q1w4qKnS

14006 --
24007 -- Table structure for table `biblio_metadata`
34008 --
44009 
54010 DROP TABLE IF EXISTS `biblio_metadata`;
64011 CREATE TABLE biblio_metadata (
74012     `id` INT(11) NOT NULL AUTO_INCREMENT,
84013     `biblionumber` INT(11) NOT NULL,
94014     `format` VARCHAR(16) NOT NULL,
104015     `marcflavour` VARCHAR(16) NOT NULL,
114016     `metadata` LONGTEXT NOT NULL,
124017     `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
134018     PRIMARY KEY(id),
144019     UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
154020     CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE,
164021     KEY `timestamp` (`timestamp`)
174022 <<<<<<< 179013be16c82181003b49b41a4d5549a60ab7fc
184023 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
194024 =======
204025 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
214026 >>>>>>> Bug 19724: Add timestamp to biblio_metadata and deletedbiblio_metadata
224027 
234028 --
244029 -- Table structure for table `deletedbiblio_metadata`
254030 --
264031 
274032 DROP TABLE IF EXISTS `deletedbiblio_metadata`;
284033 CREATE TABLE deletedbiblio_metadata (
294034     `id` INT(11) NOT NULL AUTO_INCREMENT,
304035     `biblionumber` INT(11) NOT NULL,
314036     `format` VARCHAR(16) NOT NULL,
324037     `marcflavour` VARCHAR(16) NOT NULL,
334038     `metadata` LONGTEXT NOT NULL,
344039     `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
354040     PRIMARY KEY(id),
364041     UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),
374042     CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE,
384043     KEY `timestamp` (`timestamp`)
394044 <<<<<<< 179013be16c82181003b49b41a4d5549a60ab7fc
404045 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
414046 =======