diff options
author | TDB Release <tdb-release@build.bot> | 2022-02-16 21:54:52 +0000 |
---|---|---|
committer | TDB Release <tdb-release@build.bot> | 2022-02-16 21:54:52 +0000 |
commit | cb8b06e836f2e4fa988caf564fdfa5c735419bfb (patch) | |
tree | aa4e336d02b437ee8847ba12754b69949a16be00 /sql | |
parent | 7861c764f4c78da5ab017c8cea5ffc5e84570f4a (diff) |
TDB 335.22021 - 2022/02/16TDB335.22021
Diffstat (limited to 'sql')
-rw-r--r-- | sql/base/auth_database.sql | 17 | ||||
-rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
-rw-r--r-- | sql/base/dev/world_database.sql | 14 | ||||
-rw-r--r-- | sql/old/3.3.5a/auth/22011_2022_02_16/2022_01_15_00_auth.sql (renamed from sql/updates/auth/3.3.5/2022_01_15_00_auth.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/characters/22011_2022_02_16/2022_01_15_00_characters.sql (renamed from sql/updates/characters/3.3.5/2022_01_15_00_characters.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_15_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_15_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_20_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_20_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_02_world.sql (renamed from sql/updates/world/3.3.5/2022_01_20_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_02_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_03_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_04_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_05_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_06_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_06_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_07_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_07_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_08_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_08_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_09_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_09_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_10_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_10_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_11_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_11_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_12_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_12_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_13_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_13_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_14_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_14_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_15_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_15_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_16_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_16_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_17_world.sql (renamed from sql/updates/world/3.3.5/2022_01_22_17_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_27_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_27_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_00_world.sql (renamed from sql/updates/world/3.3.5/2022_01_28_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_01_world.sql (renamed from sql/updates/world/3.3.5/2022_01_28_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_01_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_01_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_02_world.sql (renamed from sql/updates/world/3.3.5/2022_02_01_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_04_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_04_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_07_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_07_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_02_world.sql (renamed from sql/updates/world/3.3.5/2022_02_07_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_00_world_335.sql (renamed from sql/updates/world/3.3.5/2022_02_09_00_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_09_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_02_world.sql (renamed from sql/updates/world/3.3.5/2022_02_09_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_03_world.sql (renamed from sql/updates/world/3.3.5/2022_02_09_03_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_04_world.sql (renamed from sql/updates/world/3.3.5/2022_02_09_04_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_02_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_02_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_03_world_335.sql (renamed from sql/updates/world/3.3.5/2022_02_13_03_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_04_world_335.sql (renamed from sql/updates/world/3.3.5/2022_02_13_04_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_05_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_05_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_06_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_06_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_07_world.sql (renamed from sql/updates/world/3.3.5/2022_02_13_07_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_14_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_14_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_00_world.sql (renamed from sql/updates/world/3.3.5/2022_02_16_00_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_01_world.sql (renamed from sql/updates/world/3.3.5/2022_02_16_01_world.sql) | 0 | ||||
-rw-r--r-- | sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_02_world_335.sql (renamed from sql/updates/world/3.3.5/2022_02_16_02_world_335.sql) | 0 | ||||
-rw-r--r-- | sql/updates/auth/3.3.5/2022_02_16_00_auth.sql | 2 | ||||
-rw-r--r-- | sql/updates/characters/3.3.5/2022_02_16_00_characters.sql | 2 | ||||
-rw-r--r-- | sql/updates/world/3.3.5/2022_02_16_03_world.sql | 3 |
58 files changed, 26 insertions, 17 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 9c59ebd7291..5ab0f5d41c3 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -176,12 +176,12 @@ CREATE TABLE `build_info` ( `majorVersion` int DEFAULT NULL, `minorVersion` int DEFAULT NULL, `bugfixVersion` int DEFAULT NULL, - `hotfixVersion` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `winAuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `win64AuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `mac64AuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `winChecksumSeed` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `macChecksumSeed` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `hotfixVersion` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `winAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `win64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `mac64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `winChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `macChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`build`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1998,7 +1998,8 @@ INSERT INTO `updates` VALUES ('2021_11_15_00_auth.sql','82D88B06301130C7149E21A991364F62279E219B','ARCHIVED','2021-11-15 16:22:37',0), ('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0), ('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','ARCHIVED','2022-01-01 19:35:19',0), -('2022_01_15_00_auth.sql','A2123CEC10327ECA4C92A8B2212AEE25B43C457B','ARCHIVED','2022-01-15 18:05:55',0); +('2022_01_15_00_auth.sql','A2123CEC10327ECA4C92A8B2212AEE25B43C457B','ARCHIVED','2022-01-15 18:05:55',0), +('2022_02_16_00_auth.sql','CFB54EB37319916B1B80E29F5572D12A7D9A33F5','ARCHIVED','2022-02-16 21:52:01',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2137,4 +2138,4 @@ SET character_set_client = @saved_cs_client; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-15 18:05:58 +-- Dump completed on 2022-02-16 21:52:04 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 5a3b41b5b25..d37088cbf06 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2671,7 +2671,8 @@ INSERT INTO `updates` VALUES ('2021_10_15_00_characters.sql','174355CFEA8FADA50B731F54E028561AFCF46AA6','ARCHIVED','2021-10-15 08:43:41',0), ('2021_11_15_00_characters.sql','4C911C08E2E7A22E9A2FFC0AAC05481574D8048E','ARCHIVED','2021-11-15 16:22:37',0), ('2021_12_16_00_characters.sql','C250DF213B43FC2186520C3901C0A1FBF522BBDF','ARCHIVED','2021-12-16 21:17:10',0), -('2022_01_15_00_characters.sql','351DEB60A6BB87FD9ED5D097E15ADBC32424C58A','ARCHIVED','2022-01-15 18:05:55',0); +('2022_01_15_00_characters.sql','351DEB60A6BB87FD9ED5D097E15ADBC32424C58A','ARCHIVED','2022-01-15 18:05:55',0), +('2022_02_16_00_characters.sql','3086FE1DB569830190013FE0129F9CF072C12D6A','ARCHIVED','2022-02-16 21:52:01',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2842,4 +2843,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-15 18:05:59 +-- Dump completed on 2022-02-16 21:52:04 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 2b7e24268a1..b51d070b22a 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -248,7 +248,7 @@ CREATE TABLE `broadcast_text` ( `SoundEntriesID` mediumint unsigned NOT NULL DEFAULT '0', `EmotesID` mediumint unsigned NOT NULL DEFAULT '0', `Flags` mediumint unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1161,7 +1161,7 @@ CREATE TABLE `game_tele` ( `map` smallint unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=1433 DEFAULT CHARSET=utf8mb3 COMMENT='Tele Command'; +) ENGINE=MyISAM AUTO_INCREMENT=1517 DEFAULT CHARSET=utf8mb3 COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2091,7 +2091,7 @@ CREATE TABLE `page_text` ( `ID` mediumint unsigned NOT NULL DEFAULT '0', `Text` longtext NOT NULL, `NextPageID` mediumint unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2539,7 +2539,7 @@ CREATE TABLE `quest_details` ( `EmoteDelay2` int unsigned NOT NULL DEFAULT '0', `EmoteDelay3` int unsigned NOT NULL DEFAULT '0', `EmoteDelay4` int unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2611,7 +2611,7 @@ CREATE TABLE `quest_offer_reward` ( `EmoteDelay3` int unsigned NOT NULL DEFAULT '0', `EmoteDelay4` int unsigned NOT NULL DEFAULT '0', `RewardText` text, - `VerifiedBuild` smallint NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2716,7 +2716,7 @@ CREATE TABLE `quest_request_items` ( `EmoteOnComplete` smallint unsigned NOT NULL DEFAULT '0', `EmoteOnIncomplete` smallint unsigned NOT NULL DEFAULT '0', `CompletionText` text, - `VerifiedBuild` smallint NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4061,4 +4061,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-15 18:06:00 +-- Dump completed on 2022-02-16 21:52:05 diff --git a/sql/updates/auth/3.3.5/2022_01_15_00_auth.sql b/sql/old/3.3.5a/auth/22011_2022_02_16/2022_01_15_00_auth.sql index 8bff20717e3..8bff20717e3 100644 --- a/sql/updates/auth/3.3.5/2022_01_15_00_auth.sql +++ b/sql/old/3.3.5a/auth/22011_2022_02_16/2022_01_15_00_auth.sql diff --git a/sql/updates/characters/3.3.5/2022_01_15_00_characters.sql b/sql/old/3.3.5a/characters/22011_2022_02_16/2022_01_15_00_characters.sql index b2177772ff9..b2177772ff9 100644 --- a/sql/updates/characters/3.3.5/2022_01_15_00_characters.sql +++ b/sql/old/3.3.5a/characters/22011_2022_02_16/2022_01_15_00_characters.sql diff --git a/sql/updates/world/3.3.5/2022_01_15_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_15_00_world.sql index e3136864532..e3136864532 100644 --- a/sql/updates/world/3.3.5/2022_01_15_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_15_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_20_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_00_world.sql index 713c712c00f..713c712c00f 100644 --- a/sql/updates/world/3.3.5/2022_01_20_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_20_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_01_world.sql index 4a89d6e560b..4a89d6e560b 100644 --- a/sql/updates/world/3.3.5/2022_01_20_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_20_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_02_world.sql index ad281306bd2..ad281306bd2 100644 --- a/sql/updates/world/3.3.5/2022_01_20_02_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_20_02_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_00_world.sql index 3210693f075..3210693f075 100644 --- a/sql/updates/world/3.3.5/2022_01_22_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_01_world.sql index f8d147109b9..f8d147109b9 100644 --- a/sql/updates/world/3.3.5/2022_01_22_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_02_world.sql index 7da02c90af8..7da02c90af8 100644 --- a/sql/updates/world/3.3.5/2022_01_22_02_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_02_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_03_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_03_world.sql index 0ac0a87c749..0ac0a87c749 100644 --- a/sql/updates/world/3.3.5/2022_01_22_03_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_03_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_04_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_04_world.sql index 22b2b8caceb..22b2b8caceb 100644 --- a/sql/updates/world/3.3.5/2022_01_22_04_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_04_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_05_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_05_world.sql index 433262a75cb..433262a75cb 100644 --- a/sql/updates/world/3.3.5/2022_01_22_05_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_05_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_06_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_06_world.sql index 9ac13403b1f..9ac13403b1f 100644 --- a/sql/updates/world/3.3.5/2022_01_22_06_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_06_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_07_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_07_world.sql index df971683f62..df971683f62 100644 --- a/sql/updates/world/3.3.5/2022_01_22_07_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_07_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_08_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_08_world.sql index 85f46bd5fc3..85f46bd5fc3 100644 --- a/sql/updates/world/3.3.5/2022_01_22_08_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_08_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_09_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_09_world.sql index 2226055c4eb..2226055c4eb 100644 --- a/sql/updates/world/3.3.5/2022_01_22_09_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_09_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_10_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_10_world.sql index b336213a81a..b336213a81a 100644 --- a/sql/updates/world/3.3.5/2022_01_22_10_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_10_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_11_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_11_world.sql index 37717c06e00..37717c06e00 100644 --- a/sql/updates/world/3.3.5/2022_01_22_11_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_11_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_12_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_12_world.sql index af20a251b01..af20a251b01 100644 --- a/sql/updates/world/3.3.5/2022_01_22_12_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_12_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_13_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_13_world.sql index e0a8f25408b..e0a8f25408b 100644 --- a/sql/updates/world/3.3.5/2022_01_22_13_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_13_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_14_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_14_world.sql index faba9f82e26..faba9f82e26 100644 --- a/sql/updates/world/3.3.5/2022_01_22_14_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_14_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_15_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_15_world.sql index 7b8df2978a2..7b8df2978a2 100644 --- a/sql/updates/world/3.3.5/2022_01_22_15_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_15_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_16_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_16_world.sql index 03c92f08535..03c92f08535 100644 --- a/sql/updates/world/3.3.5/2022_01_22_16_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_16_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_22_17_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_17_world.sql index 0818a2c5653..0818a2c5653 100644 --- a/sql/updates/world/3.3.5/2022_01_22_17_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_22_17_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_27_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_00_world.sql index e75a500850a..e75a500850a 100644 --- a/sql/updates/world/3.3.5/2022_01_27_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_27_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_01_world.sql index f259b26ef46..f259b26ef46 100644 --- a/sql/updates/world/3.3.5/2022_01_27_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_27_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_28_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_00_world.sql index 0f27c8b6db4..0f27c8b6db4 100644 --- a/sql/updates/world/3.3.5/2022_01_28_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_01_28_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_01_world.sql index 9d06b273937..9d06b273937 100644 --- a/sql/updates/world/3.3.5/2022_01_28_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_01_28_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_01_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_00_world.sql index aa8e6b53f6f..aa8e6b53f6f 100644 --- a/sql/updates/world/3.3.5/2022_02_01_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_01_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_01_world.sql index 124a74b5a1b..124a74b5a1b 100644 --- a/sql/updates/world/3.3.5/2022_02_01_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_01_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_02_world.sql index 596872decc2..596872decc2 100644 --- a/sql/updates/world/3.3.5/2022_02_01_02_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_01_02_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_04_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_04_00_world.sql index 1cb5625b9d4..1cb5625b9d4 100644 --- a/sql/updates/world/3.3.5/2022_02_04_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_04_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_07_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_00_world.sql index 3a2468c72ea..3a2468c72ea 100644 --- a/sql/updates/world/3.3.5/2022_02_07_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_07_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_01_world.sql index 6ec01b0970a..6ec01b0970a 100644 --- a/sql/updates/world/3.3.5/2022_02_07_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_07_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_02_world.sql index 7203ab5a15a..7203ab5a15a 100644 --- a/sql/updates/world/3.3.5/2022_02_07_02_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_07_02_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_09_00_world_335.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_00_world_335.sql index 38a2fcfc675..38a2fcfc675 100644 --- a/sql/updates/world/3.3.5/2022_02_09_00_world_335.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_00_world_335.sql diff --git a/sql/updates/world/3.3.5/2022_02_09_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_01_world.sql index 4311fe2f28f..4311fe2f28f 100644 --- a/sql/updates/world/3.3.5/2022_02_09_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_09_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_02_world.sql index 81f7637513f..81f7637513f 100644 --- a/sql/updates/world/3.3.5/2022_02_09_02_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_02_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_09_03_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_03_world.sql index a4527c87588..a4527c87588 100644 --- a/sql/updates/world/3.3.5/2022_02_09_03_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_03_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_09_04_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_04_world.sql index 23270828415..23270828415 100644 --- a/sql/updates/world/3.3.5/2022_02_09_04_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_09_04_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_13_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_00_world.sql index 5b7f385a9db..5b7f385a9db 100644 --- a/sql/updates/world/3.3.5/2022_02_13_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_13_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_01_world.sql index 5e8eba143db..5e8eba143db 100644 --- a/sql/updates/world/3.3.5/2022_02_13_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_13_02_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_02_world.sql index 452eb014602..452eb014602 100644 --- a/sql/updates/world/3.3.5/2022_02_13_02_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_02_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_13_03_world_335.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_03_world_335.sql index 4bd057618ed..4bd057618ed 100644 --- a/sql/updates/world/3.3.5/2022_02_13_03_world_335.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_03_world_335.sql diff --git a/sql/updates/world/3.3.5/2022_02_13_04_world_335.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_04_world_335.sql index b94ed933d5b..b94ed933d5b 100644 --- a/sql/updates/world/3.3.5/2022_02_13_04_world_335.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_04_world_335.sql diff --git a/sql/updates/world/3.3.5/2022_02_13_05_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_05_world.sql index 0a477f5130b..0a477f5130b 100644 --- a/sql/updates/world/3.3.5/2022_02_13_05_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_05_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_13_06_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_06_world.sql index eb2bdbefbb9..eb2bdbefbb9 100644 --- a/sql/updates/world/3.3.5/2022_02_13_06_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_06_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_13_07_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_07_world.sql index 5b2226ab117..5b2226ab117 100644 --- a/sql/updates/world/3.3.5/2022_02_13_07_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_13_07_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_14_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_14_00_world.sql index 1316f6f5b7b..1316f6f5b7b 100644 --- a/sql/updates/world/3.3.5/2022_02_14_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_14_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_16_00_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_00_world.sql index eb4333a71c9..eb4333a71c9 100644 --- a/sql/updates/world/3.3.5/2022_02_16_00_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_00_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_16_01_world.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_01_world.sql index 46050344013..46050344013 100644 --- a/sql/updates/world/3.3.5/2022_02_16_01_world.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_01_world.sql diff --git a/sql/updates/world/3.3.5/2022_02_16_02_world_335.sql b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_02_world_335.sql index 7b5e1586000..7b5e1586000 100644 --- a/sql/updates/world/3.3.5/2022_02_16_02_world_335.sql +++ b/sql/old/3.3.5a/world/22011_2022_02_16/2022_02_16_02_world_335.sql diff --git a/sql/updates/auth/3.3.5/2022_02_16_00_auth.sql b/sql/updates/auth/3.3.5/2022_02_16_00_auth.sql new file mode 100644 index 00000000000..40685cc583a --- /dev/null +++ b/sql/updates/auth/3.3.5/2022_02_16_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.22021 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2022_02_16_00_characters.sql b/sql/updates/characters/3.3.5/2022_02_16_00_characters.sql new file mode 100644 index 00000000000..c50d58c6500 --- /dev/null +++ b/sql/updates/characters/3.3.5/2022_02_16_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.22021 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2022_02_16_03_world.sql b/sql/updates/world/3.3.5/2022_02_16_03_world.sql new file mode 100644 index 00000000000..e21707dbfe4 --- /dev/null +++ b/sql/updates/world/3.3.5/2022_02_16_03_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.22021 world +UPDATE `version` SET `db_version`='TDB 335.22021', `cache_id`=22021 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; |