List of newBooleanColumn() Examples

Examples of newBooleanColumn()

er.extensions.migration.ERXMigrationTable.newBooleanColumn()
Returns a new varchar(5) boolean 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.newBooleanColumn()

    sPGroupTable.newIntegerColumn("ownerID", false);
    sPGroupTable.create();
     sPGroupTable.setPrimaryKey("id");


    ERXMigrationTable sPPersonTable = database.newTableNamed("SPPerson");
    sPPersonTable.newBooleanColumn("admin", false);
    sPPersonTable.newIntegerColumn("avatarID", true);
    sPPersonTable.newStringColumn("emailAddress", 255, false);
    sPPersonTable.newBooleanColumn("emailDeliveryFailure", false);
    sPPersonTable.newIntegerColumn("id", false);
    sPPersonTable.newStringColumn("name", 255, false);

View Full Code Here

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


    ERXMigrationTable sPPersonTable = database.newTableNamed("SPPerson");
    sPPersonTable.newBooleanColumn("admin", false);
    sPPersonTable.newIntegerColumn("avatarID", true);
    sPPersonTable.newStringColumn("emailAddress", 255, false);
    sPPersonTable.newBooleanColumn("emailDeliveryFailure", false);
    sPPersonTable.newIntegerColumn("id", false);
    sPPersonTable.newStringColumn("name", 255, false);
    sPPersonTable.newStringColumn("password", 100, true);
    sPPersonTable.create();
     sPPersonTable.setPrimaryKey("id");

View Full Code Here

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


    ERXMigrationTable sPWishTable = database.newTableNamed("SPWish");
    sPWishTable.newBigDecimalColumn("cost", 38, 4, true);
    sPWishTable.newStringColumn("description", 1000, true);
    sPWishTable.newIntegerColumn("id", false);
    sPWishTable.newBooleanColumn("purchased", false);
    sPWishTable.newIntegerColumn("suggestedByID", false);
    sPWishTable.newIntegerColumn("suggestedForID", false);
    sPWishTable.create();
     sPWishTable.setPrimaryKey("id");

View Full Code Here

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

    sPWishTable.newIntegerColumn("suggestedForID", false);
    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();

View Full Code Here

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

    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");
    sPEventTable.newBooleanColumn("active", false);

View Full Code Here

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

    sPMembershipTable.newBooleanColumn("confirmed", false);
    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();

View Full Code Here

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

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

View Full Code Here

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

    employeeTable.newStringColumn("address1", 255, true);
    employeeTable.newStringColumn("address2", 255, true);
    employeeTable.newStringColumn("city", 255, true);
    employeeTable.newIntegerColumn("companyID", false);
    employeeTable.newIntegerColumn("id", false);
    employeeTable.newBooleanColumn("manager", false);
    employeeTable.newStringColumn("firstName", 255, false);
    employeeTable.newStringColumn("lastName", 255, false);
    employeeTable.newStringColumn("state", 255, true);
    employeeTable.newStringColumn("zipcode", 255, true);
    employeeTable.create();

View Full Code Here

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

    employeeRoleTable.addForeignKey("employeeId", "Employee", "id");
    employeeRoleTable.addForeignKey("roleId", "Role", "id");


    ERXMigrationTable paycheckTable = database.newTableNamed("Paycheck");
    paycheckTable.newBigDecimalColumn("amount", 38, 2, false);
    paycheckTable.newBooleanColumn("cashed", false);
    paycheckTable.newIntegerColumn("employeeID", false);
    paycheckTable.newIntegerColumn("id", false);
    paycheckTable.newTimestampColumn("paymentDate", false);
    paycheckTable.create();
    paycheckTable.setPrimaryKey("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.