diff options
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/3.3.5/2018_04_24_00_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/characters/3.3.5/2018_07_09_00_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/characters/3.3.5/2018_11_09_00_characters.sql | 4 | ||||
| -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'; |
