Installation

SQL

CREATE TABLE IF NOT EXISTS `students` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `citizenid` VARCHAR(50) NOT NULL,
    `name` VARCHAR(100) NOT NULL,
    `model` VARCHAR(100) NOT NULL,
    `level` INT DEFAULT 0,
    `xp` INT DEFAULT 0,
    `wins` INT DEFAULT 0,
    `losses` INT DEFAULT 0,
    UNIQUE KEY `unique_student` (`citizenid`, `name`)
);

Enjoy! You can let us know if theres any issues or if you have any questions here

Last updated