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

--
-- Table structure for table `term`
--

CREATE TABLE term (
  id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  term_type varchar(55) NOT NULL default '',
  acc varchar(255) NOT NULL default '',
  is_obsolete int(11) NOT NULL default '0',
  is_root int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY acc (acc),
  UNIQUE KEY t0 (id),
  KEY t1 (name),
  KEY t2 (term_type),
  KEY t3 (acc)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;