List of newBigDecimalColumn() Examples

Examples of newBigDecimalColumn()

er.extensions.migration.ERXMigrationTable.newBigDecimalColumn()
Returns a new BigDecimal column. See newColumn(..) for the full docs. @param name the name of the column @param scale the scale of the BigDecimal @param precision the precision of the BigDecimal @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.newBigDecimalColumn()

    sPSecretPalTable.newIntegerColumn("receiverID", false);
    sPSecretPalTable.create();
     sPSecretPalTable.setPrimaryKey("id");


    ERXMigrationTable sPWishTable = database.newTableNamed("SPWish");
    sPWishTable.newBigDecimalColumn("cost", 38, 4, true);
    sPWishTable.newStringColumn("description", 1000, true);
    sPWishTable.newIntegerColumn("id", false);
    sPWishTable.newBooleanColumn("purchased", false);
    sPWishTable.newIntegerColumn("suggestedByID", false);
    sPWishTable.newIntegerColumn("suggestedForID", false);

View Full Code Here

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

    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);
    employeeTable.newStringColumn("status", 50, false);
    employeeTable.create();
    employeeTable.setPrimaryKey("id");


    employeeTable.addForeignKey("companyID", "Company", "id");

View Full Code Here

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


    ERXMigrationTable partial_EmployeePersonTable = database.existingTableNamed("Person");
    partial_EmployeePersonTable.newIntegerColumn("departmentID", true);
    partial_EmployeePersonTable.newStringColumn("employeeNumber", 255, true);
    partial_EmployeePersonTable.newIntegerColumn("employeeTypeID", true);
    partial_EmployeePersonTable.newBigDecimalColumn("salary", 38, 2, true);


    partial_EmployeePersonTable.addForeignKey("departmentID", "Department", "id");
    partial_EmployeePersonTable.addForeignKey("employeeTypeID", "EmployeeType", "id");
    departmentTable.addForeignKey("companyID", "Company", "id");
  }

View Full Code Here

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

    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);
    movieTable.newStringColumn("TITLE", 255, false);
    movieTable.newStringColumn("TRAILER_NAME", 255, true);
    movieTable.create();
     movieTable.setPrimaryKey("MOVIE_ID");

View Full Code Here

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

    plotSummaryTable.newStringColumn("SUMMARY", 10000000, true);
    plotSummaryTable.create();
     plotSummaryTable.setPrimaryKey("MOVIE_ID");


    ERXMigrationTable studioTable = database.newTableNamed("studio");
    studioTable.newBigDecimalColumn("BUDGET", 15, 2, false);
    studioTable.newStringColumn("NAME", 40, false);
    studioTable.newIntegerColumn("STUDIO_ID", false);
    studioTable.create();
     studioTable.setPrimaryKey("STUDIO_ID");

View Full Code Here

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

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

View Full Code Here

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

    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();
     rentalTermsTable.setPrimaryKey("RENTAL_TERMS_ID");

View Full Code Here

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

     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();
     rentalTermsTable.setPrimaryKey("RENTAL_TERMS_ID");

View Full Code Here

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

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

View Full Code Here

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

    employeeRoleTable.setPrimaryKey("employeeId", "roleId");
    employeeRoleTable.addForeignKey("employeeId", "Employee", "id");
    employeeRoleTable.addForeignKey("roleId", "Role", "id");


    ERXMigrationTable paycheckTable = database.newTableNamed("Paycheck");
    paycheckTable.newBigDecimalColumn("amount", 38, 2, false);
    paycheckTable.newBooleanColumn("cashed", false);
    paycheckTable.newIntegerColumn("employeeID", false);
    paycheckTable.newIntegerColumn("id", false);
    paycheckTable.newTimestampColumn("paymentDate", false);
    paycheckTable.create();

View Full Code Here

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.