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

#
# Table structure for table 'interactions'
#

CREATE TABLE interactions (
  auto_interactions int(16) unsigned NOT NULL auto_increment,
  auto_int_pfamAs int(16) unsigned NOT NULL default '0',
  auto_int_atoms int(16) unsigned NOT NULL default '0',
  auto_pdb int(10) unsigned NOT NULL default '0',
  chain_A char(3) default NULL,
  pdb_seq_number_A int(10) unsigned default NULL,
  auto_pfamseq_A int(10) unsigned default NULL,
  pfamseq_acc_A varchar(6) NOT NULL default '',
  auto_pfamA_A int(10) unsigned NOT NULL default '0',
  pfamA_acc_A varchar(7) NOT NULL default '',
  pfamA_id_A varchar(40) NOT NULL default '',
  pfamseq_seq_number_A int(10) unsigned default NULL,
  chain_B char(3) default NULL,
  pdb_seq_number_B int(10) unsigned default NULL,
  auto_pfamseq_B int(10) unsigned default NULL,
  pfamseq_acc_B varchar(6) NOT NULL default '',
  auto_pfamA_B int(10) unsigned NOT NULL default '0',
  pfamA_acc_B varchar(7) NOT NULL default '',
  pfamA_id_B varchar(40) NOT NULL default '',
  pfamseq_seq_number_B int(10) unsigned default NULL,
  PRIMARY KEY  (auto_interactions),
  KEY auto_pfamA_A (auto_pfamA_A),
  KEY auto_pfamA_B (auto_pfamA_B),
  KEY auto_pfamseq_A (auto_pfamseq_A),
  KEY auto_pfamseq_B (auto_pfamseq_B),
  KEY auto_int_pfamAs (auto_int_pfamAs),
  KEY auto_int_atoms (auto_int_atoms),
  KEY auto_pdb (auto_pdb)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
