Examples of er.extensions.migration.ERXMigrationTable.addIndex()

Class er.extensions.migration.ERXMigrationTable

Examples of er.extensions.migration.ERXMigrationTable.addIndex()

er.extensions.migration.ERXMigrationTable.addIndex()
Executes the SQL operations to add this index. @param columnName the name of the column to add a unique index on @throws SQLException if the constraint fails


  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable companyTable = database.existingTableNamed("Company");
    companyTable.newIntegerColumn("logoID", true);
    companyTable.addIndex("name");


    ERXMigrationTable employeeTable = database.existingTableNamed("Employee");
    employeeTable.addIndex("lastName");


    companyTable.addForeignKey("logoID", "ERAttachment", "id");

View Full Code Here

    ERXMigrationTable companyTable = database.existingTableNamed("Company");
    companyTable.newIntegerColumn("logoID", true);
    companyTable.addIndex("name");


    ERXMigrationTable employeeTable = database.existingTableNamed("Employee");
    employeeTable.addIndex("lastName");


    companyTable.addForeignKey("logoID", "ERAttachment", "id");
  }
}

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.