----------------------------------------------------------------
--
-- Table loading scripts for class contig
--

----------------------------------------------------------------
--
-- Main table - contig
--
LOAD DATA
INFILE '../../contig.tab'
APPEND INTO TABLE contig
REENABLE DISABLED_CONSTRAINTS
FIELDS TERMINATED BY X'09'
(
	id                               	CHAR(32),
	date                             	CHAR(255)	NULLIF date="<NULL_VALUE>",
	file                             	CHAR(255)	NULLIF file="<NULL_VALUE>",
	form                             	CHAR(255)	NULLIF form="<NULL_VALUE>",
	genbank_file                     	CHAR(255)	NULLIF genbank_file="<NULL_VALUE>",
	length                           	CHAR(255)	NULLIF length="<NULL_VALUE>",
	organism                         	CHAR(255)	NULLIF organism="<NULL_VALUE>",
	reference                        	CHAR(255)	NULLIF reference="<NULL_VALUE>",
	seq_dir                          	CHAR(255)	NULLIF seq_dir="<NULL_VALUE>",
	taxid                            	CHAR(255)	NULLIF taxid="<NULL_VALUE>",
	taxo_group                       	CHAR(255)	NULLIF taxo_group="<NULL_VALUE>",
	type                             	CHAR(255)	NULLIF type="<NULL_VALUE>"
)