14 lines
746 B
SQL
14 lines
746 B
SQL
ALTER TABLE `custom_spawnlist`
|
|
MODIFY `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
MODIFY `location` varchar(40) NOT NULL DEFAULT '',
|
|
MODIFY `count` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
|
MODIFY `npc_templateid` mediumint(7) unsigned NOT NULL DEFAULT '0',
|
|
MODIFY `locx` mediumint(6) NOT NULL DEFAULT '0',
|
|
MODIFY `locy` mediumint(6) NOT NULL DEFAULT '0',
|
|
MODIFY `locz` mediumint(6) NOT NULL DEFAULT '0',
|
|
MODIFY `randomx` mediumint(6) NOT NULL DEFAULT '0',
|
|
MODIFY `randomy` mediumint(6) NOT NULL DEFAULT '0',
|
|
MODIFY `heading` mediumint(6) NOT NULL DEFAULT '0',
|
|
MODIFY `respawn_delay` mediumint(5) NOT NULL DEFAULT '0',
|
|
MODIFY `loc_id` int(9) NOT NULL DEFAULT '0',
|
|
MODIFY `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0'; |