Pattern Item Type update.sql 1.3 KB

12345678910111213141516171819202122232425262728
  1. ALTER TABLE `raw_items` CHANGE `item_type` `item_type` ENUM('Normal','Armor','Food','Bag','Weapon','Ranged','Shield','Spell','Recipe','Book','House','Thrown','Bauble','House Container','Adornment','Pattern','Armor Set') DEFAULT 'Normal' NOT NULL;
  2. CREATE TABLE `raw_item_details_armorset` (
  3. `id` int(10) unsigned NOT NULL auto_increment,
  4. `armorset_item_id` int(11) NOT NULL default '0',
  5. `item_id` int(11) NOT NULL default '0',
  6. `item_crc` int(11) NOT NULL default '0',
  7. `item_name` varchar(255) NOT NULL default 'N/A',
  8. `item_icon` smallint(5) unsigned NOT NULL default '0',
  9. `unknown_piece` int(10) unsigned NOT NULL default '0',
  10. `language_type` tinyint(3) unsigned NOT NULL default '1',
  11. PRIMARY KEY (`id`),
  12. UNIQUE KEY `UnqArmorSetIdx` (`item_id`,`armorset_item_id`)
  13. ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
  14. CREATE TABLE `raw_item_details_pattern` (
  15. `id` int(10) unsigned NOT NULL auto_increment,
  16. `pattern_item_id` int(11) NOT NULL default '0',
  17. `item_id` int(11) NOT NULL default '0',
  18. `item_crc` int(11) NOT NULL default '0',
  19. `item_name` varchar(255) NOT NULL default 'N/A',
  20. `item_icon` smallint(5) unsigned NOT NULL default '0',
  21. `language_type` tinyint(3) unsigned NOT NULL default '1',
  22. PRIMARY KEY (`id`),
  23. UNIQUE KEY `UnqPatternIDX` (`pattern_item_id`,`item_id`)
  24. ) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;