summaryrefslogtreecommitdiffstats
path: root/config/sql/users.sql
diff options
context:
space:
mode:
Diffstat (limited to 'config/sql/users.sql')
-rw-r--r--config/sql/users.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/config/sql/users.sql b/config/sql/users.sql
new file mode 100644
index 00000000..dde3b924
--- /dev/null
+++ b/config/sql/users.sql
@@ -0,0 +1,17 @@
+-- Table: public.users
+
+-- DROP TABLE public.users;
+
+CREATE TABLE public.users
+(
+ id text COLLATE pg_catalog."default" NOT NULL,
+ updated timestamp with time zone,
+ notifications integer,
+ subscriptions text[] COLLATE pg_catalog."default"
+)
+WITH (
+ OIDS = FALSE
+)
+TABLESPACE pg_default;
+
+GRANT ALL ON TABLE public.users TO kemal;