From 3646395f1d8b200ebd33f3c0b65ad6bbaf0c7156 Mon Sep 17 00:00:00 2001
From: Omar Roth <omarroth@hotmail.com>
Date: Sun, 10 Feb 2019 12:33:29 -0600
Subject: Store session_ids in separate table

---
 config/sql/session_ids.sql | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)
 create mode 100644 config/sql/session_ids.sql

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

diff --git a/config/sql/session_ids.sql b/config/sql/session_ids.sql
new file mode 100644
index 00000000..24491405
--- /dev/null
+++ b/config/sql/session_ids.sql
@@ -0,0 +1,24 @@
+-- Table: public.session_ids
+
+-- DROP TABLE public.session_ids;
+
+CREATE TABLE public.session_ids
+(
+  id text NOT NULL,
+  email text,
+  issued timestamp with time zone,
+  CONSTRAINT session_ids_pkey PRIMARY KEY (id)
+);
+
+GRANT ALL ON TABLE public.channel_videos TO kemal;
+
+-- Index: public.session_ids_id_idx
+
+-- DROP INDEX public.session_ids_id_idx;
+
+CREATE INDEX session_ids_id_idx
+  ON public.session_ids
+  USING btree
+  (id COLLATE pg_catalog."default");
+
+  
\ No newline at end of file
-- 
cgit v1.2.3

