using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace iWare.Wms.Database.Migrations.Migrations { public partial class v101 : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "sys_app", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), Name = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "名称"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"), Active = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否默认激活"), Status = table.Column(type: "int", nullable: false, comment: "状态"), Sort = table.Column(type: "int", nullable: false, comment: "排序"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_app", x => x.Id); }, comment: "系统应用表"); migrationBuilder.CreateTable( name: "sys_code_gen", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), AuthorName = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "作者姓名"), TablePrefix = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否移除表前缀"), GenerateType = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "生成方式"), DatabaseName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "数据库名"), TableName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "数据库表名"), NameSpace = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "命名空间"), BusName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "业务名"), MenuApplication = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "菜单应用分类"), MenuPid = table.Column(type: "bigint", nullable: false, comment: "菜单编码"), LowCodeId = table.Column(type: "bigint", nullable: true), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(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(type: "bigint", nullable: false, comment: "Id主键"), CodeGenId = table.Column(type: "bigint", nullable: false, comment: "代码生成主表ID"), ColumnName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: false, comment: "数据库字段名"), ColumnComment = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "字段描述"), NetType = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: ".NET数据类型"), DtoNetType = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: ".NET数据类型(接口传入)"), EffectType = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "作用类型"), FkEntityName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "外键实体名称"), FkColumnName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "外键显示字段"), FkColumnNetType = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "外键显示字段.NET类型"), DictTypeCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "字典Code"), WhetherRetract = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "列表是否缩进"), WhetherRequired = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否必填"), QueryWhether = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否是查询条件"), QueryType = table.Column(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "查询方式"), WhetherTable = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "列表显示"), WhetherOrderBy = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "列表是否排序"), WhetherAddUpdate = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "增改"), ColumnKey = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "主键"), DataType = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: true, comment: "数据库中类型"), WhetherCommon = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否通用字段"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_code_gen_config", x => x.Id); }, comment: "代码生成字段配置表"); migrationBuilder.CreateTable( name: "sys_code_modular", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), AuthorName = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "作者姓名"), DatabaseName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "数据库名"), NameSpace = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "命名空间"), BusName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "业务名"), MenuApplication = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "菜单应用分类"), MenuPid = table.Column(type: "bigint", nullable: false, comment: "菜单编码"), FormDesignJson = table.Column(type: "nvarchar(max)", nullable: true, comment: "动态表单"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_code_modular", x => x.Id); }, comment: "动态生成模块管理表"); migrationBuilder.CreateTable( name: "sys_config", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), Name = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "名称"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"), Value = table.Column(type: "nvarchar(max)", nullable: true, comment: "属性值"), SysFlag = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否是系统参数"), Remark = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"), Status = table.Column(type: "int", nullable: false, comment: "状态"), GroupCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "常量所属分类的编码"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(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(type: "bigint", nullable: false, comment: "Id主键"), Name = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "名称"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"), Sort = table.Column(type: "int", nullable: false, comment: "排序"), Remark = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"), Status = table.Column(type: "int", nullable: false, comment: "状态"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(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(type: "bigint", nullable: false, comment: "用户Id"), JobNum = table.Column(type: "nvarchar(30)", maxLength: 30, nullable: true, comment: "工号"), OrgId = table.Column(type: "bigint", nullable: false, comment: "机构Id"), OrgName = table.Column(type: "nvarchar(50)", maxLength: 50, 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(type: "bigint", nullable: false, comment: "Id主键"), FileLocation = table.Column(type: "int", nullable: false, comment: "文件存储位置"), FileBucket = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "文件仓库"), FileOriginName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "文件名称"), FileSuffix = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "文件后缀"), FileSizeKb = table.Column(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "文件大小kb"), FileSizeInfo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "文件大小信息"), FileObjectName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "存储到bucket的名称"), FilePath = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "存储路径"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_file", x => x.Id); }, comment: "文件信息表"); migrationBuilder.CreateTable( name: "sys_forms", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), Title = table.Column(type: "nvarchar(max)", nullable: false, comment: "标题"), FormJson = table.Column(type: "nvarchar(max)", nullable: false, comment: "form表单Json"), Publish = table.Column(type: "bit", nullable: false, comment: "是否发布"), TypeId = table.Column(type: "bigint", nullable: false, comment: "表单类型ID"), Version = table.Column(type: "int", nullable: false, comment: "版本"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_forms", x => x.Id); }, comment: "表单表"); migrationBuilder.CreateTable( name: "sys_log_audit", columns: table => new { Id = table.Column(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), TableName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "表名"), ColumnName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "列名"), NewValue = table.Column(type: "nvarchar(max)", nullable: true, comment: "新值"), OldValue = table.Column(type: "nvarchar(max)", nullable: true, comment: "旧值"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "操作时间"), UserId = table.Column(type: "bigint", nullable: false, comment: "操作人Id"), UserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "操作人名称"), Operate = table.Column(type: "int", nullable: false, comment: "操作方式") }, constraints: table => { table.PrimaryKey("PK_sys_log_audit", x => x.Id); }, comment: "审计日志表"); migrationBuilder.CreateTable( name: "sys_log_ex", columns: table => new { Id = table.Column(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Account = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "操作人"), Name = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "名称"), ClassName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "类名"), MethodName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "方法名"), ExceptionName = table.Column(type: "nvarchar(max)", nullable: true, comment: "异常名称"), ExceptionMsg = table.Column(type: "nvarchar(max)", nullable: true, comment: "异常信息"), ExceptionSource = table.Column(type: "nvarchar(max)", nullable: true, comment: "异常源"), StackTrace = table.Column(type: "nvarchar(max)", nullable: true, comment: "堆栈信息"), ParamsObj = table.Column(type: "nvarchar(max)", nullable: true, comment: "参数对象"), ExceptionTime = table.Column(type: "datetimeoffset", nullable: true, comment: "异常时间") }, constraints: table => { table.PrimaryKey("PK_sys_log_ex", x => x.Id); }, comment: "异常日志表"); migrationBuilder.CreateTable( name: "sys_log_op", columns: table => new { Id = table.Column(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Name = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "名称"), Success = table.Column(type: "int", nullable: false, comment: "是否执行成功"), Message = table.Column(type: "nvarchar(max)", nullable: true, comment: "具体消息"), Ip = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "IP"), Location = table.Column(type: "nvarchar(1024)", maxLength: 1024, nullable: true, comment: "地址"), Browser = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "浏览器"), Os = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "操作系统"), Url = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "请求地址"), ClassName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "类名称"), MethodName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "方法名称"), ReqMethod = table.Column(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "请求方式"), Param = table.Column(type: "nvarchar(max)", nullable: true, comment: "请求参数"), Result = table.Column(type: "nvarchar(max)", nullable: true, comment: "返回结果"), ElapsedTime = table.Column(type: "bigint", nullable: false, comment: "耗时"), OpTime = table.Column(type: "datetimeoffset", nullable: true, comment: "操作时间"), Account = table.Column(type: "nvarchar(50)", maxLength: 50, 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(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Name = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "名称"), Success = table.Column(type: "int", nullable: false, comment: "是否执行成功"), Message = table.Column(type: "nvarchar(max)", nullable: true, comment: "具体消息"), Ip = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "IP"), Location = table.Column(type: "nvarchar(1024)", maxLength: 1024, nullable: true, comment: "地址"), Browser = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "浏览器"), Os = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "操作系统"), VisType = table.Column(type: "int", nullable: false, comment: "访问类型"), VisTime = table.Column(type: "datetimeoffset", nullable: true, comment: "访问时间"), Account = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "访问人") }, constraints: table => { table.PrimaryKey("PK_sys_log_vis", x => x.Id); }, comment: "访问日志表"); migrationBuilder.CreateTable( name: "sys_low_code_module", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), AuthorName = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "作者姓名"), GenerateType = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "生成方式"), DatabaseName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "数据库名"), NameSpace = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "命名空间"), BusName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "业务名"), MenuApplication = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "菜单应用分类"), MenuPid = table.Column(type: "bigint", nullable: false, comment: "菜单编码"), FormDesignType = table.Column(type: "int", nullable: false, comment: "动态表单类型"), FormDesign = table.Column(type: "text", nullable: true, comment: "动态表单"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_low_code_module", x => x.Id); }, comment: "低代码模块管理"); migrationBuilder.CreateTable( name: "sys_menu", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), Pid = table.Column(type: "bigint", nullable: false, comment: "父Id"), Pids = table.Column(type: "nvarchar(max)", nullable: true, comment: "父Ids"), Name = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "名称"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"), Type = table.Column(type: "int", nullable: false, comment: "菜单类型"), Icon = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "图标"), Router = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "路由地址"), Component = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "组件地址"), Permission = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "权限标识"), Application = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "应用分类"), OpenType = table.Column(type: "int", nullable: false, comment: "打开方式"), Visible = table.Column(type: "nvarchar(5)", maxLength: 5, nullable: true, comment: "是否可见"), Link = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "内链地址"), Redirect = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "重定向地址"), Weight = table.Column(type: "int", nullable: false, comment: "权重"), Sort = table.Column(type: "int", nullable: false, comment: "排序"), Remark = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"), Status = table.Column(type: "int", nullable: false), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(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(type: "bigint", nullable: false, comment: "Id主键"), Title = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "标题"), Content = table.Column(type: "nvarchar(max)", nullable: false, comment: "内容"), Type = table.Column(type: "int", nullable: false, comment: "类型"), PublicUserId = table.Column(type: "bigint", nullable: false, comment: "发布人Id"), PublicUserName = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "发布人姓名"), PublicOrgId = table.Column(type: "bigint", nullable: false, comment: "发布机构Id"), PublicOrgName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "发布机构名称"), PublicTime = table.Column(type: "datetimeoffset", nullable: true, comment: "发布时间"), CancelTime = table.Column(type: "datetimeoffset", nullable: true, comment: "撤回时间"), Status = table.Column(type: "int", nullable: false, comment: "状态"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(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(type: "bigint", nullable: false, comment: "通知公告Id"), UserId = table.Column(type: "bigint", nullable: false, comment: "用户Id"), ReadTime = table.Column(type: "datetimeoffset", nullable: true, comment: "阅读时间"), ReadStatus = table.Column(type: "int", nullable: false, comment: "状态") }, constraints: table => { table.PrimaryKey("PK_sys_notice_user", x => new { x.NoticeId, x.UserId }); }, comment: "通知公告用户表"); migrationBuilder.CreateTable( name: "sys_org", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), Pid = table.Column(type: "bigint", nullable: false, comment: "父Id"), Pids = table.Column(type: "nvarchar(max)", nullable: true, comment: "父Ids"), Name = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: false, comment: "名称"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"), Contacts = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "联系人"), Tel = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "电话"), Sort = table.Column(type: "int", nullable: false, comment: "排序"), Remark = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"), Status = table.Column(type: "int", nullable: false, comment: "状态"), OrgType = table.Column(type: "nvarchar(max)", nullable: true), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_org", x => x.Id); }, comment: "组织机构表"); migrationBuilder.CreateTable( name: "sys_pos", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), Name = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "名称"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"), Sort = table.Column(type: "int", nullable: false, comment: "排序"), Remark = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"), Status = table.Column(type: "int", nullable: false, comment: "状态"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(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(type: "bigint", nullable: false, comment: "Id主键"), Name = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "名称"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"), Sort = table.Column(type: "int", nullable: false, comment: "排序"), DataScopeType = table.Column(type: "int", nullable: false, comment: "数据范围类型"), Remark = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"), Status = table.Column(type: "int", nullable: false, comment: "状态"), RoleType = table.Column(type: "int", nullable: false, comment: "角色类型-集团角色_0、加盟商角色_1、门店角色_2"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_role", x => x.Id); }, comment: "角色表"); migrationBuilder.CreateTable( name: "sys_timer", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), JobName = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "任务名称"), DoOnce = table.Column(type: "bit", nullable: false, comment: "只执行一次"), StartNow = table.Column(type: "bit", nullable: false, comment: "立即执行"), ExecuteType = table.Column(type: "int", nullable: false, comment: "执行类型"), Interval = table.Column(type: "int", nullable: true, comment: "间隔时间"), Cron = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "Cron表达式"), TimerType = table.Column(type: "int", nullable: false, comment: "定时器类型"), RequestUrl = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "请求url"), RequestParameters = table.Column(type: "nvarchar(max)", nullable: true, comment: "请求参数"), Headers = table.Column(type: "nvarchar(max)", nullable: true, comment: "Headers"), RequestType = table.Column(type: "int", nullable: false, comment: "请求类型"), Remark = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(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(type: "bigint", nullable: false, comment: "Id主键"), Account = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "账号"), Password = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "密码"), NickName = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "昵称"), Name = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "姓名"), Avatar = table.Column(type: "nvarchar(max)", nullable: true, comment: "头像"), Birthday = table.Column(type: "datetimeoffset", nullable: true, comment: "生日"), Sex = table.Column(type: "int", nullable: false, comment: "性别-男_1、女_2"), Email = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "邮箱"), Phone = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "手机"), Tel = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "电话"), LastLoginIp = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true, comment: "最后登录IP"), LastLoginTime = table.Column(type: "datetimeoffset", nullable: true, comment: "最后登录时间"), AdminType = table.Column(type: "int", nullable: false, comment: "管理员类型-超级管理员_1、管理员_2、普通账号_3"), Status = table.Column(type: "int", nullable: false, comment: "状态-正常_0、停用_1、删除_2"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_user", x => x.Id); }, comment: "用户表"); migrationBuilder.CreateTable( name: "wms_area", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), AreaName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "名称"), AreaDesc = table.Column(type: "nvarchar(250)", maxLength: 250, nullable: true, comment: "描述"), AreaStatus = table.Column(type: "int", nullable: false, comment: "状态"), AreaType = table.Column(type: "int", nullable: false, comment: "分类"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_wms_area", x => x.Id); }, comment: "库区"); migrationBuilder.CreateTable( name: "wms_container", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), ContainerCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编号"), ContainerType = table.Column(type: "int", nullable: false, comment: "类型"), ContainerStatus = table.Column(type: "int", nullable: false, comment: "托盘状态"), SpecLength = table.Column(type: "decimal(18,2)", nullable: false, comment: "长度"), SpecWidth = table.Column(type: "decimal(18,2)", nullable: false, comment: "宽度"), SpecHeight = table.Column(type: "decimal(18,2)", nullable: false, comment: "高度"), LimitLength = table.Column(type: "decimal(18,2)", nullable: false, comment: "限长"), LimitWidth = table.Column(type: "decimal(18,2)", nullable: false, comment: "限宽"), LimitHeight = table.Column(type: "decimal(18,2)", nullable: false, comment: "限高"), MaxWeight = table.Column(type: "decimal(18,2)", nullable: false, comment: "载重上限"), ParentContainerId = table.Column(type: "bigint", nullable: false, comment: "父托盘ID"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_wms_container", x => x.Id); }, comment: "托盘信息"); migrationBuilder.CreateTable( name: "wms_material", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), MaterialName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料名称"), MaterialNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料编号"), MaterialBatch = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料批次"), Description = table.Column(type: "nvarchar(500)", maxLength: 500, nullable: true, comment: "描述"), InspectionMethod = table.Column(type: "int", nullable: false, comment: "检验方式"), MaterialType = table.Column(type: "int", nullable: false, comment: "物料类别"), MaterialSpec = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料规格"), UnitType = table.Column(type: "int", nullable: false, comment: "单位类别"), UnitNo = table.Column(type: "int", nullable: false, comment: "单位编号"), Safeqty = table.Column(type: "decimal(18,2)", nullable: false, comment: "安全存量"), Keymaterials = table.Column(type: "int", nullable: false, comment: "是否关键物料"), ErpNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "Erp单号"), GraphNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "图号"), Qccategory = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "品管类别"), Warranty = table.Column(type: "decimal(18,2)", nullable: false, comment: "保质期"), MaxImumqty = table.Column(type: "decimal(18,2)", nullable: false, comment: "最大存量"), MinstorageAge = table.Column(type: "decimal(18,2)", nullable: false, comment: "最小库龄"), MaxstorageAge = table.Column(type: "decimal(18,2)", nullable: false, comment: "最大库龄"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_wms_material", x => x.Id); }, comment: "物料信息"); migrationBuilder.CreateTable( name: "wms_materialstock", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), MaterialNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料编号"), MaterialType = table.Column(type: "int", nullable: false, comment: "物料类别"), MaterialBatch = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料批次"), MaterialName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料名称"), MaterialSpec = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "物料规格"), InspectionMethod = table.Column(type: "int", nullable: false, comment: "检验方式"), UnitType = table.Column(type: "int", nullable: false, comment: "单位类别"), UnitNo = table.Column(type: "int", nullable: false, comment: "单位编号"), StockNumber = table.Column(type: "decimal(18,2)", nullable: false, comment: "库存数"), PlaceCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "库位编码"), ContainerCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "托盘编码"), AreaId = table.Column(type: "bigint", nullable: false, comment: "库区ID"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_wms_materialstock", x => x.Id); }, comment: "库存表"); migrationBuilder.CreateTable( name: "wms_task", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), TaskNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "任务号"), TaskModel = table.Column(type: "int", nullable: false, comment: "任务方式"), TaskType = table.Column(type: "int", nullable: false, comment: "任务类型"), TaskLevel = table.Column(type: "int", nullable: false, comment: "任务级别"), TaskStatus = table.Column(type: "int", nullable: false, comment: "任务状态"), ContainerCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "托盘编号"), SourcePlace = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "起始库位"), ToPlace = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "目标库位"), Aisle = table.Column(type: "int", nullable: false, comment: "巷道"), AreaName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "库区名称"), OrderNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "组盘记录ID"), SendTimes = table.Column(type: "int", nullable: false, comment: "发送次数"), DodeviceId = table.Column(type: "int", nullable: false, comment: "任务执行堆垛机ID"), DodevicenodeId = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "设备执行节点ID"), Dodevicetype = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "设备类型"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_wms_task", x => x.Id); }, comment: "任务管理"); migrationBuilder.CreateTable( name: "sys_dict_data", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), TypeId = table.Column(type: "bigint", nullable: false, comment: "字典类型Id"), Value = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "值"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "编码"), Sort = table.Column(type: "int", nullable: false, comment: "排序"), Remark = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "备注"), Status = table.Column(type: "int", nullable: false, comment: "状态"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(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.Cascade); }, comment: "字典值表"); migrationBuilder.CreateTable( name: "sys_low_code_module_database", columns: table => new { Id = table.Column(type: "uniqueidentifier", nullable: false, comment: "Id主键"), SysLowCodeId = table.Column(type: "bigint", nullable: false), Control_Key = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "组件Key"), Control_Label = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "组件名称"), Control_Model = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "组件字段"), Control_Type = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "组件字段"), TableName = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "表名"), ClassName = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "类名"), TableDesc = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "表描述"), FieldName = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "字段名称"), DbTypeName = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "数据类型"), DtoTypeName = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "传入数据类型"), DbParam = table.Column(type: "nvarchar(200)", maxLength: 200, nullable: true, comment: "数据类型补充参数"), IsRequired = table.Column(type: "bit", nullable: true, comment: "是否必填"), WhetherTable = table.Column(type: "bit", nullable: true, comment: "列表显示"), WhetherOrderBy = table.Column(type: "bit", nullable: true, comment: "排序"), WhetherAddUpdate = table.Column(type: "bit", nullable: true, comment: "增改"), QueryWhether = table.Column(type: "bit", nullable: true, comment: "是否是查询"), QueryType = table.Column(type: "nvarchar(max)", nullable: true, comment: "查询方式"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_sys_low_code_module_database", x => x.Id); table.ForeignKey( name: "FK_sys_low_code_module_database_sys_low_code_module_SysLowCodeId", column: x => x.SysLowCodeId, principalTable: "sys_low_code_module", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "低代码模块管理"); migrationBuilder.CreateTable( name: "sys_emp_ext_org_pos", columns: table => new { SysEmpId = table.Column(type: "bigint", nullable: false, comment: "员工Id"), SysOrgId = table.Column(type: "bigint", nullable: false, comment: "机构Id"), SysPosId = table.Column(type: "bigint", 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_emp_pos", columns: table => new { SysEmpId = table.Column(type: "bigint", nullable: false, comment: "员工Id"), SysPosId = table.Column(type: "bigint", 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_data_scope", columns: table => new { SysRoleId = table.Column(type: "bigint", nullable: false, comment: "角色Id"), SysOrgId = table.Column(type: "bigint", 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_role_menu", columns: table => new { SysRoleId = table.Column(type: "bigint", nullable: false, comment: "角色Id"), SysMenuId = table.Column(type: "bigint", 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_data_scope", columns: table => new { SysUserId = table.Column(type: "bigint", nullable: false, comment: "用户Id"), SysOrgId = table.Column(type: "bigint", 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.CreateTable( name: "sys_user_role", columns: table => new { SysUserId = table.Column(type: "bigint", nullable: false, comment: "用户Id"), SysRoleId = table.Column(type: "bigint", 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: "wms_place", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), PlaceCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "编码"), PlaceStatus = table.Column(type: "int", nullable: false, comment: "库位状态"), AreaId = table.Column(type: "bigint", nullable: false, comment: "所在库区"), RowNo = table.Column(type: "int", nullable: false, comment: "排"), ColumnNo = table.Column(type: "int", nullable: false, comment: "列"), LayerNo = table.Column(type: "int", nullable: false, comment: "层"), DeepcellNo = table.Column(type: "int", nullable: false, comment: "进深号"), Aisle = table.Column(type: "int", nullable: false, comment: "巷道"), Line = table.Column(type: "int", nullable: false, comment: "线号"), Islock = table.Column(type: "int", nullable: false, comment: "是否锁定"), EmptyContainer = table.Column(type: "int", nullable: false, comment: "是否空托"), PositionnoForSrm = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "堆垛机内部的位置"), Xzb = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "库位X坐标"), Yzb = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "库位Y坐标"), Zzb = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "库位Z坐标"), Length = table.Column(type: "decimal(18,2)", nullable: false, comment: "库位长度"), Width = table.Column(type: "decimal(18,2)", nullable: false, comment: "库位宽度"), Height = table.Column(type: "decimal(18,2)", nullable: false, comment: "库位高度"), MaxWeight = table.Column(type: "decimal(18,2)", nullable: false, comment: "最大承重"), HeightLevel = table.Column(type: "int", nullable: false, comment: "库位高度"), Priority = table.Column(type: "int", nullable: false, comment: "优先级"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_wms_place", x => x.Id); table.ForeignKey( name: "FK_wms_place_wms_area_AreaId", column: x => x.AreaId, principalTable: "wms_area", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }, comment: "库位"); migrationBuilder.CreateTable( name: "wms_materialcontainer", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), ContainerId = table.Column(type: "bigint", nullable: false, comment: "托盘ID"), ContainerCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "托盘编码"), MaterialName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料名称"), MaterialNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料编号"), MaterialBatch = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "物料批次"), MaterialSpec = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "物料规格"), MaterialId = table.Column(type: "bigint", nullable: false, comment: "物料ID"), BindQuantity = table.Column(type: "decimal(18,2)", nullable: false, comment: "组盘数量"), BindStatus = table.Column(type: "int", nullable: false, comment: "组盘状态"), SampleQty = table.Column(type: "decimal(18,2)", nullable: false, comment: "抽检数量"), OrderNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "单号"), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_wms_materialcontainer", x => x.Id); table.ForeignKey( name: "FK_wms_materialcontainer_wms_container_ContainerId", column: x => x.ContainerId, principalTable: "wms_container", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_wms_materialcontainer_wms_material_MaterialId", column: x => x.MaterialId, principalTable: "wms_material", principalColumn: "Id"); }, comment: "物料托盘关系表"); migrationBuilder.CreateTable( name: "wms_containerplace", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), PlaceId = table.Column(type: "bigint", nullable: false, comment: "库位ID"), PlaceCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "库位编码"), ContainerId = table.Column(type: "bigint", nullable: false, comment: "托盘ID"), ContainerCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "库位编码"), ContainerPlaceStatus = table.Column(type: "int", nullable: false, comment: "状态"), WmsContainerId = table.Column(type: "bigint", nullable: true), WmsPlaceId = table.Column(type: "bigint", nullable: true), CreatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "创建时间"), UpdatedTime = table.Column(type: "datetimeoffset", nullable: true, comment: "更新时间"), CreatedUserId = table.Column(type: "bigint", nullable: true, comment: "创建者Id"), CreatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "创建者名称"), UpdatedUserId = table.Column(type: "bigint", nullable: true, comment: "修改者Id"), UpdatedUserName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "修改者名称"), IsDeleted = table.Column(type: "bit", nullable: false, comment: "软删除标记") }, constraints: table => { table.PrimaryKey("PK_wms_containerplace", x => x.Id); table.ForeignKey( name: "FK_wms_containerplace_wms_container_WmsContainerId", column: x => x.WmsContainerId, principalTable: "wms_container", principalColumn: "Id"); table.ForeignKey( name: "FK_wms_containerplace_wms_place_WmsPlaceId", column: x => x.WmsPlaceId, principalTable: "wms_place", principalColumn: "Id"); }, comment: "托盘库位关系表"); migrationBuilder.InsertData( table: "sys_app", columns: new[] { "Id", "Active", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 142307070898245L, "Y", "system", null, null, null, false, "开发管理", 100, 0, null, null, null }, { 142307070902341L, "N", "manage", null, null, null, false, "系统管理", 300, 0, null, null, null }, { 142307070922869L, "N", "busiapp", null, null, null, false, "业务应用", 400, 0, null, null, null }, { 355686432948293L, "N", "warejob", null, null, null, false, "仓库作业", 500, 0, null, null, null }, { 355686518018117L, "N", "warecount", null, null, null, false, "统计查询", 600, 0, null, null, null } }); 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[,] { { 142307070902342L, "DILON_JWT_SECRET", null, null, null, "DEFAULT", false, "jwt密钥", "（重要）jwt密钥，默认为空，自行设置", 0, "Y", null, null, null, "weiben" }, { 142307070902343L, "DILON_DEFAULT_PASSWORD", null, null, null, "DEFAULT", false, "默认密码", "默认密码", 0, "Y", null, null, null, "123456" }, { 142307070902344L, "DILON_TOKEN_EXPIRE", null, null, null, "DEFAULT", false, "token过期时间", "token过期时间（单位：秒）", 0, "Y", null, null, null, "86400" }, { 142307070902345L, "DILON_SESSION_EXPIRE", null, null, null, "DEFAULT", false, "session会话过期时间", "session会话过期时间（单位：秒）", 0, "Y", null, null, null, "7200" }, { 142307070902361L, "DILON_FILE_UPLOAD_PATH_FOR_WINDOWS", null, null, null, "FILE_PATH", false, "Win本地上传文件路径", "Win本地上传文件路径", 0, "Y", null, null, null, "D:/tmp" }, { 142307070902363L, "DILON_UN_XSS_FILTER_URL", null, null, null, "DEFAULT", false, "放开XSS过滤的接口", "多个url可以用英文逗号隔开", 0, "Y", null, null, null, "/demo/xssfilter,/demo/unxss" }, { 142307070902364L, "DILON_ENABLE_SINGLE_LOGIN", null, null, null, "DEFAULT", false, "单用户登陆的开关", "true-打开，false-关闭，如果一个人登录两次，就会将上一次登陆挤下去", 0, "Y", null, null, null, "false" }, { 142307070902365L, "DILON_CAPTCHA_OPEN", null, null, null, "DEFAULT", false, "登录验证码的开关", "true-打开，false-关闭", 0, "Y", null, null, null, "true" } }); migrationBuilder.InsertData( table: "sys_dict_type", columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Remark", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 142307070906483L, "common_status", null, null, null, false, "通用状态", "通用状态", 100, 0, null, null, null }, { 142307070906484L, "sex", null, null, null, false, "性别", "性别字典", 100, 0, null, null, null }, { 142307070906485L, "consts_type", null, null, null, false, "常量的分类", "常量的分类，用于区别一组配置", 100, 0, null, null, null }, { 142307070906486L, "yes_or_no", null, null, null, false, "是否", "是否", 100, 0, null, null, null }, { 142307070906487L, "vis_type", null, null, null, false, "访问类型", "访问类型", 100, 0, null, null, null }, { 142307070906488L, "menu_type", null, null, null, false, "菜单类型", "菜单类型", 100, 0, null, null, null }, { 142307070906489L, "send_type", null, null, null, false, "发送类型", "发送类型", 100, 0, null, null, null }, { 142307070906490L, "open_type", null, null, null, false, "打开方式", "打开方式", 100, 0, null, null, null }, { 142307070906491L, "menu_weight", null, null, null, false, "菜单权重", "菜单权重", 100, 0, null, null, null }, { 142307070906492L, "data_scope_type", null, null, null, false, "数据范围类型", "数据范围类型", 100, 0, null, null, null }, { 142307070906494L, "op_type", null, null, null, false, "操作类型", "操作类型", 100, 0, null, null, null }, { 142307070906495L, "file_storage_location", null, null, null, false, "文件存储位置", "文件存储位置", 100, 0, null, null, null }, { 142307070910533L, "run_status", null, null, null, false, "运行状态", "定时任务运行状态", 100, 0, null, null, null }, { 142307070910534L, "notice_type", null, null, null, false, "通知公告类型", "通知公告类型", 100, 0, null, null, null }, { 142307070910535L, "notice_status", null, null, null, false, "通知公告状态", "通知公告状态", 100, 0, null, null, null }, { 142307070910536L, "yes_true_false", null, null, null, false, "是否boolean", "是否boolean", 100, 0, null, null, null }, { 142307070910537L, "code_gen_create_type", null, null, null, false, "代码生成方式", "代码生成方式", 100, 0, null, null, null }, { 142307070910538L, "request_type", null, null, null, false, "请求方式", "请求方式", 100, 0, null, null, null }, { 142307070922827L, "code_gen_effect_type", null, null, null, false, "代码生成作用类型", "代码生成作用类型", 100, 0, null, null, null }, { 142307070922828L, "code_gen_query_type", null, null, null, false, "代码生成查询类型", "代码生成查询类型", 100, 0, null, null, null }, { 142307070922829L, "code_gen_net_type", null, null, null, false, "代码生成.NET类型", "代码生成.NET类型", 100, 0, null, null, null }, { 142307070926941L, "role_type", null, null, null, false, "角色类型", "角色类型", 100, 0, null, null, null }, { 142307070926942L, "org_type", null, null, null, false, "机构类型", "机构类型", 100, 0, null, null, null }, { 285605149831237L, "form_type", null, null, null, false, "表单类型", "表单类型", 100, 0, null, null, null }, { 285641358889029L, "workflow_group", null, null, null, false, "流程分类", "流程分类", 100, 0, null, null, null }, { 355694205325381L, "container_type", null, null, null, false, "托盘类型", "", 100, 0, null, null, null }, { 355697881423941L, "container_status", null, null, null, false, "托盘状态", "", 100, 0, null, null, null }, { 355698224758853L, "area_type", null, null, null, false, "库区类型", "", 100, 0, null, null, null }, { 355698441912389L, "place_status", null, null, null, false, "库位状态", "", 100, 0, null, null, null } }); migrationBuilder.InsertData( table: "sys_dict_type", columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "Remark", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 355698661130309L, "height_level", null, null, null, false, "库位高度", "", 100, 0, null, null, null }, { 355698855280709L, "material_inspection", null, null, null, false, "物料检验", "", 100, 0, null, null, null }, { 355699003580485L, "material_type", null, null, null, false, "物料类别", "", 100, 0, null, null, null }, { 355699189051461L, "unit_type", null, null, null, false, "单位类别", "", 100, 0, null, null, null }, { 355699314061381L, "unitno_type", null, null, null, false, "单位编号", "", 100, 0, null, null, null }, { 355699447029829L, "task_model", null, null, null, false, "任务方式", "", 100, 0, null, null, null }, { 355699576467525L, "task_type", null, null, null, false, "任务类型", "", 100, 0, null, null, null }, { 355699731099717L, "task_status", null, null, null, false, "任务状态", "", 100, 0, null, null, null } }); migrationBuilder.InsertData( table: "sys_emp", columns: new[] { "Id", "JobNum", "OrgId", "OrgName" }, values: new object[,] { { 142307070910551L, "D1001", 142307070910539L, "华夏集团" }, { 142307070910552L, "D1002", 142307070910539L, "华夏集团" }, { 142307070910553L, "D1003", 142307070910539L, "华夏集团" }, { 142307070910554L, "D1001", 142307070910547L, "租户1公司" }, { 142307070910555L, "D1002", 142307070910547L, "租户1公司" }, { 142307070910556L, "D1003", 142307070910547L, "租户1公司" }, { 142307070910557L, "D1001", 142307070910548L, "租户2公司" }, { 142307070910558L, "D1002", 142307070910548L, "租户2公司" }, { 142307070910559L, "D1003", 142307070910548L, "租户2公司" }, { 358533464608837L, "", 142307070910539L, "伟本股份有限公司" }, { 358536045723717L, "", 142307070910542L, "研发部" } }); 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", "Weight" }, values: new object[,] { { 142307000914633L, "manage", "sys_mgr", "PageView", null, null, null, "team", false, null, "组织架构", 0, null, 0L, "[0],", null, null, "/sys", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070910563L, "manage", "auth_manager", "PageView", null, null, null, "safety-certificate", false, null, "权限管理", 0, null, 0L, "[0],", null, null, "/auth", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070910564L, "manage", "sys_user_mgr", "system/user/index", null, null, null, null, false, null, "用户管理", 1, null, 142307070910563L, "[0],[142307070910563],", null, null, "/mgr_user", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070910565L, "manage", "sys_user_mgr_page", null, null, null, null, null, false, null, "用户查询", 0, "sysUser:page", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910566L, "manage", "sys_user_mgr_edit", null, null, null, null, null, false, null, "用户编辑", 0, "sysUser:edit", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910567L, "manage", "sys_user_mgr_add", null, null, null, null, null, false, null, "用户增加", 0, "sysUser:add", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910568L, "manage", "sys_user_mgr_delete", null, null, null, null, null, false, null, "用户删除", 0, "sysUser:delete", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910569L, "manage", "sys_user_mgr_detail", null, null, null, null, null, false, null, "用户详情", 0, "sysUser:detail", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910570L, "manage", "sys_user_mgr_export", null, null, null, null, null, false, null, "用户导出", 0, "sysUser:export", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910571L, "manage", "sys_user_mgr_selector", null, null, null, null, null, false, null, "用户选择器", 0, "sysUser:selector", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910572L, "manage", "sys_user_mgr_grant_role", null, null, null, null, null, false, null, "用户授权角色", 0, "sysUser:grantRole", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910573L, "manage", "sys_user_mgr_own_role", null, null, null, null, null, false, null, "用户拥有角色", 0, "sysUser:ownRole", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910574L, "manage", "sys_user_mgr_grant_data", null, null, null, null, null, false, null, "用户授权数据", 0, "sysUser:grantData", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910575L, "manage", "sys_user_mgr_own_data", null, null, null, null, null, false, null, "用户拥有数据", 0, "sysUser:ownData", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910576L, "manage", "sys_user_mgr_update_info", null, null, null, null, null, false, null, "用户更新信息", 0, "sysUser:updateInfo", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910577L, "manage", "sys_user_mgr_update_pwd", null, null, null, null, null, false, null, "用户修改密码", 0, "sysUser:updatePwd", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910578L, "manage", "sys_user_mgr_change_status", null, null, null, null, null, false, null, "用户修改状态", 0, "sysUser:changeStatus", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910579L, "manage", "sys_user_mgr_update_avatar", null, null, null, null, null, false, null, "用户修改头像", 0, "sysUser:updateAvatar", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910580L, "manage", "sys_user_mgr_reset_pwd", null, null, null, null, null, false, null, "用户重置密码", 0, "sysUser:resetPwd", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910581L, "manage", "sys_org_mgr", "system/org/index", null, null, null, null, false, null, "机构管理", 1, null, 142307000914633L, "[0],[142307000914633],", null, null, "/org", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070910582L, "manage", "sys_org_mgr_page", null, null, null, null, null, false, null, "机构查询", 0, "sysOrg:page", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910583L, "manage", "sys_org_mgr_list", null, null, null, null, null, false, null, "机构列表", 0, "sysOrg:list", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910584L, "manage", "sys_org_mgr_add", null, null, null, null, null, false, null, "机构增加", 0, "sysOrg:add", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 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", "Weight" }, values: new object[,] { { 142307070910585L, "manage", "sys_org_mgr_edit", null, null, null, null, null, false, null, "机构编辑", 0, "sysOrg:edit", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910586L, "manage", "sys_org_mgr_delete", null, null, null, null, null, false, null, "机构删除", 0, "sysOrg:delete", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910587L, "manage", "sys_org_mgr_detail", null, null, null, null, null, false, null, "机构详情", 0, "sysOrg:detail", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910588L, "manage", "sys_org_mgr_tree", null, null, null, null, null, false, null, "机构树", 0, "sysOrg:tree", 142307070910581L, "[0],[142307000914633],[142307070910581],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910589L, "manage", "sys_pos_mgr", "system/pos/index", null, null, null, null, false, null, "职位管理", 1, null, 142307000914633L, "[0],[142307000914633],", null, null, "/pos", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070910590L, "manage", "sys_pos_mgr_page", null, null, null, null, null, false, null, "职位查询", 0, "sysPos:page", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070910591L, "manage", "sys_pos_mgr_list", null, null, null, null, null, false, null, "职位列表", 0, "sysPos:list", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070911739L, "manage", "sys_log_mgr_ex_log", "system/log/exlog/index", null, null, null, null, false, null, "异常日志", 1, null, 142307070918732L, "[0],[142307070918732],", null, null, "/exlog", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070911740L, "manage", "sys_log_mgr_ex_log_page", null, null, null, null, null, false, null, "异常日志查询", 0, "sysExLog:page", 142307070911739L, "[0],[142307070918732],[142307070911739],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070911741L, "manage", "sys_log_mgr_ex_log_delete", null, null, null, null, null, false, null, "异常日志清空", 0, "sysExLog:delete", 142307070911739L, "[0],[142307070918732],[142307070911739],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914629L, "manage", "sys_pos_mgr_add", null, null, null, null, null, false, null, "职位增加", 0, "sysPos:add", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914630L, "manage", "sys_pos_mgr_edit", null, null, null, null, null, false, null, "职位编辑", 0, "sysPos:edit", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914631L, "manage", "sys_pos_mgr_delete", null, null, null, null, null, false, null, "职位删除", 0, "sysPos:delete", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914632L, "manage", "sys_pos_mgr_detail", null, null, null, null, null, false, null, "职位详情", 0, "sysPos:detail", 142307070910589L, "[0],[142307000914633],[142307070910589],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914633L, "system", "sys_platform", "PageView", null, null, null, "safety-certificate", false, null, "平台管理", 0, null, 0L, "[0],", null, null, "/platform", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070914634L, "system", "sys_app_mgr", "system/app/index", null, null, null, null, false, null, "应用管理", 1, null, 142307070914633L, "[0],[142307070914633],", null, null, "/app", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070914635L, "system", "sys_app_mgr_page", null, null, null, null, null, false, null, "应用查询", 0, "sysApp:page", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914636L, "system", "sys_app_mgr_list", null, null, null, null, null, false, null, "应用列表", 0, "sysApp:list", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914637L, "system", "sys_app_mgr_add", null, null, null, null, null, false, null, "应用增加", 0, "sysApp:add", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914638L, "system", "sys_app_mgr_edit", null, null, null, null, null, false, null, "应用编辑", 0, "sysApp:edit", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914639L, "system", "sys_app_mgr_delete", null, null, null, null, null, false, null, "应用删除", 0, "sysApp:delete", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914640L, "system", "sys_app_mgr_detail", null, null, null, null, null, false, null, "应用详情", 0, "sysApp:detail", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914641L, "system", "sys_app_mgr_set_as_default", null, null, null, null, null, false, null, "设为默认应用", 0, "sysApp:setAsDefault", 142307070914634L, "[0],[142307070914633],[142307070914634],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914642L, "system", "sys_menu_mgr", "system/menu/index", null, null, null, null, false, null, "菜单管理", 1, null, 142307070914633L, "[0],[142307070914633],", null, null, "/menu", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070914643L, "system", "sys_menu_mgr_list", null, null, null, null, null, false, null, "菜单列表", 0, "sysMenu:list", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914644L, "system", "sys_menu_mgr_add", null, null, null, null, null, false, null, "菜单增加", 0, "sysMenu:add", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914645L, "system", "sys_menu_mgr_edit", null, null, null, null, null, false, null, "菜单编辑", 0, "sysMenu:edit", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914646L, "system", "sys_menu_mgr_delete", null, null, null, null, null, false, null, "菜单删除", 0, "sysMenu:delete", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914647L, "system", "sys_menu_mgr_detail", null, null, null, null, null, false, null, "菜单详情", 0, "sysMenu:detail", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914648L, "manage", "sys_menu_mgr_grant_tree", null, null, null, null, null, false, null, "菜单授权树", 0, "sysMenu:treeForGrant", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914649L, "manage", "sys_menu_mgr_tree", null, null, null, null, null, false, null, "菜单树", 0, "sysMenu:tree", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914650L, "system", "sys_menu_mgr_change", null, null, null, null, null, false, null, "菜单切换", 0, "sysMenu:change", 142307070914642L, "[0],[142307070914633],[142307070914642],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914651L, "manage", "sys_role_mgr", "system/role/index", null, null, null, null, false, null, "角色管理", 1, null, 142307070910563L, "[0],[142307070910563],", null, null, "/role", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070914652L, "manage", "sys_role_mgr_page", null, null, null, null, null, false, null, "角色查询", 0, "sysRole:page", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914653L, "manage", "sys_role_mgr_add", null, null, null, null, null, false, null, "角色增加", 0, "sysRole:add", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914654L, "manage", "sys_role_mgr_edit", null, null, null, null, null, false, null, "角色编辑", 0, "sysRole:edit", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914655L, "manage", "sys_role_mgr_delete", null, null, null, null, null, false, null, "角色删除", 0, "sysRole:delete", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914656L, "manage", "sys_role_mgr_detail", null, null, null, null, null, false, null, "角色详情", 0, "sysRole:detail", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914657L, "manage", "sys_role_mgr_drop_down", null, null, null, null, null, false, null, "角色下拉", 0, "sysRole:dropDown", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914658L, "manage", "sys_role_mgr_grant_menu", null, null, null, null, null, false, null, "角色授权菜单", 0, "sysRole:grantMenu", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914659L, "manage", "sys_role_mgr_own_menu", null, null, null, null, null, false, null, "角色拥有菜单", 0, "sysRole:ownMenu", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914660L, "manage", "sys_role_mgr_grant_data", null, null, null, null, null, false, null, "角色授权数据", 0, "sysRole:grantData", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 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", "Weight" }, values: new object[,] { { 142307070914661L, "manage", "sys_role_mgr_own_data", null, null, null, null, null, false, null, "角色拥有数据", 0, "sysRole:ownData", 142307070914651L, "[0],[142307070910563],[142307070914651],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914662L, "system", "system_tools", "PageView", null, null, null, "euro", false, null, "开发管理", 0, null, 0L, "[0],", null, null, "/tools", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070914663L, "system", "system_tools_config", "system/config/index", null, null, null, null, false, null, "系统配置", 1, null, 142307070914662L, "[0],[142307070914662],", null, null, "/config", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070914664L, "system", "system_tools_config_page", null, null, null, null, null, false, null, "配置查询", 0, "sysConfig:page", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914665L, "system", "system_tools_config_list", null, null, null, null, null, false, null, "配置列表", 0, "sysConfig:list", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914666L, "system", "system_tools_config_add", null, null, null, null, null, false, null, "配置增加", 0, "sysConfig:add", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914667L, "system", "system_tools_config_edit", null, null, null, null, null, false, null, "配置编辑", 0, "sysConfig:edit", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914668L, "system", "system_tools_config_delete", null, null, null, null, null, false, null, "配置删除", 0, "sysConfig:delete", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914669L, "system", "system_tools_config_detail", null, null, null, null, null, false, null, "配置详情", 0, "sysConfig:detail", 142307070914663L, "[0],[142307070914662],[142307070914663],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914678L, "system", "sys_dict_mgr", "system/dict/index", null, null, null, null, false, null, "字典管理", 1, null, 142307070914662L, "[0],[142307070914662],", null, null, "/dict", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070914679L, "system", "sys_dict_mgr_dict_type_page", null, null, null, null, null, false, null, "字典类型查询", 0, "sysDictType:page", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914680L, "system", "sys_dict_mgr_dict_type_list", null, null, null, null, null, false, null, "字典类型列表", 0, "sysDictType:list", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914681L, "system", "sys_dict_mgr_dict_type_add", null, null, null, null, null, false, null, "字典类型增加", 0, "sysDictType:add", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914682L, "system", "sys_dict_mgr_dict_type_delete", null, null, null, null, null, false, null, "字典类型删除", 0, "sysDictType:delete", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914683L, "system", "sys_dict_mgr_dict_type_edit", null, null, null, null, null, false, null, "字典类型编辑", 0, "sysDictType:edit", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914684L, "system", "sys_dict_mgr_dict_type_detail", null, null, null, null, null, false, null, "字典类型详情", 0, "sysDictType:detail", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914685L, "system", "sys_dict_mgr_dict_type_drop_down", null, null, null, null, null, false, null, "字典类型下拉", 0, "sysDictType:dropDown", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914686L, "system", "sys_dict_mgr_dict_type_change_status", null, null, null, null, null, false, null, "字典类型修改状态", 0, "sysDictType:changeStatus", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070914687L, "system", "sys_dict_mgr_dict_page", null, null, null, null, null, false, null, "字典值查询", 0, "sysDictData:page", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918725L, "system", "sys_dict_mgr_dict_list", null, null, null, null, null, false, null, "字典值列表", 0, "sysDictData:list", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918726L, "system", "sys_dict_mgr_dict_add", null, null, null, null, null, false, null, "字典值增加", 0, "sysDictData:add", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918727L, "system", "sys_dict_mgr_dict_delete", null, null, null, null, null, false, null, "字典值删除", 0, "sysDictData:delete", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918728L, "system", "sys_dict_mgr_dict_edit", null, null, null, null, null, false, null, "字典值编辑", 0, "sysDictData:edit", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918729L, "system", "sys_dict_mgr_dict_detail", null, null, null, null, null, false, null, "字典值详情", 0, "sysDictData:detail", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918730L, "system", "sys_dict_mgr_dict_change_status", null, null, null, null, null, false, null, "字典值修改状态", 0, "sysDictData:changeStatus", 142307070914678L, "[0],[142307070914662],[142307070914678],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918731L, "system", "sys_swagger_mgr", "Iframe", null, null, null, null, false, "http://localhost:6677/swagger/", "接口文档", 2, null, 142307070914662L, "[0],[142307070914662],", null, null, "/swagger", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918732L, "manage", "sys_log_mgr", "PageView", null, null, null, "read", false, null, "日志管理", 0, null, 0L, "[0],", null, null, "/log", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070918733L, "manage", "sys_log_mgr_vis_log", "system/log/vislog/index", null, null, null, null, false, null, "访问日志", 1, null, 142307070918732L, "[0],[142307070918732],", null, null, "/vislog", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918734L, "manage", "sys_log_mgr_vis_log_page", null, null, null, null, null, false, null, "访问日志查询", 0, "sysVisLog:page", 142307070918733L, "[0],[142307070918732],[142307070918733],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918735L, "manage", "sys_log_mgr_vis_log_delete", null, null, null, null, null, false, null, "访问日志清空", 0, "sysVisLog:delete", 142307070918733L, "[0],[142307070918732],[142307070918733],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918736L, "manage", "sys_log_mgr_op_log", "system/log/oplog/index", null, null, null, null, false, null, "操作日志", 1, null, 142307070918732L, "[0],[142307070918732],", null, null, "/oplog", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918737L, "manage", "sys_log_mgr_op_log_page", null, null, null, null, null, false, null, "操作日志查询", 0, "sysOpLog:page", 142307070918736L, "[0],[142307070918732],[142307070918736],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918738L, "manage", "sys_log_mgr_op_log_delete", null, null, null, null, null, false, null, "操作日志清空", 0, "sysOpLog:delete", 142307070918736L, "[0],[142307070918732],[142307070918736],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918739L, "system", "sys_monitor_mgr", "PageView", null, null, null, "deployment-unit", false, null, "系统监控", 0, null, 0L, "[0],", null, null, "/monitor", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070918740L, "system", "sys_monitor_mgr_machine_monitor", "system/machine/index", null, null, null, null, false, null, "服务监控", 1, null, 142307070918739L, "[0],[142307070918739],", null, null, "/machine", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918741L, "system", "sys_monitor_mgr_machine_monitor_query", null, null, null, null, null, false, null, "服务监控查询", 0, "sysMachine:query", 142307070918740L, "[0],[142307070918739],[142307070918740],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918742L, "system", "sys_monitor_mgr_online_user", "system/onlineUser/index", null, null, null, null, false, null, "在线用户", 1, null, 142307070918739L, "[0],[142307070918739],", null, null, "/onlineUser", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918743L, "system", "sys_monitor_mgr_online_user_page", null, null, null, null, null, false, null, "在线用户查询", 0, "sysOnlineUser:page", 142307070918742L, "[0],[142307070918739],[142307070918742],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918744L, "system", "sys_monitor_mgr_online_user_force_exist", null, null, null, null, null, false, null, "在线用户强退", 0, "sysOnlineUser:forceExist", 142307070918742L, "[0],[142307070918739],[142307070918742],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918745L, "system", "sys_monitor_mgr_druid", "Iframe", null, null, null, null, false, "http://localhost:82/druid/login.html", "数据监控", 2, null, 142307070918739L, "[0],[142307070918739],", null, null, "/druid", 100, 0, 1, null, null, null, "N", 1 }, { 142307070918746L, "manage", "sys_notice", "PageView", null, null, null, "sound", false, null, "通知公告", 0, null, 0L, "[0],", null, null, "/notice", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070918747L, "manage", "sys_notice_mgr", "system/notice/index", null, null, null, null, false, null, "公告管理", 1, null, 142307070918746L, "[0],[142307070918746],", null, null, "/notice", 100, 0, 1, null, null, null, "Y", 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", "Weight" }, values: new object[,] { { 142307070918748L, "manage", "sys_notice_mgr_page", null, null, null, null, null, false, null, "公告查询", 0, "sysNotice:page", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918749L, "manage", "sys_notice_mgr_add", null, null, null, null, null, false, null, "公告增加", 0, "sysNotice:add", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918750L, "manage", "sys_notice_mgr_edit", null, null, null, null, null, false, null, "公告编辑", 0, "sysNotice:edit", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918751L, "manage", "sys_notice_mgr_delete", null, null, null, null, null, false, null, "公告删除", 0, "sysNotice:delete", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918752L, "manage", "sys_notice_mgr_detail", null, null, null, null, null, false, null, "公告查看", 0, "sysNotice:detail", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918753L, "manage", "sys_notice_mgr_changeStatus", null, null, null, null, null, false, null, "公告修改状态", 0, "sysNotice:changeStatus", 142307070918747L, "[0],[142307070918746],[142307070918747],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918754L, "manage", "sys_notice_mgr_received", "system/noticeReceived/index", null, null, null, null, false, null, "已收公告", 1, null, 142307070918746L, "[0],[142307070918746],", null, null, "/noticeReceived", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918755L, "manage", "sys_notice_mgr_received_page", null, null, null, null, null, false, null, "已收公告查询", 0, "sysNotice:received", 142307070918754L, "[0],[142307070918746],[142307070918754],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918756L, "manage", "sys_file_mgr", "PageView", null, null, null, "file", false, null, "文件管理", 0, null, 0L, "[0],", null, null, "/file", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070918757L, "manage", "sys_file_mgr_sys_file", "system/file/index", null, null, null, null, false, null, "系统文件", 1, null, 142307070918756L, "[0],[142307070918756],", null, null, "/file", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918758L, "manage", "sys_file_mgr_sys_file_page", null, null, null, null, null, false, null, "文件查询", 0, "sysFileInfo:page", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918759L, "manage", "sys_file_mgr_sys_file_list", null, null, null, null, null, false, null, "文件列表", 0, "sysFileInfo:list", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918760L, "manage", "sys_file_mgr_sys_file_delete", null, null, null, null, null, false, null, "文件删除", 0, "sysFileInfo:delete", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918761L, "manage", "sys_file_mgr_sys_file_detail", null, null, null, null, null, false, null, "文件详情", 0, "sysFileInfo:detail", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918762L, "manage", "sys_file_mgr_sys_file_upload", null, null, null, null, null, false, null, "文件上传", 0, "sysFileInfo:upload", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918763L, "manage", "sys_file_mgr_sys_file_download", null, null, null, null, null, false, null, "文件下载", 0, "sysFileInfo:download", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918764L, "manage", "sys_file_mgr_sys_file_preview", null, null, null, null, null, false, null, "图片预览", 0, "sysFileInfo:preview", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918765L, "system", "sys_timers", "PageView", null, null, null, "dashboard", false, null, "任务调度", 0, null, 0L, "[0],", null, null, "/timers", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070918766L, "system", "sys_timers_mgr", "system/timers/index", null, null, null, null, false, null, "任务管理", 1, null, 142307070918765L, "[0],[142307070918765],", null, null, "/timers", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918767L, "system", "sys_timers_mgr_page", null, null, null, null, null, false, null, "定时任务查询", 0, "sysTimers:page", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918768L, "system", "sys_timers_mgr_list", null, null, null, null, null, false, null, "定时任务列表", 0, "sysTimers:list", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918769L, "system", "sys_timers_mgr_detail", null, null, null, null, null, false, null, "定时任务详情", 0, "sysTimers:detail", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918770L, "system", "sys_timers_mgr_add", null, null, null, null, null, false, null, "定时任务增加", 0, "sysTimers:add", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918771L, "system", "sys_timers_mgr_delete", null, null, null, null, null, false, null, "定时任务删除", 0, "sysTimers:delete", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918772L, "system", "sys_timers_mgr_edit", null, null, null, null, null, false, null, "定时任务编辑", 0, "sysTimers:edit", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918773L, "system", "sys_timers_mgr_get_action_classes", null, null, null, null, null, false, null, "定时任务可执行列表", 0, "sysTimers:getActionClasses", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918774L, "system", "sys_timers_mgr_start", null, null, null, null, null, false, null, "定时任务启动", 0, "sysTimers:start", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918775L, "system", "sys_timers_mgr_stop", null, null, null, null, null, false, null, "定时任务关闭", 0, "sysTimers:stop", 142307070918766L, "[0],[142307070918765],[142307070918766],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070918776L, "system", "code_gen", "PageView", null, null, null, "thunderbolt", false, null, "代码生成", 0, null, 0L, "[0],", null, null, "/codeGenerate", 100, 0, 0, null, null, null, "Y", 1 }, { 142307070918777L, "manage", "sys_user_mgr_login", null, null, null, null, null, false, null, "用户登录信息", 0, "getLoginUser", 142307070910564L, "[0],[142307070910563],[142307070910564],", null, null, null, 100, 1, 2, null, null, null, "N", 1 }, { 142307070918778L, "system", "low_code", "gen/lowCode/index", null, null, null, null, false, null, "表单设计", 0, null, 142307070918776L, "[0],[142307070918776],", null, null, "/lowCode/index", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070918779L, "system", "code_gen_gen", "gen/codeGenerate/index", null, null, null, null, false, null, "代码生成", 0, null, 142307070918776L, "[0],[142307070918776],", null, null, "/codeGenerate/index", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070922870L, "system", "form_design", "system/formDesign/index", null, null, null, null, false, null, "表单设计", 0, null, 285599875018821L, "[0],[285599875018821],", null, null, "/formDesign/index", 100, 0, 1, null, null, null, "Y", 1 }, { 142307070922874L, "manage", "sys_file_mgr_sys_file_upload_avatar", null, null, null, null, null, false, null, "头像上传", 0, "sysFileInfo:uploadAvatar", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070922875L, "manage", "sys_file_mgr_sys_file_upload_document", null, null, null, null, null, false, null, "文档上传", 0, "sysFileInfo:uploadDocument", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 142307070922876L, "manage", "sys_file_mgr_sys_file_upload_shop", null, null, null, null, null, false, null, "商城上传", 0, "sysFileInfo:uploadShop", 142307070918757L, "[0],[142307070918756],[142307070918757],", null, null, null, 100, 0, 2, null, null, null, "Y", 1 }, { 285599875018821L, "system", "sys_formDesign", "PageView", null, null, null, "snippets", false, null, "表单管理", 1, null, 0L, "[0],", null, null, "/formDesign", 100, 0, 0, null, null, null, "Y", 1 }, { 285599875018823L, "system", "sys_formDesign_list", "system/formDesign/list", null, null, null, null, false, null, "表单列表", 1, null, 285599875018821L, "[0],[285599875018821],", null, null, "/formDesign/list", 100, 0, 1, null, null, null, "Y", 1 }, { 285635743518789L, "system", "sys_formDesign_edit", "system/formDesign/edit", null, null, null, null, false, null, "修改表单", 1, null, 285599875018821L, "[0],[285599875018821],", null, null, "/formDesign/edit", 100, 0, 1, null, null, null, "N", 1 }, { 285640475689029L, "system", "btn_formDesign_edit", "", null, null, null, null, false, null, "修改表单", 0, "formmanager:edit", 285599875018823L, "[0],[285599875018821],[285599875018823],", null, null, "", 100, 0, 2, null, null, null, "Y", 1 }, { 285640599859269L, "system", "btn_formDesign_delete", "", null, null, null, null, false, null, "删除表单", 0, "formmanager:delete", 285599875018823L, "[0],[285599875018821],[285599875018823],", null, null, "", 100, 0, 2, null, null, null, "Y", 1 }, { 285640740945989L, "system", "btn_formDesign_page", "", null, null, null, null, false, null, "表单列表", 0, "formmanager:page", 285599875018823L, "[0],[285599875018821],[285599875018823],", null, null, "", 100, 0, 2, null, null, null, "Y", 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", "Weight" }, values: new object[,] { { 355687925174341L, "busiapp", "Maste_wmscontainer_mgr", "main/WmsContainer/index", null, null, null, "border", false, null, "托盘信息", 1, null, 0L, "[0],", null, null, "/wmscontainer", 100, 0, 1, null, null, null, "Y", 2 }, { 355687925178437L, "busiapp", "Maste_wmscontainer_mgr_page", null, null, null, null, null, false, null, "托盘信息查询", 0, "WmsContainer:page", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355687925178438L, "busiapp", "Maste_wmscontainer_mgr_detail", null, null, null, null, null, false, null, "托盘信息详情", 0, "WmsContainer:detail", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355687925178439L, "busiapp", "Maste_wmscontainer_mgr_add", null, null, null, null, null, false, null, "托盘信息增加", 0, "WmsContainer:add", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355687925182533L, "busiapp", "Maste_wmscontainer_mgr_delete", null, null, null, null, null, false, null, "托盘信息删除", 0, "WmsContainer:delete", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355687925182534L, "busiapp", "Maste_wmscontainer_mgr_edit", null, null, null, null, null, false, null, "托盘信息编辑", 0, "WmsContainer:edit", 355687925174341L, "[0],[355687924998213],[355687925174341],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355688792178757L, "busiapp", "Maste_wmsarea_mgr", "main/WmsArea/index", null, null, null, "appstore", false, null, "库区信息", 1, null, 0L, "[0],", null, null, "/wmsarea", 100, 0, 1, null, null, null, "Y", 2 }, { 355688792182853L, "busiapp", "Maste_wmsarea_mgr_page", null, null, null, null, null, false, null, "库区信息查询", 0, "WmsArea:page", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355688792182854L, "busiapp", "Maste_wmsarea_mgr_detail", null, null, null, null, null, false, null, "库区信息详情", 0, "WmsArea:detail", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355688792186949L, "busiapp", "Maste_wmsarea_mgr_add", null, null, null, null, null, false, null, "库区信息增加", 0, "WmsArea:add", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355688792186950L, "busiapp", "Maste_wmsarea_mgr_delete", null, null, null, null, null, false, null, "库区信息删除", 0, "WmsArea:delete", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355688792186951L, "busiapp", "Maste_wmsarea_mgr_edit", null, null, null, null, null, false, null, "库区信息编辑", 0, "WmsArea:edit", 355688792178757L, "[0],[355688792162373],[355688792178757],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355689496985669L, "busiapp", "Maste_wmsplace_mgr", "main/WmsPlace/index", null, null, null, "table", false, null, "库位信息", 1, null, 0L, "[0],", null, null, "/wmsplace", 100, 0, 1, null, null, null, "Y", 2 }, { 355689496989765L, "busiapp", "Maste_wmsplace_mgr_page", null, null, null, null, null, false, null, "库位信息查询", 0, "WmsPlace:page", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355689496993861L, "busiapp", "Maste_wmsplace_mgr_detail", null, null, null, null, null, false, null, "库位信息详情", 0, "WmsPlace:detail", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355689496993862L, "busiapp", "Maste_wmsplace_mgr_add", null, null, null, null, null, false, null, "库位信息增加", 0, "WmsPlace:add", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355689496993863L, "busiapp", "Maste_wmsplace_mgr_delete", null, null, null, null, null, false, null, "库位信息删除", 0, "WmsPlace:delete", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355689496993864L, "busiapp", "Maste_wmsplace_mgr_edit", null, null, null, null, null, false, null, "库位信息编辑", 0, "WmsPlace:edit", 355689496985669L, "[0],[355689496977477],[355689496985669],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355690042511429L, "busiapp", "Maste_wmsmaterial_mgr", "main/WmsMaterial/index", null, null, null, "barcode", false, null, "物料信息", 1, null, 0L, "[0],", null, null, "/wmsmaterial", 100, 0, 1, null, null, null, "Y", 2 }, { 355690042515525L, "busiapp", "Maste_wmsmaterial_mgr_page", null, null, null, null, null, false, null, "物料信息查询", 0, "WmsMaterial:page", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355690042519621L, "busiapp", "Maste_wmsmaterial_mgr_detail", null, null, null, null, null, false, null, "物料信息详情", 0, "WmsMaterial:detail", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355690042519622L, "busiapp", "Maste_wmsmaterial_mgr_add", null, null, null, null, null, false, null, "物料信息增加", 0, "WmsMaterial:add", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355690042519623L, "busiapp", "Maste_wmsmaterial_mgr_delete", null, null, null, null, null, false, null, "物料信息删除", 0, "WmsMaterial:delete", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355690042519624L, "busiapp", "Maste_wmsmaterial_mgr_edit", null, null, null, null, null, false, null, "物料信息编辑", 0, "WmsMaterial:edit", 355690042511429L, "[0],[355690042499141],[355690042511429],", null, null, null, 100, 0, 2, null, null, null, "Y", 2 }, { 355690923847749L, "warejob", "BindEntrance", "main/BindEntrance/index", null, null, null, "logout", false, null, "组盘入库", 1, null, 0L, "[0],", null, null, "/BindEntrance", 100, 0, 1, null, null, null, "Y", 2 }, { 355691450822725L, "warejob", "ExWarehouse", "main/ExWarehouse/index", null, null, null, "login", false, null, "出库管理", 1, null, 0L, "[0],", null, null, "/ExWarehouse", 100, 0, 1, null, null, null, "Y", 2 }, { 355691891650629L, "warejob", "WmsTask", "main/WmsTask/index", null, null, null, "hourglass", false, null, "任务管理", 1, null, 0L, "[0],", null, null, "/WmsTask", 100, 0, 1, null, null, null, "Y", 2 }, { 355692253458501L, "warecount", "LocationView", "main/LocationView/index", null, null, null, "hdd", false, null, "库位视图", 1, null, 0L, "[0],", null, null, "/LocationView", 100, 0, 1, null, null, null, "Y", 2 }, { 355692487622725L, "warecount", "View_AccessDetails", "main/View_AccessDetails/index", null, null, null, "laptop", false, null, "出入库记录", 1, null, 0L, "[0],", null, null, "/View_AccessDetails", 100, 0, 1, null, null, null, "Y", 2 } }); migrationBuilder.InsertData( table: "sys_org", columns: new[] { "Id", "Code", "Contacts", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "Name", "OrgType", "Pid", "Pids", "Remark", "Sort", "Status", "Tel", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 142307070910539L, "wbgf", null, null, null, null, false, "伟本股份有限公司", null, 0L, "[0],", "伟本股份有限公司", 100, 0, null, null, null, null }, { 142307070910540L, "wbgf_sh", null, null, null, null, false, "伟本股份有限公司(上海)", null, 142307070910539L, "[0],[142307070910539],", "伟本股份有限公司-上海", 100, 0, null, null, null, null }, { 142307070910541L, "wbgf_cq", null, null, null, null, false, "伟本股份有限公司(重庆)", null, 142307070910539L, "[0],[142307070910539],", "伟本股份有限公司-重庆", 100, 0, null, null, null, null }, { 142307070910542L, "wbgf_sh_yfb", null, null, null, null, false, "研发部", null, 142307070910540L, "[0],[142307070910539],[142307070910540],", "", 100, 0, null, null, null, null }, { 142307070910543L, "wbgf_sh_qhb", null, null, null, null, false, "企划部", null, 142307070910540L, "[0],[142307070910539],[142307070910540],", "", 100, 0, null, null, null, null }, { 142307070910544L, "wbgf_cq_scb", null, null, null, null, false, "市场部", null, 142307070910541L, "[0],[142307070910539],[142307070910541],", "", 100, 0, null, null, null, null }, { 142307070910545L, "wbgf_cq_cwb", null, null, null, null, false, "财务部", null, 142307070910541L, "[0],[142307070910539],[142307070910541],", "", 100, 0, null, null, null, null }, { 142307070910546L, "wbgf_cq_scb", null, null, null, null, false, "市场部二部", null, 142307070910544L, "[0],[142307070910539],[142307070910541],[142307070910544],", "", 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[,] { { 142307070910547L, "zjl", null, null, null, false, "总经理", "总经理", 100, 0, null, null, null }, { 142307070910548L, "fzjl", null, null, null, false, "副总经理", "副总经理", 101, 0, null, null, null }, { 142307070910549L, "bmjl", null, null, null, false, "部门经理", "部门经理", 102, 0, null, null, null }, { 142307070910550L, "gzry", null, null, null, false, "工作人员", "工作人员", 103, 0, null, null, null } }); migrationBuilder.InsertData( table: "sys_role", columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "DataScopeType", "IsDeleted", "Name", "Remark", "RoleType", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[] { 142307070910554L, "sys_manager_role", null, null, null, 1, false, "系统管理员", "系统管理员", 0, 100, 0, null, null, null }); migrationBuilder.InsertData( table: "sys_role", columns: new[] { "Id", "Code", "CreatedTime", "CreatedUserId", "CreatedUserName", "DataScopeType", "IsDeleted", "Name", "Remark", "RoleType", "Sort", "Status", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 356094617575493L, "admin", null, null, null, 1, false, "管理员", "", 0, 100, 0, null, null, null }, { 358509609758789L, "ware", null, null, null, 1, false, "仓库用户", "", 0, 100, 0, null, null, null }, { 358536344862789L, "iWare", null, null, null, 5, false, "研发用户", "", 0, 100, 0, null, null, null } }); migrationBuilder.InsertData( table: "sys_timer", columns: new[] { "Id", "CreatedTime", "CreatedUserId", "CreatedUserName", "Cron", "DoOnce", "ExecuteType", "Headers", "Interval", "IsDeleted", "JobName", "Remark", "RequestParameters", "RequestType", "RequestUrl", "StartNow", "TimerType", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[] { 142307070910556L, null, null, null, null, false, 1, null, 5, false, "百度api", "接口API", null, 2, "https://www.baidu.com", false, 0, 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[,] { { 142307070910551L, "superAdmin", 1, null, new DateTimeOffset(new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, null, null, "超级管理员", "superAdmin", "e10adc3949ba59abbe56e057f20f883e", "18020030720", 1, 0, null, null, null, null }, { 142307070910552L, "admin", 2, null, new DateTimeOffset(new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, null, null, "系统管理员", "admin", "e10adc3949ba59abbe56e057f20f883e", "18020030720", 1, 0, null, null, null, null }, { 358533464608837L, "warehouse", 3, null, new DateTimeOffset(new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, null, null, "仓库用户", "warehouse", "e10adc3949ba59abbe56e057f20f883e", "13869156666", 1, 0, null, null, null, null }, { 358536045723717L, "admin1", 3, null, new DateTimeOffset(new DateTime(1986, 7, 26, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), null, null, null, null, false, null, null, "研发部", "admin1", "f379eaf3c831b04de153469d1bec345e", "13869156666", 1, 0, null, null, null, null } }); migrationBuilder.InsertData( table: "wms_area", columns: new[] { "Id", "AreaDesc", "AreaName", "AreaStatus", "AreaType", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 355701739634757L, "", "A区", 0, 2, null, null, null, false, null, null, null }, { 358851237277765L, "", "B区", 0, 1, null, null, null, false, null, null, null }, { 358851309400133L, "", "C区", 0, 3, null, null, null, false, null, null, null } }); migrationBuilder.InsertData( table: "wms_container", columns: new[] { "Id", "ContainerCode", "ContainerStatus", "ContainerType", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "LimitHeight", "LimitLength", "LimitWidth", "MaxWeight", "ParentContainerId", "SpecHeight", "SpecLength", "SpecWidth", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 358852634767429L, "TM00001", 1, 3, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null }, { 358852767887429L, "TM00002", 2, 3, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null }, { 358852831047749L, "TM00003", 3, 1, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null }, { 358853016055877L, "TM00004", 3, 1, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null }, { 358853070798917L, "TM00005", 3, 2, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null }, { 358853146058821L, "TM00006", 1, 2, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null }, { 358853199671365L, "TM00007", 1, 0, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null }, { 358853255102533L, "TM00008", 1, 3, null, null, null, false, 1m, 1m, 1m, 1m, 0L, 1m, 1m, 1m, null, null, null } }); migrationBuilder.InsertData( table: "wms_containerplace", columns: new[] { "Id", "ContainerCode", "ContainerId", "ContainerPlaceStatus", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "PlaceCode", "PlaceId", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "WmsContainerId", "WmsPlaceId" }, values: new object[,] { { 358853586010181L, "TM00001", 358852634767429L, 2, null, null, null, false, "1-1-1-1-1", 358852152045637L, null, null, null, null, null }, { 358856088039493L, "TM00001", 358852634767429L, 2, null, null, null, false, "1-1-1-2-1", 358852152119365L, null, null, null, null, null }, { 358856888660037L, "TM00002", 358852767887429L, 2, null, null, null, false, "1-1-1-1-1", 358852152045637L, null, null, null, null, null }, { 358857243414597L, "TM00003", 358852831047749L, 0, null, null, null, false, "1-1-1-5-1", 358852152156229L, null, null, null, null, null }, { 358857693601867L, "TM00004", 358853016055877L, 0, null, null, null, false, "1-1-1-1-1", 358852152045637L, null, null, null, null, null }, { 358858262188101L, "TM00005", 358853070798917L, 0, null, null, null, false, "1-1-1-4-1", 358852152143941L, null, null, null, null, null } }); migrationBuilder.InsertData( table: "wms_material", columns: new[] { "Id", "CreatedTime", "CreatedUserId", "CreatedUserName", "Description", "ErpNo", "GraphNo", "InspectionMethod", "IsDeleted", "Keymaterials", "MaterialBatch", "MaterialName", "MaterialNo", "MaterialSpec", "MaterialType", "MaxImumqty", "MaxstorageAge", "MinstorageAge", "Qccategory", "Safeqty", "UnitNo", "UnitType", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Warranty" }, values: new object[,] { { 355707111780421L, null, null, null, null, null, null, 1, false, 0, "3570100022", "LAPP动力电缆", "3570100022", "OLFLEX CLASSIC 110 5G6", 1, 100m, 1m, 1m, null, 100m, 1, 1, null, null, null, 100m }, { 358845906632773L, null, null, null, null, null, null, 1, false, 0, "3070400120", "气动拧松枪", "3070400120", "16SUP PRO", 1, 100m, 1m, 1m, null, 100m, 1, 1, null, null, null, 10m }, { 358847125188677L, null, null, null, null, null, null, 1, false, 0, "3110800160", "定位销", "3110800160", "YDL31-D8-P12-L18-B8-X", 2, 1m, 1m, 1m, null, 100m, 1, 1, null, null, null, 1m }, { 358847583273029L, null, null, null, null, null, null, 2, false, 0, "3090200565", "防爆传感器", "3090200565", "BND-JA12GT4-24PH-25M-TL", 3, 1m, 1m, 1m, null, 1m, 2, 2, null, null, null, 1m }, { 358847917588549L, null, null, null, null, null, null, 2, false, 1, "2200074125", "套筒收纳盒安装板", "2200074125", "4301015-40-110-04-01", 3, 1m, 1m, 1m, null, 100m, 1, 1, null, null, null, 1m }, { 358848226168901L, null, null, null, null, null, null, 1, false, 0, "2200074102", "传感器安装支架", "2200074102", "40488-020-D086", 2, 1m, 1m, 1m, null, 100m, 2, 2, null, null, null, 100m }, { 358851158249541L, null, null, null, null, null, null, 2, false, 1, "1222202451", "电机", "1222202451", "LA21038-020.01-01.10", 3, 100m, 1m, 1m, null, 100m, 2, 2, null, null, null, 1m } }); migrationBuilder.InsertData( table: "wms_materialstock", columns: new[] { "Id", "AreaId", "ContainerCode", "CreatedTime", "CreatedUserId", "CreatedUserName", "InspectionMethod", "IsDeleted", "MaterialBatch", "MaterialName", "MaterialNo", "MaterialSpec", "MaterialType", "PlaceCode", "StockNumber", "UnitNo", "UnitType", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 358853586690117L, 0L, "TM00001", null, null, null, 1, false, "N/A", "N/A", "N/A", "N/A", 4, "N/A", 0m, 2, 2, null, null, null }, { 358856888787013L, 0L, "TM00002", null, null, null, 1, false, "3070400120", "气动拧松枪", "3070400120", "16SUP PRO", 1, "N/A", 0m, 1, 1, null, null, null }, { 358857243504709L, 355701739634757L, "TM00003", null, null, null, 1, false, "N/A", "N/A", "N/A", "N/A", 4, "1-1-1-5-1", 1m, 2, 2, null, null, null }, { 358857693638725L, 355701739634757L, "TM00004", null, null, null, 1, false, "3070400120", "气动拧松枪", "3070400120", "16SUP PRO", 1, "1-1-1-1-1", 100m, 1, 1, null, null, null }, { 358857693646917L, 355701739634757L, "TM00004", null, null, null, 1, false, "3110800160", "定位销", "3110800160", "YDL31-D8-P12-L18-B8-X", 2, "1-1-1-1-1", 100m, 1, 1, null, null, null }, { 358858262392901L, 355701739634757L, "TM00005", null, null, null, 2, false, "1222202451", "电机", "1222202451", "LA21038-020.01-01.10", 3, "1-1-1-4-1", 10m, 2, 2, null, null, null }, { 358858262401093L, 355701739634757L, "TM00005", null, null, null, 1, false, "2200074102", "传感器安装支架", "2200074102", "40488-020-D086", 2, "1-1-1-4-1", 1m, 2, 2, null, null, null }, { 358858262409285L, 355701739634757L, "TM00005", null, null, null, 2, false, "2200074125", "套筒收纳盒安装板", "2200074125", "4301015-40-110-04-01", 3, "1-1-1-4-1", 10m, 1, 1, null, null, null } }); migrationBuilder.InsertData( table: "wms_task", columns: new[] { "Id", "Aisle", "AreaName", "ContainerCode", "CreatedTime", "CreatedUserId", "CreatedUserName", "DodeviceId", "DodevicenodeId", "Dodevicetype", "IsDeleted", "OrderNo", "SendTimes", "SourcePlace", "TaskLevel", "TaskModel", "TaskNo", "TaskStatus", "TaskType", "ToPlace", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 358853585506373L, 1, "A区", "TM00001", null, null, null, 0, null, null, false, "N/A", 0, "N/A", 1, 1, "358853585506374", 3, 1, "1-1-1-1-1", null, null, null }, { 358856088019013L, 1, "A区", "TM00001", null, null, null, 0, null, null, false, "N/A", 0, "1-1-1-1-1", 1, 1, "358856088019014", 3, 3, "1-1-1-2-1", null, null, null } }); migrationBuilder.InsertData( table: "wms_task", columns: new[] { "Id", "Aisle", "AreaName", "ContainerCode", "CreatedTime", "CreatedUserId", "CreatedUserName", "DodeviceId", "DodevicenodeId", "Dodevicetype", "IsDeleted", "OrderNo", "SendTimes", "SourcePlace", "TaskLevel", "TaskModel", "TaskNo", "TaskStatus", "TaskType", "ToPlace", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 358856349995077L, 1, "A区", "TM00001", null, null, null, 0, null, null, false, "N/A", 0, "1-1-1-2-1", 1, 1, "358856349995078", 3, 2, "N/A", null, null, null }, { 358856845733957L, 1, "A区", "TM00002", null, null, null, 0, null, null, false, "358856845353029", 0, "100", 1, 2, "358856845733958", 3, 1, "1-1-1-1-1", null, null, null }, { 358856980553799L, 1, "A区", "TM00002", null, null, null, 0, null, null, false, "358856980553798", 0, "1-1-1-1-1", 1, 2, "358856980553800", 3, 2, "101", null, null, null }, { 358857243410501L, 1, "A区", "TM00003", null, null, null, 0, null, null, false, "N/A", 0, "N/A", 1, 1, "358857243410502", 3, 1, "1-1-1-5-1", null, null, null }, { 358857618247749L, 1, "A区", "TM00004", null, null, null, 0, null, null, false, "358857618075717", 0, "101", 1, 2, "358857618247750", 3, 1, "1-1-1-1-1", null, null, null }, { 358858262179909L, 1, "A区", "TM00005", null, null, null, 0, null, null, false, "358858261872712", 0, "N/A", 1, 1, "358858262179910", 3, 1, "1-1-1-4-1", 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[,] { { 142307070902375L, "1", null, null, null, false, "男性", 100, 0, 142307070906484L, null, null, null, "男" }, { 142307070902376L, "2", null, null, null, false, "女性", 100, 0, 142307070906484L, null, null, null, "女" }, { 142307070902377L, "3", null, null, null, false, "未知性别", 100, 0, 142307070906484L, null, null, null, "未知" }, { 142307070902384L, "0", null, null, null, false, "正常", 100, 0, 142307070906483L, null, null, null, "正常" }, { 142307070902385L, "1", null, null, null, false, "停用", 100, 0, 142307070906483L, null, null, null, "停用" }, { 142307070902386L, "2", null, null, null, false, "删除", 100, 0, 142307070906483L, null, null, null, "删除" }, { 142307070902387L, "N", null, null, null, false, "否", 100, 0, 142307070906486L, null, null, null, "否" }, { 142307070902388L, "Y", null, null, null, false, "是", 100, 0, 142307070906486L, null, null, null, "是" }, { 142307070902389L, "1", null, null, null, false, "登录", 100, 0, 142307070906487L, null, null, null, "登录" }, { 142307070902390L, "2", null, null, null, false, "登出", 100, 0, 142307070906487L, null, null, null, "登出" }, { 142307070902391L, "0", null, null, null, false, "目录", 100, 0, 142307070906488L, null, null, null, "目录" }, { 142307070902392L, "1", null, null, null, false, "菜单", 100, 0, 142307070906488L, null, null, null, "菜单" }, { 142307070902393L, "2", null, null, null, false, "按钮", 100, 0, 142307070906488L, null, null, null, "按钮" }, { 142307070902394L, "0", null, null, null, false, "未发送", 100, 0, 142307070906489L, null, null, null, "未发送" }, { 142307070902395L, "1", null, null, null, false, "发送成功", 100, 0, 142307070906489L, null, null, null, "发送成功" }, { 142307070902396L, "2", null, null, null, false, "发送失败", 100, 0, 142307070906489L, null, null, null, "发送失败" }, { 142307070902397L, "3", null, null, null, false, "失效", 100, 0, 142307070906489L, null, null, null, "失效" }, { 142307070902398L, "0", null, null, null, false, "无", 100, 0, 142307070906490L, null, null, null, "无" }, { 142307070902399L, "1", null, null, null, false, "组件", 100, 0, 142307070906490L, null, null, null, "组件" }, { 142307070906437L, "2", null, null, null, false, "内链", 100, 0, 142307070906490L, null, null, null, "内链" }, { 142307070906438L, "3", null, null, null, false, "外链", 100, 0, 142307070906490L, null, null, null, "外链" }, { 142307070906439L, "1", null, null, null, false, "系统权重", 100, 0, 142307070906491L, null, null, null, "系统权重" }, { 142307070906440L, "2", null, null, null, false, "业务权重", 100, 0, 142307070906491L, null, null, null, "业务权重" }, { 142307070906441L, "1", null, null, null, false, "全部数据", 100, 0, 142307070906492L, null, null, null, "全部数据" }, { 142307070906442L, "2", null, null, null, false, "本部门及以下数据", 100, 0, 142307070906492L, null, null, null, "本部门及以下数据" }, { 142307070906443L, "3", null, null, null, false, "本部门数据", 100, 0, 142307070906492L, null, null, null, "本部门数据" }, { 142307070906444L, "4", null, null, null, false, "仅本人数据", 100, 0, 142307070906492L, null, null, null, "仅本人数据" }, { 142307070906445L, "5", null, null, null, false, "自定义数据", 100, 0, 142307070906492L, null, null, null, "自定义数据" }, { 142307070906449L, "0", null, null, null, false, "其它", 100, 0, 142307070906494L, null, null, null, "其它" }, { 142307070906450L, "1", null, null, null, false, "增加", 100, 0, 142307070906494L, null, null, null, "增加" }, { 142307070906451L, "2", null, null, null, false, "删除", 100, 0, 142307070906494L, null, null, null, "删除" }, { 142307070906452L, "3", null, null, null, false, "编辑", 100, 0, 142307070906494L, null, null, null, "编辑" }, { 142307070906453L, "4", null, null, null, false, "更新", 100, 0, 142307070906494L, null, null, null, "更新" }, { 142307070906454L, "5", null, null, null, false, "查询", 100, 0, 142307070906494L, null, null, null, "查询" }, { 142307070906455L, "6", null, null, null, false, "详情", 100, 0, 142307070906494L, null, null, null, "详情" }, { 142307070906456L, "7", null, null, null, false, "树", 100, 0, 142307070906494L, null, null, null, "树" }, { 142307070906457L, "8", null, null, null, false, "导入", 100, 0, 142307070906494L, null, null, null, "导入" }, { 142307070906458L, "9", null, null, null, false, "导出", 100, 0, 142307070906494L, null, null, null, "导出" }, { 142307070906459L, "10", null, null, null, false, "授权", 100, 0, 142307070906494L, null, null, null, "授权" }, { 142307070906460L, "11", null, null, null, false, "强退", 100, 0, 142307070906494L, null, null, null, "强退" }, { 142307070906461L, "12", null, null, null, false, "清空", 100, 0, 142307070906494L, null, null, null, "清空" }, { 142307070906462L, "13", null, null, null, false, "修改状态", 100, 0, 142307070906494L, 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[,] { { 142307070906463L, "1", null, null, null, false, "阿里云", 100, 0, 142307070906495L, null, null, null, "阿里云" }, { 142307070906464L, "2", null, null, null, false, "腾讯云", 100, 0, 142307070906495L, null, null, null, "腾讯云" }, { 142307070906465L, "3", null, null, null, false, "minio", 100, 0, 142307070906495L, null, null, null, "minio" }, { 142307070906466L, "4", null, null, null, false, "本地", 100, 0, 142307070906495L, null, null, null, "本地" }, { 142307070906467L, "1", null, null, null, false, "运行", 100, 0, 142307070910533L, null, null, null, "运行" }, { 142307070906468L, "2", null, null, null, false, "停止", 100, 0, 142307070910533L, null, null, null, "停止" }, { 142307070906469L, "1", null, null, null, false, "通知", 100, 0, 142307070910534L, null, null, null, "通知" }, { 142307070906470L, "2", null, null, null, false, "公告", 100, 0, 142307070910534L, null, null, null, "公告" }, { 142307070906471L, "0", null, null, null, false, "草稿", 100, 0, 142307070910535L, null, null, null, "草稿" }, { 142307070906472L, "1", null, null, null, false, "发布", 100, 0, 142307070910535L, null, null, null, "发布" }, { 142307070906473L, "2", null, null, null, false, "撤回", 100, 0, 142307070910535L, null, null, null, "撤回" }, { 142307070906474L, "3", null, null, null, false, "删除", 100, 0, 142307070910535L, null, null, null, "删除" }, { 142307070906475L, "true", null, null, null, false, "是", 100, 0, 142307070910536L, null, null, null, "是" }, { 142307070906476L, "false", null, null, null, false, "否", 100, 0, 142307070910536L, null, null, null, "否" }, { 142307070906477L, "1", null, null, null, false, "下载压缩包", 100, 0, 142307070910537L, null, null, null, "下载压缩包" }, { 142307070906478L, "2", null, null, null, false, "生成到本项目", 100, 0, 142307070910537L, null, null, null, "生成到本项目" }, { 142307070906479L, "1", null, null, null, false, "GET", 100, 0, 142307070910538L, null, null, null, "GET" }, { 142307070906480L, "2", null, null, null, false, "POST", 100, 0, 142307070910538L, null, null, null, "POST" }, { 142307070906481L, "3", null, null, null, false, "PUT", 100, 0, 142307070910538L, null, null, null, "PUT" }, { 142307070906482L, "4", null, null, null, false, "DELETE", 100, 0, 142307070910538L, null, null, null, "DELETE" }, { 142307070922829L, "fk", null, null, null, false, "外键", 100, 0, 142307070922827L, null, null, null, "外键" }, { 142307070922830L, "input", null, null, null, false, "输入框", 100, 0, 142307070922827L, null, null, null, "输入框" }, { 142307070922831L, "datepicker", null, null, null, false, "时间选择", 100, 0, 142307070922827L, null, null, null, "时间选择" }, { 142307070922832L, "select", null, null, null, false, "下拉框", 100, 0, 142307070922827L, null, null, null, "下拉框" }, { 142307070922833L, "radio", null, null, null, false, "单选框", 100, 0, 142307070922827L, null, null, null, "单选框" }, { 142307070922834L, "switch", null, null, null, false, "开关", 100, 0, 142307070922827L, null, null, null, "开关" }, { 142307070922835L, "checkbox", null, null, null, false, "多选框", 100, 0, 142307070922827L, null, null, null, "多选框" }, { 142307070922836L, "inputnumber", null, null, null, false, "数字输入框", 100, 0, 142307070922827L, null, null, null, "数字输入框" }, { 142307070922837L, "textarea", null, null, null, false, "文本域", 100, 0, 142307070922827L, null, null, null, "文本域" }, { 142307070922838L, "==", null, null, null, false, "等于", 1, 0, 142307070922828L, null, null, null, "等于" }, { 142307070922839L, "like", null, null, null, false, "模糊", 2, 0, 142307070922828L, null, null, null, "模糊" }, { 142307070922840L, ">", null, null, null, false, "大于", 3, 0, 142307070922828L, null, null, null, "大于" }, { 142307070922841L, "<", null, null, null, false, "小于", 4, 0, 142307070922828L, null, null, null, "小于" }, { 142307070922842L, "!=", null, null, null, false, "不等于", 5, 0, 142307070922828L, null, null, null, "不等于" }, { 142307070922843L, ">=", null, null, null, false, "大于等于", 6, 0, 142307070922828L, null, null, null, "大于等于" }, { 142307070922844L, "<=", null, null, null, false, "小于等于", 7, 0, 142307070922828L, null, null, null, "小于等于" }, { 142307070922845L, "isNotNull", null, null, null, false, "不为空", 8, 0, 142307070922828L, null, null, null, "不为空" }, { 142307070922846L, "long", null, null, null, false, "long", 100, 0, 142307070922829L, null, null, null, "long" }, { 142307070922847L, "string", null, null, null, false, "string", 100, 0, 142307070922829L, null, null, null, "string" }, { 142307070922848L, "DateTime", null, null, null, false, "DateTime", 100, 0, 142307070922829L, null, null, null, "DateTime" }, { 142307070922850L, "bool", null, null, null, false, "bool", 100, 0, 142307070922829L, null, null, null, "bool" }, { 142307070922851L, "int", null, null, null, false, "int", 100, 0, 142307070922829L, null, null, null, "int" } }); 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[,] { { 142307070922852L, "double", null, null, null, false, "double", 100, 0, 142307070922829L, null, null, null, "double" }, { 142307070922861L, "float", null, null, null, false, "float", 100, 0, 142307070922829L, null, null, null, "float" }, { 142307070922862L, "decimal", null, null, null, false, "decimal", 100, 0, 142307070922829L, null, null, null, "decimal" }, { 142307070922863L, "Guid", null, null, null, false, "Guid", 100, 0, 142307070922829L, null, null, null, "Guid" }, { 142307070922864L, "DateTimeOffset", null, null, null, false, "DateTimeOffset", 100, 0, 142307070922829L, null, null, null, "DateTimeOffset" }, { 142307070926943L, "0", null, null, null, false, "集团角色", 100, 0, 142307070926941L, null, null, null, "集团角色" }, { 142307070926944L, "1", null, null, null, false, "加盟商角色", 100, 0, 142307070926941L, null, null, null, "加盟商角色" }, { 142307070926945L, "2", null, null, null, false, "门店角色", 100, 0, 142307070926941L, null, null, null, "门店角色" }, { 142307070926946L, "1", null, null, null, false, "一级", 100, 0, 142307070926942L, null, null, null, "一级" }, { 142307070926947L, "2", null, null, null, false, "二级", 100, 0, 142307070926942L, null, null, null, "二级" }, { 142307070926948L, "3", null, null, null, false, "三级", 100, 0, 142307070926942L, null, null, null, "三级" }, { 142307070926949L, "4", null, null, null, false, "四级", 100, 0, 142307070926942L, null, null, null, "四级" }, { 285605336563781L, "DefaultFormType", null, null, null, false, "默认表单分类", 100, 0, 285605149831237L, null, null, null, "默认表单分类" }, { 285641495289925L, "DefaultGroup", null, null, null, false, "默认分类", 100, 0, 285641358889029L, null, null, null, "默认分类" }, { 355697634480197L, "0", null, null, null, false, "", 100, 0, 355694205325381L, null, null, null, "其他" }, { 355697676427333L, "1", null, null, null, false, "", 100, 0, 355694205325381L, null, null, null, "木质" }, { 355697726726213L, "2", null, null, null, false, "", 100, 0, 355694205325381L, null, null, null, "金属" }, { 355697755361349L, "3", null, null, null, false, "", 100, 0, 355694205325381L, null, null, null, "塑料" }, { 355697944657989L, "0", null, null, null, false, "", 100, 0, 355697881423941L, null, null, null, "禁用" }, { 355697974415429L, "1", null, null, null, false, "", 100, 0, 355697881423941L, null, null, null, "空闲" }, { 355698005966917L, "2", null, null, null, false, "", 100, 0, 355697881423941L, null, null, null, "组盘" }, { 355698032828485L, "3", null, null, null, false, "", 100, 0, 355697881423941L, null, null, null, "库位" }, { 355698270015557L, "0", null, null, null, false, "", 100, 0, 355698224758853L, null, null, null, "其他" }, { 355698303508549L, "1", null, null, null, false, "", 100, 0, 355698224758853L, null, null, null, "立体库" }, { 355698328531013L, "2", null, null, null, false, "", 100, 0, 355698224758853L, null, null, null, "普通库" }, { 355698362712133L, "3", null, null, null, false, "", 100, 0, 355698224758853L, null, null, null, "公共库" }, { 355698476777541L, "1", null, null, null, false, "", 100, 0, 355698441912389L, null, null, null, "空闲" }, { 355698510786629L, "2", null, null, null, false, "", 100, 0, 355698441912389L, null, null, null, "待入" }, { 355698549424197L, "3", null, null, null, false, "", 100, 0, 355698441912389L, null, null, null, "存货" }, { 355698576941125L, "4", null, null, null, false, "", 100, 0, 355698441912389L, null, null, null, "待出" }, { 355698694561861L, "1", null, null, null, false, "", 100, 0, 355698661130309L, null, null, null, "低" }, { 355698716401733L, "2", null, null, null, false, "", 100, 0, 355698661130309L, null, null, null, "中" }, { 355698740326469L, "3", null, null, null, false, "", 100, 0, 355698661130309L, null, null, null, "高" }, { 355698898735173L, "1", null, null, null, false, "", 100, 0, 355698855280709L, null, null, null, "免检" }, { 355698924970053L, "2", null, null, null, false, "", 100, 0, 355698855280709L, null, null, null, "抽检" }, { 355699041800261L, "1", null, null, null, false, "", 100, 0, 355699003580485L, null, null, null, "原材料" }, { 355699063255109L, "2", null, null, null, false, "", 100, 0, 355699003580485L, null, null, null, "半成品" }, { 355699088330821L, "3", null, null, null, false, "", 100, 0, 355699003580485L, null, null, null, "成品" }, { 355699113156677L, "4", null, null, null, false, "", 100, 0, 355699003580485L, null, null, null, "空托" }, { 355699219353669L, "1", null, null, null, false, "", 100, 0, 355699189051461L, null, null, null, "长度" }, { 355699243540549L, "2", null, null, null, false, "", 100, 0, 355699189051461L, null, null, null, "重量" }, { 355699345645637L, "1", null, null, null, false, "", 100, 0, 355699314061381L, null, null, null, "cm" } }); 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[,] { { 355699367575621L, "2", null, null, null, false, "", 100, 0, 355699314061381L, null, null, null, "t" }, { 355699479236677L, "1", null, null, null, false, "", 100, 0, 355699447029829L, null, null, null, "手动" }, { 355699505229893L, "2", null, null, null, false, "", 100, 0, 355699447029829L, null, null, null, "自动" }, { 355699615133765L, "1", null, null, null, false, "", 100, 0, 355699576467525L, null, null, null, "入库" }, { 355699638476869L, "2", null, null, null, false, "", 100, 0, 355699576467525L, null, null, null, "出库" }, { 355699661889605L, "3", null, null, null, false, "", 100, 0, 355699576467525L, null, null, null, "移库" }, { 355699760455749L, "1", null, null, null, false, "", 100, 0, 355699731099717L, null, null, null, "未执行" }, { 355699784736837L, "2", null, null, null, false, "", 100, 0, 355699731099717L, null, null, null, "执行中" }, { 355699813859397L, "3", null, null, null, false, "", 100, 0, 355699731099717L, null, null, null, "完成" } }); migrationBuilder.InsertData( table: "sys_emp_ext_org_pos", columns: new[] { "SysEmpId", "SysOrgId", "SysPosId" }, values: new object[,] { { 142307070910551L, 142307070910539L, 142307070910547L }, { 142307070910551L, 142307070910540L, 142307070910548L }, { 142307070910551L, 142307070910541L, 142307070910549L }, { 142307070910551L, 142307070910542L, 142307070910550L }, { 142307070910553L, 142307070910542L, 142307070910547L } }); migrationBuilder.InsertData( table: "sys_emp_pos", columns: new[] { "SysEmpId", "SysPosId" }, values: new object[,] { { 142307070910551L, 142307070910547L }, { 142307070910551L, 142307070910548L }, { 142307070910552L, 142307070910549L }, { 142307070910553L, 142307070910547L }, { 358533464608837L, 142307070910550L }, { 358536045723717L, 142307070910550L } }); migrationBuilder.InsertData( table: "sys_user_data_scope", columns: new[] { "SysOrgId", "SysUserId" }, values: new object[] { 142307070910540L, 142307070910551L }); migrationBuilder.InsertData( table: "sys_user_role", columns: new[] { "SysRoleId", "SysUserId" }, values: new object[] { 142307070910554L, 142307070910552L }); migrationBuilder.InsertData( table: "wms_materialcontainer", columns: new[] { "Id", "BindQuantity", "BindStatus", "ContainerCode", "ContainerId", "CreatedTime", "CreatedUserId", "CreatedUserName", "IsDeleted", "MaterialBatch", "MaterialId", "MaterialName", "MaterialNo", "MaterialSpec", "OrderNo", "SampleQty", "UpdatedTime", "UpdatedUserId", "UpdatedUserName" }, values: new object[,] { { 358856845353031L, 100m, 2, "TM00002", 358852767887429L, null, null, null, false, "3070400120", 358845906632773L, "气动拧松枪", "3070400120", "16SUP PRO", "358856845353029", 0m, null, null, null }, { 358856980582469L, 100m, 1, "TM00002", 358852767887429L, null, null, null, false, "3070400120", 358845906632773L, "气动拧松枪", "3070400120", "16SUP PRO", "358856980553798", 0m, null, null, null }, { 358857030975557L, 100m, 0, "TM00002", 358852767887429L, null, null, null, false, "3070400120", 358845906632773L, "气动拧松枪", "3070400120", "16SUP PRO", "358857030971461", 0m, null, null, null }, { 358857618075719L, 100m, 0, "TM00004", 358853016055877L, null, null, null, false, "3070400120", 358845906632773L, "气动拧松枪", "3070400120", "16SUP PRO", "358857618075717", 0m, null, null, null }, { 358857618153542L, 100m, 0, "TM00004", 358853016055877L, null, null, null, false, "3110800160", 358847125188677L, "定位销", "3110800160", "YDL31-D8-P12-L18-B8-X", "358857618075717", 0m, null, null, null }, { 358858261872714L, 10m, 0, "TM00005", 358853070798917L, null, null, null, false, "1222202451", 358851158249541L, "电机", "1222202451", "LA21038-020.01-01.10", "358858261872712", 0m, null, null, null }, { 358858262044742L, 1m, 0, "TM00005", 358853070798917L, null, null, null, false, "2200074102", 358848226168901L, "传感器安装支架", "2200074102", "40488-020-D086", "358858261872712", 0m, null, null, null }, { 358858262089798L, 10m, 0, "TM00005", 358853070798917L, null, null, null, false, "2200074125", 358847917588549L, "套筒收纳盒安装板", "2200074125", "4301015-40-110-04-01", "358858261872712", 0m, null, null, null } }); migrationBuilder.InsertData( table: "wms_place", columns: new[] { "Id", "Aisle", "AreaId", "ColumnNo", "CreatedTime", "CreatedUserId", "CreatedUserName", "DeepcellNo", "EmptyContainer", "Height", "HeightLevel", "IsDeleted", "Islock", "LayerNo", "Length", "Line", "MaxWeight", "PlaceCode", "PlaceStatus", "PositionnoForSrm", "Priority", "RowNo", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Width", "Xzb", "Yzb", "Zzb" }, values: new object[,] { { 358852152045637L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-1-1-1", 3, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152119365L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-1-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152131653L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-1-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152143941L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-1-4-1", 3, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152156229L, 1, 355701739634757L, 1, null, null, null, 1, 1, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-1-5-1", 3, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152164421L, 1, 355701739634757L, 1, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-1-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152172613L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-2-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152180805L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-2-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152193093L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-2-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152205381L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-2-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152217669L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-2-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152229957L, 1, 355701739634757L, 2, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-2-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null } }); migrationBuilder.InsertData( table: "wms_place", columns: new[] { "Id", "Aisle", "AreaId", "ColumnNo", "CreatedTime", "CreatedUserId", "CreatedUserName", "DeepcellNo", "EmptyContainer", "Height", "HeightLevel", "IsDeleted", "Islock", "LayerNo", "Length", "Line", "MaxWeight", "PlaceCode", "PlaceStatus", "PositionnoForSrm", "Priority", "RowNo", "UpdatedTime", "UpdatedUserId", "UpdatedUserName", "Width", "Xzb", "Yzb", "Zzb" }, values: new object[,] { { 358852152238149L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-3-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152246341L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 1, 2, 1.2m, 0, 2.8m, "1-1-3-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152258629L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-3-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152266821L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-3-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152283205L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-3-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152295493L, 1, 355701739634757L, 3, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-3-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152307781L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-4-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152315973L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-4-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152328261L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-4-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152336453L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-4-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152344645L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-4-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152356933L, 1, 355701739634757L, 4, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-4-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152365125L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-5-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152373317L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-5-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152381509L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-5-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152393797L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-5-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152401989L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-5-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152410181L, 1, 355701739634757L, 5, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-5-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152422469L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-6-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152430661L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-6-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152442949L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-6-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152451141L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-6-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152463429L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-6-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152471621L, 1, 355701739634757L, 6, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-6-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152479813L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-7-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152496197L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-7-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152504389L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-7-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152516677L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-7-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152524869L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-7-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152610885L, 1, 355701739634757L, 7, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-7-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152623173L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 1, 1.2m, 0, 2.8m, "1-1-8-1-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152631365L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 2, 1.2m, 0, 2.8m, "1-1-8-2-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152639557L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 3, 1.2m, 0, 2.8m, "1-1-8-3-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152651845L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 4, 1.2m, 0, 2.8m, "1-1-8-4-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152660037L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 5, 1.2m, 0, 2.8m, "1-1-8-5-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null }, { 358852152668229L, 1, 355701739634757L, 8, null, null, null, 1, 0, 1.8m, 1, false, 0, 6, 1.2m, 0, 2.8m, "1-1-8-6-1", 1, null, 0, 1, null, null, null, 1.5m, null, null, null } }); 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_low_code_module_database_SysLowCodeId", table: "sys_low_code_module_database", column: "SysLowCodeId"); 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_data_scope_SysOrgId", table: "sys_user_data_scope", column: "SysOrgId"); migrationBuilder.CreateIndex( name: "IX_sys_user_role_SysRoleId", table: "sys_user_role", column: "SysRoleId"); migrationBuilder.CreateIndex( name: "IX_wms_containerplace_WmsContainerId", table: "wms_containerplace", column: "WmsContainerId"); migrationBuilder.CreateIndex( name: "IX_wms_containerplace_WmsPlaceId", table: "wms_containerplace", column: "WmsPlaceId"); migrationBuilder.CreateIndex( name: "IX_wms_materialcontainer_ContainerId", table: "wms_materialcontainer", column: "ContainerId"); migrationBuilder.CreateIndex( name: "IX_wms_materialcontainer_MaterialId", table: "wms_materialcontainer", column: "MaterialId"); migrationBuilder.CreateIndex( name: "IX_wms_place_AreaId", table: "wms_place", column: "AreaId"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "sys_app"); migrationBuilder.DropTable( name: "sys_code_gen"); migrationBuilder.DropTable( name: "sys_code_gen_config"); migrationBuilder.DropTable( name: "sys_code_modular"); 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_forms"); migrationBuilder.DropTable( name: "sys_log_audit"); migrationBuilder.DropTable( name: "sys_log_ex"); migrationBuilder.DropTable( name: "sys_log_op"); migrationBuilder.DropTable( name: "sys_log_vis"); migrationBuilder.DropTable( name: "sys_low_code_module_database"); migrationBuilder.DropTable( name: "sys_notice"); migrationBuilder.DropTable( name: "sys_notice_user"); migrationBuilder.DropTable( name: "sys_role_data_scope"); migrationBuilder.DropTable( name: "sys_role_menu"); migrationBuilder.DropTable( name: "sys_timer"); migrationBuilder.DropTable( name: "sys_user_data_scope"); migrationBuilder.DropTable( name: "sys_user_role"); migrationBuilder.DropTable( name: "wms_containerplace"); migrationBuilder.DropTable( name: "wms_materialcontainer"); migrationBuilder.DropTable( name: "wms_materialstock"); migrationBuilder.DropTable( name: "wms_task"); migrationBuilder.DropTable( name: "sys_dict_type"); migrationBuilder.DropTable( name: "sys_emp"); migrationBuilder.DropTable( name: "sys_pos"); migrationBuilder.DropTable( name: "sys_low_code_module"); migrationBuilder.DropTable( name: "sys_menu"); migrationBuilder.DropTable( name: "sys_org"); migrationBuilder.DropTable( name: "sys_role"); migrationBuilder.DropTable( name: "sys_user"); migrationBuilder.DropTable( name: "wms_place"); migrationBuilder.DropTable( name: "wms_container"); migrationBuilder.DropTable( name: "wms_material"); migrationBuilder.DropTable( name: "wms_area"); } } }