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

#
# Table structure for table 'pfamseq'
#

DROP TABLE IF EXISTS 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 '',
  seq_version tinyint(4) unsigned NOT NULL default '0',
  crc64 varchar(16) NOT NULL default '',
  md5 varchar(32) NOT NULL default '',
  description text NOT NULL,
  length mediumint(8) unsigned NOT NULL default '0',
  species varchar(100) NOT NULL default '',
  taxonomy mediumtext NOT NULL,
  ncbi_code int(10) unsigned default '0',
  is_fragment tinyint(4) NOT NULL default '0',
  current tinyint(4) NOT NULL default '0',
  non_cons tinyint(4) NOT NULL default '0',
  sequence blob NOT NULL,
  updated timestamp NOT NULL default CURRENT_TIMESTAMP,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  genome_seq tinyint(1) default '0',
  auto_architecture int(10) unsigned default NULL,
  treefam_acc varchar(8) default NULL,
  PRIMARY KEY  (auto_pfamseq),
  KEY pfamseq_pfamseq_acc_idx (pfamseq_acc),
  KEY pfamseq_pfamseq_id_idx (pfamseq_id),
  KEY pfamseq_ncbi_code_idx (ncbi_code,genome_seq),
  KEY pfamseq_md5_idx (md5),
  KEY pfamseq_crc64_idx (crc64),
  KEY pfamseq_auto_architecture_idx (auto_architecture)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
