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

START TRANSACTION;



--
-- Database: `idipiacom_ine_new`
--

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

--
-- Table structure for table `albums`
--

CREATE TABLE `albums` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `albums`
--

INSERT INTO `albums` (`id`, `name`, `slug`, `image`, `alt`, `meta_title`, `meta_description`, `meta_keyword`, `created_at`, `updated_at`) VALUES
(1, 'Lohri Celebration', 'lohri-celebration', '1678902823.lohri.jpg', NULL, NULL, NULL, NULL, '2023-03-15 12:23:43', '2023-03-15 12:23:43'),
(2, 'Teej Celebration', 'teej-celebration', '1679216211.tejj.jpg', NULL, NULL, NULL, NULL, '2023-03-19 03:26:51', '2023-03-19 03:26:51'),
(5, 'World Health Day 2022', 'world-health-day-2022', '1683279151.WHO DAY 2022.jpg', NULL, NULL, NULL, NULL, '2023-05-05 13:32:31', '2023-05-05 13:32:31'),
(7, 'International Thalassemia Day 2022', 'international-thalassemia-day-2022', '1683279567.International Thalassemia Day 2022.jpg', NULL, NULL, NULL, NULL, '2023-05-05 13:39:27', '2023-05-05 13:39:27'),
(8, 'International Yoga Day 2022', 'international-yoga-day-2022', '1683280138.Yoga.jpeg', NULL, NULL, NULL, NULL, '2023-05-05 13:48:58', '2023-05-05 13:48:58'),
(9, 'Sehaj Path 2022', 'sehaj-path-2022', '1683353683.Sehaj Path 2022.jpg', NULL, NULL, NULL, NULL, '2023-05-06 10:14:43', '2023-05-06 10:14:43'),
(10, 'World Alzheimer\'s Day 2022', 'world-alzheimer\'s-day-2022', '1683354281.World Alzheimers Day 2022.jpg', NULL, NULL, NULL, NULL, '2023-05-06 10:24:41', '2023-05-06 10:24:41'),
(11, 'World Suicide Prevention Day 2022', 'world-suicide-prevention-day-2022', '1683611095.World Suicide Prevention Day 2022.jpg', NULL, NULL, NULL, NULL, '2023-05-09 09:44:55', '2023-05-09 09:44:55'),
(12, 'Lohri Celebration 2023', 'lohri-celebration-2023', '1683612908.Lohri 2022.jpg', NULL, NULL, NULL, NULL, '2023-05-09 09:51:07', '2023-05-09 10:15:08'),
(13, 'Webinar#Developing tourism in Mission Mode#2023', 'webinar#developing-tourism-in-mission-mode#2023', '1683611779.webinar on Developing Tourism in Mission Mode organised by The Ministry of Tourism 2022.jpg', NULL, NULL, NULL, NULL, '2023-05-09 09:56:19', '2023-05-09 10:15:57'),
(14, 'International Women\'s Day 2023', 'international-women\'s-day-2023', '1683612216.Womens Day 2022.JPG', NULL, NULL, NULL, NULL, '2023-05-09 10:03:36', '2023-05-09 10:16:12'),
(15, 'Buddy Program # March 2023', 'buddy-program-#-march-2023', '1683612506.Buddy Program 2022.jpg', NULL, NULL, NULL, NULL, '2023-05-09 10:08:26', '2023-05-09 10:17:13'),
(16, 'World Health Day 2023', 'world-health-day-2023', '1683613155.World Health Day 2023.jpg', NULL, NULL, NULL, NULL, '2023-05-09 10:19:15', '2023-05-09 10:19:15'),
(17, 'Freshers Party 2023', 'freshers-party-2023', '1683613287.Freshers Day 2023.jpg', NULL, NULL, NULL, NULL, '2023-05-09 10:21:27', '2023-05-09 10:21:27'),
(18, 'Buddy Program # April 2023', 'buddy-program-#-april-2023', '1683613355.Buddy Program April 2023.jpg', NULL, NULL, NULL, NULL, '2023-05-09 10:22:35', '2023-05-09 10:22:35'),
(19, 'International Nurses Day 2023', 'international-nurses-day-2023', '1683904274.12.JPG', NULL, NULL, NULL, NULL, '2023-05-12 19:05:03', '2023-05-12 19:11:14'),
(20, 'International Yoga Day 2023', 'international-yoga-day-2023', '1716273599.IMG_9414.JPG', NULL, NULL, NULL, NULL, '2024-05-21 10:39:59', '2024-05-21 10:39:59'),
(21, 'Seminar on International Healthcare Professionals Bridge Program, Las Vegas, Nevada, USA', 'seminar-on-international-healthcare-professionals-bridge-program,-las-vegas,-nevada,-usa', '1716274795.IMG_2753.JPG', NULL, NULL, NULL, NULL, '2024-05-21 10:59:55', '2024-05-21 10:59:55'),
(22, 'Sehaj Path 2023', 'sehaj-path-2023', '1716274957.12345.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:02:37', '2024-05-21 11:02:37'),
(23, 'Teachers Day 2023', 'teachers-day-2023', '1716275082.12346.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:04:42', '2024-05-21 11:04:42'),
(24, 'Buddy Program # September 2023', 'buddy-program-#-september-2023', '1716275487.buddy.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:11:27', '2024-05-21 11:11:27'),
(25, 'World Alzheimer’s Day 2023', 'world-alzheimer’s-day-2023', '1716275726.12347.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:15:26', '2024-05-21 11:15:26'),
(26, 'World Heart Day 2023', 'world-heart-day-2023', '1716275999.12348.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:19:59', '2024-05-21 11:19:59'),
(27, '30th SNAI Biennial Conference organised by TNAI Punjab State Branch', '30th-snai-biennial-conference-organised-by-tnai-punjab-state-branch', '1716276278.PHOTO-2023-11-29-19-18-38.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:24:38', '2024-05-21 11:24:38'),
(28, 'World Mental Health Day 2023', 'world-mental-health-day-2023', '1716276382.12345.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:26:22', '2024-05-21 11:26:22'),
(29, 'World Osteoporosis Day 2023', 'world-osteoporosis-day-2023', '1716276502.12346.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:28:22', '2024-05-21 11:28:22'),
(30, 'World AIDS Day', 'world-aids-day', '1716276646.12347.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:30:46', '2024-05-21 11:30:46'),
(31, 'Expert talk on HIV/ AIDS at Devki Devi Jain College of Education, Ludhiana.', 'expert-talk-on-hiv/-aids-at-devki-devi-jain-college-of-education,-ludhiana.', '1716276799.12348.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:33:19', '2024-05-21 11:33:19'),
(32, 'Sri Sukhmani Sahib Path 2023', 'sri-sukhmani-sahib-path-2023', '1716276911.12349.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:35:11', '2024-05-21 11:35:11'),
(33, 'Buddy program # Dec. 2023: Guest lecture was given by Dr. Arvind Goyal, De-addiction & Psychiatry Consultant, Civil Hospital, Ludhiana', 'buddy-program-#-dec.-2023:-guest-lecture-was-given-by-dr.-arvind-goyal,-de-addiction-&-psychiatry-consultant,-civil-hospital,-ludhiana', '1716277526.12345.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:45:26', '2024-05-21 11:45:26'),
(34, 'CPR Awareness Programme 2023 by National board of Examination in Medical Sciences (NBEMS), India', 'cpr-awareness-programme-2023-by-national-board-of-examination-in-medical-sciences-(nbems),-india', '1716277814.12346.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:50:14', '2024-05-21 11:50:14'),
(35, 'Webinar regarding Viksit Bharat on 11.12. 2023', 'webinar-regarding-viksit-bharat-on-11.12.-2023', '1716277955.12347.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:52:35', '2024-05-21 11:52:35'),
(36, 'Inauguration of free medical camp on the occasion of Shaheedi Purab of ‘Hind di Chadar’ Sri Guru Teg Bahadur Sahib Ji', 'inauguration-of-free-medical-camp-on-the-occasion-of-shaheedi-purab-of-‘hind-di-chadar’-sri-guru-teg-bahadur-sahib-ji', '1716278138.123456.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:55:38', '2024-05-21 11:55:38'),
(37, 'Gurmat Samagam on the occasion of Shaheedi Purab of ‘Hind di Chadar’ Sri Guru Teg Bahadur Sahib Ji', 'gurmat-samagam-on-the-occasion-of-shaheedi-purab-of-‘hind-di-chadar’-sri-guru-teg-bahadur-sahib-ji', '1716278241.123458.jpg', NULL, NULL, NULL, NULL, '2024-05-21 11:57:21', '2024-05-21 11:57:21'),
(38, 'Lohri 2024', 'lohri-2024', '1716278515.LOHRI 2024.jpg', NULL, NULL, NULL, NULL, '2024-05-21 12:01:55', '2024-05-21 12:01:55'),
(39, 'Farewell 2024', 'farewell-2024', '1716278616.12345.jpg', NULL, NULL, NULL, NULL, '2024-05-21 12:03:36', '2024-05-21 12:03:36'),
(40, 'Mera Pehla Vote Desh Ke Liye 2024', 'mera-pehla-vote-desh-ke-liye-2024', '1716278728.12346.jpg', NULL, NULL, NULL, NULL, '2024-05-21 12:05:28', '2024-05-21 12:05:28'),
(41, 'World Cancer Day 2024', 'world-cancer-day-2024', '1716278830.123457.jpg', NULL, NULL, NULL, NULL, '2024-05-21 12:07:10', '2024-05-21 12:07:10'),
(43, 'Expert Talk on \"Cyber Security\"', 'expert-talk-on-\"cyber-security\"', '1716438423.12345.jpg', NULL, NULL, NULL, NULL, '2024-05-23 08:27:03', '2024-05-23 08:27:03'),
(44, 'Expert Talk on \"Road Safety\"', 'expert-talk-on-\"road-safety\"', '1716438503.123456.jpg', NULL, NULL, NULL, NULL, '2024-05-23 08:28:23', '2024-05-23 08:28:23'),
(45, 'World Tuberculosis Day 2024', 'world-tuberculosis-day-2024', '1716438709.123456.jpg', NULL, NULL, NULL, NULL, '2024-05-23 08:31:49', '2024-05-23 08:31:49'),
(46, 'Exhibition on \"Audio Visual Aids\"', 'exhibition-on-\"audio-visual-aids\"', '1716438821.1256.jpg', NULL, NULL, NULL, NULL, '2024-05-23 08:33:41', '2024-05-23 08:33:41'),
(47, 'Baisakhi 2024', 'baisakhi-2024', '1716438961.123458.jpg', NULL, NULL, NULL, NULL, '2024-05-23 08:36:01', '2024-05-23 08:36:01'),
(48, 'International Nurses Day, 2024', 'international-nurses-day,-2024', '1716439047.123456789.jpg', NULL, NULL, NULL, NULL, '2024-05-23 08:37:27', '2024-05-23 08:37:27');

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `btn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `btn_link` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `banners`
--

INSERT INTO `banners` (`id`, `title`, `description`, `url`, `image`, `alt`, `btn`, `btn_link`, `created_at`, `updated_at`) VALUES
(6, 'Preparing Nurses for a changing World', 'Best Nursing College in Punjab', NULL, '1678858392.college.jpg', NULL, NULL, NULL, '2023-03-15 00:03:12', '2023-05-15 11:33:47'),
(7, 'Institute of Nursing Education, Guru Teg Bahadur Sahib (C) Hospital, Ludhiana', 'Best B.Sc./G.N.M Nursing College in Punjab', NULL, '1678986624.nursing-hostel2.jpg', NULL, NULL, NULL, '2023-03-16 11:40:24', '2023-05-21 11:10:45'),
(8, 'Campus', '\"Education is the most powerful weapon which you can use to change the World.\"', NULL, '1684140315.GSM_9277.JPG', NULL, NULL, NULL, '2023-05-15 11:12:55', '2023-05-15 12:45:15'),
(9, 'WELCOME', NULL, NULL, '1684135042.GSM_9268.JPG', NULL, NULL, NULL, '2023-05-15 11:17:22', '2023-05-15 11:28:24'),
(11, 'Challenges are what make life interesting and overcoming them is what makes life meaningful.', NULL, NULL, '1695577839.ine-buidung-min.jpeg', NULL, NULL, NULL, '2023-05-15 12:49:39', '2023-09-24 21:50:39');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `featured_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metatitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadescription` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `metakeyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `description`, `short_description`, `featured_image`, `alt`, `slug`, `metatitle`, `metadescription`, `metakeyword`, `created_at`, `updated_at`) VALUES
(1, 'Freshers Day', '<p>Freshers Day in college is a special event organized by senior students and faculty members to welcome and introduce new students to college life. The purpose of Freshers Day is to make new students feel comfortable and welcomed in their new environment, and to give them a chance to meet their classmates and faculty members.</p><p>The content of Freshers Day events can vary from college to college, but some common activities and elements include:</p><p>Introduction and Welcome Speech: The event usually starts with an introduction by the college principal, followed by a welcome speech from senior students or faculty members.</p><p>Ice-breaker Activities: Ice-breaker activities are organized to help new students get to know each other and feel more comfortable. These activities can include games, quizzes, and group discussions.</p><p>Cultural Performances: Cultural performances such as dance, music, and drama are often presented by senior students to entertain new students and showcase the college\'s cultural diversity.</p><p>Motivational Talks: Motivational talks are given by successful alumni or guest speakers to inspire new students and provide them with guidance and advice for their academic and personal growth.</p><p>Refreshments: Refreshments such as snacks and beverages are usually provided to new students to create a friendly and welcoming atmosphere.</p><p>Overall, Freshers Day is an important event that sets the tone for the rest of the academic year and helps new students feel more connected to their college community.</p>', 'Freshers Day in college is a special event organized by senior students and faculty members to welcome and introduce new students to college life. The purpose of Freshers Day is to make new students feel comfortable and welcomed in their new environment, and to give them a chance to meet their classmates and faculty members.', '1680805609.freaher-day.jpeg', NULL, 'freshers-day', NULL, NULL, NULL, '2023-03-16 12:21:06', '2023-04-06 12:56:49'),
(2, 'Cancer Day', '<p>World Cancer Day is observed annually on February 4th to raise awareness about cancer, encourage its prevention, detection, and treatment, and to support those affected by cancer. The day aims to reduce the global impact of cancer by promoting education about the disease and advocating for improved access to cancer care, research, and treatment. World Cancer Day was first observed in 2000 and is coordinated by the Union for International Cancer Control (UICC). Every year, the UICC sets a theme for World Cancer Day to focus on a specific aspect of cancer prevention and treatment.</p>', 'World Cancer Day is observed annually on February 4th to raise awareness about cancer, encourage its prevention, detection, and treatment, and to support those affected by cancer.', '1680805461.cancer-day.jpg', NULL, 'cancer-day', NULL, NULL, NULL, '2023-03-16 12:21:54', '2023-04-06 12:54:21');

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `name`, `slug`, `description`, `image`, `meta_title`, `meta_description`, `meta_keyword`, `created_at`, `updated_at`) VALUES
(1, 'General Nursing and Midwifery', 'general-nursing-and-midwifery', '<p>10+2 with 40% marks from any recognized board in any stream, 35% for SC/ST candidates.</p><p>Candidates from State Open School recognized by state government and from National Institute of Open School recognized by Central government are also eligible.</p><p><strong>Eligibility Criteria</strong></p><ul><li>The minimum age of admission shall be 17 years and maximum age is 35 years. There is no age bar for ANM/LHV.</li><li>Minimum education:</li><li>Registered ANM</li><li>For N.R.I. students, the entry qualification equivalency will be obtained by Association of Indian Universities, New Delhi. Institution, State Nursing Council will be responsible to ensure that the qualification and eligibility is equivalent to what has been prescribed as above</li><li>The students should be duly vaccinated, especially TABC, Hep B, Chicken pox prior to admission to the institute.</li><li>Candidate shall be medically fit. The medical examination will be conducted by the G.T.B.S. (C) Hospital, Model Town, Ludhiana.</li><li>No admission or adjustment shall be made after October 31st regardless of any vacancy that might arise thereafter.</li></ul>', '1679212693.143489-OTCTIT-466.jpg', 'GTB Nursing', NULL, NULL, '2023-03-15 00:23:46', '2023-03-19 02:28:13'),
(4, 'B.Sc. (Nursing)', 'bsc-(nursing)', '<p>Duration: Four years degree course</p>', NULL, NULL, NULL, NULL, '2023-04-29 18:27:28', '2023-04-29 18:27:28'),
(5, 'B.Sc. (Nursing) Post Basic', 'bsc-(nursing)-post-basic', '<p>Duration: &nbsp;Two year course</p>', NULL, NULL, NULL, NULL, '2023-04-29 18:28:47', '2023-04-29 18:28:47'),
(6, 'General Nursing & Midwifery', 'general-nursing-&-midwifery', '<p>Duration: Three year diploma course</p>', NULL, NULL, NULL, NULL, '2023-04-29 18:30:08', '2023-04-29 18:30:08');

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

