-- MySQL dump 8.23
--
-- Host: localhost    Database: ligbase_new
---------------------------------------------------------
-- Server version	4.0.20

--
-- Table structure for table `active_residues`
--

CREATE TABLE active_residues (
  pdb_code char(4) NOT NULL default '',
  ligand_idnum char(3) NOT NULL default '',
  distance float default NULL,
  pdb_chain char(1) NOT NULL default '',
  ligand_code char(3) NOT NULL default '',
  ligand_id_code smallint(6) NOT NULL default '0',
  ligand_idalt char(3) default NULL,
  ligand_atom char(4) NOT NULL default '',
  ligand_chain char(1) NOT NULL default '',
  residue_name char(3) default NULL,
  residue_num smallint(6) NOT NULL default '0',
  residue_num_alt char(3) NOT NULL default '',
  receptor_atom char(3) NOT NULL default '',
  PRIMARY KEY  (pdb_code,ligand_idnum,pdb_chain,ligand_id_code,ligand_atom,ligand_chain,residue_num,residue_num_alt),
  KEY pdbcc (pdb_code,pdb_chain),
  KEY pdbcl (pdb_code,ligand_chain),
  KEY activei (ligand_idnum)
) TYPE=MyISAM;
