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

Class er.extensions.migration.ERXMigrationTable

Examples of er.extensions.migration.ERXMigrationTable.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

    rentalTermsTable.create();
     rentalTermsTable.setPrimaryKey("RENTAL_TERMS_ID");


    ERXMigrationTable customerTable = database.newTableNamed("customer");
    customerTable.newStringColumn("CITY", 20, false);
    customerTable.newIntegerColumn("CUSTOMER_ID", false);
    customerTable.newStringColumn("FIRST_NAME", 20, false);
    customerTable.newStringColumn("LAST_NAME", 30, false);
    customerTable.newTimestampColumn("MEMBER_SINCE", true);
    customerTable.newStringColumn("PHONE", 10, true);
    customerTable.newStringColumn("STATE", 2, true);

View Full Code Here


    ERXMigrationTable creditCardTable = database.newTableNamed("creditcard");
    creditCardTable.newTimestampColumn("AUTHORIZATION_DATE", false);
    creditCardTable.newStringColumn("AUTHORIZATION_NUM", 10, false);
    creditCardTable.newStringColumn("CARD_NUMBER", 25, false);
    creditCardTable.newIntegerColumn("CUSTOMER_ID", false);
    creditCardTable.newTimestampColumn("EXPIRATION_DATE", false);
    creditCardTable.newBigDecimalColumn("CLIMIT", 10, 2, false);
    creditCardTable.create();
     creditCardTable.setPrimaryKey("CUSTOMER_ID");

View Full Code Here

    creditCardTable.newBigDecimalColumn("CLIMIT", 10, 2, false);
    creditCardTable.create();
     creditCardTable.setPrimaryKey("CUSTOMER_ID");


    ERXMigrationTable feeTypeTable = database.newTableNamed("feetype");
    feeTypeTable.newIntegerColumn("ENABLED", false);
    feeTypeTable.newStringColumn("FEE_TYPE", 15, false);
    feeTypeTable.newIntegerColumn("FEE_TYPE_ID", false);
    feeTypeTable.newIntegerColumn("ORDER_BY", 9, false);
    feeTypeTable.create();
     feeTypeTable.setPrimaryKey("FEE_TYPE_ID");

View Full Code Here

     creditCardTable.setPrimaryKey("CUSTOMER_ID");


    ERXMigrationTable feeTypeTable = database.newTableNamed("feetype");
    feeTypeTable.newIntegerColumn("ENABLED", false);
    feeTypeTable.newStringColumn("FEE_TYPE", 15, false);
    feeTypeTable.newIntegerColumn("FEE_TYPE_ID", false);
    feeTypeTable.newIntegerColumn("ORDER_BY", 9, false);
    feeTypeTable.create();
     feeTypeTable.setPrimaryKey("FEE_TYPE_ID");  
    
    ERXJDBCUtilities.executeUpdateScriptFromResourceNamed(database

View Full Code Here


    ERXMigrationTable feeTypeTable = database.newTableNamed("feetype");
    feeTypeTable.newIntegerColumn("ENABLED", false);
    feeTypeTable.newStringColumn("FEE_TYPE", 15, false);
    feeTypeTable.newIntegerColumn("FEE_TYPE_ID", false);
    feeTypeTable.newIntegerColumn("ORDER_BY", 9, false);
    feeTypeTable.create();
     feeTypeTable.setPrimaryKey("FEE_TYPE_ID");  
    
    ERXJDBCUtilities.executeUpdateScriptFromResourceNamed(database
        .adaptorChannel(), "Movies0-"

View Full Code Here

    @Override
    public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
        
        ERXMigrationTable eRCAuditBlobTable = database.newTableNamed("ERCAuditBlob");
        eRCAuditBlobTable.newBlobColumn("BLOB_VALUE", NOT_NULL);
        eRCAuditBlobTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditBlobTable.create();
        eRCAuditBlobTable.setPrimaryKey("ID");


        ERXMigrationTable eRCAuditTrailTable = database.newTableNamed("ERCAuditTrail");
        eRCAuditTrailTable.newStringColumn("GID", 255, ALLOWS_NULL);

View Full Code Here

        eRCAuditBlobTable.create();
        eRCAuditBlobTable.setPrimaryKey("ID");


        ERXMigrationTable eRCAuditTrailTable = database.newTableNamed("ERCAuditTrail");
        eRCAuditTrailTable.newStringColumn("GID", 255, ALLOWS_NULL);
        eRCAuditTrailTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditTrailTable.newIntBooleanColumn("IS_DELETED", NOT_NULL);
        eRCAuditTrailTable.create();
        eRCAuditTrailTable.setPrimaryKey("ID");


        ERXMigrationTable eRCAuditTrailEntryTable = database.newTableNamed("ERCAuditTrailEntry");

View Full Code Here

        eRCAuditTrailTable.create();
        eRCAuditTrailTable.setPrimaryKey("ID");


        ERXMigrationTable eRCAuditTrailEntryTable = database.newTableNamed("ERCAuditTrailEntry");
        eRCAuditTrailEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("KEY_PATH", 100, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("NEW_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("NEW_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("OLD_VALUES", 1000, ALLOWS_NULL);

View Full Code Here


        ERXMigrationTable eRCAuditTrailEntryTable = database.newTableNamed("ERCAuditTrailEntry");
        eRCAuditTrailEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("KEY_PATH", 100, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("NEW_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("NEW_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("OLD_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("TRAIL_ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("TYPE", 50, NOT_NULL);

View Full Code Here

        eRCAuditTrailEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("KEY_PATH", 100, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("NEW_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("NEW_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("OLD_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("TRAIL_ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("TYPE", 50, NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("USER_GLOBAL_ID", 255, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newBlobColumn("USER_INFO", ALLOWS_NULL);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.