text: -- Adminer 3.2.2 MySQL dump
  
  SET NAMES utf8;
  SET foreign_key_checks = 0;
  SET time_zone = 'SYSTEM';
  SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  
  DROP TABLE IF EXISTS `article`;
  CREATE TABLE `article` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(11) unsigned NOT NULL DEFAULT 0,
    `published_at` datetime NOT NULL DEFAULT 0,
    `title` varchar(100) NOT NULL DEFAULT '',
    `content` text NOT NULL DEFAULT '',
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    CONSTRAINT `article_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `article` (`id`, `user_id`, `published_at`, `title`, `content`) VALUES
  (1,	1,	'2011-12-10 12:10:00',	'article 1',	'content 1'),
  (2,	2,	'2011-12-20 16:20:00',	'article 2',	'content 2'),
  (3,	1,	'2012-01-04 22:00:00',	'article 3',	'content 3');
  
  DROP TABLE IF EXISTS `comment`;
  CREATE TABLE `comment` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `article_id` int(11) unsigned NOT NULL,
    `user_id` int(11) unsigned NOT NULL,
    `content` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `article_id` (`article_id`),
    KEY `user_id` (`user_id`),
    CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`),
    CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `comment` (`id`, `article_id`, `user_id`, `content`) VALUES
  (1,	1,	2,	'comment 1.1'),
  (2,	1,	1,	'comment 1.2'),
  (3,	2,	1,	'comment 2.1');
  
  DROP TABLE IF EXISTS `country`;
  CREATE TABLE `country` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(20) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `country` (`id`, `name`) VALUES
  (1,	'Slovakia');
  
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `country_id` int(11) unsigned NOT NULL,
    `type` enum('admin','author') NOT NULL,
    `name` varchar(20) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `country_id` (`country_id`),
    CONSTRAINT `user_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `user` (`id`, `country_id`, `type`, `name`) VALUES
  (1,	1,	'admin',	'Marek'),
  (2,	1,	'author',	'Robert');
  
  -- 2012-01-04 22:00:18