using System;
using Microsoft.EntityFrameworkCore.Migrations;
#nullable disable
namespace orthodox.Migrations
{
///
public partial class OrthodoxMigration : Migration
{
///
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.CreateTable(
name: "Datums",
columns: table => new
{
Id = table.Column(type: "int", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
PaymentDate = table.Column(type: "datetime2", nullable: true),
PaymentType = table.Column(type: "nvarchar(max)", nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_Datums", x => x.Id);
});
migrationBuilder.CreateTable(
name: "Pakalpojumis",
columns: table => new
{
Id = table.Column(type: "int", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
DonationType = table.Column(type: "nvarchar(max)", nullable: true),
Username = table.Column(type: "nvarchar(max)", nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_Pakalpojumis", x => x.Id);
});
migrationBuilder.CreateTable(
name: "PersonInformations",
columns: table => new
{
Id = table.Column(type: "int", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
Name = table.Column(type: "nvarchar(max)", nullable: true),
Phone = table.Column(type: "nvarchar(max)", nullable: true),
Email = table.Column(type: "nvarchar(max)", nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_PersonInformations", x => x.Id);
});
migrationBuilder.CreateTable(
name: "users",
columns: table => new
{
Id = table.Column(type: "int", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
Login = table.Column(type: "nvarchar(max)", nullable: true),
Password = table.Column(type: "nvarchar(max)", nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_users", x => x.Id);
});
migrationBuilder.CreateTable(
name: "KlientaInformacijas",
columns: table => new
{
Id = table.Column(type: "int", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
IdTransactionDate = table.Column(type: "int", nullable: true),
IdDt = table.Column(type: "int", nullable: true),
IdPerson = table.Column(type: "int", nullable: true),
Payment = table.Column(type: "nvarchar(max)", nullable: true),
IdDtNavigationId = table.Column(type: "int", nullable: true),
IdPersonNavigationId = table.Column(type: "int", nullable: true),
IdTransactionDateNavigationId = table.Column(type: "int", nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_KlientaInformacijas", x => x.Id);
table.ForeignKey(
name: "FK_KlientaInformacijas_Datums_IdTransactionDateNavigationId",
column: x => x.IdTransactionDateNavigationId,
principalTable: "Datums",
principalColumn: "Id");
table.ForeignKey(
name: "FK_KlientaInformacijas_Pakalpojumis_IdDtNavigationId",
column: x => x.IdDtNavigationId,
principalTable: "Pakalpojumis",
principalColumn: "Id");
table.ForeignKey(
name: "FK_KlientaInformacijas_PersonInformations_IdPersonNavigationId",
column: x => x.IdPersonNavigationId,
principalTable: "PersonInformations",
principalColumn: "Id");
});
migrationBuilder.CreateIndex(
name: "IX_KlientaInformacijas_IdDtNavigationId",
table: "KlientaInformacijas",
column: "IdDtNavigationId");
migrationBuilder.CreateIndex(
name: "IX_KlientaInformacijas_IdPersonNavigationId",
table: "KlientaInformacijas",
column: "IdPersonNavigationId");
migrationBuilder.CreateIndex(
name: "IX_KlientaInformacijas_IdTransactionDateNavigationId",
table: "KlientaInformacijas",
column: "IdTransactionDateNavigationId");
}
///
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropTable(
name: "KlientaInformacijas");
migrationBuilder.DropTable(
name: "users");
migrationBuilder.DropTable(
name: "Datums");
migrationBuilder.DropTable(
name: "Pakalpojumis");
migrationBuilder.DropTable(
name: "PersonInformations");
}
}
}