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

(-)a/installer/data/mysql/atomicupdate/volumes.perl (+16 lines)
Lines 39-44 if ( CheckVersion( $DBversion ) ) { Link Here
39
        });
39
        });
40
    }
40
    }
41
41
42
    unless ( column_exists( 'reserves', 'volume_id' ) ) {
43
        $dbh->do(q{
44
            ALTER TABLE reserves
45
            ADD COLUMN `volume_id` int(11) NULL default NULL AFTER biblionumber,
46
            ADD CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
47
        });
48
    }
49
50
    unless ( column_exists( 'old_reserves', 'volume_id' ) ) {
51
        $dbh->do(q{
52
            ALTER TABLE old_reserves
53
            ADD COLUMN `volume_id` int(11) NULL default NULL AFTER biblionumber,
54
            ADD CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
55
        });
56
    }
57
42
    # Always end with this (adjust the bug info)
58
    # Always end with this (adjust the bug info)
43
    SetVersion( $DBversion );
59
    SetVersion( $DBversion );
44
    print "Upgrade to $DBversion done (Bug XXXXX - Add ability to define volumes for items on a record)\n";
60
    print "Upgrade to $DBversion done (Bug XXXXX - Add ability to define volumes for items on a record)\n";
(-)a/installer/data/mysql/kohastructure.sql (-2 / +6 lines)
Lines 1825-1830 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1825
  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1825
  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
1826
  `reservedate` date default NULL, -- the date the hold was placed
1826
  `reservedate` date default NULL, -- the date the hold was placed
1827
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1827
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
1828
  `volume_id` int(11) NULL default NULL, -- foreign key from the volumes table defining if this is a volume level hold
1828
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1829
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1829
  `desk_id` int(11) default NULL, -- foreign key from the desks table defining which desk the patron should pick this hold up at
1830
  `desk_id` int(11) default NULL, -- foreign key from the desks table defining which desk the patron should pick this hold up at
1830
  `notificationdate` date default NULL, -- currently unused
1831
  `notificationdate` date default NULL, -- currently unused
Lines 1857-1863 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1857
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1858
  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1858
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1859
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1859
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
1860
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
1860
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE
1861
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE,
1862
  CONSTRAINT `reserves_ibfk_7` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
1861
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1863
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1862
1864
1863
--
1865
--
Lines 1870-1875 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1870
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
1872
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
1871
  `reservedate` date default NULL, -- the date the hold was places
1873
  `reservedate` date default NULL, -- the date the hold was places
1872
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1874
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
1875
  `volume_id` int(11) NULL default NULL, -- foreign key from the volumes table defining if this is a volume level hold
1873
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1876
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
1874
  `desk_id` int(11) default NULL, -- foreign key from the desks table defining which desk the patron should pick this hold up at
1877
  `desk_id` int(11) default NULL, -- foreign key from the desks table defining which desk the patron should pick this hold up at
1875
  `notificationdate` date default NULL, -- currently unused
1878
  `notificationdate` date default NULL, -- currently unused
Lines 1902-1907 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1902
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1905
  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1903
    ON DELETE SET NULL ON UPDATE SET NULL,
1906
    ON DELETE SET NULL ON UPDATE SET NULL,
1904
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1907
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
1908
    ON DELETE SET NULL ON UPDATE SET NULL,
1909
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`)
1905
    ON DELETE SET NULL ON UPDATE SET NULL
1910
    ON DELETE SET NULL ON UPDATE SET NULL
1906
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1911
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1907
1912
1908
- 

Return to bug 24860