----------------------------------------------------------------
--
-- Table loading scripts for class mrna
--

----------------------------------------------------------------
--
-- Main table - mrna
--
LOAD DATA
INFILE '../../mrna.tab'
APPEND INTO TABLE mrna
REENABLE DISABLED_CONSTRAINTS
FIELDS TERMINATED BY X'09'
(
	id                               	CHAR(32),
	chrom_position                   	CHAR(255)	NULLIF chrom_position="<NULL_VALUE>",
	gene                             	CHAR(255)	NULLIF gene="<NULL_VALUE>",
	gene_id                          	CHAR(255)	NULLIF gene_id="<NULL_VALUE>",
	product                          	CHAR(255)	NULLIF product="<NULL_VALUE>",
	transcript_id                    	CHAR(255)	NULLIF transcript_id="<NULL_VALUE>"
)