| author | Mahlon E. Smith <mahlon@laika.com> |
| Mon, 31 Oct 2011 17:17:07 -0700 | |
| changeset 13 | 23a242d7b7fa |
| parent 12 | 191b3c25974a |
| permissions | -rw-r--r-- |
|
10
d07309450285
Get the ragel line parser properly tokenizing the input lines. Add a
Mahlon E. Smith <mahlon@martini.nu>
parents:
7
diff
changeset
|
1 |
--- vim: set noet nosta sw=4 ts=4 ft=sql: |
|
4
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
2 |
BEGIN; |
|
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
3 |
|
|
13
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
4 |
CREATE TABLE IF NOT EXISTS requests ( |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
5 |
scheme VARCHAR(5) DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
6 |
host VARCHAR(255) DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
7 |
tld VARCHAR(255) DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
8 |
path TEXT DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
9 |
port INTEGER DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
10 |
ip VARCHAR(72) DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
11 |
user VARCHAR(40) DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
12 |
method VARCHAR(10) DEFAULT NULL, |
|
12
191b3c25974a
Clean up redundant parser actions via preprocessor macros, add a
Mahlon E. Smith <mahlon@martini.nu>
parents:
10
diff
changeset
|
13 |
rewrite_rule INTEGER REFERENCES rewrite_rules( id ) ON DELETE SET NULL ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED |
|
191b3c25974a
Clean up redundant parser actions via preprocessor macros, add a
Mahlon E. Smith <mahlon@martini.nu>
parents:
10
diff
changeset
|
14 |
); |
|
13
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
15 |
CREATE INDEX IF NOT EXISTS host_idx ON requests ( host ); |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
16 |
CREATE INDEX IF NOT EXISTS tld_idx ON requests ( tld ); |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
17 |
CREATE INDEX IF NOT EXISTS path_idx ON requests ( path ); |
|
12
191b3c25974a
Clean up redundant parser actions via preprocessor macros, add a
Mahlon E. Smith <mahlon@martini.nu>
parents:
10
diff
changeset
|
18 |
|
|
13
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
19 |
CREATE TABLE IF NOT EXISTS rewrite_rules ( |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
20 |
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
21 |
scheme VARCHAR(5) DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
22 |
host VARCHAR(255) DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
23 |
path TEXT DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
24 |
port INTEGER DEFAULT NULL, |
|
23a242d7b7fa
1st iteration of volta actually doing something. Process the request,
Mahlon E. Smith <mahlon@laika.com>
parents:
12
diff
changeset
|
25 |
redir TINYINT NOT NULL DEFAULT 0 CHECK( redir IN (0,1,2) ) |
|
7
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
26 |
); |
|
4
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
27 |
|
|
7
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
28 |
COMMIT; |