Home Verkennen Help
Registreren Inloggen
L2j
/
l2j-server-datapack
2
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki
Boom: 5c0e373c5a
Aftakkingen Labels
l2j-server-data...
/
dist
/
sql
/
game
/
updates
/
20110729update.sql

20110729update.sql 7.9 KB
Geschiedenis Ruwe

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123 
  1. DROP TABLE IF EXISTS mapregion;
    2. 

  2. 

  3. ALTER TABLE `access_levels` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    4. 

  4. ALTER TABLE `account_gsdata` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    5. 

  5. ALTER TABLE `admin_command_access_rights` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    6. 

  6. ALTER TABLE `airships` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    7. 

  7. ALTER TABLE `armorsets` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    8. 

  8. ALTER TABLE `auction` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    9. 

  9. ALTER TABLE `auction_bid` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    10. 

  10. ALTER TABLE `auction_watch` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    11. 

  11. ALTER TABLE `auto_announcements` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    12. 

  12. ALTER TABLE `auto_chat` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    13. 

  13. ALTER TABLE `auto_chat_text` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    14. 

  14. ALTER TABLE `castle` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    15. 

  15. ALTER TABLE `castle_door` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    16. 

  16. ALTER TABLE `castle_doorupgrade` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    17. 

  17. ALTER TABLE `castle_functions` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    18. 

  18. ALTER TABLE `castle_manor_procure` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    19. 

  19. ALTER TABLE `castle_manor_production` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    20. 

  20. ALTER TABLE `castle_siege_guards` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    21. 

  21. ALTER TABLE `char_creation_items` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    22. 

  22. ALTER TABLE `char_templates` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    23. 

  23. ALTER TABLE `character_contacts` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    24. 

  24. ALTER TABLE `character_friends` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    25. 

  25. ALTER TABLE `character_hennas` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    26. 

  26. ALTER TABLE `character_instance_time` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    27. 

  27. ALTER TABLE `character_macroses` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    28. 

  28. ALTER TABLE `character_offline_trade` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    29. 

  29. ALTER TABLE `character_offline_trade_items` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    30. 

  30. ALTER TABLE `character_pet_skills_save` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    31. 

  31. ALTER TABLE `character_premium_items` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    32. 

  32. ALTER TABLE `character_quest_global_data` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    33. 

  33. ALTER TABLE `character_quests` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    34. 

  34. ALTER TABLE `character_raid_points` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    35. 

  35. ALTER TABLE `character_recipebook` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    36. 

  36. ALTER TABLE `character_recipeshoplist` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    37. 

  37. ALTER TABLE `character_reco_bonus` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    38. 

  38. ALTER TABLE `character_shortcuts` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    39. 

  39. ALTER TABLE `character_skills` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    40. 

  40. ALTER TABLE `character_skills_save` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    41. 

  41. ALTER TABLE `character_subclasses` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    42. 

  42. ALTER TABLE `character_summon_skills_save` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    43. 

  43. ALTER TABLE `character_summons` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    44. 

  44. ALTER TABLE `character_tpbookmark` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    45. 

  45. ALTER TABLE `character_ui_actions` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    46. 

  46. ALTER TABLE `character_ui_categories` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    47. 

  47. ALTER TABLE `characters` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    48. 

  48. ALTER TABLE `clan_data` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    49. 

  49. ALTER TABLE `clan_notices` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    50. 

  50. ALTER TABLE `clan_privs` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    51. 

  51. ALTER TABLE `clan_skills` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    52. 

  52. ALTER TABLE `clan_subpledges` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    53. 

  53. ALTER TABLE `clan_wars` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    54. 

  54. ALTER TABLE `clanhall` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    55. 

  55. ALTER TABLE `clanhall_functions` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    56. 

  56. ALTER TABLE `clanhall_siege_guards` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    57. 

  57. ALTER TABLE `class_list` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    58. 

  58. ALTER TABLE `cursed_weapons` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    59. 

  59. ALTER TABLE `dimensional_rift` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    60. 

  60. ALTER TABLE `droplist` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    61. 

  61. ALTER TABLE `enchant_skill_groups` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    62. 

  62. ALTER TABLE `fish` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    63. 

  63. ALTER TABLE `fort` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    64. 

  64. ALTER TABLE `fort_doorupgrade` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    65. 

  65. ALTER TABLE `fort_functions` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    66. 

  66. ALTER TABLE `fort_siege_guards` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    67. 

  67. ALTER TABLE `fort_spawnlist` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    68. 

  68. ALTER TABLE `fort_staticobjects` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    69. 

  69. ALTER TABLE `fortsiege_clans` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    70. 

  70. ALTER TABLE `forums` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    71. 

  71. ALTER TABLE `four_sepulchers_spawnlist` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    72. 

  72. ALTER TABLE `games` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    73. 

  73. ALTER TABLE `global_tasks` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    74. 

  74. ALTER TABLE `global_variables` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    75. 

  75. ALTER TABLE `grandboss_data` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    76. 

  76. ALTER TABLE `grandboss_list` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    77. 

  77. ALTER TABLE `helper_buff_list` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    78. 

  78. ALTER TABLE `henna` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    79. 

  79. ALTER TABLE `henna_trees` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    80. 

  80. ALTER TABLE `herb_droplist_groups` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    81. 

  81. ALTER TABLE `heroes` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    82. 

  82. ALTER TABLE `heroes_diary` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    83. 

  83. ALTER TABLE `item_attributes` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    84. 

  84. ALTER TABLE `item_auction` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    85. 

  85. ALTER TABLE `item_auction_bid` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    86. 

  86. ALTER TABLE `item_elementals` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    87. 

  87. ALTER TABLE `items` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    88. 

  88. ALTER TABLE `itemsonground` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    89. 

  89. ALTER TABLE `locations` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    90. 

  90. ALTER TABLE `lvlupgain` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    91. 

  91. ALTER TABLE `merchant_buylists` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    92. 

  92. ALTER TABLE `merchant_lease` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    93. 

  93. ALTER TABLE `merchant_shopids` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    94. 

  94. ALTER TABLE `messages` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    95. 

  95. ALTER TABLE `minions` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    96. 

  96. ALTER TABLE `npc` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    97. 

  97. ALTER TABLE `npc_buffer` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    98. 

  98. ALTER TABLE `npc_elementals` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    99. 

  99. ALTER TABLE `npcaidata` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    100. 

  100. ALTER TABLE `npcskills` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    101. 

  101. ALTER TABLE `olympiad_data` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    102. 

  102. ALTER TABLE `olympiad_fights` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    103. 

  103. ALTER TABLE `olympiad_nobles` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    104. 

  104. ALTER TABLE `olympiad_nobles_eom` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    105. 

  105. ALTER TABLE `petition_feedback` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    106. 

  106. ALTER TABLE `pets` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    107. 

  107. ALTER TABLE `pets_skills` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    108. 

  108. ALTER TABLE `posts` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    109. 

  109. ALTER TABLE `quest_global_data` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    110. 

  110. ALTER TABLE `raidboss_spawnlist` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    111. 

  111. ALTER TABLE `random_spawn` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    112. 

  112. ALTER TABLE `random_spawn_loc` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    113. 

  113. ALTER TABLE `seven_signs` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    114. 

  114. ALTER TABLE `seven_signs_festival` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    115. 

  115. ALTER TABLE `seven_signs_status` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    116. 

  116. ALTER TABLE `siege_clans` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    117. 

  117. ALTER TABLE `skill_learn` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    118. 

  118. ALTER TABLE `spawnlist` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    119. 

  119. ALTER TABLE `teleport` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    120. 

  120. ALTER TABLE `territories` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    121. 

  121. ALTER TABLE `territory_registrations` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    122. 

  122. ALTER TABLE `territory_spawnlist` ENGINE=MyISAM DEFAULT CHARSET=utf8;
    123. 

  123. ALTER TABLE `topic` ENGINE=InnoDB DEFAULT CHARSET=utf8;
    124.