YES8

CREATE TABLE `register_channel_coding` (

  `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '表ID',

  `agent_id` BIGINT NOT NULL COMMENT '站点ID',

  `reg_code` VARCHAR(100)  DEFAULT NULL COMMENT '渠道编码',

  `reg_name` VARCHAR(100)  DEFAULT NULL COMMENT '渠道名字',

	`click_amount` BIGINT DEFAULT NULL COMMENT '点击数量',

  `reg_amount` BIGINT DEFAULT NULL COMMENT '注册数量',

  `create_by` VARCHAR(50)  DEFAULT NULL COMMENT '创建人',

  `create_time` DATETIME DEFAULT NULL COMMENT '创建时间',

  `update_by` VARCHAR(50)  DEFAULT NULL COMMENT '更新人',

  `update_time` DATETIME DEFAULT NULL COMMENT '更新时间',

  PRIMARY KEY (`id`),             

   UNIQUE INDEX `idx_agent_id_reg_code` (`agent_id`, `reg_code`) 

) ENGINE=InnoDB AUTO_INCREMENT=1 ;

ALTER TABLE game_oc_player_attach_info ADD COLUMN reg_code VARCHAR(30)  DEFAULT NULL COMMENT '渠道编码';