<filename>tables.sql
CREATE TABLE users(
    userId INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255),
    password VARCHAR(255),
    role VARCHAR(255),
    groupID INT,
    categoryID INT,
    points INT
);

CREATE TABLE user_groups(
    groupID INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE category(
    categoryID INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
)

ALTER TABLE users ADD FOREIGN KEY (categoryID) REFERENCES category(categoryID);
ALTER TABLE users ADD FOREIGN KEY (groupID) REFERENCES user_groups(groupID);
