File: //storage02/Bkup/bene_benevolent-2022-03-24.sql
-- MariaDB dump 10.19 Distrib 10.4.24-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: bene_benevolent
-- ------------------------------------------------------
-- Server version 10.4.24-MariaDB-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `admins`
--
DROP TABLE IF EXISTS `admins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admins` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `admins_email_unique` (`email`),
UNIQUE KEY `admins_mobile_unique` (`mobile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admins`
--
LOCK TABLES `admins` WRITE;
/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `failed_jobs`
--
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!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 `links`
--
DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokens` double(30,4) NOT NULL DEFAULT 0.0000,
`maxUser` int(11) NOT NULL DEFAULT 0,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `links`
--
LOCK TABLES `links` WRITE;
/*!40000 ALTER TABLE `links` DISABLE KEYS */;
INSERT INTO `links` VALUES (1,1,'https://example.com',200.0000,0,NULL,'2022-03-15 08:43:49','2022-03-15 08:43:49'),(2,1,'https://example.com',200.0000,0,NULL,'2022-03-16 08:37:35','2022-03-16 08:37:35'),(3,1,'https://example.com',0.0000,0,NULL,'2022-03-16 09:24:02','2022-03-16 09:24:02'),(4,1,'https://example.com',0.0000,0,NULL,'2022-03-16 09:46:54','2022-03-16 09:46:54'),(5,1,'https://example.com',200.0000,0,NULL,'2022-03-16 20:56:24','2022-03-16 20:56:24'),(6,1,'https://example.com',3.0000,10,NULL,'2022-03-16 21:08:17','2022-03-16 21:08:17'),(7,1,'https://example.com',3.0000,10,NULL,'2022-03-16 21:08:19','2022-03-16 21:08:19'),(8,1,'https://example.com',3.0000,10,NULL,'2022-03-16 21:08:19','2022-03-16 21:08:19'),(9,1,'https://example.com',3.0000,10,NULL,'2022-03-16 21:08:20','2022-03-16 21:08:20'),(10,1,'https://example.com',3.0000,10,NULL,'2022-03-16 21:08:23','2022-03-16 21:08:23'),(11,19,'https://jignesh.com',11.0000,20,NULL,'2022-03-16 21:08:24','2022-03-20 04:58:48'),(12,19,'https://sahil.com',3.0000,10,NULL,'2022-03-16 21:08:24','2022-03-20 05:13:43'),(13,19,'https://example.com',0.0000,0,NULL,'2022-03-17 20:29:33','2022-03-17 20:29:33'),(16,1,'https://example.com',84.0000,0,NULL,'2022-03-17 21:28:28','2022-03-17 21:28:28');
/*!40000 ALTER TABLE `links` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 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 (81,'2014_10_12_000000_create_users_table',1),(82,'2014_10_12_100000_create_password_resets_table',1),(83,'2019_08_19_000000_create_failed_jobs_table',1),(84,'2019_12_14_000001_create_personal_access_tokens_table',1),(85,'2022_03_08_163112_create_admins_table',1),(86,'2022_03_08_163335_create_user_referrals_table',1),(87,'2022_03_08_171315_create_wallet_transactions_table',1),(88,'2022_03_08_171749_create_order_transactions_table',1),(89,'2022_03_09_160041_create_links_table',1),(90,'2022_03_09_162452_create_user_links_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `order_transactions`
--
DROP TABLE IF EXISTS `order_transactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_transactions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`amount` double(30,4) NOT NULL DEFAULT 0.0000,
`tokens` double(30,4) NOT NULL DEFAULT 0.0000,
`status` enum('paid','pending','failed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
`payment_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`order_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pay_via` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'razorpay',
`type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'plan',
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `order_transactions`
--
LOCK TABLES `order_transactions` WRITE;
/*!40000 ALTER TABLE `order_transactions` DISABLE KEYS */;
INSERT INTO `order_transactions` VALUES (1,19,1.0000,1.0000,'paid','pay_J6cR4K4RKHJTju','order_J9FKjS12W89mIk','razorpay','token_purchase',NULL,'2022-03-20 01:05:06','2022-03-20 01:06:20'),(2,19,1000.0000,0.0000,'paid','pay_J6cR4K4RKHJTju','order_J9FQOQRsYmt8S2','razorpay','plan_purchase','{\"name\":\"Plan A\",\"price\":\"1000\",\"time_limit\":\"30\",\"max_earning\":\"10000\",\"max_daily_task\":10,\"max_super_task\":0,\"id\":\"plan_a\"}','2022-03-20 01:10:27','2022-03-20 01:56:44'),(3,25,200.0000,200.0000,'pending',NULL,'order_JA2fL5l0FbldyB','razorpay','token_purchase',NULL,'2022-03-22 01:20:35','2022-03-22 01:20:36'),(4,25,1200.0000,1200.0000,'pending',NULL,'order_JA2frdWYfSliNS','razorpay','token_purchase',NULL,'2022-03-22 01:21:05','2022-03-22 01:21:06');
/*!40000 ALTER TABLE `order_transactions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_resets`
--
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_resets`
--
LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` VALUES ('jigneshsanghani6@gmail.com','$2y$10$Dpmhe5fIPM4FeoAv85yfTumBGoTUPpBVOvHvkYKs.B66CYilBGFqi','2022-03-17 05:53:47'),('sahilumretiya08@gmail.com','$2y$10$ttUO7w0vDzXbRbCaUvlnUeWjKdVWrLC4ZlpE5UQK.TdlTFFSafJ2W','2022-03-18 00:57:21');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `personal_access_tokens`
--
DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint(20) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_used_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `personal_access_tokens`
--
LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
INSERT INTO `personal_access_tokens` VALUES (1,'App\\Models\\User',1,'apiToken','833e53d5aec85cdc47122cb46362968503e3839c04da478fa3a9946aed3158df','[\"*\"]',NULL,'2022-03-14 12:10:16','2022-03-14 12:10:16'),(2,'App\\Models\\User',2,'apiToken','46ea87fbb7f52219f8bed77d3a3917a8af918615e3501e36149ccb7614d5325a','[\"*\"]','2022-03-14 12:13:01','2022-03-14 12:11:03','2022-03-14 12:13:01'),(3,'App\\Models\\User',7,'apiToken','7e0ae7af422272797f81f30a75123527497acdeb5b4c5bbe252b7e4d99f9499f','[\"*\"]',NULL,'2022-03-14 18:04:24','2022-03-14 18:04:24'),(4,'App\\Models\\User',8,'apiToken','248d0d7df65e3cc37360c7e50fc2ab177493832e422268fd5a29507c7cfd2938','[\"*\"]',NULL,'2022-03-14 18:05:58','2022-03-14 18:05:58'),(5,'App\\Models\\User',9,'apiToken','17f559064b3f311aea582e67bc848285ab3a2745d2faa0f9b7bed759d1c28a2f','[\"*\"]','2022-03-15 01:53:11','2022-03-14 18:11:25','2022-03-15 01:53:11'),(6,'App\\Models\\User',1,'apiToken','ca38f7b1ef1c59b5e8df5760d9dc42023ce96c3f4c128688a8933a546c8e493a','[\"*\"]',NULL,'2022-03-14 18:18:16','2022-03-14 18:18:16'),(7,'App\\Models\\User',9,'apiToken','8547a9078e03cc694f2ffb463cd88fa3767f7b06530d77d15b4b799b1d734194','[\"*\"]',NULL,'2022-03-15 01:52:08','2022-03-15 01:52:08'),(8,'App\\Models\\User',1,'apiToken','1e09fac51348cc8c7aa738217ef7eb6968dd9b0a96ea8e9a9c609a042e249d0d','[\"*\"]','2022-03-15 08:43:49','2022-03-15 08:43:26','2022-03-15 08:43:49'),(9,'App\\Models\\User',1,'apiToken','3356f1a21bd7d8b66912292fc167c08c89ef1d1e46b15ad37b80ab321ee2d63b','[\"*\"]','2022-03-17 20:58:52','2022-03-16 08:36:51','2022-03-17 20:58:52'),(10,'App\\Models\\User',1,'apiToken','726dbb89320a1a5976856dff331afa3ee696417ea595fba142a48d48e36fa417','[\"*\"]',NULL,'2022-03-16 09:18:37','2022-03-16 09:18:37'),(11,'App\\Models\\User',14,'apiToken','ca05ef140d4f357f38fbd0de8f3cb4cbff93b983ec9d54a9cb8feccfb9b84515','[\"*\"]',NULL,'2022-03-16 09:28:51','2022-03-16 09:28:51'),(12,'App\\Models\\User',1,'apiToken','d4e92e983402d6932c747a67c7ce0ebb1f8966c7e9da4dbd478e4f3170b8fdf1','[\"*\"]',NULL,'2022-03-16 09:30:48','2022-03-16 09:30:48'),(13,'App\\Models\\User',1,'apiToken','a3c8f0f6fe9dd1de870e361e8ce0601b9f1b35d3729042b75a19cfa9ea55e098','[\"*\"]',NULL,'2022-03-16 09:43:46','2022-03-16 09:43:46'),(14,'App\\Models\\User',1,'apiToken','f9af16d9ffb81174e83fbc4b554eeb3f68eb2694f21789c5bd07d82ee98de85d','[\"*\"]',NULL,'2022-03-16 09:43:57','2022-03-16 09:43:57'),(15,'App\\Models\\User',1,'apiToken','dfd3e049708b343b5d0851b7a0aaaa66447a8233620f6284bd3c3dd9f8af8d4b','[\"*\"]',NULL,'2022-03-16 09:44:57','2022-03-16 09:44:57'),(16,'App\\Models\\User',1,'apiToken','d7be100f69a1eea14ef1cac986db01a801a4d274a48ed9c178c96428e8ba8157','[\"*\"]',NULL,'2022-03-16 09:46:40','2022-03-16 09:46:40'),(17,'App\\Models\\User',1,'apiToken','615aeee90fbbb1eefda60631c49355aab9407c194d13241786253b491d0965d9','[\"*\"]',NULL,'2022-03-16 09:46:54','2022-03-16 09:46:54'),(18,'App\\Models\\User',15,'apiToken','92c0aec44b07c7a092fe79196c5c417a45e58aa035174ff5fa6b50e5061bb570','[\"*\"]',NULL,'2022-03-16 09:47:29','2022-03-16 09:47:29'),(19,'App\\Models\\User',1,'apiToken','061d7cc7a9b5e5dd2fc688715f62f0473efb2c12b81bd2333f46a1c78fc6f3f9','[\"*\"]',NULL,'2022-03-16 09:52:50','2022-03-16 09:52:50'),(20,'App\\Models\\User',1,'apiToken','163080eec87bbee695274f517393615b49964aa8876691009fb9175e8e4e6819','[\"*\"]',NULL,'2022-03-16 09:55:08','2022-03-16 09:55:08'),(21,'App\\Models\\User',16,'apiToken','e38ca3d3b12e35d1d317c335daa47a3569efadc26d0e01f10da77e8be7787261','[\"*\"]',NULL,'2022-03-16 10:16:26','2022-03-16 10:16:26'),(22,'App\\Models\\User',13,'apiToken','f74aebe8e5a575e2facf00fc03179d35464ef8380b19552015f08fbf40bcfa13','[\"*\"]','2022-03-16 20:50:59','2022-03-16 20:49:16','2022-03-16 20:50:59'),(23,'App\\Models\\User',17,'apiToken','619da80c1cb709c37241b1467f450a2c97e21865912e4f9c6c7355dbeb225d9e','[\"*\"]',NULL,'2022-03-16 20:49:32','2022-03-16 20:49:32'),(24,'App\\Models\\User',1,'apiToken','24d3b30e09e0af562b1e4220f2fb620d94addf14613e5ce289db40941146bd18','[\"*\"]','2022-03-16 21:11:53','2022-03-16 20:56:14','2022-03-16 21:11:53'),(26,'App\\Models\\User',1,'apiToken','989ec85463c880bbfb6d473e729bdc234c8dcc3e214c0d09e5c7d825c04806e5','[\"*\"]',NULL,'2022-03-17 20:28:27','2022-03-17 20:28:27'),(27,'App\\Models\\User',1,'apiToken','ab2726f38daa2e3ad81fd58aaccc347e608fc9dd68b86499f83e4252f3d439f1','[\"*\"]',NULL,'2022-03-17 20:48:14','2022-03-17 20:48:14'),(28,'App\\Models\\User',1,'apiToken','8d224cbf78c0c56848f4e55cab55a770bec49ba20bd35f1308556dc4518ea101','[\"*\"]',NULL,'2022-03-17 20:51:40','2022-03-17 20:51:40'),(29,'App\\Models\\User',1,'apiToken','bb4a604e2eef243766998d394506ad57b038c6357ccfc6d779fa5cbcc579046e','[\"*\"]',NULL,'2022-03-17 20:53:13','2022-03-17 20:53:13'),(30,'App\\Models\\User',1,'apiToken','0f702f92f6e824e830d97a75cbde6e38437a2cba7e95bcb2e3ceda3d3ad6a4d3','[\"*\"]',NULL,'2022-03-17 20:53:58','2022-03-17 20:53:58'),(31,'App\\Models\\User',1,'apiToken','71b953175a9e48764eaed50cf9551efc1f2615bdf16d94a630bd62a01ce09e85','[\"*\"]','2022-03-17 21:28:28','2022-03-17 20:56:37','2022-03-17 21:28:28'),(32,'App\\Models\\User',19,'apiToken','701b01bcf831551789cbe162fa10987b82e3a52b74b65fb9ea691715bde792fb','[\"*\"]',NULL,'2022-03-18 00:33:51','2022-03-18 00:33:51'),(33,'App\\Models\\User',20,'apiToken','68fa875b28046a5ee07885712edfa36edd77147372e8cb56509cbf132e0848bc','[\"*\"]',NULL,'2022-03-18 00:36:37','2022-03-18 00:36:37'),(34,'App\\Models\\User',19,'apiToken','011bc6044bd355227effc162cecf32766b78aeb216ea840f4ec17a401923d506','[\"*\"]',NULL,'2022-03-18 00:39:28','2022-03-18 00:39:28'),(35,'App\\Models\\User',19,'apiToken','28d66aacd275ba5a5f2e8f76b1c207943e61b30231a1eae2a904954d57a2f281','[\"*\"]',NULL,'2022-03-18 00:43:36','2022-03-18 00:43:36'),(36,'App\\Models\\User',19,'apiToken','e4e4374a9284e3c4e265af94a3daac3ffe709f17a272abbde6fcac13dfd24a6c','[\"*\"]',NULL,'2022-03-18 00:47:39','2022-03-18 00:47:39'),(37,'App\\Models\\User',19,'apiToken','155324fbbe04b811a83d47c4828eb3d4db390645852e97af0f5c744e5110b08e','[\"*\"]',NULL,'2022-03-18 01:55:47','2022-03-18 01:55:47'),(38,'App\\Models\\User',19,'apiToken','91be7c02a484ab73c84de26ff5311643e2e727c1bac0945903db9052b5d9524c','[\"*\"]',NULL,'2022-03-18 01:56:40','2022-03-18 01:56:40'),(39,'App\\Models\\User',19,'apiToken','0b9b8d391904f6d49a097d523e9eba3dfc9e6cdfcc36f2f43ef1bdbae1f94618','[\"*\"]','2022-03-18 01:59:14','2022-03-18 01:57:56','2022-03-18 01:59:14'),(40,'App\\Models\\User',19,'apiToken','6b221c59b96a3d8006ba1804a7ffca43b256da26aa4903851dba2c1e66779ce3','[\"*\"]',NULL,'2022-03-18 02:05:40','2022-03-18 02:05:40'),(41,'App\\Models\\User',19,'apiToken','951a118bb864c1b808569e3fb46d45b02ec0acb4786b2c8d5252cf63ed02d0ac','[\"*\"]',NULL,'2022-03-18 02:13:13','2022-03-18 02:13:13'),(42,'App\\Models\\User',19,'apiToken','445eaf26e46c32cde4b469969c012f5e101d836626648ae34a33a50916a82f74','[\"*\"]',NULL,'2022-03-18 02:19:12','2022-03-18 02:19:12'),(43,'App\\Models\\User',19,'apiToken','5c8348590f57590fed7c5284834de8a437f02d734f877f27e2a4c6bca2e1630d','[\"*\"]',NULL,'2022-03-19 09:55:32','2022-03-19 09:55:32'),(44,'App\\Models\\User',19,'apiToken','c64bc63a0a18311343570cb7d640fc735e18fbf71b41c77162f81ab634007769','[\"*\"]','2022-03-20 03:02:58','2022-03-19 22:45:10','2022-03-20 03:02:58'),(45,'App\\Models\\User',21,'apiToken','b80ccda81f68ecf1a87ff6e926700bd0d8a86d59d2352699378591838cba3a5d','[\"*\"]',NULL,'2022-03-19 22:53:02','2022-03-19 22:53:02'),(46,'App\\Models\\User',22,'apiToken','a83426a450de568e04e1bbb3649e5f7f31862a672f0a4d4b0d6e48feda82b42f','[\"*\"]',NULL,'2022-03-19 22:55:23','2022-03-19 22:55:23'),(47,'App\\Models\\User',23,'apiToken','442f78a384ec8663cd548f2e9ccbeff11728dc6265508e4b666a91bd5e4353d1','[\"*\"]','2022-03-19 23:30:12','2022-03-19 23:26:37','2022-03-19 23:30:12'),(50,'App\\Models\\User',19,'apiToken','1df3e5e7e04a99fb4e23294f6b2b3408b2e1aee6bf95b2eb652b807e59a428d5','[\"*\"]','2022-03-20 00:07:31','2022-03-19 23:50:47','2022-03-20 00:07:31'),(51,'App\\Models\\User',19,'apiToken','101a7036090e04697a8747077a8fb99b88b3255cb33b801202d562714377f7d9','[\"*\"]','2022-03-20 05:05:12','2022-03-19 23:53:22','2022-03-20 05:05:12'),(52,'App\\Models\\User',19,'apiToken','a0207ff68ccd62f6636cab73f38eab606c1ee1f917ef57986fa30a220f0ed8b3','[\"*\"]','2022-03-20 00:55:26','2022-03-20 00:34:32','2022-03-20 00:55:26'),(53,'App\\Models\\User',19,'apiToken','3985abbebcc6c97c85e682562827d31716e7b9d21555089bc8de0bffeedd6ab0','[\"*\"]',NULL,'2022-03-20 01:01:07','2022-03-20 01:01:07'),(56,'App\\Models\\User',13,'apiToken','dad9a7ec34720acde1908fe6365266e2ba7474e8d80ecc2d477555893cd96def','[\"*\"]','2022-03-22 01:24:19','2022-03-20 03:10:12','2022-03-22 01:24:19'),(58,'App\\Models\\User',19,'apiToken','7126059f1848b29f3017154cb42226de621516cf477a6c6066c0dd9d9337304f','[\"*\"]','2022-03-20 05:13:57','2022-03-20 04:41:27','2022-03-20 05:13:57'),(59,'App\\Models\\User',19,'apiToken','c259178dd1f23acf98da35b2066ec4a4bdb65016d14818f3bbbfe0cb8dfe617a','[\"*\"]','2022-03-20 07:47:19','2022-03-20 07:37:12','2022-03-20 07:47:19'),(60,'App\\Models\\User',1,'apiToken','b5e95dc712e8c7f80d642439334c1eb303169f2420cb4653b7fefb253a87a5fc','[\"*\"]','2022-03-22 02:22:00','2022-03-21 12:50:34','2022-03-22 02:22:00'),(61,'App\\Models\\User',13,'apiToken','183973179f22679e29c93fd429724dcc8e7ccbae8c0ebab8dbffaffb33ba89dc','[\"*\"]',NULL,'2022-03-21 23:17:28','2022-03-21 23:17:28'),(62,'App\\Models\\User',25,'apiToken','0384d9578460ef4057c6bd4889911f3ae94c65df8de4ef7f558cc5feea115d7d','[\"*\"]',NULL,'2022-03-21 23:30:30','2022-03-21 23:30:30'),(63,'App\\Models\\User',25,'apiToken','9b117cca2d4bbd0d3806012ee66e5739a0bb762904735325c9de38f61f4aad58','[\"*\"]',NULL,'2022-03-21 23:32:43','2022-03-21 23:32:43'),(64,'App\\Models\\User',1,'apiToken','adccef4eba2c12e67b09926536e27dd35f2102aaf0097b0bb27499ca1e3dc467','[\"*\"]',NULL,'2022-03-21 23:44:17','2022-03-21 23:44:17'),(65,'App\\Models\\User',1,'apiToken','99861b840b93645654c4c5a57d97b9c90b4fbc5647ac4f3faae9518bfb89c8b4','[\"*\"]',NULL,'2022-03-21 23:45:16','2022-03-21 23:45:16'),(66,'App\\Models\\User',26,'apiToken','078a4e6199a79587522a5176e20b62606679559c9f0e1e9df26e2820c2352ea9','[\"*\"]',NULL,'2022-03-21 23:56:26','2022-03-21 23:56:26'),(67,'App\\Models\\User',1,'apiToken','17da4b22d1e2d39843371b18e960dd01f1076e48d59c99bb754fac209616bab5','[\"*\"]',NULL,'2022-03-21 23:57:19','2022-03-21 23:57:19'),(68,'App\\Models\\User',1,'apiToken','2836f3504ddf503125c1d0a61003b6a59fc9651fa4caaee89000d335ec1cb702','[\"*\"]',NULL,'2022-03-21 23:58:51','2022-03-21 23:58:51'),(69,'App\\Models\\User',1,'apiToken','934d45960c0b571c27211b1435b1b5bee9cf8097505cd4b98b1655107dfdef82','[\"*\"]',NULL,'2022-03-22 00:16:46','2022-03-22 00:16:46'),(70,'App\\Models\\User',25,'apiToken','23a916c0019015b7e722c3bee9bee72c0658cb39fe7fd3c1afd921d9be50cc63','[\"*\"]','2022-03-22 00:54:58','2022-03-22 00:23:56','2022-03-22 00:54:58'),(71,'App\\Models\\User',1,'apiToken','edb7c0af3b3242500cc60c7f0d129f01ab7a1cb9e9eea81ced3b76dccc08760b','[\"*\"]','2022-03-22 00:41:49','2022-03-22 00:41:23','2022-03-22 00:41:49'),(72,'App\\Models\\User',27,'apiToken','11a49bd1ad4caf6ffd0ac24f019b02a1dd54383c082f6bc0f511c4950e026a87','[\"*\"]','2022-03-22 00:44:26','2022-03-22 00:41:54','2022-03-22 00:44:26'),(73,'App\\Models\\User',27,'apiToken','c38a95dd21ee173ec635ea8663b0c5866ecb39d987ea3b3f5706278ae61a77d7','[\"*\"]','2022-03-22 00:47:08','2022-03-22 00:46:17','2022-03-22 00:47:08'),(74,'App\\Models\\User',25,'apiToken','85df43a8bbe798155189fdef71aee4f99d8a598e06ea3770f7ff6409a7b96507','[\"*\"]','2022-03-22 00:58:10','2022-03-22 00:57:59','2022-03-22 00:58:10'),(75,'App\\Models\\User',25,'apiToken','d7a3ad1d2d73c7898bfe77ffd7549c5e9802de10070498efc52c29297a3923f9','[\"*\"]','2022-03-22 01:16:41','2022-03-22 01:04:13','2022-03-22 01:16:41'),(76,'App\\Models\\User',1,'apiToken','375c01d08ffedc82ba5017eb128482b0464ed73c2239a02e771316cedcca22ef','[\"*\"]',NULL,'2022-03-22 01:04:24','2022-03-22 01:04:24'),(77,'App\\Models\\User',1,'apiToken','1ab839d5b250b6dd7b8e919feabb8f8421a0db4c88c21fed6af8ac360684793d','[\"*\"]',NULL,'2022-03-22 01:04:54','2022-03-22 01:04:54'),(78,'App\\Models\\User',25,'apiToken','9d98167f41f869acb2a0bb6f7d1814eae1796deae36ed5672c1d9db7e9d630ca','[\"*\"]','2022-03-22 01:24:37','2022-03-22 01:04:58','2022-03-22 01:24:37'),(79,'App\\Models\\User',27,'apiToken','1122d44e8f7c3e28f4f6d870f643a783d2fd19c18a00da37e394fc8e4cc7afb9','[\"*\"]','2022-03-22 01:10:34','2022-03-22 01:08:11','2022-03-22 01:10:34'),(80,'App\\Models\\User',25,'apiToken','a84f82ee9a1b3e90cbba70f5083aec61730ebf385cce4ae827b0ca65b5dca907','[\"*\"]','2022-03-22 01:22:22','2022-03-22 01:17:41','2022-03-22 01:22:22'),(81,'App\\Models\\User',25,'apiToken','6f25991a54df03819e9cfbb21bcde6b9e692b01ebedaa753792b8ac8cca713d8','[\"*\"]','2022-03-22 01:26:10','2022-03-22 01:19:15','2022-03-22 01:26:10'),(82,'App\\Models\\User',25,'apiToken','9f14e0fa1f626f3f6c6db574d0741a9a1e5fdd5ae99cf6591a7840543e31fdc8','[\"*\"]','2022-03-22 01:27:00','2022-03-22 01:26:01','2022-03-22 01:27:00'),(83,'App\\Models\\User',25,'apiToken','f97a1fd7ea36c2ebde55fe5919a9a1f7ee63ce29178c6f9363c66bbe681f2d85','[\"*\"]','2022-03-22 01:27:52','2022-03-22 01:27:36','2022-03-22 01:27:52'),(84,'App\\Models\\User',1,'apiToken','76f27b945e8d29dab4a3eb4d7868b321a29f4e782ec7fa4b4d397b78c160a6c9','[\"*\"]',NULL,'2022-03-22 01:46:36','2022-03-22 01:46:36'),(85,'App\\Models\\User',1,'apiToken','51e95817b46980585e6391ba5cfc52a7bdf5c62a47ce9777bc7a5ef68532d799','[\"*\"]','2022-03-22 02:48:23','2022-03-22 01:49:49','2022-03-22 02:48:23'),(86,'App\\Models\\User',1,'apiToken','888f1ae1f8b1ad53e818aee7a28b47051362a02397e94156175e77a5e7bc1645','[\"*\"]','2022-03-22 04:39:41','2022-03-22 02:50:34','2022-03-22 04:39:41'),(87,'App\\Models\\User',1,'apiToken','90f4c38aead1a0a75925fe224807943190ee76816dae763e62fecd9699cc231c','[\"*\"]','2022-03-22 05:16:45','2022-03-22 05:05:57','2022-03-22 05:16:45'),(88,'App\\Models\\User',1,'apiToken','b84a1d78d523af1d869845299af3b009a5881f0c9f514d74920ce895098f3ffc','[\"*\"]','2022-03-22 05:20:34','2022-03-22 05:20:04','2022-03-22 05:20:34');
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`mobile` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`Ref_By` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`D.O.J.` varchar(255) NOT NULL,
`payment_status` varchar(255) NOT NULL DEFAULT 'Pending',
`payment_id` varchar(255) DEFAULT NULL,
`pay_date` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'jaydeep','7069440745','jp@gmail.com','7069558545','1','28-02-2022','Success','','28-02-2022 12:09:43'),(2,'Umang Kathiriya','7433005640','umangkathiriya743@gmail.comm','7433005640','142536','28-02-2022','Pending',NULL,NULL),(3,'umang','7433005640','umangkathiriya743@gmail.com','7433005640','123456','28-02-2022','Pending',NULL,NULL),(4,'jp','7069440745','jp83@gmail.com','7058458545','123123123','28-02-2022','Success','pay_J1KZc8EKsGRpId','28-02-2022 12:00:57'),(5,'Umang','7433005640','umangkathiriya7443@gmail.com','7433005640','123456','28-02-2022','Success','pay_J1MH66cv9pd4nn','28-02-2022 01:41:48'),(6,'Arun','7878308282','iamarunvekariya@gmail.com','7878308282','Arun@1991','28-02-2022','Pending',NULL,NULL),(7,'test','7405369698','test@gmail.com','7878308282','Bravo36@','14-03-2022','Pending',NULL,NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_links`
--
DROP TABLE IF EXISTS `user_links`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_links` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`link_id` bigint(20) unsigned NOT NULL,
`tokens` double(30,4) NOT NULL DEFAULT 0.0000,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_links`
--
LOCK TABLES `user_links` WRITE;
/*!40000 ALTER TABLE `user_links` DISABLE KEYS */;
INSERT INTO `user_links` VALUES (1,19,17,11.0000,'2022-03-20 01:09:03','2022-03-20 01:09:03');
/*!40000 ALTER TABLE `user_links` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_referrals`
--
DROP TABLE IF EXISTS `user_referrals`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_referrals` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`referred_id` bigint(20) unsigned NOT NULL,
`tokens` double(30,4) NOT NULL DEFAULT 0.0000,
`level` int(11) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_referrals`
--
LOCK TABLES `user_referrals` WRITE;
/*!40000 ALTER TABLE `user_referrals` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_referrals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`referral_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`refer_by` bigint(20) NOT NULL DEFAULT 0,
`wallet` double NOT NULL DEFAULT 0,
`level` int(11) NOT NULL DEFAULT 0,
`max_link` int(11) NOT NULL DEFAULT 10,
`max_daily_task` int(11) NOT NULL DEFAULT 10,
`max_super_task` int(11) NOT NULL DEFAULT 0,
`is_active` tinyint(1) NOT NULL DEFAULT 0,
`email_verified_at` timestamp NULL DEFAULT NULL,
`mobile_verified_at` timestamp NULL DEFAULT NULL,
`join_date` timestamp NULL DEFAULT NULL,
`otp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`expiry_date` timestamp NULL DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`),
UNIQUE KEY `users_mobile_unique` (`mobile`),
UNIQUE KEY `users_referral_id_unique` (`referral_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 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,'Admin','admin@nsv4hihti4.com','$2y$10$y04F7yZJcuuOuni29ipaTeeBKU1n02pRbwhYBZTj3RUPtxzLS9.ya','98888888889','cCwP1LJB77',0,0,0,10,10,0,0,'2022-03-14 23:31:54','2022-03-14 23:32:00',NULL,NULL,NULL,NULL,'2022-03-14 12:10:16','2022-03-14 12:10:16',NULL),(13,'jignesh sanghani','jigneshsanghani6@gmail.com','$2y$10$RnVjaverRBdt0NvTnqQR..ZDJ30To68/T53MM2OeOeohhLQ8B2axO','7405369698','Bpr6Phc6hY',0,1500,0,10,10,0,1,NULL,'2022-03-15 10:54:34',NULL,NULL,'2022-03-15 17:38:30',NULL,'2022-03-15 10:53:44','2022-03-19 00:38:50',NULL),(14,'Test','jinesh@arrangi.com','$2y$10$XYW9eZGgC3.zbEo0Z.m3vuD2exaZfTFDSXXFILYPQAmEu7y6zrRvm','74053696982','Ua2WuVKykx',13,0,0,10,10,0,0,NULL,NULL,NULL,'732542',NULL,NULL,'2022-03-16 09:28:50','2022-03-16 09:28:50',NULL),(15,'Test','jinesh@arrangi.comm','$2y$10$IQ9CcVNYsJIrw9v9LGGQ6.NR9Ax9funb38F4j/JZbS7BGQ1CuD31y','740536969823','6n5lxJHEeJ',13,0,0,10,10,0,0,NULL,NULL,NULL,'176124',NULL,NULL,'2022-03-16 09:47:29','2022-03-16 09:47:29',NULL),(16,'Test','jinesh@arrangi.commfg','$2y$10$nRkz1rdF6fQ2fH.Hq2XmgekavZgGGZKquw3UmRUvI2N7Ljn0epe7u','740536969823fdsd','SCYHNF2JxY',13,0,0,10,10,0,0,NULL,NULL,NULL,'278886',NULL,NULL,'2022-03-16 10:16:26','2022-03-16 10:16:26',NULL),(17,'Test','jineah@arrangi.c','$2y$10$3n8Zk/OjKaXT5P53NecBGOKNSTC/ihxXsNZCo27YiTP8C3mArxuiu','7105369698','88CKxsi0Vs',13,0,0,10,10,0,0,NULL,NULL,NULL,'678725',NULL,NULL,'2022-03-16 20:49:31','2022-03-16 20:49:31',NULL),(18,'Test','jinesh@arrangi.commfggj','$2y$10$mVLwSBueQ8LobtKXYsnI5urV.RTlFugwae7Z9iwndZbUDvytPxoam','740536969823fdsd5','hV5jMdXHsf',0,0,0,10,10,0,0,NULL,NULL,NULL,'209524',NULL,NULL,'2022-03-17 20:24:42','2022-03-17 20:24:42',NULL),(19,'test','sahilumretiya08@gmail.com','$2y$10$YwLLi5jri7Orw3pFolaKMuJkIqhGx3Lt4VlMBzoB9W67HBBnwa4Ra','7069927889','hKNrgG8298',0,12,0,10,10,0,0,NULL,'2022-03-20 03:02:58','2022-03-20 01:56:44',NULL,'2022-04-19 01:56:44',NULL,'2022-03-18 00:33:51','2022-03-20 03:02:58',NULL),(20,'Test','jinesh@arrangi.commfggjfg','$2y$10$dpxqoZSvTmBhv.n4IqWdDetMi73yGv2RoCxIblEGL1hM2XVuCy5jq','740536969823fdsd5gjk','kiDQRYFbGb',0,0,0,10,10,0,0,NULL,NULL,NULL,'117826',NULL,NULL,'2022-03-18 00:36:37','2022-03-18 00:36:37',NULL),(21,'tedt','hvvv@gmail.com','$2y$10$d0.nukmSeORpuvOGo3upX..dr5KWc9msV.3KZZYn1e7hg10cWLYQO','3565658686','Su5ofjrdsc',0,0,0,10,10,0,0,NULL,NULL,NULL,'425392',NULL,NULL,'2022-03-19 22:53:02','2022-03-19 22:53:02',NULL),(22,'yhfh','gchchug@gmail.com','$2y$10$qI63qMAlILhysFPM4SXN.OJL5caBohKCLHNk6/pP4ye1nXmHG5ff2','8868567586','pUWqn1Wo7y',0,0,0,10,10,0,0,NULL,NULL,NULL,'374310',NULL,NULL,'2022-03-19 22:55:23','2022-03-19 22:55:23',NULL),(23,'testing','xyz@gmail.com','$2y$10$aTi2x5uHoEQlyktbMB89zOrU39/Ufxxs2eiiUNWNx7T/V.qKQMKey','9023728374','n593b3tmLE',0,0,0,10,10,0,0,NULL,'2022-03-19 23:28:30',NULL,NULL,NULL,NULL,'2022-03-19 23:26:37','2022-03-19 23:28:30',NULL),(24,'test','teshh@gmail.com','$2y$10$.sLTmM5mdFA.02XP9Z3E7uPMVN4Ssv9ILuPLWQOqvwXwopq3ncp6.','9925496490','Yd22LeHj6o',19,0,0,10,10,0,0,NULL,'2022-03-20 04:16:17',NULL,NULL,NULL,NULL,'2022-03-20 04:15:51','2022-03-20 04:16:17',NULL),(25,'Het','hetthummar1234@gmail.com','$2y$10$8PmZ2ZhNG2fp0nbheYrln.8ZGvGag0MBMfs1aguhx0hFRGoiPJ5FC','9106878548','RJAnYJaaxE',0,150,0,10,10,0,1,NULL,'2022-03-22 00:52:24',NULL,NULL,NULL,NULL,'2022-03-21 23:30:30','2022-03-22 00:52:24',NULL),(26,'Het 2','hetthummar4321@gmail.com','$2y$10$9zymrQh5YSCe4HPEOThlXuvQUmeFffQLwKdTmWg7KFNWJNI7tciiC','1234567891','O2IDqVt6uq',0,0,0,10,10,0,0,NULL,NULL,NULL,'814670',NULL,NULL,'2022-03-21 23:56:26','2022-03-21 23:56:26',NULL),(27,'ridham','rydhamik@gmail.com','$2y$10$EzBSAbPV58XxLMr.CGcepuU0va2k/0LYbANY3lNiWT3Z9id6kCCqy','9727467706','sgax7d5Qea',0,0,0,10,10,0,0,NULL,'2022-03-22 00:42:06',NULL,NULL,NULL,NULL,'2022-03-22 00:41:54','2022-03-22 00:42:06',NULL),(28,'Dharmesh Umaretiya','dharmeshumaretiya@gmail.com','$2y$10$J4zduWI7AydsIsIt5k264.Vm4EBuBtIbGfXGKlhRAsRepEwqwAoiW','9429217715','zklEjTMCf7',0,0,0,10,10,0,0,NULL,NULL,NULL,'242820',NULL,NULL,'2022-03-22 05:29:42','2022-03-22 05:29:42',NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wallet_transactions`
--
DROP TABLE IF EXISTS `wallet_transactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wallet_transactions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`prev_balance` double(30,4) NOT NULL DEFAULT 0.0000,
`new_balance` double(30,4) NOT NULL DEFAULT 0.0000,
`amount` double(30,4) NOT NULL DEFAULT 0.0000,
`action` enum('debit','credit') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'debit',
`transfer_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wallet_transactions`
--
LOCK TABLES `wallet_transactions` WRITE;
/*!40000 ALTER TABLE `wallet_transactions` DISABLE KEYS */;
INSERT INTO `wallet_transactions` VALUES (1,19,0.0000,1.0000,1.0000,'debit',0,'Purchase of 1 tokens','2022-03-20 01:06:20','2022-03-20 01:06:20'),(2,19,1.0000,12.0000,11.0000,'credit',0,'Task completed','2022-03-20 01:09:03','2022-03-20 01:09:03');
/*!40000 ALTER TABLE `wallet_transactions` 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 2022-03-24 2:27:59