View | Details | Raw Unified | Return to bug 10363
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 3239-3246 CREATE TABLE categories_branches( -- association table between categories and br Link Here
3239
3239
3240
DROP TABLE IF EXISTS authorised_values_branches;
3240
DROP TABLE IF EXISTS authorised_values_branches;
3241
CREATE TABLE authorised_values_branches( -- association table between authorised_values and branches
3241
CREATE TABLE authorised_values_branches( -- association table between authorised_values and branches
3242
    av_id INTEGER,
3242
    av_id INT(11) NOT NULL,
3243
    branchcode VARCHAR(10),
3243
    branchcode VARCHAR(10) NOT NULL,
3244
    FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE,
3244
    FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE,
3245
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
3245
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
3246
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3246
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3247
- 

Return to bug 10363