Attachment #108666 for bug #24857

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




$DBversion = 'XXX'; # will be replaced by the RM
if ( CheckVersion( $DBversion ) ) {
    $dbh->do(q{
        INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
        ('EnableVolumes','0','','Enable volumes feature','YesNo');
    });

    unless ( TableExists('volumes') ) {
        $dbh->do(q{
            CREATE TABLE `volumes` ( -- information related to bibliographic records in Koha
            `id` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
            `biblionumber` INT(11) NOT NULL default 0, -- foreign key linking this table to the biblio table
            `display_order` INT(4) NOT NULL default 0, -- specifies the 'sort order' for volumes
            `description` MEDIUMTEXT default NULL, -- equivilent to enumchron
            `created_on` TIMESTAMP NULL, -- Time and date the volume was created
            `updated_on` TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- Time and date of the latest change on the volume (description)
            PRIMARY KEY  (`id`),
            CONSTRAINT `volumes_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        });
    }

    unless ( TableExists('volume_items') ) {
        $dbh->do(q{
            CREATE TABLE `volume_items` ( -- information related to bibliographic records in Koha
            `id` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
            `volume_id` int(11) NOT NULL default 0, -- foreign key making this table a 1 to 1 join from items to volumes
            `itemnumber` int(11) NOT NULL default 0, -- foreign key linking this table to the items table
            PRIMARY KEY  (`id`),
            UNIQUE KEY (volume_id,itemnumber),
            CONSTRAINT `volume_items_iifk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
            CONSTRAINT `volume_items_vifk_1` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        });
    }

    # 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";
}




  CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `volumes`
--

DROP TABLE IF EXISTS `volumes`;
CREATE TABLE `volumes` ( -- information related to bibliographic records in Koha
  `id` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
  `biblionumber` INT(11) NOT NULL default 0, -- foreign key linking this table to the biblio table
  `display_order` INT(4) NOT NULL default 0, -- specifies the 'sort order' for volumes
  `description` MEDIUMTEXT default NULL, -- equivilent to enumchron
  `created_on` TIMESTAMP NULL, -- Time and date the volume was created
  `updated_on` TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- Time and date of the latest change on the volume (description)
  PRIMARY KEY  (`id`),
  CONSTRAINT `volumes_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `volume_items`
--

DROP TABLE IF EXISTS `volume_items`;
CREATE TABLE `volume_items` ( -- information related to bibliographic records in Koha
  `id` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
  `volume_id` int(11) NOT NULL default 0, -- foreign key making this table a 1 to 1 join from items to volumes
  `itemnumber` int(11) NOT NULL default 0, -- foreign key linking this table to the items table
  PRIMARY KEY  (`id`),
  UNIQUE KEY (volume_id,itemnumber),
  CONSTRAINT `volume_items_iifk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `volume_items_vifk_1` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `reserves`
--

Lines 693-698 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
693	('UseICU','0','1','Tell Koha if ICU indexing is in use for Zebra or not.','YesNo'),	693	('UseICU','0','1','Tell Koha if ICU indexing is in use for Zebra or not.','YesNo'),
694	('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),	694	('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),
695	('UseWYSIWYGinSystemPreferences','0','','Show WYSIWYG editor when editing certain HTML system preferences.','YesNo'),	695	('UseWYSIWYGinSystemPreferences','0','','Show WYSIWYG editor when editing certain HTML system preferences.','YesNo'),
		696	('EnableVolumes','0','','Enable volumes feature','YesNo'),
696	('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),	697	('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),
697	('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),	698	('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),
698	('viewMARC','1','','Allow display of MARC view of bibiographic records','YesNo'),	699	('viewMARC','1','','Allow display of MARC view of bibiographic records','YesNo'),

Lines 621-626 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +6 lines)
621	no: "Don't store"	621	no: "Don't store"
622	- the last patron to return an item. This setting is independent of opacreadinghistory/AnonymousPatron.	622	- the last patron to return an item. This setting is independent of opacreadinghistory/AnonymousPatron.
623	Holds policy:	623	Holds policy:
		624	-
		625	- pref: EnableVolumes
		626	choices:
		627	yes: Enable
		628	no: "Don't enable"
		629	- volumes feature to allow collecting groups of items on a record into volumes.
624	-	630	-
625	- In the staff client, split the holds queue into separate tables by	631	- In the staff client, split the holds queue into separate tables by
626	- pref: HoldsSplitQueue	632	- pref: HoldsSplitQueue
627	-

Return to bug 24857

Lines 1746-1751 CREATE TABLE `patronimage` ( -- information related to patron images Link Here

(-)a/installer/data/mysql/kohastructure.sql (+31 lines)
1746	CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE	1746	CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1747	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	1747	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1748		1748
		1749	--
		1750	-- Table structure for table `volumes`
		1751	--
		1752
		1753	DROP TABLE IF EXISTS `volumes`;
		1754	CREATE TABLE `volumes` ( -- information related to bibliographic records in Koha
		1755	`id` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
		1756	`biblionumber` INT(11) NOT NULL default 0, -- foreign key linking this table to the biblio table
		1757	`display_order` INT(4) NOT NULL default 0, -- specifies the 'sort order' for volumes
		1758	`description` MEDIUMTEXT default NULL, -- equivilent to enumchron
		1759	`created_on` TIMESTAMP NULL, -- Time and date the volume was created
		1760	`updated_on` TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- Time and date of the latest change on the volume (description)
		1761	PRIMARY KEY (`id`),
		1762	CONSTRAINT `volumes_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
		1763	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		1764
		1765	--
		1766	-- Table structure for table `volume_items`
		1767	--
		1768
		1769	DROP TABLE IF EXISTS `volume_items`;
		1770	CREATE TABLE `volume_items` ( -- information related to bibliographic records in Koha
		1771	`id` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
		1772	`volume_id` int(11) NOT NULL default 0, -- foreign key making this table a 1 to 1 join from items to volumes
		1773	`itemnumber` int(11) NOT NULL default 0, -- foreign key linking this table to the items table
		1774	PRIMARY KEY (`id`),
		1775	UNIQUE KEY (volume_id,itemnumber),
		1776	CONSTRAINT `volume_items_iifk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
		1777	CONSTRAINT `volume_items_vifk_1` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
		1778	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		1779
1749	--	1780	--
1750	-- Table structure for table `reserves`	1781	-- Table structure for table `reserves`
1751	--	1782	--

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/volumes.perl (+40 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if ( CheckVersion( $DBversion ) ) {
	3	$dbh->do(q{
	4	INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
	5	('EnableVolumes','0','','Enable volumes feature','YesNo');
	6	});
	7
	8	unless ( TableExists('volumes') ) {
	9	$dbh->do(q{
	10	CREATE TABLE `volumes` ( -- information related to bibliographic records in Koha
	11	`id` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
	12	`biblionumber` INT(11) NOT NULL default 0, -- foreign key linking this table to the biblio table
	13	`display_order` INT(4) NOT NULL default 0, -- specifies the 'sort order' for volumes
	14	`description` MEDIUMTEXT default NULL, -- equivilent to enumchron
	15	`created_on` TIMESTAMP NULL, -- Time and date the volume was created
	16	`updated_on` TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- Time and date of the latest change on the volume (description)
	17	PRIMARY KEY (`id`),
	18	CONSTRAINT `volumes_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
	19	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
	20	});
	21	}
	22
	23	unless ( TableExists('volume_items') ) {
	24	$dbh->do(q{
	25	CREATE TABLE `volume_items` ( -- information related to bibliographic records in Koha
	26	`id` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
	27	`volume_id` int(11) NOT NULL default 0, -- foreign key making this table a 1 to 1 join from items to volumes
	28	`itemnumber` int(11) NOT NULL default 0, -- foreign key linking this table to the items table
	29	PRIMARY KEY (`id`),
	30	UNIQUE KEY (volume_id,itemnumber),
	31	CONSTRAINT `volume_items_iifk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
	32	CONSTRAINT `volume_items_vifk_1` FOREIGN KEY (`volume_id`) REFERENCES `volumes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
	33	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
	34	});
	35	}
	36
	37	# Always end with this (adjust the bug info)
	38	SetVersion( $DBversion );
	39	print "Upgrade to $DBversion done (Bug XXXXX - Add ability to define volumes for items on a record)\n";
	40	}