using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace Admin.NET.Database.Migrations.Migrations { public partial class v101 : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "les_agv_task", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), TaskType = table.Column(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "任务类型-入库;出库"), StartPlace = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "起始位置"), StartName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "起始名称"), EndPlace = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "结束位置"), EndName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "结束名称"), AgvState = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "状态"), TransportOrder = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "当前执行的任务"), TaskNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "主任务号"), Pid = table.Column(type: "bigint", nullable: false, comment: "Agv父Id"), ContainerCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "容器编号"), WorkShopType = table.Column(type: "int", nullable: false, comment: "所属车间"), SourcePlaceName = 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_les_agv_task", x => x.Id); }, comment: "Agv任务表"); migrationBuilder.CreateTable( name: "les_agv_waring", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), Code = table.Column(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "唯一编码"), TransportOrder = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "任务号"), AgvCarCode = table.Column(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "agv小车编号"), FaultText = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "故障内容"), StartTime = table.Column(type: "datetimeoffset", maxLength: 50, nullable: true, comment: "故障时间"), YesOrNot = table.Column(type: "int", maxLength: 50, nullable: false, comment: "是否解决"), IsRead = table.Column(type: "bit", nullable: false, comment: "WCS是否可以读取"), WorkShopType = 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_les_agv_waring", x => x.Id); }, comment: "Agv报警"); migrationBuilder.CreateTable( name: "les_devicewaring", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), WcsId = table.Column(type: "int", nullable: false, comment: "WcsId"), DeviceName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "设备名称"), FaultName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "故障名称"), StartTime = table.Column(type: "datetimeoffset", nullable: true, comment: "发生时间"), EndTime = table.Column(type: "datetimeoffset", nullable: true, comment: "结束时间"), RunningTime = 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_les_devicewaring", x => x.Id); }, comment: "设备报警"); migrationBuilder.CreateTable( name: "les_packwarehouse", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), PackCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "标签码"), MaterialNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "物料码"), Long = table.Column(type: "int", nullable: false, comment: "长"), Wide = table.Column(type: "int", nullable: false, comment: "宽"), High = table.Column(type: "int", nullable: false, comment: "高"), OutputEntrance = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "出库口"), LesPackState = table.Column(type: "int", nullable: false, comment: "打包状态"), OrderNo = 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_les_packwarehouse", x => x.Id); }, comment: "打包表"); migrationBuilder.CreateTable( name: "les_serial_rule_detail", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), SerialType = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "序号类别"), ItemNo = table.Column(type: "int", nullable: false, comment: "项次"), SourceType = table.Column(type: "nvarchar(max)", nullable: true, comment: "资料来源"), SerialLength = table.Column(type: "int", nullable: false, comment: "长度"), SearchStart = table.Column(type: "int", nullable: false, comment: "撷取码数(起)"), DecimalType = table.Column(type: "int", nullable: false, comment: "进位类型"), UserDefine = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "使用者自定义"), SerialCodeFlag = table.Column(type: "int", nullable: false, comment: "序号编码"), Description = table.Column(type: "nvarchar(300)", maxLength: 300, nullable: true, comment: "说明"), SerialTypeNo = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "序号类别编号"), GetData = table.Column(type: "int", maxLength: 50, nullable: false, comment: "撷取"), PadLeft = 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_les_serial_rule_detail", x => x.Id); }, comment: "编号规则"); migrationBuilder.CreateTable( name: "les_station", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), ProductionlineId = table.Column(type: "bigint", nullable: false, comment: "产线Id"), Name = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "工位名称"), Code = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "工位编码"), Status = table.Column(type: "int", nullable: false, comment: "工位状态"), StataionStatus = table.Column(type: "int", nullable: false, comment: "运行状态"), ContainerCode = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true, comment: "库位编码"), PlaceSpec = 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_les_station", x => x.Id); }, comment: "工位表"); 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: "命名空间"), ModuleName = table.Column(type: "nvarchar(100)", maxLength: 100, nullable: true, comment: "模块路径"), FrontProName = 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: "是否通用字段"), ShowTitleMinWidth = 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_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: "状态"), EnumClassName = table.Column(type: "nvarchar(200)", maxLength: 200, 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_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_excel_template", columns: table => new { Id = table.Column(type: "bigint", nullable: false, comment: "Id主键"), Name = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "模板名称"), Version = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "版本"), AppName = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: false, comment: "所属应用"), ClassName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "类名"), TemplateFileName = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false, comment: "模板文件名称"), UnionUniqueFields = table.Column(type: "nvarchar(300)", maxLength: 300, nullable: false, comment: "唯一字段集"), HeadStartLine = table.Column(type: "int", nullable: false, comment: "表头开始行"), DataStartLine = table.Column(type: "int", nullable: false, 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_excel_template", x => x.Id); table.UniqueConstraint("AK_sys_excel_template_ClassName_Version_AppName", x => new { x.ClassName, x.Version, x.AppName }); }, comment: "Excel模板"); 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: "命名空间"), ModuleName = 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