aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema_0009-add_extra_to_problem.sql
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2011-07-29 16:31:15 +0100
committerStruan Donald <struan@exo.org.uk>2011-07-29 16:31:15 +0100
commitbb222249d7f836fd27183c2f6b0685191e0100d4 (patch)
tree769c5b13471fb6ae9414ba44269b0850c7c5412c /db/schema_0009-add_extra_to_problem.sql
parentc2f72c17beab89d473e1776aa1662a68dc5e04be (diff)
add extra column to problem for storing addition open311 meta information
Diffstat (limited to 'db/schema_0009-add_extra_to_problem.sql')
-rw-r--r--db/schema_0009-add_extra_to_problem.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/db/schema_0009-add_extra_to_problem.sql b/db/schema_0009-add_extra_to_problem.sql
new file mode 100644
index 000000000..bac5806c7
--- /dev/null
+++ b/db/schema_0009-add_extra_to_problem.sql
@@ -0,0 +1,6 @@
+begin;
+
+ALTER TABLE problem
+ ADD COLUMN extra TEXT;
+
+commit;