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);
 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, 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, 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_xonkerxid on xonkers(xid);
16create index idx_zonkersname on zonkers(name);
17create index idx_filesxid on files(xid);
18create index idx_filesurl on files(url);
19
20create table config (key text, value text);
21
22create table users (userid integer primary key, username text, hash text, displayname text, about text, pubkey text, seckey text);
23create table auth (authid integer primary key, userid integer, hash text);
24CREATE index idxusers_username on users(username);
25CREATE index idxauth_userid on auth(userid);
26CREATE index idxauth_hash on auth(hash);
27