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

(-)a/installer/data/mysql/kohastructure.sql (+14 lines)
Lines 3502-3507 CREATE TABLE items_search_fields ( Link Here
3502
    ON DELETE SET NULL ON UPDATE CASCADE
3502
    ON DELETE SET NULL ON UPDATE CASCADE
3503
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3503
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3504
3504
3505
--
3506
-- Table structure for table 'audio_alerts'
3507
--
3508
3509
DROP TABLE IF EXISTS audio_alerts;
3510
CREATE TABLE audio_alerts (
3511
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3512
  precedence smallint(5) unsigned NOT NULL,
3513
  selector varchar(255) NOT NULL,
3514
  sound varchar(255) NOT NULL,
3515
  PRIMARY KEY (audio_alert_id),
3516
  KEY precedence (precedence)
3517
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3518
3505
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3519
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3506
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3520
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3507
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3521
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
Lines 41-46 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
41
('AmazonLocale','US','US|CA|DE|FR|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'),
41
('AmazonLocale','US','US|CA|DE|FR|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'),
42
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
42
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
43
('AnonymousPatron','0',NULL,'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',''),
43
('AnonymousPatron','0',NULL,'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',''),
44
('AudioAlerts','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
44
('AuthDisplayHierarchy','0','','Display authority hierarchies','YesNo'),
45
('AuthDisplayHierarchy','0','','Display authority hierarchies','YesNo'),
45
('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'),
46
('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'),
46
('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
47
('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
Lines 383-389 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
383
('SlipCSS','',NULL,'Slips CSS url.','free'),
384
('SlipCSS','',NULL,'Slips CSS url.','free'),
384
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
385
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
385
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
386
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
386
('soundon','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
387
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
387
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
388
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
388
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
389
('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
389
('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +26 lines)
Lines 9608-9613 if ( CheckVersion($DBversion) ) { Link Here
9608
    SetVersion ($DBversion);
9608
    SetVersion ($DBversion);
9609
}
9609
}
9610
9610
9611
$DBversion = "3.19.00.XXX";
9612
if ( CheckVersion($DBversion) ) {
9613
    $dbh->do(q{UPDATE systempreferences SET variable = 'AudioAlerts' WHERE variable = 'soundon'});
9614
9615
    $dbh->do(q{
9616
        CREATE TABLE audio_alerts (
9617
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9618
            precedence smallint(5) unsigned NOT NULL,
9619
            selector varchar(255) NOT NULL,
9620
            sound varchar(255) NOT NULL,
9621
            PRIMARY KEY (audio_alert_id),
9622
            KEY precedence (precedence)
9623
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9624
    });
9625
9626
    $dbh->do(q{
9627
        INSERT INTO audio_alerts VALUES
9628
        (1, 1, '.audio-alert-action', 'opening.ogg'),
9629
        (2, 2, '.audio-alert-warning', 'critical.ogg'),
9630
        (3, 3, '.audio-alert-success', 'beep.ogg');
9631
    });
9632
9633
    print "Upgrade to $DBversion done (Bug 11431 - Add additional sound options for warnings)\n";
9634
    SetVersion($DBversion);
9635
}
9636
9611
=head1 FUNCTIONS
9637
=head1 FUNCTIONS
9612
9638
9613
=head2 TableExists($table)
9639
=head2 TableExists($table)
9614
- 

Return to bug 11431