kohabug 2076: updated 2.2 -> 3.0 upgrade
authorGalen Charlton <galen.charlton@liblime.com>
Mon, 5 May 2008 15:04:28 +0000 (10:04 -0500)
committerJoshua Ferraro <jmf@liblime.com>
Sun, 11 May 2008 10:40:46 +0000 (05:40 -0500)
commit5833a44771a36c53edda959fbaffe19b0406e932
tree8bdb47a66c41ed18828576ce240f5017d7cf2177
parent5c41ae54e68866f9661e853376537059f4d83f70
kohabug 2076: updated 2.2 -> 3.0 upgrade

Numerous changes to update22to30.pl to help ensure
that a database upgraded from 2.2.9 to 3.0 will have
a DB schema identical to that of a new installation.

These changes were testing by starting from an empty database,
loading koha.mysql from the 2.2.9 package, then running

update22to30.pl
move_marc_to_authheader.pl
move_marc_to_biblioitems.pl
dropping the following tables:
  marc_subfield_table
  auth_subfield_table
  marc_biblio
  marc_blob_subfield
  auth_word
  biblioanalysis
  borexp
  catalogueentry
  charges
  itemsprices
  marc_word
  marcrecorddone
  sessionqueries
  uploadedmarc
  users
  websites
  z3950queue
  z3950results
updatedatabase.pl

Signed-off-by: Joshua Ferraro <jmf@liblime.com>
installer/data/mysql/update22to30.pl