parser_db_20130102.sql 1.7 KB

12345678910111213141516171819202122232425262728
  1. ALTER TABLE `raw_item_descriptions` DROP KEY `NewIndex`, ADD UNIQUE `NewIndex` (`language_type`, `item_id`);
  2. ALTER TABLE `raw_item_descriptions` ADD COLUMN `item_crc` INT(10) DEFAULT '0' NOT NULL AFTER `item_id`, CHANGE `item_id` `item_id` INT(10) DEFAULT '0' NOT NULL;
  3. -- adding item type 20, 21, and 22
  4. ALTER TABLE `raw_items` CHANGE `item_type` `item_type` ENUM('Normal','Armor','Food','Bag','Weapon','Ranged','Shield','Spell Scroll','Recipe','Book','House','Thrown','Bauble','House Container','Adornment','Pattern Set','Armor Set','Item Set','Decoration','Marketplace','Dungeon Maker') CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT 'Normal' NOT NULL;
  5. ALTER TABLE `raw_item_appearances` CHANGE `item_crc` `item_crc` INT(10) DEFAULT '0' NOT NULL;
  6. CREATE TABLE `raw_item_details_marketplace_rewards` (
  7. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  8. `item_id` INT(10) NOT NULL DEFAULT '0',
  9. `reward_item_id` INT(10) NOT NULL DEFAULT '0',
  10. `reward_item_crc` INT(10) NOT NULL DEFAULT '0',
  11. `reward_item_icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  12. `reward_item_name` VARCHAR(250) COLLATE latin1_general_ci DEFAULT '',
  13. `language_type` TINYINT(3) NOT NULL DEFAULT '0',
  14. PRIMARY KEY (`id`),
  15. UNIQUE KEY `NewIndex1` (`item_id`,`reward_item_id`,`language_type`)
  16. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  17. CREATE TABLE `raw_item_details_decorations` (
  18. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  19. `item_id` INT(11) NOT NULL DEFAULT '0',
  20. `decoration_name` VARCHAR(64) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  21. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
  22. PRIMARY KEY (`id`),
  23. UNIQUE KEY `NewIndex` (`item_id`,`language_type`)
  24. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;