EQ2ParserDB SQL Updates_v0.1.1.txt 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. ALTER TABLE raw_item_effects CHANGE column `name` `effect` VARCHAR(512) NOT NULL DEFAULT 'Unknown' AFTER `item_id`;
  2. ALTER TABLE raw_item_effects DROP COLUMN `description`;
  3. ALTER TABLE parser_stats ADD COLUMN `total_skills` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `new_books`;
  4. ALTER TABLE parser_stats ADD COLUMN `unique_skills` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `total_skills`;
  5. ALTER TABLE parser_stats ADD COLUMN `new_skills` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `unique_skills`;
  6. CREATE TABLE IF NOT EXISTS `raw_traits` (
  7. `id` int(10) unsigned NOT NULL auto_increment,
  8. `level` tinyint(3) unsigned NOT NULL default '0',
  9. `selection` tinyint(3) unsigned NOT NULL default '0',
  10. `icon_0` smallint(5) unsigned NOT NULL default '0',
  11. `icon2_0` smallint(5) unsigned NOT NULL default '0',
  12. `trait_id_0` int(10) unsigned NOT NULL default '0',
  13. `unknown_0` int(10) unsigned NOT NULL default '0',
  14. `name_0` varchar(250) collate latin1_general_ci default NULL,
  15. `icon_1` smallint(5) unsigned NOT NULL default '0',
  16. `icon2_1` smallint(5) unsigned NOT NULL default '0',
  17. `trait_id_1` int(10) unsigned NOT NULL default '0',
  18. `unknown_1` int(10) unsigned NOT NULL default '0',
  19. `name_1` varchar(250) collate latin1_general_ci default '',
  20. `icon_2` smallint(5) unsigned NOT NULL default '0',
  21. `icon2_2` smallint(5) unsigned NOT NULL default '0',
  22. `trait_id_2` int(10) unsigned NOT NULL default '0',
  23. `unknown_2` int(10) unsigned NOT NULL default '0',
  24. `name_2` varchar(250) collate latin1_general_ci default '',
  25. `icon_3` smallint(5) unsigned NOT NULL default '0',
  26. `icon2_3` smallint(5) unsigned NOT NULL default '0',
  27. `trait_id_3` int(10) unsigned NOT NULL default '0',
  28. `unknown_3` int(10) unsigned NOT NULL default '0',
  29. `name_3` varchar(250) collate latin1_general_ci default '',
  30. `icon_4` smallint(5) unsigned NOT NULL default '0',
  31. `icon2_4` smallint(5) unsigned NOT NULL default '0',
  32. `trait_id_4` int(10) unsigned NOT NULL default '0',
  33. `unknown_4` int(10) unsigned NOT NULL default '0',
  34. `name_4` varchar(250) collate latin1_general_ci default '',
  35. `data_version` smallint(5) unsigned NOT NULL,
  36. `language_type` tinyint(3) unsigned NOT NULL default '0',
  37. `log_file` varchar(250) collate latin1_general_ci default '',
  38. PRIMARY KEY (`id`),
  39. UNIQUE KEY `NewIndex1` (`trait_id_0`,`trait_id_1`,`trait_id_2`,`trait_id_3`,`trait_id_4`)
  40. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ROW_FORMAT=DYNAMIC;
  41. CREATE TABLE IF NOT EXISTS `raw_skills` (
  42. `id` int(10) unsigned NOT NULL auto_increment,
  43. `skill_id` int(10) unsigned NOT NULL default '0',
  44. `short_name` varchar(32) default 'Unknown',
  45. `name` varchar(255) default 'Unknown',
  46. `description` varchar(255) default 'Unknown',
  47. `data_version` smallint(5) NOT NULL default '0',
  48. `log_file` varchar(250) NOT NULL,
  49. PRIMARY KEY (`id`)
  50. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  51. CREATE TABLE IF NOT EXISTS `raw_skills_current` (
  52. `id` int(10) unsigned NOT NULL auto_increment,
  53. `skill_id` int(10) unsigned NOT NULL default '0',
  54. `type` smallint(5) unsigned NOT NULL default '0',
  55. `current_val` mediumint(7) unsigned NOT NULL default '0',
  56. `base_val` mediumint(7) unsigned NOT NULL default '0',
  57. `max_val` mediumint(7) unsigned NOT NULL default '0',
  58. `skill_delta` mediumint(7) NOT NULL default '0',
  59. `skill_delta2` mediumint(7) NOT NULL default '0',
  60. `display_min` tinyint(3) unsigned NOT NULL default '0',
  61. `display_max` tinyint(3) unsigned NOT NULL default '0',
  62. `unknown` tinyint(3) unsigned NOT NULL default '0',
  63. `data_version` smallint(5) unsigned NOT NULL default '0',
  64. `log_file` varchar(250) NOT NULL,
  65. PRIMARY KEY (`id`)
  66. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;