9
3

raw_arenas.sql 3.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. DROP TABLE IF EXISTS `raw_arena_levels`;
  2. CREATE TABLE `raw_arena_levels` (
  3. `id` INT (10) UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `level_name` VARCHAR (32) NOT NULL DEFAULT '',
  5. `level_value` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  6. `data_version` SMALLINT (5) UNSIGNED NOT NULL DEFAULT '0',
  7. `log_file` VARCHAR (250) NOT NULL DEFAULT '',
  8. UNIQUE `ArenaLevelIDX` (`level_name`, `level_value`),
  9. PRIMARY KEY (`id`)
  10. ) ENGINE = 'Default' COMMENT = '' ROW_FORMAT = DEFAULT ;
  11. DROP TABLE IF EXISTS `raw_arena_timers`;
  12. CREATE TABLE `raw_arena_timers` (
  13. `id` INT (10) UNSIGNED NOT NULL AUTO_INCREMENT,
  14. `time_type` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  15. `time_name` VARCHAR (32) NOT NULL DEFAULT '',
  16. `time_value` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  17. `data_version` SMALLINT (5) UNSIGNED NOT NULL DEFAULT '0',
  18. `log_file` VARCHAR (250) NOT NULL DEFAULT '',
  19. UNIQUE `ArenaTimerIDX` (`time_type`, `time_name`, `time_value`),
  20. PRIMARY KEY (`id`)
  21. ) ENGINE = 'Default' COMMENT = '' ROW_FORMAT = DEFAULT ;
  22. DROP TABLE IF EXISTS `raw_arena_types`;
  23. CREATE TABLE `raw_arena_types` (
  24. `id` INT (10) UNSIGNED NOT NULL AUTO_INCREMENT,
  25. `unknown2a` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  26. `unknown2b` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  27. `unknown2c` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  28. `type_name` VARCHAR (32) NOT NULL DEFAULT '',
  29. `unknown3a` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  30. `unknown3b` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  31. `data_version` SMALLINT (5) UNSIGNED NOT NULL DEFAULT '0',
  32. `log_file` VARCHAR (250) NOT NULL DEFAULT '',
  33. UNIQUE `ArenaTypesIDX` (`type_name`),
  34. PRIMARY KEY (`id`)
  35. ) ENGINE = 'Default' COMMENT = '' ROW_FORMAT = DEFAULT ;
  36. DROP TABLE IF EXISTS `raw_arena_challenges`;
  37. CREATE TABLE `raw_arena_challenges` (
  38. `id` INT (10) UNSIGNED NOT NULL AUTO_INCREMENT,
  39. `challenge_name` VARCHAR (32) NOT NULL DEFAULT '',
  40. `challenge_value` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  41. `data_version` SMALLINT (5) UNSIGNED NOT NULL DEFAULT '0',
  42. `log_file` VARCHAR (250) NOT NULL DEFAULT '',
  43. UNIQUE `ArenaChallengeIDX` (`challenge_name`, `challenge_value`),
  44. PRIMARY KEY (`id`)
  45. ) ENGINE = 'Default' COMMENT = '' ROW_FORMAT = DEFAULT ;
  46. DROP TABLE IF EXISTS `raw_arena_zones`;
  47. CREATE TABLE `raw_arena_zones` (
  48. `id` INT (10) UNSIGNED NOT NULL AUTO_INCREMENT,
  49. `type1` VARCHAR (32) NOT NULL DEFAULT '',
  50. `unknown4a` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  51. `unknown4b` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  52. `file` VARCHAR (64) NOT NULL DEFAULT '',
  53. `type2` VARCHAR (32) NOT NULL DEFAULT '',
  54. `name` VARCHAR (32) NOT NULL DEFAULT '',
  55. `description` TEXT,
  56. `data_version` SMALLINT (5) UNSIGNED NOT NULL DEFAULT '0',
  57. `log_file` VARCHAR (250) NOT NULL DEFAULT '',
  58. UNIQUE `ArenaZonesIDX` (`type1`, `file`, `name`),
  59. PRIMARY KEY (`id`)
  60. ) ENGINE = 'Default' COMMENT = '' ROW_FORMAT = DEFAULT ;
  61. DROP TABLE IF EXISTS `raw_arena_images`;
  62. CREATE TABLE `raw_arena_images` (
  63. `id` INT (10) UNSIGNED NOT NULL AUTO_INCREMENT,
  64. `arena_zone_id` TINYINT(3) NOT NULL DEFAULT '0',
  65. `image_path` VARCHAR (250) NOT NULL DEFAULT '',
  66. `x` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  67. `y` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  68. `x2` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  69. `y2` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0',
  70. `data_version` SMALLINT (5) UNSIGNED NOT NULL DEFAULT '0',
  71. `log_file` VARCHAR (250) NOT NULL DEFAULT '',
  72. UNIQUE `ArenaImagesIDX` (`arena_zone_id`, `image_path`),
  73. PRIMARY KEY (`id`)
  74. ) ENGINE = 'Default' COMMENT = '' ROW_FORMAT = DEFAULT ;