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

START TRANSACTION;



--
-- Database: `diihm_jobApply`
--

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `b_id` int(11) NOT NULL,
  `b_title` varchar(300) NOT NULL,
  `b_short_des` varchar(300) NOT NULL,
  `b_long_des` longtext NOT NULL,
  `b_seo_keyword` varchar(300) NOT NULL,
  `b_thumbnail` varchar(300) NOT NULL,
  `bup_date` varchar(300) NOT NULL,
  `bedit_date` varchar(300) NOT NULL,
  `b_count` int(11) NOT NULL,
  `b_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`b_id`, `b_title`, `b_short_des`, `b_long_des`, `b_seo_keyword`, `b_thumbnail`, `bup_date`, `bedit_date`, `b_count`, `b_recycle`) VALUES
(1, 'The Journey of Pursuing a Bachelor of Hotel Management (BHM)', 'The hospitality industry, with its captivating blend of service, innovation, and cultural exchange, offers a myriad of opportunities for those with a passion for creating memorable experiences. At the heart of this vibrant sector lies the Bachelor of Hotel Management (BHM) program, a gateway to a wo', '<p><strong>Embarking on the BHM Odyssey:</strong> The journey of pursuing a Bachelor of Hotel Management begins with a sense of curiosity and a desire to immerse oneself in the intricacies of hospitality management. As students delve into the program, they are introduced to a diverse array of subjects, ranging from hospitality operations and food service management to revenue management and guest relations. Through a blend of theoretical knowledge and practical experience, students gain a comprehensive understanding of the industry&#39;s inner workings.</p>\r\n\r\n<p><strong>Exploring the World of Hospitality:</strong> One of the most compelling aspects of the BHM program is the opportunity for experiential learning. From internships at luxury hotels and resorts to hands-on culinary workshops and industry seminars, students are exposed to the dynamic realities of the hospitality sector. These immersive experiences not only sharpen their skills but also foster a deep appreciation for the art of hospitality and the importance of customer satisfaction.</p>\r\n\r\n<p><strong>Unleashing Creativity and Innovation:</strong> The hospitality industry thrives on innovation, and BHM students are encouraged to think outside the box and push the boundaries of creativity. Whether it&#39;s designing innovative menu concepts, conceptualizing themed events, or implementing sustainable practices, students are empowered to embrace innovation as a catalyst for growth and success in the ever-evolving world of hospitality.</p>\r\n\r\n<p><strong>Building a Global Network:</strong> In an increasingly interconnected world, BHM students have the opportunity to interact with individuals from diverse cultural backgrounds and forge connections that transcend borders. Through study tours, international exchange programs, and multicultural campus environments, students gain a global perspective and develop invaluable cross-cultural communication skills that are essential for success in today&#39;s globalized hospitality industry.</p>\r\n\r\n<p><strong>Embracing Career Opportunities:</strong> Armed with a Bachelor of Hotel Management degree, graduates are poised to embark on a diverse range of career paths. From hotel management and event planning to food and beverage management and tourism development, the possibilities are endless. With a strong foundation in hospitality management principles and a passion for excellence, BHM graduates are well-equipped to thrive in a variety of roles and make a meaningful impact in the industry.</p>\r\n\r\n<p><strong>Conclusion:</strong> The journey of pursuing a Bachelor of Hotel Management is not just about acquiring knowledge and skills; it&#39;s about unlocking a world of opportunities and embracing a lifelong passion for hospitality. With its blend of academic rigor, practical experience, and global perspective, the BHM program offers students the chance to embark on an enriching and fulfilling journey that transcends borders and transforms lives. So, whether you&#39;re drawn to the excitement of hotel management, the creativity of event planning, or the artistry of culinary arts, the BHM program is your passport to a world of endless possibilities in the vibrant world of hospitality.</p>\r\n', 'test, seo, key, word', '../upload/blog/663828336.jpg', '2024-04-06', '2024-04-08', 432, 1),
(2, 'Career Counciling', 'Shape Your Future With Best Hotel Management Institute in Kolkata: Be The Most-Skilled Professional', '<p>Ivan Institute is the Best Hotel Management Institute in Kolkata, the best provider of world-class education, training and placement services. We create our students as best skilled professionals of the industry.Ivan Institute is the Best Hotel Management Institute in Kolkata, the best provider of world-class education, training and placement services. We create our students as best skilled professionals of the industry.Ivan Institute is the Best Hotel Management Institute in Kolkata, the best provider of world-class education, training and placement services. We create our students as best skilled professionals of the industry.Ivan Institute is the Best Hotel Management Institute in Kolkata, the best provider of world-class education, training and placement services. We create our students as best skilled professionals of the industry.Ivan Institute is the Best Hotel Management Institute in Kolkata, the best provider of world-class education, training and placement services. We create our students as best skilled professionals of the industry.Ivan Institute is the Best Hotel Management Institute in Kolkata, the best provider of world-class education, training and placement services. We create our students as best skilled professionals of the industry.Ivan Institute is the Best Hotel Management Institute in Kolkata, the best provider of world-class education, training and placement services. We create our students as best skilled professionals of the industry.</p>\r\n\r\n<h3>Shape Your Future With Best Hotel Management Institute in Kolkata: Be The Most-Skilled Professional</h3>\r\n', 'Ivan Institute is the Best Hotel Management Institute in Kolkata, the best provider of world-class education, training and placement services. We create our students as best skilled professionals of the industry.', '', '2024-05-01', '2024-05-06', 0, 10);

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

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

CREATE TABLE `category` (
  `cid` int(11) NOT NULL,
  `catname` varchar(100) NOT NULL,
  `catby` int(11) NOT NULL,
  `cpositon` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `category` (`cid`, `catname`, `catby`, `cpositon`) VALUES
(32, 'Hotel', 1, 0),
(33, 'Hospitality', 1, 0);

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

--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `id` int(11) NOT NULL,
  `stateId` varchar(225) NOT NULL,
  `distId` varchar(225) NOT NULL,
  `cityName` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `city`
--

INSERT INTO `city` (`id`, `stateId`, `distId`, `cityName`) VALUES
(5, '', '', 'Kolkata');

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

--
-- Table structure for table `contct`
--

CREATE TABLE `contct` (
  `sl` int(11) NOT NULL,
  `name` varchar(225) NOT NULL,
  `no` varchar(225) NOT NULL,
  `email` varchar(225) NOT NULL,
  `sub` varchar(225) NOT NULL,
  `msg` varchar(225) NOT NULL,
  `up_date` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contct`
