From 0c0da40477167c6f597fd1463dc0363c69ff9f17 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 Signed-off-by: Michal Denar --- installer/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 a2871be..c9128ca 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.1.4