--
-- Table structure for table `discographies`
--

CREATE TABLE `discographies` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `failed_jobs`
--

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

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

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint UNSIGNED NOT NULL,
  `album_id` int NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `galleries`
--

INSERT INTO `galleries` (`id`, `album_id`, `title`, `image`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, '16789028361344821033641206347ec43.jpeg', '2023-03-15 12:23:56', '2023-03-15 12:23:56'),
(7, 2, NULL, '167921622210542149366416ce5e352a6.jpeg', '2023-03-19 03:27:02', '2023-03-19 03:27:02');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_01_12_093641_create_products_table', 2),
(6, '2022_01_15_085452_add_deleted_at_to_products_table', 3),
(7, '2022_01_15_105401_create_carts_table', 4),
(8, '2022_01_17_070641_add_product_id_to_carts_table', 5),
(9, '2022_01_18_092646_create_orders_table', 6),
(10, '2022_01_18_093755_add_paymentmethod_to_orders_table', 7),
(11, '2022_01_18_094042_add_paymentmethod_to_orders_table', 8),
(12, '2022_01_18_114242_create_orderitems_table', 9),
(13, '2022_01_20_061439_create_coupons_table', 10),
(14, '2022_01_20_064308_add_validupto_to_coupons_table', 11),
(15, '2022_01_20_075304_add_userid_to_coupons_table', 12),
(16, '2022_06_22_113746_create_postcategory_table', 13),
(18, '2022_06_22_114155_create_postcategories_table', 14),
(19, '2022_06_23_103938_create_posts_table', 15),
(20, '2022_06_23_104557_create_post_images_table', 16),
(21, '2022_06_23_110115_update_and_addstatus_to_posts_table', 17),
(22, '2022_06_24_100905_create_product_images_table', 18),
(23, '2022_06_27_114738_create_blogs_table', 19),
(24, '2022_06_27_121138_create_testimonials_table', 20),
(25, '2022_06_28_091317_create_galleries_table', 21),
(26, '2022_07_20_102158_create_readings_table', 22),
(27, '2022_07_21_082830_create_billingdetails_table', 23),
(28, '2022_07_22_063951_create_usermessages_table', 24),
(29, '2022_08_01_121100_create_youtube_videos_table', 25),
(30, '2022_08_02_050416_create_albums_table', 26),
(31, '2022_08_03_054120_create_discographies_table', 27),
(32, '2022_08_10_055541_create_video_categories_table', 28),
(33, '2022_09_17_070313_create_banners_table', 29),
(34, '2023_03_14_171948_create_staff_table', 30),
(35, '2023_03_15_053820_create_courses_table', 31),
(36, '2023_03_15_060150_create_pages_table', 32);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint UNSIGNED NOT NULL,
  `parent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` int NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `parent`, `position`, `name`, `slug`, `description`, `image`, `meta_title`, `meta_description`, `meta_keyword`, `created_at`, `updated_at`) VALUES
