aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/schema.sql5
-rw-r--r--db/schema_0030-drop-action-log-check-constraint.sql6
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;