List of newIntegerColumn() Examples

Examples of newIntegerColumn()

er.extensions.migration.ERXMigrationTable.newIntegerColumn()
Returns a new integer column. See newColumn(..) for the full docs. @param name the name of the column @param allowsNull if true, the column will allow null values @return the new ERXMigrationColumn @throws SQLException if the column cannot be created

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

    sPWishTable.create();
     sPWishTable.setPrimaryKey("id");


    ERXMigrationTable sPMembershipTable = database.newTableNamed("SPMembership");
    sPMembershipTable.newBooleanColumn("admin", false);
    sPMembershipTable.newIntegerColumn("groupID", false);
    sPMembershipTable.newIntegerColumn("personID", false);
    sPMembershipTable.newStringColumn("confirmationCode", 100, true);
    sPMembershipTable.newBooleanColumn("confirmed", false);
    sPMembershipTable.create();
     sPMembershipTable.setPrimaryKey("groupID", "personID");

View Full Code Here

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

     sPWishTable.setPrimaryKey("id");


    ERXMigrationTable sPMembershipTable = database.newTableNamed("SPMembership");
    sPMembershipTable.newBooleanColumn("admin", false);
    sPMembershipTable.newIntegerColumn("groupID", false);
    sPMembershipTable.newIntegerColumn("personID", false);
    sPMembershipTable.newStringColumn("confirmationCode", 100, true);
    sPMembershipTable.newBooleanColumn("confirmed", false);
    sPMembershipTable.create();
     sPMembershipTable.setPrimaryKey("groupID", "personID");

View Full Code Here

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

     sPMembershipTable.setPrimaryKey("groupID", "personID");


    ERXMigrationTable sPEventTable = database.newTableNamed("SPEvent");
    sPEventTable.newBooleanColumn("active", false);
    sPEventTable.newStringColumn("description", 1000, true);
    sPEventTable.newIntegerColumn("groupID", false);
    sPEventTable.newIntegerColumn("id", false);
    sPEventTable.newStringColumn("name", 255, false);
    sPEventTable.create();
     sPEventTable.setPrimaryKey("id");

View Full Code Here

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


    ERXMigrationTable sPEventTable = database.newTableNamed("SPEvent");
    sPEventTable.newBooleanColumn("active", false);
    sPEventTable.newStringColumn("description", 1000, true);
    sPEventTable.newIntegerColumn("groupID", false);
    sPEventTable.newIntegerColumn("id", false);
    sPEventTable.newStringColumn("name", 255, false);
    sPEventTable.create();
     sPEventTable.setPrimaryKey("id");


    sPGroupTable.addForeignKey("ownerID", "SPPerson", "id");

View Full Code Here

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

  }


  @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");

View Full Code Here

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

  }


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

View Full Code Here

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

    companyTable.create();
    companyTable.setPrimaryKey("id");


    ERXMigrationTable employeeTable = database.newTableNamed("Employee");
    employeeTable.newIntBooleanColumn("admin", false);
    employeeTable.newIntegerColumn("companyID", false);
    employeeTable.newIntegerColumn("exemptions", true);
    employeeTable.newStringColumn("firstName", 255, false);
    employeeTable.newTimestampColumn("hireDate", false);
    employeeTable.newIntegerColumn("id", false);
    employeeTable.newBooleanColumn("insured", false);

View Full Code Here

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

    companyTable.setPrimaryKey("id");


    ERXMigrationTable employeeTable = database.newTableNamed("Employee");
    employeeTable.newIntBooleanColumn("admin", false);
    employeeTable.newIntegerColumn("companyID", false);
    employeeTable.newIntegerColumn("exemptions", true);
    employeeTable.newStringColumn("firstName", 255, false);
    employeeTable.newTimestampColumn("hireDate", false);
    employeeTable.newIntegerColumn("id", false);
    employeeTable.newBooleanColumn("insured", false);
    employeeTable.newStringColumn("lastName", 255, false);

View Full Code Here

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

    employeeTable.newIntBooleanColumn("admin", false);
    employeeTable.newIntegerColumn("companyID", false);
    employeeTable.newIntegerColumn("exemptions", true);
    employeeTable.newStringColumn("firstName", 255, false);
    employeeTable.newTimestampColumn("hireDate", false);
    employeeTable.newIntegerColumn("id", false);
    employeeTable.newBooleanColumn("insured", false);
    employeeTable.newStringColumn("lastName", 255, false);
    employeeTable.newIntegerColumn("photoID", true);
    employeeTable.newBigDecimalColumn("salary", 38, 4, true);
    employeeTable.newStringColumn("status", 50, false);

View Full Code Here

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

    employeeTable.newStringColumn("firstName", 255, false);
    employeeTable.newTimestampColumn("hireDate", false);
    employeeTable.newIntegerColumn("id", false);
    employeeTable.newBooleanColumn("insured", false);
    employeeTable.newStringColumn("lastName", 255, false);
    employeeTable.newIntegerColumn("photoID", true);
    employeeTable.newBigDecimalColumn("salary", 38, 4, true);
    employeeTable.newStringColumn("status", 50, false);
    employeeTable.create();
    employeeTable.setPrimaryKey("id");

View Full Code Here

0 1 2 3 4 5

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.