root / db / create_ojb_tables.sql

-- MySQL dump 10.7
--
-- Host: localhost    Database: pv_test
-- ------------------------------------------------------
-- Server version       4.1.3-beta-standard

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;

--
-- Table structure for table `OJB_DLIST`
--

DROP TABLE IF EXISTS `OJB_DLIST`;
CREATE TABLE `OJB_DLIST` (
  `ID` int(11) NOT NULL default '0',
  `SIZE_` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_DLIST`
--


/*!40000 ALTER TABLE `OJB_DLIST` DISABLE KEYS */;
LOCK TABLES `OJB_DLIST` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_DLIST` ENABLE KEYS */;

--
-- Table structure for table `OJB_DLIST_ENTRIES`
--

DROP TABLE IF EXISTS `OJB_DLIST_ENTRIES`;
CREATE TABLE `OJB_DLIST_ENTRIES` (
  `ID` int(11) NOT NULL default '0',
  `DLIST_ID` int(11) NOT NULL default '0',
  `POSITION_` int(11) default NULL,
  `OID_` longblob,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_DLIST_ENTRIES`
--


/*!40000 ALTER TABLE `OJB_DLIST_ENTRIES` DISABLE KEYS */;
LOCK TABLES `OJB_DLIST_ENTRIES` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_DLIST_ENTRIES` ENABLE KEYS */;

--
-- Table structure for table `OJB_DSET`
--

DROP TABLE IF EXISTS `OJB_DSET`;
CREATE TABLE `OJB_DSET` (
  `ID` int(11) NOT NULL default '0',
  `SIZE_` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_DSET`
--


/*!40000 ALTER TABLE `OJB_DSET` DISABLE KEYS */;
LOCK TABLES `OJB_DSET` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_DSET` ENABLE KEYS */;

--
-- Table structure for table `OJB_DSET_ENTRIES`
--

DROP TABLE IF EXISTS `OJB_DSET_ENTRIES`;
CREATE TABLE `OJB_DSET_ENTRIES` (
  `ID` int(11) NOT NULL default '0',
  `DLIST_ID` int(11) NOT NULL default '0',
  `POSITION_` int(11) default NULL,
  `OID_` longblob,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_DSET_ENTRIES`
--


/*!40000 ALTER TABLE `OJB_DSET_ENTRIES` DISABLE KEYS */;
LOCK TABLES `OJB_DSET_ENTRIES` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_DSET_ENTRIES` ENABLE KEYS */;

--
-- Table structure for table `OJB_DMAP`
--

DROP TABLE IF EXISTS `OJB_DMAP`;
CREATE TABLE `OJB_DMAP` (
  `ID` int(11) NOT NULL default '0',
  `SIZE_` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_DMAP`
--


/*!40000 ALTER TABLE `OJB_DMAP` DISABLE KEYS */;
LOCK TABLES `OJB_DMAP` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_DMAP` ENABLE KEYS */;

--
-- Table structure for table `OJB_DMAP_ENTRIES`
--

DROP TABLE IF EXISTS `OJB_DMAP_ENTRIES`;
CREATE TABLE `OJB_DMAP_ENTRIES` (
  `ID` int(11) NOT NULL default '0',
  `DMAP_ID` int(11) NOT NULL default '0',
  `KEY_OID` longblob,
  `VALUE_OID` longblob,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_DMAP_ENTRIES`
--


/*!40000 ALTER TABLE `OJB_DMAP_ENTRIES` DISABLE KEYS */;
LOCK TABLES `OJB_DMAP_ENTRIES` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_DMAP_ENTRIES` ENABLE KEYS */;

--
-- Table structure for table `OJB_HL_SEQ`
--

DROP TABLE IF EXISTS `OJB_HL_SEQ`;
CREATE TABLE `OJB_HL_SEQ` (
  `TABLENAME` varchar(175) NOT NULL default '',
  `FIELDNAME` varchar(70) NOT NULL default '',
  `MAX_KEY` int(11) default NULL,
  `GRAB_SIZE` int(11) default NULL,
  PRIMARY KEY  (`TABLENAME`,`FIELDNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_HL_SEQ`
--


/*!40000 ALTER TABLE `OJB_HL_SEQ` DISABLE KEYS */;
LOCK TABLES `OJB_HL_SEQ` WRITE;
INSERT INTO `OJB_HL_SEQ` VALUES ('SEQ_OJB_DLIST','ID',14840,20),('SEQ_photo_collections','collection_id',5380,20),('SEQ_OJB_DLIST_ENTRIES','ID',101100,20),('SEQ_photos','photo_id',13564,20);
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_HL_SEQ` ENABLE KEYS */;

--
-- Table structure for table `OJB_LOCKENTRY`
--

DROP TABLE IF EXISTS `OJB_LOCKENTRY`;
CREATE TABLE `OJB_LOCKENTRY` (
  `OID_` varchar(250) NOT NULL default '',
  `TX_ID` varchar(50) NOT NULL default '',
  `TIMESTAMP_` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ISOLATIONLEVEL` int(11) default NULL,
  `LOCKTYPE` int(11) default NULL,
  PRIMARY KEY  (`OID_`,`TX_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_LOCKENTRY`
--


/*!40000 ALTER TABLE `OJB_LOCKENTRY` DISABLE KEYS */;
LOCK TABLES `OJB_LOCKENTRY` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_LOCKENTRY` ENABLE KEYS */;

--
-- Table structure for table `OJB_NRM`
--

DROP TABLE IF EXISTS `OJB_NRM`;
CREATE TABLE `OJB_NRM` (
  `NAME` varchar(250) NOT NULL default '',
  `OID_` longblob,
  PRIMARY KEY  (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OJB_NRM`
--


/*!40000 ALTER TABLE `OJB_NRM` DISABLE KEYS */;
LOCK TABLES `OJB_NRM` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `OJB_NRM` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;