-- Game Integration Setup for pay2inr
-- Run this SQL to configure the default game user

-- Add default_game_user column to settings table (if not exists)
ALTER TABLE `settings` 
ADD COLUMN IF NOT EXISTS `default_game_user` VARCHAR(100) DEFAULT 'admin' 
AFTER `weburl`;

-- Update with your preferred default user for game payments
-- Replace 'admin' with the username you want to use for game transactions
UPDATE `settings` 
SET `default_game_user` = 'admin' 
WHERE `id` = 1;

-- Optional: Create a dedicated game user if you want separate tracking
-- Uncomment the lines below if you want to create a new user specifically for game payments

/*
INSERT INTO `loginusers` 
(username, password, email, usertype, status, wallet, created_at) 
VALUES 
('gameuser', MD5('changeme123'), 'game@fastpay.us.cc', 'apipartner', 'active', 0.00, NOW());

-- Then update settings to use this new user
UPDATE `settings` SET `default_game_user` = 'gameuser' WHERE `id` = 1;
*/

-- Verify the configuration
SELECT id, webname, default_game_user FROM settings;
