-- MySQL dump 10.13  Distrib 5.5.62, for Win64 (AMD64)
--
-- Host: 127.0.0.1    Database: xwiki
-- ------------------------------------------------------
-- Server version	5.5.5-10.9.2-MariaDB

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

DROP TABLE IF EXISTS `DATABASECHANGELOG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DATABASECHANGELOG` (
  `ID` varchar(255) NOT NULL,
  `AUTHOR` varchar(255) NOT NULL,
  `FILENAME` varchar(255) NOT NULL,
  `DATEEXECUTED` datetime NOT NULL,
  `ORDEREXECUTED` int(11) NOT NULL,
  `EXECTYPE` varchar(10) NOT NULL,
  `MD5SUM` varchar(35) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `COMMENTS` varchar(255) DEFAULT NULL,
  `TAG` varchar(255) DEFAULT NULL,
  `LIQUIBASE` varchar(20) DEFAULT NULL,
  `CONTEXTS` varchar(255) DEFAULT NULL,
  `LABELS` varchar(255) DEFAULT NULL,
  `DEPLOYMENT_ID` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DATABASECHANGELOGLOCK`
--

DROP TABLE IF EXISTS `DATABASECHANGELOGLOCK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DATABASECHANGELOGLOCK` (
  `ID` int(11) NOT NULL,
  `LOCKED` bit(1) NOT NULL,
  `LOCKGRANTED` datetime DEFAULT NULL,
  `LOCKEDBY` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `activitystream_events`
--

DROP TABLE IF EXISTS `activitystream_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activitystream_events` (
  `ase_eventid` varchar(48) NOT NULL,
  `ase_requestid` varchar(48) DEFAULT NULL,
  `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_hidden` bit(1) DEFAULT NULL,
  `ase_url` longtext DEFAULT NULL,
  `ase_title` longtext DEFAULT NULL,
  `ase_body` longtext DEFAULT NULL,
  `ase_version` varchar(30) DEFAULT NULL,
  `ase_param1` longtext DEFAULT NULL,
  `ase_param2` longtext DEFAULT NULL,
  `ase_param3` longtext DEFAULT NULL,
  `ase_param4` longtext DEFAULT NULL,
  `ase_param5` longtext DEFAULT NULL,
  PRIMARY KEY (`ase_eventid`),
  KEY `EVENT_TYPE` (`ase_type`),
  KEY `EVENT_PRIORITY` (`ase_priority`),
  KEY `EVENT_WIKI` (`ase_wiki`),
  KEY `EVENT_DATE` (`ase_date`),
  KEY `EVENT_PAGE` (`ase_page`),
  KEY `EVENT_USER` (`ase_user`),
  KEY `EVENT_SPACE` (`ase_space`),
  KEY `EVENT_STREAM` (`ase_stream`),
  KEY `EVENT_APP` (`ase_application`),
  KEY `EVENT_HIDDEN` (`ase_hidden`),
  KEY `EVENT_REQUESTID` (`ase_requestid`),
  KEY `ase_page_date` (`ase_page`,`ase_date`),
  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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `feeds_aggregatorgroup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feeds_aggregatorgroup` (
  `agg_id` int(11) NOT NULL,
  `agg_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`agg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `feeds_aggregatorurl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feeds_aggregatorurl` (
  `agg_id` bigint(20) NOT NULL,
  `agg_name` longtext DEFAULT NULL,
  `agg_url` longtext DEFAULT NULL,
  `agg_date` datetime DEFAULT NULL,
  `agg_nb` int(11) DEFAULT NULL,
  PRIMARY KEY (`agg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `feeds_aggregatorurlgroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feeds_aggregatorurlgroups` (
  `agl_id` bigint(20) NOT NULL,
  `agl_value` varchar(255) DEFAULT NULL,
  `agl_number` int(11) NOT NULL,
  PRIMARY KEY (`agl_id`,`agl_number`),
  KEY `FK7B845B068E772CC` (`agl_id`),
  CONSTRAINT `FK7B845B068E772CC` FOREIGN KEY (`agl_id`) REFERENCES `feeds_aggregatorurl` (`agg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `feeds_feedentry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feeds_feedentry` (
  `fee_id` bigint(20) NOT NULL,
  `fee_title` longtext DEFAULT NULL,
  `fee_author` longtext DEFAULT NULL,
  `fee_feedurl` longtext DEFAULT NULL,
  `fee_feedname` longtext DEFAULT NULL,
  `fee_url` longtext DEFAULT NULL,
  `fee_category` longtext DEFAULT NULL,
  `fee_content` longtext DEFAULT NULL,
  `fee_fullcontent` longtext DEFAULT NULL,
  `fee_xml` longtext DEFAULT NULL,
  `fee_date` datetime DEFAULT NULL,
  `fee_flag` int(11) DEFAULT 0,
  `fee_read` int(11) DEFAULT 0,
  PRIMARY KEY (`fee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `feeds_feedentrytags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feeds_feedentrytags` (
  `fet_id` bigint(20) NOT NULL,
  `fet_value` varchar(255) DEFAULT NULL,
  `fet_number` int(11) NOT NULL,
  PRIMARY KEY (`fet_id`,`fet_number`),
  KEY `FKBE0037834855150F` (`fet_id`),
  CONSTRAINT `FKBE0037834855150F` FOREIGN KEY (`fet_id`) REFERENCES `feeds_feedentry` (`fee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `feeds_keyword`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feeds_keyword` (
  `key_id` int(11) NOT NULL,
  `key_name` varchar(255) DEFAULT NULL,
  `key_group` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`key_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mailsender_events`
--

DROP TABLE IF EXISTS `mailsender_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailsender_events` (
  `mail_id` varchar(255) NOT NULL,
  `mail_batchId` varchar(255) NOT NULL,
  `mail_state` varchar(255) NOT NULL,
  `mail_date` datetime NOT NULL,
  `mail_recipients` varchar(2000) NOT NULL,
  `mail_type` varchar(255) DEFAULT NULL,
  `mail_errorSummary` varchar(2000) DEFAULT NULL,
  `mail_errorDescription` longtext DEFAULT NULL,
  `mail_wiki` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mail_id`),
  KEY `MAIL_TYPE` (`mail_type`),
  KEY `MAIL_STATE` (`mail_state`),
  KEY `MAIL_WIKI` (`mail_wiki`),
  KEY `MAIL_BATCH_ID` (`mail_batchId`),
  KEY `MAIL_DATE` (`mail_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikiattachment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikiattachment` (
  `XWA_ID` bigint(20) NOT NULL,
  `XWA_DOC_ID` bigint(20) DEFAULT NULL,
  `XWA_FILENAME` varchar(768) NOT NULL,
  `XWA_SIZE` int(11) DEFAULT NULL,
  `XWA_DATE` datetime NOT NULL,
  `XWA_AUTHOR` varchar(768) DEFAULT NULL,
  `XWA_VERSION` varchar(255) NOT NULL,
  `XWA_COMMENT` varchar(1023) DEFAULT NULL,
  PRIMARY KEY (`XWA_ID`),
  KEY `ATT_DATE` (`XWA_DATE`),
  KEY `ATT_DOC_ID` (`XWA_DOC_ID`),
  KEY `ATT_AUTHOR` (`XWA_AUTHOR`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikiattachment_archive`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikiattachment_archive` (
  `XWA_ID` bigint(20) NOT NULL,
  `XWA_ARCHIVE` longblob DEFAULT NULL,
  PRIMARY KEY (`XWA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikiattachment_content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikiattachment_content` (
  `XWA_ID` bigint(20) NOT NULL,
  `XWA_CONTENT` longblob NOT NULL,
  PRIMARY KEY (`XWA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikiattrecyclebin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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(768) NOT NULL,
  `XDA_DATE` datetime NOT NULL,
  `XDA_DOC_NAME` varchar(768) DEFAULT NULL,
  `XDA_DELETER` varchar(768) DEFAULT NULL,
  `XDA_XML` longtext NOT NULL,
  PRIMARY KEY (`XDA_ID`),
  KEY `XDA_DOC_NAME` (`XDA_DOC_NAME`),
  KEY `XDA_FILENAME` (`XDA_FILENAME`),
  KEY `XDA_DELETER` (`XDA_DELETER`),
  KEY `XDA_DATE` (`XDA_DATE`),
  KEY `xda_docid1` (`XDA_DOCID`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikicomments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikicomments` (
  `XWC_ID` bigint(20) NOT NULL,
  `XWC_AUTHOR` varchar(255) DEFAULT NULL,
  `XWC_HIGHLIGHT` longtext DEFAULT NULL,
  `XWC_COMMENT` longtext DEFAULT NULL,
  `XWP_REPLYTO` int(11) DEFAULT NULL,
  `XWP_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`XWC_ID`),
  KEY `COMMENT_DATE` (`XWP_DATE`),
  KEY `COMMENT_AUTHOR` (`XWC_AUTHOR`),
  KEY `COMMENT_REPLYTO` (`XWP_REPLYTO`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikidates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikidates` (
  `XWS_ID` bigint(20) 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`),
  KEY `XWDATE_NAME` (`XWS_NAME`),
  KEY `XWDATE_VALUE` (`XWS_VALUE`),
  CONSTRAINT `FKDEAEAB5D3433FD87` FOREIGN KEY (`XWS_ID`, `XWS_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikidbversion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikidbversion` (
  `XWV_VERSION` int(11) NOT NULL,
  PRIMARY KEY (`XWV_VERSION`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikidoc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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` longtext NOT NULL,
  `XWD_VERSION` varchar(255) NOT NULL,
  `XWD_CUSTOM_CLASS` varchar(255) NOT NULL,
  `XWD_PARENT` varchar(511) NOT NULL,
  `XWD_CLASS_XML` longtext DEFAULT NULL,
  `XWD_ELEMENTS` int(11) NOT NULL,
  `XWD_DEFAULT_TEMPLATE` varchar(255) NOT NULL,
  `XWD_VALIDATION_SCRIPT` varchar(255) NOT NULL,
  `XWD_COMMENT` varchar(1023) NOT NULL,
  `XWD_MINOREDIT` bit(1) NOT NULL,
  `XWD_SYNTAX_ID` varchar(50) DEFAULT NULL,
  `XWD_HIDDEN` bit(1) NOT NULL,
  PRIMARY KEY (`XWD_ID`),
  KEY `DOC_AUTHOR` (`XWD_AUTHOR`),
  KEY `DOC_NAME` (`XWD_NAME`),
  KEY `DOC_CREATION_DATE` (`XWD_CREATION_DATE`),
  KEY `DOC_CREATOR` (`XWD_CREATOR`),
  KEY `DOC_CONTENT_UPDATE_DATE` (`XWD_CONTENT_UPDATE_DATE`),
  KEY `DOC_SPACE` (`XWD_WEB`),
  KEY `DOC_TITLE` (`XWD_TITLE`),
  KEY `DOC_CONTENT_AUTHOR` (`XWD_CONTENT_AUTHOR`),
  KEY `DOC_DATE` (`XWD_DATE`),
  KEY `DOC_LANGUAGE` (`XWD_LANGUAGE`),
  KEY `DOC_FULLNAME` (`XWD_FULLNAME`),
  KEY `DOC_MINOREDIT` (`XWD_MINOREDIT`),
  KEY `DOC_HIDDEN` (`XWD_HIDDEN`),
  KEY `DOC_DEFAULT_LANGUAGE` (`XWD_DEFAULT_LANGUAGE`),
  KEY `xwd_parent` (`XWD_PARENT`(50)),
  KEY `xwd_class_xml` (`XWD_CLASS_XML`(20))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikidoubles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikidoubles` (
  `XWD_ID` bigint(20) 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`),
  KEY `XWDOUBLE_NAME` (`XWD_NAME`),
  KEY `XWDOUBLE_VALUE` (`XWD_VALUE`),
  CONSTRAINT `FK5A1CD9A1A947AA5` FOREIGN KEY (`XWD_ID`, `XWD_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikifloats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikifloats` (
  `XWF_ID` bigint(20) 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`),
  KEY `XWFLOAT_VALUE` (`XWF_VALUE`),
  KEY `XWFLOAT_NAME` (`XWF_NAME`),
  CONSTRAINT `FKFB291FBF1DFF14A1` FOREIGN KEY (`XWF_ID`, `XWF_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `xwikiid`
--

DROP TABLE IF EXISTS `xwikiid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikiid` (
  `XWI_ID` varchar(255) NOT NULL,
  PRIMARY KEY (`XWI_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikiintegers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikiintegers` (
  `XWI_ID` bigint(20) 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 `XWINT_NAME` (`XWI_NAME`),
  KEY `XWINT_VALUE` (`XWI_VALUE`),
  CONSTRAINT `FK7F8AB31D231EFB9B` FOREIGN KEY (`XWI_ID`, `XWI_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikilargestrings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikilargestrings` (
  `XWL_ID` bigint(20) NOT NULL,
  `XWL_NAME` varchar(255) NOT NULL,
  `XWL_VALUE` longtext DEFAULT NULL,
  PRIMARY KEY (`XWL_ID`,`XWL_NAME`),
  KEY `FK6661970F283EE295` (`XWL_ID`,`XWL_NAME`),
  KEY `XWLS_NAME` (`XWL_NAME`),
  KEY `xwl_value` (`XWL_VALUE`(50)),
  CONSTRAINT `FK6661970F283EE295` FOREIGN KEY (`XWL_ID`, `XWL_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikilinks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikilinks` (
  `XWL_DOC_ID` bigint(20) NOT NULL,
  `XWL_LINK` varchar(766) NOT NULL,
  `XWL_FULLNAME` varchar(768) DEFAULT NULL,
  PRIMARY KEY (`XWL_DOC_ID`,`XWL_LINK`),
  KEY `XWLNK_LINK` (`XWL_LINK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikilistitems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikilistitems` (
  `XWL_ID` bigint(20) 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`),
  KEY `XWLI_VALUE` (`XWL_VALUE`),
  KEY `XWLI_NAME` (`XWL_NAME`),
  CONSTRAINT `FKC0862BA3FB72A11` FOREIGN KEY (`XWL_ID`, `XWL_NAME`) REFERENCES `xwikilists` (`XWL_ID`, `XWL_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikilists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikilists` (
  `XWL_ID` bigint(20) NOT NULL,
  `XWL_NAME` varchar(255) NOT NULL,
  PRIMARY KEY (`XWL_ID`,`XWL_NAME`),
  KEY `FKDF23086D283EE295` (`XWL_ID`,`XWL_NAME`),
  KEY `XWLIST_NAME` (`XWL_NAME`),
  CONSTRAINT `FKDF23086D283EE295` FOREIGN KEY (`XWL_ID`, `XWL_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikilock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikilongs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikilongs` (
  `XWL_ID` bigint(20) 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 `XWLONG_NAME` (`XWL_NAME`),
  KEY `XWLONG_VALUE` (`XWL_VALUE`),
  CONSTRAINT `FKDF25AE4F283EE295` FOREIGN KEY (`XWL_ID`, `XWL_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikiobjects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikiobjects` (
  `XWO_ID` bigint(20) 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 `OBJ_NAME` (`XWO_NAME`),
  KEY `OBJ_CLASSNAME` (`XWO_CLASSNAME`),
  KEY `OBJ_NUMBER` (`XWO_NUMBER`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikipreferences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikipreferences` (
  `XWP_ID` bigint(20) 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_WEBCOPYRIGHT` varchar(255) DEFAULT NULL,
  `XWP_TITLE` varchar(255) DEFAULT NULL,
  `XWP_VERSION` varchar(255) DEFAULT NULL,
  `XWP_META` longtext DEFAULT NULL,
  `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` longtext DEFAULT NULL,
  `XWP_CONFIRMATION_EMAIL_CONTENT` longtext DEFAULT NULL,
  `XWP_INVITATION_EMAIL_CONTENT` longtext DEFAULT NULL,
  `XWP_LEFT_PANELS` longtext DEFAULT NULL,
  `XWP_RIGHT_PANELS` longtext DEFAULT NULL,
  `XWP_SHOW_LEFT_PANELS` int(11) DEFAULT NULL,
  `XWP_SHOW_RIGHT_PANELS` int(11) 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` longtext DEFAULT NULL,
  PRIMARY KEY (`XWP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikiproperties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikiproperties` (
  `XWP_ID` bigint(20) NOT NULL,
  `XWP_NAME` varchar(255) NOT NULL,
  `XWP_CLASSTYPE` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`XWP_ID`,`XWP_NAME`),
  KEY `PROP_NAME` (`XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikircs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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` varchar(1023) NOT NULL,
  `XWR_AUTHOR` varchar(255) NOT NULL,
  `XWR_ISDIFF` bit(1) DEFAULT NULL,
  `XWR_PATCH` longtext DEFAULT NULL,
  PRIMARY KEY (`XWR_DOCID`,`XWR_VERSION1`,`XWR_VERSION2`),
  KEY `REV_DATE` (`XWR_DATE`),
  KEY `REV_AUTHOR` (`XWR_AUTHOR`),
  KEY `REV_ISDIFF` (`XWR_ISDIFF`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikirecyclebin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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`),
  KEY `XDD_LANGUAGE` (`XDD_LANGUAGE`),
  KEY `XDD_DELETER` (`XDD_DELETER`),
  KEY `XDD_DATE` (`XDD_DATE`)
) ENGINE=InnoDB AUTO_INCREMENT=763 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikistatsdoc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikistatsdoc` (
  `XWS_ID` bigint(20) NOT NULL,
  `XWS_NUMBER` int(11) DEFAULT NULL,
  `XWS_NAME` varchar(768) NOT NULL,
  `XWS_CLASSNAME` varchar(255) DEFAULT 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 `XWDS_VISITS` (`XWS_VISITS`),
  KEY `XWDS_NAME` (`XWS_NAME`),
  KEY `XWDS_ACTION` (`XWS_ACTION`),
  KEY `XWDS_UNIQUE_VISITORS` (`XWS_UNIQUE_VISITORS`),
  KEY `XWDS_PERIOD` (`XWS_PERIOD`),
  KEY `XWDS_PAGE_VIEWS` (`XWS_PAGE_VIEWS`),
  KEY `xws_number` (`XWS_NUMBER`),
  KEY `xws_classname` (`XWS_CLASSNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikistatsreferer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikistatsreferer` (
  `XWR_ID` bigint(20) NOT NULL,
  `XWR_NUMBER` int(11) DEFAULT NULL,
  `XWR_NAME` varchar(768) NOT NULL,
  `XWR_CLASSNAME` varchar(255) DEFAULT NULL,
  `XWR_REFERER` longtext NOT NULL,
  `XWR_PAGE_VIEWS` int(11) DEFAULT NULL,
  `XWR_PERIOD` int(11) DEFAULT NULL,
  PRIMARY KEY (`XWR_ID`),
  KEY `XWRS_NAME` (`XWR_NAME`),
  KEY `XWRS_PERIOD` (`XWR_PERIOD`),
  KEY `XWRS_PAGE_VIEWS` (`XWR_PAGE_VIEWS`),
  KEY `xwr_number` (`XWR_NUMBER`),
  KEY `xwr_classname` (`XWR_CLASSNAME`),
  KEY `xwr_referer` (`XWR_REFERER`(50))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikistatsvisit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikistatsvisit` (
  `XWV_ID` bigint(20) NOT NULL,
  `XWV_NUMBER` int(11) DEFAULT NULL,
  `XWV_NAME` varchar(255) NOT NULL,
  `XWV_CLASSNAME` varchar(255) DEFAULT NULL,
  `XWV_IP` varchar(255) NOT NULL,
  `XWV_USER_AGENT` longtext NOT NULL,
  `XWV_COOKIE` longtext 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 `XWVS_END_DATE` (`XWV_END_DATE`),
  KEY `XWVS_UNIQUE_ID` (`XWV_UNIQUE_ID`),
  KEY `XWVS_PAGE_VIEWS` (`XWV_PAGE_VIEWS`),
  KEY `XWVS_START_DATE` (`XWV_START_DATE`),
  KEY `XWVS_NAME` (`XWV_NAME`),
  KEY `XWVS_PAGE_SAVES` (`XWV_PAGE_SAVES`),
  KEY `XWVS_DOWNLOADS` (`XWV_DOWNLOADS`),
  KEY `XWVS_IP` (`XWV_IP`),
  KEY `xwv_user_agent` (`XWV_USER_AGENT`(255)),
  KEY `xwv_classname` (`XWV_CLASSNAME`),
  KEY `xwv_number` (`XWV_NUMBER`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `xwikistrings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwikistrings` (
  `XWS_ID` bigint(20) NOT NULL,
  `XWS_NAME` varchar(255) NOT NULL,
  `XWS_VALUE` varchar(768) DEFAULT NULL,
  PRIMARY KEY (`XWS_ID`,`XWS_NAME`),
  KEY `FK2780715A3433FD87` (`XWS_ID`,`XWS_NAME`),
  KEY `XWSTR_NAME` (`XWS_NAME`),
  KEY `XWSTR_VALUE` (`XWS_VALUE`),
  CONSTRAINT `FK2780715A3433FD87` FOREIGN KEY (`XWS_ID`, `XWS_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping routines for database 'xwiki'
--
/*!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 2022-09-16 12:20:03