http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7811
Priority: P5 - low
Change sponsored?: ---
Bug ID: 7811
Assignee: [email protected]
Summary: borrowers.borrowernumber should be a foreign key for 8
tables
QA Contact: [email protected]
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
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/
