pVDfy1vG

1DROP TABLE IF EXISTS `banidos`;
2CREATE TABLE IF NOT EXISTS `banidos` (
3  `Nome` varchar(50) DEFAULT NULL,
4  `IP` varchar(50) DEFAULT NULL,
5  `Motivo` varchar(50) DEFAULT NULL,
6  `Admin` varchar(50) DEFAULT NULL,
7  `Data` varchar(50) DEFAULT NULL,
8  `Temporario` int(11) DEFAULT NULL,
9  `Dia` int(11) DEFAULT NULL,
10  `Mes` int(11) DEFAULT NULL,
11  `Ano` int(11) DEFAULT NULL
12) ENGINE=InnoDB DEFAULT CHARSET=latin1;
13
14DROP TABLE IF EXISTS `carros`;
15CREATE TABLE IF NOT EXISTS `carros` (
16  `ID` int(128) NOT NULL AUTO_INCREMENT,
17  `SID` int(128) DEFAULT NULL,
18  `Modelo` int(101) DEFAULT NULL,
19  `Nome` varchar(128) DEFAULT NULL,
20  `Dono` varchar(30) DEFAULT NULL,
21  `Preco` int(128) DEFAULT NULL,
22  `Trancado` int(10) DEFAULT NULL,
23  `Bloqueado` int(128) DEFAULT NULL,
24  `Slot` int(15) DEFAULT NULL,
25  `X` varchar(128) DEFAULT NULL,
26  `Y` varchar(128) DEFAULT NULL,
27  `Z` varchar(128) DEFAULT NULL,
28  `Angulo` varchar(128) DEFAULT NULL,
29  `RX` varchar(128) DEFAULT NULL,
30  `RY` varchar(128) DEFAULT NULL,
31  `RZ` varchar(128) DEFAULT NULL,
32  `RAngulo` varchar(128) DEFAULT NULL,
33  `Cor1` int(100) DEFAULT NULL,
34  `Cor2` int(100) DEFAULT NULL,
35  `Spoiler` int(100) DEFAULT NULL,
36  `Nitro` int(100) DEFAULT NULL,
37  `FBumper` int(100) DEFAULT NULL,
38  `Exhaust` int(100) DEFAULT NULL,
39  `BVentr` int(100) DEFAULT NULL,
40  `BVent` int(100) DEFAULT NULL,
41  `BScoop` int(100) DEFAULT NULL,
42  `RScoop` int(100) DEFAULT NULL,
43  `LSkirt` int(100) DEFAULT NULL,
44  `RSkirt` int(100) DEFAULT NULL,
45  `Hydraulics` int(100) DEFAULT NULL,
46  `Base` int(100) DEFAULT NULL,
47  `RBBars` int(100) DEFAULT NULL,
48  `FBBars` int(100) DEFAULT NULL,
49  `Whells` int(100) DEFAULT NULL,
50  `Lights` int(100) DEFAULT NULL,
51  `Painjob` int(100) DEFAULT NULL,
52  PRIMARY KEY (`ID`)
53) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
54
55DROP TABLE IF EXISTS `casas`;
56CREATE TABLE IF NOT EXISTS `casas` (
57  `ID` int(128) NOT NULL AUTO_INCREMENT,
58  `Dono` varchar(50) DEFAULT NULL,
59  `Preco` int(101) DEFAULT NULL,
60  `Criador` varchar(20) DEFAULT NULL,
61  `Data` varchar(20) DEFAULT NULL,
62  `Servidor` int(10) DEFAULT NULL,
63  `Trancada` int(10) DEFAULT NULL,
64  `Interior` int(10) DEFAULT NULL,
65  `eInterior` int(10) DEFAULT NULL,
66  `Mundo` int(10) DEFAULT NULL,
67  `X` varchar(128) DEFAULT NULL,
68  `Y` varchar(128) DEFAULT NULL,
69  `Z` varchar(128) DEFAULT NULL,
70  PRIMARY KEY (`ID`)
71) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
72
73DROP TABLE IF EXISTS `contas`;
74CREATE TABLE IF NOT EXISTS `contas` (
75  `Nome` varchar(50) DEFAULT NULL,
76  `Senha` varchar(250) DEFAULT NULL,
77  `IP` varchar(50) DEFAULT NULL,
78  `Pais` varchar(50) DEFAULT NULL,
79  `Cidade` varchar(50) DEFAULT NULL,
80  `Data` varchar(11) NOT NULL,
81  `Level` int(10) DEFAULT '0',
82  `Vip` int(10) DEFAULT '0',
83  `Sexo` int(10) NOT NULL,
84  `Horas` int(11) NOT NULL,
85  `Minutos` int(11) NOT NULL,
86  `CorCmd` int(11) NOT NULL,
87  `CtDia` int(10) NOT NULL,
88  `CtMes` int(10) NOT NULL,
89  `CtAno` int(10) NOT NULL
90) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91
92DROP TABLE IF EXISTS `dmcontas`;
93CREATE TABLE IF NOT EXISTS `dmcontas` (
94  `Nome` varchar(50) DEFAULT NULL,
95  `IP` varchar(50) DEFAULT NULL,
96  `Casa` int(11) NOT NULL,
97  `Skin` int(11) NOT NULL,
98  `Dinheiro` int(11) NOT NULL,
99  `Score` int(11) NOT NULL,
100  `Matou` int(11) NOT NULL,
101  `Morreu` int(11) NOT NULL,
102  `Boost` int(11) NOT NULL DEFAULT '0',
103  `C1` int(11) NOT NULL DEFAULT '0',
104  `C2` int(11) NOT NULL DEFAULT '0',
105  `C3` int(11) NOT NULL DEFAULT '0',
106  `C4` int(11) NOT NULL,
107  `C5` int(11) NOT NULL,
108  `C6` int(11) NOT NULL,
109  `C7` int(11) NOT NULL,
110  `C8` int(11) NOT NULL,
111  `Biz` int(11) NOT NULL,
112  `Banco` int(11) NOT NULL
113) ENGINE=InnoDB DEFAULT CHARSET=latin1;
114
115DROP TABLE IF EXISTS `empresas`;
116CREATE TABLE IF NOT EXISTS `empresas` (
117  `ID` int(128) NOT NULL AUTO_INCREMENT,
118  `Dono` varchar(50) DEFAULT NULL,
119  `Nome` varchar(50) DEFAULT NULL,
120  `Preco` int(101) DEFAULT NULL,
121  `Ganho` int(10) DEFAULT NULL,
122  `Criador` varchar(20) DEFAULT NULL,
123  `Data` varchar(20) DEFAULT NULL,
124  `X` varchar(128) DEFAULT NULL,
125  `Y` varchar(128) DEFAULT NULL,
126  `Z` varchar(128) DEFAULT NULL,
127  `Interior` int(10) DEFAULT NULL,
128  PRIMARY KEY (`ID`)
129) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=latin1;
130
131DROP TABLE IF EXISTS `kicklog`;
132CREATE TABLE IF NOT EXISTS `kicklog` (
133  `Nome` varchar(50) DEFAULT NULL,
134  `Motivo` varchar(50) DEFAULT NULL,
135  `Data` varchar(50) DEFAULT NULL
136) ENGINE=InnoDB DEFAULT CHARSET=latin1;
137
138DROP TABLE IF EXISTS `log`;
139CREATE TABLE IF NOT EXISTS `log` (
140  `Nome` varchar(50) DEFAULT NULL,
141  `ID` int(10) DEFAULT NULL,
142  `Data` varchar(50) DEFAULT NULL,
143  `Acao` varchar(50) DEFAULT NULL,
144  `Jogador1` varchar(50) DEFAULT NULL,
145  `Jogador2` varchar(50) DEFAULT NULL
146) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147
148DROP TABLE IF EXISTS `mapa`;
149CREATE TABLE IF NOT EXISTS `mapa` (
150  `Nome` varchar(70) DEFAULT NULL,
151  `Criador` varchar(70) DEFAULT NULL,
152  `Modo` varchar(50) NOT NULL,
153  `HX` varchar(100) DEFAULT NULL,
154  `HY` varchar(100) DEFAULT NULL,
155  `HZ` varchar(100) DEFAULT NULL,
156  `HInterior` int(10) DEFAULT NULL,
157  `ZX` varchar(100) DEFAULT NULL,
158  `ZY` varchar(100) DEFAULT NULL,
159  `ZZ` varchar(100) DEFAULT NULL,
160  `ZInterior` int(10) DEFAULT NULL,
161  `EX` varchar(100) NOT NULL,
162  `EY` varchar(100) NOT NULL,
163  `EZ` varchar(100) NOT NULL,
164  `EInterior` int(100) NOT NULL,
165  `AX` varchar(100) NOT NULL,
166  `AY` int(100) NOT NULL,
167  `AZ` varchar(100) NOT NULL,
168  `Objeto` int(11) NOT NULL,
169  `OX` varchar(100) NOT NULL,
170  `OY` varchar(100) NOT NULL,
171  `OZ` varchar(100) NOT NULL,
172  `ORX` varchar(100) NOT NULL,
173  `ORY` varchar(100) NOT NULL,
174  `ORZ` varchar(100) NOT NULL,
175  `OAX` varchar(100) NOT NULL,
176  `OAY` varchar(100) NOT NULL,
177  `OAZ` varchar(100) NOT NULL,
178  `OARX` varchar(100) NOT NULL,
179  `OARY` varchar(100) NOT NULL,
180  `OARZ` varchar(100) NOT NULL,
181  UNIQUE KEY `Nome` (`Nome`,`Criador`,`HX`,`HY`)
182) ENGINE=InnoDB DEFAULT CHARSET=latin1;
183
184ALTER TABLE `mapa` CHANGE `EX` `EX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0', CHANGE `EY` `EY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `EZ` `EZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0', CHANGE `EInterior` `EInterior` INT(100) NOT NULL DEFAULT '0', CHANGE `AX` `AX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `AY` `AY` INT(100) NOT NULL DEFAULT '0', CHANGE `AZ` `AZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `Objeto` `Objeto` INT(11) NOT NULL DEFAULT '0', CHANGE `OX` `OX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OY` `OY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OZ` `OZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `ORX` `ORX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `ORY` `ORY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `ORZ` `ORZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OAX` `OAX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OAY` `OAY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OAZ` `OAZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OARX` `OARX` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OARY` `OARY` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0', CHANGE `OARZ` `OARZ` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0';
185
186DROP TABLE IF EXISTS `pmblock`;
187CREATE TABLE IF NOT EXISTS `pmblock` (
188  `Nome` varchar(50) DEFAULT NULL,
189  `Block` varchar(50) DEFAULT NULL,
190  `Data` varchar(10) DEFAULT NULL
191) ENGINE=InnoDB DEFAULT CHARSET=latin1;
192
193DROP TABLE IF EXISTS `portao`;
194CREATE TABLE IF NOT EXISTS `portao` (
195  `ID` int(128) NOT NULL AUTO_INCREMENT,
196  `Senha` varchar(50) DEFAULT NULL,
197  `Criador` varchar(50) DEFAULT NULL,
198  `Data` varchar(50) DEFAULT NULL,
199  `Modelo` int(11) DEFAULT NULL,
200  `Explodir` int(10) DEFAULT NULL,
201  `X` varchar(50) DEFAULT NULL,
202  `Y` varchar(50) DEFAULT NULL,
203  `Z` varchar(50) DEFAULT NULL,
204  `RX` varchar(50) DEFAULT NULL,
205  `RY` varchar(50) DEFAULT NULL,
206  `RZ` varchar(50) DEFAULT NULL,
207  `AX` varchar(50) DEFAULT NULL,
208  `AY` varchar(50) DEFAULT NULL,
209  `AZ` varchar(50) DEFAULT NULL,
210  `ARX` varchar(50) DEFAULT NULL,
211  `ARY` varchar(50) DEFAULT NULL,
212  `ARZ` varchar(50) DEFAULT NULL,
213  PRIMARY KEY (`ID`)
214) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
215
216DROP TABLE IF EXISTS `zscontas`;
217CREATE TABLE IF NOT EXISTS `zscontas` (
218  `Nome` varchar(50) DEFAULT NULL,
219  `Coins` int(10) DEFAULT '0',
220  `Cookies` int(10) DEFAULT '0',
221  `XP` int(10) DEFAULT '0',
222  `Partidas` int(10) DEFAULT '0',
223  `Matou` int(10) DEFAULT '0',
224  `Morreu` int(10) DEFAULT '0',
225  `Score` int(11) DEFAULT '0',
226  `pEvac` int(11) NOT NULL DEFAULT '0',
227  `pEvac2` int(11) NOT NULL DEFAULT '0'
228) ENGINE=InnoDB DEFAULT CHARSET=latin1;
229
230DROP TABLE IF EXISTS `labels`;
231CREATE TABLE IF NOT EXISTS `labels` (
232  `ID` int(100) NOT NULL AUTO_INCREMENT,
233  `Texto` varchar(100) DEFAULT NULL,
234  `Cor` int(50) DEFAULT '0',
235  `Interior` int(10) DEFAULT '0',
236  `Distancia` varchar(100) DEFAULT '0',
237  `X` varchar(100) DEFAULT '0',
238  `Y` varchar(100) DEFAULT '0',
239  `Z` varchar(100) DEFAULT '0',
240  PRIMARY KEY (`ID`)
241) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
242
243DROP TABLE IF EXISTS `gangs`;
244CREATE TABLE IF NOT EXISTS  `gangs` (
245 `ID` int(10) NOT NULL AUTO_INCREMENT,
246 `Tag` varchar(10) DEFAULT NULL,
247 `Nome` varchar(30) DEFAULT NULL,
248 `Dono` varchar(30) DEFAULT NULL,
249 `Criador` varchar(30) DEFAULT NULL,
250 `Max` int(26) DEFAULT '5',
251 `Cor` int(15) NOT NULL DEFAULT '-16776961',
252 `Cor1` int(10) NOT NULL DEFAULT '18',
253 `X` varchar(30) DEFAULT '0',
254 `Y` varchar(30) DEFAULT '0',
255 `Z` varchar(30) DEFAULT '0',
256 `Interior` int(10) DEFAULT '0',
257 `C1` varchar(30) DEFAULT 'Not Set',
258 `C2` varchar(30) DEFAULT 'Not Set',
259 `C3` varchar(30) DEFAULT 'Not Set',
260 `A1` int(10) DEFAULT '0',
261 `A2` int(10) DEFAULT '0',
262 `A3` int(10) DEFAULT '0',
263 `A4` int(10) DEFAULT '0',
264 `A5` int(10) DEFAULT '0',
265 `S1` int(10) DEFAULT '0',
266 `S2` int(10) DEFAULT '0',
267 `S3` int(10) DEFAULT '0',
268 `S4` int(10) DEFAULT '0',
269 `S5` int(10) DEFAULT '0',
270 `S6` int(10) DEFAULT '0',
271 `S7` int(10) DEFAULT '0',
272 `S8` int(10) DEFAULT '0',
273 `S9` int(10) DEFAULT '0',
274 `S10` int(10) DEFAULT '0',
275 `S11` int(10) DEFAULT '0',
276 `S12` int(10) DEFAULT '0',
277 `S13` int(10) DEFAULT '0',
278 `S14` int(10) DEFAULT '0',
279 `S15` int(10) DEFAULT '0',
280 `S16` int(10) DEFAULT '0',
281 `S17` int(10) DEFAULT '0',
282 `S18` int(10) DEFAULT '0',
283 `S19` int(10) DEFAULT '0',
284 `S20` int(10) DEFAULT '0',
285 `S21` int(10) DEFAULT '0',
286 `S22` int(10) DEFAULT '0',
287 `S23` int(10) DEFAULT '0',
288 `S24` int(10) DEFAULT '0',
289 `S25` int(10) DEFAULT '0',
290 `N1` varchar(50) DEFAULT 'Rank 1',
291 `N2` varchar(50) DEFAULT 'Rank 2',
292 `N3` varchar(50) DEFAULT 'Rank 3',
293 `N4` varchar(50) DEFAULT 'Rank 4',
294 `N5` varchar(50) DEFAULT 'Rank 5',
295 `N6` varchar(50) DEFAULT 'Rank 6',
296 `N7` varchar(50) DEFAULT 'Rank 7',
297 `N8` varchar(50) DEFAULT 'Rank 8',
298 `N9` varchar(50) DEFAULT 'Rank 9',
299 `N10` varchar(50) DEFAULT 'Rank 10',
300 `N11` varchar(50) DEFAULT 'Rank 11',
301 `N12` varchar(50) DEFAULT 'Rank 12',
302 `N13` varchar(50) DEFAULT 'Rank 13',
303 `N14` varchar(50) DEFAULT 'Rank 14',
304 `N15` varchar(50) DEFAULT 'Rank 15',
305 `N16` varchar(50) DEFAULT 'Rank 16',
306 `N17` varchar(50) DEFAULT 'Rank 17',
307 `N18` varchar(50) DEFAULT 'Rank 18',
308 `N19` varchar(50) DEFAULT 'Rank 19',
309 `N20` varchar(50) DEFAULT 'Rank 20',
310 `N21` varchar(50) DEFAULT 'Rank 21',
311 `N22` varchar(50) DEFAULT 'Rank 22',
312 `N23` varchar(50) DEFAULT 'Rank 23',
313 `N24` varchar(50) DEFAULT 'Rank 24',
314 `N25` varchar(50) DEFAULT 'Rank 25',
315 PRIMARY KEY (`ID`)
316) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
317
318DROP TABLE IF EXISTS `membros`;
319CREATE TABLE IF NOT EXISTS  `membros` (
320 `Nome` varchar(30) DEFAULT NULL,
321 `Tag` varchar(30) DEFAULT NULL,
322 `Nivel` int(10) DEFAULT NULL
323) ENGINE=InnoDB DEFAULT CHARSET=latin1;
324
325CREATE TABLE IF NOT EXISTS `config` (
326 `Nome` Varchar(50),
327 `Valor` int(30)
328);
329
330CREATE TABLE IF NOT EXISTS `clan` (`Nome` VARCHAR(30) NOT NULL ,`bG` INT(10) NOT NULL DEFAULT '0');
331
332INSERT INTO `mapa` (`Nome`, `Criador`, `Modo`, `HX`, `HY`, `HZ`, `HInterior`, `ZX`, `ZY`, `ZZ`, `ZInterior`, `EX`, `EY`, `EZ`, `EInterior`, `AX`, `AY`, `AZ`, `Objeto`, `OX`, `OY`, `OZ`, `ORX`, `ORY`, `ORZ`, `OAX`, `OAY`, `OAZ`, `OARX`, `OARY`, `OARZ`) VALUES
333('Mb', 'Unknown', 'DM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,'0','0','0', 0,'0',0,'0', 0,'0','0','0','0','0','0','0','0','0','0','0','0'),
334('Vinewood', 'RUFAT', 'ZS', '219.783523', '-1290.421020', '60.149578', 0, '179.565658', '-1224.333129', '78.375000', 0, '374.239685', '-1154.993041', '78.194122', 0, '242.568634', -1254, '69.701606', 0,'0','0','0','0','0','0','0','0','0','0','0','0'),
335('Area51', 'LeoOliver', 'ZS', '298.058929', '1815.808471', '4.710937', 0, '297.674530', '1816.002441', '4.710937', 0, '-1751.831787', '889.133728', '347.371887', 0, '267.597381', 1817, '4.703125', 980, '96.741149', '1920.777343', '18.606916', '0.000000', '0.000000', '89.038185', '96.741149', '1920.777343', '13.756915', '0.000000', '0.000000', '89.038185'),
336('DeathMatch', 'Misho1', 'ZS', '-1696.932373', '916.134094', '342.128448', 0, '-1792.224853', '775.130432', '349.774505', 0, '-1752.124145', '889.598937', '347.347381', 0, '-1718.573486', 916, '342.128448', 0,'0','0','0','0','0','0','0','0','0','0','0','0'),
337('Rave', 'Youarex', 'ZS', '-96.146308', '63.567100', '78.779457', 0, '-27.045963', '1.655962', '67.845565', 0, '-6.309685', '114.880996', '64.120201', 0, '-78.035118', 79, '76.918289', 980, '-6.642311', '108.483329', '64.163894', '0.000000', '0.000000', '-0.064648', '-6.642311', '108.483329', '59.953899', '0.000000', '0.000000', '-0.064648'),
338('Military Fuels', 'Ceedie', 'ZS', '2569.871582', '2809.995605', '10.820312', 0, '2547.154785', '2714.727294', '10.820312', 0, '2514.305175', '2730.200683', '10.901562', 0, '2567.143798', 2828, '10.820312', 0,'0','0','0','0','0','0','0','0','0','0','0','0'),
339('Santa Maria', 'Ceedie', 'ZS', '439.405029', '-2007.722778', '12.507698', 0, '484.115173', '-2058.964599', '12.497947', 0, '492.163146', '-1995.207763', '12.582352', 0, '467.974395', -2015, '12.507698', 2933, '492.020324', '-1998.134521', '9.745809', '0.000000', '-90.399940', '0.208469', '492.038940', '-1998.134521', '7.075873', '0.000000', '-90.399940', '0.208469'),
340('SF Radio Station', 'Ceedie', 'ZS', '-2534.591064', '-618.027893', '132.562500', 0, '-2418.011230', '-666.548583', '133.132812', 0, '-2476.272949', '-483.466766', '100.134017', 0, '-2498.623291', -623, '132.659576', 980, '-2439.643798', '-583.430664', '132.264282', '0.000000', '0.000000', '24.825296', '-2439.643798', '-583.430664', '126.684257', '0.000000', '0.000000', '24.825296'),
341('Unity Station','hossa','ZS','1800.333618','-2012.873535','13.521794','0','1755.675292','-1917.188598','13.570697','0','1698.255493','-1960.723999','19.218750','0','1801.299926','-1990','13.525097','0','0','0','0','0','0','0','0','0','0','0','0','0');