Test 1 Test 1 Test 1 Test 1 Test 1 Test 1 Test 1 Test 1 Test 1 Test 1 Test 1 Test 1 Test 1
','Technical Issue',NULL,'Resolved','3','Medium','test',NULL,NULL,'2024-11-25 20:52:54','2024-11-28','2024-11-27T14:57',NULL,'2','103.244.179.4','2024-11-25 19:54:25','2024-11-25 20:52:54'),(2,'1732564816','Jeff Williams','jeff@designsfunnel.com',NULL,NULL,'Test 2','Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2 Test 2
','Technical Issue',NULL,'Unresolved','3','Low',NULL,'teststtttt',NULL,NULL,'2024-11-28','2024-11-08T17:54',NULL,'2','103.244.179.4','2024-11-25 20:00:16','2024-11-25 20:52:58'),(3,'1732648059','hipabi','tikehyt@mailinator.com','+1 (652) 423-2452','Omnis eius exercitat','Aut sapiente est au','Quia et aut sit tem','General Inquiry',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-11-26 19:07:39','2024-11-26 19:07:39'),(4,'1732714997','lavak','xawyjofas@mailinator.com','+1 (544) 681-5418','Qui sed minim except','Et ut perspiciatis','Dolor molestiae cons','General Inquiry',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-11-27 13:43:17','2024-11-27 13:43:17'),(5,'1732715044','wamuziqymi','gowykemagi@mailinator.com','+1 (732) 115-7691','Dolor commodo minim','Laboriosam sint et','Repellendus Sit ali','General Inquiry',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-11-27 13:44:04','2024-11-27 13:44:04'),(6,'1732715114','kifuba','wyboqow@mailinator.com','+1 (296) 621-4446','Pariatur Obcaecati','Et cillum deserunt d','Laboriosam anim lau','General Inquiry',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-11-27 13:45:14','2024-11-27 13:45:14'),(7,'1732715643','jiqejugo','taxahugex@mailinator.com','+1 (679) 831-6592','Sapiente ullam volup','Sequi qui dolor volu','Sunt nemo officia am','General Inquiry',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-11-27 13:54:03','2024-11-27 13:54:03'),(8,'1732715934','ninuvuc','fesami@mailinator.com','+1 (992) 282-3331','Quam dolore obcaecat','Sed illum expedita','Inventore aliquip in','Customer Service',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-11-27 13:58:54','2024-11-27 13:58:54'),(9,'1732722687','Jeff Williams','jeff@designsfunnel.com','3073149315','7673 Oak Field Ct','Testing from frontend','Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend Testing from frontend','Technical Issue',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-11-27 15:51:27','2024-11-27 15:51:27'),(10,'1732801839','test name','email@gmail.com','2954836023','Alias exercitation d','test','test','Customer Service',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-11-28 13:50:39','2024-11-28 13:50:39'),(11,'1733169337','cytafew','covaty@mailinator.com','+1 (432) 682-7536','Repudiandae sit aut','Vel fugit nemo id q','Qui ut tenetur neque','Customer Service',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-12-02 19:55:37','2024-12-02 19:55:37'),(12,'1733170555','fyryfoteno','fihiroxozu@mailinator.com','+1 (481) 806-3585','Placeat quia alias','Ea quis ut perspicia','Eaque ut voluptatem','General Inquiry',NULL,'New',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'199.192.21.156','2024-12-02 20:15:55','2024-12-02 20:15:55'),(13,'1733170702','qiwerizybi','lixi@mailinator.com','+1 (481) 187-1987','Rem aut dolor verita','Provident in commod','Velit velit dolore d','General Inquiry',NULL,'Assigned','3','Medium',NULL,NULL,NULL,NULL,'2024-12-24',NULL,NULL,NULL,'199.192.21.156','2024-12-02 20:18:22','2024-12-02 20:20:38'); /*!40000 ALTER TABLE `complaints` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email_templates` -- DROP TABLE IF EXISTS `email_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `email_templates` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `identifier` varchar(255) DEFAULT NULL, `subject` text DEFAULT NULL, `note` text DEFAULT NULL, `content` longtext DEFAULT NULL, `system_use` int(11) NOT NULL DEFAULT 0, `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `email_templates` -- LOCK TABLES `email_templates` WRITE; /*!40000 ALTER TABLE `email_templates` DISABLE KEYS */; INSERT INTO `email_templates` VALUES (1,'Forgot Password','emails.forgot','Forgot Password',NULL,'Hello [name],
It looks like you requested to reset your password. Click the button below to proceed.
',1,'2024-11-21 14:14:00','2024-11-21 15:26:46'),(2,'Email Verification','emails.verify_email','Email Verification',NULL,'
Hi there,
Welcome to Designs Funnel LLC! Please verify your email address by clicking the button below.
',1,'2024-11-21 14:14:00','2024-11-21 14:14:00'); /*!40000 ALTER TABLE `email_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `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(), PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` 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_06_06_140353_create_roles_table',1),(7,'2024_06_06_140425_create_permissions_table',1),(8,'2024_06_06_140448_create_role_permissions_table',1),(9,'2024_06_21_133502_create_email_templates_table',1),(10,'2024_06_28_151139_create_cities_table',1),(11,'2024_07_05_180355_create_states_table',1),(12,'2024_10_04_194658_create_newsletters_table',1),(13,'2024_10_07_180841_create_jobs_table',1),(14,'2024_10_07_183753_create_system_settings_table',1),(15,'2024_10_07_184808_create_smtp_settings_table',1),(16,'2024_11_12_122322_create_color_settings_table',1),(18,'2024_11_20_181027_create_attendances_table',1),(20,'2024_11_18_153726_create_complaints_table',2); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `newsletters` -- DROP TABLE IF EXISTS `newsletters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `newsletters` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `newsletters` -- LOCK TABLES `newsletters` WRITE; /*!40000 ALTER TABLE `newsletters` DISABLE KEYS */; /*!40000 ALTER TABLE `newsletters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `password_resets` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `display_name` varchar(255) NOT NULL, `group` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'create-user','Create User','User Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(2,'read-user','Read User','User Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(3,'update-user','Update User','User Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(4,'delete-user','Delete User','User Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(5,'create-role','Create Role','Role Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(6,'read-role','Read Role','Role Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(7,'update-role','Update Role','Role Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(8,'delete-role','Delete Role','Role Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(9,'create-email-template','Create Email Template','Email Template Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(10,'read-email-template','Read Email Template','Email Template Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(11,'update-email-template','Update Email Template','Email Template Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(12,'delete-email-template','Delete Email Template','Email Template Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(13,'sent-email','Sent Email','Email Template Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(14,'create-state','Create State','State Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(15,'read-state','Read State','State Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(16,'update-state','Update State','State Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(17,'delete-state','Delete State','State Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(18,'read-profile','Read Profile','Profile Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(19,'read-setting','Read Setting','Setting Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(20,'update-setting','Update Setting','Setting Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(21,'create-setting','Create Setting','Setting Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(22,'create-complaint','Create Complaint','Complaint Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(23,'read-complaint','Read Complaint','Complaint Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(24,'update-complaint','Update Complaint','Complaint Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(25,'delete-complaint','Delete Complaint','Complaint Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(26,'create-attendance','Create Attendance','Attendance Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(27,'read-attendance','Read Attendance','Attendance Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(28,'update-attendance','Update Attendance','Attendance Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(29,'delete-attendance','Delete Attendance','Attendance Management','1',NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_permissions` -- DROP TABLE IF EXISTS `role_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `role_permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` int(11) NOT NULL, `permission_id` varchar(255) NOT NULL, `user_id` int(11) NOT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `author_ip` varchar(255) DEFAULT NULL, `author_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_permissions` -- LOCK TABLES `role_permissions` WRITE; /*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */; INSERT INTO `role_permissions` VALUES (11,1,'create-user',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(12,1,'read-user',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(13,1,'update-user',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(14,1,'delete-user',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(15,1,'read-profile',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(16,1,'create-complaint',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(17,1,'read-complaint',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(18,1,'update-complaint',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(19,1,'delete-complaint',1,'1','103.244.179.4','1','2024-11-21 15:58:39','2024-11-21 15:58:39',NULL),(20,2,'update-user',1,'1','103.244.179.4','1','2024-11-21 16:02:16','2024-11-21 16:02:16',NULL),(21,2,'read-profile',1,'1','103.244.179.4','1','2024-11-21 16:02:16','2024-11-21 16:02:16',NULL),(22,2,'read-complaint',1,'1','103.244.179.4','1','2024-11-21 16:02:16','2024-11-21 16:02:16',NULL),(23,2,'update-complaint',1,'1','103.244.179.4','1','2024-11-21 16:02:16','2024-11-21 16:02:16',NULL),(24,2,'create-attendance',1,'1','103.244.179.4','1','2024-11-21 16:02:16','2024-11-21 16:02:16',NULL),(25,2,'read-attendance',1,'1','103.244.179.4','1','2024-11-21 16:02:16','2024-11-21 16:02:16',NULL); /*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `status` int(11) NOT NULL DEFAULT 1, `user_id` int(11) DEFAULT NULL, `author_ip` text DEFAULT NULL, `author_id` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'Admin',1,1,NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL),(2,'Technician',1,1,NULL,NULL,'2024-11-21 14:13:59','2024-11-21 14:13:59',NULL); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smtp_settings` -- DROP TABLE IF EXISTS `smtp_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `smtp_settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `host` varchar(255) DEFAULT NULL, `port` varchar(255) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `encryption` varchar(255) DEFAULT NULL, `from_name` varchar(255) DEFAULT NULL, `from_address` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `smtp_settings` -- LOCK TABLES `smtp_settings` WRITE; /*!40000 ALTER TABLE `smtp_settings` DISABLE KEYS */; INSERT INTO `smtp_settings` VALUES (1,'smtp.gmail.com','465','support@tresource.com','ywnatfxelmjoemul','ssl','Arias Communication Services','support@tresource.com','1','103.244.179.4','1','2024-11-21 14:49:50','2024-11-21 14:49:50'); /*!40000 ALTER TABLE `smtp_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `states` -- DROP TABLE IF EXISTS `states`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `states` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `states` -- LOCK TABLES `states` WRITE; /*!40000 ALTER TABLE `states` DISABLE KEYS */; INSERT INTO `states` VALUES (1,'Alabama','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(2,'Alaska','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(3,'Arizona','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(4,'Arkansas','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(5,'California','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(6,'Colorado','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(7,'Connecticut','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(8,'Delaware','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(9,'Florida','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(10,'Georgia','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(11,'Hawaii','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(12,'Idaho','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(13,'Illinois','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(14,'Indiana','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(15,'Iowa','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(16,'Kansas','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(17,'Kentucky','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(18,'Louisiana','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(19,'Maine','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(20,'Maryland','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(21,'Massachusetts','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(22,'Michigan','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(23,'Minnesota','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(24,'Mississippi','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(25,'Missouri','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(26,'Montana','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(27,'Nebraska','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(28,'Nevada','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(29,'New Hampshire','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(30,'New Jersey','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(31,'New Mexico','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(32,'New York','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(33,'North Carolina','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(34,'North Dakota','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(35,'Ohio','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(36,'Oklahoma','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(37,'Oregon','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(38,'Pennsylvania','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(39,'Rhode Island','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(40,'South Carolina','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(41,'South Dakota','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(42,'Tennessee','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(43,'Texas','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(44,'Utah','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(45,'Vermont','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(46,'Virginia','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(47,'Washington','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(48,'West Virginia','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(49,'Wisconsin','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'),(50,'Wyoming','1',NULL,'Active','2024-11-21 14:14:00','2024-11-21 14:14:00'); /*!40000 ALTER TABLE `states` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `system_settings` -- DROP TABLE IF EXISTS `system_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `system_settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `app_name` varchar(255) DEFAULT NULL, `app_url` varchar(255) DEFAULT NULL, `fav_icon` varchar(255) DEFAULT NULL, `copyright` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `portal_logo` varchar(255) DEFAULT NULL, `email_logo` varchar(255) DEFAULT NULL, `auth_logo` varchar(255) DEFAULT NULL, `dev_name` varchar(255) DEFAULT NULL, `dev_link` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `system_settings` -- LOCK TABLES `system_settings` WRITE; /*!40000 ALTER TABLE `system_settings` DISABLE KEYS */; INSERT INTO `system_settings` VALUES (1,'Arias Communication Services',NULL,'fav/1732201425_Arisas-Communication-Services-1.png','© 2024 Arias Communication Services','contactus@acssplice.com','(918) 286-8349','2801 E Kenosha Street, Unit 140321, Broken Arrow, Ok 74014','logo/1732200611_Arisas-Communication-Services-1.png','logo/1732200590_Arisas-Communication-Services-1.png','logo/1732201425_Arisas-Communication-Services-1.png','Designs Funnel LLC','https://designsfunnel.com',NULL,NULL,'1','2024-11-21 14:14:00','2024-11-21 15:23:32'); /*!40000 ALTER TABLE `system_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `date_of_birth` varchar(255) DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `zip` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `timezone` varchar(255) DEFAULT NULL, `img` varchar(255) DEFAULT NULL, `user_type` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `publish_status` varchar(255) NOT NULL DEFAULT '0', `payment_status` varchar(255) NOT NULL DEFAULT '0', `stripe_id` varchar(255) DEFAULT NULL, `subscription_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `verification_token` varchar(255) DEFAULT NULL, `remember_token` varchar(100) 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Super','Admin','designsfunnel@gmail.com','2024-11-21 14:13:59','$2y$12$PYv6qq4k1fAIyj9z2mnO0.oYaPfxKrifngGfFxjrc/6UKw07Ii2C.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MST',NULL,'0','1','0','0',NULL,NULL,NULL,'$2y$12$GzTE.1HF.QTDt3mJDdGVP.QiUDkeVaRY63GhSMzhwGc.tZMr5.BBq','r1KHYnLtnackb15TBQRz9fC7X59PrMB7tc3AzUrry2HARuYKlfvp8vtJvZZf',NULL,'2024-11-25 19:51:47'),(2,'Jeff','Williams','jeff@designsfunnel.com','2024-11-21 15:27:59','$2y$12$GJ3IEtx5tKX.1pyLtAU/RegZQVCVSV/YjGDvq/hhUreyTJcRsIBBW',NULL,'Male',NULL,NULL,NULL,NULL,NULL,'EST',NULL,'1','1','0','0',NULL,NULL,NULL,'$2y$12$TLO0i5WNSJidEvVL0SXND.IdaBTrGCICz0qYtEg60Zyp88WE2e8o2','mFm01CM5aNCMo4SJ0Zksljz6jmDCFzJxIVTJdCjNdLGusUR0qFGfUa1JrU5y',NULL,'2024-11-25 19:54:40'),(3,'Ashley','Miles','ashley@designsfunnel.com','2024-11-21 18:55:12','$2y$12$mTQfOs21dJzwwiRZjKGUJ.9rdufH3Mr44PAfBDoWuQXoTZv.Vcw7u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MST','upload/1732556555.jpg','2','1','0','0',NULL,NULL,NULL,NULL,'4M4ptmZUtOrlJybLkbLI3Jo1gsRoVU1iwx8qMXw67YjxDt5XsuzsQTB7MweF','2024-11-21 18:55:12','2024-11-25 19:57:08'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-06-18 21:44:23