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

#
# Table structure for table 'seq_info'
#

DROP TABLE IF EXISTS seq_info;
CREATE TABLE seq_info (
  pfamA_acc varchar(7) NOT NULL default '',
  pfamA_id varchar(40) NOT NULL default '',
  description varchar(100) NOT NULL default '',
  auto_pfamA int(10) unsigned NOT NULL default '0',
  auto_pfamseq int(10) unsigned NOT NULL default '0',
  pfamseq_id varchar(12) NOT NULL default '',
  pfamseq_acc varchar(6) NOT NULL default '',
  seq_description text NOT NULL,
  species varchar(100) NOT NULL default '',
  KEY seq_info_pfamA_acc_idx (pfamA_acc),
  KEY seq_info_pfamA_id_idx (pfamA_id),
  KEY seq_info_pfamseq_id_idx (pfamseq_id),
  KEY seq_info_pfamseq_acc_idx (pfamseq_acc),
  KEY seq_info_auto_pfamA_idx (auto_pfamA),
  KEY seq_info_auto_pfamseq_idx (auto_pfamseq),
  FULLTEXT KEY seq_info_text_idx (seq_description,species)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
