[OPEN-ILS-DEV] Proposed modification to 1.6.0.4-1.6.1.0-upgrade-db.sql

[Peters, Michael]

Hi all,

In working through the process of updating a 1.6.0.0 test server to 2.0 Alpha 5 I ran across a problem with this particular upgrade.  It was impossible for me to excute line 531 of the old script:

ALTER TABLE acq.purchase_order ADD COLUMN name TEXT NOT NULL;

I modified line 531 to first give the name column an empty string for a name, then later added the "NOT NULL" constraint on this column via the new line 532.

Thanks to atz for helping me catch this!

Sincerely,
Michael Peters
Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
office - 317.234.2128
email - mrpeters at library.in.gov<mailto:mrpeters at library.in.gov>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20101108/6b96f87e/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 1.6.0.4-1.6.1.0-upgrade-db.sql
Type: application/octet-stream
Size: 33366 bytes
Desc: 1.6.0.4-1.6.1.0-upgrade-db.sql
Url : http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20101108/6b96f87e/attachment-0001.obj