-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `tzweb_parindey`
--

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int NOT NULL,
  `category_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `category_name`) VALUES
(1, 'Sikkim Tour Package'),
(3, 'Best of Sikkim Darjeeling Tours'),
(4, 'Sikkim Darjeeling Student Tours'),
(6, 'Sikkim Darjeeling Honeymoon Tours'),
(7, 'Tour Package1'),
(8, 'Tour Package 2'),
(11, 'Tour Package 3'),
(12, 'contaimm');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone_number` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `massage` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `name`, `phone_number`, `email`, `massage`) VALUES
(1, 'Sk Arif Hossen', '9907707307', '0', 'Parindey'),
(2, 'Sk Arif', '9907707307', 'skarifh45@gmail.com', 'ok.'),
(3, 'Sri', '8923645987', 'sridas12345@gmail.com', ''),
(4, 'Srikrishna Mandal', '7047301445', 'srikrishnamandal7291@gmail.com', ''),
(5, 'Sonali', '8675645342312', 'v@gmail.com', ''),
(6, 'Sonali', '8675645342312', 'v@gmail.com', ''),
(7, 'Champa', '987564', 'a@gmail.com', ''),
(8, 'ilhkgufydtrf', '8645312', 'a@gmail.com', 'ihlgkufydtrsten'),
(9, 'Chat', '8541656768', 'chat@gmail.com', ''),
(10, 'chat', '854755558', 's@gmail.com', 'Lorem ipsum is a dummy or placeholder text commonly used in graphic design, publishing, and web development.'),
(11, 'Test User', '7894561230', 'test@gmail.com', ''),
(12, 'Test2', '1234567890', 'test@gmail.co', ''),
(13, 'Test Test', '1234567890', 'test@gmail.co', ''),
(14, 'Test2', '1234567890', 'test@gmail.co', ''),
(15, 'SOMA BAR', '9002338241', 'somabar721401@gmail.com', 'mnmvm');

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

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `id` int NOT NULL,
  `class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`id`, `class`) VALUES
(2, 'BCA'),
(19, 'MCA'),
(20, 'B.Sc'),
(23, 'M.Sc'),
(24, 'Both');

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

--
-- Table structure for table `destination`
--

CREATE TABLE `destination` (
  `id` int NOT NULL,
  `destinationname` varchar(255) NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `destination`
--

INSERT INTO `destination` (`id`, `destinationname`, `description`) VALUES
(1, 'Gangtok', '<div class=\"main-inner\">\r\n                    <h1>Gangtok Tourism places and Tour Packages:</h1>\r\n                    <p>Parindey.tzweb.in in offers you the best suitable Gangtok tour packages, which includes popular tourist places and local sightseeing of Gangtok tourism, SIkkim. For a perfect tour plan know all about Best time to visit, Weather & Temperature, Nearest Airport, Distances etc. <span>GET QUOTE & COMPARE </span> before you Book. Parindey.tzweb.in in being a leading tour operator of this region assured you a perfect, hassle free and memorable vacation.</p>\r\n                </div>\r\n                <div class=\"main-inner\">\r\n                    <h1>Gangtok Tourism, SIkkim:</h1>\r\n                    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quae repudiandae repellat optio. Beatae blanditiis voluptates veniam vitae expedita adipisci quo corporis, ipsum at eos molestias, quae pariatur iure fugit dolorem nesciunt a commodi consectetur.</p>\r\n                </div>\r\n                <div class=\"main-inner\">\r\n                    <h1>Top 3 Tourist Places to visit in Gangtok, East Sikkim Tourism:</h1>\r\n                    <p>Lorem, ipsum dolor sit amet consectetur adipisicing elit. Distinctio delectus reiciendis voluptatibus incidunt, quisquam quibusdam, esse tempora dignissimos!</p>\r\n                </div>\r\n                <div class=\"main-inner\">\r\n                    <h1>Gangtok Airport, Road and Distances:</h1>\r\n                    <p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet quasi mollitia reprehenderit earum sequi ullam sapiente. Quia totam reiciendis voluptatibus doloremque consectetur ex tempore! Nostrum, quasi nemo?</p>\r\n                </div>\r\n                <div class=\"main-inner\">\r\n                    <h1>Gangtok Tour Packages:</h1>\r\n                    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nihil quas quam quibusdam ex, aliquam vero quaerat blanditiis dolores numquam cupiditate, explicabo unde natus itaque libero.</p>\r\n                </div>'),
(10, 'Darjeeling', '<h1>Gangtok Tourism places and Tour Packages:</h1>\r\n\r\n<p>Parindey.tzweb.in in offers you the best suitable Gangtok tour packages, which includes popular tourist places and local sightseeing of Gangtok tourism, SIkkim. For a perfect tour plan know all about Best time to visit, Weather &amp; Temperature, Nearest Airport, Distances etc. GET QUOTE &amp; COMPARE before you Book. Parindey.tzweb.in in being a leading tour operator of this region assured you a perfect, hassle free and memorable vacation.</p>\r\n\r\n<h1>Gangtok Tourism, SIkkim:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quae repudiandae repellat optio. Beatae blanditiis voluptates veniam vitae expedita adipisci quo corporis, ipsum at eos molestias, quae pariatur iure fugit dolorem nesciunt a commodi consectetur.</p>\r\n\r\n<h1>Top 3 Tourist Places to visit in Gangtok, East Sikkim Tourism:</h1>\r\n\r\n<p>Lorem, ipsum dolor sit amet consectetur adipisicing elit. Distinctio delectus reiciendis voluptatibus incidunt, quisquam quibusdam, esse tempora dignissimos!</p>\r\n\r\n<h1>Gangtok Airport, Road and Distances:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet quasi mollitia reprehenderit earum sequi ullam sapiente. Quia totam reiciendis voluptatibus doloremque consectetur ex tempore! Nostrum, quasi nemo?</p>\r\n\r\n<h1>Gangtok Tour Packages:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nihil quas quam quibusdam ex, aliquam vero quaerat blanditiis dolores numquam cupiditate, explicabo unde natus itaque libero.</p>\r\n'),
(16, 'Destination1', '<p>hhgdf</p>\r\n'),
(17, 'Destination2', '<h1><span style=\"color:#e74c3c\">Gangtok Tourism places and Tour Packages:</span></h1>\r\n\r\n<p>Parindey.tzweb.in in offers you the best suitable Gangtok tour packages, which includes popular tourist places and local sightseeing of Gangtok tourism, SIkkim. For a perfect tour plan know all about Best time to visit, Weather &amp; Temperature, Nearest Airport, Distances etc. GET QUOTE &amp; COMPARE before you Book. Parindey.tzweb.in in being a leading tour operator of this region assured you a perfect, hassle free and memorable vacation.</p>\r\n\r\n<div>\r\n<h1>Gangtok Tourism, SIkkim:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quae repudiandae repellat optio. Beatae blanditiis voluptates veniam vitae expedita adipisci quo corporis, ipsum at eos molestias, quae pariatur iure fugit dolorem nesciunt a commodi consectetur.</p>\r\n</div>\r\n\r\n<div>\r\n<h1>Top 3 Tourist Places to visit in Gangtok, East Sikkim Tourism:</h1>\r\n\r\n<p>Lorem, ipsum dolor sit amet consectetur adipisicing elit. Distinctio delectus reiciendis voluptatibus incidunt, quisquam quibusdam, esse tempora dignissimos!</p>\r\n</div>\r\n\r\n<div>\r\n<h1>Gangtok Airport, Road and Distances:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet quasi mollitia reprehenderit earum sequi ullam sapiente. Quia totam reiciendis voluptatibus doloremque consectetur ex tempore! Nostrum, quasi nemo?</p>\r\n</div>\r\n\r\n<div>\r\n<h1>Gangtok Tour Packages:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nihil quas quam quibusdam ex, aliquam vero quaerat blanditiis dolores numquam cupiditate, explicabo unde natus itaque libero.</p>\r\n</div>\r\n\r\n<p>&quot; id=&quot;myeditor&quot;&gt;</p>\r\n\r\n<div>\r\n<h1>Gangtok Tourism places and Tour Packages:</h1>\r\n\r\n<p>Parindey.tzweb.in in offers you the best suitable Gangtok tour packages, which includes popular tourist places and local sightseeing of Gangtok tourism, SIkkim. For a perfect tour plan know all about Best time to visit, Weather &amp; Temperature, Nearest Airport, Distances etc. GET QUOTE &amp; COMPARE before you Book. Parindey.tzweb.in in being a leading tour operator of this region assured you a perfect, hassle free and memorable vacation.</p>\r\n</div>\r\n\r\n<div>\r\n<h1>Gangtok Tourism, SIkkim:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quae repudiandae repellat optio. Beatae blanditiis voluptates veniam vitae expedita adipisci quo corporis, ipsum at eos molestias, quae pariatur iure fugit dolorem nesciunt a commodi consectetur.</p>\r\n</div>\r\n\r\n<div>\r\n<h1>Top 3 Tourist Places to visit in Gangtok, East Sikkim Tourism:</h1>\r\n\r\n<p>Lorem, ipsum dolor sit amet consectetur adipisicing elit. Distinctio delectus reiciendis voluptatibus incidunt, quisquam quibusdam, esse tempora dignissimos!</p>\r\n</div>\r\n\r\n<div>\r\n<h1>Gangtok Airport, Road and Distances:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet quasi mollitia reprehenderit earum sequi ullam sapiente. Quia totam reiciendis voluptatibus doloremque consectetur ex tempore! Nostrum, quasi nemo?</p>\r\n</div>\r\n\r\n<div>\r\n<h1>Gangtok Tour Packages:</h1>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nihil quas quam quibusdam ex, aliquam vero quaerat blanditiis dolores numquam cupiditate, explicabo unde natus itaque libero.</p>\r\n</div>\r\n'),
(18, 'Destination3', '<h1><span style=\"color:#f39c12\">Gangtok Tourism, SIkkim:</span></h1>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quae repudiandae repellat optio. Beatae blanditiis voluptates veniam vitae expedita adipisci quo corporis, ipsum at eos molestias, quae pariatur iure fugit dolorem nesciunt a commodi consectetur.</p>\r\n\r\n<h1><span style=\"color:#f39c12\">Top 3 Tourist Places to visit in Gangtok, East Sikkim Tourism:</span></h1>\r\n\r\n<p>Lorem, ipsum dolor sit amet consectetur adipisicing elit. Distinctio delectus reiciendis voluptatibus incidunt, quisquam quibusdam, esse tempora dignissimos!</p>\r\n\r\n<h1><span style=\"color:#f39c12\">Gangtok Airport, Road and Distances:</span></h1>\r\n\r\n<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet quasi mollitia reprehenderit earum sequi ullam sapiente. Quia totam reiciendis voluptatibus doloremque consectetur ex tempore! Nostrum, quasi nemo?</p>\r\n\r\n<h1><span style=\"color:#f39c12\">Gangtok Tour Packages:</span></h1>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nihil quas quam quibusdam ex, aliquam vero quaerat blanditiis dolores numquam cupiditate, explicabo unde natus itaque libero</p>\r\n\r\n<p>&nbsp;</p>\r\n');

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

--
-- Table structure for table `dptassign`
--

CREATE TABLE `dptassign` (
  `id` int NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `department_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dptassign`
--

INSERT INTO `dptassign` (`id`, `user_id`, `department_id`) VALUES
(1, '15', '23'),
(24, '15', '2'),
(25, '22', '6'),
(28, '21', '6'),
(29, '18', '2'),
(30, '22', '6'),
(31, '15', '20'),
(32, '18', '24');

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

--
-- Table structure for table `home`
--

CREATE TABLE `home` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `lesson`
--

CREATE TABLE `lesson` (
  `id` int NOT NULL,
  `created_date` tinyint DEFAULT NULL,
  `updated_date` tinyint DEFAULT NULL,
  `subject_id` int DEFAULT NULL COMMENT 'id from subject table',
  `lesson` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lesson`
