From 3875ae0c669a87ff4fb663f52d4f2effed6cf17c Mon Sep 17 00:00:00 2001 From: Nay Date: Wed, 17 Jul 2013 00:27:42 +0100 Subject: TDB 335.52 - 2013/07/17 --- .../2013_03_04_00_characters_character_queststatus_rewarded.sql | 1 - .../characters/2013_04_05_00_characters_banned_addons.sql | 9 --------- sql/updates/characters/2013_06_23_00_characters_game_event.sql | 3 --- 3 files changed, 13 deletions(-) delete mode 100644 sql/updates/characters/2013_03_04_00_characters_character_queststatus_rewarded.sql delete mode 100644 sql/updates/characters/2013_04_05_00_characters_banned_addons.sql delete mode 100644 sql/updates/characters/2013_06_23_00_characters_game_event.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/2013_03_04_00_characters_character_queststatus_rewarded.sql b/sql/updates/characters/2013_03_04_00_characters_character_queststatus_rewarded.sql deleted file mode 100644 index e4dbf73ad7a..00000000000 --- a/sql/updates/characters/2013_03_04_00_characters_character_queststatus_rewarded.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `character_queststatus_rewarded` ADD `active` tinyint(3) unsigned NOT NULL DEFAULT '1' AFTER `quest`; diff --git a/sql/updates/characters/2013_04_05_00_characters_banned_addons.sql b/sql/updates/characters/2013_04_05_00_characters_banned_addons.sql deleted file mode 100644 index 4f286b2326c..00000000000 --- a/sql/updates/characters/2013_04_05_00_characters_banned_addons.sql +++ /dev/null @@ -1,9 +0,0 @@ -DROP TABLE IF EXISTS `banned_addons`; -CREATE TABLE `banned_addons` ( - `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, - `Name` varchar(255) NOT NULL, - `Version` varchar(255) NOT NULL DEFAULT '', - `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - PRIMARY KEY (`Id`), - UNIQUE KEY `idx_name_ver` (`Name`, `Version`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/updates/characters/2013_06_23_00_characters_game_event.sql b/sql/updates/characters/2013_06_23_00_characters_game_event.sql deleted file mode 100644 index d8a58832ce1..00000000000 --- a/sql/updates/characters/2013_06_23_00_characters_game_event.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Delete no longer used data from Characters Database -DELETE FROM `game_event_save` WHERE `eventEntry` BETWEEN 33 AND 47; -DELETE FROM `game_event_condition_save` WHERE `eventEntry` BETWEEN 33 AND 47; -- cgit v1.2.3