Upgrading ERAttachment to version 0 with migration 'er.attachment.migrations.ERAttachment0@5c66b06b'
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing CREATE TABLE ERAttachment(attachmentDataID INTEGER, configurationName VARCHAR(100), filesystemPath VARCHAR(255), height INTEGER, id INTEGER NOT NULL, mimeType VARCHAR(100) NOT NULL, originalFileName VARCHAR(255) NOT NULL, ownerID VARCHAR(16), parentID INTEGER, proxied VARCHAR(5) NOT NULL, s3Path VARCHAR(1000), size INTEGER NOT NULL, smallData LONG VARBINARY, storageType VARCHAR(10), thumbnail VARCHAR(10), webPath VARCHAR(1000) NOT NULL, width INTEGER)
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE ERAttachment ADD PRIMARY KEY (id)
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE `ERAttachment` ADD UNIQUE `ERAttachmentWebPath` (`webPath`(255))
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing CREATE TABLE ERAttachmentData(data LONG VARBINARY, id INTEGER NOT NULL)
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE ERAttachmentData ADD PRIMARY KEY (id)
Nov 04 14:10:03 MidwestFoodsWeb[65241] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE ERAttachment ADD CONSTRAINT ERAttachment_attachmentDataID_id_FK FOREIGN KEY (attachmentDataID) REFERENCES ERAttachmentData (id)
Nov 04 14:10:03 MidwestFoodsWeb[65241] DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE _dbupdater SET version = ? WHERE modelname = ?" withBindings: 1:0(version), 2:"ERAttachment"(modelName)>
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] INFO er.extensions.migration.ERXMigrator - ERAttachment is now version 0
==== >> PERFECT !! SO FAR
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE _dbupdater SET lockowner = NULL, updatelock = ? WHERE modelname = ?" withBindings: 1:0(updateLock), 2:"ERAttachment"(modelName)>
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - Using JDBCPlugIn 'com.webobjects.jdbcadaptor.MySQLPlugIn' for JDBCAdaptor@909751202
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE _dbupdater SET lockowner = ?, updatelock = ? WHERE (modelname = ? AND (updatelock = ? OR lockowner = ?))" withBindings: 1:"MidwestFoodsWeb-James-iMac-2.local:-1"(lockOwner), 2:1(updateLock), 3:"ERAttachment"(modelName), 4:0(updateLock), 5:"MidwestFoodsWeb-James-iMac-2.local:-1"(lockOwner)>
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Commit Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - === Begin Internal Transaction
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT t0.version FROM _dbupdater t0 WHERE t0.modelname = ?" withBindings: 1:"ERAttachment"(modelName)>
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - fetch canceled
Nov 04 14:10:04 MidwestFoodsWeb[65241] DEBUG NSLog - 1 row(s) processed
==== >>>>>> NOW WHY THIS?!!
Nov 04 14:10:04 MidwestFoodsWeb[65241] INFO er.extensions.migration.ERXMigrator - Upgrading ERAttachment to version 1 with migration 'er.attachment.migrations.ERAttachment1@35f784d7'