diff options
| author | Struan Donald <struan@exo.org.uk> | 2011-07-29 18:10:50 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2011-07-29 18:10:50 +0100 |
| commit | e7ccf3fe896a9f642306daff9a750f3c9a6b7cdd (patch) | |
| tree | eda3740a18a39a9a32ba9cb96417dba9c4720f04 /db | |
| parent | a9b0f5199b2b028ab33d909f0a4121d368f0bd2f (diff) | |
open311conf id to type serial
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema.sql | 2 | ||||
| -rw-r--r-- | db/schema_0010-add_open311_conf.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/db/schema.sql b/db/schema.sql index d4dbd76de..c3487cdc8 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -391,7 +391,7 @@ create table admin_log ( -- Record open 311 configuration details create table open311conf ( - id integer primary key, + id serial primary key, area_id integer not null unique, endpoint text not null, jurisdiction text, diff --git a/db/schema_0010-add_open311_conf.sql b/db/schema_0010-add_open311_conf.sql index 06667caf0..920272c05 100644 --- a/db/schema_0010-add_open311_conf.sql +++ b/db/schema_0010-add_open311_conf.sql @@ -1,7 +1,7 @@ begin; CREATE TABLE open311conf ( - id INTEGER PRIMARY KEY, + id SERIAL PRIMARY KEY, area_id INTEGER NOT NULL unique, endpoint TEXT NOT NULL, jurisdiction TEXT, |