1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
drop table if exists borrowed_book;
drop table if exists book;
drop table if exists user_account;
create table user_account (
uid serial primary key,
username text unique not null,
name text,
password text
);
insert into user_account (username, name) values ('kamal', 'Kamal Wickramanayake');
insert into user_account (username, name) values ('tharindu', 'Tharindu Fernando');
create table book (
bookid serial primary key,
name text,
author text
);
insert into book (name, author) values ('Tasty Cooking', 'Bhagya Ratnayake');
insert into book (name, author) values ('Smiling Kitty', 'Seema Farwin');
create table borrowed_book (
uid integer references user_account(uid) on delete restrict,
bookid integer references book(bookid) on delete restrict,
borrowed_time timestamp
);
|
