9
3

raw_adventure_list.sql 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. ALTER TABLE `parser_stats`
  2. DROP COLUMN `total_aa_subclass`,
  3. DROP COLUMN `new_aa_tso`,
  4. DROP COLUMN `unique_aa_tso`,
  5. DROP COLUMN `total_aa_tso`,
  6. DROP COLUMN `new_aa_subclass`,
  7. DROP COLUMN `unique_aa_subclass`,
  8. CHANGE `total_aa_class` `total_aa` SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
  9. CHANGE `unique_aa_class` `unique_aa` SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
  10. CHANGE `new_aa_class` `new_aa` SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL ;
  11. DROP TABLE IF EXISTS `raw_aa_class`;
  12. DROP TABLE IF EXISTS `raw_aa_subclass`;
  13. DROP TABLE IF EXISTS `raw_aa_tso`;
  14. CREATE TABLE `raw_adventure_list` (
  15. `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  16. `unknown6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  17. `unknown7` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  18. `spell_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  19. `unknown10` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
  20. `name` VARCHAR(250) COLLATE latin1_general_ci DEFAULT NULL,
  21. `description` VARCHAR(250) COLLATE latin1_general_ci DEFAULT NULL,
  22. `icon` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  23. `icon2` MEDIUMINT(5) UNSIGNED NOT NULL DEFAULT '0',
  24. `current_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  25. `max_rank` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  26. `rank_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  27. `unknown11` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  28. `class_name` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
  29. `points_req` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  30. `subclass_name` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
  31. `icon_col` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  32. `icon_row` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  33. `line_title` VARCHAR(50) COLLATE latin1_general_ci DEFAULT NULL,
  34. `unknown20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  35. `global_req` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  36. `aa_type` VARCHAR(32) COLLATE latin1_general_ci DEFAULT NULL,
  37. `data_version` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  38. `log_file` VARCHAR(250) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  39. PRIMARY KEY (`id`),
  40. UNIQUE KEY `AdventureListIDX` (`spell_id`)
  41. ) ENGINE=MYISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;