~~~ CREATE TABLE `ims_ewei_shop_unionpay_agent` ( `upid` int(10) NOT NULL COMMENT '会员ID', `uniacid` int(10) DEFAULT NULL COMMENT '公众号ID', `upagentid` int(10) DEFAULT NULL COMMENT '上级ID', `upagentlevel` int(3) DEFAULT NULL COMMENT '银联代理等级', `hnapay_lock` tinyint(1) DEFAULT NULL COMMENT '新生锁定', `hnapay_realname` varchar(20) DEFAULT NULL COMMENT '新生机构名', `hnapay_channelId` varchar(20) DEFAULT NULL COMMENT '新生机构编号', `hnapay_secret` varchar(32) DEFAULT NULL COMMENT '新生机构密钥', `hnapay_feilv` decimal(10,4) DEFAULT NULL COMMENT '新生结算费率', `hnapay_upfeilv` decimal(10,4) DEFAULT NULL COMMENT '新生银联>1000结算费率', `newland_lock` tinyint(1) DEFAULT NULL COMMENT '新大陆锁定', `newland_realname` varchar(20) DEFAULT NULL COMMENT '新大陆机构名', `newland_channelId` varchar(20) DEFAULT NULL COMMENT '新大陆机构编号', `newland_secret` varchar(32) DEFAULT NULL COMMENT '新大陆机构密钥', `newland_feilv` decimal(10,4) DEFAULT NULL COMMENT '新大陆结算费率', `newland_upfeilv` decimal(10,4) DEFAULT NULL COMMENT '新大陆银联>1000结算费率', `upreview` tinyint(1) DEFAULT NULL COMMENT '审核状态', `upbilldatatime` date DEFAULT NULL COMMENT '账单更新日期', `upupdatatime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`upid`), UNIQUE KEY `idx_upid` (`upid`) USING BTREE, UNIQUE KEY `idx_hnapay_channelId` (`hnapay_channelId`) USING BTREE, UNIQUE KEY `idx_newland_channelId` (`newland_channelId`) USING BTREE, KEY `idx_uniacid` (`uniacid`) USING BTREE, KEY `idx_agentid` (`upagentid`) USING BTREE, KEY `idx_hnapay_lock` (`hnapay_lock`) USING BTREE, KEY `idx_newland_lock` (`hnapay_lock`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='银联机构信息表'; ~~~