| author | Mahlon E. Smith <mahlon@martini.nu> |
| Wed, 28 Sep 2011 09:04:16 -0700 | |
| changeset 7 | e4f1a551d45c |
| parent 4 | 5701b7859a31 |
| child 10 | d07309450285 |
| permissions | -rw-r--r-- |
|
4
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
1 |
BEGIN; |
|
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
2 |
|
|
7
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
3 |
DROP TABLE IF EXISTS rules; |
|
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
4 |
CREATE TABLE rules ( |
|
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
5 |
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
|
6 |
); |
|
4
5701b7859a31
Groundwork for automatic database initialization and schema upgrades.
Mahlon E. Smith <mahlon@laika.com>
parents:
diff
changeset
|
7 |
|
|
7
e4f1a551d45c
Fine tuning for database initialization/upgrades.
Mahlon E. Smith <mahlon@martini.nu>
parents:
4
diff
changeset
|
8 |
COMMIT; |