-- MySQL dump 10.13 Distrib 8.0.40, for Linux (x86_64) -- -- Host: localhost Database: yapcutedb -- ------------------------------------------------------ -- Server version 8.0.40-0ubuntu0.22.04.1 /*!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 `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, `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_access_tokens` -- DROP TABLE IF EXISTS `oauth_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `client_id` bigint unsigned NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_access_tokens_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_access_tokens` -- LOCK TABLES `oauth_access_tokens` WRITE; /*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */; INSERT INTO `oauth_access_tokens` VALUES ('0c066c0ae7dce66fbd9e2393b1fb7abbb0da3e9ca09f369d5ffc5e45b6a8dfc1f6967b3d75641160',4,1,'shortzz','[]',0,'2023-12-05 11:48:21','2023-12-05 11:48:21','2024-12-05 11:48:21'),('114e5c745898de154669ccabf8265f95d3f28fdd07108db00c535bc25778d0dd0bd4fc85434ca446',4,1,'shortzz','[]',0,'2023-12-13 02:43:43','2023-12-13 02:43:43','2024-12-13 08:13:43'),('174c03345a1d0f4d17f8791318cd06ffafe24eee1a30970c3b4b91f3edf412892f49bf63ec8c4173',1,1,'shortzz','[]',0,'2023-12-13 00:38:58','2023-12-13 00:38:58','2024-12-13 06:08:58'),('2abfac18999a9560793542318bf90f8a1ddde4c58318195d914e41251fa8ccdad6d6a6520976c8c6',1,1,'shortzz','[]',0,'2023-12-06 09:08:25','2023-12-06 09:08:25','2024-12-06 09:08:25'),('2ee85729fb0bdc9bf01dd0a1fc6347f579b0531f5c945b725cf575a225cc3cd00e7cdaa1ac606416',2,1,'shortzz','[]',0,'2023-12-06 06:18:25','2023-12-06 06:18:25','2024-12-06 11:48:25'),('332ae42b8a1e7a77449fcbf7aed328b8b88d9b545bda2d8c03cc2b1139e7b12a7eb28b6b8c03c0ef',6,1,'shortzz','[]',0,'2023-12-06 04:32:23','2023-12-06 04:32:23','2024-12-06 10:02:23'),('3e9e639fff7b4c2d9d9b533f0999f39a299b130912a92d6487d6b8170bab21131f39ef49d0169909',1,1,'shortzz','[]',0,'2023-12-06 07:17:17','2023-12-06 07:17:17','2024-12-06 12:47:17'),('4bcaeb7c2628987e05839d98aa80d8835db622044b8279212d6cb6057e335ea4b329dcf0b951f5a3',17,1,'shortzz','[]',0,'2024-02-10 06:16:31','2024-02-10 06:16:31','2025-02-10 11:46:31'),('4c8b7442fa55d99abed09b5f49eacd90d15a91086c3b3e40d94a64c24e1010c619b5e6f57051677e',1,1,'shortzz','[]',0,'2023-12-06 07:44:23','2023-12-06 07:44:23','2024-12-06 07:44:23'),('634f7e039456323fdbad7966ae2107e245b8ad96e997d05584d3923f795b2b58f4943b4f54f0db74',1,1,'shortzz','[]',0,'2023-12-01 07:56:34','2023-12-01 07:56:34','2024-12-01 07:56:34'),('63fbb545004dec2b6e50b182fbb324c48af6bc48ed59867226260fa36dcfb239acc32438a3201e47',2,1,'shortzz','[]',0,'2023-12-01 10:48:59','2023-12-01 10:48:59','2024-12-01 10:48:59'),('6d317be57f0d8a2c8ca310056c7bd05f2f6b0003b2cf043ec81def6fae58a17018ecf3957ff55cf3',1,1,'shortzz','[]',0,'2023-12-05 11:43:01','2023-12-05 11:43:01','2024-12-05 11:43:01'),('6f2175c1f147e3c480455b477b741caaec45a01400c6e9a8c73e303a657cfc0c7936667c6cd8f49c',13,1,'shortzz','[]',0,'2023-12-21 06:36:07','2023-12-21 06:36:07','2024-12-21 12:06:07'),('70989eb93cf59fa539d9580e4738bb0bd7fb004d71e72d62e73c5c510cb2a48bf3dee2c7535ad15d',1,1,'shortzz','[]',0,'2023-12-11 22:58:15','2023-12-11 22:58:15','2024-12-12 04:28:15'),('726357a86888984d9a3179449edfc4e64c944a1ab015859cac7d59e20778cbbed2cce88d39656918',1,1,'shortzz','[]',0,'2023-12-06 05:50:49','2023-12-06 05:50:49','2024-12-06 05:50:49'),('7bad0812aeec2d4110ff42a3fddaad7d23c73603435ba89d5fe5b7dbb59738b2beb3c9e63329d0a4',5,1,'shortzz','[]',0,'2023-12-06 07:51:09','2023-12-06 07:51:09','2024-12-06 07:51:09'),('89f0fdf3986f5661e4473a3d0af22a655cbf5dd549a288b82a78b823939a1b9de51f0eb4f5a34486',14,1,'shortzz','[]',0,'2023-12-22 02:45:09','2023-12-22 02:45:09','2024-12-22 08:15:09'),('95ad235d6ae94fecfc1a1b3fd49257035e0fa39d1cff8e0e404d2e10a88748d3a879a8feed340a77',8,1,'shortzz','[]',0,'2023-12-06 05:19:40','2023-12-06 05:19:40','2024-12-06 10:49:40'),('9606e42ea65ff718768661a350301b43e42fe17f48972d441055d49a4faab0d22da7cc08f9afd5ee',9,1,'shortzz','[]',0,'2023-12-20 01:55:45','2023-12-20 01:55:45','2024-12-20 07:25:45'),('9713fd2eb983da0581685a1ca43fa4f4109ccecef87f23f15ba5a1a73b7e98d8d389d7ec1caccc2d',4,1,'shortzz','[]',0,'2023-12-15 04:50:13','2023-12-15 04:50:13','2024-12-15 10:20:13'),('9ae5ac99979b6ead5b26044a68661b291d5f4d1a15feb67225352a6130584382f858027043c566f9',2,1,'shortzz','[]',0,'2023-12-01 12:03:20','2023-12-01 12:03:20','2024-12-01 12:03:20'),('a0f099985b3ecc531b7761104ddcb6a3fb0af917921a18f368922844c47ab2c0d5863c978153fd51',5,1,'shortzz','[]',0,'2023-12-07 01:27:59','2023-12-07 01:27:59','2024-12-07 06:57:59'),('a800ff8f2f4dedaf83b3a44394ad44e85c78f938408f65f6d2a608f81e2891ad922f26a7518f009d',4,1,'shortzz','[]',0,'2023-12-12 05:07:57','2023-12-12 05:07:57','2024-12-12 10:37:57'),('a83f9acedac285458c179c9d7c81982060af496bd4b8315bc3799d74807cdb852a8efa52bc70278f',2,1,'shortzz','[]',0,'2023-12-06 05:46:21','2023-12-06 05:46:21','2024-12-06 11:16:21'),('aa0d41e21c0b24ef75df83257758fdad31aa862ce66e3115d95c356bd5bd1bae3f4f7bc2abd2239d',4,1,'shortzz','[]',0,'2023-12-06 22:42:37','2023-12-06 22:42:37','2024-12-07 04:12:37'),('b87923e18495a1b5476041c758191643b26655b2293455063eb9bccd3ee9f59fe0976d55c172c031',1,1,'shortzz','[]',0,'2023-11-30 05:33:21','2023-11-30 05:33:21','2024-11-30 05:33:21'),('b8af030acc825f84be96f8036a633afe37b175e6ba331ba4ce0ddc5492fd4cb735cb7c9141439c97',4,1,'shortzz','[]',0,'2023-12-10 23:07:26','2023-12-10 23:07:26','2024-12-11 04:37:26'),('c31cf8ddf09287c03cb114d617f38eae7b44a0d158dedf942b7e6b9e476d650e9d4a6d0f5794e84e',4,1,'shortzz','[]',0,'2023-12-07 07:02:20','2023-12-07 07:02:20','2024-12-07 12:32:20'),('c36510241f331d8d33ebb079fc9e1325fe019da5f240f62221944d9964b5265f2d4a2012b6b9c19b',1,1,'shortzz','[]',0,'2023-12-11 02:33:46','2023-12-11 02:33:46','2024-12-11 08:03:46'),('c4595c0166777dd7725b054d1a2d10de6993737dcc34925a9a885b37a90f8cc7a22ff914c0b138f2',16,1,'shortzz','[]',0,'2023-12-22 06:13:52','2023-12-22 06:13:52','2024-12-22 11:43:52'),('c4af102e96f89daec26412557adddbcff3192d23d648a198e78b907b22b5871cf54e7e9ef3354472',15,1,'shortzz','[]',0,'2023-12-22 06:07:33','2023-12-22 06:07:33','2024-12-22 11:37:33'),('ca1ba99c80071349b1a60315d5d96231d8693526511f18001eef565291356b0350a64c2673172b60',11,1,'shortzz','[]',0,'2023-12-20 01:57:47','2023-12-20 01:57:47','2024-12-20 07:27:47'),('ccb59b1ffcbb14de4db5ca17beb14084b55d3501cd929fd090235d14f0c1632e9b2e022e50cbc81d',18,1,'shortzz','[]',0,'2024-02-13 04:25:04','2024-02-13 04:25:04','2025-02-13 09:55:04'),('ce7450c34adb77a032da84c2d14d218f0d8de29d8d5e8cf2c58c1d58782f2f007a1dea22f816a6a8',4,1,'shortzz','[]',0,'2023-12-15 04:08:23','2023-12-15 04:08:23','2024-12-15 09:38:23'),('cf5ea223399f836121508fdf53f9ac792c2bc680cf7d80b3a91dd7a5e3cd30b93083898dcf6ef4ca',10,1,'shortzz','[]',0,'2023-12-20 01:57:43','2023-12-20 01:57:43','2024-12-20 07:27:43'),('d48aa0227de6ac3ea5507b45800adf3792de7d6b09e582bb06857bf5610a07d4ab78aee4c534c16f',1,1,'shortzz','[]',0,'2023-12-01 13:01:04','2023-12-01 13:01:04','2024-12-01 13:01:04'),('ea446907b0098dd4a4a54b88663edb6b1cf514a59a9d8b3ead7d0613c302762817f2abfde0ce6e72',7,1,'shortzz','[]',0,'2023-12-06 05:08:42','2023-12-06 05:08:42','2024-12-06 10:38:42'),('eb2ea4a4a509abb34dad954719eda8a49c8d3e3a1bba8f07b60dfc808f54de1973b5fb50f0f2684f',5,1,'shortzz','[]',0,'2023-12-07 02:36:41','2023-12-07 02:36:41','2024-12-07 08:06:41'),('f2add2eeb867006ae2daafa15804948d385adfb1a0f9f6c2023af60e3faf7b0b5e707b89dd66f37c',12,1,'shortzz','[]',0,'2023-12-20 02:09:06','2023-12-20 02:09:06','2024-12-20 07:39:06'),('f9d7a12fc2c872efb432e11dc12aadee0b8cf5755e513a15479be2aa35b01cd76fde5f448baf3043',1,1,'shortzz','[]',0,'2023-11-30 05:32:05','2023-11-30 05:32:05','2024-11-30 05:32:05'),('fd63765efa4d70569ca43ec26c9a0c8c423972d2c03046bf4c913fea8764570893e3b5f551f7bb02',14,1,'shortzz','[]',0,'2023-12-22 02:45:09','2023-12-22 02:45:09','2024-12-22 08:15:09'); /*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_auth_codes` -- DROP TABLE IF EXISTS `oauth_auth_codes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_auth_codes` ( `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned NOT NULL, `client_id` bigint unsigned NOT NULL, `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_auth_codes_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_auth_codes` -- LOCK TABLES `oauth_auth_codes` WRITE; /*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_clients` -- DROP TABLE IF EXISTS `oauth_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_clients` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned DEFAULT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `provider` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `personal_access_client` tinyint(1) NOT NULL, `password_client` tinyint(1) NOT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_clients_user_id_index` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_clients` -- LOCK TABLES `oauth_clients` WRITE; /*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */; INSERT INTO `oauth_clients` VALUES (1,NULL,'Laravel Personal Access Client','4PfWrCtPLoYGDInQgDflRBRsLKwUxdTQwVUwwayx',NULL,'http://localhost',1,0,0,'2021-03-22 02:05:21','2021-03-22 02:05:21'),(2,NULL,'Laravel Password Grant Client','gZdczTJXtFsOwKGX02sLHU6yjSPEjYADq0XOzsWC','users','http://localhost',0,1,0,'2021-03-22 02:05:21','2021-03-22 02:05:21'),(3,1,'Bubbletok','p9UDAOjQNqwLNIIAWd9fl1itLPKbHY9JTAwnxXsz',NULL,'http://127.0.0.1:8000/',0,0,0,'2021-03-22 02:05:39','2021-03-22 02:05:39'); /*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_personal_access_clients` -- DROP TABLE IF EXISTS `oauth_personal_access_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_personal_access_clients` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `client_id` bigint unsigned NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, 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 `oauth_personal_access_clients` -- LOCK TABLES `oauth_personal_access_clients` WRITE; /*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */; INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2021-03-22 02:05:21','2021-03-22 02:05:21'); /*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_refresh_tokens` -- DROP TABLE IF EXISTS `oauth_refresh_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_refresh_tokens` -- LOCK TABLES `oauth_refresh_tokens` WRITE; /*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_resets` ( `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) CHARACTER SET utf8mb4 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 */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_admin` -- DROP TABLE IF EXISTS `tbl_admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_admin` ( `admin_id` int NOT NULL AUTO_INCREMENT, `admin_name` varchar(50) NOT NULL, `admin_email` varchar(100) NOT NULL, `admin_password` varchar(50) NOT NULL, `admin_profile` varchar(100) NOT NULL, `unique_key` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`admin_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_admin` -- LOCK TABLES `tbl_admin` WRITE; /*!40000 ALTER TABLE `tbl_admin` DISABLE KEYS */; INSERT INTO `tbl_admin` VALUES (1,'admin','admin@retrytech.com','admin@123','profile_638.jpeg','dev123','2021-03-16 06:16:45','2021-05-25 05:33:29'),(2,'tester','testadmin@retrytech.com','tester','profile_638.jpeg','dev123','2021-03-16 06:16:45','2021-05-25 05:33:29'); /*!40000 ALTER TABLE `tbl_admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_bookmark` -- DROP TABLE IF EXISTS `tbl_bookmark`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_bookmark` ( `bookmark_id` int NOT NULL AUTO_INCREMENT, `post_id` int NOT NULL, `user_id` int NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`bookmark_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_bookmark` -- LOCK TABLES `tbl_bookmark` WRITE; /*!40000 ALTER TABLE `tbl_bookmark` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_bookmark` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_coin_plan` -- DROP TABLE IF EXISTS `tbl_coin_plan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_coin_plan` ( `coin_plan_id` int NOT NULL AUTO_INCREMENT, `coin_plan_name` varchar(100) NOT NULL, `coin_plan_description` text NOT NULL, `coin_plan_price` varchar(50) NOT NULL, `coin_amount` int NOT NULL, `playstore_product_id` varchar(100) NOT NULL, `appstore_product_id` varchar(100) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`coin_plan_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_coin_plan` -- LOCK TABLES `tbl_coin_plan` WRITE; /*!40000 ALTER TABLE `tbl_coin_plan` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_coin_plan` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_coin_rate` -- DROP TABLE IF EXISTS `tbl_coin_rate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_coin_rate` ( `coin_rate_id` int NOT NULL AUTO_INCREMENT, `usd_rate` varchar(50) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`coin_rate_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_coin_rate` -- LOCK TABLES `tbl_coin_rate` WRITE; /*!40000 ALTER TABLE `tbl_coin_rate` DISABLE KEYS */; INSERT INTO `tbl_coin_rate` VALUES (1,'0.0001','2021-03-16 06:27:48','2021-03-20 06:37:24'); /*!40000 ALTER TABLE `tbl_coin_rate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_comments` -- DROP TABLE IF EXISTS `tbl_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_comments` ( `comments_id` int NOT NULL AUTO_INCREMENT, `post_id` int NOT NULL, `user_id` int NOT NULL, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`comments_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_comments` -- LOCK TABLES `tbl_comments` WRITE; /*!40000 ALTER TABLE `tbl_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_followers` -- DROP TABLE IF EXISTS `tbl_followers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_followers` ( `follower_id` int NOT NULL AUTO_INCREMENT, `from_user_id` int NOT NULL, `to_user_id` int NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`follower_id`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_followers` -- LOCK TABLES `tbl_followers` WRITE; /*!40000 ALTER TABLE `tbl_followers` DISABLE KEYS */; INSERT INTO `tbl_followers` VALUES (1,2,1,1,'2023-12-01 12:57:17',NULL),(2,1,2,1,'2023-12-01 13:01:32',NULL),(3,3,1,1,'2023-12-05 10:38:08',NULL),(6,4,1,1,'2023-12-06 11:11:17',NULL),(8,5,1,1,'2023-12-06 11:18:24',NULL),(9,1,5,1,'2023-12-06 11:49:38',NULL),(10,4,5,1,'2023-12-06 11:50:27',NULL),(11,2,5,1,'2023-12-06 11:51:52',NULL),(13,3,5,1,'2023-12-06 11:56:06',NULL),(14,5,4,1,'2023-12-07 06:55:39',NULL),(15,2,4,1,'2023-12-07 06:56:39',NULL),(17,1,4,1,'2023-12-07 06:57:42',NULL),(18,3,4,1,'2023-12-07 06:58:52',NULL),(19,4,7,1,'2023-12-07 09:27:29',NULL),(20,1,3,1,'2023-12-15 10:19:32',NULL),(21,13,11,1,'2023-12-21 13:54:33',NULL),(22,15,11,1,'2023-12-22 11:39:02',NULL),(23,15,9,1,'2023-12-22 11:39:15',NULL),(24,15,13,1,'2023-12-22 11:39:50',NULL),(25,16,11,1,'2023-12-22 11:44:23',NULL),(26,16,9,1,'2023-12-22 11:44:29',NULL),(27,16,13,1,'2023-12-22 11:44:59',NULL),(28,11,13,1,'2023-12-23 04:55:06',NULL); /*!40000 ALTER TABLE `tbl_followers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_gifts` -- DROP TABLE IF EXISTS `tbl_gifts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_gifts` ( `id` int NOT NULL AUTO_INCREMENT, `coin_price` int DEFAULT NULL, `image` varchar(555) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_gifts` -- LOCK TABLES `tbl_gifts` WRITE; /*!40000 ALTER TABLE `tbl_gifts` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_gifts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_hash_tags` -- DROP TABLE IF EXISTS `tbl_hash_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_hash_tags` ( `hash_tag_id` int NOT NULL AUTO_INCREMENT, `hash_tag_name` varchar(100) NOT NULL, `move_explore` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'if move to explore to display search tab in default hash tag wise video', `move_to_banner` tinyint(1) NOT NULL DEFAULT '0', `hash_tag_profile` text, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hash_tag_id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_hash_tags` -- LOCK TABLES `tbl_hash_tags` WRITE; /*!40000 ALTER TABLE `tbl_hash_tags` DISABLE KEYS */; INSERT INTO `tbl_hash_tags` VALUES (1,'bava',0,0,NULL,'2023-12-07 10:17:23',NULL),(2,'hashtag',0,0,NULL,'2023-12-07 10:26:03',NULL),(3,'check',1,0,'1701945508image-20231103-050158.png','2023-12-07 10:37:26','2023-12-07 10:38:29'),(4,'today',1,0,'1701951041logo_(4)_2.png','2023-12-07 12:09:47','2023-12-07 12:10:41'),(5,'new',1,0,'1702632199Screenshot_1701843285.png','2023-12-15 09:22:53','2023-12-15 09:23:19'),(6,'Lord',0,0,NULL,'2023-12-20 07:49:20',NULL),(7,'kushi',0,0,NULL,'2023-12-21 13:48:32',NULL),(8,'joe',0,0,NULL,'2023-12-21 18:12:27',NULL),(9,'ben10',0,0,NULL,'2023-12-22 08:30:27',NULL),(10,'ben',0,0,NULL,'2023-12-22 08:40:09',NULL),(11,'railin',0,0,NULL,'2023-12-22 17:37:18',NULL),(12,'uethi',0,0,NULL,'2023-12-22 17:50:09',NULL),(13,'u',0,0,NULL,'2023-12-22 17:50:09',NULL),(14,'yethi',0,0,NULL,'2023-12-22 17:50:09',NULL); /*!40000 ALTER TABLE `tbl_hash_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_likes` -- DROP TABLE IF EXISTS `tbl_likes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_likes` ( `like_id` int NOT NULL AUTO_INCREMENT, `post_id` int NOT NULL, `user_id` int NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`like_id`) ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_likes` -- LOCK TABLES `tbl_likes` WRITE; /*!40000 ALTER TABLE `tbl_likes` DISABLE KEYS */; INSERT INTO `tbl_likes` VALUES (11,29,11,'2023-12-21 13:42:11',NULL),(12,28,13,'2023-12-21 13:52:01',NULL),(14,27,13,'2023-12-21 13:54:56',NULL),(15,35,13,'2023-12-21 13:54:58',NULL),(16,30,13,'2023-12-21 13:55:02',NULL),(18,32,13,'2023-12-21 13:55:11',NULL),(19,33,13,'2023-12-21 13:55:15',NULL),(20,31,13,'2023-12-21 13:55:19',NULL),(21,39,13,'2023-12-21 16:32:49',NULL),(22,38,13,'2023-12-21 16:32:51',NULL),(23,34,13,'2023-12-21 18:08:17',NULL),(24,36,13,'2023-12-21 18:08:21',NULL),(25,37,13,'2023-12-21 18:10:00',NULL),(26,27,15,'2023-12-22 11:37:45',NULL),(27,35,15,'2023-12-22 11:37:48',NULL),(28,36,15,'2023-12-22 11:37:51',NULL),(29,32,15,'2023-12-22 11:37:58',NULL),(30,34,15,'2023-12-22 11:37:59',NULL),(31,30,15,'2023-12-22 11:38:01',NULL),(32,29,15,'2023-12-22 11:38:10',NULL),(33,31,15,'2023-12-22 11:38:16',NULL),(34,39,15,'2023-12-22 11:38:22',NULL),(35,41,15,'2023-12-22 11:38:27',NULL),(36,37,15,'2023-12-22 11:38:36',NULL),(37,38,15,'2023-12-22 11:38:38',NULL),(38,28,15,'2023-12-22 11:38:42',NULL),(39,42,15,'2023-12-22 11:38:44',NULL),(40,33,15,'2023-12-22 11:38:52',NULL),(41,36,16,'2023-12-22 11:44:00',NULL),(42,28,16,'2023-12-22 11:44:01',NULL),(43,42,16,'2023-12-22 11:44:06',NULL),(44,29,16,'2023-12-22 11:44:06',NULL),(45,41,16,'2023-12-22 11:44:09',NULL),(46,34,16,'2023-12-22 11:44:12',NULL),(47,33,16,'2023-12-22 11:44:14',NULL),(48,30,16,'2023-12-22 11:44:16',NULL),(49,35,16,'2023-12-22 11:44:20',NULL),(50,37,16,'2023-12-22 11:44:36',NULL),(51,32,16,'2023-12-22 11:44:42',NULL),(52,38,16,'2023-12-22 11:44:43',NULL),(53,43,13,'2023-12-22 17:35:54',NULL),(55,43,11,'2023-12-23 04:54:48',NULL); /*!40000 ALTER TABLE `tbl_likes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_notification` -- DROP TABLE IF EXISTS `tbl_notification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_notification` ( `notification_id` int NOT NULL AUTO_INCREMENT, `sender_user_id` int NOT NULL, `received_user_id` int NOT NULL, `notification_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'send_coin', `item_id` int DEFAULT NULL, `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`notification_id`) ) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_notification` -- LOCK TABLES `tbl_notification` WRITE; /*!40000 ALTER TABLE `tbl_notification` DISABLE KEYS */; INSERT INTO `tbl_notification` VALUES (4,1,2,4,1,'Bhuvan sent you 15 Stars','2023-12-04 04:43:14',NULL),(6,3,1,3,3,'bhuvaneswari nk started following you','2023-12-05 10:38:09',NULL),(7,1,3,3,1,'Bhuvana started following you','2023-12-05 10:39:42',NULL),(13,1,3,3,1,'Bhuvi started following you','2023-12-06 10:55:27',NULL),(15,4,1,3,4,'bava started following you','2023-12-06 11:11:17',NULL),(18,1,5,3,1,'Bhuvi started following you','2023-12-06 11:49:38',NULL),(19,4,5,3,4,'bava started following you','2023-12-06 11:50:27',NULL),(20,2,5,3,2,'mohamad started following you','2023-12-06 11:51:52',NULL),(22,3,5,3,3,'bhuvaneswari nk started following you','2023-12-06 11:56:06',NULL),(24,2,4,3,2,'mohamad started following you','2023-12-07 06:56:39',NULL),(26,1,4,3,1,'Bhuvi started following you','2023-12-07 06:57:42',NULL),(27,3,4,3,3,'bhuvaneswari nk started following you','2023-12-07 06:58:52',NULL),(28,4,7,3,4,'bava started following you','2023-12-07 09:27:29',NULL),(31,1,3,3,1,'Bhuvi started following you','2023-12-15 10:19:32',NULL),(32,11,9,1,29,'Uma Kondalsamy liked your video','2023-12-21 13:42:11',NULL),(33,13,11,1,28,'Harun Matthew✨ liked your video','2023-12-21 13:52:01',NULL),(34,13,11,1,36,'Harun Matthew✨ liked your video','2023-12-21 13:52:59',NULL),(35,13,11,3,13,'Harun Matthew✨ started following you','2023-12-21 13:54:33',NULL),(36,13,11,1,27,'Harun Matthew✨ liked your video','2023-12-21 13:54:56',NULL),(37,13,11,1,35,'Harun Matthew✨ liked your video','2023-12-21 13:54:58',NULL),(38,13,9,1,30,'Harun Matthew✨ liked your video','2023-12-21 13:55:02',NULL),(39,13,10,1,34,'Harun Matthew✨ liked your video','2023-12-21 13:55:10',NULL),(40,13,11,1,32,'Harun Matthew✨ liked your video','2023-12-21 13:55:11',NULL),(41,13,10,1,33,'Harun Matthew✨ liked your video','2023-12-21 13:55:15',NULL),(42,13,9,1,31,'Harun Matthew✨ liked your video','2023-12-21 13:55:19',NULL),(43,13,12,1,39,'Harun Matthew✨ liked your video','2023-12-21 16:32:49',NULL),(44,13,12,1,38,'Harun Matthew✨ liked your video','2023-12-21 16:32:51',NULL),(45,13,10,1,34,'Harun Matthew✨ liked your video','2023-12-21 18:08:17',NULL),(46,13,11,1,36,'Harun Matthew✨ liked your video','2023-12-21 18:08:21',NULL),(47,13,11,1,37,'Harun Matthew✨ liked your video','2023-12-21 18:10:00',NULL),(48,15,11,1,27,'Madhan Madhan liked your video','2023-12-22 11:37:45',NULL),(49,15,11,1,35,'Madhan Madhan liked your video','2023-12-22 11:37:48',NULL),(50,15,11,1,36,'Madhan Madhan liked your video','2023-12-22 11:37:51',NULL),(51,15,11,1,32,'Madhan Madhan liked your video','2023-12-22 11:37:58',NULL),(52,15,10,1,34,'Madhan Madhan liked your video','2023-12-22 11:37:59',NULL),(53,15,9,1,30,'Madhan Madhan liked your video','2023-12-22 11:38:01',NULL),(54,15,9,1,29,'Madhan Madhan liked your video','2023-12-22 11:38:10',NULL),(55,15,9,1,31,'Madhan Madhan liked your video','2023-12-22 11:38:16',NULL),(56,15,12,1,39,'Madhan Madhan liked your video','2023-12-22 11:38:22',NULL),(57,15,14,1,41,'Madhan Madhan liked your video','2023-12-22 11:38:27',NULL),(58,15,11,1,37,'Madhan Madhan liked your video','2023-12-22 11:38:36',NULL),(59,15,12,1,38,'Madhan Madhan liked your video','2023-12-22 11:38:38',NULL),(60,15,11,1,28,'Madhan Madhan liked your video','2023-12-22 11:38:42',NULL),(61,15,14,1,42,'Madhan Madhan liked your video','2023-12-22 11:38:44',NULL),(62,15,10,1,33,'Madhan Madhan liked your video','2023-12-22 11:38:52',NULL),(63,15,11,3,15,'Madhan Madhan started following you','2023-12-22 11:39:02',NULL),(64,15,9,3,15,'Madhan Madhan started following you','2023-12-22 11:39:15',NULL),(65,15,13,3,15,'Madhan Madhan started following you','2023-12-22 11:39:50',NULL),(66,16,11,1,36,'Suji Dhina liked your video','2023-12-22 11:44:00',NULL),(67,16,11,1,28,'Suji Dhina liked your video','2023-12-22 11:44:01',NULL),(68,16,14,1,42,'Suji Dhina liked your video','2023-12-22 11:44:06',NULL),(69,16,9,1,29,'Suji Dhina liked your video','2023-12-22 11:44:06',NULL),(70,16,14,1,41,'Suji Dhina liked your video','2023-12-22 11:44:09',NULL),(71,16,10,1,34,'Suji Dhina liked your video','2023-12-22 11:44:12',NULL),(72,16,10,1,33,'Suji Dhina liked your video','2023-12-22 11:44:14',NULL),(73,16,9,1,30,'Suji Dhina liked your video','2023-12-22 11:44:16',NULL),(74,16,11,1,35,'Suji Dhina liked your video','2023-12-22 11:44:20',NULL),(75,16,11,3,16,'Suji Dhina started following you','2023-12-22 11:44:23',NULL),(76,16,9,3,16,'Suji Dhina started following you','2023-12-22 11:44:29',NULL),(77,16,11,1,37,'Suji Dhina liked your video','2023-12-22 11:44:36',NULL),(78,16,11,1,32,'Suji Dhina liked your video','2023-12-22 11:44:42',NULL),(79,16,12,1,38,'Suji Dhina liked your video','2023-12-22 11:44:43',NULL),(80,16,13,3,16,'Suji Dhina started following you','2023-12-22 11:44:59',NULL),(81,11,13,1,43,'Uma Kondalsamy liked your video','2023-12-23 04:54:48',NULL),(82,11,13,3,11,'Uma Kondalsamy started following you','2023-12-23 04:55:06',NULL); /*!40000 ALTER TABLE `tbl_notification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_post` -- DROP TABLE IF EXISTS `tbl_post`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_post` ( `post_id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `sound_id` int NOT NULL DEFAULT '0', `post_description` longblob, `post_hash_tag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `post_video` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `post_image` text NOT NULL, `video_view_count` int NOT NULL DEFAULT '0', `is_trending` tinyint(1) NOT NULL DEFAULT '0', `can_comment` tinyint(1) NOT NULL DEFAULT '0', `can_duet` tinyint(1) NOT NULL DEFAULT '0', `can_save` tinyint(1) NOT NULL DEFAULT '0', `country_code` varchar(100) NOT NULL DEFAULT '+91', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`post_id`) ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_post` -- LOCK TABLES `tbl_post` WRITE; /*!40000 ALTER TABLE `tbl_post` DISABLE KEYS */; INSERT INTO `tbl_post` VALUES (27,11,27,'','','1703057463image_picker4906179292060011923.mp4','1703057463thumbNail.png',113,0,0,0,0,'+91','2023-12-20 07:31:04','2024-06-07 09:07:08'),(28,11,28,'','','1703057510image_picker7178099877050387345.mp4','1703057510thumbNail.png',97,0,0,0,0,'+91','2023-12-20 07:31:50','2024-03-25 05:57:29'),(29,9,29,_binary 'Good Night','','1703057578image_picker6946761898580114353.mp4','1703057578thumbNail.png',117,0,0,0,0,'+91','2023-12-20 07:32:58','2024-08-10 05:24:35'),(30,9,30,_binary 'God Bless You','','1703057649image_picker9138206556854656647.mp4','1703057649thumbNail.png',94,0,0,0,0,'+91','2023-12-20 07:34:09','2024-05-18 15:12:00'),(31,9,31,_binary 'Neeya Naana','','1703057731image_picker269828261070035664.mp4','1703057731thumbNail.png',95,0,0,0,0,'+91','2023-12-20 07:35:31','2024-08-10 05:24:38'),(32,11,32,'','','1703057758image_picker8998711952486201395.mp4','1703057758thumbNail.png',98,0,0,0,0,'+91','2023-12-20 07:35:58','2024-06-07 09:07:14'),(33,10,33,_binary '#Lord shivaa🙏🔱💫','Lord','1703058559image_picker1233252678704634157.mp4','1703058560thumbNail.png',102,0,0,0,0,'+91','2023-12-20 07:49:20','2024-06-07 09:07:08'),(34,10,34,_binary 'உன் வார்த்தைக்கு முன்னால் என் வாழ்வே உன் பின்னால்...❤️🦋💫','','1703059241image_picker5600350515241036687.mp4','1703059241thumbNail.png',107,0,0,0,0,'+91','2023-12-20 08:00:42','2024-08-10 05:24:34'),(35,11,35,_binary '#kushi','kushi,kushi','','',76,0,0,0,0,'+91','2023-12-21 13:48:32','2024-06-07 09:06:53'),(36,11,36,_binary '#kushi','kushi,kushi,kushi','1703166653image_picker1681322564714424260.mp4','1703166654thumbNail.png',77,0,0,0,0,'+91','2023-12-21 13:50:54','2024-05-18 15:11:35'),(37,11,37,_binary 'kushi','','1703167161image_picker108351578177864427.mp4','1703167161thumbNail.png',60,0,0,0,0,'+91','2023-12-21 13:59:21','2024-06-07 09:06:49'),(38,12,38,'','','','',75,0,0,0,0,'+91','2023-12-21 16:27:59','2024-06-07 09:07:07'),(39,12,39,'','','','',64,0,0,0,0,'+91','2023-12-21 16:28:01','2024-05-26 05:26:02'),(41,14,41,_binary '#ben10','ben10','','',30,0,0,0,0,'+91','2023-12-22 08:30:27','2024-05-18 15:11:52'),(42,14,42,_binary '#ben 10','ben','','',48,0,0,0,0,'+91','2023-12-22 08:40:09','2024-03-25 05:58:00'),(43,13,43,_binary '#joe#urugi urugi','joe','1703251888image_picker251417748960948236.mp4','1703251889thumbNail.png',66,0,0,0,0,'+91','2023-12-22 13:31:29','2024-06-07 09:07:10'),(46,13,46,'','','1703315016image_picker4601414959962596030.mp4','1703315017thumbNail.png',19,0,0,0,0,'+91','2023-12-23 07:03:37','2024-03-25 05:58:29'),(47,13,47,'','','1705747570image_picker6919375369495261620.mp4','1705747570thumbNail.png',8,0,0,0,0,'+91','2024-01-20 10:46:10','2024-06-07 09:06:52'),(48,13,48,'','','1705747597image_picker1355400838719684186.mp4','1705747598thumbNail.png',4,0,0,0,0,'+91','2024-01-20 10:46:38','2024-06-15 10:25:30'),(49,13,49,'','','1705747619image_picker2434635305888893013.mp4','1705747619thumbNail.png',8,0,0,0,0,'+91','2024-01-20 10:46:59','2024-06-15 10:25:23'),(50,13,50,'','','1705747636image_picker819535795032195084.mp4','1705747636thumbNail.png',2,0,0,0,0,'+91','2024-01-20 10:47:16','2024-03-25 05:58:05'),(51,13,51,'','','1705747658image_picker2781448829355318630.mp4','1705747658thumbNail.png',6,0,0,0,0,'+91','2024-01-20 10:47:38','2024-03-25 05:57:30'),(52,13,52,'','','1705747701image_picker6418652831037362835.mp4','1705747701thumbNail.png',12,0,0,0,0,'+91','2024-01-20 10:48:21','2024-06-07 09:07:00'); /*!40000 ALTER TABLE `tbl_post` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_profile_category` -- DROP TABLE IF EXISTS `tbl_profile_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_profile_category` ( `profile_category_id` int NOT NULL AUTO_INCREMENT, `profile_category_name` varchar(100) NOT NULL, `profile_category_image` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`profile_category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_profile_category` -- LOCK TABLES `tbl_profile_category` WRITE; /*!40000 ALTER TABLE `tbl_profile_category` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_profile_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_redeem_request` -- DROP TABLE IF EXISTS `tbl_redeem_request`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_redeem_request` ( `redeem_request_id` int NOT NULL AUTO_INCREMENT, `redeem_request_type` varchar(10) NOT NULL COMMENT 'paytm,paypal', `account` varchar(100) NOT NULL, `amount` varchar(100) NOT NULL, `user_id` int NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`redeem_request_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_redeem_request` -- LOCK TABLES `tbl_redeem_request` WRITE; /*!40000 ALTER TABLE `tbl_redeem_request` DISABLE KEYS */; INSERT INTO `tbl_redeem_request` VALUES (1,'Paytm','demo@gmail.com','0.000115',1,0,'2023-12-06 13:13:03',NULL); /*!40000 ALTER TABLE `tbl_redeem_request` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_report` -- DROP TABLE IF EXISTS `tbl_report`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_report` ( `report_id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `post_id` int DEFAULT NULL, `report_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 for report_user,2 for report_video', `reason` varchar(255) NOT NULL, `description` text NOT NULL, `contact_info` text NOT NULL, `status` int NOT NULL DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`report_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_report` -- LOCK TABLES `tbl_report` WRITE; /*!40000 ALTER TABLE `tbl_report` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_report` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_rewarding_action` -- DROP TABLE IF EXISTS `tbl_rewarding_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_rewarding_action` ( `rewarding_action_id` int NOT NULL AUTO_INCREMENT, `action_name` varchar(100) NOT NULL, `coin` int NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`rewarding_action_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_rewarding_action` -- LOCK TABLES `tbl_rewarding_action` WRITE; /*!40000 ALTER TABLE `tbl_rewarding_action` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_rewarding_action` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_settings` -- DROP TABLE IF EXISTS `tbl_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_settings` ( `id` int NOT NULL AUTO_INCREMENT, `currency` varchar(10) NOT NULL DEFAULT '$', `coin_value` float NOT NULL DEFAULT '0.001', `min_redeem_coins` int NOT NULL DEFAULT '1000', `min_fans_verification` int NOT NULL DEFAULT '10', `min_fans_for_live` int NOT NULL DEFAULT '100', `reward_video_upload` int NOT NULL DEFAULT '0', `admob_banner` varchar(555) DEFAULT NULL, `admob_int` varchar(555) DEFAULT NULL, `admob_int_ios` varchar(255) DEFAULT NULL, `admob_banner_ios` varchar(255) DEFAULT NULL, `max_upload_daily` int NOT NULL DEFAULT '10', `live_min_viewers` int NOT NULL DEFAULT '0', `live_timeout` int NOT NULL DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_settings` -- LOCK TABLES `tbl_settings` WRITE; /*!40000 ALTER TABLE `tbl_settings` DISABLE KEYS */; INSERT INTO `tbl_settings` VALUES (1,'$',0.001,100,500,5,10,NULL,NULL,NULL,NULL,10,60,100,'2022-04-06 06:16:05','2022-12-05 00:27:11'); /*!40000 ALTER TABLE `tbl_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_sound` -- DROP TABLE IF EXISTS `tbl_sound`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_sound` ( `sound_id` int NOT NULL AUTO_INCREMENT, `sound_category_id` int NOT NULL DEFAULT '0', `sound_title` varchar(250) NOT NULL, `sound` varchar(200) NOT NULL, `duration` varchar(100) NOT NULL, `singer` varchar(100) NOT NULL, `sound_image` text NOT NULL, `added_by` varchar(10) NOT NULL DEFAULT 'user', `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=not 1=deleted', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`sound_id`) ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_sound` -- LOCK TABLES `tbl_sound` WRITE; /*!40000 ALTER TABLE `tbl_sound` DISABLE KEYS */; INSERT INTO `tbl_sound` VALUES (1,0,'Original Sound','17013224991701322465575sound.wav','1','Bhuvan','1701322499thumbNail.png','user',0,'2023-11-30 05:34:59',NULL),(2,0,'Original Sound','17014148331701414912951sound.wav','1','Bhuvan','1701414833thumbNail.png','user',0,'2023-12-01 07:13:53',NULL),(3,0,'Original Sound','17014247711701424736109sound.wav','1','Bhuvan','1701424771thumbNail.png','user',0,'2023-12-01 09:59:31',NULL),(4,0,'Original Sound','17014271991701427286802sound.wav','1','mohamad','1701427199thumbNail.png','user',0,'2023-12-01 10:39:59',NULL),(5,0,'Original Sound','17014278141701427761509sound.wav','1','mohamad','1701427814thumbNail.png','user',0,'2023-12-01 10:50:14',NULL),(6,0,'Original Sound','17014323361701432423354sound.wav','1','mohamad','1701432336thumbNail.png','user',0,'2023-12-01 12:05:36',NULL),(7,0,'Original Sound','17016644371701664383156sound.wav','1','Bhuvan','1701664437thumbNail.png','user',0,'2023-12-04 04:33:58',NULL),(8,0,'Original Sound','17018491371701849220870sound.wav','1','yapdemo','1701849138thumbNail.png','user',0,'2023-12-06 07:52:18',NULL),(9,0,'Original Sound','17018498001701849697903sound.wav','1','Bhuvi','1701849800thumbNail.png','user',0,'2023-12-06 08:03:20',NULL),(10,0,'Original Sound','17018544651701854431131sound.wav','1','Bhuvi','1701854465thumbNail.png','user',0,'2023-12-06 09:21:05',NULL),(11,0,'Original Sound','17018548511701854936860sound.wav','1','Bhuvi','1701854851thumbNail.png','user',0,'2023-12-06 09:27:31',NULL),(12,0,'Original Sound','17018555701701855665826sound.wav','1','yapdemo','1701855570thumbNail.png','user',0,'2023-12-06 09:39:30',NULL),(13,0,'Original Sound','17018587831701858877810sound.wav','1','satham','1701858783thumbNail.png','user',0,'2023-12-06 10:33:04',NULL),(14,0,'Original Sound','17018588851701858949738sound.wav','1','satham','1701858886thumbNail.png','user',0,'2023-12-06 10:34:46',NULL),(15,0,'Original Sound','17018592231701859286877sound.wav','1','Server Admin','1701859223thumbNail.png','user',0,'2023-12-06 10:40:23',NULL),(16,0,'Original Sound','17018593301701859366958sound.wav','1','Server Admin','1701859331thumbNail.png','user',0,'2023-12-06 10:42:11',NULL),(17,0,'Original Sound','17018596361701859449524sound.wav','1','Server Admin','1701859637thumbNail.png','user',0,'2023-12-06 10:47:17',NULL),(18,0,'Original Sound','17018598831701859969686sound.wav','1','Janmy','1701859883thumbNail.png','user',0,'2023-12-06 10:51:23',NULL),(19,0,'Original Sound','17019227481701922711388sound.wav','1','bava','1701922748thumbNail.png','user',0,'2023-12-07 04:19:08',NULL),(20,0,'Original Sound','17019442431701944174606sound.wav','1','bava','1701944243thumbNail.png','user',0,'2023-12-07 10:17:23',NULL),(21,0,'Original Sound','17019447631701944667395sound.wav','1','bava','1701944763thumbNail.png','user',0,'2023-12-07 10:26:03',NULL),(22,0,'Original Sound','17019450321701945122277sound.wav','1','yapdemo','1701945032thumbNail.png','user',0,'2023-12-07 10:30:32',NULL),(23,0,'Original Sound','17019454461701945527687sound.wav','1','yapdemo','1701945446thumbNail.png','user',0,'2023-12-07 10:37:27',NULL),(24,0,'Original Sound','17019509871701951095635sound.wav','1','Bhuvi','1701950987thumbNail.png','user',0,'2023-12-07 12:09:47',NULL),(25,0,'Original Sound','17026320041702632090023sound.wav','1','Bhuvi','1702632004thumbNail.png','user',0,'2023-12-15 09:20:04',NULL),(26,0,'Original Sound','17026321731702632267796sound.wav','1','Bhuvi','1702632174thumbNail.png','user',0,'2023-12-15 09:22:54',NULL),(27,0,'Original Sound','1703057464sound.wav','1','Uma Kondalsamy','1703057464thumbNail.png','user',0,'2023-12-20 07:31:04',NULL),(28,0,'Original Sound','1703057510sound.wav','1','Uma Kondalsamy','1703057510thumbNail.png','user',0,'2023-12-20 07:31:51',NULL),(29,0,'Original Sound','1703057578sound.wav','1','Boobalan G','1703057578thumbNail.png','user',0,'2023-12-20 07:32:58',NULL),(30,0,'Original Sound','1703057649sound.wav','1','Boobalan G','1703057649thumbNail.png','user',0,'2023-12-20 07:34:09',NULL),(31,0,'Original Sound','1703057731sound.wav','1','Boobalan G','1703057731thumbNail.png','user',0,'2023-12-20 07:35:31',NULL),(32,0,'Original Sound','1703057758sound.wav','1','Uma Kondalsamy','1703057758thumbNail.png','user',0,'2023-12-20 07:35:59',NULL),(33,0,'Original Sound','1703058560sound.wav','1','Nahu Naha','1703058560thumbNail.png','user',0,'2023-12-20 07:49:20',NULL),(34,0,'Original Sound','1703059242sound.wav','1','Nahu Naha','1703059242thumbNail.png','user',0,'2023-12-20 08:00:42',NULL),(35,0,'Original Sound','1703166512sound.wav','1','Uma Kondalsamy','1703166512thumbNail.png','user',0,'2023-12-21 13:48:32',NULL),(36,0,'Original Sound','1703166654sound.wav','1','Uma Kondalsamy','1703166654thumbNail.png','user',0,'2023-12-21 13:50:54',NULL),(37,0,'Original Sound','1703167161sound.wav','1','Uma Kondalsamy','1703167162thumbNail.png','user',0,'2023-12-21 13:59:22',NULL),(38,0,'Original Sound','','1','Priya Koki','','user',0,'2023-12-21 16:27:59',NULL),(39,0,'Original Sound','','1','Priya Koki','','user',0,'2023-12-21 16:28:01',NULL),(40,0,'Original Sound','1703182347sound.wav','1','Harun Matthew✨','1703182347thumbNail.png','user',0,'2023-12-21 18:12:28',NULL),(41,0,'Original Sound','','1','Barath Barath','','user',0,'2023-12-22 08:30:27',NULL),(42,0,'Original Sound','','1','Barath Barath','','user',0,'2023-12-22 08:40:09',NULL),(43,0,'Original Sound','1703251889sound.wav','1','Harun Matthew✨','1703251889thumbNail.png','user',0,'2023-12-22 13:31:29',NULL),(44,0,'Original Sound','','1','Harun Matthew✨','','user',0,'2023-12-22 17:37:18',NULL),(45,0,'Original Sound','','1','Harun Matthew✨','','user',0,'2023-12-22 17:50:09',NULL),(46,0,'Original Sound','1703315017sound.wav','1','Harun Matthew✨','1703315017thumbNail.png','user',0,'2023-12-23 07:03:37',NULL),(47,0,'Original Sound','1705747570sound.wav','1','Harun Matthew✨','1705747571thumbNail.png','user',0,'2024-01-20 10:46:11',NULL),(48,0,'Original Sound','1705747598sound.wav','1','Harun Matthew✨','1705747598thumbNail.png','user',0,'2024-01-20 10:46:38',NULL),(49,0,'Original Sound','1705747619sound.wav','1','Harun Matthew✨','1705747619thumbNail.png','user',0,'2024-01-20 10:46:59',NULL),(50,0,'Original Sound','1705747636sound.wav','1','Harun Matthew✨','1705747636thumbNail.png','user',0,'2024-01-20 10:47:17',NULL),(51,0,'Original Sound','1705747658sound.wav','1','Harun Matthew✨','1705747658thumbNail.png','user',0,'2024-01-20 10:47:38',NULL),(52,0,'Original Sound','1705747701sound.wav','1','Harun Matthew✨','1705747701thumbNail.png','user',0,'2024-01-20 10:48:21',NULL); /*!40000 ALTER TABLE `tbl_sound` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_sound_category` -- DROP TABLE IF EXISTS `tbl_sound_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_sound_category` ( `sound_category_id` int NOT NULL AUTO_INCREMENT, `sound_category_name` varchar(200) NOT NULL, `sound_category_profile` text NOT NULL, `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=not 1=deleted', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`sound_category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_sound_category` -- LOCK TABLES `tbl_sound_category` WRITE; /*!40000 ALTER TABLE `tbl_sound_category` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_sound_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_user_block` -- DROP TABLE IF EXISTS `tbl_user_block`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_user_block` ( `id` int NOT NULL AUTO_INCREMENT, `from_user_id` int NOT NULL, `block_user_id` int NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime 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 `tbl_user_block` -- LOCK TABLES `tbl_user_block` WRITE; /*!40000 ALTER TABLE `tbl_user_block` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_user_block` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_users` -- DROP TABLE IF EXISTS `tbl_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_users` ( `user_id` int NOT NULL AUTO_INCREMENT, `full_name` varchar(50) NOT NULL, `user_name` varchar(50) NOT NULL, `user_email` varchar(50) NOT NULL, `user_mobile_no` varchar(20) DEFAULT NULL, `user_profile` text, `login_type` varchar(10) NOT NULL COMMENT 'facebook OR google', `identity` text NOT NULL, `platform` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 for android OR 2 for ios', `device_token` text NOT NULL, `is_verify` tinyint(1) NOT NULL DEFAULT '0', `total_received` int NOT NULL DEFAULT '0', `total_send` int NOT NULL DEFAULT '0', `my_wallet` int NOT NULL DEFAULT '0', `spen_in_app` int NOT NULL DEFAULT '0', `check_in` int NOT NULL DEFAULT '0', `upload_video` int NOT NULL DEFAULT '0', `from_fans` int NOT NULL DEFAULT '0', `purchased` int NOT NULL DEFAULT '0', `bio` blob, `profile_category` int DEFAULT NULL, `fb_url` varchar(100) DEFAULT NULL, `insta_url` varchar(100) DEFAULT NULL, `youtube_url` varchar(100) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `freez_or_not` tinyint(1) NOT NULL DEFAULT '0', `timezone` varchar(50) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_users` -- LOCK TABLES `tbl_users` WRITE; /*!40000 ALTER TABLE `tbl_users` DISABLE KEYS */; INSERT INTO `tbl_users` VALUES (1,'Bhuvi','ELQ457916NBO','bhuvi.1571999@gmail.com',NULL,NULL,'google','bhuvi.1571999@gmail.com',0,'',0,30,0,30,0,0,30,0,0,NULL,NULL,NULL,NULL,'https://www.youtube.com/',2,0,'Asia/Kolkata','2023-11-30 05:32:05','2023-12-15 10:19:59'),(2,'mohamad','RSH362934FCT','thasthakirfazal66@gmail.com',NULL,NULL,'email','thasthakirfazal66@gmail.com',0,'',0,45,0,45,0,0,30,15,0,NULL,NULL,NULL,NULL,NULL,2,0,'Asia/Kolkata','2023-12-01 10:29:42','2023-12-07 06:56:43'),(3,'bhuvaneswari nk','ISU114269LWA','bhuvimenpani@gmail.com',NULL,NULL,'google','bhuvimenpani@gmail.com',0,'',0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-05 10:13:40','2023-12-07 08:06:28'),(4,'bava','BNI311092QTJ','bava1402@gmail.com',NULL,NULL,'email','bava1402@gmail.com',1,'fkU564BHSAeOL53jeEnJuY:APA91bF9fUPy2OWMZTIcnCfHaj2-tejBrIe4RbCDOXLlM8HI6Phm4HAwgkvRxCZ1GxnerbdoTDufeNpmEGFHK16F42-MCpzuL2obPdsQTcOicX_01RjhkgBi8Qhsv5Ft6BFm_Mr92VJD',0,30,0,30,0,0,30,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-05 11:16:15','2023-12-15 10:20:12'),(5,'yapdemo','GYC116671YYM','yapcuteaws2023@gmail.com',NULL,NULL,'email','yapcuteaws2023@gmail.com',1,'ewIkJVscSbaSjmiWjy8SMK:APA91bFOKohw9EbliuRTSiikt7gr3-SSeTYZln5Vi9NdUIYF4bqF0Lidi__TuuNOdDwBMGU238wPtWl0zSRSqN6RPo3AuIoNo94Ud_ozEI3rA_EUNjK0xK7uM_DqUS0kB00VpMb4CGXZ',0,110,0,110,0,0,110,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-06 07:51:09','2023-12-07 10:37:27'),(6,'satham','OBO335841JGE','satham7321@gmail.com',NULL,NULL,'email','satham7321@gmail.com',0,'',0,40,0,40,0,0,40,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-06 10:02:23','2023-12-06 10:36:06'),(7,'Server Admin','RXI242185PDD','tgsslinuxserveraws01@gmail.com',NULL,NULL,'email','tgsslinuxserveraws01@gmail.com',0,'',0,60,0,60,0,0,60,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-06 10:38:42','2023-12-06 10:48:09'),(9,'Boobalan G','KQS455904UNY','boobalang@gmail.com',NULL,NULL,'google','boobalang@gmail.com',1,'csT76Xe7SHGfxika_yniIH:APA91bGCWfUBnaDMQ15lkRXwfXN5qJZh-pcoB9P1NK4ouWgZmrBDXnZSf8y6FwF9wI0d0MZdQZ2TpEpMGQ_O1JbEpG_2yl-wDBNnEr56aW75B0GrYdHehpwhlXE9VvLFC3fwGSOxzxYx',0,30,0,30,0,0,30,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-20 07:25:45','2023-12-20 07:35:32'),(10,'Nahu Naha','Nahaa','kaleesnagu11@gmail.com',NULL,NULL,'google','kaleesnagu11@gmail.com',1,'fhVJ2W_8ST-mVJAr6vOOAy:APA91bG1_dWR9O_KzpU9625sRy5RNH1ehiYjfRe4ddQ-B5VqEBSg3ia7N4sCVewFXbbW864YIA3oOOihOJMEXHU_Jm667TKufMknBv_FowqrRqIadkO-WgAz9H8CnVd2xUhcIv3dTd_A',0,20,0,20,0,0,20,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-20 07:27:43','2023-12-20 14:11:26'),(11,'Uma Kondalsamy','UMA KONDALASAMY','umakondalsamy@gmail.com',NULL,NULL,'google','umakondalsamy@gmail.com',1,'fEVemr1vSzm7k_p5uC0OOK:APA91bGjOoKPQtxIVd6cA4j9O-LHRr0byj_xDTX3JuDoIM_QVmKwPC5p8O51Lt-6Yc6R3nndCXlDFp0jZg4sBb0yl5ZQvO7s0NomZaEaJYLtV8CfP7W6f6HpSJygw1phzHigJW-xzL0n',0,50,0,50,0,0,50,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-20 07:27:47','2023-12-21 13:59:22'),(12,'Priya Koki','YMZ551920TDE','priyakoki99@gmail.com',NULL,NULL,'google','priyakoki99@gmail.com',1,'eXhR8jR-RXKnkslaVR9Vab:APA91bElUb9gM5D5-TM5MC4G5vw7GQ_R3IE_7LZ5_UrXlM9EpXSNPaCSKyBfOsfPnBMgKif-AGQ42RTjEHrrAXiJRa1hJb7CJeT66oph4-jw9Q6XSOAKc71ovSTnp3SKykKmlR7iycu5',0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-20 07:39:06','2023-12-20 07:39:06'),(13,'Harun Matthew✨','harun_matthew','harunmatthewb@gmail.com',NULL,'1703265747scaled_image_picker2498681859627649332.jpg','google','harunmatthewb@gmail.com',1,'cy_lJ5fQQBmB90qsSkZyvG:APA91bHjPeszeBfNeEbMDGnBrMZBbLVS6HGMt1JytPIXPP6ZuWS_wgEiHu71XPk3AomP-d89OgUf5N7MJMGPUoFCaYyDAz-LFwSaxPAQtd0j5XvW9DUKuFdvjxsY5Y9pbefZoBMPYLaN',0,90,0,90,0,0,90,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-21 12:06:07','2024-01-20 10:48:22'),(14,'Barath Barath','PMT465551NTJ','barathash7785@gmail.com',NULL,NULL,'google','barathash7785@gmail.com',1,'c9E5PbhTT4qhGOZOkaXhwN:APA91bGVrX-nUG2ONvw_tupLq1BZgzqYNx1FJc7aMZ6R_nw0PtB2d82yycaHbb0m648chymEnzLQtZw-PC3v0MKobgykQ0bFyDRKNPQwWO8AFMYy1G2kAEJhn3hyayNuPc-T7GLI0TRm',0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-22 08:15:09','2023-12-22 08:15:09'),(15,'Madhan Madhan','HZG844439VYM','madhan7373485@gmail.com',NULL,NULL,'google','madhan7373485@gmail.com',1,'dLVc9i4JSfeBqtZdm-d5Ql:APA91bFzu8EjZWZIW77oWGhNFlAWaIqQUWGs-3C2ExesaWCHc_R8SvMaSdbdBxRKl_5rWflzPg1GZPATC4wKBx4O7PcGwLSFwPY9SJ4gOhWu2z0bAZGsUfZnnsaQTaWCyhx_V1CSrpXc',0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-22 11:37:33','2023-12-22 11:37:33'),(16,'Suji Dhina','FTH751429GTZ','dhinasuji0@gmail.com',NULL,NULL,'google','dhinasuji0@gmail.com',1,'e3TvdDnrQpShyiW-MftR0-:APA91bGpJtZhy6QTfKnE0OywJ8Ebx2hj7ZbeKRXTVJ50ooCZy53AULDWFsTtunu707BrIo7aXb7Ta8XHQaGMO5uCApsxeVXLoyx06BvCEhdbAcQYNKDsH54fJanSnFxsP6gpfEbfIG-j',0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2023-12-22 11:43:52','2023-12-22 11:43:53'),(17,'Dr.K.R. RAJA CHAIRMAN','SYN640296MCN','drkrrajachairman@gmail.com',NULL,NULL,'google','drkrrajachairman@gmail.com',1,'cpucQ8ciTmaVY2dEtTZUZC:APA91bFxGub40hpPu8XpgygEELABL2nXxdC8A5bul8obKnOF8MiFQ719bf9pXozJHUbxoCisHY4tnBDfX438cwUOnRM8AwiIfQ7GiR_rrd6Q360VaRpmU13htT0kDskapSSAxu2bZF86',0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2024-02-10 11:46:31','2024-02-10 11:46:31'),(18,'Ajithkumar techno','WYX688342CAG','ajithtechno1603@gmail.com',NULL,NULL,'google','ajithtechno1603@gmail.com',1,'dalnPf0GTXyGJ-8sjzcB1G:APA91bFkEkQB1eTMJL1aXOTUTnVQJNSj5gEptcxlBXYdhrKXfsJrD7U0Y7b4JneT6e-SQTd4kc43jDg50eJnvg-Z0SVu0Nfmorx1kEA_i-YMntqpt04O0CDMnv1wGj4G8Ko-ANukuKvZ',0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0,'Asia/Kolkata','2024-02-13 09:55:04','2024-02-13 09:55:05'); /*!40000 ALTER TABLE `tbl_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_verification_request` -- DROP TABLE IF EXISTS `tbl_verification_request`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_verification_request` ( `verification_request_id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `photo_id_image` text NOT NULL COMMENT 'add image', `photo_with_id_image` text NOT NULL COMMENT 'add image', `id_number` varchar(100) NOT NULL, `name` varchar(200) NOT NULL, `address` text NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`verification_request_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_verification_request` -- LOCK TABLES `tbl_verification_request` WRITE; /*!40000 ALTER TABLE `tbl_verification_request` DISABLE KEYS */; /*!40000 ALTER TABLE `tbl_verification_request` 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 2024-11-22 15:20:46
cải xoăn