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 |
- |
|
|