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

#
# Table structure for table 'ligands'
#

DROP TABLE IF EXISTS ligands;
CREATE TABLE ligands (
  ligand_id int(16) unsigned NOT NULL default '0',
  code varchar(10) NOT NULL default '',
  three_letter_code char(3) NOT NULL default '',
  one_letter_code varchar(5) default '',
  name text,
  systematic_name text,
  num_atoms_all int(10) unsigned NOT NULL default '0',
  num_atoms_no_h int(10) unsigned NOT NULL default '0',
  stereo_smiles text NOT NULL,
  non_stereo_smiles text NOT NULL,
  charge int(7) NOT NULL default '0',
  category tinytext,
  formula text,
  molecular_weight float(12,5) default '0.00000',
  PRIMARY KEY  (ligand_id),
  KEY ligands_code_idx (code),
  KEY ligands_three_letter_code_idx (three_letter_code),
  KEY ligands_name_idx (name(8)),
  FULLTEXT KEY ligands_text_idx (name,systematic_name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
