| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131 |
- -- These queries are meant to delete any gameserver table you may have from
- -- previous L2J installations.
- --
- -- Queries that create these tables and/or populate them apropiately are
- -- available in the ../sql/ folder. See the documentation.txt file
- -- for more details.
- DROP TABLE IF EXISTS
- access_levels,
- account_gsdata,
- admin_command_access_rights,
- airships,
- auction,
- auction_bid,
- auction_watch,
- auto_announcements,
- auto_chat_text,
- auto_chat,
- castle,
- castle_door,
- castle_doorupgrade,
- castle_functions,
- castle_manor_procure,
- castle_manor_production,
- castle_siege_guards,
- char_templates,
- character_contacts,
- character_friends,
- character_hennas,
- character_instance_time,
- character_item_reuse_save,
- character_macroses,
- character_norestart_zone_time,
- character_offline_trade_items,
- character_offline_trade,
- character_pet_skills_save,
- character_quest_global_data,
- character_quests,
- character_raid_points,
- character_recipebook,
- character_recipeshoplist,
- character_reco_bonus,
- character_shortcuts,
- character_skills,
- character_skills_save,
- character_subclasses,
- character_summons,
- character_summon_skills_save,
- character_tpbookmark,
- character_ui_actions,
- character_ui_categories,
- characters,
- clan_data,
- clan_notices,
- clan_privs,
- clan_skills,
- clan_subpledges,
- clan_wars,
- clanhall,
- clanhall_functions,
- clanhall_siege_attackers,
- clanhall_siege_guards,
- cursed_weapons,
- dimensional_rift,
- droplist,
- enchant_skill_groups,
- fort,
- fort_doorupgrade,
- fort_functions,
- fort_siege_guards,
- fort_spawnlist,
- fort_staticobjects,
- fortsiege_clans,
- forums,
- four_sepulchers_spawnlist,
- games,
- global_tasks,
- global_variables,
- grandboss_data,
- grandboss_list,
- hellbound_spawnlist,
- helper_buff_list,
- herb_droplist_groups,
- heroes,
- heroes_diary,
- item_attributes,
- item_auction_bid,
- item_auction,
- item_elementals,
- items,
- itemsonground,
- locations,
- lvlupgain,
- merchant_buylists,
- merchant_lease,
- merchant_shopids,
- messages,
- minions,
- mods_wedding,
- npc,
- npc_buffer,
- npcaidata,
- npc_elementals,
- npcskills,
- olympiad_data,
- olympiad_fights,
- olympiad_nobles,
- olympiad_nobles_eom,
- petition_feedback,
- pets,
- pets_skills,
- posts,
- quest_global_data,
- raidboss_spawnlist,
- rainbowsprings_attacker_list,
- random_spawn,
- random_spawn_loc,
- seven_signs,
- seven_signs_festival,
- seven_signs_status,
- siegable_clanhall,
- siegable_hall_flagwar_attackers,
- siegable_hall_flagwar_attackers_members,
- siege_clans,
- skill_learn,
- spawnlist,
- teleport,
- territories,
- territory_registrations,
- territory_spawnlist,
- topic;
|
