aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql5
-rw-r--r--sql/base/characters_database.sql5
-rw-r--r--sql/base/dev/world_database.sql6
-rw-r--r--sql/old/3.3.5a/auth/21081_2021_09_28/2021_08_15_00_auth.sql (renamed from sql/updates/auth/3.3.5/2021_08_15_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/characters/21081_2021_09_28/2021_08_15_00_characters.sql (renamed from sql/updates/characters/3.3.5/2021_08_15_00_characters.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_00_world.sql (renamed from sql/updates/world/3.3.5/2021_08_15_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_01_world.sql (renamed from sql/updates/world/3.3.5/2021_08_15_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_02_world.sql (renamed from sql/updates/world/3.3.5/2021_08_15_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_15_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_00_world.sql (renamed from sql/updates/world/3.3.5/2021_08_16_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_01_world.sql (renamed from sql/updates/world/3.3.5/2021_08_16_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_16_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_00_world.sql (renamed from sql/updates/world/3.3.5/2021_08_19_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_01_world.sql (renamed from sql/updates/world/3.3.5/2021_08_19_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_02_world.sql (renamed from sql/updates/world/3.3.5/2021_08_19_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_03_world.sql (renamed from sql/updates/world/3.3.5/2021_08_19_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_00_world.sql (renamed from sql/updates/world/3.3.5/2021_08_20_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_20_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_20_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_03_world.sql (renamed from sql/updates/world/3.3.5/2021_08_20_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_22_00_world.sql (renamed from sql/updates/world/3.3.5/2021_08_22_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_22_01_world.sql (renamed from sql/updates/world/3.3.5/2021_08_22_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_23_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_23_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_00_world.sql (renamed from sql/updates/world/3.3.5/2021_08_24_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_01_world.sql (renamed from sql/updates/world/3.3.5/2021_08_24_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_24_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_24_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_29_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_29_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_29_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_29_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_00_world.sql (renamed from sql/updates/world/3.3.5/2021_08_31_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_01_world.sql (renamed from sql/updates/world/3.3.5/2021_08_31_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_31_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_08_31_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_04_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_04_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_05_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_01_world.sql (renamed from sql/updates/world/3.3.5/2021_09_05_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_02_world.sql (renamed from sql/updates/world/3.3.5/2021_09_05_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_01_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_02_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_03_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_04_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_05_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_06_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_07_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_08_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_09_08_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_09_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_09_09_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_10_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_10_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_11_world.sql (renamed from sql/updates/world/3.3.5/2021_09_09_11_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_11_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_11_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_00_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_13_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_13_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_13_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_19_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_19_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_21_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_01_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_21_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_02_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_21_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_03_world_335.sql (renamed from sql/updates/world/3.3.5/2021_09_21_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_23_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_23_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_23_01_world.sql (renamed from sql/updates/world/3.3.5/2021_09_23_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_25_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_25_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_26_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_01_world.sql (renamed from sql/updates/world/3.3.5/2021_09_26_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_02_world.sql (renamed from sql/updates/world/3.3.5/2021_09_26_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_03_world.sql (renamed from sql/updates/world/3.3.5/2021_09_26_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_27_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_27_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/21081_2021_09_28/2021_09_28_00_world.sql (renamed from sql/updates/world/3.3.5/2021_09_28_00_world.sql)0
-rw-r--r--sql/updates/auth/3.3.5/2021_09_28_00_auth.sql2
-rw-r--r--sql/updates/characters/3.3.5/2021_09_28_00_characters.sql2
-rw-r--r--sql/updates/world/3.3.5/2021_09_28_01_world.sql3
72 files changed, 16 insertions, 7 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 2ce87dfe2d9..9e5e9a975bc 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1992,7 +1992,8 @@ INSERT INTO `updates` VALUES
('2021_06_15_00_auth.sql','DAFFA7699D3BF0A15AE72321AFC9F7D22F33B65C','ARCHIVED','2021-06-15 11:53:33',0),
('2021_06_20_00_auth.sql','7CA418D570DC1444C19AAD18F4A50FF187642310','ARCHIVED','2021-06-20 17:29:17',0),
('2021_07_15_00_auth.sql','C8B29D477A5A6704775517EF8203871BFE3D4906','ARCHIVED','2021-07-15 07:32:48',0),
-('2021_08_15_00_auth.sql','256E06BF052C246B92B61AD7DD6233D98EEA6E9E','ARCHIVED','2021-08-15 16:59:31',0);
+('2021_08_15_00_auth.sql','256E06BF052C246B92B61AD7DD6233D98EEA6E9E','ARCHIVED','2021-08-15 16:59:31',0),
+('2021_09_28_00_auth.sql','07B3ECF2EBAF1F1C3692059CB3A05B1088A93E18','ARCHIVED','2021-09-28 20:48:10',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2131,4 +2132,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 2021-08-15 16:59:38
+-- Dump completed on 2021-09-28 20:48:13
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 3a9fc9b4a75..65e1d98bea8 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2666,7 +2666,8 @@ INSERT INTO `updates` VALUES
('2021_06_15_00_characters.sql','4432846E2B0769C01E2B333EEDD90ABA44BF2BC1','ARCHIVED','2021-06-15 11:53:33',0),
('2021_07_15_00_characters.sql','2ACFF71253DEA0F059476AEA52A55196E6D5DCFE','ARCHIVED','2021-07-15 07:32:48',0),
('2021_07_18_00_characters.sql','0BA579ED21F4E75AC2B4797421B5029568B3F6E2','ARCHIVED','2021-07-18 11:55:00',0),
-('2021_08_15_00_characters.sql','A8A32D47C65FB6A0C7995F8342D85B6A50C6C63F','ARCHIVED','2021-08-15 16:59:31',0);
+('2021_08_15_00_characters.sql','A8A32D47C65FB6A0C7995F8342D85B6A50C6C63F','ARCHIVED','2021-08-15 16:59:31',0),
+('2021_09_28_00_characters.sql','A57869AE14FFFA935AB57318F65F4F1217AA2421','ARCHIVED','2021-09-28 20:48:10',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2837,4 +2838,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-08-15 16:59:38
+-- Dump completed on 2021-09-28 20:48:13
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 5c254adf21f..254a4a4871b 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -3385,8 +3385,8 @@ DROP TABLE IF EXISTS `spell_learn_spell`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `spell_learn_spell` (
- `entry` smallint(5) unsigned NOT NULL DEFAULT '0',
- `SpellID` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `entry` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellID` int(10) unsigned NOT NULL DEFAULT '0',
`Active` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`entry`,`SpellID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
@@ -4044,4 +4044,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2021-08-15 16:59:38
+-- Dump completed on 2021-09-28 20:48:13
diff --git a/sql/updates/auth/3.3.5/2021_08_15_00_auth.sql b/sql/old/3.3.5a/auth/21081_2021_09_28/2021_08_15_00_auth.sql
index 15b9aae388e..15b9aae388e 100644
--- a/sql/updates/auth/3.3.5/2021_08_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/21081_2021_09_28/2021_08_15_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2021_08_15_00_characters.sql b/sql/old/3.3.5a/characters/21081_2021_09_28/2021_08_15_00_characters.sql
index c4fcffe109d..c4fcffe109d 100644
--- a/sql/updates/characters/3.3.5/2021_08_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/21081_2021_09_28/2021_08_15_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2021_08_15_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_00_world.sql
index e9c7cea0c3d..e9c7cea0c3d 100644
--- a/sql/updates/world/3.3.5/2021_08_15_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_15_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_01_world.sql
index d777a6e5753..d777a6e5753 100644
--- a/sql/updates/world/3.3.5/2021_08_15_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_15_02_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_02_world.sql
index 0a653a349f1..0a653a349f1 100644
--- a/sql/updates/world/3.3.5/2021_08_15_02_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_15_03_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_03_world_335.sql
index e18cc0921a0..e18cc0921a0 100644
--- a/sql/updates/world/3.3.5/2021_08_15_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_15_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_16_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_00_world.sql
index e7cf032d6e2..e7cf032d6e2 100644
--- a/sql/updates/world/3.3.5/2021_08_16_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_16_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_01_world.sql
index 2d90af21ede..2d90af21ede 100644
--- a/sql/updates/world/3.3.5/2021_08_16_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_16_02_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_02_world_335.sql
index 4f155b51d2d..4f155b51d2d 100644
--- a/sql/updates/world/3.3.5/2021_08_16_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_16_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_19_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_00_world.sql
index 39775ff2e19..39775ff2e19 100644
--- a/sql/updates/world/3.3.5/2021_08_19_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_19_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_01_world.sql
index f52558b64a2..f52558b64a2 100644
--- a/sql/updates/world/3.3.5/2021_08_19_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_19_02_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_02_world.sql
index 94074a7bd6c..94074a7bd6c 100644
--- a/sql/updates/world/3.3.5/2021_08_19_02_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_19_03_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_03_world.sql
index e7aaba311e1..e7aaba311e1 100644
--- a/sql/updates/world/3.3.5/2021_08_19_03_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_19_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_20_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_00_world.sql
index e57e0f687f5..e57e0f687f5 100644
--- a/sql/updates/world/3.3.5/2021_08_20_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_20_01_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_01_world_335.sql
index f55d12352ce..f55d12352ce 100644
--- a/sql/updates/world/3.3.5/2021_08_20_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_20_02_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_02_world_335.sql
index 1b5c84a0e0c..1b5c84a0e0c 100644
--- a/sql/updates/world/3.3.5/2021_08_20_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_20_03_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_03_world.sql
index e07086fc7a3..e07086fc7a3 100644
--- a/sql/updates/world/3.3.5/2021_08_20_03_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_20_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_22_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_22_00_world.sql
index 409a3e39b20..409a3e39b20 100644
--- a/sql/updates/world/3.3.5/2021_08_22_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_22_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_22_01_world.sql
index 9b27ad523f4..9b27ad523f4 100644
--- a/sql/updates/world/3.3.5/2021_08_22_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_22_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_23_00_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_23_00_world_335.sql
index 4e75f9d1316..4e75f9d1316 100644
--- a/sql/updates/world/3.3.5/2021_08_23_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_23_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_24_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_00_world.sql
index adeb782a58e..adeb782a58e 100644
--- a/sql/updates/world/3.3.5/2021_08_24_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_24_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_01_world.sql
index e3742e63121..e3742e63121 100644
--- a/sql/updates/world/3.3.5/2021_08_24_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_24_02_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_02_world_335.sql
index 937d24d2c9a..937d24d2c9a 100644
--- a/sql/updates/world/3.3.5/2021_08_24_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_24_03_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_03_world_335.sql
index 59b8b72830c..59b8b72830c 100644
--- a/sql/updates/world/3.3.5/2021_08_24_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_24_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_29_00_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_00_world_335.sql
index 9aa5a8ea60a..9aa5a8ea60a 100644
--- a/sql/updates/world/3.3.5/2021_08_29_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_29_01_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_01_world_335.sql
index f4418d11900..f4418d11900 100644
--- a/sql/updates/world/3.3.5/2021_08_29_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_29_02_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_02_world_335.sql
index 09b7be5c61b..09b7be5c61b 100644
--- a/sql/updates/world/3.3.5/2021_08_29_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_29_03_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_03_world_335.sql
index 06d75ad28d5..06d75ad28d5 100644
--- a/sql/updates/world/3.3.5/2021_08_29_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_29_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_31_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_00_world.sql
index aa4dd0b3b99..aa4dd0b3b99 100644
--- a/sql/updates/world/3.3.5/2021_08_31_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_31_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_01_world.sql
index 6f0e8173cd9..6f0e8173cd9 100644
--- a/sql/updates/world/3.3.5/2021_08_31_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_08_31_02_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_02_world_335.sql
index 58787ee1b64..58787ee1b64 100644
--- a/sql/updates/world/3.3.5/2021_08_31_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_08_31_03_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_03_world_335.sql
index eff030af4ce..eff030af4ce 100644
--- a/sql/updates/world/3.3.5/2021_08_31_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_08_31_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_04_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_04_00_world.sql
index 9b6018789fc..9b6018789fc 100644
--- a/sql/updates/world/3.3.5/2021_09_04_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_05_00_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_00_world_335.sql
index f4cf96771ac..f4cf96771ac 100644
--- a/sql/updates/world/3.3.5/2021_09_05_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_05_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_01_world.sql
index 7e9aba42037..7e9aba42037 100644
--- a/sql/updates/world/3.3.5/2021_09_05_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_05_02_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_02_world.sql
index fc1747dfd89..fc1747dfd89 100644
--- a/sql/updates/world/3.3.5/2021_09_05_02_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_05_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_00_world.sql
index 17f8ad8e101..17f8ad8e101 100644
--- a/sql/updates/world/3.3.5/2021_09_09_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_01_world.sql
index b8ada2a8a11..b8ada2a8a11 100644
--- a/sql/updates/world/3.3.5/2021_09_09_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_02_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_02_world.sql
index ee1b45fd1dc..ee1b45fd1dc 100644
--- a/sql/updates/world/3.3.5/2021_09_09_02_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_03_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_03_world.sql
index e9d0c0d9a30..e9d0c0d9a30 100644
--- a/sql/updates/world/3.3.5/2021_09_09_03_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_04_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_04_world.sql
index ea7d1485d0c..ea7d1485d0c 100644
--- a/sql/updates/world/3.3.5/2021_09_09_04_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_04_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_05_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_05_world.sql
index 74710d87449..74710d87449 100644
--- a/sql/updates/world/3.3.5/2021_09_09_05_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_05_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_06_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_06_world.sql
index a32b740ab2a..a32b740ab2a 100644
--- a/sql/updates/world/3.3.5/2021_09_09_06_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_06_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_07_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_07_world.sql
index a008d3199c5..a008d3199c5 100644
--- a/sql/updates/world/3.3.5/2021_09_09_07_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_07_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_08_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_08_world_335.sql
index 1c74ed41c7c..1c74ed41c7c 100644
--- a/sql/updates/world/3.3.5/2021_09_09_08_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_08_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_09_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_09_world_335.sql
index ad8955825a4..ad8955825a4 100644
--- a/sql/updates/world/3.3.5/2021_09_09_09_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_09_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_10_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_10_world.sql
index 5a3c28e7a78..5a3c28e7a78 100644
--- a/sql/updates/world/3.3.5/2021_09_09_10_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_10_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_09_11_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_11_world.sql
index f41335c6172..f41335c6172 100644
--- a/sql/updates/world/3.3.5/2021_09_09_11_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_09_11_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_11_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_11_00_world.sql
index 39a5097bfa3..39a5097bfa3 100644
--- a/sql/updates/world/3.3.5/2021_09_11_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_11_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_13_00_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_00_world_335.sql
index ee5b888691d..ee5b888691d 100644
--- a/sql/updates/world/3.3.5/2021_09_13_00_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_13_01_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_01_world_335.sql
index b488dea7956..b488dea7956 100644
--- a/sql/updates/world/3.3.5/2021_09_13_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_13_02_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_02_world_335.sql
index 56775f7c812..56775f7c812 100644
--- a/sql/updates/world/3.3.5/2021_09_13_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_13_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_19_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_19_00_world.sql
index a729811db30..a729811db30 100644
--- a/sql/updates/world/3.3.5/2021_09_19_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_19_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_21_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_00_world.sql
index 309ec0650ad..309ec0650ad 100644
--- a/sql/updates/world/3.3.5/2021_09_21_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_21_01_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_01_world_335.sql
index 636dcf811a2..636dcf811a2 100644
--- a/sql/updates/world/3.3.5/2021_09_21_01_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_21_02_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_02_world_335.sql
index 71e77fc7b93..71e77fc7b93 100644
--- a/sql/updates/world/3.3.5/2021_09_21_02_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_21_03_world_335.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_03_world_335.sql
index 6a2cae3d0c2..6a2cae3d0c2 100644
--- a/sql/updates/world/3.3.5/2021_09_21_03_world_335.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_21_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2021_09_23_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_23_00_world.sql
index f208ac976d2..f208ac976d2 100644
--- a/sql/updates/world/3.3.5/2021_09_23_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_23_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_23_01_world.sql
index 139e3ae3751..139e3ae3751 100644
--- a/sql/updates/world/3.3.5/2021_09_23_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_23_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_25_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_25_00_world.sql
index 630043f760a..630043f760a 100644
--- a/sql/updates/world/3.3.5/2021_09_25_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_25_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_26_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_00_world.sql
index 264e351cc9d..264e351cc9d 100644
--- a/sql/updates/world/3.3.5/2021_09_26_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_26_01_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_01_world.sql
index 693e3eead68..693e3eead68 100644
--- a/sql/updates/world/3.3.5/2021_09_26_01_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_01_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_26_02_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_02_world.sql
index 4b4171da092..4b4171da092 100644
--- a/sql/updates/world/3.3.5/2021_09_26_02_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_02_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_26_03_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_03_world.sql
index 9be7553cc9d..9be7553cc9d 100644
--- a/sql/updates/world/3.3.5/2021_09_26_03_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_26_03_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_27_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_27_00_world.sql
index 1ded1133260..1ded1133260 100644
--- a/sql/updates/world/3.3.5/2021_09_27_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2021_09_28_00_world.sql b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_28_00_world.sql
index dea8b852c66..dea8b852c66 100644
--- a/sql/updates/world/3.3.5/2021_09_28_00_world.sql
+++ b/sql/old/3.3.5a/world/21081_2021_09_28/2021_09_28_00_world.sql
diff --git a/sql/updates/auth/3.3.5/2021_09_28_00_auth.sql b/sql/updates/auth/3.3.5/2021_09_28_00_auth.sql
new file mode 100644
index 00000000000..59d08fb98b4
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2021_09_28_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21091 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2021_09_28_00_characters.sql b/sql/updates/characters/3.3.5/2021_09_28_00_characters.sql
new file mode 100644
index 00000000000..b8f2d6228f7
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2021_09_28_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.21091 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2021_09_28_01_world.sql b/sql/updates/world/3.3.5/2021_09_28_01_world.sql
new file mode 100644
index 00000000000..59569c06bf9
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_09_28_01_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.21091 world
+UPDATE `version` SET `db_version`='TDB 335.21091', `cache_id`=21091 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';