Bugzilla – Attachment 60485 Details for
Bug 7317
Add an Interlibrary Loan Module to Circulation and OPAC
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7317: Add SQL templates & sysprefs.
Bug-7317-Add-SQL-templates--sysprefs.patch (text/plain), 9.11 KB, created by
Andrew Isherwood
on 2017-02-21 09:01:30 UTC
(
hide
)
Description:
Bug 7317: Add SQL templates & sysprefs.
Filename:
MIME Type:
Creator:
Andrew Isherwood
Created:
2017-02-21 09:01:30 UTC
Size:
9.11 KB
patch
obsolete
>From 424cd2d63595370b7a5b092c8580f5c6679dc176 Mon Sep 17 00:00:00 2001 >From: Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com> >Date: Thu, 22 Sep 2016 16:20:14 +0200 >Subject: [PATCH] Bug 7317: Add SQL templates & sysprefs. > >* installer/data/mysql/atomicupdate/ill_tables.sql: New file. >* installer/data/mysql/kohastructure.sql: Add tables. >* installer/data/mysql/sysprefs.sql: Add sysprefs. >* installer/data/mysql/userflags.sql: Add userflags. >* koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref: > Add sysprefs to UI. >--- > installer/data/mysql/atomicupdate/ill_tables.sql | 52 ++++++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 49 ++++++++++++++++++++ > installer/data/mysql/sysprefs.sql | 1 + > installer/data/mysql/userflags.sql | 3 +- > .../prog/en/modules/admin/preferences/admin.pref | 8 ++++ > 5 files changed, 112 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/ill_tables.sql > >diff --git a/installer/data/mysql/atomicupdate/ill_tables.sql b/installer/data/mysql/atomicupdate/ill_tables.sql >new file mode 100644 >index 0000000..a2b9701 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/ill_tables.sql >@@ -0,0 +1,52 @@ >+-- ILL Requests >+ >+CREATE TABLE illrequests ( >+ illrequest_id serial PRIMARY KEY, -- ILL request number >+ borrowernumber integer DEFAULT NULL, -- Patron associated with request >+ biblio_id integer DEFAULT NULL, -- Potential bib linked to request >+ branchcode varchar(50) NOT NULL, -- The branch associated with the request >+ status varchar(50) DEFAULT NULL, -- Current Koha status of request >+ placed date DEFAULT NULL, -- Date the request was placed >+ replied date DEFAULT NULL, -- Last API response >+ updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request >+ ON UPDATE CURRENT_TIMESTAMP, >+ completed date DEFAULT NULL, -- Date the request was completed >+ medium varchar(30) DEFAULT NULL, -- The Koha request type >+ accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item >+ cost varchar(20) DEFAULT NULL, -- Cost of request >+ notesopac text DEFAULT NULL, -- Patron notes attached to request >+ notesstaff text DEFAULT NULL, -- Staff notes attached to request >+ orderid varchar(50) DEFAULT NULL, -- Backend id attached to request >+ backend varchar(20) DEFAULT NULL, -- The backend used to create request >+ CONSTRAINT `illrequests_bnfk` >+ FOREIGN KEY (`borrowernumber`) >+ REFERENCES `borrowers` (`borrowernumber`) >+ ON UPDATE CASCADE ON DELETE CASCADE, >+ CONSTRAINT `illrequests_bcfk_2` >+ FOREIGN KEY (`branchcode`) >+ REFERENCES `branches` (`branchcode`) >+ ON UPDATE CASCADE ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ >+-- ILL Request Attributes >+ >+CREATE TABLE illrequestattributes ( >+ illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number >+ type varchar(200) NOT NULL, -- API ILL property name >+ value text NOT NULL, -- API ILL property value >+ PRIMARY KEY (`illrequest_id`,`type`), >+ CONSTRAINT `illrequestattributes_ifk` >+ FOREIGN KEY (illrequest_id) >+ REFERENCES `illrequests` (`illrequest_id`) >+ ON UPDATE CASCADE ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ >+-- System preferences >+ >+INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES >+ ('ILLModule','0','If ON, enables the interlibrary loans module.','','YesNo'); >+ >+-- Userflags >+ >+INSERT INTO userflags (bit,flag,flagdesc,defaulton) >+VALUES (21,'ill','The Interlibrary Loans Module',0); >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 7f405c9..e37930b 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3953,6 +3953,55 @@ CREATE TABLE deletedbiblio_metadata ( > CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >+-- >+-- Table structure for table `illrequests` >+-- >+ >+DROP TABLE IF EXISTS `illrequests`; >+CREATE TABLE illrequests ( >+ illrequest_id serial PRIMARY KEY, -- ILL request number >+ borrowernumber integer DEFAULT NULL, -- Patron associated with request >+ biblio_id integer DEFAULT NULL, -- Potential bib linked to request >+ branchcode varchar(50) NOT NULL, -- The branch associated with the request >+ status varchar(50) DEFAULT NULL, -- Current Koha status of request >+ placed date DEFAULT NULL, -- Date the request was placed >+ replied date DEFAULT NULL, -- Last API response >+ updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request >+ ON UPDATE CURRENT_TIMESTAMP, >+ completed date DEFAULT NULL, -- Date the request was completed >+ medium varchar(30) DEFAULT NULL, -- The Koha request type >+ accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item >+ cost varchar(20) DEFAULT NULL, -- Cost of request >+ notesopac text DEFAULT NULL, -- Patron notes attached to request >+ notesstaff text DEFAULT NULL, -- Staff notes attached to request >+ orderid varchar(50) DEFAULT NULL, -- Backend id attached to request >+ backend varchar(20) DEFAULT NULL, -- The backend used to create request >+ CONSTRAINT `illrequests_bnfk` >+ FOREIGN KEY (`borrowernumber`) >+ REFERENCES `borrowers` (`borrowernumber`) >+ ON UPDATE CASCADE ON DELETE CASCADE, >+ CONSTRAINT `illrequests_bcfk_2` >+ FOREIGN KEY (`branchcode`) >+ REFERENCES `branches` (`branchcode`) >+ ON UPDATE CASCADE ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ >+-- >+-- Table structure for table `illrequestattributes` >+-- >+ >+DROP TABLE IF EXISTS `illrequestattributes`; >+CREATE TABLE illrequestattributes ( >+ illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number >+ type varchar(200) NOT NULL, -- API ILL property name >+ value text NOT NULL, -- API ILL property value >+ PRIMARY KEY (`illrequest_id`,`type`), >+ CONSTRAINT `illrequestattributes_ifk` >+ FOREIGN KEY (illrequest_id) >+ REFERENCES `illrequests` (`illrequest_id`) >+ ON UPDATE CASCADE ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ > /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; > /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; > /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index 5ab4dd5..2aee660 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -188,6 +188,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('IDreamBooksResults','0','','Display IDreamBooks.com rating in search results','YesNo'), > ('IDreamBooksReviews','0','','Display book review snippets from IDreamBooks.com','YesNo'), > ('IdRef','0','','Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'), >+('ILLModule','0','If ON, enables the interlibrary loans module.','','YesNo'), > ('ILS-DI','0','','Enables ILS-DI services at OPAC.','YesNo'), > ('ILS-DI:AuthorizedIPs','','Restricts usage of ILS-DI to some IPs','.','Free'), > ('ImageLimit','5','','Limit images stored in the database by the Patron Card image manager to this number.','Integer'), >diff --git a/installer/data/mysql/userflags.sql b/installer/data/mysql/userflags.sql >index d8e3626..cb360b3 100644 >--- a/installer/data/mysql/userflags.sql >+++ b/installer/data/mysql/userflags.sql >@@ -17,5 +17,6 @@ INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES > (17,'staffaccess','Allow staff members to modify permissions for other staff members',0), > (18,'coursereserves','Course reserves',0), > (19, 'plugins', 'Koha plugins', '0'), >-(20, 'lists', 'Lists', 0) >+(20, 'lists', 'Lists', 0), >+(21,'ill','The Interlibrary Loans Module',0) > ; >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref >index e9d95be..309f967 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref >@@ -65,6 +65,14 @@ Administration: > choices: > yes: "The logged-in library" > no: "All libraries" >+ Interlibrary Loans: >+ - >+ - pref: ILLModule >+ default: 0 >+ choices: >+ yes: Enable >+ no: Disable >+ - the interlibrary loans module (master switch). > Login options: > - > - "Inactivity timeout in seconds to automatically log out users: " >-- >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 7317
:
59893
|
59894
|
59895
|
59920
|
60485
|
60486
|
60487
|
60488
|
63081
|
63082
|
63083
|
63084
|
63085
|
63086
|
63087
|
63088
|
63089
|
63090
|
63113
|
63175
|
63176
|
63354
|
63421
|
63472
|
63475
|
65469
|
65470
|
65471
|
65472
|
65473
|
65474
|
65475
|
65476
|
66266
|
67242
|
67243
|
67244
|
67245
|
67246
|
67247
|
67248
|
67249
|
67250
|
67251
|
67252
|
67253
|
67254
|
67255
|
67256
|
67257
|
67258
|
67259
|
67260
|
67261
|
67262
|
67263
|
67264
|
67281
|
67282
|
67283
|
67284
|
67285
|
67286
|
67287
|
67288
|
67289
|
67290
|
67291
|
67292
|
67293
|
67294
|
67295
|
67296
|
67297
|
67298
|
67299
|
67300
|
67301
|
67302
|
67303
|
68185
|
68186
|
68328
|
68391
|
68406
|
68407
|
68408
|
68409
|
68418
|
68444
|
68445
|
68483
|
68484
|
68485
|
68487
|
68516
|
68517
|
68518
|
68519
|
68520
|
68521
|
68522
|
68523
|
68524
|
68525
|
68542
|
68543
|
68544
|
68545
|
68546
|
68547
|
68548
|
68549
|
68550
|
68551
|
68552
|
68558
|
68559
|
68560
|
68561
|
68562
|
68563
|
68564
|
68565
|
68566
|
68567
|
68858
|
68874
|
68877
|
68878
|
68885
|
68886
|
68921
|
68922
|
68926
|
68927
|
68928
|
68929
|
68931
|
68932
|
68933
|
68988
|
68989
|
68999
|
69000
|
69006
|
69008
|
69009
|
69012
|
69014
|
69044
|
69045
|
69046
|
69056
|
69059
|
69060
|
69061
|
69063
|
69064
|
69065
|
69066
|
69069
|
69070
|
69071
|
69074