-- MySQL dump 10.13  Distrib 5.1.31sp1, for unknown-linux-gnu (x86_64)
--
-- Host: localhost    Database: hybris_stg
-- ------------------------------------------------------
-- Server version	5.1.31sp1-enterprise-gpl-pro-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `catalogversions`
--

DROP TABLE IF EXISTS `catalogversions`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `catalogversions` (
  `hjmpTS` bigint(20) DEFAULT NULL,
  `createdTS` datetime NOT NULL,
  `OwnerPkString` bigint(20) DEFAULT NULL,
  `aCLTS` bigint(20) DEFAULT '0',
  `modifiedTS` datetime DEFAULT NULL,
  `PK` bigint(20) NOT NULL,
  `TypePkString` bigint(20) NOT NULL,
  `propTS` bigint(20) DEFAULT '0',
  `p_defaultcurrency` bigint(20) DEFAULT NULL,
  `p_previousupdateversion` int(11) DEFAULT NULL,
  `p_inclpacking` tinyint(1) DEFAULT NULL,
  `p_categorysystemid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_catalog` bigint(20) DEFAULT NULL,
  `p_mimerootdirectory` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_version` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_previousversion` bigint(20) DEFAULT NULL,
  `p_languages` text COLLATE utf8_bin,
  `p_generatorinfo` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_inclfreight` tinyint(1) DEFAULT NULL,
  `p_inclduty` tinyint(1) DEFAULT NULL,
  `p_inclassurance` tinyint(1) DEFAULT NULL,
  `p_generationdate` datetime DEFAULT NULL,
  `p_active` tinyint(1) DEFAULT NULL,
  `p_territories` text COLLATE utf8_bin,
  PRIMARY KEY (`PK`),
  KEY `owneridx_601` (`OwnerPkString`),
  KEY `typepkindex_601` (`TypePkString`),
  KEY `catalogRelIDX_601` (`p_catalog`),
  KEY `versionIDX_601` (`p_version`),
  KEY `catalogIDX_601` (`p_catalog`),
  KEY `visibleIDX_601` (`p_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `catalogversions`
--

LOCK TABLES `catalogversions` WRITE;
/*!40000 ALTER TABLE `catalogversions` DISABLE KEYS */;
INSERT INTO `catalogversions` VALUES (3,'2009-05-14 13:25:44',NULL,0,'2009-05-14 13:25:44',169173715229408304,23088202315820656,0,NULL,NULL,0,NULL,168892240252697408,NULL,'Online',NULL,',#1,9014453480926624,',NULL,0,0,0,NULL,1,NULL),(3,'2009-05-14 13:25:44',NULL,0,'2009-05-14 13:25:44',169173715229408448,23088202315820656,0,NULL,NULL,0,NULL,168892240252697408,NULL,'Staged',NULL,',#1,9014453480926624,',NULL,0,0,0,NULL,0,NULL),(1,'2009-05-14 13:25:44',NULL,0,'2009-05-14 13:25:44',169173715229418752,23088202315820656,0,NULL,NULL,0,NULL,168892240252707504,NULL,'eBook',NULL,',#1,9014453480926624,9014453480926752,',NULL,1,1,1,NULL,0,NULL),(1,'2009-05-14 13:25:44',NULL,0,'2009-05-14 13:25:44',169173715229418880,23088202315820656,0,NULL,NULL,0,NULL,168892240252707504,NULL,'nbdBook',NULL,',#1,9014453480926624,9014453480926752,',NULL,1,1,1,NULL,1,NULL),(1,'2009-05-14 13:25:44',NULL,0,'2009-05-14 13:25:44',169173715229419024,23088202315820656,0,NULL,NULL,0,NULL,168892240252707504,NULL,'nonBook',NULL,',#1,9014453480926624,9014453480926752,',NULL,1,1,1,NULL,0,NULL),(1,'2009-05-14 13:25:44',NULL,0,'2009-05-14 13:25:44',169173715229419152,23088202315820656,0,NULL,NULL,0,NULL,168892240252707632,NULL,'staged',169173715229418880,',#1,9014453480926624,9014453480926752,',NULL,1,1,1,NULL,1,NULL),(1,'2009-05-14 13:25:44',NULL,0,'2009-05-14 13:25:44',169173715229419280,23088202315820656,0,NULL,NULL,0,NULL,168892240252707744,NULL,'staged',169173715229419152,',#1,9014453480926624,9014453480926752,',NULL,1,1,1,NULL,1,NULL),(1,'2009-05-14 13:25:44',NULL,0,'2009-05-14 13:25:44',169173715229419392,23088202315820656,0,NULL,NULL,0,NULL,168892240252707744,NULL,'live',NULL,',#1,9014453480926624,9014453480926752,',NULL,1,1,1,NULL,0,NULL);
/*!40000 ALTER TABLE `catalogversions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `jobs` (
  `hjmpTS` bigint(20) DEFAULT NULL,
  `TypePkString` bigint(20) NOT NULL,
  `aCLTS` bigint(20) DEFAULT '0',
  `createdTS` datetime NOT NULL,
  `OwnerPkString` bigint(20) DEFAULT NULL,
  `modifiedTS` datetime DEFAULT NULL,
  `PK` bigint(20) NOT NULL,
  `propTS` bigint(20) DEFAULT '0',
  `p_maxthreads` int(11) DEFAULT NULL,
  `p_scale` float(20,5) DEFAULT NULL,
  `p_directory` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_location` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_validationmode` bigint(20) DEFAULT NULL,
  `p_createnewitems` tinyint(1) DEFAULT NULL,
  `p_enabletransactions` tinyint(1) DEFAULT NULL,
  `p_encoding` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_model` bigint(20) DEFAULT NULL,
  `p_code` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_csvs` tinyint(1) DEFAULT NULL,
  `p_lastexportdatetime` datetime DEFAULT NULL,
  `p_maxupdatesperrun` int(11) DEFAULT NULL,
  `p_deep` tinyint(1) DEFAULT NULL,
  `p_copycachesize` int(11) DEFAULT NULL,
  `p_removemissingitems` tinyint(1) DEFAULT NULL,
  `p_exportsystem` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `p_sourceversion` bigint(20) DEFAULT NULL,
  `p_syncorder` int(11) DEFAULT NULL,
  `p_zips` tinyint(1) DEFAULT NULL,
  `p_targetversion` bigint(20) DEFAULT NULL,
  `p_exclusivemode` tinyint(1) DEFAULT NULL,
  `p_quote` smallint(6) DEFAULT NULL,
  `p_separator` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`PK`),
  KEY `owneridx_500` (`OwnerPkString`),
  KEY `typepkindex_500` (`TypePkString`),
  KEY `IdxCode_500` (`p_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
INSERT INTO `jobs` VALUES (1,23088202315813168,0,'2009-05-14 13:25:38',NULL,'2009-05-14 13:25:38',140744742581538304,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Type and Localization Export',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315816272,0,'2009-05-14 13:25:38',NULL,'2009-05-14 13:25:38',140744742581542496,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ImpEx-Import',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315814672,0,'2009-05-14 13:25:38',NULL,'2009-05-14 13:25:38',140744742581550416,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Lucenesearch-RebuildIndex-Job',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315814768,0,'2009-05-14 13:25:39',NULL,'2009-05-14 13:25:39',140744742581557280,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Lucenesearch-UpdateIndex-Job',NULL,NULL,2400,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315822256,0,'2009-05-14 13:25:44',NULL,'2009-05-14 13:25:44',140744742581633136,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,'Sync Default:Staged -> Default:Online',NULL,NULL,NULL,NULL,NULL,0,NULL,169173715229408448,NULL,NULL,169173715229408304,0,NULL,NULL),(1,23088202315820976,0,'2009-05-14 13:25:44',NULL,'2009-05-14 13:25:44',140744742581638944,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CompareCatalogVersionsJob',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315821104,0,'2009-05-14 13:25:44',NULL,'2009-05-14 13:25:44',140744742581639104,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'RemoveCatalogVersionJob',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315832448,0,'2009-05-14 13:26:50',NULL,'2009-05-14 13:26:50',140744742582693504,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dataload',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315832112,0,'2009-05-14 13:26:50',NULL,'2009-05-14 13:26:50',140744742582693888,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Endeca.Full.Export',NULL,NULL,NULL,NULL,NULL,NULL,'ENDECA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315832112,0,'2009-05-14 13:26:50',NULL,'2009-05-14 13:26:50',140744742582694112,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Endeca.Delta.Export',NULL,NULL,NULL,NULL,NULL,NULL,'ENDECA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315832112,0,'2009-05-14 13:26:50',NULL,'2009-05-14 13:26:50',140744742582694368,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Endeca.Incremental.Export',NULL,NULL,NULL,NULL,NULL,NULL,'ENDECA',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315832112,0,'2009-05-14 13:26:50',NULL,'2009-05-14 13:26:50',140744742582694592,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BazaarVoice.Full.Export',NULL,NULL,NULL,NULL,NULL,NULL,'BAZAARVOICE',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315832112,0,'2009-05-14 13:26:50',NULL,'2009-05-14 13:26:50',140744742582694832,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BazaarVoice.Incremental.Export',NULL,NULL,NULL,NULL,NULL,NULL,'BAZAARVOICE',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315832112,0,'2009-05-14 13:26:50',NULL,'2009-05-14 13:26:50',140744742582695088,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BVRelatedProducts',NULL,NULL,NULL,NULL,NULL,NULL,'BVRELATED',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(1,23088202315832240,0,'2009-05-14 13:26:50',NULL,'2009-05-14 13:26:50',140744742582695632,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LoaderJob',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,23088202315822256,0,'2009-05-14 13:27:50',NULL,'2009-05-17 12:24:11',140744742583660272,0,16,NULL,NULL,NULL,NULL,1,0,NULL,NULL,'feeds:nbdBook->master:staged',NULL,NULL,NULL,NULL,NULL,0,NULL,169173715229418880,NULL,NULL,169173715229419152,0,NULL,NULL),(2,23088202315822256,0,'2009-05-14 13:27:50',NULL,'2009-05-14 13:27:51',140744742583663696,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,'feeds:nonBook->master:staged',NULL,NULL,NULL,NULL,NULL,0,NULL,169173715229419024,NULL,NULL,169173715229419152,0,NULL,NULL),(2,23088202315822256,0,'2009-05-14 13:27:51',NULL,'2009-05-14 13:27:51',140744742583666176,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,'feeds:eBook->master:staged',NULL,NULL,NULL,NULL,NULL,0,NULL,169173715229418752,NULL,NULL,169173715229419152,0,NULL,NULL),(4,23088202315822256,0,'2009-05-14 13:27:51',NULL,'2009-05-18 16:21:32',140744742583668704,0,16,NULL,NULL,NULL,NULL,1,0,NULL,NULL,'master->web:staged',NULL,NULL,NULL,NULL,NULL,0,NULL,169173715229419152,NULL,NULL,169173715229419280,0,NULL,NULL),(2,23088202315822256,0,'2009-05-14 13:27:51',NULL,'2009-05-14 13:27:51',140744742583671440,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,'web:staged->web:live',NULL,NULL,NULL,NULL,NULL,0,NULL,169173715229419280,NULL,NULL,169173715229419392,0,NULL,NULL),(3,23088202315822256,0,'2009-05-14 13:27:51',NULL,'2009-05-14 13:27:51',140744742583673904,0,NULL,NULL,NULL,NULL,NULL,1,0,NULL,NULL,'feeds:nbdBook->web:staged',NULL,NULL,NULL,NULL,NULL,0,NULL,169173715229418880,NULL,NULL,169173715229419280,0,NULL,NULL);
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-05-21 13:00:50