2 files changed, 22 insertions, 12 deletions
diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql
new file mode 100644
index 00000000..e6cb3c8f
--- /dev/null
+++ b/config/sql/channel_videos.sql
@@ -0,0 +1,20 @@
+-- Table: public.channel_videos
+
+-- DROP TABLE public.channel_videos;
+
+CREATE TABLE public.channel_videos
+(
+    id text COLLATE pg_catalog."default" NOT NULL,
+    title text COLLATE pg_catalog."default",
+    published timestamp with time zone,
+    updated timestamp with time zone,
+    ucid text COLLATE pg_catalog."default",
+    author text COLLATE pg_catalog."default",
+    CONSTRAINT channel_videos_id_key UNIQUE (id)
+)
+WITH (
+    OIDS = FALSE
+)
+TABLESPACE pg_default;
+
+GRANT ALL ON TABLE public.channel_videos TO kemal;
diff --git a/config/sql/channels.sql b/config/sql/channels.sql
index a908c785..d24329f3 100644
--- a/config/sql/channels.sql
+++ b/config/sql/channels.sql
@@ -5,9 +5,8 @@
 CREATE TABLE public.channels
 (
     id text COLLATE pg_catalog."default" NOT NULL,
-    rss text COLLATE pg_catalog."default",
-    updated timestamp with time zone,
-    author text COLLATE pg_catalog."default"
+    author text COLLATE pg_catalog."default",
+    updated timestamp with time zone
 )
 WITH (
     OIDS = FALSE
@@ -15,12 +14,3 @@ WITH (
 TABLESPACE pg_default;
 
 GRANT ALL ON TABLE public.channels TO kemal;
-
--- Index: channel_id_idx
-
--- DROP INDEX public.channel_id_idx;
-
-CREATE UNIQUE INDEX channel_id_idx
-    ON public.channels USING btree
-    (id COLLATE pg_catalog."default")
-    TABLESPACE pg_default;
-\ No newline at end of file