1 TRUNCATE TABLE `corpse`;
\r
2 TRUNCATE TABLE `creature_respawn`;
\r
3 TRUNCATE TABLE `gameobject_respawn`;
\r
5 DROP TABLE IF EXISTS `instance`;
\r
6 CREATE TABLE `instance` (
\r
7 `id` int(11) unsigned NOT NULL default '0',
\r
8 `map` int(11) unsigned NOT NULL default '0',
\r
9 `resettime` bigint(40) NOT NULL default '0',
\r
12 KEY `resettime` (`resettime`)
\r
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\r
15 DROP TABLE IF EXISTS `character_instance`;
\r
16 CREATE TABLE `character_instance` (
\r
17 `guid` int(11) unsigned NOT NULL default '0',
\r
18 `map` int(11) unsigned NOT NULL default '0',
\r
19 `instance` bigint(40) NOT NULL default '0',
\r
20 `leader` int(11) unsigned NOT NULL default '0',
\r
21 PRIMARY KEY (`guid`,`map`),
\r
22 KEY `instance` (`instance`),
\r
23 KEY `leader` (`leader`)
\r
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\r
26 ALTER TABLE `creature_respawn` ADD `instance` int(11) unsigned NOT NULL default '0';
\r
27 ALTER TABLE `creature_respawn` DROP PRIMARY KEY;
\r
28 ALTER TABLE `creature_respawn` ADD PRIMARY KEY (`guid`, `instance`);
\r
30 ALTER TABLE `gameobject_respawn` ADD `instance` int(11) unsigned NOT NULL default '0';
\r
31 ALTER TABLE `gameobject_respawn` DROP PRIMARY KEY;
\r
32 ALTER TABLE `gameobject_respawn` ADD PRIMARY KEY (`guid`, `instance`);
\r
34 ALTER TABLE `corpse` ADD `instance` int(11) unsigned NOT NULL default '0';
\r
36 DROP TABLE IF EXISTS `instance_template`;
\r
37 CREATE TABLE `instance_template` (
\r
38 `map` int(11) unsigned NOT NULL,
\r
39 `levelMin` int(11) unsigned NOT NULL default '0',
\r
40 `levelMax` int(11) unsigned NOT NULL default '0',
\r
41 `maxPlayers` int(11) unsigned NOT NULL default '0',
\r
42 `reset_delay` int(20) unsigned NOT NULL default '0',
\r
43 `startLocX` float default NULL,
\r
44 `startLocY` float default NULL,
\r
45 `startLocZ` float default NULL,
\r
46 `startLocO` float default NULL,
\r
48 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
50 INSERT INTO `instance_template` VALUES (33, 22, 30, 10, 7200, NULL, NULL, NULL, NULL);
\r
51 INSERT INTO `instance_template` VALUES (34, 24, 32, 10, 7200, NULL, NULL, NULL, NULL);
\r
52 INSERT INTO `instance_template` VALUES (36, 15, 20, 10, 7200, NULL, NULL, NULL, NULL);
\r
53 INSERT INTO `instance_template` VALUES (43, 15, 21, 10, 7200, NULL, NULL, NULL, NULL);
\r
54 INSERT INTO `instance_template` VALUES (47, 29, 38, 10, 7200, NULL, NULL, NULL, NULL);
\r
55 INSERT INTO `instance_template` VALUES (48, 24, 32, 10, 7200, NULL, NULL, NULL, NULL);
\r
56 INSERT INTO `instance_template` VALUES (70, 35, 47, 10, 7200, NULL, NULL, NULL, NULL);
\r
57 INSERT INTO `instance_template` VALUES (90, 29, 38, 10, 7200, NULL, NULL, NULL, NULL);
\r
58 INSERT INTO `instance_template` VALUES (109, 45, 55, 10, 7200, NULL, NULL, NULL, NULL);
\r
59 INSERT INTO `instance_template` VALUES (129, 37, 46, 10, 7200, NULL, NULL, NULL, NULL);
\r
60 INSERT INTO `instance_template` VALUES (189, 34, 45, 10, 7200, NULL, NULL, NULL, NULL);
\r
61 INSERT INTO `instance_template` VALUES (209, 44, 54, 10, 7200, NULL, NULL, NULL, NULL);
\r
62 INSERT INTO `instance_template` VALUES (229, 58, 0, 10, 120000, 78.5083, -225.044, 49.839, 5.1);
\r
63 INSERT INTO `instance_template` VALUES (230, 52, 0, 5, 7200, NULL, NULL, NULL, NULL);
\r
64 INSERT INTO `instance_template` VALUES (249, 60, 0, 40, 432000, NULL, NULL, NULL, NULL);
\r
65 INSERT INTO `instance_template` VALUES (289, 57, 0, 5, 7200, NULL, NULL, NULL, NULL);
\r
66 INSERT INTO `instance_template` VALUES (309, 60, 0, 20, 259200, NULL, NULL, NULL, NULL);
\r
67 INSERT INTO `instance_template` VALUES (329, 58, 60, 5, 7200, NULL, NULL, NULL, NULL);
\r
68 INSERT INTO `instance_template` VALUES (349, 46, 55, 10, 7200, NULL, NULL, NULL, NULL);
\r
69 INSERT INTO `instance_template` VALUES (389, 13, 18, 10, 7200, NULL, NULL, NULL, NULL);
\r
70 INSERT INTO `instance_template` VALUES (409, 60, 0, 40, 604800, NULL, NULL, NULL, NULL);
\r
71 INSERT INTO `instance_template` VALUES (429, 55, 60, 5, 7200, NULL, NULL, NULL, NULL);
\r
72 INSERT INTO `instance_template` VALUES (469, 60, 0, 40, 604800, NULL, NULL, NULL, NULL);
\r
73 INSERT INTO `instance_template` VALUES (509, 60, 0, 20, 259200, NULL, NULL, NULL, NULL);
\r
74 INSERT INTO `instance_template` VALUES (531, 60, 0, 40, 604800, NULL, NULL, NULL, NULL);
\r
75 INSERT INTO `instance_template` VALUES (533, 60, 0, 40, 604800, NULL, NULL, NULL, NULL);
\r