From 59dfb39e99c603432d4ed83ff000b39433479d47 Mon Sep 17 00:00:00 2001
From: Kamal Wickramanayake <kamal@inbox.lk>
Date: Sun, 26 Apr 2026 08:53:58 +0530
Subject: Added database directory

---
 database/postgresql/01-basics/basic.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 database/postgresql/01-basics/basic.sql

(limited to 'database/postgresql/01-basics/basic.sql')

diff --git a/database/postgresql/01-basics/basic.sql b/database/postgresql/01-basics/basic.sql
new file mode 100644
index 0000000..bbe2bef
--- /dev/null
+++ b/database/postgresql/01-basics/basic.sql
@@ -0,0 +1,12 @@
+create table user_account (
+  uid serial primary key,
+  username text unique not null,
+  name text,
+  password text
+);
+
+insert into user_account (username, name, password) values ('kamal', 'Kamal Wickramanayake', 'e99a18c428cb38d5f260853678922e03');
+
+insert into user_account (username, name, password) values ('kamal2', 'Kamal Wickramanayake', 'e99a18c428cb38d5f260853678922e03');
+
+select * from user_account;
-- 
cgit v1.2.3

