· 9 years ago · Nov 07, 2016, 02:48 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Feb 10, 2016 at 09:19 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
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: `smrp`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `adminchat`
27--
28
29CREATE TABLE IF NOT EXISTS `adminchat` (
30 `ID` int(11) NOT NULL AUTO_INCREMENT,
31 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
32 `Message` varchar(128) NOT NULL DEFAULT 'Nothing',
33 `TimeDate` varchar(54) NOT NULL DEFAULT 'N/A',
34 `IP` varchar(31) NOT NULL DEFAULT 'N/A',
35 PRIMARY KEY (`ID`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `admindb`
42--
43
44CREATE TABLE IF NOT EXISTS `admindb` (
45 `ID` int(11) NOT NULL AUTO_INCREMENT,
46 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
47 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
48 `Reason` varchar(128) NOT NULL DEFAULT 'Nothing',
49 `Header` varchar(24) NOT NULL DEFAULT '[SUSPENDED]',
50 `By` varchar(24) NOT NULL DEFAULT 'NoBodY',
51 PRIMARY KEY (`ID`)
52) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `adminlogs`
58--
59
60CREATE TABLE IF NOT EXISTS `adminlogs` (
61 `ID` int(11) NOT NULL AUTO_INCREMENT,
62 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
63 `IP` varchar(31) NOT NULL DEFAULT 'N/A',
64 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
65 `Reason` varchar(128) NOT NULL DEFAULT 'Nothing',
66 PRIMARY KEY (`ID`)
67) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `advertisements`
73--
74
75CREATE TABLE IF NOT EXISTS `Advertisements` (
76 `ID` int(11) NOT NULL AUTO_INCREMENT,
77 `PlayerName` varchar(24) NOT NULL,
78 `Message` varchar(128) DEFAULT NULL,
79 `DateTime` varchar(35) DEFAULT NULL,
80 `Active` tinyint(1) NOT NULL DEFAULT '1',
81 `Price` mediumint(6) NOT NULL DEFAULT '1500',
82 `PhoneNumber` mediumint(6) NOT NULL DEFAULT '666666',
83 `Type` tinyint(1) NOT NULL DEFAULT '0',
84 PRIMARY KEY (`ID`)
85) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
86
87-- --------------------------------------------------------
88
89--
90-- Table structure for table `atminfo`
91--
92
93CREATE TABLE IF NOT EXISTS `ATMInfo` (
94 `ID` smallint(3) NOT NULL DEFAULT '-1',
95 `X` float NOT NULL DEFAULT '1681.97',
96 `Y` float NOT NULL DEFAULT '-1245.81',
97 `Z` float NOT NULL DEFAULT '129.365',
98 `rotX` float NOT NULL DEFAULT '0',
99 `rotY` float NOT NULL DEFAULT '0',
100 `rotZ` float NOT NULL DEFAULT '0',
101 `Interior` int(9) NOT NULL DEFAULT '0',
102 `VirtualWorld` int(9) NOT NULL DEFAULT '0'
103) ENGINE=InnoDB DEFAULT CHARSET=latin1;
104
105-- --------------------------------------------------------
106
107--
108-- Table structure for table `businessinfo`
109--
110
111CREATE TABLE IF NOT EXISTS `BusinessInfo` (
112 `ID` smallint(3) NOT NULL DEFAULT '-1',
113 `Owner` varchar(24) NOT NULL DEFAULT 'NULL',
114 `Dupekey` varchar(24) DEFAULT 'NoBodY',
115 `Name` varchar(45) DEFAULT NULL,
116 `X` float NOT NULL DEFAULT '1681.97',
117 `Y` float NOT NULL DEFAULT '-1245.81',
118 `Z` float NOT NULL DEFAULT '129.365',
119 `Interior` int(9) NOT NULL DEFAULT '0',
120 `VirtualWorld` int(11) NOT NULL DEFAULT '0',
121 `InteriorPack` tinyint(2) NOT NULL DEFAULT '0',
122 `Type` tinyint(2) NOT NULL DEFAULT '-1',
123 `CompsFlag` mediumint(3) NOT NULL DEFAULT '255',
124 `Tax` tinyint(2) NOT NULL DEFAULT '9',
125 `LastRob` tinyint(2) NOT NULL DEFAULT '0',
126 `Level` tinyint(2) NOT NULL DEFAULT '99',
127 `Sellprice` int(9) NOT NULL DEFAULT '0',
128 `Restock` tinyint(1) NOT NULL DEFAULT '0',
129 `RentPrice` smallint(4) NOT NULL DEFAULT '7500',
130 `Till` int(9) NOT NULL DEFAULT '1500',
131 `Locked` tinyint(1) NOT NULL DEFAULT '0',
132 `Comps` smallint(5) NOT NULL DEFAULT '100',
133 `Fee` smallint(5) NOT NULL DEFAULT '10000',
134 `Deagle` smallint(5) NOT NULL DEFAULT '1500',
135 `MP5` smallint(5) NOT NULL DEFAULT '2200',
136 `M4` smallint(5) NOT NULL DEFAULT '3000',
137 `AK47` smallint(5) NOT NULL DEFAULT '3000',
138 `Shotgun` smallint(5) NOT NULL DEFAULT '2000',
139 `Silenced` smallint(5) NOT NULL DEFAULT '1200',
140 `Rifle` smallint(5) NOT NULL DEFAULT '1200',
141 `Sniper` smallint(5) NOT NULL DEFAULT '10000',
142 `Armour` smallint(5) NOT NULL DEFAULT '2000',
143 `AskComps` smallint(5) NOT NULL DEFAULT '0',
144 `Buyable` tinyint(1) NOT NULL DEFAULT '0',
145 UNIQUE KEY `ID` (`ID`)
146) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147
148-- --------------------------------------------------------
149
150--
151-- Table structure for table `bussinessedit`
152--
153
154CREATE TABLE IF NOT EXISTS `bussinessedit` (
155 `ID` int(11) NOT NULL AUTO_INCREMENT,
156 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
157 `IP` varchar(31) NOT NULL DEFAULT 'N/A',
158 `Reason` varchar(128) NOT NULL DEFAULT 'Nothing',
159 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
160 PRIMARY KEY (`ID`)
161) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
162
163-- --------------------------------------------------------
164
165--
166-- Table structure for table `confirmedrconadmins`
167--
168
169CREATE TABLE IF NOT EXISTS `confirmedrconadmins` (
170 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
171 `IP` varchar(31) NOT NULL DEFAULT 'N/A',
172 `Active` varchar(1) NOT NULL DEFAULT '1'
173) ENGINE=InnoDB DEFAULT CHARSET=latin1;
174
175-- --------------------------------------------------------
176
177--
178-- Table structure for table `deaths`
179--
180
181CREATE TABLE IF NOT EXISTS `deaths` (
182 `ID` int(11) NOT NULL AUTO_INCREMENT,
183 `PlayerName` varchar(24) NOT NULL,
184 `KillerName` varchar(24) NOT NULL,
185 `Reason` tinyint(2) NOT NULL DEFAULT '0',
186 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
187 PRIMARY KEY (`ID`)
188) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
189
190-- --------------------------------------------------------
191
192--
193-- Table structure for table `factionchat`
194--
195
196CREATE TABLE IF NOT EXISTS `factionchat` (
197 `ID` int(11) NOT NULL AUTO_INCREMENT,
198 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
199 `Message` varchar(128) NOT NULL DEFAULT 'Nothing',
200 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
201 `IP` varchar(31) NOT NULL DEFAULT 'N/A',
202 PRIMARY KEY (`ID`)
203) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
204
205-- --------------------------------------------------------
206
207--
208-- Table structure for table `factioninfo`
209--
210
211CREATE TABLE IF NOT EXISTS `FactionInfo` (
212 `ID` tinyint(2) NOT NULL DEFAULT '-1',
213 `FactionName` varchar(40) NOT NULL DEFAULT 'None',
214 `Type` tinyint(2) NOT NULL DEFAULT '-1',
215 `Colour` int(10) NOT NULL DEFAULT '-1',
216 `GangZoneColour` int(10) NOT NULL DEFAULT '-1',
217 `Points` int(10) NOT NULL DEFAULT '0',
218 `TogChat` tinyint(1) NOT NULL DEFAULT '0',
219 `TogColour` tinyint(1) NOT NULL DEFAULT '1',
220 `MaxVehicles` smallint(4) NOT NULL DEFAULT '25',
221 `MaxMembers` smallint(4) NOT NULL DEFAULT '25',
222 `Startpayment` mediumint(6) NOT NULL DEFAULT '1000',
223 `Startrank` varchar(25) NOT NULL DEFAULT 'None',
224 `Leader` varchar(24) NOT NULL DEFAULT 'NoBodY',
225 `MOTD` varchar(75) NOT NULL DEFAULT 'Welcome Back!',
226 `Bank` int(10) NOT NULL DEFAULT '0',
227 `SDCWarehouse` int(10) NOT NULL DEFAULT '1000',
228 `SDCCompsprice` mediumint(6) NOT NULL DEFAULT '1000',
229 `StockLevel` int(10) NOT NULL DEFAULT '150',
230 `Freq` int(7) NOT NULL DEFAULT '666',
231 `News1` varchar(128) NOT NULL DEFAULT 'Nothing new',
232 `News2` varchar(128) NOT NULL DEFAULT 'Nothing new',
233 `News3` varchar(128) NOT NULL DEFAULT 'Nothing new',
234 `News4` varchar(128) NOT NULL DEFAULT 'Nothing new',
235 `News5` varchar(128) NOT NULL DEFAULT 'Nothing new',
236 `News6` varchar(128) NOT NULL DEFAULT 'Nothing new',
237 `News7` varchar(128) NOT NULL DEFAULT 'Nothing new',
238 `News8` varchar(128) NOT NULL DEFAULT 'Nothing new'
239) ENGINE=InnoDB DEFAULT CHARSET=latin1;
240
241-- --------------------------------------------------------
242
243--
244-- Table structure for table `factionlogs`
245--
246
247CREATE TABLE IF NOT EXISTS `factionlogs` (
248 `ID` int(11) NOT NULL AUTO_INCREMENT,
249 `FactionID` smallint(2) NOT NULL DEFAULT '-1',
250 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
251 `Reason` varchar(128) NOT NULL DEFAULT 'Nothing',
252 `LogLevel` tinyint(1) NOT NULL DEFAULT '2',
253 PRIMARY KEY (`ID`)
254) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
255
256-- --------------------------------------------------------
257
258--
259-- Table structure for table `furnitureinfo`
260--
261
262CREATE TABLE IF NOT EXISTS `FurnitureInfo` (
263 `ID` int(11) NOT NULL AUTO_INCREMENT,
264 `House` smallint(3) NOT NULL DEFAULT '-1',
265 `Slot` tinyint(2) NOT NULL DEFAULT '-1',
266 `Name` varchar(85) NOT NULL DEFAULT 'Please rename!',
267 `Model` int(11) NOT NULL DEFAULT '19355',
268 `X` float NOT NULL DEFAULT '0',
269 `Y` float NOT NULL DEFAULT '0',
270 `Z` float NOT NULL DEFAULT '0',
271 `rX` float NOT NULL DEFAULT '0',
272 `rY` float NOT NULL DEFAULT '0',
273 `rZ` float NOT NULL DEFAULT '0',
274 `MaterialSlot1` smallint(3) NOT NULL DEFAULT '-1',
275 `MaterialSlot2` smallint(3) NOT NULL DEFAULT '-1',
276 `MaterialSlot3` smallint(3) NOT NULL DEFAULT '-1',
277 `MaterialSlot4` smallint(3) NOT NULL DEFAULT '-1',
278 `MaterialSlot5` smallint(3) NOT NULL DEFAULT '-1',
279 `ColourMaterial1` smallint(5) NOT NULL DEFAULT '-1',
280 `ColourMaterial2` smallint(5) NOT NULL DEFAULT '-1',
281 `ColourMaterial3` smallint(5) NOT NULL DEFAULT '-1',
282 `ColourMaterial4` smallint(5) NOT NULL DEFAULT '-1',
283 `ColourMaterial5` smallint(5) NOT NULL DEFAULT '-1',
284 PRIMARY KEY (`ID`)
285) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
286
287-- --------------------------------------------------------
288
289--
290-- Table structure for table `furniturelogs`
291--
292
293CREATE TABLE IF NOT EXISTS `furniturelogs` (
294 `ID` bigint(15) NOT NULL AUTO_INCREMENT,
295 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
296 `HouseID` smallint(4) NOT NULL DEFAULT '-1',
297 `SlotID` smallint(3) NOT NULL DEFAULT '-1',
298 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
299 `Reason` varchar(128) NOT NULL DEFAULT 'Nothing',
300 PRIMARY KEY (`ID`)
301) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
302
303-- --------------------------------------------------------
304
305--
306-- Table structure for table `gangzones`
307--
308
309CREATE TABLE IF NOT EXISTS `GangZones` (
310 `ID` smallint(3) NOT NULL DEFAULT '-1',
311 `Faction` int(3) NOT NULL DEFAULT '255',
312 `Colour` int(11) NOT NULL DEFAULT '-808595559',
313 `minX` float NOT NULL DEFAULT '0',
314 `minY` float NOT NULL DEFAULT '0',
315 `maxX` float NOT NULL DEFAULT '0',
316 `maxY` float NOT NULL DEFAULT '0'
317) ENGINE=InnoDB DEFAULT CHARSET=latin1;
318
319--
320-- Dumping data for table `WHInfos`
321--
322
323INSERT INTO `GangZones` (`ID`, `Faction`, `Colour`, `minX`, `minY`, `maxX`, `maxY`) VALUES
324(0, -1, -808595559, 2500, -2350, 2850, -2000),
325(1, -1, -808595559, 2148, -2350, 2498, -2000),
326(2, -1, -808595559, 1796, -2350, 2146, -2000),
327(3, -1, -808595559, 1444, -2350, 1794, -2000),
328(4, -1, -808595559, 1092, -2350, 1442, -2000),
329(5, -1, -808595559, 2500, -1998, 2850, -1648),
330(6, -1, -808595559, 2500, -1646, 2850, -1296),
331(7, -1, -808595559, 2500, -1294, 2850, -1044),
332(8, -1, -808595559, 2500, -1042, 2850, -692),
333(9, -1, -808595559, 2500, -690, 2850, -340),
334(10, -1, -808595559, 2148, -1998, 2498, -1648),
335(11, -1, -808595559, 2148, -1646, 2498, -1296),
336(12, -1, -808595559, 2148, -1294, 2498, -1044),
337(13, -1, -808595559, 2148, -1042, 2498, -692),
338(14, -1, -808595559, 2148, -690, 2498, -340),
339(15, -1, -808595559, 1796, -1998, 2146, -1648),
340(16, -1, -808595559, 1444, -1998, 1794, -1648),
341(17, -1, -808595559, 1092, -1998, 1442, -1648),
342(18, -1, -808595559, 1796, -1646, 2146, -1296),
343(19, -1, -808595559, 1444, -1646, 1794, -1296),
344(20, -1, -808595559, 1092, -1646, 1442, -1296),
345(21, -1, -808595559, 740, -1294, 1090, -1044),
346(22, -1, -808595559, 388, -1646, 738, -1296),
347(23, -1, -808595559, 36, -1646, 386, -1296),
348(24, -1, -808595559, 1796, -1294, 2146, -1044),
349(25, -1, -808595559, 1444, -1294, 1794, -1044),
350(26, -1, -808595559, 1092, -1294, 1442, -1044),
351(27, -1, -808595559, 740, -1646, 1090, -1296),
352(28, -1, -808595559, 36, -1294, 386, -1044),
353(29, -1, -808595559, 388, -1294, 738, -1044),
354(30, -1, -808595559, 1796, -1042, 2146, -692),
355(31, -1, -808595559, 1444, -1042, 1794, -692),
356(32, -1, -808595559, 1092, -1042, 1442, -692),
357(33, -1, -808595559, 740, -1042, 1090, -692),
358(34, -1, -808595559, 388, -1042, 738, -692),
359(35, -1, -808595559, 36, -1042, 386, -692),
360(36, -1, -808595559, 1796, -690, 2146, -340),
361(37, -1, -808595559, 1444, -690, 1794, -340),
362(38, -1, -808595559, 36, -690, 386, -340),
363(39, -1, -808595559, 388, -690, 738, -340),
364(40, -1, -808595559, 740, -690, 1090, -340),
365(41, -1, -808595559, 1092, -690, 1442, -340);
366
367-- --------------------------------------------------------
368
369--
370-- Table structure for table `hduplicatedkey`
371--
372
373CREATE TABLE IF NOT EXISTS `hduplicatedkey` (
374 `ID` int(11) NOT NULL AUTO_INCREMENT,
375 `HouseID` smallint(4) NOT NULL DEFAULT '-1',
376 `Owner` varchar(24) NOT NULL DEFAULT 'NoBodY',
377 `LockDoor` tinyint(1) NOT NULL DEFAULT '1',
378 `Evict` tinyint(1) NOT NULL DEFAULT '0',
379 `Houselocker` tinyint(1) NOT NULL DEFAULT '0',
380 `Rent` tinyint(1) NOT NULL DEFAULT '0',
381 PRIMARY KEY (`ID`)
382) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
383
384-- --------------------------------------------------------
385
386--
387-- Table structure for table `helperchat`
388--
389
390CREATE TABLE IF NOT EXISTS `helperchat` (
391 `ID` int(11) NOT NULL AUTO_INCREMENT,
392 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
393 `Message` varchar(128) NOT NULL DEFAULT 'Nothing',
394 `IP` varchar(31) NOT NULL DEFAULT 'N/A',
395 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
396 PRIMARY KEY (`ID`)
397) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
398
399-- --------------------------------------------------------
400
401--
402-- Table structure for table `houseinfo`
403--
404
405CREATE TABLE IF NOT EXISTS `HouseInfo` (
406 `ID` smallint(4) NOT NULL DEFAULT '-1',
407 `Owner` varchar(24) NOT NULL DEFAULT 'NoBodY',
408 `X` float NOT NULL DEFAULT '1681.97',
409 `Y` float NOT NULL DEFAULT '-1245.81',
410 `Z` float NOT NULL DEFAULT '129.365',
411 `Interior` int(9) NOT NULL DEFAULT '0',
412 `VirtualWorld` int(9) NOT NULL DEFAULT '0',
413 `InteriorPack` tinyint(2) NOT NULL DEFAULT '0',
414 `Till` int(10) NOT NULL DEFAULT '500',
415 `Cash` int(10) NOT NULL DEFAULT '0',
416 `SGuns` int(10) NOT NULL DEFAULT '0',
417 `SDrugs` int(10) NOT NULL DEFAULT '0',
418 `Rentable` tinyint(1) NOT NULL DEFAULT '1',
419 `Rentprice` smallint(5) NOT NULL DEFAULT '1500',
420 `Buyable` tinyint(1) NOT NULL DEFAULT '1',
421 `Sellprice` int(10) NOT NULL DEFAULT '16500',
422 `Level` tinyint(1) NOT NULL DEFAULT '1',
423 `Closed` tinyint(1) NOT NULL DEFAULT '0',
424 `Weapons` varchar(34) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0',
425 `Ammo` varchar(50) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0',
426 `HouseLocker` tinyint(1) NOT NULL DEFAULT '1',
427 `Alarm` tinyint(2) NOT NULL DEFAULT '0',
428 `GarageX` float NOT NULL DEFAULT '0',
429 `GarageY` float NOT NULL DEFAULT '0',
430 `GarageZ` float NOT NULL DEFAULT '0',
431 `GarageA` float NOT NULL DEFAULT '0',
432 `GarageInterior` int(10) NOT NULL DEFAULT '31337',
433 `GarageVirtualWorld` int(10) NOT NULL DEFAULT '0',
434 `GInteriorPack` tinyint(2) NOT NULL DEFAULT '0',
435 `GarageOpen` tinyint(1) NOT NULL DEFAULT '1',
436 `Wardrobe` tinyint(1) NOT NULL DEFAULT '0',
437 `Armour` tinyint(1) NOT NULL DEFAULT '0',
438 `Skin-Slot-0` smallint(3) NOT NULL DEFAULT '-1',
439 `Skin-Slot-1` smallint(3) NOT NULL DEFAULT '-1',
440 `Skin-Slot-2` smallint(3) NOT NULL DEFAULT '-1',
441 `Skin-Slot-3` smallint(3) NOT NULL DEFAULT '-1',
442 `Skin-Slot-4` smallint(3) NOT NULL DEFAULT '-1'
443) ENGINE=InnoDB DEFAULT CHARSET=latin1;
444
445-- --------------------------------------------------------
446
447--
448-- Table structure for table `hqinfo`
449--
450
451CREATE TABLE IF NOT EXISTS `HQInfo` (
452 `ID` tinyint(2) NOT NULL DEFAULT '-1',
453 `Open` tinyint(1) NOT NULL DEFAULT '0',
454 `StockTog` tinyint(1) NOT NULL DEFAULT '1',
455 `Stock` int(10) NOT NULL DEFAULT '500',
456 `X` float NOT NULL DEFAULT '0',
457 `Y` float NOT NULL DEFAULT '0',
458 `Z` float NOT NULL DEFAULT '0',
459 `A` float NOT NULL DEFAULT '0',
460 `Interior` int(10) NOT NULL DEFAULT '0',
461 `VirtualWorld` int(10) NOT NULL DEFAULT '0',
462 `LeaderX` float NOT NULL DEFAULT '0',
463 `LeaderY` float NOT NULL DEFAULT '0',
464 `LeaderZ` float NOT NULL DEFAULT '0',
465 `LeaderA` float NOT NULL DEFAULT '0',
466 `LeaderInterior` int(10) NOT NULL DEFAULT '0',
467 `LeaderVirtualWorld` int(10) NOT NULL DEFAULT '0',
468 `SpawnX` float NOT NULL DEFAULT '0',
469 `SpawnY` float NOT NULL DEFAULT '0',
470 `SpawnZ` float NOT NULL DEFAULT '0',
471 `SpawnA` float NOT NULL DEFAULT '0',
472 `SpawnInterior` int(10) NOT NULL DEFAULT '0',
473 `SpawnVirtualWorld` int(10) NOT NULL DEFAULT '0',
474 `RoofX` float NOT NULL DEFAULT '0',
475 `RoofY` float NOT NULL DEFAULT '0',
476 `RoofZ` float NOT NULL DEFAULT '0',
477 `RoofA` float NOT NULL DEFAULT '0',
478 `RoofInterior` int(10) NOT NULL DEFAULT '0',
479 `RoofVirtualWorld` int(10) NOT NULL DEFAULT '0'
480) ENGINE=InnoDB DEFAULT CHARSET=latin1;
481
482-- --------------------------------------------------------
483
484--
485-- Table structure for table `logindb`
486--
487
488CREATE TABLE IF NOT EXISTS `LoginDB` (
489 `ID` int(11) NOT NULL AUTO_INCREMENT,
490 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
491 `IP` varchar(24) NOT NULL DEFAULT '0.0.0.0',
492 `DateTime` varchar(35) NOT NULL DEFAULT '07.10.2015',
493 `Successful` tinyint(1) NOT NULL DEFAULT '0',
494 PRIMARY KEY (`ID`)
495) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
496
497-- --------------------------------------------------------
498
499--
500-- Table structure for table `moneylog`
501--
502
503CREATE TABLE IF NOT EXISTS `moneylog` (
504 `ID` int(11) NOT NULL AUTO_INCREMENT,
505 `PlayerName` varchar(24) NOT NULL,
506 `Amount` int(11) NOT NULL DEFAULT '0',
507 `Type` smallint(2) NOT NULL DEFAULT '-1',
508 `IP` varchar(24) NOT NULL DEFAULT '0.0.0.0',
509 `TimeDate` varchar(31) NOT NULL DEFAULT 'N/A',
510 `Reason` varchar(128) NOT NULL DEFAULT 'N/A',
511 PRIMARY KEY (`ID`)
512) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
513
514-- --------------------------------------------------------
515
516--
517-- Table structure for table `namechanges`
518--
519
520CREATE TABLE IF NOT EXISTS `namechanges` (
521 `ID` int(11) NOT NULL AUTO_INCREMENT,
522 `NewName` varchar(24) NOT NULL,
523 `OldName` varchar(24) NOT NULL,
524 `TimeDate` varchar(24) NOT NULL,
525 PRIMARY KEY (`ID`)
526) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
527
528-- --------------------------------------------------------
529
530--
531-- Table structure for table `offlinemessages`
532--
533
534CREATE TABLE IF NOT EXISTS `offlinemessages` (
535 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
536 `Message` varchar(252) DEFAULT NULL,
537 `Date` varchar(24) DEFAULT NULL
538) ENGINE=InnoDB DEFAULT CHARSET=latin1;
539
540-- --------------------------------------------------------
541
542--
543-- Table structure for table `opms`
544--
545
546CREATE TABLE IF NOT EXISTS `opms` (
547 `ID` int(11) NOT NULL AUTO_INCREMENT,
548 `To` varchar(24) NOT NULL DEFAULT 'None',
549 `From` varchar(24) NOT NULL DEFAULT 'None',
550 `Message` varchar(128) NOT NULL DEFAULT 'None',
551 `Active` tinyint(1) NOT NULL DEFAULT '0',
552 PRIMARY KEY (`ID`)
553) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
554
555-- --------------------------------------------------------
556
557--
558-- Table structure for table `playerinfo`
559--
560
561CREATE TABLE IF NOT EXISTS `PlayerInfo` (
562 `SQLID` int(11) NOT NULL AUTO_INCREMENT,
563 `Online` tinyint(1) NOT NULL DEFAULT '0',
564 `PlayerName` varchar(44) DEFAULT NULL,
565 `Password` varchar(129) NOT NULL,
566 `IP` varchar(16) DEFAULT '0.0.0.0',
567 `Money` int(10) NOT NULL DEFAULT '10000',
568 `Bank` int(10) NOT NULL DEFAULT '0',
569 `level` tinyint(3) unsigned NOT NULL DEFAULT '1',
570 `RPoints` smallint(4) NOT NULL DEFAULT '0',
571 `PlayerTime` mediumint(6) NOT NULL DEFAULT '0',
572 `Jail` tinyint(1) NOT NULL DEFAULT '0',
573 `JailTime` mediumint(5) NOT NULL DEFAULT '0',
574 `Banned` tinyint(1) NOT NULL DEFAULT '0',
575 `BanReason` varchar(64) NOT NULL DEFAULT 'None',
576 `WhoBannedMe` varchar(24) NOT NULL DEFAULT 'NoBodY',
577 `WhenIGotBanned` varchar(15) NOT NULL DEFAULT 'None',
578 `Skin` smallint(3) NOT NULL DEFAULT '1',
579 `RentPrice` smallint(5) NOT NULL DEFAULT '0',
580 `DriverLicense` tinyint(1) NOT NULL DEFAULT '0',
581 `PilotLicense` tinyint(1) NOT NULL DEFAULT '0',
582 `WeaponLicense` tinyint(1) NOT NULL DEFAULT '0',
583 `SailingLicense` tinyint(1) NOT NULL DEFAULT '0',
584 `JobSkill` smallint(5) NOT NULL DEFAULT '0',
585 `TotalPlayTime` mediumint(5) NOT NULL DEFAULT '0',
586 `Kills` int(8) NOT NULL DEFAULT '0',
587 `Deaths` int(8) NOT NULL DEFAULT '0',
588 `RentHouse` smallint(4) NOT NULL DEFAULT '-1',
589 `Loan` smallint(5) NOT NULL DEFAULT '0',
590 `Guns` smallint(5) NOT NULL DEFAULT '0',
591 `SGuns` int(10) NOT NULL DEFAULT '0',
592 `SDrugs` int(10) NOT NULL DEFAULT '0',
593 `AdminLevel` smallint(5) NOT NULL DEFAULT '0',
594 `HeadActive` tinyint(1) NOT NULL DEFAULT '0',
595 `HeadBy` varchar(24) NOT NULL DEFAULT 'NoBodY',
596 `Bail` mediumint(7) NOT NULL DEFAULT '0',
597 `PremiumLevel` tinyint(1) NOT NULL DEFAULT '0',
598 `GotPhone` tinyint(1) NOT NULL DEFAULT '0',
599 `PhoneNumber` mediumint(7) NOT NULL DEFAULT '-1',
600 `PhoneBook` tinyint(1) NOT NULL DEFAULT '0',
601 `Laptop` tinyint(1) NOT NULL DEFAULT '0',
602 `Age` tinyint(2) NOT NULL DEFAULT '25',
603 `PremiumExpire` int(10) NOT NULL DEFAULT '0',
604 `FactionID` tinyint(3) unsigned NOT NULL DEFAULT '255',
605 `Radio` tinyint(1) NOT NULL DEFAULT '0',
606 `Freq1` mediumint(7) NOT NULL DEFAULT '666',
607 `Freq2` mediumint(7) NOT NULL DEFAULT '666',
608 `Freq3` mediumint(7) NOT NULL DEFAULT '666',
609 `CurrentFrequency` mediumint(7) NOT NULL DEFAULT '666',
610 `TBanned` int(10) NOT NULL DEFAULT '0',
611 `Married` varchar(24) NOT NULL DEFAULT 'NoBodY',
612 `Job` varchar(12) NOT NULL DEFAULT 'None',
613 `TotalRuns` smallint(5) unsigned NOT NULL DEFAULT '0',
614 `FactionPay` mediumint(7) NOT NULL DEFAULT '0',
615 `DrugInfo` varchar(30) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0',
616 `Warns` tinyint(3) unsigned NOT NULL DEFAULT '0',
617 `Helper` tinyint(1) unsigned NOT NULL DEFAULT '0',
618 `RankName` varchar(64) NOT NULL DEFAULT 'CIV',
619 `PhoneChanges` tinyint(3) unsigned NOT NULL DEFAULT '0',
620 `PhoneOFF` tinyint(1) NOT NULL DEFAULT '0',
621 `OOCOff` tinyint(1) NOT NULL DEFAULT '0',
622 `WhisperLock` tinyint(1) NOT NULL DEFAULT '0',
623 `jqmessage` tinyint(1) NOT NULL DEFAULT '0',
624 `NameOFF` tinyint(1) NOT NULL DEFAULT '0',
625 `Seeds` smallint(5) unsigned NOT NULL DEFAULT '0',
626 `FishAmount` smallint(4) unsigned NOT NULL DEFAULT '0',
627 `TotalFish` mediumint(8) unsigned NOT NULL DEFAULT '0',
628 `TotalRob` int(10) NOT NULL DEFAULT '0',
629 `totalguns` mediumint(8) unsigned NOT NULL DEFAULT '0',
630 `TotalLogin` smallint(5) unsigned NOT NULL DEFAULT '0',
631 `Key_Enter` varchar(1) NOT NULL DEFAULT '2',
632 `imprisoned` int(1) NOT NULL DEFAULT '0',
633 `OOCMode` tinyint(1) NOT NULL DEFAULT '0',
634 `Fightstyleleft` smallint(5) NOT NULL DEFAULT '0',
635 `Tier` tinyint(2) NOT NULL DEFAULT '-1',
636 `SellableDrugs` int(10) NOT NULL DEFAULT '0',
637 `JailReason` varchar(64) NOT NULL DEFAULT 'None',
638 `vMax` smallint(4) NOT NULL DEFAULT '12',
639 `vSMax` tinyint(2) NOT NULL DEFAULT '2',
640 `pbkills` smallint(5) NOT NULL DEFAULT '0',
641 `pbdeaths` smallint(5) NOT NULL DEFAULT '0',
642 `LastOnline` varchar(45) NOT NULL DEFAULT '0',
643 `Gender` tinyint(1) NOT NULL DEFAULT '-1',
644 `Ethnicity` tinyint(1) NOT NULL DEFAULT '-1',
645 `Boombox` tinyint(1) NOT NULL DEFAULT '0',
646 `NameChanges` smallint(3) NOT NULL DEFAULT '0',
647 `AllowCBug` tinyint(1) NOT NULL DEFAULT '0',
648 `BoomBoxBan` tinyint(1) NOT NULL DEFAULT '0',
649 `ChatAnim` tinyint(1) NOT NULL DEFAULT '1',
650 `Wanted` tinyint(1) NOT NULL DEFAULT '0',
651 `WantedReason` varchar(128) NOT NULL DEFAULT 'None',
652 PRIMARY KEY (`SQLID`),
653 UNIQUE KEY `PlayerName` (`PlayerName`)
654) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
655
656-- --------------------------------------------------------
657
658--
659-- Table structure for table `playernotes`
660--
661
662CREATE TABLE IF NOT EXISTS `playernotes` (
663 `ID` int(11) NOT NULL AUTO_INCREMENT,
664 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
665 `Message` varchar(128) DEFAULT NULL,
666 `TimeDate` datetime DEFAULT NULL,
667 PRIMARY KEY (`ID`),
668 UNIQUE KEY `ID` (`ID`)
669) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
670
671-- --------------------------------------------------------
672
673--
674-- Table structure for table `playertickets`
675--
676
677CREATE TABLE IF NOT EXISTS `playertickets` (
678 `ID` int(11) NOT NULL AUTO_INCREMENT,
679 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
680 `ByWho` varchar(24) NOT NULL DEFAULT 'NoBodY',
681 `Reason` varchar(128) NOT NULL,
682 `Amount` int(10) NOT NULL DEFAULT '500',
683 `DateTime` varchar(24) NOT NULL DEFAULT 'Now',
684 `Active` tinyint(1) NOT NULL DEFAULT '1',
685 PRIMARY KEY (`ID`)
686) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
687
688-- --------------------------------------------------------
689
690--
691-- Table structure for table `playertoyinfo`
692--
693
694CREATE TABLE IF NOT EXISTS `playertoyinfo` (
695 `ID` bigint(15) NOT NULL AUTO_INCREMENT,
696 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
697 `SlotID` smallint(3) NOT NULL DEFAULT '0',
698 `ModelID` smallint(5) NOT NULL DEFAULT '0',
699 `Bone` tinyint(2) NOT NULL DEFAULT '0',
700 `ToyName` varchar(75) NOT NULL DEFAULT 'None',
701 `X` float NOT NULL DEFAULT '0',
702 `Y` float NOT NULL DEFAULT '0',
703 `Z` float NOT NULL DEFAULT '0',
704 `rX` float NOT NULL DEFAULT '0',
705 `rY` float NOT NULL DEFAULT '0',
706 `rZ` float NOT NULL DEFAULT '0',
707 `ScaleX` float NOT NULL DEFAULT '0',
708 `ScaleY` float NOT NULL DEFAULT '0',
709 `ScaleZ` float NOT NULL DEFAULT '0',
710 `Active` tinyint(1) NOT NULL DEFAULT '0',
711 PRIMARY KEY (`ID`)
712) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
713
714-- --------------------------------------------------------
715
716--
717-- Table structure for table `policedb`
718--
719
720CREATE TABLE IF NOT EXISTS `policedb` (
721 `ID` int(11) NOT NULL AUTO_INCREMENT,
722 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
723 `Reason` varchar(128) NOT NULL DEFAULT 'Nothing',
724 `Date` varchar(24) NOT NULL DEFAULT '07.10.2015',
725 PRIMARY KEY (`ID`)
726) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
727
728-- --------------------------------------------------------
729
730--
731-- Table structure for table `querylogs`
732--
733
734CREATE TABLE IF NOT EXISTS `querylogs` (
735 `ID` bigint(255) NOT NULL AUTO_INCREMENT,
736 `Query` varchar(535) DEFAULT NULL,
737 PRIMARY KEY (`ID`)
738) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
739
740-- --------------------------------------------------------
741
742--
743-- Table structure for table `security`
744--
745
746CREATE TABLE IF NOT EXISTS `security` (
747 `ID` int(11) NOT NULL AUTO_INCREMENT,
748 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
749 `IP` varchar(31) NOT NULL DEFAULT 'N/A',
750 `TimeDate` varchar(31) NOT NULL DEFAULT '31',
751 `Reason` varchar(128) NOT NULL DEFAULT 'Nothing',
752 PRIMARY KEY (`ID`)
753) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
754
755-- --------------------------------------------------------
756
757--
758-- Table structure for table `strangerdb`
759--
760
761CREATE TABLE IF NOT EXISTS `strangerdb` (
762 `ID` int(11) NOT NULL AUTO_INCREMENT,
763 `PlayerName` varchar(24) NOT NULL DEFAULT 'NoBodY',
764 `StrangerID` mediumint(6) NOT NULL,
765 `Date` varchar(31) NOT NULL,
766 `IP` varchar(31) NOT NULL DEFAULT '0',
767 PRIMARY KEY (`ID`)
768) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
769
770-- --------------------------------------------------------
771
772--
773-- Table structure for table `teleportinfo`
774--
775
776CREATE TABLE IF NOT EXISTS `TeleportInfo` (
777 `ID` smallint(4) NOT NULL DEFAULT '-1',
778 `Name` varchar(75) NOT NULL DEFAULT 'None',
779 `X` float NOT NULL DEFAULT '0',
780 `Y` float NOT NULL DEFAULT '0',
781 `Z` float NOT NULL DEFAULT '0',
782 `A` float NOT NULL DEFAULT '0',
783 `Interior` int(11) NOT NULL DEFAULT '0',
784 `VirtualWorld` int(11) NOT NULL DEFAULT '0',
785 `intX` float NOT NULL DEFAULT '0',
786 `intY` float NOT NULL DEFAULT '0',
787 `intZ` float NOT NULL DEFAULT '0',
788 `intA` float NOT NULL DEFAULT '0',
789 `intInterior` int(11) NOT NULL DEFAULT '0',
790 `intVirtualWorld` int(11) NOT NULL DEFAULT '0',
791 `HouseID` int(10) NOT NULL DEFAULT '-1',
792 `intHouseID` int(10) NOT NULL DEFAULT '-1'
793) ENGINE=InnoDB DEFAULT CHARSET=latin1;
794
795-- --------------------------------------------------------
796
797--
798-- Table structure for table `vehicleinfo`
799--
800
801CREATE TABLE IF NOT EXISTS `VehicleInfo` (
802 `ID` smallint(5) NOT NULL DEFAULT '-1',
803 `Owner` varchar(24) DEFAULT 'NoBodY',
804 `Dupekey` varchar(24) NOT NULL DEFAULT 'NoBodY',
805 `Model` smallint(3) NOT NULL DEFAULT '400',
806 `X` float NOT NULL DEFAULT '1681.97',
807 `Y` float NOT NULL DEFAULT '-1245.81',
808 `Z` float NOT NULL DEFAULT '129.365',
809 `A` float NOT NULL DEFAULT '272.773',
810 `VirtualWorld` int(11) NOT NULL DEFAULT '0',
811 `Colour1` smallint(3) NOT NULL DEFAULT '1',
812 `Colour2` int(3) NOT NULL DEFAULT '1',
813 `Paintjob` tinyint(2) NOT NULL DEFAULT '-1',
814 `FactionID` smallint(3) NOT NULL DEFAULT '255',
815 `Reserved` tinyint(1) NOT NULL DEFAULT '0',
816 `Job` varchar(12) NOT NULL DEFAULT 'None',
817 `Business` smallint(3) NOT NULL DEFAULT '-1',
818 `Sellprice` int(10) NOT NULL DEFAULT '0',
819 `Fuel` tinyint(3) NOT NULL DEFAULT '100',
820 `VehicleGuns` tinyint(2) NOT NULL DEFAULT '0',
821 `VehicleBullets` tinyint(2) NOT NULL DEFAULT '0',
822 `HasGunCrates` tinyint(2) NOT NULL DEFAULT '0',
823 `HasBulletCrates` tinyint(2) NOT NULL DEFAULT '0',
824 `Stuffs` smallint(3) NOT NULL DEFAULT '0',
825 `Guns` smallint(3) NOT NULL DEFAULT '0',
826 `Alchool` smallint(3) NOT NULL DEFAULT '0',
827 `Cars` smallint(3) DEFAULT '0',
828 `Money` int(10) NOT NULL DEFAULT '0',
829 `Oil` smallint(3) NOT NULL DEFAULT '0',
830 `Drugs` smallint(3) NOT NULL DEFAULT '0',
831 `Impounded` tinyint(1) NOT NULL DEFAULT '0',
832 `Components` varchar(35) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0,0',
833 `Weapons` varchar(35) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0',
834 `Ammo` varchar(35) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0,0,0,0',
835 `Location` varchar(40) NOT NULL DEFAULT 'Commerce',
836 `ImpoundFee` smallint(5) NOT NULL DEFAULT '0',
837 `ImpoundReason` varchar(128) NOT NULL DEFAULT 'None',
838 `Mileage` mediumint(7) NOT NULL DEFAULT '0',
839 `Alarm` tinyint(1) NOT NULL DEFAULT '0',
840 `Plate` varchar(12) NOT NULL DEFAULT 'NOTREG',
841 `Registered` tinyint(1) NOT NULL DEFAULT '0',
842 UNIQUE KEY `ID` (`ID`)
843) ENGINE=InnoDB DEFAULT CHARSET=latin1;
844
845-- --------------------------------------------------------
846
847--
848-- Table structure for table `whinfo`
849--
850
851CREATE TABLE IF NOT EXISTS `WHInfo` (
852 `ID` tinyint(3) NOT NULL DEFAULT '-1',
853 `X` float NOT NULL DEFAULT '0',
854 `Y` float NOT NULL DEFAULT '0',
855 `Z` float NOT NULL DEFAULT '0',
856 `Interior` int(10) NOT NULL DEFAULT '0',
857 `VirtualWorld` int(10) NOT NULL DEFAULT '0',
858 `Open` tinyint(1) NOT NULL DEFAULT '0',
859 `Materials` int(10) NOT NULL DEFAULT '0',
860 `Lead` int(10) NOT NULL DEFAULT '0',
861 `Metal` int(10) NOT NULL DEFAULT '0',
862 `Level` tinyint(1) NOT NULL DEFAULT '1',
863 PRIMARY KEY (`ID`),
864 UNIQUE KEY `ID` (`ID`)
865) ENGINE=InnoDB DEFAULT CHARSET=latin1;
866
867-- --------------------------------------------------------
868
869--
870-- Table structure for table `GateInfo`
871--
872
873CREATE TABLE IF NOT EXISTS `GateInfo` (
874 `ID` tinyint(3) NOT NULL DEFAULT '-1',
875 `X` float NOT NULL DEFAULT '0',
876 `Y` float NOT NULL DEFAULT '0',
877 `Z` float NOT NULL DEFAULT '0',
878 `rX` float NOT NULL DEFAULT '0',
879 `rY` float NOT NULL DEFAULT '0',
880 `rZ` float NOT NULL DEFAULT '0',
881 `mX` float NOT NULL DEFAULT '0',
882 `mY` float NOT NULL DEFAULT '0',
883 `mZ` float NOT NULL DEFAULT '0',
884 `mrX` float NOT NULL DEFAULT '0',
885 `mrY` float NOT NULL DEFAULT '0',
886 `mrZ` float NOT NULL DEFAULT '0',
887 `Interior` int(10) NOT NULL DEFAULT '0',
888 `VirtualWorld` int(10) NOT NULL DEFAULT '0',
889 `House` smallint(3) NOT NULL DEFAULT '-1',
890 `Business` smallint(3) NOT NULL DEFAULT '-1',
891 `Faction` smallint(3) NOT NULL DEFAULT '-1',
892 `Owner` varchar(24) DEFAULT 'NoBodY',
893 PRIMARY KEY (`ID`),
894 UNIQUE KEY `ID` (`ID`)
895) ENGINE=InnoDB DEFAULT CHARSET=latin1;
896
897/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
898/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
899/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;