-- MySQL dump 8.23
--
-- Host: localhost    Database: PO_0205
---------------------------------------------------------
-- Server version	4.1.7-standard-log

--
-- Table structure for table `term2term`
--

CREATE TABLE term2term (
  id int(11) NOT NULL auto_increment,
  relationship_type_id int(11) NOT NULL default '0',
  term1_id int(11) NOT NULL default '0',
  term2_id int(11) NOT NULL default '0',
  complete int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY term1_id (term1_id,term2_id,relationship_type_id),
  KEY tt1 (term1_id),
  KEY tt2 (term2_id),
  KEY tt3 (term1_id,term2_id),
  KEY tt4 (relationship_type_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;