8PHeenH8

1CREATE TABLE IF NOT EXISTS users (
2	user_id SERIAL PRIMARY KEY, 
3	login VARCHAR(25) UNIQUE,
4	password VARCHAR(25) NOT NULL
5);
6
7CREATE TABLE IF NOT EXISTS books (
8	book_id SERIAL PRIMARY KEY,
9	title VARCHAR(100) NOT NULL,
10	author VARCHAR(100) NOT NULL,
11	genre VARCHAR(50) NOT NULL,
12	description VARCHAR(200),
13	price INTEGER NOT NULL,
14	copies INTEGER NOT NULL,
15	number_of_pages INTEGER NOT NULL,
16	is_for_sale BOOLEAN DEFAULT true
17);
18
19CREATE TABLE IF NOT EXISTS transactions (
20	transaction_id SERIAL PRIMARY KEY,
21	book_id INTEGER references books(book_id),
22	date DATE,
23	amount INTEGER 
24);