From 23f700258100bfc42c8b07c251f8582399824409 Mon Sep 17 00:00:00 2001
From: Struan Donald <struan@exo.org.uk>
Date: Mon, 26 Mar 2012 17:34:50 +0100
Subject: associated a comment user with a council config

---
 db/schema_0018-add_comment_user_to_open311conf.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 db/schema_0018-add_comment_user_to_open311conf.sql

(limited to 'db/schema_0018-add_comment_user_to_open311conf.sql')

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;
-- 
cgit v1.2.3

