nWL3wJUT

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