]> git.koha-community.org Git - koha.git/commit
Bug 16573: fix structure and sample data for MySQL 5.7
authorBernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Mon, 23 May 2016 20:06:01 +0000 (17:06 -0300)
committerJulian Maurice <julian.maurice@biblibre.com>
Wed, 17 Aug 2016 12:04:49 +0000 (14:04 +0200)
commit7fa5b2d97912796723f15a0b437631236ee58f3d
tree4af8ea57b5c088227474af561f80ce0599071692
parentf0cfa73b3547629a25f8c906b8df40d5b1f58535
Bug 16573: fix structure and sample data for MySQL 5.7

Web install on Ubuntu 16.04/Mysql 5.7 fails.

This patch makes small changes to make installation
possible to kohastructure.sql and some sample files.

Sample values for quotes table can't have '0000-00-00 ...' values
nor NULL values, now() is perhaps an option.

Depends on Bug 16572

To test:
1) System with MySQL 5.7, for example Ubuntu 16.05
2) Apply 16572
3) Try web install, it fails
4) Apply this and next patch
5) Try again, now it succeed

This is only for English install, i18n files needs revision
I can do that if this is accepted.

Perphaps a change is needed to updatedatabase.pl

Ammended patch, 'created_on' field on virtualshelves
can't be timestamp default null, mysql 5.5 complains
that only one timestamp column can be defined as
default not null. Changed to 'datetime' type.

Can provide followup with updatedabase change,
but need an opinion if this type change makes sense.

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit 36b2b288a7b8a39530f0a1ba7a00396206640533)
Signed-off-by: Frédéric Demians <f.demians@tamil.fr>
(cherry picked from commit 8955b1b7c56ebbcf350a57e3a794597e0ac2d70c)
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
installer/data/mysql/en/optional/sample_patrons.sql
installer/data/mysql/en/optional/sample_quotes.sql
installer/data/mysql/kohastructure.sql