summaryrefslogtreecommitdiff
path: root/resources/sql/sqlite_init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'resources/sql/sqlite_init.sql')
-rw-r--r--resources/sql/sqlite_init.sql32
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
-);