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 1760-1765 CREATE TABLE `patronimage` ( -- information related to patron images Link Here
1760
  CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1760
  CONSTRAINT `patronimage_fk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1761
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1761
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1762
1762
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
1763
--
1794
--
1764
-- Table structure for table `reserves`
1795
-- Table structure for table `reserves`
1765
--
1796
--
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 677-682 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
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'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +6 lines)
Lines 595-600 Circulation: Link Here
595
                  no: "Don't store"
595
                  no: "Don't store"
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
        -
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.
598
        -
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
- 

Return to bug 24857