--

INSERT INTO `lesson` (`id`, `created_date`, `updated_date`, `subject_id`, `lesson`, `status`) VALUES
(1, NULL, NULL, 1, 'c l1', 1),
(3, NULL, NULL, 2, 'math l1', 1),
(7, NULL, NULL, 4, 'uhuiub', 0),
(8, NULL, NULL, 1, 'ugytf', 1),
(9, NULL, NULL, 4, '7', 0),
(10, NULL, NULL, 1, '8', 1);

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

--
-- Table structure for table `order_packages`
--

CREATE TABLE `order_packages` (
  `id` int NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone_number` varchar(25) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `travel_date` date DEFAULT NULL,
  `destinationid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `package` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `massage` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_packages`
--

INSERT INTO `order_packages` (`id`, `first_name`, `last_name`, `email`, `phone_number`, `address`, `travel_date`, `destinationid`, `category`, `package`, `massage`) VALUES
(69, 'S0MA', 'BAR', 'sIm01@gmail.com', '9002338241', 'Kishorenagar', '2025-06-08', '10', '', '', 'bdjsk'),
(70, 'SOMA', 'BAR', 'sima@gmail.com', '09002338241', 'Contai2', '2025-05-29', '10', 'sikkim', 'ccc', 'bdjsk');

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` int NOT NULL,
  `images` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `days` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `night` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `place_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'rupes per head',
  `category` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `destinationid` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `tour_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `time` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `spots` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `images`, `days`, `night`, `place_name`, `price`, `category`, `destinationid`, `location`, `tour_id`, `time`, `spots`) VALUES
