· 9 years ago · Dec 30, 2016, 11:32 PM
1CREATE TABLE IF NOT EXISTS copuser(
2`userid` INT(6) NOT NULL AUTO_INCREMENT,
3`playerid` varchar(17) NOT NULL,
4`badgenum` INT(3) NOT NULL,
5`username` VARCHAR(30) NOT NULL,
6`userpass` CHAR(64) NOT NULL,
7`salt` CHAR(32) NOT NULL,
8`tnc` INT(1) NOT NULL,
9`coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
10sessionid VARCHAR(64),
11PRIMARY KEY (userid)
12);