diff options
| author | TDB Release <tdb-release@build.bot> | 2022-01-15 23:33:52 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2022-01-15 23:33:52 +0000 |
| commit | 1761f72da7a0578475cf04019f6bc772f534b89b (patch) | |
| tree | 25ff643768ee9f66bf2fdc996db3b69fa3652b87 /sql/old/9.x/characters | |
| parent | bf357312e0c4d0a68a95379ecdcbed817b136c31 (diff) | |
TDB 915.22012 - 2022/01/15TDB915.22012
Diffstat (limited to 'sql/old/9.x/characters')
| -rw-r--r-- | sql/old/9.x/characters/22011_2022_01_15/2022_01_02_00_characters.sql | 3 | ||||
| -rw-r--r-- | sql/old/9.x/characters/22011_2022_01_15/2022_01_09_00_characters.sql | 4 |
2 files changed, 7 insertions, 0 deletions
diff --git a/sql/old/9.x/characters/22011_2022_01_15/2022_01_02_00_characters.sql b/sql/old/9.x/characters/22011_2022_01_15/2022_01_02_00_characters.sql new file mode 100644 index 00000000000..ab361bdae75 --- /dev/null +++ b/sql/old/9.x/characters/22011_2022_01_15/2022_01_02_00_characters.sql @@ -0,0 +1,3 @@ +-- TDB 915.22011 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/22011_2022_01_15/2022_01_09_00_characters.sql b/sql/old/9.x/characters/22011_2022_01_15/2022_01_09_00_characters.sql new file mode 100644 index 00000000000..6cf9ad0b470 --- /dev/null +++ b/sql/old/9.x/characters/22011_2022_01_15/2022_01_09_00_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `guild_rank` + ADD COLUMN `RankOrder` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 AFTER `rid`; + +UPDATE `guild_rank` SET `RankOrder`=`rid`; -- set some unique initial value |