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

(-)a/installer/data/mysql/atomicupdate/bug_32357.pl (+14 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "32357",
5
    description => "Set borrower_message_preferences.days_in_advance default to NULL",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
            ALTER TABLE borrower_message_preferences ALTER days_in_advance SET DEFAULT NULL;
11
        });
12
        say $out "Updated column 'borrower_message_preferences.days_in_advance default' to NULL";
13
    },
14
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1253-1259 CREATE TABLE `borrower_message_preferences` ( Link Here
1253
  `borrowernumber` int(11) DEFAULT NULL,
1253
  `borrowernumber` int(11) DEFAULT NULL,
1254
  `categorycode` varchar(10) DEFAULT NULL,
1254
  `categorycode` varchar(10) DEFAULT NULL,
1255
  `message_attribute_id` int(11) DEFAULT 0,
1255
  `message_attribute_id` int(11) DEFAULT 0,
1256
  `days_in_advance` int(11) DEFAULT 0,
1256
  `days_in_advance` int(11) DEFAULT NULL,
1257
  `wants_digest` tinyint(1) NOT NULL DEFAULT 0,
1257
  `wants_digest` tinyint(1) NOT NULL DEFAULT 0,
1258
  PRIMARY KEY (`borrower_message_preference_id`),
1258
  PRIMARY KEY (`borrower_message_preference_id`),
1259
  KEY `borrowernumber` (`borrowernumber`),
1259
  KEY `borrowernumber` (`borrowernumber`),
1260
- 

Return to bug 32357