summaryrefslogtreecommitdiffstats
path: root/schema/mysql-migrations/upgrade_172.sql
blob: 3af3571be13e44838f341103d827c6ee48bb4065 (plain)
1
2
3
4
5
6
7
8
9
10
11
ALTER TABLE sync_rule
  ADD COLUMN purge_action ENUM('delete', 'disable') NULL DEFAULT NULL AFTER purge_existing;

UPDATE sync_rule SET purge_action = 'delete';

ALTER TABLE sync_rule
  MODIFY COLUMN purge_action ENUM('delete', 'disable') DEFAULT NULL;

INSERT INTO director_schema_migration
  (schema_version, migration_time)
  VALUES (172, NOW());