Sha256: 576cfc2185b3d3fb0bdf0a3ab38047f44f382cd8a2afd24cde03e7d9b6a12e95
Contents?: true
Size: 1.94 KB
Versions: 36
Compression:
Stored size: 1.94 KB
Contents
DROP TABLE IF EXISTS server;
DROP TABLE IF EXISTS host;
DROP TABLE IF EXISTS handler;
DROP TABLE IF EXISTS proxy;
DROP TABLE IF EXISTS route;
DROP TABLE IF EXISTS statistic;
DROP TABLE IF EXISTS mimetype;
DROP TABLE IF EXISTS setting;
DROP TABLE IF EXISTS directory;
DROP TABLE IF EXISTS filter;
CREATE TABLE server (id INTEGER PRIMARY KEY,
uuid TEXT,
access_log TEXT,
error_log TEXT,
chroot TEXT DEFAULT '/var/www',
pid_file TEXT,
default_host TEXT,
name TEXT DEFAULT '',
bind_addr TEXT DEFAULT "0.0.0.0",
port INTEGER,
use_ssl INTEGER default 0);
CREATE TABLE host (id INTEGER PRIMARY KEY,
server_id INTEGER,
maintenance BOOLEAN DEFAULT 0,
name TEXT,
matching TEXT);
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 proxy (id INTEGER PRIMARY KEY,
addr TEXT,
port INTEGER);
CREATE TABLE directory (id INTEGER PRIMARY KEY,
base TEXT,
index_file TEXT,
default_ctype TEXT,
cache_ttl INTEGER DEFAULT 0);
CREATE TABLE route (id INTEGER PRIMARY KEY,
path TEXT,
reversed BOOLEAN DEFAULT 0,
host_id INTEGER,
target_id INTEGER,
target_type TEXT);
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 mimetype (id INTEGER PRIMARY KEY, mimetype TEXT, extension TEXT);
CREATE TABLE filter (id INTEGER PRIMARY KEY,
server_id INTEGER,
name TEXT,
settings TEXT);
CREATE TABLE IF NOT EXISTS log(id INTEGER PRIMARY KEY,
who TEXT,
what TEXT,
location TEXT,
happened_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
how TEXT,
why TEXT);
Version data entries
36 entries across 36 versions & 1 rubygems