[Building Sakai] 2.4.x - 2.5.0 upgrade script

[Gerwood Stewart]

The 2.4.x - 2.5.0 upgrade script has the following line:
alter table ASSIGNMENT_SUBMISSION add SUBMITTER_ID VARCHAR2 (99) NOT NULL;

This statement won't run because there is data in the db already. There are several solutions I can think of:
Give it a default:
alter table ASSIGNMENT_SUBMISSION add SUBMITTER_ID VARCHAR2 (99) NOT NULL default '';

Or find a join that can create the data?

Has anyone encountered this and what did they do?
Is a default value of '' going to cause issues?

If so is there a way of populating for existing records. Starting from a blank table is really not an option.

Thanks
Gerwood
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090624/eaa6772b/attachment.html