Attachment #113616 for bug #24860

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




        });
    }

    unless ( column_exists( 'reserves', 'volume_id' ) ) {
        $dbh->do(q{
            ALTER TABLE reserves
            ADD COLUMN `volume_id` int(11) NULL default NULL AFTER biblionumber,
            ADD CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
        });
    }

    unless ( column_exists( 'old_reserves', 'volume_id' ) ) {
        $dbh->do(q{
            ALTER TABLE old_reserves
            ADD COLUMN `volume_id` int(11) NULL default NULL AFTER biblionumber,
            ADD CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
        });
    }

    # Always end with this (adjust the bug info)
    SetVersion( $DBversion );
    print "Upgrade to $DBversion done (Bug XXXXX - Add ability to define volumes for items on a record)\n";




  `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for
  `reservedate` date default NULL, -- the date the hold was placed
  `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on
  `volume_id` int(11) NULL default NULL, -- foreign key from the volumes table defining if this is a volume level hold
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
  `desk_id` int(11) default NULL, -- foreign key from the desks table defining which desk the patron should pick this hold up at
  `notificationdate` date default NULL, -- currently unused

  CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `reserves_ibfk_7` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--

  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for
  `reservedate` date default NULL, -- the date the hold was places
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on
  `volume_id` int(11) NULL default NULL, -- foreign key from the volumes table defining if this is a volume level hold
  `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at
  `desk_id` int(11) default NULL, -- foreign key from the desks table defining which desk the patron should pick this hold up at
  `notificationdate` date default NULL, -- currently unused

  CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
    ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
    ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `old_reserves_ibfk_5` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`)
    ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

- 

Return to bug 24860

Lines 39-44 if ( CheckVersion( $DBversion ) ) { Link Here

(-)a/installer/data/mysql/atomicupdate/volumes.perl (+16 lines)
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";

Lines 1825-1830 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +6 lines)
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	-