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 |
- |
|
|