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

    attachmentTable.newBlobColumn("smallData", true);
    attachmentTable.newStringColumn("thumbnail", 10, true);
    attachmentTable.newStringColumn("webPath", 1000, false);
    attachmentTable.newIntegerColumn("width", true);
    attachmentTable.newIntegerColumn("attachmentDataID", true);
    attachmentTable.newStringColumn("filesystemPath", 255, true);
    attachmentTable.newStringColumn("s3Path", 1000, true);
    attachmentTable.create();
    attachmentTable.setPrimaryKey("id");
    attachmentTable.addUniqueIndex("ERAttachmentWebPath", "webPath", 1000);

View Full Code Here

    attachmentTable.newStringColumn("thumbnail", 10, true);
    attachmentTable.newStringColumn("webPath", 1000, false);
    attachmentTable.newIntegerColumn("width", true);
    attachmentTable.newIntegerColumn("attachmentDataID", true);
    attachmentTable.newStringColumn("filesystemPath", 255, true);
    attachmentTable.newStringColumn("s3Path", 1000, true);
    attachmentTable.create();
    attachmentTable.setPrimaryKey("id");
    attachmentTable.addUniqueIndex("ERAttachmentWebPath", "webPath", 1000);


    ERXMigrationTable attachmentDataTable = database.newTableNamed("ERAttachmentData");

View Full Code Here


  @Override
  public void upgrade(EOEditingContext editingContext,
                      ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable attachmentTable = database.existingTableNamed(ERAttachment2.ER_ATTACHMENT_TABLE_NAME);
    attachmentTable.newStringColumn(CF_PATH_COLUMN_NAME, 1000, true);


  }


}

View Full Code Here


  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable tagTable = database.newTableNamed("ERTag");
    tagTable.newIntegerColumn("id", false);
    tagTable.newStringColumn("name", 255, false);
    tagTable.create();
    tagTable.setPrimaryKey("id");
    tagTable.addUniqueIndex("uniqueTagName", "name", 255);
  }
}

View Full Code Here

    votingTable.newDoubleColumn("RUNNING_AVERAGE", 20, 9, true);
    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);

View Full Code Here


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

View Full Code Here

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

View Full Code Here

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


    ERXMigrationTable plotSummaryTable = database.newTableNamed("PlotSummary");

View Full Code Here

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


    ERXMigrationTable plotSummaryTable = database.newTableNamed("PlotSummary");
    plotSummaryTable.newIntegerColumn("MOVIE_ID", 9, false);

View Full Code Here

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


    ERXMigrationTable plotSummaryTable = database.newTableNamed("PlotSummary");
    plotSummaryTable.newIntegerColumn("MOVIE_ID", 9, false);
    plotSummaryTable.newStringColumn("SUMMARY", 10000000, true);
    plotSummaryTable.create();
     plotSummaryTable.setPrimaryKey("MOVIE_ID");


    ERXMigrationTable studioTable = database.newTableNamed("studio");
    studioTable.newBigDecimalColumn("BUDGET", 15, 2, 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.