-- ============================================================
-- HyipPro - HYIP Investment Script Database Schema
-- Full SQL File: Tables, Indexes, Foreign Keys & Seed Data
-- ============================================================
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
-- ============================================================
-- DATABASE
-- ============================================================
CREATE DATABASE IF NOT EXISTS `hyippro` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `hyippro`;
-- ============================================================
-- TABLE: users
-- ============================================================
CREATE TABLE `users` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) NOT NULL UNIQUE,
`email` VARCHAR(191) NOT NULL UNIQUE,
`password` VARCHAR(255) NOT NULL,
`full_name` VARCHAR(100) NOT NULL,
`phone` VARCHAR(20) DEFAULT NULL,
`avatar` VARCHAR(255) DEFAULT 'default.png',
`country` VARCHAR(100) DEFAULT NULL,
`address` TEXT DEFAULT NULL,
`referral_code` VARCHAR(30) NOT NULL UNIQUE,
`referred_by` BIGINT UNSIGNED DEFAULT NULL,
`balance` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`profit_balance` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`bonus_balance` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`referral_balance` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`total_deposit` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`total_withdraw` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`total_invested` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`total_profit` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`kyc_status` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '0=Pending,1=Verified,2=Rejected',
`status` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '0=Inactive,1=Active,2=Banned',
`email_verified` TINYINT(1) NOT NULL DEFAULT 0,
`two_factor_secret` VARCHAR(100) DEFAULT NULL,
`two_factor_enabled` TINYINT(1) NOT NULL DEFAULT 0,
`last_login` TIMESTAMP NULL DEFAULT NULL,
`last_login_ip` VARCHAR(45) DEFAULT NULL,
`remember_token` VARCHAR(100) DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_users_referral_code` (`referral_code`),
KEY `idx_users_referred_by` (`referred_by`),
KEY `idx_users_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: admins
-- ============================================================
CREATE TABLE `admins` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL,
`email` VARCHAR(191) NOT NULL UNIQUE,
`password` VARCHAR(255) NOT NULL,
`role` ENUM('superadmin','admin','moderator') NOT NULL DEFAULT 'admin',
`permissions` JSON DEFAULT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`last_login` TIMESTAMP NULL DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: investment_plans
-- ============================================================
CREATE TABLE `investment_plans` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL,
`description` TEXT DEFAULT NULL,
`min_amount` DECIMAL(20,8) NOT NULL,
`max_amount` DECIMAL(20,8) NOT NULL,
`roi_percent` DECIMAL(10,4) NOT NULL COMMENT 'Return on investment percent per period',
`roi_type` ENUM('daily','weekly','monthly','once') NOT NULL DEFAULT 'daily',
`duration` INT NOT NULL COMMENT 'Duration in days',
`capital_return` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '1=Return capital at end',
`referral_bonus` DECIMAL(10,4) NOT NULL DEFAULT 0.0000,
`plan_type` ENUM('fixed','range') NOT NULL DEFAULT 'fixed',
`badge` VARCHAR(50) DEFAULT NULL COMMENT 'e.g. Popular, Hot',
`color` VARCHAR(20) DEFAULT '#3498db',
`icon` VARCHAR(100) DEFAULT NULL,
`compound_interest` TINYINT(1) NOT NULL DEFAULT 0,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`sort_order` INT NOT NULL DEFAULT 0,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_plans_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: investments (user investments)
-- ============================================================
CREATE TABLE `investments` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`plan_id` INT UNSIGNED NOT NULL,
`trx` VARCHAR(64) NOT NULL UNIQUE COMMENT 'Unique transaction reference',
`amount` DECIMAL(20,8) NOT NULL,
`roi_percent` DECIMAL(10,4) NOT NULL,
`roi_type` ENUM('daily','weekly','monthly','once') NOT NULL,
`duration` INT NOT NULL,
`next_roi_date` DATE DEFAULT NULL,
`end_date` DATE NOT NULL,
`total_paid` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`status` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '0=Cancelled,1=Running,2=Completed',
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_investments_user` (`user_id`),
KEY `idx_investments_plan` (`plan_id`),
KEY `idx_investments_status` (`status`),
KEY `idx_investments_next_roi` (`next_roi_date`),
CONSTRAINT `fk_investments_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
CONSTRAINT `fk_investments_plan` FOREIGN KEY (`plan_id`) REFERENCES `investment_plans` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: payment_gateways
-- ============================================================
CREATE TABLE `payment_gateways` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL,
`code` VARCHAR(50) NOT NULL UNIQUE,
`logo` VARCHAR(255) DEFAULT NULL,
`type` ENUM('auto','manual') NOT NULL DEFAULT 'auto',
`currency` VARCHAR(20) NOT NULL DEFAULT 'USD',
`rate` DECIMAL(20,8) NOT NULL DEFAULT 1.00000000 COMMENT 'Conversion rate to USD',
`min_amount` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`max_amount` DECIMAL(20,8) NOT NULL DEFAULT 99999999.00000000,
`fixed_charge` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`percent_charge` DECIMAL(10,4) NOT NULL DEFAULT 0.0000,
`credentials` JSON DEFAULT NULL COMMENT 'API keys, secrets etc.',
`parameters` JSON DEFAULT NULL,
`extra` JSON DEFAULT NULL,
`description` TEXT DEFAULT NULL,
`deposit_enabled` TINYINT(1) NOT NULL DEFAULT 1,
`withdraw_enabled` TINYINT(1) NOT NULL DEFAULT 1,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`sort_order` INT NOT NULL DEFAULT 0,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: deposits
-- ============================================================
CREATE TABLE `deposits` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`gateway_id` INT UNSIGNED NOT NULL,
`trx` VARCHAR(64) NOT NULL UNIQUE,
`amount` DECIMAL(20,8) NOT NULL,
`charge` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`rate` DECIMAL(20,8) NOT NULL DEFAULT 1.00000000,
`final_amount` DECIMAL(20,8) NOT NULL COMMENT 'Amount after charge',
`currency` VARCHAR(20) NOT NULL DEFAULT 'USD',
`btc_amount` DECIMAL(20,8) DEFAULT NULL,
`btc_wallet` VARCHAR(255) DEFAULT NULL,
`detail` JSON DEFAULT NULL,
`from_address` VARCHAR(255) DEFAULT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '0=Pending,1=Completed,2=Cancelled,3=Rejected',
`admin_note` TEXT DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_deposits_user` (`user_id`),
KEY `idx_deposits_gateway` (`gateway_id`),
KEY `idx_deposits_status` (`status`),
KEY `idx_deposits_trx` (`trx`),
CONSTRAINT `fk_deposits_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
CONSTRAINT `fk_deposits_gateway` FOREIGN KEY (`gateway_id`) REFERENCES `payment_gateways` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: withdrawals
-- ============================================================
CREATE TABLE `withdrawals` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`gateway_id` INT UNSIGNED NOT NULL,
`trx` VARCHAR(64) NOT NULL UNIQUE,
`amount` DECIMAL(20,8) NOT NULL,
`charge` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`final_amount` DECIMAL(20,8) NOT NULL,
`currency` VARCHAR(20) NOT NULL DEFAULT 'USD',
`wallet_address` VARCHAR(255) DEFAULT NULL,
`bank_detail` JSON DEFAULT NULL,
`after_balance` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`status` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '0=Pending,1=Completed,2=Cancelled,3=Rejected',
`admin_note` TEXT DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_withdrawals_user` (`user_id`),
KEY `idx_withdrawals_gateway` (`gateway_id`),
KEY `idx_withdrawals_status` (`status`),
CONSTRAINT `fk_withdrawals_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
CONSTRAINT `fk_withdrawals_gateway` FOREIGN KEY (`gateway_id`) REFERENCES `payment_gateways` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: transactions (ledger / general log)
-- ============================================================
CREATE TABLE `transactions` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`trx` VARCHAR(64) NOT NULL UNIQUE,
`type` ENUM('deposit','withdraw','invest','profit','referral','bonus','transfer','fee') NOT NULL,
`amount` DECIMAL(20,8) NOT NULL,
`charge` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`post_balance`DECIMAL(20,8) NOT NULL,
`remark` VARCHAR(255) DEFAULT NULL,
`details` TEXT DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_transactions_user` (`user_id`),
KEY `idx_transactions_type` (`type`),
KEY `idx_transactions_trx` (`trx`),
CONSTRAINT `fk_transactions_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: referrals
-- ============================================================
CREATE TABLE `referrals` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`referrer_id` BIGINT UNSIGNED NOT NULL,
`referred_id` BIGINT UNSIGNED NOT NULL,
`investment_id` BIGINT UNSIGNED DEFAULT NULL,
`commission` DECIMAL(20,8) NOT NULL DEFAULT 0.00000000,
`level` TINYINT NOT NULL DEFAULT 1,
`status` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '0=Pending,1=Paid',
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_referrals_referrer` (`referrer_id`),
KEY `idx_referrals_referred` (`referred_id`),
CONSTRAINT `fk_referrals_referrer` FOREIGN KEY (`referrer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
CONSTRAINT `fk_referrals_referred` FOREIGN KEY (`referred_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: referral_levels (multi-level settings)
-- ============================================================
CREATE TABLE `referral_levels` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`level` TINYINT NOT NULL,
`percent` DECIMAL(10,4) NOT NULL DEFAULT 0.0000,
`status` TINYINT(1) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_referral_level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: bonuses
-- ============================================================
CREATE TABLE `bonuses` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`type` VARCHAR(50) NOT NULL COMMENT 'e.g. signup,deposit_match,promo',
`amount` DECIMAL(20,8) NOT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`note` VARCHAR(255) DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_bonuses_user` (`user_id`),
CONSTRAINT `fk_bonuses_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: profit_logs (ROI distribution history)
-- ============================================================
CREATE TABLE `profit_logs` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`investment_id` BIGINT UNSIGNED NOT NULL,
`user_id` BIGINT UNSIGNED NOT NULL,
`amount` DECIMAL(20,8) NOT NULL,
`after_balance` DECIMAL(20,8) NOT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_profit_logs_investment` (`investment_id`),
KEY `idx_profit_logs_user` (`user_id`),
CONSTRAINT `fk_profit_logs_investment` FOREIGN KEY (`investment_id`) REFERENCES `investments` (`id`) ON DELETE CASCADE,
CONSTRAINT `fk_profit_logs_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: kyc_verifications
-- ============================================================
CREATE TABLE `kyc_verifications` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`id_type` VARCHAR(50) NOT NULL COMMENT 'passport, national_id, driving_license',
`id_number` VARCHAR(100) NOT NULL,
`front_image` VARCHAR(255) NOT NULL,
`back_image` VARCHAR(255) DEFAULT NULL,
`selfie_image` VARCHAR(255) DEFAULT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '0=Pending,1=Approved,2=Rejected',
`admin_note` TEXT DEFAULT NULL,
`reviewed_by` INT UNSIGNED DEFAULT NULL,
`reviewed_at` TIMESTAMP NULL DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_kyc_user` (`user_id`),
CONSTRAINT `fk_kyc_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: notifications
-- ============================================================
CREATE TABLE `notifications` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED DEFAULT NULL COMMENT 'NULL = global / all users',
`title` VARCHAR(191) NOT NULL,
`message` TEXT NOT NULL,
`type` VARCHAR(50) NOT NULL DEFAULT 'info' COMMENT 'info,success,warning,danger',
`icon` VARCHAR(100) DEFAULT NULL,
`link` VARCHAR(255) DEFAULT NULL,
`is_read` TINYINT(1) NOT NULL DEFAULT 0,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_notifications_user` (`user_id`),
KEY `idx_notifications_is_read` (`is_read`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: email_templates
-- ============================================================
CREATE TABLE `email_templates` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL UNIQUE,
`subject` VARCHAR(255) NOT NULL,
`body` LONGTEXT NOT NULL,
`variables` JSON DEFAULT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: settings (key-value site configuration)
-- ============================================================
CREATE TABLE `settings` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`key` VARCHAR(100) NOT NULL UNIQUE,
`value` LONGTEXT DEFAULT NULL,
`group` VARCHAR(50) NOT NULL DEFAULT 'general',
`type` VARCHAR(20) NOT NULL DEFAULT 'text',
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_settings_group` (`group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: pages (CMS)
-- ============================================================
CREATE TABLE `pages` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(255) NOT NULL,
`slug` VARCHAR(255) NOT NULL UNIQUE,
`content` LONGTEXT NOT NULL,
`meta_title` VARCHAR(255) DEFAULT NULL,
`meta_desc` TEXT DEFAULT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: blogs
-- ============================================================
CREATE TABLE `blogs` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(255) NOT NULL,
`slug` VARCHAR(255) NOT NULL UNIQUE,
`image` VARCHAR(255) DEFAULT NULL,
`content` LONGTEXT NOT NULL,
`tags` VARCHAR(255) DEFAULT NULL,
`meta_title` VARCHAR(255) DEFAULT NULL,
`meta_desc` TEXT DEFAULT NULL,
`views` INT UNSIGNED NOT NULL DEFAULT 0,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: faqs
-- ============================================================
CREATE TABLE `faqs` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`question` VARCHAR(500) NOT NULL,
`answer` TEXT NOT NULL,
`sort_order` INT NOT NULL DEFAULT 0,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: testimonials
-- ============================================================
CREATE TABLE `testimonials` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL,
`designation` VARCHAR(100) DEFAULT NULL,
`avatar` VARCHAR(255) DEFAULT NULL,
`rating` TINYINT NOT NULL DEFAULT 5,
`message` TEXT NOT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`sort_order` INT NOT NULL DEFAULT 0,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: support_tickets
-- ============================================================
CREATE TABLE `support_tickets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`ticket_no` VARCHAR(20) NOT NULL UNIQUE,
`subject` VARCHAR(255) NOT NULL,
`priority` ENUM('low','medium','high','critical') NOT NULL DEFAULT 'medium',
`status` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '0=Open,1=Answered,2=Closed,3=Replied',
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_tickets_user` (`user_id`),
CONSTRAINT `fk_tickets_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: support_messages
-- ============================================================
CREATE TABLE `support_messages` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`ticket_id` BIGINT UNSIGNED NOT NULL,
`sender_id` BIGINT UNSIGNED DEFAULT NULL,
`admin_id` INT UNSIGNED DEFAULT NULL,
`message` TEXT NOT NULL,
`attachment` VARCHAR(255) DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_messages_ticket` (`ticket_id`),
CONSTRAINT `fk_messages_ticket` FOREIGN KEY (`ticket_id`) REFERENCES `support_tickets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: password_resets
-- ============================================================
CREATE TABLE `password_resets` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`email` VARCHAR(191) NOT NULL,
`token` VARCHAR(255) NOT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_pw_resets_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: email_verifications
-- ============================================================
CREATE TABLE `email_verifications` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`token` VARCHAR(255) NOT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_ev_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: login_logs
-- ============================================================
CREATE TABLE `login_logs` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`ip_address` VARCHAR(45) NOT NULL,
`user_agent` TEXT DEFAULT NULL,
`location` VARCHAR(100) DEFAULT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '1=Success,0=Failed',
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_login_logs_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: cron_logs
-- ============================================================
CREATE TABLE `cron_logs` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`job` VARCHAR(100) NOT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`message` TEXT DEFAULT NULL,
`executed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: push_subscriptions (Web Push / In-App)
-- ============================================================
CREATE TABLE `push_subscriptions` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` BIGINT UNSIGNED NOT NULL,
`endpoint` TEXT NOT NULL,
`p256dh` TEXT DEFAULT NULL,
`auth` TEXT DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_push_user` (`user_id`),
CONSTRAINT `fk_push_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: currencies
-- ============================================================
CREATE TABLE `currencies` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL,
`code` VARCHAR(10) NOT NULL UNIQUE,
`symbol` VARCHAR(10) NOT NULL,
`rate_usd` DECIMAL(20,8) NOT NULL DEFAULT 1.00000000,
`type` ENUM('fiat','crypto') NOT NULL DEFAULT 'fiat',
`status` TINYINT(1) NOT NULL DEFAULT 1,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: sliders (Homepage banners)
-- ============================================================
CREATE TABLE `sliders` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(255) NOT NULL,
`subtitle` VARCHAR(255) DEFAULT NULL,
`image` VARCHAR(255) NOT NULL,
`button_text` VARCHAR(100) DEFAULT NULL,
`button_url` VARCHAR(255) DEFAULT NULL,
`sort_order` INT NOT NULL DEFAULT 0,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: partners / sponsors logos
-- ============================================================
CREATE TABLE `partners` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL,
`logo` VARCHAR(255) NOT NULL,
`url` VARCHAR(255) DEFAULT NULL,
`sort_order` INT NOT NULL DEFAULT 0,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: activity_logs (admin audit)
-- ============================================================
CREATE TABLE `activity_logs` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`admin_id` INT UNSIGNED DEFAULT NULL,
`user_id` BIGINT UNSIGNED DEFAULT NULL,
`action` VARCHAR(255) NOT NULL,
`model` VARCHAR(100) DEFAULT NULL,
`model_id` BIGINT UNSIGNED DEFAULT NULL,
`old_values` JSON DEFAULT NULL,
`new_values` JSON DEFAULT NULL,
`ip_address` VARCHAR(45) DEFAULT NULL,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: social_links
-- ============================================================
CREATE TABLE `social_links` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`platform` VARCHAR(50) NOT NULL,
`url` VARCHAR(255) NOT NULL,
`icon` VARCHAR(100) DEFAULT NULL,
`sort_order` INT NOT NULL DEFAULT 0,
`status` TINYINT(1) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- TABLE: newsletter_subscribers
-- ============================================================
CREATE TABLE `newsletter_subscribers` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`email` VARCHAR(191) NOT NULL UNIQUE,
`status` TINYINT(1) NOT NULL DEFAULT 1,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ============================================================
-- SEED DATA
-- ============================================================
-- Default Super Admin (password: Admin@1234)
INSERT INTO `admins` (`name`, `email`, `password`, `role`, `status`) VALUES
('Super Admin', 'admin@hyippro.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'superadmin', 1);
-- Referral Levels
INSERT INTO `referral_levels` (`level`, `percent`, `status`) VALUES
(1, 5.0000, 1),
(2, 2.0000, 1),
(3, 1.0000, 1);
-- Investment Plans
INSERT INTO `investment_plans` (`name`, `description`, `min_amount`, `max_amount`, `roi_percent`, `roi_type`, `duration`, `capital_return`, `referral_bonus`, `badge`, `color`, `status`, `sort_order`) VALUES
('Starter Plan', 'Perfect for new investors. Low risk, steady daily returns.', 10.00, 999.00, 1.5000, 'daily', 30, 1, 3.0000, NULL, '#27ae60', 1, 1),
('Silver Plan', 'Mid-level plan with great returns for growing portfolios.', 1000.00, 4999.00, 2.5000, 'daily', 60, 1, 4.0000, 'Popular','#2980b9', 1, 2),
('Gold Plan', 'High yield daily returns for serious investors.', 5000.00, 19999.00,3.5000, 'daily', 90, 1, 5.0000, 'Hot', '#f39c12', 1, 3),
('VIP Plan', 'Exclusive plan with the highest returns and capital protection.',20000.00,99999.00, 5.0000, 'daily', 180, 1, 7.0000, 'VIP', '#8e44ad', 1, 4),
('Weekly Boost', 'Receive compounded returns every week.', 500.00, 9999.00, 15.000, 'weekly', 12, 1, 4.0000, NULL, '#e74c3c', 1, 5);
-- Payment Gateways (32 gateways)
INSERT INTO `payment_gateways` (`name`, `code`, `type`, `currency`, `min_amount`, `max_amount`, `percent_charge`, `fixed_charge`, `status`, `sort_order`) VALUES
('Bitcoin', 'bitcoin', 'auto', 'BTC', 0.00010000, 99999999.00, 1.0000, 0.00000000, 1, 1),
('Ethereum', 'ethereum', 'auto', 'ETH', 0.00100000, 99999999.00, 1.0000, 0.00000000, 1, 2),
('Tether (USDT ERC20)','usdt_erc20', 'auto', 'USDT', 1.00000000, 99999999.00, 1.0000, 1.00000000, 1, 3),
('Tether (USDT TRC20)','usdt_trc20', 'auto', 'USDT', 1.00000000, 99999999.00, 0.5000, 1.00000000, 1, 4),
('Litecoin', 'litecoin', 'auto', 'LTC', 0.01000000, 99999999.00, 1.0000, 0.00000000, 1, 5),
('Ripple (XRP)', 'ripple', 'auto', 'XRP', 1.00000000, 99999999.00, 1.0000, 0.00000000, 1, 6),
('Dogecoin', 'dogecoin', 'auto', 'DOGE', 10.0000000, 99999999.00, 1.0000, 0.00000000, 1, 7),
('Bitcoin Cash', 'bitcoin_cash', 'auto', 'BCH', 0.00100000, 99999999.00, 1.0000, 0.00000000, 1, 8),
('Binance Coin (BNB)','bnb', 'auto', 'BNB', 0.01000000, 99999999.00, 1.0000, 0.00000000, 1, 9),
('TRON', 'tron', 'auto', 'TRX', 10.0000000, 99999999.00, 0.5000, 0.00000000, 1, 10),
('Solana', 'solana', 'auto', 'SOL', 0.01000000, 99999999.00, 1.0000, 0.00000000, 1, 11),
('Polygon (MATIC)', 'polygon', 'auto', 'MATIC',1.00000000, 99999999.00, 1.0000, 0.00000000, 1, 12),
('Dash', 'dash', 'auto', 'DASH', 0.01000000, 99999999.00, 1.0000, 0.00000000, 1, 13),
('Monero', 'monero', 'auto', 'XMR', 0.01000000, 99999999.00, 1.0000, 0.00000000, 1, 14),
('Cardano (ADA)', 'cardano', 'auto', 'ADA', 1.00000000, 99999999.00, 1.0000, 0.00000000, 1, 15),
('Stellar (XLM)', 'stellar', 'auto', 'XLM', 1.00000000, 99999999.00, 1.0000, 0.00000000, 1, 16),
('Avalanche', 'avalanche', 'auto', 'AVAX', 0.10000000, 99999999.00, 1.0000, 0.00000000, 1, 17),
('Chainlink', 'chainlink', 'auto', 'LINK', 0.10000000, 99999999.00, 1.0000, 0.00000000, 1, 18),
('Uniswap', 'uniswap', 'auto', 'UNI', 0.10000000, 99999999.00, 1.0000, 0.00000000, 1, 19),
('Shiba Inu', 'shiba_inu', 'auto', 'SHIB', 1000000.00, 99999999.00, 1.0000, 0.00000000, 1, 20),
('PayPal', 'paypal', 'auto', 'USD', 5.00000000, 5000.00, 2.9000, 0.30000000, 1, 21),
('Stripe', 'stripe', 'auto', 'USD', 1.00000000, 9999.00, 2.9000, 0.30000000, 1, 22),
('Coinbase Commerce', 'coinbase', 'auto', 'USD', 1.00000000, 99999999.00, 1.0000, 0.00000000, 1, 23),
('CoinPayments', 'coinpayments', 'auto', 'BTC', 0.00010000, 99999999.00, 0.5000, 0.00000000, 1, 24),
('NowPayments', 'nowpayments', 'auto', 'USD', 1.00000000, 99999999.00, 0.5000, 0.00000000, 1, 25),
('Perfect Money', 'perfect_money', 'auto', 'USD', 1.00000000, 99999.00, 0.5000, 0.00000000, 1, 26),
('Payeer', 'payeer', 'auto', 'USD', 1.00000000, 99999.00, 1.0000, 0.00000000, 1, 27),
('Skrill', 'skrill', 'auto', 'USD', 1.00000000, 9999.00, 1.0000, 0.20000000, 1, 28),
('Neteller', 'neteller', 'auto', 'USD', 1.00000000, 9999.00, 1.9000, 0.00000000, 1, 29),
('Bank Wire', 'bank_wire', 'manual', 'USD', 100.0000000,500000.00, 0.0000, 15.0000000, 1, 30),
('CashApp', 'cashapp', 'manual', 'USD', 5.00000000, 2000.00, 1.5000, 0.00000000, 1, 31),
('Voucher / Coupon', 'voucher', 'manual', 'USD', 1.00000000, 9999.00, 0.0000, 0.00000000, 1, 32);
-- Currencies
INSERT INTO `currencies` (`name`, `code`, `symbol`, `rate_usd`, `type`, `status`) VALUES
('US Dollar', 'USD', '$', 1.00000000, 'fiat', 1),
('Euro', 'EUR', '€', 0.92000000, 'fiat', 1),
('British Pound', 'GBP', '£', 0.79000000, 'fiat', 1),
('Bitcoin', 'BTC', '₿', 0.00002500, 'crypto', 1),
('Ethereum', 'ETH', 'Ξ', 0.00040000, 'crypto', 1),
('Tether', 'USDT', '₮', 1.00000000, 'crypto', 1),
('Litecoin', 'LTC', 'Ł', 0.01200000, 'crypto', 1);
-- Default Site Settings
INSERT INTO `settings` (`key`, `value`, `group`, `type`) VALUES
('site_name', 'HyipPro', 'general', 'text'),
('site_tagline', 'Invest Smart. Earn More.', 'general', 'text'),
('site_email', 'info@hyippro.com', 'general', 'email'),
('site_phone', '+1 800 000 0000', 'general', 'text'),
('site_address', '123 Finance Street, NY', 'general', 'text'),
('site_logo', 'logo.png', 'general', 'file'),
('site_favicon', 'favicon.ico', 'general', 'file'),
('currency_symbol', '$', 'general', 'text'),
('currency_code', 'USD', 'general', 'text'),
('min_deposit', '10', 'deposit', 'number'),
('max_deposit', '100000', 'deposit', 'number'),
('min_withdraw', '5', 'withdraw', 'number'),
('max_withdraw', '50000', 'withdraw', 'number'),
('withdraw_charge', '1', 'withdraw', 'number'),
('withdraw_charge_type','percent', 'withdraw', 'select'),
('email_verification', '1', 'security', 'boolean'),
('kyc_required', '0', 'security', 'boolean'),
('two_factor_auth', '1', 'security', 'boolean'),
('referral_system', '1', 'referral', 'boolean'),
('signup_bonus', '0', 'bonus', 'number'),
('deposit_bonus', '0', 'bonus', 'number'),
('maintenance_mode', '0', 'general', 'boolean'),
('google_analytics', '', 'seo', 'text'),
('meta_title', 'HyipPro - Best HYIP Script', 'seo', 'text'),
('meta_description', 'Automated HYIP Investment Script with 32 payment gateways.', 'seo', 'text'),
('smtp_host', 'smtp.mailtrap.io', 'email', 'text'),
('smtp_port', '587', 'email', 'number'),
('smtp_username', '', 'email', 'text'),
('smtp_password', '', 'email', 'password'),
('smtp_encryption', 'tls', 'email', 'select');
-- Default FAQs
INSERT INTO `faqs` (`question`, `answer`, `sort_order`, `status`) VALUES
('What is HyipPro?', 'HyipPro is a fully automated HYIP investment platform allowing you to invest, earn daily returns, and withdraw profits seamlessly.', 1, 1),
('How do I register?', 'Click the Sign Up button, fill in your details, verify your email, and your account will be ready.', 2, 1),
('What payment methods are supported?', 'We support 32 payment gateways including Bitcoin, Ethereum, USDT, PayPal, Skrill, Neteller, and Bank Wire.', 3, 1),
('How are profits distributed?', 'Profits are distributed automatically by our system every day based on your active investment plan.', 4, 1),
('Is there a referral program?', 'Yes! Earn multi-level referral commissions when your referred users make investments.', 5, 1),
('How do I withdraw funds?', 'Go to your dashboard, click Withdraw, select your preferred gateway, enter the amount, and submit.', 6, 1),
('Is my investment secure?', 'We use bank-grade SSL encryption, two-factor authentication, and advanced security protocols to protect all funds.', 7, 1);
-- Default Testimonials
INSERT INTO `testimonials` (`name`, `designation`, `rating`, `message`, `sort_order`, `status`) VALUES
('James Wilson', 'Business Investor', 5, 'HyipPro is absolutely amazing. I have been investing for 6 months and the returns are consistent and the platform is very user friendly.', 1, 1),
('Sarah Johnson', 'Crypto Enthusiast', 5, 'The fastest withdrawal I have ever experienced on any HYIP platform. Highly recommend!', 2, 1),
('Michael Chen', 'Financial Consultant', 5, 'Excellent platform with a clean interface and reliable profit distribution. My clients love it.',3, 1),
('Emily Davis', 'Online Entrepreneur', 4, 'The referral system is incredible. I have earned significant passive income just from referring friends.', 4, 1);
-- Social Links
INSERT INTO `social_links` (`platform`, `url`, `icon`, `sort_order`, `status`) VALUES
('Facebook', 'https://facebook.com/hyippro', 'fab fa-facebook', 1, 1),
('Twitter', 'https://twitter.com/hyippro', 'fab fa-twitter', 2, 1),
('Telegram', 'https://t.me/hyippro', 'fab fa-telegram', 3, 1),
('Instagram', 'https://instagram.com/hyippro', 'fab fa-instagram', 4, 1),
('YouTube', 'https://youtube.com/hyippro', 'fab fa-youtube', 5, 1),
('LinkedIn', 'https://linkedin.com/hyippro', 'fab fa-linkedin', 6, 1);
-- CMS Pages
INSERT INTO `pages` (`title`, `slug`, `content`, `meta_title`, `status`) VALUES
('About Us', 'about-us', 'About HyipPro
HyipPro is a leading automated investment platform built for modern investors.
', 'About HyipPro', 1),
('Terms of Service','terms-of-service','Terms of Service
Please read these terms carefully before using our platform.
', 'Terms of Service', 1),
('Privacy Policy', 'privacy-policy', 'Privacy Policy
Your privacy is important to us. This policy explains how we handle your data.
', 'Privacy Policy', 1),
('Contact Us', 'contact-us', 'Contact HyipPro
Get in touch with our support team 24/7.
', 'Contact HyipPro', 1),
('Disclaimer', 'disclaimer', 'Disclaimer
Investing carries risk. Please invest only what you can afford to lose.
', 'Investment Disclaimer', 1);
-- Email Templates
INSERT INTO `email_templates` (`name`, `subject`, `body`, `variables`) VALUES
('registration', 'Welcome to {{site_name}}!',
'Hello {{full_name}},
Welcome to {{site_name}}. Your account is ready.
',
'["site_name","full_name","email"]'),
('email_verification', 'Verify Your Email - {{site_name}}',
'Hello {{full_name}},
Please verify your email by clicking: Verify Email
',
'["full_name","link","site_name"]'),
('deposit_success', 'Deposit Confirmed - {{site_name}}',
'Hello {{full_name}},
Your deposit of {{amount}} has been confirmed.
',
'["full_name","amount","trx","site_name"]'),
('withdrawal_success', 'Withdrawal Processed - {{site_name}}',
'Hello {{full_name}},
Your withdrawal of {{amount}} has been processed.
',
'["full_name","amount","trx","site_name"]'),
('investment_created', 'Investment Activated - {{site_name}}',
'Hello {{full_name}},
Your investment of {{amount}} in {{plan_name}} is now active.
',
'["full_name","amount","plan_name","site_name"]'),
('profit_credited', 'Profit Credited - {{site_name}}',
'Hello {{full_name}},
A profit of {{amount}} has been credited to your account.
',
'["full_name","amount","site_name"]'),
('password_reset', 'Password Reset Request - {{site_name}}',
'Hello {{full_name}},
Click to reset your password: Reset Password. Expires in 60 minutes.
',
'["full_name","link","site_name"]'),
('ticket_reply', 'Support Ticket Reply - {{site_name}}',
'Hello {{full_name}},
Your ticket #{{ticket_no}} has a new reply.
',
'["full_name","ticket_no","site_name"]');
COMMIT;
-- ============================================================
-- END OF HYIPPRO SQL FILE
-- ============================================================