fix: [CI-15948]: Changing build_deploy_id to BIG INT (#3618)

ShobhitSingh11 · web-flow · commit 4f8596143406 · 2025-02-28T17:26:51.000+05:30
diff --git a/store/shared/migrate/postgres/ddl_gen.go b/store/shared/migrate/postgres/ddl_gen.go
@@ -200,6 +200,10 @@ var migrations = []struct {
 		name: "create-new-table-cards",
 		stmt: createNewTableCards,
 	},
+	{
+		name: "alter-table-builds-alter-column-deploy-id",
+		stmt: alterTableBuildsAlterColumnDeployId,
+	},
 }
 
 // Migrate performs the database migration. If the migration fails
@@ -769,3 +773,9 @@ CREATE TABLE IF NOT EXISTS cards
     FOREIGN KEY (card_id) REFERENCES steps (step_id) ON DELETE CASCADE
 );
 `
+var alterTableBuildsAlterColumnDeployId = `
+ALTER TABLE builds
+ALTER COLUMN build_deploy_id SET DATA TYPE BIGINT,
+ALTER COLUMN build_deploy_id SET NOT NULL,
+ALTER COLUMN build_deploy_id SET DEFAULT 0;
+`
diff --git a/store/shared/migrate/postgres/files/020_amend_column_builds_deploy_id.sql b/store/shared/migrate/postgres/files/020_amend_column_builds_deploy_id.sql
@@ -0,0 +1,4 @@
+ALTER TABLE builds
+ALTER COLUMN build_deploy_id SET DATA TYPE BIGINT,
+ALTER COLUMN build_deploy_id SET NOT NULL,
+ALTER COLUMN build_deploy_id SET DEFAULT 0;
