diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql new file mode 100644 index 0000000..a2a74b1 --- /dev/null +++ b/schema.sql @@ -0,0 +1,10 @@ +CREATE TABLE sessions( + created_at timestamp DEFAULT now(), + session_id uuid DEFAULT gen_random_uuid(), + user_id integer REFERENCES users(id) +); + +CREATE TABLE users( + id integer PRIMARY KEY serial, + user_name text + password text); |
