Attachment #113136 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 704-709 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

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

Lines 645-651 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-2 / +7 lines)
645	- the last patron to return an item. This setting is independent of the opacreadinghistory and AnonymousPatron system preferences.	645	- the last patron to return an item. This setting is independent of the opacreadinghistory and AnonymousPatron system preferences.
646	Holds policy:	646	Holds policy:
647	-	647	-
648	- In the staff interface, split the holds queue into separate tables by	648	- pref: EnableVolumes
		649	choices:
		650	yes: Enable
		651	no: "Don't enable"
		652	- volumes feature to allow collecting groups of items on a record into volumes.
		653	-
		654	- In the staff client, split the holds queue into separate tables by
649	- pref: HoldsSplitQueue	655	- pref: HoldsSplitQueue
650	choices:	656	choices:
651	nothing: nothing	657	nothing: nothing
652	-

Return to bug 24857

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

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

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	}