--

INSERT INTO `contct` (`sl`, `name`, `no`, `email`, `sub`, `msg`, `up_date`) VALUES
(1, 'Test', 'n/c', 'test@test.com', 'n/c', 'test', '27 February, 2024, 9:09 pm'),
(2, 'Sucharita Bhattacharya', '9830555985', 'bhsucharita4@gmail.com', 'Communicative English and Soft Skills ', 'I wish to apply for the post of a faculty member (on Part-time / Adjunct/visiting positions only) in Communicative English and Soft Skills Training for your institute.\r\n\r\nI have 18 years of teaching experience as a communicat', '17 April, 2024, 4:34 pm'),
(3, 'Debasish Santra', '9830344452', 'santradebasish012@gmail.com', 'Application for the post of hotel management faculty. ', 'Sir, \r\nMyself, Debasish Santra, an experienced hotel management faculty, from Barrackpore.  I can teach all four major subjects of hotel management.  \r\nIn near future, if you have any vacancy, in the above mentioned post, kin', '1 May, 2024, 4:29 pm'),
(4, 'Dhrub', '9163447763', 'dhanrajmaheswari@gmail.com', 'Diploma in hotel management ', 'Please call', '27 May, 2024, 4:12 pm');

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

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `course_id` int(11) NOT NULL,
  `course_name` varchar(300) NOT NULL,
  `course_img` varchar(300) NOT NULL,
  `course_des` longtext NOT NULL,
  `course_created` varchar(300) NOT NULL,
  `course_recycle` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `course`
--

INSERT INTO `course` (`course_id`, `course_name`, `course_img`, `course_des`, `course_created`, `course_recycle`) VALUES
(4, 'Bachelor of Hotel Management (BHM)', '../upload/course/UY0I_20240408172401.jpg', '<p><strong>Bachelor of Hotel Management (BHM) at IVAN</strong></p>\r\n\r\n<p>The Bachelor of Hotel Management (BHM) program at IVAN College is designed to equip students with the knowledge and skills necessary for a successful career in the hospitality industry. With a comprehensive curriculum and hands-on training, this program prepares students for leadership roles in hotels, resorts, restaurants, and other hospitality establishments.</p>\r\n\r\n<p><strong>Program Overview:</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>Duration:</strong>&nbsp;The BHM program is a four-year undergraduate degree program.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Curriculum:</strong>&nbsp;The curriculum covers a wide range of subjects including hospitality management, food and beverage management, accommodation operations, marketing, finance, human resource management, tourism management, and event management.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Industry Exposure:</strong>&nbsp;IVAN College emphasizes practical learning experiences, offering students opportunities for internships, industry visits, and guest lectures by professionals in the hospitality sector. These experiences provide students with valuable insights into the workings of the industry and help them develop practical skills.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Facilities:</strong>&nbsp;The college boasts state-of-the-art facilities including fully-equipped kitchens, mock hotel rooms, and computer labs with industry-standard software. These facilities allow students to gain hands-on experience and familiarize themselves with the tools and technologies used in the hospitality industry.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>International Perspective:</strong>&nbsp;In an increasingly globalized industry, IVAN College recognizes the importance of providing students with an international perspective. The program may include modules on international hospitality trends, cross-cultural communication, and global hospitality management practices.</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>Career Opportunities:</strong></p>\r\n\r\n<p>Graduates of the BHM program at IVAN College are well-prepared to pursue a variety of career opportunities in the hospitality industry. Some potential career paths include:</p>\r\n\r\n<ul>\r\n	<li>Hotel Manager</li>\r\n	<li>Restaurant Manager</li>\r\n	<li>Event Manager</li>\r\n	<li>Food and Beverage Director</li>\r\n	<li>Front Office Manager</li>\r\n	<li>Resort Manager</li>\r\n	<li>Tourism Officer</li>\r\n	<li>Cruise Ship Director</li>\r\n	<li>Hospitality Consultant</li>\r\n</ul>\r\n\r\n<p><strong>Admission Requirements:</strong></p>\r\n\r\n<p>Prospective students interested in the BHM program must meet the college&#39;s admission requirements, which may include a high school diploma or equivalent qualification, standardized test scores, letters of recommendation, and a personal statement.</p>\r\n', '2024-04-08 17:24:01', '1'),
(5, 'Diploma In Hotel Management', '../upload/course/sRkL_20240424183030.png', '<p>The curriculum for a one-year diploma in hotel management will typically cover a variety of topics, including:</p>\r\n\r\n<ul>\r\n	<li>Front office operations</li>\r\n	<li>Housekeeping management</li>\r\n	<li>Food and beverage service</li>\r\n	<li>Accounting</li>\r\n	<li>Marketing</li>\r\n	<li>Human resources</li>\r\n</ul>\r\n\r\n<p>Students will also have the opportunity to gain practical experience through internships or externships.</p>\r\n\r\n<p>If you are interested in pursuing a career in the hospitality industry, a diploma in hotel management can be a great way to get started.</p>\r\n', '2024-04-24 18:30:30', '1');

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

