Parser Item and Quest DB Changes.sql 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102
  1. ALTER TABLE `raw_item_stats` CHANGE `text` `text` VARCHAR(250) DEFAULT ' ' NOT NULL;
  2. ALTER TABLE `raw_item_details_weapon` CHANGE `damage_low1` `damage_low1` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  3. ALTER TABLE `raw_item_details_weapon` CHANGE `damage_low2` `damage_low2` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  4. ALTER TABLE `raw_item_details_weapon` CHANGE `damage_low3` `damage_low3` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  5. ALTER TABLE `raw_item_details_weapon` CHANGE `damage_high1` `damage_high1` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  6. ALTER TABLE `raw_item_details_weapon` CHANGE `damage_high2` `damage_high2` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  7. ALTER TABLE `raw_item_details_weapon` CHANGE `damage_high3` `damage_high3` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  8. ALTER TABLE `raw_item_details_weapon` CHANGE `delay` `delay` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  9. ALTER TABLE `raw_item_details_range` CHANGE `damage_low1` `damage_low1` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  10. ALTER TABLE `raw_item_details_range` CHANGE `damage_low2` `damage_low2` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  11. ALTER TABLE `raw_item_details_range` CHANGE `damage_low3` `damage_low3` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  12. ALTER TABLE `raw_item_details_range` CHANGE `damage_high1` `damage_high1` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  13. ALTER TABLE `raw_item_details_range` CHANGE `damage_high2` `damage_high2` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  14. ALTER TABLE `raw_item_details_range` CHANGE `damage_high3` `damage_high3` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  15. ALTER TABLE `raw_item_details_range` CHANGE `delay` `delay` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  16. ALTER TABLE `raw_item_details_range` CHANGE `range_low` `range_low` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  17. ALTER TABLE `raw_item_details_range` CHANGE `range_high` `range_high` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  18. ALTER TABLE `raw_item_details_shield` CHANGE `mitigation_high` `mitigation_high` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  19. ALTER TABLE `raw_item_details_shield` CHANGE `mitigation_low` `mitigation_low` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  20. ALTER TABLE `raw_item_details_armor` CHANGE `mitigation_high` `mitigation_high` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  21. ALTER TABLE `raw_item_details_armor` CHANGE `mitigation_low` `mitigation_low` SMALLINT UNSIGNED DEFAULT '0' NOT NULL;
  22. ALTER TABLE `raw_spell_levels` CHANGE `class_id` `adventure_class_id` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
  23. ALTER TABLE `raw_spell_levels` ADD `tradeskill_class_id` TINYINT UNSIGNED DEFAULT '0' NOT NULL AFTER `adventure_class_id`;
  24. ALTER TABLE `raw_spell_levels` DROP PRIMARY KEY, ADD PRIMARY KEY (`spell_id`, `tier`, `adventure_class_id`, `tradeskill_class_id`);
  25. ALTER TABLE `raw_item_skill_classes` CHANGE `class_id` `adventure_class_id` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
  26. ALTER TABLE `raw_item_skill_classes` ADD `tradeskill_class_id` TINYINT UNSIGNED DEFAULT '0' NOT NULL AFTER `adventure_class_id`;
  27. ALTER TABLE `raw_item_skill_classes` DROP INDEX `NewIndex`, ADD UNIQUE `NewIndex` (`item_id`, `adventure_class_id`, `language_type`, `tradeskill_class_id`);
  28. ALTER TABLE `raw_item_classes` ADD `tradeskill_class_id` TINYINT UNSIGNED DEFAULT '0' NOT NULL AFTER `class_id`;
  29. ALTER TABLE `raw_item_classes` CHANGE `class_id` `adventure_class_id` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
  30. ALTER TABLE `raw_item_classes` DROP INDEX `NewIndex`, ADD UNIQUE `NewIndex` (`adventure_class_id`, `item_id`, `language_type`, `tradeskill_class_id`);
  31. ALTER TABLE `raw_item_details_range` CHANGE `unknown12` `damage_type` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL;
  32. ALTER TABLE `raw_items` CHANGE `description` `description` VARCHAR(1024) NOT NULL;
  33. CREATE TABLE `raw_quest_reward_factions` (
  34. `id` int(10) unsigned NOT NULL auto_increment,
  35. `quest_id` int(10) unsigned NOT NULL default '0',
  36. `faction_name` varchar(64) NOT NULL,
  37. `amount` int(10) unsigned NOT NULL default '0',
  38. PRIMARY KEY (`id`),
  39. UNIQUE KEY `FactionQuestIDX` (`quest_id`,`faction_name`)
  40. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  41. CREATE TABLE `raw_quest_reward_items` (
  42. `id` int(10) unsigned NOT NULL auto_increment,
  43. `quest_id` int(10) unsigned NOT NULL default '0',
  44. `item_id` int(10) unsigned NOT NULL default '0',
  45. PRIMARY KEY (`id`),
  46. UNIQUE KEY `ItemQuestIDX` (`item_id`,`quest_id`)
  47. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  48. CREATE TABLE `raw_quest_taskgroup_tasks` (
  49. `id` int(10) unsigned NOT NULL auto_increment,
  50. `taskgroup_id` int(10) unsigned NOT NULL default '0',
  51. `task` text NOT NULL,
  52. PRIMARY KEY (`id`),
  53. UNIQUE KEY `TaskGroupTaskIDX` (`task`(200),`taskgroup_id`)
  54. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
  55. CREATE TABLE `raw_quest_taskgroup_taskupdates` (
  56. `id` int(10) unsigned NOT NULL auto_increment,
  57. `taskgroup_id` int(10) unsigned NOT NULL default '0',
  58. `icon` smallint(5) unsigned NOT NULL default '0',
  59. `update_target_name` varchar(64) NOT NULL,
  60. PRIMARY KEY (`id`),
  61. UNIQUE KEY `TaskGroupUpdateIDX` (`taskgroup_id`,`update_target_name`)
  62. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  63. CREATE TABLE `raw_quest_taskgroups` (
  64. `id` int(10) unsigned NOT NULL auto_increment,
  65. `quest_id` int(10) unsigned NOT NULL default '0',
  66. `task_group` text NOT NULL,
  67. PRIMARY KEY (`id`),
  68. UNIQUE KEY `QuestTaskIDX` (`quest_id`,`task_group`(200))
  69. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  70. CREATE TABLE `raw_quests` (
  71. `id` int(11) unsigned NOT NULL default '0',
  72. `name` varchar(255) NOT NULL,
  73. `description` text NOT NULL,
  74. `type` varchar(255) NOT NULL,
  75. `zone` varchar(255) NOT NULL,
  76. `unknown1` tinyint(3) unsigned NOT NULL default '0',
  77. `repeatable` tinyint(3) unsigned NOT NULL default '0',
  78. `unknown2` tinyint(3) unsigned NOT NULL default '0',
  79. `day` tinyint(3) unsigned NOT NULL default '0',
  80. `month` tinyint(3) unsigned NOT NULL default '0',
  81. `year` tinyint(3) unsigned NOT NULL default '0',
  82. `level` tinyint(3) unsigned NOT NULL default '0',
  83. `encounter_level` tinyint(3) unsigned NOT NULL default '0',
  84. `difficulty` tinyint(3) unsigned NOT NULL default '0',
  85. `visible` tinyint(3) unsigned NOT NULL default '0',
  86. `max_coin` int(10) unsigned NOT NULL default '0',
  87. `min_coin` int(10) unsigned NOT NULL default '0',
  88. `status_points` int(10) unsigned NOT NULL default '0',
  89. `text` varchar(50) NOT NULL,
  90. `exp_bonus` int(10) unsigned NOT NULL default '0',
  91. PRIMARY KEY (`id`)
  92. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;