· 7 years ago · Sep 25, 2018, 09:18 AM
1DROP TABLE IF EXISTS `725_GarrSiteLevel`;
2CREATE TABLE `725_GarrSiteLevel` (
3 `ID` INT NOT NULL DEFAULT '0',
4 `TownHall_0` FLOAT NOT NULL DEFAULT '0',
5 `TownHall_1` FLOAT NOT NULL DEFAULT '0',
6 `MapID` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
7 `UITextureKitID` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
8 `MovieID` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
9 `UpgradeResourceCost` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
10 `UpgradeMoneyCost` SMALLINT UNSIGNED NOT NULL DEFAULT '0',
11 `Level` TINYINT UNSIGNED NOT NULL DEFAULT '0',
12 `SiteID` TINYINT UNSIGNED NOT NULL DEFAULT '0',
13 `Level2` TINYINT UNSIGNED NOT NULL DEFAULT '0',
14 PRIMARY KEY (`ID`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Export of GarrSiteLevel.db2';
16
17INSERT INTO `725_GarrSiteLevel` VALUES (5, 0.3584606, 0.6308265, 1158, 10, 192, 200, 0, 1, 2, 1);
18INSERT INTO `725_GarrSiteLevel` VALUES (6, 0.2967181, 0.2204033, 1159, 12, 194, 0, 0, 3, 2, 3);
19INSERT INTO `725_GarrSiteLevel` VALUES (258, 0.4903073, 0.6412199, 1152, 53, 189, 200, 0, 1, 71, 1);
20INSERT INTO `725_GarrSiteLevel` VALUES (259, 0.2825415, 0.4311562, 1153, 55, 191, 0, 0, 3, 71, 3);
21INSERT INTO `725_GarrSiteLevel` VALUES (444, 0.3079746, 0.2439098, 1331, 11, 193, 2000, 5000, 2, 2, 2);
22INSERT INTO `725_GarrSiteLevel` VALUES (445, 0.2825415, 0.4824382, 1330, 54, 190, 2000, 5000, 2, 71, 2);
23INSERT INTO `725_GarrSiteLevel` VALUES (560, 0, 0, 1220, 0, 0, 0, 0, 1, 161, 1);
24INSERT INTO `725_GarrSiteLevel` VALUES (579, 0.5, 0.5, 1461, 0, 0, 0, 0, 2, 161, 2);
25INSERT INTO `725_GarrSiteLevel` VALUES (580, 0.5, 0.5, 1462, 0, 0, 0, 0, 3, 161, 3);
26INSERT INTO `725_GarrSiteLevel` VALUES (584, 0, 0, 1463, 0, 0, 0, 0, 1, 163, 1);
27INSERT INTO `725_GarrSiteLevel` VALUES (585, 0.5, 0.5, 1464, 0, 0, 0, 0, 2, 163, 2);
28INSERT INTO `725_GarrSiteLevel` VALUES (586, 0.5, 0.5, 1466, 0, 0, 0, 0, 3, 163, 3);