From a7fe0494bf6d6737b0a874ceddac0e2c089a7ce8 Mon Sep 17 00:00:00 2001
From: TDB Release <tdb-release@build.bot>
Date: Wed, 1 Jun 2022 10:53:46 +0000
Subject: TDB 335.22061 - 2022/06/01

---
 sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql          | 2 ++
 .../3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql  | 2 ++
 sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql        | 3 +++
 sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql        | 5 +++++
 4 files changed, 12 insertions(+)
 create mode 100644 sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql
 create mode 100644 sql/old/3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql
 create mode 100644 sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql
 create mode 100644 sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql

(limited to 'sql/old')

diff --git a/sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql b/sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql
new file mode 100644
index 00000000000..632b30d4531
--- /dev/null
+++ b/sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.22041 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql b/sql/old/3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql
new file mode 100644
index 00000000000..3a5b28dd092
--- /dev/null
+++ b/sql/old/3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.22041 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql b/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql
new file mode 100644
index 00000000000..f8720daf989
--- /dev/null
+++ b/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.22041 world
+UPDATE `version` SET `db_version`='TDB 335.22041', `cache_id`=22041 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql b/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql
new file mode 100644
index 00000000000..6330c80461d
--- /dev/null
+++ b/sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `waypoint_data` CHANGE `orientation` `orientation` FLOAT DEFAULT NULL NULL;
+UPDATE `waypoint_data` SET `orientation`= NULL WHERE `orientation`= 0;
+
+ALTER TABLE `waypoints` CHANGE `orientation` `orientation` FLOAT DEFAULT NULL NULL;
+UPDATE `waypoints` SET `orientation`= NULL WHERE `orientation`= 0;
-- 
cgit v1.2.3