okayapi_72crm_admin_user

-- MySQL Table okayapi_72crm_admin_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_admin_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NULL COMMENT '主键',
    `username` varchar(50) NULL COMMENT '用户名',
    `okayapi_72crm_admin_user_password` varchar(64) NULL COMMENT '密码',
    `salt` varchar(32) NULL COMMENT '安全符',
    `img` varchar(200) NULL COMMENT '头像',
    `create_time` datetime NULL COMMENT '创建时间',
    `realname` varchar(100) NULL COMMENT '真实姓名',
    `num` varchar(100) NULL COMMENT '员工编号',
    `mobile` varchar(20) NULL COMMENT '手机号',
    `email` varchar(50) NULL COMMENT '邮箱',
    `sex` int(1) NULL COMMENT '0 未选择 1 男 2 女 ',
    `dept_id` int(11) NULL COMMENT '部门',
    `post` varchar(50) NULL COMMENT '岗位',
    `okayapi_72crm_admin_user_status` int(3) NULL DEFAULT '2' COMMENT '状态,0禁用,1正常,2未激活',
    `parent_id` bigint(20) NULL COMMENT '直属上级ID',
    `last_login_time` datetime NULL COMMENT '最后登录时间',
    `last_login_ip` varchar(30) NULL COMMENT '最后登录IP 注意兼容IPV6',
    KEY `user_id` (`user_id`),
    KEY `username` (`username`),
    KEY `okayapi_72crm_admin_user_password` (`okayapi_72crm_admin_user_password`),
    KEY `salt` (`salt`),
    KEY `img` (`img`),
    KEY `create_time` (`create_time`),
    KEY `realname` (`realname`),
    KEY `num` (`num`),
    KEY `mobile` (`mobile`),
    KEY `email` (`email`),
    KEY `sex` (`sex`),
    KEY `dept_id` (`dept_id`),
    KEY `post` (`post`),
    KEY `okayapi_72crm_admin_user_status` (`okayapi_72crm_admin_user_status`),
    KEY `parent_id` (`parent_id`),
    KEY `last_login_time` (`last_login_time`),
    KEY `last_login_ip` (`last_login_ip`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-用户表';

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