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

#
# Table structure for table 'pdbmap'
#

DROP TABLE IF EXISTS pdbmap;
CREATE TABLE pdbmap (
  auto_pdb int(10) unsigned NOT NULL default '0',
  chain char(2) default '',
  pdb_start_res varchar(10) NOT NULL default '',
  pdb_end_res varchar(10) NOT NULL default '',
  auto_pfam int(10) unsigned NOT NULL default '0',
  pfam_region tinyint(4) NOT NULL default '0',
  auto_pfamseq int(10) unsigned NOT NULL default '0',
  pfam_start_res varchar(10) NOT NULL default '',
  pfam_end_res varchar(10) NOT NULL default '',
  complex tinyint(4) default NULL,
  hex_colour varchar(6) default NULL,
  KEY pdbmap_auto_pfam_idx (auto_pfam),
  KEY pdbmap_auto_pfamseq_idx (auto_pfamseq),
  KEY pdbmap_pfam_region_idx (pfam_region),
  KEY auto_pdb (auto_pdb)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
