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

(-)a/installer/data/mysql/atomicupdate/bug_31297_allow_NULL_description_in_serial_numberpatterns.pl (+18 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "31297",
5
    description => "Allow subscription number pattern description to be NULL",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        $dbh->do(q{
11
            ALTER TABLE subscription_numberpatterns MODIFY description mediumtext DEFAULT NULL
12
        });
13
14
        say $out "Added new table 'XXX'";
15
        say $out "Modified column 'subscription_numberpatterns.description' to allow and default to NULL";
16
17
    },
18
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 6018-6024 CREATE TABLE `subscription_numberpatterns` ( Link Here
6018
  `id` int(11) NOT NULL AUTO_INCREMENT,
6018
  `id` int(11) NOT NULL AUTO_INCREMENT,
6019
  `label` varchar(255) NOT NULL,
6019
  `label` varchar(255) NOT NULL,
6020
  `displayorder` int(11) DEFAULT NULL,
6020
  `displayorder` int(11) DEFAULT NULL,
6021
  `description` mediumtext NOT NULL,
6021
  `description` mediumtext DEFAULT NULL,
6022
  `numberingmethod` varchar(255) NOT NULL,
6022
  `numberingmethod` varchar(255) NOT NULL,
6023
  `label1` varchar(255) DEFAULT NULL,
6023
  `label1` varchar(255) DEFAULT NULL,
6024
  `add1` int(11) DEFAULT NULL,
6024
  `add1` int(11) DEFAULT NULL,
6025
- 

Return to bug 31297