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

START TRANSACTION;



--
-- Database: `toschool`
--

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

--
-- Table structure for table `chat_lists`
--

CREATE TABLE `chat_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` bigint(20) UNSIGNED NOT NULL,
  `reciever_id` bigint(20) UNSIGNED NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `docs` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('docs','image','pdf','text') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
  `status` enum('read','unread') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread',
  `seen_status` enum('Sent','Delivered','Seen') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_by` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `communication_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext 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 `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2021_06_29_103845_create_category_table', 2),
(5, '2021_07_01_083215_create_subcategory_table', 3),
(6, '2021_10_17_175925_create_chat_lists_table', 4),
(7, '2016_06_01_000001_create_oauth_auth_codes_table', 5),
(8, '2016_06_01_000002_create_oauth_access_tokens_table', 5),
(9, '2016_06_01_000003_create_oauth_refresh_tokens_table', 5),
(10, '2016_06_01_000004_create_oauth_clients_table', 5),
(11, '2016_06_01_000005_create_oauth_personal_access_clients_table', 5),
(12, '2019_12_14_000001_create_personal_access_tokens_table', 6);

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_personal_access_clients`
--

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

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2023-03-14 07:11:38', '2023-03-14 07:11:38');

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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int(11) NOT NULL,
  `category_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_arabic_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`id`, `category_name`, `category_arabic_name`, `created_at`, `updated_at`) VALUES
(3, 'المرحلة الابتدائية / التعليم الابتدائي', NULL, '2021-09-18 07:21:00', '2021-10-25 14:14:02'),
(4, 'Middle School / Intermediate Education', ' ميددلي سكهوول / ينتيرميدياتي يدوكاتيون', '2021-09-18 07:23:50', '2021-10-25 15:33:58'),
(5, 'Secondary Stage / General Secondary', ' سيكونداري ستاغي / غينيرال سيكونداري', '2021-09-18 07:24:09', '2021-10-25 15:30:55'),
(6, 'Diploma', ' ديبلوما', '2021-09-18 07:25:46', '2021-10-25 15:34:22'),
(7, 'Bachelor\'s Degree / Undergraduate', NULL, '2021-09-18 07:25:46', '2021-10-25 11:44:11'),
(8, 'Master\'s Degree / Post Graduate', NULL, '2021-09-18 07:25:46', '2021-09-18 07:25:46'),
(9, 'Doctoral Degree', NULL, '2021-09-18 07:25:46', '2021-09-18 07:25:46'),
(10, 'A', NULL, '2021-10-25 15:07:42', '2021-10-25 15:07:42'),
(11, 'test waqar', ' تيست واكار', '2021-10-25 15:36:37', '2021-10-25 15:36:37');

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

--
-- Table structure for table `tbl_class`
--

CREATE TABLE `tbl_class` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `class` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_class`
--

