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

#
# Table structure for table 'pdb_new'
#

DROP TABLE IF EXISTS pdb_new;
CREATE TABLE pdb_new (
  auto_pdb int(10) unsigned NOT NULL auto_increment,
  pdb_id varchar(5) NOT NULL default '',
  header tinytext,
  title mediumtext,
  `date` tinytext,
  resolution decimal(5,2) default '0.00',
  experiment_short tinytext,
  experiment_long tinytext,
  pubmed_id int(10) unsigned default NULL,
  PRIMARY KEY  (auto_pdb),
  KEY pdb_new_pdb_id_idx (pdb_id),
  KEY pdb_new_experiment_short_idx (experiment_short(4)),
  FULLTEXT KEY pdb_new_text_idx (pdb_id,header,title,experiment_short,experiment_long)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
