From 59dfb39e99c603432d4ed83ff000b39433479d47 Mon Sep 17 00:00:00 2001 From: Kamal Wickramanayake 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') 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