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

Class er.extensions.migration.ERXMigrationTable

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

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

View Full Code Here

     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);
    customerTable.newStringColumn("STREET_ADDRESS", 50, true);

View Full Code Here


    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);
    customerTable.newStringColumn("STREET_ADDRESS", 50, true);
    customerTable.newStringColumn("ZIP", 10, true);

View Full Code Here

    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);
    customerTable.newStringColumn("STREET_ADDRESS", 50, true);
    customerTable.newStringColumn("ZIP", 10, true);
    customerTable.create();
     customerTable.setPrimaryKey("CUSTOMER_ID");

View Full Code Here

    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);
    customerTable.newStringColumn("STREET_ADDRESS", 50, true);
    customerTable.newStringColumn("ZIP", 10, true);
    customerTable.create();
     customerTable.setPrimaryKey("CUSTOMER_ID");

View Full Code Here

    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);
    customerTable.newStringColumn("STREET_ADDRESS", 50, true);
    customerTable.newStringColumn("ZIP", 10, true);
    customerTable.create();
     customerTable.setPrimaryKey("CUSTOMER_ID");


    ERXMigrationTable creditCardTable = database.newTableNamed("creditcard");

View Full Code Here

    customerTable.newStringColumn("LAST_NAME", 30, false);
    customerTable.newTimestampColumn("MEMBER_SINCE", true);
    customerTable.newStringColumn("PHONE", 10, true);
    customerTable.newStringColumn("STATE", 2, true);
    customerTable.newStringColumn("STREET_ADDRESS", 50, true);
    customerTable.newStringColumn("ZIP", 10, true);
    customerTable.create();
     customerTable.setPrimaryKey("CUSTOMER_ID");


    ERXMigrationTable creditCardTable = database.newTableNamed("creditcard");
    creditCardTable.newTimestampColumn("AUTHORIZATION_DATE", false);

View Full Code Here

    customerTable.create();
     customerTable.setPrimaryKey("CUSTOMER_ID");


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

View Full Code Here

     customerTable.setPrimaryKey("CUSTOMER_ID");


    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.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

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.