-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 07, 2026 at 03:54 PM
-- Server version: 10.11.19-MariaDB
-- PHP Version: 8.4.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `czjobs6_s1lv3r51`
--

-- --------------------------------------------------------

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `author_id` bigint(20) UNSIGNED NOT NULL,
  `title_bn` varchar(255) NOT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `excerpt_bn` text DEFAULT NULL,
  `excerpt_en` text DEFAULT NULL,
  `body_bn` longtext NOT NULL,
  `body_en` longtext DEFAULT NULL,
  `featured_image` varchar(500) DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `status` enum('draft','pending_review','verified','published','archived') NOT NULL DEFAULT 'draft',
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `is_verified` tinyint(1) NOT NULL DEFAULT 0,
  `view_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `article_categories`
--

CREATE TABLE `article_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_bn` varchar(150) NOT NULL,
  `name_en` varchar(150) DEFAULT NULL,
  `slug` varchar(180) NOT NULL,
  `description_bn` text DEFAULT NULL,
  `description_en` text DEFAULT NULL,
  `status` enum('draft','pending_review','verified','published') NOT NULL DEFAULT 'published',
  `is_verified` tinyint(1) NOT NULL DEFAULT 0,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `article_categories`
--

INSERT INTO `article_categories` (`id`, `name_bn`, `name_en`, `slug`, `description_bn`, `description_en`, `status`, `is_verified`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'চলচ্চিত্র ইতিহাস', 'Film History', 'film-history', 'বাংলা চলচ্চিত্রের ঐতিহাসিক ঘটনাবলী ও বিশ্লেষণ।', NULL, 'published', 1, 1, 1, '2026-09-21 14:16:23', '2026-09-21 14:16:23'),
(2, 'সংবাদ ও সমসাময়িক', 'News & Updates', 'news-updates', 'চলচ্চিত্র জগতের সাম্প্রতিক সংবাদ ও খবর।', NULL, 'published', 1, 2, 1, '2026-09-21 14:16:23', '2026-09-21 14:16:23'),
(3, 'জীবনী ও স্মৃতিচারণ', 'Biography & Memories', 'biography-memories', 'চলচ্চিত্র ব্যক্তিত্বদের জীবনকথা ও স্মৃতিচারণমূলক লেখা।', NULL, 'published', 1, 3, 1, '2026-09-21 14:16:23', '2026-09-21 14:16:23'),
(4, 'সাক্ষাৎকার', 'Interviews', 'interviews', 'নির্মাতা ও কলাকুশলীদের সাক্ষাৎকার।', NULL, 'published', 1, 4, 1, '2026-09-21 14:16:23', '2026-09-21 14:16:23'),
(5, 'চলচ্চিত্র বিশ্লেষণ', 'Film Analysis', 'film-analysis', 'বিভিন্ন কালজয়ী চলচ্চিত্রের গভীর পর্যালোচনা ও বিশ্লেষণ।', NULL, 'published', 1, 5, 1, '2026-09-21 14:16:23', '2026-09-21 14:16:23');

-- --------------------------------------------------------

--
-- Table structure for table `awards`
--

CREATE TABLE `awards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_bn` varchar(150) NOT NULL,
  `name_en` varchar(150) DEFAULT NULL,
  `slug` varchar(180) NOT NULL,
  `description_bn` text DEFAULT NULL,
  `description_en` text DEFAULT NULL,
  `country` varchar(100) NOT NULL DEFAULT 'Bangladesh',
  `first_edition_year` year(4) DEFAULT NULL,
  `logo` varchar(500) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `award_categories`
--

CREATE TABLE `award_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `award_id` bigint(20) UNSIGNED NOT NULL,
  `name_bn` varchar(150) NOT NULL,
  `name_en` varchar(150) DEFAULT NULL,
  `slug` varchar(180) NOT NULL,
  `description_bn` text DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `award_nominations`
--

CREATE TABLE `award_nominations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `award_id` bigint(20) UNSIGNED NOT NULL,
  `award_category_id` bigint(20) UNSIGNED NOT NULL,
  `content_id` bigint(20) UNSIGNED DEFAULT NULL,
  `person_id` bigint(20) UNSIGNED DEFAULT NULL,
  `year` year(4) NOT NULL,
  `edition` varchar(50) DEFAULT NULL,
  `is_winner` tinyint(1) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contents`
