summaryrefslogtreecommitdiffstats
path: root/config/sql/annotations.sql
diff options
context:
space:
mode:
authorsyeopite <70992037+syeopite@users.noreply.github.com>2021-10-03 18:53:35 +0000
committerGitHub <noreply@github.com>2021-10-03 18:53:35 +0000
commit347c189f3f0a1d563f48f1739d742c1f8c8a4b82 (patch)
tree9b66b3ef12bdba4127014447fcbf1599e1181717 /config/sql/annotations.sql
parent81b12b800190c7aa40c18cfb12cd39faae62c3df (diff)
parentffa9e5dfab7a1d7ea84d88007107f9f40295c50a (diff)
downloadinvidious-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/annotations.sql')
-rw-r--r--config/sql/annotations.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/config/sql/annotations.sql b/config/sql/annotations.sql
index 4ea077e7..3705829d 100644
--- a/config/sql/annotations.sql
+++ b/config/sql/annotations.sql
@@ -2,11 +2,11 @@
-- DROP TABLE public.annotations;
-CREATE TABLE public.annotations
+CREATE TABLE IF NOT EXISTS public.annotations
(
id text NOT NULL,
annotations xml,
CONSTRAINT annotations_id_key UNIQUE (id)
);
-GRANT ALL ON TABLE public.annotations TO kemal;
+GRANT ALL ON TABLE public.annotations TO current_user;