API tools faq
paste
Advertisement
Guest User

lsplay.sql

a guest
Apr 6th, 2017
2,057
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 35.57 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:47
  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: `lsplay`
  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=1 ;
  36.  
  37. -- --------------------------------------------------------
  38.  
  39. --
  40. -- Sukurta duomenų struktūra lentelei `business`
  41. --
  42.  
  43. CREATE TABLE IF NOT EXISTS `business` (
  44.   `bID` int(11) NOT NULL AUTO_INCREMENT,
  45.   `bOwnerID` int(11) NOT NULL,
  46.   `bName` varchar(50) NOT NULL,
  47.   `bPosX` float NOT NULL,
  48.   `bPosY` float NOT NULL,
  49.   `bPosZ` float NOT NULL,
  50.   `bcInterior` int(5) NOT NULL,
  51.   `bcPosX` float NOT NULL,
  52.   `bcPosY` float NOT NULL,
  53.   `bcPosZ` float NOT NULL,
  54.   `bkPosX` float NOT NULL,
  55.   `bkPosY` float NOT NULL,
  56.   `bkPosZ` float NOT NULL,
  57.   `bIsBuyable` int(1) NOT NULL,
  58.   `bPrice` int(11) NOT NULL,
  59.   `bType` int(1) NOT NULL,
  60.   `bExtra0` int(11) NOT NULL,
  61.   `bEarnings` int(11) NOT NULL,
  62.   PRIMARY KEY (`bID`)
  63. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
  64.  
  65. --
  66. -- Sukurta duomenų kopija lentelei `business`
  67. --
  68.  
  69. INSERT INTO `business` (`bID`, `bOwnerID`, `bName`, `bPosX`, `bPosY`, `bPosZ`, `bcInterior`, `bcPosX`, `bcPosY`, `bcPosZ`, `bkPosX`, `bkPosY`, `bkPosZ`, `bIsBuyable`, `bPrice`, `bType`, `bExtra0`, `bEarnings`) VALUES
  70. (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),
  71. (5, -1, 'be pavadinimo', 1194.22, -917.189, 43.164, 0, 0, 0, 0, 0, 0, 0, 1, 2500000, 0, 0, 0),
  72. (6, 1, 'Baldyla', 1115.54, -1371.03, 13.991, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 0, 0),
  73. (7, 53, 'Gintarinë vaistinë', 2249.86, 52.814, 26.667, 0, 2254.9, 45.893, 26.336, 2245.59, 49.435, 26.484, 0, 100000, 4, 0, 0);
  74.  
  75. -- --------------------------------------------------------
  76.  
  77. --
  78. -- Sukurta duomenų struktūra lentelei `gangs`
  79. --
  80.  
  81. CREATE TABLE IF NOT EXISTS `gangs` (
  82.   `gangID` int(11) NOT NULL AUTO_INCREMENT,
  83.   `gangName` varchar(30) NOT NULL,
  84.   `gangLeadID` int(11) NOT NULL,
  85.   `gangRep` int(11) NOT NULL,
  86.   `gangColor` int(11) NOT NULL,
  87.   `gangX` float NOT NULL,
  88.   `gangY` float NOT NULL,
  89.   `gangZ` float NOT NULL,
  90.   PRIMARY KEY (`gangID`)
  91. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  92.  
  93. --
  94. -- Sukurta duomenų kopija lentelei `gangs`
  95. --
  96.  
  97. INSERT INTO `gangs` (`gangID`, `gangName`, `gangLeadID`, `gangRep`, `gangColor`, `gangX`, `gangY`, `gangZ`) VALUES
  98. (1, 'ðuo', 22, 15, 0, 2492.17, -1692.1, 14.7656),
  99. (2, 'Pakaraka', 14, 9000, 0, 1967.54, -1176.65, 20.0307);
  100.  
  101. -- --------------------------------------------------------
  102.  
  103. --
  104. -- Sukurta duomenų struktūra lentelei `garages`
  105. --
  106.  
  107. CREATE TABLE IF NOT EXISTS `garages` (
  108.   `gID` int(11) NOT NULL AUTO_INCREMENT,
  109.   `gOwnerID` int(11) NOT NULL,
  110.   `gPrice` int(11) NOT NULL,
  111.   `gGalioja` int(11) NOT NULL,
  112.   `gBuyable` int(1) NOT NULL,
  113.   `gPosX` float NOT NULL,
  114.   `gPosY` float NOT NULL,
  115.   `gPosZ` float NOT NULL,
  116.   `gVartaiID` int(4) NOT NULL,
  117.   PRIMARY KEY (`gID`)
  118. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  119.  
  120. -- --------------------------------------------------------
  121.  
  122. --
  123. -- Sukurta duomenų struktūra lentelei `gps`
  124. --
  125.  
  126. CREATE TABLE IF NOT EXISTS `gps` (
  127.   `gpsID` int(11) NOT NULL AUTO_INCREMENT,
  128.   `gpsName` varchar(40) NOT NULL,
  129.   `gpsX` float NOT NULL,
  130.   `gpsY` float NOT NULL,
  131.   `gpsZ` float NOT NULL,
  132.   `gpsType` int(2) NOT NULL,
  133.   `gpsMap` varchar(3) NOT NULL,
  134.   PRIMARY KEY (`gpsID`)
  135. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
  136.  
  137. --
  138. -- Sukurta duomenų kopija lentelei `gps`
  139. --
  140.  
  141. INSERT INTO `gps` (`gpsID`, `gpsName`, `gpsX`, `gpsY`, `gpsZ`, `gpsType`, `gpsMap`) VALUES
  142. (6, 'LS - Transporto turgus', 2267.85, -1974.65, 13.362, 2, 'ls'),
  143. (9, 'LS - Degalinë', 1941.88, -1759.77, 13.14, 2, 'ls'),
  144. (10, 'LS - Policija', 1530.44, -1675.22, 13.383, 0, 'ls'),
  145. (11, 'LS - Ligoninë', 1996, -1452.45, 13.325, 2, 'ls'),
  146. (12, 'LS - Bankas', 1722.14, -1292.76, 13.547, 2, 'ls'),
  147. (13, 'LS - Tune', 1040.53, -1032.42, 31.997, 2, 'ls'),
  148. (14, 'LS - Oro uostas', 1923.74, -2409.43, 13.197, 2, 'ls'),
  149. (15, 'SF - Tune (WAA)', -2690.47, 210.164, 4.328, 2, 'sf'),
  150. (16, 'LS - Fûristai', 2760.57, -2459.21, 13.56, 0, 'ls'),
  151. (17, 'LS - Taksi', 1814.12, -1871.19, 13.57, 0, 'ls'),
  152. (18, 'Atsiradimo vieta', 634.72, -1451.06, 14.183, 2, 'ls'),
  153. (19, 'LS - 2 Ligoninë', 1200.97, -1327.59, 13.398, 2, 'ls'),
  154. (20, 'LS - Autoservisas', 1667.19, -1826.79, 13.554, 0, 'ls'),
  155. (21, 'LS - Taksi', 2480.65, -1739.54, 13.547, 0, 'ls'),
  156. (22, 'Degalø gamykla', 2483.94, -2111.03, 13.5469, 5, 'ls'),
  157. (23, 'testinglel 2', 1820.66, -1308.36, 131.734, 2, 'ls'),
  158. (24, 'PC - Bankas', 2301.29, -6.81, 26.484, 2, 'km'),
  159. (25, 'VM', 681.914, -638.983, 16.188, 2, 'km'),
  160. (26, 'Dillimore degalinë', 699.959, -565.85, 16.329, 3, 'km');
  161.  
  162. -- --------------------------------------------------------
  163.  
  164. --
  165. -- Sukurta duomenų struktūra lentelei `gzones`
  166. --
  167.  
  168. CREATE TABLE IF NOT EXISTS `gzones` (
  169.   `gID` int(2) NOT NULL AUTO_INCREMENT,
  170.   `gminX` float NOT NULL,
  171.   `gminY` float NOT NULL,
  172.   `gmaxX` float NOT NULL,
  173.   `gmaxY` float NOT NULL,
  174.   `gOwners` int(11) NOT NULL,
  175.   PRIMARY KEY (`gID`)
  176. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  177.  
  178. -- --------------------------------------------------------
  179.  
  180. --
  181. -- Sukurta duomenų struktūra lentelei `houses`
  182. --
  183.  
  184. CREATE TABLE IF NOT EXISTS `houses` (
  185.   `hID` int(11) NOT NULL AUTO_INCREMENT,
  186.   `hOwnerID` int(11) NOT NULL,
  187.   `hLocked` int(1) NOT NULL,
  188.   `hInterior` int(11) NOT NULL,
  189.   `hIsBuyable` int(1) NOT NULL,
  190.   `hoPosX` float NOT NULL,
  191.   `hoPosY` float NOT NULL,
  192.   `hoPosZ` float NOT NULL,
  193.   `hiPosX` float NOT NULL,
  194.   `hiPosY` float NOT NULL,
  195.   `hiPosZ` float NOT NULL,
  196.   `hPrice` int(11) NOT NULL,
  197.   `hAlarm` int(2) NOT NULL,
  198.   `hCamera` int(2) NOT NULL,
  199.   `hDoors` int(2) NOT NULL,
  200.   `hIntUpgrade` int(11) NOT NULL,
  201.   `hSignalizacija` int(2) NOT NULL,
  202.   `hStreet` varchar(30) NOT NULL,
  203.   `hNumber` int(11) NOT NULL,
  204.   `hMap` varchar(3) NOT NULL,
  205.   PRIMARY KEY (`hID`)
  206. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=132 ;
  207.  
  208. --
  209. -- Sukurta duomenų kopija lentelei `houses`
  210. --
  211.  
  212. INSERT INTO `houses` (`hID`, `hOwnerID`, `hLocked`, `hInterior`, `hIsBuyable`, `hoPosX`, `hoPosY`, `hoPosZ`, `hiPosX`, `hiPosY`, `hiPosZ`, `hPrice`, `hAlarm`, `hCamera`, `hDoors`, `hIntUpgrade`, `hSignalizacija`, `hStreet`, `hNumber`, `hMap`) VALUES
  213. (4, -1, 1, 0, 1, 2459.48, -1691.06, 13.545, 0, 0, 0, 564521, 0, 0, 0, 0, 0, 'Jotvingiø', 1, 'ls'),
  214. (5, -1, 1, 0, 1, 2514.17, -1691.61, 14.046, 0, 0, 0, 458642, 0, 0, 0, 0, 0, 'Jotvingiø', 2, 'ls'),
  215. (6, -1, 1, 0, 1, 2523.27, -1679.4, 15.497, 0, 0, 0, 581976, 0, 0, 0, 0, 0, 'Jotvingiø', 3, 'ls'),
  216. (7, -1, 1, 0, 1, 2524.71, -1658.75, 15.824, 0, 0, 0, 488514, 0, 0, 0, 0, 0, 'Jotvingiø', 4, 'ls'),
  217. (8, 15, 1, 0, 0, 2513.75, -1650.28, 14.356, 0, 0, 0, 487355, 0, 0, 0, 0, 0, 'Jotvingiø', 5, 'ls'),
  218. (9, -1, 1, 0, 1, 2498.45, -1642.64, 13.783, 0, 0, 0, 423165, 0, 0, 0, 0, 0, 'Jotvingiø', 6, 'ls'),
  219. (10, -1, 1, 0, 1, 2486.48, -1644.54, 14.077, 0, 0, 0, 581584, 0, 0, 0, 0, 0, 'Jotvingiø', 7, 'ls'),
  220. (11, -1, 1, 0, 1, 2469.54, -1646.35, 13.78, 0, 0, 0, 465497, 0, 0, 0, 0, 0, 'Jotvingiø', 8, 'ls'),
  221. (12, -1, 1, 0, 1, 2451.9, -1641.41, 14.066, 0, 0, 0, 456479, 0, 0, 0, 0, 0, 'Jotvingiø', 9, 'ls'),
  222. (13, -1, 1, 0, 1, 2413.84, -1646.79, 14.012, 0, 0, 0, 473345, 0, 0, 0, 0, 0, 'Jotvingiø', 10, 'ls'),
  223. (14, -1, 1, 0, 1, 2409.02, -1674.87, 14.375, 0, 0, 0, 473345, 0, 0, 0, 0, 0, 'Jotvingiø', 11, 'ls'),
  224. (15, -1, 1, 0, 1, 2384.64, -1675.84, 15.246, 0, 0, 0, 508269, 0, 0, 0, 0, 0, 'Jotvingiø', 13, 'ls'),
  225. (16, 15, 1, 0, 0, 2368.27, -1675.16, 14.168, 0, 0, 0, 532798, 0, 0, 0, 0, 0, 'Jotvingiø', 15, 'ls'),
  226. (17, -1, 1, 0, 1, 2393.32, -1646.04, 13.905, 0, 0, 0, 532798, 0, 0, 0, 0, 0, 'Jotvingiø', 12, 'ls'),
  227. (18, -1, 1, 0, 1, 2362.79, -1643.24, 14.352, 0, 0, 0, 467608, 0, 0, 0, 0, 0, 'Jotvingiø', 14, 'ls'),
  228. (19, -1, 1, 0, 1, 2327.08, -1681.87, 14.93, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Jotvingiø', 16, 'ls'),
  229. (20, -1, 1, 0, 1, 2385.52, -1711.8, 14.242, 0, 0, 0, 545768, 0, 0, 0, 0, 0, 'Jotvingiø', 17, 'ls'),
  230. (21, -1, 1, 0, 1, 2522.46, -2018.92, 14.074, 0, 0, 0, 545768, 0, 0, 0, 0, 0, 'Laisvës', 1, 'ls'),
  231. (22, -1, 1, 0, 1, 2524.33, -1998.28, 14.113, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Laisvës', 2, 'ls'),
  232. (23, -1, 1, 0, 1, 2507.79, -2021.05, 14.21, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Laisvës', 3, 'ls'),
  233. (24, -1, 1, 0, 1, 2508.21, -1998.53, 13.903, 0, 0, 0, 504782, 0, 0, 0, 0, 0, 'Laisvës', 4, 'ls'),
  234. (25, -1, 1, 0, 1, 2486.45, -2021.55, 13.999, 0, 0, 0, 544660, 0, 0, 0, 0, 0, 'Laisvës', 5, 'ls'),
  235. (26, -1, 1, 0, 1, 2465.4, -2020.79, 14.124, 0, 0, 0, 464064, 0, 0, 0, 0, 0, 'Laisvës', 7, 'ls'),
  236. (27, -1, 1, 0, 1, 2437.92, -2020.84, 13.903, 0, 0, 0, 505413, 0, 0, 0, 0, 0, 'Laisvës', 9, 'ls'),
  237. (28, -1, 1, 0, 1, 2483.59, -1995.54, 13.834, 0, 0, 0, 540262, 0, 0, 0, 0, 0, 'Laisvës', 6, 'ls'),
  238. (29, 25, 1, 0, 0, 2465.02, -1995.75, 14.019, 0, 0, 0, 502568, 0, 0, 0, 0, 0, 'Laisvës', 8, 'ls'),
  239. (30, -1, 1, 0, 1, 2637.16, -1991.63, 14.324, 0, 0, 0, 466013, 0, 0, 0, 0, 0, 'Naujakuriø', 1, 'ls'),
  240. (31, -1, 1, 0, 1, 2635.51, -2012.77, 14.144, 0, 0, 0, 512437, 0, 0, 0, 0, 0, 'Naujakuriø', 2, 'ls'),
  241. (32, -1, 1, 0, 1, 2652.77, -1989.45, 13.999, 0, 0, 0, 519659, 0, 0, 0, 0, 0, 'Naujakuriø', 3, 'ls'),
  242. (33, -1, 1, 0, 1, 2672.8, -1989.47, 14.324, 0, 0, 0, 502551, 0, 0, 0, 0, 0, 'Naujakuriø', 5, 'ls'),
  243. (34, -1, 1, 0, 1, 2696.55, -1990.5, 14.223, 0, 0, 0, 497790, 0, 0, 0, 0, 0, 'Naujakuriø', 7, 'ls'),
  244. (35, -1, 1, 0, 1, 2650.7, -2021.92, 14.177, 0, 0, 0, 544213, 0, 0, 0, 0, 0, 'Naujakuriø', 4, 'ls'),
  245. (36, -1, 1, 0, 1, 2673.33, -2020.29, 14.168, 0, 0, 0, 504611, 0, 0, 0, 0, 0, 'Naujakuriø', 6, 'ls'),
  246. (37, -1, 1, 0, 1, 2695.41, -2020.55, 14.022, 0, 0, 0, 508801, 0, 0, 0, 0, 0, 'Naujakuriø', 8, 'ls'),
  247. (38, -1, 1, 0, 1, 315.949, -1769.61, 4.628, 0, 0, 0, 630541, 0, 0, 0, 0, 0, 'Uosto', 1, 'ls'),
  248. (39, -1, 1, 0, 1, 305.424, -1770.26, 4.538, 0, 0, 0, 684645, 0, 0, 0, 0, 0, 'Uosto', 2, 'ls'),
  249. (40, -1, 1, 0, 1, 295.241, -1764.12, 4.868, 0, 0, 0, 615744, 0, 0, 0, 0, 0, 'Uosto', 3, 'ls'),
  250. (41, -1, 1, 0, 1, 280.874, -1767.28, 4.551, 0, 0, 0, 676548, 0, 0, 0, 0, 0, 'Uosto', 4, 'ls'),
  251. (42, -1, 1, 0, 1, 206.794, -1768.9, 4.368, 0, 0, 0, 671021, 0, 0, 0, 0, 0, 'Uosto', 5, 'ls'),
  252. (43, -1, 1, 0, 1, 192.783, -1769.39, 4.329, 0, 0, 0, 675288, 0, 0, 0, 0, 0, 'Uosto', 6, 'ls'),
  253. (44, -1, 1, 0, 1, 168.306, -1768.41, 4.487, 0, 0, 0, 634214, 0, 0, 0, 0, 0, 'Uosto', 7, 'ls'),
  254. (45, -1, 1, 0, 1, 653.594, -1713.88, 14.765, 0, 0, 0, 542231, 0, 0, 0, 0, 0, 'Þvejø', 1, 'ls'),
  255. (46, -1, 1, 0, 1, 652.666, -1693.97, 14.55, 0, 0, 0, 487059, 0, 0, 0, 0, 0, 'Þvejø', 2, 'ls'),
  256. (47, -1, 1, 0, 1, 693.545, -1705.72, 3.819, 0, 0, 0, 486809, 0, 0, 0, 0, 0, 'Þvejø', 3, 'ls'),
  257. (48, -1, 1, 0, 1, 694.883, -1690.73, 4.346, 0, 0, 0, 455158, 0, 0, 0, 0, 0, 'Þvejø', 4, 'ls'),
  258. (49, -1, 1, 0, 1, 693.758, -1645.88, 4.094, 0, 0, 0, 539935, 0, 0, 0, 0, 0, 'Þvejø', 5, 'ls'),
  259. (50, -1, 1, 0, 1, 697.28, -1626.96, 3.749, 0, 0, 0, 487434, 0, 0, 0, 0, 0, 'Þvejø', 6, 'ls'),
  260. (51, -1, 1, 0, 1, 657.226, -1652.67, 15.406, 0, 0, 0, 508370, 0, 0, 0, 0, 0, 'Þvejø', 7, 'ls'),
  261. (52, -1, 1, 0, 1, 656.089, -1635.87, 15.862, 0, 0, 0, 500724, 0, 0, 0, 0, 0, 'Þvejø', 8, 'ls'),
  262. (53, -1, 1, 0, 1, 653.112, -1619.83, 15, 0, 0, 0, 495916, 0, 0, 0, 0, 0, 'Þvejø', 9, 'ls'),
  263. (54, -1, 1, 0, 1, 692.981, -1602.77, 15.047, 0, 0, 0, 483939, 0, 0, 0, 0, 0, 'Þvejø', 10, 'ls'),
  264. (55, -1, 1, 0, 1, 766.923, -1605.88, 13.804, 0, 0, 0, 469979, 0, 0, 0, 0, 0, 'Þvejø', 11, 'ls'),
  265. (56, -1, 1, 0, 1, 768.08, -1655.86, 5.609, 0, 0, 0, 538002, 0, 0, 0, 0, 0, 'Þvejø', 12, 'ls'),
  266. (57, -1, 1, 0, 1, 769.229, -1696.62, 5.155, 0, 0, 0, 536814, 0, 0, 0, 0, 0, 'Þvejø', 13, 'ls'),
  267. (58, -1, 1, 0, 1, 769.029, -1726.23, 13.432, 0, 0, 0, 472360, 0, 0, 0, 0, 0, 'Þvejø', 14, 'ls'),
  268. (59, -1, 1, 0, 1, 769.227, -1746.04, 13.077, 0, 0, 0, 483150, 0, 0, 0, 0, 0, 'Þvejø', 15, 'ls'),
  269. (60, -1, 1, 0, 1, 791.449, -1753.37, 13.457, 0, 0, 0, 509271, 0, 0, 0, 0, 0, 'Þvejø', 16, 'ls'),
  270. (61, -1, 1, 0, 1, 797.234, -1729.11, 13.547, 0, 0, 0, 538391, 0, 0, 0, 0, 0, 'Þvejø', 17, 'ls'),
  271. (62, -1, 1, 0, 1, 793.979, -1707.56, 14.038, 0, 0, 0, 527762, 0, 0, 0, 0, 0, 'Þvejø', 18, 'ls'),
  272. (63, -1, 1, 0, 1, 794.762, -1692.09, 14.463, 0, 0, 0, 460847, 0, 0, 0, 0, 0, 'Þvejø', 19, 'ls'),
  273. (64, -1, 1, 0, 1, 790.812, -1661.34, 13.484, 0, 0, 0, 482451, 0, 0, 0, 0, 0, 'Þvejø', 20, 'ls'),
  274. (65, -1, 1, 0, 1, 1421.83, -886.16, 50.684, 0, 0, 0, 1351603, 0, 0, 0, 0, 0, 'Mosëdþio', 1, 'ls'),
  275. (66, -1, 1, 0, 1, 1468.5, -906.166, 54.836, 0, 0, 0, 1126943, 0, 0, 0, 0, 0, 'Mosëdþio', 2, 'ls'),
  276. (67, -1, 1, 0, 1, 1535.86, -885.387, 57.657, 0, 0, 0, 1414994, 0, 0, 0, 0, 0, 'Mosëdþio', 3, 'ls'),
  277. (68, -1, 1, 0, 1, 1540.33, -851.367, 64.336, 0, 0, 0, 1210430, 0, 0, 0, 0, 0, 'Mosëdþio', 4, 'ls'),
  278. (69, -1, 1, 0, 1, 1535.04, -800.186, 72.849, 0, 0, 0, 1384614, 0, 0, 0, 0, 0, 'Mosëdþio', 5, 'ls'),
  279. (70, -1, 1, 0, 1, 1527.89, -772.65, 80.578, 0, 0, 0, 1431438, 0, 0, 0, 0, 0, 'Mosëdþio', 6, 'ls'),
  280. (71, -1, 1, 0, 1, 1298.45, -797.983, 84.141, 0, 0, 0, 1412326, 0, 0, 0, 0, 0, 'Mosëdþio', 7, 'ls'),
  281. (72, -1, 1, 0, 1, 1093.78, -806.866, 107.42, 0, 0, 0, 1031659, 0, 0, 0, 0, 0, 'Mosëdþio', 8, 'ls'),
  282. (73, -1, 1, 0, 1, 1034.9, -812.999, 101.852, 0, 0, 0, 1339354, 0, 0, 0, 0, 0, 'Mosëdþio', 9, 'ls'),
  283. (74, -1, 1, 0, 1, 1017.03, -763.359, 112.563, 0, 0, 0, 1012196, 0, 0, 0, 0, 0, 'Mosëdþio', 10, 'ls'),
  284. (75, -1, 1, 0, 1, 989.838, -828.637, 95.469, 0, 0, 0, 1087136, 0, 0, 0, 0, 0, 'Mosëdþio', 11, 'ls'),
  285. (76, -1, 1, 0, 1, 937.822, -848.476, 93.611, 0, 0, 0, 1355025, 0, 0, 0, 0, 0, 'Mosëdþio', 12, 'ls'),
  286. (77, -1, 1, 0, 1, 910.427, -817.522, 103.126, 0, 0, 0, 1026123, 0, 0, 0, 0, 0, 'Mosëdþio', 13, 'ls'),
  287. (78, -1, 1, 0, 1, 923.939, -853.232, 93.457, 0, 0, 0, 1088622, 0, 0, 0, 0, 0, 'Mosëdþio', 14, 'ls'),
  288. (79, -1, 1, 0, 1, 836.171, -894.791, 68.769, 0, 0, 0, 1206596, 0, 0, 0, 0, 0, 'Mosëdþio', 15, 'ls'),
  289. (80, -1, 1, 0, 1, 827.943, -857.943, 70.331, 0, 0, 0, 1124618, 0, 0, 0, 0, 0, 'Mosëdþio', 16, 'ls'),
  290. (81, -1, 1, 0, 1, 1442.66, -629.098, 95.719, 0, 0, 0, 1239413, 0, 0, 0, 0, 0, 'Eidintø', 1, 'ls'),
  291. (82, 14, 1, 0, 0, 1332.07, -633.317, 109.135, 0, 0, 0, 1057146, 0, 0, 0, 0, 0, 'Eidintø', 2, 'ls'),
  292. (83, -1, 1, 0, 1, 1095.09, -647.915, 113.648, 0, 0, 0, 1421163, 0, 0, 0, 0, 0, 'Eidintø', 3, 'ls'),
  293. (84, -1, 1, 0, 1, 1045.18, -642.936, 120.117, 0, 0, 0, 1003870, 0, 0, 0, 0, 0, 'Eidintø', 4, 'ls'),
  294. (85, -1, 1, 0, 1, 980.449, -677.28, 121.976, 0, 0, 0, 1323132, 0, 0, 0, 0, 0, 'Eidintø', 5, 'ls'),
  295. (86, -1, 1, 0, 1, 946.27, -710.719, 122.62, 0, 0, 0, 1397065, 0, 0, 0, 0, 0, 'Eidintø', 6, 'ls'),
  296. (87, -1, 1, 0, 1, 898.597, -676.528, 116.89, 0, 0, 0, 1298028, 0, 0, 0, 0, 0, 'Eidintø', 7, 'ls'),
  297. (88, -1, 1, 0, 1, 977.295, -771.709, 112.203, 0, 0, 0, 1230772, 0, 0, 0, 0, 0, 'Eidintø', 8, 'ls'),
  298. (89, -1, 1, 0, 1, 891.177, -783.16, 101.314, 0, 0, 0, 1475357, 0, 0, 0, 0, 0, 'Eidintø', 9, 'ls'),
  299. (90, -1, 1, 0, 1, 867.548, -717.605, 105.68, 0, 0, 0, 1335953, 0, 0, 0, 0, 0, 'Eidintø', 10, 'ls'),
  300. (91, -1, 1, 0, 1, 847.961, -745.474, 94.969, 0, 0, 0, 1338475, 0, 0, 0, 0, 0, 'Eidintø', 11, 'ls'),
  301. (92, -1, 1, 0, 1, 808.285, -759.464, 76.531, 0, 0, 0, 1044932, 0, 0, 0, 0, 0, 'Eidintø', 12, 'ls'),
  302. (93, -1, 1, 0, 1, 785.98, -828.58, 70.29, 0, 0, 0, 1028794, 0, 0, 0, 0, 0, 'Eidintø', 13, 'ls'),
  303. (94, -1, 1, 0, 1, 724.689, -999.371, 52.734, 0, 0, 0, 1258596, 0, 0, 0, 0, 0, 'Girios', 1, 'ls'),
  304. (95, -1, 1, 0, 1, 672.791, -1020.74, 55.76, 0, 0, 0, 1312005, 0, 0, 0, 0, 0, 'Girios', 2, 'ls'),
  305. (96, -1, 1, 0, 1, 700.25, -1060.34, 49.422, 0, 0, 0, 1192582, 0, 0, 0, 0, 0, 'Girios', 3, 'ls'),
  306. (97, -1, 1, 0, 1, 648.076, -1059, 52.58, 0, 0, 0, 1078935, 0, 0, 0, 0, 0, 'Girios', 4, 'ls'),
  307. (98, -1, 1, 0, 1, 646.026, -1117.38, 44.207, 0, 0, 0, 1380854, 0, 0, 0, 0, 0, 'Girios', 5, 'ls'),
  308. (99, -1, 1, 0, 1, 612.137, -1085.94, 58.827, 0, 0, 0, 1201493, 0, 0, 0, 0, 0, 'Girios', 6, 'ls'),
  309. (100, -1, 1, 0, 1, 553.032, -1200.25, 44.832, 0, 0, 0, 1317091, 0, 0, 0, 0, 0, 'Girios', 7, 'ls'),
  310. (101, -1, 1, 0, 1, 432.122, -1253.93, 51.581, 0, 0, 0, 1291030, 0, 0, 0, 0, 0, 'Girios', 8, 'ls'),
  311. (102, -1, 1, 0, 1, 397.983, -1271.45, 50.02, 0, 0, 0, 1072223, 0, 0, 0, 0, 0, 'Girios', 9, 'ls'),
  312. (103, -1, 1, 0, 1, 355.235, -1281.11, 53.704, 0, 0, 0, 1350877, 0, 0, 0, 0, 0, 'Girios', 10, 'ls'),
  313. (109, -1, 1, 0, 1, 298.629, -1338.41, 53.441, 0, 0, 0, 1161805, 0, 0, 0, 0, 0, 'Girios', 12, 'ls'),
  314. (110, -1, 1, 0, 1, 254.56, -1366.97, 53.109, 0, 0, 0, 1137254, 0, 0, 0, 0, 0, 'Girios', 13, 'ls'),
  315. (111, -1, 1, 0, 1, 227.969, -1405.44, 51.609, 0, 0, 0, 1251448, 0, 0, 0, 0, 0, 'Girios', 14, 'ls'),
  316. (112, -1, 1, 0, 1, 189.64, -1308.28, 70.249, 0, 0, 0, 1387716, 0, 0, 0, 0, 0, 'Girios', 15, 'ls'),
  317. (113, -1, 1, 0, 1, 580.637, -1149.7, 53.18, 0, 0, 0, 1137893, 0, 0, 0, 0, 0, 'Girios', 16, 'ls'),
  318. (114, -1, 1, 0, 1, 558.907, -1161.01, 54.43, 0, 0, 0, 1281940, 0, 0, 0, 0, 0, 'Girios', 18, 'ls'),
  319. (115, -1, 1, 0, 1, 534.966, -1173.74, 58.81, 0, 0, 0, 1298151, 0, 0, 0, 0, 0, 'Girios', 19, 'ls'),
  320. (116, -1, 1, 0, 1, 470.868, -1163.92, 67.215, 0, 0, 0, 1032119, 0, 0, 0, 0, 0, 'Girios', 17, 'ls'),
  321. (117, -1, 1, 0, 1, 416.775, -1154.13, 76.688, 0, 0, 0, 1007701, 0, 0, 0, 0, 0, 'Girios', 20, 'ls'),
  322. (118, -1, 1, 0, 1, 352.395, -1197.94, 76.516, 0, 0, 0, 1258835, 0, 0, 0, 0, 0, 'Girios', 21, 'ls'),
  323. (119, -1, 1, 0, 1, 300.234, -1154.45, 81.389, 0, 0, 0, 1018177, 0, 0, 0, 0, 0, 'Girios', 22, 'ls'),
  324. (120, -1, 1, 0, 1, 251.353, -1220.27, 76.102, 0, 0, 0, 1124568, 0, 0, 0, 0, 0, 'Girios', 23, 'ls'),
  325. (121, -1, 1, 0, 1, 253.247, -1269.97, 74.429, 0, 0, 0, 1446538, 0, 0, 0, 0, 0, 'Girios', 24, 'ls'),
  326. (122, -1, 1, 0, 1, 219.216, -1249.82, 78.337, 0, 0, 0, 1346442, 0, 0, 0, 0, 0, 'Girios', 25, 'ls'),
  327. (123, -1, 1, 0, 1, 161.608, -1455.74, 32.845, 0, 0, 0, 1177543, 0, 0, 0, 0, 0, 'Girios', 26, 'ls'),
  328. (124, -1, 1, 0, 1, 142.578, -1470.14, 25.211, 0, 0, 0, 1059774, 0, 0, 0, 0, 0, 'Girios', 27, 'ls'),
  329. (125, -1, 1, 0, 1, 1112.24, -742.078, 100.133, 0, 0, 0, 1354047, 0, 0, 0, 0, 0, 'Girios', 28, 'ls'),
  330. (126, -1, 1, 0, 1, 2326.78, -1716.71, 14.238, 0, 0, 0, 469557, 0, 0, 0, 0, 0, 'Jotvingiø', 18, 'ls'),
  331. (127, -1, 1, 0, 1, 2308.87, -1714.33, 14.98, 0, 0, 0, 502631, 0, 0, 0, 0, 0, 'Jotvingiø', 19, 'ls'),
  332. (128, -1, 1, 0, 1, 2306.94, -1679.07, 14.332, 0, 0, 0, 506341, 0, 0, 0, 0, 0, 'Jotvingiø', 20, 'ls'),
  333. (129, -1, 1, 0, 1, 2282.31, -1641.38, 15.89, 0, 0, 0, 464442, 0, 0, 0, 0, 0, 'Jotvingiø', 21, 'ls'),
  334. (130, -1, 1, 0, 1, 2257.27, -1643.97, 15.808, 0, 0, 0, 455940, 0, 0, 0, 0, 0, 'Jotvingiø', 22, 'ls'),
  335. (131, -1, 1, 0, 1, 2244.41, -1637.61, 16.238, 0, 0, 0, 460427, 0, 0, 0, 0, 0, 'Jotvingiø', 23, 'ls');
  336.  
  337. -- --------------------------------------------------------
  338.  
  339. --
  340. -- Sukurta duomenų struktūra lentelei `mapicons`
  341. --
  342.  
  343. CREATE TABLE IF NOT EXISTS `mapicons` (
  344.   `mi_ID` int(11) NOT NULL AUTO_INCREMENT,
  345.   `mi_Name` varchar(30) NOT NULL,
  346.   `mi_PosX` float NOT NULL,
  347.   `mi_PosY` float NOT NULL,
  348.   `mi_PosZ` float NOT NULL,
  349.   `mi_Type` int(2) NOT NULL,
  350.   `mi_VW` int(11) NOT NULL,
  351.   `mi_Interior` int(11) NOT NULL,
  352.   `mi_Streamdistance` float NOT NULL,
  353.   `mi_Show` int(1) NOT NULL,
  354.   `mi_Map` varchar(3) NOT NULL,
  355.   PRIMARY KEY (`mi_ID`)
  356. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
  357.  
  358. --
  359. -- Sukurta duomenų kopija lentelei `mapicons`
  360. --
  361.  
  362. INSERT INTO `mapicons` (`mi_ID`, `mi_Name`, `mi_PosX`, `mi_PosY`, `mi_PosZ`, `mi_Type`, `mi_VW`, `mi_Interior`, `mi_Streamdistance`, `mi_Show`, `mi_Map`) VALUES
  363. (1, 'Bankas', 1734.84, -1266.76, 13.543, 52, 0, 0, 2000, 0, 'ls'),
  364. (2, 'Idlewood parduotuve', 2129.81, -1761.15, 13.5625, 38, 0, 0, 2000, 0, 'ls'),
  365. (3, 'Ganton parduotuve', 2423.66, -1742.44, 13.5469, 38, 0, 0, 2000, 0, 'ls'),
  366. (4, 'East Beach parduotuve', 2751.63, -1468.24, 30.4531, 38, 0, 0, 2000, 0, 'ls'),
  367. (5, 'Jefferson parduotuve', 2139.72, -1191.97, 23.9922, 38, 0, 0, 2000, 0, 'ls'),
  368. (6, 'Downtown parduotuve', 1582.35, -1170.37, 24.0781, 38, 0, 0, 2000, 0, 'ls'),
  369. (8, 'LSPD', 1531.41, -1674.8, 13.3828, 30, 0, 0, 2000, 0, 'ls'),
  370. (9, 'LSMD', 1995.36, -1452.89, 13.5547, 22, 0, 0, 2000, 0, 'ls'),
  371. (16, 'Tiuningas', 1024.63, -1033.07, 31.841, 27, 0, 0, 2000, 0, 'ls'),
  372. (18, 'Garažas1', 1189.95, -1013.27, 32.547, 55, 0, 0, 2000, 0, 'ls'),
  373. (19, 'Orouostas', 1923.74, -2409.43, 13.539, 5, 0, 0, 2000, 0, 'ls'),
  374. (20, 'Tune SF (WAA)', -2690.47, 210.164, 4.328, 27, 0, 0, 2000, 0, 'ls'),
  375. (21, 'MocoMisija', 1360.95, -1659.3, 14.766, 33, 0, 0, 2000, 1, 'ls'),
  376. (22, 'Vieðbutis', 1653.95, -1656.31, 22.516, 31, 0, 0, 2000, 1, 'ls'),
  377. (23, 'KM-Bankas', 2313.42, -6.787, 26.485, 52, 0, 0, 1000, 1, 'km'),
  378. (24, 'Daugiabuèiai1', 2440.75, 21.639, 26.459, 31, 0, 0, 1000, 1, 'km'),
  379. (25, 'Picerija', 1365.73, 250.772, 19.388, 29, 0, 0, 1000, 1, 'km'),
  380. (26, 'race', -490.514, -211.25, 79.497, 53, 0, 0, 1000, 1, 'km'),
  381. (27, 'picerija-bb', 212.533, -202.515, 1.578, 29, 0, 0, 1000, 1, 'km'),
  382. (28, 'dill_deg', 699.959, -565.85, 16.329, 24, 0, 0, 1000, 1, 'km'),
  383. (29, 'dill_deg2', 655.615, -564.964, 16.336, 24, 0, 0, 1000, 1, 'km'),
  384. (30, 'daugiabutis2', 2498.12, 76.107, 26.459, 31, 0, 0, 1000, 1, 'km'),
  385. (31, 'medprek', 2242.61, 52.725, 26.667, 21, 0, 0, 1000, 1, 'km');
  386.  
  387. -- --------------------------------------------------------
  388.  
  389. --
  390. -- Sukurta duomenų struktūra lentelei `objects`
  391. --
  392.  
  393. CREATE TABLE IF NOT EXISTS `objects` (
  394.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  395.   `Model` int(11) NOT NULL,
  396.   `X` float NOT NULL,
  397.   `Y` float NOT NULL,
  398.   `Z` float NOT NULL,
  399.   `rX` float NOT NULL,
  400.   `rY` float NOT NULL,
  401.   `rZ` float NOT NULL,
  402.   `Int` int(11) NOT NULL,
  403.   `vw` int(11) NOT NULL,
  404.   `e1` int(11) NOT NULL COMMENT 'none, vehicle, player etc',
  405.   `e2` int(11) NOT NULL COMMENT 'none, vehSQL, plrSQL, etc',
  406.   PRIMARY KEY (`ID`)
  407. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  408.  
  409. -- --------------------------------------------------------
  410.  
  411. --
  412. -- Sukurta duomenų struktūra lentelei `offmsg`
  413. --
  414.  
  415. CREATE TABLE IF NOT EXISTS `offmsg` (
  416.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  417.   `Type` int(1) NOT NULL,
  418.   `GiverID` int(6) NOT NULL,
  419.   `SenderID` int(6) NOT NULL,
  420.   `Msg` varchar(120) NOT NULL,
  421.   `Time` int(11) NOT NULL,
  422.   PRIMARY KEY (`ID`)
  423. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  424.  
  425. -- --------------------------------------------------------
  426.  
  427. --
  428. -- Sukurta duomenų struktūra lentelei `playeritems`
  429. --
  430.  
  431. CREATE TABLE IF NOT EXISTS `playeritems` (
  432.   `i_ID` int(11) NOT NULL AUTO_INCREMENT,
  433.   `i_Type` int(1) NOT NULL,
  434.   `i_Owner` int(11) NOT NULL,
  435.   `i_ItemID` int(11) NOT NULL,
  436.   `i_Quantity` int(11) NOT NULL,
  437.   `i_Price` int(11) NOT NULL,
  438.   `i_Show` int(1) NOT NULL,
  439.   `i_Extra0` int(11) NOT NULL,
  440.   `i_Extra1` int(11) NOT NULL,
  441.   `i_Extra2` int(11) NOT NULL,
  442.   `i_Extra3` float NOT NULL,
  443.   `i_Extra4` int(1) NOT NULL,
  444.   `i_Weight` float NOT NULL,
  445.   PRIMARY KEY (`i_ID`)
  446. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
  447.  
  448. --
  449. -- Sukurta duomenų kopija lentelei `playeritems`
  450. --
  451.  
  452. 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
  453. (1, 1, 14, 4, 1, 0, 0, 11, 82, 0, 0, 0, 0),
  454. (2, 1, 15, 4, 1, 0, 0, 11, 16, 0, 0, 0, 0),
  455. (3, 3, 2, 6, 2383, 2, 1, 0, 0, 0, 0, 0, 0),
  456. (4, 3, 1, 2881, 2552, 3, 1, 0, 0, 0, 0, 0, 0),
  457. (5, 1, 15, 4, 1, 0, 0, 11, 8, 0, 0, 0, 0),
  458. (6, 1, 15, 7, 1, 0, 0, 0, 0, 0, 0, 1, 0),
  459. (7, 1, 14, 7, 1, 0, 0, 0, 0, 0, 0, 1, 0),
  460. (8, 1, 25, 4, 1, 0, 0, 11, 29, 0, 0, 0, 0),
  461. (9, 3, 3, 11738, 2322, 50, 1, 0, 0, 0, 0, 0, 0),
  462. (10, 3, 3, 11736, 2530, 15, 1, 0, 0, 0, 0, 0, 0),
  463. (11, 3, 3, 19570, 2159, 10, 1, 0, 0, 0, 0, 0, 0),
  464. (12, 6, 7, 11738, 50, 5, 0, 0, 0, 0, 0, 0, 0);
  465.  
  466. -- --------------------------------------------------------
  467.  
  468. --
  469. -- Sukurta duomenų struktūra lentelei `players`
  470. --
  471.  
  472. CREATE TABLE IF NOT EXISTS `players` (
  473.   `pID` int(11) NOT NULL AUTO_INCREMENT,
  474.   `pName` varchar(24) NOT NULL,
  475.   `pPass` varchar(130) NOT NULL,
  476.   `pRegTime` int(20) NOT NULL,
  477.   `pRegIP` varchar(17) NOT NULL,
  478.   `pLastIP` varchar(17) NOT NULL,
  479.   `pLastTime` int(20) NOT NULL,
  480.   `vvpPass` varchar(150) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
  481.   `vvpActive` varchar(255) NOT NULL,
  482.   `pEmail` varchar(100) NOT NULL,
  483.   `pPosX` float NOT NULL,
  484.   `pPosY` float NOT NULL,
  485.   `pPosZ` float NOT NULL,
  486.   `pPosA` float NOT NULL,
  487.   `pDrabuziai` int(3) NOT NULL,
  488.   `pMoney` int(11) NOT NULL,
  489.   `pScore` int(11) NOT NULL,
  490.   `pAdmin` int(1) NOT NULL,
  491.   `pAod` int(1) NOT NULL,
  492.   `pVip` int(1) NOT NULL,
  493.   `pContract` int(11) NOT NULL,
  494.   `pJobSkin` int(3) NOT NULL,
  495.   `pGangID` int(2) NOT NULL,
  496.   `pGangSkin` int(1) NOT NULL,
  497.   `pGangSkinID` int(3) NOT NULL,
  498.   `pGangLead` int(11) NOT NULL,
  499.   `pJobID` int(2) NOT NULL,
  500.   `pJobSkinID` int(3) NOT NULL,
  501.   `pJobLead` int(2) NOT NULL,
  502.   `pJobDeputy` int(3) NOT NULL,
  503.   `pInterior` int(4) NOT NULL,
  504.   `pVW` int(11) NOT NULL,
  505.   `pBankoSaskaita` int(11) NOT NULL,
  506.   `pBMoney` int(11) NOT NULL,
  507.   `pRangas` int(2) NOT NULL,
  508.   `pGRangas` int(11) NOT NULL,
  509.   `pWanted` int(5) NOT NULL,
  510.   `pBauda` int(11) NOT NULL,
  511.   `pJailed` int(1) NOT NULL,
  512.   `pCuff` int(1) NOT NULL,
  513.   `pLevel` int(11) NOT NULL,
  514.   `pMask` int(1) NOT NULL,
  515.   `pOnline` int(1) NOT NULL,
  516.   `pGender` int(1) NOT NULL,
  517.   `pApmokymuStep` int(3) NOT NULL,
  518.   `pGuns` varchar(100) NOT NULL,
  519.   `pGunLic` int(1) NOT NULL,
  520.   `pCanLogin` int(11) NOT NULL,
  521.   `pCanLoginReason` varchar(50) NOT NULL,
  522.   `pCanLoginType` int(1) NOT NULL,
  523.   `pLastRaceTime` int(11) NOT NULL,
  524.   `pTimeSpent` int(11) NOT NULL,
  525.   `pAlga` int(11) NOT NULL,
  526.   `pMuted` int(11) NOT NULL,
  527.   `pDead` int(1) NOT NULL,
  528.   `pDviratis` int(1) NOT NULL,
  529.   `pDviratisX` float NOT NULL,
  530.   `pDviratisY` float NOT NULL,
  531.   `pDviratisZ` float NOT NULL,
  532.   `pSettings` varchar(20) NOT NULL,
  533.   `pLastTimeTakeGun` int(11) NOT NULL,
  534.   `pLastTimeEgun` int(11) NOT NULL,
  535.   `pNamuose` int(11) NOT NULL,
  536.   `pBankPin` int(4) NOT NULL,
  537.   PRIMARY KEY (`pID`)
  538. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
  539.  
  540. --
  541. -- Sukurta duomenų kopija lentelei `players`
  542. --
  543.  
  544. 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`, `pBankPin`) VALUES
  545. (14, 'Yawas', 'asdasd', 0, '', '', 1468668311, '', '', 'asd@asd.lt', 1955.51, -1205.35, 17.532, 125.277, 7, 50000, 200, 2, 0, 0, 1456331887, 0, 2, 0, 0, 2, 5, 0, 1, 0, 0, 0, 1, 3172, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, '0 0 0 0 24 50100 25 50000 32 5000050 30 10015 0 0 38 1849258976 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 1468571601, 42570, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 1234),
  546. (23, 'Aine_Sportt', '864225821', 1454771884, '78.63.21.18', '', 1454772144, '', '', 'ainorasp@gmail.com', 1489.91, -1765.49, 14.381, 311.428, 22, 10246, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 227, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  547. (25, 'John_Elite', '123456', 1468170631, '78.63.97.210', '', 1469045289, '', '', 'asdasd@gmail.com', -429.747, -1729.6, 2089.01, 349.93, 7, -20, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 69, 0, 1, 62804107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '21 1 0 0 24 101 25 101 32 5000000 0 0 34 1 0 0 0 0 0 0 15 1 0 0 0 0', 0, 0, '', 0, 0, 17157, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 1234),
  548. (29, 'John_Elites', '123456', 1468354011, '78.63.97.210', '', 1468355075, '', '', 'asdasdsd@gmail.com', 1342.38, -1622.78, 17.734, 356.428, 93, 1500, 0, 0, 0, 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 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 971, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  549. (39, 'dovydas', 'asdasd', 1468408988, '127.0.0.1', '', 1468409436, '', '', '', 1276.93, -1544.35, 13.547, 338.271, 20, 10770, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1468409060, 172, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  550. (40, 'Test', 'asdasd', 1468409882, '127.0.0.1', '', 0, '', '', '', 1341.93, -1662.85, 17.7266, 0, 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, 0),
  551. (41, 'Testasa', 'sadasd', 1468410725, '127.0.0.1', '', 1468410838, '', '', '', 1356.89, -1668.46, 13.608, 67.681, 22, 10000, 0, 0, 0, 0, 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, 19, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  552. (42, 'Testasakiu', 'asdasd', 1468411270, '127.0.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, 0, 0, 0, 0, 0, 0, 0, 0, 2, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
  553. (43, 'askbsdkbd', 'asdasd', 1468411558, '127.0.0.1', '', 1468411594, '', '', '', 1341.84, -1681.88, 17.719, 180.458, 7, 10000, 0, 0, 0, 0, 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, 6, 0, 0, 0, 1, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  554. (44, 'Sudas_Susas', '123456', 1468423951, '78.63.97.210', '', 0, '', '', 'asdasd@gmail.com', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
  555. (45, 'Pimpalasas', '123456', 1468424191, '78.63.97.210', '', 0, '', '', 'asdasd@gmail.com', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
  556. (46, 'tasdasd', 'asdasd', 1468424201, '127.0.0.1', '', 1468429663, '', '', '', 1348.98, -1681.7, 13.604, 341.139, 7, 0, 0, 2, 0, 0, 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, 2111, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  557. (47, 'Tuduchas', '123456', 1468424581, '78.63.97.210', '', 1468425360, '', '', '', 1785.98, -1393.6, 15.758, 25.295, 7, 1493, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1468424805, 683, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  558. (48, 'TESTASDA', 'asdasd', 1468429802, '127.0.0.1', '', 1468432832, '', '', '', 1422.43, -1317.68, 13.555, 26.634, 7, 10000, 0, 0, 0, 0, 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, 1111, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  559. (49, 'asdffghjkl', 'asdasd', 1468440517, '127.0.0.1', '', 1468440688, '', '', '', 1343.59, -1680.37, 13.585, 133.458, 20, 10000, 0, 0, 0, 0, 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, 153, 0, 0, 0, 1, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  560. (50, 'Memius', '123456', 1468445361, '78.63.97.210', '', 1468445532, '', '', '', 1886.36, -1757.08, 13.179, 245.247, 7, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 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, 150, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  561. (51, 'John_Juske', '147852', 1468587312, '86.38.226.143', '', 1468946360, '', '', '14725a@gmail.com', 639.024, -531.624, 15.915, 251.632, 7, 1500, 0, 0, 0, 0, 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, 5252, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  562. (52, 'Pimpis', '123456', 1468592611, '78.63.97.210', '', 1468594003, '', '', '', -1036.42, -591.987, 32.2, 132.977, 20, 1500, 0, 0, 0, 0, 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, 1262, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  563. (53, 'Yawukas', 'asdasd', 1468672971, '127.0.0.1', '', 1470558939, '', '', '', -427.408, -1727.97, 2244.36, 251.825, 22, 6380, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 69, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, '21 500000 6 500000 22 500000 25 500000 29 500000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 35125, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
  564. (54, 'Andrew_Extazy', 'tavomama', 1468701418, '78.58.49.91', '', 1468703126, '', '', 'tavomama@tavomama.com', 1372.42, 287.818, 19.112, 81.078, 7, 1500, 0, 0, 0, 0, 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, 825, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0);
  565.  
  566. -- --------------------------------------------------------
  567.  
  568. --
  569. -- Sukurta duomenų struktūra lentelei `rangai`
  570. --
  571.  
  572. CREATE TABLE IF NOT EXISTS `rangai` (
  573.   `rang_ID` int(5) NOT NULL AUTO_INCREMENT,
  574.   `rang_Name` varchar(50) NOT NULL,
  575.   `rang_IDinJob` int(5) NOT NULL,
  576.   `rang_JobID` int(5) NOT NULL,
  577.   `rang_SkinVID` int(3) NOT NULL,
  578.   `rang_SkinMID` int(3) NOT NULL,
  579.   PRIMARY KEY (`rang_ID`)
  580. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  581.  
  582. --
  583. -- Sukurta duomenų kopija lentelei `rangai`
  584. --
  585.  
  586. INSERT INTO `rangai` (`rang_ID`, `rang_Name`, `rang_IDinJob`, `rang_JobID`, `rang_SkinVID`, `rang_SkinMID`) VALUES
  587. (1, 'Abrikosai', 1, 2, 0, 0);
  588.  
  589. -- --------------------------------------------------------
  590.  
  591. --
  592. -- Sukurta duomenų struktūra lentelei `vehicles`
  593. --
  594.  
  595. CREATE TABLE IF NOT EXISTS `vehicles` (
  596.   `vID` int(11) NOT NULL AUTO_INCREMENT,
  597.   `vOwnerType` int(1) NOT NULL,
  598.   `vOwnerID` int(11) NOT NULL,
  599.   `vModel` int(3) NOT NULL,
  600.   `vPosX` float NOT NULL,
  601.   `vPosY` float NOT NULL,
  602.   `vPosZ` float NOT NULL,
  603.   `vPosA` float NOT NULL,
  604.   `vHealth` float NOT NULL,
  605.   `vFuel` float NOT NULL,
  606.   `vFuelType` int(1) NOT NULL,
  607.   `vRida` float NOT NULL,
  608.   `vEngine` int(1) NOT NULL,
  609.   `vLights` int(1) NOT NULL,
  610.   `vAlarm` int(1) NOT NULL,
  611.   `vBonnet` int(1) NOT NULL,
  612.   `vBoot` int(1) NOT NULL,
  613.   `vObjective` int(1) NOT NULL,
  614.   `vLocked` int(1) NOT NULL,
  615.   `vColor1` int(3) NOT NULL,
  616.   `vColor2` int(3) NOT NULL,
  617.   `vPaintjob` int(1) NOT NULL,
  618.   `vMods` varchar(70) NOT NULL,
  619.   `vRangas` int(5) NOT NULL,
  620.   `vPanelsDamage` int(11) NOT NULL,
  621.   `vDoorsDamage` int(11) NOT NULL,
  622.   `vLightsDamage` int(11) NOT NULL,
  623.   `vTiresDamage` int(11) NOT NULL,
  624.   `vUp_Speed` float NOT NULL,
  625.   `vUp_Brake` float NOT NULL,
  626.   PRIMARY KEY (`vID`)
  627. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  628.  
  629. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  630. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  631. /*!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!