diff options
| author | Duarte Duarte <dnpd.dd@gmail.com> | 2015-02-13 18:56:44 +0000 |
|---|---|---|
| committer | Duarte Duarte <dnpd.dd@gmail.com> | 2015-02-13 18:56:44 +0000 |
| commit | 71f3642bdc1639cbaf972c9a407b4609928701da (patch) | |
| tree | db4b58328a5439ccda68fd45c15d81e7f02165c7 | |
| parent | bc0c0ae2a334ee87df726c25b833e38a0c874614 (diff) | |
Rename SQLs added in commit bc0c0ae
| -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; |