Attachment #101637 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 675-680 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
675	('UseQueryParser','0',NULL,'If enabled, try to use QueryParser for queries.','YesNo'),	675	('UseQueryParser','0',NULL,'If enabled, try to use QueryParser for queries.','YesNo'),
676	('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),	676	('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),
677	('UseWYSIWYGinSystemPreferences','0','','Show WYSIWYG editor when editing certain HTML system preferences.','YesNo'),	677	('UseWYSIWYGinSystemPreferences','0','','Show WYSIWYG editor when editing certain HTML system preferences.','YesNo'),
		678	('EnableVolumes','0','','Enable volumes feature','YesNo'),
678	('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),	679	('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),
679	('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),	680	('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),
680	('viewMARC','1','','Allow display of MARC view of bibiographic records','YesNo'),	681	('viewMARC','1','','Allow display of MARC view of bibiographic records','YesNo'),

Lines 575-580 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +6 lines)
575	no: "Don't block"	575	no: "Don't block"
576	- staff from continuing to checkin items when a transfer is triggered.	576	- staff from continuing to checkin items when a transfer is triggered.
577	Holds Policy:	577	Holds Policy:
		578	-
		579	- pref: EnableVolumes
		580	choices:
		581	yes: Enable
		582	no: "Don't enable"
		583	- volumes feature to allow collecting groups of items on a record into volumes.
578	-	584	-
579	- In the staff client, split the holds queue into separate tables by	585	- In the staff client, split the holds queue into separate tables by
580	- pref: HoldsSplitQueue	586	- pref: HoldsSplitQueue
581	-

Return to bug 24857

Lines 1754-1759 CREATE TABLE `patronimage` ( -- information related to patron images Link Here

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

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	}