-- 22nov05 dem Added table contigset.
-- 25nov05 dem Added tables contigsetauthor, contigsetremark.

create table contigset (
        id integer auto_increment primary key,
	-- Object name
	name varchar(50),
        -- Date Text
        date varchar(50),
        -- Species ?Species.  Assume unique, no cross-species assemblies.
        speciesid integer,
        -- Software Text
        software varchar(50),
        -- Parameters Text
        parameters varchar(100),
        -- Contigs Int
        contigs integer,
        -- Singletons Int
        singletons integer,
	-- Clones Int. Number of clones in assembly (for BAC assemblies).
	clones integer,
	-- Markers Int. Number of anchor markers in assembly (for BACs).
	markers int,
        -- WWW_page Text
        wwwpage varchar(100)
) ENGINE=InnoDB;
create index speciesid_index on contigset (speciesid);

create table contigsetauthor (
        id integer auto_increment primary key,
	contigsetid integer,
	-- Author
	authorid integer
) ENGINE=InnoDB;
create index contigsetid_index on contigsetauthor (contigsetid);
create index authorid_index on contigsetauthor (authorid);

create table contigsetremark (
        id integer auto_increment primary key,
	contigsetid integer,
	-- Description, Procedure, Remarks
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index contigsetid_index on contigsetremark (contigsetid);