Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
.well-known	[ DIR ]	drwxr-xr-x	2025-09-15 16:52
DB	[ DIR ]	drwxr-xr-x	2024-01-26 18:47
Documentation	[ DIR ]	drwxr-xr-x	2025-08-31 15:59
Documentation.1	[ DIR ]	drwxr-xr-x	2025-10-30 18:23
FASTEARNADS	[ DIR ]	drwxr-xr-x	2025-09-15 19:14
Files	[ DIR ]	drwxr-xr-x	2025-10-30 18:23
admin	[ DIR ]	drwxr-xr-x	2025-10-18 00:49
admin.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
admin.2	[ DIR ]	drwxr-xr-x	2025-10-18 21:54
app	[ DIR ]	drwxr-xr-x	2025-09-15 01:54
asset	[ DIR ]	drwxr-xr-x	2024-01-15 11:35
assets	[ DIR ]	drwxr--r--	2025-10-18 01:49
assets.1	[ DIR ]	drwxr--r--	2025-10-18 02:06
assets.2	[ DIR ]	drwxr-xr-x	2025-10-17 23:09
assets.3	[ DIR ]	drwxr--r--	2025-10-18 02:13
assets.4	[ DIR ]	drwxr-xr-x	2025-10-18 21:42
bootstrap	[ DIR ]	drwxr-xr-x	2025-09-15 21:09
cgi-bin	[ DIR ]	drwxr-xr-x	2025-08-31 15:33
cgi-bin.1	[ DIR ]	drwxr-xr-x	2025-11-14 14:25
cgi-bin.2	[ DIR ]	drwxr-xr-x	2026-03-06 11:21
core	[ DIR ]	drwxr-xr-x	2025-11-21 11:34
core.1	[ DIR ]	drwxr-xr-x	2025-11-21 15:51
data sycho	[ DIR ]	drwxr-xr-x	2026-03-18 10:25
database	[ DIR ]	drwxr-xr-x	2025-09-15 01:47
db	[ DIR ]	drwxr-xr-x	2025-10-17 23:00
db.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
debug.php	[ DIR ]	drwxr-xr-x	2026-03-13 16:15
deployment_package	[ DIR ]	drwxr-xr-x	2025-10-18 02:05
deployment_package.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
earnonline	[ DIR ]	drwxr-xr-x	2025-10-18 17:55
includes	[ DIR ]	drwxr-xr-x	2025-10-17 21:12
includes.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
includes.2	[ DIR ]	drwxr-xr-x	2025-10-18 21:40
loading	[ DIR ]	drwxr-xr-x	2025-01-23 07:37
public	[ DIR ]	drwxr-xr-x	2025-09-15 19:19
resources	[ DIR ]	drwxr-xr-x	2025-09-15 01:28
routes	[ DIR ]	drwxr-xr-x	2025-09-15 21:08
serive	[ DIR ]	drwxr-xr-x	2024-10-22 19:23
shearearn	[ DIR ]	drwxr-xr-x	2025-10-17 21:12
storage	[ DIR ]	drwxr-xr-x	2025-09-15 01:56
uploads	[ DIR ]	drwxr--r--	2025-10-18 01:49
uploads.1	[ DIR ]	drwxr--r--	2025-10-18 02:06
uploads.2	[ DIR ]	drwxr-xr-x	2025-10-17 23:08
uploads.3	[ DIR ]	drwxr--r--	2025-10-18 02:13
user	[ DIR ]	drwxr-xr-x	2025-10-17 23:42
user.1	[ DIR ]	drwxr-xr-x	2025-10-17 21:15
user.2	[ DIR ]	drwxr-xr-x	2025-10-18 22:14
vendor	[ DIR ]	drwxr-xr-x	2025-09-15 01:53
.env	1.2 KB	-rw-r--r--	2025-09-15 19:24
.env.example	1.19 KB	-rw-r--r--	2025-09-15 01:27
.htaccess	281 B	-rw-r--r--	2025-09-15 16:51
.htaccess.1	1.08 KB	-rw-r--r--	2025-10-18 21:45
.htaccess.2	913 B	-rw-r--r--	2023-12-27 04:45
.htaccess.3	281 B	-rw-r--r--	2025-12-23 09:40
.htaccess.4	1.38 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.5	812 B	-rw-r--r--	2025-12-23 09:40
.htaccess.6	281 B	-rw-r--r--	2026-02-22 15:25
.htaccess.7	5.15 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.8	1.02 KB	-rw-r--r--	2025-12-23 09:40
.htaccess.9	281 B	-rw-r--r--	2025-12-23 09:40
.trash_restore	11.24 KB	-rw-------	2026-03-30 15:07
.well-known_2.zip	66.1 MB	-rw-r--r--	2025-07-10 15:10
.well-known_3.zip	69.98 MB	-rw-r--r--	2025-07-18 07:02
6clube by Tha_perfect_provider (1).zip	67.84 MB	-rw-r--r--	2025-11-21 12:25
DEPLOYMENT_INSTRUCTIONS.md	3.05 KB	-rw-r--r--	2025-10-18 01:48
FASTEARNADS.zip	26.04 MB	-rw-r--r--	2025-09-15 19:10
FIX_DUPLICATE_COMMISSIONS.md	3.63 KB	-rw-r--r--	2025-10-18 00:32
FIX_DUPLICATE_COMMISSIONS.md.1	3.63 KB	-rw-r--r--	2025-10-18 00:32
FIX_USER_EDIT_ISSUE.md	6.15 KB	-rw-r--r--	2025-10-18 00:44
FIX_USER_EDIT_ISSUE.md.1	6.15 KB	-rw-r--r--	2025-10-18 00:44
Hyipe rio_2.zip	56.84 MB	-rw-r--r--	2025-08-31 15:56
IMPROVEMENTS_SUMMARY.md	4.11 KB	-rw-r--r--	2025-10-18 00:40
IMPROVEMENTS_SUMMARY.md.1	4.11 KB	-rw-r--r--	2025-10-18 00:40
MRby91club.sql	32.58 MB	-rw-r--r--	2025-11-09 05:09
MRby91club.zip	58.89 MB	-rw-r--r--	2025-11-09 05:09
PropLab v1.0 Nulled.zip	67.55 MB	-rw-r--r--	2025-11-21 11:36
README.md	6.77 KB	-rw-r--r--	2025-09-15 01:24
README.md.1	3.01 KB	-rw-r--r--	2025-10-18 21:46
README.txt	2.34 KB	-rw-r--r--	2025-10-17 23:08
README.txt.1	2.34 KB	-rw-r--r--	2025-10-17 23:08
README_DEPLOYMENT.txt	1.74 KB	-rw-r--r--	2025-10-18 01:49
README_REFERRAL_COMMISSIONS.md	4.02 KB	-rw-r--r--	2025-10-18 00:22
README_REFERRAL_COMMISSIONS.md.1	4.02 KB	-rw-r--r--	2025-10-18 00:22
SQL_CHANGES_SUMMARY.md	2.02 KB	-rw-r--r--	2025-10-18 00:25
SQL_CHANGES_SUMMARY.md.1	2.02 KB	-rw-r--r--	2025-10-18 00:25
Vinance-Digital-Trading-Platform-V2.7[www.shop.softbdteam.com].zip	39.3 MB	-rw-r--r--	2025-11-28 16:01
apply_database_fixes.php	5.17 KB	-rw-r--r--	2025-10-18 00:39
apply_database_fixes.php.1	5.17 KB	-rw-r--r--	2025-10-18 00:39
artisan	1.7 KB	-rw-r--r--	2025-09-15 01:54
check_commission_levels.php	3.16 KB	-rw-r--r--	2025-10-18 00:53
check_commission_levels.php.1	3.16 KB	-rw-r--r--	2025-10-18 00:53
check_database_structure.php	3.9 KB	-rw-r--r--	2025-10-18 00:55
check_database_structure.php.1	3.9 KB	-rw-r--r--	2025-10-18 00:55
check_duplicate_commissions.php	4.38 KB	-rw-r--r--	2025-10-18 00:32
check_duplicate_commissions.php.1	4.38 KB	-rw-r--r--	2025-10-18 00:32
check_referrals_table.php	2.28 KB	-rw-r--r--	2025-10-18 00:39
check_referrals_table.php.1	2.28 KB	-rw-r--r--	2025-10-18 00:39
complete_setup.sql	5.34 KB	-rw-r--r--	2025-10-18 00:25
complete_setup.sql.1	5.34 KB	-rw-r--r--	2025-10-18 00:25
complete_setup_for_import.sql	5.36 KB	-rw-r--r--	2025-10-18 01:59
complete_setup_for_import.sql.1	5.36 KB	-rw-r--r--	2025-10-18 01:59
composer.json	1.83 KB	-rw-r--r--	2025-09-15 01:27
composer.lock	294.45 KB	-rw-r--r--	2025-09-15 01:52
config.php	2.63 KB	-rw-r--r--	2025-10-18 17:56
crazydeveloperbd_auto-ptc.sql	320.06 KB	-rw-r--r--	2025-02-03 11:56
crazydeveloperbd_auto-ptc.sql.1	320.06 KB	-rw-r--r--	2025-02-03 11:56
create_table_direct.php	3.44 KB	-rw-r--r--	2025-10-18 00:09
create_table_direct.php.1	3.44 KB	-rw-r--r--	2025-10-18 00:09
css_test.php	999 B	-rw-r--r--	2025-10-18 02:06
data sycho.1	0 B	-rw-r--r--	2026-03-18 10:25
database.sql	13.77 KB	-rw-r--r--	2025-10-18 22:24
debug_referral_chain.php	6.88 KB	-rw-r--r--	2025-10-18 00:54
debug_referral_chain.php.1	6.88 KB	-rw-r--r--	2025-10-18 00:54
demo-enhanced.html	45.46 KB	-rw-r--r--	2025-09-15 01:43
earnonline.zip	88.67 KB	-rw-r--r--	2025-10-18 17:55
error.php	3.84 KB	-rw-r--r--	2025-10-18 21:45
error_log	488 B	-rw-r--r--	2025-07-04 21:02
error_log.1	37.29 KB	-rw-r--r--	2025-11-21 16:03
favicon.png	2.71 KB	-rw-r--r--	2025-06-07 20:15
favicon.png.1	6.62 KB	-rw-r--r--	2022-08-31 22:45
favicon.png.2	50.48 KB	-rw-r--r--	2025-07-18 10:14
favicon.png.3	2.21 KB	-rw-r--r--	2025-07-18 10:19
fix_css_paths.bat	1.85 KB	-rw-r--r--	2025-10-18 02:06
fix_duplicate_commissions.php	2.67 KB	-rw-r--r--	2025-10-18 00:31
fix_duplicate_commissions.php.1	2.67 KB	-rw-r--r--	2025-10-18 00:31
fix_referral_commissions.sql	677 B	-rw-r--r--	2025-10-18 00:25
fix_referral_commissions.sql.1	677 B	-rw-r--r--	2025-10-18 00:25
fix_referral_commissions_for_import.sql	705 B	-rw-r--r--	2025-10-18 01:59
fix_referral_commissions_for_import.sql.1	705 B	-rw-r--r--	2025-10-18 01:59
index-8df9a8d8.js	1.09 MB	-rw-r--r--	2026-03-18 15:16
index.php	25.73 KB	-rw-r--r--	2025-10-18 01:40
index.php.1	26.17 KB	-rw-r--r--	2025-10-18 02:11
index.php.2	23.31 KB	-rw-r--r--	2025-10-18 22:32
index.php.3	1.77 KB	-rw-r--r--	2023-12-27 04:45
index.php.backup	25.74 KB	-rw-r--r--	2025-10-18 02:05
index_professional.php	26.17 KB	-rw-r--r--	2025-10-18 02:12
index_with_css_fix.php	25.82 KB	-rw-r--r--	2025-10-18 02:06
login.php	4.14 KB	-rw-r--r--	2025-10-17 23:09
login.php.1	4.15 KB	-rw-r--r--	2025-10-18 02:12
logo.png	18.18 KB	-rw-r--r--	2025-06-07 20:15
logo.png.1	46.68 KB	-rw-r--r--	2025-07-18 10:12
logo.png.2	46.68 KB	-rw-r--r--	2025-07-18 10:11
logo.png.3	920.77 KB	-rw-r--r--	2023-07-01 15:03
logout.php	88 B	-rw-r--r--	2025-10-17 23:02
logout.php.1	88 B	-rw-r--r--	2025-10-17 23:02
mailer.php	10.16 KB	-rw-r--r--	2026-03-30 14:45
mobile-demo.html	23.36 KB	-rw-r--r--	2025-09-15 01:32
register.php	6.57 KB	-rw-r--r--	2025-10-17 23:09
register.php.1	6.58 KB	-rw-r--r--	2025-10-18 02:12
run_setup.bat	714 B	-rw-r--r--	2025-10-18 00:23
run_setup.bat.1	714 B	-rw-r--r--	2025-10-18 00:23
servertime.php	128 B	-rw-r--r--	2024-09-27 12:16
setup_referral_commissions.php	2.73 KB	-rw-r--r--	2025-10-18 00:21
setup_referral_commissions.php.1	2.73 KB	-rw-r--r--	2025-10-18 00:21
shearearn.zip	3.2 MB	-rw-r--r--	2025-10-17 21:11
test.html	203 B	-rw-r--r--	2025-10-17 23:16
test.php	59 B	-rw-r--r--	2025-10-17 23:16
test.php.1	59 B	-rw-r--r--	2025-10-17 23:16
test_commission_application.php	6.93 KB	-rw-r--r--	2025-10-18 00:55
test_commission_application.php.1	6.93 KB	-rw-r--r--	2025-10-18 00:55
test_commission_display.php	3.26 KB	-rw-r--r--	2025-10-18 00:19
test_commission_display.php.1	3.26 KB	-rw-r--r--	2025-10-18 00:19
test_commission_fix.php	3.16 KB	-rw-r--r--	2025-10-18 00:39
test_commission_fix.php.1	3.16 KB	-rw-r--r--	2025-10-18 00:39
test_mobile_menu.php	2.73 KB	-rw-r--r--	2025-10-18 01:24
test_mobile_menu.php.1	2.73 KB	-rw-r--r--	2025-10-18 01:24
test_referral.php	2.07 KB	-rw-r--r--	2025-10-17 23:55
test_referral.php.1	2.07 KB	-rw-r--r--	2025-10-17 23:55
tradex (1).sql	189.14 KB	-rw-r--r--	2025-11-21 15:51
update_referral_commissions.sql	682 B	-rw-r--r--	2025-10-18 00:25
update_referral_commissions.sql.1	682 B	-rw-r--r--	2025-10-18 00:25
update_referral_commissions_for_import.sql	710 B	-rw-r--r--	2025-10-18 01:59
update_referral_commissions_for_import.sql.1	710 B	-rw-r--r--	2025-10-18 01:59
update_referrals_table.sql	398 B	-rw-r--r--	2025-10-18 00:31
update_referrals_table.sql.1	398 B	-rw-r--r--	2025-10-18 00:31
update_referrals_table_for_import.sql	426 B	-rw-r--r--	2025-10-18 01:59
update_referrals_table_for_import.sql.1	426 B	-rw-r--r--	2025-10-18 01:59
verify-code.php	8.79 KB	-rw-r--r--	2026-03-30 14:55
verify_commissions.php	3.28 KB	-rw-r--r--	2025-10-18 00:20
verify_commissions.php.1	3.28 KB	-rw-r--r--	2025-10-18 00:20
verify_commissions_working.php	8.2 KB	-rw-r--r--	2025-10-18 00:56
verify_commissions_working.php.1	8.2 KB	-rw-r--r--	2025-10-18 00:56
website_deployment_package.zip	648.91 KB	-rw-r--r--	2025-10-18 01:49
website_deployment_package_final.zip	657.48 KB	-rw-r--r--	2025-10-18 02:06
website_deployment_package_professional.zip	667.46 KB	-rw-r--r--	2025-10-17 21:14
website_deployment_package_updated.zip	653.07 KB	-rw-r--r--	2025-10-18 01:59

