CREATE DATABASE IF NOT EXISTS calendar;
USE calendar;

DROP TABLE IF EXISTS `calendar`.`accessright`;
CREATE TABLE  `calendar`.`accessright` (
  `accessRightId` int(11) NOT NULL auto_increment,
  `parameters` text,
  `interceptionPointId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`accessRightId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`accessrightgroup`;
CREATE TABLE  `calendar`.`accessrightgroup` (
  `accessRightGroupId` int(11) NOT NULL auto_increment,
  `accessRightId` int(11) NOT NULL default '0',
  `groupName` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`accessRightGroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`accessrightrole`;
CREATE TABLE  `calendar`.`accessrightrole` (
  `accessRightRoleId` int(11) NOT NULL auto_increment,
  `accessRightId` int(11) NOT NULL default '0',
  `roleName` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`accessRightRoleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`accessrightuser`;
CREATE TABLE  `calendar`.`accessrightuser` (
  `accessRightUserId` int(11) NOT NULL auto_increment,
  `accessRightId` int(11) NOT NULL default '0',
  `userName` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`accessRightUserId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`asset`;
CREATE TABLE  `calendar`.`asset` (
  `id` bigint(20) NOT NULL auto_increment,
  `assetKey` varchar(85) default NULL,
  `assetBlob` blob NOT NULL,
  `event_id` bigint(20) default NULL,
  `fileName` varchar(85) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FKEF86282E1093C0E0` (`event_id`),
  KEY `FKEF86282E41A9A85C` (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`calendar`;
CREATE TABLE  `calendar`.`calendar` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(85) default NULL,
  `description` varchar(85) default NULL,
  `owner` varchar(85) default NULL,
  `eventtype_id` bigint(20) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`calendar_group`;
CREATE TABLE  `calendar`.`calendar_group` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `calendar_id` bigint(20) unsigned default '0',
  `groupName` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`calendar_language`;
CREATE TABLE  `calendar`.`calendar_language` (
  `calendar_id` bigint(20) NOT NULL default '0',
  `language_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`calendar_id`,`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`calendar_role`;
CREATE TABLE  `calendar`.`calendar_role` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `calendar_id` bigint(20) unsigned default '0',
  `roleName` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=137 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`category`;
CREATE TABLE  `calendar`.`category` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `active` tinyint(4) NOT NULL default '1',
  `parent_id` int(11) default NULL,
  `internalName` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`content_type_definition`;
CREATE TABLE  `calendar`.`content_type_definition` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `schemaValue` text NOT NULL,
  `name` varchar(255) NOT NULL default '',
  `type` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`entry`;
CREATE TABLE  `calendar`.`entry` (
  `id` bigint(20) NOT NULL auto_increment,
  `firstName` varchar(85) default NULL,
  `lastName` varchar(85) default NULL,
  `email` varchar(85) default NULL,
  `event_id` bigint(20) default NULL,
  `organisation` varchar(85) default NULL,
  `address` varchar(85) default NULL,
  `zipcode` varchar(85) default NULL,
  `city` varchar(85) default NULL,
  `phone` varchar(85) default NULL,
  `fax` varchar(85) default NULL,
  `message` varchar(85) default NULL,
  `metadata` text,
  `attributes` text,
  PRIMARY KEY  (`id`),
  KEY `FK40018521093C0E0` (`event_id`),
  KEY `FK400185241A9A85C` (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=148 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`event`;
CREATE TABLE  `calendar`.`event` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(85) default NULL,
  `description` varchar(85) default NULL,
  `endDateTime` datetime default NULL,
  `startDateTime` datetime default NULL,
  `calendar_id` bigint(20) default NULL,
  `lecturer` varchar(85) default NULL,
  `isOrganizedByGU` tinyint(1) default NULL,
  `lastRegistrationDateTime` datetime default NULL,
  `longDescription` text,
  `maximumParticipants` int(11) default NULL,
  `contactEmail` varchar(85) default NULL,
  `shortDescription` text,
  `organizerName` varchar(85) default NULL,
  `contactPhone` varchar(85) default NULL,
  `price` varchar(255) default NULL,
  `customLocation` varchar(85) default NULL,
  `isInternal` tinyint(1) default NULL,
  `eventUrl` varchar(85) default NULL,
  `contactName` varchar(85) default NULL,
  `stateId` tinyint(1) default NULL,
  `creator` varchar(255) default NULL,
  `alternativeLocation` varchar(255) default NULL,
  `entryFormId` int(10) unsigned default NULL,
  `attributes` text,
  PRIMARY KEY  (`id`),
  KEY `FK403827A1818C5BC` (`calendar_id`),
  KEY `name` (`name`),
  KEY `FK403827A20EA88D8` (`calendar_id`)
) ENGINE=MyISAM AUTO_INCREMENT=216 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`event_calendar`;
CREATE TABLE  `calendar`.`event_calendar` (
  `event_id` bigint(20) NOT NULL default '0',
  `calendar_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`event_id`,`calendar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`event_category`;
CREATE TABLE  `calendar`.`event_category` (
  `id` bigint(20) NOT NULL auto_increment,
  `event_id` bigint(20) default '0',
  `category_id` bigint(20) NOT NULL default '0',
  `eventtype_categoryattribute_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1032 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`event_location`;
CREATE TABLE  `calendar`.`event_location` (
  `event_id` bigint(20) NOT NULL default '0',
  `location_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`event_id`,`location_id`),
  KEY `FK5DDBFA20EBB9E5` (`location_id`),
  KEY `FK5DDBFA1093C0E0` (`event_id`),
  KEY `FK5DDBFA41A9A85C` (`event_id`),
  KEY `FK5DDBFAA5AE2178` (`location_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`event_version`;
CREATE TABLE  `calendar`.`event_version` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `lecturer` varchar(1024) default NULL,
  `longDescription` text,
  `contactEmail` varchar(255) default NULL,
  `shortDescription` text,
  `organizerName` varchar(255) default NULL,
  `contactPhone` varchar(255) default NULL,
  `price` varchar(255) default NULL,
  `customLocation` varchar(255) default NULL,
  `eventUrl` varchar(255) default NULL,
  `contactName` varchar(255) default NULL,
  `event_id` int(11) default NULL,
  `attributes` text,
  `alternativeLocation` varchar(255) default NULL,
  `language_id` bigint(20) unsigned default NULL,
  `title` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`events`;
CREATE TABLE  `calendar`.`events` (
  `uid_1` bigint(20) NOT NULL default '0',
  `elm_1` varchar(85) default NULL,
  KEY `FKB307E1196A1FC02` (`uid_1`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`eventtype`;
CREATE TABLE  `calendar`.`eventtype` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `schemaValue` text,
  `type` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`eventtype_category`;
CREATE TABLE  `calendar`.`eventtype_category` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `eventtype_id` bigint(20) NOT NULL default '0',
  `category_id` bigint(20) NOT NULL default '0',
  `internalName` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`interceptionpoint`;
CREATE TABLE  `calendar`.`interceptionpoint` (
  `id` int(11) NOT NULL auto_increment,
  `category` text NOT NULL,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `uses_extra_data` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`language`;
CREATE TABLE  `calendar`.`language` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `isoCode` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `calendar`.`location`;
CREATE TABLE  `calendar`.`location` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(85) default NULL,
  `description` varchar(85) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`locations`;
CREATE TABLE  `calendar`.`locations` (
  `uid_4` bigint(20) NOT NULL default '0',
  `elm_4` varchar(85) default NULL,
  KEY `FKB8A4575E6A1FC05` (`uid_4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`participant`;
CREATE TABLE  `calendar`.`participant` (
  `id` bigint(20) NOT NULL auto_increment,
  `userName` varchar(85) default NULL,
  `event_id` bigint(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `FK912797131093C0E0` (`event_id`),
  KEY `FK9127971341A9A85C` (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=187 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`property`;
CREATE TABLE  `calendar`.`property` (
  `id` bigint(20) NOT NULL auto_increment,
  `nameSpace` varchar(100) NOT NULL default '',
  `name` varchar(155) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`resources`;
CREATE TABLE  `calendar`.`resources` (
  `uid_3` bigint(20) NOT NULL default '0',
  `elm_3` varchar(85) default NULL,
  KEY `FK89CCBE256A1FC04` (`uid_3`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `calendar`.`subscriber`;
CREATE TABLE  `calendar`.`subscriber` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `calendar_id` bigint(20) unsigned default '0',
  `email` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;