Warning: session_start(): Session cannot be started after headers have already been sent in /home/tvrreohg/public_html/manga.php on line 13
/*M!999999\- enable the sandbox mode */
-- MariaDB dump 10.19 Distrib 10.6.22-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: designsfunnel_charm
-- ------------------------------------------------------
-- Server version 10.6.22-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `availabilities`
--
DROP TABLE IF EXISTS `availabilities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `availabilities` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`day_start` varchar(255) DEFAULT NULL,
`day_end` varchar(255) DEFAULT NULL,
`time_start` varchar(255) DEFAULT NULL,
`time_end` 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `availabilities`
--
LOCK TABLES `availabilities` WRITE;
/*!40000 ALTER TABLE `availabilities` DISABLE KEYS */;
INSERT INTO `availabilities` VALUES (1,'Monday','Sunday','00:15','02:15','3','45.39.33.202','1','2024-08-28 13:15:50','2024-08-28 13:15:50'),(2,'Thursday','Sunday','09:19','01:15','3','45.39.33.202','1','2024-08-28 13:15:50','2024-08-28 13:15:50');
/*!40000 ALTER TABLE `availabilities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `biographies`
--
DROP TABLE IF EXISTS `biographies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `biographies` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`image` varchar(255) DEFAULT NULL,
`professional_statement` longtext DEFAULT NULL,
`primary_language` longtext DEFAULT NULL,
`facebook` varchar(255) DEFAULT NULL,
`twitter` varchar(255) DEFAULT NULL,
`linkedIn` varchar(255) DEFAULT NULL,
`instagram` varchar(255) DEFAULT NULL,
`youtube` 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 `biographies`
--
LOCK TABLES `biographies` WRITE;
/*!40000 ALTER TABLE `biographies` DISABLE KEYS */;
INSERT INTO `biographies` VALUES (1,NULL,'In publishing and graphic design, Lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document or a typeface without relying on meaningful content. Lorem ipsum may be used as a placeholder before the final copy is av','a:1:{i:0;s:7:\"English\";}',NULL,NULL,NULL,NULL,NULL,'3','45.39.33.202','1','2024-08-28 13:14:47','2024-08-28 13:14:47');
/*!40000 ALTER TABLE `biographies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `blogs`
--
DROP TABLE IF EXISTS `blogs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `blogs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`img` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`description` longtext 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 `blogs`
--
LOCK TABLES `blogs` WRITE;
/*!40000 ALTER TABLE `blogs` DISABLE KEYS */;
/*!40000 ALTER TABLE `blogs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `certifications`
--
DROP TABLE IF EXISTS `certifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `certifications` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`certificate_number` varchar(255) DEFAULT NULL,
`gov_body` varchar(255) DEFAULT NULL,
`expiration` 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=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `certifications`
--
LOCK TABLES `certifications` WRITE;
/*!40000 ALTER TABLE `certifications` DISABLE KEYS */;
INSERT INTO `certifications` VALUES (3,'Cosmetology License','123-123','VA','2024-08-30','3','45.39.33.202','1','2024-08-28 13:13:43','2024-08-28 13:13:43'),(8,'Esthetician License','sssssss','ssss','2024-08-30','1','154.198.124.239','1','2024-08-28 15:00:45','2024-08-28 15:00:45');
/*!40000 ALTER TABLE `certifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cities`
--
DROP TABLE IF EXISTS `cities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cities` (
`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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cities`
--
LOCK TABLES `cities` WRITE;
/*!40000 ALTER TABLE `cities` DISABLE KEYS */;
/*!40000 ALTER TABLE `cities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contact_forms`
--
DROP TABLE IF EXISTS `contact_forms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact_forms` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`number` varchar(255) DEFAULT NULL,
`message` longtext 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 `contact_forms`
--
LOCK TABLES `contact_forms` WRITE;
/*!40000 ALTER TABLE `contact_forms` DISABLE KEYS */;
INSERT INTO `contact_forms` VALUES (1,'Dillon Page','bytoqyfe@mailinator.com','454','Dolor mollit atque e',NULL,'103.244.179.4','1','2024-08-13 20:11:42','2024-08-13 20:11:42');
/*!40000 ALTER TABLE `contact_forms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `documents`
--
DROP TABLE IF EXISTS `documents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `documents` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`expiration` varchar(255) DEFAULT NULL,
`state_gov_body` varchar(255) DEFAULT NULL,
`image` 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `documents`
--
LOCK TABLES `documents` WRITE;
/*!40000 ALTER TABLE `documents` DISABLE KEYS */;
INSERT INTO `documents` VALUES (1,'License','2024-08-30','Va','document/1724851158_sample.pdf','3','45.39.33.202','Awaiting admin approval','2024-08-28 13:19:18','2024-08-28 13:19:18'),(2,'Certificate','2024-09-06','VA','document/1724851158_sample.pdf','3','45.39.33.202','Awaiting admin approval','2024-08-28 13:19:18','2024-08-28 13:19:18');
/*!40000 ALTER TABLE `documents` 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,
`identifier` varchar(255) NOT NULL,
`subject` text NOT NULL,
`content` longtext NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 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,'emails.payment','Subscription Purchase Confirmation','Hello [name],
Thank you for subscribing to our plan! We’re excited to have you on board.
Your subscription has been successfully activated, and your profile can now be reviewed and published on our website.
If you have any questions or need assistance, feel free to contact our support team.
Your subscription details:
','2024-08-28 19:55:35','2024-08-28 18:24:09'),(2,'emails.subscriptioncancled','Subscription Cancellation Confirmation','Hello [name],
We’re sorry to see you go! Your subscription plan has been successfully cancelled.
You will still have access to your account, but your profile will be unpublished soon. If you change your mind, you can always reactivate your subscription by logging into your account.
Your subscription details:
','2024-08-28 19:55:35','2024-08-28 18:24:28'),(3,'emails.activation','Your Profile on The Charm Website is Now Live!','Dear [name],
Great news! Your profile on on The Charm Website has been successfully published and is now live.
If you need to make any updates or changes, you can easily do so by logging into your account.
Thank you for being a part of our community. We wish you great success!
','2024-08-28 19:55:35','2024-08-28 18:15:34'),(4,'emails.decline','Important: Your Profile on The Charm Website Has Been Unpublished','Hello [name],
We wanted to inform you that your profile on The Charm Website is unpublished due to the following reason. Please address the issue and make the necessary updates. Once resolved, you can request to have your profile republished.
','2024-08-28 19:55:35','2024-08-28 18:17:22');
/*!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 `finances`
--
DROP TABLE IF EXISTS `finances`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `finances` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`fee_from` varchar(255) DEFAULT NULL,
`fee_to` varchar(255) DEFAULT NULL,
`payment_method` 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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `finances`
--
LOCK TABLES `finances` WRITE;
/*!40000 ALTER TABLE `finances` DISABLE KEYS */;
INSERT INTO `finances` VALUES (5,NULL,NULL,'a:1:{i:0;s:5:\"Check\";}','3','103.244.179.4','1','2024-08-28 15:02:04','2024-08-28 15:02:04');
/*!40000 ALTER TABLE `finances` 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=187 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 (161,'2014_10_12_000000_create_users_table',1),(162,'2014_10_12_100000_create_password_reset_tokens_table',1),(163,'2014_10_12_100000_create_password_resets_table',1),(164,'2019_08_19_000000_create_failed_jobs_table',1),(165,'2019_12_14_000001_create_personal_access_tokens_table',1),(166,'2024_06_06_140353_create_roles_table',1),(167,'2024_06_06_140425_create_permissions_table',1),(168,'2024_06_06_140448_create_role_permissions_table',1),(169,'2024_06_21_133502_create_email_templates_table',1),(170,'2024_06_27_132021_create_providers_table',1),(171,'2024_06_27_161847_create_certifications_table',1),(172,'2024_06_27_161903_create_practices_table',1),(173,'2024_06_27_161921_create_biographies_table',1),(174,'2024_06_27_161935_create_qualifications_table',1),(175,'2024_06_27_161946_create_specialities_table',1),(176,'2024_06_27_161958_create_availabilities_table',1),(177,'2024_06_27_162014_create_finances_table',1),(178,'2024_06_27_205359_create_documents_table',1),(179,'2024_06_28_151139_create_cities_table',1),(180,'2024_07_05_180355_create_states_table',1),(181,'2024_07_05_210456_create_sliders_table',1),(182,'2024_07_08_150006_create_blogs_table',1),(183,'2024_07_26_125115_create_services_table',1),(184,'2024_08_06_134250_create_subscriptions_table',1),(185,'2024_08_13_165442_create_newsletters_table',1),(186,'2024_08_13_165601_create_contact_forms_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 AUTO_INCREMENT=5 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 */;
INSERT INTO `newsletters` VALUES (2,'jeff@designsfunnel.com',NULL,'103.244.179.4','1','2024-08-13 20:15:35','2024-08-13 20:15:35'),(3,'test@test.com',NULL,'103.244.179.4','1','2024-08-13 20:54:02','2024-08-13 20:54:02'),(4,'test@gmail.com',NULL,'103.244.179.4','1','2024-08-21 11:49:13','2024-08-21 11:49:13');
/*!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 */;
INSERT INTO `password_reset_tokens` VALUES ('ds.dev.ramish@gmail.com','$2y$12$S1whLTXlJOUkc2BIDFKO3.d5fNQ.WuOf7jGFmPtSWxXdIqJiUg9Qq','2024-08-21 13:55:06');
/*!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=37 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-08-13 20:10:14','2024-08-13 20:10:14',NULL),(2,'read-user','Read User','User Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(3,'update-user','Update User','User Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(4,'delete-user','Delete User','User Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(5,'create-role','Create Role','Role Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(6,'read-role','Read Role','Role Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(7,'update-role','Update Role','Role Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(8,'delete-role','Delete Role','Role Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(9,'create-email-template','Create Email Template','Email Template Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(10,'read-email-template','Read Email Template','Email Template Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(11,'update-email-template','Update Email Template','Email Template Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(12,'delete-email-template','Delete Email Template','Email Template Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(13,'create-state','Create State','State Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(14,'read-state','Read State','State Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(15,'update-state','Update State','State Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(16,'delete-state','Delete State','State Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(17,'create-slider','Create Slider','Slider Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(18,'read-slider','Read Slider','Slider Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(19,'update-slider','Update Slider','Slider Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(20,'delete-slider','Delete Slider','Slider Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(21,'create-gallery','Create Gallery','Gallery Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(22,'read-gallery','Read Gallery','Gallery Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(23,'update-gallery','Update Gallery','Gallery Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(24,'delete-gallery','Delete Gallery','Gallery Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(25,'create-blog','Create Blog','Blog Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(26,'read-blog','Read Blog','Blog Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(27,'update-blog','Update Blog','Blog Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(28,'delete-blog','Delete Blog','Blog Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(29,'read-profile','Read Profile','Profile Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(30,'create-subscription','Create Subscription','Subscription Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(31,'read-subscription','Read Subscription','Subscription Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(32,'update-subscription','Update Subscription','Subscription Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(33,'delete-subscription','Delete Subscription','Subscription Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(34,'buy-subscription','Buy Subscription','Subscription Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(35,'read-newsletter','Read Newsletter','Other Form Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(36,'read-contact-form','Read Contact Form','Other Form Management','1',NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',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 `practices`
--
DROP TABLE IF EXISTS `practices`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `practices` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`business_name` varchar(255) DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`contact` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`zip` 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 `practices`
--
LOCK TABLES `practices` WRITE;
/*!40000 ALTER TABLE `practices` DISABLE KEYS */;
INSERT INTO `practices` VALUES (1,'Designs Funnel LLC','https://designsfunnel.com','(307) 314-9315','designsfunnel@gmail.com','7673 Oak Field Ct','Springfield','Virginia','22153','3','45.39.33.202','1','2024-08-28 13:14:19','2024-08-28 13:14:19');
/*!40000 ALTER TABLE `practices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `providers`
--
DROP TABLE IF EXISTS `providers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `providers` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`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 `providers`
--
LOCK TABLES `providers` WRITE;
/*!40000 ALTER TABLE `providers` DISABLE KEYS */;
/*!40000 ALTER TABLE `providers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `qualifications`
--
DROP TABLE IF EXISTS `qualifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `qualifications` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`school_name` varchar(255) DEFAULT NULL,
`school_address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`degree` varchar(255) DEFAULT NULL,
`year_graduated` varchar(255) DEFAULT NULL,
`number_year_practice` 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 `qualifications`
--
LOCK TABLES `qualifications` WRITE;
/*!40000 ALTER TABLE `qualifications` DISABLE KEYS */;
INSERT INTO `qualifications` VALUES (1,'The school','7673 Oak Field Ct','Springfield','Virginia','Masters','2024-08-23','12','3','45.39.33.202','1','2024-08-28 13:15:09','2024-08-28 13:15:09');
/*!40000 ALTER TABLE `qualifications` 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=90 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 (50,2,'create-slider',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(51,2,'read-slider',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(52,2,'update-slider',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(53,2,'delete-slider',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(54,2,'create-gallery',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(55,2,'read-gallery',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(56,2,'update-gallery',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(57,2,'delete-gallery',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(58,2,'read-profile',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(59,2,'read-subscription',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(60,2,'buy-subscription',1,'1','45.39.33.202','1','2024-08-28 13:36:27','2024-08-28 13:36:27',NULL),(80,1,'create-user',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(81,1,'read-user',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(82,1,'update-user',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(83,1,'delete-user',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(84,1,'create-subscription',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(85,1,'read-subscription',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(86,1,'update-subscription',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(87,1,'delete-subscription',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(88,1,'read-newsletter',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',NULL),(89,1,'read-contact-form',1,'1','103.244.179.4','1','2024-08-28 18:48:02','2024-08-28 18:48:02',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=4 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-08-13 20:10:14','2024-08-13 20:10:14',NULL),(2,'Provider',1,1,NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL),(3,'User',1,1,NULL,NULL,'2024-08-13 20:10:14','2024-08-13 20:10:14',NULL);
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `services`
--
DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `services` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`category` varchar(255) NOT NULL,
`service_name` varchar(255) NOT 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=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `services`
--
LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
INSERT INTO `services` VALUES (1,'Hair Services','Haircut and Styling','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(2,'Hair Services','Hair Coloring','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(3,'Hair Services','Hair Treatments','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(4,'Hair Services','Texture Services','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(5,'Hair Services','Extensions and Add-Ons','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(6,'Hair Services','Special Occasion Styling','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(7,'Skin Services','Facials','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(8,'Skin Services','Chemical Peels','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(9,'Skin Services','Microdermabrasion','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(10,'Skin Services','Laser Treatments','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(11,'Skin Services','Skin Analysis','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(12,'Makeup Services','Bridal Makeup','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(13,'Makeup Services','Event Makeup','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(14,'Makeup Services','Makeup Lessons','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(15,'Makeup Services','Airbrush Makeup','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(16,'Nail Services','Manicure','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(17,'Nail Services','Pedicure','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(18,'Nail Services','Nail Art','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(19,'Nail Services','Gel Nails','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(20,'Nail Services','Acrylic Nails','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(21,'Massage Therapy','Swedish Massage','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(22,'Massage Therapy','Deep Tissue Massage','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(23,'Massage Therapy','Hot Stone Massage','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(24,'Massage Therapy','Sports Massage','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(25,'Massage Therapy','Prenatal Massage','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(26,'Hair Removal','Waxing','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(27,'Hair Removal','Laser Hair Removal','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(28,'Hair Removal','Threading','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15'),(29,'Hair Removal','Electrolysis','1',NULL,'1','2024-08-13 20:10:15','2024-08-13 20:10:15');
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sliders`
--
DROP TABLE IF EXISTS `sliders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sliders` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`img` varchar(255) DEFAULT NULL,
`category` 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=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sliders`
--
LOCK TABLES `sliders` WRITE;
/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
INSERT INTO `sliders` VALUES (12,'slider/1724854247_digital_camera_photo-1080x675.jpg','slider','1','103.244.179.4','Active','2024-08-28 14:10:47','2024-08-28 14:10:47'),(13,'slider/1724854390_digital_camera_photo-1080x675.jpg','slider','1','103.244.179.4','Active','2024-08-28 14:13:10','2024-08-28 14:13:10'),(16,'slider/1724855833_profile.png','slider','1','103.244.179.4','Active','2024-08-28 14:37:13','2024-08-28 14:37:13'),(18,'slider/1724855833_download.png','slider','1','103.244.179.4','Active','2024-08-28 14:37:13','2024-08-28 14:37:13'),(22,'slider/1724856032_download.png','gallery','1','103.244.179.4','Active','2024-08-28 14:40:32','2024-08-28 14:40:32'),(23,'slider/1724856032_pexels-felix-mittermeier-1146134.jpg','gallery','1','103.244.179.4','Active','2024-08-28 14:40:32','2024-08-28 14:40:32'),(24,'slider/1724856032_Image_circle.jpg','gallery','1','103.244.179.4','Active','2024-08-28 14:40:32','2024-08-28 14:40:32'),(25,'slider/1724856033_digital_camera_photo-1080x675.jpg','gallery','1','103.244.179.4','Active','2024-08-28 14:40:33','2024-08-28 14:40:33'),(31,'slider/1724869759_bloom__blog-01.jpg','slider','3','103.244.179.4','Active','2024-08-28 18:29:19','2024-08-28 18:29:19'),(32,'slider/1724869759_bloom__blog-02.jpg','slider','3','103.244.179.4','Active','2024-08-28 18:29:19','2024-08-28 18:29:19'),(33,'slider/1724869759_bloom__iwto-01--Aug2020.jpg','slider','3','103.244.179.4','Active','2024-08-28 18:29:19','2024-08-28 18:29:19'),(34,'slider/1724869759_bloom__testimonial-05.jpg','slider','3','103.244.179.4','Active','2024-08-28 18:29:19','2024-08-28 18:29:19'),(35,'slider/1724869759_emporium__favicon-01.png','slider','3','103.244.179.4','Active','2024-08-28 18:29:19','2024-08-28 18:29:19'),(36,'slider/1724869759_emporium__fp-05.jpg','slider','3','103.244.179.4','Active','2024-08-28 18:29:20','2024-08-28 18:29:20'),(37,'slider/1724869760_flora__footer-logo.png','slider','3','103.244.179.4','Active','2024-08-28 18:29:20','2024-08-28 18:29:20'),(38,'slider/1724869760_flora__logo-colour.png','slider','3','103.244.179.4','Active','2024-08-28 18:29:20','2024-08-28 18:29:20'),(39,'slider/1724869760_flora__logolist-01.jpg','slider','3','103.244.179.4','Active','2024-08-28 18:29:20','2024-08-28 18:29:20'),(40,'slider/1724869795_flora__popup.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(41,'slider/1724869795_fresh__gallery-01.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(42,'slider/1724869795_fresh__gallery-02.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(43,'slider/1724869795_fresh__gallery-03.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(44,'slider/1724869795_fresh__gallery-04.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(45,'slider/1724869795_fresh__imt-01.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(46,'slider/1724869795_fresh__imto-01.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(47,'slider/1724869795_fresh__page--contact-us-01.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(48,'slider/1724869795_fresh__page--contact-us-banner-01.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(49,'slider/1724869795_fresh__page--faq-01.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(50,'slider/1724869795_fresh__page--our-story-01.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55'),(51,'slider/1724869795_fresh__page--our-story-banner-01.jpg','gallery','3','103.244.179.4','Active','2024-08-28 18:29:55','2024-08-28 18:29:55');
/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `specialities`
--
DROP TABLE IF EXISTS `specialities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `specialities` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`service_name` varchar(255) DEFAULT NULL,
`service_price` varchar(255) DEFAULT NULL,
`time` varchar(255) DEFAULT NULL,
`age_range` 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `specialities`
--
LOCK TABLES `specialities` WRITE;
/*!40000 ALTER TABLE `specialities` DISABLE KEYS */;
INSERT INTO `specialities` VALUES (1,'Waxing','12','hour',NULL,'3','45.39.33.202','1','2024-08-28 13:15:32','2024-08-28 13:15:32'),(2,'Chemical Peels','32','hour',NULL,'3','45.39.33.202','1','2024-08-28 13:15:32','2024-08-28 13:15:32'),(3,'Hair Treatments','123','hour',NULL,'3','45.39.33.202','1','2024-08-28 13:15:32','2024-08-28 13:15:32'),(4,'Makeup Lessons','23','hour',NULL,'3','45.39.33.202','1','2024-08-28 13:15:32','2024-08-28 13:15:32');
/*!40000 ALTER TABLE `specialities` 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=52 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-08-13 20:10:15','2024-08-13 20:10:15'),(2,'Alaska','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(3,'Arizona','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(4,'Arkansas','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(5,'California','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(6,'Colorado','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(7,'Connecticut','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(8,'Delaware','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(9,'Florida','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(10,'Georgia','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(11,'Hawaii','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(12,'Idaho','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(13,'Illinois','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(14,'Indiana','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(15,'Iowa','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(16,'Kansas','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(17,'Kentucky','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(18,'Louisiana','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(19,'Maine','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(20,'Maryland','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(21,'Massachusetts','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(22,'Michigan','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(23,'Minnesota','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(24,'Mississippi','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(25,'Missouri','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(26,'Montana','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(27,'Nebraska','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(28,'Nevada','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(29,'New Hampshire','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(30,'New Jersey','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(31,'New Mexico','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(32,'New York','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(33,'North Carolina','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(34,'North Dakota','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(35,'Ohio','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(36,'Oklahoma','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(37,'Oregon','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(38,'Pennsylvania','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(39,'Rhode Island','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(40,'South Carolina','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(41,'South Dakota','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(42,'Tennessee','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(43,'Texas','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(44,'Utah','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(45,'Vermont','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(46,'Virginia','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(47,'Washington','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(48,'West Virginia','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(49,'Wisconsin','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15'),(50,'Wyoming','1',NULL,'Active','2024-08-13 20:10:15','2024-08-13 20:10:15');
/*!40000 ALTER TABLE `states` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subscriptions`
--
DROP TABLE IF EXISTS `subscriptions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `subscriptions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`product_name` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`amount` varchar(255) DEFAULT NULL,
`currency` varchar(255) DEFAULT NULL,
`interval` varchar(255) DEFAULT NULL,
`trial_period_days` varchar(255) DEFAULT NULL,
`plan_id` varchar(255) DEFAULT NULL,
`product_id` 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 `subscriptions`
--
LOCK TABLES `subscriptions` WRITE;
/*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */;
INSERT INTO `subscriptions` VALUES (1,'Basic Plan','This plan will allow you to publish your profile on our website. This will help you grow your business online.','30','usd','month','15','plan_QkLf9pXltRbZCu','prod_QkLfxHaP56bOKR','2','103.244.179.4','1','2024-08-28 18:51:42','2024-08-28 18:52:08');
/*!40000 ALTER TABLE `subscriptions` 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,
`remember_token` varchar(100) DEFAULT NULL,
`verification_token` varchar(255) 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=8 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-08-13 20:10:14','$2y$12$oJFxwZpY3K2uIFEO3RZLpOCWxUa/YFiWvirEJ2QHbulymVwxcm0ce',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','1','0','0',NULL,NULL,NULL,'p8qpnQcw1ZQi6L8vZRGHM0jTPI4IPMQV7enhZSUPqzetT0GFn4UOxov8Hc0x','$2y$12$w3nSr0S37D2mMZhoCM5lKeqVypssl1mvYs44tI2NB/G0iAKrD8HR2',NULL,'2024-09-25 17:42:05'),(2,'Portal','Admin','admin@gmail.com','2024-08-13 20:10:14','$2y$12$IBJ9zW8agrrfR5Mc4LASH./q9sL8vvBXe/JOPLGb3QpAZU3i9JBqK',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1','0','0',NULL,NULL,NULL,'mQgMgcLYd4U8EEJDQOX46LUlyUZUuoTHqh6rFpJFNNVmSCynpDUYbZ00KBSg',NULL,NULL,NULL),(3,'Jeff','Williams','jeff@designsfunnel.com','2024-08-13 20:22:18','$2y$12$fJ0.9OSmC9UshbKchn85H.h.IPjc7UXgqE62kQnczi2RNim4Vf.XC','1993-11-10','Male','30 N Gould St Ste R','Sheridan','Wyoming','82801','(123) 456-7899','PST','upload/1724850802.jpg','2','1','1','1','cus_P6NpsT4GxGlqQA','sub_1PsqzEEmSGh5uWbDmUuvuG5b',NULL,'TJbQ3Xn9CjfbMyq2WnRcvEMEfNzYghMMYM63U7afMhVIjg4kWTKFw6Iljfa7','$2y$12$TD/ftekx9Kdu3nVGmWN9/eSdh9i7E1Jvhi4oPtSBw6oRuPQR9wS7y','2024-08-13 20:19:40','2024-09-19 18:22:51'),(5,'Brian','Miller','brian@designsfunnel.com',NULL,'$2y$12$BR8UtExmMrkx6n1LSM5tc.8KAC7sctt0oEyu/c9wBD.B6iJG9yMuy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','1','0','0',NULL,NULL,NULL,NULL,NULL,'2024-08-27 16:42:52','2024-08-27 16:42:52'),(6,'Thomas','Jackson','thomas.jackson@designsfunnel.com',NULL,'$2y$12$oJFxwZpY3K2uIFEO3RZLpOCWxUa/YFiWvirEJ2QHbulymVwxcm0ce',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2','1','0','0',NULL,NULL,NULL,NULL,'$2y$12$edvCKZoBTPz2yXgoFkOjoe1DJDHgAuYcsQ7LugwpO7yJ0Gat9J26e','2024-08-28 12:59:07','2024-08-28 13:52:02');
/*!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