custom_npc_elementals.sql 918 B

12345678910111213141516171819202122232425
  1. CREATE TABLE IF NOT EXISTS `custom_npc_elementals` (
  2. `npc_id` mediumint(7) unsigned NOT NULL,
  3. `elemAtkType` tinyint(1) NOT NULL default '-1',
  4. `elemAtkValue` int(3) NOT NULL default '0',
  5. `fireDefValue` int(3) NOT NULL default '0',
  6. `waterDefValue` int(3) NOT NULL default '0',
  7. `windDefValue` int(3) NOT NULL default '0',
  8. `earthDefValue` int(3) NOT NULL default '0',
  9. `holyDefValue` int(3) NOT NULL default '0',
  10. `darkDefValue` int(3) NOT NULL default '0',
  11. PRIMARY KEY (`npc_id`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  13. INSERT IGNORE INTO `custom_npc_elementals` VALUES
  14. (50007,0,0,20,20,20,20,20,20),
  15. (70010,0,0,20,20,20,20,20,20),
  16. (1000003,0,0,20,20,20,20,20,20),
  17. -- eventmod Elpies
  18. (900100,0,0,20,20,20,20,20,20),
  19. -- eventmod Rabbits
  20. (900101,0,0,20,20,20,20,20,20),
  21. (900102,0,0,20,20,20,20,20,20),
  22. -- eventmod Race
  23. (900103,0,0,20,20,20,20,20,20),
  24. (900104,0,0,20,20,20,20,20,20);