· 9 years ago · Oct 03, 2016, 06:02 AM
1TRUNCATE `settings`;
2
3INSERT INTO `settings` (`name`, `status`) VALUES ('vtcname', 'NEWMAN Logistics & Trucking');
4INSERT INTO `settings` (`name`, `status`) VALUES ('weburl', 'https://www.facebook.com/groups/1376303282384636');
5INSERT INTO `settings` (`name`, `status`) VALUES ('recaptcha_key_public', 'ENTER PUBLIC RECAPTCHA KEY HERE');
6INSERT INTO `settings` (`name`, `status`) VALUES ('recaptcha_key_private', 'ENTER SECRET RECAPTCHA KEY HERE');
7INSERT INTO `settings` (`name`, `status`) VALUES ('user_email', 'ENTER YOUR VTC EMAIL HERE HERE');
8INSERT INTO `settings` (`name`, `status`) VALUES ('navbar_color', '7a7a7a');
9INSERT INTO `settings` (`name`, `status`) VALUES ('job_submission_upload_required', '0');
10INSERT INTO `settings` (`name`, `status`) VALUES ('signin_disabled', '0');
11INSERT INTO `settings` (`name`, `status`) VALUES ('logindisabled', '0');
12INSERT INTO `settings` (`name`, `status`) VALUES ('adminonly', '0');
13
14DROP TABLE IF EXISTS `issues`;
15
16ALTER TABLE `drive_routes` ADD `fuel_used` VARCHAR(255) NOT NULL;
17ALTER TABLE `drive_routes` ADD `image` VARCHAR(255) NOT NULL;
18ALTER TABLE `drive_routes` ADD `admin` int(4) NOT NULL DEFAULT '0';
19
20ALTER TABLE `users` ADD `passwordReset` int(1) NOT NULL DEFAULT '0';
21ALTER TABLE `users` ADD `passwordKey` varchar(25) NOT NULL;
22ALTER TABLE `users` ADD `perm_edit_members` int(1) NOT NULL DEFAULT '0';
23ALTER TABLE `users` ADD `perm_edit_jobs` int(1) NOT NULL DEFAULT '0';
24ALTER TABLE `users` ADD `perm_edit_settings` int(1) NOT NULL DEFAULT '0';
25ALTER TABLE `users` ADD `perm_edit_blog` int(1) NOT NULL DEFAULT '0';
26
27CREATE TABLE IF NOT EXISTS `drive_locations_game` (
28 `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
29 `title` varchar(255) NOT NULL
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31
32INSERT INTO `drive_locations_game` (`title`) VALUES
33('Euro Truck Simulator 2'),
34('American Truck Simulator');
35
36TRUNCATE TABLE `drive_locations`;
37ALTER TABLE `drive_locations` ADD `type` VARCHAR(50) NOT NULL DEFAULT 'Default Map';
38ALTER TABLE `drive_locations` ADD `game` INT NOT NULL;
39
40INSERT INTO `drive_locations` (`id`, `name`, `type`, `game`) VALUES
41(1, 'ABERDEEN', 'Default Map', 1),
42(2, 'AMSTERDAM', 'Default Map', 1),
43(3, 'BERLIN', 'Default Map', 1),
44(4, 'BERN', 'Default Map', 1),
45(5, 'BIRMINGHAM', 'Default Map', 1),
46(6, 'BRATISLAVA', 'Default Map', 1),
47(7, 'BREMEN', 'Default Map', 1),
48(8, 'BRNO', 'Default Map', 1),
49(9, 'BRUSSELS', 'Default Map', 1),
50(10, 'CALAIS', 'Default Map', 1),
51(11, 'CAMBRIDGE', 'Default Map', 1),
52(12, 'CARDIFF', 'Default Map', 1),
53(13, 'CARLISLE', 'Default Map', 1),
54(14, 'DIJON', 'Default Map', 1),
55(15, 'DORTMUND', 'Default Map', 1),
56(16, 'DOVER', 'Default Map', 1),
57(17, 'DRESDEN', 'Default Map', 1),
58(18, 'DUISBOURG', 'Default Map', 1),
59(19, 'DUSSELDORF', 'Default Map', 1),
60(20, 'EDINBURGH', 'Default Map', 1),
61(21, 'ERFURT', 'Default Map', 1),
62(22, 'FELIXSTOWE', 'Default Map', 1),
63(23, 'FRANKFURT-AM-MAIN', 'Default Map', 1),
64(24, 'GENEVE', 'Default Map', 1),
65(25, 'GLASGOW', 'Default Map', 1),
66(26, 'GRIMSBY', 'Default Map', 1),
67(27, 'GRONINGEN', 'Default Map', 1),
68(28, 'HAMBURG', 'Default Map', 1),
69(29, 'HANNOVER', 'Default Map', 1),
70(30, 'INNSBRUCK', 'Default Map', 1),
71(31, 'KASSEL', 'Default Map', 1),
72(32, 'KIEL', 'Default Map', 1),
73(33, 'KOLN', 'Default Map', 1),
74(34, 'LEIPZIG', 'Default Map', 1),
75(35, 'LIEGE', 'Default Map', 1),
76(36, 'LILLE', 'Default Map', 1),
77(37, 'LINZ', 'Default Map', 1),
78(38, 'LIVERPOOL', 'Default Map', 1),
79(39, 'LONDON', 'Default Map', 1),
80(40, 'LUXEMBOURG', 'Default Map', 1),
81(41, 'LYON', 'Default Map', 1),
82(42, 'MAGDEBURG', 'Default Map', 1),
83(43, 'MANCHESTER', 'Default Map', 1),
84(44, 'MANNHEIM', 'Default Map', 1),
85(45, 'METZ', 'Default Map', 1),
86(46, 'MILANO', 'Default Map', 1),
87(47, 'MUNCHEN', 'Default Map', 1),
88(48, 'NEWCASTLE-UPON-TYNE', 'Default Map', 1),
89(49, 'NURNBERG', 'Default Map', 1),
90(50, 'OSNABRUCK', 'Default Map', 1),
91(51, 'PARIS', 'Default Map', 1),
92(52, 'PLYMOUTH', 'Default Map', 1),
93(53, 'POZNAN', 'Default Map', 1),
94(54, 'PRAHA', 'Default Map', 1),
95(55, 'REIMS', 'Default Map', 1),
96(56, 'ROSTOCK', 'Default Map', 1),
97(57, 'ROTTERDAM', 'Default Map', 1),
98(58, 'SALZBURG', 'Default Map', 1),
99(59, 'SHEFFIELD', 'Default Map', 1),
100(60, 'SOUTHAMPTON', 'Default Map', 1),
101(61, 'STRASBOURG', 'Default Map', 1),
102(62, 'STUTTGART', 'Default Map', 1),
103(63, 'SWANSEA', 'Default Map', 1),
104(64, 'SZCZECIN', 'Default Map', 1),
105(65, 'TORINO', 'Default Map', 1),
106(66, 'VERONA', 'Default Map', 1),
107(67, 'WIEN', 'Default Map', 1),
108(68, 'WROCLAW', 'Default Map', 1),
109(69, 'OTHER', 'Default Map', 1),
110(70, 'GDANSK', 'Default Map', 1),
111(71, 'OLSZTYN', 'Default Map', 1),
112(72, 'BIALYSTOK', 'Default Map', 1),
113(73, 'WARSAW', 'Default Map', 1),
114(74, 'LODZ', 'Default Map', 1),
115(75, 'LUBLIN', 'Default Map', 1),
116(76, 'ZURICH', 'Default Map', 1),
117(77, 'KATOWICE', 'Default Map', 1),
118(78, 'KRAKOW', 'Default Map', 1),
119(79, 'OSTRAVA', 'Default Map', 1),
120(80, 'BANSKA BYSTRICA', 'Default Map', 1),
121(82, 'KOSICE', 'Default Map', 1),
122(83, 'DEBRECEN', 'Default Map', 1),
123(84, 'BUDAPEST', 'Default Map', 1),
124(85, 'FLENSBURG', 'Promods', 1),
125(86, 'PUTTGARDEN', 'Promods', 1),
126(87, 'KOLDING', 'Promods', 1),
127(88, 'ESBJERG', 'Promods', 1),
128(89, 'AARHUS', 'Promods', 1),
129(90, 'AALBORG', 'Promods', 1),
130(91, 'ODENSE', 'Promods', 1),
131(92, 'COPENHAGEN', 'Promods', 1),
132(93, 'MALMÖ', 'Promods', 1),
133(94, 'GÖTEBORG', 'Promods', 1),
134(95, 'JÖNKÖPING', 'Promods', 1),
135(96, 'SKÖVDE', 'Promods', 1),
136(97, 'KARLSTAD', 'Promods', 1),
137(98, 'SÖDERTÄLJE', 'Promods', 1),
138(99, 'STOCKHOLM', 'Promods', 1),
139(100, 'OSLO', 'Promods', 1),
140(101, 'GARDERMOEN', 'Promods', 1),
141(102, 'HØNEFOSS', 'Promods', 1),
142(103, 'KRISTIANSAND', 'Promods', 1),
143(104, 'STAVANGER', 'Promods', 1),
144(105, 'ODDA', 'Promods', 1),
145(106, 'BERGEN', 'Promods', 1),
146(107, 'GEILO', 'Promods', 1),
147(108, 'TURKU', 'Promods', 1),
148(109, 'HELSINKI', 'Promods', 1),
149(110, 'VENEZIA', 'Default Map', 1),
150(111, 'KLAGENFURT AM WORTHERSEE', 'Default Map', 1),
151(112, 'GRAZ', 'Default Map', 1),
152(113, 'HELSINKI', 'Promods', 1),
153(114, 'HELSINKI', 'Promods', 1),
154(115, 'ALBI', 'TSM', 1),
155(116, 'ALEXANDRIA', 'TSM', 1),
156(117, 'ALEXANDROUPOLI', 'TSM', 1),
157(118, 'ALGIER', 'TSM', 1),
158(119, 'ANCONA', 'TSM', 1),
159(120, 'ATHINA', 'TSM', 1),
160(121, 'BARCELONA', 'TSM', 1),
161(122, 'BARI', 'TSM', 1),
162(123, 'BATNA', 'TSM', 1),
163(124, 'BENGHAZI', 'TSM', 1),
164(125, 'BILBAO', 'TSM', 1),
165(126, 'BISKRA', 'TSM', 1),
166(127, 'BOCHUM', 'TSM', 1),
167(128, 'BOLOGNA', 'TSM', 1),
168(129, 'BOLZANO', 'TSM', 1),
169(130, 'BORDEAUX', 'TSM', 1),
170(131, 'BOURGES', 'TSM', 1),
171(132, 'CAIRO', 'TSM', 1),
172(133, 'CALABRIA', 'TSM', 1),
173(134, 'CASABLANCA', 'TSM', 1),
174(135, 'CHANIA', 'TSM', 1),
175(136, 'CLERMONT-FOOT', 'TSM', 1),
176(137, 'CORDOBA', 'TSM', 1),
177(138, 'DJELFA', 'TSM', 1),
178(139, 'DRAMA', 'TSM', 1),
179(140, 'DRESDEN', 'TSM', 1),
180(141, 'DUBROVNIK', 'TSM', 1),
181(142, 'EL HAMMA', 'TSM', 1),
182(143, 'ESSEN', 'TSM', 1),
183(144, 'EVORA', 'TSM', 1),
184(145, 'FARO', 'TSM', 1),
185(146, 'FIRENZE', 'TSM', 1),
186(147, 'FOGGIA', 'TSM', 1),
187(148, 'GABES', 'TSM', 1),
188(149, 'GAFSA', 'TSM', 1),
189(150, 'AMMANFORD', 'Heavy Alex', 1),
190(151, 'AMIENS', 'Heavy Alex', 1),
191(152, 'EPINAL', 'Heavy Alex', 1),
192(153, 'FELDKIRCH', 'Heavy Alex', 1),
193(154, 'UNKEN', 'Heavy Alex', 1),
194(155, 'LIENZ', 'Heavy Alex', 1),
195(156, 'CHUR', 'Heavy Alex', 1),
196(157, 'BELLUNO', 'Heavy Alex', 1),
197(158, 'SILLIAN', 'Heavy Alex', 1),
198(159, 'BOLZANO', 'Heavy Alex', 1),
199(160, 'CROYDON', 'Heavy Alex', 1),
200(161, 'PORTSMOUTH', 'Heavy Alex', 1),
201(162, 'MAIDSTONE', 'Heavy Alex', 1),
202(163, 'RUZOMBEROK', 'Heavy Alex', 1),
203(164, 'GRUDZIADZ', 'Heavy Alex', 1),
204(165, 'AUXERRE', 'Heavy Alex', 1),
205(166, 'BREGNEZ', 'Heavy Alex', 1),
206(167, 'TRUTNOV', 'Heavy Alex', 1),
207(168, 'GELSENKIRCHEN', 'TSM', 1),
208(169, 'GENOVA', 'TSM', 1),
209(170, 'GIBRALTAR', 'TSM', 1),
210(171, 'HEBIRA', 'TSM', 1),
211(172, 'IGOUMENITSA', 'TSM', 1),
212(173, 'IOANNINA', 'TSM', 1),
213(174, 'IRAKLIO', 'TSM', 1),
214(175, 'KALAMATA', 'TSM', 1),
215(176, 'KALAMATA', 'TSM', 1),
216(177, 'KALAMATA', 'TSM', 1),
217(178, 'KOZANI', 'TSM', 1),
218(179, 'KAVALA', 'TSM', 1),
219(180, 'LA ROCHELLE', 'TSM', 1),
220(181, 'LAMIA', 'TSM', 1),
221(182, 'LARISA', 'TSM', 1),
222(183, 'LAZIO', 'TSM', 1),
223(184, 'LECCE', 'TSM', 1),
224(185, 'LIMOGES', 'TSM', 1),
225(186, 'LISBOA', 'TSM', 1),
226(187, 'LIVORNO', 'TSM', 1),
227(188, 'LJUBLJANA', 'TSM', 1),
228(189, 'MADRID', 'TSM', 1),
229(190, 'MALAGA', 'TSM', 1),
230(191, 'MEKNES', 'TSM', 1),
231(192, 'MERIDA', 'TSM', 1),
232(193, 'MISRATA', 'TSM', 1),
233(194, 'MONTPELLIER', 'TSM', 1),
234(195, 'MURCIA', 'TSM', 1),
235(196, 'NANTES', 'TSM', 1),
236(197, 'NAPOLI', 'TSM', 1),
237(198, 'NICE', 'TSM', 1),
238(199, 'ORLEANS', 'TSM', 1),
239(200, 'OUJDA', 'TSM', 1),
240(201, 'PADOVA', 'TSM', 1),
241(202, 'PATRA', 'TSM', 1),
242(203, 'PERPIGNAN', 'TSM', 1),
243(204, 'PERUGIA', 'TSM', 1),
244(205, 'PESCARA', 'TSM', 1),
245(206, 'PORTO', 'TSM', 1),
246(207, 'POTENZA', 'TSM', 1),
247(208, 'PREVEZA', 'TSM', 1),
248(209, 'PUGLIA', 'TSM', 1),
249(210, 'RABAT', 'TSM', 1),
250(211, 'RECKLINGHAUSEN', 'TSM', 1),
251(212, 'REDEYEF', 'TSM', 1),
252(213, 'REGGIO CALABRIA', 'TSM', 1),
253(214, 'RIJEKA', 'TSM', 1),
254(215, 'ROMA', 'TSM', 1),
255(216, 'SALAMANCA', 'TSM', 1),
256(217, 'SERRES', 'TSM', 1),
257(218, 'SEVILLA', 'TSM', 1),
258(219, 'SIRTE', 'TSM', 1),
259(220, 'SPARTI', 'TSM', 1),
260(221, 'SPLIT', 'TSM', 1),
261(222, 'ST POLTEN', 'TSM', 1),
262(223, 'TANGIER', 'TSM', 1),
263(224, 'TAZA', 'TSM', 1),
264(225, 'THESSALONIKI', 'TSM', 1),
265(226, 'TIARET', 'TSM', 1),
266(227, 'TIRANA', 'TSM', 1),
267(228, 'TOULOUSE', 'TSM', 1),
268(229, 'TRIESTE', 'TSM', 1),
269(230, 'TRIKALA', 'TSM', 1),
270(231, 'TRIPOLI', 'TSM', 1),
271(232, 'TRIPOLIS', 'TSM', 1),
272(233, 'TUBRUQ', 'TSM', 1),
273(234, 'TUNIS', 'TSM', 1),
274(235, 'UDINE', 'TSM', 1),
275(236, 'VALENCIA', 'TSM', 1),
276(237, 'VALLADOLID', 'TSM', 1),
277(238, 'VILLACH', 'TSM', 1),
278(239, 'VISEU', 'TSM', 1),
279(240, 'VOLOS', 'TSM', 1),
280(241, 'WUPPERTAL', 'TSM', 1),
281(242, 'ZADAR', 'TSM', 1),
282(243, 'ZARAGOZA', 'TSM', 1),
283(244, 'ZUWARA', 'TSM', 1),
284(245, 'CAEN', 'Promods', 1),
285(246, 'BREST', 'Russian Map', 1),
286(247, 'GOMEL', 'Russian Map', 1),
287(248, 'KALUGA', 'Russian Map', 1),
288(249, 'MAHILYOW', 'Russian Map', 1),
289(250, 'MAZYR', 'Russian Map', 1),
290(251, 'MOSCOW', 'Russian Map', 1),
291(252, 'MSTSISLAW', 'Russian Map', 1),
292(253, 'NEVEL', 'Russian Map', 1),
293(254, 'OBNINSK', 'Russian Map', 1),
294(255, 'ORSHA', 'Russian Map', 1),
295(256, 'PINSK', 'Russian Map', 1),
296(257, 'ROSLAVL', 'Russian Map', 1),
297(258, 'RZHEV', 'Russian Map', 1),
298(259, 'SLAUHARAD', 'Russian Map', 1),
299(260, 'SMOLENSK', 'Russian Map', 1),
300(261, 'TVER', 'Russian Map', 1),
301(262, 'VELIKIYE LUKI', 'Russian Map', 1),
302(263, 'VELIZH', 'Russian Map', 1),
303(264, 'VITEBSK', 'Russian Map', 1),
304(265, 'VOLOKOLAMSK', 'Russian Map', 1),
305(266, 'VYAZMA', 'Russian Map', 1),
306(267, 'BRYANSK', 'Russian Map', 1),
307(268, 'Testing', 'Default Map', 1),
308(269, 'ORADEA', 'RO Map AddOn v4.2', 1),
309(270, 'DEVA', 'RO Map AddOn v4.2', 1),
310(271, 'NADLAX', 'RO Map AddOn v4.2', 1),
311(272, 'SEBES', 'RO Map AddOn v4.2', 1),
312(273, 'ARAD', 'RO Map AddOn v4.2', 1),
313(274, 'SIBIU', 'RO Map AddOn v4.2', 1),
314(275, 'TIMISOARA', 'RO Map AddOn v4.2', 1),
315(276, 'BRASOV', 'RO Map AddOn v4.2', 1),
316(277, 'DROBETA TURNU SEVERIN', 'RO Map AddOn v4.2', 1),
317(278, 'CRAIOCA', 'RO Map AddOn v4.2', 1),
318(279, 'SLATINA', 'RO Map AddOn v4.2', 1),
319(280, 'RAMNICU VALCEA', 'RO Map AddOn v4.2', 1),
320(281, 'PITESTI', 'RO Map AddOn v4.2', 1),
321(282, 'BUCURESTI', 'RO Map AddOn v4.2', 1),
322(283, 'URZICENI', 'RO Map AddOn v4.2', 1),
323(284, 'SLOBOZIA', 'RO Map AddOn v4.2', 1),
324(285, 'CALARASI', 'RO Map AddOn v4.2', 1),
325(286, 'VENTSPILS', 'RO Map AddOn v4.2', 1),
326(287, 'LIEPAJA', 'RO Map AddOn v4.2', 1),
327(288, 'KLAIPEDA', 'RO Map AddOn v4.2', 1),
328(289, 'KAUNAS', 'RO Map AddOn v4.2', 1),
329(290, 'ANTWERPEN', 'Promods', 1),
330(291, 'ESBJERG', 'Promods', 1),
331(292, 'HERNING', 'Promods', 1),
332(293, 'HIRTSHALS', 'Promods', 1),
333(294, 'HOLSTEBRO', 'Promods', 1),
334(295, 'PADBORG', 'Promods', 1),
335(296, 'VIBORG', 'Promods', 1),
336(297, 'PÄRNU', 'Promods', 1),
337(298, 'TALINN', 'Promods', 1),
338(299, 'TARTU', 'Promods', 1),
339(300, 'VALGA', 'Promods', 1),
340(301, 'KLAKSVIK', 'Promods', 1),
341(302, 'TORSHAVN', 'Promods', 1),
342(303, 'HÄMEENLINNA', 'Promods', 1),
343(304, 'JYVÄSKYLÄ', 'Promods', 1),
344(305, 'KUOPIO', 'Promods', 1),
345(306, 'LAHTI', 'Promods', 1),
346(307, 'MIKKELI', 'Promods', 1),
347(308, 'PORVOO', 'Promods', 1),
348(309, 'VARKAUS', 'Promods', 1),
349(310, 'TAMPERE', 'Promods', 1),
350(311, 'ANGERS', 'Promods', 1),
351(312, 'BAYONNE', 'Promods', 1),
352(313, 'BREST', 'Promods', 1),
353(314, 'BORDEAUX', 'Promods', 1),
354(315, 'CHERBOURG', 'Promods', 1),
355(316, 'LE HAVRE', 'Promods', 1),
356(317, 'LE MANS', 'Promods', 1),
357(318, 'LIMOGES', 'Promods', 1),
358(319, 'LORIENT', 'Promods', 1),
359(320, 'NANTES', 'Promods', 1),
360(321, 'ORLÉANS', 'Promods', 1),
361(322, 'RENNES', 'Promods', 1),
362(323, 'ROUEN', 'Promods', 1),
363(324, 'PAU', 'Promods', 1),
364(325, 'POITIERS', 'Promods', 1),
365(326, 'TOURS', 'Promods', 1),
366(327, 'BAD OEYNHAUSEN', 'Promods', 1),
367(328, 'BURG A. FEHMARN', 'Promods', 1),
368(329, 'OBERHAUSEN', 'Promods', 1),
369(330, 'BOLOGNA', 'Promods', 1),
370(331, 'GENOVA', 'Promods', 1),
371(332, 'MODENA', 'Promods', 1),
372(333, 'PARMA', 'Promods', 1),
373(334, 'VICENZA', 'Promods', 1),
374(335, 'AKUREYRI', 'Promods', 1),
375(336, 'BLONDUOS', 'Promods', 1),
376(337, 'BORGAMES', 'Promods', 1),
377(338, 'HOFN', 'Promods', 1),
378(339, 'KEFLAVIK INTERNATIONAL AIRPORT', 'Promods', 1),
379(340, 'REYKJAVIK', 'Promods', 1),
380(341, 'REYÃARFJÖRÃUR', 'Promods', 1),
381(342, 'SEYÃISFJÖRÃUR', 'Promods', 1),
382(343, 'VIK', 'Promods', 1),
383(344, 'VALKA', 'Promods', 1),
384(345, 'VADUZ', 'Promods', 1),
385(346, 'LJUBLJANA', 'Promods', 1),
386(347, 'MARIBOR', 'Promods', 1),
387(348, 'GOTEBORG', 'Promods', 1),
388(349, 'KALMAR', 'Promods', 1),
389(350, 'LINKOPING', 'Promods', 1),
390(351, 'BASEL', 'Promods', 1),
391(352, 'CROYDON', 'Promods', 1),
392(354, 'HULL', 'Promods', 1),
393(355, 'FORT WILLIAM', 'Promods', 1),
394(356, 'INVERNESS', 'Promods', 1),
395(357, 'OBAN', 'Promods', 1),
396(358, 'PORTSMOUTH', 'Promods', 1),
397(359, 'WICK', 'Promods', 1),
398(360, 'Bergen', 'Scandinavia', 1),
399(361, 'Stavanger', 'Scandinavia', 1),
400(362, 'Kristiansand', 'Scandinavia', 1),
401(363, 'Oslo', 'Scandinavia', 1),
402(364, 'Hirtshals', 'Scandinavia', 1),
403(365, 'Frederikshavn', 'Scandinavia', 1),
404(366, 'Aalborg', 'Scandinavia', 1),
405(367, 'Esbjerg', 'Scandinavia', 1),
406(368, 'Odense', 'Scandinavia', 1),
407(369, 'København', 'Scandinavia', 1),
408(370, 'Gedser', 'Scandinavia', 1),
409(371, 'Trelleborg', 'Scandinavia', 1),
410(372, 'Helsingborg', 'Scandinavia', 1),
411(373, 'Karlskrona', 'Scandinavia', 1),
412(374, 'Kalmar', 'Scandinavia', 1),
413(375, 'Växjö', 'Scandinavia', 1),
414(376, 'Jönköping', 'Scandinavia', 1),
415(377, 'Malmö', 'Scandinavia', 1),
416(378, 'Göteborg', 'Scandinavia', 1),
417(379, 'Linköping', 'Scandinavia', 1),
418(380, 'Orebro', 'Scandinavia', 1),
419(381, 'Västerà s', 'Scandinavia', 1),
420(382, 'Uppsala', 'Scandinavia', 1),
421(383, 'Stockholm', 'Scandinavia', 1),
422(384, 'Södertälje', 'Scandinavia', 1),
423(385, 'Nynäshamn', 'Scandinavia', 1),
424(386, 'Pecs', 'Default Map', 1),
425(387, 'Szeged', 'Default Map', 1),
426(390, 'Albany', 'NY', 2),
427(340, 'Albuquerque', 'NM', 2),
428(341, 'Amarillo', 'TX', 2),
429(342, 'Atlanta', 'GA', 2),
430(343, 'Bakersfield', 'CA', 2),
431(344, 'Baltimore', 'MD', 2),
432(345, 'Bangor', 'ME', 2),
433(346, 'Barstow', 'CA', 2),
434(347, 'Billings', 'MT', 2),
435(348, 'Bismark', 'ND', 2),
436(349, 'Boise', 'ID', 2),
437(350, 'Boston', 'MA', 2),
438(351, 'Burlington', 'VT', 2),
439(352, 'Butte', 'MT', 2),
440(353, 'Camp Verde', 'AZ', 2),
441(354, 'Carlsbad', 'CA', 2),
442(355, 'Carson City', 'NV', 2),
443(356, 'Charleston', 'WV', 2),
444(357, 'Cheyenne', 'WY', 2),
445(358, 'Chicago', 'IL', 2),
446(359, 'Cleveland', 'OH', 2),
447(360, 'Columbia', 'SC', 2),
448(361, 'Columbus', 'OH', 2),
449(362, 'Dallas', 'TX', 2),
450(363, 'Denver', 'CO', 2),
451(364, 'Des Moines', 'IA', 2),
452(365, 'Detroit', 'MI', 2),
453(366, 'Duluth', 'MN', 2),
454(367, 'Ehernburg', 'AZ', 2),
455(368, 'El Centro', 'CA', 2),
456(369, 'El Paso', 'TX', 2),
457(370, 'Elko', 'NV', 2),
458(371, 'Ely', 'NV', 2),
459(372, 'Eugene', 'OR', 2),
460(373, 'Eureka', 'CA', 2),
461(374, 'Fargo', 'ND', 2),
462(375, 'Fayetteville', 'NC', 2),
463(376, 'Fresno', 'CA', 2),
464(377, 'Grand Canyon Village', 'AZ', 2),
465(378, 'Grand Rapids', 'MI', 2),
466(379, 'Grandforks', 'IL', 2),
467(380, 'Green Bay', 'WI', 2),
468(381, 'Hartford', 'CT', 2),
469(382, 'Hollbrook', 'AZ', 2),
470(383, 'Hornbrook', 'CA', 2),
471(384, 'Houston', 'TX', 2),
472(385, 'Huron', 'CA', 2),
473(386, 'Idaho Falls', 'ID', 2),
474(387, 'Jackpot', 'NV, 2),
475(388, 'Jackson', 'MS', 2),
476(389, 'Jacksonville', 'FL', 2),
477(390, 'Kansas City', 'MO', 2),
478(391, 'Kayenta', 'AZ', 2),
479(392, 'Key West', 'FL', 2),
480(393, 'Kingman', 'AZ', 2),
481(394, 'Las Vegas', 'NV', 2),
482(395, 'Little Rock', 'AR', 2),
483(396, 'Los Angeles', 'CA', 2),
484(397, 'Louisville', 'KY', 2),
485(398, 'Lubbock', 'TX', 2),
486(399, 'Manchester', 'NH', 2),
487(400, 'Memphis', 'TN', 2),
488(401, 'Miami', 'FL', 2),
489(402, 'Milwaukie', 'WI', 2),
490(403, 'Minneapolis', 'MN', 2),
491(404, 'Missoula', 'MT', 2),
492(405, 'Moab', 'UT', 2),
493(406, 'Mobile', 'AL', 2),
494(407, 'Nashville', 'TN', 2),
495(408, 'New Orleans', 'LA' 2),
496(409, 'New York', 'NY', 2),
497(410, 'Nogales', 'AZ', 2),
498(411, 'Norfolk', 'VA', 2),
499(412, 'Oakdale', 'CA', 2),
500(413, 'Oakland', 'CA', 2),
501(414, 'Oklahoma City', 'OK', 2),
502(415, 'Omaha', 'NE', 2),
503(416, 'Oxnard', 'CA', 2),
504(417, 'Page', 'AZ', 2),
505(418, 'Philadelphia', 'PA', 2),
506(419, 'Phoenix', 'AZ', 2),
507(420, 'Pioche', 'NV', 2),
508(421, 'Pittsburgh', 'PA', 2),
509(422, 'Portland', 'ME', 2),
510(423, 'Portland', 'OR', 2),
511(424, 'Primm', 'NV', 2),
512(425, 'Providence', 'RI', 2),
513(426, 'Raleigh', 'NC', 2),
514(427, 'Rapid City', 'SD', 2),
515(428, 'Redding', 'CA', 2),
516(429, 'Reno', 'NV', 2),
517(430, 'Rochester', 'NY', 2),
518(431, 'Sacramento', 'CA', 2),
519(432, 'Salt Lake City', 'UT', 2),
520(433, 'San Antonio', 'TX', 2),
521(434, 'San Diego', 'CA, 2),
522(435, 'San Francisco', 'CA', 2),
523(436, 'San Rafael', 'CA', 2),
524(437, 'San Simon', 'AZ', 2),
525(438, 'Santa Cruz', 'CA', 2),
526(439, 'Savanah', 'GA', 2),
527(440, 'Seattle', 'WA', 2),
528(441, 'Serra Vista', 'AZ', 2),
529(442, 'Show low', 'AZ', 2),
530(443, 'Sioux Falls', 'SD', 2),
531(444, 'Spokane', 'WA', 2),
532(445, 'Springfield', 'MO', 2),
533(446, 'St. Louis', 'MO', 2),
534(447, 'Stockton', 'CA', 2),
535(448, 'Tallahassee', 'FL', 2),
536(449, 'Tampa', 'FL', 2),
537(450, 'Tonopah', 'NV', 2),
538(451, 'Truckee', 'CA', 2),
539(452, 'Tulsa', 'OK', 2),
540(453, 'Tuscon', 'AZ', 2),
541(454, 'Twin Falls', 'ID', 2),
542(455, 'Washington', 'DC', 2),
543(456, 'Wichita', 'KS', 2),
544(457, 'Wichita Falls', 'TX', 2),
545(458, 'Winnemucca', 'NV', 2),
546(459, 'Yuma', 'AZ', 2);