diff options
| -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); |