82 lines
2.4 KiB
C#
82 lines
2.4 KiB
C#
using System;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
#nullable disable
|
|
|
|
namespace ProjecThing.Migrations
|
|
{
|
|
public partial class _11 : Migration
|
|
{
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.AddColumn<string>(
|
|
name: "BuyersOrderNumber",
|
|
table: "Projects",
|
|
type: "longtext",
|
|
nullable: true)
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.AddColumn<int>(
|
|
name: "ProjectNumber",
|
|
table: "Projects",
|
|
type: "int",
|
|
nullable: false,
|
|
defaultValue: 0);
|
|
|
|
migrationBuilder.AddColumn<int>(
|
|
name: "ProjectYear",
|
|
table: "Projects",
|
|
type: "int",
|
|
nullable: false,
|
|
defaultValue: 0);
|
|
|
|
migrationBuilder.AddColumn<int>(
|
|
name: "ProjectPartNumber",
|
|
table: "ProjectParts",
|
|
type: "int",
|
|
nullable: false,
|
|
defaultValue: 0);
|
|
|
|
migrationBuilder.AddColumn<DateTime>(
|
|
name: "DeliveryDate",
|
|
table: "ProjectPartItems",
|
|
type: "datetime(6)",
|
|
nullable: true);
|
|
|
|
migrationBuilder.AddColumn<int>(
|
|
name: "ProjectPartItemNumber",
|
|
table: "ProjectPartItems",
|
|
type: "int",
|
|
nullable: false,
|
|
defaultValue: 0);
|
|
}
|
|
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DropColumn(
|
|
name: "BuyersOrderNumber",
|
|
table: "Projects");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "ProjectNumber",
|
|
table: "Projects");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "ProjectYear",
|
|
table: "Projects");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "ProjectPartNumber",
|
|
table: "ProjectParts");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "DeliveryDate",
|
|
table: "ProjectPartItems");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "ProjectPartItemNumber",
|
|
table: "ProjectPartItems");
|
|
}
|
|
}
|
|
}
|