uid          INT NOT NULL AUTO_INCREMENT,
    pid          VARCHAR(17) NOT NULL,
    name         VARCHAR(32) NOT NULL,
    aliases      TEXT NOT NULL,
    cash         INT NOT NULL DEFAULT 0,
    bankacc      INT NOT NULL DEFAULT 0,
    coplevel     ENUM('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
    mediclevel   ENUM('0','1','2','3','4','5') NOT NULL DEFAULT '0',
    civ_licenses TEXT NOT NULL,
    cop_licenses TEXT NOT NULL,
    med_licenses TEXT NOT NULL,
    civ_gear     TEXT NOT NULL,
    cop_gear     TEXT NOT NULL,
    med_gear     TEXT NOT NULL,
    civ_stats    VARCHAR(25) NOT NULL DEFAULT '"[100,100,0]"',
    cop_stats    VARCHAR(25) NOT NULL DEFAULT '"[100,100,0]"',
    med_stats    VARCHAR(25) NOT NULL DEFAULT '"[100,100,0]"',
    arrested     TINYINT NOT NULL DEFAULT 0,
    adminlevel   ENUM('0','1','2','3','4','5')  NOT NULL DEFAULT '0',
    donorlevel   ENUM('0','1','2','3','4','5')  NOT NULL DEFAULT '0',
    blacklist    TINYINT NOT NULL DEFAULT 0,
    civ_alive    TINYINT NOT NULL DEFAULT 0,
    civ_position VARCHAR(32) NOT NULL DEFAULT '"[]"',
    playtime     VARCHAR(32) NOT NULL DEFAULT '"[0,0,0]"',
    insert_time  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    last_seen    TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    side     TEXT NOT NULL,