List of newStringColumn() Examples

Examples of newStringColumn()

er.extensions.migration.ERXMigrationTable.newStringColumn()
Returns a new String column (VARCHAR). See newColumn(..) for the full docs. @param name the name of the column @param width the max width of the varchar @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.newStringColumn()


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


    ERXMigrationTable sPEventTable = database.newTableNamed("SPEvent");

View Full Code Here

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

    sPMembershipTable.create();
     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.newStringColumn()

    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");
    sPPersonTable.addForeignKey("avatarID", "ERAttachment", "id");

View Full Code Here

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


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


    ERXMigrationTable employeeTable = database.newTableNamed("Employee");

View Full Code Here

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

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


    ERXMigrationTable employeeTable = database.newTableNamed("Employee");
    employeeTable.newIntBooleanColumn("admin", false);

View Full Code Here

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


    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);
    employeeTable.newIntegerColumn("photoID", true);

View Full Code Here

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

    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);
    employeeTable.create();
    employeeTable.setPrimaryKey("id");

View Full Code Here

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

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


    employeeTable.addForeignKey("companyID", "Company", "id");
    employeeTable.addForeignKey("photoID", "ERAttachment", "id");

View Full Code Here

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


  @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");
    departmentTable.newIntegerColumn("companyID", false);

View Full Code Here

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

    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

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.