protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_ReleaseBatchItem_ReleaseBatch_ReleaseBatchId", schema: "kraken", table: "ReleaseBatchItem"); migrationBuilder.AddUniqueConstraint( name: "AK_ReleaseBatch_Name", schema: "kraken", table: "ReleaseBatch", column: "Name"); migrationBuilder.AddForeignKey( name: "FK_ReleaseBatchItem_ReleaseBatch_ReleaseBatchId", schema: "kraken", table: "ReleaseBatchItem", column: "ReleaseBatchId", principalSchema: "kraken", principalTable: "ReleaseBatch", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn<string>( name: "UniqueId", table: "Users", nullable: false); migrationBuilder.AddUniqueConstraint( name: "AK_Users_UniqueId", table: "Users", column: "UniqueId"); migrationBuilder.AddUniqueConstraint( name: "AK_SectionMemberships_ClassroomMembershipId_SectionId", table: "SectionMemberships", columns: new[] { "ClassroomMembershipId", "SectionId" }); migrationBuilder.AddUniqueConstraint( name: "AK_ClassroomMemberships_UserId_ClassroomId", table: "ClassroomMemberships", columns: new[] { "UserId", "ClassroomId" }); migrationBuilder.AddUniqueConstraint( name: "AK_QuestionCategories_ClassroomId_Name", table: "QuestionCategories", columns: new[] { "ClassroomId", "Name" }); migrationBuilder.AddUniqueConstraint( name: "AK_Questions_QuestionCategoryId_Name", table: "Questions", columns: new[] { "QuestionCategoryId", "Name" }); migrationBuilder.AddUniqueConstraint( name: "AK_Sections_ClassroomId_Name", table: "Sections", columns: new[] { "ClassroomId", "Name" }); migrationBuilder.AddUniqueConstraint( name: "AK_Classrooms_Name", table: "Classrooms", column: "Name"); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn <int>( name: "Language", table: "Drafts", nullable: true, defaultValue: 1); migrationBuilder.AddColumn <DateTime>( name: "PublishDate", table: "Drafts", nullable: true, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)); migrationBuilder.AddColumn <string>( name: "Summary", table: "Drafts", nullable: true, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Tags", table: "Drafts", nullable: true, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Title", table: "Drafts", maxLength: 150, nullable: true, defaultValue: ""); migrationBuilder.Sql( "UPDATE T1" + "SET T1.Language = T2.Language, T1.PublishDate = T2.PublishDate, T1.Summary = T2.Summary, T1.Tags = T2.Tags, T1.Title = T2.Title" + "FROM Drafts AS T1" + "INNER JOIN Infos AS T2 ON T1.Id = T2.Id"); migrationBuilder.AlterColumn <int>( name: "Language", table: "Drafts", nullable: false); migrationBuilder.AlterColumn <DateTime>( name: "PublishDate", table: "Drafts", nullable: false); migrationBuilder.AlterColumn <string>( name: "Summary", table: "Drafts", nullable: false); migrationBuilder.AlterColumn <string>( name: "Tags", table: "Drafts", nullable: false); migrationBuilder.AlterColumn <string>( name: "Title", table: "Drafts", nullable: false); migrationBuilder.AddUniqueConstraint( name: "AK_Drafts_Title", table: "Drafts", column: "Title"); migrationBuilder.DropTable( name: "Infos"); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey(name: "FK_Contact_Item_Contact_contactId", table: "Contact_Item"); migrationBuilder.DropForeignKey(name: "FK_Ferias_Funcionario_funcionarioId", table: "Ferias"); migrationBuilder.DropForeignKey(name: "FK_Ferias_Itens_Funcionario_funcionarioId", table: "Ferias_Itens"); migrationBuilder.DropForeignKey(name: "FK_FuncFerias_Funcionario_funcionarioId", table: "FuncFerias"); migrationBuilder.DropForeignKey(name: "FK_FuncInfFerias_Funcionario_funcionarioId", table: "FuncInfFerias"); migrationBuilder.DropForeignKey(name: "FK_Funcionario_Departamento_departamentoId", table: "Funcionario"); migrationBuilder.DropForeignKey(name: "FK_Historio_Ferias_Item_Ferias_Itens_ferias_item_id", table: "Historio_Ferias_Item"); migrationBuilder.AlterColumn<string>( name: "contactId", table: "Contact_Item", nullable: true); migrationBuilder.AddColumn<string>( name: "contactId", table: "Contact", nullable: false, defaultValue: ""); migrationBuilder.AddUniqueConstraint( name: "AK_Contact_contactId", table: "Contact", column: "contactId"); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Contact_Item_Contact_contactId", table: "Contact_Item", column: "contactId", principalTable: "Contact", principalColumn: "contactId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Ferias_Funcionario_funcionarioId", table: "Ferias", column: "funcionarioId", principalTable: "Funcionario", principalColumn: "id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Ferias_Itens_Funcionario_funcionarioId", table: "Ferias_Itens", column: "funcionarioId", principalTable: "Funcionario", principalColumn: "id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_FuncFerias_Funcionario_funcionarioId", table: "FuncFerias", column: "funcionarioId", principalTable: "Funcionario", principalColumn: "id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_FuncInfFerias_Funcionario_funcionarioId", table: "FuncInfFerias", column: "funcionarioId", principalTable: "Funcionario", principalColumn: "id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Funcionario_Departamento_departamentoId", table: "Funcionario", column: "departamentoId", principalTable: "Departamento", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Historio_Ferias_Item_Ferias_Itens_ferias_item_id", table: "Historio_Ferias_Item", column: "ferias_item_id", principalTable: "Ferias_Itens", principalColumn: "id", onDelete: ReferentialAction.Restrict); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_DraftedPlayers_Drafts_DraftId", schema: "ff", table: "DraftedPlayers"); migrationBuilder.DropForeignKey( name: "FK_DraftedPlayers_Team_TeamId", schema: "ff", table: "DraftedPlayers"); migrationBuilder.DropForeignKey( name: "FK_MatchupRosters_Team_TeamId", schema: "ff", table: "MatchupRosters"); migrationBuilder.DropForeignKey( name: "FK_Seasons_Drafts_DraftId", schema: "ff", table: "Seasons"); migrationBuilder.DropForeignKey( name: "FK_Team_Managers_ManagerId", schema: "ff", table: "Team"); migrationBuilder.DropForeignKey( name: "FK_Team_Seasons_SeasonId", schema: "ff", table: "Team"); migrationBuilder.DropIndex( name: "IX_Seasons_DraftId", schema: "ff", table: "Seasons"); migrationBuilder.DropIndex( name: "IX_DraftedPlayers_DraftId", schema: "ff", table: "DraftedPlayers"); migrationBuilder.DropPrimaryKey( name: "PK_Team", schema: "ff", table: "Team"); migrationBuilder.DropColumn( name: "DraftId", schema: "ff", table: "Seasons"); migrationBuilder.DropColumn( name: "DisplayPosition", schema: "ff", table: "NFLPlayers"); migrationBuilder.DropColumn( name: "EligiblePositions", schema: "ff", table: "MatchupPlayers"); migrationBuilder.DropColumn( name: "DraftId", schema: "ff", table: "DraftedPlayers"); migrationBuilder.DropColumn( name: "LossesDivision", schema: "ff", table: "Team"); migrationBuilder.DropColumn( name: "PlayoffSeed", schema: "ff", table: "Team"); migrationBuilder.DropColumn( name: "TiesDivision", schema: "ff", table: "Team"); migrationBuilder.DropColumn( name: "WinsDivision", schema: "ff", table: "Team"); migrationBuilder.RenameTable( name: "Team", schema: "ff", newName: "ManagerSeasons", newSchema: "ff"); migrationBuilder.RenameColumn( name: "PrimaryPosition", schema: "ff", table: "NFLPlayers", newName: "NFLPosition"); migrationBuilder.RenameIndex( name: "IX_Team_SeasonId", schema: "ff", table: "ManagerSeasons", newName: "IX_ManagerSeasons_SeasonId"); migrationBuilder.RenameIndex( name: "IX_Team_ManagerId", schema: "ff", table: "ManagerSeasons", newName: "IX_ManagerSeasons_ManagerId"); migrationBuilder.AddColumn <int>( name: "YahooLeagueId", schema: "ff", table: "Seasons", type: "int", nullable: false, defaultValue: 0); migrationBuilder.AddColumn <int>( name: "YahooId", schema: "ff", table: "NFLPlayers", type: "int", nullable: true); migrationBuilder.AddColumn <string>( name: "SeasonId", schema: "ff", table: "Drafts", type: "nvarchar(450)", nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_Seasons_YahooLeagueId", schema: "ff", table: "Seasons", column: "YahooLeagueId"); migrationBuilder.AddPrimaryKey( name: "PK_ManagerSeasons", schema: "ff", table: "ManagerSeasons", column: "TeamId"); migrationBuilder.CreateIndex( name: "IX_Drafts_SeasonId", schema: "ff", table: "Drafts", column: "SeasonId", unique: true, filter: "[SeasonId] IS NOT NULL"); migrationBuilder.AddForeignKey( name: "FK_DraftedPlayers_ManagerSeasons_TeamId", schema: "ff", table: "DraftedPlayers", column: "TeamId", principalSchema: "ff", principalTable: "ManagerSeasons", principalColumn: "TeamId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Drafts_Seasons_SeasonId", schema: "ff", table: "Drafts", column: "SeasonId", principalSchema: "ff", principalTable: "Seasons", principalColumn: "SeasonId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ManagerSeasons_Managers_ManagerId", schema: "ff", table: "ManagerSeasons", column: "ManagerId", principalSchema: "ff", principalTable: "Managers", principalColumn: "ManagerId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ManagerSeasons_Seasons_SeasonId", schema: "ff", table: "ManagerSeasons", column: "SeasonId", principalSchema: "ff", principalTable: "Seasons", principalColumn: "SeasonId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_MatchupRosters_ManagerSeasons_TeamId", schema: "ff", table: "MatchupRosters", column: "TeamId", principalSchema: "ff", principalTable: "ManagerSeasons", principalColumn: "TeamId", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.RenameColumn( name: "UserId", table: "Service", newName: "VendorId"); migrationBuilder.AddUniqueConstraint( name: "AK_Service_Id_VendorId", table: "Service", columns: new[] { "Id", "VendorId" }); migrationBuilder.CreateTable( name: "AppUser", columns: table => new { AccessFailedCount = table.Column <int>(nullable: false), EmailConfirmed = table.Column <bool>(nullable: false), LockoutEnabled = table.Column <bool>(nullable: false), LockoutEnd = table.Column <DateTimeOffset>(nullable: true), PhoneNumberConfirmed = table.Column <bool>(nullable: false), TwoFactorEnabled = table.Column <bool>(nullable: false), Id = table.Column <string>(nullable: false), UserName = table.Column <string>(maxLength: 256, nullable: true), NormalizedUserName = table.Column <string>(maxLength: 256, nullable: true), Email = table.Column <string>(maxLength: 256, nullable: true), NormalizedEmail = table.Column <string>(maxLength: 256, nullable: true), PasswordHash = table.Column <string>(nullable: true), SecurityStamp = table.Column <string>(nullable: true), ConcurrencyStamp = table.Column <string>(nullable: true), PhoneNumber = table.Column <string>(nullable: true), FirstName = table.Column <string>(nullable: true), LastName = table.Column <string>(nullable: true), FacebookId = table.Column <long>(nullable: true), GoogleId = table.Column <long>(nullable: true), PictureUrl = table.Column <string>(nullable: true), DateCreated = table.Column <DateTime>(nullable: false), DateUpdated = table.Column <DateTime>(nullable: false), LastLogin = table.Column <DateTime>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_AppUser", x => x.Id); }); migrationBuilder.CreateTable( name: "IdentityRole", columns: table => new { Id = table.Column <string>(nullable: false), Name = table.Column <string>(maxLength: 256, nullable: true), NormalizedName = table.Column <string>(maxLength: 256, nullable: true), ConcurrencyStamp = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_IdentityRole", x => x.Id); }); migrationBuilder.CreateTable( name: "IdentityUserClaim", columns: table => new { Id = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), UserId = table.Column <string>(nullable: false), ClaimType = table.Column <string>(nullable: true), ClaimValue = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_IdentityUserClaim", x => x.Id); table.ForeignKey( name: "FK_IdentityUserClaim_AppUser_UserId", column: x => x.UserId, principalTable: "AppUser", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "IdentityUserLogin", columns: table => new { LoginProvider = table.Column <string>(nullable: false), ProviderKey = table.Column <string>(nullable: false), ProviderDisplayName = table.Column <string>(nullable: true), UserId = table.Column <string>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_IdentityUserLogin", x => new { x.LoginProvider, x.ProviderKey }); table.ForeignKey( name: "FK_IdentityUserLogin_AppUser_UserId", column: x => x.UserId, principalTable: "AppUser", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "IdentityUserToken", columns: table => new { UserId = table.Column <string>(nullable: false), LoginProvider = table.Column <string>(nullable: false), Name = table.Column <string>(nullable: false), Value = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_IdentityUserToken", x => new { x.UserId, x.LoginProvider, x.Name }); table.ForeignKey( name: "FK_IdentityUserToken_AppUser_UserId", column: x => x.UserId, principalTable: "AppUser", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "Vendor", columns: table => new { Id = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), IdentityId = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Vendor", x => x.Id); table.ForeignKey( name: "FK_Vendor_AppUser_IdentityId", column: x => x.IdentityId, principalTable: "AppUser", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "IdentityRoleClaim", columns: table => new { Id = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), RoleId = table.Column <string>(nullable: false), ClaimType = table.Column <string>(nullable: true), ClaimValue = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_IdentityRoleClaim", x => x.Id); table.ForeignKey( name: "FK_IdentityRoleClaim_IdentityRole_RoleId", column: x => x.RoleId, principalTable: "IdentityRole", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "IdentityUserRole", columns: table => new { UserId = table.Column <string>(nullable: false), RoleId = table.Column <string>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_IdentityUserRole", x => new { x.UserId, x.RoleId }); table.ForeignKey( name: "FK_IdentityUserRole_IdentityRole_RoleId", column: x => x.RoleId, principalTable: "IdentityRole", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_IdentityUserRole_AppUser_UserId", column: x => x.UserId, principalTable: "AppUser", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_Service_VendorId", table: "Service", column: "VendorId"); migrationBuilder.CreateIndex( name: "EmailIndex", table: "AppUser", column: "NormalizedEmail"); migrationBuilder.CreateIndex( name: "UserNameIndex", table: "AppUser", column: "NormalizedUserName", unique: true, filter: "[NormalizedUserName] IS NOT NULL"); migrationBuilder.CreateIndex( name: "RoleNameIndex", table: "IdentityRole", column: "NormalizedName", unique: true, filter: "[NormalizedName] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_IdentityRoleClaim_RoleId", table: "IdentityRoleClaim", column: "RoleId"); migrationBuilder.CreateIndex( name: "IX_IdentityUserClaim_UserId", table: "IdentityUserClaim", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_IdentityUserLogin_UserId", table: "IdentityUserLogin", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_IdentityUserRole_RoleId", table: "IdentityUserRole", column: "RoleId"); migrationBuilder.CreateIndex( name: "IX_Vendor_IdentityId", table: "Vendor", column: "IdentityId"); migrationBuilder.AddForeignKey( name: "FK_Service_Vendor_VendorId", table: "Service", column: "VendorId", principalTable: "Vendor", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { //migrationBuilder.DropForeignKey( // name: "FK_Candles_Pairs_ExchangePairId", // table: "Candles"); migrationBuilder.DropForeignKey( name: "FK_Candles_Pairs_PairId", table: "Candles"); migrationBuilder.DropUniqueConstraint( name: "AK_Candles_TimeOpen_TimeClose_PairId", table: "Candles"); migrationBuilder.DropIndex( name: "IX_Candles_PairId", table: "Candles"); //migrationBuilder.DropColumn( // name: "PairId", // table: "Candles"); migrationBuilder.AlterColumn <Guid>( name: "ExchangePairId", table: "Candles", nullable: false, oldClrType: typeof(Guid), oldType: "uuid", oldNullable: true); migrationBuilder.AddColumn <Guid>( name: "ExchangePairId1", table: "Candles", nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_Candles_TimeOpen_TimeClose_ExchangePairId", table: "Candles", columns: new[] { "TimeOpen", "TimeClose", "ExchangePairId" }); migrationBuilder.CreateIndex( name: "IX_Candles_ExchangePairId1", table: "Candles", column: "ExchangePairId1"); migrationBuilder.AddForeignKey( name: "FK_Candles_Pairs_ExchangePairId", table: "Candles", column: "ExchangePairId", principalTable: "Pairs", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Candles_Pairs_ExchangePairId1", table: "Candles", column: "ExchangePairId1", principalTable: "Pairs", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropIndex( name: "IX_Tournament_WinnerId", table: "Tournament"); migrationBuilder.DropIndex( name: "IX_Player_GameId_UserId", table: "Player"); migrationBuilder.DropIndex( name: "IX_OpenIddictTokens_ApplicationId", table: "OpenIddictTokens"); migrationBuilder.DropIndex( name: "IX_OpenIddictAuthorizations_ApplicationId", table: "OpenIddictAuthorizations"); migrationBuilder.DropIndex( name: "IX_Channels_GameId", table: "Channels"); migrationBuilder.DropIndex( name: "UserNameIndex", table: "AspNetUsers"); migrationBuilder.DropPrimaryKey( name: "PK_AspNetUserLogins", table: "AspNetUserLogins"); migrationBuilder.DropIndex( name: "IX_AspNetUserLogins_UserId", table: "AspNetUserLogins"); migrationBuilder.DropIndex( name: "RoleNameIndex", table: "AspNetRoles"); migrationBuilder.RenameColumn( name: "Scope", table: "OpenIddictAuthorizations", newName: "Scopes"); migrationBuilder.RenameColumn( name: "RedirectUri", table: "OpenIddictApplications", newName: "RedirectUris"); migrationBuilder.RenameColumn( name: "LogoutRedirectUri", table: "OpenIddictApplications", newName: "Properties"); migrationBuilder.AlterColumn <string>( name: "Type", table: "OpenIddictTokens", maxLength: 25, nullable: false, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "Subject", table: "OpenIddictTokens", maxLength: 450, nullable: false, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AddColumn <string>( name: "ConcurrencyToken", table: "OpenIddictTokens", maxLength: 50, nullable: true); migrationBuilder.AddColumn <DateTimeOffset>( name: "CreationDate", table: "OpenIddictTokens", nullable: true); migrationBuilder.AddColumn <DateTimeOffset>( name: "ExpirationDate", table: "OpenIddictTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "Payload", table: "OpenIddictTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "Properties", table: "OpenIddictTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "ReferenceId", table: "OpenIddictTokens", maxLength: 100, nullable: true); migrationBuilder.AddColumn <string>( name: "Status", table: "OpenIddictTokens", maxLength: 25, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "ConcurrencyToken", table: "OpenIddictScopes", maxLength: 50, nullable: true); migrationBuilder.AddColumn <string>( name: "DisplayName", table: "OpenIddictScopes", nullable: true); migrationBuilder.AddColumn <string>( name: "Name", table: "OpenIddictScopes", maxLength: 200, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Properties", table: "OpenIddictScopes", nullable: true); migrationBuilder.AddColumn <string>( name: "Resources", table: "OpenIddictScopes", nullable: true); migrationBuilder.AlterColumn <string>( name: "Subject", table: "OpenIddictAuthorizations", maxLength: 450, nullable: false, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AddColumn <string>( name: "ConcurrencyToken", table: "OpenIddictAuthorizations", maxLength: 50, nullable: true); migrationBuilder.AddColumn <string>( name: "Properties", table: "OpenIddictAuthorizations", nullable: true); migrationBuilder.AddColumn <string>( name: "Status", table: "OpenIddictAuthorizations", maxLength: 25, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Type", table: "OpenIddictAuthorizations", maxLength: 25, nullable: false, defaultValue: ""); migrationBuilder.AlterColumn <string>( name: "Type", table: "OpenIddictApplications", maxLength: 25, nullable: false, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "ClientId", table: "OpenIddictApplications", maxLength: 100, nullable: false, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AddColumn <string>( name: "ConcurrencyToken", table: "OpenIddictApplications", maxLength: 50, nullable: true); migrationBuilder.AddColumn <string>( name: "ConsentType", table: "OpenIddictApplications", nullable: true); migrationBuilder.AddColumn <string>( name: "Permissions", table: "OpenIddictApplications", nullable: true); migrationBuilder.AddColumn <string>( name: "PostLogoutRedirectUris", table: "OpenIddictApplications", nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_AspNetUserLogins_LoginProvider_ProviderKey", table: "AspNetUserLogins", columns: new[] { "LoginProvider", "ProviderKey" }); migrationBuilder.AddPrimaryKey( name: "PK_AspNetUserLogins", table: "AspNetUserLogins", columns: new[] { "UserId", "LoginProvider" }); migrationBuilder.CreateIndex( name: "IX_Tournament_WinnerId", table: "Tournament", column: "WinnerId", unique: true, filter: "[WinnerId] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_Player_GameId_UserId", table: "Player", columns: new[] { "GameId", "UserId" }, unique: true, filter: "[GameId] IS NOT NULL AND [UserId] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_OpenIddictTokens_ReferenceId", table: "OpenIddictTokens", column: "ReferenceId", unique: true, filter: "[ReferenceId] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_OpenIddictTokens_ApplicationId_Status_Subject_Type", table: "OpenIddictTokens", columns: new[] { "ApplicationId", "Status", "Subject", "Type" }); migrationBuilder.CreateIndex( name: "IX_OpenIddictScopes_Name", table: "OpenIddictScopes", column: "Name", unique: true); migrationBuilder.CreateIndex( name: "IX_OpenIddictAuthorizations_ApplicationId_Status_Subject_Type", table: "OpenIddictAuthorizations", columns: new[] { "ApplicationId", "Status", "Subject", "Type" }); migrationBuilder.CreateIndex( name: "IX_Channels_GameId", table: "Channels", column: "GameId", unique: true, filter: "[GameId] IS NOT NULL"); migrationBuilder.CreateIndex( name: "UserNameIndex", table: "AspNetUsers", column: "NormalizedUserName", unique: true, filter: "[NormalizedUserName] IS NOT NULL"); migrationBuilder.CreateIndex( name: "RoleNameIndex", table: "AspNetRoles", column: "NormalizedName", unique: true, filter: "[NormalizedName] IS NOT NULL"); migrationBuilder.AddForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId", table: "AspNetUserTokens", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropPrimaryKey( name: "PK_PharmacyPrescriptions", schema: "an", table: "PharmacyPrescriptions"); migrationBuilder.DropIndex( name: "IX_PharmacyPrescriptions_PharmacyId", schema: "an", table: "PharmacyPrescriptions"); migrationBuilder.DropIndex( name: "IX_PharmacyPrescriptions_TreatmentHistoryId", schema: "an", table: "PharmacyPrescriptions"); migrationBuilder.DropColumn( name: "Id", schema: "an", table: "PharmacyPrescriptions"); migrationBuilder.AddUniqueConstraint( name: "AK_PharmacyPrescriptions_PharmacyId_TreatmentHistoryId", schema: "an", table: "PharmacyPrescriptions", columns: new[] { "PharmacyId", "TreatmentHistoryId" }); migrationBuilder.AddPrimaryKey( name: "PK_PharmacyPrescriptions", schema: "an", table: "PharmacyPrescriptions", columns: new[] { "TreatmentHistoryId", "PharmacyId" }); migrationBuilder.UpdateData( schema: "an", table: "City", keyColumn: "Id", keyValue: 1, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 684, DateTimeKind.Local).AddTicks(8125)); migrationBuilder.UpdateData( schema: "an", table: "City", keyColumn: "Id", keyValue: 2, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 684, DateTimeKind.Local).AddTicks(8156)); migrationBuilder.UpdateData( schema: "an", table: "City", keyColumn: "Id", keyValue: 3, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 684, DateTimeKind.Local).AddTicks(8159)); migrationBuilder.UpdateData( schema: "an", table: "Expertise", keyColumn: "Id", keyValue: 1, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 686, DateTimeKind.Local).AddTicks(453)); migrationBuilder.UpdateData( schema: "an", table: "Expertise", keyColumn: "Id", keyValue: 2, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 686, DateTimeKind.Local).AddTicks(475)); migrationBuilder.UpdateData( schema: "an", table: "ExpertiseCategory", keyColumn: "Id", keyValue: 1, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(6739)); migrationBuilder.UpdateData( schema: "an", table: "ExpertiseCategory", keyColumn: "Id", keyValue: 2, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(8242)); migrationBuilder.UpdateData( schema: "an", table: "Province", keyColumn: "Id", keyValue: 1, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 684, DateTimeKind.Local).AddTicks(1104)); migrationBuilder.UpdateData( schema: "an", table: "Province", keyColumn: "Id", keyValue: 2, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 684, DateTimeKind.Local).AddTicks(1744)); migrationBuilder.UpdateData( schema: "an", table: "Province", keyColumn: "Id", keyValue: 3, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 684, DateTimeKind.Local).AddTicks(1747)); migrationBuilder.UpdateData( schema: "an", table: "ScientificCategory", keyColumn: "Id", keyValue: 1, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(4305)); migrationBuilder.UpdateData( schema: "an", table: "ScientificCategory", keyColumn: "Id", keyValue: 2, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(5850)); migrationBuilder.UpdateData( schema: "an", table: "ScientificCategory", keyColumn: "Id", keyValue: 3, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(5864)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 1, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3194)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 2, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3388)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 3, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3390)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 4, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3392)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 5, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3393)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 6, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3418)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 7, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3420)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 8, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3422)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 9, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3423)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 10, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3425)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 11, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3426)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 12, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3428)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 13, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3430)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 14, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3431)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 15, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3434)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 16, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3436)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 17, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3461)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 18, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3463)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 19, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3474)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 20, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3476)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 21, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3486)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 22, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3487)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 23, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3489)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 24, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3490)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 25, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3492)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 26, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3494)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 27, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3495)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 28, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3497)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 29, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3498)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 30, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3500)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 31, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3501)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 32, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3503)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 33, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3515)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 34, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3516)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 35, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3527)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 36, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3529)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 37, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3531)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 38, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3532)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 39, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3543)); migrationBuilder.UpdateData( schema: "an", table: "Service", keyColumn: "Id", keyValue: 40, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(3544)); migrationBuilder.UpdateData( schema: "an", table: "ServiceCategory", keyColumn: "Id", keyValue: 1, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(712)); migrationBuilder.UpdateData( schema: "an", table: "ServiceCategory", keyColumn: "Id", keyValue: 2, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(735)); migrationBuilder.UpdateData( schema: "an", table: "ServiceCategory", keyColumn: "Id", keyValue: 3, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(738)); migrationBuilder.UpdateData( schema: "an", table: "ServiceCategory", keyColumn: "Id", keyValue: 4, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(739)); migrationBuilder.UpdateData( schema: "an", table: "ServiceCategory", keyColumn: "Id", keyValue: 5, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(741)); migrationBuilder.UpdateData( schema: "an", table: "ServiceCategory", keyColumn: "Id", keyValue: 6, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(743)); migrationBuilder.UpdateData( schema: "an", table: "ServiceCategory", keyColumn: "Id", keyValue: 7, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(744)); migrationBuilder.UpdateData( schema: "an", table: "ServiceCategory", keyColumn: "Id", keyValue: 8, column: "CreatedAt", value: new DateTime(2019, 12, 3, 12, 9, 59, 685, DateTimeKind.Local).AddTicks(746)); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Groups_Rooms_RoomId", table: "Groups"); migrationBuilder.DropForeignKey( name: "FK_RoomParticipants_Rooms_RoomId", table: "RoomParticipants"); migrationBuilder.DropForeignKey( name: "FK_RoomParticipants_Users_UserId", table: "RoomParticipants"); migrationBuilder.DropUniqueConstraint( name: "AK_RoomParticipants_RoomId_UserId", table: "RoomParticipants"); migrationBuilder.DropPrimaryKey( name: "PK_RoomParticipants", table: "RoomParticipants"); migrationBuilder.DropPrimaryKey( name: "PK_Groups", table: "Groups"); migrationBuilder.RenameTable( name: "RoomParticipants", newName: "RoomParticipant"); migrationBuilder.RenameTable( name: "Groups", newName: "Group"); migrationBuilder.RenameIndex( name: "IX_Groups_RoomId", table: "Group", newName: "IX_Group_RoomId"); migrationBuilder.AddUniqueConstraint( name: "AK_RoomParticipant_RoomId_UserId", table: "RoomParticipant", columns: new[] { "RoomId", "UserId" }); migrationBuilder.AddPrimaryKey( name: "PK_RoomParticipant", table: "RoomParticipant", columns: new[] { "UserId", "RoomId" }); migrationBuilder.AddPrimaryKey( name: "PK_Group", table: "Group", column: "Id"); migrationBuilder.AddForeignKey( name: "FK_Group_Rooms_RoomId", table: "Group", column: "RoomId", principalTable: "Rooms", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_RoomParticipant_Rooms_RoomId", table: "RoomParticipant", column: "RoomId", principalTable: "Rooms", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_RoomParticipant_Users_UserId", table: "RoomParticipant", column: "UserId", principalTable: "Users", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_LessonPlan_ArtPiece_ArtPieces_ArtPieceId", table: "LessonPlan_ArtPiece"); migrationBuilder.DropForeignKey( name: "FK_LessonPlan_ArtPiece_Lessonplans_LessonPlanId", table: "LessonPlan_ArtPiece"); migrationBuilder.DropForeignKey( name: "FK_LessonPlan_Poem_Lessonplans_LessonPlanId", table: "LessonPlan_Poem"); migrationBuilder.DropForeignKey( name: "FK_LessonPlan_Poem_Poems_PoemId", table: "LessonPlan_Poem"); migrationBuilder.DropForeignKey( name: "FK_LessonPlan_WritingAssignment_Lessonplans_LessonPlanId", table: "LessonPlan_WritingAssignment"); migrationBuilder.DropForeignKey( name: "FK_LessonPlan_WritingAssignment_WritingAssignments_WritingAssignmentId", table: "LessonPlan_WritingAssignment"); migrationBuilder.DropPrimaryKey( name: "PK_LessonPlan_WritingAssignment", table: "LessonPlan_WritingAssignment"); migrationBuilder.DropUniqueConstraint( name: "AK_LessonPlan_WritingAssignment_WritingAssignmentId_LessonPlanId", table: "LessonPlan_WritingAssignment"); migrationBuilder.DropPrimaryKey( name: "PK_LessonPlan_Poem", table: "LessonPlan_Poem"); migrationBuilder.DropPrimaryKey( name: "PK_LessonPlan_ArtPiece", table: "LessonPlan_ArtPiece"); migrationBuilder.RenameTable( name: "LessonPlan_WritingAssignment", newName: "lessonPlan_WritingAssignments"); migrationBuilder.RenameTable( name: "LessonPlan_Poem", newName: "lessonPlan_Poems"); migrationBuilder.RenameTable( name: "LessonPlan_ArtPiece", newName: "lessonPlan_ArtPieces"); migrationBuilder.RenameIndex( name: "IX_LessonPlan_Poem_PoemId", table: "lessonPlan_Poems", newName: "IX_lessonPlan_Poems_PoemId"); migrationBuilder.RenameIndex( name: "IX_LessonPlan_ArtPiece_LessonPlanId", table: "lessonPlan_ArtPieces", newName: "IX_lessonPlan_ArtPieces_LessonPlanId"); migrationBuilder.AddColumn <int>( name: "LessonPlanId", table: "WritingAssignments", nullable: true); migrationBuilder.AddColumn <int>( name: "LessonPlanId", table: "Poems", nullable: true); migrationBuilder.AddColumn <int>( name: "LessonPlanId", table: "ArtPieces", nullable: true); migrationBuilder.AddPrimaryKey( name: "PK_lessonPlan_WritingAssignments", table: "lessonPlan_WritingAssignments", columns: new[] { "LessonPlanId", "WritingAssignmentId" }); migrationBuilder.AddUniqueConstraint( name: "AK_lessonPlan_WritingAssignments_WritingAssignmentId_LessonPlanId", table: "lessonPlan_WritingAssignments", columns: new[] { "WritingAssignmentId", "LessonPlanId" }); migrationBuilder.AddPrimaryKey( name: "PK_lessonPlan_Poems", table: "lessonPlan_Poems", columns: new[] { "LessonPlanId", "PoemId" }); migrationBuilder.AddPrimaryKey( name: "PK_lessonPlan_ArtPieces", table: "lessonPlan_ArtPieces", columns: new[] { "ArtPieceId", "LessonPlanId" }); migrationBuilder.CreateIndex( name: "IX_WritingAssignments_LessonPlanId", table: "WritingAssignments", column: "LessonPlanId"); migrationBuilder.CreateIndex( name: "IX_Poems_LessonPlanId", table: "Poems", column: "LessonPlanId"); migrationBuilder.CreateIndex( name: "IX_ArtPieces_LessonPlanId", table: "ArtPieces", column: "LessonPlanId"); migrationBuilder.AddForeignKey( name: "FK_ArtPieces_Lessonplans_LessonPlanId", table: "ArtPieces", column: "LessonPlanId", principalTable: "Lessonplans", principalColumn: "LessonPlanId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_lessonPlan_ArtPieces_ArtPieces_ArtPieceId", table: "lessonPlan_ArtPieces", column: "ArtPieceId", principalTable: "ArtPieces", principalColumn: "ArtPieceId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_lessonPlan_ArtPieces_Lessonplans_LessonPlanId", table: "lessonPlan_ArtPieces", column: "LessonPlanId", principalTable: "Lessonplans", principalColumn: "LessonPlanId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_lessonPlan_Poems_Lessonplans_LessonPlanId", table: "lessonPlan_Poems", column: "LessonPlanId", principalTable: "Lessonplans", principalColumn: "LessonPlanId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_lessonPlan_Poems_Poems_PoemId", table: "lessonPlan_Poems", column: "PoemId", principalTable: "Poems", principalColumn: "PoemId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_lessonPlan_WritingAssignments_Lessonplans_LessonPlanId", table: "lessonPlan_WritingAssignments", column: "LessonPlanId", principalTable: "Lessonplans", principalColumn: "LessonPlanId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_lessonPlan_WritingAssignments_WritingAssignments_WritingAssignmentId", table: "lessonPlan_WritingAssignments", column: "WritingAssignmentId", principalTable: "WritingAssignments", principalColumn: "WritingAssignmentId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Poems_Lessonplans_LessonPlanId", table: "Poems", column: "LessonPlanId", principalTable: "Lessonplans", principalColumn: "LessonPlanId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_WritingAssignments_Lessonplans_LessonPlanId", table: "WritingAssignments", column: "LessonPlanId", principalTable: "Lessonplans", principalColumn: "LessonPlanId", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropUniqueConstraint( name: "AK_TradePoolMaster_BidPrice_BuyServiceID_Id_SellServiceID", table: "TradePoolMaster"); migrationBuilder.DropColumn( name: "RoutID", table: "TransactionQueue"); migrationBuilder.AlterColumn <long>( name: "ProductID", table: "TransactionQueue", nullable: false, oldClrType: typeof(int)); migrationBuilder.AddColumn <long>( name: "RouteID", table: "TransactionQueue", nullable: false, defaultValue: 0L); migrationBuilder.AddColumn <long>( name: "CountPerPrice", table: "TradePoolMaster", nullable: false, defaultValue: 0L); migrationBuilder.AlterColumn <long>( name: "CountryID", table: "StateMaster", nullable: false, oldClrType: typeof(string)); migrationBuilder.AddUniqueConstraint( name: "AK_TradePoolMaster_BidPrice_BuyServiceID_CountPerPrice_Id_SellServiceID", table: "TradePoolMaster", columns: new[] { "BidPrice", "BuyServiceID", "CountPerPrice", "Id", "SellServiceID" }); migrationBuilder.CreateTable( name: "CityMaster", columns: table => new { Id = table.Column <long>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), CreatedDate = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <long>(nullable: false), UpdatedBy = table.Column <long>(nullable: true), UpdatedDate = table.Column <DateTime>(nullable: false), Status = table.Column <short>(nullable: false), CityName = table.Column <string>(maxLength: 30, nullable: false), StateID = table.Column <long>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_CityMaster", x => x.Id); }); migrationBuilder.CreateTable( name: "DepositCounterLog", columns: table => new { Id = table.Column <long>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), CreatedDate = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <long>(nullable: false), UpdatedBy = table.Column <long>(nullable: true), UpdatedDate = table.Column <DateTime>(nullable: false), Status = table.Column <short>(nullable: false), NewTxnID = table.Column <string>(nullable: true), PreviousTrnID = table.Column <string>(nullable: true), LastTrnID = table.Column <string>(nullable: true), LastLimit = table.Column <long>(nullable: false), NextBatchPrvID = table.Column <string>(nullable: true), DepositCounterMasterId = table.Column <long>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_DepositCounterLog", x => x.Id); }); migrationBuilder.CreateTable( name: "DepositCounterMaster", columns: table => new { Id = table.Column <long>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), CreatedDate = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <long>(nullable: false), UpdatedBy = table.Column <long>(nullable: true), UpdatedDate = table.Column <DateTime>(nullable: false), Status = table.Column <short>(nullable: false), RecordCount = table.Column <int>(nullable: false), Limit = table.Column <long>(nullable: false), LastTrnID = table.Column <string>(nullable: true), MaxLimit = table.Column <long>(nullable: false), WalletTypeID = table.Column <long>(nullable: false), SerProId = table.Column <long>(nullable: false), PreviousTrnID = table.Column <string>(nullable: true), TPSPickupStatus = table.Column <long>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_DepositCounterMaster", x => x.Id); }); migrationBuilder.CreateTable( name: "ZipCodeMaster", columns: table => new { Id = table.Column <long>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), CreatedDate = table.Column <DateTime>(nullable: false), CreatedBy = table.Column <long>(nullable: false), UpdatedBy = table.Column <long>(nullable: true), UpdatedDate = table.Column <DateTime>(nullable: false), Status = table.Column <short>(nullable: false), ZipCode = table.Column <long>(nullable: false), ZipAreaName = table.Column <string>(maxLength: 30, nullable: false), CityID = table.Column <long>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_ZipCodeMaster", x => x.Id); }); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn <string>( name: "UserName", table: "AspNetUsers", maxLength: 256, nullable: false, oldClrType: typeof(string), oldMaxLength: 256, oldNullable: true); migrationBuilder.AddColumn <string>( name: "City", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Country", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "FirstName", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <bool>( name: "IsAdmin", table: "AspNetUsers", nullable: false, defaultValue: false); migrationBuilder.AddColumn <string>( name: "LastName", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <long>( name: "MobileNumber", table: "AspNetUsers", nullable: false, defaultValue: 0L); migrationBuilder.AddColumn <string>( name: "Password", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "PostalCode", table: "AspNetUsers", maxLength: 6, nullable: true); migrationBuilder.AddColumn <string>( name: "Province", table: "AspNetUsers", maxLength: 2, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Street", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <DateTime>( name: "CreationDate", table: "AspNetRoles", nullable: false, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)); migrationBuilder.AddColumn <string>( name: "Description", table: "AspNetRoles", nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_AspNetUsers_UserName", table: "AspNetUsers", column: "UserName"); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropIndex( name: "IX_MovieActors_ActorId", table: "MovieActors"); migrationBuilder.DeleteData( table: "MovieActors", keyColumns: new[] { "MovieId", "ActorId" }, keyValues: new object[] { 1, 1 }); migrationBuilder.DeleteData( table: "MovieActors", keyColumns: new[] { "MovieId", "ActorId" }, keyValues: new object[] { 2, 2 }); migrationBuilder.DeleteData( table: "Actors", keyColumn: "Id", keyValue: 1); migrationBuilder.DeleteData( table: "Actors", keyColumn: "Id", keyValue: 2); migrationBuilder.DeleteData( table: "Movies", keyColumn: "Id", keyValue: 1); migrationBuilder.DeleteData( table: "Movies", keyColumn: "Id", keyValue: 2); migrationBuilder.AlterColumn <decimal>( name: "Id", table: "Movies", type: "decimal(20,0)", nullable: false, oldClrType: typeof(int)) .Annotation("SqlServer:Identity", "1, 1") .OldAnnotation("SqlServer:Identity", "1, 1"); migrationBuilder.AlterColumn <decimal>( name: "ActorId", table: "MovieActors", type: "decimal(20,0)", nullable: false, oldClrType: typeof(int)); migrationBuilder.AlterColumn <decimal>( name: "MovieId", table: "MovieActors", type: "decimal(20,0)", nullable: false, oldClrType: typeof(int)); migrationBuilder.AlterColumn <decimal>( name: "Id", table: "Actors", type: "decimal(20,0)", nullable: false, oldClrType: typeof(int)) .Annotation("SqlServer:Identity", "1, 1") .OldAnnotation("SqlServer:Identity", "1, 1"); migrationBuilder.AddColumn <decimal>( name: "MovieId", table: "Actors", type: "decimal(20,0)", nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_MovieActors_ActorId_MovieId", table: "MovieActors", columns: new[] { "ActorId", "MovieId" }); migrationBuilder.InsertData( table: "Actors", columns: new[] { "Id", "FirstName", "LastName", "MovieId" }, values: new object[] { 1m, "Samuel L.", "Jackson", null }); migrationBuilder.InsertData( table: "Movies", columns: new[] { "Id", "Name" }, values: new object[] { 1m, "Pulp Fiction" }); migrationBuilder.InsertData( table: "MovieActors", columns: new[] { "MovieId", "ActorId" }, values: new object[] { 1m, 1m }); migrationBuilder.CreateIndex( name: "IX_Actors_MovieId", table: "Actors", column: "MovieId"); migrationBuilder.AddForeignKey( name: "FK_Actors_Movies_MovieId", table: "Actors", column: "MovieId", principalTable: "Movies", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropPrimaryKey( name: "PK_Cars", table: "Cars"); migrationBuilder.RenameTable( name: "Cars", newName: "Car"); migrationBuilder.RenameColumn( name: "Id", table: "Car", newName: "CarId"); migrationBuilder.AlterColumn <string>( name: "PlateNo", table: "Car", maxLength: 30, nullable: false, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "Color", table: "Car", maxLength: 30, nullable: true, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "BuildNo", table: "Car", maxLength: 30, nullable: true, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AddPrimaryKey( name: "PK_Car", table: "Car", column: "CarId"); migrationBuilder.AddUniqueConstraint( name: "AK_Car_PlateNo", table: "Car", column: "PlateNo"); migrationBuilder.CreateIndex( name: "UX_Car_BuildNo", table: "Car", column: "BuildNo", unique: true, filter: "[BuildNo] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_Car_CarId", table: "Car", column: "CarId"); migrationBuilder.CreateIndex( name: "UX_Car_PlateNo", table: "Car", column: "PlateNo", unique: true); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_SectionMemberships_Sections_SectionId", table: "SectionMemberships"); migrationBuilder.DropIndex( name: "IX_Users_UniqueId", table: "Users"); migrationBuilder.DropIndex( name: "IX_SectionMemberships_SectionId", table: "SectionMemberships"); migrationBuilder.DropIndex( name: "IX_SectionMemberships_ClassroomMembershipId_SectionId", table: "SectionMemberships"); migrationBuilder.DropIndex( name: "IX_ClassroomMemberships_UserId_ClassroomId", table: "ClassroomMemberships"); migrationBuilder.DropIndex( name: "IX_QuestionCategories_ClassroomId_Name", table: "QuestionCategories"); migrationBuilder.DropIndex( name: "IX_Questions_QuestionCategoryId_Name", table: "Questions"); migrationBuilder.DropIndex( name: "IX_Sections_ClassroomId_Name", table: "Sections"); migrationBuilder.DropIndex( name: "IX_Classrooms_Name", table: "Classrooms"); migrationBuilder.DropColumn( name: "IsPrivate", table: "QuestionCategories"); migrationBuilder.DropColumn( name: "AllowPartialCredit", table: "Questions"); migrationBuilder.DropColumn( name: "IsPrivate", table: "Questions"); migrationBuilder.DropColumn( name: "DateModified", table: "Questions"); migrationBuilder.DropColumn( name: "FullGeneratorFileContents", table: "Questions"); migrationBuilder.DropColumn( name: "FullGeneratorFileLineOffset", table: "Questions"); migrationBuilder.DropTable( name: "UserQuestionSubmission"); migrationBuilder.DropTable( name: "UserQuestionData"); migrationBuilder.AddColumn<bool>( name: "RandomizeAnswers", table: "Questions", nullable: true); migrationBuilder.AlterColumn<string>( name: "UniqueId", table: "Users", nullable: false); migrationBuilder.AddUniqueConstraint( name: "AK_Users_UniqueId", table: "Users", column: "UniqueId"); migrationBuilder.AddUniqueConstraint( name: "AK_SectionMemberships_ClassroomMembershipId_SectionId", table: "SectionMemberships", columns: new[] { "ClassroomMembershipId", "SectionId" }); migrationBuilder.AddUniqueConstraint( name: "AK_ClassroomMemberships_UserId_ClassroomId", table: "ClassroomMemberships", columns: new[] { "UserId", "ClassroomId" }); migrationBuilder.AddUniqueConstraint( name: "AK_QuestionCategories_ClassroomId_Name", table: "QuestionCategories", columns: new[] { "ClassroomId", "Name" }); migrationBuilder.AddUniqueConstraint( name: "AK_Questions_QuestionCategoryId_Name", table: "Questions", columns: new[] { "QuestionCategoryId", "Name" }); migrationBuilder.AddUniqueConstraint( name: "AK_Sections_ClassroomId_Name", table: "Sections", columns: new[] { "ClassroomId", "Name" }); migrationBuilder.AddUniqueConstraint( name: "AK_Classrooms_Name", table: "Classrooms", column: "Name"); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddUniqueConstraint( name: "ak_player_user_id", table: "player", column: "user_id"); migrationBuilder.CreateTable( name: "round", columns: table => new { round_id = table.Column <int>(type: "integer", nullable: false) .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn) }, constraints: table => { table.PrimaryKey("PK_round", x => x.round_id); }); migrationBuilder.CreateTable( name: "admin_log", columns: table => new { admin_log_id = table.Column <int>(type: "integer", nullable: false) .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), round_id = table.Column <int>(type: "integer", nullable: false), type = table.Column <int>(type: "integer", nullable: false), date = table.Column <DateTime>(type: "timestamp with time zone", nullable: false), message = table.Column <string>(type: "text", nullable: false), json = table.Column <JsonDocument>(type: "jsonb", nullable: false) }, constraints: table => { table.PrimaryKey("PK_admin_log", x => new { x.admin_log_id, x.round_id }); table.ForeignKey( name: "FK_admin_log_round_round_id", column: x => x.round_id, principalTable: "round", principalColumn: "round_id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "player_round", columns: table => new { players_id = table.Column <int>(type: "integer", nullable: false), rounds_id = table.Column <int>(type: "integer", nullable: false) }, constraints: table => { table.PrimaryKey("PK_player_round", x => new { x.players_id, x.rounds_id }); table.ForeignKey( name: "FK_player_round_player_players_id", column: x => x.players_id, principalTable: "player", principalColumn: "player_id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_player_round_round_rounds_id", column: x => x.rounds_id, principalTable: "round", principalColumn: "round_id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "admin_log_entity", columns: table => new { uid = table.Column <int>(type: "integer", nullable: false) .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), name = table.Column <string>(type: "text", nullable: true), admin_log_id = table.Column <int>(type: "integer", nullable: true), admin_log_round_id = table.Column <int>(type: "integer", nullable: true) }, constraints: table => { table.PrimaryKey("PK_admin_log_entity", x => x.uid); table.ForeignKey( name: "FK_admin_log_entity_admin_log_admin_log_id_admin_log_round_id", columns: x => new { x.admin_log_id, x.admin_log_round_id }, principalTable: "admin_log", principalColumns: new[] { "admin_log_id", "round_id" }); }); migrationBuilder.CreateTable( name: "admin_log_player", columns: table => new { player_user_id = table.Column <Guid>(type: "uuid", nullable: false), log_id = table.Column <int>(type: "integer", nullable: false), round_id = table.Column <int>(type: "integer", nullable: false) }, constraints: table => { table.PrimaryKey("PK_admin_log_player", x => new { x.player_user_id, x.log_id, x.round_id }); table.ForeignKey( name: "FK_admin_log_player_admin_log_log_id_round_id", columns: x => new { x.log_id, x.round_id }, principalTable: "admin_log", principalColumns: new[] { "admin_log_id", "round_id" }, onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_admin_log_player_player_player_user_id", column: x => x.player_user_id, principalTable: "player", principalColumn: "user_id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_admin_log_round_id", table: "admin_log", column: "round_id"); migrationBuilder.CreateIndex( name: "IX_admin_log_type", table: "admin_log", column: "type"); migrationBuilder.CreateIndex( name: "IX_admin_log_entity_admin_log_id_admin_log_round_id", table: "admin_log_entity", columns: new[] { "admin_log_id", "admin_log_round_id" }); migrationBuilder.CreateIndex( name: "IX_admin_log_player_log_id_round_id", table: "admin_log_player", columns: new[] { "log_id", "round_id" }); migrationBuilder.CreateIndex( name: "IX_player_round_rounds_id", table: "player_round", column: "rounds_id"); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "MarkFromUserToConpany", table: "Ratings"); migrationBuilder.AlterColumn <DateTime>( name: "SendingDateTime", table: "Requests", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn <DateTime>( name: "ReceivingDateTime", table: "Requests", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn <int>( name: "CurrentLongitude", table: "Requests", nullable: true, oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn <int>( name: "CurrentLatitude", table: "Requests", nullable: true, oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn <int>( name: "MarkFromCompanyToUser", table: "Ratings", nullable: true, oldClrType: typeof(int), oldType: "int"); migrationBuilder.AddColumn <int>( name: "MarkFromUserToCompany", table: "Ratings", nullable: true); migrationBuilder.AlterColumn <string>( name: "Series", table: "Passports", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn <string>( name: "Number", table: "Passports", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn <DateTime>( name: "IssuedDate", table: "Passports", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn <DateTime>( name: "BirthDate", table: "Passports", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn <float>( name: "Width", table: "Goods", nullable: true, oldClrType: typeof(float), oldType: "real"); migrationBuilder.AlterColumn <float>( name: "Weight", table: "Goods", nullable: true, oldClrType: typeof(float), oldType: "real"); migrationBuilder.AlterColumn <float>( name: "Length", table: "Goods", nullable: true, oldClrType: typeof(float), oldType: "real"); migrationBuilder.AlterColumn <bool>( name: "IsFragile", table: "Goods", nullable: true, oldClrType: typeof(bool), oldType: "bit"); migrationBuilder.AlterColumn <float>( name: "Height", table: "Goods", nullable: true, oldClrType: typeof(float), oldType: "real"); migrationBuilder.AlterColumn <DateTime>( name: "RegistrationDate", table: "Companies", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn <DateTime>( name: "OgrnDate", table: "Companies", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AddUniqueConstraint( name: "AK_Passports_Series_Number", table: "Passports", columns: new[] { "Series", "Number" }); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_ApplicationRoleGroup_Groups_GroupId", table: "ApplicationRoleGroup"); migrationBuilder.DropForeignKey( name: "FK_ApplicationRoleGroup_AspNetRoles_RoleId", table: "ApplicationRoleGroup"); migrationBuilder.DropForeignKey( name: "FK_ApplicationUserGroup_Groups_GroupId", table: "ApplicationUserGroup"); migrationBuilder.DropForeignKey( name: "FK_ApplicationUserGroup_AspNetUsers_UserId1", table: "ApplicationUserGroup"); migrationBuilder.DropPrimaryKey( name: "PK_AspNetUserLogins", table: "AspNetUserLogins"); migrationBuilder.DropIndex( name: "IX_AspNetUserLogins_UserId", table: "AspNetUserLogins"); migrationBuilder.DropPrimaryKey( name: "PK_ApplicationUserGroup", table: "ApplicationUserGroup"); migrationBuilder.DropPrimaryKey( name: "PK_ApplicationRoleGroup", table: "ApplicationRoleGroup"); migrationBuilder.DropIndex( name: "IX_ApplicationRoleGroup_RoleId", table: "ApplicationRoleGroup"); migrationBuilder.RenameTable( name: "ApplicationUserGroup", newName: "ApplicationUserGroups"); migrationBuilder.RenameTable( name: "ApplicationRoleGroup", newName: "ApplicationRoleGroups"); migrationBuilder.RenameIndex( name: "IX_ApplicationUserGroup_UserId1", table: "ApplicationUserGroups", newName: "IX_ApplicationUserGroups_UserId1"); migrationBuilder.RenameIndex( name: "IX_ApplicationUserGroup_GroupId", table: "ApplicationUserGroups", newName: "IX_ApplicationUserGroups_GroupId"); migrationBuilder.RenameIndex( name: "IX_ApplicationRoleGroup_GroupId", table: "ApplicationRoleGroups", newName: "IX_ApplicationRoleGroups_GroupId"); migrationBuilder.AlterColumn <string>( name: "Name", table: "Groups", nullable: false, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "UserName", table: "AspNetUsers", maxLength: 256, nullable: false, oldClrType: typeof(string), oldMaxLength: 256, oldNullable: true); migrationBuilder.AlterColumn <string>( name: "Name", table: "AspNetRoles", maxLength: 256, nullable: false, oldClrType: typeof(string), oldMaxLength: 256, oldNullable: true); migrationBuilder.AlterColumn <string>( name: "RoleId", table: "ApplicationRoleGroups", nullable: false, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AddColumn <string>( name: "ApplicationUserId", table: "ApplicationRoleGroups", nullable: true); migrationBuilder.AddColumn <string>( name: "UserId", table: "ApplicationRoleGroups", nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_AspNetUserLogins_LoginProvider_ProviderKey", table: "AspNetUserLogins", columns: new[] { "LoginProvider", "ProviderKey" }); migrationBuilder.AddPrimaryKey( name: "PK_AspNetUserLogins", table: "AspNetUserLogins", columns: new[] { "UserId", "LoginProvider", "ProviderKey" }); migrationBuilder.AddUniqueConstraint( name: "AK_ApplicationUserGroups_UserId", table: "ApplicationUserGroups", column: "UserId"); migrationBuilder.AddPrimaryKey( name: "PK_ApplicationUserGroups", table: "ApplicationUserGroups", columns: new[] { "UserId", "GroupId" }); migrationBuilder.AddUniqueConstraint( name: "AK_ApplicationRoleGroups_Id", table: "ApplicationRoleGroups", column: "Id"); migrationBuilder.AddPrimaryKey( name: "PK_ApplicationRoleGroups", table: "ApplicationRoleGroups", columns: new[] { "RoleId", "GroupId" }); migrationBuilder.CreateIndex( name: "IX_ApplicationRoleGroups_ApplicationUserId", table: "ApplicationRoleGroups", column: "ApplicationUserId"); migrationBuilder.AddForeignKey( name: "FK_ApplicationRoleGroups_AspNetUsers_ApplicationUserId", table: "ApplicationRoleGroups", column: "ApplicationUserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ApplicationRoleGroups_Groups_GroupId", table: "ApplicationRoleGroups", column: "GroupId", principalTable: "Groups", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_ApplicationRoleGroups_AspNetRoles_RoleId", table: "ApplicationRoleGroups", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_ApplicationUserGroups_Groups_GroupId", table: "ApplicationUserGroups", column: "GroupId", principalTable: "Groups", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_ApplicationUserGroups_AspNetUsers_UserId1", table: "ApplicationUserGroups", column: "UserId1", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_CourseEnrollment_Metadata_MetaId", table: "CourseEnrollment"); migrationBuilder.DropForeignKey( name: "FK_CourseEnrollment_Sections_SectionId", table: "CourseEnrollment"); migrationBuilder.DropForeignKey( name: "FK_CourseEnrollment_Students_StudentId", table: "CourseEnrollment"); migrationBuilder.DropPrimaryKey( name: "PK_CourseEnrollment", table: "CourseEnrollment"); migrationBuilder.DropIndex( name: "IX_CourseEnrollment_StudentId", table: "CourseEnrollment"); migrationBuilder.RenameTable( name: "CourseEnrollment", newName: "CourseEnrollments"); migrationBuilder.RenameIndex( name: "IX_CourseEnrollment_SectionId", table: "CourseEnrollments", newName: "IX_CourseEnrollments_SectionId"); migrationBuilder.RenameIndex( name: "IX_CourseEnrollment_MetaId", table: "CourseEnrollments", newName: "IX_CourseEnrollments_MetaId"); migrationBuilder.AddPrimaryKey( name: "PK_CourseEnrollments", table: "CourseEnrollments", column: "Id"); migrationBuilder.AddUniqueConstraint( name: "AK_CourseEnrollments_StudentId_SectionId", table: "CourseEnrollments", columns: new[] { "StudentId", "SectionId" }); migrationBuilder.AddForeignKey( name: "FK_CourseEnrollments_Metadata_MetaId", table: "CourseEnrollments", column: "MetaId", principalTable: "Metadata", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_CourseEnrollments_Sections_SectionId", table: "CourseEnrollments", column: "SectionId", principalTable: "Sections", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_CourseEnrollments_Students_StudentId", table: "CourseEnrollments", column: "StudentId", principalTable: "Students", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Review_Movies_MovieId", table: "Review"); migrationBuilder.DropForeignKey( name: "FK_Review_UserDetails_UserDetailId", table: "Review"); migrationBuilder.DropUniqueConstraint( name: "AK_Review_MovieId_UserDetailId", table: "Review"); migrationBuilder.DropPrimaryKey( name: "PK_Review", table: "Review"); migrationBuilder.RenameTable( name: "Review", newName: "Reviews"); migrationBuilder.RenameIndex( name: "IX_Review_UserDetailId", table: "Reviews", newName: "IX_Reviews_UserDetailId"); migrationBuilder.RenameIndex( name: "IX_Review_MovieId", table: "Reviews", newName: "IX_Reviews_MovieId"); migrationBuilder.AddUniqueConstraint( name: "AK_Reviews_MovieId_UserDetailId", table: "Reviews", columns: new[] { "MovieId", "UserDetailId" }); migrationBuilder.AddPrimaryKey( name: "PK_Reviews", table: "Reviews", columns: new[] { "UserDetailId", "MovieId" }); migrationBuilder.CreateTable( name: "Payments", columns: table => new { PaymentId = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Pay = table.Column <double>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Payments", x => x.PaymentId); }); migrationBuilder.AddForeignKey( name: "FK_Reviews_Movies_MovieId", table: "Reviews", column: "MovieId", principalTable: "Movies", principalColumn: "MovieId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Reviews_UserDetails_UserDetailId", table: "Reviews", column: "UserDetailId", principalTable: "UserDetails", principalColumn: "UserDetailID", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Schedules_Employees_EmployeeId", table: "Schedules"); migrationBuilder.DropForeignKey( name: "FK_ScheduleBaseSettingses_Schedules_ScheduleId", table: "ScheduleBaseSettingses"); migrationBuilder.DropIndex( name: "IX_ScheduleBaseSettingses_ScheduleId", table: "ScheduleBaseSettingses"); migrationBuilder.DropIndex( name: "IX_Schedules_EmployeeId", table: "Schedules"); migrationBuilder.DropColumn( name: "ScheduleId", table: "ScheduleBaseSettingses"); migrationBuilder.DropColumn( name: "EmployeeId", table: "Schedules"); migrationBuilder.AddColumn <int>( name: "ScheduleBaseSettingsId", table: "Schedules", nullable: false, defaultValue: 0); migrationBuilder.AddColumn <int>( name: "ScheduleId", table: "Employees", nullable: false, defaultValue: 0); migrationBuilder.AddColumn <int>( name: "ScheduleId1", table: "Employees", nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_Employees_ScheduleId", table: "Employees", column: "ScheduleId"); migrationBuilder.CreateIndex( name: "IX_Schedules_ScheduleBaseSettingsId", table: "Schedules", column: "ScheduleBaseSettingsId"); migrationBuilder.CreateIndex( name: "IX_Employees_ScheduleId1", table: "Employees", column: "ScheduleId1"); migrationBuilder.AddForeignKey( name: "FK_Employees_Schedules_ScheduleId1", table: "Employees", column: "ScheduleId1", principalTable: "Schedules", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Schedules_ScheduleBaseSettingses_ScheduleBaseSettingsId", table: "Schedules", column: "ScheduleBaseSettingsId", principalTable: "ScheduleBaseSettingses", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_parent_address_student_master", table: "parent_address"); migrationBuilder.DropForeignKey( name: "FK_student_documents_student_master", table: "student_documents"); migrationBuilder.DropForeignKey( name: "FK_student_comments_student_master", table: "student_comments"); migrationBuilder.DropPrimaryKey( name: "PK_student_master", table: "student_master"); migrationBuilder.DropIndex( name: "IX_parent_address_tenant_id_school_id_student_id", table: "parent_address"); migrationBuilder.RenameColumn( name: "bus_No", table: "student_master", newName: "bus_no"); migrationBuilder.AlterColumn <double>( name: "credit_hours", table: "course", nullable: true, oldClrType: typeof(string), oldType: "nchar(5)", oldFixedLength: true, oldMaxLength: 5, oldNullable: true); migrationBuilder.AlterColumn <string>( name: "course_category", table: "course", unicode: false, maxLength: 8, nullable: true, comment: "'Core' or 'Elective'", oldClrType: typeof(string), oldType: "varchar(100)", oldUnicode: false, oldMaxLength: 100, oldNullable: true); migrationBuilder.AddColumn <string>( name: "standard", table: "course", unicode: false, maxLength: 50, nullable: true, comment: "choose between US Common Core library or school specific standards library."); migrationBuilder.AddColumn <string>( name: "standard_ref_no", table: "course", unicode: false, maxLength: 50, nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_student_master_tenant_id_school_id_student_guid", table: "student_master", columns: new[] { "tenant_id", "school_id", "student_guid" }); migrationBuilder.AddPrimaryKey( name: "PK_student_master_1", table: "student_master", columns: new[] { "tenant_id", "school_id", "student_id" }); migrationBuilder.CreateTable( name: "honor_rolls", columns: table => new { tenant_id = table.Column <Guid>(nullable: false), school_id = table.Column <int>(nullable: false), honor_roll_id = table.Column <int>(nullable: false), marking_period_id = table.Column <int>(nullable: false), honor_roll = table.Column <string>(unicode: false, maxLength: 20, nullable: true), breakoff = table.Column <int>(nullable: true), created_by = table.Column <string>(unicode: false, maxLength: 150, nullable: true), created_on = table.Column <DateTime>(type: "datetime", nullable: true), updated_by = table.Column <string>(unicode: false, maxLength: 150, nullable: true), updated_on = table.Column <DateTime>(type: "datetime", nullable: true) }, constraints: table => { table.PrimaryKey("PK_honor_rolls", x => new { x.tenant_id, x.school_id, x.honor_roll_id }); table.ForeignKey( name: "FK_honor_rolls_honor_rolls", columns: x => new { x.tenant_id, x.school_id, x.marking_period_id }, principalTable: "school_years", principalColumns: new[] { "tenant_id", "school_id", "marking_period_id" }, onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateIndex( name: "IX_student_master", table: "student_master", columns: new[] { "tenant_id", "school_id", "student_guid" }, unique: true); migrationBuilder.CreateIndex( name: "IX_student_enrollment_tenant_id_school_id_student_guid", table: "student_enrollment", columns: new[] { "tenant_id", "school_id", "student_guid" }); migrationBuilder.CreateIndex( name: "IX_honor_rolls_tenant_id_school_id_marking_period_id", table: "honor_rolls", columns: new[] { "tenant_id", "school_id", "marking_period_id" }); migrationBuilder.AddForeignKey( name: "FK_student_enrollment_student_master", table: "student_enrollment", columns: new[] { "tenant_id", "school_id", "student_guid" }, principalTable: "student_master", principalColumns: new[] { "tenant_id", "school_id", "student_guid" }, onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_student_documents_student_master", table: "student_documents", columns: new[] { "tenant_id", "school_id", "student_id" }, principalTable: "student_master", principalColumns: new[] { "tenant_id", "school_id", "student_id" }, onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_student_comments_student_master", table: "student_comments", columns: new[] { "tenant_id", "school_id", "student_id" }, principalTable: "student_master", principalColumns: new[] { "tenant_id", "school_id", "student_id" }, onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_RoomMessage_RoomUsers_RoomUserId", table: "RoomMessage"); migrationBuilder.DropIndex( name: "IX_RoomUsers_RoomId", table: "RoomUsers"); migrationBuilder.DropPrimaryKey( name: "PK_RoomMessage", table: "RoomMessage"); migrationBuilder.RenameTable( name: "RoomMessage", newName: "RoomMessages"); migrationBuilder.RenameIndex( name: "IX_RoomMessage_RoomUserId", table: "RoomMessages", newName: "IX_RoomMessages_RoomUserId"); migrationBuilder.AddColumn <int>( name: "RoomId", table: "RoomMessages", type: "INTEGER", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "TimeCreated", table: "RoomMessages", type: "TEXT", nullable: false, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)); migrationBuilder.AddUniqueConstraint( name: "AK_RoomUsers_RoomId_UserId", table: "RoomUsers", columns: new[] { "RoomId", "UserId" }); migrationBuilder.AddPrimaryKey( name: "PK_RoomMessages", table: "RoomMessages", column: "Id"); migrationBuilder.CreateIndex( name: "IX_RoomMessages_RoomId", table: "RoomMessages", column: "RoomId"); migrationBuilder.AddForeignKey( name: "FK_RoomMessages_Rooms_RoomId", table: "RoomMessages", column: "RoomId", principalTable: "Rooms", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_RoomMessages_RoomUsers_RoomUserId", table: "RoomMessages", column: "RoomUserId", principalTable: "RoomUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropPrimaryKey( name: "PK_UserRoles", table: "UserRoles"); migrationBuilder.DropUniqueConstraint( name: "AK_UserRoles_UserId_RoleId", table: "UserRoles"); migrationBuilder.DropUniqueConstraint( name: "AK_OrganizationItems_OrganizationId_ItemId", table: "OrganizationItems"); migrationBuilder.DropPrimaryKey( name: "PK_OrderItems", table: "OrderItems"); migrationBuilder.DropUniqueConstraint( name: "AK_OrderItems_OrderId_ItemId", table: "OrderItems"); migrationBuilder.DropPrimaryKey( name: "PK_InventoryItems", table: "InventoryItems"); migrationBuilder.DropUniqueConstraint( name: "AK_InventoryItems_InventoryId_ItemId", table: "InventoryItems"); migrationBuilder.AlterColumn <int>( name: "OrderItemId", table: "OrderItems", nullable: false, oldClrType: typeof(int), oldType: "int") .OldAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); migrationBuilder.AlterColumn <int>( name: "InventoryItemId", table: "InventoryItems", nullable: false, oldClrType: typeof(int), oldType: "int") .OldAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); migrationBuilder.AddUniqueConstraint( name: "AK_UserRoles_UserRoleId", table: "UserRoles", column: "UserRoleId"); migrationBuilder.AddPrimaryKey( name: "PK_UserRoles", table: "UserRoles", columns: new[] { "UserId", "RoleId" }); migrationBuilder.AddPrimaryKey( name: "PK_OrderItems", table: "OrderItems", columns: new[] { "OrderId", "ItemId" }); migrationBuilder.AddPrimaryKey( name: "PK_InventoryItems", table: "InventoryItems", columns: new[] { "InventoryId", "ItemId" }); migrationBuilder.CreateIndex( name: "IX_OrganizationItems_OrganizationId", table: "OrganizationItems", column: "OrganizationId"); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Reviews_Movies_MovieId", table: "Reviews"); migrationBuilder.DropForeignKey( name: "FK_Reviews_UserDetails_UserDetailId", table: "Reviews"); migrationBuilder.DropTable( name: "Payments"); migrationBuilder.DropUniqueConstraint( name: "AK_Reviews_MovieId_UserDetailId", table: "Reviews"); migrationBuilder.DropPrimaryKey( name: "PK_Reviews", table: "Reviews"); migrationBuilder.RenameTable( name: "Reviews", newName: "Review"); migrationBuilder.RenameIndex( name: "IX_Reviews_UserDetailId", table: "Review", newName: "IX_Review_UserDetailId"); migrationBuilder.RenameIndex( name: "IX_Reviews_MovieId", table: "Review", newName: "IX_Review_MovieId"); migrationBuilder.AddUniqueConstraint( name: "AK_Review_MovieId_UserDetailId", table: "Review", columns: new[] { "MovieId", "UserDetailId" }); migrationBuilder.AddPrimaryKey( name: "PK_Review", table: "Review", columns: new[] { "UserDetailId", "MovieId" }); migrationBuilder.AddForeignKey( name: "FK_Review_Movies_MovieId", table: "Review", column: "MovieId", principalTable: "Movies", principalColumn: "MovieId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Review_UserDetails_UserDetailId", table: "Review", column: "UserDetailId", principalTable: "UserDetails", principalColumn: "UserDetailID", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Configuration_User_UserId", table: "Configuration"); migrationBuilder.DropPrimaryKey( name: "PK_UserFile", table: "UserFile"); migrationBuilder.DropPrimaryKey( name: "PK_Configuration", table: "Configuration"); migrationBuilder.AddColumn <int>( name: "UserFileId", table: "UserFile", nullable: false, defaultValue: 0) .Annotation("SqlServer:Identity", "1, 1"); migrationBuilder.AlterColumn <int>( name: "UserId", table: "Configuration", nullable: false, oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AddColumn <int>( name: "ConfigurationId", table: "Configuration", nullable: false, defaultValue: 0) .Annotation("SqlServer:Identity", "1, 1"); migrationBuilder.AddPrimaryKey( name: "PK_UserFile", table: "UserFile", column: "UserFileId"); migrationBuilder.AddUniqueConstraint( name: "AK_UserFile_UserId_FileName", table: "UserFile", columns: new[] { "UserId", "FileName" }); migrationBuilder.AddPrimaryKey( name: "PK_Configuration", table: "Configuration", column: "ConfigurationId"); migrationBuilder.AddUniqueConstraint( name: "AK_Configuration_Group_Name_UserId", table: "Configuration", columns: new[] { "Group", "Name", "UserId" }); migrationBuilder.AddForeignKey( name: "FK_Configuration_User_UserId", table: "Configuration", column: "UserId", principalTable: "User", principalColumn: "UserId", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_AspNetRoleClaims_AspNetRoles_RoleId", table: "AspNetRoleClaims"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserClaims_AspNetUsers_UserId", table: "AspNetUserClaims"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserLogins_AspNetUsers_UserId", table: "AspNetUserLogins"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserRoles_AspNetUsers_UserId", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId", table: "AspNetUserTokens"); migrationBuilder.DropPrimaryKey( name: "PK_AspNetUsers", table: "AspNetUsers"); migrationBuilder.DropIndex( name: "EmailIndex", table: "AspNetUsers"); migrationBuilder.DropIndex( name: "UserNameIndex", table: "AspNetUsers"); migrationBuilder.DropPrimaryKey( name: "PK_AspNetUserClaims", table: "AspNetUserClaims"); migrationBuilder.DropIndex( name: "IX_AspNetUserClaims_UserId", table: "AspNetUserClaims"); migrationBuilder.DropPrimaryKey( name: "PK_AspNetRoleClaims", table: "AspNetRoleClaims"); migrationBuilder.DropIndex( name: "IX_AspNetRoleClaims_RoleId", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "ConcurrencyStamp", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "Email", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "EmailConfirmed", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "LockoutEnabled", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "LockoutEnd", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "NormalizedEmail", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "NormalizedUserName", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "PasswordHash", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "PhoneNumber", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "PhoneNumberConfirmed", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "SecurityStamp", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "TwoFactorEnabled", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "UserName", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "Id", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "ClaimType", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "ClaimValue", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "Id", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "ClaimType", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "ClaimValue", table: "AspNetRoleClaims"); migrationBuilder.RenameTable( name: "AspNetUsers", newName: "ApplicationUser"); migrationBuilder.RenameTable( name: "AspNetUserClaims", newName: "IdentityUserClaim<string>"); migrationBuilder.RenameTable( name: "AspNetRoleClaims", newName: "IdentityRoleClaim<string>"); migrationBuilder.RenameColumn( name: "AccessFailedCount", table: "ApplicationUser", newName: "TempId"); migrationBuilder.RenameColumn( name: "Id", table: "ApplicationUser", newName: "TempId4"); migrationBuilder.AddColumn <string>( name: "TempId2", table: "ApplicationUser", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "TempId3", table: "ApplicationUser", nullable: false, defaultValue: ""); migrationBuilder.AlterColumn <int>( name: "UserId", table: "IdentityUserClaim<string>", nullable: true, oldClrType: typeof(string)); migrationBuilder.AlterColumn <string>( name: "RoleId", table: "IdentityRoleClaim<string>", nullable: true, oldClrType: typeof(string)); migrationBuilder.AddUniqueConstraint( name: "AK_ApplicationUser_TempId", table: "ApplicationUser", column: "TempId"); migrationBuilder.AddUniqueConstraint( name: "AK_ApplicationUser_TempId2", table: "ApplicationUser", column: "TempId2"); migrationBuilder.AddUniqueConstraint( name: "AK_ApplicationUser_TempId3", table: "ApplicationUser", column: "TempId3"); migrationBuilder.AddUniqueConstraint( name: "AK_ApplicationUser_TempId4", table: "ApplicationUser", column: "TempId4"); migrationBuilder.AddForeignKey( name: "FK_AspNetUserLogins_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "ApplicationUser", principalColumn: "TempId2", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_AspNetUserRoles_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "ApplicationUser", principalColumn: "TempId3", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_AspNetUserTokens_ApplicationUser_UserId", table: "AspNetUserTokens", column: "UserId", principalTable: "ApplicationUser", principalColumn: "TempId4", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_AspNetRoles_RoleId", table: "IdentityRoleClaim<string>", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "IdentityUserClaim<string>", column: "UserId", principalTable: "ApplicationUser", principalColumn: "TempId", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddUniqueConstraint( name: "AK_Clube_ClubeId", table: "Clube", column: "ClubeId"); migrationBuilder.CreateTable( name: "Partida", columns: table => new { Id = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), PartidaId = table.Column <int>(nullable: false), Rodada = table.Column <int>(nullable: false), ClubeCasaId = table.Column <int>(nullable: false), ClubeCasaPosicao = table.Column <int>(nullable: false), ClubeVisitanteId = table.Column <int>(nullable: false), AproveitamentoClubeMandante = table.Column <string>(maxLength: 16, nullable: true), AproveitamentoClubeVisitante = table.Column <string>(maxLength: 16, nullable: true), ClubeVisitantePosicao = table.Column <int>(nullable: false), DataPartida = table.Column <DateTime>(nullable: false), LocalPartida = table.Column <string>(maxLength: 64, nullable: true), PartidaValida = table.Column <bool>(nullable: false), PlacarOficialMandante = table.Column <int>(nullable: false), PlacarOficialVisitante = table.Column <int>(nullable: false), UrlConfronto = table.Column <string>(maxLength: 256, nullable: true), UrlTransmissao = table.Column <string>(maxLength: 256, nullable: true), DataModificacao = table.Column <DateTime>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Partida", x => x.Id); table.ForeignKey( name: "FK_Partida_Clube_ClubeCasaId", column: x => x.ClubeCasaId, principalTable: "Clube", principalColumn: "ClubeId", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_Partida_Clube_ClubeVisitanteId", column: x => x.ClubeVisitanteId, principalTable: "Clube", principalColumn: "ClubeId"); }); migrationBuilder.CreateTable( name: "Transmissao", columns: table => new { TransmissaoId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), PartidaId = table.Column <int>(nullable: false), Label = table.Column <string>(maxLength: 128, nullable: true), Url = table.Column <string>(maxLength: 256, nullable: true), DataModificacao = table.Column <DateTime>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Transmissao", x => x.TransmissaoId); table.ForeignKey( name: "FK_Transmissao_Partida_PartidaId", column: x => x.PartidaId, principalTable: "Partida", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_Status_StatusId", table: "Status", column: "StatusId", unique: true); migrationBuilder.CreateIndex( name: "IX_Esquema_EsquemaId", table: "Esquema", column: "EsquemaId", unique: true); migrationBuilder.CreateIndex( name: "IX_Partida_ClubeCasaId", table: "Partida", column: "ClubeCasaId"); migrationBuilder.CreateIndex( name: "IX_Partida_ClubeVisitanteId", table: "Partida", column: "ClubeVisitanteId"); migrationBuilder.CreateIndex( name: "IX_Partida_PartidaId", table: "Partida", column: "PartidaId", unique: true); migrationBuilder.CreateIndex( name: "IX_Transmissao_PartidaId", table: "Transmissao", column: "PartidaId", unique: true); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_AspNetUserClaims_AspNetUsers_UserId", table: "AspNetUserClaims"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserLogins_AspNetUsers_UserId", table: "AspNetUserLogins"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserRoles_AspNetUsers_UserId", table: "AspNetUserRoles"); migrationBuilder.DropPrimaryKey( name: "PK_AspNetUsers", table: "AspNetUsers"); migrationBuilder.DropIndex( name: "UserNameIndex", table: "AspNetUsers"); migrationBuilder.DropIndex( name: "IX_AspNetUserRoles_UserId", table: "AspNetUserRoles"); migrationBuilder.DropIndex( name: "RoleNameIndex", table: "AspNetRoles"); migrationBuilder.RenameColumn( name: "Id", table: "AspNetUsers", newName: "ID"); migrationBuilder.AlterColumn <int>( name: "ID", table: "AspNetUsers", nullable: false, oldClrType: typeof(string)); migrationBuilder.AddColumn <string>( name: "Id", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "BirthDate", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Company", table: "AspNetUsers", nullable: true); migrationBuilder.AddColumn <string>( name: "FirstName", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "LastName", table: "AspNetUsers", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Position", table: "AspNetUsers", nullable: true); migrationBuilder.AddUniqueConstraint( name: "AK_AspNetUsers_ID", table: "AspNetUsers", column: "ID"); migrationBuilder.AddPrimaryKey( name: "PK_AspNetUsers", table: "AspNetUsers", column: "Id"); migrationBuilder.CreateTable( name: "Dealership", columns: table => new { ID = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Email = table.Column <string>(nullable: false), Name = table.Column <string>(nullable: false), PhoneNumber = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Dealership", x => x.ID); }); migrationBuilder.CreateIndex( name: "UserNameIndex", table: "AspNetUsers", column: "NormalizedUserName", unique: true, filter: "[NormalizedUserName] IS NOT NULL"); migrationBuilder.CreateIndex( name: "RoleNameIndex", table: "AspNetRoles", column: "NormalizedName", unique: true, filter: "[NormalizedName] IS NOT NULL"); migrationBuilder.AddForeignKey( name: "FK_AspNetUserClaims_AspNetUsers_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_AspNetUserLogins_AspNetUsers_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_AspNetUserRoles_AspNetUsers_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId", table: "AspNetUserTokens", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropIndex( name: "IX_Ratings_PostId", table: "Ratings"); migrationBuilder.AlterColumn <DateTime>( name: "UpdatedOn", table: "UserProfiles", type: "datetime2", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP", oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn <string>( name: "Id", table: "UserProfiles", type: "nvarchar(450)", nullable: false, defaultValue: "", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn <DateTime>( name: "CreatedOn", table: "UserProfiles", type: "datetime2", nullable: false, defaultValueSql: "CURRENT_TIMESTAMP", oldClrType: typeof(DateTime), oldType: "datetime2"); migrationBuilder.AlterColumn <string>( name: "UserId", table: "Ratings", type: "nvarchar(450)", nullable: false, defaultValue: "", oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn <string>( name: "AuthorId", table: "Posts", type: "nvarchar(450)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn <string>( name: "AuthorId", table: "Comments", type: "nvarchar(450)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AlterColumn <string>( name: "UserId", table: "AuthorVerifications", type: "nvarchar(450)", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)", oldNullable: true); migrationBuilder.AddColumn <string>( name: "Discriminator", table: "AspNetUsers", type: "nvarchar(max)", nullable: false, defaultValue: ""); migrationBuilder.AddPrimaryKey( name: "PK_UserProfiles", table: "UserProfiles", column: "Id"); migrationBuilder.AddUniqueConstraint( name: "AK_Ratings_PostId_UserId", table: "Ratings", columns: new[] { "PostId", "UserId" }); migrationBuilder.CreateIndex( name: "IX_Ratings_UserId", table: "Ratings", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_Posts_AuthorId", table: "Posts", column: "AuthorId"); migrationBuilder.CreateIndex( name: "IX_Comments_AuthorId", table: "Comments", column: "AuthorId"); migrationBuilder.CreateIndex( name: "IX_AuthorVerifications_UserId", table: "AuthorVerifications", column: "UserId"); migrationBuilder.AddForeignKey( name: "FK_AuthorVerifications_AspNetUsers_UserId", table: "AuthorVerifications", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Comments_AspNetUsers_AuthorId", table: "Comments", column: "AuthorId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.SetNull); migrationBuilder.AddForeignKey( name: "FK_Posts_AspNetUsers_AuthorId", table: "Posts", column: "AuthorId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.SetNull); migrationBuilder.AddForeignKey( name: "FK_Ratings_AspNetUsers_UserId", table: "Ratings", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_UserProfiles_AspNetUsers_Id", table: "UserProfiles", column: "Id", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "UserUseCase"); migrationBuilder.DeleteData( table: "UseCases", keyColumn: "Id", keyValue: 29); migrationBuilder.DeleteData( table: "UseCases", keyColumn: "Id", keyValue: 30); migrationBuilder.AddUniqueConstraint( name: "AK_Users_Username", table: "Users", column: "Username"); migrationBuilder.UpdateData( table: "Roles", keyColumn: "Id", keyValue: 1, column: "CreatedAt", value: new DateTime(2020, 6, 30, 19, 41, 41, 666, DateTimeKind.Utc).AddTicks(1315)); migrationBuilder.UpdateData( table: "Roles", keyColumn: "Id", keyValue: 2, column: "CreatedAt", value: new DateTime(2020, 6, 30, 19, 41, 41, 666, DateTimeKind.Utc).AddTicks(2874)); migrationBuilder.UpdateData( table: "Roles", keyColumn: "Id", keyValue: 3, column: "CreatedAt", value: new DateTime(2020, 6, 30, 19, 41, 41, 666, DateTimeKind.Utc).AddTicks(2901)); migrationBuilder.UpdateData( table: "Users", keyColumn: "Id", keyValue: 1, columns: new[] { "CreatedAt", "IsActive" }, values: new object[] { new DateTime(2020, 6, 30, 19, 41, 41, 666, DateTimeKind.Utc).AddTicks(5865), true }); migrationBuilder.UpdateData( table: "Users", keyColumn: "Id", keyValue: 2, columns: new[] { "CreatedAt", "IsActive" }, values: new object[] { new DateTime(2020, 6, 30, 19, 41, 41, 666, DateTimeKind.Utc).AddTicks(9975), true }); migrationBuilder.UpdateData( table: "Users", keyColumn: "Id", keyValue: 3, columns: new[] { "CreatedAt", "IsActive" }, values: new object[] { new DateTime(2020, 6, 30, 19, 41, 41, 667, DateTimeKind.Utc).AddTicks(47), true }); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropPrimaryKey( name: "PK_CRM_CustomerFile", table: "CRM_CustomerFile"); migrationBuilder.DropPrimaryKey( name: "PK_CRM_CustomerContact", table: "CRM_CustomerContact"); migrationBuilder.DropPrimaryKey( name: "PK_CRM_CustomerBrand", table: "CRM_CustomerBrand"); migrationBuilder.DropPrimaryKey( name: "PK_CRM_Customer", table: "CRM_Customer"); migrationBuilder.DropPrimaryKey( name: "PK_CRM_Brand", table: "CRM_Brand"); migrationBuilder.AddColumn <string>( name: "CountryCode", table: "CRM_CustomerFile", maxLength: 20, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "CountryCode", table: "CRM_CustomerContact", maxLength: 20, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "CountryCode", table: "CRM_CustomerBrand", maxLength: 20, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "CountryCode", table: "CRM_Customer", maxLength: 20, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "CountryCode", table: "CRM_Brand", maxLength: 20, nullable: false, defaultValue: ""); migrationBuilder.AddUniqueConstraint( name: "AK_CRM_CustomerFile_CountryCode_CustomerBrandId", table: "CRM_CustomerFile", columns: new[] { "CountryCode", "CustomerBrandId" }); migrationBuilder.AddPrimaryKey( name: "PK_CRM_CustomerFile", table: "CRM_CustomerFile", columns: new[] { "CustomerBrandId", "CountryCode" }); migrationBuilder.AddUniqueConstraint( name: "AK_CRM_CustomerContact_CountryCode_CustomerContactId", table: "CRM_CustomerContact", columns: new[] { "CountryCode", "CustomerContactId" }); migrationBuilder.AddPrimaryKey( name: "PK_CRM_CustomerContact", table: "CRM_CustomerContact", columns: new[] { "CustomerContactId", "CountryCode" }); migrationBuilder.AddUniqueConstraint( name: "AK_CRM_CustomerBrand_CountryCode_CustomerBrandId", table: "CRM_CustomerBrand", columns: new[] { "CountryCode", "CustomerBrandId" }); migrationBuilder.AddPrimaryKey( name: "PK_CRM_CustomerBrand", table: "CRM_CustomerBrand", columns: new[] { "CustomerBrandId", "CountryCode" }); migrationBuilder.AddUniqueConstraint( name: "AK_CRM_Customer_CountryCode_CustomerId", table: "CRM_Customer", columns: new[] { "CountryCode", "CustomerId" }); migrationBuilder.AddPrimaryKey( name: "PK_CRM_Customer", table: "CRM_Customer", columns: new[] { "CustomerId", "CountryCode" }); migrationBuilder.AddUniqueConstraint( name: "AK_CRM_Brand_CountryCode_BrandId", table: "CRM_Brand", columns: new[] { "CountryCode", "BrandId" }); migrationBuilder.AddPrimaryKey( name: "PK_CRM_Brand", table: "CRM_Brand", columns: new[] { "BrandId", "CountryCode" }); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserClaim<string>_Gebruiker_UserId", table: "AspNetUserClaims"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserLogin<string>_Gebruiker_UserId", table: "AspNetUserLogins"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserRole<string>_Gebruiker_UserId", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey(name: "FK_BestellingMateriaalItem_Bestelling_BestellingId", table: "BestellingMateriaalItem"); migrationBuilder.DropForeignKey(name: "FK_BestellingMateriaalItem_MateriaalItem_MateriaalItemId", table: "BestellingMateriaalItem"); migrationBuilder.DropForeignKey(name: "FK_MateriaalDoelgroep_Doelgroep_DoelgroepId", table: "MateriaalDoelgroep"); migrationBuilder.DropForeignKey(name: "FK_MateriaalDoelgroep_Materiaal_MateriaalId", table: "MateriaalDoelgroep"); migrationBuilder.DropForeignKey(name: "FK_MateriaalItem_Materiaal_MateriaalId", table: "MateriaalItem"); migrationBuilder.DropForeignKey(name: "FK_MateriaalLeergebied_Leergebied_LeergebiedId", table: "MateriaalLeergebied"); migrationBuilder.DropForeignKey(name: "FK_MateriaalLeergebied_Materiaal_MateriaalId", table: "MateriaalLeergebied"); migrationBuilder.DropForeignKey(name: "FK_MateriaalVerlanglijst_Materiaal_MateriaalId", table: "MateriaalVerlanglijst"); migrationBuilder.DropForeignKey(name: "FK_MateriaalVerlanglijst_Verlanglijst_VerlanglijstId", table: "MateriaalVerlanglijst"); migrationBuilder.DropForeignKey(name: "FK_Uitleeninformatie_MateriaalItem_MateriaalItemId", table: "Uitleeninformatie"); migrationBuilder.DropForeignKey(name: "FK_Verlanglijst_Gebruiker_GebruikerId1", table: "Verlanglijst"); migrationBuilder.DropColumn(name: "GebruikerId", table: "Verlanglijst"); migrationBuilder.DropColumn(name: "GebruikerId1", table: "Verlanglijst"); migrationBuilder.AddColumn<int>( name: "GebruikerForeignKey", table: "Verlanglijst", nullable: false, defaultValue: 0); migrationBuilder.AddColumn<int>( name: "GebruikerForeignKey", table: "AspNetUsers", nullable: false, defaultValue: 0); migrationBuilder.AddUniqueConstraint( name: "AK_Gebruiker_GebruikerForeignKey", table: "AspNetUsers", column: "GebruikerForeignKey"); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_Gebruiker_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_Gebruiker_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_Gebruiker_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_BestellingMateriaalItem_Bestelling_BestellingId", table: "BestellingMateriaalItem", column: "BestellingId", principalTable: "Bestelling", principalColumn: "BestellingId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_BestellingMateriaalItem_MateriaalItem_MateriaalItemId", table: "BestellingMateriaalItem", column: "MateriaalItemId", principalTable: "MateriaalItem", principalColumn: "MateriaalItemId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_MateriaalDoelgroep_Doelgroep_DoelgroepId", table: "MateriaalDoelgroep", column: "DoelgroepId", principalTable: "Doelgroep", principalColumn: "DoelgroepId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_MateriaalDoelgroep_Materiaal_MateriaalId", table: "MateriaalDoelgroep", column: "MateriaalId", principalTable: "Materiaal", principalColumn: "MateriaalId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_MateriaalItem_Materiaal_MateriaalId", table: "MateriaalItem", column: "MateriaalId", principalTable: "Materiaal", principalColumn: "MateriaalId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_MateriaalLeergebied_Leergebied_LeergebiedId", table: "MateriaalLeergebied", column: "LeergebiedId", principalTable: "Leergebied", principalColumn: "LeergebiedId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_MateriaalLeergebied_Materiaal_MateriaalId", table: "MateriaalLeergebied", column: "MateriaalId", principalTable: "Materiaal", principalColumn: "MateriaalId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_MateriaalVerlanglijst_Materiaal_MateriaalId", table: "MateriaalVerlanglijst", column: "MateriaalId", principalTable: "Materiaal", principalColumn: "MateriaalId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_MateriaalVerlanglijst_Verlanglijst_VerlanglijstId", table: "MateriaalVerlanglijst", column: "VerlanglijstId", principalTable: "Verlanglijst", principalColumn: "VerlanglijstId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Uitleeninformatie_MateriaalItem_MateriaalItemId", table: "Uitleeninformatie", column: "MateriaalItemId", principalTable: "MateriaalItem", principalColumn: "MateriaalItemId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Verlanglijst_Gebruiker_GebruikerForeignKey", table: "Verlanglijst", column: "GebruikerForeignKey", principalTable: "AspNetUsers", principalColumn: "GebruikerForeignKey", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddUniqueConstraint( name: "AK_Game_GameName", table: "Game", column: "GameName"); migrationBuilder.AddUniqueConstraint( name: "AK_Client_Email", table: "Client", column: "Email"); migrationBuilder.AddUniqueConstraint( name: "AK_Client_UserName", table: "Client", column: "UserName"); migrationBuilder.CreateTable( name: "OverviewType", columns: table => new { TypeID = table.Column <Guid>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_OverviewType", x => x.TypeID); }); migrationBuilder.CreateTable( name: "Overview", columns: table => new { OverviewID = table.Column <Guid>(nullable: false), GameID = table.Column <Guid>(nullable: false), TypeID = table.Column <Guid>(nullable: false), OverviewTypeTypeID = table.Column <Guid>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Overview", x => x.OverviewID); table.ForeignKey( name: "FK_Overview_Game_GameID", column: x => x.GameID, principalTable: "Game", principalColumn: "GameID", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_Overview_OverviewType_OverviewTypeTypeID", column: x => x.OverviewTypeTypeID, principalTable: "OverviewType", principalColumn: "TypeID", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateIndex( name: "IX_Overview_GameID", table: "Overview", column: "GameID"); migrationBuilder.CreateIndex( name: "IX_Overview_OverviewTypeTypeID", table: "Overview", column: "OverviewTypeTypeID"); }