aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/3.3.5/2018_04_24_00_characters.sql2
-rw-r--r--sql/updates/characters/3.3.5/2018_07_09_00_characters.sql3
-rw-r--r--sql/updates/characters/3.3.5/2018_11_09_00_characters.sql4
-rw-r--r--sql/updates/characters/3.3.5/2019_03_19_00_characters.sql (renamed from sql/updates/characters/3.3.5/2018_02_19_00_characters.sql)2
4 files changed, 1 insertions, 10 deletions
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/2018_02_19_00_characters.sql b/sql/updates/characters/3.3.5/2019_03_19_00_characters.sql
index 2dffc9ecc80..042cd92d6b6 100644
--- a/sql/updates/characters/3.3.5/2018_02_19_00_characters.sql
+++ b/sql/updates/characters/3.3.5/2019_03_19_00_characters.sql
@@ -1,2 +1,2 @@
--- TDB 335.64 characters
+-- TDB 335.19031 characters
UPDATE `updates` SET `state`='ARCHIVED';