diff options
| -rw-r--r-- | sql/updates/characters/2015_01_26_00_characters.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/2015_02_13_00_characters.sql (renamed from sql/updates/characters/2015_01_22_00_characters.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/characters/2015_02_13_01_characters.sql | 5 | ||||
| -rw-r--r-- | sql/updates/world/2015_02_13_00_world.sql (renamed from sql/updates/world/2015_01_22_00_world.sql) | 2 |
4 files changed, 6 insertions, 6 deletions
diff --git a/sql/updates/characters/2015_01_26_00_characters.sql b/sql/updates/characters/2015_01_26_00_characters.sql deleted file mode 100644 index b2530013944..00000000000 --- a/sql/updates/characters/2015_01_26_00_characters.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM `petition` WHERE `type` NOT IN(10); -- delete all non guild petitions -ALTER TABLE `petition` DROP COLUMN `type`, DROP PRIMARY KEY, ADD PRIMARY KEY (`ownerguid`); - -DELETE FROM `petition_sign` WHERE `type` NOT IN(10); -- delete all non guild petition signs -ALTER TABLE `petition_sign` DROP COLUMN `type`; diff --git a/sql/updates/characters/2015_01_22_00_characters.sql b/sql/updates/characters/2015_02_13_00_characters.sql index 1ed83e4e762..1ed83e4e762 100644 --- a/sql/updates/characters/2015_01_22_00_characters.sql +++ b/sql/updates/characters/2015_02_13_00_characters.sql diff --git a/sql/updates/characters/2015_02_13_01_characters.sql b/sql/updates/characters/2015_02_13_01_characters.sql new file mode 100644 index 00000000000..52b7a7e4c2a --- /dev/null +++ b/sql/updates/characters/2015_02_13_01_characters.sql @@ -0,0 +1,5 @@ +DELETE FROM `petition` WHERE `type` != 10; -- delete all non guild petitions +ALTER TABLE `petition` DROP COLUMN `type`, DROP PRIMARY KEY, ADD PRIMARY KEY (`ownerguid`); + +DELETE FROM `petition_sign` WHERE `type` != 10; -- delete all non guild petition signs +ALTER TABLE `petition_sign` DROP COLUMN `type`; diff --git a/sql/updates/world/2015_01_22_00_world.sql b/sql/updates/world/2015_02_13_00_world.sql index 4a23527e5aa..f510682f090 100644 --- a/sql/updates/world/2015_01_22_00_world.sql +++ b/sql/updates/world/2015_02_13_00_world.sql @@ -1,4 +1,4 @@ -DROP TABLE `guild_xp_for_level` IF EXISTS; +DROP TABLE IF EXISTS `guild_xp_for_level`; ALTER TABLE `guild_rewards` CHANGE COLUMN `entry` `ItemID` mediumint(8) UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `guild_rewards` CHANGE COLUMN `standing` `MinGuildRep` tinyint(3) UNSIGNED NULL DEFAULT 0; |