aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@mysociety.org>2020-02-27 07:39:46 +0000
committerMatthew Somerville <matthew@mysociety.org>2020-02-27 07:39:46 +0000
commitb0b6810e372a154b1af7da72c1bd2143e5e251e9 (patch)
tree1ebbc91b59f8822e483e51f1f486c347718b0e65 /db/schema.sql
parent152f8f4e608abc5029104e652f4ef37d4cfe02cb (diff)
parent18adbe946c1104338e6abff159b4f9877154969c (diff)
Merge branch 'admin-only-categories'
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql2
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'
),