full_install.sql 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. DROP TABLE IF EXISTS account_data;
  2. DROP TABLE IF EXISTS armor;
  3. DROP TABLE IF EXISTS auction;
  4. DROP TABLE IF EXISTS auction_bid;
  5. DROP TABLE IF EXISTS auction_watch;
  6. DROP TABLE IF EXISTS auto_chat;
  7. DROP TABLE IF EXISTS auto_chat_text;
  8. DROP TABLE IF EXISTS boxaccess;
  9. DROP TABLE IF EXISTS boxes;
  10. DROP TABLE IF EXISTS castle;
  11. DROP TABLE IF EXISTS castle_door;
  12. DROP TABLE IF EXISTS castle_doorupgrade;
  13. DROP TABLE IF EXISTS castle_siege_guards;
  14. DROP TABLE IF EXISTS char_templates;
  15. DROP TABLE IF EXISTS character_friends;
  16. DROP TABLE IF EXISTS character_hennas;
  17. DROP TABLE IF EXISTS character_macroses;
  18. DROP TABLE IF EXISTS character_quests;
  19. DROP TABLE IF EXISTS character_recipebook;
  20. DROP TABLE IF EXISTS character_shortcuts;
  21. DROP TABLE IF EXISTS character_skills;
  22. DROP TABLE IF EXISTS character_skills_save;
  23. DROP TABLE IF EXISTS character_subclasses;
  24. DROP TABLE IF EXISTS characters;
  25. DROP TABLE IF EXISTS clan_data;
  26. DROP TABLE IF EXISTS clan_wars;
  27. DROP TABLE IF EXISTS clanhall;
  28. DROP TABLE IF EXISTS class_list;
  29. DROP TABLE IF EXISTS droplist;
  30. DROP TABLE IF EXISTS games;
  31. DROP TABLE IF EXISTS etcitem;
  32. DROP TABLE IF EXISTS forums;
  33. DROP TABLE IF EXISTS global_tasks;
  34. DROP TABLE IF EXISTS helper_buff_list;
  35. DROP TABLE IF EXISTS henna;
  36. DROP TABLE IF EXISTS henna_trees;
  37. DROP TABLE IF EXISTS heroes;
  38. DROP TABLE IF EXISTS items;
  39. DROP TABLE IF EXISTS locations;
  40. DROP TABLE IF EXISTS lvlupgain;
  41. DROP TABLE IF EXISTS mapregion;
  42. DROP TABLE IF EXISTS merchant_areas_list;
  43. DROP TABLE IF EXISTS merchant_buylists;
  44. DROP TABLE IF EXISTS merchant_lease;
  45. DROP TABLE IF EXISTS merchant_shopids;
  46. DROP TABLE IF EXISTS merchants;
  47. DROP TABLE IF EXISTS minions;
  48. DROP TABLE IF EXISTS npc;
  49. DROP TABLE IF EXISTS npcskills;
  50. DROP TABLE IF EXISTS olympiad_nobles;
  51. DROP TABLE IF EXISTS pets;
  52. DROP TABLE IF EXISTS pets_stats;
  53. DROP TABLE IF EXISTS posts;
  54. DROP TABLE IF EXISTS raidboss_spawnlist;
  55. DROP TABLE IF EXISTS random_spawn;
  56. DROP TABLE IF EXISTS random_spawn_loc;
  57. DROP TABLE IF EXISTS seven_signs;
  58. DROP TABLE IF EXISTS seven_signs_festival;
  59. DROP TABLE IF EXISTS seven_signs_status;
  60. DROP TABLE IF EXISTS siege_clans;
  61. DROP TABLE IF EXISTS skill_learn;
  62. DROP TABLE IF EXISTS skill_spellbooks;
  63. DROP TABLE IF EXISTS skill_trees;
  64. DROP TABLE IF EXISTS spawnlist;
  65. DROP TABLE IF EXISTS teleport;
  66. DROP TABLE IF EXISTS topic;
  67. DROP TABLE IF EXISTS weapon;
  68. DROP TABLE IF EXISTS zone;