--

CREATE TABLE `contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `content_type_id` bigint(20) UNSIGNED NOT NULL,
  `title_bn` varchar(255) NOT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `alternative_titles` varchar(500) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `release_date` date DEFAULT NULL,
  `release_year` smallint(5) UNSIGNED DEFAULT NULL,
  `release_month` tinyint(3) UNSIGNED DEFAULT NULL,
  `release_day` tinyint(3) UNSIGNED DEFAULT NULL,
  `runtime_minutes` smallint(5) UNSIGNED DEFAULT NULL,
  `episodes_count` smallint(5) UNSIGNED DEFAULT NULL,
  `seasons_count` smallint(5) UNSIGNED DEFAULT NULL,
  `synopsis_bn` text DEFAULT NULL,
  `synopsis_en` text DEFAULT NULL,
  `story_bn` longtext DEFAULT NULL,
  `story_en` longtext DEFAULT NULL,
  `language` varchar(50) NOT NULL DEFAULT 'Bengali',
  `country` varchar(100) NOT NULL DEFAULT 'Bangladesh',
  `production_status` enum('upcoming','released','in_production','cancelled') NOT NULL DEFAULT 'released',
  `box_office_status` enum('blockbuster','superhit','hit','average','flop','unknown') DEFAULT NULL,
  `budget` varchar(100) DEFAULT NULL,
  `box_office` varchar(100) DEFAULT NULL,
  `poster` varchar(500) DEFAULT NULL,
  `cover_image` varchar(500) DEFAULT NULL,
  `trailer_url` varchar(500) DEFAULT NULL,
  `status` enum('draft','pending_review','verified','published') NOT NULL DEFAULT 'draft',
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `view_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` (`id`, `content_type_id`, `title_bn`, `title_en`, `alternative_titles`, `slug`, `release_date`, `release_year`, `release_month`, `release_day`, `runtime_minutes`, `episodes_count`, `seasons_count`, `synopsis_bn`, `synopsis_en`, `story_bn`, `story_en`, `language`, `country`, `production_status`, `box_office_status`, `budget`, `box_office`, `poster`, `cover_image`, `trailer_url`, `status`, `is_featured`, `view_count`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'টেস্ট', 'TEST', NULL, 'test', '2026-09-01', 2026, 9, 1, 120, NULL, NULL, 'এটি স্যাম্পল সিনোপসিস', 'This is a sample synopsis.', NULL, NULL, 'Bengali', 'Bangladesh', 'released', 'unknown', NULL, NULL, NULL, NULL, NULL, 'published', 0, 0, '2026-09-23 14:10:24', '2026-09-23 14:10:24', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `content_genres`
--

CREATE TABLE `content_genres` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `content_id` bigint(20) UNSIGNED NOT NULL,
  `genre_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_genres`
--

INSERT INTO `content_genres` (`id`, `content_id`, `genre_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2026-09-23 14:10:24', '2026-09-23 14:10:24');

-- --------------------------------------------------------

--
-- Table structure for table `content_people`
--

CREATE TABLE `content_people` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `content_id` bigint(20) UNSIGNED NOT NULL,
  `person_id` bigint(20) UNSIGNED NOT NULL,
  `profession_id` bigint(20) UNSIGNED NOT NULL,
  `character_name` varchar(255) DEFAULT NULL,
  `credit_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `notes` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `content_types`
--

CREATE TABLE `content_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_bn` varchar(100) NOT NULL,
  `name_en` varchar(100) NOT NULL,
  `slug` varchar(120) NOT NULL,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_types`
--

