Hello [name],
It looks like you requested to reset your password. Click the button below to proceed.
',1,'2024-12-06 19:34:23','2024-12-06 19:34:23'),(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-12-06 19:34:23','2024-12-06 19:34:23'); /*!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=36 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 (18,'2014_10_12_000000_create_users_table',1),(19,'2014_10_12_100000_create_password_reset_tokens_table',1),(20,'2014_10_12_100000_create_password_resets_table',1),(21,'2019_08_19_000000_create_failed_jobs_table',1),(22,'2019_12_14_000001_create_personal_access_tokens_table',1),(23,'2024_06_06_140353_create_roles_table',1),(24,'2024_06_06_140425_create_permissions_table',1),(25,'2024_06_06_140448_create_role_permissions_table',1),(26,'2024_06_21_133502_create_email_templates_table',1),(27,'2024_06_28_151139_create_cities_table',1),(28,'2024_07_05_180355_create_states_table',1),(29,'2024_10_04_194658_create_newsletters_table',1),(30,'2024_10_07_180841_create_jobs_table',1),(31,'2024_10_07_183753_create_system_settings_table',1),(32,'2024_10_07_184808_create_smtp_settings_table',1),(33,'2024_11_12_122322_create_color_settings_table',1),(34,'2024_11_20_181027_create_attendances_table',1),(35,'2024_12_06_141500_create_mockups_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mockups` -- DROP TABLE IF EXISTS `mockups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mockups` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `description` longtext DEFAULT NULL, `link` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT '1', `user_id` varchar(255) DEFAULT NULL, `user_ip` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mockups` -- LOCK TABLES `mockups` WRITE; /*!40000 ALTER TABLE `mockups` DISABLE KEYS */; INSERT INTO `mockups` VALUES (3,'Michael Heinrichs','
New Landing Page
','mockup/1735835991.jpg','Active','1','103.244.179.4','2024-12-16 20:28:36','2025-01-02 16:39:51'),(4,'Nasri Barghouti - Vistacoll','New Landing Page Design
','mockup/1734465024.jpg','Active','1','103.244.179.4','2024-12-17 19:50:24','2024-12-17 19:50:24'),(5,'Nasri Liver Pool Colleges','New layout design
','mockup/1734533990.png','Active','1','103.244.179.4','2024-12-18 14:59:50','2024-12-18 14:59:50'),(6,'Farooq Ahmed - Four in a Row Ltd','new layout design attach
','mockup/1734642051.png','Active','1','103.244.179.4','2024-12-19 21:00:51','2024-12-19 21:00:51'),(7,'KD Publishing Agency','New Landing Page Design
','mockup/1735826683.jpg','Active','1','103.244.179.4','2025-01-02 13:53:44','2025-01-02 14:04:43'),(8,'John Fore | Pig Sticker','Coming Soon Page
','mockup/1745526221.png','Active','1','103.244.179.4','2025-01-03 15:58:20','2025-04-24 20:23:41'),(9,'Walter - Suffolk Serenity Living Limited','new layout design
','mockup/1736274076.jpg','Active','1','39.51.27.65','2025-01-07 18:21:16','2025-01-09 14:30:49'),(10,'Walter - Total Care Advisory','new layout design
','mockup/1736440299.png','Active','1','103.244.179.4','2025-01-09 16:31:39','2025-01-09 16:31:39'),(11,'Walter - Total Care Advisory 2','new layout
','mockup/1736440626.png','Active','1','103.244.179.4','2025-01-09 16:37:06','2025-01-09 16:37:06'),(12,'Ian Gracias - Ian Gracias Pianos','new layout design
','mockup/1738601839.jpg','Active','1','103.244.179.4','2025-01-29 19:01:59','2025-02-03 16:57:20'),(13,'Chris','new layout design
','mockup/1738608844.png','Active','1','103.244.179.4','2025-02-03 18:54:04','2025-02-03 19:00:10'),(14,'Angel Bojanovich','new layout design
','mockup/1739300610.png','Active','1','103.244.179.4','2025-02-11 19:03:30','2025-02-11 19:03:30'),(15,'Angel Bojanovich 2','new layout
','mockup/1739390292.png','Active','1','103.244.179.4','2025-02-11 19:08:50','2025-02-12 19:58:13'),(16,'Sophia Fisher - Inference LLC','new layout design
','mockup/1739472443.jpg','Active','1','103.244.179.4','2025-02-12 17:42:15','2025-02-13 18:47:23'),(17,'Angel Bojanovich New','new layout done
','mockup/1739390352.jpg','Active','1','103.244.179.4','2025-02-12 19:59:12','2025-02-12 19:59:12'),(18,'Jay Eiland - Bird Dawg','new layout design
','mockup/1739557054.jpg','Active','1','103.244.179.4','2025-02-14 18:17:34','2025-02-14 18:17:34'),(19,'Angel Bojanovich new 2','new layout design
','mockup/1740158952.jpg','Active','1','103.244.179.4','2025-02-18 17:31:21','2025-02-21 17:29:12'),(20,'Timothy Hamilton - Creative Financing','new layout design
','mockup/1740160812.jpg','Active','1','103.244.179.4','2025-02-21 17:22:05','2025-02-21 18:00:12'),(21,'Angel Bojanovich - kawsita new','new layout design
','mockup/1740419228.jpg','Active','1','103.244.179.4','2025-02-24 17:43:10','2025-02-24 17:47:08'),(22,'Latasha Quick Shuttle Service','new layout design
','mockup/1740511130.jpg','Active','1','103.244.179.4','2025-02-25 18:25:30','2025-02-25 19:18:50'),(23,'Timothy Hamilton - Creative Financing new','new layout design
','mockup/1740512132.jpg','Active','1','103.244.179.4','2025-02-25 19:35:32','2025-02-25 19:35:32'),(24,'Shivani Garret Rhea - Zenadigm Wellness','new layout design
','mockup/1740684274.jpg','Active','1','103.244.179.4','2025-02-27 19:24:34','2025-02-27 19:24:34'),(25,'Courtney Poole Jim Poole Memorial Golf Tournament','inner page design
','mockup/1741023616.jpg','Active','1','111.88.56.122','2025-03-03 17:40:16','2025-03-03 17:40:16'),(26,'Jim Poole','Courtney Poole Jim Poole Memorial Golf Tournament
','mockup/1741023681.jpg','Active','1','103.244.179.4','2025-03-03 17:41:21','2025-03-03 17:41:21'),(27,'Goodwin Barrymore Atlas Claims','new layout design
','mockup/1741198376.jpg','Active','1','111.88.58.151','2025-03-05 18:12:56','2025-03-05 18:12:56'),(28,'Angel Bojanovich - kawsita MK01','new layout design
','mockup/1741202422.jpg','Active','1','111.88.58.151','2025-03-05 19:20:22','2025-03-05 19:20:22'),(29,'Angel Bojanovich - kawsita MK 02','new layout design
','mockup/1741202459.jpg','Active','1','111.88.58.151','2025-03-05 19:20:59','2025-03-05 19:20:59'),(30,'Angel Bojanovich - kawsita Mk 03','new layout design
','mockup/1741205503.jpg','Active','1','111.88.56.175','2025-03-05 20:11:43','2025-03-05 20:11:43'),(31,'Angel Bojanovich - kawsita MK 04','new layout design
','mockup/1741282055.jpg','Active','1','111.88.61.39','2025-03-05 20:13:46','2025-03-06 17:27:35'),(32,'Murphy Orji','new layout design done
','mockup/1741804032.jpg','Active','1','111.88.60.38','2025-03-10 19:25:24','2025-03-12 18:27:12'),(33,'Linda','new layout design done
','mockup/1741636898.jpg','Active','1','111.88.63.7','2025-03-10 20:01:38','2025-03-10 20:01:38'),(34,'Faris FayCurry Sault West','new layout design
','mockup/1741720550.jpg','Active','1','111.88.58.103','2025-03-11 19:14:52','2025-03-11 19:15:50'),(35,'Murphy Orji Govsur plus online Services','inner page design
','mockup/1741978946.jpg','Active','1','111.88.63.244','2025-03-14 19:02:26','2025-03-14 19:02:26'),(36,'Murphy Orji Govsur plus online About us','inner page design
','mockup/1741978980.jpg','Active','1','111.88.63.244','2025-03-14 19:03:00','2025-03-14 19:03:00'),(37,'Murphy Orji Govsur plus online Portfolio','inner page design done
','mockup/1741979058.jpg','Active','1','111.88.63.244','2025-03-14 19:04:18','2025-03-14 19:04:18'),(38,'Murphy Orji Govsur plus online Contact us','inner page design done
','mockup/1741979105.jpg','Active','1','111.88.63.244','2025-03-14 19:05:05','2025-03-14 19:05:05'),(39,'Faris FayCurry Sault West new','new layout design
','mockup/1744307041.jpg','Active','1','103.244.179.4','2025-03-17 18:28:22','2025-04-10 17:44:01'),(40,'Bhoopal Reddy Retail Sols Inc','new layout design done
','mockup/1742843200.jpg','Active','1','103.244.179.4','2025-03-24 17:52:06','2025-03-24 19:06:40'),(41,'DOUGLAS MENSAH HOME CONNEXSIONS INTERNATIONAL','new layout design done
','mockup/1742843089.jpg','Active','1','103.244.179.4','2025-03-24 19:04:49','2025-03-24 19:04:49'),(42,'Aderajew Hailu Walia Charity Association','new layout design
','mockup/1744217105.jpg','Active','1','103.244.179.4','2025-04-03 18:06:13','2025-04-09 16:45:05'),(43,'DeLisa Glaspie Seize The Smoke','new landing page done
','mockup/1744139622.jpg','Active','1','103.244.179.4','2025-04-08 19:13:42','2025-04-08 19:13:42'),(44,'Sonya Rondon Garden Home Care','new layout design done
','mockup/1744224453.jpg','Active','1','103.244.179.4','2025-04-09 18:47:33','2025-04-09 18:47:33'),(45,'Sonya Rondon Garden Home Care 2','new layout 2
','mockup/1744309932.jpg','Active','1','103.244.179.4','2025-04-10 18:32:12','2025-04-10 18:32:12'),(46,'Donald Gray Gray Protective Services','new layout design done
','mockup/1744397668.jpg','Active','1','103.244.179.4','2025-04-11 18:54:28','2025-04-11 18:54:28'),(47,'Sonya Rondon Garden Home Care 3','Layout revision 3','mockup/1745620065.png','Active','1','103.244.179.4','2025-04-15 23:31:01','2025-04-25 22:27:45'),(48,'Mikevgolf','v1
','mockup/1744925700.png','Active','1','103.244.179.4','2025-04-17 21:35:00','2025-04-17 21:35:00'),(49,'Sonya Rondon Garden Home Care v3','V3
','mockup/1745621139.png','Active','1','103.244.179.4','2025-04-25 22:45:39','2025-04-25 22:45:39'),(50,'John Stofer v1','New layout V1
','mockup/1746053940.png','Active','1','103.244.179.4','2025-04-30 22:06:29','2025-04-30 22:59:00'),(51,'John Stofer v2','v2
','mockup/1746121002.png','Active','1','103.244.179.4','2025-05-01 17:36:42','2025-05-01 17:36:42'),(52,'Joseph K. Manning','v1 layout
','mockup/1746566788.png','Active','1','103.244.179.4','2025-05-06 21:26:28','2025-05-06 21:26:28'),(53,'James Lines','v1 layout
','mockup/1746653750.png','Active','1','103.244.179.4','2025-05-07 21:35:50','2025-05-07 21:35:50'),(54,'James Lines v2','initial layout v2
','mockup/1746825575.png','Active','1','103.244.179.4','2025-05-09 21:19:35','2025-05-09 21:19:35'),(55,'Daniel Keith West','initial layout v1
','mockup/1747158908.png','Active','1','103.244.179.4','2025-05-12 18:00:33','2025-05-13 17:55:08'),(56,'Milot Odne','initial layout v1
','mockup/1747150353.png','Active','1','103.244.179.4','2025-05-13 15:32:33','2025-05-13 15:32:33'),(57,'John Swahn','inatial layout v1
','mockup/1747681958.png','Active','1','103.244.179.4','2025-05-19 19:12:38','2025-05-19 19:12:38'),(58,'Bill Tudor','inatial layout v1
','mockup/1747859859.png','Active','1','103.244.179.4','2025-05-21 20:37:39','2025-05-21 20:37:39'),(59,'Komal Ahmed','inatial layout V1
','mockup/1747946497.png','Active','1','103.244.179.4','2025-05-22 20:41:37','2025-05-22 20:41:37'),(60,'Alisa Sanders Tabitha Nahabedian','V1 inatial layout
','mockup/1748291975.png','Active','1','103.244.179.4','2025-05-26 20:39:35','2025-05-26 20:39:35'),(61,'Courtney Poole Jim','innerpage
','mockup/1749138217.png','Active','1','103.244.177.79','2025-06-05 15:43:37','2025-06-05 15:43:37'),(62,'Cassandra Wright - Landing Page','landing page
','mockup/1749820125.png','Active','1','103.244.179.4','2025-06-10 23:34:09','2025-06-13 13:08:45'),(63,'Usama Syed Think Teq Solutions','inatioal layout v1
','mockup/1750103249.png','Active','1','103.244.179.4','2025-06-16 19:47:29','2025-06-16 19:47:29'),(65,'Cassandra Wright - Landing Page v2','Landing Page v2
','mockup/1750174746.png','Active','1','103.244.179.4','2025-06-17 14:54:19','2025-06-17 15:39:06'),(66,'Usama Syed Think Teq Solutions Shop','v2 Shop
','mockup/1750178908.png','Active','1','103.244.179.4','2025-06-17 16:48:28','2025-06-17 16:48:28'),(67,'Usama Syed Think Teq Solutions Repairing','V2 Reapring
','mockup/1750180391.png','Active','1','103.244.179.4','2025-06-17 17:13:11','2025-06-17 17:13:11'),(68,'Cherie Ann Blackburn','inatial layout V1
','mockup/1750265053.png','Active','1','117.120.9.29','2025-06-18 16:42:16','2025-06-18 16:44:13'); /*!40000 ALTER TABLE `mockups` 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-12-06 19:34:22','2024-12-06 19:34:22',NULL),(2,'read-user','Read User','User Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(3,'update-user','Update User','User Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(4,'delete-user','Delete User','User Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(5,'create-role','Create Role','Role Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(6,'read-role','Read Role','Role Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(7,'update-role','Update Role','Role Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(8,'delete-role','Delete Role','Role Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(9,'create-email-template','Create Email Template','Email Template Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(10,'read-email-template','Read Email Template','Email Template Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(11,'update-email-template','Update Email Template','Email Template Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(12,'delete-email-template','Delete Email Template','Email Template Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(13,'sent-email','Sent Email','Email Template Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(14,'create-state','Create State','State Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(15,'read-state','Read State','State Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(16,'update-state','Update State','State Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(17,'delete-state','Delete State','State Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(18,'read-profile','Read Profile','Profile Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(19,'read-setting','Read Setting','Setting Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(20,'update-setting','Update Setting','Setting Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(21,'create-setting','Create Setting','Setting Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(22,'create-attendance','Create Attendance','Attendance Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(23,'read-attendance','Read Attendance','Attendance Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(24,'update-attendance','Update Attendance','Attendance Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(25,'delete-attendance','Delete Attendance','Attendance Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(26,'create-mockup','Create Mockup','Mockup Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(27,'read-mockup','Read Mockup','Mockup Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(28,'update-mockup','Update Mockup','Mockup Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',NULL),(29,'delete-mockup','Delete Mockup','Mockup Management','1',NULL,NULL,'2024-12-06 19:34:22','2024-12-06 19:34:22',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 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 */; /*!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-12-06 19:34:22','2024-12-06 19:34:22',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 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 */; /*!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-12-06 19:34:22','2024-12-06 19:34:22'),(2,'Alaska','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(3,'Arizona','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(4,'Arkansas','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(5,'California','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(6,'Colorado','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(7,'Connecticut','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(8,'Delaware','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(9,'Florida','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(10,'Georgia','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(11,'Hawaii','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(12,'Idaho','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(13,'Illinois','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(14,'Indiana','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(15,'Iowa','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(16,'Kansas','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(17,'Kentucky','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(18,'Louisiana','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(19,'Maine','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(20,'Maryland','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(21,'Massachusetts','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(22,'Michigan','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(23,'Minnesota','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(24,'Mississippi','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(25,'Missouri','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(26,'Montana','1',NULL,'Active','2024-12-06 19:34:22','2024-12-06 19:34:22'),(27,'Nebraska','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(28,'Nevada','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(29,'New Hampshire','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(30,'New Jersey','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(31,'New Mexico','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(32,'New York','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(33,'North Carolina','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(34,'North Dakota','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(35,'Ohio','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(36,'Oklahoma','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(37,'Oregon','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(38,'Pennsylvania','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(39,'Rhode Island','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(40,'South Carolina','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(41,'South Dakota','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(42,'Tennessee','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(43,'Texas','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(44,'Utah','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(45,'Vermont','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(46,'Virginia','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(47,'Washington','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(48,'West Virginia','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(49,'Wisconsin','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'),(50,'Wyoming','1',NULL,'Active','2024-12-06 19:34:23','2024-12-06 19:34:23'); /*!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,'Designs Funnel LLC',NULL,'logo_black.png','© 2024 Designs Funnel LLC','designsfunnel@gmail.com',NULL,NULL,'logo-white.png','logo_black.png','logo_black.png','Design & Develop by Designs Funnel','https://designsfunnel.com/',NULL,NULL,'1','2024-12-06 19:34:23','2024-12-06 19:34:23'); /*!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=3 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-12-06 19:34:22','$2y$12$7oE5SZMTdOkTLgXXl3xDfO3KU334DDgR8PrnEWWQ9r5b6e7TW6Do2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0',NULL,NULL,NULL,NULL,'D2NIfyE9xDi17Z68nF64DMBcyza7xKJ4QcDiGn60aanBIkOhB0hETzU7H24R',NULL,NULL),(2,'Portal','Admin','admin@gmail.com','2024-12-06 19:34:22','$2y$12$DqzZaD3o6ksbs6Q4fHh8quE3/nuubXsKZPP4o2ZJaEqRn88aeQ6mK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1','0','0',NULL,NULL,NULL,NULL,'NYY3Z0MMbP',NULL,NULL); /*!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:55:52