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

(-)a/installer/data/mysql/atomicupdate/bug_24412_Attach_waiting_reserve_to_desk.perl (+16 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    # you can use $dbh here like:
4
    $dbh->do(q{
5
ALTER TABLE reserves ADD COLUMN desk_id INT(11) DEFAULT NULL AFTER branchcode,
6
  ADD KEY desk_id (`desk_id`),
7
  ADD CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE CASCADE ON UPDATE CASCADE ;
8
             });
9
    $dbh->do(q{
10
ALTER TABLE old_reserves ADD COLUMN desk_id INT(11) DEFAULT NULL AFTER branchcode,
11
  ADD KEY `old_desk_id` (`desk_id`);
12
             });
13
14
    SetVersion( $DBversion );
15
    print "Upgrade to $DBversion done (Bug XXXXX - Attach waiting reserve to desk)\n";
16
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +5 lines)
Lines 1763-1768 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1763
  `reservedate` date default NULL, -- the date the hold was placed
1763
  `reservedate` date default NULL, -- the date the hold was placed
1764
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1764
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1765
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1765
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1766
  `desk_id` int(11) default NULL, -- foreign key from the desks table defining which desk the patron should pick this hold up at
1766
  `notificationdate` date default NULL, -- currently unused
1767
  `notificationdate` date default NULL, -- currently unused
1767
  `reminderdate` date default NULL, -- currently unused
1768
  `reminderdate` date default NULL, -- currently unused
1768
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1769
  `cancellationdate` date default NULL, -- the date this hold was cancelled
Lines 1786-1797 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1786
  KEY `biblionumber` (`biblionumber`),
1787
  KEY `biblionumber` (`biblionumber`),
1787
  KEY `itemnumber` (`itemnumber`),
1788
  KEY `itemnumber` (`itemnumber`),
1788
  KEY `branchcode` (`branchcode`),
1789
  KEY `branchcode` (`branchcode`),
1790
  KEY `desk_id` (`desk_id`),
1789
  KEY `itemtype` (`itemtype`),
1791
  KEY `itemtype` (`itemtype`),
1790
  CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1792
  CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1791
  CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1793
  CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1792
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1794
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1793
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1795
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1794
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE
1796
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
1797
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE CASCADE ON UPDATE CASCADE
1795
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1798
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1796
1799
1797
--
1800
--
Lines 1805-1810 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1805
  `reservedate` date default NULL, -- the date the hold was places
1808
  `reservedate` date default NULL, -- the date the hold was places
1806
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1809
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1807
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1810
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1811
  `desk_id` int(11) default NULL, -- foreign key from the desks table defining which desk the patron should pick this hold up at
1808
  `notificationdate` date default NULL, -- currently unused
1812
  `notificationdate` date default NULL, -- currently unused
1809
  `reminderdate` date default NULL, -- currently unused
1813
  `reminderdate` date default NULL, -- currently unused
1810
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1814
  `cancellationdate` date default NULL, -- the date this hold was cancelled
1811
- 

Return to bug 24412