parser_db_20130110.sql 3.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. DROP TABLE IF EXISTS `raw_item_details_marketplace`;
  2. CREATE TABLE `raw_item_details_marketplace` (
  3. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `marketplace_item_id` INT(10) NOT NULL DEFAULT '0',
  5. `item_id` INT(10) NOT NULL DEFAULT '0',
  6. `item_icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  7. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  8. PRIMARY KEY (`id`),
  9. UNIQUE KEY `NewIndex1` (`marketplace_item_id`,`item_id`,`language_type`)
  10. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  11. ALTER TABLE `raw_item_descriptions`
  12. CHANGE `flags1` `flags1` SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
  13. CHANGE `flags2` `flags2` SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
  14. CHANGE `item_type` `item_type` TINYINT (3) UNSIGNED DEFAULT '0' NOT NULL ;
  15. DROP TABLE `raw_item_details_armorset`;
  16. DROP TABLE `raw_item_sets`;
  17. DROP TABLE `raw_item_sets_effects`;
  18. DROP TABLE `raw_item_sets_stats`;
  19. DROP TABLE `raw_item_set_effects`;
  20. DROP TABLE `raw_item_set_items`;
  21. DROP TABLE `raw_item_set_stats`;
  22. ALTER TABLE `raw_items`
  23. ADD COLUMN `attuned` TINYINT (3) UNSIGNED DEFAULT '0' NOT NULL AFTER `show_name`,
  24. ADD COLUMN `stacklore` TINYINT (3) UNSIGNED DEFAULT '0' NOT NULL AFTER `evil_only`,
  25. ADD COLUMN `flags_16384` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `lore_equip`,
  26. ADD COLUMN `flags_32768` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `flags_16384`,
  27. ADD COLUMN `unlocked` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `appearance_only`,
  28. ADD COLUMN `norepair` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `unlocked`,
  29. ADD COLUMN `flags2_64` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `norepair`,
  30. ADD COLUMN `flags2_256` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `flags2_64`,
  31. ADD COLUMN `item_crc` INT(10) NOT NULL DEFAULT '0' AFTER `item_id`,
  32. CHANGE `item_id` `item_id` INT(10) DEFAULT '0' NOT NULL;
  33. ALTER TABLE `raw_item_itemset_items` ADD COLUMN `item_order` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `item_name`, ADD COLUMN `master_item_id` INT(10) DEFAULT '0' NOT NULL AFTER `item_name`;
  34. ALTER TABLE `raw_item_itemset_items` DROP KEY `SetItemIDX`, ADD UNIQUE `SetItemIDX` (`set_id`, `master_item_id`, `item_name`, `item_order`, `language_type`);
  35. ALTER TABLE `raw_item_itemset_bonus_stats` ADD COLUMN `master_item_id` INT(10) DEFAULT '0' NOT NULL AFTER `set_id`;
  36. ALTER TABLE `raw_item_itemset_bonus_stats` DROP KEY `SetStatsIDX`, ADD UNIQUE `SetStatsIDX` (`set_id`, `master_item_id`, `items_needed`, `type`, `subtype`, `value`, `value2`, `stats_order`, `language_type`, `name`);
  37. ALTER TABLE `raw_item_itemset_bonus_effects` ADD COLUMN `master_item_id` INT(10) DEFAULT '0' NOT NULL AFTER `set_id`;
  38. ALTER TABLE `raw_item_itemset_bonus_effects` DROP KEY `SetEffectsIDX`, ADD UNIQUE `SetEffectsIDX` (`set_id`, `master_item_id`, `items_needed`, `subbulletflag`, `description`, `language_type`);
  39. ALTER TABLE `raw_item_stats` DROP COLUMN `value2`, CHANGE `value` `value` FLOAT DEFAULT '0' NOT NULL;
  40. ALTER TABLE `raw_item_itemset_bonus_stats` DROP COLUMN `value2`, CHANGE `value` `value` FLOAT DEFAULT '0' NOT NULL;
  41. ALTER TABLE `raw_items`
  42. ADD COLUMN `adornment_slot1` TINYINT (3) UNSIGNED DEFAULT '255' NOT NULL AFTER `collectable`,
  43. ADD COLUMN `adornment_slot2` TINYINT (3) UNSIGNED DEFAULT '255' NOT NULL AFTER `adornment_slot1`,
  44. ADD COLUMN `adornment_slot3` TINYINT (3) UNSIGNED DEFAULT '255' NOT NULL AFTER `adornment_slot2`,
  45. ADD COLUMN `adornment_slot4` TINYINT (3) UNSIGNED DEFAULT '255' NOT NULL AFTER `adornment_slot3`,
  46. ADD COLUMN `adornment_slot5` TINYINT (3) UNSIGNED DEFAULT '255' NOT NULL AFTER `adornment_slot4`,
  47. ADD COLUMN `adornment_slot6` TINYINT (3) UNSIGNED DEFAULT '255' NOT NULL AFTER `adornment_slot5`;