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

(-)a/installer/data/mysql/atomicupdate/ill_tables.sql (+52 lines)
Line 0 Link Here
1
-- ILL Requests
2
3
CREATE TABLE illrequests (
4
    illrequest_id serial PRIMARY KEY,           -- ILL request number
5
    borrowernumber integer DEFAULT NULL,        -- Patron associated with request
6
    biblio_id integer DEFAULT NULL,             -- Potential bib linked to request
7
    branchcode varchar(50) NOT NULL,            -- The branch associated with the request
8
    status varchar(50) DEFAULT NULL,            -- Current Koha status of request
9
    placed date DEFAULT NULL,                   -- Date the request was placed
10
    replied date DEFAULT NULL,                  -- Last API response
11
    updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request
12
      ON UPDATE CURRENT_TIMESTAMP,
13
    completed date DEFAULT NULL,                -- Date the request was completed
14
    medium varchar(30) DEFAULT NULL,            -- The Koha request type
15
    accessurl varchar(500) DEFAULT NULL,        -- Potential URL for accessing item
16
    cost varchar(20) DEFAULT NULL,              -- Cost of request
17
    notesopac text DEFAULT NULL,                -- Patron notes attached to request
18
    notesstaff text DEFAULT NULL,               -- Staff notes attached to request
19
    orderid varchar(50) DEFAULT NULL,           -- Backend id attached to request
20
    backend varchar(20) DEFAULT NULL,           -- The backend used to create request
21
    CONSTRAINT `illrequests_bnfk`
22
      FOREIGN KEY (`borrowernumber`)
23
      REFERENCES `borrowers` (`borrowernumber`)
24
      ON UPDATE CASCADE ON DELETE CASCADE,
25
    CONSTRAINT `illrequests_bcfk_2`
26
      FOREIGN KEY (`branchcode`)
27
      REFERENCES `branches` (`branchcode`)
28
      ON UPDATE CASCADE ON DELETE CASCADE
29
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
30
31
-- ILL Request Attributes
32
33
CREATE TABLE illrequestattributes (
34
    illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number
35
    type varchar(200) NOT NULL,                 -- API ILL property name
36
    value text NOT NULL,                        -- API ILL property value
37
    PRIMARY KEY  (`illrequest_id`,`type`),
38
    CONSTRAINT `illrequestattributes_ifk`
39
      FOREIGN KEY (illrequest_id)
40
      REFERENCES `illrequests` (`illrequest_id`)
41
      ON UPDATE CASCADE ON DELETE CASCADE
42
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
43
44
-- System preferences
45
46
INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES
47
       ('ILLModule','0','If ON, enables the interlibrary loans module.','','YesNo');
48
49
-- Userflags
50
51
INSERT INTO userflags (bit,flag,flagdesc,defaulton)
52
VALUES (21,'ill','The Interlibrary Loans Module',0);
(-)a/installer/data/mysql/kohastructure.sql (+49 lines)
Lines 3953-3958 CREATE TABLE deletedbiblio_metadata ( Link Here
3953
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3953
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3954
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3954
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3955
3955
3956
--
3957
-- Table structure for table `illrequests`
3958
--
3959
3960
DROP TABLE IF EXISTS `illrequests`;
3961
CREATE TABLE illrequests (
3962
    illrequest_id serial PRIMARY KEY,           -- ILL request number
3963
    borrowernumber integer DEFAULT NULL,        -- Patron associated with request
3964
    biblio_id integer DEFAULT NULL,             -- Potential bib linked to request
3965
    branchcode varchar(50) NOT NULL,            -- The branch associated with the request
3966
    status varchar(50) DEFAULT NULL,            -- Current Koha status of request
3967
    placed date DEFAULT NULL,                   -- Date the request was placed
3968
    replied date DEFAULT NULL,                  -- Last API response
3969
    updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request
3970
      ON UPDATE CURRENT_TIMESTAMP,
3971
    completed date DEFAULT NULL,                -- Date the request was completed
3972
    medium varchar(30) DEFAULT NULL,            -- The Koha request type
3973
    accessurl varchar(500) DEFAULT NULL,        -- Potential URL for accessing item
3974
    cost varchar(20) DEFAULT NULL,              -- Cost of request
3975
    notesopac text DEFAULT NULL,                -- Patron notes attached to request
3976
    notesstaff text DEFAULT NULL,               -- Staff notes attached to request
3977
    orderid varchar(50) DEFAULT NULL,           -- Backend id attached to request
3978
    backend varchar(20) DEFAULT NULL,           -- The backend used to create request
3979
    CONSTRAINT `illrequests_bnfk`
3980
      FOREIGN KEY (`borrowernumber`)
3981
      REFERENCES `borrowers` (`borrowernumber`)
3982
      ON UPDATE CASCADE ON DELETE CASCADE,
3983
    CONSTRAINT `illrequests_bcfk_2`
3984
      FOREIGN KEY (`branchcode`)
3985
      REFERENCES `branches` (`branchcode`)
3986
      ON UPDATE CASCADE ON DELETE CASCADE
3987
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3988
3989
--
3990
-- Table structure for table `illrequestattributes`
3991
--
3992
3993
DROP TABLE IF EXISTS `illrequestattributes`;
3994
CREATE TABLE illrequestattributes (
3995
    illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number
3996
    type varchar(200) NOT NULL,                 -- API ILL property name
3997
    value text NOT NULL,                        -- API ILL property value
3998
    PRIMARY KEY  (`illrequest_id`,`type`),
3999
    CONSTRAINT `illrequestattributes_ifk`
4000
      FOREIGN KEY (illrequest_id)
4001
      REFERENCES `illrequests` (`illrequest_id`)
4002
      ON UPDATE CASCADE ON DELETE CASCADE
4003
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4004
3956
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4005
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3957
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4006
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3958
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4007
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 188-193 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
188
('IDreamBooksResults','0','','Display IDreamBooks.com rating in search results','YesNo'),
188
('IDreamBooksResults','0','','Display IDreamBooks.com rating in search results','YesNo'),
189
('IDreamBooksReviews','0','','Display book review snippets from IDreamBooks.com','YesNo'),
189
('IDreamBooksReviews','0','','Display book review snippets from IDreamBooks.com','YesNo'),
190
('IdRef','0','','Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'),
190
('IdRef','0','','Disable/enable the IdRef webservice from the OPAC detail page.','YesNo'),
191
('ILLModule','0','If ON, enables the interlibrary loans module.','','YesNo'),
191
('ILS-DI','0','','Enables ILS-DI services at OPAC.','YesNo'),
192
('ILS-DI','0','','Enables ILS-DI services at OPAC.','YesNo'),
192
('ILS-DI:AuthorizedIPs','','Restricts usage of ILS-DI to some IPs','.','Free'),
193
('ILS-DI:AuthorizedIPs','','Restricts usage of ILS-DI to some IPs','.','Free'),
193
('ImageLimit','5','','Limit images stored in the database by the Patron Card image manager to this number.','Integer'),
194
('ImageLimit','5','','Limit images stored in the database by the Patron Card image manager to this number.','Integer'),
(-)a/installer/data/mysql/userflags.sql (-1 / +2 lines)
Lines 17-21 INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES Link Here
17
(17,'staffaccess','Allow staff members to modify permissions for other staff members',0),
17
(17,'staffaccess','Allow staff members to modify permissions for other staff members',0),
18
(18,'coursereserves','Course reserves',0),
18
(18,'coursereserves','Course reserves',0),
19
(19, 'plugins', 'Koha plugins', '0'),
19
(19, 'plugins', 'Koha plugins', '0'),
20
(20, 'lists', 'Lists', 0)
20
(20, 'lists', 'Lists', 0),
21
(21,'ill','The Interlibrary Loans Module',0)
21
;
22
;
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref (-1 / +8 lines)
Lines 65-70 Administration: Link Here
65
              choices:
65
              choices:
66
                  yes: "The logged-in library"
66
                  yes: "The logged-in library"
67
                  no: "All libraries"
67
                  no: "All libraries"
68
    Interlibrary Loans:
69
        -
70
            - pref: ILLModule
71
              default: 0
72
              choices:
73
                  yes: Enable
74
                  no: Disable
75
            - the interlibrary loans module (master switch).
68
    Login options:
76
    Login options:
69
        -
77
        -
70
            - "Inactivity timeout in seconds to automatically log out users: "
78
            - "Inactivity timeout in seconds to automatically log out users: "
71
- 

Return to bug 7317