aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorDave Whiteland <dave@mysociety.org>2012-07-12 11:50:58 +0100
committerDave Whiteland <dave@mysociety.org>2012-07-12 11:50:58 +0100
commit8c297f3f178dc8e3678ab28d5d686d2ee542d96c (patch)
treec87d2e91fcfc47969b7ee4dfe382dc65298ca8cd /db
parent55751b48ca0cd977bf1d58ed600eff22bf5e8e81 (diff)
changed mm_msg_id to external_source_id, and added external_source col
Diffstat (limited to 'db')
-rw-r--r--db/schema_0021-add_external_source_columns_to_problem.sql8
-rw-r--r--db/schema_0021-add_mm_msg_id_to_problem.sql6
2 files changed, 8 insertions, 6 deletions
diff --git a/db/schema_0021-add_external_source_columns_to_problem.sql b/db/schema_0021-add_external_source_columns_to_problem.sql
new file mode 100644
index 000000000..4105ebb39
--- /dev/null
+++ b/db/schema_0021-add_external_source_columns_to_problem.sql
@@ -0,0 +1,8 @@
+begin;
+
+ALTER table problem
+ ADD column external_source TEXT;
+ALTER table problem
+ ADD column external_source_id INTEGER;
+
+commit;
diff --git a/db/schema_0021-add_mm_msg_id_to_problem.sql b/db/schema_0021-add_mm_msg_id_to_problem.sql
deleted file mode 100644
index 12c981ed3..000000000
--- a/db/schema_0021-add_mm_msg_id_to_problem.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-begin;
-
-ALTER table problem
- ADD column mm_msg_id INTEGER;
-
-commit;