· 6 years ago · Oct 28, 2019, 05:48 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u6
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: 2019 m. Rgs 30 d. 14:40
7-- Server version: 5.5.62-0+deb8u1
8-- PHP Version: 5.6.40-0+deb8u6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `sang`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Sukurta duomenų struktūra lentelei `arasnustatymai`
27--
28
29CREATE TABLE IF NOT EXISTS `arasnustatymai` (
30 `0` int(11) NOT NULL,
31 `1` int(11) NOT NULL,
32 `2` int(11) NOT NULL,
33 `3` int(11) NOT NULL,
34 `4` int(11) NOT NULL,
35 `5` int(11) NOT NULL,
36 `6` int(11) NOT NULL,
37 `7` int(11) NOT NULL
38) ENGINE=MyISAM DEFAULT CHARSET=latin1;
39
40--
41-- Sukurta duomenų kopija lentelei `arasnustatymai`
42--
43
44INSERT INTO `arasnustatymai` (`0`, `1`, `2`, `3`, `4`, `5`, `6`, `7`) VALUES
45(1, 1, 1, 1, 1, 1, 1, 1);
46
47-- --------------------------------------------------------
48
49--
50-- Sukurta duomenų struktūra lentelei `bans`
51--
52
53CREATE TABLE IF NOT EXISTS `bans` (
54 `Vardas` varchar(24) NOT NULL,
55 `IP-Adress` varchar(24) NOT NULL,
56 `Priezastis` varchar(24) NOT NULL,
57 `Tipas` varchar(24) NOT NULL,
58 `GaliojimoPabaiga` int(24) NOT NULL
59) ENGINE=MyISAM DEFAULT CHARSET=latin1;
60
61-- --------------------------------------------------------
62
63--
64-- Sukurta duomenų struktūra lentelei `bussinesses`
65--
66
67CREATE TABLE IF NOT EXISTS `bussinesses` (
68 `ID` tinyint(3) unsigned NOT NULL,
69 `owned` int(1) NOT NULL DEFAULT '0',
70 `owner` varchar(25) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
71 `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
72 `price` int(10) NOT NULL,
73 `earning` smallint(5) NOT NULL,
74 `maxEarning` smallint(5) NOT NULL,
75 `offer` smallint(3) NOT NULL,
76 `employees` int(10) NOT NULL,
77 `investments` smallint(3) NOT NULL,
78 `lastEdit` int(11) NOT NULL,
79 `posX` float NOT NULL,
80 `posY` float NOT NULL,
81 `posZ` float NOT NULL,
82 `interior` smallint(5) NOT NULL,
83 `world` smallint(5) NOT NULL
84) ENGINE=MyISAM DEFAULT CHARSET=utf8;
85
86--
87-- Sukurta duomenų kopija lentelei `bussinesses`
88--
89
90INSERT INTO `bussinesses` (`ID`, `owned`, `owner`, `name`, `price`, `earning`, `maxEarning`, `offer`, `employees`, `investments`, `lastEdit`, `posX`, `posY`, `posZ`, `interior`, `world`) VALUES
91(5, 0, 'Nėra', '„Verslas be pavadinimo“', 10000000, 0, 350, 0, 0, 0, 0, -2428.95, -93.7206, 35.3203, 0, 0),
92(4, 0, 'Nėra', '„Verslas be pavadinimo“', 8000000, 280, 280, 100, 305, 50, 1563879662, -2347.04, -63.1906, 35.3203, 0, 0),
93(1, 0, 'Nėra', '„Verslas be pavadinimo“', 2000000, 70, 70, 100, 80, 50, 1563880380, -2167.19, 246.204, 35.3203, 0, 0),
94(2, 0, 'Nėra', '„Verslas be pavadinimo“', 4000000, 140, 140, 100, 160, 50, 1563891401, -2161.15, 128.833, 35.3203, 0, 0),
95(3, 0, 'Nėra', '„Verslas be pavadinimo“', 6000000, 210, 210, 100, 240, 50, 1563793229, -2176.34, -42.3436, 35.3125, 0, 0),
96(6, 0, 'Nėra', '„Verslas be pavadinimo“', 12000000, 416, 420, 100, 480, 50, 1564869597, -2493.91, -142.852, 25.6093, 0, 0),
97(7, 0, 'Nėra', '„Verslas be pavadinimo“', 14000000, 0, 490, 0, 0, 0, 0, -2507.24, 47.3216, 25.6171, 0, 0),
98(8, 0, 'Nėra', '„Verslas be pavadinimo“', 100000, 3, 3, 100, 80, 100, 1563751528, -2590.11, 59.707, 4.3358, 0, 0),
99(9, 0, 'Nėra', '„Verslas be pavadinimo“', 450000, 16, 16, 100, 80, 50, 1564238649, -2591.62, 167.674, 4.3281, 0, 0),
100(10, 0, 'Nėra', '„Verslas be pavadinimo“', 940000, 32, 32, 100, 65, 50, 1564057249, -2554.81, 192.621, 6.1352, 0, 0),
101(11, 0, 'Nėra', '„Verslas be pavadinimo“', 1300000, 42, 42, 100, 80, 50, 1564858841, -2672.35, 262.183, 4.6328, 0, 0),
102(12, 0, 'Nėra', '„Verslas be pavadinimo“', 1900000, 65, 65, 100, 65, 50, 1563786473, -2266.03, 544.27, 35.1769, 0, 0),
103(13, 0, 'Nėra', '„Verslas be pavadinimo“', 12000000, 420, 420, 100, 465, 50, 1563978496, -2100.04, 482.913, 35.1935, 0, 0),
104(14, 0, 'Nėra', '„Verslas be pavadinimo“', 1000000, 0, 35, 100, 65, 50, 1563751082, -1966.86, 434.343, 35.1717, 0, 0),
105(15, 0, 'Nėra', '„Verslas be pavadinimo“', 8000000, 350, 350, 100, 300, 50, 1564341486, -2033.46, 148.596, 28.8358, 0, 0),
106(16, 0, 'Nėra', '„Verslas be pavadinimo“', 100000000, 0, 3500, 100, 3985, 50, 1563792580, 386.361, -1805.33, 7.8298, 0, 0),
107(17, 0, 'Nėra', '„Verslas be pavadinimo“', 6000000, 210, 210, 100, 225, 50, 1564164493, 380.58, -2026, 7.8358, 0, 0),
108(18, 0, 'Nėra', '„Verslas be pavadinimo“', 50000000, 0, 1750, 0, 0, 0, 0, 277.514, -1433.93, 13.9073, 0, 0),
109(19, 0, 'Nėra', '„Verslas be pavadinimo“', 6000000, 0, 210, 0, 0, 0, 0, 785.34, -1034.09, 24.5191, 0, 0),
110(20, 0, 'Nėra', '„Verslas be pavadinimo“', 75000000, 0, 2625, 0, 0, 0, 0, 2185.88, 1667.3, 11.0955, 0, 0),
111(21, 0, 'Nėra', '„Verslas be pavadinimo“', 900000, 32, 32, 100, 65, 50, 1565459280, 1969.39, 1623.31, 12.8613, 0, 0),
112(22, 0, 'Nėra', '„Verslas be pavadinimo“', 1500000, 105, 105, 50, 70, 50, 1564401142, 2089.65, 1514.75, 10.8203, 0, 0),
113(0, 0, 'Nėra', '„Verslas be pavadinimo“', 500000, 17, 18, 1, 80, 20, 1564648942, -1995.55, 879.716, 45.4453, 0, 0),
114(23, 0, 'Nėra', '„Verslas be pavadinimo“', 250000, 17, 17, 100, 80, 100, 1563814328, -1712.62, 1270.73, 7.1971, 0, 0),
115(24, 0, 'Nėra', '„Verslas be pavadinimo“', 1000000, 35, 35, 50, 80, 50, 1565000336, -1552.4, 1168.32, 7.1875, 0, 0),
116(25, 0, 'Nėra', '„Verslas be pavadinimo“', 300000, 24, 24, 100, 80, 50, 1564307096, 2087.45, 2076.44, 11.0578, 0, 0),
117(26, 0, 'Nėra', '„Verslas be pavadinimo“', 135000, 10, 12, 0, 80, 0, 1564665579, 2193.54, 1990.92, 12.2966, 0, 0),
118(27, 0, 'Nėra', '„Verslas be pavadinimo“', 500000, 35, 35, 50, 75, 50, 1564003304, 567.059, -1742.51, 12.8846, 0, 0);
119
120-- --------------------------------------------------------
121
122--
123-- Sukurta duomenų struktūra lentelei `clothesforcredits`
124--
125
126CREATE TABLE IF NOT EXISTS `clothesforcredits` (
127`ID` int(11) NOT NULL,
128 `PlayerName` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
129 `SkinID` int(11) NOT NULL DEFAULT '0'
130) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
131
132-- --------------------------------------------------------
133
134--
135-- Sukurta duomenų struktūra lentelei `darbuinformacija`
136--
137
138CREATE TABLE IF NOT EXISTS `darbuinformacija` (
139`DarboID` int(11) NOT NULL,
140 `1RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
141 `2RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
142 `3RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
143 `4RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
144 `5RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
145 `6RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
146 `7RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
147 `8RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
148 `9RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
149 `10RangoPavadinimas` varchar(30) COLLATE utf8_lithuanian_ci NOT NULL,
150 `DarboFondas` int(11) NOT NULL DEFAULT '0'
151) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
152
153--
154-- Sukurta duomenų kopija lentelei `darbuinformacija`
155--
156
157INSERT INTO `darbuinformacija` (`DarboID`, `1RangoPavadinimas`, `2RangoPavadinimas`, `3RangoPavadinimas`, `4RangoPavadinimas`, `5RangoPavadinimas`, `6RangoPavadinimas`, `7RangoPavadinimas`, `8RangoPavadinimas`, `9RangoPavadinimas`, `10RangoPavadinimas`, `DarboFondas`) VALUES
158(1, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
159(2, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
160(3, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
161(4, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
162(5, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
163(6, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
164(7, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
165(8, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
166(9, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
167(10, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
168(11, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
169(21, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
170(22, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
171(23, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
172(25, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0),
173(26, 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 'Nenustatyta', 0);
174
175-- --------------------------------------------------------
176
177--
178-- Sukurta duomenų struktūra lentelei `darbuotojai`
179--
180
181CREATE TABLE IF NOT EXISTS `darbuotojai` (
182`ID` int(11) NOT NULL,
183 `Vardas` varchar(256) NOT NULL,
184 `SiandienZaista` int(11) NOT NULL,
185 `AtvykimaiTotal` int(11) NOT NULL,
186 `BaudosTotal` int(11) NOT NULL,
187 `UzdarbisSiandien` int(11) NOT NULL,
188 `PagydimaiTotal` int(11) NOT NULL,
189 `SiandienParduotaIrankiu` int(11) NOT NULL,
190 `NuveztiKroviniai` int(11) NOT NULL,
191 `SiandienParduotaNark` int(11) NOT NULL,
192 `SiandienParduotaGun` int(11) NOT NULL,
193 `JobID` int(11) NOT NULL
194) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
195
196-- --------------------------------------------------------
197
198--
199-- Sukurta duomenų struktūra lentelei `darbu_blist`
200--
201
202CREATE TABLE IF NOT EXISTS `darbu_blist` (
203`id` int(11) NOT NULL,
204 `name` varchar(24) NOT NULL,
205 `reason` varchar(128) CHARACTER SET utf16 COLLATE utf16_lithuanian_ci NOT NULL,
206 `time` int(11) NOT NULL,
207 `admin` varchar(24) NOT NULL,
208 `date` varchar(24) NOT NULL,
209 `date_end` varchar(24) NOT NULL
210) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
211
212-- --------------------------------------------------------
213
214--
215-- Sukurta duomenų struktūra lentelei `dchat`
216--
217
218CREATE TABLE IF NOT EXISTS `dchat` (
219 `name` varchar(256) NOT NULL,
220 `rangas` varchar(256) NOT NULL,
221 `zinute` varchar(256) NOT NULL,
222 `data` varchar(256) NOT NULL,
223 `darbas` int(11) NOT NULL
224) ENGINE=InnoDB DEFAULT CHARSET=latin1;
225
226-- --------------------------------------------------------
227
228--
229-- Sukurta duomenų struktūra lentelei `direktoriuzinutes`
230--
231
232CREATE TABLE IF NOT EXISTS `direktoriuzinutes` (
233 `DarboID` int(11) NOT NULL,
234 `Zinute` varchar(150) NOT NULL
235) ENGINE=MyISAM DEFAULT CHARSET=latin1;
236
237--
238-- Sukurta duomenų kopija lentelei `direktoriuzinutes`
239--
240
241INSERT INTO `direktoriuzinutes` (`DarboID`, `Zinute`) VALUES
242(1, ' \r\nNenustatyta'),
243(2, ' \r\nNenustatyta'),
244(3, ' \r\nNenustatyta'),
245(4, ' \r\nNenustatyta'),
246(5, ' \r\nNenustatyta'),
247(6, ' \r\nNenustatyta'),
248(7, ' \r\nNenustatyta'),
249(8, ' \r\nNenustatyta'),
250(9, ' \r\nNenustatyta'),
251(10, ' \r\nNenustatyta'),
252(11, ' \r\nNenustatyta'),
253(21, ' \r\nNenustatyta'),
254(22, ' \r\nNenustatyta'),
255(23, ' \r\nNenustatyta'),
256(25, ' \r\nNenustatyta'),
257(26, ' \r\nNenustatyta');
258
259-- --------------------------------------------------------
260
261--
262-- Sukurta duomenų struktūra lentelei `distorijos`
263--
264
265CREATE TABLE IF NOT EXISTS `distorijos` (
266`id` int(11) NOT NULL,
267 `DARBOID` int(11) NOT NULL DEFAULT '0',
268 `Data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
269 `Informacija` varchar(200) COLLATE utf8_lithuanian_ci NOT NULL
270) ENGINE=InnoDB AUTO_INCREMENT=2869 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
271
272-- --------------------------------------------------------
273
274--
275-- Sukurta duomenų struktūra lentelei `drk_blist`
276--
277
278CREATE TABLE IF NOT EXISTS `drk_blist` (
279`id` int(11) NOT NULL,
280 `name` varchar(24) NOT NULL,
281 `reason` varchar(128) CHARACTER SET utf16 COLLATE utf16_lithuanian_ci NOT NULL,
282 `time` int(11) NOT NULL,
283 `admin` varchar(24) NOT NULL,
284 `date` varchar(24) NOT NULL,
285 `date_end` varchar(24) NOT NULL
286) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
287
288-- --------------------------------------------------------
289
290--
291-- Sukurta duomenų struktūra lentelei `d_messages`
292--
293
294CREATE TABLE IF NOT EXISTS `d_messages` (
295`id` int(11) NOT NULL,
296 `m_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
297 `m_message` varchar(256) CHARACTER SET utf16 COLLATE utf16_lithuanian_ci NOT NULL
298) ENGINE=InnoDB AUTO_INCREMENT=9464 DEFAULT CHARSET=latin1;
299
300-- --------------------------------------------------------
301
302--
303-- Sukurta duomenų struktūra lentelei `fishing_data`
304--
305
306CREATE TABLE IF NOT EXISTS `fishing_data` (
307`id` int(11) NOT NULL,
308 `belongs_to` varchar(33) NOT NULL,
309 `fishingRod` int(3) NOT NULL,
310 `fishingNet` int(3) NOT NULL,
311 `fishingFloat` int(3) NOT NULL,
312 `fishCount0` int(11) NOT NULL,
313 `fishAmount0` float NOT NULL,
314 `fishBiggestSize0` float NOT NULL,
315 `fishCount1` int(11) NOT NULL,
316 `fishAmount1` float NOT NULL,
317 `fishBiggestSize1` float NOT NULL,
318 `fishCount2` int(11) NOT NULL,
319 `fishAmount2` float NOT NULL,
320 `fishBiggestSize2` float NOT NULL,
321 `fishCount3` int(11) NOT NULL,
322 `fishAmount3` float NOT NULL,
323 `fishBiggestSize3` float NOT NULL,
324 `fishCount4` int(11) NOT NULL,
325 `fishAmount4` float NOT NULL,
326 `fishBiggestSize4` float NOT NULL,
327 `fishCount5` int(11) NOT NULL,
328 `fishAmount5` float NOT NULL,
329 `fishBiggestSize5` float NOT NULL,
330 `fishCount6` int(11) NOT NULL,
331 `fishAmount6` float NOT NULL,
332 `fishBiggestSize6` float NOT NULL,
333 `fishCount7` int(11) NOT NULL,
334 `fishAmount7` float NOT NULL,
335 `fishBiggestSize7` float NOT NULL,
336 `fishCount8` int(11) NOT NULL,
337 `fishAmount8` float NOT NULL,
338 `fishBiggestSize8` float NOT NULL,
339 `fishCount9` int(11) NOT NULL,
340 `fishAmount9` float NOT NULL,
341 `fishBiggestSize9` float NOT NULL,
342 `fishCount10` int(11) NOT NULL,
343 `fishAmount10` float NOT NULL,
344 `fishBiggestSize10` float NOT NULL,
345 `fishCount11` int(11) NOT NULL,
346 `fishAmount11` float NOT NULL,
347 `fishBiggestSize11` float NOT NULL,
348 `fishCount12` int(11) NOT NULL,
349 `fishAmount12` float NOT NULL,
350 `fishBiggestSize12` float NOT NULL,
351 `fishCount13` int(11) NOT NULL,
352 `fishAmount13` float NOT NULL,
353 `fishBiggestSize13` float NOT NULL,
354 `fishCount14` int(11) NOT NULL,
355 `fishAmount14` float NOT NULL,
356 `fishBiggestSize14` float NOT NULL,
357 `fishCount15` int(11) NOT NULL,
358 `fishAmount15` float NOT NULL,
359 `fishBiggestSize15` float NOT NULL,
360 `fishBait` int(11) NOT NULL,
361 `fishingBait` int(11) NOT NULL DEFAULT '0',
362 `fishesMoneyToday` int(11) NOT NULL DEFAULT '0',
363 `fishesCaughtToday` int(11) NOT NULL DEFAULT '0'
364) ENGINE=InnoDB AUTO_INCREMENT=1649 DEFAULT CHARSET=utf8mb4;
365
366-- --------------------------------------------------------
367
368--
369-- Sukurta duomenų struktūra lentelei `ftbnustatymai`
370--
371
372CREATE TABLE IF NOT EXISTS `ftbnustatymai` (
373 `FTB541Vehicle_RANGAS` int(11) NOT NULL,
374 `FTB598Vehicle_RANGAS` int(11) NOT NULL,
375 `FTB490Vehicle_RANGAS` int(11) NOT NULL,
376 `FTB469Vehicle_RANGAS` int(11) NOT NULL,
377 `FTB286SKIN_RANGAS` int(11) NOT NULL,
378 `FTB305SKIN_RANGAS` int(11) NOT NULL,
379 `FTB211SKIN_RANGAS` int(11) NOT NULL,
380 `FTB469Ve5hicle_RANGAS` int(11) NOT NULL,
381 `FTB304SKIN_RANGAS` int(11) NOT NULL
382) ENGINE=MyISAM DEFAULT CHARSET=latin1;
383
384--
385-- Sukurta duomenų kopija lentelei `ftbnustatymai`
386--
387
388INSERT INTO `ftbnustatymai` (`FTB541Vehicle_RANGAS`, `FTB598Vehicle_RANGAS`, `FTB490Vehicle_RANGAS`, `FTB469Vehicle_RANGAS`, `FTB286SKIN_RANGAS`, `FTB305SKIN_RANGAS`, `FTB211SKIN_RANGAS`, `FTB469Ve5hicle_RANGAS`, `FTB304SKIN_RANGAS`) VALUES
389(1, 1, 1, 1, 1, 1, 1, 1, 1);
390
391-- --------------------------------------------------------
392
393--
394-- Sukurta duomenų struktūra lentelei `furistainustatymai`
395--
396
397CREATE TABLE IF NOT EXISTS `furistainustatymai` (
398 `F515Vehicle_RANGAS` int(11) NOT NULL,
399 `F514Vehicle_RANGAS` int(11) NOT NULL,
400 `F403Vehicle_RANGAS` int(11) NOT NULL,
401 `F32SKIN_RANGAS` int(11) NOT NULL,
402 `F44SKIN_RANGAS` int(11) NOT NULL,
403 `F261SKIN_RANGAS` int(11) NOT NULL,
404 `F272SKIN_RANGAS` int(11) NOT NULL,
405 `Vaistineles` int(11) NOT NULL,
406 `Nelegalu` int(11) NOT NULL,
407 `Kuras` int(11) NOT NULL
408) ENGINE=MyISAM DEFAULT CHARSET=latin1;
409
410--
411-- Sukurta duomenų kopija lentelei `furistainustatymai`
412--
413
414INSERT INTO `furistainustatymai` (`F515Vehicle_RANGAS`, `F514Vehicle_RANGAS`, `F403Vehicle_RANGAS`, `F32SKIN_RANGAS`, `F44SKIN_RANGAS`, `F261SKIN_RANGAS`, `F272SKIN_RANGAS`, `Vaistineles`, `Nelegalu`, `Kuras`) VALUES
415(1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
416
417-- --------------------------------------------------------
418
419--
420-- Sukurta duomenų struktūra lentelei `garazai`
421--
422
423CREATE TABLE IF NOT EXISTS `garazai` (
424 `ID` int(11) NOT NULL,
425 `Nupirktas` int(11) NOT NULL,
426 `Savininkas` varchar(24) NOT NULL,
427 `IkiKadaPirktas` int(25) NOT NULL
428) ENGINE=MyISAM DEFAULT CHARSET=latin1;
429
430--
431-- Sukurta duomenų kopija lentelei `garazai`
432--
433
434INSERT INTO `garazai` (`ID`, `Nupirktas`, `Savininkas`, `IkiKadaPirktas`) VALUES
435(0, 0, 'Nera', 0),
436(1, 0, 'Nera', 0),
437(2, 0, 'Nera', 0),
438(3, 0, 'Nera', 0),
439(4, 0, 'Nera', 0),
440(5, 0, 'Nera', 0),
441(6, 0, 'Nera', 0),
442(7, 0, 'Nera', 0),
443(8, 0, 'Nera', 0),
444(9, 0, 'Nera', 0),
445(10, 0, 'Nera', 0),
446(11, 0, 'Nera', 0),
447(12, 0, 'Nera', 0),
448(13, 0, 'Nera', 0),
449(14, 0, 'Nera', 0),
450(15, 0, 'Nera', 0),
451(16, 0, 'Nera', 0),
452(17, 0, 'Nera', 0),
453(18, 0, 'Nera', 0),
454(19, 0, 'Nera', 0),
455(20, 0, 'Nera', 0),
456(21, 0, 'Nera', 0),
457(22, 0, 'Nera', 0),
458(23, 0, 'Nera', 0),
459(24, 0, 'Nera', 0),
460(25, 0, 'Nera', 0),
461(26, 0, 'Nera', 0),
462(27, 0, 'Nera', 0),
463(28, 0, 'Nera', 0),
464(29, 0, 'Nera', 0),
465(30, 0, 'Nera', 0),
466(31, 0, 'Nera', 0);
467
468-- --------------------------------------------------------
469
470--
471-- Sukurta duomenų struktūra lentelei `genovesenustatymai`
472--
473
474CREATE TABLE IF NOT EXISTS `genovesenustatymai` (
475 `0` int(11) NOT NULL DEFAULT '1',
476 `1` int(11) NOT NULL DEFAULT '1',
477 `2` int(11) NOT NULL DEFAULT '1',
478 `3` int(11) NOT NULL DEFAULT '1',
479 `4` int(11) NOT NULL DEFAULT '1',
480 `5` int(11) NOT NULL DEFAULT '1',
481 `6` int(11) NOT NULL DEFAULT '1',
482 `7` int(11) NOT NULL DEFAULT '1',
483 `GenoveseAmmoShotgun` int(11) NOT NULL,
484 `GenoveseAmmoDeagle` int(11) NOT NULL,
485 `GenoveseAmmoAK47` int(11) NOT NULL,
486 `GenoveseAmmoSniper` int(11) NOT NULL
487) ENGINE=MyISAM DEFAULT CHARSET=latin1;
488
489--
490-- Sukurta duomenų kopija lentelei `genovesenustatymai`
491--
492
493INSERT INTO `genovesenustatymai` (`0`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `GenoveseAmmoShotgun`, `GenoveseAmmoDeagle`, `GenoveseAmmoAK47`, `GenoveseAmmoSniper`) VALUES
494(1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0);
495
496-- --------------------------------------------------------
497
498--
499-- Sukurta duomenų struktūra lentelei `gpnustatymai`
500--
501
502CREATE TABLE IF NOT EXISTS `gpnustatymai` (
503 `1` int(11) NOT NULL,
504 `2` int(11) NOT NULL,
505 `3` int(11) NOT NULL,
506 `4` int(11) NOT NULL,
507 `5` int(11) NOT NULL,
508 `6` int(11) NOT NULL
509) ENGINE=MyISAM DEFAULT CHARSET=latin1;
510
511--
512-- Sukurta duomenų kopija lentelei `gpnustatymai`
513--
514
515INSERT INTO `gpnustatymai` (`1`, `2`, `3`, `4`, `5`, `6`) VALUES
516(1, 1, 1, 1, 1, 1);
517
518-- --------------------------------------------------------
519
520--
521-- Sukurta duomenų struktūra lentelei `gssettings`
522--
523
524CREATE TABLE IF NOT EXISTS `gssettings` (
525 `1` int(11) NOT NULL,
526 `2` int(11) NOT NULL,
527 `3` int(11) NOT NULL,
528 `4` int(11) NOT NULL,
529 `5` int(11) NOT NULL,
530 `6` int(11) NOT NULL,
531 `GSAmmoShotgun` int(11) NOT NULL,
532 `GSAmmoDeagle` int(11) NOT NULL,
533 `GSAmmoAK47` int(11) NOT NULL,
534 `GSAmmoSniper` int(11) NOT NULL
535) ENGINE=InnoDB DEFAULT CHARSET=latin1;
536
537--
538-- Sukurta duomenų kopija lentelei `gssettings`
539--
540
541INSERT INTO `gssettings` (`1`, `2`, `3`, `4`, `5`, `6`, `GSAmmoShotgun`, `GSAmmoDeagle`, `GSAmmoAK47`, `GSAmmoSniper`) VALUES
542(1, 1, 1, 1, 1, 1, 0, 0, 0, 0);
543
544-- --------------------------------------------------------
545
546--
547-- Sukurta duomenų struktūra lentelei `gzones`
548--
549
550CREATE TABLE IF NOT EXISTS `gzones` (
551`id` int(11) NOT NULL,
552 `zoneId` int(11) NOT NULL,
553 `pos` varchar(256) NOT NULL,
554 `svarba` int(11) NOT NULL,
555 `valdo` int(11) NOT NULL,
556 `car1_pos` varchar(128) NOT NULL,
557 `car2_pos` varchar(128) NOT NULL,
558 `car3_pos` varchar(128) NOT NULL,
559 `pickup` varchar(128) NOT NULL,
560 `zoneName` varchar(64) NOT NULL
561) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
562
563--
564-- Sukurta duomenų kopija lentelei `gzones`
565--
566
567INSERT INTO `gzones` (`id`, `zoneId`, `pos`, `svarba`, `valdo`, `car1_pos`, `car2_pos`, `car3_pos`, `pickup`, `zoneName`) VALUES
568(1, 0, '1455 -1306 1722 -1159 ', 5, 0, '', '', '', '1514.4076 -1219.2058 20.2252', 'Laiptai'),
569(2, 1, '1713 -1476 1860 -1294', 10, 0, '', '', '', '1776.4329 -1354.0306 15.7561', 'Balkonai'),
570(3, 2, '1844 -1458 1995 -1345', 5, 0, '', '', '', '1919.5837 -1405.4381 13.5703', 'BMX parkas'),
571(4, 3, '1854 -1258 2075 -1083', 5, 0, '', '', '', '1966.4501 -1176.9424 20.0307', 'Parkas'),
572(5, 4, '2735 -1421 2914 -1235', 5, 0, '', '', '', '2804.1887 -1253.3688 46.9531', 'Nauja zona'),
573(6, 5, '2811 -2078 2928 -1872', 5, 0, '', '', '', '2854.5134 -1977.2472 10.9390', 'Papludimys'),
574(7, 6, '2681 -2588 2828 -2321 ', 2, 0, '', '', '', '2784.3513 -2454.6221 13.6345', 'Uostas'),
575(8, 7, '334 -2099 434 -1999', 3, 0, '', '', '', '386.4927 -2063.6421 7.8359', '/tpls tiltas'),
576(9, 8, '744 -1705 868 -1571', 5, 0, '', '', '', '788.3828 -1615.3905 13.3828', 'Hesburgeris'),
577(10, 9, '767 -1416 921 -1299', 7, 0, '', '', '', '825.0008 -1362.3889 -0.5078', 'LS Stotis'),
578(11, 10, '795 -1314 945 -1147', 5, 0, '', '', '', '895.5574 -1248.4930 15.4899', 'Angarai'),
579(12, 11, '802 -1136 963 -1039', 5, 0, '', '', '', '880.6967 -1102.1265 24.2969', 'Kapines'),
580(13, 12, '923 -1334 1079 -1204', 9, 0, '', '', '', '986.7234 -1273.6095 15.1797', 'Nauja zona'),
581(14, 13, '1964 -2121 2120 -1938', 12, 0, '', '', '', '2049.8606 -2091.0256 16.0759', 'LS traukiniu stotis'),
582(16, 14, '2409 -1996 2548 -1858', 5, 0, '', '', '', '2473.2314 -1925.9260 13.5469', 'Ballas zona'),
583(17, 15, '1458 -1301 1657 -1169', 5, 0, '', '', '', '1723.1066 -1630.3879 20.2141', 'Ofisai'),
584(18, 16, '2351 -1543 2598 -1440 ', 7, 0, '', '', '', '2489.5381 -1462.9990 24.0209', 'Plovykla');
585
586-- --------------------------------------------------------
587
588--
589-- Sukurta duomenų struktūra lentelei `houses`
590--
591
592CREATE TABLE IF NOT EXISTS `houses` (
593 `HouseID` int(11) NOT NULL,
594 `HouseBought` tinyint(4) NOT NULL DEFAULT '0',
595 `HouseCost` int(11) NOT NULL,
596 `HousePosX` float NOT NULL,
597 `HousePosY` float NOT NULL,
598 `HousePosZ` float NOT NULL,
599 `HouseOwner` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'Nėra',
600 `HouseVirtualWorld` int(11) NOT NULL DEFAULT '0',
601 `HouseInteriorNumber` int(11) NOT NULL DEFAULT '0',
602 `HouseForCredits` int(11) NOT NULL DEFAULT '0',
603 `HouseDoorsLocked` int(11) NOT NULL DEFAULT '1',
604 `HouseMoneyInside` int(11) NOT NULL DEFAULT '0',
605 `SoldForCredits` int(11) NOT NULL DEFAULT '0'
606) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
607
608--
609-- Sukurta duomenų kopija lentelei `houses`
610--
611
612INSERT INTO `houses` (`HouseID`, `HouseBought`, `HouseCost`, `HousePosX`, `HousePosY`, `HousePosZ`, `HouseOwner`, `HouseVirtualWorld`, `HouseInteriorNumber`, `HouseForCredits`, `HouseDoorsLocked`, `HouseMoneyInside`, `SoldForCredits`) VALUES
613(1, 0, 100000, -2110.09, 344.68, 35.181, 'Nera', 0, 0, 0, 1, 0, 0),
614(13, 0, 100000, -2791.93, 218.781, 7.859, 'Nera', 0, 0, 0, 1, 0, 0),
615(14, 0, 100000, -2792.16, 212.014, 10.055, 'Nera', 0, 0, 0, 1, 0, 0),
616(15, 0, 100000, -2791.6, 200.586, 7.859, 'Nera', 0, 0, 0, 1, 0, 0),
617(16, 0, 150000, -2791.6, 194.577, 10.055, 'Nera', 0, 0, 0, 1, 0, 0),
618(17, 0, 130000, -2789.19, 183.817, 10.063, 'Nera', 0, 0, 0, 1, 0, 0),
619(18, 0, 330000, 315.941, -1770, 4.639, 'Nera', 0, 0, 0, 1, 0, 0),
620(19, 0, 200000, 305.394, -1770.23, 4.538, 'Nera', 0, 0, 0, 1, 0, 0),
621(21, 0, 300000, 168.026, -1769.47, 4.47, 'Nera', 0, 0, 0, 1, 0, 0),
622(23, 0, 100000, -2379.02, 2444.55, 10.169, 'Nera', 0, 0, 0, 1, 0, 0),
623(24, 0, 200000, -2386.42, 2447.58, 10.169, 'Nera', 0, 0, 0, 1, 0, 0),
624(25, 0, 140000, -2424.57, 2448.77, 13.149, 'Nera', 0, 0, 0, 1, 0, 0),
625(26, 0, 100000, -2472.12, 2450.99, 17.323, 'Nera', 0, 0, 0, 1, 0, 0),
626(27, 0, 100000, -2479.83, 2449.96, 17.323, 'Nera', 0, 0, 0, 1, 0, 0),
627(29, 0, 500000, -2552.07, 2266.68, 5.476, 'Nera', 0, 0, 0, 1, 400000, 0),
628(30, 0, 100000, -2583.51, 2307.88, 7.003, 'Nera', 0, 0, 0, 1, 0, 0),
629(37, 0, 180000, 915.809, -1621.98, -1.734, 'Nera', 3, 4, 0, 1, 0, 0),
630(38, 0, 180000, 915.464, -1619.99, -1.741, 'Nera', 3, 4, 0, 1, 0, 0),
631(39, 0, 180000, 922.444, -1619.9, -1.741, 'Nera', 3, 4, 0, 1, 0, 0),
632(40, 0, 180000, 922.458, -1622.03, -1.741, 'Nera', 3, 4, 0, 1, 0, 0),
633(41, 0, 180000, 922.579, -1622.24, -1.741, 'Nera', 2, 4, 0, 1, 0, 0),
634(42, 0, 180000, 915.8, -1622.22, -1.734, 'Nera', 2, 4, 0, 1, 0, 0),
635(43, 0, 180000, 915.595, -1619.84, -1.741, 'Nera', 2, 4, 0, 1, 0, 0),
636(44, 0, 180000, 922.312, -1619.97, -1.741, 'Nera', 2, 4, 0, 1, 0, 0),
637(45, 0, 180000, 922.531, -1622.06, -1.741, 'Nera', 1, 4, 0, 1, 0, 0),
638(46, 0, 180000, 915.91, -1622.24, -1.734, 'Nera', 1, 4, 0, 1, 0, 0),
639(47, 0, 180000, 915.562, -1620.06, -1.741, 'Nera', 1, 4, 0, 1, 0, 0),
640(48, 0, 180000, 922.507, -1619.91, -1.741, 'Nera', 1, 4, 0, 1, 0, 0),
641(51, 0, 180000, 915.66, -1619.89, -1.741, 'Nera', 4, 4, 0, 1, 0, 0),
642(53, 0, 180000, 922.322, -1622.27, -1.741, 'Nera', 4, 4, 0, 1, 0, 0),
643(54, 0, 180000, 922.486, -1619.89, -1.741, 'Nera', 4, 4, 0, 1, 0, 0),
644(55, 0, 180000, 915.961, -1622.21, -1.734, 'Nera', 4, 4, 0, 1, 0, 0),
645(56, 0, 1000000, -2524, 2238.87, 5.398, 'Nera', 0, 9, 0, 1, 9100000, 0),
646(57, 0, 1200000, 1539.94, -851.788, 64.336, 'Nera', 0, 9, 0, 1, 0, 0),
647(58, 0, 1200000, 1534.84, -800.068, 72.849, 'Nera', 0, 9, 0, 1, 0, 0),
648(59, 0, 1200000, 1527.67, -772.807, 80.578, 'Nera', 0, 9, 0, 1, 0, 0),
649(60, 0, 1000000, 1497.06, -688.156, 95.546, 'Nera', 0, 9, 0, 1, 0, 0),
650(63, 0, 1000000, 1094.9, -647.339, 113.648, 'Nera', 0, 9, 0, 1, 0, 0),
651(64, 0, 1000000, 1045.22, -642.925, 120.117, 'Nera', 0, 9, 0, 1, 0, 0),
652(65, 0, 1000000, 980.575, -677.202, 121.976, 'Nera', 0, 9, 0, 1, 13500000, 0),
653(66, 0, 1000000, 945.963, -709.904, 122.62, 'Nera', 0, 9, 0, 1, 0, 0),
654(67, 0, 1000000, 898.026, -676.964, 116.89, 'Nera', 0, 9, 0, 1, 0, 0),
655(69, 0, 1000000, -2671.24, 928.748, 79.703, 'Nera', 0, 9, 0, 1, 0, 0),
656(70, 0, 1000000, -2660.16, 877.03, 79.774, 'Nera', 0, 9, 0, 1, 0, 0),
657(72, 0, 700000, -2591.56, 927.887, 65.016, 'Nera', 0, 7, 0, 1, 0, 0),
658(73, 0, 700000, -2591.2, 935.9, 68.93, 'Nera', 0, 7, 0, 1, 0, 0),
659(74, 0, 700000, -2591.76, 944.45, 70.43, 'Nera', 0, 7, 0, 1, 0, 0),
660(75, 0, 700000, -2591.66, 960.779, 78.45, 'Nera', 0, 7, 0, 1, 0, 0),
661(76, 0, 700000, -2597.34, 968.903, 78.284, 'Nera', 0, 7, 0, 1, 0, 0),
662(77, 0, 700000, -2597.32, 979.854, 78.273, 'Nera', 0, 7, 0, 1, 0, 0),
663(78, 0, 700000, -2596.66, 986.343, 78.273, 'Nera', 0, 7, 0, 1, 0, 0),
664(80, 0, 700000, -2737.34, 846.691, 59.273, 'Nera', 0, 7, 0, 1, 0, 0),
665(81, 0, 1000000, -2706.73, 864.765, 70.703, 'Nera', 0, 8, 0, 1, 0, 0),
666(82, 0, 700000, -2738.99, 866.227, 65.217, 'Nera', 0, 7, 0, 1, 0, 0),
667(83, 0, 700000, -2738.44, 836.74, 56.355, 'Nera', 0, 7, 0, 1, 0, 0),
668(84, 0, 700000, -2737.18, 822.466, 53.6, 'Nera', 0, 7, 0, 1, 0, 0),
669(85, 0, 700000, -2726.94, 822.428, 53.59, 'Nera', 0, 7, 0, 1, 0, 0),
670(86, 0, 700000, -2726.63, 829.625, 53.813, 'Nera', 0, 7, 0, 1, 0, 0),
671(87, 0, 1000000, -2700.45, 820.665, 49.984, 'Nera', 0, 7, 0, 1, 0, 0),
672(88, 0, 700000, -2684.85, 820.182, 49.984, 'Nera', 0, 7, 0, 1, 0, 0),
673(89, 0, 700000, -2667.2, 819.452, 49.984, 'Nera', 0, 7, 0, 1, 0, 0),
674(90, 0, 700000, -2652.66, 819.897, 49.984, 'Nera', 0, 7, 0, 1, 0, 0),
675(91, 0, 700000, -2641.86, 819.86, 49.984, 'Nera', 0, 7, 0, 1, 0, 0),
676(92, 0, 700000, -2645.55, 803.655, 49.977, 'Nera', 0, 7, 0, 1, 0, 0),
677(93, 0, 700000, -2659.68, 803.082, 49.977, 'Nera', 0, 7, 0, 1, 0, 0),
678(94, 0, 700000, -2670.35, 803.091, 49.977, 'Nera', 0, 7, 0, 1, 0, 0),
679(95, 0, 700000, -2677.15, 803.085, 49.977, 'Nera', 0, 7, 0, 1, 0, 0),
680(96, 0, 700000, -2687.58, 803.321, 49.977, 'Nera', 0, 7, 0, 1, 0, 0),
681(97, 0, 700000, -2698.56, 803.28, 49.97, 'Nera', 0, 7, 0, 1, 0, 0),
682(98, 0, 700000, -2709.68, 803.307, 49.977, 'Nera', 0, 7, 0, 1, 0, 0),
683(99, 0, 700000, -2738.96, 801.484, 53.063, 'Nera', 0, 7, 0, 1, 0, 0),
684(100, 0, 700000, -2739.01, 789.071, 54.383, 'Nera', 0, 7, 0, 1, 0, 0),
685(101, 0, 700000, -2738.67, 771.992, 54.383, 'Nera', 0, 7, 0, 1, 0, 0),
686(102, 0, 700000, -2738.63, 759.093, 54.383, 'Nera', 0, 7, 0, 1, 0, 0),
687(103, 0, 700000, -2739.34, 755.049, 52.962, 'Nera', 0, 7, 0, 1, 0, 0),
688(104, 0, 1000000, 1286.11, -1308.34, 13.545, 'Nera', 0, 9, 0, 1, 0, 0),
689(105, 0, 1000000, 1286.11, -1328.66, 13.552, 'Nera', 0, 9, 0, 1, 0, 0),
690(106, 0, 1000000, 1286.43, -1349.6, 13.569, 'Nera', 0, 9, 0, 1, 0, 0),
691(107, 0, 1000000, 1258.66, -785.516, 92.03, 'Nera', 0, 9, 0, 1, 0, 0),
692(108, 0, 1000000, 1093.79, -806.85, 107.42, 'Nera', 0, 9, 0, 1, 0, 0),
693(109, 0, 200000, 937.551, -847.996, 93.69, 'Nera', 0, 9, 0, 1, 0, 0),
694(110, 0, 200000, 910.033, -817.47, 103.126, 'Nera', 0, 9, 0, 1, 0, 0),
695(111, 0, 200000, 989.731, -828.685, 95.469, 'Nera', 0, 9, 0, 1, 0, 0),
696(112, 0, 120000, 1017.03, -763.363, 112.563, 'Nera', 0, 9, 0, 1, 0, 0),
697(113, 0, 1000000, 1034.79, -813.191, 101.852, 'Nera', 0, 9, 0, 1, 0, 0),
698(114, 0, 1000000, 1112.64, -742.212, 100.133, 'Nera', 0, 9, 0, 1, 0, 0),
699(115, 0, 1000000, 1331.63, -633.032, 109.135, 'Nera', 0, 9, 0, 1, 0, 0),
700(116, 0, 1000000, 1442.53, -629.231, 95.719, 'Nera', 0, 9, 0, 1, 0, 0),
701(117, 0, 1000000, 724.776, -999.31, 52.734, 'Nera', 0, 9, 0, 1, 0, 0),
702(118, 0, 1000000, 700.23, -1060.38, 49.422, 'Nera', 0, 9, 0, 1, 0, 0),
703(119, 0, 1500000, 647.461, -1058.05, 52.58, 'Nera', 0, 7, 0, 1, 0, 0),
704(120, 0, 1000000, 645.927, -1117.49, 44.207, 'Nera', 0, 9, 0, 1, 0, 0),
705(121, 0, 1000000, 559.145, -1076.25, 72.922, 'Nera', 0, 9, 0, 1, 0, 0),
706(122, 0, 1000000, 497.527, -1095.05, 82.359, 'Nera', 0, 9, 0, 1, 0, 0),
707(123, 0, 1000000, 416.649, -1154.05, 76.688, 'Nera', 0, 7, 0, 1, 0, 0),
708(124, 0, 1000000, 300.312, -1154.52, 81.39, 'Nera', 0, 9, 0, 1, 0, 0),
709(125, 0, 1500000, 352.255, -1197.84, 76.516, 'Nera', 0, 7, 0, 1, 0, 0),
710(126, 0, 1000000, 253.266, -1269.94, 74.424, 'Nera', 0, 9, 0, 1, 0, 0),
711(127, 0, 1000000, 254.611, -1367.01, 53.109, 'Nera', 0, 9, 0, 1, 0, 0),
712(129, 0, 1000000, 227.923, -1405.41, 51.609, 'Nera', 0, 7, 0, 1, 0, 0),
713(130, 0, 150000, 280.849, -1767.33, 4.549, 'Nera', 0, 7, 0, 1, 0, 0),
714(131, 0, 100000, 192.845, -1770.02, 4.31, 'Nera', 0, 4, 0, 1, 0, 0),
715(132, 0, 150000, 206.848, -1769.58, 4.355, 'Nera', 0, 4, 0, 1, 0, 0),
716(133, 0, 300000, 2244.1, -1638.25, 15.907, 'Nera', 0, 5, 0, 1, 0, 0),
717(134, 0, 300000, 2256.96, -1644.21, 15.523, 'Nera', 0, 5, 0, 1, 0, 0),
718(135, 0, 300000, 2282.07, -1641.36, 15.89, 'Nera', 0, 5, 0, 1, 0, 0),
719(136, 0, 300000, 2307.21, -1678.85, 14.001, 'Nera', 0, 5, 0, 1, 0, 0),
720(137, 0, 500000, 2327.78, -1681.82, 14.931, 'Nera', 0, 5, 0, 1, 0, 0),
721(138, 0, 300000, 2362.84, -1644, 13.533, 'Nera', 0, 5, 0, 1, 0, 0),
722(139, 0, 300000, 2393.25, -1646.21, 13.905, 'Nera', 0, 5, 0, 1, 0, 0),
723(140, 0, 300000, 2413.71, -1647.1, 14.012, 'Nera', 0, 5, 0, 1, 0, 0),
724(141, 0, 400000, 2451.72, -1641.52, 14.066, 'Nera', 0, 5, 0, 1, 0, 0),
725(142, 0, 700000, 2459.65, -1691.34, 13.543, 'Nera', 0, 5, 0, 1, 0, 0),
726(143, 0, 800000, 2469.54, -1646.35, 13.78, 'Nera', 0, 5, 0, 1, 0, 0),
727(144, 0, 800000, 2486.45, -1644.59, 14.077, 'Nera', 0, 5, 0, 1, 0, 0),
728(145, 0, 800000, 2498.5, -1642.27, 14.113, 'Nera', 0, 5, 0, 1, 0, 0),
729(146, 0, 800000, 2513.27, -1650.61, 14.356, 'Nera', 0, 5, 0, 1, 0, 0),
730(147, 0, 800000, 2524.34, -1658.42, 15.494, 'Nera', 0, 5, 0, 1, 0, 0),
731(148, 0, 800000, 2523.27, -1679.23, 15.497, 'Nera', 0, 5, 0, 1, 0, 0),
732(149, 0, 600000, 2514.47, -1691.44, 14.046, 'Nera', 0, 5, 0, 1, 0, 0),
733(150, 0, 1000000, 2495.39, -1690.78, 14.766, 'Nera', 0, 9, 0, 1, 0, 0),
734(151, 0, 600000, 2385.47, -1712.14, 14.242, 'Nera', 0, 5, 0, 1, 0, 0),
735(152, 0, 500000, 2402.44, -1715.43, 14.133, 'Nera', 0, 6, 0, 1, 0, 0),
736(153, 0, 500000, 2326.77, -1716.7, 14.238, 'Nera', 0, 6, 0, 1, 0, 0),
737(154, 0, 500000, 2309, -1714.34, 14.98, 'Nera', 0, 6, 0, 1, 0, 0),
738(155, 0, 130000, 2155.47, -1699.17, 15.086, 'Nera', 0, 2, 0, 1, 0, 0),
739(156, 0, 130000, 2139.03, -1697.6, 15.086, 'Nera', 0, 2, 0, 1, 0, 0),
740(157, 0, 130000, 2140.54, -1707.56, 15.086, 'Nera', 0, 2, 0, 1, 0, 0),
741(158, 0, 130000, 2156.94, -1708.35, 15.086, 'Nera', 0, 2, 0, 1, 0, 0),
742(159, 0, 130000, 2165.96, -1671.19, 15.073, 'Nera', 0, 2, 0, 1, 0, 0),
743(160, 0, 130000, 2178.58, -1660.46, 14.963, 'Nera', 0, 2, 0, 1, 0, 0),
744(161, 0, 190000, 2172.16, -1614.97, 14.302, 'Nera', 0, 3, 0, 1, 0, 0),
745(162, 0, 190000, 2179.02, -1600.25, 14.346, 'Nera', 0, 3, 0, 1, 0, 0),
746(163, 0, 190000, 2165.8, -1590.65, 14.347, 'Nera', 0, 3, 0, 1, 0, 0),
747(164, 0, 190000, 2150.46, -1583.98, 14.336, 'Nera', 0, 3, 0, 1, 0, 0),
748(165, 0, 190000, 2136.11, -1592.03, 14.352, 'Nera', 0, 3, 0, 1, 0, 0),
749(166, 0, 190000, 2151.45, -1598.56, 14.346, 'Nera', 0, 3, 0, 1, 0, 0),
750(167, 0, 190000, 2142.71, -1605.12, 14.352, 'Nera', 0, 3, 0, 1, 0, 0),
751(168, 0, 190000, 2158.29, -1611.63, 14.352, 'Nera', 0, 3, 0, 1, 0, 0),
752(169, 0, 190000, 2141.32, -1652.62, 15.086, 'Nera', 0, 3, 0, 1, 0, 0),
753(170, 0, 190000, 2128.8, -1663.27, 15.086, 'Nera', 0, 3, 0, 1, 0, 0),
754(171, 0, 190000, 2143.89, -1662.93, 15.086, 'Nera', 0, 3, 0, 1, 0, 0),
755(172, 0, 190000, 2156.42, -1651.79, 15.078, 'Nera', 0, 3, 0, 1, 0, 0),
756(173, 0, 190000, 2163.5, -1661.22, 15.086, 'Nera', 0, 3, 0, 1, 0, 0),
757(174, 0, 190000, 2151.56, -1671.78, 15.086, 'Nera', 0, 3, 0, 1, 0, 0),
758(175, 0, 190000, 2144.42, -1688.77, 15.086, 'Nera', 0, 3, 0, 1, 0, 0),
759(176, 0, 190000, 2127.96, -1687.8, 15.086, 'Nera', 0, 3, 0, 1, 0, 0),
760(177, 0, 190000, 743.153, -509.68, 18.013, 'Nera', 0, 3, 0, 1, 0, 0),
761(178, 0, 390000, 768.306, -503.67, 18.013, 'Nera', 0, 5, 0, 1, 0, 0),
762(180, 0, 1000000, 795.054, -506.491, 18.013, 'Nera', 0, 8, 0, 1, 0, 0),
763(181, 0, 390000, 818.252, -509.325, 18.013, 'Nera', 0, 5, 0, 1, 0, 0),
764(182, 0, 490000, 766.464, -556.562, 18.013, 'Nera', 0, 5, 0, 1, 0, 0),
765(183, 0, 490000, 745.074, -556.697, 18.013, 'Nera', 0, 5, 0, 1, 0, 0),
766(184, 0, 1000000, 2236.38, 167.857, 28.154, 'Nera', 0, 8, 0, 1, 0, 0),
767(185, 0, 490000, 2257.92, 168.141, 28.154, 'Nera', 0, 5, 0, 1, 0, 0),
768(186, 0, 490000, 2285.82, 161.561, 28.442, 'Nera', 0, 5, 0, 1, 0, 0),
769(187, 0, 490000, 2269.46, 111.76, 28.442, 'Nera', 0, 5, 0, 1, 0, 0),
770(188, 0, 490000, 2249.37, 111.758, 28.442, 'Nera', 0, 5, 0, 1, 0, 0),
771(189, 0, 590000, 2204.05, 106.19, 28.442, 'Nera', 0, 6, 0, 1, 0, 0),
772(190, 0, 590000, 2203.85, 62.193, 28.442, 'Nera', 0, 6, 0, 1, 0, 0),
773(191, 0, 590000, 2245.49, -1.745, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
774(192, 0, 590000, 2270.31, -7.499, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
775(193, 0, 590000, 2199.95, -37.25, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
776(194, 0, 590000, 2197.27, -60.748, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
777(195, 0, 590000, 2203.11, -89.271, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
778(196, 0, 590000, 2245.52, -122.212, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
779(197, 0, 590000, 2272.32, -119.13, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
780(198, 0, 590000, 2293.71, -124.964, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
781(199, 0, 590000, 2322.26, -124.719, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
782(200, 0, 590000, 2367.51, -49.127, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
783(201, 0, 590000, 2392.3, -54.96, 28.154, 'Nera', 0, 6, 0, 1, 0, 0),
784(202, 0, 290000, 2415.42, -52.283, 28.154, 'Nera', 0, 4, 0, 1, 0, 0),
785(203, 0, 290000, 2438.87, -54.954, 28.154, 'Nera', 0, 4, 0, 1, 0, 0),
786(204, 0, 1000000, 2448.36, -11.029, 27.683, 'Nera', 0, 8, 0, 1, 0, 0),
787(205, 0, 290000, 2484.41, -27.93, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
788(206, 0, 290000, 2513.39, -28.402, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
789(207, 0, 290000, 2488.37, 11.519, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
790(208, 0, 150000, 2509.45, 11.753, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
791(209, 0, 150000, 2550.92, -5.338, 27.676, 'Nera', 0, 4, 0, 1, 0, 0),
792(210, 0, 150000, 2549.23, 25.107, 27.676, 'Nera', 0, 4, 0, 1, 0, 0),
793(211, 0, 1000000, 2551.21, 57.2, 27.676, 'Nera', 0, 8, 0, 1, 0, 0),
794(212, 0, 150000, 2556.89, 87.988, 27.676, 'Nera', 0, 4, 0, 1, 0, 0),
795(213, 0, 150000, 2536.07, 128.988, 27.683, 'Nera', 0, 4, 0, 1, 0, 0),
796(214, 0, 1000000, 2518.53, 128.984, 27.676, 'Nera', 0, 8, 0, 1, 0, 0),
797(215, 0, 150000, 2480.85, 126.976, 27.676, 'Nera', 0, 4, 0, 1, 0, 0),
798(216, 0, 150000, 2462.79, 134.773, 27.676, 'Nera', 0, 4, 0, 1, 0, 0),
799(217, 0, 150000, 2443.86, 92.334, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
800(218, 0, 150000, 2481.22, 64.319, 27.683, 'Nera', 0, 4, 0, 1, 0, 0),
801(219, 0, 150000, 2443.24, 61.763, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
802(220, 0, 1000000, 2413.54, 61.761, 28.442, 'Nera', 0, 8, 0, 1, 0, 0),
803(221, 0, 150000, 2373.85, 42.406, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
804(222, 0, 150000, 2373.85, 21.835, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
805(223, 0, 1000000, 2373.85, -8.558, 28.442, 'Nera', 0, 8, 0, 1, 0, 0),
806(224, 0, 150000, 2373.85, 71.172, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
807(225, 0, 150000, 2363.98, 116.113, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
808(226, 0, 150000, 2323.86, 116.037, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
809(227, 0, 1000000, 2323.85, 136.397, 28.442, 'Nera', 0, 8, 0, 1, 0, 0),
810(228, 0, 150000, 2323.85, 162.167, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
811(229, 0, 150000, 2324.2, 191.105, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
812(230, 0, 150000, 2364, 187.295, 28.442, 'Nera', 0, 4, 0, 1, 0, 0),
813(231, 0, 150000, 2364, 166.236, 28.442, 'Nera', 0, 4, 0, 1, 799, 0),
814(232, 0, 1000000, 2363.99, 142.075, 28.442, 'Nera', 0, 8, 0, 1, 0, 0),
815(233, 0, 1000000, -2027.79, -41.006, 38.805, 'Nera', 0, 8, 0, 1, 0, 0),
816(234, 0, 1000000, -2397.62, 155.145, 36.848, 'Nera', 0, 9, 0, 1, 0, 0),
817(235, 0, 1000000, -2397.13, 130.253, 36.848, 'Nera', 0, 9, 0, 1, 0, 0),
818(236, 0, 1000000, -2397.09, 105.896, 36.848, 'Nera', 0, 9, 0, 1, 0, 0),
819(237, 0, 1000000, -2397.1, 81.076, 36.848, 'Nera', 0, 9, 0, 1, 0, 0),
820(238, 0, 1000000, -2397.73, 23.851, 36.841, 'Nera', 0, 9, 0, 1, 0, 0),
821(239, 0, 1000000, -2395.15, -46.5, 37.005, 'Nera', 0, 9, 0, 1, 0, 0),
822(240, 0, 1000000, -2398.68, -96.809, 37.008, 'Nera', 0, 9, 0, 1, 0, 0),
823(241, 0, 1000000, -2397.54, -146.744, 37.035, 'Nera', 0, 9, 0, 1, 0, 0);
824
825-- --------------------------------------------------------
826
827--
828-- Sukurta duomenų struktūra lentelei `hpnustatymai`
829--
830
831CREATE TABLE IF NOT EXISTS `hpnustatymai` (
832 `SKIN274_RANGAS` int(11) NOT NULL DEFAULT '1',
833 `SKIN275_RANGAS` int(11) NOT NULL DEFAULT '1',
834 `SKIN70_RANGAS` int(11) NOT NULL DEFAULT '1',
835 `VEHICLE416_RANGAS` int(11) NOT NULL DEFAULT '1',
836 `VEHICLE490_RANGAS` int(11) NOT NULL DEFAULT '1',
837 `VEHICLE487_RANGAS` int(11) NOT NULL DEFAULT '1',
838 `VEHICLE452_RANGAS` int(11) NOT NULL DEFAULT '1',
839 `VEHICLE4562_RANGAS` int(11) NOT NULL DEFAULT '1',
840 `Vaistineles` int(11) NOT NULL
841) ENGINE=MyISAM DEFAULT CHARSET=latin1;
842
843--
844-- Sukurta duomenų kopija lentelei `hpnustatymai`
845--
846
847INSERT INTO `hpnustatymai` (`SKIN274_RANGAS`, `SKIN275_RANGAS`, `SKIN70_RANGAS`, `VEHICLE416_RANGAS`, `VEHICLE490_RANGAS`, `VEHICLE487_RANGAS`, `VEHICLE452_RANGAS`, `VEHICLE4562_RANGAS`, `Vaistineles`) VALUES
848(1, 1, 1, 1, 1, 1, 1, 1, 0);
849
850-- --------------------------------------------------------
851
852--
853-- Sukurta duomenų struktūra lentelei `ipbans`
854--
855
856CREATE TABLE IF NOT EXISTS `ipbans` (
857 `IP-Adress` varchar(24) NOT NULL,
858 `Reason` varchar(24) NOT NULL
859) ENGINE=MyISAM DEFAULT CHARSET=latin1;
860
861-- --------------------------------------------------------
862
863--
864-- Sukurta duomenų struktūra lentelei `israsas`
865--
866
867CREATE TABLE IF NOT EXISTS `israsas` (
868 `player` varchar(255) NOT NULL,
869 `to_player` varchar(255) NOT NULL,
870 `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
871 `suma` int(11) NOT NULL DEFAULT '0',
872`ID` int(11) NOT NULL,
873 `text` varchar(32) NOT NULL
874) ENGINE=InnoDB AUTO_INCREMENT=4263 DEFAULT CHARSET=latin1;
875
876-- --------------------------------------------------------
877
878--
879-- Sukurta duomenų struktūra lentelei `itarimai`
880--
881
882CREATE TABLE IF NOT EXISTS `itarimai` (
883`ID` int(11) NOT NULL,
884 `Vardas` varchar(24) NOT NULL,
885 `itaDate` varchar(64) NOT NULL,
886 `ItarimoTekstas` varchar(150) CHARACTER SET ucs2 COLLATE ucs2_lithuanian_ci NOT NULL,
887 `Stars` int(11) NOT NULL
888) ENGINE=MyISAM AUTO_INCREMENT=8255 DEFAULT CHARSET=latin1;
889
890-- --------------------------------------------------------
891
892--
893-- Sukurta duomenų struktūra lentelei `Klubai`
894--
895
896CREATE TABLE IF NOT EXISTS `Klubai` (
897`ID` int(11) NOT NULL,
898 `clubId` int(11) NOT NULL,
899 `clubName` varchar(32) CHARACTER SET utf16 COLLATE utf16_lithuanian_ci NOT NULL,
900 `clubOwner` varchar(24) NOT NULL,
901 `clubCoOwner` varchar(24) NOT NULL,
902 `posX` float NOT NULL,
903 `posY` float NOT NULL,
904 `posZ` float NOT NULL,
905 `uzimtiX` float NOT NULL,
906 `uzimtiY` float NOT NULL,
907 `uzimtiZ` float NOT NULL,
908 `clubLast` int(11) NOT NULL,
909 `clubPriceCredits` int(11) NOT NULL,
910 `clubPriceMoney` int(11) NOT NULL,
911 `clubCarColor` int(11) NOT NULL,
912 `clubMenSkin` int(11) NOT NULL,
913 `clubWomenSkin` int(11) NOT NULL,
914 `clubMoney` int(11) NOT NULL
915) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
916
917--
918-- Sukurta duomenų kopija lentelei `Klubai`
919--
920
921INSERT INTO `Klubai` (`ID`, `clubId`, `clubName`, `clubOwner`, `clubCoOwner`, `posX`, `posY`, `posZ`, `uzimtiX`, `uzimtiY`, `uzimtiZ`, `clubLast`, `clubPriceCredits`, `clubPriceMoney`, `clubCarColor`, `clubMenSkin`, `clubWomenSkin`, `clubMoney`) VALUES
922(1, 0, '1', '', '', -1785.46, 1312.84, 59.7344, -1810.25, 1300.83, 59.7344, 1567076294, 200, 2000000, 1, 175, 148, 0),
923(2, 1, '2', '', '', 1252.72, -2042.2, 60.0395, 1261.74, -2030.26, 59.3702, 1566768158, 200, 2000000, 1, 230, 1, 0);
924
925-- --------------------------------------------------------
926
927--
928-- Sukurta duomenų struktūra lentelei `KlubaiCars`
929--
930
931CREATE TABLE IF NOT EXISTS `KlubaiCars` (
932`ID` int(11) NOT NULL,
933 `clubId` int(11) NOT NULL,
934 `560car1` varchar(128) NOT NULL,
935 `560car2` varchar(128) NOT NULL,
936 `560car3` varchar(128) NOT NULL,
937 `560car4` varchar(128) NOT NULL,
938 `522car1` varchar(128) NOT NULL,
939 `522car2` varchar(128) NOT NULL,
940 `522car3` varchar(128) NOT NULL,
941 `522car4` varchar(128) NOT NULL,
942 `522car5` varchar(128) NOT NULL,
943 `522car6` varchar(128) NOT NULL,
944 `522car7` varchar(128) NOT NULL,
945 `522car8` varchar(128) NOT NULL,
946 `508car1` varchar(128) NOT NULL
947) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
948
949--
950-- Sukurta duomenų kopija lentelei `KlubaiCars`
951--
952
953INSERT INTO `KlubaiCars` (`ID`, `clubId`, `560car1`, `560car2`, `560car3`, `560car4`, `522car1`, `522car2`, `522car3`, `522car4`, `522car5`, `522car6`, `522car7`, `522car8`, `508car1`) VALUES
954(1, 0, '-1801.7939 1291.2468 59.2863 -90.4800', '-1809.6095 1291.0972 59.2863 -90.4800', '-1794.6399 1291.1948 59.2863 -90.4800', '-1817.5504 1290.8177 59.2863 -90.4800', '-1823.1917 1289.4819 59.1427 0.0000', '-1824.2969 1289.0879 59.1427 0.0000', '-1825.4930 1288.7356 59.1427 0.0000', '-1826.6688 1288.3035 59.1427 0.0000', '-1827.8783 1287.8076 59.1427 0.0000', '-1828.9961 1287.5205 59.1427 0.0000', '-1830.0460 1287.0657 59.1427 0.0000', '-1831.2168 1286.4425 59.1427 0.0000', '-1784.0557 1290.1429 59.8837 -94.3800'),
955(2, 1, '1246.1910 -2033.7428 59.3095 -90.4800', '1246.2969 -2030.1035 59.3095 -90.4800', '1246.3064 -2026.2224 59.3095 -90.4800', '1246.3641 -2022.0054 59.3095 -90.4800', '1278.5604 -2028.9236 58.4451 96.5400', '1278.5195 -2030.8524 58.4451 96.5400', '1278.6077 -2032.4872 58.4451 96.5400', '1278.5735 -2034.0726 58.4451 96.5400', '1278.6658 -2035.6300 58.4451 96.5400', '1278.5381 -2036.9609 58.4451 96.5400', '1278.5500 -2027.3536 58.4451 96.5400', '1278.5641 -2025.4912 58.4451 96.5400', '1276.6268 -2019.6886 59.1665 87.7800');
956
957-- --------------------------------------------------------
958
959--
960-- Sukurta duomenų struktūra lentelei `KlubaiPaliko`
961--
962
963CREATE TABLE IF NOT EXISTS `KlubaiPaliko` (
964`ID` int(11) NOT NULL,
965 `Name` varchar(24) NOT NULL,
966 `Date` varchar(24) NOT NULL,
967 `Reason` varchar(32) NOT NULL,
968 `clubId` int(11) NOT NULL
969) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
970
971-- --------------------------------------------------------
972
973--
974-- Sukurta duomenų struktūra lentelei `KlubaiUsers`
975--
976
977CREATE TABLE IF NOT EXISTS `KlubaiUsers` (
978`ID` int(11) NOT NULL,
979 `Name` varchar(24) NOT NULL,
980 `clubOwner` int(11) NOT NULL DEFAULT '-1',
981 `clubCoOwner` int(11) NOT NULL DEFAULT '-1',
982 `club` int(11) NOT NULL DEFAULT '-1',
983 `loginDate` varchar(32) NOT NULL,
984 `ClubXP` int(11) NOT NULL
985) ENGINE=InnoDB AUTO_INCREMENT=675 DEFAULT CHARSET=latin1;
986
987-- --------------------------------------------------------
988
989--
990-- Sukurta duomenų struktūra lentelei `laukimai`
991--
992
993CREATE TABLE IF NOT EXISTS `laukimai` (
994 `id` int(11) NOT NULL,
995 `LaukiamoZaidejoID` int(11) NOT NULL,
996 `Priezastis` varchar(24) NOT NULL,
997 `Data` int(11) NOT NULL,
998 `UniqueID` int(11) NOT NULL
999) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1000
1001-- --------------------------------------------------------
1002
1003--
1004-- Sukurta duomenų struktūra lentelei `lucchesenustatymai`
1005--
1006
1007CREATE TABLE IF NOT EXISTS `lucchesenustatymai` (
1008 `0` int(11) NOT NULL DEFAULT '1',
1009 `1` int(11) NOT NULL DEFAULT '1',
1010 `2` int(11) NOT NULL DEFAULT '1',
1011 `3` int(11) NOT NULL DEFAULT '1',
1012 `4` int(11) NOT NULL DEFAULT '1',
1013 `5` int(11) NOT NULL DEFAULT '1',
1014 `6` int(11) NOT NULL DEFAULT '1',
1015 `7` int(11) NOT NULL DEFAULT '1',
1016 `LuccheseAmmoShotgun` int(11) NOT NULL,
1017 `LuccheseAmmoDeagle` int(11) NOT NULL,
1018 `LuccheseAmmoAK47` int(11) NOT NULL,
1019 `LuccheseAmmoSniper` int(11) NOT NULL
1020) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1021
1022--
1023-- Sukurta duomenų kopija lentelei `lucchesenustatymai`
1024--
1025
1026INSERT INTO `lucchesenustatymai` (`0`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `LuccheseAmmoShotgun`, `LuccheseAmmoDeagle`, `LuccheseAmmoAK47`, `LuccheseAmmoSniper`) VALUES
1027(1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0);
1028
1029-- --------------------------------------------------------
1030
1031--
1032-- Sukurta duomenų struktūra lentelei `mafiju_blist`
1033--
1034
1035CREATE TABLE IF NOT EXISTS `mafiju_blist` (
1036`id` int(11) NOT NULL,
1037 `name` varchar(24) NOT NULL,
1038 `reason` varchar(128) CHARACTER SET utf16 COLLATE utf16_lithuanian_ci NOT NULL,
1039 `time` int(11) NOT NULL,
1040 `admin` varchar(24) NOT NULL,
1041 `date` varchar(24) NOT NULL,
1042 `date_end` varchar(24) NOT NULL
1043) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
1044
1045-- --------------------------------------------------------
1046
1047--
1048-- Sukurta duomenų struktūra lentelei `masinuturguskiekiai`
1049--
1050
1051CREATE TABLE IF NOT EXISTS `masinuturguskiekiai` (
1052 `ModelID` int(11) NOT NULL,
1053 `Kiekis` int(11) NOT NULL
1054) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1055
1056--
1057-- Sukurta duomenų kopija lentelei `masinuturguskiekiai`
1058--
1059
1060INSERT INTO `masinuturguskiekiai` (`ModelID`, `Kiekis`) VALUES
1061(587, 50),
1062(602, 50),
1063(439, 50),
1064(477, 50),
1065(562, 50),
1066(559, 50),
1067(560, 50),
1068(405, 50),
1069(402, 50),
1070(589, 50),
1071(480, 50),
1072(506, 50),
1073(462, 50),
1074(471, 50),
1075(586, 50),
1076(463, 50),
1077(522, 50),
1078(521, 50),
1079(468, 50),
1080(565, 50),
1081(561, 50),
1082(558, 50),
1083(550, 50),
1084(551, 50),
1085(500, 50),
1086(400, 50),
1087(508, 50),
1088(567, 50),
1089(533, 50),
1090(534, 50),
1091(491, 50),
1092(419, 50),
1093(489, 50),
1094(479, 50),
1095(535, 50),
1096(507, 50),
1097(496, 50),
1098(418, 50),
1099(517, 50),
1100(483, 50),
1101(445, 50),
1102(555, 50),
1103(412, 50),
1104(458, 50),
1105(426, 50),
1106(526, 50),
1107(527, 50),
1108(554, 50),
1109(516, 50),
1110(411, 50),
1111(451, 50),
1112(421, 50),
1113(415, 50),
1114(603, 50),
1115(541, 50),
1116(429, 50),
1117(579, 50),
1118(434, 50),
1119(495, 50),
1120(481, 50),
1121(510, 50),
1122(509, 50),
1123(494, 50),
1124(566, 50);
1125
1126-- --------------------------------------------------------
1127
1128--
1129-- Sukurta duomenų struktūra lentelei `mechanikainustatymai`
1130--
1131
1132CREATE TABLE IF NOT EXISTS `mechanikainustatymai` (
1133 `50SKIN_RANGAS` int(11) NOT NULL,
1134 `8SKIN_RANGAS` int(11) NOT NULL,
1135 `42SKIN_RANGAS` int(11) NOT NULL,
1136 `Vehicle525_RANGAS` int(11) NOT NULL,
1137 `Vehicle602_RANGAS` int(11) NOT NULL
1138) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1139
1140--
1141-- Sukurta duomenų kopija lentelei `mechanikainustatymai`
1142--
1143
1144INSERT INTO `mechanikainustatymai` (`50SKIN_RANGAS`, `8SKIN_RANGAS`, `42SKIN_RANGAS`, `Vehicle525_RANGAS`, `Vehicle602_RANGAS`) VALUES
1145(1, 1, 1, 1, 1);
1146
1147-- --------------------------------------------------------
1148
1149--
1150-- Sukurta duomenų struktūra lentelei `npnustatymai`
1151--
1152
1153CREATE TABLE IF NOT EXISTS `npnustatymai` (
1154 `1` int(11) NOT NULL DEFAULT '1',
1155 `2` int(11) NOT NULL DEFAULT '1',
1156 `3` int(11) NOT NULL DEFAULT '1',
1157 `4` int(11) NOT NULL DEFAULT '1',
1158 `5` int(11) NOT NULL DEFAULT '1',
1159 `6` int(11) NOT NULL DEFAULT '1',
1160 `Heroinas` int(11) NOT NULL,
1161 `Kokainas` int(11) NOT NULL,
1162 `Kanapes` int(11) NOT NULL,
1163 `soldWeed` int(11) NOT NULL,
1164 `soldHero` int(11) NOT NULL,
1165 `soldCoke` int(11) NOT NULL
1166) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1167
1168--
1169-- Sukurta duomenų kopija lentelei `npnustatymai`
1170--
1171
1172INSERT INTO `npnustatymai` (`1`, `2`, `3`, `4`, `5`, `6`, `Heroinas`, `Kokainas`, `Kanapes`, `soldWeed`, `soldHero`, `soldCoke`) VALUES
1173(1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0);
1174
1175-- --------------------------------------------------------
1176
1177--
1178-- Sukurta duomenų struktūra lentelei `nuosavostrpriemones`
1179--
1180
1181CREATE TABLE IF NOT EXISTS `nuosavostrpriemones` (
1182`ID` int(11) NOT NULL,
1183 `Savininkas` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1184 `Modelis` int(4) NOT NULL,
1185 `Rida` float NOT NULL DEFAULT '0',
1186 `Numeriai` varchar(9) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'None',
1187 `RegistruotiNumeriai` int(1) NOT NULL DEFAULT '0',
1188 `X` float NOT NULL DEFAULT '0',
1189 `Y` float NOT NULL DEFAULT '0',
1190 `Z` float NOT NULL DEFAULT '0',
1191 `Rotation` float NOT NULL DEFAULT '0',
1192 `Color1` int(11) NOT NULL DEFAULT '-1',
1193 `Color2` int(11) NOT NULL DEFAULT '-1',
1194 `FuelType` int(11) NOT NULL DEFAULT '0',
1195 `Bendzinas` float NOT NULL DEFAULT '0',
1196 `Dujos` float NOT NULL DEFAULT '0',
1197 `Sudauzyta` tinyint(1) NOT NULL DEFAULT '0',
1198 `SuSignalizacija` int(11) NOT NULL DEFAULT '0',
1199 `Dauztumas` int(11) NOT NULL DEFAULT '0',
1200 `DujuIranga` int(11) NOT NULL DEFAULT '0',
1201 `WeaponSlot1WeaponModel` int(11) NOT NULL,
1202 `WeaponSlot1WeaponBullets` int(11) NOT NULL,
1203 `WeaponSlot2WeaponModel` int(11) NOT NULL,
1204 `WeaponSlot2WeaponBullets` int(11) NOT NULL,
1205 `WeaponSlot3WeaponModel` int(11) NOT NULL,
1206 `WeaponSlot3WeaponBullets` int(11) NOT NULL,
1207 `WeaponSlot4WeaponModel` int(11) NOT NULL,
1208 `WeaponSlot4WeaponBullets` int(11) NOT NULL,
1209 `WeaponSlot5WeaponModel` int(11) NOT NULL,
1210 `WeaponSlot5WeaponBullets` int(11) NOT NULL,
1211 `WeaponSlot6WeaponModel` int(11) NOT NULL,
1212 `WeaponSlot6WeaponBullets` int(11) NOT NULL,
1213 `DrugsSlot1` int(11) NOT NULL,
1214 `DrugsSlot2` int(11) NOT NULL,
1215 `DrugsSlot3` int(11) NOT NULL,
1216 `Tune0` int(10) NOT NULL,
1217 `Tune1` int(11) NOT NULL,
1218 `Tune2` int(11) NOT NULL,
1219 `Tune3` int(11) NOT NULL,
1220 `Tune4` int(11) NOT NULL,
1221 `Tune5` int(11) NOT NULL,
1222 `Tune6` int(11) NOT NULL,
1223 `Tune7` int(11) NOT NULL,
1224 `Tune8` int(11) NOT NULL,
1225 `Tune9` int(11) NOT NULL,
1226 `Tune10` int(11) NOT NULL,
1227 `Tune11` int(11) NOT NULL,
1228 `Tune12` int(11) NOT NULL,
1229 `Tune13` int(11) NOT NULL,
1230 `Paintjob` int(11) NOT NULL DEFAULT '-1',
1231 `VehicleLocked` int(11) NOT NULL DEFAULT '-1',
1232 `Pardavinejama` int(11) NOT NULL,
1233 `PardavimoKaina` int(11) NOT NULL,
1234 `PardavimoZinutesTekstas` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL
1235) ENGINE=InnoDB AUTO_INCREMENT=951 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
1236
1237-- --------------------------------------------------------
1238
1239--
1240-- Sukurta duomenų struktūra lentelei `palikodarba`
1241--
1242
1243CREATE TABLE IF NOT EXISTS `palikodarba` (
1244`id` int(11) NOT NULL,
1245 `DarboID` int(11) NOT NULL,
1246 `PlayerName` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1247 `IsidarbinimoData` date NOT NULL,
1248 `PalikimoData` date NOT NULL,
1249 `Reason` varchar(90) COLLATE utf8_lithuanian_ci NOT NULL
1250) ENGINE=InnoDB AUTO_INCREMENT=1103 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
1251
1252-- --------------------------------------------------------
1253
1254--
1255-- Sukurta duomenų struktūra lentelei `pasiekimai`
1256--
1257
1258CREATE TABLE IF NOT EXISTS `pasiekimai` (
1259 `Name` varchar(24) NOT NULL,
1260 `1` int(11) NOT NULL DEFAULT '0',
1261 `2` int(11) NOT NULL DEFAULT '0',
1262 `3` int(11) NOT NULL DEFAULT '0',
1263 `4` int(11) NOT NULL DEFAULT '0',
1264 `5` int(11) NOT NULL DEFAULT '0',
1265 `6` int(11) NOT NULL DEFAULT '0',
1266 `7` int(11) NOT NULL DEFAULT '0',
1267 `8` int(11) NOT NULL DEFAULT '0',
1268 `9` int(11) NOT NULL DEFAULT '0',
1269 `10` int(11) NOT NULL DEFAULT '0',
1270 `11` int(11) NOT NULL DEFAULT '0',
1271 `12` int(11) NOT NULL DEFAULT '0',
1272 `13` int(11) NOT NULL DEFAULT '0',
1273 `14` int(11) NOT NULL DEFAULT '0',
1274 `15` int(11) NOT NULL DEFAULT '0',
1275 `16` int(11) NOT NULL DEFAULT '0',
1276 `17` int(11) NOT NULL DEFAULT '0',
1277 `18` int(11) NOT NULL DEFAULT '0',
1278 `19` int(11) NOT NULL DEFAULT '0',
1279 `20` int(11) NOT NULL DEFAULT '0',
1280 `21` int(11) NOT NULL DEFAULT '0',
1281 `22` int(11) NOT NULL DEFAULT '0',
1282 `24` int(11) NOT NULL DEFAULT '0',
1283 `25` int(11) NOT NULL DEFAULT '0',
1284 `26` int(11) NOT NULL DEFAULT '0',
1285 `27` int(11) NOT NULL DEFAULT '0',
1286 `28` int(11) NOT NULL DEFAULT '0',
1287 `29` int(11) NOT NULL DEFAULT '0',
1288 `30` int(11) NOT NULL DEFAULT '0',
1289 `31` int(11) NOT NULL DEFAULT '0',
1290 `32` int(11) NOT NULL DEFAULT '0',
1291 `33` int(11) NOT NULL DEFAULT '0',
1292 `34` int(11) NOT NULL DEFAULT '0',
1293 `35` int(11) NOT NULL DEFAULT '0',
1294 `36` int(11) NOT NULL DEFAULT '0',
1295 `37` int(11) NOT NULL DEFAULT '0',
1296 `38` int(11) NOT NULL DEFAULT '0',
1297 `39` int(11) NOT NULL DEFAULT '0',
1298 `40` int(11) NOT NULL DEFAULT '0',
1299 `41` int(11) NOT NULL DEFAULT '0',
1300 `42` int(11) NOT NULL DEFAULT '0'
1301) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1302
1303-- --------------------------------------------------------
1304
1305--
1306-- Sukurta duomenų struktūra lentelei `pavaduotojunustatymai`
1307--
1308
1309CREATE TABLE IF NOT EXISTS `pavaduotojunustatymai` (
1310 `JobID` int(11) NOT NULL,
1311 `RightToInvite` int(11) NOT NULL,
1312 `RightToKickFromJob` int(11) NOT NULL,
1313 `RightToWrite` int(11) NOT NULL,
1314 `RightToWarn` int(11) NOT NULL,
1315 `RightToGiveBonuses` int(11) NOT NULL,
1316 `RightToLockGarage` int(11) NOT NULL,
1317 `RightToAdministrateFund` int(11) NOT NULL,
1318 `RightToSetARank` int(11) NOT NULL,
1319 `RightToAdministrateRanks` int(11) NOT NULL
1320) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1321
1322--
1323-- Sukurta duomenų kopija lentelei `pavaduotojunustatymai`
1324--
1325
1326INSERT INTO `pavaduotojunustatymai` (`JobID`, `RightToInvite`, `RightToKickFromJob`, `RightToWrite`, `RightToWarn`, `RightToGiveBonuses`, `RightToLockGarage`, `RightToAdministrateFund`, `RightToSetARank`, `RightToAdministrateRanks`) VALUES
1327(1, 1, 1, 1, 1, 1, 1, 0, 1, 1),
1328(2, 1, 1, 1, 1, 1, 1, 1, 1, 1),
1329(3, 1, 1, 1, 1, 1, 1, 1, 1, 1),
1330(4, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1331(5, 1, 0, 1, 1, 1, 0, 0, 1, 0),
1332(6, 1, 1, 1, 1, 1, 1, 1, 1, 1),
1333(7, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1334(8, 1, 1, 1, 1, 1, 1, 1, 1, 1),
1335(9, 1, 1, 1, 1, 0, 1, 0, 1, 1),
1336(10, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1337(11, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1338(21, 1, 1, 1, 1, 0, 1, 0, 0, 1),
1339(22, 1, 1, 1, 1, 1, 1, 1, 1, 0),
1340(23, 1, 1, 1, 1, 0, 1, 0, 1, 1),
1341(25, 1, 1, 1, 0, 1, 1, 0, 0, 0),
1342(26, 1, 1, 1, 1, 1, 1, 0, 1, 1);
1343
1344-- --------------------------------------------------------
1345
1346--
1347-- Sukurta duomenų struktūra lentelei `pbussinesses`
1348--
1349
1350CREATE TABLE IF NOT EXISTS `pbussinesses` (
1351 `owner` varchar(25) NOT NULL,
1352 `price` int(10) NOT NULL,
1353 `earning` smallint(5) NOT NULL,
1354 `maxEarning` smallint(5) NOT NULL,
1355 `offer` smallint(3) NOT NULL,
1356 `employees` int(10) NOT NULL,
1357 `investments` smallint(3) NOT NULL,
1358 `lastEdit` int(11) NOT NULL
1359) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1360
1361-- --------------------------------------------------------
1362
1363--
1364-- Sukurta duomenų struktūra lentelei `pdnustatymai`
1365--
1366
1367CREATE TABLE IF NOT EXISTS `pdnustatymai` (
1368 `280SKIN_RANGAS` int(11) NOT NULL DEFAULT '1',
1369 `281SKIN_RANGAS` int(11) NOT NULL DEFAULT '1',
1370 `282SKIN_RANGAS` int(11) NOT NULL DEFAULT '1',
1371 `283SKIN_RANGAS` int(11) NOT NULL DEFAULT '1',
1372 `288SKIN_RANGAS` int(11) NOT NULL DEFAULT '1',
1373 `284SKIN_RANGAS` int(11) NOT NULL DEFAULT '1',
1374 `Vehicle497` int(11) NOT NULL DEFAULT '1',
1375 `Vehicle597` int(11) NOT NULL DEFAULT '1',
1376 `Vehicle523` int(11) NOT NULL DEFAULT '1',
1377 `Vehicle599` int(11) NOT NULL DEFAULT '1',
1378 `Vehicle430` int(11) NOT NULL DEFAULT '1'
1379) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
1380
1381--
1382-- Sukurta duomenų kopija lentelei `pdnustatymai`
1383--
1384
1385INSERT INTO `pdnustatymai` (`280SKIN_RANGAS`, `281SKIN_RANGAS`, `282SKIN_RANGAS`, `283SKIN_RANGAS`, `288SKIN_RANGAS`, `284SKIN_RANGAS`, `Vehicle497`, `Vehicle597`, `Vehicle523`, `Vehicle599`, `Vehicle430`) VALUES
1386(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
1387
1388-- --------------------------------------------------------
1389
1390--
1391-- Sukurta duomenų struktūra lentelei `players`
1392--
1393
1394CREATE TABLE IF NOT EXISTS `players` (
1395`id` int(11) NOT NULL,
1396 `Name` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1397 `Password` varchar(65) COLLATE utf8_lithuanian_ci NOT NULL,
1398 `Salt` varchar(11) COLLATE utf8_lithuanian_ci NOT NULL,
1399 `RegIP` varchar(17) COLLATE utf8_lithuanian_ci NOT NULL,
1400 `LastIP` varchar(17) COLLATE utf8_lithuanian_ci NOT NULL,
1401 `Email` varchar(40) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'UNSET',
1402 `SecretQuestion` varchar(64) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'UNSET',
1403 `SecretQuestionA` varchar(64) COLLATE utf8_lithuanian_ci DEFAULT 'UNSET',
1404 `Sex` int(2) NOT NULL,
1405 `Skin` int(5) NOT NULL,
1406 `PRIZAS` int(5) NOT NULL,
1407 `Newbie` int(2) NOT NULL DEFAULT '1',
1408 `Pos_X` float NOT NULL DEFAULT '-1958.95',
1409 `Pos_Y` float NOT NULL DEFAULT '137.536',
1410 `Pos_Z` float NOT NULL DEFAULT '27.694',
1411 `FacingAngle` float NOT NULL DEFAULT '178.747',
1412 `Weapon0` int(3) NOT NULL DEFAULT '0',
1413 `Ammo0` int(11) NOT NULL DEFAULT '0',
1414 `Weapon1` int(3) NOT NULL DEFAULT '0',
1415 `Ammo1` int(11) NOT NULL DEFAULT '0',
1416 `Weapon2` int(3) NOT NULL DEFAULT '0',
1417 `Ammo2` int(11) NOT NULL DEFAULT '0',
1418 `Weapon3` int(3) NOT NULL DEFAULT '0',
1419 `Ammo3` int(11) NOT NULL DEFAULT '0',
1420 `Weapon4` int(3) NOT NULL DEFAULT '0',
1421 `Ammo4` int(11) NOT NULL DEFAULT '0',
1422 `Weapon5` int(3) NOT NULL DEFAULT '0',
1423 `Ammo5` int(11) NOT NULL DEFAULT '0',
1424 `Weapon6` int(3) NOT NULL DEFAULT '0',
1425 `Ammo6` int(11) NOT NULL DEFAULT '0',
1426 `Weapon7` int(3) NOT NULL DEFAULT '0',
1427 `Ammo7` int(11) NOT NULL DEFAULT '0',
1428 `Weapon8` int(3) NOT NULL DEFAULT '0',
1429 `Ammo8` int(11) NOT NULL DEFAULT '0',
1430 `Weapon9` int(3) NOT NULL DEFAULT '0',
1431 `Ammo9` int(11) NOT NULL DEFAULT '0',
1432 `Weapon10` int(3) NOT NULL DEFAULT '0',
1433 `Ammo10` int(11) NOT NULL DEFAULT '0',
1434 `Weapon11` int(3) NOT NULL DEFAULT '0',
1435 `Ammo11` int(11) NOT NULL DEFAULT '0',
1436 `XP` int(11) NOT NULL DEFAULT '2000',
1437 `MoneyInPocket` int(11) NOT NULL DEFAULT '10000',
1438 `MoneyInBank` int(11) NOT NULL DEFAULT '0',
1439 `Credits` int(11) NOT NULL DEFAULT '0',
1440 `Credits2` int(11) NOT NULL DEFAULT '0',
1441 `JailTime` int(11) NOT NULL DEFAULT '0',
1442 `WantedLevel` int(11) NOT NULL DEFAULT '0',
1443 `Health` float NOT NULL DEFAULT '100',
1444 `Armour` float NOT NULL DEFAULT '0',
1445 `Job` int(3) NOT NULL DEFAULT '0',
1446 `Club` int(3) NOT NULL DEFAULT '0',
1447 `DrivingTheory` int(3) NOT NULL DEFAULT '0',
1448 `AutoLicense` int(2) NOT NULL DEFAULT '0',
1449 `AutoParkDriving` int(3) NOT NULL DEFAULT '0',
1450 `MotoLicense` int(2) NOT NULL DEFAULT '0',
1451 `MotoParkDriving` int(11) NOT NULL DEFAULT '0',
1452 `SunkvLicense` int(2) NOT NULL DEFAULT '0',
1453 `SunkvParkDriving` int(11) NOT NULL DEFAULT '0',
1454 `PilotoLicense` int(2) NOT NULL DEFAULT '0',
1455 `LostDLicenses` int(11) NOT NULL DEFAULT '0',
1456 `WeaponsLicense` int(2) NOT NULL DEFAULT '0',
1457 `PhoneBalance` int(11) NOT NULL DEFAULT '0',
1458 `PhoneState` int(11) NOT NULL DEFAULT '0',
1459 `VirtualWorld` int(3) NOT NULL DEFAULT '0',
1460 `Interior` int(3) NOT NULL DEFAULT '0',
1461 `adminlvl` int(11) NOT NULL DEFAULT '0',
1462 `AdminLaikoPabaiga` int(11) NOT NULL DEFAULT '0',
1463 `Uzdarbis` int(11) NOT NULL DEFAULT '0',
1464 `VIP` int(11) NOT NULL DEFAULT '0',
1465 `VIPLaikoPabaiga` int(11) NOT NULL DEFAULT '0',
1466 `Direktorius` int(11) NOT NULL DEFAULT '0',
1467 `Pavaduotojas` int(11) NOT NULL DEFAULT '0',
1468 `DarboSutartiesPabaiga` int(11) NOT NULL DEFAULT '0',
1469 `DarboPradziosData` date NOT NULL,
1470 `UniformosID` int(11) NOT NULL DEFAULT '0',
1471 `AprangosTipas` int(11) NOT NULL DEFAULT '0',
1472 `Drabuziai` int(11) NOT NULL DEFAULT '0',
1473 `Rangas` int(11) NOT NULL DEFAULT '1',
1474 `Vaistineles` int(11) NOT NULL DEFAULT '0',
1475 `LigoninesLaikas` int(4) NOT NULL DEFAULT '0',
1476 `Sotumas` double NOT NULL DEFAULT '100',
1477 `BendraEnergija` double NOT NULL DEFAULT '100',
1478 `JobWarnings` int(11) NOT NULL DEFAULT '0',
1479 `AdminWarnings` int(11) NOT NULL DEFAULT '0',
1480 `VIPWarnings` int(11) NOT NULL DEFAULT '0',
1481 `LawWarnings` int(11) NOT NULL DEFAULT '0',
1482 `Kanapes` int(11) NOT NULL DEFAULT '0',
1483 `Kokainas` int(11) NOT NULL DEFAULT '0',
1484 `Heroinas` int(11) NOT NULL DEFAULT '0',
1485 `DayOfRegistration` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1486 `PagydimaiTotal` int(11) NOT NULL DEFAULT '0',
1487 `Emigruotas` int(11) NOT NULL DEFAULT '0',
1488 `AtvykimaiTotal` int(11) NOT NULL DEFAULT '0',
1489 `Atvezimai` int(11) NOT NULL DEFAULT '0',
1490 `BaudosTotal` int(11) NOT NULL DEFAULT '0',
1491 `ClothesBeforeJail` int(11) NOT NULL DEFAULT '0',
1492 `EmigracijuPriziuretojas` int(11) NOT NULL DEFAULT '0',
1493 `MutedPlayer` int(11) NOT NULL DEFAULT '0',
1494 `HeroinoPriklausomybesLygis` int(11) NOT NULL DEFAULT '0',
1495 `KokainoPriklausomybesLygis` int(11) NOT NULL DEFAULT '0',
1496 `AprangaBeforeJail` int(11) NOT NULL DEFAULT '0',
1497 `LaikoMasinosTeisesKartu` int(11) NOT NULL DEFAULT '0',
1498 `Salmas` int(11) NOT NULL DEFAULT '0',
1499 `UzdarbisSiandien` int(11) NOT NULL DEFAULT '0',
1500 `KicksForRapidShots` int(11) NOT NULL DEFAULT '0',
1501 `AlgosBonusas` int(11) NOT NULL DEFAULT '0',
1502 `PlayerWhoGaveMute` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1503 `NuveztiKroviniai` int(11) NOT NULL DEFAULT '0',
1504 `LyderiuPriziuretojas` int(11) NOT NULL DEFAULT '0',
1505 `SiandienZaista` int(11) NOT NULL DEFAULT '0',
1506 `ZaistaTotal` int(11) NOT NULL DEFAULT '0',
1507 `ZaistaSavaite` int(11) NOT NULL DEFAULT '0',
1508 `PrivPriziuretojas` int(11) NOT NULL DEFAULT '0',
1509 `MatuokliuBalai` int(11) NOT NULL DEFAULT '0',
1510 `TuriBankoSaskaita` int(11) NOT NULL DEFAULT '0',
1511 `BankoSaskaitosPin` int(11) NOT NULL DEFAULT '0',
1512 `UnBanPriziuretojas` int(11) NOT NULL DEFAULT '0',
1513 `DirektoriuPriziuretojas` int(11) NOT NULL DEFAULT '0',
1514 `Igaliotinis` int(11) NOT NULL DEFAULT '0',
1515 `Kvalifikatorius` int(11) NOT NULL DEFAULT '0',
1516 `PrisijungimoData` varchar(18) COLLATE utf8_lithuanian_ci NOT NULL,
1517 `MISIJA` int(5) NOT NULL DEFAULT '10',
1518 `pravaziavoviso` float NOT NULL DEFAULT '0',
1519 `PravaziavoSiandien` float NOT NULL DEFAULT '0',
1520 `aViela` int(1) NOT NULL,
1521 `Kuponas` int(11) NOT NULL DEFAULT '0',
1522 `VisoPagydymu` int(11) NOT NULL DEFAULT '0',
1523 `VisoBaudu` int(11) NOT NULL DEFAULT '0',
1524 `VisoAtvykimu` int(11) NOT NULL DEFAULT '0',
1525 `VisoKroviniu` int(11) NOT NULL DEFAULT '0',
1526 `SiandienParduotaGun` int(11) NOT NULL DEFAULT '0',
1527 `SiandienParduotaNark` int(11) NOT NULL DEFAULT '0',
1528 `VisoParduotaGun` int(11) NOT NULL DEFAULT '0',
1529 `VisoParduotaNark` int(11) NOT NULL DEFAULT '0',
1530 `CarIrankiai` int(11) NOT NULL DEFAULT '0',
1531 `VisoParduotaIrankiu` int(11) NOT NULL DEFAULT '0',
1532 `SiandienParduotaIrankiu` int(11) NOT NULL DEFAULT '0',
1533 `Valiuta` int(11) NOT NULL,
1534 `Valiuta2` int(11) NOT NULL,
1535 `LaimetosVarzybos` int(11) NOT NULL,
1536 `setting_to` int(11) NOT NULL,
1537 `MiresZonoje` int(11) NOT NULL,
1538 `setting_get` int(11) NOT NULL,
1539 `PagavoSiandien` int(11) NOT NULL DEFAULT '0',
1540 `meskere` int(11) DEFAULT '0',
1541 `AntiCheat` int(11) NOT NULL,
1542 `prizes` int(5) NOT NULL DEFAULT '0',
1543 `galiKrautis` int(11) NOT NULL,
1544 `LikoEmail` int(11) NOT NULL,
1545 `NuimamasElP` int(11) NOT NULL,
1546 `NuimamasSQ` int(11) NOT NULL,
1547 `LikoSQ` int(11) NOT NULL,
1548 `drk_blist` int(11) NOT NULL DEFAULT '0',
1549 `mafiju_blist` int(11) NOT NULL DEFAULT '0',
1550 `teisesaugos_blist` int(11) NOT NULL DEFAULT '0',
1551 `darbu_blist` int(11) NOT NULL DEFAULT '0',
1552 `teisesaugos_blist_uzdejo` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1553 `mafiju_blist_uzdejo` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1554 `darbu_blist_uzdejo` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1555 `drk_blist_uzdejo` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1556 `drk_blist_reason` varchar(128) COLLATE utf8_lithuanian_ci NOT NULL,
1557 `mafiju_blist_reason` varchar(128) COLLATE utf8_lithuanian_ci NOT NULL,
1558 `teisesaugos_blist_reason` varchar(128) COLLATE utf8_lithuanian_ci NOT NULL,
1559 `darbu_blist_reason` varchar(128) COLLATE utf8_lithuanian_ci NOT NULL,
1560 `TuriNama` int(11) NOT NULL,
1561 `TookSummer` int(11) NOT NULL,
1562 `playedMonth` int(11) NOT NULL
1563) ENGINE=InnoDB AUTO_INCREMENT=1814 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
1564
1565-- --------------------------------------------------------
1566
1567--
1568-- Sukurta duomenų struktūra lentelei `playerStats`
1569--
1570
1571CREATE TABLE IF NOT EXISTS `playerStats` (
1572 `Name` varchar(25) NOT NULL,
1573 `GunCargoToday` int(11) NOT NULL,
1574 `NarkCargoToday` int(11) NOT NULL,
1575 `HPCargoToday` int(11) NOT NULL,
1576 `CarCargoToday` int(11) NOT NULL,
1577 `GasCargoToday` int(11) NOT NULL,
1578 `GunAmmoToday` int(11) NOT NULL,
1579 `NarkGramsToday` int(11) NOT NULL,
1580 `GunCargoAll` int(11) NOT NULL,
1581 `NarkCargoAll` int(11) NOT NULL,
1582 `HPCargoAll` int(11) NOT NULL,
1583 `CarCargoAll` int(11) NOT NULL,
1584 `GasCargoAll` int(11) NOT NULL,
1585 `GunAmmoAll` int(11) NOT NULL,
1586 `NarkGramsAll` int(11) NOT NULL,
1587 `WeedPDToday` int(11) NOT NULL,
1588 `HeroPDToday` int(11) NOT NULL,
1589 `CokePDToday` int(11) NOT NULL,
1590 `WeedPDAll` int(11) NOT NULL,
1591 `HeroPDAll` int(11) NOT NULL,
1592 `CokePDAll` int(11) NOT NULL,
1593 `KillsToday` int(11) NOT NULL,
1594 `KillsAll` int(11) NOT NULL,
1595 `AK47Today` int(11) NOT NULL,
1596 `AK47All` int(11) NOT NULL,
1597 `AWPToday` int(11) NOT NULL,
1598 `AWPAll` int(11) NOT NULL,
1599 `SGToday` int(11) NOT NULL,
1600 `SGAll` int(11) NOT NULL,
1601 `TECToday` int(11) NOT NULL,
1602 `TECAll` int(11) NOT NULL,
1603 `DGLToday` int(11) NOT NULL,
1604 `DGLAll` int(11) NOT NULL,
1605 `SPToday` int(11) NOT NULL,
1606 `SPAll` int(11) NOT NULL,
1607 `mmToday` int(11) NOT NULL,
1608 `mmAll` int(11) NOT NULL,
1609 `GolfToday` int(11) NOT NULL,
1610 `GolfAll` int(11) NOT NULL,
1611 `BatToday` int(11) NOT NULL,
1612 `BatAll` int(11) NOT NULL,
1613 `KatanToday` int(11) NOT NULL,
1614 `KatanAll` int(11) NOT NULL,
1615 `SoldWeedToday` int(11) NOT NULL,
1616 `SoldWeedAll` int(11) NOT NULL,
1617 `SoldCokeToday` int(11) NOT NULL,
1618 `SoldCokeAll` int(11) NOT NULL,
1619 `SoldHeroToday` int(11) NOT NULL,
1620 `SoldHeroAll` int(11) NOT NULL,
1621 `JobMoneyToday` int(11) NOT NULL,
1622 `JobMoneyAll` int(11) NOT NULL,
1623 `UniformToday` int(11) NOT NULL,
1624 `DrivenJob` float NOT NULL
1625) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1626
1627-- --------------------------------------------------------
1628
1629--
1630-- Sukurta duomenų struktūra lentelei `playerXp`
1631--
1632
1633CREATE TABLE IF NOT EXISTS `playerXp` (
1634`ID` int(11) NOT NULL,
1635 `Name` varchar(24) NOT NULL,
1636 `copXp` int(11) NOT NULL,
1637 `taxiXp` int(11) NOT NULL,
1638 `medicXp` int(11) NOT NULL,
1639 `mechXp` int(11) NOT NULL,
1640 `gangXp` int(11) NOT NULL,
1641 `radioXp` int(11) NOT NULL,
1642 `truckXp` int(11) NOT NULL,
1643 `sellXp` int(11) NOT NULL,
1644 `unempXp` int(11) NOT NULL
1645) ENGINE=InnoDB AUTO_INCREMENT=329 DEFAULT CHARSET=latin1;
1646
1647-- --------------------------------------------------------
1648
1649--
1650-- Sukurta duomenų struktūra lentelei `priezastys`
1651--
1652
1653CREATE TABLE IF NOT EXISTS `priezastys` (
1654`ID` int(24) NOT NULL,
1655 `Name` varchar(24) NOT NULL,
1656 `Priezastis` varchar(180) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL
1657) ENGINE=MyISAM AUTO_INCREMENT=583 DEFAULT CHARSET=latin1;
1658
1659-- --------------------------------------------------------
1660
1661--
1662-- Sukurta duomenų struktūra lentelei `prisijungimai`
1663--
1664
1665CREATE TABLE IF NOT EXISTS `prisijungimai` (
1666 `Vardas` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1667 `IP` varchar(24) COLLATE utf8_lithuanian_ci NOT NULL,
1668 `Data` int(24) NOT NULL
1669) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
1670
1671-- --------------------------------------------------------
1672
1673--
1674-- Sukurta duomenų struktūra lentelei `prizai`
1675--
1676
1677CREATE TABLE IF NOT EXISTS `prizai` (
1678 `name` varchar(255) NOT NULL
1679) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1680
1681-- --------------------------------------------------------
1682
1683--
1684-- Sukurta duomenų struktūra lentelei `radistainustatymai`
1685--
1686
1687CREATE TABLE IF NOT EXISTS `radistainustatymai` (
1688 `1` int(11) NOT NULL,
1689 `2` int(11) NOT NULL,
1690 `3` int(11) NOT NULL,
1691 `4` int(11) NOT NULL,
1692 `5` int(11) NOT NULL,
1693 `6` int(11) NOT NULL
1694) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1695
1696--
1697-- Sukurta duomenų kopija lentelei `radistainustatymai`
1698--
1699
1700INSERT INTO `radistainustatymai` (`1`, `2`, `3`, `4`, `5`, `6`) VALUES
1701(1, 1, 1, 1, 1, 1);
1702
1703-- --------------------------------------------------------
1704
1705--
1706-- Sukurta duomenų struktūra lentelei `smszinutes`
1707--
1708
1709CREATE TABLE IF NOT EXISTS `smszinutes` (
1710 `ReceiverName` varchar(24) NOT NULL,
1711 `SenderName` varchar(24) NOT NULL,
1712 `Zinute` varchar(24) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
1713`ID` int(11) NOT NULL,
1714 `SendingTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
1715) ENGINE=MyISAM AUTO_INCREMENT=64066 DEFAULT CHARSET=latin1;
1716
1717-- --------------------------------------------------------
1718
1719--
1720-- Sukurta duomenų struktūra lentelei `spdnustatymai`
1721--
1722
1723CREATE TABLE IF NOT EXISTS `spdnustatymai` (
1724 `1` int(11) NOT NULL,
1725 `2` int(11) NOT NULL,
1726 `3` int(11) NOT NULL,
1727 `4` int(11) NOT NULL,
1728 `5` int(11) NOT NULL,
1729 `6` int(11) NOT NULL,
1730 `7` int(11) NOT NULL,
1731 `8` int(11) NOT NULL,
1732 `9` int(11) NOT NULL,
1733 `10` int(11) NOT NULL,
1734 `11` int(11) NOT NULL,
1735 `12` int(11) NOT NULL,
1736 `13` int(11) NOT NULL,
1737 `14` int(11) NOT NULL
1738) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1739
1740--
1741-- Sukurta duomenų kopija lentelei `spdnustatymai`
1742--
1743
1744INSERT INTO `spdnustatymai` (`1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`, `10`, `11`, `12`, `13`, `14`) VALUES
1745(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
1746
1747-- --------------------------------------------------------
1748
1749--
1750-- Sukurta duomenų struktūra lentelei `taksi1fnustatymai`
1751--
1752
1753CREATE TABLE IF NOT EXISTS `taksi1fnustatymai` (
1754 `SKIN189_RANGAS` int(11) NOT NULL,
1755 `SKIN187_RANGAS` int(11) NOT NULL,
1756 `Vehicle438` int(11) NOT NULL,
1757 `Vehicle560` int(11) NOT NULL,
1758 `Vehicle418` int(11) NOT NULL,
1759 `KilometroKaina` int(11) NOT NULL,
1760 `TaksiZenklas` int(11) NOT NULL
1761) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1762
1763--
1764-- Sukurta duomenų kopija lentelei `taksi1fnustatymai`
1765--
1766
1767INSERT INTO `taksi1fnustatymai` (`SKIN189_RANGAS`, `SKIN187_RANGAS`, `Vehicle438`, `Vehicle560`, `Vehicle418`, `KilometroKaina`, `TaksiZenklas`) VALUES
1768(1, 3, 3, 5, 1, 500, 1);
1769
1770-- --------------------------------------------------------
1771
1772--
1773-- Sukurta duomenų struktūra lentelei `taksi2fnustatymai`
1774--
1775
1776CREATE TABLE IF NOT EXISTS `taksi2fnustatymai` (
1777 `SKIN187_RANGAS` int(11) NOT NULL DEFAULT '1',
1778 `SKIN240_RANGAS` int(11) NOT NULL DEFAULT '1',
1779 `Vehicle420` int(11) NOT NULL DEFAULT '1',
1780 `Vehicle560` int(11) NOT NULL DEFAULT '1',
1781 `Vehicle418` int(11) NOT NULL DEFAULT '1',
1782 `KilometroKaina` int(11) NOT NULL DEFAULT '1',
1783 `TaksiZenklas` int(11) NOT NULL DEFAULT '1'
1784) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1785
1786--
1787-- Sukurta duomenų kopija lentelei `taksi2fnustatymai`
1788--
1789
1790INSERT INTO `taksi2fnustatymai` (`SKIN187_RANGAS`, `SKIN240_RANGAS`, `Vehicle420`, `Vehicle560`, `Vehicle418`, `KilometroKaina`, `TaksiZenklas`) VALUES
1791(1, 1, 1, 1, 1, 1, 1);
1792
1793-- --------------------------------------------------------
1794
1795--
1796-- Sukurta duomenų struktūra lentelei `tbsettings`
1797--
1798
1799CREATE TABLE IF NOT EXISTS `tbsettings` (
1800 `1` int(11) NOT NULL DEFAULT '1',
1801 `2` int(11) NOT NULL DEFAULT '1',
1802 `3` int(11) NOT NULL DEFAULT '1',
1803 `4` int(11) NOT NULL DEFAULT '1',
1804 `5` int(11) NOT NULL DEFAULT '1',
1805 `6` int(11) NOT NULL DEFAULT '1',
1806 `TBAmmoShotgun` int(11) NOT NULL,
1807 `TBAmmoDeagle` int(11) NOT NULL,
1808 `TBAmmoAK47` int(11) NOT NULL,
1809 `TBAmmoSniper` int(11) NOT NULL
1810) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1811
1812--
1813-- Sukurta duomenų kopija lentelei `tbsettings`
1814--
1815
1816INSERT INTO `tbsettings` (`1`, `2`, `3`, `4`, `5`, `6`, `TBAmmoShotgun`, `TBAmmoDeagle`, `TBAmmoAK47`, `TBAmmoSniper`) VALUES
1817(1, 1, 1, 1, 1, 1, 25000, 25000, 25000, 25000);
1818
1819-- --------------------------------------------------------
1820
1821--
1822-- Sukurta duomenų struktūra lentelei `teisesaugos_blist`
1823--
1824
1825CREATE TABLE IF NOT EXISTS `teisesaugos_blist` (
1826`id` int(11) NOT NULL,
1827 `name` varchar(24) NOT NULL,
1828 `reason` varchar(128) CHARACTER SET utf16 COLLATE utf16_lithuanian_ci NOT NULL,
1829 `time` int(11) NOT NULL,
1830 `admin` varchar(24) NOT NULL,
1831 `date` varchar(24) NOT NULL,
1832 `date_end` varchar(24) NOT NULL
1833) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
1834
1835-- --------------------------------------------------------
1836
1837--
1838-- Sukurta duomenų struktūra lentelei `valiuta_logs`
1839--
1840
1841CREATE TABLE IF NOT EXISTS `valiuta_logs` (
1842 `u_name` varchar(24) NOT NULL,
1843 `u_quantity` int(11) NOT NULL,
1844 `u_orderID` varchar(64) NOT NULL
1845) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1846
1847-- --------------------------------------------------------
1848
1849--
1850-- Sukurta duomenų struktūra lentelei `varzybos`
1851--
1852
1853CREATE TABLE IF NOT EXISTS `varzybos` (
1854 `data` varchar(255) NOT NULL,
1855 `laimetojas` varchar(255) NOT NULL,
1856 `prazaide` double NOT NULL
1857) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1858
1859--
1860-- Indexes for dumped tables
1861--
1862
1863--
1864-- Indexes for table `bussinesses`
1865--
1866ALTER TABLE `bussinesses`
1867 ADD PRIMARY KEY (`ID`);
1868
1869--
1870-- Indexes for table `clothesforcredits`
1871--
1872ALTER TABLE `clothesforcredits`
1873 ADD UNIQUE KEY `ID` (`ID`);
1874
1875--
1876-- Indexes for table `darbuinformacija`
1877--
1878ALTER TABLE `darbuinformacija`
1879 ADD PRIMARY KEY (`DarboID`);
1880
1881--
1882-- Indexes for table `darbuotojai`
1883--
1884ALTER TABLE `darbuotojai`
1885 ADD PRIMARY KEY (`ID`);
1886
1887--
1888-- Indexes for table `darbu_blist`
1889--
1890ALTER TABLE `darbu_blist`
1891 ADD PRIMARY KEY (`id`);
1892
1893--
1894-- Indexes for table `distorijos`
1895--
1896ALTER TABLE `distorijos`
1897 ADD PRIMARY KEY (`id`);
1898
1899--
1900-- Indexes for table `drk_blist`
1901--
1902ALTER TABLE `drk_blist`
1903 ADD PRIMARY KEY (`id`);
1904
1905--
1906-- Indexes for table `d_messages`
1907--
1908ALTER TABLE `d_messages`
1909 ADD PRIMARY KEY (`id`);
1910
1911--
1912-- Indexes for table `fishing_data`
1913--
1914ALTER TABLE `fishing_data`
1915 ADD PRIMARY KEY (`id`);
1916
1917--
1918-- Indexes for table `garazai`
1919--
1920ALTER TABLE `garazai`
1921 ADD PRIMARY KEY (`ID`);
1922
1923--
1924-- Indexes for table `gzones`
1925--
1926ALTER TABLE `gzones`
1927 ADD PRIMARY KEY (`id`);
1928
1929--
1930-- Indexes for table `houses`
1931--
1932ALTER TABLE `houses`
1933 ADD PRIMARY KEY (`HouseID`);
1934
1935--
1936-- Indexes for table `israsas`
1937--
1938ALTER TABLE `israsas`
1939 ADD PRIMARY KEY (`ID`);
1940
1941--
1942-- Indexes for table `itarimai`
1943--
1944ALTER TABLE `itarimai`
1945 ADD PRIMARY KEY (`ID`);
1946
1947--
1948-- Indexes for table `Klubai`
1949--
1950ALTER TABLE `Klubai`
1951 ADD PRIMARY KEY (`ID`);
1952
1953--
1954-- Indexes for table `KlubaiCars`
1955--
1956ALTER TABLE `KlubaiCars`
1957 ADD PRIMARY KEY (`ID`);
1958
1959--
1960-- Indexes for table `KlubaiPaliko`
1961--
1962ALTER TABLE `KlubaiPaliko`
1963 ADD PRIMARY KEY (`ID`);
1964
1965--
1966-- Indexes for table `KlubaiUsers`
1967--
1968ALTER TABLE `KlubaiUsers`
1969 ADD PRIMARY KEY (`ID`);
1970
1971--
1972-- Indexes for table `mafiju_blist`
1973--
1974ALTER TABLE `mafiju_blist`
1975 ADD PRIMARY KEY (`id`);
1976
1977--
1978-- Indexes for table `masinuturguskiekiai`
1979--
1980ALTER TABLE `masinuturguskiekiai`
1981 ADD PRIMARY KEY (`ModelID`);
1982
1983--
1984-- Indexes for table `nuosavostrpriemones`
1985--
1986ALTER TABLE `nuosavostrpriemones`
1987 ADD UNIQUE KEY `ID` (`ID`);
1988
1989--
1990-- Indexes for table `palikodarba`
1991--
1992ALTER TABLE `palikodarba`
1993 ADD UNIQUE KEY `id` (`id`);
1994
1995--
1996-- Indexes for table `players`
1997--
1998ALTER TABLE `players`
1999 ADD UNIQUE KEY `id` (`id`), ADD UNIQUE KEY `Name` (`Name`);
2000
2001--
2002-- Indexes for table `playerXp`
2003--
2004ALTER TABLE `playerXp`
2005 ADD PRIMARY KEY (`ID`);
2006
2007--
2008-- Indexes for table `priezastys`
2009--
2010ALTER TABLE `priezastys`
2011 ADD PRIMARY KEY (`ID`);
2012
2013--
2014-- Indexes for table `smszinutes`
2015--
2016ALTER TABLE `smszinutes`
2017 ADD PRIMARY KEY (`ID`);
2018
2019--
2020-- Indexes for table `teisesaugos_blist`
2021--
2022ALTER TABLE `teisesaugos_blist`
2023 ADD PRIMARY KEY (`id`);
2024
2025--
2026-- AUTO_INCREMENT for dumped tables
2027--
2028
2029--
2030-- AUTO_INCREMENT for table `clothesforcredits`
2031--
2032ALTER TABLE `clothesforcredits`
2033MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=61;
2034--
2035-- AUTO_INCREMENT for table `darbuinformacija`
2036--
2037ALTER TABLE `darbuinformacija`
2038MODIFY `DarboID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
2039--
2040-- AUTO_INCREMENT for table `darbuotojai`
2041--
2042ALTER TABLE `darbuotojai`
2043MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=181;
2044--
2045-- AUTO_INCREMENT for table `darbu_blist`
2046--
2047ALTER TABLE `darbu_blist`
2048MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2049--
2050-- AUTO_INCREMENT for table `distorijos`
2051--
2052ALTER TABLE `distorijos`
2053MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2869;
2054--
2055-- AUTO_INCREMENT for table `drk_blist`
2056--
2057ALTER TABLE `drk_blist`
2058MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=37;
2059--
2060-- AUTO_INCREMENT for table `d_messages`
2061--
2062ALTER TABLE `d_messages`
2063MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9464;
2064--
2065-- AUTO_INCREMENT for table `fishing_data`
2066--
2067ALTER TABLE `fishing_data`
2068MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1649;
2069--
2070-- AUTO_INCREMENT for table `gzones`
2071--
2072ALTER TABLE `gzones`
2073MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19;
2074--
2075-- AUTO_INCREMENT for table `israsas`
2076--
2077ALTER TABLE `israsas`
2078MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4263;
2079--
2080-- AUTO_INCREMENT for table `itarimai`
2081--
2082ALTER TABLE `itarimai`
2083MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8255;
2084--
2085-- AUTO_INCREMENT for table `Klubai`
2086--
2087ALTER TABLE `Klubai`
2088MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2089--
2090-- AUTO_INCREMENT for table `KlubaiCars`
2091--
2092ALTER TABLE `KlubaiCars`
2093MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2094--
2095-- AUTO_INCREMENT for table `KlubaiPaliko`
2096--
2097ALTER TABLE `KlubaiPaliko`
2098MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
2099--
2100-- AUTO_INCREMENT for table `KlubaiUsers`
2101--
2102ALTER TABLE `KlubaiUsers`
2103MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=675;
2104--
2105-- AUTO_INCREMENT for table `mafiju_blist`
2106--
2107ALTER TABLE `mafiju_blist`
2108MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
2109--
2110-- AUTO_INCREMENT for table `nuosavostrpriemones`
2111--
2112ALTER TABLE `nuosavostrpriemones`
2113MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=951;
2114--
2115-- AUTO_INCREMENT for table `palikodarba`
2116--
2117ALTER TABLE `palikodarba`
2118MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1103;
2119--
2120-- AUTO_INCREMENT for table `players`
2121--
2122ALTER TABLE `players`
2123MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1814;
2124--
2125-- AUTO_INCREMENT for table `playerXp`
2126--
2127ALTER TABLE `playerXp`
2128MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=329;
2129--
2130-- AUTO_INCREMENT for table `priezastys`
2131--
2132ALTER TABLE `priezastys`
2133MODIFY `ID` int(24) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=583;
2134--
2135-- AUTO_INCREMENT for table `smszinutes`
2136--
2137ALTER TABLE `smszinutes`
2138MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=64066;
2139--
2140-- AUTO_INCREMENT for table `teisesaugos_blist`
2141--
2142ALTER TABLE `teisesaugos_blist`
2143MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
2144/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2145/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2146/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;