Bug 16402: Make kohastructure.sql valid for MySQL v5.7
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 5 May 2016 14:14:51 +0000 (15:14 +0100)
committerKyle M Hall <kyle@bywatersolutions.com>
Mon, 16 May 2016 17:07:28 +0000 (17:07 +0000)
commit1960ba7e5b108ecc81ec7ac2f6303ee45f0f2c2c
tree5c2500899bb0f98d35b08e6da824ad641dcfc1a0
parentbc707baf02c672fdd8f6d2095137694d7e400a97
Bug 16402: Make kohastructure.sql valid for MySQL v5.7

A primary key should not contain null value, and MySQL v5.7 is now more
strict and won't accept our errors in the DB structure.

Test plan:
  mysql < installer/data/mysql/kohastructure.sql
should work using MySQL v5.7

QA:
- letter.branchcode should not be NULL, the default (all) is an empty
string
- permissions.code should not be NULL, it's always a string

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Clean install of Ubuntu 16.05, MySQL 5.7.11
kohastructure.sql loads ok, just one warning
No errors

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
installer/data/mysql/kohastructure.sql