diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema.sql | 3 | ||||
| -rw-r--r-- | db/schema_0018-add_comment_user_to_open311conf.sql | 6 |
2 files changed, 8 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index 74b2eade6..169939315 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -432,5 +432,6 @@ create table open311conf ( jurisdiction text, api_key text, send_method text, - send_comments boolean not null default 'f' + send_comments boolean not null default 'f', + comment_user_id int references users(id) ); diff --git a/db/schema_0018-add_comment_user_to_open311conf.sql b/db/schema_0018-add_comment_user_to_open311conf.sql new file mode 100644 index 000000000..93851e2a3 --- /dev/null +++ b/db/schema_0018-add_comment_user_to_open311conf.sql @@ -0,0 +1,6 @@ +begin; + +ALTER TABLE open311conf + ADD COLUMN comment_user_id INT REFERENCES users(id); + +commit; |