Bug 22634: Standardize table creation for stockrotation* tables in kohastructure.sql
authorKatrin Fischer <katrin.fischer.83@web.de>
Wed, 3 Apr 2019 20:35:38 +0000 (22:35 +0200)
committerNick Clemens <nick@bywatersolutions.com>
Thu, 11 Apr 2019 13:34:09 +0000 (13:34 +0000)
commitfbdb2b2be009140be6f9b5b84c765741bc828a3c
tree9171eb2e36e8ac0ef1742632b23ada5b0cb289c8
parentb215c7d55195a4912fb3ab585aba6ee44581f746
Bug 22634: Standardize table creation for stockrotation* tables in kohastructure.sql

The existing pattern is:
DROP TABLE IF EXISTS ...
CRATE TABLE

Stockrotation was using:
CREATE TABLE IF NOT EXISTS ...
which would not recreate the table in a database it's already
existing in possibly causing mismatches in table structure.

To test:
- Drop your database
- Run through the web installer
- Make sure there are no Database/SQL errors
- Makse sure the 4 stockrotation tables have been created

Signed-off-by: Frédéric Demians <f.demians@tamil.fr>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
installer/data/mysql/kohastructure.sql