1create table honks (honkid integer primary key, userid integer, what text, honker text, xid text, rid text, dt text, url text, audience text, noise text, convoy text, whofore integer, format text, precis text, oonker text, flags integer, plain text);
 2create table chonks (chonkid integer primary key, userid integer, xid text, who txt, target text, dt text, noise text, format text);
 3create table donks (honkid integer, chonkid integer, fileid integer);
 4create table filemeta (fileid integer primary key, xid text, name text, description text, url text, media text, local integer, meta text);
 5create table honkers (honkerid integer primary key, userid integer, name text, xid text, flavor text, combos text, owner text, meta text, folxid text);
 6create table xonkers (xonkerid integer primary key, name text, info text, flavor text, dt text);
 7create table zonkers (zonkerid integer primary key, userid integer, name text, wherefore text);
 8create table doovers(dooverid integer primary key, dt text, tries integer, userid integer, rcpt text, msg blob);
 9create table onts (ontology text, honkid integer);
10create table honkmeta (honkid integer, genus text, json text);
11create table hfcs (hfcsid integer primary key, userid integer, json text);
12create table tracks (xid text, fetches text);
13create table masto (clientname text, redirecturis text, scopes text, clientid text, clientsecret text, vapidkey text, authtoken text);
14create table mastokens (clientid text, accesstoken text)
15
16create index idx_honksxid on honks(xid);
17create index idx_honksurl on honks(url);
18create index idx_honksrid on honks(rid) where rid <> '';
19create index idx_honksconvoy on honks(convoy);
20create index idx_honkshonker on honks(honker);
21create index idx_honksoonker on honks(oonker);
22create index idx_honksforme on honks(whofore) where whofore = 1;
23create index idx_honkswhotwo on honks(whofore) where whofore = 2;
24create index idx_donkshonk on donks(honkid);
25create index idx_donkschonk on donks(chonkid);
26create index idx_honkerxid on honkers(xid);
27create index idx_xonkername on xonkers(name);
28create index idx_zonkersname on zonkers(name);
29create index idx_filesxid on filemeta(xid);
30create index idx_filesurl on filemeta(url);
31create index idx_ontology on onts(ontology);
32create index idx_onthonkid on onts(honkid);
33create index idx_honkmetaid on honkmeta(honkid);
34create index idx_hfcsuser on hfcs(userid);
35create index idx_trackhonkid on tracks(xid);
36
37create table config (key text, value text);
38
39create table users (userid integer primary key, username text, hash text, displayname text, about text, pubkey text, seckey text, options text);
40create table auth (authid integer primary key, userid integer, hash text, expiry text);
41CREATE index idxusers_username on users(username);
42CREATE index idxauth_userid on auth(userid);
43CREATE index idxauth_hash on auth(hash);
44