SET @member_idx = 131;

-- casino
-- INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '170700', '84000', '-84000', '1', '1', '680883260710613531', '2023-04-11 16:45:13', '2023-04-11 16:45:23', '0');
INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '100700', '70000', '70000', '1', '1', '680883260706980531', '2023-04-11 16:44:22', '2023-04-11 16:44:29', '0');
INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '100700', '73000', '0', '1', '1', '680883260704752531', '2023-04-11 16:43:57', '2023-04-11 16:44:03', '0');
INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '260110', '40000', '-40000', '1', '3', '680779597351203187', '2023-04-11 15:45:23', '2023-04-11 15:45:39', '0');
INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '296110', '36000', '-36000', '1', '3', '680779597348417187', '2023-04-11 15:44:38', '2023-04-11 15:44:57', '0');
INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '294110', '34000', '2000', '1', '3', '680779597345437187', '2023-04-11 15:43:54', '2023-04-11 15:44:11', '0');
INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '330110', '36000', '-36000', '1', '3', '680779597341239187', '2023-04-11 15:43:06', '2023-04-11 15:43:27', '0');
INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '123300', '30000', '30000', '1', '1', '680883242099785406', '2023-04-11 15:42:44', '2023-04-11 15:42:49', '0');
INSERT INTO `KP_CSN_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '208110', '40000', '122000', '1', '3', '680779597338597187', '2023-04-11 15:42:23', '2023-04-11 15:42:39', '0');

-- slot
INSERT INTO `KP_SLOT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '3020600', '340000', '-180880', '200', '181', '64351aeb61e2704fcd0d0944', '2023-04-11 17:31:39', '2023-04-11 17:32:22', '0');
INSERT INTO `KP_SLOT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '3024000', '3400', '-3400', '200', '181', '64351ae9d783a753a268a847', '2023-04-11 17:31:37', '2023-04-11 17:31:38', '0');
INSERT INTO `KP_SLOT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '1300', '1000', '-1000', '228', '23', '248307143803443786', '2023-04-11 15:07:23', '2023-04-11 15:07:24', '0');
INSERT INTO `KP_SLOT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '5300', '1000', '2000', '228', '23', '248307111203443786', '2023-04-11 15:06:46', '2023-04-11 15:06:47', '0');
INSERT INTO `KP_SLOT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '1083948', '1000000', '-790000', '200', '181', '6434f71eda942d5c98fb04c6', '2023-04-11 14:58:55', '2023-04-11 14:59:38', '0');
INSERT INTO `KP_SLOT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '1930948', '1000000', '-725000', '200', '181', '6434f69661e2704fcdec84a8', '2023-04-11 14:56:38', '2023-04-11 14:57:43', '0');
INSERT INTO `KP_SLOT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '2665056', '472000', '-390108', '200', '181', '6434f50b9f792a0e2854684a', '2023-04-11 14:50:03', '2023-04-11 14:50:41', '0');
INSERT INTO `KP_SLOT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '21300', '1000', '-1000', '228', '23', '248306295503443786', '2023-04-11 14:49:19', '2023-04-11 14:49:19', '0');

-- esport
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `IS_CALC`) VALUES ('B', @member_idx, '703203', '300000', '-300000', '101', '0', 'TES20230411163627013nj2YBCwS', '2023-04-11 17:36:27', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '368918', '50000', '15450', '101', '0', 'TES20230411162330266Fol1UPFE', '2023-04-11 17:23:30', '2023-04-11 17:30:14', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '400000', '31082', '9729', '101', '0', 'TES202304111623247055zqth6r3', '2023-04-11 17:23:24', '2023-04-11 17:30:14', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '459951', '59951', '-59951', '101', '0', 'TES20230411162150262odHtMEem', '2023-04-11 17:21:50', '2023-04-11 17:30:14', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '509951', '50000', '-50000', '101', '0', 'TES20230411162139085pAzo7JjR', '2023-04-11 17:21:39', '2023-04-11 17:30:14', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '51429', '51429', '-51429', '101', '0', 'TES20230411160002865MyLlMAic', '2023-04-11 17:00:02', '2023-04-11 18:38:33', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('L', @member_idx, '190160', '138731', '-138731', '101', '0', 'TES20230411155957506ugb6vbrb', '2023-04-11 16:59:57', '2023-04-11 18:38:33', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `IS_CALC`) VALUES ('B', @member_idx, '1046000', '100000', '-100000', '101', '0', 'TES20230411154301555kwRhCMvP', '2023-04-11 16:43:01', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '57759', '57759', '40143', '101', '0', 'TES20230411152034558WCI1EnJd', '2023-04-11 16:20:34', '2023-04-11 17:01:53', '0');
INSERT INTO `KP_ESPT_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_ID`, `GAME_ID`, `TRX_ID`, `REG_DTM`, `MOD_DTM`, `IS_CALC`) VALUES ('W', @member_idx, '138736', '80977', '56603', '101', '0', 'TES20230411152031048EjzKGEdj', '2023-04-11 16:20:31', '2023-04-11 17:01:53', '0');

-- hash
INSERT INTO `OD_HASH_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_TYPE`, `WAVE`, `REG_DTM`, `MOD_DTM`, `IS_CALC`, `CH_CODE`) VALUES ('W', @member_idx, '303710', '303000', '281790', 'B', '721601', '2023-04-11 17:03:02', '2023-04-11 17:03:32', '0', '01');
INSERT INTO `OD_HASH_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_TYPE`, `WAVE`, `REG_DTM`, `MOD_DTM`, `IS_CALC`, `CH_CODE`) VALUES ('L', @member_idx, '518710', '215000', '-215000', 'B', '721600', '2023-04-11 17:02:24', '2023-04-11 17:05:00', '0', '01');
INSERT INTO `OD_HASH_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_TYPE`, `WAVE`, `REG_DTM`, `MOD_DTM`, `IS_CALC`, `CH_CODE`, `BT_TYPE`, `BT_TYPE_LB`) VALUES ('L', @member_idx, '15800', '10000', '-10000', 'H', '960718', '2023-04-11 15:05:05', '2023-04-11 15:10:00', '0', '', 'NUM_L', '3~8');
INSERT INTO `OD_HASH_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_TYPE`, `WAVE`, `REG_DTM`, `MOD_DTM`, `IS_CALC`, `CH_CODE`, `BT_TYPE`, `BT_TYPE_LB`) VALUES ('W', @member_idx, '25800', '10000', '9500', 'H', '960718', '2023-04-11 15:05:04', '2023-04-11 15:05:23', '0', '', 'BLACK', 'BLACK');
INSERT INTO `OD_HASH_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_TYPE`, `WAVE`, `REG_DTM`, `MOD_DTM`, `IS_CALC`, `CH_CODE`) VALUES ('W', @member_idx, '92689', '10000', '9300', 'B', '721041', '2023-04-11 10:36:47', '2023-04-11 10:37:17', '0', '01');
INSERT INTO `OD_HASH_BET_HIST` (`TYPE`, `MBR_IDX`, `HLD_MNY`, `BET_MNY`, `RSLT_MNY`, `PRD_TYPE`, `WAVE`, `REG_DTM`, `MOD_DTM`, `IS_CALC`, `CH_CODE`) VALUES ('L', @member_idx, '14900', '30000', '-30000', 'R', '827121', '2023-04-11 09:40:42', '2023-04-11 09:45:00', '0', '');
