# MySQL dump 8.16
#
# Host: pfam    Database: pfam_20_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 NULL,
  PRIMARY KEY  (region_id),
  KEY auto_pfamseq (auto_pfamseq),
  KEY type_id (type_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
