add in extra field to contacts for storing open311 meta data

2 files changed, 9 insertions, 0 deletions

diff --git a/db/schema.sql b/db/schema.sql
index c3487cdc8..3ec3c6756 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -79,6 +79,9 @@ create table contacts (
     whenedited timestamp not null, 
     -- what the last change was for: author's notes
     note text not null
+
+    -- extra fields required for open311
+    extra text
 );
 create unique index contacts_area_id_category_idx on contacts(area_id, category);
 
diff --git a/db/schema_0011-add_extra_to_contacts.sql b/db/schema_0011-add_extra_to_contacts.sql
new file mode 100644
index 000000000..fd6eae807
--- /dev/null
+++ b/db/schema_0011-add_extra_to_contacts.sql
@@ -0,0 +1,6 @@
+begin;
+
+ALTER TABLE contacts
+    ADD COLUMN extra TEXT;
+
+commit;