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

DROP TABLE IF EXISTS `Binaries`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Binaries` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `MimeType` varchar(50) default NULL,
  `Filename` varchar(255) default NULL,
  `width` int(11) unsigned NOT NULL default '0',
  `height` int(11) unsigned NOT NULL default '0',
  `EntryID` int(11) unsigned NOT NULL default '0',
  `SectionID` int(11) unsigned NOT NULL default '0',
  `PageID` int(11) unsigned NOT NULL default '0',
  `Image` tinyint(4) unsigned NOT NULL default '0',
  `SearchContent` text,
  `LastChanged` int(11) unsigned NOT NULL default '0',
  `Size` bigint(20) unsigned NOT NULL default '0',
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`),
  KEY `SectionID` (`SectionID`),
  KEY `EntryID` (`EntryID`),
  FULLTEXT KEY `SearchContent` (`SearchContent`)
) ENGINE=MyISAM AUTO_INCREMENT=23524 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `BinariesBlob`
--

DROP TABLE IF EXISTS `BinariesBlob`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `BinariesBlob` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `data` longblob,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=23524 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `BlockedPollIPs`
--

DROP TABLE IF EXISTS `BlockedPollIPs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `BlockedPollIPs` (
  `EntryID` int(11) NOT NULL,
  `ID` varchar(255) NOT NULL,
  `LastAccess` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Building`
--

DROP TABLE IF EXISTS `Building`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Building` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `Number` varchar(255) default NULL,
  `PageID` int(11) unsigned default NULL,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `BuildingLang`
--

DROP TABLE IF EXISTS `BuildingLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `BuildingLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` text,
  `ImageID` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `ChangeLog`
--

DROP TABLE IF EXISTS `ChangeLog`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ChangeLog` (
  `ID` int(11) NOT NULL auto_increment,
  `Timestamp` int(11) unsigned NOT NULL default '0',
  `SessionID` varchar(64) default 'NULL',
  `UserID` int(11) unsigned default NULL,
  `PageID` int(11) unsigned default NULL,
  `PublishedPageID` int(11) unsigned default NULL,
  `SectionID` int(11) unsigned default NULL,
  `EntryID` int(11) unsigned default NULL,
  `EntryClass` text,
  `BinaryID` int(11) unsigned default NULL,
  `EntityID` int(11) unsigned default NULL,
  `EntityClass` text,
  `LangID` tinyint(4) unsigned default NULL,
  `Undone` tinyint(4) unsigned NOT NULL default '0',
  `Description` text,
  `Success` tinyint(4) unsigned NOT NULL default '0',
  `Doable` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`),
  KEY `PublishedPageID` (`PublishedPageID`),
  KEY `SectionID` (`SectionID`),
  KEY `SessionID` (`SessionID`),
  KEY `EntryID` (`EntryID`),
  KEY `EntityID` (`EntityID`)
) ENGINE=MyISAM AUTO_INCREMENT=135699 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DbLog`
--

DROP TABLE IF EXISTS `DbLog`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DbLog` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `ChangeLogID` int(11) unsigned default NULL,
  `Redo` longblob,
  `Undo` longblob,
  PRIMARY KEY  (`ID`),
  KEY `ChangeLogID` (`ChangeLogID`)
) ENGINE=MyISAM AUTO_INCREMENT=7504 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DocumentType`
--

DROP TABLE IF EXISTS `DocumentType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DocumentType` (
  `ID` int(11) unsigned NOT NULL default '0',
  `Name` varchar(255) default NULL,
  `MimeType` varchar(255) default NULL,
  `Endings` varchar(255) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Entry`
--

DROP TABLE IF EXISTS `Entry`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Entry` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `TypeID` int(11) unsigned default '1',
  `SectionID` int(11) unsigned default NULL,
  `ColPos` int(11) unsigned default NULL,
  `RowPos` int(11) unsigned default NULL,
  `LastChanged` int(11) unsigned NOT NULL default '0',
  `LastChangedByUserID` int(11) unsigned NOT NULL default '0',
  `Xml` text,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `SectionID` (`SectionID`),
  KEY `ColPos` (`ColPos`),
  KEY `RowPos` (`RowPos`)
) ENGINE=MyISAM AUTO_INCREMENT=28012 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EntryLang`
--

