Examples with IntegerColumnDef org.sonar.server.platform.db.migration.def.IntegerColumnDef used on opensource projects

Example 16 with IntegerColumnDef

use of org.sonar.server.platform.db.migration.def.IntegerColumnDef in project sonarqube by SonarSource.

the class CreateInitialSchema method createRulesParameters.

private void createRulesParameters(Context context) throws SQLException {
    IntegerColumnDef ruleIdCol = newIntegerColumnDefBuilder().setColumnName("rule_id").setIsNullable(false).build();
    context.execute(newTableBuilder("rules_parameters").addPkColumn(newIntegerColumnDefBuilder().setColumnName("id").setIsNullable(false).build(), AUTO_INCREMENT).addColumn(ruleIdCol).addColumn(newLenientVarcharBuilder("name").setLimit(128).setIsNullable(false).build()).addColumn(newLenientVarcharBuilder("description").setLimit(4000).setIsNullable(true).build()).addColumn(newLenientVarcharBuilder("param_type").setLimit(512).setIsNullable(false).build()).addColumn(newLenientVarcharBuilder("default_value").setLimit(4000).setIsNullable(true).build()).build());
    addIndex(context, "rules_parameters", "rules_parameters_rule_id", false, ruleIdCol);
}