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 (+46 lines)
Lines 5995-6000 CREATE TABLE `zebraqueue` ( Link Here
5995
  KEY `zebraqueue_lookup` (`server`,`biblio_auth_number`,`operation`,`done`)
5995
  KEY `zebraqueue_lookup` (`server`,`biblio_auth_number`,`operation`,`done`)
5996
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5996
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5997
/*!40101 SET character_set_client = @saved_cs_client */;
5997
/*!40101 SET character_set_client = @saved_cs_client */;
5998
5999
--
6000
-- Table structure for table 'sign_streams'
6001
--
6002
6003
DROP TABLE IF EXISTS sign_streams;
6004
CREATE TABLE sign_streams (
6005
  `sign_stream_id` int(11) NOT NULL auto_increment, -- primary key, used to identify streams
6006
  `saved_sql_id` int(11) NOT NULL, -- foreign key from the saved_sql table
6007
  `name` varchar(64), -- name/title of the sign
6008
  PRIMARY KEY (`sign_stream_id`),
6009
  CONSTRAINT `sign_streams_ibfk_1` FOREIGN KEY (`saved_sql_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE
6010
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
6011
6012
--
6013
-- Table structure for table 'signs'
6014
--
6015
6016
DROP TABLE IF EXISTS signs;
6017
CREATE TABLE signs (
6018
  `sign_id` int(11) NOT NULL auto_increment, -- primary key, used to identify signs
6019
  `name` varchar(64), -- name/title of the deck
6020
  `webapp` int(1) NOT NULL DEFAULT 0, -- display as web app or normal page
6021
  `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)
6022
  `swatch` char(1) NOT NULL DEFAULT '', -- swatches determine the colors of page elements
6023
  `idleafter` int(11) NOT NULL default 0, -- seconds to wait before automatic page turning clicks in
6024
  `pagedelay` int(11) NOT NULL default 0, -- seconds to wait before turning to a new page/record
6025
  `reloadafter` int(11) NOT NULL default 0, -- seconds to wait before reloading all the pages
6026
  PRIMARY KEY (`sign_id`)
6027
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
6028
6029
--
6030
-- Table structure for table 'signs_to_streams'
6031
--
6032
6033
DROP TABLE IF EXISTS signs_to_streams;
6034
CREATE TABLE signs_to_streams (
6035
  `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)
6036
  `sign_stream_id` int(11) NOT NULL, -- foreign key from the decks sign_streams table
6037
  `sign_id` int(11) NOT NULL, -- foreign key from the signs table
6038
  `params` varchar(255) NOT NULL DEFAULT '', -- list of parameters for the SQL associated with the sign_stream
6039
  PRIMARY KEY (`sign_to_stream_id`),
6040
  CONSTRAINT `signs_to_streams_ibfk_1` FOREIGN KEY (`sign_stream_id`) REFERENCES `sign_streams` (`sign_stream_id`) ON DELETE CASCADE,
6041
  CONSTRAINT `signs_to_streams_ibfk_2` FOREIGN KEY (`sign_id`) REFERENCES `signs` (`sign_id`) ON DELETE CASCADE
6042
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
6043
5998
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
6044
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
5999
6045
6000
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
6046
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
(-)a/installer/data/mysql/mandatory/sysprefs.sql (-1 / +3 lines)
Lines 441-446 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
441
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
441
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
442
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
442
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
443
('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
443
('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
444
('OPACDigitalSigns',0,NULL, 'Turn digital signs in the OPAC on or off.','YesNo'),
445
('OPACDigitalSignsCSS','',NULL,'Extra CSS to be included in all signs','Textarea'),
446
('OPACDigitalSignsSwatches','abcde',NULL,'List the swatches that can be chosen when creating a new sign','free'),
444
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
447
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
445
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
448
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
446
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
449
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
447
- 

Return to bug 8628