diff options
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, |