diff options
author | Matthew Somerville <matthew@mysociety.org> | 2011-06-13 01:35:04 +0100 |
---|---|---|
committer | Matthew Somerville <matthew@mysociety.org> | 2011-06-13 01:35:04 +0100 |
commit | e754a8d985d68daa345e58deddfca9ecb2ba09ba (patch) | |
tree | 97946516c77e37732a470e5eed202e9ddd93ccf6 /db | |
parent | 24a3d1c80caf08719463bee762dd759955683913 (diff) |
Fix a couple of small bugs.
Diffstat (limited to 'db')
-rw-r--r-- | db/schema_0001-add_sessions_and_users_and_dbic_fields.sql | 3 |
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; |