(51, '1745255155_flower.jpg', '8', '7', 'Everest', '200', '6', '10', 'Sikkim', 'TR-51', '1745255155000', NULL),
(52, '1745256943_Screenshot 2025-02-18 133541.png', '3', '2', 'Trip to Sikkim 8 Days package', '500', '1', '1', 'Gangtok', 'TR-52', '1745256943000', NULL),
(53, '1745257096_Screenshot 2025-03-20 132855.png', '5', '4', 'Trip to Sikkim 8 Days package', '300', '1', '10', 'Gangtok', 'TR-53', '1745257096000', NULL),
(55, '1745307518_sunset.jpg', '5', '6', 'Student Category', '200', '7', '16', 'Hill', 'TR-55', '1745307518000', NULL),
(56, '1745307555_sunset.jpg', '5', '7', 'Student Category', '8000', '7', '16', 'Digha', 'TR-56', '1745307555000', NULL),
(57, '1745307582_sunset.jpg', '6', '8', 'Everest', '1000', '8', '16', 'Hill', 'TR-57', '1745307582000', NULL),
(58, '1745307616_sunset.jpg', '6', '3', 'Some', '200', '8', '16', 'Sikkim', 'TR-58', '1745307616000', NULL),
(59, '1745308959_sunset.jpg', '6', '5', 'Everest', '3000', '6', '1', 'Hill', 'TR-59', '1745308959000', NULL),
(60, '1745373891_mount.jpg', '4', '3', 'Sikkim Darjeeling Student 4 Days', '500', '4', '17', 'Sikkim', 'TR-60', '1745373891000', NULL),
(61, '', '5', '6', 'Best Of Sikkim Darjelling Tours', '200', '3', '10', 'Hill', 'TR-61', '1745723475000', 'a:1:{i:0;a:2:{s:4:\"spot\";s:9:\"Sandakphu\";s:8:\"spot_des\";s:126:\"serializedDataserializedDataserializedDataserializedDataserializedDataserializedDataserializedDataserializedDataserializedData\";}}'),
(82, '1746294210_Screenshot (94).png', '78', '3', 'ccc', '1232f', '6', '\r\n								10', 'sikkim', 'TR-82', '1746294210000', 'a:2:{i:0;a:2:{s:4:\"spot\";s:3:\"he1\";s:8:\"spot_des\";s:6:\"nmskjk\";}i:1;a:2:{s:4:\"spot\";s:2:\"h3\";s:8:\"spot_des\";s:9:\"tywqyjhbn\";}}');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int NOT NULL,
  `permission_name` varchar(100) DEFAULT NULL,
  `permission_code` varchar(100) DEFAULT NULL,
  `created_date` tinyint DEFAULT NULL,
  `updated_date` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `permission_name`, `permission_code`, `created_date`, `updated_date`) VALUES
