[Koha-bugs] [Bug 10631] New: Table alert should have a FK on borrowernumber and entries be deleted with the referenced borrower

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10631

            Bug ID: 10631
           Summary: Table alert should have a FK on borrowernumber and
                    entries be deleted with the referenced borrower
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: gmcharlt at gmail.com
          Reporter: katrin.fischer at bsz-bw.de
        QA Contact: testopia at bugs.koha-community.org

The table alert is currently used to store information about email subscriptons
for new serial issues. 

The current table defnition is:

2682 DROP TABLE IF EXISTS `alert`;
2683 CREATE TABLE `alert` (
2684   `alertid` int(11) NOT NULL auto_increment,
2685   `borrowernumber` int(11) NOT NULL default 0,
2686   `type` varchar(10) NOT NULL default '',
2687   `externalid` varchar(20) NOT NULL default '',
2688   PRIMARY KEY  (`alertid`),
2689   KEY `borrowernumber` (`borrowernumber`),
2690   KEY `type` (`type`,`externalid`)
2691 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2692 

As I see it borrowernumber should be a FK and we are missing some cascades to
make sure the table is cleaned up when a borrower is deleted.

-- 
You are receiving this mail because:
You are watching all bug changes.