Set timestamps to CURRENT_TIMESTAMP
@@ -31,6 +31,8 @@ ALTER COLUMN updated_at TYPE timestamp,
ALTER COLUMN updated_at SET NOT NULL,
ALTER COLUMN updated_at SET DEFAULT CURRENT_TIMESTAMP;
+UPDATE jobs SET updated_at = CURRENT_TIMESTAMP;
+
ALTER TABLE jobs
ALTER COLUMN created_at TYPE timestamp,
ALTER COLUMN created_at SET NOT NULL,
@@ -42,6 +44,8 @@ ALTER TABLE namespace_ownerships
ALTER COLUMN started_at TYPE timestamp,
ALTER COLUMN started_at SET DEFAULT CURRENT_TIMESTAMP;
+UPDATE namespaces SET updated_at = CURRENT_TIMESTAMP;
+
ALTER TABLE namespaces
ALTER COLUMN updated_at TYPE timestamp,
ALTER COLUMN updated_at SET NOT NULL,
