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