· 6 years ago · May 31, 2019, 04:12 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.10
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: May 29, 2019 at 12:43 PM
7-- Server version: 5.5.60-MariaDB
8-- PHP Version: 5.4.16
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 utf8mb4 */;
18
19--
20-- Database: `firexhost_2`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `accounts`
27--
28
29CREATE TABLE IF NOT EXISTS `accounts` (
30 `ID` int(12) NOT NULL,
31 `Username` varchar(24) DEFAULT NULL,
32 `Password` varchar(129) DEFAULT NULL,
33 `RegisterDate` varchar(36) DEFAULT NULL,
34 `LoginDate` varchar(36) DEFAULT NULL,
35 `IP` varchar(16) DEFAULT 'n/a'
36) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
37
38--
39-- Dumping data for table `accounts`
40--
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `arrestpoints`
46--
47
48CREATE TABLE IF NOT EXISTS `arrestpoints` (
49 `arrestID` int(11) NOT NULL,
50 `arrestX` float NOT NULL,
51 `arrestY` float NOT NULL,
52 `arrestZ` float NOT NULL,
53 `arrestInterior` int(11) NOT NULL,
54 `arrestWorld` int(11) NOT NULL
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57-- --------------------------------------------------------
58
59--
60-- Table structure for table `atm`
61--
62
63CREATE TABLE IF NOT EXISTS `atm` (
64 `atmID` int(11) NOT NULL,
65 `atmX` float NOT NULL,
66 `atmY` float NOT NULL,
67 `atmZ` float NOT NULL,
68 `atmInterior` int(11) NOT NULL,
69 `atmWorld` int(11) NOT NULL
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71
72-- --------------------------------------------------------
73
74--
75-- Table structure for table `backpackitems`
76--
77
78CREATE TABLE IF NOT EXISTS `backpackitems` (
79 `ID` int(12) DEFAULT '0',
80 `itemID` int(12) NOT NULL,
81 `itemName` varchar(32) DEFAULT NULL,
82 `itemModel` int(12) DEFAULT '0',
83 `itemQuantity` int(12) DEFAULT '0'
84) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `backpacks`
90--
91
92CREATE TABLE IF NOT EXISTS `backpacks` (
93 `backpackID` int(12) NOT NULL,
94 `backpackPlayer` int(12) DEFAULT '0',
95 `backpackX` float DEFAULT '0',
96 `backpackY` float DEFAULT '0',
97 `backpackZ` float DEFAULT '0',
98 `backpackInterior` int(12) DEFAULT '0',
99 `backpackWorld` int(12) DEFAULT '0',
100 `backpackHouse` int(12) DEFAULT '0',
101 `backpackVehicle` int(12) DEFAULT '0'
102) ENGINE=InnoDB DEFAULT CHARSET=latin1;
103
104-- --------------------------------------------------------
105
106--
107-- Table structure for table `billboards`
108--
109
110CREATE TABLE IF NOT EXISTS `billboards` (
111 `bbID` int(12) NOT NULL,
112 `bbExists` int(12) DEFAULT '0',
113 `bbName` varchar(32) DEFAULT NULL,
114 `bbOwner` int(12) NOT NULL DEFAULT '0',
115 `bbPrice` int(12) NOT NULL DEFAULT '0',
116 `bbRange` int(12) DEFAULT '10',
117 `bbPosX` float DEFAULT '0',
118 `bbPosY` float DEFAULT '0',
119 `bbPosZ` float DEFAULT '0',
120 `bbMessage` varchar(230) DEFAULT NULL
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122
123-- --------------------------------------------------------
124
125--
126-- Table structure for table `blacklist`
127--
128
129CREATE TABLE IF NOT EXISTS `blacklist` (
130 `IP` varchar(16) DEFAULT '0.0.0.0',
131 `Username` varchar(24) DEFAULT NULL,
132 `BannedBy` varchar(24) DEFAULT NULL,
133 `Reason` varchar(128) DEFAULT NULL,
134 `Date` varchar(36) DEFAULT NULL
135) ENGINE=InnoDB DEFAULT CHARSET=latin1;
136
137-- --------------------------------------------------------
138
139--
140-- Table structure for table `businesses`
141--
142
143CREATE TABLE IF NOT EXISTS `businesses` (
144 `bizID` int(12) NOT NULL,
145 `bizName` varchar(32) DEFAULT NULL,
146 `bizOwner` int(12) DEFAULT '0',
147 `bizType` int(12) DEFAULT '0',
148 `bizPrice` int(12) DEFAULT '0',
149 `bizPosX` float DEFAULT '0',
150 `bizPosY` float DEFAULT '0',
151 `bizPosZ` float DEFAULT '0',
152 `bizPosA` float DEFAULT '0',
153 `bizIntX` float DEFAULT '0',
154 `bizIntY` float DEFAULT '0',
155 `bizIntZ` float DEFAULT '0',
156 `bizIntA` float DEFAULT '0',
157 `bizInterior` int(12) DEFAULT '0',
158 `bizExterior` int(12) DEFAULT '0',
159 `bizExteriorVW` int(12) DEFAULT '0',
160 `bizLocked` int(4) DEFAULT '0',
161 `bizVault` int(12) DEFAULT '0',
162 `bizProducts` int(12) DEFAULT '0',
163 `bizPrice1` int(12) DEFAULT '0',
164 `bizPrice2` int(12) DEFAULT '0',
165 `bizPrice3` int(12) DEFAULT '0',
166 `bizPrice4` int(12) DEFAULT '0',
167 `bizPrice5` int(12) DEFAULT '0',
168 `bizPrice6` int(12) DEFAULT '0',
169 `bizPrice7` int(12) DEFAULT '0',
170 `bizPrice8` int(12) DEFAULT '0',
171 `bizPrice9` int(12) DEFAULT '0',
172 `bizPrice10` int(12) DEFAULT '0',
173 `bizSpawnX` float DEFAULT '0',
174 `bizSpawnY` float DEFAULT '0',
175 `bizSpawnZ` float DEFAULT '0',
176 `bizSpawnA` float DEFAULT '0',
177 `bizDeliverX` float DEFAULT '0',
178 `bizDeliverY` float DEFAULT '0',
179 `bizDeliverZ` float DEFAULT '0',
180 `bizMessage` varchar(128) DEFAULT NULL,
181 `bizPrice11` int(12) DEFAULT '0',
182 `bizPrice12` int(12) DEFAULT '0',
183 `bizPrice13` int(12) DEFAULT '0',
184 `bizPrice14` int(12) DEFAULT '0',
185 `bizPrice15` int(12) DEFAULT '0',
186 `bizPrice16` int(12) DEFAULT '0',
187 `bizPrice17` int(12) DEFAULT '0',
188 `bizPrice18` int(12) DEFAULT '0',
189 `bizPrice19` int(12) DEFAULT '0',
190 `bizPrice20` int(12) DEFAULT '0',
191 `bizShipment` int(4) DEFAULT '0'
192) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
193
194--
195-- Dumping data for table `businesses`
196--
197
198INSERT INTO `businesses` (`bizID`, `bizName`, `bizOwner`, `bizType`, `bizPrice`, `bizPosX`, `bizPosY`, `bizPosZ`, `bizPosA`, `bizIntX`, `bizIntY`, `bizIntZ`, `bizIntA`, `bizInterior`, `bizExterior`, `bizExteriorVW`, `bizLocked`, `bizVault`, `bizProducts`, `bizPrice1`, `bizPrice2`, `bizPrice3`, `bizPrice4`, `bizPrice5`, `bizPrice6`, `bizPrice7`, `bizPrice8`, `bizPrice9`, `bizPrice10`, `bizSpawnX`, `bizSpawnY`, `bizSpawnZ`, `bizSpawnA`, `bizDeliverX`, `bizDeliverY`, `bizDeliverZ`, `bizMessage`, `bizPrice11`, `bizPrice12`, `bizPrice13`, `bizPrice14`, `bizPrice15`, `bizPrice16`, `bizPrice17`, `bizPrice18`, `bizPrice19`, `bizPrice20`, `bizShipment`) VALUES
199(16, 'Idlewood Gas Sation', 0, 6, 1, 1929.49, -1776.3, 13.5466, 89.5102, -27.3383, -57.6907, 1003.55, 0, 6, 0, 0, 0, 49300, 1862, 75, 115, 15, 90, 3, 2, 10, 90, 20, 10, 1929.49, -1776.3, 13.5466, 89.5102, 1919.58, -1789.66, 13.3905, 'Welcome to Idlewood Gas Station.', 140, 150, 50, 40, 5, 10, 5, 0, 0, 0, 0),
200(32, 'Pizzeria Mozza', 0, 4, 1, 1555.54, -1199.99, 20.0235, 358.303, -794.936, 489.772, 1376.2, 1.8946, 1, 0, 0, 0, 818, 1256, 3, 6, 7, 12, 12, 13, 13, 0, 0, 0, 1632.1, -1199.95, 19.7807, 353.341, 1492.83, -1155.99, 23.9139, 'Welcome to Pizzeria Mozza!', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
201(37, 'Jeffersons'' Autos', 0, 5, 1410065407, 2131.8, -1151.32, 24.0599, 181.047, 1494.56, 1304.21, 1093.29, 0, 3, 0, 0, 0, 343440, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2146.89, -1148.41, 24.4029, 268.636, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
202(41, 'Snow''s Seven Eleven', 0, 1, 1, 1833.38, -1842.58, 13.5781, 81.6912, 161.314, -96.3802, 1001.8, 182.657, 18, 0, 0, 0, 549, 1410064358, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 1833.38, -1842.58, 13.5781, 81.6912, 0, 0, 0, 'Welcome to Snow''s Seven Eleven.', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
203(47, 'Willowfield Ammunation', 0, 2, 1, 2400.39, -1981.99, 13.5466, 179.549, 316.396, -169.837, 999.601, 0, 6, 0, 0, 0, 134661, 421150, 50, 100, 200, 500, 700, 1000, 0, 0, 0, 0, 2400.39, -1981.99, 13.5466, 179.549, 634.33, -508.829, 16.3358, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
204(57, 'Rathery''s Clothing Shop', 0, 3, 0, 2244.26, -1665.53, 15.4764, 340.723, 161.48, -96.5363, 1001.8, 0, 18, 0, 0, 0, 861, 12354, 40, 21, 10, 10, 0, 0, 0, 0, 0, 0, 2244.26, -1665.53, 15.4764, 340.723, 2237.77, -1663.7, 15.4764, 'Welcome to Rathery''s clothing shop the cheapest one in town.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
205(60, 'Echo Parque 24/7', 0, 1, 45, 2081.52, -1202.49, 23.9162, 273.856, -25.8283, -187.481, 1003.55, 358.289, 17, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2081.52, -1202.49, 23.9162, 273.856, 2097.12, -1195.83, 23.8596, '', 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),
206(61, 'Pizza Stack (Idlewood)', 0, 4, 37000, 2105.4, -1806.54, 13.5545, 270.32, 372.414, -133.22, 1001.49, 354.584, 5, 0, 0, 0, 802, 4771, 3, 5, 13, 13, 15, 20, 17, 0, 0, 0, 2105.48, -1806.63, 13.5544, 274.225, 2096.86, -1807.04, 13.5529, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
207(62, 'Brooks'' Autos''', 0, 5, 250000, 1083.01, -1226.51, 15.8203, 95.7052, -2158.66, 643.142, 1052.38, 3.2943, 1, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1097.28, -1241.78, 15.8203, 270.832, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
208(63, 'Ideal Homes Store', 0, 7, 30000, 2351.6, -1412.13, 23.9923, 270.439, -2240.5, 128.377, 1035.42, 270, 6, 0, 0, 0, 0, 0, 100, 100, 100, 100, 100, 100, 100, 100, 100, 10, 2351.6, -1412.13, 23.9923, 270.439, 0, 0, 0, 'Welcome to Ideal Homes Store!', 140, 190, 150, 60, 50, 5, 10, 5, 0, 0, 0),
209(64, 'Mongols MC''s Bike Dealership', 0, 5, 1, 987.626, -1349.18, 13.5839, 81.3843, 1494.56, 1304.21, 1093.29, 0, 3, 0, 0, 0, 21764, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 990.406, -1353.42, 13.3704, 260.758, 0, 0, 0, 'Best prices for the best bikes!', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
210(65, 'The Mongol''s MC club-house', 0, 4, 1, 1008.84, -1295.73, 13.5466, 348.179, 501.66, -67.5671, 998.758, 181.026, 11, 0, 0, 0, 947, 0, 2, 5, 5, 10, 10, 15, 10, 0, 0, 0, 1008.84, -1295.73, 13.5466, 348.179, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
211(67, 'Under Construction', 0, 6, 20000, 661.363, -573.407, 16.3358, 270.41, -25.6979, -188.25, 1003.55, 0.5993, 17, 0, 0, 0, 100, 90, 75, 115, 15, 90, 3, 2, 10, 90, 20, 10, 661.363, -573.407, 16.3358, 270.41, 0, 0, 0, 'Welcome to Dillemore Gas Station', 140, 150, 50, 40, 5, 10, 5, 0, 0, 0, 0),
212(68, 'The welcome pump', 0, 1, 15000, 681.601, -473.346, 16.5361, 0.2818, -227.028, 1401.23, 27.7656, 349.899, 18, 0, 0, 0, 170, 98, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 681.601, -473.346, 16.5361, 0.2818, 0, 0, 0, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
213(69, 'Local General Store', 0, 1, 25000, 691.857, -583.62, 16.3358, 265.886, -27.3073, -30.874, 1003.56, 0, 4, 0, 0, 0, 0, 157, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 691.857, -583.62, 16.3358, 265.886, 710.88, -569.458, 16.3358, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
214(70, 'Dillimore Barbers', 0, 1, 6000, 672.086, -496.856, 16.3358, 91.1496, 418.653, -82.6397, 1001.8, 78.9293, 3, 0, 0, 1, 0, 220, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 672.086, -496.856, 16.3358, 91.1496, 658.63, -499.877, 16.3358, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
215(71, 'Dillimore Binco', 0, 3, 25000, 672.064, -505.434, 16.3358, 93.1744, 161.391, -93.1591, 1001.8, 93.1744, 18, 0, 0, 0, 0, 85, 25, 15, 10, 10, 0, 0, 0, 0, 0, 0, 672.064, -505.434, 16.3358, 93.1744, 655.097, -500.75, 16.3358, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
216(72, 'Burger Shot', 0, 4, 7000, 670.971, -519.353, 16.3358, 43.2324, 363.371, -74.5755, 1001.51, 319.838, 10, 0, 0, 0, 211, 49, 3, 7, 8, 15, 20, 15, 10, 0, 0, 0, 670.971, -519.353, 16.3358, 43.2324, 0, 0, 0, 'Welcome to Burger Shot! Enjoy your stay!', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
217(74, 'Strawton''s Ammunation', 0, 2, 150000, 691.361, -614.229, 16.3358, 275.559, 316.396, -169.837, 999.601, 0, 6, 0, 0, 0, 0, 98, 50, 100, 200, 400, 600, 800, 10, 0, 0, 0, 691.361, -614.229, 16.3358, 275.559, 0, 0, 0, 'Strawton''s Ammunation.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
218(75, 'CheapPrice Restaurant', 0, 4, 13500, 2397.89, -1899.2, 13.5466, 179.116, 364.867, -10.6787, 1001.85, 324.504, 9, 0, 0, 0, 263, 241180, 2, 4, 7, 12, 12, 15, 10, 0, 0, 0, 2397.89, -1899.2, 13.5466, 179.116, 2391.01, -1886.2, 13.5466, 'Welcome to CheapPrice Restaurant - Enjoy the Cheap Price for your Meal.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
219(76, 'The Great Hall of Remorse', 0, 1, 9000, 940.621, -1085.28, 24.2961, 359.621, 947.875, 2176.76, 1011.02, 179.499, 1, 0, 0, 0, 1607, 57, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 940.621, -1085.28, 24.2961, 359.621, 0, 0, 0, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
220(79, '98c 24/7', 0, 1, 25000, 2424.12, -1922.09, 13.5481, 134.012, 773.839, -77.257, 1000.65, 3.0611, 7, 0, 0, 0, 3725, 0, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 2424.12, -1922.09, 13.5481, 134.012, 0, 0, 0, 'Welcom to 98c 24/7 ', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
221(80, 'Rathery''s Bar.', 0, 1, 25000, 2310.06, -1643.51, 14.8268, 317.216, 501.759, -68.1277, 998.758, 178.263, 11, 0, 0, 0, 9, 62, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 2310.06, -1643.51, 14.8268, 317.216, 0, 0, 0, 'Welcome to Rathery''s cheapest bar!', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
222(81, 'Ganton Barbers', 0, 1, 9500, 2265.07, -1670.38, 15.3591, 276.506, -27.3073, -30.874, 1003.56, 0, 4, 0, 0, 0, 1832, 63, 200, 300, 150, 100, 3, 2, 10, 500, 20, 10, 2265.07, -1670.38, 15.3591, 276.506, 0, 0, 0, '', 150, 200, 450, 60, 50, 5, 10, 5, 0, 0, 0),
223(82, 'Mexican & Salvadorean Food', 0, 4, 13500, 1949.3, -1985.11, 13.5466, 267.947, 681.427, -452.203, -25.617, 180.091, 1, 0, 0, 0, 350, 32, 2, 5, 5, 10, 10, 15, 10, 0, 0, 0, 1949.3, -1985.11, 13.5466, 267.947, 0, 0, 0, '~ Welcome to the M&D restaurant, eat well ~', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
224(84, 'East Los Santos Cluckin'' Bell', 0, 4, 16000, 2420.1, -1509.14, 24, 270.522, 364.827, -9.857, 1001.85, 324.753, 9, 0, 0, 0, 667, 0, 2, 5, 5, 10, 10, 15, 10, 100, 20, 10, 2420.1, -1509.14, 24, 270.522, 0, 0, 0, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
225(85, 'Sal''s Bargen Deals', 0, 1, 10000, 992.87, -1460.18, 13.5466, 91.7659, -2159.74, 642.329, 1052.38, 114.182, 1, 0, 0, 0, 795, 86, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 992.87, -1460.18, 13.5466, 91.7659, 0, 0, 0, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
226(86, 'Washington Street Club', 0, 1, 25000, 2177.24, -1311.18, 23.9843, 236.068, 493.28, -24.3178, 1000.68, 357.956, 17, 0, 0, 0, 402, 2276, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 2177.24, -1311.18, 23.9843, 236.068, 2179.14, -1340.73, 23.9843, '', 150, 150, 50, 60, 50, 5, 10, 5, 0, 0, 0),
227(87, 'Michael''s Towing Co.', 0, 1, 7000, 972.484, -1479.95, 13.557, 178.509, -2159.12, 641.518, 1052.38, 178.509, 1, 0, 0, 0, 192, 96, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 972.484, -1479.95, 13.557, 178.509, 0, 0, 0, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
228(88, 'Splash', 0, 1, 100000, 1219.15, -1811.7, 16.5937, 353.988, 1204.92, -13.5426, 1000.92, 354.783, 2, 0, 0, 1, 0, 100, 2, 5, 5, 10, 10, 15, 10, 0, 0, 0, 1219.15, -1811.7, 16.5937, 353.988, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
229(89, 'Brooks'' Autos''', 0, 5, 550000, 542.477, -1293.26, 17.242, 1.3135, 1494.56, 1304.21, 1093.29, 0, 3, 0, 0, 0, 22950, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 538.555, -1284.21, 17.242, 320.86, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
230(90, 'Pig Pen', 0, 1, 30000, 2421.57, -1219.87, 25.5209, 175.15, 1205.32, -11.9039, 1000.92, 352.354, 2, 0, 0, 0, 301, 31, 5, 5, 15, 5, 3, 2, 1, 10, 5, 10, 2421.57, -1219.87, 25.5209, 175.15, 0, 0, 0, '', 2, 50, 50, 50, 50, 1, 10, 5, 0, 0, 0),
231(92, 'The Furniture Shop', 0, 7, 1, 1978.8, -1761.96, 13.5466, 182.708, -2240.5, 128.377, 1035.42, 270, 6, 0, 0, 0, 4608, 7369, 100, 115, 60, 70, 60, 30, 40, 100, 20, 10, 1978.8, -1761.96, 13.5466, 182.708, 1985.05, -1759.15, 13.5466, 'Hello, welcome to my Furniture Shop, make sure to buy everything you need.', 140, 190, 150, 60, 50, 5, 10, 5, 0, 0, 0),
232(93, 'Mercer Marijuana Distillery', 0, 1, 1, 2001.83, -1761.96, 13.5389, 182.751, -2158.73, 643.141, 1052.38, 190.97, 1, 0, 0, 0, 5258, 37, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 2001.83, -1761.96, 13.5389, 182.751, 0, 0, 0, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
233(95, 'Seville 24/7', 0, 1, 13000, 2723.93, -2026.5, 13.5471, 265.929, -25.8843, -185.869, 1003.55, 265.929, 17, 0, 0, 0, 4635, 56, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 2723.93, -2026.5, 13.5471, 265.929, 0, 0, 0, 'Welcome!', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
234(96, 'Ganton 24/7', 0, 1, 5000, 2424.09, -1742.62, 13.5438, 229.806, 6.0911, -29.2716, 1003.55, 229.806, 10, 0, 0, 0, 9020, 613, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 2424.09, -1742.62, 13.5438, 229.806, 2445.48, -1759.3, 13.5909, 'Welcome To Ganton 24/7! This is the Best 24/7 in Los Santos!', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
235(97, 'Tony''s', 0, 4, 25000, 2129.93, -1761.65, 13.5625, 180.733, -228.881, 1401.39, 27.7656, 272.372, 18, 0, 0, 1, 0, 100, 2, 5, 5, 10, 10, 15, 10, 0, 0, 0, 2129.93, -1761.65, 13.5625, 180.733, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
236(98, 'Benny''s Diner', 0, 4, 1, 2348.45, -1962.68, 13.5466, 187.052, -228.568, 1401.32, 27.7656, 274.618, 18, 0, 0, 1, 43, 93, 2, 5, 5, 10, 10, 15, 10, 0, 0, 0, 2348.45, -1962.68, 13.5466, 187.052, 0, 0, 0, '*The diner would be a bona fide shithole. It would not be unclean, but it would not be a place you''d choose to go to.*', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
237(99, 'Warehouse', 0, 1, 1, 2414.05, -1425.58, 23.9841, 265.331, 1076.53, 2078.36, 10.8203, 6.4917, 0, 0, 0, 1, 0, 100, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 2414.05, -1425.58, 23.9841, 265.331, 0, 0, 0, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
238(100, 'Commerce Night Club', 0, 1, 21000, 1726.9, -1636.59, 20.2171, 181.81, 493.564, -23.2842, 1000.68, 1.8106, 17, 0, 0, 0, 2, 99, 75, 125, 15, 100, 3, 2, 10, 100, 20, 10, 1726.9, -1636.59, 20.2171, 181.81, 0, 0, 0, '', 150, 200, 160, 60, 50, 5, 10, 5, 0, 0, 0),
239(101, 'Unnamed Business', 1, 5, 1, 1590.83, -2334.21, 13.5394, 90.409, 1494.56, 1304.21, 1093.29, 0, 3, 0, 0, 0, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1590.83, -2334.21, 13.5394, 90.409, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
240(102, 'Unnamed Business', 1, 2, 1, 1680.97, -2160.37, 13.5546, 275.844, 316.396, -169.837, 999.601, 0, 6, 0, 0, 0, 0, 1, 50, 100, 200, 400, 600, 800, 0, 0, 0, 0, 1680.97, -2160.37, 13.5546, 275.844, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
241(103, 'Unnamed Business', 0, 6, 1, 2762.12, -1911.89, 12.3403, 92.407, -27.3383, -57.6908, 1003.55, 0, 6, 0, 0, 1, 24, 100, 75, 115, 15, 90, 3, 2, 10, 90, 20, 10, 2762.12, -1911.89, 12.3403, 92.407, 0, 0, 0, '', 140, 150, 50, 40, 5, 10, 5, 0, 0, 0, 0);
242
243-- --------------------------------------------------------
244
245--
246-- Table structure for table `cars`
247--
248
249CREATE TABLE IF NOT EXISTS `cars` (
250 `carID` int(12) NOT NULL,
251 `carModel` int(12) DEFAULT '0',
252 `carOwner` int(12) DEFAULT '0',
253 `carPosX` float DEFAULT '0',
254 `carPosY` float DEFAULT '0',
255 `carPosZ` float DEFAULT '0',
256 `carPosR` float DEFAULT '0',
257 `carColor1` int(12) DEFAULT '0',
258 `carColor2` int(12) DEFAULT '0',
259 `carPaintjob` int(12) DEFAULT '-1',
260 `carLocked` int(4) DEFAULT '0',
261 `carMod1` int(12) DEFAULT '0',
262 `carMod2` int(12) DEFAULT '0',
263 `carMod3` int(12) DEFAULT '0',
264 `carMod4` int(12) DEFAULT '0',
265 `carMod5` int(12) DEFAULT '0',
266 `carMod6` int(12) DEFAULT '0',
267 `carMod7` int(12) DEFAULT '0',
268 `carMod8` int(12) DEFAULT '0',
269 `carMod9` int(12) DEFAULT '0',
270 `carMod10` int(12) DEFAULT '0',
271 `carMod11` int(12) DEFAULT '0',
272 `carMod12` int(12) DEFAULT '0',
273 `carMod13` int(12) DEFAULT '0',
274 `carMod14` int(12) DEFAULT '0',
275 `carImpounded` int(12) DEFAULT '0',
276 `carWeapon1` int(12) DEFAULT '0',
277 `carAmmo1` int(12) DEFAULT '0',
278 `carWeapon2` int(12) DEFAULT '0',
279 `carAmmo2` int(12) DEFAULT '0',
280 `carWeapon3` int(12) DEFAULT '0',
281 `carAmmo3` int(12) DEFAULT '0',
282 `carWeapon4` int(12) DEFAULT '0',
283 `carAmmo4` int(12) DEFAULT '0',
284 `carWeapon5` int(12) DEFAULT '0',
285 `carAmmo5` int(12) DEFAULT '0',
286 `carImpoundPrice` int(12) DEFAULT '0',
287 `carFaction` int(12) DEFAULT '0'
288) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=latin1;
289
290--
291-- Dumping data for table `cars`
292--
293
294INSERT INTO `cars` (`carID`, `carModel`, `carOwner`, `carPosX`, `carPosY`, `carPosZ`, `carPosR`, `carColor1`, `carColor2`, `carPaintjob`, `carLocked`, `carMod1`, `carMod2`, `carMod3`, `carMod4`, `carMod5`, `carMod6`, `carMod7`, `carMod8`, `carMod9`, `carMod10`, `carMod11`, `carMod12`, `carMod13`, `carMod14`, `carImpounded`, `carWeapon1`, `carAmmo1`, `carWeapon2`, `carAmmo2`, `carWeapon3`, `carAmmo3`, `carWeapon4`, `carAmmo4`, `carWeapon5`, `carAmmo5`, `carImpoundPrice`, `carFaction`) VALUES
295(11, 541, 0, 1602.18, -1683.97, 5.8906, 89.4865, 1, 0, -1, 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, 1),
296(13, 541, 0, 1602.21, -1688.14, 5.8906, 86.265, 1, 0, -1, 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, 1),
297(14, 560, 0, 1601.37, -1691.89, 5.8906, 89.4116, 0, 0, -1, 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, 1),
298(15, 560, 0, 1601.83, -1696.02, 5.8906, 84.9687, 0, 0, -1, 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, 1),
299(16, 426, 0, 1602.31, -1700.22, 5.8906, 87.9125, 0, 0, -1, 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, 1),
300(17, 426, 0, 1601.87, -1704.17, 5.8906, 87.3421, 0, 0, -1, 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, 1),
301(18, 523, 0, 1602.67, -1710.49, 5.4633, 60.7625, 0, 0, -1, 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, 1),
302(19, 523, 0, 1601.21, -1712.19, 5.4633, 20.2916, 0, 0, -1, 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, 1),
303(20, 596, 0, 1595.47, -1710.98, 5.8906, 355.68, 0, 1, -1, 0, 0, 0, 0, 0, 0, 1010, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
304(21, 596, 0, 1591.29, -1710.73, 5.8906, 356.049, 0, 1, -1, 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, 1),
305(22, 596, 0, 1587.55, -1710.6, 5.8906, 359.608, 0, 1, -1, 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, 1),
306(23, 596, 0, 1583.35, -1711.05, 5.8906, 359.609, 0, 1, -1, 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, 1),
307(24, 596, 0, 1578.52, -1711.94, 5.8906, 0.5485, 0, 1, -1, 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, 1),
308(25, 596, 0, 1574.46, -1711.02, 5.8906, 1.5116, 0, 1, -1, 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, 1),
309(26, 597, 0, 1570.41, -1711.83, 5.8906, 358.748, 0, 1, -1, 1, 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, 1),
310(27, 597, 0, 1565.65, -1711.57, 5.8906, 355.671, 0, 1, -1, 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, 1),
311(28, 597, 0, 1560.48, -1711, 5.8906, 356.98, 0, 1, -1, 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, 1),
312(31, 427, 0, 1544.46, -1684.5, 5.8906, 90.4437, 0, 1, -1, 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, 1),
313(32, 427, 0, 1544.91, -1680.35, 6.0221, 90.3821, 0, 1, -1, 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, 1),
314(33, 528, 0, 1544.28, -1676.22, 5.8906, 89.4535, 0, 1, -1, 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, 1),
315(34, 490, 0, 1545.81, -1668.03, 6.0192, 88.6512, 0, 0, -1, 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, 1),
316(35, 490, 0, 1545.74, -1672.05, 6.019, 88.6813, 0, 0, -1, 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, 1),
317(36, 599, 0, 1585.51, -1671.8, 5.8921, 272.999, 0, 1, -1, 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, 1),
318(37, 599, 0, 1585.43, -1667.66, 5.8922, 272.373, 0, 1, -1, 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, 1),
319(70, 414, 0, 2457.89, -2117.29, 13.5529, 357.777, 0, 3, -1, 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),
320(71, 414, 0, 2464.91, -2116.77, 13.5468, 0.2668, 0, 3, -1, 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),
321(72, 414, 0, 2472.18, -2116.59, 13.5468, 359.438, 4, 4, -1, 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),
322(73, 414, 0, 2479.06, -2116.44, 13.5468, 352.896, 3, 3, -1, 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),
323(74, 414, 0, 2487.6, -2116.92, 13.5468, 2.5369, 41, 14, -1, 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),
324(116, 499, 0, 2469.19, -2074.92, 13.5468, 181.161, 108, 34, -1, 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),
325(137, 544, 0, 1751.38, -1137.71, 24.325, 181.192, 3, 3, -1, 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),
326(138, 544, 0, 1742.26, -1136.88, 24.0781, 179.594, 3, 29, -1, 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),
327(139, 407, 0, 1733.99, -1136.07, 24.0859, 180.171, 3, 45, -1, 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),
328(140, 407, 0, 1725.32, -1135.44, 24.0859, 177.475, 3, 66, -1, 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),
329(141, 416, 0, 1717.05, -1135.58, 24.0781, 179.167, 3, 49, -1, 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),
330(142, 490, 0, 1708.21, -1135.17, 24.0859, 179.517, 3, 3, -1, 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),
331(143, 427, 0, 1734.25, -1101.34, 24.0781, 0.6202, 3, 1, -1, 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),
332(144, 427, 0, 1725.12, -1101.7, 24.0859, 1.1467, 3, 1, -1, 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),
333(145, 416, 0, 1716.92, -1101.55, 24.0781, 358.626, 3, 1, -1, 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),
334(146, 490, 0, 1708.24, -1100.78, 24.0781, 359.253, 3, 3, -1, 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),
335(147, 499, 0, 2458.08, -2077.07, 13.5468, 180.891, 41, 33, -1, 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),
336(153, 596, 0, 1535.95, -1677.98, 14.4011, 2.3376, 0, 1, -1, 1, 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, 1),
337(193, 503, 0, -1494.6, 957.99, 1037, 307.061, 0, 0, -1, 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),
338(195, 494, 0, -1497.29, 959.981, 1037.03, 311.762, 3, 3, -1, 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),
339(216, 504, 0, 2668.83, -1706.16, 10.0866, 282.608, 83, 112, -1, 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),
340(239, 597, 0, 1528.35, -1683.68, 5.8906, 266.746, 0, 0, -1, 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, 1),
341(241, 427, 1, 1669.07, -2181.7, 13.812, 0.0559, 1, 1, -1, 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, 1, 0);
342
343-- --------------------------------------------------------
344
345--
346-- Table structure for table `carstorage`
347--
348
349CREATE TABLE IF NOT EXISTS `carstorage` (
350 `ID` int(12) DEFAULT '0',
351 `itemID` int(12) NOT NULL,
352 `itemName` varchar(32) DEFAULT NULL,
353 `itemModel` int(12) DEFAULT '0',
354 `itemQuantity` int(12) DEFAULT '0'
355) ENGINE=InnoDB DEFAULT CHARSET=latin1;
356
357-- --------------------------------------------------------
358
359--
360-- Table structure for table `characters`
361--
362
363CREATE TABLE IF NOT EXISTS `characters` (
364 `ID` int(12) NOT NULL,
365 `Username` varchar(24) DEFAULT NULL,
366 `Character` varchar(24) DEFAULT NULL,
367 `Created` int(4) DEFAULT '0',
368 `Gender` int(4) DEFAULT '0',
369 `Birthdate` varchar(32) DEFAULT '01/01/1970',
370 `Origin` varchar(32) DEFAULT 'Not Specified',
371 `Skin` int(12) DEFAULT '0',
372 `Glasses` int(12) DEFAULT '0',
373 `Hat` int(12) DEFAULT '0',
374 `Bandana` int(12) DEFAULT '0',
375 `PosX` float DEFAULT '0',
376 `PosY` float DEFAULT '0',
377 `PosZ` float DEFAULT '0',
378 `PosA` float DEFAULT '0',
379 `Interior` int(12) DEFAULT '0',
380 `World` int(12) DEFAULT '0',
381 `GlassesPos` varchar(100) DEFAULT NULL,
382 `HatPos` varchar(100) DEFAULT NULL,
383 `BandanaPos` varchar(100) DEFAULT NULL,
384 `Hospital` int(12) DEFAULT '-1',
385 `HospitalInt` int(12) DEFAULT '0',
386 `Money` int(12) DEFAULT '0',
387 `BankMoney` int(12) DEFAULT '0',
388 `OwnsBillboard` int(12) DEFAULT '-1',
389 `Savings` int(12) DEFAULT '0',
390 `Admin` int(12) DEFAULT '0',
391 `JailTime` int(12) DEFAULT '0',
392 `Muted` int(4) DEFAULT '0',
393 `CreateDate` int(12) DEFAULT '0',
394 `LastLogin` int(12) DEFAULT '0',
395 `Tester` int(4) DEFAULT '0',
396 `Gun1` int(12) DEFAULT '0',
397 `Gun2` int(12) DEFAULT '0',
398 `Gun3` int(12) DEFAULT '0',
399 `Gun4` int(12) DEFAULT '0',
400 `Gun5` int(12) DEFAULT '0',
401 `Gun6` int(12) DEFAULT '0',
402 `Gun7` int(12) DEFAULT '0',
403 `Gun8` int(12) DEFAULT '0',
404 `Gun9` int(12) DEFAULT '0',
405 `Gun10` int(12) DEFAULT '0',
406 `Gun11` int(12) DEFAULT '0',
407 `Gun12` int(12) DEFAULT '0',
408 `Gun13` int(12) DEFAULT '0',
409 `Ammo1` int(12) DEFAULT '0',
410 `Ammo2` int(12) DEFAULT '0',
411 `Ammo3` int(12) DEFAULT '0',
412 `Ammo4` int(12) DEFAULT '0',
413 `Ammo5` int(12) DEFAULT '0',
414 `Ammo6` int(12) DEFAULT '0',
415 `Ammo7` int(12) DEFAULT '0',
416 `Ammo8` int(12) DEFAULT '0',
417 `Ammo9` int(12) DEFAULT '0',
418 `Ammo10` int(12) DEFAULT '0',
419 `Ammo11` int(12) DEFAULT '0',
420 `Ammo12` int(12) DEFAULT '0',
421 `Ammo13` int(12) DEFAULT '0',
422 `House` int(12) DEFAULT '-1',
423 `Business` int(12) DEFAULT '-1',
424 `Phone` int(12) DEFAULT '0',
425 `Lottery` int(12) DEFAULT '0',
426 `Hunger` int(12) DEFAULT '100',
427 `Thirst` int(12) DEFAULT '100',
428 `PlayingHours` int(12) DEFAULT '0',
429 `Minutes` int(12) DEFAULT '0',
430 `ArmorStatus` float DEFAULT '0',
431 `Entrance` int(12) DEFAULT '0',
432 `Job` int(12) DEFAULT '0',
433 `Faction` int(12) DEFAULT '-1',
434 `FactionRank` int(12) DEFAULT '0',
435 `Prisoned` int(4) DEFAULT '0',
436 `Warrants` int(12) DEFAULT '0',
437 `Injured` int(4) DEFAULT '0',
438 `Health` float DEFAULT '0',
439 `Channel` int(12) DEFAULT '0',
440 `Accent` varchar(24) DEFAULT NULL,
441 `Bleeding` int(4) DEFAULT '0',
442 `Warnings` int(12) DEFAULT '0',
443 `Warn1` varchar(32) DEFAULT NULL,
444 `Warn2` varchar(32) DEFAULT NULL,
445 `Donator` int(11) NOT NULL,
446 `MaskID` int(12) DEFAULT '0',
447 `FactionMod` int(12) DEFAULT '0',
448 `Capacity` int(12) DEFAULT '35',
449 `AdminHide` int(4) DEFAULT '0',
450 `LotteryB` int(11) NOT NULL,
451 `SpawnPoint` int(11) NOT NULL
452) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
453
454--
455-- Dumping data for table `characters`
456--
457
458-- --------------------------------------------------------
459
460--
461-- Table structure for table `contacts`
462--
463
464CREATE TABLE IF NOT EXISTS `contacts` (
465 `ID` int(12) DEFAULT '0',
466 `contactID` int(12) NOT NULL,
467 `contactName` varchar(32) DEFAULT NULL,
468 `contactNumber` int(12) DEFAULT '0'
469) ENGINE=InnoDB DEFAULT CHARSET=latin1;
470
471-- --------------------------------------------------------
472
473--
474-- Table structure for table `crates`
475--
476
477CREATE TABLE IF NOT EXISTS `crates` (
478 `crateID` int(12) NOT NULL,
479 `crateType` int(12) DEFAULT '0',
480 `crateX` float DEFAULT '0',
481 `crateY` float DEFAULT '0',
482 `crateZ` float DEFAULT '0',
483 `crateA` float DEFAULT '0',
484 `crateInterior` int(12) DEFAULT '0',
485 `crateWorld` int(12) DEFAULT '0'
486) ENGINE=InnoDB DEFAULT CHARSET=latin1;
487
488-- --------------------------------------------------------
489
490--
491-- Table structure for table `dealervehicles`
492--
493
494CREATE TABLE IF NOT EXISTS `dealervehicles` (
495 `ID` int(12) DEFAULT '0',
496 `vehID` int(12) NOT NULL,
497 `vehModel` int(12) DEFAULT '0',
498 `vehPrice` int(12) DEFAULT '0'
499) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=latin1;
500
501--
502-- Dumping data for table `dealervehicles`
503--
504
505INSERT INTO `dealervehicles` (`ID`, `vehID`, `vehModel`, `vehPrice`) VALUES
506(18, 19, 400, 5000),
507(18, 20, 401, 2300),
508(18, 21, 405, 7650),
509(18, 22, 413, 3000),
510(18, 23, 562, 12000),
511(18, 24, 541, 20000),
512(18, 25, 415, 17000),
513(18, 26, 402, 5000),
514(18, 27, 451, 15000),
515(18, 28, 580, 12000),
516(18, 29, 426, 3000),
517(18, 30, 566, 2500),
518(18, 31, 458, 1500),
519(18, 32, 496, 3200),
520(18, 33, 559, 10000),
521(18, 34, 517, 4000),
522(18, 35, 550, 4000),
523(18, 36, 560, 8000),
524(18, 37, 468, 1500),
525(18, 38, 461, 2000),
526(18, 39, 471, 1000),
527(18, 40, 521, 2000),
528(18, 41, 522, 2500),
529(18, 42, 445, 1500),
530(18, 43, 534, 1800),
531(18, 44, 500, 4000),
532(37, 45, 400, 3700),
533(37, 46, 401, 1650),
534(37, 48, 404, 1200),
535(37, 49, 405, 3100),
536(37, 50, 409, 7000),
537(37, 51, 410, 2400),
538(37, 53, 412, 4000),
539(37, 54, 413, 3200),
540(37, 57, 418, 4600),
541(37, 58, 419, 1000),
542(37, 59, 426, 12000),
543(37, 60, 420, 4200),
544(37, 61, 422, 800),
545(37, 62, 445, 8000),
546(37, 63, 421, 3450),
547(37, 64, 458, 9000),
548(37, 66, 579, 42000),
549(37, 68, 562, 24000),
550(53, 69, 462, 350),
551(53, 70, 463, 650),
552(53, 71, 468, 1000),
553(53, 72, 586, 950),
554(53, 73, 581, 1750),
555(54, 74, 487, 175000),
556(54, 75, 511, 280000),
557(54, 76, 593, 95000),
558(37, 77, 566, 7500),
559(37, 78, 463, 1200),
560(37, 79, 481, 500),
561(62, 80, 414, 57500),
562(62, 81, 413, 35000),
563(62, 82, 440, 2350),
564(62, 83, 455, 17500),
565(62, 84, 456, 27500),
566(62, 85, 498, 17850),
567(62, 86, 609, 23500),
568(62, 87, 525, 3500),
569(37, 89, 439, 4300),
570(37, 90, 467, 2300),
571(37, 91, 475, 4800),
572(37, 92, 479, 2300),
573(37, 93, 489, 6500),
574(37, 94, 559, 23500),
575(37, 95, 565, 16500),
576(37, 96, 567, 6550),
577(37, 97, 576, 4300),
578(37, 98, 580, 4500),
579(37, 99, 585, 4600),
580(37, 100, 600, 2990),
581(37, 101, 602, 8500),
582(37, 102, 603, 9500),
583(64, 105, 463, 700),
584(64, 106, 461, 2350),
585(64, 108, 468, 1750),
586(64, 109, 586, 600),
587(37, 110, 525, 10000),
588(89, 111, 566, 3500),
589(89, 112, 525, 8500),
590(89, 113, 401, 2600),
591(89, 115, 405, 11000),
592(89, 116, 521, 28000),
593(89, 117, 400, 14000),
594(89, 118, 404, 4300),
595(89, 119, 410, 2000),
596(89, 120, 412, 6800),
597(89, 121, 421, 9100),
598(89, 122, 426, 14500),
599(89, 123, 422, 3000),
600(89, 124, 442, 6700),
601(89, 125, 445, 8700),
602(89, 126, 458, 8900),
603(89, 127, 463, 6000),
604(89, 128, 462, 1000),
605(89, 129, 467, 4100),
606(89, 130, 475, 8000),
607(89, 131, 478, 900),
608(89, 132, 482, 5000),
609(89, 133, 491, 4000),
610(89, 134, 492, 3000),
611(89, 135, 516, 8700),
612(89, 136, 540, 4500),
613(89, 137, 546, 5900),
614(89, 138, 551, 6000),
615(89, 139, 550, 3900),
616(89, 140, 499, 4000),
617(89, 141, 508, 7000),
618(89, 142, 547, 4000),
619(64, 143, 481, 400),
620(64, 144, 521, 2800),
621(64, 145, 581, 2650),
622(37, 146, 560, 75000),
623(101, 147, 427, 1);
624
625-- --------------------------------------------------------
626
627--
628-- Table structure for table `detectors`
629--
630
631CREATE TABLE IF NOT EXISTS `detectors` (
632 `detectorID` int(12) NOT NULL,
633 `detectorX` float DEFAULT '0',
634 `detectorY` float DEFAULT '0',
635 `detectorZ` float DEFAULT '0',
636 `detectorAngle` float DEFAULT '0',
637 `detectorInterior` int(12) DEFAULT '0',
638 `detectorWorld` int(12) DEFAULT '0'
639) ENGINE=MyISAM DEFAULT CHARSET=latin1;
640
641-- --------------------------------------------------------
642
643--
644-- Table structure for table `dropped`
645--
646
647CREATE TABLE IF NOT EXISTS `dropped` (
648 `ID` int(12) NOT NULL,
649 `itemName` varchar(32) DEFAULT NULL,
650 `itemModel` int(12) DEFAULT '0',
651 `itemX` float DEFAULT '0',
652 `itemY` float DEFAULT '0',
653 `itemZ` float DEFAULT '0',
654 `itemInt` int(12) DEFAULT '0',
655 `itemWorld` int(12) DEFAULT '0',
656 `itemQuantity` int(12) DEFAULT '0',
657 `itemAmmo` int(12) DEFAULT '0',
658 `itemWeapon` int(12) DEFAULT '0',
659 `itemPlayer` varchar(24) DEFAULT NULL
660) ENGINE=InnoDB DEFAULT CHARSET=latin1;
661
662-- --------------------------------------------------------
663
664--
665-- Table structure for table `entrances`
666--
667
668CREATE TABLE IF NOT EXISTS `entrances` (
669 `entranceID` int(12) NOT NULL,
670 `entranceName` varchar(32) DEFAULT NULL,
671 `entranceIcon` int(12) DEFAULT '0',
672 `entrancePosX` float DEFAULT '0',
673 `entrancePosY` float DEFAULT '0',
674 `entrancePosZ` float DEFAULT '0',
675 `entrancePosA` float DEFAULT '0',
676 `entranceIntX` float DEFAULT '0',
677 `entranceIntY` float DEFAULT '0',
678 `entranceIntZ` float DEFAULT '0',
679 `entranceIntA` float DEFAULT '0',
680 `entranceInterior` int(12) DEFAULT '0',
681 `entranceExterior` int(12) DEFAULT '0',
682 `entranceExteriorVW` int(12) DEFAULT '0',
683 `entranceType` int(12) DEFAULT '0',
684 `entrancePass` varchar(32) DEFAULT NULL,
685 `entranceLocked` int(12) DEFAULT '0',
686 `entranceCustom` int(4) DEFAULT '0',
687 `entranceWorld` int(12) DEFAULT '0'
688) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;
689
690--
691-- Dumping data for table `entrances`
692--
693
694INSERT INTO `entrances` (`entranceID`, `entranceName`, `entranceIcon`, `entrancePosX`, `entrancePosY`, `entrancePosZ`, `entrancePosA`, `entranceIntX`, `entranceIntY`, `entranceIntZ`, `entranceIntA`, `entranceInterior`, `entranceExterior`, `entranceExteriorVW`, `entranceType`, `entrancePass`, `entranceLocked`, `entranceCustom`, `entranceWorld`) VALUES
695(7, 'San Fierro Roleplay', 0, -1605.49, 711.306, 13.8671, 182.47, 1587.61, -1709.62, -36.8138, 182.455, 1, 0, 0, 0, '', 0, 0, 0),
696(8, 'Department of Motor Vehicles', 0, -2026.62, -101.736, 35.164, 172.514, -2029.55, -118.8, 1035.17, 0, 3, 0, 0, 1, 'San Fierro Roleplay', 0, 0, 7008),
697(10, 'Downtown Bank', 0, -2055.41, 455.282, 35.1718, 141.754, 1456.19, -987.942, 996.105, 90, 6, 0, 0, 2, 'Department of Motor Vehicles', 0, 0, 7010),
698(12, 'San Fierro Cityhall', 0, -1493.9, 919.842, 7.1875, 271.94, 390.169, 173.807, 1008.38, 90, 3, 0, 0, 4, 'San Fierro Cityhall', 0, 0, 7012),
699(14, 'Downtown Apartment Complex', 0, -1754.19, 962.555, 24.8828, 3.8796, 2214.8, -1150.34, 1025.8, 276.821, 15, 0, 0, 0, 'San Fierro Cityhall', 0, 0, 7014),
700(54, 'Master Bedroom', 0, 134.639, 1379.96, 1088.37, 93.0609, 134.639, 1379.96, 11088.4, 0, 0, 5, 5006, 0, '', 0, 0, 7054),
701(55, 'Los Santos Stadium', 0, 2695.35, -1704.55, 11.8437, 227.137, -1464.28, 1557.01, 1052.53, 342.974, 14, 0, 0, 0, '', 0, 0, 7055);
702
703-- --------------------------------------------------------
704
705--
706-- Table structure for table `factions`
707--
708
709CREATE TABLE IF NOT EXISTS `factions` (
710 `factionID` int(12) NOT NULL,
711 `factionName` varchar(32) DEFAULT NULL,
712 `factionColor` int(12) DEFAULT '0',
713 `factionType` int(12) DEFAULT '0',
714 `factionRanks` int(12) DEFAULT '0',
715 `factionLockerX` float DEFAULT '0',
716 `factionLockerY` float DEFAULT '0',
717 `factionLockerZ` float DEFAULT '0',
718 `factionLockerInt` int(12) DEFAULT '0',
719 `factionLockerWorld` int(12) DEFAULT '0',
720 `factionWeapon1` int(12) DEFAULT '0',
721 `factionAmmo1` int(12) DEFAULT '0',
722 `factionWeapon2` int(12) DEFAULT '0',
723 `factionAmmo2` int(12) DEFAULT '0',
724 `factionWeapon3` int(12) DEFAULT '0',
725 `factionAmmo3` int(12) DEFAULT '0',
726 `factionWeapon4` int(12) DEFAULT '0',
727 `factionAmmo4` int(12) DEFAULT '0',
728 `factionWeapon5` int(12) DEFAULT '0',
729 `factionAmmo5` int(12) DEFAULT '0',
730 `factionWeapon6` int(12) DEFAULT '0',
731 `factionAmmo6` int(12) DEFAULT '0',
732 `factionWeapon7` int(12) DEFAULT '0',
733 `factionAmmo7` int(12) DEFAULT '0',
734 `factionWeapon8` int(12) DEFAULT '0',
735 `factionAmmo8` int(12) DEFAULT '0',
736 `factionWeapon9` int(12) DEFAULT '0',
737 `factionAmmo9` int(12) DEFAULT '0',
738 `factionWeapon10` int(12) DEFAULT '0',
739 `factionAmmo10` int(12) DEFAULT '0',
740 `factionRank1` varchar(32) DEFAULT NULL,
741 `factionRank2` varchar(32) DEFAULT NULL,
742 `factionRank3` varchar(32) DEFAULT NULL,
743 `factionRank4` varchar(32) DEFAULT NULL,
744 `factionRank5` varchar(32) DEFAULT NULL,
745 `factionRank6` varchar(32) DEFAULT NULL,
746 `factionRank7` varchar(32) DEFAULT NULL,
747 `factionRank8` varchar(32) DEFAULT NULL,
748 `factionRank9` varchar(32) DEFAULT NULL,
749 `factionRank10` varchar(32) DEFAULT NULL,
750 `factionRank11` varchar(32) DEFAULT NULL,
751 `factionRank12` varchar(32) DEFAULT NULL,
752 `factionRank13` varchar(32) DEFAULT NULL,
753 `factionRank14` varchar(32) DEFAULT NULL,
754 `factionRank15` varchar(32) DEFAULT NULL,
755 `factionSkin1` int(12) DEFAULT '0',
756 `factionSkin2` int(12) DEFAULT '0',
757 `factionSkin3` int(12) DEFAULT '0',
758 `factionSkin4` int(12) DEFAULT '0',
759 `factionSkin5` int(12) DEFAULT '0',
760 `factionSkin6` int(12) DEFAULT '0',
761 `factionSkin7` int(12) DEFAULT '0',
762 `factionSkin8` int(12) DEFAULT '0',
763 `SpawnX` float NOT NULL,
764 `SpawnY` float NOT NULL,
765 `SpawnZ` float NOT NULL,
766 `SpawnInterior` int(11) NOT NULL,
767 `SpawnVW` int(1) NOT NULL
768) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
769
770--
771-- Dumping data for table `factions`
772--
773
774INSERT INTO `factions` (`factionID`, `factionName`, `factionColor`, `factionType`, `factionRanks`, `factionLockerX`, `factionLockerY`, `factionLockerZ`, `factionLockerInt`, `factionLockerWorld`, `factionWeapon1`, `factionAmmo1`, `factionWeapon2`, `factionAmmo2`, `factionWeapon3`, `factionAmmo3`, `factionWeapon4`, `factionAmmo4`, `factionWeapon5`, `factionAmmo5`, `factionWeapon6`, `factionAmmo6`, `factionWeapon7`, `factionAmmo7`, `factionWeapon8`, `factionAmmo8`, `factionWeapon9`, `factionAmmo9`, `factionWeapon10`, `factionAmmo10`, `factionRank1`, `factionRank2`, `factionRank3`, `factionRank4`, `factionRank5`, `factionRank6`, `factionRank7`, `factionRank8`, `factionRank9`, `factionRank10`, `factionRank11`, `factionRank12`, `factionRank13`, `factionRank14`, `factionRank15`, `factionSkin1`, `factionSkin2`, `factionSkin3`, `factionSkin4`, `factionSkin5`, `factionSkin6`, `factionSkin7`, `factionSkin8`, `SpawnX`, `SpawnY`, `SpawnZ`, `SpawnInterior`, `SpawnVW`) VALUES
775(1, 'California Highway Patrol', -256, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rank 1', 'Rank 2', 'Rank 3', 'Rank 4', 'Rank 5', 'Rank 6', 'Rank 7', 'Rank 8', 'Rank 9', 'Rank 10', 'Rank 11', 'Rank 12', 'Rank 13', 'Rank 14', 'Rank 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
776(2, 'Dual''s Test Gang - Will be dele', -256, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Rank 1', 'Rank 2', 'Rank 3', 'Rank 4', 'Rank 5', 'Rank 6', 'Rank 7', 'Rank 8', 'Rank 9', 'Rank 10', 'Rank 11', 'Rank 12', 'Rank 13', 'Rank 14', 'Rank 15', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
777
778-- --------------------------------------------------------
779
780--
781-- Table structure for table `furniture`
782--
783
784CREATE TABLE IF NOT EXISTS `furniture` (
785 `ID` int(12) DEFAULT '0',
786 `furnitureID` int(12) NOT NULL,
787 `furnitureName` varchar(32) DEFAULT NULL,
788 `furnitureModel` int(12) DEFAULT '0',
789 `furnitureX` float DEFAULT '0',
790 `furnitureY` float DEFAULT '0',
791 `furnitureZ` float DEFAULT '0',
792 `furnitureRX` float DEFAULT '0',
793 `furnitureRY` float DEFAULT '0',
794 `furnitureRZ` float DEFAULT '0',
795 `furnitureType` int(12) DEFAULT '0'
796) ENGINE=InnoDB DEFAULT CHARSET=latin1;
797
798-- --------------------------------------------------------
799
800--
801-- Table structure for table `garbage`
802--
803
804CREATE TABLE IF NOT EXISTS `garbage` (
805 `garbageID` int(12) NOT NULL,
806 `garbageModel` int(12) DEFAULT '1236',
807 `garbageCapacity` int(12) DEFAULT '0',
808 `garbageX` float DEFAULT '0',
809 `garbageY` float DEFAULT '0',
810 `garbageZ` float DEFAULT '0',
811 `garbageA` float DEFAULT '0',
812 `garbageInterior` int(12) DEFAULT '0',
813 `garbageWorld` int(12) DEFAULT '0'
814) ENGINE=InnoDB DEFAULT CHARSET=latin1;
815
816-- --------------------------------------------------------
817
818--
819-- Table structure for table `gates`
820--
821
822CREATE TABLE IF NOT EXISTS `gates` (
823 `gateID` int(12) NOT NULL,
824 `gateModel` int(12) DEFAULT '0',
825 `gateSpeed` float DEFAULT '0',
826 `gateTime` int(12) DEFAULT '0',
827 `gateX` float DEFAULT '0',
828 `gateY` float DEFAULT '0',
829 `gateZ` float DEFAULT '0',
830 `gateRX` float DEFAULT '0',
831 `gateRY` float DEFAULT '0',
832 `gateRZ` float DEFAULT '0',
833 `gateInterior` int(12) DEFAULT '0',
834 `gateWorld` int(12) DEFAULT '0',
835 `gateMoveX` float DEFAULT '0',
836 `gateMoveY` float DEFAULT '0',
837 `gateMoveZ` float DEFAULT '0',
838 `gateMoveRX` float DEFAULT '0',
839 `gateMoveRY` float DEFAULT '0',
840 `gateMoveRZ` float DEFAULT '0',
841 `gateLinkID` int(12) DEFAULT '0',
842 `gateFaction` int(12) DEFAULT '0',
843 `gatePass` varchar(32) DEFAULT NULL,
844 `gateRadius` float DEFAULT '0'
845) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
846
847-- --------------------------------------------------------
848
849--
850-- Table structure for table `gps`
851--
852
853CREATE TABLE IF NOT EXISTS `gps` (
854 `ID` int(12) DEFAULT '0',
855 `locationID` int(12) NOT NULL,
856 `locationName` varchar(32) DEFAULT NULL,
857 `locationX` float DEFAULT '0',
858 `locationY` float DEFAULT '0',
859 `locationZ` float DEFAULT '0'
860) ENGINE=InnoDB DEFAULT CHARSET=latin1;
861
862-- --------------------------------------------------------
863
864--
865-- Table structure for table `graffiti`
866--
867
868CREATE TABLE IF NOT EXISTS `graffiti` (
869 `graffitiID` int(12) NOT NULL,
870 `graffitiX` float DEFAULT '0',
871 `graffitiY` float DEFAULT '0',
872 `graffitiZ` float DEFAULT '0',
873 `graffitiAngle` float DEFAULT '0',
874 `graffitiColor` int(12) DEFAULT '0',
875 `graffitiText` varchar(64) DEFAULT NULL
876) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
877
878--
879-- Dumping data for table `graffiti`
880--
881
882INSERT INTO `graffiti` (`graffitiID`, `graffitiX`, `graffitiY`, `graffitiZ`, `graffitiAngle`, `graffitiColor`, `graffitiText`) VALUES
883(1, 1674.26, -2156.57, 12.9646, -89.8736, -1, 'Graffiti');
884
885-- --------------------------------------------------------
886
887--
888-- Table structure for table `gunracks`
889--
890
891CREATE TABLE IF NOT EXISTS `gunracks` (
892 `rackID` int(12) NOT NULL,
893 `rackHouse` int(12) DEFAULT '0',
894 `rackX` float DEFAULT '0',
895 `rackY` float DEFAULT '0',
896 `rackZ` float DEFAULT '0',
897 `rackA` float DEFAULT '0',
898 `rackInterior` int(12) DEFAULT '0',
899 `rackWorld` int(12) DEFAULT '0',
900 `rackWeapon1` int(12) DEFAULT '0',
901 `rackAmmo1` int(12) DEFAULT '0',
902 `rackWeapon2` int(12) DEFAULT '0',
903 `rackAmmo2` int(12) DEFAULT '0',
904 `rackWeapon3` int(12) DEFAULT '0',
905 `rackAmmo3` int(12) DEFAULT '0',
906 `rackWeapon4` int(12) DEFAULT '0',
907 `rackAmmo4` int(12) DEFAULT '0'
908) ENGINE=InnoDB DEFAULT CHARSET=latin1;
909
910-- --------------------------------------------------------
911
912--
913-- Table structure for table `houses`
914--
915
916CREATE TABLE IF NOT EXISTS `houses` (
917 `houseID` int(12) NOT NULL,
918 `houseOwner` int(12) DEFAULT '0',
919 `housePrice` int(12) DEFAULT '0',
920 `houseAddress` varchar(32) DEFAULT NULL,
921 `housePosX` float DEFAULT '0',
922 `housePosY` float DEFAULT '0',
923 `housePosZ` float DEFAULT '0',
924 `housePosA` float DEFAULT '0',
925 `houseIntX` float DEFAULT '0',
926 `houseIntY` float DEFAULT '0',
927 `houseIntZ` float DEFAULT '0',
928 `houseIntA` float DEFAULT '0',
929 `houseInterior` int(12) DEFAULT '0',
930 `houseExterior` int(12) DEFAULT '0',
931 `houseExteriorVW` int(12) DEFAULT '0',
932 `houseLocked` int(4) DEFAULT '0',
933 `houseWeapon1` int(12) DEFAULT '0',
934 `houseAmmo1` int(12) DEFAULT '0',
935 `houseWeapon2` int(12) DEFAULT '0',
936 `houseAmmo2` int(12) DEFAULT '0',
937 `houseWeapon3` int(12) DEFAULT '0',
938 `houseAmmo3` int(12) DEFAULT '0',
939 `houseWeapon4` int(12) DEFAULT '0',
940 `houseAmmo4` int(12) DEFAULT '0',
941 `houseWeapon5` int(12) DEFAULT '0',
942 `houseAmmo5` int(12) DEFAULT '0',
943 `houseWeapon6` int(12) DEFAULT '0',
944 `houseAmmo6` int(12) DEFAULT '0',
945 `houseWeapon7` int(12) DEFAULT '0',
946 `houseAmmo7` int(12) DEFAULT '0',
947 `houseWeapon8` int(12) DEFAULT '0',
948 `houseAmmo8` int(12) DEFAULT '0',
949 `houseWeapon9` int(12) DEFAULT '0',
950 `houseAmmo9` int(12) DEFAULT '0',
951 `houseWeapon10` int(12) DEFAULT '0',
952 `houseAmmo10` int(12) DEFAULT '0',
953 `houseMoney` int(12) DEFAULT '0'
954) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=latin1;
955
956--
957-- Dumping data for table `houses`
958--
959
960INSERT INTO `houses` (`houseID`, `houseOwner`, `housePrice`, `houseAddress`, `housePosX`, `housePosY`, `housePosZ`, `housePosA`, `houseIntX`, `houseIntY`, `houseIntZ`, `houseIntA`, `houseInterior`, `houseExterior`, `houseExteriorVW`, `houseLocked`, `houseWeapon1`, `houseAmmo1`, `houseWeapon2`, `houseAmmo2`, `houseWeapon3`, `houseAmmo3`, `houseWeapon4`, `houseAmmo4`, `houseWeapon5`, `houseAmmo5`, `houseWeapon6`, `houseAmmo6`, `houseWeapon7`, `houseAmmo7`, `houseWeapon8`, `houseAmmo8`, `houseWeapon9`, `houseAmmo9`, `houseWeapon10`, `houseAmmo10`, `houseMoney`) VALUES
961(2, 0, 1, '2065 Campanella Park', 2157.38, -1709.01, 15.0859, 165.058, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
962(3, 0, 1, '424 Echo Parque', 2095.36, -1145.09, 26.5928, 276.9, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
963(4, 0, 1, '300 Echo Parque', 2092.24, -1166.35, 26.5858, 267.187, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
964(5, 0, 1, '632 Dead End, El Corona', 1804.1, -2124.9, 13.942, 182.539, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
965(6, 0, 1, '732 Richman Hills', 189.637, -1308.13, 70.2491, 94.0185, 140.309, 1366.82, 1083.86, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50000),
966(7, 0, 1, '527 Cardinal Park', 2150.92, -1419.09, 25.9218, 279.49, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
967(8, 0, 1, '765 Richman Hills', 253.185, -1270.02, 74.43, 216.22, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
968(9, 0, 1, '162 Temple Drive', 1325.95, -1067.66, 31.5545, 92.6201, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
969(10, 0, 1, '1030 Idlewood', 2067.05, -1731.53, 14.2066, 89.8861, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
970(11, 0, 1, '1031 Idlewood', 2066.24, -1717.09, 14.1363, 91.6212, 2269.88, -1210.32, 1047.56, 90, 10, 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(12, 0, 1, '1032 Idlewood', 2065.1, -1703.57, 14.1484, 95.068, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 24, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
972(13, 0, 5000, '1033 Idlewood', 2066.74, -1656.6, 14.1328, 89.4279, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
973(14, 0, 5000, '1034 Idlewood', 2067.56, -1643.71, 14.1363, 85.9812, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
974(15, 0, 5000, '1035 Idlewood', 2067.7, -1628.86, 14.2066, 89.4279, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 24, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
975(16, 0, 5000, '1036 Idlewood', 2018.05, -1629.92, 14.0424, 269.283, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
976(17, 0, 5000, '1037 Idlewood', 2016.54, -1641.55, 14.1127, 272.416, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
977(18, 0, 5000, '1038 Idlewood', 2013.58, -1656.45, 14.1363, 267.863, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
978(19, 0, 5000, '1039 Idlewood', 2018.24, -1703.28, 14.2341, 274.296, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
979(20, 0, 5000, '1040 Idlewood', 2016.2, -1716.93, 14.125, 267.716, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 33, 5, 29, 40, 30, 142, 4, 21, 0, 0, 31, 194, 29, 198, 25, 50, 24, 196, 30, 2000, 0),
980(21, 0, 5000, '1041 Idlewood', 2015.35, -1732.63, 14.2341, 272.103, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
981(22, 0, 5000, 'Campanella Park.', 2139.09, -1697.51, 15.0859, 5.4773, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1255),
982(23, 0, 0, '2064 Campanella Park.', 2140.62, -1708.31, 15.0859, 185.309, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
983(24, 0, 5000, '2066 Campanella Park.', 2155.62, -1698.51, 15.0859, 7.044, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
984(25, 0, 5000, '2067 Campanella Park.', 2165.9, -1671.22, 15.0731, 44.6441, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
985(26, 0, 5000, 'Ganton 1', 2326.99, -1716.7, 14.2377, 14.0402, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2),
986(27, 0, 5000, 'Ganton 2', 2308.83, -1714.33, 14.9799, 353.673, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
987(28, 0, 5000, 'Ganton 3', 2385.41, -1711.66, 14.2419, 7.7733, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
988(29, 0, 5000, 'Ganton 4', 2402.61, -1715.15, 14.1328, 359.941, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2798),
989(30, 0, 5000, 'Ganton 5', 2409.04, -1674.94, 14.375, 180.108, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
990(31, 0, 5000, 'Ganton 6', 2384.81, -1675.84, 15.2454, 212.141, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
991(32, 0, 5000, 'Ganton 7', 2368.22, -1675.34, 14.1681, 186.375, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50),
992(33, 0, 5000, 'Ganton 8', 2362.79, -1643.36, 14.3079, 326.87, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
993(34, 0, 5000, 'Ganton 9', 2393.28, -1646.03, 13.9048, 357.143, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
994(35, 0, 5000, 'Ganton 10', 2413.98, -1646.79, 14.0115, 5.6034, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 24, 42, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
995(36, 0, 5000, 'Ganton 11', 2459.45, -1691.66, 13.5458, 180.758, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 33, 5, 24, 7, 24, 7, 24, 7, 24, 7, 24, 7, 24, 7, 33, 5, 24, 7, 0, 0, 0),
996(37, 0, 5000, 'Ganton 12', 2495.2, -1691.14, 14.7656, 183.578, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
997(38, 0, 5000, 'Ganton 13', 2514.37, -1691.55, 14.0459, 222.745, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
998(39, 0, 5000, 'Ganton 14', 2523.27, -1679.44, 15.4968, 263.166, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
999(40, 0, 5000, 'Ganton 15', 2513.81, -1650.34, 14.3556, 338.366, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1000(41, 0, 5000, 'Ganton 16', 2498.65, -1642.26, 14.1127, 4.0598, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1001(42, 0, 5000, 'Ganton 17', 2486.51, -1644.53, 14.0768, 358.42, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 22, 85, 25, 28, 22, 85, 30, 150, 22, 170, 30, 150, 30, 150, 33, 100, 32, 250, 29, 150, 0),
1002(43, 0, 5000, 'Ganton 18', 2469.58, -1646.35, 13.7798, 41.0335, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1003(44, 0, 5000, 'Ganton 19', 2451.92, -1641.41, 14.0662, 349.647, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1004(45, 0, 1, '133 Cardinal Park', 2190.72, -1470.33, 25.9139, 87.8824, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1005(46, 0, 5000, '1 Jefferson', 2153.83, -1243.71, 25.367, 180, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 5, 1, 5, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14227),
1006(47, 0, 5000, '2 Jefferson', 2133.4, -1233, 24.4218, 174.385, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1007(48, 0, 5000, '3 Jefferson', 2191.62, -1239.23, 24.4878, 174.555, 309.227, 313.337, 1003.3, 189.641, 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),
1008(49, 0, 5000, '4 Jefferson', 2209.73, -1240.25, 24.4799, 183.015, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1009(50, 0, 5000, '5 Jefferson', 2229.61, -1241.61, 25.6562, 180.195, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 67),
1010(51, 0, 5000, '6 Jefferson', 2249.86, -1238.91, 25.8983, 180.822, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1011(52, 0, 1, '10 Jefferson', 2307.01, -1679.16, 14.3316, 174.808, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1012(53, 0, 5000, '11 Jefferson', 2132.25, -1280.05, 25.8906, 353.37, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1013(54, 0, 5000, '12 Jefferson', 2111.31, -1278.98, 25.8358, 4, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1014(56, 0, 5000, '14 Jefferson', 2100.94, -1321.89, 25.9531, 172.552, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1015(58, 0, 5000, '16 Jefferson', 2148.48, -1320.08, 26.0736, 177.542, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 22, 46, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1016(59, 0, 5000, '17 Jefferson', 2191.58, -1275.6, 25.1562, 0.2167, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1017(60, 0, 5000, '18 Jefferson', 2208, -1280.82, 25.1205, 359.591, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1018(61, 0, 5000, '19 Jefferson', 2230.17, -1280.06, 25.6284, 2.723, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3400),
1019(62, 0, 5000, '20 Jefferson', 2250.27, -1280.05, 25.4764, 1.8558, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1020(63, 0, 5000, '21 Jefferson', 2185.07, -1363.71, 26.1597, 8.0155, 225.646, 1022.84, 1084.01, 350.817, 7, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1021(64, 0, 5000, '22 Jefferson', 2202.83, -1363.67, 26.1909, 8.0155, 225.646, 1022.84, 1084.01, 350.817, 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),
1022(65, 0, 5000, '23 Jefferson', 2129.65, -1361.69, 26.1361, 7.0755, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1023(66, 0, 5000, '24 Jefferson', 2147.7, -1366.12, 25.9722, 356.422, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1024(67, 0, 5000, '25 Jefferson', 2151.19, -1400.68, 26.1284, 274.642, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1025(68, 0, 5000, '26 Cardinal', 2149.86, -1433.76, 26.0701, 276.835, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1026(69, 0, 5000, '27 Cardinal', 2152.22, -1446.29, 26.1049, 275.582, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1027(70, 0, 5000, '28 Cardinal', 2146.8, -1470.48, 26.0424, 270.882, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1028(71, 0, 5000, '29 Cardinal', 2148.94, -1485, 26.6238, 266.182, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1029(72, 0, 5000, '1 Willowfield', 2238.12, -1906.83, 14.9375, 186.338, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1030(73, 0, 5000, '2 Willowfield', 2261.48, -1906.76, 14.9375, 189.784, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1031(74, 0, 5000, '3 Willowfield', 2284.53, -1906.6, 14.9294, 182.264, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1032(75, 0, 5000, '4 Willowfield', 2296.74, -1882.01, 14.2341, 1.4687, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1033(76, 0, 5000, '5 Willowfield', 2269.28, -1882.01, 14.2341, 2.4089, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1034(77, 0, 5000, '6 Willowfield', 2241.89, -1882.01, 14.2341, 356.142, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1035(78, 0, 5000, '1 Seville Boulevard', 2637.15, -1991.63, 14.324, 45.0227, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5000),
1036(79, 0, 5000, '2 Seville Boulevard', 2635.75, -2013.13, 14.1443, 150.28, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1037(80, 0, 5000, '3 Seville Boulevard', 2650.7, -2021.75, 14.1766, 275.615, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1038(81, 0, 5000, '4 Seville Boulevard', 2653.01, -1989.42, 13.9988, 0.8421, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20000),
1039(82, 0, 5000, '5 Seville Boulevard', 2672.77, -1989.47, 14.324, 2.4089, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1040(83, 0, 5000, '6 Seville Boulevard', 2673.07, -2020.29, 14.1681, 172.527, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1041(84, 0, 5000, '7 Seville Boulevard', 2695.25, -2020.55, 14.0221, 191.328, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1042(85, 0, 5000, '8 Seville Boulevard', 2696.31, -1990.36, 14.2228, 358.649, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1043(88, 0, 5000, '11 Seville Boulevard', 2787.08, -1926.12, 13.5466, 274.675, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1044(89, 0, 5000, '12 Seville Boulevard', 2787.07, -1952.43, 13.5466, 275.302, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1045(90, 0, 5000, '30 Willowfield', 2522.76, -2018.99, 14.074, 218.999, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1046(91, 0, 5000, '31 Willowfield', 2524.17, -1998.12, 14.1127, 349.323, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1047(92, 0, 5000, '32 Willowfield', 2508.49, -1998.37, 13.9025, 7.8104, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1048(93, 0, 5000, '33 Willowfield', 2483.48, -1995.34, 13.8343, 356.217, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1049(94, 0, 5000, '34 Willowfield', 2465.12, -1995.75, 14.0193, 359.35, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1050(95, 0, 5000, '35 Willowfield', 2437.92, -2020.85, 13.9025, 182.663, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1051(96, 0, 5000, '36 Willowfield', 2465.53, -2020.79, 14.1239, 186.109, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1052(97, 0, 5000, '37 Willowfield', 2486.39, -2021.55, 13.9988, 187.363, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1053(98, 0, 5000, '38 Willowfield', 2507.67, -2021.05, 14.2101, 186.736, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1054(99, 0, 3000, 'Apartment - B1', 2275.83, -1785.77, 13.5466, 266.19, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1055(100, 0, 3000, 'Apartment - B2', 2247.07, -1795.85, 13.5466, 95.4216, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1056(101, 0, 2000, 'Apartment C1', 1179.89, -1260.87, 15.1795, 91.7779, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1057(102, 0, 2000, 'Apartment C2', 1187.44, -1260.92, 15.1794, 269.416, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1058(103, 0, 2000, 'Apartment C3', 1187.36, -1254.73, 15.1794, 270.356, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1059(104, 0, 2000, 'Apartment C4', 1187.36, -1254.9, 18.8906, 237.022, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 30, 150, 30, 150, 28, 250, 32, 250, 24, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1060(105, 0, 2000, 'Apartment C5', 1179.8, -1254.44, 18.8906, 86.4278, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1061(106, 0, 2000, 'Apartment C6', 1179.89, -1260.82, 18.8983, 95.5146, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1062(107, 0, 2000, 'Apartment C7', 1187.44, -1261.08, 18.8983, 273.49, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1063(108, 0, 2000, 'Apartment C8', 1179.89, -1233.32, 22.1406, 93.6578, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1064(109, 0, 2000, 'Apartment C9', 1187.44, -1233.35, 22.1406, 268.79, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1065(110, 0, 2000, 'Apartment C10', 1187.36, -1227.3, 22.1329, 274.743, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1066(111, 0, 2000, 'Apartment C11', 1179.81, -1227.07, 18.5545, 93.6578, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1067(112, 0, 2000, 'Apartment C12', 1187.36, -1227.32, 18.5545, 265.366, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 24, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1068(113, 0, 2000, 'Apartment C13', 1187.45, -1233.54, 18.5545, 256.906, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1069(114, 0, 2000, 'Apartment C14', 1179.81, -1254.62, 15.1795, 88.6446, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1070(115, 0, 2000, 'El Corona 1', 1870.76, -2019.6, 13.5466, 94.7565, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1071(116, 0, 2000, 'El Corona 2', 1870.76, -2021.43, 13.5466, 94.7565, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1072(117, 0, 2000, 'El Corona 3', 1895.53, -2021.63, 13.5466, 277.408, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7500),
1073(118, 0, 2000, 'El Corona 4', 1895.53, -2019.4, 13.5466, 277.408, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1074(119, 0, 2000, 'El Corona 5', 1895.48, -2068.92, 15.6688, 179.334, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1075(120, 0, 2000, 'El Corona 6', 1873.35, -2070.76, 15.4968, 181.527, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25000),
1076(121, 0, 2000, 'El Corona 7', 1851.8, -2070.45, 15.4812, 181.214, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1077(122, 0, 2000, 'El Corona 8', 1857.16, -2040.85, 13.5466, 351.982, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 24, 65, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1078(123, 0, 2000, 'El Corona 9', 1867.87, -1985.4, 13.5466, 0.1764, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500),
1079(124, 0, 2000, 'El Corona 10', 1865.72, -1998.09, 13.5466, 170.922, 2468.26, -1698.24, 1013.51, 90, 2, 0, 0, 1, 8, 1, 0, 0, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 0),
1080(125, 0, 2000, 'El Corona 11', 1900.32, -1985.39, 13.5466, 359.551, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1081(126, 0, 2000, 'El Corona 12', 1898.34, -1998.06, 13.5466, 177.188, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1082(127, 0, 2000, 'El Corona 13', 1913.95, -1993.3, 13.5466, 275.576, 295.148, 1473.11, 1080.26, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1083(128, 0, 2000, 'El Corona 14', 1852.28, -1990.19, 13.5466, 91.9607, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4500),
1084(129, 0, 2000, 'El Corona 15', 1853.99, -1914.26, 15.2566, 359.926, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500),
1085(130, 0, 2000, 'El Corona 16', 1872.36, -1911.79, 15.2566, 2.1149, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1086(131, 0, 2000, 'El Corona 17', 1891.95, -1914.39, 15.2566, 358.355, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1087(132, 0, 2000, 'El Corona 18', 1913.58, -1911.9, 15.2566, 1.1749, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1088(133, 0, 2000, 'El Corona 19', 1928.74, -1915.9, 15.2566, 3.3682, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1089(134, 0, 2000, 'El Corona 20', 1938.54, -1911.45, 15.2566, 273.754, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1090(135, 0, 1, '210 Vinewood Hills', 1258.68, -785.378, 92.0298, 264.674, 1260.87, -785.61, 1091.91, 279.859, 5, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1091(136, 0, 150000, 'LSPD TRAIN - HOUSE', 251.431, -1220.21, 76.1023, 29.3019, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1092(137, 0, 1, 'Martin Luther King Apartment 1', 2228.43, -1150.72, 1025.8, 276.194, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7014, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1093(138, 0, 1, '3 Martin Luther King Jr Apartme', 2242.52, -1170.67, 1029.8, 283.478, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7014, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1094(139, 0, 1, '159 Dead End, El Corona', 1684.86, -2098.53, 13.8343, 3.6054, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1095(140, 0, 1, '2 Martin Luther King Apartment', 2235.46, -1162.57, 1029.8, 179.253, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7014, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1096(141, 0, 5000, '472 Oak Hill Road', 2408, -1106.97, 40.2957, 183.102, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1097(142, 0, 5000, '473 Oak Hill Road', 2457.07, -1102.5, 43.867, 216.606, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1098(143, 0, 5000, '474 Oak Hill Road', 2470.72, -1105.32, 44.4878, 95.2723, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1099(144, 0, 5000, '473 Oak Hill Road', 2438.63, -1105.28, 42.7509, 187.212, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1100(145, 0, 10000, '475 Oak Hill Road', 2519.02, -1112.73, 56.5924, 86.8846, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1101(146, 0, 10000, '476 Oak Hill Road', 2572.29, -1091.87, 67.2257, 234.443, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1102(147, 0, 10000, '477 Oak Hill Road', 2576.68, -1070.79, 69.8321, 269.536, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1103(148, 0, 1, '4 Martin Luther King Apartment', 2238.93, -1192.74, 1033.8, 93.3809, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7014, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1104(150, 0, 1, '911 Vinewood Road', 1111.5, -976.408, 42.7653, 189.737, 2496.08, -1692.21, 1014.74, 176.409, 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),
1105(151, 0, 1, '5 Martin Luther King Apartment', 2225.39, -1189.96, 1029.8, 175.083, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7014, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1106(152, 0, 1, '632 Temple Drive', 993.813, -1059.03, 33.6995, 179.87, 2807.42, -1174.64, 1025.57, 2.9567, 8, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1107(158, 0, 5000, 'Pershing Square.', 1411.37, -1699.79, 13.5394, 56.1618, 226.928, 1114.28, 1081, 270, 5, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1108(159, 0, 5000, '424 Echo parque.', 2091.56, -1184.29, 27.0569, 352.559, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1109(160, 0, 5000, 'Echo parque.', 2093.99, -1122.68, 27.6898, 353.186, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1110(161, 0, 5000, 'Jefferson St.', 2090.62, -1235.18, 26.0191, 181.832, 2269.88, -1210.32, 1047.56, 90, 10, 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(162, 0, 5000, '3030 Jefferson St', 2110.88, -1244.4, 25.8514, 176.818, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1112(163, 0, 5000, '3020 Jefferson St', 2230.37, -1397.24, 24.5736, 186.532, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1113(164, 0, 5000, '3010 Jefferson St', 2243.4, -1397.24, 24.5736, 183.085, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1114(165, 0, 5000, '3000 Jefferson St', 2256.42, -1397.24, 24.5736, 181.205, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1115(166, 0, 1000, 'Room 1.', 2228.43, -1150.49, 1025.8, 271.822, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7020, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1116(167, 0, 1000, 'Room 2.', 2242.52, -1170.77, 1029.8, 267.122, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7020, 1, 25, 97, 0, 0, 30, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1117(168, 0, 1000, 'Red County st.', 1451.69, 375.744, 19.4004, 343.424, 301.965, 301.119, 999.148, 329.847, 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),
1118(169, 0, 1000, 'El Corona - Room 1', 2228.41, -1150.43, 1025.8, 268.166, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7021, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1119(170, 0, 1000, 'El Corona - Room 2', 2242.52, -1170.78, 1029.8, 264.72, 244.148, 304.842, 999.148, 79.818, 1, 15, 7021, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1120(171, 0, 1000, 'El Corona - Room 3', 2225.73, -1189.96, 1029.8, 178.961, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7021, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1121(172, 0, 1000, 'El Corona - Room 4', 2209.65, -1187.37, 1029.8, 11.8807, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7021, 0, 32, 250, 0, 0, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1122(173, 0, 1000, 'El Corona - Room 5', 2191.89, -1173.03, 1029.8, 82.6946, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7021, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1123(174, 0, 1000, 'El Corona - Room 6', 2193.46, -1138.62, 1029.8, 354.647, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7021, 1, 24, 42, 0, 0, 24, 42, 24, 42, 24, 42, 24, 42, 32, 250, 8, 1, 0, 0, 0, 0, 0),
1124(175, 0, 1000, 'El Corona - Room 7', 2193.25, -1147.67, 1033.8, 174.479, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7021, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1125(176, 0, 1, 'Apartment 27', 2228.43, -1150.53, 1025.8, 272.112, 295.148, 1473.11, 1080.26, 0, 15, 15, 7053, 1, 30, 36, 33, 3, 30, 30, 33, 85, 25, 128, 25, 108, 0, 0, 25, 8, 24, 7, 25, 100, 0),
1126(177, 0, 1, '786 Red County Hills', 980.31, -677.371, 121.976, 218.824, 2324.42, -1148.94, 1050.71, 0, 12, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1127(178, 0, 1, '614 Brooksdale Avenue', 2551.12, -1233.79, 49.3316, 1.1088, 235.292, 1187.37, 1080.26, 0, 3, 0, 0, 1, 24, 1362, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1128(179, 0, 1, '613 Brooksdale Avenue', 2536.83, -1235.61, 43.7218, 183.085, 235.292, 1187.37, 1080.26, 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),
1129(180, 0, 1, '467 Brooksdale Avenue', 2434, -1274.96, 24.7565, 88.9494, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 25, 50, 25, 100, 29, 150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1130(181, 0, 5000, 'Ganton 20', 2327.49, -1681.84, 14.9294, 91.3973, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1131(182, 0, 45000, '290 Vinewood Hills', 1540.41, -851.46, 64.3358, 270.75, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1132(183, 0, 30000, '289 Vinewood Hills', 1535.03, -800.241, 72.8494, 271.812, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1133(184, 0, 30000, '288 Vinewood Hills', 1527.82, -772.586, 80.5781, 321.632, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1134(185, 0, 30000, '291 Vinewood Hills', 1535.77, -885.294, 57.6572, 133.63, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1135(186, 0, 30000, '292 Vinewood Hills', 1468.6, -906.169, 54.8358, 180.944, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1136(187, 0, 30000, '293 Vinewood Hills', 1421.8, -886.232, 50.6861, 179.691, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1137(188, 0, 50000, '172 Vinewood Hills', 1045.15, -642.707, 120.117, 254.866, 1260.64, -785.275, 1091.91, 94.529, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1138(189, 0, 12000, '13 Jefferson', 2090.91, -1277.83, 26.1795, 213.122, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1139(190, 0, 17500, '15 Jefferson', 2126.76, -1320.75, 26.624, 359.239, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1140(191, 0, 75000, '752 Vinewood Hills', 1095.13, -647.43, 113.648, 144.842, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 24, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1141(192, 0, 1, '173 Willowfield', 2333.25, -1883.56, 15, 176.716, 2495.87, -1693.1, 1014.74, 180, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1142(193, 0, 950000, '895 Richman Hills', 1496.84, -687.898, 95.5633, 2.591, 1261.47, -785.267, 1091.91, 267.014, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1143(194, 0, 1, '173 Vinewood Hills ', 1331.94, -633.231, 109.135, 202.812, 2324.42, -1148.94, 1050.71, 0, 12, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1144(195, 0, 1, '27 Jefferson', 2050.72, -1065.77, 25.7835, 51.9308, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 25, 28, 0, 0, 24, 42, 24, 42, 24, 42, 24, 42, 209600),
1145(196, 0, 1, '4000', 2232.48, -1469.34, 24.5816, 1.4982, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1146(198, 0, 1, '4020 Jefferson St', 2263.88, -1469.34, 24.3705, 2.1484, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1147(199, 0, 10000, '107 Burbon Street', 497.411, -1095.07, 82.3591, 179.813, 497.405, -1094.55, 82.3591, 180.898, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1148(200, 0, 25000, 'East Los Santos Car Wash', 2494.14, -1464.71, 24.0254, 186.41, 1062.15, 2077.08, 10.8203, 187.71, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1149(202, 0, 2500, '147 Suger Hill', 1106.55, -299.86, 74.539, 264.17, 2317.8, -1026.21, 1050.22, 0, 9, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1150(203, 0, 2, '478 Oak Hill Road', 2579.67, -1033.45, 69.58, 359.409, 226.291, 1240.06, 1082.14, 90, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1151(204, 0, 1000, '479 Oak Hill Road', 2561.81, -1034.28, 69.8692, 268.855, 2233.79, -1114.27, 1050.88, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1152(205, 0, 1000, '480 Oak Hill Road', 2549.41, -1032.38, 69.5789, 183.482, 2233.79, -1114.27, 1050.88, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1153(206, 0, 1500, '481 Oak Hill Road', 2526.79, -1033.52, 69.5792, 352.829, 223.162, 1287.52, 1082.14, 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),
1154(207, 0, 4000, '482 Oak Hill Road', 2512.75, -1027.16, 70.0858, 352.202, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1155(208, 0, 1000, '483 Oak Hill Road', 2534.48, -1063.39, 69.5652, 264.782, 2233.79, -1114.27, 1050.88, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1156(209, 0, 1000, '484 Oak Hill Road', 2526.09, -1060.61, 69.9707, 90.5895, 2233.79, -1114.27, 1050.88, 0, 5, 0, 0, 1, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 24, 42, 0),
1157(210, 0, 2000, '485 Oak Hill Road', 2499.75, -1065.52, 70.2359, 254.465, 223.162, 1287.52, 1082.14, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1158(211, 0, 3000, '1 Dillimore', 743.217, -509.318, 18.0128, 0.7634, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1159(212, 0, 3000, '2 Dillimore', 768.311, -503.482, 18.0128, 1.077, 223.162, 1287.52, 1082.14, 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),
1160(213, 0, 3000, '3 Dillimore', 795.222, -506.15, 18.0128, 0.7634, 225.7, 1022, 1084.02, 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),
1161(214, 0, 3000, '4 Dillimore', 818.277, -509.318, 18.0128, 2.6435, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1162(215, 0, 3000, '5 Dillimore', 766.636, -556.784, 18.0128, 179.98, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1163(216, 0, 3000, '6 Dillimore', 745.13, -556.785, 18.0128, 181.535, 23.9584, 1340.61, 1084.38, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1164(217, 0, 3000, '7 Dillimore', 745.673, -591.091, 18.0128, 268.329, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1165(218, 0, 7000, '57 Glen Park', 2023.03, -1120.26, 26.4209, 1.5147, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1166(219, 0, 7000, '56 Glen Park', 2045.57, -1116.65, 26.3617, 174.622, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1167(221, 0, 1, '31 El Monte', 2459.45, -948.157, 80.0822, 351.893, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1168(222, 0, 1, '32 El Monte', 2454.18, -964.925, 80.0729, 98.7406, 318.754, 1116.47, 1083.88, 348.432, 5, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1169(223, 0, 3000, '58 Glen Park', 1999.94, -1114.15, 27.125, 6.1142, 223.162, 1287.52, 1082.14, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 500, 0, 0, 0, 0, 0, 0, 0),
1170(224, 0, 3000, '59 Glen Park', 1955.44, -1115.37, 27.8304, 91.4866, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1171(225, 0, 3000, '60 Glen Park', 1939.1, -1114.48, 27.4521, 2.354, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1172(226, 0, 3000, '61 Glen Park', 1921.56, -1115.1, 27.0883, 93.3666, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1173(227, 0, 3000, '62 Glen Park', 1905.93, -1113.1, 26.6639, 1.559, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 24, 42, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16000),
1174(228, 0, 3000, '63 Glen Park', 1886.15, -1113.8, 26.2758, 89.9197, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1175(229, 0, 1, 'STORAGE', -823.495, 534.756, 1356.86, 312.217, 2269.88, -1210.32, 1047.56, 90, 10, 1, 6032, 0, 0, 0, 23, 20, 23, 20, 23, 20, 23, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1176(230, 0, 1000, '1 Normandy Projects', 2468.45, -1409.83, 28.8335, 177.269, 222.042, 1140.76, 1082.61, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1177(231, 0, 1000, '2 Normandy Projects', 2473.11, -1410.01, 28.8337, 180.088, 22.9675, 1403.84, 1084.43, 0, 5, 0, 0, 1, 22, 17, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1178(232, 0, 1000, '3 Normandy Projects', 2476.28, -1410.02, 28.8337, 180.088, 222.042, 1140.76, 1082.61, 0, 4, 0, 0, 0, 0, 0, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1179(233, 0, 1000, '4 Normandy Projects', 2468.28, -1399.11, 28.8281, 1.1741, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1180(234, 0, 1000, '5 Normandy Projects', 2473.1, -1399.07, 28.8339, 0.5475, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 24, 42, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1181(235, 0, 1000, '6 Normandy Projects', 2476.31, -1399.09, 28.8346, 0.5475, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1182(236, 0, 1000, '7 Normandy Projects', 2487.39, -1399.1, 28.8374, 1.5104, 235.292, 1187.37, 1080.26, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1183(237, 0, 1000, '8 Normandy Projects', 2492.25, -1399.09, 28.8386, 359.944, 222.042, 1140.76, 1082.61, 0, 4, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1184(238, 0, 1000, '9 Normandy Projects', 2495.42, -1399.08, 28.8393, 358.064, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1185(239, 0, 1000, '10 Normandy Projects', 2495.37, -1410.03, 28.8393, 177.896, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1186(240, 0, 1000, '11 Normandy Projects', 2492.12, -1410.04, 28.8386, 180.088, 2495.87, -1693.1, 1014.74, 180, 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),
1187(241, 0, 1000, '12 Normandy Projects', 2487.32, -1410.03, 28.8374, 179.776, 295.148, 1473.11, 1080.26, 0, 15, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1188(242, 0, 7500, '747 East Beach, Jacksonville', 2808.08, -1175.92, 25.3801, 359.154, 2495.87, -1693.1, 1014.74, 180, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1189(243, 0, 7500, '746 East Beach, Jacksonville', 2808.06, -1190.79, 25.3418, 180.793, 2495.87, -1693.1, 1014.74, 180, 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),
1190(246, 0, 1, '420 Idlewood Avenue', 1980.38, -1719.04, 17.0303, 77.1138, 140.309, 1366.82, 1083.86, 0, 5, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1191(247, 0, 1, '33 El Monte', 2472.3, -962.44, 80.5252, 358.559, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1192(248, 0, 5000, '468 Brooksdale Avenue', 2434.8, -1289.36, 25.3477, 82.2798, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1193(252, 0, 5000, '469 Brooksdale Avenue', 2434.25, -1303.4, 24.9764, 87.2826, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1194(253, 0, 5000, '170 Brooksdale Avenue', 2434.42, -1320.64, 24.9337, 96.6595, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1195(254, 0, 5000, '171 Brooksdale Avenue', 2439.94, -1338.37, 24.1079, 176.247, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1196(255, 0, 5000, '172 Brooksdale Avenue', 2439.94, -1357.02, 24.1002, 89.0669, 318.708, 1115.47, 1083.88, 6.339, 5, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1197(256, 0, 5000, '164 Temple Drive', 1326.26, -1090.75, 27.9765, 92.0129, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1198(257, 0, 5000, '1 Brooksdale Avenue', 2594.82, -1200.03, 59.2187, 88.3675, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1199(258, 0, 5000, '2 Brooksdale Avenue', 2594.89, -1203.07, 58.4375, 88.1104, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1200(259, 0, 5000, '3 Brooksdale Avenue', 2594.8, -1207.59, 57.5078, 86.5999, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1201(260, 0, 5000, '4 Brooksdale Avenue', 2594.95, -1211.89, 56.375, 89.4761, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1202(261, 0, 5000, '5 Brooksdale Avenue', 2594.83, -1216.26, 54.9765, 87.6523, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1203(262, 0, 5000, '6 Brooksdale Avenue', 2594.96, -1220.63, 53.6693, 85.8847, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1204(263, 0, 5000, '7 Brooksdale Avenue', 2595.03, -1224.64, 52.3763, 88.4476, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1205(264, 0, 5000, '8 Brooksdale Avenue', 2594.76, -1229.18, 51.0468, 93.1476, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1206(265, 0, 5000, '9 Brooksdale Avenue', 2595.12, -1233.49, 49.8203, 92.2638, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1207(266, 0, 5000, '10 Brooksdale Avenue', 2594.7, -1237.98, 48.4218, 91.9505, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1208(267, 0, 5000, '11 Brooksdale Avenue', 2600.9, -1238.14, 48.6836, 273.059, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1209(268, 0, 5000, '12 Brooksdale Avenue', 2600.71, -1233.47, 49.8203, 267.788, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1210(269, 0, 5000, '13 Brooksdale Avenue', 2600.47, -1229.22, 51.0468, 273.485, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1211(270, 0, 5000, '14 Brooksdale Avenue', 2600.81, -1224.69, 52.341, 272.858, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1212(271, 0, 5000, '15 Brooksdale Avenue', 2600.67, -1220.61, 53.6372, 273.798, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1213(272, 0, 5000, '16 Brooksdale Avenue', 2600.38, -1216.36, 54.9765, 271.604, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1214(273, 0, 5000, '17 Brooksdale Avenue', 2600.89, -1211.74, 56.6269, 269.467, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1215(274, 0, 5000, '18 Brooksdale Avenue', 2600.71, -1207.67, 57.5078, 274.481, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1216(275, 0, 5000, '19 Brooksdale Avenue', 2600.58, -1203.06, 58.4375, 268.27, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1217(276, 0, 5000, '20 Brooksdale Avenue', 2600.83, -1200.14, 59.2187, 268.013, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1218(277, 0, 4000, 'Apartment 290', 2240.05, -1170.63, 1029.8, 91.0041, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7053, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1219(278, 0, 4000, 'Apartment 291', 2242.36, -1170.67, 1029.8, 271.237, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7053, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1220(279, 0, 4000, 'Apartment 289', 2239.89, -1159.66, 1029.8, 95.564, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7053, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1221(280, 0, 4000, 'Apartment 288', 2242.57, -1159.86, 1029.8, 271.949, 2269.88, -1210.32, 1047.56, 90, 10, 15, 7053, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1222(282, 0, 5000, '633 Dead End, El Corona', 1801.86, -2099.41, 14.021, 352.112, 226.291, 1240.06, 1082.14, 90, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5000),
1223(283, 0, 5000, '634 Dead End, El Corona', 1782.15, -2126.17, 14.0678, 181.826, 226.291, 1240.06, 1082.14, 90, 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),
1224(284, 0, 5000, '636 Dead End, El Corona', 1761.19, -2125.43, 14.0566, 180.572, 226.291, 1240.06, 1082.14, 90, 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),
1225(285, 0, 5000, '638 Dead End, El Corona', 1734.75, -2130.19, 14.021, 178.547, 226.291, 1240.06, 1082.14, 90, 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),
1226(286, 0, 5000, '640 Dead End, El Corona', 1715.09, -2125.15, 14.0566, 181.849, 226.291, 1240.06, 1082.14, 90, 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),
1227(287, 0, 5000, '642 Dead End, El Corona', 1695.56, -2125.69, 13.81, 178.571, 226.291, 1240.06, 1082.14, 90, 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),
1228(288, 0, 5000, '644 Dead End, El Corona', 1673.74, -2122.34, 14.146, 133.619, 226.291, 1240.06, 1082.14, 90, 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),
1229(289, 1, 1, 'Fuck off - Test', 1659.27, -2179.17, 13.5546, 81.8892, 2269.88, -1210.32, 1047.56, 90, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
1230
1231-- --------------------------------------------------------
1232
1233--
1234-- Table structure for table `housestorage`
1235--
1236
1237CREATE TABLE IF NOT EXISTS `housestorage` (
1238 `ID` int(12) DEFAULT '0',
1239 `itemID` int(12) NOT NULL,
1240 `itemName` varchar(32) DEFAULT NULL,
1241 `itemModel` int(12) DEFAULT '0',
1242 `itemQuantity` int(12) DEFAULT '0'
1243) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1244
1245-- --------------------------------------------------------
1246
1247--
1248-- Table structure for table `impoundlots`
1249--
1250
1251CREATE TABLE IF NOT EXISTS `impoundlots` (
1252 `impoundID` int(12) NOT NULL,
1253 `impoundLotX` float DEFAULT '0',
1254 `impoundLotY` float DEFAULT '0',
1255 `impoundLotZ` float DEFAULT '0',
1256 `impoundReleaseX` float DEFAULT '0',
1257 `impoundReleaseY` float DEFAULT '0',
1258 `impoundReleaseZ` float DEFAULT '0',
1259 `impoundReleaseInt` int(12) DEFAULT '0',
1260 `impoundReleaseWorld` int(12) DEFAULT '0',
1261 `impoundReleaseA` float DEFAULT '0'
1262) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1263
1264--
1265-- Dumping data for table `impoundlots`
1266--
1267
1268INSERT INTO `impoundlots` (`impoundID`, `impoundLotX`, `impoundLotY`, `impoundLotZ`, `impoundReleaseX`, `impoundReleaseY`, `impoundReleaseZ`, `impoundReleaseInt`, `impoundReleaseWorld`, `impoundReleaseA`) VALUES
1269(1, 1644.36, -2172.96, 13.5546, 1628.53, -2164.01, 13.5546, 0, 0, 270.035);
1270
1271-- --------------------------------------------------------
1272
1273--
1274-- Table structure for table `inventory`
1275--
1276
1277CREATE TABLE IF NOT EXISTS `inventory` (
1278 `ID` int(12) DEFAULT '0',
1279 `invID` int(12) NOT NULL,
1280 `invItem` varchar(32) DEFAULT NULL,
1281 `invModel` int(12) DEFAULT '0',
1282 `invQuantity` int(12) DEFAULT '0'
1283) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1284
1285-- --------------------------------------------------------
1286
1287--
1288-- Table structure for table `jobs`
1289--
1290
1291CREATE TABLE IF NOT EXISTS `jobs` (
1292 `jobID` int(12) NOT NULL,
1293 `jobPosX` float DEFAULT '0',
1294 `jobPosY` float DEFAULT '0',
1295 `jobPosZ` float DEFAULT '0',
1296 `jobPointX` float DEFAULT '0',
1297 `jobPointY` float DEFAULT '0',
1298 `jobPointZ` float DEFAULT '0',
1299 `jobDeliverX` float DEFAULT '0',
1300 `jobDeliverY` float DEFAULT '0',
1301 `jobDeliverZ` float DEFAULT '0',
1302 `jobInterior` int(12) DEFAULT '0',
1303 `jobWorld` int(12) DEFAULT '0',
1304 `jobType` int(12) DEFAULT '0',
1305 `jobPointInt` int(12) DEFAULT '0',
1306 `jobPointWorld` int(12) DEFAULT '0'
1307) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;
1308
1309--
1310-- Dumping data for table `jobs`
1311--
1312
1313INSERT INTO `jobs` (`jobID`, `jobPosX`, `jobPosY`, `jobPosZ`, `jobPointX`, `jobPointY`, `jobPointZ`, `jobDeliverX`, `jobDeliverY`, `jobDeliverZ`, `jobInterior`, `jobWorld`, `jobType`, `jobPointInt`, `jobPointWorld`) VALUES
1314(13, 2446.43, -2118.8, 13.5468, 2452.66, -2116.49, 13.5529, 0, 0, 0, 0, 0, 1, 0, 0),
1315(17, 1844.17, -1760.96, 13.5468, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0),
1316(18, 790.254, -1620.72, 13.3905, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0),
1317(19, 2194.4, -1974.56, 13.5592, 2184.69, -1988.42, 13.5499, 0, 0, 0, 0, 0, 7, 0, 0),
1318(20, 2561.64, -1293.43, 1044.12, 2558.7, -1295.85, 1044.12, 0, 0, 0, 2, 7013, 9, 2, 7013),
1319(31, 937.282, 2117.79, 1011.02, 941.023, 2163.11, 1011.03, 0, 0, 0, 1, 7019, 9, 1, 7019),
1320(32, 2562.13, -1293.56, 1044.12, 0, 0, 0, 0, 0, 0, 2, 7049, 9, 0, 0),
1321(34, 2562.26, -1293.47, 1044.12, 0, 0, 0, 0, 0, 0, 2, 0, 9, 0, 0);
1322
1323-- --------------------------------------------------------
1324
1325--
1326-- Table structure for table `namechanges`
1327--
1328
1329CREATE TABLE IF NOT EXISTS `namechanges` (
1330 `ID` int(12) NOT NULL,
1331 `OldName` varchar(24) DEFAULT NULL,
1332 `NewName` varchar(24) DEFAULT NULL,
1333 `Date` varchar(36) DEFAULT NULL
1334) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1335
1336-- --------------------------------------------------------
1337
1338--
1339-- Table structure for table `plants`
1340--
1341
1342CREATE TABLE IF NOT EXISTS `plants` (
1343 `plantID` int(12) NOT NULL,
1344 `plantType` int(12) DEFAULT '0',
1345 `plantDrugs` int(12) DEFAULT '0',
1346 `plantX` float DEFAULT '0',
1347 `plantY` float DEFAULT '0',
1348 `plantZ` float DEFAULT '0',
1349 `plantA` float DEFAULT '0',
1350 `plantInterior` int(12) DEFAULT '0',
1351 `plantWorld` int(12) DEFAULT '0'
1352) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1353
1354-- --------------------------------------------------------
1355
1356--
1357-- Table structure for table `pumps`
1358--
1359
1360CREATE TABLE IF NOT EXISTS `pumps` (
1361 `ID` int(12) DEFAULT '0',
1362 `pumpID` int(12) NOT NULL,
1363 `pumpPosX` float DEFAULT '0',
1364 `pumpPosY` float DEFAULT '0',
1365 `pumpPosZ` float DEFAULT '0',
1366 `pumpPosA` float DEFAULT '0',
1367 `pumpFuel` int(12) DEFAULT '0'
1368) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
1369
1370--
1371-- Dumping data for table `pumps`
1372--
1373
1374INSERT INTO `pumps` (`ID`, `pumpID`, `pumpPosX`, `pumpPosY`, `pumpPosZ`, `pumpPosA`, `pumpFuel`) VALUES
1375(67, 15, 655.642, -570.239, 16.4113, 91.5188, 1454),
1376(67, 16, 655.598, -559.56, 16.4514, 88.9889, 2000),
1377(16, 17, 1941.36, -1767.12, 14.1428, 273.761, 181133),
1378(16, 18, 1941.83, -1771.51, 14.1625, -90.7393, 181131),
1379(16, 20, 1941.89, -1774.31, 14.1511, -91.0074, 179042),
1380(16, 21, 1941.82, -1777.77, 14.1302, -91.1277, 179743),
1381(103, 22, 2762.87, -1909.83, 12.6279, 89.467, 1976);
1382
1383-- --------------------------------------------------------
1384
1385--
1386-- Table structure for table `speedcameras`
1387--
1388
1389CREATE TABLE IF NOT EXISTS `speedcameras` (
1390 `speedID` int(12) NOT NULL,
1391 `speedRange` float DEFAULT '0',
1392 `speedLimit` float DEFAULT '0',
1393 `speedX` float DEFAULT '0',
1394 `speedY` float DEFAULT '0',
1395 `speedZ` float DEFAULT '0',
1396 `speedAngle` float DEFAULT '0'
1397) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1398
1399-- --------------------------------------------------------
1400
1401--
1402-- Table structure for table `tickets`
1403--
1404
1405CREATE TABLE IF NOT EXISTS `tickets` (
1406 `ID` int(12) DEFAULT '0',
1407 `ticketID` int(12) NOT NULL,
1408 `ticketFee` int(12) DEFAULT '0',
1409 `ticketBy` varchar(24) DEFAULT NULL,
1410 `ticketDate` varchar(36) DEFAULT NULL,
1411 `ticketReason` varchar(32) DEFAULT NULL
1412) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1413
1414-- --------------------------------------------------------
1415
1416--
1417-- Table structure for table `vendors`
1418--
1419
1420CREATE TABLE IF NOT EXISTS `vendors` (
1421 `vendorID` int(12) NOT NULL,
1422 `vendorType` int(12) DEFAULT '0',
1423 `vendorX` float DEFAULT '0',
1424 `vendorY` float DEFAULT '0',
1425 `vendorZ` float DEFAULT '0',
1426 `vendorA` float DEFAULT '0',
1427 `vendorInterior` int(12) DEFAULT '0',
1428 `vendorWorld` int(12) DEFAULT '0'
1429) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1430
1431--
1432-- Dumping data for table `vendors`
1433--
1434
1435INSERT INTO `vendors` (`vendorID`, `vendorType`, `vendorX`, `vendorY`, `vendorZ`, `vendorA`, `vendorInterior`, `vendorWorld`) VALUES
1436(1, 1, 1728.84, -2390.79, 13.5546, 5.4138, 0, 0),
1437(2, 2, 1724.95, -2390.97, 13.5546, 6.6672, 0, 0);
1438
1439-- --------------------------------------------------------
1440
1441--
1442-- Table structure for table `warrants`
1443--
1444
1445CREATE TABLE IF NOT EXISTS `warrants` (
1446 `ID` int(12) NOT NULL,
1447 `Suspect` varchar(24) DEFAULT NULL,
1448 `Username` varchar(24) DEFAULT NULL,
1449 `Date` varchar(36) DEFAULT NULL,
1450 `Description` varchar(128) DEFAULT NULL
1451) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1452
1453--
1454-- Indexes for dumped tables
1455--
1456
1457--
1458-- Indexes for table `accounts`
1459--
1460ALTER TABLE `accounts`
1461 ADD PRIMARY KEY (`ID`);
1462
1463--
1464-- Indexes for table `arrestpoints`
1465--
1466ALTER TABLE `arrestpoints`
1467 ADD PRIMARY KEY (`arrestID`);
1468
1469--
1470-- Indexes for table `backpackitems`
1471--
1472ALTER TABLE `backpackitems`
1473 ADD PRIMARY KEY (`itemID`);
1474
1475--
1476-- Indexes for table `backpacks`
1477--
1478ALTER TABLE `backpacks`
1479 ADD PRIMARY KEY (`backpackID`);
1480
1481--
1482-- Indexes for table `billboards`
1483--
1484ALTER TABLE `billboards`
1485 ADD PRIMARY KEY (`bbID`);
1486
1487--
1488-- Indexes for table `businesses`
1489--
1490ALTER TABLE `businesses`
1491 ADD PRIMARY KEY (`bizID`);
1492
1493--
1494-- Indexes for table `cars`
1495--
1496ALTER TABLE `cars`
1497 ADD PRIMARY KEY (`carID`);
1498
1499--
1500-- Indexes for table `carstorage`
1501--
1502ALTER TABLE `carstorage`
1503 ADD PRIMARY KEY (`itemID`);
1504
1505--
1506-- Indexes for table `characters`
1507--
1508ALTER TABLE `characters`
1509 ADD PRIMARY KEY (`ID`);
1510
1511--
1512-- Indexes for table `contacts`
1513--
1514ALTER TABLE `contacts`
1515 ADD PRIMARY KEY (`contactID`);
1516
1517--
1518-- Indexes for table `crates`
1519--
1520ALTER TABLE `crates`
1521 ADD PRIMARY KEY (`crateID`);
1522
1523--
1524-- Indexes for table `dealervehicles`
1525--
1526ALTER TABLE `dealervehicles`
1527 ADD PRIMARY KEY (`vehID`);
1528
1529--
1530-- Indexes for table `detectors`
1531--
1532ALTER TABLE `detectors`
1533 ADD PRIMARY KEY (`detectorID`);
1534
1535--
1536-- Indexes for table `dropped`
1537--
1538ALTER TABLE `dropped`
1539 ADD PRIMARY KEY (`ID`);
1540
1541--
1542-- Indexes for table `entrances`
1543--
1544ALTER TABLE `entrances`
1545 ADD PRIMARY KEY (`entranceID`);
1546
1547--
1548-- Indexes for table `factions`
1549--
1550ALTER TABLE `factions`
1551 ADD PRIMARY KEY (`factionID`);
1552
1553--
1554-- Indexes for table `furniture`
1555--
1556ALTER TABLE `furniture`
1557 ADD PRIMARY KEY (`furnitureID`);
1558
1559--
1560-- Indexes for table `garbage`
1561--
1562ALTER TABLE `garbage`
1563 ADD PRIMARY KEY (`garbageID`);
1564
1565--
1566-- Indexes for table `gates`
1567--
1568ALTER TABLE `gates`
1569 ADD PRIMARY KEY (`gateID`);
1570
1571--
1572-- Indexes for table `gps`
1573--
1574ALTER TABLE `gps`
1575 ADD PRIMARY KEY (`locationID`);
1576
1577--
1578-- Indexes for table `graffiti`
1579--
1580ALTER TABLE `graffiti`
1581 ADD PRIMARY KEY (`graffitiID`);
1582
1583--
1584-- Indexes for table `gunracks`
1585--
1586ALTER TABLE `gunracks`
1587 ADD PRIMARY KEY (`rackID`);
1588
1589--
1590-- Indexes for table `houses`
1591--
1592ALTER TABLE `houses`
1593 ADD PRIMARY KEY (`houseID`);
1594
1595--
1596-- Indexes for table `housestorage`
1597--
1598ALTER TABLE `housestorage`
1599 ADD PRIMARY KEY (`itemID`);
1600
1601--
1602-- Indexes for table `impoundlots`
1603--
1604ALTER TABLE `impoundlots`
1605 ADD PRIMARY KEY (`impoundID`);
1606
1607--
1608-- Indexes for table `inventory`
1609--
1610ALTER TABLE `inventory`
1611 ADD PRIMARY KEY (`invID`);
1612
1613--
1614-- Indexes for table `jobs`
1615--
1616ALTER TABLE `jobs`
1617 ADD PRIMARY KEY (`jobID`);
1618
1619--
1620-- Indexes for table `namechanges`
1621--
1622ALTER TABLE `namechanges`
1623 ADD PRIMARY KEY (`ID`);
1624
1625--
1626-- Indexes for table `plants`
1627--
1628ALTER TABLE `plants`
1629 ADD PRIMARY KEY (`plantID`);
1630
1631--
1632-- Indexes for table `pumps`
1633--
1634ALTER TABLE `pumps`
1635 ADD PRIMARY KEY (`pumpID`);
1636
1637--
1638-- Indexes for table `speedcameras`
1639--
1640ALTER TABLE `speedcameras`
1641 ADD PRIMARY KEY (`speedID`);
1642
1643--
1644-- Indexes for table `tickets`
1645--
1646ALTER TABLE `tickets`
1647 ADD PRIMARY KEY (`ticketID`);
1648
1649--
1650-- Indexes for table `vendors`
1651--
1652ALTER TABLE `vendors`
1653 ADD PRIMARY KEY (`vendorID`);
1654
1655--
1656-- Indexes for table `warrants`
1657--
1658ALTER TABLE `warrants`
1659 ADD PRIMARY KEY (`ID`);
1660
1661--
1662-- AUTO_INCREMENT for dumped tables
1663--
1664
1665--
1666-- AUTO_INCREMENT for table `accounts`
1667--
1668ALTER TABLE `accounts`
1669 MODIFY `ID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
1670--
1671-- AUTO_INCREMENT for table `arrestpoints`
1672--
1673ALTER TABLE `arrestpoints`
1674 MODIFY `arrestID` int(11) NOT NULL AUTO_INCREMENT;
1675--
1676-- AUTO_INCREMENT for table `backpackitems`
1677--
1678ALTER TABLE `backpackitems`
1679 MODIFY `itemID` int(12) NOT NULL AUTO_INCREMENT;
1680--
1681-- AUTO_INCREMENT for table `backpacks`
1682--
1683ALTER TABLE `backpacks`
1684 MODIFY `backpackID` int(12) NOT NULL AUTO_INCREMENT;
1685--
1686-- AUTO_INCREMENT for table `billboards`
1687--
1688ALTER TABLE `billboards`
1689 MODIFY `bbID` int(12) NOT NULL AUTO_INCREMENT;
1690--
1691-- AUTO_INCREMENT for table `businesses`
1692--
1693ALTER TABLE `businesses`
1694 MODIFY `bizID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=104;
1695--
1696-- AUTO_INCREMENT for table `cars`
1697--
1698ALTER TABLE `cars`
1699 MODIFY `carID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=242;
1700--
1701-- AUTO_INCREMENT for table `carstorage`
1702--
1703ALTER TABLE `carstorage`
1704 MODIFY `itemID` int(12) NOT NULL AUTO_INCREMENT;
1705--
1706-- AUTO_INCREMENT for table `characters`
1707--
1708ALTER TABLE `characters`
1709 MODIFY `ID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
1710--
1711-- AUTO_INCREMENT for table `contacts`
1712--
1713ALTER TABLE `contacts`
1714 MODIFY `contactID` int(12) NOT NULL AUTO_INCREMENT;
1715--
1716-- AUTO_INCREMENT for table `crates`
1717--
1718ALTER TABLE `crates`
1719 MODIFY `crateID` int(12) NOT NULL AUTO_INCREMENT;
1720--
1721-- AUTO_INCREMENT for table `dealervehicles`
1722--
1723ALTER TABLE `dealervehicles`
1724 MODIFY `vehID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=148;
1725--
1726-- AUTO_INCREMENT for table `detectors`
1727--
1728ALTER TABLE `detectors`
1729 MODIFY `detectorID` int(12) NOT NULL AUTO_INCREMENT;
1730--
1731-- AUTO_INCREMENT for table `dropped`
1732--
1733ALTER TABLE `dropped`
1734 MODIFY `ID` int(12) NOT NULL AUTO_INCREMENT;
1735--
1736-- AUTO_INCREMENT for table `entrances`
1737--
1738ALTER TABLE `entrances`
1739 MODIFY `entranceID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=56;
1740--
1741-- AUTO_INCREMENT for table `factions`
1742--
1743ALTER TABLE `factions`
1744 MODIFY `factionID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
1745--
1746-- AUTO_INCREMENT for table `furniture`
1747--
1748ALTER TABLE `furniture`
1749 MODIFY `furnitureID` int(12) NOT NULL AUTO_INCREMENT;
1750--
1751-- AUTO_INCREMENT for table `garbage`
1752--
1753ALTER TABLE `garbage`
1754 MODIFY `garbageID` int(12) NOT NULL AUTO_INCREMENT;
1755--
1756-- AUTO_INCREMENT for table `gates`
1757--
1758ALTER TABLE `gates`
1759 MODIFY `gateID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
1760--
1761-- AUTO_INCREMENT for table `gps`
1762--
1763ALTER TABLE `gps`
1764 MODIFY `locationID` int(12) NOT NULL AUTO_INCREMENT;
1765--
1766-- AUTO_INCREMENT for table `graffiti`
1767--
1768ALTER TABLE `graffiti`
1769 MODIFY `graffitiID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
1770--
1771-- AUTO_INCREMENT for table `gunracks`
1772--
1773ALTER TABLE `gunracks`
1774 MODIFY `rackID` int(12) NOT NULL AUTO_INCREMENT;
1775--
1776-- AUTO_INCREMENT for table `houses`
1777--
1778ALTER TABLE `houses`
1779 MODIFY `houseID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=291;
1780--
1781-- AUTO_INCREMENT for table `housestorage`
1782--
1783ALTER TABLE `housestorage`
1784 MODIFY `itemID` int(12) NOT NULL AUTO_INCREMENT;
1785--
1786-- AUTO_INCREMENT for table `impoundlots`
1787--
1788ALTER TABLE `impoundlots`
1789 MODIFY `impoundID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
1790--
1791-- AUTO_INCREMENT for table `inventory`
1792--
1793ALTER TABLE `inventory`
1794 MODIFY `invID` int(12) NOT NULL AUTO_INCREMENT;
1795--
1796-- AUTO_INCREMENT for table `jobs`
1797--
1798ALTER TABLE `jobs`
1799 MODIFY `jobID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=35;
1800--
1801-- AUTO_INCREMENT for table `namechanges`
1802--
1803ALTER TABLE `namechanges`
1804 MODIFY `ID` int(12) NOT NULL AUTO_INCREMENT;
1805--
1806-- AUTO_INCREMENT for table `plants`
1807--
1808ALTER TABLE `plants`
1809 MODIFY `plantID` int(12) NOT NULL AUTO_INCREMENT;
1810--
1811-- AUTO_INCREMENT for table `pumps`
1812--
1813ALTER TABLE `pumps`
1814 MODIFY `pumpID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
1815--
1816-- AUTO_INCREMENT for table `speedcameras`
1817--
1818ALTER TABLE `speedcameras`
1819 MODIFY `speedID` int(12) NOT NULL AUTO_INCREMENT;
1820--
1821-- AUTO_INCREMENT for table `tickets`
1822--
1823ALTER TABLE `tickets`
1824 MODIFY `ticketID` int(12) NOT NULL AUTO_INCREMENT;
1825--
1826-- AUTO_INCREMENT for table `vendors`
1827--
1828ALTER TABLE `vendors`
1829 MODIFY `vendorID` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
1830--
1831-- AUTO_INCREMENT for table `warrants`
1832--
1833ALTER TABLE `warrants`
1834 MODIFY `ID` int(12) NOT NULL AUTO_INCREMENT;
1835/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1836/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1837/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;