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

(-)a/installer/data/mysql/atomicupdate/bug_14697.perl (+52 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    if( !TableExists( 'return_claims' ) ) {
4
        $dbh->do(q{
5
            CREATE TABLE IF NOT EXISTS return_claims (
6
                id int(11) auto_increment,
7
                itemnumber int(11) NOT NULL,
8
                issue_id int(11) NULL DEFAULT NULL,
9
                old_issue_id int(11) NULL DEFAULT NULL,
10
                borrowernumber int(11) NOT NULL,
11
                notes MEDIUMTEXT DEFAULT NULL,
12
                created_on TIMESTAMP NULL,
13
                created_by int(11) NULL DEFAULT NULL,
14
                updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP,
15
                updated_by int(11) NULL DEFAULT NULL,
16
                resolution  varchar(80) NULL DEFAULT NULL,
17
                resolved_on TIMESTAMP NULL DEFAULT NULL,
18
                resolved_by int(11) NULL DEFAULT NULL,
19
                PRIMARY KEY (`id`),
20
                KEY `itemnumber` (`itemnumber`),
21
                CONSTRAINT `rc_issues_ibfk` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE,
22
                CONSTRAINT `rc_old_issues_ibfk` FOREIGN KEY (`old_issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE,
23
                CONSTRAINT `rc_items_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
24
                CONSTRAINT `rc_borrowers_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
25
                CONSTRAINT `rc_created_by_ibfk` FOREIGN KEY (`created_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
26
                CONSTRAINT `rc_updated_by_ibfk` FOREIGN KEY (`updated_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
27
                CONSTRAINT `rc_resolved_by_ibfk` FOREIGN KEY (`resolved_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
28
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
29
        });
30
    }
31
32
    $dbh->do(q{
33
        INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
34
        ('ClaimReturnedChargeFee', 'ask', 'ask|charge|no_charge', 'Controls whether or not a lost item fee is charged for return claims', 'Choice'),
35
        ('ClaimReturnedLostValue', '', '', 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'),
36
        ('ClaimReturnedWarningThreshold', '', '', 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer');
37
    });
38
39
    $dbh->do(q{
40
        INSERT INTO `authorised_values` ( category, authorised_value, lib, )
41
        VALUES
42
          (
43
            'RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'
44
          ),
45
          (
46
            'RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library',
47
          );
48
    });
49
50
    SetVersion( $DBversion );
51
    print "Upgrade to $DBversion done (Bug 14697 - Extend and enhance 'Claims returned' lost status)\n";
52
}
(-)a/installer/data/mysql/kohastructure.sql (+29 lines)
Lines 4278-4283 shortcut_keys varchar(80) NOT NULL, Link Here
4278
PRIMARY KEY (shortcut_name)
4278
PRIMARY KEY (shortcut_name)
4279
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4279
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4280
4280
4281
--
4282
-- Table structure for table `return_claims`
4283
--
4284
4285
CREATE TABLE IF NOT EXISTS return_claims (
4286
    id int(11) auto_increment,
4287
    itemnumber int(11) NOT NULL,
4288
    issue_id int(11) NULL DEFAULT NULL,
4289
    old_issue_id int(11) NULL DEFAULT NULL,
4290
    borrowernumber int(11) NOT NULL,
4291
    notes MEDIUMTEXT DEFAULT NULL,
4292
    created_on TIMESTAMP NULL,
4293
    created_by int(11) NULL DEFAULT NULL,
4294
    updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP,
4295
    updated_by int(11) NULL DEFAULT NULL,
4296
    resolution  varchar(80) NULL DEFAULT NULL,
4297
    resolved_on TIMESTAMP NULL DEFAULT NULL,
4298
    resolved_by int(11) NULL DEFAULT NULL,
4299
    PRIMARY KEY (`id`),
4300
    KEY `itemnumber` (`itemnumber`),
4301
    CONSTRAINT `rc_issues_ibfk` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE,
4302
    CONSTRAINT `rc_old_issues_ibfk` FOREIGN KEY (`old_issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE,
4303
    CONSTRAINT `rc_items_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
4304
    CONSTRAINT `rc_borrowers_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
4305
    CONSTRAINT `rc_created_by_ibfk` FOREIGN KEY (`created_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
4306
    CONSTRAINT `rc_updated_by_ibfk` FOREIGN KEY (`updated_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
4307
    CONSTRAINT `rc_resolved_by_ibfk` FOREIGN KEY (`resolved_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
4308
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4309
4281
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4310
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4282
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4311
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4283
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4312
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (-1 / +3 lines)
Lines 118-123 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
118
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),
118
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),
119
('CircSidebar','0',NULL,'Activate or deactivate the navigation sidebar on all Circulation pages','YesNo'),
119
('CircSidebar','0',NULL,'Activate or deactivate the navigation sidebar on all Circulation pages','YesNo'),
120
('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),
120
('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),
121
('ClaimReturnedChargeFee', 'ask', 'ask|charge|no_charge', 'Controls whether or not a lost item fee is charged for return claims', 'Choice'),
122
('ClaimReturnedLostValue', '', '', 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'),
123
('ClaimReturnedWarningThreshold', '', '', 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'),
121
('Coce','0', NULL, 'If on, enables cover retrieval from the configured Coce server', 'YesNo'),
124
('Coce','0', NULL, 'If on, enables cover retrieval from the configured Coce server', 'YesNo'),
122
('CoceHost', '', NULL, 'Coce server URL', 'Free'),
125
('CoceHost', '', NULL, 'Coce server URL', 'Free'),
123
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),
126
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),
124
- 

Return to bug 14697