aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema_0010-add_open311_conf.sql
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2011-07-29 18:10:50 +0100
committerStruan Donald <struan@exo.org.uk>2011-07-29 18:10:50 +0100
commite7ccf3fe896a9f642306daff9a750f3c9a6b7cdd (patch)
treeeda3740a18a39a9a32ba9cb96417dba9c4720f04 /db/schema_0010-add_open311_conf.sql
parenta9b0f5199b2b028ab33d909f0a4121d368f0bd2f (diff)
open311conf id to type serial
Diffstat (limited to 'db/schema_0010-add_open311_conf.sql')
-rw-r--r--db/schema_0010-add_open311_conf.sql2
1 files changed, 1 insertions, 1 deletions
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,