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

(-)a/installer/data/mysql/atomicupdate/bug_24010.pl (+2 lines)
Lines 15-20 return { Link Here
15
        $dbh->do(q{
15
        $dbh->do(q{
16
            ALTER TABLE subscription
16
            ALTER TABLE subscription
17
            MODIFY COLUMN staffdisplaycount INT(11) NULL DEFAULT NULL
17
            MODIFY COLUMN staffdisplaycount INT(11) NULL DEFAULT NULL
18
            COMMENT 'how many issues to show to the staff'
18
        });
19
        });
19
20
20
        $dbh->do(q{
21
        $dbh->do(q{
Lines 25-30 return { Link Here
25
        $dbh->do(q{
26
        $dbh->do(q{
26
            ALTER TABLE subscription
27
            ALTER TABLE subscription
27
            MODIFY COLUMN opacdisplaycount INT(11) NULL DEFAULT NULL
28
            MODIFY COLUMN opacdisplaycount INT(11) NULL DEFAULT NULL
29
            COMMENT 'how many issues to show to the public'
28
        });
30
        });
29
    },
31
    },
30
};
32
};
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 4899-4906 CREATE TABLE `subscription` ( Link Here
4899
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'default branches (items.homebranch)',
4899
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'default branches (items.homebranch)',
4900
  `lastbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4900
  `lastbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4901
  `serialsadditems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'does receiving this serial create an item record',
4901
  `serialsadditems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'does receiving this serial create an item record',
4902
  `staffdisplaycount` INT(11) NULL DEFAULT NULL, -- how many issues to show to the staff
4902
  `staffdisplaycount` INT(11) NULL DEFAULT NULL COMMENT 'how many issues to show to the staff',
4903
  `opacdisplaycount` INT(11) NULL DEFAULT NULL, -- how many issues to show to the public
4903
  `opacdisplaycount` INT(11) NULL DEFAULT NULL COMMENT 'how many issues to show to the public',
4904
  `graceperiod` int(11) NOT NULL DEFAULT 0 COMMENT 'grace period in days',
4904
  `graceperiod` int(11) NOT NULL DEFAULT 0 COMMENT 'grace period in days',
4905
  `enddate` date DEFAULT NULL COMMENT 'subscription end date',
4905
  `enddate` date DEFAULT NULL COMMENT 'subscription end date',
4906
  `closed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes / no if the subscription is closed',
4906
  `closed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes / no if the subscription is closed',
4907
- 

Return to bug 24010