CREATE TABLE `tb_user_salvation` (
  `member_idx` int(11) NOT NULL DEFAULT 0,
  `charge` int(11) DEFAULT 0,
  `charge_count` int(11) DEFAULT 0,
  `exchange` int(11) DEFAULT 0,
  `update_dt` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `create_dt` datetime DEFAULT current_timestamp(),
  `last_charge` int(11) DEFAULT 0,
  `last_exchange` int(11) DEFAULT 0,
  `last_charge_count` int(11) DEFAULT 0,
  PRIMARY KEY (`member_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE `tb_user_salvation_list` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `member_idx` int(11) NOT NULL DEFAULT 0,
  `reward` int(11) NOT NULL DEFAULT 0,
  `is_display` enum('Y','N') DEFAULT 'N',
  `is_sound` enum('Y','N') DEFAULT 'N',
  `display_dt` datetime DEFAULT current_timestamp(),
  `update_dt` datetime DEFAULT current_timestamp(),
  `create_dt` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`idx`),
  KEY `mb_idx_up` (`member_idx`,`update_dt`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
