--
-- 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_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_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 `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');


