eq2_rawdata_aa_tables.sql 3.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. CREATE TABLE `raw_aa_class` (
  2. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3. `unknown6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  4. `unknown7` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  5. `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  6. `unknown10` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
  7. `name` VARCHAR(250) DEFAULT NULL,
  8. `description` VARCHAR(250) DEFAULT NULL,
  9. `icon` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  10. `icon2` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  11. `current_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  12. `max_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  13. `rank_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  14. `unknown11` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  15. `class_name` VARCHAR(50) DEFAULT NULL,
  16. `points_req` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  17. `subclass_name` VARCHAR(50) DEFAULT NULL,
  18. `icon_col` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  19. `icon_row` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  20. `line_title` VARCHAR(50) DEFAULT NULL,
  21. `unknown20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  22. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  23. `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  24. PRIMARY KEY (`id`),
  25. UNIQUE KEY `SpellIDX` (`spell_id`)
  26. ) ENGINE=MYISAM;
  27. CREATE TABLE `raw_aa_subclass` (
  28. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  29. `unknown6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  30. `unknown7` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  31. `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  32. `unknown10` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
  33. `name` VARCHAR(250) DEFAULT NULL,
  34. `description` VARCHAR(250) DEFAULT NULL,
  35. `icon` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  36. `icon2` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  37. `current_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  38. `max_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  39. `rank_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  40. `unknown11` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  41. `class_name` VARCHAR(50) DEFAULT NULL,
  42. `points_req` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  43. `subclass_name` VARCHAR(50) DEFAULT NULL,
  44. `icon_col` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  45. `icon_row` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  46. `line_title` VARCHAR(50) DEFAULT NULL,
  47. `unknown20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  48. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  49. `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  50. PRIMARY KEY (`id`),
  51. UNIQUE KEY `SpellIDX` (`spell_id`)
  52. ) ENGINE=MYISAM;
  53. CREATE TABLE `raw_aa_tso` (
  54. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  55. `unknown6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  56. `unknown7` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  57. `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  58. `unknown10` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
  59. `name` VARCHAR(250) DEFAULT NULL,
  60. `description` VARCHAR(250) DEFAULT NULL,
  61. `icon` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  62. `icon2` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  63. `current_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  64. `max_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  65. `rank_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  66. `unknown11` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  67. `class_name` VARCHAR(50) DEFAULT NULL,
  68. `points_req` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  69. `subclass_name` VARCHAR(50) DEFAULT NULL,
  70. `icon_col` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  71. `icon_row` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  72. `line_title` VARCHAR(50) DEFAULT NULL,
  73. `unknown20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  74. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  75. `log_file` VARCHAR(250) NOT NULL DEFAULT '',
  76. PRIMARY KEY (`id`),
  77. UNIQUE KEY `SpellIDX` (`spell_id`)
  78. ) ENGINE=MYISAM;