/*
    记录用户登录
    @author: 陈峰 <feng.chen@yoho.cn>
    @date: 2017-09-13 10:23:56
*/
#注意：GO;分割执行块
#发布积攒活动文章点赞
CREATE TABLE IF NOT EXISTS act_login_user_log (
    `id` int(8) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `user_id` int(8) NOT NULL DEFAULT 0,
    `login_time` bigint NOT NULL DEFAULT 0,
    `platform` varchar(50) NOT NULL DEFAULT '',
    `ip` varchar(20) NOT NULL DEFAULT '',
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) DEFAULT CHARSET=utf8;
GO;

ALTER TABLE act_login_user_log ADD `referer` varchar(200) DEFAULT '';
GO;