Hello [name],
It looks like you requested to reset your password. Click the button below to proceed.
',1,'2024-11-15 12:52:40','2024-11-15 12:52:40'),(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-15 12:52:40','2024-11-15 12:52:40'); /*!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=75 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 (59,'2014_10_12_000000_create_users_table',1),(60,'2014_10_12_100000_create_password_reset_tokens_table',1),(61,'2014_10_12_100000_create_password_resets_table',1),(62,'2019_08_19_000000_create_failed_jobs_table',1),(63,'2019_12_14_000001_create_personal_access_tokens_table',1),(64,'2024_06_06_140353_create_roles_table',1),(65,'2024_06_06_140425_create_permissions_table',1),(66,'2024_06_06_140448_create_role_permissions_table',1),(67,'2024_06_21_133502_create_email_templates_table',1),(68,'2024_06_28_151139_create_cities_table',1),(69,'2024_07_05_180355_create_states_table',1),(70,'2024_10_04_194658_create_newsletters_table',1),(71,'2024_10_07_180841_create_jobs_table',1),(72,'2024_10_07_183753_create_system_settings_table',1),(73,'2024_10_07_184808_create_smtp_settings_table',1),(74,'2024_11_12_122322_create_color_settings_table',1); /*!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=38 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-15 12:52:39','2024-11-15 12:52:39',NULL),(2,'read-user','Read User','User Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(3,'update-user','Update User','User Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(4,'delete-user','Delete User','User Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(5,'create-role','Create Role','Role Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(6,'read-role','Read Role','Role Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(7,'update-role','Update Role','Role Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(8,'delete-role','Delete Role','Role Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(9,'create-email-template','Create Email Template','Email Template Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(10,'read-email-template','Read Email Template','Email Template Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(11,'update-email-template','Update Email Template','Email Template Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(12,'delete-email-template','Delete Email Template','Email Template Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(13,'sent-email','Sent Email','Email Template Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(14,'create-state','Create State','State Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(15,'read-state','Read State','State Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(16,'update-state','Update State','State Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(17,'delete-state','Delete State','State Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(18,'create-vcard','Create Vcard','Vcard Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(19,'read-vcard','Read Vcard','Vcard Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(20,'update-vcard','Update Vcard','Vcard Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(21,'delete-vcard','Delete Vcard','Vcard Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(22,'create-quiq-vcard','Create Quiq Vcard','Vcard Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(23,'read-quiq-vcard','Read Quiq Vcard','Vcard Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(24,'update-quiq-vcard','Update Quiq Vcard','Vcard Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(25,'delete-quiq-vcard','Delete Quiq Vcard','Vcard Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(26,'create-URL','Create URL','URL Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(27,'read-URL','Read URL','URL Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(28,'update-URL','Update URL','URL Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(29,'delete-URL','Delete URL','URL Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(30,'create-quiq-URL','Create Quiq URL','URL Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(31,'read-quiq-URL','Read Quiq URL','URL Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(32,'update-quiq-URL','Update Quiq URL','URL Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(33,'delete-quiq-URL','Delete Quiq URL','URL Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(34,'read-profile','Read Profile','Profile Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(35,'read-setting','Read Setting','Setting Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(36,'update-setting','Update Setting','Setting Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',NULL),(37,'create-setting','Create Setting','Setting Management','1',NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',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-11-15 12:52:39','2024-11-15 12:52:39',NULL),(2,'User',1,1,NULL,NULL,'2024-11-15 12:52:39','2024-11-15 12:52:39',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-11-15 12:52:40','2024-11-15 12:52:40'),(2,'Alaska','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(3,'Arizona','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(4,'Arkansas','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(5,'California','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(6,'Colorado','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(7,'Connecticut','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(8,'Delaware','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(9,'Florida','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(10,'Georgia','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(11,'Hawaii','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(12,'Idaho','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(13,'Illinois','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(14,'Indiana','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(15,'Iowa','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(16,'Kansas','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(17,'Kentucky','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(18,'Louisiana','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(19,'Maine','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(20,'Maryland','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(21,'Massachusetts','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(22,'Michigan','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(23,'Minnesota','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(24,'Mississippi','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(25,'Missouri','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(26,'Montana','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(27,'Nebraska','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(28,'Nevada','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(29,'New Hampshire','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(30,'New Jersey','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(31,'New Mexico','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(32,'New York','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(33,'North Carolina','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(34,'North Dakota','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(35,'Ohio','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(36,'Oklahoma','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(37,'Oregon','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(38,'Pennsylvania','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(39,'Rhode Island','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(40,'South Carolina','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(41,'South Dakota','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(42,'Tennessee','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(43,'Texas','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(44,'Utah','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(45,'Vermont','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(46,'Virginia','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(47,'Washington','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(48,'West Virginia','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(49,'Wisconsin','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'),(50,'Wyoming','1',NULL,'Active','2024-11-15 12:52:40','2024-11-15 12:52:40'); /*!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-11-15 12:52:40','2024-11-15 12:52:40'); /*!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-11-15 12:52:39','$2y$12$R1shfLPW/LUqZ2cjiagCCOqTiFI.7C4.4RXl4FA6/hXyJ/062JiES',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0',NULL,NULL,NULL,'$2y$12$IXPlEHEg1FYYC4Kc042ui.aok0.QcgH23KJ6b0jtGf/APO.liRx/S','sZj8u31TvTRl9buoBf3RsHXAX62gZwOP4e634NUEcBt77l4rjh4mvq6TtOrs',NULL,'2024-11-18 13:50:00'),(2,'Portal','Admin','admin@gmail.com','2024-11-15 12:52:40','$2y$12$XJrPJUUFml6zMu1GyIaireHVIOdVrsaS6SYJA3uYaelevm1QGnrfK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1','0','0',NULL,NULL,NULL,NULL,'ZMdTuMGb31',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:51