
DROP TABLE IF EXISTS `t_adm_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_adm_log` (
  `idx` int unsigned NOT NULL AUTO_INCREMENT,
  `day` varchar(2) NOT NULL,
  `a_id` varchar(50) NOT NULL,
  `a_ip` varchar(30) DEFAULT NULL,
  `a_country` varchar(50) DEFAULT NULL,
  `is_login` enum('Y','N','') DEFAULT NULL,
  `member_idx` bigint unsigned DEFAULT '0',
  `member_id` varchar(20) DEFAULT NULL,
  `log_data` text,
  `ac_code` int unsigned DEFAULT '0' COMMENT 't_log_cash와 동일',
  `reg_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `idx` (`idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='관리자 로그'
/*!50500 PARTITION BY LIST  COLUMNS(`day`)
(PARTITION t_adm_log_01 VALUES IN ('01') ENGINE = InnoDB,
 PARTITION t_adm_log_02 VALUES IN ('02') ENGINE = InnoDB,
 PARTITION t_adm_log_03 VALUES IN ('03') ENGINE = InnoDB,
 PARTITION t_adm_log_04 VALUES IN ('04') ENGINE = InnoDB,
 PARTITION t_adm_log_05 VALUES IN ('05') ENGINE = InnoDB,
 PARTITION t_adm_log_06 VALUES IN ('06') ENGINE = InnoDB,
 PARTITION t_adm_log_07 VALUES IN ('07') ENGINE = InnoDB,
 PARTITION t_adm_log_08 VALUES IN ('08') ENGINE = InnoDB,
 PARTITION t_adm_log_09 VALUES IN ('09') ENGINE = InnoDB,
 PARTITION t_adm_log_10 VALUES IN ('10') ENGINE = InnoDB,
 PARTITION t_adm_log_11 VALUES IN ('11') ENGINE = InnoDB,
 PARTITION t_adm_log_12 VALUES IN ('12') ENGINE = InnoDB,
 PARTITION t_adm_log_13 VALUES IN ('13') ENGINE = InnoDB,
 PARTITION t_adm_log_14 VALUES IN ('14') ENGINE = InnoDB,
 PARTITION t_adm_log_15 VALUES IN ('15') ENGINE = InnoDB,
 PARTITION t_adm_log_16 VALUES IN ('16') ENGINE = InnoDB,
 PARTITION t_adm_log_17 VALUES IN ('17') ENGINE = InnoDB,
 PARTITION t_adm_log_18 VALUES IN ('18') ENGINE = InnoDB,
 PARTITION t_adm_log_19 VALUES IN ('19') ENGINE = InnoDB,
 PARTITION t_adm_log_20 VALUES IN ('20') ENGINE = InnoDB,
 PARTITION t_adm_log_21 VALUES IN ('21') ENGINE = InnoDB,
 PARTITION t_adm_log_22 VALUES IN ('22') ENGINE = InnoDB,
 PARTITION t_adm_log_23 VALUES IN ('23') ENGINE = InnoDB,
 PARTITION t_adm_log_24 VALUES IN ('24') ENGINE = InnoDB,
 PARTITION t_adm_log_25 VALUES IN ('25') ENGINE = InnoDB,
 PARTITION t_adm_log_26 VALUES IN ('26') ENGINE = InnoDB,
 PARTITION t_adm_log_27 VALUES IN ('27') ENGINE = InnoDB,
 PARTITION t_adm_log_28 VALUES IN ('28') ENGINE = InnoDB,
 PARTITION t_adm_log_29 VALUES IN ('29') ENGINE = InnoDB,
 PARTITION t_adm_log_30 VALUES IN ('30') ENGINE = InnoDB,
 PARTITION t_adm_log_31 VALUES IN ('31') ENGINE = InnoDB) */;
/*!40101 SET character_set_client = @saved_cs_client */;