-- MySQL dump 8.23
--
-- Host: localhost    Database: mobyobject
---------------------------------------------------------
-- Server version	4.1.12-standard

--
-- Table structure for table `object`
--

CREATE TABLE object (
  object_id int(10) unsigned NOT NULL auto_increment,
  object_lsid varchar(255) NOT NULL default '',
  object_type varchar(255) NOT NULL default '',
  description text NOT NULL,
  authority varchar(255) NOT NULL default '',
  contact_email varchar(255) NOT NULL default '',
  PRIMARY KEY  (object_id),
  UNIQUE KEY object_type (object_type)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `object_term2term`
--

CREATE TABLE object_term2term (
  assertion_id int(10) unsigned NOT NULL auto_increment,
  relationship_type varchar(255) NOT NULL default '',
  object1_id int(11) NOT NULL default '0',
  object2_id int(11) NOT NULL default '0',
  object2_articlename varchar(255) default NULL,
  PRIMARY KEY  (assertion_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;