Edit

Editing: /home/goacom/baji.princedev.shop/database.sql

-- =====================================================================
-- VELKI 365 FULL DATABASE SQL DUMP / SCHEMA FILE
-- Suitable for phpMyAdmin, cPanel, MySQL, MariaDB, PostgreSQL, and SQLite
-- =====================================================================

-- --------------------------------------------------------
-- Table structure for table `site_settings`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `site_settings`;
CREATE TABLE `site_settings` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `site_title` VARCHAR(255) NOT NULL DEFAULT 'VELKE 365 | Verified Agent Directory & Games',
  `logo_text` VARCHAR(100) NOT NULL DEFAULT 'VELKE 365',
  `logo_sub` VARCHAR(100) NOT NULL DEFAULT 'OFFICIAL AGENT PORTAL',
  `site_notice` TEXT DEFAULT NULL,
  `support_whatsapp` VARCHAR(50) DEFAULT '+8801711112222',
  `support_telegram` VARCHAR(255) DEFAULT 'https://t.me/velkesite',
  `complain_notice` TEXT DEFAULT NULL,
  `footer_text` 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `site_settings`
INSERT INTO `site_settings` (`id`, `site_title`, `logo_text`, `logo_sub`, `site_notice`, `support_whatsapp`, `support_telegram`, `complain_notice`, `footer_text`) VALUES
(1, 'VELKE 365 | Verified Agent List', 'VELKE 365', 'OFFICIAL AGENT PORTAL', '🚨 WARNING: Always verify agent WhatsApp number before cash-in or cash-out! Report scam agents immediately.', '+8801711112222', 'https://t.me/velkesite', 'If any agent cheats or delays deposit/withdrawal, click Report button.', '© 2026 Velke 365 Official Agent Directory. All rights reserved.');

-- --------------------------------------------------------
-- Table structure for table `admin_users`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `admin_users`;
CREATE TABLE `admin_users` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(100) NOT NULL,
  `password_hash` VARCHAR(255) NOT NULL,
  `role` VARCHAR(50) NOT NULL DEFAULT 'SUPER_ADMIN',
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `admin_users` (Default login: admin / admin123)
INSERT INTO `admin_users` (`id`, `username`, `password_hash`, `role`) VALUES
(1, 'admin', '$2a$10$wN1H9M2U2eW3f4G5h6I7J8K9L0M1N2O3P4Q5R6S7T8U9V0W1X2Y3Z', 'SUPER_ADMIN');

-- --------------------------------------------------------
-- Table structure for table `agents`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `agents`;
CREATE TABLE `agents` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `agent_id` VARCHAR(50) NOT NULL,
  `name` VARCHAR(150) NOT NULL,
  `category` VARCHAR(100) NOT NULL,
  `level` INT(11) NOT NULL DEFAULT 3,
  `level_name` VARCHAR(100) DEFAULT 'Level 3 - Master Agent',
  `whatsapp` VARCHAR(50) NOT NULL,
  `status` VARCHAR(20) NOT NULL DEFAULT 'Active',
  `rating` DECIMAL(3,1) NOT NULL DEFAULT 5.0,
  `verified` TINYINT(1) NOT NULL DEFAULT 1,
  `notes` TEXT DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `agents`
INSERT INTO `agents` (`id`, `agent_id`, `name`, `category`, `level`, `level_name`, `whatsapp`, `status`, `rating`, `verified`, `notes`) VALUES
(1, 'SUB-101', 'Velke Sub Admin Main', 'SUB ADMIN', 1, 'Level 1 - Sub Admin', '+8801700000001', 'Active', 5.0, 1, 'Official Sub Admin for account creation and agent complaints.'),
(2, 'SUPER-201', 'Velke Super Agent Rahat', 'SUPER AGENT', 2, 'Level 2 - Super Agent', '+8801800000002', 'Active', 5.0, 1, 'Top rated Super Agent. Fast deposit and withdrawal.'),
(3, 'MASTER-301', 'Velke Master Agent Shakib', 'MASTER AGENT', 3, 'Level 3 - Master Agent', '+8801900000003', 'Active', 4.8, 1, 'Master Agent available 24/7.'),
(4, 'AGENT-401', 'Velke Sub Agent Tanvir', 'SUB AGENT', 4, 'Level 4 - Sub Agent', '+8801600000004', 'Active', 4.9, 1, 'Instant bKash/Nagad/Rocket transactions.'),
(5, 'CARE-501', 'Velke Official Support Helpline', 'CUSTOMER CARE', 5, 'Level 5 - Customer Care', '+8801700000005', 'Active', 5.0, 1, 'Customer Care support for user issues.');

