Max Depth:

Bug 5334 depends on 47 bugs:

view as bug list

•    5334: Omnibus: Add explicit foreign key constraints [NEW; assigned to gmcharlt]
  •    12555: The DelItem subroutine should be called on canceling a receipt [In Discussion; assigned to jonathan.druart]
    •    11744: cancel receipt doesn't work for one item [CLOSED FIXED; assigned to jonathan.druart]
    •    12583: DelItem takes $dbh in parameter [CLOSED FIXED; assigned to jonathan.druart]
  •    13668: Creator of an SQL report shoudl be NULL when the staff patron is deleted [In Discussion; assigned to jonathan.druart]
  •    14849: Owner should be FK in uploaded_files [NEW; assigned to koha-bugs]
  •    16090: FK branchcode in issues [NEW; assigned to gmcharlt]
  •    22421: accountlines.issue_id is missing a foreign key constraint [Pushed to main; assigned to martin.renvoize]
  •    22658: aqbasket.authorisedby is missing a foreign key constraint [NEW; assigned to martin.renvoize]
    •    22642: DB upgrade 18.06.00.005 can fail [CLOSED FIXED; assigned to martin.renvoize]
      •    12395: Save order line's creator [CLOSED FIXED; assigned to julian.maurice]
  •    26044: frameworkcode fields must be a FK [NEW; assigned to koha-bugs]
  •    26493: Add missing FK constraints to aqbudgets [NEW; assigned to koha-bugs]
    •    18050: Missing constraint on aqbudgets.budget_period_id in aqbudgets [CLOSED FIXED; assigned to katrin.fischer]
  •    29390: Authorised values: Add a few missing foreign keys [Failed QA; assigned to m.de.rooy]
    •    29336: Some authorised_value FKs are too short [CLOSED FIXED; assigned to m.de.rooy]
    •    35190: Additional_fields table should allow null values for authorised_value_category [RESOLVED FIXED; assigned to emily.lamancusa]
  •    38011: Add a foreign key link between vendors and subscriptions [Pushed to main; assigned to matt.blenkinsop]
  •    7811: borrowers.borrowernumber should be a foreign key for 8 tables [RESOLVED MOVED; assigned to martin.renvoize]
    •    22008: accountlines.manager_id is missing a foreign key constraint [CLOSED FIXED; assigned to martin.renvoize]
      •    21065: Data in account_offsets and accountlines is deleted with the patron leaving gaps in financial reports [CLOSED FIXED; assigned to jonathan.druart]
    •    22368: Table suggestions lacks foreign key constraints [CLOSED FIXED; assigned to martin.renvoize]
  •    12601: aqorders.budget_id should be a foreign key [CLOSED FIXED; assigned to jonathan.druart]
  •    13007: suggestions.budgetid should be a foreign key [CLOSED FIXED; assigned to jonathan.druart]
    •    12627: SQLHelper replacement - C4::Suggestions [CLOSED FIXED; assigned to jonathan.druart]
      •    12445: C4::Suggestions.pm needs more unit tests [CLOSED FIXED; assigned to yohann.dufour]
  •    13515: Table messages is missing FK constraints and is never cleaned up [CLOSED FIXED; assigned to jonathan.druart]
  •    13518: Table borrower_modifications is missing FK and not deleted with the patron [CLOSED FIXED; assigned to jonathan.druart]
  •    13533: Table suggestions is missing FK constraints / borrowernumbers are kept on deletion of patron [RESOLVED DUPLICATE; assigned to gmcharlt]
  •    13534: Deleting staff patron will delete tags approved by this patron [CLOSED FIXED; assigned to jonathan.druart]
  •    13535: Table alert is missing FK and not deleted with the patron [CLOSED FIXED; assigned to katrin.fischer]
  •    16170: Pseudo foreign key in Items [CLOSED FIXED; assigned to m.de.rooy]
  •    17160: Foreign key constraint for message_transports is too loose [RESOLVED DUPLICATE; assigned to koha-bugs]
  •    18050: Missing constraint on aqbudgets.budget_period_id in aqbudgets [CLOSED FIXED; assigned to katrin.fischer] (*)
  •    18086: overduerules table is lacking foreign key constraints [RESOLVED MOVED; assigned to kyle]
  •    18441: Add primary, foreign keys to statistics table [CLOSED WONTFIX; assigned to koha-bugs]
  •    21901: Foreign keys are missing on the serials and subscriptions tables [CLOSED FIXED; assigned to jonathan.druart]
    •    24213: Koha::Object->get_from_storage should return undef if the object has been deleted [CLOSED FIXED; assigned to jonathan.druart]
  •    21983: Better handling of deleted biblios on ILL requests [RESOLVED FIXED; assigned to tomascohen]
    •    22440: Improve ILL page performance by moving to server side filtering [RESOLVED FIXED; assigned to tomascohen]
      •    26635: Expand coded values in REST API call [RESOLVED FIXED; assigned to tomascohen]
        •    26636: Add objects.find Mojolicious helper [CLOSED FIXED; assigned to agustinmoyano]
      •    29032: ILL route unusable (slow) [CLOSED FIXED; assigned to tomascohen]
  •    22368: Table suggestions lacks foreign key constraints [CLOSED FIXED; assigned to martin.renvoize] (*)
  •    22480: itemtype/itype is used to join allot of tables, but often isn't defined as a key [RESOLVED WONTFIX; assigned to martin.renvoize]
  •    22887: authorised_values is missing a unique constraint on category + authorised_value [CLOSED FIXED; assigned to jonathan.druart]
  •    24289: Deleting branch will not delete entry in special or repeatable holidays [CLOSED FIXED; assigned to jonathan.druart]
  •    25731: The table authorised_values_branches should have foreign key constraints [CLOSED INVALID; assigned to koha-bugs]
  •    28972: Add missing foreign key constraints to holds queue table [CLOSED FIXED; assigned to kyle]
  •    35610: Missing FK on old_reserves.branchcode [RESOLVED FIXED; assigned to jonathan.druart]

Bug 5334 does not block any bugs.

Max Depth:

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    [x]
  • | Forgot Password
    Login: [x]