aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/db/schema.sql b/db/schema.sql
index 9c5b3d8fd..37ffddd51 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -176,6 +176,7 @@ create table problem (
lastupdate timestamp not null default ms_current_timestamp(),
whensent timestamp,
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);
create index problem_user_id_idx on problem ( user_id );