5wjQCya1

1CREATE TABLE IF NOT EXISTS image (
2    id INT PRIMARY KEY AUTO_INCREMENT,
3    url VARCHAR(250) NOT NULL
4);
5
6CREATE TABLE IF NOT EXISTS  user (
7    id INT PRIMARY KEY AUTO_INCREMENT,
8    firstname VARCHAR(50) NOT NULL,
9    lastname VARCHAR(50) NOT NULL,
10    email VARCHAR(75) NOT NULL UNIQUE,
11    password VARCHAR(128) NOT NULL,
12    socialid VARCHAR(11) DEFAULT NULL,
13    adress VARCHAR(75) DEFAULT NULL,
14    postnr VARCHAR(20) DEFAULT NULL,
15    city VARCHAR(50) DEFAULT NULL,
16);
17
18CREATE TABLE IF NOT EXISTS post (
19    id INT PRIMARY KEY AUTO_INCREMENT,
20    title VARCHAR(100) NOT NULL,
21    data TEXT NOT NULL,
22    image_id INT DEFAULT NULL,
23    user_id INT NOT NULL,
24    date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
25    FOREIGN KEY (image_id) REFERENCES image(id),
26    FOREIGN KEY (user_id) REFERENCES user(id)
27);
28
29CREATE TABLE IF NOT EXISTS comment (
30    id INT PRIMARY KEY AUTO_INCREMENT,
31    data TEXT NOT NULL,
32    post_id INT NOT NULL,
33    user_id INT NOT NULL,
34    FOREIGN KEY (post_id) REFERENCES post(id),
35    FOREIGN KEY (user_id) REFERENCES user(id)
36);