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

#
# Table structure for table 'pfamA'
#

DROP TABLE IF EXISTS pfamA;
CREATE TABLE pfamA (
  auto_pfamA int(10) unsigned NOT NULL auto_increment,
  pfamA_acc varchar(7) NOT NULL default '',
  pfamA_id varchar(40) NOT NULL default '',
  description varchar(100) NOT NULL default '',
  model_length mediumint(8) unsigned NOT NULL default '0',
  author tinytext NOT NULL,
  seed_source tinytext NOT NULL,
  alignment_method tinytext,
  `type` tinytext NOT NULL,
  ls_sequence_GA double(16,4) NOT NULL default '0.0000',
  ls_domain_GA double(16,4) NOT NULL default '0.0000',
  fs_sequence_GA double(16,4) NOT NULL default '0.0000',
  fs_domain_GA double(16,4) NOT NULL default '0.0000',
  ls_sequence_TC double(16,4) NOT NULL default '0.0000',
  ls_domain_TC double(16,4) NOT NULL default '0.0000',
  fs_sequence_TC double(16,4) NOT NULL default '0.0000',
  fs_domain_TC double(16,4) NOT NULL default '0.0000',
  ls_sequence_NC double(16,4) NOT NULL default '0.0000',
  ls_domain_NC double(16,4) NOT NULL default '0.0000',
  fs_sequence_NC double(16,4) NOT NULL default '0.0000',
  fs_domain_NC double(16,4) NOT NULL default '0.0000',
  ls_mu double(16,4) NOT NULL default '0.0000',
  ls_kappa double(16,4) NOT NULL default '0.0000',
  fs_mu double(16,4) NOT NULL default '0.0000',
  fs_kappa double(16,4) NOT NULL default '0.0000',
  `comment` longtext,
  previous_id tinytext,
  hmmbuild_ls tinytext NOT NULL,
  hmmcalibrate_ls tinytext NOT NULL,
  hmmbuild_fs tinytext NOT NULL,
  hmmcalibrate_fs tinytext NOT NULL,
  num_seed int(10) unsigned default NULL,
  num_full int(10) unsigned default NULL,
  updated timestamp NOT NULL default CURRENT_TIMESTAMP,
  created datetime NOT NULL default '0000-00-00 00:00:00',
  version smallint(5) unsigned NOT NULL default '0',
  average_length double(6,1) default NULL,
  percentage_id int(3) unsigned default NULL,
  average_coverage double(6,2) default NULL,
  change_status tinytext,
  seed_consensus text,
  full_consensus text,
  PRIMARY KEY  (auto_pfamA),
  KEY pfamA_pfamA_acc_idx (pfamA_acc),
  KEY pfamA_pfamA_id_idx (pfamA_id),
  KEY pfamA_change_status_idx (change_status(2)),
  FULLTEXT KEY pfamA_text_idx (pfamA_acc,pfamA_id,description,`comment`,previous_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
