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

(-)a/installer/data/mysql/atomicupdate/bug_8628-digital-signs-permissions.sql (+1 lines)
Line 0 Link Here
1
INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (13, 'edit_digital_signs', 'Create and edit digital signs for the OPAC');
(-)a/installer/data/mysql/atomicupdate/bug_8628-digital-signs-sysprefs.sql (+3 lines)
Line 0 Link Here
1
INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES ('OPACDigitalSigns',0,'Turn digital signs in the OPAC on or off.','YesNo');
2
INSERT IGNORE INTO systempreferences (variable,explanation,type) VALUES ('OPACDigitalSignsCSS','Extra CSS to be included in all signs','Textarea');
3
INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES ('OPACDigitalSignsSwatches','abcde','List the swatches that can be chosen when creating a new sign','free');
(-)a/installer/data/mysql/atomicupdate/bug_8628-digital-signs.sql (+30 lines)
Line 0 Link Here
1
DROP TABLE IF EXISTS signs_to_streams;
2
DROP TABLE IF EXISTS sign_streams;
3
CREATE TABLE sign_streams (
4
  sign_stream_id int(11) NOT NULL auto_increment,    -- primary key, used to identify streams
5
  saved_sql_id int(11) NOT NULL,              -- foreign key from the saved_sql table
6
  name varchar(64),                           -- name/title of the sign
7
  PRIMARY KEY (sign_stream_id),
8
  CONSTRAINT sign_streams_ibfk_1 FOREIGN KEY (saved_sql_id) REFERENCES saved_sql (id) ON DELETE CASCADE
9
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10
DROP TABLE IF EXISTS signs;
11
CREATE TABLE signs (
12
  sign_id int(11) NOT NULL auto_increment,     -- primary key, used to identify signs
13
  name varchar(64),                            -- name/title of the deck
14
  webapp int(1) NOT NULL DEFAULT 0,            -- display as web app or normal page
15
  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)
16
  swatch char(1) NOT NULL DEFAULT '',          -- swatches determine the colors of page elements
17
  idleafter int(11) NOT NULL default 0,        -- seconds to wait before automatic page turning cicks in
18
  pagedelay int(11) NOT NULL default 0,        -- seconds to wait before turning to a new page/record
19
  reloadafter int(11) NOT NULL default 0,      -- seconds to wait before reloading all the pages
20
  PRIMARY KEY (sign_id)
21
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
22
CREATE TABLE signs_to_streams (
23
  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)
24
  sign_stream_id int(11) NOT NULL,                   -- foreign key from the decks sign_streams table
25
  sign_id int(11) NOT NULL,                          -- foreign key from the signs table
26
  params varchar(255) NOT NULL DEFAULT '',           -- list of parameters for the SQL associated with the sign_stream
27
  PRIMARY KEY (sign_to_stream_id),
28
  CONSTRAINT signs_to_streams_ibfk_1 FOREIGN KEY (sign_stream_id) REFERENCES sign_streams (sign_stream_id) ON DELETE CASCADE,
29
  CONSTRAINT signs_to_streams_ibfk_2 FOREIGN KEY (sign_id) REFERENCES signs (sign_id) ON DELETE CASCADE
30
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/sysprefs.sql (-3 lines)
Lines 65-71 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
65
('BasketConfirmations','1','always ask for confirmation.|do not ask for confirmation.','When closing or reopening a basket,','Choice'),
65
('BasketConfirmations','1','always ask for confirmation.|do not ask for confirmation.','When closing or reopening a basket,','Choice'),
66
('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'),
66
('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'),
67
('BiblioDefaultView','normal','normal|marc|isbd','Choose the default detail view in the catalog; choose between normal, marc or isbd','Choice'),
67
('BiblioDefaultView','normal','normal|marc|isbd','Choose the default detail view in the catalog; choose between normal, marc or isbd','Choice'),
68
('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'),
69
('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'),
68
('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'),
70
('BlockReturnOfWithdrawnItems','1','0','If enabled, items that are marked as withdrawn cannot be returned.','YesNo'),
69
('BlockReturnOfWithdrawnItems','1','0','If enabled, items that are marked as withdrawn cannot be returned.','YesNo'),
71
('BorrowerMandatoryField','surname|cardnumber',NULL,'Choose the mandatory fields for a patron\'s account','free'),
70
('BorrowerMandatoryField','surname|cardnumber',NULL,'Choose the mandatory fields for a patron\'s account','free'),
Lines 374-380 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
374
('ReturnLog','1',NULL,'If ON, enables the circulation (returns) log','YesNo'),
373
('ReturnLog','1',NULL,'If ON, enables the circulation (returns) log','YesNo'),
375
('ReturnToShelvingCart','0','','If set, when any item is \'checked in\', it\'s location code will be changed to CART.','YesNo'),
374
('ReturnToShelvingCart','0','','If set, when any item is \'checked in\', it\'s location code will be changed to CART.','YesNo'),
376
('reviewson','1','','If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'),
375
('reviewson','1','','If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'),
377
('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'),
378
('RoutingListAddReserves','1','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
376
('RoutingListAddReserves','1','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'),
379
('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'),
377
('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'),
380
('RoutingSerials','1',NULL,'If ON, serials routing is enabled','YesNo'),
378
('RoutingSerials','1',NULL,'If ON, serials routing is enabled','YesNo'),
381
- 

Return to bug 8628