[Koha-bugs] [Bug 13535] New: Table alert is missing FK and not deleted with the patron

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

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

            Bug ID: 13535
           Summary: Table alert is missing FK and not deleted with the
                    patron
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Database
          Assignee: gmcharlt at gmail.com
          Reporter: katrin.fischer at bsz-bw.de
        QA Contact: testopia at bugs.koha-community.org

The table alert contains subscriptions for email notifications for new serial
issues. There is no FK on the borrowernumber and no other permission I can see
to clean the table once the patron has been deleted.


2806 DROP TABLE IF EXISTS `alert`;
2807 CREATE TABLE `alert` (
2808   `alertid` int(11) NOT NULL auto_increment,
2809   `borrowernumber` int(11) NOT NULL default 0,
2810   `type` varchar(10) NOT NULL default '',
2811   `externalid` varchar(20) NOT NULL default '',
2812   PRIMARY KEY  (`alertid`),
2813   KEY `borrowernumber` (`borrowernumber`),
2814   KEY `type` (`type`,`externalid`)
2815 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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