| | |
|---|
| | | columns: table => new |
|---|
| | | { |
|---|
| | | 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: "物料编码（唯一标识）") |
|---|
| | | MaterialNo = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "物料编码（唯一标识）") |
|---|
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
|---|
| | | MaterialName = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: false, comment: "物料名称") |
|---|
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
|---|
| | |
|---|
| | | column: "ContainerType"); |
|---|
| | | |
|---|
| | | migrationBuilder.CreateIndex( |
|---|
| | | name: "IX_scms_wmsmaterials_MaterialCode", |
|---|
| | | name: "IX_scms_wmsmaterials_MaterialNo", |
|---|
| | | table: "scms_wmsmaterials", |
|---|
| | | column: "MaterialCode", |
|---|
| | | column: "MaterialNo", |
|---|
| | | unique: true); |
|---|
| | | |
|---|
| | | migrationBuilder.CreateIndex( |
|---|
