-- MySQL dump 10.13  Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost    Database: happy_paradise
-- ------------------------------------------------------
-- Server version	8.0.40-0ubuntu0.22.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `all_platform`
--

DROP TABLE IF EXISTS `all_platform`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `all_platform` (
  `uid` int unsigned NOT NULL AUTO_INCREMENT,
  `platform` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '前端和客戶會看到的名稱 (可以修改的平臺名稱)',
  `platform_mode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'single' COMMENT '该平台模式转账还是单一',
  `supported_currencies` json DEFAULT NULL COMMENT '该品牌支持的货币，以JSON格式存储',
  `platform_enum` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '个平台的固定常量(不可修改)',
  `game_wallet_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '加游戏必须确保相同',
  `is_under_maintenance` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否進行挂維護',
  `is_exclusive_brand` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否為獨家平臺',
  `maintenance_day_of_week` tinyint(1) NOT NULL DEFAULT '0' COMMENT '維護星期',
  `maintenance_start_time` time NOT NULL DEFAULT '00:00:00' COMMENT '維護開始時間',
  `maintenance_end_time` time NOT NULL DEFAULT '00:00:00' COMMENT '維護結束時間',
  `not_supported_iframe` tinyint(1) NOT NULL DEFAULT '0' COMMENT '該平臺是否不支援iframe',
  `status_front` tinyint(1) NOT NULL DEFAULT '0' COMMENT '前台品牌顯示1開0關',
  `status_backend` tinyint(1) NOT NULL DEFAULT '0' COMMENT '後台報表顯示1開0關',
  `is_scheduled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '扩充: 是否启用排程任务',
  `commission` double(30,8) NOT NULL DEFAULT '0.10000000' COMMENT '扩充: 原廠抽成0~1',
  `enable_buffer_wallet` tinyint(1) DEFAULT '0' COMMENT '使否啟用緩衝錢包機制，{0:關閉，1:開啟}',
  `bet_log_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '遊戲資訊，不含前綴(prefix)的表格名稱',
  `report_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '報表、詳細紀錄(用API從原廠抓取的)，不含前綴(prefix)的表格名稱',
  `primary_key` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '歷程表的唯一鍵',
  `member_info_uid_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '會員編號在該館別的欄位名稱',
  `date_time_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'date時間欄位名稱',
  `date_time_timezone` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'date時間欄位的時區範例:"+8"',
  `unix_time_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '時間戳欄位名稱',
  `report_time_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '紀錄遊戲帳務時間所使用的欄位名稱',
  `round_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '紀錄遊戲回合的欄位名稱',
  `order_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '紀錄遊戲局別的欄位名稱',
  `amount_before_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交易前餘額欄位名稱',
  `amount_name` text COLLATE utf8mb4_unicode_ci COMMENT '交易金额欄位名稱',
  `amount_after_name` text COLLATE utf8mb4_unicode_ci COMMENT '交易后餘額欄位名稱',
  `win` text COLLATE utf8mb4_unicode_ci COMMENT '贏金額欄位或公式',
  `win_or_lose` text COLLATE utf8mb4_unicode_ci COMMENT '輸贏欄位或公式',
  `jack_port_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'JackPort欄位名稱',
  `game_id_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '遊戲ID欄位名稱',
  `user_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '玩家遊戲名稱欄位',
  `transaction_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交易狀態欄位或公式',
  `transaction_status_judgment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交易狀態Enum',
  `oem_order_detail_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '原廠查訂單明細用ID',
  `oem_order_detail_option` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '原廠查訂單明細用，填充選項',
  `sum_bet_order` text COLLATE utf8mb4_unicode_ci COMMENT 'select計算下注額的mysql指令(不含where條件)',
  `sum_win_order` text COLLATE utf8mb4_unicode_ci COMMENT 'select計算輸贏額的mysql指令(不含where條件)',
  `excluding_cancelled` text COLLATE utf8mb4_unicode_ci COMMENT 'mysql指令中where的條件子句，排除取消單',
  `other_conditions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '動態搜尋用的其他條件',
  `sum_valid_bet` text COLLATE utf8mb4_unicode_ci COMMENT '有效投注欄位',
  `table_style` tinyint(1) DEFAULT NULL COMMENT '表格顯示樣式(1:911模式,0:新模式)',
  `game_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '平台遊戲類別',
  `sort` int DEFAULT '0' COMMENT '平台排序',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `platform_enum_unique` (`platform_enum`),
  UNIQUE KEY `all_platform_platform_enum_unique` (`platform_enum`),
  KEY `platform_mode_idx` (`platform`,`platform_mode`),
  KEY `front_back_status_idx` (`status_front`,`status_backend`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `all_platform`
--

LOCK TABLES `all_platform` WRITE;
/*!40000 ALTER TABLE `all_platform` DISABLE KEYS */;
REPLACE INTO `all_platform` VALUES (1,'WM','single',NULL,'WM','wm',0,0,1,'10:00:00','12:30:00',0,1,1,0,0.10000000,0,'wm_bet_log',NULL,'id','uid','requestDate','8','unix_time',NULL,'gameno','dealid',NULL,'CASE WHEN code = 2 THEN money ELSE 0 END',NULL,'CASE WHEN code = 1 THEN money ELSE 0 END',NULL,NULL,NULL,'user','CASE WHEN cmd =\'TimeoutBetReturn\' THEN 3 ELSE code END','{\"2\":\"bet\",\"1\":\"payout\",\"3\":\"cancel\"}',NULL,NULL,'sum(case when CODE = \'2\' then -money ELSE 0 END)','SUM(money)','',NULL,NULL,1,'LIVE',0),(2,'PG','single',NULL,'PG','pg',0,0,0,'00:00:00','23:00:00',0,0,0,0,0.10000000,0,'pg_bet_log',NULL,'uid','member_info_uid','txn_date',NULL,'txn_date_unix',NULL,'game_round_id','txn_id','','bet_amount','','win_amount','',NULL,'','user_id','action','{\"1\":\"bet\",\"2\":\"payout\",\"3\":\"cancel\"}',NULL,NULL,'SUM(bet_amount)','SUM(amount)',NULL,NULL,NULL,0,'SLOT',0),(3,'EVO','single',NULL,'EVO','evo',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'evo_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE WHEN action = 1 THEN amount ELSE 0 END',NULL,'CASE WHEN action = 2 THEN amount ELSE 0 END',NULL,NULL,'JSON_UNQUOTE(JSON_EXTRACT(game_detail, \"$.table.id\"))','user_id','action','{\"1\":\"bet\",\"2\":\"payout\"}',NULL,NULL,'SUM(\r\n    CASE \r\n        WHEN action = 1 THEN amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(\r\n    CASE \r\n        WHEN action = 2 THEN amount\r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN amount\r\n        ELSE 0 \r\n    END\r\n)','',NULL,NULL,1,'LIVE',0),(4,'JILI','single',NULL,'JILI','jili',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'jili_bet_log',NULL,'uid','memId','endTime','8','endTime_Unixt',NULL,'round','sessionId','beginGold','CASE WHEN action = 3 THEN -betAmount ELSE betAmount END','balance','winloseAmount','CASE \r\nWHEN `type` = \'EGAME\' THEN \r\n    CASE \r\n        WHEN `ACTION` = \'2\' THEN netWin \r\n        WHEN `ACTION` = \'3\' THEN cancel \r\n        ELSE 0 \r\n    END\r\nWHEN `type` = \'TABLE\' THEN netWin\r\nELSE 0 \r\nEND','jpWin','game','userId','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','round',NULL,'SUM(\n    CASE \n        WHEN `type` = \'EGAME\' THEN \n            CASE \n                WHEN `ACTION` = \'2\' THEN betAmount \n                WHEN `ACTION` = \'3\' THEN -betAmount \n                ELSE 0 \n            END\n        WHEN `type` = \'TABLE\' THEN \n            CASE \n                WHEN `ACTION` = \'1\' THEN betAmount\n                WHEN `ACTION` = \'2\' THEN betAmount \n                WHEN `ACTION` = \'3\' THEN -cancel \n                ELSE 0 \n            END \n        ELSE 0 \n    END\n)','SUM(\n                    CASE \n                        WHEN `type` = \'EGAME\' THEN \n                            CASE \n                                WHEN `ACTION` = \'2\' AND transaction_status!=\'cancel\' THEN winloseAmount-betAmount\n                                ELSE 0 \n                            END\n                        WHEN `type` = \'TABLE\' THEN \n                            CASE \n                                WHEN `ACTION` = \'2\' THEN winloseAmount \n                                WHEN `ACTION` = \'1\' THEN -betAmount\n                                WHEN `ACTION` = \'2\' THEN -betAmount\n                                WHEN `ACTION` = \'3\' THEN cancel \n                                ELSE 0 \n                            END \n                        ELSE 0 \n                    END\n                )  ','',NULL,'SUM(\r\n    CASE \r\n        WHEN `type` = \'EGAME\' THEN \r\n            CASE \r\n                WHEN `ACTION` = \'2\' THEN turnover \r\n                WHEN `ACTION` = \'3\' THEN -cancel \r\n                ELSE 0 \r\n            END\r\n        WHEN `type` = \'TABLE\' AND `ACTION` = \'2\' THEN \r\n            CASE \r\n                WHEN `ACTION` = \'1\' THEN turnover\r\n                WHEN `ACTION` = \'2\' THEN turnover \r\n                WHEN `ACTION` = \'3\' THEN -cancel \r\n                ELSE 0 \r\n            END \r\n        ELSE 0 \r\n    END\r\n)',0,'SLOT',0),(5,'EG','single',NULL,'EG','eg',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'eg_bet_log',NULL,'id','uid','modifyDate','8','timestamp',NULL,'mainTxID','subTxID',NULL,'CASE WHEN action = \'bet&payout\' THEN bet ELSE 0 END',NULL,'CASE WHEN action = \'bet&payout\' THEN win ELSE 0 END','CASE WHEN action = \'bet&payout\' THEN netWin ELSE 0 END',NULL,'gameID','username','action','{\"cancelBet\":\"cancel\",\"bet&payout\":\"result\"}','mainTxID',NULL,'SUM(CASE WHEN `action` != \'cancelBet\' THEN bet ELSE 0 END)','SUM(\n                    CASE \n                        WHEN action != \'cancelBet\' THEN netWin\n                        ELSE 0 \n                    END\n                )','action!=\'cancelBet\'',NULL,NULL,0,'SLOT',0),(6,'GR','transfer',NULL,'GR','GRtable,GRpvp,GRslot,GRfish',0,0,1,'12:00:00','15:00:00',0,0,0,0,0.10000000,0,NULL,NULL,NULL,NULL,NULL,NULL,'create_timeUnix',NULL,'game_round','sid',NULL,'valid_bet',NULL,NULL,'netWin',NULL,NULL,'',NULL,NULL,NULL,NULL,'sum(valid_bet)','sum(win)-sum(validbet)',NULL,NULL,NULL,0,'',0),(7,'BBIN','transfer',NULL,'BBIN','bbin',0,0,3,'13:00:00','15:00:00',1,0,0,0,0.10000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'win-validbet',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',0),(8,'RG','transfer',NULL,'RG','RG',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,NULL,NULL,NULL,NULL,'payout_at','8','payout_unix',NULL,'qishu','order_sn',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','status','{\"0\":\"bet\",\"1\":\"result\",\"2\":\"cancel\"}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',0),(9,'IMESPORTS','single',NULL,'IMESPORTS','imes',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'imes_bet_log',NULL,'id','uid','TimeStamp','8','TimeStamp_Unix',NULL,'BetId','OperatorTransactionId',NULL,'Amount',NULL,NULL,'CASE WHEN ActionId IN (\'4002\',\'4004\',\'1005\') THEN Amount WHEN ActionId in (\'1003\') THEN -Amount ELSE 0 END',NULL,NULL,'','ActionId','{\"1003\":\"bet\",\"1005\":\"cancel\",\"4002\":\"result\"}',NULL,NULL,'SUM(CASE WHEN ActionId = \'1003\' THEN Amount when ActionId = \'1005\' THEN -Amount ELSE 0 END)','SUM(CASE WHEN ActionId IN (\'4002\',\'4004\',\'1005\') THEN Amount WHEN ActionId in (\'1003\') THEN -Amount ELSE 0 END)','TransactionType IS null',NULL,NULL,0,'SPORT',0),(10,'SABA','single',NULL,'SABA','saba',0,0,0,'00:00:00','00:00:00',1,0,0,0,0.10000000,0,'saba_bet_log',NULL,'id','uid',NULL,NULL,'winlostDateTs',NULL,'txId','licenseeTxId',NULL,'actualAmount',NULL,NULL,'CASE WHEN action IN (\'settle\', \'resettle\', \'unsettle\') THEN COALESCE(creditAmount - debitAmount, 0) WHEN action IN (\'ConfirmBet\', \'ConfirmBetParlay\') THEN COALESCE(-actualAmount, 0) ELSE 0 END',NULL,NULL,'userId',NULL,NULL,NULL,NULL,'SUM(CASE  WHEN action = \'ConfirmBet\' OR action = \'ConfirmBetParlay\' THEN COALESCE(actualAmount, 0) ELSE 0 END)','SUM(CASE WHEN action IN (\'settle\', \'resettle\', \'unsettle\') THEN COALESCE(creditAmount - debitAmount, 0) WHEN action IN (\'ConfirmBet\', \'ConfirmBetParlay\') THEN COALESCE(-actualAmount, 0) ELSE 0 END)','winlostDate IS not NULL',NULL,NULL,0,'SPORT',0),(11,'DG','single',NULL,'DG','dg',0,0,4,'04:00:00','11:00:00',0,1,1,0,0.10000000,0,'dg_bet_log',NULL,'id','uid','createDate','8','ts',NULL,'ticketId','data',NULL,'CASE WHEN iaction = 1 then amount ELSE 0 END',NULL,'CASE WHEN iaction IN (2)  then amount ELSE 0 END','',NULL,NULL,'username','iaction','{\"1\":\"bet\",\"2\":\"payout\",\"3\":\"cancel\"}','ticketId',NULL,'SUM(case when iaction = 1 then -amount when iaction = 3 then amount ELSE 0 END )','SUM(case when iaction = 1 then amount when iaction IN (2, 3) then amount ELSE 0 END )','iaction != \'3\'',NULL,NULL,1,'LIVE',0),(12,'SEXY','single',NULL,'SEXY','sexy',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'sexy_bet_log',NULL,'id','uid','txTime','8','txTimeUnix',NULL,'roundId','platformTxId',NULL,'betAmount',NULL,'winAmount','winAmount-betAmount',NULL,NULL,'userId','CASE WHEN updateAction in (\'settle\',\'resettle\') THEN \'settle\' ELSE \'cancelBet\' END','{\"cancelBet\":\"cancel\",\"settle\":\"result\"}',NULL,NULL,'sum(betAmount)','sum(winAmount-betAmount)','updateAction in (\'settle\', \'resettle\')',NULL,'sum(turnover)',0,'LIVE',0),(13,'SALONG','single',NULL,'SALONG','salong',0,0,1,'10:00:00','12:00:00',1,1,1,0,0.10000000,0,'salong_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE WHEN action = 1 then amount WHEN action = 3 then amount ELSE 0 END',NULL,'CASE WHEN action in (2) then amount ELSE 0 END','',NULL,NULL,'user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}',NULL,NULL,'SUM(\r\n    CASE \r\n        WHEN action = 1 THEN  -amount\r\n        WHEN action = 3 THEN  -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(\r\n    CASE \r\n        WHEN action = 1 THEN  amount\r\n        WHEN action = 2 THEN  amount\r\n        WHEN action = 3 THEN  amount\r\n        ELSE 0 \r\n    END\r\n)\r\n',NULL,NULL,NULL,1,'LIVE',0),(14,'VSL','single',NULL,'VSL','vsl',0,0,0,'00:00:00','00:00:00',1,0,0,0,0.10000000,0,'vsl_bet_log',NULL,'id','uid','datetime','8',NULL,NULL,'cwTransId','requestId',NULL,'amt',NULL,NULL,'case when transType IN (510,501,502,503) then amt ELSE -amt END',NULL,NULL,'',NULL,NULL,NULL,NULL,'sum(case when transType = \'500\' then amt when transType = \'502\' then -amt ELSE 0 END)','sum(case when transType IN (510,501,502,503) then amt ELSE -amt END)','WLstatus != \'Cancel Bet\'',NULL,NULL,0,'',0),(15,'AG','single',NULL,'AG','ag',0,0,0,'00:00:00','00:00:00',1,0,0,0,0.10000000,0,'ag_bet_log',NULL,'id','uid','TimeStamp','8','TimeStamp_Unix',NULL,'RoundId','TransactionId',NULL,'Amount',NULL,NULL,'(CASE WHEN Type = \'Settle\' THEN Amount ELSE 0 END)-(CASE WHEN Type = \'Bet\' THEN Amount ELSE 0 END)',NULL,NULL,'',NULL,NULL,NULL,NULL,'SUM(CASE WHEN Type = \'Bet\' THEN Amount ELSE 0 END)','SUM(CASE WHEN Type = \'Settle\' THEN Amount ELSE 0 END)-SUM(CASE WHEN Type = \'Bet\' THEN Amount ELSE 0 END)','TransactionType IS NULL',NULL,NULL,0,'LIVE',0),(16,'XG','single',NULL,'XG','xg',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'xg_bet_log',NULL,'id','uid',NULL,NULL,'settle_time_unix',NULL,'bet_form_id','transaction_id',NULL,'bet_amount',NULL,NULL,'bet_amount+win_amount',NULL,NULL,'',NULL,NULL,NULL,NULL,'SUM(-bet_amount)','SUM(bet_amount+win_amount)','operation_new_code =2',NULL,NULL,0,'LIVE',0),(17,'EVOE','transfer',NULL,'EVOPLAY','EVOE',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,NULL,NULL,NULL,NULL,'startedAt','0','startedAtUnix',NULL,NULL,'id',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'SLOT',0),(18,'ALLBET','single',NULL,'ALLBET','allbet',0,0,1,'08:00:00','12:00:00',0,1,1,0,0.10000000,0,'allbet_bet_log','allbet_detail_log','id','member_info_uid',NULL,NULL,'betTimeUnix',NULL,'gameRoundId','tranId',NULL,'CASE WHEN a.status = 100 then betAmount ELSE 0 END',NULL,'','winOrLossAmount',NULL,NULL,'','status','{\"100\":\"bet\",\"110\":\"bet\",\"111\":\"result\",\"101\":\"cancel\"}',NULL,NULL,'sum(case when status = 100 then betAmount when status = 101 then -betAmount ELSE 0 END)','SUM(winOrLossAmount)',NULL,NULL,NULL,0,'LIVE',0),(19,'CQ9','single',NULL,'CQ9','cq9',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'cq9_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'amount',NULL,NULL,'amount',NULL,NULL,'user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"refund\"}','game_round_id','user_id as oem_order_detail_playerId','SUM(\r\nCASE \r\n    WHEN action = 1 THEN -amount\r\n    WHEN action = 3 THEN -amount\r\n    ELSE 0\r\nEND\r\n) ','SUM(amount)','',NULL,NULL,0,'SLOT',0),(20,'RICH88','single',NULL,'RICH88','rich88',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'rich88_bet_log',NULL,'uid','memId','createDate','8','timestamp',NULL,'round_id','record_id',NULL,'CASE \r\nWHEN `action` = \'withdraw\' AND transaction_status IS null THEN money  \r\nELSE 0 END',NULL,'CASE WHEN `action` = \'deposit\' THEN money ELSE 0 END','',NULL,'game_code','account','CASE WHEN transaction_status IS NOT NULL THEN transaction_status  ELSE action END','{\"deposit\":\"payout\",\"withdraw\":\"bet\",\"cancel\":\"cancel\"}','',NULL,'SUM(CASE WHEN `action` = \'withdraw\' AND transaction_status IS null THEN money ELSE 0 END)','SUM(CASE WHEN `action` = \'deposit\' THEN money ELSE 0 END)- SUM(CASE WHEN `action` = \'withdraw\' AND transaction_status IS null THEN money ELSE 0 END)','',NULL,NULL,1,'SLOT',0),(21,'WS168','single',NULL,'WS168','ws168',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'ws168_bet_log',NULL,'id','uid','settled_at','0',NULL,NULL,'round_id','slug',NULL,'amount',NULL,NULL,'(CASE WHEN amount >= 0 THEN amount ELSE 0 END)-(CASE WHEN amount < 0 THEN -amount ELSE 0 END)',NULL,NULL,'player',NULL,NULL,NULL,NULL,'SUM(CASE WHEN amount < 0 THEN -amount ELSE 0 END)','SUM(CASE WHEN amount >= 0 THEN amount ELSE 0 END)-SUM(CASE WHEN amount < 0 THEN -amount ELSE 0 END)','status != \'cancel\'',NULL,NULL,0,'SPORT',0),(22,'QTECH','single',NULL,'QTECH','qtech',0,0,0,'00:00:00','00:00:00',0,1,1,0,0.10000000,0,'qtech_bet_log',NULL,'id','uid',NULL,NULL,'createdUnix',NULL,'roundId','txnId',NULL,'CASE WHEN txnType = \'DEBIT\' THEN amount WHEN txnType = \'ROLLBACK\' THEN -amount ELSE 0 END',NULL,'CASE WHEN txnType = \'CREDIT\' THEN amount ELSE 0 END','',NULL,'gameId','playerId','txnType','{\"CREDIT\":\"payout\",\"DEBIT\":\"bet\",\"ROLLBACK\":\"cancel\"}','roundId',NULL,'SUM(CASE WHEN txnType = \'DEBIT\' THEN amount ELSE 0 END) - SUM(CASE WHEN txnType = \'ROLLBACK\' THEN amount ELSE 0 END)','SUM(CASE WHEN txnType = \'CREDIT\' THEN amount ELSE 0 END) - SUM(CASE WHEN txnType = \'DEBIT\' THEN amount ELSE 0 END) + SUM(CASE WHEN txnType = \'ROLLBACK\' THEN amount ELSE 0 END)',NULL,NULL,'SUM(CASE WHEN txnType = \'DEBIT\' THEN amount ELSE 0 END) - SUM(CASE WHEN txnType = \'ROLLBACK\' THEN amount ELSE 0 END)',1,'SLOT',0),(23,'V8','single',NULL,'V8','v8',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'v8_bet_log',NULL,'uid','memId','create_date','8','create_unix',NULL,'game_no','order_id',NULL,'amount',NULL,NULL,'(CASE WHEN type = \'1003\' THEN amount ELSE 0 END) - (CASE WHEN type = \'1002\' THEN amount ELSE 0 END)',NULL,NULL,'memId','type','{\"1003\":\"result\",\"1002\":\"bet\",\"1005\":\"cancel\"}',NULL,NULL,'SUM(\n                    CASE \n                        WHEN type = \'1002\' AND kind_id NOT IN (510) AND status = 0 THEN amount \n                        ELSE 0 \n                    END\n                )','SUM(CASE WHEN type = \'1003\' THEN amount ELSE 0 END) - \n                SUM(\n                    CASE \n                        WHEN type = \'1002\' AND kind_id NOT IN (510) AND status = 0 THEN amount \n                        ELSE 0 \n                    END\n                )\n                ','STATUS = 0',NULL,NULL,0,'SLOT',0),(24,'UG','single',NULL,'UG','ug',0,0,3,'13:00:00','15:00:00',0,0,0,0,0.10000000,0,'ug_bet_log',NULL,'id','uid',NULL,NULL,'timestamp',NULL,'ticketId','txnId',NULL,'amount',NULL,NULL,'(CASE WHEN status = 2 THEN amount ELSE 0 END)-(CASE WHEN status = 1 THEN -amount ELSE 0 END)',NULL,NULL,'userId','status','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','ticketId','userId as oem_order_detail_playerId','SUM(CASE WHEN status = 1 THEN -amount ELSE 0 END)','SUM(CASE WHEN status = 2 THEN amount ELSE 0 END)-SUM(CASE WHEN status = 1 THEN -amount ELSE 0 END)',NULL,NULL,NULL,0,'SPORT',0),(25,'GB','single',NULL,'HC','gb',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'gb_bet_log',NULL,'id','memberInfo_uid',NULL,NULL,'timestamp',NULL,'mainOrderNo','orderNo',NULL,'bet',NULL,NULL,'totalWin',NULL,NULL,'',NULL,NULL,'orderNo',NULL,'SUM(CASE WHEN gameCode != \'fish-GetRichFishing\' THEN bet ELSE 0 END)','SUM(totalWin)','cancelAmount is null',NULL,NULL,0,'SLOT',0),(26,'IMSPRIBE','single',NULL,'IMSPRIBE','spribe',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'spribe_bet_log',NULL,'id','uid','TimeStamp','8','TimeStamp_Unix',NULL,'RoundId','TransactionId',NULL,'Amount',NULL,NULL,'(CASE WHEN Type = \'Settle\' THEN Amount ELSE 0 END) - (CASE WHEN Type = \'Bet\' THEN Amount ELSE 0 END)',NULL,NULL,'','CASE WEHN TransactionType IS NOT NULL THEN TransactionType ELSE Type END','{\"Bet\":\"bet\",\"Settle\":\"result\",\"Cancel\":\"cancel\"}',NULL,NULL,'SUM(CASE WHEN Type = \'Bet\' THEN Amount ELSE 0 END)','SUM(CASE WHEN Type = \'Settle\' THEN Amount ELSE 0 END)-SUM(CASE WHEN Type = \'Bet\' THEN Amount ELSE 0 END)','TransactionType IS NULL',NULL,NULL,0,'SLOT',0),(27,'SC','transfer',NULL,'SC','SC',0,0,0,'00:00:00','00:00:00',1,0,0,0,0.10000000,0,NULL,NULL,NULL,NULL,'time','8','time_unix',NULL,'issue','project_id',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',0),(28,'WINWIN','transfer',NULL,'WINWIN','winwin',0,0,0,'00:00:00','00:00:00',1,0,0,0,0.10000000,0,NULL,NULL,NULL,NULL,'bet_time','8','bet_unix',NULL,'number','bid',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',0),(29,'C911','single',NULL,'C911','c911',0,1,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'c911_bet_log',NULL,'id','uid','modifyDate','8','timestamp',NULL,'mainTxID','subTxID',NULL,'bet',NULL,NULL,'netWin',NULL,NULL,'username','action','{\"cancelBet\":\"cancel\",\"bet&payout\":\"result\"}','mainTxID',NULL,'SUM(\n                    CASE \n                        WHEN action != \'cancelBet\' THEN bet\n                        ELSE 0 \n                    END\n                )','SUM(\n                    CASE \n                        WHEN action != \'cancelBet\' THEN netWin\n                        ELSE 0 \n                    END\n                )','action!=\'cancelBet\'',NULL,NULL,0,'SLOT',0),(30,'BIGPOT','single',NULL,'BIGPOT','bigpot',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'bigpot_bet_log',NULL,'id','uid',NULL,NULL,'time',NULL,'gameId','transactionId',NULL,'CASE WHEN action = 1 THEN amount ELSE 0 END',NULL,'winning','',NULL,'tname','account','action','{\"1\":\"bet\",\"2\":\"payout\",\"3\":\"cancel\"}','CASE WHEN gcode = \'SLOT\' THEN gameId ELSE transactionId END',NULL,'SUM(CASE WHEN ACTION = 1 THEN COALESCE(amount, 0) ELSE 0 END)','SUM(CASE WHEN ACTION = 2 THEN COALESCE(winning, 0) WHEN ACTION = 1 THEN COALESCE(-amount, 0) ELSE 0 END)',NULL,NULL,NULL,1,'SLOT',0),(31,'CMD','single',NULL,'CMD','cmd',0,0,0,'00:00:00','00:00:00',1,0,0,0,0.10000000,0,'cmd_bet_log',NULL,'id','uid',NULL,NULL,'dateSentTs',NULL,'ReferenceNo','packageId',NULL,'TransactionAmount ',NULL,NULL,'TransactionAmount',NULL,NULL,'',NULL,NULL,NULL,NULL,'SUM(CASE WHEN ActionId = 1003 THEN -TransactionAmount ELSE 0 END) ','SUM(TransactionAmount)',NULL,NULL,NULL,0,'SPORT',0),(32,'PNG','single',NULL,'PNG','png',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'png_bet_log',NULL,'uid','memId','betTime',NULL,'betTimeUnix',NULL,'GamesessionId','transactionId',NULL,'TotalLoss',NULL,NULL,'winOrLoss',NULL,NULL,'','Status','{\"0\":\"bet\",\"1\":\"result\"}',NULL,NULL,'SUM(TotalLoss)','SUM(winOrLoss)',' action=\'release\' AND NumRounds!=\'\'',NULL,NULL,0,'SLOT',0),(33,'DNASlot','single',NULL,'DNASlot','dnaslot',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'dnaslot_betlog',NULL,'uid','memId','createDate',NULL,'timestamp',NULL,'order_id','order_id',NULL,'betPoint',NULL,NULL,'winPoint',NULL,'','',NULL,NULL,NULL,NULL,'SUM(betPoint)','SUM(winPoint)','is_over=1',NULL,NULL,0,'SLOT',0),(34,'FC','single',NULL,'FC','fc',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'fc_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\nWHEN `action_type` = \'multiple\' THEN \r\n    CASE \r\n        WHEN `action` = \'1\' THEN Bet \r\n        WHEN `action` = \'3\' THEN -amount \r\n        ELSE 0 \r\n    END\r\nELSE \r\nCASE \r\n WHEN `action` = \'2\' THEN Bet \r\n WHEN `action` = \'3\' THEN -Bet \r\nELSE 0 \r\nEND\r\nEND',NULL,'Win','CASE \r\nWHEN `GameId` IN (\'27007\',\'28001\',\'27008\',\'27009\') THEN \r\n    CASE \r\n        WHEN `action` = \'1\' THEN NetWin\r\n        WHEN `action` = \'2\' THEN NetWin\r\n        ELSE 0 \r\n    END\r\nELSE \r\nCASE \r\n WHEN `action` = \'2\' THEN NetWin \r\n WHEN `action` = \'3\' THEN amount \r\nELSE 0 \r\nEND\r\nEND',NULL,'GameID','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\",\"4\":\"event\"}','game_round_id','user_id as oem_order_detail_playerId','SUM(\r\n    CASE \r\n        WHEN action = 2 THEN Bet\r\n        WHEN action = 3 THEN -Bet\r\n        ELSE 0 \r\n    END\r\n)','SUM(amount)','',NULL,'SUM(\r\n    CASE \r\n        WHEN action = 2 THEN RequireAmt\r\n        WHEN action = 3 THEN -RequireAmt\r\n        ELSE 0 \r\n    END\r\n)',0,'SLOT',0),(35,'FTG','single',NULL,'FTG','ftg',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'ftg_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE WHEN action = 1 then -amount WHEN action = 3 then -amount ELSE 0 END',NULL,'CASE WHEN action = 2 then amount ELSE 0 END','',NULL,'game_id','user_id','action','{\"1\":\"bet\",\"2\":\"payout\",\"3\":\"cancel\"}','game_round_id','game_id as oem_order_detail_gameId','SUM(\r\n    CASE \r\n        WHEN (action = 1 OR action = 3) AND game_id != 248 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(amount)','',NULL,'',1,'SLOT',0),(36,'DS88','single',NULL,'DS88','ds88',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'ds88_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'amount',NULL,'amount','amount',NULL,NULL,'user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','game_round_id','','SUM(\r\n        CASE \r\n            WHEN action = 1 THEN -amount\r\n            WHEN action = 3 THEN -amount\r\n            ELSE 0\r\n        END\r\n        ) ','SUM(amount)','',NULL,'',0,'SLOT',0),(37,'KA','single',NULL,'KA','ka',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'ka_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\n    WHEN freeGames = \'true\' THEN 0 \r\n    ELSE \r\n        CASE \r\n            WHEN action = \'2\' THEN betAmount \r\n            WHEN action = \'3\' THEN -betAmount \r\n        END \r\nEND',NULL,'winAmount','amount',NULL,'gameId','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','game_round_id','gameId as oem_order_detail_gameId','SUM(\r\n        CASE \r\n            WHEN freeGames = false THEN betAmount\r\n            WHEN action = 3 THEN -betAmount\r\n            ELSE 0\r\n        END\r\n        ) ','SUM(amount)','',NULL,'',0,'SLOT',0),(38,'DCS','single',NULL,'DCS','dcs',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'dcs_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'amount',NULL,'amount','amount',NULL,'game_id','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','game_round_id','provider as oem_order_detail_gameId,user_id as oem_order_detail_playerId','SUM(\r\n        CASE \r\n            WHEN action = 1 THEN -amount\r\n            WHEN action = 3 THEN -amount\r\n            ELSE 0\r\n        END\r\n        ) ','SUM(amount)','',NULL,'',0,'SLOT',0),(39,'JDB','single',NULL,'JDB','jdb',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'jdb_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'\r\nCASE \r\nWHEN `action_type` = \'single\' THEN \r\n    CASE \r\n        WHEN `action` = \'2\' THEN -bet \r\n        WHEN `action` = \'3\' THEN bet \r\n        ELSE 0 \r\n    END\r\nWHEN `action_type` = \'multiple\' THEN \r\n 	CASE \r\n 		  WHEN `action` = \'1\' THEN -amount\r\n 		  WHEN `action` = \'3\' THEN -amount\r\n        ELSE 0 \r\n    END\r\nELSE 0 \r\nEND\r\n',NULL,'win','amount',NULL,'mType','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','historyId','gType as oem_order_detail_gameId,user_id as oem_order_detail_playerId','SUM(\r\n   CASE \r\nWHEN `action_type` = \'single\' THEN \r\n    CASE \r\n        WHEN `action` = \'2\' THEN -bet \r\n        WHEN `action` = \'3\' THEN bet \r\n        ELSE 0 \r\n    END\r\nWHEN `action_type` = \'multiple\' THEN \r\n 	CASE \r\n 		  WHEN `action` = \'1\' THEN -amount\r\n 		  WHEN `action` = \'3\' THEN -amount\r\n        ELSE 0 \r\n    END\r\nELSE 0 \r\nEND\r\n)','SUM(\r\n   CASE \r\n	WHEN `action_type` = \'single\' THEN \r\n	    CASE \r\n	        WHEN `action` = \'2\' THEN netWin \r\n	        WHEN `action` = \'3\' THEN -netWin \r\n	        ELSE 0 \r\n	    END\r\n	WHEN `action_type` = \'multiple\' THEN \r\n	 	CASE \r\n	 		  WHEN `action` = \'2\' THEN netWin\r\n	        ELSE 0 \r\n	    END\r\n	ELSE 0 \r\n END\r\n)','',NULL,'',0,'SLOT',0),(40,'MW','single',NULL,'MW','mw',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'mw_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\nWHEN action = 1 THEN -amount\r\nWHEN action = 3 THEN -amount\r\nELSE 0 \r\nEND\r\n',NULL,'CASE \r\nWHEN action = 2 THEN amount\r\nELSE 0 \r\nEND\r\n','',NULL,'gameId','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','game_round_id','gameId as oem_order_detail_gameId','SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(amount)','',NULL,'',1,'SLOT',0),(41,'MKBINGO(TRANS)','transfer',NULL,'BINGO','bingo',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.10000000,0,'bingo_bet_log',NULL,'uid','member_info_uid','bet_time','8','bet_time_unix',NULL,'round_id','txn_id',NULL,'bet_amount','','win_lose_amount+bet_amount','win_lose_amount',NULL,'game_type','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','','game_type as oem_order_detail_gameId','sum(bet_amount)','sum(win_lose_amount)','',NULL,'',1,'BINGO',0),(42,'PP','single',NULL,'PP','PP',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.00000000,0,'pp_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\nWHEN action = 1 THEN -amount\r\nWHEN action = 3 THEN -amount\r\nELSE 0 \r\nEND\r\n',NULL,'CASE \r\nWHEN action = 2 THEN amount\r\nELSE 0 \r\nEND\r\n','',NULL,'gameId','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','game_round_id','gameId as oem_order_detail_gameId,user_id as oem_order_detail_playerId','SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(amount)','',NULL,'',1,'SLOT',3),(43,'SIMPLEPLAY','single',NULL,'SIMPLEPLAY','simpleplay',0,0,0,'00:00:00','00:00:00',0,1,1,0,0.10000000,0,'simpleplay_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\nWHEN action = 1 THEN -amount\r\nWHEN action = 3 THEN -amount\r\nELSE 0 \r\nEND\r\n',NULL,'CASE \r\nWHEN action = 2 THEN amount\r\nELSE 0 \r\nEND\r\n','',NULL,'gamecode',NULL,'action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','CASE WHEN\r\ngametype = \'slot\' then game_round_id\r\nelse\r\nNULL\r\nend','','SUM(\r\n    CASE \r\n        WHEN action = 2 THEN bet_amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(winlose_amount)','',NULL,'sum(vaild_bet_amount)',1,'SLOT',0),(45,'BNG','single',NULL,'BNG','bng',0,0,0,'00:00:00','00:00:00',0,1,1,0,0.10000000,0,'bng_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'bet',NULL,'win','',NULL,'','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','','','SUM(bet)','SUM(amount)','',NULL,'SUM(bet)',1,'SLOT',1),(46,'T1','single',NULL,'T1','t1',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.00000000,0,'t1_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\nWHEN action = 1 THEN -amount\r\nWHEN action = 3 THEN -amount\r\nELSE 0 \r\nEND\r\n',NULL,'CASE \r\nWHEN action = 2 THEN amount\r\nELSE 0 \r\nEND\r\n','',NULL,'game_code',NULL,'action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','','','SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(amount)','',NULL,'SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)',1,'SLOT',1),(47,'MKBINGO','single',NULL,'MKBINGO','mkbingo',0,0,0,'00:00:00','00:00:00',0,0,0,0,0.00000000,0,'mkbingo_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\nWHEN action = 1 THEN -amount\r\nWHEN action = 3 THEN -amount\r\nELSE 0 \r\nEND\r\n',NULL,'CASE \r\nWHEN action = 2 THEN amount\r\nELSE 0 \r\nEND\r\n','',NULL,'gameId','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','','','SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(amount)','',NULL,'',1,'BINGO',0),(48,'SUPER','transfer',NULL,'SUPER','super',0,0,0,'00:00:00','00:00:00',1,1,1,0,0.10000000,0,'super_bet_log',NULL,'uid','member_info_uid','bet_time',NULL,'bet_time_unix',NULL,'txn_id','txn_id',NULL,'bet_amount',NULL,NULL,'win_lose_amount',NULL,NULL,NULL,'action','{\"0\":\"bet\",\"1\":\"result\",\"3\":\"cancel\"}',NULL,NULL,'SUM(bet_amount)','SUM(win_lose_amount)',NULL,NULL,'sum(valid_bet_amount)',0,'SPORT',0),(49,'T9','transfer',NULL,'T9','t9',0,0,0,'00:00:00','00:00:00',0,1,1,0,0.10000000,0,'wg_bet_log',NULL,'uid','member_info_uid','bet_time',NULL,'bet_time_unix',NULL,'round_id','txn_id',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SUM(bet_amount)','SUM(win_lose_amount)',NULL,NULL,NULL,1,'LIVE',0),(50,'RSG','single',NULL,'RSG','rsg',0,0,0,'00:00:00','00:00:00',0,1,1,0,0.00000000,0,'rsg_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\nWHEN action = 1 THEN -amount\r\nWHEN action = 3 THEN -amount\r\nELSE 0 \r\nEND\r\n',NULL,'CASE \r\nWHEN action = 2 THEN amount\r\nELSE 0 \r\nEND\r\n','',NULL,'','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','game_round_id','GameId as oem_order_detail_gameId,user_id as oem_order_detail_playerId','SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(amount)','',NULL,'SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)',1,'SLOT',1),(51,'ATG','single',NULL,'ATG','atg',0,0,0,'00:00:00','00:00:00',0,1,1,0,0.00000000,0,'atg_bet_log',NULL,'uid','member_info_uid','txn_date','8','txn_date_unix',NULL,'game_round_id','txn_id',NULL,'CASE \r\nWHEN action = 1 THEN -amount\r\nWHEN action = 3 THEN -amount\r\nELSE 0 \r\nEND\r\n',NULL,'CASE \r\nWHEN action = 2 THEN amount\r\nELSE 0 \r\nEND\r\n','',NULL,'','user_id','action','{\"1\":\"bet\",\"2\":\"result\",\"3\":\"cancel\"}','','','SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)','SUM(amount)','',NULL,'SUM(\r\n    CASE \r\n        WHEN action = 1 THEN -amount\r\n        WHEN action = 3 THEN -amount\r\n        ELSE 0 \r\n    END\r\n)',1,'SLOT',1);
/*!40000 ALTER TABLE `all_platform` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-01-20 19:22:23
