From 5faecb6c67c3b34e237ae7a645bed7359f025fd7 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 6 Apr 2021 00:14:51 +0200 Subject: SQL: Add missing `updates` entry --- sql/base/characters_database.sql | 3 +- .../characters/master/2021_04_05_00_characters.sql | 93 ++++++++++++++++++++++ .../master/2021_04_05_00_charactrers.sql | 93 ---------------------- 3 files changed, 95 insertions(+), 94 deletions(-) create mode 100644 sql/updates/characters/master/2021_04_05_00_characters.sql delete mode 100644 sql/updates/characters/master/2021_04_05_00_charactrers.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 7cdf50285d4..4d87865100e 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3851,7 +3851,8 @@ INSERT INTO `updates` VALUES ('2020_10_20_00_characters.sql','744F2A36865761920CE98A6DDE3A3BADF44D1E77','ARCHIVED','2020-10-20 21:36:49',0), ('2020_11_16_00_characters.sql','33D5C7539E239132923D01F4B6EAD5F3EF3EEB69','RELEASED','2020-11-16 19:16:31',0), ('2020_12_13_00_characters.sql','6AC743240033DED2C402ECB894A59D79EF607920','RELEASED','2020-12-13 18:36:58',0), -('2021_03_27_00_characters_aura_stored_location.sql','BF772ABC2DF186AF0A5DC56D5E824A2F4813BA69','RELEASED','2021-03-27 15:53:04',0); +('2021_03_27_00_characters_aura_stored_location.sql','BF772ABC2DF186AF0A5DC56D5E824A2F4813BA69','RELEASED','2021-03-27 15:53:04',0), +('2021_04_05_00_characters.sql','33D656995E0F3578FFE1A658ED1692CA5310AB30','RELEASED','2021-04-05 23:44:54',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2021_04_05_00_characters.sql b/sql/updates/characters/master/2021_04_05_00_characters.sql new file mode 100644 index 00000000000..5b66a62f108 --- /dev/null +++ b/sql/updates/characters/master/2021_04_05_00_characters.sql @@ -0,0 +1,93 @@ +ALTER TABLE `account_data` MODIFY `time` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `account_instance_times` MODIFY `releaseTime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `auctionhouse` + MODIFY `startTime` bigint(20) NOT NULL DEFAULT '0', + MODIFY `endTime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `blackmarket_auctions` MODIFY `time` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `calendar_events` + MODIFY `Date` bigint(20) NOT NULL DEFAULT '0', + MODIFY `LockDate` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `calendar_invites` MODIFY `ResponseTime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `channels` MODIFY `lastUsed` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_account_data` MODIFY `time` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_achievement` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_achievement_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_banned` + MODIFY `bandate` bigint(20) NOT NULL DEFAULT '0', + MODIFY `unbandate` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_garrison_buildings` MODIFY `timeBuilt` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_queststatus` MODIFY `timer` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_queststatus_daily` MODIFY `time` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_queststatus_objectives_criteria_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_spell_charges` + MODIFY `rechargeStart` bigint(20) NOT NULL DEFAULT '0', + MODIFY `rechargeEnd` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `character_spell_cooldown` + MODIFY `time` bigint(20) NOT NULL DEFAULT '0', + MODIFY `categoryEnd` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `characters` + MODIFY `logout_time` bigint(20) NOT NULL DEFAULT '0', + MODIFY `resettalents_time` bigint(20) NOT NULL DEFAULT '0', + MODIFY `death_expire_time` bigint(20) NOT NULL DEFAULT '0', + MODIFY `deleteDate` bigint(20) unsigned DEFAULT NULL; + +ALTER TABLE `creature_respawn` MODIFY `respawnTime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `game_event_save` MODIFY `next_start` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `gameobject_respawn` MODIFY `respawnTime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `gm_bug` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `gm_complaint` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `gm_complaint_chatlog` MODIFY `timestamp` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `gm_suggestion` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `guild_achievement` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `guild_achievement_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `guild_bank_eventlog` MODIFY `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time'; + +ALTER TABLE `guild_eventlog` MODIFY `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'; + +ALTER TABLE `guild_finder_applicant` MODIFY `submitTime` bigint(20) DEFAULT NULL; + +ALTER TABLE `guild_newslog` MODIFY `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time'; + +ALTER TABLE `instance` MODIFY `resettime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `instance_reset` MODIFY `resettime` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `instance_scenario_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `mail` + MODIFY `expire_time` bigint(20) NOT NULL DEFAULT '0', + MODIFY `deliver_time` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `pet_spell_charges` + MODIFY `rechargeStart` bigint(20) NOT NULL DEFAULT '0', + MODIFY `rechargeEnd` bigint(20) NOT NULL DEFAULT '0'; + +ALTER TABLE `pet_spell_cooldown` + MODIFY `time` bigint(20) NOT NULL DEFAULT '0', + MODIFY `categoryEnd` bigint(20) NOT NULL DEFAULT '0'; diff --git a/sql/updates/characters/master/2021_04_05_00_charactrers.sql b/sql/updates/characters/master/2021_04_05_00_charactrers.sql deleted file mode 100644 index 5b66a62f108..00000000000 --- a/sql/updates/characters/master/2021_04_05_00_charactrers.sql +++ /dev/null @@ -1,93 +0,0 @@ -ALTER TABLE `account_data` MODIFY `time` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `account_instance_times` MODIFY `releaseTime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `auctionhouse` - MODIFY `startTime` bigint(20) NOT NULL DEFAULT '0', - MODIFY `endTime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `blackmarket_auctions` MODIFY `time` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `calendar_events` - MODIFY `Date` bigint(20) NOT NULL DEFAULT '0', - MODIFY `LockDate` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `calendar_invites` MODIFY `ResponseTime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `channels` MODIFY `lastUsed` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_account_data` MODIFY `time` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_achievement` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_achievement_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_banned` - MODIFY `bandate` bigint(20) NOT NULL DEFAULT '0', - MODIFY `unbandate` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_garrison_buildings` MODIFY `timeBuilt` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_queststatus` MODIFY `timer` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_queststatus_daily` MODIFY `time` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_queststatus_objectives_criteria_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_spell_charges` - MODIFY `rechargeStart` bigint(20) NOT NULL DEFAULT '0', - MODIFY `rechargeEnd` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `character_spell_cooldown` - MODIFY `time` bigint(20) NOT NULL DEFAULT '0', - MODIFY `categoryEnd` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `characters` - MODIFY `logout_time` bigint(20) NOT NULL DEFAULT '0', - MODIFY `resettalents_time` bigint(20) NOT NULL DEFAULT '0', - MODIFY `death_expire_time` bigint(20) NOT NULL DEFAULT '0', - MODIFY `deleteDate` bigint(20) unsigned DEFAULT NULL; - -ALTER TABLE `creature_respawn` MODIFY `respawnTime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `game_event_save` MODIFY `next_start` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `gameobject_respawn` MODIFY `respawnTime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `gm_bug` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `gm_complaint` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `gm_complaint_chatlog` MODIFY `timestamp` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `gm_suggestion` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `guild_achievement` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `guild_achievement_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `guild_bank_eventlog` MODIFY `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time'; - -ALTER TABLE `guild_eventlog` MODIFY `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'; - -ALTER TABLE `guild_finder_applicant` MODIFY `submitTime` bigint(20) DEFAULT NULL; - -ALTER TABLE `guild_newslog` MODIFY `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time'; - -ALTER TABLE `instance` MODIFY `resettime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `instance_reset` MODIFY `resettime` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `instance_scenario_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `mail` - MODIFY `expire_time` bigint(20) NOT NULL DEFAULT '0', - MODIFY `deliver_time` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `pet_spell_charges` - MODIFY `rechargeStart` bigint(20) NOT NULL DEFAULT '0', - MODIFY `rechargeEnd` bigint(20) NOT NULL DEFAULT '0'; - -ALTER TABLE `pet_spell_cooldown` - MODIFY `time` bigint(20) NOT NULL DEFAULT '0', - MODIFY `categoryEnd` bigint(20) NOT NULL DEFAULT '0'; -- cgit v1.2.3