🧱 Database Structure Only

Database: sadhieaq_91

📌 Table: aks_active_settings

📌 Table: aks_admin_users

CREATE TABLE `aks_admin_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `email` varchar(150) NOT NULL,
  `password` varchar(255) NOT NULL,
  `full_name` varchar(200) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `role` enum('super_admin','admin','manager','user') DEFAULT 'user',
  `permissions` text DEFAULT NULL COMMENT 'JSON format permissions',
  `status` enum('active','inactive','suspended') DEFAULT 'active',
  `last_login` datetime DEFAULT NULL,
  `last_ip` varchar(45) 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`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`),
  KEY `role` (`role`),
  KEY `status` (`status`),
  KEY `idx_admin_email_status` (`email`,`status`),
  KEY `idx_admin_role_status` (`role`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

📌 Table: aks_banners

📌 Table: aks_dashboard_widgets

CREATE TABLE `aks_dashboard_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `widget_title` varchar(150) NOT NULL,
  `widget_icon` varchar(100) DEFAULT 'fas fa-cube',
  `widget_type` enum('stat_card','info_card','chart','table','custom_html','link_card') DEFAULT 'stat_card',
  `widget_color` varchar(50) DEFAULT 'blue',
  `widget_content` text DEFAULT NULL COMMENT 'JSON or HTML content',
  `widget_link` varchar(255) DEFAULT NULL,
  `widget_sql` text DEFAULT NULL COMMENT 'SQL query for dynamic data',
  `widget_size` enum('small','medium','large','full') DEFAULT 'small',
  `required_role` varchar(50) DEFAULT NULL,
  `required_permission` varchar(100) DEFAULT NULL,
  `sort_order` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created_by` int(11) 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 `status` (`status`),
  KEY `sort_order` (`sort_order`),
  KEY `widget_type` (`widget_type`),
  KEY `idx_widgets_status_order` (`status`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

📌 Table: aks_home_settings

📌 Table: aks_loaded_settings

📌 Table: aks_menu_items

CREATE TABLE `aks_menu_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_title` varchar(100) NOT NULL,
  `menu_icon` varchar(100) DEFAULT 'fas fa-circle',
  `menu_link` varchar(255) NOT NULL,
  `menu_type` enum('internal','external') DEFAULT 'internal',
  `parent_id` int(11) DEFAULT NULL,
  `required_role` varchar(50) DEFAULT NULL,
  `required_permission` varchar(100) DEFAULT NULL,
  `sort_order` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `show_badge` tinyint(1) DEFAULT 0,
  `badge_text` varchar(50) DEFAULT NULL,
  `badge_color` varchar(20) DEFAULT '#e74c3c',
  `created_by` int(11) 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 `status` (`status`),
  KEY `sort_order` (`sort_order`),
  KEY `parent_id` (`parent_id`),
  KEY `idx_menu_status_order` (`status`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

📌 Table: aks_settings

📌 Table: aks_user_group_auth

📌 Table: aks_user_settings

CREATE TABLE `aks_user_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `is_open_point_mall` varchar(10) DEFAULT '0',
  `is_open_amount_of_code` varchar(10) DEFAULT '1',
  `is_open_official_recharge_input_dialog` varchar(10) DEFAULT '1',
  `is_allow_user_add_usdt` varchar(10) DEFAULT '1',
  `is_show_wallet_total_ct` varchar(10) DEFAULT '1',
  `is_show_recharge_bank_list` varchar(10) DEFAULT '1',
  `is_popup_commission_switch` varchar(10) DEFAULT '1',
  `is_open_champion` varchar(10) DEFAULT '0',
  `allow_no_recharge_game` varchar(10) DEFAULT '0',
  `is_partner_reward` varchar(10) DEFAULT '0',
  `can_direct_to_game` tinyint(1) DEFAULT 1,
  `is_open_new_safe` varchar(10) 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`),
  UNIQUE KEY `user_id` (`user_id`),
  CONSTRAINT `fk_user_settings` FOREIGN KEY (`user_id`) REFERENCES `aks_users` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

📌 Table: aks_users

CREATE TABLE `aks_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_photo` varchar(255) DEFAULT '1',
  `user_name` varchar(100) NOT NULL,
  `nick_name` varchar(100) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `amount` decimal(10,2) DEFAULT 0.00,
  `amount_of_code` decimal(10,2) DEFAULT 0.00,
  `is_withdraw` varchar(10) DEFAULT NULL,
  `withdraw_count` int(11) DEFAULT 0,
  `email` varchar(150) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `add_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `user_login_date` datetime DEFAULT NULL,
  `last_ip` varchar(45) DEFAULT NULL,
  `fee` decimal(10,2) DEFAULT 0.00,
  `un_read` int(11) DEFAULT 0,
  `facebook_app_id` varchar(100) DEFAULT NULL,
  `google_app_id` varchar(100) DEFAULT NULL,
  `twitter_app_id` varchar(100) DEFAULT NULL,
  `key_code` varchar(100) DEFAULT NULL,
  `u_rate` decimal(10,2) DEFAULT 97.00,
  `trx_rate` decimal(10,2) DEFAULT 9.50,
  `u_gold` decimal(10,2) DEFAULT 0.01,
  `google_verify` tinyint(1) DEFAULT 0,
  `is_validator` tinyint(1) DEFAULT 0,
  `is_re_pwd` varchar(10) DEFAULT '1',
  `integral` int(11) DEFAULT 0,
  `reg_type` tinyint(1) DEFAULT 1 COMMENT '1=mobile, 2=email',
  `bind_reward` decimal(10,2) DEFAULT 0.00,
  `is_google` varchar(10) DEFAULT '0',
  `is_allow_withdraw` tinyint(1) DEFAULT 1,
  `user_recharge_times` int(11) DEFAULT 0,
  `use_language` varchar(10) DEFAULT 'en',
  `channel_amount_of_code` tinyint(1) DEFAULT 1,
  `status` enum('active','inactive','suspended','deleted') DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `email` (`email`),
  KEY `mobile` (`mobile`),
  KEY `status` (`status`),
  KEY `add_time` (`add_time`),
  KEY `idx_users_status` (`status`),
  KEY `idx_users_mobile` (`mobile`),
  KEY `idx_users_email` (`email`),
  KEY `idx_users_login_date` (`user_login_date`)
) ENGINE=InnoDB AUTO_INCREMENT=399757 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

