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

[Mike Rylander]

On Mon, Nov 8, 2010 at 3:07 PM, Peters, Michael <MRPeters at library.in.gov> wrote:
> 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.
>

Because the acq schema is entirely non-authoritative until 2.0, I
suggest we simply delete any data from this table (and others that may
suffer similar issues) during upgrade.

Thoughts, folks?

-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com