/*
SQLyog Trial v13.1.8 (64 bit)
MySQL - 8.0.30 : Database - hitreels_backend
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`hitreels_backend` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `hitreels_backend`;

/*Table structure for table `adonis_schema` */

DROP TABLE IF EXISTS `adonis_schema`;

CREATE TABLE `adonis_schema` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `batch` int DEFAULT NULL,
  `migration_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `adonis_schema` */

/*Table structure for table `application_settings` */

DROP TABLE IF EXISTS `application_settings`;

CREATE TABLE `application_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `identifier` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_key` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_file` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `application_settings_identifier_index` (`identifier`),
  KEY `application_settings_meta_key_index` (`meta_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `application_settings` */

/*Table structure for table `audio` */

DROP TABLE IF EXISTS `audio`;

CREATE TABLE `audio` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `audio_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `track_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `track_artist` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `duration` float NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `audio_slug_unique` (`slug`),
  KEY `audio_user_slug_foreign` (`user_slug`),
  CONSTRAINT `audio_user_slug_foreign` FOREIGN KEY (`user_slug`) REFERENCES `users` (`slug`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `audio` */

insert  into `audio`(`id`,`user_slug`,`slug`,`audio_url`,`track_name`,`track_artist`,`created_at`,`updated_at`,`deleted_at`,`duration`) values 
(70,'john','y1nE16rgmxXGfudbNxz7vNUaocm54Zkn','https://hitreelsdatastorage.s3.amazonaws.com/XUjqSarBKmhEzHVpK1msDCF2P4scP5yr.mp3','Over_the_Horizon.mp3','unknown','2023-01-04 04:02:30','2023-01-04 04:02:30',NULL,184.487);

/*Table structure for table `cash_outs` */

DROP TABLE IF EXISTS `cash_outs`;

CREATE TABLE `cash_outs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` int unsigned DEFAULT NULL,
  `total_amount` int unsigned DEFAULT '0',
  `status` enum('pending','approved','disapproved') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cash_outs_slug_unique` (`slug`),
  KEY `cash_outs_user_slug_foreign` (`user_slug`),
  CONSTRAINT `cash_outs_user_slug_foreign` FOREIGN KEY (`user_slug`) REFERENCES `users` (`slug`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cash_outs` */

/*Table structure for table `chat_message_delete` */

DROP TABLE IF EXISTS `chat_message_delete`;

CREATE TABLE `chat_message_delete` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `chat_room_id` int DEFAULT '0',
  `chat_message_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `chat_message_delete` */

/*Table structure for table `chat_message_status` */

DROP TABLE IF EXISTS `chat_message_status`;

CREATE TABLE `chat_message_status` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `chat_room_id` int DEFAULT '0',
  `chat_message_id` int NOT NULL,
  `is_read` int NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=195 DEFAULT CHARSET=utf8mb3;

/*Data for the table `chat_message_status` */

insert  into `chat_message_status`(`id`,`user_id`,`chat_room_id`,`chat_message_id`,`is_read`,`created_at`,`updated_at`,`deleted_at`) values 
(171,97,39,130,1,'2023-01-04 04:23:59',NULL,NULL),
(172,98,39,130,1,'2023-01-04 04:23:59',NULL,NULL),
(173,97,39,131,1,'2023-01-04 04:24:34',NULL,NULL),
(174,98,39,131,1,'2023-01-04 04:24:34',NULL,NULL),
(175,97,39,132,1,'2023-01-04 04:24:38',NULL,NULL),
(176,98,39,132,1,'2023-01-04 04:24:38',NULL,NULL),
(177,97,39,133,1,'2023-01-04 04:24:44',NULL,NULL),
(178,98,39,133,1,'2023-01-04 04:24:44',NULL,NULL),
(179,97,39,134,1,'2023-01-04 04:25:15',NULL,NULL),
(180,98,39,134,1,'2023-01-04 04:25:15',NULL,NULL),
(181,97,39,135,1,'2023-01-04 04:32:35',NULL,NULL),
(182,98,39,135,1,'2023-01-04 04:32:35',NULL,NULL),
(183,97,39,136,1,'2023-01-04 04:33:04',NULL,NULL),
(184,98,39,136,1,'2023-01-04 04:33:04',NULL,NULL),
(188,97,39,140,0,'2023-01-04 10:22:38',NULL,NULL),
(189,98,39,140,1,'2023-01-04 10:22:38',NULL,NULL),
(190,97,39,141,0,'2023-01-04 10:23:42',NULL,NULL),
(191,98,39,141,1,'2023-01-04 10:23:42',NULL,NULL),
(192,98,37,142,0,'2023-01-06 02:26:31',NULL,NULL),
(193,98,37,143,0,'2023-01-06 02:26:57',NULL,NULL),
(194,98,37,144,0,'2023-01-06 02:27:34',NULL,NULL);

/*Table structure for table `chat_messages` */

DROP TABLE IF EXISTS `chat_messages`;

CREATE TABLE `chat_messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `chat_room_id` int NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `message_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
  `is_anonymous` tinyint NOT NULL DEFAULT '0',
  `ip_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `chat_messages` */

insert  into `chat_messages`(`id`,`user_id`,`chat_room_id`,`message`,`file_data`,`file_url`,`message_type`,`is_anonymous`,`ip_address`,`uuid`,`created_at`,`updated_at`,`deleted_at`) values 
(130,98,39,'hey',NULL,NULL,'text',0,NULL,NULL,'2023-01-04 04:23:59',NULL,NULL),
(131,97,39,'Hi',NULL,NULL,'text',0,NULL,NULL,'2023-01-04 04:24:34',NULL,NULL),
(132,97,39,'?',NULL,NULL,'text',0,NULL,NULL,'2023-01-04 04:24:37',NULL,NULL),
(133,97,39,'Image','{\"file_size\":191997,\"file_name\":\"6031449.jpg\"}','','file',0,NULL,NULL,'2023-01-04 04:24:44',NULL,NULL),
(134,97,39,'Image','{\"file_size\":5931771,\"file_name\":\"mixkit-people-pouring-a-warm-drink-around-a-campfire-513-medium.mp4\"}','https://hitreelsdatastorage.s3.amazonaws.com/eeSaXv0ojJU9cUA0niaNH08krsd337Lf.mp4','file',0,NULL,NULL,'2023-01-04 04:25:15',NULL,NULL),
(135,97,39,'Image','{\"file_size\":80850,\"file_name\":\"3d-illustration-cartoon-young-woman-wall-character_40876-3090.jpg\"}','','file',0,NULL,NULL,'2023-01-04 04:32:35',NULL,NULL),
(136,97,39,'Image','{\"file_size\":191997,\"file_name\":\"6031449.jpg\"}','','file',0,NULL,NULL,'2023-01-04 04:33:04',NULL,NULL),
(140,98,39,'Image','{\"file_size\":28483,\"file_name\":\"cat-animation.png\"}','https://hitreelsdatastorage.s3.amazonaws.com/X3hI2shN7NOtu4QnO8JKEyyOQL47CkBe.png','file',0,NULL,NULL,'2023-01-04 10:22:38',NULL,NULL),
(141,98,39,'Image','{\"file_size\":18693475,\"file_name\":\"mixkit-going-down-a-curved-highway-through-a-mountain-range-41576-medium.mp4\"}','https://hitreelsdatastorage.s3.amazonaws.com/8WSQClNVTgFyF8ZicIDwx1qnB25PwS7i.mp4','file',0,NULL,NULL,'2023-01-04 10:23:42',NULL,NULL),
(142,102,37,'test messg',NULL,NULL,'text',0,NULL,NULL,'2023-01-06 02:26:31',NULL,NULL),
(143,102,37,'test2',NULL,NULL,'text',0,NULL,NULL,'2023-01-06 02:26:57',NULL,NULL),
(144,102,37,'test 3',NULL,NULL,'text',0,NULL,NULL,'2023-01-06 02:27:34',NULL,NULL);

/*Table structure for table `chat_room_users` */

DROP TABLE IF EXISTS `chat_room_users`;

CREATE TABLE `chat_room_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `chat_room_id` int NOT NULL,
  `user_id` int NOT NULL,
  `is_owner` int NOT NULL DEFAULT '0',
  `is_accepted` tinyint NOT NULL DEFAULT '0',
  `last_chat_message_id` int NOT NULL DEFAULT '0',
  `last_message_timestamp` datetime DEFAULT NULL,
  `unread_message_counts` int NOT NULL DEFAULT '0',
  `is_anonymous` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb3;

/*Data for the table `chat_room_users` */

insert  into `chat_room_users`(`id`,`chat_room_id`,`user_id`,`is_owner`,`is_accepted`,`last_chat_message_id`,`last_message_timestamp`,`unread_message_counts`,`is_anonymous`,`created_at`,`updated_at`,`deleted_at`) values 
(42,37,98,1,0,144,'2023-01-06 02:27:34',3,0,'2023-01-04 04:20:58',NULL,NULL),
(44,39,97,0,1,141,'2023-01-04 10:23:42',2,0,'2023-01-04 04:23:59',NULL,NULL),
(45,39,98,1,1,141,'2023-01-04 10:23:42',0,0,'2023-01-04 04:23:59',NULL,NULL),
(46,40,101,1,0,0,'2023-01-04 10:18:31',0,0,'2023-01-04 10:18:31',NULL,NULL),
(47,41,98,1,0,0,'2023-01-04 10:24:12',0,0,'2023-01-04 10:24:12',NULL,NULL),
(48,42,102,1,0,0,'2023-01-06 02:17:36',0,0,'2023-01-06 02:17:36',NULL,NULL),
(49,43,102,1,0,0,'2023-01-06 02:19:15',0,0,'2023-01-06 02:19:15',NULL,NULL),
(50,44,102,1,0,0,'2023-01-06 02:20:39',0,0,'2023-01-06 02:20:39',NULL,NULL);

/*Table structure for table `chat_rooms` */

DROP TABLE IF EXISTS `chat_rooms`;

CREATE TABLE `chat_rooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `identifier` varchar(200) NOT NULL,
  `post_id` int NOT NULL,
  `created_by` int NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `image_url` text,
  `description` text,
  `status` int NOT NULL DEFAULT '1',
  `type` enum('single','group','room') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `member_limit` int DEFAULT NULL,
  `is_anonymous` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb3;

/*Data for the table `chat_rooms` */

insert  into `chat_rooms`(`id`,`identifier`,`post_id`,`created_by`,`title`,`slug`,`image_url`,`description`,`status`,`type`,`member_limit`,`is_anonymous`,`created_at`,`updated_at`,`deleted_at`) values 
(37,'title',0,98,'title','title','http://69.162.81.82:5191//images/user-placeholder.jpg','galaxy',1,'room',NULL,0,'2023-01-04 04:20:58',NULL,NULL),
(39,'single-1672806239-1672806239',0,98,'single-1672806239','single-1672806239','https://static.turbosquid.com/Preview/001292/481/WV/_D.jpg',NULL,1,'single',NULL,0,'2023-01-04 04:23:59',NULL,NULL),
(40,'title',0,101,'title','title','https://lh3.googleusercontent.com/a/AEdFTp4TiaXwjuTtLRojTLBx_yOh-nWcLsq9VLWTTuSVmA=s96-c','stars',1,'room',NULL,0,'2023-01-04 10:18:31',NULL,NULL),
(41,'title',0,98,'title','title','https://hitreelsdatastorage.s3.amazonaws.com/1FQT5PiYRGJBrdeWEcP1ynuxDal1fzgj.png','forest',1,'room',NULL,0,'2023-01-04 10:24:12',NULL,NULL),
(42,'title',0,102,'title','title','https://lh3.googleusercontent.com/a/AEdFTp60EVazuwmHOIPJp9BG60fh_BafV9pZyadgNqQu=s96-c','test1',1,'room',NULL,0,'2023-01-06 02:17:36',NULL,NULL),
(43,'title',0,102,'title','title','https://lh3.googleusercontent.com/a/AEdFTp60EVazuwmHOIPJp9BG60fh_BafV9pZyadgNqQu=s96-c','test',1,'room',NULL,0,'2023-01-06 02:19:15',NULL,NULL),
(44,'title',0,102,'title','title','https://lh3.googleusercontent.com/a/AEdFTp60EVazuwmHOIPJp9BG60fh_BafV9pZyadgNqQu=s96-c','test 2',1,'room',NULL,0,'2023-01-06 02:20:39',NULL,NULL);

/*Table structure for table `cms_module_permissions` */

DROP TABLE IF EXISTS `cms_module_permissions`;

CREATE TABLE `cms_module_permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_group_id` int unsigned DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `cms_module_id` int unsigned DEFAULT NULL,
  `is_add` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `is_view` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `is_update` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `is_delete` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_module_permissions_user_group_id_foreign` (`user_group_id`),
  KEY `cms_module_permissions_user_id_foreign` (`user_id`),
  KEY `cms_module_permissions_cms_module_id_foreign` (`cms_module_id`),
  CONSTRAINT `cms_module_permissions_cms_module_id_foreign` FOREIGN KEY (`cms_module_id`) REFERENCES `cms_modules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cms_module_permissions_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cms_module_permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cms_module_permissions` */

/*Table structure for table `cms_modules` */

DROP TABLE IF EXISTS `cms_modules`;

CREATE TABLE `cms_modules` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int DEFAULT '0',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `route_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `sort_order` decimal(8,2) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `cms_modules` */

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

/*Table structure for table `constants` */

DROP TABLE IF EXISTS `constants`;

CREATE TABLE `constants` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `cash_per_view` int unsigned DEFAULT NULL,
  `exchange_rate` int unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `constants` */

insert  into `constants`(`id`,`cash_per_view`,`exchange_rate`,`created_at`,`updated_at`,`deleted_at`) values 
(1,5,5,'2022-11-01 13:25:50','2022-12-27 07:29:05',NULL);

/*Table structure for table `content_managements` */

DROP TABLE IF EXISTS `content_managements`;

CREATE TABLE `content_managements` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `content_managements_slug_unique` (`slug`),
  KEY `content_managements_slug_index` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `content_managements` */

/*Table structure for table `faqs` */

DROP TABLE IF EXISTS `faqs`;

CREATE TABLE `faqs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `faqs_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `faqs` */

insert  into `faqs`(`id`,`slug`,`question`,`answer`,`created_at`,`updated_at`,`deleted_at`) values 
(16,'wTbaddvYrE79VAB0Wr6cPUINex7TlOr6','Hello world','this is hitreels app','2023-01-04 04:43:41','2023-01-04 04:43:41',NULL);

/*Table structure for table `follows` */

DROP TABLE IF EXISTS `follows`;

CREATE TABLE `follows` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `followed_to` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `followed_by` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `follows_slug_unique` (`slug`),
  KEY `follows_followed_to_foreign` (`followed_to`),
  KEY `follows_followed_by_foreign` (`followed_by`),
  CONSTRAINT `follows_followed_by_foreign` FOREIGN KEY (`followed_by`) REFERENCES `users` (`slug`) ON DELETE CASCADE,
  CONSTRAINT `follows_followed_to_foreign` FOREIGN KEY (`followed_to`) REFERENCES `users` (`slug`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `follows` */

insert  into `follows`(`id`,`followed_to`,`followed_by`,`slug`,`created_at`,`updated_at`,`deleted_at`) values 
(209,'jim','john','NEQW4GqKpOIGeAJlV05BOM1FR0L6GWMY','2023-01-04 04:40:12','2023-01-04 04:40:12',NULL),
(210,'john','jim','EiMsP2YEzqQpO5IA5490KPJca4g81GYt','2023-01-04 04:41:45','2023-01-04 04:41:45',NULL);

/*Table structure for table `like_videos` */

DROP TABLE IF EXISTS `like_videos`;

CREATE TABLE `like_videos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `liked_by` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `like_videos_slug_unique` (`slug`),
  KEY `like_videos_liked_by_foreign` (`liked_by`),
  KEY `like_videos_post_slug_foreign` (`post_slug`),
  CONSTRAINT `like_videos_liked_by_foreign` FOREIGN KEY (`liked_by`) REFERENCES `users` (`slug`) ON DELETE CASCADE,
  CONSTRAINT `like_videos_post_slug_foreign` FOREIGN KEY (`post_slug`) REFERENCES `posts` (`slug`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=878 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `like_videos` */

insert  into `like_videos`(`id`,`liked_by`,`post_slug`,`slug`,`created_at`,`updated_at`,`deleted_at`) values 
(876,'john','jHUgWJH09lOE1meXUKxggQnZIgC6XMKe','JxHPU7D5kPFoXdlDtVzHhGS6V4W5sWdi','2023-01-04 04:40:36','2023-01-04 04:40:36',NULL),
(877,'tyler-mccarter','jHUgWJH09lOE1meXUKxggQnZIgC6XMKe','tSiKIcVRLf751izmSD2akyD95N6CSDec','2023-01-06 02:26:18','2023-01-06 02:26:18',NULL);

/*Table structure for table `mail_templates` */

DROP TABLE IF EXISTS `mail_templates`;

CREATE TABLE `mail_templates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `identifier` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `wildcard` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `mail_templates` */

/*Table structure for table `media` */

DROP TABLE IF EXISTS `media`;

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

/*Data for the table `media` */

/*Table structure for table `notification_settings` */

DROP TABLE IF EXISTS `notification_settings`;

CREATE TABLE `notification_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `meta_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_settings_user_id_foreign` (`user_id`),
  KEY `notification_settings_meta_key_index` (`meta_key`),
  CONSTRAINT `notification_settings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `notification_settings` */

/*Table structure for table `notifications` */

DROP TABLE IF EXISTS `notifications`;

CREATE TABLE `notifications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `actor_id` int unsigned DEFAULT NULL,
  `target_id` int unsigned DEFAULT NULL,
  `module` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int NOT NULL,
  `module_slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_id` int DEFAULT NULL,
  `reference_slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `web_redirect_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_read` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_view` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notifications_unique_id_unique` (`unique_id`),
  KEY `notifications_actor_id_foreign` (`actor_id`),
  KEY `notifications_target_id_foreign` (`target_id`),
  CONSTRAINT `notifications_actor_id_foreign` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notifications_target_id_foreign` FOREIGN KEY (`target_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `notifications` */

/*Table structure for table `packages` */

DROP TABLE IF EXISTS `packages`;

CREATE TABLE `packages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `packageID` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` float unsigned NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_column` (`packageID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `packages` */

insert  into `packages`(`id`,`packageID`,`price`,`description`,`title`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'com.subscription.monthly',8.99,'No Add;Cash Your Coins',1,'2022-12-13 18:14:50','2022-12-13 18:14:50',NULL),
(2,'com.subscription.halfyearly',18.99,'No Add;Cash Your Coins',6,'2022-12-13 18:15:06','2022-12-13 18:15:06',NULL),
(3,'com.subscription.yearly',28.99,'No Add;Cash Your Coins',12,'2022-12-13 18:15:21','2022-12-13 18:15:21',NULL);

/*Table structure for table `posts` */

DROP TABLE IF EXISTS `posts`;

CREATE TABLE `posts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `isPrivate` tinyint(1) NOT NULL,
  `views` int unsigned DEFAULT '0',
  `room_id` int unsigned DEFAULT '0',
  `share_count` int unsigned DEFAULT '0',
  `video_url` text COLLATE utf8mb4_unicode_ci,
  `thumbnail_url` text COLLATE utf8mb4_unicode_ci,
  `likes` int unsigned NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `post_url` text COLLATE utf8mb4_unicode_ci,
  `audio_track_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audio_track_artist` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audio_url` text COLLATE utf8mb4_unicode_ci,
  `comments` int unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `posts_slug_unique` (`slug`),
  KEY `posts_user_slug_foreign` (`user_slug`),
  CONSTRAINT `posts_user_slug_foreign` FOREIGN KEY (`user_slug`) REFERENCES `users` (`slug`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=300 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `posts` */

insert  into `posts`(`id`,`user_slug`,`slug`,`description`,`isPrivate`,`views`,`room_id`,`share_count`,`video_url`,`thumbnail_url`,`likes`,`created_at`,`updated_at`,`deleted_at`,`post_url`,`audio_track_name`,`audio_track_artist`,`audio_url`,`comments`) values 
(296,'jim','jHUgWJH09lOE1meXUKxggQnZIgC6XMKe','#galaxy',0,8,37,2,'https://hitreelsdatastorage.s3.amazonaws.com/jzeTXpvkJSmlXmFs5vq0NjHhVSoQlIFb.mp4','https://hitreelsdatastorage.s3.amazonaws.com/fvJxnkFXbSelCyMu41j2VHplI3hQYu12.png',2,'2023-01-04 04:21:08','2023-01-04 04:22:19',NULL,NULL,NULL,NULL,NULL,6),
(298,'jack-turner','efO06JnN3pw0xIIo4ROq2kQetngq2D0i','stars',0,1,40,0,'https://hitreelsdatastorage.s3.amazonaws.com/odZR7CcV4EYbEtc0HQIsFtfVVm73Jfuf.mp4','https://hitreelsdatastorage.s3.amazonaws.com/WJnucJe7kNWWIWvkHapHvP1zFoBuWUDS.png',0,'2023-01-04 10:19:34','2023-01-04 10:19:34',NULL,NULL,NULL,NULL,NULL,0),
(299,'jim','fQVBphY2SMRnQnKxzWrhiAKZrtjqGd1T','forest',0,1,41,0,'https://hitreelsdatastorage.s3.amazonaws.com/Px6qVjfNupXvzIPKqfsQJMRuDDeR1PWa.mp4','https://hitreelsdatastorage.s3.amazonaws.com/yIFmWB4GPzwp4zrDXlx8G5FmHrspGp2C.png',0,'2023-01-04 10:24:20','2023-01-04 10:24:20',NULL,NULL,NULL,NULL,NULL,0);

/*Table structure for table `report_users` */

DROP TABLE IF EXISTS `report_users`;

CREATE TABLE `report_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_user_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comments` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('unblock','block') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unblock',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_users_slug_unique` (`slug`),
  KEY `report_users_user_slug_foreign` (`user_slug`),
  KEY `report_users_target_user_slug_foreign` (`target_user_slug`),
  CONSTRAINT `report_users_target_user_slug_foreign` FOREIGN KEY (`target_user_slug`) REFERENCES `users` (`slug`) ON DELETE CASCADE,
  CONSTRAINT `report_users_user_slug_foreign` FOREIGN KEY (`user_slug`) REFERENCES `users` (`slug`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `report_users` */

/*Table structure for table `reset_passwords` */

DROP TABLE IF EXISTS `reset_passwords`;

CREATE TABLE `reset_passwords` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reset_passwords_email_index` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `reset_passwords` */

insert  into `reset_passwords`(`id`,`email`,`token`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'anasakhtar365@gmail.com','24%7C1662395838645','2022-09-05 16:37:19',NULL,NULL),
(2,'anasakhtar365@gmail.com','24%7C1662395873938','2022-09-05 16:37:54',NULL,NULL),
(3,'anasakhtar365@gmail.com','24%7C1662395909954','2022-09-05 16:38:30',NULL,NULL),
(4,'anasakhtar365@gmail.com','24%7C1662395985049','2022-09-05 16:39:45',NULL,NULL),
(5,'anasakhtar365@gmail.com','24%7C1662397373547','2022-09-05 17:02:54',NULL,NULL),
(6,'anasakhtar365@gmail.com','24%7C1662397555330','2022-09-05 17:05:55',NULL,NULL),
(7,'anasakhtar365@gmail.com','24%7C1662399074866','2022-09-05 17:31:15',NULL,NULL),
(8,'anasakhtar365@gmail.com','24%7C1662399210373','2022-09-05 17:33:30',NULL,NULL),
(9,'anasakhtar365@gmail.com','24%7C1662402286498','2022-09-05 18:24:46',NULL,NULL),
(10,'anasakhtar365@gmail.com','26%7C1662448458787','2022-09-06 07:14:19',NULL,NULL),
(11,'aaa@yopmail.com','30%7C1662450356376','2022-09-06 07:45:56',NULL,NULL),
(12,'aaa@yopmail.com','30%7C1662450389537','2022-09-06 07:46:30',NULL,NULL),
(13,'aaa@yopmail.com','30%7C1662450442816','2022-09-06 07:47:23',NULL,NULL),
(14,'aaa@yopmail.com','30%7C1662450450586','2022-09-06 07:47:31',NULL,NULL),
(15,'tester123@retrocube.com','32%7C1662465727249','2022-09-06 12:02:07',NULL,NULL),
(16,'muhammad.faisal@abtach.org','33%7C1662465755161','2022-09-06 12:02:35',NULL,NULL),
(17,'faraz.ahmed@retrocube.org','9%7C1662467281851','2022-09-06 12:28:02',NULL,NULL),
(18,'ocute30@gmail.com','9%7C1662467499265','2022-09-06 12:31:39',NULL,NULL),
(19,'faraz.ahmed@retrocube.org','9%7C1662467868111','2022-09-06 12:37:48',NULL,NULL),
(20,'anasakhtar365@gmail.com','26%7C1662489893530','2022-09-06 18:44:54',NULL,NULL),
(21,'faraz.ahmed@retrocube.org','9%7C1662535769201','2022-09-07 07:29:29',NULL,NULL),
(22,'faraz.ahmed@retrocube.org','9%7C1662537569174','2022-09-07 07:59:29',NULL,NULL),
(23,'faraz.ahmed@retrocube.org','9%7C1662537616073','2022-09-07 08:00:16',NULL,NULL),
(24,'faraz.ahmed@retrocube.org','9%7C1662537855603','2022-09-07 08:04:16',NULL,NULL),
(25,'faraz.ahmed@retrocube.org','9%7C1662538015587','2022-09-07 08:06:56',NULL,NULL),
(26,'faraz.ahmed@retrocube.org','9%7C1662538247260','2022-09-07 08:10:47',NULL,NULL),
(27,'faraz.ahmed@retrocube.org','9%7C1662538350496','2022-09-07 08:12:30',NULL,NULL),
(28,'abc@yopmail.com','35%7C1662539980314','2022-09-07 08:39:40',NULL,NULL),
(29,'anasakhtar365@gmail.com','26%7C1662577198985','2022-09-07 18:59:59',NULL,NULL),
(30,'anasakhtar365@gmail.com','26%7C1662578072824','2022-09-07 19:14:33',NULL,NULL),
(31,'anasakhtar365@gmail.com','26%7C1663182284416','2022-09-14 19:04:44',NULL,NULL),
(32,'test1@yopmail.com','63%7C1664183496063','2022-09-26 09:11:36',NULL,NULL),
(33,'test1@yopmail.com','3%7C1664352062583','2022-09-28 08:01:03',NULL,NULL),
(34,'anasakhtar1337@gmail.com','36%7C1666637385078','2022-10-24 18:49:45',NULL,NULL),
(35,'juhijain110@gmail.com','43%7C1667168222810','2022-10-30 22:17:03',NULL,NULL),
(36,'taylor@yopmail.com','37%7C1667220897038','2022-10-31 12:54:57',NULL,NULL),
(37,'test1@yopmail.com','3%7C1667221164402','2022-10-31 12:59:24',NULL,NULL),
(39,'anasakhtar1337@gmail.com','36%7C1667374638870','2022-11-02 07:37:19',NULL,NULL),
(52,'admin@retrocube.com','1%7C1668943663068','2022-11-20 11:27:43',NULL,NULL),
(55,'admin@retrocube.com','1%7C1671882235165','2022-12-24 11:43:55',NULL,NULL),
(56,'admin@retrocube.com','1%7C1672759552990','2023-01-03 15:25:53',NULL,NULL),
(57,'admin@retrocube.com','1%7C1672760821765','2023-01-03 15:47:02',NULL,NULL);

/*Table structure for table `save_videos` */

DROP TABLE IF EXISTS `save_videos`;

CREATE TABLE `save_videos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `saved_by` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `save_videos_slug_unique` (`slug`),
  KEY `save_videos_saved_by_foreign` (`saved_by`),
  KEY `save_videos_post_slug_foreign` (`post_slug`),
  CONSTRAINT `save_videos_post_slug_foreign` FOREIGN KEY (`post_slug`) REFERENCES `posts` (`slug`) ON DELETE CASCADE,
  CONSTRAINT `save_videos_saved_by_foreign` FOREIGN KEY (`saved_by`) REFERENCES `users` (`slug`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=381 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `save_videos` */

/*Table structure for table `static_texts` */

DROP TABLE IF EXISTS `static_texts`;

CREATE TABLE `static_texts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `terms` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `privacy` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `static_texts` */

insert  into `static_texts`(`id`,`slug`,`terms`,`privacy`,`created_at`,`updated_at`,`deleted_at`) values 
(1,'','Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, and res test','It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now\n',NULL,'2022-12-28 15:13:52',NULL);

/*Table structure for table `subscriptions` */

DROP TABLE IF EXISTS `subscriptions`;

CREATE TABLE `subscriptions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `packageID` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isCancel` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `start_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `end_date` timestamp NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `subscriptions_user_slug_foreign` (`user_slug`),
  CONSTRAINT `subscriptions_user_slug_foreign` FOREIGN KEY (`user_slug`) REFERENCES `users` (`slug`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `subscriptions` */

insert  into `subscriptions`(`id`,`slug`,`user_slug`,`packageID`,`isCancel`,`start_date`,`end_date`,`created_at`,`updated_at`,`deleted_at`) values 
(15,'fjNafPvgyl0m1MjXAUfgn8p2mHwuOVDb','anas','com.subscription.monthly','1','2023-01-04 12:09:00','2023-02-04 12:09:00','2023-01-04 12:09:07','2023-01-04 12:09:18',NULL),
(16,'sacDRP9v3aCJyRcjxRwcXIqeVo5IVNDD','anas','com.subscription.yearly','1','2023-01-04 12:09:00','2024-01-04 12:09:00','2023-01-04 12:09:18','2023-01-04 12:09:41',NULL),
(17,'sKwsnEhcdjXZ2mNfDURt5uwLAScZNUSp','anas','com.subscription.monthly','1','2023-01-04 12:09:00','2023-02-04 12:09:00','2023-01-04 12:09:48','2023-01-04 12:09:55',NULL),
(18,'OETAV3zxFv8t6pzfkOCiYmKI7sJPSjRM','anas','com.subscription.monthly','1','2023-01-05 05:34:00','2023-02-05 05:34:00','2023-01-05 05:34:26','2023-01-05 05:34:33',NULL),
(19,'2CG2ArXMDqpr5cUdclWC73IX3bYlKmIx','anas','com.subscription.monthly','1','2023-01-05 05:34:00','2023-02-05 05:34:00','2023-01-05 05:34:41','2023-01-05 05:34:51',NULL),
(20,'nTDBOCYMAxlJMGDWlmoczFlcH8RIESHz','anas','com.subscription.yearly','0','2023-01-05 05:34:00','2024-01-05 05:34:00','2023-01-05 05:34:51','2023-01-05 05:34:51',NULL);

/*Table structure for table `trendings` */

DROP TABLE IF EXISTS `trendings`;

CREATE TABLE `trendings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tags` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `trendings` */

insert  into `trendings`(`id`,`tags`) values 
(1,'#galaxy');

/*Table structure for table `user_api_tokens` */

DROP TABLE IF EXISTS `user_api_tokens`;

CREATE TABLE `user_api_tokens` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `api_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `device_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `platform_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `platform_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_api_tokens_user_id_foreign` (`user_id`),
  CONSTRAINT `user_api_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2452 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `user_api_tokens` */

insert  into `user_api_tokens`(`id`,`user_id`,`api_token`,`device_type`,`device_token`,`platform_type`,`platform_id`,`ip_address`,`user_agent`,`created_at`,`updated_at`,`deleted_at`) values 
(2405,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI2NzM5NzIsImV4cCI6MTY3MzI3ODc3MiwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.kEfiVv0Eg5IeKK509KBSGCxPZF65dqHE1V2_EoV32GY',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-02 15:39:33',NULL,NULL),
(2406,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI2NzQwMzAsImV4cCI6MTY3MzI3ODgzMCwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.NymaWNT7TEeDRMKklGolwapgt8k68Baad7uVxskka5U',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-02 15:40:30',NULL,NULL),
(2407,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI2NzgyNTEsImV4cCI6MTY3MzI4MzA1MSwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.5sBEm8zqIejHS5i-4FftRIXbdPLreGSOTC_umg953TY',NULL,NULL,'custom',NULL,'36.255.44.118','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-02 16:50:52',NULL,NULL),
(2408,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI2NzgyNjgsImV4cCI6MTY3MzI4MzA2OCwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.vkj-0d89Xkp5avk7BsI8UKe183AsCHZj3RnTCZsSBT0',NULL,NULL,'custom',NULL,'36.255.44.118','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-02 16:51:09',NULL,NULL),
(2409,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI2Nzg4OTIsImV4cCI6MTY3MzI4MzY5MiwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.ytoXSD1PWIUBh7wl3I0VfLOTSTWzHYFwofES4274ToU',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-02 17:01:32',NULL,NULL),
(2410,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI3NTk1NjMsImV4cCI6MTY3MzM2NDM2MywiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.Jy001o8RJeN4Gvs55VDEzeWC84iglzcsBcAPpJRf10k',NULL,NULL,'custom',NULL,'39.50.142.206','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-03 15:26:03',NULL,NULL),
(2411,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI3NjA4MzUsImV4cCI6MTY3MzM2NTYzNSwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.S_nOPRTnHLsaIm29gUQjA2-S7e0-fgdbWevIvPO5o8g',NULL,NULL,'custom',NULL,'39.50.142.206','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-03 15:47:15',NULL,NULL),
(2412,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4MDQ2NjIsImV4cCI6MTY3MzQwOTQ2MiwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.MJ2PwT0tZ1fzSzhiJo_vsL2NrW8wm-O27eLKGCL3Dy0',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-04 03:57:43',NULL,NULL),
(2415,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4MDQ5ODQsImV4cCI6MTY3MzQwOTc4NCwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.ls97CBkoKGViNPDzlooveUCSfRskO0jLqZZzNxfaw-c',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-04 04:03:04',NULL,NULL),
(2420,99,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFiY0B5b3BtYWlsLmNvbSIsImlhdCI6MTY3MjgwNjkwNywiZXhwIjoxNjczNDExNzA3LCJpc3MiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsInN1YiI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwianRpIjoiYWJjQHlvcG1haWwuY29tIn0.Wti7MxkJXqUt58PsXFMZW1Np5oT4oRN2uvK3pXTmD2I','android','1234567890xyz','custom',NULL,'103.86.55.218','PostmanRuntime/7.30.0','2023-01-04 04:35:08',NULL,NULL),
(2423,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4MDc0NjYsImV4cCI6MTY3MzQxMjI2NiwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.iRtU6R1tz1e5zzvDRyqEHIgG6d935eQ364te925WCnk',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-04 04:44:27',NULL,NULL),
(2425,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4MjE2NzYsImV4cCI6MTY3MzQyNjQ3NiwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.VGIGfzprfItk2EL-y8tIi-Ixp6ycJ2fihoyrJ1eW4OU',NULL,NULL,'custom',NULL,'39.50.128.164','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-04 08:41:17',NULL,NULL),
(2426,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4MjI4MTQsImV4cCI6MTY3MzQyNzYxNCwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.ui0gJx-tgmkfzDu6gmd5htoKrLvOqtNG5S1ID9bDq3Y',NULL,NULL,'custom',NULL,'39.50.128.164','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-04 09:00:15',NULL,NULL),
(2427,100,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFuYXNha2h0YXIxMzM3QGdtYWlsLmNvbSIsImlhdCI6MTY3MjgyNjQ0MywiZXhwIjoxNjczNDMxMjQzLCJpc3MiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsInN1YiI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwianRpIjoiYW5hc2FraHRhcjEzMzdAZ21haWwuY29tIn0.0dKiu06KyM4QA9p9v_sN7GFuJUg2aaYqcCpmdlOpIv8','android','1234567890','google','1234567890','39.50.182.129','PostmanRuntime/7.30.0','2023-01-04 10:00:44',NULL,NULL),
(2428,100,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFuYXNha2h0YXIxMzM3QGdtYWlsLmNvbSIsImlhdCI6MTY3MjgyNjQ1NSwiZXhwIjoxNjczNDMxMjU1LCJpc3MiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsInN1YiI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwianRpIjoiYW5hc2FraHRhcjEzMzdAZ21haWwuY29tIn0.pVgSlhsR9u4mfB0MtEjKJ5csLyxdTzvScl5BujIHO1k','android','12345678901','google','1234567890','39.50.182.129','PostmanRuntime/7.30.0','2023-01-04 10:00:55',NULL,NULL),
(2429,100,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFuYXNha2h0YXIxMzM3QGdtYWlsLmNvbSIsImlhdCI6MTY3MjgyNjQ1OSwiZXhwIjoxNjczNDMxMjU5LCJpc3MiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsInN1YiI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwianRpIjoiYW5hc2FraHRhcjEzMzdAZ21haWwuY29tIn0.2b5SM1axxjaiZUtYeDE4EoU8FvKoL1pRDRIL_XZv-OA','android','12345678901','google','12345678901','39.50.182.129','PostmanRuntime/7.30.0','2023-01-04 10:00:59',NULL,NULL),
(2430,100,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFuYXNha2h0YXIxMzM3QGdtYWlsLmNvbSIsImlhdCI6MTY3MjgyNjQ2MiwiZXhwIjoxNjczNDMxMjYyLCJpc3MiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsInN1YiI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwianRpIjoiYW5hc2FraHRhcjEzMzdAZ21haWwuY29tIn0.jDjLyus0mJ76YkFquJ46M-qNfQ76k2PB_a1SQkk4sNE','android','123456789012','google','123456789012','39.50.182.129','PostmanRuntime/7.30.0','2023-01-04 10:01:03',NULL,NULL),
(2431,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4MjY0ODQsImV4cCI6MTY3MzQzMTI4NCwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.F8G0G7Bz995FlyfRk90ZYggCrDMRPDVB-vWekUVyl6E',NULL,NULL,'custom',NULL,'39.50.182.129','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-04 10:01:25',NULL,NULL),
(2432,100,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFuYXNha2h0YXIxMzM3QGdtYWlsLmNvbSIsImlhdCI6MTY3MjgyNjUwMywiZXhwIjoxNjczNDMxMzAzLCJpc3MiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsInN1YiI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwianRpIjoiYW5hc2FraHRhcjEzMzdAZ21haWwuY29tIn0.AEnzfSp8zqlcImu2ol2gEoxNY8ubqDSwO7vgvKFYzyk','android','123456789012','google','123456789012','39.50.182.129','PostmanRuntime/7.30.0','2023-01-04 10:01:43',NULL,NULL),
(2437,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4Mjc1MjUsImV4cCI6MTY3MzQzMjMyNSwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.I2Qy39kes4HHwveofwpncedTG1sAW4OYxf00-amMfeg',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-04 10:18:46',NULL,NULL),
(2439,100,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFuYXNha2h0YXIxMzM3QGdtYWlsLmNvbSIsImlhdCI6MTY3MjgzNDEzMCwiZXhwIjoxNjczNDM4OTMwLCJpc3MiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsInN1YiI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwianRpIjoiYW5hc2FraHRhcjEzMzdAZ21haWwuY29tIn0.y84bgPg9dZiRK5-ILzM7ptzyYjBtbpvVCY5aWoHgAZM','android','123456789012','google','123456789012','39.50.182.129','PostmanRuntime/7.30.0','2023-01-04 12:08:50',NULL,NULL),
(2440,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4MzkzMTMsImV4cCI6MTY3MzQ0NDExMywiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.Qe2CrH00Vca2zOF3LPQNiMMwqD_o_IQ9H48i4RGuQoo',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:108.0) Gecko/20100101 Firefox/108.0','2023-01-04 13:35:13',NULL,NULL),
(2441,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4NDQzODIsImV4cCI6MTY3MzQ0OTE4MiwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.8MqbLCU1JZoUhOrKu2Jrm37LxXUwUE0fHyftYLuPlz4',NULL,NULL,'custom',NULL,'39.50.182.129','PostmanRuntime/7.30.0','2023-01-04 14:59:43',NULL,NULL),
(2442,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI4NTA4ODgsImV4cCI6MTY3MzQ1NTY4OCwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.hg5UEoHZamhl0ATG1OvNV3S1PAgK2wgbnSoZLDsFNhU',NULL,NULL,'custom',NULL,'39.50.182.129','PostmanRuntime/7.30.0','2023-01-04 16:48:09',NULL,NULL),
(2443,101,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6InRlc3RlcjIwMTkwMDFAZ21haWwuY29tIiwiaWF0IjoxNjcyOTA1NzczLCJleHAiOjE2NzM1MTA1NzMsImlzcyI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwic3ViIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJqdGkiOiJ0ZXN0ZXIyMDE5MDAxQGdtYWlsLmNvbSJ9._j6hhZN1qUkuDYU1G5JHtEHhQBZ9bT0LteqyzNneBQ8','android','1234567890','google','102998899681570649958','103.86.55.218','Dart/2.18 (dart:io)','2023-01-05 08:02:53',NULL,NULL),
(2447,102,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6InR5bGVyLm1jY2FydGVyQHJldHJvY3ViZWxsYy5jb20iLCJpYXQiOjE2NzI5NDQ5NzAsImV4cCI6MTY3MzU0OTc3MCwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6InR5bGVyLm1jY2FydGVyQHJldHJvY3ViZWxsYy5jb20ifQ.-XlaJ86KJQCQWfPSLoe58WiApxdeMK6W474dQElsgiI','android','1234567890','google','118017197090542491517','103.86.55.218','Dart/2.18 (dart:io)','2023-01-05 18:56:10',NULL,NULL),
(2448,102,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6InR5bGVyLm1jY2FydGVyQHJldHJvY3ViZWxsYy5jb20iLCJpYXQiOjE2NzI5NDUwNTcsImV4cCI6MTY3MzU0OTg1NywiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6InR5bGVyLm1jY2FydGVyQHJldHJvY3ViZWxsYy5jb20ifQ.YEK2PHBA6Q7Kaamf4zxJ9ooDXx_Tg2n141blLLJ5nkw','android','1234567890','custom',NULL,'103.86.55.218','Dart/2.18 (dart:io)','2023-01-05 18:57:38',NULL,NULL),
(2449,102,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6InR5bGVyLm1jY2FydGVyQHJldHJvY3ViZWxsYy5jb20iLCJpYXQiOjE2NzI5NzEwNTUsImV4cCI6MTY3MzU3NTg1NSwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6InR5bGVyLm1jY2FydGVyQHJldHJvY3ViZWxsYy5jb20ifQ.UIlCT5A7M0HPYsM8i6TKh67vF_9Gja5UgB0jEQZjVs8','ios','1234567890','custom',NULL,'108.53.161.72','Dart/2.18 (dart:io)','2023-01-06 02:10:55',NULL,NULL),
(2450,1,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImFkbWluQHJldHJvY3ViZS5jb20iLCJpYXQiOjE2NzI5OTIxNjIsImV4cCI6MTY3MzU5Njk2MiwiaXNzIjoiNTkyMDA3NDgtMzZmYy0yNzQ0LTM1NS04YzEyODFmN2ZjZDIiLCJzdWIiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsImp0aSI6ImFkbWluQHJldHJvY3ViZS5jb20ifQ.ZhZ6G9-O0ujo61p9vn-y65NMKp5QjT8NudK7wttuqzQ',NULL,NULL,'custom',NULL,'103.86.55.218','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','2023-01-06 08:02:43',NULL,NULL),
(2451,98,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6ImppbUB5b3BtYWlsLmNvbSIsImlhdCI6MTY3Mjk5MjQwMSwiZXhwIjoxNjczNTk3MjAxLCJpc3MiOiI1OTIwMDc0OC0zNmZjLTI3NDQtMzU1LThjMTI4MWY3ZmNkMiIsInN1YiI6IjU5MjAwNzQ4LTM2ZmMtMjc0NC0zNTUtOGMxMjgxZjdmY2QyIiwianRpIjoiamltQHlvcG1haWwuY29tIn0.eZ350tc8SME9WOskRpAqBHqXYDRfr0ugzIGe_-DKhA4','android','1234567890','custom',NULL,'103.86.55.218','Dart/2.18 (dart:io)','2023-01-06 08:06:41',NULL,NULL);

/*Table structure for table `user_groups` */

DROP TABLE IF EXISTS `user_groups`;

CREATE TABLE `user_groups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('admin','user') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
  `is_super_admin` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_groups_title_unique` (`title`),
  UNIQUE KEY `user_groups_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `user_groups` */

insert  into `user_groups`(`id`,`title`,`slug`,`description`,`type`,`is_super_admin`,`status`,`created_at`,`updated_at`,`deleted_at`) values 
(3,'Super Admin','super-admin',NULL,'admin','1','1','2022-07-08 10:55:25',NULL,NULL),
(4,'App User','app-user',NULL,'user','0','1','2022-07-08 10:55:25',NULL,NULL);

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_group_id` int unsigned DEFAULT NULL,
  `user_type` enum('admin','user') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `interest` text COLLATE utf8mb4_unicode_ci,
  `bio` text COLLATE utf8mb4_unicode_ci,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `blur_image` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_width` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_height` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `is_email_verify` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `email_verify_at` timestamp NULL DEFAULT NULL,
  `is_mobile_verify` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `mobile_verify_at` timestamp NULL DEFAULT NULL,
  `is_guest` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `about_us` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dob` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zipcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fcm_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_access` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `online_status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `mobile_otp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_otp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `followers` int unsigned NOT NULL DEFAULT '0',
  `followings` int unsigned NOT NULL DEFAULT '0',
  `videos` int unsigned NOT NULL DEFAULT '0',
  `coins` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_slug_unique` (`slug`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_mobile_no_unique` (`mobile_no`),
  KEY `users_user_group_id_foreign` (`user_group_id`),
  KEY `users_name_index` (`name`),
  CONSTRAINT `users_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `users` */

insert  into `users`(`id`,`user_group_id`,`user_type`,`name`,`username`,`slug`,`interest`,`bio`,`email`,`mobile_no`,`password`,`image_url`,`blur_image`,`image_width`,`image_height`,`status`,`is_email_verify`,`email_verify_at`,`is_mobile_verify`,`mobile_verify_at`,`is_guest`,`about_us`,`dob`,`country`,`city`,`state`,`zipcode`,`address`,`latitude`,`longitude`,`fcm_token`,`is_access`,`online_status`,`mobile_otp`,`email_otp`,`created_at`,`updated_at`,`deleted_at`,`followers`,`followings`,`videos`,`coins`) values 
(1,3,'admin','RetroCube','retrocube','retrocube',NULL,NULL,'admin@retrocube.com','1-8882051816','$2a$10$O42dLIkIAdfTn4FJEJYITeeOJWu5GW4NeBl46.GTdQj820ROkRuWW',NULL,NULL,NULL,NULL,1,'1','2022-07-08 05:55:25','1','2022-07-08 05:55:25','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1',NULL,NULL,'2022-07-08 10:55:25',NULL,NULL,0,0,0,0),
(97,4,'user','john1','@john','john','Art,Racing',NULL,'john@yopmail.com','+16504447894','$2a$10$H8v06mgDIwLJ7fedR.YRnu8JjeSNCDDdgormXRNFr3gh21BP4DR8m','https://hitreelsdatastorage.s3.amazonaws.com/5pJivTtq0Ut7DsXhZreubPnZBKeggysP.png',NULL,NULL,NULL,1,'0',NULL,'0',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1','0000',NULL,'2023-01-04 03:59:41','2023-01-04 03:59:41',NULL,1,1,0,35),
(98,4,'user','jim1','jim','jim',NULL,NULL,'jim@yopmail.com','+16502212222','$2a$10$.5YCmd241djvU7Zbpc7L8eb7pbzGVNUWjt7o/RW.9w.W1JfpKKt/W','https://hitreelsdatastorage.s3.amazonaws.com/1FQT5PiYRGJBrdeWEcP1ynuxDal1fzgj.png',NULL,NULL,NULL,1,'0',NULL,'0',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1','0000',NULL,'2023-01-04 04:16:59','2023-01-04 04:16:59',NULL,1,1,2,50),
(99,4,'user','abc','abc','abc',NULL,NULL,'abc@yopmail.com','+9212345678','$2a$10$mNONMK4Mb6BWCw2sjcNhN.z3p5SG/NQWxUTzzgX.Z92FeFaP8P5Ue',NULL,NULL,NULL,NULL,1,'0',NULL,'0',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1','0000',NULL,'2023-01-04 04:35:07','2023-01-04 04:35:07',NULL,0,0,0,0),
(100,4,'user','anas','anas','anas',NULL,NULL,'anasakhtar1337@gmail.com',NULL,'$2a$10$AfnvMPvYJZdgyQ2CVbYLT.C/4cmxFHf7JoG7s5hN0ybcVUd.eoIJy','https://www.pngfind.com/pngs/m/610-6104451_image-placeholder-png-user-profile-placeholder-image-png.png',NULL,NULL,NULL,1,'1','2023-01-04 10:00:44','1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1',NULL,NULL,'2023-01-04 10:00:43','2023-01-04 12:08:50',NULL,0,0,0,0),
(101,4,'user','Jack Turner','jack-turner','jack-turner',NULL,NULL,'tester2019001@gmail.com',NULL,'$2a$10$nbKSrS39LqJXqs3ZHTxeOO9.IDoWXxElgvJG5oksS1UM8ivrT2zQy','https://lh3.googleusercontent.com/a/AEdFTp4TiaXwjuTtLRojTLBx_yOh-nWcLsq9VLWTTuSVmA=s96-c',NULL,NULL,NULL,1,'1','2023-01-04 10:17:16','1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1',NULL,NULL,'2023-01-04 10:17:16','2023-01-05 08:02:53',NULL,0,0,1,5),
(102,4,'user','Tyler Mccarter','tyler-mccarter','tyler-mccarter',NULL,NULL,'tyler.mccarter@retrocubellc.com',NULL,'$2a$10$lZgfD6zhJR7XGr0m3KwWqeyWf43U9OTuXmo6rADiZXNAu83kUmbya','https://lh3.googleusercontent.com/a/AEdFTp60EVazuwmHOIPJp9BG60fh_BafV9pZyadgNqQu=s96-c',NULL,NULL,NULL,1,'1','2023-01-05 18:56:10','1',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','1',NULL,NULL,'2023-01-05 18:56:10','2023-01-05 18:56:10',NULL,0,0,0,0);

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