diff options
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; |