-- updated 040505 DDH
-- comment out marker1 051101 DDH
-- remove marker1 051106 DDH

-- this isn't a real GrainGenes class
-- this combines Genes and Probes and Loci to make the pseudoclass marker
-- this assumes that markers are composed of either genes or probes or loci
-- populate from unique names in gene and probe and locus tables
-- this could be done with a view in PostgreSQL

create table marker (
        id integer auto_increment primary key,
        name varchar(255),
        geneid integer,
        probeid integer,
        locusid integer
) ENGINE=InnoDB;
create index name_index on marker (name);
create index geneid_index on marker (geneid);
create index probeid_index on marker (probeid);
create index locusid_index on marker (locusid);