DROP TABLE IF EXISTS `EntryLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EntryLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `XmlSrc` text,
  `SearchContent` text,
  PRIMARY KEY  (`ID`,`LangID`),
  FULLTEXT KEY `SearchContent` (`SearchContent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EntryType`
--

DROP TABLE IF EXISTS `EntryType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EntryType` (
  `ID` int(11) unsigned NOT NULL default '0',
  `Class` varchar(50) default NULL,
  `PosInGroup` tinyint(4) unsigned default NULL,
  `GroupID` tinyint(4) unsigned NOT NULL default '99',
  PRIMARY KEY  (`ID`),
  KEY `GroupID` (`GroupID`,`PosInGroup`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Event`
--

DROP TABLE IF EXISTS `Event`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Event` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PageID` int(11) unsigned default NULL,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  `Date` int(11) unsigned default NULL,
  `SubscriptionMandatory` tinyint(4) default '1',
  `StartDate` int(11) unsigned default NULL,
  `ClosureDate` int(11) unsigned default NULL,
  `ReservedPlaces` int(11) unsigned default NULL,
  `TotalPlaces` int(11) unsigned default NULL,
  `MaxRegistrationsPerUser` int(11) unsigned default NULL,
  `GuestsPerEmployee` int(11) unsigned default NULL,
  `ChildrenAllowed` tinyint(4) default '1',
  `MinChildAge` int(11) unsigned default NULL,
  `EventSeriesName` varchar(255) default NULL,
  `Cancelled` tinyint(4) unsigned default '0',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`)
) ENGINE=MyISAM AUTO_INCREMENT=191 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EventCategory`
--

DROP TABLE IF EXISTS `EventCategory`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EventCategory` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PageID` int(11) unsigned default NULL,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EventCategoryLang`
--

DROP TABLE IF EXISTS `EventCategoryLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EventCategoryLang` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `LangID` tinyint(4) NOT NULL default '1',
  `Title` text,
  `XmlSrc` text,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EventDate`
--

DROP TABLE IF EXISTS `EventDate`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EventDate` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `EventID` int(11) unsigned NOT NULL default '0',
  `RoomID` int(11) unsigned default NULL,
  `Start` int(11) unsigned NOT NULL default '0',
  `End` int(11) unsigned NOT NULL default '0',
  `daily` int(11) unsigned NOT NULL default '0',
  `weekly` int(11) unsigned NOT NULL default '0',
  `monthly` int(11) unsigned NOT NULL default '0',
  `PeriodEnd` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EventLang`
--

