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

(-)a/installer/data/mysql/atomicupdate/bug_8628-digital-signs-permissions.perl (+7 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (13, 'edit_digital_signs', 'Create and edit digital signs for the OPAC') });
4
5
    SetVersion( $DBversion );
6
    print "Upgrade to $DBversion done (Bug 8628 - adding permission for managing digital signs)\n";
7
}
(-)a/installer/data/mysql/atomicupdate/bug_8628-digital-signs-sysprefs.perl (+11 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{INSERT IGNORE INTO systempreferences (`variable`,`value`,`options`,`explanation`,`type`) VALUES
4
                ('OPACDigitalSigns',0,NULL,'Turn digital signs in the OPAC on or off.','YesNo'),
5
                ('OPACDigitalSignsCSS','',NULL,'Extra CSS to be included in all signs','Textarea'),
6
                ('OPACDigitalSignsSwatches','abcde',NULL,'List the swatches that can be chosen when creating a new sign','free')
7
            });
8
9
    SetVersion( $DBversion );
10
    print "Upgrade to $DBversion done (Bug 8628 - Adding OPACDigitalSigns, OPACDigitalSignsCSS and OPACDigitalSignsSwatches system preferences)\n";
11
}
(-)a/installer/data/mysql/atomicupdate/bug_8628-digital-signs.perl (+37 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{DROP TABLE IF EXISTS sign_streams });
4
    $dbh->do(q{DROP TABLE IF EXISTS signs });
