text: CREATE TABLE IF NOT EXISTS `agenda` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `meta_id` int(11) NOT NULL,
    `category_id` int(11) NOT NULL,
    `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
    `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `introduction` text COLLATE utf8_unicode_ci,
    `text` text COLLATE utf8_unicode_ci,
    `whole_day` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT NULL,
    `recurring` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT NULL,
    `begin_date` datetime NOT NULL,
    `end_date` datetime NOT NULL,
    `allow_subscriptions` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
    `num_subscriptions` int(11) NOT NULL,
    `location_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `street` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `zip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `lat` float NOT NULL,
    `lng` float NOT NULL,
    `google_maps` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
    `created_on` datetime NOT NULL,
    `edited_on` datetime NOT NULL,
    `sequence` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=25 ;
  
  CREATE TABLE IF NOT EXISTS `agenda_categories` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `meta_id` int(11) NOT NULL,
    `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
    `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `sequence` int(11) NOT NULL,
    `created_on` datetime NOT NULL,
    `edited_on` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
  
  CREATE TABLE IF NOT EXISTS `agenda_files` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `agenda_id` int(11) NOT NULL,
    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `sequence` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  CREATE TABLE IF NOT EXISTS `agenda_images` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `agenda_id` int(11) NOT NULL,
    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `sequence` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
  
  CREATE TABLE IF NOT EXISTS `agenda_videos` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `agenda_id` int(11) NOT NULL,
    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `filename` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `sequence` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  CREATE TABLE IF NOT EXISTS `agenda_recurring_options` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `agenda_id` int(11) NOT NULL,
    `frequency` int(11) NOT NULL,
    `type` int(11) NOT NULL,
    `interval` int(11) DEFAULT NULL,
    `days` text,
    `ends_on` int(11) NOT NULL,
    `end_date` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
  
  CREATE TABLE IF NOT EXISTS `agenda_subscriptions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `agenda_id` int(11) NOT NULL,
    `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
    `created_on` datetime NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` enum('moderation','subscribed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'moderation',
    PRIMARY KEY (`id`),
    KEY `idx_post_id_status` (`status`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
  