-- MySQL dump 10.13 Distrib 5.1.69, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: confluence -- ------------------------------------------------------ -- Server version 5.1.69-0ubuntu0.10.04.1-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 */; -- -- Current Database: `confluence` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `confluence` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */; USE `confluence`; -- -- Table structure for table `AO_187CCC_SIDEBAR_LINK` -- DROP TABLE IF EXISTS `AO_187CCC_SIDEBAR_LINK`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `AO_187CCC_SIDEBAR_LINK` ( `CATEGORY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_ICON_CLASS` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_TITLE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DEST_PAGE_ID` bigint(20) DEFAULT '0', `HARDCODED_URL` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HIDDEN` tinyint(1) DEFAULT NULL, `ID` int(11) NOT NULL AUTO_INCREMENT, `POSITION` int(11) DEFAULT '0', `SPACE_KEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `WEB_ITEM_KEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AO_9412A1_AONOTIFICATION` -- DROP TABLE IF EXISTS `AO_9412A1_AONOTIFICATION`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `AO_9412A1_AONOTIFICATION` ( `ACTION` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ACTION_ICON_URL` longtext COLLATE utf8_bin, `APPLICATION` varchar(255) COLLATE utf8_bin DEFAULT NULL, `APPLICATION_LINK_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATED` datetime DEFAULT NULL, `DESCRIPTION` longtext COLLATE utf8_bin, `ENTITY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `GLOBAL_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `GROUPING_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ICON_URL` longtext COLLATE utf8_bin, `ID` bigint(20) NOT NULL AUTO_INCREMENT, `ITEM_ICON_URL` longtext COLLATE utf8_bin, `ITEM_TITLE` longtext COLLATE utf8_bin, `ITEM_URL` longtext COLLATE utf8_bin, `METADATA` longtext COLLATE utf8_bin, `PINNED` tinyint(1) DEFAULT '0', `READ` tinyint(1) DEFAULT '0', `STATUS` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TITLE` longtext COLLATE utf8_bin, `UPDATED` datetime DEFAULT NULL, `URL` longtext COLLATE utf8_bin, `USER` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID`), KEY `index_ao_9412a1_aon1547032463` (`CREATED`), KEY `index_ao_9412a1_aon648423710` (`USER`), KEY `index_ao_9412a1_aon849931648` (`GLOBAL_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=9004 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AO_9412A1_AOREGISTRATION` -- DROP TABLE IF EXISTS `AO_9412A1_AOREGISTRATION`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `AO_9412A1_AOREGISTRATION` ( `DATA` longtext COLLATE utf8_bin, `ID` varchar(255) COLLATE utf8_bin NOT NULL, `UPDATED` datetime DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AO_9412A1_AOTASK` -- DROP TABLE IF EXISTS `AO_9412A1_AOTASK`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `AO_9412A1_AOTASK` ( `APPLICATION` varchar(255) COLLATE utf8_bin DEFAULT NULL, `APPLICATION_LINK_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATED` datetime DEFAULT NULL, `DESCRIPTION` longtext COLLATE utf8_bin, `ENTITY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `GLOBAL_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ID` bigint(20) NOT NULL AUTO_INCREMENT, `ITEM_ICON_URL` longtext COLLATE utf8_bin, `ITEM_TITLE` longtext COLLATE utf8_bin, `METADATA` longtext COLLATE utf8_bin, `STATUS` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TITLE` longtext COLLATE utf8_bin, `UPDATED` datetime DEFAULT NULL, `URL` longtext COLLATE utf8_bin, `USER` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID`), KEY `index_ao_9412a1_aotask_user` (`USER`), KEY `index_ao_9412a1_aot1465568358` (`GLOBAL_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AO_9412A1_AOUSER` -- DROP TABLE IF EXISTS `AO_9412A1_AOUSER`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `AO_9412A1_AOUSER` ( `CREATED` datetime DEFAULT NULL, `ID` bigint(20) NOT NULL AUTO_INCREMENT, `LAST_READ_NOTIFICATION_ID` bigint(20) DEFAULT '0', `TASK_ORDERING` longtext COLLATE utf8_bin, `UPDATED` datetime DEFAULT NULL, `USERNAME` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `U_AO_9412A1_AOUSER_USERNAME` (`USERNAME`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AO_9412A1_USER_APP_LINK` -- DROP TABLE IF EXISTS `AO_9412A1_USER_APP_LINK`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `AO_9412A1_USER_APP_LINK` ( `APPLICATION_LINK_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `AUTH_VERIFIED` tinyint(1) DEFAULT NULL, `CREATED` datetime DEFAULT NULL, `ID` bigint(20) NOT NULL AUTO_INCREMENT, `UPDATED` datetime DEFAULT NULL, `USER_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `index_ao_9412a1_use1222319987` (`USER_ID`), KEY `index_ao_9412a1_use643533071` (`APPLICATION_LINK_ID`), CONSTRAINT `fk_ao_9412a1_user_app_link_user_id` FOREIGN KEY (`USER_ID`) REFERENCES `AO_9412A1_AOUSER` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ATTACHMENTDATA` -- DROP TABLE IF EXISTS `ATTACHMENTDATA`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ATTACHMENTDATA` ( `ATTACHMENTDATAID` bigint(20) NOT NULL, `ATTVERSION` int(11) NOT NULL, `DATA` longblob, `ATTACHMENTID` bigint(20) NOT NULL, PRIMARY KEY (`ATTACHMENTDATAID`), UNIQUE KEY `ad_unique_attachmentid` (`ATTACHMENTID`), KEY `attch_data_idx` (`ATTACHMENTID`), KEY `attch_idver_idx` (`ATTVERSION`,`ATTACHMENTID`), CONSTRAINT `FK9DC3E34D34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `ATTACHMENTS` (`ATTACHMENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ATTACHMENTS` -- DROP TABLE IF EXISTS `ATTACHMENTS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ATTACHMENTS` ( `ATTACHMENTID` bigint(20) NOT NULL, `TITLE` varchar(255) COLLATE utf8_bin NOT NULL, `CONTENTTYPE` varchar(255) COLLATE utf8_bin NOT NULL, `PAGEID` bigint(20) NOT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, `FILESIZE` bigint(20) DEFAULT NULL, `ATTACHMENT_COMMENT` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ATTVERSION` int(11) DEFAULT NULL, `PREVVER` bigint(20) DEFAULT NULL, PRIMARY KEY (`ATTACHMENTID`), KEY `att_pageid_idx` (`PAGEID`), KEY `att_prevver_idx` (`PREVVER`), CONSTRAINT `FK54475F9017D4A070` FOREIGN KEY (`PREVVER`) REFERENCES `ATTACHMENTS` (`ATTACHMENTID`), CONSTRAINT `FK54475F908C38FBEA` FOREIGN KEY (`PAGEID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `BANDANA` -- DROP TABLE IF EXISTS `BANDANA`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `BANDANA` ( `BANDANAID` bigint(20) NOT NULL, `BANDANACONTEXT` varchar(255) COLLATE utf8_bin NOT NULL, `BANDANAKEY` varchar(100) COLLATE utf8_bin NOT NULL, `BANDANAVALUE` longtext COLLATE utf8_bin, PRIMARY KEY (`BANDANAID`), UNIQUE KEY `bandana_unique_key` (`BANDANACONTEXT`,`BANDANAKEY`), KEY `band_context_idx` (`BANDANACONTEXT`), KEY `band_cont_key_idx` (`BANDANACONTEXT`,`BANDANAKEY`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `BODYCONTENT` -- DROP TABLE IF EXISTS `BODYCONTENT`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `BODYCONTENT` ( `BODYCONTENTID` bigint(20) NOT NULL, `BODY` longtext COLLATE utf8_bin, `CONTENTID` bigint(20) DEFAULT NULL, `BODYTYPEID` smallint(6) DEFAULT NULL, PRIMARY KEY (`BODYCONTENTID`), KEY `body_content_idx` (`CONTENTID`), CONSTRAINT `FKA898D4778DD41734` FOREIGN KEY (`CONTENTID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CLUSTERSAFETY` -- DROP TABLE IF EXISTS `CLUSTERSAFETY`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CLUSTERSAFETY` ( `CLUSTERSAFETYID` bigint(20) NOT NULL, `SAFETYNUMBER` int(11) DEFAULT NULL, PRIMARY KEY (`CLUSTERSAFETYID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CONFANCESTORS` -- DROP TABLE IF EXISTS `CONFANCESTORS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CONFANCESTORS` ( `DESCENDENTID` bigint(20) NOT NULL, `ANCESTORID` bigint(20) NOT NULL, `ANCESTORPOSITION` int(11) NOT NULL, PRIMARY KEY (`DESCENDENTID`,`ANCESTORPOSITION`), KEY `FK9494E23C37E35A2E` (`ANCESTORID`), CONSTRAINT `FK9494E23CC45E94DC` FOREIGN KEY (`DESCENDENTID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CONFVERSION` -- DROP TABLE IF EXISTS `CONFVERSION`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CONFVERSION` ( `CONFVERSIONID` bigint(20) NOT NULL, `BUILDNUMBER` int(11) NOT NULL, `INSTALLDATE` datetime DEFAULT NULL, `VERSIONTAG` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`CONFVERSIONID`), UNIQUE KEY `BUILDNUMBER` (`BUILDNUMBER`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CONTENT` -- DROP TABLE IF EXISTS `CONTENT`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CONTENT` ( `CONTENTID` bigint(20) NOT NULL, `CONTENTTYPE` varchar(255) COLLATE utf8_bin NOT NULL, `TITLE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `VERSION` int(11) DEFAULT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, `VERSIONCOMMENT` longtext COLLATE utf8_bin, `PREVVER` bigint(20) DEFAULT NULL, `CONTENT_STATUS` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SPACEID` bigint(20) DEFAULT NULL, `CHILD_POSITION` int(11) DEFAULT NULL, `PARENTID` bigint(20) DEFAULT NULL, `MESSAGEID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DRAFTPAGEID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DRAFTSPACEKEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DRAFTTYPE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DRAFTPAGEVERSION` int(11) DEFAULT NULL, `PAGEID` bigint(20) DEFAULT NULL, `PARENTCOMMENTID` bigint(20) DEFAULT NULL, `USERNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PLUGINKEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PLUGINVER` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`CONTENTID`), KEY `c_parentcommid_idx` (`PARENTCOMMENTID`), KEY `c_title_idx` (`TITLE`), KEY `c_spaceid_idx` (`SPACEID`), KEY `c_drafttype_idx` (`DRAFTTYPE`), KEY `c_draftpageid_idx` (`DRAFTPAGEID`), KEY `c_parentid_idx` (`PARENTID`), KEY `c_username_idx` (`USERNAME`), KEY `c_prevver_idx` (`PREVVER`), KEY `c_messageid_idx` (`MESSAGEID`), KEY `c_contenttype_idx` (`CONTENTTYPE`), KEY `c_pageid_idx` (`PAGEID`), KEY `c_creator_idx` (`CREATOR`), CONSTRAINT `FK6382C05917D4A070` FOREIGN KEY (`PREVVER`) REFERENCES `CONTENT` (`CONTENTID`), CONSTRAINT `FK6382C05974B18345` FOREIGN KEY (`PARENTID`) REFERENCES `CONTENT` (`CONTENTID`), CONSTRAINT `FK6382C0598C38FBEA` FOREIGN KEY (`PAGEID`) REFERENCES `CONTENT` (`CONTENTID`), CONSTRAINT `FK6382C059B2DC6081` FOREIGN KEY (`SPACEID`) REFERENCES `SPACES` (`SPACEID`), CONSTRAINT `FK6382C059B97E9230` FOREIGN KEY (`PARENTCOMMENTID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CONTENTPROPERTIES` -- DROP TABLE IF EXISTS `CONTENTPROPERTIES`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CONTENTPROPERTIES` ( `PROPERTYID` bigint(20) NOT NULL, `PROPERTYNAME` varchar(255) COLLATE utf8_bin NOT NULL, `STRINGVAL` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LONGVAL` bigint(20) DEFAULT NULL, `DATEVAL` datetime DEFAULT NULL, `CONTENTID` bigint(20) DEFAULT NULL, PRIMARY KEY (`PROPERTYID`), KEY `FK984C5E4C8DD41734` (`CONTENTID`), KEY `content_prop_str_idx` (`STRINGVAL`), KEY `content_prop_long_idx` (`LONGVAL`), KEY `content_prop_name_idx` (`PROPERTYNAME`), KEY `content_prop_date_idx` (`DATEVAL`), CONSTRAINT `FK984C5E4C8DD41734` FOREIGN KEY (`CONTENTID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CONTENT_LABEL` -- DROP TABLE IF EXISTS `CONTENT_LABEL`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CONTENT_LABEL` ( `ID` bigint(20) NOT NULL, `LABELID` bigint(20) NOT NULL, `CONTENTID` bigint(20) DEFAULT NULL, `SPACEKEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `OWNER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, `ATTACHMENTID` bigint(20) DEFAULT NULL, `PAGETEMPLATEID` bigint(20) DEFAULT NULL, `LABELABLEID` bigint(20) DEFAULT NULL, `LABELABLETYPE` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID`), KEY `cl_spacekey_idx` (`SPACEKEY`), KEY `cl_contentid_idx` (`CONTENTID`), KEY `cl_labelid_idx` (`LABELID`), KEY `cl_lastmoddate_idx` (`LASTMODDATE`), KEY `cl_attachmentid_idx` (`ATTACHMENTID`), KEY `cl_pagetemplateid_idx` (`PAGETEMPLATEID`), KEY `cl_labelable_idx` (`LABELABLEID`,`LABELABLETYPE`), CONSTRAINT `FKF0E7436E27072AEF` FOREIGN KEY (`LABELID`) REFERENCES `LABEL` (`LABELID`), CONSTRAINT `FKF0E7436E34A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `ATTACHMENTS` (`ATTACHMENTID`), CONSTRAINT `FKF0E7436E8DD41734` FOREIGN KEY (`CONTENTID`) REFERENCES `CONTENT` (`CONTENTID`), CONSTRAINT `FKF0E7436ED32042E4` FOREIGN KEY (`PAGETEMPLATEID`) REFERENCES `PAGETEMPLATES` (`TEMPLATEID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CONTENT_PERM` -- DROP TABLE IF EXISTS `CONTENT_PERM`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CONTENT_PERM` ( `ID` bigint(20) NOT NULL, `CP_TYPE` varchar(10) COLLATE utf8_bin NOT NULL, `USERNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `GROUPNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CPS_ID` bigint(20) NOT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `cp_unique_user` (`CPS_ID`,`CP_TYPE`,`USERNAME`), UNIQUE KEY `cp_unique_group` (`CPS_ID`,`CP_TYPE`,`GROUPNAME`), KEY `cp_os_idx` (`CPS_ID`), KEY `cp_gn_idx` (`GROUPNAME`), KEY `cp_un_idx` (`USERNAME`), CONSTRAINT `FKBD74B31676E33274` FOREIGN KEY (`CPS_ID`) REFERENCES `CONTENT_PERM_SET` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CONTENT_PERM_SET` -- DROP TABLE IF EXISTS `CONTENT_PERM_SET`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CONTENT_PERM_SET` ( `ID` bigint(20) NOT NULL, `CONT_PERM_TYPE` varchar(10) COLLATE utf8_bin NOT NULL, `CONTENT_ID` bigint(20) NOT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `cps_unique_type` (`CONTENT_ID`,`CONT_PERM_TYPE`), KEY `cps_content_idx` (`CONTENT_ID`), KEY `cps_permtype_idx` (`CONT_PERM_TYPE`), CONSTRAINT `FKBF45A7992CAF22C1` FOREIGN KEY (`CONTENT_ID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `DECORATOR` -- DROP TABLE IF EXISTS `DECORATOR`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DECORATOR` ( `DECORATORID` bigint(20) NOT NULL, `SPACEKEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DECORATORNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BODY` longtext COLLATE utf8_bin, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`DECORATORID`), KEY `dec_name_idx` (`DECORATORNAME`), KEY `dec_key_idx` (`SPACEKEY`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EXTRNLNKS` -- DROP TABLE IF EXISTS `EXTRNLNKS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EXTRNLNKS` ( `LINKID` bigint(20) NOT NULL, `CONTENTTYPE` varchar(255) COLLATE utf8_bin NOT NULL, `VIEWCOUNT` int(11) NOT NULL, `URL` varchar(255) COLLATE utf8_bin NOT NULL, `CONTENTID` bigint(20) NOT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`LINKID`), KEY `el_contentid_idx` (`CONTENTID`), CONSTRAINT `FK97C10FE78DD41734` FOREIGN KEY (`CONTENTID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `FOLLOW_CONNECTIONS` -- DROP TABLE IF EXISTS `FOLLOW_CONNECTIONS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `FOLLOW_CONNECTIONS` ( `CONNECTIONID` bigint(20) NOT NULL, `FOLLOWER` varchar(255) COLLATE utf8_bin NOT NULL, `FOLLOWEE` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`CONNECTIONID`), KEY `cn_followee_idx` (`FOLLOWEE`), KEY `cn_follower_idx` (`FOLLOWER`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `IMAGEDETAILS` -- DROP TABLE IF EXISTS `IMAGEDETAILS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `IMAGEDETAILS` ( `ATTACHMENTID` bigint(20) NOT NULL, `HEIGHT` int(11) DEFAULT NULL, `WIDTH` int(11) DEFAULT NULL, `MIMETYPE` varchar(30) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ATTACHMENTID`), CONSTRAINT `FKA768048734A4917E` FOREIGN KEY (`ATTACHMENTID`) REFERENCES `ATTACHMENTS` (`ATTACHMENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `INDEXQUEUEENTRIES` -- DROP TABLE IF EXISTS `INDEXQUEUEENTRIES`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `INDEXQUEUEENTRIES` ( `ENTRYID` bigint(20) NOT NULL, `CREATIONDATE` datetime DEFAULT NULL, `TYPE` int(11) DEFAULT NULL, `HANDLE` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ENTRYID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `KEYSTORE` -- DROP TABLE IF EXISTS `KEYSTORE`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `KEYSTORE` ( `KEYID` bigint(20) NOT NULL, `ALIAS` varchar(255) COLLATE utf8_bin NOT NULL, `TYPE` varchar(32) COLLATE utf8_bin NOT NULL, `ALGORITHM` varchar(32) COLLATE utf8_bin NOT NULL, `KEYSPEC` mediumtext COLLATE utf8_bin NOT NULL, PRIMARY KEY (`KEYID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `LABEL` -- DROP TABLE IF EXISTS `LABEL`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `LABEL` ( `LABELID` bigint(20) NOT NULL, `NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `OWNER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAMESPACE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`LABELID`), KEY `l_owner_idx` (`OWNER`), KEY `l_name_idx` (`NAME`), KEY `l_namespace_idx` (`NAMESPACE`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `LIKES` -- DROP TABLE IF EXISTS `LIKES`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `LIKES` ( `ID` bigint(20) NOT NULL, `CONTENTID` bigint(20) NOT NULL, `USERNAME` varchar(255) COLLATE utf8_bin NOT NULL, `CREATIONDATE` datetime NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `like_cid_name_uni` (`CONTENTID`,`USERNAME`), KEY `like_cid_idx` (`CONTENTID`), KEY `like_username_idx` (`USERNAME`), KEY `like_cdate_idx` (`CREATIONDATE`), CONSTRAINT `FK4514B9C8DD41734` FOREIGN KEY (`CONTENTID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `LINKS` -- DROP TABLE IF EXISTS `LINKS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `LINKS` ( `LINKID` bigint(20) NOT NULL, `DESTPAGETITLE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DESTSPACEKEY` varchar(255) COLLATE utf8_bin NOT NULL, `CONTENTID` bigint(20) NOT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`LINKID`), KEY `l_contentid_idx` (`CONTENTID`), KEY `l_destspacekey_idx` (`DESTSPACEKEY`), CONSTRAINT `FK45157998DD41734` FOREIGN KEY (`CONTENTID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `NOTIFICATIONS` -- DROP TABLE IF EXISTS `NOTIFICATIONS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `NOTIFICATIONS` ( `NOTIFICATIONID` bigint(20) NOT NULL, `PAGEID` bigint(20) DEFAULT NULL, `SPACEID` bigint(20) DEFAULT NULL, `USERNAME` varchar(255) COLLATE utf8_bin NOT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, `DIGEST` bit(1) DEFAULT NULL, `NETWORK` bit(1) DEFAULT NULL, `CONTENTTYPE` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`NOTIFICATIONID`), KEY `n_spaceid_idx` (`SPACEID`), KEY `n_pageid_idx` (`PAGEID`), CONSTRAINT `FK594ACC88C38FBEA` FOREIGN KEY (`PAGEID`) REFERENCES `CONTENT` (`CONTENTID`), CONSTRAINT `FK594ACC8B2DC6081` FOREIGN KEY (`SPACEID`) REFERENCES `SPACES` (`SPACEID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `OS_PROPERTYENTRY` -- DROP TABLE IF EXISTS `OS_PROPERTYENTRY`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `OS_PROPERTYENTRY` ( `entity_name` varchar(125) COLLATE utf8_bin NOT NULL, `entity_id` bigint(20) NOT NULL, `entity_key` varchar(200) COLLATE utf8_bin NOT NULL, `key_type` int(11) DEFAULT NULL, `boolean_val` bit(1) DEFAULT NULL, `double_val` double DEFAULT NULL, `string_val` varchar(255) COLLATE utf8_bin DEFAULT NULL, `text_val` longtext COLLATE utf8_bin, `long_val` bigint(20) DEFAULT NULL, `int_val` int(11) DEFAULT NULL, `date_val` datetime DEFAULT NULL, PRIMARY KEY (`entity_name`,`entity_id`,`entity_key`), KEY `ospe_entityid_idx` (`entity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PAGETEMPLATES` -- DROP TABLE IF EXISTS `PAGETEMPLATES`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PAGETEMPLATES` ( `TEMPLATEID` bigint(20) NOT NULL, `TEMPLATENAME` varchar(255) COLLATE utf8_bin NOT NULL, `TEMPLATEDESC` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LABELS` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CONTENT` longtext COLLATE utf8_bin, `SPACEID` bigint(20) DEFAULT NULL, `PREVVER` bigint(20) DEFAULT NULL, `VERSION` int(11) NOT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, `BODYTYPEID` smallint(6) DEFAULT NULL, `PLUGINKEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `MODULEKEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFPLUGINKEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFMODULEKEY` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`TEMPLATEID`), KEY `pt_prevver_idx` (`PREVVER`), KEY `pt_spaceid_idx` (`SPACEID`), CONSTRAINT `FKBC7CE96A17D4A070` FOREIGN KEY (`PREVVER`) REFERENCES `PAGETEMPLATES` (`TEMPLATEID`), CONSTRAINT `FKBC7CE96AB2DC6081` FOREIGN KEY (`SPACEID`) REFERENCES `SPACES` (`SPACEID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `PLUGINDATA` -- DROP TABLE IF EXISTS `PLUGINDATA`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `PLUGINDATA` ( `PLUGINDATAID` bigint(20) NOT NULL, `PLUGINKEY` varchar(255) COLLATE utf8_bin NOT NULL, `FILENAME` varchar(255) COLLATE utf8_bin NOT NULL, `LASTMODDATE` datetime DEFAULT NULL, `DATA` longblob, PRIMARY KEY (`PLUGINDATAID`), UNIQUE KEY `PLUGINKEY` (`PLUGINKEY`), UNIQUE KEY `FILENAME` (`FILENAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SPACEGROUPPERMISSIONS` -- DROP TABLE IF EXISTS `SPACEGROUPPERMISSIONS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SPACEGROUPPERMISSIONS` ( `SPACEGROUPPERMID` bigint(20) NOT NULL, `SPACEGROUPID` bigint(20) DEFAULT NULL, `PERMTYPE` varchar(255) COLLATE utf8_bin NOT NULL, `PERMGROUPNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PERMUSERNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`SPACEGROUPPERMID`), KEY `sgp_type_idx` (`PERMTYPE`), KEY `sgp_group_idx` (`PERMGROUPNAME`), KEY `sgp_user_idx` (`PERMUSERNAME`), KEY `spg_id_idx` (`SPACEGROUPID`), CONSTRAINT `FK487D958B16994414` FOREIGN KEY (`SPACEGROUPID`) REFERENCES `SPACEGROUPS` (`SPACEGROUPID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SPACEGROUPS` -- DROP TABLE IF EXISTS `SPACEGROUPS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SPACEGROUPS` ( `SPACEGROUPID` bigint(20) NOT NULL, `SPACEGROUPNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SPACEGROUPKEY` varchar(255) COLLATE utf8_bin NOT NULL, `LICENSEKEY` mediumtext COLLATE utf8_bin, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`SPACEGROUPID`), UNIQUE KEY `SPACEGROUPKEY` (`SPACEGROUPKEY`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SPACEPERMISSIONS` -- DROP TABLE IF EXISTS `SPACEPERMISSIONS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SPACEPERMISSIONS` ( `PERMID` bigint(20) NOT NULL, `SPACEID` bigint(20) DEFAULT NULL, `PERMTYPE` varchar(255) COLLATE utf8_bin NOT NULL, `PERMGROUPNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PERMUSERNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`PERMID`), KEY `sp_puname_idx` (`PERMUSERNAME`), KEY `sp_pgname_idx` (`PERMGROUPNAME`), KEY `sp_permtype_idx` (`PERMTYPE`), KEY `sp_spaceid_idx` (`SPACEID`), KEY `sp_comp_idx` (`PERMTYPE`,`PERMGROUPNAME`,`PERMUSERNAME`), CONSTRAINT `FKD33F23BEB2DC6081` FOREIGN KEY (`SPACEID`) REFERENCES `SPACES` (`SPACEID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SPACES` -- DROP TABLE IF EXISTS `SPACES`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SPACES` ( `SPACEID` bigint(20) NOT NULL, `SPACENAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SPACEKEY` varchar(255) COLLATE utf8_bin NOT NULL, `SPACEDESCID` bigint(20) DEFAULT NULL, `HOMEPAGE` bigint(20) DEFAULT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, `SPACETYPE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SPACEGROUPID` bigint(20) DEFAULT NULL, `SPACESTATUS` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`SPACEID`), UNIQUE KEY `SPACEKEY` (`SPACEKEY`), KEY `s_spacedescid_idx` (`SPACEDESCID`), KEY `s_spacegroupid_idx` (`SPACEGROUPID`), KEY `s_homepage_idx` (`HOMEPAGE`), KEY `s_creationdate_idx` (`CREATIONDATE`), KEY `s_spacestatus_idx` (`SPACESTATUS`), CONSTRAINT `FK9228242D11B7BFEE` FOREIGN KEY (`HOMEPAGE`) REFERENCES `CONTENT` (`CONTENTID`), CONSTRAINT `FK9228242D16994414` FOREIGN KEY (`SPACEGROUPID`) REFERENCES `SPACEGROUPS` (`SPACEGROUPID`), CONSTRAINT `FK9228242D2C72D3D2` FOREIGN KEY (`SPACEDESCID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TRACKBACKLINKS` -- DROP TABLE IF EXISTS `TRACKBACKLINKS`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `TRACKBACKLINKS` ( `LINKID` bigint(20) NOT NULL, `CONTENTTYPE` varchar(255) COLLATE utf8_bin NOT NULL, `VIEWCOUNT` int(11) NOT NULL, `URL` varchar(255) COLLATE utf8_bin NOT NULL, `TITLE` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BLOGNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCERPT` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CONTENTID` bigint(20) NOT NULL, `CREATOR` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATIONDATE` datetime DEFAULT NULL, `LASTMODIFIER` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LASTMODDATE` datetime DEFAULT NULL, PRIMARY KEY (`LINKID`), KEY `tbl_contentid_idx` (`CONTENTID`), CONSTRAINT `FKF6977A478DD41734` FOREIGN KEY (`CONTENTID`) REFERENCES `CONTENT` (`CONTENTID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TRUSTEDAPP` -- DROP TABLE IF EXISTS `TRUSTEDAPP`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `TRUSTEDAPP` ( `TRUSTEDAPPID` bigint(20) NOT NULL, `NAME` varchar(255) COLLATE utf8_bin NOT NULL, `TIMEOUT` int(11) NOT NULL, `PUBLIC_KEY_ID` bigint(20) NOT NULL, PRIMARY KEY (`TRUSTEDAPPID`), UNIQUE KEY `NAME` (`NAME`), UNIQUE KEY `PUBLIC_KEY_ID` (`PUBLIC_KEY_ID`), CONSTRAINT `FKDDB119CA9C85ADB1` FOREIGN KEY (`PUBLIC_KEY_ID`) REFERENCES `KEYSTORE` (`KEYID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `TRUSTEDAPPRESTRICTION` -- DROP TABLE IF EXISTS `TRUSTEDAPPRESTRICTION`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `TRUSTEDAPPRESTRICTION` ( `TRUSTEDAPPRESTRICTIONID` bigint(20) NOT NULL, `TYPE` varchar(32) COLLATE utf8_bin NOT NULL, `restriction` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TRUSTEDAPPID` bigint(20) DEFAULT NULL, PRIMARY KEY (`TRUSTEDAPPRESTRICTIONID`), KEY `FKE8496BA235D1D865` (`TRUSTEDAPPID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_app_dir_group_mapping` -- DROP TABLE IF EXISTS `cwd_app_dir_group_mapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_app_dir_group_mapping` ( `id` bigint(20) NOT NULL, `app_dir_mapping_id` bigint(20) NOT NULL, `application_id` bigint(20) NOT NULL, `directory_id` bigint(20) NOT NULL, `group_name` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `fk_app_dir_group_app` (`application_id`), KEY `fk_app_dir_group_mapping` (`app_dir_mapping_id`), KEY `idx_app_dir_group_group_dir` (`directory_id`,`group_name`), CONSTRAINT `fk_app_dir_group_app` FOREIGN KEY (`application_id`) REFERENCES `cwd_application` (`id`), CONSTRAINT `fk_app_dir_group_dir` FOREIGN KEY (`directory_id`) REFERENCES `cwd_directory` (`id`), CONSTRAINT `fk_app_dir_group_mapping` FOREIGN KEY (`app_dir_mapping_id`) REFERENCES `cwd_app_dir_mapping` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_app_dir_mapping` -- DROP TABLE IF EXISTS `cwd_app_dir_mapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_app_dir_mapping` ( `id` bigint(20) NOT NULL, `application_id` bigint(20) DEFAULT NULL, `directory_id` bigint(20) NOT NULL, `allow_all` char(1) COLLATE utf8_bin NOT NULL, `list_index` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_app_dir_dir` (`directory_id`), KEY `FK52050E2FB347AA6A` (`application_id`), CONSTRAINT `FK52050E2FB347AA6A` FOREIGN KEY (`application_id`) REFERENCES `cwd_application` (`id`), CONSTRAINT `fk_app_dir_dir` FOREIGN KEY (`directory_id`) REFERENCES `cwd_directory` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_app_dir_operation` -- DROP TABLE IF EXISTS `cwd_app_dir_operation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_app_dir_operation` ( `app_dir_mapping_id` bigint(20) NOT NULL, `operation_type` varchar(32) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`app_dir_mapping_id`,`operation_type`), CONSTRAINT `fk_app_dir_mapping` FOREIGN KEY (`app_dir_mapping_id`) REFERENCES `cwd_app_dir_mapping` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_application` -- DROP TABLE IF EXISTS `cwd_application`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_application` ( `id` bigint(20) NOT NULL, `application_name` varchar(255) COLLATE utf8_bin NOT NULL, `lower_application_name` varchar(255) COLLATE utf8_bin NOT NULL, `created_date` datetime NOT NULL, `updated_date` datetime NOT NULL, `active` char(1) COLLATE utf8_bin NOT NULL, `description` varchar(255) COLLATE utf8_bin DEFAULT NULL, `application_type` varchar(32) COLLATE utf8_bin NOT NULL, `credential` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `lower_application_name` (`lower_application_name`), KEY `idx_app_active` (`active`), KEY `idx_app_type` (`application_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_application_address` -- DROP TABLE IF EXISTS `cwd_application_address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_application_address` ( `application_id` bigint(20) NOT NULL, `remote_address` varchar(255) COLLATE utf8_bin NOT NULL, `remote_address_binary` varchar(255) COLLATE utf8_bin DEFAULT NULL, `remote_address_mask` int(11) NOT NULL, KEY `fk_application_address` (`application_id`), CONSTRAINT `fk_application_address` FOREIGN KEY (`application_id`) REFERENCES `cwd_application` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_application_attribute` -- DROP TABLE IF EXISTS `cwd_application_attribute`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_application_attribute` ( `application_id` bigint(20) NOT NULL, `attribute_value` text COLLATE utf8_bin, `attribute_name` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`application_id`,`attribute_name`), CONSTRAINT `fk_application_attribute` FOREIGN KEY (`application_id`) REFERENCES `cwd_application` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_directory` -- DROP TABLE IF EXISTS `cwd_directory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_directory` ( `id` bigint(20) NOT NULL, `directory_name` varchar(255) COLLATE utf8_bin NOT NULL, `lower_directory_name` varchar(255) COLLATE utf8_bin NOT NULL, `created_date` datetime NOT NULL, `updated_date` datetime NOT NULL, `active` char(1) COLLATE utf8_bin NOT NULL, `description` varchar(255) COLLATE utf8_bin DEFAULT NULL, `impl_class` varchar(255) COLLATE utf8_bin NOT NULL, `lower_impl_class` varchar(255) COLLATE utf8_bin NOT NULL, `directory_type` varchar(32) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `lower_directory_name` (`lower_directory_name`), KEY `idx_dir_type` (`directory_type`), KEY `idx_dir_active` (`active`), KEY `idx_dir_l_impl_class` (`lower_impl_class`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_directory_attribute` -- DROP TABLE IF EXISTS `cwd_directory_attribute`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_directory_attribute` ( `directory_id` bigint(20) NOT NULL, `attribute_value` text COLLATE utf8_bin, `attribute_name` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`directory_id`,`attribute_name`), CONSTRAINT `fk_directory_attribute` FOREIGN KEY (`directory_id`) REFERENCES `cwd_directory` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_directory_operation` -- DROP TABLE IF EXISTS `cwd_directory_operation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_directory_operation` ( `directory_id` bigint(20) NOT NULL, `operation_type` varchar(32) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`directory_id`,`operation_type`), CONSTRAINT `fk_directory_operation` FOREIGN KEY (`directory_id`) REFERENCES `cwd_directory` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_group` -- DROP TABLE IF EXISTS `cwd_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_group` ( `id` bigint(20) NOT NULL, `group_name` varchar(255) COLLATE utf8_bin NOT NULL, `lower_group_name` varchar(255) COLLATE utf8_bin NOT NULL, `active` char(1) COLLATE utf8_bin NOT NULL, `local` char(1) COLLATE utf8_bin NOT NULL, `created_date` datetime NOT NULL, `updated_date` datetime NOT NULL, `description` varchar(255) COLLATE utf8_bin DEFAULT NULL, `group_type` varchar(32) COLLATE utf8_bin NOT NULL, `directory_id` bigint(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `cwd_group_name_dir_id` (`lower_group_name`,`directory_id`), KEY `idx_group_active` (`active`,`directory_id`), KEY `idx_group_dir_id` (`directory_id`), CONSTRAINT `fk_directory_id` FOREIGN KEY (`directory_id`) REFERENCES `cwd_directory` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_group_attribute` -- DROP TABLE IF EXISTS `cwd_group_attribute`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_group_attribute` ( `id` bigint(20) NOT NULL, `group_id` bigint(20) NOT NULL, `directory_id` bigint(20) NOT NULL, `attribute_name` varchar(255) COLLATE utf8_bin NOT NULL, `attribute_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, `attribute_lower_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `cwd_unique_grp_attr` (`directory_id`,`group_id`,`attribute_name`,`attribute_lower_value`), KEY `idx_group_attr_dir_name_lval` (`directory_id`,`attribute_name`,`attribute_lower_value`), KEY `idx_group_attr_group_id` (`group_id`), CONSTRAINT `fk_group_attr_dir_id` FOREIGN KEY (`directory_id`) REFERENCES `cwd_directory` (`id`), CONSTRAINT `fk_group_attr_id_group_id` FOREIGN KEY (`group_id`) REFERENCES `cwd_group` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_membership` -- DROP TABLE IF EXISTS `cwd_membership`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_membership` ( `id` bigint(20) NOT NULL, `parent_id` bigint(20) NOT NULL, `child_group_id` bigint(20) DEFAULT NULL, `child_user_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `cwd_unique_user_membership` (`parent_id`,`child_user_id`), UNIQUE KEY `cwd_unique_group_membership` (`parent_id`,`child_group_id`), KEY `fk_child_user` (`child_user_id`), KEY `idx_mem_dir_child` (`child_group_id`,`child_user_id`), KEY `idx_mem_dir_parent` (`parent_id`), KEY `idx_mem_dir_parent_child` (`parent_id`,`child_group_id`,`child_user_id`), CONSTRAINT `fk_child_grp` FOREIGN KEY (`child_group_id`) REFERENCES `cwd_group` (`id`), CONSTRAINT `fk_child_user` FOREIGN KEY (`child_user_id`) REFERENCES `cwd_user` (`id`), CONSTRAINT `fk_parent_grp` FOREIGN KEY (`parent_id`) REFERENCES `cwd_group` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_user` -- DROP TABLE IF EXISTS `cwd_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_user` ( `id` bigint(20) NOT NULL, `user_name` varchar(255) COLLATE utf8_bin NOT NULL, `lower_user_name` varchar(255) COLLATE utf8_bin NOT NULL, `active` char(1) COLLATE utf8_bin NOT NULL, `created_date` datetime NOT NULL, `updated_date` datetime NOT NULL, `first_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `lower_first_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `last_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `lower_last_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `display_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `lower_display_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `email_address` varchar(255) COLLATE utf8_bin DEFAULT NULL, `lower_email_address` varchar(255) COLLATE utf8_bin DEFAULT NULL, `directory_id` bigint(20) NOT NULL, `credential` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `cwd_user_name_dir_id` (`lower_user_name`,`directory_id`), KEY `idx_user_lower_display_name` (`lower_display_name`,`directory_id`), KEY `idx_user_lower_last_name` (`lower_last_name`,`directory_id`), KEY `idx_user_active` (`active`,`directory_id`), KEY `idx_user_name_dir_id` (`directory_id`), KEY `idx_user_lower_first_name` (`lower_first_name`,`directory_id`), KEY `idx_user_lower_email_address` (`lower_email_address`,`directory_id`), CONSTRAINT `fk_user_dir_id` FOREIGN KEY (`directory_id`) REFERENCES `cwd_directory` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_user_attribute` -- DROP TABLE IF EXISTS `cwd_user_attribute`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_user_attribute` ( `id` bigint(20) NOT NULL, `user_id` bigint(20) NOT NULL, `directory_id` bigint(20) NOT NULL, `attribute_name` varchar(255) COLLATE utf8_bin NOT NULL, `attribute_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, `attribute_lower_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `cwd_unique_usr_attr` (`directory_id`,`user_id`,`attribute_name`,`attribute_lower_value`), KEY `idx_user_attr_dir_name_lval` (`directory_id`,`attribute_name`,`attribute_lower_value`), KEY `idx_user_attr_user_id` (`user_id`), CONSTRAINT `fk_user_attribute_id_user_id` FOREIGN KEY (`user_id`) REFERENCES `cwd_user` (`id`), CONSTRAINT `fk_user_attr_dir_id` FOREIGN KEY (`directory_id`) REFERENCES `cwd_directory` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cwd_user_credential_record` -- DROP TABLE IF EXISTS `cwd_user_credential_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cwd_user_credential_record` ( `id` bigint(20) NOT NULL, `user_id` bigint(20) DEFAULT NULL, `password_hash` varchar(255) COLLATE utf8_bin NOT NULL, `list_index` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK76F874F73AEE0F` (`user_id`), CONSTRAINT `FK76F874F73AEE0F` FOREIGN KEY (`user_id`) REFERENCES `cwd_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `external_entities` -- DROP TABLE IF EXISTS `external_entities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `external_entities` ( `id` bigint(20) NOT NULL, `name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `type` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `ext_ent_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `external_members` -- DROP TABLE IF EXISTS `external_members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `external_members` ( `extentityid` bigint(20) NOT NULL, `groupid` bigint(20) NOT NULL, PRIMARY KEY (`groupid`,`extentityid`), KEY `FKD8C8D8A5F25E5D5F` (`extentityid`), CONSTRAINT `FKD8C8D8A5117D5FDA` FOREIGN KEY (`groupid`) REFERENCES `groups` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `groups` -- DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `groups` ( `id` bigint(20) NOT NULL, `groupname` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `groupname` (`groupname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hibernate_unique_key` -- DROP TABLE IF EXISTS `hibernate_unique_key`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hibernate_unique_key` ( `next_hi` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `local_members` -- DROP TABLE IF EXISTS `local_members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `local_members` ( `userid` bigint(20) NOT NULL, `groupid` bigint(20) NOT NULL, PRIMARY KEY (`groupid`,`userid`), KEY `FK6B8FB445CE2B3226` (`userid`), CONSTRAINT `FK6B8FB445117D5FDA` FOREIGN KEY (`groupid`) REFERENCES `groups` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `logininfo` -- DROP TABLE IF EXISTS `logininfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `logininfo` ( `id` bigint(20) NOT NULL, `CURFAILED` int(11) DEFAULT NULL, `TOTALFAILED` int(11) DEFAULT NULL, `SUCCESSDATE` datetime DEFAULT NULL, `PREVSUCCESSDATE` datetime DEFAULT NULL, `FAILEDDATE` datetime DEFAULT NULL, `USERNAME` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `USERNAME` (`USERNAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `os_group` -- DROP TABLE IF EXISTS `os_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `os_group` ( `id` bigint(20) NOT NULL, `groupname` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `groupname` (`groupname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `os_user` -- DROP TABLE IF EXISTS `os_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `os_user` ( `id` bigint(20) NOT NULL, `username` varchar(255) COLLATE utf8_bin NOT NULL, `passwd` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `os_user_group` -- DROP TABLE IF EXISTS `os_user_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `os_user_group` ( `group_id` bigint(20) NOT NULL, `user_id` bigint(20) NOT NULL, PRIMARY KEY (`user_id`,`group_id`), KEY `FK932472461E2E76DB` (`group_id`), CONSTRAINT `FK93247246F73AEE0F` FOREIGN KEY (`user_id`) REFERENCES `os_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `remembermetoken` -- DROP TABLE IF EXISTS `remembermetoken`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `remembermetoken` ( `id` bigint(20) NOT NULL, `username` varchar(255) COLLATE utf8_bin NOT NULL, `created` bigint(20) NOT NULL, `token` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `rmt_username_idx` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL, `password` varchar(255) COLLATE utf8_bin DEFAULT NULL, `email` varchar(255) COLLATE utf8_bin DEFAULT NULL, `created` datetime DEFAULT NULL, `fullname` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 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 2013-12-05 18:29:06