Examples with DropIndexBuilder org.sonar.server.platform.db.migration.sql.DropIndexBuilder used on opensource projects

Example 1 with DropIndexBuilder

use of org.sonar.server.platform.db.migration.sql.DropIndexBuilder in project sonarqube by SonarSource.

the class RenameTableProperties2ToProperties method execute.

@Override
public void execute(Context context) throws SQLException {
    context.execute(new DropIndexBuilder(getDialect()).setTable("properties2").setName("properties2_key").build());
    context.execute(new RenameTableBuilder(getDialect()).setName("properties2").setNewName("properties").build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable("properties").setName("properties_key").addColumn(newVarcharColumnDefBuilder().setColumnName("prop_key").setLimit(512).setIsNullable(false).setIgnoreOracleUnit(true).build()).build());
}

Example 2 with DropIndexBuilder

use of org.sonar.server.platform.db.migration.sql.DropIndexBuilder in project sonarqube by SonarSource.

the class IncludeOrganizationUuidInUniqueIndexOfGroupRoles method execute.

@Override
public void execute(Context context) throws SQLException {
    context.execute(new DropIndexBuilder(getDialect()).setTable(TABLE_GROUP_ROLES).setName("uniq_group_roles").build());
    context.execute(new CreateIndexBuilder(getDialect()).setTable(TABLE_GROUP_ROLES).setName("uniq_group_roles").setUnique(true).addColumn(newVarcharColumnDefBuilder().setColumnName("organization_uuid").setLimit(40).setIgnoreOracleUnit(true).build()).addColumn(newIntegerColumnDefBuilder().setColumnName("group_id").build()).addColumn(newIntegerColumnDefBuilder().setColumnName("resource_id").build()).addColumn(newVarcharColumnDefBuilder().setColumnName("role").setLimit(64).setIgnoreOracleUnit(true).build()).build());
}