-- --------------------------------------------------------
-- Table structure for table `games`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `games`;
CREATE TABLE `games` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(150) NOT NULL,
  `category` VARCHAR(100) NOT NULL,
  `icon` VARCHAR(50) DEFAULT '🎲',
  `image_url` VARCHAR(255) NOT NULL,
  `badge_text` VARCHAR(50) DEFAULT 'PLAY NOW',
  `is_featured` TINYINT(1) DEFAULT 1,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `games`
INSERT INTO `games` (`id`, `title`, `category`, `icon`, `image_url`, `badge_text`, `is_featured`) VALUES
(1, 'Cricket Exchange', 'Sports', '🏏', 'https://images.unsplash.com/photo-1531415074968-036ba1b575da?w=400&q=80', 'PLAY NOW', 1),
(2, 'Soccer Betting', 'Sports', '⚽', 'https://images.unsplash.com/photo-1508098682722-e99c43a406b2?w=400&q=80', 'PLAY NOW', 1),
(3, 'Speed Baccarat', 'Live Casino', '🃏', 'https://images.unsplash.com/photo-1518609878373-06d740f60d8b?w=400&q=80', 'PLAY NOW', 1),
(4, 'Crazy Time', 'Live Casino', '🎡', 'https://images.unsplash.com/photo-1596838132731-3301c3fd4317?w=400&q=80', 'PLAY NOW', 1),
(5, 'Lightning Roulette', 'Live Casino', '⚡', 'https://images.unsplash.com/photo-1606167668584-78701c57f13d?w=400&q=80', 'PLAY NOW', 1),
(6, 'Dragon Tiger', 'Live Casino', '🐉', 'https://images.unsplash.com/photo-1544717305-2782549b5136?w=400&q=80', 'PLAY NOW', 1),
(7, 'Aviator Game', 'Crash', '🚀', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=400&q=80', 'HOT', 1),
(8, 'Crash X', 'Crash', '📈', 'https://images.unsplash.com/photo-1611974789855-9c2a0a7236a3?w=400&q=80', 'PLAY NOW', 1),
(9, 'JILI Slots', 'Slots', '🎰', 'https://images.unsplash.com/photo-1518609878373-06d740f60d8b?w=400&q=80', 'HOT', 1),
(10, 'Pragmatic Play', 'Slots', '💎', 'https://images.unsplash.com/photo-1596838132731-3301c3fd4317?w=400&q=80', 'PLAY NOW', 1),
(11, 'Teen Patti', 'Table Games', '🎴', 'https://images.unsplash.com/photo-1511193311914-0346f16efe90?w=400&q=80', 'PLAY NOW', 1),
(12, 'Andar Bahar', 'Table Games', '🂠', 'https://images.unsplash.com/photo-1544717305-2782549b5136?w=400&q=80', 'PLAY NOW', 1);

-- --------------------------------------------------------
-- Table structure for table `inplay_matches`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `inplay_matches`;
CREATE TABLE `inplay_matches` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `sport` VARCHAR(50) NOT NULL,
  `team_a` VARCHAR(100) NOT NULL,
  `team_b` VARCHAR(100) NOT NULL,
  `score` VARCHAR(100) NOT NULL,
  `status` VARCHAR(20) NOT NULL DEFAULT 'LIVE',
  `match_time` VARCHAR(100) DEFAULT 'Live Now',
  `notes` VARCHAR(255) DEFAULT NULL,
  `link_url` VARCHAR(255) DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `inplay_matches`
INSERT INTO `inplay_matches` (`id`, `sport`, `team_a`, `team_b`, `score`, `status`, `match_time`, `notes`, `link_url`) VALUES
(1, 'Cricket', 'Bangladesh', 'India', '168/4 (19.1 Ov)', 'LIVE', 'Live Now', 'T20 International Series', '+8801700000001'),
(2, 'Soccer', 'Real Madrid', 'Barcelona', '2 - 1 (75\')', 'LIVE', 'Live Now', 'El Clasico League Match', '+8801700000001'),
(3, 'Cricket', 'Australia', 'England', 'Upcoming - 07:30 PM', 'UPCOMING', 'Today 7:30 PM', 'The Ashes Series', '+8801700000001');

-- --------------------------------------------------------
-- Table structure for table `api_providers`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `api_providers`;
CREATE TABLE `api_providers` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(50) NOT NULL UNIQUE, -- sportsApi, casinoApi, crashApi
  `provider_name` VARCHAR(150) NOT NULL,
  `base_url` VARCHAR(255) NOT NULL,
  `api_key` VARCHAR(255) NOT NULL,
  `status` VARCHAR(20) NOT NULL DEFAULT 'Active',
  `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `api_providers`
INSERT INTO `api_providers` (`id`, `category`, `provider_name`, `base_url`, `api_key`, `status`) VALUES
(1, 'sportsApi', 'Betfair Exchange API', 'https://api.sportsprovider.com/v1', 'SK_LIVE_998877665544332211', 'Active'),
(2, 'casinoApi', 'Evolution & Ezugi Live Casino API', 'https://api.casinoprovider.com/v1', 'CK_LIVE_112233445566778899', 'Active'),
(3, 'crashApi', 'Spribe Aviator Crash API', 'https://api.spribe.com/v1', 'AV_LIVE_554433221100998877', 'Active');

-- --------------------------------------------------------
-- Table structure for table `users`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(100) NOT NULL,
  `phone` VARCHAR(50) DEFAULT NULL,
  `balance` DECIMAL(12,2) NOT NULL DEFAULT 0.00,
  `status` VARCHAR(20) NOT NULL DEFAULT 'Active',
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `users`
INSERT INTO `users` (`id`, `username`, `phone`, `balance`, `status`) VALUES
(1, 'player101', '+8801711110001', 5000.00, 'Active'),
(2, 'cricket_boss', '+8801822220002', 12500.50, 'Active'),
(3, 'user777', '+8801933330003', 200.00, 'Active');

-- --------------------------------------------------------
-- Table structure for table `transactions`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) NOT NULL,
  `username` VARCHAR(100) NOT NULL,
  `type` VARCHAR(20) NOT NULL, -- CREDIT or DEBIT
  `amount` DECIMAL(12,2) NOT NULL,
  `balance_after` DECIMAL(12,2) NOT NULL,
  `notes` VARCHAR(255) DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `transactions`
INSERT INTO `transactions` (`id`, `user_id`, `username`, `type`, `amount`, `balance_after`, `notes`) VALUES
(1, 1, 'player101', 'CREDIT', 5000.00, 5000.00, 'Initial Deposit by Admin'),
(2, 2, 'cricket_boss', 'CREDIT', 12500.50, 12500.50, 'bKash Deposit Added by Admin');

-- --------------------------------------------------------
-- Table structure for table `complaints`
-- --------------------------------------------------------
DROP TABLE IF EXISTS `complaints`;
CREATE TABLE `complaints` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `agent_id` VARCHAR(50) NOT NULL,
  `agent_name` VARCHAR(150) DEFAULT NULL,
  `user_contact` VARCHAR(50) NOT NULL,
  `issue` TEXT NOT NULL,
  `status` VARCHAR(20) NOT NULL DEFAULT 'Pending',
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- =====================================================================
-- END OF SQL DUMP
-- =====================================================================