zexnWpSn

1USE `whitelist`;
2CREATE TABLE IF NOT EXISTS `chars` (
3`ID` int(11) NOT NULL,
4  `STEAMID` varchar(255) NOT NULL,
5  `Username` varchar(255) NOT NULL,
6  `Firstname` varchar(255) NOT NULL,
7  `Lastname` varchar(255) NOT NULL,
8  `DOB` varchar(255) NOT NULL,
9  `Gender` varchar(255) NOT NULL,
10  `d_license` tinyint(1) NOT NULL,
11  `cd_license` tinyint(1) NOT NULL,
12  `license_p` int(11) NOT NULL,
13  `b_license` tinyint(1) NOT NULL,
14  `f_license` tinyint(1) NOT NULL
15) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
16CREATE TABLE IF NOT EXISTS `srr_char_bolos` (
17`ID` int(11) NOT NULL,
18  `STEAMID` varchar(255) NOT NULL,
19  `Username` varchar(255) NOT NULL,
20  `bolo` varchar(255) NOT NULL,
21  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
22) ENGINE=InnoDB DEFAULT CHARSET=latin1;
23-- --------------------------------------------------------
24
25
26CREATE TABLE IF NOT EXISTS `srr_char_charges` (
27`ID` int(11) NOT NULL,
28  `ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
29  `STEAMID` varchar(255) NOT NULL,
30  `Username` varchar(255) NOT NULL,
31  `officer_STEAMID` varchar(255) NOT NULL,
32  `officer_Username` varchar(255) NOT NULL,
33  `charge` varchar(255) NOT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
35-- --------------------------------------------------------
36
37
38CREATE TABLE IF NOT EXISTS `srr_char_plate` (
39`ID` int(11) NOT NULL,
40  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
41  `STEAMID` varchar(255) NOT NULL,
42  `Username` varchar(255) NOT NULL,
43  `plate_number` varchar(255) NOT NULL,
44  `veh_name` varchar(255) NOT NULL,
45  `flag_stolen` tinyint(1) NOT NULL
46) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;
47-- --------------------------------------------------------
48
49
50CREATE TABLE IF NOT EXISTS `srr_char_warrants` (
51`ID` int(11) NOT NULL,
52  `ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
53  `STEAMID` varchar(255) NOT NULL,
54  `Username` varchar(255) NOT NULL,
55  `officer_STEAMID` varchar(255) NOT NULL,
56  `officer_Username` varchar(255) NOT NULL,
57  `warrant` varchar(255) NOT NULL
58) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
59ALTER TABLE `chars`
60MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=70;
61/* SQL Error (1075): Incorrect table definition; there can be only one auto column and it must be defined as a key */
62/* Affected rows: 0  Found rows: 0  Varningar: 5  Duration for 6 of 11 queries: 0,157 sec. */
63SHOW WARNINGS LIMIT 5;