diff options
author | Struan Donald <struan@exo.org.uk> | 2011-08-16 10:22:31 +0100 |
---|---|---|
committer | Struan Donald <struan@exo.org.uk> | 2011-08-16 10:22:31 +0100 |
commit | 213948dcc9c281b1873da98e381b25231c376165 (patch) | |
tree | 1d2c2130336ccc0628506010a11ce40de8f7b33d /db | |
parent | 9ecfbd8ddc99fcff5b421f0dfebfb60c2f5a52d4 (diff) |
fix syntax errors
Diffstat (limited to 'db')
-rw-r--r-- | db/schema.sql | 4 |
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); |