Hmm, how could that be? It actually added some tables before it choked.
James
On Nov 4, 2011, at 2:30 PM, Chuck Hill wrote:
> DB plugin not added to project.
>
>
> On 2011-11-04, at 12:15 PM, James Cicenia wrote:
>
>> Hello -
>>
>> I am developing another D2WApp and using Migrations from the very start.
>>
>> However, when I first start my application I get this error:
>>
>> Executing alter table ERAttachment null available VARCHAR(5) NOT NULL
>>
>> I am using ERAttachment and here is my migration file:
>>
>> Anything seem obvious?
>>
>> James
>>
>>
>> ==============
>> package com.jimijon.mwf.migrations;
>>
>>
>> import com.webobjects.eocontrol.EOEditingContext;
>> import com.webobjects.foundation.NSArray;
>>
>> import er.extensions.jdbc.ERXSQLHelper.ColumnIndex;
>> import er.extensions.migration.ERXMigrationDatabase;
>> import er.extensions.migration.ERXMigrationIndex;
>> import er.extensions.migration.ERXMigrationTable;
>> import er.extensions.migration.ERXModelVersion;
>>
>> public class MidwestFoodsModel0 extends ERXMigrationDatabase.Migration {
>> @Override
>> public NSArray<ERXModelVersion> modelDependencies() {
>> return null;
>> }
>>
>> @Override
>> public void downgrade(EOEditingContext editingContext,
>> ERXMigrationDatabase database) throws Throwable {
>> // DO NOTHING
>> }
>>
>> @Override
>> public void upgrade(EOEditingContext editingContext,
>> ERXMigrationDatabase database) throws Throwable {
>> ERXMigrationTable foodFamilyTable =
>> database.newTableNamed("food_family");
>> foodFamilyTable.newTimestampColumn("add_date", true);
>> foodFamilyTable.newIntegerColumn("id", false);
>> foodFamilyTable.newIntegerColumn("main_image_erattachment_id",
>> true);
>> foodFamilyTable.newTimestampColumn("mod_date", true);
>> foodFamilyTable.newStringColumn("name", 255, false);
>> foodFamilyTable.newIntegerColumn("thumbnail_erattachment_id",
>> true);
>> foodFamilyTable.create();
>> foodFamilyTable.setPrimaryKey("id");
>>
>> ERXMigrationTable foodItemTable =
>> database.newTableNamed("food_item");
>> foodItemTable.newTimestampColumn("add_date", true);
>> foodItemTable.newStringColumn("availability_status", 50, true);
>> foodItemTable.newStringColumn("food_family", 100, true);
>> foodItemTable.newStringColumn("fruit_or_vegetable_type", 100,
>> true);
>> foodItemTable.newIntegerColumn("id", false);
>> foodItemTable.newIntegerColumn("main_image_erattachment_id",
>> true);
>> foodItemTable.newTimestampColumn("mod_date", true);
>> foodItemTable.newStringColumn("name", 100, false);
>> foodItemTable.newBigDecimalColumn("price", 38, 4, true);
>> foodItemTable.newStringColumn("price_status", 50, false);
>> foodItemTable.newStringColumn("quality_status", 50, false);
>> foodItemTable.newBooleanColumn("seasonal_second_half_sep",
>> true);
>> foodItemTable.newStringColumn("sku", 50, true);
>> foodItemTable.newIntegerColumn("thumbnail_erattachment_id",
>> true);
>> foodItemTable.create();
>> foodItemTable.setPrimaryKey("id");
>>
>> ERXMigrationTable newsItemTable =
>> database.newTableNamed("news_item");
>> newsItemTable.newTimestampColumn("add_date", true);
>> newsItemTable.newDateColumn("entryDate", false);
>> newsItemTable.newIntegerColumn("food_family_id", false);
>> newsItemTable.newIntegerColumn("food_item_id", true);
>> newsItemTable.newIntegerColumn("id", false);
>> newsItemTable.newTimestampColumn("mod_date", true);
>> newsItemTable.newStringColumn("name", 255, false);
>> newsItemTable.create();
>> newsItemTable.setPrimaryKey("id");
>>
>> foodFamilyTable.addForeignKey("main_image_erattachment_id",
>> "ERAttachment", "id");
>> foodFamilyTable.addForeignKey("thumbnail_erattachment_id",
>> "ERAttachment", "id");
>> foodItemTable.addForeignKey("main_image_erattachment_id",
>> "ERAttachment", "id");
>> foodItemTable.addForeignKey("thumbnail_erattachment_id",
>> "ERAttachment", "id");
>> newsItemTable.addForeignKey("food_family_id", "food_family",
>> "id");
>> newsItemTable.addForeignKey("food_item_id", "food_item", "id");
>> }
>> }
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list ([email protected])
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>
>> This email sent to [email protected]
>
> --
> Chuck Hill Senior Consultant / VP Development
>
> Practical WebObjects - for developers who want to increase their overall
> knowledge of WebObjects or who are trying to solve specific problems.
> http://www.global-village.net/products/practical_webobjects
>
>
>
>
>
>
>
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
