/*
 Navicat Premium Data Transfer

 Source Server         : ALY4
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : 47.95.194.179:3306
 Source Schema         : sc_lumen_auth

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 22/01/2021 11:24:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_system_api
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_api`;
CREATE TABLE `sc_system_api`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `menu_id` int(10) NULL DEFAULT 0 COMMENT '菜单ID',
  `name` varchar(255)  NULL DEFAULT '' COMMENT '名称',
  `description` text  NULL COMMENT '描述',
  `url` text  NULL COMMENT '路径',
  `create_time` bigint(13) NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` bigint(13) NULL DEFAULT 0 COMMENT '修改时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '数据状态 1 正常 9 删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '菜单功能表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_system_authority
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_authority`;
CREATE TABLE `sc_system_authority`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255)  NOT NULL DEFAULT '' COMMENT '名称',
  `description` text  NULL COMMENT '描述',
  `sort` int(20) NULL DEFAULT 0 COMMENT '排序',
  `create_time` bigint(13) NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` bigint(13) NULL DEFAULT 0 COMMENT '修改时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '数据状态 1 正常 9 删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_system_authority_menu
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_authority_menu`;
CREATE TABLE `sc_system_authority_menu`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `authority_id` int(10) NULL DEFAULT 0,
  `menu_id` int(10) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '菜单权限关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_system_authority_menu_function
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_authority_menu_function`;
CREATE TABLE `sc_system_authority_menu_function`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `authority_id` int(10) NULL DEFAULT 0,
  `menu_id` int(10) NULL DEFAULT 0,
  `function_id` int(10) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '权限与菜单功能关联' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_system_function
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_function`;
CREATE TABLE `sc_system_function`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `menu_id` int(10) NULL DEFAULT 0 COMMENT '菜单ID',
  `name` varchar(255)  NOT NULL DEFAULT '' COMMENT '名称',
  `key_val` varchar(255)  NULL DEFAULT '' COMMENT 'keyVal',
  `create_time` bigint(13) NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` bigint(13) NULL DEFAULT 0 COMMENT '修改时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '数据状态 1 正常 9 删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '菜单功能表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_system_menu
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_menu`;
CREATE TABLE `sc_system_menu`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `menu_type` int(10) NULL DEFAULT 1 COMMENT '菜单所属平台 1:PC端',
  `parent_id` int(10) NULL DEFAULT 0 COMMENT '父级菜单Id',
  `name` varchar(255)  NOT NULL DEFAULT '' COMMENT '名称',
  `description` text  NULL COMMENT '描述',
  `key_val` varchar(255)  NULL DEFAULT '' COMMENT 'keyVal',
  `url` varchar(255)  NULL DEFAULT '' COMMENT '路径',
  `icon` varchar(255)  NULL DEFAULT '' COMMENT '图标',
  `include_str` text  NULL COMMENT '自定义信息字符串',
  `sort` int(255) NULL DEFAULT 0 COMMENT '排序',
  `create_time` bigint(13) NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` bigint(13) NULL DEFAULT 0 COMMENT '修改时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '数据状态 1 正常 9 删除',
  `is_can_distribution` tinyint(1) NULL DEFAULT 1 COMMENT '是否允许分配 0：否 1：是',
  `depth` varchar(255)  NULL DEFAULT '' COMMENT '深度',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_system_role
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_role`;
CREATE TABLE `sc_system_role`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255)  NOT NULL DEFAULT '' COMMENT '名称',
  `description` text  NULL COMMENT '描述',
  `sort` int(20) NULL DEFAULT 0 COMMENT '排序',
  `create_time` bigint(13) NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` bigint(13) NULL DEFAULT 0 COMMENT '修改时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '数据状态 1 正常 9 删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_system_role_authority
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_role_authority`;
CREATE TABLE `sc_system_role_authority`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_id` int(10) NULL DEFAULT 0,
  `authority_id` int(10) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '角色权限关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_system_role_user
-- ----------------------------
DROP TABLE IF EXISTS `sc_system_role_user`;
CREATE TABLE `sc_system_role_user`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_id` int(10) NOT NULL DEFAULT 0,
  `user_id` int(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1  COMMENT = '用户与角色关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sc_token_cache
-- ----------------------------
DROP TABLE IF EXISTS `sc_token_cache`;
CREATE TABLE `sc_token_cache` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `token` char(32) DEFAULT '' COMMENT '用户令牌',
  `expire_time` bigint(11) DEFAULT '0' COMMENT '过期时间',
  `update_time` bigint(11) DEFAULT '0' COMMENT '更新时间',
  `login_time` bigint(11) DEFAULT '0' COMMENT '登录时间',
  `call_num` int(11) DEFAULT '0' COMMENT '令牌剩余调用次数',
  `is_invalid` tinyint(1) DEFAULT '0' COMMENT '是否失效 0：否 1：是',
  `src` tinyint(1) DEFAULT '1' COMMENT '来源 1:backHome  2:AppHome',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户令牌缓存表';
-- ----------------------------
-- Table structure for sc_user
-- ----------------------------
DROP TABLE IF EXISTS `sc_user`;
CREATE TABLE `sc_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nike_name` varchar(10) NOT NULL COMMENT '用户昵称',
  `username` varchar(20) NOT NULL COMMENT '用户登录账号',
  `password` char(32) NOT NULL COMMENT '用户密码',
  `is_supper_admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是超级管理员 0：否 1：是',
  `is_update_init_pwd` tinyint(1) DEFAULT '0' COMMENT '是否更改过初始密码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2  COMMENT='用户列表';

DROP TABLE IF EXISTS `sc_do_handle_logs`;
CREATE TABLE `sc_do_handle_logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '操作者ID',
  `type` char(1) DEFAULT NULL COMMENT '类型：d：删除  i：插入  u：修改',
  `method` varchar(255) DEFAULT NULL COMMENT '操作具体方法',
  `data` text COMMENT '操作数据',
  `remark` varchar(255) DEFAULT NULL COMMENT '操作备注',
  `route` varchar(1024) DEFAULT '' COMMENT '请求API',
  `ip` bigint(20) DEFAULT NULL COMMENT '请求者IP',
  `created_at` bigint(20) DEFAULT NULL COMMENT '创建时间',
  `src` tinyint(255) DEFAULT '0' COMMENT '日志来源 1：PC端  2：APP',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB   ROW_FORMAT=COMPACT COMMENT='日志表';

DROP TABLE IF EXISTS `sc_user_oauth`;
CREATE TABLE `sc_user_oauth` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `open_id` varchar(255) DEFAULT '' COMMENT '用户唯一标识(小程序、公众号等)',
  `union_id` varchar(255) DEFAULT '' COMMENT '平台唯一标识(微信开放平台等)',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '类型 1:微信小程序 2:微信公众号 3:微信Oauth2.0 4:其他后续补充(例如支付宝小程序)',
  `session_key` varchar(255) DEFAULT '' COMMENT '用户会话标识，一般当令牌使用',
  `last_login_time` bigint(11) DEFAULT '0' COMMENT '最后登录时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  COMMENT='用户三方登录扩展表';

DROP TABLE IF EXISTS `sc_customer_form`;
CREATE TABLE `sc_customer_form` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `table_name` varchar(50) DEFAULT NULL COMMENT '表单名称',
  `status` tinyint(2) DEFAULT NULL COMMENT '状态 1:正常 2：禁止修改 3：禁止查看 9：删除 ',
  `create_time` bigint(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` bigint(11) DEFAULT NULL COMMENT '更新时间',
  `project_id` int(11) DEFAULT NULL COMMENT '项目ID',
  `type` tinyint(1) DEFAULT NULL COMMENT '类型0：其他',
  `object_id` int(11) DEFAULT NULL COMMENT '对应类型的ID(该表单结构属于的外部对象)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB COMMENT='自定义表单-表单列表';

DROP TABLE IF EXISTS `sc_customer_form_key`;
CREATE TABLE `sc_customer_form_key` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `customer_form_id` int(11) NOT NULL COMMENT '整改通知书ID',
  `type` varchar(50) DEFAULT '' COMMENT '前端标签标识(前端自定义)',
  `label` varchar(50) DEFAULT '' COMMENT '当前主键标签',
  `field_key` varchar(50) NOT NULL COMMENT '当前表中的当前组件KEY(生成规则:type_sort)',
  `ext` text COMMENT '当前组件的自定义属性',
  `value` text COMMENT '当前组件默认值',
  `sort` tinyint(4) DEFAULT '1' COMMENT '当前组件排序(不允许重复)',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `customer_form_id` (`customer_form_id`) USING BTREE
) ENGINE=InnoDB COMMENT='自定义表单-表单key';

DROP TABLE IF EXISTS `sc_customer_form_list`;
CREATE TABLE `sc_customer_form_list` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_form_id` int(11) NOT NULL COMMENT '自定义表单ID',
  `create_user` int(11) DEFAULT NULL COMMENT '创建者ID',
  `create_time` bigint(11) DEFAULT '0' COMMENT '创建时间',
  `update_time` bigint(11) DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 1:正常 9:删除',
  `project_id` int(11) DEFAULT NULL COMMENT '项目ID',
  `type` tinyint(1) DEFAULT '0' COMMENT '类型0：其他',
  `object_id` int(11) DEFAULT '0' COMMENT '对应类型的ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `customer_form_id` (`customer_form_id`) USING BTREE
) ENGINE=InnoDB COMMENT='自定义表单-实体表单列表';

DROP TABLE IF EXISTS `sc_customer_form_list_content`;
CREATE TABLE `sc_customer_form_list_content` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `customer_form_list_id` int(11) NOT NULL COMMENT '表单列表ID',
  `customer_form_key_id` int(11) NOT NULL DEFAULT '0' COMMENT '表单KEY的ID',
  `field_value` text COMMENT '当前字段值(JSON串)',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `customer_form_list_id` (`customer_form_list_id`) USING BTREE,
  KEY `customer_form_key_id` (`customer_form_key_id`) USING BTREE
) ENGINE=InnoDB COMMENT='自定义表单-表单列表内容';

-- ----------------------------
-- Records of sc_user
-- ----------------------------
INSERT INTO `sc_user` VALUES (1, 'Scarecrow', '18888888888', '57a51c12792a0aa880faa8889da409ac', 1, 0);

SET FOREIGN_KEY_CHECKS = 1;