· 9 years ago · Nov 13, 2016, 11:46 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.10.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 29, 2016 at 01:00 PM
7-- Server version: 5.5.50-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 utf8 */;
18
19--
20-- Database: `Real-GameDB`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `banlog`
27--
28
29CREATE TABLE IF NOT EXISTS `banlog` (
30`ID` int(11) NOT NULL,
31 `ip` varchar(25) NOT NULL,
32 `player` varchar(25) NOT NULL,
33 `admin` varchar(25) NOT NULL,
34 `reason` varchar(60) NOT NULL,
35 `time` varchar(60) NOT NULL
36) ENGINE=MyISAM DEFAULT CHARSET=latin1;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `bizz`
42--
43
44CREATE TABLE IF NOT EXISTS `bizz` (
45`ID` int(11) NOT NULL,
46 `Owned` int(11) NOT NULL,
47 `Owner` varchar(25) NOT NULL DEFAULT 'AdmBot',
48 `Message` varchar(50) NOT NULL,
49 `EntranceX` float NOT NULL,
50 `EntranceY` float NOT NULL,
51 `EntranceZ` float NOT NULL,
52 `ExitX` float NOT NULL,
53 `ExitY` float NOT NULL,
54 `ExitZ` float NOT NULL,
55 `LevelNeeded` int(11) NOT NULL,
56 `BuyPrice` int(11) NOT NULL,
57 `EntranceCost` int(11) NOT NULL,
58 `Till` int(11) NOT NULL,
59 `Locked` int(11) NOT NULL,
60 `Interior` int(11) NOT NULL,
61 `Products` int(11) NOT NULL,
62 `MaxProducts` int(11) NOT NULL,
63 `PriceProd` int(11) NOT NULL,
64 `Virtual` int(11) NOT NULL
65) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
66
67--
68-- Dumping data for table `bizz`
69--
70
71INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Products`, `MaxProducts`, `PriceProd`, `Virtual`) VALUES
72(1, 1, 'AdmBot', 'LS Bank', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 10, 500000, 1000, 5331172, 0, 0, 8408, 10000, 100, 0),
73(2, 1, 'AdmBot', 'B4L Gun Shop Los Santos', 1791.52, -1164.86, 23.8281, 316, -142, 1000, 9, 500000, 5000, 1746695, 0, 7, 9502, 10000, 100, 0),
74(3, 1, 'AdmBot', '*** Club ***', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 4, 500000, 5000, 173257, 0, 17, 9968, 10000, 100, 0),
75(4, 1, 'AdmBot', 'KRYSTAL', 2129.86, -1761.46, 13.5625, -228.27, 1401.07, 27.7656, 3, 500000, 15000, 119777, 0, 18, 9996, 10000, 100, 0),
76(5, 1, 'AdmBot', '*** Strip Club ***', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 3, 500000, 5000, 358374, 0, 2, 9880, 10000, 100, 0),
77(6, 1, 'AdmBot', 'CASA ADAM', 1498.5, -1581.31, 13.5498, -794.942, 490.782, 1376.2, 6, 500000, 15000, 0, 0, 1, 562, 1000, 100, 0),
78(7, 1, 'AdmBot', 'Sex Shop ', 1098.8, -1473.6, 15.7969, -100.403, -24.3921, 1000.72, 5, 500000, 15000, 60080, 0, 3, 9992, 10000, 100, 0),
79(8, 1, 'AdmBot', 'Radio Bussines', 1112.43, -1520.66, 15.7969, 1259.39, -804.104, 1084.02, 5, 500000, 5000, 35000, 0, 5, 9851, 10000, 100, 1);
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `cars`
85--
86
87CREATE TABLE IF NOT EXISTS `cars` (
88`ID` int(11) NOT NULL,
89 `Model` int(11) NOT NULL,
90 `Locationx` float NOT NULL,
91 `Locationy` float NOT NULL,
92 `Locationz` float NOT NULL,
93 `Angle` float NOT NULL,
94 `ColorOne` int(11) NOT NULL,
95 `ColorTwo` int(11) NOT NULL,
96 `Owner` varchar(25) NOT NULL DEFAULT 'Dealership',
97 `Value` int(20) NOT NULL,
98 `License` varchar(14) NOT NULL DEFAULT 'NewCar',
99 `Description` varchar(50) NOT NULL,
100 `Lockk` int(3) NOT NULL,
101 `Timed` int(11) NOT NULL,
102 `Inscarprice` int(11) NOT NULL,
103 `Insurancecar` int(11) NOT NULL,
104 `KM` float NOT NULL,
105 `Owned` int(11) NOT NULL,
106 `Spawned` int(11) NOT NULL,
107 `Sell` int(11) NOT NULL,
108 `mod1` int(24) NOT NULL,
109 `mod2` int(24) NOT NULL,
110 `mod3` int(24) NOT NULL,
111 `mod4` int(24) NOT NULL,
112 `mod5` int(24) NOT NULL,
113 `mod6` int(24) NOT NULL,
114 `mod7` int(24) NOT NULL,
115 `mod8` int(24) NOT NULL,
116 `mod9` int(24) NOT NULL,
117 `mod10` int(24) NOT NULL,
118 `mod11` int(24) NOT NULL,
119 `mod12` int(24) NOT NULL,
120 `mod13` int(24) NOT NULL,
121 `mod14` int(24) NOT NULL,
122 `mod15` int(24) NOT NULL,
123 `mod16` int(24) NOT NULL,
124 `mod17` int(24) NOT NULL,
125 `PaintJ` int(24) NOT NULL DEFAULT '6'
126) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
127
128-- --------------------------------------------------------
129
130--
131-- Table structure for table `charity`
132--
133
134CREATE TABLE IF NOT EXISTS `charity` (
135`ID` int(11) NOT NULL,
136 `CharityMoney` int(20) NOT NULL
137) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
138
139-- --------------------------------------------------------
140
141--
142-- Table structure for table `factionlog`
143--
144
145CREATE TABLE IF NOT EXISTS `factionlog` (
146`ID` int(11) NOT NULL,
147 `factionid` int(11) NOT NULL,
148 `player` varchar(64) NOT NULL,
149 `action` varchar(64) NOT NULL,
150 `time` varchar(64) NOT NULL
151) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
152
153-- --------------------------------------------------------
154
155--
156-- Table structure for table `factions`
157--
158
159CREATE TABLE IF NOT EXISTS `factions` (
160`ID` int(11) NOT NULL,
161 `Name` varchar(50) NOT NULL,
162 `X` float NOT NULL,
163 `Y` float NOT NULL,
164 `Z` float NOT NULL,
165 `Mats` int(11) NOT NULL,
166 `Drugs` int(11) NOT NULL,
167 `Bank` int(11) NOT NULL
168) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
169
170--
171-- Dumping data for table `factions`
172--
173
174INSERT INTO `factions` (`ID`, `Name`, `X`, `Y`, `Z`, `Mats`, `Drugs`, `Bank`) VALUES
175(1, 'pd', 0, 0, 0, 0, 0, 0),
176(2, 'fbi', 0, 0, 0, 0, 0, 0),
177(3, 'ng', 0, 0, 0, 0, 0, 0),
178(4, 'Triad', 774.214, -48.9243, 1000.59, 1, 22224, 2441401),
179(5, 'Porrello', 1702.38, -1667.68, 20.2188, 103, 4850, 545109),
180(6, 'Sicillian', 2316.21, -1143.7, 1054.3, 0, -111100, 1705006),
181(7, 'guv', 0, 0, 0, 0, 0, 0),
182(8, 'ttc', 0, 0, 0, 0, 0, 0),
183(9, 'nr', 0, 0, 0, 0, 0, 0),
184(10, 'Rusian', 956.566, -53.9777, 1001.12, 0, 0, 2365001);
185
186-- --------------------------------------------------------
187
188--
189-- Table structure for table `houses`
190--
191
192CREATE TABLE IF NOT EXISTS `houses` (
193`ID` int(11) NOT NULL,
194 `Entrancex` float NOT NULL,
195 `Entrancey` float NOT NULL,
196 `Entrancez` float NOT NULL,
197 `Exitx` float NOT NULL,
198 `Exity` float NOT NULL,
199 `Exitz` float NOT NULL,
200 `Owner` varchar(25) NOT NULL DEFAULT 'The State',
201 `Discription` varchar(50) NOT NULL,
202 `Value` int(20) NOT NULL,
203 `Hel` int(11) NOT NULL,
204 `Arm` int(11) NOT NULL,
205 `Interior` int(11) NOT NULL,
206 `Lockk` int(11) NOT NULL,
207 `Owned` int(11) NOT NULL,
208 `Rent` int(11) NOT NULL,
209 `Rentabil` int(11) NOT NULL,
210 `Takings` int(11) NOT NULL,
211 `Level` int(11) NOT NULL,
212 `Virtual` int(11) NOT NULL
213) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
214
215--
216-- Dumping data for table `houses`
217--
218
219INSERT INTO `houses` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Hel`, `Arm`, `Interior`, `Lockk`, `Owned`, `Rent`, `Rentabil`, `Takings`, `Level`, `Virtual`) VALUES
220(1, 1421.85, -885.64, 50.6647, 225.94, 1022.69, 1084.01, 'AdmBot', 'Vinewood', 3500000, 1, 0, 7, 0, 1, 1, 1, 230, 8, 0),
221(2, 1468.62, -904.898, 54.8359, 225.88, 1022.95, 1084.01, 'AdmBot', 'Nu este de vanzare', 3000000, 1, 0, 7, 1, 1, 1, 1, 717, 8, 1),
222(3, 1539.26, -851.508, 64.3361, 235.188, 1187.54, 1080.26, 'AdmBot', 'Barlogul Lupilor', 1, 1, 0, 3, 0, 1, 1, 1, 15265, 7, 2),
223(4, 1534.06, -800.188, 72.8495, 491.203, 1399.24, 1080.26, 'AdmBot', 'Network Director House', 2000000, 1, 0, 2, 0, 1, 1, 0, 15, 6, 3),
224(5, 1527.3, -773.188, 80.5781, 491.203, 1399.24, 1080.26, 'AdmBot', '.', 2000000, 1, 0, 2, 1, 1, 1, 0, 75363, 6, 4),
225(6, 1497.06, -688.239, 95.5086, 140.325, 1366.66, 1083.86, 'AdmBot', 'Welcome!', 5000000, 1, 0, 5, 1, 1, 0, 1, 0, 20, 5),
226(7, 1112.11, -742.075, 100.133, 227.021, 1114.34, 1081, 'AdmBot', '.', 2500000, 1, 0, 5, 1, 1, 14, 1, 1867, 8, 6),
227(8, 1093.9, -806.597, 107.419, 2196.12, -1204.33, 1049.02, 'AdmBot', 'OZN', 3000000, 0, 0, 6, 0, 1, 1, 1, 53, 6, 7),
228(9, 1034.74, -812.627, 101.852, 447.043, 1397.9, 1084.3, 'AdmBot', 'Lautari', 19000000, 0, 0, 2, 0, 1, 1, 1, 457220, 7, 8),
229(10, 1094.91, -647.068, 113.648, 22.9734, 1404.15, 1084.43, 'AdmBot', 'Vinewood', 4000000, 0, 0, 5, 0, 1, 1, 1, 242, 10, 9),
230(11, 980.352, -676.742, 121.976, 140.17, 1366.07, 1083.65, 'AdmBot', 'The King Club', 20000000, 1, 0, 5, 1, 1, 1, 1, 677, 15, 10),
231(12, 990.004, -828.547, 95.4686, 223.005, 1287.6, 1082.14, 'AdmBot', '. . .', 63000000, 0, 0, 1, 1, 1, 1, 0, 156, 5, 11),
232(13, 937.327, -847.405, 93.7796, 223.005, 1287.6, 1082.14, 'AdmBot', 'MAGNAT', 1500000, 0, 0, 1, 0, 1, 1, 1, 190, 5, 12),
233(14, 836.166, -894.341, 68.7689, 386.402, 1471.7, 1080.19, 'AdmBot', 'MaRiUS. House', 3000000, 1, 0, 15, 0, 1, 1, 1, 369, 7, 13),
234(15, 827.889, -858.718, 70.3308, 376.136, 1417.34, 1081.33, 'AdmBot', 'IMPARAT', 2500000, 1, 0, 15, 1, 1, 1, 1, 128, 6, 14),
235(16, 1981.29, -1718.79, 17.0301, 2495.74, -1692.82, 1014.74, 'AdmBot', 'Casa Manelelor', 3500000, 1, 1, 3, 1, 1, 100, 0, 63191, 6, 15),
236(17, 2495.35, -1690.12, 14.7656, 2496.05, -1692.73, 1014.74, 'AdmBot', 'THE MENTALIST', 2000000, 1, 0, 3, 1, 1, 1, 1, 71, 14, 16),
237(18, 1854.1, -1914.87, 15.2568, 2259.74, -1135.83, 1050.63, 'AdmBot', 'No name', 900000, 1, 0, 10, 1, 1, 1, 1, 60195, 3, 17),
238(19, 1872.32, -1912.36, 15.2568, 2259.86, -1135.86, 1050.63, 'AdmBot', 'Marijuana House.', 5000000, 1, 0, 10, 1, 1, 1, 0, 165, 4, 18),
239(20, 2672.72, -1990.09, 13.9935, 2308.74, -1212.61, 1049.02, 'AdmBot', 'Willowfield', 500000, 1, 0, 6, 0, 1, 1000, 1, 15000, 4, 19),
240(21, 2808, -1176.59, 25.3797, 24.0261, 1340.52, 1084.38, 'AdmBot', 'Nu intra, RISTI BAN ![JR]', 1000000, 1, 0, 10, 0, 1, 1, 1, 17, 9, 20),
241(22, 2519.42, -1112.92, 56.5926, -42.5426, 1406.23, 1084.43, 'AdmBot', 'Las Colinas', 1, 1, 0, 8, 0, 1, 1000, 1, 22000, 5, 21),
242(23, 2191.42, -1276.37, 25.1563, 2233.57, -1114.62, 1050.88, 'AdmBot', 'Tow Truck Company POWA', 900000, 1, 0, 5, 0, 1, 1, 1, 319, 6, 22),
243(24, 2147.98, -1484.88, 26.6241, 235.228, 1187.86, 1080.26, 'AdmBot', 'Vila de Magnati', 1000000, 1, 0, 3, 0, 1, 1, 1, 2145, 6, 23),
244(25, 1905.88, -1113.42, 26.6641, 446.534, 507.182, 1001.42, 'AdmBot', 'VEX`s Residence', 600000, 1, 0, 12, 0, 1, 1, 1, 55, 5, 24),
245(26, 1111.6, -976.003, 42.7656, 300.745, 310.174, 1003.3, 'AdmBot', 'Los Santos', 1500000, 1, 0, 4, 0, 1, 1, 1, 1936, 7, 25),
246(27, 1050.96, -1057.95, 34.7969, 2237.52, -1081.16, 1049.02, 'AdmBot', 'BGS HQ', 950000, 1, 0, 2, 1, 1, 1, 1, 269, 5, 26),
247(28, 850.313, -1520.14, 14.1739, 2365.32, -1134.59, 1050.88, 'AdmBot', '*** Vicious House ***', 2000000, 1, 0, 8, 0, 1, 1, 1, 131, 7, 27),
248(29, 315.85, -1769.75, 4.631, 2196, -1204.32, 1049.02, 'AdmBot', 'Summer Club', 2500000, 1, 1, 6, 0, 1, 1, 0, 51, 10, 28),
249(30, 1804.11, -2124.18, 13.9424, 223.072, 1288.01, 1082.14, 'AdmBot', 'Casa de Bagnati', 1, 1, 1, 1, 1, 1, 15000, 1, 15014, 5, 29),
250(31, 1684.83, -2098.62, 13.8343, 223.021, 1287.73, 1082.14, 'AdmBot', 'Corona House', 4000000, 1, 0, 1, 1, 1, 1, 1, 247, 6, 30),
251(32, 1331.87, -632.87, 109.135, 2317.82, -1026.4, 1050.22, 'AdmBot', 'ZEW', 20500000, 1, 0, 9, 1, 1, 0, 1, 0, 13, 31),
252(33, 300.255, -1154.46, 81.391, 140.075, 1367.21, 1083.86, 'AdmBot', 'Nimic.', 20000000, 1, 0, 5, 1, 1, 1, 1, 14123, 15, 32),
253(34, 977.377, -770.917, 112.203, -42.5781, 1405.96, 1084.43, 'AdmBot', 'SkyFlame SEF', 3000000, 0, 0, 8, 1, 1, 15000, 1, 135000, 7, 33),
254(35, 1247.08, -908.934, 46.6016, 2233.79, -1114.59, 1050.88, 'AdmBot', 'HOUSE DE MAGNATI', 1, 1, 0, 5, 1, 1, 2, 1, 278, 5, 34),
255(36, 1285.05, -904.014, 46.6328, 2217.68, -1076.33, 1050.48, 'AdmBot', '[OC]Kovac Propriety', 1, 1, 0, 1, 1, 1, 1, 0, 183, 5, 35),
256(37, 952.289, -909.99, 45.7656, 234.166, 1064.05, 1084.21, 'AdmBot', '*** Vicious H.Q. ***', 1, 1, 0, 6, 0, 1, 1, 1, 878, 12, 36),
257(38, 1378.71, -1753.22, 14.1406, 2196.09, -1204.05, 1049.02, 'AdmBot', 'Dance Dance Revolution', 10000000, 1, 1, 6, 1, 1, 1, 1, 197, 7, 37),
258(39, 1981.84, -1682.86, 17.0538, 83.0945, 1322.78, 1083.87, 'AdmBot', '4nDrEi95 SafeHouse', 3000000, 1, 1, 9, 1, 1, 1, 0, 102, 6, 38),
259(40, 2385.39, -1712.06, 14.2422, 2495.98, -1692.08, 1014.74, 'AdmBot', 'Camatarii', 25000000, 1, 0, 3, 0, 1, 1, 1, 104, 13, 39),
260(41, 1258.7, -785.379, 92.0302, 225.68, 1021.45, 1084.02, 'AdmBot', 'Semper Superiores', 30000000, 1, 0, 7, 0, 1, 16, 1, 9941, 16, 40),
261(42, 2393.2, -1646.26, 13.9051, 140.325, 1366.66, 1083.86, 'AdmBot', 'MAYBE STAFF', 5000000, 1, 0, 5, 0, 1, 0, 0, 0, 10, 41),
262(43, 2486.52, -1645.6, 14.0772, 2496.05, -1692.73, 1014.74, 'AdmBot', '[¬ ZEW HeadQuarters ¬]', 100000000, 1, 1, 3, 1, 1, 1, 0, 632, 12, 42),
263(44, 2362.77, -1643.74, 14.0649, 225.721, 1022.18, 1084.02, 'AdmBot', 'STAFF', 10000000, 0, 0, 7, 0, 1, 1, 1, 584, 12, 43),
264(45, 254.887, -1366.69, 53.1094, 234.19, 1063.73, 1084.21, 'AdmBot', '*** Vicious House ***', 10000000, 1, 1, 6, 1, 1, 1, 1, 40, 14, 44),
265(46, 189.638, -1308.32, 70.2492, 225.68, 1021.45, 1084.02, 'AdmBot', 'OLD CREW', 20000000, 1, 0, 7, 1, 1, 1, 1, 687, 15, 45),
266(47, 251.765, -1220.67, 75.9508, 235.34, 1186.68, 1080.26, 'AdmBot', 'Agent 47', 15000000, 1, 0, 3, 1, 1, 1, 0, 15745, 14, 46),
267(48, 416.651, -1154.24, 76.6876, 491.07, 1398.5, 1080.26, 'AdmBot', 'Semper Superiores', 7000000, 1, 0, 2, 1, 1, 1, 1, 3333, 10, 47),
268(49, 2384.6, -1675.31, 14.9152, 260.85, 1237.24, 1084.26, 'AdmBot', '||| Steam Name: supermataa ||| ', 5000000, 0, 0, 9, 0, 1, 0, 1, 0, 13, 48),
269(50, 2327.62, -1681.99, 14.9297, 260.85, 1237.24, 1084.26, 'AdmBot', 'Am numa valuta', 6000000, 0, 0, 9, 0, 1, 0, 1, 0, 15, 49),
270(51, 1442.69, -629.352, 95.7186, 225.68, 1021.45, 1084.02, 'AdmBot', 'Cine citeste, pl o beleste', 10000000, 1, 0, 7, 0, 1, 0, 1, 0, 20, 50),
271(52, 253.206, -1270, 74.4307, 140.075, 1367.21, 1083.86, 'AdmBot', 'Casa de Magnati!', 10000000, 1, 0, 5, 1, 1, 0, 1, 0, 15, 51),
272(53, 298.488, -1338.02, 53.4415, 235.34, 1186.68, 1080.26, 'AdmBot', 'Casa De Magnat <3', 15000000, 0, 0, 3, 0, 1, 1, 1, 1589, 15, 52),
273(54, 795.161, -506.891, 18.0129, 1262.14, -785.331, 1091.91, 'AdmBot', 'â„¢MAYOR HOUSEâ„¢ ARMOUR + HEAL', 25000000, 1, 0, 5, 1, 1, 0, 1, 0, 25, 53),
274(55, 854.511, -604.539, 18.4219, 140.17, 1366.07, 1083.65, 'AdmBot', 'Vicious Special', 20000000, 1, 0, 5, 0, 1, 1, 1, 102, 20, 54),
275(56, -691.853, 939.666, 13.6328, 226.3, 1114.24, 1080.99, 'AdmBot', 'C@S@ C|_| V@L0@R3', 15000000, 1, 0, 5, 0, 1, 1, 1, 66, 15, 55);
276
277-- --------------------------------------------------------
278
279--
280-- Table structure for table `iplogs`
281--
282
283CREATE TABLE IF NOT EXISTS `iplogs` (
284`ID` int(11) NOT NULL,
285 `Log` varchar(128) NOT NULL,
286 `time` varchar(64) NOT NULL
287) ENGINE=MyISAM DEFAULT CHARSET=latin1;
288
289-- --------------------------------------------------------
290
291--
292-- Table structure for table `jaillog`
293--
294
295CREATE TABLE IF NOT EXISTS `jaillog` (
296`ID` int(11) NOT NULL,
297 `ip` varchar(25) NOT NULL,
298 `player` varchar(25) NOT NULL,
299 `admin` varchar(25) NOT NULL,
300 `reason` varchar(60) NOT NULL,
301 `min` int(11) NOT NULL,
302 `time` varchar(60) NOT NULL
303) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
304
305-- --------------------------------------------------------
306
307--
308-- Table structure for table `log_admin`
309--
310
311CREATE TABLE IF NOT EXISTS `log_admin` (
312`id` int(11) NOT NULL,
313 `log` varchar(256) NOT NULL,
314 `time` varchar(256) NOT NULL
315) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
316
317-- --------------------------------------------------------
318
319--
320-- Table structure for table `papers`
321--
322
323CREATE TABLE IF NOT EXISTS `papers` (
324`ID` int(11) NOT NULL,
325 `PaperUsed` int(11) NOT NULL,
326 `PaperMaker` varchar(40) NOT NULL,
327 `PaperTitle` varchar(40) NOT NULL,
328 `PaperText1` varchar(40) NOT NULL,
329 `PaperText2` varchar(40) NOT NULL,
330 `PaperText3` varchar(40) NOT NULL,
331 `PaperText4` varchar(40) NOT NULL,
332 `PaperText5` varchar(40) NOT NULL,
333 `PaperText6` varchar(40) NOT NULL,
334 `PaperText7` varchar(40) NOT NULL
335) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
336
337-- --------------------------------------------------------
338
339--
340-- Table structure for table `sbizz`
341--
342
343CREATE TABLE IF NOT EXISTS `sbizz` (
344`ID` int(11) NOT NULL,
345 `EntranceX` float NOT NULL,
346 `EntranceY` float NOT NULL,
347 `EntranceZ` float NOT NULL,
348 `Owner` varchar(25) NOT NULL,
349 `Discription` varchar(50) NOT NULL,
350 `Owned` int(11) NOT NULL,
351 `LevelNeeded` int(11) NOT NULL,
352 `BuyPrice` int(11) NOT NULL,
353 `EntranceCost` int(11) NOT NULL,
354 `Till` int(11) NOT NULL,
355 `Locked` int(11) NOT NULL,
356 `Interior` int(11) NOT NULL,
357 `Products` int(11) NOT NULL,
358 `MaxProducts` int(11) NOT NULL,
359 `PriceProd` int(11) NOT NULL
360) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
361
362--
363-- Dumping data for table `sbizz`
364--
365
366INSERT INTO `sbizz` (`ID`, `EntranceX`, `EntranceY`, `EntranceZ`, `Owner`, `Discription`, `Owned`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Products`, `MaxProducts`, `PriceProd`) VALUES
367(1, 1116.1, -923.542, 43.3906, 'AdmBot', 'CNN Los Santos, [/ad].', 1, 15, 500000, 5, 3378980, 0, 0, 8446, 10000, 100),
368(2, 1847.46, -1871.76, 13.5781, 'AdmBot', 'The Russian Mafia Property', 1, 5, 500000, 20000, 1079400, 0, 0, 9978, 10000, 100),
369(3, 1868.07, -1394.48, 13.507, 'AdmBot', 'Biciclete Vicious', 1, 3, 500000, 15000, 165000, 0, 0, 9979, 10000, 100),
370(4, 1310.16, -1368.18, 13.5457, 'AdmBot', 'PaintBall Arena', 1, 5, 500000, 5000, 4525000, 0, 0, 7581, 10000, 100),
371(5, 725.604, -1450.44, 17.6953, 'AdmBot', 'Inchiriaza o barca.', 1, 4, 500000, 15000, 60000, 0, 0, 9942, 10000, 100),
372(6, 563.145, -1289.79, 17.2482, 'AdmBot', 'Rent Car', 1, 5, 500000, 15000, 749900, 0, 0, 9972, 10000, 100),
373(7, 1738.19, -1270.06, 13.5438, 'AdmBot', 'Phone Company', 1, 7, 500000, 200, 2100800, 0, 0, 10000, 10000, 100),
374(8, 1766.64, -1363.75, 15.7578, 'AdmBot', 'General Store 24/7', 1, 6, 500000, 750, 3652750, 0, 0, 3725, 10000, 100),
375(9, 1452.2, -1143.22, 24.0332, 'AdmBot', 'General Clothes', 1, 4, 500000, 15000, 1719000, 0, 0, 9974, 10000, 100),
376(10, 2508.27, -1470.36, 24.034, 'AdmBot', 'Tow Car', 1, 6, 500000, 1000, 7404200, 0, 0, 8096, 10000, 100),
377(11, 1702.71, -1470.21, 13.5469, 'AdmBot', 'Triads POWER', 1, 3, 500000, 1000, 444000, 0, 0, 9223, 10000, 100),
378(12, 1412.43, -1700.16, 13.5395, 'AdmBot', '*** Vicious hotdogs ***', 1, 5, 500000, 500000, 66100, 0, 0, 8491, 10000, 100),
379(13, 1941.6, -1764.74, 13.6406, 'AdmBot', 'Gas Company', 1, 5, 500000, 15000, 1381900, 0, 0, 10000, 10000, 100),
380(14, 1422.19, -1487.52, 20.4323, 'AdmBot', 'Electricity Company', 1, 5, 500000, 50000, 685500, 0, 0, 10000, 10000, 100),
381(15, 1173.97, -1361.48, 13.9823, 'AdmBot', 'The Agency - Hospital Los Santos', 1, 9, 500000, 250, 3197800, 0, 0, 10000, 0, 100),
382(16, 1782.14, -1721.43, 13.5474, 'AdmBot', '* Vicious General Eat *', 1, 5, 500000, 15000, 67500, 0, 0, 775, 1000, 100),
383(17, 2074.87, -1831.28, 13.5545, 'AdmBot', 'Pay & Spray', 1, 6, 500000, 1, 9394, 0, 0, 9921, 10000, 100),
384(18, 1025.17, -1032.01, 31.9402, 'AdmBot', 'Pay & Spray', 1, 6, 500000, 3500, 2075300, 0, 0, 9706, 10000, 100),
385(19, 488.382, -1733.06, 11.1752, 'AdmBot', '007', 1, 6, 500000, 5000, 1059900, 0, 0, 9911, 10000, 100),
386(20, 1034.88, -1028.13, 32.1016, 'AdmBot', 'Vicious Tuning', 1, 7, 500000, 15000, 2669800, 0, 0, 9853, 10000, 100),
387(21, 2650.33, -2021.76, 14.1766, 'AdmBot', 'Antonel69', 1, 7, 500000, 15000, 30000, 0, 0, 9997, 10000, 100),
388(22, 2281.49, -2364.65, 13.5469, 'AdmBot', 'Kart Los Santos', 1, 5, 500000, 100, 300, 0, 0, 9997, 10000, 100);
389
390-- --------------------------------------------------------
391
392--
393-- Table structure for table `stock`
394--
395
396CREATE TABLE IF NOT EXISTS `stock` (
397`ID` int(11) NOT NULL,
398 `Stock` int(11) NOT NULL,
399 `Price` int(20) NOT NULL,
400 `Car` varchar(50) NOT NULL
401) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
402
403--
404-- Dumping data for table `stock`
405--
406
407INSERT INTO `stock` (`ID`, `Stock`, `Price`, `Car`) VALUES
408(1, 30, 45000000, 'Infernus'),
409(2, 30, 3000000, 'Bravura'),
410(3, 30, 30000000, 'Banshee'),
411(4, 30, 10000000, 'Admiral'),
412(5, 30, 30000000, 'Turismo'),
413(6, 30, 15000000, 'Sabre'),
414(7, 30, 20000000, 'Zr-350'),
415(8, 30, 22000000, 'Comet'),
416(9, 30, 15000000, 'Sandking'),
417(10, 30, 8000000, 'NRG'),
418(11, 30, 5000000, 'Fcr-900'),
419(12, 30, 40000000, 'Bullet'),
420(13, 30, 10000000, 'Sultan'),
421(14, 30, 25000000, 'Cheetach'),
422(15, 30, 18000000, 'Elegy'),
423(16, 30, 60000000, 'Hotring'),
424(17, 30, 13000000, 'Savana'),
425(18, 30, 15000000, 'Premier'),
426(19, 30, 50000000, 'Maverick'),
427(20, 30, 40000000, 'sparrow'),
428(21, 30, 5000000, 'Landstalker'),
429(22, 30, 2500000, 'Perenniel'),
430(23, 30, 2800000, 'Bobcat'),
431(24, 30, 3000000, 'Regina'),
432(25, 30, 3100000, 'Burrito'),
433(26, 30, 4000000, 'Intruder'),
434(27, 30, 13000000, 'Slamvan'),
435(28, 30, 20000000, 'Blade'),
436(29, 30, 25000000, 'Hustler'),
437(30, 30, 23000000, 'Merit'),
438(31, 30, 26000000, 'Windsor'),
439(32, 30, 16000000, 'Tahoma'),
440(33, 30, 30000000, 'Huntley'),
441(34, 30, 25000000, 'Buffalo'),
442(35, 30, 21000000, 'Super GT'),
443(36, 30, 19000000, 'Jester'),
444(37, 30, 17000000, 'Flash'),
445(38, 30, 15000000, 'Phoenix'),
446(39, 30, 2000000, 'Faggio'),
447(40, 30, 6000000, 'Freeway'),
448(41, 30, 4000000, 'Sanchez'),
449(42, 30, 3000000, 'Quad'),
450(43, 30, 4500000, 'Wayfarer'),
451(44, 30, 150000000, 'Hotknife'),
452(45, 30, 250000000, 'Monster Truck');
453
454-- --------------------------------------------------------
455
456--
457-- Table structure for table `stuff`
458--
459
460CREATE TABLE IF NOT EXISTS `stuff` (
461`ID` int(11) NOT NULL,
462 `Jackpot` int(20) NOT NULL,
463 `Tax` int(20) NOT NULL,
464 `TaxValue` int(20) NOT NULL,
465 `Security` int(3) NOT NULL
466) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
467
468-- --------------------------------------------------------
469
470--
471-- Table structure for table `turfs`
472--
473
474CREATE TABLE IF NOT EXISTS `turfs` (
475`ID` int(11) NOT NULL,
476 `Owned` int(11) NOT NULL,
477 `Time` int(11) NOT NULL,
478 `MinX` float NOT NULL,
479 `MinY` float NOT NULL,
480 `MaxX` float NOT NULL,
481 `MaxY` float NOT NULL
482) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
483
484--
485-- Dumping data for table `turfs`
486--
487
488INSERT INTO `turfs` (`ID`, `Owned`, `Time`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
489(1, 10, 0, 114.21, -1364.93, 506.54, -912.91),
490(2, 4, 0, 506.54, -1364.93, 899.25, -912.91),
491(3, 4, 0, 899.25, -1313.7, 1313.58, -912.91),
492(4, 10, 0, 1313.58, -1364.93, 1727.49, -912.91),
493(5, 4, 0, 1727.49, -1364.93, 2108.13, -912.91),
494(6, 4, 0, 2108.13, -1364.93, 2499.38, -912.91),
495(7, 4, 0, 2499.38, -1313.7, 2916.17, -912.91),
496(8, 10, 0, 114.21, -1821.03, 506.54, -1364.93),
497(9, 10, 0, 506.54, -1821.03, 899.25, -1364.93),
498(10, 6, 0, 899.25, -1721.9, 1313.58, -1313.7),
499(11, 4, 0, 1313.58, -1821.03, 1727.49, -1364.93),
500(12, 4, 0, 1727.49, -1821.03, 2108.13, -1364.93),
501(13, 4, 0, 2108.13, -1821.03, 2499.38, -1364.93),
502(14, 4, 0, 2499.38, -1737.65, 2916.17, -1313.7),
503(15, 6, 0, 899.25, -2131.32, 1313.58, -1721.9),
504(16, 6, 0, 899.25, -2489.99, 1313.58, -2131.32),
505(17, 6, 0, 1313.58, -2250.92, 1727.49, -1821.03),
506(18, 4, 0, 1727.49, -2250.92, 2108.13, -1821.03),
507(19, 4, 0, 2108.13, -2250.92, 2499.38, -1821.03),
508(20, 4, 0, 2499.38, -2172.41, 2916.17, -1737.65),
509(21, 4, 0, 1313.58, -2690.47, 1727.49, -2250.92),
510(22, 4, 0, 1727.49, -2690.47, 2108.13, -2250.92),
511(23, 4, 0, 2108.13, -2690.47, 2499.38, -2250.92),
512(24, 4, 0, 2499.38, -2567.91, 2916.17, -2172.41);
513
514-- --------------------------------------------------------
515
516--
517-- Table structure for table `users`
518--
519
520CREATE TABLE IF NOT EXISTS `users` (
521`id` int(11) NOT NULL,
522 `name` varchar(25) NOT NULL,
523 `password` varchar(50) NOT NULL,
524 `Level` int(3) NOT NULL DEFAULT '0',
525 `Admin` int(2) NOT NULL DEFAULT '0',
526 `Helper` int(2) NOT NULL DEFAULT '0',
527 `Premium` int(2) NOT NULL DEFAULT '0',
528 `ConnectedTime` int(11) NOT NULL DEFAULT '0',
529 `Registered` int(2) NOT NULL DEFAULT '0',
530 `Sex` int(2) NOT NULL DEFAULT '0',
531 `Age` int(3) NOT NULL DEFAULT '0',
532 `Origin` int(2) NOT NULL DEFAULT '1',
533 `Muted` int(2) NOT NULL DEFAULT '0',
534 `MuteTime` int(11) NOT NULL DEFAULT '0',
535 `Respect` int(11) NOT NULL DEFAULT '0',
536 `Money` int(11) NOT NULL DEFAULT '0',
537 `Bank` int(11) NOT NULL DEFAULT '0',
538 `Crimes` int(11) NOT NULL DEFAULT '0',
539 `Kills` int(11) NOT NULL DEFAULT '0',
540 `Deaths` int(11) NOT NULL DEFAULT '0',
541 `Arrested` int(11) NOT NULL DEFAULT '0',
542 `WantedDeaths` int(11) NOT NULL DEFAULT '0',
543 `Phonebook` int(2) NOT NULL DEFAULT '0',
544 `LottoNr` int(5) NOT NULL DEFAULT '0',
545 `WantedLevel` int(11) NOT NULL DEFAULT '0',
546 `Fishes` int(3) NOT NULL DEFAULT '0',
547 `RFishes` int(2) NOT NULL DEFAULT '0',
548 `Job` int(3) NOT NULL DEFAULT '0',
549 `Paycheck` int(11) NOT NULL DEFAULT '0',
550 `HeadValue` int(11) NOT NULL DEFAULT '0',
551 `Jailed` int(2) NOT NULL DEFAULT '0',
552 `JailTime` int(11) NOT NULL DEFAULT '0',
553 `Materials` int(11) NOT NULL DEFAULT '0',
554 `Drugs` int(11) NOT NULL DEFAULT '0',
555 `Leader` int(3) NOT NULL DEFAULT '0',
556 `Member` int(3) NOT NULL DEFAULT '0',
557 `Rank` int(2) NOT NULL DEFAULT '0',
558 `CChar` int(11) NOT NULL,
559 `FWarn` int(2) NOT NULL DEFAULT '0',
560 `FPunish` int(4) NOT NULL DEFAULT '0',
561 `Acceptpoints` int(2) NOT NULL DEFAULT '0',
562 `SexSkill` int(11) NOT NULL DEFAULT '0',
563 `LawSkill` int(11) NOT NULL DEFAULT '0',
564 `MechSkill` int(11) NOT NULL DEFAULT '0',
565 `NewsSkill` int(11) NOT NULL DEFAULT '0',
566 `DrugsSkill` int(11) NOT NULL DEFAULT '0',
567 `FishSkill` int(11) NOT NULL DEFAULT '0',
568 `MatSkill` int(11) NOT NULL DEFAULT '0',
569 `RobSkill` int(11) NOT NULL DEFAULT '0',
570 `pHealth` float NOT NULL,
571 `Inter` int(3) NOT NULL DEFAULT '0',
572 `Local` int(11) NOT NULL DEFAULT '0',
573 `Team` int(3) NOT NULL DEFAULT '0',
574 `Model` int(11) NOT NULL,
575 `PhoneNr` int(5) NOT NULL DEFAULT '0',
576 `PhoneCredits` int(4) NOT NULL DEFAULT '0',
577 `House` int(11) NOT NULL DEFAULT '0',
578 `Bizz` int(11) NOT NULL DEFAULT '0',
579 `Radio` int(2) NOT NULL DEFAULT '0',
580 `Pos_x` float NOT NULL,
581 `Pos_y` float NOT NULL,
582 `Pos_z` float NOT NULL,
583 `Rob` int(11) NOT NULL DEFAULT '0',
584 `CarLicT` int(11) NOT NULL DEFAULT '0',
585 `CarLic` int(2) NOT NULL DEFAULT '0',
586 `FlyLicT` int(11) NOT NULL DEFAULT '0',
587 `FlyLic` int(2) NOT NULL DEFAULT '0',
588 `BoatLicT` int(11) NOT NULL DEFAULT '0',
589 `BoatLic` int(2) NOT NULL DEFAULT '0',
590 `FishLicT` int(11) NOT NULL DEFAULT '0',
591 `FishLic` int(2) NOT NULL DEFAULT '0',
592 `GunLicT` int(11) NOT NULL DEFAULT '0',
593 `GunLic` int(2) NOT NULL DEFAULT '0',
594 `PayDay` int(20) NOT NULL DEFAULT '0',
595 `PayDayHad` int(20) NOT NULL DEFAULT '0',
596 `Tutorial` int(2) NOT NULL DEFAULT '0',
597 `Warnings` int(2) NOT NULL DEFAULT '0',
598 `Rented` int(111) NOT NULL DEFAULT '0',
599 `Fuel` int(11) NOT NULL DEFAULT '0',
600 `Married` int(2) NOT NULL DEFAULT '0',
601 `MarriedTo` varchar(25) NOT NULL,
602 `WTalkie` int(2) NOT NULL DEFAULT '0',
603 `Lighter` int(2) NOT NULL DEFAULT '0',
604 `Cigarettes` int(2) NOT NULL DEFAULT '0',
605 `Tow` int(20) NOT NULL DEFAULT '0',
606 `Email` varchar(50) NOT NULL DEFAULT 'email@yahoo.com',
607 `RegisterDate` varchar(50) NOT NULL DEFAULT '01/01/1970 01:01:01',
608 `lastOn` varchar(50) NOT NULL DEFAULT '01/01/1970 01:01:01',
609 `Banned` int(3) NOT NULL DEFAULT '0',
610 `Accusedof` varchar(124) NOT NULL,
611 `Accusing` varchar(64) NOT NULL,
612 `Victim` varchar(64) NOT NULL,
613 `Bplayer` varchar(64) NOT NULL,
614 `ClanTag` varchar(64) NOT NULL,
615 `Clan` int(11) NOT NULL DEFAULT '0',
616 `Radio2` int(2) NOT NULL DEFAULT '0',
617 `Status` int(11) NOT NULL DEFAULT '0',
618 `HitT` int(20) NOT NULL DEFAULT '0',
619 `CRank` int(11) NOT NULL DEFAULT '0',
620 `Phone` int(11) NOT NULL DEFAULT '0',
621 `referral` int(20) NOT NULL DEFAULT '0',
622 `referralp` int(20) NOT NULL DEFAULT '0',
623 `Carkey` int(11) NOT NULL DEFAULT '0',
624 `motokey` int(11) NOT NULL DEFAULT '0',
625 `helikey` int(11) NOT NULL DEFAULT '0',
626 `prcarkey` int(11) NOT NULL DEFAULT '0',
627 `Laptop` int(11) NOT NULL DEFAULT '0'
628) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
629
630--
631-- Dumping data for table `users`
632--
633
634INSERT INTO `users` (`id`, `name`, `password`, `Level`, `Admin`, `Helper`, `Premium`, `ConnectedTime`, `Registered`, `Sex`, `Age`, `Origin`, `Muted`, `MuteTime`, `Respect`, `Money`, `Bank`, `Crimes`, `Kills`, `Deaths`, `Arrested`, `WantedDeaths`, `Phonebook`, `LottoNr`, `WantedLevel`, `Fishes`, `RFishes`, `Job`, `Paycheck`, `HeadValue`, `Jailed`, `JailTime`, `Materials`, `Drugs`, `Leader`, `Member`, `Rank`, `CChar`, `FWarn`, `FPunish`, `Acceptpoints`, `SexSkill`, `LawSkill`, `MechSkill`, `NewsSkill`, `DrugsSkill`, `FishSkill`, `MatSkill`, `RobSkill`, `pHealth`, `Inter`, `Local`, `Team`, `Model`, `PhoneNr`, `PhoneCredits`, `House`, `Bizz`, `Radio`, `Pos_x`, `Pos_y`, `Pos_z`, `Rob`, `CarLicT`, `CarLic`, `FlyLicT`, `FlyLic`, `BoatLicT`, `BoatLic`, `FishLicT`, `FishLic`, `GunLicT`, `GunLic`, `PayDay`, `PayDayHad`, `Tutorial`, `Warnings`, `Rented`, `Fuel`, `Married`, `MarriedTo`, `WTalkie`, `Lighter`, `Cigarettes`, `Tow`, `Email`, `RegisterDate`, `lastOn`, `Banned`, `Accusedof`, `Accusing`, `Victim`, `Bplayer`, `ClanTag`, `Clan`, `Radio2`, `Status`, `HitT`, `CRank`, `Phone`, `referral`, `referralp`, `Carkey`, `motokey`, `helikey`, `prcarkey`, `Laptop`) VALUES
635(4, 'Zen.', 'americandrim', 11, 6, 0, 1, 1, 1, 1, 13, 1, 0, 0, 3, 27016675, 9918, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14144, 0, 0, 0, 0, 0, 1, 1, 7, 281, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 2, 250, 9760, 0, 999, 255, 1, 0, 0, 0, 1, 99, 1, 0, 0, 0, 0, 0, 0, 100, 1, 6, 0, 1, 0, 0, 0, 0, '', 0, 0, 0, 0, 'zen.zew@gmail.com', '29/10/2016 14:1:47', '29 octombrie 2016, ora 15:55', 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 5, 4, 0, 0, 0);
636
637-- --------------------------------------------------------
638
639--
640-- Table structure for table `warnlog`
641--
642
643CREATE TABLE IF NOT EXISTS `warnlog` (
644`ID` int(11) NOT NULL,
645 `ip` varchar(25) NOT NULL,
646 `player` varchar(25) NOT NULL,
647 `admin` varchar(25) NOT NULL,
648 `reason` varchar(60) NOT NULL,
649 `time` varchar(60) NOT NULL
650) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
651
652--
653-- Indexes for dumped tables
654--
655
656--
657-- Indexes for table `banlog`
658--
659ALTER TABLE `banlog`
660 ADD PRIMARY KEY (`ID`);
661
662--
663-- Indexes for table `bizz`
664--
665ALTER TABLE `bizz`
666 ADD PRIMARY KEY (`ID`);
667
668--
669-- Indexes for table `cars`
670--
671ALTER TABLE `cars`
672 ADD PRIMARY KEY (`ID`);
673
674--
675-- Indexes for table `charity`
676--
677ALTER TABLE `charity`
678 ADD PRIMARY KEY (`ID`);
679
680--
681-- Indexes for table `factionlog`
682--
683ALTER TABLE `factionlog`
684 ADD PRIMARY KEY (`ID`);
685
686--
687-- Indexes for table `factions`
688--
689ALTER TABLE `factions`
690 ADD PRIMARY KEY (`ID`);
691
692--
693-- Indexes for table `houses`
694--
695ALTER TABLE `houses`
696 ADD PRIMARY KEY (`ID`);
697
698--
699-- Indexes for table `iplogs`
700--
701ALTER TABLE `iplogs`
702 ADD PRIMARY KEY (`ID`);
703
704--
705-- Indexes for table `jaillog`
706--
707ALTER TABLE `jaillog`
708 ADD PRIMARY KEY (`ID`);
709
710--
711-- Indexes for table `log_admin`
712--
713ALTER TABLE `log_admin`
714 ADD PRIMARY KEY (`id`);
715
716--
717-- Indexes for table `papers`
718--
719ALTER TABLE `papers`
720 ADD PRIMARY KEY (`ID`);
721
722--
723-- Indexes for table `sbizz`
724--
725ALTER TABLE `sbizz`
726 ADD PRIMARY KEY (`ID`);
727
728--
729-- Indexes for table `stock`
730--
731ALTER TABLE `stock`
732 ADD PRIMARY KEY (`ID`);
733
734--
735-- Indexes for table `stuff`
736--
737ALTER TABLE `stuff`
738 ADD PRIMARY KEY (`ID`);
739
740--
741-- Indexes for table `turfs`
742--
743ALTER TABLE `turfs`
744 ADD PRIMARY KEY (`ID`);
745
746--
747-- Indexes for table `users`
748--
749ALTER TABLE `users`
750 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_2` (`id`), ADD KEY `id` (`id`);
751
752--
753-- Indexes for table `warnlog`
754--
755ALTER TABLE `warnlog`
756 ADD PRIMARY KEY (`ID`);
757
758--
759-- AUTO_INCREMENT for dumped tables
760--
761
762--
763-- AUTO_INCREMENT for table `banlog`
764--
765ALTER TABLE `banlog`
766MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
767--
768-- AUTO_INCREMENT for table `bizz`
769--
770ALTER TABLE `bizz`
771MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
772--
773-- AUTO_INCREMENT for table `cars`
774--
775ALTER TABLE `cars`
776MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
777--
778-- AUTO_INCREMENT for table `charity`
779--
780ALTER TABLE `charity`
781MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
782--
783-- AUTO_INCREMENT for table `factionlog`
784--
785ALTER TABLE `factionlog`
786MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
787--
788-- AUTO_INCREMENT for table `factions`
789--
790ALTER TABLE `factions`
791MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
792--
793-- AUTO_INCREMENT for table `houses`
794--
795ALTER TABLE `houses`
796MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=58;
797--
798-- AUTO_INCREMENT for table `iplogs`
799--
800ALTER TABLE `iplogs`
801MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
802--
803-- AUTO_INCREMENT for table `jaillog`
804--
805ALTER TABLE `jaillog`
806MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
807--
808-- AUTO_INCREMENT for table `log_admin`
809--
810ALTER TABLE `log_admin`
811MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=42;
812--
813-- AUTO_INCREMENT for table `papers`
814--
815ALTER TABLE `papers`
816MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
817--
818-- AUTO_INCREMENT for table `sbizz`
819--
820ALTER TABLE `sbizz`
821MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=24;
822--
823-- AUTO_INCREMENT for table `stock`
824--
825ALTER TABLE `stock`
826MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=46;
827--
828-- AUTO_INCREMENT for table `stuff`
829--
830ALTER TABLE `stuff`
831MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
832--
833-- AUTO_INCREMENT for table `turfs`
834--
835ALTER TABLE `turfs`
836MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
837--
838-- AUTO_INCREMENT for table `users`
839--
840ALTER TABLE `users`
841MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
842--
843-- AUTO_INCREMENT for table `warnlog`
844--
845ALTER TABLE `warnlog`
846MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
847/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
848/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
849/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;