aboutsummaryrefslogtreecommitdiffstats
path: root/bin/update-schema
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@mysociety.org>2020-02-17 17:43:54 +0000
committerMatthew Somerville <matthew@mysociety.org>2020-02-26 11:40:15 +0000
commit18adbe946c1104338e6abff159b4f9877154969c (patch)
tree5bae6c894981d3d90724f75c241c9d1e4c848dc2 /bin/update-schema
parent97133a07a181e6cccc207cc6598a08e8028ad7ca (diff)
Add a new "staff" contact state.
This state will appear when reporting if you are logged in as a staff member of the relevant body, but otherwise not appear on the site.
Diffstat (limited to 'bin/update-schema')
-rwxr-xr-xbin/update-schema1
1 files changed, 1 insertions, 0 deletions
diff --git a/bin/update-schema b/bin/update-schema
index 7941bc542..8f31085c9 100755
--- a/bin/update-schema
+++ b/bin/update-schema
@@ -212,6 +212,7 @@ else {
# (assuming schema change files are never half-applied, which should be the case)
sub get_db_version {
return 'EMPTY' if ! table_exists('problem');
+ return '0072' if constraint_contains('contacts_state_check', 'staff');
return '0071' if table_exists('manifest_theme');
return '0070' if column_like('alert_type', "ref='new_problems'", 'head_title', '{{SITE_NAME}}');
return '0069' if constraint_contains('admin_log_object_type_check', 'template');