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

#
# Table structure for table 'other_reg'
#

DROP TABLE IF EXISTS other_reg;
CREATE TABLE other_reg (
  region_id int(10) unsigned NOT NULL auto_increment,
  auto_pfamseq int(10) unsigned NOT NULL default '0',
  seq_start mediumint(8) unsigned NOT NULL default '0',
  seq_end mediumint(6) unsigned NOT NULL default '0',
  type_id varchar(20) NOT NULL default '',
  source_id varchar(20) NOT NULL default '',
  score double(16,4) default NULL,
  orientation varchar(4) default '',
  PRIMARY KEY  (region_id),
  KEY other_reg_type_id_idx (type_id),
  KEY other_reg_source_id_idx (source_id),
  KEY other_reg_auto_pfamseq_idx (auto_pfamseq)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
