summaryrefslogtreecommitdiffstats
path: root/schema/mysql-migrations/upgrade_93.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema/mysql-migrations/upgrade_93.sql')
-rw-r--r--schema/mysql-migrations/upgrade_93.sql22
1 files changed, 22 insertions, 0 deletions
diff --git a/schema/mysql-migrations/upgrade_93.sql b/schema/mysql-migrations/upgrade_93.sql
new file mode 100644
index 0000000..845d4bf
--- /dev/null
+++ b/schema/mysql-migrations/upgrade_93.sql
@@ -0,0 +1,22 @@
+ALTER TABLE sync_rule
+ ADD COLUMN sync_state ENUM(
+ 'unknown',
+ 'in-sync',
+ 'pending-changes',
+ 'failing'
+ ) NOT NULL DEFAULT 'unknown',
+ ADD COLUMN last_error_message VARCHAR(255) DEFAULT NULL,
+ ADD COLUMN last_attempt DATETIME DEFAULT NULL
+;
+
+UPDATE sync_rule r
+ JOIN (
+ SELECT rule_id, MAX(start_time) AS start_time
+ FROM sync_run
+ GROUP BY rule_id
+ ) lr ON r.id = lr.rule_id
+ SET r.last_attempt = lr.start_time;
+
+INSERT INTO director_schema_migration
+ (schema_version, migration_time)
+ VALUES (93, NOW());