数据库加表
数据库:shuidi_data
表名:tb_third_api_count
sql:
CREATE TABLE `tb_third_api_count` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dateindex` int(11) NOT NULL,
`user_name` varchar(100) NOT NULL,
`api_name` varchar(100) NOT NULL,
`num` int(11) NOT NULL DEFAULT '0',
`money` float(11,2) NOT NULL DEFAULT '0.00',
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8