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

(-)a/installer/data/mysql/atomicupdate/bug_31086_do_not_allow_null_branchcode_in_reserves.pl (-1 / +1 lines)
Lines 8-14 return { Link Here
8
        my ($dbh, $out) = @$args{qw(dbh out)};
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
9
        $dbh->do(q{
10
            ALTER TABLE reserves
10
            ALTER TABLE reserves
11
            MODIFY COLUMN `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 0 COMMENT 'foreign key from the branches table defining which branch the patron wishes to pick this hold up at'
11
            MODIFY COLUMN `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'foreign key from the branches table defining which branch the patron wishes to pick this hold up at'
12
        });
12
        });
13
        # Print useful stuff here
13
        # Print useful stuff here
14
        say $out "Removed NULL option from branchcode for reserves";
14
        say $out "Removed NULL option from branchcode for reserves";
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 4439-4445 CREATE TABLE `reserves` ( Link Here
4439
  `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this hold is for',
4439
  `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the borrowers table defining which patron this hold is for',
4440
  `reservedate` date DEFAULT NULL COMMENT 'the date the hold was placed',
4440
  `reservedate` date DEFAULT NULL COMMENT 'the date the hold was placed',
4441
  `biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this hold is on',
4441
  `biblionumber` int(11) NOT NULL DEFAULT 0 COMMENT 'foreign key from the biblio table defining which bib record this hold is on',
4442
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 0 COMMENT 'foreign key from the branches table defining which branch the patron wishes to pick this hold up at',
4442
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'foreign key from the branches table defining which branch the patron wishes to pick this hold up at',
4443
  `desk_id` int(11) DEFAULT NULL COMMENT 'foreign key from the desks table defining which desk the patron should pick this hold up at',
4443
  `desk_id` int(11) DEFAULT NULL COMMENT 'foreign key from the desks table defining which desk the patron should pick this hold up at',
4444
  `notificationdate` date DEFAULT NULL COMMENT 'currently unused',
4444
  `notificationdate` date DEFAULT NULL COMMENT 'currently unused',
4445
  `reminderdate` date DEFAULT NULL COMMENT 'currently unused',
4445
  `reminderdate` date DEFAULT NULL COMMENT 'currently unused',
4446
- 

Return to bug 31086