Implement SQLite storage #7 (#73)

- new config `:storage-type` (default `:edn`, also support `:sqlite`)
- `LICENSE` change: add exceptions to `next.jdbc` (which uses EPL)

Reviewed-on: https://codeberg.org/eltrac/weepinbell/pulls/73

1 files changed, 32 insertions, 0 deletions

diff --git a/resources/sql/sqlite_init.sql b/resources/sql/sqlite_init.sql
new file mode 100644
index 0000000..012e9c6
--- /dev/null
+++ b/resources/sql/sqlite_init.sql
@@ -0,0 +1,32 @@
+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
+);