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

(-)a/installer/data/mysql/atomicupdate/volumes.perl (+40 lines)
Line 0 Link Here
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
}
(-)a/installer/data/mysql/kohastructure.sql (+31 lines)
Lines 1751-1756 CREATE TABLE `patronimage` ( -- information related to patron images Link Here
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
--
(-)a/installer/data/mysql/mandatory/sysprefs.sql (+1 lines)
Lines 704-709 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
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'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-2 / +7 lines)
Lines 645-651 Circulation: Link Here
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