-- MySQL dump 10.11
--
-- Host: localhost    Database: xwiki
-- ------------------------------------------------------
-- Server version	5.0.51a-3ubuntu5.7

/*!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 `activitystream_events`
--

DROP TABLE IF EXISTS `activitystream_events`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `activitystream_events` (
  `ase_eventid` varchar(255) NOT NULL,
  `ase_requestid` text,
  `ase_stream` varchar(255) default NULL,
  `ase_date` datetime default NULL,
  `ase_priority` int(11) default NULL,
  `ase_type` varchar(255) default NULL,
  `ase_application` varchar(255) default NULL,
  `ase_user` varchar(255) default NULL,
  `ase_wiki` varchar(255) default NULL,
  `ase_space` varchar(255) default NULL,
  `ase_page` varchar(255) default NULL,
  `ase_url` text,
  `ase_title` text,
  `ase_body` text,
  `ase_version` varchar(30) default NULL,
  `ase_param1` text,
  `ase_param2` text,
  `ase_param3` text,
  `ase_param4` text,
  `ase_param5` text,
  PRIMARY KEY  (`ase_eventid`),
  KEY `ase_requestid` (`ase_requestid`(200)),
  KEY `ase_stream` (`ase_stream`),
  KEY `ase_date` (`ase_date`),
  KEY `ase_priority` (`ase_priority`),
  KEY `ase_type` (`ase_type`),
  KEY `ase_application` (`ase_application`),
  KEY `ase_user` (`ase_user`),
  KEY `ase_wiki` (`ase_wiki`),
  KEY `ase_space` (`ase_space`),
  KEY `ase_page` (`ase_page`),
  KEY `ase_param1` (`ase_param1`(200)),
  KEY `ase_param2` (`ase_param2`(200)),
  KEY `ase_param3` (`ase_param3`(200)),
  KEY `ase_param4` (`ase_param4`(200)),
  KEY `ase_param5` (`ase_param5`(200))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `feeds_aggregatorgroup`
--

DROP TABLE IF EXISTS `feeds_aggregatorgroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `feeds_aggregatorgroup` (
  `agg_id` int(11) NOT NULL,
  `agg_name` text,
  PRIMARY KEY  (`agg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `feeds_aggregatorurl`
--

DROP TABLE IF EXISTS `feeds_aggregatorurl`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `feeds_aggregatorurl` (
  `agg_id` int(11) NOT NULL,
  `agg_name` text,
  `agg_url` text,
  `agg_date` datetime default NULL,
  `agg_nb` int(11) default NULL,
  PRIMARY KEY  (`agg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `feeds_aggregatorurlgroups`
--

DROP TABLE IF EXISTS `feeds_aggregatorurlgroups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `feeds_aggregatorurlgroups` (
  `agl_id` int(11) NOT NULL,
  `agl_value` varchar(255) default NULL,
  `agl_number` int(11) NOT NULL,
  PRIMARY KEY  (`agl_id`,`agl_number`),
  KEY `FK7B845B068E772CC` (`agl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `feeds_feedentry`
--

DROP TABLE IF EXISTS `feeds_feedentry`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `feeds_feedentry` (
  `fee_id` int(11) NOT NULL,
  `fee_title` text,
  `fee_author` text,
  `fee_feedurl` text,
  `fee_feedname` text,
  `fee_url` text,
  `fee_category` text,
  `fee_content` text,
  `fee_fullcontent` text,
  `fee_xml` text,
  `fee_date` datetime default NULL,
  `fee_flag` int(11) default '0',
  `fee_read` int(11) default '0',
  PRIMARY KEY  (`fee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `feeds_feedentrytags`
--

DROP TABLE IF EXISTS `feeds_feedentrytags`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `feeds_feedentrytags` (
  `fet_id` int(11) NOT NULL,
  `fet_value` varchar(255) default NULL,
  `fet_number` int(11) NOT NULL,
  PRIMARY KEY  (`fet_id`,`fet_number`),
  KEY `FKBE0037834855150F` (`fet_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `feeds_keyword`
--

DROP TABLE IF EXISTS `feeds_keyword`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `feeds_keyword` (
  `key_id` int(11) NOT NULL,
  `key_name` text,
  `key_group` text,
  PRIMARY KEY  (`key_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiattachment`
--

DROP TABLE IF EXISTS `xwikiattachment`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiattachment` (
  `XWA_ID` bigint(20) NOT NULL,
  `XWA_DOC_ID` bigint(20) default NULL,
  `XWA_FILENAME` varchar(255) NOT NULL,
  `XWA_SIZE` int(11) default NULL,
  `XWA_DATE` datetime NOT NULL,
  `XWA_AUTHOR` varchar(255) default NULL,
  `XWA_VERSION` varchar(255) NOT NULL,
  `XWA_COMMENT` varchar(255) default NULL,
  PRIMARY KEY  (`XWA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiattachment_archive`
--

DROP TABLE IF EXISTS `xwikiattachment_archive`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiattachment_archive` (
  `XWA_ID` bigint(20) NOT NULL,
  `XWA_ARCHIVE` mediumblob,
  PRIMARY KEY  (`XWA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiattachment_content`
--

DROP TABLE IF EXISTS `xwikiattachment_content`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiattachment_content` (
  `XWA_ID` bigint(20) NOT NULL,
  `XWA_CONTENT` mediumblob NOT NULL,
  PRIMARY KEY  (`XWA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiattrecyclebin`
--

DROP TABLE IF EXISTS `xwikiattrecyclebin`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiattrecyclebin` (
  `XDA_ID` bigint(20) NOT NULL auto_increment,
  `XDA_DOCID` bigint(20) NOT NULL,
  `XDA_FILENAME` varchar(255) NOT NULL,
  `XDA_DATE` datetime NOT NULL,
  `XDA_DOC_NAME` varchar(255) default NULL,
  `XDA_DELETER` varchar(255) default NULL,
  `XDA_XML` longtext NOT NULL,
  PRIMARY KEY  (`XDA_ID`),
  UNIQUE KEY `XDA_DOCID` (`XDA_DOCID`,`XDA_FILENAME`,`XDA_DATE`),
  KEY `xda_docid1` (`XDA_DOCID`),
  KEY `xda_doc_name` (`XDA_DOC_NAME`),
  KEY `xda_filename` (`XDA_FILENAME`),
  KEY `xda_date` (`XDA_DATE`),
  KEY `xda_deleter` (`XDA_DELETER`)
) ENGINE=MyISAM AUTO_INCREMENT=268 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikibooleanclasses`
--

DROP TABLE IF EXISTS `xwikibooleanclasses`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikibooleanclasses` (
  `XWN_ID` int(11) NOT NULL,
  `XWN_NAME` varchar(255) NOT NULL,
  `XWN_DISPLAYTYPE` varchar(20) default NULL,
  PRIMARY KEY  (`XWN_ID`,`XWN_NAME`),
  KEY `FK6D139D269159A4BC` (`XWN_ID`,`XWN_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiclasses`
--

DROP TABLE IF EXISTS `xwikiclasses`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiclasses` (
  `XWO_ID` int(11) NOT NULL,
  `XWO_NAME` varchar(255) NOT NULL,
  `XWO_CUSTOM_MAPPING` text,
  `XWO_CUSTOM_CLASS` varchar(255) default NULL,
  `XWO_VALIDATION_SCRIPT` varchar(255) default NULL,
  PRIMARY KEY  (`XWO_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiclassesprop`
--

DROP TABLE IF EXISTS `xwikiclassesprop`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiclassesprop` (
  `XWP_ID` int(11) NOT NULL,
  `XWP_NAME` varchar(255) NOT NULL,
  `XWP_PRETTYNAME` varchar(255) default NULL,
  `XWP_CLASSTYPE` varchar(255) default NULL,
  `XWP_UNMODIFIABLE` bit(1) default NULL,
  `XWP_NUMBER` int(11) default NULL,
  `XWP_CUSTOMDISPLAY` text,
  `XWP_VALIDATION_REGEXP` varchar(255) default NULL,
  PRIMARY KEY  (`XWP_ID`,`XWP_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikicomments`
--

DROP TABLE IF EXISTS `xwikicomments`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikicomments` (
  `XWC_ID` int(11) NOT NULL,
  `XWC_AUTHOR` varchar(255) default NULL,
  `XWC_HIGHLIGHT` text,
  `XWC_COMMENT` text,
  `XWP_REPLYTO` int(11) default NULL,
  `XWP_DATE` datetime default NULL,
  PRIMARY KEY  (`XWC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikidateclasses`
--

DROP TABLE IF EXISTS `xwikidateclasses`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikidateclasses` (
  `XWS_ID` int(11) NOT NULL,
  `XWS_NAME` varchar(255) NOT NULL,
  `XWS_SIZE` int(11) default NULL,
  `XWS_EMPTY_IS_TODAY` int(11) default NULL,
  `XWS_DATE_FORMAT` varchar(255) default NULL,
  PRIMARY KEY  (`XWS_ID`,`XWS_NAME`),
  KEY `FK14DA8B9099E425B2` (`XWS_ID`,`XWS_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikidates`
--

DROP TABLE IF EXISTS `xwikidates`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikidates` (
  `XWS_ID` int(11) NOT NULL,
  `XWS_NAME` varchar(255) NOT NULL,
  `XWS_VALUE` datetime default NULL,
  PRIMARY KEY  (`XWS_ID`,`XWS_NAME`),
  KEY `FKDEAEAB5D3433FD87` (`XWS_ID`,`XWS_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikidblistclasses`
--

DROP TABLE IF EXISTS `xwikidblistclasses`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikidblistclasses` (
  `XWL_ID` int(11) NOT NULL,
  `XWL_NAME` varchar(255) NOT NULL,
  `XWL_DISPLAYTYPE` varchar(20) default NULL,
  `XWL_MULTISELECT` bit(1) default NULL,
  `XWL_SIZE` int(11) default NULL,
  `XWL_RELATIONAL` bit(1) default NULL,
  `XWL_SQL` text,
  PRIMARY KEY  (`XWL_ID`,`XWL_NAME`),
  KEY `FK5A4B5F628DEF0AC0` (`XWL_ID`,`XWL_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikidbversion`
--

DROP TABLE IF EXISTS `xwikidbversion`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikidbversion` (
  `XWV_VERSION` int(11) NOT NULL,
  PRIMARY KEY  (`XWV_VERSION`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikidoc`
--

DROP TABLE IF EXISTS `xwikidoc`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikidoc` (
  `XWD_ID` bigint(20) NOT NULL,
  `XWD_FULLNAME` varchar(255) NOT NULL,
  `XWD_NAME` varchar(255) NOT NULL,
  `XWD_TITLE` varchar(255) NOT NULL,
  `XWD_LANGUAGE` varchar(5) default NULL,
  `XWD_DEFAULT_LANGUAGE` varchar(5) default NULL,
  `XWD_TRANSLATION` int(11) NOT NULL,
  `XWD_DATE` datetime NOT NULL,
  `XWD_CONTENT_UPDATE_DATE` datetime NOT NULL,
  `XWD_CREATION_DATE` datetime NOT NULL,
  `XWD_AUTHOR` varchar(255) NOT NULL,
  `XWD_CONTENT_AUTHOR` varchar(255) NOT NULL,
  `XWD_CREATOR` varchar(255) NOT NULL,
  `XWD_WEB` varchar(255) NOT NULL,
  `XWD_CONTENT` mediumtext NOT NULL,
  `XWD_VERSION` varchar(255) NOT NULL,
  `XWD_CUSTOM_CLASS` varchar(255) NOT NULL,
  `XWD_PARENT` text NOT NULL,
  `XWD_CLASS_XML` text,
  `XWD_ELEMENTS` int(11) default NULL,
  `XWD_DEFAULT_TEMPLATE` varchar(255) NOT NULL,
  `XWD_VALIDATION_SCRIPT` varchar(255) NOT NULL,
  `XWD_COMMENT` text NOT NULL,
  `XWD_MINOREDIT` bit(1) NOT NULL,
  `XWD_SYNTAX_ID` varchar(50) default NULL,
  `XWD_HIDDEN` bit(1) default NULL,
  PRIMARY KEY  (`XWD_ID`),
  KEY `xwd_name` (`XWD_NAME`),
  KEY `xwd_fullname` (`XWD_FULLNAME`),
  KEY `xwd_web` (`XWD_WEB`),
  KEY `xwd_creation_date` (`XWD_CREATION_DATE`),
  KEY `xwd_date` (`XWD_DATE`),
  KEY `xwd_content_update_date` (`XWD_CONTENT_UPDATE_DATE`),
  KEY `xwd_content_author` (`XWD_CONTENT_AUTHOR`),
  KEY `xwd_author` (`XWD_AUTHOR`),
  KEY `xwd_creator` (`XWD_CREATOR`),
  KEY `xwd_language` (`XWD_LANGUAGE`),
  KEY `xwd_default_language` (`XWD_DEFAULT_LANGUAGE`),
  KEY `xwd_title` (`XWD_TITLE`),
  KEY `xwd_parent` (`XWD_PARENT`(50)),
  KEY `xwd_class_xml` (`XWD_CLASS_XML`(20))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikidoubles`
--

DROP TABLE IF EXISTS `xwikidoubles`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikidoubles` (
  `XWD_ID` int(11) NOT NULL,
  `XWD_NAME` varchar(255) NOT NULL,
  `XWD_VALUE` double default NULL,
  PRIMARY KEY  (`XWD_ID`,`XWD_NAME`),
  KEY `FK5A1CD9A1A947AA5` (`XWD_ID`,`XWD_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikifloats`
--

DROP TABLE IF EXISTS `xwikifloats`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikifloats` (
  `XWF_ID` int(11) NOT NULL,
  `XWF_NAME` varchar(255) NOT NULL,
  `XWF_VALUE` float default NULL,
  PRIMARY KEY  (`XWF_ID`,`XWF_NAME`),
  KEY `FKFB291FBF1DFF14A1` (`XWF_ID`,`XWF_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiintegers`
--

DROP TABLE IF EXISTS `xwikiintegers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiintegers` (
  `XWI_ID` int(11) NOT NULL,
  `XWI_NAME` varchar(255) NOT NULL,
  `XWI_VALUE` int(11) default NULL,
  PRIMARY KEY  (`XWI_ID`,`XWI_NAME`),
  KEY `FK7F8AB31D231EFB9B` (`XWI_ID`,`XWI_NAME`),
  KEY `xwi_value` (`XWI_VALUE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikilargestrings`
--

DROP TABLE IF EXISTS `xwikilargestrings`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikilargestrings` (
  `XWL_ID` int(11) NOT NULL,
  `XWL_NAME` varchar(255) NOT NULL,
  `XWL_VALUE` text,
  PRIMARY KEY  (`XWL_ID`,`XWL_NAME`),
  KEY `FK6661970F283EE295` (`XWL_ID`,`XWL_NAME`),
  KEY `xwl_value` (`XWL_VALUE`(50))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikilinks`
--

DROP TABLE IF EXISTS `xwikilinks`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikilinks` (
  `XWL_DOC_ID` bigint(20) NOT NULL,
  `XWL_LINK` varchar(255) NOT NULL,
  `XWL_FULLNAME` varchar(255) default NULL,
  PRIMARY KEY  (`XWL_DOC_ID`,`XWL_LINK`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikilistitems`
--

DROP TABLE IF EXISTS `xwikilistitems`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikilistitems` (
  `XWL_ID` int(11) NOT NULL,
  `XWL_NAME` varchar(255) NOT NULL,
  `XWL_VALUE` varchar(255) default NULL,
  `XWL_NUMBER` int(11) NOT NULL,
  PRIMARY KEY  (`XWL_ID`,`XWL_NAME`,`XWL_NUMBER`),
  KEY `FKC0862BA3FB72A11` (`XWL_ID`,`XWL_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikilists`
--

DROP TABLE IF EXISTS `xwikilists`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikilists` (
  `XWL_ID` int(11) NOT NULL,
  `XWL_NAME` varchar(255) NOT NULL,
  PRIMARY KEY  (`XWL_ID`,`XWL_NAME`),
  KEY `FKDF23086D283EE295` (`XWL_ID`,`XWL_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikilock`
--

DROP TABLE IF EXISTS `xwikilock`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikilock` (
  `XWL_DOC_ID` bigint(20) NOT NULL,
  `XWL_AUTHOR` varchar(255) default NULL,
  `XWL_DATE` datetime NOT NULL,
  PRIMARY KEY  (`XWL_DOC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikilongs`
--

DROP TABLE IF EXISTS `xwikilongs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikilongs` (
  `XWL_ID` int(11) NOT NULL,
  `XWL_NAME` varchar(255) NOT NULL,
  `XWL_VALUE` bigint(20) default NULL,
  PRIMARY KEY  (`XWL_ID`,`XWL_NAME`),
  KEY `FKDF25AE4F283EE295` (`XWL_ID`,`XWL_NAME`),
  KEY `xwl_value` (`XWL_VALUE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikinumberclasses`
--

DROP TABLE IF EXISTS `xwikinumberclasses`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikinumberclasses` (
  `XWN_ID` int(11) NOT NULL,
  `XWN_NAME` varchar(255) NOT NULL,
  `XWN_SIZE` int(11) default NULL,
  `XWN_NUMBERTYPE` varchar(20) default NULL,
  PRIMARY KEY  (`XWN_ID`,`XWN_NAME`),
  KEY `FK38FB15959159A4BC` (`XWN_ID`,`XWN_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiobjects`
--

DROP TABLE IF EXISTS `xwikiobjects`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiobjects` (
  `XWO_ID` int(11) NOT NULL,
  `XWO_NUMBER` int(11) default NULL,
  `XWO_NAME` varchar(255) NOT NULL,
  `XWO_CLASSNAME` varchar(255) NOT NULL,
  `XWO_GUID` varchar(255) default NULL,
  PRIMARY KEY  (`XWO_ID`),
  KEY `xwo_name` (`XWO_NAME`),
  KEY `xwo_classname` (`XWO_CLASSNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikipreferences`
--

DROP TABLE IF EXISTS `xwikipreferences`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikipreferences` (
  `XWP_ID` int(11) NOT NULL,
  `XWP_LANGUAGE` varchar(255) default NULL,
  `XWP_DEFAULT_LANGUAGE` varchar(255) default NULL,
  `XWP_MULTI_LINGUAL` int(11) default NULL,
  `XWP_AUTHENTICATE_EDIT` int(11) default NULL,
  `XWP_AUTHENTICATE_VIEW` int(11) default NULL,
  `XWP_AUTH_ACTIVE_CHECK` int(11) default NULL,
  `XWP_BACKLINKS` int(11) default NULL,
  `XWP_SKIN` varchar(255) default NULL,
  `XWP_STYLESHEET` varchar(255) default NULL,
  `XWP_STYLESHEETS` varchar(255) default NULL,
  `XWP_EDITOR` varchar(255) default NULL,
  `XWP_EDITBOX_WIDTH` varchar(255) default NULL,
  `XWP_EDITBOX_HEIGHT` varchar(255) default NULL,
  `XWP_WEBCOPYRIGHT` varchar(255) default NULL,
  `XWP_TITLE` varchar(255) default NULL,
  `XWP_VERSION` varchar(255) default NULL,
  `XWP_MENU` text,
  `XWP_META` text,
  `XWP_USE_EMAIL_VERIFICATION` int(11) default NULL,
  `XWP_SMTP_SERVER` varchar(255) default NULL,
  `XWP_ADMIN_EMAIL` varchar(255) default NULL,
  `XWP_VALIDATION_EMAIL_CONTENT` text,
  `XWP_CONFIRMATION_EMAIL_CONTENT` text,
  `XWP_INVITATION_EMAIL_CONTENT` text,
  `XWP_MACROS_LANGUAGE` varchar(255) default NULL,
  `XWP_MACROS_VELOCITY` varchar(255) default NULL,
  `XWP_MACROS_GROOVY` varchar(255) default NULL,
  `XWP_MACROS_WIKI2` varchar(255) default NULL,
  `XWP_MACROS_MAPPING` text,
  `XWP_NOTIFICATION_PAGES` varchar(255) default NULL,
  `XWP_LEFT_PANELS` text,
  `XWP_RIGHT_PANELS` text,
  `XWP_SHOW_LEFT_PANELS` int(11) default NULL,
  `XWP_SHOW_RIGHT_PANELS` int(11) default NULL,
  `XWP_PAGE_WIDTH` varchar(255) default NULL,
  `XWP_LANGUAGES` varchar(255) default NULL,
  `XWP_REGISTRATION_ANONYMOUS` varchar(255) default NULL,
  `XWP_REGISTRATION_REGISTERED` varchar(255) default NULL,
  `XWP_EDIT_ANONYMOUS` varchar(255) default NULL,
  `XWP_EDIT_REGISTERED` varchar(255) default NULL,
  `XWP_COMMENT_ANONYMOUS` varchar(255) default NULL,
  `XWP_COMMENT_REGISTERED` varchar(255) default NULL,
  `XWP_DOCUMENT_BUNDLES` varchar(255) default NULL,
  PRIMARY KEY  (`XWP_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikiproperties`
--

DROP TABLE IF EXISTS `xwikiproperties`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikiproperties` (
  `XWP_ID` int(11) NOT NULL,
  `XWP_NAME` varchar(255) NOT NULL,
  `XWP_CLASSTYPE` varchar(255) default NULL,
  PRIMARY KEY  (`XWP_ID`,`XWP_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikircs`
--

DROP TABLE IF EXISTS `xwikircs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikircs` (
  `XWR_DOCID` bigint(20) NOT NULL,
  `XWR_VERSION1` int(11) NOT NULL,
  `XWR_VERSION2` int(11) NOT NULL,
  `XWR_DATE` datetime NOT NULL,
  `XWR_COMMENT` text NOT NULL,
  `XWR_AUTHOR` varchar(255) NOT NULL,
  `XWR_ISDIFF` bit(1) default NULL,
  `XWR_PATCH` longtext,
  PRIMARY KEY  (`XWR_DOCID`,`XWR_VERSION1`,`XWR_VERSION2`),
  KEY `xwr_isdiff` (`XWR_ISDIFF`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikirecyclebin`
--

DROP TABLE IF EXISTS `xwikirecyclebin`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikirecyclebin` (
  `XDD_ID` bigint(20) NOT NULL auto_increment,
  `XDD_FULLNAME` varchar(255) NOT NULL,
  `XDD_LANGUAGE` varchar(5) NOT NULL,
  `XDD_DATE` datetime NOT NULL,
  `XDD_DELETER` varchar(255) default NULL,
  `XDD_XML` longtext NOT NULL,
  PRIMARY KEY  (`XDD_ID`),
  UNIQUE KEY `XDD_FULLNAME` (`XDD_FULLNAME`,`XDD_LANGUAGE`,`XDD_DATE`),
  KEY `xdd_fullname1` (`XDD_FULLNAME`),
  KEY `xdd_language` (`XDD_LANGUAGE`),
  KEY `xdd_date` (`XDD_DATE`),
  KEY `xdd_deleter` (`XDD_DELETER`)
) ENGINE=MyISAM AUTO_INCREMENT=517 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikislistclasses`
--

DROP TABLE IF EXISTS `xwikislistclasses`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikislistclasses` (
  `XWL_ID` int(11) NOT NULL,
  `XWL_NAME` varchar(255) NOT NULL,
  `XWL_DISPLAYTYPE` varchar(20) default NULL,
  `XWL_MULTISELECT` bit(1) default NULL,
  `XWL_SIZE` int(11) default NULL,
  `XWL_RELATIONAL` bit(1) default NULL,
  `XWL_VALUES` text,
  PRIMARY KEY  (`XWL_ID`,`XWL_NAME`),
  KEY `FK17ED3B9D8DEF0AC0` (`XWL_ID`,`XWL_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikistatsdoc`
--

DROP TABLE IF EXISTS `xwikistatsdoc`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikistatsdoc` (
  `XWS_ID` int(11) NOT NULL,
  `XWS_NUMBER` int(11) default NULL,
  `XWS_NAME` varchar(255) NOT NULL,
  `XWS_CLASSNAME` varchar(255) NOT NULL,
  `XWS_ACTION` varchar(255) NOT NULL,
  `XWS_PAGE_VIEWS` int(11) default NULL,
  `XWS_UNIQUE_VISITORS` int(11) default NULL,
  `XWS_PERIOD` int(11) default NULL,
  `XWS_VISITS` int(11) default NULL,
  PRIMARY KEY  (`XWS_ID`),
  KEY `xws_name` (`XWS_NAME`),
  KEY `xws_number` (`XWS_NUMBER`),
  KEY `xws_classname` (`XWS_CLASSNAME`),
  KEY `xws_action` (`XWS_ACTION`),
  KEY `xws_page_views` (`XWS_PAGE_VIEWS`),
  KEY `xws_unique_visitors` (`XWS_UNIQUE_VISITORS`),
  KEY `xws_period` (`XWS_PERIOD`),
  KEY `xws_visits` (`XWS_VISITS`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikistatsreferer`
--

DROP TABLE IF EXISTS `xwikistatsreferer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikistatsreferer` (
  `XWR_ID` int(11) NOT NULL,
  `XWR_NUMBER` int(11) default NULL,
  `XWR_NAME` varchar(255) NOT NULL,
  `XWR_CLASSNAME` varchar(255) NOT NULL,
  `XWR_REFERER` text NOT NULL,
  `XWR_PAGE_VIEWS` int(11) default NULL,
  `XWR_PERIOD` int(11) default NULL,
  PRIMARY KEY  (`XWR_ID`),
  KEY `xwr_number` (`XWR_NUMBER`),
  KEY `xwr_name` (`XWR_NAME`),
  KEY `xwr_classname` (`XWR_CLASSNAME`),
  KEY `xwr_referer` (`XWR_REFERER`(50)),
  KEY `xwr_page_views` (`XWR_PAGE_VIEWS`),
  KEY `xwr_period` (`XWR_PERIOD`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikistatsvisit`
--

DROP TABLE IF EXISTS `xwikistatsvisit`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikistatsvisit` (
  `XWV_ID` int(11) NOT NULL,
  `XWV_NUMBER` int(11) default NULL,
  `XWV_NAME` varchar(255) NOT NULL,
  `XWV_CLASSNAME` varchar(255) NOT NULL,
  `XWV_IP` varchar(255) NOT NULL,
  `XWV_USER_AGENT` text NOT NULL,
  `XWV_COOKIE` text NOT NULL,
  `XWV_UNIQUE_ID` varchar(255) NOT NULL,
  `XWV_PAGE_VIEWS` int(11) default NULL,
  `XWV_PAGE_SAVES` int(11) default NULL,
  `XWV_DOWNLOADS` int(11) default NULL,
  `XWV_START_DATE` datetime default NULL,
  `XWV_END_DATE` datetime default NULL,
  PRIMARY KEY  (`XWV_ID`),
  KEY `xwv_start_date` (`XWV_START_DATE`),
  KEY `xwv_name` (`XWV_NAME`),
  KEY `xwv_page_views` (`XWV_PAGE_VIEWS`),
  KEY `xwv_page_saves` (`XWV_PAGE_SAVES`),
  KEY `xwv_downloads` (`XWV_DOWNLOADS`),
  KEY `xwv_end_date` (`XWV_END_DATE`),
  KEY `xwv_ip` (`XWV_IP`),
  KEY `xwv_user_agent` (`XWV_USER_AGENT`(255)),
  KEY `xwv_cookie` (`XWV_COOKIE`(255)),
  KEY `xwv_unique_id` (`XWV_UNIQUE_ID`),
  KEY `xwv_classname` (`XWV_CLASSNAME`),
  KEY `xwv_number` (`XWV_NUMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikistringclasses`
--

DROP TABLE IF EXISTS `xwikistringclasses`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikistringclasses` (
  `XWS_ID` int(11) NOT NULL,
  `XWS_NAME` varchar(255) NOT NULL,
  `XWS_SIZE` int(11) default NULL,
  `XWS_ROWS` int(11) default NULL,
  PRIMARY KEY  (`XWS_ID`,`XWS_NAME`),
  KEY `FK300D1FCD99E425B2` (`XWS_ID`,`XWS_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `xwikistrings`
--

DROP TABLE IF EXISTS `xwikistrings`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `xwikistrings` (
  `XWS_ID` int(11) NOT NULL,
  `XWS_NAME` varchar(255) NOT NULL,
  `XWS_VALUE` varchar(255) default NULL,
  PRIMARY KEY  (`XWS_ID`,`XWS_NAME`),
  KEY `FK2780715A3433FD87` (`XWS_ID`,`XWS_NAME`),
  KEY `xws_value` (`XWS_VALUE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
/*!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 2010-09-30 17:25:17
