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

(-)a/installer/data/mysql/kohastructure.sql (+14 lines)
Lines 3504-3509 CREATE TABLE items_search_fields ( Link Here
3504
    ON DELETE SET NULL ON UPDATE CASCADE
3504
    ON DELETE SET NULL ON UPDATE CASCADE
3505
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3505
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3506
3506
3507
--
3508
-- Table structure for table 'audio_alerts'
3509
--
3510
3511
DROP TABLE IF EXISTS audio_alerts;
3512
CREATE TABLE audio_alerts (
3513
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3514
  precedence smallint(5) unsigned NOT NULL,
3515
  selector varchar(255) NOT NULL,
3516
  sound varchar(255) NOT NULL,
3517
  PRIMARY KEY (audio_alert_id),
3518
  KEY precedence (precedence)
3519
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3520
3507
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3521
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3508
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3522
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3509
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3523
/*!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 384-390 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
384
('SlipCSS','',NULL,'Slips CSS url.','free'),
385
('SlipCSS','',NULL,'Slips CSS url.','free'),
385
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
386
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
386
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
387
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
387
('soundon','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
388
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
388
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
389
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
389
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
390
('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
390
('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 / +25 lines)
Lines 9624-9630 if ( CheckVersion($DBversion) ) { Link Here
9624
        });
9624
        });
9625
        print "Upgrade to $DBversion done (Bug 1861 - Unique patrons logins not (totally) enforced)\n";
9625
        print "Upgrade to $DBversion done (Bug 1861 - Unique patrons logins not (totally) enforced)\n";
9626
    }
9626
    }
9627
    SetVersion ($DBversion);
9628
}
9629
9630
$DBversion = "3.19.00.XXX";
9631
if ( CheckVersion($DBversion) ) {
9632
    $dbh->do(q{UPDATE systempreferences SET variable = 'AudioAlerts' WHERE variable = 'soundon'});
9633
9634
    $dbh->do(q{
9635
        CREATE TABLE audio_alerts (
9636
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9637
            precedence smallint(5) unsigned NOT NULL,
9638
            selector varchar(255) NOT NULL,
9639
            sound varchar(255) NOT NULL,
9640
            PRIMARY KEY (audio_alert_id),
9641
            KEY precedence (precedence)
9642
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9643
    });
9644
9645
    $dbh->do(q{
9646
        INSERT INTO audio_alerts VALUES
9647
        (1, 1, '.audio-alert-action', 'opening.ogg'),
9648
        (2, 2, '.audio-alert-warning', 'critical.ogg'),
9649
        (3, 3, '.audio-alert-success', 'beep.ogg');
9650
    });
9627
9651
9652
    print "Upgrade to $DBversion done (Bug 11431 - Add additional sound options for warnings)\n";
9628
    SetVersion($DBversion);
9653
    SetVersion($DBversion);
9629
}
9654
}
9630
9655
9631
- 

Return to bug 11431