· 9 years ago · Apr 06, 2017, 01:26 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 2017 m. Kov 05 d. 09:48
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
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: `gm`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Sukurta duomenų struktūra lentelei `baudos`
27--
28
29CREATE TABLE IF NOT EXISTS `baudos` (
30 `bauda_ID` int(11) NOT NULL AUTO_INCREMENT,
31 `bauda_pID` int(11) NOT NULL,
32 `bauda_Money` int(9) NOT NULL,
33 `bauda_Reason` varchar(50) NOT NULL,
34 PRIMARY KEY (`bauda_ID`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
36
37--
38-- Sukurta duomenų kopija lentelei `baudos`
39--
40
41INSERT INTO `baudos` (`bauda_ID`, `bauda_pID`, `bauda_Money`, `bauda_Reason`) VALUES
42(1, 19, 150, 'KET nesilaikymas'),
43(2, 22, 1000, 'pareigûno iþeidinëjimas');
44
45-- --------------------------------------------------------
46
47--
48-- Sukurta duomenų struktūra lentelei `business`
49--
50
51CREATE TABLE IF NOT EXISTS `business` (
52 `bID` int(11) NOT NULL AUTO_INCREMENT,
53 `bOwnerID` int(11) NOT NULL,
54 `bName` varchar(50) NOT NULL,
55 `bPosX` float NOT NULL,
56 `bPosY` float NOT NULL,
57 `bPosZ` float NOT NULL,
58 `bcInterior` int(5) NOT NULL,
59 `bcPosX` float NOT NULL,
60 `bcPosY` float NOT NULL,
61 `bcPosZ` float NOT NULL,
62 `bkPosX` float NOT NULL,
63 `bkPosY` float NOT NULL,
64 `bkPosZ` float NOT NULL,
65 `bIsBuyable` int(1) NOT NULL,
66 `bPrice` int(11) NOT NULL,
67 `bType` int(1) NOT NULL,
68 `bExtra0` int(11) NOT NULL,
69 `bEarnings` int(11) NOT NULL,
70 PRIMARY KEY (`bID`)
71) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
72
73--
74-- Sukurta duomenų kopija lentelei `business`
75--
76
77INSERT INTO `business` (`bID`, `bOwnerID`, `bName`, `bPosX`, `bPosY`, `bPosZ`, `bcInterior`, `bcPosX`, `bcPosY`, `bcPosZ`, `bkPosX`, `bkPosY`, `bkPosZ`, `bIsBuyable`, `bPrice`, `bType`, `bExtra0`, `bEarnings`) VALUES
78(4, 19, 'Lukoil', 1930.31, -1785.81, 13.547, 0, 1930.21, -1779.51, 13.547, 1922.57, -1790.8, 13.383, 0, 1250000, 1, 15, 0),
79(5, -1, 'be pavadinimo', 1194.22, -917.189, 43.164, 0, 0, 0, 0, 0, 0, 0, 1, 2500000, 0, 0, 0),
80(6, 1, 'Baldyla', 1115.54, -1371.03, 13.991, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 0, 0);
81
82-- --------------------------------------------------------
83
84--
85-- Sukurta duomenų struktūra lentelei `gangs`
86--
87
88CREATE TABLE IF NOT EXISTS `gangs` (
89 `gangID` int(11) NOT NULL AUTO_INCREMENT,
90 `gangName` varchar(30) NOT NULL,
91 `gangLeadID` int(11) NOT NULL,
92 `gangRep` int(11) NOT NULL,
93 `gangColor` int(11) NOT NULL,
94 `gangX` float NOT NULL,
95 `gangY` float NOT NULL,
96 `gangZ` float NOT NULL,
97 PRIMARY KEY (`gangID`)
98) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
99
100--
101-- Sukurta duomenų kopija lentelei `gangs`
102--
103
104INSERT INTO `gangs` (`gangID`, `gangName`, `gangLeadID`, `gangRep`, `gangColor`, `gangX`, `gangY`, `gangZ`) VALUES
105(1, 'ðuo', 22, 15, 0, 2492.17, -1692.1, 14.7656),
106(2, 'Pakaraka', 19, 9000, 0, 1967.54, -1176.65, 20.0307);
107
108-- --------------------------------------------------------
109
110--
111-- Sukurta duomenų struktūra lentelei `garages`
112--
113
114CREATE TABLE IF NOT EXISTS `garages` (
115 `gID` int(11) NOT NULL AUTO_INCREMENT,
116 `gOwnerID` int(11) NOT NULL,
117 `gPrice` int(11) NOT NULL,
118 `gGalioja` int(11) NOT NULL,
119 `gBuyable` int(1) NOT NULL,
120 `gPosX` float NOT NULL,
121 `gPosY` float NOT NULL,
122 `gPosZ` float NOT NULL,
123 `gVartaiID` int(4) NOT NULL,
124 PRIMARY KEY (`gID`)
125) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
126
127--
128-- Sukurta duomenų kopija lentelei `garages`
129--
130
131INSERT INTO `garages` (`gID`, `gOwnerID`, `gPrice`, `gGalioja`, `gBuyable`, `gPosX`, `gPosY`, `gPosZ`, `gVartaiID`) VALUES
132(15, 19, 555, 1436727354, 0, 1189.75, -1012.93, 32.547, 2),
133(16, -1, 69, 1428017999, 1, 1196.14, -1012.41, 32.551, 1);
134
135-- --------------------------------------------------------
136
137--
138-- Sukurta duomenų struktūra lentelei `gps`
139--
140
141CREATE TABLE IF NOT EXISTS `gps` (
142 `gpsID` int(11) NOT NULL AUTO_INCREMENT,
143 `gpsName` varchar(40) NOT NULL,
144 `gpsX` float NOT NULL,
145 `gpsY` float NOT NULL,
146 `gpsZ` float NOT NULL,
147 `gpsType` int(2) NOT NULL,
148 PRIMARY KEY (`gpsID`)
149) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
150
151--
152-- Sukurta duomenų kopija lentelei `gps`
153--
154
155INSERT INTO `gps` (`gpsID`, `gpsName`, `gpsX`, `gpsY`, `gpsZ`, `gpsType`) VALUES
156(6, 'LS - Transporto turgus', 2267.85, -1974.65, 13.362, 2),
157(9, 'LS - Degalinë', 1941.88, -1759.77, 13.14, 2),
158(10, 'LS - Policija', 1530.44, -1675.22, 13.383, 0),
159(11, 'LS - Ligoninë', 1996, -1452.45, 13.325, 2),
160(12, 'LS - Bankas', 1722.14, -1292.76, 13.547, 2),
161(13, 'LS - Tune', 1040.53, -1032.42, 31.997, 2),
162(14, 'LS - Oro uostas', 1923.74, -2409.43, 13.197, 2),
163(15, 'SF - Tune (WAA)', -2690.47, 210.164, 4.328, 2),
164(16, 'LS - Fûristai', 2760.57, -2459.21, 13.56, 0),
165(17, 'LS - Taksi', 1814.12, -1871.19, 13.57, 0),
166(18, 'Atsiradimo vieta', 634.72, -1451.06, 14.183, 2),
167(19, 'LS - 2 Ligoninë', 1200.97, -1327.59, 13.398, 2);
168
169-- --------------------------------------------------------
170
171--
172-- Sukurta duomenų struktūra lentelei `gzones`
173--
174
175CREATE TABLE IF NOT EXISTS `gzones` (
176 `gID` int(2) NOT NULL AUTO_INCREMENT,
177 `gminX` float NOT NULL,
178 `gminY` float NOT NULL,
179 `gmaxX` float NOT NULL,
180 `gmaxY` float NOT NULL,
181 `gOwners` int(11) NOT NULL,
182 PRIMARY KEY (`gID`)
183) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=61 ;
184
185--
186-- Sukurta duomenų kopija lentelei `gzones`
187--
188
189INSERT INTO `gzones` (`gID`, `gminX`, `gminY`, `gmaxX`, `gmaxY`, `gOwners`) VALUES
190(1, 2222.5, -1852.8, 2632.8, -1722.3, -1),
191(2, 2222.5, -1722.3, 2632.8, -1628.5, -1),
192(3, 1812.6, -1852.8, 1971.6, -1742.3, -1),
193(4, 1951.6, -1742.3, 2124.6, -1602.3, 7),
194(5, 1812.6, -1602.3, 2124.6, -1449.6, -1),
195(6, 2124.6, -1742.3, 2222.5, -1494, -1),
196(7, 1971.6, -1852.8, 2222.5, -1742.3, -1),
197(8, 1812.6, -1742.3, 1951.6, -1602.3, -1),
198(9, 1970.6, -2179.2, 2089, -1852.8, 6),
199(10, 2089, -1989.9, 2324, -1852.8, -1),
200(11, 2089, -2235.8, 2201.8, -1989.9, -1),
201(12, 2324, -2059.2, 2541.7, -1852.8, -1),
202(13, 2056.8, -1372, 2281.4, -1210.7, -1),
203(14, 2056.8, -1210.7, 2185.3, -1126.3, -1),
204(15, 2056.8, -1449.6, 2266.2, -1372, -1),
205(16, 2421, -1628.5, 2632.8, -1454.3, -1),
206(17, 2222.5, -1628.5, 2421, -1494, -1),
207(18, 2266.2, -1494, 2381.6, -1372, -1),
208(19, 2281.6, -1372, 2381.6, -1135, -1),
209(20, 2381.6, -1454.3, 2462.1, -1135, -1),
210(21, 2462.1, -1454.3, 2581.7, -1135, -1),
211(22, 2632.8, -1852.8, 2959.3, -1668.1, -1),
212(23, 2632.8, -1668.1, 2747.7, -1393.4, -1),
213(24, 2747.7, -1668.1, 2959.3, -1498.6, 5),
214(25, 2747.7, -1498.6, 2959.3, -1120, -1),
215(26, 2703.5, -2126.9, 2959.3, -1852.8, -1),
216(27, 1812.6, -2179.2, 1970.6, -1852.8, -1),
217(28, 1692.6, -2179.2, 1812.6, -1842.2, -1),
218(29, 1812.6, -1350.7, 2056.8, -1100.8, -1),
219(30, 2581.7, -1393.4, 2747.7, -1135, -1),
220(31, 1994.3, -1100.8, 2056.8, -920.8, -1),
221(32, 2056.8, -1126.3, 2126.8, -920.8, -1),
222(33, 2185.3, -1154.5, 2281.4, -934.4, -1),
223(34, 2126.8, -1126.3, 2185.3, -934.4, -1),
224(35, 2632.7, -1135, 2747.7, -945, -1),
225(36, 2281.4, -1135, 2632.7, -945, -1),
226(37, 930.2, -2006.7, 1073.2, -1804.2, -1),
227(38, 851.4, -1804.2, 1046.1, -1577.5, -1),
228(39, 1161.5, -1722.2, 1323.9, -1577.5, -1),
229(40, 1046.1, -1722.2, 1161.5, -1577.5, -1),
230(41, 1169.1, -910.1, 1318.1, -768, -1),
231(42, 1318.1, -910.1, 1357, -768, -1),
232(43, 1357, -926.9, 1463.9, -768, -1),
233(44, 1185.58, -767.09, 1462.02, -641.76, -1),
234(45, 1327.89, -1729.33, 1821.77, -1573.59, -1),
235(46, 1249.6, -2394.3, 1852, -2179.2, -1),
236(47, 1852, -2394.3, 2089, -2179.2, -1),
237(48, 1382.7, -2730.8, 2201.8, -2394.3, -1),
238(49, 2373.7, -2697, 2809.2, -2330.4, -1),
239(50, 2201.8, -2418.3, 2324, -2095, -1),
240(51, 2324, -2302.3, 2703.5, -2145.1, -1),
241(52, 2089, -2394.3, 2201.8, -2235.8, -1),
242(53, 2201.8, -2730.8, 2324, -2418.3, -1),
243(54, 2703.5, -2302.3, 2959.3, -2126.9, -1),
244(55, 2324, -2145.1, 2703.5, -2059.2, -1),
245(56, 787.4, -1416.2, 1072.6, -1310.2, -1),
246(57, 952.6, -1310.2, 1072.6, -1130.8, -1),
247(58, 1072.6, -1416.2, 1370.8, -1130.8, -1),
248(59, 926.9, -1577.5, 1370.8, -1416.2, -1),
249(60, 1370.8, -1384.9, 1463.9, -1170.8, -1);
250
251-- --------------------------------------------------------
252
253--
254-- Sukurta duomenų struktūra lentelei `houses`
255--
256
257CREATE TABLE IF NOT EXISTS `houses` (
258 `hID` int(11) NOT NULL AUTO_INCREMENT,
259 `hOwnerID` int(11) NOT NULL,
260 `hLocked` int(1) NOT NULL,
261 `hInterior` int(11) NOT NULL,
262 `hIsBuyable` int(1) NOT NULL,
263 `hoPosX` float NOT NULL,
264 `hoPosY` float NOT NULL,
265 `hoPosZ` float NOT NULL,
266 `hiPosX` float NOT NULL,
267 `hiPosY` float NOT NULL,
268 `hiPosZ` float NOT NULL,
269 `hPrice` int(11) NOT NULL,
270 `hAlarm` int(2) NOT NULL,
271 `hCamera` int(2) NOT NULL,
272 `hDoors` int(2) NOT NULL,
273 `hIntUpgrade` int(11) NOT NULL,
274 PRIMARY KEY (`hID`)
275) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;
276
277--
278-- Sukurta duomenų kopija lentelei `houses`
279--
280
281INSERT INTO `houses` (`hID`, `hOwnerID`, `hLocked`, `hInterior`, `hIsBuyable`, `hoPosX`, `hoPosY`, `hoPosZ`, `hiPosX`, `hiPosY`, `hiPosZ`, `hPrice`, `hAlarm`, `hCamera`, `hDoors`, `hIntUpgrade`) VALUES
282(1, -1, 1, 1, 1, 2437.85, -2020.36, 13.903, 223.2, 1287.08, 1082.14, 35000, 0, 0, 0, 0),
283(2, -1, 1, 1, 1, 2465.34, -2020.14, 14.124, 223.2, 1287.08, 1082.14, 40000, 0, 0, 0, 0),
284(3, -1, 1, 1, 1, 2486.4, -2021.24, 13.999, 223.2, 1287.08, 1082.14, 39000, 0, 0, 0, 0),
285(4, -1, 1, 1, 1, 2507.85, -2020.61, 14.21, 223.2, 1287.08, 1082.14, 27000, 0, 0, 0, 0),
286(5, -1, 1, 1, 1, 2522.36, -2018.79, 14.074, 223.2, 1287.08, 1082.14, 35000, 0, 0, 0, 0),
287(6, -1, 1, 1, 1, 2524.2, -1998.44, 13.783, 223.2, 1287.08, 1082.14, 29000, 0, 0, 0, 0),
288(7, -1, 1, 1, 1, 2508.36, -1999.24, 13.641, 223.2, 1287.08, 1082.14, 29000, 0, 0, 0, 0),
289(8, -1, 1, 1, 1, 2483.5, -1996.07, 13.834, 223.2, 1287.08, 1082.14, 30000, 0, 0, 0, 0),
290(9, -1, 1, 1, 1, 2465.13, -1996.14, 13.689, 223.2, 1287.08, 1082.14, 30000, 0, 0, 0, 0),
291(10, -1, 1, 1, 1, 2696.38, -1991.16, 13.961, 223.2, 1287.08, 1082.14, 30000, 0, 0, 0, 0),
292(11, -1, 1, 1, 1, 2672.74, -1990.19, 13.994, 223.2, 1287.08, 1082.14, 29000, 0, 0, 0, 0),
293(12, -1, 1, 1, 1, 2652.85, -1990.13, 13.737, 223.2, 1287.08, 1082.14, 26000, 0, 0, 0, 0),
294(13, -1, 1, 1, 1, 2637.6, -1992.1, 13.994, 223.2, 1287.08, 1082.14, 29000, 0, 0, 0, 0),
295(14, -1, 1, 1, 1, 2636.18, -2012.45, 13.814, 223.2, 1287.08, 1082.14, 30000, 0, 0, 0, 0),
296(15, -1, 1, 1, 1, 2650.24, -2021.71, 14.177, 223.2, 1287.08, 1082.14, 69000, 0, 0, 0, 0),
297(16, -1, 1, 1, 1, 2673.27, -2019.96, 14.168, 223.2, 1287.08, 1082.14, 30000, 0, 0, 0, 0),
298(17, -1, 1, 1, 1, 2695.3, -2020.03, 14.022, 223.2, 1287.08, 1082.14, 28000, 0, 0, 0, 0),
299(18, 22, 1, 1, 0, 2402.46, -1716.02, 13.938, 223.2, 1287.08, 1082.14, 26000, 0, 0, 0, 0),
300(19, 22, 1, 1, 0, 2385.4, -1712.89, 14.194, 223.2, 1287.08, 1082.14, 95000, 0, 0, 0, 0),
301(20, 19, 1, 1, 0, 2326.86, -1717.56, 13.547, 223.2, 1287.08, 1082.14, 29000, 0, 0, 0, 1439997824),
302(21, 24, 1, 1, 0, 2308.89, -1715.57, 14.65, 223.2, 1287.08, 1082.14, 29000, 0, 0, 0, 1440388191),
303(22, 19, 1, 1, 0, 2459.43, -1690.46, 13.545, 223.2, 1287.08, 1082.14, 120000, 0, 0, 0, 0),
304(24, -1, 1, 1, 1, 2513.84, -1691.2, 14.046, 223.2, 1287.08, 1082.14, 100000, 0, 0, 0, 0),
305(25, 44, 1, 1, 0, 2522.58, -1679.34, 15.497, 223.2, 1287.08, 1082.14, 150000, 0, 0, 0, 0),
306(26, -1, 1, 1, 1, 2523.68, -1658.56, 15.494, 223.2, 1287.08, 1082.14, 100000, 0, 0, 0, 0),
307(27, -1, 1, 1, 1, 2513.4, -1650.69, 14.356, 223.2, 1287.08, 1082.14, 100000, 0, 0, 0, 0),
308(28, -1, 1, 1, 1, 2498.5, -1643.47, 13.783, 223.2, 1287.08, 1082.14, 90000, 0, 0, 0, 0),
309(29, 19, 1, 10, 0, 2486.58, -1645.55, 14.07, 223.2, 1287.08, 1082.14, 290000, 0, 0, 0, 1439990358),
310(30, -1, 1, 1, 1, 2469.52, -1646.9, 13.518, 223.2, 1287.08, 1082.14, 90000, 0, 0, 0, 0),
311(31, 19, 1, 10, 0, 2451.86, -1642.57, 13.736, 223.2, 1287.08, 1082.14, 55000, 0, 0, 1, 0),
312(32, -1, 1, 1, 1, 2413.91, -1647.28, 14.012, 223.2, 1287.08, 1082.14, 36000, 0, 0, 0, 0),
313(33, 6, 1, 1, 0, 2409.02, -1673.42, 13.599, 223.2, 1287.08, 1082.14, 35000, 0, 0, 0, 0),
314(34, -1, 1, 1, 1, 2393.19, -1646.67, 13.643, 223.2, 1287.08, 1082.14, 35000, 0, 0, 0, 0),
315(35, -1, 1, 1, 1, 2384.69, -1675.02, 14.715, 223.2, 1287.08, 1082.14, 34000, 0, 0, 0, 0),
316(36, -1, 1, 1, 1, 2368.27, -1674.99, 14.168, 223.2, 1287.08, 1082.14, 35000, 0, 0, 0, 0),
317(37, -1, 1, 1, 1, 2362.9, -1644.34, 13.534, 223.2, 1287.08, 1082.14, 36000, 0, 0, 0, 0);
318
319-- --------------------------------------------------------
320
321--
322-- Sukurta duomenų struktūra lentelei `mapicons`
323--
324
325CREATE TABLE IF NOT EXISTS `mapicons` (
326 `mi_ID` int(11) NOT NULL AUTO_INCREMENT,
327 `mi_Name` varchar(30) NOT NULL,
328 `mi_PosX` float NOT NULL,
329 `mi_PosY` float NOT NULL,
330 `mi_PosZ` float NOT NULL,
331 `mi_Type` int(2) NOT NULL,
332 `mi_VW` int(11) NOT NULL,
333 `mi_Interior` int(11) NOT NULL,
334 `mi_Streamdistance` float NOT NULL,
335 `mi_Show` int(1) NOT NULL,
336 PRIMARY KEY (`mi_ID`)
337) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
338
339--
340-- Sukurta duomenų kopija lentelei `mapicons`
341--
342
343INSERT INTO `mapicons` (`mi_ID`, `mi_Name`, `mi_PosX`, `mi_PosY`, `mi_PosZ`, `mi_Type`, `mi_VW`, `mi_Interior`, `mi_Streamdistance`, `mi_Show`) VALUES
344(1, 'Bankas', 1734.84, -1266.76, 13.543, 52, 0, 0, 1000, 0),
345(2, 'Idlewood parduotuve', 2129.81, -1761.15, 13.5625, 38, 0, 0, 1000, 0),
346(3, 'Ganton parduotuve', 2423.66, -1742.44, 13.5469, 38, 0, 0, 1000, 0),
347(4, 'East Beach parduotuve', 2751.63, -1468.24, 30.4531, 38, 0, 0, 1000, 0),
348(5, 'Jefferson parduotuve', 2139.72, -1191.97, 23.9922, 38, 0, 0, 1000, 0),
349(6, 'Downtown parduotuve', 1582.35, -1170.37, 24.0781, 38, 0, 0, 1000, 0),
350(8, 'LSPD', 1531.41, -1674.8, 13.3828, 30, 0, 0, 1000, 0),
351(9, 'LSMD', 1995.36, -1452.89, 13.5547, 22, 0, 0, 1000, 0),
352(16, 'Tiuningas', 1024.63, -1033.07, 31.841, 27, 0, 0, 1000, 0),
353(18, 'Garaþas1', 1189.95, -1013.27, 32.547, 55, 0, 0, 1000, 0),
354(19, 'Orouostas', 1923.74, -2409.43, 13.539, 5, 0, 0, 1000, 0),
355(20, 'Tune SF (WAA)', -2690.47, 210.164, 4.328, 27, 0, 0, 1000, 0);
356
357-- --------------------------------------------------------
358
359--
360-- Sukurta duomenų struktūra lentelei `objects`
361--
362
363CREATE TABLE IF NOT EXISTS `objects` (
364 `ID` int(11) NOT NULL AUTO_INCREMENT,
365 `Model` int(11) NOT NULL,
366 `X` float NOT NULL,
367 `Y` float NOT NULL,
368 `Z` float NOT NULL,
369 `rX` float NOT NULL,
370 `rY` float NOT NULL,
371 `rZ` float NOT NULL,
372 `Int` int(11) NOT NULL,
373 `vw` int(11) NOT NULL,
374 `e1` int(11) NOT NULL COMMENT 'none, vehicle, player etc',
375 `e2` int(11) NOT NULL COMMENT 'none, vehSQL, plrSQL, etc',
376 PRIMARY KEY (`ID`)
377) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
378
379-- --------------------------------------------------------
380
381--
382-- Sukurta duomenų struktūra lentelei `offmsg`
383--
384
385CREATE TABLE IF NOT EXISTS `offmsg` (
386 `ID` int(11) NOT NULL AUTO_INCREMENT,
387 `Type` int(1) NOT NULL,
388 `GiverID` int(6) NOT NULL,
389 `SenderID` int(6) NOT NULL,
390 `Msg` varchar(120) NOT NULL,
391 `Time` int(11) NOT NULL,
392 PRIMARY KEY (`ID`)
393) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
394
395--
396-- Sukurta duomenų kopija lentelei `offmsg`
397--
398
399INSERT INTO `offmsg` (`ID`, `Type`, `GiverID`, `SenderID`, `Msg`, `Time`) VALUES
400(11, 1, 44, 22, 'storas kelk', 1445798480),
401(12, 1, 44, 22, 'laas', 1445799828);
402
403-- --------------------------------------------------------
404
405--
406-- Sukurta duomenų struktūra lentelei `playeritems`
407--
408
409CREATE TABLE IF NOT EXISTS `playeritems` (
410 `i_ID` int(11) NOT NULL AUTO_INCREMENT,
411 `i_Type` int(1) NOT NULL,
412 `i_Owner` int(11) NOT NULL,
413 `i_ItemID` int(11) NOT NULL,
414 `i_Quantity` int(11) NOT NULL,
415 `i_Price` int(11) NOT NULL,
416 `i_Show` int(1) NOT NULL,
417 `i_Extra0` int(11) NOT NULL,
418 `i_Extra1` int(11) NOT NULL,
419 `i_Extra2` int(11) NOT NULL,
420 `i_Extra3` float NOT NULL,
421 `i_Extra4` int(1) NOT NULL,
422 `i_Weight` float NOT NULL,
423 PRIMARY KEY (`i_ID`)
424) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ;
425
426--
427-- Sukurta duomenų kopija lentelei `playeritems`
428--
429
430INSERT INTO `playeritems` (`i_ID`, `i_Type`, `i_Owner`, `i_ItemID`, `i_Quantity`, `i_Price`, `i_Show`, `i_Extra0`, `i_Extra1`, `i_Extra2`, `i_Extra3`, `i_Extra4`, `i_Weight`) VALUES
431(7, 0, 19, 346, 190, 0, 0, 0, 0, 0, 0, 0, 0),
432(8, 0, 19, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0),
433(9, 5, 1, 346, 436, 0, 0, 0, 0, 0, 0, 0, 0),
434(10, 5, 2, 346, 436, 0, 0, 0, 0, 0, 0, 0, 0),
435(13, 0, 19, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0),
436(14, 0, 24, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0),
437(15, 0, 24, 348, 100, 0, 0, 0, 0, 0, 0, 0, 0),
438(16, 0, 24, 349, 150, 0, 0, 0, 0, 0, 0, 0, 0),
439(17, 0, 24, 357, 100, 0, 0, 0, 0, 0, 0, 0, 0),
440(18, 0, 19, 5, 2, 0, 0, 0, 0, 0, 0, 0, 0),
441(19, 4, 4, 5, 20, 120, 0, 0, 0, 0, 0, 0, 0),
442(20, 3, 1, 6, 0, 5, 0, 0, 0, 0, 0, 0, 0),
443(22, 4, 4, 6, 244, 10, 0, 0, 0, 0, 0, 0, 0),
444(23, 0, 19, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0),
445(24, 0, 19, 7, 2, 0, 0, 0, 0, 100, 9.3, 1, 0),
446(26, 0, 22, 7, 2, 0, 0, 0, 0, 100, 8.6, 1, 0),
447(28, 0, 22, 4, 1, 0, 0, 11, 18, 0, 0, 0, 0),
448(29, 0, 22, 4, 1, 0, 0, 11, 19, 0, 0, 0, 0),
449(78, 2, 30, 2161, 2, 0, 0, 0, 0, 0, 0, 0, 0),
450(79, 2, 30, 1758, 1, 0, 0, 0, 0, 0, 0, 0, 0),
451(80, 2, 30, 1820, 1, 0, 0, 0, 0, 0, 0, 0, 0),
452(81, 2, 30, 1822, 1, 0, 0, 0, 0, 0, 0, 0, 0),
453(82, 0, 19, 1820, 1, 0, 0, 0, 0, 0, 0, 0, 0),
454(83, 7, 19, 1820, 1, 0, 1, 0, 0, 0, 0, 0, 0),
455(84, 7, 19, 1754, 1, 0, 1, 0, 0, 0, 0, 0, 0),
456(85, 7, 22, 2134, 1, 0, 1, 0, 0, 0, 0, 0, 0),
457(86, 7, 22, 2161, 1, 0, 1, 0, 0, 0, 0, 0, 0),
458(87, 0, 22, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0),
459(88, 0, 44, 7, 1, 0, 0, 0, 0, 0, 0, 0, 0),
460(89, 0, 44, 4, 1, 0, 0, 11, 25, 0, 0, 0, 0),
461(90, 0, 22, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0);
462
463-- --------------------------------------------------------
464
465--
466-- Sukurta duomenų struktūra lentelei `players`
467--
468
469CREATE TABLE IF NOT EXISTS `players` (
470 `pID` int(11) NOT NULL AUTO_INCREMENT,
471 `pName` varchar(24) NOT NULL,
472 `pPass` varchar(130) NOT NULL,
473 `pRegTime` int(20) NOT NULL,
474 `pRegIP` varchar(17) NOT NULL,
475 `pLastIP` varchar(17) NOT NULL,
476 `pLastTime` int(20) NOT NULL,
477 `vvpPass` varchar(150) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
478 `vvpActive` varchar(255) NOT NULL,
479 `pEmail` varchar(100) NOT NULL,
480 `pPosX` float NOT NULL,
481 `pPosY` float NOT NULL,
482 `pPosZ` float NOT NULL,
483 `pPosA` float NOT NULL,
484 `pDrabuziai` int(3) NOT NULL,
485 `pMoney` int(11) NOT NULL,
486 `pScore` int(11) NOT NULL,
487 `pAdmin` int(1) NOT NULL,
488 `pAod` int(1) NOT NULL,
489 `pVip` int(1) NOT NULL,
490 `pContract` int(11) NOT NULL,
491 `pJobSkin` int(3) NOT NULL,
492 `pGangID` int(2) NOT NULL,
493 `pGangSkin` int(1) NOT NULL,
494 `pGangSkinID` int(3) NOT NULL,
495 `pGangLead` int(11) NOT NULL,
496 `pJobID` int(2) NOT NULL,
497 `pJobSkinID` int(3) NOT NULL,
498 `pJobLead` int(2) NOT NULL,
499 `pJobDeputy` int(3) NOT NULL,
500 `pInterior` int(4) NOT NULL,
501 `pVW` int(11) NOT NULL,
502 `pBankoSaskaita` int(11) NOT NULL,
503 `pBMoney` int(11) NOT NULL,
504 `pRangas` int(2) NOT NULL,
505 `pGRangas` int(11) NOT NULL,
506 `pWanted` int(5) NOT NULL,
507 `pBauda` int(11) NOT NULL,
508 `pJailed` int(1) NOT NULL,
509 `pCuff` int(1) NOT NULL,
510 `pLevel` int(11) NOT NULL,
511 `pMask` int(1) NOT NULL,
512 `pOnline` int(1) NOT NULL,
513 `pGender` int(1) NOT NULL,
514 `pApmokymuStep` int(3) NOT NULL,
515 `pGuns` varchar(100) NOT NULL,
516 `pGunLic` int(1) NOT NULL,
517 `pCanLogin` int(11) NOT NULL,
518 `pCanLoginReason` varchar(50) NOT NULL,
519 `pCanLoginType` int(1) NOT NULL,
520 `pLastRaceTime` int(11) NOT NULL,
521 `pTimeSpent` int(11) NOT NULL,
522 `pAlga` int(11) NOT NULL,
523 `pMuted` int(11) NOT NULL,
524 `pDead` int(1) NOT NULL,
525 `pDviratis` int(1) NOT NULL,
526 `pDviratisX` float NOT NULL,
527 `pDviratisY` float NOT NULL,
528 `pDviratisZ` float NOT NULL,
529 `pSettings` varchar(20) NOT NULL,
530 `pLastTimeTakeGun` int(11) NOT NULL,
531 `pLastTimeEgun` int(11) NOT NULL,
532 `pNamuose` int(11) NOT NULL,
533 PRIMARY KEY (`pID`)
534) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;
535
536--
537-- Sukurta duomenų kopija lentelei `players`
538--
539
540INSERT INTO `players` (`pID`, `pName`, `pPass`, `pRegTime`, `pRegIP`, `pLastIP`, `pLastTime`, `vvpPass`, `vvpActive`, `pEmail`, `pPosX`, `pPosY`, `pPosZ`, `pPosA`, `pDrabuziai`, `pMoney`, `pScore`, `pAdmin`, `pAod`, `pVip`, `pContract`, `pJobSkin`, `pGangID`, `pGangSkin`, `pGangSkinID`, `pGangLead`, `pJobID`, `pJobSkinID`, `pJobLead`, `pJobDeputy`, `pInterior`, `pVW`, `pBankoSaskaita`, `pBMoney`, `pRangas`, `pGRangas`, `pWanted`, `pBauda`, `pJailed`, `pCuff`, `pLevel`, `pMask`, `pOnline`, `pGender`, `pApmokymuStep`, `pGuns`, `pGunLic`, `pCanLogin`, `pCanLoginReason`, `pCanLoginType`, `pLastRaceTime`, `pTimeSpent`, `pAlga`, `pMuted`, `pDead`, `pDviratis`, `pDviratisX`, `pDviratisY`, `pDviratisZ`, `pSettings`, `pLastTimeTakeGun`, `pLastTimeEgun`, `pNamuose`) VALUES
541(1, 'Serveris', '', 0, '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
542(19, 'The_Yaw', 'asdasd', 0, '', '', 1444594747, '', '', 'dovy.buz@gmail.com', 1032.43, -1541.9, 13.203, 359.361, 7, 123505, 2756, 2, 1, 1, 1441980357, 1, 2, 0, 0, 2, 1, 300, 2, 0, 0, 0, 1, 10010, 0, 3, 0, 150, -1, 0, 16, 1, 1, 0, 5, '0 0 0 0 22 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 1, 5, 'atsibodo tavæs laukti', 1, 1443507051, 99169, 0, 0, 0, 0, 0, 0, 0, '1 1 0', 0, 0, 0),
543(22, 'Marius_Joker', 'asd123', 0, '', '', 1445801665, '', '', 'asgaidys@gmail.com', 2364.82, -1659.38, 13.383, 90.054, 7, 142402, 5481, 2, 1, 1, 1443440897, 1, 1, 0, 0, 1, 2, 158, 0, 0, 0, 0, 0, 20100, 0, 3, 0, 0, -841, 0, 51, 1, 0, 0, 5, '20 20 0 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 1, 0, '', 0, 1437629393, 20708, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0),
544(23, 'Krw_Atudurns', 'geraigerai', 0, '', '', 1437859285, '', '', 'getmauil@inbox.lt', 1532.37, -1688.19, 13.383, 1.726, 20, -55, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 1270, 0, 0, 0, 1, 1535.54, -1695.12, 13.136, '0 0', 0, 0, 0),
545(24, 'Petras_Antanaitis', 'asd123', 0, '', '', 1440342447, '', '', 'asd@gmail.com', 2305.84, -1732.07, 13.383, 212.655, 7, 140999, 30, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 1235, 0, 0, 0, 0, 0, 0, 0, '0 0 0', 0, 0, 0),
546(25, 'Kazkoka_Gryba', '123456', 0, '', '', 0, '', '', 'rar@gmail.com', 1538.78, -1665.98, 13.5469, 87.446, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
547(26, 'Snukin_Nori', 'vienas', 0, '', '', 0, '', '', 'vienas@gmail.com', 1538.78, -1665.98, 13.5469, 87.446, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
548(27, 'Paul_Hoffman', 'kkkkkkk', 0, '', '', 0, '', '', 'rekrekrek@gmail.com', 1538.78, -1665.98, 13.5469, 87.446, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 90, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
549(28, 'Hoffman_Jokerlop', 'pisusnukin', 0, '', '', 0, '', '', 'asdasd@gmail.com', 1538.78, -1665.98, 13.5469, 87.446, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
550(29, 'Quit_Buiqt', 'kkkkkkk', 0, '', '', 0, '', '', 'rekek@gmail.com', 1538.78, -1665.98, 13.5469, 87.446, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
551(30, 'Paul_Hoffmans', 'jojojo', 0, '', '', 0, '', '', 'rimtciukas@gmail.com', 1538.78, -1665.98, 13.5469, 87.446, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
552(31, 'Naujokas', 'asdasd', 0, '', '', 0, '', '', 'dovy.buz@gmail.com', 1538.78, -1665.98, 13.5469, 87.446, 56, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
553(32, 'Register', 'asdasd', 0, '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
554(33, 'asdasd', 'tavomama', 0, '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
555(34, 'tavomama', 'asdasd', 0, '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
556(35, 'tavo_motina', 'asdasd', 0, '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
557(36, 'konori', 'tavomama', 0, '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
558(37, 'TavoMotina', 'tavomama', 0, '', '', 1440341198, '', '', '', 1539.9, -1654.9, 13.55, 172.361, 20, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 77, 0, 0, 0, 1, 0, 0, 0, '0 0 0', 0, 0, 0),
559(38, 'Serveris', '', 0, '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
560(39, 'noob', 'asdasd', 0, '', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
561(40, 'noob2', 'asdasd', 0, '', '', 0, '', '', '', 1538.78, -1665.98, 13.5469, 87.446, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
562(41, 'noob3', 'lollol', 0, '', '', 0, '', '', '', 1538.78, -1665.98, 13.5469, 87.446, 93, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
563(42, 'noob4', 'asdasd', 0, '', '', 0, '', '', '', 1538.78, -1665.98, 13.5469, 87.446, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0),
564(43, 'noob6', 'asdasd', 0, '', '', 1444663960, '', '', '', 1539.2, -1638.99, 13.982, 0.617, 20, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 84, 0, 0, 0, 1, 1549.73, -1677.23, 14.771, '0 0 0', 0, 0, 0),
565(44, 'noob8', 'tavomama', 0, '', '', 1445801650, '', '', '', 2445.62, -1658.67, 13.305, 102.837, 93, 2372, 380, 2, 1, 1, 0, 0, 0, 0, 0, 0, 1, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 20708, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0);
566
567-- --------------------------------------------------------
568
569--
570-- Sukurta duomenų struktūra lentelei `rangai`
571--
572
573CREATE TABLE IF NOT EXISTS `rangai` (
574 `rang_ID` int(5) NOT NULL AUTO_INCREMENT,
575 `rang_Name` varchar(50) NOT NULL,
576 `rang_IDinJob` int(5) NOT NULL,
577 `rang_JobID` int(5) NOT NULL,
578 `rang_SkinVID` int(3) NOT NULL,
579 `rang_SkinMID` int(3) NOT NULL,
580 PRIMARY KEY (`rang_ID`)
581) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
582
583--
584-- Sukurta duomenų kopija lentelei `rangai`
585--
586
587INSERT INTO `rangai` (`rang_ID`, `rang_Name`, `rang_IDinJob`, `rang_JobID`, `rang_SkinVID`, `rang_SkinMID`) VALUES
588(1, 'Eilinis', 0, 1, 300, 306),
589(2, 'Serþantas', 1, 1, 301, 307),
590(3, 'Leitenantas', 2, 1, 310, 309),
591(4, 'Ãerifas', 4, 1, 283, 246),
592(6, 'Noobas', 0, 22, 55, 55),
593(7, 'lenkas', 1, 21, 90, 50),
594(8, 'didis lenkas', 2, 21, 0, 0),
595(9, 'paprastas', 0, 3, 142, 194),
596(10, 'Kareivis', 0, 2, 158, 45),
597(11, 'penktas', 3, 21, 50, 90);
598
599-- --------------------------------------------------------
600
601--
602-- Sukurta duomenų struktūra lentelei `vehicles`
603--
604
605CREATE TABLE IF NOT EXISTS `vehicles` (
606 `vID` int(11) NOT NULL AUTO_INCREMENT,
607 `vOwnerType` int(1) NOT NULL,
608 `vOwnerID` int(11) NOT NULL,
609 `vModel` int(3) NOT NULL,
610 `vPosX` float NOT NULL,
611 `vPosY` float NOT NULL,
612 `vPosZ` float NOT NULL,
613 `vPosA` float NOT NULL,
614 `vHealth` float NOT NULL,
615 `vFuel` float NOT NULL,
616 `vFuelType` int(1) NOT NULL,
617 `vRida` float NOT NULL,
618 `vEngine` int(1) NOT NULL,
619 `vLights` int(1) NOT NULL,
620 `vAlarm` int(1) NOT NULL,
621 `vBonnet` int(1) NOT NULL,
622 `vBoot` int(1) NOT NULL,
623 `vObjective` int(1) NOT NULL,
624 `vLocked` int(1) NOT NULL,
625 `vColor1` int(3) NOT NULL,
626 `vColor2` int(3) NOT NULL,
627 `vPaintjob` int(1) NOT NULL,
628 `vMods` varchar(70) NOT NULL,
629 `vRangas` int(5) NOT NULL,
630 `vPanelsDamage` int(11) NOT NULL,
631 `vDoorsDamage` int(11) NOT NULL,
632 `vLightsDamage` int(11) NOT NULL,
633 `vTiresDamage` int(11) NOT NULL,
634 `vUp_Speed` float NOT NULL,
635 `vUp_Brake` float NOT NULL,
636 PRIMARY KEY (`vID`)
637) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
638
639--
640-- Sukurta duomenų kopija lentelei `vehicles`
641--
642
643INSERT INTO `vehicles` (`vID`, `vOwnerType`, `vOwnerID`, `vModel`, `vPosX`, `vPosY`, `vPosZ`, `vPosA`, `vHealth`, `vFuel`, `vFuelType`, `vRida`, `vEngine`, `vLights`, `vAlarm`, `vBonnet`, `vBoot`, `vObjective`, `vLocked`, `vColor1`, `vColor2`, `vPaintjob`, `vMods`, `vRangas`, `vPanelsDamage`, `vDoorsDamage`, `vLightsDamage`, `vTiresDamage`, `vUp_Speed`, `vUp_Brake`) VALUES
644(1, 0, 3, 420, 1777.81, -1896.9, 13.189, -89.94, 1000, 107, 0, 0, 0, 0, 0, 0, 0, 0, 1, 6, 6, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
645(2, 0, 3, 420, 1777.86, -1902.18, 13.189, -89.94, 1000, 107, 0, 0, 0, 0, 0, 0, 0, 0, 1, 6, 6, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
646(3, 0, 3, 420, 1777.83, -1907.25, 13.189, -89.94, 1000, 107, 0, 0.001, 1, 0, 0, 0, 0, 0, 1, 6, 6, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
647(4, 0, 3, 420, 1778.05, -1912.2, 13.189, -89.94, 536.218, 87.192, 0, 65.187, 1, 1, 0, 0, 0, 0, 0, 6, 6, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
648(5, 0, 3, 420, 1778.08, -1917.1, 13.189, -89.94, 1000, 107, 0, 0, 0, 0, 0, 0, 0, 0, 1, 6, 6, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
649(6, 0, 3, 420, 1778.08, -1922.12, 13.189, -89.94, 1000, 107, 0, 0, 0, 0, 0, 0, 0, 0, 1, 6, 6, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
650(7, 0, 1, 596, 1547.9, -1613.8, 13.183, 0, 1000, 122, 0, 0.041, 0, 0, 0, 0, 0, 0, 1, 16, 1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
651(8, 0, 1, 596, 1554.19, -1613.96, 13.183, 0, 1000, 88.727, 0, 31.436, 1, 0, 0, 0, 0, 0, 1, 16, 1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 4, 0, 0, 0, 0, 0, 0),
652(9, 0, 1, 596, 1560.89, -1613.98, 13.183, 0, 1000, 108.89, 0, 12.95, 1, 0, 0, 0, 0, 0, 0, 16, 1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0.012, 0),
653(10, 0, 1, 596, 1568.21, -1613.98, 13.183, 0, 1000, 120.21, 0, 3.161, 1, 0, 0, 0, 0, 0, 0, 16, 1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
654(11, 0, 1, 596, 1578.28, -1605.91, 13.183, -182.94, 1000, 122, 0, 0.022, 0, 0, 0, 0, 0, 0, 1, 16, 1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 4, 0, 0, 0, 0, 0, 0),
655(12, 0, 1, 599, 1590.02, -1622.74, 13.781, 89.82, 1000, 118.76, 0, 2.647, 0, 0, 0, 0, 0, 0, 0, 16, 1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
656(13, 0, 1, 599, 1591.7, -1614.31, 13.781, 88.62, 1000, 95.105, 0, 21.287, 1, 0, 0, 0, 0, 0, 1, 16, 1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0.006, 0),
657(14, 0, 4, 416, 2012.22, -1414.81, 17.418, 95.5, 880, 90.03, 0, 30.665, 1, 1, 0, 0, 0, 0, 0, 1, 3, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
658(15, 0, 4, 416, 2032.6, -1437.17, 17.418, 176.86, 1000, 110.07, 0, 10.086, 1, 0, 0, 0, 0, 0, 1, 1, 3, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
659(17, 0, 1, 405, 1592.78, -1607.48, 13.267, 88.227, 1000, 0, 0, 0.0002222, 0, 0, 0, 0, 0, 0, 1, -1, -1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
660(20, 0, 1, 445, 2305.7, -2000.91, 13.378, 271.56, 1000, 150.1, 0, 3.01, 1, 0, 0, 0, 0, 0, 0, -1, -1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
661(25, 0, 2, 514, 2735.94, -2482.72, 14.215, -179.16, 1000, 150, 0, 0, 0, 0, 0, 0, 0, 0, 1, -1, -1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
662(26, 0, 2, 514, 2766.14, -2533.93, 14.215, -179.16, 1000, 150, 0, 0.939, 1, 0, 0, 0, 0, 0, 0, -1, -1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
663(27, 0, 2, 514, 2765.08, -2386.8, 14.215, -179.16, 982.946, 140.1, 0, 7.435, 1, 0, 0, 0, 0, 0, 0, -1, -1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
664(28, 0, 2, 514, 2744.93, -2445.07, 14.215, -91.92, 1000, 150, 0, 0, 0, 0, 0, 0, 0, 0, 1, -1, -1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
665(29, 0, 2, 514, 2745.8, -2460.44, 14.215, -91.92, 980.477, 102.571, 0, 19.124, 1, 1, 0, 0, 0, 0, 0, -1, -1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0),
666(30, 1, 19, 589, 1032.43, -1541.9, 13.203, 177.391, 1000, 54.87, 0, 35.358, 1, 1, 0, 0, 0, 0, 1, -1, -1, 0, '0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, 0, 0, 0, 0, 0);
667
668/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
669/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
670/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;