diff options
| author | Guillaume Horel <guillaume.horel@gmail.com> | 2018-12-27 13:15:16 -0500 |
|---|---|---|
| committer | Guillaume Horel <guillaume.horel@gmail.com> | 2018-12-28 06:05:03 -0500 |
| commit | b8b80e0a896433bed8eb331aff3ecd12e00fd4ba (patch) | |
| tree | 248d77473f978786b7252918289dcf2834789c44 /schema.sql | |
| parent | b3ae0e1eeb517c06c5817b9921f76cbaaa62c036 (diff) | |
| download | id-b8b80e0a896433bed8eb331aff3ecd12e00fd4ba.tar.gz | |
add schema
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); |