SHARE
TWEET

Untitled

a guest Jul 22nd, 2014 200 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. import_records | CREATE TABLE `import_records` (
  2.   `import_record_id` int(11) NOT NULL,
  3.   `import_batch_id` int(11) NOT NULL,
  4.   `branchcode` varchar(10) DEFAULT NULL,
  5.   `record_sequence` int(11) NOT NULL DEFAULT '0',
  6.   `upload_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  7.   `import_date` date DEFAULT NULL,
  8.   `marc` longblob NOT NULL,
  9.   `marcxml` longtext NOT NULL,
  10.   `marcxml_old` longtext NOT NULL,
  11.   `record_type` enum('biblio','auth','holdings') NOT NULL DEFAULT 'biblio',
  12.   `overlay_status` enum('no_match','auto_match','manual_match','match_applied') NOT NULL DEFAULT 'no_match',
  13.   `status` enum('error','staged','imported','reverted','items_reverted','ignored') NOT NULL DEFAULT 'staged',
  14.   `import_error` mediumtext,
  15.   `encoding` varchar(40) NOT NULL DEFAULT '',
  16.   `z3950random` varchar(40) DEFAULT NULL,
  17.   KEY `import_records_ifbk_1` (`import_batch_id`),
  18.   CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`) REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE
  19. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top