1 files changed, 3 insertions, 5 deletions
diff --git a/db/schema.sql b/db/schema.sql
index f221825f2..6ddb7bae6 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -65,7 +65,8 @@ create table body (
     comment_user_id int references users(id),
     suppress_alerts boolean not null default 'f',
     can_be_devolved boolean not null default 'f',
-    send_extended_statuses boolean not null default 'f'
+    send_extended_statuses boolean not null default 'f',
+    deleted boolean not null default 'f'
 );
 
 create table body_areas (
@@ -448,9 +449,6 @@ create table admin_log (
       or object_type = 'user'
     ),
     object_id integer not null,
-    action text not null check (
-        action = 'edit'
-        or action = 'state_change' 
-        or action = 'resend'),
+    action text not null,
     whenedited timestamp not null default ms_current_timestamp()
 );