--
-- Host: localhost    Database: kanfeebulksms_agentnew12025718
-- ------------------------------------------------------


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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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,
  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 `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


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

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

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

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2025_06_21_005038_add_role_to_users_table',2),(5,'2025_07_17_011131_create_settings_table',3),(6,'2025_07_21_005955_add_profile_fields_to_users_table',4),(7,'2025_07_22_010620_create_password_reset_tokens_table',5),(8,'2025_07_30_112106_add_slug_to_settings_table',6),(9,'2025_07_30_134751_update_settings_table_remove_key_column',7),(10,'2025_07_31_001923_create_support_contacts_table',8),(11,'2025_07_31_025504_add_value_to_support_contacts_table',9),(12,'2025_07_31_133054_create_useful_links_table',10);

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('HyhX2bAPVa0Vi5IGOaCyIwH9IIoaOJvxr18sZ5b4',NULL,'172.222.214.3','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZDVQelF6UUFnYXp3ajV2MVY4YjhScDEyUnFTV3FqZ0RNWnJtbGh0TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8va2FuZmVlYnVsa3Ntcy5jb20vYWdlbnRwb3J0YWwvcHVibGljL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1754011169),('ONdZGcG15C6vfsXofYbYZggJAWqBnc66XrD8dHt6',47,'172.222.214.3','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoic0ZFS3BhbllZUWFrYk1sUFlsbTVkOUxvV0VsQjdGSTh1Tk1Sc0NhRCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjA6Imh0dHBzOi8va2FuZmVlYnVsa3Ntcy5jb20vYWdlbnRwb3J0YWwvcHVibGljL2FkbWluL2Rhc2hib2FyZCI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjQ3O30=',1754016299),('zO84ZCt0yTbDAGxF2qqe31OnidknbtcSEse1ZFPH',38,'172.222.214.3','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:141.0) Gecko/20100101 Firefox/141.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVjVyVklFSXhDZDAwZDh6M1o2Qk9Bc3c0R1N0TUdzVUpQSHFsYWRrYSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjA6Imh0dHBzOi8va2FuZmVlYnVsa3Ntcy5jb20vYWdlbnRwb3J0YWwvcHVibGljL2FnZW50L2Rhc2hib2FyZCI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM4O30=',1754011037);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'excerpt_title','Drop Us A Message','2025-07-30 15:09:24','2025-07-30 15:09:24'),(2,'excerpt','Our objective at KanfeeAgency is to provide prompt responses to your needs. Don\'t hesitate! Let us hear from you.','2025-07-30 15:15:06','2025-07-30 15:48:11'),(3,'contact_form_title','Contact Form','2025-07-30 15:15:06','2025-07-30 15:15:06'),(4,'company_name','KanfeeAgency','2025-07-30 15:15:06','2025-07-30 15:48:11'),(5,'business_address','Rancho Cucamonga, CA 91701','2025-07-30 15:15:06','2025-07-30 15:15:06'),(6,'company_email','support@kanfeeagency.com','2025-07-30 15:15:06','2025-07-30 15:48:11'),(7,'company_phone_number','+(866)-331-1980','2025-07-30 15:15:06','2025-07-30 15:15:06'),(8,'work_hours','Monday - Saturday\r\n9:00 AM to 5:30 PM\r\nSunday Closed','2025-07-30 15:15:06','2025-07-30 15:48:11');

--
-- Table structure for table `support_contacts`
--

CREATE TABLE `support_contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `support_contacts_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_contacts`
--

INSERT INTO `support_contacts` VALUES (1,'main',NULL,NULL,NULL,NULL,'2025-07-31 00:27:51','2025-07-31 00:27:51'),(2,'excerpt_title','Drop Us A Message',NULL,NULL,NULL,NULL,NULL),(3,'excerpt','Our objective at KanfeeAgency is to provide prompt responses to your needs.\r\nDon\'t hesitate! Let us hear from you.',NULL,NULL,NULL,NULL,NULL),(4,'contact_form_title','Contact Form',NULL,NULL,NULL,NULL,NULL),(5,'company_name','KanfeeAgency',NULL,NULL,NULL,NULL,NULL),(6,'business_address','Rancho Cucamonga, CA 91701',NULL,NULL,NULL,NULL,NULL),(7,'company_email','support@kanfeeagency.com',NULL,NULL,NULL,NULL,NULL),(8,'company_phone_number','+(866)-331-1980',NULL,NULL,NULL,NULL,NULL),(9,'work_hours','Monday - Saturday\r\n9:00 AM to 5:30 PM\r\nSunday Closed',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `useful_links`
--

CREATE TABLE `useful_links` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `useful_links`
--

INSERT INTO `useful_links` VALUES (2,'KanfeeAgency Website','https://kanfeeagency.com/','2025-07-31 23:12:42','2025-07-31 23:12:42');


