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