From ffa9e5dfab7a1d7ea84d88007107f9f40295c50a Mon Sep 17 00:00:00 2001
From: Andre Borie <hi@rjevski.io>
Date: Sun, 17 Jan 2021 01:44:31 +0000
Subject: Make migrations (mostly) idempotent.

---
 config/sql/annotations.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'config/sql/annotations.sql')

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;
-- 
cgit v1.2.3

