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"); } } }