-- MySQL dump 8.23 -- -- Host: localhost Database: PO_0205 --------------------------------------------------------- -- Server version 4.1.7-standard-log -- -- Table structure for table `seq` -- CREATE TABLE seq ( id int(11) NOT NULL auto_increment, display_id varchar(64) default NULL, description varchar(255) default NULL, seq mediumtext, seq_len int(11) default NULL, md5checksum varchar(32) default NULL, moltype varchar(25) default NULL, `timestamp` int(11) default NULL, PRIMARY KEY (id), UNIQUE KEY seq0 (id), UNIQUE KEY display_id (display_id,md5checksum), KEY seq1 (display_id), KEY seq2 (md5checksum) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;