diff options
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 |