85X6zz53

1DROP TABLE IF EXISTS users;
2DROP TABLE IF EXISTS books;
3
4CREATE TABLE users (
5    id SERIAL PRIMARY KEY,
6    firstname VARCHAR(20) NOT NULL,
7    lastname VARCHAR(20) NOT NULL,
8    email VARCHAR(40) NOT NULL,
9    password VARCHAR(1024) NOT NULL,
10    birthday VARCHAR(40) NOT NULL,
11    username VARCHAR(20) NOT NULL
12);
13
14CREATE TABLE tasks   (
15    id SERIAL PRIMARY KEY,
16    title VARCHAR(40) NOT NULL,
17    description VARCHAR(250) NOT NULL,
18    start_date VARCHAR(40) NOT NULL,
19    end_date VARCHAR(40) NOT NULL,
20    priority VARCHAR(20) NOT NULL,
21    task_status VARCHAR(20) NOT NULL,
22    assigned_to varchar(20) NOT NULL
23);
24
25insert into tasks(title, description, start_date, end_date, priority, task_status)
26 VALUES ('Sample','Streync???','11.05.2021','16.05.2021','High','Not Completed')
27
28select * from users;
29select * from tasks;
30select * from roles;
31select * from user_roles;
32select * from user_tasks;
33
34INSERT INTO roles(name) VALUES('ROLE_USER');
35INSERT INTO roles(name) VALUES('ROLE_ADMIN');
36
37drop table users;
38drop table user_roles;
39drop table user_tasks;
40drop table roles;
41drop table tasks;
42