# MySQL dump 8.16
#
# Host: pfam    Database: pfam_20_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) default NULL,
  model_length mediumint(8) unsigned default NULL,
  author tinytext,
  seed_source tinytext,
  alignment_method tinytext,
  `type` tinytext,
  ls_sequence_GA double(16,4) default NULL,
  ls_domain_GA double(16,4) default NULL,
  fs_sequence_GA double(16,4) default NULL,
  fs_domain_GA double(16,4) default NULL,
  ls_sequence_TC double(16,4) default NULL,
  ls_domain_TC double(16,4) default NULL,
  fs_sequence_TC double(16,4) default NULL,
  fs_domain_TC double(16,4) default NULL,
  ls_sequence_NC double(16,4) default NULL,
  ls_domain_NC double(16,4) default NULL,
  fs_sequence_NC double(16,4) default NULL,
  fs_domain_NC double(16,4) default NULL,
  ls_mu double(16,4) default NULL,
  ls_kappa double(16,4) default NULL,
  fs_mu double(16,4) default NULL,
  fs_kappa double(16,4) default NULL,
  `comment` longtext,
  previous_id tinytext,
  hmmbuild_ls tinytext,
  hmmcalibrate_ls tinytext,
  hmmbuild_fs tinytext,
  hmmcalibrate_fs tinytext,
  num_seed int(10) unsigned default NULL,
  num_full int(10) unsigned default NULL,
  updated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  created datetime default NULL,
  version smallint(5) unsigned default NULL,
  PRIMARY KEY  (auto_pfamA),
  UNIQUE KEY pfamA_acc (pfamA_acc),
  UNIQUE KEY pfamA_id (pfamA_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
