PageRenderTime 109ms CodeModel.GetById 38ms RepoModel.GetById 0ms app.codeStats 0ms

/sql/updates/world/already_applied/12_07_08_03_world_vehicle_accessory_template.sql

https://bitbucket.org/biglad/uncore
SQL | 181 lines | 174 code | 4 blank | 3 comment | 0 complexity | 2dc37116318743706cb27c5ca0ed11fc MD5 | raw file
Possible License(s): GPL-3.0, CC-BY-SA-3.0, BSD-3-Clause, GPL-2.0 
    

  1. RENAME TABLE `vehicle_accessory` TO `vehicle_template_accessory`;
    2. 

  2. 

  3. ALTER TABLE `vehicle_template_accessory` 
    4. 

  4. ADD COLUMN  `summontype` TINYINT(3) UNSIGNED NOT NULL DEFAULT 6 COMMENT 'see enum TempSummonType' AFTER `description`,
    5. 

  5. ADD COLUMN  `summontimer` INT(10) UNSIGNED NOT NULL DEFAULT 30000 COMMENT 'timer, only relevant for certain summontypes' AFTER `summontype`;
    6. 

  6. 

  7. CREATE TABLE IF NOT EXISTS `vehicle_accessory` (
    8. 

  8.   `guid` mediumint(8) unsigned NOT NULL DEFAULT '0',
    9. 

  9.   `accessory_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
    10. 

  10.   `seat_id` tinyint(1) NOT NULL DEFAULT '0',
    11. 

  11.   `minion` tinyint(1) unsigned NOT NULL DEFAULT '0',
    12. 

  12.   `description` text NOT NULL,
    13. 

  13.   `summontype` tinyint(3) unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType',
    14. 

  14.   `summontimer` int(10) unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes',
    15. 

  15.   PRIMARY KEY (`guid`,`seat_id`)
    16. 

  16. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='CTDB Vehicle Accessory System.';
    17. 

  17. 

  18. --
    19. 

  19. -- Contenu de la table `vehicle_template_accessory`
    20. 

  20. --
    21. 

  21. 

  22. INSERT INTO `vehicle_accessory` (`guid`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES
    23. 

  23. (28782, 28768, 0, 0, 'Acherus Deathcharger', 6, 30000),
    24. 

  24. (28312, 28319, 7, 1, 'Wintergrasp Siege Engine', 6, 30000),
    25. 

  25. (32627, 32629, 7, 1, 'Wintergrasp Siege Engine', 6, 30000),
    26. 

  26. (32930, 32933, 0, 1, 'Kologarn', 6, 30000),
    27. 

  27. (32930, 32934, 1, 1, 'Kologarn', 6, 30000),
    28. 

  28. (33109, 33167, 1, 1, 'Salvaged Demolisher', 6, 30000),
    29. 

  29. (33060, 33067, 7, 1, 'Salvaged Siege Engine', 6, 30000),
    30. 

  30. (33113, 33114, 0, 1, 'Flame Leviathan', 6, 30000),
    31. 

  31. (33113, 33114, 1, 1, 'Flame Leviathan', 6, 30000),
    32. 

  32. (33113, 33114, 2, 1, 'Flame Leviathan', 6, 30000),
    33. 

  33. (33113, 33114, 3, 1, 'Flame Leviathan', 6, 30000),
    34. 

  34. (33113, 33139, 7, 1, 'Flame Leviathan', 6, 30000),
    35. 

  35. (36678, 38309, 0, 1, 'Professor Putricide - trigger', 6, 30000),
    36. 

  36. (33214, 33218, 1, 1, 'Mechanolift 304-A', 6, 30000),
    37. 

  37. (35637, 34705, 0, 0, 'Marshal Jacob Alerius'' Mount', 6, 30000),
    38. 

  38. (35633, 34702, 0, 0, 'Ambrose Boltspark''s Mount', 6, 30000),
    39. 

  39. (35768, 34701, 0, 0, 'Colosos'' Mount', 6, 30000),
    40. 

  40. (34658, 34657, 0, 0, 'Jaelyne Evensong''s Mount', 6, 30000),
    41. 

  41. (35636, 34703, 0, 0, 'Lana Stouthammer''s Mount', 6, 30000),
    42. 

  42. (35638, 35572, 0, 0, 'Mokra the Skullcrusher''s Mount', 6, 30000),
    43. 

  43. (35635, 35569, 0, 0, 'Eressea Dawnsinger''s Mount', 6, 30000),
    44. 

  44. (35640, 35571, 0, 0, 'Runok Wildmane''s Mount', 6, 30000),
    45. 

  45. (35641, 35570, 0, 0, 'Zul''tore''s Mount', 6, 30000),
    46. 

  46. (35634, 35617, 0, 0, 'Deathstalker Visceri''s Mount', 6, 30000),
    47. 

  47. (27241, 27268, 0, 0, 'Risen Gryphon', 6, 30000),
    48. 

  48. (27661, 27662, 0, 0, 'Wintergarde Gryphon', 6, 30000),
    49. 

  49. (29698, 29699, 0, 0, 'Drakuru Raptor', 6, 30000),
    50. 

  50. (33778, 33780, 0, 0, 'Tournament Hippogryph', 6, 30000),
    51. 

  51. (33687, 33695, 0, 0, 'Chillmaw', 6, 30000),
    52. 

  52. (33687, 33695, 1, 0, 'Chillmaw', 6, 30000),
    53. 

  53. (33687, 33695, 2, 0, 'Chillmaw', 6, 30000),
    54. 

  54. (29625, 29694, 0, 0, 'Hyldsmeet Proto-Drake', 6, 30000),
    55. 

  55. (30330, 30332, 0, 0, 'Jotunheim Proto-Drake', 6, 30000),
    56. 

  56. (32189, 32190, 0, 0, 'Skybreaker Recon Fighter', 6, 30000),
    57. 

  57. (36678, 38308, 1, 1, 'Professor Putricide - trigger', 6, 30000),
    58. 

  58. (32640, 32642, 1, 0, 'Traveler Mammoth (H) - Vendor', 6, 30000),
    59. 

  59. (32640, 32641, 2, 0, 'Traveler Mammoth (H) - Vendor & Repairer', 6, 30000),
    60. 

  60. (32633, 32638, 1, 0, 'Traveler Mammoth (A) - Vendor', 6, 30000),
    61. 

  61. (32633, 32639, 2, 0, 'Traveler Mammoth (A) - Vendor & Repairer', 6, 30000),
    62. 

  62. (33669, 33666, 0, 0, 'Demolisher Engineer Blastwrench', 6, 30000),
    63. 

  63. (29555, 29556, 0, 0, 'Goblin Sapper', 6, 30000),
    64. 

  64. (28018, 28006, 0, 1, 'Thiassi the Light Bringer', 6, 30000),
    65. 

  65. (28054, 28053, 0, 0, 'Lucky Wilhelm - Apple', 6, 30000),
    66. 

  66. (35491, 35451, 0, 0, 'Black Knight', 6, 30000),
    67. 

  67. (33299, 35323, 0, 1, 'Darkspear Raptor', 6, 30000),
    68. 

  68. (33418, 35326, 0, 1, 'Silvermoon Hawkstrider', 6, 30000),
    69. 

  69. (33409, 35314, 0, 1, 'Orgrimmar Wolf', 6, 30000),
    70. 

  70. (33300, 35325, 0, 1, 'Thunder Bluff Kodo', 6, 30000),
    71. 

  71. (33408, 35329, 0, 1, 'Ironforge Ram', 6, 30000),
    72. 

  72. (33301, 35331, 0, 1, 'Gnomeregan Mechanostrider', 6, 30000),
    73. 

  73. (33414, 35327, 0, 1, 'Forsaken Warhorse', 6, 30000),
    74. 

  74. (33297, 35328, 0, 1, 'Stormwind Steed', 6, 30000),
    75. 

  75. (33416, 35330, 0, 1, 'Exodar Elekk', 6, 30000),
    76. 

  76. (33298, 35332, 0, 1, 'Darnassian Nightsaber', 6, 30000),
    77. 

  77. (33318, 35330, 0, 1, 'Exodar Elekk', 6, 30000),
    78. 

  78. (33319, 35332, 0, 1, 'Darnassian Nightsaber', 6, 30000),
    79. 

  79. (33316, 35329, 0, 1, 'Ironforge Ram', 6, 30000),
    80. 

  80. (33317, 35331, 0, 1, 'Gnomeregan Mechanostrider', 6, 30000),
    81. 

  81. (33217, 35328, 0, 1, 'Stormwind Steed', 6, 30000),
    82. 

  82. (33324, 35327, 0, 1, 'Forsaken Warhorse', 6, 30000),
    83. 

  83. (33322, 35325, 0, 1, 'Thunder Bluff Kodo', 6, 30000),
    84. 

  84. (33320, 35314, 0, 1, 'Orgrimmar Wolf', 6, 30000),
    85. 

  85. (33323, 35326, 0, 1, 'Silvermoon Hawkstrider', 6, 30000),
    86. 

  86. (33321, 35323, 0, 1, 'Darkspear Raptor', 6, 30000),
    87. 

  87. (28614, 28616, 0, 1, 'Scarlet Gryphon Rider', 6, 30000),
    88. 

  88. (36891, 31260, 0, 0, 'Ymirjar Skycaller on Drake', 6, 30000),
    89. 

  89. (38500, 38493, 0, 0, 'Argent Crusader', 6, 30000),
    90. 

  90. (27626, 27627, 0, 0, 'Tatjana''s Horse', 6, 30000),
    91. 

  91. (28009, 28093, 0, 0, 'Sholazar Tickbird', 6, 30000),
    92. 

  92. (28451, 28468, 0, 0, 'Hemet Nesingwary', 6, 30000),
    93. 

  93. (30204, 30268, 0, 0, 'Webbed Crusader', 6, 30000),
    94. 

  94. (29351, 29558, 0, 0, 'Frost Giant Target Bunny', 6, 30000),
    95. 

  95. (29708, 29805, 0, 1, 'Captive Proto Drake Beam Bunny', 6, 30000),
    96. 

  96. (30174, 30175, 0, 0, 'Hyldsmeet Bear Rider', 6, 30000),
    97. 

  97. (29460, 29458, 0, 0, 'Brunnhildar Drakerider', 6, 30000),
    98. 

  98. (29500, 29498, 0, 0, 'Brunnhildar Warmaiden', 6, 30000),
    99. 

  99. (29358, 29558, 0, 0, 'Frost Giant Target Bunny', 6, 30000),
    100. 

  100. (25968, 25801, 0, 0, 'Nedar, Lord of Rhinos', 6, 30000),
    101. 

  101. (38431, 38309, 0, 0, 'Slimy Tentacle Stalker', 6, 30000),
    102. 

  102. (38585, 38309, 0, 0, 'Slimy Tentacle Stalker', 6, 30000),
    103. 

  103. (38586, 38309, 0, 0, 'Slimy Tentacle Stalker', 6, 30000),
    104. 

  104. (38431, 38308, 1, 1, 'Ooze Covered Tentacle Stalker', 6, 30000),
    105. 

  105. (38585, 38308, 1, 1, 'Ooze Covered Tentacle Stalker', 6, 30000),
    106. 

  106. (38586, 38308, 1, 1, 'Ooze Covered Tentacle Stalker', 6, 30000),
    107. 

  107. (28669, 28717, 0, 0, 'Overlord Drakuru', 6, 30000),
    108. 

  108. (39860, 39264, 0, 0, 'Gnomeregan Mechano-Tank Pilot', 6, 30000),
    109. 

  109. (36896, 28717, 0, 0, 'Overlord Drakuru', 6, 30000),
    110. 

  110. (36794, 36658, 0, 0, 'Scourgelord Tyrannus', 6, 30000),
    111. 

  111. (29931, 29982, 0, 0, 'Drakkari Rider on Drakkari Rhino, not minion', 6, 30000),
    112. 

  112. (24750, 24751, 0, 1, 'Excelsior rides Hidalgo the Master Falconer', 6, 30000),
    113. 

  113. (36661, 36658, 0, 0, 'Scourgelord Tyrannus and Rimefang', 6, 30000),
    114. 

  114. (36476, 36477, 0, 0, 'Krick on Ick', 6, 30000),
    115. 

  115. (30234, 30245, 0, 0, 'Hover Disk - Nexus Lord', 6, 30000),
    116. 

  116. (30248, 30249, 0, 0, 'Hover Disk - Scion of Eternity', 6, 30000),
    117. 

  117. (46012, 46363, 0, 0, 'Target Acquisition Device', 6, 30000),
    118. 

  118. (13210, 466, 0, 0, 'General Marcus Jonathan', 6, 30000),
    119. 

  119. (17804, 721, 0, 1, 'Rowe', 6, 30000),
    120. 

  120. (2041, 7555, 0, 0, 'Ancient Protector', 6, 30000),
    121. 

  121. (4262, 5945, 0, 1, 'Darnassus Sentinels', 6, 30000),
    122. 

  122. (6588, 49877, 0, 0, 'Golden King', 6, 30000),
    123. 

  123. (2500, 25111, 0, 1, 'Captain Hecklebury Smotts', 6, 30000),
    124. 

  124. (35999, 35063, 0, 0, 'Kezan Citizen', 6, 30000),
    125. 

  125. (37968, 38505, 0, 0, 'Argent Hippogryph', 6, 30000),
    126. 

  126. (25049, 24976, 0, 0, 'Dawnstar Charger', 6, 30000),
    127. 

  127. (31269, 27559, 0, 0, 'Kor''kron Battle Wyvern', 6, 30000),
    128. 

  128. (33293, 33329, 0, 1, 'XT-002 Deconstructor - Heart', 6, 30000),
    129. 

  129. (29433, 29440, 0, 0, 'Goblin Sapper in K3', 6, 30000),
    130. 

  130. (29838, 29836, 0, 0, 'Drakkari Battle Rider on Drakkari Rhino, not minion', 6, 30000),
    131. 

  131. (31262, 31263, 0, 0, 'Carrion Hunter rides Blight Falconer', 6, 30000),
    132. 

  132. (31406, 31408, 0, 1, 'Alliance Bomber Seat on Alliance Infra-green Bomber', 6, 30000),
    133. 

  133. (31406, 31407, 1, 1, 'Alliance Turret Seat on Alliance Infra-green Bomber', 6, 30000),
    134. 

  134. (31406, 31409, 2, 1, 'Alliance Engineering Seat on rides Alliance Infra-green Bomber', 6, 30000),
    135. 

  135. (31406, 32217, 3, 1, 'Banner Bunny, Hanging, Alliance on Alliance Infra-green Bomber', 6, 30000),
    136. 

  136. (31406, 32221, 4, 1, 'Banner Bunny, Side, Alliance on Alliance Infra-green Bomber', 6, 30000),
    137. 

  137. (31406, 32221, 5, 1, 'Banner Bunny, Side, Alliance on Alliance Infra-green Bomber', 6, 30000),
    138. 

  138. (31406, 32256, 6, 1, 'Shield Visual Loc Bunny on Alliance Infra-green Bomber', 6, 30000),
    139. 

  139. (31406, 32274, 7, 0, 'Alliance Bomber Pilot rides Alliance Infra-green Bomber', 6, 30000),
    140. 

  140. (31583, 31630, 1, 1, 'Skytalon Explosion Bunny on Frostbrood Skytalon', 6, 30000),
    141. 

  141. (31881, 31891, 0, 0, 'Kor''kron Transport Pilot rides Kor''kron Troop Transport', 6, 30000),
    142. 

  142. (31881, 31884, 1, 1, 'Kor''kron Suppression Turret on Kor''kron Troop Transport', 6, 30000),
    143. 

  143. (31881, 31882, 2, 0, 'Kor''kron Infiltrator on Kor''kron Troop Transport', 6, 30000),
    144. 

  144. (31881, 31882, 3, 0, 'Kor''kron Infiltrator on Kor''kron Troop Transport', 6, 30000),
    145. 

  145. (31881, 31882, 4, 0, 'Kor''kron Infiltrator on Kor''kron Troop Transport', 6, 30000),
    146. 

  146. (31881, 31882, 5, 0, 'Kor''kron Infiltrator on Kor''kron Troop Transport', 6, 30000),
    147. 

  147. (31884, 31882, 0, 1, 'Kor''kron Infiltrator rides Kor''kron Suppression Turret', 6, 30000),
    148. 

  148. (32225, 32223, 0, 0, 'Skybreaker Transport Pilot rides Skybreaker Troop Transport', 6, 30000),
    149. 

  149. (32225, 32227, 1, 1, 'Skybreaker Suppression Turret on Skybreaker Troop Transport', 6, 30000),
    150. 

  150. (32225, 32222, 2, 0, 'Skybreaker Infiltrator on Skybreaker Troop Transport', 6, 30000),
    151. 

  151. (32225, 32222, 3, 0, 'Skybreaker Infiltrator on Skybreaker Troop Transport', 6, 30000),
    152. 

  152. (32225, 32222, 4, 0, 'Skybreaker Infiltrator on Skybreaker Troop Transport', 6, 30000),
    153. 

  153. (32225, 32222, 5, 0, 'Skybreaker Infiltrator on Skybreaker Troop Transport', 6, 30000),
    154. 

  154. (32227, 32222, 0, 1, 'Skybreaker Infiltrator rides Skybreaker Suppression Turret', 6, 30000),
    155. 

  155. (32490, 32486, 0, 0, 'Scourge Death Knight rides Scourge Deathcharger', 6, 30000),
    156. 

  156. (32344, 32274, 0, 0, 'Alliance Bomber Pilot rides Alliance Rescue Craft', 6, 30000),
    157. 

  157. (32344, 32531, 2, 1, 'Banner Bunny, Side, Alliance, Small rides Alliance Rescue Craft', 6, 30000),
    158. 

  158. (43259, 43092, 0, 0, 'Gnomeregan Recruit', 6, 30000),
    159. 

  159. (47297, 47296, 0, 1, 'Patan inutil', 6, 30000),
    160. 

  160. (32823, 34812, 0, 1, 'Bountiful Table - The Turkey Chair', 6, 30000),
    161. 

  161. (32823, 34823, 1, 1, 'Bountiful Table - The Cranberry Chair', 6, 30000),
    162. 

  162. (32823, 34819, 2, 1, 'Bountiful Table - The Stuffing Chair', 6, 30000),
    163. 

  163. (32823, 34824, 3, 1, 'Bountiful Table - The Sweet Potato Chair', 6, 30000),
    164. 

  164. (32823, 34822, 4, 1, 'Bountiful Table - The Pie Chair', 6, 30000),
    165. 

  165. (32823, 32830, 5, 1, 'Bountiful Table - Food Holder', 6, 30000),
    166. 

  166. (32823, 32840, 6, 1, 'Bountiful Table - Plate Holder', 6, 30000),
    167. 

  167. (32830, 32824, 0, 1, 'Food Holder - [PH] Pilgrim''s Bounty Table - Turkey', 6, 30000),
    168. 

  168. (32830, 32827, 1, 1, 'Food Holder - [PH] Pilgrim''s Bounty Table - Cranberry Sauce', 6, 30000),
    169. 

  169. (32830, 32831, 2, 1, 'Food Holder - [PH] Pilgrim''s Bounty Table - Stuffing', 6, 30000),
    170. 

  170. (32830, 32825, 3, 1, 'Food Holder - [PH] Pilgrim''s Bounty Table - Yams', 6, 30000),
    171. 

  171. (32830, 32829, 4, 1, 'Food Holder - [PH] Pilgrim''s Bounty Table - Pie', 6, 30000),
    172. 

  172. (32840, 32839, 0, 1, 'Plate Holder - Sturdy Plate', 6, 30000),
    173. 

  173. (32840, 32839, 1, 1, 'Plate Holder - Sturdy Plate', 6, 30000),
    174. 

  174. (32840, 32839, 2, 1, 'Plate Holder - Sturdy Plate', 6, 30000),
    175. 

  175. (32840, 32839, 3, 1, 'Plate Holder - Sturdy Plate', 6, 30000),
    176. 

  176. (32840, 32839, 4, 1, 'Plate Holder - Sturdy Plate', 6, 30000),
    177. 

  177. (41570, 42347, 0, 0, 'Magmaws Head', 6, 30000),
    178. 

  178. (34160, 34163, 0, 0, 'Hellscream Hellion', 6, 30000),
    179. 

  179. (40573, 40575, 0, 0, 'Twilight Stormwaker', 6, 30000),
    180. 

  180. (34132, 6087, 0, 0, 'Thrower', 6, 30000),
    181. 

  181. (51195, 14304, 0, 0, 'Korkron Annihilator', 6, 30000);
    182.