INSERT INTO `content_types` (`id`, `name_bn`, `name_en`, `slug`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'পূর্ণদৈর্ঘ্য চলচ্চিত্র', 'Feature Film', 'feature-film', 1, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(2, 'স্বল্পদৈর্ঘ্য চলচ্চিত্র', 'Short Film', 'short-film', 2, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(3, 'প্রামাণ্যচিত্র', 'Documentary', 'documentary', 3, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(4, 'একক নাটক', 'TV Drama', 'tv-drama', 4, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(5, 'ধারাবাহিক নাটক', 'TV Drama Serial', 'tv-drama-serial', 5, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(6, 'টেলিফিল্ম', 'Telefilm', 'telefilm', 6, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(7, 'ওয়েব সিরিজ', 'Web Series', 'web-series', 7, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(8, 'ওয়েব ফিল্ম', 'Web Film', 'web-film', 8, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(9, 'ক্ষুদ্র ধারাবাহিক', 'Micro Drama Series', 'micro-drama-series', 9, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(10, 'মিউজিক ভিডিও', 'Music Video', 'music-video', 10, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20'),
(11, 'বিজ্ঞাপন', 'Advertisement', 'advertisement', 11, 1, '2026-09-21 15:00:20', '2026-09-21 15:00:20');

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `genres`
--

CREATE TABLE `genres` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_bn` varchar(100) NOT NULL,
  `name_en` varchar(100) NOT NULL,
  `slug` varchar(120) NOT NULL,
  `description_bn` text DEFAULT NULL,
  `description_en` text DEFAULT NULL,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `genres`
--

INSERT INTO `genres` (`id`, `name_bn`, `name_en`, `slug`, `description_bn`, `description_en`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'অ্যাকশন', 'Action', 'action', NULL, NULL, 1, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(2, 'নাটকীয় / ড্রামা', 'Drama', 'drama', NULL, NULL, 2, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(3, 'প্রণয় / রোমান্স', 'Romance', 'romance', NULL, NULL, 3, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(4, 'কমেডি / হাস্যরসাত্মক', 'Comedy', 'comedy', NULL, NULL, 4, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(5, 'থ্রিলার', 'Thriller', 'thriller', NULL, NULL, 5, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(6, 'রহস্য / মিস্ট্রি', 'Mystery', 'mystery', NULL, NULL, 6, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(7, 'ভৌতিক / হরর', 'Horror', 'horror', NULL, NULL, 7, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(8, 'অপরাধ / ক্রাইম', 'Crime', 'crime', NULL, NULL, 8, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(9, 'ঐতিহাসিক', 'Historical', 'historical', NULL, NULL, 9, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(10, 'যুদ্ধভিত্তিক', 'War', 'war', NULL, NULL, 10, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(11, 'জীবনীভিত্তিক', 'Biographical', 'biographical', NULL, NULL, 11, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(12, 'পারিবারিক', 'Family', 'family', NULL, NULL, 12, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(13, 'সঙ্গীতধর্মী / মিউজিক্যাল', 'Musical', 'musical', NULL, NULL, 13, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(14, 'কাল্পনিক / ফ্যান্টাসি', 'Fantasy', 'fantasy', NULL, NULL, 14, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(15, 'বিজ্ঞান কল্পকাহিনী / সাই-ফাই', 'Sci-Fi', 'sci-fi', NULL, NULL, 15, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(16, 'অ্যানিমেশন', 'Animation', 'animation', NULL, NULL, 16, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(17, 'সামাজিক', 'Social', 'social', NULL, NULL, 17, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46'),
(18, 'রাজনৈতিক', 'Political', 'political', NULL, NULL, 18, 1, '2026-09-21 15:07:46', '2026-09-21 15:07:46');

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_09_20_170323_create_settings_table', 2),
(5, '2026_09_20_171758_create_professions_table', 3),
(6, '2026_09_21_155525_create_people_table', 4),
(7, '2026_09_21_155839_create_person_roles_table', 5),
(8, '2026_09_21_160121_add_foreign_keys_to_person_roles_table', 6),
(9, '2026_09_21_161246_create_article_categories_table', 7),
(10, '2026_09_21_161827_create_articles_table', 8),
(11, '2026_09_21_162038_create_tags_and_taggables_tables', 9),
(12, '2026_09_21_165721_create_content_types_table', 10),
(13, '2026_09_21_170253_create_contents_table', 11),
(14, '2026_09_21_170532_create_genres_table', 12),
(15, '2026_09_21_170921_create_content_genres_table', 13),
(16, '2026_09_21_171228_create_content_people_table', 14),
(17, '2026_09_23_153917_add_roles_and_profile_fields_to_users_table', 15),
(18, '2026_09_23_155422_create_reviews_table', 16),
(19, '2026_09_23_161809_add_is_spoiler_to_reviews_table', 17),
(20, '2026_09_23_163715_create_awards_tables', 18);

-- --------------------------------------------------------

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `people`
--

CREATE TABLE `people` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_bn` varchar(255) NOT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `profile_image` varchar(500) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `birth_day` tinyint(3) UNSIGNED DEFAULT NULL,
  `birth_month` tinyint(3) UNSIGNED DEFAULT NULL,
  `death_date` date DEFAULT NULL,
  `death_day` tinyint(3) UNSIGNED DEFAULT NULL,
  `death_month` tinyint(3) UNSIGNED DEFAULT NULL,
  `birth_place` varchar(255) DEFAULT NULL,
  `nationality` varchar(100) DEFAULT 'Bangladeshi',
  `biography_bn` longtext DEFAULT NULL,
  `biography_en` longtext DEFAULT NULL,
  `status` enum('draft','pending_review','verified','published') NOT NULL DEFAULT 'draft',
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `person_roles`
--

CREATE TABLE `person_roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `person_id` bigint(20) UNSIGNED NOT NULL,
  `profession_id` bigint(20) UNSIGNED NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `professions`
--

CREATE TABLE `professions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_bn` varchar(100) NOT NULL,
  `name_en` varchar(100) NOT NULL,
  `slug` varchar(120) NOT NULL,
  `description_bn` text DEFAULT NULL,
  `description_en` text DEFAULT NULL,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `professions`
--

INSERT INTO `professions` (`id`, `name_bn`, `name_en`, `slug`, `description_bn`, `description_en`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'প্রযোজক', 'Producer', 'producer', NULL, NULL, 20, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(2, 'সহ-প্রযোজক', 'Co-Producer', 'co-producer', NULL, NULL, 21, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(3, 'নির্বাহী প্রযোজক', 'Executive Producer', 'executive-producer', NULL, NULL, 22, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(4, 'প্রযোজনা ব্যবস্থাপক', 'Production Manager', 'production-manager', NULL, NULL, 23, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(5, 'ব্যবস্থাপনা সহকারী', 'Production Crew', 'production-crew', NULL, NULL, 24, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(6, 'কাহিনিকার', 'Story Writer', 'story-writer', NULL, NULL, 30, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(7, 'চিত্রনাট্যকার', 'Screenwriter', 'screenwriter', NULL, NULL, 31, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(8, 'সংলাপ লেখক', 'Dialogue Writer', 'dialogue-writer', NULL, NULL, 32, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(9, 'অভিনেতা', 'Actor', 'actor', NULL, NULL, 1, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(10, 'অভিনেত্রী', 'Actress', 'actress', NULL, NULL, 2, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(11, 'খল অভিনেতা', 'Antagonist (Male)', 'antagonist-male', NULL, NULL, 3, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(12, 'খল অভিনেত্রী', 'Antagonist (Female)', 'antagonist-female', NULL, NULL, 4, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(13, 'পরিচালক', 'Director', 'director', NULL, NULL, 10, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(14, 'প্রধান সহকারী পরিচালক', 'Chief Assistant Director', 'chief-assistant-director', NULL, NULL, 11, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(15, 'সহকারী পরিচালক', 'Assistant Director', 'assistant-director', NULL, NULL, 12, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(16, 'অ্যাকশন দৃশ্য পরিচালক', 'Action Director / Stunt Coordinator', 'action-director', NULL, NULL, 13, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(17, 'সহকারী অ্যাকশন দৃশ্য পরিচালক', 'Assistant Action Director', 'assistant-action-director', NULL, NULL, 14, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(18, 'নৃত্য পরিচালক', 'Choreographer', 'choreographer', NULL, NULL, 15, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(19, 'সহকারী নৃত্য পরিচালক', 'Assistant Choreographer', 'assistant-choreographer', NULL, NULL, 16, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(20, 'চিত্রগ্রাহক', 'Cinematographer', 'cinematographer', NULL, NULL, 40, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(21, 'সহকারী চিত্রগ্রাহক', 'Assistant Cinematographer', 'assistant-cinematographer', NULL, NULL, 41, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(22, 'আলোক নির্দেশক', 'Gaffer / Lighting Designer', 'gaffer-lighting-designer', NULL, NULL, 42, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(23, 'সহকারী আলোক নির্দেশক', 'Assistant Lighting Designer', 'assistant-lighting-designer', NULL, NULL, 43, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(24, 'সম্পাদক', 'Editor', 'editor', NULL, NULL, 50, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(25, 'সহকারী সম্পাদক', 'Assistant Editor', 'assistant-editor', NULL, NULL, 51, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(26, 'কালারিস্ট', 'Colorist', 'colorist', NULL, NULL, 52, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(27, 'ভিএফএক্স শিল্পী', 'VFX Artist', 'vfx-artist', NULL, NULL, 53, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(28, 'শব্দ পরিকল্পক', 'Sound Designer', 'sound-designer', NULL, NULL, 60, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(29, 'শব্দগ্রাহক', 'Sound Recordist', 'sound-recordist', NULL, NULL, 61, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(30, 'শব্দ পুনঃসংযোজক', 'Sound Re-recording Mixer', 'sound-mixer', NULL, NULL, 62, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(31, 'সহকারী শব্দগ্রাহক', 'Assistant Sound Recordist', 'assistant-sound-recordist', NULL, NULL, 63, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(32, 'আবহ সঙ্গীত', 'Background Music', 'background-music', NULL, NULL, 64, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(33, 'সঙ্গীত পরিচালক', 'Music Director', 'music-director', NULL, NULL, 70, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(34, 'সুরকার', 'Composer', 'composer', NULL, NULL, 71, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(35, 'গীতিকার', 'Lyricist', 'lyricist', NULL, NULL, 72, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(36, 'কণ্ঠশিল্পী', 'Playback Singer', 'playback-singer', NULL, NULL, 73, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(37, 'সহকারী সঙ্গীত পরিচালক', 'Assistant Music Director', 'assistant-music-director', NULL, NULL, 74, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(38, 'শিল্প নির্দেশক', 'Art Director', 'art-director', NULL, NULL, 80, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(39, 'প্রোডাকশন ডিজাইনার', 'Production Designer', 'production-designer', NULL, NULL, 81, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(40, 'সহকারী শিল্প নির্দেশক', 'Assistant Art Director', 'assistant-art-director', NULL, NULL, 82, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(41, 'পোশাক পরিকল্পক', 'Costume Designer', 'costume-designer', NULL, NULL, 83, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(42, 'সহকারী পোশাক পরিকল্পক', 'Assistant Costume Designer', 'assistant-costume-designer', NULL, NULL, 84, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(43, 'রূপসজ্জাকর', 'Makeup Artist', 'makeup-artist', NULL, NULL, 85, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04'),
(44, 'সহকারী রূপসজ্জাকর', 'Assistant Makeup Artist', 'assistant-makeup-artist', NULL, NULL, 86, 1, '2026-09-20 15:43:04', '2026-09-20 15:43:04');

-- --------------------------------------------------------

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `content_id` bigint(20) UNSIGNED NOT NULL,
  `rating` tinyint(3) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'approved',
  `is_spoiler` tinyint(1) NOT NULL DEFAULT 0,
  `has_spoilers` tinyint(1) NOT NULL DEFAULT 0,
  `helpful_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`id`, `user_id`, `content_id`, `rating`, `title`, `body`, `status`, `is_spoiler`, `has_spoilers`, `helpful_count`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 7, 'TEST', 'TEST', 'approved', 0, 0, 0, '2026-09-23 14:19:21', '2026-09-23 14:19:41');

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('4QtaqOUu5SNmj3D1aaLN6fYw1jCWuRpkcguuLynz', NULL, '205.210.31.195', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidnRxN25zdWxQNm5jdFd4aDd3bzN3ajZpYzVPYnpUSzdCZ3RhYzlqdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vd3d3LnNzLmN6am9iczR1LmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1791088631),
('b9fUhFM3Vm4IEHCneEytAUwogyagDgbvut0ELcPk', NULL, '198.235.24.194', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoib0ZFZlB0OHA4N0MxWlRaR2lUU0xrVjFKR0tyN3E2Vk9JNXpmYXpsSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vd3d3LnNzLmN6am9iczR1LmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1791086677),
('CraL8FftHlAHiaaQ7r4dQVfJRfuuYSgyK8u3lGpP', NULL, '192.71.103.197', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/122.0.6261.89 Mobile/15E148 Safari/604', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYjF3OG03VVRZa1YwMU0weGwyQVp5ZHJNam10MUtCb2RGUXhxVnNCayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjQ6Imh0dHA6Ly9zaWx2ZXJzdG9yaWVzLnh5eiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1791082495),
('fPLb1IbPDqBGHMOSXgF91fv06qRDxUb18m9OfkpK', NULL, '35.94.17.39', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoickJxVHZnNFpWTTdSMmNyYnlPa29tcTVnWEdXQmJvSlRncjZmaXNzYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vc2lsdmVyc3Rvcmllcy54eXoiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1791088430),
('oRQnObNmWbsfB1T7CILMeprLr2I5AdfiMXUVECS6', NULL, '43.153.74.75', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieDZXWHVmNGxmdjBYMmJHQVplYnR1cnpoWnkwdVVJblo2czVpdURjOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjQ6Imh0dHA6Ly9zaWx2ZXJzdG9yaWVzLnh5eiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1791086112),
('tMQw3l9zHYeFm6HfKmMOu0TouSqq47JKGSZK4SQt', NULL, '66.132.195.66', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiR0dWTHg3TGdndFpOcENKbk9VUFFPdjRNdXZkZ2g4Sjl3dHpTakRUaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly93d3cuc3MuY3pqb2JzNHUuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1791081772),
('UOHktjzOM26hofaujOrrwwFkFzD6rHtICrIrCA9Q', NULL, '43.167.239.66', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYnhubFhha1FtS2g1RjVuVmJRZFo3TUVCQTZ5U2dqRFhpdk9HemVxUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly93d3cuc2lsdmVyc3Rvcmllcy54eXoiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1791089126);

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(150) NOT NULL,
  `value` text DEFAULT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'string',
  `group` varchar(50) NOT NULL DEFAULT 'general',
  `description_bn` varchar(500) DEFAULT NULL,
  `description_en` varchar(500) DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `description_bn`, `description_en`, `is_public`, `created_at`, `updated_at`) VALUES
(1, 'verification_enabled', '0', 'boolean', 'content', 'পুরো content system-এর verification workflow চালু বা বন্ধ করবে।', 'Enable or disable the verification workflow for the entire content system.', 0, '2026-09-20 15:11:06', '2026-09-21 16:19:23'),
(2, 'site_name_bn', 'সিলভার স্টোরিজ', 'string', 'general', 'ওয়েবসাইটের বাংলা নাম', 'Website name in Bengali', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(3, 'site_name_en', 'Silver Stories', 'string', 'general', 'ওয়েবসাইটের ইংরেজি নাম', 'Website name in English', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(4, 'site_tagline_bn', 'বাংলা চলচ্চিত্রের সমৃদ্ধ ডিজিটাল আর্কাইভ', 'string', 'general', 'ওয়েবসাইটের ট্যাগলাইন (বাংলা)', 'Website tagline in Bengali', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(5, 'site_tagline_en', 'Comprehensive Digital Archive of Bengali Cinema', 'string', 'general', 'ওয়েবসাইটের ট্যাগলাইন (ইংরেজি)', 'Website tagline in English', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(6, 'site_description_bn', 'সিলভার স্টোরিজ হলো বাংলা চলচ্চিত্র, নাটক, এবং সৃজনশীল কলাকুশলীদের তথ্যের একটি উন্মুক্ত ডাটাবেজ।', 'text', 'general', 'ওয়েবসাইট পরিচিতি (বাংলা)', 'Website description in Bengali', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(7, 'site_logo', NULL, 'image', 'general', 'সাইট লোগো', 'Site logo image path', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(8, 'site_favicon', NULL, 'image', 'general', 'সাইট ফেভিকন', 'Site favicon image path', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(9, 'contact_email', 'contact@silverstories.xyz', 'string', 'contact', 'যোগাযোগের অফিসিয়াল ইমেইল', 'Official contact email', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(10, 'contact_phone', NULL, 'string', 'contact', 'যোগাযোগের ফোন নম্বর', 'Contact phone number', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(11, 'social_facebook', 'https://facebook.com', 'string', 'social', 'ফেসবুক পেজ লিংক', 'Facebook page URL', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(12, 'social_youtube', 'https://youtube.com', 'string', 'social', 'ইউটিউব চ্যানেল লিংক', 'YouTube channel URL', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23'),
(13, 'social_x', 'https://x.com', 'string', 'social', 'এক্স (টুইটার) প্রোফাইল লিংক', 'X (Twitter) profile URL', 1, '2026-09-21 16:19:23', '2026-09-21 16:19:23');

-- --------------------------------------------------------

--
-- Table structure for table `taggables`
--

CREATE TABLE `taggables` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tag_id` bigint(20) UNSIGNED NOT NULL,
  `taggable_type` varchar(120) NOT NULL,
  `taggable_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_bn` varchar(100) NOT NULL,
  `name_en` varchar(100) DEFAULT NULL,
  `slug` varchar(120) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `role` varchar(30) NOT NULL DEFAULT 'user',
  `status` varchar(20) NOT NULL DEFAULT 'active',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `display_name`, `avatar`, `phone`, `bio`, `email`, `role`, `status`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'neel-manush', NULL, NULL, NULL, NULL, 'dhushoralbum@gmail.com', 'super_admin', 'active', NULL, '$2y$12$ZZsDrQFUJHMB2TxYLsYNBOBgyJeVTYOUgEg.uexnvpEFw.nwFfi3G', NULL, '2026-09-20 15:01:08', '2026-09-23 13:41:28');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `articles`
--
ALTER TABLE `articles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `articles_slug_unique` (`slug`),
  ADD KEY `articles_author_id_foreign` (`author_id`),
  ADD KEY `articles_category_id_status_published_at_index` (`category_id`,`status`,`published_at`),
  ADD KEY `articles_published_at_index` (`published_at`),
  ADD KEY `articles_status_index` (`status`),
  ADD KEY `articles_is_featured_index` (`is_featured`),
  ADD KEY `articles_is_verified_index` (`is_verified`),
  ADD KEY `articles_view_count_index` (`view_count`);

--
-- Indexes for table `article_categories`
--
ALTER TABLE `article_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `article_categories_slug_unique` (`slug`),
  ADD KEY `article_categories_status_index` (`status`),
  ADD KEY `article_categories_is_verified_index` (`is_verified`),
  ADD KEY `article_categories_is_active_index` (`is_active`);

--
-- Indexes for table `awards`
--
ALTER TABLE `awards`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `awards_slug_unique` (`slug`);

--
-- Indexes for table `award_categories`
--
ALTER TABLE `award_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `award_category_slug_unique` (`award_id`,`slug`);

--
-- Indexes for table `award_nominations`
--
ALTER TABLE `award_nominations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `award_nominations_award_category_id_foreign` (`award_category_id`),
  ADD KEY `award_nominations_award_id_year_index` (`award_id`,`year`),
  ADD KEY `award_nominations_content_id_year_index` (`content_id`,`year`),
  ADD KEY `award_nominations_person_id_year_index` (`person_id`,`year`),
  ADD KEY `award_nominations_year_index` (`year`),
  ADD KEY `award_nominations_is_winner_index` (`is_winner`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `contents`
--
ALTER TABLE `contents`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `contents_slug_unique` (`slug`),
  ADD KEY `contents_content_type_id_foreign` (`content_type_id`),
  ADD KEY `contents_release_month_day_index` (`release_month`,`release_day`),
  ADD KEY `contents_release_date_index` (`release_date`),
  ADD KEY `contents_release_year_index` (`release_year`),
  ADD KEY `contents_production_status_index` (`production_status`),
  ADD KEY `contents_box_office_status_index` (`box_office_status`),
  ADD KEY `contents_status_index` (`status`),
  ADD KEY `contents_is_featured_index` (`is_featured`);

--
-- Indexes for table `content_genres`
--
ALTER TABLE `content_genres`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `content_genres_unique` (`content_id`,`genre_id`),
  ADD KEY `content_genres_genre_id_foreign` (`genre_id`);

--
-- Indexes for table `content_people`
--
ALTER TABLE `content_people`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_people_profession_id_foreign` (`profession_id`),
  ADD KEY `content_people_content_prof_index` (`content_id`,`profession_id`),
  ADD KEY `content_people_person_prof_index` (`person_id`,`profession_id`),
  ADD KEY `content_people_credit_order_index` (`credit_order`),
  ADD KEY `content_people_is_featured_index` (`is_featured`);

--
-- Indexes for table `content_types`
--
ALTER TABLE `content_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `content_types_name_en_unique` (`name_en`),
  ADD UNIQUE KEY `content_types_slug_unique` (`slug`),
  ADD KEY `content_types_is_active_index` (`is_active`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `genres`
--
ALTER TABLE `genres`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `genres_name_en_unique` (`name_en`),
  ADD UNIQUE KEY `genres_slug_unique` (`slug`),
  ADD KEY `genres_is_active_index` (`is_active`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `people`
--
ALTER TABLE `people`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `people_slug_unique` (`slug`),
  ADD KEY `people_birth_month_day_index` (`birth_month`,`birth_day`),
  ADD KEY `people_death_month_day_index` (`death_month`,`death_day`),
  ADD KEY `people_name_bn_index` (`name_bn`(250)),
  ADD KEY `people_name_en_index` (`name_en`(250)),
  ADD KEY `people_birth_date_index` (`birth_date`),
  ADD KEY `people_death_date_index` (`death_date`),
  ADD KEY `people_status_index` (`status`),
  ADD KEY `people_is_featured_index` (`is_featured`);

--
-- Indexes for table `person_roles`
--
ALTER TABLE `person_roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `person_roles_person_profession_unique` (`person_id`,`profession_id`),
  ADD KEY `person_roles_profession_sort_index` (`profession_id`,`sort_order`),
  ADD KEY `person_roles_is_primary_index` (`is_primary`);

--
-- Indexes for table `professions`
--
ALTER TABLE `professions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `professions_name_en_unique` (`name_en`),
  ADD UNIQUE KEY `professions_slug_unique` (`slug`),
  ADD KEY `professions_is_active_index` (`is_active`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `reviews_user_content_unique` (`user_id`,`content_id`),
  ADD KEY `reviews_content_status_created_idx` (`content_id`,`status`,`created_at`),
  ADD KEY `reviews_status_index` (`status`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`),
  ADD KEY `settings_group_index` (`group`),
  ADD KEY `settings_is_public_index` (`is_public`);

--
-- Indexes for table `taggables`
--
ALTER TABLE `taggables`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `taggables_unique_index` (`tag_id`,`taggable_type`,`taggable_id`),
  ADD KEY `taggables_type_id_index` (`taggable_type`,`taggable_id`);

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tags_slug_unique` (`slug`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_role_index` (`role`),
  ADD KEY `users_status_index` (`status`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `articles`
--
ALTER TABLE `articles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `article_categories`
--
ALTER TABLE `article_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `awards`
--
ALTER TABLE `awards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `award_categories`
--
ALTER TABLE `award_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `award_nominations`
--
ALTER TABLE `award_nominations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `content_genres`
--
ALTER TABLE `content_genres`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `content_people`
--
ALTER TABLE `content_people`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_types`
--
ALTER TABLE `content_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `genres`
--
ALTER TABLE `genres`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `people`
--
ALTER TABLE `people`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `person_roles`
--
ALTER TABLE `person_roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `professions`
--
ALTER TABLE `professions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `taggables`
--
ALTER TABLE `taggables`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `person_roles`
--
ALTER TABLE `person_roles`
  ADD CONSTRAINT `person_roles_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `person_roles_profession_id_foreign` FOREIGN KEY (`profession_id`) REFERENCES `professions` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;