INSERT INTO `tbl_class` (`id`, `category_id`, `class`, `created_at`, `updated_at`) VALUES
(13, 3, '1', '2021-09-18 07:45:08', '2021-09-18 07:45:08'),
(14, 3, '2', '2021-09-18 07:45:08', '2021-09-18 07:45:08'),
(15, 3, '3', '2021-09-18 07:45:08', '2021-09-18 07:45:08'),
(16, 3, '4', '2021-09-18 07:45:08', '2021-09-18 07:45:08'),
(17, 3, '5', '2021-09-18 07:45:08', '2021-09-18 07:45:08'),
(18, 3, '6', '2021-09-18 07:45:08', '2021-09-18 07:45:08'),
(19, 4, 'Middle First', '2021-09-18 14:50:25', '2021-09-18 14:50:25'),
(20, 4, 'Secondary Average', '2021-09-18 14:50:25', '2021-09-18 14:50:25'),
(21, 4, 'Middle Second', '2021-09-18 14:50:25', '2021-09-18 14:50:25'),
(22, 5, '1', '2021-09-18 14:51:04', '2021-09-18 14:51:04'),
(23, 5, '2', '2021-09-18 14:51:04', '2021-09-18 14:51:04'),
(24, 5, '3', '2021-09-18 14:51:04', '2021-09-18 14:51:04'),
(25, 6, '1', '2021-09-18 14:51:25', '2021-09-18 14:51:25'),
(26, 6, '2', '2021-09-18 14:51:25', '2021-09-18 14:51:25'),
(27, 6, '3', '2021-09-18 14:51:25', '2021-09-18 14:51:25'),
(28, 7, '1', '2021-09-18 14:51:48', '2021-09-18 14:51:48'),
(29, 7, '2', '2021-09-18 14:51:48', '2021-09-18 14:51:48'),
(30, 7, '3', '2021-09-18 14:51:48', '2021-09-18 14:51:48'),
(31, 7, '4', '2021-09-18 14:51:48', '2021-09-18 14:51:48'),
(32, 7, '5', '2021-09-18 14:51:48', '2021-09-18 14:51:48'),
(33, 7, '6', '2021-09-18 14:51:48', '2021-09-18 14:51:48'),
(34, 8, '1', '2021-09-18 14:52:13', '2021-09-18 14:52:13'),
(35, 8, '2', '2021-09-18 14:52:14', '2021-09-18 14:52:14'),
(36, 8, '3', '2021-09-18 14:52:14', '2021-09-18 14:52:14'),
(37, 9, '1', '2021-09-18 14:52:35', '2021-09-18 14:52:35'),
(38, 9, '2', '2021-09-18 14:52:35', '2021-09-18 14:52:35'),
(39, 9, '3', '2021-09-18 14:52:35', '2021-09-18 14:52:35');

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

--
-- Table structure for table `tbl_institute`
--

