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

    resultItemTable.newBigIntegerColumn("closestfactorial", true);
    resultItemTable.newIntegerColumn("factornumber", true);
    resultItemTable.newIntegerColumn("id", false);
    resultItemTable.newIntBooleanColumn("isfactorialprime", false);
    resultItemTable.newIntBooleanColumn("isprime", false);
    resultItemTable.newTimestampColumn("modificationtime", false);
    resultItemTable.newBigIntegerColumn("numbertocheck", false);
    resultItemTable.newIntegerColumn("taskinfoid", false);
    resultItemTable.newStringColumn("workflowstate", 255, false);
    resultItemTable.create();
    resultItemTable.setPrimaryKey("id");

View Full Code Here

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

    resultItemTable.setPrimaryKey("id");


    ERXMigrationTable taskInfoTable = database.newTableNamed("taskinfo");
    taskInfoTable.newBigIntegerColumn("duration", false);
    taskInfoTable.newBigIntegerColumn("endnumber", true);
    taskInfoTable.newTimestampColumn("endtime", true);
    taskInfoTable.newIntegerColumn("id", false);
    taskInfoTable.newBigIntegerColumn("startnumber", false);
    taskInfoTable.newTimestampColumn("starttime", true);
    taskInfoTable.newStringColumn("workflowstate", 255, false);
    taskInfoTable.create();

View Full Code Here

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

    taskInfoTable.newBigIntegerColumn("duration", false);
    taskInfoTable.newBigIntegerColumn("endnumber", true);
    taskInfoTable.newTimestampColumn("endtime", true);
    taskInfoTable.newIntegerColumn("id", false);
    taskInfoTable.newBigIntegerColumn("startnumber", false);
    taskInfoTable.newTimestampColumn("starttime", true);
    taskInfoTable.newStringColumn("workflowstate", 255, false);
    taskInfoTable.create();
    taskInfoTable.setPrimaryKey("id");


    resultItemTable.addForeignKey("taskinfoid", "taskinfo", "id");

View Full Code Here

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

    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);
    employeeTable.newBigDecimalColumn("salary", 38, 4, true);

View Full Code Here

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

    companyTable.newStringColumn("zipcode", 255, true);
    companyTable.create();
     companyTable.setPrimaryKey("id");


    ERXMigrationTable partial_AuthenticatedPersonTable = database.existingTableNamed("Person");
    partial_AuthenticatedPersonTable.newTimestampColumn("lastLoginDate", true);
    partial_AuthenticatedPersonTable.newStringColumn("password", 255, true);
    partial_AuthenticatedPersonTable.newStringColumn("username", 255, true);


    ERXMigrationTable partial_EmployeePersonTable = database.existingTableNamed("Person");
    partial_EmployeePersonTable.newIntegerColumn("departmentID", true);

View Full Code Here

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

    votingTable.create();
     votingTable.setPrimaryKey("MOVIE_ID");


    ERXMigrationTable movieTable = database.newTableNamed("movie");
    movieTable.newStringColumn("CATEGORY", 20, true);
    movieTable.newTimestampColumn("DATE_RELEASED", true);
    movieTable.newIntegerColumn("MOVIE_ID", false);
    movieTable.newStringColumn("POSTER_NAME", 255, true);
    movieTable.newStringColumn("RATED", 10, true);
    movieTable.newBigDecimalColumn("REVENUE", 10, 2, true);
    movieTable.newIntegerColumn("STUDIO_ID", true);

View Full Code Here

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

    userTable.create();
     userTable.setPrimaryKey("USER_ID");


    ERXMigrationTable rentalTable = database.newTableNamed("rental");
    rentalTable.newIntegerColumn("CUSTOMER_ID", false);
    rentalTable.newTimestampColumn("DATE_OUT", false);
    rentalTable.newTimestampColumn("DATE_RETURNED", true);
    rentalTable.newIntegerColumn("RENTAL_ID", false);
    rentalTable.newIntegerColumn("UNIT_ID", false);
    rentalTable.create();
     rentalTable.setPrimaryKey("RENTAL_ID");

View Full Code Here

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

     userTable.setPrimaryKey("USER_ID");


    ERXMigrationTable rentalTable = database.newTableNamed("rental");
    rentalTable.newIntegerColumn("CUSTOMER_ID", false);
    rentalTable.newTimestampColumn("DATE_OUT", false);
    rentalTable.newTimestampColumn("DATE_RETURNED", true);
    rentalTable.newIntegerColumn("RENTAL_ID", false);
    rentalTable.newIntegerColumn("UNIT_ID", false);
    rentalTable.create();
     rentalTable.setPrimaryKey("RENTAL_ID");

View Full Code Here

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

    rentalTable.create();
     rentalTable.setPrimaryKey("RENTAL_ID");


    ERXMigrationTable feeTable = database.newTableNamed("fee");
    feeTable.newBigDecimalColumn("AMOUNT", 10, 2, false);
    feeTable.newTimestampColumn("DATE_PAID", true);
    feeTable.newIntegerColumn("FEE_ID", false);
    feeTable.newIntegerColumn("FEE_TYPE_ID", false);
    feeTable.newIntegerColumn("RENTAL_ID", false);
    feeTable.create();
     feeTable.setPrimaryKey("FEE_ID");

View Full Code Here

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

    feeTable.newIntegerColumn("RENTAL_ID", false);
    feeTable.create();
     feeTable.setPrimaryKey("FEE_ID");


    ERXMigrationTable unitTable = database.newTableNamed("unit");
    unitTable.newTimestampColumn("DATE_ACQUIRED", false);
    unitTable.newStringColumn("NOTES", 100, true);
    unitTable.newIntegerColumn("UNIT_ID", false);
    unitTable.newIntegerColumn("VIDEO_ID", false);
    unitTable.create();
     unitTable.setPrimaryKey("UNIT_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.