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




) 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 677-682 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
677	('UseKohaPlugins','0','','Enable or disable the ability to use Koha Plugins.','YesNo'),	677	('UseKohaPlugins','0','','Enable or disable the ability to use Koha Plugins.','YesNo'),
678	('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),	678	('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),
679	('UseWYSIWYGinSystemPreferences','0','','Show WYSIWYG editor when editing certain HTML system preferences.','YesNo'),	679	('UseWYSIWYGinSystemPreferences','0','','Show WYSIWYG editor when editing certain HTML system preferences.','YesNo'),
		680	('EnableVolumes','0','','Enable volumes feature','YesNo'),
680	('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),	681	('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),
681	('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),	682	('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),
682	('viewMARC','1','','Allow display of MARC view of bibiographic records','YesNo'),	683	('viewMARC','1','','Allow display of MARC view of bibiographic records','YesNo'),

Lines 596-601 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +6 lines)
596	- the last patron to return an item. This setting is independent of opacreadinghistory/AnonymousPatron.	596	- the last patron to return an item. This setting is independent of opacreadinghistory/AnonymousPatron.
597	Holds Policy:	597	Holds Policy:
598	-	598	-
		599	- pref: EnableVolumes
		600	choices:
		601	yes: Enable
		602	no: "Don't enable"
		603	- volumes feature to allow collecting groups of items on a record into volumes.
		604	-
599	- In the staff client, split the holds queue into separate tables by	605	- In the staff client, split the holds queue into separate tables by
600	- pref: HoldsSplitQueue	606	- pref: HoldsSplitQueue
601	choices:	607	choices:
602	-

Return to bug 24857

Lines 1761-1766 CREATE TABLE `patronimage` ( -- information related to patron images Link Here

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

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	}