(1, '0', 1, 'Message', 'message', '<p>In the later part of the twentieth century, the likeminded Sikh residents of a very posh locality of Ludhiana, envisioned opening of a hospital for the lesser fortunate groups of the society. They collected a sum of Rs. 8400/- and started a charitable dispensary in the name of Shri Guru Teg Bahadur Sahib. The, then Chief Minister of Punjab, Giani Zail Singh allotted 4000 yards of land for expanding that dispensary to a hospital, which now proudly stands as Guru Teg Bahadur Sahib (C) Hospital, Model Town, Ludhiana.</p><p>The hospital commenced operations on Oct.29th 1978 under the guidance of Guru Teg Bahadur Sahib (C) Hospital Society. The management consists of educationationists, humanitarians and visionaries whose purpose is to serve the fellow men with all humility and passion.</p><p>From a hospital which started serving with 22 beds, it has grown substantially in terms of infrastructure and services offered. It is now a 250 bedded multispecialty hospital which delivers exemplary service with the help of latest technology in modern science.</p><p>Institute of Nursing Education was established in 1989 with a generous donation of Rs.1 lac by Principal S. Surjit Singh Bhatia (Retd. DPI Colleges). This Institute plunged into the field of education with 35 GNM students with the motive of providing employment opportunities to women belonging to the rural areas of Punjab. After more than two decades of being functional, this institution now has a strength of 540 students in GNM, B.Sc.(N) and P.B. B.Sc.(N).</p><p>Institute of Nursing Education is situated in a prime neighbourhood in the city of Ludhiana, just opposite of GTBS (C) Hospital. The institute is easily accessible, being merely 2 km away from ISBT and 3.5 km away from the railway station. It is duly recognized by Punjab Nurses Registration Council, Mohali, Baba Farid University of Health Sciences, Faridkot and Indian Nursing Council, New Delhi.</p><p>The basic objective of this prestigious institution is to create an environment necessary for the overall growth and development of the students. With the help of a balanced theoretical and practical curriculum, the students acquire working skills and realize their true potential. Students are given ample opportunities to organize and participate in various conferences, seminars and workshops in the state and national level.</p><p>With the blessings of Shri Guru Teg Bahadur Sahib Ji and because of the sincere efforts of our hard working management and faculty, this institution has become the primary choice of students from all over North India.</p>', '1678861112.college.jpg', NULL, NULL, NULL, '2023-03-15 00:48:32', '2023-04-29 19:50:25'),
(3, '1', 1, 'MIssion & Vision', 'mission-&-vision', '<h4><strong>Aims and objectives</strong></h4><ol><li>Apply knowledge from physical, biological and behavioral sciences in providing nursing care to individuals, families and communities.</li><li>Demonstrate critical thinking and practice within the frame work of code of ethics and acceptable standards of community health policies.</li><li>Provide promotive, preventive and restorative health services in line with the national health policies and programmes.</li><li>Communicate and participate effectively as members of the health team to promote interpersonal relationships and team work.</li><li>Present leadership and managerial skills in clinical and community health settings.</li><li>Assume the role of a teacher, supervisor, nurse manager and contribute to advancement of self and of the profession.</li><li>Engage in lifelong learning, conduct need based research and utilize the research findings to improve the quality of health care system.<br><br>&nbsp;</li></ol>', NULL, NULL, NULL, NULL, '2023-03-15 00:52:31', '2023-04-29 20:01:00'),
(4, '1', 3, 'Principal Message', 'principal-message', '<p>&nbsp;</p><figure class=\"image image-style-side\"><img src=\"https://www.gtbhnursing.com/admin/ckeditor/1680935701.93-3821-Ponamma.jpg\"></figure><p>Dear Candidates,</p><p>God has been extremely gracious throughout the years. He has provided all the facilities and faculty for teaching and preparing nursing students as they are our future working force.</p><p>Nursing is a dynamic, therapeutic and educative profession that helps in meeting the health needs of the society. A nurse has to be a critical thinker and an empathetic healer at the same time.</p><p>Guru Teg Bahadur Sahib ( C) Hospital Society seeks to make significant contribution to the health standards of all communities, with special emphasis on health care in the rural communities of India. Our nursing students have brought laurels to the institution by their academic achievements and have also bagged many prizes in co curricular activities at the state and national level. The credit for the progression and growth of the institute goes to our worthy management and also to the experienced, competent and hard working faculty under the guidance of our worthy Director</p><p>I welcome you in our college and expect your co operation and hard work.</p><p><strong>Mrs. Ponamma R Singh</strong></p><p>Principal</p>', NULL, NULL, NULL, NULL, '2023-03-15 11:42:25', '2023-04-29 20:01:47'),
(5, '1', 2, 'Director\'s Message', 'director\'s-message', '<p>Dear Students,</p><p>Institute of Nursing Education is an avant garde institution where standards of workmanship, dedication and excellence are observed and governed by Guru Teg Bahadur Sahib (C ) Hospital Society. The motto of the institute is to provide worthy education that guarantees hundred percent placement in this age of acute unemployment, and also, enables the students to develop cognitive as well as empathetic abilities.&nbsp;</p><p>From Bhai Ghaniya to Florence Nightingale and from Bhagat Puran Singh to Mother Teresa, service to humanity has always been a pathway to spiritual elevation and ethical existence. In this world, where success is directly proportional to materialistic earnings, nursing provides an opportunity to be worldly and spiritually affluent. The study and practice of nursing inculcates in the students the aptitude to think critically and work effortlessly for dispensing quality health care.</p><p>We, at Institute of Nursing Education recognize the importance of providing a supportive and stimulative learning environment using innovative teaching and learning strategies. With the help of a goal oriented governing body and a focused faculty, we hope that our students will continue to set and achieve impressive levels of success. I, on behalf of the institute, welcome you all and extend a reassurance that your stay in the institute will prepare you to sustain and grow in the world outside.</p><p>&nbsp;</p><p>Wishing you all the success,</p><p>&nbsp;</p><p><strong>Dr. Amarjeet Singh Dua</strong></p><p><strong>Director</strong></p>', '1678900432.director.png', NULL, NULL, NULL, '2023-03-15 11:43:52', '2023-04-29 20:01:25'),
(6, '0', 2, 'About College', 'about-college', NULL, NULL, NULL, NULL, NULL, '2023-03-15 11:53:44', '2023-05-05 13:03:50'),
(17, '6', 1, 'Campus', 'campus', NULL, NULL, NULL, NULL, NULL, '2023-04-29 19:25:16', '2023-04-29 19:57:47'),
(19, '6', 2, 'Laboratories', 'laboratories', '<ol><li>Nursing Foundation Laboratory</li><li>Community Health Nursing Practice Laboratory</li><li>Obstetrics and Gynaecology Laboratory</li><li>Paediatrics Nursing Laboratory</li><li>Pre-Clinical Sciences Laboratory</li><li>Nutrition Laboratory</li><li>Advanced Nursing Laboratory</li><li>Audio-Visual Aid Laboratory</li><li>Computer Laboratory</li></ol>', NULL, NULL, NULL, NULL, '2023-04-29 19:25:45', '2023-04-29 20:41:45'),
(20, '6', 3, 'Library', 'library', NULL, NULL, NULL, NULL, NULL, '2023-04-29 19:26:53', '2023-04-29 19:58:50'),
(21, '6', 4, 'Hostel', 'hostel', NULL, NULL, NULL, NULL, NULL, '2023-04-29 19:27:32', '2023-04-29 19:59:12'),
(26, '8', 2, 'B.Sc. (Nursing) Post Basic', 'bsc-(nursing)-post-basic', '<p><strong>B. Sc. NURSING POST BASIC</strong></p><p><strong>ADMISSION TERMS &amp; CONDITIONS</strong></p><p>1. Passed the Higher Secondary or Senior Secondary or Intermediate or 10+2 or an equivalent examination recognized by the university for this purpose.&nbsp;</p><p>2. Obtained a certificate in General Nursing and Midwifery and registered as R.N.R.M. with the State Nurses Registration Council.&nbsp;</p><p>3. Candidate shall be medically fit.</p><p>4. Students shall be admitted once in a year.</p>', NULL, NULL, NULL, NULL, '2023-04-29 20:03:20', '2024-06-07 12:51:45'),
(25, '8', 1, 'B.Sc. (Nursing)', 'bsc-(nursing)', '<p><strong>B. Sc. NURSING&nbsp;</strong></p><p><strong>ADMISSION TERMS &amp; CONDITIONS</strong></p><p>1. The minimum age for admission shall be 17 years on 31st December of the year in which admission is sought.&nbsp;</p><p>2. Minimum Educational Qualification&nbsp;</p><p>a) Candidate with Science who have passed the qualifying 12th Standard examination (10+2) and must have obtained a minimum of 45% marks in Physics, Chemistry and Biology taken together. The candidate must have pass marks in English.&nbsp;</p><p>b) Candidates are also eligible from State Open School recognized by State Government and National Institute of Open School (NIOS) recognized by Central Government having Science subjects and English only.&nbsp;</p><p>c) English is a compulsory subject in 10+2 for being eligible for admission to B.Sc. (Nursing).&nbsp;</p><p>3. Candidate shall be medically fit.&nbsp;</p><p>4. Students shall be admitted once in a year.&nbsp;</p><p>5. Selection of candidates should be based on the merit of the entrance examination.</p>', NULL, NULL, NULL, NULL, '2023-04-29 20:02:56', '2024-06-07 12:59:45'),
(8, '0', 3, 'Programs', 'programs', NULL, NULL, NULL, NULL, NULL, '2023-03-16 11:05:27', '2023-04-29 19:56:53'),
(27, '8', 3, 'General Nursing & Midwifery', 'general-nursing-&-midwifery', '<p><strong>GENERAL NURSING &amp; MIDWIFERY</strong></p><p><strong>ADMISSION TERMS &amp; CONDITIONS</strong></p><p>1. Minimum education eligibility criteria for admission to GNM: &nbsp;</p><ul><li>10+2 with English and must have obtained a minimum of 40% at the qualifying examination and English individually from any recognized board.&nbsp;</li><li>Candidates are also eligible from State Open School recognized by State Government and National Institute of Open School (NIOS) recognized by Central Government. However Science is preferable. Three (core elective) subject marks&nbsp;may be taken for calculating the percentage of marks excluding the marks in English. Also, it has to be ensured the candidate has pass marks in English. &nbsp;</li><li>10+2 with English having 40% of marks in vocational ANM course from the school recognized by Indian Nursing Council. &nbsp;</li><li>10+2 with English having 40% of marks in Vocational Stream-Health care Science from a recognized CBSE board/State/Centre.&nbsp;</li><li>Registered ANM with pass marks.</li></ul><p>2. Admission of students shall be once in a year.&nbsp;</p><p>3. Students shall be medically fit.&nbsp;</p><p>4. Minimum age for admission will be 17 years (as on 31st December of that year).&nbsp;</p>', NULL, NULL, NULL, NULL, '2023-04-29 20:03:50', '2024-06-07 12:57:09'),
(28, '8', 4, 'Short Term Courses', 'short-term-courses', NULL, NULL, NULL, NULL, NULL, '2023-04-29 20:04:21', '2023-04-29 20:04:21');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `featured_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcategory` int NOT NULL,
  `btn_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `btn_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `metatitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadescription` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `metakeyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` bigint UNSIGNED NOT NULL,
  `position` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `designation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qualification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keyword` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` (`id`, `position`, `name`, `slug`, `department`, `designation`, `qualification`, `description`, `image`, `meta_title`, `meta_description`, `meta_keyword`, `created_at`, `updated_at`) VALUES
(1, 1, 'Mrs. Ponnamma R Singh', 'mrs-ponnamma-r-singh', 'Mental Health Nursing', 'Professor cum Principal', 'M.Sc.(N) 1992, RN.41', NULL, '1684131042.Ponnama.JPG', NULL, NULL, NULL, '2023-03-14 12:18:43', '2023-09-24 21:19:43'),
(4, 2, 'Ms. Amandeep Kaur', 'ms-amandeep-kaur', 'Medical Surgical Nursing', 'Professor', 'M.Sc. (Nursing)', NULL, '1684131271.Aman.JPG', NULL, NULL, NULL, '2023-04-29 18:03:08', '2023-09-24 21:20:06'),
(5, 3, 'Mrs. Pardeep Kaur Grewal', 'mrs-pardeep-kaur', 'Child Health Nursing', 'Associate Professor', 'M.Sc. (Nursing)', NULL, '1684130863.PARDEEP PIC.jpg', NULL, NULL, NULL, '2023-04-29 18:04:29', '2023-09-24 21:23:06'),
(6, 4, 'Mrs. Harpreet Kaur', 'mrs-harpreet-kaur', 'Medical Surgical Nursing', 'Associate Professor', 'M.Sc. (Nursing)', NULL, '1684130831.HARPREET PIC.JPG', NULL, NULL, NULL, '2023-04-29 18:05:08', '2023-09-24 21:23:29'),
(7, 5, 'Mrs. Monika Amandeep Hans', 'mrs-monika-amandeep-hans', 'Child Health Nursing', 'Assistant Professor', 'M.Sc. (Nursing)', NULL, '1684128460.Monika Hans.jpg', NULL, NULL, NULL, '2023-04-29 18:08:25', '2023-09-24 21:24:24'),
(8, 6, 'Mrs. Baljeet Kaur', 'mrs-baljeet-kaur', 'Community Health Nursing', 'Assistant Professor', 'M.Sc. (Nursing)', NULL, '1684128493.BALJEET PHOT (1).jpg', NULL, NULL, NULL, '2023-04-29 18:09:03', '2023-09-24 21:24:28'),
(31, 22, 'Ms. Amrita', 'ms-amrita', NULL, 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, '1717748867.Amrita.JPG', NULL, NULL, NULL, '2024-04-10 11:29:23', '2024-06-07 12:27:47'),
(10, 8, 'Ms. Anjali Bhan', 'ms-anjali-bhan', 'Obstetrics & Gynaecology Nursing', 'Nursing Tutor', 'M.Sc. (Nursing)', NULL, '1684130442.Anjali.JPG', NULL, NULL, NULL, '2023-04-29 18:12:45', '2023-09-24 21:24:35'),
(11, 8, 'Mr. Abhishek Masih', 'mr-abhishek', 'Community Health Nursing', 'Nursing Tutor', 'M.Sc. (Nursing)', NULL, '1684130474.Abhishek.jpg', NULL, NULL, NULL, '2023-04-29 18:14:13', '2024-04-10 11:18:26'),
(12, 11, 'Mrs. Archana Azad', 'mrs-archana-azad', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, '1684130627.ARCHANA PIC.jpg', NULL, NULL, NULL, '2023-04-29 18:15:44', '2024-05-21 09:16:20'),
(13, 12, 'Mrs. Jaswinder Kaur', 'mrs-jaswinder-kaur', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, '1684130686.JASWINDER PIC.jpg', NULL, NULL, NULL, '2023-04-29 18:16:14', '2024-04-10 11:23:18'),
(14, 13, 'Mrs. Susy', 'mrs-susy', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, '1684130729.SUSY.jpg', NULL, NULL, NULL, '2023-04-29 18:17:14', '2024-04-10 11:24:37'),
(15, 14, 'Mrs. Monica', 'mrs-monica', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, '1684130760.MONIKA PIC.JPG', NULL, NULL, NULL, '2023-04-29 18:18:09', '2024-04-10 11:25:22'),
(18, 15, 'Mrs. Gurpreet Kaur', 'mrs-gurpreet-kaur', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, '1684128309.Gurpreet Registration - Copy.JPG', NULL, NULL, NULL, '2023-04-29 18:42:45', '2023-09-24 21:25:39'),
(19, 16, 'Mrs. Harpreet Kaur', 'mrs-harpreet-kaur', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing) Post Basic', NULL, '1684128283.Harpreet Grewal.jpg', NULL, NULL, NULL, '2023-04-29 18:43:32', '2023-09-24 21:25:42'),
(21, 18, 'Mrs. Jatinder Kaur', 'mrs-jatinder-kaur', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing) Post Basic', NULL, '1684131449.Jaspreet.JPG', NULL, NULL, NULL, '2023-04-29 18:46:46', '2023-09-24 21:25:49'),
(23, 19, 'Ms. Prabhjot Kaur', 'ms-prabhjot-kaur', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing) Post Basic', NULL, '1684128128.Pic prabhjot kaur.JPG', NULL, NULL, NULL, '2023-04-29 18:47:57', '2023-09-24 21:25:57'),
(25, 20, 'Ms. Aradhana', 'ms-aradhana', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, '1684128041.Aradhna.jpg', NULL, NULL, NULL, '2023-04-29 18:49:48', '2023-09-24 21:26:05'),
(26, 21, 'Mrs. Jyoti', 'mrs-jyoti', 'Nursing', 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, '1684127850.Jyoti.jpg', NULL, NULL, NULL, '2023-05-12 19:13:54', '2023-09-24 21:26:10'),
(27, 29, 'Mrs. Pavleen Kaur', 'mrs-pavleen-kaur', 'English', 'Lecturer - English', 'M.A. English', NULL, '1717746079.pavleen.jpg', NULL, NULL, NULL, '2023-05-15 10:22:05', '2024-06-07 12:30:33'),
(30, 10, 'Mr. Jasmeet Singh', 'mr-jasmeet-singh', NULL, 'Nursing Tutor', 'M.Sc. Nursing', NULL, '1717748780.Jasmeet.jpg', NULL, NULL, NULL, '2024-04-10 11:20:44', '2024-06-07 12:26:20'),
(29, 9, 'Mrs. Aanchal Thakur', 'mrs-aanchal-thakur', NULL, 'Nursing Tutor', 'M.Sc. Nursing', NULL, '1717748821.Anchal.jpg', NULL, NULL, NULL, '2024-04-10 11:14:11', '2024-06-07 12:27:01'),
(38, 28, 'Mrs. Richa', 'mrs-richa', 'Nursing', 'Nursing Tutor', 'B.Sc. Nursing', NULL, '1717743573.Richa.jpg', NULL, NULL, NULL, '2024-05-21 09:18:43', '2024-06-07 10:59:33'),
(33, 24, 'Ms. Shweta', 'ms-shweta', NULL, 'Nursing Tutor', 'B.Sc. (Nursing)', NULL, NULL, NULL, NULL, NULL, '2024-04-10 11:30:47', '2024-04-10 11:30:47'),
(34, 25, 'Ms. Rohini', 'ms-rohini', NULL, 'Nursing Tutor', 'B.Sc. Nursing', NULL, '1717748921.Rohini.jpg', NULL, NULL, NULL, '2024-04-10 11:31:26', '2024-06-07 12:28:41'),
(35, 26, 'Ms. Jaspreet Kaur Mutti', 'ms-jaspreet-kaur-mutti', NULL, 'Nursing Tutor', 'B.Sc. Nursing', NULL, '1717748507.Jaspreet.jpg', NULL, NULL, NULL, '2024-04-10 11:32:05', '2024-06-07 12:21:47'),
(36, 27, 'Mrs. Nancy', 'mrs-nancy', NULL, 'Nursing Tutor', 'B.Sc. Nursing', NULL, '1717743407.NANCY.jpg', NULL, NULL, NULL, '2024-04-10 11:32:47', '2024-06-07 10:56:47'),
(37, 11, 'Mrs. Pooja Sinha', 'mrs-pooja-sinha', NULL, 'Nursing Tutor', 'M.Sc. NPCC', NULL, '1717746343.Pooja Sinha.jpg', NULL, NULL, NULL, '2024-04-10 11:34:09', '2024-06-07 11:45:43');

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

--
-- Table structure for table `topbars`
--

CREATE TABLE `topbars` (
  `id` int NOT NULL,
  `message` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `updated_at` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `topbars`
--

INSERT INTO `topbars` (`id`, `message`, `created_at`, `updated_at`) VALUES
(1, 'ADMISSIONS OPEN FOR G.N.M. , B.Sc. NURSING AND POST BASIC B.Sc NURSING. It is duly recognized by Punjab Nurses Registration Council, Mohali, Baba Farid University of Health Sciences, Faridkot and Indian Nursing Council, New Delhi.', '2022-07-07 11:09:52', '2023-04-06 18:11:45');

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

--
-- Table structure for table `vacancies`
--

CREATE TABLE `vacancies` (
  `id` bigint UNSIGNED NOT NULL,
  `album_id` int DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `vacancies`
--

INSERT INTO `vacancies` (`id`, `album_id`, `title`, `image`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, '16789028361344821033641206347ec43.jpeg', '2023-03-15 12:23:56', '2023-03-15 12:23:56'),
(7, 2, NULL, '167921622210542149366416ce5e352a6.jpeg', '2023-03-19 03:27:02', '2023-03-19 03:27:02');

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

--
-- Table structure for table `video_categories`
--

CREATE TABLE `video_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `section` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `video_categories`
--

