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

Example 6 with CreateTableBuilder

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

the class CreateTableQprofileChanges method execute.

@Override
public void execute(Context context) throws SQLException {
    List<String> stmts = new CreateTableBuilder(getDialect(), "qprofile_changes").addPkColumn(newVarcharColumnDefBuilder().setColumnName("kee").setLimit(40).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("qprofile_key").setLimit(255).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("change_type").setLimit(20).setIsNullable(false).setIgnoreOracleUnit(true).build()).addColumn(newVarcharColumnDefBuilder().setColumnName("user_login").setLimit(255).setIsNullable(true).setIgnoreOracleUnit(true).build()).addColumn(newClobColumnDefBuilder().setColumnName("change_data").setIsNullable(true).build()).addColumn(newBigIntegerColumnDefBuilder().setColumnName("created_at").setIsNullable(false).build()).build();
    context.execute(stmts);
}