1
 2create 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);
 3create table donks (honkid integer, fileid integer);
 4create table files(fileid integer primary key, xid text, name text, url text, media text, content blob);
 5create table honkers (honkerid integer primary key, userid integer, name text, xid text, flavor text, combos text, pubkey text);
 6create table xonkers (xonkerid integer primary key, xid text, ibox text, obox text, sbox text, pubkey 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, username text, rcpt text, msg blob);
 9
10create index idx_honksxid on honks(xid);
11create index idx_honksconvoy on honks(convoy);
12create index idx_honkshonker on honks(honker);
13create index idx_honkerxid on honkers(xid);
14create index idx_xonkerxid on xonkers(xid);
15create index idx_zonkersname on zonkers(name);
16create index idx_filesxid on files(xid);
17create index idx_filesurl on files(url);
18
19create table config (key text, value text);
20
21create table users (userid integer primary key, username text, hash text, displayname text, about text, pubkey text, seckey text);
22create table auth (authid integer primary key, userid integer, hash text);
23CREATE index idxusers_username on users(username);
24CREATE index idxauth_userid on auth(userid);
25CREATE index idxauth_hash on auth(hash);
26