For full setup verification, also run setup-check.php once.
Admin login: admin / admin123
OK: CREATE TABLE IF NOT EXISTS bank_withdrawals (
id INT AUTO_INCREMENT PRIMARY KEY,
u
OK: CREATE TABLE IF NOT EXISTS email_logs (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id
OK: CREATE TABLE IF NOT EXISTS earning_plans (
id INT AUTO_INCREMENT PRIMARY KEY,
plan
OK: CREATE TABLE IF NOT EXISTS earning_subscriptions (
id INT AUTO_INCREMENT PRIMARY KEY,
OK: CREATE TABLE IF NOT EXISTS earning_monthly_bonus (
id INT AUTO_INCREMENT PRIMARY KEY,
SKIP/ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'payment_screenshot'
SKIP/ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'tx_hash'
SKIP/ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'deposit_network'
OK: CREATE TABLE IF NOT EXISTS earning_wallets (
id INT AUTO_INCREMENT PRIMARY KEY,
us
OK: ALTER TABLE earning_subscriptions MODIFY start_date DATETIME NOT NULL
OK: ALTER TABLE earning_subscriptions MODIFY maturity_date DATETIME NOT NULL
OK: ALTER TABLE earning_monthly_bonus MODIFY due_date DATETIME NOT NULL
SKIP/ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'credited_at'
SKIP/ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'ticket_number'
SKIP/ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'replied_at'
OK: CREATE TABLE IF NOT EXISTS user_notifications (
id INT AUTO_INCREMENT PRIMARY KEY,
OK: CREATE TABLE IF NOT EXISTS blocked_transaction_attempts (
id INT AUTO_INCREMENT PRIMAR
OK: CREATE TABLE IF NOT EXISTS support_chats (
id INT AUTO_INCREMENT PRIMARY KEY,
user
OK: CREATE TABLE IF NOT EXISTS support_chat_messages (
id INT AUTO_INCREMENT PRIMARY KEY,
OK: CREATE TABLE IF NOT EXISTS contact_messages (
id INT AUTO_INCREMENT PRIMARY KEY,
f
OK: INSERT IGNORE INTO earning_plans (id, plan_name, coin, duration_months, bonus_percent, min
OK: INSERT IGNORE INTO coin_listings (coin_symbol, coin_name, network) VALUES ('LOKA', 'Loka',
OK: setting company_usdt_trc20_address
OK: setting crypto_news_api_url
OK: setting crypto_news_api_key
OK: setting crypto_news_source
OK: setting crypto_news_fallback_rss
OK: Admin password reset to admin123Important: Delete update-database.php after running.