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

--
-- Table structure for table `ligands`
--

CREATE TABLE ligands (
  pdb_code char(4) NOT NULL default '',
  ligand_idnum char(3) NOT NULL default '',
  ligand_chain char(1) default NULL,
  ligand_code char(3) NOT NULL default '',
  ligand_id_code smallint(6) NOT NULL default '0',
  ligand_idalt char(3) default NULL,
  description char(100) default NULL,
  PRIMARY KEY  (pdb_code,ligand_idnum,ligand_code,ligand_id_code),
  KEY ligc (pdb_code,ligand_chain),
  KEY ligb (ligand_chain,pdb_code),
  KEY ligi (ligand_idnum)
) TYPE=MyISAM;
