aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql3
1 files changed, 2 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);