List of newTimestampColumn() Examples

Examples of newTimestampColumn()

er.extensions.migration.ERXMigrationTable.newTimestampColumn()
Returns a new timestamp 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.newTimestampColumn()

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

View Full Code Here

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

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

View Full Code Here

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

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


    ERXMigrationTable feeTypeTable = database.newTableNamed("feetype");

View Full Code Here

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

        eRCAuditTrailTable.newIntBooleanColumn("IS_DELETED", NOT_NULL);
        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);

View Full Code Here

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

        eRCHelpTextTable.newLocalizedClobColumns("VALUE_", ALLOWS_NULL);
        eRCHelpTextTable.create();
        eRCHelpTextTable.setPrimaryKey("ID");


        ERXMigrationTable eRCLogEntryTable = database.newTableNamed("ERCLOG_ENTRY");
        eRCLogEntryTable.newTimestampColumn("CREATED", NOT_NULL);
        eRCLogEntryTable.newIntegerColumn("ID", NOT_NULL);
        eRCLogEntryTable.newClobColumn("TEXT_", NOT_NULL);
        eRCLogEntryTable.newIntegerColumn("USER_ID", NOT_NULL);
        eRCLogEntryTable.create();
        eRCLogEntryTable.setPrimaryKey("ID");

View Full Code Here

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

  }


  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable erSessionInfoTable = database.newTableNamed("ERSessionInfo");
    erSessionInfoTable.newTimestampColumn("expirationDate", false);
    erSessionInfoTable.newIntegerColumn("intLock", false);
    erSessionInfoTable.newBlobColumn("sessionData", false);
    erSessionInfoTable.newStringColumn("sessionID", 50, false);

View Full Code Here

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

    xRequirementTestItemTable.create();
    xRequirementTestItemTable.setPrimaryKey("BUG_ID", "ID");


    ERXMigrationTable commentTable = database.newTableNamed("Comment");
    commentTable.newIntegerColumn("BUG_ID", false);
    commentTable.newTimestampColumn("DATE_SUBMITTED", true);
    commentTable.newIntegerColumn("id", false);
    commentTable.newIntegerColumn("ORIGINATOR_ID", false);
    commentTable.newIntegerColumn("PARENT_ID", true);
    commentTable.newLargeStringColumn("DESCRIPTION", true);
    commentTable.create();

View Full Code Here

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

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


    ERXMigrationTable bugTable = database.newTableNamed("BUG");
    bugTable.newIntegerColumn("COMP_ID", false);
    bugTable.newTimestampColumn("DATE_MODIFIED", true);
    bugTable.newTimestampColumn("DATE_SUBMITTED", true);
    bugTable.newIntegerColumn("ID", false);
    bugTable.newIntBooleanColumn("IS_FEATURE_REQUEST", false);
    bugTable.newIntBooleanColumn("IS_READ", false);
    bugTable.newIntegerColumn("ORIGINATOR_ID", false);

View Full Code Here

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

    commentTable.setPrimaryKey("id");


    ERXMigrationTable bugTable = database.newTableNamed("BUG");
    bugTable.newIntegerColumn("COMP_ID", false);
    bugTable.newTimestampColumn("DATE_MODIFIED", true);
    bugTable.newTimestampColumn("DATE_SUBMITTED", true);
    bugTable.newIntegerColumn("ID", false);
    bugTable.newIntBooleanColumn("IS_FEATURE_REQUEST", false);
    bugTable.newIntBooleanColumn("IS_READ", false);
    bugTable.newIntegerColumn("ORIGINATOR_ID", false);
    bugTable.newIntegerColumn("PEOPLE_ID", false);

View Full Code Here

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

    bugTable.newStringColumn("type", 1, true);
    bugTable.create();
    bugTable.setPrimaryKey("ID");


    ERXMigrationTable releaseTable = database.newTableNamed("RELEASE");
    releaseTable.newTimestampColumn("DATE_DUE", false);
    releaseTable.newIntegerColumn("ID", false);
    releaseTable.newIntBooleanColumn("IS_OPEN", false);
    releaseTable.newStringColumn("NAME", 50, false);
    releaseTable.create();
    releaseTable.setPrimaryKey("ID");

View Full Code Here

0 1 2

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.