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

(-)a/installer/data/mysql/atomicupdate/bug_13668.sql (+2 lines)
Line 0 Link Here
1
UPDATE saved_sql LEFT JOIN borrowers on saved_sql.borrowernumber=borrowers.borrowernumber SET saved_sql.borrowernumber=NULL WHERE borrowers.borrowernumber IS NULL;
2
ALTER TABLE saved_sql ADD FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 1910-1916 CREATE TABLE saved_sql ( -- saved sql reports Link Here
1910
    report_subgroup varchar(80) default NULL,
1910
    report_subgroup varchar(80) default NULL,
1911
   PRIMARY KEY  (`id`),
1911
   PRIMARY KEY  (`id`),
1912
   KEY sql_area_group_idx (report_group, report_subgroup),
1912
   KEY sql_area_group_idx (report_group, report_subgroup),
1913
   KEY boridx (`borrowernumber`)
1913
   KEY boridx (`borrowernumber`),
1914
   CONSTRAINT `saved_sql_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
1914
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1915
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1915
1916
1916
1917
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt (-2 / +5 lines)
Lines 333-339 canned reports and writing custom SQL reports.</p> Link Here
333
                        <td>[% savedreport.groupname %]</td>
333
                        <td>[% savedreport.groupname %]</td>
334
                        <td>[% savedreport.subgroupname %]</td>
334
                        <td>[% savedreport.subgroupname %]</td>
335
                        <td>[% savedreport.notes %]</td>
335
                        <td>[% savedreport.notes %]</td>
336
                        <td>[% savedreport.borrowersurname %][% IF ( savedreport.borrowerfirstname ) %], [% savedreport.borrowerfirstname %][% END %] ([% savedreport.borrowernumber %])</td>
336
                        <td>
337
                            [% IF savedreport.borrowernumber %]
338
                                [% savedreport.borrowersurname %][% IF ( savedreport.borrowerfirstname ) %], [% savedreport.borrowerfirstname %][% END %] ([% savedreport.borrowernumber %])
339
                            [% END %]
340
                        </td>
337
                        <td><span title="[% savedreport.date_created %]">[% savedreport.date_created | $KohaDates %]</span></td>
341
                        <td><span title="[% savedreport.date_created %]">[% savedreport.date_created | $KohaDates %]</span></td>
338
                        [% IF (savedreport.public) %]
342
                        [% IF (savedreport.public) %]
339
                        <td>Yes</td>
343
                        <td>Yes</td>
340
- 

Return to bug 13668