# MySQL dump 8.16
#
# Host: pfam    Database: pfam_19_0
#--------------------------------------------------------
# Server version	4.1.10-standard

#
# Table structure for table 'pfamseq'
#

CREATE TABLE pfamseq (
  auto_pfamseq int(10) unsigned NOT NULL auto_increment,
  pfamseq_id varchar(12) NOT NULL default '',
  pfamseq_acc varchar(6) NOT NULL default '',
  crc64 varchar(16) NOT NULL default '',
  description text NOT NULL,
  length mediumint(8) unsigned NOT NULL default '0',
  species varchar(100) NOT NULL default '',
  taxonomy mediumtext,
  is_fragment tinyint(4) default NULL,
  version varchar(6) default NULL,
  current tinyint(4) default NULL,
  non_cons tinyint(4) default NULL,
  sequence blob NOT NULL,
  updated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  created datetime default NULL,
  PRIMARY KEY  (auto_pfamseq),
  UNIQUE KEY pfamseq_acc (pfamseq_acc),
  KEY crc64 (crc64),
  KEY pfamseq_id (pfamseq_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
