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

(-)a/installer/data/mysql/atomicupdate/bug_14697.perl (+48 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 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 IGNORE INTO `authorised_values` ( category, authorised_value, lib )

            

            

              41
              
        VALUES

            

            

              42
              
          ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'),

            

            

              43
              
          ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library');

            

            

              44
              
    });

            

            

              45
              

            

            

              46
              
    SetVersion( $DBversion );

            

            

              47
              
    print "Upgrade to $DBversion done (Bug 14697 - Extend and enhance 'Claims returned' lost status)\n";

            

            

              48
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (+30 lines)




  

    
      
            Lines 4361-4366
          CREATE TABLE itemtypes_branches( -- association table between authorised_values
      
      
        Link Here
      
    
  

        

          4361
          
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE

          4361
          
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE

        

        

          4362
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

          4362
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

        

        

          4363
          

          4363
          

        

            

              
              
              4364
              
--

            

            

              4365
              
-- Table structure for table `return_claims`

            

            

              4366
              
--

            

            

              4367
              

            

            

              4368
              
DROP TABLE IF EXISTS `return_claims`;

            

            

              4369
              
CREATE TABLE return_claims (

            

            

              4370
              
    id int(11) auto_increment,

            

            

              4371
              
    itemnumber int(11) NOT NULL,

            

            

              4372
              
    issue_id int(11) NULL DEFAULT NULL,

            

            

              4373
              
    old_issue_id int(11) NULL DEFAULT NULL,

            

            

              4374
              
    borrowernumber int(11) NOT NULL,

            

            

              4375
              
    notes MEDIUMTEXT DEFAULT NULL,

            

            

              4376
              
    created_on TIMESTAMP NULL,

            

            

              4377
              
    created_by int(11) NULL DEFAULT NULL,

            

            

              4378
              
    updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP,

            

            

              4379
              
    updated_by int(11) NULL DEFAULT NULL,

            

            

              4380
              
    resolution  varchar(80) NULL DEFAULT NULL,

            

            

              4381
              
    resolved_on TIMESTAMP NULL DEFAULT NULL,

            

            

              4382
              
    resolved_by int(11) NULL DEFAULT NULL,

            

            

              4383
              
    PRIMARY KEY (`id`),

            

            

              4384
              
    KEY `itemnumber` (`itemnumber`),

            

            

              4385
              
    CONSTRAINT `rc_issues_ibfk` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE,

            

            

              4386
              
    CONSTRAINT `rc_old_issues_ibfk` FOREIGN KEY (`old_issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE,

            

            

              4387
              
    CONSTRAINT `rc_items_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,

            

            

              4388
              
    CONSTRAINT `rc_borrowers_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,

            

            

              4389
              
    CONSTRAINT `rc_created_by_ibfk` FOREIGN KEY (`created_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,

            

            

              4390
              
    CONSTRAINT `rc_updated_by_ibfk` FOREIGN KEY (`updated_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,

            

            

              4391
              
    CONSTRAINT `rc_resolved_by_ibfk` FOREIGN KEY (`resolved_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE

            

            

              4392
              
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

            

            

              4393
              

            

        

          4364
          
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

          4394
          
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

        

        

          4365
          
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

          4395
          
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

        

        

          4366
          
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

          4396
          
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

        



(-)a/installer/data/mysql/sysprefs.sql
      (-1 / +3 lines)




  

    
      
            Lines 120-125
          INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
      
      
        Link Here
      
    
  

        

          120
          
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),

          120
          
('CircControl','ItemHomeLibrary','PickupLibrary|PatronLibrary|ItemHomeLibrary','Specify the agency that controls the circulation and fines policy','Choice'),

        

        

          121
          
('CircSidebar','0',NULL,'Activate or deactivate the navigation sidebar on all Circulation pages','YesNo'),

          121
          
('CircSidebar','0',NULL,'Activate or deactivate the navigation sidebar on all Circulation pages','YesNo'),

        

        

          122
          
('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),

          122
          
('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo'),

        

            

              
              
              123
              
('ClaimReturnedChargeFee', 'ask', 'ask|charge|no_charge', 'Controls whether or not a lost item fee is charged for return claims', 'Choice'),

            

            

              124
              
('ClaimReturnedLostValue', '', '', 'Sets the LOST AV value that represents "Claims returned" as a lost value', 'Free'),

            

            

              125
              
('ClaimReturnedWarningThreshold', '', '', 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'),

            

        

          123
          
('CoceHost', '', NULL, 'Coce server URL', 'Free'),

          126
          
('CoceHost', '', NULL, 'Coce server URL', 'Free'),

        

        

          124
          
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),

          127
          
('CoceProviders', '', 'aws,gb,ol', 'Coce providers', 'multiple'),

        

        

          125
          
('COinSinOPACResults','1','','If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),

          128
          
('COinSinOPACResults','1','','If ON, use COinS in OPAC search results page.  NOTE: this can slow down search response time significantly','YesNo'),

        

            

              126
              
- 

              
              
            






  

  Return to bug 14697