Base de dades

CREATE TABLE USERS (
    user_id int NOT NULL AUTO_INCREMENT,
    user_name varchar(255),
    user_password varchar(255),
    user_mail varchar(255) UNIQUE,
    user_role ENUM ('user','admin'),
    primary key (user_id)
);

INSERT INTO USERS (user_name, user_password, user_mail, user_role) VALUES ('admin', '6b86b273ff34fce19d6b804eff5a3f5747ada4eaa22f1d49c01e52ddb7875b4b', 'admin@localhost', 'admin');


CREATE TABLE WORKSTATION (
    ws_id int NOT NULL AUTO_INCREMENT,
    ws_name varchar(255),
    primary key (ws_id)
);

CREATE TABLE APPOINTMENTS (
    app_id int NOT NULL AUTO_INCREMENT,
    app_datetime dateTime,
    app_type ENUM('user','blocked'),
    user_id int,
    ws_id int,
    primary key (app_id),
    FOREIGN KEY (user_id) REFERENCES USERS (user_id) ON DELETE CASCADE,
    FOREIGN KEY (ws_id) REFERENCES WORKSTATION (ws_id) ON DELETE CASCADE
);


CREATE TABLE DISABLEDDAYS (
    day date
);