Lines 993-999
CREATE TABLE `import_batches` ( -- information about batches of marc records tha
Link Here
|
993 |
`num_records` int(11) NOT NULL default 0, -- number of records in the file |
993 |
`num_records` int(11) NOT NULL default 0, -- number of records in the file |
994 |
`num_items` int(11) NOT NULL default 0, -- number of items in the file |
994 |
`num_items` int(11) NOT NULL default 0, -- number of items in the file |
995 |
`upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- date and time the file was uploaded |
995 |
`upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- date and time the file was uploaded |
996 |
`overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new', -- how to handle duplicate records |
996 |
`overlay_action` enum('replace', 'create_new', 'use_template', 'ignore','appendmarctag') NOT NULL default 'create_new', -- how to handle duplicate records |
997 |
`nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new', -- how to handle records where no match is found |
997 |
`nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new', -- how to handle records where no match is found |
998 |
`item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore', 'replace') NOT NULL default 'always_add', -- what to do with item records |
998 |
`item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore', 'replace') NOT NULL default 'always_add', -- what to do with item records |
999 |
`import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', -- the status of the imported file |
999 |
`import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', -- the status of the imported file |
Lines 1001-1006
CREATE TABLE `import_batches` ( -- information about batches of marc records tha
Link Here
|
1001 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch |
1001 |
`record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch |
1002 |
`file_name` varchar(100), -- the name of the file uploaded |
1002 |
`file_name` varchar(100), -- the name of the file uploaded |
1003 |
`comments` mediumtext, -- any comments added when the file was uploaded |
1003 |
`comments` mediumtext, -- any comments added when the file was uploaded |
|
|
1004 |
`marctag` mediumtext, -- marc tag for ex: 100a, 700a |
1004 |
PRIMARY KEY (`import_batch_id`), |
1005 |
PRIMARY KEY (`import_batch_id`), |
1005 |
KEY `branchcode` (`branchcode`) |
1006 |
KEY `branchcode` (`branchcode`) |
1006 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1007 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |