Lines 1455-1460
CREATE TABLE saved_sql ( -- saved sql reports
Link Here
|
1455 |
report_area varchar(6) default NULL, |
1455 |
report_area varchar(6) default NULL, |
1456 |
report_group varchar(80) default NULL, |
1456 |
report_group varchar(80) default NULL, |
1457 |
report_subgroup varchar(80) default NULL, |
1457 |
report_subgroup varchar(80) default NULL, |
|
|
1458 |
`combine_params` tinyint(1) NOT NULL DEFAULT 0, -- controls if matching <<name|type>> vars in reports share the same value |
1458 |
PRIMARY KEY (`id`), |
1459 |
PRIMARY KEY (`id`), |
1459 |
KEY sql_area_group_idx (report_group, report_subgroup), |
1460 |
KEY sql_area_group_idx (report_group, report_subgroup), |
1460 |
KEY boridx (`borrowernumber`) |
1461 |
KEY boridx (`borrowernumber`) |
1461 |
- |
|
|