mirror of
https://github.com/araxiaonline/AscEmu.git
synced 2026-06-13 03:02:22 -04:00
dcecceacbc
Add default value to spell_type. Remove "NOT NULL" from comments (I guess comments are just for mysql devs, so it can be NULL
30 lines
1.4 KiB
SQL
30 lines
1.4 KiB
SQL
-- ----------------------------
|
|
-- Table structure for `creature_ai_scripts`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `creature_ai_scripts`;
|
|
CREATE TABLE `creature_ai_scripts` (
|
|
`min_build` int NOT NULL DEFAULT '12340',
|
|
`max_build` int NOT NULL DEFAULT '12340',
|
|
`entry` int unsigned NOT NULL,
|
|
`difficulty` tinyint unsigned NOT NULL DEFAULT '0',
|
|
`phase` tinyint unsigned NOT NULL DEFAULT '0',
|
|
`event` tinyint unsigned NOT NULL DEFAULT '0',
|
|
`action` tinyint unsigned NOT NULL DEFAULT '0',
|
|
`maxCount` tinyint unsigned NOT NULL DEFAULT '0',
|
|
`chance` float unsigned NOT NULL DEFAULT '1',
|
|
`spell` int unsigned NOT NULL DEFAULT '0',
|
|
`spell_type` int NOT NULL DEFAULT '0',
|
|
`triggered` tinyint(1) NOT NULL DEFAULT '0',
|
|
`target` tinyint NOT NULL DEFAULT '0',
|
|
`cooldownMin` int NOT NULL DEFAULT '0',
|
|
`cooldownMax` int unsigned NOT NULL DEFAULT '0',
|
|
`minHealth` float NOT NULL DEFAULT '0',
|
|
`maxHealth` float NOT NULL DEFAULT '100',
|
|
`textId` int unsigned NOT NULL DEFAULT '0',
|
|
`misc1` int NOT NULL DEFAULT '0',
|
|
`comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
|
UNIQUE KEY `entry` (`min_build`,`max_build`,`entry`,`difficulty`,`phase`,`spell`,`event`,`action`) USING BTREE
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI System';
|
|
|
|
REPLACE INTO `world_db_version` VALUES ('85', '20210814-01_creature_ai_scripts');
|