diff options
| author | Matthew Somerville <matthew@mysociety.org> | 2020-02-17 17:43:54 +0000 |
|---|---|---|
| committer | Matthew Somerville <matthew@mysociety.org> | 2020-02-26 11:40:15 +0000 |
| commit | 18adbe946c1104338e6abff159b4f9877154969c (patch) | |
| tree | 5bae6c894981d3d90724f75c241c9d1e4c848dc2 /db/schema.sql | |
| parent | 97133a07a181e6cccc207cc6598a08e8028ad7ca (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 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/db/schema.sql b/db/schema.sql index 0e38ad862..ed21aded6 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -100,6 +100,7 @@ create table contacts ( state = 'unconfirmed' or state = 'confirmed' or state = 'inactive' + or state = 'staff' or state = 'deleted' ), @@ -137,6 +138,7 @@ create table contacts_history ( state = 'unconfirmed' or state = 'confirmed' or state = 'inactive' + or state = 'staff' or state = 'deleted' ), |