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

(-)a/installer/data/mysql/atomicupdate/bug_29648_2.pl (+14 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "29648",
5
    description => "Allow tables_settings.default_display_length to be NULL",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
            ALTER TABLE tables_settings
11
            MODIFY COLUMN default_display_length smallint(6) DEFAULT NULL
12
        });
13
    },
14
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 5058-5064 CREATE TABLE `tables_settings` ( Link Here
5058
  `module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
5058
  `module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
5059
  `page` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
5059
  `page` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
5060
  `tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
5060
  `tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
5061
  `default_display_length` smallint(6) NOT NULL DEFAULT 20,
5061
  `default_display_length` smallint(6) DEFAULT NULL,
5062
  `default_sort_order` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5062
  `default_sort_order` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5063
  PRIMARY KEY (`module`(191),`page`(191),`tablename`(191))
5063
  PRIMARY KEY (`module`(191),`page`(191),`tablename`(191))
5064
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5064
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5065
- 

Return to bug 29648