1 TRUNCATE `character_instance`;
4 ALTER TABLE `character_instance`
7 ADD PRIMARY KEY `guid` (`guid`,`instance`),
10 MODIFY COLUMN `instance` int(11) unsigned NOT NULL default '0',
11 ADD COLUMN `permanent` tinyint(1) unsigned NOT NULL default '0';
13 ALTER TABLE `instance`
14 ADD COLUMN `difficulty` tinyint(1) unsigned NOT NULL default '0' AFTER `resettime`;
16 CREATE TABLE `group_instance` (
17 `leaderGuid` int(11) unsigned NOT NULL default '0',
18 `instance` int(11) unsigned NOT NULL default '0',
19 `permanent` tinyint(1) unsigned NOT NULL default '0',
20 PRIMARY KEY (`leaderGuid`,`instance`),
21 KEY `instance` (`instance`)
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
24 CREATE TABLE `instance_reset` (
25 `mapid` int(11) unsigned NOT NULL default '0',
26 `resettime` bigint(40) NOT NULL default '0',
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31 ADD COLUMN `difficulty` tinyint(3) unsigned NOT NULL default '0' AFTER `isRaid`;
33 ALTER TABLE `characters`
34 ADD COLUMN `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `map`;