From fb5455828b4ca31355468b4866a80270b3c3e12d Mon Sep 17 00:00:00 2001 From: Kamal Wickramanayake Date: Sun, 26 Apr 2026 11:44:44 +0530 Subject: Added library.sql --- database/postgresql/02-library/library.sql | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 database/postgresql/02-library/library.sql (limited to 'database/postgresql/02-library') diff --git a/database/postgresql/02-library/library.sql b/database/postgresql/02-library/library.sql new file mode 100644 index 0000000..b104fbe --- /dev/null +++ b/database/postgresql/02-library/library.sql @@ -0,0 +1,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 +); -- cgit v1.2.3