aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@mysociety.org>2011-06-13 01:35:04 +0100
committerMatthew Somerville <matthew@mysociety.org>2011-06-13 01:35:04 +0100
commite754a8d985d68daa345e58deddfca9ecb2ba09ba (patch)
tree97946516c77e37732a470e5eed202e9ddd93ccf6 /db
parent24a3d1c80caf08719463bee762dd759955683913 (diff)
Fix a couple of small bugs.
Diffstat (limited to 'db')
-rw-r--r--db/schema_0001-add_sessions_and_users_and_dbic_fields.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql b/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
index 581741fe8..b22ab7dfe 100644
--- a/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
+++ b/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
@@ -33,6 +33,9 @@ update contacts_history
and contacts_history.area_id = contacts.area_id
);
+-- Note any categories that have been deleted will cause the following
+-- line to fail, and they'll need to be deleted manually first.
+
AlTER TABLE contacts_history
alter COLUMN contact_id SET NOT NULL;