|
Lines 1159-1164
CREATE TABLE `biblio_metadata` (
Link Here
|
| 1159 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1159 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1160 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1160 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1161 |
|
1161 |
|
|
|
1162 |
-- |
| 1163 |
-- Table structure for table `biblio_metadata_errors` |
| 1164 |
-- |
| 1165 |
|
| 1166 |
DROP TABLE IF EXISTS `biblio_metadata_errors`; |
| 1167 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 1168 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 1169 |
CREATE TABLE `biblio_metadata_errors` ( |
| 1170 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 1171 |
`metadata_id` int(11) NOT NULL COMMENT 'FK to biblio_metadata.id', |
| 1172 |
`error_type` varchar(64) NOT NULL COMMENT 'Error type identifier, e.g. nonxml_stripped', |
| 1173 |
`message` mediumtext DEFAULT NULL COMMENT 'Error message details', |
| 1174 |
`created_on` timestamp NOT NULL DEFAULT current_timestamp(), |
| 1175 |
PRIMARY KEY (`id`), |
| 1176 |
KEY `biblio_metadata_errors_fk_1` (`metadata_id`), |
| 1177 |
CONSTRAINT `biblio_metadata_errors_fk_1` FOREIGN KEY (`metadata_id`) REFERENCES `biblio_metadata` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 1178 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1179 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1180 |
|
| 1162 |
-- |
1181 |
-- |
| 1163 |
-- Table structure for table `biblioitems` |
1182 |
-- Table structure for table `biblioitems` |
| 1164 |
-- |
1183 |
-- |
| 1165 |
- |
|
|