9
3

raw_spells, raw_items and raw_collections update.sql 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. TRUNCATE `raw_item_appearances`;
  2. TRUNCATE `raw_item_classes`;
  3. TRUNCATE `raw_item_descriptions`;
  4. TRUNCATE `raw_item_details_armor`;
  5. TRUNCATE `raw_item_details_armorset`;
  6. TRUNCATE `raw_item_details_bag`;
  7. TRUNCATE `raw_item_details_bauble`;
  8. TRUNCATE `raw_item_details_book`;
  9. TRUNCATE `raw_item_details_food`;
  10. TRUNCATE `raw_item_details_house`;
  11. TRUNCATE `raw_item_details_house_container`;
  12. TRUNCATE `raw_item_details_pattern`;
  13. TRUNCATE `raw_item_details_range`;
  14. TRUNCATE `raw_item_details_recipe`;
  15. TRUNCATE `raw_item_details_recipe_items`;
  16. TRUNCATE `raw_item_details_shield`;
  17. TRUNCATE `raw_item_details_skills`;
  18. TRUNCATE `raw_item_details_thrown`;
  19. TRUNCATE `raw_item_details_weapon`;
  20. TRUNCATE `raw_item_effects`;
  21. TRUNCATE `raw_item_sets`;
  22. TRUNCATE `raw_item_sets_effects`;
  23. TRUNCATE `raw_item_sets_stats`;
  24. TRUNCATE `raw_item_skill_classes`;
  25. TRUNCATE `raw_item_stats`;
  26. TRUNCATE `raw_items`;
  27. ALTER TABLE `raw_items` ADD `item_id` INT DEFAULT '0' NOT NULL AFTER `id`;
  28. ALTER TABLE `raw_items` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL;
  29. ALTER TABLE `raw_items` DROP PRIMARY KEY;
  30. ALTER TABLE `raw_items` ADD PRIMARY KEY (`id`);
  31. ALTER TABLE `raw_items` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  32. ALTER TABLE `raw_items` AUTO_INCREMENT = 1;
  33. ALTER TABLE `raw_items` ADD UNIQUE `ItemIDLanguageTypeIDX` (`item_id`, `language_type`);
  34. ALTER TABLE `raw_items` CHANGE `menu_type` `menu_type` SMALLINT UNSIGNED DEFAULT '3' NOT NULL;
  35. ALTER TABLE `raw_items` DROP `sub_type`;
  36. TRUNCATE `raw_spell_details`;
  37. TRUNCATE `raw_spell_effects`;
  38. TRUNCATE `raw_spell_levels`;
  39. TRUNCATE `raw_spells`;
  40. ALTER TABLE `raw_spells` ADD `spell_id` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `id`;
  41. ALTER TABLE `raw_spells` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL;
  42. ALTER TABLE `raw_spells` DROP PRIMARY KEY;
  43. ALTER TABLE `raw_spells` ADD PRIMARY KEY (`id`);
  44. ALTER TABLE `raw_spells` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  45. ALTER TABLE `raw_spells` AUTO_INCREMENT = 1;
  46. ALTER TABLE `raw_spells` ADD UNIQUE `SpellLanguageTypeIDX` (`spell_id`, `tier`, `language_type`);
  47. DELETE FROM `raw_collections`;
  48. ALTER TABLE `raw_collections` ADD `id` INT UNSIGNED DEFAULT '0' NOT NULL FIRST;
  49. ALTER TABLE `raw_collections` ADD PRIMARY KEY (`id`);
  50. ALTER TABLE `raw_collections` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  51. ALTER TABLE `raw_items` ADD `data_version` SMALLINT(5) UNSIGNED NOT NULL AFTER `log_file`;
  52. ALTER TABLE `raw_spells` ADD `data_version` SMALLINT(5) UNSIGNED NOT NULL AFTER `log_file`;
  53. ALTER TABLE `raw_quests` ADD `data_version` SMALLINT(5) UNSIGNED NOT NULL AFTER `log_file`;
  54. ALTER TABLE `raw_spawns` ADD `data_version` SMALLINT(5) UNSIGNED NOT NULL AFTER `log_file`;
  55. ALTER TABLE `raw_items` ADD COLUMN `populate_item_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL AFTER `processed`;