diff options
author | Santo Cariotti <santo@dcariotti.me> | 2024-08-21 12:29:23 +0200 |
---|---|---|
committer | Santo Cariotti <santo@dcariotti.me> | 2024-08-21 12:29:23 +0200 |
commit | 91bfbd1abeb37ced029afba966a7134d92838baa (patch) | |
tree | dffcbeae78b89a76120ba476aeae4dda95effd61 /schema | |
parent | 185ba5270aaf94de9b91e4455be27db5198ec21e (diff) |
Add users
Query must be something like '{users { id, email, password, isAdmin }}'
Diffstat (limited to 'schema')
-rw-r--r-- | schema/init.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/schema/init.sql b/schema/init.sql new file mode 100644 index 0000000..38d1e80 --- /dev/null +++ b/schema/init.sql @@ -0,0 +1,7 @@ +CREATE TABLE users( + id SERIAL NOT NULL, + email text NOT NULL, + password text NOT NULL, + is_admin boolean default false, + PRIMARY KEY (id) +); |