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

(-)a/installer/data/mysql/kohastructure.sql (+14 lines)
Lines 3533-3538 CREATE TABLE discharges ( Link Here
3533
  CONSTRAINT borrower_discharges_ibfk1 FOREIGN KEY (borrower) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3533
  CONSTRAINT borrower_discharges_ibfk1 FOREIGN KEY (borrower) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3534
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3534
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3535
3535
3536
--
3537
-- Table structure for table 'audio_alerts'
3538
--
3539
3540
DROP TABLE IF EXISTS audio_alerts;
3541
CREATE TABLE audio_alerts (
3542
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3543
  precedence smallint(5) unsigned NOT NULL,
3544
  selector varchar(255) NOT NULL,
3545
  sound varchar(255) NOT NULL,
3546
  PRIMARY KEY (audio_alert_id),
3547
  KEY precedence (precedence)
3548
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3549
3536
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3550
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3537
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3551
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3538
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3552
/*!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 390-396 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
390
('SlipCSS','',NULL,'Slips CSS url.','free'),
391
('SlipCSS','',NULL,'Slips CSS url.','free'),
391
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
392
('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'),
392
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
393
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
393
('soundon','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
394
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
394
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
395
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
395
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
396
('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
396
('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 9671-9677 if ( CheckVersion($DBversion) ) { Link Here
9671
        });
9671
        });
9672
        print "Upgrade to $DBversion done (Bug 1861: Unique patrons logins not (totally) enforced)\n";
9672
        print "Upgrade to $DBversion done (Bug 1861: Unique patrons logins not (totally) enforced)\n";
9673
    }
9673
    }
9674
    SetVersion ($DBversion);
9675
}
9676
9677
$DBversion = "3.19.00.XXX";
9678
if ( CheckVersion($DBversion) ) {
9679
    $dbh->do(q{UPDATE systempreferences SET variable = 'AudioAlerts' WHERE variable = 'soundon'});
9680
9681
    $dbh->do(q{
9682
        CREATE TABLE audio_alerts (
9683
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9684
            precedence smallint(5) unsigned NOT NULL,
9685
            selector varchar(255) NOT NULL,
9686
            sound varchar(255) NOT NULL,
9687
            PRIMARY KEY (audio_alert_id),
9688
            KEY precedence (precedence)
9689
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9690
    });
9691
9692
    $dbh->do(q{
9693
        INSERT INTO audio_alerts VALUES
9694
        (1, 1, '.audio-alert-action', 'opening.ogg'),
9695
        (2, 2, '.audio-alert-warning', 'critical.ogg'),
9696
        (3, 3, '.audio-alert-success', 'beep.ogg');
9697
    });
9674
9698
9699
    print "Upgrade to $DBversion done (Bug 11431 - Add additional sound options for warnings)\n";
9675
    SetVersion($DBversion);
9700
    SetVersion($DBversion);
9676
}
9701
}
9677
9702
9678
- 

Return to bug 11431