Add channel sql

3 files changed, 32 insertions, 1 deletions

diff --git a/config/sql/channels.sql b/config/sql/channels.sql
new file mode 100644
index 00000000..a908c785
--- /dev/null
+++ b/config/sql/channels.sql
@@ -0,0 +1,26 @@
+-- Table: public.channels
+
+-- DROP TABLE public.channels;
+
+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"
+)
+WITH (
+    OIDS = FALSE
+)
+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
diff --git a/videos.sql b/config/sql/videos.sql
index 444de280..2fb52946 100644
--- a/videos.sql
+++ b/config/sql/videos.sql
@@ -1,5 +1,7 @@
 -- Table: public.videos
 
+-- DROP TABLE public.videos;
+
 CREATE TABLE public.videos
 (
     id text COLLATE pg_catalog."default" NOT NULL,
@@ -24,6 +26,8 @@ GRANT ALL ON TABLE public.videos TO kemal;
 
 -- Index: id_idx
 
+-- DROP INDEX public.id_idx;
+
 CREATE UNIQUE INDEX id_idx
     ON public.videos USING btree
     (id COLLATE pg_catalog."default")
diff --git a/setup.sh b/setup.sh
index a5ffeee8..333312d0 100755
--- a/setup.sh
+++ b/setup.sh
@@ -2,4 +2,5 @@
 
 createdb invidious
 createuser kemal
-psql invidious < videos.sql
+psql invidious < config/sql/channels.sql
+psql invidious < config/sql/videos.sql