CREATE TABLE `tb_static_reg_first_charge` (
  `idx` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_0_flag` enum('ON','OFF') DEFAULT 'ON',
  `reg_first_charge_0_desc` varchar(128) DEFAULT '',
  `reg_first_charge_1` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_1_max` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_1_desc` varchar(128) DEFAULT '',
  `reg_first_charge_1_flag` enum('ON','OFF') DEFAULT 'ON',
  `reg_first_charge_2` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_2_max` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_2_desc` varchar(128) DEFAULT '',
  `reg_first_charge_2_flag` enum('ON','OFF') DEFAULT 'ON',
  `reg_first_charge_3` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_3_max` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_3_desc` varchar(128) DEFAULT '',
  `reg_first_charge_3_flag` enum('ON','OFF') DEFAULT 'ON',
  `reg_first_charge_4` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_4_max` int(11) NOT NULL DEFAULT 0,
  `reg_first_charge_4_desc` varchar(128) DEFAULT '',
  `reg_first_charge_4_flag` enum('ON','OFF') DEFAULT 'ON',
  `deposit_plus_1_charge` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_1_bonus` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_1_flag` enum('ON','OFF') DEFAULT 'ON',
  `deposit_plus_2_charge` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_2_bonus` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_2_flag` enum('ON','OFF') DEFAULT 'ON',
  `deposit_plus_3_charge` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_3_bonus` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_3_flag` enum('ON','OFF') DEFAULT 'ON',
  `deposit_plus_4_charge` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_4_bonus` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_4_flag` enum('ON','OFF') DEFAULT 'ON',
  `deposit_plus_5_charge` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_5_bonus` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_5_flag` enum('ON','OFF') DEFAULT 'ON',
  `deposit_plus_6_charge` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_6_bonus` int(11) NOT NULL DEFAULT 0,
  `deposit_plus_6_flag` enum('ON','OFF') DEFAULT 'ON',
  `exchange_desc` varchar(128) DEFAULT '',
  `bonus_desc` varchar(128) DEFAULT '',
  `update_dt` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`idx`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='가입첫충 관리 테이블';

INSERT INTO `tb_static_reg_first_charge` (`idx`) VALUES ('1');

ALTER TABLE `member_money_charge_history` 
ADD COLUMN `reg_first_charge` INT(11) NULL DEFAULT 1 AFTER `bonus_level`;

-- 겜블3사
/*ALTER TABLE `member_money_charge_history` 
CHANGE COLUMN `bonus_money` `bonus_money` INT(11) NULL DEFAULT 0 ;*/