diff options
| author | Andre Borie <hi@rjevski.io> | 2021-01-17 01:44:31 +0000 |
|---|---|---|
| committer | Andre Borie <hi@rjevski.io> | 2021-01-17 14:20:34 +0000 |
| commit | ffa9e5dfab7a1d7ea84d88007107f9f40295c50a (patch) | |
| tree | 5dac9a812f2b1001d1e7d13680979dd95680caa0 /config/sql/annotations.sql | |
| parent | c7e65ce795df7858ed1cdb161e3c40165f80e0ac (diff) | |
| download | invidious-ffa9e5dfab7a1d7ea84d88007107f9f40295c50a.tar.gz invidious-ffa9e5dfab7a1d7ea84d88007107f9f40295c50a.tar.bz2 invidious-ffa9e5dfab7a1d7ea84d88007107f9f40295c50a.zip | |
Make migrations (mostly) idempotent.
Diffstat (limited to 'config/sql/annotations.sql')
| -rw-r--r-- | config/sql/annotations.sql | 4 |
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; |