-- ==================================================================== -- Felles Platform - Clean Production Database Export for phpMyAdmin -- Compatible with MySQL 5.7+, MySQL 8.0+, MariaDB 10.3+, and phpMyAdmin -- Generated: 2026-09-04 13:41:57 -- ==================================================================== SET FOREIGN_KEY_CHECKS = 0; SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -------------------------------------------------------- -- Table structure for table `activation_release_requests` -- -------------------------------------------------------- DROP TABLE IF EXISTS `activation_release_requests`; CREATE TABLE `activation_release_requests` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `request_number` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `amount` decimal(14,2) NOT NULL DEFAULT '50', `status` varchar(255) NOT NULL DEFAULT 'pending', `user_notes` longtext NULL DEFAULT NULL, `admin_notes` longtext NULL DEFAULT NULL, `reviewed_by` bigint(20) UNSIGNED NULL DEFAULT NULL, `reviewed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `ad_view_logs` -- -------------------------------------------------------- DROP TABLE IF EXISTS `ad_view_logs`; CREATE TABLE `ad_view_logs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, `advertisement_id` bigint(20) UNSIGNED NOT NULL, `user_vip_subscription_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `reward_amount` decimal(14,2) NOT NULL, `duration_watched_seconds` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `session_token` varchar(255) NOT NULL, `started_at` timestamp NOT NULL, `completed_at` timestamp NULL DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'started', `ip_address` varchar(255) NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `advertisements` -- -------------------------------------------------------- DROP TABLE IF EXISTS `advertisements`; CREATE TABLE `advertisements` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `banner_image` varchar(255) NULL DEFAULT NULL, `target_url` varchar(255) NOT NULL, `duration_seconds` bigint(20) UNSIGNED NOT NULL DEFAULT '15', `reward_amount` decimal(14,2) NOT NULL DEFAULT '2.5', `min_vip_package_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `daily_view_limit` bigint(20) UNSIGNED NOT NULL DEFAULT '1000', `is_active` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `advertisements` INSERT INTO `advertisements` (`id`, `title`, `slug`, `banner_image`, `target_url`, `duration_seconds`, `reward_amount`, `min_vip_package_id`, `daily_view_limit`, `is_active`, `created_at`, `updated_at`) VALUES ('1', 'Visit TechBazaar & Explore Latest Gadgets 2026', 'visit-techbazaar-gadgets', NULL, 'https://www.dollarplaza.org/', '10', '3.5', NULL, '1000', '1', '2026-08-26 11:06:50', '2026-08-27 05:15:23'); INSERT INTO `advertisements` (`id`, `title`, `slug`, `banner_image`, `target_url`, `duration_seconds`, `reward_amount`, `min_vip_package_id`, `daily_view_limit`, `is_active`, `created_at`, `updated_at`) VALUES ('2', 'Explore CloudPay Instant Wallet & Remittance', 'explore-cloudpay-wallet', NULL, 'https://cloudpay.example.com', '15', '5', NULL, '1000', '1', '2026-08-26 11:06:50', '2026-08-26 11:06:50'); INSERT INTO `advertisements` (`id`, `title`, `slug`, `banner_image`, `target_url`, `duration_seconds`, `reward_amount`, `min_vip_package_id`, `daily_view_limit`, `is_active`, `created_at`, `updated_at`) VALUES ('3', 'Learn Full-Stack Development with CodeBangla Academy', 'learn-codebangla-academy', NULL, 'https://codebangla.example.com', '20', '7.5', NULL, '500', '1', '2026-08-26 11:06:50', '2026-08-26 11:06:50'); INSERT INTO `advertisements` (`id`, `title`, `slug`, `banner_image`, `target_url`, `duration_seconds`, `reward_amount`, `min_vip_package_id`, `daily_view_limit`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'Download EcoShop Android & iOS Mobile Shopping App', 'download-ecoshop-mobile', NULL, 'https://www.dollarplaza.org/', '15', '6', NULL, '800', '1', '2026-08-26 11:06:50', '2026-08-27 05:14:24'); INSERT INTO `advertisements` (`id`, `title`, `slug`, `banner_image`, `target_url`, `duration_seconds`, `reward_amount`, `min_vip_package_id`, `daily_view_limit`, `is_active`, `created_at`, `updated_at`) VALUES ('5', 'Digital E-Commerce Flash Sale', 'digital-e-commerce-flash-sale-gxykz', NULL, 'https://www.dollarplaza.org/', '15', '2', NULL, '500', '1', '2026-08-27 05:02:26', '2026-08-27 05:11:09'); INSERT INTO `advertisements` (`id`, `title`, `slug`, `banner_image`, `target_url`, `duration_seconds`, `reward_amount`, `min_vip_package_id`, `daily_view_limit`, `is_active`, `created_at`, `updated_at`) VALUES ('6', 'Digital E-Commerce Flash Sale', 'digital-e-commerce-flash-sale-qqkaz', NULL, 'https://example.com/sale', '15', '2', NULL, '500', '1', '2026-08-27 05:03:44', '2026-08-27 05:03:44'); INSERT INTO `advertisements` (`id`, `title`, `slug`, `banner_image`, `target_url`, `duration_seconds`, `reward_amount`, `min_vip_package_id`, `daily_view_limit`, `is_active`, `created_at`, `updated_at`) VALUES ('7', 'Digital E-Commerce Flash Sale', 'digital-e-commerce-flash-sale-cxwh6', NULL, 'https://example.com/sale', '15', '2', NULL, '500', '1', '2026-08-27 05:03:55', '2026-08-27 05:03:55'); INSERT INTO `advertisements` (`id`, `title`, `slug`, `banner_image`, `target_url`, `duration_seconds`, `reward_amount`, `min_vip_package_id`, `daily_view_limit`, `is_active`, `created_at`, `updated_at`) VALUES ('8', 'Test Security Ad', 'test-security-ad', NULL, 'https://example.com', '30', '5', NULL, '1000', '1', '2026-08-27 14:27:01', '2026-08-27 14:27:01'); -- -------------------------------------------------------- -- Table structure for table `audit_logs` -- -------------------------------------------------------- DROP TABLE IF EXISTS `audit_logs`; CREATE TABLE `audit_logs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `action` varchar(255) NOT NULL, `ip_address` varchar(255) NULL DEFAULT NULL, `user_agent` longtext NULL DEFAULT NULL, `details` longtext NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `audit_logs` INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('1', NULL, 'Signup Verification Code Dispatched', '127.0.0.1', 'Symfony', '{\"email\":\"clean_user_987@gmail.com\"}', '2026-08-27 14:35:46', '2026-08-27 14:35:46'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('2', NULL, 'User Registered with Verified Email', '127.0.0.1', 'Symfony', '[]', '2026-08-27 14:35:46', '2026-08-27 14:35:46'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('3', '1', 'User Logged In', '127.0.0.1', 'Symfony', '[]', '2026-08-27 15:56:47', '2026-08-27 15:56:47'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('4', '1', 'User Logged In', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:44:30', '2026-08-28 09:44:30'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('5', '1', 'Admin updated SMTP email configuration', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:46:11', '2026-08-28 09:46:11'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('6', NULL, 'Signup Verification Code Dispatched', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', '{\"email\":\"fasale1952@mapsguy.com\"}', '2026-08-28 09:47:19', '2026-08-28 09:47:19'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('7', NULL, 'User Registered with Verified Email', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', '[]', '2026-08-28 09:47:40', '2026-08-28 09:47:40'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('8', NULL, 'Signup Verification Code Dispatched', '127.0.0.1', 'Symfony', '{\"email\":\"verify_test_1787910548@example.com\"}', '2026-08-28 09:49:14', '2026-08-28 09:49:14'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('9', NULL, 'User Registered with Verified Email', '127.0.0.1', 'Symfony', '[]', '2026-08-28 09:49:16', '2026-08-28 09:49:16'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('10', NULL, 'User Logged In', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', '[]', '2026-08-28 09:51:58', '2026-08-28 09:51:58'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('11', '1', 'User Logged Out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:53:31', '2026-08-28 09:53:31'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('12', NULL, 'Signup Verification Code Dispatched', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '{\"email\":\"29c1be8693c2@westcast-systems.com\"}', '2026-08-28 09:55:30', '2026-08-28 09:55:30'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('13', NULL, 'User Registered with Verified Email', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:55:59', '2026-08-28 09:55:59'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('14', NULL, 'Submitted Deposit Request', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '{\"deposit_id\":1,\"amount\":50,\"is_activation\":true}', '2026-08-28 09:56:51', '2026-08-28 09:56:51'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('15', NULL, 'User Logged Out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:57:43', '2026-08-28 09:57:43'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('16', '1', 'User Logged In', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:57:56', '2026-08-28 09:57:56'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('17', '1', 'Admin rejected deposit #DEP-UPMOFQOX', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '{\"deposit_id\":1,\"reason\":\"Invalid transaction reference or unverified payment proof\",\"is_activation\":true}', '2026-08-28 09:58:28', '2026-08-28 09:58:28'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('18', '1', 'User Logged Out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:58:46', '2026-08-28 09:58:46'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('19', NULL, 'User Logged In', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:58:57', '2026-08-28 09:58:57'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('20', NULL, 'Submitted Deposit Request', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '{\"deposit_id\":2,\"amount\":50,\"is_activation\":true}', '2026-08-28 09:59:21', '2026-08-28 09:59:21'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('21', NULL, 'User Logged Out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:59:30', '2026-08-28 09:59:30'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('22', '1', 'User Logged In', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 09:59:45', '2026-08-28 09:59:45'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('23', '1', 'Admin approved deposit #DEP-CZACSD8R', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '{\"deposit_id\":2,\"amount\":\"50.00\",\"account_activated\":true}', '2026-08-28 10:00:06', '2026-08-28 10:00:06'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('24', '1', 'User Logged Out', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 10:07:20', '2026-08-28 10:07:20'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('25', NULL, 'User Logged In', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '[]', '2026-08-28 10:07:28', '2026-08-28 10:07:28'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('26', NULL, 'Two-Factor Authentication enabled', '127.0.0.1', 'Mozilla/5.0 (Linux; Android 15; Pixel 9) AppleWebKit/537.36 (KHTML, like Gecko) Edg/151.0.0.0 Mobile Safari/537.36', '[]', '2026-08-28 10:08:52', '2026-08-28 10:08:52'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('27', NULL, 'Two-Factor Authentication disabled', '127.0.0.1', 'Mozilla/5.0 (Linux; Android 15; Pixel 9) AppleWebKit/537.36 (KHTML, like Gecko) Edg/151.0.0.0 Mobile Safari/537.36', '[]', '2026-08-28 10:08:56', '2026-08-28 10:08:56'); INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `ip_address`, `user_agent`, `details`, `created_at`, `updated_at`) VALUES ('28', '1', 'User Logged In', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36 Edg/152.0.0.0', '[]', '2026-09-04 13:18:06', '2026-09-04 13:18:06'); -- -------------------------------------------------------- -- Table structure for table `cache` -- -------------------------------------------------------- DROP TABLE IF EXISTS `cache`; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` longtext NOT NULL, `expiration` bigint(20) UNSIGNED NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `cache` INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-b95cd370efcdece21569bbc0a6e262f3:timer', 'i:1787914271;', '1787914271'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-b95cd370efcdece21569bbc0a6e262f3', 'i:5;', '1787914271'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-f3873df25e6f9e956564130426ace7cb:timer', 'i:1787910777;', '1787910777'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-f3873df25e6f9e956564130426ace7cb', 'i:1;', '1787910778'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-signup_velocity_hr_127.0.0.1', 'i:1;', '1787914524'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-signup_velocity_day_127.0.0.1', 'i:1;', '1787997324'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-2b6624d98fb940ab1eaa1e657f07d64d:timer', 'i:1787911215;', '1787911215'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-2b6624d98fb940ab1eaa1e657f07d64d', 'i:1;', '1787911215'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-action_lock_a17c5df807eef64c99e3f744eab83924', 'i:1;', '1787911170'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-819ae0eff35acfd7db274b374b5ffcb0:timer', 'i:1787911708;', '1787911708'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-819ae0eff35acfd7db274b374b5ffcb0', 'i:1;', '1787911708'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-c01d0c658ca3d3aa0444687f4acc7af6:timer', 'i:1788527944;', '1788527944'); INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('felles-cache-c01d0c658ca3d3aa0444687f4acc7af6', 'i:1;', '1788527944'); -- -------------------------------------------------------- -- Table structure for table `cache_locks` -- -------------------------------------------------------- DROP TABLE IF EXISTS `cache_locks`; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` bigint(20) UNSIGNED NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `deposits` -- -------------------------------------------------------- DROP TABLE IF EXISTS `deposits`; CREATE TABLE `deposits` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `deposit_number` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `payment_method_id` bigint(20) UNSIGNED NOT NULL, `wallet_type` varchar(255) NOT NULL DEFAULT 'main', `amount` decimal(14,2) NOT NULL, `fee` decimal(14,2) NOT NULL DEFAULT '0', `final_amount` decimal(14,2) NOT NULL, `sender_number` varchar(255) NULL DEFAULT NULL, `transaction_reference` varchar(255) NOT NULL, `proof_screenshot` varchar(255) NULL DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `admin_notes` longtext NULL DEFAULT NULL, `processed_by` bigint(20) UNSIGNED NULL DEFAULT NULL, `processed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `email_verification_codes` -- -------------------------------------------------------- DROP TABLE IF EXISTS `email_verification_codes`; CREATE TABLE `email_verification_codes` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `registration_data` longtext NULL DEFAULT NULL, `expires_at` timestamp NOT NULL, `last_sent_at` timestamp NULL DEFAULT NULL, `attempts` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `failed_jobs` -- -------------------------------------------------------- DROP TABLE IF EXISTS `failed_jobs`; CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` longtext NOT NULL, `queue` longtext NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `investment_plans` -- -------------------------------------------------------- DROP TABLE IF EXISTS `investment_plans`; CREATE TABLE `investment_plans` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `badge` varchar(255) NULL DEFAULT NULL, `min_amount` decimal(14,2) NOT NULL, `max_amount` decimal(14,2) NOT NULL, `duration_days` bigint(20) UNSIGNED NOT NULL, `return_rate_percent` decimal(14,2) NOT NULL, `payout_frequency` varchar(255) NOT NULL DEFAULT 'daily', `capital_back` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `description` longtext NULL DEFAULT NULL, `terms` longtext NULL DEFAULT NULL, `is_active` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `investment_plans` INSERT INTO `investment_plans` (`id`, `name`, `badge`, `min_amount`, `max_amount`, `duration_days`, `return_rate_percent`, `payout_frequency`, `capital_back`, `description`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('1', '7-Day Liquidity Boost', 'Fast Return', '100', '5000', '7', '3.5', 'at_maturity', '1', 'Short term reward plan allocating platform liquidity with fixed reward at maturity.', 'Principal and rewards are returned to your Main Wallet after 7 days.', '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `investment_plans` (`id`, `name`, `badge`, `min_amount`, `max_amount`, `duration_days`, `return_rate_percent`, `payout_frequency`, `capital_back`, `description`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('2', '30-Day Growth Yield', 'Most Popular', '500', '25000', '30', '12', 'daily', '1', 'Accrues daily reward portions into your main account with full principal return on day 30.', 'Daily payouts can be withdrawn or reinvested anytime.', '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `investment_plans` (`id`, `name`, `badge`, `min_amount`, `max_amount`, `duration_days`, `return_rate_percent`, `payout_frequency`, `capital_back`, `description`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('3', '90-Day VIP Staking', 'Highest Yield', '2000', '100000', '90', '32', 'daily', '1', 'Institutional grade platform staking pool with premium tier priority loan approvals.', 'VIP tier perks include zero-fee withdrawals.', '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `investment_plans` (`id`, `name`, `badge`, `min_amount`, `max_amount`, `duration_days`, `return_rate_percent`, `payout_frequency`, `capital_back`, `description`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'Fixed Income Yield Plan', NULL, '1000', '50000', '60', '12.5', 'daily', '1', 'Daily yield return on locked capital with 100% principal back.', NULL, '1', '2026-08-27 05:03:44', '2026-08-27 05:03:44'); INSERT INTO `investment_plans` (`id`, `name`, `badge`, `min_amount`, `max_amount`, `duration_days`, `return_rate_percent`, `payout_frequency`, `capital_back`, `description`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('5', 'Fixed Income Yield Plan', NULL, '1000', '50000', '60', '12.5', 'daily', '1', 'Daily yield return on locked capital with 100% principal back.', NULL, '1', '2026-08-27 05:03:55', '2026-08-27 05:03:55'); -- -------------------------------------------------------- -- Table structure for table `job_batches` -- -------------------------------------------------------- DROP TABLE IF EXISTS `job_batches`; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` bigint(20) UNSIGNED NOT NULL, `pending_jobs` bigint(20) UNSIGNED NOT NULL, `failed_jobs` bigint(20) UNSIGNED NOT NULL, `failed_job_ids` longtext NOT NULL, `options` longtext NULL DEFAULT NULL, `cancelled_at` bigint(20) UNSIGNED NULL DEFAULT NULL, `created_at` bigint(20) UNSIGNED NOT NULL, `finished_at` bigint(20) UNSIGNED NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `jobs` -- -------------------------------------------------------- DROP TABLE IF EXISTS `jobs`; CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` bigint(20) UNSIGNED NOT NULL, `reserved_at` bigint(20) UNSIGNED NULL DEFAULT NULL, `available_at` bigint(20) UNSIGNED NOT NULL, `created_at` bigint(20) UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `kyc_submissions` -- -------------------------------------------------------- DROP TABLE IF EXISTS `kyc_submissions`; CREATE TABLE `kyc_submissions` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, `full_name` varchar(255) NOT NULL, `dob` date NOT NULL, `nid_number` varchar(255) NOT NULL, `id_front_image` varchar(255) NULL DEFAULT NULL, `id_back_image` varchar(255) NULL DEFAULT NULL, `selfie_image` varchar(255) NULL DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `admin_notes` longtext NULL DEFAULT NULL, `reviewed_by` bigint(20) UNSIGNED NULL DEFAULT NULL, `reviewed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `ledger_entries` -- -------------------------------------------------------- DROP TABLE IF EXISTS `ledger_entries`; CREATE TABLE `ledger_entries` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `transaction_uuid` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `wallet_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `wallet_type` varchar(255) NOT NULL, `entry_type` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `amount` decimal(14,2) NOT NULL, `previous_balance` decimal(14,2) NOT NULL DEFAULT '0', `new_balance` decimal(14,2) NOT NULL DEFAULT '0', `reference_type` varchar(255) NULL DEFAULT NULL, `reference_id` varchar(255) NULL DEFAULT NULL, `description` varchar(255) NOT NULL, `created_by` varchar(255) NOT NULL DEFAULT 'system', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `loan_applications` -- -------------------------------------------------------- DROP TABLE IF EXISTS `loan_applications`; CREATE TABLE `loan_applications` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `application_number` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `loan_product_id` bigint(20) UNSIGNED NOT NULL, `requested_amount` decimal(14,2) NOT NULL, `approved_amount` decimal(14,2) NOT NULL DEFAULT '0', `interest_rate_percent` decimal(14,2) NOT NULL, `interest_amount` decimal(14,2) NOT NULL DEFAULT '0', `total_payable` decimal(14,2) NOT NULL DEFAULT '0', `installment_amount` decimal(14,2) NOT NULL DEFAULT '0', `total_installments` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `paid_installments` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `collateral_locked_amount` decimal(14,2) NOT NULL DEFAULT '0', `purpose` varchar(255) NULL DEFAULT NULL, `employment_status` varchar(255) NULL DEFAULT NULL, `monthly_income` decimal(14,2) NOT NULL DEFAULT '0', `guarantor_name` varchar(255) NULL DEFAULT NULL, `guarantor_phone` varchar(255) NULL DEFAULT NULL, `guarantor_nid` varchar(255) NULL DEFAULT NULL, `supporting_documents` longtext NULL DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `admin_notes` longtext NULL DEFAULT NULL, `reviewed_by` bigint(20) UNSIGNED NULL DEFAULT NULL, `disbursed_at` timestamp NULL DEFAULT NULL, `closed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `refund_status` varchar(255) NOT NULL DEFAULT 'none', `refund_requested_at` timestamp NULL DEFAULT NULL, `refunded_at` timestamp NULL DEFAULT NULL, `refund_notes` longtext NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `loan_products` -- -------------------------------------------------------- DROP TABLE IF EXISTS `loan_products`; CREATE TABLE `loan_products` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `badge` varchar(255) NULL DEFAULT NULL, `min_amount` decimal(14,2) NOT NULL, `max_amount` decimal(14,2) NOT NULL, `interest_rate_percent` decimal(14,2) NOT NULL, `duration_months` bigint(20) UNSIGNED NOT NULL, `repayment_frequency` varchar(255) NOT NULL DEFAULT 'monthly', `collateral_required_percent` decimal(14,2) NOT NULL DEFAULT '10', `min_security_deposit` decimal(14,2) NOT NULL DEFAULT '0', `eligibility_notes` longtext NULL DEFAULT NULL, `terms` longtext NULL DEFAULT NULL, `is_active` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `loan_products` INSERT INTO `loan_products` (`id`, `name`, `code`, `badge`, `min_amount`, `max_amount`, `interest_rate_percent`, `duration_months`, `repayment_frequency`, `collateral_required_percent`, `min_security_deposit`, `eligibility_notes`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'Starter Micro Loan', 'TIER-01', 'Popular', '500', '5000', '4.5', '3', 'monthly', '0', '1000', 'Minimum ৳1,000 required in Loan Deposit Wallet.', 'Repay in 3 equal monthly installments with flexible terms.', '1', '2026-08-26 15:29:04', '2026-08-26 15:29:04'); INSERT INTO `loan_products` (`id`, `name`, `code`, `badge`, `min_amount`, `max_amount`, `interest_rate_percent`, `duration_months`, `repayment_frequency`, `collateral_required_percent`, `min_security_deposit`, `eligibility_notes`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('5', 'Growth Capital Loan', 'TIER-02', 'Fast Approval', '5000', '8000', '5', '6', 'monthly', '0', '2500', 'Minimum ৳2,500 required in Loan Deposit Wallet.', 'Repay in 6 equal monthly installments.', '1', '2026-08-26 15:29:05', '2026-08-26 15:29:05'); INSERT INTO `loan_products` (`id`, `name`, `code`, `badge`, `min_amount`, `max_amount`, `interest_rate_percent`, `duration_months`, `repayment_frequency`, `collateral_required_percent`, `min_security_deposit`, `eligibility_notes`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('6', 'Executive High-Limit Loan', 'TIER-03', 'High Limit', '8000', '15000', '6', '12', 'monthly', '0', '3500', 'Minimum ৳3,500 required in Loan Deposit Wallet.', 'Repay in 12 equal monthly installments.', '1', '2026-08-26 15:29:05', '2026-08-26 15:29:05'); INSERT INTO `loan_products` (`id`, `name`, `code`, `badge`, `min_amount`, `max_amount`, `interest_rate_percent`, `duration_months`, `repayment_frequency`, `collateral_required_percent`, `min_security_deposit`, `eligibility_notes`, `terms`, `is_active`, `created_at`, `updated_at`) VALUES ('11', 'Hello Boost', 'TIER-29', 'Popular', '150', '199', '8', '1', 'monthly', '10', '100', 'Minimum required balance in Loan Deposit Wallet.', NULL, '1', '2026-08-27 05:06:26', '2026-08-27 05:06:26'); -- -------------------------------------------------------- -- Table structure for table `loan_repayments` -- -------------------------------------------------------- DROP TABLE IF EXISTS `loan_repayments`; CREATE TABLE `loan_repayments` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `loan_application_id` bigint(20) UNSIGNED NOT NULL, `installment_number` bigint(20) UNSIGNED NOT NULL, `due_date` date NOT NULL, `amount_due` decimal(14,2) NOT NULL, `amount_paid` decimal(14,2) NOT NULL DEFAULT '0', `late_fee` decimal(14,2) NOT NULL DEFAULT '0', `status` varchar(255) NOT NULL DEFAULT 'pending', `payment_method` varchar(255) NULL DEFAULT NULL, `paid_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `merchant_tasks` -- -------------------------------------------------------- DROP TABLE IF EXISTS `merchant_tasks`; CREATE TABLE `merchant_tasks` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `merchant_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `task_category_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `task_code` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `description` longtext NOT NULL, `instructions` longtext NOT NULL, `target_url` varchar(255) NULL DEFAULT NULL, `proof_type` varchar(255) NOT NULL DEFAULT 'screenshot_and_text', `required_proof_details` longtext NOT NULL, `reward_per_user` decimal(14,2) NOT NULL, `total_slots` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `completed_slots` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `reserved_budget` decimal(14,2) NOT NULL DEFAULT '0', `status` varchar(255) NOT NULL DEFAULT 'active', `start_date` timestamp NULL DEFAULT NULL, `end_date` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `task_owner_type` varchar(255) NOT NULL DEFAULT 'merchant', `deadline` timestamp NULL DEFAULT NULL, `rejection_reason` longtext NULL DEFAULT NULL, `approved_by` bigint(20) UNSIGNED NULL DEFAULT NULL, `approved_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `merchants` -- -------------------------------------------------------- DROP TABLE IF EXISTS `merchants`; CREATE TABLE `merchants` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, `business_name` varchar(255) NOT NULL, `business_type` varchar(255) NULL DEFAULT NULL, `website` varchar(255) NULL DEFAULT NULL, `trade_license` varchar(255) NULL DEFAULT NULL, `logo` varchar(255) NULL DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `admin_notes` longtext NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `migrations` -- -------------------------------------------------------- DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` bigint(20) UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `migrations` INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('1', '0001_01_01_000000_create_users_table', '1'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('2', '0001_01_01_000001_create_cache_table', '1'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('3', '0001_01_01_000002_create_jobs_table', '1'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('4', '0001_01_01_000003_create_core_platform_tables', '1'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('5', '0001_01_01_000004_create_vip_ads_system_tables', '1'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('6', '0001_01_01_000005_create_activation_release_requests_table', '2'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('7', '0001_01_01_000006_add_refund_fields_to_loan_applications_table', '3'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('8', '2026_08_27_104500_create_email_verification_codes_table', '4'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('9', '2026_08_27_105000_add_free_plan_fields_to_vip_packages_table', '5'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('10', '2026_08_27_150000_add_activation_deposit_approved_at_to_users_table', '6'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('11', '2026_08_27_160000_make_merchant_tasks_support_admin_tasks_and_moderation', '7'); INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('12', '2026_08_27_170000_create_security_logs_table', '8'); -- -------------------------------------------------------- -- Table structure for table `notifications` -- -------------------------------------------------------- DROP TABLE IF EXISTS `notifications`; CREATE TABLE `notifications` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `message` longtext NOT NULL, `type` varchar(255) NOT NULL DEFAULT 'info', `link` varchar(255) NULL DEFAULT NULL, `is_read` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `notifications` INSERT INTO `notifications` (`id`, `user_id`, `title`, `message`, `type`, `link`, `is_read`, `created_at`, `updated_at`) VALUES ('6', '1', '🔔 New Account Activation Deposit (৳50)', 'User thfghfghfg submitted ৳50.00 for Account Activation Security Deposit via bKash Personal (TxID: cfgcvb).', 'info', '/admin/deposits', '0', '2026-08-28 09:56:50', '2026-08-28 09:56:50'); INSERT INTO `notifications` (`id`, `user_id`, `title`, `message`, `type`, `link`, `is_read`, `created_at`, `updated_at`) VALUES ('8', '1', '🔔 New Account Activation Deposit (৳50)', 'User thfghfghfg submitted ৳50.00 for Account Activation Security Deposit via bKash Personal (TxID: dgf).', 'info', '/admin/deposits', '0', '2026-08-28 09:59:20', '2026-08-28 09:59:20'); -- -------------------------------------------------------- -- Table structure for table `pages` -- -------------------------------------------------------- DROP TABLE IF EXISTS `pages`; CREATE TABLE `pages` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `content` longtext NOT NULL, `meta_title` varchar(255) NULL DEFAULT NULL, `meta_description` longtext NULL DEFAULT NULL, `is_active` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `pages` INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `is_active`, `created_at`, `updated_at`) VALUES ('1', 'Terms & Conditions', 'terms', '

1. Agreement to Terms

By accessing and using our platform, you agree to abide by all platform rules regarding task completion, merchant escrow security, and financial operations.

2. User Integrity

Duplicate accounts, automated bots, and falsified task proofs are strictly prohibited and result in immediate account restriction.

', 'Terms of Service - Felles', NULL, '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `is_active`, `created_at`, `updated_at`) VALUES ('2', 'Privacy Policy', 'privacy-policy', '

Privacy & Data Protection

We treat your personal data with bank-grade encryption and security. Your KYC documentation is stored securely and never shared with third-party advertising brokers.

', 'Privacy Policy - Felles', NULL, '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `is_active`, `created_at`, `updated_at`) VALUES ('3', 'Refund & Escrow Policy', 'refund-escrow-policy', '

Transparent Escrow & Refund Protection

All merchant campaign budgets are held in transparent cryptographic-style database escrow. If a campaign is cancelled or unused slots remain, 100% of the remaining escrow balance is refunded immediately.

Security deposits are fully refundable upon user request when no conflicting loan commitments exist.

', 'Refund & Escrow Policy - Felles', NULL, '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'Risk Disclosure', 'risk-disclosure', '

Responsible Platform Participation

Our micro-credit and investment reward plans are designed to promote transparent micro-economy participation. Users should borrow responsibly within their verifiable repayment capability.

', 'Risk Disclosure - Felles', NULL, '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); -- -------------------------------------------------------- -- Table structure for table `password_reset_tokens` -- -------------------------------------------------------- DROP TABLE IF EXISTS `password_reset_tokens`; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `payment_methods` -- -------------------------------------------------------- DROP TABLE IF EXISTS `payment_methods`; CREATE TABLE `payment_methods` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `type` varchar(255) NOT NULL DEFAULT 'mobile_money', `account_details` varchar(255) NOT NULL, `qr_code_image` varchar(255) NULL DEFAULT NULL, `min_deposit` decimal(14,2) NOT NULL DEFAULT '50', `max_deposit` decimal(14,2) NOT NULL DEFAULT '50000', `deposit_fee_percentage` decimal(14,2) NOT NULL DEFAULT '0', `min_withdraw` decimal(14,2) NOT NULL DEFAULT '100', `max_withdraw` decimal(14,2) NOT NULL DEFAULT '25000', `withdraw_fee_percentage` decimal(14,2) NOT NULL DEFAULT '1.5', `instructions` longtext NULL DEFAULT NULL, `is_active` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `payment_methods` INSERT INTO `payment_methods` (`id`, `name`, `code`, `type`, `account_details`, `qr_code_image`, `min_deposit`, `max_deposit`, `deposit_fee_percentage`, `min_withdraw`, `max_withdraw`, `withdraw_fee_percentage`, `instructions`, `is_active`, `created_at`, `updated_at`) VALUES ('6', 'bKash', 'bkash', 'mobile_money', '01700000000 (Personal)', NULL, '50', '50000', '0', '100', '30000', '0', 'Send money or withdraw directly to your bKash personal account.', '1', '2026-09-04 13:31:45', '2026-09-04 13:41:21'); INSERT INTO `payment_methods` (`id`, `name`, `code`, `type`, `account_details`, `qr_code_image`, `min_deposit`, `max_deposit`, `deposit_fee_percentage`, `min_withdraw`, `max_withdraw`, `withdraw_fee_percentage`, `instructions`, `is_active`, `created_at`, `updated_at`) VALUES ('7', 'Nagad', 'nagad', 'mobile_money', '01800000000 (Personal)', NULL, '50', '50000', '0', '100', '30000', '0', 'Send money or withdraw directly to your Nagad personal account.', '1', '2026-09-04 13:31:45', '2026-09-04 13:41:21'); INSERT INTO `payment_methods` (`id`, `name`, `code`, `type`, `account_details`, `qr_code_image`, `min_deposit`, `max_deposit`, `deposit_fee_percentage`, `min_withdraw`, `max_withdraw`, `withdraw_fee_percentage`, `instructions`, `is_active`, `created_at`, `updated_at`) VALUES ('8', 'Rocket', 'rocket', 'mobile_money', '01900000000 (Personal)', NULL, '50', '50000', '0', '100', '30000', '0', 'Send money or withdraw directly to your Rocket personal account (including 12th check digit).', '1', '2026-09-04 13:31:45', '2026-09-04 13:41:21'); INSERT INTO `payment_methods` (`id`, `name`, `code`, `type`, `account_details`, `qr_code_image`, `min_deposit`, `max_deposit`, `deposit_fee_percentage`, `min_withdraw`, `max_withdraw`, `withdraw_fee_percentage`, `instructions`, `is_active`, `created_at`, `updated_at`) VALUES ('9', 'Mobile Recharge', 'mobile_recharge', 'mobile_recharge', '{\"operator\":\"All Operators (GP, BL, Robi, Airtel, Teletalk)\",\"account_type\":\"Prepaid \\/ Postpaid\"}', NULL, '50', '1000', '0', '40', '300', '0', 'Instant Mobile Recharge / Flexiload to any Bangladeshi operator (40 - 300 TK).', '1', '2026-09-04 13:31:46', '2026-09-04 13:31:46'); INSERT INTO `payment_methods` (`id`, `name`, `code`, `type`, `account_details`, `qr_code_image`, `min_deposit`, `max_deposit`, `deposit_fee_percentage`, `min_withdraw`, `max_withdraw`, `withdraw_fee_percentage`, `instructions`, `is_active`, `created_at`, `updated_at`) VALUES ('10', 'Bank Transfer', 'bank_transfer', 'bank', '{\"bank_name\":\"Any Bangladeshi Commercial Bank\",\"account_type\":\"BEFTN \\/ NPSB \\/ RTGS\"}', NULL, '500', '500000', '0', '10000', '100000', '0', 'Direct EFT / NPSB Bank payout to any bank account in Bangladesh (10K - 100K TK).', '1', '2026-09-04 13:31:46', '2026-09-04 13:31:46'); -- -------------------------------------------------------- -- Table structure for table `referral_commissions` -- -------------------------------------------------------- DROP TABLE IF EXISTS `referral_commissions`; CREATE TABLE `referral_commissions` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `referrer_id` bigint(20) UNSIGNED NOT NULL, `referee_id` bigint(20) UNSIGNED NOT NULL, `source_type` varchar(255) NOT NULL, `source_id` varchar(255) NULL DEFAULT NULL, `commission_amount` decimal(14,2) NOT NULL, `percentage` decimal(14,2) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'credited', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `security_logs` -- -------------------------------------------------------- DROP TABLE IF EXISTS `security_logs`; CREATE TABLE `security_logs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `event_type` varchar(255) NOT NULL, `severity` varchar(255) NOT NULL DEFAULT 'info', `ip_address` varchar(255) NULL DEFAULT NULL, `user_agent` varchar(255) NULL DEFAULT NULL, `risk_score` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `action_summary` longtext NULL DEFAULT NULL, `details` longtext NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `security_logs` INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('1', NULL, 'signup_otp_dispatched', 'info', '127.0.0.1', 'Symfony', '0', 'Signup verification code dispatched to: clean_user_987@gmail.com', '[]', '2026-08-27 14:35:46', '2026-08-27 14:35:46'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('2', NULL, 'user_registered', 'info', '127.0.0.1', 'Symfony', '0', 'User successfully registered & verified: clean_user_987@gmail.com', '[]', '2026-08-27 14:35:46', '2026-08-27 14:35:46'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('3', '1', 'login_success', 'info', '127.0.0.1', 'Symfony', '0', 'User logged in successfully: admin@platform.com', '[]', '2026-08-27 15:56:47', '2026-08-27 15:56:47'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('4', '1', 'login_success', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User logged in successfully: admin@platform.com', '[]', '2026-08-28 09:44:30', '2026-08-28 09:44:30'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('5', NULL, 'signup_otp_dispatched', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', '0', 'Signup verification code dispatched to: fasale1952@mapsguy.com', '[]', '2026-08-28 09:47:19', '2026-08-28 09:47:19'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('6', NULL, 'user_registered', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', '0', 'User successfully registered & verified: fasale1952@mapsguy.com', '[]', '2026-08-28 09:47:39', '2026-08-28 09:47:39'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('7', NULL, 'signup_otp_dispatched', 'info', '127.0.0.1', 'Symfony', '0', 'Signup verification code dispatched to: verify_test_1787910548@example.com', '[]', '2026-08-28 09:49:13', '2026-08-28 09:49:13'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('8', NULL, 'user_registered', 'info', '127.0.0.1', 'Symfony', '0', 'User successfully registered & verified: verify_test_1787910548@example.com', '[]', '2026-08-28 09:49:16', '2026-08-28 09:49:16'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('9', NULL, 'login_success', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', '0', 'User logged in successfully: fasale1952@mapsguy.com', '[]', '2026-08-28 09:51:58', '2026-08-28 09:51:58'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('10', '1', 'user_logout', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User signed out: admin@platform.com', '[]', '2026-08-28 09:53:31', '2026-08-28 09:53:31'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('11', NULL, 'signup_otp_dispatched', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'Signup verification code dispatched to: 29c1be8693c2@westcast-systems.com', '[]', '2026-08-28 09:55:30', '2026-08-28 09:55:30'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('12', NULL, 'user_registered', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User successfully registered & verified: 29c1be8693c2@westcast-systems.com', '[]', '2026-08-28 09:55:59', '2026-08-28 09:55:59'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('13', NULL, 'user_logout', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User signed out: 29c1be8693c2@westcast-systems.com', '[]', '2026-08-28 09:57:43', '2026-08-28 09:57:43'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('14', '1', 'login_success', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User logged in successfully: admin@platform.com', '[]', '2026-08-28 09:57:56', '2026-08-28 09:57:56'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('15', '1', 'user_logout', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User signed out: admin@platform.com', '[]', '2026-08-28 09:58:46', '2026-08-28 09:58:46'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('16', NULL, 'login_success', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User logged in successfully: 29c1be8693c2@westcast-systems.com', '[]', '2026-08-28 09:58:57', '2026-08-28 09:58:57'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('17', NULL, 'user_logout', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User signed out: 29c1be8693c2@westcast-systems.com', '[]', '2026-08-28 09:59:30', '2026-08-28 09:59:30'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('18', '1', 'login_success', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User logged in successfully: admin@platform.com', '[]', '2026-08-28 09:59:45', '2026-08-28 09:59:45'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('19', NULL, 'referral_reward_paid', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'Referrer #52 (USR-RBYIHW) received ৳30 active referral reward for referee #54 (USR-MANAWC)', '[]', '2026-08-28 10:00:03', '2026-08-28 10:00:03'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('20', '1', 'user_logout', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User signed out: admin@platform.com', '[]', '2026-08-28 10:07:20', '2026-08-28 10:07:20'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('21', NULL, 'login_success', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', '0', 'User logged in successfully: 29c1be8693c2@westcast-systems.com', '[]', '2026-08-28 10:07:28', '2026-08-28 10:07:28'); INSERT INTO `security_logs` (`id`, `user_id`, `event_type`, `severity`, `ip_address`, `user_agent`, `risk_score`, `action_summary`, `details`, `created_at`, `updated_at`) VALUES ('22', '1', 'login_success', 'info', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36 Edg/152.0.0.0', '0', 'User logged in successfully: admin@platform.com', '[]', '2026-09-04 13:18:06', '2026-09-04 13:18:06'); -- -------------------------------------------------------- -- Table structure for table `sessions` -- -------------------------------------------------------- DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `ip_address` varchar(255) NULL DEFAULT NULL, `user_agent` longtext NULL DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` bigint(20) UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `sessions` INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('umn5Q213GtPUADy2eqbZyt9c9iS9JqNCPlT8zq4f', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidVFjakxIU1BNWEU4Unk2bUQ4RjI3cWJWemRDZkF3R01aQXBkb2lUciI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czozMzoiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2FkbWluL3VzZXJzIjtzOjU6InJvdXRlIjtzOjE3OiJhZG1pbi51c2Vycy5pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1787824353'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('DTIpslxqq5adv1BN2UdzBBhoJlPqzWk55SKgbYHv', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiYjhyVUxyQXM3S2tjR3d0OGQ2cFM1WTlpZ0Vjd21vUWtmR1dQTk5oViI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjM2OiJodHRwOi8vbG9jYWxob3N0OjgwMDAvYWRtaW4vZGVwb3NpdHMiO3M6NToicm91dGUiO3M6MjA6ImFkbWluLmRlcG9zaXRzLmluZGV4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', '1787825305'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('sH6y66Jv0sNSImDUk8D9phtIZwCU7dSEwHxQ82u9', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiN1VtZklIdTliQkt0Vno3QmFwSUhtQUg1dUhaV3JrQUl3a25MREs3bCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7czo1OiJyb3V0ZSI7czo1OiJsb2dpbiI7fXM6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zdXBwb3J0Ijt9fQ==', '1787826509'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('soFgKsYODLJUrvtww3iM6LupCubftue9pSObilfq', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6280', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkdLQ1pMZjBVbXZOZDc3UFlyMWo5OUNEWmZjREg2RkxraGc2bVdpTyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1787835975'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('Nw2hcioZFBe663Id8zeOGflJUyiLQWhWcWlpjaVc', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoibHVuSldhZHVaWHdmQW1FcUt2cDU5MFZERGx4a0VET0R2dE4yazUwViI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozMToiaHR0cDovL2xvY2FsaG9zdDo4MDAwL2Rhc2hib2FyZCI7fX0=', '1787840929'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('slYbBgDG0lNYiSAa926lLlL8N0J3Av7oxCpYL0lg', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZG1uZVB2c2Zvbzl4Y0pONkJpU0hGczZYdXlwTzI0MWtXUmpmTWpEZyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1787836165'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('AASCeAT3xkyfix4NvoAWkittMJI0qsaXYI4bqouJ', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibllacndmSTJIOTkxTkkwZFhIdmNnRGVrNWtCVTVWd0l0d0tweGcxdCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9sb2NhbGhvc3QiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1787840063'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('yOaMIkGXLyF5zB0QCsSgNUFn5dgzgP9y942Btwjg', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ0pqbUI5cG5KcWRRSjdYRWlTNFVqQ3d5a05zV0hldFJCd0tWenBFdCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9sb2NhbGhvc3QiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1787840140'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('z4469HDa5sbCxGbTiz7z61fJqh7ApU0drT65dwrU', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN0tDYXNiakFVRThhVjFZRUUwMUJTaURXNjRGSGVCcUt0c3VhalJ6TiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9sb2NhbGhvc3QiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1787840171'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('F1ZDx2jiNF2NfD4FSgmu5ueUvHrj9pYGHvKcvmEf', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWDk0OU9GY3N1VlZnY3Y1TloybDZWQnVVd2QwRVBockxQU1NaQ1QxMiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9sb2NhbGhvc3QiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1787840332'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('3Kojt9AMeDC3sXQp3gEsbGO5NCuQQjGOqMmHgRak', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6280', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRDhUNU5LaEQzcUF2VHUzUEhuRVFpTDR6RklHblRtamNpcHpSTTlzZyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1787840338'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('pEMMXCUDwZoFuzgk8S75OLl95Mo4Zs83mNZ44Ytc', '3', '127.0.0.1', 'Symfony', 'YTo0OntzOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTozO3M6NjoiX3Rva2VuIjtzOjQwOiJYRW82TlRJOHFhZjNtRVNhOGJOQzk4VEllSXdYekVtZTdmTEhjejRiIjtzOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czoxNjoiaHR0cDovL2xvY2FsaG9zdCI7czo1OiJyb3V0ZSI7czo0OiJob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1787840822'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('miv98zwpPK1Iq35uA9r3kNDmeHhq1l1yuMHenkCe', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNkZuWm9GODlEZWdFUzRtR0E4cFlHYWtFbmRBZHh3VkhHdzRCZVp3MyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9sb2NhbGhvc3QiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1787840831'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('DEflSE6qx0UvWTGiZRPsvNiLfnp1ngjGCdUCukBG', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkdxTzJaRVpSWHZhT2c3QTNuekxheUh1WDN5b09PU3BQYmxDUXd4SiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9sb2NhbGhvc3QiO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1787845530'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('yhaLiyWHVSXcPjY5RvQjAtsJDxjAiV4RfnoGVnwn', '1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoibmtNOVNockJHTXRhUGVKeUFDSUh4aDBmdmJYOFd3UlZpVXg2U2xscSI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjM2OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvYWRtaW4vc2V0dGluZ3MiO3M6NToicm91dGUiO3M6MjA6ImFkbWluLnNldHRpbmdzLmluZGV4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', '1787910371'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('9hKW0eN9dHrp9HJJqAC9Km93MZON02o66xP7QbPL', '52', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiWVloZTRPZG81djVqOTJTNE9mUEF2czJVUldpNmt5Um5rMmROMHBzeSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9yZWdpc3Rlci92ZXJpZnkiO3M6NToicm91dGUiO3M6MTk6InZlcmlmaWNhdGlvbi5ub3RpY2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YToxOntpOjA7czo3OiJzdWNjZXNzIjt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo1MjtzOjc6InN1Y2Nlc3MiO3M6NTU6IkVtYWlsIHZlcmlmaWVkIHN1Y2Nlc3NmdWxseSEgV2VsY29tZSB0byB5b3VyIGRhc2hib2FyZC4iO30=', '1787910460'); INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('utEABZEZlczIYy8zT05sdOgN2B0Z6Fj7QzuUZZtv', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoid2szR2Qwa0QySjNrc3BxTzBNeXBnVlI3bEJNa0NUaWkzcUMxanVDSiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1787910460'); -- -------------------------------------------------------- -- Table structure for table `settings` -- -------------------------------------------------------- DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `key` varchar(255) NOT NULL, `value` longtext NULL DEFAULT NULL, `group` varchar(255) NOT NULL DEFAULT 'general', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `settings` INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('1', 'site_name', 'Felles', 'general', '2026-08-26 11:06:47', '2026-08-27 05:32:38'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('2', 'support_email', 'support@felles.xyz', 'general', '2026-08-26 11:06:47', '2026-08-27 05:32:39'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('3', 'support_phone', '+880 1700-000000', 'general', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('4', 'currency_symbol', '৳', 'general', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('5', 'required_security_deposit', '50.00', 'general', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('6', 'referral_task_commission_percent', '10.00', 'general', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('7', 'announcement_banner', 'Welcome to Felles! Complete tasks, earn micro-rewards, and access instant micro-loans.', 'general', '2026-08-26 11:06:47', '2026-08-27 05:32:39'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('8', 'site_title', 'Felles - Micro-Jobs, Freelance Tasks, VIP Ads & Micro-Credit', 'seo', '2026-08-27 05:29:16', '2026-08-27 05:32:38'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('9', 'mail_from_name', 'Felles', 'smtp', '2026-08-27 05:29:16', '2026-08-27 05:32:39'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('10', 'mail_mailer', 'smtp', 'smtp', '2026-08-28 09:46:10', '2026-08-28 09:46:10'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('11', 'mail_host', 'dollarplaza.org', 'smtp', '2026-08-28 09:46:10', '2026-08-28 09:46:10'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('12', 'mail_port', '587', 'smtp', '2026-08-28 09:46:10', '2026-08-28 09:46:10'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('13', 'mail_username', 'noreply@dollarplaza.org', 'smtp', '2026-08-28 09:46:10', '2026-08-28 09:46:10'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('14', 'mail_password', '1.sh@2.s@z@', 'smtp', '2026-08-28 09:46:10', '2026-08-28 09:46:10'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('15', 'mail_encryption', 'tls', 'smtp', '2026-08-28 09:46:10', '2026-08-28 09:46:10'); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `created_at`, `updated_at`) VALUES ('16', 'mail_from_address', 'noreply@dollarplaza.org', 'smtp', '2026-08-28 09:46:11', '2026-08-28 09:46:11'); -- -------------------------------------------------------- -- Table structure for table `support_tickets` -- -------------------------------------------------------- DROP TABLE IF EXISTS `support_tickets`; CREATE TABLE `support_tickets` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `ticket_number` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `subject` varchar(255) NOT NULL, `category` varchar(255) NOT NULL DEFAULT 'General', `priority` varchar(255) NOT NULL DEFAULT 'normal', `status` varchar(255) NOT NULL DEFAULT 'open', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `task_categories` -- -------------------------------------------------------- DROP TABLE IF EXISTS `task_categories`; CREATE TABLE `task_categories` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `icon` varchar(255) NULL DEFAULT NULL, `description` longtext NULL DEFAULT NULL, `is_active` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `task_categories` INSERT INTO `task_categories` (`id`, `name`, `slug`, `icon`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('1', 'Social Media & Engagement', 'social-media', 'share-2', 'Follow pages, like posts, share content, and subscribe to channels.', '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `task_categories` (`id`, `name`, `slug`, `icon`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('2', 'App Testing & Downloads', 'app-testing', 'smartphone', 'Download mobile apps, test features, and leave authentic store reviews.', '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `task_categories` (`id`, `name`, `slug`, `icon`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('3', 'Website Visits & Signups', 'website-signups', 'globe', 'Visit partner sites, browse landing pages, or create free demo accounts.', '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `task_categories` (`id`, `name`, `slug`, `icon`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('4', 'Feedback & Surveys', 'surveys-feedback', 'clipboard-check', 'Participate in consumer research and product feedback polls.', '1', '2026-08-26 11:06:47', '2026-08-26 11:06:47'); INSERT INTO `task_categories` (`id`, `name`, `slug`, `icon`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('5', 'App Download', 'app-download', 'fa-download', NULL, '1', '2026-08-27 09:29:04', '2026-08-27 09:29:04'); INSERT INTO `task_categories` (`id`, `name`, `slug`, `icon`, `description`, `is_active`, `created_at`, `updated_at`) VALUES ('6', 'YouTube Tasks', 'youtube-tasks', 'fa-youtube', NULL, '1', '2026-08-27 09:43:07', '2026-08-27 09:43:07'); -- -------------------------------------------------------- -- Table structure for table `task_submissions` -- -------------------------------------------------------- DROP TABLE IF EXISTS `task_submissions`; CREATE TABLE `task_submissions` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `submission_code` varchar(255) NOT NULL, `merchant_task_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `proof_text` longtext NULL DEFAULT NULL, `proof_url` varchar(255) NULL DEFAULT NULL, `proof_file` varchar(255) NULL DEFAULT NULL, `reward_amount` decimal(14,2) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'submitted', `rejection_reason` longtext NULL DEFAULT NULL, `reviewed_by` bigint(20) UNSIGNED NULL DEFAULT NULL, `reviewed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `ticket_messages` -- -------------------------------------------------------- DROP TABLE IF EXISTS `ticket_messages`; CREATE TABLE `ticket_messages` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `support_ticket_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `message` longtext NOT NULL, `attachment` varchar(255) NULL DEFAULT NULL, `is_admin_reply` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `user_investments` -- -------------------------------------------------------- DROP TABLE IF EXISTS `user_investments`; CREATE TABLE `user_investments` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `investment_code` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `investment_plan_id` bigint(20) UNSIGNED NOT NULL, `invested_amount` decimal(14,2) NOT NULL, `total_expected_return` decimal(14,2) NOT NULL, `total_earned` decimal(14,2) NOT NULL DEFAULT '0', `next_payout_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `user_investments` INSERT INTO `user_investments` (`id`, `investment_code`, `user_id`, `investment_plan_id`, `invested_amount`, `total_expected_return`, `total_earned`, `next_payout_at`, `expires_at`, `status`, `created_at`, `updated_at`) VALUES ('1', 'INV-SWPYSWC2', '1', '1', '1000', '1035', '0', '2026-08-28 05:55:47', '2026-09-03 05:55:47', 'active', '2026-08-27 05:55:47', '2026-08-27 05:55:47'); -- -------------------------------------------------------- -- Table structure for table `user_profiles` -- -------------------------------------------------------- DROP TABLE IF EXISTS `user_profiles`; CREATE TABLE `user_profiles` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, `date_of_birth` date NULL DEFAULT NULL, `gender` varchar(255) NULL DEFAULT NULL, `address` varchar(255) NULL DEFAULT NULL, `city` varchar(255) NULL DEFAULT NULL, `country` varchar(255) NOT NULL DEFAULT 'Bangladesh', `nid_passport_number` varchar(255) NULL DEFAULT NULL, `emergency_contact` varchar(255) NULL DEFAULT NULL, `bio` longtext NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `user_profiles` INSERT INTO `user_profiles` (`id`, `user_id`, `date_of_birth`, `gender`, `address`, `city`, `country`, `nid_passport_number`, `emergency_contact`, `bio`, `created_at`, `updated_at`) VALUES ('1', '1', NULL, NULL, NULL, 'Dhaka', 'Bangladesh', NULL, NULL, NULL, '2026-08-26 11:06:48', '2026-08-26 11:06:48'); -- -------------------------------------------------------- -- Table structure for table `user_vip_subscriptions` -- -------------------------------------------------------- DROP TABLE IF EXISTS `user_vip_subscriptions`; CREATE TABLE `user_vip_subscriptions` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, `vip_package_id` bigint(20) UNSIGNED NOT NULL, `price_paid` decimal(14,2) NOT NULL, `starts_at` timestamp NOT NULL, `expires_at` timestamp NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- Table structure for table `users` -- -------------------------------------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_code` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NULL DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `phone_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `role` varchar(255) NOT NULL DEFAULT 'user', `status` varchar(255) NOT NULL DEFAULT 'active', `referral_code` varchar(255) NOT NULL, `referred_by` bigint(20) UNSIGNED NULL DEFAULT NULL, `two_factor_enabled` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `two_factor_secret` varchar(255) NULL DEFAULT NULL, `avatar` varchar(255) NULL DEFAULT NULL, `security_deposit_paid` bigint(20) UNSIGNED NOT NULL DEFAULT '0', `last_login_at` timestamp NULL DEFAULT NULL, `last_login_ip` varchar(255) NULL DEFAULT NULL, `remember_token` varchar(255) NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `activation_deposit_approved_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `users` INSERT INTO `users` (`id`, `user_code`, `name`, `email`, `phone`, `email_verified_at`, `phone_verified_at`, `password`, `role`, `status`, `referral_code`, `referred_by`, `two_factor_enabled`, `two_factor_secret`, `avatar`, `security_deposit_paid`, `last_login_at`, `last_login_ip`, `remember_token`, `created_at`, `updated_at`, `activation_deposit_approved_at`) VALUES ('1', 'ADM-00101', 'Platform Administrator', 'admin@platform.com', '01700000001', NULL, NULL, '$2y$12$ilqYXkMfw9CmW2FRShc8ROEXv98SmyzsCbR3H0tysiB5m5MDMRSYO', 'admin', 'active', 'ADMINVIP', NULL, '0', NULL, NULL, '1', '2026-09-04 13:18:06', '127.0.0.1', 'Cy76Yf2doYtyxXMaCijXoznQW8ScfCeNgAeETDtix9GlC7dSAwUZ6t5HTDa2', '2026-08-26 11:06:48', '2026-09-04 13:18:06', NULL); -- -------------------------------------------------------- -- Table structure for table `vip_packages` -- -------------------------------------------------------- DROP TABLE IF EXISTS `vip_packages`; CREATE TABLE `vip_packages` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `badge_color` varchar(255) NOT NULL DEFAULT 'emerald', `price` decimal(14,2) NOT NULL, `validity_days` bigint(20) UNSIGNED NOT NULL DEFAULT '30', `daily_ad_limit` bigint(20) UNSIGNED NOT NULL DEFAULT '15', `ad_reward_multiplier` decimal(14,2) NOT NULL DEFAULT '1', `description` longtext NULL DEFAULT NULL, `is_active` bigint(20) UNSIGNED NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `reward_per_ad` decimal(14,2) NOT NULL DEFAULT '1.5', `plan_type` varchar(255) NOT NULL DEFAULT 'vip', `sort_order` bigint(20) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `vip_packages` INSERT INTO `vip_packages` (`id`, `name`, `slug`, `badge_color`, `price`, `validity_days`, `daily_ad_limit`, `ad_reward_multiplier`, `description`, `is_active`, `created_at`, `updated_at`, `reward_per_ad`, `plan_type`, `sort_order`) VALUES ('1', 'Bronze VIP', 'bronze-vip', 'amber', '300', '30', '10', '1', 'Starter VIP membership with 10 daily ad views.', '1', '2026-08-26 11:06:49', '2026-08-26 11:06:49', '1.5', 'vip', '0'); INSERT INTO `vip_packages` (`id`, `name`, `slug`, `badge_color`, `price`, `validity_days`, `daily_ad_limit`, `ad_reward_multiplier`, `description`, `is_active`, `created_at`, `updated_at`, `reward_per_ad`, `plan_type`, `sort_order`) VALUES ('2', 'Silver VIP Tier', 'silver-vip', 'cyan', '200', '30', '10', '1.25', 'Watch 10 ads daily and earn ৳2.00 per ad. Valid for 30 days.', '1', '2026-08-26 11:06:49', '2026-08-27 04:47:27', '2', 'vip', '2'); INSERT INTO `vip_packages` (`id`, `name`, `slug`, `badge_color`, `price`, `validity_days`, `daily_ad_limit`, `ad_reward_multiplier`, `description`, `is_active`, `created_at`, `updated_at`, `reward_per_ad`, `plan_type`, `sort_order`) VALUES ('3', 'Gold VIP Tier', 'gold-vip', 'amber', '500', '30', '25', '1.5', 'Watch 25 ads daily and earn ৳2.50 per ad. Valid for 30 days.', '1', '2026-08-26 11:06:50', '2026-08-27 04:47:27', '2.5', 'vip', '3'); INSERT INTO `vip_packages` (`id`, `name`, `slug`, `badge_color`, `price`, `validity_days`, `daily_ad_limit`, `ad_reward_multiplier`, `description`, `is_active`, `created_at`, `updated_at`, `reward_per_ad`, `plan_type`, `sort_order`) VALUES ('4', 'Diamond VIP', 'diamond-vip', 'emerald', '2500', '60', '50', '2', 'Ultimate 60-day VIP pass with 50 daily ads and 2.00x double rewards.', '1', '2026-08-26 11:06:50', '2026-08-26 11:06:50', '1.5', 'vip', '0'); INSERT INTO `vip_packages` (`id`, `name`, `slug`, `badge_color`, `price`, `validity_days`, `daily_ad_limit`, `ad_reward_multiplier`, `description`, `is_active`, `created_at`, `updated_at`, `reward_per_ad`, `plan_type`, `sort_order`) VALUES ('5', 'Free Plan', 'free-plan', 'emerald', '0', '30', '1', '1', 'Watch 1 advertisement daily and earn ৳1.50 per ad. Valid for 30 days.', '1', '2026-08-27 04:47:27', '2026-08-27 04:49:49', '1.5', 'free', '1'); INSERT INTO `vip_packages` (`id`, `name`, `slug`, `badge_color`, `price`, `validity_days`, `daily_ad_limit`, `ad_reward_multiplier`, `description`, `is_active`, `created_at`, `updated_at`, `reward_per_ad`, `plan_type`, `sort_order`) VALUES ('6', 'Platinum VIP Tier', 'platinum-vip-tier-velr', 'purple', '1200', '45', '30', '1.5', 'Watch 30 ads daily and earn ৳2.50 per ad.', '1', '2026-08-27 05:02:26', '2026-08-27 05:02:26', '2.5', 'vip', '4'); INSERT INTO `vip_packages` (`id`, `name`, `slug`, `badge_color`, `price`, `validity_days`, `daily_ad_limit`, `ad_reward_multiplier`, `description`, `is_active`, `created_at`, `updated_at`, `reward_per_ad`, `plan_type`, `sort_order`) VALUES ('7', 'Platinum VIP Tier', 'platinum-vip-tier-1a3b', 'purple', '1200', '45', '30', '1.5', 'Watch 30 ads daily and earn ৳2.50 per ad.', '1', '2026-08-27 05:03:44', '2026-08-27 05:03:44', '2.5', 'vip', '4'); INSERT INTO `vip_packages` (`id`, `name`, `slug`, `badge_color`, `price`, `validity_days`, `daily_ad_limit`, `ad_reward_multiplier`, `description`, `is_active`, `created_at`, `updated_at`, `reward_per_ad`, `plan_type`, `sort_order`) VALUES ('8', 'Platinum VIP Tier', 'platinum-vip-tier-bpoj', 'purple', '1200', '45', '30', '1.5', 'Watch 30 ads daily and earn ৳2.50 per ad.', '1', '2026-08-27 05:03:55', '2026-08-27 05:03:55', '2.5', 'vip', '4'); -- -------------------------------------------------------- -- Table structure for table `wallets` -- -------------------------------------------------------- DROP TABLE IF EXISTS `wallets`; CREATE TABLE `wallets` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, `wallet_type` varchar(255) NOT NULL, `balance` decimal(14,2) NOT NULL DEFAULT '0', `locked_balance` decimal(14,2) NOT NULL DEFAULT '0', `pending_balance` decimal(14,2) NOT NULL DEFAULT '0', `currency` varchar(255) NOT NULL DEFAULT 'BDT', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table `wallets` INSERT INTO `wallets` (`id`, `user_id`, `wallet_type`, `balance`, `locked_balance`, `pending_balance`, `currency`, `created_at`, `updated_at`) VALUES ('1', '1', 'main', '4000', '0', '0', 'BDT', '2026-08-26 11:06:48', '2026-08-27 05:55:47'); INSERT INTO `wallets` (`id`, `user_id`, `wallet_type`, `balance`, `locked_balance`, `pending_balance`, `currency`, `created_at`, `updated_at`) VALUES ('2', '1', 'security_deposit', '0', '0', '0', 'BDT', '2026-08-26 11:06:48', '2026-08-26 11:06:48'); INSERT INTO `wallets` (`id`, `user_id`, `wallet_type`, `balance`, `locked_balance`, `pending_balance`, `currency`, `created_at`, `updated_at`) VALUES ('28', '1', 'loan_deposit', '0', '0', '0', 'BDT', '2026-08-27 05:04:08', '2026-08-27 05:04:08'); INSERT INTO `wallets` (`id`, `user_id`, `wallet_type`, `balance`, `locked_balance`, `pending_balance`, `currency`, `created_at`, `updated_at`) VALUES ('155', '1', 'merchant_available', '0', '0', '0', 'BDT', '2026-09-04 13:26:24', '2026-09-04 13:26:24'); -- -------------------------------------------------------- -- Table structure for table `withdrawals` -- -------------------------------------------------------- DROP TABLE IF EXISTS `withdrawals`; CREATE TABLE `withdrawals` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `withdrawal_number` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `payment_method_id` bigint(20) UNSIGNED NOT NULL, `wallet_type` varchar(255) NOT NULL DEFAULT 'main', `amount` decimal(14,2) NOT NULL, `fee` decimal(14,2) NOT NULL DEFAULT '0', `payable_amount` decimal(14,2) NOT NULL, `account_number` varchar(255) NOT NULL, `account_name` varchar(255) NULL DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `admin_notes` longtext NULL DEFAULT NULL, `processed_by` bigint(20) UNSIGNED NULL DEFAULT NULL, `processed_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; SET FOREIGN_KEY_CHECKS = 1; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;