INSERT INTO `video_categories` (`id`, `section`, `name`, `slug`, `image`, `alt`, `meta_title`, `meta_description`, `meta_keyword`, `created_at`, `updated_at`) VALUES
(2, 2, 'Music Videos', 'music-videos', '1660283572.wecome-banner.jpg', NULL, NULL, NULL, NULL, '2022-08-10 00:48:26', '2022-09-17 04:09:35'),
(4, 1, 'Movies', 'movies', '1663395724.fiber-optics.jpg', 'ss', 'meta', 'sdff', 'meta keyword', '2022-09-17 00:52:04', '2022-09-26 02:26:49'),
(5, 3, 'Shows', 'shows', '1663395736.low-voltage.jpg', NULL, NULL, NULL, NULL, '2022-09-17 00:52:16', '2022-09-17 04:00:05'),
(6, 1, 'Behind the Scenes', 'behind-the-scenes', '1672728882.Bina Band Chal England.jpg', 'Bina Band Chal England', NULL, NULL, NULL, '2023-01-03 12:53:46', '2023-01-03 12:54:42'),
(7, 3, 'Reels', 'reels', '1672729449.bale o chalaak sajna.jpg', 'Reels', NULL, NULL, NULL, '2023-01-03 13:04:09', '2023-01-03 13:04:09');

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

