List of newBlobColumn() Examples

Examples of newBlobColumn()

er.extensions.migration.ERXMigrationTable.newBlobColumn()
Returns a new Blob 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.newBlobColumn()

    attachmentTable.newStringColumn("originalFileName", 255, false);
    attachmentTable.newIntegerColumn("parentID", true);
    attachmentTable.newStringColumn("proxied", 5, false);
    attachmentTable.newIntegerColumn(ERXProperties.stringForKeyWithDefault("er.extensions.ERXModelGroup.ERAttachment.size.columnName", "size"), false);
    attachmentTable.newStringColumn("storageType", 10, true);
    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);

View Full Code Here

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

    attachmentTable.create();
    attachmentTable.setPrimaryKey("id");
    attachmentTable.addUniqueIndex("ERAttachmentWebPath", "webPath", 1000);


    ERXMigrationTable attachmentDataTable = database.newTableNamed("ERAttachmentData");
    attachmentDataTable.newBlobColumn("data", true);
    attachmentDataTable.newIntegerColumn("id", false);
    attachmentDataTable.create();
    attachmentDataTable.setPrimaryKey("id");


    attachmentTable.addForeignKey("attachmentDataID", "ERAttachmentData", "id");

View Full Code Here

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


  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    
    ERXMigrationTable talentPhotoTable = database.newTableNamed("talentphoto");
    talentPhotoTable.newBlobColumn("PHOTO", true);
    talentPhotoTable.newIntegerColumn("TALENT_ID", false);
    talentPhotoTable.create();
     talentPhotoTable.setPrimaryKey("TALENT_ID");


    ERXMigrationTable directorTable = database.newTableNamed("director");

View Full Code Here

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


    @Override
    public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
        
        ERXMigrationTable eRCAuditBlobTable = database.newTableNamed("ERCAuditBlob");
        eRCAuditBlobTable.newBlobColumn("BLOB_VALUE", NOT_NULL);
        eRCAuditBlobTable.newIntegerColumn("ID", NOT_NULL);
        eRCAuditBlobTable.create();
        eRCAuditBlobTable.setPrimaryKey("ID");


        ERXMigrationTable eRCAuditTrailTable = database.newTableNamed("ERCAuditTrail");

View Full Code Here

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

        eRCAuditTrailEntryTable.newIntegerColumn("OLD_BLOB_VALUE_ID", ALLOWS_NULL);
        eRCAuditTrailEntryTable.newStringColumn("OLD_VALUES", 1000, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newIntegerColumn("TRAIL_ID", NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("TYPE", 50, NOT_NULL);
        eRCAuditTrailEntryTable.newStringColumn("USER_GLOBAL_ID", 255, ALLOWS_NULL);
        eRCAuditTrailEntryTable.newBlobColumn("USER_INFO", ALLOWS_NULL);
        eRCAuditTrailEntryTable.create();
        eRCAuditTrailEntryTable.setPrimaryKey("ID");
        eRCAuditTrailEntryTable.addForeignKey("NEW_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("OLD_BLOB_VALUE_ID", "ERCAuditBlob", "id");
        eRCAuditTrailEntryTable.addForeignKey("TRAIL_ID", "ERCAuditTrail", "id");

View Full Code Here

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

  @Override
  public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable {
    ERXMigrationTable erSessionInfoTable = database.newTableNamed("ERSessionInfo");
    erSessionInfoTable.newTimestampColumn("expirationDate", false);
    erSessionInfoTable.newIntegerColumn("intLock", false);
    erSessionInfoTable.newBlobColumn("sessionData", false);
    erSessionInfoTable.newStringColumn("sessionID", 50, false);




    erSessionInfoTable.create();
     erSessionInfoTable.setPrimaryKey("sessionID");

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.