Uw42ziXf

1DROP TABLE IF EXISTS events CASCADE;
2DROP TABLE IF EXISTS events_menus;
3DROP TABLE IF EXISTS events_guests;
4
5CREATE TABLE events (
6  id SERIAL,
7  name INT NOT NULL,
8  startDate DATETIME NOT NULL,
9  endDate DATETIME NOT NULL,
10  deadlineDate DATETIME NOT NULL,
11  description VARCHAR(256) NOT NULL,
12  PRIMARY KEY(id)
13);
14
15CREATE INDEX events_id ON events (id);
16
17CREATE TABLE events_menus {
18  idEvent INT,
19  idMenu INT,
20  PRIMARY KEY(idEvent, idMenu),
21  FOREIGN KEY idEvent REFERENCES events(id)
22};
23
24CREATE TABLE events_guests {
25  idEvent INT,
26  idGuest INT,
27  PRIMARY KEY(idEvent, idGuest)
28  FOREIGN KEY idEvent REFERENCES events(id)
29};