From 908543dd620a8fb8f5a2d1a58ce82b83e3aafe12 Mon Sep 17 00:00:00 2001
From: Omar Roth <omarroth@hotmail.com>
Date: Sat, 24 Mar 2018 22:44:17 -0500
Subject: Add channel sql

---
 config/sql/channels.sql | 26 ++++++++++++++++++++++++++
 config/sql/videos.sql   | 34 ++++++++++++++++++++++++++++++++++
 setup.sh                |  3 ++-
 videos.sql              | 30 ------------------------------
 4 files changed, 62 insertions(+), 31 deletions(-)
 create mode 100644 config/sql/channels.sql
 create mode 100644 config/sql/videos.sql
 delete mode 100644 videos.sql

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/config/sql/videos.sql b/config/sql/videos.sql
new file mode 100644
index 00000000..2fb52946
--- /dev/null
+++ b/config/sql/videos.sql
@@ -0,0 +1,34 @@
+-- Table: public.videos
+
+-- DROP TABLE public.videos;
+
+CREATE TABLE public.videos
+(
+    id text COLLATE pg_catalog."default" NOT NULL,
+    info text COLLATE pg_catalog."default",
+    updated timestamp with time zone,
+    title text COLLATE pg_catalog."default",
+    views bigint,
+    likes integer,
+    dislikes integer,
+    wilson_score double precision,
+    published timestamp with time zone,
+    description text COLLATE pg_catalog."default",
+    language text COLLATE pg_catalog."default",
+    CONSTRAINT videos_pkey PRIMARY KEY (id)
+)
+WITH (
+    OIDS = FALSE
+)
+TABLESPACE pg_default;
+
+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")
+    TABLESPACE pg_default;
\ No newline at end of file
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
diff --git a/videos.sql b/videos.sql
deleted file mode 100644
index 444de280..00000000
--- a/videos.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- Table: public.videos
-
-CREATE TABLE public.videos
-(
-    id text COLLATE pg_catalog."default" NOT NULL,
-    info text COLLATE pg_catalog."default",
-    updated timestamp with time zone,
-    title text COLLATE pg_catalog."default",
-    views bigint,
-    likes integer,
-    dislikes integer,
-    wilson_score double precision,
-    published timestamp with time zone,
-    description text COLLATE pg_catalog."default",
-    language text COLLATE pg_catalog."default",
-    CONSTRAINT videos_pkey PRIMARY KEY (id)
-)
-WITH (
-    OIDS = FALSE
-)
-TABLESPACE pg_default;
-
-GRANT ALL ON TABLE public.videos TO kemal;
-
--- Index: id_idx
-
-CREATE UNIQUE INDEX id_idx
-    ON public.videos USING btree
-    (id COLLATE pg_catalog."default")
-    TABLESPACE pg_default;
\ No newline at end of file
-- 
cgit v1.2.3