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

#
# Table structure for table 'int_ext_links'
#

DROP TABLE IF EXISTS int_ext_links;
CREATE TABLE int_ext_links (
  auto_int_ext_links int(16) unsigned NOT NULL auto_increment,
  auto_pfamseq_A int(10) unsigned NOT NULL default '0',
  pfamseq_acc_A varchar(6) NOT NULL default '',
  auto_pfamA_A int(10) unsigned default NULL,
  pfamA_id_A varchar(40) default NULL,
  auto_pfamseq_B int(10) unsigned NOT NULL default '0',
  pfamseq_acc_B varchar(6) NOT NULL default '',
  auto_pfamA_B int(10) unsigned default NULL,
  pfamA_id_B varchar(40) default NULL,
  reference varchar(64) NOT NULL default '',
  experiment_ref varchar(10) default NULL,
  auto_int_pfamAs int(16) unsigned default NULL,
  dataset varchar(64) default NULL,
  PRIMARY KEY  (auto_int_ext_links),
  KEY auto_pfamA_B (auto_pfamA_B),
  KEY auto_pfamseq_B (auto_pfamseq_B),
  KEY auto_int_ext_links_index (auto_int_ext_links),
  KEY auto_int_pfamAs_index (auto_int_pfamAs),
  KEY auto_pfamA_index (auto_pfamA_A,auto_pfamA_B),
  KEY auto_pfamseq_index (auto_pfamseq_A,auto_pfamseq_B),
  KEY pfamseq_acc_index (pfamseq_acc_A,pfamseq_acc_B)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