DROP TABLE IF EXISTS `EventLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EventLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Title` text,
  `MenuTitle` varchar(255) default NULL,
  `Location` text,
  `FieldsXml` text,
  `RegistrationFieldsXml` text,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EventSubscription`
--

DROP TABLE IF EXISTS `EventSubscription`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EventSubscription` (
  `EventID` int(11) unsigned NOT NULL,
  `Email` varchar(255) NOT NULL default '',
  `Guest` int(11) unsigned NOT NULL,
  `Position` int(11) unsigned NOT NULL default '1',
  `WaitingListPos` int(11) unsigned NOT NULL default '1',
  `PersonalDataXml` text,
  PRIMARY KEY  (`EventID`,`Email`,`Guest`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EventType`
--

DROP TABLE IF EXISTS `EventType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EventType` (
  `ID` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `EventTypeLang`
--

DROP TABLE IF EXISTS `EventTypeLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `EventTypeLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` varchar(255) default NULL,
  `Abbreviation` varchar(255) default NULL,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Floor`
--

DROP TABLE IF EXISTS `Floor`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Floor` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PageID` int(11) unsigned default NULL,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `FloorLang`
--

DROP TABLE IF EXISTS `FloorLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `FloorLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` text,
  `Number` varchar(20) default NULL,
  `ImageMap` text,
  `ImageID` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Help`
--

DROP TABLE IF EXISTS `Help`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Help` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `UrlName` varchar(255) default NULL,
  `Keywords` text,
  `LangID` int(11) unsigned NOT NULL default '1',
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM AUTO_INCREMENT=1814 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `IntranetNews`
--

DROP TABLE IF EXISTS `IntranetNews`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `IntranetNews` (
  `ID` int(11) NOT NULL auto_increment,
  `PageID` int(11) default NULL,
  `NewsDate` int(11) NOT NULL default '0',
  `OnHomepage` tinyint(4) NOT NULL default '0',
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  `NewsPageID` int(11) default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `IntranetNewsLang`
--

DROP TABLE IF EXISTS `IntranetNewsLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `IntranetNewsLang` (
  `ID` int(11) NOT NULL default '0',
  `LangID` tinyint(4) NOT NULL default '1',
  `Title` text,
  `Teaser` text,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Location`
--

DROP TABLE IF EXISTS `Location`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Location` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PageID` int(11) unsigned default NULL,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `LocationLang`
--

DROP TABLE IF EXISTS `LocationLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `LocationLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` text,
  `ImageID` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Message`
--

DROP TABLE IF EXISTS `Message`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Message` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `Recipient` int(11) unsigned NOT NULL default '0',
  `Forwarder` int(11) unsigned NOT NULL default '0',
  `Subject` text,
  `Text` text,
  `Date` int(11) unsigned NOT NULL default '0',
  `ReplyTo` int(11) unsigned NOT NULL default '0',
  `Caller` int(11) unsigned NOT NULL default '0',
  `bRead` tinyint(4) unsigned NOT NULL,
  `PageID` int(11) unsigned default NULL,
  `Comment` text,
  PRIMARY KEY  (`ID`),
  KEY `Recipient` (`Recipient`),
  KEY `Forwarder` (`Forwarder`)
) ENGINE=MyISAM AUTO_INCREMENT=4316 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `News`
--

DROP TABLE IF EXISTS `News`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `News` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PageID` int(11) unsigned default NULL,
  `NewsDate` int(11) unsigned NOT NULL default '0',
  `OnHomepage` tinyint(4) unsigned NOT NULL default '0',
  `ImageID` int(11) unsigned default NULL,
  `PublishedVersionID` int(11) default '0',
  `EditVersionID` int(11) default '0',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`),
  KEY `NewsDate` (`NewsDate`)
) ENGINE=MyISAM AUTO_INCREMENT=1262 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `NewsLang`
--

DROP TABLE IF EXISTS `NewsLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `NewsLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Title` text,
  `Teaser` text,
  `Caption` text,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `OrgType`
--

DROP TABLE IF EXISTS `OrgType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OrgType` (
  `ID` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `OrgTypeLang`
--

DROP TABLE IF EXISTS `OrgTypeLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OrgTypeLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` varchar(255) default NULL,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `OrgUnit`
--

DROP TABLE IF EXISTS `OrgUnit`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OrgUnit` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `OrgTypeID` int(11) unsigned default NULL,
  `PageID` int(11) unsigned default NULL,
  `BasicMain` int(11) NOT NULL default '1',
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `OrgUnitLang`
--

DROP TABLE IF EXISTS `OrgUnitLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OrgUnitLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` varchar(255) default NULL,
  `Abbreviation` varchar(255) default NULL,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Page`
--

DROP TABLE IF EXISTS `Page`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Page` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `TypeID` int(11) unsigned default NULL,
  `ParentID` int(11) unsigned default '2',
  `PosInParent` int(11) unsigned default NULL,
  `Expires` int(11) unsigned NOT NULL default '0',
  `LastChanged` int(11) unsigned NOT NULL default '0',
  `LastChangedByUserID` int(11) unsigned NOT NULL default '0',
  `ReadAccessIDs` text,
  `WriteAccessIDs` text,
  `PublishAccessIDs` text,
  `Dynamic` varchar(200) default NULL,
  `ShowInMenu` tinyint(4) unsigned NOT NULL default '1',
  `MetaAuthor` varchar(200) default NULL,
  `MetaPublisher` varchar(200) default NULL,
  `MetaCopyright` varchar(200) default NULL,
  `MainLanguageID` tinyint(4) unsigned NOT NULL default '1',
  `NewWindow` tinyint(4) unsigned NOT NULL default '0',
  `PublishDate` int(11) unsigned NOT NULL default '0',
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  `PublishRequestForUserIDs` text,
  `PublishRequestByUserID` int(11) unsigned NOT NULL default '0',
  `PublishMode` tinyint(4) unsigned default NULL,
  `LockedBySession` varchar(64) default NULL,
  `PathIDs` text,
  `Modified` int(11) unsigned NOT NULL default '0',
  `TagsModified` int(11) unsigned NOT NULL default '1',
  `MenuTree` mediumtext,
  `MenuModified` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `TypeID` (`TypeID`),
  KEY `ParentID` (`ParentID`),
  KEY `PosInParent` (`PosInParent`),
  KEY `Expires` (`Expires`),
  KEY `Modified` (`Modified`),
  KEY `PathIDs` (`PathIDs`(50))
) ENGINE=MyISAM AUTO_INCREMENT=5392 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PageAlias`
--

DROP TABLE IF EXISTS `PageAlias`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PageAlias` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PageID` int(11) unsigned default NULL,
  `AliasPageID` int(11) unsigned default NULL,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  `Frameset` tinyint(4) default '1',
  `cClass` varchar(20) NOT NULL default 'PageAlias',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`)
) ENGINE=MyISAM AUTO_INCREMENT=257 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PageAliasLang`
--

DROP TABLE IF EXISTS `PageAliasLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PageAliasLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `MenuTitle` varchar(50) default '',
  `URL` varchar(255) default '',
  `SearchContent` text,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PageLang`
--

DROP TABLE IF EXISTS `PageLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PageLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Title` varchar(255) default '',
  `MenuTitle` varchar(50) default '',
  `UrlName` varchar(255) default '',
  `MetaKeywords` text,
  `MetaDescription` text,
  `MetaPageTopic` text,
  `MetaPageType` text,
  `MetaAudience` text,
  `SearchContent` text,
  `LangVisible` tinyint(4) unsigned NOT NULL,
  `UrlPath` text,
  PRIMARY KEY  (`ID`,`LangID`),
  KEY `UrlName` (`UrlName`),
  KEY `UrlPath` (`UrlPath`(200)),
  FULLTEXT KEY `SearchContent` (`Title`,`MenuTitle`,`UrlName`,`SearchContent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PageTag`
--

DROP TABLE IF EXISTS `PageTag`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PageTag` (
  `PageID` int(11) unsigned NOT NULL,
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `TagID` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`PageID`,`LangID`,`TagID`),
  KEY `Tag` (`TagID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PageType`
--

DROP TABLE IF EXISTS `PageType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PageType` (
  `ID` int(11) unsigned NOT NULL default '0',
  `Class` text NOT NULL,
  `CreateByTemplate` tinyint(4) unsigned default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Person`
--

DROP TABLE IF EXISTS `Person`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Person` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `Name` varchar(100) NOT NULL default '',
  `FirstName` varchar(100) NOT NULL default '',
  `Salutation` varchar(25) default NULL,
  `Title` varchar(25) default NULL,
  `Phone` varchar(50) default NULL,
  `Fax` varchar(50) default NULL,
  `Email` varchar(50) default NULL,
  `RoomID` int(11) unsigned default NULL,
  `PageID` int(11) unsigned default NULL,
  `PrivAddress` text,
  `PrivPhone` varchar(50) default NULL,
  `PrivFax` varchar(50) default NULL,
  `Birthday` varchar(20) default NULL,
  `CanEdit` tinyint(4) unsigned default '1',
  `Password` varchar(50) default NULL,
  `UserGroupIDs` text,
  `SessionID` varchar(64) default NULL,
  `LastAccess` int(11) unsigned NOT NULL default '0',
  `BinaryID` int(11) unsigned default NULL,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  `LastMessage` int(11) unsigned NOT NULL default '1',
  `MessageMode` int(11) unsigned NOT NULL default '0',
  `GuiLangID` int(11) default '2',
  `CanLogin` tinyint(4) unsigned default NULL,
  `CanChangePassword` tinyint(4) unsigned default '1',
  `MustChangePassword` tinyint(4) unsigned default NULL,
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`),
  KEY `Name` (`Name`,`FirstName`)
) ENGINE=MyISAM AUTO_INCREMENT=1327 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PersonLang`
--

DROP TABLE IF EXISTS `PersonLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PersonLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Committee` varchar(255) default NULL,
  `Job` varchar(255) default NULL,
  `ConsultingTime` varchar(255) default NULL,
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PollResults`
--

DROP TABLE IF EXISTS `PollResults`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PollResults` (
  `EntryID` int(11) NOT NULL,
  `Xml` text,
  `Total` int(11) NOT NULL,
  KEY `EntryID` (`EntryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Resource`
--

DROP TABLE IF EXISTS `Resource`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Resource` (
  `ID` char(200) NOT NULL,
  `Lang1` text,
  `Lang2` text,
  `Lang3` text,
  `Lang4` text,
  `Lang5` text,
  `Lang6` text,
  `Lang7` text,
  `Lang8` text,
  `Lang9` text,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=10242 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Room`
--

DROP TABLE IF EXISTS `Room`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Room` (
  `PageID` int(11) unsigned default NULL,
  `Number` char(20) default NULL,
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  `ExtraRoomID1` int(11) unsigned NOT NULL,
  `ExtraRoomID2` int(11) unsigned NOT NULL,
  `uFormSeats` int(11) unsigned NOT NULL,
  `uFormSeats2ndRow` int(11) unsigned NOT NULL,
  `cinemaSeats` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `RoomEvent`
--

DROP TABLE IF EXISTS `RoomEvent`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `RoomEvent` (
  `ID` int(11) NOT NULL auto_increment,
  `FirstEventID` int(11) unsigned default NULL,
  `EventName` varchar(200) default NULL,
  `Topic` varchar(500) default NULL,
  `Notes` varchar(300) default NULL,
  `Organiser` varchar(200) default NULL,
  `OrganiserMail` varchar(200) default NULL,
  `OrganiserTel` varchar(20) default NULL,
  `OrganiserKey` varchar(6) default NULL,
  `RoomID` int(11) unsigned NOT NULL,
  `ExtraRooms` varchar(100) default NULL,
  `cinemaSeating` tinyint(1) unsigned NOT NULL,
  `cinemaSeats` int(11) unsigned NOT NULL,
  `uFormSeats2ndRow` int(11) unsigned NOT NULL,
  `seatingConfirmed` tinyint(1) NOT NULL,
  `DateFrom` int(11) unsigned default NULL,
  `DateTo` int(11) unsigned default NULL,
  `StartDate` int(11) unsigned default NULL,
  `ClosureDate` int(11) unsigned default NULL,
  `Serial` tinyint(4) default NULL,
  `HowOften` int(11) default '7',
  `BookingConfirmed` tinyint(4) default NULL,
  `Kostenstelle` varchar(50) default NULL,
  `SeatingProviderKey` varchar(6) default NULL,
  `specialSeating` tinyint(1) unsigned NOT NULL,
  `NetKey` varchar(6) default NULL,
  `NetConfirmed` tinyint(1) NOT NULL default '-2',
  `AirbusEvent` tinyint(1) unsigned NOT NULL,
  `numberNomadism` int(11) unsigned NOT NULL,
  `numberIntern` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2210 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `RoomEventTechnic`
--

DROP TABLE IF EXISTS `RoomEventTechnic`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `RoomEventTechnic` (
  `ID` int(11) NOT NULL auto_increment,
  `RoomEventID` int(11) unsigned default NULL,
  `Technique` varchar(300) default NULL,
  `Status` int(11) default NULL,
  `ServiceProviderKey` varchar(6) default NULL,
  `ServiceProvider` varchar(200) NOT NULL,
  `RoomPoolID` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=216 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `RoomLang`
--

DROP TABLE IF EXISTS `RoomLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `RoomLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` text,
  `ImageID` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `SearchResult`
--

DROP TABLE IF EXISTS `SearchResult`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `SearchResult` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PageID` int(11) unsigned NOT NULL default '0',
  `SectionID` int(11) unsigned default NULL,
  `BinaryID` int(11) unsigned default NULL,
  `SID` varchar(64) NOT NULL default '',
  `PageRead` text,
  `PageWrite` text,
  `SectionRead` text,
  `SectionWrite` text,
  `Quality` int(11) NOT NULL default '0',
  `Timestamp` int(11) unsigned NOT NULL default '0',
  `ExternalURL` text,
  `ExternalTitle` text,
  PRIMARY KEY  (`ID`),
  KEY `SID` (`SID`)
) ENGINE=MyISAM AUTO_INCREMENT=6668819 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Section`
--

DROP TABLE IF EXISTS `Section`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Section` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `TypeID` int(11) unsigned default '1',
  `PageID` int(11) unsigned default '2',
  `RowPos` int(11) unsigned default NULL,
  `Expires` int(11) unsigned NOT NULL default '0',
  `LastChanged` int(11) unsigned NOT NULL default '0',
  `LastChangedByUserID` int(11) unsigned NOT NULL default '0',
  `ReadAccessIDs` text,
  `WriteAccessIDs` text,
  `ShowTitle` tinyint(4) unsigned default NULL,
  `CustomColumnsWidth` varchar(255) character set utf8 NOT NULL default '0',
  `PublishedVersionID` int(11) NOT NULL default '0',
  `EditVersionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `PageID` (`PageID`),
  KEY `RowPos` (`RowPos`),
  KEY `Expires` (`Expires`)
) ENGINE=MyISAM AUTO_INCREMENT=10321 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `SectionLang`
--

DROP TABLE IF EXISTS `SectionLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `SectionLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Title` varchar(255) default NULL,
  `SearchContent` text,
  `UseMainLanguageContent` tinyint(1) unsigned default NULL,
  PRIMARY KEY  (`ID`,`LangID`),
  FULLTEXT KEY `SearchContent` (`Title`,`SearchContent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Session`
--

DROP TABLE IF EXISTS `Session`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Session` (
  `ID` varchar(64) NOT NULL default '',
  `DATA` text,
  `LASTACCESS` int(11) unsigned default NULL,
  `REMOTE_ADDR` varchar(16) default '',
  `HTTP_USER_AGENT` varchar(255) NOT NULL,
  `UserID` varchar(11) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `UserID` (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `System`
--

DROP TABLE IF EXISTS `System`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `System` (
  `LastDeleteExpired` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Tag`
--

DROP TABLE IF EXISTS `Tag`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Tag` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` varchar(255) NOT NULL,
  PRIMARY KEY  (`ID`,`LangID`),
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `UserGroup`
--

DROP TABLE IF EXISTS `UserGroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `UserGroup` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `UserGroupLang`
--

DROP TABLE IF EXISTS `UserGroupLang`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `UserGroupLang` (
  `ID` int(11) unsigned NOT NULL default '0',
  `LangID` tinyint(4) unsigned NOT NULL default '1',
  `Name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`ID`,`LangID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `XslStyle`
--

DROP TABLE IF EXISTS `XslStyle`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `XslStyle` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `PageMode` tinyint(4) NOT NULL default '-1',
  `Dynamic` varchar(200) default NULL,
  `Entity` varchar(200) default NULL,
  `IsTestXSL` tinyint(4) unsigned NOT NULL default '1',
  `IsLib` tinyint(4) unsigned NOT NULL default '0',
  `TemplMatch` varchar(255) default NULL,
  `TemplName` varchar(255) default NULL,
  `TemplMode` varchar(255) default NULL,
  `Content` mediumtext,
  `Special` varchar(100) default NULL,
  `PagePathID` int(11) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `PageMode` (`PageMode`),
  KEY `Dynamic` (`Dynamic`),
  KEY `Entity` (`Entity`),
  KEY `IsTestXSL` (`IsTestXSL`),
  KEY `Special` (`Special`)
) ENGINE=MyISAM AUTO_INCREMENT=2643 DEFAULT CHARSET=latin1;
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-03-12 15:46:29