(1, 'view Users', 'view_users', NULL, NULL),
(2, 'Edit Users', 'edit_users', NULL, NULL),
(3, 'Delete Users', 'delete_users', NULL, NULL),
(4, 'view lesson', 'view_lesson', NULL, NULL),
(5, 'Edit lesson', 'edit_lesson', NULL, NULL),
(6, 'Delete lesson', 'delete_lesson', NULL, NULL),
(7, 'View Subject', 'view_subject', NULL, NULL),
(8, 'Edit Subject', 'edit_subject', NULL, NULL),
(9, 'Delete Subject', 'delete_subject', NULL, NULL),
(10, 'View Roles', 'view_roles', NULL, NULL),
(11, 'Edit Roles', 'edit_roles', NULL, NULL),
(12, 'Delete Roles', 'delete_roles', NULL, NULL),
(13, 'View Topic', 'view_topic', NULL, NULL),
(14, 'Edit Topic', 'edit_topic', NULL, NULL),
(15, 'Delete Topic', 'delete_topic', NULL, NULL),
(16, 'View Project', 'view_project', NULL, NULL),
(17, 'Edit Project', 'edit_project', NULL, NULL),
(18, 'Delete Project', 'delete_project', NULL, NULL),
(19, 'View Department', 'view_department', NULL, NULL),
(20, 'Edit Department', 'edit_department', NULL, NULL),
(21, 'Delete Department', 'delete_department', NULL, NULL),
(22, 'View Assign Department', 'view_assign_department', NULL, NULL),
(23, 'Edit Assign Department', 'edit_assign_department', NULL, NULL),
(24, 'Delete Assign Department', 'delete_assign_department', NULL, NULL);

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `first_name`, `last_name`, `image`, `email`, `status`, `phone`) VALUES
(12, 'Some', 'Info', '1742105234_Environment.jpg', 'r@gmail.com', '1', '000000'),
(13, 'ani', 'patra', '1742104549_birds-in-flight-photography-tips-and-tricks-2023.jpg', 'ani123@gmail.com', '1', '789235879');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int NOT NULL,
  `role` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_date` tinyint DEFAULT NULL,
  `updated_date` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `role`, `status`, `created_date`, `updated_date`) VALUES
(1, 'Super Admin', 1, NULL, NULL),
(3, 'Teacher', 1, NULL, NULL),
(12, 'Admin', 1, NULL, NULL);

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

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `id` int NOT NULL,
  `role_id` int DEFAULT NULL,
  `permission_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role_permissions`
--

INSERT INTO `role_permissions` (`id`, `role_id`, `permission_id`) VALUES
(29, 12, 1),
(42, 3, 2),
(43, 3, 3),
(53, 1, 1),
(54, 1, 2),
(55, 1, 19),
(56, 1, 20);

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

--
-- Table structure for table `subject`
--

CREATE TABLE `subject` (
  `id` int NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_date` tinyint DEFAULT NULL,
  `updated_date` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subject`
--

INSERT INTO `subject` (`id`, `subject`, `status`, `created_date`, `updated_date`) VALUES
(1, 'C programming', 1, NULL, NULL),
(4, 'Fundamentals', 1, NULL, NULL);

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

--
-- Table structure for table `topic`
--

CREATE TABLE `topic` (
  `id` int NOT NULL,
  `subject_id` varchar(255) NOT NULL,
  `lesson_id` varchar(255) NOT NULL,
  `topic_name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_date` tinyint DEFAULT NULL,
  `updated_date` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `topic`
--

INSERT INTO `topic` (`id`, `subject_id`, `lesson_id`, `topic_name`, `status`, `created_date`, `updated_date`) VALUES
(2, '1', '2', 'Commands', '0', NULL, NULL),
(4, '1', '2', 'hbbhb', '1', NULL, NULL);

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

--
-- Table structure for table `tourpackage`
--

CREATE TABLE `tourpackage` (
  `id` int NOT NULL,
  `places` varchar(255) DEFAULT NULL,
  `destinationid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `covered` varchar(255) NOT NULL,
  `tourpackage` varchar(255) NOT NULL,
  `tour_id` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL COMMENT 'This column is created to identify each record uniquely'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tourpackage`
--

INSERT INTO `tourpackage` (`id`, `places`, `destinationid`, `covered`, `tourpackage`, `tour_id`, `time`) VALUES
(12, 'Kanchanjangha', '14', 'a:1:{i:0;a:2:{s:4:\"spot\";s:12:\"Kanchanjagha\";s:8:\"spot_des\";s:46:\"Very beautifull mountain view among darjelling\";}}', '1', '', ''),
(13, 'Mount Everest', '\r\n							17', 'a:1:{i:0;a:2:{s:4:\"spot\";s:13:\"Mount Everest\";s:8:\"spot_des\";s:17:\"gvhcfgxdgcfvhjbkn\";}}', '', '', ''),
(14, 'Sandakphu', '19', 'a:1:{i:0;a:2:{s:4:\"spot\";s:9:\"Sandakphu\";s:8:\"spot_des\";s:33:\"jhgytfdresrwarzsdxtcfgvbhjkml,;l.\";}}', '12', '', ''),
(15, 'Lepchajagat', '3', 'a:1:{i:0;a:2:{s:4:\"spot\";s:11:\"Lepchajagat\";s:8:\"spot_des\";s:47:\"Lepchajagat,Lepchajagat.Lepchajagat,Lepchajagat\";}}', '19', '', ''),
(21, 'Darjleling', '3', 'a:1:{i:0;a:2:{s:4:\"spot\";s:13:\"Mount Everest\";s:8:\"spot_des\";s:16:\"werthyjuhtgrfedw\";}}', '16', 'TR-21', '1743242765000'),
(22, 'Sikkim', '11', 'a:1:{i:0;a:2:{s:4:\"spot\";s:9:\"Sandakphu\";s:8:\"spot_des\";s:18:\"klhkugyfutdyrseafw\";}}', '17', 'TR-22', '1743242782000');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `role_permissions`
--
ALTER TABLE `role_permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_id` (`role_id`),
  ADD KEY `permission_id` (`permission_id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `destination`
--
ALTER TABLE `destination`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `dptassign`
--
ALTER TABLE `dptassign`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `home`
--
ALTER TABLE `home`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lesson`
--
ALTER TABLE `lesson`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `order_packages`
--
ALTER TABLE `order_packages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `role_permissions`
--
ALTER TABLE `role_permissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `subject`
--
ALTER TABLE `subject`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `topic`
--
ALTER TABLE `topic`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tourpackage`
--
ALTER TABLE `tourpackage`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `role_permissions`
--
ALTER TABLE `role_permissions`
  ADD CONSTRAINT `role_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  ADD CONSTRAINT `role_permissions_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`);
COMMIT;

