Dear [name],
The subscription has been successfully created. Below are the plan details.
','2024-09-26 17:56:31','2024-09-26 17:56:31'),(2,'emails.subscriptioncancled','Designs Funnel LLC Subscription Canceled','
Dear [name],
Your Charm subscription has been canceled. These are the details of your plan cancellation.
','2024-09-26 17:56:31','2024-09-26 17:56:31'),(3,'emails.activation','You are Designs Funnel LLC Verified!','Dear [name],
Congratulations on becoming Designs Funnel LLC Verified!
','2024-09-26 17:56:31','2024-09-26 17:56:31'); /*!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 `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=53 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 (40,'2014_10_12_000000_create_users_table',1),(41,'2014_10_12_100000_create_password_reset_tokens_table',1),(42,'2014_10_12_100000_create_password_resets_table',1),(43,'2019_08_19_000000_create_failed_jobs_table',1),(44,'2019_12_14_000001_create_personal_access_tokens_table',1),(45,'2024_06_06_140353_create_roles_table',1),(46,'2024_06_06_140425_create_permissions_table',1),(47,'2024_06_06_140448_create_role_permissions_table',1),(48,'2024_06_21_133502_create_email_templates_table',1),(49,'2024_06_28_151139_create_cities_table',1),(50,'2024_07_05_180355_create_states_table',1),(51,'2024_09_25_112814_create_vcards_table',1),(52,'2024_09_25_113100_create_u_r_l_s_table',1); /*!40000 ALTER TABLE `migrations` 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=34 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-09-26 17:56:30','2024-09-26 17:56:30',NULL),(2,'read-user','Read User','User Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(3,'update-user','Update User','User Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(4,'delete-user','Delete User','User Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(5,'create-role','Create Role','Role Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(6,'read-role','Read Role','Role Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(7,'update-role','Update Role','Role Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(8,'delete-role','Delete Role','Role Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(9,'create-email-template','Create Email Template','Email Template Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(10,'read-email-template','Read Email Template','Email Template Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(11,'update-email-template','Update Email Template','Email Template Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(12,'delete-email-template','Delete Email Template','Email Template Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(13,'create-state','Create State','State Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(14,'read-state','Read State','State Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(15,'update-state','Update State','State Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(16,'delete-state','Delete State','State Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(17,'create-vcard','Create Vcard','Vcard Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(18,'read-vcard','Read Vcard','Vcard Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(19,'update-vcard','Update Vcard','Vcard Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(20,'delete-vcard','Delete Vcard','Vcard Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(21,'create-quiq-vcard','Create Quiq Vcard','Vcard Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(22,'read-quiq-vcard','Read Quiq Vcard','Vcard Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(23,'update-quiq-vcard','Update Quiq Vcard','Vcard Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(24,'delete-quiq-vcard','Delete Quiq Vcard','Vcard Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(25,'create-URL','Create URL','URL Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(26,'read-URL','Read URL','URL Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(27,'update-URL','Update URL','URL Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(28,'delete-URL','Delete URL','URL Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(29,'create-quiq-URL','Create Quiq URL','URL Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(30,'read-quiq-URL','Read Quiq URL','URL Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(31,'update-quiq-URL','Update Quiq URL','URL Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(32,'delete-quiq-URL','Delete Quiq URL','URL Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL),(33,'read-profile','Read Profile','Profile Management','1',NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',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-09-26 17:56:30','2024-09-26 17:56:30',NULL),(2,'User',1,1,NULL,NULL,'2024-09-26 17:56:30','2024-09-26 17:56:30',NULL); /*!40000 ALTER TABLE `roles` 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-09-26 17:56:30','2024-09-26 17:56:30'),(2,'Alaska','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(3,'Arizona','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(4,'Arkansas','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(5,'California','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(6,'Colorado','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(7,'Connecticut','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(8,'Delaware','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(9,'Florida','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(10,'Georgia','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(11,'Hawaii','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(12,'Idaho','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(13,'Illinois','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(14,'Indiana','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(15,'Iowa','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(16,'Kansas','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(17,'Kentucky','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(18,'Louisiana','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(19,'Maine','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(20,'Maryland','1',NULL,'Active','2024-09-26 17:56:30','2024-09-26 17:56:30'),(21,'Massachusetts','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(22,'Michigan','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(23,'Minnesota','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(24,'Mississippi','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(25,'Missouri','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(26,'Montana','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(27,'Nebraska','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(28,'Nevada','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(29,'New Hampshire','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(30,'New Jersey','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(31,'New Mexico','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(32,'New York','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(33,'North Carolina','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(34,'North Dakota','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(35,'Ohio','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(36,'Oklahoma','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(37,'Oregon','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(38,'Pennsylvania','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(39,'Rhode Island','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(40,'South Carolina','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(41,'South Dakota','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(42,'Tennessee','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(43,'Texas','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(44,'Utah','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(45,'Vermont','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(46,'Virginia','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(47,'Washington','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(48,'West Virginia','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(49,'Wisconsin','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'),(50,'Wyoming','1',NULL,'Active','2024-09-26 17:56:31','2024-09-26 17:56:31'); /*!40000 ALTER TABLE `states` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `u_r_l_s` -- DROP TABLE IF EXISTS `u_r_l_s`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `u_r_l_s` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `URL` varchar(255) DEFAULT NULL, `code` varchar(255) DEFAULT NULL, `qr_code` 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=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `u_r_l_s` -- LOCK TABLES `u_r_l_s` WRITE; /*!40000 ALTER TABLE `u_r_l_s` DISABLE KEYS */; INSERT INTO `u_r_l_s` VALUES (2,'https://netshiftsolutions.com','20240930124032','qr-codes/URL-20240930124032.png','1','103.244.179.4','1','2024-09-30 12:40:32','2024-09-30 12:40:32'),(3,'https://ggo.com',NULL,'qr-codes/URL-20240930124137.png','1','103.244.179.4','1','2024-09-30 12:41:37','2024-09-30 12:41:37'),(4,'https://pcsoxford.co.uk/',NULL,'qr-codes/URL-20241017195153.png','1','103.244.179.4','1','2024-10-17 19:51:53','2024-10-17 19:51:53'),(6,'https://griffingriergroup.com/',NULL,'qr-codes/URL-20241021162336.png','1','103.244.179.4','1','2024-10-21 16:23:36','2024-10-21 16:23:36'),(7,'https://gatorfamilybusiness.com/','20241030143828','qr-codes/URL-20241030143828.png','1','103.244.179.4','1','2024-10-30 14:38:28','2024-10-30 14:38:28'),(9,'http://www.cobaltsec.com/',NULL,'qr-codes/URL-20241111111751.png','1','103.244.179.4','1','2024-11-11 11:17:51','2024-11-11 11:17:51'),(10,'https://www.netshiftsolutions.com',NULL,'qr-codes/URL-20250317125657.png','1','41.13.208.164','1','2025-03-17 12:56:56','2025-03-17 12:56:57'),(11,'https://netshiftsolutions.com/za/lets-discuss',NULL,'qr-codes/URL-20250322124442.png','1','41.13.204.212','1','2025-03-22 12:44:42','2025-03-22 12:44:42'),(12,'https://sparkspetroleum.designsfunnelserver.com/','20250530151153','qr-codes/URL-20250530151153.png','1','103.244.179.4','1','2025-05-30 15:11:53','2025-05-30 15:11:53'),(13,'https://sparkspetroleum.designsfunnelserver.com/dwc-candidate-simulator-feedback-final/','20250612171036','qr-codes/URL-20250612171036.png','1','103.244.179.4','1','2025-06-12 17:10:36','2025-06-12 17:10:36'),(14,'https://sparkspetroleum.designsfunnelserver.com/dwc-assessor-simulator-session/','20250612171109','qr-codes/URL-20250612171110.png','1','103.244.179.4','1','2025-06-12 17:11:09','2025-06-12 17:11:10'),(15,'https://sparkspetroleum.designsfunnelserver.com/dwc-wipc-classroom-instructor-feedback/','20250612171139','qr-codes/URL-20250612171139.png','1','103.244.179.4','1','2025-06-12 17:11:39','2025-06-12 17:11:39'); /*!40000 ALTER TABLE `u_r_l_s` 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-09-26 17:56:30','$2y$12$bTWOSIBQERSjkH0DLa1hfeKlQ9hoeMbzxp8jekEHpK/k.PiNrZwee',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0',NULL,NULL,NULL,NULL,'lqrf0R5AOZq8yladVNXPU1nGxYBueqrjtzX9teaZ4Dtd7FvmtXWdjpfWw4pp',NULL,NULL),(2,'Portal','Admin','admin@gmail.com','2024-09-26 17:56:30','$2y$12$IpEmYSvKlslihv.WQlojmOmcA1japump0gy/hSmoDnM5gfwb82z0K',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1','0','0',NULL,NULL,NULL,NULL,'hLGrjOTIb8',NULL,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vcards` -- DROP TABLE IF EXISTS `vcards`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `vcards` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `company` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `fax` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `job_detail` varchar(255) DEFAULT NULL, `street` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `zip` varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `country` varchar(255) DEFAULT NULL, `website` varchar(255) DEFAULT NULL, `code` varchar(255) DEFAULT NULL, `qr_code` 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=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vcards` -- LOCK TABLES `vcards` WRITE; /*!40000 ALTER TABLE `vcards` DISABLE KEYS */; INSERT INTO `vcards` VALUES (2,'s','d','d','f','s','f','s','d','d','s','s','d','f','d',NULL,'qr-codes/d','1','103.244.179.4','1','2024-09-30 12:37:21','2024-09-30 12:37:21'),(3,'Zoe','Cain','Britt Hayden Associates','Delectus dolores ip','+1 (404) 457-3362','+1 (642) 241-7616','mufoxyh@mailinator.com','Amet enim perspicia','Explicabo Cillum of','Officiis ratione eiu','93815','Quas reprehenderit','Magnam corporis dict','https://www.rar.org.au','20240930141020','qr-codes/Britt Hayden Associates','1','66.235.168.196','1','2024-09-30 14:10:20','2024-09-30 14:10:20'),(4,'Percy','Gorejena','Cobalt Security Limited','07393026903',NULL,NULL,'percygorejena@cobaltsec.com','Managing Director','10 Summercroft Close,','Golborne',NULL,'Warrington WA3 3WL','UK',NULL,'20241101183054','qr-codes/Cobalt Security Limited','1','156.146.47.3','1','2024-11-01 18:30:54','2024-11-01 18:33:09'),(7,'Garry','Noon',NULL,'078 0141 3861',NULL,NULL,'garrynoon@gmail.com','Managing Director','10 Summercroft Cl, Golborne, Warrington WA3 3WL',NULL,NULL,NULL,NULL,NULL,NULL,'qr-codes/URL-20241107192506.png','1','103.244.179.4','1','2024-11-07 19:25:06','2024-11-07 19:25:06'),(8,'Percy','Gorejena',NULL,'073 9302 6903',NULL,NULL,'percygorejena@gmail.com','Business Development Manager','10 Summercroft Cl, Golborne, Warrington WA3 3WL',NULL,NULL,NULL,NULL,NULL,NULL,'qr-codes/URL-20241107192623.png','1','103.244.179.4','1','2024-11-07 19:26:23','2024-11-07 19:26:23'),(9,'Garry','Noon','Cobaltsec','07801413861',NULL,NULL,'garrynoon@cobaltsec.com','Managing Director','10 Summercroft Cl','Golborne,Warrington',NULL,NULL,'WA3 3WL',NULL,NULL,'qr-codes/Cobaltsec','1','103.244.179.4','1','2025-01-13 14:40:10','2025-01-13 14:40:10'),(10,'Hamza','Masood','Net Shift Solutions','064 895 8607',NULL,NULL,'hamza@netshiftsolutions.com','Managing Director',NULL,NULL,NULL,NULL,NULL,'www.netshiftsolutions.com',NULL,'qr-codes/Net Shift Solutions','1','111.88.58.151','1','2025-03-05 19:25:00','2025-03-05 19:25:00'),(11,'Hamza','Masood','Net Shift Solutions','064 895 8607',NULL,NULL,'hamza@NetShiftSolutions.com','Director',NULL,'Cape Town',NULL,'Western Cape','South Africa','www.NetShiftSolutions.com',NULL,'qr-codes/Net Shift Solutions','1','41.13.208.164','1','2025-03-17 12:31:39','2025-03-17 12:31:39'); /*!40000 ALTER TABLE `vcards` 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