/*
    true
    @author: qiuj <jun.qiu@yoho.cn>
    @date: 2018-04-13 10:55:09
*/
#注意：GO;分割执行块

#球鞋试卷好友关系
CREATE TABLE IF NOT EXISTS act_shoes_friends (
    `id` int(8) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `act_id` int(8) NOT NULL DEFAULT 0,
    `union_id` varchar(50) NOT NULL DEFAULT '0',
    `friend_union_id` varchar(50) NOT NULL DEFAULT '0',
    `user_id` int(8) NOT NULL,
    `friend_id` int(8) NOT NULL,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) DEFAULT CHARSET=utf8;
GO;

#球鞋试卷答题统计
CREATE TABLE IF NOT EXISTS act_shoes_answers (
    `id` int(8) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `act_id` int(8) NOT NULL DEFAULT 0,
    `user_id` int(8) NOT NULL,
    `question_id` int(8) NOT NULL,
    `user_select_answer` varchar(50) NOT NULL DEFAULT 'F',
    `is_correct` tinyint(1) NOT NULL DEFAULT 0,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) DEFAULT CHARSET=utf8;
GO;