@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl +++ a/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}); --