1package main
 2
 3var sqlSchema = `
 4
 5create 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);
 6create table donks (honkid integer, fileid integer);
 7create table filemeta (fileid integer primary key, xid text, name text, description text, url text, media text, local integer);
 8create table honkers (honkerid integer primary key, userid integer, name text, xid text, flavor text, combos text, owner text);
 9create table xonkers (xonkerid integer primary key, name text, info text, flavor text);
10create table zonkers (zonkerid integer primary key, userid integer, name text, wherefore text);
11create table doovers(dooverid integer primary key, dt text, tries integer, userid integer, rcpt text, msg blob);
12create table onts (ontology text, honkid integer);
13create table honkmeta (honkid integer, genus text, json text);
14create table hfcs (hfcsid integer primary key, userid integer, json text);
15
16create index idx_honksxid on honks(xid);
17create index idx_honksconvoy on honks(convoy);
18create index idx_honkshonker on honks(honker);
19create index idx_honksoonker on honks(oonker);
20create index idx_honkerxid on honkers(xid);
21create index idx_xonkername on xonkers(name);
22create index idx_zonkersname on zonkers(name);
23create index idx_filesxid on filemeta(xid);
24create index idx_filesurl on filemeta(url);
25create index idx_ontology on onts(ontology);
26create index idx_onthonkid on onts(honkid);
27create index idx_honkmetaid on honkmeta(honkid);
28create index idx_hfcsuser on hfcs(userid);
29
30create table config (key text, value text);
31
32create table users (userid integer primary key, username text, hash text, displayname text, about text, pubkey text, seckey text, options text);
33create table auth (authid integer primary key, userid integer, hash text, expiry text);
34CREATE index idxusers_username on users(username);
35CREATE index idxauth_userid on auth(userid);
36CREATE index idxauth_hash on auth(hash);
37
38`