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

(-)a/installer/data/mysql/kohastructure.sql (+14 lines)
Lines 3563-3568 CREATE TABLE `additional_field_values` ( Link Here
3563
  CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3563
  CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3564
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3564
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3565
3565
3566
--
3567
-- Table structure for table 'audio_alerts'
3568
--
3569
3570
DROP TABLE IF EXISTS audio_alerts;
3571
CREATE TABLE audio_alerts (
3572
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3573
  precedence smallint(5) unsigned NOT NULL,
3574
  selector varchar(255) NOT NULL,
3575
  sound varchar(255) NOT NULL,
3576
  PRIMARY KEY (audio_alert_id),
3577
  KEY precedence (precedence)
3578
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3579
3566
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3580
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3567
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3581
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3568
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3582
/*!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 407-413 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
407
('SMSSendPassword', '', '', 'Password used to send SMS messages', 'free'),
408
('SMSSendPassword', '', '', 'Password used to send SMS messages', 'free'),
408
('SMSSendUsername', '', '', 'Username/Login used to send SMS messages', 'free'),
409
('SMSSendUsername', '', '', 'Username/Login used to send SMS messages', 'free'),
409
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
410
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
410
('soundon','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
411
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
411
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
412
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
412
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
413
('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
413
('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