Bug 14246: Add borrowernumber, altered SQL
authorMartin Persson <xarragon@gmail.com>
Wed, 27 May 2015 05:36:33 +0000 (07:36 +0200)
committerTomas Cohen Arazi <tomascohen@theke.io>
Tue, 27 Oct 2015 18:56:24 +0000 (15:56 -0300)
commitb3721f71ea084234d67c8671d2314ca4861b2c77
treece42c98f04f8a965403bc69ac147a46da5e4c3a7
parent34818c05d561d0caf02f432129c455bf20e1e69d
Bug 14246: Add borrowernumber, altered SQL

As suggested by kind reviewers, an AFTER statement was added to the atomic
upgrade script to ensure that the final field order is consistent is both
fresh and upgraded databases.

Also:
* UPDATE action changed to CASCADE to improve robustness.

Test plan:
* Apply first patch in this set.
* Apply this patch.
* Perform a database upgrade.
* Use mysql client to inspect field order.
  It should be identical to the kohastructure.sql order.

Sponsored-by: Halland County Library
Signed-off-by: Nick Clemens <nick@quecheelibrary.org>
Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bug_14246-add_news_author.sql
installer/data/mysql/kohastructure.sql