CREATE TABLE directory (id INTEGER PRIMARY KEY, base TEXT, index_file TEXT, default_ctype TEXT, cache_ttl INTEGER DEFAULT 0); CREATE TABLE handler (id INTEGER PRIMARY KEY,

 send_spec TEXT, 
 send_ident TEXT,
 recv_spec TEXT,
 recv_ident TEXT,
raw_payload INTEGER DEFAULT 0,
protocol TEXT DEFAULT 'json');

CREATE TABLE host (id INTEGER PRIMARY KEY,

server_id INTEGER,
maintenance BOOLEAN DEFAULT 0,
name TEXT,
matching TEXT);

CREATE TABLE log(id INTEGER PRIMARY KEY,

who TEXT,
what TEXT,
location TEXT,
happened_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
how TEXT,
why TEXT);

CREATE TABLE mimetype (id INTEGER PRIMARY KEY, mimetype TEXT, extension TEXT); CREATE TABLE proxy (id INTEGER PRIMARY KEY,

addr TEXT,
port INTEGER);

CREATE TABLE route (id INTEGER PRIMARY KEY,

path TEXT,
reversed BOOLEAN DEFAULT 0,
host_id INTEGER,
target_id INTEGER,
target_type TEXT);

CREATE TABLE server (id INTEGER PRIMARY KEY,

uuid TEXT,
access_log TEXT,
error_log TEXT,
chroot TEXT DEFAULT '/var/www',
pid_file TEXT,
control_port TEXT DEFAULT "",
default_host TEXT,
name TEXT DEFAULT '',
bind_addr TEXT DEFAULT "0.0.0.0",
port INTEGER,
use_ssl INTEGER default 0);

CREATE TABLE setting (id INTEGER PRIMARY KEY, key TEXT, value TEXT); CREATE TABLE statistic (id SERIAL,

other_type TEXT,
other_id INTEGER,
name text,
sum REAL,
sumsq REAL,
n INTEGER,
min REAL,
max REAL,
mean REAL,
sd REAL,
primary key (other_type, other_id, name));

CREATE TABLE filter (id INTEGER PRIMARY KEY,

server_id INTEGER,
name TEXT,
settings TEXT);