aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema_0018-add_comment_user_to_open311conf.sql
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2012-03-26 17:34:50 +0100
committerStruan Donald <struan@exo.org.uk>2012-03-26 17:34:50 +0100
commit23f700258100bfc42c8b07c251f8582399824409 (patch)
tree600fb44e616080335fea1ab6491d4c5232172241 /db/schema_0018-add_comment_user_to_open311conf.sql
parent592149f0659620ddc0fd6ae4ccdea10b9598739b (diff)
associated a comment user with a council config
Diffstat (limited to 'db/schema_0018-add_comment_user_to_open311conf.sql')
-rw-r--r--db/schema_0018-add_comment_user_to_open311conf.sql6
1 files changed, 6 insertions, 0 deletions
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;