/*
    记录微信access_token与ticket
    @author: qiuj <jun.qiu@yoho.cn>
    @date: 2017-11-15 10:10:17
*/
#注意：GO;分割执行块
use yoho_activity_platform;
GO;
CREATE TABLE IF NOT EXISTS `wechat_token` (
    `id` int(8) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `access_token` varchar(200) NOT NULL DEFAULT '',
    `access_ticket` varchar(200) NOT NULL DEFAULT '',
    `access_create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `access_expired` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) DEFAULT CHARSET=utf8;
GO;