-- Adminer 3.7.1 MySQL dump

SET NAMES utf8;
SET foreign_key_checks = 0;
SET time_zone = '+01:00';
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `articles`;
CREATE TABLE `articles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(30) COLLATE utf8_slovak_ci NOT NULL,
  `text` text COLLATE utf8_slovak_ci NOT NULL,
  `author_id` int(10) unsigned NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `author_id` (`author_id`),
  CONSTRAINT `articles_ibfk_1` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

INSERT INTO `articles` (`id`, `title`, `text`, `author_id`, `date_created`) VALUES
(1,	'TEST',	'My money\'s in that office, right? If she start giving me some bullshit about it ain\'t there, and we got to go someplace else and get it, I\'m gonna shoot you in the head then and there. Then I\'m gonna shoot that bitch in the kneecaps, find out where my goddamn money is. She gonna tell me too. Hey, look at me when I\'m talking to you, motherfucker. You listen: we go in there, and that nigga Winston or anybody else is in there, you the first motherfucker to get shot. You understand?\r\n',	1,	'2013-12-08 15:17:31');

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(15) COLLATE utf8_slovak_ci NOT NULL,
  `password` char(40) COLLATE utf8_slovak_ci NOT NULL,
  `role` varchar(10) COLLATE utf8_slovak_ci NOT NULL,
  `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

INSERT INTO `users` (`id`, `username`, `password`, `role`, `register_date`) VALUES
(1,	'lime',	'fde955e73998719e0a85a07ce0f9f08f59a3a8a1',	'member',	'2013-12-08 13:49:03'),
(2,	'honza',	'd00a5d0fb8d645369cbe7829d818d4ed7dbc53e0',	'member',	'2013-12-10 09:55:01');

-- 2013-12-10 16:28:51