📦 Full Database Structure

CREATE TABLE `aks_active_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` enum('boolean','string','number','object') DEFAULT 'string',
  `description` varchar(255) DEFAULT NULL,
  `updated_by` int(11) 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`),
  UNIQUE KEY `setting_key` (`setting_key`),
  KEY `updated_by` (`updated_by`),
  KEY `idx_active_settings_key` (`setting_key`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `aks_banners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `banner_image` varchar(500) NOT NULL,
  `link_url` varchar(500) DEFAULT NULL,
  `category_type` tinyint(1) DEFAULT 0,
  `jump_link_type` tinyint(1) DEFAULT 0,
  `vendor_code` varchar(100) DEFAULT '',
  `game_code` varchar(100) DEFAULT '',
  `game_name_en` varchar(200) DEFAULT '',
  `sort_order` int(11) DEFAULT 0,
  `status` tinyint(1) DEFAULT 1,
  `created_by` int(11) 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 `status` (`status`),
  KEY `sort_order` (`sort_order`),
  KEY `created_by` (`created_by`),
  KEY `idx_banners_status_order` (`status`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `aks_home_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` enum('boolean','string','number','object','array') DEFAULT 'string',
  `description` varchar(255) DEFAULT NULL,
  `updated_by` int(11) 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`),
  UNIQUE KEY `setting_key` (`setting_key`),
  KEY `updated_by` (`updated_by`),
  KEY `idx_home_settings_key` (`setting_key`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `aks_loaded_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` enum('boolean','string','number','object','null') DEFAULT 'string',
  `description` varchar(255) DEFAULT NULL,
  `updated_by` int(11) 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`),
  UNIQUE KEY `setting_key` (`setting_key`),
  KEY `updated_by` (`updated_by`),
  KEY `idx_loaded_settings_key` (`setting_key`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `aks_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_group` varchar(50) DEFAULT 'general',
  `updated_by` int(11) 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`),
  UNIQUE KEY `setting_key` (`setting_key`),
  KEY `updated_by` (`updated_by`),
  KEY `idx_settings_group` (`setting_group`),
  CONSTRAINT `fk_settings_admin` FOREIGN KEY (`updated_by`) REFERENCES `aks_admin_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `aks_user_group_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `is_show` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `group_id` (`group_id`),
  CONSTRAINT `fk_group_auth_user` FOREIGN KEY (`user_id`) REFERENCES `aks_users` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;