http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7811 Priority: P5 - low Change sponsored?: --- Bug ID: 7811 Assignee: christophe.croullebois@biblibre.com Summary: borrowers.borrowernumber should be a foreign key for 8 tables QA Contact: koha.sekjal@gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: christophe.croullebois@biblibre.com Hardware: All Status: ASSIGNED Version: master Component: Database Product: Koha I just add constraints : alert.borrowernumber (with ON DELETE CASCADE) statistics.borrowernumber (with ON DELETE SET NULL) messages.borrowernumber (with ON DELETE SET NULL) reserveconstraints.borrowernumber (with ON DELETE CASCADE) reviews.borrowernumber (with ON DELETE CASCADE) saved_sql.borrowernumber (with ON DELETE SET NULL) search_history.borrowernumber (with ON DELETE CASCADE) -the borrowernumber field is called userid atm, see below- suggestions.suggestedby, suggestion.managedby, acceptedby, rejectedby (with ON DELETE SET NULL) -- You are receiving this mail because: You are watching all bug changes.