Skill and Bauble Items update.sql 1.4 KB

1234567891011121314151617181920212223242526272829303132
  1. DROP TABLE IF EXISTS `raw_item_details_skills`;
  2. DROP TABLE IF EXISTS `raw_item_details_skill`;
  3. CREATE TABLE `raw_item_details_skill` (
  4. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  5. `item_id` INT(11) NOT NULL DEFAULT '0',
  6. `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  7. `tier` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  8. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
  9. PRIMARY KEY (`id`),
  10. UNIQUE KEY `ItemSpellTierIdx` (`item_id`,`spell_id`,`tier`,`language_type`)
  11. ) ENGINE=MYISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
  12. CREATE TABLE `raw_item_details_bauble` (
  13. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  14. `item_id` INT(10) NOT NULL DEFAULT '0',
  15. `cast` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '100',
  16. `recovery` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  17. `duration` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  18. `recast` FLOAT UNSIGNED NOT NULL DEFAULT '1',
  19. `display_cast_time` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  20. `display_bauble_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  21. `effect_radius` FLOAT NOT NULL DEFAULT '0',
  22. `max_aoe_targets` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  23. `display_until_cancelled` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  24. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
  25. PRIMARY KEY (`id`),
  26. UNIQUE KEY `NewIndex` (`item_id`,`language_type`)
  27. ) ENGINE=MYISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;