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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 3931-3936 CREATE TABLE biblio_metadata ( Link Here
3931
    `marcflavour` VARCHAR(16) NOT NULL,
3931
    `marcflavour` VARCHAR(16) NOT NULL,
3932
    `metadata` LONGTEXT NOT NULL,
3932
    `metadata` LONGTEXT NOT NULL,
3933
    PRIMARY KEY(id),
3933
    PRIMARY KEY(id),
3934
    UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
3934
    CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3935
    CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3935
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3936
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3936
3937
Lines 3945-3950 CREATE TABLE deletedbiblio_metadata ( Link Here
3945
    `marcflavour` VARCHAR(16) NOT NULL,
3946
    `marcflavour` VARCHAR(16) NOT NULL,
3946
    `metadata` LONGTEXT NOT NULL,
3947
    `metadata` LONGTEXT NOT NULL,
3947
    PRIMARY KEY(id),
3948
    PRIMARY KEY(id),
3949
    UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
3948
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3950
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3949
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3951
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3950
3952
3951
- 

Return to bug 17196