diff options
Diffstat (limited to 'sql/old')
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; |