Database

Please import the included init.sql file into your database.

Alternatively, you can copy and execute the following commands directly in your database.

CREATE TABLE IF NOT EXISTS `player_nametag_data` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `citizenid` VARCHAR(20) DEFAULT NULL,
    `firstname` VARCHAR(50) DEFAULT NULL,
    `lastname` VARCHAR(50) DEFAULT NULL,
    `namevisible` VARCHAR(10) DEFAULT NULL,
    `gangvisible` VARCHAR(10) DEFAULT NULL,
    `subtagvisible` VARCHAR(10) DEFAULT NULL,
    `allnamevisible` VARCHAR(10) DEFAULT NULL,
    `subtag` TEXT DEFAULT NULL,
    `badge` VARCHAR(20) DEFAULT NULL,
    `namecolor` VARCHAR(255) DEFAULT NULL,
    `subtagcolor` VARCHAR(255) DEFAULT NULL,
    PRIMARY KEY (`citizenid`),
    KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Last updated