· 7 years ago · Dec 17, 2018, 11:44 AM
1CREATE TABLE IF NOT EXISTS `guild_houses` (
2 `id` int(8) unsigned NOT NULL auto_increment,
3 `guildId` bigint(20) NOT NULL default '0',
4 `x` double NOT NULL,
5 `y` double NOT NULL,
6 `z` double NOT NULL,
7 `map` int(11) NOT NULL,
8 `comment` varchar(255) NOT NULL default '',
9 PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=22 ;
11
12--
13-- Dumping data for table `guild_houses`
14--
15
16INSERT INTO `guild_houses` (`id`, `guildId`, `x`, `y`, `z`, `map`, `comment`) VALUES
17(1, 1, 16222, 16266, 14.2, 1, 'GM Island'),
18(2, 0, -10711, 2483, 8, 1, 'Village on the Veiled Sea (Silithus)'),
19(3, 0, -8323, -343, 146, 0, 'Elwynn Falls Camp (Elwynn Forest)'),
20(4, 0, -1840, -4233, 2.14, 0, 'Arathi Village (Arathi Highlands, Forbidding Sea)'),
21(5, 0, -6374, 1262, 7, 0, 'Harbor House (Elwynn Forest)'),
22(6, 0, 4303, -2760, 16.8, 0, 'Quel''Thalas Tower');