1 files changed, 15 insertions, 0 deletions
diff --git a/db/click_house/migrate/main/20240102161102_modify_ci_finished_builds_started_at_default_to_zero.rb b/db/click_house/migrate/main/20240102161102_modify_ci_finished_builds_started_at_default_to_zero.rb
new file mode 100644
index 00000000000..e4fae74748b
--- /dev/null
+++ b/db/click_house/migrate/main/20240102161102_modify_ci_finished_builds_started_at_default_to_zero.rb
@@ -0,0 +1,15 @@
+# frozen_string_literal: true
+
+class ModifyCiFinishedBuildsStartedAtDefaultToZero < ClickHouse::Migration
+  def up
+    execute <<~SQL
+      ALTER TABLE ci_finished_builds MODIFY COLUMN started_at DEFAULT 0
+    SQL
+  end
+
+  def down
+    execute <<~SQL
+      ALTER TABLE ci_finished_builds MODIFY COLUMN started_at DEFAULT COALESCE(finished_at, 0)
+    SQL
+  end
+end