Server : Apache/2.4.52 (Ubuntu) System : Linux srv913213 5.15.0-179-generic #189-Ubuntu SMP Tue May 5 18:20:56 UTC 2026 x86_64 User : www-data ( 33) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory : /var/www/
Upload File :
Current File : /var/www/yapcute.com.sql
-- 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
