# MySQL dump 8.16
#
# Host: pfam    Database: pfam_21_0_web
#--------------------------------------------------------
# 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 '',
  pdb_seq_number_A int(10) unsigned NOT NULL default '0',
  auto_pfamseq_A int(10) unsigned NOT NULL default '0',
  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 NOT NULL default '0',
  chain_B char(3) default '',
  pdb_seq_number_B int(10) unsigned NOT NULL default '0',
  auto_pfamseq_B int(10) unsigned NOT NULL default '0',
  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 NOT NULL default '0',
  PRIMARY KEY  (auto_interactions),
  KEY interactions_auto_int_pfamAs_idx (auto_int_pfamAs),
  KEY interactions_auto_int_atoms_idx (auto_int_atoms),
  KEY interactions_auto_pdb_idx (auto_pdb),
  KEY interactions_auto_pfamseq_A_idx (auto_pfamseq_A),
  KEY interactions_auto_pfamseq_B_idx (auto_pfamseq_B),
  KEY interactions_auto_pfamA_A_idx (auto_pfamA_A),
  KEY interactions_auto_pfamA_B_idx (auto_pfamA_B)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=1000000000 AVG_ROW_LENGTH=1000;

