/*
SQLyog Professional v13.1.1 (64 bit)
MySQL - 10.4.22-MariaDB : Database - gigme
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 `application_setting` */

CREATE TABLE `application_setting` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_file` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `identifier` (`identifier`),
  KEY `meta_key` (`meta_key`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `application_setting` */

insert  into `application_setting`(`id`,`identifier`,`meta_key`,`value`,`is_file`,`created_at`,`updated_at`,`deleted_at`) values (1,'application_setting','favicon','images/favicon.png',1,'2021-12-20 07:16:05',NULL,NULL);
insert  into `application_setting`(`id`,`identifier`,`meta_key`,`value`,`is_file`,`created_at`,`updated_at`,`deleted_at`) values (2,'application_setting','logo','images/favicon.png',1,'2021-12-20 07:16:05',NULL,NULL);
insert  into `application_setting`(`id`,`identifier`,`meta_key`,`value`,`is_file`,`created_at`,`updated_at`,`deleted_at`) values (3,'application_setting','application_name','GIGME',0,'2021-12-20 07:16:05',NULL,NULL);

/*Table structure for table `booking_status_log` */

CREATE TABLE `booking_status_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actor_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `booking_status_log_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `booking_status_log` */

/*Table structure for table `bookings` */

CREATE TABLE `bookings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `package_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `package_id` int(11) NOT NULL,
  `price` int(11) DEFAULT NULL,
  `gig_id` bigint(20) unsigned NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` decimal(8,2) DEFAULT NULL,
  `latitude` decimal(8,2) DEFAULT NULL,
  `date_time` datetime NOT NULL,
  `additional_notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bookings_slug_unique` (`slug`),
  KEY `bookings_gig_id_foreign` (`gig_id`),
  CONSTRAINT `bookings_gig_id_foreign` FOREIGN KEY (`gig_id`) REFERENCES `gigs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `bookings` */

/*Table structure for table `categories` */

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`),
  UNIQUE KEY `categories_title_unique` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `categories` */

insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (1,0,'61c02db55e3dc61c02db55e3dd','IT and Web',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (2,0,'61c02db55e3df61c02db55e3e0','SEO',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (3,0,'61c02db55e3e161c02db55e3e2','Digital Marketing',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (4,0,'61c02db55e3e361c02db55e3e4','Content Writing',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (5,0,'61c02db55e3e561c02db55e3e6','VR',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (6,0,'61c02db55e3e761c02db55e3e8','Mobile Apps',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (7,0,'61c02db55e3e961c02db55e3ea','E-commerce',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (8,0,'61c02db55e3eb61c02db55e3ec','Graphics',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (9,0,'61c02db55e3ed61c02db55e3ee','Writing',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (10,0,'61c02db55e3ef61c02db55e3f0','Web Development',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (11,0,'61c02db55e3f161c02db55e3f2','User Persona',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (12,0,'61c02db55e3f361c02db55e3f4','UI',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (13,0,'61c02db55e3f561c02db55e3f6','User Experience',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (14,0,'61c02db55e3f761c02db55e3f8','Animatiom',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (15,0,'61c02db55e3f961c02db55e3fa','Sketch',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);
insert  into `categories`(`id`,`parent_id`,`slug`,`title`,`status`,`description`,`image`,`created_at`,`updated_at`,`deleted_at`) values (16,0,'61c02db55e3fb61c02db55e3fc','Story Based',1,NULL,'user-placehoder','2021-12-20 12:16:05',NULL,NULL);

/*Table structure for table `cms_module_permissions` */

CREATE TABLE `cms_module_permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cms_role_id` bigint(20) unsigned NOT NULL,
  `cms_module_id` bigint(20) unsigned NOT NULL,
  `is_add` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_view` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_update` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_delete` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_module_permissions_cms_role_id_foreign` (`cms_role_id`),
  KEY `cms_module_permissions_cms_module_id_foreign` (`cms_module_id`),
  CONSTRAINT `cms_module_permissions_cms_module_id_foreign` FOREIGN KEY (`cms_module_id`) REFERENCES `cms_modules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cms_module_permissions_cms_role_id_foreign` FOREIGN KEY (`cms_role_id`) REFERENCES `cms_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cms_module_permissions` */

/*Table structure for table `cms_modules` */

CREATE TABLE `cms_modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fa fa-list',
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `sort_order` decimal(5,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cms_modules_name_unique` (`name`),
  UNIQUE KEY `cms_modules_route_name_unique` (`route_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cms_modules` */

insert  into `cms_modules`(`id`,`parent_id`,`name`,`route_name`,`icon`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values (1,0,'Cms Roles Management','cms-roles-management.index','fa fa-key','1',1.00,'2021-12-20 07:16:04',NULL,NULL);
insert  into `cms_modules`(`id`,`parent_id`,`name`,`route_name`,`icon`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values (2,0,'Cms Users Management','cms-users-management.index','fa fa-users','1',2.00,'2021-12-20 07:16:04',NULL,NULL);
insert  into `cms_modules`(`id`,`parent_id`,`name`,`route_name`,`icon`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values (3,0,'Application Setting','admin.application-setting','fa fa-cog','1',3.00,'2021-12-20 07:16:04',NULL,NULL);
insert  into `cms_modules`(`id`,`parent_id`,`name`,`route_name`,`icon`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values (4,0,'Users Management','app-users.index','fa fa-users','1',4.00,'2021-12-20 07:16:04',NULL,NULL);
insert  into `cms_modules`(`id`,`parent_id`,`name`,`route_name`,`icon`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values (5,0,'Content Management','content-management.index','fa fa-tasks','1',5.00,'2021-12-20 07:16:04',NULL,NULL);
insert  into `cms_modules`(`id`,`parent_id`,`name`,`route_name`,`icon`,`status`,`sort_order`,`created_at`,`updated_at`,`deleted_at`) values (6,0,'FAQ`s','faq.index','fa fa-question-circle-o','1',6.00,'2021-12-20 07:16:04',NULL,NULL);

/*Table structure for table `cms_roles` */

CREATE TABLE `cms_roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_super_admin` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cms_roles` */

insert  into `cms_roles`(`id`,`name`,`slug`,`is_super_admin`,`created_at`,`updated_at`,`deleted_at`) values (1,'Super Admin','super-admin','1','2021-12-20 07:16:04',NULL,NULL);

/*Table structure for table `cms_users` */

CREATE TABLE `cms_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cms_role_id` bigint(20) unsigned NOT NULL,
  `user_ref_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cms_users_username_unique` (`username`),
  UNIQUE KEY `cms_users_slug_unique` (`slug`),
  UNIQUE KEY `cms_users_email_unique` (`email`),
  UNIQUE KEY `cms_users_mobile_no_unique` (`mobile_no`),
  KEY `cms_users_cms_role_id_foreign` (`cms_role_id`),
  CONSTRAINT `cms_users_cms_role_id_foreign` FOREIGN KEY (`cms_role_id`) REFERENCES `cms_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cms_users` */

insert  into `cms_users`(`id`,`cms_role_id`,`user_ref_id`,`name`,`username`,`slug`,`email`,`mobile_no`,`password`,`image_url`,`status`,`remember_token`,`created_at`,`updated_at`,`deleted_at`) values (1,1,0,'RetroCube','retrocube','retrocube','admin@retrocube.com','1-8882051816','$2y$10$PRaC61eiGtw7XtdpcBjNt.sGCbbqi72IB9cPbY8ugflPUQrp0ZVEe',NULL,'1',NULL,'2021-12-20 07:16:04',NULL,NULL);

/*Table structure for table `cms_widget_role` */

CREATE TABLE `cms_widget_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cms_widget_id` bigint(20) unsigned NOT NULL,
  `cms_role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_widget_role_cms_widget_id_foreign` (`cms_widget_id`),
  KEY `cms_widget_role_cms_role_id_foreign` (`cms_role_id`),
  CONSTRAINT `cms_widget_role_cms_role_id_foreign` FOREIGN KEY (`cms_role_id`) REFERENCES `cms_roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cms_widget_role_cms_widget_id_foreign` FOREIGN KEY (`cms_widget_id`) REFERENCES `cms_widgets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cms_widget_role` */

/*Table structure for table `cms_widgets` */

CREATE TABLE `cms_widgets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `div_column_class` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `widget_type` enum('small_box','line_chart','bar_chat','pie_chart','map_chart') COLLATE utf8mb4_unicode_ci NOT NULL,
  `sql` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `config` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_widgets_widget_type_index` (`widget_type`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cms_widgets` */

insert  into `cms_widgets`(`id`,`title`,`description`,`icon`,`color`,`div_column_class`,`link`,`widget_type`,`sql`,`config`,`status`,`created_at`,`updated_at`,`deleted_at`) values (1,'Total User',NULL,'icon-user','#4b71fa','col-md-3','/admin/app-users','small_box','Select count(*) from users limit 1','','0',NULL,NULL,NULL);
insert  into `cms_widgets`(`id`,`title`,`description`,`icon`,`color`,`div_column_class`,`link`,`widget_type`,`sql`,`config`,`status`,`created_at`,`updated_at`,`deleted_at`) values (2,'Total Roles',NULL,'icon-people','#7bcb4d','col-md-3','/admin/app-users','small_box','Select count(*) from users limit 1','','0',NULL,NULL,NULL);
insert  into `cms_widgets`(`id`,`title`,`description`,`icon`,`color`,`div_column_class`,`link`,`widget_type`,`sql`,`config`,`status`,`created_at`,`updated_at`,`deleted_at`) values (3,'Total User',NULL,'icon-user','#4b71fa','col-md-3','/admin/app-users','small_box','Select count(*) from users limit 1','','0',NULL,NULL,NULL);
insert  into `cms_widgets`(`id`,`title`,`description`,`icon`,`color`,`div_column_class`,`link`,`widget_type`,`sql`,`config`,`status`,`created_at`,`updated_at`,`deleted_at`) values (4,'Total Roles',NULL,'icon-people','#7bcb4d ','col-md-3','/admin/app-users','small_box','Select count(*) from users limit 1','','0',NULL,NULL,NULL);
insert  into `cms_widgets`(`id`,`title`,`description`,`icon`,`color`,`div_column_class`,`link`,`widget_type`,`sql`,`config`,`status`,`created_at`,`updated_at`,`deleted_at`) values (5,'Users',NULL,'icon-user','#fff','col-md-12','/admin/app-users','line_chart','SELECT count(id) AS value, MONTHNAME(created_at) as label FROM users where YEAR(created_at) = YEAR(now()) group by MONTH(created_at) order by MONTH(created_at) asc','','0',NULL,NULL,NULL);

/*Table structure for table `content_management` */

CREATE TABLE `content_management` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `content_management_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `content_management` */

insert  into `content_management`(`id`,`title`,`slug`,`content`,`status`,`created_at`,`updated_at`,`deleted_at`) values (1,'Terms Condition','terms-condition','Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.',1,'2020-02-11 15:01:25',NULL,NULL);
insert  into `content_management`(`id`,`title`,`slug`,`content`,`status`,`created_at`,`updated_at`,`deleted_at`) values (2,'Privacy Policy','privacy-policy','Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.',1,'2020-02-11 15:01:25',NULL,NULL);
insert  into `content_management`(`id`,`title`,`slug`,`content`,`status`,`created_at`,`updated_at`,`deleted_at`) values (3,'About Us','about-us','Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.',1,'2020-02-11 15:01:25',NULL,NULL);

/*Table structure for table `failed_jobs` */

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci 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;

/*Data for the table `failed_jobs` */

/*Table structure for table `faqs` */

CREATE TABLE `faqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `faqs_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `faqs` */

insert  into `faqs`(`id`,`slug`,`question`,`answer`,`status`,`created_at`,`updated_at`,`deleted_at`) values (1,'61c02db54d6f461c02db54d6f6','How to change the language','Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.',1,'2020-02-17 15:45:47',NULL,NULL);
insert  into `faqs`(`id`,`slug`,`question`,`answer`,`status`,`created_at`,`updated_at`,`deleted_at`) values (2,'61c02db54d6f761c02db54d6f8','How to restore your chat history','Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs. The passage is attributed to an unknown typesetter in the 15th century who is thought to have scrambled parts of Cicero\'s De Finibus Bonorum et Malorum for use in a type specimen book.',1,'2020-02-17 15:51:16',NULL,NULL);

/*Table structure for table `gigs` */

CREATE TABLE `gigs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `is_delete` int(11) NOT NULL DEFAULT 0,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `status` enum('pending','accepted','rejected','completed','disputed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `gigs_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `gigs` */

/*Table structure for table `jobs` */

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci 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;

/*Data for the table `jobs` */

/*Table structure for table `mail_templates` */

CREATE TABLE `mail_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `identifier` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `wildcard` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_templates_identifier_unique` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `mail_templates` */

insert  into `mail_templates`(`id`,`identifier`,`subject`,`body`,`wildcard`,`created_at`,`updated_at`,`deleted_at`) values (1,'forgot-password','Forgot Password Confirmation','<table class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: #ffffff; border-radius: 3px;\">\r\n    <tr>\r\n        <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\">\r\n            <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\">\r\n                <tr>\r\n                    <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\">\r\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;\">Hi [USERNAME],</p>\r\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;\">A request has been made to recover password for your account. Please follow below link to generate new password for your account :</p>\r\n                        <p><a href=\"[LINK]\">Reset Password</a></p>\r\n                        <br>\r\n                        <br>\r\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;\">Regards,</p>\r\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;\">© [YEAR] [APP_NAME] All Rights reserved.</p>\r\n                    </td>\r\n                </tr>\r\n            </table>\r\n        </td>\r\n    </tr>\r\n</table>\r\n','[USERNAME],[LINK],[YEAR],[APP_NAME]','2021-12-20 07:16:04',NULL,NULL);
insert  into `mail_templates`(`id`,`identifier`,`subject`,`body`,`wildcard`,`created_at`,`updated_at`,`deleted_at`) values (2,'user_registration','Welcome to [APP_NAME]','<table class=\"main\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: #ffffff; border-radius: 3px;\">\r\n    <tr>\r\n        <td class=\"wrapper\" style=\"font-family: sans-serif; font-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;\">\r\n            <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;\">\r\n                <tr>\r\n                    <td style=\"font-family: sans-serif; font-size: 14px; vertical-align: top;\">\r\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;\">Hi [USERNAME],</p>\r\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;\">Your account has been created successfully. First, you need to confirm your account. Just click the below link</p>\r\n                        <p><a href=\"[LINK]\">Verify Now</a></p>\r\n                        <br>\r\n                        <br>\r\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;\">Regards,</p>\r\n                        <p style=\"font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;\">© [YEAR] [APP_NAME] All Rights reserved.</p>\r\n                    </td>\r\n                </tr>\r\n            </table>\r\n        </td>\r\n    </tr>\r\n</table>\r\n','[USERNAME],[LINK],[YEAR],[APP_NAME]','2021-12-20 07:16:04',NULL,NULL);

/*Table structure for table `media` */

CREATE TABLE `media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int(11) NOT NULL,
  `filename` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `driver` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local',
  `media_type` enum('public','private') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  `meta` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_module_module_id_index` (`module`,`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `media` */

/*Table structure for table `migrations` */

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values (1,'2019_08_19_000000_create_failed_jobs_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (2,'2021_03_05_000000_create_cms_roles_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (3,'2021_03_05_172240_create_cms_users_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (4,'2021_03_05_174918_create_cms_modules_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (5,'2021_03_05_175415_create_cms_module_permissions_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (6,'2021_03_06_185651_create_mail_templates_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (7,'2021_03_08_191839_create_reset_password_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (8,'2021_03_13_121206_create_application_setting_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (9,'2021_04_20_200223_create_user_groups_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (10,'2021_04_20_200451_create_users_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (11,'2021_04_20_202053_create_user_api_token_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (12,'2021_06_04_181436_create_notification_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (13,'2021_06_06_130550_create_notification_setting_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (14,'2021_08_29_105840_create_jobs_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (15,'2021_09_07_154417_create_cms_widgets_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (16,'2021_09_07_161059_create_cms_widget_role_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (17,'2021_09_08_081135_create_content_management_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (18,'2021_09_08_082346_create_faqs_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (19,'2021_09_20_180624_create_media_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (20,'2021_11_30_121343_create_categories_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (21,'2021_12_01_082227_create_user_preferences_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (22,'2021_12_02_063940_create_skills_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (23,'2021_12_02_070554_create_user_skills_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (24,'2021_12_03_075747_create_gigs_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (25,'2021_12_03_080928_create_packages_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (26,'2021_12_07_062215_create_services_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (27,'2021_12_07_062525_create_bookings_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (28,'2021_12_07_065250_create_booking_status_log_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (29,'2021_12_07_065556_create_rating_review_table',1);
insert  into `migrations`(`id`,`migration`,`batch`) values (30,'2021_12_17_125634_create_user_json_skill_table',1);

/*Table structure for table `notification` */

CREATE TABLE `notification` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actor_id` int(11) NOT NULL,
  `actor_type` enum('users','cms_users') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'users',
  `target_id` int(11) NOT NULL,
  `target_type` enum('users','cms_users') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'users',
  `reference_id` int(11) NOT NULL,
  `reference_module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `web_redirect_link` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_read` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_view` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_unique_id_identifier_target_id_index` (`unique_id`,`identifier`,`target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `notification` */

/*Table structure for table `notification_setting` */

CREATE TABLE `notification_setting` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_setting_user_id_index` (`user_id`),
  CONSTRAINT `notification_setting_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `notification_setting` */

/*Table structure for table `packages` */

CREATE TABLE `packages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `package_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int(11) NOT NULL DEFAULT 0,
  `package_details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gig_id` bigint(20) unsigned NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `packages_slug_unique` (`slug`),
  KEY `packages_gig_id_foreign` (`gig_id`),
  CONSTRAINT `packages_gig_id_foreign` FOREIGN KEY (`gig_id`) REFERENCES `gigs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `packages` */

/*Table structure for table `rating_review` */

CREATE TABLE `rating_review` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actor_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `module_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `review` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reply` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating` decimal(8,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `rating_review` */

/*Table structure for table `reset_password` */

CREATE TABLE `reset_password` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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;

/*Data for the table `reset_password` */

/*Table structure for table `services` */

CREATE TABLE `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gig_id` bigint(20) unsigned NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `services_slug_unique` (`slug`),
  KEY `services_gig_id_foreign` (`gig_id`),
  CONSTRAINT `services_gig_id_foreign` FOREIGN KEY (`gig_id`) REFERENCES `gigs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `services` */

/*Table structure for table `skills` */

CREATE TABLE `skills` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `skills_slug_unique` (`slug`),
  UNIQUE KEY `skills_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `skills` */

/*Table structure for table `user_api_token` */

CREATE TABLE `user_api_token` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `api_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `refresh_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `udid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `device_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `platform_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'custom',
  `platform_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_api_token_api_token_unique` (`api_token`),
  UNIQUE KEY `user_api_token_refresh_token_unique` (`refresh_token`),
  KEY `user_api_token_user_id_foreign` (`user_id`),
  KEY `user_api_token_api_token_index` (`api_token`),
  CONSTRAINT `user_api_token_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `user_api_token` */

/*Table structure for table `user_groups` */

CREATE TABLE `user_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `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;

/*Data for the table `user_groups` */

insert  into `user_groups`(`id`,`title`,`slug`,`status`,`created_at`,`updated_at`,`deleted_at`) values (1,'App User','app-user','1','2021-12-20 07:16:05',NULL,NULL);
insert  into `user_groups`(`id`,`title`,`slug`,`status`,`created_at`,`updated_at`,`deleted_at`) values (2,'Freelancer','freelancer','1','2021-12-20 07:16:05',NULL,NULL);

/*Table structure for table `user_json_skills` */

CREATE TABLE `user_json_skills` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `skill_data` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_json_skills_user_id_foreign` (`user_id`),
  CONSTRAINT `user_json_skills_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `user_json_skills` */

/*Table structure for table `user_preferences` */

CREATE TABLE `user_preferences` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_preferences_user_id_foreign` (`user_id`),
  KEY `user_preferences_category_id_user_id_index` (`category_id`,`user_id`),
  CONSTRAINT `user_preferences_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_preferences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `user_preferences` */

/*Table structure for table `user_skills` */

CREATE TABLE `user_skills` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `skill_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_skills_user_id_foreign` (`user_id`),
  KEY `user_skills_skill_id_user_id_index` (`skill_id`,`user_id`),
  CONSTRAINT `user_skills_skill_id_foreign` FOREIGN KEY (`skill_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_skills_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `user_skills` */

/*Table structure for table `users` */

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_group_id` bigint(20) unsigned NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `is_email_verify` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `email_verify_at` datetime DEFAULT NULL,
  `is_mobile_verify` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `mobile_verify_at` datetime DEFAULT NULL,
  `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zipcode` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `online_status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `mobile_otp` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_otp` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `years_of_experience` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_slug_unique` (`slug`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_mobile_no_unique` (`mobile_no`),
  KEY `index1` (`user_group_id`,`slug`,`email`,`mobile_no`,`is_email_verify`,`status`),
  CONSTRAINT `users_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `users` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;