--
-- Table structure for table `employers`
--

CREATE TABLE `employers` (
  `emp_id` int(11) NOT NULL,
  `emp_name` varchar(300) NOT NULL,
  `emp_logo` varchar(300) NOT NULL,
  `emp_creatdate` varchar(300) NOT NULL,
  `emp_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employers`
--

INSERT INTO `employers` (`emp_id`, `emp_name`, `emp_logo`, `emp_creatdate`, `emp_recycle`) VALUES
(1, 'Infosis', '../upload/employers/6630dc7a436dc_WhatsApp-Image-2021-06-23-at-10.28.41-AM.jpeg', '2024-04-30 16:18:31', 1),
(3, 'Test', '../upload/employers/6632076306c49_images (3).jpg', '2024-05-01 11:34:56', 5);

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

--
-- Table structure for table `interview_location_time`
--

CREATE TABLE `interview_location_time` (
  `id` int(11) NOT NULL,
  `job_post_id` varchar(255) DEFAULT NULL,
  `stateId` varchar(225) NOT NULL,
  `distId` varchar(225) NOT NULL,
  `cityId` varchar(225) NOT NULL,
  `interview_location` varchar(255) DEFAULT NULL,
  `interview_date` varchar(255) DEFAULT NULL,
  `interview_time` varchar(255) DEFAULT NULL,
  `up_by` varchar(225) NOT NULL,
  `up_date` varchar(225) NOT NULL,
  `edit_date` varchar(225) NOT NULL,
  `status` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interview_location_time`
--

INSERT INTO `interview_location_time` (`id`, `job_post_id`, `stateId`, `distId`, `cityId`, `interview_location`, `interview_date`, `interview_time`, `up_by`, `up_date`, `edit_date`, `status`) VALUES
(1, '2', '1', '1', '3', 'Durgapur', '2023-12-22', '', '', '', '16 December, 2023, 5:25 pm', '1'),
(3, '3', '3', '3', '2', 'Runibari', '2023-12-19', '18:07,19:20', 'master_admin', '16 December, 2023, 3:55 pm', '16 December, 2023, 6:21 pm', '1'),
(4, '2', '3', '3', '2', 'NA', '2023-12-21', '', 'master_admin', '16 December, 2023, 5:25 pm', '', '1'),
(5, '5', '1', '1', '1', 'qawsedfg', '2023-12-19', '16:03', 'master_admin', '18 December, 2023, 3:03 pm', '', '1'),
(6, '6', '', '', '', 'This is office Address', '2023-12-22', '20:00', 'master_admin', '21 December, 2023, 7:53 pm', '', '1'),
(7, '7', '', '', '', 'sdfghjkl;\'\r\n', '2023-12-23', '19:56', 'master_admin', '21 December, 2023, 7:56 pm', '', '1'),
(8, '8', '', '', '4', 'aa2', '2023-12-23', '15:00', 'master_admin', '21 December, 2023, 7:58 pm', '21 December, 2023, 8:34 pm', '1'),
(9, '9', '', '', '5', 'Plot No.2, opposite City Centre, Bidhan Nagar, EC Block, Sector 1, Bidhannagar, Kolkata, West Bengal 700064', '2024-04-15', '10:00', 'master_admin', '8 April, 2024, 5:14 pm', '', '1'),
(10, '10', '', '', '5', 'Plot No.2, opposite City Centre, Bidhan Nagar, EC Block, Sector 1, Bidhannagar, Kolkata, West Bengal 700064', '2024-04-15', '10:00', 'master_admin', '8 April, 2024, 5:17 pm', '', '1'),
(11, '11', '', '', '5', 'Plot No.2, opposite City Centre, Bidhan Nagar, EC Block, Sector 1, Bidhannagar, Kolkata, West Bengal 700064', '2024-04-15', '09:30', 'master_admin', '8 April, 2024, 5:21 pm', '', '1');

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

--
-- Table structure for table `job_apply`
--

CREATE TABLE `job_apply` (
  `id` int(11) NOT NULL,
  `job_id` varchar(255) DEFAULT NULL,
  `applicant_id` varchar(255) DEFAULT NULL,
  `applicant_phone` varchar(255) DEFAULT NULL,
  `applicant_email` varchar(255) DEFAULT NULL,
  `applicant_whatsapp` varchar(255) DEFAULT NULL,
  `applydate` varchar(255) DEFAULT NULL,
  `interview_location` varchar(255) DEFAULT NULL,
  `interview_datetime` varchar(255) DEFAULT NULL,
  `payment_amount` varchar(255) DEFAULT NULL,
  `payment_transaction_id` varchar(255) DEFAULT NULL,
  `paymentDatetime` varchar(255) DEFAULT NULL,
  `paymentPeriod` enum('Pay Now','Pay Later') DEFAULT NULL,
  `paymentStatus` enum('pending','success','failed') DEFAULT NULL,
  `interview_status` varchar(225) NOT NULL,
  `remark` varchar(300) NOT NULL,
  `status` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `job_apply`
--

INSERT INTO `job_apply` (`id`, `job_id`, `applicant_id`, `applicant_phone`, `applicant_email`, `applicant_whatsapp`, `applydate`, `interview_location`, `interview_datetime`, `payment_amount`, `payment_transaction_id`, `paymentDatetime`, `paymentPeriod`, `paymentStatus`, `interview_status`, `remark`, `status`) VALUES
(16, '2', '271', '9735907380', 'k.d@gmail.com', '9735907380', '2023-12-19 15:06:37', 'Durgapur', '2023-12-22', ' 50', 'pay_NE9nRY1GhJRqTm', '2023-12-19 10:37:46', 'Pay Later', 'success', '0', '', '1'),
(18, '7', '266', '7894561235', 'sd@fg.com', '8855885588', '2023-12-22 18:25:03', '5', '', ' 50', NULL, NULL, 'Pay Now', 'pending', '0', '', '1'),
(19, '11', '276', '7319172060', 'abdulrahamank162@gmail.com', '7319172060', '2024-05-07 06:19:28', '5', '', ' 50', NULL, NULL, 'Pay Now', 'pending', '0', '', '1'),
(20, '9', '289', '8001482888', 'Daluisrikanta931@gmail.com', '8001482888', '2024-06-11 13:44:05', '5', '', ' 50', NULL, NULL, 'Pay Now', 'pending', '0', '', '1'),
(21, '11', '297', '9641651490', 'khatuaprasanta980@gmail.com', '9641651490', '2024-07-09 22:11:18', '5', '', ' 50', NULL, NULL, 'Pay Now', 'pending', '0', '', '1'),
(22, '9', '271', '9875580466', 'mdmohubulhoque@digix.in', '9732335542', '2025-09-11 12:30:50', '5', '', ' 50', NULL, NULL, 'Pay Now', 'pending', '0', '', '1');

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

--
-- Table structure for table `job_post`
--

CREATE TABLE `job_post` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `job_cat` varchar(225) NOT NULL,
  `job_description` longtext DEFAULT NULL,
  `status` int(11) NOT NULL,
  `up_by` varchar(225) NOT NULL,
  `up_date` varchar(225) NOT NULL,
  `edit_date` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `job_post`
--

INSERT INTO `job_post` (`id`, `title`, `job_cat`, `job_description`, `status`, `up_by`, `up_date`, `edit_date`) VALUES
(9, 'BBA in Hospitality', 'Hospitality', 'As a Bachelor of Business Administration (BBA) in Hospitality graduate working as a Hospitality Management Associate at IVAN College, you will play a crucial role in supporting various aspects of hospitality management operations. Your responsibilities will involve assisting in the implementation of strategic initiatives and ensuring the efficient delivery of services to meet the needs of guests and stakeholders.\r\n\r\nKey Responsibilities:\r\n\r\nGuest Relations: Interact with guests to ensure a positive experience, address inquiries, and resolve any issues or concerns promptly and courteously. Operations Support: Assist in overseeing day-to-day operations of hospitality services, including front desk management, housekeeping coordination, and food and beverage service.\r\n\r\nMarketing and Promotion: Support marketing efforts by assisting in the development and implementation of promotional campaigns to attract guests and increase revenue.\r\n\r\nFinancial Management: Assist in monitoring expenses, budgeting, and financial reporting to ensure profitability and cost-efficiency in hospitality operations.\r\n\r\nEvent Coordination: Participate in planning and executing college events, such as conferences, seminars, and workshops, by coordinating logistics and providing on-site support.\r\n\r\nQuality Assurance: Ensure compliance with quality standards and regulations in hospitality services, including cleanliness, safety, and hygiene practices.\r\n\r\nTeam Leadership: Supervise and motivate staff to uphold service standards, foster teamwork, and promote a positive work culture.\r\n\r\nInventory Control: Monitor inventory levels for supplies, equipment, and amenities, and coordinate procurement activities to maintain adequate stock levels.\r\n\r\nData Analysis: Analyze guest feedback, operational metrics, and market trends to identify opportunities for improvement and inform decision-making processes.\r\n\r\nProfessional Development: Continuously enhance your knowledge and skills through training programs, workshops, and industry networking opportunities.\r\n\r\nRequirements:\r\n\r\nBachelor&#39;s degree in Business Administration with a focus on Hospitality Management (BBA in Hospitality) Excellent communication and interpersonal skills Strong organizational and problem-solving abilities Leadership qualities and ability to motivate and inspire teams Proficiency in MS Office suite and hospitality management software (preferred) Flexibility to work in a dynamic and fast-paced environment Passion for the hospitality industry and commitment to delivering exceptional guest experiences Benefits:\r\n\r\nOpportunity to gain hands-on experience in hospitality management Exposure to various facets of the hospitality industry, including operations, marketing, and finance Mentorship and guidance from seasoned professionals Competitive salary and benefits package Potential for career advancement within the hospitality sector Joining IVAN College as a Hospitality Management Associate offers you a unique opportunity to contribute to the success of our hospitality operations and develop valuable skills for a rewarding career in the industry. If you are enthusiastic about hospitality management and eager to make a positive impact, we invite you to apply and join our dynamic team.\r\n', 1, 'master_admin', '8 April, 2024, 5:14 pm', ''),
(11, 'Bachelor of Hotel Management (BHM)', 'Hospitality', 'As a Bachelor of Hotel Management (BHM) graduate working as a Hospitality Management Trainee at IVAN College, you will be responsible for assisting in various aspects of hospitality management under the guidance of experienced professionals. Your role will encompass a wide range of tasks aimed at developing your skills and knowledge in the hospitality industry. Key Responsibilities: Front Desk Operations: Assist in managing front desk operations, including guest check-in/check-out, reservations, and handling inquiries. Customer Service: Provide exceptional customer service to guests, addressing their needs and resolving any issues or complaints promptly and professionally. Housekeeping Coordination: Coordinate with the housekeeping staff to ensure cleanliness and maintenance standards are upheld throughout the college premises. Food and Beverage Service: Support food and beverage service operations, including assisting with meal preparation, serving, and ensuring quality standards are met. Event Management: Assist in organizing and executing college events, such as seminars, conferences, and workshops, by coordinating logistics and providing on-site support. Inventory Management: Assist in managing inventory levels for supplies, equipment, and amenities, ensuring adequate stock levels are maintained. Safety and Security: Uphold safety and security procedures to ensure the well-being of guests, staff, and college property at all times. Administrative Support: Provide administrative support to various departments as needed, including data entry, filing, and document preparation. Team Collaboration: Work collaboratively with colleagues and supervisors to achieve departmental goals and maintain a positive work environment. Professional Development: Continuously seek opportunities to enhance your skills and knowledge through training programs, workshops, and self-study. Requirements: Bachelor&#39;s degree in Hotel Management or related field (BHM) Strong communication and interpersonal skills Customer-focused with a passion for delivering exceptional service Ability to multitask and prioritize tasks effectively Attention to detail and problem-solving abilities Flexibility to work in shifts and adapt to changing work environments Proficiency in MS Office suite and hospitality management software (preferred) Benefits: Opportunity to gain hands-on experience in the hospitality industry Exposure to various aspects of hotel and event management Mentorship and guidance from experienced professionals Competitive compensation package Potential for career advancement within the hospitality sector Joining IVAN College as a Hospitality Management Trainee provides you with a valuable opportunity to kickstart your career in the dynamic and rewarding field of hospitality management. If you are passionate about delivering exceptional guest experiences and eager to learn and grow in a supportive environment, we encourage you to apply and become a part of our team.\r\n', 1, 'master_admin', '8 April, 2024, 5:21 pm', '');

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

--
-- Table structure for table `onlinepayment`
--

CREATE TABLE `onlinepayment` (
  `pID` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `email` varchar(300) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `service` varchar(300) NOT NULL,
  `typeProduct` varchar(300) NOT NULL,
  `toValue` varchar(300) NOT NULL,
  `message` varchar(300) NOT NULL,
  `razorpayOrderId` varchar(300) NOT NULL,
  `razorpayPaymentId` varchar(300) NOT NULL,
  `paymentStatus` varchar(300) NOT NULL,
  `makerstamp` datetime NOT NULL,
  `updatestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `onlinepayment`
--

INSERT INTO `onlinepayment` (`pID`, `name`, `email`, `phone`, `service`, `typeProduct`, `toValue`, `message`, `razorpayOrderId`, `razorpayPaymentId`, `paymentStatus`, `makerstamp`, `updatestamp`) VALUES
(9, 'Soumen Dutta', 'sunny.soumen@gmail.com', '01231231235', 'service-charge', '', ' 50', 'Paid', 'order_MyseR8xgRz7DRG', '', 'PENDING', '2023-11-10 08:06:13', '2023-11-10 08:06:13'),
(10, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'service-charge', '', ' 50', 'Paid', 'order_Mysfsga6AUiOiN', '', 'PENDING', '2023-11-10 08:07:35', '2023-11-10 08:07:35'),
(11, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MyskdBm61Fv0V3', '', 'PENDING', '2023-11-10 08:12:05', '2023-11-10 08:12:05'),
(12, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MysmUtsxkaA2gK', '', 'PENDING', '2023-11-10 08:13:51', '2023-11-10 08:13:51'),
(13, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MysunmVB9qygAv', '', 'PENDING', '2023-11-10 08:21:42', '2023-11-10 08:21:42'),
(14, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MysuorjIXeSXh3', '', 'PENDING', '2023-11-10 08:21:43', '2023-11-10 08:21:43'),
(15, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MysuvLtKfWAJmR', 'pay_MysvgPdrVFsKMo', 'SUCCESS', '2023-11-10 08:21:49', '2023-11-10 08:22:48'),
(16, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MyszRGHS25B69U', '', 'PENDING', '2023-11-10 08:26:06', '2023-11-10 08:26:06'),
(17, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MyszSMgW1rtWIZ', '', 'PENDING', '2023-11-10 08:26:07', '2023-11-10 08:26:07'),
(18, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MyszYvr9bN3APq', 'pay_Myt07xCp5gVCIC', 'SUCCESS', '2023-11-10 08:26:13', '2023-11-10 08:26:59'),
(19, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_Myt1gOTIgkZhzE', '', 'PENDING', '2023-11-10 08:28:13', '2023-11-10 08:28:13'),
(20, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_Myt1hPQJhCy8L9', '', 'PENDING', '2023-11-10 08:28:14', '2023-11-10 08:28:14'),
(21, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_Myt4Jq48NkIrtJ', '', 'PENDING', '2023-11-10 08:30:43', '2023-11-10 08:30:43'),
(22, 'Soumen Dutta', 'sunny.soumen@gmail.com', '7412589636', 'serviceChargeForJobApplyId-4', '', ' 50', 'Paid', 'order_MytIoFGJ8du8AV', 'pay_MytJ9eGbk5VnOG', 'SUCCESS', '2023-11-10 08:44:26', '2023-11-10 08:45:02'),
(23, 'Soumen Dutta', 'sunny.soumen@gmail.com', '8653589652', 'serviceChargeForJobApplyId-3', '', ' 50', 'Paid', 'order_MytT5L2KyCOsdz', '', 'PENDING', '2023-11-10 08:54:09', '2023-11-10 08:54:09'),
(24, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-6', '', ' 50', 'Paid', 'order_N01qJu8RwYEWRH', '', 'PENDING', '2023-11-13 04:44:43', '2023-11-13 04:44:43'),
(25, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-6', '', ' 50', 'Paid', 'order_N01qcR5YK4Mosi', 'pay_N01rHVCFmJRCNj', 'SUCCESS', '2023-11-13 04:45:00', '2023-11-13 04:45:53'),
(26, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-8', '', ' 50', 'Paid', 'order_N1U6PcHB3XNWNn', '', 'PENDING', '2023-11-17 09:02:22', '2023-11-17 09:02:22'),
(27, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-8', '', ' 50', 'Paid', 'order_NCW4hJXYeiUY6U', '', 'PENDING', '2023-12-15 06:07:09', '2023-12-15 06:07:09'),
(28, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-9', '', ' 50', 'Paid', 'order_NCWQSkB3TYErOz', '', 'PENDING', '2023-12-15 06:27:45', '2023-12-15 06:27:45'),
(29, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-10', '', ' 50', 'Paid', 'order_NCbFfhV9gdENp7', '', 'PENDING', '2023-12-15 12:10:59', '2023-12-15 12:10:59'),
(30, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-10', '', ' 50', 'Paid', 'order_NCbJE84eT0gjfE', '', 'PENDING', '2023-12-15 12:14:21', '2023-12-15 12:14:21'),
(31, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-10', '', ' 50', 'Paid', 'order_NCbJIh2CCWiqOk', '', 'PENDING', '2023-12-15 12:14:25', '2023-12-15 12:14:25'),
(32, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-10', '', ' 50', 'Paid', 'order_NCcQS6j3kXuWvK', '', 'PENDING', '2023-12-15 01:19:52', '2023-12-15 01:19:52'),
(33, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-12', '', ' 50', 'Paid', 'order_NCcrUkREn50Usi', '', 'PENDING', '2023-12-15 01:45:28', '2023-12-15 01:45:28'),
(34, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-12', '', ' 50', 'Paid', 'order_NCdPIvLXHgFQPE', '', 'PENDING', '2023-12-15 02:17:29', '2023-12-15 02:17:29'),
(35, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-12', '', ' 50', 'Paid', 'order_NCdTQdspuZ8OUp', '', 'PENDING', '2023-12-15 02:21:23', '2023-12-15 02:21:23'),
(36, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-12', '', ' 50', 'Paid', 'order_NCdV1kNJMsuo2a', 'pay_NCdWrcAM5LWkcv', 'SUCCESS', '2023-12-15 02:22:54', '2023-12-15 02:25:18'),
(37, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-10', '', ' 50', 'Paid', 'order_NCdYatVi2QX6bj', 'pay_NCdZ3CspSGp4C8', 'SUCCESS', '2023-12-15 02:26:16', '2023-12-15 02:26:58'),
(38, 'Soumen Dutta', '', '', 'serviceChargeForJobApplyId-5', '', ' 50', 'Paid', 'order_NCdaBOIwu3biil', '', 'PENDING', '2023-12-15 02:27:47', '2023-12-15 02:27:47'),
(39, 'Soumen Dutta', '', '', 'serviceChargeForJobApplyId-5', '', ' 50', 'Paid', 'order_NCtNWzjeQcgHHl', '', 'PENDING', '2023-12-16 05:54:50', '2023-12-16 05:54:50'),
(40, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-8', '', ' 50', 'Paid', 'order_NCu4mHiqLoG1de', '', 'PENDING', '2023-12-16 06:35:49', '2023-12-16 06:35:49'),
(41, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-8', '', ' 50', 'Paid', 'order_NCu7grQMU4KMAH', '', 'PENDING', '2023-12-16 06:38:35', '2023-12-16 06:38:35'),
(42, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-8', '', ' 50', 'Paid', 'order_NCuFPuYfHJE7p5', '', 'PENDING', '2023-12-16 06:45:54', '2023-12-16 06:45:54'),
(43, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-8', '', ' 50', 'Paid', 'order_NCuLQF3kDYDhwq', '', 'PENDING', '2023-12-16 06:51:33', '2023-12-16 06:51:33'),
(44, 'Soumen Dutta', 'rockingfever.rocki@gmail.com', '08522588525', 'serviceChargeForJobApplyId-8', '', ' 50', 'Paid', 'order_NCudvBufmQBuHM', '', 'PENDING', '2023-12-16 07:09:05', '2023-12-16 07:09:05'),
(45, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-9', '', ' 50', 'Paid', 'order_NDVnXvR58VTPuk', '', 'PENDING', '2023-12-17 07:29:49', '2023-12-17 07:29:49'),
(46, 'Soumen Dutta', 'kalloldeysarkar1996@gmail.com', '+919735907380', 'serviceChargeForJobApplyId-9', '', ' 50', 'Paid', 'order_NDiIKlurJk6Yyr', '', 'PENDING', '2023-12-18 07:43:17', '2023-12-18 07:43:17'),
(47, 'Kallol', 'k.d@gmail.com', '9735907380', 'serviceChargeForJobApplyId-13', '', ' 50', 'Paid', 'order_NDlFyrPdvZ0Eiq', '', 'PENDING', '2023-12-18 10:37:08', '2023-12-18 10:37:08'),
(48, 'Kallol', '', '', 'serviceChargeForJobApplyId-15', '', ' 50', 'Paid', 'order_NE6GJPNmo5wy1Z', 'pay_NE6GsL6efGOR0n', 'SUCCESS', '2023-12-19 07:09:59', '2023-12-19 07:10:48'),
(49, 'Kallol', 'k.d@gmail.com', '9735907380', 'serviceChargeForJobApplyId-16', '', ' 50', 'Paid', 'order_NE9muFcq90jw4w', 'pay_NE9nRY1GhJRqTm', 'SUCCESS', '2023-12-19 10:36:54', '2023-12-19 10:37:46'),
(50, 'Kallol', 'k.d@gmail.com', '9735907380', 'serviceChargeForJobApplyId-14', '', ' 50', 'Paid', 'order_NE9sCd4kT9rB22', 'pay_NE9sXbG1yXK1Ic', 'SUCCESS', '2023-12-19 10:41:56', '2023-12-19 10:42:41'),
(51, 'Soumen Dutta', '', '', 'serviceChargeForJobApplyId-17', '', ' 50', 'Paid', 'order_NFOijcN4nG7Qgz', '', 'PENDING', '2023-12-22 12:52:31', '2023-12-22 12:52:31'),
(52, 'Soumen Dutta', 'sd@fg.com', '7894561235', 'serviceChargeForJobApplyId-18', '', ' 50', 'Paid', 'order_NFOlQ83mPo0aHH', '', 'PENDING', '2023-12-22 12:55:03', '2023-12-22 12:55:03'),
(53, 'Kallol', 'mdmohubulhoque@digix.in', '9875580466', 'serviceChargeForJobApplyId-22', '', ' 50', 'Paid', 'order_RGCk28Z2B20Ol0', '', 'PENDING', '2025-09-11 07:00:51', '2025-09-11 07:00:51'),
(54, 'Kallol', 'mdmohubulhoque@digix.in', '9875580466', 'serviceChargeForJobApplyId-22', '', ' 50', 'Paid', 'order_RGCt0yjzKMIo8d', '', 'PENDING', '2025-09-11 07:09:22', '2025-09-11 07:09:22');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `s_id` int(11) NOT NULL,
  `s_cat` varchar(300) NOT NULL,
  `s_img` varchar(300) NOT NULL,
  `s_video` varchar(300) NOT NULL,
  `s_creatdate` varchar(300) NOT NULL,
  `s_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`s_id`, `s_cat`, `s_img`, `s_video`, `s_creatdate`, `s_recycle`) VALUES
(7, 'image', '../upload/slider/Hotel_Management_Career.jpg', '', 'May 1, 2024 7:21 pm', 1),
(9, 'image', '../upload/slider/Top 10 hotel management colleges in kolkata.png', '', 'May 5, 2024 3:40 pm', 1);

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

--
-- Table structure for table `success_story`
--

CREATE TABLE `success_story` (
  `ss_id` int(11) NOT NULL,
  `ss_title` varchar(300) NOT NULL,
  `ss_des` longtext NOT NULL,
  `ss_cat` varchar(300) NOT NULL,
  `ss_img` varchar(300) NOT NULL,
  `ss_video` varchar(300) NOT NULL,
  `ss_creatdate` varchar(300) NOT NULL,
  `ss_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `success_story`
--

INSERT INTO `success_story` (`ss_id`, `ss_title`, `ss_des`, `ss_cat`, `ss_img`, `ss_video`, `ss_creatdate`, `ss_recycle`) VALUES
(3, 'Top Hotel Management Institute', 'Established in 2024, IIHM - Ivan Institute of Hotel Management is your springboard to a fulfilling career in the thriving hospitality industry. We offer intensive short-term courses designed to equip you with the essential skills and knowledge to excel in this fast-paced environment.\r\n', 'video', '', 'https://www.youtube.com/watch?v=fRmqXItAqvg', 'May 5, 2024 3:37 pm', 1);

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

--
-- Table structure for table `trainingplacement`
--

CREATE TABLE `trainingplacement` (
  `tp_id` int(11) NOT NULL,
  `tp_name` varchar(300) NOT NULL,
  `tp_img` varchar(300) NOT NULL,
  `tp_des` longtext NOT NULL,
  `tp_des_two` longtext NOT NULL,
  `tp_created` varchar(300) NOT NULL,
  `tp_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `trainingplacement`
--

INSERT INTO `trainingplacement` (`tp_id`, `tp_name`, `tp_img`, `tp_des`, `tp_des_two`, `tp_created`, `tp_recycle`) VALUES
(3, 'Bachelor of Hotel Management (BHM)', '../upload/tp/hItD_20240408173006.jpg', '<p><strong>Training and Placement Opportunities for Bachelor of Hotel Management (BHM) Students at IVAN College</strong></p>\r\n\r\n<p>At IVAN College, we recognize the importance of providing comprehensive training and robust placement opportunities for our Bachelor of Hotel Management (BHM) students. Our commitment to excellence extends beyond the classroom, ensuring that our students are well-prepared to excel in the competitive hospitality industry.</p>\r\n', '<p><strong>1. Practical Training:</strong> BHM students at IVAN College undergo rigorous practical training to develop essential skills and competencies required in the hospitality sector. Our state-of-the-art facilities, including fully-equipped kitchens, mock hotel rooms, and simulation labs, provide students with hands-on experience in various aspects of hotel management, culinary arts, food and beverage service, front office operations, and more.</p>\r\n\r\n<p><strong>2. Industry Internships:</strong> We facilitate industry internships for our BHM students, allowing them to gain valuable real-world experience in leading hotels, resorts, restaurants, and hospitality organizations. These internships provide students with the opportunity to apply their academic knowledge in a professional setting, network with industry professionals, and gain insights into industry trends and practices.</p>\r\n\r\n<p><strong>3. Career Counseling and Guidance:</strong> Our dedicated career counseling team provides personalized guidance and support to BHM students, helping them identify their career goals, explore job opportunities, and develop job search strategies. From resume writing workshops to mock interviews and career fairs, we equip students with the tools and resources they need to succeed in the job market.</p>\r\n\r\n<p><strong>4. Industry Partnerships:</strong> IVAN College has established strong partnerships with leading hospitality industry partners, including hotels, resorts, restaurant chains, and tourism organizations. These partnerships provide our BHM students with access to exclusive job openings, networking events, guest lectures, and mentorship opportunities, enhancing their career prospects and industry connections.</p>\r\n\r\n<p><strong>5. Alumni Network:</strong> Our extensive alumni network consists of successful BHM graduates who have gone on to pursue rewarding careers in the hospitality industry. As part of the IVAN College community, BHM students benefit from valuable alumni connections, professional mentorship, and networking opportunities, further enhancing their career advancement prospects.</p>\r\n\r\n<p><strong>6. Placement Assistance:</strong> IVAN College offers comprehensive placement assistance to BHM students, connecting them with top employers in the hospitality sector and facilitating job placements upon graduation. Our placement team works closely with students to match their skills and interests with suitable job opportunities, ensuring a seamless transition from academia to the workforce.</p>\r\n\r\n<p>At IVAN College, we are committed to empowering our BHM students with the knowledge, skills, and experiences they need to succeed in the dynamic and rapidly evolving hospitality industry. Through practical training, industry internships, career counseling, industry partnerships, alumni support, and placement assistance, we prepare our students to embark on successful and fulfilling careers in hotel management and related fields.</p>\r\n', '2024-04-08 17:30:06', 1);

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

--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `v_id` int(11) NOT NULL,
  `v_title` varchar(300) NOT NULL,
  `v_video` varchar(300) NOT NULL,
  `v_url` varchar(300) NOT NULL,
  `v_creatdate` varchar(300) NOT NULL,
  `v_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `video`
--

INSERT INTO `video` (`v_id`, `v_title`, `v_video`, `v_url`, `v_creatdate`, `v_recycle`) VALUES
(2, 'Top hotel Management Training institute in Kolkata', '../upload/video/Top-hotel-Management-Training-institute-in-Kolkata.mp4', 'upload/video/Top-hotel-Management-Training-institute-in-Kolkata.mp4', '2024-05-05 15:33:29', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blog`
--
ALTER TABLE `blog`
  ADD PRIMARY KEY (`b_id`);

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

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

--
-- Indexes for table `contct`
--
ALTER TABLE `contct`
  ADD PRIMARY KEY (`sl`);

--
-- Indexes for table `course`
--
ALTER TABLE `course`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `employers`
--
ALTER TABLE `employers`
  ADD PRIMARY KEY (`emp_id`);

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

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

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

--
-- Indexes for table `onlinepayment`
--
ALTER TABLE `onlinepayment`
  ADD PRIMARY KEY (`pID`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`s_id`);

--
-- Indexes for table `success_story`
--
ALTER TABLE `success_story`
  ADD PRIMARY KEY (`ss_id`);

--
-- Indexes for table `trainingplacement`
--
ALTER TABLE `trainingplacement`
  ADD PRIMARY KEY (`tp_id`);

--
-- Indexes for table `video`
--
ALTER TABLE `video`
  ADD PRIMARY KEY (`v_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blog`
--
ALTER TABLE `blog`
  MODIFY `b_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `city`
--
ALTER TABLE `city`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `contct`
--
ALTER TABLE `contct`
  MODIFY `sl` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `course`
--
ALTER TABLE `course`
  MODIFY `course_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `employers`
--
ALTER TABLE `employers`
  MODIFY `emp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `interview_location_time`
--
ALTER TABLE `interview_location_time`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `job_apply`
--
ALTER TABLE `job_apply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `job_post`
--
ALTER TABLE `job_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `onlinepayment`
--
ALTER TABLE `onlinepayment`
  MODIFY `pID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `s_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `success_story`
--
ALTER TABLE `success_story`
  MODIFY `ss_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `trainingplacement`
--
ALTER TABLE `trainingplacement`
  MODIFY `tp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `video`
--
ALTER TABLE `video`
  MODIFY `v_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

