-- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64) -- -- Host: localhost Database: retrocub_gigme_qa2 -- ------------------------------------------------------ -- Server version 8.0.32-0ubuntu0.20.04.2 /*!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 */; /*!50503 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 `application_setting` -- DROP TABLE IF EXISTS `application_setting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `application_setting` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_file` tinyint 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=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `application_setting` -- LOCK TABLES `application_setting` WRITE; /*!40000 ALTER TABLE `application_setting` DISABLE KEYS */; INSERT INTO `application_setting` VALUES (8,'application_setting','favicon','application_setting/1b28zgYDEamrSHGR6L38N91hVMStXQiK1svaFxu6.png',1,'2022-08-17 18:46:45',NULL,NULL),(9,'application_setting','application_name','GIGME',0,'2022-08-22 14:22:46',NULL,NULL),(10,'application_setting','logo','application_setting/oRFp05LwYKgYqr30R2krkXoV4KXDzUV3668MpmAT.png',1,'2022-08-22 14:22:46',NULL,NULL); /*!40000 ALTER TABLE `application_setting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `booking_package_log` -- DROP TABLE IF EXISTS `booking_package_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `booking_package_log` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `package_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `price` int NOT NULL DEFAULT '0', `package_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `booking_id` int 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 `booking_package_log_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `booking_package_log` -- LOCK TABLES `booking_package_log` WRITE; /*!40000 ALTER TABLE `booking_package_log` DISABLE KEYS */; INSERT INTO `booking_package_log` VALUES (1,'63fe5dc2706e563fe5dc2706e6','diamond','Diamond',6,'Terrazzo floor refinishing',1,'2023-02-28 20:02:10',NULL,NULL),(2,'63fe5eff26d7163fe5eff26d72','silver','Silver',12,'Silver',2,'2023-02-28 20:07:27',NULL,NULL); /*!40000 ALTER TABLE `booking_package_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `booking_status_log` -- DROP TABLE IF EXISTS `booking_status_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `booking_status_log` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `actor_id` int NOT NULL, `booking_id` int NOT NULL, `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status` varchar(255) CHARACTER SET utf8mb4 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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `booking_status_log` -- LOCK TABLES `booking_status_log` WRITE; /*!40000 ALTER TABLE `booking_status_log` DISABLE KEYS */; INSERT INTO `booking_status_log` VALUES (1,'63fe5dc26fa9e63fe5dc26fa9f',4,1,NULL,'pending','2023-02-28 20:02:10',NULL,NULL),(2,'63fe5eff25dbd63fe5eff25dbe',4,2,NULL,'pending','2023-02-28 20:07:27',NULL,NULL),(3,'63fe71022013d63fe71022013e',11,1,'Not in my location','rejected','2023-02-28 21:24:18',NULL,NULL),(4,'63fe71052600b63fe71052600c',11,1,'Not in my location','rejected','2023-02-28 21:24:21',NULL,NULL); /*!40000 ALTER TABLE `booking_status_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bookings` -- DROP TABLE IF EXISTS `bookings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bookings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `actor_id` bigint unsigned NOT NULL, `gig_id` bigint unsigned NOT NULL, `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `longitude` decimal(8,2) DEFAULT NULL, `latitude` decimal(8,2) DEFAULT NULL, `date_time` datetime NOT NULL, `additional_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `is_complete` int NOT NULL DEFAULT '0', `is_dispute` tinyint NOT NULL DEFAULT '0', `is_settled` int NOT NULL DEFAULT '0', `transaction_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `platform_fee` decimal(10,2) NOT NULL DEFAULT '0.00', `net_amount` decimal(10,2) NOT NULL DEFAULT '0.00', `status_updated_at` datetime 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 `bookings_slug_unique` (`slug`), KEY `bookings_actor_id_foreign` (`actor_id`), KEY `bookings_gig_id_foreign` (`gig_id`), CONSTRAINT `bookings_actor_id_foreign` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `bookings_gig_id_foreign` FOREIGN KEY (`gig_id`) REFERENCES `gigs` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bookings` -- LOCK TABLES `bookings` WRITE; /*!40000 ALTER TABLE `bookings` DISABLE KEYS */; INSERT INTO `bookings` VALUES (1,'63fe5dc26ea5763fe5dc26ea58',4,3,'Abu Dhabi - Mohamed Bin Zayed City - Z13 - Abu Dhabi - United Arab Emirates',54.56,24.34,'2023-03-01 22:01:24','Change for 1000aed','Not in my location','rejected',0,0,0,'0',0.00,0.00,'0000-00-00 00:00:00','2023-02-28 20:02:10','2023-02-28 21:24:21',NULL),(2,'63fe5eff2423163fe5eff24232',4,4,'200 W Main St, Louisville, KY 40202, USA',-85.75,38.26,'2023-03-07 01:06:37','We have a dog so wait at the gate amd call us',NULL,'pending',0,0,0,'0',0.00,0.00,'0000-00-00 00:00:00','2023-02-28 20:07:27','2023-02-28 20:07:27',NULL); /*!40000 ALTER TABLE `bookings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `categories` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `parent_id` int NOT NULL DEFAULT '0', `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint NOT NULL DEFAULT '1', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `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=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,0,'61e96ae6a0b0561e96ae6a0b06','IT and Web',1,NULL,NULL,'2022-01-20 19:00:06',NULL,NULL),(2,0,'61e96ae6a0b0861e96ae6a0b09','SEO',1,NULL,NULL,'2022-01-20 19:00:06',NULL,NULL),(3,0,'61e96ae6a0b0a61e96ae6a0b0b','Digital Marketing',1,NULL,NULL,'2022-01-20 19:00:06',NULL,NULL),(4,0,'61e96ae6a0b0c61e96ae6a0b0d','Content Writing',1,NULL,NULL,'2022-01-20 19:00:06',NULL,NULL),(5,0,'61e96ae6a0b0e61e96ae6a0b0f','VR',1,NULL,NULL,'2022-01-20 19:00:06',NULL,NULL),(6,0,'61e96ae6a0b1061e96ae6a0b11','Mobile Apps',1,NULL,NULL,'2022-01-20 19:00:06',NULL,NULL),(7,0,'61e96ae6a0b1261e96ae6a0b13','E-commerce',1,NULL,NULL,'2022-01-20 19:00:06',NULL,NULL),(8,0,'61e96ae6a0b1461e96ae6a0b15','Graphics',1,NULL,NULL,'2022-01-20 19:00:06',NULL,NULL),(9,0,'61e96ae6a0b1e61e96ae6a0b1f','Writing',1,NULL,'category/SfxassWS5Er0Qp6JuK5ZR6Yu6Y6dLwdbQ61jglUQ.jpg','2022-01-20 19:00:06','2022-09-09 14:00:29',NULL),(10,0,'61e96ae6a0b2061e96ae6a0b21','Web Development',1,NULL,'category/I3IbSpu2pLy4N64rs9jM4gr0g5Veo4iHbgWwT85e.jpg','2022-01-20 19:00:06','2022-09-09 14:00:12',NULL),(11,0,'61e96ae6a0b2261e96ae6a0b23','User Persona',1,NULL,'category/I0Q5RXopOnrRKfjGFVLWKJmXyu9ciYzS7zASJgJL.bin','2022-01-20 19:00:06','2022-09-09 13:59:43',NULL),(12,0,'61e96ae6a0b2461e96ae6a0b25','UI',1,NULL,'category/PssW6DeZjX1WWIhZRZ3Hz6TQbBi8wYCzsAOjZ0mq.webp','2022-01-20 19:00:06','2022-09-09 13:59:14',NULL),(13,0,'61e96ae6a0b2661e96ae6a0b27','User Experience',1,NULL,'category/7LA2czVW0vDCu38G0aSqnTZN047gychxw5LYKWqH.png','2022-01-20 19:00:06','2022-09-09 13:58:41',NULL),(14,0,'61e96ae6a0b2861e96ae6a0b29','Animation',1,NULL,'category/T1DHHyUipzd4EnyKcqFoeFcd1XORpMyZllW0TdB8.png','2022-01-20 19:00:06','2022-09-09 13:58:17',NULL),(15,0,'61e96ae6a0b2a61e96ae6a0b2b','Sketch',1,NULL,'category/tpJ66gWETK5zcqQSDEOGK2tDuV9vnXk2PDOwTuVv.png','2022-01-20 19:00:06','2022-09-09 13:57:17',NULL),(16,0,'61e96ae6a0b2c61e96ae6a0b2d','Story Based',1,NULL,'category/0AEQCwURZs1IZBfvFPdEQuam0QKMANB1iOVaK8OM.jpg','2022-01-20 19:00:06','2022-09-09 13:57:42',NULL),(18,0,'62136aa0c5ad262136aa0c5ad4','ututuu',0,'rtrt','category/Q8SgYrzInNiSIwSDGQKJpiEW3zPNGDI1fMOyCQlV.png','2022-02-21 10:34:08','2022-08-17 10:02:17',NULL),(19,0,'62136bd67826f62136bd678270','test',0,'rtrt','category/HAO1MjZHq2nm5EYRjmrr94pHYtEO1lyS2259Yg3I.png','2022-02-21 10:39:18','2022-02-22 04:47:10',NULL),(20,0,'63030c6204dba63030c6204dbc','Abrasive services',1,'Surface cleaning and preparation','category/jwGWSKsoxIyc4VuOUp12fTW6SJgO71NAaXQxtrE3.webp','2022-08-22 04:56:02','2022-09-09 13:55:48',NULL),(21,0,'63030cd19212663030cd192127','AC Repairs',1,'Air-conditioning repair and maintenance services','category/ThjPkQWgDysTR8PNPzkWSpfy1fKGJPPVUxatUt65.jpg','2022-08-22 04:57:53','2022-09-09 13:55:18',NULL),(22,0,'6303b359321f46303b359321f7','Development & IT',1,'Computer services','category/Wa1fDTJqp02lKTBjXDoGxZt3zv09ix4poTCl1drK.webp','2022-08-22 16:48:25','2022-09-09 13:54:43',NULL),(23,0,'6303b3d3737ea6303b3d3737ec','Design & Creative',1,NULL,'category/mEOsx5iXMt3esLkuv7pzCydTvCCsxETdXeQeZZEQ.jpg','2022-08-22 16:50:27','2022-09-09 13:54:08',NULL),(24,0,'6303b40fb93cc6303b40fb93cf','Sales & Marketing',1,NULL,'category/Ot9C0bNTIi0Mq7v6I97IpAGviEli6159uYU9ouZl.jpg','2022-08-22 16:51:27','2022-09-09 13:53:17',NULL),(25,0,'6303b44cd67656303b44cd6767','Writing & Translation',1,NULL,'category/URcWPOlorPZkRqiwrP9INCa5HI5i7aUonsqnbREp.jpg','2022-08-22 16:52:28','2022-09-09 13:52:49',NULL),(26,0,'6303b48c42fa06303b48c42fa2','Administration & Customer Support',1,NULL,'category/Xr6pPxJg4povV8MT0pCoBCiB8nGV5uq7TmA2FobD.webp','2022-08-22 16:53:32','2022-09-09 13:52:20',NULL),(27,0,'6303b867e6e146303b867e6e15','Engineering & Architecture',1,NULL,'category/cBSGqdcLBYh0rf77TWfoEXJihMXYWAnGbDGlKvbU.jpg','2022-08-22 17:09:59','2022-09-09 13:51:51',NULL),(28,0,'6303b894654f96303b894654fb','Legal',1,NULL,'category/LIBuRrDlLHfni3tQkb6k1WgPI94mhlnd9oaVWqDM.jpg','2022-08-22 17:10:44','2022-09-09 12:32:24',NULL),(29,0,'6303ba10d35cf6303ba10d35d0','Home Help',1,'For help around the house','category/abiGPK2yISJR5bepFRCuK9qGUtJEKvZN6Aia6VL2.webp','2022-08-22 17:17:04','2022-09-09 06:45:23',NULL); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat_message_delete` -- DROP TABLE IF EXISTS `chat_message_delete`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chat_message_delete` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `chat_room_id` int DEFAULT '0', `chat_message_id` int NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat_message_delete` -- LOCK TABLES `chat_message_delete` WRITE; /*!40000 ALTER TABLE `chat_message_delete` DISABLE KEYS */; /*!40000 ALTER TABLE `chat_message_delete` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat_message_status` -- DROP TABLE IF EXISTS `chat_message_status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chat_message_status` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `chat_room_id` int DEFAULT '0', `chat_message_id` int NOT NULL, `is_read` int NOT NULL DEFAULT '1', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat_message_status` -- LOCK TABLES `chat_message_status` WRITE; /*!40000 ALTER TABLE `chat_message_status` DISABLE KEYS */; INSERT INTO `chat_message_status` VALUES (1,12,1,1,1,'2023-02-28 08:54:11',NULL,NULL),(2,14,1,1,1,'2023-02-28 08:54:11',NULL,NULL),(3,9,2,2,0,'2023-03-01 10:30:00',NULL,NULL),(4,22,2,2,1,'2023-03-01 10:30:00',NULL,NULL),(5,12,3,3,1,'2023-03-09 13:40:37',NULL,NULL),(6,11,3,3,1,'2023-03-09 13:40:37',NULL,NULL),(7,12,3,4,1,'2023-03-09 13:41:06',NULL,NULL),(8,11,3,4,1,'2023-03-09 13:41:06',NULL,NULL),(9,12,1,5,1,'2023-03-09 13:41:32',NULL,NULL),(10,14,1,5,0,'2023-03-09 13:41:32',NULL,NULL),(11,12,1,6,1,'2023-03-09 14:03:04',NULL,NULL),(12,14,1,6,0,'2023-03-09 14:03:04',NULL,NULL),(13,12,3,7,1,'2023-03-09 14:03:25',NULL,NULL),(14,11,3,7,1,'2023-03-09 14:03:25',NULL,NULL),(15,12,3,8,1,'2023-03-09 14:03:31',NULL,NULL),(16,11,3,8,0,'2023-03-09 14:03:31',NULL,NULL),(17,12,4,9,0,'2023-03-14 12:33:52',NULL,NULL),(18,18,4,9,1,'2023-03-14 12:33:52',NULL,NULL),(19,12,5,10,0,'2023-03-31 10:55:19',NULL,NULL),(20,33,5,10,1,'2023-03-31 10:55:19',NULL,NULL),(21,12,6,11,0,'2023-04-03 09:36:34',NULL,NULL),(22,3,6,11,1,'2023-04-03 09:36:34',NULL,NULL),(23,33,7,12,0,'2023-04-03 11:33:01',NULL,NULL),(24,37,7,12,1,'2023-04-03 11:33:01',NULL,NULL),(25,33,8,13,0,'2023-04-03 11:40:34',NULL,NULL),(26,37,8,13,1,'2023-04-03 11:40:34',NULL,NULL),(27,33,9,14,0,'2023-04-03 11:40:49',NULL,NULL),(28,37,9,14,1,'2023-04-03 11:40:49',NULL,NULL),(29,33,9,15,0,'2023-04-03 11:40:52',NULL,NULL),(30,37,9,15,1,'2023-04-03 11:40:52',NULL,NULL),(31,37,10,16,0,'2023-04-03 11:41:09',NULL,NULL),(32,33,10,16,1,'2023-04-03 11:41:09',NULL,NULL),(33,37,11,17,0,'2023-04-03 11:42:11',NULL,NULL),(34,33,11,17,1,'2023-04-03 11:42:11',NULL,NULL),(35,33,12,18,0,'2023-04-03 11:42:22',NULL,NULL),(36,37,12,18,1,'2023-04-03 11:42:22',NULL,NULL),(37,33,13,19,0,'2023-04-03 11:42:29',NULL,NULL),(38,37,13,19,1,'2023-04-03 11:42:29',NULL,NULL); /*!40000 ALTER TABLE `chat_message_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat_messages` -- DROP TABLE IF EXISTS `chat_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chat_messages` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `chat_room_id` int NOT NULL, `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `file_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `file_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `message_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text', `ip_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_anonymous` tinyint DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat_messages` -- LOCK TABLES `chat_messages` WRITE; /*!40000 ALTER TABLE `chat_messages` DISABLE KEYS */; INSERT INTO `chat_messages` VALUES (1,14,1,'Hi',NULL,NULL,'text',NULL,0,'2023-02-28 08:54:11',NULL,NULL),(2,22,2,'Hu',NULL,NULL,'text',NULL,0,'2023-03-01 10:30:00',NULL,NULL),(3,11,3,'Hhh',NULL,NULL,'text',NULL,0,'2023-03-09 13:40:37',NULL,NULL),(4,11,3,'Ggggg',NULL,NULL,'text',NULL,0,'2023-03-09 13:41:06',NULL,NULL),(5,12,1,'Ojihih',NULL,NULL,'text',NULL,0,'2023-03-09 13:41:32',NULL,NULL),(6,12,1,'Ok',NULL,NULL,'text',NULL,0,'2023-03-09 14:03:04',NULL,NULL),(7,11,3,'Tdyd',NULL,NULL,'text',NULL,0,'2023-03-09 14:03:25',NULL,NULL),(8,12,3,'Guvuuvuv',NULL,NULL,'text',NULL,0,'2023-03-09 14:03:31',NULL,NULL),(9,18,4,'Hi',NULL,NULL,'text',NULL,0,'2023-03-14 12:33:52',NULL,NULL),(10,33,5,'Hi',NULL,NULL,'text',NULL,0,'2023-03-31 10:55:19',NULL,NULL),(11,3,6,'Hiii',NULL,NULL,'text',NULL,0,'2023-04-03 09:36:34',NULL,NULL),(12,37,7,'Hi',NULL,NULL,'text',NULL,0,'2023-04-03 11:33:01',NULL,NULL),(13,37,8,'Ggg',NULL,NULL,'text',NULL,0,'2023-04-03 11:40:34',NULL,NULL),(14,37,9,' Ggcfg',NULL,NULL,'text',NULL,0,'2023-04-03 11:40:49',NULL,NULL),(15,37,9,'Gyhgg',NULL,NULL,'text',NULL,0,'2023-04-03 11:40:52',NULL,NULL),(16,33,10,'Hhh',NULL,NULL,'text',NULL,0,'2023-04-03 11:41:09',NULL,NULL),(17,33,11,'Touqeer',NULL,NULL,'text',NULL,0,'2023-04-03 11:42:11',NULL,NULL),(18,37,12,'Gdhdhhd',NULL,NULL,'text',NULL,0,'2023-04-03 11:42:22',NULL,NULL),(19,37,13,'Ggzg',NULL,NULL,'text',NULL,0,'2023-04-03 11:42:29',NULL,NULL); /*!40000 ALTER TABLE `chat_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat_room_users` -- DROP TABLE IF EXISTS `chat_room_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chat_room_users` ( `id` int NOT NULL AUTO_INCREMENT, `chat_room_id` int NOT NULL, `user_id` int NOT NULL, `is_owner` int NOT NULL DEFAULT '0', `last_chat_message_id` int DEFAULT '0', `last_message_timestamp` datetime DEFAULT NULL, `unread_message_counts` int DEFAULT '0', `is_anonymous` tinyint DEFAULT '0', `is_leave` int DEFAULT '0', `is_pin` int NOT NULL DEFAULT '0', `is_mute` int NOT NULL DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat_room_users` -- LOCK TABLES `chat_room_users` WRITE; /*!40000 ALTER TABLE `chat_room_users` DISABLE KEYS */; INSERT INTO `chat_room_users` VALUES (1,1,12,0,6,'2023-03-09 14:03:04',0,0,0,0,0,'2023-02-28 08:54:11',NULL,NULL),(2,1,14,1,6,'2023-03-09 14:03:04',2,0,0,0,0,'2023-02-28 08:54:11',NULL,NULL),(3,2,9,0,2,'2023-03-01 10:30:00',1,0,0,0,0,'2023-03-01 10:30:00',NULL,NULL),(4,2,22,1,2,'2023-03-01 10:30:00',0,0,0,0,0,'2023-03-01 10:30:00',NULL,NULL),(5,3,12,0,8,'2023-03-09 14:03:31',0,0,0,0,0,'2023-03-09 13:40:37',NULL,NULL),(6,3,11,1,8,'2023-03-09 14:03:31',1,0,0,0,0,'2023-03-09 13:40:37',NULL,NULL),(7,4,12,0,9,'2023-03-14 12:33:52',1,0,0,0,0,'2023-03-14 12:33:52',NULL,NULL),(8,4,18,1,9,'2023-03-14 12:33:52',0,0,0,0,0,'2023-03-14 12:33:52',NULL,NULL),(9,5,12,0,10,'2023-03-31 10:55:19',1,0,0,0,0,'2023-03-31 10:55:19',NULL,NULL),(10,5,33,1,10,'2023-03-31 10:55:19',0,0,0,0,0,'2023-03-31 10:55:19',NULL,NULL),(11,6,12,0,11,'2023-04-03 09:36:34',1,0,0,0,0,'2023-04-03 09:36:34',NULL,NULL),(12,6,3,1,11,'2023-04-03 09:36:34',0,0,0,0,0,'2023-04-03 09:36:34',NULL,NULL),(13,7,33,0,12,'2023-04-03 11:33:01',1,0,0,0,0,'2023-04-03 11:33:01',NULL,NULL),(14,7,37,1,12,'2023-04-03 11:33:01',0,0,0,0,0,'2023-04-03 11:33:01',NULL,NULL),(15,8,33,0,13,'2023-04-03 11:40:34',1,0,0,0,0,'2023-04-03 11:40:34',NULL,NULL),(16,8,37,1,13,'2023-04-03 11:40:34',0,0,0,0,0,'2023-04-03 11:40:34',NULL,NULL),(17,9,33,0,15,'2023-04-03 11:40:52',2,0,0,0,0,'2023-04-03 11:40:49',NULL,NULL),(18,9,37,1,15,'2023-04-03 11:40:52',0,0,0,0,0,'2023-04-03 11:40:49',NULL,NULL),(19,10,37,0,16,'2023-04-03 11:41:09',1,0,0,0,0,'2023-04-03 11:41:09',NULL,NULL),(20,10,33,1,16,'2023-04-03 11:41:09',0,0,0,0,0,'2023-04-03 11:41:09',NULL,NULL),(21,11,37,0,17,'2023-04-03 11:42:11',1,0,0,0,0,'2023-04-03 11:42:11',NULL,NULL),(22,11,33,1,17,'2023-04-03 11:42:11',0,0,0,0,0,'2023-04-03 11:42:11',NULL,NULL),(23,12,33,0,18,'2023-04-03 11:42:22',1,0,0,0,0,'2023-04-03 11:42:22',NULL,NULL),(24,12,37,1,18,'2023-04-03 11:42:22',0,0,0,0,0,'2023-04-03 11:42:22',NULL,NULL),(25,13,33,0,19,'2023-04-03 11:42:29',1,0,0,0,0,'2023-04-03 11:42:29',NULL,NULL),(26,13,37,1,19,'2023-04-03 11:42:29',0,0,0,0,0,'2023-04-03 11:42:29',NULL,NULL); /*!40000 ALTER TABLE `chat_room_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat_rooms` -- DROP TABLE IF EXISTS `chat_rooms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chat_rooms` ( `id` int NOT NULL AUTO_INCREMENT, `identifier` varchar(200) NOT NULL, `created_by` int NOT NULL, `title` varchar(200) DEFAULT NULL, `slug` varchar(200) DEFAULT NULL, `image_url` text, `description` text, `status` int NOT NULL DEFAULT '1', `type` enum('single','group') NOT NULL, `member_limit` int NOT NULL DEFAULT '0', `is_anonymous` tinyint DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat_rooms` -- LOCK TABLES `chat_rooms` WRITE; /*!40000 ALTER TABLE `chat_rooms` DISABLE KEYS */; INSERT INTO `chat_rooms` VALUES (1,'single-1677574451-1677574451',14,'single-1677574451','single-1677574451','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-02-28 08:54:11',NULL,NULL),(2,'single-1677666600-1677666600',22,'single-1677666600','single-1677666600','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-03-01 10:30:00',NULL,NULL),(3,'single-1678369237-1678369237',11,'single-1678369237','single-1678369237','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-03-09 13:40:37',NULL,NULL),(4,'single-1678797232-1678797232',18,'single-1678797232','single-1678797232','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-03-14 12:33:52',NULL,NULL),(5,'single-1680260119-1680260119',33,'single-1680260119','single-1680260119','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-03-31 10:55:19',NULL,NULL),(6,'single-1680514594-1680514594',3,'single-1680514594','single-1680514594','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-04-03 09:36:34',NULL,NULL),(7,'single-1680521581-1680521581',37,'single-1680521581','single-1680521581','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-04-03 11:33:01',NULL,NULL),(8,'single-1680522034-1680522034',37,'single-1680522034','single-1680522034','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-04-03 11:40:34',NULL,NULL),(9,'single-1680522049-1680522049',37,'single-1680522049','single-1680522049','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-04-03 11:40:49',NULL,NULL),(10,'single-1680522069-1680522069',33,'single-1680522069','single-1680522069','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-04-03 11:41:09',NULL,NULL),(11,'single-1680522131-1680522131',33,'single-1680522131','single-1680522131','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-04-03 11:42:11',NULL,NULL),(12,'single-1680522141-1680522141',37,'single-1680522141','single-1680522141','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-04-03 11:42:22',NULL,NULL),(13,'single-1680522149-1680522149',37,'single-1680522149','single-1680522149','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',0,0,'2023-04-03 11:42:29',NULL,NULL); /*!40000 ALTER TABLE `chat_rooms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cms_module_permissions` -- DROP TABLE IF EXISTS `cms_module_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cms_module_permissions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `cms_role_id` bigint unsigned NOT NULL, `cms_module_id` bigint unsigned NOT NULL, `is_add` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `is_view` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `is_update` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `is_delete` enum('1','0') CHARACTER SET utf8mb4 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 AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cms_module_permissions` -- LOCK TABLES `cms_module_permissions` WRITE; /*!40000 ALTER TABLE `cms_module_permissions` DISABLE KEYS */; INSERT INTO `cms_module_permissions` VALUES (23,2,1,'0','0','0','0','2022-08-04 13:44:20',NULL,NULL),(24,2,2,'0','0','0','0','2022-08-04 13:44:20',NULL,NULL),(25,2,3,'1','1','1','1','2022-08-04 13:44:20',NULL,NULL),(26,2,4,'1','1','1','1','2022-08-04 13:44:20',NULL,NULL),(27,2,5,'1','1','1','1','2022-08-04 13:44:20',NULL,NULL),(28,2,6,'1','1','1','1','2022-08-04 13:44:20',NULL,NULL),(29,2,7,'1','1','1','1','2022-08-04 13:44:20',NULL,NULL),(30,2,12,'0','0','0','0','2022-08-04 13:44:20',NULL,NULL),(31,2,13,'0','1','0','0','2022-08-04 13:44:20',NULL,NULL),(32,2,14,'0','1','1','0','2022-08-04 13:44:20',NULL,NULL),(33,2,8,'0','0','0','0','2022-08-04 13:44:20',NULL,NULL),(34,2,9,'1','1','1','1','2022-08-04 13:44:20',NULL,NULL),(35,2,10,'1','1','1','1','2022-08-04 13:44:20',NULL,NULL),(36,2,11,'1','1','1','1','2022-08-04 13:44:20',NULL,NULL); /*!40000 ALTER TABLE `cms_module_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cms_modules` -- DROP TABLE IF EXISTS `cms_modules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cms_modules` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `parent_id` int NOT NULL DEFAULT '0', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `route_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fa fa-list', `status` enum('1','0') CHARACTER SET utf8mb4 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=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cms_modules` -- LOCK TABLES `cms_modules` WRITE; /*!40000 ALTER TABLE `cms_modules` DISABLE KEYS */; INSERT INTO `cms_modules` VALUES (1,0,'Cms Roles Management','cms-roles-management.index','fa fa-key','1',1.00,'2022-01-20 14:00:06',NULL,NULL),(2,0,'Cms Users Management','cms-users-management.index','fa fa-users','1',2.00,'2022-01-20 14:00:06',NULL,NULL),(3,0,'Freelancer Management','freelancer-management.index','fa fa-users','1',3.00,'2022-01-20 14:00:06',NULL,NULL),(4,0,'Booking Management','booking-management.index','fa fa-tags','1',7.00,'2022-01-20 14:00:06',NULL,NULL),(5,0,'Category Management','category-management.index','fa fa-tag','1',9.00,'2022-01-20 14:00:06',NULL,NULL),(6,0,'Skill Management','skill-management.index','fa fa-tasks','1',11.00,'2022-01-20 14:00:06',NULL,NULL),(7,0,'Dispute Management','dispute-management.index','fa fa-list','1',8.00,'2022-01-20 14:00:06',NULL,NULL),(8,0,'Application Setting','admin.application-setting','fa fa-cog','1',14.00,'2022-01-20 14:00:06',NULL,NULL),(9,0,'Users Management','app-users.index','fa fa-users','1',6.00,'2022-01-20 14:00:06',NULL,NULL),(10,0,'Content Management','content-management.index','fa fa-pencil','1',12.00,'2022-01-20 14:00:06',NULL,NULL),(11,0,'FAQ`s','faq.index','fa fa-question-circle-o','1',13.00,'2022-01-20 14:00:06',NULL,NULL),(12,0,'Gig Management','gig-management.index','fa fa-pencil','1',10.00,'2022-01-20 14:00:06',NULL,NULL),(13,0,'Freelancer Billing A/c','user-billing-account.index','fa fa-money','1',4.00,'2022-01-20 14:00:06',NULL,NULL),(14,0,'Freelancer Cashout ','user-cashout-request.index','fa fa-university','1',5.00,'2022-01-20 14:00:06',NULL,NULL); /*!40000 ALTER TABLE `cms_modules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cms_roles` -- DROP TABLE IF EXISTS `cms_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cms_roles` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_super_admin` enum('1','0') CHARACTER SET utf8mb4 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cms_roles` -- LOCK TABLES `cms_roles` WRITE; /*!40000 ALTER TABLE `cms_roles` DISABLE KEYS */; INSERT INTO `cms_roles` VALUES (1,'Super Admin','super-admin','1','2022-01-20 14:00:05',NULL,NULL),(2,'Admin','admin','0','2022-02-16 06:32:36','2022-08-04 13:44:20',NULL); /*!40000 ALTER TABLE `cms_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cms_users` -- DROP TABLE IF EXISTS `cms_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cms_users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `cms_role_id` bigint unsigned NOT NULL, `user_ref_id` int NOT NULL DEFAULT '0', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mobile_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `remember_token` varchar(100) CHARACTER SET utf8mb4 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cms_users` -- LOCK TABLES `cms_users` WRITE; /*!40000 ALTER TABLE `cms_users` DISABLE KEYS */; INSERT INTO `cms_users` VALUES (1,1,0,'RetroCube','retrocube','retrocube','admin@retrocube.com','1-8882051816','$2y$10$uncLchdn4SPPVNt2B2adl.Sw.Y/fAKDxiBcQiB1ZbBViXDsiNAyCO',NULL,'1',NULL,'2022-01-20 14:00:06',NULL,NULL),(2,2,0,'Admin','admin','admin','admin@gigme.com','+1-238749912','$2y$10$uncLchdn4SPPVNt2B2adl.Sw.Y/fAKDxiBcQiB1ZbBViXDsiNAyCO','cms_user/q7pEionDYFWOBS38LQCp8KaStfIQekhGU37kCtQq.png','1',NULL,'2022-02-16 06:33:09','2022-09-08 07:52:08',NULL); /*!40000 ALTER TABLE `cms_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cms_widget_role` -- DROP TABLE IF EXISTS `cms_widget_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cms_widget_role` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `cms_widget_id` bigint unsigned NOT NULL, `cms_role_id` bigint 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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cms_widget_role` -- LOCK TABLES `cms_widget_role` WRITE; /*!40000 ALTER TABLE `cms_widget_role` DISABLE KEYS */; INSERT INTO `cms_widget_role` VALUES (1,1,2,'2022-02-16 06:32:36',NULL,NULL),(2,2,2,'2022-02-16 06:32:36',NULL,NULL),(3,3,2,'2022-02-16 06:32:36',NULL,NULL),(4,4,2,'2022-02-16 06:32:36',NULL,NULL),(5,5,2,'2022-02-16 06:32:36',NULL,NULL); /*!40000 ALTER TABLE `cms_widget_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cms_widgets` -- DROP TABLE IF EXISTS `cms_widgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cms_widgets` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `icon` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `color` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `div_column_class` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `widget_type` enum('small_box','line_chart','bar_chat','pie_chart','map_chart') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `sql` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('1','0') CHARACTER SET utf8mb4 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cms_widgets` -- LOCK TABLES `cms_widgets` WRITE; /*!40000 ALTER TABLE `cms_widgets` DISABLE KEYS */; INSERT INTO `cms_widgets` VALUES (1,'Total User',NULL,'icon-user','#4b71fa','col-md-3','/admin/app-users','small_box','Select count(*) from users limit 1','','1',NULL,NULL,NULL),(2,'Total Freelancer',NULL,'icon-people','#7bcb4d','col-md-3','/admin/app-users','small_box','Select count(*) from users where user_group_id = 2 limit 1','','1',NULL,NULL,NULL),(3,'Total Roles',NULL,'icon-user','#4b71fa','col-md-3','/admin/app-users','small_box','Select count(*) from user_groups','','1',NULL,NULL,NULL),(4,'Total Gigs',NULL,'fa fa-book','#7bcb4d ','col-md-3','/admin/app-users','small_box','Select count(*) from gigs limit 1','','1',NULL,NULL,NULL),(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','','1',NULL,NULL,NULL); /*!40000 ALTER TABLE `cms_widgets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `content_management` -- DROP TABLE IF EXISTS `content_management`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `content_management` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` int 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `content_management` -- LOCK TABLES `content_management` WRITE; /*!40000 ALTER TABLE `content_management` DISABLE KEYS */; INSERT INTO `content_management` VALUES (1,'Terms Condition','terms-condition','
1.       Introduction
 
1.1.    GIGMEHQ, is a limited liability company registered in the United Arab Emirates (UAE), trading under the name GIGMEHQ, as defined under the Privacy Policy, and as available on the GIGMEHQ website and mobile application, for further information click, Privacy Policy. GIGMEHQ with its registered offices located in Abu Dhabi, United Arab Emirates (hereby referred to as “GIGMEHQ”). GIGMEHQ, provides these terms and conditions to inform its users; freelancer, buyers, and other visitors browsing the application (collectively referred to as “Users”) of the terms of service regarding the procedures, policies and use of the GIGMEHQ website or mobile application, (hereby referred to as “GIGMEHQ Platforms”). By accessing and/or using the GIGMEHQ Platforms and/or registering for a GIGMEHQ account, you hereby agree to the GIGMEHQ terms and conditions and Privacy Policy, including but not limited to; our collection, use, disclosure, processing and retention of personal information and any similar action, thereof. (hereby referred to as “Terms of Service”). These Terms of Service, governs and guides your access to and use of the GIGMEHQ Platforms, including any content, function and services offered onto the GIGMEHQ Platforms. 
 
1.2.    By using the GIGMEHQ Platforms, opening an account, or by clicking to accept or agree to the Terms of Service, you hereby irrevocably accept and agree, on behalf of yourself or on behalf of any party which you represent, to be legally bound by and abide by the following Terms of Service, which includes without limitation our Privacy Policy, of which is incorporated herein by reference. If you do not want to agree to these Terms of Service and Privacy Policy, you must not access or use the GIGMEHQ Platforms. By using the GIGMEHQ Platforms, you represent and warrant that you are of legal age to form a binding agreement and meet all of the foregoing eligibility requirements. If you do not meet all of these requirements, you must not access or use the GIGMEHQ Platforms.
 
1.3.    Our Customer Support team is available 24/7 if you have any inquiries regarding any of the GIGMEHQ Platforms or its Terms of Service and/or Privacy Policy. Users can contact our Customer Care team by emailing GIGMEHQ at support@GIGMEHQ.com . 
 
1.4.    The original language of these Terms of Service, as well as all other texts throughout the GIGMEHQ Platforms, is English. In case of conflicts between the original English version and any translation, the English version shall prevail.
 
1.5.    The GIGMEHQ Platforms is offered subject to your acceptance without modification of all the Terms of Service, contained herein and all other operating rules, policies including, without limitation, the Privacy Policy and procedures that may be published from time to time on this or any GIGMEHQ Platform. 

2.      License to use GIGMEHQ Platforms; 
2.1.1.In direct accordance with the acceptance of these Terms of Service, Privacy Policy and any of the relevant laws of the Federal Laws of the United Arab Emirates (hereby referred to as the“Relevant Laws”), Users hereby declare, the following;
 
2.1.2.  In relation to, all copyrights and other intellectual property rights or anything related to GIGMEHQ Platforms; (including all new releases and updates) shall accrue exclusively to GIGMEHQ. The User shall receive a right to use the GIGMEHQ Platforms, in accordance with the following Terms of Service.  
 
2.1.3.The User may reproduce the software insofar as is necessary for use of the software within the scope of the license. Necessary reproductions include the installation of the software on the agreed number of computers as well as the loading into the random access memory (RAM) of the computers. The Licensee may transfer the software from one computer to another provided the agreed number of installations is not thus exceeded. 
 
2.1.4. The Licensee may make necessary back-up copies of the software. A back-up copy on a movable data medium shall be designated as such and a copyright notice affixed to it. The Licensee may not modify or remove copyright notices within the software or other features serving to identify the program.

3.      Registration, Use and Switch of User Accounts; 
3.1.1. Once an individual opens up any of the GIGMEHQ Platforms he/she may register for an account within GIGMEHQ Platforms by completing and submitting the account registration form on our GIGMEHQ Website, and clicking on the verification link in the email that GIGMEHQ will send to you.
3.1.2.Users may not allow any other person to use their account to access any of the GIGMEHQ Platforms.
3.1.3.Users must notify GIGMEHQ in writing immediately if he/she becomes aware of any unauthorized use of their account.
3.1.4.Users must not use any other person\'s account to access any GIGMEHQ Platform. 
3.1.5.Users can either be; User (freelancer)/s or client/s. Upon the GIGMEHQ account registration as per Section 3.1.1, the User may choose/switch between either User options upon their desired needs from the GIGMEHQ Platform. 
3.1.6.In accordance to Section 3.1.5 above, The User may switch account types, pending the satisfaction of regulatory requirements as per the Relevant Laws and the payment of fees necessary as per Section 7, below. The User hereby acknowledges and accepts that once the switch in accounts has been made, this shall be a permanent switch and shall be dealt with by GIGMEHQ according to said switch in accounts. 

4.      User Login Details and Account Security;
4.1.    Upon the registration of an account within the GIGMEHQ Platforms, GIGMEHQ will provide you with or ask the User to choose his/her username and password. Therefore in accordance with the above, the User hereby agrees to the following; 
4.1.1.1.              User ID must not be liable to mislead and must comply with the content rules set  out these Terms of Service.
4.1.1.2.              To not use your account or user ID for or in connection with the impersonation of  any person. 
4.1.1.3.              To keep their password confidential.
4.1.1.4.              To notify GIGMEHQ in writing immediately if they become aware of any disclosure of their password.
4.1.1.5.              To accept the responsibility for any activity on GIGMEHQ Platforms arising out of any failure to keep your password confidential, and may be held liable for any losses arising out of such a failure.

5.      Cancellation and Suspension of Account; 
5.1.    Users may at anytime and in their sole discretion without notice or explanation cancel their account, subject only to the satisfaction of payment terms as set out in Section 7, below. 
5.2.    GIGMEHQ may in accordance with these Terms of Service suspend a User account as it deems fit for the violation/breach of any and/or all sections of these Terms of Service.  
5.3.    Users may cancel their account on the GIGMEHQ Website using the User account control panel on the GIGMEHQ Website. 

6.      Uploaded Content and Intellectual Property Rights; 
6.1.    In these Terms of Service, any and all works and materials (including without limitation; text, graphics, images, audio material, video material, audio-visual material, scripts, software and files) that you submit to us or any GIGMEHQ Platform for storage or publication on, processing by, or transmission via, our website. (Hereby collectively referred to as “Uploaded Content”) 
6.2.    Users hereby grant to GIGMEHQ, a worldwide, irrevocable, non-exclusive, royalty-free license to; use, reproduce, store, adapt, publish, translate and distribute your content in any existing or future media, and/or reproduce, store and publish your content on and in relation to any GIGMEHQ Platform and any successor platforms created by GIGMEHQ. 
6.3.    Users hereby grant to GIGMEHQ, the right to bring an action for infringement of the rights licensed.
6.4.    Users hereby waive all moral rights within the Uploaded Content to the maximum extent permitted by the Relevant Laws; and you warrant and represent that all other moral rights in your content have been waived to the maximum extent permitted by the Relevant Laws. 
6.5.    Users may edit the Uploaded Content to the extent permitted using the editing functionality made available on GIGMEHQ Platforms. 
6.6.    Without prejudice to other rights under these Terms of Service, if you breach any provision of these Terms of Service in any way, or if we reasonably suspect that you have breached these Terms of Service in any way, we may delete, unpublish or edit any or all of the Uploaded Content.
6.7.    Users warrant and represent that your content will comply with these Terms of Service.
6.8.    Uploaded Content must not be illegal or unlawful, must not infringe any person’s legal rights, and must not be capable of giving rise to legal action against any person (in each case in any jurisdiction and under the Relevant Laws). 
6.9.    Uploaded Content and the use of the content in accordance with these Terms of Service, must not be; libelous and/or maliciously false, obscene and/or indecent; infringe any copyright, moral right, database rights, trademark rights, design rights, rights in passing off, or any other intellectual property right, infringe any of confidence, right of privacy or right under data protection legislation, constitute negligent advice or contain any negligent statement, therein.
6.9.1.Uploaded Content and the use of the content in accordance with these Terms of Service, must not; constitute an incitement to commit a crime, instructions for the commission of a crime or the promotion of criminal activity, be in contempt of any court, or in breach of any court order, breach of any racial or religious hatred or discrimination legislation, be blasphemous, breach of official secret legislations, breach of any contractual obligation owed to any person, depict violence, in an explicit, graphic or gratuitous manner, offensive deceptive, fraudulent, threatening, abusive, harassing, anti-social, menacing, hateful, discriminatory, cause annoyance, inconvenience, needless anxiety to any person, pornographic, suggestive or sexually explicit, be true, false, inaccurate or misleading. 

7.      Payment, Fees and Refunds; 
7.1.    By agreeing upon the Terms of Services, and once the User is a registered User of the GIGMEHQ Platforms, be it a User (freelancer) or Buyer, you hereby agree to pay the annual and monthly fees as per schedule below, (Section 7.5).
7.2.    Payments will be due as of the first day you sign up for a GIGMEHQ Platform Service, and will cover an annual period, as indicated when signing up.
7.3.    Configurations and prices of the GIGMEHQ Platform Services are subject to change at any time, and GIGMEHQ shall at all times be entitled to modify configurations, fees, prices and quotations, provided that no price changes shall be made applicable to you during a subscription term, and shall only take effect after GIGMEHQ and the User have agreed upon an extension, upgrade or renewal of the subscription term.
7.4.    The monetary amount of, thirty (25) AED will be deducted on your total weekly accepted and paid jobs as bank transfer charges.
 
GIGMEHQ Membership Packages
7.5.    Users can choose from each of the three membership packages as described in the table below (Hereby referred to as “GIGMEHQ Membership Packages”); 
Membership Package Categories Fees (AED) Fee Payment Term Applicable Fees
Basic NO CHARGE NO TERM Section 7.6 applicable
Gold 26.0 Monthly Section 7.6 applicable
Platinum 37.0 Monthly Section 7.6 applicable
  
7.6.   Service Fees;  
7.6.1.1.     GIGMEHQ shall deduct a fixed percentage of (15%) for all Membership Package Categories, as detailed in Section 7.5, above. Said percentage will be deducted from the User (freelancer)s invoice per order/service.  
7.7.   Refunds; 
7.7.1.1.      Users may request a refund within 48 hours or two (2) days from the time of the order/service has been paid on GIGMEHQ. This shall exclude without limitation or exception, the Applicable Fees and any other charge as GIGMEHQ deems fit. 
7.7.1.2.        Upon satisfaction of refund conditions, GIGMEHQ may agree to the refund, the User will receive the funds via the same payment method(s) that they used to make the original payment to GIGMEHQ.
7.7.1.3.         GIGMEHQ may refund funds to a User irrespective of whether a User has requested funds be refunded, upon the satisfaction of the following; 
7.7.1.3.1.       GIGMEHQ is required by law or by arbitration award; and/or
7.7.1.3.2.        GIGMEHQ determine that refunding funds to a User will avoid any unnecessary dispute; and/or
7.7.1.3.3.        GIGMEHQ refund funds to a User in accordance with any refund policy specified by GIGMEHQ; and/or
7.7.1.3.4.         GIGMEHQ and any relevant third party (i.e Bank Compliance Department) find out that the original payment made by User is fraudulent; and/or 
7.7.1.3.5.          User has made a duplicate payment in error; and/or
7.7.1.3.6.          GIGMEHQ consider, in its sole opinion, that it is likely that the refund of funds is necessary to avoid a credit card chargeback. 
7.7.1.4.          Users may request a refund by emailing us at support@GIGMEHQ.com .
7.7.1.5.          Once a User has made a Payment a User expressly agrees to use the dispute resolution as described in Section (15) of these Terms of Service, process and expressly agree to be bound by its ruling and expressly agree not to initiate any chargeback request with card issuer.
7.7.1.6.              If User initiates any chargeback request or similar process, a User expressly agrees and consents GIGMEHQ to share any and all information in relation to your agreement to these Terms of Service, in order to defeat any such chargeback request.
7.7.1.7.              If GIGMEHQ reasonably suspects, having considered all the relevant circumstances, that User has made an excessive or unreasonable number of requests to refund funds back or chargebacks, GIGMEHQ may suspend, limit or close the User Account. 

8.      Payment Services & Fund Transfer; 
8.1.    User (freelancer) Transfer Method Fee: Upon the Users (User (freelancer)) request, funds are to be disbursed via a wire transfer, a User (freelancer) Transfer Method Fee will be charged to the User (User (freelancer)). 
8.2.    GIGMEHQ Invoice Service; enables Users (User (freelancer)s) to issue invoices and enables User (client) to make payments for services.
8.3.    All transfers shall be made through the use of MY FATOORAH payment gateway.
8.4.    Users (User (freelancer)s) will complete the electronic invoice form (the \"Invoice\") and submit it to GIGMEHQ via the GIGMEHQ Website. A User (User (freelancer)s) must complete and submit an Invoice to GIGMEHQ for each and every payment.
8.5.    MY FATOORAH; enables User (client) to transfer certain payment responsibilities to GIGMEHQ.
8.6.    At a User’s (client’s) request, upon payment to GIGMEHQ for services rendered by another User (User (freelancer)), GIGMEHQ will assume responsibility for the payment for such User’s (User (freelancer)\'s) services (this will be subject to less Service Fee upon GIGMEHQ’s sole discretion). 
8.7.    GIGMEHQ agrees not to pay User (User (freelancer)) for services until after the occurrence of a User’s (client) acceptance and confirmation of the User’s services. The User acknowledges that such funds will belong to GIGMEHQ immediately upon transfer of funds to GIGMEHQ. 
8.8.    Upon the unsatisfaction of services rendered between Users and the User (client) has paid for, the User (User (freelancer)) may notify GIGMEHQ within (15) fifteen days from confirmation of order between Users. 
8.9.    GIGMEHQ will attempt to resolve the concerns within (7) seven days from date of notification.
8.10.    GIGMEHQ agrees to keep Users informed as to the status of the Assumed Payment Liability.
8.11.      In case User (client) terminates the engagement prior to work completion without proper reason or justification, the User (client) will still be obligated to pay the work fee for the User (User (freelancer)) and GIGMEHQ and the Applicable Fees and Charges for work done, and for expenses and disbursements incurred, up to the date of termination, plus any transaction fee charged by GIGMEHQ, thereof. 
8.12.      If User reasonably disputes the quality or completion of services provided by such User (freelancer), then User agree that GIGMEHQ shall have no payment obligations to any party related to relevant fees. 
8.13.     To receive due funds; the User must request such funds and indicate your  selection of the funds transfer methods available on the Application. Any such requests shall be subject to the conditions and restrictions contained on the Application and in these Terms of Service. Notwithstanding any other provision of these Terms of Service, if GIGMEHQ determines in its sole discretion that a Registered User has violated the conditions and restrictions of the Application or Terms of Service, GIGMEHQ has the right to refuse to process such request.
8.14.      Hold On Transfers; GIGMEHQ,reserves the right, at its sole discretion, to place a hold on requested transfers if GIGMEHQ suspects funds may be subject to charge back, bank reversal, failure to clear or fraud. GIGMEHQ  will release a Hold On Transfers, as it deems fit. 
8.15.         Release and Delivery of Amounts to GIGMEHQ; Users hereby irrevocably authorize and instruct GIGMEHQ to release applicable portions of the Fixed Price GIGMEHQ Account (each portion, a “Release”) to User Account, as applicable, upon the occurrence of and in accordance with one or more Release Conditions provided below or as otherwise required by the Relevant Laws or the Terms of Service. The amount of the Release will be delivered to the applicable User Account in accordance with Users instructions, as applicable.
8.16.                      Release and Delivery of Amounts from GIGMEHQ; GIGMEHQ shall release the amount due to the User (User (freelancer)) within the minimum time of (20) twenty working days and a maximum time of (40) forty working days.
8.17.                      Release Conditions; shall hold the meaning as follows; 
8.17.1.1.           User (client) clicks to release funds to User (User (freelancer)).
8.17.1.2.           User (client) does not take any action for (7) days from the date of a User (freelancer)’s Release request, in which case User (freelancer) and User (client) agree that GIGMEHQ is authorized and irrevocably instructed to immediately release to User (freelancer) the amount associated with to the applicable milestone in connection with such Release request.
8.17.1.3.           User (freelancer) cancels the service contract before a milestone payment has been released to User (freelancer), in which case the funds are to be returned to the User (client).
8.17.1.4.           User (client) and User (freelancer) have submitted joint written instructions for a Release to either User Account, as applicable.
8.17.1.5.           User (client) and User (freelancer) agree to close the contract without release of funds, in which case the funds are to be returned to the User (client).
 
9.       Limitation of Liability and Warranty; 
9.1.    GIGMEHQ hereby declares that the limitations and exclusions of liability as set out in these Terms of Service shall include but not be limited to; 
9.1.1. All liabilities arising under these Terms of Service and Privacy Policy, including liabilities arising in contract, and for breach of statutory duty, except to the extent expressly provided otherwise in these Terms of Service.
9.1.2. To the extent that the GIGMEHQ Platforms and the information and services provided are utilized, we will not be liable for any loss or damage of any nature. 
9.1.3.  Any and all liability to Users in respect of any losses arising out of any event or events beyond our reasonable control.
9.1.4.   Any liability and all to Users in respect of any business losses, including without limitation; loss of or damage to profits, income, revenue, use, production, anticipated savings, business, contracts and commercial opportunities. 
9.1.5.   Any liability to Users in respect of any loss or corruption of any data, database or software. 
9.1.6.   Any liability to Users in respect of any special, indirect or consequential loss or damage.
9.2.    Users hereby accept that GIGMEHQ have an interest in limiting the personal liability of GIGMEHQ; employees, managers, consultants, partners or any person who formulates part of the GIGMEHQ team (hereby collectively referred to as “GIGMEHQ Team”). Having regard to that interest, you acknowledge that we are a limited liability entity; you agree that you will not bring any claim personally against GIGMEHQ Team in respect of any losses you suffer in connection with the GIGMEHQ Platforms, this will not, limit or exclude the liability of the limited liability entity itself for the acts and omissions of our GIGMEHQ Team. 
9.3.    Further to Sub-sections (9.1 and 9.2), GIGMEHQ hereby declares that we do not warrant or represent;
9.3.1.1.              The completeness or accuracy of the information published on GIGMEHQ Platforms or the material on the GIGMEHQ Platforms is up to date; or that any service will remain available.
9.3.1.2.              We further reserve the right to discontinue or alter any or all of our GIGMEHQ Platform services, at any time in our sole discretion without notice or explanation; and save to the extent expressly provided otherwise in these Terms of Service, you will not be entitled to any compensation or other payment upon the discontinuance or alteration of any GIGMEHQ Website services, or if we stop publishing the GIGMEHQ Website.
9.3.1.3.              To the maximum extent permitted by the Relevant Laws and/or any applicable laws; we exclude all representations and warranties relating to the subject matter of these Terms of Service, in relation to the GIGMEHQ Platforms. 
 
10.  Breach of Terms of Service; 
10.1.   Without prejudice to GIGMEHQ’s other rights under these Terms of Service, if the User breaches these Terms of Service in any way, or if GIGMEHQ reasonably suspect that the User has breached these Terms of Service. GIGMEHQ reserves the right to; 
10.1.1.              Temporarily suspend your access to GIGMEHQ Platforms; and
10.1.2.              Permanently prohibit you from accessing GIGMEHQ Platforms;
10.1.3.              Send you one or more formal warnings; and 
10.1.4.              Block computers using your IP address from accessing the GIGMEHQ Website;
10.1.5.              Contact any and all of our Internet service providers to request that they block access to GIGMEHQ Platforms. 
10.1.6.              Commence legal action against you, whether for breach of contract or otherwise; and/or
10.1.7.              Suspend or delete your account on our GIGMEHQ Website.
10.2.   Whereby in accordance with subsection (10.1.7) above; we suspend or prohibit or block your access to GIGMEHQ Platforms or a part of it, you must not take any action to elude such suspension and/or prohibition and/or blocking including without limitation; creating and/or using a different account. 

11.  Variations; 
11.1.   The revised Terms of Service shall apply to the use of all GIGMEHQ Platforms, from the date of publication of the revised Terms of Service on any GIGMEHQ Platform, and you hereby waive any right you may otherwise have to be notified of, or to consent to, revisions of these Terms of Service.
11.2.    GIGMEHQ will give you written notice of any revision of these Terms of Service, and the revised Terms of Service will apply to the use of our GIGMEHQ Website from the date that we give you such notice; if you do not agree to the revised Terms of Service, you have prohibited from accessing any and all GIGMEHQ Platforms. 
11.3.   If you have given your express agreement to these Terms of Service, we will ask for your express agreement to any revision of these Terms of Service; and if you do not give your express agreement to the revised Terms of Service within such period as we may specify, we will disable or delete your account on GIGMEHQ Platforms, additionally the User must stop using said GIGMEHQ Platforms. 

12.  Violations; 
12.1.        If the User comes across any content that may violate our Terms of Service and/or our Community Standards, you should report it to us through the appropriate channels created to handle those issues as outlined in our Terms of Service. Our team reviews all cases. To protect individual privacy, the results of the investigation are not shared. You can review our Privacy Policy for more information. 
12.2.        Users may receive a warning to their account for violations of our Terms of Service. A warning will be sent to the User\'s email and will be displayed for such User on the GIGMEHQ Website. 
12.3.                      Non Permitted Usage; 
12.4.       GIGMEHQ hereby declares that it will take all necessary legal and functional action needed against the User for the nullification and resolution of any non permitted action of the GIGMEHQ Platforms, these non permitted actions shall include without limitation; 
12.4.1.              Adult Services & Pornography – GIGMEHQ hereby does not allow any exchange of adult oriented or pornographic materials and services.
12.4.2.              Inappropriate Behavior & Language - Communication on any GIGMEHQ Platform should be respectful, constructive, and professional. GIGMEHQ hereby condemns bullying, harassment, and hate speech towards fellow Users. 
12.4.3.              Phishing and Spam – Any and all attempts to publish or send malicious content with the intent to compromise another Users account or computer environment is strictly prohibited. 
12.4.4.              Privacy & Identity - You may not publish or post other people\'s private and confidential information. Any exchange of personal information required for the completion of a service and shall not be used for any purpose whatsoever other than for the delivery of the work.
12.4.5.              These Terms of Service will not protect any Users who engage and communicate off of GIGMEHQ Platforms.
12.4.6.              Fraud / Unlawful Use - You may not use GIGMEHQ for any unlawful purposes or to conduct illegal activities.
12.4.7.              Multiple Accounts - To prevent fraud and abuse, Users are limited to one active GIGMEHQ account. Any additional account created to circumvent guidelines, promote competitive advantages, or mislead the GIGMEHQ User’s, will be disabled. 
12.4.8.              Targeted Abuse - GIGMEHQ do not tolerate Users who engage in targeted abuse or harassment towards other users on GIGMEHQ. This includes creating new multiple accounts to harass members through our message or ordering system.

13.  Confidentiality; 
13.1.1.              Users should recognize that there will/might be a need for Users to disclose confidential information to each other for the purpose of delivering the agreed upon work, and to protect such confidential information from unauthorized use and disclosure. Therefore, Users irrevocably agree to treat any information received from any User as highly confidential. Without derogating from the generality of the above, Users specifically agree to the following;
13.1.1.1.           Maintain all such information in strict confidence; and/or
13.1.1.2.           Not disclose the information to any third parties; and/or
13.1.1.3.           Not use the information for any purpose except for delivering the agreed upon work; and/or
13.1.1.4.           Not to copy or reproduce any of the information without the Users permission. 
14.  Termination;
 
14.1.           GIGMEHQ may terminate your access to all or any part of the GIGMEHQ Platforms at any time, with or without cause, with or without notice, effective immediately. If you wish to terminate your usage of GIGMEHQ Platforms, you may simply discontinue using the GIGMEHQ Platforms. Notwithstanding the foregoing, if you materially breach these Terms of Service and fail to cure such breach within (14) fourteen days from GIGMEHQ’s notice to you, thereof. 
 
14.2.              Provided that, GIGMEHQ can terminate GIGMEHQ Platforms immediately as part of a general shut down of our services. All provisions of these Terms of Service, which by their nature should survive termination, shall survive termination, including, without limitation, ownership provisions, warranty disclaimers, indemnity and limitations of liability.

 
15.  Applicable Laws and Disputes; 
 
15.1.                 These Terms of Service shall be interpreted in accordance with the Federal laws of the United Arab Emirates (UAE) (hereby referred to as the “Relevant Laws”).  All and any disputes or claims arising out of or in connection with these Terms of Service, shall be exclusively referred to and finally resolved by arbitration in Dubai in accordance with the Arbitration Rules of the Dubai International Arbitration Centre (DIAC) for the time being in force; which rules are deemed to be incorporated by reference into this provision and the User waive any objection to such proceedings on the grounds of venue or on the grounds that the proceedings have been brought in an inappropriate forum. All proceedings shall be conducted in the English language, in accordance with the Federal Laws of the United Arab Emirates. The tribunal shall comprise of one arbitrator to be agreed between the parties and if not so agreed, to be appointed by the DIAC. Subject to the arbitration provisions, the Courts at DIAC only shall have jurisdiction on issues relating to these Terms of Service. 
 
15.2.                      New and Changed Regulations:
 
15.2.1.              In the event that at any time and from time to time during the term of these Terms of Service any applicable laws, rules, regulations, decrees, agreements, concessions and arrangements (“Changed Regulations”). In the event that Changed Regulations become effective, whether by law, decree or regulation or by response to the insistence or request of any governmental or public authority or any person purporting to act therefore, and the material effect of such Changed Regulations (a) is not covered by any other provision of these Terms of Service, and (b) has a material adverse economic effect upon either party, GIGMEHQ hereby declares its right to amend its Terms of Service and Privacy Policy and any other legal document in accordance with said Changed Regulation, thereof. 

16.  Invalidity; 
16.1.      If at any time any provision of these Terms of Service is or becomes illegal, invalid, void or unenforceable under the Relevant Laws, the legality, validity and enforceability of the remainder of these Terms of Service shall not be affected, and the legality, validity and enforceability of the whole of these Terms of Service in any other jurisdiction shall not be affected.

17.  Indemnification;
17.1.                Users agree to indemnify and hold harmless GIGMEHQ, its contractors, and its licensors, and their respective directors, officers, employees and agents from and against any and all claims and expenses, including legal fees, arising out of your use of any of the GIGMEHQ Platforms, including but not limited to your violation of these Terms of Service. 

 
18.  Changes to our Terms of Service and Privacy Policy; 
 
18.1.                      From time to time we may make adjustments to the Terms of Service and Privacy Policy. Changes will be made at GIGMEHQ’s sole discretion. GIGMEHQ Platform Users are encouraged to check these Terms of Service and Privacy Policy. User’s continued use constitutes acceptance of the changes.

 
19.  Contacting GIGMEHQ; 
 
19.1.                      Any questions or inquires related to these Terms of Service and the Privacy Policy about should be addressed to us via our email address; support@GIGMEHQ.com . 
 
19.2.                      This document has been last modified on 31st March 2021. 


20.  Miscellaneous;
 
20.1.                      These Terms of Service constitutes the entire Terms of Service between GIGMEHQ and the User, concerning the subject matter hereof. These Terms of Service is made up of (20) twenty Sections and may be modified by a written amendment executed only by GIGMEHQ and any authorized executive or legal counsel solely appointed by GIGMEHQ. Any access to any of the GIGMEHQ Platform’s will be governed by the Relevant Laws as defined within these Terms of Service. 
 
If any part of these Terms of Service is held invalid or unenforceable, that part will be construed to reflect the parties\' original intent, and the remaining portions will remain in full force and effect. A waiver by either party of any term or condition of these Terms of Service or any breach thereof, in any one instance, will not waive such Terms of Service or any subsequent breach thereof. 

',1,'2020-02-11 15:01:25','2022-09-12 11:19:11',NULL),(2,'Privacy Policy','privacy-policy','

GIGMEHQ, is a company registered under trader license (13336) and trading under the name GIGMEHQ, with its registered offices located in Abu Dhabi, United Arab Emirates 38th Floor, Media One Hotel - Office Tower, Abu Dhabi Media City, PO Box 334069 (hereby referred to as “GIGMEHQ”). GIGMEHQ provides this privacy policy to inform you of our policies and procedures regarding the collection, use and disclosure of information through GIGMEHQ Portal (the “GIGMEHQ Platforms”), (hereby collectively referred to as “Privacy Policy”). GIGMEHQ hereby declares that it respects your privacy and is highly dedicated and committed to protect the personal information of its users; freelancers, buyers, and other visitors browsing the GIGMEHQ Platforms (hereby collectively referred to as “User/s”). We strongly believe that you have a right to know our practices regarding the information we collect when you visit and/or use the GIGMEHQ Platforms. This Privacy Policy explains our privacy practices for the GIGMEHQ Platforms and services provided by GIGMEHQ. By accessing and/or using the GIGMEHQ Platforms and its related sites and/or registering for a GIGMEHQ account, you hereby agree to the terms and conditions of this Privacy Policy and the Terms of Service; including to our collection, use, disclosure, processing and retention of personal information and any similar action, thereof. 


1. Collected Information;

Upon your registration to the GIGMEHQ Platforms, complete forms; and proceed to use the GIGMEHQ Platforms, we ask you to provide certain personal information, including a valid email address, Facebook or Google account login details and username. We will also ask you to provide or otherwise collect additional information that you provide us, such as, your profile details, physical address, billing information, proof of identification (included but not limited to; photo verifications), telephone number or other contact details, financial information (such as payment method, number and information), details about your education, profession and expertise, and any additional authentication information (such as your government issued ID, passport, or driving license (hereby collectivly referred to as “Collected Information”) as permitted bythe Federal laws of the United Arab Emirates (hereby referred to as the  “Relevant Laws”), and as detailed in our GIGMEHQ Platforms. We also collect information about your communications with GIGMEHQ as well as communication with other Users. 

We further collect information during Users access, browsing, view or otherwise overall use of the GIGMEHQ Platforms. Meaning,when you access the GIGMEHQ Platforms, we are aware of your usage of the GIGMEHQ Platforms, and gather, collect and record the information relating to such usage, including IP address, device and connection information, browser information, geo-location information, and web-log information, and all communications recorded by Users through the GIGMEHQ Platforms. We use that information to further enhance user experience, personalize your browsing experience as well as monitor the GIGMEHQ Platforms for preventing fraud and inappropriate content or behavior. We further collect supplemental information obtained from third parties such as demographic and navigation data, once and/or if applicable. Further to the above, GIGMEHQ combines your personal information with information we collect automatically or otherwise obtain from other companies and utilize it (as described in Section 3, below); to improve and personalize our GIGMEHQ Services, content and advertising and/or to prevent fraudulent activity and any and all breaches to our GIGMEHQ Services.

Once you register, your username, country, and additional information regarding your activity, Users information will automatically be made public and shall be visible to all Users of the GIGMEHQ Platforms. This information includes, but is not limited to; Users uploaded photos, published portfolio, personal information, ratings, and additional information Users may choose to add to their profile. Please be aware that certain information, such as your user name and profile, together with the content uploaded by you, will be publicly displayed when you use such features.

 

2.      Collecting Information; 

Through the direct use of our GIGMEHQ Platforms, Users directly provide us with most of the information we collect. You do this by filling out the registration details on the GIGMEHQ Platforms, linking to your GIGMEHQ account, completing the GIGMEHQ Platforms forms, skill tests and as well as by posting and sharing additional information voluntarily. This can include, but not limited to; information about freelancers requirements, education and profession, sharing of portfolio, ratings and feedbacks by Users and anything Users choose to add to their user profile.

We collect technical information indirectly and automatically through our systems. This information includes logging Users Internet Protocol (IP) address, software configuration, operating system and use of cookies (cookies are small files sent from us to Users computer and sometimes back). 

We may receive information from third party vendors and/or other commercially available sources, such as:

● Third party vendors who provide us data to supplement the information we collect about you, in accordance with the Relevant Laws. We also receive information from advertising and marketing partners in order to manage and measure our campaigns.

● If you link, connect, or login to your GIGMEHQ Account with a third-party service (e.g. Google, Facebook, LinkedIn), We receive certain information, such as your registration and profile information from that service. This information varies and is controlled by that service or as authorized by you via your privacy settings at that service.

● Advertising and marketing partners in order to monitor, manage and measure our campaigns.

● We also receive certain information about you, if you are invited to GIGMEHQ by another user, in such case we will receive limited information, such as your email address or other contact information, and we will use it for the same purpose it was provided and in accordance with the terms of this Privacy Policy.


3.      Utilization of Collected Information; 

Where applicable under the Relevant Laws, all processing of your personal information will be justified on “Legal Grounds” for processing. In the majority of cases, processing will be justified on the basis that:

● Users have provided their consent for GIGMEHQ to use their personal information for a specific purpose;

● GIGMEHQ’s use of Users personal information is necessary to perform a contract or take steps to enter into a contract with you (e.g. to provide you with GIGMEHQ Services which you have purchased);

● the processing is necessary to comply with a relevant legal obligation or regulatory obligation that we have (i.e. fraud prevention); and/or

● the processing is necessary to support our legitimate interests as a business (i.e. to improve our GIGMEHQ Services to Users), subject to your interests and fundamental rights and provided it is conducted at all times in a way that is legitamte, lawful and proportionate.

● GIGMEHQ  may use Users personal information for the following purposes;

·         to provide Users with quality service and security, to operate the GIGMEHQ Platforms,  to perform our obligations to Users and to develop and improve our service; we may use the information collected from you to verify your identity. We also use this information to establish and set up your account, verify or re-issue a password, log your activity, enable your communications with other members, provide customer support and contact Users from time to time, as per requirement. The information helps GIGMEHQ to develop and improve its services to Users, to understand and analyse your preferences and performance and to customize and personalize your experience.

·         to ensure marketplace integrity, prevent fraudulent activity and maintain a safe and secure marketplace. We may use your information to track and prevent fraudulent activities and other inappropriate activities, monitor content integrity, conduct security investigations and risk assessments, verify or authenticate information provided by you, enforce our Terms of Service and comply with Relevant Laws. We conduct certain behavioural analytics to achieve the above objectives and in limited cases, if we detect activity that we think poses a risk to the GIGMEHQ marketplace and/or GIGMEHQ Platforms, other Users, or third parties, automated security processes may restrict or limit your ability to use the GIGMEHQ Platforms.

·         to contact GIGMEHQ, as requested by Users or as otherwise approved by Users or permitted according to this Privacy Policy.

·         to promote and advertise the GIGMEHQ Platforms and the GIGMEHQ marketplace. We may use the information collected from you for the purpose of sending direct marketing messages, to show you information that may be of interest to you, to organize and facilitate referral programs, contests or other promotional activities or events.

·         to maintain appropriate business records, to comply with lawful requests by public authorities and to comply with the RelevantLaws.

·         GIGMEHQ will ask for your consent before using information for a purpose other than those set out in this Privacy Policy.

● GIGMEHQ may use your personal information to send you direct marketing communications about our promotions from GIGMEHQ that may be of interest to you or our related GIGMEHQ Services. This may be via email, post, SMS, telephone or targeted online advertisements.

● GIGMEHQ will take steps to limit direct marketing to a reasonable and proportionate level, and to send you communications which we believe may be of interest or relevance to you, based on the information we have about you.


4.      Preservation of Information; 

● GIGMEHQ applies a general rule of keeping personal information only for as long as is required to fulfil the purpose for which it was collected. However, in some circumstances, GIGMEHQ may retain your personal information for longer periods of time. The abovementioned may be retained as follows;


● As long as it is necessary and relevant for GIGMEHQ operations, i.e so that we have an accurate record of Users dealings with GIGMEHQ in the event of any complaints or challenge; and

● In relation to personal information from closed accounts to comply with Relevant Laws, prevent fraud, collect any fees owed, resolve disputes, troubleshoot problems, assist with any investigation, enforce our GIGMEHQ Platforms Terms of Service and take other actions as permitted by the Relevant Laws.


5.      Personal Information and Third Parties; 

● GIGMEHQ do not sell or rent your personal information to third parties for their marketing purposes without Users explicit consent.

·         We may share Users personal information with third parties as follows;

·         GIGMEHQ share personal information with service providers that provide us with services for the purpose of operating the GIGMEHQ Platforms, opening and operating Users account, as well as providing ancillary services and solutions. These include,but shall not be limited to; hosting services, billing and payment vendors, forum hosting, community management services, data and cybersecurity services, web analytics and performance tools,session recording, communication systems, mailing systems, data optimization and marketing services, data enrichment services, legal and financial advisors or technical consultants. Consistent with the Relevant Laws, we take commercially reasonable steps to require third parties to adequately safeguard your personal information and only process it in accordance with our instructions; and/or

·         We may share personal information to law enforcement agencies, public authorities or other parties in order to respond to court orders, judicial process or to regulatory authorities, if we believe we are required to do so by the Relevant Laws, or that doing so is reasonably necessary to comply with legal processing; when GIGMEHQ believe it necessary or appropriate to disclose personal information to law enforcement authorities, such as to investigate actual or suspected fraud or violations of law, breaches of security, or breaches of this Privacy Policy; to respond to claims against GIGMEHQ; and to protect the rights, property, or personal safety of GIGMEHQ, our Users, and/or the public;and/or

·         GIGMEHQ may share personal information with payment processors, and similar third parties for the purpose of facilitating payments done via the GIGMEHQ Platforms and securing the GIGMEHQ Platforms and protecting it against fraudulent activity, unauthorized transactions, claims or other liabilities;and/or

·         Personal information will also be disclosed if GIGMEHQ go through a business transition such as a merger, sale, transfer of all or a portion of GIGMEHQ\'s assets, acquisition, bankruptcy or similar event. In the event that GIGMEHQ sell any business or assets, we will disclose your data to the prospective buyer. If GIGMEHQ or substantially all of our assets are acquired by a third party, information held by GIGMEHQ about our Users will be one of the transferred assets.

·         Users profile information and additional information regarding User activity is made public and is visible to all Users of the GIGMEHQ Platforms. When you publish your information and/or share your data with other Users, you do so at your own risk and liability.

 

6.      Storing Personal Information; 

·         Some of the personal information Users provide to GIGMEHQ will be stored or processed on GIGMEHQ’s behalf by either GIGMEHQ and/or third party suppliers and data processors. GIGMEHQ will take all steps reasonably necessary to ensure that your personal information is treated securely and in accordance with this Privacy Policy and Terms of Service.


7.      Cookies;

·         The use cookies and similar technologies (such as web beacons, pixels, tags, and scripts)shall be used but not be limited to; improve and personalize your experience, provide our services, analyze web performance and for marketing purposes. 


8.      External Links;

 

·         Please note that the GIGMEHQ Platforms contain links to third party sites and if you link to a third party GIGMEHQ Platforms from any GIGMEHQ Platform, any data Users provide to that GIGMEHQ Platforms and any use of that data by the third party are not under the control of GIGMEHQ and are not subject to this PrivacyPolicy and Terms of Service. This Privacy Policy applies solely to personal information collected by our GIGMEHQ Platforms. If you upload content, including personal information, to a social network and then tag any GIGMEHQ Social Media Account, your submission will be subject to that social network\'s terms of use and privacy policy, even where you post on GIGMEHQ’s official page on any social network. GIGMEHQ hereby declares that it does not have control over these terms of use and privacy policies and have not reviewed their adequacy. You should therefore review these before submitting any personal information.

 

9.      Cyber Security; 

·         We take great care in maintaining the security of the GIGMEHQ Platforms and your information and in preventing unauthorized access, loss, misuse, alteration, destruction or damage to it through industry standard technologies and internal procedures. In addition, we ensure that any and all third party processing your personal information equally and adequetley provides for confidentiality and overall integrity of Users data according to industry standards. However, any and all transmission of data via the internet is not completely secure, and although GIGMEHQ will do its best efforts to protect your personal information, we in no way guarantee nor can we guaratnee, the security of your data transmitted to the GIGMEHQ Platforms; any transmission is at your own risk. Once we have received your data, we will use strict procedures and security features to try to prevent unauthorized access.

·         Users who have registered to the GIGMEHQ Platforms agree to keep their password in strict confidence and not disclose such password to any third party. Further information about our data security practices can be provided on request, in accordance with Section (4) of the Terms of Service. 

 

10.  Updating Personal Information;  

·         GIGMEHQ takes steps to ensure that the personal information GIGMEHQ collects is accurate and up to date, and we provide you with the opportunity to update your information through your GIGMEHQ Account profile settings. In the event that a User believes his/her information is in any way incorrect or inaccurate, the User is advised to let GIGMEHQ know immediately. 

·         GIGMEHQ will make sure an investigation takes place on the matter and correct any inaccuracies as quickly as possible where necessary or give you ways to update it quickly or to delete it,  unless GIGMEHQ have to keep that information for legitimate business or legal purposes. When updating your personal information, GIGMEHQ will further ask you to verify your identity before we can act on your request. If for any reason you have a problem with deleting your personal information, please contact GIGMEHQ\'s Customer Care personal and we will make reasonable efforts to delete any such information pursuant to any applicable privacy laws.

·         Users can review and change their personal information by logging into the GIGMEHQ Platforms and visiting their account profile page.


11.  Contact Us; 

·         GIGMEHQ will process any requests in line with any local laws and our policies and procedures. If you do not have an active GIGMEHQ account, please contact us at support@GIGMEHQ.com     

·         If you have any inquires concerning this Privacy Policy, please email our team at support@GIGMEHQ.com , and we will make an effort to reply within a reasonable timeframe.

 

12.  Entire Privacy Policy; 

·         This Privacy Policy constitutes the entire understanding between GIGMEHQ and the User with respect to the matters contained herein; superseding all prior Privacy Policies for GIGMEHQ.


',1,'2020-02-11 15:01:25','2022-09-12 11:17:18',NULL),(3,'About Us','about-us','

One platform connecting you to a world of services!

Finding a freelance service near you has just got easier! Gigme HQ all in one app saves you time finding great services at competitive prices.

Take control today! Whether you’re looking for a quick or more comprehensive solution, Gigme HQ is at your service!

We connect you to local and international freelancers, world wide, 24 hours a day. With services to meet every budget and every requirement!

Join us here!

',1,'2020-02-11 15:01:25','2022-09-09 12:42:19',NULL),(4,'FAQs','faq','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.',1,'2020-02-11 15:01:25','2022-09-09 12:45:41',NULL); /*!40000 ALTER TABLE `content_management` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 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; /*!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 `faqs` -- DROP TABLE IF EXISTS `faqs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faqs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` int 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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs` -- LOCK TABLES `faqs` WRITE; /*!40000 ALTER TABLE `faqs` DISABLE KEYS */; INSERT INTO `faqs` VALUES (1,'61e96ae6967c761e96ae6967c8','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),(2,'61e96ae6967c961e96ae6967ca','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),(3,'630337e7b83531661155303','aaabbb','aaaa\r\nvbbb',1,'2022-08-22 08:01:43','2022-08-23 07:14:28',NULL),(4,'630e51bc0a20f1661882812','What is Gigme?','Gigme is an online outsourcing platform that puts clients and businesses in contact with a global network of freelancers. Any member can post a project, whether a short- or long-term job, and choose from skilled freelancers who offer bid proposals with rate quotes and time estimates for completing the work. It\'s a mutually beneficial arrangement.\r\n\r\n\r\nClients can have their pick of thousands of freelancers who have the exact skills needed to get the job done, without undertaking the expense and commitment of hiring full-time employees in person.\r\n\r\nFreelancers can access a readily available source of constant part-time and full-time work opportunities from clients who are specifically seeking them out.',1,'2022-08-30 18:06:52','2022-08-30 18:06:52',NULL),(5,'630e54f62a7631661883638','Freelancer Fees and Charges','Freelancer Logo\r\nLog In Sign Up\r\nFreelancer Fees and Charges\r\nFor Employers\r\nProjects\r\nFreelancer is free to sign up, post a project, receive bids from freelancers, review the freelancer\'s portfolio and discuss the project requirements. If you choose to award the project, we charge you a small project fee relative to the value of the selected bid, as an introduction fee.\r\n\r\nThe cost and how this fee is charged depends on the type of project.\r\n\r\nFor fixed price projects, a fee of 3% or $3.00 USD (whichever is greater) is levied at the time a project has been awarded by you. If you subsequently pay the freelancer more than the original bid amount we will also charge the project fee on any overage payments.\r\n\r\nFor hourly projects, a fee of 3% is levied on each payment that you make to the freelancer.\r\n\r\nYou may cancel the project from your dashboard at any time for up to seven (7) days after the project has been accepted for a full refund of your fee.\r\n\r\nOptional project upgrades may be purchased.\r\n\r\nContests\r\nAt the time of posting a contest, employers must provide funds equivalent to the total contest prize. We have a Money Back Guarantee for this prize money.\r\n\r\nThe Money Back Guarantee entitles you to get your money back for up to 30 days from contest closing if you are not happy with the submitted entries. You can get refunded simply by contacting support.\r\n\r\nNote that refunds are not available on \'Guaranteed contests\', and this refund does not include any upgrades that you may have selected for the contest. If you\'ve already selected an entry as the winner and completed the contest handover, which has released the prize money to them, you are not eligible for a refund.\r\n\r\nThere is no contest fee for posting and awarding the contest for employers.\r\n\r\nEach additional awarded entry will also require payment of the prize for that entry.\r\n\r\nOptional contest upgrades may be purchased.\r\n\r\nServices\r\nAt the time of ordering a service, employers must provide funds equivalent to the total service price. The payment is protected by the Freelancer Milestone Payment System. Only release the payment once you are 100% happy with the work that has been delivered.\r\n\r\nFor Freelancers\r\nFreelancer is free to sign up, create a profile, select skills of projects you are interested in, upload a portfolio, receive project notifications, discuss project details with the employer, bid on projects (free members receive initially 6 bids per month) and enter contests.\r\n\r\nOptional bid upgrades may be purchased to promote a bid.\r\n\r\nProjects\r\nFor fixed price projects, if you are awarded a project, and you accept, we charge you a small project fee relative to the value of the selected bid, as an introduction fee. If you are subsequently paid more than the original bid amount, we will also charge the project fee on any overage payments.\r\n\r\nFor hourly projects, the fee is levied on each payment as it is made by the employer to you.\r\n\r\nThe fee for fixed price projects is 10% or $5.00 USD, whichever is greater, and 10% for hourly projects.\r\n\r\nContests\r\nSubmitting entries to a contest is free. Contest fee applies when you are awarded a contest prize. This fee is charged when the prize is released, which is after contest has been awarded to you and the handover of entry materials has been completed to the contest poster\'s satisfaction.\r\n\r\nThe freelancer contest fee is 10% or $5.00 USD, whichever is greater.\r\nServices\r\nIf you are subsequently hired to perform that Service, a 20% fee of the total service price is charged. This is charged when the service is ordered by way of a deduction from the payment you receive.\r\n\r\nPreferred Freelancer Program\r\nIf you are in the Preferred Freelancer Program, you will be charged 15% project fee when you are awarded and accept a Recruiter project. This will not be charged upfront, like on regular projects, but rather when you receive the payment.\r\n\r\nRefunds as Bonus Credit\r\nIn some instances, refund of fees may be done as bonus credit. This bonus may only be used on site, and can not be withdrawn or transferred. The bonus will expire in 90 days from the date of receipt.\r\n\r\n0% Fees Promotion\r\nFreelancer project commissions charged for freelancers who refer new employers that do not have an existing account on Freelancer.com and who join and create a new account, will be reduced from 10% to 0%, for all future projects performed by the referring freelancer for the referred employer.\r\n\r\nThis is subject to the following conditions:\r\n\r\nNew employers must be referred using the specific promotional links on https://www.freelancer.com/no-commission.\r\nFor the avoidance of doubt, the reduced freelancer project commission of 0% applies only in relation to new work performed by the freelancer who has successfully applied for this promotion for the specific employer to whom the application relates. The new projects must commence after the employer creates a new account on Freelancer.com and be initiated using that new account.\r\nProject commission fees for the freelancer only are lowered from 10% to 0% under this promotion. All other fees and charges remain unaffected including but not limited to employer commissions and transaction fees.\r\nThis promotion does not apply to contests.\r\nFreelancer reserves the right to review classifications of employers as new employers for the purpose of this promotion, to ensure fair use of this promotion. Employers must have worked with, and paid, the freelancer applying to use this promotion before the beginning of this promotion, for example from another platform. Freelancers may be required to provide evidence of this prior work and payment before being eligible for the commission reduction. To be eligible for this promotion, employers must not have had any active account on Freelancer.com from which a payment was made within the 6 months immediately prior to creating the new account.\r\nAll other elements of the User Agreement continue to apply - see https://www.freelancer.com/about/terms.\r\nAll other elements of the Fees and Charges component of the Additional Terms continue to apply - see https://www.freelancer.com/feesandcharges.\r\nFreelancer may require that both parties fill in and complete their profiles and/or pass identity checks before payments are released.\r\nFreelancer may require that the details for any project for which the commission reduction applies are appropriately complete.\r\nThis promotion may be withdrawn for a specific user, if significant reversals, fraud or chargebacks are observed, if Freelancer believes that there is a risk of funds being subject to reversal or chargeback, in cases of disputes between employer and freelancer, or for any other reason.\r\nFreelancer reserves the right to disallow use of this promotion in its sole and absolute discretion, with respect to fair use of this promotion, and to prevent any suspected fraud.\r\nFreelancer reserves the right to require submission of further information from any party applying to make use of this promotion, for investigating fraud and for risk management and related purposes.\r\nFreelancer reserves the right to cancel or amend this promotion at any time.\r\nFreelancer reserves the right to cancel the promotion in any region if it is deemed or becomes unlawful to offer the promotion to any resident of that region.\r\n3% Quote Fee\r\nFreelancer project commissions charged for freelancers who have a quote awarded by a new external Client will be 3% for all projects between the Freelancer and new Client. For new external Clients accepting a quote, 0% Freelancer project commissions will be charged.\r\n\r\n\"New Client\" refers to clients that have not created an account on Freelancer.com before.\r\nThe promotion does not apply if clients have multiple accounts on Freelancer.com.\r\nThis is subject to the following conditions:\r\n\r\nNew employers must be referred through accepting a quote and registering during the acceptance process.\r\nFor the avoidance of doubt, the reduced freelancer project commission of 3% applies only in relation to work performed by the freelancer who has successfully applied for this promotion for the specific employer to whom the application relates. Work must commence after the employer creates a new account on Freelancer.com and be initiated using that new account.\r\nProject commission fees for the freelancer only are lowered from 10% to 3% and client project commission fees are lowered from 3% to 0% under this promotion. All other fees and charges remain unaffected including but not limited to transaction fees.\r\nThis promotion does not apply to contests.\r\nFreelancer reserves the right to review classifications of employers as new employers for the purpose of this promotion, to ensure fair use of this promotion. To be eligible for this promotion, employers must not have had any active account on Freelancer.com from which a payment was made within the 6 months immediately prior to creating the new account.\r\nAll other elements of the User Agreement continue to apply - see https://www.freelancer.com/about/terms.\r\nAll other elements of the Fees and Charges component of the Additional Terms continue to apply - see https://www.freelancer.com/feesandcharges.\r\nFreelancer may require that both parties fill in and complete their profiles and/or pass identity checks before payments are released.\r\nFreelancer may require that the details for any project for which the commission reduction applies are appropriately complete.\r\nThis promotion may be withdrawn for a specific user, if significant reversals, fraud or chargebacks are observed, if Freelancer believes that there is a risk of funds being subject to reversal or chargeback, in cases of disputes between employer and freelancer, or for any other reason.\r\nFreelancer reserves the right to disallow use of this promotion in its sole and absolute discretion, with respect to fair use of this promotion, and to prevent any suspected fraud.\r\nFreelancer reserves the right to require submission of further information from any party applying to make use of this promotion, for investigating fraud and for risk management and related purposes.\r\nFreelancer reserves the right to cancel or amend this promotion at any time.\r\nFreelancer reserves the right to cancel the promotion in any region if it is deemed or becomes unlawful to offer the promotion to any resident of that region.\r\nMembership Plans\r\nSelect from a range of membership plans to determine the fees you pay for our service. You can work on the site as either an employer or freelancer as a free member, or gain additional benefits as a paid member by upgrading to a paid plan.\r\n\r\nMemberships will recur on either a monthly or annual basis on the anniversary of your subscription, unless cancelled. If funds are insufficient we will try to renew your membership for up to 30 days, until funds are made available.\r\n\r\nYou may cancel your membership at anytime from the user settings page, which will cease billing at the end of your subscription period without additional costs.\r\n\r\nView our membership plans\r\n\r\nOther Fees\r\nProjects\r\nThe following fees are optionally charged for additional services. Unless otherwise specified according to the benefits of a paid membership plan:\r\n\r\nPosting a Project FREE\r\nFeatured $9.00 USD\r\nUrgent $9.00 USD\r\nPrivate $19.00 USD\r\nFull Time $199.00 USD\r\nRecruiter $9.50 USD\r\nNon-Disclosure Agreement (NDA) $19.00 USD\r\nIP Agreement $19.00 USD\r\nSealed $9.00 USD\r\nPriority $5.00 USD\r\nExtend $9.00 USD\r\nContests\r\nThe following fees are optionally charged for additional services. Unless otherwise specified according to the benefits of a paid membership plan:\r\n\r\nPosting a Contest FREE\r\nAwarding contest FREE\r\nAwarding to additional freelancers FREE\r\nGuaranteed FREE\r\nFeatured $30.00 USD\r\nTop Contest $30.00 USD\r\nUrgent $35.00 USD\r\nHighlight $15.00 USD\r\nSealed $30.00 USD\r\nPrivate $25.00 USD\r\nNon-Disclosure Agreement (NDA) $20.00 USD\r\nExtend Costs:\r\n3 days = 15% of contest prize\r\n5 days = 20% of contest prize\r\n7 days = 30% of contest prize\r\n14 days = 40% of contest prize\r\n21 days = 50% of contest prize\r\nHalf of the costs will be used to increase the contest prize (rounded to the nearest whole number).\r\nBid Fees\r\nBidding on projects FREE\r\nSponsored bid 0.75% of bid amount (minimum $5.00 USD, maximum $20.00 USD)\r\nHighlight Bid $1.00 USD\r\nSealed Bid $0.10 USD\r\nContest Entry Fees\r\nSubmit an Entry FREE\r\nSealed Entry $0.50 USD\r\nHighlight Entry $0.50 USD\r\nDirectory Fees\r\nDirectory sponsorship As selected at time of sponsoring (minimum $50.00 USD)\r\nExams\r\nTaking an exam Dependent on exam. As specified prior to purchase. Typically either free, $5.00 USD, $10.00 USD, or $15.00 USD.\r\nTransaction Fees\r\nTransaction fees incurred for using Credit Card, PayPal or Skrill.* $0.30 USD + 2.3%\r\nLocal Bank Deposit FREE\r\nInternational Wire Transfer $15.00 USD*Australian users incur $0.30AUD + 0.99% for Credit/Debit card transactions.\r\nArbitration Fees\r\nThe arbitration fee for a milestone dispute is $5.00 USD or 5%, whichever is greater.\r\n\r\nOur dispute resolution system is designed to allow both parties to resolve issues regarding milestone payments amongst themselves without arbitration.\r\n\r\nAfter 4 days of a dispute being filed (or 7 days if the dispute is filed by the freelancer) either party may elect to move the dispute to paid arbitration. The other party will then have a further 4 days to agree to pay this fee and for both parties to submit any final evidence. If the other party fails to pay within time, they will lose the dispute.\r\n\r\nThe arbitration fee will then be refunded to the winner of the dispute.\r\n\r\nWithdrawal Fees\r\nFees may be optionally levied depending on the method of withdrawal. Additional fees may be levied by the third party offering the withdrawal method.\r\n\r\nExpress Withdrawal FREE\r\nPayPal FREE\r\nSkrill (Moneybookers) FREE\r\nPayoneer Debit Card FREE\r\nInternational Wire $25.00 USD\r\nWe impose a minimum withdrawal, after fees, of USD $30.\r\n\r\nMaintenance Fee\r\nUser Accounts that have not logged in for six months will incur a maintenance fee of up to $12.00 USD per month until either the account is terminated or reactivated for storage, bandwidth, support and management costs of providing hosting of the user\'s profile, portfolio storage, listing in directories, provision of the HireMe service, file storage and message storage. These fees will be refunded upon request by users on subsequent reactivation.\r\n\r\nTaxes\r\nTaxes are applied based on local rates and rules defined by the user\'s country of residence / registered country.\r\n\r\nAustralia - Goods and Service Tax (GST) 10%\r\nChile - Value Added Tax (VAT) 19%\r\nEuropean Union - Value Added Tax (VAT) VAT rates\r\nIndia - Tax Collected at Source (TCS) 1%\r\nIndia - Tax Deducted at Source (TDS) 1% / 5%\r\nMexico - Income Tax Withholding 1% / 20%\r\nMexico - Value Added Tax (VAT) 16%\r\nRussia - Value Added Tax (VAT) 20%\r\nSwitzerland - Value Added Tax (VAT) 7.7%\r\nIndia Equalisation Levy Reimbursement\r\nThe treaty relieves freelancers of withholding obligations, for the avoidance of doubt, the Equalisation Levy. You are not being charged or paying for this levy, it is a reimbursement.\r\nCLIENT\r\n\r\nIndian Resident\r\n\r\nFREELANCER\r\n\r\nIndian Resident\r\n\r\nWHO PAYS LEVY\r\n\r\nFreelancer\r\n\r\nLEVY DETAILS\r\n\r\n2% charged to Freelancer on gross earnings\r\n\r\nCLIENT\r\n\r\nIndian Resident\r\n\r\nFREELANCER\r\n\r\nOther\r\n\r\nWHO PAYS LEVY\r\n\r\nClient\r\n\r\nLEVY DETAILS\r\n\r\n2% charged to Client on gross milestone payments\r\n\r\nCLIENT\r\n\r\nOther\r\n\r\nFREELANCER\r\n\r\nIndian Resident\r\n\r\nWHO PAYS LEVY\r\n\r\nFreelancer\r\n\r\nLEVY DETAILS\r\n\r\n2% charged to Freelancer on gross earnings\r\n\r\nCLIENT\r\n\r\nOther\r\n\r\nFREELANCER\r\n\r\nOther\r\n\r\nWHO PAYS LEVY\r\n\r\nN/A\r\n\r\nLEVY DETAILS\r\n\r\nN/A\r\n\r\n* Freelancer and its affiliates do not provide tax, legal or accounting advice. This material has been prepared for informational purposes only, and is not intended to provide, and should not be relied on for, tax, legal or accounting advice. You should consult your own tax, legal and accounting advisors.\r\n\r\nUser Agreement\r\nThe fees and charges summarised on this page are governed by the terms of the Freelancer User Agreement and related site policies. The User Agreement includes other important terms and should be read in full. In particular section 23 of the User Agreement specifies the consequences of termination for violations of the User Agreement. Those consequences can include fines for damages that Freelancer will sustain as a result of actions that breach the User Agreement.',1,'2022-08-30 18:20:38','2022-08-30 18:23:21',NULL),(6,'630e58d4c78b61661884628','How do I sign up?','Fill out a short signup form. You will be asked to create a unique username for identification in our system, provide a valid email address, and confirm that you have read our Terms and Conditions. You don\'t have to give any personal information to start your Freelancer membership.\r\n\r\nConfirm your email address. When you submit the registration form, we will send a verification email to the email address you provided upon signing up. Follow the link provided on the email to activate your Freelancer account.\r\n\r\nCreate your profile. Fill out your profile correctly and completely to let the Freelancer community know who you are as a person and what you\'re looking for professionally.\r\n\r\nUsers with incomplete profiles will not be allowed to bid on projects. Here are a few tips to complete your profile and get noticed:\r\n\r\nBe sure to upload a photo on your profile. It\'s much easier to recognize and relate to a face than a username.\r\n\r\nYou might want to consider using your full name or company name as your display name.\r\n\r\nYour Professional Headline is a good place to make a solid first impression. It might be your company slogan or a list of the top skills you can offer to a client. It should make other users want to know more about you.\r\n\r\nUse the Summary section to give more details about yourself. This is your chance to really make your profile stand out from the crowd. Talk about your company mission or your work history. Highlight your skills and let people in the Freelancer.com community know why you\'re the best freelancer for the job.\r\n\r\n \r\n\r\nThe information you provide on your profile page will give other users an overview of your skills and/or needs. Gigme does not share your personal and contact information on your Profile Details page.',1,'2022-08-30 18:37:08','2022-08-30 18:37:08',NULL),(7,'630e5962ba20a1661884770','I am a client, how will Gigme work for me??','You can gain a competitive advantage over your competition by tapping into a skilled global workforce on demand.\r\n\r\n\r\nIf you are a small business and can\'t afford to hire a full-time staff, don\'t fret! The power of Freelancer is available for small to medium businesses! Whether it\'s a website that needs building, business cards or stationery that needs designing, a product that needs to be designed or manufactured, or research that needs to be done, this is the place for you!\r\n\r\n\r\nThousands of skilled workers are ready to start working right now! All you need to do is post a project!',1,'2022-08-30 18:39:30','2022-08-30 18:39:46',NULL),(8,'630e59c7576e11661884871','I am a freelancer, what will GIGme do for me?','With Freelancer, you can work at home and tap into a global network of businesses and projects across a huge range of industries - the ultimate opportunity in job flexibility!\r\n\r\n\r\nWork on what you want, when you want and where you want to! The lifestyle of a freelancer is taking off. By working as a Freelancer online, you can greatly increase your client base and job throughput.\r\n\r\n \r\n\r\nTo start, all you need to do is sign up and start bidding. It\'s FREE!',1,'2022-08-30 18:41:11','2022-08-30 18:41:11',NULL),(9,'630e5a87264dd1661885063','How do I get paid?','How do I get paid?\r\nPayments from completing projects and contests will be transferred to your Freelancer.com account. You can then have them requested to be withdrawn.\r\n\r\n \r\n\r\nYour clients can pay you via any of the following methods:\r\n\r\n \r\n\r\n \r\n\r\nMilestone Payments\r\n \r\n\r\nThe Milestone Payment System is the recommended mode of payment on the site. Your client can set funds aside for later payment once you have completed the project. The payment, called a Milestone Payment, can also be released to you by your client for every task met. Also, every Milestone Payment comes with an invoice which you can use for tax purposes.\r\n\r\n \r\n\r\nWe encourage using Proposed Milestones as early as bidding on projects to help your client see the payment schedule for the project per task in case they award you.\r\n\r\n \r\n\r\nUsing Milestone Payments also gives you and your client access to our Dispute Resolution Service in the event that your project does not go as planned.\r\n\r\n \r\n\r\nNote that quote items in quotations you send to clients turn into Milestone Payments once your client accepts your quote.\r\n\r\n \r\n\r\n \r\n\r\nTransfer Funds\r\n \r\n\r\nTransfer Funds allows your client to directly transfer payment to you via the Transfer Funds tab on their Financial Dashboard. However, we still recommend using the Milestone Payment System instead because this mode of payment is not eligible for our Dispute Resolution Service.\r\n\r\n \r\n\r\nTo ensure you have the best protection possible in an unlikely event of a dispute, keep your correspondences and payments within GIGme.com',1,'2022-08-30 18:44:23','2022-08-30 18:44:23',NULL); /*!40000 ALTER TABLE `faqs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `file_disputes` -- DROP TABLE IF EXISTS `file_disputes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `file_disputes` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned NOT NULL, `booking_id` bigint unsigned NOT NULL, `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status` varchar(255) CHARACTER SET utf8mb4 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 `file_disputes_slug_unique` (`slug`), KEY `file_disputes_user_id_foreign` (`user_id`), KEY `file_disputes_booking_id_foreign` (`booking_id`), CONSTRAINT `file_disputes_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE, CONSTRAINT `file_disputes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `file_disputes` -- LOCK TABLES `file_disputes` WRITE; /*!40000 ALTER TABLE `file_disputes` DISABLE KEYS */; /*!40000 ALTER TABLE `file_disputes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gigs` -- DROP TABLE IF EXISTS `gigs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gigs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `category_id` int NOT NULL, `is_delete` int NOT NULL DEFAULT '0', `is_active` int NOT NULL DEFAULT '1', `is_premium` int NOT NULL DEFAULT '0', `status` enum('pending','accepted','rejected','completed','disputed') CHARACTER SET utf8mb4 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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gigs` -- LOCK TABLES `gigs` WRITE; /*!40000 ALTER TABLE `gigs` DISABLE KEYS */; INSERT INTO `gigs` VALUES (1,'product',3,'Product','Test',26,0,1,0,'pending','2023-01-20 12:56:02','2023-01-20 12:56:02',NULL),(2,'home-cleaning',8,'Home cleaning','Test',29,0,1,0,'pending','2023-01-26 18:34:46','2023-01-26 18:34:46',NULL),(3,'terrazzo-floor-refinishing',11,'Terrazzo floor Refinishing','Terrazzo floor restoration, we restore terrazzo flooring to a high shine your terrazzo floor will never look as good until you try us 🇺🇸 😉',29,0,1,0,'pending','2023-02-08 02:11:39','2023-02-08 02:11:39',NULL),(4,'test',2,'Test','Tyes',20,0,1,0,'pending','2023-02-20 11:15:35','2023-02-20 11:15:35',NULL),(5,'aaaa',13,'Aaaa','Aaaa aaaa aaaaa',14,0,1,0,'pending','2023-04-13 11:05:22','2023-04-13 11:05:22',NULL); /*!40000 ALTER TABLE `gigs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mail_templates` -- DROP TABLE IF EXISTS `mail_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail_templates` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `wildcard` text CHARACTER SET utf8mb4 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mail_templates` -- LOCK TABLES `mail_templates` WRITE; /*!40000 ALTER TABLE `mail_templates` DISABLE KEYS */; INSERT INTO `mail_templates` VALUES (1,'forgot-password','Forgot Password Confirmation','\r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n

Hi [USERNAME],

\r\n

A request has been made to recover password for your account. Please follow below link to generate new password for your account :

\r\n

Reset Password

\r\n
\r\n
\r\n

Regards,

\r\n

© [YEAR] [APP_NAME] All Rights reserved.

\r\n
\r\n
\r\n','[USERNAME],[LINK],[YEAR],[APP_NAME]','2022-01-20 14:00:06',NULL,NULL),(2,'user_registration','Welcome to [APP_NAME]','\r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n

Hi [USERNAME],

\r\n

Your account has been created successfully. First, you need to confirm your account. Just click the below link

\r\n

Verify Now

\r\n
\r\n
\r\n

Regards,

\r\n

© [YEAR] [APP_NAME] All Rights reserved.

\r\n
\r\n
\r\n','[USERNAME],[LINK],[YEAR],[APP_NAME]','2022-01-20 14:00:06',NULL,NULL); /*!40000 ALTER TABLE `mail_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media` -- DROP TABLE IF EXISTS `media`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `media` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `module` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `module_id` int NOT NULL, `filename` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `original_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `file_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `thumbnail_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `mime_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `file_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image_blur_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `driver` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local', `media_type` enum('public','private') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public', `meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media` -- LOCK TABLES `media` WRITE; /*!40000 ALTER TABLE `media` DISABLE KEYS */; INSERT INTO `media` VALUES (1,'gigs',1,'uvnu5NCntXTOzfSF4AEfEo67AHsQlXh3bGHilBuR.jpg','uvnu5NCntXTOzfSF4AEfEo67AHsQlXh3bGHilBuR.jpg','gig_media/uvnu5NCntXTOzfSF4AEfEo67AHsQlXh3bGHilBuR.jpg','gig_media/thumb_uvnu5NCntXTOzfSF4AEfEo67AHsQlXh3bGHilBuR.jpg','image/jpg','jpg','','local','public',NULL,NULL,NULL,NULL),(2,'gigs',1,'sZdKhJjAXDS7zifQHk4LJKW9aY54KyKEddeoJK49.jpg','sZdKhJjAXDS7zifQHk4LJKW9aY54KyKEddeoJK49.jpg','gig_media/sZdKhJjAXDS7zifQHk4LJKW9aY54KyKEddeoJK49.jpg','gig_media/thumb_sZdKhJjAXDS7zifQHk4LJKW9aY54KyKEddeoJK49.jpg','image/jpg','jpg','','local','public',NULL,NULL,NULL,NULL),(3,'gigs',2,'A1vKEmA5cn3FcELnO45JwlP9dvBcjX4SRDdGQSD9.jpg','A1vKEmA5cn3FcELnO45JwlP9dvBcjX4SRDdGQSD9.jpg','gig_media/A1vKEmA5cn3FcELnO45JwlP9dvBcjX4SRDdGQSD9.jpg','gig_media/thumb_A1vKEmA5cn3FcELnO45JwlP9dvBcjX4SRDdGQSD9.jpg','image/jpg','jpg','','local','public',NULL,NULL,NULL,NULL),(4,'gigs',3,'C9AOiPjb4Psoqv1mQ6OX1a2vSdDaOOKAKlCEwHIO.jpg','C9AOiPjb4Psoqv1mQ6OX1a2vSdDaOOKAKlCEwHIO.jpg','gig_media/C9AOiPjb4Psoqv1mQ6OX1a2vSdDaOOKAKlCEwHIO.jpg','gig_media/thumb_C9AOiPjb4Psoqv1mQ6OX1a2vSdDaOOKAKlCEwHIO.jpg','image/jpg','jpg','','local','public',NULL,NULL,NULL,NULL),(5,'gigs',3,'kejJkfkuUAbdYctoAKTdaisEcVKyhjvnZTpBzMa9.jpg','kejJkfkuUAbdYctoAKTdaisEcVKyhjvnZTpBzMa9.jpg','gig_media/kejJkfkuUAbdYctoAKTdaisEcVKyhjvnZTpBzMa9.jpg','gig_media/thumb_kejJkfkuUAbdYctoAKTdaisEcVKyhjvnZTpBzMa9.jpg','image/jpg','jpg','','local','public',NULL,NULL,NULL,NULL),(6,'gigs',4,'x1ShMd2GHT8pSdNFlmqWUJDxs82Zrj3tQu4KcsSB.jpg','x1ShMd2GHT8pSdNFlmqWUJDxs82Zrj3tQu4KcsSB.jpg','gig_media/x1ShMd2GHT8pSdNFlmqWUJDxs82Zrj3tQu4KcsSB.jpg','gig_media/thumb_x1ShMd2GHT8pSdNFlmqWUJDxs82Zrj3tQu4KcsSB.jpg','image/jpg','jpg','','local','public',NULL,NULL,NULL,NULL),(7,'gigs',5,'2EM4LA8CYM7lkws3xHubXIOUUhSgT80fdDHOH5re.png','2EM4LA8CYM7lkws3xHubXIOUUhSgT80fdDHOH5re.png','gig_media/2EM4LA8CYM7lkws3xHubXIOUUhSgT80fdDHOH5re.png','gig_media/thumb_2EM4LA8CYM7lkws3xHubXIOUUhSgT80fdDHOH5re.png','image/jpg','png','','local','public',NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `media` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=63 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 (32,'2019_08_19_000000_create_failed_jobs_table',1),(33,'2021_03_05_000000_create_cms_roles_table',1),(34,'2021_03_05_172240_create_cms_users_table',1),(35,'2021_03_05_174918_create_cms_modules_table',1),(36,'2021_03_05_175415_create_cms_module_permissions_table',1),(37,'2021_03_06_185651_create_mail_templates_table',1),(38,'2021_03_08_191839_create_reset_password_table',1),(39,'2021_03_13_121206_create_application_setting_table',1),(40,'2021_04_20_200223_create_user_groups_table',1),(41,'2021_04_20_200451_create_users_table',1),(42,'2021_04_20_202053_create_user_api_token_table',1),(43,'2021_06_04_181436_create_notification_table',1),(44,'2021_06_06_130550_create_notification_setting_table',1),(45,'2021_08_29_105840_create_jobs_table',1),(46,'2021_09_07_154417_create_cms_widgets_table',1),(47,'2021_09_07_161059_create_cms_widget_role_table',1),(48,'2021_09_08_081135_create_content_management_table',1),(49,'2021_09_08_082346_create_faqs_table',1),(50,'2021_09_20_180624_create_media_table',1),(51,'2021_11_30_121343_create_categories_table',1),(52,'2021_12_01_082227_create_user_preferences_table',1),(53,'2021_12_02_063940_create_skills_table',1),(54,'2021_12_02_070554_create_user_skills_table',1),(55,'2021_12_03_075747_create_gigs_table',1),(56,'2021_12_03_080928_create_packages_table',1),(57,'2021_12_07_062215_create_services_table',1),(58,'2021_12_07_062525_create_bookings_table',1),(59,'2021_12_07_065250_create_booking_status_log_table',1),(60,'2021_12_07_065556_create_rating_review_table',1),(61,'2021_12_17_125634_create_user_json_skill_table',1),(62,'2022_01_14_072309_create_booking_package_log_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notification` -- DROP TABLE IF EXISTS `notification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notification` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `unique_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `identifier` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `actor_id` int NOT NULL, `actor_type` enum('users','cms_users') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'users', `target_id` int NOT NULL, `target_type` enum('users','cms_users') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'users', `reference_id` int NOT NULL, `reference_module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `web_redirect_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_read` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `is_view` enum('0','1') CHARACTER SET utf8mb4 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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notification` -- LOCK TABLES `notification` WRITE; /*!40000 ALTER TABLE `notification` DISABLE KEYS */; INSERT INTO `notification` VALUES (1,'63fe5dc2716be','booking',4,'users',11,'users',1,'booking','GIGME','Booking has been created',NULL,'1','0','2023-02-28 20:02:10','2023-03-01 00:25:58'),(2,'63fe5eff27eb5','booking',4,'users',2,'users',2,'booking','GIGME','Booking has been created',NULL,'1','0','2023-02-28 20:07:27','2023-04-13 12:33:21'),(3,'63fe71022130f','booking',11,'users',4,'users',1,'booking','GIGME','You booking#1 has been rejected',NULL,'1','0','2023-02-28 21:24:18','2023-03-12 09:40:00'),(4,'63fe710526f5f','booking',11,'users',4,'users',1,'booking','GIGME','You booking#1 has been rejected',NULL,'1','0','2023-02-28 21:24:21','2023-03-12 09:40:00'); /*!40000 ALTER TABLE `notification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notification_setting` -- DROP TABLE IF EXISTS `notification_setting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notification_setting` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `meta_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `meta_value` int 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notification_setting` -- LOCK TABLES `notification_setting` WRITE; /*!40000 ALTER TABLE `notification_setting` DISABLE KEYS */; /*!40000 ALTER TABLE `notification_setting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `packages` -- DROP TABLE IF EXISTS `packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `packages` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `package_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `price` int NOT NULL DEFAULT '0', `package_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `gig_id` bigint 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 AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `packages` -- LOCK TABLES `packages` WRITE; /*!40000 ALTER TABLE `packages` DISABLE KEYS */; INSERT INTO `packages` VALUES (1,'63ca8f623ed1a63ca8f623ed1b','silver','Silver',12,'Test 1',1,'2023-01-20 12:56:02',NULL,NULL),(2,'63ca8f623ed3763ca8f623ed38','gold','Gold',19,'Test2',1,'2023-01-20 12:56:02',NULL,NULL),(3,'63ca8f623ed4963ca8f623ed4a','diamond','Diamond',25,'Test 3',1,'2023-01-20 12:56:02',NULL,NULL),(4,'63ca8f623ed5563ca8f623ed56','custom','Custom',0,' ',1,'2023-01-20 12:56:02',NULL,NULL),(5,'63d2c7c6cee0963d2c7c6cee0a','silver','Silver',500,'Test',2,'2023-01-26 18:34:46',NULL,NULL),(6,'63d2c7c6cee2363d2c7c6cee24','gold','Gold',600,'Test 2',2,'2023-01-26 18:34:46',NULL,NULL),(7,'63d2c7c6cee3463d2c7c6cee35','diamond','Diamond',700,'Test 3',2,'2023-01-26 18:34:46',NULL,NULL),(8,'63d2c7c6cee3e63d2c7c6cee3f','custom','Custom',0,' ',2,'2023-01-26 18:34:46',NULL,NULL),(9,'63e304dba5e0d63e304dba5e0e','silver','Silver',2,'Vinyl floor stripping and waxing',3,'2023-02-08 02:11:39',NULL,NULL),(10,'63e304dba5e3463e304dba5e35','gold','Gold',5,'Marble floor refinishing',3,'2023-02-08 02:11:39',NULL,NULL),(11,'63e304dba5e5063e304dba5e51','diamond','Diamond',6,'Terrazzo floor refinishing',3,'2023-02-08 02:11:39',NULL,NULL),(12,'63e304dba5e5f63e304dba5e60','custom','Custom',0,' ',3,'2023-02-08 02:11:39',NULL,NULL),(13,'63f356579376f63f3565793771','silver','Silver',12,'Silver',4,'2023-02-20 11:15:35',NULL,NULL),(14,'63f356579379563f3565793796','gold','Gold',24,'Gold',4,'2023-02-20 11:15:35',NULL,NULL),(15,'63f35657937a763f35657937a8','diamond','Diamond',36,'Diamond',4,'2023-02-20 11:15:35',NULL,NULL),(16,'63f35657937b163f35657937b2','custom','Custom',0,' ',4,'2023-02-20 11:15:35',NULL,NULL),(17,'6437e1f2065cc6437e1f2065cd','silver','Silver',10,'Xhchx iddjdd duhd',5,'2023-04-13 11:05:22',NULL,NULL),(18,'6437e1f2065f46437e1f2065f5','gold','Gold',20,'Hcjfhd djjdusud duudud du',5,'2023-04-13 11:05:22',NULL,NULL),(19,'6437e1f2066086437e1f206609','diamond','Diamond',30,'Cdi usduid suisduidis',5,'2023-04-13 11:05:22',NULL,NULL),(20,'6437e1f2066126437e1f206613','custom','Custom',0,' ',5,'2023-04-13 11:05:22',NULL,NULL); /*!40000 ALTER TABLE `packages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rating_review` -- DROP TABLE IF EXISTS `rating_review`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `rating_review` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `actor_id` int NOT NULL, `module_id` int NOT NULL, `module_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_module_id` int NOT NULL, `reference_module_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `review` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `reply` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `rating` decimal(8,2) DEFAULT NULL, `target_id` int NOT NULL, `target_module_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) CHARACTER SET utf8mb4 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rating_review` -- LOCK TABLES `rating_review` WRITE; /*!40000 ALTER TABLE `rating_review` DISABLE KEYS */; /*!40000 ALTER TABLE `rating_review` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reset_password` -- DROP TABLE IF EXISTS `reset_password`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reset_password` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `module` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8mb4 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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reset_password` -- LOCK TABLES `reset_password` WRITE; /*!40000 ALTER TABLE `reset_password` DISABLE KEYS */; INSERT INTO `reset_password` VALUES (1,'users','terakumea20@gmail.com','JjxtWq4NxtXsf6Ujz5Q2KfAFiZZYPDknYHBtJag6WamzjzzprFke2ylZ61o9qqYJBwEVNJtlRjymtJgpJ53qUyABjOf8RZ3cqxbCNPf0IaVK6gmRoRmq4z7RP6Cez8cJ4cZ7wiURp89Bd6YLUTXBdi','2023-03-17 01:19:18',NULL,NULL),(2,'users','terakumea20@gmail.com','q0NRmJCPJ3a7fJigGBLLkqhmEaIvihZFepMVTMKPl66Pwv6wygrYYSduWbOdP87OUfzAuhJv2PCj8qsOzefIIP78IkhcZTMXcKci9xBSg6PrpGWeezjsM5BG3jAO3Ws79cHdyUao5yEz2MAzbPNBr9','2023-03-17 01:19:27',NULL,NULL),(3,'users','terakumea20@gmail.com','qGcEKQ06oE0aMdwVbxEXq6mUmU2DbqdHAdUBQ6zifFjItHksbSWAoSGHtRrkCDt7dt9SdjvgOOrTxlLb3zIEnfs8g9PUyvsEYzDk9C6JkpT4l0N1mq5q7XJY23Qcv6posNp6gVLXmZ1pRP2NUZzZZl','2023-03-17 01:19:59',NULL,NULL),(4,'users','terakumea20@gmail.com','RhL7sLyt1a2U4YGSXFySQFDMv34vJnKIWWUZQpu3Bav6VgDLEApNF5NHNcVo9sVXO0xz2YiqAbQF2Kwb5QWSKh9gPvhcbMzv252lXz7pRjAdQ8vHdiHkmsUjN0bcECqkKOyyR6cqeCzchxy8fRJzpP','2023-03-21 01:11:10',NULL,NULL),(5,'users','terakumea20@gmail.com','JeLW5acxVjZg8GoUkuSeCCimc7K0MFsFUJHhV6U51YvPl41F5YAvZvq4Jn9mf2W1flUka0Pt5Av5fn4vTD9ZhoHW6p8rI5dw9AUm2yqCy69Up2S83KQMqw1BrxwaY9JFjtSXI71xY4bqf5WOmuWo3q','2023-03-21 01:11:36',NULL,NULL),(6,'users','terakumea20@gmail.com','CE7MsfIu9DHBiqO3xDEpkZzHvgzU16pZ25Gy6oo4t2iBhRPGkPDnHbouAWl6s1oxV7oE7E1khsO7suCiKLQOovXCVuzrinZCVxmuk8lAf8QZuD5fSftrVt90RNbVXRlxfky7MM9Adb2BKQxqCwsYSt','2023-03-21 01:11:44',NULL,NULL); /*!40000 ALTER TABLE `reset_password` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `services` -- DROP TABLE IF EXISTS `services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `services` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `service` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `gig_id` bigint 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 AUTO_INCREMENT=9 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,'63ca8f623e00163ca8f623e002','Test',1,'2023-01-20 12:56:02',NULL,NULL),(2,'63d2c7c6ce0d663d2c7c6ce0d7','Services',2,'2023-01-26 18:34:46',NULL,NULL),(3,'63e304dba518f63e304dba5190','Terrazzo',3,'2023-02-08 02:11:39',NULL,NULL),(4,'63e304dba519c63e304dba519d','Marble',3,'2023-02-08 02:11:39',NULL,NULL),(5,'63e304dba51a263e304dba51a3','Traver',3,'2023-02-08 02:11:39',NULL,NULL),(6,'63e304dba51a763e304dba51a8','Vynil',3,'2023-02-08 02:11:39',NULL,NULL),(7,'63f3565792cda63f3565792cdb','Test',4,'2023-02-20 11:15:35',NULL,NULL),(8,'6437e1f205be26437e1f205be3','Aaaa',5,'2023-04-13 11:05:22',NULL,NULL); /*!40000 ALTER TABLE `services` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `skills` -- DROP TABLE IF EXISTS `skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skills` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint NOT NULL DEFAULT '1', `user_id` int NOT NULL DEFAULT '0', `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 AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `skills` -- LOCK TABLES `skills` WRITE; /*!40000 ALTER TABLE `skills` DISABLE KEYS */; INSERT INTO `skills` VALUES (1,'it-and-web','IT and Web',1,0,'2022-01-20 19:00:06',NULL,NULL),(2,'seo','SEO',1,0,'2022-01-20 19:00:06',NULL,NULL),(3,'digital-marketing','Digital Marketing',1,0,'2022-01-20 19:00:06',NULL,NULL),(4,'content-writing','Content Writing',1,0,'2022-01-20 19:00:06',NULL,NULL),(5,'vr','VR',1,0,'2022-01-20 19:00:06',NULL,NULL),(6,'mobile-apps','Mobile Apps',1,0,'2022-01-20 19:00:06',NULL,NULL),(7,'e-commerce','E-commerce',1,0,'2022-01-20 19:00:06',NULL,NULL),(8,'graphics','Graphics',1,0,'2022-01-20 19:00:06',NULL,NULL),(9,'writing','Writing',1,0,'2022-01-20 19:00:06',NULL,NULL),(10,'web-development','Web Development',1,0,'2022-01-20 19:00:06',NULL,NULL),(11,'user-persona','User Persona',1,0,'2022-01-20 19:00:06',NULL,NULL),(12,'ui','UI',1,0,'2022-01-20 19:00:06',NULL,NULL),(13,'user-experience','User Experience',1,0,'2022-01-20 19:00:06',NULL,NULL),(14,'animation','Animation',1,0,'2022-01-20 19:00:06',NULL,NULL),(15,'sketch','Sketch',1,0,'2022-01-20 19:00:06',NULL,NULL),(16,'story-board','Story Board',1,0,'2022-01-20 19:00:06',NULL,NULL),(17,'photoshop','Photoshop',1,1,'2022-01-20 14:06:54','2022-01-20 14:06:54',NULL),(18,'seo-linking','SEO Linking',1,4,'2022-01-24 07:09:54','2022-01-24 07:09:54',NULL),(19,'data-entry','Data Entry',1,4,'2022-01-24 07:41:45','2022-01-24 07:41:45',NULL),(20,'taker','Taker',0,4,'2022-01-24 07:42:48','2022-08-17 08:02:49',NULL),(21,'hello','hello',0,4,'2022-01-25 06:41:39','2022-08-17 08:02:40',NULL),(22,'62ffab85c1afa62ffab85c1afc','Musician',1,0,'2022-08-19 15:25:57','2022-08-19 15:25:57',NULL),(23,'63033297103836303329710385','aaa',0,0,'2022-08-22 07:39:03','2022-08-22 07:39:12',NULL),(24,'6303b8d7880926303b8d788093','Builder',1,0,'2022-08-22 17:11:51','2022-08-22 17:11:51',NULL),(25,'6303b8f4561926303b8f456194','Electrician',1,0,'2022-08-22 17:12:20','2022-08-22 17:12:20',NULL),(26,'6303b901d78236303b901d7825','Web designer',1,0,'2022-08-22 17:12:33','2022-08-22 17:12:55',NULL),(27,'6303b92ea93206303b92ea9321','Cleaner',1,0,'2022-08-22 17:13:18','2022-08-22 17:14:28',NULL),(28,'6303ba297b6086303ba297b609','Housesitter',1,0,'2022-08-22 17:17:29','2022-08-22 17:17:29',NULL),(29,'6303ba3f5ee6c6303ba3f5ee6e','Babysitter',1,0,'2022-08-22 17:17:51','2022-08-22 17:17:55',NULL),(30,'crash','crash',1,3,'2022-09-06 12:09:43','2022-09-06 12:09:43',NULL),(31,'tester','tester',1,3,'2022-09-06 13:13:30','2022-09-06 13:13:30',NULL),(32,'new','new',1,3,'2022-09-07 07:19:20','2022-09-07 07:19:20',NULL),(33,'abcde','abcde',1,3,'2022-09-07 08:16:25','2022-09-07 08:16:25',NULL),(34,'dsfdsfg','dsfdsfg',1,3,'2022-09-07 08:17:11','2022-09-07 08:17:11',NULL),(35,'dsfdsfgas','dsfdsfgas',1,3,'2022-09-07 08:17:31','2022-09-07 08:17:31',NULL),(36,'dsfdsfga','dsfdsfga',1,3,'2022-09-07 08:17:51','2022-09-07 08:17:51',NULL),(37,'test','test',1,3,'2022-09-07 08:21:45','2022-09-07 08:21:45',NULL),(38,'asd','asd',1,3,'2022-09-07 08:24:24','2022-09-07 08:24:24',NULL),(39,'asdfsdf','asdfsdf',1,3,'2022-09-07 08:24:36','2022-09-07 08:24:36',NULL),(40,'jjjjjj','jjjjjj',1,2,'2022-09-07 12:49:08','2022-09-07 12:49:08',NULL),(41,'631ae3fbde3b4631ae3fbde3b5','Band Aid',1,0,'2022-09-09 06:58:03','2022-09-09 06:58:03',NULL),(42,'date','date',1,3,'2022-09-09 12:26:33','2022-09-09 12:26:33',NULL),(43,'trans','trans',1,25,'2022-10-21 17:06:38','2022-10-21 17:06:38',NULL),(44,'translater','translater',1,25,'2022-10-21 17:07:02','2022-10-21 17:07:02',NULL),(45,'gggggg-bdhdh','gggggg bdhdh',1,2,'2023-01-31 12:51:44','2023-01-31 12:51:44',NULL),(46,'terrazzo-flooring','terrazzo flooring',1,11,'2023-02-08 01:59:34','2023-02-08 01:59:34',NULL),(47,'marble-floor-restoration','Marble floor restoration',1,11,'2023-02-08 01:59:53','2023-02-08 01:59:53',NULL),(48,'vinyl-floor-stripping-and-waxing','Vinyl floor stripping and waxing',1,11,'2023-02-08 02:00:11','2023-02-08 02:00:11',NULL),(49,'travertine-restoration','travertine restoration',1,11,'2023-02-08 02:00:29','2023-02-08 02:00:29',NULL); /*!40000 ALTER TABLE `skills` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_api_token` -- DROP TABLE IF EXISTS `user_api_token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_api_token` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `api_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `refresh_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `udid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `device_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `device_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `platform_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'custom', `platform_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `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 AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_api_token` -- LOCK TABLES `user_api_token` WRITE; /*!40000 ALTER TABLE `user_api_token` DISABLE KEYS */; INSERT INTO `user_api_token` VALUES (1,1,'f188d779d06eb6cdfba7a526852a20449b48d3e28cf3afce489cb52b237ab391','ea84d0bfc78e764f0c5fc3196adcae03335596d03bff4584f0854e1d72fd8302','api.Pd*!(5675','ios','be6a7910-6bbe-4a20-9b4d-024b9300b55a','apple',NULL,'94.59.78.104','GigmeHQ/1 CFNetwork/1402.0.8 Darwin/22.2.0','2023-01-20 11:18:56','2023-01-20 11:18:56',NULL),(15,8,'f666d48b420872a499d414dc2c1239fc1727ceeb0c97cbc2cfe6a90bdcb7fb71','6d991efdf6530956a7b200393c3415bf67c24874b969755c79913e1ae6aeb24b','api.Pd*!(5675','ios','0d75fdfb-861c-48f2-b44e-95e23a83ddb8','google',NULL,'119.73.104.164','GigmeHQ/1 CFNetwork/1333.0.4 Darwin/21.5.0','2023-01-26 18:40:48','2023-01-26 18:40:48',NULL),(16,10,'d4e5422ce9d560eafdb216d2747034576eea0565819075919030991cf4e35c09','41fb4402c6c210cb24b2a5bf7e341972089d7141e86ad083b5396d3a48826c90','api.Pd*!(5675','android','af022404-d5dd-4858-8cae-e2c19c7b2d41','custom',NULL,'189.216.25.181','okhttp/4.9.1','2023-01-26 22:12:30',NULL,NULL),(17,11,'1e02c8147b5445b401a29a1100c82c48288a345694f92869519e66ff6ed762a0','0a06d26507837e84e00e6968f82580841ee83d2786517847aa5fb8267a08b752','api.Pd*!(5675','android','a300dcf4-02bb-434e-a0d8-bbf5e4142100','custom',NULL,'47.197.240.194','okhttp/4.9.1','2023-02-08 01:57:41','2023-02-08 01:57:41',NULL),(18,12,'e9c103794c867e463f7a1e0ef2be60eb1df7a7cc8f8c4cb9875d44c30586bce0','d1ebc10656e35407a7aaa3e4809efc63230234cdf3f9b7c19fd35f4e36efb173','api.Pd*!(5675','ios','a90a2600-8c2a-4595-8bf5-d3935c4de3d6','custom',NULL,'94.59.152.159','GigmeHQ/1 CFNetwork/1402.0.8 Darwin/22.2.0','2023-01-30 19:01:32','2023-01-30 19:01:32',NULL),(23,15,'6b3dc2e3aa4f8647408588dc129b853e3791ec3e830a44a6fe8a295946f03b95','54e6359782531b0cfa6541ea47ce78fbd63cd0eb6f6aae08666e684a699dc602','api.Pd*!(5675','ios','c91809b6-ba68-4cec-aadc-e9edd4eb1202','google',NULL,'31.187.78.186','GigmeHQ/1 CFNetwork/1402.0.8 Darwin/22.2.0','2023-02-03 11:48:06','2023-02-03 11:48:06',NULL),(24,16,'8128457a32759d5bc8589890a24663790e62c8c7c3e84fca88822bf997e89399','54c8518314bc6ebbb32132e4cfdb47f524cc228dc3cc7ab125783991026fe725','api.Pd*!(5675','ios','f1baab0f-999d-4ab5-a7e8-87ba53a2676b','custom',NULL,'103.86.55.218','GigmeHQ/1 CFNetwork/1329 Darwin/21.3.0','2023-02-13 12:47:26','2023-02-13 12:47:26',NULL),(35,19,'e0fb414a1ef09bc41cad52d8ffcccee3cfceebc3f57b3bf043f5e76773ba4a5f','fd4dacb2dd63fdff1b3a4d90d757564155657f55f58b9b07aa73b0f87ff6ef1d','e772afbf-65a2-4263-9ef9-65a3763d44b4','ios','54321','apple',NULL,'103.86.55.218','PostmanRuntime/7.30.0','2023-02-17 11:20:05','2023-02-17 11:20:05',NULL),(37,2,'6ba4118a6154e477328fd1581ca646c313a2c8c0d730a6ea4d4792822e0139a5','fb5d454b05782054d9ffd805eed2faa5d83d928aaa8c216b79454b3da1cc3c68','e772afbf-65a2-4263-9ef9-65a3763d55b5','android','1234567890','custom',NULL,'103.86.55.218','PostmanRuntime/7.31.0','2023-02-17 11:38:26','2023-02-17 11:38:26',NULL),(38,17,'81c6ebf829f1e55650d0f84f915024ce0ed8d3b62d028d5fc1d24cc3d80ba3d7','87fd6964bb3d4110c209f53adf890ed00b4b2ac2ac786c9cbb2a7c95ca0ccb5d','e772afbf-65a2-4263-9ef9-65a3763d44b4','ios','54321','google',NULL,'103.86.55.218','PostmanRuntime/7.31.0','2023-02-17 11:45:29','2023-02-17 11:45:29',NULL),(50,24,'003e9ce4e7d5a3f02a0f14a0e85f231942e39bc857e2e1605a375266b03de4ff','216887c981e3a2dfe6d1bbf3065aa00b167f9316c0283950c38627cf4b4f6bbf','api.Pd*!(5675','ios','825f6f0f-ae9f-40eb-afa8-c121e824cbf6','custom',NULL,'103.86.55.218','GigmeHQ/1 CFNetwork/1333.0.4 Darwin/21.6.0','2023-02-20 07:29:48',NULL,NULL),(51,25,'80754fb3e2cabbed5ce69a512bc5b2869015cfe853cec23ed769d5e1c2755f09','9348e5fc46d772082ed395bda2a8ef5ff63b44b9a2b2eecc555b5bf3f460be7e','api.Pd*!(5675','ios','825f6f0f-ae9f-40eb-afa8-c121e824cbf6','custom',NULL,'103.86.55.218','GigmeHQ/1 CFNetwork/1333.0.4 Darwin/21.6.0','2023-02-20 07:40:12','2023-02-20 07:40:12',NULL),(65,4,'33e2b65b78e9ff5eeb764fcd84edd7f0d7dea389afdd8334ccb6d6a1f92fc163','58a2a282cae8de183ed66d6cfd0dad439530a054f1f21a8fa10131ed29f0f9f8','api.Pd*!(5675','android','c4be1a00-913d-41c6-9344-aa99b2cc3109','custom',NULL,'92.99.77.211','okhttp/4.9.2','2023-04-16 04:57:42','2023-04-16 04:57:42',NULL),(68,27,'4f22088e13072453f294d28f937e58c3ef97371d9abede46a4142ec067b314a7','4393a1261771be85df5f96b01ed45c41c0e6e2e2db70c036119b0b321915f405','api.Pd*!(5675','ios','956a613e-ac43-4a79-b2d6-9c6c95ed3b9b','custom',NULL,'103.152.112.156','GigmeHQ/1 CFNetwork/1335.0.3 Darwin/21.6.0','2023-03-01 11:18:00','2023-03-01 11:18:00',NULL),(69,28,'1ee3e4c42ab17fd89576aaa676cd915afbd050d6a3b741bad672713211b1a4a4','32e0914a43fd1124d0ef95f69802761df2c2f72a848fd49acd002d46f48da054','api.Pd*!(5675','android','e62048b6-bb83-4e56-ab2f-8e0a80717378','custom',NULL,'134.195.224.126','okhttp/4.9.1','2023-03-03 19:56:05','2023-03-03 19:56:05',NULL),(70,29,'2c6bea57189a21adea01c21508eb1908356ecee16a994aee18d8aae94d0f2ef2','036be64f7577347c9975e6f7129fc97b2e043234d2f1c74076ae0a5ed2c64bed','api.Pd*!(5675','ios','0c92ac97-f428-4ee9-b571-4963175b2673','custom',NULL,'5.194.214.181','GigmeHQ/1 CFNetwork/1399 Darwin/22.1.0','2023-03-09 07:20:37','2023-03-09 07:20:37',NULL),(71,30,'9ef36959846564c3b931733fd2dc76f38c53ae9cd3d204ec102a3e4ce1a12372','3e8bdf36b9744334cf723e060f445794288bd038baf4157c165a14ce01600e7f','api.Pd*!(5675','ios','62095598-b8e1-4783-aa37-caf1a3ec79bd','google',NULL,'162.156.92.51','GigmeHQ/1 CFNetwork/1406.0.4 Darwin/22.4.0','2023-03-11 22:34:54','2023-03-11 22:34:54',NULL),(73,32,'be3695a7d8c354d1d5cd71cfc5137c3484fcce9f9e998513f20b49401a8cc617','3b433de3f8284a5e0cc1c60e25db70f810cd883b4cde50cc733472fc2746d360','api.Pd*!(5675','ios','99489d61-b63a-48e6-a746-0131450dfb3b','custom',NULL,'5.38.108.1','GigmeHQ/1 CFNetwork/1404.0.5 Darwin/22.3.0','2023-03-16 06:34:01',NULL,NULL),(74,33,'107739e872d527f97ecdc6ef46f2fa18d1cf5322d9abe64dae11e608e2fc5dbb','00178fde1a0c295b1dcbd63070b494966d550ea316bb5dd614f8873085e16adb','api.Pd*!(5675','ios','95bb6565-2d64-44af-a34f-a8e8db3742a9','custom',NULL,'112.200.162.142','GigmeHQ/1 CFNetwork/1404.0.5 Darwin/22.3.0','2023-03-23 11:19:57','2023-03-23 11:19:57',NULL),(75,34,'4ae8534c30e4de7a666c0584b72300eb2a45af72ec732389b7ed950e24c2b716','0c057bdb2078e87e2a9acaa2c3abdc866d9b423aac55e25f52370ee1702acc42','api.Pd*!(5675','ios','7b412505-1a8e-4825-b59f-5f5080902bc7','custom',NULL,'94.57.121.213','GigmeHQ/1 CFNetwork/1399 Darwin/22.1.0','2023-03-24 19:33:52','2023-03-24 19:33:52',NULL),(79,36,'019c64f5e4914439fb106194bd279ac9601d7dbfb73943964eefc065ef66ecda','ea05e2592566ebf5fe16a359c7eacf409055c10bc32918ad53db4871a7d9e4cd','api.Pd*!(5675','android','5ee80623-630e-4daf-8ecf-d71b872b2fb4','custom',NULL,'103.86.55.218','okhttp/4.9.2','2023-04-13 11:15:05','2023-04-13 11:15:05',NULL),(80,37,'c2f36f9567110f8560bfcdcea12736b674451a664b5d034e50ba74e530f01372','dc0d7354bf1cd1bde1f57925d19ddd52b72268610f3849717e11c5de9a8dc7b8','api.Pd*!(5675','android','6d830498-df0c-4d6c-8630-4da137e48a89','custom',NULL,'166.196.58.15','okhttp/4.9.2','2023-04-13 13:54:52',NULL,NULL),(83,38,'2c8f89f6640e7b682b8d00b008b75dc05a034ee3e3d2ec863ec93e1a74ddc492','d0e9280701e2c8f053ddea963b7374da9c73c16da30943c95b0f81d5dfd130e5','api.Pd*!(5675','android','92d246af-c689-49ab-9b50-6d8792158912','custom',NULL,'92.99.77.211','okhttp/4.9.2','2023-04-14 11:45:46',NULL,NULL),(85,39,'4877dfd76e9f02b746c37a6a73cccaab63af929a7f005a51f74052bfa1e9a251','fe806015067b70861507bd32f97a9f206be155a3c760454441f064000fedacc2','api.Pd*!(5675','ios','6aeb8d70-1ebf-4dca-98e4-a7daab31f8e0','apple',NULL,'139.178.131.2','GigmeHQ/4 CFNetwork/1406.0.4 Darwin/22.4.0','2023-04-14 13:05:03','2023-04-14 13:05:03',NULL),(91,35,'9a3b12f9f561bec600fb5150166ad7a413d2dd73a098a860c2650278a7cd7ed8','d6d697052378b9451b38e1c8eac5ff85d9a5958d39e64b7c6e4c3c663a322a5d','api.Pd*!(5675','android','9963cf21-1b78-4f78-b356-b7cb3dac5f0f','google',NULL,'103.86.55.218','okhttp/4.9.2','2023-04-17 11:18:14','2023-04-17 11:18:14',NULL),(92,13,'2652d7629156c1491033eae7f999c62e6f66994d762d638a94fc2e64240911bc','954872ef48f6c70da5b06058c3a3665e5b5351e0dcfc010b0f3c5a0d33b99271','api.Pd*!(5675','ios','ab4ee1d3-9c77-40ff-8cef-baddeed082ee','google',NULL,'103.86.55.218','GigmeHQ/1 CFNetwork/1402.0.8 Darwin/22.4.0','2023-04-18 09:49:06','2023-04-18 09:49:06',NULL); /*!40000 ALTER TABLE `user_api_token` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_billing_account` -- DROP TABLE IF EXISTS `user_billing_account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_billing_account` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `first_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_of_birth` date DEFAULT NULL, `location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ssn` int DEFAULT NULL, `account_number` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL, `routing_number` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `card_holder_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image_front` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `image_back` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_billing_account_email_unique` (`email`), UNIQUE KEY `user_billing_account_mobile_no_unique` (`mobile_no`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_billing_account` -- LOCK TABLES `user_billing_account` WRITE; /*!40000 ALTER TABLE `user_billing_account` DISABLE KEYS */; INSERT INTO `user_billing_account` VALUES (1,'63e0ad191ad9d63e0ad191ad9e',4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2147483647','1234','Sarah',NULL,NULL,'2023-02-06 07:32:41','2023-02-06 07:32:41',NULL),(2,'6437ddd3ceb426437ddd3ceb43',13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'000123456789','110000000','Test',NULL,NULL,'2023-04-13 10:47:47','2023-04-13 10:47:47',NULL); /*!40000 ALTER TABLE `user_billing_account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_card_detail` -- DROP TABLE IF EXISTS `user_card_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_card_detail` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `customer_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `card_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `last_4_digit` int NOT NULL DEFAULT '0', `is_default` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `card_brand` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_card_detail` -- LOCK TABLES `user_card_detail` WRITE; /*!40000 ALTER TABLE `user_card_detail` DISABLE KEYS */; INSERT INTO `user_card_detail` VALUES (1,4,'cus_NEvI3nJOfkZHgY','card_1MfnUhCI6191st8597YEwbiI',9654,'1','MasterCard','2023-02-26 16:54:42',NULL,NULL); /*!40000 ALTER TABLE `user_card_detail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_cashout_request` -- DROP TABLE IF EXISTS `user_cashout_request`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_cashout_request` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL, `amount` int NOT NULL, `status` enum('pending','approved','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_cashout_request_slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_cashout_request` -- LOCK TABLES `user_cashout_request` WRITE; /*!40000 ALTER TABLE `user_cashout_request` DISABLE KEYS */; /*!40000 ALTER TABLE `user_cashout_request` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_earnings` -- DROP TABLE IF EXISTS `user_earnings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_earnings` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `module_id` int NOT NULL, `module` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(11,2) NOT NULL, `admin_amount` decimal(11,2) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_earnings` -- LOCK TABLES `user_earnings` WRITE; /*!40000 ALTER TABLE `user_earnings` DISABLE KEYS */; /*!40000 ALTER TABLE `user_earnings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_groups` -- DROP TABLE IF EXISTS `user_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_groups` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('1','0') CHARACTER SET utf8mb4 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_groups` -- LOCK TABLES `user_groups` WRITE; /*!40000 ALTER TABLE `user_groups` DISABLE KEYS */; INSERT INTO `user_groups` VALUES (1,'App User','app-user','1','2022-01-20 14:00:06',NULL,NULL),(2,'Freelancer','freelancer','1','2022-01-20 14:00:06',NULL,NULL); /*!40000 ALTER TABLE `user_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_json_skills` -- DROP TABLE IF EXISTS `user_json_skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_json_skills` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `skill_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_json_skills` -- LOCK TABLES `user_json_skills` WRITE; /*!40000 ALTER TABLE `user_json_skills` DISABLE KEYS */; /*!40000 ALTER TABLE `user_json_skills` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_preferences` -- DROP TABLE IF EXISTS `user_preferences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_preferences` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint unsigned NOT NULL, `user_id` bigint 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 AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_preferences` -- LOCK TABLES `user_preferences` WRITE; /*!40000 ALTER TABLE `user_preferences` DISABLE KEYS */; INSERT INTO `user_preferences` VALUES (6,27,2,'2023-01-20 12:52:05',NULL,NULL),(7,26,2,'2023-01-20 12:52:05',NULL,NULL),(8,23,2,'2023-01-20 12:52:05',NULL,NULL),(9,21,2,'2023-01-20 12:52:05',NULL,NULL),(10,20,2,'2023-01-20 12:52:05',NULL,NULL),(30,24,10,'2023-01-26 22:12:30',NULL,NULL),(31,23,10,'2023-01-26 22:12:30',NULL,NULL),(32,22,10,'2023-01-26 22:12:30',NULL,NULL),(33,20,10,'2023-01-26 22:12:30',NULL,NULL),(34,21,10,'2023-01-26 22:12:30',NULL,NULL),(35,29,10,'2023-01-26 22:12:30',NULL,NULL),(36,28,10,'2023-01-26 22:12:30',NULL,NULL),(37,27,10,'2023-01-26 22:12:30',NULL,NULL),(38,26,10,'2023-01-26 22:12:30',NULL,NULL),(39,25,10,'2023-01-26 22:12:30',NULL,NULL),(40,29,11,'2023-01-27 04:53:54',NULL,NULL),(41,24,11,'2023-01-27 04:53:54',NULL,NULL),(42,27,11,'2023-01-27 04:53:54',NULL,NULL),(43,21,11,'2023-01-27 04:53:54',NULL,NULL),(44,20,11,'2023-01-27 04:53:54',NULL,NULL),(45,23,11,'2023-01-27 04:53:54',NULL,NULL),(51,27,12,'2023-01-30 19:01:08',NULL,NULL),(52,24,12,'2023-01-30 19:01:08',NULL,NULL),(53,23,12,'2023-01-30 19:01:08',NULL,NULL),(54,23,14,'2023-02-01 23:34:51',NULL,NULL),(55,28,16,'2023-02-13 12:46:28',NULL,NULL),(56,25,16,'2023-02-13 12:46:28',NULL,NULL),(57,20,24,'2023-02-20 07:29:48',NULL,NULL),(58,21,24,'2023-02-20 07:29:48',NULL,NULL),(59,26,24,'2023-02-20 07:29:48',NULL,NULL),(60,20,25,'2023-02-20 07:33:59',NULL,NULL),(61,14,25,'2023-02-20 07:33:59',NULL,NULL),(62,23,25,'2023-02-20 07:33:59',NULL,NULL),(66,26,4,'2023-02-26 16:55:18',NULL,NULL),(67,29,4,'2023-02-26 16:55:18',NULL,NULL),(68,27,4,'2023-02-26 16:55:18',NULL,NULL),(69,28,4,'2023-02-26 16:55:18',NULL,NULL),(70,23,4,'2023-02-26 16:55:18',NULL,NULL),(71,3,27,'2023-03-01 11:17:09',NULL,NULL),(72,20,28,'2023-03-03 19:55:26',NULL,NULL),(83,27,29,'2023-03-09 07:23:52',NULL,NULL),(84,3,29,'2023-03-09 07:23:52',NULL,NULL),(85,22,29,'2023-03-09 07:23:52',NULL,NULL),(86,23,29,'2023-03-09 07:23:52',NULL,NULL),(87,7,29,'2023-03-09 07:23:52',NULL,NULL),(88,4,29,'2023-03-09 07:23:52',NULL,NULL),(89,26,29,'2023-03-09 07:23:52',NULL,NULL),(90,21,29,'2023-03-09 07:23:52',NULL,NULL),(91,20,29,'2023-03-09 07:23:52',NULL,NULL),(92,14,29,'2023-03-09 07:23:52',NULL,NULL),(93,4,31,'2023-03-13 20:13:25',NULL,NULL),(94,23,31,'2023-03-13 20:13:25',NULL,NULL),(95,3,31,'2023-03-13 20:13:25',NULL,NULL),(96,7,31,'2023-03-13 20:13:25',NULL,NULL),(97,26,31,'2023-03-13 20:13:25',NULL,NULL),(98,20,32,'2023-03-16 06:34:01',NULL,NULL),(99,26,32,'2023-03-16 06:34:01',NULL,NULL),(100,4,32,'2023-03-16 06:34:01',NULL,NULL),(101,23,32,'2023-03-16 06:34:01',NULL,NULL),(102,22,32,'2023-03-16 06:34:01',NULL,NULL),(103,7,32,'2023-03-16 06:34:01',NULL,NULL),(104,27,32,'2023-03-16 06:34:01',NULL,NULL),(105,3,32,'2023-03-16 06:34:01',NULL,NULL),(106,14,32,'2023-03-16 06:34:01',NULL,NULL),(107,21,32,'2023-03-16 06:34:01',NULL,NULL),(114,3,34,'2023-03-24 19:37:00',NULL,NULL),(115,23,34,'2023-03-24 19:37:00',NULL,NULL),(116,14,34,'2023-03-24 19:37:00',NULL,NULL),(117,7,34,'2023-03-24 19:37:00',NULL,NULL),(120,26,33,'2023-03-27 10:46:49',NULL,NULL),(121,7,33,'2023-03-27 10:46:49',NULL,NULL),(122,20,36,'2023-04-13 11:14:17',NULL,NULL),(123,21,36,'2023-04-13 11:14:17',NULL,NULL),(124,14,36,'2023-04-13 11:14:17',NULL,NULL),(125,20,37,'2023-04-13 13:54:52',NULL,NULL),(126,22,37,'2023-04-13 13:54:52',NULL,NULL),(127,27,37,'2023-04-13 13:54:52',NULL,NULL),(135,26,3,'2023-04-14 11:31:15',NULL,NULL),(136,25,3,'2023-04-14 11:31:15',NULL,NULL),(137,23,3,'2023-04-14 11:31:15',NULL,NULL),(138,24,3,'2023-04-14 11:31:15',NULL,NULL),(139,21,3,'2023-04-14 11:31:15',NULL,NULL),(140,22,3,'2023-04-14 11:31:15',NULL,NULL),(141,20,3,'2023-04-14 11:31:15',NULL,NULL),(142,20,38,'2023-04-14 11:45:46',NULL,NULL),(143,26,38,'2023-04-14 11:45:46',NULL,NULL),(144,23,38,'2023-04-14 11:45:46',NULL,NULL),(145,14,42,'2023-04-18 08:07:08',NULL,NULL),(146,22,42,'2023-04-18 08:07:08',NULL,NULL),(147,23,42,'2023-04-18 08:07:08',NULL,NULL),(166,20,13,'2023-04-18 09:52:06',NULL,NULL),(167,21,13,'2023-04-18 09:52:06',NULL,NULL),(168,26,13,'2023-04-18 09:52:06',NULL,NULL); /*!40000 ALTER TABLE `user_preferences` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_skills` -- DROP TABLE IF EXISTS `user_skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_skills` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `skill_id` bigint unsigned NOT NULL, `user_id` bigint 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 AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_skills` -- LOCK TABLES `user_skills` WRITE; /*!40000 ALTER TABLE `user_skills` DISABLE KEYS */; INSERT INTO `user_skills` VALUES (1,32,3,'2023-01-20 12:54:46',NULL,NULL),(2,35,3,'2023-01-20 12:54:46',NULL,NULL),(3,34,3,'2023-01-20 12:54:46',NULL,NULL),(4,33,3,'2023-01-20 12:54:46',NULL,NULL),(5,36,3,'2023-01-20 12:54:46',NULL,NULL),(6,38,3,'2023-01-20 12:54:46',NULL,NULL),(7,41,3,'2023-01-20 12:54:46',NULL,NULL),(8,39,3,'2023-01-20 12:54:46',NULL,NULL),(9,37,3,'2023-01-20 12:54:46',NULL,NULL),(16,27,1,'2023-01-26 05:21:04',NULL,NULL),(17,28,1,'2023-01-26 05:21:04',NULL,NULL),(18,29,1,'2023-01-26 05:21:04',NULL,NULL),(19,25,6,'2023-01-26 11:41:58',NULL,NULL),(20,26,6,'2023-01-26 11:41:58',NULL,NULL),(21,22,6,'2023-01-26 11:41:58',NULL,NULL),(22,16,6,'2023-01-26 11:41:58',NULL,NULL),(23,28,6,'2023-01-26 11:41:58',NULL,NULL),(24,29,6,'2023-01-26 11:41:58',NULL,NULL),(34,16,8,'2023-01-26 17:58:41',NULL,NULL),(35,25,8,'2023-01-26 17:58:41',NULL,NULL),(36,28,8,'2023-01-26 17:58:41',NULL,NULL),(37,22,8,'2023-01-26 17:58:41',NULL,NULL),(38,26,8,'2023-01-26 17:58:41',NULL,NULL),(39,29,8,'2023-01-26 17:58:41',NULL,NULL),(40,24,8,'2023-01-26 17:58:41',NULL,NULL),(41,27,8,'2023-01-26 17:58:41',NULL,NULL),(42,15,8,'2023-01-26 17:58:41',NULL,NULL),(47,26,13,'2023-01-31 13:09:47',NULL,NULL),(48,24,13,'2023-01-31 13:09:47',NULL,NULL),(49,27,4,'2023-02-06 07:30:25',NULL,NULL),(50,28,4,'2023-02-06 07:30:25',NULL,NULL),(51,25,4,'2023-02-06 07:30:25',NULL,NULL),(52,24,4,'2023-02-06 07:30:25',NULL,NULL),(53,19,4,'2023-02-06 07:30:25',NULL,NULL),(54,18,4,'2023-02-06 07:30:25',NULL,NULL),(55,46,11,'2023-02-08 02:00:48',NULL,NULL),(56,47,11,'2023-02-08 02:00:48',NULL,NULL),(57,48,11,'2023-02-08 02:00:48',NULL,NULL),(58,49,11,'2023-02-08 02:00:48',NULL,NULL),(59,41,17,'2023-02-17 10:29:54',NULL,NULL),(71,45,2,'2023-02-22 09:37:11',NULL,NULL),(72,29,2,'2023-02-22 09:37:11',NULL,NULL),(73,41,35,'2023-04-13 11:10:32',NULL,NULL),(74,29,35,'2023-04-13 11:10:32',NULL,NULL),(75,28,35,'2023-04-13 11:10:32',NULL,NULL),(76,26,35,'2023-04-13 11:10:32',NULL,NULL),(77,15,35,'2023-04-13 11:10:32',NULL,NULL); /*!40000 ALTER TABLE `user_skills` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_transactions` -- DROP TABLE IF EXISTS `user_transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_transactions` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `user_card_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `gateway_charge_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `module_id` int NOT NULL, `module` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `charge_amount` int NOT NULL, `platform_fee` decimal(10,2) NOT NULL, `net_amount` decimal(11,2) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_transactions` -- LOCK TABLES `user_transactions` WRITE; /*!40000 ALTER TABLE `user_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `user_transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_group_id` bigint unsigned NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `image_blur_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `is_complete` int NOT NULL DEFAULT '0', `is_email_verify` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `email_verify_at` datetime DEFAULT NULL, `is_mobile_verify` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `mobile_verify_at` datetime DEFAULT NULL, `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `zipcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `latitude` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `longitude` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `online_status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `mobile_otp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_otp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `years_of_experience` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `review_count` int NOT NULL DEFAULT '0', `total_rating` decimal(10,1) DEFAULT NULL, `total_booking` int NOT NULL DEFAULT '0', `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `gateway_customer_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total_earning` int NOT NULL DEFAULT '0', `total_cashout` int NOT NULL DEFAULT '0', `current_balance` int NOT NULL DEFAULT '0', 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 AUTO_INCREMENT=43 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,2,'BenjaminGibbons','benjamingibbons','benjamingibbons','cq84yj7jnq@privaterelay.appleid.com',NULL,'$2y$10$H4yTnsgMOtPBkhFkKSRZXe1buRSxL86MMSogL3hsOe5NWBU9oJvHW',NULL,NULL,'1',1,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,'F93G+CX7 - Al Mushrif - Abu Dhabi - United Arab Emirates','24.453403670699238','54.37734369188547','0',NULL,NULL,'Test\nNo lg\nDdbscav\nAcsgav\nAfavac','100',0,NULL,0,NULL,'2023-01-20 11:18:56','2023-01-26 05:26:16',NULL,NULL,0,0,0),(2,1,'Peter','peter','peter','Peter@yopmail.com','+1-8004444896','$2y$10$HvhTCYkXiRDqZRtaCSGpMOygyhlvD0/9EswvTnUu8yQDtQzt72g/m','users/ZG3mJVHZtMxcz8gew8qPhRrPZCwabxffiTEjfDfy.jpg',NULL,'1',1,'1','2023-01-20 12:51:22','0',NULL,NULL,NULL,NULL,NULL,'J 906 VVIP ADDRESSES, NH58 Bypass, Raj Nagar Extension, Ghaziabad, Uttar Pradesh 201027, India','28.698604079218235','77.43039440363646','0',NULL,NULL,'Gdhdh','12',0,NULL,0,NULL,'2023-01-20 12:51:11','2023-02-22 10:04:33',NULL,'cus_NCjW6Qu14YPSIs',0,0,0),(3,1,'Charles 1','charles','charles','Charles@yopmail.com','+1-8004444801','$2y$10$jtizJ8VtHJHADimohaiI6OOIX0RlTPMF5k5VXjOQtU7WsKgq.syMy','users/FjL4U3fAcJxQ4Yn6icjvTtHYP7e71DYhT2X0cwLH.jpg',NULL,'1',1,'1','2023-01-20 12:53:03','0',NULL,NULL,NULL,NULL,NULL,'143 Financial Center Rd - Downtown Dubai - Dubai - United Arab Emirates','25.198267957705536','55.27960527688265','0',NULL,NULL,'I am a professional content writer.','5',0,NULL,0,NULL,'2023-01-20 12:52:51','2023-04-14 11:31:26',NULL,'cus_NCjYnIBnbKMtvv',0,0,0),(4,1,'Sarah Gage','sarah','sarah','gagesarah17@gmail.com','+971-564748963','$2y$10$hBEQ6W32d25N1Abz4lR4dugLpGZ0sLN8rGCyEFPTmIBVDGMCJenbC','users/fyTJSpWC4rJMB8xU0sENr71BsYLJVAkc4UE5yRlM.jpg',NULL,'1',1,'1','2023-01-26 09:09:28','0',NULL,NULL,NULL,NULL,NULL,'Abu Dhabi - Mohamed Bin Zayed City - Z13 - Abu Dhabi - United Arab Emirates','24.344534233115322','54.56409065052867','0',NULL,NULL,'Spray tan specialist. Manual spraytans. Using LA tan. Mobile service available 9-3pm daily','20',0,NULL,0,NULL,'2023-01-26 09:09:04','2023-03-21 13:08:01',NULL,'cus_NEvI3nJOfkZHgY',0,0,0),(5,1,'Hameez Raj Chohan','hameez-raj-chohan','hameez-raj-chohan','chohanhameezraj@gmail.com',NULL,'$2y$10$GGdiIyw/QvpBnqcxVZr1Wu4foJIPe9OKLA0G0csh9w4c5KqoCtixG',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-01-26 11:36:52','2023-01-26 17:47:11',NULL,NULL,0,0,0),(6,1,'Martin Joe','martin-joe','martin-joe','martinjoey2j618@gmail.com',NULL,'$2y$10$eClZtNm7EBEIbZSz25v5IOKzU2euoT1CM2ZSpFe.B/v79zBs/i7RO',NULL,NULL,'1',1,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,'65HG+22J - The World Islands - Dubai - United Arab Emirates','25.22758013499095','55.175012201070786','0',NULL,NULL,'Test','10',0,NULL,0,NULL,'2023-01-26 11:41:08','2023-01-26 17:45:45',NULL,NULL,0,0,0),(7,1,'Hameez RajChohan','hameez-rajchohan','hameez-rajchohan','hameez.12@icloud.com',NULL,'$2y$10$ugalsjYr.Yo5ksKLOxLGLeTvmTDsmxU.eXSkFoL.axnztDc.GM98O',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-01-26 17:47:26',NULL,NULL,NULL,0,0,0),(8,1,'Henry David','henry-david','henry-david','henrydavids834@gmail.com',NULL,'$2y$10$fex7igOmv/yRltOI0/i7NOOu3JpP9L494IAZHRY/WZyY6E.Hdh/Wy',NULL,NULL,'1',1,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,'65HG+22J - The World Islands - Dubai - United Arab Emirates','25.22758013499095','55.175012201070786','0',NULL,NULL,'test','4',0,NULL,0,NULL,'2023-01-26 17:57:18','2023-01-31 13:53:02',NULL,NULL,0,0,0),(9,1,'Martin David','martin-david','martin-david','martindavidy2j618@gmail.com',NULL,'$2y$10$bbYPe3AJ9gy.FcFWDIBDNuyycUU8H7KYHAdCd9z6wrUJgykY41rgq',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-01-26 18:35:30',NULL,NULL,NULL,0,0,0),(10,1,'Rufino Acevedo','rufino-acevedo','rufino-acevedo','rocharino46@gmail.com','+1-9153305092','$2y$10$dBmkCDKdmgISgvZo/n0GNu1sN8GzBbWMn3a1lsz0xKOn7Yt7oBfVe',NULL,NULL,'1',0,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-01-26 22:12:30','2023-01-26 22:12:30',NULL,'cus_NF7ww97N7T1SDj',0,0,0),(11,2,'Luis terrazzo floor restoration','luis','luis','Luie7377@gmail.com','+1-8132038880','$2y$10$cI9yX79vAMy8qcyPaSeS5unHxZCeljln/k1lpXKF1lhSotD2qcwHu','users/9J43zqhKZWxnv5M0TZVuHQ4gABQSVxXl7SqhxG8I.jpg',NULL,'1',1,'1','2023-01-27 04:54:51','0',NULL,NULL,NULL,NULL,NULL,'2519 Siesta Ct, Tampa, FL 33614, USA','27.994435958611277','-82.48539565131068','0',NULL,NULL,'Been refinishing floors since 2016 especially terrazzo floor and vinyl flooring check us out','14',0,NULL,0,NULL,'2023-01-27 04:53:54','2023-03-10 04:18:38',NULL,'cus_NFEP7bgeVUEEp9',0,0,0),(12,1,'Dillon Gage','dillon-gage','dillon-gage','dmdgage@hotmail.com','+971-502043009','$2y$10$gxMURvqH8rrnTkjRZFjj0.1lxyCXJ668TsPE/l20Z9qPS.PJVPA76',NULL,NULL,'1',0,'1','2023-01-30 19:01:23','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-01-30 19:01:08','2023-01-30 19:01:23',NULL,'cus_NGZkZ5TJXvBjA9',0,0,0),(13,1,'Tom Hunter','jack-turner','jack-turner','tester2019001@gmail.com',NULL,'$2y$10$Xns3FaOCnDqXeAZXyfl30O/D.jWgjf4vvuPhwBysWdUsPbT0OR44q','users/iqb8khHxkcF2PTi0kAg5KFSQ5zVtw391pPDCqAu5.jpg',NULL,'1',1,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,'24, Block 8 Clifton, Karachi, Karachi City, Sindh 75600, Pakistan','24.832275121412696','67.03958373516798','0',NULL,NULL,'Bdhdhdh','11',0,NULL,0,NULL,'2023-01-31 13:06:55','2023-04-18 09:52:06',NULL,NULL,0,0,0),(14,1,'Johann van Niekerk','johann-van-niekerk','johann-van-niekerk','johannc.vanniekerk@gmail.com','+64-2108294407','$2y$10$oBn/TsvogXc/vXKE6tdieeKwb/.9trA7pUWgMq5.Q3t7ohC0PSWES',NULL,NULL,'1',0,'1','2023-02-02 12:41:39','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-01 23:34:51','2023-02-02 12:41:39',NULL,'cus_NHOc279A2skIkK',0,0,0),(15,1,'Tracy Felton','tracy-felton','tracy-felton','tracy.felts30@gmail.com',NULL,'$2y$10$2Flr5QguqlN5f9FrduLiKePs9m3B7QLFXkne/Z./TzSI38/BVyLCe',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-03 11:48:06',NULL,NULL,NULL,0,0,0),(16,1,'Adam','adam','adam','Adam99@yopmail.com','+1-2025551036','$2y$10$pQN1i.bVEyZCEMb5Nk14CesNVVXvrgrx9K3bf/4OaJ6llH7u1rJAy',NULL,NULL,'1',0,'1','2023-02-13 12:47:23','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-13 12:46:28','2023-02-13 12:47:23',NULL,'cus_NLis6udZkDH2tL',0,0,0),(17,2,'ali raza','tester-002','tester-002','tester2019002@gmail.com',NULL,'$2y$10$qjx/ZcifvtzYCRKVZRu5cuP2gUBVO6C8RI3FGnYAqMrGYXdWxmYL6',NULL,NULL,'1',1,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,'2005 Buchanan St, San Francisco, CA 94115, USA','123456','123456','0',NULL,NULL,'This is testing account','5',0,NULL,0,NULL,'2023-02-17 09:01:07','2023-02-20 13:33:04',NULL,NULL,0,0,0),(19,2,'ali raza','ali-raza','ali-raza','ali.raza.nasir3@yopmail.com',NULL,'$2y$10$uWjKN8rHuj2Cma8u1YPQvOI3gQGGBdDqPF1cdJxk17n/0c63EUbWi',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'123456','123456','0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-17 11:20:05',NULL,NULL,NULL,0,0,0),(20,2,'AzneemBilwani','azneembilwani','azneembilwani','admin@reckonmediallc.com',NULL,'$2y$10$FHcK6nOvfFnBstZeRp9zIuloWVtUb33xP2E5IAvntHxSsNK614/xG',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-17 11:26:07','2023-02-17 11:50:41',NULL,NULL,0,0,0),(21,2,'nullnull','nullnull','nullnull','null',NULL,'$2y$10$taaxFCSY4JaBXD7FyQja7OFEdncvodes.IQD5rsACXwo9h/cBx/3i',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-17 11:55:24','2023-02-17 12:40:11',NULL,NULL,0,0,0),(22,2,'jacks tester','jacks-tester','jacks-tester','jackstesters@gmail.com',NULL,'$2y$10$iDZYs8XtHCQAxdOOozIG1enFHWXvVd.e56hstrRmuB708yhErtqFe',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-17 12:05:30',NULL,NULL,NULL,0,0,0),(23,2,'RetroCube','retrocube','retrocube','developer@retrocube.com',NULL,'$2y$10$IeA3X68PYry.y5gol1OeRuYg/n/0XCmCLUmYQkhNu4mdIbyORr4FG',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-17 12:07:37',NULL,NULL,NULL,0,0,0),(24,1,'Charles','charles1596','charles1596','Charles@yomail.com','+1-8009865421','$2y$10$SLXW1eULQi2mgLRYw.hFY.95S3qpUlJI9PX1PSrJIhzS5n.4y60k.',NULL,NULL,'1',0,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-20 07:29:48','2023-02-20 07:29:48',NULL,'cus_NOGL8A4lRR0FcR',0,0,0),(25,1,'Kitten','kitten','kitten','Kitten@yopmail.com','+1-8003265987','$2y$10$RMu.6AnVI/Hx/NkSRak9MuWck1/hgUCzAR/DsCtfHWudl4c8Eu4wC',NULL,NULL,'1',0,'1','2023-02-20 07:39:59','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-20 07:33:59','2023-02-20 07:39:59',NULL,'cus_NOGPByLCDMrjT4',0,0,0),(26,2,'ڈویلپر دگیترنڈس','oylbr-dgytrns','oylbr-dgytrns','testbm88@gmail.com',NULL,'$2y$10$3HnXQXp9Ikj1KpYvBa4r/uATE6zQe2lJKFvgBkyIXda41FrdnjYCS',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-02-20 13:29:09','2023-04-17 11:10:57',NULL,NULL,0,0,0),(27,1,'Rosalie wilson','rosalie-wilson','rosalie-wilson','Wilson@jiayoudajia.com','+1-5304229261','$2y$10$tmxDLM1H4owYJdBHRmjus.AKSH74wInRkfRg8IoMs1cr1lIM5py4i',NULL,NULL,'1',0,'1','2023-03-01 11:17:32','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-03-01 11:17:09','2023-03-01 11:17:32',NULL,'cus_NRh2lOV5jVHMar',0,0,0),(28,1,'Marco','marco','marco','Marcmed89@gmail.com','+1-9702034381','$2y$10$h9xddCtekawVVRYUejgKtekdkiAGo1ZxFkqezORRehYcM3ccs2FMG',NULL,NULL,'1',0,'1','2023-03-03 20:13:49','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-03-03 19:55:26','2023-03-03 20:13:49',NULL,'cus_NSZru2NLkcIed3',0,0,0),(29,1,'Renee Harvey','renee-harvey','renee-harvey','Rharvey.inc@gmail.com','+971-552551260','$2y$10$DHTYjbIRlTGWgrtU/T8bXumNdsH2MRMyYm6nfrjndAY0mUZpD.t/C','users/5naiIn3QZGxUjCYJhusWVKmDqBiiIUFWpOVFVEc3.jpg',NULL,'1',0,'1','2023-03-09 19:57:10','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-03-09 07:19:36','2023-03-09 19:57:10',NULL,'cus_NUd1782z9G9a3J',0,0,0),(30,1,'Dimpie Dhani','dimpie-dhani','dimpie-dhani','dimpiedhani@gmail.com',NULL,'$2y$10$v.I8F5FRp4.kMywdp/swQeDjvZKtj.yc26XX/LCpLCdiBaSJ1LgTe',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-03-11 22:34:54',NULL,NULL,'cus_NVcEJzcybqf08P',0,0,0),(31,1,'Evangeline anamani','evangeline-anamani','evangeline-anamani','lynanamani@hotmail.com','+971-507229326','$2y$10$rpUggadFqSUSIXv/78R82Oxhs7GfVQu7BRtGKqbD/Z2GQ64D7x48G',NULL,NULL,'1',0,'1','2023-03-13 20:14:02','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-03-13 20:13:25','2023-03-13 20:14:02',NULL,'cus_NWKPNFQJAXQfuI',0,0,0),(32,1,'Kim Solomon','kim-solomon','kim-solomon','terakumea20@gmail.com','+971-567619637','$2y$10$6nDY20L0hzsGZORg1I0uU.5yKry25o3h4dqScG74qT7Y/sRdXfpmi',NULL,NULL,'1',0,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-03-16 06:34:01','2023-03-16 06:34:01',NULL,'cus_NXErGrHljfLF16',0,0,0),(33,1,'Rachel Cuales','rachel-cuales','rachel-cuales','info@reliableremoteassistants.com','+63-9179240127','$2y$10$whzEdB/30p4rVOPDyn9eYOR5i88hq9wH6jFgI225z79WCr0x/vY7u','users/i9mz5H3hC4jVCMYxeiic1KdG6BRxx0fAeWf5VyQQ.jpg',NULL,'1',0,'1','2023-03-23 16:02:27','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-03-23 11:00:13','2023-03-27 10:46:49',NULL,'cus_NZvj1cf2JzvoPR',0,0,0),(34,1,'Grant Goes','grant-goes','grant-goes','grant@findfitpeople.com','+971-562617359','$2y$10$m2tihSKqvnJZfVgwOmIdiOK8sfpzPqzkOV1Vt7xto6X3uWcms65gG','users/nxi6OxTJLoFoQvi9y4XAaitmQgNEjph1yr2urEvl.jpg',NULL,'1',0,'1','2023-03-25 04:09:17','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-03-24 19:33:00','2023-03-25 04:09:17',NULL,'cus_NaRES31Go0uBCb',0,0,0),(35,1,'Therry Henry','therry-henry','therry-henry','therryhenry5959@gmail.com',NULL,'$2y$10$v9wQuCQx9A/3ZZn/RbKgs.xoPoRtOvwYdWHKO0Cmt3G1AWi4V3fLK','users/CeIGZ0aBlKrskc2yosHd6nTu3qDfpvY8GiU7i735.jpg',NULL,'1',1,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,'R2JQ+WQC, Khaliq-uz-Zaman Rd, Block 8 Clifton, Karachi, Karachi City, Sindh 75600, Pakistan','24.832230435346126','67.03942833468318','0',NULL,NULL,'Test','20',0,NULL,0,NULL,'2023-04-13 11:03:24','2023-04-17 11:18:14',NULL,'cus_NhnXguEJ1a25gh',0,0,0),(36,1,'Henry','henry','henry','Henry@yopmail.com','+1-8004444853','$2y$10$4UxLlPwWCRBz1WJfymzUnuk9xfZy3K9iNpV3IrxR/6XxXYcieoEw6',NULL,NULL,'1',0,'1','2023-04-13 11:14:53','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-04-13 11:14:17','2023-04-13 11:14:53',NULL,'cus_Nhnhrw29TNodld',0,0,0),(37,1,'Ulises Romero','ulises-romero','ulises-romero','RDrywall.Renovationsllc@gmail.com','+1-9124367116','$2y$10$69FXbuOcmYg5sFK83qGdf.suoyKrqRMGOihGZwJ6DCB6PbxRP4mVO',NULL,NULL,'1',0,'1','2023-04-13 16:12:07','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-04-13 13:54:52','2023-04-13 16:12:07',NULL,'cus_NhqILi1Q4Hysk7',0,0,0),(38,1,'Sarah Gage','sarah-gage','sarah-gage','Admin@gigmehq.com','+971-544822218','$2y$10$1AEd1hdHB8QalVrXOzc4sOlCqqpnzUDSQJsZx1x0OEH3eGvDj..NW',NULL,NULL,'1',0,'0',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-04-14 11:45:46','2023-04-14 11:45:46',NULL,'cus_NiBR3CcGQUUeNW',0,0,0),(39,1,'LauraDiamond','lauradiamond','lauradiamond','7tdzsqt4h2@privaterelay.appleid.com',NULL,'$2y$10$EDxH6MDNWbrmqcjku0U/8.HAjO3ed2NzoSjurX8PB27.G7sBEqVke',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-04-14 13:05:03',NULL,NULL,'cus_NiCiz4Acy0c4FM',0,0,0),(40,1,'Touqeer Ahmed','touqeer-ahmed','touqeer-ahmed','touqeerahmed1633@gmail.com',NULL,'$2y$10$WEOuDsrWDv8mIXvtBA.UKuh5oJxBe8I1sT2orCJuO2Fl0.DOWC/vO',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-04-17 10:40:41',NULL,NULL,'cus_NjI4HDuY9BKQh1',0,0,0),(41,1,'Touqeer Ahmed','touqeer-ahmed1668','touqeer-ahmed1668','16cs33@gmail.com',NULL,'$2y$10$Ow9rldGv1l/Vz.0f53tyg.IkkmGM5IJ/vefeAbmu8ps4dlbisQRci',NULL,NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-04-17 11:11:51',NULL,NULL,'cus_NjIZ3UXrRse5L6',0,0,0),(42,1,'Rizwan','rizwan','rizwan','rizwan@abtach.ae',NULL,'$2y$10$a34q773rADXydsVHq513Eu9b68YRY/wxJoIYloRfAaa2RB3fc19Fi','users/IoqdRucSwZRiVVMrGAZtPwKPIsGVgtmT5k0cGwNt.jpg',NULL,'1',0,'1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,0,NULL,0,NULL,'2023-04-18 08:03:45','2023-04-18 08:50:39',NULL,'cus_NjclLglzxz7YWL',0,0,0); /*!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 2023-04-18 9:52:59