okayapi_social_users

-- MySQL Table okayapi_social_users
-- From: OkayAPI.com
CREATE TABLE `okayapi_social_users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `uid` int(11) NULL COMMENT '用户的 UID',
    `user_name` varchar(255) NULL COMMENT '用户名',
    `email` varchar(255) NULL COMMENT 'EMAIL',
    `mobile` varchar(16) NULL COMMENT '用户手机',
    `okayapi_social_users_password` varchar(32) NULL COMMENT '用户密码',
    `salt` varchar(16) NULL COMMENT '用户附加混淆码',
    `avatar_file` varchar(128) NULL COMMENT '头像文件',
    `sex` tinyint(1) NULL COMMENT '性别',
    `birthday` int(10) NULL COMMENT '生日',
    `province` varchar(64) NULL COMMENT '省',
    `city` varchar(64) NULL COMMENT '市',
    `job_id` int(10) NULL DEFAULT '0' COMMENT '职业ID',
    `reg_time` int(10) NULL COMMENT '注册时间',
    `reg_ip` bigint(12) NULL COMMENT '注册IP',
    `last_login` int(10) NULL DEFAULT '0' COMMENT '最后登录时间',
    `last_ip` bigint(12) NULL COMMENT '最后登录 IP',
    `online_time` int(10) NULL DEFAULT '0' COMMENT '在线时间',
    `last_active` int(10) NULL COMMENT '最后活跃时间',
    `fans_count` int(10) NULL DEFAULT '0' COMMENT '粉丝数',
    `article_count` int(10) NULL DEFAULT '0' COMMENT '文章数量',
    `question_count` int(10) NULL DEFAULT '0' COMMENT '问题数量',
    `answer_count` int(10) NULL DEFAULT '0' COMMENT '回答数量',
    `topic_focus_count` int(10) NULL DEFAULT '0' COMMENT '关注话题数量',
    `invitation_available` int(10) NULL DEFAULT '0' COMMENT '邀请数量',
    `group_id` int(10) NULL DEFAULT '0' COMMENT '用户组',
    `forbidden` tinyint(1) NULL DEFAULT '0' COMMENT '是否禁止用户',
    `valid_email` tinyint(1) NULL DEFAULT '0' COMMENT '邮箱验证',
    `is_first_login` tinyint(1) NULL DEFAULT '1' COMMENT '首次登录标记',
    `agree_count` int(10) NULL DEFAULT '0' COMMENT '赞同数量',
    `thanks_count` int(10) NULL DEFAULT '0' COMMENT '感谢数量',
    `reputation` int(10) NULL DEFAULT '0' COMMENT '威望',
    `reputation_update_time` int(10) NULL DEFAULT '0' COMMENT '威望更新',
    `draft_count` int(10) NULL COMMENT '',
    `common_email` varchar(255) NULL COMMENT '常用邮箱',
    `url_token` varchar(32) NULL COMMENT '个性网址',
    `verified` varchar(32) NULL COMMENT '',
    KEY `uid` (`uid`),
    KEY `user_name` (`user_name`),
    KEY `email` (`email`),
    KEY `mobile` (`mobile`),
    KEY `okayapi_social_users_password` (`okayapi_social_users_password`),
    KEY `salt` (`salt`),
    KEY `avatar_file` (`avatar_file`),
    KEY `sex` (`sex`),
    KEY `birthday` (`birthday`),
    KEY `province` (`province`),
    KEY `city` (`city`),
    KEY `job_id` (`job_id`),
    KEY `reg_time` (`reg_time`),
    KEY `reg_ip` (`reg_ip`),
    KEY `last_login` (`last_login`),
    KEY `last_ip` (`last_ip`),
    KEY `online_time` (`online_time`),
    KEY `last_active` (`last_active`),
    KEY `fans_count` (`fans_count`),
    KEY `article_count` (`article_count`),
    KEY `question_count` (`question_count`),
    KEY `answer_count` (`answer_count`),
    KEY `topic_focus_count` (`topic_focus_count`),
    KEY `invitation_available` (`invitation_available`),
    KEY `group_id` (`group_id`),
    KEY `forbidden` (`forbidden`),
    KEY `valid_email` (`valid_email`),
    KEY `is_first_login` (`is_first_login`),
    KEY `agree_count` (`agree_count`),
    KEY `thanks_count` (`thanks_count`),
    KEY `reputation` (`reputation`),
    KEY `reputation_update_time` (`reputation_update_time`),
    KEY `draft_count` (`draft_count`),
    KEY `common_email` (`common_email`),
    KEY `url_token` (`url_token`),
    KEY `verified` (`verified`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '社交会员';

After replication, you can go to the database to create the database table.