remove action check on admin_log

to allow a wider range of action logging.

2 files changed, 7 insertions, 4 deletions

diff --git a/db/schema.sql b/db/schema.sql
index 5c54e2d88..125e680c6 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -448,9 +448,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()
 ); 
diff --git a/db/schema_0030-drop-action-log-check-constraint.sql b/db/schema_0030-drop-action-log-check-constraint.sql
new file mode 100644
index 000000000..dfc5387f3
--- /dev/null
+++ b/db/schema_0030-drop-action-log-check-constraint.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE admin_log 
+    DROP CONSTRAINT admin_log_action_check;
+
+COMMIT;