Skip to main content

Content

Categories​

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1- Video, 2- Music',
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Comments​

--
-- Table structure for table `tbl_comment`
--

CREATE TABLE `tbl_comment` (
  `id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL,
  `content_type` int(11) NOT NULL COMMENT '	1- Video, 2- Music, 3- Reels, 4- Podcasts, 5- Playlist, 6- Radio	',
  `content_id` int(11) NOT NULL,
  `episode_id` int(11) NOT NULL DEFAULT 0,
  `comment` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Reports​

--
-- Table structure for table `tbl_comment_report`
--

CREATE TABLE `tbl_comment_report` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `report_user_id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Table structure for table `tbl_content`
--


--
-- Table structure for table `tbl_content_report`
--

CREATE TABLE `tbl_content_report` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `report_user_id` int(11) NOT NULL,
  `content_type` int(11) NOT NULL COMMENT '	1- Video, 2- Music, 3- Reels, 4- Podcasts, 5- Playlist, 6- Radio	',
  `content_id` int(11) NOT NULL,
  `episode_id` int(11) NOT NULL DEFAULT 0,
  `message` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Show​

Episod​

--
-- Table structure for table `tbl_episode`
--

CREATE TABLE `tbl_episode` (
  `id` int(11) NOT NULL,
  `podcasts_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `portrait_img` varchar(255) NOT NULL,
  `landscape_img` varchar(255) NOT NULL,
  `episode_upload_type` varchar(255) NOT NULL COMMENT 'server_video, external_url, youtube',
  `episode_audio` varchar(255) NOT NULL,
  `episode_size` varchar(255) NOT NULL,
  `is_comment` int(11) NOT NULL DEFAULT 0,
  `is_download` int(11) NOT NULL DEFAULT 0,
  `is_like` int(11) NOT NULL DEFAULT 0,
  `total_view` int(11) NOT NULL DEFAULT 0,
  `total_like` int(11) NOT NULL DEFAULT 0,
  `total_dislike` int(11) NOT NULL DEFAULT 0,
  `sortable` int(11) NOT NULL DEFAULT 1,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;