CREATE TABLE `tbl_institute` (
  `id` int(11) NOT NULL,
  `institute_id` int(11) NOT NULL,
  `telephone_number` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax_number` varchar(22) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_line_1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_line_2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_institute`
--

INSERT INTO `tbl_institute` (`id`, `institute_id`, `telephone_number`, `fax_number`, `address_line_1`, `address_line_2`, `city`, `state`, `zip`, `country`, `created_at`, `updated_at`) VALUES
(1, 118, '4536643664', '4356345634', 'LIne1', 'LIne2', 'city', 'state', '223344', 'Country', '2021-09-17 13:13:06', '2021-09-17 13:13:06'),
(2, 119, '+913456789', '4356345634', 'LIne1', 'fsdffsdfsd', 'LAHUL AND SPITI', 'Himachal Pradesh !', '123456', 'India', '2021-09-17 13:16:52', '2021-09-22 13:57:31'),
(3, 120, '+913456789', '4356345634', 'y7gy7', 'fsdffsdfsd', 'LAHUL AND SPITI', 'Himachal Pradesh', '123456', 'India', '2021-09-17 13:19:41', '2021-09-17 13:19:41'),
(5, 152, '3423423', '5345345', '34555', '45345', '35345', '3454534', '345', '34534', '2021-09-22 14:03:09', '2021-09-22 14:03:09'),
(6, 165, '12', '111', '1111', '1111', '346', '34564', '45364', '645', '2021-09-29 08:24:43', '2021-09-29 08:24:43'),
(7, 166, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-09-29 08:24:43', '2021-09-29 08:24:43'),
(8, 228, '96617418529', NULL, 'Al-Qassim Region', NULL, 'Al-Qassim Region', 'Tabuk.', '11564', 'Saudia Arabia', '2021-10-07 08:21:22', '2021-10-07 08:21:22'),
(9, 229, '96627412589', NULL, 'Al-Qassim Region', NULL, 'Al-Qassim Region', 'Bahah', '15941', 'Saudia Arabia', '2021-10-07 08:21:22', '2021-10-07 08:21:22'),
(10, 230, '96637406649', NULL, 'Asir Region', NULL, 'Asir Region', 'Jawf.', '14230', 'Saudia Arabia', '2021-10-07 08:21:23', '2021-10-07 08:21:23'),
(11, 231, '96647400709', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Madinah.', '20012', 'Saudia Arabia', '2021-10-07 08:21:23', '2021-10-07 08:21:23'),
(12, 232, '96657394769', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Makkah.', '11564', 'Saudia Arabia', '2021-10-07 08:21:23', '2021-10-07 08:21:23'),
(13, 233, '96667388829', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Jizan', '15941', 'Saudia Arabia', '2021-10-07 08:21:23', '2021-10-07 08:21:23'),
(14, 234, '96677382889', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Ha\'il.', '14230', 'Saudia Arabia', '2021-10-07 08:21:23', '2021-10-07 08:21:23'),
(15, 235, '96687376949', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Northern. Borders.', '20012', 'Saudia Arabia', '2021-10-07 08:21:23', '2021-10-07 08:21:23'),
(16, 236, '96697371009', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Tabuk.', '11564', 'Saudia Arabia', '2021-10-07 08:21:24', '2021-10-07 08:21:24'),
(17, 237, '96707365069', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Bahah', '15941', 'Saudia Arabia', '2021-10-07 08:21:24', '2021-10-07 08:21:24'),
(18, 238, '96717359129', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Jawf.', '14230', 'Saudia Arabia', '2021-10-07 08:21:24', '2021-10-07 08:21:24'),
(19, 239, '96727353189', NULL, 'Eastern Province', NULL, 'Eastern Province', 'Madinah.', '20012', 'Saudia Arabia', '2021-10-07 08:21:24', '2021-10-07 08:21:24'),
(20, 254, '2523452345', '346534634', '11', '2', '23534523452543', '365657334', '55342', 'AS', '2021-12-13 09:50:46', '2021-12-13 09:50:46');

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

--
-- Table structure for table `tbl_school_like`
--

CREATE TABLE `tbl_school_like` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `school_id` int(11) NOT NULL,
  `is_like` enum('0','1') COLLATE utf8_unicode_ci DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_school_like`
--

INSERT INTO `tbl_school_like` (`id`, `user_id`, `school_id`, `is_like`, `created_at`, `updated_at`) VALUES
(1, 50, 0, '1', '2021-09-09 18:10:34', '2021-09-09 18:10:34'),
(2, 50, 119, '1', '2021-09-09 18:13:28', '2021-09-18 05:12:52'),
(3, 51, 50, '0', '2021-09-09 18:23:36', '2021-09-09 18:23:56'),
(4, 50, 5, '1', '2021-09-18 05:13:05', '2021-09-18 05:13:05'),
(5, 5, 5, '1', '2021-09-18 05:13:16', '2021-09-18 05:13:16'),
(6, 0, 5, '1', '2021-09-18 05:23:55', '2021-09-18 05:23:55'),
(7, 1, 11, '0', '2021-09-19 14:02:14', '2021-09-19 14:02:37'),
(8, 1, 111, '0', '2021-09-19 14:02:50', '2021-09-19 14:02:50'),
(9, 138, 1, '0', '2021-09-20 12:23:23', '2021-09-21 04:24:14'),
(10, 138, 2, '0', '2021-09-20 12:27:45', '2021-09-21 04:23:41'),
(11, 138, 3, '0', '2021-09-20 12:28:09', '2021-09-20 13:27:01'),
(12, 140, 1, '0', '2021-09-20 12:58:03', '2021-09-20 13:07:37'),
(13, 138, 4, '0', '2021-09-20 13:27:07', '2021-09-20 13:27:07'),
(14, 159, 3, '1', '2021-10-03 14:06:02', '2021-10-09 18:34:09'),
(15, 159, 2, '0', '2021-10-03 14:07:06', '2021-10-09 18:41:03'),
(16, 196, 3, '1', '2021-10-06 06:48:40', '2021-10-06 06:48:40'),
(17, 11, 1, '1', '2021-10-06 10:24:44', '2021-10-06 10:26:39'),
(18, 212, 2, '1', '2021-10-07 03:22:45', '2021-10-07 03:22:45'),
(19, 159, 8, '1', '2021-10-09 03:53:00', '2021-10-09 03:53:00'),
(20, 159, 9, '1', '2021-10-09 05:38:45', '2021-10-09 05:38:45'),
(21, 215, 3, '1', '2021-10-09 09:50:09', '2021-10-09 09:50:09'),
(22, 215, 10, '1', '2021-10-09 09:50:15', '2021-10-09 09:50:15'),
(23, 215, 16, '1', '2021-10-09 09:50:20', '2021-10-09 09:50:20'),
(24, 159, 119, '1', '2021-10-09 18:34:47', '2021-10-09 21:07:31'),
(25, 159, 120, '1', '2021-10-09 18:38:18', '2021-10-09 18:50:33'),
(26, 159, 228, '1', '2021-10-09 18:38:22', '2021-10-09 21:07:34'),
(27, 212, 119, '0', '2021-10-10 02:22:30', '2021-10-10 02:22:48'),
(28, 212, 236, '0', '2021-10-10 02:23:25', '2021-10-12 06:55:32'),
(29, 254, 119, '1', '2021-10-10 06:31:34', '2021-10-10 06:31:34'),
(30, 255, 119, '1', '2021-10-10 13:37:29', '2021-10-10 13:37:29'),
(31, 255, 233, '1', '2021-10-10 13:37:34', '2021-10-10 13:37:34'),
(32, 1, 118, '1', '2023-02-27 11:11:18', '2023-02-27 11:11:44');

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

--
-- Table structure for table `tbl_section`
--

CREATE TABLE `tbl_section` (
  `id` int(11) NOT NULL,
  `section_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_section`
--

INSERT INTO `tbl_section` (`id`, `section_name`, `created_at`, `updated_at`) VALUES
(13, 'A', '2021-09-21 08:04:31', '2021-09-21 08:04:31'),
(14, 'B', '2021-09-21 08:04:31', '2021-09-21 08:04:31'),
(15, 'C', '2021-09-21 08:04:31', '2021-09-21 08:04:31'),
(16, 'D', '2021-09-21 08:04:31', '2021-09-21 08:04:31'),
(17, 'E', '2021-09-21 08:04:31', '2021-09-21 08:04:31'),
(18, 'F', '2021-09-21 08:04:31', '2021-09-21 08:04:31'),
(19, 'G', '2021-09-21 08:04:31', '2021-09-21 08:04:31');

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

--
-- Table structure for table `tbl_session`
--

CREATE TABLE `tbl_session` (
  `id` int(11) NOT NULL,
  `partner_id` int(11) NOT NULL,
  `session` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_session`
--

INSERT INTO `tbl_session` (`id`, `partner_id`, `session`, `created_at`, `updated_at`) VALUES
(11, 1, '1990-1991', '2021-09-18 07:29:20', '2021-09-18 07:29:20'),
(12, 1, '1991-1992', '2021-09-18 07:29:36', '2021-09-18 07:29:36'),
(13, 1, '1992-1993', '2021-09-18 07:31:48', '2021-09-18 07:31:48'),
(14, 1, '1993-1994', '2021-09-18 07:33:40', '2021-09-18 07:33:40'),
(16, 1, '1994-1995', '2021-09-18 07:39:31', '2021-09-18 07:39:31'),
(17, 1, '1995-1996', '2021-09-18 07:40:02', '2021-09-18 07:40:02'),
(18, 1, '1996-1997', '2021-09-18 07:40:22', '2021-09-18 07:40:22'),
(19, 1, '1997-1998', '2021-09-21 15:30:23', '2021-09-21 15:30:23'),
(20, 1, '1998-1999', '2021-09-18 07:40:57', '2021-09-18 07:40:57'),
(21, 1, '1999-2000', '2021-09-18 07:41:16', '2021-09-18 07:41:16'),
(25, 1, '2000-2001', '2021-09-21 08:06:02', '2021-09-21 08:06:02'),
(26, 1, '2001-2002', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(27, 1, '2002-2003', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(28, 1, '2003-2004', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(29, 1, '2004-2005', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(30, 1, '2005-2006', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(31, 1, '2006-2007', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(32, 1, '2007-2008', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(33, 1, '2008-2009', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(34, 1, '2009-2010', '2021-09-21 15:22:32', '2021-09-21 15:22:32'),
(35, 1, '2010-2011', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(36, 1, '2011-2012', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(37, 1, '2012-2013', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(38, 1, '2013-2014', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(39, 1, '2014-2015', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(40, 1, '2015-2016', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(41, 1, '2016-2017', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(42, 1, '2017-2018', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(43, 1, '2018-2019', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(44, 1, '2019-2020', '2021-09-21 15:25:05', '2021-09-21 15:25:05'),
(45, 1, '2020-2021', '2021-09-21 15:27:06', '2021-09-21 15:27:06'),
(46, 1, '2021-2022', '2021-09-21 15:27:06', '2021-09-21 15:27:06'),
(47, 1, '2022-2023', '2021-09-21 15:27:06', '2021-09-21 15:27:06'),
(48, 1, '2023-2024', '2021-09-21 15:27:06', '2021-09-21 15:27:06'),
(49, 1, '2024-2025', '2021-09-21 15:27:06', '2021-09-21 15:27:06'),
(50, 1, '2025-2026', '2021-09-21 15:27:06', '2021-09-21 15:27:06'),
(51, 1, '2027-2028', '2021-09-21 15:27:06', '2021-09-21 15:27:06'),
(52, 1, '2028-2029', '2021-09-21 15:27:06', '2021-09-21 15:27:06'),
(53, 1, '2029-2030', '2021-09-21 15:27:06', '2021-09-21 15:27:06');

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

--
-- Table structure for table `tbl_student`
--

CREATE TABLE `tbl_student` (
  `id` int(11) NOT NULL,
  `sid` int(11) DEFAULT NULL,
  `current_status` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `school_id` varchar(110) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `session` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `enrollment_number` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_student`
--

INSERT INTO `tbl_student` (`id`, `sid`, `current_status`, `school_id`, `category_id`, `session`, `class_id`, `section_id`, `enrollment_number`, `created_at`, `updated_at`) VALUES
(32, 134, '1', '118', 3, '1991-1992', 0, 8, NULL, '2021-09-19 05:24:53', '2021-09-19 05:24:53'),
(33, 134, '1', '118', 3, '1991-1992', 0, 8, NULL, '2021-09-19 05:25:01', '2021-09-19 05:25:01'),
(34, 134, '1', '118', 3, '1991-1992', 0, 8, NULL, '2021-09-19 05:25:20', '2021-09-19 05:25:20'),
(35, 134, '2', '120', 4, '1993-1994', 1, 7, NULL, '2021-09-19 05:25:20', '2021-09-19 05:25:20'),
(46, 134, '1', '121', 3, '1993-1994', 0, 8, NULL, '2021-09-19 06:38:51', '2021-09-19 06:38:51'),
(59, 127, '1', '118', 3, '30', 13, 7, NULL, '2021-09-19 10:51:39', '2021-09-19 10:18:50'),
(60, 127, '2', '118', 4, '40', 2, 2, NULL, '2021-09-19 10:45:52', '2021-09-19 10:18:50'),
(61, 127, NULL, '118', 5, NULL, 222, 8, NULL, '2021-09-19 10:51:50', '2021-09-19 10:18:50'),
(62, 127, NULL, NULL, 6, NULL, NULL, NULL, NULL, '2021-09-19 10:42:41', '2021-09-19 10:18:50'),
(63, 141, '1', '120', 3, '1993-1994', 0, 16, NULL, '2021-09-22 02:05:28', '2021-09-22 02:05:28'),
(64, 141, '2', NULL, 4, NULL, NULL, NULL, NULL, '2021-09-22 02:05:28', '2021-09-22 02:05:28'),
(65, 141, NULL, NULL, 5, NULL, NULL, NULL, NULL, '2021-09-22 02:05:28', '2021-09-22 02:05:28'),
(66, 141, NULL, NULL, 6, NULL, NULL, NULL, NULL, '2021-09-22 02:05:28', '2021-09-22 02:05:28'),
(67, 141, NULL, NULL, 7, NULL, NULL, NULL, NULL, '2021-09-22 02:05:28', '2021-09-22 02:05:28'),
(68, 141, NULL, NULL, 8, NULL, NULL, NULL, NULL, '2021-09-22 02:05:28', '2021-09-22 02:05:28'),
(69, 141, NULL, NULL, 9, NULL, NULL, NULL, NULL, '2021-09-22 02:05:28', '2021-09-22 02:05:28'),
(70, 144, NULL, '120', 4, '1992-1993', 19, 8, '432423', '2021-09-20 08:33:33', '2021-09-20 08:33:33'),
(71, 156, NULL, '119', 4, '2018-2019', 20, 15, '423424232', '2021-09-24 15:20:01', '2021-09-22 15:43:42'),
(72, 156, NULL, '120', 4, '1995-1996', 19, 16, NULL, '2021-09-24 11:25:31', '2021-09-24 11:25:31'),
(73, 158, '4', '120', 3, '1992-1993', 17, 15, NULL, '2021-09-25 16:00:08', '0000-00-00 00:00:00'),
(74, 158, NULL, '120', 4, '1994-1995', 20, 16, NULL, '2021-09-25 16:00:08', '0000-00-00 00:00:00'),
(75, 159, '0', '120', 3, '2012-2013', 15, 14, NULL, '2021-10-06 02:28:51', '2021-10-06 02:28:51'),
(76, 160, '1', '120', 3, '1999-2000', 18, 16, NULL, '2021-10-06 06:32:09', '2021-10-06 06:32:09'),
(77, 159, '0', '119', 4, '2016-2017', 20, 16, NULL, '2021-10-06 02:28:51', '2021-10-06 02:28:51'),
(78, 160, '1', '119', 4, '1994-1995', 20, 16, NULL, '2021-10-06 06:32:09', '2021-10-06 06:32:09'),
(87, 192, '1', '1', 111, '30', 1, 10, NULL, '2021-10-05 14:06:57', '2021-10-05 14:06:57'),
(88, 160, '1', '119', 7, '2020-2021', 31, 16, NULL, '2021-10-06 06:32:09', '2021-10-06 06:32:09'),
(89, 160, '0', '119', 8, '2023-2024', 36, 16, NULL, '2021-10-06 06:32:09', '2021-10-06 06:32:09'),
(90, 195, '4', '119', 3, '2014-2015', 16, 16, NULL, '2021-10-01 12:31:23', '0000-00-00 00:00:00'),
(91, 195, NULL, '119', 4, '2021-2022', 20, 17, NULL, '2021-10-01 12:31:23', '0000-00-00 00:00:00'),
(92, 193, '3', '119', 3, '1994-1995', 18, 16, NULL, '2021-10-01 12:58:12', '0000-00-00 00:00:00'),
(93, 200, '3', '120', 3, '1992-1993', 15, 15, NULL, '2021-10-05 13:33:49', '0000-00-00 00:00:00'),
(94, 209, '1', '119', 3, '1999-2000', 18, 16, NULL, '2021-10-07 07:10:47', '2021-10-07 07:10:47'),
(95, 210, '3', '119', 3, '1999-2000', 18, 16, NULL, '2021-10-05 13:46:19', '0000-00-00 00:00:00'),
(96, 192, '2', '2', 556, '40', 2, 2, NULL, '2021-10-05 14:06:57', '2021-10-05 14:06:57'),
(97, 192, NULL, NULL, 1, NULL, 222, NULL, NULL, '2021-10-05 14:06:57', '2021-10-05 14:06:57'),
(98, 192, NULL, NULL, 2077, NULL, NULL, NULL, NULL, '2021-10-05 14:06:57', '2021-10-05 14:06:57'),
(99, 159, '0', '120', 5, '1993-1994', 23, 16, NULL, '2021-10-06 02:28:51', '2021-10-06 02:28:51'),
(100, 196, '0', '120', 3, '2021-2022', 18, 16, NULL, '2021-10-07 07:04:32', '2021-10-07 07:04:32'),
(101, 196, '1', '120', 7, '2004-2005', 33, 15, NULL, '2021-10-07 07:04:32', '2021-10-07 07:04:32'),
(102, 212, '1', '119', 3, '1992-1993', 14, 15, NULL, '2021-10-07 06:21:17', '2021-10-07 06:21:17'),
(103, 209, '0', '119', 4, '2003-2004', 21, 16, NULL, '2021-10-07 07:10:47', '0000-00-00 00:00:00'),
(104, 222, NULL, '119', 4, '1995-1996', 20, 15, NULL, '2021-10-07 07:28:11', '2021-10-07 07:28:11'),
(105, 223, NULL, '119', 4, '1995-1996', 20, 15, NULL, '2021-10-07 07:28:11', '2021-10-07 07:28:11'),
(106, 225, NULL, '120', 5, '2006-2007', 22, 19, NULL, '2021-10-07 07:55:48', '2021-10-07 07:55:48'),
(107, 226, NULL, '120', 5, '2006-2007', 22, 19, NULL, '2021-10-07 07:55:48', '2021-10-07 07:55:48'),
(108, 241, NULL, '228', 3, '2020-2021', 14, 13, NULL, '2021-10-07 09:18:58', '2021-10-07 09:18:58'),
(109, 243, NULL, '228', 3, '2020-2021', 14, 13, NULL, '2021-10-07 09:22:59', '2021-10-07 09:22:59'),
(110, 244, NULL, '228', 3, '2020-2021', 14, 13, NULL, '2021-10-07 09:22:59', '2021-10-07 09:22:59'),
(111, 245, NULL, '228', 3, '2020-2021', 14, 13, NULL, '2021-10-07 09:22:59', '2021-10-07 09:22:59'),
(112, 246, NULL, '228', 3, '2020-2021', 14, 13, NULL, '2021-10-07 09:22:59', '2021-10-07 09:22:59'),
(113, 247, NULL, '228', 3, '2020-2021', 14, 13, NULL, '2021-10-07 09:22:59', '2021-10-07 09:22:59'),
(116, 215, '1', '228', 3, '2007-2008', 18, 16, NULL, '2021-10-09 09:53:48', '0000-00-00 00:00:00'),
(117, 253, '1', '231', 3, '1992-1993', 14, 15, NULL, '2021-10-11 14:47:51', '2021-10-11 14:47:51'),
(118, 255, '1', '119', 3, '2010-2011', 16, 17, NULL, '2021-10-10 13:45:22', '2021-10-10 13:45:22'),
(119, 255, '0', '120', 4, '2013-2014', 21, 17, NULL, '2021-10-10 13:45:22', '2021-10-10 13:45:22'),
(120, 255, '0', '228', 5, '2016-2017', 24, 17, NULL, '2021-10-10 13:45:22', '2021-10-10 13:45:22'),
(121, 255, '0', '230', 7, '2020-2021', 31, 13, NULL, '2021-10-10 13:45:22', '2021-10-10 13:45:22');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `chat_lists`
--
ALTER TABLE `chat_lists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chat_lists_sender_id_foreign` (`sender_id`),
  ADD KEY `chat_lists_reciever_id_foreign` (`reciever_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 `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- 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=13;

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `chat_lists`
--
ALTER TABLE `chat_lists`
  ADD CONSTRAINT `chat_lists_reciever_id_foreign` FOREIGN KEY (`reciever_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chat_lists_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

