----------------------------------------------------------------
--
-- Table loading scripts for class cds
--

----------------------------------------------------------------
--
-- Main table - cds
--
LOAD DATA
INFILE '../../cds.tab'
APPEND INTO TABLE cds
REENABLE DISABLED_CONSTRAINTS
FIELDS TERMINATED BY X'09'
(
	id                               	CHAR(32),
	gi                               	CHAR(255)	NULLIF gi="<NULL_VALUE>",
	geneid                           	CHAR(255)	NULLIF geneid="<NULL_VALUE>",
	chrom_position                   	CHAR(255)	NULLIF chrom_position="<NULL_VALUE>",
	chromosome                       	CHAR(255)	NULLIF chromosome="<NULL_VALUE>",
	codon_start                      	CHAR(255)	NULLIF codon_start="<NULL_VALUE>",
	contig                           	CHAR(255)	NULLIF contig="<NULL_VALUE>",
	description                      	CHAR(255)	NULLIF description="<NULL_VALUE>",
	end_pos                          	CHAR(255)	NULLIF end_pos="<NULL_VALUE>",
	gene                             	CHAR(255)	NULLIF gene="<NULL_VALUE>",
	gene_id                          	CHAR(255)	NULLIF gene_id="<NULL_VALUE>",
	name                             	CHAR(255)	NULLIF name="<NULL_VALUE>",
	organism                         	CHAR(255)	NULLIF organism="<NULL_VALUE>",
	product                          	CHAR(255)	NULLIF product="<NULL_VALUE>",
	protein_id                       	CHAR(255)	NULLIF protein_id="<NULL_VALUE>",
	start_pos                        	CHAR(255)	NULLIF start_pos="<NULL_VALUE>",
	strand                           	CHAR(255)	NULLIF strand="<NULL_VALUE>",
	taxid                            	CHAR(255)	NULLIF taxid="<NULL_VALUE>",
	type                             	CHAR(255)	NULLIF type="<NULL_VALUE>"
)