this repo has no description
1-- Add up migration script here
2
3CREATE TABLE feed_content (
4 feed_id TEXT NOT NULL,
5 uri TEXT NOT NULL,
6 indexed_at INTEGER NOT NULL,
7 cid TEXT NOT NULL,
8 updated_at DATETIME NOT NULL DEFAULT (datetime('now')),
9 PRIMARY KEY (feed_id, uri)
10);
11
12CREATE INDEX feed_content_idx_feed ON feed_content(feed_id, indexed_at DESC, cid DESC);
13
14CREATE TABLE consumer_control (
15 source TEXT NOT NULL,
16 time_us INTEGER NOT NULL,
17 updated_at DATETIME NOT NULL DEFAULT (datetime('now')),
18 PRIMARY KEY (source)
19);
20
21CREATE TABLE verification_method_cache (
22 did TEXT NOT NULL,
23 multikey TEXT NOT NULL,
24 updated_at DATETIME NOT NULL DEFAULT (datetime('now')),
25 PRIMARY KEY (did)
26);