5 description => "Move NumSavedReports to table settings and allow tables_settings.default_display_length to be NULL",
8 my ($dbh, $out) = @$args{qw(dbh out)};
11 ALTER TABLE tables_settings
12 MODIFY COLUMN default_display_length smallint(6) DEFAULT NULL
15 my $NumSavedReports = C4::Context->preference('NumSavedReports');
17 DELETE FROM systempreferences
18 WHERE variable="NumSavedReports"
21 if ( $NumSavedReports ) {
23 INSERT IGNORE INTO tables_settings (module, page, tablename, default_display_length, default_sort_order)
24 VALUES('reports', 'saved-sql', 'table_reports', ?, 1)
25 }, undef, $NumSavedReports);
26 say $out "NumSavedReports value '$NumSavedReports' moved to table settings";