detect_relations: true

article:
  actAs: TimestampBehavior
  options:
    type: INNODB
  columns:
    topic: string
    preview: string
    content: string

article_link:
  options:
    type: INNODB
  columns:
    article_id: integer(10)
    label: string
    url: string

article_view:
  options:
    type: INNODB
  columns:
    article_id: integer
    article: integer(10)
    date: date
    count: integer(10)

news:
  actAs: TimestampBehavior
  options:
    type: INNODB
  columns:
    kind: integer(1)
    topic: string
    preview: string
    content: string

news_comment:
  actAs: TimestampBehavior
  options:
    type: INNODB
  columns:
    news_id: integer(10)
    comment_relation: integer(10)
    impression: integer(1)
    email: string
    topic: string
    content: string

news_link:
  options:
    type: INNODB
  columns:
    news_id: integer(10)
    label: string
    url: string

news_view:
  options:
    type: INNODB
  columns:
   news_id: integer(10)
   date: date
   count: integer(10)


SET time_zone = '+1:00';

USE mguytrunk;

CREATE TABLE `articles` (
  `article_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `article_creation` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `article_last_edit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `article_topic` tinytext NOT NULL,
  `article_preview` text NOT NULL,
  `article_content` mediumtext NOT NULL,
  PRIMARY KEY (`article_id`),
  UNIQUE KEY `creation` (`article_creation`)
) ENGINE=InnoDB COLLATE utf8_unicode_ci DEFAULT CHARSET utf8;

CREATE TABLE `articles_links` (
  `link_article` int(10) unsigned NOT NULL,
  `link_label` tinytext NOT NULL,
  `link_url` tinytext NOT NULL,
  KEY `link_article` (`link_article`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `articles_views` (
  `view_article` int(10) unsigned NOT NULL,
  `view_date` date NOT NULL,
  `view_count` int(10) unsigned NOT NULL,
  UNIQUE KEY `view_article_2` (`view_article`,`view_date`),
  KEY `view_article` (`view_article`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `eh_blob` (
  `eh` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `eh_blob` blob NOT NULL,
  PRIMARY KEY (`eh`)
) ENGINE=InnoDB COLLATE utf8_unicode_ci DEFAULT CHARSET utf8;

CREATE TABLE `news` (
  `news_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `news_kind` INTEGER(1) unsigned NOT NULL DEFAULT 0,
  `news_creation` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `news_lastedit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `news_topic` tinytext NOT NULL,
  `news_preview` text NOT NULL,
  `news_content` mediumtext NOT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=InnoDB COLLATE utf8_unicode_ci DEFAULT CHARSET utf8;

CREATE TABLE `news_comments` (
  `comment_news` int(10) unsigned NOT NULL,
  `comment_creation` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comment_relation` int(10) unsigned NOT NULL,
  `comment_impression` int(1) unsigned DEFAULT 0 NOT NULL,
  `comment_email` tinytext NOT NULL,
  `comment_topic` tinytext NOT NULL,
  `comment_content` text NOT NULL,
  KEY `comment_article` (`comment_news`),
  KEY `comment_creation` (`comment_creation`)
) ENGINE=InnoDB COLLATE utf8_unicode_ci DEFAULT CHARSET utf8;

CREATE TABLE `news_links` (
  `link_news` int(10) unsigned NOT NULL,
  `link_label` tinytext NOT NULL,
  `link_url` tinytext NOT NULL,
  KEY `link_news` (`link_news`)
) ENGINE=InnoDB COLLATE utf8_unicode_ci DEFAULT CHARSET utf8;

CREATE TABLE `news_views` (
  `view_news` int(10) unsigned NOT NULL,
  `view_date` date NOT NULL,
  `view_count` int(10) unsigned NOT NULL,
  UNIQUE KEY `view_article_2` (`view_news`,`view_date`),
  KEY `view_article` (`view_news`)
) ENGINE=InnoDB COLLATE utf8_unicode_ci DEFAULT CHARSET utf8;