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 5325-5330 CREATE TABLE `zebraqueue` ( Link Here
5325
  KEY `zebraqueue_lookup` (`server`,`biblio_auth_number`,`operation`,`done`)
5325
  KEY `zebraqueue_lookup` (`server`,`biblio_auth_number`,`operation`,`done`)
5326
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5326
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5327
/*!40101 SET character_set_client = @saved_cs_client */;
5327
/*!40101 SET character_set_client = @saved_cs_client */;
5328
5329
--
5330
-- Table structure for table 'sign_streams'
5331
--
5332
5333
DROP TABLE IF EXISTS sign_streams;
5334
CREATE TABLE sign_streams (
5335
  `sign_stream_id` int(11) NOT NULL auto_increment, -- primary key, used to identify streams
5336
  `saved_sql_id` int(11) NOT NULL, -- foreign key from the saved_sql table
5337
  `name` varchar(64), -- name/title of the sign
5338
  PRIMARY KEY (`sign_stream_id`),
5339
  CONSTRAINT `sign_streams_ibfk_1` FOREIGN KEY (`saved_sql_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE
5340
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
5341
5342
--
5343
-- Table structure for table 'signs'
5344
--
5345
5346
DROP TABLE IF EXISTS signs;
5347
CREATE TABLE signs (
5348
  `sign_id` int(11) NOT NULL auto_increment, -- primary key, used to identify signs
5349
  `name` varchar(64), -- name/title of the deck
5350
  `webapp` int(1) NOT NULL DEFAULT 0, -- display as web app or normal page
5351
  `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)
5352
  `swatch` char(1) NOT NULL DEFAULT '', -- swatches determine the colors of page elements
5353
  `idleafter` int(11) NOT NULL default 0, -- seconds to wait before automatic page turning clicks in
5354
  `pagedelay` int(11) NOT NULL default 0, -- seconds to wait before turning to a new page/record
5355
  `reloadafter` int(11) NOT NULL default 0, -- seconds to wait before reloading all the pages
5356
  PRIMARY KEY (`sign_id`)
5357
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
5358
5359
--
5360
-- Table structure for table 'signs_to_streams'
5361
--
5362
5363
DROP TABLE IF EXISTS signs_to_streams;
5364
CREATE TABLE signs_to_streams (
5365
  `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)
5366
  `sign_stream_id` int(11) NOT NULL, -- foreign key from the decks sign_streams table
5367
  `sign_id` int(11) NOT NULL, -- foreign key from the signs table
5368
  `params` varchar(255) NOT NULL DEFAULT '', -- list of parameters for the SQL associated with the sign_stream
5369
  PRIMARY KEY (`sign_to_stream_id`),
5370
  CONSTRAINT `signs_to_streams_ibfk_1` FOREIGN KEY (`sign_stream_id`) REFERENCES `sign_streams` (`sign_stream_id`) ON DELETE CASCADE,
5371
  CONSTRAINT `signs_to_streams_ibfk_2` FOREIGN KEY (`sign_id`) REFERENCES `signs` (`sign_id`) ON DELETE CASCADE
5372
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
5373
5328
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
5374
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
5329
5375
5330
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
5376
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
(-)a/installer/data/mysql/mandatory/sysprefs.sql (-1 / +3 lines)
Lines 396-401 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
396
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
396
('OPACdefaultSortField','relevance','relevance|popularity|call_number|pubdate|acqdate|title|author','Specify the default field used for sorting','Choice'),
397
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
397
('OPACdefaultSortOrder','dsc','asc|dsc|za|az','Specify the default sort order','Choice'),
398
('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
398
('OPACdidyoumean','',NULL,'Did you mean? configuration for the OPAC. Do not change, as this is controlled by /cgi-bin/koha/admin/didyoumean.pl.','Free'),
399
('OPACDigitalSigns',0,NULL, 'Turn digital signs in the OPAC on or off.','YesNo'),
400
('OPACDigitalSignsCSS','',NULL,'Extra CSS to be included in all signs','Textarea'),
401
('OPACDigitalSignsSwatches','abcde',NULL,'List the swatches that can be chosen when creating a new sign','free'),
399
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
402
('OPACDisplay856uAsImage','OFF','OFF|Details|Results|Both','Display the URI in the 856u field as an image, the corresponding OPACXSLT option must be on','Choice'),
400
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
403
('OpacExportOptions','bibtex,dc,marcxml,marc8,utf8,marcstd,mods,ris,isbd','','Define export options available on OPAC detail page.','multiple'),
401
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
404
('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes'),
402
- 

Return to bug 8628