Lines 792-807
CREATE TABLE `import_biblios` (
Link Here
|
792 |
`matched_biblionumber` int(11) default NULL, |
792 |
`matched_biblionumber` int(11) default NULL, |
793 |
`control_number` varchar(25) default NULL, |
793 |
`control_number` varchar(25) default NULL, |
794 |
`original_source` varchar(25) default NULL, |
794 |
`original_source` varchar(25) default NULL, |
795 |
`title` varchar(128) default NULL, |
795 |
`title` LONGTEXT default NULL, |
796 |
`author` varchar(80) default NULL, |
796 |
`author` LONGTEXT default NULL, |
797 |
`isbn` varchar(30) default NULL, |
797 |
`isbn` LONGTEXT default NULL, |
798 |
`issn` varchar(9) default NULL, |
798 |
`issn` LONGTEXT default NULL, |
799 |
`has_items` tinyint(1) NOT NULL default 0, |
799 |
`has_items` tinyint(1) NOT NULL default 0, |
800 |
CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`) |
800 |
CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`) |
801 |
REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
801 |
REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
802 |
KEY `matched_biblionumber` (`matched_biblionumber`), |
802 |
KEY `matched_biblionumber` (`matched_biblionumber`), |
803 |
KEY `title` (`title`), |
803 |
KEY `title` (`title`(191)), |
804 |
KEY `isbn` (`isbn`) |
804 |
KEY `isbn` (`isbn`(191)) |
805 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
805 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
806 |
|
806 |
|
807 |
-- |
807 |
-- |
808 |
- |
|
|