13 lines
672 B
SQL
13 lines
672 B
SQL
USE hyapp_wallet;
|
|
|
|
-- 主播提现后台页会用来源工资用户反查币商侧 COIN_SELLER_COIN 分录；
|
|
-- counterparty_user_id 是工资来源用户，组合索引避免按资产时间大范围扫描后再过滤来源用户。
|
|
SET @ddl := IF(
|
|
(SELECT COUNT(*) FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'wallet_entries' AND INDEX_NAME = 'idx_wallet_entries_asset_counterparty_time') = 0,
|
|
'ALTER TABLE wallet_entries ADD INDEX idx_wallet_entries_asset_counterparty_time (app_code, asset_type, counterparty_user_id, created_at_ms, entry_id)',
|
|
'SELECT 1'
|
|
);
|
|
PREPARE stmt FROM @ddl;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|