From 618ab11c71e71c21b8bf58450341bccf2010955d Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Wed, 17 Apr 2019 01:30:28 +0000 Subject: [PATCH] Bug 15516: (follow-up) Changing utf8 to utf8mb4 Signed-off-by: Michal Denar --- .../data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl b/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl index a2871bec82..c9128ca008 100644 --- a/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl +++ b/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl @@ -4,7 +4,7 @@ if( CheckVersion( $DBversion ) ) { $dbh->do(q{CREATE TABLE hold_group ( hold_group_id int unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (hold_group_id) - ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci}); + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci}); $dbh->do(q{ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL}); $dbh->do(q{ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_6 FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE}); $dbh->do(q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL}); -- 2.20.1