9
3

raw_item_itemsets.sql 3.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. -- Item Type 16 - Profile Items
  2. 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','Profile') CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT 'Normal' NOT NULL;
  3. DROP TABLE IF EXISTS `raw_item_itemsets`;
  4. CREATE TABLE `raw_item_itemsets` (
  5. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  6. `set_name` VARCHAR(250) COLLATE latin1_general_ci NOT NULL DEFAULT 'Unknown',
  7. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
  8. PRIMARY KEY (`id`),
  9. UNIQUE KEY `ItemSetIDX` (`set_name`, `language_type`)
  10. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  11. DROP TABLE IF EXISTS `raw_item_itemset_items`;
  12. CREATE TABLE `raw_item_itemset_items` (
  13. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  14. `set_id` INT(10) NOT NULL DEFAULT '0',
  15. `unknown1` TINYINT(3) NOT NULL DEFAULT '0',
  16. `unknown2` TINYINT(3) NOT NULL DEFAULT '0',
  17. `item_name` VARCHAR(250) COLLATE latin1_general_ci NOT NULL DEFAULT 'Unknown',
  18. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
  19. PRIMARY KEY (`id`),
  20. UNIQUE KEY `SetItemIDX` (`set_id`, `item_name`, `language_type`)
  21. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  22. DROP TABLE IF EXISTS `raw_item_itemset_bonus_stats`;
  23. CREATE TABLE `raw_item_itemset_bonus_stats` (
  24. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  25. `set_id` INT(10) NOT NULL DEFAULT '0',
  26. `items_needed` TINYINT(3) NOT NULL DEFAULT '0',
  27. `type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  28. `subtype` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  29. `value` SMALLINT(5) NOT NULL DEFAULT '0',
  30. `value2` FLOAT DEFAULT '0',
  31. `name` VARCHAR(512) COLLATE latin1_general_ci DEFAULT '',
  32. `unknown` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  33. `stats_order` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  34. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
  35. PRIMARY KEY (`id`),
  36. UNIQUE KEY `SetStatsIDX` (`set_id`,`items_needed`,`type`,`subtype`,`value`,`value2`,`stats_order`,`language_type`)
  37. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  38. DROP TABLE IF EXISTS `raw_item_itemset_bonus_effects`;
  39. CREATE TABLE `raw_item_itemset_bonus_effects` (
  40. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  41. `set_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  42. `items_needed` TINYINT(3) NOT NULL DEFAULT '0',
  43. `subbulletflag` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  44. `description` VARCHAR(512) COLLATE latin1_general_ci DEFAULT '',
  45. `percentage` TINYINT(3) UNSIGNED NOT NULL DEFAULT '100',
  46. `effect_order` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  47. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1',
  48. PRIMARY KEY (`id`),
  49. UNIQUE KEY `SetEffectsIDX` (`set_id`, `description`, `effect_order`, `language_type`)
  50. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  51. ALTER TABLE `raw_item_itemsets` ADD COLUMN `data_version` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `language_type`, ADD COLUMN `log_file` VARCHAR(250) DEFAULT '' NOT NULL AFTER `data_version`;