View | Details | Raw Unified | Return to bug 6716
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-14 / +13 lines)
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
- 

Return to bug 6716