From fb5455828b4ca31355468b4866a80270b3c3e12d Mon Sep 17 00:00:00 2001
From: Kamal Wickramanayake <kamal@inbox.lk>
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/library.sql')

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

