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

(-)a/Koha/Schema/Result/AudioAlert.pm (+81 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::AudioAlert;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::AudioAlert
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<audio_alerts>
19
20
=cut
21
22
__PACKAGE__->table("audio_alerts");
23
24
=head1 ACCESSORS
25
26
=head2 audio_alert_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 precedence
33
34
  data_type: 'smallint'
35
  extra: {unsigned => 1}
36
  is_nullable: 0
37
38
=head2 selector
39
40
  data_type: 'varchar'
41
  is_nullable: 0
42
  size: 255
43
44
=head2 sound
45
46
  data_type: 'varchar'
47
  is_nullable: 0
48
  size: 255
49
50
=cut
51
52
__PACKAGE__->add_columns(
53
  "audio_alert_id",
54
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
55
  "precedence",
56
  { data_type => "smallint", extra => { unsigned => 1 }, is_nullable => 0 },
57
  "selector",
58
  { data_type => "varchar", is_nullable => 0, size => 255 },
59
  "sound",
60
  { data_type => "varchar", is_nullable => 0, size => 255 },
61
);
62
63
=head1 PRIMARY KEY
64
65
=over 4
66
67
=item * L</audio_alert_id>
68
69
=back
70
71
=cut
72
73
__PACKAGE__->set_primary_key("audio_alert_id");
74
75
76
# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-12-22 01:04:21
77
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yIXpJMcpovBDl3bBVrwLqg
78
79
80
# You can replace this text with custom code or comments, and it will be preserved on regeneration
81
1;
(-)a/installer/data/mysql/de-DE/optional/audio_alerts.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO audio_alerts VALUES
2
(1, 1, '.audio-alert-action', 'opening.ogg'),
3
(2, 2, '.audio-alert-warning', 'critical.ogg'),
4
(3, 3, '.audio-alert-success', 'beep.ogg');
(-)a/installer/data/mysql/de-DE/optional/audio_alerts.txt (+1 lines)
Line 0 Link Here
1
Audio alerts
(-)a/installer/data/mysql/en/optional/audio_alerts.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO audio_alerts VALUES
2
(1, 1, '.audio-alert-action', 'opening.ogg'),
3
(2, 2, '.audio-alert-warning', 'critical.ogg'),
4
(3, 3, '.audio-alert-success', 'beep.ogg');
(-)a/installer/data/mysql/en/optional/audio_alerts.txt (+1 lines)
Line 0 Link Here
1
Audio alerts
(-)a/installer/data/mysql/es-ES/optional/audio_alerts.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO audio_alerts VALUES
2
(1, 1, '.audio-alert-action', 'opening.ogg'),
3
(2, 2, '.audio-alert-warning', 'critical.ogg'),
4
(3, 3, '.audio-alert-success', 'beep.ogg');
(-)a/installer/data/mysql/es-ES/optional/audio_alerts.txt (+1 lines)
Line 0 Link Here
1
Audio alerts
(-)a/installer/data/mysql/fr-FR/2-Optionel/audio_alerts.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO audio_alerts VALUES
2
(1, 1, '.audio-alert-action', 'opening.ogg'),
3
(2, 2, '.audio-alert-warning', 'critical.ogg'),
4
(3, 3, '.audio-alert-success', 'beep.ogg');
(-)a/installer/data/mysql/fr-FR/2-Optionel/audio_alerts.txt (+1 lines)
Line 0 Link Here
1
Audio alerts
(-)a/installer/data/mysql/kohastructure.sql (+14 lines)
Lines 3502-3507 CREATE TABLE items_search_fields ( Link Here
3502
    ON DELETE SET NULL ON UPDATE CASCADE
3502
    ON DELETE SET NULL ON UPDATE CASCADE
3503
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3503
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3504
3504
3505
--
3506
-- Table structure for table 'audio_alerts'
3507
--
3508
3509
DROP TABLE IF EXISTS audio_alerts;
3510
CREATE TABLE audio_alerts (
3511
  audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
3512
  precedence smallint(5) unsigned NOT NULL,
3513
  selector varchar(255) NOT NULL,
3514
  sound varchar(255) NOT NULL,
3515
  PRIMARY KEY (audio_alert_id),
3516
  KEY precedence (precedence)
3517
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3518
3505
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3519
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3506
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3520
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3507
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3521
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/audio_alerts.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO audio_alerts VALUES
2
(1, 1, '.audio-alert-action', 'opening.ogg'),
3
(2, 2, '.audio-alert-warning', 'critical.ogg'),
4
(3, 3, '.audio-alert-success', 'beep.ogg');
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/audio_alerts.txt (+1 lines)
Line 0 Link Here
1
Audio alerts
(-)a/installer/data/mysql/pl-PL/optional/audio_alerts.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO audio_alerts VALUES
2
(1, 1, '.audio-alert-action', 'opening.ogg'),
3
(2, 2, '.audio-alert-warning', 'critical.ogg'),
4
(3, 3, '.audio-alert-success', 'beep.ogg');
(-)a/installer/data/mysql/pl-PL/optional/audio_alerts.txt (+1 lines)
Line 0 Link Here
1
Audio alerts
(-)a/installer/data/mysql/ru-RU/optional/audio_alerts.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO audio_alerts VALUES
2
(1, 1, '.audio-alert-action', 'opening.ogg'),
3
(2, 2, '.audio-alert-warning', 'critical.ogg'),
4
(3, 3, '.audio-alert-success', 'beep.ogg');
(-)a/installer/data/mysql/ru-RU/optional/audio_alerts.txt (+1 lines)
Line 0 Link Here
1
Audio alerts
(-)a/installer/data/mysql/sysprefs.sql (-7 lines)
Lines 42-51 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
42
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
42
('AnonSuggestions','0',NULL,'Set to enable Anonymous suggestions to AnonymousPatron borrowernumber','YesNo'),
43
('AnonymousPatron','0',NULL,'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',''),
43
('AnonymousPatron','0',NULL,'Set the identifier (borrowernumber) of the anonymous patron. Used for Suggestion and reading history privacy',''),
44
('AudioAlerts','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
44
('AudioAlerts','0','','Enable circulation sounds during checkin and checkout in the staff interface.  Not supported by all web browsers yet.','YesNo'),
45
( 'AudioAlertsCustom', '', NULL, 'Custom audio alert triggers in json associative array format', 'free' ),
46
( 'AudioAlertSelectorWarning', '.audio-alert-warning', NULL, 'List of jQuery selectors that should trigger warning alert',  'free' ),
47
( 'AudioAlertSelectorAction',  '.audio-alert-action',  NULL, 'List of jQuery selectors that should trigger action alert',   'free' ),
48
( 'AudioAlertSelectorSuccess', '.audio-alert-success', NULL, 'List of jQuery selectors that should trigger successs alert', 'free' ),
49
('AuthDisplayHierarchy','0','','Display authority hierarchies','YesNo'),
45
('AuthDisplayHierarchy','0','','Display authority hierarchies','YesNo'),
50
('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'),
46
('AuthoritiesLog','1',NULL,'If ON, log edit/create/delete actions on authorities.','YesNo'),
51
('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
47
('AuthoritySeparator','--','10','Used to separate a list of authorities in a display. Usually --','free'),
Lines 331-339 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
331
('OverdueNoticeBcc','','','Email address to bcc outgoing overdue notices sent by email','free'),
327
('OverdueNoticeBcc','','','Email address to bcc outgoing overdue notices sent by email','free'),
332
('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
328
('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
333
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
329
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
334
( 'OverrideAudioAlertWarning', '', NULL, 'URL to an audio file to replace the default warning sound.',           'free' ),
335
( 'OverrideAudioAlertAction',  '', NULL, 'URL to an audio file to replace the default "action required" sound.', 'free' ),
336
( 'OverrideAudioAlertSuccess', '', NULL, 'URL to an audio file to replace the default success sound.',           'free' ),
337
('patronimages','0',NULL,'Enable patron images for the Staff Client','YesNo'),
330
('patronimages','0',NULL,'Enable patron images for the Staff Client','YesNo'),
338
('PatronSelfRegistration','0',NULL,'If enabled, patrons will be able to register themselves via the OPAC.','YesNo'),
331
('PatronSelfRegistration','0',NULL,'If enabled, patrons will be able to register themselves via the OPAC.','YesNo'),
339
('PatronSelfRegistrationAdditionalInstructions','','','A free text field to display additional instructions to newly self registered patrons.','free'),
332
('PatronSelfRegistrationAdditionalInstructions','','','A free text field to display additional instructions to newly self registered patrons.','free'),
(-)a/installer/data/mysql/uk-UA/optional/audio_alerts.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO audio_alerts VALUES
2
(1, 1, '.audio-alert-action', 'opening.ogg'),
3
(2, 2, '.audio-alert-warning', 'critical.ogg'),
4
(3, 3, '.audio-alert-success', 'beep.ogg');
(-)a/installer/data/mysql/uk-UA/optional/audio_alerts.txt (+1 lines)
Line 0 Link Here
1
Audio alerts
(-)a/installer/data/mysql/updatedatabase.pl (-9 / +15 lines)
Lines 9613-9626 if ( CheckVersion($DBversion) ) { Link Here
9613
    $dbh->do(q{UPDATE systempreferences SET variable = 'AudioAlerts' WHERE variable = 'soundon'});
9613
    $dbh->do(q{UPDATE systempreferences SET variable = 'AudioAlerts' WHERE variable = 'soundon'});
9614
9614
9615
    $dbh->do(q{
9615
    $dbh->do(q{
9616
        INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES
9616
        CREATE TABLE audio_alerts (
9617
        ( 'AudioAlertsCustom',         '', NULL, 'Custom audio alert triggers in json associative array format',         'free' ),
9617
            audio_alert_id int(11) NOT NULL AUTO_INCREMENT,
9618
        ( 'OverrideAudioAlertWarning', '', NULL, 'URL to an audio file to replace the default warning sound.',           'free' ),
9618
            precedence smallint(5) unsigned NOT NULL,
9619
        ( 'OverrideAudioAlertAction',  '', NULL, 'URL to an audio file to replace the default "action required" sound.', 'free' ),
9619
            selector varchar(255) NOT NULL,
9620
        ( 'OverrideAudioAlertSuccess', '', NULL, 'URL to an audio file to replace the default success sound.',           'free' ),
9620
            sound varchar(255) NOT NULL,
9621
        ( 'AudioAlertSelectorWarning', '.audio-alert-warning', NULL, 'List of jQuery selectors that should trigger warning alert',  'free' ),
9621
            PRIMARY KEY (audio_alert_id),
9622
        ( 'AudioAlertSelectorAction',  '.audio-alert-action',  NULL, 'List of jQuery selectors that should trigger action alert',   'free' ),
9622
            KEY precedence (precedence)
9623
        ( 'AudioAlertSelectorSuccess', '.audio-alert-success', NULL, 'List of jQuery selectors that should trigger successs alert', 'free' )
9623
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9624
    });
9625
9626
    $dbh->do(q{
9627
        INSERT INTO audio_alerts VALUES
9628
        (1, 1, '.audio-alert-action', 'opening.ogg'),
9629
        (2, 2, '.audio-alert-warning', 'critical.ogg'),
9630
        (3, 3, '.audio-alert-success', 'beep.ogg');
9624
    });
9631
    });
9625
9632
9626
    print "Upgrade to $DBversion done (Bug 11431 - Add additional sound options for warnings)\n";
9633
    print "Upgrade to $DBversion done (Bug 11431 - Add additional sound options for warnings)\n";
9627
- 

Return to bug 11431