25 lines
436 B
SQL
25 lines
436 B
SQL
PRAGMA journal_mode=WAL;
|
|
|
|
create table if not exists feeds (
|
|
feed_id blob primary key,
|
|
uri text,
|
|
nick text,
|
|
last_scan_on timestamp,
|
|
refresh_rate int default 600,
|
|
last_modified_on timestamp,
|
|
last_etag text,
|
|
last_error text
|
|
);
|
|
|
|
create table if not exists twts (
|
|
feed_id blob,
|
|
hash text,
|
|
conv text,
|
|
dt text, -- timestamp with timezone
|
|
text text,
|
|
mentions text, -- json
|
|
tags text, -- json
|
|
primary key (feed_id, hash)
|
|
);
|
|
|