ihTeyerA

1CREATE TABLE IF NOT EXISTS `players` (
2  `uid` int(12) NOT NULL AUTO_INCREMENT,
3  `name` varchar(32) NOT NULL,
4  `playerid` varchar(50) NOT NULL,
5  `cash` int(100) NOT NULL DEFAULT '0',
6  `bankacc` int(100) NOT NULL DEFAULT '0',
7  `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15') DEFAULT '0',
8  `cop_licenses` text,
9  `civ_licenses` text,
10  `med_licenses` text,
11  `cop_gear` text NOT NULL,
12  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
13  `arrested` tinyint(1) NOT NULL DEFAULT '0',
14  `aliases` text NOT NULL,
15  `adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
16  `donatorlvl` int(100) NOT NULL DEFAULT '0',
17  `civ_gear` text NOT NULL,
18  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
19  `admin_user` varchar(50) DEFAULT NULL,
20  `admin_pass` varchar(50) DEFAULT NULL,
21  `timeupdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
22  `timejoined` datetime DEFAULT NULL,
23  `med_gear` text NOT NULL,
24  `issupport` enum('0','1') NOT NULL DEFAULT '0',
25  `jailtime` int(11) NOT NULL DEFAULT '0',
26  `arrestreason` varchar(150) NOT NULL,
27  `streamSaftey` tinyint(1) NOT NULL DEFAULT '0',
28  PRIMARY KEY (`uid`),
29  UNIQUE KEY `playerid` (`playerid`),
30  KEY `name` (`name`),
31  KEY `blacklist` (`blacklist`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;