ÎļþÃû´Ó Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508090853_InitialCreate4.cs ÐÞ¸Ä |
| | |
| | | |
| | | namespace CMS.Plugin.HIAWms.MySQL.Migrations |
| | | { |
| | | public partial class InitialCreate4 : Migration |
| | | public partial class InitialCreate5 : Migration |
| | | { |
| | | protected override void Up(MigrationBuilder migrationBuilder) |
| | | { |
| | |
| | | Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"), |
| | | MaterialCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "ç©æç¼ç ï¼å¯ä¸æ è¯ï¼") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | IsValid = table.Column<bool>(type: "tinyint(1)", nullable: false, comment: "æ¯å¦ææç©æ"), |
| | | IsSelfMade = table.Column<bool>(type: "tinyint(1)", nullable: true, comment: "æ°é"), |
| | | Num = table.Column<int>(type: "int", nullable: false, comment: "æ¯å¦ææç©æ"), |
| | | SelfNum = table.Column<int>(type: "int", nullable: true, comment: "èªææ°é"), |
| | | MaterialName = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: false, comment: "ç©æåç§°") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | NullLength = table.Column<decimal>(type: "decimal(65,30)", nullable: true), |
| | | PurchaseType = table.Column<int>(type: "int", nullable: false, comment: "éè´ç±»åï¼æä¸¾å¼ï¼"), |
| | | MaterialType = table.Column<int>(type: "int", nullable: false, comment: "ç©æç±»åï¼æä¸¾å¼ï¼"), |
| | | PrimaryUnit = table.Column<string>(type: "varchar(20)", maxLength: 20, nullable: true, comment: "主åä½ï¼å¦ï¼kgãmã个ï¼") |
| | |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | RedundantField3 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åä½å段3 - é¢çæ©å±ç¨é") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Sort = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "æåº"), |
| | | Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "夿³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, defaultValue: false, comment: "æ¯å¦ç¦ç¨"), |
| | | ExtraProperties = table.Column<string>(type: "longtext", nullable: true, comment: "æ©å±å±æ§") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true, comment: "å¹¶åæ³") |
| | |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | LastModifierName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "ä¿®æ¹äºº") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Sort = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "æåº"), |
| | | Remark = table.Column<string>(type: "varchar(500)", maxLength: 500, nullable: true, comment: "夿³¨") |
| | | OperationRemark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æä½å¤æ³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, defaultValue: false, comment: "æ¯å¦ç¦ç¨"), |
| | | DeleteRemark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å é¤å¤æ³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ExtraField1 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æ©å±å段1") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ExtraField2 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æ©å±å段2") |