
----------------------------------------------------------------
--
-- Table creation scripts for class contig
--

----------------------------------------------------------------
--
-- Schema
--
alter session set current_schema=embl;


----------------------------------------------------------------
--
-- Main table - contig
--
CREATE TABLE embl.contig
	(
		id                               	VARCHAR(32)	NOT NULL PRIMARY KEY,
		accession                        	VARCHAR(255),
		version                          	VARCHAR(255),
		form                             	VARCHAR(255),
		type                             	VARCHAR(255),
		file                             	VARCHAR(255),
		length                           	VARCHAR(255),
		description                      	VARCHAR(255)
	)
;
GRANT select ON embl.contig TO amaze;

----------------------------------------------------------------
--
-- Quit
--
quit;