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

(-)a/installer/data/mysql/kohastructure.sql (+14 lines)
Lines 3536-3541 CREATE TABLE discharges ( Link Here
3536
  CONSTRAINT borrower_discharges_ibfk1 FOREIGN KEY (borrower) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3536
  CONSTRAINT borrower_discharges_ibfk1 FOREIGN KEY (borrower) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3537
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3537
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3538
3538
3539
--
3540
-- Table structure for table 'audio_alerts'
3541
--
3542
3543
DROP TABLE IF EXISTS audio_alerts;
3544
CREATE TABLE audio_alerts (
3545
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3546
  precedence smallint(5) unsigned NOT NULL,
3547
  selector varchar(255) NOT NULL,
3548
  sound varchar(255) NOT NULL,
3549
  PRIMARY KEY (audio_alert_id),
3550
  KEY precedence (precedence)
3551
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3552
3539
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3553
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3540
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3554
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3541
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3555
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
Lines 40-45 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
40
('AmazonLocale','US','US|CA|DE|FR|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'),
40
('AmazonLocale','US','US|CA|DE|FR|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'),
41
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
41
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
42
('AnonymousPatron','0',NULL,'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',''),
42
('AnonymousPatron','0',NULL,'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',''),
43
('AudioAlerts','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
43
('AuthDisplayHierarchy','0','','Display authority hierarchies','YesNo'),
44
('AuthDisplayHierarchy','0','','Display authority hierarchies','YesNo'),
44
('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'),
45
('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'),
45
('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
46
('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
Lines 399-405 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
399
('SlipCSS','',NULL,'Slips CSS url.','free'),
400
('SlipCSS','',NULL,'Slips CSS url.','free'),
400
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
401
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
401
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
402
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
402
('soundon','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
403
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
403
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
404
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
404
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
405
('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
405
('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 9670-9676 if ( CheckVersion($DBversion) ) { Link Here
9670
        });
9670
        });
9671
        print "Upgrade to $DBversion done (Bug 1861: Unique patrons logins not (totally) enforced)\n";
9671
        print "Upgrade to $DBversion done (Bug 1861: Unique patrons logins not (totally) enforced)\n";
9672
    }
9672
    }
9673
    SetVersion ($DBversion);
9674
}
9675
9676
$DBversion = "3.19.00.XXX";
9677
if ( CheckVersion($DBversion) ) {
9678
    $dbh->do(q{UPDATE systempreferences SET variable = 'AudioAlerts' WHERE variable = 'soundon'});
9679
9680
    $dbh->do(q{
9681
        CREATE TABLE audio_alerts (
9682
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9683
            precedence smallint(5) unsigned NOT NULL,
9684
            selector varchar(255) NOT NULL,
9685
            sound varchar(255) NOT NULL,
9686
            PRIMARY KEY (audio_alert_id),
9687
            KEY precedence (precedence)
9688
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9689
    });
9690
9691
    $dbh->do(q{
9692
        INSERT INTO audio_alerts VALUES
9693
        (1, 1, '.audio-alert-action', 'opening.ogg'),
9694
        (2, 2, '.audio-alert-warning', 'critical.ogg'),
9695
        (3, 3, '.audio-alert-success', 'beep.ogg');
9696
    });
9673
9697
9698
    print "Upgrade to $DBversion done (Bug 11431 - Add additional sound options for warnings)\n";
9674
    SetVersion($DBversion);
9699
    SetVersion($DBversion);
9675
}
9700
}
9676
9701
9677
- 

Return to bug 11431