diff options
Diffstat (limited to 'database')
| -rw-r--r-- | database/postgresql/01-basics/basic.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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; |