aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2011-08-16 10:22:31 +0100
committerStruan Donald <struan@exo.org.uk>2011-08-16 10:22:31 +0100
commit213948dcc9c281b1873da98e381b25231c376165 (patch)
tree1d2c2130336ccc0628506010a11ce40de8f7b33d /db
parent9ecfbd8ddc99fcff5b421f0dfebfb60c2f5a52d4 (diff)
fix syntax errors
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/db/schema.sql b/db/schema.sql
index 3ec3c6756..e9dff0f84 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -78,7 +78,7 @@ create table contacts (
-- time of last change
whenedited timestamp not null,
-- what the last change was for: author's notes
- note text not null
+ note text not null,
-- extra fields required for open311
extra text
@@ -178,7 +178,7 @@ create table problem (
cobrand_data text not null default '' check (cobrand_data ~* '^[a-z0-9]*$'), -- Extra data used in cobranded versions of the site
lastupdate timestamp not null default ms_current_timestamp(),
whensent timestamp,
- send_questionnaire boolean not null default 't'
+ send_questionnaire boolean not null default 't',
extra text -- extra fields required for open311
);
create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude);