SpMavc9Z

1DROP DATABASE IF EXISTS LunchAPI;
2CREATE DATABASE LunchAPI;
3USE LunchAPI;
4
5CREATE TABLE User(
6	id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
7	name VARCHAR(200),
8    password VARCHAR(200),
9    role ENUM('admin', 'user')
10);
11
12CREATE TABLE Meeting(
13	id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
14    description VARCHAR(500),
15    meeting_time DATETIME
16);
17
18CREATE TABLE User_meeting_connection(
19	id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
20    user_id INTEGER NOT NULL,
21    meeting_id INTEGER NOT NULL,
22    
23	FOREIGN KEY(user_id) REFERENCES User(id),
24    FOREIGN KEY(meeting_id) REFERENCES Meeting(id)
25);