5
    $dbh->do(q{CREATE TABLE sign_streams (
6
                sign_stream_id int(11) NOT NULL auto_increment,    -- primary key, used to identify streams
7
                saved_sql_id int(11) NOT NULL,              -- foreign key from the saved_sql table
8
                name varchar(64),                           -- name/title of the sign
9
                PRIMARY KEY (sign_stream_id),
10
                CONSTRAINT sign_streams_ibfk_1 FOREIGN KEY (saved_sql_id) REFERENCES saved_sql (id) ON DELETE CASCADE
11
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8 });
12
    $dbh->do(q{CREATE TABLE signs (
13
                sign_id int(11) NOT NULL auto_increment,     -- primary key, used to identify signs
14
                name varchar(64),                            -- name/title of the deck
15
                webapp int(1) NOT NULL DEFAULT 0,            -- display as web app or normal page
16
                transition char(16) NOT NULL DEFAULT 'none', -- transition to use between pages, must be one of the transitions defined by jQuery Mobile (see their docs)
17
                swatch char(1) NOT NULL DEFAULT '',          -- swatches determine the colors of page elements
18
                idleafter int(11) NOT NULL default 0,        -- seconds to wait before automatic page turning cicks in
19
                pagedelay int(11) NOT NULL default 0,        -- seconds to wait before turning to a new page/record
20
                reloadafter int(11) NOT NULL default 0,      -- seconds to wait before reloading all the pages
21
                PRIMARY KEY (sign_id)
22
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8 });
23
24
    $dbh->do(q{DROP TABLE IF EXISTS signs_to_streams });
25
    $dbh->do(q{CREATE TABLE signs_to_streams (
26
                sign_to_stream_id int(11) NOT NULL auto_increment, -- primary key, used to identify connections between signs and streams (the same stream can be attached to a sign more than once, with different parameters)
27
                sign_stream_id int(11) NOT NULL,                   -- foreign key from the decks sign_streams table
28
                sign_id int(11) NOT NULL,                          -- foreign key from the signs table
29
                params varchar(255) NOT NULL DEFAULT '',           -- list of parameters for the SQL associated with the sign_stream
30
                PRIMARY KEY (sign_to_stream_id),
31
                CONSTRAINT signs_to_streams_ibfk_1 FOREIGN KEY (sign_stream_id) REFERENCES sign_streams (sign_stream_id) ON DELETE CASCADE,
32
                CONSTRAINT signs_to_streams_ibfk_2 FOREIGN KEY (sign_id) REFERENCES signs (sign_id) ON DELETE CASCADE
33
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8 });
34
35
    SetVersion( $DBversion );
36
    print "Upgrade to $DBversion done (Bug 8628 - add signs, sign_streams and signs_to_streams tables)\n";
37
}
(-)a/installer/data/mysql/kohastructure.sql (+45 lines)
Lines 4324-4329 CREATE TABLE stockrotationitems ( Link Here
4324
      ON UPDATE CASCADE ON DELETE CASCADE
4324
      ON UPDATE CASCADE ON DELETE CASCADE
4325
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4325
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4326
4326
4327
--
4328
-- Table structure for table 'sign_streams'
4329
--
4330
4331
DROP TABLE IF EXISTS sign_streams;
4332
CREATE TABLE sign_streams (
4333
  `sign_stream_id` int(11) NOT NULL auto_increment, -- primary key, used to identify streams
4334
  `saved_sql_id` int(11) NOT NULL, -- foreign key from the saved_sql table
4335
  `name` varchar(64), -- name/title of the sign
4336
  PRIMARY KEY (`sign_stream_id`),
4337
  CONSTRAINT `sign_streams_ibfk_1` FOREIGN KEY (`saved_sql_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE
4338
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4339
4340
--
4341
-- Table structure for table 'signs'
4342
--
4343
4344
DROP TABLE IF EXISTS signs;
4345
CREATE TABLE signs (
4346
  `sign_id` int(11) NOT NULL auto_increment, -- primary key, used to identify signs
4347
  `name` varchar(64), -- name/title of the deck
4348
  `webapp` int(1) NOT NULL DEFAULT 0, -- display as web app or normal page
4349
  `transition` char(16) NOT NULL DEFAULT 'none', -- transition to use between pages, must be one of the transitions defined by jQuery Mobile (see their docs)
4350
  `swatch` char(1) NOT NULL DEFAULT '', -- swatches determine the colors of page elements
4351
  `idleafter` int(11) NOT NULL default 0, -- seconds to wait before automatic page turning clicks in
4352
  `pagedelay` int(11) NOT NULL default 0, -- seconds to wait before turning to a new page/record
4353
  `reloadafter` int(11) NOT NULL default 0, -- seconds to wait before reloading all the pages
4354
  PRIMARY KEY (`sign_id`)
4355
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4356
4357
--
4358
-- Table structure for table 'signs_to_streams'
4359
--
4360
4361
DROP TABLE IF EXISTS signs_to_streams;
4362
CREATE TABLE signs_to_streams (
4363
  `sign_to_stream_id` int(11) NOT NULL auto_increment, -- primary key, used to identify connections between signs and streams (the same stream can be attached to a sign more than once, with different parameters)
4364
  `sign_stream_id` int(11) NOT NULL, -- foreign key from the decks sign_streams table
4365
  `sign_id` int(11) NOT NULL, -- foreign key from the signs table
4366
  `params` varchar(255) NOT NULL DEFAULT '', -- list of parameters for the SQL associated with the sign_stream
4367
  PRIMARY KEY (`sign_to_stream_id`),
4368
  CONSTRAINT `signs_to_streams_ibfk_1` FOREIGN KEY (`sign_stream_id`) REFERENCES `sign_streams` (`sign_stream_id`) ON DELETE CASCADE,
4369
  CONSTRAINT `signs_to_streams_ibfk_2` FOREIGN KEY (`sign_id`) REFERENCES `signs` (`sign_id`) ON DELETE CASCADE
4370
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4371
4327
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4372
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4328
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4373
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4329
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4374
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (-3 / +5 lines)
Lines 89-95 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
89
('BatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch','Free'),
89
('BatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch','Free'),
90
('BiblioAddsAuthorities','0',NULL,'If ON, adding a new biblio will check for an existing authority record and create one on the fly if one doesn\'t exist','YesNo'),
90
('BiblioAddsAuthorities','0',NULL,'If ON, adding a new biblio will check for an existing authority record and create one on the fly if one doesn\'t exist','YesNo'),
91
('BiblioDefaultView','normal','normal|marc|isbd','Choose the default detail view in the catalog; choose between normal, marc or isbd','Choice'),
91
('BiblioDefaultView','normal','normal|marc|isbd','Choose the default detail view in the catalog; choose between normal, marc or isbd','Choice'),
92
('BibtexExportAdditionalFields',  '', NULL ,  'Define additional BibTex tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.',  'textarea'),
92
('BibtexExportAdditionalFields', '', NULL, 'Define additional BibTex tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.', 'textarea'),
93
('BlockExpiredPatronOpacActions','1',NULL,'Set whether an expired patron can perform opac actions such as placing holds or renew books, can be overridden on a per patron-type basis','YesNo'),
93
('BlockExpiredPatronOpacActions','1',NULL,'Set whether an expired patron can perform opac actions such as placing holds or renew books, can be overridden on a per patron-type basis','YesNo'),
94
('BlockReturnOfLostItems','0','0','If enabled, items that are marked as lost cannot be returned.','YesNo'),
94
('BlockReturnOfLostItems','0','0','If enabled, items that are marked as lost cannot be returned.','YesNo'),
95
('BlockReturnOfWithdrawnItems','1','0','If enabled, items that are marked as withdrawn cannot be returned.','YesNo'),
95
('BlockReturnOfWithdrawnItems','1','0','If enabled, items that are marked as withdrawn cannot be returned.','YesNo'),
Lines 357-362 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
357
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
357
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
358
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
358
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
359
('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
359
('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
360
('OPACDigitalSigns',0,NULL, 'Turn digital signs in the OPAC on or off.','YesNo'),
361
('OPACDigitalSignsCSS','',NULL,'Extra CSS to be included in all signs','Textarea'),
362
('OPACDigitalSignsSwatches','abcde',NULL,'List the swatches that can be chosen when creating a new sign','free'),
360
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
363
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
361
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
364
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
362
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
365
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
Lines 512-518 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
512
('ReturnpathDefault','',NULL,'Use this email address as return path or bounce address for undeliverable emails','Free'),
515
('ReturnpathDefault','',NULL,'Use this email address as return path or bounce address for undeliverable emails','Free'),
513
('ReturnToShelvingCart','0','','If set, when any item is \'checked in\', it\'s location code will be changed to CART.','YesNo'),
516
('ReturnToShelvingCart','0','','If set, when any item is \'checked in\', it\'s location code will be changed to CART.','YesNo'),
514
('reviewson','1','','If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'),
517
('reviewson','1','','If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'),
515
('RisExportAdditionalFields',  '', NULL ,  'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.',  'textarea'),
518
('RisExportAdditionalFields', '', NULL, 'Define additional RIS tags to export from MARC records in YAML format as an associative array with either a marc tag/subfield combination as the value, or a list of tag/subfield combinations.', 'textarea'),
516
('RoutingListAddReserves','0','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
519
('RoutingListAddReserves','0','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
517
('RotationPreventTransfers','0',NULL,'If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','YesNo'),
520
('RotationPreventTransfers','0',NULL,'If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','YesNo'),
518
('RoutingListNote','To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference.','70|10','Define a note to be shown on all routing lists','Textarea'),
521
('RoutingListNote','To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference.','70|10','Define a note to be shown on all routing lists','Textarea'),
519
- 

Return to bug 8628