1443 lines
168 KiB
C#
1443 lines
168 KiB
C#
using System;
|
||
using Microsoft.EntityFrameworkCore.Metadata;
|
||
using Microsoft.EntityFrameworkCore.Migrations;
|
||
|
||
namespace Ewide.Database.Migrations.Migrations
|
||
{
|
||
public partial class init : Migration
|
||
{
|
||
protected override void Up(MigrationBuilder migrationBuilder)
|
||
{
|
||
migrationBuilder.CreateTable(
|
||
name: "bs_house_projectinfo",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Name = table.Column<string>(type: "varchar(100) CHARACTER SET utf8mb4", maxLength: 100, nullable: false, comment: "名称"),
|
||
Note = table.Column<string>(type: "varchar(1000) CHARACTER SET utf8mb4", maxLength: 1000, nullable: true, comment: "备注"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
||
AreaId = table.Column<string>(type: "varchar(36) CHARACTER SET utf8mb4", maxLength: 36, nullable: false, comment: "区域ID"),
|
||
AreaName = table.Column<string>(type: "varchar(500) CHARACTER SET utf8mb4", maxLength: 500, nullable: true, comment: "区域名称"),
|
||
Type = table.Column<int>(type: "int", nullable: false, comment: "类型"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_bs_house_projectinfo", x => x.Id);
|
||
},
|
||
comment: "项目表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_app",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Code = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "编码"),
|
||
Icon = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "图标"),
|
||
Color = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "图标颜色"),
|
||
Active = table.Column<ulong>(type: "bit", nullable: false, comment: "是否默认激活"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_app", x => x.Id);
|
||
},
|
||
comment: "系统应用表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_area_code",
|
||
columns: table => new
|
||
{
|
||
Code = table.Column<string>(type: "varchar(50) CHARACTER SET utf8mb4", maxLength: 50, nullable: false, comment: "系统使用的区域编码"),
|
||
AdCode = table.Column<string>(type: "varchar(50) CHARACTER SET utf8mb4", maxLength: 50, nullable: true, comment: "区域的行政编码"),
|
||
Name = table.Column<string>(type: "varchar(100) CHARACTER SET utf8mb4", maxLength: 100, nullable: false, comment: "名称"),
|
||
Note = table.Column<string>(type: "varchar(1000) CHARACTER SET utf8mb4", maxLength: 1000, nullable: true, comment: "备注"),
|
||
LevelType = table.Column<int>(type: "int", nullable: false, comment: "类别"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_area_code", x => x.Code);
|
||
},
|
||
comment: "区域表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_code_gen",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
AuthorName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "作者姓名"),
|
||
TablePrefix = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "是否移除表前缀"),
|
||
GenerateType = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "生成方式"),
|
||
TableName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "数据库表名"),
|
||
NameSpace = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "命名空间"),
|
||
BusName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "业务名"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_code_gen", x => x.Id);
|
||
},
|
||
comment: "代码生成表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_code_gen_config",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
CodeGenId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "代码生成主表ID"),
|
||
ColumnName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "数据库字段名"),
|
||
ColumnComment = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "字段描述"),
|
||
NetType = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: ".NET数据类型"),
|
||
EffectType = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "作用类型"),
|
||
DictTypeCode = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "字典Code"),
|
||
WhetherRetract = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "列表是否缩进"),
|
||
WhetherRequired = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "是否必填"),
|
||
QueryWhether = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "是否是查询条件"),
|
||
QueryType = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "查询方式"),
|
||
WhetherTable = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "列表显示"),
|
||
WhetherAddUpdate = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "增改"),
|
||
ColumnKey = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "主外键"),
|
||
DataType = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "数据库中类型"),
|
||
WhetherCommon = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "是否通用字段"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_code_gen_config", x => x.Id);
|
||
},
|
||
comment: "代码生成字段配置表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_config",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Code = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "编码"),
|
||
Value = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "属性值"),
|
||
SysFlag = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "是否是系统参数"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
|
||
GroupCode = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "常量所属分类的编码"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_config", x => x.Id);
|
||
},
|
||
comment: "参数配置表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_dict_type",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Code = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "编码"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_dict_type", x => x.Id);
|
||
},
|
||
comment: "字典类型表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_emp",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "用户Id"),
|
||
JobNum = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "工号"),
|
||
OrgId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "机构Id"),
|
||
OrgName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "机构名称")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_emp", x => x.Id);
|
||
},
|
||
comment: "员工表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_file",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
FileLocation = table.Column<int>(type: "int", nullable: false, comment: "文件存储位置"),
|
||
FileBucket = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "文件仓库"),
|
||
FileOriginName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "文件名称"),
|
||
FileSuffix = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "文件后缀"),
|
||
FileSizeKb = table.Column<long>(type: "bigint", nullable: false, comment: "文件大小kb"),
|
||
FileSizeInfo = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "文件大小信息"),
|
||
FileObjectName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "存储到bucket的名称"),
|
||
FilePath = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "存储路径"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_file", x => x.Id);
|
||
},
|
||
comment: "文件信息表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_log_audit",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<int>(type: "int", nullable: false)
|
||
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
||
TableName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "表名"),
|
||
ColumnName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "列名"),
|
||
NewValue = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "新值"),
|
||
OldValue = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "旧值"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: false, comment: "操作时间"),
|
||
UserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "操作人Id"),
|
||
UserName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "操作人名称"),
|
||
Operate = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "操作方式")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_log_audit", x => x.Id);
|
||
},
|
||
comment: "审计日志表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_log_op",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<int>(type: "int", nullable: false)
|
||
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
OpType = table.Column<int>(type: "int", nullable: true, comment: "操作类型"),
|
||
Success = table.Column<bool>(type: "tinyint(1)", nullable: true, comment: "是否执行成功"),
|
||
Message = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "具体消息"),
|
||
Ip = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "IP"),
|
||
Location = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "地址"),
|
||
Browser = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "浏览器"),
|
||
Os = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "操作系统"),
|
||
Url = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "请求地址"),
|
||
ClassName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "类名称"),
|
||
MethodName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "方法名称"),
|
||
ReqMethod = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "请求方式"),
|
||
Param = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "请求参数"),
|
||
Result = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "返回结果"),
|
||
ElapsedTime = table.Column<long>(type: "bigint", nullable: false, comment: "耗时"),
|
||
OpTime = table.Column<DateTime>(type: "datetime", nullable: false, comment: "操作时间"),
|
||
Account = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "操作人")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_log_op", x => x.Id);
|
||
},
|
||
comment: "操作日志表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_log_vis",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<int>(type: "int", nullable: false)
|
||
.Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Success = table.Column<bool>(type: "tinyint(1)", nullable: false, comment: "是否执行成功"),
|
||
Message = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "具体消息"),
|
||
Ip = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "IP"),
|
||
Location = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "地址"),
|
||
Browser = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "浏览器"),
|
||
Os = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "操作系统"),
|
||
VisType = table.Column<int>(type: "int", nullable: true, comment: "访问类型"),
|
||
VisTime = table.Column<DateTime>(type: "datetime", nullable: false, comment: "访问时间"),
|
||
Account = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "访问人")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_log_vis", x => x.Id);
|
||
},
|
||
comment: "访问日志表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_menu",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Pid = table.Column<string>(type: "varchar(36)", nullable: true, comment: "父Id"),
|
||
Pids = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "父Ids"),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Code = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "编码"),
|
||
Type = table.Column<int>(type: "int", nullable: false, comment: "菜单类型"),
|
||
Icon = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "图标"),
|
||
Router = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "路由地址"),
|
||
Component = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "组件地址"),
|
||
Permission = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "权限标识"),
|
||
Application = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "应用分类"),
|
||
OpenType = table.Column<int>(type: "int", nullable: false, comment: "打开方式"),
|
||
Visible = table.Column<ulong>(type: "bit", nullable: false, comment: "是否可见"),
|
||
Link = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "内链地址"),
|
||
Redirect = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "重定向地址"),
|
||
Weight = table.Column<int>(type: "int", nullable: false, comment: "权重"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
VisibleParent = table.Column<ulong>(type: "bit", nullable: false, comment: "关联菜单显示"),
|
||
Status = table.Column<int>(type: "int", nullable: false),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_menu", x => x.Id);
|
||
},
|
||
comment: "菜单表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_notice",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Title = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "标题"),
|
||
Content = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "内容"),
|
||
Type = table.Column<int>(type: "int", nullable: false, comment: "类型"),
|
||
PublicUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "发布人Id"),
|
||
PublicUserName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "发布人姓名"),
|
||
PublicOrgId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "发布机构Id"),
|
||
PublicOrgName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "发布机构名称"),
|
||
PublicTime = table.Column<DateTime>(type: "datetime", nullable: false, comment: "发布时间"),
|
||
CancelTime = table.Column<DateTime>(type: "datetime", nullable: false, comment: "撤回时间"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_notice", x => x.Id);
|
||
},
|
||
comment: "通知公告表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_notice_user",
|
||
columns: table => new
|
||
{
|
||
NoticeId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "通知公告Id"),
|
||
UserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "用户Id"),
|
||
ReadTime = table.Column<DateTime>(type: "datetime", nullable: false, comment: "阅读时间"),
|
||
ReadStatus = table.Column<int>(type: "int", nullable: false, comment: "状态")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
},
|
||
comment: "通知公告用户表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_oauth_user",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Uuid = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "UUID"),
|
||
AccessToken = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "Token"),
|
||
NickName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "昵称"),
|
||
Avatar = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "头像"),
|
||
Gender = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "性别"),
|
||
Phone = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "电话"),
|
||
Email = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "邮箱"),
|
||
Location = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "位置"),
|
||
Blog = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "用户网址"),
|
||
Company = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "所在公司"),
|
||
Source = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "用户来源"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_oauth_user", x => x.Id);
|
||
},
|
||
comment: "Oauth登录用户表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_pos",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Code = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "编码"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_pos", x => x.Id);
|
||
},
|
||
comment: "职位表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_role",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Code = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "编码"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
||
DataScopeType = table.Column<int>(type: "int", nullable: false, comment: "数据范围类型"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_role", x => x.Id);
|
||
},
|
||
comment: "角色表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_tenant",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Host = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "主机"),
|
||
Email = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "电子邮箱"),
|
||
Phone = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "电话"),
|
||
Connection = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "数据库连接"),
|
||
Schema = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "架构"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_tenant", x => x.Id);
|
||
},
|
||
comment: "租户表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_timer",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
JobName = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "任务名称"),
|
||
JobGroup = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "任务分组"),
|
||
BeginTime = table.Column<DateTime>(type: "datetime", nullable: false, comment: "开始时间"),
|
||
EndTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "结束时间"),
|
||
Cron = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "Cron表达式"),
|
||
RunNumber = table.Column<int>(type: "int", nullable: true, comment: "执行次数"),
|
||
Interval = table.Column<int>(type: "int", nullable: true, comment: "执行间隔时间"),
|
||
TriggerType = table.Column<int>(type: "int", nullable: false, comment: "触发器类型"),
|
||
RequestUrl = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "请求url"),
|
||
RequestParameters = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "请求参数"),
|
||
Headers = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "Headers"),
|
||
RequestType = table.Column<int>(type: "int", nullable: false, comment: "请求类型"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_timer", x => x.Id);
|
||
},
|
||
comment: "定时任务表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_user",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Account = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: false, comment: "账号"),
|
||
Password = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: false, comment: "密码"),
|
||
NickName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "昵称"),
|
||
Name = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "姓名"),
|
||
Avatar = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "头像"),
|
||
Birthday = table.Column<DateTime>(type: "datetime", nullable: true, comment: "生日"),
|
||
Sex = table.Column<int>(type: "int", nullable: false, comment: "性别-男_1、女_2"),
|
||
Email = table.Column<string>(type: "varchar(30) CHARACTER SET utf8mb4", maxLength: 30, nullable: true, comment: "邮箱"),
|
||
Phone = table.Column<string>(type: "varchar(30) CHARACTER SET utf8mb4", maxLength: 30, nullable: true, comment: "手机"),
|
||
Tel = table.Column<string>(type: "varchar(30) CHARACTER SET utf8mb4", maxLength: 30, nullable: true, comment: "电话"),
|
||
LastLoginIp = table.Column<string>(type: "varchar(30) CHARACTER SET utf8mb4", maxLength: 30, nullable: true, comment: "最后登录IP"),
|
||
LastLoginTime = table.Column<DateTime>(type: "datetime", nullable: false, comment: "最后登录时间"),
|
||
AdminType = table.Column<int>(type: "int", nullable: false, comment: "管理员类型-超级管理员_1、非管理员_2"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态-正常_0、停用_1、删除_2"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_user", x => x.Id);
|
||
},
|
||
comment: "用户表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_org",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
Pid = table.Column<string>(type: "varchar(36)", nullable: true, comment: "父Id"),
|
||
Pids = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "Pids"),
|
||
Name = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "名称"),
|
||
Code = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "编码"),
|
||
Contacts = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "联系人"),
|
||
Tel = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "电话"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
|
||
AreaCode = table.Column<string>(type: "varchar(50) CHARACTER SET utf8mb4", nullable: true),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_org", x => x.Id);
|
||
table.ForeignKey(
|
||
name: "FK_sys_org_sys_area_code_AreaCode",
|
||
column: x => x.AreaCode,
|
||
principalTable: "sys_area_code",
|
||
principalColumn: "Code",
|
||
onDelete: ReferentialAction.Restrict);
|
||
},
|
||
comment: "组织机构表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_dict_data",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<string>(type: "varchar(36)", nullable: false, comment: "Id主键"),
|
||
TypeId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "字典类型Id"),
|
||
Value = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "值"),
|
||
Code = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "编码"),
|
||
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
||
Remark = table.Column<string>(type: "longtext CHARACTER SET utf8mb4", nullable: true, comment: "备注"),
|
||
Status = table.Column<int>(type: "int", nullable: false, comment: "状态"),
|
||
CreatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
UpdatedTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "更新时间"),
|
||
CreatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "创建者Id"),
|
||
CreatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "创建者名称"),
|
||
UpdatedUserId = table.Column<string>(type: "varchar(36)", nullable: true, comment: "修改者Id"),
|
||
UpdatedUserName = table.Column<string>(type: "varchar(20) CHARACTER SET utf8mb4", maxLength: 20, nullable: true, comment: "修改者名称"),
|
||
IsDeleted = table.Column<ulong>(type: "bit", nullable: false, comment: "软删除标记")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_dict_data", x => x.Id);
|
||
table.ForeignKey(
|
||
name: "FK_sys_dict_data_sys_dict_type_TypeId",
|
||
column: x => x.TypeId,
|
||
principalTable: "sys_dict_type",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Restrict);
|
||
},
|
||
comment: "字典值表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_emp_pos",
|
||
columns: table => new
|
||
{
|
||
SysEmpId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "员工Id"),
|
||
SysPosId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "职位Id")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_emp_pos", x => new { x.SysEmpId, x.SysPosId });
|
||
table.ForeignKey(
|
||
name: "FK_sys_emp_pos_sys_emp_SysEmpId",
|
||
column: x => x.SysEmpId,
|
||
principalTable: "sys_emp",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_emp_pos_sys_pos_SysPosId",
|
||
column: x => x.SysPosId,
|
||
principalTable: "sys_pos",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
},
|
||
comment: "员工职位表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_role_area",
|
||
columns: table => new
|
||
{
|
||
SysRoleId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "角色Id"),
|
||
AreaCode = table.Column<string>(type: "varchar(50) CHARACTER SET utf8mb4", nullable: false, comment: "系统使用的区域代码")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_role_area", x => new { x.SysRoleId, x.AreaCode });
|
||
table.ForeignKey(
|
||
name: "FK_sys_role_area_sys_area_code_AreaCode",
|
||
column: x => x.AreaCode,
|
||
principalTable: "sys_area_code",
|
||
principalColumn: "Code",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_role_area_sys_role_SysRoleId",
|
||
column: x => x.SysRoleId,
|
||
principalTable: "sys_role",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
},
|
||
comment: "角色区域自定义数据");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_role_menu",
|
||
columns: table => new
|
||
{
|
||
SysRoleId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "角色Id"),
|
||
SysMenuId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "菜单Id")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_role_menu", x => new { x.SysRoleId, x.SysMenuId });
|
||
table.ForeignKey(
|
||
name: "FK_sys_role_menu_sys_menu_SysMenuId",
|
||
column: x => x.SysMenuId,
|
||
principalTable: "sys_menu",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_role_menu_sys_role_SysRoleId",
|
||
column: x => x.SysRoleId,
|
||
principalTable: "sys_role",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
},
|
||
comment: "角色菜单表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_user_area",
|
||
columns: table => new
|
||
{
|
||
SysUserId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "用户Id"),
|
||
AreaCode = table.Column<string>(type: "varchar(10) CHARACTER SET utf8mb4", maxLength: 10, nullable: false, comment: "系统使用的区域代码")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_user_area", x => new { x.SysUserId, x.AreaCode });
|
||
table.ForeignKey(
|
||
name: "FK_sys_user_area_sys_area_code_AreaCode",
|
||
column: x => x.AreaCode,
|
||
principalTable: "sys_area_code",
|
||
principalColumn: "Code",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_user_area_sys_user_SysUserId",
|
||
column: x => x.SysUserId,
|
||
principalTable: "sys_user",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
},
|
||
comment: "用户授权区域信息");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_user_role",
|
||
columns: table => new
|
||
{
|
||
SysUserId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "用户Id"),
|
||
SysRoleId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "角色Id")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_user_role", x => new { x.SysUserId, x.SysRoleId });
|
||
table.ForeignKey(
|
||
name: "FK_sys_user_role_sys_role_SysRoleId",
|
||
column: x => x.SysRoleId,
|
||
principalTable: "sys_role",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_user_role_sys_user_SysUserId",
|
||
column: x => x.SysUserId,
|
||
principalTable: "sys_user",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
},
|
||
comment: "用户角色表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_emp_ext_org_pos",
|
||
columns: table => new
|
||
{
|
||
SysEmpId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "员工Id"),
|
||
SysOrgId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "机构Id"),
|
||
SysPosId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "职位Id")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_emp_ext_org_pos", x => new { x.SysEmpId, x.SysOrgId, x.SysPosId });
|
||
table.ForeignKey(
|
||
name: "FK_sys_emp_ext_org_pos_sys_emp_SysEmpId",
|
||
column: x => x.SysEmpId,
|
||
principalTable: "sys_emp",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_emp_ext_org_pos_sys_org_SysOrgId",
|
||
column: x => x.SysOrgId,
|
||
principalTable: "sys_org",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_emp_ext_org_pos_sys_pos_SysPosId",
|
||
column: x => x.SysPosId,
|
||
principalTable: "sys_pos",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
},
|
||
comment: "员工附属机构职位表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_role_data_scope",
|
||
columns: table => new
|
||
{
|
||
SysRoleId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "角色Id"),
|
||
SysOrgId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "机构Id")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_role_data_scope", x => new { x.SysRoleId, x.SysOrgId });
|
||
table.ForeignKey(
|
||
name: "FK_sys_role_data_scope_sys_org_SysOrgId",
|
||
column: x => x.SysOrgId,
|
||
principalTable: "sys_org",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_role_data_scope_sys_role_SysRoleId",
|
||
column: x => x.SysRoleId,
|
||
principalTable: "sys_role",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
},
|
||
comment: "角色数据范围表");
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "sys_user_data_scope",
|
||
columns: table => new
|
||
{
|
||
SysUserId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "用户Id"),
|
||
SysOrgId = table.Column<string>(type: "varchar(36)", nullable: false, comment: "机构Id")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_sys_user_data_scope", x => new { x.SysUserId, x.SysOrgId });
|
||
table.ForeignKey(
|
||
name: "FK_sys_user_data_scope_sys_org_SysOrgId",
|
||
column: x => x.SysOrgId,
|
||
principalTable: "sys_org",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
table.ForeignKey(
|
||
name: "FK_sys_user_data_scope_sys_user_SysUserId",
|
||
column: x => x.SysUserId,
|
||
principalTable: "sys_user",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
},
|
||
comment: "用户数据范围表");
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_app",
|
||
columns: new[] { "Id", "Active", "Code", "Color", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Name", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
|
||
values: new object[,]
|
||
{
|
||
{ "8b2aeb5e-09a6-4afd-bcae-8ee8e5a1e6ec", 0ul, "busapp", null, null, null, null, null, 0ul, "业务应用", 100, 0, null, null, null },
|
||
{ "d781b8f1-0d08-48c8-b7a5-ed75ddfa676c", 1ul, "system", null, null, null, null, null, 0ul, "系统管理", 100, 0, null, null, null },
|
||
{ "850ab86f-cd6a-4d49-b920-77dfa5d78813", 0ul, "system_tool", null, null, null, null, null, 0ul, "系统工具", 100, 0, null, null, null },
|
||
{ "05a32be5-82e8-423f-affa-e17232a63ee1", 0ul, "advanced", null, null, null, null, null, 0ul, "高级功能", 100, 0, null, null, null }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_area_code",
|
||
columns: new[] { "Code", "AdCode", "LevelType", "Name", "Note", "Sort" },
|
||
values: new object[,]
|
||
{
|
||
{ "3302", "3302", 1, "XX市", "XX市", 0 },
|
||
{ "330266", "330266", 2, "测试区", "测试区", 100 },
|
||
{ "330266001", "330266001", 3, "测试街道", "测试街道", 0 }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_config",
|
||
columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "GroupCode", "IsDeleted", "Name", "Remark", "Status", "SysFlag", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Value" },
|
||
values: new object[,]
|
||
{
|
||
{ "55756524-ecb8-444e-9cdd-a0fc767c4b96", "DILON_FILE_UPLOAD_PATH_FOR_WINDOWS", null, null, null, "FILE_PATH", 0ul, "Win本地上传文件路径", "Win本地上传文件路径", 0, "Y", null, null, null, "D:/tmp" },
|
||
{ "d2db41ee-ce1f-46de-ac00-5860634afed9", "DILON_FILE_UPLOAD_PATH_FOR_LINUX", null, null, null, "FILE_PATH", 0ul, "Linux/Mac本地上传文件路径", "Linux/Mac本地上传文件路径", 0, "Y", null, null, null, "/tmp" },
|
||
{ "ff8debdd-eca0-4f91-8213-e2080f76b35d", "DILON_UN_XSS_FILTER_URL", null, null, null, "DEFAULT", 0ul, "放开XSS过滤的接口", "多个url可以用英文逗号隔开", 0, "Y", null, null, null, "/demo/xssfilter,/demo/unxss" },
|
||
{ "5584fb84-f580-463f-b06d-bbb80a4dfb72", "DILON_ENABLE_SINGLE_LOGIN", null, null, null, "DEFAULT", 0ul, "单用户登陆的开关", "true-打开，false-关闭，如果一个人登录两次，就会将上一次登陆挤下去", 0, "Y", null, null, null, "false" },
|
||
{ "53b0afb2-4917-4b85-bcca-fe7c7723ae22", "DILON_CAPTCHA_OPEN", null, null, null, "DEFAULT", 0ul, "登录验证码的开关", "true-打开，false-关闭", 0, "Y", null, null, null, "true" },
|
||
{ "974740d8-8647-4cf8-8102-542eea53e97f", "DILON_DRUID_USERNAME", null, null, null, "DEFAULT", 0ul, "Druid监控登录账号", "Druid监控登录账号", 0, "Y", null, null, null, "superAdmin" },
|
||
{ "8cee44ea-ba4c-42db-a57d-69b8b5316ca5", "DILON_DRUID_PASSWORD", null, null, null, "DEFAULT", 0ul, "Druid监控界面登录密码", "Druid监控界面登录密码", 0, "Y", null, null, null, "123456" },
|
||
{ "59c8a6f2-9e3c-4e9e-b9cf-8ecad5f0cb45", "DILON_ENABLE_OAUTH_LOGIN", null, null, null, "OAUTH", 0ul, "Oauth用户登录的开关", "Oauth用户登录的开关", 0, "Y", null, null, null, "true" },
|
||
{ "d3597d8a-562a-4b24-93c7-8655c5445d74", "DILON_IP_GEO_APP_CODE", null, null, null, "DEFAULT", 0ul, "阿里云定位appCode", "阿里云定位appCode", 0, "Y", null, null, null, "461535aabeae4f34861884d392f5d452" },
|
||
{ "dc462c05-de23-4f90-bcdc-88de4abcdf22", "DILON_EMAIL_SSL", null, null, null, "EMAIL", 0ul, "邮箱是否开启ssl", "邮箱是否开启ssl", 0, "Y", null, null, null, "true" },
|
||
{ "ff502ee7-8129-4828-8d16-fb04562ef52c", "DILON_OAUTH_GITEE_CLIENT_ID", null, null, null, "OAUTH", 0ul, "Oauth码云登录ClientId", "Oauth码云登录ClientId", 0, "Y", null, null, null, "你的clientId" },
|
||
{ "a1d957ef-2b70-456f-8eda-b70a4cf01535", "DILON_OAUTH_GITEE_CLIENT_SECRET", null, null, null, "OAUTH", 0ul, "Oauth码云登录ClientSecret", "Oauth码云登录ClientSecret", 0, "Y", null, null, null, "你的clientSecret" },
|
||
{ "b32ee22b-671d-40bf-8070-32e1054fef96", "DILON_OAUTH_GITEE_REDIRECT_URI", null, null, null, "OAUTH", 0ul, "Oauth码云登录回调地址", "Oauth码云登录回调地址", 0, "Y", null, null, null, "http://127.0.0.1:5566/oauth/callback/gitee" },
|
||
{ "38dda85c-2a98-4768-aebd-a60ab286052c", "DILON_DEMO_ENV_FLAG", null, null, null, "DEFAULT", 0ul, "演示环境", "演示环境的开关,true-打开，false-关闭，如果演示环境开启，则只能读数据不能写数据", 0, "Y", null, null, null, "false" },
|
||
{ "efc235ab-9b05-4820-afe4-32a1eb59e4de", "DILON_IP_GEO_API", null, null, null, "DEFAULT", 0ul, "阿里云定位api接口地址", "阿里云定位api接口地址", 0, "Y", null, null, null, "http://api01.aliyun.venuscn.com/ip?ip=%s" },
|
||
{ "67e468f7-e791-4e91-a896-62e9f7411635", "DILON_EMAIL_PORT", null, null, null, "EMAIL", 0ul, "邮箱端口", "邮箱端口", 0, "Y", null, null, null, "465" },
|
||
{ "8beac2a0-4c67-4499-a7ce-27e989546ce9", "DILON_EMAIL_FROM", null, null, null, "EMAIL", 0ul, "邮箱发件人", "邮箱发件人", 0, "Y", null, null, null, "test@126.com" },
|
||
{ "997a9bc6-22ed-4fe6-a20c-c3c2a0b682a0", "DILON_EMAIL_USERNAME", null, null, null, "EMAIL", 0ul, "邮箱用户名", "邮箱用户名", 0, "Y", null, null, null, "test@126.com" },
|
||
{ "7c2765cd-d39b-4772-8d6c-0dbcdcfa1ff8", "DILON_JWT_SECRET", null, null, null, "DEFAULT", 0ul, "jwt密钥", "（重要）jwt密钥，默认为空，自行设置", 0, "Y", null, null, null, "xiaonuo" },
|
||
{ "e3553657-14cf-4c26-ba7b-dbb4bfd4bc55", "DILON_DEFAULT_PASSWORD", null, null, null, "DEFAULT", 0ul, "默认密码", "默认密码", 0, "Y", null, null, null, "123456" },
|
||
{ "633d1851-41d9-4ebd-b83b-3aa4501cd1a7", "DILON_EMAIL_PASSWORD", null, null, null, "EMAIL", 0ul, "邮箱密码", "邮箱密码", 0, "Y", null, null, null, "你的邮箱密码" },
|
||
{ "8938506d-2e00-44e0-8592-48453d43f9f5", "DILON_SESSION_EXPIRE", null, null, null, "DEFAULT", 0ul, "session会话过期时间", "session会话过期时间（单位：秒）", 0, "Y", null, null, null, "7200" },
|
||
{ "beb2e9e7-f4d9-43b1-bfab-3557ea232f8d", "DILON_ALIYUN_SMS_ACCESSKEY_ID", null, null, null, "ALIYUN_SMS", 0ul, "阿里云短信keyId", "阿里云短信keyId", 0, "Y", null, null, null, "你的keyId" },
|
||
{ "ead14cd0-9fd4-4fd6-b75c-239d8b2ebed8", "DILON_ALIYUN_SMS_ACCESSKEY_SECRET", null, null, null, "ALIYUN_SMS", 0ul, "阿里云短信secret", "阿里云短信secret", 0, "Y", null, null, null, "你的secret" },
|
||
{ "beaaafc2-3fdf-42af-9b06-ead3a6dd6306", "DILON_ALIYUN_SMS_SIGN_NAME", null, null, null, "ALIYUN_SMS", 0ul, "阿里云短信签名", "阿里云短信签名", 0, "Y", null, null, null, "你的签名" },
|
||
{ "2c677cd2-2a54-46c6-971d-f9fe20f101f3", "DILON_TOKEN_EXPIRE", null, null, null, "DEFAULT", 0ul, "token过期时间", "token过期时间（单位：秒）", 0, "Y", null, null, null, "86400" },
|
||
{ "24d3f286-efca-49af-91b4-e3ce42cce36e", "DILON_ALIYUN_SMS_INVALIDATE_MINUTES", null, null, null, "ALIYUN_SMS", 0ul, "阿里云短信默认失效时间", "阿里云短信默认失效时间（单位：分钟）", 0, "Y", null, null, null, "5" },
|
||
{ "c6540a07-ce32-47b4-ab83-b647bdb14491", "DILON_TENCENT_SMS_SECRET_ID", null, null, null, "TENCENT_SMS", 0ul, "腾讯云短信secretId", "腾讯云短信secretId", 0, "Y", null, null, null, "你的secretId" },
|
||
{ "a0412212-d50b-42aa-9484-3cef8fe3cc59", "DILON_TENCENT_SMS_SECRET_KEY", null, null, null, "TENCENT_SMS", 0ul, "腾讯云短信secretKey", "腾讯云短信secretKey", 0, "Y", null, null, null, "你的secretkey" },
|
||
{ "c928ca11-5137-4b71-bf1c-f3bc95bcd34d", "DILON_TENCENT_SMS_SDK_APP_ID", null, null, null, "TENCENT_SMS", 0ul, "腾讯云短信sdkAppId", "腾讯云短信sdkAppId", 0, "Y", null, null, null, "1400375123" },
|
||
{ "16ce1b6e-c8ad-4299-9293-6caff0e5cb49", "DILON_TENCENT_SMS_SIGN", null, null, null, "TENCENT_SMS", 0ul, "腾讯云短信签名", "腾讯云短信签名", 0, "Y", null, null, null, "你的签名" },
|
||
{ "66e63d64-b7eb-4e6a-b5b6-c87811c2e700", "DILON_EMAIL_HOST", null, null, null, "EMAIL", 0ul, "邮箱host", "邮箱host", 0, "Y", null, null, null, "smtp.126.com" },
|
||
{ "e26a10cf-911a-4fe0-a113-76965be749a0", "DILON_ALIYUN_SMS_LOGIN_TEMPLATE_CODE", null, null, null, "ALIYUN_SMS", 0ul, "阿里云短信-登录模板号", "阿里云短信-登录模板号", 0, "Y", null, null, null, "SMS_1877123456" }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_dict_type",
|
||
columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Remark", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
|
||
values: new object[,]
|
||
{
|
||
{ "0f1b8660-d932-4a53-a681-a38bebae91e0", "run_status", null, null, null, 0ul, "运行状态", "定时任务运行状态", 100, 0, null, null, null },
|
||
{ "d5b311fd-4b60-4b51-9156-b0e6d6cfa4d1", "notice_type", null, null, null, 0ul, "通知公告类型", "通知公告类型", 100, 0, null, null, null },
|
||
{ "b30937e6-03cd-4d98-a413-10b06d605e5a", "notice_status", null, null, null, 0ul, "通知公告状态", "通知公告状态", 100, 0, null, null, null },
|
||
{ "80aea9e7-ad1b-4f57-b4db-9d15813707bd", "yes_true_false", null, null, null, 0ul, "是否boolean", "是否boolean", 100, 0, null, null, null },
|
||
{ "41bc31f6-cef5-400d-b03a-bf51d27b2432", "code_gen_query_type", null, null, null, 0ul, "代码生成查询类型", "代码生成查询类型", 100, 0, null, null, null },
|
||
{ "bc0dc25b-b85e-4dd1-8368-e014fe1bf30b", "request_type", null, null, null, 0ul, "请求方式", "请求方式", 100, 0, null, null, null },
|
||
{ "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", "code_gen_effect_type", null, null, null, 0ul, "代码生成作用类型", "代码生成作用类型", 100, 0, null, null, null },
|
||
{ "28f653d4-e573-4f54-8e5c-4e308780145a", "code_gen_net_type", null, null, null, 0ul, "代码生成.NET类型", "代码生成.NET类型", 100, 0, null, null, null },
|
||
{ "b924e0c1-3f23-4e37-9f27-90e945381304", "file_storage_location", null, null, null, 0ul, "文件存储位置", "文件存储位置", 100, 0, null, null, null },
|
||
{ "430d0538-054a-4b37-a459-1095d0ccf4ae", "code_gen_create_type", null, null, null, 0ul, "代码生成方式", "代码生成方式", 100, 0, null, null, null },
|
||
{ "8461bd1d-311b-487e-b579-d6049c6fb191", "op_type", null, null, null, 0ul, "操作类型", "操作类型", 100, 0, null, null, null },
|
||
{ "688f9a69-ec95-46f4-87bb-e19e3cc5c7fc", "sms_send_source", null, null, null, 0ul, "短信发送来源", "短信发送来源", 100, 0, null, null, null },
|
||
{ "a2068ed1-62a6-463c-b720-06111d994079", "data_scope_type", null, null, null, 0ul, "数据范围类型", "数据范围类型", 100, 0, null, null, null },
|
||
{ "b0cfa91c-1189-4f39-bc5a-f035885d0604", "common_status", null, null, null, 0ul, "通用状态", "通用状态", 100, 0, null, null, null },
|
||
{ "301ed120-dfc5-4d7c-af59-b56a519581c9", "sex", null, null, null, 0ul, "性别", "性别字典", 100, 0, null, null, null },
|
||
{ "64afb5e7-9f00-4c4f-9ba6-6b41221bd862", "consts_type", null, null, null, 0ul, "常量的分类", "常量的分类，用于区别一组配置", 100, 0, null, null, null },
|
||
{ "f2f0e8bf-04da-4a2f-9fb8-1d6549227302", "yes_or_no", null, null, null, 0ul, "是否", "是否", 100, 0, null, null, null },
|
||
{ "2815b28b-e51d-4dfb-b549-2eaa27d8c23d", "dic_areacode_type", null, null, null, 0ul, "区域编码类型", "区域编码类型", 0, 0, null, null, null },
|
||
{ "e973d383-c28e-42e0-9e23-5f2bd592fef5", "menu_type", null, null, null, 0ul, "菜单类型", "菜单类型", 100, 0, null, null, null },
|
||
{ "058db370-3718-42c3-8ba7-095341b1fe13", "send_type", null, null, null, 0ul, "发送类型", "发送类型", 100, 0, null, null, null },
|
||
{ "ff6202cb-25ce-4ab9-9c39-910c418b1d2d", "open_type", null, null, null, 0ul, "打开方式", "打开方式", 100, 0, null, null, null },
|
||
{ "b3235678-f7fe-442b-8fba-e792a89b78f2", "menu_weight", null, null, null, 0ul, "菜单权重", "菜单权重", 100, 0, null, null, null },
|
||
{ "2cecf329-cf95-44eb-a8d7-3fb77b13e093", "vis_type", null, null, null, 0ul, "访问类型", "访问类型", 100, 0, null, null, null }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_emp",
|
||
columns: new[] { "Id", "JobNum", "OrgId", "OrgName" },
|
||
values: new object[,]
|
||
{
|
||
{ "d0ead3dc-5096-4e15-bc6d-f640be5301ec", "D1001", "12d888de-f55d-4c88-b0a0-7c3510664d97", "华夏集团" },
|
||
{ "5398fb9a-2209-4ce7-a2c1-b6a983e502b5", "D1002", "12d888de-f55d-4c88-b0a0-7c3510664d97", "华夏集团" },
|
||
{ "16a74726-e156-499f-9942-0e0e24ad0c3f", "D1003", "12d888de-f55d-4c88-b0a0-7c3510664d97", "华夏集团" }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_menu",
|
||
columns: new[] { "Id", "Application", "Code", "Component", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Link", "Name", "OpenType", "Permission", "Pid", "Pids", "Redirect", "Remark", "Router", "Sort", "Status", "Type", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Visible", "VisibleParent", "Weight" },
|
||
values: new object[,]
|
||
{
|
||
{ "122641c1-ab6d-4f91-9527-16fc8fea9708", "system", "sys_log_mgr_vis_log_page", null, null, null, null, null, 0ul, null, "访问日志查询", 0, "sysVisLog:page", "322b2cb6-df29-483b-b011-54dce1532fae", "[00000000-0000-0000-0000-000000000000],[eec4563e-9307-4ccd-ac3a-93598badb195],[322b2cb6-df29-483b-b011-54dce1532fae],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "38809fc3-163f-4fe9-a488-c9bb5bce752a", "system", "sys_dict_mgr_dict_edit", null, null, null, null, null, 0ul, null, "字典值编辑", 0, "sysDictData:edit", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "fc511b42-f0a1-489b-8418-7ef94b0fb374", "system", "sys_role_mgr_grant_data", null, null, null, null, null, 0ul, null, "字典值详情", 0, "sysDictData:detail", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "200428b3-1605-4c70-b840-e691e302ae69", "system", "sys_dict_mgr_dict_change_status", null, null, null, null, null, 0ul, null, "字典值修改状态", 0, "sysDictData:changeStatus", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "d40f424d-d5fc-4b86-a2bd-3a5a76076bc1", "system", "sys_swagger_mgr", "Iframe", null, null, null, null, 0ul, "http://127.0.0.1:5566/", "接口文档", 2, null, "ac0ee878-f713-4a77-9c8f-6e1ee1f4484e", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],", null, null, "/swagger", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "eec4563e-9307-4ccd-ac3a-93598badb195", "system", "sys_log_mgr", "PageView", null, null, null, "read", 0ul, null, "日志管理", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/log", 100, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "322b2cb6-df29-483b-b011-54dce1532fae", "system", "sys_log_mgr_vis_log", "system/log/vislog/index", null, null, null, null, 0ul, null, "访问日志", 1, null, "eec4563e-9307-4ccd-ac3a-93598badb195", "[00000000-0000-0000-0000-000000000000],[eec4563e-9307-4ccd-ac3a-93598badb195],", null, null, "/vislog", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f2367804-6382-4e72-8282-e4f6f988ecd1", "system", "sys_log_mgr_vis_log_delete", null, null, null, null, null, 0ul, null, "访问日志清空", 0, "sysVisLog:delete", "322b2cb6-df29-483b-b011-54dce1532fae", "[00000000-0000-0000-0000-000000000000],[eec4563e-9307-4ccd-ac3a-93598badb195],[322b2cb6-df29-483b-b011-54dce1532fae],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "49a8b476-327b-4f33-87b8-2d9bc50dc390", "system", "sys_monitor_mgr_online_user", "system/onlineUser/index", null, null, null, null, 0ul, null, "在线用户", 1, null, "cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c", "[00000000-0000-0000-0000-000000000000],[cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c],", null, null, "/onlineUser", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "7f44f49e-6458-4149-bbcd-9a937f552cec", "system", "sys_log_mgr_op_log_page", null, null, null, null, null, 0ul, null, "操作日志查询", 0, "sysOpLog:page", "1a1a13cb-f9a9-4ffe-924d-d523db79f7bf", "[00000000-0000-0000-0000-000000000000],[eec4563e-9307-4ccd-ac3a-93598badb195],[1a1a13cb-f9a9-4ffe-924d-d523db79f7bf],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "263e0c00-2796-411c-9f50-0aa361f7781c", "system", "sys_log_mgr_op_log_delete", null, null, null, null, null, 0ul, null, "操作日志清空", 0, "sysOpLog:delete", "1a1a13cb-f9a9-4ffe-924d-d523db79f7bf", "[00000000-0000-0000-0000-000000000000],[eec4563e-9307-4ccd-ac3a-93598badb195],[1a1a13cb-f9a9-4ffe-924d-d523db79f7bf],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c", "system", "sys_monitor_mgr", "PageView", null, null, null, "deployment-unit", 0ul, null, "系统监控", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/monitor", 100, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "c1e70042-fe3f-4efc-a6cc-86de8507f948", "system", "sys_monitor_mgr_machine_monitor", "system/machine/index", null, null, null, null, 0ul, null, "服务监控", 1, null, "cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c", "[00000000-0000-0000-0000-000000000000],[cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c],", null, null, "/machine", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "444f3658-defe-47a7-880e-bf0af8b66591", "system", "sys_monitor_mgr_machine_monitor_query", null, null, null, null, null, 0ul, null, "服务监控查询", 0, "sysMachine:query", "c1e70042-fe3f-4efc-a6cc-86de8507f948", "[00000000-0000-0000-0000-000000000000],[cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c],[c1e70042-fe3f-4efc-a6cc-86de8507f948],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "be98da08-a3b0-463c-8208-05d843620258", "system", "sys_dict_mgr_dict_delete", null, null, null, null, null, 0ul, null, "字典值删除", 0, "sysDictData:delete", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "4785eb5a-678a-4f9c-b07c-3b92acdd6de0", "system", "sys_monitor_mgr_online_user_list", null, null, null, null, null, 0ul, null, "在线用户列表", 0, "sysOnlineUser:list", "49a8b476-327b-4f33-87b8-2d9bc50dc390", "[00000000-0000-0000-0000-000000000000],[cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c],[49a8b476-327b-4f33-87b8-2d9bc50dc390],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "1a1a13cb-f9a9-4ffe-924d-d523db79f7bf", "system", "sys_log_mgr_op_log", "system/log/oplog/index", null, null, null, null, 0ul, null, "操作日志", 1, null, "eec4563e-9307-4ccd-ac3a-93598badb195", "[00000000-0000-0000-0000-000000000000],[eec4563e-9307-4ccd-ac3a-93598badb195],", null, null, "/oplog", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "54e97bde-94d6-42df-89e3-4c3ace153b22", "system", "sys_dict_mgr_dict_add", null, null, null, null, null, 0ul, null, "字典值增加", 0, "sysDictData:add", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "1f7a41ff-5a46-449c-81f3-1618dfdcb4cd", "system", "sys_dict_mgr_dict_type_delete", null, null, null, null, null, 0ul, null, "字典类型删除", 0, "sysDictType:delete", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "29be8e3c-c2bb-4162-b282-fdf58c218b9d", "system", "sys_dict_mgr_dict_page", null, null, null, null, null, 0ul, null, "字典值查询", 0, "sysDictData:page", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "cde43456-baae-4e9b-b6f9-b0ea9ab49adb", "system", "sys_email_mgr", "system/email/index", null, null, null, null, 0ul, null, "邮件发送", 1, null, "ac0ee878-f713-4a77-9c8f-6e1ee1f4484e", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],", null, null, "/email", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "4d4cf5b3-bd4c-4f17-9fb2-47b28b00681f", "system", "sys_email_mgr_send_email", null, null, null, null, null, 0ul, null, "发送文本邮件", 0, "email:sendEmail", "cde43456-baae-4e9b-b6f9-b0ea9ab49adb", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[cde43456-baae-4e9b-b6f9-b0ea9ab49adb],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "51e45073-1461-4b3b-ae06-d0d3dcf222e0", "system", "sys_email_mgr_send_email_html", null, null, null, null, null, 0ul, null, "发送html邮件", 0, "email:sendEmailHtml", "cde43456-baae-4e9b-b6f9-b0ea9ab49adb", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[cde43456-baae-4e9b-b6f9-b0ea9ab49adb],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e571a1c9-8b43-459f-9dc6-1dcf967627b7", "system", "sys_sms_mgr", "system/sms/index", null, null, null, null, 0ul, null, "短信管理", 1, null, "ac0ee878-f713-4a77-9c8f-6e1ee1f4484e", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],", null, null, "/sms", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "2afa4925-b927-457e-88a1-d215b7d75fb6", "system", "sys_sms_mgr_page", null, null, null, null, null, 0ul, null, "短信发送查询", 0, "sms:page", "e571a1c9-8b43-459f-9dc6-1dcf967627b7", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[e571a1c9-8b43-459f-9dc6-1dcf967627b7],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "97c1b073-5e19-4542-89e2-d8da44d0f1df", "system", "sys_sms_mgr_send_login_message", null, null, null, null, null, 0ul, null, "发送验证码短信", 0, "sms:sendLoginMessage", "e571a1c9-8b43-459f-9dc6-1dcf967627b7", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[e571a1c9-8b43-459f-9dc6-1dcf967627b7],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "d2454bd2-f300-4b28-95c0-12432c28cbdf", "system", "sys_sms_mgr_validate_message", null, null, null, null, null, 0ul, null, "验证短信验证码", 0, "sms:validateMessage", "e571a1c9-8b43-459f-9dc6-1dcf967627b7", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[e571a1c9-8b43-459f-9dc6-1dcf967627b7],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "b8cbc4e1-ac10-4cda-b1e4-f816a2632d02", "system", "sys_dict_mgr_dict_list", null, null, null, null, null, 0ul, null, "字典值列表", 0, "sysDictData:list", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "system", "sys_dict_mgr", "system/dict/index", null, null, null, null, 0ul, null, "字典管理", 1, null, "ac0ee878-f713-4a77-9c8f-6e1ee1f4484e", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],", null, null, "/dict", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "1bd1d982-e05a-4bdc-a4e0-752d94f3196c", "system", "sys_dict_mgr_dict_type_list", null, null, null, null, null, 0ul, null, "字典类型列表", 0, "sysDictType:list", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "bd09b023-0884-4f31-8cf7-f66f789fa3db", "system", "sys_dict_mgr_dict_type_add", null, null, null, null, null, 0ul, null, "字典类型增加", 0, "sysDictType:add", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "4dbf6765-ac79-4708-a9d5-16a4d4b09164", "system", "sys_monitor_mgr_online_user_force_exist", null, null, null, null, null, 0ul, null, "在线用户强退", 0, "sysOnlineUser:forceExist", "49a8b476-327b-4f33-87b8-2d9bc50dc390", "[00000000-0000-0000-0000-000000000000],[cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c],[49a8b476-327b-4f33-87b8-2d9bc50dc390],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "2381cde4-2174-47e7-a1e5-e58da70e7a11", "system", "sys_dict_mgr_dict_type_edit", null, null, null, null, null, 0ul, null, "字典类型编辑", 0, "sysDictType:edit", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "8f7d3c74-8800-4922-9662-ac6af378c882", "system", "sys_dict_mgr_dict_type_detail", null, null, null, null, null, 0ul, null, "字典类型详情", 0, "sysDictType:detail", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "4f87b6de-be62-4398-b680-1f8611f2cd70", "system", "sys_dict_mgr_dict_type_drop_down", null, null, null, null, null, 0ul, null, "字典类型下拉", 0, "sysDictType:dropDown", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "07c799b2-e8e9-4955-83da-97560f161d87", "system", "sys_dict_mgr_dict_type_change_status", null, null, null, null, null, 0ul, null, "字典类型修改状态", 0, "sysDictType:changeStatus", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "70c5e8c5-6104-4e53-99c0-4743e557456b", "system", "sys_dict_mgr_dict_type_page", null, null, null, null, null, 0ul, null, "字典类型查询", 0, "sysDictType:page", "477739a3-53d8-4f9b-ba32-f6dda79ec8a8", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[477739a3-53d8-4f9b-ba32-f6dda79ec8a8],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "31c2af01-b856-4a1d-a131-cdf8e847b1a4", "system", "sys_monitor_mgr_druid", "Iframe", null, null, null, null, 0ul, "http://localhost:82/druid/login.html", "数据监控", 2, null, "cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c", "[00000000-0000-0000-0000-000000000000],[cf72e37b-3d3b-4dba-bcd0-3fb4bd54757c],", null, null, "/druid", 100, 0, 1, null, null, null, 0ul, 0ul, 1 },
|
||
{ "f4cf2a3d-0714-4ca4-a691-0b363c172f82", "advanced", "sys_tenant", "PageView", null, null, null, "switcher", 0ul, null, "SaaS租户", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/tenant", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e8ca3968-e404-4ea6-a71a-d06d06b51bd5", "system", "sys_notice_mgr", "system/notice/index", null, null, null, null, 0ul, null, "公告管理", 1, null, "d4cac841-99e5-4014-af17-2986c9340306", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],", null, null, "/notice", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "1e562d31-c2f8-4af8-be4b-47e3b251d9a3", "system", "sys_timers_mgr_detail", null, null, null, null, null, 0ul, null, "定时任务详情", 0, "sysTimers:detail", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f27ba442-7d6f-499f-8053-a737adc3492a", "system", "sys_timers_mgr_add", null, null, null, null, null, 0ul, null, "定时任务增加", 0, "sysTimers:add", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "99129601-0be5-43ee-842b-a428603f013b", "system", "sys_timers_mgr_delete", null, null, null, null, null, 0ul, null, "定时任务删除", 0, "sysTimers:delete", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "5e118fc0-f580-4d06-a89d-f321a84e5654", "system", "sys_timers_mgr_edit", null, null, null, null, null, 0ul, null, "定时任务编辑", 0, "sysTimers:edit", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_menu",
|
||
columns: new[] { "Id", "Application", "Code", "Component", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Link", "Name", "OpenType", "Permission", "Pid", "Pids", "Redirect", "Remark", "Router", "Sort", "Status", "Type", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Visible", "VisibleParent", "Weight" },
|
||
values: new object[,]
|
||
{
|
||
{ "4272f2e4-4a8b-45bb-b688-2b9471c35e83", "system", "sys_timers_mgr_get_action_classes", null, null, null, null, null, 0ul, null, "定时任务可执行列表", 0, "sysTimers:getActionClasses", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "54094687-f661-4cba-bdfc-e76f22db8d76", "system", "sys_timers_mgr_start", null, null, null, null, null, 0ul, null, "定时任务启动", 0, "sysTimers:start", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "6b82d407-d1ea-440e-9245-128ad03dffc0", "system", "sys_timers_mgr_stop", null, null, null, null, null, 0ul, null, "定时任务关闭", 0, "sysTimers:stop", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "dc07cd9f-4a53-40d9-988e-70290a146eff", "system", "sys_timers_mgr_list", null, null, null, null, null, 0ul, null, "定时任务列表", 0, "sysTimers:list", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "5172265d-eda3-4b8a-a542-d582467a51a1", "system_tool", "code_gen", "gen/codeGenerate/index", null, null, null, "thunderbolt", 0ul, null, "代码生成", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/codeGenerate/index", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f7fe47a3-86b2-4660-9920-0c9836755666", "system", "sys_app_mgr_set_as_default", null, null, null, null, null, 0ul, null, "设为默认应用", 0, "sysApp:setAsDefault", "abf3e33d-3d6a-4bbd-8743-179df5a95d48", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[abf3e33d-3d6a-4bbd-8743-179df5a95d48],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "a6e5cd91-e3de-401d-bc8c-86bd464ab32e", "advanced", "sys_tenant_mgr", "system/tenant/index", null, null, null, null, 0ul, null, "租户管理", 1, null, "f4cf2a3d-0714-4ca4-a691-0b363c172f82", "[00000000-0000-0000-0000-000000000000],[f4cf2a3d-0714-4ca4-a691-0b363c172f82],", null, null, "/tenant", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "8985ec0a-5060-4812-bf47-4f3102948066", "advanced", "sys_tenant_mgr_page", null, null, null, null, null, 0ul, null, "租户查询", 0, "sysTenant:page", "a6e5cd91-e3de-401d-bc8c-86bd464ab32e", "[00000000-0000-0000-0000-000000000000],[f4cf2a3d-0714-4ca4-a691-0b363c172f82],[a6e5cd91-e3de-401d-bc8c-86bd464ab32e],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "d9584afb-18de-4f7e-b992-c21ad77b1aae", "advanced", "sys_tenant_mgr_detail", null, null, null, null, null, 0ul, null, "租户详情", 0, "sysTenant:detail", "a6e5cd91-e3de-401d-bc8c-86bd464ab32e", "[00000000-0000-0000-0000-000000000000],[f4cf2a3d-0714-4ca4-a691-0b363c172f82],[a6e5cd91-e3de-401d-bc8c-86bd464ab32e],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "01ae6b95-9c1e-4882-a9ac-ebb9f1868c54", "advanced", "sys_tenant_mgr_add", null, null, null, null, null, 0ul, null, "租户增加", 0, "sysTenant:add", "a6e5cd91-e3de-401d-bc8c-86bd464ab32e", "[00000000-0000-0000-0000-000000000000],[f4cf2a3d-0714-4ca4-a691-0b363c172f82],[a6e5cd91-e3de-401d-bc8c-86bd464ab32e],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "59e9f6da-151a-4201-bea1-00ef06fe5842", "advanced", "sys_tenant_mgr_delete", null, null, null, null, null, 0ul, null, "租户删除", 0, "sysTenant:delete", "a6e5cd91-e3de-401d-bc8c-86bd464ab32e", "[00000000-0000-0000-0000-000000000000],[f4cf2a3d-0714-4ca4-a691-0b363c172f82],[a6e5cd91-e3de-401d-bc8c-86bd464ab32e],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "220b6a86-e65d-469b-8aa0-46c4f5e77ab8", "advanced", "sys_tenant_mgr_edit", null, null, null, null, null, 0ul, null, "租户编辑", 0, "sysTenant:edit", "a6e5cd91-e3de-401d-bc8c-86bd464ab32e", "[00000000-0000-0000-0000-000000000000],[f4cf2a3d-0714-4ca4-a691-0b363c172f82],[a6e5cd91-e3de-401d-bc8c-86bd464ab32e],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "cf51df0a-8e0b-4252-ba06-9646cad648d1", "system_tool", "form_design", "system/formDesign/index", null, null, null, "robot", 0ul, null, "表单设计", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/formDesign/index", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "db62154a-470e-43c8-8959-a686b954fe7d", "system", "sys_timers_mgr_page", null, null, null, null, null, 0ul, null, "定时任务查询", 0, "sysTimers:page", "8d4643d7-ec15-48ba-b896-816f8dab1b31", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],[8d4643d7-ec15-48ba-b896-816f8dab1b31],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "8d4643d7-ec15-48ba-b896-816f8dab1b31", "system", "sys_timers_mgr", "system/timers/index", null, null, null, null, 0ul, null, "任务管理", 1, null, "ba03cfd5-5d72-465f-87b6-71134da68fab", "[00000000-0000-0000-0000-000000000000],[ba03cfd5-5d72-465f-87b6-71134da68fab],", null, null, "/timers", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "ba03cfd5-5d72-465f-87b6-71134da68fab", "system", "sys_timers", "PageView", null, null, null, "dashboard", 0ul, null, "定时任务", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/timers", 100, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "54584ab7-25d1-45b7-b3d4-76ba21511f97", "system", "sys_notice_mgr_page", null, null, null, null, null, 0ul, null, "公告查询", 0, "sysNotice:page", "e8ca3968-e404-4ea6-a71a-d06d06b51bd5", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],[e8ca3968-e404-4ea6-a71a-d06d06b51bd5],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f27c8431-7da5-4ffe-a8f3-b511cf44c0c8", "system", "sys_notice_mgr_add", null, null, null, null, null, 0ul, null, "公告增加", 0, "sysNotice:add", "e8ca3968-e404-4ea6-a71a-d06d06b51bd5", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],[e8ca3968-e404-4ea6-a71a-d06d06b51bd5],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f84c1f3a-3a51-4be2-97c9-7543b044e457", "system", "sys_notice_mgr_edit", null, null, null, null, null, 0ul, null, "公告编辑", 0, "sysNotice:edit", "e8ca3968-e404-4ea6-a71a-d06d06b51bd5", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],[e8ca3968-e404-4ea6-a71a-d06d06b51bd5],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "a8abcb85-ad3b-47b9-8c9b-e7d1876b90cf", "system", "sys_notice_mgr_delete", null, null, null, null, null, 0ul, null, "公告删除", 0, "sysNotice:delete", "e8ca3968-e404-4ea6-a71a-d06d06b51bd5", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],[e8ca3968-e404-4ea6-a71a-d06d06b51bd5],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "fe9cbb41-7b05-4f32-b960-87a1ef146166", "system", "sys_notice_mgr_detail", null, null, null, null, null, 0ul, null, "公告查看", 0, "sysNotice:detail", "e8ca3968-e404-4ea6-a71a-d06d06b51bd5", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],[e8ca3968-e404-4ea6-a71a-d06d06b51bd5],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "3e547bb0-4cf5-4cf0-8386-48d2f3c12dcb", "system", "sys_notice_mgr_changeStatus", null, null, null, null, null, 0ul, null, "公告修改状态", 0, "sysNotice:changeStatus", "e8ca3968-e404-4ea6-a71a-d06d06b51bd5", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],[e8ca3968-e404-4ea6-a71a-d06d06b51bd5],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "ac3065ff-d239-4e0e-86e5-d72cc658224c", "system", "sys_notice_mgr_received", "system/noticeReceived/index", null, null, null, null, 0ul, null, "已收公告", 1, null, "d4cac841-99e5-4014-af17-2986c9340306", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],", null, null, "/noticeReceived", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e2d4b13b-eb3e-4ead-8fb8-4c61a3004726", "system", "sys_notice_mgr_received_page", null, null, null, null, null, 0ul, null, "已收公告查询", 0, "sysNotice:received", "ac3065ff-d239-4e0e-86e5-d72cc658224c", "[00000000-0000-0000-0000-000000000000],[d4cac841-99e5-4014-af17-2986c9340306],[ac3065ff-d239-4e0e-86e5-d72cc658224c],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "05326e62-f496-4950-8a29-40e8a479424f", "system", "sys_file_mgr", "PageView", null, null, null, "file", 0ul, null, "文件管理", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/file", 100, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "0af2a460-bbb0-472c-b027-8532970425df", "system", "sys_file_mgr_sys_file", "system/file/index", null, null, null, null, 0ul, null, "系统文件", 1, null, "05326e62-f496-4950-8a29-40e8a479424f", "[00000000-0000-0000-0000-000000000000],[05326e62-f496-4950-8a29-40e8a479424f],", null, null, "/file", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "c7bac800-b922-4173-bd8d-9888b4eab1d4", "system", "sys_file_mgr_sys_file_page", null, null, null, null, null, 0ul, null, "文件查询", 0, "sysFileInfo:page", "0af2a460-bbb0-472c-b027-8532970425df", "[00000000-0000-0000-0000-000000000000],[05326e62-f496-4950-8a29-40e8a479424f],[0af2a460-bbb0-472c-b027-8532970425df],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f47e1fa7-6329-4d67-8fe6-36ca06aad54b", "system", "sys_file_mgr_sys_file_list", null, null, null, null, null, 0ul, null, "文件列表", 0, "sysFileInfo:list", "0af2a460-bbb0-472c-b027-8532970425df", "[00000000-0000-0000-0000-000000000000],[05326e62-f496-4950-8a29-40e8a479424f],[0af2a460-bbb0-472c-b027-8532970425df],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "cca0a2ee-cfb9-4996-affb-dc8d8168ac10", "system", "sys_file_mgr_sys_file_delete", null, null, null, null, null, 0ul, null, "文件删除", 0, "sysFileInfo:delete", "0af2a460-bbb0-472c-b027-8532970425df", "[00000000-0000-0000-0000-000000000000],[05326e62-f496-4950-8a29-40e8a479424f],[0af2a460-bbb0-472c-b027-8532970425df],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "eb738eaa-5eed-466d-b422-4eb6f4662dd9", "system", "sys_file_mgr_sys_file_detail", null, null, null, null, null, 0ul, null, "文件详情", 0, "sysFileInfo:detail", "0af2a460-bbb0-472c-b027-8532970425df", "[00000000-0000-0000-0000-000000000000],[05326e62-f496-4950-8a29-40e8a479424f],[0af2a460-bbb0-472c-b027-8532970425df],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "69b97ace-d849-4e52-8fc2-9da7d93e325f", "system", "sys_file_mgr_sys_file_upload", null, null, null, null, null, 0ul, null, "文件上传", 0, "sysFileInfo:upload", "0af2a460-bbb0-472c-b027-8532970425df", "[00000000-0000-0000-0000-000000000000],[05326e62-f496-4950-8a29-40e8a479424f],[0af2a460-bbb0-472c-b027-8532970425df],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e286d53d-bf3c-4711-b0a3-15cfad0a7521", "system", "sys_file_mgr_sys_file_download", null, null, null, null, null, 0ul, null, "文件下载", 0, "sysFileInfo:download", "0af2a460-bbb0-472c-b027-8532970425df", "[00000000-0000-0000-0000-000000000000],[05326e62-f496-4950-8a29-40e8a479424f],[0af2a460-bbb0-472c-b027-8532970425df],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "1975891b-7940-44a8-a513-9f2e8b05dda1", "system", "sys_file_mgr_sys_file_preview", null, null, null, null, null, 0ul, null, "图片预览", 0, "sysFileInfo:preview", "0af2a460-bbb0-472c-b027-8532970425df", "[00000000-0000-0000-0000-000000000000],[05326e62-f496-4950-8a29-40e8a479424f],[0af2a460-bbb0-472c-b027-8532970425df],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "d4cac841-99e5-4014-af17-2986c9340306", "system", "sys_notice", "PageView", null, null, null, "sound", 0ul, null, "通知公告", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/notice", 100, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "6bfc0c53-5d6c-437c-9757-bc79e664d0f5", "system", "system_tools_config_detail", null, null, null, null, null, 0ul, null, "配置详情", 0, "sysConfig:detail", "abf3e33d-3d6a-4bbd-8743-179df5a95d48", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[abf3e33d-3d6a-4bbd-8743-179df5a95d48],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "758e15e6-75a6-4b72-8f94-5da379e53354", "system", "sys_menu_mgr_add", null, null, null, null, null, 0ul, null, "菜单增加", 0, "sysMenu:add", "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[babff4e1-dd00-4e6b-909a-3aac76bb52cd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "1efb72e8-3449-490a-92e0-308b124c338f", "system", "system_tools_config_edit", null, null, null, null, null, 0ul, null, "配置编辑", 0, "sysConfig:edit", "abf3e33d-3d6a-4bbd-8743-179df5a95d48", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[abf3e33d-3d6a-4bbd-8743-179df5a95d48],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "471b5259-5f55-4643-841c-f07089cfafdf", "system", "sys_user_mgr_reset_pwd", null, null, null, null, null, 0ul, null, "用户重置密码", 0, "sysUser:resetPwd", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "471d3098-90a4-47e1-bd07-5d3ed8d21fb0", "system", "sys_user_mgr_login", null, null, null, null, null, 0ul, null, "用户登录信息", 0, "getLoginUser", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 1, 2, null, null, null, 0ul, 0ul, 1 },
|
||
{ "9c1b34f3-2412-496a-a42e-e4f6ae407ae1", "system", "sys_org_mgr", "system/org/index", null, null, null, null, 0ul, null, "机构管理", 1, null, "f7d60a3f-2de3-4dca-a1d6-385cee9638bc", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],", null, null, "/org", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "b7c34c9b-933e-4c48-b1d0-af15a1f7da1f", "system", "sys_org_mgr_page", null, null, null, null, null, 0ul, null, "机构查询", 0, "sysOrg:page", "9c1b34f3-2412-496a-a42e-e4f6ae407ae1", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9c1b34f3-2412-496a-a42e-e4f6ae407ae1],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "917064b2-c715-4fa4-9b2d-20a11b784ed1", "system", "sys_org_mgr_list", null, null, null, null, null, 0ul, null, "机构列表", 0, "sysOrg:list", "9c1b34f3-2412-496a-a42e-e4f6ae407ae1", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9c1b34f3-2412-496a-a42e-e4f6ae407ae1],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "d7c18d60-f28f-4a57-90b3-26fc95249ae0", "system", "sys_org_mgr_add", null, null, null, null, null, 0ul, null, "机构增加", 0, "sysOrg:add", "9c1b34f3-2412-496a-a42e-e4f6ae407ae1", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9c1b34f3-2412-496a-a42e-e4f6ae407ae1],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e65eb1e3-cc9e-4309-8c7a-9ac41765b239", "system", "sys_org_mgr_edit", null, null, null, null, null, 0ul, null, "机构编辑", 0, "sysOrg:edit", "9c1b34f3-2412-496a-a42e-e4f6ae407ae1", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9c1b34f3-2412-496a-a42e-e4f6ae407ae1],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "9d681aac-528a-46b0-9718-ffc4abe9c29e", "system", "sys_user_mgr_update_avatar", null, null, null, null, null, 0ul, null, "用户修改头像", 0, "sysUser:updateAvatar", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "c2450c4c-89c6-46e8-8f89-11331790cbe3", "system", "sys_org_mgr_delete", null, null, null, null, null, 0ul, null, "机构删除", 0, "sysOrg:delete", "9c1b34f3-2412-496a-a42e-e4f6ae407ae1", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9c1b34f3-2412-496a-a42e-e4f6ae407ae1],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "2d153046-279b-43be-8f57-46875118fd2c", "system", "sys_org_mgr_tree", null, null, null, null, null, 0ul, null, "机构树", 0, "sysOrg:tree", "9c1b34f3-2412-496a-a42e-e4f6ae407ae1", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9c1b34f3-2412-496a-a42e-e4f6ae407ae1],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "5760230f-e6fc-4c3d-ba38-1c8a5a923eb3", "system", "system_tools_config_delete", null, null, null, null, null, 0ul, null, "配置删除", 0, "sysConfig:delete", "abf3e33d-3d6a-4bbd-8743-179df5a95d48", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[abf3e33d-3d6a-4bbd-8743-179df5a95d48],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "d2436601-bc48-4610-ba67-5b666f8ce33a", "system", "sys_pos_mgr_page", null, null, null, null, null, 0ul, null, "职位查询", 0, "sysPos:page", "0f60d129-9d3b-42b5-9eb2-99bc066be6aa", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[0f60d129-9d3b-42b5-9eb2-99bc066be6aa],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "1305efaa-b81a-475f-9dde-8f6549ca7743", "system", "sys_pos_mgr_list", null, null, null, null, null, 0ul, null, "职位列表", 0, "sysPos:list", "0f60d129-9d3b-42b5-9eb2-99bc066be6aa", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[0f60d129-9d3b-42b5-9eb2-99bc066be6aa],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "c227e732-f231-4488-89b0-d1c9dad78950", "system", "sys_pos_mgr_add", null, null, null, null, null, 0ul, null, "职位增加", 0, "sysPos:add", "0f60d129-9d3b-42b5-9eb2-99bc066be6aa", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[0f60d129-9d3b-42b5-9eb2-99bc066be6aa],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "9dafbe04-83c9-482c-9c83-81f4da045da5", "system", "sys_pos_mgr_edit", null, null, null, null, null, 0ul, null, "职位编辑", 0, "sysPos:edit", "0f60d129-9d3b-42b5-9eb2-99bc066be6aa", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[0f60d129-9d3b-42b5-9eb2-99bc066be6aa],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "031df05e-b7c6-4ecd-aff2-f189c994e86d", "system", "sys_pos_mgr_delete", null, null, null, null, null, 0ul, null, "职位删除", 0, "sysPos:delete", "0f60d129-9d3b-42b5-9eb2-99bc066be6aa", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[0f60d129-9d3b-42b5-9eb2-99bc066be6aa],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "695a6018-82c3-466e-a2a1-dab16039bfdb", "system", "sys_org_mgr_detail", null, null, null, null, null, 0ul, null, "机构详情", 0, "sysOrg:detail", "9c1b34f3-2412-496a-a42e-e4f6ae407ae1", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9c1b34f3-2412-496a-a42e-e4f6ae407ae1],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "fe5ee8a1-2145-43c6-bdeb-518f3a9c127d", "system", "sys_pos_mgr_detail", null, null, null, null, null, 0ul, null, "职位详情", 0, "sysPos:detail", "0f60d129-9d3b-42b5-9eb2-99bc066be6aa", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[0f60d129-9d3b-42b5-9eb2-99bc066be6aa],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "791b0d88-7e25-490f-a94f-a2e32bb3b6e6", "system", "sys_user_mgr_change_status", null, null, null, null, null, 0ul, null, "用户修改状态", 0, "sysUser:changeStatus", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "711563e5-fed6-44d6-bcf3-138c73cfbfca", "system", "sys_user_mgr_update_info", null, null, null, null, null, 0ul, null, "用户更新信息", 0, "sysUser:updateInfo", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "83ce02c9-b37f-4885-96e3-9b34371edb2e", "system", "system_index", "RouteView", null, null, null, "home", 0ul, null, "主控面板", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", "/analysis", null, "/", 1, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "914a520d-9e4f-465b-ae05-7248b37d4be1", "system", "system_index_dashboard", "system/dashboard/Analysis", null, null, null, null, 0ul, null, "分析页", 0, null, "83ce02c9-b37f-4885-96e3-9b34371edb2e", "[00000000-0000-0000-0000-000000000000],[83ce02c9-b37f-4885-96e3-9b34371edb2e],", null, null, "analysis", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "72981ad9-9036-4aa7-b8f4-dc407eda50b4", "system", "system_index_workplace", "system/dashboard/Workplace", null, null, null, null, 0ul, null, "工作台", 0, null, "83ce02c9-b37f-4885-96e3-9b34371edb2e", "[00000000-0000-0000-0000-000000000000],[83ce02c9-b37f-4885-96e3-9b34371edb2e],", null, null, "workplace", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f7d60a3f-2de3-4dca-a1d6-385cee9638bc", "system", "sys_mgr", "PageView", null, null, null, "team", 0ul, null, "组织架构", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/sys", 100, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "system", "sys_user_mgr", "system/user/index", null, null, null, null, 0ul, null, "用户管理", 1, null, "f7d60a3f-2de3-4dca-a1d6-385cee9638bc", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],", null, null, "/mgr_user", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "bff7e542-6463-4f82-a03d-b1022e60d4b6", "system", "sys_user_mgr_page", null, null, null, null, null, 0ul, null, "用户查询", 0, "sysUser:page", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "936440c7-93ef-4d2f-adff-6151f4317355", "system", "sys_user_mgr_edit", null, null, null, null, null, 0ul, null, "用户编辑", 0, "sysUser:edit", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "306fe9bf-3132-4011-9f3f-1a2f4ead7734", "system", "sys_user_mgr_update_pwd", null, null, null, null, null, 0ul, null, "用户修改密码", 0, "sysUser:updatePwd", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "281888e3-d183-4711-ba27-298ef6e64659", "system", "sys_user_mgr_add", null, null, null, null, null, 0ul, null, "用户增加", 0, "sysUser:add", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "7a266494-e17b-480d-8f50-cc234e6fe424", "system", "sys_user_mgr_detail", null, null, null, null, null, 0ul, null, "用户详情", 0, "sysUser:detail", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "0d93f763-20d3-4c95-add3-3d94770b110e", "system", "sys_user_mgr_export", null, null, null, null, null, 0ul, null, "用户导出", 0, "sysUser:export", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "17d047c3-6e95-4f7d-93db-97817d886fa2", "system", "sys_user_mgr_selector", null, null, null, null, null, 0ul, null, "用户选择器", 0, "sysUser:selector", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "5fc44256-2e56-4805-9382-b5504ca5b6cb", "system", "sys_user_mgr_grant_role", null, null, null, null, null, 0ul, null, "用户授权角色", 0, "sysUser:grantRole", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "ceff7899-6779-4708-b9ed-a2d5b488cff2", "system", "sys_user_mgr_own_role", null, null, null, null, null, 0ul, null, "用户拥有角色", 0, "sysUser:ownRole", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "38ba9ccc-eb96-4a60-a5ab-f6ea013f8291", "system", "sys_user_mgr_grant_data", null, null, null, null, null, 0ul, null, "用户授权数据", 0, "sysUser:grantData", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "cf2f8faf-b280-456c-8865-64115e04019f", "system", "sys_user_mgr_own_data", null, null, null, null, null, 0ul, null, "用户拥有数据", 0, "sysUser:ownData", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e4aff800-d34a-416b-bd6e-dcebaa1dd436", "system", "sys_user_mgr_delete", null, null, null, null, null, 0ul, null, "用户删除", 0, "sysUser:delete", "9f1f6051-15e6-474f-ab40-ab98a8713f7b", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[9f1f6051-15e6-474f-ab40-ab98a8713f7b],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "235d9a5f-2469-4f17-a98c-45824513d5ae", "system", "org_areaManage", "system/area/index", null, null, null, null, 0ul, null, "区域管理", 1, null, "f7d60a3f-2de3-4dca-a1d6-385cee9638bc", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],", null, null, "/area", 0, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "0f60d129-9d3b-42b5-9eb2-99bc066be6aa", "system", "sys_pos_mgr", "system/pos/index", null, null, null, null, 0ul, null, "职位管理", 1, null, "f7d60a3f-2de3-4dca-a1d6-385cee9638bc", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],", null, null, "/pos", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "4f44d697-5421-487e-9d31-3161aee4b7cc", "system", "org_area_edit", null, null, null, null, null, 0ul, null, "区域编辑", 0, "sysArea:edit", "235d9a5f-2469-4f17-a98c-45824513d5ae", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[235d9a5f-2469-4f17-a98c-45824513d5ae],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_menu",
|
||
columns: new[] { "Id", "Application", "Code", "Component", "CreatedTime", "CreatedUserId", "CreatedUserName", "Icon", "IsDeleted", "Link", "Name", "OpenType", "Permission", "Pid", "Pids", "Redirect", "Remark", "Router", "Sort", "Status", "Type", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Visible", "VisibleParent", "Weight" },
|
||
values: new object[,]
|
||
{
|
||
{ "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "system", "sys_role_mgr", "system/role/index", null, null, null, null, 0ul, null, "角色管理", 1, null, "4c00d8c1-e871-4231-8b46-a3e3f3fd400c", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],", null, null, "/role", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "4241f4a0-89ab-4a6a-80bb-2830f855d3be", "system", "sys_role_mgr_page", null, null, null, null, null, 0ul, null, "角色查询", 0, "sysRole:page", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "6a48beb1-c828-43d6-af3d-3e18ef163070", "system", "sys_role_mgr_add", null, null, null, null, null, 0ul, null, "角色增加", 0, "sysRole:add", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "1198a602-a23d-4a06-aa9a-76aaf5f065a7", "system", "sys_role_mgr_edit", null, null, null, null, null, 0ul, null, "角色编辑", 0, "sysRole:edit", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e7708eeb-2c87-4c3d-bc71-c395e5d708db", "system", "sys_role_mgr_delete", null, null, null, null, null, 0ul, null, "角色删除", 0, "sysRole:delete", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "d5130f78-5d8d-4c8d-b433-f8e6796f0d12", "system", "org_area_add", null, null, null, null, null, 0ul, null, "区域增加", 0, "sysArea:add", "235d9a5f-2469-4f17-a98c-45824513d5ae", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[235d9a5f-2469-4f17-a98c-45824513d5ae],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "2622348c-dd8f-4ade-a350-de0a8f01e1f6", "system", "sys_role_mgr_drop_down", null, null, null, null, null, 0ul, null, "角色下拉", 0, "sysRole:dropDown", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "00831a3b-d080-411f-afb9-9f415334b192", "system", "sys_menu_mgr_change", null, null, null, null, null, 0ul, null, "菜单切换", 0, "sysMenu:change", "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[babff4e1-dd00-4e6b-909a-3aac76bb52cd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "73d84863-b381-40be-84bc-ec8381fa6c0a", "system", "sys_role_mgr_grant_menu", null, null, null, null, null, 0ul, null, "角色授权菜单", 0, "sysRole:grantMenu", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "19234814-6007-484c-818c-88a664a2a339", "system", "sys_role_mgr_grant_data", null, null, null, null, null, 0ul, null, "角色授权数据", 0, "sysRole:grantData", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "19e5c5f6-b598-4c42-8eed-3d46fb11b465", "system", "sys_role_mgr_own_data", null, null, null, null, null, 0ul, null, "角色拥有数据", 0, "sysRole:ownData", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "ac0ee878-f713-4a77-9c8f-6e1ee1f4484e", "system", "system_tools", "PageView", null, null, null, "euro", 0ul, null, "开发管理", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/tools", 100, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "abf3e33d-3d6a-4bbd-8743-179df5a95d48", "system", "system_tools_config", "system/config/index", null, null, null, null, 0ul, null, "系统配置", 1, null, "ac0ee878-f713-4a77-9c8f-6e1ee1f4484e", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],", null, null, "/config", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "c14c82bd-632d-4cc9-9236-37aa64b15ecf", "system", "system_tools_config_page", null, null, null, null, null, 0ul, null, "配置查询", 0, "sysConfig:page", "abf3e33d-3d6a-4bbd-8743-179df5a95d48", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[abf3e33d-3d6a-4bbd-8743-179df5a95d48],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "78d31d68-9c9b-4e02-94c9-8a74eea4c1fb", "system", "system_tools_config_list", null, null, null, null, null, 0ul, null, "配置列表", 0, "sysConfig:list", "abf3e33d-3d6a-4bbd-8743-179df5a95d48", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[abf3e33d-3d6a-4bbd-8743-179df5a95d48],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "fc91afb5-2b9e-428b-b5ff-b0ef35dd5336", "system", "system_tools_config_add", null, null, null, null, null, 0ul, null, "配置增加", 0, "sysConfig:add", "abf3e33d-3d6a-4bbd-8743-179df5a95d48", "[00000000-0000-0000-0000-000000000000],[ac0ee878-f713-4a77-9c8f-6e1ee1f4484e],[abf3e33d-3d6a-4bbd-8743-179df5a95d48],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "bbc5e792-3d72-4d0d-8ddb-25cf2c4e1374", "system", "sys_role_mgr_own_menu", null, null, null, null, null, 0ul, null, "角色拥有菜单", 0, "sysRole:ownMenu", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "3892ef5d-39b2-4a4d-8047-cb96542fb54f", "system", "sys_menu_mgr_tree", null, null, null, null, null, 0ul, null, "菜单树", 0, "sysMenu:tree", "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[babff4e1-dd00-4e6b-909a-3aac76bb52cd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "63ab477f-88fb-4f4b-9dcd-0cb83ac767f6", "system", "sys_role_mgr_detail", null, null, null, null, null, 0ul, null, "角色详情", 0, "sysRole:detail", "ee63be7b-5d06-4c15-81f3-875e2eb164dd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[ee63be7b-5d06-4c15-81f3-875e2eb164dd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "cd43a8ee-9f98-4355-bf81-ba40f388b23f", "system", "sys_menu_mgr_detail", null, null, null, null, null, 0ul, null, "菜单详情", 0, "sysMenu:detail", "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[babff4e1-dd00-4e6b-909a-3aac76bb52cd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "ec318997-596d-403a-91be-f303b234b02d", "system", "sys_menu_mgr_grant_tree", null, null, null, null, null, 0ul, null, "菜单授权树", 0, "sysMenu:treeForGrant", "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[babff4e1-dd00-4e6b-909a-3aac76bb52cd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e7f28efd-2ac4-45c6-a73b-57ef7c5b8c8b", "system", "org_area_page", null, null, null, null, null, 0ul, null, "区域查询", 0, "sysArea:page", "235d9a5f-2469-4f17-a98c-45824513d5ae", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[235d9a5f-2469-4f17-a98c-45824513d5ae],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "8645a374-6939-4dd8-a827-c6a39771f33d", "system", "org_area_tree", null, null, null, null, null, 0ul, null, "区域树", 0, "sysArea:tree", "235d9a5f-2469-4f17-a98c-45824513d5ae", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[235d9a5f-2469-4f17-a98c-45824513d5ae],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "4c00d8c1-e871-4231-8b46-a3e3f3fd400c", "system", "auth_manager", "PageView", null, null, null, "safety-certificate", 0ul, null, "权限管理", 0, null, "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", null, null, "/auth", 100, 0, 0, null, null, null, 1ul, 0ul, 1 },
|
||
{ "05175bfd-6e5f-4c3b-8daf-0f79df4e9694", "system", "sys_app_mgr", "system/app/index", null, null, null, null, 0ul, null, "应用管理", 1, null, "4c00d8c1-e871-4231-8b46-a3e3f3fd400c", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],", null, null, "/app", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "dbaa7a6d-234f-4cc9-977f-4544b8bb45b8", "system", "sys_app_mgr_page", null, null, null, null, null, 0ul, null, "应用查询", 0, "sysApp:page", "05175bfd-6e5f-4c3b-8daf-0f79df4e9694", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[05175bfd-6e5f-4c3b-8daf-0f79df4e9694],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "ab7b2b41-b0bc-4b9c-9017-f5c6918e393e", "system", "sys_app_mgr_list", null, null, null, null, null, 0ul, null, "应用列表", 0, "sysApp:list", "05175bfd-6e5f-4c3b-8daf-0f79df4e9694", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[05175bfd-6e5f-4c3b-8daf-0f79df4e9694],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f4e1d63b-5d92-46eb-82aa-267335a5a3f3", "system", "sys_app_mgr_add", null, null, null, null, null, 0ul, null, "应用增加", 0, "sysApp:add", "05175bfd-6e5f-4c3b-8daf-0f79df4e9694", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[05175bfd-6e5f-4c3b-8daf-0f79df4e9694],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "142803a5-63de-48be-afa9-3bde8640d580", "system", "org_area_delete", null, null, null, null, null, 0ul, null, "区域删除", 0, "sysArea:delete", "235d9a5f-2469-4f17-a98c-45824513d5ae", "[00000000-0000-0000-0000-000000000000],[f7d60a3f-2de3-4dca-a1d6-385cee9638bc],[235d9a5f-2469-4f17-a98c-45824513d5ae],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e0a6cf90-0a8b-44e4-a32f-5f43ef996b82", "system", "sys_app_mgr_delete", null, null, null, null, null, 0ul, null, "应用删除", 0, "sysApp:delete", "05175bfd-6e5f-4c3b-8daf-0f79df4e9694", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[05175bfd-6e5f-4c3b-8daf-0f79df4e9694],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "a0abe974-5ae9-440b-9d16-2412eab52d70", "system", "sys_app_mgr_detail", null, null, null, null, null, 0ul, null, "应用详情", 0, "sysApp:detail", "05175bfd-6e5f-4c3b-8daf-0f79df4e9694", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[05175bfd-6e5f-4c3b-8daf-0f79df4e9694],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f640e243-b439-4109-8aea-c66205ef6b12", "system", "sys_app_mgr_set_as_default", null, null, null, null, null, 0ul, null, "设为默认应用", 0, "sysApp:setAsDefault", "05175bfd-6e5f-4c3b-8daf-0f79df4e9694", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[05175bfd-6e5f-4c3b-8daf-0f79df4e9694],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "system", "sys_menu_mgr", "system/menu/index", null, null, null, null, 0ul, null, "菜单管理", 1, null, "4c00d8c1-e871-4231-8b46-a3e3f3fd400c", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],", null, null, "/menu", 100, 0, 1, null, null, null, 1ul, 0ul, 1 },
|
||
{ "e9982e73-1833-4674-9403-ee3dee2efdf7", "system", "sys_menu_mgr_list", null, null, null, null, null, 0ul, null, "菜单列表", 0, "sysMenu:list", "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[babff4e1-dd00-4e6b-909a-3aac76bb52cd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "07139c19-6b39-49f5-9e22-c4dc7e9d947b", "system", "sys_menu_mgr_edit", null, null, null, null, null, 0ul, null, "菜单编辑", 0, "sysMenu:edit", "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[babff4e1-dd00-4e6b-909a-3aac76bb52cd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "857fb581-78ff-4884-a6fb-8dfb4951fef9", "system", "sys_menu_mgr_delete", null, null, null, null, null, 0ul, null, "菜单删除", 0, "sysMenu:delete", "babff4e1-dd00-4e6b-909a-3aac76bb52cd", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[babff4e1-dd00-4e6b-909a-3aac76bb52cd],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 },
|
||
{ "f33a3791-1c01-4d30-bcc3-d9fdf5246376", "system", "sys_app_mgr_edit", null, null, null, null, null, 0ul, null, "应用编辑", 0, "sysApp:edit", "05175bfd-6e5f-4c3b-8daf-0f79df4e9694", "[00000000-0000-0000-0000-000000000000],[4c00d8c1-e871-4231-8b46-a3e3f3fd400c],[05175bfd-6e5f-4c3b-8daf-0f79df4e9694],", null, null, null, 100, 0, 2, null, null, null, 1ul, 0ul, 1 }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_org",
|
||
columns: new[] { "Id", "AreaCode", "Code", "Contacts", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Pid", "Pids", "Remark", "Sort", "Status", "Tel", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
|
||
values: new object[,]
|
||
{
|
||
{ "e9f97d63-a585-40ff-bf0c-7406e785f660", null, "hxjt_cd_scb_2b", null, null, null, null, 0ul, "市场部二部", "49dc3f25-873d-4998-9767-46978d79d8e6", "[00000000-0000-0000-0000-000000000000],[12d888de-f55d-4c88-b0a0-7c3510664d97],[127c0a5d-43ac-4370-b313-082361885aca],[49dc3f25-873d-4998-9767-46978d79d8e6],", "华夏集团成都分公司市场部二部", 100, 0, null, null, null, null },
|
||
{ "56b7a823-cc62-492b-a91b-0b053ef2683b", null, "hxjt_cd_cwb", null, null, null, null, 0ul, "财务部", "127c0a5d-43ac-4370-b313-082361885aca", "[00000000-0000-0000-0000-000000000000],[12d888de-f55d-4c88-b0a0-7c3510664d97],[127c0a5d-43ac-4370-b313-082361885aca],", "华夏集团成都分公司财务部", 100, 0, null, null, null, null },
|
||
{ "49dc3f25-873d-4998-9767-46978d79d8e6", null, "hxjt_cd_scb", null, null, null, null, 0ul, "市场部", "127c0a5d-43ac-4370-b313-082361885aca", "[00000000-0000-0000-0000-000000000000],[12d888de-f55d-4c88-b0a0-7c3510664d97],[127c0a5d-43ac-4370-b313-082361885aca],", "华夏集团成都分公司市场部", 100, 0, null, null, null, null },
|
||
{ "07322be0-2015-41f2-859e-132b5e142fca", null, "hxjt_bj_qhb", null, null, null, null, 0ul, "企划部", "8a2271d6-5bda-4544-bdd3-27e53a8b418e", "[00000000-0000-0000-0000-000000000000],[12d888de-f55d-4c88-b0a0-7c3510664d97],[8a2271d6-5bda-4544-bdd3-27e53a8b418e],", "华夏集团北京分公司企划部", 100, 0, null, null, null, null },
|
||
{ "127c0a5d-43ac-4370-b313-082361885aca", null, "hxjt_cd", null, null, null, null, 0ul, "华夏集团成都分公司", "12d888de-f55d-4c88-b0a0-7c3510664d97", "[00000000-0000-0000-0000-000000000000],[12d888de-f55d-4c88-b0a0-7c3510664d97],", "华夏集团成都分公司", 100, 0, null, null, null, null },
|
||
{ "8a2271d6-5bda-4544-bdd3-27e53a8b418e", null, "hxjt_bj", null, null, null, null, 0ul, "华夏集团北京分公司", "12d888de-f55d-4c88-b0a0-7c3510664d97", "[00000000-0000-0000-0000-000000000000],[12d888de-f55d-4c88-b0a0-7c3510664d97],", "华夏集团北京分公司", 100, 0, null, null, null, null },
|
||
{ "12d888de-f55d-4c88-b0a0-7c3510664d97", null, "hxjt", null, null, null, null, 0ul, "华夏集团", "00000000-0000-0000-0000-000000000000", "[00000000-0000-0000-0000-000000000000],", "华夏集团", 100, 0, null, null, null, null },
|
||
{ "f236ab2d-e1b5-4e9d-844f-a59ec32c20e4", null, "hxjt_bj_yfb", null, null, null, null, 0ul, "研发部", "8a2271d6-5bda-4544-bdd3-27e53a8b418e", "[00000000-0000-0000-0000-000000000000],[12d888de-f55d-4c88-b0a0-7c3510664d97],[8a2271d6-5bda-4544-bdd3-27e53a8b418e],", "华夏集团北京分公司研发部", 100, 0, null, null, null, null }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_pos",
|
||
columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Remark", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
|
||
values: new object[,]
|
||
{
|
||
{ "269236c4-d74e-4e54-9d50-f6f61580a197", "zjl", null, null, null, 0ul, "总经理", "总经理", 100, 0, null, null, null },
|
||
{ "46c68a62-f119-4ff7-b621-0bbd77504538", "fzjl", null, null, null, 0ul, "副总经理", "副总经理", 101, 0, null, null, null },
|
||
{ "5bd8c466-2bca-4386-a551-daac78e3cee8", "bmjl", null, null, null, 0ul, "部门经理", "部门经理", 102, 0, null, null, null },
|
||
{ "d89a3afe-e6ba-4018-bdae-3c98bb47ad66", "gzry", null, null, null, 0ul, "工作人员", "工作人员", 103, 0, null, null, null }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_role",
|
||
columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "DataScopeType", "IsDeleted", "Name", "Remark", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
|
||
values: new object[,]
|
||
{
|
||
{ "6dfe9189-ce10-434e-a7a7-5cdc46e85047", "sys_manager_role", null, null, null, 1, 0ul, "系统管理员", "系统管理员", 100, 0, null, null, null },
|
||
{ "cd187ebd-ab3d-4768-9669-85e2219c2910", "common_role", null, null, null, 5, 0ul, "普通用户", "普通用户", 101, 0, null, null, null }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_timer",
|
||
columns: new[] { "Id", "BeginTime", "CreatedTime", "CreatedUserId", "CreatedUserName", "Cron", "EndTime", "Headers", "Interval", "IsDeleted", "JobGroup", "JobName", "Remark", "RequestParameters", "RequestType", "RequestUrl", "RunNumber", "TriggerType", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
|
||
values: new object[] { "971bc338-0c03-46d4-8113-c7738d54ea18", new DateTime(2021, 3, 21, 0, 0, 0, 0, DateTimeKind.Local), null, null, null, null, null, null, 30, 0ul, "默认分组", "百度api", null, null, 2, "https://www.baidu.com", null, 1, null, null, null });
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_user",
|
||
columns: new[] { "Id", "Account", "AdminType", "Avatar", "Birthday", "CreatedTime", "CreatedUserId", "CreatedUserName", "Email", "IsDeleted", "LastLoginIp", "LastLoginTime", "Name", "NickName", "Password", "Phone", "Sex", "Status", "Tel", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" },
|
||
values: new object[,]
|
||
{
|
||
{ "5398fb9a-2209-4ce7-a2c1-b6a983e502b5", "admin", 1, null, new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), null, null, null, null, 0ul, null, new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), "admin", null, "e10adc3949ba59abbe56e057f20f883e", "18020030720", 2, 0, null, null, null, null },
|
||
{ "d0ead3dc-5096-4e15-bc6d-f640be5301ec", "superAdmin", 1, null, new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), null, null, null, null, 0ul, null, new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), "superAdmin", null, "e10adc3949ba59abbe56e057f20f883e", "18020030720", 1, 0, null, null, null, null },
|
||
{ "16a74726-e156-499f-9942-0e0e24ad0c3f", "zuohuaijun", 2, null, new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), null, null, null, null, 0ul, null, new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), "zuohuaijun", null, "e10adc3949ba59abbe56e057f20f883e", "18020030720", 1, 0, null, null, null, null }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_dict_data",
|
||
columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Remark", "Sort", "Status", "TypeId", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Value" },
|
||
values: new object[,]
|
||
{
|
||
{ "6a01e89a-6bbb-4822-b862-8e566b6dde74", "1", null, null, null, 0ul, "市级编号", 1, 0, "2815b28b-e51d-4dfb-b549-2eaa27d8c23d", null, null, null, "市级编号" },
|
||
{ "0e4dc1f1-8654-401b-800a-22b31f62ced1", "4", null, null, null, 0ul, "DELETE", 100, 0, "bc0dc25b-b85e-4dd1-8368-e014fe1bf30b", null, null, null, "DELETE" },
|
||
{ "69a34c0b-85ce-4e53-9ad4-a592057dddd4", "3", null, null, null, 0ul, "PUT", 100, 0, "bc0dc25b-b85e-4dd1-8368-e014fe1bf30b", null, null, null, "PUT" },
|
||
{ "10070836-0c89-4b89-96e3-c65c7e33a86c", "2", null, null, null, 0ul, "POST", 100, 0, "bc0dc25b-b85e-4dd1-8368-e014fe1bf30b", null, null, null, "POST" },
|
||
{ "b2a00b40-23e1-40e1-8995-60ab420eafe1", "1", null, null, null, 0ul, "GET", 100, 0, "bc0dc25b-b85e-4dd1-8368-e014fe1bf30b", null, null, null, "GET" },
|
||
{ "5bc8662d-b795-48f1-a88e-2f4be5279d37", "2", null, null, null, 0ul, "生成到本项目", 100, 0, "430d0538-054a-4b37-a459-1095d0ccf4ae", null, null, null, "生成到本项目" },
|
||
{ "881ebcf2-94a6-4938-81a4-55b81736f3b3", "1", null, null, null, 0ul, "下载压缩包", 100, 0, "430d0538-054a-4b37-a459-1095d0ccf4ae", null, null, null, "下载压缩包" },
|
||
{ "0724636d-e870-46c6-8e1e-67f1ea5f58e5", "false", null, null, null, 0ul, "否", 100, 0, "80aea9e7-ad1b-4f57-b4db-9d15813707bd", null, null, null, "否" },
|
||
{ "1f432e9d-f031-4787-a527-f37bb20ebe3a", "true", null, null, null, 0ul, "是", 100, 0, "80aea9e7-ad1b-4f57-b4db-9d15813707bd", null, null, null, "是" },
|
||
{ "6385916f-6ead-470e-889b-cfb9d2da6256", "3", null, null, null, 0ul, "删除", 100, 0, "b30937e6-03cd-4d98-a413-10b06d605e5a", null, null, null, "删除" },
|
||
{ "d2f73bb4-05a1-4aa5-9273-e9f3c393996d", "2", null, null, null, 0ul, "撤回", 100, 0, "b30937e6-03cd-4d98-a413-10b06d605e5a", null, null, null, "撤回" },
|
||
{ "f5b49fa9-31a1-44c2-9df0-b28bf5daeee0", "1", null, null, null, 0ul, "发布", 100, 0, "b30937e6-03cd-4d98-a413-10b06d605e5a", null, null, null, "发布" },
|
||
{ "40d336cd-918a-4e90-8836-cba7c1bf6cdf", "0", null, null, null, 0ul, "草稿", 100, 0, "b30937e6-03cd-4d98-a413-10b06d605e5a", null, null, null, "草稿" },
|
||
{ "2616e6c2-a504-4fc6-993e-72701b48e79a", "2", null, null, null, 0ul, "公告", 100, 0, "d5b311fd-4b60-4b51-9156-b0e6d6cfa4d1", null, null, null, "公告" },
|
||
{ "99b965d3-1f2b-4f5b-a62a-6763b8d64a64", "1", null, null, null, 0ul, "通知", 100, 0, "d5b311fd-4b60-4b51-9156-b0e6d6cfa4d1", null, null, null, "通知" },
|
||
{ "6e3591ec-2902-4bf3-b5a2-7ebc94ebc08f", "2", null, null, null, 0ul, "停止", 100, 0, "0f1b8660-d932-4a53-a681-a38bebae91e0", null, null, null, "停止" },
|
||
{ "76e885e8-1b40-45b6-bb0f-5519c6839df2", "1", null, null, null, 0ul, "运行", 100, 0, "0f1b8660-d932-4a53-a681-a38bebae91e0", null, null, null, "运行" },
|
||
{ "cdc4a9ee-7436-4807-87cd-4350a72745b0", "4", null, null, null, 0ul, "本地", 100, 0, "b924e0c1-3f23-4e37-9f27-90e945381304", null, null, null, "本地" },
|
||
{ "cc64be62-3213-4442-a98a-c508bc35104b", "3", null, null, null, 0ul, "minio", 100, 0, "b924e0c1-3f23-4e37-9f27-90e945381304", null, null, null, "minio" },
|
||
{ "91c522b5-4f6f-48a5-ba79-962d56821bdc", "2", null, null, null, 0ul, "腾讯云", 100, 0, "b924e0c1-3f23-4e37-9f27-90e945381304", null, null, null, "腾讯云" },
|
||
{ "f86e19a0-8ba8-4588-91f6-be2af525f490", "1", null, null, null, 0ul, "阿里云", 100, 0, "b924e0c1-3f23-4e37-9f27-90e945381304", null, null, null, "阿里云" },
|
||
{ "beb773cd-a22a-44e2-ac4b-5ab6f21aa3c4", "12", null, null, null, 0ul, "清空", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "清空" },
|
||
{ "443f965e-96b4-4fd2-93e9-07fe00a47205", "input", null, null, null, 0ul, "输入框", 100, 0, "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", null, null, null, "输入框" },
|
||
{ "bf7be9a2-53fb-4250-87fe-49d7f741d159", "datepicker", null, null, null, 0ul, "时间选择", 100, 0, "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", null, null, null, "时间选择" },
|
||
{ "cea10919-47e2-43ab-a19b-9d41fe648310", "select", null, null, null, 0ul, "下拉框", 100, 0, "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", null, null, null, "下拉框" },
|
||
{ "7d534f44-cf66-472e-b0d3-20a4cc2ad432", "radio", null, null, null, 0ul, "单选框", 100, 0, "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", null, null, null, "单选框" },
|
||
{ "c597306f-5fd0-4f75-9a46-12de340cd199", "DateTimeOffset", null, null, null, 0ul, "DateTimeOffset", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "DateTimeOffset" },
|
||
{ "134d4173-8d93-4c19-bf6b-a640d35da097", "Guid", null, null, null, 0ul, "Guid", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "Guid" },
|
||
{ "4b68cb83-f173-4864-bd10-a7a7d5248102", "decimal", null, null, null, 0ul, "decimal", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "decimal" },
|
||
{ "a30c682e-744a-468d-a74f-827928c96c01", "float", null, null, null, 0ul, "float", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "float" },
|
||
{ "259698cf-b25d-427a-8d22-33b9c1899eea", "DateTime", null, null, null, 0ul, "DateTime", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "DateTime" },
|
||
{ "681c02ea-7570-4a97-85a7-957a77314df6", "double", null, null, null, 0ul, "double", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "double" },
|
||
{ "496eef62-3849-4263-b274-a3e6090942e3", "bool", null, null, null, 0ul, "bool", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "bool" },
|
||
{ "25be90ea-b439-4e9d-993c-48a5ce3b9358", "string", null, null, null, 0ul, "string", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "string" },
|
||
{ "cffdd4b5-d4e0-4196-81b9-02045de8b189", "long", null, null, null, 0ul, "long", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "long" },
|
||
{ "a5cdf75e-6361-490d-a043-f5929ccf65a9", "int", null, null, null, 0ul, "int", 100, 0, "28f653d4-e573-4f54-8e5c-4e308780145a", null, null, null, "int" },
|
||
{ "023244cd-eb32-4a19-bb3c-97301be1e769", "11", null, null, null, 0ul, "强退", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "强退" },
|
||
{ "759ea7de-a18f-4ed7-9032-bbd1a4dadc9e", "isNotNull", null, null, null, 0ul, "不为空", 8, 0, "41bc31f6-cef5-400d-b03a-bf51d27b2432", null, null, null, "不为空" },
|
||
{ "4825f15d-077b-4c16-8ee7-0205d653e14d", ">=", null, null, null, 0ul, "大于等于", 6, 0, "41bc31f6-cef5-400d-b03a-bf51d27b2432", null, null, null, "大于等于" },
|
||
{ "218b5bac-343e-4594-a9da-30e391c7735c", "!=", null, null, null, 0ul, "不等于", 5, 0, "41bc31f6-cef5-400d-b03a-bf51d27b2432", null, null, null, "不等于" },
|
||
{ "a6812d98-7785-4db2-b2f8-d476a459c5ed", "<", null, null, null, 0ul, "小于", 4, 0, "41bc31f6-cef5-400d-b03a-bf51d27b2432", null, null, null, "小于" },
|
||
{ "efc18513-c17b-4fc1-8e0e-2e79fb9b0107", ">", null, null, null, 0ul, "大于", 3, 0, "41bc31f6-cef5-400d-b03a-bf51d27b2432", null, null, null, "大于" },
|
||
{ "2c8e1240-f3ef-4df1-bd68-3047109ad5b4", "like", null, null, null, 0ul, "模糊", 2, 0, "41bc31f6-cef5-400d-b03a-bf51d27b2432", null, null, null, "模糊" },
|
||
{ "ad759239-e34e-4fdf-a0d0-6b39eb41f880", "==", null, null, null, 0ul, "等于", 1, 0, "41bc31f6-cef5-400d-b03a-bf51d27b2432", null, null, null, "等于" },
|
||
{ "d00b3efa-2f9d-464c-8134-aa7013ef52bb", "textarea", null, null, null, 0ul, "文本域", 100, 0, "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", null, null, null, "文本域" },
|
||
{ "a8ac5009-93d3-4405-a6b9-81ed3e2811f2", "inputnumber", null, null, null, 0ul, "数字输入框", 100, 0, "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", null, null, null, "数字输入框" },
|
||
{ "46967f62-bac9-47fd-9278-b29c047b0c38", "checkbox", null, null, null, 0ul, "多选框", 100, 0, "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", null, null, null, "多选框" },
|
||
{ "d63b06d4-be11-4ab7-9905-87f6f2ca056f", "switch", null, null, null, 0ul, "开关", 100, 0, "5bdf9b7a-a483-4b61-8e22-e2b25b255b91", null, null, null, "开关" },
|
||
{ "7c9e8270-db5a-45b7-acd7-f95c8ee31547", "<=", null, null, null, 0ul, "小于等于", 7, 0, "41bc31f6-cef5-400d-b03a-bf51d27b2432", null, null, null, "小于等于" },
|
||
{ "e02d9274-aa68-4e2c-9211-b226f1e6423e", "10", null, null, null, 0ul, "授权", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "授权" },
|
||
{ "b6f55ff4-6b6a-452a-b372-32ac2f1f2b30", "13", null, null, null, 0ul, "修改状态", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "修改状态" },
|
||
{ "2b9cf0b8-74ba-4b36-8504-275a2387729a", "8", null, null, null, 0ul, "导入", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "导入" },
|
||
{ "a4cba529-769a-4309-add6-b15b25ebf05a", "2", null, null, null, 0ul, "按钮", 100, 0, "e973d383-c28e-42e0-9e23-5f2bd592fef5", null, null, null, "按钮" },
|
||
{ "db13458a-22b4-4f5e-b6f9-c3c9e1400909", "9", null, null, null, 0ul, "导出", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "导出" },
|
||
{ "a8cd8263-4397-4d68-91db-d92330c67632", "0", null, null, null, 0ul, "目录", 100, 0, "e973d383-c28e-42e0-9e23-5f2bd592fef5", null, null, null, "目录" },
|
||
{ "934099f4-c1a6-4f63-8cff-a42356369dd9", "2", null, null, null, 0ul, "登出", 100, 0, "2cecf329-cf95-44eb-a8d7-3fb77b13e093", null, null, null, "登出" },
|
||
{ "8204daac-b2ea-41f6-ab52-ef299a05fd94", "1", null, null, null, 0ul, "登录", 100, 0, "2cecf329-cf95-44eb-a8d7-3fb77b13e093", null, null, null, "登录" },
|
||
{ "7d3115a8-938a-4d09-a2c9-21ad65b8b65a", "Y", null, null, null, 0ul, "是", 100, 0, "f2f0e8bf-04da-4a2f-9fb8-1d6549227302", null, null, null, "是" },
|
||
{ "1159fc34-ef51-4e0f-b55b-0220d2445a1e", "N", null, null, null, 0ul, "否", 100, 0, "f2f0e8bf-04da-4a2f-9fb8-1d6549227302", null, null, null, "否" },
|
||
{ "fdf38fa8-3d1e-4a43-84bc-785c0a394160", "OAUTH", null, null, null, 0ul, "Oauth配置", 100, 0, "64afb5e7-9f00-4c4f-9ba6-6b41221bd862", null, null, null, "Oauth配置" },
|
||
{ "81d87a9c-a4ee-46dc-be69-71dcccb14d9d", "FILE_PATH", null, null, null, 0ul, "文件上传路径", 100, 0, "64afb5e7-9f00-4c4f-9ba6-6b41221bd862", null, null, null, "文件上传路径" },
|
||
{ "9cba05e7-495a-43fb-b86b-fa459da5b04d", "EMAIL", null, null, null, 0ul, "邮件配置", 100, 0, "64afb5e7-9f00-4c4f-9ba6-6b41221bd862", null, null, null, "邮件配置" },
|
||
{ "7ec98dee-8dc9-47fe-9276-f3312ed5dd24", "0", null, null, null, 0ul, "未发送", 100, 0, "058db370-3718-42c3-8ba7-095341b1fe13", null, null, null, "未发送" },
|
||
{ "5e61f455-1975-438b-bd17-85a1f89abe84", "TENCENT_SMS", null, null, null, 0ul, "腾讯云短信", 100, 0, "64afb5e7-9f00-4c4f-9ba6-6b41221bd862", null, null, null, "腾讯云短信" },
|
||
{ "b6ad194b-ccfb-4ee7-b402-7b78e8bb8680", "DEFAULT", null, null, null, 0ul, "默认常量，都以XIAONUO_开头的", 100, 0, "64afb5e7-9f00-4c4f-9ba6-6b41221bd862", null, null, null, "默认常量" },
|
||
{ "150e04a6-3bf5-4604-98d5-14fbd1608bc5", "3", null, null, null, 0ul, "未知性别", 100, 0, "301ed120-dfc5-4d7c-af59-b56a519581c9", null, null, null, "未知" },
|
||
{ "46ba4c21-cbde-4561-8e57-19ed0f752c17", "2", null, null, null, 0ul, "女性", 100, 0, "301ed120-dfc5-4d7c-af59-b56a519581c9", null, null, null, "女" },
|
||
{ "9b44b297-f6f0-4c31-b680-83baabf4c5b7", "1", null, null, null, 0ul, "男性", 100, 0, "301ed120-dfc5-4d7c-af59-b56a519581c9", null, null, null, "男" },
|
||
{ "297030a2-88d9-4646-b7c1-a17c9a8c0b98", "2", null, null, null, 0ul, "删除", 100, 0, "b0cfa91c-1189-4f39-bc5a-f035885d0604", null, null, null, "删除" },
|
||
{ "22492650-a92b-43f0-9954-3d3891ec6e45", "1", null, null, null, 0ul, "停用", 100, 0, "b0cfa91c-1189-4f39-bc5a-f035885d0604", null, null, null, "停用" },
|
||
{ "e3c9ebce-bdae-45a3-92b1-fc2e35a23242", "0", null, null, null, 0ul, "正常", 100, 0, "b0cfa91c-1189-4f39-bc5a-f035885d0604", null, null, null, "正常" },
|
||
{ "514dbb46-ae79-4c07-96fa-496983765609", "4", null, null, null, 0ul, "社区/村委会编号", 4, 0, "2815b28b-e51d-4dfb-b549-2eaa27d8c23d", null, null, null, "社区/村委会编号" },
|
||
{ "dad01f31-bb7f-4696-9e53-ad6d58b366a7", "3", null, null, null, 0ul, "乡镇街道编号", 3, 0, "2815b28b-e51d-4dfb-b549-2eaa27d8c23d", null, null, null, "乡镇街道编号" },
|
||
{ "fc843478-1e98-47e8-aaf3-12442fd4cbfc", "2", null, null, null, 0ul, "区县编号", 2, 0, "2815b28b-e51d-4dfb-b549-2eaa27d8c23d", null, null, null, "区县编号" },
|
||
{ "e2271e0a-17a3-41f3-81fa-dbe895ce0466", "ALIYUN_SMS", null, null, null, 0ul, "阿里云短信配置", 100, 0, "64afb5e7-9f00-4c4f-9ba6-6b41221bd862", null, null, null, "阿里云短信" },
|
||
{ "83cf4407-dbe1-4da2-883d-a3e16a780f37", "1", null, null, null, 0ul, "发送成功", 100, 0, "058db370-3718-42c3-8ba7-095341b1fe13", null, null, null, "发送成功" },
|
||
{ "bb082602-57ea-4941-b68b-64460e7f63b6", "1", null, null, null, 0ul, "菜单", 100, 0, "e973d383-c28e-42e0-9e23-5f2bd592fef5", null, null, null, "菜单" },
|
||
{ "13e71f10-539b-4016-9acf-e3541c0f04db", "3", null, null, null, 0ul, "失效", 100, 0, "058db370-3718-42c3-8ba7-095341b1fe13", null, null, null, "失效" },
|
||
{ "bf8f818f-060b-4815-8fe9-11bb356cb2e6", "7", null, null, null, 0ul, "树", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "树" },
|
||
{ "fe6e46ee-208b-446f-8aaa-05bd5eaa459b", "6", null, null, null, 0ul, "详情", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "详情" },
|
||
{ "d1334517-ddfa-47f3-b053-88ea999babc7", "5", null, null, null, 0ul, "查询", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "查询" },
|
||
{ "9edba767-7008-4623-8dbf-75417f1a0c82", "4", null, null, null, 0ul, "更新", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "更新" },
|
||
{ "4656bf7b-df6a-4c71-b963-18d8af3f93a7", "3", null, null, null, 0ul, "编辑", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "编辑" },
|
||
{ "387d403c-6af3-4bda-af05-d60472823480", "2", null, null, null, 0ul, "删除", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "删除" },
|
||
{ "e1e71562-015e-466b-b98b-29f4b8966bce", "2", null, null, null, 0ul, "发送失败", 100, 0, "058db370-3718-42c3-8ba7-095341b1fe13", null, null, null, "发送失败" },
|
||
{ "35aac71b-9939-4b2e-8533-d087618c1dca", "0", null, null, null, 0ul, "其它", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "其它" },
|
||
{ "2bce5da0-b386-4412-935d-d081b7cf4391", "3", null, null, null, 0ul, "其他", 100, 0, "688f9a69-ec95-46f4-87bb-e19e3cc5c7fc", null, null, null, "其他" },
|
||
{ "b1e821b3-4e7b-4e60-a67f-a40d327ab6d6", "2", null, null, null, 0ul, "pc", 100, 0, "688f9a69-ec95-46f4-87bb-e19e3cc5c7fc", null, null, null, "pc" },
|
||
{ "a819d549-6107-43a2-99d2-377cf0a5681a", "1", null, null, null, 0ul, "app", 100, 0, "688f9a69-ec95-46f4-87bb-e19e3cc5c7fc", null, null, null, "app" },
|
||
{ "e7585292-d6c6-475f-bf87-8ad473ce6be4", "1", null, null, null, 0ul, "增加", 100, 0, "8461bd1d-311b-487e-b579-d6049c6fb191", null, null, null, "增加" },
|
||
{ "70afe4c1-3495-483a-bdd0-3d4ea45136b3", "4", null, null, null, 0ul, "仅本人数据", 100, 0, "a2068ed1-62a6-463c-b720-06111d994079", null, null, null, "仅本人数据" },
|
||
{ "f965b257-b2ff-4a18-9084-6e805547e9e6", "0", null, null, null, 0ul, "无", 100, 0, "ff6202cb-25ce-4ab9-9c39-910c418b1d2d", null, null, null, "无" },
|
||
{ "6f395e69-8add-40ae-a378-0881d64a4413", "5", null, null, null, 0ul, "自定义数据", 100, 0, "a2068ed1-62a6-463c-b720-06111d994079", null, null, null, "自定义数据" },
|
||
{ "be3197fd-2fba-4e79-b252-793f05e51a21", "2", null, null, null, 0ul, "内链", 100, 0, "ff6202cb-25ce-4ab9-9c39-910c418b1d2d", null, null, null, "内链" },
|
||
{ "2a10adc6-b286-4fad-9719-7e7321c7a93e", "3", null, null, null, 0ul, "外链", 100, 0, "ff6202cb-25ce-4ab9-9c39-910c418b1d2d", null, null, null, "外链" },
|
||
{ "75c40b12-07d1-4828-9b6c-132f4bca194c", "1", null, null, null, 0ul, "组件", 100, 0, "ff6202cb-25ce-4ab9-9c39-910c418b1d2d", null, null, null, "组件" },
|
||
{ "f4771570-e4a5-416f-b82f-1e3082c35ee8", "2", null, null, null, 0ul, "业务权重", 100, 0, "b3235678-f7fe-442b-8fba-e792a89b78f2", null, null, null, "业务权重" },
|
||
{ "a2d6bdfe-ee61-4425-94c9-7ece3de080fa", "1", null, null, null, 0ul, "全部数据", 100, 0, "a2068ed1-62a6-463c-b720-06111d994079", null, null, null, "全部数据" },
|
||
{ "d0b25877-165e-41b8-9034-7a8fea7e5776", "2", null, null, null, 0ul, "本部门及以下数据", 100, 0, "a2068ed1-62a6-463c-b720-06111d994079", null, null, null, "本部门及以下数据" },
|
||
{ "375362c8-d694-40d9-8c55-07669e472460", "3", null, null, null, 0ul, "本部门数据", 100, 0, "a2068ed1-62a6-463c-b720-06111d994079", null, null, null, "本部门数据" },
|
||
{ "d3984ed0-29d5-416e-87c6-75364010677b", "1", null, null, null, 0ul, "系统权重", 100, 0, "b3235678-f7fe-442b-8fba-e792a89b78f2", null, null, null, "系统权重" }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_emp_ext_org_pos",
|
||
columns: new[] { "SysEmpId", "SysOrgId", "SysPosId" },
|
||
values: new object[,]
|
||
{
|
||
{ "d0ead3dc-5096-4e15-bc6d-f640be5301ec", "12d888de-f55d-4c88-b0a0-7c3510664d97", "269236c4-d74e-4e54-9d50-f6f61580a197" },
|
||
{ "16a74726-e156-499f-9942-0e0e24ad0c3f", "f236ab2d-e1b5-4e9d-844f-a59ec32c20e4", "269236c4-d74e-4e54-9d50-f6f61580a197" },
|
||
{ "d0ead3dc-5096-4e15-bc6d-f640be5301ec", "8a2271d6-5bda-4544-bdd3-27e53a8b418e", "46c68a62-f119-4ff7-b621-0bbd77504538" },
|
||
{ "d0ead3dc-5096-4e15-bc6d-f640be5301ec", "127c0a5d-43ac-4370-b313-082361885aca", "5bd8c466-2bca-4386-a551-daac78e3cee8" },
|
||
{ "d0ead3dc-5096-4e15-bc6d-f640be5301ec", "f236ab2d-e1b5-4e9d-844f-a59ec32c20e4", "d89a3afe-e6ba-4018-bdae-3c98bb47ad66" }
|
||
});
|
||
|
||
migrationBuilder.InsertData(
|
||
table: "sys_emp_pos",
|
||
columns: new[] { "SysEmpId", "SysPosId" },
|
||
values: new object[,]
|
||
{
|
||
{ "5398fb9a-2209-4ce7-a2c1-b6a983e502b5", "5bd8c466-2bca-4386-a551-daac78e3cee8" },
|
||
{ "d0ead3dc-5096-4e15-bc6d-f640be5301ec", "269236c4-d74e-4e54-9d50-f6f61580a197" },
|
||
{ "16a74726-e156-499f-9942-0e0e24ad0c3f", "269236c4-d74e-4e54-9d50-f6f61580a197" },
|
||
{ "d0ead3dc-5096-4e15-bc6d-f640be5301ec", "46c68a62-f119-4ff7-b621-0bbd77504538" }
|
||
});
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_dict_data_TypeId",
|
||
table: "sys_dict_data",
|
||
column: "TypeId");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_emp_ext_org_pos_SysOrgId",
|
||
table: "sys_emp_ext_org_pos",
|
||
column: "SysOrgId");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_emp_ext_org_pos_SysPosId",
|
||
table: "sys_emp_ext_org_pos",
|
||
column: "SysPosId");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_emp_pos_SysPosId",
|
||
table: "sys_emp_pos",
|
||
column: "SysPosId");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_org_AreaCode",
|
||
table: "sys_org",
|
||
column: "AreaCode");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_role_area_AreaCode",
|
||
table: "sys_role_area",
|
||
column: "AreaCode");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_role_data_scope_SysOrgId",
|
||
table: "sys_role_data_scope",
|
||
column: "SysOrgId");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_role_menu_SysMenuId",
|
||
table: "sys_role_menu",
|
||
column: "SysMenuId");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_user_area_AreaCode",
|
||
table: "sys_user_area",
|
||
column: "AreaCode");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_user_data_scope_SysOrgId",
|
||
table: "sys_user_data_scope",
|
||
column: "SysOrgId");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_sys_user_role_SysRoleId",
|
||
table: "sys_user_role",
|
||
column: "SysRoleId");
|
||
}
|
||
|
||
protected override void Down(MigrationBuilder migrationBuilder)
|
||
{
|
||
migrationBuilder.DropTable(
|
||
name: "bs_house_projectinfo");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_app");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_code_gen");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_code_gen_config");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_config");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_dict_data");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_emp_ext_org_pos");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_emp_pos");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_file");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_log_audit");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_log_op");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_log_vis");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_notice");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_notice_user");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_oauth_user");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_role_area");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_role_data_scope");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_role_menu");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_tenant");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_timer");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_user_area");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_user_data_scope");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_user_role");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_dict_type");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_emp");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_pos");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_menu");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_org");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_role");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_user");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "sys_area_code");
|
||
}
|
||
}
|
||
}
|