Rename

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Oct 18, 2025 at 10:00 AM
-- Server version: 8.0.30
-- PHP Version: 8.1.10

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

--
-- Database: `earnonline_db`
--
CREATE DATABASE IF NOT EXISTS `earnonline_db` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `earnonline_db`;

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

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

CREATE TABLE `users` (
  `id` int NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `referral_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_by` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `join_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `current_plan` int DEFAULT NULL,
  `status` enum('active','inactive','suspended') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `plans` (
  `id` int NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `duration` int NOT NULL COMMENT 'In days',
  `daily_ads` int NOT NULL,
  `per_ad_earning` decimal(10,2) NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `deposits` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `method` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','approved','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `dpins`
--

CREATE TABLE `dpins` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `pin_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` enum('pending','active','used','expired') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `activated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `withdrawals` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `method` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` int NOT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_link` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timer` int NOT NULL COMMENT 'In seconds',
  `earning` decimal(10,2) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ads_completed`
--

CREATE TABLE `ads_completed` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `ad_id` int NOT NULL,
  `earning` decimal(10,2) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referral_commissions`
--

CREATE TABLE `referral_commissions` (
  `id` int NOT NULL,
  `from_user` int NOT NULL,
  `to_user` int NOT NULL,
  `level` int NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `transactions` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `type` enum('deposit','withdrawal','pin_purchase','ad_earning','referral') COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','completed','failed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `description` text COLLATE utf8mb4_unicode_ci,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `notifications` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('info','success','warning','error') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'info',
  `seen` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `deposit_methods`
--

CREATE TABLE `deposit_methods` (
  `id` int NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` int NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minimum_amount` decimal(10,2) NOT NULL,
  `processing_time` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referral_settings`
--

CREATE TABLE `referral_settings` (
  `id` int NOT NULL,
  `level` int NOT NULL,
  `percentage` decimal(5,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `name`, `value`) VALUES
(1, 'dpin_price', '100');

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int NOT NULL,
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`, `email`) VALUES
(1, 'admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin@example.com');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `referral_code` (`referral_code`);

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

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

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

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

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

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

--
-- Indexes for table `referral_commissions`
--
ALTER TABLE `referral_commissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `from_user` (`from_user`),
  ADD KEY `to_user` (`to_user`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dpins`
--
ALTER TABLE `dpins`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ads`
--
ALTER TABLE `ads`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ads_completed`
--
ALTER TABLE `ads_completed`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_commissions`
--
ALTER TABLE `referral_commissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deposit_methods`
--
ALTER TABLE `deposit_methods`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_settings`
--
ALTER TABLE `referral_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

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

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

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

--
-- Constraints for table `ads_completed`
--
ALTER TABLE `ads_completed`
  ADD CONSTRAINT `ads_completed_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ads_completed_ibfk_2` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `referral_commissions`
--
ALTER TABLE `referral_commissions`
  ADD CONSTRAINT `referral_commissions_ibfk_1` FOREIGN KEY (`from_user`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `referral_commissions_ibfk_2` FOREIGN KEY (`to_user`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

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