aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2019-03-19 07:20:15 +0000
committerTDB Release <tdb-release@build.bot>2019-03-19 07:20:15 +0000
commit3358cc2a4772aedf6415b5ba7ca3fdbbf808da24 (patch)
treecbf384404d28bb48b827514934d7bdf68c795d0d /sql/updates/characters
parent995aabe4bbbe17233376e7ee84a2ae52a82b424b (diff)
TDB 335.19031 - 2019/03/19TDB335.19031
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';