INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(276, 'default', '{\"uuid\":\"bbab252b-5f2c-478a-b1c7-d2e8e5dad2d0\",\"displayName\":\"App\\\\Notifications\\\\AcceptedVideoCall\",\"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:35:\\\"App\\\\Notifications\\\\AcceptedVideoCall\\\":3:{s:13:\\\"formattedDate\\\";s:12:\\\"Apr 16, 2026\\\";s:46:\\\"\\u0000App\\\\Notifications\\\\AcceptedVideoCall\\u0000videoCall\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\VideoCall\\\";s:2:\\\"id\\\";i:9937;s:9:\\\"relations\\\";a:1:{i:0;s:5:\\\"buyer\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"96b2a49b-1706-4089-bec5-f168b734cac2\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1776403751,\"delay\":null}', 0, NULL, 1776403751, 1776403751),
(277, 'default', '{\"uuid\":\"47f5fe91-c23f-46b4-960a-6025b7289930\",\"displayName\":\"App\\\\Notifications\\\\NewMessageReceived\",\"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:36;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:36:\\\"App\\\\Notifications\\\\NewMessageReceived\\\":2:{s:45:\\\"\\u0000App\\\\Notifications\\\\NewMessageReceived\\u0000message\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:19:\\\"App\\\\Models\\\\Messages\\\";s:2:\\\"id\\\";i:82;s:9:\\\"relations\\\";a:2:{i:0;s:12:\\\"transactions\\\";i:1;s:8:\\\"receiver\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"649cf5c2-3a18-4a10-870b-25321b342555\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1776428492,\"delay\":null}', 0, NULL, 1776428492, 1776428492),
(278, 'default', '{\"uuid\":\"216e13e8-810f-43e6-8796-18125c173df3\",\"displayName\":\"App\\\\Notifications\\\\NewMessageReceived\",\"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:20;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:36:\\\"App\\\\Notifications\\\\NewMessageReceived\\\":2:{s:45:\\\"\\u0000App\\\\Notifications\\\\NewMessageReceived\\u0000message\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:19:\\\"App\\\\Models\\\\Messages\\\";s:2:\\\"id\\\";i:85;s:9:\\\"relations\\\";a:2:{i:0;s:12:\\\"transactions\\\";i:1;s:8:\\\"receiver\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"6bd415b4-5b30-4c32-a8b7-60ee7091d299\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1777809310,\"delay\":null}', 0, NULL, 1777809310, 1777809310),
(279, 'default', '{\"uuid\":\"f267b6cd-84b9-44b2-96c9-b2bc17f3c413\",\"displayName\":\"App\\\\Notifications\\\\NewVerificationRequest\",\"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:15:\\\"admin@admin.com\\\";}}}s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;}s:12:\\\"notification\\\";O:40:\\\"App\\\\Notifications\\\\NewVerificationRequest\\\":2:{s:4:\\\"data\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:31:\\\"App\\\\Models\\\\VerificationRequests\\\";s:2:\\\"id\\\";i:24;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"81942f7e-6ab5-4bd2-95c7-e67fde0fed96\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1779175826,\"delay\":null}', 0, NULL, 1779175826, 1779175826),
(280, 'default', '{\"uuid\":\"9b9d3adb-958a-4fe1-a44c-e3406fd08e38\",\"displayName\":\"App\\\\Notifications\\\\NewMessageReceived\",\"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:14;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:36:\\\"App\\\\Notifications\\\\NewMessageReceived\\\":2:{s:45:\\\"\\u0000App\\\\Notifications\\\\NewMessageReceived\\u0000message\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:19:\\\"App\\\\Models\\\\Messages\\\";s:2:\\\"id\\\";i:89;s:9:\\\"relations\\\";a:2:{i:0;s:12:\\\"transactions\\\";i:1;s:8:\\\"receiver\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"c6699e22-f468-4435-95a0-e226db772082\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1779949399,\"delay\":null}', 0, NULL, 1779949399, 1779949399),
(281, 'default', '{\"uuid\":\"bf1b1cd5-096c-427e-b623-c710b6dc4cab\",\"displayName\":\"App\\\\Notifications\\\\NewMessageReceived\",\"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:12;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:36:\\\"App\\\\Notifications\\\\NewMessageReceived\\\":2:{s:45:\\\"\\u0000App\\\\Notifications\\\\NewMessageReceived\\u0000message\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:19:\\\"App\\\\Models\\\\Messages\\\";s:2:\\\"id\\\";i:90;s:9:\\\"relations\\\";a:2:{i:0;s:12:\\\"transactions\\\";i:1;s:8:\\\"receiver\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"be261873-7da9-40d9-8abd-4c77fb56a24a\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1779949425,\"delay\":null}', 0, NULL, 1779949425, 1779949425),
(282, 'default', '{\"uuid\":\"a6fe35b0-2493-4cbb-a16d-07b094950bbb\",\"displayName\":\"App\\\\Notifications\\\\AdminWithdrawalPending\",\"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:15:\\\"admin@admin.com\\\";}}}s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;}s:12:\\\"notification\\\";O:40:\\\"App\\\\Notifications\\\\AdminWithdrawalPending\\\":2:{s:4:\\\"data\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\Withdrawals\\\";s:2:\\\"id\\\";i:9;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:2:\\\"id\\\";s:36:\\\"d5c69a7d-39db-485d-80c7-1edcc2791b62\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}}\"},\"createdAt\":1780906909,\"delay\":null}', 0, NULL, 1780906909, 1780906909);

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

--
-- 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'),
(6, 'Spanish', 'es'),
(7, 'German', 'de'),
(8, 'French', 'fr');

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

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

CREATE TABLE `messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `transactions_id` bigint(20) UNSIGNED DEFAULT NULL,
  `custom_offer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'text',
  `buyer_id` int(10) UNSIGNED NOT NULL,
  `sender_id` int(10) UNSIGNED NOT NULL,
  `receiver_id` int(10) UNSIGNED NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `messages` (`id`, `transactions_id`, `custom_offer_id`, `type`, `buyer_id`, `sender_id`, `receiver_id`, `message`, `status`, `created_at`, `updated_at`) VALUES
(49, 78, NULL, 'text', 2, 2, 12, 'Hello Carry!', 'readed', '2026-02-26 11:30:51', '2026-02-26 11:30:51'),
(50, 79, NULL, 'text', 2, 2, 12, 'Hello Carry!', 'readed', '2026-02-26 11:31:05', '2026-02-26 11:31:05'),
(51, 80, NULL, 'text', 2, 2, 12, 'Hello Carry!', 'readed', '2026-02-26 11:31:07', '2026-02-26 11:31:07'),
(52, 81, NULL, 'text', 2, 2, 12, 'Hello Carry!', 'readed', '2026-02-26 11:31:08', '2026-02-26 11:31:08'),
(53, 83, NULL, 'text', 2, 2, 12, 'Hello', 'readed', '2026-02-26 11:48:16', '2026-02-26 11:48:16'),
(54, 91, NULL, 'text', 2, 2, 12, 'Hello carryminati, how are you?', 'readed', '2026-02-27 05:27:04', '2026-02-27 05:27:04'),
(55, 0, NULL, 'text', 12, 12, 2, 'good what about you', 'readed', '2026-02-27 05:31:00', '2026-02-27 05:31:00'),
(56, 92, NULL, 'text', 2, 2, 12, 'Hello Bhai', 'readed', '2026-02-27 05:31:01', '2026-02-27 05:31:01'),
(57, 93, NULL, 'text', 2, 2, 12, 'I am also good', 'readed', '2026-02-27 05:31:40', '2026-02-27 05:31:40'),
(58, 94, NULL, 'text', 2, 2, 12, 'Hi', 'readed', '2026-02-27 05:32:58', '2026-02-27 06:21:06'),
(59, 0, NULL, 'text', 12, 12, 2, 'hiii', 'readed', '2026-02-27 06:21:14', '2026-02-27 06:21:50'),
(60, 101, NULL, 'text', 2, 2, 12, 'test est etste sfdsf', 'readed', '2026-02-27 07:09:52', '2026-02-27 07:09:52'),
(61, 102, NULL, 'text', 2, 2, 12, 'test est etste sfdsf', 'readed', '2026-02-27 07:09:57', '2026-02-27 07:09:57'),
(62, 103, NULL, 'text', 2, 2, 12, 'test', 'readed', '2026-02-27 07:28:33', '2026-02-27 07:28:33'),
(63, 104, NULL, 'text', 2, 2, 12, 'teste12', 'readed', '2026-02-27 07:29:38', '2026-02-27 07:29:38'),
(64, 0, NULL, 'text', 2, 2, 12, 'teste12', 'readed', '2026-02-27 07:29:38', '2026-02-27 07:29:38'),
(65, 110, NULL, 'text', 2, 2, 12, 'Hi', 'readed', '2026-02-27 09:42:47', '2026-02-27 09:42:47'),
(66, 0, NULL, 'text', 2, 2, 12, 'Hi', 'readed', '2026-02-27 09:42:47', '2026-02-27 09:42:47'),
(67, 111, NULL, 'text', 2, 2, 12, 'Hi carry', 'readed', '2026-02-27 09:43:22', '2026-02-27 09:43:22'),
(68, 140, NULL, 'text', 2, 2, 12, 'hdhshgzhszhhshzhhzhzhzhzhNSNZ', 'readed', '2026-03-06 09:15:47', '2026-03-06 09:15:47'),
(69, 141, NULL, 'text', 2, 2, 12, 'fhhgffvbbvcdghvcdxccc', 'readed', '2026-03-06 09:17:55', '2026-03-06 09:17:55'),
(70, 142, NULL, 'text', 2, 2, 12, 'fhhgffvbbvcdghvcdxccc', 'readed', '2026-03-06 09:18:24', '2026-03-06 09:18:24'),
(71, 143, NULL, 'text', 2, 2, 12, 'gddgdhsgagagahVhHbshB', 'readed', '2026-03-06 09:24:04', '2026-03-06 09:24:04'),
(72, 146, NULL, 'text', 2, 2, 12, 'ffhfjfjdhdjdjdjdjdjdjdjdjshs', 'readed', '2026-03-10 04:10:02', '2026-03-10 04:10:02'),
(73, 163, NULL, 'text', 2, 2, 12, 'sghahshhshshshshshHHHH', 'readed', '2026-03-11 11:20:08', '2026-03-11 16:54:34'),
(74, 0, NULL, 'text', 12, 12, 2, 'hello', 'readed', '2026-03-12 08:01:50', '2026-03-12 08:01:50'),
(75, 0, NULL, 'text', 12, 12, 2, 'hii', 'readed', '2026-03-12 08:20:02', '2026-03-12 08:20:02'),
(76, 0, NULL, 'text', 12, 12, 2, 'hello', 'readed', '2026-03-12 08:25:18', '2026-03-12 08:25:18'),
(77, 0, NULL, 'text', 12, 12, 2, 'hello', 'readed', '2026-03-12 08:28:35', '2026-03-12 08:28:35'),
(78, 0, NULL, 'text', 12, 12, 2, 'hii', 'readed', '2026-03-12 08:31:25', '2026-03-12 08:31:25'),
(79, 0, NULL, 'text', 12, 12, 2, 'hi', 'readed', '2026-04-02 04:42:02', '2026-04-02 05:10:41'),
(80, 0, NULL, 'text', 12, 12, 2, 'hey user', 'readed', '2026-04-02 05:10:36', '2026-04-02 05:10:41'),
(81, 176, NULL, 'text', 2, 2, 12, 'hello how are you carry', 'readed', '2026-04-02 05:11:13', '2026-04-02 05:11:13'),
(82, 177, NULL, 'text', 1, 1, 36, 'hi', 'new', '2026-04-17 12:21:32', '2026-04-17 12:21:32'),
(83, 178, NULL, 'text', 1, 1, 36, 'Hello', 'new', '2026-04-17 12:21:52', '2026-04-17 12:21:52'),
(84, 0, NULL, 'text', 1, 1, 36, 'Hello', 'new', '2026-04-17 12:21:52', '2026-04-17 12:21:52'),
(85, 179, NULL, 'text', 12, 12, 20, 'vdfv', 'new', '2026-05-03 11:55:09', '2026-05-03 11:55:09'),
(86, 182, NULL, 'text', 648, 648, 14, 'sksdsdsdsdss sssd s df sdf', 'new', '2026-05-28 06:16:59', '2026-05-28 06:16:59'),
(87, 184, NULL, 'text', 648, 648, 12, 'asd   da d s  sd as d as d asd', 'new', '2026-05-28 06:17:55', '2026-05-28 06:17:55'),
(88, 185, NULL, 'text', 648, 648, 12, 'a sd sd s c s c sd c sd', 'new', '2026-05-28 06:20:38', '2026-05-28 06:20:38'),
(89, 186, NULL, 'text', 648, 648, 14, 'dss d sd sd', 'new', '2026-05-28 06:23:19', '2026-05-28 06:23:19'),
(90, 187, NULL, 'text', 648, 648, 12, 'hello', 'new', '2026-05-28 06:23:45', '2026-05-28 06:23:45');

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

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

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2024_06_21_151311_create_promotional_videos_table', 1),
('2024_06_25_193909_create_video_occasions_table', 2),
('2026_02_20_083126_add_verification_tiers_to_admin_settings_table', 3),
('2026_02_20_083128_add_tier_to_users_and_verification_requests_table', 4),
('2026_02_20_111733_create_verification_audit_logs_table', 5),
('2026_02_23_082512_add_tier_free_followers_to_admin_settings', 6),
('2026_02_23_085518_make_tier_nullable_in_verification_requests', 7),
('2026_02_23_102236_add_marketplace_fields_to_users_table', 8),
('2026_02_23_121206_create_stories_table', 9),
('2026_02_23_121207_create_story_views_table', 10),
('2026_02_23_092837_create_profile_views_table', 11),
('2026_02_20_071920_add_business_wizard_fields_to_orders_table', 12),
('2026_02_20_090127_add_scheduled_date_to_orders_table', 13),
('2026_02_20_095416_create_video_request_categories_table', 14),
('2026_02_20_095417_add_video_request_category_id_to_orders_table', 15),
('2026_02_20_114244_create_user_business_licenses_table', 16),
('2026_02_23_101724_create_user_video_request_categories_table', 17),
('2026_02_23_104658_add_requesting_for_and_image_to_orders_table', 18),
('2026_02_23_120243_alter_scheduled_date_to_datetime_on_orders_table', 19),
('2026_02_23_121207_add_story_module_to_admin_settings', 20),
('2026_02_24_051119_create_order_tips_table', 21),
('2026_02_24_051332_create_tips_table', 22),
('2026_02_24_054112_add_allow_tip_to_admin_settings_table', 23),
('2026_02_24_063005_add_allow_download_setting_to_admin_settings_table', 24),
('2026_02_24_063005_add_allow_download_to_orders_table', 25),
('2026_02_24_084441_add_ai_subtitle_settings_to_admin_settings', 26),
('2026_02_24_084443_add_subtitles_to_video_tables', 27),
('2026_02_24_110000_add_subtitle_settings_to_admin_settings_table', 28),
('2019_12_14_000001_create_personal_access_tokens_table', 29),
('2026_03_10_143818_add_agora_app_certificate_to_admin_settings', 30),
('2026_05_19_120000_create_business_profiles_table', 31),
('2026_05_19_120100_create_business_contacts_table', 32),
('2026_05_19_120200_create_business_team_members_table', 33),
('2026_05_19_120300_create_business_invitations_table', 34),
('2026_05_19_130000_add_business_module_to_admin_settings', 35),
('2026_05_19_140000_add_workspace_and_approval_fields_to_orders_table', 36),
('2026_05_19_140100_create_business_campaign_assets_table', 37),
('2026_05_19_140200_create_business_order_comments_table', 38),
('2026_05_20_110000_add_business_talent_marketplace_fields', 39),
('2026_05_20_110100_create_user_audience_demographics_table', 40),
('2026_05_22_100000_add_licensing_fields_to_orders_table', 41),
('2026_05_22_110000_create_advanced_pricing_tables', 42),
('2026_05_22_000001_create_creator_social_handles_table', 43),
('2026_05_22_000002_create_creator_faqs_table', 44),
('2026_05_22_000003_expand_user_audience_demographics', 45),
('2026_05_25_000001_create_campaigns_table', 46),
('2026_05_25_000002_create_campaign_applications_table', 47),
('2026_05_25_151518_create_invoice_items_table', 48),
('2026_05_25_150835_add_billing_fields_to_business_profiles_table', 49),
('2026_05_25_151517_create_invoices_table', 50),
('2026_05_25_160529_add_subscription_fields_to_business_profiles_table', 51),
('2026_05_25_162120_create_business_refunds_table', 52),
('2026_05_25_173736_create_order_approvals_table', 53),
('2026_05_25_173736_create_order_milestones_table', 54),
('2026_05_25_173737_add_revision_fields_to_orders_table', 55),
('2026_05_25_224829_create_campaign_analytics_table', 56),
('2026_05_25_224829_create_campaign_conversions_table', 57),
('2026_05_26_071744_create_business_asset_folders_table', 58),
('2026_05_26_071754_add_media_management_fields_to_business_campaign_assets_table', 59),
('2026_05_25_153900_create_campaign_groups_table', 60),
('2026_05_25_153917_add_bulk_features_to_campaigns_table', 61),
('2026_05_26_092738_add_multi_video_fields_to_campaigns', 62),
('2026_05_26_100000_create_audit_logs_table', 63),
('2026_05_26_100001_add_nda_fields_to_campaigns', 64),
('2026_05_26_200000_add_premium_support_fields_to_business_profiles_table', 65),
('2026_05_26_200001_create_support_tickets_table', 66),
('2026_05_26_200002_create_support_ticket_replies_table', 67),
('2026_05_26_200003_create_onboarding_checklists_table', 68),
('2026_05_27_165727_change_campaigns_file_columns_to_json', 69),
('2026_06_08_000000_add_bulk_payout_options_to_admin_settings_table', 70);

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

--
-- 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` varchar(200) NOT NULL,
  `type` varchar(100) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0 unseen, 1 seen',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) 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`, `updated_at`) VALUES
(3, 68, 68, '68', 'verificationApproved', '1', '2026-02-20 06:59:20', '2026-02-20 07:08:59'),
(126, 2, 2, '2', 'verificationApproved', '1', '2026-02-27 05:38:27', '2026-02-27 05:38:39'),
(132, 2, 12, '0', 'orderReject', '1', '2026-02-27 08:04:39', '2026-02-27 09:42:13'),
(137, 2, 12, '0', 'videoCallAccept', '1', '2026-02-27 09:48:09', '2026-03-03 12:26:33'),
(139, 2, 12, '0', 'videoCallReject', '1', '2026-02-27 09:49:06', '2026-03-03 12:26:33'),
(141, 2, 12, '0', 'orderReject', '1', '2026-02-27 09:50:33', '2026-03-03 12:26:33'),
(143, 2, 12, '0', 'orderReject', '1', '2026-02-27 09:52:00', '2026-03-03 12:26:33'),
(146, 2, 12, '0', 'orderCompleted', '1', '2026-03-02 05:01:38', '2026-03-03 12:26:33'),
(148, 2, 12, '0', 'orderCompleted', '1', '2026-03-02 05:02:50', '2026-03-03 12:26:33'),
(168, 2, 12, '0', 'orderCompleted', '1', '2026-03-06 09:26:54', '2026-03-06 11:43:13'),
(169, 2, 12, '0', 'orderCompleted', '1', '2026-03-06 09:28:23', '2026-03-06 11:43:13'),
(171, 2, 12, '0', 'orderCompleted', '1', '2026-03-06 09:37:41', '2026-03-06 11:43:13'),
(172, 2, 12, '0', 'orderCompleted', '1', '2026-03-06 10:27:42', '2026-03-06 11:43:13'),
(174, 2, 12, '0', 'orderCompleted', '1', '2026-03-06 10:30:37', '2026-03-06 11:43:13'),
(176, 645, 645, '645', 'verificationApproved', '1', '2026-03-09 06:12:07', '2026-03-09 06:12:29'),
(177, 2, 12, '0', 'orderCompleted', '1', '2026-03-10 05:32:22', '2026-03-10 06:47:06'),
(178, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 06:35:53', '2026-03-10 06:47:06'),
(179, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 06:37:34', '2026-03-10 06:47:06'),
(181, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 07:15:45', '2026-03-10 18:08:12'),
(182, 2, 12, '0', 'refundApproved', '1', '2026-03-10 13:37:28', '2026-03-10 18:08:12'),
(185, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 14:00:58', '2026-03-10 18:08:12'),
(186, 2, 12, 'a3f88088-2593-4453-aa74-a3ddf2a79499', 'videoCallStart', '1', '2026-03-10 14:03:54', '2026-03-10 18:08:12'),
(188, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 14:21:56', '2026-03-10 18:08:12'),
(189, 2, 12, '530cb3b7-aeff-43a1-9c3b-6221d12cf1cf', 'videoCallStart', '1', '2026-03-10 14:22:59', '2026-03-10 18:08:12'),
(190, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 14:59:23', '2026-03-10 18:08:12'),
(191, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 14:59:37', '2026-03-10 18:08:12'),
(192, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 14:59:46', '2026-03-10 18:08:12'),
(193, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 14:59:53', '2026-03-10 18:08:12'),
(194, 2, 12, '0', 'videoCallReject', '1', '2026-03-10 15:00:00', '2026-03-10 18:08:12'),
(196, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 17:37:44', '2026-03-10 18:08:12'),
(197, 2, 12, '7f95034d-e333-44ae-8306-363e9ac7ef79', 'videoCallStart', '1', '2026-03-10 17:38:32', '2026-03-10 18:08:12'),
(198, 2, 12, '7f95034d-e333-44ae-8306-363e9ac7ef79', 'videoCallStart', '1', '2026-03-10 17:39:53', '2026-03-10 18:08:12'),
(200, 2, 12, '0', 'videoCallAccept', '1', '2026-03-10 18:02:31', '2026-03-10 18:08:12'),
(201, 2, 12, 'bde9d4e6-435a-4669-a3e6-951c5fa66fa1', 'videoCallStart', '1', '2026-03-10 18:02:46', '2026-03-10 18:08:12'),
(203, 2, 12, '0', 'videoCallAccept', '1', '2026-03-11 09:11:52', '2026-03-11 09:13:23'),
(204, 2, 12, 'a325bf86-5bed-4caa-a7d8-46e149cd0cce', 'videoCallStart', '1', '2026-03-11 09:13:05', '2026-03-11 09:13:23'),
(206, 2, 12, '0', 'videoCallAccept', '1', '2026-03-11 09:23:39', '2026-03-11 09:24:05'),
(207, 2, 12, '5bee53a0-67be-4cdc-9763-df7dc5b74c6f', 'videoCallStart', '1', '2026-03-11 09:23:54', '2026-03-11 09:24:05'),
(210, 2, 12, '0', 'videoCallReject', '1', '2026-03-11 09:37:28', '2026-03-11 09:39:19'),
(211, 2, 12, '0', 'videoCallAccept', '1', '2026-03-11 09:38:31', '2026-03-11 09:39:19'),
(212, 2, 12, '983cc8bb-cc3d-4d43-9db7-15c0c4faa687', 'videoCallStart', '1', '2026-03-11 09:39:03', '2026-03-11 09:39:19'),
(214, 2, 12, '0', 'videoCallAccept', '1', '2026-03-11 09:55:19', '2026-03-11 09:55:51'),
(215, 2, 12, 'a10dff55-1846-4791-bf5f-9b2b5623979f', 'videoCallStart', '1', '2026-03-11 09:55:43', '2026-03-11 09:55:51'),
(217, 2, 12, '0', 'videoCallAccept', '1', '2026-03-11 10:14:09', '2026-03-11 10:14:36'),
(218, 2, 12, '4ef0ee78-2519-44cb-8be8-83b018751e27', 'videoCallStart', '1', '2026-03-11 10:14:25', '2026-03-11 10:14:36'),
(220, 2, 12, '0', 'videoCallAccept', '1', '2026-03-11 10:26:14', '2026-03-11 10:26:37'),
(221, 2, 12, 'e5933937-b713-44dd-bc34-7e2a6a4062ae', 'videoCallStart', '1', '2026-03-11 10:26:28', '2026-03-11 10:26:37'),
(223, 2, 12, '0', 'videoCallAccept', '1', '2026-03-11 10:40:13', '2026-03-11 10:42:03'),
(224, 2, 12, 'e281e9d8-fefd-44f9-8889-ccd73a6dc2ca', 'videoCallStart', '1', '2026-03-11 10:41:54', '2026-03-11 10:42:03'),
(227, 2, 12, '0', 'orderCompleted', '1', '2026-03-11 11:33:36', '2026-03-12 10:30:34'),
(228, 2, 12, '0', 'videoCallAccept', '1', '2026-03-12 10:04:47', '2026-03-12 10:30:34'),
(237, 2, 12, '0', 'orderCompleted', '1', '2026-04-01 04:37:18', '2026-04-01 05:54:06'),
(238, 2, 12, '0', 'orderCompleted', '1', '2026-04-01 04:37:48', '2026-04-01 05:54:06'),
(239, 2, 12, '0', 'orderCompleted', '1', '2026-04-01 04:38:18', '2026-04-01 05:54:06'),
(240, 2, 12, '0', 'orderCompleted', '1', '2026-04-01 04:38:49', '2026-04-01 05:54:06'),
(243, 2, 12, '0', 'refundApproved', '1', '2026-04-01 05:02:38', '2026-04-01 05:54:06'),
(244, 2, 12, '0', 'refundDeclined', '1', '2026-04-01 05:08:18', '2026-04-01 05:54:06'),
(246, 2, 12, '0', 'refundApproved', '1', '2026-04-01 07:20:39', '2026-04-01 12:01:49'),
(248, 2, 12, '0', 'refundApproved', '1', '2026-04-01 07:21:50', '2026-04-01 12:01:49'),
(250, 2, 12, '0', 'refundApproved', '1', '2026-04-01 07:24:48', '2026-04-01 12:01:49'),
(252, 2, 12, '0', 'refundApproved', '1', '2026-04-01 07:26:41', '2026-04-01 12:01:49'),
(254, 2, 12, '0', 'refundApproved', '1', '2026-04-01 07:57:34', '2026-04-01 12:01:49'),
(259, 2, 12, '0', 'refundDeclined', '1', '2026-04-01 08:18:14', '2026-04-01 12:01:49'),
(260, 2, 12, '0', 'refundDeclined', '1', '2026-04-01 08:21:50', '2026-04-01 12:01:49'),
(261, 2, 12, '0', 'orderCompleted', '1', '2026-04-01 08:24:12', '2026-04-01 12:01:49'),
(263, 2, 12, '0', 'refundApproved', '1', '2026-04-01 08:25:17', '2026-04-01 12:01:49'),
(264, 2, 12, '0', 'orderCompleted', '1', '2026-04-01 08:26:32', '2026-04-01 12:01:49'),
(272, 2, 12, '0', 'orderCompleted', '1', '2026-04-01 11:37:49', '2026-04-01 12:01:49'),
(274, 2, 12, '0', 'orderCompleted', '1', '2026-04-02 05:10:01', '2026-04-02 05:28:41'),
(277, 2, 12, '0', 'refundDeclined', '1', '2026-04-02 05:13:31', '2026-04-02 05:28:41'),
(279, 2, 12, '0', 'refundApproved', '1', '2026-04-02 05:13:59', '2026-04-02 05:28:41'),
(280, 2, 12, '0', 'videoCallAccept', '1', '2026-04-02 05:15:06', '2026-04-02 05:28:41'),
(281, 2, 12, 'fcbb4037-41f2-4417-af36-3197de54bdde', 'videoCallStart', '1', '2026-04-02 05:20:09', '2026-04-02 05:28:41'),
(282, 2, 12, '0', 'videoCallAccept', '1', '2026-04-17 05:29:10', '2026-04-28 12:48:18'),
(283, 14, 12, '972', 'newOrder', '0', '2026-05-03 18:20:51', '2026-05-03 18:20:51'),
(285, 12, 648, '973', 'newOrder', '1', '2026-05-28 06:16:21', '2026-05-28 06:34:04'),
(286, 14, 648, '974', 'newOrder', '0', '2026-05-28 06:17:28', '2026-05-28 06:17:28'),
(287, 648, 12, '0', 'orderCompleted', '1', '2026-05-28 06:34:21', '2026-05-28 08:23:01'),
(288, 12, 648, '9939', 'newVideoCallRequest', '0', '2026-05-28 06:40:07', '2026-05-28 06:40:07'),
(289, 12, 648, '9940', 'newVideoCallRequest', '0', '2026-05-28 06:40:38', '2026-05-28 06:40:38'),
(290, 12, 648, '9941', 'newVideoCallRequest', '0', '2026-05-28 06:47:40', '2026-05-28 06:47:40');

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

--
-- Table structure for table `onboarding_checklists`
--

CREATE TABLE `onboarding_checklists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `business_profile_id` bigint(20) UNSIGNED NOT NULL,
  `steps` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`steps`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `transactions_id` int(10) UNSIGNED DEFAULT NULL,
  `custom_offer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `revenue_share_pct` decimal(5,2) NOT NULL DEFAULT 0.00,
  `seller_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `business_profile_id` bigint(20) UNSIGNED DEFAULT NULL,
  `receiver_name` varchar(200) DEFAULT NULL,
  `type` varchar(100) NOT NULL,
  `requesting_for` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `public` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  `occasion` varchar(200) DEFAULT NULL,
  `instructions` text NOT NULL,
  `script_type` varchar(255) NOT NULL DEFAULT 'Talking points',
  `required_lines` varchar(255) DEFAULT NULL,
  `scheduled_date` datetime DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `duration_video` varchar(50) DEFAULT NULL,
  `video_poster` varchar(255) DEFAULT NULL,
  `subtitles` varchar(255) DEFAULT NULL,
  `encode` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `flash_delivery` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `how_use_video_business` varchar(255) DEFAULT NULL,
  `business_name` varchar(255) DEFAULT NULL,
  `pronunciation` varchar(255) DEFAULT NULL,
  `license_duration` varchar(255) DEFAULT NULL,
  `commercial_platforms` text DEFAULT NULL,
  `geographic_rights` varchar(255) DEFAULT NULL,
  `is_exclusive` tinyint(1) NOT NULL DEFAULT 0,
  `contract_signed_at` timestamp NULL DEFAULT NULL,
  `signature_image` varchar(255) DEFAULT NULL,
  `signee_name` varchar(255) DEFAULT NULL,
  `signee_title` varchar(255) DEFAULT NULL,
  `contract_pdf_path` varchar(255) DEFAULT NULL,
  `industry` varchar(255) DEFAULT NULL,
  `brief_description_business` text DEFAULT NULL,
  `tone_style` varchar(255) DEFAULT NULL,
  `filming_requirements` varchar(255) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `revision_count` int(11) NOT NULL DEFAULT 0,
  `approval_status` varchar(255) NOT NULL DEFAULT 'approved',
  `expires` timestamp NULL DEFAULT NULL,
  `reason_cancel` text DEFAULT NULL,
  `job_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `video_request_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `allow_download` enum('yes','no') NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `transactions_id`, `custom_offer_id`, `revenue_share_pct`, `seller_id`, `user_id`, `business_profile_id`, `receiver_name`, `type`, `requesting_for`, `image`, `public`, `occasion`, `instructions`, `script_type`, `required_lines`, `scheduled_date`, `video`, `duration_video`, `video_poster`, `subtitles`, `encode`, `flash_delivery`, `how_use_video_business`, `business_name`, `pronunciation`, `license_duration`, `commercial_platforms`, `geographic_rights`, `is_exclusive`, `contract_signed_at`, `signature_image`, `signee_name`, `signee_title`, `contract_pdf_path`, `industry`, `brief_description_business`, `tone_style`, `filming_requirements`, `status`, `revision_count`, `approval_status`, `expires`, `reason_cancel`, `job_id`, `created_at`, `updated_at`, `video_request_category_id`, `allow_download`) VALUES
(1, 1, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'Hello everyone! \n\nI’m Carry Minati, and I’m excited to connect with you today. \n\nAs you know, I’ve always been passionate about creating content that resonates with you, my amazing audience.', 'Talking points', '', '0000-00-00 00:00:00', '12699d6315b64e01771922197fp9er7ypkt2xfpj8lw0t.mp4', NULL, NULL, NULL, 0, 0, 'Marketing', 'TEst', '333', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'We would like to request Carry Minati to create a vibrant promotional video announcing the launch of our new product, aimed at engaging his audience and generating excitement around our brand.', 'The video will have a cool and charismatic tone, infused with cheeky humor while maintaining a professional edge.', 'Filming Instructions for Carry Minati:\n\n1. Orientation: Landscape mode for video content.', 'delivered', 0, 'approved', '2026-03-03 03:03:08', NULL, NULL, '2026-02-24 03:03:08', '2026-02-24 03:06:41', NULL, 'no'),
(2, 2, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', '0000-00-00 00:00:00', '2J5vjSOPW63xEfEGC5TRw699d6d63a8d7d1771924835-converted.mp4', '00:36', 'pTu7N6Pa6hdlAqpluSQr699d6d63a8d991771924835-poster.jpg', NULL, 0, 0, 'Marketing', 'Test', '3333', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'delivered', 0, 'approved', '2026-03-03 03:25:03', NULL, NULL, '2026-02-24 03:25:03', '2026-02-24 03:51:08', NULL, 'no'),
(3, 3, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'Hello everyone! \n\nI’m Carry Minati, and I’m excited to connect with you today. \n\nI want to take a moment to share something special with you all. \n\nAs you know, I’m passionate about creating content that resonates with my audience, and I’m always looking for new ways to engage and entertain you.', 'Talking points', '', '0000-00-00 00:00:00', '3PP9KaebtblOVdrrgPLY4699d703c285641771925564-converted.mp4', '00:59', 'qlcbAYJNAoyLVpCe4SCn699d703c286a51771925564-poster.jpg', NULL, 0, 0, 'Marketing', 'TEst', 'eee', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'We are looking to create a dynamic promotional video featuring Carry Minati to announce our upcoming product launch and engage our audience with his unique style and influence.', 'The video will have a cool and charismatic tone, infused with cheeky humor while maintaining a professional edge.', '', 'delivered', 0, 'approved', '2026-03-03 04:02:04', NULL, NULL, '2026-02-24 04:02:04', '2026-02-24 04:03:40', NULL, 'no'),
(4, 4, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', '', '0000-00-00 00:00:00', '40M72a7osAb07ELZGL55N699d769eeb30e1771927198-converted.mp4', '00:59', 'pYnzstjMn4628IwCPWqA699d769eebbb41771927198-poster.jpg', NULL, 0, 0, 'Marketing', 'etst', 'ee', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', '', 'delivered', 0, 'approved', '2026-03-03 04:29:19', NULL, NULL, '2026-02-24 04:29:19', '2026-02-24 04:30:41', NULL, 'no'),
(5, 5, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', '', '0000-00-00 00:00:00', '5V0oFFxx6YaE805S3KBVp699d79a2042f11771927970-converted.mp4', '00:59', 'qyDszzYYgAlfYJjMEoTX699d79a2057151771927970-poster.jpg', NULL, 0, 0, 'Marketing', 'dddddd', 'dd', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', '', '', 'delivered', 0, 'approved', '2026-03-03 04:42:07', NULL, NULL, '2026-02-24 04:42:07', '2026-02-24 04:43:29', NULL, 'no'),
(6, 6, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 0, NULL, 'What\'s the goal of this video?\r\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', '', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, 0, 0, 'Marketing', 'eees', 'eee', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\r\nAre you announcing a new product? Celebrating a milestone?', '', '', 'canceled', 0, 'approved', '2026-03-03 04:49:35', NULL, NULL, '2026-02-24 04:49:35', '2026-03-12 09:19:55', NULL, 'no'),
(7, 7, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', '', '0000-00-00 00:00:00', '75Adx0SeVikAA7tGmCJ7Z699d7d4f562991771928911-converted.mp4', '00:59', 'D3YqxLeQ2wPqGWvrwyqo699d7d4f56a271771928911-poster.jpg', NULL, 0, 0, 'Marketing', 'dd', 'dd', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', '', '', 'delivered', 0, 'approved', '2026-03-03 04:57:57', NULL, NULL, '2026-02-24 04:57:57', '2026-02-24 04:59:16', NULL, 'no'),
(8, 8, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milesto', 'Talking points', '', '0000-00-00 00:00:00', '8BN2GqItc7XFAYQABmhOV699d7e5cc2cc71771929180-converted.mp4', '00:59', 'FlLNOqH7f7lyNkpDqzoJ699d7e5cc36a21771929180-poster.jpg', NULL, 0, 0, 'Marketing', 'eee', 'ee', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milesto', '', '', 'delivered', 0, 'approved', '2026-03-03 05:02:37', NULL, NULL, '2026-02-24 05:02:37', '2026-02-24 05:03:53', NULL, 'no'),
(9, 9, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', '', '0000-00-00 00:00:00', '9vXoCkS5izxMqSupOGNJC699d8cad7109b1771932845-converted.mp4', '00:59', '6PqhahQA2BfZvF9Pmf3g699d8cad719f71771932845-poster.jpg', NULL, 0, 0, 'Marketing', 'ee', 'eee', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', '', '', 'delivered', 0, 'approved', '2026-03-03 06:03:38', NULL, NULL, '2026-02-24 06:03:38', '2026-02-24 06:04:57', NULL, 'no'),
(10, 10, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', '', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, 0, 0, 'Marketing', 'wwmw', 'ww', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', '', '', 'canceled', 0, 'approved', '2026-03-03 06:05:09', NULL, NULL, '2026-02-24 06:05:09', '2026-03-12 09:19:55', NULL, 'no'),
(11, 11, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'ffmpeg running commandffmpeg running commandffmpeg running commandffmpeg running commandffmpeg running commandffmpeg running commandffmpeg running command', 'Talking points', '', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, 0, 0, 'Marketing', 'dd', 'ddd', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'ffmpeg running commandffmpeg running commandffmpeg running commandffmpeg running command', '', '', 'canceled', 0, 'approved', '2026-03-03 06:19:45', NULL, NULL, '2026-02-24 06:19:45', '2026-03-12 09:19:55', NULL, 'no'),
(12, 12, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'google/gemini-2.5-flashgoogle/gemini-2.5-flashgoogle/gemini-2.5-flashgoogle/gemini-2.5-flash', 'Talking points', '', '0000-00-00 00:00:00', '12mjadcDKNKCVahXbF0NYV699d9536137a61771935030-converted.mp4', '00:59', 'bDH5CzSDZ5VvUmPpySIl699d953614f0b1771935030-poster.jpg', NULL, 0, 0, 'Marketing', 'eee', 'eee', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'We would like to invite Carry Minati to create a dynamic video announcement for our upcoming product launch, which aims to engage our audience and generate excitement around our innovative offerings.', '', '', 'delivered', 0, 'approved', '2026-03-03 06:29:42', NULL, NULL, '2026-02-24 06:29:42', '2026-02-24 06:41:19', NULL, 'no'),
(13, 13, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'eekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemk', 'Talking points', '', '0000-00-00 00:00:00', '13k6EbiuU5IS8nBIFKrM10699d972657b911771935526-converted.mp4', '00:59', 'a2zcBFrimtsDCxJqmYhS699d97265865b1771935526-poster.jpg', NULL, 0, 0, 'Marketing', 'ekeke', 'eee', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'eekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemkeekemkemekemk', '', '', 'delivered', 0, 'approved', '2026-03-03 06:48:08', NULL, NULL, '2026-02-24 06:48:08', '2026-02-24 06:49:38', NULL, 'no'),
(14, 14, NULL, 0.00, 12, 70, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'Are you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', '', '0000-00-00 00:00:00', '14iW44uBMPSxtjcXb1NkTn699dbdd7884521771945431-converted.mp4', '00:59', 'FYstocmhpt18iAMhpytq699dbdd7886e31771945431-poster.jpg', NULL, 0, 0, 'Marketing', 'eememe', 'eeee', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'eeeeAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?\n\nAre you announcing a new product? Celebrating a milestone?', '', '', 'delivered', 0, 'approved', '2026-03-03 07:07:16', NULL, NULL, '2026-02-24 07:07:16', '2026-02-24 09:34:27', NULL, 'no'),
(15, 15, NULL, 0.00, 70, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'Hi User 25! We’d love for you to share a heartfelt message in the video. Please introduce yourself, share a fun fact, and give some advice for aspiring creators. A personal touch would be amazing! Thank you!', 'Talking points', NULL, '0000-00-00 00:00:00', '15H6PtKUI4P0VLSqdIAJGR699ddb0a3a2e21771952906-converted.mp4', '00:59', 'qxkX64P1EvdhXXWfbc2C699ddb0a3aaef1771952906-poster.jpg', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-03-03 11:38:02', NULL, NULL, '2026-02-24 11:38:02', '2026-02-24 11:38:57', 1, 'no'),
(53, 29, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772085513_699fe10912145.png', 1, NULL, 'test est et ete tete testse testest', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-03-05 00:28:33', NULL, NULL, '2026-02-26 00:28:33', NULL, 1, 'no'),
(54, 30, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772085783_699fe217f2a87.png', 1, NULL, 'tes test t etetes testest etset', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-03-05 00:33:04', NULL, NULL, '2026-02-26 00:33:04', NULL, 2, 'no'),
(55, 31, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772085898_699fe28a102ed.png', 1, NULL, 'tes test etsete esfsete', 'Talking points', NULL, '0000-00-00 00:00:00', '12699fe333aef5c1772086067i3i0t3j8ecld0l4kf1cq.mp4', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pending', 0, 'approved', '2026-03-05 00:34:58', NULL, NULL, '2026-02-26 00:34:58', '2026-02-26 00:37:52', 2, 'yes'),
(57, 32, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'test est est etsete tsetet', 'Talking points', NULL, '0000-00-00 00:00:00', '12699fe3bc854191772086204tzleqntqyxmtddyipleh.mp4', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pending', 0, 'approved', '2026-03-05 00:39:47', NULL, NULL, '2026-02-26 00:39:47', '2026-02-26 00:40:06', 2, 'yes'),
(70, 33, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'tes test este tet estestests', 'Talking points', NULL, '0000-00-00 00:00:00', '12699fe5f3d698d1772086771qeeszoojazkoqkzepihf.mp4', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pending', 0, 'approved', '2026-03-05 00:49:19', 'Cancel cancel cancel', NULL, '2026-02-26 00:49:19', '2026-02-27 04:58:34', 1, 'yes'),
(71, 34, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'test est estest este ses este ste', 'Talking points', NULL, '0000-00-00 00:00:00', '12699fec50ea3341772088400jbf3na8ewrfsa46sfhtl.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-03-05 01:16:12', NULL, NULL, '2026-02-26 01:16:12', '2026-02-26 01:16:43', 1, 'yes'),
(933, 77, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772103540_69a02774241b0.png', 1, NULL, 'Roast Roast Roast Roast', 'Talking points', NULL, '2026-02-26 16:37:00', 'MicrosoftTeams-video.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'scheduled', 0, 'approved', '2026-03-05 10:56:38', 'not working', NULL, '2026-02-26 10:56:38', '2026-02-26 11:12:08', 1, 'yes'),
(934, 82, NULL, 0.00, 12, 2, NULL, 'Gangadhar', 'custom_video', 'Someone Else', '1772106386_69a03292cef9a.png', 1, NULL, 'Shaktimaan Shaktimaan Shaktimaan', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'canceled', 0, 'approved', '2026-03-05 11:46:27', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', NULL, '2026-02-26 11:46:27', '2026-02-27 06:03:29', 2, 'no'),
(935, 84, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772168198_69a124061bf9d.png', 1, 'birthday', 'Happy Birthday to you! dfsfsf', 'Talking points', NULL, '2026-02-27 10:31:00', '1269a1244d90a0c1772168269fe88nxo1erm1ckm8d2xt.mp4', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'canceled', 0, 'approved', '2026-03-06 04:56:38', 'not good', NULL, '2026-02-27 04:56:38', '2026-03-05 06:14:22', 1, 'yes'),
(936, 85, NULL, 0.00, 12, 2, NULL, 'John Doe', 'custom_video', 'Someone Else', '1772168682_69a125ea13e26.png', 1, NULL, 'Motivational Video about Junior G', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-02-28 05:04:42', NULL, NULL, '2026-02-27 05:04:42', NULL, 2, 'no'),
(937, 86, NULL, 0.00, 12, 2, NULL, 'John Doe', 'custom_video', 'Someone Else', '1772168793_69a126599ed02.png', 1, NULL, 'Create a video to motivate Junior G', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-02-28 05:06:34', NULL, NULL, '2026-02-27 05:06:34', NULL, 2, 'no'),
(938, 87, NULL, 0.00, 12, 2, NULL, 'John Doe', 'custom_video', 'Someone Else', '1772168922_69a126dac17bb.png', 1, NULL, 'Draft a motivational video', 'Talking points', NULL, NULL, '1269ccd6b82204b1775031992ws5yuln48lf5fffcus2e.mp4', NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-02-28 05:08:43', 'new order', NULL, '2026-02-27 05:08:43', '2026-04-01 08:26:32', 2, 'yes'),
(939, 88, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772169189_69a127e51a72e.png', 1, NULL, 'Motivational Video for Junior G AAA', 'Talking points', NULL, '2026-02-27 10:46:00', '1269a12816c37691772169238tbz9nwixehwk8l2jpnrq.mp4', NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pending', 0, 'approved', '2026-02-28 05:13:09', NULL, NULL, '2026-02-27 05:13:09', '2026-03-05 12:16:24', 2, 'yes'),
(940, 89, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772169395_69a128b3afe6f.png', 1, NULL, 'Hello world!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-02-28 05:16:36', NULL, NULL, '2026-02-27 05:16:36', NULL, 2, 'no'),
(941, 90, NULL, 0.00, 12, 2, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'IT Solutions, website designing, app designing, cloud solutions', 'Talking points', '', '2026-02-27 10:57:00', '1269a12accc80281772169932lipax26tay3ruhachlg5.mp4', NULL, NULL, NULL, 1, 0, 'Marketing', 'Miracuves', 'Mira Q vs', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'Marketing the various services and products.', 'Cool', 'Proper lighting', 'canceled', 0, 'approved', '2026-03-06 05:24:41', 'heloooooooooooooooooooooooooooooooo', NULL, '2026-02-27 05:24:41', '2026-02-27 06:03:45', NULL, 'yes'),
(942, 95, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772175131_69a13f1bf07d2.png', 1, NULL, 'tes est este testsaet estse tsetest', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'canceled', 0, 'approved', '2026-03-06 06:52:12', 'test etse t', NULL, '2026-02-27 06:52:12', '2026-02-27 06:52:17', 1, 'no'),
(943, 96, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'test estse testes testes', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-03-06 06:54:13', NULL, NULL, '2026-02-27 06:54:13', NULL, 2, 'no'),
(944, 97, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'test estes test setestes testset', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-03-06 06:59:39', NULL, NULL, '2026-02-27 06:59:39', NULL, 2, 'no'),
(945, 98, NULL, 0.00, 12, 1, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'Talking points', 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', NULL, NULL, NULL, NULL, NULL, 0, 0, 'Marketing', 'rrrrr', 'rrr', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', 'What\'s the goal of this video?\nAre you announcing a new product? Celebrating a milestone?', '', 'initiated', 0, 'approved', '2026-03-06 07:02:24', NULL, NULL, '2026-02-27 07:02:24', NULL, NULL, 'no'),
(946, 99, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'grdsg rsgsdfgsgsddgff g', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-03-06 07:08:07', NULL, NULL, '2026-02-27 07:08:07', NULL, 1, 'no'),
(947, 100, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'tea fesfes fsdfdsfds fdsfdsf sdf', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-03-06 07:09:25', NULL, NULL, '2026-02-27 07:09:25', NULL, 1, 'no'),
(948, 106, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'test est est e st setet et etset', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'rejected', 0, 'approved', '2026-03-06 08:02:48', 'tes test est', NULL, '2026-02-27 08:02:48', '2026-02-27 08:04:39', 1, 'no'),
(949, 109, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'test et setetestet test es ssee ete te', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'rejected', 0, 'approved', '2026-03-06 08:24:50', 'no nononono', NULL, '2026-02-27 08:24:50', '2026-02-27 09:50:33', 1, 'no'),
(950, 114, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772185825_69a168e13c4a9.png', 1, NULL, 'Happy birthday to you', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'rejected', 0, 'approved', '2026-03-06 09:50:25', 'not an issue', NULL, '2026-02-27 09:50:25', '2026-02-27 09:52:00', 1, 'no'),
(951, 115, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', '1772186023_69a169a75abf1.png', 1, NULL, 'Hello world, hello Mars', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'initiated', 0, 'approved', '2026-02-28 09:53:43', NULL, NULL, '2026-02-27 09:53:43', NULL, 1, 'no'),
(952, 116, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'test estes tsetest setest estsetestse trtsr tsr', 'Talking points', NULL, '2026-03-19 13:33:00', '1269a5196a065201772427626nytfaexrmlk9xzrled3c.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'scheduled', 0, 'approved', '2026-03-09 04:59:50', NULL, NULL, '2026-03-02 04:59:50', '2026-03-02 05:00:32', 1, 'yes'),
(953, 117, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'tes tests sefdfdg sfgddg rt rtrt', 'Talking points', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refunded', 0, 'approved', '2026-03-09 05:01:13', NULL, NULL, '2026-03-02 05:01:13', '2026-03-10 13:37:28', 1, 'yes'),
(954, 118, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'tes test etset ete stsrt rstsrt rtsrtsr tsrt', 'Talking points', NULL, '0000-00-00 00:00:00', '1269a519f86e1d51772427768oshijbssosrowwgr2ahw.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-03-09 05:02:25', NULL, NULL, '2026-03-02 05:02:25', '2026-03-02 05:02:50', 2, 'yes'),
(955, 128, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'hddjdhdhshhshshhdhdhhsjzhzhs.   tyhhgffg gfhhgfh dfdfd', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refunded', 0, 'approved', '2026-03-12 12:47:24', NULL, NULL, '2026-03-05 12:47:24', '2026-04-01 08:25:17', 1, 'yes'),
(956, 129, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'bdhd kh hdhhdjhddjsjzjsjsj bbbbbbbbbbb dd', 'Talking points', NULL, NULL, '1269aface684bac1773120742wy831is6e7avf5lzfppv.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-03-13 04:54:48', NULL, NULL, '2026-03-06 04:54:48', '2026-03-10 05:32:22', 1, 'yes'),
(957, 130, NULL, 0.00, 12, 2, NULL, 'demo', 'custom_video', 'Someone Else', NULL, 1, '', 'motivational dhhdhhshssghs hg', 'Talking points', NULL, NULL, '1269aaac1ed019317727928621sqqblzronxutqrjmxgo.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-03-13 04:56:39', NULL, NULL, '2026-03-06 04:56:39', '2026-03-06 10:27:42', 2, 'yes'),
(958, 131, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'gfgfhghfdgsggsgagagagagsgag', 'Talking points', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refunded', 0, 'approved', '2026-03-13 05:10:14', NULL, NULL, '2026-03-06 05:10:14', '2026-04-01 07:57:34', 2, 'yes'),
(959, 132, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'sfghgdfhhhffdfghhfffyhhh', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'canceled', 0, 'approved', '2026-03-13 05:20:00', 'dgg', NULL, '2026-03-06 05:20:00', '2026-03-06 05:20:21', 1, 'no'),
(960, 133, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'assdfffhhhhfffdgghjjggf', 'Talking points', NULL, NULL, '1269aa9e37b04c11772789303fcxb13u3l59hp7rjgofw.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-03-13 05:20:46', NULL, NULL, '2026-03-06 05:20:46', '2026-03-06 09:28:23', 2, 'no'),
(961, 134, NULL, 0.00, 12, 2, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'gdfgdgdfggdfgggdvzvsgzgzgsg', 'Talking points', '', NULL, '1269aa9dde742911772789214lud1r06i4ddgydinzxnf.mp4', NULL, NULL, NULL, 0, 0, 'Marketing', 'hdhshsgaga', NULL, '15', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'bbfdfgdgfdgfgfgfgfgfdgdfgfdggd', '', '', 'delivered', 0, 'approved', '2026-03-13 05:29:54', NULL, NULL, '2026-03-06 05:29:54', '2026-03-06 09:26:54', NULL, 'no'),
(962, 135, NULL, 0.00, 12, 2, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'rhusbxdgjshshdjshshs', 'Exact script', '', NULL, '1269aa8123c68b517727818592qhgjstjdoli3v3v4amy.mp4', NULL, NULL, NULL, 0, 0, 'Business event', 'ggghghf', NULL, '20', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'sgysysggagagagagagagagag', '', '', 'delivered', 0, 'approved', '2026-03-13 05:32:31', NULL, NULL, '2026-03-06 05:32:31', '2026-03-06 07:24:19', NULL, 'no'),
(963, 145, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'hello birthday hello hello', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refunded', 0, 'approved', '2026-03-13 10:29:52', NULL, NULL, '2026-03-06 10:29:52', '2026-04-01 07:26:41', 1, 'yes'),
(964, 161, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'svvshshshsbsbsbsbsbsbBBBBBs', 'Talking points', NULL, NULL, '1269b105b81c0861773209016olmdeua42v9utkz8tadj.mp4', NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-03-12 11:19:31', NULL, NULL, '2026-03-11 11:19:31', '2026-03-11 11:33:36', 2, 'yes'),
(965, 164, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'happy birthday sir ...............', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refunded', 0, 'approved', '2026-03-27 10:52:11', NULL, NULL, '2026-03-20 10:52:11', '2026-04-01 07:24:48', 1, 'yes'),
(966, 165, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'fhjgddtyjjvcbmnnvccccvbn', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refunded', 0, 'approved', '2026-03-27 11:41:57', NULL, NULL, '2026-03-20 11:41:57', '2026-04-01 07:21:50', 1, 'yes'),
(967, 166, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'gjhfdghgfdtyyuujgffffgghhh', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refunded', 0, 'approved', '2026-03-27 12:53:45', NULL, NULL, '2026-03-20 12:53:45', '2026-04-01 07:20:39', 1, 'yes'),
(968, 167, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, NULL, 'hello how are you my friend birthday to share your video', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refunded', 0, 'approved', '2026-04-08 04:28:53', NULL, NULL, '2026-04-01 04:28:53', '2026-04-01 05:02:38', 1, 'yes'),
(969, 169, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'motivational speach for carry minati', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pending', 0, 'approved', '2026-04-08 08:52:21', NULL, NULL, '2026-04-01 08:52:21', '2026-04-01 08:52:21', 2, 'no'),
(970, 170, NULL, 0.00, 12, 2, NULL, NULL, 'custom_video_business', NULL, NULL, 1, NULL, 'sky is the main plaform', 'Talking points', '', NULL, NULL, NULL, NULL, NULL, 0, 0, 'Marketing', 'sky', '', '30', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'sky is the best platform', '', '', 'refunded', 0, 'approved', '2026-04-08 08:53:57', NULL, NULL, '2026-04-01 08:53:57', '2026-04-02 05:13:59', NULL, 'yes'),
(971, 174, NULL, 0.00, 12, 2, NULL, 'User Demo', 'custom_video', 'Me', NULL, 1, '', 'hello happy birthday to jayesh sir', 'Talking points', NULL, NULL, '1269cdfa29e455a1775106601tmxafiy4cz6s10nfsdv7.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-04-09 04:22:49', NULL, NULL, '2026-04-02 04:22:49', '2026-04-02 05:10:01', 1, 'yes'),
(972, 180, NULL, 0.00, 14, 12, NULL, 'Carry Minati', 'custom_video', 'Me', NULL, 1, NULL, 'n hb n ,m m   h vghb gvj', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pending', 0, 'approved', '2026-05-04 18:20:51', NULL, NULL, '2026-05-03 18:20:51', '2026-05-03 18:20:51', 1, 'no'),
(973, 181, NULL, 0.00, 12, 648, NULL, 'User 2', 'custom_video', 'Me', NULL, 1, NULL, 'jhkjj s f sfdfsd fsdf  f  df sd f sdf s f sd f sf s fs fsd f', 'Talking points', NULL, '0000-00-00 00:00:00', '126a17e1e7ebe7717799500558jvmzrixtlvf9mde1i2n.mp4', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'delivered', 0, 'approved', '2026-06-04 06:16:21', NULL, NULL, '2026-05-28 06:16:21', '2026-05-28 06:34:20', 1, 'yes'),
(974, 183, NULL, 0.00, 14, 648, NULL, 'User 2', 'custom_video', 'Me', NULL, 1, NULL, 'd da sd asd  asd a sd a sd a s as d as  as dasd', 'Talking points', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'pending', 0, 'approved', '2026-06-04 06:17:28', NULL, NULL, '2026-05-28 06:17:28', '2026-05-28 06:17:28', 1, 'no');

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

--
-- Table structure for table `order_approvals`
--

CREATE TABLE `order_approvals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `stage` enum('compliance','brand','legal') NOT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `reviewer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_milestones`
--

CREATE TABLE `order_milestones` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','active','completed','paid') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_tips`
--

CREATE TABLE `order_tips` (
  `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 `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 'en',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `pages` (`id`, `title`, `content`, `slug`, `description`, `keywords`, `lang`, `created_at`, `updated_at`) VALUES
(2, 'Terms of Service', '<p>Welcome to <strong>MxMeo</strong>, a platform that allows fans to request and receive personalized video messages from their favorite stars. By using MxMeo (&ldquo;we,&rdquo; &ldquo;our,&rdquo; or &ldquo;us&rdquo;), you (&ldquo;user,&rdquo; &ldquo;you,&rdquo; or &ldquo;customer&rdquo;) agree to the following Terms and Conditions. Please read carefully before making any purchase or request.</p>\r\n\r\n<h2><strong>1. Eligibility</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>You must be at least 18 years old or have parental/guardian consent to use MxMeo.</p>\r\n	</li>\r\n	<li>\r\n	<p>By using the platform, you confirm that all information provided is accurate and complete.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>2. Services</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>MxMeo connects fans with celebrities, influencers, and public figures (&ldquo;Stars&rdquo;) to create personalized video messages.</p>\r\n	</li>\r\n	<li>\r\n	<p>All video requests are subject to the availability and approval of the Star.</p>\r\n	</li>\r\n	<li>\r\n	<p>MxMeo does not guarantee that every request will be accepted. If a request is declined, you will be notified, and a refund will be processed (see Refund Policy below).</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>3. User Requests</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>You must provide clear and respectful instructions for your personalized video.</p>\r\n	</li>\r\n	<li>\r\n	<p>Requests must not include:</p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>Offensive, abusive, defamatory, or discriminatory content.</p>\r\n		</li>\r\n		<li>\r\n		<p>Requests for illegal activities, political endorsements, or explicit material.</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n	<li>\r\n	<p>Stars reserve the right to refuse any request that violates these rules or that they are uncomfortable fulfilling.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>4. Ownership and Usage Rights</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>You are granted a <strong>personal, non-commercial license</strong> to use and share the personalized video for personal enjoyment only (e.g., posting on your social media with attribution to the Star).</p>\r\n	</li>\r\n	<li>\r\n	<p>Videos may <strong>not</strong> be used for:</p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>Commercial purposes (advertising, promotions, endorsements, resale).</p>\r\n		</li>\r\n		<li>\r\n		<p>Political or religious campaigns.</p>\r\n		</li>\r\n		<li>\r\n		<p>Creating deepfakes or manipulated content.</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n	<li>\r\n	<p>MxMeo and the Stars retain all intellectual property rights in the videos.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>5. Delivery</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Delivery times may vary based on the Star&rsquo;s availability. While MxMeo makes reasonable efforts to deliver videos within the estimated time, delays may occur, and we are not liable for such delays.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>6. Refund Policy</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Refunds will be issued if:</p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>The Star declines your request.</p>\r\n		</li>\r\n		<li>\r\n		<p>The video cannot be delivered due to technical or scheduling issues.</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n	<li>\r\n	<p>Refunds will not be issued if:</p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>The video is delivered as per your request.</p>\r\n		</li>\r\n		<li>\r\n		<p>You are dissatisfied with the Star&rsquo;s performance style, appearance, or interpretation</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>7. Star&rsquo;s Discretion</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Stars have full creative freedom in how they deliver your request. By placing a request, you acknowledge that the final product may not be exactly as you envisioned.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>8. Platform Rights</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>MxMeo reserves the right to use delivered videos (or parts of them) for marketing, promotions, and platform-related purposes, unless you opt-out by contacting us at the time of request.</p>\r\n	</li>\r\n	<li>\r\n	<p>MxMeo may update, suspend, or terminate the service at any time.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>9. Limitation of Liability</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>MxMeo is not responsible for any direct, indirect, or incidental damages resulting from the use of our services.</p>\r\n	</li>\r\n	<li>\r\n	<p>We do not guarantee the accuracy, reliability, or completeness of any content created by Stars.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>10. Privacy</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Your personal information will be handled in accordance with our <strong>Privacy Policy</strong>.</p>\r\n	</li>\r\n	<li>\r\n	<p>By using MxMeo, you consent to sharing limited information (such as your name and request details) with the selected Star.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>11. Governing Law</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>These Terms and Conditions are governed by and construed in accordance with the laws of [Insert Jurisdiction].</p>\r\n	</li>\r\n	<li>\r\n	<p>Any disputes shall be subject to the exclusive jurisdiction of the courts in [Insert Location].</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>12. Contact Us</strong></h2>\r\n\r\n<p>For questions or concerns regarding these Terms and Conditions, please contact: support@mxmeo.com</p>', 'terms-of-service', 'Terms of Service of Mxmeo', 'terms, Terms of Service', 'en', '2022-11-09 05:28:44', '2026-02-19 03:25:10'),
(3, 'Privacy', '<p>MxMeo (&ldquo;we,&rdquo; &ldquo;our,&rdquo; or &ldquo;us&rdquo;) values your privacy and is committed to protecting your personal data. This Privacy Policy explains how we collect, use, and safeguard your information when you use our services, including requesting personalized videos from your favorite stars.</p>\r\n\r\n<h2><strong>1. Information We Collect</strong></h2>\r\n\r\n<p>When you use MxMeo, we may collect the following types of information:</p>\r\n\r\n<p><strong>a. Personal Information</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Name, email address, phone number, billing details.</p>\r\n	</li>\r\n	<li>\r\n	<p>Information you provide in video requests (e.g., names, occasions, personal messages).</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>b. Technical Information</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>IP address, device type, browser, operating system.</p>\r\n	</li>\r\n	<li>\r\n	<p>Usage data such as pages visited, time spent, and actions taken on our platform.</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>c. Payment Information</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Processed securely through third-party payment providers (e.g., Stripe, Razorpay).</p>\r\n	</li>\r\n	<li>\r\n	<p>MxMeo does not store your full credit/debit card details.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>2. How We Use Your Information</strong></h2>\r\n\r\n<p>We use the information we collect to:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Provide and deliver your requested personalized videos.</p>\r\n	</li>\r\n	<li>\r\n	<p>Communicate with you regarding orders, updates, and support.</p>\r\n	</li>\r\n	<li>\r\n	<p>Improve and personalize our services.</p>\r\n	</li>\r\n	<li>\r\n	<p>Process payments and prevent fraud.</p>\r\n	</li>\r\n	<li>\r\n	<p>Comply with legal and regulatory obligations.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>3. Sharing of Information</strong></h2>\r\n\r\n<p>We may share your information only in the following cases:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>With Stars:</strong> To enable them to create your personalized video.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>With Service Providers:</strong> Payment processors, hosting providers, analytics tools, and customer support platforms.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>For Legal Reasons:</strong> If required by law, regulation, or legal process.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Business Transfers:</strong> In the event of a merger, acquisition, or sale of company assets.</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>We do <strong>not</strong> sell or rent your personal data to third parties.</p>\r\n\r\n<h2><strong>4. Your Content in Videos</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Information you include in your video request (such as names, occasions, or greetings) may appear in the video and be visible if you share it publicly.</p>\r\n	</li>\r\n	<li>\r\n	<p>By submitting a request, you consent to this use.</p>\r\n	</li>\r\n	<li>\r\n	<p>You may request removal of specific information by contacting us.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>5. Data Retention</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>We retain your personal data only for as long as necessary to fulfill your request, comply with legal obligations, and resolve disputes.</p>\r\n	</li>\r\n	<li>\r\n	<p>Videos may be stored for platform use (e.g., promotions, with your consent) unless you opt out at the time of request.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>6. Security</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>We use industry-standard security measures (encryption, firewalls, secure servers) to protect your data.</p>\r\n	</li>\r\n	<li>\r\n	<p>However, no system is 100% secure, and we cannot guarantee absolute protection.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>7. Your Rights</strong></h2>\r\n\r\n<p>Depending on your jurisdiction, you may have the right to:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Access, correct, or delete your personal data.</p>\r\n	</li>\r\n	<li>\r\n	<p>Withdraw consent for certain processing.</p>\r\n	</li>\r\n	<li>\r\n	<p>Request a copy of your data.</p>\r\n	</li>\r\n	<li>\r\n	<p>Opt out of promotional communications.</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>To exercise these rights, please contact us at demo@demo.com</p>\r\n\r\n<h2><strong>8. Children&rsquo;s Privacy</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Our services are not directed at children under 13 (or the minimum legal age in your country).</p>\r\n	</li>\r\n	<li>\r\n	<p>If we discover we have collected data from a child without parental consent, we will delete it immediately.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>9. Cookies and Tracking</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p>We use cookies and similar technologies to enhance user experience, analyze traffic, and personalize content.</p>\r\n	</li>\r\n	<li>\r\n	<p>You may manage cookie preferences in your browser settings.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>10. Changes to This Policy</strong></h2>\r\n\r\n<p>We may update this Privacy Policy from time to time. Updates will be posted on this page with a revised &ldquo;Last Updated&rdquo; date.</p>\r\n\r\n<h2><strong>11. Contact Us</strong></h2>\r\n\r\n<p>If you have questions or concerns about this Privacy Policy, please contact us: demo@demo.com</p>', 'privacy', '', '', 'en', '2022-11-09 05:29:24', '2026-02-19 03:25:36'),
(5, 'About', '<p>At <strong>MxMeo</strong>, we believe in bringing fans closer to their favorite stars through the magic of personalized experiences. Our platform allows you to request <strong>custom video messages</strong> from celebrities, influencers, and public figures &ndash; whether it&rsquo;s a birthday wish, a motivational message, a shoutout, or a special surprise for your loved ones.</p>\r\n\r\n<p>We started MxMeo with a simple idea: <strong>to create unforgettable moments by connecting people with the personalities they admire most</strong>. Every video is unique, heartfelt, and crafted just for you.</p>\r\n\r\n<h3><strong>What We Do</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>Personalized Videos</strong> &ndash; Order custom messages from your favorite stars.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Memorable Gifts</strong> &ndash; Surprise friends, family, or colleagues with a one-of-a-kind greeting.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Closer Connections</strong> &ndash; Break the barrier between fans and celebrities with authentic, direct interactions.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h3><strong>Our Promise</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Easy and secure booking process.</p>\r\n	</li>\r\n	<li>\r\n	<p>Timely delivery of high-quality personalized videos.</p>\r\n	</li>\r\n	<li>\r\n	<p>Respect for your privacy and trust.</p>\r\n	</li>\r\n	<li>\r\n	<p>100% authentic videos directly from the stars you choose.</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>At MxMeo, we&rsquo;re not just delivering videos &ndash; <strong>we&rsquo;re creating memories that last a lifetime.</strong></p>', 'about', '', '', 'en', '2024-06-27 21:03:03', '2026-02-19 03:25:59'),
(9, 'Cookies Policy', '<p>This Cookies Policy explains how <strong>MxMeo</strong> (&ldquo;we,&rdquo; &ldquo;our,&rdquo; or &ldquo;us&rdquo;) uses cookies and similar technologies to recognize you when you visit our website or use our services. It explains what these technologies are, why we use them, and your choices regarding their use.</p>\r\n\r\n<h2><strong>1. What Are Cookies?</strong></h2>\r\n\r\n<p>Cookies are small text files placed on your device (computer, tablet, or mobile) when you visit a website. They are widely used to make websites work, improve user experience, and provide information to the website owners.</p>\r\n\r\n<h2><strong>2. Types of Cookies We Use</strong></h2>\r\n\r\n<p><strong>a.&nbsp;</strong><strong>Essential Cookies</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Necessary for the website to function properly.</p>\r\n	</li>\r\n	<li>\r\n	<p>Enable core features like account login, payment processing, and order requests.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h3><strong>b.&nbsp;</strong><strong>Performance &amp; Analytics Cookies</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Help us understand how visitors use our platform.</p>\r\n	</li>\r\n	<li>\r\n	<p>Collect anonymous data to improve navigation, speed, and usability.</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>c.&nbsp;</strong><strong>Functionality Cookies</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Remember your preferences (such as language or region).</p>\r\n	</li>\r\n	<li>\r\n	<p>Provide a more personalized experience.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h3><strong>d.&nbsp;</strong><strong>Advertising &amp; Marketing Cookies</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Track your browsing activity to deliver relevant ads.</p>\r\n	</li>\r\n	<li>\r\n	<p>Help us measure the effectiveness of promotions and campaigns.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>3. Why We Use Cookies</strong></h2>\r\n\r\n<p>We use cookies to:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Ensure the website operates smoothly.</p>\r\n	</li>\r\n	<li>\r\n	<p>Improve your browsing experience.</p>\r\n	</li>\r\n	<li>\r\n	<p>Understand how our services are used.</p>\r\n	</li>\r\n	<li>\r\n	<p>Personalize content and offers.</p>\r\n	</li>\r\n	<li>\r\n	<p>Deliver targeted advertising that matches your interests.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>4. Third-Party Cookies</strong></h2>\r\n\r\n<p>Some cookies may be set by third parties, such as:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>Analytics providers</strong> (e.g., Google Analytics) to measure traffic and usage patterns.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Advertising networks</strong> to display relevant ads on other websites.</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Payment gateways</strong> to ensure secure transactions.</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>We do not control these third-party cookies, and their use is governed by their own privacy policies.</p>\r\n\r\n<h2><strong>5. Managing Cookies</strong></h2>\r\n\r\n<p>You can manage or disable cookies at any time through your browser settings. However, please note that disabling essential cookies may affect the functionality of our services.</p>\r\n\r\n<p>Instructions for managing cookies can be found here:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><a bis_size=\"{\" x=\"\">Google Chrome</a></p>\r\n	</li>\r\n	<li>\r\n	<p><a bis_size=\"{\" x=\"\">Mozilla Firefox</a></p>\r\n	</li>\r\n	<li>\r\n	<p><a bis_size=\"{\" x=\"\">Safari</a></p>\r\n	</li>\r\n	<li>\r\n	<p><a bis_size=\"{\" x=\"\">Microsoft Edge</a></p>\r\n	</li>\r\n</ul>\r\n\r\n<h2><strong>6. Updates to This Policy</strong></h2>\r\n\r\n<p>We may update this Cookies Policy from time to time to reflect changes in technology, law, or our practices. Updates will be posted on this page with a revised &ldquo;Last Updated&rdquo; date.</p>\r\n\r\n<h2><strong>7. Contact Us</strong></h2>\r\n\r\n<p>If you have any questions about our Cookies Policy, please contact us: demo@demo.com</p>', 'cookies', 'Page Cookies Policy', 'cookies, policy', 'en', '2022-11-09 05:30:10', '2026-02-19 03:26:48'),
(12, 'How it works', '<p>Ordering a personalized video from your favorite star on&nbsp;<strong>MxMeo</strong>&nbsp;is simple and fun. Here&rsquo;s how it works:</p>\r\n\r\n<h3><strong>1.&nbsp;Browse Your Favorite Stars</strong></h3>\r\n\r\n<p>Explore our wide selection of celebrities, influencers, and public figures. Find the star who inspires you or the perfect match for your occasion.</p>\r\n\r\n<h3><strong>2.&nbsp;Send Your Request</strong></h3>\r\n\r\n<p>Tell us what you&rsquo;d like your star to say &ndash; a birthday wish, congratulations, motivation, shoutout, or just a fun message. Keep it clear and respectful.</p>\r\n\r\n<h3><strong>3.&nbsp;Star Creates Your Video</strong></h3>\r\n\r\n<p>Once your request is accepted, your star will record a personalized video just for you (or your loved one). Each message is unique and authentic.</p>\r\n\r\n<p><strong>4.&nbsp;Receive &amp; Share</strong></p>\r\n\r\n<p>You&rsquo;ll get your video delivered directly to your account/email. Watch it, download it, and share it with friends, family, or on social media!</p>\r\n\r\n<p>⭐ With MxMeo, creating unforgettable memories with your favorite stars has never been easier.</p>', 'how-it-works', '', '', 'en', '2026-05-03 17:35:47', '2026-05-03 17:35:47');

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

--
-- Table structure for table `promotional_videos`
--

CREATE TABLE `promotional_videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `video` varchar(100) DEFAULT NULL,
  `video_poster` varchar(100) DEFAULT NULL,
  `subtitles` varchar(255) DEFAULT NULL,
  `duration_video` varchar(100) DEFAULT NULL,
  `encode` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `bytes` varchar(100) DEFAULT NULL,
  `mime` varchar(100) DEFAULT NULL,
  `job_id` 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;

--
-- Dumping data for table `promotional_videos`
--

INSERT INTO `promotional_videos` (`id`, `user_id`, `video`, `video_poster`, `subtitles`, `duration_video`, `encode`, `status`, `bytes`, `mime`, `job_id`, `created_at`, `updated_at`) VALUES
(2, 12, '1269a1322592eee1772171813tauapuigpwxq3sdl1ar8.mp4', NULL, NULL, NULL, 1, 0, '2603986', 'video/mp4', NULL, '2026-02-27 05:56:53', '2026-02-27 05:57:36');

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

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

--
-- Dumping data for table `referrals`
--

INSERT INTO `referrals` (`id`, `user_id`, `referred_by`, `created_at`, `updated_at`) VALUES
(1, 648, 647, '2026-05-28 06:01:14', '2026-05-28 06:01:14');

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

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

--
-- Dumping data for table `referral_transactions`
--

INSERT INTO `referral_transactions` (`id`, `transactions_id`, `referrals_id`, `user_id`, `referred_by`, `earnings`, `type`, `created_at`, `updated_at`) VALUES
(1, 185, 1, 648, 647, 0.01, 'dm', '2026-05-28 06:20:38', '2026-05-28 06:20:38'),
(2, 186, 1, 648, 647, 0.01, 'dm', '2026-05-28 06:23:19', '2026-05-28 06:23:19'),
(3, 187, 1, 648, 647, 0.01, 'dm', '2026-05-28 06:23:45', '2026-05-28 06:23:45'),
(4, 181, 1, 648, 647, 0.17, 'custom_video', '2026-05-28 06:34:21', '2026-05-28 06:34:21');

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

--
-- Table structure for table `refunds`
--

CREATE TABLE `refunds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `seller_id` int(10) UNSIGNED NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'pending',
  `reason` text 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 `refunds`
--

INSERT INTO `refunds` (`id`, `order_id`, `user_id`, `seller_id`, `status`, `reason`, `created_at`, `updated_at`) VALUES
(4, 953, 2, 12, 'approved_by_admin', 'not good errterte not good errterte', '2026-03-03 12:18:40', '2026-03-10 13:37:28'),
(5, 954, 2, 12, 'approved_by_seller', 'ghngvsgdhdgshshdhshshshshahshsjsj', '2026-03-05 09:25:50', '2026-03-05 09:26:19'),
(6, 960, 2, 12, 'approved_by_seller', 'not good work and not good behavior', '2026-03-30 10:39:05', '2026-04-01 07:16:56'),
(7, 964, 2, 12, 'approved_by_seller', 'not good work and not good behavior', '2026-03-30 10:39:46', '2026-04-01 07:13:37'),
(8, 961, 2, 12, 'approved_by_seller', 'not good ..dsfffsfsff', '2026-03-30 11:30:21', '2026-04-01 07:11:24'),
(9, 962, 2, 12, 'declined_by_seller', 'not good work and not good behavior', '2026-03-30 11:53:47', '2026-04-01 05:08:18'),
(10, 968, 2, 12, 'approved_by_seller', 'not good work this was not reply time to time', '2026-04-01 04:58:53', '2026-04-01 05:02:38'),
(11, 967, 2, 12, 'approved_by_seller', 'not good work for video in this', '2026-04-01 07:19:28', '2026-04-01 07:20:39'),
(12, 966, 2, 12, 'approved_by_seller', 'not good work for creator so refund my money', '2026-04-01 07:21:33', '2026-04-01 07:21:50'),
(13, 965, 2, 12, 'approved_by_seller', 'not good work for this creator', '2026-04-01 07:22:45', '2026-04-01 07:24:48'),
(14, 963, 2, 12, 'approved_by_seller', 'demo not working good to see this', '2026-04-01 07:25:38', '2026-04-01 07:26:41'),
(15, 958, 2, 12, 'approved_by_seller', 'not good working creator refund my money', '2026-04-01 07:29:46', '2026-04-01 07:57:34'),
(16, 957, 2, 12, 'closed', 'not propper work refund my money', '2026-04-01 08:02:13', '2026-04-01 08:04:52'),
(17, 956, 2, 12, 'declined_by_seller', 'not good work on this creator data', '2026-04-01 08:06:22', '2026-04-01 08:18:14'),
(18, 71, 2, 12, 'declined_by_seller', 'not good work of creator', '2026-04-01 08:15:37', '2026-04-01 08:21:50'),
(19, 955, 2, 12, 'approved_by_seller', 'demo not good good  gfdgfdgfg', '2026-04-01 08:25:03', '2026-04-01 08:25:17'),
(20, 938, 2, 12, 'closed', 'not good work gdydhjhhdhss', '2026-04-01 08:28:03', '2026-04-01 08:28:12'),
(21, 971, 2, 12, 'declined_by_seller', 'not working propper way', '2026-04-02 05:13:17', '2026-04-02 05:13:31'),
(22, 970, 2, 12, 'approved_by_seller', 'hdhdhdgsgsfshfmcnfhdgsge', '2026-04-02 05:13:50', '2026-04-02 05:13:59');

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

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

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

--
-- 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,
  `reason` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) 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, 'favorites', 0),
(55, 'orders', 0),
(56, 'enroll', 0),
(57, 'wallet', 0),
(58, 'withdrawals', 0),
(59, 'changelog', 0),
(60, 'payments', 0),
(61, 'install', 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 `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `seller_id` int(10) UNSIGNED NOT NULL,
  `orders_id` int(10) UNSIGNED NOT NULL,
  `rating` int(10) UNSIGNED NOT NULL,
  `comment` text 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 `reviews`
--

INSERT INTO `reviews` (`id`, `user_id`, `seller_id`, `orders_id`, `rating`, `comment`, `created_at`, `updated_at`) VALUES
(20, 2, 12, 954, 4, 'yrdry rdydydtyt ydty', '2026-03-02 05:06:06', '2026-03-02 05:06:06'),
(21, 2, 12, 952, 4, 'gffdg', '2026-03-05 11:55:29', '2026-03-05 11:55:29'),
(22, 2, 12, 962, 5, 'nice work', '2026-03-30 10:19:33', '2026-03-30 10:19:33'),
(25, 2, 12, 971, 5, 'nice work', '2026-04-02 05:11:49', '2026-04-02 05:11:49');

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

--
-- Table structure for table `roles_and_permissions`
--

CREATE TABLE `roles_and_permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(250) NOT NULL,
  `permissions` longtext NOT NULL,
  `editable` 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 `roles_and_permissions`
--

INSERT INTO `roles_and_permissions` (`id`, `name`, `permissions`, `editable`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'full_access', '0', '2024-06-27 19:00:00', '2024-06-27 19:00:00'),
(2, 'Admin', 'limited_access', '1', '2026-03-12 09:25:53', '2026-03-12 09:25:53');

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

--
-- 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` int(10) UNSIGNED NOT NULL,
  `media_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `media_type` enum('image','video') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overlay_data_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `privacy_type` enum('public','followers','subscribers') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  `expires_at` datetime DEFAULT NULL,
  `viewers_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `status` enum('active','expired','deleted') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `stories` (`id`, `user_id`, `media_path`, `media_type`, `caption`, `overlay_data_json`, `privacy_type`, `expires_at`, `viewers_count`, `status`, `created_at`, `updated_at`) VALUES
(50, 192, 'stories/test_video.mp4', 'video', NULL, NULL, 'public', '2026-02-25 04:13:17', 0, 'active', '2026-02-26 01:17:03', '2026-02-26 04:13:17'),
(61, 2, 'stories/2/story_MjmpNsE07romP6pT1GP1.png', 'image', 'Test', '{\"version\":\"5.3.0\",\"objects\":[{\"type\":\"i-text\",\"version\":\"5.3.0\",\"originX\":\"center\",\"originY\":\"center\",\"left\":179,\"top\":535.35,\"width\":202.08,\"height\":40.68,\"fill\":\"#ffffff\",\"stroke\":null,\"strokeWidth\":1,\"strokeDashArray\":null,\"strokeLineCap\":\"butt\",\"strokeDashOffset\":0,\"strokeLineJoin\":\"miter\",\"strokeUniform\":false,\"strokeMiterLimit\":4,\"scaleX\":1,\"scaleY\":1,\"angle\":0,\"flipX\":false,\"flipY\":false,\"opacity\":1,\"shadow\":{\"color\":\"rgba(0,0,0,0.8)\",\"blur\":8,\"offsetX\":2,\"offsetY\":2,\"id\":0},\"visible\":true,\"backgroundColor\":\"\",\"fillRule\":\"nonzero\",\"paintFirst\":\"fill\",\"globalCompositeOperation\":\"source-over\",\"skewX\":0,\"skewY\":0,\"fontFamily\":\"Montserrat, sans-serif\",\"fontWeight\":\"bold\",\"fontSize\":36,\"text\":\"Shaktimaan\",\"underline\":false,\"overline\":false,\"linethrough\":false,\"textAlign\":\"left\",\"fontStyle\":\"normal\",\"lineHeight\":1.16,\"textBackgroundColor\":\"\",\"charSpacing\":0,\"styles\":[],\"direction\":\"ltr\",\"path\":null,\"pathStartOffset\":0,\"pathSide\":\"left\",\"pathAlign\":\"baseline\"},{\"type\":\"path\",\"version\":\"5.3.0\",\"originX\":\"left\",\"originY\":\"top\",\"left\":128.1,\"top\":530.05,\"width\":179,\"height\":88.92,\"fill\":null,\"stroke\":\"#ffffff\",\"strokeWidth\":5,\"strokeDashArray\":null,\"strokeLineCap\":\"round\",\"strokeDashOffset\":0,\"strokeLineJoin\":\"round\",\"strokeUniform\":false,\"strokeMiterLimit\":10,\"scaleX\":1,\"scaleY\":1,\"angle\":0,\"flipX\":false,\"flipY\":false,\"opacity\":1,\"shadow\":null,\"visible\":true,\"backgroundColor\":\"\",\"fillRule\":\"nonzero\",\"paintFirst\":\"fill\",\"globalCompositeOperation\":\"source-over\",\"skewX\":0,\"skewY\":0,\"path\":[[\"M\",130.59999084472656,591.4954219409283],[\"Q\",130.59999084472656,591.5004219409283,130.59999084472656,592],[\"Q\",130.59999084472656,592.4995780590717,130.59999084472656,592.9991561181434],[\"Q\",130.59999084472656,593.4987341772152,131.59999084472656,594.4978902953587],[\"Q\",132.59999084472656,595.4970464135022,134.09999084472656,597.9949367088608],[\"Q\",135.59999084472656,600.4928270042194,137.09999084472656,602.9907172995781],[\"Q\",138.59999084472656,605.4886075949368,141.09999084472656,608.4860759493672],[\"Q\",143.59999084472656,611.4835443037975,144.09999084472656,613.4818565400844],[\"Q\",144.59999084472656,615.4801687763713,145.59999084472656,616.4793248945148],[\"Q\",146.59999084472656,617.4784810126582,147.59999084472656,617.97805907173],[\"Q\",148.59999084472656,618.4776371308017,148.59999084472656,619.4767932489451],[\"Q\",148.59999084472656,620.4759493670887,148.59999084472656,620.9755274261604],[\"Q\",148.59999084472656,621.4751054852321,149.09999084472656,621.4751054852321],[\"Q\",149.59999084472656,621.4751054852321,150.09999084472656,621.4751054852321],[\"Q\",150.59999084472656,621.4751054852321,152.09999084472656,620.9755274261604],[\"Q\",153.59999084472656,620.4759493670887,155.59999084472656,619.4767932489451],[\"Q\",157.59999084472656,618.4776371308017,163.59999084472656,614.4810126582279],[\"Q\",169.59999084472656,610.4843881856541,179.59999084472656,602.9907172995781],[\"Q\",189.59999084472656,595.4970464135022,202.09999084472656,588.5029535864979],[\"Q\",214.59999084472656,581.5088607594937,237.09999084472656,569.0194092827005],[\"Q\",259.59999084472656,556.5299578059072,274.09999084472656,548.5367088607595],[\"Q\",288.59999084472656,540.5434599156118,293.59999084472656,538.5451476793249],[\"Q\",298.59999084472656,536.546835443038,300.59999084472656,535.0481012658229],[\"Q\",302.59999084472656,533.5493670886076,304.59999084472656,533.0497890295359],[\"Q\",306.59999084472656,532.5502109704641,308.09999084472656,532.5502109704641],[\"L\",309.60499084472656,532.5502109704641]]}]}', 'public', '2026-02-27 05:40:04', 1, 'active', '2026-02-27 05:39:58', '2026-02-27 05:40:04'),
(68, 12, 'stories/12/story_taOsoSN7M29HRFkC8FmW.png', 'image', 'aaaaaa', '{\"version\":\"5.3.0\",\"objects\":[]}', 'public', '2026-03-03 07:32:15', 1, 'active', '2026-03-03 07:32:11', '2026-03-03 07:32:15'),
(69, 12, 'stories/12/story_R2vBxTxxmBMcnUc0GcgZ.png', 'image', 'LOgo', '{\"version\":\"5.3.0\",\"objects\":[]}', 'public', '2026-03-03 08:07:55', 1, 'active', '2026-03-03 08:07:52', '2026-03-03 08:07:55'),
(70, 12, 'stories/12/story_wY7RLPCDWaEam6jnrC9A.png', 'image', 'VV', '{\"version\":\"5.3.0\",\"objects\":[]}', 'public', '2026-03-03 08:08:12', 1, 'active', '2026-03-03 08:08:10', '2026-03-03 08:08:12'),
(71, 12, 'stories/12/story_1GnQB4aboqqjfMD6Eylv.png', 'image', 'eeee', '{\"version\":\"5.3.0\",\"objects\":[]}', 'public', '2026-03-03 08:09:01', 1, 'active', '2026-03-03 08:08:53', '2026-03-03 08:09:01'),
(72, 12, 'stories/12/story_zOsTzwotd1XW6c9dLfgP.png', 'image', '11', '{\"version\":\"5.3.0\",\"objects\":[]}', 'public', '2026-03-03 08:52:49', 1, 'active', '2026-03-03 08:52:42', '2026-03-03 08:52:42'),
(73, 12, 'stories/12/story_KxlTjg2rT29bvEencbNr.png', 'image', '12', '{\"version\":\"5.3.0\",\"objects\":[]}', 'public', '2026-03-03 08:53:05', 1, 'active', '2026-03-03 08:53:00', '2026-03-03 08:53:00'),
(74, 12, 'stories/12/story_VE8YX46EPe1dYqn4unBJ.png', 'image', '1', '{\"version\":\"5.3.0\",\"objects\":[]}', 'public', '2026-03-04 08:56:13', 1, 'active', '2026-03-03 08:56:13', '2026-03-03 08:56:13'),
(75, 12, 'stories/12/story_xt5YYV6fMQaoLZHhLbAy.png', 'image', '3', '{\"version\":\"5.3.0\",\"objects\":[]}', 'public', '2026-03-04 08:56:32', 1, 'active', '2026-03-03 08:56:32', '2026-03-03 08:56:32'),
(76, 12, 'stories/12/story_K1i5ymLJITchIroFBYSq.jpg', 'image', 'thh', NULL, 'public', '2026-03-04 09:01:56', 1, 'active', '2026-03-03 09:01:56', '2026-03-03 09:01:56'),
(77, 12, 'stories/12/story_NgukNRAjTwXuiQjjYaL3.jpg', 'image', '', NULL, 'public', '2026-03-10 09:49:43', 1, 'active', '2026-03-09 09:49:43', '2026-03-09 09:49:43'),
(83, 12, 'stories/12/story_aYEYTgiONO78PSPSJpGk.jpg', 'image', 'hellofriends', NULL, 'public', '2026-03-13 16:58:55', 1, 'active', '2026-03-12 11:28:55', '2026-03-12 11:28:55'),
(84, 12, 'stories/12/story_vrz98S31isDca61RkFMF.jpg', 'image', '', NULL, 'public', '2026-04-02 17:16:00', 2, 'active', '2026-04-01 11:46:00', '2026-04-01 11:46:00');

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

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

CREATE TABLE `story_views` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `story_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `viewed_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `story_views`
--

INSERT INTO `story_views` (`id`, `story_id`, `user_id`, `ip_address`, `viewed_at`) VALUES
(20, 61, 2, '152.58.17.226', '2026-02-27 05:40:04'),
(26, 68, 12, '152.58.35.177', '2026-03-03 07:32:15'),
(27, 69, 12, '106.215.176.184', '2026-03-03 08:07:55'),
(28, 70, 12, '106.215.176.184', '2026-03-03 08:08:12'),
(29, 71, 12, '106.215.176.184', '2026-03-03 08:09:01'),
(30, 72, 12, '106.215.176.184', '2026-03-03 08:52:49'),
(31, 73, 12, '106.215.176.184', '2026-03-03 08:53:05'),
(32, 74, 12, '106.215.176.184', '2026-03-03 08:56:16'),
(33, 75, 12, '106.215.176.184', '2026-03-03 08:56:39'),
(34, 76, 12, '152.58.35.177', '2026-03-03 09:02:12'),
(35, 77, 12, '152.59.38.168', '2026-03-09 09:51:42'),
(37, 83, 12, '152.58.61.49', '2026-03-12 11:35:01'),
(38, 84, 2, '152.58.60.86', '2026-04-01 11:46:39'),
(40, 84, 12, '152.58.17.141', '2026-04-02 04:29:13');

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

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `business_profile_id` bigint(20) UNSIGNED NOT NULL,
  `assigned_admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `type` enum('general','concierge','campaign_assistance','managed_campaign') NOT NULL DEFAULT 'general',
  `status` enum('open','in_progress','waiting_business','resolved','closed') NOT NULL DEFAULT 'open',
  `priority` enum('standard','priority','enterprise') NOT NULL DEFAULT 'standard',
  `sla_due_at` timestamp NULL DEFAULT NULL,
  `resolved_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_ticket_replies`
--

CREATE TABLE `support_ticket_replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `body` text NOT NULL,
  `is_admin_reply` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM 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,
  `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 `tips`
--

CREATE TABLE `tips` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `seller_id` int(10) UNSIGNED NOT NULL,
  `orders_id` int(10) UNSIGNED NOT NULL,
  `transactions_id` int(10) UNSIGNED DEFAULT NULL,
  `amount` decimal(10,2) 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 `tips`
--

INSERT INTO `tips` (`user_id`, `seller_id`, `orders_id`, `transactions_id`, `amount`, `created_at`, `updated_at`) VALUES
(2, 12, 954, 120, 1.00, '2026-03-05 09:23:20', '2026-03-05 09:23:20'),
(2, 12, 954, 121, 5.00, '2026-03-05 09:24:46', '2026-03-05 09:24:46'),
(2, 12, 953, 122, 1.00, '2026-03-05 09:50:13', '2026-03-05 09:50:13'),
(2, 12, 960, 144, 1.00, '2026-03-06 09:32:06', '2026-03-06 09:32:06'),
(2, 12, 968, 168, 1.00, '2026-04-01 04:58:01', '2026-04-01 04:58:01'),
(2, 12, 971, 175, 1.00, '2026-04-02 05:10:32', '2026-04-02 05:10:32');

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

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

CREATE TABLE `transactions` (
  `id` int(10) UNSIGNED NOT NULL,
  `txn_id` varchar(250) DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `seller` int(10) UNSIGNED NOT NULL,
  `earning_net_user` decimal(10,2) NOT NULL,
  `earning_net_admin` decimal(10,2) NOT NULL,
  `payment_gateway` varchar(100) NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  `amount` float NOT NULL,
  `charged` decimal(10,2) NOT NULL,
  `type` varchar(100) NOT NULL DEFAULT 'custom_video',
  `percentage_applied` varchar(50) DEFAULT NULL,
  `referred_commission` int(10) UNSIGNED DEFAULT NULL,
  `taxes_applied` decimal(10,2) NOT NULL,
  `taxes` text DEFAULT NULL,
  `direct_payment` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `transactions` (`id`, `txn_id`, `user_id`, `seller`, `earning_net_user`, `earning_net_admin`, `payment_gateway`, `status`, `amount`, `charged`, `type`, `percentage_applied`, `referred_commission`, `taxes_applied`, `taxes`, `direct_payment`, `created_at`, `updated_at`, `coupon_id`) VALUES
(1, 'w_Kp6BmmaH0kPPHNnUFKjpDfXGk', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 03:03:08', '2026-02-24 03:06:41', NULL),
(2, 'w_cEpFocmAKmVQybvY6tub1YXd4', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 03:25:03', '2026-02-24 03:51:08', NULL),
(3, 'w_LaRJcw7aAJTgIlU61NgK90I93', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 04:02:04', '2026-02-24 04:03:40', NULL),
(4, 'w_0G84oShW7cUYgM1QFupZnpuvt', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 04:29:19', '2026-02-24 04:30:41', NULL),
(5, 'w_RQ3nr27MQdVGQjRnHzyU4KCEP', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 04:42:06', '2026-02-24 04:43:29', NULL),
(6, 'w_ocYh6VXR4imks0JfWRXy5NmSY', 70, 12, 500.00, 25.00, 'Wallet', 2, 500, 525.00, 'custom_video_business', NULL, NULL, 0.00, '', 0, '2026-02-24 04:49:34', '2026-03-12 09:19:55', NULL),
(7, 'w_zoKn6dtl0jmFQKOrg3x0f8R5N', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 04:57:56', '2026-02-24 04:59:17', NULL),
(8, 'w_0hMYAXnUuJVvxPt6kcANTi3yI', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 05:02:37', '2026-02-24 05:03:53', NULL),
(9, 'w_cxqIh4n6ZmQaHil8wselW6znW', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 06:03:38', '2026-02-24 06:04:57', NULL),
(10, 'w_qt4guzSdMvsk0RYieUYtvf0PN', 70, 12, 500.00, 25.00, 'Wallet', 2, 500, 525.00, 'custom_video_business', NULL, NULL, 0.00, '', 0, '2026-02-24 06:05:09', '2026-03-12 09:19:55', NULL),
(11, 'w_4aE0ZegjOKzpUZeqXfjB3vrrS', 70, 12, 500.00, 25.00, 'Wallet', 2, 500, 525.00, 'custom_video_business', NULL, NULL, 0.00, '', 0, '2026-02-24 06:19:45', '2026-03-12 09:19:55', NULL),
(12, 'w_Co0yDQhvgZ5oCiLTXkQ4JOOfl', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 06:29:42', '2026-02-24 06:41:20', NULL),
(13, 'w_d6aJm2MTtl6jO19rXlGVESI0p', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 06:48:08', '2026-02-24 06:49:38', NULL),
(14, 'w_NWOtCX6zK8vqaeQe8nz6M8Z5V', 70, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-02-24 07:07:16', '2026-02-24 09:34:27', NULL),
(15, 'w_89sUqwQofAsUUH9mQ18orYR1d', 2, 70, 10.00, 0.50, 'Wallet', 1, 10, 10.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-02-24 11:38:02', '2026-02-24 11:38:57', NULL),
(29, NULL, 2, 12, 1.64, 0.10, 'Stripe', 3, 2, 2.10, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-26 00:28:33', '2026-02-26 00:28:33', NULL),
(30, NULL, 2, 12, 1.64, 0.10, 'Stripe', 3, 2, 2.10, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-26 00:33:04', '2026-02-26 00:33:04', NULL),
(31, 'w_5yrNNBCP95un36vLooPG1GFl9', 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-26 00:34:58', '2026-02-26 00:34:58', NULL),
(32, 'w_akJmTzioMOURMkaPScwGX7MTy', 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-26 00:39:47', '2026-02-26 00:39:47', NULL),
(33, 'w_SgNKKtZU9uD1uCKuM9xlebtXp', 2, 12, 2.00, 0.10, 'Wallet', 2, 2, 2.10, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-26 00:49:19', '2026-02-27 04:58:34', NULL),
(34, 'w_r1XLshViu2LUgjtV7PMXTzsYO', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'custom_video', NULL, 0, 0.00, '', 0, '2026-02-26 01:16:12', '2026-02-26 01:16:44', NULL),
(77, 'w_gneHHX2GE3GqfeawooNfBLZRU', 2, 12, 2.00, 0.10, 'Wallet', 2, 2, 2.10, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-26 10:56:38', '2026-02-26 11:12:08', NULL),
(78, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-26 11:30:51', '2026-02-26 11:30:51', NULL),
(79, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-26 11:31:05', '2026-02-26 11:31:05', NULL),
(80, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-26 11:31:07', '2026-02-26 11:31:07', NULL),
(81, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-26 11:31:08', '2026-02-26 11:31:08', NULL),
(82, 'w_rPJQ1ZmOEqMCtfqR4CUXC4YGQ', 2, 12, 2.00, 0.10, 'Wallet', 2, 2, 2.10, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-26 11:46:27', '2026-02-27 06:03:29', NULL),
(83, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-26 11:48:16', '2026-02-26 11:48:16', NULL),
(84, 'w_JpneRcFqQNgI2P25QkGLynoCE', 2, 12, 2.00, 0.10, 'Wallet', 2, 2, 2.10, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-27 04:56:38', '2026-03-05 06:14:22', NULL),
(85, NULL, 2, 12, 11.33, 0.60, 'Stripe', 3, 12, 12.60, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 05:04:42', '2026-02-27 05:04:42', NULL),
(86, NULL, 2, 12, 11.33, 0.60, 'Stripe', 3, 12, 12.60, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 05:06:34', '2026-02-27 05:06:34', NULL),
(87, 'w_3sKQe2fqV7v3GMAfWmLt5o8i9', 2, 12, 12.00, 0.60, 'Wallet', 1, 12, 12.60, 'custom_video', NULL, 0, 0.00, '', 0, '2026-02-27 05:08:43', '2026-04-01 08:26:32', NULL),
(88, 'w_YdXTpjIoqJvEwxUbUwom0CEEf', 2, 12, 12.00, 0.60, 'Wallet', 3, 12, 12.60, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-27 05:13:09', '2026-02-27 05:13:09', NULL),
(89, NULL, 2, 12, 11.33, 0.60, 'Stripe', 3, 12, 12.60, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 05:16:36', '2026-02-27 05:16:36', NULL),
(90, 'w_FP6USz8M2ablc79DANkNpnvAX', 2, 12, 500.00, 25.00, 'Wallet', 2, 500, 525.00, 'custom_video_business', NULL, NULL, 0.00, '', 0, '2026-02-27 05:24:41', '2026-02-27 06:03:45', NULL),
(91, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-27 05:27:04', '2026-02-27 05:27:04', NULL),
(92, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-27 05:31:01', '2026-02-27 05:31:01', NULL),
(93, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-27 05:31:40', '2026-02-27 05:31:40', NULL),
(94, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-27 05:32:58', '2026-02-27 05:32:58', NULL),
(95, 'w_d8emi2uipkqcD1Yyn1aXHl8Hm', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-27 06:52:12', '2026-02-27 06:52:17', NULL),
(96, NULL, 2, 12, 67.57, 3.50, 'Stripe', 3, 70, 73.50, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 06:54:13', '2026-02-27 06:54:13', NULL),
(97, NULL, 2, 12, 67.57, 3.50, 'Stripe', 3, 70, 73.50, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 06:59:39', '2026-02-27 06:59:39', NULL),
(98, NULL, 1, 12, 484.47, 25.00, 'Stripe', 3, 500, 525.00, 'custom_video_business', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 07:02:24', '2026-02-27 07:02:24', NULL),
(99, NULL, 2, 12, 67.57, 3.50, 'Stripe', 3, 70, 73.50, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 07:08:07', '2026-02-27 07:08:07', NULL),
(100, NULL, 2, 12, 67.57, 3.50, 'Stripe', 3, 70, 73.50, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 07:09:25', '2026-02-27 07:09:25', NULL),
(101, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-27 07:09:52', '2026-02-27 07:09:52', NULL),
(102, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-02-27 07:09:57', '2026-02-27 07:09:57', NULL),
(103, 'w_DHK1SSnD2HPFd7oXmiwdbu6J3', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'dm', NULL, 0, 0.00, '', 0, '2026-02-27 07:28:33', '2026-02-27 07:28:33', NULL),
(104, 'w_CUcSPrqGezUOSqn44ytIZBL4S', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'dm', NULL, 0, 0.00, '', 0, '2026-02-27 07:29:38', '2026-02-27 07:29:38', NULL),
(105, NULL, 2, 38, 3.00, 0.15, 'Wallet', 3, 3, 3.15, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-27 07:58:12', '2026-02-27 07:58:12', NULL),
(106, 'w_pm9nD29bUaVO7c0BafTRmuuV0', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-27 08:02:48', '2026-02-27 08:04:39', NULL),
(107, 'w_h92x5eRAqVEdY3g5Q5U68j7lE', 2, 12, 0.01, 0.00, 'Wallet', 2, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-02-27 08:07:24', '2026-03-10 15:00:00', NULL),
(108, 'w_jwIF26cWl7p8dRhO3H0EzEBEc', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-02-27 08:21:31', '2026-02-27 08:21:31', NULL),
(109, 'w_Wb8pSB84lQP6g4MYVnvhrs4PV', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-27 08:24:50', '2026-02-27 09:50:33', NULL),
(110, 'w_oCPhqWhlQgyCmh9D3yzrNtKIe', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'dm', NULL, 0, 0.00, '', 0, '2026-02-27 09:42:47', '2026-02-27 09:42:47', NULL),
(111, 'w_kTi7nw19jNdg6oM9mXZVsJfKC', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'dm', NULL, 0, 0.00, '', 0, '2026-02-27 09:43:22', '2026-02-27 09:43:22', NULL),
(112, 'w_Mxb7asEuGd25SvLcnukpj2UDa', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-02-27 09:47:37', '2026-02-27 09:47:37', NULL),
(113, 'w_uUlW2WdOd1KuWlRAYXOR42epk', 2, 12, 0.01, 0.00, 'Wallet', 2, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-02-27 09:48:40', '2026-02-27 09:49:06', NULL),
(114, 'w_k6EY49MUJ0LVIFdTqh82cd9lg', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-02-27 09:50:25', '2026-02-27 09:52:00', NULL),
(115, NULL, 2, 12, 77.26, 4.00, 'Stripe', 3, 80, 84.00, 'custom_video', '2.9% + 0.30', NULL, 0.00, '', 0, '2026-02-27 09:53:43', '2026-02-27 09:53:43', NULL),
(116, 'w_NaGSpZmdFVajlaJwCYvS2IEsP', 2, 12, 70.00, 3.50, 'Wallet', 3, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-03-02 04:59:50', '2026-03-02 04:59:50', NULL),
(117, 'w_3RNHE8buTLfMMce0fa4oNFD6i', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-02 05:01:13', '2026-03-10 13:37:28', NULL),
(118, 'w_Jk8k1xLvdGekVnt5kF7y6XUCQ', 2, 12, 70.00, 3.50, 'Wallet', 1, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-02 05:02:25', '2026-03-02 05:02:50', NULL),
(119, NULL, 2, 12, 500.00, 25.00, 'Wallet', 3, 500, 525.00, 'custom_video_business', NULL, NULL, 0.00, '', 0, '2026-03-02 10:14:17', '2026-03-02 10:14:17', NULL),
(120, 't_MMeT6gt3o14FDX83nM686AdRM', 2, 12, 1.00, 0.00, 'Wallet', 1, 1, 1.00, 'tip', NULL, NULL, 0.00, NULL, 0, '2026-03-05 09:23:20', '2026-03-05 09:23:20', NULL),
(121, 't_xFLTGkYfx55ClpDA4SB8STtNO', 2, 12, 5.00, 0.00, 'Wallet', 1, 5, 5.00, 'tip', NULL, NULL, 0.00, NULL, 0, '2026-03-05 09:24:46', '2026-03-05 09:24:46', NULL),
(122, 't_yqWFg1RdTO8jWPbArgHF2VxTb', 2, 12, 1.00, 0.00, 'Wallet', 1, 1, 1.00, 'tip', NULL, NULL, 0.00, NULL, 0, '2026-03-05 09:50:13', '2026-03-05 09:50:13', NULL),
(123, NULL, 2, 12, 70.00, 3.50, 'Wallet', 3, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-03-05 12:35:46', '2026-03-05 12:35:46', NULL),
(124, NULL, 2, 12, 70.00, 3.50, 'Wallet', 3, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-03-05 12:38:40', '2026-03-05 12:38:40', NULL),
(125, NULL, 2, 12, 70.00, 3.50, 'Wallet', 3, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-03-05 12:41:04', '2026-03-05 12:41:04', NULL),
(126, NULL, 2, 12, 70.00, 3.50, 'Wallet', 3, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-03-05 12:42:45', '2026-03-05 12:42:45', NULL),
(127, NULL, 2, 12, 70.00, 3.50, 'Wallet', 3, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-03-05 12:44:16', '2026-03-05 12:44:16', NULL),
(128, 'w_gNzTTYnrTOuNH95flrhQwiILt', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-05 12:47:24', '2026-04-01 08:25:17', NULL),
(129, 'w_wPBxEQPaW4JSgpcPv9R1VUCWs', 2, 12, 70.00, 3.50, 'Wallet', 1, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-06 04:54:48', '2026-03-10 05:32:22', NULL),
(130, 'w_g9AGxnGOEdI9h82LhygZ6RFOu', 2, 12, 70.00, 3.50, 'Wallet', 1, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-06 04:56:39', '2026-03-06 10:27:42', NULL),
(131, 'w_TlsAlyNxDQGewimZ5AGL360PM', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-06 05:10:14', '2026-04-01 07:57:34', NULL),
(132, 'w_CAVN0GjN0AWX5ZwUxLnj741tv', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-03-06 05:20:00', '2026-03-06 05:20:21', NULL),
(133, 'w_5V861fs2MsInLuRQFVOrOCJEH', 2, 12, 70.00, 3.50, 'Wallet', 1, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-06 05:20:46', '2026-03-06 09:28:23', NULL),
(134, 'w_6ChktawR4UEDN2WAfFjxsgWzL', 2, 12, 500.00, 25.00, 'Wallet', 1, 500, 525.00, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-03-06 05:29:54', '2026-03-06 09:26:54', NULL),
(135, 'w_shuHdOHW8g3iN1g2W9DfWvTQ5', 2, 12, 520.00, 26.00, 'Wallet', 3, 520, 546.00, 'custom_video_business', NULL, NULL, 0.00, '', 0, '2026-03-06 05:32:31', '2026-03-06 05:32:31', NULL),
(136, 'w_RLxY26D0McQeNC6YIKGnVxcXk', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-03-06 06:40:25', '2026-03-06 06:40:25', NULL),
(137, 'w_SNYDJ92fGDnSZKPj6pQcXrzsX', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-03-06 06:41:21', '2026-03-06 06:41:21', NULL),
(138, 'w_tNrxr3qEYfbirv16UVSDlRKSI', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-03-06 07:12:22', '2026-03-06 07:12:22', NULL),
(139, 'w_hfxe5kvkm78NHhJa3QNSt7SSD', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-03-06 07:19:30', '2026-03-06 07:19:30', NULL),
(140, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-03-06 09:15:47', '2026-03-06 09:15:47', NULL),
(141, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-03-06 09:17:55', '2026-03-06 09:17:55', NULL),
(142, NULL, 2, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-03-06 09:18:24', '2026-03-06 09:18:24', NULL),
(143, 'w_dCFEdJ8bCJrRApNabo1eSP9pe', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'dm', NULL, 0, 0.00, '', 0, '2026-03-06 09:24:04', '2026-03-06 09:24:04', NULL),
(144, 't_V11OkQ15D272E8kmlxzlSQGkJ', 2, 12, 1.00, 0.00, 'Wallet', 1, 1, 1.00, 'tip', NULL, NULL, 0.00, NULL, 0, '2026-03-06 09:32:06', '2026-03-06 09:32:06', NULL),
(145, 'w_wpRdj9PixmsskTOu5HejcjPyM', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-06 10:29:52', '2026-04-01 07:26:41', NULL),
(146, 'w_88mH48z01e9WoDVWeCZQ9Piev', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'dm', NULL, 0, 0.00, '', 0, '2026-03-10 04:10:02', '2026-03-10 04:10:02', NULL),
(147, 'w_KWHzy7DrvB2qcY2YealRCMnFj', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-03-10 07:13:26', '2026-03-10 07:13:26', NULL),
(148, 'w_3rveMdJsPdPL7xcagyNpfgqPt', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-03-10 13:50:16', '2026-03-10 13:50:16', NULL),
(149, 'w_eC3l1EwTdYWiOHsUCiYARpnNu', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-10 13:59:24', '2026-03-10 14:03:54', NULL),
(150, 'w_p0VSm0ySLwvZz4mRwSFzyDHKt', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-10 14:21:16', '2026-03-10 14:22:59', NULL),
(151, 'w_x7NgbX15dk4xSEZhUkI5ugvM2', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-10 17:35:44', '2026-03-10 17:39:53', NULL),
(152, 'w_18j64hNcUtQKb8nVF9YKUnsEH', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-10 18:01:52', '2026-03-10 18:02:46', NULL),
(153, 'w_7VpZmLRD2CuG7FPpN8jD7tsV3', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-11 09:11:24', '2026-03-11 09:13:05', NULL),
(154, 'w_cJGQ8OUC0X7gLXxZsTUIZjzZF', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-11 09:23:27', '2026-03-11 09:23:54', NULL),
(155, 'w_L81Htw7PZ4ke0AI8kqALOZvQu', 2, 12, 0.01, 0.00, 'Wallet', 2, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-03-11 09:35:07', '2026-03-11 09:37:28', NULL),
(156, 'w_slrjcX6YMnziazSHZ6dQJe1tX', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-11 09:37:12', '2026-03-11 09:39:03', NULL),
(157, 'w_dMIe0Go5p0o2p4zPuIpbFkFmF', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-11 09:55:07', '2026-03-11 09:55:43', NULL),
(158, 'w_B3YUc2L68kYpzuaRzh6Gc6V3d', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-11 10:13:57', '2026-03-11 10:14:25', NULL),
(159, 'w_gaQhZlFU6fSxQy1eMpQe4UHDQ', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-11 10:26:01', '2026-03-11 10:26:28', NULL),
(160, 'w_CRzVV2BgJNoFyVP15xhA6NQkO', 2, 12, 0.01, 0.00, 'Wallet', 1, 0.01, 0.01, 'videocall', NULL, 0, 0.00, '', 0, '2026-03-11 10:39:59', '2026-03-11 10:41:54', NULL),
(161, 'w_jmssmTrK2mvmSA9J39IXhzH7i', 2, 12, 80.00, 4.00, 'Wallet', 1, 80, 84.00, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-11 11:19:31', '2026-03-11 11:33:36', NULL),
(162, 'w_2Z7cDvfmK4wlYbd8JJIHqCmkZ', 2, 12, 0.01, 0.00, 'Wallet', 3, 0.01, 0.01, 'videocall', NULL, NULL, 0.00, '', 0, '2026-03-11 11:19:52', '2026-03-11 11:19:52', NULL),
(163, 'w_BDIDo8ICvkIgADl3vibuSavIP', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'dm', NULL, 0, 0.00, '', 0, '2026-03-11 11:20:08', '2026-03-11 11:20:08', NULL),
(164, 'w_PQVPtQqCSeJ1umJyoxmioLmTN', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-20 10:52:11', '2026-04-01 07:24:48', NULL),
(165, 'w_neuDuI2YXmZsmemYsihri0qHd', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-20 11:41:57', '2026-04-01 07:21:50', NULL),
(166, 'w_cKsbD8foJdozpw4jWY2RHLzll', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-03-20 12:53:45', '2026-04-01 07:20:39', NULL),
(167, 'w_JHNcZ3HP4YfKZzpVWti4bcNSM', 2, 12, 70.00, 3.50, 'Wallet', 2, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-04-01 04:28:53', '2026-04-01 05:02:38', NULL),
(168, 't_wN48y7x2hkorGcZuqkxkBixWw', 2, 12, 1.00, 0.00, 'Wallet', 1, 1, 1.00, 'tip', NULL, NULL, 0.00, NULL, 0, '2026-04-01 04:58:01', '2026-04-01 04:58:01', NULL),
(169, 'w_Zxhij2cFNvpS4BnXxwxu06KpC', 2, 12, 70.00, 3.50, 'Wallet', 3, 70, 73.50, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-04-01 08:52:21', '2026-04-01 08:52:21', NULL),
(170, 'w_tcqhBYyaqewYrJDksz3lPmvro', 2, 12, 530.00, 26.50, 'Wallet', 2, 530, 556.50, 'custom_video_business', NULL, 0, 0.00, '', 0, '2026-04-01 08:53:57', '2026-04-02 05:13:59', NULL),
(171, 'w_tIZSOi7c29Vk9CeXVpygHfdnP', 2, 12, 0.03, 0.00, 'Wallet', 3, 0.03, 0.03, 'videocall', NULL, NULL, 0.00, '', 0, '2026-04-01 08:54:34', '2026-04-01 08:54:34', NULL),
(172, 'w_eMjBfuUIXELczuK6zBG76yfxR', 2, 12, 0.03, 0.00, 'Wallet', 3, 0.03, 0.03, 'videocall', NULL, NULL, 0.00, '', 0, '2026-04-01 09:14:57', '2026-04-01 09:14:57', NULL),
(173, 'w_L6NRBtFJQZyDLRML6EI8m6KXv', 2, 12, 0.03, 0.00, 'Wallet', 1, 0.03, 0.03, 'videocall', NULL, 0, 0.00, '', 0, '2026-04-01 09:15:25', '2026-04-02 05:20:09', NULL),
(174, 'w_wq2TRfuv8IZ0ZOPdyDNCG09A8', 2, 12, 70.00, 3.50, 'Wallet', 1, 70, 73.50, 'custom_video', NULL, 0, 0.00, '', 0, '2026-04-02 04:22:49', '2026-04-02 05:10:01', NULL),
(175, 't_eas5KcJCcbQhPrkIKF40lqLWI', 2, 12, 1.00, 0.00, 'Wallet', 1, 1, 1.00, 'tip', NULL, NULL, 0.00, NULL, 0, '2026-04-02 05:10:32', '2026-04-02 05:10:32', NULL),
(176, 'w_YMe0bNl7FXww40muA6vjj0q6J', 2, 12, 2.00, 0.10, 'Wallet', 1, 2, 2.10, 'dm', NULL, 0, 0.00, '', 0, '2026-04-02 05:11:13', '2026-04-02 05:11:13', NULL),
(177, 'w_fLW09lEOCe2zbDjQgOiSuZiaL', 1, 36, 5.00, 0.25, 'Wallet', 1, 5, 5.25, 'dm', NULL, 0, 0.00, '', 0, '2026-04-17 12:21:32', '2026-04-17 12:21:32', NULL),
(178, 'w_ZCWqL8yinFB9FdWa2szzJmOXQ', 1, 36, 5.00, 0.25, 'Wallet', 1, 5, 5.25, 'dm', NULL, 0, 0.00, '', 0, '2026-04-17 12:21:52', '2026-04-17 12:21:52', NULL),
(179, 'w_Jz28uhRh1jL7vbpkNivd1z4ss', 12, 20, 5.00, 0.25, 'Wallet', 1, 5, 5.25, 'dm', NULL, 0, 0.00, '', 0, '2026-05-03 11:55:09', '2026-05-03 11:55:09', NULL),
(180, 'w_pAYeFHzJYLrxCA3r40liLfwvB', 12, 14, 12.00, 0.60, 'Wallet', 3, 12, 12.60, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-05-03 18:20:51', '2026-05-03 18:20:51', NULL),
(181, 'w_2NP1kqZmiS0WN3p2eq2Vawt4h', 648, 12, 70.00, 3.32, 'Wallet', 1, 70, 73.50, 'custom_video', NULL, 1, 0.00, '', 0, '2026-05-28 06:16:21', '2026-05-28 06:34:21', NULL),
(182, NULL, 648, 14, 5.00, 0.25, 'Wallet', 3, 5, 5.25, 'dm', NULL, NULL, 0.00, '', 0, '2026-05-28 06:16:59', '2026-05-28 06:16:59', NULL),
(183, 'w_tEXI0SdREvBEOmC346Fa7pHzq', 648, 14, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'custom_video', NULL, NULL, 0.00, '', 0, '2026-05-28 06:17:28', '2026-05-28 06:17:28', NULL),
(184, NULL, 648, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-05-28 06:17:55', '2026-05-28 06:17:55', NULL),
(185, NULL, 648, 12, 2.00, 0.10, 'Wallet', 3, 2, 2.10, 'dm', NULL, NULL, 0.00, '', 0, '2026-05-28 06:20:38', '2026-05-28 06:20:38', NULL),
(186, 'w_KYSP6ay0ZWnXubD72ALvfaS2Y', 648, 14, 5.00, 0.24, 'Wallet', 1, 5, 5.25, 'dm', NULL, 1, 0.00, '', 0, '2026-05-28 06:23:19', '2026-05-28 06:23:19', NULL),
(187, 'w_tf0Sb6ouKHa4tSkC7pB53CXLE', 648, 12, 2.00, 0.09, 'Wallet', 1, 2, 2.10, 'dm', NULL, 1, 0.00, '', 0, '2026-05-28 06:23:45', '2026-05-28 06:23:45', NULL),
(188, 'w_v28MUXmDGsGT8qjpPzUovNW3l', 648, 12, 0.03, 0.00, 'Wallet', 3, 0.03, 0.03, 'videocall', NULL, NULL, 0.00, '', 0, '2026-05-28 06:40:07', '2026-05-28 06:40:07', NULL),
(189, 'w_48hcv8m9GbfGO3PLwVyMXOuMU', 648, 12, 0.03, 0.00, 'Wallet', 3, 0.03, 0.03, 'videocall', NULL, NULL, 0.00, '', 0, '2026-05-28 06:40:38', '2026-05-28 06:40:38', NULL),
(190, 'w_eXzoLS7fKrSi1Xr2m6UUTwiBe', 648, 12, 0.03, 0.00, 'Wallet', 3, 0.03, 0.03, 'videocall', NULL, NULL, 0.00, '', 0, '2026-05-28 06:47:40', '2026-05-28 06:47:40', 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 `user_audience_demographics`
--

CREATE TABLE `user_audience_demographics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `age_13_17_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `male_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 50,
  `female_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 50,
  `age_18_24_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 30,
  `age_25_34_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 40,
  `age_35_44_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `age_45_54_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `age_55_plus_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `age_35_plus_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 30,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `income_0_20k_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `income_20_40k_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `income_40_60k_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `income_60_80k_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `income_80_100k_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `income_100k_plus_percentage` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `top_city_1` varchar(255) DEFAULT NULL,
  `top_city_1_percentage` decimal(5,2) DEFAULT NULL,
  `top_city_2` varchar(255) DEFAULT NULL,
  `top_city_2_percentage` decimal(5,2) DEFAULT NULL,
  `top_city_3` varchar(255) DEFAULT NULL,
  `top_city_3_percentage` decimal(5,2) DEFAULT NULL,
  `top_city_4` varchar(255) DEFAULT NULL,
  `top_city_4_percentage` decimal(5,2) DEFAULT NULL,
  `top_city_5` varchar(255) DEFAULT NULL,
  `top_city_5_percentage` decimal(5,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_audience_demographics`
--

INSERT INTO `user_audience_demographics` (`id`, `user_id`, `age_13_17_percentage`, `male_percentage`, `female_percentage`, `age_18_24_percentage`, `age_25_34_percentage`, `age_35_44_percentage`, `age_45_54_percentage`, `age_55_plus_percentage`, `age_35_plus_percentage`, `created_at`, `updated_at`, `income_0_20k_percentage`, `income_20_40k_percentage`, `income_40_60k_percentage`, `income_60_80k_percentage`, `income_80_100k_percentage`, `income_100k_plus_percentage`, `top_city_1`, `top_city_1_percentage`, `top_city_2`, `top_city_2_percentage`, `top_city_3`, `top_city_3_percentage`, `top_city_4`, `top_city_4_percentage`, `top_city_5`, `top_city_5_percentage`) VALUES
(1, 12, 0, 50, 50, 0, 0, 0, 0, 0, 30, '2026-05-28 06:37:39', '2026-05-28 06:38:56', 0, 0, 0, 0, 0, 0, 'United States', 33.33, 'India', 33.33, NULL, 0.00, NULL, 0.00, NULL, 0.00);

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

--
-- Table structure for table `user_business_licenses`
--

CREATE TABLE `user_business_licenses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `days` int(11) NOT NULL,
  `price` decimal(10,2) 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 `user_business_licenses`
--

INSERT INTO `user_business_licenses` (`id`, `user_id`, `days`, `price`, `created_at`, `updated_at`) VALUES
(122, 12, 15, 0.00, '2026-04-01 08:49:06', '2026-04-01 08:49:06'),
(123, 12, 20, 20.00, '2026-04-01 08:49:06', '2026-04-01 08:49:06'),
(124, 12, 30, 30.00, '2026-04-01 08:49:06', '2026-04-01 08:49:06');

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

--
-- 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 `user_video_request_categories`
--

CREATE TABLE `user_video_request_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `video_request_category_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 `user_video_request_categories`
--

INSERT INTO `user_video_request_categories` (`id`, `user_id`, `video_request_category_id`, `created_at`, `updated_at`) VALUES
(3, 12, 1, NULL, NULL),
(4, 12, 2, NULL, NULL),
(5, 645, 1, NULL, NULL),
(6, 645, 2, NULL, NULL),
(7, 20, 1, NULL, NULL),
(8, 20, 2, NULL, NULL),
(9, 32, 1, NULL, NULL),
(10, 32, 2, NULL, NULL),
(11, 192, 1, NULL, NULL),
(12, 192, 2, NULL, NULL),
(13, 44, 1, NULL, NULL),
(14, 44, 2, NULL, NULL),
(15, 14, 1, NULL, NULL),
(16, 14, 2, NULL, NULL),
(17, 43, 1, NULL, NULL),
(18, 43, 2, NULL, NULL);

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

--
-- Table structure for table `verification_audit_logs`
--

CREATE TABLE `verification_audit_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `from_tier` varchar(255) DEFAULT NULL,
  `to_tier` varchar(255) DEFAULT NULL,
  `note` text 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 `verification_audit_logs`
--

INSERT INTO `verification_audit_logs` (`id`, `user_id`, `admin_id`, `action`, `from_tier`, `to_tier`, `note`, `created_at`, `updated_at`) VALUES
(1, 67, 1, 'approved', NULL, 'silver', NULL, '2026-02-20 06:45:24', '2026-02-20 06:45:24'),
(2, 68, 1, 'approved', NULL, 'silver', NULL, '2026-02-20 06:59:20', '2026-02-20 06:59:20'),
(3, 68, 1, 'upgraded', 'silver', 'gold', '', '2026-02-20 07:14:58', '2026-02-20 07:14:58'),
(4, 68, 1, 'upgraded', 'gold', 'premium', '', '2026-02-20 07:15:36', '2026-02-20 07:15:36'),
(5, 69, 1, 'approved', NULL, 'silver', NULL, '2026-02-23 03:15:59', '2026-02-23 03:15:59'),
(6, 70, 1, 'approved', NULL, NULL, NULL, '2026-02-23 03:30:13', '2026-02-23 03:30:13'),
(7, 12, 1, 'upgraded', 'none', 'gold', '', '2026-02-25 06:22:46', '2026-02-25 06:22:46'),
(8, 68, 1, 'upgraded', '', 'silver', '', '2026-02-25 06:27:57', '2026-02-25 06:27:57'),
(9, 68, 1, 'downgraded', 'silver', NULL, '', '2026-02-25 06:39:38', '2026-02-25 06:39:38'),
(10, 2, 1, 'approved', NULL, NULL, NULL, '2026-02-27 05:38:27', '2026-02-27 05:38:27'),
(11, 2, 1, 'revoked', '', NULL, 'You are a user', '2026-02-27 05:41:22', '2026-02-27 05:41:22'),
(12, 644, 1, 'approved', NULL, NULL, NULL, '2026-03-09 05:58:41', '2026-03-09 05:58:41'),
(13, 645, 1, 'approved', NULL, NULL, NULL, '2026-03-09 06:12:07', '2026-03-09 06:12:07'),
(14, 646, 1, 'approved', NULL, NULL, NULL, '2026-05-19 08:09:53', '2026-05-19 08:09:53');

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

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

CREATE TABLE `verification_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(200) NOT NULL,
  `username` varchar(150) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `country` int(10) UNSIGNED NOT NULL,
  `document_type` varchar(100) DEFAULT NULL,
  `id_card` varchar(100) DEFAULT NULL,
  `id_card_back` varchar(100) DEFAULT NULL,
  `passport` varchar(100) DEFAULT NULL,
  `image_selfie` varchar(100) DEFAULT NULL,
  `category` int(10) UNSIGNED NOT NULL,
  `subcategory` int(11) NOT NULL,
  `link_social` varchar(200) NOT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `language` varchar(20) DEFAULT NULL,
  `status` varchar(100) NOT NULL DEFAULT 'pending',
  `tier` varchar(255) DEFAULT NULL,
  `price_paid` decimal(10,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

INSERT INTO `verification_requests` (`id`, `user_id`, `name`, `email`, `username`, `phone`, `country`, `document_type`, `id_card`, `id_card_back`, `passport`, `image_selfie`, `category`, `subcategory`, `link_social`, `ip`, `language`, `status`, `tier`, `price_paid`, `created_at`, `updated_at`) VALUES
(1, 66, 'User 1', 'user1@demo.com', '', '9898767656', 99, 'id_driver_license', 'zouHioJxgU9hen9YKaB5UuiD29OvCQ9d3CE2UoDW.png', 'UWDBtZlNoOMFSTZlBhYzh0apF4MJo8rn5qjS6gse.png', NULL, 'EktOG3NpAFNBgdRO945RRVLPBTqtfKQKAkPINX5F.png', 5, 28, 'https://fb.com/abhishekb', '::1', 'en', 'deleted', 'gold', 50.00, '2026-02-20 04:52:33', '2026-03-12 09:20:43'),
(2, 67, 'User 22', 'user22@demo.com', '', '2345656767', 99, 'id_driver_license', '3XK9bjJi0sNI2fdHo1DiKEOUSVALIIOUMK7pPGQE.png', 'HYRhyiMbWiXl62qA6yKEgRXbYczxpjxrI6RwJ81E.png', NULL, 'pQXUBK1nFsJzUNXbXguaetgYwZvMf4HZgUnl271w.png', 5, 28, 'http://localhost/mxmeo/', '::1', 'en', 'deleted', 'silver', 0.00, '2026-02-20 06:45:03', '2026-03-12 09:20:49'),
(3, 68, 'user23', 'user23@demo.com', '', '8787475875', 99, 'id_driver_license', 'O5U0pMb5bwe2bMwvS7iWUoZCppdeacW25P5ySogn.png', 'xYF8iEXGlu9B7C28HzGvtQwWdja2aDrvRMevAKcM.png', NULL, 'kzHeJPH9pk6oddu9WckUZII7mwhNIksu1IClOkky.png', 5, 28, 'https://example.com', '::1', 'en', 'approved', 'silver', 0.00, '2026-02-20 06:58:33', '2026-02-20 06:59:20'),
(4, 69, 'USer 24', 'user24@demo.com', '', '9878767656', 99, 'id_driver_license', 'UfwSQQ7BgobwkeKJ89NcvELbfN7vCJ0EQLD5f7N8.jpg', 'zImwmgEWknCtdqWSJtWpkRCQHVSPMzRkDzsnj1ZE.jpg', NULL, '2X9IYLWlQKOzBlOWxilu5mwG2wTiinbeL6XoscGW.jpg', 5, 28, 'https://example.com', '::1', 'en', 'deleted', 'silver', 0.00, '2026-02-23 03:15:17', '2026-03-12 09:20:54'),
(5, 70, 'User 25', 'user25@demo.com', '', '8758758575', 99, 'passport', NULL, NULL, 'rq9QgrPHHOeyzcvSgbNw3e0oP0cfObQr6IXv7EGC.jpg', 'uY6VdCVTenuAjuMiH3q3aFq9QZgUG2WybCFMFlSR.jpg', 5, 28, 'https://www.linkedin.com/', '::1', 'en', 'deleted', NULL, 0.00, '2026-02-23 03:27:58', '2026-03-12 09:19:55'),
(21, 2, 'User Demo', 'user@demo.com', '', '78945123000', 99, 'id_driver_license', 'uujjoSEkafOtvZUMrClDMvcVSXCq6T9ceftqnSbt.png', 'Fb9YItRshQFkDAhoGsn2ITdJyHqR6oDvLLHBEjV9.png', NULL, 'aKvSfjPMwewQy7Y05c6sKNjznJzUgZFEtP9iULpG.png', 1, 19, 'https://www.miracuves.com/', '152.58.17.226', 'en', 'approved', NULL, 0.00, '2026-02-27 05:37:25', '2026-02-27 05:38:27'),
(22, 644, 'user', 'user222@demo.com', '', '9898989898', 99, 'id_driver_license', 'Q3X8Cl43wkGuASXZkEL6nf8R8Dw5NurglYsQb5d9.jpg', '1IQdcRVlrN7kQhHtH8G5rXZaXmuk88A5dVyXCAOs.jpg', NULL, 'QzsBnOhAueZHkMPwuliXRU5w1vFcMGqFecsnxBUp.jpg', 4, 50, 'https://google.com', '152.59.38.168', 'en', 'approved', NULL, 0.00, '2026-03-09 05:50:38', '2026-03-09 05:58:41'),
(23, 645, 'dyhdy', 'user22@demo.com', '', '9598989898', 49, 'id_driver_license', '5agalj0njpf7TDCKp0f37OgQZiBI3keHRuv6mPqU.jpg', 'EuyEFebp32jc6c3jKnb7VStzS6N37zLz9Gerkv81.jpg', NULL, 'FTJvSDD0mhF56mu1tpBjspYLazL8kWAuqMQriN6P.jpg', 4, 49, 'https://google.com', '152.59.38.168', 'en', 'approved', NULL, 0.00, '2026-03-09 06:11:52', '2026-03-09 06:12:07'),
(24, 646, 'Business Account', 'business@demo.com', '', '09876543210', 3, 'id_driver_license', 'rcOuYc4kDJxfSv0wgPYE3vQF76pAxnuP6WJg3gBW.jpg', 'a2pNupBqXn8RKTdH3ORsIG7olhI1vhu2Qcuz7niD.png', NULL, 'nFRUFWdnIhqjPf8UX8niIXUnEkth9zOqdYOMnhgI.jpg', 5, 28, 'https://facebook.com', '127.0.0.1', 'en', 'deleted', NULL, 0.00, '2026-05-19 07:30:26', '2026-05-19 09:43:18');

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

--
-- Table structure for table `video_occasions`
--

CREATE TABLE `video_occasions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `unique_id` varchar(100) 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;

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

--
-- Table structure for table `video_request_categories`
--

CREATE TABLE `video_request_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) 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 `video_request_categories`
--

INSERT INTO `video_request_categories` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Birthday', '1', '2026-02-24 11:36:58', '2026-02-24 11:36:58'),
(2, 'Motivation', '1', '2026-02-24 11:37:05', '2026-02-24 11:37:05');

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

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

--
-- Dumping data for table `withdrawals`
--

INSERT INTO `withdrawals` (`id`, `user_id`, `status`, `amount`, `date`, `gateway`, `account`, `estimated_payment`, `date_paid`, `txn_id`) VALUES
(1, 12, 'paid', '999', '2026-02-27 05:47:22', 'bank', '123456799', '2026-03-08 13:00:00', '2026-02-27 05:47:49', ''),
(6, 12, 'paid', '100', '2026-03-03 11:41:33', 'bank', '123456799', '2026-04-08 13:00:00', '2026-03-10 13:37:15', ''),
(9, 12, 'pending', '400', '2026-06-08 08:21:49', 'PayPal', 'provider@demo.com', '2026-07-08 07:30:00', '0000-00-00 00:00:00', '');

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

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

--
-- Indexes for table `business_asset_folders`
--
ALTER TABLE `business_asset_folders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_asset_folders_business_profile_id_foreign` (`business_profile_id`),
  ADD KEY `business_asset_folders_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `business_contacts`
--
ALTER TABLE `business_contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_contacts_business_profile_id_foreign` (`business_profile_id`);

--
-- Indexes for table `business_order_comments`
--
ALTER TABLE `business_order_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_order_comments_order_id_foreign` (`order_id`),
  ADD KEY `business_order_comments_user_id_foreign` (`user_id`);

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

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

--
-- Indexes for table `business_team_members`
--
ALTER TABLE `business_team_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_team_members_business_profile_id_foreign` (`business_profile_id`),
  ADD KEY `business_team_members_user_id_foreign` (`user_id`);

--
-- Indexes for table `campaigns`
--
ALTER TABLE `campaigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaigns_business_profile_id_foreign` (`business_profile_id`),
  ADD KEY `campaigns_campaign_group_id_foreign` (`campaign_group_id`);

--
-- Indexes for table `campaign_analytics`
--
ALTER TABLE `campaign_analytics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaign_analytics_order_id_foreign` (`order_id`);

--
-- Indexes for table `campaign_applications`
--
ALTER TABLE `campaign_applications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `campaign_applications_campaign_id_creator_id_unique` (`campaign_id`,`creator_id`),
  ADD KEY `campaign_applications_creator_id_foreign` (`creator_id`);

--
-- Indexes for table `campaign_conversions`
--
ALTER TABLE `campaign_conversions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaign_conversions_order_id_foreign` (`order_id`);

--
-- Indexes for table `campaign_groups`
--
ALTER TABLE `campaign_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaign_groups_business_profile_id_foreign` (`business_profile_id`);

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

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

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `code` (`code`);

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

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

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

--
-- Indexes for table `custom_offers`
--
ALTER TABLE `custom_offers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `custom_offers_quote_id_foreign` (`quote_id`),
  ADD KEY `custom_offers_sender_id_foreign` (`sender_id`),
  ADD KEY `custom_offers_receiver_id_foreign` (`receiver_id`);

--
-- Indexes for table `custom_quotes`
--
ALTER TABLE `custom_quotes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `custom_quotes_buyer_id_foreign` (`buyer_id`),
  ADD KEY `custom_quotes_seller_id_foreign` (`seller_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 `favorites`
--
ALTER TABLE `favorites`
  ADD PRIMARY KEY (`id`),
  ADD KEY `celebrity` (`celebrity`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoices_invoice_number_unique` (`invoice_number`),
  ADD KEY `invoices_business_profile_id_index` (`business_profile_id`);

--
-- Indexes for table `invoice_items`
--
ALTER TABLE `invoice_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice_items_invoice_id_index` (`invoice_id`),
  ADD KEY `invoice_items_campaign_id_index` (`campaign_id`);

--
-- 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 `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sender_id` (`sender_id`),
  ADD KEY `receiver_id` (`receiver_id`),
  ADD KEY `transactions_id` (`transactions_id`),
  ADD KEY `status` (`status`),
  ADD KEY `buyer_id` (`buyer_id`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `messages_custom_offer_id_foreign` (`custom_offer_id`);

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

--
-- Indexes for table `onboarding_checklists`
--
ALTER TABLE `onboarding_checklists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `onboarding_checklists_business_profile_id_foreign` (`business_profile_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `seller` (`seller_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `type` (`type`),
  ADD KEY `status` (`status`),
  ADD KEY `delivery_deadline` (`expires`),
  ADD KEY `encode` (`encode`),
  ADD KEY `job_id` (`job_id`),
  ADD KEY `orders_video_request_category_id_foreign` (`video_request_category_id`),
  ADD KEY `orders_business_profile_id_foreign` (`business_profile_id`),
  ADD KEY `orders_custom_offer_id_foreign` (`custom_offer_id`);

--
-- Indexes for table `order_approvals`
--
ALTER TABLE `order_approvals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_approvals_order_id_foreign` (`order_id`),
  ADD KEY `order_approvals_reviewer_id_foreign` (`reviewer_id`);

--
-- Indexes for table `order_milestones`
--
ALTER TABLE `order_milestones`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_milestones_order_id_foreign` (`order_id`);

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

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

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

--
-- 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 `refunds`
--
ALTER TABLE `refunds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `refunds_orders_id_index` (`order_id`),
  ADD KEY `refunds_user_id_index` (`user_id`),
  ADD KEY `refunds_seller_id_index` (`seller_id`),
  ADD KEY `refunds_status_index` (`status`);

--
-- 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 `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reviews_user_id_index` (`user_id`),
  ADD KEY `reviews_orders_id_index` (`orders_id`),
  ADD KEY `seller` (`seller_id`),
  ADD KEY `rating` (`rating`);

--
-- Indexes for table `roles_and_permissions`
--
ALTER TABLE `roles_and_permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`),
  ADD KEY `roles_and_permissions_permissions_index` (`permissions`(768));

--
-- 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_expires_at_index` (`expires_at`),
  ADD KEY `stories_status_index` (`status`);

--
-- Indexes for table `story_views`
--
ALTER TABLE `story_views`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `story_views_story_id_user_id_ip_address_unique` (`story_id`,`user_id`,`ip_address`),
  ADD KEY `story_views_story_id_index` (`story_id`),
  ADD KEY `story_views_user_id_index` (`user_id`);

--
-- Indexes for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_tickets_business_profile_id_foreign` (`business_profile_id`);

--
-- Indexes for table `support_ticket_replies`
--
ALTER TABLE `support_ticket_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_ticket_replies_ticket_id_foreign` (`ticket_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 `tips`
--
ALTER TABLE `tips`
  ADD KEY `tips_user_id_foreign` (`user_id`),
  ADD KEY `tips_seller_id_foreign` (`seller_id`),
  ADD KEY `tips_orders_id_foreign` (`orders_id`),
  ADD KEY `tips_transactions_id_foreign` (`transactions_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `seller` (`seller`),
  ADD KEY `approved` (`status`);

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

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

--
-- Indexes for table `user_business_licenses`
--
ALTER TABLE `user_business_licenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_business_licenses_user_id_foreign` (`user_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 `user_video_request_categories`
--
ALTER TABLE `user_video_request_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_video_request_categories_user_id_foreign` (`user_id`),
  ADD KEY `user_video_request_categories_video_request_category_id_foreign` (`video_request_category_id`);

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

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

--
-- Indexes for table `video_occasions`
--
ALTER TABLE `video_occasions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `unique_id` (`unique_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `support_ticket_replies`
--
ALTER TABLE `support_ticket_replies`
  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=191;

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `creator_pricing_rules`
--
ALTER TABLE `creator_pricing_rules`
  ADD CONSTRAINT `creator_pricing_rules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `custom_offers`
--
ALTER TABLE `custom_offers`
  ADD CONSTRAINT `custom_offers_quote_id_foreign` FOREIGN KEY (`quote_id`) REFERENCES `custom_quotes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `custom_offers_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `custom_offers_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `custom_quotes`
--
ALTER TABLE `custom_quotes`
  ADD CONSTRAINT `custom_quotes_buyer_id_foreign` FOREIGN KEY (`buyer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `custom_quotes_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_custom_offer_id_foreign` FOREIGN KEY (`custom_offer_id`) REFERENCES `custom_offers` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_business_profile_id_foreign` FOREIGN KEY (`business_profile_id`) REFERENCES `business_profiles` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `orders_custom_offer_id_foreign` FOREIGN KEY (`custom_offer_id`) REFERENCES `custom_offers` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `orders_video_request_category_id_foreign` FOREIGN KEY (`video_request_category_id`) REFERENCES `video_request_categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `stories`
--
ALTER TABLE `stories`
  ADD CONSTRAINT `stories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `story_views`
--
ALTER TABLE `story_views`
  ADD CONSTRAINT `story_views_story_id_foreign` FOREIGN KEY (`story_id`) REFERENCES `stories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `story_views_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tips`
--
ALTER TABLE `tips`
  ADD CONSTRAINT `tips_orders_id_foreign` FOREIGN KEY (`orders_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tips_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tips_transactions_id_foreign` FOREIGN KEY (`transactions_id`) REFERENCES `transactions` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `tips_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_business_licenses`
--
ALTER TABLE `user_business_licenses`
  ADD CONSTRAINT `user_business_licenses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_video_request_categories`
--
ALTER TABLE `user_video_request_categories`
  ADD CONSTRAINT `user_video_request_categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_video_request_categories_video_request_category_id_foreign` FOREIGN KEY (`video_request_category_id`) REFERENCES `video_request_categories` (`id`) ON DELETE CASCADE;
COMMIT;

