CREATE TABLE `comments` (
  `id` int(11) UNSIGNED NOT NULL,
  `comment_id` int(11) UNSIGNED DEFAULT NULL COMMENT 'Reply of specific comment in project',
  `project_content_id` int(11) UNSIGNED DEFAULT NULL,
  `project_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcado de datos para la tabla `comments`
--

INSERT INTO `comments` (`id`, `comment_id`, `project_content_id`, `project_id`, `user_id`, `comment`, `created_at`, `updated_at`) VALUES
(1, NULL, 3, 2, 1, 'Este es un nuevo comentario del proyecto colaborativo.', '2018-11-15 14:04:41', '2018-11-15 14:04:41'),
(2, 1, 3, 2, 260, '<p>orkfrof frpkfrokforkpfk o</p>', '2018-11-15 16:01:47', '2018-11-15 16:01:47'),
(3, 1, 3, 2, 260, '<p>Comentario para el proyecto test proyecto colaborativo</p>', '2018-11-16 15:11:21', '2018-11-16 15:11:21'),
(4, NULL, 3, 2, 260, '<p>Comentario para test proyecto colaborativo</p>', '2018-11-16 15:12:44', '2018-11-16 15:12:44'),
(5, NULL, 9, 2, 260, '<p>Tercer comentario</p>', '2018-11-16 15:16:13', '2018-11-16 15:16:13'),
(6, 5, 9, 2, 260, '<p>Comentario para el tercer comentario</p>', '2018-11-16 15:23:42', '2018-11-16 15:23:42'),
(7, 4, 3, 2, 260, '<p>Comentar comentario</p>', '2018-11-16 19:22:28', '2018-11-16 19:22:28'),
(8, NULL, 13, 2, 260, '<p>Este es un nuevo comentario</p>', '2018-12-13 02:25:49', '2018-12-13 02:25:49'),
(9, NULL, 18, 2, 260, '<p>Comentario para el proyecto 2</p>', '2018-12-13 02:30:09', '2018-12-13 02:30:09'),
(10, 3, 3, 2, 1, '<p>Comentario admin</p>', '2018-12-19 17:00:53', '2018-12-19 17:00:53'),
(11, 3, 3, 2, 261, '<p>Comentario en proyecto colaborativo</p>', '2018-12-19 20:31:48', '2018-12-19 20:31:48');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_comments_projects1_idx` (`project_id`),
  ADD KEY `fk_comments_comments1_idx` (`comment_id`),
  ADD KEY `fk_comments_projects_contents1_idx` (`project_content_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;