add external id to comments table

2 files changed, 8 insertions, 1 deletions

diff --git a/db/schema.sql b/db/schema.sql
index 395d1c07b..d54cecd5a 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -303,9 +303,10 @@ create table comment (
         or problem_state = 'fixed'
         or problem_state = 'fixed - council'
         or problem_state = 'fixed - user'
-    )
+    ),
     -- other fields? one to indicate whether this was written by the council
     -- and should be highlighted in the display?
+    external_id text
 );
 
 create index comment_user_id_idx on comment(user_id);
diff --git a/db/schema_0013-add_external_id_to_comment.sql b/db/schema_0013-add_external_id_to_comment.sql
new file mode 100644
index 000000000..a1cd11c3f
--- /dev/null
+++ b/db/schema_0013-add_external_id_to_comment.sql
@@ -0,0 +1,6 @@
+begin;
+
+ALTER TABLE comment
+    ADD COLUMN external_id TEXT;
+
+commit;