|
Lines 701-706
CREATE TABLE `export_format` (
Link Here
|
| 701 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export'; |
701 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export'; |
| 702 |
|
702 |
|
| 703 |
-- |
703 |
-- |
|
|
704 |
-- Table structure for table `import_batches_profile` |
| 705 |
-- |
| 706 |
|
| 707 |
DROP TABLE IF EXISTS `import_batches_profile`; |
| 708 |
CREATE TABLE `import_batches_profile` ( -- profile for batches of marc records to be imported |
| 709 |
`id` int(11) NOT NULL auto_increment, -- unique identifier and primary key |
| 710 |
`name` varchar(100) NOT NULL, -- name of this profile |
| 711 |
`matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id) |
| 712 |
`template_id` int(11) default NULL, -- the id of the marc modification template |
| 713 |
`overlay_action` varchar(50) default NULL, -- how to handle duplicate records |
| 714 |
`nomatch_action` varchar(50) default NULL, -- how to handle records where no match is found |
| 715 |
`item_action` varchar(50) default NULL, -- what to do with item records |
| 716 |
`parse_items` tinyint(1) default NULL, -- should items be parsed |
| 717 |
`record_type` varchar(50) default NULL, -- type of record in the batch |
| 718 |
`encoding` varchar(50) default NULL, -- file encoding |
| 719 |
`format` varchar(50) default NULL, -- marc format |
| 720 |
`comments` LONGTEXT, -- any comments added when the file was uploaded |
| 721 |
PRIMARY KEY (`id`), |
| 722 |
UNIQUE KEY `u_import_batches_profile__name` (`name`) |
| 723 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 724 |
|
| 725 |
-- |
| 704 |
-- Table structure for table `import_batches` |
726 |
-- Table structure for table `import_batches` |
| 705 |
-- |
727 |
-- |
| 706 |
|
728 |
|
|
Lines 721-728
CREATE TABLE `import_batches` ( -- information about batches of marc records tha
Link Here
|
| 721 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch |
743 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch |
| 722 |
`file_name` varchar(100), -- the name of the file uploaded |
744 |
`file_name` varchar(100), -- the name of the file uploaded |
| 723 |
`comments` LONGTEXT, -- any comments added when the file was uploaded |
745 |
`comments` LONGTEXT, -- any comments added when the file was uploaded |
|
|
746 |
`profile_id` int(11) default NULL, |
| 724 |
PRIMARY KEY (`import_batch_id`), |
747 |
PRIMARY KEY (`import_batch_id`), |
| 725 |
KEY `branchcode` (`branchcode`) |
748 |
KEY `branchcode` (`branchcode`), |
|
|
749 |
CONSTRAINT `import_batches_ibfk_1` FOREIGN KEY (`profile_id`) |
| 750 |
REFERENCES `import_batches_profile` (`id`) ON DELETE SET NULL ON UPDATE SET NULL |
| 726 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
751 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 727 |
|
752 |
|
| 728 |
-- |
753 |
-- |
| 729 |
- |
|
|