|
Lines 3980-3985
CREATE TABLE biblio_metadata (
Link Here
|
| 3980 |
`format` VARCHAR(16) NOT NULL, |
3980 |
`format` VARCHAR(16) NOT NULL, |
| 3981 |
`marcflavour` VARCHAR(16) NOT NULL, |
3981 |
`marcflavour` VARCHAR(16) NOT NULL, |
| 3982 |
`metadata` LONGTEXT NOT NULL, |
3982 |
`metadata` LONGTEXT NOT NULL, |
|
|
3983 |
timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
| 3983 |
PRIMARY KEY(id), |
3984 |
PRIMARY KEY(id), |
| 3984 |
UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), |
3985 |
UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), |
| 3985 |
CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
3986 |
CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
|
Lines 3996-4001
CREATE TABLE deletedbiblio_metadata (
Link Here
|
| 3996 |
`format` VARCHAR(16) NOT NULL, |
3997 |
`format` VARCHAR(16) NOT NULL, |
| 3997 |
`marcflavour` VARCHAR(16) NOT NULL, |
3998 |
`marcflavour` VARCHAR(16) NOT NULL, |
| 3998 |
`metadata` LONGTEXT NOT NULL, |
3999 |
`metadata` LONGTEXT NOT NULL, |
|
|
4000 |
timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
| 3999 |
PRIMARY KEY(id), |
4001 |
PRIMARY KEY(id), |
| 4000 |
UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), |
4002 |
UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), |
| 4001 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
4003 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |