-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 29, 2025 at 04:29 AM
-- Server version: 10.11.14-MariaDB
-- PHP Version: 8.4.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mxthrillz_main`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin_settings`
--

CREATE TABLE `admin_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `update_length` int(10) UNSIGNED NOT NULL COMMENT 'The max length of updates',
  `status_page` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0 Offline, 1 Online',
  `email_verification` enum('0','1') NOT NULL COMMENT '0 Off, 1 On',
  `email_no_reply` varchar(200) NOT NULL,
  `email_admin` varchar(200) NOT NULL,
  `captcha` enum('on','off') NOT NULL DEFAULT 'on',
  `file_size_allowed` int(10) UNSIGNED NOT NULL COMMENT 'Size in Bytes',
  `google_analytics` text NOT NULL,
  `paypal_account` varchar(200) NOT NULL,
  `twitter` varchar(200) NOT NULL,
  `facebook` varchar(200) NOT NULL,
  `pinterest` varchar(200) NOT NULL,
  `instagram` varchar(200) NOT NULL,
  `google_adsense` text NOT NULL,
  `currency_symbol` char(10) NOT NULL,
  `currency_code` varchar(20) NOT NULL,
  `min_subscription_amount` int(10) UNSIGNED NOT NULL,
  `payment_gateway` enum('PayPal','Stripe') NOT NULL DEFAULT 'PayPal',
  `min_width_height_image` varchar(100) NOT NULL,
  `fee_commission` int(10) UNSIGNED NOT NULL,
  `max_subscription_amount` int(10) UNSIGNED NOT NULL,
  `date_format` varchar(200) NOT NULL,
  `link_privacy` varchar(200) NOT NULL,
  `link_terms` varchar(200) NOT NULL,
  `currency_position` varchar(100) NOT NULL DEFAULT 'left',
  `facebook_login` enum('on','off') NOT NULL DEFAULT 'off',
  `amount_min_withdrawal` int(10) UNSIGNED NOT NULL,
  `youtube` varchar(200) NOT NULL,
  `github` varchar(200) NOT NULL,
  `comment_length` int(10) UNSIGNED NOT NULL,
  `days_process_withdrawals` int(10) UNSIGNED NOT NULL,
  `google_login` enum('on','off') NOT NULL DEFAULT 'off',
  `number_posts_show` tinyint(3) UNSIGNED NOT NULL,
  `number_comments_show` tinyint(3) UNSIGNED NOT NULL,
  `registration_active` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0 No, 1 Yes',
  `account_verification` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0 No, 1 Yes',
  `logo` varchar(100) NOT NULL,
  `logo_2` varchar(100) NOT NULL,
  `favicon` varchar(100) NOT NULL,
  `home_index` varchar(100) NOT NULL,
  `bg_gradient` varchar(100) NOT NULL,
  `img_1` varchar(100) NOT NULL,
  `img_2` varchar(100) NOT NULL,
  `img_3` varchar(100) NOT NULL,
  `img_4` varchar(100) NOT NULL,
  `avatar` varchar(100) NOT NULL,
  `show_counter` enum('on','off') NOT NULL DEFAULT 'on',
  `color_default` varchar(100) NOT NULL,
  `decimal_format` enum('comma','dot') NOT NULL DEFAULT 'dot',
  `version` varchar(5) NOT NULL,
  `link_cookies` varchar(200) NOT NULL,
  `story_length` int(10) UNSIGNED NOT NULL,
  `maintenance_mode` enum('on','off') NOT NULL DEFAULT 'off',
  `company` varchar(100) NOT NULL,
  `country` varchar(255) NOT NULL,
  `address` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `zip` varchar(100) NOT NULL,
  `vat` varchar(100) NOT NULL,
  `widget_creators_featured` enum('on','off') NOT NULL DEFAULT 'on',
  `home_style` int(10) UNSIGNED NOT NULL,
  `file_size_allowed_verify_account` int(10) UNSIGNED NOT NULL,
  `payout_method_paypal` enum('on','off') NOT NULL DEFAULT 'on',
  `payout_method_bank` enum('on','off') NOT NULL DEFAULT 'on',
  `min_tip_amount` int(10) UNSIGNED NOT NULL,
  `max_tip_amount` int(10) UNSIGNED NOT NULL,
  `min_ppv_amount` int(10) UNSIGNED NOT NULL,
  `max_ppv_amount` int(10) UNSIGNED NOT NULL,
  `min_deposits_amount` int(10) UNSIGNED NOT NULL,
  `max_deposits_amount` int(10) UNSIGNED NOT NULL,
  `button_style` enum('rounded','normal') NOT NULL DEFAULT 'rounded',
  `twitter_login` enum('on','off') NOT NULL DEFAULT 'off',
  `hide_admin_profile` enum('on','off') NOT NULL DEFAULT 'off',
  `requests_verify_account` enum('on','off') NOT NULL DEFAULT 'on',
  `navbar_background_color` varchar(30) NOT NULL,
  `navbar_text_color` varchar(30) NOT NULL,
  `footer_background_color` varchar(30) NOT NULL,
  `footer_text_color` varchar(30) NOT NULL,
  `preloading` enum('on','off') NOT NULL DEFAULT 'off',
  `preloading_image` varchar(100) NOT NULL,
  `watermark` enum('on','off') NOT NULL DEFAULT 'on',
  `earnings_simulator` enum('on','off') NOT NULL DEFAULT 'on',
  `custom_css` text NOT NULL,
  `custom_js` text NOT NULL,
  `alert_adult` enum('on','off') NOT NULL DEFAULT 'off',
  `genders` varchar(250) NOT NULL,
  `cover_default` varchar(100) NOT NULL,
  `who_can_see_content` enum('all','users') NOT NULL DEFAULT 'all',
  `users_can_edit_post` enum('on','off') NOT NULL DEFAULT 'on',
  `disable_wallet` enum('on','off') NOT NULL DEFAULT 'on',
  `disable_banner_cookies` enum('on','off') NOT NULL DEFAULT 'off',
  `wallet_format` enum('real_money','credits','points','tokens') NOT NULL DEFAULT 'real_money',
  `maximum_files_post` int(10) UNSIGNED NOT NULL DEFAULT 5,
  `maximum_files_msg` int(10) UNSIGNED NOT NULL DEFAULT 5,
  `announcement` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `announcement_show` varchar(100) NOT NULL,
  `announcement_cookie` varchar(20) NOT NULL,
  `limit_categories` int(10) UNSIGNED NOT NULL DEFAULT 3,
  `captcha_contact` enum('on','off') NOT NULL DEFAULT 'on',
  `disable_tips` enum('on','off') NOT NULL DEFAULT 'off',
  `payout_method_payoneer` enum('on','off') NOT NULL DEFAULT 'off',
  `payout_method_zelle` enum('on','off') NOT NULL DEFAULT 'off',
  `type_announcement` char(10) NOT NULL DEFAULT 'primary',
  `referral_system` enum('on','off') NOT NULL DEFAULT 'off',
  `auto_approve_post` enum('on','off') NOT NULL DEFAULT 'on',
  `watermark_on_videos` enum('on','off') NOT NULL DEFAULT 'on',
  `percentage_referred` int(10) UNSIGNED NOT NULL DEFAULT 5,
  `referral_transaction_limit` char(10) NOT NULL DEFAULT '1',
  `video_encoding` enum('on','off') NOT NULL DEFAULT 'off',
  `live_streaming_status` enum('on','off') NOT NULL DEFAULT 'off',
  `live_streaming_minimum_price` int(10) UNSIGNED NOT NULL DEFAULT 5,
  `live_streaming_max_price` int(10) UNSIGNED NOT NULL DEFAULT 100,
  `agora_app_id` varchar(200) NOT NULL,
  `tiktok` varchar(200) NOT NULL,
  `snapchat` varchar(200) NOT NULL,
  `limit_live_streaming_paid` int(10) UNSIGNED NOT NULL,
  `limit_live_streaming_free` int(10) UNSIGNED NOT NULL,
  `live_streaming_free` enum('0','1') NOT NULL DEFAULT '0',
  `type_withdrawals` char(50) NOT NULL DEFAULT 'custom',
  `shop` tinyint(1) NOT NULL DEFAULT 0,
  `min_price_product` int(10) UNSIGNED NOT NULL DEFAULT 5,
  `max_price_product` int(10) UNSIGNED NOT NULL DEFAULT 100,
  `digital_product_sale` tinyint(1) NOT NULL DEFAULT 0,
  `custom_content` tinyint(1) NOT NULL DEFAULT 0,
  `tax_on_wallet` tinyint(1) NOT NULL DEFAULT 1,
  `stripe_connect` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `stripe_connect_countries` longtext NOT NULL,
  `physical_products` tinyint(1) NOT NULL DEFAULT 0,
  `disable_login_register_email` tinyint(1) NOT NULL DEFAULT 0,
  `disable_contact` tinyint(1) NOT NULL DEFAULT 0,
  `specific_day_payment_withdrawals` int(10) UNSIGNED NOT NULL,
  `disable_new_post_notification` tinyint(1) NOT NULL DEFAULT 0,
  `disable_search_creators` tinyint(1) NOT NULL DEFAULT 0,
  `search_creators_genders` tinyint(1) NOT NULL DEFAULT 0,
  `generate_qr_code` tinyint(1) NOT NULL DEFAULT 0,
  `autofollow_admin` tinyint(1) NOT NULL DEFAULT 0,
  `allow_zip_files` tinyint(1) NOT NULL DEFAULT 1,
  `reddit` varchar(200) NOT NULL,
  `telegram` varchar(200) NOT NULL,
  `linkedin` varchar(200) NOT NULL,
  `push_notification_status` tinyint(1) NOT NULL DEFAULT 0,
  `onesignal_appid` varchar(150) NOT NULL,
  `onesignal_restapi` varchar(150) NOT NULL,
  `status_pwa` tinyint(1) NOT NULL DEFAULT 1,
  `zip_verification_creator` tinyint(1) NOT NULL DEFAULT 1,
  `amount_max_withdrawal` int(10) UNSIGNED NOT NULL,
  `story_status` tinyint(1) NOT NULL DEFAULT 0,
  `story_image` tinyint(1) NOT NULL DEFAULT 1,
  `story_text` tinyint(1) NOT NULL DEFAULT 1,
  `story_max_videos_length` int(10) UNSIGNED NOT NULL DEFAULT 30,
  `payout_method_western_union` enum('on','off') NOT NULL DEFAULT 'off',
  `payout_method_crypto` enum('on','off') NOT NULL DEFAULT 'off',
  `threads` varchar(200) NOT NULL,
  `watermak_video` varchar(100) NOT NULL,
  `coconut_key` varchar(255) NOT NULL,
  `encoding_method` varchar(255) NOT NULL DEFAULT 'ffmpeg',
  `allow_scheduled_posts` tinyint(1) DEFAULT 0,
  `google_tag_manager_head` text NOT NULL,
  `google_tag_manager_body` text NOT NULL,
  `live_streaming_private` enum('on','off') NOT NULL DEFAULT 'off',
  `live_streaming_minimum_price_private` decimal(10,2) DEFAULT NULL,
  `live_streaming_max_price_private` decimal(10,2) DEFAULT NULL,
  `limit_live_streaming_private` int(10) UNSIGNED NOT NULL,
  `show_address_company_footer` tinyint(1) DEFAULT 0,
  `watermark_position` varchar(50) NOT NULL DEFAULT 'center',
  `coconut_region` varchar(100) NOT NULL DEFAULT 'Virginia',
  `payout_method_mercadopago` enum('on','off') NOT NULL DEFAULT 'off',
  `theme` enum('light','dark') NOT NULL DEFAULT 'light',
  `allow_creators_deactivate_profile` tinyint(1) NOT NULL DEFAULT 0,
  `allow_epub_files` tinyint(1) NOT NULL DEFAULT 0,
  `gifts` tinyint(1) NOT NULL DEFAULT 0,
  `disable_free_post` tinyint(1) NOT NULL DEFAULT 0,
  `disable_explore_section` tinyint(1) NOT NULL DEFAULT 0,
  `disable_creators_section` tinyint(1) NOT NULL DEFAULT 0,
  `phone` varchar(100) DEFAULT NULL,
  `allow_free_items_shop` tinyint(1) NOT NULL DEFAULT 0,
  `allow_external_links_shop` tinyint(1) NOT NULL DEFAULT 0,
  `users_can_delete_messages` tinyint(1) NOT NULL DEFAULT 1,
  `delete_old_users_inactive` tinyint(1) NOT NULL DEFAULT 0,
  `delete_old_messages` tinyint(1) NOT NULL DEFAULT 0,
  `theme_color_pwa` varchar(255) NOT NULL DEFAULT '#450ea7',
  `video_call_status` tinyint(1) NOT NULL DEFAULT 0,
  `video_call_max_price` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `video_call_min_price` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `video_call_max_duration` int(10) UNSIGNED NOT NULL DEFAULT 10,
  `websockets` tinyint(1) NOT NULL DEFAULT 0,
  `allow_reels` tinyint(1) NOT NULL DEFAULT 0,
  `disable_audio` tinyint(1) NOT NULL DEFAULT 0,
  `audio_call_status` tinyint(1) NOT NULL DEFAULT 0,
  `audio_call_max_price` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `audio_call_min_price` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `audio_call_max_duration` int(10) UNSIGNED NOT NULL DEFAULT 10
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `admin_settings`
--

INSERT INTO `admin_settings` (`id`, `title`, `description`, `keywords`, `update_length`, `status_page`, `email_verification`, `email_no_reply`, `email_admin`, `captcha`, `file_size_allowed`, `google_analytics`, `paypal_account`, `twitter`, `facebook`, `pinterest`, `instagram`, `google_adsense`, `currency_symbol`, `currency_code`, `min_subscription_amount`, `payment_gateway`, `min_width_height_image`, `fee_commission`, `max_subscription_amount`, `date_format`, `link_privacy`, `link_terms`, `currency_position`, `facebook_login`, `amount_min_withdrawal`, `youtube`, `github`, `comment_length`, `days_process_withdrawals`, `google_login`, `number_posts_show`, `number_comments_show`, `registration_active`, `account_verification`, `logo`, `logo_2`, `favicon`, `home_index`, `bg_gradient`, `img_1`, `img_2`, `img_3`, `img_4`, `avatar`, `show_counter`, `color_default`, `decimal_format`, `version`, `link_cookies`, `story_length`, `maintenance_mode`, `company`, `country`, `address`, `city`, `zip`, `vat`, `widget_creators_featured`, `home_style`, `file_size_allowed_verify_account`, `payout_method_paypal`, `payout_method_bank`, `min_tip_amount`, `max_tip_amount`, `min_ppv_amount`, `max_ppv_amount`, `min_deposits_amount`, `max_deposits_amount`, `button_style`, `twitter_login`, `hide_admin_profile`, `requests_verify_account`, `navbar_background_color`, `navbar_text_color`, `footer_background_color`, `footer_text_color`, `preloading`, `preloading_image`, `watermark`, `earnings_simulator`, `custom_css`, `custom_js`, `alert_adult`, `genders`, `cover_default`, `who_can_see_content`, `users_can_edit_post`, `disable_wallet`, `disable_banner_cookies`, `wallet_format`, `maximum_files_post`, `maximum_files_msg`, `announcement`, `announcement_show`, `announcement_cookie`, `limit_categories`, `captcha_contact`, `disable_tips`, `payout_method_payoneer`, `payout_method_zelle`, `type_announcement`, `referral_system`, `auto_approve_post`, `watermark_on_videos`, `percentage_referred`, `referral_transaction_limit`, `video_encoding`, `live_streaming_status`, `live_streaming_minimum_price`, `live_streaming_max_price`, `agora_app_id`, `tiktok`, `snapchat`, `limit_live_streaming_paid`, `limit_live_streaming_free`, `live_streaming_free`, `type_withdrawals`, `shop`, `min_price_product`, `max_price_product`, `digital_product_sale`, `custom_content`, `tax_on_wallet`, `stripe_connect`, `stripe_connect_countries`, `physical_products`, `disable_login_register_email`, `disable_contact`, `specific_day_payment_withdrawals`, `disable_new_post_notification`, `disable_search_creators`, `search_creators_genders`, `generate_qr_code`, `autofollow_admin`, `allow_zip_files`, `reddit`, `telegram`, `linkedin`, `push_notification_status`, `onesignal_appid`, `onesignal_restapi`, `status_pwa`, `zip_verification_creator`, `amount_max_withdrawal`, `story_status`, `story_image`, `story_text`, `story_max_videos_length`, `payout_method_western_union`, `payout_method_crypto`, `threads`, `watermak_video`, `coconut_key`, `encoding_method`, `allow_scheduled_posts`, `google_tag_manager_head`, `google_tag_manager_body`, `live_streaming_private`, `live_streaming_minimum_price_private`, `live_streaming_max_price_private`, `limit_live_streaming_private`, `show_address_company_footer`, `watermark_position`, `coconut_region`, `payout_method_mercadopago`, `theme`, `allow_creators_deactivate_profile`, `allow_epub_files`, `gifts`, `disable_free_post`, `disable_explore_section`, `disable_creators_section`, `phone`, `allow_free_items_shop`, `allow_external_links_shop`, `users_can_delete_messages`, `delete_old_users_inactive`, `delete_old_messages`, `theme_color_pwa`, `video_call_status`, `video_call_max_price`, `video_call_min_price`, `video_call_max_duration`, `websockets`, `allow_reels`, `disable_audio`, `audio_call_status`, `audio_call_max_price`, `audio_call_min_price`, `audio_call_max_duration`) VALUES
(1, 'MXThrillz', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer ut tortor rutrum massa efficitur tincidunt vel nec lacus. Curabitur porta aliquet diam, eu gravida neque lacinia.', 'donations,support,creators,Creaty,subscription', 250, '1', '', 'demo@demo.com', 'biz@miracuves.com', 'off', 5120, '', 'paypal@yousite.com', '', '', '', '', '', '$', 'USD', 2, 'PayPal', '400', 5, 100, 'M d, Y', 'https://mxthrillz.mimeld.com/p/privacy', 'https://mxthrillz.mimeld.com/p/terms-of-service', 'left', 'off', 50, '', '', 150, 7, 'off', 5, 2, '1', '1', 'logo-1757918793.png', 'logo_2-1757918793.png', 'favicon-1757918793.png', 'home_index-1754629152.mp4', 'background-1754627561.png', 'img_1.svg', 'img_2.svg', 'img_3.svg', 'img_4.png', 'default-1754636093.jpg', 'on', '#ee1802', 'dot', '6.5', 'https://mxthrillz.mimeld.com/p/cookies', 500, 'off', '', '', '', '', '', '', 'on', 0, 1024, 'on', 'on', 5, 100, 5, 100, 5, 100, 'rounded', 'off', 'off', 'on', '#000000', '#ffffff', '#000000', '#ffffff', 'off', '', 'on', 'on', '', '', 'off', 'male,female,transgender', '', 'all', 'on', 'off', 'off', 'real_money', 5, 5, '', '', '', 3, 'off', 'off', 'off', 'off', 'primary', 'off', 'on', 'on', 5, '1', 'off', 'on', 5, 100, '97d7054a8644416f8ee93a27e9f9ea60', '', '', 0, 0, '1', 'custom', 1, 5, 1000, 1, 1, 1, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', '', '', 0, 'd5313c9d-94bc-487b-b5b5-808397527966', 'os_v2_app_2uytzhmuxrehxnnvqcbzoutzm3hz2wk2glpex5mtwlcsqjokzilawn7a4jxgoy4sl4ef777izktxxuhv7bnhccqts6nh7ebnsn6nyui', 0, 1, 0, 0, 1, 1, 30, 'off', 'off', '', 'watermak_video-1757918793.png', '', 'ffmpeg', 1, '', '', 'on', 5.00, 100.00, 10, 0, 'center', 'Virginia', 'off', 'dark', 0, 0, 0, 0, 0, 0, NULL, 1, 1, 1, 0, 0, '#ee1802', 1, 100, 5, 10, 0, 1, 0, 1, 100, 1, 10);

-- --------------------------------------------------------

--
-- Table structure for table `advertisings`
--

CREATE TABLE `advertisings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `url` varchar(200) NOT NULL,
  `image` varchar(150) NOT NULL,
  `clicks` int(10) UNSIGNED NOT NULL,
  `impressions` int(10) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `expired_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ad_click_impressions`
--

CREATE TABLE `ad_click_impressions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `advertisings_id` bigint(20) UNSIGNED NOT NULL,
  `type` char(20) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ad_click_impressions`
--

INSERT INTO `ad_click_impressions` (`id`, `advertisings_id`, `type`, `ip`, `created_at`, `updated_at`) VALUES
(1, 1, 'impression', '223.233.87.11', '2025-03-28 12:09:48', '2025-03-28 12:09:48'),
(2, 1, 'click', '223.233.87.11', '2025-03-28 12:10:37', '2025-03-28 12:10:37');

-- --------------------------------------------------------

--
-- Table structure for table `audio_calls`
--

CREATE TABLE `audio_calls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) UNSIGNED NOT NULL,
  `buyer_id` bigint(20) UNSIGNED NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'calling',
  `minutes` int(10) UNSIGNED NOT NULL,
  `token` varchar(200) DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `joined_at` timestamp NULL DEFAULT NULL,
  `ended_at` timestamp NULL DEFAULT NULL,
  `paid` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `image` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `tags` varchar(255) NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `bookmarks`
--

CREATE TABLE `bookmarks` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `updates_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bookmarks`
--

INSERT INTO `bookmarks` (`id`, `user_id`, `updates_id`, `created_at`, `updated_at`) VALUES
(1, 6, 3, '2025-03-28 10:35:50', '2025-03-28 10:35:50'),
(2, 6, 11, '2025-08-08 12:12:55', '2025-08-08 12:12:55'),
(3, 7, 14, '2025-08-08 12:19:40', '2025-08-08 12:19:40');

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `mode` enum('on','off') NOT NULL DEFAULT 'on',
  `image` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `description`, `keywords`, `mode`, `image`) VALUES
(1, 'Artist', 'artist', '', '', 'on', 'artist-sjCaZaFfPCs114wCVsklnzDG4bBskrx5.png'),
(2, 'Designer', 'designer', '', '', 'on', 'designer-f2wbkIhbHYaqIfAUNwAH0Z2u09uHydGi.jpg'),
(3, 'Drawing and Painting', 'drawing-and-painting', '', '', 'on', 'drawing-and-painting-juSOoeSlHfiV87PRNZjtRpcakrTOSxRG.jpg'),
(4, 'Developer', 'developer', '', '', 'on', 'developer-NsjZqPTktkFddcocuO0Tt6DUr0pFb7uf.jpg'),
(5, 'Animation', 'animation', 'Category Animation', 'animate, animation', 'on', 'animation-68vGWiEp5N1ZBifBErYTw2PxgzydpIPN.png'),
(7, 'Photography', 'photography', '', '', 'on', 'photography-sy3S7yqZ5wFNU8mXKlsiQgmpKT3I2gNM.jpg'),
(8, 'Video and Film', 'video-and-film', '', '', 'on', 'video-and-film-4hzrmxdgdKKSzHtHNyZTH3ZBI0Fvaqbo.jpg'),
(9, 'Podcasts', 'podcasts', '', '', 'on', 'podcasts-Vs2cYOnDv3BYpLKA4rqQ3V4E3qxaAwH5.jpg'),
(10, 'Others', 'others', '', '', 'on', 'others-PplPsJxWsOu7ex6qWqWdQtMhYDufxM2k.jpg'),
(12, 'Writing', 'writing', '', '', 'on', 'writing-kFL09nqIU518jMK43PU8o7ZRpwZCvzWu.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `updates_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `reply` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0 Trash, 1 Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `updates_id`, `user_id`, `reply`, `date`, `status`) VALUES
(2, 8, 6, '😁Nice One buddy', '2025-08-08 11:43:26', '1'),
(3, 3, 6, 'Amazing', '2025-08-08 12:05:52', '1'),
(4, 14, 6, 'Awesome😎', '2025-08-08 12:13:47', '1');

-- --------------------------------------------------------

--
-- Table structure for table `comments_likes`
--

CREATE TABLE `comments_likes` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `comments_id` int(10) UNSIGNED NOT NULL,
  `replies_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `comment_like_reels`
--

CREATE TABLE `comment_like_reels` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `comment_reels_id` int(10) UNSIGNED NOT NULL,
  `reel_replies_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `comment_reels`
--

CREATE TABLE `comment_reels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `reels_id` bigint(20) UNSIGNED NOT NULL,
  `reply` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comment_reels`
--

INSERT INTO `comment_reels` (`id`, `user_id`, `reels_id`, `reply`, `created_at`, `updated_at`) VALUES
(1, 7, 4, 'Awesome😎', '2025-08-08 12:34:28', '2025-08-08 12:34:28');

-- --------------------------------------------------------

--
-- Table structure for table `conversations`
--

CREATE TABLE `conversations` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_1` int(11) NOT NULL,
  `user_2` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `country_code` varchar(2) NOT NULL DEFAULT '',
  `country_name` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `country_code`, `country_name`) VALUES
(1, 'US', 'United States'),
(2, 'CA', 'Canada'),
(3, 'AF', 'Afghanistan'),
(4, 'AL', 'Albania'),
(5, 'DZ', 'Algeria'),
(6, 'DS', 'American Samoa'),
(7, 'AD', 'Andorra'),
(8, 'AO', 'Angola'),
(9, 'AI', 'Anguilla'),
(10, 'AQ', 'Antarctica'),
(11, 'AG', 'Antigua and/or Barbuda'),
(12, 'AR', 'Argentina'),
(13, 'AM', 'Armenia'),
(14, 'AW', 'Aruba'),
(15, 'AU', 'Australia'),
(16, 'AT', 'Austria'),
(17, 'AZ', 'Azerbaijan'),
(18, 'BS', 'Bahamas'),
(19, 'BH', 'Bahrain'),
(20, 'BD', 'Bangladesh'),
(21, 'BB', 'Barbados'),
(22, 'BY', 'Belarus'),
(23, 'BE', 'Belgium'),
(24, 'BZ', 'Belize'),
(25, 'BJ', 'Benin'),
(26, 'BM', 'Bermuda'),
(27, 'BT', 'Bhutan'),
(28, 'BO', 'Bolivia'),
(29, 'BA', 'Bosnia and Herzegovina'),
(30, 'BW', 'Botswana'),
(31, 'BV', 'Bouvet Island'),
(32, 'BR', 'Brazil'),
(33, 'IO', 'British lndian Ocean Territory'),
(34, 'BN', 'Brunei Darussalam'),
(35, 'BG', 'Bulgaria'),
(36, 'BF', 'Burkina Faso'),
(37, 'BI', 'Burundi'),
(38, 'KH', 'Cambodia'),
(39, 'CM', 'Cameroon'),
(40, 'CV', 'Cape Verde'),
(41, 'KY', 'Cayman Islands'),
(42, 'CF', 'Central African Republic'),
(43, 'TD', 'Chad'),
(44, 'CL', 'Chile'),
(45, 'CN', 'China'),
(46, 'CX', 'Christmas Island'),
(47, 'CC', 'Cocos (Keeling) Islands'),
(48, 'CO', 'Colombia'),
(49, 'KM', 'Comoros'),
(50, 'CG', 'Congo'),
(51, 'CK', 'Cook Islands'),
(52, 'CR', 'Costa Rica'),
(53, 'HR', 'Croatia (Hrvatska)'),
(54, 'CU', 'Cuba'),
(55, 'CY', 'Cyprus'),
(56, 'CZ', 'Czech Republic'),
(57, 'DK', 'Denmark'),
(58, 'DJ', 'Djibouti'),
(59, 'DM', 'Dominica'),
(60, 'DO', 'Dominican Republic'),
(61, 'TP', 'East Timor'),
(62, 'EC', 'Ecuador'),
(63, 'EG', 'Egypt'),
(64, 'SV', 'El Salvador'),
(65, 'GQ', 'Equatorial Guinea'),
(66, 'ER', 'Eritrea'),
(67, 'EE', 'Estonia'),
(68, 'ET', 'Ethiopia'),
(69, 'FK', 'Falkland Islands (Malvinas)'),
(70, 'FO', 'Faroe Islands'),
(71, 'FJ', 'Fiji'),
(72, 'FI', 'Finland'),
(73, 'FR', 'France'),
(74, 'FX', 'France, Metropolitan'),
(75, 'GF', 'French Guiana'),
(76, 'PF', 'French Polynesia'),
(77, 'TF', 'French Southern Territories'),
(78, 'GA', 'Gabon'),
(79, 'GM', 'Gambia'),
(80, 'GE', 'Georgia'),
(81, 'DE', 'Germany'),
(82, 'GH', 'Ghana'),
(83, 'GI', 'Gibraltar'),
(84, 'GR', 'Greece'),
(85, 'GL', 'Greenland'),
(86, 'GD', 'Grenada'),
(87, 'GP', 'Guadeloupe'),
(88, 'GU', 'Guam'),
(89, 'GT', 'Guatemala'),
(90, 'GN', 'Guinea'),
(91, 'GW', 'Guinea-Bissau'),
(92, 'GY', 'Guyana'),
(93, 'HT', 'Haiti'),
(94, 'HM', 'Heard and Mc Donald Islands'),
(95, 'HN', 'Honduras'),
(96, 'HK', 'Hong Kong'),
(97, 'HU', 'Hungary'),
(98, 'IS', 'Iceland'),
(99, 'IN', 'India'),
(100, 'ID', 'Indonesia'),
(101, 'IR', 'Iran (Islamic Republic of)'),
(102, 'IQ', 'Iraq'),
(103, 'IE', 'Ireland'),
(104, 'IL', 'Israel'),
(105, 'IT', 'Italy'),
(106, 'CI', 'Ivory Coast'),
(107, 'JM', 'Jamaica'),
(108, 'JP', 'Japan'),
(109, 'JO', 'Jordan'),
(110, 'KZ', 'Kazakhstan'),
(111, 'KE', 'Kenya'),
(112, 'KI', 'Kiribati'),
(113, 'KP', 'Korea, Democratic People\'s Republic of'),
(114, 'KR', 'Korea, Republic of'),
(115, 'XK', 'Kosovo'),
(116, 'KW', 'Kuwait'),
(117, 'KG', 'Kyrgyzstan'),
(118, 'LA', 'Lao People\'s Democratic Republic'),
(119, 'LV', 'Latvia'),
(120, 'LB', 'Lebanon'),
(121, 'LS', 'Lesotho'),
(122, 'LR', 'Liberia'),
(123, 'LY', 'Libyan Arab Jamahiriya'),
(124, 'LI', 'Liechtenstein'),
(125, 'LT', 'Lithuania'),
(126, 'LU', 'Luxembourg'),
(127, 'MO', 'Macau'),
(128, 'MK', 'Macedonia'),
(129, 'MG', 'Madagascar'),
(130, 'MW', 'Malawi'),
(131, 'MY', 'Malaysia'),
(132, 'MV', 'Maldives'),
(133, 'ML', 'Mali'),
(134, 'MT', 'Malta'),
(135, 'MH', 'Marshall Islands'),
(136, 'MQ', 'Martinique'),
(137, 'MR', 'Mauritania'),
(138, 'MU', 'Mauritius'),
(139, 'TY', 'Mayotte'),
(140, 'MX', 'Mexico'),
(141, 'FM', 'Micronesia, Federated States of'),
(142, 'MD', 'Moldova, Republic of'),
(143, 'MC', 'Monaco'),
(144, 'MN', 'Mongolia'),
(145, 'ME', 'Montenegro'),
(146, 'MS', 'Montserrat'),
(147, 'MA', 'Morocco'),
(148, 'MZ', 'Mozambique'),
(149, 'MM', 'Myanmar'),
(150, 'NA', 'Namibia'),
(151, 'NR', 'Nauru'),
(152, 'NP', 'Nepal'),
(153, 'NL', 'Netherlands'),
(154, 'AN', 'Netherlands Antilles'),
(155, 'NC', 'New Caledonia'),
(156, 'NZ', 'New Zealand'),
(157, 'NI', 'Nicaragua'),
(158, 'NE', 'Niger'),
(159, 'NG', 'Nigeria'),
(160, 'NU', 'Niue'),
(161, 'NF', 'Norfork Island'),
(162, 'MP', 'Northern Mariana Islands'),
(163, 'NO', 'Norway'),
(164, 'OM', 'Oman'),
(165, 'PK', 'Pakistan'),
(166, 'PW', 'Palau'),
(167, 'PA', 'Panama'),
(168, 'PG', 'Papua New Guinea'),
(169, 'PY', 'Paraguay'),
(170, 'PE', 'Peru'),
(171, 'PH', 'Philippines'),
(172, 'PN', 'Pitcairn'),
(173, 'PL', 'Poland'),
(174, 'PT', 'Portugal'),
(175, 'PR', 'Puerto Rico'),
(176, 'QA', 'Qatar'),
(177, 'RE', 'Reunion'),
(178, 'RO', 'Romania'),
(179, 'RU', 'Russian Federation'),
(180, 'RW', 'Rwanda'),
(181, 'KN', 'Saint Kitts and Nevis'),
(182, 'LC', 'Saint Lucia'),
(183, 'VC', 'Saint Vincent and the Grenadines'),
(184, 'WS', 'Samoa'),
(185, 'SM', 'San Marino'),
(186, 'ST', 'Sao Tome and Principe'),
(187, 'SA', 'Saudi Arabia'),
(188, 'SN', 'Senegal'),
(189, 'RS', 'Serbia'),
(190, 'SC', 'Seychelles'),
(191, 'SL', 'Sierra Leone'),
(192, 'SG', 'Singapore'),
(193, 'SK', 'Slovakia'),
(194, 'SI', 'Slovenia'),
(195, 'SB', 'Solomon Islands'),
(196, 'SO', 'Somalia'),
(197, 'ZA', 'South Africa'),
(198, 'GS', 'South Georgia South Sandwich Islands'),
(199, 'ES', 'Spain'),
(200, 'LK', 'Sri Lanka'),
(201, 'SH', 'St. Helena'),
(202, 'PM', 'St. Pierre and Miquelon'),
(203, 'SD', 'Sudan'),
(204, 'SR', 'Suriname'),
(205, 'SJ', 'Svalbarn and Jan Mayen Islands'),
(206, 'SZ', 'Swaziland'),
(207, 'SE', 'Sweden'),
(208, 'CH', 'Switzerland'),
(209, 'SY', 'Syrian Arab Republic'),
(210, 'TW', 'Taiwan'),
(211, 'TJ', 'Tajikistan'),
(212, 'TZ', 'Tanzania, United Republic of'),
(213, 'TH', 'Thailand'),
(214, 'TG', 'Togo'),
(215, 'TK', 'Tokelau'),
(216, 'TO', 'Tonga'),
(217, 'TT', 'Trinidad and Tobago'),
(218, 'TN', 'Tunisia'),
(219, 'TR', 'Turkey'),
(220, 'TM', 'Turkmenistan'),
(221, 'TC', 'Turks and Caicos Islands'),
(222, 'TV', 'Tuvalu'),
(223, 'UG', 'Uganda'),
(224, 'UA', 'Ukraine'),
(225, 'AE', 'United Arab Emirates'),
(226, 'GB', 'United Kingdom'),
(227, 'UM', 'United States minor outlying islands'),
(228, 'UY', 'Uruguay'),
(229, 'UZ', 'Uzbekistan'),
(230, 'VU', 'Vanuatu'),
(231, 'VA', 'Vatican City State'),
(232, 'VE', 'Venezuela'),
(233, 'VN', 'Vietnam'),
(234, 'VG', 'Virgin Islands (British)'),
(235, 'VI', 'Virgin Islands (U.S.)'),
(236, 'WF', 'Wallis and Futuna Islands'),
(237, 'EH', 'Western Sahara'),
(238, 'YE', 'Yemen'),
(239, 'YU', 'Yugoslavia'),
(240, 'ZR', 'Zaire'),
(241, 'ZM', 'Zambia'),
(242, 'ZW', 'Zimbabwe');

-- --------------------------------------------------------

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `txn_id` varchar(200) NOT NULL,
  `amount` int(10) UNSIGNED NOT NULL,
  `payment_gateway` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` varchar(200) NOT NULL DEFAULT 'active',
  `screenshot_transfer` varchar(100) NOT NULL,
  `percentage_applied` varchar(50) DEFAULT NULL,
  `transaction_fee` double(10,2) NOT NULL,
  `taxes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deposits`
--

INSERT INTO `deposits` (`id`, `user_id`, `txn_id`, `amount`, `payment_gateway`, `date`, `status`, `screenshot_transfer`, `percentage_applied`, `transaction_fee`, `taxes`) VALUES
(1, 6, 'bt_4IcyFAIJnDLPRiupCdkkUQC0P', 100, 'Bank', '2025-03-31 03:55:47', 'active', 'bt_61743393329sq5gpcjwowcs1wd9bnbkrdhoiqrqqplyvowtke6e.png', '2.0% + 3.00', 5.00, '');

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) DEFAULT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `gifts`
--

CREATE TABLE `gifts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(50) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gifts`
--

INSERT INTO `gifts` (`id`, `image`, `price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'kSGP0HALXTcxJ9QrR7mfBE9l3or5j2TtKEr8k2OE.png', 5.00, 1, '2025-03-28 10:07:05', '2025-03-28 10:07:05');

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"8ccd76f0-3d97-49e6-98c8-646c2e84a504\",\"displayName\":\"App\\\\Notifications\\\\AdminVerificationPending\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:29:\\\"Illuminate\\\\Support\\\\Collection\\\":2:{s:8:\\\"\\u0000*\\u0000items\\\";a:1:{i:0;O:44:\\\"Illuminate\\\\Notifications\\\\AnonymousNotifiable\\\":1:{s:6:\\\"routes\\\";a:1:{s:4:\\\"mail\\\";s:17:\\\"biz@miracuves.com\\\";}}}s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;}s:12:\\\"notification\\\";O:42:\\\"App\\\\Notifications\\\\AdminVerificationPending\\\":2:{s:4:\\\"data\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:31:\\\"App\\\\Models\\\\VerificationRequests\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"6646ca2c-4b07-4b64-b556-c33d36dfcf49\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1754651512,\"delay\":null}', 0, NULL, 1754651512, 1754651512),
(2, 'default', '{\"uuid\":\"99a74250-381e-42fa-b091-5c52d7ca873f\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:6;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754652150,\"delay\":null}', 0, NULL, 1754652150, 1754652150),
(3, 'default', '{\"uuid\":\"dc890555-94e0-448b-8865-7cb9374ac815\",\"displayName\":\"App\\\\Listeners\\\\SubscriptionDisabledListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:42:\\\"App\\\\Listeners\\\\SubscriptionDisabledListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:36:\\\"App\\\\Events\\\\SubscriptionDisabledEvent\\\":2:{s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:16:\\\"freeSubscription\\\";s:3:\\\"yes\\\";}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754652181,\"delay\":null}', 0, NULL, 1754652181, 1754652181),
(4, 'default', '{\"uuid\":\"80914ce4-f94c-4ee0-b2c6-ce66fb197911\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:7;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754652241,\"delay\":null}', 0, NULL, 1754652241, 1754652241),
(5, 'default', '{\"uuid\":\"3af31af7-b219-4e92-8c0c-57ab82e8f3c1\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754652427,\"delay\":null}', 0, NULL, 1754652427, 1754652427),
(6, 'default', '{\"uuid\":\"6b6ffac2-9270-401d-b8c8-304161bcbff3\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:9;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754652888,\"delay\":null}', 0, NULL, 1754652888, 1754652888),
(7, 'default', '{\"uuid\":\"4826738b-923e-430d-afc0-caa4533dabf6\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:10;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754652945,\"delay\":null}', 0, NULL, 1754652945, 1754652945),
(8, 'default', '{\"uuid\":\"fc43c478-7242-4506-ae31-1deff0eec0f6\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653124,\"delay\":null}', 0, NULL, 1754653124, 1754653124),
(9, 'default', '{\"uuid\":\"f8d8e639-a4b3-4a68-934b-f042064e6ab8\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:12;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653331,\"delay\":null}', 0, NULL, 1754653331, 1754653331),
(10, 'default', '{\"uuid\":\"918e9b74-12a7-4f21-8645-be57f59469b1\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:13;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653375,\"delay\":null}', 0, NULL, 1754653375, 1754653375),
(11, 'default', '{\"uuid\":\"cbf7c7ec-80d1-47d7-808a-dc0cc960b8bb\",\"displayName\":\"App\\\\Notifications\\\\NewSale\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:5;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:25:\\\"App\\\\Notifications\\\\NewSale\\\":2:{s:4:\\\"sale\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Purchases\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"7bb31ad7-65c6-48b8-a8e4-0b320f2e9992\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1754653410,\"delay\":null}', 0, NULL, 1754653410, 1754653410),
(12, 'default', '{\"uuid\":\"120d310f-38d4-465e-948e-cdc146d1d77b\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:14;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653411,\"delay\":null}', 0, NULL, 1754653411, 1754653411),
(13, 'default', '{\"uuid\":\"88b64dc5-838e-4781-a8e9-f9c313eb2883\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:15;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653606,\"delay\":null}', 0, NULL, 1754653606, 1754653606),
(14, 'default', '{\"uuid\":\"37f4bc1d-aa22-4a4d-ae99-06bfccf85ae7\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:16;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653673,\"delay\":null}', 0, NULL, 1754653673, 1754653673),
(15, 'default', '{\"uuid\":\"57533f67-af6a-42d2-9639-817a1419930d\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:17;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653705,\"delay\":null}', 0, NULL, 1754653705, 1754653705),
(16, 'default', '{\"uuid\":\"233a62f1-1442-4db1-ac6c-9b52f4ac05b3\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:18;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653849,\"delay\":null}', 0, NULL, 1754653849, 1754653849),
(17, 'default', '{\"uuid\":\"9b4b7298-ce57-43ad-84ea-5e1657e1da3b\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:19;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653890,\"delay\":null}', 0, NULL, 1754653890, 1754653890),
(18, 'default', '{\"uuid\":\"9651fda0-6091-45ae-adb0-296271ee641c\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:20;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754653962,\"delay\":null}', 0, NULL, 1754653962, 1754653962),
(19, 'default', '{\"uuid\":\"e8783d84-b9c2-4a3d-9676-26619b796906\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:21;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754654148,\"delay\":null}', 0, NULL, 1754654148, 1754654148),
(20, 'default', '{\"uuid\":\"64b1a13c-0886-4c89-9f81-b2c817749f6d\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:22;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754654183,\"delay\":null}', 0, NULL, 1754654183, 1754654183),
(21, 'default', '{\"uuid\":\"1f4e4cdf-c76d-4ee3-bee2-50568fd84289\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:23;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754654232,\"delay\":null}', 0, NULL, 1754654232, 1754654232),
(22, 'default', '{\"uuid\":\"ce36cd91-5275-4eeb-a532-ffa73e9385ff\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:24;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754654291,\"delay\":null}', 0, NULL, 1754654291, 1754654291),
(23, 'default', '{\"uuid\":\"5ed3cf2b-766f-42ec-b9e0-21d11d0fdbad\",\"displayName\":\"App\\\\Notifications\\\\NewSale\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:5;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:25:\\\"App\\\\Notifications\\\\NewSale\\\":2:{s:4:\\\"sale\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Purchases\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"5ed6b413-9b73-4f74-93d1-af12ddec9db0\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1754654786,\"delay\":null}', 0, NULL, 1754654786, 1754654786),
(24, 'default', '{\"uuid\":\"b340d32d-1637-4e59-b10a-90fad2ae64b0\",\"displayName\":\"App\\\\Notifications\\\\TipReceived\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:7;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:29:\\\"App\\\\Notifications\\\\TipReceived\\\":2:{s:35:\\\"\\u0000App\\\\Notifications\\\\TipReceived\\u0000data\\\";a:2:{s:6:\\\"tipper\\\";s:5:\\\"user6\\\";s:6:\\\"amount\\\";s:1:\\\"5\\\";}s:2:\\\"id\\\";s:36:\\\"820bca52-411f-41bc-8e6b-778a459b4ca8\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1754654821,\"delay\":null}', 0, NULL, 1754654821, 1754654821),
(25, 'default', '{\"uuid\":\"a6c9d495-53b5-4201-8fe9-6ae28499cc43\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:25;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754654870,\"delay\":null}', 0, NULL, 1754654870, 1754654870),
(26, 'default', '{\"uuid\":\"3a13f1f8-a389-4ab8-baa3-b64b183f57ba\",\"displayName\":\"App\\\\Notifications\\\\PayPerViewReceived\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:36:\\\"App\\\\Notifications\\\\PayPerViewReceived\\\":2:{s:42:\\\"\\u0000App\\\\Notifications\\\\PayPerViewReceived\\u0000data\\\";a:3:{s:5:\\\"buyer\\\";s:7:\\\"jack007\\\";s:7:\\\"content\\\";s:9:\\\"ewrsdfdsf\\\";s:4:\\\"type\\\";s:4:\\\"post\\\";}s:2:\\\"id\\\";s:36:\\\"6dfc6c83-0bca-4928-909f-23c417c3590c\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1754655032,\"delay\":null}', 0, NULL, 1754655032, 1754655032),
(27, 'default', '{\"uuid\":\"9a1b7b14-6b70-4eb6-a55b-28613b31daa7\",\"displayName\":\"App\\\\Notifications\\\\NewSale\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:25:\\\"App\\\\Notifications\\\\NewSale\\\":2:{s:4:\\\"sale\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Purchases\\\";s:2:\\\"id\\\";i:3;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"f387e716-c80a-4519-8161-63fd9071a724\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1754655091,\"delay\":null}', 0, NULL, 1754655091, 1754655091),
(28, 'default', '{\"uuid\":\"20af8064-03b0-4770-9ee2-94adf17f0f5d\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:26;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754655815,\"delay\":null}', 0, NULL, 1754655815, 1754655815),
(29, 'default', '{\"uuid\":\"6ea777db-92db-46a3-8132-b98ca67444ac\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:27;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754655973,\"delay\":null}', 0, NULL, 1754655973, 1754655973),
(30, 'default', '{\"uuid\":\"7e89c060-a3fe-40e8-bbd2-becca26a6bc5\",\"displayName\":\"App\\\\Listeners\\\\NewPostListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":20:{s:5:\\\"class\\\";s:29:\\\"App\\\\Listeners\\\\NewPostListener\\\";s:6:\\\"method\\\";s:6:\\\"handle\\\";s:4:\\\"data\\\";a:1:{i:0;O:23:\\\"App\\\\Events\\\\NewPostEvent\\\":1:{s:4:\\\"post\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Updates\\\";s:2:\\\"id\\\";i:28;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:13:\\\"failOnTimeout\\\";b:0;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1754656564,\"delay\":null}', 0, NULL, 1754656564, 1754656564),
(31, 'default', '{\"uuid\":\"e5c187f3-8e82-45e7-8fa5-29516244a844\",\"displayName\":\"App\\\\Notifications\\\\PayPerViewReceived\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:7;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:36:\\\"App\\\\Notifications\\\\PayPerViewReceived\\\":2:{s:42:\\\"\\u0000App\\\\Notifications\\\\PayPerViewReceived\\u0000data\\\";a:3:{s:5:\\\"buyer\\\";s:7:\\\"jack007\\\";s:7:\\\"content\\\";s:11:\\\"Live Stream\\\";s:4:\\\"type\\\";s:4:\\\"post\\\";}s:2:\\\"id\\\";s:36:\\\"60cfb7d4-8451-46be-b330-fa5373443245\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1754656661,\"delay\":null}', 0, NULL, 1754656661, 1754656661),
(32, 'default', '{\"uuid\":\"284757e0-babe-4465-a8d6-de00c8e483ac\",\"displayName\":\"App\\\\Notifications\\\\TipReceived\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:29:\\\"App\\\\Notifications\\\\TipReceived\\\":2:{s:35:\\\"\\u0000App\\\\Notifications\\\\TipReceived\\u0000data\\\";a:2:{s:6:\\\"tipper\\\";s:7:\\\"jack007\\\";s:6:\\\"amount\\\";s:2:\\\"20\\\";}s:2:\\\"id\\\";s:36:\\\"651855f2-baa5-4218-862a-c38dd6bddcce\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1757323768,\"delay\":null}', 0, NULL, 1757323768, 1757323768),
(33, 'default', '{\"uuid\":\"6dfcadaa-268c-43d4-b789-4c38f0b9c3ee\",\"displayName\":\"App\\\\Notifications\\\\NewSale\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:3;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:25:\\\"App\\\\Notifications\\\\NewSale\\\":2:{s:4:\\\"sale\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Purchases\\\";s:2:\\\"id\\\";i:4;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"29dd77f8-3f37-4a9c-98d1-77dfb3a2c0eb\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1757954501,\"delay\":null}', 0, NULL, 1757954501, 1757954501),
(34, 'default', '{\"uuid\":\"9408ace0-fffb-41bc-bcec-033c7c2fdff1\",\"displayName\":\"App\\\\Notifications\\\\NewSale\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:25:\\\"App\\\\Notifications\\\\NewSale\\\":2:{s:4:\\\"sale\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Purchases\\\";s:2:\\\"id\\\";i:5;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"afd3cd85-dabe-48e0-976e-eecc99211625\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1757958357,\"delay\":null}', 0, NULL, 1757958357, 1757958357);

-- --------------------------------------------------------

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `abbreviation` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `name`, `abbreviation`) VALUES
(1, 'English', 'en'),
(2, 'Español', 'es'),
(3, 'French', 'fr');

-- --------------------------------------------------------

--
-- Table structure for table `likes`
--

CREATE TABLE `likes` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `updates_id` int(10) UNSIGNED NOT NULL,
  `status` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '1' COMMENT '0 trash, 1 active',
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `likes`
--

INSERT INTO `likes` (`id`, `user_id`, `updates_id`, `status`, `date`) VALUES
(1, 6, 2, '0', '2025-03-28 10:10:59'),
(2, 6, 3, '1', '2025-03-28 10:21:19'),
(3, 1, 1, '1', '2025-03-31 05:34:46'),
(4, 6, 1, '1', '2025-08-07 15:51:20'),
(5, 6, 8, '0', '2025-08-08 11:43:29'),
(6, 6, 11, '0', '2025-08-08 12:12:51'),
(7, 6, 14, '1', '2025-08-08 12:13:24'),
(8, 7, 13, '1', '2025-08-08 12:19:46'),
(9, 6, 7, '1', '2025-09-27 03:50:57');

-- --------------------------------------------------------

--
-- Table structure for table `like_reels`
--

CREATE TABLE `like_reels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `reels_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `like_reels`
--

INSERT INTO `like_reels` (`id`, `user_id`, `reels_id`, `created_at`, `updated_at`) VALUES
(1, 7, 2, '2025-08-08 12:29:50', '2025-08-08 12:29:50'),
(2, 7, 3, '2025-08-08 12:33:02', '2025-08-08 12:33:02'),
(3, 7, 4, '2025-08-08 12:34:03', '2025-08-08 12:34:03');

-- --------------------------------------------------------

--
-- Table structure for table `live_comments`
--

CREATE TABLE `live_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `live_streamings_id` int(10) UNSIGNED NOT NULL,
  `comment` text NOT NULL,
  `joined` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `tip` enum('0','1') NOT NULL DEFAULT '0',
  `earnings` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `gift_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `live_comments`
--

INSERT INTO `live_comments` (`id`, `user_id`, `live_streamings_id`, `comment`, `joined`, `tip`, `earnings`, `created_at`, `updated_at`, `gift_id`) VALUES
(1, 6, 2, '', 1, '0', 0.00, '2025-03-28 10:56:33', '2025-03-28 10:56:33', NULL),
(2, 7, 2, '..', 0, '0', 0.00, '2025-03-28 10:56:50', '2025-03-28 10:56:50', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `live_likes`
--

CREATE TABLE `live_likes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `live_streamings_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `live_online_users`
--

CREATE TABLE `live_online_users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `live_streamings_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `live_online_users`
--

INSERT INTO `live_online_users` (`id`, `user_id`, `live_streamings_id`, `created_at`, `updated_at`) VALUES
(1, 6, 2, '2025-03-28 10:56:33', '2025-03-28 10:57:15');

-- --------------------------------------------------------

--
-- Table structure for table `live_streamings`
--

CREATE TABLE `live_streamings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(100) NOT NULL DEFAULT 'normal',
  `user_id` int(10) UNSIGNED NOT NULL,
  `buyer_id` int(10) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `channel` text NOT NULL,
  `minutes` int(10) UNSIGNED NOT NULL,
  `price` int(10) UNSIGNED NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0',
  `joined_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `availability` char(50) NOT NULL DEFAULT 'all_pay',
  `token` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `live_streamings`
--

INSERT INTO `live_streamings` (`id`, `type`, `user_id`, `buyer_id`, `name`, `channel`, `minutes`, `price`, `status`, `joined_at`, `created_at`, `updated_at`, `ends_at`, `availability`, `token`) VALUES
(1, 'normal', 7, NULL, 'creator', 'live_5E1MK_7', 0, 0, '1', NULL, '2025-03-28 10:50:21', '2025-03-28 10:52:53', NULL, 'everyone_free', NULL),
(2, 'normal', 7, NULL, 'creator', 'live_1uBD8_7', 0, 0, '1', NULL, '2025-03-28 10:53:09', '2025-03-28 10:57:32', NULL, 'everyone_free', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `live_streaming_private_requests`
--

CREATE TABLE `live_streaming_private_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `creator_id` int(10) UNSIGNED NOT NULL,
  `minutes` int(10) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `login_sessions`
--

CREATE TABLE `login_sessions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(100) NOT NULL,
  `device` varchar(100) DEFAULT NULL,
  `device_type` varchar(100) DEFAULT NULL,
  `browser` varchar(100) DEFAULT NULL,
  `platform` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_sessions`
--

INSERT INTO `login_sessions` (`id`, `user_id`, `ip`, `device`, `device_type`, `browser`, `platform`, `country`, `created_at`, `updated_at`) VALUES
(1, 1, '127.0.0.1', 'WebKit', 'desktop', 'Chrome 136.0.0.0', 'Windows 10.0', NULL, '2025-05-22 18:53:00', '2025-05-31 03:42:10'),
(2, 1, '127.0.0.1', 'WebKit', 'desktop', 'Chrome 137.0.0.0', 'Windows 10.0', NULL, '2025-06-06 03:47:14', '2025-06-06 03:47:14'),
(3, 1, '152.58.131.5', 'WebKit', 'desktop', 'Chrome 138.0.0.0', 'Windows 10.0', NULL, '2025-08-08 04:25:20', '2025-08-08 12:51:01'),
(4, 1, '223.185.38.56', 'Macintosh', 'desktop', 'Chrome 138.0.0.0', 'OS X 10_15_7', NULL, '2025-08-08 04:25:40', '2025-08-08 07:32:05'),
(6, 7, '152.58.131.5', 'WebKit', 'desktop', 'Chrome 138.0.0.0', 'Windows 10.0', 'India', '2025-08-08 08:53:55', '2025-08-08 12:55:14'),
(7, 6, '186.189.73.107', 'WebKit', 'desktop', 'Chrome 138.0.0.0', 'Windows 10.0', 'Chile', '2025-08-08 09:15:11', '2025-08-08 13:52:51'),
(8, 1, '60.254.14.192', 'Macintosh', 'desktop', 'Safari 18.6', 'OS X 10_15_7', NULL, '2025-08-08 04:21:38', '2025-09-16 03:05:47'),
(9, 6, '106.215.182.200', 'WebKit', 'phone', 'Chrome 138.0.0.0', 'AndroidOS 10', 'India', '2025-08-08 10:56:39', '2025-08-08 12:36:50'),
(10, 7, '152.58.43.227', 'WebKit', 'phone', 'Chrome 130.0.0.0', 'AndroidOS 10', 'India', '2025-08-08 10:57:21', '2025-09-17 21:44:04'),
(11, 12, '106.215.182.200', 'WebKit', 'phone', 'Chrome 138.0.0.0', 'AndroidOS 10', 'India', '2025-08-08 11:02:36', '2025-08-08 11:21:05'),
(12, 12, '106.215.182.200', 'WebKit', 'desktop', 'Chrome 138.0.0.0', 'Windows 10.0', 'India', '2025-08-08 11:04:49', '2025-08-08 11:04:49'),
(13, 1, '106.215.182.200', 'WebKit', 'desktop', 'Opera 120.0.0.0', 'Windows 10.0', NULL, '2025-08-08 11:12:45', '2025-08-08 11:12:45'),
(14, 12, '106.215.182.200', '0', 'desktop', 'Firefox 141.0', 'Windows 10.0', 'India', '2025-08-08 11:22:56', '2025-08-08 11:22:56'),
(15, 7, '106.215.182.200', 'WebKit', 'phone', 'Chrome 138.0.0.0', 'AndroidOS 10', 'India', '2025-08-08 12:27:06', '2025-08-08 12:44:00'),
(16, 2, '186.189.73.107', 'WebKit', 'desktop', 'Chrome 138.0.0.0', 'Windows 10.0', 'Chile', '2025-08-08 12:58:07', '2025-08-08 13:47:19'),
(17, 2, '176.29.241.204', 'WebKit', 'phone', 'Chrome 139.0.0.0', 'AndroidOS 10', 'Jordan', '2025-08-08 13:13:11', '2025-08-25 18:54:53'),
(18, 6, '176.29.241.204', 'WebKit', 'phone', 'Chrome 139.0.0.0', 'AndroidOS 10', 'Jordan', '2025-08-08 13:17:49', '2025-08-25 18:58:37'),
(19, 2, '72.201.11.95', 'Macintosh', 'desktop', 'Chrome 139.0.0.0', 'OS X 10_15_7', 'United States', '2025-08-14 15:45:20', '2025-08-14 15:45:20'),
(20, 7, '72.201.11.95', '0', 'desktop', ' ', ' ', 'United States', '2025-08-15 04:11:07', '2025-08-15 04:11:07'),
(21, 2, '106.222.218.120', 'WebKit', 'desktop', 'Chrome 139.0.0.0', 'Windows 10.0', 'India', '2025-08-18 10:46:25', '2025-09-08 10:45:30'),
(22, 7, '176.29.241.204', 'WebKit', 'phone', 'Chrome 139.0.0.0', 'AndroidOS 10', 'Jordan', '2025-08-25 19:00:36', '2025-08-25 19:00:36'),
(23, 1, '152.59.190.189', 'WebKit', 'desktop', 'Chrome 139.0.0.0', 'Windows 10.0', NULL, '2025-08-28 06:03:59', '2025-08-28 10:51:06'),
(24, 6, '106.222.218.120', 'WebKit', 'desktop', 'Chrome 139.0.0.0', 'Windows 10.0', 'India', '2025-09-08 09:17:43', '2025-09-08 11:13:35'),
(25, 7, '106.222.218.120', 'WebKit', 'desktop', 'Chrome 139.0.0.0', 'Windows 10.0', 'India', '2025-09-08 10:33:56', '2025-09-08 11:14:35'),
(26, 2, '146.75.165.32', 'iPhone', 'phone', 'Safari 18.6', 'iOS 18_6_2', 'United States', '2025-09-14 09:07:22', '2025-09-14 09:07:22'),
(27, 7, '60.254.14.192', 'Macintosh', 'desktop', 'Safari 18.6', 'OS X 10_15_7', 'India', '2025-09-15 01:53:04', '2025-09-16 02:53:33'),
(28, 2, '60.254.14.192', 'Macintosh', 'desktop', 'Safari 18.6', 'OS X 10_15_7', 'India', '2025-09-15 02:25:51', '2025-09-16 02:54:15'),
(29, 1, '152.58.153.50', 'WebKit', 'desktop', 'Chrome 140.0.0.0', 'Windows 10.0', NULL, '2025-09-15 06:44:01', '2025-09-16 05:45:46'),
(30, 6, '66.69.65.158', 'WebKit', 'desktop', 'Chrome 132.0.0.0', 'Windows 10.0', 'United States', '2025-09-15 16:34:40', '2025-09-16 21:50:09'),
(31, 7, '66.69.65.158', 'WebKit', 'desktop', 'Chrome 132.0.0.0', 'Windows 10.0', 'United States', '2025-09-15 17:05:08', '2025-09-15 17:05:08'),
(32, 2, '66.69.65.158', 'WebKit', 'desktop', 'Chrome 132.0.0.0', 'Windows 10.0', 'United States', '2025-09-15 17:33:29', '2025-09-16 02:13:44'),
(33, 2, '122.170.198.82', 'WebKit', 'desktop', 'Chrome 140.0.0.0', 'Windows 10.0', 'India', '2025-09-17 09:17:31', '2025-09-17 09:17:31'),
(34, 6, '66.69.65.158', 'WebKit', 'desktop', 'Edge 140.0.0.0', 'Windows 10.0', 'United States', '2025-09-18 23:56:36', '2025-09-18 23:56:36'),
(35, 1, '60.254.7.37', 'Macintosh', 'desktop', 'Safari 26.0', 'OS X 10_15_7', NULL, '2025-09-27 02:30:33', '2025-09-27 03:37:43'),
(36, 6, '104.28.50.208', 'iPhone', 'phone', 'Safari 18.6', 'iOS 18_6_2', 'United States', '2025-09-27 03:49:09', '2025-09-27 03:49:09');

-- --------------------------------------------------------

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `updates_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `type` varchar(100) NOT NULL,
  `image` varchar(255) NOT NULL,
  `width` varchar(5) DEFAULT NULL,
  `height` varchar(5) DEFAULT NULL,
  `img_type` varchar(255) NOT NULL,
  `video` varchar(255) NOT NULL,
  `encoded` enum('yes','no') NOT NULL DEFAULT 'no',
  `video_poster` varchar(255) DEFAULT NULL,
  `duration_video` varchar(50) DEFAULT NULL,
  `quality_video` varchar(20) DEFAULT NULL,
  `video_embed` varchar(200) NOT NULL,
  `music` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` varchar(255) NOT NULL,
  `bytes` varchar(255) DEFAULT NULL,
  `mime` varchar(255) DEFAULT NULL,
  `token` varchar(255) NOT NULL,
  `status` enum('active','pending') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `job_id` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `updates_id`, `user_id`, `type`, `image`, `width`, `height`, `img_type`, `video`, `encoded`, `video_poster`, `duration_video`, `quality_video`, `video_embed`, `music`, `file`, `file_name`, `file_size`, `bytes`, `mime`, `token`, `status`, `created_at`, `updated_at`, `job_id`) VALUES
(1, 1, 2, 'image', '267e394732e0c41742967923pcyjxsbpspjtblinqhuh.jpg', '1900', '1267', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '318535', 'image/jpeg', 'Tj94uNAJiYJJaAEHV8zmdixNkpgIyQ6RzWQQlFqsiHJvCbDYWLn9bkzvDq5ytmPDFCXgLCSpJ5pSYrnENFg6NvLkbxbjfkf6JhONY32D9AoqerxeqiwrQwR4pUpiJFhR1nFUzb2QYbNhEnYLNPpjrD67e3947340cf91742967923', 'active', '2025-03-26 05:45:23', '2025-03-26 05:45:37', NULL),
(2, 2, 4, 'image', '467e3979e12d5217429687341vtzwp9egje0a5zt5v0j.jpg', '1900', '1135', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '401970', 'image/jpeg', 'LA85URXgNUzo26qWrfEdn6pOHGJLGFPyxwmxi7ZnpduteD3W273kGX3QvGkkPLEBfe6mFIncS3lZThaW5H820LSTIzm3TTe8hXQ3ARox1qpoe1BDlZAYdzlllaJP4d7GmOi2WS0p8IqAG9AyblPzVm67e3979e23ec01742968734', 'active', '2025-03-26 05:58:54', '2025-03-26 05:58:56', NULL),
(3, 3, 7, 'video', '', NULL, NULL, '', '767e677b9044e21743157177ndtwacc6mu3ym1bt4nwk.mp4', 'no', '', NULL, NULL, '', '', '', '', '', '1570024', 'video/mp4', 'Og48OLEJSXGZiwknjLi80fJHHizyTNGVa6X2TxGsokLpTNyW64SBWXrpQ3AVCtCUPJcpo3wn8TnzEuyEI3bY0CltkCfwTfxR6FmrfcGZiYWGGSE2b5wqtF7bO91CaD4GENINkHgTveOOXqHxiDqrVc67e677b9046f41743157177', 'active', '2025-03-28 10:19:37', '2025-03-28 10:19:53', NULL),
(5, 6, 1, 'image', '16895ddf34c38f1754652147qwln2koqlnmgggxteyx7.png', '740', '416', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '297366', 'image/png', 'CFaT0aew3UVEredThHnbJCHJZqM1bvHzDpM44JCepHmMjJdGlFdqSdzEl4yl813X7f7vtfSiEl2dJwAhI546edNyc9ddJApxJv3BRmZG4H7djwS8ap9t8LtmpD6X3nxoIqhVXEatmF9RIfdBosqrlq6895ddf350f9e1754652147', 'active', '2025-08-08 11:22:27', '2025-08-08 11:22:30', NULL),
(6, 7, 1, 'image', '16895de4f19a0c175465223967aaef0bfnfjsr2znyb1.png', '900', '510', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '524970', 'image/png', 'XNCGR1lxytTuf1ktFhyGVM0rAN6QSaXe3BSkD1YUPAZdnT30fsckamUkVYIoaAbU0mrWfmb8s7YXWBWSbM8XPCBR90BlZdcoKpmuxHfwLy3lgGRsOOfGQfhjisvrNzDCTzDnlfiK3vB0SmSMvE04Zj6895de4f1fa011754652239', 'active', '2025-08-08 11:23:59', '2025-08-08 11:24:01', NULL),
(7, 8, 1, 'image', '16895defcb88281754652412z1wokhlfa91wyuzxyold.jpg', '906', '515', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '61559', 'image/jpeg', 'sV3ReP3fNKyI9twvA4uSS6p1tbcDJO5eWL6uBQScJrJ0sZmKizdPKYg449uNWYb93ODIF6Wa23KdENMBaqfaIJgu7Uy0MChgi4CU29CobwgkrmlLdn03jRqHEdHJnBAPZAMTA7Cy1OkH2jxOyla57J6895defcbc87d1754652412', 'active', '2025-08-08 11:26:52', '2025-08-08 11:27:07', NULL),
(8, 9, 7, 'image', '76895e0d528b1b175465288538xxiqmu980hzrgw9zam.jpg', '612', '408', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '74442', 'image/jpeg', '9nO4AV8rzshclPQtPcAG90d4CskdSkNz3eZcJ9RbQXGJ7qyWBg8zh2T6C8qTiwyGZq3wh8CeNgEcnRHemnHQsZrn48sXkNzNCkdY9a9VygATAP7bth6cI5XTeHxpjAvjD4vaodEjbypX1yjCGpFVPF6895e0d52c86c1754652885', 'active', '2025-08-08 11:34:45', '2025-08-08 11:34:48', NULL),
(9, 10, 7, 'image', '76895e10d8fd741754652941eaiftzuneofgxpkwbvq7.jpg', '1200', '673', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '778864', 'image/jpeg', 'BPXTtXIz85br4GrLUtLirsBpBth0fmn38GT6pfqN2ko0YQez4LPRIXvEhze3CWs7zqDl8NLs1fOakXNWXit7AQZqU6RnFxhhb1JAzNNZ5BryGktDVUbIYFgebNiyTomk3wZZRlt8P4TPgcdW77EVGp6895e10d993901754652941', 'active', '2025-08-08 11:35:41', '2025-08-08 11:35:45', NULL),
(10, 11, 7, 'image', '76895e1b357e9c1754653107ttktfjzhbpipdqwbc6qd.jpg', '612', '408', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '40790', 'image/jpeg', 'h316Cf9y7Ff6ccJVO6mA25bLMe1eImek2I2hRL1aO8BzihR0yZKaVjcTIuADCmYDPYgmaz7YbnWZaPzatM5P0KA9fSZSoljNBZexpfX1Tz3cb235kFOYgtcEt4k3NUQDdehm8abkXiu5YyOiXnCTF16895e1b35b80a1754653107', 'active', '2025-08-08 11:38:27', '2025-08-08 11:38:44', NULL),
(11, 12, 2, 'image', '26895e290ac22e1754653328mw2e7pj8eeqixoueeijr.png', '1980', '1320', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '1352812', 'image/png', 'TaslJyDecPYyWbMIKxrlPd2oiUfNczTeprkHqZon99N6vmFmWVO6xGnxOHK9ggVU8oe9KTpnXK7kpjDmgAqP7U9VCcnnRXqehCuRE7P5MzgKmF62vfIwXJJw1V8dV6Yjwh4tGyK2FMGXGzzO7aIUXW6895e290c10b81754653328', 'active', '2025-08-08 11:42:09', '2025-08-08 11:42:11', NULL),
(12, 13, 2, 'image', '26895e2bc835ab1754653372zqi0v7wvy0dfvstqavtm.jpg', '1180', '600', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '66658', 'image/jpeg', 'eTVhtutNAJt7OpCcgNG3gwAM7cjreRynmeNdfbcC1S1VOmnFbJmzWsvg4e4U82jzmjObWuAszURkYwTJwl3X2nZ1bFIp2C2P2DQ2dY5LfV72w0s09G3FUn0pvW1Pma0O7iWnYoaU4i02rf4d9jlxnH6895e2bc86d051754653372', 'active', '2025-08-08 11:42:52', '2025-08-08 11:42:55', NULL),
(13, 14, 2, 'image', '26895e2e0d50411754653408qt0uak5jbaeneecxhoin.jpg', '1071', '720', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '74995', 'image/jpeg', 'nuK5rFfFBA3yJmed0mwZFuofIulLZ29NmUoqo0VCvPcfLEBzpZBwvRplWfqS3nzjrTCBBR8VceTbvOm9p2ZhmgDLQjd4ybbpml4X7um141NiZYuYrC226iLKIzGHYzgVWLSY9Rn5HZVHsuyRToNsw16895e2e0d9d1a1754653408', 'active', '2025-08-08 11:43:29', '2025-08-08 11:43:31', NULL),
(14, 15, 3, 'image', '36895e3a3dc6d31754653603kxwted15q6ks77bvsmmd.png', '1920', '1080', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '1444385', 'image/png', 'jBdMjhrss1PPvOtYSyj27cgDixJoINURQzu8JCUNsKZ7JT5USqNLodk8lJwkA6VUTfH2FeYbYzvpwObSHdAIa9xMWCXQLzWe0BbGFTIu3F3bA6XehHm8EipPrS6MwKkwcF7NQEt5OzHZ9aM4gTgA956895e3a3ec53c1754653603', 'active', '2025-08-08 11:46:44', '2025-08-08 11:46:46', NULL),
(15, 16, 3, 'image', '36895e3dd966cc1754653661tkjybqxt655kessricql.png', '2287', '1589', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '2998234', 'image/png', 'cZTl0eVCO8HIM7C9ssGogxaDetYMO05dtBBznlpHx9BMyky7rzg5JqFtCRvNA3jx0PDhgCra8Ne3ckiTo7NNAKLtsgsQFQ9HNoz4h5ucRANzbknxsqJGKQofiULVg7O5dp1exlYR3pPg6PZMWG3N3L6895e3ddb326a1754653661', 'active', '2025-08-08 11:47:43', '2025-08-08 11:47:53', NULL),
(16, 17, 3, 'image', '36895e4077036f1754653703h1jh3tgvji6zjjco8cku.jpg', '1024', '576', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '77810', 'image/jpeg', 'pLh6dF4CCrftir9VW4nOKeWTjEa8yxQ30zvPiByH29yPeGPqkvD6lxClNEvHXU7PPWMh9y1dV3ILUXaAf1LtWcbGdEbmT97OhRalvfv6UjHB2qgiAxwfzMroVWHglap1DYGbqDh5ijSkZbhlDd40w36895e40773ea11754653703', 'active', '2025-08-08 11:48:23', '2025-08-08 11:48:25', NULL),
(17, 18, 4, 'image', '46895e492a49911754653842lfp5gf8xrc35i9j6l8gk.png', '2400', '1800', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '1549995', 'image/png', 'FH3hN8Mnj0jjTTOiGnaWcDnpZC1EU75spcuIK9p2slVL2pCFYndO00EVAEFetexhXuwhPYrzGpDgTDAP2josleI0mOdbcZIrxcmNxvPhg9bt6fIoTAHJtTKtsSJKnIQ0kNOyoFVOnFst2bCQOvbRJm6895e492c26811754653842', 'active', '2025-08-08 11:50:43', '2025-08-08 11:50:49', NULL),
(18, 19, 4, 'image', '46895e4c079d531754653888odr59lydm3bdlfqcohbz.jpg', '1200', '900', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '384963', 'image/jpeg', '2SHEkTVFBaGvdhsbGL9f0FPx192NFKmHTB4yp9CBXLzJq6hC5Pg0D0nYjHa1MXsbz9CUu5HFQvMPKF2zFBD6yawkhn2i0ZXVdNhfBkaz4j9gQs2iCLkJGTumF4RszbFOfb1oiUHqdw7PpZcKlUon1Q6895e4c08212c1754653888', 'active', '2025-08-08 11:51:28', '2025-08-08 11:51:30', NULL),
(19, 20, 4, 'image', '46895e507a7cf51754653959inb4nzt9rwf8cplz1wri.png', '1024', '575', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '379968', 'image/png', 'qvrRKroogLpjhN8bXTJFg2qGYeT06eDXNLcoA2owzNqTWGF0AgssGFcVETpfTUFureflwRgMziYVfMWIL4Nlsh3m3dKxm11B80gpjhLsNb6Kg4LSaM2rzyxzg16bfddPtiVkn8qqoVuJdSaogG9Dfq6895e507ae3731754653959', 'active', '2025-08-08 11:52:39', '2025-08-08 11:52:42', NULL),
(20, 21, 5, 'image', '56895e5c106f651754654145ojyib3su4d6za1zabfek.png', '1920', '1080', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '2747315', 'image/png', 'GwTVbimCAD5QwGi56UU4Iz19CrG4rzh3cfFpZV0OzhcrysZT6TP2mtBqZztD2bUCuq9NGDC5N9aNo1fcHzSobUDvPfP6Mq87HIQjpReqDvv98eok4zr4dCg0hWSIPClj7dnfwCBTI5X0vQk0tYauZg6895e5c11a0121754654145', 'active', '2025-08-08 11:55:46', '2025-08-08 11:55:48', NULL),
(21, 22, 5, 'image', '56895e5e502ffc1754654181zh5aasn6lnlucruwgopc.jpg', '1200', '1016', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '167078', 'image/jpeg', 'iOqvPjiOFCwvkzpPU0FXdvq7YDFWsUjj3ovwHcWlMap0IOPJke7W6fXhLJ6PM9bZaOnl3KqRnpsiXDX3BfhHewwUpuCGc2OROFLFRMNbnDNguJCIzXBEZuj5lMJmb8rqYOl3Ja8gH03ziCd1ZMV7JV6895e5e509e6e1754654181', 'active', '2025-08-08 11:56:21', '2025-08-08 11:56:23', NULL),
(22, 23, 5, 'image', '56895e61552e4c1754654229pe7ubtd9twzjn5qup6lw.png', '780', '520', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '362866', 'image/png', 'dN6jk3j2lRlnQRsOJ9HrkG8N3toQpNi8T9jOnKfww0pSGtp7thJhR5JkLwLyb7c1Wo08WRU85RcervUS0axkrkUPclUVtW548ks83u1mEMBpGURzCAP8WIHIlNiIEIAvmGYry0aAL33Wq07Ny9Op0f6895e615583ce1754654229', 'active', '2025-08-08 11:57:09', '2025-08-08 11:57:12', NULL),
(23, 24, 5, 'image', '56895e650b1f041754654288fxjjtnwed6hoylxz5njc.jpg', '1200', '1200', '', '', 'no', NULL, NULL, NULL, '', '', '', '', '', '104515', 'image/jpeg', 'wuOA9vZJxBo66mERFoQ5C9v9RoreMJfpGX9uXk8EDyGelCBPTKGAxVj8SEDBL1VMVoWpSuLeM3Jmb1KgRNSUNvu1TIIy1HdY9n2pJDEGLZcjCsiP9Dg7WZjV6gB53bvVxRHEItTs9Ze75aVro1VEpB6895e650b78f81754654288', 'active', '2025-08-08 11:58:08', '2025-08-08 11:58:11', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `media_messages`
--

CREATE TABLE `media_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `messages_id` int(10) UNSIGNED NOT NULL,
  `type` varchar(100) NOT NULL,
  `file` varchar(255) NOT NULL,
  `width` varchar(5) DEFAULT NULL,
  `height` varchar(5) DEFAULT NULL,
  `video_poster` varchar(255) DEFAULT NULL,
  `duration_video` varchar(50) DEFAULT NULL,
  `quality_video` varchar(20) DEFAULT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `status` enum('active','pending') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `encoded` enum('yes','no') NOT NULL DEFAULT 'no',
  `job_id` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_messages`
--

INSERT INTO `media_messages` (`id`, `messages_id`, `type`, `file`, `width`, `height`, `video_poster`, `duration_video`, `quality_video`, `file_name`, `file_size`, `token`, `status`, `created_at`, `updated_at`, `encoded`, `job_id`) VALUES
(1, 10, 'zip', '61754654575bpxqc5l0ihvznqnk9utp.zip', NULL, NULL, NULL, NULL, NULL, 'sample-zip-file', '380', 'NK5e73lb89MZJ2HTJVioYuXK3H9sPaJb2RhVqy5lx2NI8drF2TyFzl4FDeIR9BbtpzFIcxwzZ9ZSPC1KrQg2JcmouQuMB682hBT0cmSETdRpHosw23Njb8UwdGai3ghkmWe5tTWENPQQwQzCWyKWKV6895e76f072461754654575', 'active', '2025-08-08 12:02:55', '2025-08-08 12:02:55', 'no', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `media_products`
--

CREATE TABLE `media_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `products_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_products`
--

INSERT INTO `media_products` (`id`, `products_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, '167e6936193af11743164257v3siykfdo1odyirzpv8s.png', '2025-03-28 12:18:37', '2025-03-28 12:18:37'),
(2, 2, '167eb7cc4bceec1743486148ipnh0ya8gquwhwyqq4un.jpg', '2025-04-01 05:43:12', '2025-04-01 05:43:12'),
(3, 3, '167eb7dc55aae51743486405eyysp25j0sti5el5frzz.png', '2025-04-01 05:47:23', '2025-04-01 05:47:23'),
(4, 4, '167eb7f757d9321743486837lpukuufavuk0lms9cpt3.jpg', '2025-04-01 05:54:33', '2025-04-01 05:54:33'),
(5, 5, '167eb804c8685117434870529zujabkhqcrpq7s6id65.jpg', '2025-04-01 05:57:42', '2025-04-01 05:57:42'),
(6, 13, '167eb82c6de68f1743487686ckxrhbius0cxxntwmwi3.jpg', '2025-04-01 06:08:25', '2025-04-01 06:08:25'),
(7, 14, '367eb845c0db721743488092mtykweiykuuz9w928evy.jpg', '2025-04-01 06:15:00', '2025-04-01 06:15:00'),
(8, 15, '167eb84a8989fe1743488168t918xvrun0sfoiwhj8ma.jpg', '2025-04-01 06:16:17', '2025-04-01 06:16:17'),
(9, 16, '367eb84e57c6ba17434882294zv8e4hg8adsez5xjxof.jpg', '2025-04-01 06:17:11', '2025-04-01 06:17:11'),
(10, 17, '367eb84fca82081743488252jj45aubiagvpk49zhqcz.jpg', '2025-04-01 06:17:50', '2025-04-01 06:17:50'),
(11, 18, '267eb855a81f9d1743488346o9yygvszlcnkhpstnxjx.png', '2025-04-01 06:19:23', '2025-04-01 06:19:23'),
(12, 19, '267eb85839d45f1743488387ehp8dnzhdb1rz8vyygzg.jpg', '2025-04-01 06:20:03', '2025-04-01 06:20:03'),
(13, 20, '267eb85a34c5c51743488419eoyzotcrgr2clnwzt8vf.jpg', '2025-04-01 06:20:40', '2025-04-01 06:20:40'),
(14, 21, '267eb85d95c0bd1743488473ehaepaddme7wmq62rl5a.jpg', '2025-04-01 06:21:27', '2025-04-01 06:21:27'),
(15, 22, '267eb86062b10d1743488518w5yfqhlxeigeguaxxuxm.png', '2025-04-01 06:22:47', '2025-04-01 06:22:47'),
(16, 23, '567eb86a1d5a981743488673pzo6g4vp2eptkahwu3ok.jpg', '2025-04-01 06:24:52', '2025-04-01 06:24:52'),
(17, 24, '567eb86c80742a17434887129hwr7zooa2p8kwtj1zf7.jpg', '2025-04-01 06:25:23', '2025-04-01 06:25:23'),
(18, 25, '567eb86e44c2b51743488740d1vetkqjaz7t27oy5q5v.jpg', '2025-04-01 06:26:00', '2025-04-01 06:26:00');

-- --------------------------------------------------------

--
-- Table structure for table `media_reels`
--

CREATE TABLE `media_reels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reels_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `video_poster` varchar(255) DEFAULT NULL,
  `duration_video` varchar(255) DEFAULT NULL,
  `job_id` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `media_stories`
--

CREATE TABLE `media_stories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `stories_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(100) NOT NULL,
  `video_length` varchar(20) DEFAULT NULL,
  `video_poster` varchar(100) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `font_color` varchar(50) NOT NULL DEFAULT '#ffffff',
  `font` varchar(50) NOT NULL DEFAULT 'Arial',
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `job_id` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_stories`
--

INSERT INTO `media_stories` (`id`, `stories_id`, `name`, `type`, `video_length`, `video_poster`, `text`, `font_color`, `font`, `status`, `created_at`, `updated_at`, `job_id`) VALUES
(1, 1, '1743160796ZRpWUZQrQ4D7MvdXQut2Ue7TbeC6rMTFtb5R4LeGnGQRZfWyf1.png', 'photo', '', '', 'new', '#ffffff', 'Arial', 1, '2025-03-28 11:19:56', '2025-03-28 11:19:56', NULL),
(2, 2, '17433940883ZbrGDjQQ64bA46qvSAEimIG4VUOvCG1LBJHuG7lgDf3a2dbHw.jpg', 'photo', '', '', 'Nice Day', '#ffffff', 'Arial', 1, '2025-03-31 04:08:08', '2025-03-31 04:08:08', NULL),
(4, 4, '174339502314krwf4J8RRgDkhoZgRdQeMXZX6bc6rXmGUXT3f5ePgPRetItn.jpg', 'photo', '', '', '55', '#ffffff', 'Arial', 1, '2025-03-31 04:23:43', '2025-03-31 04:23:43', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `media_welcome_messages`
--

CREATE TABLE `media_welcome_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `creator_id` int(10) UNSIGNED NOT NULL,
  `type` varchar(100) NOT NULL,
  `file` varchar(255) NOT NULL,
  `width` varchar(5) DEFAULT NULL,
  `height` varchar(5) DEFAULT NULL,
  `video_poster` varchar(255) DEFAULT NULL,
  `duration_video` varchar(50) DEFAULT NULL,
  `quality_video` varchar(20) DEFAULT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` varchar(255) NOT NULL,
  `file_size_bytes` varchar(255) DEFAULT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `encoded` enum('yes','no') NOT NULL DEFAULT 'no',
  `token` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `job_id` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `conversations_id` int(10) UNSIGNED NOT NULL,
  `from_user_id` int(10) UNSIGNED NOT NULL,
  `to_user_id` int(10) UNSIGNED NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attach_file` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` enum('new','readed') NOT NULL DEFAULT 'new',
  `remove_from` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0 Delete, 1 Active',
  `file` varchar(150) NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `format` varchar(10) NOT NULL,
  `size` varchar(50) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `tip` enum('yes','no') NOT NULL DEFAULT 'no',
  `tip_amount` int(10) UNSIGNED NOT NULL,
  `mode` enum('active','pending') NOT NULL DEFAULT 'active',
  `gift_id` int(10) UNSIGNED DEFAULT NULL,
  `gift_amount` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `conversations_id`, `from_user_id`, `to_user_id`, `message`, `attach_file`, `created_at`, `updated_at`, `status`, `remove_from`, `file`, `original_name`, `format`, `size`, `price`, `tip`, `tip_amount`, `mode`, `gift_id`, `gift_amount`) VALUES
(1, 0, 1, 4, '', '', '2025-03-31 05:25:41', '2025-03-31 05:25:41', 'readed', '1', '', '', '', '', 0.00, 'yes', 5, 'active', NULL, 0.00),
(2, 0, 1, 4, 'Hey there😰', '', '2025-03-31 05:25:56', '2025-03-31 05:25:56', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(3, 0, 4, 1, 'Hey', '', '2025-03-31 05:27:49', '2025-03-31 05:27:50', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(4, 0, 6, 1, 'hi', '', '2025-08-08 11:58:42', '2025-08-08 11:58:42', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(5, 0, 6, 1, 'hello friemd', '', '2025-08-08 11:58:59', '2025-08-08 11:59:00', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(6, 0, 1, 6, 'hi', '', '2025-08-08 11:59:23', '2025-08-08 11:59:23', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(7, 0, 6, 1, 'sdf', '', '2025-08-08 11:59:33', '2025-08-08 11:59:33', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(8, 0, 1, 6, 'hi', '', '2025-08-08 11:59:39', '2025-08-08 11:59:40', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(9, 0, 1, 6, 'ewrre', '', '2025-08-08 12:00:07', '2025-08-08 12:00:07', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(10, 0, 6, 1, 'Collection', '', '2025-08-08 12:02:55', '2025-08-08 12:02:55', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(11, 0, 1, 6, '😄', '', '2025-08-08 12:03:48', '2025-08-08 12:03:49', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00),
(12, 0, 6, 2, 'hi', '', '2025-09-08 09:29:40', '2025-09-08 09:29:40', 'readed', '1', '', '', '', '', 0.00, 'no', 0, 'active', NULL, 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(10) UNSIGNED NOT NULL,
  `destination` int(10) UNSIGNED NOT NULL,
  `author` int(10) UNSIGNED NOT NULL,
  `target` int(10) UNSIGNED NOT NULL,
  `type` int(10) UNSIGNED NOT NULL COMMENT '1 Subscribed, 2  Like, 3 reply, 4 Like Comment',
  `status` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0 unseen, 1 seen',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `destination`, `author`, `target`, `type`, `status`, `created_at`) VALUES
(1, 2, 2, 2, 18, '1', '2025-03-26 05:44:12'),
(2, 3, 3, 3, 18, '0', '2025-03-26 05:51:41'),
(3, 4, 4, 4, 18, '1', '2025-03-26 05:57:40'),
(4, 5, 5, 5, 18, '1', '2025-03-26 06:04:09'),
(5, 7, 7, 7, 18, '1', '2025-03-28 08:34:31'),
(6, 6, 6, 6, 19, '1', '2025-03-28 09:37:25'),
(8, 4, 6, 4, 1, '1', '2025-03-28 10:10:52'),
(9, 4, 6, 2, 2, '1', '2025-03-28 10:10:59'),
(10, 4, 6, 6, 26, '1', '2025-03-28 10:11:22'),
(11, 7, 6, 7, 1, '1', '2025-03-28 10:20:51'),
(13, 7, 6, 3, 2, '1', '2025-03-28 10:21:19'),
(14, 6, 7, 1, 14, '1', '2025-03-28 10:50:21'),
(15, 6, 7, 2, 14, '1', '2025-03-28 10:53:09'),
(19, 4, 1, 1, 5, '1', '2025-03-31 05:25:41'),
(20, 2, 1, 1, 2, '1', '2025-03-31 05:34:46'),
(21, 4, 1, 4, 1, '0', '2025-03-31 05:35:41'),
(22, 2, 6, 1, 2, '1', '2025-08-07 15:51:20'),
(24, 12, 12, 12, 18, '1', '2025-08-08 11:13:29'),
(25, 7, 6, 7, 1, '1', '2025-08-08 11:43:00'),
(26, 1, 6, 1, 1, '1', '2025-08-08 11:43:07'),
(27, 1, 6, 8, 3, '1', '2025-08-08 11:43:26'),
(28, 1, 6, 8, 2, '1', '2025-08-08 11:43:29'),
(29, 5, 6, 25, 15, '0', '2025-08-08 11:43:30'),
(30, 7, 6, 3, 3, '1', '2025-08-08 12:05:52'),
(31, 5, 7, 23, 15, '0', '2025-08-08 12:06:26'),
(32, 7, 6, 6, 5, '1', '2025-08-08 12:07:01'),
(34, 2, 6, 20, 15, '1', '2025-08-08 12:11:31'),
(35, 7, 6, 11, 2, '1', '2025-08-08 12:12:51'),
(37, 2, 6, 14, 2, '1', '2025-08-08 12:13:24'),
(38, 2, 6, 14, 3, '1', '2025-08-08 12:13:47'),
(39, 2, 6, 14, 3, '1', '2025-08-08 12:16:59'),
(40, 2, 7, 2, 1, '1', '2025-08-08 12:19:35'),
(41, 2, 7, 13, 2, '1', '2025-08-08 12:19:46'),
(43, 2, 6, 6, 5, '1', '2025-09-08 09:29:28'),
(44, 3, 6, 17, 15, '0', '2025-09-15 16:41:41'),
(45, 5, 6, 5, 1, '0', '2025-09-15 16:56:02'),
(46, 1, 6, 3, 15, '1', '2025-09-15 17:45:57'),
(47, 1, 6, 7, 2, '0', '2025-09-27 03:50:57');

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(150) NOT NULL,
  `content` mediumtext DEFAULT NULL,
  `slug` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `lang` char(10) NOT NULL DEFAULT 'es',
  `access` varchar(50) NOT NULL DEFAULT 'all'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `content`, `slug`, `description`, `keywords`, `lang`, `access`) VALUES
(2, 'Terms of Service', '<p>Welcome to <strong>MxThrillz</strong>!</p>\n\n<p>These Terms and Conditions (&quot;Terms&quot;) govern your use of our website located at [<a href=\"http://www.mxthrillz.mimeld.com\" rel=\"noopener\" target=\"_new\">www.mxthrillz.mimeld.com</a>] (the &quot;Site&quot;). By accessing or using MxThrillz, you agree to comply with and be bound by these Terms. If you do not agree to these Terms, please do not use the Site.</p>\n&nbsp;\n\n<h2>1. Use of the Site</h2>\n\n<ul>\n	<li>\n	<p>MxThrillz is intended for informational and demonstration purposes only.</p>\n	</li>\n	<li>\n	<p>You agree not to use the Site for any unlawful purpose or in violation of any local, state, national, or international law.</p>\n	</li>\n	<li>\n	<p>You may not interfere with or disrupt the Site or servers connected to the Site.</p>\n	</li>\n</ul>\n&nbsp;\n\n<h2>2. Intellectual Property</h2>\n\n<ul>\n	<li>\n	<p>All content on MxThrillz, including text, images, graphics, and logos, is the property of MxThrillz or its content suppliers.</p>\n	</li>\n	<li>\n	<p>You may not reproduce, distribute, modify, or republish any content from the Site without prior written permission.</p>\n	</li>\n</ul>\n&nbsp;\n\n<h2>3. Disclaimer</h2>\n\n<ul>\n	<li>\n	<p>MxThrillz is a demo site and does not represent a live or functioning product or service.</p>\n	</li>\n	<li>\n	<p>Content on the Site is provided &quot;as is&quot; and for demonstration purposes only. We make no warranties regarding the accuracy, reliability, or completeness of any content.</p>\n	</li>\n</ul>\n&nbsp;\n\n<h2>4. Limitation of Liability</h2>\n\n<ul>\n	<li>\n	<p>In no event shall MxThrillz, its creators, or affiliates be liable for any damages arising from your use of or inability to use the Site.</p>\n	</li>\n	<li>\n	<p>This includes, but is not limited to, direct, indirect, incidental, punitive, and consequential damages.</p>\n	</li>\n</ul>\n&nbsp;\n\n<h2>5. Third-Party Links</h2>\n\n<ul>\n	<li>\n	<p>The Site may contain links to third-party websites. We do not control or endorse these sites and are not responsible for their content or privacy practices.</p>\n	</li>\n</ul>\n&nbsp;\n\n<h2>6. Changes to Terms</h2>\n\n<ul>\n	<li>\n	<p>We may update these Terms at any time. Updates will be posted on this page with a revised &quot;Last updated&quot; date.</p>\n	</li>\n	<li>\n	<p>Your continued use of the Site after any changes means you accept the revised Terms.</p>\n	</li>\n</ul>\n&nbsp;\n\n<h2>7. Contact Us</h2>\n\n<p>If you have any questions about these Terms, please contact us at <strong><a data-end=\"2244\" data-start=\"2227\" href=\"https://mxthrillz.mimeld.com/\" rel=\"noopener\">admin@demo.com</a></strong>.</p>', 'terms-of-service', 'Terms of Service of MXThrillz', 'terms, Terms of Service', 'en', 'all'),
(3, 'Privacy', '<p>Welcome to <strong>MxThrillz</strong>.</p>\n\n<p>This Privacy Policy describes how we collect, use, and protect any information you provide while using our website located at [<a href=\"http://www.mxthrillz.mimeld.com\" rel=\"noopener\" target=\"_new\">www.mxthrillz.mimeld.com</a>] (the &ldquo;Site&rdquo;). Since this is a demo website, we do not collect or store real user data, but this policy outlines what would typically apply on a functioning version of the site.</p>\n&nbsp;\n\n<h2>1. Information We May Collect</h2>\n\n<p>For demonstration purposes only, here&rsquo;s the type of data that might be collected on a real website:</p>\n\n<ul>\n	<li>\n	<p><strong>Personal Information</strong>: such as name, email address, or other contact details if provided through a form.</p>\n	</li>\n	<li>\n	<p><strong>Non-Personal Information</strong>: such as browser type, operating system, IP address, and pages visited.</p>\n	</li>\n</ul>\n\n<p><em>Note: MxThrillz does <strong>not</strong> currently collect or store any actual user information.</em></p>\n&nbsp;\n\n<h2>2. How We Use Information</h2>\n\n<p>If MxThrillz were live and collecting data, we might use it to:</p>\n\n<ul>\n	<li>\n	<p>Improve website performance and user experience.</p>\n	</li>\n	<li>\n	<p>Respond to user inquiries or feedback.</p>\n	</li>\n	<li>\n	<p>Analyze traffic and usage trends for internal purposes.</p>\n	</li>\n</ul>\n&nbsp;\n\n<h2>3. Cookies</h2>\n\n<p>For demo purposes, the Site may simulate the use of cookies to show how they would be implemented.</p>\n\n<p>Cookies can help remember user preferences and collect anonymous data about how visitors interact with the site.</p>\n\n<p><em>Since MxThrillz is a demo site, no real cookies are stored on your browser.</em></p>\n&nbsp;\n\n<h2>4. Data Sharing</h2>\n\n<p>MxThrillz does <strong>not</strong> sell, rent, or share personal data with third parties.</p>\n\n<p>If this were a live site, data sharing would only occur with trusted service providers under strict confidentiality agreements, and only if necessary to operate the website.</p>\n&nbsp;\n\n<h2>5. Security</h2>\n\n<p>While no data is stored on this demo site, a live version of MxThrillz would include appropriate technical measures to protect user information from unauthorized access or disclosure.</p>\n&nbsp;\n\n<h2>6. Third-Party Links</h2>\n\n<p>The Site may include links to third-party websites for demonstration purposes. We are not responsible for the privacy practices of these external sites.</p>\n&nbsp;\n\n<h2>7. Changes to This Policy</h2>\n\n<p>We may update this Privacy Policy from time to time. Any changes will be posted here with a new &quot;Last updated&quot; date.</p>\n&nbsp;\n\n<h2>8. Contact Us</h2>\n\n<p>If you have questions about this Privacy Policy or how a live version of MxThrillz would handle data, you can contact us at <strong><a data-end=\"2540\" data-start=\"2523\" rel=\"noopener\">demo@demo.com</a></strong>.</p>', 'privacy', '', '', 'en', 'all'),
(5, 'About us', '<p><strong>Welcome to MxThrillz &mdash; where moments become memories.</strong></p>\n\n<p>MxThrillz is a platform that connects fans with their favorite creators, influencers, and public figures through personalized video messages. Whether it&rsquo;s a birthday surprise, a shoutout, a pep talk, or just a fun interaction, MxThrillz brings authentic, one-of-a-kind moments straight from the people you admire &mdash; to you or someone you love.</p>\n\n<p>We believe in celebrating the connection between fans and talent in a meaningful and personal way. Our mission is simple: <strong>to make joy more accessible, one video at a time.</strong></p>\n\n<h3>What We Do:</h3>\n\n<ul>\n	<li>\n	<p>Let fans <strong>book custom video messages</strong> from their favorite personalities.</p>\n	</li>\n	<li>\n	<p>Give creators a <strong>new way to connect</strong> with their community and monetize their time.</p>\n	</li>\n	<li>\n	<p>Make special occasions even more memorable with a <strong>touch of star power</strong>.</p>\n	</li>\n</ul>\n\n<p>Whether you&#39;re looking to surprise a friend or just treat yourself, MxThrillz is here to help you make it unforgettable.</p>', 'about', '', '', 'en', 'all'),
(8, 'How it works', '<p>Getting a personalized video from your favorite creator on <strong>MxThrillz</strong> is quick, easy, and fun. Here&rsquo;s how it works:</p>\n\n<h3>1. <strong>Browse Creators</strong></h3>\n\n<p>Explore our list of creators, influencers, and personalities. Whether you&#39;re into comedy, sports, music, or entertainment &mdash; there&rsquo;s someone here for everyone.</p>\n\n<h3>2. <strong>Book Your Video</strong></h3>\n\n<p>Found someone awesome? Submit a quick request with details on who the video is for, what you&#39;d like them to say, and any special instructions. Make it personal, funny, or heartfelt&mdash;it&rsquo;s your moment to shine!</p>\n\n<h3>3. <strong>The Creator Records It</strong></h3>\n\n<p>Once your request is submitted, the creator has a few days to record your video. You&rsquo;ll be notified as soon as it&rsquo;s ready.</p>\n\n<h3>4. <strong>Receive &amp; Share</strong></h3>\n\n<p>You&rsquo;ll get a personalized video straight to your inbox. Download it, share it with friends, post it on social media &mdash; or keep it as your own special memory.</p>', 'how-it-works', '', '', 'en', 'all'),
(9, 'Cookies Policy', '<p>This Cookie Policy explains how <strong>MxThrillz</strong> (&quot;we&quot;, &quot;us&quot;, or &quot;our&quot;) uses cookies and similar technologies when you visit our website at [<a href=\"http://www.mxthrillz.mimeld.com\" rel=\"noopener\" target=\"_new\">www.mxthrillz.mimeld.com</a>] (the &quot;Site&quot;).</p>\n&nbsp;\n\n<h2>1. What Are Cookies?</h2>\n\n<p>Cookies are small text files stored on your device (computer, phone, tablet) when you visit a website. They help the site remember your preferences, login info, and browsing activity to enhance your user experience.</p>\n&nbsp;\n\n<h2>2. Types of Cookies We May Use</h2>\n\n<p>If MxThrillz were live, we might use the following types of cookies:</p>\n\n<ul>\n	<li>\n	<p><strong>Essential Cookies</strong> &ndash; Necessary for basic website functionality (e.g. page navigation, access to secure areas).</p>\n	</li>\n	<li>\n	<p><strong>Performance Cookies</strong> &ndash; Help us understand how visitors interact with the site (e.g. analytics).</p>\n	</li>\n	<li>\n	<p><strong>Functionality Cookies</strong> &ndash; Remember choices you&rsquo;ve made (e.g. your username or language preference).</p>\n	</li>\n	<li>\n	<p><strong>Targeting/Advertising Cookies</strong> &ndash; Used to deliver relevant ads or content based on your interests.</p>\n	</li>\n</ul>\n&nbsp;\n\n<h2>3. Third-Party Cookies</h2>\n\n<p>We may use third-party services (like Google Analytics or social media plugins) that set their own cookies to collect anonymous usage data or provide interactive features.</p>\n&nbsp;\n\n<h2>4. Managing Cookies</h2>\n\n<p>You can choose to accept or reject cookies by modifying your browser settings. Most browsers allow you to:</p>\n\n<ul>\n	<li>\n	<p>View which cookies are stored</p>\n	</li>\n	<li>\n	<p>Block all cookies or specific types</p>\n	</li>\n	<li>\n	<p>Delete cookies at any time</p>\n	</li>\n</ul>\n\n<p>Be aware that disabling certain cookies may affect the functionality of the Site.</p>\n&nbsp;\n\n<h2>5. Changes to This Policy</h2>\n\n<p>We may update this Cookie Policy occasionally. Any changes will be posted here with a new &quot;Last updated&quot; date.</p>\n&nbsp;\n\n<h2>6. Contact Us</h2>\n\n<p>If you have any questions about this Cookie Policy or how cookies would be used on a live version of MxThrillz, you can reach out at <strong><a data-end=\"2236\" data-start=\"2219\" rel=\"noopener\">demo@demo.com</a></strong>.</p>', 'cookies', 'Page Cookies Policy', 'cookies, policy', 'en', 'all');

-- --------------------------------------------------------

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` int(10) UNSIGNED NOT NULL,
  `token` varchar(150) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `type` varchar(255) NOT NULL,
  `enabled` enum('1','0') NOT NULL DEFAULT '1',
  `sandbox` enum('true','false') NOT NULL DEFAULT 'true',
  `fee` decimal(3,1) NOT NULL,
  `fee_cents` decimal(6,2) NOT NULL,
  `email` varchar(80) NOT NULL,
  `token` varchar(200) NOT NULL,
  `key` varchar(255) NOT NULL,
  `key_secret` varchar(255) NOT NULL,
  `bank_info` text NOT NULL,
  `recurrent` enum('yes','no') NOT NULL,
  `logo` varchar(50) NOT NULL,
  `webhook_secret` varchar(255) NOT NULL,
  `subscription` enum('yes','no') NOT NULL DEFAULT 'yes',
  `ccbill_accnum` varchar(200) NOT NULL,
  `ccbill_subacc` varchar(200) NOT NULL,
  `ccbill_flexid` varchar(200) NOT NULL,
  `ccbill_salt` varchar(200) NOT NULL,
  `ccbill_subacc_subscriptions` varchar(200) NOT NULL,
  `project_id` varchar(255) DEFAULT NULL,
  `project_secret` varchar(255) DEFAULT NULL,
  `ccbill_datalink_username` varchar(255) DEFAULT NULL,
  `ccbill_datalink_password` varchar(255) DEFAULT NULL,
  `ccbill_skip_subaccount_cancellations` tinyint(1) NOT NULL DEFAULT 0,
  `allow_payments_alipay` tinyint(1) NOT NULL DEFAULT 0,
  `crypto_currency` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` (`id`, `name`, `type`, `enabled`, `sandbox`, `fee`, `fee_cents`, `email`, `token`, `key`, `key_secret`, `bank_info`, `recurrent`, `logo`, `webhook_secret`, `subscription`, `ccbill_accnum`, `ccbill_subacc`, `ccbill_flexid`, `ccbill_salt`, `ccbill_subacc_subscriptions`, `project_id`, `project_secret`, `ccbill_datalink_username`, `ccbill_datalink_password`, `ccbill_skip_subaccount_cancellations`, `allow_payments_alipay`, `crypto_currency`) VALUES
(1, 'PayPal', 'normal', '0', 'true', 5.4, 0.30, '', '02bGGfD9bHevK3eJN06CdDvFSTXsTrTG44yGdAONeN1R37jqnLY1PuNF0mJRoFnsEygyf28yePSCA1eR0alQk4BX89kGG9Rlha2D2KX55TpDFNR5o774OshrkHSZLOFo2fAhHzcWKnwsYDFKgwuaRg', '', '', '', 'yes', 'paypal.png', '', 'yes', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(2, 'Stripe', 'card', '1', 'false', 2.9, 0.30, '', 'asfQSGRvYzS1P0X745krAAyHeU7ZbTpHbYKnxI2abQsBUi48EpeAu5lFAU2iBmsUWO5tpgAn9zzussI4Cce5ZcANIAmfBz0bNR9g3UfR4cserhkJwZwPsETiXiZuCixXVDHhCItuXTPXXSA6KITEoT', 'pk_test_51I6GGiCGv1sRiQlEOisPKrjBqQqqcFsw8mXNaZ2H2baN6R01NulFS7dKFji1NRRxuchoUTEDdB7ujKcyKYSVc0z500eth7otOM', 'sk_test_51I6GGiCGv1sRiQlEi5v1or9eR0HVbuzdMd2rW4n3DxC8UKfz66R4X6n4yYkzvI2LeAIuRU9H99ZpY7XCNFC9xMs500vBjZGkKG', '', 'yes', 'stripe.png', 'whsec_lUmit1gtxwKTveLnSe88xCSDdnPOt8g5', 'yes', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(3, 'Bank', 'bank', '1', 'false', 0.0, 0.00, '', 'MUXRUWEuhBulbgDGUS4PbTCCjlUGr4VcGb59RU2rRWtgCHstntxq2eOeeDvIHKUwxj5z2njJ6DUGfmt0PzFnEWuspasmCserf705dJeQcVttZtHugTlBMlzt0Uf6K4DjVmGVtyZuPzXakjrFGVLYRd', '', '', 'Bank name\r\nBank Number', 'no', '', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(4, 'CCBill', 'card', '0', 'true', 0.0, 0.00, '', 'zYYFZRjTfypGTPg0TCgWK8SKdLjGEMuNGMYedjl1D0hgmSPDS0UUduCNqkYL609NWH6ru6qdaBGFIzxeL85HwEtIOBfEQRC16qIQZ1zkTM1wbcC4fe2Wxpom6g8zmoOR1ppFN6MbPFHUJQur434Nzg', '', '', '', 'yes', '', '', 'yes', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(5, 'Paystack', 'card', '0', 'true', 0.0, 0.00, '', '4w2JnfBSvoZKLiVRzHRWu3pzkgsFslVZBn8Z4mmwzVJ5KVfiFZN9kTgfFEVu90E1wPN8TnaXhtmYKwkzZ0p6HGUo1S5yVXisVxlD2PIOcm6v096akLbMAgjxiXCdFlCALkZXqi4pfrwxpYd7BGFk8c', '', '', '', 'yes', '', '', 'yes', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(6, 'Coinpayments', 'normal', '0', 'true', 0.0, 0.00, '', 'nzfADI4PgRHRn8m3r7UrR0arnfT9u1rDOQL5SKGbqPjDOZGDZA35NX3y0lQBAdmIyGVS58Rr9OtebfpGNpiXROq1G1DJNqq6xoD04fLKWTaAS2Xh3CZvECa1OfH5cchJ2P6kEl167Caax2XyAwwjGl', '', '', '', 'no', 'coinpayments.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(7, 'Mercadopago', 'normal', '0', 'true', 0.0, 0.00, '', 'UmqNKk1EzDyjGgJxAswkhzL8bSdHusZh8RxF4hqzCEf52qdMOAMzMCchsKrLZgPcuTry6AZLLG7DUGwlpXVVpv1CajJbiV3j4EvPqbbIkBCoOptrDWZY1nRJhMc39v6NDOKFo9TjHQdnwU5pZSSReW', '', '', '', 'no', 'mercadopago.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(8, 'Flutterwave', 'normal', '0', 'true', 0.0, 0.00, '', 'jMF4RWTW14dfJxlusZ22jGeCLdc8i3416CNiw2ny4l8kGBILQDTrhLtCsDxmb1MfBQA6xGh5BhQBrOXCUBB8lQMZrCaJQykG3Nxbv0ADFUSJiNewq7kbSkxyR3rCbbVjhBYMtWt6dpJTB78CafpA6T', '', '', '', 'no', 'flutterwave.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(9, 'Mollie', 'normal', '0', 'true', 0.0, 0.00, '', 'EqvhQZimw0L3zWQ35AV93iDOqgQnkXV9cqLnIvgsnz2zRLpjeZUv5JnC3QzTjtctYuVmzuo06N31tLCRPFJNkomdh7Rhk2zxe68GzgWsL1hc6YEM5V5W6JVnqwQfAzNGZkY6ZRFKmZCMbFQXOF3WkR', '', '', '', 'no', 'mollie.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(10, 'Razorpay', 'normal', '0', 'true', 0.0, 0.00, '', 'PsNqGq2rlLjo4AaTTsJpxshttwFFrLXjaKcwwQeG2r8aekDoETl9OG1cqND9PluycCfXazyzUiLo7ZFWs2tBWYwOpGcM8i5ID93Kr7Y6l79XrBcST56QONVpEcAuLRs36Z2t1Q1MBlR315c6vSpAFX', '', '', '', 'no', 'razorpay.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(11, 'Coinbase', 'normal', '0', 'true', 0.0, 0.00, '', 'sjuRSAj4VdjaBx2bcdXgDbvTdpiHJF40CNsX5vqw4VaaaohvDS48Oc30N6DAxIxChfd2qWQ99q6e11E90OOKwmo0RbXUv3fdpPksWMvJUkm8i7F5ajbsy0LbjqyidUBqJP0BG6H3NkidnbhtfcDF45', '', '', '', 'no', 'coinbase.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(12, 'NowPayments', 'normal', '0', 'true', 0.0, 0.00, '', '4DPdFIbqqPqI8XjseCCV1RRVwVuuQx6WtYdHIkMDtxgUKCQaS9Mqww4WUwa6fIxn7NN9ediLstZyIYQQIIt9l6rUANRSzrUVt86J5FopCkZHvysC8CMRBS3LOnKDbNHiUmVh91CkmvjiwCrFApfrtH', '', '', '', 'no', 'nowpayments.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(13, 'Cardinity', 'card', '0', 'true', 0.0, 0.00, '', '0DBObWPPA7adVNLvhRC1YwZBANmK4i0PBREfPzyuG0IdJn1qP0X5jkIPsMNCAXh3plFI8IRXm0onNNjPPWnCqoOP89ZCG3ycIYLwX9x6kxYBW8vci5BGFgCG3BTGI7ytEkLnxz9BuJV1N9XfhDexPd', '', '', '', 'yes', '', '', 'yes', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(14, 'Binance', 'normal', '0', 'true', 0.0, 0.00, '', 'Hmo74bTxZMErUhHiiy1kPWECIgcAyt7PPCMkXfE4ZuT5HuCLC9rew9utO32bsh99RaBaqaA57ND1HY3n81M4JueKaeRQxsmWSsKUy8sSLwxWPo4ONolGcJcFSWLsrTF7aZUxcRrpT9Npp0TBZKJbVi', '', '', '', 'no', 'binance.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL),
(15, 'OpenPix', 'normal', '0', 'true', 0.0, 0.00, '', 'S6vCyZexN83KHZ4AMaCeZ9uQ69JvkhDvs0yq7Xu2S8alI2gtCBn3KrtxILgt76Iwofhu0PdIOswdvHz4K9iEhD2qH8dvYM7RTBzAM2M5R6gb98DlWNCYCPdyG8lNzaHQDuLi8NzFIeIYemZ6TEqjFF', '', '', '', 'no', 'openpix.png', '', 'no', '', '', '', '', '', NULL, NULL, NULL, NULL, 0, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `pay_per_views`
--

CREATE TABLE `pay_per_views` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `updates_id` int(10) UNSIGNED NOT NULL,
  `messages_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pay_per_views`
--

INSERT INTO `pay_per_views` (`id`, `user_id`, `updates_id`, `messages_id`, `created_at`, `updated_at`) VALUES
(1, 6, 5, 0, '2025-03-28 11:10:19', '2025-03-28 11:10:19'),
(2, 6, 25, 0, '2025-08-08 12:10:32', '2025-08-08 12:10:32'),
(3, 6, 28, 0, '2025-08-08 12:37:41', '2025-08-08 12:37:41');

-- --------------------------------------------------------

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `interval` varchar(100) NOT NULL,
  `paystack` varchar(150) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` (`id`, `user_id`, `name`, `price`, `interval`, `paystack`, `status`, `created_at`, `updated_at`) VALUES
(1, 4, 'user_4_weekly', 10.00, 'weekly', '', '0', '2025-03-26 05:58:34', '2025-03-26 05:58:34'),
(2, 4, 'user_4', 20.00, 'monthly', '', '1', '2025-03-26 05:58:34', '2025-03-26 05:58:34'),
(3, 4, 'user_4_quarterly', 30.00, 'quarterly', '', '0', '2025-03-26 05:58:34', '2025-03-26 05:58:34'),
(4, 4, 'user_4_biannually', 50.00, 'biannually', '', '0', '2025-03-26 05:58:34', '2025-03-26 05:58:34'),
(5, 4, 'user_4_yearly', 100.00, 'yearly', '', '0', '2025-03-26 05:58:34', '2025-03-26 05:58:34'),
(6, 7, 'user_7', 0.00, 'monthly', '', '1', '2025-03-28 10:20:51', '2025-03-28 10:20:51'),
(7, 2, 'user_2', 0.00, 'monthly', '', '1', '2025-03-31 05:10:04', '2025-03-31 05:10:04'),
(8, 1, 'plan_user_1', 0.00, 'monthly', '', '1', '2025-08-08 11:43:07', '2025-08-08 11:43:07'),
(9, 5, 'plan_user_5', 0.00, 'monthly', '', '1', '2025-09-15 16:56:02', '2025-09-15 16:56:02');

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` char(20) NOT NULL DEFAULT 'digital',
  `price` decimal(10,2) NOT NULL,
  `delivery_time` int(10) UNSIGNED NOT NULL,
  `country_free_shipping` char(20) NOT NULL,
  `tags` text NOT NULL,
  `description` text NOT NULL,
  `file` varchar(255) NOT NULL,
  `mime` varchar(50) DEFAULT NULL,
  `extension` varchar(50) DEFAULT NULL,
  `size` varchar(50) DEFAULT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `shipping_fee` decimal(10,2) NOT NULL,
  `quantity` int(10) UNSIGNED NOT NULL,
  `box_contents` varchar(200) NOT NULL,
  `category` varchar(20) DEFAULT NULL,
  `downloads` int(10) UNSIGNED NOT NULL,
  `external_link` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `user_id`, `name`, `type`, `price`, `delivery_time`, `country_free_shipping`, `tags`, `description`, `file`, `mime`, `extension`, `size`, `status`, `created_at`, `updated_at`, `shipping_fee`, `quantity`, `box_contents`, `category`, `downloads`, `external_link`) VALUES
(2, 1, 'Big Bus', 'digital', 100.00, 0, '', 'Bus', 'Product Description', '167eb7cef6d87a1743486191wt0dkgdulwc9s3mbcnry.jpg', 'image/webp', 'jpg', '67.1kB', '1', '2025-04-01 05:43:12', '2025-04-01 05:43:12', 0.00, 0, '', '1', 0, NULL),
(3, 1, 'Celebrity Shout Out', 'digital', 20.00, 0, '', 'shout out', 'Get a personalized shout out from your favorite celebrity on MXThrillz for birthdays, anniversaries, or special occasions.', '167eb7dc0dd6c21743486400slml6gj2dgmrdwtln5ao.png', 'image/png', 'png', '27.1kB', '1', '2025-04-01 05:47:23', '2025-04-01 05:47:23', 0.00, 0, '', '1', 0, NULL),
(4, 3, 'Audio message', 'digital', 10.00, 0, '0', 'Audio Message', 'Audio Message', '167eb7f9619ff71743486870d8cq4nzoauw7er2yn3fi.jpg', 'image/jpeg', 'jpg', '103kB', '1', '2025-04-01 05:54:33', '2025-04-01 05:56:57', 0.00, 0, '0', '1', 0, NULL),
(5, 1, 'Video Call', 'digital', 30.00, 0, '', 'Video Call', 'Video Call', '167eb8048f0c621743487048cpg5opxzgpzl3fbs5awm.jpg', 'image/jpeg', 'jpg', '85kB', '1', '2025-04-01 05:57:42', '2025-04-01 05:57:42', 0.00, 0, '', '1', 0, NULL),
(13, 1, 'Video message', 'digital', 40.00, 0, '', 'Video message', 'Video message', '167eb82d858e3e1743487704rjunziw8rpzzopd35dlo.jpg', 'image/jpeg', 'jpg', '75.4kB', '1', '2025-04-01 06:08:25', '2025-04-01 06:08:25', 0.00, 0, '', '1', 0, NULL),
(14, 3, 'Audio message', 'digital', 35.00, 0, '', 'Audio message', 'Audio message', '367eb8460d30251743488096udsgeug6qrjyiqvsimnc.jpg', 'image/jpeg', 'jpg', '103kB', '1', '2025-04-01 06:15:00', '2025-04-01 06:15:00', 0.00, 0, '', '1', 0, NULL),
(15, 1, 'Video message', 'digital', 100.00, 0, '', 'Video message', 'Video message', '167eb84a509280174348816556qh6fiss0yzvhipnqit.jpg', 'image/jpeg', 'jpg', '75.4kB', '1', '2025-04-01 06:16:17', '2025-04-01 06:16:17', 0.00, 0, '', '1', 0, NULL),
(16, 3, 'Video message', 'digital', 100.00, 0, '', 'Video Message', 'Video message', '367eb84db92b551743488219hwzbpw9pcqc72fmckpdb.jpg', 'image/jpeg', 'jpg', '75.4kB', '1', '2025-04-01 06:17:11', '2025-04-01 06:17:11', 0.00, 0, '', '1', 0, NULL),
(17, 3, 'Video Call', 'digital', 80.00, 0, '', 'Video Call', 'Video Call', '367eb850e3cbe71743488270q0i5r5wxtcxogdgbivjm.jpg', 'image/jpeg', 'jpg', '85kB', '1', '2025-04-01 06:17:50', '2025-04-01 06:17:50', 0.00, 0, '', '1', 0, NULL),
(19, 2, 'Audio Call', 'digital', 100.00, 0, '', 'Audio Call', 'Audio Call', '267eb8592467e617434884025cvllmawyih06a7rsofj.png', 'image/png', 'png', '89.4kB', '1', '2025-04-01 06:20:03', '2025-04-01 06:20:03', 0.00, 0, '', '1', 0, NULL),
(20, 2, 'Video message', 'digital', 100.00, 0, '', 'Video Message', 'Video message', '267eb85b35a53a1743488435j4gefmsmvpfq9srhlfhx.jpg', 'image/jpeg', 'jpg', '75.4kB', '1', '2025-04-01 06:20:40', '2025-04-01 06:20:40', 0.00, 0, '', '1', 0, NULL),
(21, 2, 'Video Call', 'digital', 100.00, 0, '', 'Video Call', 'Video Call', '267eb85e46800d174348848470wb2qpoi9lhrs2l7wup.jpg', 'image/jpeg', 'jpg', '85kB', '1', '2025-04-01 06:21:27', '2025-04-01 06:21:27', 0.00, 0, '', '1', 0, NULL),
(22, 2, 'Shout Out', 'digital', 100.00, 0, '', 'Shout Out', 'Get a personalized shout out from your favorite celebrity on MXThrillz for birthdays, anniversaries, or special occasions.', '267eb86103ed4c1743488528bctg27gbljhti6apm4gq.png', 'image/png', 'png', '27.1kB', '1', '2025-04-01 06:22:47', '2025-04-01 06:22:47', 0.00, 0, '', '1', 0, NULL),
(23, 5, 'Audio message', 'digital', 50.00, 0, '', 'Audio message', 'Audio message', '567eb86b3126381743488691eulc1q8p5vt0zxsvnrdu.jpg', 'image/jpeg', 'jpg', '103kB', '1', '2025-04-01 06:24:52', '2025-04-01 06:24:52', 0.00, 0, '', '1', 0, NULL),
(24, 5, 'Video Call', 'digital', 100.00, 0, '', 'Video Call', 'Video Call', '567eb86c23e0171743488706nfzbhreamzjyzffauqbr.jpg', 'image/jpeg', 'jpg', '85kB', '1', '2025-04-01 06:25:23', '2025-04-01 06:25:23', 0.00, 0, '', '1', 0, NULL),
(25, 5, 'Video Message', 'digital', 100.00, 0, '', 'Video Message', 'Video Message', '567eb86e7b4a7d1743488743c6u0ofvehdwuiqrkido6.jpg', 'image/jpeg', 'jpg', '75.4kB', '1', '2025-04-01 06:26:00', '2025-04-01 06:26:00', 0.00, 0, '', '1', 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transactions_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `products_id` int(10) UNSIGNED NOT NULL,
  `delivery_status` varchar(50) NOT NULL DEFAULT 'delivered',
  `description_custom_content` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `city` varchar(150) DEFAULT NULL,
  `zip` varchar(50) DEFAULT NULL,
  `phone` char(20) DEFAULT NULL,
  `expired_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchases`
--

INSERT INTO `purchases` (`id`, `transactions_id`, `user_id`, `products_id`, `delivery_status`, `description_custom_content`, `created_at`, `updated_at`, `address`, `city`, `zip`, `phone`, `expired_at`) VALUES
(1, 5, 6, 25, 'delivered', NULL, '2025-08-08 11:43:29', '2025-08-08 11:43:29', NULL, NULL, NULL, NULL, NULL),
(2, 6, 7, 23, 'delivered', NULL, '2025-08-08 12:06:26', '2025-08-08 12:06:26', NULL, NULL, NULL, NULL, NULL),
(3, 9, 6, 20, 'delivered', NULL, '2025-08-08 12:11:31', '2025-08-08 12:11:31', NULL, NULL, NULL, NULL, NULL),
(4, 12, 6, 17, 'delivered', NULL, '2025-09-15 16:41:41', '2025-09-15 16:41:41', NULL, NULL, NULL, NULL, NULL),
(5, 13, 6, 3, 'delivered', NULL, '2025-09-15 17:45:57', '2025-09-15 17:45:57', NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `reels`
--

CREATE TABLE `reels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `views` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `likes` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `comments_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `type` varchar(255) NOT NULL DEFAULT 'private',
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `reel_replies`
--

CREATE TABLE `reel_replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `reels_id` bigint(20) UNSIGNED NOT NULL,
  `comment_reels_id` bigint(20) UNSIGNED NOT NULL,
  `reply` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `referrals`
--

CREATE TABLE `referrals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `referred_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `referral_transactions`
--

CREATE TABLE `referral_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transactions_id` int(10) UNSIGNED DEFAULT NULL,
  `referrals_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `referred_by` int(10) UNSIGNED NOT NULL,
  `earnings` double(10,2) NOT NULL,
  `type` char(25) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `replies`
--

CREATE TABLE `replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `updates_id` bigint(20) UNSIGNED NOT NULL,
  `comments_id` bigint(20) UNSIGNED NOT NULL,
  `reply` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `replies`
--

INSERT INTO `replies` (`id`, `user_id`, `updates_id`, `comments_id`, `reply`, `created_at`, `updated_at`) VALUES
(1, 6, 14, 4, 'Great', '2025-08-08 12:16:59', '2025-08-08 12:16:59');

-- --------------------------------------------------------

--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `report_id` int(10) UNSIGNED NOT NULL,
  `type` varchar(100) NOT NULL,
  `reason` varchar(100) NOT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `reserved`
--

CREATE TABLE `reserved` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `editable` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `reserved`
--

INSERT INTO `reserved` (`id`, `name`, `editable`) VALUES
(1, 'fuck', 0),
(2, 'app', 0),
(3, 'public', 0),
(4, 'vendor', 0),
(5, 'xxx', 0),
(6, 'porn', 0),
(7, 'sex', 0),
(8, 'tags', 0),
(9, 'goods', 0),
(11, 'jobs', 0),
(12, 'projects', 0),
(13, 'messages', 0),
(14, 'account', 0),
(15, 'popular', 0),
(16, 'latest', 0),
(17, 'search', 0),
(19, 'notifications', 0),
(20, 'login', 0),
(21, 'join', 0),
(23, 'register', 0),
(24, 'upgrade', 0),
(25, 'contact', 0),
(26, 'signup', 0),
(27, 'members', 0),
(28, 'upload', 0),
(29, 'comment', 0),
(30, 'bootstrap', 0),
(31, 'api', 0),
(32, 'creators', 0),
(33, 'logout', 0),
(34, 'categories', 0),
(35, 'featured', 0),
(36, 'collections', 0),
(37, 'dashboard', 0),
(38, 'tests', 0),
(39, 'routes', 0),
(40, 'resources', 0),
(41, 'database', 0),
(42, 'config', 0),
(44, 'storage', 0),
(45, 'core', 0),
(46, 'cpanel', 0),
(47, 'blog', 0),
(48, 'offline', 0),
(49, 'artisan', 0),
(50, 'explore', 0),
(51, 'shop', 0),
(52, 'home', 0),
(53, 'lang', 0),
(54, 'reels', 0);

-- --------------------------------------------------------

--
-- Table structure for table `restrictions`
--

CREATE TABLE `restrictions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `user_restricted` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(191) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `shop_categories`
--

CREATE TABLE `shop_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shop_categories`
--

INSERT INTO `shop_categories` (`id`, `name`, `slug`) VALUES
(1, 'Surprise', 'category');

-- --------------------------------------------------------

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `countries_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(250) NOT NULL,
  `code` char(10) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `stories`
--

CREATE TABLE `stories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stories`
--

INSERT INTO `stories` (`id`, `user_id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 'active', '2025-03-28 11:19:56', '2025-03-28 11:19:56'),
(2, 1, NULL, 'active', '2025-03-31 04:08:08', '2025-03-31 04:08:08'),
(4, 7, NULL, 'active', '2025-03-31 04:23:43', '2025-03-31 04:23:43');

-- --------------------------------------------------------

--
-- Table structure for table `story_backgrounds`
--

CREATE TABLE `story_backgrounds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `story_backgrounds`
--

INSERT INTO `story_backgrounds` (`id`, `name`) VALUES
(1, '01.jpg'),
(2, '02.png'),
(3, '03.jpg'),
(4, '04.jpg'),
(5, '05.jpg'),
(6, '06.png'),
(7, '07.jpg'),
(8, '08.png'),
(9, '09.jpg'),
(10, '10.png'),
(11, '11.jpg'),
(12, '12.jpg'),
(13, '13.jpg'),
(14, '14.jpg'),
(15, '15.png'),
(16, 'Ig7KB1743394397.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `story_fonts`
--

CREATE TABLE `story_fonts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `story_views`
--

CREATE TABLE `story_views` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `media_stories_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `stripe_state_tokens`
--

CREATE TABLE `stripe_state_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `creator_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_status` varchar(255) NOT NULL,
  `stripe_price` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_payment` varchar(255) DEFAULT NULL,
  `free` enum('yes','no') NOT NULL DEFAULT 'no',
  `subscription_id` varchar(50) NOT NULL,
  `cancelled` enum('yes','no') NOT NULL DEFAULT 'no',
  `rebill_wallet` enum('on','off') NOT NULL DEFAULT 'off',
  `interval` varchar(100) NOT NULL DEFAULT 'monthly',
  `taxes` text DEFAULT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `gateway` varchar(255) DEFAULT NULL,
  `cofTransactionId` varchar(255) DEFAULT NULL,
  `merchantIdentifier` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `creator_id`, `user_id`, `type`, `stripe_id`, `stripe_status`, `stripe_price`, `quantity`, `trial_ends_at`, `ends_at`, `created_at`, `updated_at`, `last_payment`, `free`, `subscription_id`, `cancelled`, `rebill_wallet`, `interval`, `taxes`, `payment_id`, `gateway`, `cofTransactionId`, `merchantIdentifier`) VALUES
(2, 7, 6, '', '', '', 'plan_user_7', NULL, NULL, NULL, '2025-08-08 11:43:00', '2025-08-08 11:43:00', NULL, 'yes', '', 'no', 'off', 'monthly', NULL, NULL, NULL, NULL, NULL),
(3, 1, 6, '', '', '', 'plan_user_1', NULL, NULL, NULL, '2025-08-08 11:43:07', '2025-08-08 11:43:07', NULL, 'yes', '', 'no', 'off', 'monthly', NULL, NULL, NULL, NULL, NULL),
(5, 2, 7, '', '', '', 'plan_user_2', NULL, NULL, NULL, '2025-08-08 12:19:35', '2025-08-08 12:19:35', NULL, 'yes', '', 'no', 'off', 'monthly', NULL, NULL, NULL, NULL, NULL),
(6, 2, 6, '', '', '', 'plan_user_2', NULL, NULL, NULL, '2025-09-08 09:20:20', '2025-09-08 09:20:20', NULL, 'yes', '', 'no', 'off', 'monthly', NULL, NULL, NULL, NULL, NULL),
(7, 5, 6, '', '', '', 'plan_user_5', NULL, NULL, NULL, '2025-09-15 16:56:02', '2025-09-15 16:56:02', NULL, 'yes', '', 'no', 'off', 'monthly', NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `subscription_deleteds`
--

CREATE TABLE `subscription_deleteds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `creator_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_deleteds`
--

INSERT INTO `subscription_deleteds` (`id`, `creator_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 2, 6, '2025-09-08 09:20:11', '2025-09-08 09:20:11');

-- --------------------------------------------------------

--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subscription_id` bigint(20) UNSIGNED NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_product` varchar(255) DEFAULT NULL,
  `stripe_price` varchar(255) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tax_rates`
--

CREATE TABLE `tax_rates` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(250) NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 1,
  `percentage` decimal(5,2) NOT NULL,
  `country` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `iso_state` char(10) DEFAULT NULL,
  `stripe_id` varchar(100) DEFAULT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(10) UNSIGNED NOT NULL,
  `txn_id` varchar(250) NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `subscriptions_id` int(10) UNSIGNED NOT NULL,
  `subscribed` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `earning_net_user` decimal(10,2) NOT NULL,
  `earning_net_admin` decimal(10,2) NOT NULL,
  `payment_gateway` varchar(100) NOT NULL,
  `approved` varchar(50) NOT NULL DEFAULT '1' COMMENT '0 Pending, 1 Success, 2 Canceled',
  `amount` float NOT NULL,
  `type` varchar(100) NOT NULL DEFAULT 'subscription',
  `percentage_applied` varchar(50) NOT NULL,
  `referred_commission` int(10) UNSIGNED NOT NULL,
  `taxes` text DEFAULT NULL,
  `direct_payment` tinyint(1) NOT NULL DEFAULT 0,
  `gift_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `txn_id`, `user_id`, `subscriptions_id`, `subscribed`, `created_at`, `earning_net_user`, `earning_net_admin`, `payment_gateway`, `approved`, `amount`, `type`, `percentage_applied`, `referred_commission`, `taxes`, `direct_payment`, `gift_id`) VALUES
(1, 'w_5TtZHc3to1MykChNOIbHpTB57', 6, 0, 4, '2025-03-28 10:11:22', 4.75, 0.25, 'Wallet', '1', 5, 'gift', '5%', 0, '', 0, 1),
(2, 'ppv_HFcbpDyxTm6pBqm4XMa9IJ0Xq', 6, 0, 7, '2025-03-28 11:10:19', 4.75, 0.25, 'Wallet', '1', 5, 'ppv', '5%', 0, '', 0, NULL),
(3, 'purchase_G1j2cKMAEBIsU4wtbkfyWYEE4', 6, 0, 1, '2025-03-28 12:21:09', 19.00, 1.00, 'Wallet', '1', 20, 'purchase', '5%', 0, '', 0, NULL),
(4, 'pi_3R8aquHTAHWwyrB61EqGAgkd', 1, 0, 4, '2025-03-31 05:25:41', 4.33, 0.23, 'Stripe', '1', 5, 'tip', '2.9% + 0.30 + 5%', 0, '', 0, NULL),
(5, 'purchase_H5DM1qyDc35hxFGMgrxsTd2pC', 6, 0, 5, '2025-08-08 11:43:29', 95.00, 5.00, 'Wallet', '1', 100, 'purchase', '5%', 0, '', 0, NULL),
(6, 'purchase_8ZsJjHqMceMu6D3i2CuNI5gRD', 7, 0, 5, '2025-08-08 12:06:26', 47.50, 2.50, 'Wallet', '1', 50, 'purchase', '5%', 0, '', 0, NULL),
(7, 'pi_3Rtp4bCGv1sRiQlE1mXORXFR', 6, 0, 7, '2025-08-08 12:07:01', 4.33, 0.23, 'Stripe', '1', 5, 'tip', '2.9% + 0.30 + 5%', 0, '', 0, NULL),
(8, 'ppv_JiVyh3OZPoCXZUSM023DqZFZS', 6, 0, 1, '2025-08-08 12:10:32', 4.75, 0.25, 'Wallet', '1', 5, 'ppv', '5%', 0, '', 0, NULL),
(9, 'purchase_ZL65Qr6prsP9Z3BY8cGCPTPhi', 6, 0, 2, '2025-08-08 12:11:31', 95.00, 5.00, 'Wallet', '1', 100, 'purchase', '5%', 0, '', 0, NULL),
(10, 'ppv_XbF1R3SSQv0YrkgvT7gavJjqq', 6, 0, 7, '2025-08-08 12:37:41', 4.33, 0.23, 'Stripe', '1', 5, 'ppv', '2.9% + 0.30 + 5%', 0, '', 0, NULL),
(11, 'w_UZMtv7iio54ieoJa5zx0VrJt3', 6, 0, 2, '2025-09-08 09:29:28', 19.00, 1.00, 'Wallet', '1', 20, 'tip', '5%', 0, '', 0, NULL),
(12, 'purchase_28kmlbZYkTBsX0FHwqs9pPaJZ', 6, 0, 3, '2025-09-15 16:41:41', 76.00, 4.00, 'Wallet', '1', 80, 'purchase', '5%', 0, '', 0, NULL),
(13, 'purchase_DrDZK2puAx8A7dxo9bPMQhU9A', 6, 0, 1, '2025-09-15 17:45:57', 19.00, 1.00, 'Wallet', '1', 20, 'purchase', '5%', 0, '', 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `two_factor_codes`
--

CREATE TABLE `two_factor_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `code` varchar(25) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `updates`
--

CREATE TABLE `updates` (
  `id` int(11) NOT NULL,
  `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `token_id` varchar(255) NOT NULL,
  `locked` enum('yes','no') NOT NULL DEFAULT 'no',
  `fixed_post` enum('0','1') NOT NULL DEFAULT '0',
  `price` decimal(10,2) NOT NULL,
  `status` char(20) NOT NULL DEFAULT 'active',
  `video_views` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(200) DEFAULT NULL,
  `scheduled_date` timestamp NULL DEFAULT NULL,
  `schedule` tinyint(1) NOT NULL DEFAULT 0,
  `editing` tinyint(1) NOT NULL DEFAULT 0,
  `can_media_edit` tinyint(1) NOT NULL DEFAULT 0,
  `likes_extras` bigint(20) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `updates`
--

INSERT INTO `updates` (`id`, `title`, `description`, `user_id`, `date`, `token_id`, `locked`, `fixed_post`, `price`, `status`, `video_views`, `ip`, `scheduled_date`, `schedule`, `editing`, `can_media_edit`, `likes_extras`) VALUES
(1, NULL, '😅', 2, '2025-03-26 05:45:37', 'wJ5g9eBqxPzN5Qqwwuz0GCSVWfiMtc1t2BXVeyiLc0vAv7sbJdfrM6drxtYWCQzsuHZCCWjOqApS1NULYL7poEumSpc1RklajwQVR0pfvE9JPfPMyyYN8wYtZbeI7wRJjChb06pJFWEV1yKgsuHzvi', 'yes', '0', 0.00, 'active', 0, '106.215.153.188', '0000-00-00 00:00:00', 0, 0, 1, 0),
(2, NULL, 'Hey there', 4, '2025-03-26 05:58:56', 'M3pK6oAEWPmJ8a3Ulr3a1YzNwfqZ7AZISH1IdjbaTBBLI7ZhjZrHGSnrkpxw6irWcIKdT9NZEuwdJMpAVWAAHW9L33hxYzKFz8ZpIX0xWU8ig7rLj8rHDH1T0QkBHBZqsO4Fca6Xl1rbR1ciSk3kXO', 'yes', '0', 0.00, 'active', 0, '106.215.153.188', '0000-00-00 00:00:00', 0, 0, 1, 0),
(3, NULL, 'Trying New Things Out', 7, '2025-03-28 10:19:53', 'M9WoKMWVkcOCnhVrqa0L9VpspTBYwKntKH0bPI52R4VyWaE05JTWfxBdDfIT07xLrJ3DX25OanYPdPNq17qt5l9KNZ93C8EV5q93M8EYiavPu8ecEFlKHNW5C4cMpZozVdFhUsNZNvONNt1Sx5YvIY', 'yes', '0', 0.00, 'active', 1, '223.233.84.212', '0000-00-00 00:00:00', 0, 0, 1, 0),
(4, '', '...🙂', 1, '2025-03-28 11:08:41', 'bZy5oGnsoYVZAnPzFxicmOGxLlaYBmDVQFhUz4NOouNsQJX1GIxtYSUiGqVxoSrfQrxFzm6Y5YJdLm45SXKxMuWgkiIQqPL5C3MhoAJTdk381oDhCU2wy31hetXw7yZ0yUQo5IGoFNZp3VkBxPoBDC', 'yes', '0', 78.00, 'active', 0, '223.233.87.11', '0000-00-00 00:00:00', 0, 0, 1, 0),
(6, NULL, 'The best way to predict the future is to create it.', 1, '2025-08-08 11:22:30', 'vlJk0vTsCXCD26jwocz0849ephz9E3yqa7SymvnAKZVbVli6BXsJ2rmgSbOxMqS1h8olRorYxyarJERX2mbmjFZ9olnoLjtAWXOGg9mTlehnNdTYDOArwd8v29lwsaHYdpClwed9idCk46DIbBQrZb', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(7, NULL, 'Here’s where the magic happens! Working on something special for you all.', 1, '2025-08-08 11:24:01', 'vPbLjgOCkdszRTBg7YrJDZGI396nXRe9kaQP74uebZxGVdi7a1edYscL3doAFxTI47S86hClstLcwybF43MmsW5Qvxtu6ch7VIm3aA9jNJDurMKHbkssgI2Zjzs0QwhFeuROD9o5D2ohUQBT3qOcVV', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(8, NULL, 'Keep sharing your moments with us. #CustomerLove', 1, '2025-08-08 11:27:07', 'xTrur3PPaXjyp5WJODJxYwDgODJGiYkgRl58Bv5TeZCB99nkpB22rba9ILR86PiofR1QR0AleKWnCBf5DMryi9QPlVyisbAsd22278YuoNozg2zKIiyW3AUtXiA1us09LPaqaA0ElQAQA2LYsLQWXs', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(9, NULL, 'Getting into the holiday spirit with our new festive collection. 🎄 #SeasonalVibes #HolidayShopping\"', 7, '2025-08-08 11:34:48', 'CjeX7xTVRFdbvhsgVx8cVI78TqTQXSlXEq0naKD210YyRi41up4Pq0GauFUNZTmPgVnTaMknuBeiiPlL5sCrQ0xhpC6PABgaQ1rO2D8Gma3jQUpKIAoihRNaYAAmahRBhqOPK42ATMiVHSg6weFpwc', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(10, NULL, 'A fun, colorful infographic or playful typography with an illustration.', 7, '2025-08-08 11:35:45', 'TwRHwY5EM2WT642FBCbi59Gw9LIMYJ8qDOF4Ftw6zUJF0tzS6AueXGGd4xEC9V3XiYzlhjcHV4LAqsZe2WI8uiysKzIqkryNEzmlkv4Z8iJA6CIiixg6BJDh2RJ3pF5EuGO0tvsWJiXRlGzF9IndQM', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(11, NULL, 'Meet Sarah! #CustomerSpotlight #SuccessStory', 7, '2025-08-08 11:38:44', 'j7tPxT7aTpPaX7kySiCsjl8Kufnd2no8kOMwdirokUlEC41kdjLP8VYAyMxpsIXY2daU9aW4X4u5q4X2Wxa0HFamANEmH1yebvf7rTTnsNbVRsdlFbiR60PhWkOItWoOe8uSaU76B2O78WaoZapZdO', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(12, NULL, 'New look for next event', 2, '2025-08-08 11:42:11', 'fS7z0TF8rS5TGPlJvaU8fIbn6N3PGIkeX4TwK01RvFil6Puq8k35fZNEeEGdZ5NqjnOc19gunfy0CgazmugLrNzobsJZJFA6lRzUYO5Ei44gsRXuhvgvZr6XfAoy1VhAzgxDUcIP9P9jWMK5gBWICg', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(13, NULL, 'Golden days', 2, '2025-08-08 11:42:55', 'nq8gcIIcO02NVGKZT8lk7ktlFvAxfBY9ZNLPOnozANsFsz1267ybC32hqjfcBXB7ZOoAtg3oqSoqSnazKf4mEtAw4hdjafkfmJju9cIv91tBtzZPYwT7hkYEGHAKTTRZcQeCFFlWA3EoFGDpJiCZdt', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(14, NULL, 'It was an honor', 2, '2025-08-08 11:43:31', '8PQPuoOSVLuqKZaGLCj4TExhfNGP0cqHn2mSbW0CpeV3KcStsEZrX1vu9kspXNQn5iSAqdoP6MBOntWrYhzvi76NyeWI4laQXHkvZyBfPRJF7lQixp8z8cD7Hgudf7OOxu3gT0DlYEKph4YEvlkyjA', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(15, NULL, 'What do you say about this ??', 3, '2025-08-08 11:46:46', 'hjoTkz4a1e3IhbVUPrVjQKMV9Ru7leZRZCNV5wPAAWJm7NAWw25H5xA4rt81L3Ft2m126OSMqK5N8NUjhu9KczuLsJeH63JQy7hBrd9UbyM5Gk8aCYTwki4FRg95r0BZbWOZ54dRWDQ6lkYFpFOxOH', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(16, NULL, 'Woowwww', 3, '2025-08-08 11:47:53', 'GmczeomPFd5TuC2mxsDXYkqDOvOjYluTcIGAf78cpxiZiWoUgR3KwJntBmcEnkzA1FATSfLCEvp1pe2ueR5IbskcUISX0gO8QFCwO7nWt8XZ4FvmExoZCbGiWrfFXkqOe19SGVXI4IE9haisU31RQQ', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(17, NULL, 'Oppsssss!!!', 3, '2025-08-08 11:48:25', 'qrhQhJHvBmeLr8aXY3VR9UKA39emHVRjO1lukmNItCdZzcBtG9wO45nBJaROtdPvbLrQwpRgKfsrIYsuFRJy43ehMUOSsszNvMbExUpSEH1PEv3FGosWcbVVg8U3Q2KrGiUAVEXjGMWdsz6IjVgxt8', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(18, NULL, 'Took a while to achieve this.... What do you say was it worth it ?', 4, '2025-08-08 11:50:49', 'YAjEza93SOQiOFYB0pY3haWgxu1wz3fHi8f7YmWkTozmmEqm3vglm5lmoCulIJSowCZlNoh2qukI2ZRha87QI6pKTFNsG5JFKyY4kLrg6D14dUocPlpDnWS9OEfxWFb3QtLBe7aAaDcKwLPbosOCFs', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(19, NULL, 'Don\'t have any words for this !!!', 4, '2025-08-08 11:51:30', 'yTjfSf1JMC6mKUfg6vuKaMf41HBqfpf4L42rvCZuIxdOckX5oX4jqLarTe2zUQ9B8186rissIPZqIfMAwi93JmgtWLy6BruFydUAHA51emn6GtgpF2KPRQ965qjeihPA7JBdyMlthLy24cRD4Sh0Jk', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(20, NULL, 'Feeling good.....', 4, '2025-08-08 11:52:42', '1YNnUZxc2FeN0JRhrEbm3TTwnNbe1T4AXlQ7SJMMFmtgB2RfUpljUbBu0Vdr8oa8gTTsWrXcksjN86pShexjYUqqFOtyOtjN0TlZhxa6aqIBVZcKfb5OM8geUwopZvlpxpNs3FFXgYP1umSRnWWAeR', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(21, NULL, 'Feeling good >>>>', 5, '2025-08-08 11:55:48', 'iVxA8Xo5K6rKXkFfrdIVzy1Sc4QlPxX0A7KEMi8gUJJJIlZo8FLYC1LBfKrhJMLGDSLOjyEhNd5gUAQrdXlN4yK8uBwAEsDwVvwjFbPw8b09D5iAnCWzSLLpJjxY5wPVL4pDbHWHleWTsoMuB8Q6VH', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(22, NULL, 'Pretty Old huh...', 5, '2025-08-08 11:56:23', '8XjwuukSuzjXMJISNyaheWGjyMoNzBKGUUxlKBrD2oNPgaaRtl0vxIhIlb9GygegZGwo2FB7BPGomHVZWsQ9DurPzgUqfj4949YHoUn8jCtp3MuF3dL4rlXjULNvCGxtPBT2oAgGn5XFTjIfKQi7Q1', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(23, NULL, 'The OG <<<', 5, '2025-08-08 11:57:12', 'yOQgQcCnfFykcGVW2LLdFDhqFDP4OD5oU8DolpUznasWFjZZiwLaP0vuMq6DpML1mN6GgI73FQs1vsL3exLPgMHGRU8XnaXadiidX4AlHxboeyupcYBIonVTVoaKLgJ3g6k3NtZaegoTFWNNEWLhH9', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(24, NULL, 'Be smiling every moment .... !', 5, '2025-08-08 11:58:11', 'o8MPQ4DJ0Ypbm5UFuZ6de6jimjrwPgSW06XOmwTX5w84kQ9wVcuPqYgepq1FwrbjjJgYFwL893fiHRfTODAqHwVi7DX1Cu8VaADQ2SlRpdCbG7gn14GJ5Byrk3NUUfwKMQciLN28sjwCWf3uxP9UoE', 'yes', '0', 0.00, 'active', 0, '106.222.204.135', '0000-00-00 00:00:00', 0, 0, 1, 0),
(29, 'Get together', '😎', 7, '2025-08-08 12:39:11', '3zifY5M4rsc9BCW7RlwJ3xYnozP8WIKyLtYe2em97gKqKBfFBJTA8h4bAZAWgFnYZZoWzq8l6OOvxiKSa1ectHgEj2QmIFto4b6OA595xe8BTilahpINyRUrehH5RLLeiIBQCiZ85S3W5c48pSlKlW', 'yes', '0', 0.00, 'schedule', 0, '106.215.182.200', '2025-08-09 08:10:00', 1, 0, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(150) NOT NULL,
  `username` varchar(50) NOT NULL,
  `countries_id` char(25) NOT NULL,
  `password` char(60) NOT NULL,
  `email` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `avatar` varchar(70) NOT NULL,
  `cover` varchar(70) NOT NULL,
  `status` varchar(200) NOT NULL DEFAULT 'active',
  `role` enum('normal','admin') NOT NULL DEFAULT 'normal',
  `permission` enum('all','none') NOT NULL DEFAULT 'none',
  `remember_token` varchar(100) NOT NULL,
  `token` varchar(80) NOT NULL,
  `confirmation_code` varchar(125) NOT NULL,
  `paypal_account` varchar(200) NOT NULL,
  `payment_gateway` varchar(50) NOT NULL,
  `bank` mediumtext NOT NULL,
  `featured` enum('yes','no') NOT NULL DEFAULT 'no',
  `featured_date` timestamp NULL DEFAULT NULL,
  `about` varchar(200) NOT NULL,
  `story` text NOT NULL,
  `profession` varchar(200) NOT NULL,
  `oauth_uid` varchar(255) NOT NULL,
  `oauth_provider` varchar(255) NOT NULL,
  `categories_id` varchar(255) NOT NULL,
  `website` varchar(200) NOT NULL,
  `stripe_id` varchar(255) DEFAULT NULL,
  `pm_type` varchar(255) DEFAULT NULL,
  `pm_last_four` varchar(4) DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `verified_id` enum('yes','no','reject') DEFAULT 'no',
  `address` varchar(200) NOT NULL,
  `city` varchar(150) NOT NULL,
  `zip` varchar(50) NOT NULL,
  `facebook` varchar(200) NOT NULL,
  `twitter` varchar(200) NOT NULL,
  `instagram` varchar(200) NOT NULL,
  `youtube` varchar(200) NOT NULL,
  `pinterest` varchar(200) NOT NULL,
  `github` varchar(200) NOT NULL,
  `last_seen` timestamp NULL DEFAULT NULL,
  `email_new_subscriber` enum('yes','no') NOT NULL DEFAULT 'yes',
  `plan` varchar(255) NOT NULL,
  `notify_new_subscriber` enum('yes','no') NOT NULL DEFAULT 'yes',
  `notify_liked_post` enum('yes','no') NOT NULL DEFAULT 'yes',
  `notify_commented_post` enum('yes','no') NOT NULL DEFAULT 'yes',
  `company` varchar(50) NOT NULL,
  `post_locked` enum('yes','no') NOT NULL DEFAULT 'yes',
  `ip` varchar(40) NOT NULL,
  `dark_mode` enum('on','off') NOT NULL DEFAULT 'off',
  `gender` varchar(50) NOT NULL,
  `birthdate` varchar(30) NOT NULL,
  `allow_download_files` enum('no','yes') NOT NULL DEFAULT 'no',
  `language` varchar(10) NOT NULL,
  `free_subscription` enum('yes','no') NOT NULL DEFAULT 'no',
  `wallet` decimal(10,2) NOT NULL,
  `tiktok` varchar(200) NOT NULL,
  `snapchat` varchar(200) NOT NULL,
  `paystack_plan` varchar(100) NOT NULL,
  `paystack_authorization_code` varchar(100) NOT NULL,
  `paystack_last4` int(10) UNSIGNED NOT NULL,
  `paystack_exp` varchar(50) NOT NULL,
  `paystack_card_brand` varchar(25) NOT NULL,
  `notify_new_tip` enum('yes','no') NOT NULL DEFAULT 'yes',
  `hide_profile` enum('yes','no') NOT NULL DEFAULT 'no',
  `hide_last_seen` enum('yes','no') NOT NULL DEFAULT 'no',
  `last_login` varchar(250) NOT NULL,
  `hide_count_subscribers` enum('yes','no') NOT NULL DEFAULT 'no',
  `hide_my_country` enum('yes','no') NOT NULL DEFAULT 'no',
  `show_my_birthdate` enum('yes','no') NOT NULL DEFAULT 'no',
  `notify_new_post` enum('yes','no') NOT NULL DEFAULT 'yes',
  `notify_email_new_post` enum('yes','no') NOT NULL DEFAULT 'yes',
  `custom_fee` int(10) UNSIGNED NOT NULL,
  `hide_name` enum('yes','no') NOT NULL DEFAULT 'no',
  `birthdate_changed` enum('yes','no') NOT NULL DEFAULT 'no',
  `email_new_tip` enum('yes','no') NOT NULL DEFAULT 'yes',
  `email_new_ppv` enum('yes','no') NOT NULL DEFAULT 'yes',
  `notify_new_ppv` enum('yes','no') NOT NULL DEFAULT 'yes',
  `active_status_online` enum('yes','no') NOT NULL DEFAULT 'yes',
  `payoneer_account` varchar(200) NOT NULL,
  `zelle_account` varchar(200) NOT NULL,
  `notify_liked_comment` enum('yes','no') NOT NULL DEFAULT 'yes',
  `permissions` mediumtext NOT NULL,
  `blocked_countries` mediumtext NOT NULL,
  `two_factor_auth` enum('yes','no') NOT NULL DEFAULT 'no',
  `notify_live_streaming` enum('yes','no') NOT NULL DEFAULT 'yes',
  `notify_mentions` enum('yes','no') NOT NULL DEFAULT 'yes',
  `stripe_connect_id` varchar(255) DEFAULT NULL,
  `completed_stripe_onboarding` tinyint(1) NOT NULL DEFAULT 0,
  `device_token` varchar(255) DEFAULT NULL,
  `telegram` varchar(200) NOT NULL,
  `vk` varchar(200) NOT NULL,
  `twitch` varchar(200) NOT NULL,
  `discord` varchar(200) NOT NULL,
  `reddit` varchar(200) NOT NULL,
  `spotify` varchar(200) NOT NULL,
  `posts_privacy` tinyint(1) NOT NULL DEFAULT 1,
  `document_id` varchar(100) NOT NULL,
  `crypto_wallet` varchar(255) NOT NULL,
  `threads` varchar(200) NOT NULL,
  `allow_live_streaming_private` enum('on','off') NOT NULL DEFAULT 'off',
  `price_live_streaming_private` decimal(10,2) DEFAULT NULL,
  `allow_dm` tinyint(1) NOT NULL DEFAULT 1,
  `welcome_message_new_subs` text NOT NULL,
  `send_welcome_message` tinyint(1) NOT NULL DEFAULT 0,
  `price_welcome_message` decimal(10,2) DEFAULT NULL,
  `alias_mp` varchar(100) NOT NULL,
  `cvu` varchar(100) NOT NULL,
  `kick` varchar(200) NOT NULL,
  `email_new_message` tinyint(1) NOT NULL DEFAULT 1,
  `allow_comments` tinyint(1) NOT NULL DEFAULT 1,
  `custom_profit_referral` int(10) UNSIGNED NOT NULL,
  `price_video_call` decimal(10,2) DEFAULT NULL,
  `video_call_duration` int(10) UNSIGNED DEFAULT NULL,
  `notify_commented_reel` tinyint(1) NOT NULL DEFAULT 1,
  `notify_liked_reel` tinyint(1) NOT NULL DEFAULT 1,
  `price_audio_call` decimal(10,2) DEFAULT NULL,
  `audio_call_duration` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `username`, `countries_id`, `password`, `email`, `date`, `avatar`, `cover`, `status`, `role`, `permission`, `remember_token`, `token`, `confirmation_code`, `paypal_account`, `payment_gateway`, `bank`, `featured`, `featured_date`, `about`, `story`, `profession`, `oauth_uid`, `oauth_provider`, `categories_id`, `website`, `stripe_id`, `pm_type`, `pm_last_four`, `trial_ends_at`, `price`, `balance`, `verified_id`, `address`, `city`, `zip`, `facebook`, `twitter`, `instagram`, `youtube`, `pinterest`, `github`, `last_seen`, `email_new_subscriber`, `plan`, `notify_new_subscriber`, `notify_liked_post`, `notify_commented_post`, `company`, `post_locked`, `ip`, `dark_mode`, `gender`, `birthdate`, `allow_download_files`, `language`, `free_subscription`, `wallet`, `tiktok`, `snapchat`, `paystack_plan`, `paystack_authorization_code`, `paystack_last4`, `paystack_exp`, `paystack_card_brand`, `notify_new_tip`, `hide_profile`, `hide_last_seen`, `last_login`, `hide_count_subscribers`, `hide_my_country`, `show_my_birthdate`, `notify_new_post`, `notify_email_new_post`, `custom_fee`, `hide_name`, `birthdate_changed`, `email_new_tip`, `email_new_ppv`, `notify_new_ppv`, `active_status_online`, `payoneer_account`, `zelle_account`, `notify_liked_comment`, `permissions`, `blocked_countries`, `two_factor_auth`, `notify_live_streaming`, `notify_mentions`, `stripe_connect_id`, `completed_stripe_onboarding`, `device_token`, `telegram`, `vk`, `twitch`, `discord`, `reddit`, `spotify`, `posts_privacy`, `document_id`, `crypto_wallet`, `threads`, `allow_live_streaming_private`, `price_live_streaming_private`, `allow_dm`, `welcome_message_new_subs`, `send_welcome_message`, `price_welcome_message`, `alias_mp`, `cvu`, `kick`, `email_new_message`, `allow_comments`, `custom_profit_referral`, `price_video_call`, `video_call_duration`, `notify_commented_reel`, `notify_liked_reel`, `price_audio_call`, `audio_call_duration`) VALUES
(1, 'Anna', 'master', '1', '$2y$10$/d24adtdu.zPm9nrpensSOfCj2bk2zy05iLxvQr1Lk6Ha/UWmlZj.', 'mastermcx@miracuves.com', '2021-03-13 08:01:01', 'admin-11754651422pg0wsqiqqn.jpg', 'admin-11754651426ugnmxgsmyw.jpg', 'active', 'admin', 'all', 'Dw2jSxYnBC8xUlD8ONs70QTslwGyrM6CbQ1rolviW2C3g0wJZJ5ZX93p9UXG', 'Wy4VkAl2dxHb9WHoXjTowSGPXFPnEQHca6RBe2yeqqmRafs0hSbCEobhNkZZAbCDIru60ceLzAAOI3fj', '', '', '', '', 'yes', '2019-02-21 03:25:00', '', 'Welcome to my page. If you like my content, please consider support. Any donation will be well received. Thank you for your support!', '', '', '', '', '', 'cus_T84HZGSe5BaWKt', 'visa', '4242', NULL, 0.00, 23.75, 'yes', '', '', '', '', '', '', '', '', '', '2025-09-27 03:38:13', 'yes', 'user_1', 'yes', 'yes', 'yes', '', 'yes', '', 'on', 'male', '06/16/1993', 'no', '', 'yes', 0.00, '', '', '', '', 0, '', '', 'yes', 'no', 'no', '', 'no', 'no', 'no', 'yes', 'no', 0, 'no', 'yes', 'yes', 'yes', 'yes', 'yes', '', '', 'yes', 'full_access', '', 'no', 'yes', 'yes', NULL, 0, NULL, '', '', '', '', '', '', 1, '', '', '', 'off', NULL, 1, '', 0, NULL, '', '', '', 1, 1, 0, NULL, NULL, 1, 1, NULL, NULL),
(2, 'Robert Downey Jr.', 'robert', '1', '$2y$10$GuBHJAW4DYQhBgwNV5CY7e2Mc5AXyLN67pttvCUocIHjJluXqh6kq', 'admin@demo.com', '2025-03-26 05:38:39', 'robert-217429676286hmj0zjlsk.jpg', 'robert-21742967632v07hcdmxba.jpg', 'active', 'admin', 'none', 'q74XLc9MUUTkBF2TulSZBtjH52curKqmU3yx7NbUVnmEi1TbbX6Ajyol2ndX', '4oULlIIFZ0Tn5Tm0VaijmmD3OK0OE4ZzOhSq00Gv7chZG3PcHOaFvs07cki9mCrRZFrZTZ8ZYkz', '', '', '', '', 'yes', '2025-03-26 05:54:36', '', 'Welcome to my page. If you like my content, please consider support. Thank you for your support!', '', '', '', '', '', NULL, NULL, NULL, NULL, 0.00, 109.00, 'yes', 'US', 'Los angeles', '162990', '', '', '', '', '', '', '2025-09-17 09:19:05', 'yes', 'plan_user_2', 'yes', 'yes', 'yes', '', 'yes', '106.215.153.188', 'off', 'male', '01/31/2000', 'no', 'en', 'yes', 5.00, '', '', '', '', 0, '', '', 'yes', 'no', 'no', '', 'no', 'no', 'no', 'yes', 'yes', 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '', '', 'yes', 'limited_access', '', 'no', 'yes', 'yes', NULL, 0, NULL, '', '', '', '', '', '', 1, '', '', '', 'off', NULL, 1, '', 0, NULL, '', '', '', 1, 1, 0, NULL, NULL, 1, 1, NULL, NULL),
(3, 'cristiano', 'cristiano', '1', '$2y$10$QW1yEx2mEr1PjElLSguiYulFRciYgh9l0xjXE5v/JBjcqLC0eCTce', 'cristiano@demo.com', '2025-03-26 05:48:39', 'cristiano3-31742968128pvx38xdgid.jpg', 'cristiano-317429682523hd7hzxlot.jpg', 'active', 'normal', 'none', '', 'VaazhW5FHutwvbwx7Obe1AFxLnlEcvhkCdcgCqISidsJm4zGdYbRA6GUNElJImC0QVx76TVO4L6', '', '', '', '', 'yes', '2025-03-26 05:54:31', '', 'Welcome to my page. If you like my content, please consider support. Thank you for your support!', '', '', '', '', '', NULL, NULL, NULL, NULL, 0.00, 76.00, 'yes', 'US', 'Vegas', '124234', '', '', '', '', '', '', '2025-08-08 11:48:31', 'yes', 'user_3', 'yes', 'yes', 'yes', '', 'yes', '106.215.153.188', 'on', 'male', '01/11/2000', 'no', 'en', 'yes', 0.00, '', '', '', '', 0, '', '', 'yes', 'no', 'no', '', 'no', 'no', 'no', 'yes', 'yes', 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '', '', 'yes', '', '', 'no', 'yes', 'yes', NULL, 0, NULL, '', '', '', '', '', '', 1, '', '', '', 'off', NULL, 1, '', 0, NULL, '', '', '', 1, 1, 0, NULL, NULL, 1, 1, NULL, NULL),
(4, 'Vin Disel', 'vind', '226', '$2y$10$093WyLdfdFvzR8OGPVM3G.bFY00hYQsU0TPyf2KEebAKnvQ81C6Lq', 'viin@demo.com', '2025-03-26 05:56:17', 'vin4-41742968586znoqnirejx.jpg', 'vin4-417429685903riybhubzo.jpg', 'active', 'normal', 'none', '', 'GWCxQs5MzPm689hc5Wg75mXFZwyKlg1OIXVKTqOLONV2wm3uuHroFqrWIGZVEvymanZgglUClED', '', '', '', '', 'yes', '2025-03-26 05:59:27', '', 'Welcome to my page. If you like my content, please consider support. Thank you for your support!', '', '', '', '', '', NULL, NULL, NULL, NULL, 0.00, 28.08, 'yes', 'UK', 'London', '543901', '', '', '', '', '', '', '2025-08-08 11:52:50', 'yes', 'user_4', 'yes', 'yes', 'yes', '', 'yes', '106.215.153.188', 'on', 'male', '06/06/2000', 'no', 'en', 'no', 0.00, '', '', '', '', 0, '', '', 'yes', 'no', 'no', '', 'no', 'no', 'no', 'yes', 'yes', 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '', '', 'yes', '', '', 'no', 'yes', 'yes', NULL, 0, NULL, '', '', '', '', '', '', 1, '', '', '', 'off', NULL, 1, '', 0, NULL, '', '', '', 1, 1, 0, NULL, NULL, 1, 1, NULL, NULL),
(5, 'Dwayne', 'dwayne', '1', '$2y$10$QW1yEx2mEr1PjElLSguiYulFRciYgh9l0xjXE5v/JBjcqLC0eCTce', 'dwayne@demo.com', '2025-03-26 06:00:50', 'dwayne5-51742968860fni1zzfbgw.jpg', 'dwayne5-51742968866q0sx6hbvo4.jpg', 'active', 'normal', 'none', '', 'JqVSzMRigJf28Hyq7KW12HoILXQzDfWafx28fmCOkR7bSdH5pqk3JOPrhPrftoV4ittTcJoE9Dm', '', '', '', '', 'no', NULL, '', 'Welcome to my page. If you like my content, please consider support. Thank you for your support!', '', '', '', '', '', NULL, NULL, NULL, NULL, 0.00, 142.50, 'yes', 'US', 'Vegas', '543901', '', '', '', '', '', '', '2025-08-08 11:59:18', 'yes', 'plan_user_5', 'yes', 'yes', 'yes', '', 'yes', '106.215.153.188', 'on', 'male', '01/12/1999', 'no', 'en', 'yes', 0.00, '', '', '', '', 0, '', '', 'yes', 'no', 'no', '', 'no', 'no', 'no', 'yes', 'yes', 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '', '', 'yes', '', '', 'no', 'yes', 'yes', NULL, 0, NULL, '', '', '', '', '', '', 1, '', '', '', 'off', NULL, 1, '', 0, NULL, '', '', '', 1, 1, 0, NULL, NULL, 1, 1, NULL, NULL),
(6, 'User Demo', 'jack007', '99', '$2y$10$bFiPNCY4dnLPCf4xMFp8ye5lfLR00bSXbMBGQdDwGNkxwLvzxtF.e', 'user@demo.com', '2025-03-28 08:27:49', 'user6-61754651927vgrako9h5u.jpg', '', 'active', 'normal', 'none', '9r4SKQHxp391Ojiji6Q4ITMYRmawjvggyN4jxk1qMV3x8sl7jdBRvpuflDqh', 'GBMpSo4jueBzqQdBVqCQkeAq3wJwbCobOYTWisWIEPGQ8NiSQXvfCXmRTpH2xH60E7auKrkMP9y', '', '', '', '', 'no', NULL, '', 'Welcome to my page. If you like my content, please consider support. Thank you for your support!', '', '', '', '', '', 'cus_S2epoLgjIMRjPz', 'visa', '4242', NULL, 0.00, 10000000.00, 'reject', 'test', 'ttt', '333', '', '', '', '', '', '', '2025-09-27 03:54:23', 'no', 'user_6', 'no', 'no', 'no', '', 'yes', '152.58.155.113', 'off', '', '03/26/2007', 'no', 'en', 'no', 9999780.00, '', '', '', '', 0, '', '', 'no', 'no', 'no', '', 'no', 'no', 'no', 'yes', 'yes', 0, 'yes', 'yes', 'no', 'no', 'no', 'yes', '', '', 'yes', '', '', 'no', 'yes', 'yes', NULL, 0, NULL, '', '', '', '', '', '', 1, '', '', '', 'off', NULL, 1, '', 0, NULL, '', '', '', 1, 1, 0, NULL, NULL, 1, 1, NULL, NULL),
(7, 'Creator Demo', 'creator', '99', '$2y$10$90p7731dKDGkvICtHXph1e2RzDZXb8qYoy7beIrD2vyRg2Iqzxs6C', 'creator@demo.com', '2025-03-28 08:28:35', 'creator7-71743150567puuhjvhajf.jpg', 'creator7-717431506621i96gfj9rl.jpg', 'active', 'normal', 'none', '2PjRZoekru4addpHsYs6oc4nuhJS4Ym6x8SJnefBBzcEWUL6GNaXphk7d5eO', 'kgmmT0gTr6FWrMOQtgxmxesO92s2KvEqGKMaeElzVybQJDv1Bq6eNEMfw4XwPbn93eiGX2FhZ7s', '', '', '', '', 'yes', '2025-08-08 09:05:59', '', 'Welcome to my page. If you like my content, please consider support. Thank you for your support!', 'Developer', '', '', '', '', NULL, NULL, NULL, NULL, 0.00, 0.41, 'yes', 'Mumbai', 'Mumbai', '654321', '', '', '', '', '', '', '2025-09-17 21:46:07', 'yes', 'plan_user_7', 'yes', 'yes', 'yes', '', 'yes', '152.58.155.113', 'on', 'female', '03/19/2002', 'no', 'en', 'yes', 2963.00, '', '', '', '', 0, '', '', 'yes', 'no', 'no', '', 'no', 'no', 'no', 'yes', 'yes', 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '', '', 'yes', '', '', 'no', 'yes', 'yes', NULL, 0, NULL, '', '', '', '', '', '', 1, '', '', '', 'on', 5.00, 1, '', 0, NULL, '', '', '', 1, 1, 0, 100.00, 10, 1, 1, NULL, NULL),
(12, 'Roman', 'roman12', '99', '$2y$10$iBG/iTOlI.pFoqEO421wDexg95Z2occBPfvRa2kl7sivZ/B1fdGvW', 'user1@demo.com', '2025-08-08 11:02:36', 'roman12-1217546509794rzg2kyu92.jpg', 'roman12-12175465119273lwxmenn1.jpg', 'active', 'normal', 'none', 'PeNWniJJD9TlvIadJlDXuDXekalwLvYcPuCBvA7IGTRfcuywjuQd0C3hcP5r', 'BzskiD6ID8f9uAthx7paTUv5yqCDQheN7rg9NJdJnfYLjke1FFyxwNsF85dzKVq58Qh8mW2IpfD', '', '', '', '', 'no', NULL, '', 'Welcome to my page. If you like my content, please consider support. Thank you for your support!', '', '', '', '', '', NULL, NULL, NULL, NULL, 0.00, 0.00, 'yes', '1600 Pennsylvania Ave NW', 'Washington', '20500', '', '', '', '', '', '', '2025-08-08 12:26:57', 'yes', 'user_12', 'yes', 'yes', 'yes', '', 'yes', '106.215.182.200', 'on', 'male', '08/06/2007', 'no', 'en', 'no', 0.00, '', '', '', '', 0, '', '', 'yes', 'no', 'no', '', 'no', 'no', 'no', 'yes', 'yes', 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '', '', 'yes', '', '', 'no', 'yes', 'yes', NULL, 0, NULL, '', '', '', '', '', '', 1, '', '', '', 'off', NULL, 1, '', 0, NULL, '', '', '', 1, 1, 0, NULL, NULL, 1, 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `user_devices`
--

CREATE TABLE `user_devices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `player_id` varchar(255) NOT NULL,
  `device_type` char(5) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `verification_requests`
--

CREATE TABLE `verification_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `address` varchar(200) NOT NULL,
  `city` varchar(150) NOT NULL,
  `zip` varchar(50) NOT NULL,
  `image` varchar(100) NOT NULL,
  `image_reverse` varchar(100) DEFAULT NULL,
  `image_selfie` varchar(100) DEFAULT NULL,
  `status` enum('pending','approved') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `form_w9` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `verification_requests`
--

INSERT INTO `verification_requests` (`id`, `user_id`, `address`, `city`, `zip`, `image`, `image_reverse`, `image_selfie`, `status`, `created_at`, `form_w9`) VALUES
(1, 2, 'US', 'Los angeles', '162990', '217429678033gsyxuthcwqb91mfphdcxxltq9sb3jlugq9csxeb.jpg', 'reverse-21742967803ccncfvs5gbcsaisayepruqzbxafqvd3olk2aciyy.jpg', 'selfie-21742967803xle9mccpgr1hdj6uus9rcjvwyxhit44mi14omwct.jpg', 'approved', '2025-03-26 05:43:23', '21742967803glfl83lltocbordczsgph5mcgwfvwbxbx2vk0yee.pdf'),
(2, 3, 'US', 'Vegas', '124234', '31742968288gamekg2euq6c4cicncdpvhoixa98pzprxxgu5pn6.jpg', 'reverse-31742968288fhl9wewmh9pfx2jpjkwcjfybpdnswtqxjlyn0c7c.jpg', 'selfie-31742968288fnmc2eehiukwndcyl3cecsqyy8xxxeaehxacojly.jpg', 'approved', '2025-03-26 05:51:28', '31742968288vxjevxbsrtsngvvcliw2dekvplmsdnuxiyafuuu5.pdf'),
(3, 4, 'UK', 'London', '543901', '41742968653nn6jkehj87ydjbqv1hlyd6l7nqcypi3oniwv0fbx.jpg', 'reverse-41742968653yqs70wielwo6jkgxakasdtlruuuvo7pvlzamedmq.jpg', 'selfie-41742968653ilgydesdugoh53x3epdt6kezijzxzmdtdulylhpe.jpg', 'approved', '2025-03-26 05:57:33', ''),
(4, 5, 'US', 'Vegas', '543901', '51742969028blwyjpd6ix4ce1l2fi2ty0tetxzvza5gev7clfjy.jpg', 'reverse-517429690286umo1nzec8shpnwqswh0qskextlruwgpb9fvetir.jpg', 'selfie-51742969028crkl4bkrjxcadhw6uhunvsvqdz8akql3dcdpcq2s.jpg', 'approved', '2025-03-26 06:03:48', '5174296902887mcrct6odvnwzjvhtc8rkuxa5tk37lslersfbtw.pdf'),
(5, 7, 'Mumabi', 'Mumbai', '654321', '71743150816a1vzojduoeihcw66yrijmqtos14zl4wuxrlrouap.jpg', 'reverse-71743150816zanfmvlr7h4k7wrqfyzmqtk3pyoqjpx9fuu0xjgv.jpg', 'selfie-71743150816igjeyngazn48y6s9cltggslih5r65amgv9rr1vyu.jpg', 'approved', '2025-03-28 08:33:36', ''),
(8, 12, '1600 Pennsylvania Ave NW', 'Washington', '20500', '121754651512kxyafn8t6dli1xzijsxbhafwfcltkqqfm4aext6y.jpg', 'reverse-121754651512uhu9dp6g5rmtgfmqyyzup6qhgvpzldqxexrchx80.jpg', 'selfie-121754651512zww2u7n9vy67a3dtexbyvajlawptdrznufqtphvf.jpg', 'approved', '2025-08-08 11:11:52', '');

-- --------------------------------------------------------

--
-- Table structure for table `video_calls`
--

CREATE TABLE `video_calls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_id` bigint(20) UNSIGNED NOT NULL,
  `buyer_id` bigint(20) UNSIGNED NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'calling',
  `minutes` int(10) UNSIGNED NOT NULL,
  `token` varchar(200) DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `joined_at` timestamp NULL DEFAULT NULL,
  `ended_at` timestamp NULL DEFAULT NULL,
  `paid` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `video_views`
--

CREATE TABLE `video_views` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `updates_id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `video_views`
--

INSERT INTO `video_views` (`id`, `user_id`, `updates_id`, `ip`, `created_at`, `updated_at`) VALUES
(1, 6, 3, '117.99.247.52', '2025-08-07 15:51:27', '2025-08-07 15:51:27');

-- --------------------------------------------------------

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `status` enum('pending','paid') NOT NULL DEFAULT 'pending',
  `amount` varchar(50) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `gateway` varchar(100) NOT NULL,
  `account` text NOT NULL,
  `estimated_payment` timestamp NULL DEFAULT NULL,
  `date_paid` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `txn_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_settings`
--
ALTER TABLE `admin_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `advertisings`
--
ALTER TABLE `advertisings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clicks` (`clicks`),
  ADD KEY `impressions` (`impressions`),
  ADD KEY `expired_at` (`expired_at`);

--
-- Indexes for table `ad_click_impressions`
--
ALTER TABLE `ad_click_impressions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `advertisings_id` (`advertisings_id`),
  ADD KEY `type` (`type`),
  ADD KEY `ip` (`ip`);

--
-- Indexes for table `audio_calls`
--
ALTER TABLE `audio_calls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `seller_id` (`seller_id`),
  ADD KEY `buyer_id` (`buyer_id`),
  ADD KEY `status` (`status`),
  ADD KEY `token` (`token`),
  ADD KEY `joined_at` (`joined_at`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tags` (`tags`),
  ADD KEY `slug` (`slug`);

--
-- Indexes for table `bookmarks`
--
ALTER TABLE `bookmarks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bookmarks_user_id_index` (`user_id`),
  ADD KEY `bookmarks_updates_id_index` (`updates_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slug` (`slug`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `post` (`updates_id`,`user_id`,`status`);

--
-- Indexes for table `comments_likes`
--
ALTER TABLE `comments_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comments_likes_user_id_index` (`user_id`),
  ADD KEY `comments_likes_comments_id_index` (`comments_id`),
  ADD KEY `comments_likes_replies_id_index` (`replies_id`);

--
-- Indexes for table `comment_like_reels`
--
ALTER TABLE `comment_like_reels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `comment_reels_id` (`comment_reels_id`),
  ADD KEY `reel_replies_id` (`reel_replies_id`);

--
-- Indexes for table `comment_reels`
--
ALTER TABLE `comment_reels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `reels_id` (`reels_id`);

--
-- Indexes for table `conversations`
--
ALTER TABLE `conversations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_1` (`user_1`,`user_2`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `gifts`
--
ALTER TABLE `gifts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `likes`
--
ALTER TABLE `likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_usr` (`user_id`,`updates_id`,`status`);

--
-- Indexes for table `like_reels`
--
ALTER TABLE `like_reels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `reels_id` (`reels_id`);

--
-- Indexes for table `live_comments`
--
ALTER TABLE `live_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `live_comments_user_id_index` (`user_id`),
  ADD KEY `live_comments_live_streamings_id_index` (`live_streamings_id`),
  ADD KEY `gift_id` (`gift_id`);

--
-- Indexes for table `live_likes`
--
ALTER TABLE `live_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `live_likes_user_id_index` (`user_id`),
  ADD KEY `live_likes_live_streamings_id_index` (`live_streamings_id`);

--
-- Indexes for table `live_online_users`
--
ALTER TABLE `live_online_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `live_online_users_user_id_index` (`user_id`),
  ADD KEY `live_online_users_live_streamings_id_index` (`live_streamings_id`);

--
-- Indexes for table `live_streamings`
--
ALTER TABLE `live_streamings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `live_streamings_user_id_index` (`user_id`),
  ADD KEY `type` (`type`),
  ADD KEY `buyer_id` (`buyer_id`),
  ADD KEY `minutes` (`minutes`),
  ADD KEY `joined_at` (`joined_at`),
  ADD KEY `token` (`token`),
  ADD KEY `updated_at` (`updated_at`);

--
-- Indexes for table `live_streaming_private_requests`
--
ALTER TABLE `live_streaming_private_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaction_id` (`transaction_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `creator_id` (`creator_id`),
  ADD KEY `minutes` (`minutes`);

--
-- Indexes for table `login_sessions`
--
ALTER TABLE `login_sessions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_updates_id_index` (`updates_id`),
  ADD KEY `media_user_id_index` (`user_id`),
  ADD KEY `media_type_index` (`type`),
  ADD KEY `media_token_index` (`token`),
  ADD KEY `media_encoded_index` (`encoded`),
  ADD KEY `job_id` (`job_id`);

--
-- Indexes for table `media_messages`
--
ALTER TABLE `media_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_messages_messages_id_index` (`messages_id`),
  ADD KEY `media_messages_type_index` (`type`),
  ADD KEY `media_messages_token_index` (`token`),
  ADD KEY `media_messages_encoded_index` (`encoded`),
  ADD KEY `job_id` (`job_id`);

--
-- Indexes for table `media_products`
--
ALTER TABLE `media_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_products_products_id_index` (`products_id`);

--
-- Indexes for table `media_reels`
--
ALTER TABLE `media_reels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reels_id` (`reels_id`),
  ADD KEY `name` (`name`),
  ADD KEY `job_id` (`job_id`);

--
-- Indexes for table `media_stories`
--
ALTER TABLE `media_stories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_stories_stories_id_index` (`stories_id`),
  ADD KEY `media_stories_name_index` (`name`),
  ADD KEY `media_stories_type_index` (`type`),
  ADD KEY `job_id` (`job_id`);

--
-- Indexes for table `media_welcome_messages`
--
ALTER TABLE `media_welcome_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_welcome_messages_creator_id_index` (`creator_id`),
  ADD KEY `media_welcome_messages_type_index` (`type`),
  ADD KEY `media_welcome_messages_encoded_index` (`encoded`),
  ADD KEY `media_welcome_messages_token_index` (`token`),
  ADD KEY `job_id` (`job_id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `remove_from` (`remove_from`),
  ADD KEY `conversation_id` (`conversations_id`),
  ADD KEY `from_user_id` (`from_user_id`),
  ADD KEY `to_user_id` (`to_user_id`),
  ADD KEY `status` (`status`),
  ADD KEY `mode` (`mode`),
  ADD KEY `gift_id` (`gift_id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `destination` (`destination`),
  ADD KEY `author` (`author`),
  ADD KEY `target` (`target`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slug` (`slug`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_hash` (`token`),
  ADD KEY `email` (`email`);

--
-- Indexes for table `payment_gateways`
--
ALTER TABLE `payment_gateways`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pay_per_views`
--
ALTER TABLE `pay_per_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pay_per_views_user_id_index` (`user_id`),
  ADD KEY `pay_per_views_updates_id_index` (`updates_id`),
  ADD KEY `pay_per_views_messages_id_index` (`messages_id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `plans_name_unique` (`name`),
  ADD KEY `plans_user_id_index` (`user_id`),
  ADD KEY `plans_paystack_index` (`paystack`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_user_id_index` (`user_id`);

--
-- Indexes for table `purchases`
--
ALTER TABLE `purchases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchases_transactions_id_index` (`transactions_id`),
  ADD KEY `purchases_user_id_index` (`user_id`),
  ADD KEY `purchases_products_id_index` (`products_id`),
  ADD KEY `expired_at` (`expired_at`);

--
-- Indexes for table `reels`
--
ALTER TABLE `reels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `type` (`type`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `reel_replies`
--
ALTER TABLE `reel_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `reels_id` (`reels_id`),
  ADD KEY `comment_reels_id` (`comment_reels_id`);

--
-- Indexes for table `referrals`
--
ALTER TABLE `referrals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `referrals_user_id_index` (`user_id`),
  ADD KEY `referrals_referred_by_index` (`referred_by`);

--
-- Indexes for table `referral_transactions`
--
ALTER TABLE `referral_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `referral_transactions_referrals_id_index` (`referrals_id`),
  ADD KEY `referral_transactions_user_id_index` (`user_id`),
  ADD KEY `referral_transactions_referred_by_index` (`referred_by`),
  ADD KEY `referral_transactions_transactions_id_index` (`transactions_id`);

--
-- Indexes for table `replies`
--
ALTER TABLE `replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `replies_user_id_index` (`user_id`),
  ADD KEY `replies_updates_id_index` (`updates_id`),
  ADD KEY `replies_comments_id_index` (`comments_id`);

--
-- Indexes for table `reports`
--
ALTER TABLE `reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user_id`,`report_id`);

--
-- Indexes for table `reserved`
--
ALTER TABLE `reserved`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`) USING BTREE;

--
-- Indexes for table `restrictions`
--
ALTER TABLE `restrictions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `restrictions_user_id_index` (`user_id`),
  ADD KEY `restrictions_user_restricted_index` (`user_restricted`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD UNIQUE KEY `sessions_id_unique` (`id`);

--
-- Indexes for table `shop_categories`
--
ALTER TABLE `shop_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_categories_slug_index` (`slug`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `states_countries_id_index` (`countries_id`),
  ADD KEY `name` (`name`),
  ADD KEY `code` (`code`);

--
-- Indexes for table `stories`
--
ALTER TABLE `stories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stories_user_id_index` (`user_id`),
  ADD KEY `stories_status_index` (`status`);

--
-- Indexes for table `story_backgrounds`
--
ALTER TABLE `story_backgrounds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `story_backgrounds_name_index` (`name`);

--
-- Indexes for table `story_fonts`
--
ALTER TABLE `story_fonts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `story_views`
--
ALTER TABLE `story_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `story_views_user_id_index` (`user_id`),
  ADD KEY `story_views_media_stories_id_index` (`media_stories_id`);

--
-- Indexes for table `stripe_state_tokens`
--
ALTER TABLE `stripe_state_tokens`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `last_payment` (`last_payment`(191)),
  ADD KEY `payment_id` (`payment_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `stripe_status` (`stripe_status`),
  ADD KEY `stripe_id` (`stripe_id`),
  ADD KEY `stripe_price` (`stripe_price`),
  ADD KEY `free` (`free`),
  ADD KEY `creator_id` (`creator_id`),
  ADD KEY `rebill_wallet` (`rebill_wallet`),
  ADD KEY `cancelled` (`cancelled`),
  ADD KEY `gateway` (`gateway`);

--
-- Indexes for table `subscription_deleteds`
--
ALTER TABLE `subscription_deleteds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subscription_deleteds_creator_id_index` (`creator_id`),
  ADD KEY `subscription_deleteds_user_id_index` (`user_id`);

--
-- Indexes for table `subscription_items`
--
ALTER TABLE `subscription_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscription_id` (`subscription_id`);

--
-- Indexes for table `tax_rates`
--
ALTER TABLE `tax_rates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`),
  ADD KEY `type` (`type`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `subscriber` (`subscriptions_id`),
  ADD KEY `subscribed` (`subscribed`),
  ADD KEY `earning_net_user` (`earning_net_user`),
  ADD KEY `earning_net_admin` (`earning_net_admin`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `amount` (`amount`),
  ADD KEY `approved` (`approved`),
  ADD KEY `gift_id` (`gift_id`);

--
-- Indexes for table `two_factor_codes`
--
ALTER TABLE `two_factor_codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `updates`
--
ALTER TABLE `updates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `token_id` (`token_id`),
  ADD KEY `video_views` (`video_views`),
  ADD KEY `status` (`status`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `can_media_edit` (`can_media_edit`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `role` (`role`),
  ADD KEY `permission` (`permission`),
  ADD KEY `categories_id` (`categories_id`),
  ADD KEY `stripe_id` (`stripe_id`(191)),
  ADD KEY `users_blocked_countries_index` (`blocked_countries`(768)),
  ADD KEY `username` (`username`),
  ADD KEY `status` (`status`),
  ADD KEY `permissions` (`permissions`(768)),
  ADD KEY `countries_id` (`countries_id`);

--
-- Indexes for table `user_devices`
--
ALTER TABLE `user_devices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_devices_player_id_unique` (`player_id`);

--
-- Indexes for table `verification_requests`
--
ALTER TABLE `verification_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `video_calls`
--
ALTER TABLE `video_calls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `seller_id` (`seller_id`),
  ADD KEY `buyer_id` (`buyer_id`),
  ADD KEY `status` (`status`),
  ADD KEY `token` (`token`),
  ADD KEY `joined_at` (`joined_at`);

--
-- Indexes for table `video_views`
--
ALTER TABLE `video_views`
  ADD PRIMARY KEY (`id`),
  ADD KEY `video_views_user_id_index` (`user_id`),
  ADD KEY `video_views_updates_id_index` (`updates_id`),
  ADD KEY `video_views_ip_index` (`ip`);

--
-- Indexes for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaings_id` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_settings`
--
ALTER TABLE `admin_settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `advertisings`
--
ALTER TABLE `advertisings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ad_click_impressions`
--
ALTER TABLE `ad_click_impressions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `audio_calls`
--
ALTER TABLE `audio_calls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bookmarks`
--
ALTER TABLE `bookmarks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `comments_likes`
--
ALTER TABLE `comments_likes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comment_like_reels`
--
ALTER TABLE `comment_like_reels`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comment_reels`
--
ALTER TABLE `comment_reels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `conversations`
--
ALTER TABLE `conversations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=243;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gifts`
--
ALTER TABLE `gifts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `likes`
--
ALTER TABLE `likes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `like_reels`
--
ALTER TABLE `like_reels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `live_comments`
--
ALTER TABLE `live_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `live_likes`
--
ALTER TABLE `live_likes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `live_online_users`
--
ALTER TABLE `live_online_users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `live_streamings`
--
ALTER TABLE `live_streamings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `live_streaming_private_requests`
--
ALTER TABLE `live_streaming_private_requests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_sessions`
--
ALTER TABLE `login_sessions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `media_messages`
--
ALTER TABLE `media_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `media_products`
--
ALTER TABLE `media_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `media_reels`
--
ALTER TABLE `media_reels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `media_stories`
--
ALTER TABLE `media_stories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `media_welcome_messages`
--
ALTER TABLE `media_welcome_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `password_resets`
--
ALTER TABLE `password_resets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_gateways`
--
ALTER TABLE `payment_gateways`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `pay_per_views`
--
ALTER TABLE `pay_per_views`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `purchases`
--
ALTER TABLE `purchases`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `reels`
--
ALTER TABLE `reels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `reel_replies`
--
ALTER TABLE `reel_replies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referrals`
--
ALTER TABLE `referrals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_transactions`
--
ALTER TABLE `referral_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `replies`
--
ALTER TABLE `replies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `reserved`
--
ALTER TABLE `reserved`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `restrictions`
--
ALTER TABLE `restrictions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `shop_categories`
--
ALTER TABLE `shop_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stories`
--
ALTER TABLE `stories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `story_backgrounds`
--
ALTER TABLE `story_backgrounds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `story_fonts`
--
ALTER TABLE `story_fonts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `story_views`
--
ALTER TABLE `story_views`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stripe_state_tokens`
--
ALTER TABLE `stripe_state_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `subscription_deleteds`
--
ALTER TABLE `subscription_deleteds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `subscription_items`
--
ALTER TABLE `subscription_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tax_rates`
--
ALTER TABLE `tax_rates`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `two_factor_codes`
--
ALTER TABLE `two_factor_codes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `updates`
--
ALTER TABLE `updates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `user_devices`
--
ALTER TABLE `user_devices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `verification_requests`
--
ALTER TABLE `verification_requests`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `video_calls`
--
ALTER TABLE `video_calls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `video_views`
--
ALTER TABLE `video_views`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;