-- 应用信息表DROP TABLE IF EXISTS `ks_apps_info`;CREATE TABLE `ks_apps_info` (  `appid` int(11) NOT NULL COMMENT ‘应用id, 由业务网关产生‘,  `appname` varchar(255) NOT NULL DEFAULT ‘默认应用‘ COMMENT ‘应用名称‘,  `access_token` varchar(255) NOT NULL DEFAULT ‘‘ COMMENT ‘访问授权码‘,  `instance_count` int(11) NOT NULL DEFAULT 0 COMMENT ‘实例个数‘,  `create_time` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00‘ COMMENT ‘创建记录时间‘,  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间戳‘,  PRIMARY KEY (`appid`),  UNIQUE KEY `idx_accesstoken` (`access_token`) USING HASH,)ENGINE=InnoDB DEFAULT CHARSET=utf8;