Bug 11562: re-sort sysprefs.sql
authorJonathan Druart <jonathan.druart@biblibre.com>
Wed, 15 Jan 2014 15:24:00 +0000 (16:24 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Wed, 21 May 2014 08:34:58 +0000 (10:34 +0200)
commit1bfb679a084aadabcee0c51dd2828da8746baba3
tree58718fe043393d20d75c4453b25820f2f2db6172
parentfdeb2a0cad0b686617d8376842408bb437fa26c4
Bug 11562: re-sort sysprefs.sql

The QA tools does not manage to catch error sorting on the sysprefs.sql
file if it is already badly sorted.

This patch tidies up the sysprefs file.

TEST PLAN
---------
[1] Verify that loading sysprefs.sql into an empty Koha
    database (or one whose system preferences table is
    is empty) works.

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
RM note: I must point out that there ZERO functionality associated
with the order that system preferences occur in that SQL script; they are
sorted solely in an attempt to reduce the likelihood of merge conflicts
during the development process.  Consequently, I dislike language that
suggests it is an "error" if sysprefs.sql happens to not be perfectly
sorted; it is at most an inconvenience.

(cherry picked from commit 988dc3b64af00d34f535b811f4093782ac7925a1)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/sysprefs.sql