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

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


    ERXMigrationTable talentTable = database.newTableNamed("talent");

View Full Code Here

    studioTable.newIntegerColumn("STUDIO_ID", false);
    studioTable.create();
     studioTable.setPrimaryKey("STUDIO_ID");


    ERXMigrationTable talentTable = database.newTableNamed("talent");
    talentTable.newStringColumn("FIRST_NAME", 20, false);
    talentTable.newStringColumn("LAST_NAME", 30, false);
    talentTable.newIntegerColumn("TALENT_ID", 9, false);
    talentTable.create();
     talentTable.setPrimaryKey("TALENT_ID");

View Full Code Here

    studioTable.create();
     studioTable.setPrimaryKey("STUDIO_ID");


    ERXMigrationTable talentTable = database.newTableNamed("talent");
    talentTable.newStringColumn("FIRST_NAME", 20, false);
    talentTable.newStringColumn("LAST_NAME", 30, false);
    talentTable.newIntegerColumn("TALENT_ID", 9, false);
    talentTable.create();
     talentTable.setPrimaryKey("TALENT_ID");


    ERXMigrationTable movieRoleTable = database.newTableNamed("movierole");

View Full Code Here

    talentTable.create();
     talentTable.setPrimaryKey("TALENT_ID");


    ERXMigrationTable movieRoleTable = database.newTableNamed("movierole");
    movieRoleTable.newIntegerColumn("MOVIE_ID", false);
    movieRoleTable.newStringColumn("ROLE_NAME", 30, true);
    movieRoleTable.newIntegerColumn("TALENT_ID", false);
    movieRoleTable.create();
     movieRoleTable.setPrimaryKey("TALENT_ID", "MOVIE_ID");


    ERXMigrationTable reviewTable = database.newTableNamed("review");

View Full Code Here

    movieRoleTable.create();
     movieRoleTable.setPrimaryKey("TALENT_ID", "MOVIE_ID");


    ERXMigrationTable reviewTable = database.newTableNamed("review");
    reviewTable.newIntegerColumn("MOVIE_ID", false);
    reviewTable.newStringColumn("REVIEW", 10000000, true);
    reviewTable.newStringColumn("REVIEWER", 50, true);
    reviewTable.newIntegerColumn("REVIEW_ID", false);
    reviewTable.create();
     reviewTable.setPrimaryKey("REVIEW_ID");

View Full Code Here

     movieRoleTable.setPrimaryKey("TALENT_ID", "MOVIE_ID");


    ERXMigrationTable reviewTable = database.newTableNamed("review");
    reviewTable.newIntegerColumn("MOVIE_ID", false);
    reviewTable.newStringColumn("REVIEW", 10000000, true);
    reviewTable.newStringColumn("REVIEWER", 50, true);
    reviewTable.newIntegerColumn("REVIEW_ID", false);
    reviewTable.create();
     reviewTable.setPrimaryKey("REVIEW_ID");
     
    ERXMigrationTable userTable = database.newTableNamed("rentalsuser");

View Full Code Here

     reviewTable.setPrimaryKey("REVIEW_ID");
     
    ERXMigrationTable userTable = database.newTableNamed("rentalsuser");
    userTable.newIntegerColumn("ACCESS_LEVEL", false);
    userTable.newIntegerColumn("CUSTOMER_ID", true);
    userTable.newStringColumn("PASSWORD", 20, false);
    userTable.newIntegerColumn("USER_ID", false);
    userTable.newStringColumn("LOGIN", 20, false);
    userTable.create();
     userTable.setPrimaryKey("USER_ID");

View Full Code Here

    ERXMigrationTable userTable = database.newTableNamed("rentalsuser");
    userTable.newIntegerColumn("ACCESS_LEVEL", false);
    userTable.newIntegerColumn("CUSTOMER_ID", true);
    userTable.newStringColumn("PASSWORD", 20, false);
    userTable.newIntegerColumn("USER_ID", false);
    userTable.newStringColumn("LOGIN", 20, false);
    userTable.create();
     userTable.setPrimaryKey("USER_ID");


    ERXMigrationTable rentalTable = database.newTableNamed("rental");
    rentalTable.newIntegerColumn("CUSTOMER_ID", false);

View Full Code Here

    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


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

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.