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

(-)a/installer/data/mysql/atomicupdate/bug_16631.pl (-4 / +7 lines)
Lines 16-27 return { Link Here
16
            KEY `branchcode` (`branchcode`),
16
            KEY `branchcode` (`branchcode`),
17
            CONSTRAINT `reports_branches_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE,
17
            CONSTRAINT `reports_branches_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE,
18
            CONSTRAINT `reports_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE
18
            CONSTRAINT `reports_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE
19
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
19
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci}
20
            INSERT IGNORE INTO systempreferences
21
            (variable,value,options,explanation,type) VALUES ('EnableFilteringReports', '0', NULL, 'Enable ability for staff to filter report access based on home library.', 'YesNo');}
22
        );
20
        );
23
21
24
        say $out "Added new table 'reports_branches'";
22
        say $out "Added new table 'reports_branches'";
23
24
        $dbh->do(
25
            q{INSERT IGNORE INTO systempreferences
26
            (variable,value,options,explanation,type) VALUES ('EnableFilteringReports', '0', NULL, 'Enable ability for staff to filter report access based on home library.', 'YesNo')}
27
        );
28
25
        say $out "Added new system preference 'EnableFilteringReports'";
29
        say $out "Added new system preference 'EnableFilteringReports'";
26
    },
30
    },
27
};
31
};
28
- 

Return to bug 16631