From 6c4cfbe39dc90c2014ae0755fe1a2bfaa255dbe6 Mon Sep 17 00:00:00 2001
From: Omar Roth <omarroth@hotmail.com>
Date: Thu, 29 Mar 2018 21:41:05 -0500
Subject: Add users table

---
 config/sql/channels.sql | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'config/sql/channels.sql')

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
-- 
cgit v1.2.3

