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

     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


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


    ERXMigrationTable unitTable = database.newTableNamed("unit");

View Full Code Here

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


    ERXMigrationTable unitTable = database.newTableNamed("unit");
    unitTable.newTimestampColumn("DATE_ACQUIRED", false);

View Full Code Here

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


    ERXMigrationTable videoTable = database.newTableNamed("video");

View Full Code Here


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


    ERXMigrationTable videoTable = database.newTableNamed("video");
    videoTable.newIntegerColumn("MOVIE_ID", false);

View Full Code Here

    unitTable.newIntegerColumn("VIDEO_ID", false);
    unitTable.create();
     unitTable.setPrimaryKey("UNIT_ID");


    ERXMigrationTable videoTable = database.newTableNamed("video");
    videoTable.newIntegerColumn("MOVIE_ID", false);
    videoTable.newIntegerColumn("RENTAL_TERMS_ID", false);
    videoTable.newIntegerColumn("VIDEO_ID", false);
    videoTable.create();
     videoTable.setPrimaryKey("VIDEO_ID");

View Full Code Here

    unitTable.create();
     unitTable.setPrimaryKey("UNIT_ID");


    ERXMigrationTable videoTable = database.newTableNamed("video");
    videoTable.newIntegerColumn("MOVIE_ID", false);
    videoTable.newIntegerColumn("RENTAL_TERMS_ID", false);
    videoTable.newIntegerColumn("VIDEO_ID", false);
    videoTable.create();
     videoTable.setPrimaryKey("VIDEO_ID");


    ERXMigrationTable rentalTermsTable = database.newTableNamed("rentalterms");

View Full Code Here

     unitTable.setPrimaryKey("UNIT_ID");


    ERXMigrationTable videoTable = database.newTableNamed("video");
    videoTable.newIntegerColumn("MOVIE_ID", false);
    videoTable.newIntegerColumn("RENTAL_TERMS_ID", false);
    videoTable.newIntegerColumn("VIDEO_ID", false);
    videoTable.create();
     videoTable.setPrimaryKey("VIDEO_ID");


    ERXMigrationTable rentalTermsTable = database.newTableNamed("rentalterms");
    rentalTermsTable.newIntegerColumn("CHECK_OUT_LENGTH", false);

View Full Code Here

    videoTable.newIntegerColumn("VIDEO_ID", false);
    videoTable.create();
     videoTable.setPrimaryKey("VIDEO_ID");


    ERXMigrationTable rentalTermsTable = database.newTableNamed("rentalterms");
    rentalTermsTable.newIntegerColumn("CHECK_OUT_LENGTH", false);
    rentalTermsTable.newBigDecimalColumn("COST", 10, 2, false);
    rentalTermsTable.newBigDecimalColumn("DEPOSIT_AMOUNT", 10, 2, false);
    rentalTermsTable.newStringColumn("NAME", 20, false);
    rentalTermsTable.newIntegerColumn("RENTAL_TERMS_ID", false);
    rentalTermsTable.create();

View Full Code Here

    ERXMigrationTable rentalTermsTable = database.newTableNamed("rentalterms");
    rentalTermsTable.newIntegerColumn("CHECK_OUT_LENGTH", false);
    rentalTermsTable.newBigDecimalColumn("COST", 10, 2, false);
    rentalTermsTable.newBigDecimalColumn("DEPOSIT_AMOUNT", 10, 2, false);
    rentalTermsTable.newStringColumn("NAME", 20, false);
    rentalTermsTable.newIntegerColumn("RENTAL_TERMS_ID", false);
    rentalTermsTable.create();
     rentalTermsTable.setPrimaryKey("RENTAL_TERMS_ID");


    ERXMigrationTable customerTable = database.newTableNamed("customer");
    customerTable.newStringColumn("CITY", 20, false);

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.