Hi,

I've noticed that MIgrations code does not respect the default values 
specified. E.g.  Following code creates a database table called CALENDAR.

ERXMigrationTable calendarTable = database.newTableNamed("CALENDAR");
calendarTable.newStringColumn("CAL_DESC", 512, true);
calendarTable.newStringColumn("CAL_NAME", 64, false);
calendarTable.newIntegerColumn("IS_PUBLIC", false, 0);
calendarTable.newIntegerColumn("OID", false);
calendarTable.create();
calendarTable.setPrimaryKey("OID");

Technically this should set the column to set the default value to 0 for 
IS_PUBLIC column whenever a record is inserted in this table. But this is not 
the case, inspecting the table structure tells there is no default value set 
for this column and inserting a new record in this table without explicitly 
specifying the is_public value to 0, it gives Not Null sql exception.

Any comments?

Farrukh
 _______________________________________________
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]

Reply via email to