invidious/config/sql/session_ids.sql

24 lines
490 B
MySQL
Raw Permalink Normal View History

2019-02-10 18:33:29 +00:00
-- Table: public.session_ids
-- DROP TABLE public.session_ids;
2021-01-17 01:44:31 +00:00
CREATE TABLE IF NOT EXISTS public.session_ids
2019-02-10 18:33:29 +00:00
(
id text NOT NULL,
email text,
issued timestamp with time zone,
CONSTRAINT session_ids_pkey PRIMARY KEY (id)
);
2021-01-17 01:44:31 +00:00
GRANT ALL ON TABLE public.session_ids TO current_user;
2019-02-10 18:33:29 +00:00
-- Index: public.session_ids_id_idx
-- DROP INDEX public.session_ids_id_idx;
2021-01-17 01:44:31 +00:00
CREATE INDEX IF NOT EXISTS session_ids_id_idx
2019-02-10 18:33:29 +00:00
ON public.session_ids
USING btree
(id COLLATE pg_catalog."default");