API tools faq
paste
Advertisement
Guest User

gm.sql

a guest
Apr 6th, 2017
986
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 33.54 KB | None | 0 0
raw download clone embed print report
  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.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET 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.  
  29. CREATE 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.  
  41. INSERT 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.  
  51. CREATE 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.  
  77. INSERT 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.  
  88. CREATE 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.  
  104. INSERT 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.  
  114. CREATE 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.  
  131. INSERT 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.  
  141. CREATE 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.  
  155. INSERT 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.  
  175. CREATE 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.  
  189. INSERT 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.  
  257. CREATE 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.  
  281. INSERT 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.  
  325. CREATE 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.  
  343. INSERT 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.  
  363. CREATE 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.  
  385. CREATE 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.  
  399. INSERT 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.  
  409. CREATE 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.  
  430. INSERT 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.  
  469. CREATE 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.  
  540. INSERT 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.  
  573. CREATE 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.  
  587. INSERT 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.  
  605. CREATE 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.  
  643. INSERT 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!