storage/h2: fix startup failure when indexes are already created

add "if not exists" condition before creating indexes

1 files changed, 4 insertions, 4 deletions

diff --git a/resources/sql/h2_init.sql b/resources/sql/h2_init.sql
index 475987f..4674842 100644
--- a/resources/sql/h2_init.sql
+++ b/resources/sql/h2_init.sql
@@ -31,10 +31,10 @@ create table if not exists proxied_photo (
     on delete cascade
 );
 
-create index idx_webmention_hash on webmention (hash);
+create index if not exists idx_webmention_hash on webmention (hash);
 
-create index idx_webmention_pair on webmention (wm_source, wm_target);
+create index if not exists idx_webmention_pair on webmention (wm_source, wm_target);
 
-create index idx_webmention_domain on webmention (wm_target_domain);
+create index if not exists idx_webmention_domain on webmention (wm_target_domain);
 
-create index idx_webmention_uri on webmention (wm_target_domain, wm_target_path);
+create index if not exists idx_webmention_uri on webmention (wm_target_domain, wm_target_path);