[Koha-bugs] [Bug 25731] The table authorised_values_branches should have foreign key constraints

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

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

--- Comment #1 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Kyle, they both have the correct foreign key:

CREATE TABLE authorised_values_branches( -- association table between
authorised_values and branches
    av_id INT(11) NOT NULL,
    branchcode VARCHAR(10) NOT NULL,
    FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE,
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.