DROP TABLE IF EXISTS `work_comment`;
CREATE TABLE `work_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) DEFAULT NULL,
  `task_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` datetime DEFAULT NULL,
  `comment` text COLLATE utf8_czech_ci,
  `confirmed` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `task_id` (`task_id`),
  KEY `user_id` (`user_id`),
  KEY `parent` (`parent`),
  CONSTRAINT `work_comment_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `work_task` (`id`),
  CONSTRAINT `work_comment_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `work_user` (`id`),
  CONSTRAINT `work_comment_ibfk_3` FOREIGN KEY (`parent`) REFERENCES `work_comment` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


DROP TABLE IF EXISTS `work_task`;
CREATE TABLE `work_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8_czech_ci DEFAULT NULL,
  `description` text COLLATE utf8_czech_ci,
  `user_id` int(11) NOT NULL,
  `date` datetime DEFAULT NULL,
  `date_end` datetime DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `state` tinyint(4) NOT NULL DEFAULT '0',
  `confirmed` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `work_task_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `work_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;