diff options
Diffstat (limited to 'resources/sql/sqlite_init.sql')
| -rw-r--r-- | resources/sql/sqlite_init.sql | 32 |
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 -); |
