· 9 years ago · Oct 04, 2016, 10:02 PM
1DROP TABLE IF EXISTS `mob_spell_lists`;
2
3CREATE TABLE `mob_spell_lists`
4(
5 `spell_list_name` char(20) DEFAULT NULL,
6 `spell_list_id` smallint(5) unsigned NOT NULL,
7 `spell_id` smallint(3) unsigned NOT NULL,
8 `min_level` tinyint(3) unsigned NOT NULL,
9 `max_level` tinyint(3) unsigned NOT NULL,
10 PRIMARY KEY (`spell_list_id`,`spell_id`)
11) ENGINE=MyISAM DEFAULT CHARSET=utf8;
12
13
14--
15-- Dumping data for table `mob_spell_lists`
16--
17
18LOCK TABLES `mob_spell_lists` WRITE;
19
20INSERT INTO `mob_spell_lists` VALUES ('Beastmen_WHM',1,1,1,10);
21INSERT INTO `mob_spell_lists` VALUES ('Beastmen_WHM',1,2,11,20);
22INSERT INTO `mob_spell_lists` VALUES ('Beastmen_WHM',1,3,21,40);
23INSERT INTO `mob_spell_lists` VALUES ('Beastmen_WHM',1,4,41,60);