summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--project.clj2
-rw-r--r--resources/sql/h2_init.sql8
2 files changed, 5 insertions, 5 deletions
diff --git a/project.clj b/project.clj
index 0ec358b..5b46a17 100644
--- a/project.clj
+++ b/project.clj
@@ -1,4 +1,4 @@
-(defproject weepinbell "v1.0.0-818b2d0"
+(defproject weepinbell "v1.0.0-fcfdb21"
:description "A Webmention receiver written in Clojure."
:url "https://codeberg.org/eltrac/weepinbell"
:license {:name "GNU Affero General Public License"
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);