From 3358cc2a4772aedf6415b5ba7ca3fdbbf808da24 Mon Sep 17 00:00:00 2001
From: TDB Release <tdb-release@build.bot>
Date: Tue, 19 Mar 2019 07:20:15 +0000
Subject: TDB 335.19031 - 2019/03/19

---
 sql/updates/characters/3.3.5/2018_02_19_00_characters.sql | 2 --
 sql/updates/characters/3.3.5/2018_04_24_00_characters.sql | 2 --
 sql/updates/characters/3.3.5/2018_07_09_00_characters.sql | 3 ---
 sql/updates/characters/3.3.5/2018_11_09_00_characters.sql | 4 ----
 sql/updates/characters/3.3.5/2019_03_19_00_characters.sql | 2 ++
 5 files changed, 2 insertions(+), 11 deletions(-)
 delete mode 100644 sql/updates/characters/3.3.5/2018_02_19_00_characters.sql
 delete mode 100644 sql/updates/characters/3.3.5/2018_04_24_00_characters.sql
 delete mode 100644 sql/updates/characters/3.3.5/2018_07_09_00_characters.sql
 delete mode 100644 sql/updates/characters/3.3.5/2018_11_09_00_characters.sql
 create mode 100644 sql/updates/characters/3.3.5/2019_03_19_00_characters.sql

(limited to 'sql/updates/characters')

diff --git a/sql/updates/characters/3.3.5/2018_02_19_00_characters.sql b/sql/updates/characters/3.3.5/2018_02_19_00_characters.sql
deleted file mode 100644
index 2dffc9ecc80..00000000000
--- a/sql/updates/characters/3.3.5/2018_02_19_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- TDB 335.64 characters
-UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2018_04_24_00_characters.sql b/sql/updates/characters/3.3.5/2018_04_24_00_characters.sql
deleted file mode 100644
index 303a1dd9ffd..00000000000
--- a/sql/updates/characters/3.3.5/2018_04_24_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
---
-UPDATE `worldstates` SET `value`=UNIX_TIMESTAMP() WHERE `entry`=20001 AND `value` < UNIX_TIMESTAMP();
diff --git a/sql/updates/characters/3.3.5/2018_07_09_00_characters.sql b/sql/updates/characters/3.3.5/2018_07_09_00_characters.sql
deleted file mode 100644
index fb4e63537b5..00000000000
--- a/sql/updates/characters/3.3.5/2018_07_09_00_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `character_queststatus`
-  ADD `itemcount5` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `itemcount4`,
-  ADD `itemcount6` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `itemcount5`;
diff --git a/sql/updates/characters/3.3.5/2018_11_09_00_characters.sql b/sql/updates/characters/3.3.5/2018_11_09_00_characters.sql
deleted file mode 100644
index 53de0b528b6..00000000000
--- a/sql/updates/characters/3.3.5/2018_11_09_00_characters.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `character_aura`
-  DROP PRIMARY KEY,
-  ADD `itemGuid` bigint(20) unsigned NOT NULL DEFAULT '0' AFTER `casterGuid`,
-  ADD PRIMARY KEY(`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`);
diff --git a/sql/updates/characters/3.3.5/2019_03_19_00_characters.sql b/sql/updates/characters/3.3.5/2019_03_19_00_characters.sql
new file mode 100644
index 00000000000..042cd92d6b6
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2019_03_19_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19031 characters
+UPDATE `updates` SET `state`='ARCHIVED';
-- 
cgit v1.2.3