9abie415

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(40) NOT NULL,
10    birthday VARCHAR(40) NOT NULL,
11    username VARCHAR(20) NOT NULL
12);
13CREATE TABLE books(
14    id SERIAL PRIMARY KEY,
15    title VARCHAR(40) NOT NULL,
16    category VARCHAR(20) NOT NULL,
17    author VARCHAR(40) NOT NULL,
18    publish_date VARCHAR(40) NOT NULL,
19    availability VARCHAR(20) NOT NULL
20);
21
22INSERT INTO books
23(id, title,category,author,publish_date,availability)
24VALUES
25(1, 'The Catcher in the Rye','STEM','qqqqqqq','11.12.1978','AVAILABLE'),
26(2, 'Nine Stories','Economy','zzzzzz','21.10.1875','AVAILABLE'),
27(3, 'Franny and Zooey','Sci-Fi','cccccc','11.12.2008','AVAILABLE'),
28(4, 'The Great Gatsby','Literature','bbbb','23.12.2101','AVAILABLE'),
29(5, 'Tender id the Night','Detective','aaaaaaa','10.09.2003','AVAILABLE'),
30(6, 'Pride and Prejudice','History','hhhhhhh','01.02.2245','AVAILABLE')
31;
32INSERT INTO books
33(id, title,category,author,publish_date,availability)
34VALUES
35(7, 'Meşdibad','STEM','asd','07.12.2000','AVAILABLE');
36
37
38select * from users;
39select * from roles;
40select * from books;
41select * from user_roles;
42
43INSERT INTO roles(name) VALUES('ROLE_USER');
44INSERT INTO roles(name) VALUES('ROLE_MODERATOR');
45INSERT INTO roles(name) VALUES('ROLE_ADMIN');
46
47drop table users;
48drop table user_roles;
49drop table roles;
50drop table books