diff options
2 files changed, 3 insertions, 1 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 72b933164c0..78f221a55e4 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -1095,7 +1095,7 @@ CREATE TABLE "SCA_RELEASES"( "CREATED_AT" BIGINT NOT NULL, "UPDATED_AT" BIGINT NOT NULL, "NEW_IN_PULL_REQUEST" BOOLEAN DEFAULT FALSE NOT NULL, - "DECLARED_LICENSE_EXPRESSION" CHARACTER VARYING(400) NOT NULL + "DECLARED_LICENSE_EXPRESSION" CHARACTER VARYING(400) DEFAULT 'NOASSERTION' NOT NULL ); ALTER TABLE "SCA_RELEASES" ADD CONSTRAINT "PK_SCA_RELEASES" PRIMARY KEY("UUID"); CREATE INDEX "SCA_RELEASES_COMP_UUID_UUID" ON "SCA_RELEASES"("COMPONENT_UUID" NULLS FIRST, "UUID" NULLS FIRST); diff --git a/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v202503/AddDeclaredLicenseExpressionToScaReleasesTable.java b/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v202503/AddDeclaredLicenseExpressionToScaReleasesTable.java index bd806c9d497..b8a0c26e52b 100644 --- a/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v202503/AddDeclaredLicenseExpressionToScaReleasesTable.java +++ b/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v202503/AddDeclaredLicenseExpressionToScaReleasesTable.java @@ -30,6 +30,7 @@ import static org.sonar.db.DatabaseUtils.tableColumnExists; public class AddDeclaredLicenseExpressionToScaReleasesTable extends DdlChange { static final String TABLE_NAME = "sca_releases"; static final String COLUMN_NAME = "declared_license_expression"; + private static final String NOASSERTION = "NOASSERTION"; private static final int COLUMN_SIZE = 400; public AddDeclaredLicenseExpressionToScaReleasesTable(Database db) { @@ -41,6 +42,7 @@ public class AddDeclaredLicenseExpressionToScaReleasesTable extends DdlChange { try (var connection = getDatabase().getDataSource().getConnection()) { if (!tableColumnExists(connection, TABLE_NAME, COLUMN_NAME)) { var columnDef = VarcharColumnDef.newVarcharColumnDefBuilder() + .setDefaultValue(NOASSERTION) .setColumnName(COLUMN_NAME) .setLimit(COLUMN_SIZE) .setIsNullable(false) |