diff options
| author | Struan Donald <struan@exo.org.uk> | 2011-07-29 17:53:10 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2011-07-29 17:53:10 +0100 |
| commit | a9b0f5199b2b028ab33d909f0a4121d368f0bd2f (patch) | |
| tree | 0df9b3216cd96a9190b22b8850ccaf0e2e8a7b01 /db/schema_0010-add_open311_conf.sql | |
| parent | 2fb1d662ebc31eb54f129609899770c2811072eb (diff) | |
add in table to store configuration of councils using open311
Diffstat (limited to 'db/schema_0010-add_open311_conf.sql')
| -rw-r--r-- | db/schema_0010-add_open311_conf.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/db/schema_0010-add_open311_conf.sql b/db/schema_0010-add_open311_conf.sql new file mode 100644 index 000000000..06667caf0 --- /dev/null +++ b/db/schema_0010-add_open311_conf.sql @@ -0,0 +1,11 @@ +begin; + +CREATE TABLE open311conf ( + id INTEGER PRIMARY KEY, + area_id INTEGER NOT NULL unique, + endpoint TEXT NOT NULL, + jurisdiction TEXT, + api_key TEXT +); + +commit; |