From 871ea1569fc1dc5900e3b8233fc9aede8245f15f Mon Sep 17 00:00:00 2001 From: eltrac Date: Fri, 23 Oct 2026 14:38:14 +0800 Subject: storage: migrate from SQLite to H2 add ADR-0002 about migrating to H2 --- resources/sql/sqlite_init.sql | 32 -------------------------------- 1 file changed, 32 deletions(-) delete mode 100644 resources/sql/sqlite_init.sql (limited to 'resources/sql/sqlite_init.sql') 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 -); -- cgit v1.2.3