add extra column to problem for storing addition open311 meta information

2 files changed, 7 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 );
diff --git a/db/schema_0009-add_extra_to_problem.sql b/db/schema_0009-add_extra_to_problem.sql
new file mode 100644
index 000000000..bac5806c7
--- /dev/null
+++ b/db/schema_0009-add_extra_to_problem.sql
@@ -0,0 +1,6 @@
+begin;
+
+ALTER TABLE problem
+    ADD COLUMN extra TEXT;
+
+commit;