]> git.koha-community.org Git - koha.git/commit
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)
committerJulian Maurice <julian.maurice@biblibre.com>
Mon, 16 May 2016 17:18:59 +0000 (19:18 +0200)
commit401f654bd46941d0f0d3d6f4e4255268bc2abd5a
treeab9b385dddc864af543635da7763bbc846e9b322
parentbf924a0fadd846a1e179a0b5944a7e8d78c37a8e
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>
(cherry picked from commit 1960ba7e5b108ecc81ec7ac2f6303ee45f0f2c2c)
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
installer/data/mysql/kohastructure.sql