aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql9
1 files changed, 6 insertions, 3 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 4fcc88a3a7d..88327122f26 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1363,7 +1363,9 @@ CREATE TABLE `characters` (
`position_z` float NOT NULL DEFAULT '0',
`map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`instance_id` int(10) unsigned NOT NULL DEFAULT '0',
- `instance_mode_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `dungeonDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '14',
+ `legacyRaidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '3',
`orientation` float NOT NULL DEFAULT '0',
`taximask` text NOT NULL,
`online` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -1731,8 +1733,9 @@ CREATE TABLE `groups` (
`icon7` binary(16) NOT NULL,
`icon8` binary(16) NOT NULL,
`groupType` tinyint(3) unsigned NOT NULL,
- `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `raiddifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '14',
+ `legacyRaidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '3',
`masterLooterGuid` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`guid`),
KEY `leaderGuid` (`leaderGuid`)