diff options
| author | syeopite <70992037+syeopite@users.noreply.github.com> | 2021-10-03 18:53:35 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-03 18:53:35 +0000 |
| commit | 347c189f3f0a1d563f48f1739d742c1f8c8a4b82 (patch) | |
| tree | 9b66b3ef12bdba4127014447fcbf1599e1181717 /config/sql/session_ids.sql | |
| parent | 81b12b800190c7aa40c18cfb12cd39faae62c3df (diff) | |
| parent | ffa9e5dfab7a1d7ea84d88007107f9f40295c50a (diff) | |
| download | invidious-347c189f3f0a1d563f48f1739d742c1f8c8a4b82.tar.gz invidious-347c189f3f0a1d563f48f1739d742c1f8c8a4b82.tar.bz2 invidious-347c189f3f0a1d563f48f1739d742c1f8c8a4b82.zip | |
Merge pull request #1678 from Rjevski/idempotent-database-migrations
Make DB migrations idempotent.
Diffstat (limited to 'config/sql/session_ids.sql')
| -rw-r--r-- | config/sql/session_ids.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/config/sql/session_ids.sql b/config/sql/session_ids.sql index afbabb67..c493769a 100644 --- a/config/sql/session_ids.sql +++ b/config/sql/session_ids.sql @@ -2,7 +2,7 @@ -- DROP TABLE public.session_ids; -CREATE TABLE public.session_ids +CREATE TABLE IF NOT EXISTS public.session_ids ( id text NOT NULL, email text, @@ -10,13 +10,13 @@ CREATE TABLE public.session_ids CONSTRAINT session_ids_pkey PRIMARY KEY (id) ); -GRANT ALL ON TABLE public.session_ids TO kemal; +GRANT ALL ON TABLE public.session_ids TO current_user; -- Index: public.session_ids_id_idx -- DROP INDEX public.session_ids_id_idx; -CREATE INDEX session_ids_id_idx +CREATE INDEX IF NOT EXISTS session_ids_id_idx ON public.session_ids USING btree (id COLLATE pg_catalog."default"); |