--
-- Host: localhost    Database: frieghtosdb
-- ------------------------------------------------------


--
-- Table structure for table `available_slot_for_booking`
--

CREATE TABLE `available_slot_for_booking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `classname_id` int DEFAULT NULL,
  `room_id` int DEFAULT NULL,
  `monday_slot_star` int DEFAULT NULL,
  `monday_slot_end` int DEFAULT NULL,
  `tuesday_slot_star` int DEFAULT NULL,
  `tuesday_slot_end` int DEFAULT NULL,
  `wednesday_slot_star` int DEFAULT NULL,
  `wednesday_slot_end` int DEFAULT NULL,
  `thursday_slot_star` int DEFAULT NULL,
  `thursday_slot_end` int DEFAULT NULL,
  `friday_slot_star` int DEFAULT NULL,
  `friday_slot_end` int DEFAULT NULL,
  `sat_slot_star` int DEFAULT NULL,
  `sunday_slot_star` int DEFAULT NULL,
  `sunday_slot_end` int DEFAULT NULL,
  `can_book_every` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `booked_username` varchar(20) DEFAULT NULL,
  `sat_slot_end` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `available_slot_for_booking`
--

INSERT INTO `available_slot_for_booking` VALUES (7,4,2,8,18,NULL,NULL,NULL,NULL,8,18,NULL,NULL,NULL,NULL,NULL,2,'2023-01-25 05:25:06','2023-01-25 05:25:06',NULL,18),(8,4,1,9,18,NULL,NULL,9,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2023-01-25 05:27:01','2023-01-25 05:27:01',NULL,NULL),(9,4,3,NULL,NULL,15,22,NULL,NULL,NULL,NULL,15,22,NULL,NULL,NULL,1,'2023-01-25 05:29:32','2023-01-25 05:29:32',NULL,22),(10,4,4,NULL,NULL,15,22,NULL,NULL,NULL,NULL,15,22,NULL,NULL,NULL,1,'2023-01-25 07:02:06','2023-01-25 07:02:06',NULL,22);

--
-- Table structure for table `booking_slot`
--

CREATE TABLE `booking_slot` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slot_id` int DEFAULT NULL,
  `booked_by` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `booking_slot`
--

INSERT INTO `booking_slot` VALUES (1,1,'raju','2023-01-25 07:42:31','2023-01-25 07:42:31',NULL),(2,1,'raju','2023-01-25 07:48:09','2023-01-25 07:48:09',NULL),(3,1,'raju','2023-01-25 07:48:51','2023-01-25 07:48:51',NULL),(4,1,'raju','2023-01-25 07:50:39','2023-01-25 07:50:39',NULL),(5,1,'raju','2023-01-25 07:51:09','2023-01-25 07:51:09',NULL),(6,1,'raju','2023-01-25 07:52:22','2023-01-25 07:52:22','1'),(7,1,'raju','2023-01-25 08:53:35','2023-01-25 09:16:35','2');

--
-- Table structure for table `classes`
--

