using System; using Microsoft.EntityFrameworkCore.Migrations; namespace Ropin.Inspection.Model.Migrations { public partial class EditUserRole : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "TSYS_UserRole", columns: table => new { C_UserCode = table.Column(type: "char(36)", nullable: false), C_RoleCode = table.Column(type: "char(36)", nullable: false), C_CreateBy = table.Column(type: "char(36)", nullable: false), D_CreateOn = table.Column(type: "datetime(6)", nullable: false) }, constraints: table => { table.PrimaryKey("PK_TSYS_UserRole", x => new { x.C_UserCode, x.C_RoleCode }); table.ForeignKey( name: "FK_TSYS_UserRole_TSYS_Role_C_RoleCode", column: x => x.C_RoleCode, principalTable: "TSYS_Role", principalColumn: "C_Code", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_TSYS_UserRole_TSYS_User_C_CreateBy", column: x => x.C_CreateBy, principalTable: "TSYS_User", principalColumn: "C_UserID", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_TSYS_UserRole_TSYS_User_C_UserCode", column: x => x.C_UserCode, principalTable: "TSYS_User", principalColumn: "C_UserID", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateIndex( name: "IX_TSYS_UserRole_C_CreateBy", table: "TSYS_UserRole", column: "C_CreateBy"); migrationBuilder.CreateIndex( name: "IX_TSYS_UserRole_C_RoleCode", table: "TSYS_UserRole", column: "C_RoleCode"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "TSYS_UserRole"); } } }