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

START TRANSACTION;



--
-- Database: `grivaservicessss`
--

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

--
-- Table structure for table `assignments`
--

CREATE TABLE `assignments` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `contact_number` varchar(20) DEFAULT NULL,
  `assignment_title` varchar(200) DEFAULT NULL,
  `words` varchar(256) DEFAULT NULL,
  `deadline` timestamp NULL DEFAULT NULL,
  `time_zone` time DEFAULT NULL,
  `file` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assignments`
--

INSERT INTO `assignments` (`id`, `name`, `email`, `contact_number`, `assignment_title`, `words`, `deadline`, `time_zone`, `file`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
(15, 'sonikaq', 'sona8d82187f0295@gmail.com', '938247293847', 'test assignment', 'just for test..', '2024-03-28 18:30:00', '22:58:00', '/storage/assignments/1711645978_CS2FinalAnswerKey.pdf', 'this is test assignment...', '2024-03-28 11:42:58', '2024-03-29 13:24:16', NULL);

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `status` enum('0','1','','') NOT NULL DEFAULT '1',
  `type` enum('course','assignment','','') DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `status`, `type`, `created_at`, `updated_at`, `deleted`) VALUES
(9, 'Business and Management', '1', 'course', '2024-03-28 10:02:31', '2024-03-28 16:00:37', NULL),
(10, 'Engineering', '1', 'course', '2024-03-28 10:04:02', '2024-03-28 16:00:37', NULL),
(11, 'Computer Science and IT', '1', 'course', '2024-03-28 10:07:06', '2024-03-28 16:00:37', NULL),
(12, 'Healthcare and Medicine', '1', 'course', '2024-03-28 10:08:00', '2024-03-28 16:00:37', NULL),
(13, 'Social Sciences', '1', 'course', '2024-03-28 10:08:54', '2024-03-28 16:00:37', NULL),
(14, 'Arts and Humanities', '1', 'course', '2024-03-28 10:09:41', '2024-03-28 16:00:37', NULL),
(15, 'Science', '1', 'course', '2024-03-28 10:10:34', '2024-03-28 16:00:37', NULL),
(16, 'Law', '1', 'course', '2024-03-28 10:11:29', '2024-03-28 16:00:37', NULL),
(17, 'Education', '1', 'course', '2024-03-28 10:12:15', '2024-03-28 16:00:37', NULL),
(18, 'Hospitality and Tourism', '1', 'course', '2024-03-28 10:14:26', '2024-03-28 16:00:37', NULL),
(19, 'Creative Arts and Design', '1', 'course', '2024-03-28 10:14:55', '2024-03-28 16:00:37', NULL),
(20, 'Language', '1', 'course', '2024-03-28 10:15:47', '2024-03-28 16:00:37', NULL),
(21, 'Business and Management', '1', 'assignment', '2024-03-28 10:17:41', '2024-03-28 16:00:37', NULL),
(22, 'Engineering', '1', 'assignment', '2024-03-28 10:19:00', '2024-03-28 16:00:37', NULL),
(23, 'Computer Science and IT', '1', 'assignment', '2024-03-28 10:19:57', '2024-03-28 16:00:37', NULL),
(24, 'Healthcare and Medicine', '1', 'assignment', '2024-03-28 10:21:01', '2024-03-28 16:00:37', NULL),
(25, 'Social Sciences', '1', 'assignment', '2024-03-28 10:21:59', '2024-03-28 16:00:37', NULL),
(26, 'Arts and Humanities', '1', 'assignment', '2024-03-28 10:22:52', '2024-03-28 16:00:37', NULL),
(27, 'Science', '1', 'assignment', '2024-03-28 10:23:50', '2024-03-28 16:00:37', NULL),
(28, 'Law', '1', 'assignment', '2024-03-28 10:24:35', '2024-03-28 16:00:37', NULL),
(29, 'Education', '1', 'assignment', '2024-03-28 10:25:53', '2024-03-28 16:00:37', NULL),
(30, 'Hospitality and Tourism', '1', 'assignment', '2024-03-28 10:27:22', '2024-03-28 16:00:37', NULL),
(31, 'Creative Arts and Design', '1', 'assignment', '2024-03-28 10:29:17', '2024-03-28 10:29:17', NULL);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `contact_number` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `contact_number`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
(19, 'test user', 'sonikakurmi48@gmail.com', '938247293847', 'dasdasd', '2024-03-27 02:16:36', '2024-03-27 02:16:36', NULL),
(23, 'test user 3', 'sona@gmail.com', '938247293847', 'ADSFASBCVBCVB', '2024-03-27 02:32:04', '2024-03-27 02:32:04', NULL);

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

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

CREATE TABLE `courses` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `duration` varchar(200) DEFAULT NULL,
  `level` varchar(200) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `type` enum('course','assignment','','') DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `subcategory_id` int(11) DEFAULT NULL,
  `status` enum('0','1','','') NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `courses` (`id`, `name`, `image`, `description`, `duration`, `level`, `price`, `slug`, `type`, `category_id`, `subcategory_id`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'math', '/storage/course/1711533638_news1.jpg', '<p>Similarly, one of the two main schools of thought in&nbsp;<a href=\"https://en.wikipedia.org/wiki/Pythagoreanism\">Pythagoreanism</a>&nbsp;was known as the&nbsp;<em>mathēmatikoi</em>&nbsp;(&mu;&alpha;&theta;&eta;&mu;&alpha;&tau;&iota;&kappa;&omicron;ί)&mdash;which at the time meant &quot;learners&quot; rather than &quot;mathematicians&quot; in the modern sense. The Pythagoreans were likely the first to constrain the use of the word to just the study of&nbsp;<a href=\"https://en.wikipedia.org/wiki/Arithmetic\">arithmetic</a>&nbsp;and geometry. By the time of&nbsp;<a href=\"https://en.wikipedia.org/wiki/Aristotle\">Aristotle</a>&nbsp;(384&ndash;322&nbsp;BC) this meaning was fully established.<a href=\"https://en.wikipedia.org/wiki/Mathematics#cite_note-17\">[15]</a></p>\r\n\r\n<p>In Latin, and in English until around 1700, the term&nbsp;<em>mathematics</em>&nbsp;more commonly meant &quot;<a href=\"https://en.wikipedia.org/wiki/Astrology\">astrology</a>&quot; (or sometimes &quot;<a href=\"https://en.wikipedia.org/wiki/Astronomy\">astronomy</a>&quot;) rather than &quot;mathematics&quot;; the meaning gradually changed to its present one from about 1500 to 1800. This change has resulted in several mistranslations: For example,&nbsp;<a href=\"https://en.wikipedia.org/wiki/Saint_Augustine\">Saint Augustine</a>&#39;s warning that Christians should beware of&nbsp;<em>mathematici</em>, meaning &quot;astrologers&quot;, is sometimes mistranslated as a condemnation of mathematicians.<a href=\"https://en.wikipedia.org/wiki/Mathematics#cite_note-Boas-18\">[16]</a></p>', '34', 'ooo', 453.00, 'wer', NULL, 9, 9, '1', '2024-03-23 07:29:38', '2024-04-10 11:13:53', '2024-03-28 04:48:12'),
(2, 'English Literature', '/storage/course/1711533655_Happy-Client.jpeg', '<p>The English language spread throughout the world with the development of the&nbsp;<a href=\"https://en.wikipedia.org/wiki/British_Empire\">British Empire</a>&nbsp;between the late 16th and early 18th centuries. At its height, it was the&nbsp;<a href=\"https://en.wikipedia.org/wiki/List_of_largest_empires\">largest empire in history</a>.<a href=\"https://en.wikipedia.org/wiki/English_literature#cite_note-FOOTNOTEFerguson2004b-10\">[10]</a>&nbsp;By 1913, the British Empire held sway over 412 million people,&nbsp;23% of the world population at the time,<a href=\"https://en.wikipedia.org/wiki/English_literature#cite_note-11\">[11]</a>&nbsp;During the nineteenth and twentieth centuries these colonies and the&nbsp;<a href=\"https://en.wikipedia.org/wiki/American_literature\">USA</a>&nbsp;started to produce their own significant literary traditions in English. Cumulatively, over the period of 1907 to the present, numerous writers from&nbsp;<a href=\"https://en.wikipedia.org/wiki/Great_Britain\">Great Britain</a>,&nbsp;<a href=\"https://en.wikipedia.org/wiki/Irish_literature\">both the Republic of Ireland and Northern Ireland</a>, the US, and former British colonies have received the&nbsp;<a href=\"https://en.wikipedia.org/wiki/Nobel_Prize_in_literature\">Nobel Prize for works in the English language</a>, more than in any language.</p>', '12', 'mid', 12000.00, 'dfg', NULL, 9, 9, '1', '2024-03-23 07:34:01', '2024-04-10 11:13:53', NULL),
(5, 'HIndi', '/storage/course/1711211158_reseize3.jpg', '<p>just testing purpose...</p>', '45day', 'senior', 24.99, 'ghjhgj', NULL, 9, 9, '1', '2024-03-23 10:55:25', '2024-04-10 11:13:53', '2024-03-23 10:56:11'),
(8, 'science', '/storage/course/1711214352_news2.jpg', '<p>just testing</p>', '6', 'mid', 25.32, 'science', NULL, 9, 9, '1', '2024-03-23 11:49:12', '2024-04-10 11:13:53', NULL),
(9, 'English Literature', '/storage/course/1711530486_English-Literature.jpeg', '<p>Elevate your literary prowess with our English Literature assignments.</p>\r\n\r\n<p>&nbsp; From Shakespearean Literature to Modernist Fiction</p>', '12', 'mid', 457.99, 'english-literature', NULL, 9, 9, '1', '2024-03-27 03:38:06', '2024-04-10 11:13:53', NULL),
(10, 'Psychology', '/storage/course/1711530579_Psychology.jpeg', '<p>Embark on a journey through the human mind with our Psychology</p>\r\n\r\n<p>&nbsp;assignments. Explore topics ranging from Introduction to Psychology to</p>', '423', 'senior', 54.02, 'psychology', NULL, 9, 9, '1', '2024-03-27 03:39:39', '2024-04-10 11:13:53', NULL),
(11, 'fourth course', '/storage/course/1711552054_12th-marksheet.jpg', '<p>testing doing</p>', NULL, NULL, NULL, 'fourth-course', NULL, 9, 9, '1', '2024-03-27 09:37:34', '2024-04-10 11:13:53', NULL),
(12, 'mmmmmmmm', '/storage/course/1711615087_caste-certificate.jpg', '<p>working.....working....</p>', NULL, NULL, NULL, 'frist-ttest', 'course', 9, 9, '0', '2024-03-28 03:03:24', '2024-04-10 11:13:53', '2024-03-28 03:16:06'),
(13, 'course test', '/storage/course/1711614998_10th-marksheet.jpg', '<p>just testing</p>', NULL, NULL, NULL, 'course-test', 'course', 9, 9, '1', '2024-03-28 03:06:38', '2024-04-10 11:13:53', NULL),
(14, 'erterterttttttttttt', '/storage/course/1711615235_domicile.jpeg', '<p>ewrwer</p>', NULL, NULL, NULL, 'ertertert', 'course', 9, 9, '1', '2024-03-28 03:10:35', '2024-04-10 11:13:53', NULL),
(15, 'iuyiuyu', '/storage/course/1711615352_resie2.jpg', '<p>ewrewr</p>', NULL, NULL, NULL, 'iuyiuyu', 'course', 9, 9, '1', '2024-03-28 03:12:32', '2024-04-10 11:13:53', NULL),
(16, 'fffffffffff', '/storage/course/1711615479_aadhar-front.jpeg', '<p>werrwer</p>', NULL, NULL, NULL, 'nbnvbn', 'assignment', 9, 9, '1', '2024-03-28 03:14:39', '2024-04-10 11:13:53', '2024-03-28 03:16:14'),
(17, 'Assignment', '/storage/course/1711616942_WhatsApp Image 2023-09-08 at 18.19.57.jpeg', '<p>n publishing and graphic design, Lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document or a typeface without relying on meaningful content. Lorem ipsum may be used as a placeholder before the final copy is available</p>', NULL, NULL, NULL, 'assignment', 'assignment', 21, 66, '1', '2024-03-28 03:39:02', '2024-04-10 06:22:56', NULL),
(18, 'ttttttttt', '/storage/course/1712743572_IMG20240229141406.jpg', '<p>qwerqwerqwer</p>', NULL, NULL, NULL, 'ttttttttt', 'course', 12, 26, '1', '2024-04-10 04:36:12', '2024-04-10 04:36:12', NULL),
(19, 'asdfasdfsdaf', '/storage/course/1712743896_IMG20240229141406.jpg', '<p>wetwetrwet</p>', NULL, NULL, NULL, 'asdfasdfsdaf', 'assignment', 22, 71, '1', '2024-04-10 04:41:36', '2024-04-10 06:22:34', NULL),
(20, 'retwert', '/storage/course/1712745347_IMG20240229141406.jpg', '<p>retertert</p>', NULL, NULL, NULL, 'retwert', 'course', 17, 51, '1', '2024-04-10 05:05:47', '2024-04-10 05:05:47', NULL),
(21, 'test user 3', '/storage/course/1712745503_IMG20240229141406.jpg', '<p>werwer</p>', NULL, NULL, NULL, 'test-user-3', 'assignment', 22, 71, '1', '2024-04-10 05:08:23', '2024-04-10 05:46:39', NULL),
(22, 'ttttgdg', '/storage/course/1712747824_IMG20240229141406.jpg', '<p>werwer</p>', NULL, NULL, NULL, 'ttttgdg', 'assignment', 26, 91, '1', '2024-04-10 05:47:05', '2024-04-10 05:47:05', NULL),
(23, 'bbbbbbbb', '/storage/course/1712747915_IMG20240229141406.jpg', '<p>werwer</p>', NULL, NULL, NULL, 'bbbbbbbb', 'course', 15, 42, '1', '2024-04-10 05:48:35', '2024-04-10 05:51:46', NULL),
(24, 'rwerwerer', '/storage/course/1712749834_SAGE Toll free Bill 2023.jpg', '<p>ertert dgdfg</p>', NULL, NULL, NULL, 'rwerwerer', 'course', 15, 41, '1', '2024-04-10 06:20:34', '2024-04-10 06:20:34', NULL);

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

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

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

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2024_02_01_061433_create_project_types_table', 1),
(7, '2024_02_01_061550_create_positions_table', 1),
(8, '2024_02_01_061600_create_technologies_table', 1),
(9, '2024_02_01_061616_create_coding_languages_table', 1),
(10, '2024_02_01_084456_create_developers_table', 1),
(11, '2024_02_01_085140_create_developer_has_coding_languages_table', 1),
(12, '2024_02_02_073738_create_clients_table', 1),
(13, '2024_02_02_083811_create_countries_table', 1),
(14, '2024_02_02_100411_create_invoices_table', 1),
(15, '2024_02_02_100422_create_payments_table', 1),
(16, '2024_02_02_100434_create_agreements_table', 1),
(17, '2024_02_02_103406_create_projects_table', 1),
(18, '2024_02_03_071950_create_project_has_coding_languages_table', 1),
(19, '2024_02_03_072004_create_project_has_developers_table', 1);

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

--
-- Table structure for table `subcategories`
--

CREATE TABLE `subcategories` (
  `id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `status` enum('0','1','','') NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subcategories`
--

INSERT INTO `subcategories` (`id`, `category_id`, `name`, `status`, `created_at`, `updated_at`, `deleted`) VALUES
(8, 9, 'Bachelor of Business Administration (BBA)', '1', '2024-03-28 10:02:47', '2024-03-28 10:02:47', NULL),
(9, 9, 'Bachelor of Management Studies (BMS)', '1', '2024-03-28 10:02:54', '2024-03-28 10:02:54', NULL),
(10, 9, 'Bachelor of Commerce (BCom)', '1', '2024-03-28 10:03:00', '2024-03-28 10:03:00', NULL),
(11, 9, 'Master of Business Administration (MBA)', '1', '2024-03-28 10:03:05', '2024-03-28 10:03:05', NULL),
(12, 9, 'Master of Management (MM)', '1', '2024-03-28 10:03:10', '2024-03-28 10:03:10', NULL),
(13, 10, 'Bachelor of Engineering (BEng)', '1', '2024-03-28 10:04:51', '2024-03-28 10:04:51', NULL),
(14, 10, 'Bachelor of Science in Engineering (BSc Eng)', '1', '2024-03-28 10:04:58', '2024-03-28 10:04:58', NULL),
(15, 10, 'Master of Engineering (MEng)', '1', '2024-03-28 10:05:04', '2024-03-28 10:05:04', NULL),
(16, 10, 'Master of Science in Engineering (MSc Eng)', '1', '2024-03-28 10:05:57', '2024-03-28 10:05:57', NULL),
(17, 10, 'Doctor of Philosophy in Engineering (Ph.D. Eng)', '1', '2024-03-28 10:06:04', '2024-03-28 10:06:04', NULL),
(18, 11, 'Bachelor of Science in Computer Science (BSc CS)', '1', '2024-03-28 10:07:18', '2024-03-28 10:07:18', NULL),
(19, 11, 'Bachelor of Technology in Information Technology (BTech IT)', '1', '2024-03-28 10:07:24', '2024-03-28 10:07:24', NULL),
(20, 11, 'Master of Science in Computer Science (MSc CS)', '1', '2024-03-28 10:07:32', '2024-03-28 10:07:32', NULL),
(21, 11, 'Master of Information Technology (MIT)', '1', '2024-03-28 10:07:40', '2024-03-28 10:07:40', NULL),
(22, 11, 'Doctor of Philosophy in Computer Science (Ph.D. CS)', '1', '2024-03-28 10:07:47', '2024-03-28 10:07:47', NULL),
(23, 12, 'Bachelor of Medicine, Bachelor of Surgery (MBBS)', '1', '2024-03-28 10:08:17', '2024-03-28 10:08:17', NULL),
(24, 12, 'Bachelor of Science in Nursing (BSN)', '1', '2024-03-28 10:08:24', '2024-03-28 10:08:24', NULL),
(25, 12, 'Bachelor of Pharmacy (BPharm)', '1', '2024-03-28 10:08:30', '2024-03-28 10:08:30', NULL),
(26, 12, 'Doctor of Medicine (MD)', '1', '2024-03-28 10:08:37', '2024-03-28 10:08:37', NULL),
(27, 12, 'Doctor of Pharmacy (PharmD)', '1', '2024-03-28 10:08:44', '2024-03-28 10:08:44', NULL),
(28, 13, 'Bachelor of Arts in Psychology (BA Psych)', '1', '2024-03-28 10:09:04', '2024-03-28 10:09:04', NULL),
(29, 13, 'Bachelor of Arts in Sociology (BA Soc)', '1', '2024-03-28 10:09:11', '2024-03-28 10:09:11', NULL),
(30, 13, 'Bachelor of Economics (BEcon)', '1', '2024-03-28 10:09:18', '2024-03-28 10:09:18', NULL),
(31, 13, 'Master of Arts in Political Science (MA Pol Sci)', '1', '2024-03-28 10:09:26', '2024-03-28 10:09:26', NULL),
(32, 13, 'Doctor of Philosophy in Sociology (Ph.D. Soc)', '1', '2024-03-28 10:09:32', '2024-03-28 10:09:32', NULL),
(33, 14, 'Bachelor of Arts in English Literature (BA Eng Lit)', '1', '2024-03-28 10:09:50', '2024-03-28 10:09:50', NULL),
(34, 14, 'Bachelor of Arts in History (BA History)', '1', '2024-03-28 10:10:00', '2024-03-28 10:10:00', NULL),
(35, 14, 'Bachelor of Philosophy (BPhil)', '1', '2024-03-28 10:10:08', '2024-03-28 10:10:08', NULL),
(36, 14, 'Master of Fine Arts (MFA)', '1', '2024-03-28 10:10:17', '2024-03-28 10:10:17', NULL),
(37, 14, 'Doctor of Philosophy in Philosophy (Ph.D. Phil)', '1', '2024-03-28 10:10:25', '2024-03-28 10:10:25', NULL),
(38, 15, 'Bachelor of Science (BSc)', '1', '2024-03-28 10:10:45', '2024-03-28 10:10:45', NULL),
(39, 15, 'Bachelor of Science in Physics (BSc Physics)', '1', '2024-03-28 10:10:52', '2024-03-28 10:10:52', NULL),
(40, 15, 'Bachelor of Science in Chemistry (BSc Chemistry)', '1', '2024-03-28 10:10:58', '2024-03-28 10:10:58', NULL),
(41, 15, 'Bachelor of Science in Biology (BSc Biology)', '1', '2024-03-28 10:11:07', '2024-03-28 10:11:07', NULL),
(42, 15, 'Master of Science (MSc)', '1', '2024-03-28 10:11:14', '2024-03-28 10:11:14', NULL),
(43, 15, 'Doctor of Philosophy in Physics (Ph.D. Physics)', '1', '2024-03-28 10:11:21', '2024-03-28 10:11:21', NULL),
(44, 16, 'Bachelor of Laws (LLB)', '1', '2024-03-28 10:11:41', '2024-03-28 10:11:41', NULL),
(45, 16, 'Master of Laws (LLM)', '1', '2024-03-28 10:11:48', '2024-03-28 10:11:48', NULL),
(46, 16, 'Doctor of Juridical Science (SJD)', '1', '2024-03-28 10:11:56', '2024-03-28 10:11:56', NULL),
(47, 16, 'Juris Doctor (JD)', '1', '2024-03-28 10:12:04', '2024-03-28 10:12:04', NULL),
(48, 17, 'Bachelor of Education (BEd)', '1', '2024-03-28 10:12:45', '2024-03-28 10:12:45', NULL),
(49, 17, 'Master of Education (MEd)', '1', '2024-03-28 10:13:59', '2024-03-28 10:13:59', NULL),
(50, 17, 'Doctor of Education (EdD)', '1', '2024-03-28 10:14:04', '2024-03-28 10:14:04', NULL),
(51, 17, 'Doctor of Philosophy in Education (Ph.D. Ed)', '1', '2024-03-28 10:14:09', '2024-03-28 10:14:09', NULL),
(52, 18, 'Bachelor of Science in Hospitality Management (BSHM)', '1', '2024-03-28 10:14:35', '2024-03-28 10:14:35', NULL),
(53, 18, 'Bachelor of Science in Tourism Management (BSTM)', '1', '2024-03-28 10:14:40', '2024-03-28 10:14:40', NULL),
(54, 18, 'Master of Science in Hospitality and Tourism Management (MSHTM)', '1', '2024-03-28 10:14:47', '2024-03-28 10:14:47', NULL),
(55, 19, 'Bachelor of Fine Arts (BFA)', '1', '2024-03-28 10:15:15', '2024-03-28 10:15:15', NULL),
(56, 19, 'Bachelor of Arts in Graphic Design (BA GD)', '1', '2024-03-28 10:15:22', '2024-03-28 10:15:22', NULL),
(57, 19, 'Bachelor of Arts in Fashion Design (BA FD)', '1', '2024-03-28 10:15:27', '2024-03-28 10:15:27', NULL),
(58, 19, 'Master of Fine Arts (MFA)', '1', '2024-03-28 10:15:32', '2024-03-28 10:15:32', NULL),
(59, 20, 'Bachelor of Arts in Linguistics (BA Linguistics)', '1', '2024-03-28 10:15:59', '2024-03-28 10:15:59', NULL),
(60, 20, 'Bachelor of Arts in Modern Languages (BA Modern Languages)', '1', '2024-03-28 10:16:06', '2024-03-28 10:16:06', NULL),
(61, 20, 'Master of Arts in Translation and Interpretation (MATI)', '1', '2024-03-28 10:16:10', '2024-03-28 10:16:10', NULL),
(62, 20, 'Doctor of Philosophy in Linguistics (Ph.D. Linguistics)', '1', '2024-03-28 10:16:18', '2024-03-28 10:16:30', NULL),
(63, 21, 'Business Administration', '1', '2024-03-28 10:18:17', '2024-03-28 10:18:17', NULL),
(64, 21, 'Marketing', '1', '2024-03-28 10:18:24', '2024-03-28 10:18:24', NULL),
(65, 21, 'Human Resource Management', '1', '2024-03-28 10:18:30', '2024-03-28 10:18:30', NULL),
(66, 21, 'Finance and Accounting', '1', '2024-03-28 10:18:39', '2024-03-28 10:18:39', NULL),
(67, 21, 'Entrepreneurship', '1', '2024-03-28 10:18:46', '2024-03-28 10:18:46', NULL),
(68, 22, 'Mechanical Engineering', '1', '2024-03-28 10:19:17', '2024-03-28 10:19:17', NULL),
(69, 22, 'Electrical Engineering', '1', '2024-03-28 10:19:24', '2024-03-28 10:19:24', NULL),
(70, 22, 'Civil Engineering', '1', '2024-03-28 10:19:31', '2024-03-28 10:19:31', NULL),
(71, 22, 'Aerospace Engineering', '1', '2024-03-28 10:19:37', '2024-03-28 10:19:37', NULL),
(72, 22, 'Chemical Engineering', '1', '2024-03-28 10:19:44', '2024-03-28 10:19:44', NULL),
(73, 23, 'Computer Science', '1', '2024-03-28 10:20:14', '2024-03-28 10:20:14', NULL),
(74, 23, 'Information Technology', '1', '2024-03-28 10:20:23', '2024-03-28 10:20:23', NULL),
(75, 23, 'Software Engineering', '1', '2024-03-28 10:20:30', '2024-03-28 10:20:30', NULL),
(76, 23, 'Cybersecurity', '1', '2024-03-28 10:20:36', '2024-03-28 10:20:36', NULL),
(77, 23, 'Data Science and Analytics', '1', '2024-03-28 10:20:43', '2024-03-28 10:20:43', NULL),
(78, 24, 'Medicine (MBBS)', '1', '2024-03-28 10:21:20', '2024-03-28 10:21:20', NULL),
(79, 24, 'Nursing', '1', '2024-03-28 10:21:27', '2024-03-28 10:21:27', NULL),
(80, 24, 'Pharmacy', '1', '2024-03-28 10:21:34', '2024-03-28 10:21:34', NULL),
(81, 24, 'Dentistry', '1', '2024-03-28 10:21:40', '2024-03-28 10:21:40', NULL),
(82, 24, 'Biomedical Sciences', '1', '2024-03-28 10:21:47', '2024-03-28 10:21:47', NULL),
(83, 25, 'Psychology', '1', '2024-03-28 10:22:14', '2024-03-28 10:22:14', NULL),
(84, 25, 'Sociology', '1', '2024-03-28 10:22:20', '2024-03-28 10:22:20', NULL),
(85, 25, 'Anthropology', '1', '2024-03-28 10:22:26', '2024-03-28 10:22:26', NULL),
(86, 25, 'Economics', '1', '2024-03-28 10:22:35', '2024-03-28 10:22:35', NULL),
(87, 25, 'Political Science', '1', '2024-03-28 10:22:42', '2024-03-28 10:22:42', NULL),
(88, 26, 'English Literature', '1', '2024-03-28 10:23:12', '2024-03-28 10:23:12', NULL),
(89, 26, 'History', '1', '2024-03-28 10:23:28', '2024-03-28 10:23:28', NULL),
(90, 26, 'Philosophy', '1', '2024-03-28 10:23:32', '2024-03-28 10:23:32', NULL),
(91, 26, 'Fine Arts', '1', '2024-03-28 10:23:39', '2024-03-28 10:23:39', NULL),
(92, 26, 'Linguistics', '1', '2024-03-28 10:23:44', '2024-03-28 10:23:44', NULL),
(93, 27, 'Physics', '1', '2024-03-28 10:24:05', '2024-03-28 10:24:05', NULL),
(94, 27, 'Chemistry', '1', '2024-03-28 10:24:10', '2024-03-28 10:24:10', NULL),
(95, 27, 'Biology', '1', '2024-03-28 10:24:15', '2024-03-28 10:24:15', NULL),
(96, 27, 'Environmental Science', '1', '2024-03-28 10:24:21', '2024-03-28 10:24:21', NULL),
(97, 27, 'Mathematics', '1', '2024-03-28 10:24:26', '2024-03-28 10:24:26', NULL),
(98, 28, 'LLB (Bachelor of Laws)', '1', '2024-03-28 10:25:15', '2024-03-28 10:25:15', NULL),
(99, 28, 'LLM (Master of Laws)', '1', '2024-03-28 10:25:21', '2024-03-28 10:25:21', NULL),
(100, 28, 'Criminal Law', '1', '2024-03-28 10:25:27', '2024-03-28 10:25:27', NULL),
(101, 28, 'International Law', '1', '2024-03-28 10:25:34', '2024-03-28 10:25:34', NULL),
(102, 28, 'Corporate Law', '1', '2024-03-28 10:25:40', '2024-03-28 10:25:40', NULL),
(103, 29, 'Teaching (Primary/Secondary)', '1', '2024-03-28 10:26:09', '2024-03-28 10:26:09', NULL),
(104, 29, 'Education Studies', '1', '2024-03-28 10:26:15', '2024-03-28 10:26:15', NULL),
(105, 29, 'Special Education', '1', '2024-03-28 10:26:23', '2024-03-28 10:26:23', NULL),
(106, 29, 'Educational Psychology', '1', '2024-03-28 10:26:29', '2024-03-28 10:26:29', NULL),
(107, 29, 'Early Childhood Education', '1', '2024-03-28 10:26:35', '2024-03-28 10:26:35', NULL),
(108, 30, 'Hospitality Management\n', '1', '2024-03-28 10:26:44', '2024-03-28 15:58:37', NULL),
(109, 30, 'Tourism Management', '1', '2024-03-28 10:28:14', '2024-03-28 10:28:14', NULL),
(110, 30, 'Event Management', '1', '2024-03-28 10:28:49', '2024-03-28 10:28:49', NULL),
(111, 30, 'Culinary Arts', '1', '2024-03-28 10:28:57', '2024-03-28 10:28:57', NULL),
(112, 30, 'Hotel Administration', '1', '2024-03-28 10:29:04', '2024-03-28 10:29:04', NULL),
(113, 31, 'Graphic Design', '1', '2024-03-28 10:29:36', '2024-03-28 10:29:36', NULL),
(114, 31, 'Fashion Design', '1', '2024-03-28 10:29:43', '2024-03-28 10:29:43', NULL),
(115, 31, 'Interior Design', '1', '2024-03-28 10:29:50', '2024-03-28 10:29:50', NULL),
(116, 31, 'Animation', '1', '2024-03-28 10:29:57', '2024-03-28 10:29:57', NULL),
(117, 31, 'Film and Television Production', '1', '2024-03-28 10:30:05', '2024-03-28 10:30:05', NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subcategories`
--
ALTER TABLE `subcategories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subcategories_category_id` (`category_id`) USING BTREE;

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `subcategories`
--
ALTER TABLE `subcategories`
  ADD CONSTRAINT `fk_subcategories_category_id` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);
COMMIT;

