aboutsummaryrefslogtreecommitdiff
path: root/sql/old
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2022-06-01 10:53:46 +0000
committerTDB Release <tdb-release@build.bot>2022-06-01 10:53:46 +0000
commita7fe0494bf6d6737b0a874ceddac0e2c089a7ce8 (patch)
treeb9a6e299b5ac07d2b9a409c6b7186b3ecbea353f /sql/old
parent2237926cec890d12849b0c8af14ada6dd6c7e6aa (diff)
TDB 335.22061 - 2022/06/01TDB335.22061
Diffstat (limited to 'sql/old')
-rw-r--r--sql/old/3.3.5a/auth/22041_2022_06_01/2022_04_14_00_auth.sql2
-rw-r--r--sql/old/3.3.5a/characters/22041_2022_06_01/2022_04_14_00_characters.sql2
-rw-r--r--sql/old/3.3.5a/world/22041_2022_06_01/2022_04_14_00_world.sql3
-rw-r--r--sql/old/3.3.5a/world/22041_2022_06_01/2022_04_16_00_world.sql5
4 files changed, 12 insertions, 0 deletions
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;