https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21062

            Bug ID: 21062
           Summary: Clean up borrower_password_recovery when patron is
                    deleted
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Database
          Assignee: koha-bugs@lists.koha-community.org
          Reporter: katrin.fisc...@bsz-bw.de
        QA Contact: testo...@bugs.koha-community.org

When a patron is deleted, any entries in borrower_password_recovery should be
deleted as well by cascade.

CREATE TABLE `borrower_password_recovery` (
  `borrowernumber` int(11) NOT NULL,
  `uuid` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`borrowernumber`),
  KEY `borrowernumber` (`borrowernumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to