Lines 855-861
CREATE TABLE `import_batches` ( -- information about batches of marc records tha
Link Here
|
855 |
`matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id) |
855 |
`matcher_id` int(11) default NULL, -- the id of the match rule used (matchpoints.matcher_id) |
856 |
`template_id` int(11) default NULL, |
856 |
`template_id` int(11) default NULL, |
857 |
`branchcode` varchar(10) default NULL, |
857 |
`branchcode` varchar(10) default NULL, |
858 |
`num_biblios` int(11) NOT NULL default 0, -- number of bib records in the file |
858 |
`num_records` int(11) NOT NULL default 0, -- number of records in the file |
859 |
`num_items` int(11) NOT NULL default 0, -- number of items in the file |
859 |
`num_items` int(11) NOT NULL default 0, -- number of items in the file |
860 |
`upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- date and time the file was uploaded |
860 |
`upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- date and time the file was uploaded |
861 |
`overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new', -- how to handle duplicate records |
861 |
`overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new', -- how to handle duplicate records |
Lines 863-868
CREATE TABLE `import_batches` ( -- information about batches of marc records tha
Link Here
|
863 |
`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 |
863 |
`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 |
864 |
`import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', -- the status of the imported file |
864 |
`import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', -- the status of the imported file |
865 |
`batch_type` enum('batch', 'z3950', 'webservice') NOT NULL default 'batch', -- where this batch has come from |
865 |
`batch_type` enum('batch', 'z3950', 'webservice') NOT NULL default 'batch', -- where this batch has come from |
|
|
866 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch |
866 |
`file_name` varchar(100), -- the name of the file uploaded |
867 |
`file_name` varchar(100), -- the name of the file uploaded |
867 |
`comments` mediumtext, -- any comments added when the file was uploaded |
868 |
`comments` mediumtext, -- any comments added when the file was uploaded |
868 |
PRIMARY KEY (`import_batch_id`), |
869 |
PRIMARY KEY (`import_batch_id`), |
Lines 911-916
CREATE TABLE `import_record_matches` ( -- matches found when importing a batch o
Link Here
|
911 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
912 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
912 |
|
913 |
|
913 |
-- |
914 |
-- |
|
|
915 |
-- Table structure for table `import_auths` |
916 |
-- |
917 |
|
918 |
DROP TABLE IF EXISTS `import_auths`; |
919 |
CREATE TABLE `import_auths` ( |
920 |
`import_record_id` int(11) NOT NULL, |
921 |
`matched_authid` int(11) default NULL, |
922 |
`control_number` varchar(25) default NULL, |
923 |
`authorized_heading` varchar(128) default NULL, |
924 |
`original_source` varchar(25) default NULL, |
925 |
CONSTRAINT `import_auths_ibfk_1` FOREIGN KEY (`import_record_id`) |
926 |
REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
927 |
KEY `matched_authid` (`matched_authid`), |
928 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
929 |
|
930 |
-- |
914 |
-- Table structure for table `import_biblios` |
931 |
-- Table structure for table `import_biblios` |
915 |
-- |
932 |
-- |
916 |
|
933 |
|
917 |
- |
|
|