--
-- Table structure for table `youtube_videos`
--

CREATE TABLE `youtube_videos` (
  `id` bigint UNSIGNED NOT NULL,
  `category_id` int DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keyword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `youtube_videos`
--

INSERT INTO `youtube_videos` (`id`, `category_id`, `title`, `description`, `slug`, `url`, `meta_title`, `meta_description`, `meta_keyword`, `created_at`, `updated_at`) VALUES
(4, NULL, 'Our Campus', NULL, NULL, 'https://www.youtube.com/watch?v=Jw22BwUECuM', NULL, NULL, NULL, '2023-05-14 17:06:17', '2023-05-14 17:06:17'),
(5, NULL, 'International Nurses Day 2023', NULL, NULL, 'https://www.youtube.com/watch?v=0I-c9Mg87PY', NULL, NULL, NULL, '2023-05-14 17:07:20', '2023-05-14 17:07:20');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `albums`
--
ALTER TABLE `albums`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `discographies`
--
ALTER TABLE `discographies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

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

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staff`
--
ALTER TABLE `staff`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `topbars`
--
ALTER TABLE `topbars`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `vacancies`
--
ALTER TABLE `vacancies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `video_categories`
--
ALTER TABLE `video_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `youtube_videos`
--
ALTER TABLE `youtube_videos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

