Add users table

3 files changed, 37 insertions, 1 deletions

diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql
index e6cb3c8f..98d4d7de 100644
--- a/config/sql/channel_videos.sql
+++ b/config/sql/channel_videos.sql
@@ -18,3 +18,12 @@ WITH (
 TABLESPACE pg_default;
 
 GRANT ALL ON TABLE public.channel_videos TO kemal;
+
+-- Index: channel_videos_published_idx
+
+-- DROP INDEX public.channel_videos_published_idx;
+
+CREATE INDEX channel_videos_published_idx
+    ON public.channel_videos USING btree
+    (published)
+    TABLESPACE pg_default;
\ No newline at end of file
diff --git a/config/sql/channels.sql b/config/sql/channels.sql
index d24329f3..a328bcad 100644
--- a/config/sql/channels.sql
+++ b/config/sql/channels.sql
@@ -6,7 +6,8 @@ CREATE TABLE public.channels
 (
     id text COLLATE pg_catalog."default" NOT NULL,
     author text COLLATE pg_catalog."default",
-    updated timestamp with time zone
+    updated timestamp with time zone,
+    CONSTRAINT channels_id_key UNIQUE (id)
 )
 WITH (
     OIDS = FALSE
@@ -14,3 +15,12 @@ WITH (
 TABLESPACE pg_default;
 
 GRANT ALL ON TABLE public.channels TO kemal;
+
+-- Index: channels_id_idx
+
+-- DROP INDEX public.channels_id_idx;
+
+CREATE INDEX channels_id_idx
+    ON public.channels USING btree
+    (id COLLATE pg_catalog."default")
+    TABLESPACE pg_default;
\ No newline at end of file
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;