diff options
| author | TDB Release <tdb-release@build.bot> | 2021-11-17 13:31:04 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2021-11-17 13:31:04 +0000 |
| commit | 06b9be494a7e4d1249d11550cc0eec2e35712d25 (patch) | |
| tree | eca810e65b14530059c8930cda77e77ff8f3999d /sql/old/9.x/characters | |
| parent | f83c40a5028e01135ee30c06e87a9efe1a911806 (diff) | |
TDB 915.21111 - 2021/11/17TDB915.21111
Diffstat (limited to 'sql/old/9.x/characters')
4 files changed, 9 insertions, 0 deletions
diff --git a/sql/old/9.x/characters/21101_2021_11_17/2021_10_15_00_characters.sql b/sql/old/9.x/characters/21101_2021_11_17/2021_10_15_00_characters.sql new file mode 100644 index 00000000000..0b929d6c9bc --- /dev/null +++ b/sql/old/9.x/characters/21101_2021_11_17/2021_10_15_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 910.21101 characters +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/characters', 'ARCHIVED'); diff --git a/sql/old/9.x/characters/21101_2021_11_17/2021_10_16_00_characters.sql b/sql/old/9.x/characters/21101_2021_11_17/2021_10_16_00_characters.sql new file mode 100644 index 00000000000..b92c1b58ac0 --- /dev/null +++ b/sql/old/9.x/characters/21101_2021_11_17/2021_10_16_00_characters.sql @@ -0,0 +1,2 @@ +-- +ALTER TABLE `character_homebind` ADD `orientation` float NOT NULL DEFAULT '0' AFTER `posZ`; diff --git a/sql/old/9.x/characters/21101_2021_11_17/2021_11_02_00_characters.sql b/sql/old/9.x/characters/21101_2021_11_17/2021_11_02_00_characters.sql new file mode 100644 index 00000000000..f8e5f9f171f --- /dev/null +++ b/sql/old/9.x/characters/21101_2021_11_17/2021_11_02_00_characters.sql @@ -0,0 +1,2 @@ +DROP TABLE IF EXISTS `guild_finder_applicant`; +DROP TABLE IF EXISTS `guild_finder_guild_settings`; diff --git a/sql/old/9.x/characters/21101_2021_11_17/2021_11_04_00_characters.sql b/sql/old/9.x/characters/21101_2021_11_17/2021_11_04_00_characters.sql new file mode 100644 index 00000000000..e6db9872f42 --- /dev/null +++ b/sql/old/9.x/characters/21101_2021_11_17/2021_11_04_00_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE `characters` ADD `power7` int(10) unsigned NOT NULL DEFAULT '0' AFTER `power6`; +ALTER TABLE `character_stats` ADD `maxpower7` int(10) unsigned NOT NULL DEFAULT '0' AFTER `maxpower6`; |