Examples of newIntegerColumn()


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

  }

  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable employeeTypeTable = database.newTableNamed("EmployeeType");
    employeeTypeTable.newIntegerColumn("id", false);
    employeeTypeTable.newStringColumn("name", 255, false);
    employeeTypeTable.create();
     employeeTypeTable.setPrimaryKey("id");

    ERXMigrationTable departmentTable = database.newTableNamed("Department");
View Full Code Here

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

    employeeTypeTable.newStringColumn("name", 255, false);
    employeeTypeTable.create();
     employeeTypeTable.setPrimaryKey("id");

    ERXMigrationTable departmentTable = database.newTableNamed("Department");
    departmentTable.newIntegerColumn("companyID", false);
    departmentTable.newStringColumn("departmentCode", 255, false);
    departmentTable.newIntegerColumn("id", false);
    departmentTable.newStringColumn("name", 255, false);
    departmentTable.create();
     departmentTable.setPrimaryKey("id");
View Full Code Here

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

     employeeTypeTable.setPrimaryKey("id");

    ERXMigrationTable departmentTable = database.newTableNamed("Department");
    departmentTable.newIntegerColumn("companyID", false);
    departmentTable.newStringColumn("departmentCode", 255, false);
    departmentTable.newIntegerColumn("id", false);
    departmentTable.newStringColumn("name", 255, false);
    departmentTable.create();
     departmentTable.setPrimaryKey("id");

    ERXMigrationTable companyTable = database.newTableNamed("Company");
View Full Code Here

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

    ERXMigrationTable companyTable = database.newTableNamed("Company");
    companyTable.newStringColumn("address1", 255, true);
    companyTable.newStringColumn("address2", 255, true);
    companyTable.newStringColumn("city", 255, true);
    companyTable.newIntegerColumn("id", false);
    companyTable.newStringColumn("name", 255, false);
    companyTable.newStringColumn("state", 255, true);
    companyTable.newStringColumn("zipcode", 255, true);
    companyTable.create();
     companyTable.setPrimaryKey("id");
View Full Code Here

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

  }

  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable spNoNoPalTable = database.newTableNamed("SPNoNoPal");
    spNoNoPalTable.newIntegerColumn("eventID", false);
    spNoNoPalTable.newIntegerColumn("giverID", false);
    spNoNoPalTable.newIntegerColumn("id", false);
    spNoNoPalTable.newIntegerColumn("receiverID", false);
    spNoNoPalTable.create();
    spNoNoPalTable.setPrimaryKey("id");
View Full Code Here

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

  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable spNoNoPalTable = database.newTableNamed("SPNoNoPal");
    spNoNoPalTable.newIntegerColumn("eventID", false);
    spNoNoPalTable.newIntegerColumn("giverID", false);
    spNoNoPalTable.newIntegerColumn("id", false);
    spNoNoPalTable.newIntegerColumn("receiverID", false);
    spNoNoPalTable.create();
    spNoNoPalTable.setPrimaryKey("id");
View Full Code Here

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

  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable spNoNoPalTable = database.newTableNamed("SPNoNoPal");
    spNoNoPalTable.newIntegerColumn("eventID", false);
    spNoNoPalTable.newIntegerColumn("giverID", false);
    spNoNoPalTable.newIntegerColumn("id", false);
    spNoNoPalTable.newIntegerColumn("receiverID", false);
    spNoNoPalTable.create();
    spNoNoPalTable.setPrimaryKey("id");

    spNoNoPalTable.addForeignKey("eventID", "SPEvent", "id");
View Full Code Here

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

  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable spNoNoPalTable = database.newTableNamed("SPNoNoPal");
    spNoNoPalTable.newIntegerColumn("eventID", false);
    spNoNoPalTable.newIntegerColumn("giverID", false);
    spNoNoPalTable.newIntegerColumn("id", false);
    spNoNoPalTable.newIntegerColumn("receiverID", false);
    spNoNoPalTable.create();
    spNoNoPalTable.setPrimaryKey("id");

    spNoNoPalTable.addForeignKey("eventID", "SPEvent", "id");
    spNoNoPalTable.addForeignKey("giverID", "SPPerson", "id");
View Full Code Here

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

    partial_AuthenticatedPersonTable.newTimestampColumn("lastLoginDate", true);
    partial_AuthenticatedPersonTable.newStringColumn("password", 255, true);
    partial_AuthenticatedPersonTable.newStringColumn("username", 255, true);

    ERXMigrationTable partial_EmployeePersonTable = database.existingTableNamed("Person");
    partial_EmployeePersonTable.newIntegerColumn("departmentID", true);
    partial_EmployeePersonTable.newStringColumn("employeeNumber", 255, true);
    partial_EmployeePersonTable.newIntegerColumn("employeeTypeID", true);
    partial_EmployeePersonTable.newBigDecimalColumn("salary", 38, 2, true);

    partial_EmployeePersonTable.addForeignKey("departmentID", "Department", "id");
View Full Code Here

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

    partial_AuthenticatedPersonTable.newStringColumn("username", 255, true);

    ERXMigrationTable partial_EmployeePersonTable = database.existingTableNamed("Person");
    partial_EmployeePersonTable.newIntegerColumn("departmentID", true);
    partial_EmployeePersonTable.newStringColumn("employeeNumber", 255, true);
    partial_EmployeePersonTable.newIntegerColumn("employeeTypeID", true);
    partial_EmployeePersonTable.newBigDecimalColumn("salary", 38, 2, true);

    partial_EmployeePersonTable.addForeignKey("departmentID", "Department", "id");
    partial_EmployeePersonTable.addForeignKey("employeeTypeID", "EmployeeType", "id");
    departmentTable.addForeignKey("companyID", "Company", "id");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.