RwG8J057

1CREATE TABLE IF NOT EXISTS users
2(
3    id    SERIAL PRIMARY KEY ,
4    role VARCHAR(10) NOT NULL DEFAULT 'USER' ,
5    login VARCHAR(30) NOT NULL UNIQUE ,
6    password VARCHAR(60)  NOT NULL
7);
8
9CREATE TABLE IF NOT EXISTS posts
10(
11    id SERIAL PRIMARY KEY ,
12    title VARCHAR(40) NOT NULL ,
13    content text NOT NULL ,
14    image VARCHAR(50) DEFAULT '0052b95f-e4d5-407b-a68a-45e32169e725.png',
15    tags text ,
16    author_id INT NOT NULL ,
17    publish BOOLEAN NOT NULL DEFAULT TRUE
18);
19
20CREATE TABLE IF NOT EXISTS tasks
21(
22    id SERIAL PRIMARY KEY ,
23    name VARCHAR(60) NOT NULL ,
24    content text NOT NULL ,
25    multiple BOOLEAN NOT NULL DEFAULT FALSE ,
26    formats VARCHAR(20) NOT NULL DEFAULT '*' ,
27    homework_id INT NOT NULL
28);
29
30CREATE TABLE IF NOT EXISTS homeworks
31(
32    id SERIAL PRIMARY KEY ,
33    name VARCHAR(60) NOT NULL ,
34    lesson_file VARCHAR(60) NOT NULL DEFAULT 'fc3b26a8-af8b-473d-bff7-58e9435c3efb.pdf' ,
35    end_date VARCHAR(10) NOT NULL DEFAULT '2020-10-01'
36)
37
38