From 3646395f1d8b200ebd33f3c0b65ad6bbaf0c7156 Mon Sep 17 00:00:00 2001 From: Omar Roth 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