| author | Mahlon E. Smith <mahlon@martini.nu> |
| Mon, 17 Oct 2011 09:12:00 -0700 | |
| changeset 10 | d07309450285 |
| parent 7 | e4f1a551d45c |
| child 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: |
|
d07309450285
Get the ragel line parser properly tokenizing the input lines. Add a
Mahlon E. Smith <mahlon@martini.nu>
parents:
7
diff
changeset
|
2 |
|
|
4
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
3 |
BEGIN; |
|
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
4 |
|
|
7
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
5 |
DROP TABLE IF EXISTS rules; |
|
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
6 |
CREATE TABLE rules ( |
|
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
7 |
redir TINYINT NOT NULL DEFAULT 0 CHECK( redir IN (0,1,2) ) |
|
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
8 |
); |
|
4
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
9 |
|
|
7
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
10 |
COMMIT; |