View | Details | Raw Unified | Return to bug 11431
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 3594-3600 CREATE TABLE audio_alerts ( Link Here
3594
  sound varchar(255) NOT NULL,
3594
  sound varchar(255) NOT NULL,
3595
  PRIMARY KEY (id),
3595
  PRIMARY KEY (id),
3596
  KEY precedence (precedence)
3596
  KEY precedence (precedence)
3597
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3597
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3598
3598
3599
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3599
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3600
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3600
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 11268-11278 if ( CheckVersion($DBversion) ) { Link Here
11268
            sound varchar(255) NOT NULL,
11268
            sound varchar(255) NOT NULL,
11269
            PRIMARY KEY (id),
11269
            PRIMARY KEY (id),
11270
            KEY precedence (precedence)
11270
            KEY precedence (precedence)
11271
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11271
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
11272
    });
11272
    });
11273
11273
11274
    $dbh->do(q{
11274
    $dbh->do(q{
11275
        INSERT INTO audio_alerts VALUES
11275
        INSERT IGNORE INTO audio_alerts VALUES
11276
        (1, 1, '.audio-alert-action', 'opening.ogg'),
11276
        (1, 1, '.audio-alert-action', 'opening.ogg'),
11277
        (2, 2, '.audio-alert-warning', 'critical.ogg'),
11277
        (2, 2, '.audio-alert-warning', 'critical.ogg'),
11278
        (3, 3, '.audio-alert-success', 'beep.ogg');
11278
        (3, 3, '.audio-alert-success', 'beep.ogg');
11279
- 

Return to bug 11431