9
3

Parser DB Updates.sql 3.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. DROP TABLE IF EXISTS `raw_abilities`;
  2. CREATE TABLE `raw_abilities` (
  3. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `ability_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  5. `icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  6. `icon2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  7. `unknown` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  8. `name` VARCHAR(250) DEFAULT '',
  9. `data_version` SMALLINT(5) UNSIGNED NOT NULL,
  10. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  11. `log_file` VARCHAR(250) DEFAULT '',
  12. PRIMARY KEY (`id`),
  13. UNIQUE KEY (`ability_id`)
  14. ) ENGINE=MYISAM;
  15. DROP TABLE IF EXISTS `raw_locations`;
  16. CREATE TABLE `raw_locations` (
  17. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  18. `poi_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  19. `soe_zone_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  20. `unknown` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  21. `poi_name` VARCHAR(250) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  22. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  23. `log_file` VARCHAR(250) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  24. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  25. PRIMARY KEY (`id`),
  26. UNIQUE KEY `LocationIDX` (`poi_id`,`soe_zone_id`)
  27. ) ENGINE=MYISAM;
  28. DROP TABLE IF EXISTS `raw_traditions`;
  29. CREATE TABLE `raw_traditions` (
  30. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  31. `tradition_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  32. `selection` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  33. `icon` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  34. `icon2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  35. `unknown` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  36. `name` VARCHAR(250) DEFAULT '',
  37. `data_version` SMALLINT(5) UNSIGNED NOT NULL,
  38. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  39. `log_file` VARCHAR(250) DEFAULT '',
  40. PRIMARY KEY (`id`),
  41. UNIQUE KEY (`tradition_id`)
  42. ) ENGINE=MYISAM;
  43. DROP TABLE IF EXISTS `raw_trainings`;
  44. CREATE TABLE `raw_trainings` (
  45. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  46. `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  47. `spell_line` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  48. `icon_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  49. `icon2_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  50. `training_id_0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  51. `unknown_0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  52. `name_0` VARCHAR(250) DEFAULT NULL,
  53. `icon_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  54. `icon2_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  55. `training_id_1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  56. `unknown_1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  57. `name_1` VARCHAR(250) DEFAULT '',
  58. `icon_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  59. `icon2_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  60. `training_id_2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  61. `unknown_2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  62. `name_2` VARCHAR(250) DEFAULT '',
  63. `icon_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  64. `icon2_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  65. `training_id_3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  66. `unknown_3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  67. `name_3` VARCHAR(250) DEFAULT '',
  68. `icon_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  69. `icon2_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  70. `training_id_4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  71. `unknown_4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  72. `name_4` VARCHAR(250) DEFAULT '',
  73. `data_version` SMALLINT(5) UNSIGNED NOT NULL,
  74. `language_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  75. `log_file` VARCHAR(250) DEFAULT '',
  76. PRIMARY KEY (`id`),
  77. UNIQUE KEY `TrainingIDX` (`training_id_0`, `training_id_1`, `training_id_2`, `training_id_3`, `training_id_4`)
  78. ) ENGINE=MYISAM;