6k03scGr

1CREATE TABLE IF NOT EXISTS `players` (
2  `uid` int(6) NOT NULL AUTO_INCREMENT,
3  `name` varchar(32) NOT NULL,
4  `aliases` text NOT NULL,
5  `pid` varchar(17) NOT NULL,
6  `banking_pin` int(4) NOT NULL DEFAULT '0',
7  `cash` int(100) NOT NULL DEFAULT '20',
8  `bankacc` int(100) NOT NULL DEFAULT '0',
9  `adminlevel` enum('0','1','2') NOT NULL DEFAULT '0',
10  `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
11  `mediclevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
12  `donorlevel` enum('0','1') NOT NULL DEFAULT '0',
13  `ganglevel` enum('0','1') NOT NULL DEFAULT '0',
14  `civ_licenses` text NOT NULL,
15  `cop_licenses` text NOT NULL,
16  `med_licenses` text NOT NULL,
17  `civ_gear` text NOT NULL,
18  `cop_gear` text NOT NULL,
19  `med_gear` text NOT NULL,
20  `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
21  `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
22  `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
23  `arrested` tinyint(1) NOT NULL DEFAULT '0',
24  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
25  `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
26  `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
27  `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
28  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
29  `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
30  `exp_level` int(11) NOT NULL DEFAULT '0',
31  `exp_total` int(11) NOT NULL DEFAULT '0',
32  `exp_perkPoints` int(11) NOT NULL DEFAULT '0',
33  `exp_perks` text,
34  `jail_time` int(11) NOT NULL DEFAULT '0',
35  PRIMARY KEY (`uid`),
36  UNIQUE KEY `pid` (`pid`),
37  KEY `name` (`name`),
38  KEY `blacklist` (`blacklist`)
39) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4;