Bugzilla – Attachment 82896 Details for
Bug 8628
Add digital signs to the OPAC
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8628: Add digital signs to the OPAC, dbchanges
Bug-8628-Add-digital-signs-to-the-OPAC-dbchanges.patch (text/plain), 7.20 KB, created by
Aleisha Amohia
on 2018-12-05 22:18:22 UTC
(
hide
)
Description:
Bug 8628: Add digital signs to the OPAC, dbchanges
Filename:
MIME Type:
Creator:
Aleisha Amohia
Created:
2018-12-05 22:18:22 UTC
Size:
7.20 KB
patch
obsolete
>From 0e99062b77344bb8b56d01cf28c8296d9b350b13 Mon Sep 17 00:00:00 2001 >From: Martin Stenberg <martin@xinxidi.net> >Date: Fri, 18 Sep 2015 14:30:39 +0200 >Subject: [PATCH] Bug 8628: Add digital signs to the OPAC, dbchanges > >Database changes for bug 8628 > >Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz> >--- > .../bug_8628-digital-signs-permissions.sql | 1 + > .../bug_8628-digital-signs-sysprefs.sql | 3 +++ > .../mysql/atomicupdate/bug_8628-digital-signs.sql | 30 ++++++++++++++++++++++ > installer/data/mysql/sysprefs.sql | 2 -- > 4 files changed, 34 insertions(+), 2 deletions(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_8628-digital-signs-permissions.sql > create mode 100644 installer/data/mysql/atomicupdate/bug_8628-digital-signs-sysprefs.sql > create mode 100644 installer/data/mysql/atomicupdate/bug_8628-digital-signs.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_8628-digital-signs-permissions.sql b/installer/data/mysql/atomicupdate/bug_8628-digital-signs-permissions.sql >new file mode 100644 >index 0000000..0e8775c >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_8628-digital-signs-permissions.sql >@@ -0,0 +1 @@ >+INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (13, 'edit_digital_signs', 'Create and edit digital signs for the OPAC'); >diff --git a/installer/data/mysql/atomicupdate/bug_8628-digital-signs-sysprefs.sql b/installer/data/mysql/atomicupdate/bug_8628-digital-signs-sysprefs.sql >new file mode 100644 >index 0000000..8aff962 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_8628-digital-signs-sysprefs.sql >@@ -0,0 +1,3 @@ >+INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES ('OPACDigitalSigns',0,'Turn digital signs in the OPAC on or off.','YesNo'); >+INSERT IGNORE INTO systempreferences (variable,explanation,type) VALUES ('OPACDigitalSignsCSS','Extra CSS to be included in all signs','Textarea'); >+INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES ('OPACDigitalSignsSwatches','abcde','List the swatches that can be chosen when creating a new sign','free'); >diff --git a/installer/data/mysql/atomicupdate/bug_8628-digital-signs.sql b/installer/data/mysql/atomicupdate/bug_8628-digital-signs.sql >new file mode 100644 >index 0000000..4c608b2 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_8628-digital-signs.sql >@@ -0,0 +1,30 @@ >+DROP TABLE IF EXISTS signs_to_streams; >+DROP TABLE IF EXISTS sign_streams; >+CREATE TABLE sign_streams ( >+ sign_stream_id int(11) NOT NULL auto_increment, -- primary key, used to identify streams >+ saved_sql_id int(11) NOT NULL, -- foreign key from the saved_sql table >+ name varchar(64), -- name/title of the sign >+ PRIMARY KEY (sign_stream_id), >+ CONSTRAINT sign_streams_ibfk_1 FOREIGN KEY (saved_sql_id) REFERENCES saved_sql (id) ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+DROP TABLE IF EXISTS signs; >+CREATE TABLE signs ( >+ sign_id int(11) NOT NULL auto_increment, -- primary key, used to identify signs >+ name varchar(64), -- name/title of the deck >+ webapp int(1) NOT NULL DEFAULT 0, -- display as web app or normal page >+ 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) >+ swatch char(1) NOT NULL DEFAULT '', -- swatches determine the colors of page elements >+ idleafter int(11) NOT NULL default 0, -- seconds to wait before automatic page turning cicks in >+ pagedelay int(11) NOT NULL default 0, -- seconds to wait before turning to a new page/record >+ reloadafter int(11) NOT NULL default 0, -- seconds to wait before reloading all the pages >+ PRIMARY KEY (sign_id) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+CREATE TABLE signs_to_streams ( >+ 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) >+ sign_stream_id int(11) NOT NULL, -- foreign key from the decks sign_streams table >+ sign_id int(11) NOT NULL, -- foreign key from the signs table >+ params varchar(255) NOT NULL DEFAULT '', -- list of parameters for the SQL associated with the sign_stream >+ PRIMARY KEY (sign_to_stream_id), >+ CONSTRAINT signs_to_streams_ibfk_1 FOREIGN KEY (sign_stream_id) REFERENCES sign_streams (sign_stream_id) ON DELETE CASCADE, >+ CONSTRAINT signs_to_streams_ibfk_2 FOREIGN KEY (sign_id) REFERENCES signs (sign_id) ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index 1e36c30..adf83bd 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -86,7 +86,6 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('BatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch','Free'), > ('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'), > ('BiblioDefaultView','normal','normal|marc|isbd','Choose the default detail view in the catalog; choose between normal, marc or isbd','Choice'), >-('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'), > ('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'), > ('BlockReturnOfLostItems','0','0','If enabled, items that are marked as lost cannot be returned.','YesNo'), > ('BlockReturnOfWithdrawnItems','1','0','If enabled, items that are marked as withdrawn cannot be returned.','YesNo'), >@@ -494,7 +493,6 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('ReturnpathDefault','',NULL,'Use this email address as return path or bounce address for undeliverable emails','Free'), > ('ReturnToShelvingCart','0','','If set, when any item is \'checked in\', it\'s location code will be changed to CART.','YesNo'), > ('reviewson','1','','If ON, enables patron reviews of bibliographic records in the OPAC','YesNo'), >-('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'), > ('RoutingListAddReserves','0','','If ON the patrons on routing lists are automatically added to holds on the issue.','YesNo'), > ('RotationPreventTransfers','0',NULL,'If ON, prevent any transfers for items on stock rotation rotas, except for stock rotation transfers','YesNo'), > ('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'), >-- >2.1.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 8628
:
42703
|
42704
|
45968
|
45969
|
58602
|
58603
|
58604
|
58605
|
62338
|
64249
|
66246
|
66247
|
66248
|
66249
|
66250
|
77025
|
77026
|
77027
|
77028
|
77141
|
77142
|
77143
|
77144
|
77145
|
78709
|
80248
|
80249
|
80250
|
80252
|
82896
|
82897
|
82898
|
82899
|
82900
|
82901
|
83312
|
88821
|
88822
|
88823
|
88824
|
88825
|
88826
|
93054
|
93055
|
93056
|
93057
|
93058
|
93059
|
93066
|
93067
|
93068
|
93069
|
93070
|
93071
|
99608
|
99609
|
99610
|
99611
|
99612
|
99613
|
99614
|
99615
|
99616
|
99617
|
99618
|
99619
|
99620
|
99621
|
99622
|
99623
|
99624
|
99717
|
99718
|
99801
|
118472
|
118473
|
118474
|
118475
|
118476
|
118477
|
118478
|
118479
|
118480
|
119455
|
131223
|
131224
|
145645
|
145646
|
145647
|
145648
|
145649
|
145650
|
145651
|
145652
|
145653
|
145654
|
147000
|
147001
|
147002
|
147003
|
147004
|
147005
|
147006
|
147007
|
147008
|
147009
|
147010