CREATE TABLE `project_contents` (
  `id` int(11) UNSIGNED NOT NULL,
  `project_id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL COMMENT 'Content creator',
  `description` text NOT NULL COLLATE utf8_unicode_ci,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-Only text, 2-Text and image, 3-Text and file, 4-Text and video(url youtube), 5-Text image and file, 6-Text video and file',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-Inactive, 1-Active, 2-Pending, 3-In review, 4-Not approved',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indices de la tabla `project_contents`
--
ALTER TABLE `project_contents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_project_contents_projects1_idx` (`project_id`),
  ADD KEY `fk_project_contents_users1_idx` (`user_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

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