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 1233-1239 CREATE TABLE `borrower_message_preferences` ( Link Here
1233
  `borrowernumber` int(11) DEFAULT NULL,
1233
  `borrowernumber` int(11) DEFAULT NULL,
1234
  `categorycode` varchar(10) DEFAULT NULL,
1234
  `categorycode` varchar(10) DEFAULT NULL,
1235
  `message_attribute_id` int(11) DEFAULT 0,
1235
  `message_attribute_id` int(11) DEFAULT 0,
1236
  `days_in_advance` int(11) DEFAULT 0,
1236
  `days_in_advance` int(11) DEFAULT NULL,
1237
  `wants_digest` tinyint(1) NOT NULL DEFAULT 0,
1237
  `wants_digest` tinyint(1) NOT NULL DEFAULT 0,
1238
  PRIMARY KEY (`borrower_message_preference_id`),
1238
  PRIMARY KEY (`borrower_message_preference_id`),
1239
  KEY `borrowernumber` (`borrowernumber`),
1239
  KEY `borrowernumber` (`borrowernumber`),
1240
- 

Return to bug 32357