@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 2 +- installer/data/mysql/updatedatabase.pl | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3594,7 +3594,7 @@ CREATE TABLE audio_alerts ( sound varchar(255) NOT NULL, PRIMARY KEY (id), KEY precedence (precedence) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -11268,11 +11268,11 @@ if ( CheckVersion($DBversion) ) { sound varchar(255) NOT NULL, PRIMARY KEY (id), KEY precedence (precedence) - ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; }); $dbh->do(q{ - INSERT INTO audio_alerts VALUES + INSERT IGNORE INTO audio_alerts VALUES (1, 1, '.audio-alert-action', 'opening.ogg'), (2, 2, '.audio-alert-warning', 'critical.ogg'), (3, 3, '.audio-alert-success', 'beep.ogg'); --