Remove unused dirs

1 files changed, 0 insertions, 95 deletions

diff --git a/sql-files/upgrades/2019-08-08--19-43.sql b/sql-files/upgrades/2019-08-08--19-43.sql
deleted file mode 100644
index 15bc4a89a..000000000
--- a/sql-files/upgrades/2019-08-08--19-43.sql
+++ /dev/null
@@ -1,95 +0,0 @@
-#1565293394
-
--- This file is part of Hercules.
--- http://herc.ws - http://github.com/HerculesWS/Hercules
---
--- Copyright (C) 2019-2020 Hercules Dev Team
---
--- Hercules is free software: you can redistribute it and/or modify
--- it under the terms of the GNU General Public License as published by
--- the Free Software Foundation, either version 3 of the License, or
--- (at your option) any later version.
---
--- This program is distributed in the hope that it will be useful,
--- but WITHOUT ANY WARRANTY; without even the implied warranty of
--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
--- GNU General Public License for more details.
---
--- You should have received a copy of the GNU General Public License
--- along with this program.  If not, see <http://www.gnu.org/licenses/>.
-
-ALTER TABLE `guild_castle` DROP PRIMARY KEY;
-ALTER TABLE `guild_castle` ADD COLUMN `castle_name` VARCHAR(24) AFTER `castle_id`;
-UPDATE `guild_castle` SET `castle_name` = 'aldeg_cas01' WHERE castle_id = 0;
-UPDATE `guild_castle` SET `castle_name` = 'aldeg_cas02' WHERE castle_id = 1;
-UPDATE `guild_castle` SET `castle_name` = 'aldeg_cas03' WHERE castle_id = 2;
-UPDATE `guild_castle` SET `castle_name` = 'aldeg_cas04' WHERE castle_id = 3;
-UPDATE `guild_castle` SET `castle_name` = 'aldeg_cas05' WHERE castle_id = 4;
-UPDATE `guild_castle` SET `castle_name` = 'gefg_cas01' WHERE castle_id = 5;
-UPDATE `guild_castle` SET `castle_name` = 'gefg_cas02' WHERE castle_id = 6;
-UPDATE `guild_castle` SET `castle_name` = 'gefg_cas03' WHERE castle_id = 7;
-UPDATE `guild_castle` SET `castle_name` = 'gefg_cas04' WHERE castle_id = 8;
-UPDATE `guild_castle` SET `castle_name` = 'gefg_cas05' WHERE castle_id = 9;
-UPDATE `guild_castle` SET `castle_name` = 'payg_cas01' WHERE castle_id = 10;
-UPDATE `guild_castle` SET `castle_name` = 'payg_cas02' WHERE castle_id = 11;
-UPDATE `guild_castle` SET `castle_name` = 'payg_cas03' WHERE castle_id = 12;
-UPDATE `guild_castle` SET `castle_name` = 'payg_cas04' WHERE castle_id = 13;
-UPDATE `guild_castle` SET `castle_name` = 'payg_cas05' WHERE castle_id = 14;
-UPDATE `guild_castle` SET `castle_name` = 'prtg_cas01' WHERE castle_id = 15;
-UPDATE `guild_castle` SET `castle_name` = 'prtg_cas02' WHERE castle_id = 16;
-UPDATE `guild_castle` SET `castle_name` = 'prtg_cas03' WHERE castle_id = 17;
-UPDATE `guild_castle` SET `castle_name` = 'prtg_cas04' WHERE castle_id = 18;
-UPDATE `guild_castle` SET `castle_name` = 'prtg_cas05' WHERE castle_id = 19;
-UPDATE `guild_castle` SET `castle_name` = 'nguild_alde' WHERE castle_id = 20;
-UPDATE `guild_castle` SET `castle_name` = 'nguild_gef' WHERE castle_id = 21;
-UPDATE `guild_castle` SET `castle_name` = 'nguild_pay' WHERE castle_id = 22;
-UPDATE `guild_castle` SET `castle_name` = 'nguild_prt' WHERE castle_id = 23;
-UPDATE `guild_castle` SET `castle_name` = 'schg_cas01' WHERE castle_id = 24;
-UPDATE `guild_castle` SET `castle_name` = 'schg_cas02' WHERE castle_id = 25;
-UPDATE `guild_castle` SET `castle_name` = 'schg_cas03' WHERE castle_id = 26;
-UPDATE `guild_castle` SET `castle_name` = 'schg_cas04' WHERE castle_id = 27;
-UPDATE `guild_castle` SET `castle_name` = 'schg_cas05' WHERE castle_id = 28;
-UPDATE `guild_castle` SET `castle_name` = 'arug_cas01' WHERE castle_id = 29;
-UPDATE `guild_castle` SET `castle_name` = 'arug_cas02' WHERE castle_id = 30;
-UPDATE `guild_castle` SET `castle_name` = 'arug_cas03' WHERE castle_id = 31;
-UPDATE `guild_castle` SET `castle_name` = 'arug_cas04' WHERE castle_id = 32;
-UPDATE `guild_castle` SET `castle_name` = 'arug_cas05' WHERE castle_id = 33;
-
--- Change the castle ids
-UPDATE `guild_castle` SET `castle_id` = 1 WHERE castle_name = 'prtg_cas01';
-UPDATE `guild_castle` SET `castle_id` = 2 WHERE castle_name = 'prtg_cas02';
-UPDATE `guild_castle` SET `castle_id` = 3 WHERE castle_name = 'prtg_cas03';
-UPDATE `guild_castle` SET `castle_id` = 4 WHERE castle_name = 'prtg_cas04';
-UPDATE `guild_castle` SET `castle_id` = 5 WHERE castle_name = 'prtg_cas05';
-UPDATE `guild_castle` SET `castle_id` = 6 WHERE castle_name = 'aldeg_cas01';
-UPDATE `guild_castle` SET `castle_id` = 7 WHERE castle_name = 'aldeg_cas02';
-UPDATE `guild_castle` SET `castle_id` = 8 WHERE castle_name = 'aldeg_cas03';
-UPDATE `guild_castle` SET `castle_id` = 9 WHERE castle_name = 'aldeg_cas04';
-UPDATE `guild_castle` SET `castle_id` = 10 WHERE castle_name = 'aldeg_cas05';
-UPDATE `guild_castle` SET `castle_id` = 11 WHERE castle_name = 'gefg_cas01';
-UPDATE `guild_castle` SET `castle_id` = 12 WHERE castle_name = 'gefg_cas02';
-UPDATE `guild_castle` SET `castle_id` = 13 WHERE castle_name = 'gefg_cas03';
-UPDATE `guild_castle` SET `castle_id` = 14 WHERE castle_name = 'gefg_cas04';
-UPDATE `guild_castle` SET `castle_id` = 15 WHERE castle_name = 'gefg_cas05';
-UPDATE `guild_castle` SET `castle_id` = 16 WHERE castle_name = 'payg_cas01';
-UPDATE `guild_castle` SET `castle_id` = 17 WHERE castle_name = 'payg_cas02';
-UPDATE `guild_castle` SET `castle_id` = 18 WHERE castle_name = 'payg_cas03';
-UPDATE `guild_castle` SET `castle_id` = 19 WHERE castle_name = 'payg_cas04';
-UPDATE `guild_castle` SET `castle_id` = 20 WHERE castle_name = 'payg_cas05';
-UPDATE `guild_castle` SET `castle_id` = 21 WHERE castle_name = 'arug_cas01';
-UPDATE `guild_castle` SET `castle_id` = 22 WHERE castle_name = 'arug_cas02';
-UPDATE `guild_castle` SET `castle_id` = 23 WHERE castle_name = 'arug_cas03';
-UPDATE `guild_castle` SET `castle_id` = 24 WHERE castle_name = 'arug_cas04';
-UPDATE `guild_castle` SET `castle_id` = 25 WHERE castle_name = 'arug_cas05';
-UPDATE `guild_castle` SET `castle_id` = 26 WHERE castle_name = 'schg_cas01';
-UPDATE `guild_castle` SET `castle_id` = 27 WHERE castle_name = 'schg_cas02';
-UPDATE `guild_castle` SET `castle_id` = 29 WHERE castle_name = 'schg_cas04';
-UPDATE `guild_castle` SET `castle_id` = 28 WHERE castle_name = 'schg_cas03';
-UPDATE `guild_castle` SET `castle_id` = 30 WHERE castle_name = 'schg_cas05';
-UPDATE `guild_castle` SET `castle_id` = 31 WHERE castle_name = 'nguild_prt';
-UPDATE `guild_castle` SET `castle_id` = 32 WHERE castle_name = 'nguild_alde';
-UPDATE `guild_castle` SET `castle_id` = 33 WHERE castle_name = 'nguild_gef';
-UPDATE `guild_castle` SET `castle_id` = 34 WHERE castle_name = 'nguild_pay';
-ALTER TABLE `guild_castle` ADD PRIMARY KEY (`castle_id`);
-ALTER TABLE `guild_castle` DROP COLUMN `castle_name`;
-INSERT INTO `sql_updates` (`timestamp`) VALUES (1565293394);