CREATE TABLE `dist_type` (
  `id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(45) DEFAULT '',
  `create_dt` datetime DEFAULT current_timestamp(),
  `update_dt` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Distributor type definition table';

INSERT INTO `dist_type` (`id`, `name`, `create_dt`, `update_dt`) VALUES ('0', '기본', '2022-09-29 23:35:34', '2022-09-29 23:35:34');
INSERT INTO `dist_type` (`id`, `name`, `create_dt`, `update_dt`) VALUES ('1', '죽장', '2022-09-29 23:35:34', '2022-09-29 23:35:34');
INSERT INTO `dist_type` (`id`, `name`, `create_dt`, `update_dt`) VALUES ('2', '롤링', '2022-09-29 23:35:34', '2022-09-29 23:35:34');
INSERT INTO `dist_type` (`id`, `name`, `create_dt`, `update_dt`) VALUES ('3', '배너', '2022-09-29 23:35:35', '2022-09-29 23:35:35');

ALTER TABLE `member` 
ADD COLUMN `dist_type` TINYINT(4) NULL DEFAULT 0 COMMENT '총판 유형 : 0 기본, 1: 죽장, 2: 롤링, 3: 배너 ' AFTER `info_change_dt`;