Bug 13149: Fix sequence of fields in sysprefs.sql
authorKatrin Fischer <Katrin.Fischer.83@web.de>
Mon, 27 Oct 2014 18:22:26 +0000 (19:22 +0100)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Tue, 28 Oct 2014 13:21:43 +0000 (10:21 -0300)
commit9f989999b79a765cb2177c049d6f6ea547a6300c
tree160475ad1500144215851ca82df791c835346490
parentab5f1d73ad872afe9b45bfae59fd9d7011d40eee
Bug 13149: Fix sequence of fields in sysprefs.sql

The sequence of fields in the SQL statement didn't
match correctly.

Test plan:
- Run the web installer on an empty database
- Make sure no SQL errors are shown
- Check the systempreferences table in your database,
  especially all UsageStats*
- Make sure the explanations are in explanation etc.

Alternatively:
- Save your database
- truncate systempreferences;
- Load the sql file sysprefs.sql
- Verfiy as above

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Tested creating new database, then loading kohastructure and sysprefs.sql
Without patch sysprefs fails to load, with patch loads Ok!
No koha-qa errors

Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
installer/data/mysql/sysprefs.sql