[Koha-bugs] [Bug 7811] New: borrowers.borrowernumber should be a foreign key for 8 tables

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

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

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 7811
          Assignee: christophe.croullebois at biblibre.com
           Summary: borrowers.borrowernumber should be a foreign key for 8
                    tables
        QA Contact: koha.sekjal at gmail.com
          Severity: enhancement
    Classification: Unclassified
                OS: All
          Reporter: christophe.croullebois at 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.