Bugzilla – Attachment 44392 Details for
Bug 11431
Custom notification sounds
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11431 [1] - Update database
Bug-11431-1---Update-database.patch (text/plain), 4.72 KB, created by
Kyle M Hall (khall)
on 2015-11-04 15:15:11 UTC
(
hide
)
Description:
Bug 11431 [1] - Update database
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2015-11-04 15:15:11 UTC
Size:
4.72 KB
patch
obsolete
>From 5c9f430f8d34910fdef416789857af47294ab8eb Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Mon, 22 Dec 2014 05:56:33 -0500 >Subject: [PATCH] Bug 11431 [1] - Update database > >Signed-off-by: Nick Clemens <nick@quecheelibrary.org> > >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > installer/data/mysql/kohastructure.sql | 14 ++++++++++++++ > installer/data/mysql/sysprefs.sql | 2 +- > installer/data/mysql/updatedatabase.pl | 25 +++++++++++++++++++++++++ > 3 files changed, 40 insertions(+), 1 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 12b7924..6cc0133 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3581,6 +3581,20 @@ CREATE TABLE `localization` ( > UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >+-- >+-- Table structure for table 'audio_alerts' >+-- >+ >+DROP TABLE IF EXISTS audio_alerts; >+CREATE TABLE audio_alerts ( >+ audio_alert_id int(11) NOT NULL AUTO_INCREMENT, >+ precedence smallint(5) unsigned NOT NULL, >+ selector varchar(255) NOT NULL, >+ sound varchar(255) NOT NULL, >+ PRIMARY KEY (audio_alert_id), >+ KEY precedence (precedence) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ > /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; > /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; > /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index cb77b7d..2e4a019 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -40,6 +40,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('AmazonLocale','US','US|CA|DE|FR|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'), > ('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'), > ('AnonymousPatron','0',NULL,'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',''), >+('AudioAlerts','0','','Enable circulation sounds during checkin and checkout in the staff interface. Not supported by all web browsers yet.','YesNo'), > ('AuthDisplayHierarchy','0','','Display authority hierarchies','YesNo'), > ('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'), > ('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'), >@@ -410,7 +411,6 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('SMSSendPassword', '', '', 'Password used to send SMS messages', 'free'), > ('SMSSendUsername', '', '', 'Username/Login used to send SMS messages', 'free'), > ('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'), >-('soundon','0','','Enable circulation sounds during checkin and checkout in the staff interface. Not supported by all web browsers yet.','YesNo'), > ('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','YesNo'), > ('SpecifyReturnDate',1,'','Define whether to display \"Specify Return Date\" form in Circulation','YesNo'), > ('SpineLabelAutoPrint','0','','If this setting is turned on, a print dialog will automatically pop up for the quick spine label printer.','YesNo'), >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 5e1bff4..b530128 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -9669,7 +9669,32 @@ if ( CheckVersion($DBversion) ) { > }); > print "Upgrade to $DBversion done (Bug 1861: Unique patrons logins not (totally) enforced)\n"; > } >+ SetVersion ($DBversion); >+} >+ >+$DBversion = "3.19.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do(q{UPDATE systempreferences SET variable = 'AudioAlerts' WHERE variable = 'soundon'}); >+ >+ $dbh->do(q{ >+ CREATE TABLE audio_alerts ( >+ audio_alert_id int(11) NOT NULL AUTO_INCREMENT, >+ precedence smallint(5) unsigned NOT NULL, >+ selector varchar(255) NOT NULL, >+ sound varchar(255) NOT NULL, >+ PRIMARY KEY (audio_alert_id), >+ KEY precedence (precedence) >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ }); >+ >+ $dbh->do(q{ >+ INSERT INTO audio_alerts VALUES >+ (1, 1, '.audio-alert-action', 'opening.ogg'), >+ (2, 2, '.audio-alert-warning', 'critical.ogg'), >+ (3, 3, '.audio-alert-success', 'beep.ogg'); >+ }); > >+ print "Upgrade to $DBversion done (Bug 11431 - Add additional sound options for warnings)\n"; > SetVersion($DBversion); > } > >-- >1.7.2.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 11431
:
29030
|
29031
|
29032
|
29033
|
29034
|
29035
|
29036
|
29037
|
29038
|
29039
|
29119
|
29120
|
29404
|
29764
|
29765
|
29766
|
29767
|
29768
|
29769
|
31145
|
31146
|
31147
|
31148
|
31149
|
31150
|
34637
|
34638
|
34639
|
34640
|
34641
|
34642
|
34643
|
34644
|
34645
|
34646
|
34647
|
34648
|
34649
|
34650
|
34651
|
34652
|
34653
|
34717
|
34718
|
34719
|
34720
|
34864
|
34865
|
34866
|
34867
|
35843
|
35844
|
35845
|
35846
|
38547
|
38548
|
40726
|
40727
|
40728
|
40729
|
40730
|
40731
|
40732
|
41634
|
41661
|
41662
|
42678
|
42679
|
42680
|
42681
|
42682
|
42683
|
42684
|
42685
|
42686
|
42687
|
42688
|
42689
|
42696
|
43753
|
43754
|
43755
|
43756
|
43757
|
43758
|
43759
|
43760
|
43761
|
43762
|
43763
|
43764
|
43765
|
43817
|
43820
|
43821
|
43822
|
43823
|
43824
|
43825
|
43887
|
43888
|
43889
|
43890
|
43891
|
43892
|
43893
|
43894
|
43895
|
43896
|
43897
|
43898
|
43899
|
43900
|
43901
|
43902
|
43903
|
44391
| 44392 |
44393
|
44394
|
44395
|
44396
|
44397
|
44398
|
44399
|
44400
|
44401
|
44402
|
44404
|
44405
|
44407
|
44408
|
44409
|
44411
|
44412
|
44599
|
45135