storage: migrate from SQLite to H2

add ADR-0002 about migrating to H2

1 files changed, 0 insertions, 32 deletions

diff --git a/resources/sql/sqlite_init.sql b/resources/sql/sqlite_init.sql
deleted file mode 100644
index 012e9c6..0000000
--- a/resources/sql/sqlite_init.sql
+++ /dev/null
@@ -1,32 +0,0 @@
-create table if not exists webmention (
-  id integer primary key autoincrement,
-  hash text not null unique,
-  wm_source text not null,
-  wm_target text not null,
-  wm_source_domain text not null,
-  wm_target_domain text not null,
-  wm_source_path text not null,
-  wm_target_path text not null,
-  lastmod integer not null
-);
-
-create table if not exists microformats (
-  id integer primary key autoincrement,
-  wm_id integer not null,
-  mf_type text not null,
-  mf_data text not null, /* schema on read, store EDN string here */
-
-  FOREIGN KEY (wm_id)
-    references webmention(id)
-    on delete cascade
-);
-
-create table if not exists proxied_photo (
-  id integer primary key autoincrement,
-  wm_id integer not null,
-  url text not null,
-
-  FOREIGN KEY (wm_id)
-    references webmention(id)
-    on delete cascade
-);