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

(-)a/installer/data/mysql/kohastructure.sql (+14 lines)
Lines 3581-3586 CREATE TABLE `localization` ( Link Here
3581
      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
3581
      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
3582
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3582
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3583
3583
3584
--
3585
-- Table structure for table 'audio_alerts'
3586
--
3587
3588
DROP TABLE IF EXISTS audio_alerts;
3589
CREATE TABLE audio_alerts (
3590
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3591
  precedence smallint(5) unsigned NOT NULL,
3592
  selector varchar(255) NOT NULL,
3593
  sound varchar(255) NOT NULL,
3594
  PRIMARY KEY (audio_alert_id),
3595
  KEY precedence (precedence)
3596
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COLLATE=utf8_unicode_ci;
3597
3584
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3598
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3585
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3599
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3586
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3600
/*!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 410-416 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
410
('SMSSendPassword', '', '', 'Password used to send SMS messages', 'free'),
411
('SMSSendPassword', '', '', 'Password used to send SMS messages', 'free'),
411
('SMSSendUsername', '', '', 'Username/Login used to send SMS messages', 'free'),
412
('SMSSendUsername', '', '', 'Username/Login used to send SMS messages', 'free'),
412
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
413
('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'),
413
('soundon','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
414
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
414
('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'),
415
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
415
('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'),
416
('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'),
416
('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 9669-9675 if ( CheckVersion($DBversion) ) { Link Here
9669
        });
9669
        });
9670
        print "Upgrade to $DBversion done (Bug 1861: Unique patrons logins not (totally) enforced)\n";
9670
        print "Upgrade to $DBversion done (Bug 1861: Unique patrons logins not (totally) enforced)\n";
9671
    }
9671
    }
9672
    SetVersion ($DBversion);
9673
}
9674
9675
$DBversion = "3.19.00.XXX";
9676
if ( CheckVersion($DBversion) ) {
9677
    $dbh->do(q{UPDATE systempreferences SET variable = 'AudioAlerts' WHERE variable = 'soundon'});
9678
9679
    $dbh->do(q{
9680
        CREATE TABLE audio_alerts (
9681
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9682
            precedence smallint(5) unsigned NOT NULL,
9683
            selector varchar(255) NOT NULL,
9684
            sound varchar(255) NOT NULL,
9685
            PRIMARY KEY (audio_alert_id),
9686
            KEY precedence (precedence)
9687
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9688
    });
9689
9690
    $dbh->do(q{
9691
        INSERT INTO audio_alerts VALUES
9692
        (1, 1, '.audio-alert-action', 'opening.ogg'),
9693
        (2, 2, '.audio-alert-warning', 'critical.ogg'),
9694
        (3, 3, '.audio-alert-success', 'beep.ogg');
9695
    });
9672
9696
9697
    print "Upgrade to $DBversion done (Bug 11431 - Add additional sound options for warnings)\n";
9673
    SetVersion($DBversion);
9698
    SetVersion($DBversion);
9674
}
9699
}
9675
9700
9676
- 

Return to bug 11431