diff options
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/master/2022_09_18_00_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_10_03_00_characters.sql | 30 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_10_03_01_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_10_03_02_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_11_20_00_characters.sql (renamed from sql/updates/characters/master/2022_08_21_00_characters.sql) | 2 |
5 files changed, 1 insertions, 36 deletions
diff --git a/sql/updates/characters/master/2022_09_18_00_characters.sql b/sql/updates/characters/master/2022_09_18_00_characters.sql deleted file mode 100644 index c87d83fa1f6..00000000000 --- a/sql/updates/characters/master/2022_09_18_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `character_action` MODIFY `action` bigint unsigned NOT NULL DEFAULT 0; diff --git a/sql/updates/characters/master/2022_10_03_00_characters.sql b/sql/updates/characters/master/2022_10_03_00_characters.sql deleted file mode 100644 index ab8c334882c..00000000000 --- a/sql/updates/characters/master/2022_10_03_00_characters.sql +++ /dev/null @@ -1,30 +0,0 @@ --- --- Table structure for table `character_instance_lock` --- -DROP TABLE IF EXISTS `character_instance_lock`; -CREATE TABLE `character_instance_lock` ( - `guid` bigint unsigned NOT NULL, - `mapId` int unsigned NOT NULL, - `lockId` int unsigned NOT NULL, - `instanceId` int unsigned DEFAULT NULL, - `difficulty` tinyint unsigned DEFAULT NULL, - `data` text COLLATE utf8mb4_unicode_ci, - `completedEncountersMask` int unsigned DEFAULT NULL, - `entranceWorldSafeLocId` int unsigned DEFAULT NULL, - `expiryTime` bigint unsigned DEFAULT NULL, - `extended` tinyint unsigned DEFAULT NULL, - PRIMARY KEY (`guid`,`mapId`,`lockId`), - UNIQUE KEY `uk_character_instanceId` (`guid`,`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; - --- --- Table structure for table `instance` --- -DROP TABLE IF EXISTS `instance`; -CREATE TABLE `instance` ( - `instanceId` int unsigned NOT NULL, - `data` text COLLATE utf8mb4_unicode_ci, - `completedEncountersMask` int unsigned DEFAULT NULL, - `entranceWorldSafeLocId` int unsigned DEFAULT NULL, - PRIMARY KEY (`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/sql/updates/characters/master/2022_10_03_01_characters.sql b/sql/updates/characters/master/2022_10_03_01_characters.sql deleted file mode 100644 index 7883656f3c7..00000000000 --- a/sql/updates/characters/master/2022_10_03_01_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -DROP TABLE IF EXISTS `character_instance`; -DROP TABLE IF EXISTS `group_instance`; -DROP TABLE IF EXISTS `instance_reset`; diff --git a/sql/updates/characters/master/2022_10_03_02_characters.sql b/sql/updates/characters/master/2022_10_03_02_characters.sql deleted file mode 100644 index 0bc7b663012..00000000000 --- a/sql/updates/characters/master/2022_10_03_02_characters.sql +++ /dev/null @@ -1 +0,0 @@ -DROP TABLE IF EXISTS `instance_scenario_progress`; diff --git a/sql/updates/characters/master/2022_08_21_00_characters.sql b/sql/updates/characters/master/2022_11_20_00_characters.sql index f81eae18344..46bfa1de3a1 100644 --- a/sql/updates/characters/master/2022_08_21_00_characters.sql +++ b/sql/updates/characters/master/2022_11_20_00_characters.sql @@ -1,3 +1,3 @@ --- TDB 927.22082 characters +-- TDB 927.22111 characters UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/characters', 'ARCHIVED'); |
