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



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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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` */


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;

/*Table structure for table `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` */


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` */


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` */


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_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);

