----------------------------------------------------------------
--
-- Table loading scripts for class source
--

----------------------------------------------------------------
--
-- Main table - source
--
LOAD DATA
INFILE '../../source.tab'
APPEND INTO TABLE source
REENABLE DISABLED_CONSTRAINTS
FIELDS TERMINATED BY X'09'
(
	id                               	CHAR(32),
	chrom_position                   	CHAR(255)	NULLIF chrom_position="<NULL_VALUE>",
	chromosome                       	CHAR(255)	NULLIF chromosome="<NULL_VALUE>",
	contig                           	CHAR(255)	NULLIF contig="<NULL_VALUE>",
	isolate                          	CHAR(255)	NULLIF isolate="<NULL_VALUE>",
	organism                         	CHAR(255)	NULLIF organism="<NULL_VALUE>",
	plasmid                          	CHAR(255)	NULLIF plasmid="<NULL_VALUE>",
	serotype                         	CHAR(255)	NULLIF serotype="<NULL_VALUE>",
	strain                           	CHAR(255)	NULLIF strain="<NULL_VALUE>",
	sub_strain                       	CHAR(255)	NULLIF sub_strain="<NULL_VALUE>",
	taxid                            	CHAR(255)	NULLIF taxid="<NULL_VALUE>",
	type                             	CHAR(255)	NULLIF type="<NULL_VALUE>"
)