Bug 13577: Add the utf8_unicode_ci COLLATE to all tables
authorJonathan Druart <jonathan.druart@biblibre.com>
Wed, 14 Jan 2015 08:54:40 +0000 (09:54 +0100)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Sat, 17 Jan 2015 13:28:44 +0000 (10:28 -0300)
commit9820e40f5d44e3094e253ed9edbf6f45cd2b2c17
treec5b70d0237d50d21895b0a137d85a77b0de0a3ba
parented7221102fec439997ebba14e4f061dfd8e3808b
Bug 13577: Add the utf8_unicode_ci COLLATE to all tables

Bug 11944 added the COLLATE=utf8_unicode_ci to all DB tables.
But some new tables have been created between the write of the patch set
and the push to master.
So these new tables don't have the correct collate.

Test plan:
0/ Reproduce the error:
mysql> create database koha_test CHARACTER SET utf8 COLLATE utf8_unicode_ci;
mysql koha_test < installer/data/mysql/kohastructure.sql

It will boom with:
ERROR 1005 (HY000) at line 3493: Can't create table `koha_test`.`items_search_fields`
(errno: 150 "Foreign key constraint is incorrectly formed")

1/ Apply the patch, destroy the DB and recreate it:
mysql> create database koha_test CHARACTER SET utf8 COLLATE utf8_unicode_ci;
mysql> drop database koha_test;
mysql koha_test < installer/data/mysql/kohastructure.sql
All tables should be inserted without any error.

Signed-off-by: Paola Rossi <paola.rossi@cineca.it>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
installer/data/mysql/kohastructure.sql