summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
Diffstat (limited to 'schema')
-rw-r--r--schema/init.sql7
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)
+);