Lines 848-868
CREATE TABLE hold_fill_targets (
Link Here
|
848 |
-- |
848 |
-- |
849 |
|
849 |
|
850 |
DROP TABLE IF EXISTS `import_batches`; |
850 |
DROP TABLE IF EXISTS `import_batches`; |
851 |
CREATE TABLE `import_batches` ( |
851 |
CREATE TABLE `import_batches` ( -- information about batches of marc records that have been imported |
852 |
`import_batch_id` int(11) NOT NULL auto_increment, |
852 |
`import_batch_id` int(11) NOT NULL auto_increment, -- unique identifier and primary key |
853 |
`matcher_id` int(11) default NULL, |
853 |
`matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id) |
854 |
`template_id` int(11) default NULL, |
854 |
`template_id` int(11) default NULL, |
855 |
`branchcode` varchar(10) default NULL, |
855 |
`branchcode` varchar(10) default NULL, |
856 |
`num_biblios` int(11) NOT NULL default 0, |
856 |
`num_biblios` int(11) NOT NULL default 0, -- number of bib records in the file |
857 |
`num_items` int(11) NOT NULL default 0, |
857 |
`num_items` int(11) NOT NULL default 0, -- number of items in the file |
858 |
`upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, |
858 |
`upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- date and time the file was uploaded |
859 |
`overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new', |
859 |
`overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new', -- how to handle duplicate records |
860 |
`nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new', |
860 |
`nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new', -- how to handle records where no match is found |
861 |
`item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore') NOT NULL default 'always_add', |
861 |
`item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore') NOT NULL default 'always_add', -- what to do with item records |
862 |
`import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', |
862 |
`import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', -- the status of the imported file |
863 |
`batch_type` enum('batch', 'z3950', 'webservice') NOT NULL default 'batch', |
863 |
`batch_type` enum('batch', 'z3950', 'webservice') NOT NULL default 'batch', -- where this batch has come from |
864 |
`file_name` varchar(100), |
864 |
`file_name` varchar(100), -- the name of the file uploaded |
865 |
`comments` mediumtext, |
865 |
`comments` mediumtext, -- any comments added when the file was uploaded |
866 |
PRIMARY KEY (`import_batch_id`), |
866 |
PRIMARY KEY (`import_batch_id`), |
867 |
KEY `branchcode` (`branchcode`) |
867 |
KEY `branchcode` (`branchcode`) |
868 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
868 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
869 |
- |
|
|