CREATE TABLE `classes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `classname` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` VALUES (4,'Maths','2023-01-25 05:18:54','2023-01-25 05:18:54'),(5,'Chemistry','2023-01-25 06:58:48','2023-01-25 06:58:48');

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(6,'2016_06_01_000004_create_oauth_clients_table',1),(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(8,'2019_08_19_000000_create_failed_jobs_table',1),(9,'2019_12_14_000001_create_personal_access_tokens_table',1);

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `client_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--


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

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

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` VALUES (1,NULL,'Laravel Personal Access Client','b3DGmf33n7qcZhFDPoopC5vHditorwcPIJ5U1yxq',NULL,'http://localhost',1,0,0,'2023-01-25 02:00:33','2023-01-25 02:00:33'),(2,NULL,'Laravel Password Grant Client','1jSpJV3rYQeFDHDGKQIamQc7CSdZB8mnwRiNKZ31','users','http://localhost',0,1,0,'2023-01-25 02:00:33','2023-01-25 02:00:33');

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

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2023-01-25 02:00:33','2023-01-25 02:00:33');

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--

INSERT INTO `personal_access_tokens` VALUES (1,'App\\Models\\User',1,'FreightOsApp','53f1ea6a181a6104df683fa43ccc2bc56ad919f8403733ccd38647c74a78f095','[\"*\"]',NULL,NULL,'2023-01-25 03:02:22','2023-01-25 03:02:22'),(2,'App\\Models\\User',1,'FreightOsApp','4528a7016803dc5c08f6f907a95f91dbdd69c7b5accf12a3e5f446525ae41715','[\"*\"]',NULL,NULL,'2023-01-25 03:09:43','2023-01-25 03:09:43'),(3,'App\\Models\\User',1,'FreightOsApp','6806c4550f71060dd4480f74c7631e4cbb3a0e65542f44ad6913f55fe420bb44','[\"*\"]',NULL,NULL,'2023-01-25 03:30:01','2023-01-25 03:30:01'),(4,'App\\Models\\User',1,'FreightOsApp','686fdf88b1e3b16139237b08eedd59c25ebd6c3bc6273a3f334c6865292b58f2','[\"*\"]',NULL,NULL,'2023-01-25 03:42:25','2023-01-25 03:42:25'),(5,'App\\Models\\User',1,'FreightOsApp','8f48fea993deeaddb108ac11a3b960282f152aa949435eb599d07d19fd4c5552','[\"*\"]','2023-01-25 06:58:48',NULL,'2023-01-25 03:47:33','2023-01-25 06:58:48'),(6,'App\\Models\\User',1,'FreightOsApp','36a92aad2641245cca35e56128ab9f9a3b8015b5729fdf0d4f63995d63456d7e','[\"*\"]',NULL,NULL,'2023-01-25 03:47:57','2023-01-25 03:47:57'),(7,'App\\Models\\User',1,'FreightOsApp','23ec7a33b3abdcd2cc5a9fc5dadfa864e9b71a1cbd40acd1106630936ff7c0e5','[\"*\"]','2023-01-25 07:00:49',NULL,'2023-01-25 04:21:55','2023-01-25 07:00:49'),(8,'App\\Models\\User',1,'FreightOsApp','451986eb41b6f73fc857fdc452f5b3eea807f2322039857668f0cda1e2369874','[\"*\"]','2023-01-25 07:02:06',NULL,'2023-01-25 04:50:19','2023-01-25 07:02:06'),(9,'App\\Models\\User',1,'FreightOsApp','3b1e44798ba395a7c0f4d35cc1fae34ca970ec335457496223470e6ca48b49c3','[\"*\"]',NULL,NULL,'2023-01-25 06:53:08','2023-01-25 06:53:08'),(10,'App\\Models\\User',3,'FreightOsApp','6370ce3024a9648f14094b2beee4b2a69b5658d22a0be80b36a32a88794dc2fe','[\"*\"]',NULL,NULL,'2023-01-25 06:55:21','2023-01-25 06:55:21'),(11,'App\\Models\\User',1,'FreightOsApp','3dcbd8a43da2d692054a51541507a2310c1b35355431636e378b4a5edc084451','[\"*\"]',NULL,NULL,'2023-01-25 06:58:00','2023-01-25 06:58:00'),(12,'App\\Models\\User',1,'FreightOsApp','936d6d82b135b2ba4ac46401bf1fb5c725d70866677bed23625a030e1cd08300','[\"*\"]','2023-01-25 08:42:29',NULL,'2023-01-25 07:10:21','2023-01-25 08:42:29'),(13,'App\\Models\\User',1,'FreightOsApp','31c64e1d12c92fa36b9d076262802d93241aac9563f0d7341b61012109ccc923','[\"*\"]','2023-01-25 09:16:35',NULL,'2023-01-25 08:52:44','2023-01-25 09:16:35'),(14,'App\\Models\\User',5,'FreightOsApp','244be9a3efe1889d27b0df1b05a993d03afbf7088e6b7384f4a070cb19e19461','[\"*\"]',NULL,NULL,'2023-01-28 04:27:42','2023-01-28 04:27:42'),(15,'App\\Models\\User',7,'FreightOsApp','922cd62c9c6e6762af4664895c509c30f6bf9b7a4cbca8c03691141de82d7d25','[\"*\"]',NULL,NULL,'2023-01-28 04:49:04','2023-01-28 04:49:04'),(16,'App\\Models\\User',1,'FreightOsApp','e789757754e1cd1c98ae8b89db1dacf4a9efee2b0744ae33eb8e58fe8121a7ab','[\"*\"]',NULL,NULL,'2023-01-28 05:25:51','2023-01-28 05:25:51'),(17,'App\\Models\\User',1,'FreightOsApp','413e9976048131acfcc0f5a9207e13e76cb0aa05958be69bad7eeef285c23c52','[\"*\"]','2023-01-28 16:48:20',NULL,'2023-01-28 14:50:58','2023-01-28 16:48:20'),(18,'App\\Models\\User',1,'FreightOsApp','6e6602dd3b4ed26a516f28c296c48daa24511000d046ecab46c4c1c9087a8637','[\"*\"]','2023-01-29 00:23:04',NULL,'2023-01-29 00:05:10','2023-01-29 00:23:04'),(19,'App\\Models\\User',1,'FreightOsApp','812fa1124dfb2adebe618d723663cce5f1a72d051d4c6d459b25f145f47b8bd3','[\"*\"]','2023-01-29 05:35:03',NULL,'2023-01-29 00:51:22','2023-01-29 05:35:03');

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `room_name` varchar(20) DEFAULT NULL,
  `room_capacity` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` VALUES (1,'A',10,'2023-01-25 04:23:30','2023-01-25 04:23:30'),(2,'B',15,'2023-01-25 05:17:37','2023-01-25 05:17:37'),(3,'C',7,'2023-01-25 05:17:57','2023-01-25 05:17:57'),(4,'D',7,'2023-01-25 07:00:49','2023-01-25 07:00:49');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'sundar','apkpsm@gmail.com',NULL,'$2y$10$e0wl7BJUGSlPVEs4TN7akOFnh5/1gZg0OttqQUUmmCJzrj14gPo1q',NULL,'2023-01-25 03:02:22','2023-01-25 03:02:22'),(3,'sundar','apkpsm1@gmail.com',NULL,'$2y$10$lXesZEVyC7UpcKcR1C0cfu3fnS04kF80vYhDzUiTxsYdjtrzhoK9i',NULL,'2023-01-25 06:55:21','2023-01-25 06:55:21'),(5,'sundar','apksundar@gmail.com',NULL,'$2y$10$z1aWXvzvnxC20KHq.i7CP.PxkfqWEqqIVP4/N1ia5M/3YBqB6z6T2',NULL,'2023-01-28 04:27:42','2023-01-28 04:27:42'),(7,'sundar','apksundartest@gmail.com',NULL,'$2y$10$Tb1xb37rGMy1XQHfCNYYAOJ7On6n5krrdREHkNf0NYZx6tuBnUiRC',NULL,'2023-01-28 04:49:04','2023-01-28 04:49:04');


