Lines 3349-3355
CREATE TABLE `import_batches` (
Link Here
|
3349 |
`num_items` int(11) NOT NULL DEFAULT 0 COMMENT 'number of items in the file', |
3349 |
`num_items` int(11) NOT NULL DEFAULT 0 COMMENT 'number of items in the file', |
3350 |
`upload_timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time the file was uploaded', |
3350 |
`upload_timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time the file was uploaded', |
3351 |
`overlay_action` enum('replace','create_new','use_template','ignore') NOT NULL DEFAULT 'create_new' COMMENT 'how to handle duplicate records', |
3351 |
`overlay_action` enum('replace','create_new','use_template','ignore') NOT NULL DEFAULT 'create_new' COMMENT 'how to handle duplicate records', |
|
|
3352 |
`overlay_frameworkcode` varchar(4) NOT NULL DEFAULT '', |
3352 |
`nomatch_action` enum('create_new','ignore') NOT NULL DEFAULT 'create_new' COMMENT 'how to handle records where no match is found', |
3353 |
`nomatch_action` enum('create_new','ignore') NOT NULL DEFAULT 'create_new' COMMENT 'how to handle records where no match is found', |
|
|
3354 |
`import_frameworkcode` varchar(4) NOT NULL DEFAULT '', |
3353 |
`item_action` enum('always_add','add_only_for_matches','add_only_for_new','ignore','replace') NOT NULL DEFAULT 'always_add' COMMENT 'what to do with item records', |
3355 |
`item_action` enum('always_add','add_only_for_matches','add_only_for_new','ignore','replace') NOT NULL DEFAULT 'always_add' COMMENT 'what to do with item records', |
3354 |
`import_status` enum('staging','staged','importing','imported','reverting','reverted','cleaned') NOT NULL DEFAULT 'staging' COMMENT 'the status of the imported file', |
3356 |
`import_status` enum('staging','staged','importing','imported','reverting','reverted','cleaned') NOT NULL DEFAULT 'staging' COMMENT 'the status of the imported file', |
3355 |
`batch_type` enum('batch','z3950','webservice') NOT NULL DEFAULT 'batch' COMMENT 'where this batch has come from', |
3357 |
`batch_type` enum('batch','z3950','webservice') NOT NULL DEFAULT 'batch' COMMENT 'where this batch has come from', |