protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_ReleaseBatchItem_ReleaseBatch_ReleaseBatchId", schema: "kraken", table: "ReleaseBatchItem"); migrationBuilder.DropForeignKey(name: "FK_ReleaseBatchLogo_ReleaseBatch_ReleaseBatchId", schema: "kraken", table: "ReleaseBatchLogo"); migrationBuilder.DropColumn(name: "IsLocked", schema: "kraken", table: "ReleaseBatch"); migrationBuilder.DropColumn(name: "LockComment", schema: "kraken", table: "ReleaseBatch"); migrationBuilder.DropColumn(name: "LockUserName", schema: "kraken", table: "ReleaseBatch"); migrationBuilder.AddForeignKey( name: "FK_ReleaseBatchItem_ReleaseBatch_ReleaseBatchId", schema: "kraken", table: "ReleaseBatchItem", column: "ReleaseBatchId", principalSchema: "kraken", principalTable: "ReleaseBatch", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ReleaseBatchLogo_ReleaseBatch_ReleaseBatchId", schema: "kraken", table: "ReleaseBatchLogo", column: "ReleaseBatchId", principalSchema: "kraken", principalTable: "ReleaseBatch", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Category_Article", table: "Article"); migrationBuilder.DropForeignKey(name: "FK_Section_Category", table: "Category"); migrationBuilder.AlterColumn<int>( name: "SectionId", table: "Section", nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); migrationBuilder.AddColumn<bool>( name: "IsDeleted", table: "Section", nullable: false, defaultValue: false); migrationBuilder.AddForeignKey( name: "FK_Category_Article", table: "Article", column: "CategoryId", principalTable: "Category", principalColumn: "CategoryId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Section_Category", table: "Category", column: "SectionId", principalTable: "Section", principalColumn: "SectionId", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_MenuItem_Category_CategoryId", table: "MenuItem"); migrationBuilder.DropForeignKey(name: "FK_OrderItem_Order_OrderId", table: "OrderItem"); migrationBuilder.AlterColumn<int>( name: "Id", table: "OrderItem", nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); migrationBuilder.AddColumn<decimal>( name: "Total", table: "Order", nullable: false, defaultValue: 0m); migrationBuilder.AddForeignKey( name: "FK_MenuItem_Category_CategoryId", table: "MenuItem", column: "CategoryId", principalTable: "Category", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_OrderItem_Order_OrderId", table: "OrderItem", column: "OrderId", principalTable: "Order", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn<string>( name: "DisplayName", table: "TestClasses", nullable: true); migrationBuilder.CreateIndex( name: "IX_Commits_ProjectId", table: "Commits", column: "ProjectId"); migrationBuilder.CreateIndex( name: "IX_Commits_UserId", table: "Commits", column: "UserId"); migrationBuilder.AddForeignKey( name: "FK_Commits_Projects_ProjectId", table: "Commits", column: "ProjectId", principalTable: "Projects", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Commits_Users_UserId", table: "Commits", column: "UserId", principalTable: "Users", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Category_Article", table: "Article"); migrationBuilder.AlterColumn<string>( name: "Url", table: "Section", nullable: false); migrationBuilder.AlterColumn<string>( name: "Title", table: "Section", nullable: false); migrationBuilder.AlterColumn<string>( name: "Url", table: "Category", nullable: false); migrationBuilder.AlterColumn<string>( name: "Title", table: "Category", nullable: false); migrationBuilder.AddForeignKey( name: "FK_Category_Article", table: "Article", column: "CategoryId", principalTable: "Category", principalColumn: "CategoryId", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Section_Category", table: "Category", column: "SectionId", principalTable: "Section", principalColumn: "SectionId", onDelete: ReferentialAction.Cascade); }
protected override void Up(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.CreateTable( name: "Event", columns: table => new { ID = table.Column<int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), CompleteAddress = table.Column<string>(nullable: true), EventEnd = table.Column<DateTime>(nullable: false), EventStart = table.Column<DateTime>(nullable: false), IsCurrent = table.Column<bool>(nullable: false), Name = table.Column<string>(nullable: true), SocialMediaHashtag = table.Column<string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Event", x => x.ID); }); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_OpeningHours_Shop_ShopId", table: "OpeningHours"); migrationBuilder.DropForeignKey(name: "FK_Prize_Shop_ShopId", table: "Prize"); migrationBuilder.DropForeignKey(name: "FK_Puzzle_Shop_ShopId", table: "Puzzle"); migrationBuilder.AddForeignKey( name: "FK_OpeningHours_Shop_ShopId", table: "OpeningHours", column: "ShopId", principalTable: "Shop", principalColumn: "ID", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Prize_Shop_ShopId", table: "Prize", column: "ShopId", principalTable: "Shop", principalColumn: "ID", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Puzzle_Shop_ShopId", table: "Puzzle", column: "ShopId", principalTable: "Shop", principalColumn: "ID", onDelete: ReferentialAction.Restrict); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_PriceHistory_Stock_StockId", table: "PriceHistory"); migrationBuilder.DropForeignKey(name: "FK_Txn_Stock_StockId", table: "Txn"); migrationBuilder.AlterColumn<decimal>( name: "Open", table: "PriceHistory", nullable: false); migrationBuilder.AlterColumn<decimal>( name: "Low", table: "PriceHistory", nullable: false); migrationBuilder.AlterColumn<decimal>( name: "High", table: "PriceHistory", nullable: false); migrationBuilder.AlterColumn<decimal>( name: "Close", table: "PriceHistory", nullable: false); migrationBuilder.AddForeignKey( name: "FK_PriceHistory_Stock_StockId", table: "PriceHistory", column: "StockId", principalTable: "Stock", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Txn_Stock_StockId", table: "Txn", column: "StockId", principalTable: "Stock", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Resource_ResourceType_ResourceTypeId", table: "Resource"); migrationBuilder.DropForeignKey(name: "FK_Resource_Supplier_SupplierId", table: "Resource"); migrationBuilder.DropForeignKey(name: "FK_Supplier_Address_AddressId", table: "Supplier"); migrationBuilder.AddForeignKey( name: "FK_Resource_ResourceType_ResourceTypeId", table: "Resource", column: "ResourceTypeId", principalTable: "ResourceType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Resource_Supplier_SupplierId", table: "Resource", column: "SupplierId", principalTable: "Supplier", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Supplier_Address_AddressId", table: "Supplier", column: "AddressId", principalTable: "Address", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Photo_Album_AlbumId", table: "Photo"); migrationBuilder.DropForeignKey(name: "FK_UserRole_Role_RoleId", table: "UserRole"); migrationBuilder.DropForeignKey(name: "FK_UserRole_User_UserId", table: "UserRole"); migrationBuilder.AddColumn<string>( name: "Throwaway", table: "Album", nullable: true); migrationBuilder.AddForeignKey( name: "FK_Photo_Album_AlbumId", table: "Photo", column: "AlbumId", principalTable: "Album", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_UserRole_Role_RoleId", table: "UserRole", column: "RoleId", principalTable: "Role", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_UserRole_User_UserId", table: "UserRole", column: "UserId", principalTable: "User", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Produto_Categoria_CategoriaID", table: "Produto"); migrationBuilder.DropForeignKey(name: "FK_ProdutoVenda_Produto_ProdutoID", table: "ProdutoVenda"); migrationBuilder.DropForeignKey(name: "FK_ProdutoVenda_Venda_VendaID", table: "ProdutoVenda"); migrationBuilder.DropColumn(name: "Discriminator", table: "Usuario"); migrationBuilder.DropColumn(name: "CPF", table: "Usuario"); migrationBuilder.DropColumn(name: "CNPJ", table: "Usuario"); migrationBuilder.AddForeignKey( name: "FK_Produto_Categoria_CategoriaID", table: "Produto", column: "CategoriaID", principalTable: "Categoria", principalColumn: "ID", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ProdutoVenda_Produto_ProdutoID", table: "ProdutoVenda", column: "ProdutoID", principalTable: "Produto", principalColumn: "ID", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ProdutoVenda_Venda_VendaID", table: "ProdutoVenda", column: "VendaID", principalTable: "Venda", principalColumn: "ID", onDelete: ReferentialAction.Restrict); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_SkillToTag_Skill_SkillId", schema: "skill", table: "SkillToTag"); migrationBuilder.DropForeignKey(name: "FK_SkillToTag_SkillTag_TagId", schema: "skill", table: "SkillToTag"); migrationBuilder.DropTable(name: "Comment", schema: "blog"); migrationBuilder.DropTable(name: "Entry", schema: "blog"); migrationBuilder.AddForeignKey( name: "FK_SkillToTag_Skill_SkillId", schema: "skill", table: "SkillToTag", column: "SkillId", principalSchema: "skill", principalTable: "Skill", principalColumn: "SkillId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_SkillToTag_SkillTag_TagId", schema: "skill", table: "SkillToTag", column: "TagId", principalSchema: "skill", principalTable: "Tag", principalColumn: "TagId", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Photo_Album_AlbumId", table: "Photo"); migrationBuilder.DropForeignKey(name: "FK_UserRole_Role_RoleId", table: "UserRole"); migrationBuilder.DropForeignKey(name: "FK_UserRole_User_UserId", table: "UserRole"); migrationBuilder.DropColumn(name: "Throwaway", table: "Album"); migrationBuilder.AddForeignKey( name: "FK_Photo_Album_AlbumId", table: "Photo", column: "AlbumId", principalTable: "Album", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_UserRole_Role_RoleId", table: "UserRole", column: "RoleId", principalTable: "Role", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_UserRole_User_UserId", table: "UserRole", column: "UserId", principalTable: "User", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Prize_Shop_ShopId", table: "Prize"); migrationBuilder.DropForeignKey(name: "FK_Puzzle_Shop_ShopId", table: "Puzzle"); migrationBuilder.AlterColumn<TimeSpan>( name: "Opening2", table: "OpeningHours", nullable: true); migrationBuilder.AlterColumn<TimeSpan>( name: "Opening1", table: "OpeningHours", nullable: true); migrationBuilder.AlterColumn<TimeSpan>( name: "Closing2", table: "OpeningHours", nullable: true); migrationBuilder.AlterColumn<TimeSpan>( name: "Closing1", table: "OpeningHours", nullable: true); migrationBuilder.AddForeignKey( name: "FK_Prize_Shop_ShopId", table: "Prize", column: "ShopId", principalTable: "Shop", principalColumn: "ID", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Puzzle_Shop_ShopId", table: "Puzzle", column: "ShopId", principalTable: "Shop", principalColumn: "ID", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Student_Teacher_TeacherID", table: "Student"); migrationBuilder.CreateTable( name: "School", columns: table => new { ID = table.Column<long>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Name = table.Column<string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_School", x => x.ID); }); migrationBuilder.AddColumn<long>( name: "SchoolID", table: "Teacher", nullable: false, defaultValue: 0L); migrationBuilder.AddForeignKey( name: "FK_Student_Teacher_TeacherID", table: "Student", column: "TeacherID", principalTable: "Teacher", principalColumn: "ID", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Teacher_School_SchoolID", table: "Teacher", column: "SchoolID", principalTable: "School", principalColumn: "ID", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Character_Planet_HomePlanetId", table: "Character"); migrationBuilder.CreateTable( name: "Species", columns: table => new { Id = table.Column<Guid>(nullable: false), Description = table.Column<string>(nullable: true), Name = table.Column<string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Species", x => x.Id); }); migrationBuilder.AddColumn<Guid>( name: "SpeciesId", table: "Character", nullable: true); migrationBuilder.AddForeignKey( name: "FK_Character_Planet_HomePlanetId", table: "Character", column: "HomePlanetId", principalTable: "Planet", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Character_Species_SpeciesId", table: "Character", column: "SpeciesId", principalTable: "Species", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateIndex( name: "IX_UserQuestionData_QuestionId", table: "UserQuestionData", column: "QuestionId"); migrationBuilder.CreateIndex( name: "IX_UserQuestionData_UserId", table: "UserQuestionData", column: "UserId"); migrationBuilder.AddForeignKey( name: "FK_UserQuestionData_Questions_QuestionId", table: "UserQuestionData", column: "QuestionId", principalTable: "Questions", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_UserQuestionData_Users_UserId", table: "UserQuestionData", column: "UserId", principalTable: "Users", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
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.DropColumn(name: "City", table: "AspNetUsers"); migrationBuilder.DropColumn(name: "State", table: "AspNetUsers"); migrationBuilder.DropTable("ToDo"); migrationBuilder.AlterColumn<string>( name: "UserId", table: "AspNetUserLogins", nullable: true); migrationBuilder.AlterColumn<string>( name: "UserId", table: "AspNetUserClaims", nullable: true); migrationBuilder.AlterColumn<string>( name: "RoleId", table: "AspNetRoleClaims", nullable: true); 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); }
protected override void Up(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.CreateTable( name: "Announcement", columns: table => new { ID = table.Column<int>(nullable: false), ExpiresOn = table.Column<DateTime>(nullable: false), Message = table.Column<string>(nullable: true), PublishOn = table.Column<DateTime>(nullable: false), Rank = table.Column<int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Announcement", x => x.ID); }); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Resource_ResourceType_ResourceTypeId", table: "Resource"); migrationBuilder.DropForeignKey(name: "FK_Resource_Supplier_SupplierId", table: "Resource"); migrationBuilder.CreateTable( name: "HousingDetail", columns: table => new { Id = table.Column<int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), OtherShelterInfo = table.Column<string>(nullable: true), PatientHasShelter = table.Column<bool>(nullable: false), ShelterIsIndoors = table.Column<bool>(nullable: false), ShelterIsSafe = table.Column<bool>(nullable: false), ShelterLocation = table.Column<string>(nullable: true), ShelterWithFamily = table.Column<bool>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_HousingDetail", x => x.Id); }); migrationBuilder.CreateTable( name: "QuestionAnswer", columns: table => new { Id = table.Column<int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), AnswerBool = table.Column<bool>(nullable: false), AnswerString = table.Column<string>(nullable: true), QuestionText = table.Column<string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_QuestionAnswer", x => x.Id); }); migrationBuilder.AddForeignKey( name: "FK_Resource_ResourceType_ResourceTypeId", table: "Resource", column: "ResourceTypeId", principalTable: "ResourceType", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Resource_Supplier_SupplierId", table: "Resource", column: "SupplierId", principalTable: "Supplier", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Supplier_Address_AddressId", table: "Supplier", column: "AddressId", principalTable: "Address", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(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.AddColumn<string>( name: "CompanyName", table: "Speaker", nullable: true); migrationBuilder.AddColumn<string>( name: "SponsorLevel", table: "Speaker", nullable: true); migrationBuilder.AlterColumn<int>( name: "ID", table: "Announcement", nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(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.CreateTable( name: "Products", columns: table => new { ID = table.Column<int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), PreviewUrl = table.Column<string>(nullable: true), Title = table.Column<string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Products", x => x.ID); }); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(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.CreateTable( name: "Project", columns: table => new { Id = table.Column<int>(nullable: false) .Annotation("Sqlite:Autoincrement", true), Name = table.Column<string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Project", x => x.Id); }); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(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.AlterColumn<string>( name: "UserId", table: "AspNetUserLogins", nullable: false); migrationBuilder.AlterColumn<string>( name: "UserId", table: "AspNetUserClaims", nullable: false); migrationBuilder.AlterColumn<string>( name: "RoleId", table: "AspNetRoleClaims", nullable: false); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_ChirpPost_ChirpUser_UserId", table: "ChirpPost"); migrationBuilder.DropForeignKey(name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserClaim<string>_ChirpUser_UserId", table: "AspNetUserClaims"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserLogin<string>_ChirpUser_UserId", table: "AspNetUserLogins"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey(name: "FK_IdentityUserRole<string>_ChirpUser_UserId", table: "AspNetUserRoles"); migrationBuilder.DropColumn(name: "HasProfilePicture", table: "AspNetUsers"); migrationBuilder.AlterColumn<int>( name: "UserId", table: "ChirpPost", nullable: false); migrationBuilder.AlterColumn<DateTime>( name: "PostTime", table: "ChirpPost", nullable: false); 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>_ChirpUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ChirpUser_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>_ChirpUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_TimeLog_Client_ClientId", table: "TimeLog"); migrationBuilder.DropForeignKey(name: "FK_TimeLog_User_UserId", table: "TimeLog"); migrationBuilder.CreateTable( name: "Invoice", columns: table => new { Id = table.Column<int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), ClientId = table.Column<int>(nullable: true), From = table.Column<DateTime>(nullable: false), InvoiceNumber = table.Column<int>(nullable: false), Paid = table.Column<bool>(nullable: false), To = table.Column<DateTime>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Invoice", x => x.Id); table.ForeignKey( name: "FK_Invoice_Client_ClientId", column: x => x.ClientId, principalTable: "Client", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.AddColumn<int>( name: "OnInvoiceId", table: "TimeLog", nullable: true); migrationBuilder.AddForeignKey( name: "FK_TimeLog_Client_ClientId", table: "TimeLog", column: "ClientId", principalTable: "Client", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_TimeLog_Invoice_OnInvoiceId", table: "TimeLog", column: "OnInvoiceId", principalTable: "Invoice", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_TimeLog_User_UserId", table: "TimeLog", column: "UserId", principalTable: "User", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(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.AddColumn<string>( name: "LastName", table: "User", nullable: true); migrationBuilder.AddColumn<DateTime>( name: "birthdate", table: "User", nullable: false, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(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.DropColumn(name: "ChineseSentenceExample", table: "Vocabulary"); migrationBuilder.AddColumn<string>( name: "Example", table: "Vocabulary", nullable: true); migrationBuilder.AddColumn<string>( name: "Pinyin", table: "Vocabulary", nullable: true); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
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.AlterColumn<int>( name: "Tolerance", table: "Resistor", nullable: false); migrationBuilder.AddColumn<int>( name: "Value", table: "Resistor", nullable: false, defaultValue: 0); 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); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Session_Speaker_SpeakerID", table: "Session"); 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.AddForeignKey( name: "FK_Session_Speaker_SpeakerID", table: "Session", column: "SpeakerID", principalTable: "Speaker", principalColumn: "ID", onDelete: ReferentialAction.Restrict); 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); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_AspNetRoleClaims_Role_RoleId1", table: "AspNetRoleClaims"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserClaims_AspNetUsers_UserId1", table: "AspNetUserClaims"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserRoles_Role_RoleId1", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserRoles_AspNetUsers_UserId1", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId1", table: "AspNetUserTokens"); migrationBuilder.DropForeignKey( name: "FK_Comments_UserPhotos_UserPhotoId", table: "Comments"); migrationBuilder.DropForeignKey( name: "FK_UserPhotos_Activities_ActivityId", table: "UserPhotos"); migrationBuilder.DropTable( name: "AppUserUsedPasswords"); migrationBuilder.DropTable( name: "Role"); migrationBuilder.DropPrimaryKey( name: "PK_UserPhotos", table: "UserPhotos"); migrationBuilder.DropIndex( name: "IX_UserPhotos_ActivityId", table: "UserPhotos"); migrationBuilder.DropIndex( name: "IX_AspNetUserTokens_UserId1", table: "AspNetUserTokens"); migrationBuilder.DropIndex( name: "IX_AspNetUserRoles_RoleId1", table: "AspNetUserRoles"); migrationBuilder.DropIndex( name: "IX_AspNetUserRoles_UserId1", table: "AspNetUserRoles"); migrationBuilder.DropIndex( name: "IX_AspNetUserClaims_UserId1", table: "AspNetUserClaims"); migrationBuilder.DropIndex( name: "IX_AspNetRoleClaims_RoleId1", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "alakyId", table: "UserPhotos"); migrationBuilder.DropColumn( name: "ActivityId", table: "UserPhotos"); migrationBuilder.DropColumn( name: "AccessTokenExpiresDateTime", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "AccessTokenHash", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "CreatedByBrowserName", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "CreatedByIp", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "CreatedByUserId", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "CreatedDateTime", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "Id", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "ModifiedByBrowserName", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "ModifiedByIp", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "ModifiedByUserId", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "ModifiedDateTime", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "RefreshTokenExpiresDateTime", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "RefreshTokenIdHash", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "RefreshTokenIdHashSource", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "UserId1", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "Discriminator", table: "AspNetUserTokens"); migrationBuilder.DropColumn( name: "IsActive", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "SerialNumber", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "CreatedByBrowserName", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "CreatedByIp", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "CreatedByUserId", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "CreatedDateTime", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "ModifiedByBrowserName", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "ModifiedByIp", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "ModifiedByUserId", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "ModifiedDateTime", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "RoleId1", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "UserId1", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "Discriminator", table: "AspNetUserRoles"); migrationBuilder.DropColumn( name: "CreatedByBrowserName", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "CreatedByIp", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "CreatedByUserId", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "CreatedDateTime", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "ModifiedByBrowserName", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "ModifiedByIp", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "ModifiedByUserId", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "ModifiedDateTime", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "UserId1", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "Discriminator", table: "AspNetUserClaims"); migrationBuilder.DropColumn( name: "CreatedByBrowserName", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "CreatedByIp", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "CreatedByUserId", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "CreatedDateTime", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "ModifiedByBrowserName", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "ModifiedByIp", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "ModifiedByUserId", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "ModifiedDateTime", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "RoleId1", table: "AspNetRoleClaims"); migrationBuilder.DropColumn( name: "Discriminator", table: "AspNetRoleClaims"); migrationBuilder.AddColumn <int>( name: "Id", table: "UserPhotos", type: "int", nullable: false, defaultValue: 0) .Annotation("SqlServer:Identity", "1, 1"); migrationBuilder.AlterColumn <int>( name: "UserPhotoId", table: "Comments", type: "int", nullable: true, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AddColumn <string>( name: "ImagePath", table: "Activities", type: "nvarchar(max)", nullable: true); migrationBuilder.AddPrimaryKey( name: "PK_UserPhotos", table: "UserPhotos", column: "Id"); migrationBuilder.AddForeignKey( name: "FK_Comments_UserPhotos_UserPhotoId", table: "Comments", column: "UserPhotoId", principalTable: "UserPhotos", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "BookAuthor", table: "BookCheckedOutModel"); migrationBuilder.DropColumn( name: "BookTitle", table: "BookCheckedOutModel"); migrationBuilder.RenameColumn( name: "BookYear", table: "BookCheckedOutModel", newName: "UserId"); migrationBuilder.RenameColumn( name: "BookToBeReturned", table: "BookCheckedOutModel", newName: "ReturnDate"); migrationBuilder.RenameColumn( name: "BookCheckedOutByLibrarian", table: "BookCheckedOutModel", newName: "LibrarianId"); migrationBuilder.RenameColumn( name: "BookCheckedOut", table: "BookCheckedOutModel", newName: "IssueDate"); migrationBuilder.RenameColumn( name: "BookBorrowedByUser", table: "BookCheckedOutModel", newName: "BookId"); migrationBuilder.RenameColumn( name: "BookCheckedOutId", table: "BookCheckedOutModel", newName: "CopyId"); migrationBuilder.DropColumn( name: "UserDOB", table: "UserModel"); migrationBuilder.AddColumn <DateTime>( name: "UserDOB", table: "UserModel", type: "datetime2", nullable: false); migrationBuilder.AddColumn <int>( name: "BookModelBookId", table: "BookCheckedOutModel", type: "int", nullable: true); migrationBuilder.AddColumn <int>( name: "LibrarianModelLibrarianId", table: "BookCheckedOutModel", type: "int", nullable: true); migrationBuilder.AddColumn <int>( name: "UserModelUserId", table: "BookCheckedOutModel", type: "int", nullable: true); migrationBuilder.CreateIndex( name: "IX_BookCheckedOutModel_BookModelBookId", table: "BookCheckedOutModel", column: "BookModelBookId"); migrationBuilder.CreateIndex( name: "IX_BookCheckedOutModel_LibrarianModelLibrarianId", table: "BookCheckedOutModel", column: "LibrarianModelLibrarianId"); migrationBuilder.CreateIndex( name: "IX_BookCheckedOutModel_UserModelUserId", table: "BookCheckedOutModel", column: "UserModelUserId"); migrationBuilder.AddForeignKey( name: "FK_BookCheckedOutModel_BookModel_BookModelBookId", table: "BookCheckedOutModel", column: "BookModelBookId", principalTable: "BookModel", principalColumn: "BookId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_BookCheckedOutModel_LibrarianModel_LibrarianModelLibrarianId", table: "BookCheckedOutModel", column: "LibrarianModelLibrarianId", principalTable: "LibrarianModel", principalColumn: "LibrarianId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_BookCheckedOutModel_UserModel_UserModelUserId", table: "BookCheckedOutModel", column: "UserModelUserId", principalTable: "UserModel", principalColumn: "UserId", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Comments_UserPhotos_UserPhotoId", table: "Comments"); migrationBuilder.DropPrimaryKey( name: "PK_UserPhotos", table: "UserPhotos"); migrationBuilder.DropColumn( name: "Id", table: "UserPhotos"); migrationBuilder.DropColumn( name: "ImagePath", table: "Activities"); migrationBuilder.AddColumn <string>( name: "alakyId", table: "UserPhotos", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <Guid>( name: "ActivityId", table: "UserPhotos", nullable: true); migrationBuilder.AlterColumn <string>( name: "UserPhotoId", table: "Comments", nullable: true, oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AddColumn <DateTimeOffset>( name: "AccessTokenExpiresDateTime", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "AccessTokenHash", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "CreatedByBrowserName", table: "AspNetUserTokens", maxLength: 1000, nullable: true); migrationBuilder.AddColumn <string>( name: "CreatedByIp", table: "AspNetUserTokens", maxLength: 255, nullable: true); migrationBuilder.AddColumn <int>( name: "CreatedByUserId", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "CreatedDateTime", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <int>( name: "Id", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "ModifiedByBrowserName", table: "AspNetUserTokens", maxLength: 1000, nullable: true); migrationBuilder.AddColumn <string>( name: "ModifiedByIp", table: "AspNetUserTokens", maxLength: 255, nullable: true); migrationBuilder.AddColumn <int>( name: "ModifiedByUserId", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "ModifiedDateTime", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <DateTimeOffset>( name: "RefreshTokenExpiresDateTime", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "RefreshTokenIdHash", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "RefreshTokenIdHashSource", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "UserId1", table: "AspNetUserTokens", nullable: true); migrationBuilder.AddColumn <string>( name: "Discriminator", table: "AspNetUserTokens", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <bool>( name: "IsActive", table: "AspNetUsers", nullable: false, defaultValue: false); migrationBuilder.AddColumn <string>( name: "SerialNumber", table: "AspNetUsers", nullable: true); migrationBuilder.AddColumn <string>( name: "CreatedByBrowserName", table: "AspNetUserRoles", maxLength: 1000, nullable: true); migrationBuilder.AddColumn <string>( name: "CreatedByIp", table: "AspNetUserRoles", maxLength: 255, nullable: true); migrationBuilder.AddColumn <int>( name: "CreatedByUserId", table: "AspNetUserRoles", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "CreatedDateTime", table: "AspNetUserRoles", nullable: true); migrationBuilder.AddColumn <string>( name: "ModifiedByBrowserName", table: "AspNetUserRoles", maxLength: 1000, nullable: true); migrationBuilder.AddColumn <string>( name: "ModifiedByIp", table: "AspNetUserRoles", maxLength: 255, nullable: true); migrationBuilder.AddColumn <int>( name: "ModifiedByUserId", table: "AspNetUserRoles", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "ModifiedDateTime", table: "AspNetUserRoles", nullable: true); migrationBuilder.AddColumn <string>( name: "RoleId1", table: "AspNetUserRoles", nullable: true); migrationBuilder.AddColumn <string>( name: "UserId1", table: "AspNetUserRoles", nullable: true); migrationBuilder.AddColumn <string>( name: "Discriminator", table: "AspNetUserRoles", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "CreatedByBrowserName", table: "AspNetUserClaims", maxLength: 1000, nullable: true); migrationBuilder.AddColumn <string>( name: "CreatedByIp", table: "AspNetUserClaims", maxLength: 255, nullable: true); migrationBuilder.AddColumn <int>( name: "CreatedByUserId", table: "AspNetUserClaims", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "CreatedDateTime", table: "AspNetUserClaims", nullable: true); migrationBuilder.AddColumn <string>( name: "ModifiedByBrowserName", table: "AspNetUserClaims", maxLength: 1000, nullable: true); migrationBuilder.AddColumn <string>( name: "ModifiedByIp", table: "AspNetUserClaims", maxLength: 255, nullable: true); migrationBuilder.AddColumn <int>( name: "ModifiedByUserId", table: "AspNetUserClaims", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "ModifiedDateTime", table: "AspNetUserClaims", nullable: true); migrationBuilder.AddColumn <string>( name: "UserId1", table: "AspNetUserClaims", nullable: true); migrationBuilder.AddColumn <string>( name: "Discriminator", table: "AspNetUserClaims", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "CreatedByBrowserName", table: "AspNetRoleClaims", maxLength: 1000, nullable: true); migrationBuilder.AddColumn <string>( name: "CreatedByIp", table: "AspNetRoleClaims", maxLength: 255, nullable: true); migrationBuilder.AddColumn <int>( name: "CreatedByUserId", table: "AspNetRoleClaims", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "CreatedDateTime", table: "AspNetRoleClaims", nullable: true); migrationBuilder.AddColumn <string>( name: "ModifiedByBrowserName", table: "AspNetRoleClaims", maxLength: 1000, nullable: true); migrationBuilder.AddColumn <string>( name: "ModifiedByIp", table: "AspNetRoleClaims", maxLength: 255, nullable: true); migrationBuilder.AddColumn <int>( name: "ModifiedByUserId", table: "AspNetRoleClaims", nullable: true); migrationBuilder.AddColumn <DateTime>( name: "ModifiedDateTime", table: "AspNetRoleClaims", nullable: true); migrationBuilder.AddColumn <string>( name: "RoleId1", table: "AspNetRoleClaims", nullable: true); migrationBuilder.AddColumn <string>( name: "Discriminator", table: "AspNetRoleClaims", nullable: false, defaultValue: ""); migrationBuilder.AddPrimaryKey( name: "PK_UserPhotos", table: "UserPhotos", column: "alakyId"); migrationBuilder.CreateTable( name: "AppUserUsedPasswords", columns: table => new { Id = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), HashedPassword = table.Column <string>(maxLength: 450, nullable: false), UserId = table.Column <string>(nullable: true), CreatedByBrowserName = table.Column <string>(maxLength: 1000, nullable: true), CreatedByIp = table.Column <string>(maxLength: 255, nullable: true), CreatedByUserId = table.Column <int>(nullable: true), CreatedDateTime = table.Column <DateTime>(nullable: true), ModifiedByBrowserName = table.Column <string>(maxLength: 1000, nullable: true), ModifiedByIp = table.Column <string>(maxLength: 255, nullable: true), ModifiedByUserId = table.Column <int>(nullable: true), ModifiedDateTime = table.Column <DateTime>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_AppUserUsedPasswords", x => x.Id); table.ForeignKey( name: "FK_AppUserUsedPasswords_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "Role", columns: table => new { Id = table.Column <string>(nullable: false), Name = table.Column <string>(nullable: true), NormalizedName = table.Column <string>(nullable: true), ConcurrencyStamp = table.Column <string>(nullable: true), Description = table.Column <string>(nullable: true), CreatedByBrowserName = table.Column <string>(maxLength: 1000, nullable: true), CreatedByIp = table.Column <string>(maxLength: 255, nullable: true), CreatedByUserId = table.Column <int>(nullable: true), CreatedDateTime = table.Column <DateTime>(nullable: true), ModifiedByBrowserName = table.Column <string>(maxLength: 1000, nullable: true), ModifiedByIp = table.Column <string>(maxLength: 255, nullable: true), ModifiedByUserId = table.Column <int>(nullable: true), ModifiedDateTime = table.Column <DateTime>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Role", x => x.Id); }); migrationBuilder.CreateIndex( name: "IX_UserPhotos_ActivityId", table: "UserPhotos", column: "ActivityId"); migrationBuilder.CreateIndex( name: "IX_AspNetUserTokens_UserId1", table: "AspNetUserTokens", column: "UserId1"); migrationBuilder.CreateIndex( name: "IX_AspNetUserRoles_RoleId1", table: "AspNetUserRoles", column: "RoleId1"); migrationBuilder.CreateIndex( name: "IX_AspNetUserRoles_UserId1", table: "AspNetUserRoles", column: "UserId1"); migrationBuilder.CreateIndex( name: "IX_AspNetUserClaims_UserId1", table: "AspNetUserClaims", column: "UserId1"); migrationBuilder.CreateIndex( name: "IX_AspNetRoleClaims_RoleId1", table: "AspNetRoleClaims", column: "RoleId1"); migrationBuilder.CreateIndex( name: "IX_AppUserUsedPasswords_UserId", table: "AppUserUsedPasswords", column: "UserId"); migrationBuilder.AddForeignKey( name: "FK_AspNetRoleClaims_Role_RoleId1", table: "AspNetRoleClaims", column: "RoleId1", principalTable: "Role", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_AspNetUserClaims_AspNetUsers_UserId1", table: "AspNetUserClaims", column: "UserId1", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_AspNetUserRoles_Role_RoleId1", table: "AspNetUserRoles", column: "RoleId1", principalTable: "Role", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_AspNetUserRoles_AspNetUsers_UserId1", table: "AspNetUserRoles", column: "UserId1", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId1", table: "AspNetUserTokens", column: "UserId1", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Comments_UserPhotos_UserPhotoId", table: "Comments", column: "UserPhotoId", principalTable: "UserPhotos", principalColumn: "alakyId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_UserPhotos_Activities_ActivityId", table: "UserPhotos", column: "ActivityId", principalTable: "Activities", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "Imagems", columns: table => new { ImagemId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Foto = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Imagems", x => x.ImagemId); }); migrationBuilder.CreateTable( name: "Imovels", columns: table => new { ImovelId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), NomeImovel = table.Column <string>(nullable: false), Cidade = table.Column <string>(nullable: true), Estado = table.Column <string>(nullable: true), Bairro = table.Column <string>(nullable: false), Rua = table.Column <string>(nullable: false), Numero = table.Column <int>(nullable: false), Cep = table.Column <int>(nullable: false), Status = table.Column <bool>(nullable: false), ContratoId = table.Column <int>(nullable: true), ImovelId1 = table.Column <int>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Imovels", x => x.ImovelId); table.ForeignKey( name: "FK_Imovels_Imovels_ImovelId1", column: x => x.ImovelId1, principalTable: "Imovels", principalColumn: "ImovelId", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "Locadores", columns: table => new { LocadorId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Nome = table.Column <string>(nullable: false), SobreNome = table.Column <string>(nullable: false), Cpf = table.Column <decimal>(nullable: false), Rg = table.Column <decimal>(nullable: false), OrgaoEmissor = table.Column <string>(nullable: false), Profissao = table.Column <string>(nullable: false), EstadoCivil = table.Column <int>(nullable: false), Email = table.Column <string>(nullable: false), Tel = table.Column <decimal>(nullable: false), TelTestemunha = table.Column <decimal>(nullable: false), Status = table.Column <bool>(nullable: false), ContratoId = table.Column <int>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Locadores", x => x.LocadorId); }); migrationBuilder.CreateTable( name: "Locatarios", columns: table => new { LocatarioId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Nome = table.Column <string>(nullable: false), SobreNome = table.Column <string>(nullable: false), Cpf = table.Column <decimal>(nullable: false), Rg = table.Column <decimal>(nullable: false), OrgaoEmissor = table.Column <string>(nullable: false), Profissao = table.Column <string>(nullable: false), EstadoCivil = table.Column <int>(nullable: false), Email = table.Column <string>(nullable: false), Tel = table.Column <decimal>(nullable: false), TelTestemunha = table.Column <decimal>(nullable: false), Status = table.Column <bool>(nullable: false), ContratoId = table.Column <int>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Locatarios", x => x.LocatarioId); }); migrationBuilder.CreateTable( name: "Contratos", columns: table => new { ContratoId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), LocadorId = table.Column <int>(nullable: false), LocatarioId = table.Column <int>(nullable: false), imovelId = table.Column <int>(nullable: false), DataContrato = table.Column <DateTime>(nullable: false), DiaVencimentoAlguel = table.Column <DateTime>(nullable: false), DataInicio = table.Column <DateTime>(nullable: false), DataFim = table.Column <DateTime>(nullable: false), Status = table.Column <bool>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Contratos", x => x.ContratoId); table.ForeignKey( name: "FK_Contratos_Locadores_LocadorId", column: x => x.LocadorId, principalTable: "Locadores", principalColumn: "LocadorId", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_Contratos_Locatarios_LocatarioId", column: x => x.LocatarioId, principalTable: "Locatarios", principalColumn: "LocatarioId", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_Contratos_Imovels_imovelId", column: x => x.imovelId, principalTable: "Imovels", principalColumn: "ImovelId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_Contratos_LocadorId", table: "Contratos", column: "LocadorId"); migrationBuilder.CreateIndex( name: "IX_Contratos_LocatarioId", table: "Contratos", column: "LocatarioId"); migrationBuilder.CreateIndex( name: "IX_Contratos_imovelId", table: "Contratos", column: "imovelId"); migrationBuilder.CreateIndex( name: "IX_Imovels_ContratoId", table: "Imovels", column: "ContratoId"); migrationBuilder.CreateIndex( name: "IX_Imovels_ImovelId1", table: "Imovels", column: "ImovelId1"); migrationBuilder.CreateIndex( name: "IX_Locadores_ContratoId", table: "Locadores", column: "ContratoId"); migrationBuilder.CreateIndex( name: "IX_Locatarios_ContratoId", table: "Locatarios", column: "ContratoId"); migrationBuilder.AddForeignKey( name: "FK_Imovels_Contratos_ContratoId", table: "Imovels", column: "ContratoId", principalTable: "Contratos", principalColumn: "ContratoId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Locadores_Contratos_ContratoId", table: "Locadores", column: "ContratoId", principalTable: "Contratos", principalColumn: "ContratoId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Locatarios_Contratos_ContratoId", table: "Locatarios", column: "ContratoId", principalTable: "Contratos", principalColumn: "ContratoId", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Services_ServiceItems_ServiceItemId", table: "Services"); migrationBuilder.DropIndex( name: "IX_Services_ServiceItemId", table: "Services"); migrationBuilder.DropColumn( name: "ServiceItemId", table: "Services"); migrationBuilder.DropColumn( name: "Description", table: "ServiceItems"); migrationBuilder.DropColumn( name: "Image", table: "ServiceItems"); migrationBuilder.DropColumn( name: "ShortDescription", table: "ServiceItems"); migrationBuilder.DropColumn( name: "ShortText", table: "ServiceItems"); migrationBuilder.AlterColumn <string>( name: "Logo", table: "Services", nullable: false, oldClrType: typeof(string), oldType: "nvarchar(50)", oldMaxLength: 50); migrationBuilder.AddColumn <string>( name: "Description", table: "Services", maxLength: 200, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "EndPoint", table: "Services", maxLength: 200, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Image", table: "Services", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Slogan", table: "Services", maxLength: 200, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Text", table: "Services", maxLength: 500, nullable: false, defaultValue: ""); migrationBuilder.AlterColumn <string>( name: "Text", table: "ServiceItems", maxLength: 500, nullable: false, oldClrType: typeof(string), oldType: "nvarchar(200)", oldMaxLength: 200); migrationBuilder.AddColumn <string>( name: "Logo", table: "ServiceItems", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Name", table: "ServiceItems", maxLength: 50, nullable: false, defaultValue: ""); migrationBuilder.AddColumn <int>( name: "ServiceId", table: "ServiceItems", nullable: false, defaultValue: 0); migrationBuilder.CreateIndex( name: "IX_ServiceSpecs_ServiceId", table: "ServiceSpecs", column: "ServiceId"); migrationBuilder.CreateIndex( name: "IX_ServiceItems_ServiceId", table: "ServiceItems", column: "ServiceId"); migrationBuilder.AddForeignKey( name: "FK_ServiceItems_Services_ServiceId", table: "ServiceItems", column: "ServiceId", principalTable: "Services", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_ServiceSpecs_Services_ServiceId", table: "ServiceSpecs", column: "ServiceId", principalTable: "Services", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Insurances_AspNetUsers_IDUser", table: "Insurances"); migrationBuilder.DropForeignKey( name: "FK_PolicyDetails_AspNetUsers_IDUser", table: "PolicyDetails"); migrationBuilder.DropForeignKey( name: "FK_PolicyDetails_PriceLists_IDTypeInsurance", table: "PolicyDetails"); migrationBuilder.DropIndex( name: "IX_PolicyDetails_IDTypeInsurance", table: "PolicyDetails"); migrationBuilder.DropIndex( name: "IX_PolicyDetails_IDUser", table: "PolicyDetails"); migrationBuilder.DropIndex( name: "IX_Insurances_IDUser", table: "Insurances"); migrationBuilder.DropColumn( name: "IDTypeInsurance", table: "PolicyDetails"); migrationBuilder.DropColumn( name: "IDUser", table: "PolicyDetails"); migrationBuilder.DropColumn( name: "IDUser", table: "Insurances"); migrationBuilder.RenameColumn( name: "IDTypeInsurance", table: "PriceLists", newName: "IDPriceList"); migrationBuilder.AddColumn <int>( name: "IDForm", table: "Insurances", type: "int", nullable: false, defaultValue: 0); migrationBuilder.AddColumn <int>( name: "IDPriceList", table: "Insurances", type: "int", nullable: false, defaultValue: 0); migrationBuilder.CreateTable( name: "Forms", columns: table => new { IDForm = table.Column <int>(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), IDPolicyDetails = table.Column <int>(type: "int", nullable: false), IDUser = table.Column <string>(type: "nvarchar(450)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Forms", x => x.IDForm); table.ForeignKey( name: "FK_Forms_AspNetUsers_IDUser", column: x => x.IDUser, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_Forms_PolicyDetails_IDPolicyDetails", column: x => x.IDPolicyDetails, principalTable: "PolicyDetails", principalColumn: "IDPolicyDetails", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_Insurances_IDForm", table: "Insurances", column: "IDForm"); migrationBuilder.CreateIndex( name: "IX_Insurances_IDPriceList", table: "Insurances", column: "IDPriceList"); migrationBuilder.CreateIndex( name: "IX_Forms_IDPolicyDetails", table: "Forms", column: "IDPolicyDetails"); migrationBuilder.CreateIndex( name: "IX_Forms_IDUser", table: "Forms", column: "IDUser"); migrationBuilder.AddForeignKey( name: "FK_Insurances_Forms_IDForm", table: "Insurances", column: "IDForm", principalTable: "Forms", principalColumn: "IDForm", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Insurances_PriceLists_IDPriceList", table: "Insurances", column: "IDPriceList", principalTable: "PriceLists", principalColumn: "IDPriceList", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_ATMSources_ATMs_TradePointId", table: "ATMSources"); migrationBuilder.DropForeignKey( name: "FK_InfoKioskSources_InfoKiosks_TradePointId", table: "InfoKioskSources"); migrationBuilder.DropForeignKey( name: "FK_OfficeSources_Offices_TradePointId", table: "OfficeSources"); migrationBuilder.DropIndex( name: "IX_OfficeSources_TradePointId", table: "OfficeSources"); migrationBuilder.DropIndex( name: "IX_InfoKioskSources_TradePointId", table: "InfoKioskSources"); migrationBuilder.DropIndex( name: "IX_ATMSources_TradePointId", table: "ATMSources"); migrationBuilder.DropColumn( name: "TradePointId", table: "OfficeSources"); migrationBuilder.DropColumn( name: "TradePointId", table: "InfoKioskSources"); migrationBuilder.DropColumn( name: "TradePointId", table: "ATMSources"); migrationBuilder.AddColumn<string>( name: "SourceDataFileType", table: "Offices", nullable: true); migrationBuilder.AddColumn<Guid>( name: "SourceTradePointSourceId", table: "Offices", nullable: true); migrationBuilder.AddColumn<string>( name: "SourceDataFileType", table: "InfoKiosks", nullable: true); migrationBuilder.AddColumn<Guid>( name: "SourceTradePointSourceId", table: "InfoKiosks", nullable: true); migrationBuilder.AddColumn<string>( name: "SourceDataFileType", table: "ATMs", nullable: true); migrationBuilder.AddColumn<Guid>( name: "SourceTradePointSourceId", table: "ATMs", nullable: true); migrationBuilder.CreateIndex( name: "IX_Offices_SourceTradePointSourceId_SourceDataFileType", table: "Offices", columns: new[] { "SourceTradePointSourceId", "SourceDataFileType" }, unique: true, filter: "[SourceTradePointSourceId] IS NOT NULL AND [SourceDataFileType] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_InfoKiosks_SourceTradePointSourceId_SourceDataFileType", table: "InfoKiosks", columns: new[] { "SourceTradePointSourceId", "SourceDataFileType" }, unique: true, filter: "[SourceTradePointSourceId] IS NOT NULL AND [SourceDataFileType] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_ATMs_SourceTradePointSourceId_SourceDataFileType", table: "ATMs", columns: new[] { "SourceTradePointSourceId", "SourceDataFileType" }, unique: true, filter: "[SourceTradePointSourceId] IS NOT NULL AND [SourceDataFileType] IS NOT NULL"); migrationBuilder.AddForeignKey( name: "FK_ATMs_ATMSources_SourceTradePointSourceId_SourceDataFileType", table: "ATMs", columns: new[] { "SourceTradePointSourceId", "SourceDataFileType" }, principalTable: "ATMSources", principalColumns: new[] { "TradePointSourceId", "DataFileType" }, onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_InfoKiosks_InfoKioskSources_SourceTradePointSourceId_SourceDataFileType", table: "InfoKiosks", columns: new[] { "SourceTradePointSourceId", "SourceDataFileType" }, principalTable: "InfoKioskSources", principalColumns: new[] { "TradePointSourceId", "DataFileType" }, onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Offices_OfficeSources_SourceTradePointSourceId_SourceDataFileType", table: "Offices", columns: new[] { "SourceTradePointSourceId", "SourceDataFileType" }, principalTable: "OfficeSources", principalColumns: new[] { "TradePointSourceId", "DataFileType" }, onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropIndex( name: "UserNameIndex", table: "AspNetUsers"); migrationBuilder.DropIndex( name: "IX_AspNetUserRoles_UserId", table: "AspNetUserRoles"); migrationBuilder.DropIndex( name: "RoleNameIndex", table: "AspNetRoles"); migrationBuilder.CreateTable( name: "Genres", columns: table => new { Id = table.Column <byte>(nullable: false), Name = table.Column <string>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Genres", x => x.Id); }); migrationBuilder.CreateTable( name: "MembershipTypes", columns: table => new { Id = table.Column <byte>(nullable: false), DiscountRate = table.Column <byte>(nullable: false), DurationInMonths = table.Column <byte>(nullable: false), Name = table.Column <string>(nullable: false), SignUpFee = table.Column <short>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_MembershipTypes", x => x.Id); }); migrationBuilder.CreateTable( name: "Movies", columns: table => new { Id = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), DateAdded = table.Column <DateTime>(nullable: false), GenreId = table.Column <byte>(nullable: false), Name = table.Column <string>(nullable: false), NumberInStock = table.Column <short>(nullable: false), ReleaseDate = table.Column <DateTime>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Movies", x => x.Id); table.ForeignKey( name: "FK_Movies_Genres_GenreId", column: x => x.GenreId, principalTable: "Genres", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "Customers", columns: table => new { Id = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Birthday = table.Column <DateTime>(nullable: true), IsSubscribedToNewsletter = table.Column <bool>(nullable: false), MembershipTypeId = table.Column <byte>(nullable: false), Name = table.Column <string>(maxLength: 255, nullable: false) }, constraints: table => { table.PrimaryKey("PK_Customers", x => x.Id); table.ForeignKey( name: "FK_Customers_MembershipTypes_MembershipTypeId", column: x => x.MembershipTypeId, principalTable: "MembershipTypes", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); 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.CreateIndex( name: "IX_Customers_MembershipTypeId", table: "Customers", column: "MembershipTypeId"); migrationBuilder.CreateIndex( name: "IX_Movies_GenreId", table: "Movies", column: "GenreId"); 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.DropForeignKey( name: "FK_Hotels_Addresses_AddressId", table: "Hotels"); migrationBuilder.DropForeignKey( name: "FK_Hotels_Amenities_AmenityId", table: "Hotels"); migrationBuilder.DropForeignKey( name: "FK_Hotels_Infos_InfoId", table: "Hotels"); migrationBuilder.AlterColumn <int>( name: "InfoId", table: "Hotels", type: "int", nullable: false, oldClrType: typeof(int), oldNullable: true); migrationBuilder.AlterColumn <int>( name: "AmenityId", table: "Hotels", type: "int", nullable: false, oldClrType: typeof(int), oldNullable: true); migrationBuilder.AlterColumn <int>( name: "AddressId", table: "Hotels", type: "int", nullable: false, oldClrType: typeof(int), oldNullable: true); migrationBuilder.AddColumn <int>( name: "ReviewId", table: "Hotels", type: "int", nullable: true); migrationBuilder.AddColumn <int>( name: "RoomId", table: "Hotels", type: "int", nullable: false, defaultValue: 0); migrationBuilder.AddColumn <int>( name: "StayId", table: "Hotels", type: "int", nullable: true); migrationBuilder.AddForeignKey( name: "FK_Hotels_Addresses_AddressId", table: "Hotels", column: "AddressId", principalTable: "Addresses", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Hotels_Amenities_AmenityId", table: "Hotels", column: "AmenityId", principalTable: "Amenities", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Hotels_Infos_InfoId", table: "Hotels", column: "InfoId", principalTable: "Infos", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_GamesRates_Games_GameId", table: "GamesRates"); migrationBuilder.DropPrimaryKey( name: "PK_GamesRates", table: "GamesRates"); migrationBuilder.DropPrimaryKey( name: "PK_Games", table: "Games"); migrationBuilder.DropColumn( name: "GameRateId", table: "GamesRates"); migrationBuilder.DropColumn( name: "GameId", table: "Games"); migrationBuilder.AlterColumn <int>( name: "GameId", table: "GamesRates", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(450)", oldNullable: true); migrationBuilder.AddColumn <int>( name: "Id", table: "GamesRates", nullable: false, defaultValue: 0) .Annotation("SqlServer:Identity", "1, 1"); migrationBuilder.AddColumn <int>( name: "Id", table: "Games", nullable: false, defaultValue: 0) .Annotation("SqlServer:Identity", "1, 1"); migrationBuilder.AddPrimaryKey( name: "PK_GamesRates", table: "GamesRates", column: "Id"); migrationBuilder.AddPrimaryKey( name: "PK_Games", table: "Games", column: "Id"); migrationBuilder.AddForeignKey( name: "FK_GamesRates_Games_GameId", table: "GamesRates", column: "GameId", principalTable: "Games", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(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.CreateTable( name: "Warehouses", columns: table => new { id = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), addr1 = table.Column <string>(nullable: true), addr2 = table.Column <string>(nullable: true), addr3 = table.Column <string>(nullable: true), addr4 = table.Column <string>(nullable: true), country = table.Column <string>(nullable: true), desc = table.Column <string>(nullable: true), name = table.Column <string>(nullable: true), post_code = table.Column <string>(nullable: true), type_of_transport = table.Column <string>(nullable: true), warehouse_id = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Warehouses", x => x.id); }); migrationBuilder.AlterColumn <string>( name: "UserId", table: "AspNetUserLogins", nullable: false); migrationBuilder.AlterColumn <string>( name: "UserId", table: "AspNetUserClaims", nullable: false); migrationBuilder.AlterColumn <string>( name: "RoleId", table: "AspNetRoleClaims", nullable: false); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn <int>( name: "TreinadorId", table: "Times", nullable: false, defaultValue: 0); migrationBuilder.CreateTable( name: "Campeonatos", columns: table => new { CampeonatoId = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Premiacao = table.Column <decimal>(nullable: false), TipoCampeonato = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Campeonatos", x => x.CampeonatoId); }); migrationBuilder.CreateTable( name: "jogadores", columns: table => new { JogadorId = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Nome = table.Column <string>(nullable: true), DataNascimento = table.Column <DateTime>(nullable: false), Altura = table.Column <float>(nullable: false), TimeId = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_jogadores", x => x.JogadorId); table.ForeignKey( name: "FK_jogadores_Times_TimeId", column: x => x.TimeId, principalTable: "Times", principalColumn: "Codigo", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "Treinadores", columns: table => new { TreinadorId = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Nome = table.Column <string>(nullable: true), Salario = table.Column <decimal>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Treinadores", x => x.TreinadorId); }); migrationBuilder.CreateTable( name: "CampeonatoTime", columns: table => new { TimeId = table.Column <int>(nullable: false), CampeonatoId = table.Column <int>(nullable: false), TipoCampeonato = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_CampeonatoTime", x => new { x.CampeonatoId, x.TimeId }); table.ForeignKey( name: "FK_CampeonatoTime_Campeonatos_CampeonatoId", column: x => x.CampeonatoId, principalTable: "Campeonatos", principalColumn: "CampeonatoId", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_CampeonatoTime_Times_TimeId", column: x => x.TimeId, principalTable: "Times", principalColumn: "Codigo", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_Times_TreinadorId", table: "Times", column: "TreinadorId"); migrationBuilder.CreateIndex( name: "IX_CampeonatoTime_TimeId", table: "CampeonatoTime", column: "TimeId"); migrationBuilder.CreateIndex( name: "IX_jogadores_TimeId", table: "jogadores", column: "TimeId"); migrationBuilder.AddForeignKey( name: "FK_Times_Treinadores_TreinadorId", table: "Times", column: "TreinadorId", principalTable: "Treinadores", principalColumn: "TreinadorId", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_ArcVolume_Arcs_ArcsId", table: "ArcVolume"); migrationBuilder.DropForeignKey( name: "FK_ArcVolume_Volumes_VolumesId", table: "ArcVolume"); migrationBuilder.DropTable( name: "ArcCharacter"); migrationBuilder.DropTable( name: "ArcVolumes"); migrationBuilder.DropTable( name: "CharacterIssue"); migrationBuilder.DropTable( name: "CharacterSeries"); migrationBuilder.DropTable( name: "CharacterVolume"); migrationBuilder.DropTable( name: "IssuePublisher"); migrationBuilder.DropTable( name: "PublisherVolume"); migrationBuilder.RenameColumn( name: "VolumesId", table: "ArcVolume", newName: "VolumeId"); migrationBuilder.RenameColumn( name: "ArcsId", table: "ArcVolume", newName: "ArcId"); migrationBuilder.RenameIndex( name: "IX_ArcVolume_VolumesId", table: "ArcVolume", newName: "IX_ArcVolume_VolumeId"); migrationBuilder.AddForeignKey( name: "FK_ArcVolume_Arcs_ArcId", table: "ArcVolume", column: "ArcId", principalTable: "Arcs", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ArcVolume_Volumes_VolumeId", table: "ArcVolume", column: "VolumeId", principalTable: "Volumes", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DeleteData( table: "AspNetRoles", keyColumn: "Id", keyValue: "79ddf8ea-46f9-4bb9-9e9d-bc2e2ea0c83b"); migrationBuilder.CreateTable( name: "Diets", columns: table => new { DietId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1") }, constraints: table => { table.PrimaryKey("PK_Diets", x => x.DietId); }); migrationBuilder.CreateTable( name: "Customers", columns: table => new { CustomerId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), UserName = table.Column <string>(nullable: true), IdentityUserId = table.Column <string>(nullable: true), DietId = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Customers", x => x.CustomerId); table.ForeignKey( name: "FK_Customers_Diets_DietId", column: x => x.DietId, principalTable: "Diets", principalColumn: "DietId", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_Customers_AspNetUsers_IdentityUserId", column: x => x.IdentityUserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "Meals", columns: table => new { MealId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), DietId = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Meals", x => x.MealId); table.ForeignKey( name: "FK_Meals_Diets_DietId", column: x => x.DietId, principalTable: "Diets", principalColumn: "DietId", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "Foods", columns: table => new { FoodId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), MealsID = table.Column <int>(nullable: false), food_name = table.Column <string>(nullable: true), brand_name = table.Column <string>(nullable: true), serving_qty = table.Column <int>(nullable: false), serving_unit = table.Column <string>(nullable: true), serving_weight_grams = table.Column <float>(nullable: false), nf_calories = table.Column <float>(nullable: false), nf_total_fat = table.Column <float>(nullable: false), nf_saturated_fat = table.Column <float>(nullable: false), nf_cholesterol = table.Column <float>(nullable: false), nf_sodium = table.Column <float>(nullable: false), nf_total_carbohydrate = table.Column <float>(nullable: false), nf_dietary_fiber = table.Column <float>(nullable: false), nf_sugars = table.Column <float>(nullable: false), nf_protein = table.Column <float>(nullable: false), nf_potassium = table.Column <float>(nullable: false), nf_p = table.Column <float>(nullable: false), full_nutrientsID = table.Column <int>(nullable: false), nix_brand_name = table.Column <string>(nullable: true), nix_brand_id = table.Column <string>(nullable: true), nix_item_name = table.Column <string>(nullable: true), nix_item_id = table.Column <string>(nullable: true), upc = table.Column <string>(nullable: true), consumed_at = table.Column <DateTime>(nullable: false), source = table.Column <int>(nullable: false), ndb_no = table.Column <int>(nullable: false), tagsID = table.Column <int>(nullable: false), alt_measuresID = table.Column <int>(nullable: false), lat = table.Column <string>(nullable: true), lng = table.Column <string>(nullable: true), meal_type = table.Column <int>(nullable: false), photoID = table.Column <int>(nullable: false), sub_recipe = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Foods", x => x.FoodId); table.ForeignKey( name: "FK_Foods_Meals_MealsID", column: x => x.MealsID, principalTable: "Meals", principalColumn: "MealId", onDelete: ReferentialAction.NoAction); }); migrationBuilder.CreateTable( name: "Alt_Measures", columns: table => new { Alt_MeasuresID = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), foodID = table.Column <int>(nullable: false), serving_weight = table.Column <float>(nullable: false), measure = table.Column <string>(nullable: true), seq = table.Column <int>(nullable: true), qty = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Alt_Measures", x => x.Alt_MeasuresID); table.ForeignKey( name: "FK_Alt_Measures_Foods_foodID", column: x => x.foodID, principalTable: "Foods", principalColumn: "FoodId", onDelete: ReferentialAction.NoAction); }); migrationBuilder.CreateTable( name: "Full_Nutrients", columns: table => new { Full_NutrientsID = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), foodId = table.Column <int>(nullable: false), attr_id = table.Column <int>(nullable: false), value = table.Column <float>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Full_Nutrients", x => x.Full_NutrientsID); table.ForeignKey( name: "FK_Full_Nutrients_Foods_foodId", column: x => x.foodId, principalTable: "Foods", principalColumn: "FoodId", onDelete: ReferentialAction.NoAction); }); migrationBuilder.CreateTable( name: "Metadata", columns: table => new { metaDataID = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), is_raw_food = table.Column <bool>(nullable: false), FoodId = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Metadata", x => x.metaDataID); table.ForeignKey( name: "FK_Metadata_Foods_FoodId", column: x => x.FoodId, principalTable: "Foods", principalColumn: "FoodId", onDelete: ReferentialAction.NoAction); }); migrationBuilder.CreateTable( name: "Photo", columns: table => new { photoID = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), foodID = table.Column <int>(nullable: false), thumb = table.Column <string>(nullable: true), highres = table.Column <string>(nullable: true), is_user_uploaded = table.Column <bool>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Photo", x => x.photoID); table.ForeignKey( name: "FK_Photo_Foods_foodID", column: x => x.foodID, principalTable: "Foods", principalColumn: "FoodId", onDelete: ReferentialAction.NoAction); }); migrationBuilder.CreateTable( name: "Tags", columns: table => new { TagId = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), FoodId = table.Column <int>(nullable: false), item = table.Column <string>(nullable: true), measure = table.Column <string>(nullable: true), quantity = table.Column <string>(nullable: true), food_group = table.Column <int>(nullable: false), tag_id = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Tags", x => x.TagId); table.ForeignKey( name: "FK_Tags_Foods_FoodId", column: x => x.FoodId, principalTable: "Foods", principalColumn: "FoodId", onDelete: ReferentialAction.NoAction); }); migrationBuilder.InsertData( table: "AspNetRoles", columns: new[] { "Id", "ConcurrencyStamp", "Name", "NormalizedName" }, values: new object[] { "edf29ae9-ad37-4511-88ef-905037225de9", "ece829be-4f8d-4627-a9ad-e09f56ad9f41", "Admin", "ADMIN" }); migrationBuilder.CreateIndex( name: "IX_Alt_Measures_foodID", table: "Alt_Measures", column: "foodID"); migrationBuilder.CreateIndex( name: "IX_Customers_DietId", table: "Customers", column: "DietId"); migrationBuilder.CreateIndex( name: "IX_Customers_IdentityUserId", table: "Customers", column: "IdentityUserId"); migrationBuilder.CreateIndex( name: "IX_Foods_MealsID", table: "Foods", column: "MealsID"); migrationBuilder.CreateIndex( name: "IX_Foods_alt_measuresID", table: "Foods", column: "alt_measuresID"); migrationBuilder.CreateIndex( name: "IX_Foods_full_nutrientsID", table: "Foods", column: "full_nutrientsID"); migrationBuilder.CreateIndex( name: "IX_Foods_photoID", table: "Foods", column: "photoID"); migrationBuilder.CreateIndex( name: "IX_Foods_tagsID", table: "Foods", column: "tagsID"); migrationBuilder.CreateIndex( name: "IX_Full_Nutrients_foodId", table: "Full_Nutrients", column: "foodId"); migrationBuilder.CreateIndex( name: "IX_Meals_DietId", table: "Meals", column: "DietId"); migrationBuilder.CreateIndex( name: "IX_Metadata_FoodId", table: "Metadata", column: "FoodId", unique: true); migrationBuilder.CreateIndex( name: "IX_Photo_foodID", table: "Photo", column: "foodID"); migrationBuilder.CreateIndex( name: "IX_Tags_FoodId", table: "Tags", column: "FoodId"); migrationBuilder.AddForeignKey( name: "FK_Foods_Alt_Measures_alt_measuresID", table: "Foods", column: "alt_measuresID", principalTable: "Alt_Measures", principalColumn: "Alt_MeasuresID", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Foods_Full_Nutrients_full_nutrientsID", table: "Foods", column: "full_nutrientsID", principalTable: "Full_Nutrients", principalColumn: "Full_NutrientsID", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Foods_Photo_photoID", table: "Foods", column: "photoID", principalTable: "Photo", principalColumn: "photoID", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Foods_Tags_tagsID", table: "Foods", column: "tagsID", principalTable: "Tags", principalColumn: "TagId", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "GalleryImages"); migrationBuilder.DropTable( name: "Pages"); migrationBuilder.DropTable( name: "Partniors"); migrationBuilder.DropTable( name: "Projects"); migrationBuilder.DropTable( name: "Images"); migrationBuilder.DropPrimaryKey( name: "PK_Galleries", table: "Galleries"); migrationBuilder.DropColumn( name: "Name", table: "Settings"); migrationBuilder.RenameTable( name: "Galleries", newName: "Gallerys"); migrationBuilder.RenameColumn( name: "Name", table: "Gallerys", newName: "Title"); migrationBuilder.AddColumn <string>( name: "Description", table: "AspNetUsers", type: "text", nullable: true); migrationBuilder.AddColumn <string>( name: "Discriminator", table: "AspNetUsers", type: "text", nullable: false, defaultValue: ""); migrationBuilder.AddColumn <string>( name: "Facebook", table: "AspNetUsers", type: "text", nullable: true); migrationBuilder.AddColumn <string>( name: "ImageId", table: "AspNetUsers", type: "text", nullable: true); migrationBuilder.AddColumn <string>( name: "JobTitle", table: "AspNetUsers", type: "text", nullable: true); migrationBuilder.AddColumn <string>( name: "Description", table: "Gallerys", type: "text", nullable: true); migrationBuilder.AddPrimaryKey( name: "PK_Gallerys", table: "Gallerys", column: "Id"); migrationBuilder.CreateTable( name: "Category", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Description = table.Column <string>(type: "text", nullable: true), Title = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Category", x => x.Id); }); migrationBuilder.CreateTable( name: "Logs", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Date = table.Column <DateTime>(type: "timestamp without time zone", nullable: false), Message = table.Column <string>(type: "text", nullable: true), Type = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Logs", x => x.Id); }); migrationBuilder.CreateTable( name: "MediaTypes", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Type = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_MediaTypes", x => x.Id); }); migrationBuilder.CreateTable( name: "Statistics", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), PageId = table.Column <string>(type: "text", nullable: true), Time = table.Column <DateTime>(type: "timestamp without time zone", nullable: false), UserId = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Statistics", x => x.Id); }); migrationBuilder.CreateTable( name: "INMedias", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Description = table.Column <string>(type: "text", nullable: true), Path = table.Column <string>(type: "text", nullable: true), Title = table.Column <string>(type: "text", nullable: true), TypeId = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_INMedias", x => x.Id); table.ForeignKey( name: "FK_INMedias_MediaTypes_TypeId", column: x => x.TypeId, principalTable: "MediaTypes", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "AboutSkilsSections", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Description = table.Column <string>(type: "text", nullable: true), ImageId = table.Column <string>(type: "text", nullable: true), Title = table.Column <string>(type: "text", nullable: true), VideoId = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_AboutSkilsSections", x => x.Id); table.ForeignKey( name: "FK_AboutSkilsSections_INMedias_ImageId", column: x => x.ImageId, principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_AboutSkilsSections_INMedias_VideoId", column: x => x.VideoId, principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "BlogPosts", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Active = table.Column <bool>(type: "boolean", nullable: false), AppUserId = table.Column <string>(type: "text", nullable: true), ComentsIsActive = table.Column <bool>(type: "boolean", nullable: false), Content = table.Column <string>(type: "text", nullable: true), DateCreated = table.Column <DateTime>(type: "timestamp without time zone", nullable: false), DateEdited = table.Column <DateTime>(type: "timestamp without time zone", nullable: true), GalleryId = table.Column <string>(type: "text", nullable: true), PostImageId = table.Column <string>(type: "text", nullable: true), Title = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_BlogPosts", x => x.Id); table.ForeignKey( name: "FK_BlogPosts_AspNetUsers_AppUserId", column: x => x.AppUserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_BlogPosts_Gallerys_GalleryId", column: x => x.GalleryId, principalTable: "Gallerys", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_BlogPosts_INMedias_PostImageId", column: x => x.PostImageId, principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "Carousels", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Ative = table.Column <bool>(type: "boolean", nullable: false), Description = table.Column <string>(type: "text", nullable: true), Link = table.Column <string>(type: "text", nullable: true), MediaId = table.Column <string>(type: "text", nullable: true), Number = table.Column <int>(type: "integer", nullable: true), Title = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Carousels", x => x.Id); table.ForeignKey( name: "FK_Carousels_INMedias_MediaId", column: x => x.MediaId, principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "GalleryINMedias", columns: table => new { GalleryId = table.Column <string>(type: "text", nullable: false), INMediaId = table.Column <string>(type: "text", nullable: false) }, constraints: table => { table.PrimaryKey("PK_GalleryINMedias", x => new { x.GalleryId, x.INMediaId }); table.ForeignKey( name: "FK_GalleryINMedias_Gallerys_GalleryId", column: x => x.GalleryId, principalTable: "Gallerys", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_GalleryINMedias_INMedias_INMediaId", column: x => x.INMediaId, principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "INMediaCategories", columns: table => new { INMediaId = table.Column <string>(type: "text", nullable: false), CategoryId = table.Column <string>(type: "text", nullable: false) }, constraints: table => { table.PrimaryKey("PK_INMediaCategories", x => new { x.INMediaId, x.CategoryId }); table.ForeignKey( name: "FK_INMediaCategories_Category_CategoryId", column: x => x.CategoryId, principalTable: "Category", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_INMediaCategories_INMedias_INMediaId", column: x => x.INMediaId, principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "INServices", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Description = table.Column <string>(type: "text", nullable: true), ImageId = table.Column <string>(type: "text", nullable: true), Link = table.Column <string>(type: "text", nullable: true), Title = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_INServices", x => x.Id); table.ForeignKey( name: "FK_INServices_INMedias_ImageId", column: x => x.ImageId, principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "Skils", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), Content = table.Column <string>(type: "text", nullable: true), ImageId = table.Column <string>(type: "text", nullable: true), Title = table.Column <string>(type: "text", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Skils", x => x.Id); table.ForeignKey( name: "FK_Skils_INMedias_ImageId", column: x => x.ImageId, principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "Comments", columns: table => new { Id = table.Column <string>(type: "text", nullable: false), AppUserId = table.Column <string>(type: "text", nullable: true), BlogPostId = table.Column <string>(type: "text", nullable: true), CommentText = table.Column <string>(type: "text", nullable: true), Visable = table.Column <bool>(type: "boolean", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Comments", x => x.Id); table.ForeignKey( name: "FK_Comments_AspNetUsers_AppUserId", column: x => x.AppUserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_Comments_BlogPosts_BlogPostId", column: x => x.BlogPostId, principalTable: "BlogPosts", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.CreateTable( name: "PostCategories", columns: table => new { BlogPostId = table.Column <string>(type: "text", nullable: false), CategoryId = table.Column <string>(type: "text", nullable: false) }, constraints: table => { table.PrimaryKey("PK_PostCategories", x => new { x.BlogPostId, x.CategoryId }); table.ForeignKey( name: "FK_PostCategories_BlogPosts_BlogPostId", column: x => x.BlogPostId, principalTable: "BlogPosts", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_PostCategories_Category_CategoryId", column: x => x.CategoryId, principalTable: "Category", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_AspNetUsers_ImageId", table: "AspNetUsers", column: "ImageId"); migrationBuilder.CreateIndex( name: "IX_AboutSkilsSections_ImageId", table: "AboutSkilsSections", column: "ImageId"); migrationBuilder.CreateIndex( name: "IX_AboutSkilsSections_VideoId", table: "AboutSkilsSections", column: "VideoId"); migrationBuilder.CreateIndex( name: "IX_BlogPosts_AppUserId", table: "BlogPosts", column: "AppUserId"); migrationBuilder.CreateIndex( name: "IX_BlogPosts_GalleryId", table: "BlogPosts", column: "GalleryId"); migrationBuilder.CreateIndex( name: "IX_BlogPosts_PostImageId", table: "BlogPosts", column: "PostImageId"); migrationBuilder.CreateIndex( name: "IX_Carousels_MediaId", table: "Carousels", column: "MediaId"); migrationBuilder.CreateIndex( name: "IX_Comments_AppUserId", table: "Comments", column: "AppUserId"); migrationBuilder.CreateIndex( name: "IX_Comments_BlogPostId", table: "Comments", column: "BlogPostId"); migrationBuilder.CreateIndex( name: "IX_GalleryINMedias_INMediaId", table: "GalleryINMedias", column: "INMediaId"); migrationBuilder.CreateIndex( name: "IX_INMediaCategories_CategoryId", table: "INMediaCategories", column: "CategoryId"); migrationBuilder.CreateIndex( name: "IX_INMedias_TypeId", table: "INMedias", column: "TypeId"); migrationBuilder.CreateIndex( name: "IX_INServices_ImageId", table: "INServices", column: "ImageId"); migrationBuilder.CreateIndex( name: "IX_PostCategories_CategoryId", table: "PostCategories", column: "CategoryId"); migrationBuilder.CreateIndex( name: "IX_Skils_ImageId", table: "Skils", column: "ImageId"); migrationBuilder.AddForeignKey( name: "FK_AspNetUsers_INMedias_ImageId", table: "AspNetUsers", column: "ImageId", principalTable: "INMedias", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "Id", table: "InquiryItems"); migrationBuilder.AddColumn<int>( name: "InventoryId1", table: "InquiryItems", type: "int", nullable: true); migrationBuilder.UpdateData( table: "Inquirys", keyColumn: "Id", keyValue: 1, columns: new[] { "DateCreated", "DateIssued", "DateUpdated" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 776, DateTimeKind.Local).AddTicks(966), new DateTime(2020, 10, 15, 12, 17, 17, 776, DateTimeKind.Local).AddTicks(557), new DateTime(2020, 10, 15, 12, 17, 17, 776, DateTimeKind.Local).AddTicks(1348) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 1, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(514), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(916) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 2, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1795), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1806) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 3, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1822), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1823) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 4, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1825), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1826) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 5, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1827), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1829) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 6, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1838), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1839) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 7, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1840), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1841) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 8, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1843), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1844) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 9, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1845), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1846) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 10, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1849), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1850) }); migrationBuilder.UpdateData( table: "Inventories", keyColumn: "Id", keyValue: 11, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1852), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(1853) }); migrationBuilder.UpdateData( table: "Invoices", keyColumn: "Id", keyValue: 1, columns: new[] { "DateCreated", "DateUpdated" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 775, DateTimeKind.Local).AddTicks(5206), new DateTime(2020, 10, 15, 12, 17, 17, 775, DateTimeKind.Local).AddTicks(5597) }); migrationBuilder.UpdateData( table: "Orders", keyColumn: "Id", keyValue: 1, columns: new[] { "DateCreated", "DateUpdated" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(4935), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(5397) }); migrationBuilder.UpdateData( table: "Orders", keyColumn: "Id", keyValue: 2, columns: new[] { "DateCreated", "DateUpdated" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(5875), new DateTime(2020, 10, 15, 12, 17, 17, 773, DateTimeKind.Local).AddTicks(5904) }); migrationBuilder.UpdateData( table: "Quotations", keyColumn: "Id", keyValue: 1, columns: new[] { "DateCreated", "DateUpdated" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 774, DateTimeKind.Local).AddTicks(6929), new DateTime(2020, 10, 15, 12, 17, 17, 774, DateTimeKind.Local).AddTicks(7333) }); migrationBuilder.UpdateData( table: "Users", keyColumn: "Id", keyValue: 1, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 770, DateTimeKind.Local).AddTicks(6872), new DateTime(2020, 10, 15, 12, 17, 17, 771, DateTimeKind.Local).AddTicks(5273) }); migrationBuilder.UpdateData( table: "Users", keyColumn: "Id", keyValue: 2, columns: new[] { "DateCreated", "DateUpdate" }, values: new object[] { new DateTime(2020, 10, 15, 12, 17, 17, 771, DateTimeKind.Local).AddTicks(5792), new DateTime(2020, 10, 15, 12, 17, 17, 771, DateTimeKind.Local).AddTicks(5837) }); migrationBuilder.CreateIndex( name: "IX_InquiryItems_InventoryId1", table: "InquiryItems", column: "InventoryId1"); migrationBuilder.AddForeignKey( name: "FK_InquiryItems_Inventories_InventoryId1", table: "InquiryItems", column: "InventoryId1", principalTable: "Inventories", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
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_AspNetRoles_RoleId", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserRoles_AspNetUsers_UserId", table: "AspNetUserRoles"); migrationBuilder.DropForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId", table: "AspNetUserTokens"); migrationBuilder.AddForeignKey( name: "FK_AspNetRoleClaims_AspNetRoles_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); 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_AspNetRoles_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", 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.AlterColumn <string>( name: "Password", table: "Users", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AlterColumn <string>( name: "Name", table: "Users", nullable: true, oldClrType: typeof(string), oldType: "nvarchar(max)"); migrationBuilder.AddColumn <int>( name: "RentalId", table: "EquipmentList", nullable: true); migrationBuilder.CreateTable( name: "Rental", columns: table => new { Id = table.Column <int>(nullable: false) .Annotation("SqlServer:Identity", "1, 1"), SerialNumber = table.Column <string>(nullable: true), Name = table.Column <string>(nullable: true), IsApproved = table.Column <bool>(nullable: false), FeedBack = table.Column <string>(nullable: true), CategoryId = table.Column <int>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Rental", x => x.Id); table.ForeignKey( name: "FK_Rental_Categories_CategoryId", column: x => x.CategoryId, principalTable: "Categories", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); migrationBuilder.UpdateData( table: "EquipmentList", keyColumn: "Id", keyValue: 1, column: "RentalDates", value: ","); migrationBuilder.CreateIndex( name: "IX_EquipmentList_RentalId", table: "EquipmentList", column: "RentalId"); migrationBuilder.CreateIndex( name: "IX_Rental_CategoryId", table: "Rental", column: "CategoryId"); migrationBuilder.AddForeignKey( name: "FK_EquipmentList_Rental_RentalId", table: "EquipmentList", column: "RentalId", principalTable: "Rental", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_ATMs_ATMSources_SourceTradePointSourceId_SourceDataFileType", table: "ATMs"); migrationBuilder.DropForeignKey( name: "FK_InfoKiosks_InfoKioskSources_SourceTradePointSourceId_SourceDataFileType", table: "InfoKiosks"); migrationBuilder.DropForeignKey( name: "FK_Offices_OfficeSources_SourceTradePointSourceId_SourceDataFileType", table: "Offices"); migrationBuilder.DropIndex( name: "IX_Offices_SourceTradePointSourceId_SourceDataFileType", table: "Offices"); migrationBuilder.DropIndex( name: "IX_InfoKiosks_SourceTradePointSourceId_SourceDataFileType", table: "InfoKiosks"); migrationBuilder.DropIndex( name: "IX_ATMs_SourceTradePointSourceId_SourceDataFileType", table: "ATMs"); migrationBuilder.DropColumn( name: "SourceDataFileType", table: "Offices"); migrationBuilder.DropColumn( name: "SourceTradePointSourceId", table: "Offices"); migrationBuilder.DropColumn( name: "SourceDataFileType", table: "InfoKiosks"); migrationBuilder.DropColumn( name: "SourceTradePointSourceId", table: "InfoKiosks"); migrationBuilder.DropColumn( name: "SourceDataFileType", table: "ATMs"); migrationBuilder.DropColumn( name: "SourceTradePointSourceId", table: "ATMs"); migrationBuilder.AddColumn<Guid>( name: "TradePointId", table: "OfficeSources", nullable: true); migrationBuilder.AddColumn<Guid>( name: "TradePointId", table: "InfoKioskSources", nullable: true); migrationBuilder.AddColumn<Guid>( name: "TradePointId", table: "ATMSources", nullable: true); migrationBuilder.CreateIndex( name: "IX_OfficeSources_TradePointId", table: "OfficeSources", column: "TradePointId"); migrationBuilder.CreateIndex( name: "IX_InfoKioskSources_TradePointId", table: "InfoKioskSources", column: "TradePointId"); migrationBuilder.CreateIndex( name: "IX_ATMSources_TradePointId", table: "ATMSources", column: "TradePointId"); migrationBuilder.AddForeignKey( name: "FK_ATMSources_ATMs_TradePointId", table: "ATMSources", column: "TradePointId", principalTable: "ATMs", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_InfoKioskSources_InfoKiosks_TradePointId", table: "InfoKioskSources", column: "TradePointId", principalTable: "InfoKiosks", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_OfficeSources_Offices_TradePointId", table: "OfficeSources", column: "TradePointId", principalTable: "Offices", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn <string>( name: "UserId", table: "Products", nullable: true); migrationBuilder.CreateTable( name: "AspNetRoles", 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_AspNetRoles", x => x.Id); }); migrationBuilder.CreateTable( name: "AspNetUsers", columns: table => new { 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), EmailConfirmed = table.Column <bool>(nullable: false), PasswordHash = table.Column <string>(nullable: true), SecurityStamp = table.Column <string>(nullable: true), ConcurrencyStamp = table.Column <string>(nullable: true), PhoneNumber = table.Column <string>(nullable: true), PhoneNumberConfirmed = table.Column <bool>(nullable: false), TwoFactorEnabled = table.Column <bool>(nullable: false), LockoutEnd = table.Column <DateTimeOffset>(nullable: true), LockoutEnabled = table.Column <bool>(nullable: false), AccessFailedCount = table.Column <int>(nullable: false), FirstName = table.Column <string>(nullable: true), LastName = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_AspNetUsers", x => x.Id); }); migrationBuilder.CreateTable( name: "AspNetRoleClaims", 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_AspNetRoleClaims", x => x.Id); table.ForeignKey( name: "FK_AspNetRoleClaims_AspNetRoles_RoleId", column: x => x.RoleId, principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AspNetUserClaims", 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_AspNetUserClaims", x => x.Id); table.ForeignKey( name: "FK_AspNetUserClaims_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AspNetUserLogins", 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_AspNetUserLogins", x => new { x.LoginProvider, x.ProviderKey }); table.ForeignKey( name: "FK_AspNetUserLogins_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AspNetUserRoles", columns: table => new { UserId = table.Column <string>(nullable: false), RoleId = table.Column <string>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_AspNetUserRoles", x => new { x.UserId, x.RoleId }); table.ForeignKey( name: "FK_AspNetUserRoles_AspNetRoles_RoleId", column: x => x.RoleId, principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_AspNetUserRoles_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "AspNetUserTokens", 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_AspNetUserTokens", x => new { x.UserId, x.LoginProvider, x.Name }); table.ForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_Products_UserId", table: "Products", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_AspNetRoleClaims_RoleId", table: "AspNetRoleClaims", column: "RoleId"); migrationBuilder.CreateIndex( name: "RoleNameIndex", table: "AspNetRoles", column: "NormalizedName", unique: true, filter: "[NormalizedName] IS NOT NULL"); migrationBuilder.CreateIndex( name: "IX_AspNetUserClaims_UserId", table: "AspNetUserClaims", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_AspNetUserLogins_UserId", table: "AspNetUserLogins", column: "UserId"); migrationBuilder.CreateIndex( name: "IX_AspNetUserRoles_RoleId", table: "AspNetUserRoles", column: "RoleId"); migrationBuilder.CreateIndex( name: "EmailIndex", table: "AspNetUsers", column: "NormalizedEmail"); migrationBuilder.CreateIndex( name: "UserNameIndex", table: "AspNetUsers", column: "NormalizedUserName", unique: true, filter: "[NormalizedUserName] IS NOT NULL"); migrationBuilder.AddForeignKey( name: "FK_Products_AspNetUsers_UserId", table: "Products", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn <string>( name: "LastName", table: "Student", maxLength: 50, nullable: false, oldClrType: typeof(string), oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn <string>( name: "FirstName", table: "Student", maxLength: 50, nullable: false, oldClrType: typeof(string), oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn <string>( name: "Title", table: "Course", maxLength: 50, nullable: true, oldClrType: typeof(string), oldNullable: true); // migrationBuilder.AddColumn<int>( // name: "DepartmentID", // table: "Course", // nullable: false, // defaultValue: 0); migrationBuilder.CreateTable( name: "Instructor", columns: table => new { ID = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), LastName = table.Column <string>(maxLength: 50, nullable: false), FirstName = table.Column <string>(maxLength: 50, nullable: false), HireDate = table.Column <DateTime>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Instructor", x => x.ID); }); migrationBuilder.CreateTable( name: "CourseAssignment", columns: table => new { InstructorID = table.Column <int>(nullable: false), CourseID = table.Column <int>(nullable: false) }, constraints: table => { table.PrimaryKey("PK_CourseAssignment", x => new { x.CourseID, x.InstructorID }); table.ForeignKey( name: "FK_CourseAssignment_Course_CourseID", column: x => x.CourseID, principalTable: "Course", principalColumn: "CourseID", onDelete: ReferentialAction.Cascade); table.ForeignKey( name: "FK_CourseAssignment_Instructor_InstructorID", column: x => x.InstructorID, principalTable: "Instructor", principalColumn: "ID", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateTable( name: "Department", columns: table => new { DepartmentID = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Name = table.Column <string>(maxLength: 50, nullable: true), Budget = table.Column <decimal>(type: "money", nullable: false), StartDate = table.Column <DateTime>(nullable: false), InstructorID = table.Column <int>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Department", x => x.DepartmentID); table.ForeignKey( name: "FK_Department_Instructor_InstructorID", column: x => x.InstructorID, principalTable: "Instructor", principalColumn: "ID", onDelete: ReferentialAction.Restrict); }); migrationBuilder.Sql("INSERT INTO dbo.Department (Name, Budget, StartDate) VALUES ('Temp', 0.00, GETDATE())"); // Default value for FK points to department created above, with // defaultValue changed to 1 in following AddColumn statement. migrationBuilder.AddColumn <int>( name: "DepartmentID", table: "Course", nullable: false, defaultValue: 1); migrationBuilder.CreateTable( name: "OfficeAssignment", columns: table => new { InstructorID = table.Column <int>(nullable: false), Location = table.Column <string>(maxLength: 50, nullable: true) }, constraints: table => { table.PrimaryKey("PK_OfficeAssignment", x => x.InstructorID); table.ForeignKey( name: "FK_OfficeAssignment_Instructor_InstructorID", column: x => x.InstructorID, principalTable: "Instructor", principalColumn: "ID", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_Course_DepartmentID", table: "Course", column: "DepartmentID"); migrationBuilder.CreateIndex( name: "IX_CourseAssignment_InstructorID", table: "CourseAssignment", column: "InstructorID"); migrationBuilder.CreateIndex( name: "IX_Department_InstructorID", table: "Department", column: "InstructorID"); migrationBuilder.AddForeignKey( name: "FK_Course_Department_DepartmentID", table: "Course", column: "DepartmentID", principalTable: "Department", principalColumn: "DepartmentID", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Eventos_UnidadesSesi_UnidadeId", table: "Eventos"); migrationBuilder.DropForeignKey( name: "FK_FuncionariosUnidadesFavoritas_UnidadesSesi_UnidadeId", table: "FuncionariosUnidadesFavoritas"); migrationBuilder.DropForeignKey( name: "FK_Pesquisas_Empresas_EmpresaId", table: "Pesquisas"); migrationBuilder.RenameColumn( name: "EmpresaId", table: "Pesquisas", newName: "EmpresaDomainId"); migrationBuilder.RenameIndex( name: "IX_Pesquisas_EmpresaId", table: "Pesquisas", newName: "IX_Pesquisas_EmpresaDomainId"); migrationBuilder.RenameColumn( name: "NomePermissao", table: "Permissoes", newName: "Permissao"); migrationBuilder.RenameColumn( name: "Descricao", table: "Perguntas", newName: "Pergunta"); migrationBuilder.RenameColumn( name: "UnidadeId", table: "FuncionariosUnidadesFavoritas", newName: "UnidadeSesiId"); migrationBuilder.RenameIndex( name: "IX_FuncionariosUnidadesFavoritas_UnidadeId", table: "FuncionariosUnidadesFavoritas", newName: "IX_FuncionariosUnidadesFavoritas_UnidadeSesiId"); migrationBuilder.RenameColumn( name: "UnidadeId", table: "Eventos", newName: "UnidadeFavoritaId"); migrationBuilder.RenameIndex( name: "IX_Eventos_UnidadeId", table: "Eventos", newName: "IX_Eventos_UnidadeFavoritaId"); migrationBuilder.RenameColumn( name: "Descricao", table: "Alternativas", newName: "Resposta"); migrationBuilder.AddColumn <DateTime>( name: "DataAlteracao", table: "Dicas", nullable: false, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)); migrationBuilder.AddForeignKey( name: "FK_Eventos_UnidadesSesi_UnidadeFavoritaId", table: "Eventos", column: "UnidadeFavoritaId", principalTable: "UnidadesSesi", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_FuncionariosUnidadesFavoritas_UnidadesSesi_UnidadeSesiId", table: "FuncionariosUnidadesFavoritas", column: "UnidadeSesiId", principalTable: "UnidadesSesi", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Pesquisas_Empresas_EmpresaDomainId", table: "Pesquisas", column: "EmpresaDomainId", principalTable: "Empresas", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Insurances_Forms_IDForm", table: "Insurances"); migrationBuilder.DropForeignKey( name: "FK_Insurances_PriceLists_IDPriceList", table: "Insurances"); migrationBuilder.DropTable( name: "Forms"); migrationBuilder.DropIndex( name: "IX_Insurances_IDForm", table: "Insurances"); migrationBuilder.DropIndex( name: "IX_Insurances_IDPriceList", table: "Insurances"); migrationBuilder.DropColumn( name: "IDForm", table: "Insurances"); migrationBuilder.DropColumn( name: "IDPriceList", table: "Insurances"); migrationBuilder.RenameColumn( name: "IDPriceList", table: "PriceLists", newName: "IDTypeInsurance"); migrationBuilder.AddColumn <int>( name: "IDTypeInsurance", table: "PolicyDetails", type: "int", nullable: false, defaultValue: 0); migrationBuilder.AddColumn <string>( name: "IDUser", table: "PolicyDetails", type: "nvarchar(450)", nullable: true); migrationBuilder.AddColumn <string>( name: "IDUser", table: "Insurances", type: "nvarchar(450)", nullable: true); migrationBuilder.CreateIndex( name: "IX_PolicyDetails_IDTypeInsurance", table: "PolicyDetails", column: "IDTypeInsurance"); migrationBuilder.CreateIndex( name: "IX_PolicyDetails_IDUser", table: "PolicyDetails", column: "IDUser"); migrationBuilder.CreateIndex( name: "IX_Insurances_IDUser", table: "Insurances", column: "IDUser"); migrationBuilder.AddForeignKey( name: "FK_Insurances_AspNetUsers_IDUser", table: "Insurances", column: "IDUser", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_PolicyDetails_AspNetUsers_IDUser", table: "PolicyDetails", column: "IDUser", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_PolicyDetails_PriceLists_IDTypeInsurance", table: "PolicyDetails", column: "IDTypeInsurance", principalTable: "PriceLists", principalColumn: "IDTypeInsurance", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn <int>( name: "BrandId", table: "Products", type: "int", nullable: false, defaultValue: 0); migrationBuilder.AddColumn <int>( name: "CategoryId", table: "Products", type: "int", nullable: false, defaultValue: 0); migrationBuilder.AddColumn <DateTime>( name: "CreatedDate", table: "Products", type: "datetime2", nullable: false, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)); migrationBuilder.AddColumn <double>( name: "Price", table: "Products", type: "float", nullable: false, defaultValue: 0.0); migrationBuilder.AddColumn <int>( name: "StorageId", table: "Products", type: "int", nullable: false, defaultValue: 0); migrationBuilder.CreateTable( name: "Brands", columns: table => new { Id = table.Column <int>(type: "int", nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Name = table.Column <string>(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Brands", x => x.Id); }); migrationBuilder.CreateTable( name: "Categories", columns: table => new { Id = table.Column <int>(type: "int", nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Name = table.Column <string>(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Categories", x => x.Id); }); migrationBuilder.CreateTable( name: "Storages", columns: table => new { Id = table.Column <int>(type: "int", nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), Count = table.Column <int>(type: "int", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Storages", x => x.Id); }); migrationBuilder.CreateIndex( name: "IX_Products_BrandId", table: "Products", column: "BrandId"); migrationBuilder.CreateIndex( name: "IX_Products_CategoryId", table: "Products", column: "CategoryId"); migrationBuilder.CreateIndex( name: "IX_Products_StorageId", table: "Products", column: "StorageId", unique: true); migrationBuilder.AddForeignKey( name: "FK_Products_Brands_BrandId", table: "Products", column: "BrandId", principalTable: "Brands", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Products_Categories_CategoryId", table: "Products", column: "CategoryId", principalTable: "Categories", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Products_Storages_StorageId", table: "Products", column: "StorageId", principalTable: "Storages", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Hotels_Addresses_AddressId", table: "Hotels"); migrationBuilder.DropForeignKey( name: "FK_Hotels_Amenities_AmenityId", table: "Hotels"); migrationBuilder.DropForeignKey( name: "FK_Hotels_Infos_InfoId", table: "Hotels"); migrationBuilder.DropColumn( name: "ReviewId", table: "Hotels"); migrationBuilder.DropColumn( name: "RoomId", table: "Hotels"); migrationBuilder.DropColumn( name: "StayId", table: "Hotels"); migrationBuilder.AlterColumn <int>( name: "InfoId", table: "Hotels", nullable: true, oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn <int>( name: "AmenityId", table: "Hotels", nullable: true, oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn <int>( name: "AddressId", table: "Hotels", nullable: true, oldClrType: typeof(int), oldType: "int"); migrationBuilder.AddForeignKey( name: "FK_Hotels_Addresses_AddressId", table: "Hotels", column: "AddressId", principalTable: "Addresses", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Hotels_Amenities_AmenityId", table: "Hotels", column: "AmenityId", principalTable: "Amenities", principalColumn: "Id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Hotels_Infos_InfoId", table: "Hotels", column: "InfoId", principalTable: "Infos", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_IndustrialProperties_ProviderModels_ProviderModelId", table: "IndustrialProperties"); migrationBuilder.DropForeignKey( name: "FK_OnSaleProperties_ProviderModels_ProviderModelId", table: "OnSaleProperties"); migrationBuilder.DropForeignKey( name: "FK_RentalProperties_ProviderModels_ProviderModelId", table: "RentalProperties"); migrationBuilder.AlterColumn <int>( name: "ProviderModelId", table: "RentalProperties", nullable: false, oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn <int>( name: "ProviderModelId", table: "OnSaleProperties", nullable: false, oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AlterColumn <int>( name: "ProviderModelId", table: "IndustrialProperties", nullable: false, oldClrType: typeof(int), oldType: "int", oldNullable: true); migrationBuilder.AddForeignKey( name: "FK_IndustrialProperties_ProviderModels_ProviderModelId", table: "IndustrialProperties", column: "ProviderModelId", principalTable: "ProviderModels", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_OnSaleProperties_ProviderModels_ProviderModelId", table: "OnSaleProperties", column: "ProviderModelId", principalTable: "ProviderModels", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_RentalProperties_ProviderModels_ProviderModelId", table: "RentalProperties", column: "ProviderModelId", principalTable: "ProviderModels", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Up(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_CompanyModule_Module_moduleId", table: "CompanyModule"); 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.AddColumn <int>( name: "feriasInfFeriasId", table: "Ferias_Itens", nullable: true); migrationBuilder.AddForeignKey( name: "FK_IdentityRoleClaim<string>_IdentityRole_RoleId", table: "AspNetRoleClaims", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserClaim<string>_ApplicationUser_UserId", table: "AspNetUserClaims", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserLogin<string>_ApplicationUser_UserId", table: "AspNetUserLogins", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_IdentityRole_RoleId", table: "AspNetUserRoles", column: "RoleId", principalTable: "AspNetRoles", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_IdentityUserRole<string>_ApplicationUser_UserId", table: "AspNetUserRoles", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_CompanyModule_Module_moduleId", table: "CompanyModule", column: "moduleId", principalTable: "Module", principalColumn: "id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Contact_Item_Contact_contactId", table: "Contact_Item", column: "contactId", principalTable: "Contact", principalColumn: "id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Ferias_Funcionario_funcionarioId", table: "Ferias", column: "funcionarioId", principalTable: "Funcionario", principalColumn: "id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Ferias_Itens_FuncInfFerias_feriasInfFeriasId", table: "Ferias_Itens", column: "feriasInfFeriasId", principalTable: "FuncInfFerias", principalColumn: "id", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_Ferias_Itens_Funcionario_funcionarioId", table: "Ferias_Itens", column: "funcionarioId", principalTable: "Funcionario", principalColumn: "id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_FuncFerias_Funcionario_funcionarioId", table: "FuncFerias", column: "funcionarioId", principalTable: "Funcionario", principalColumn: "id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_FuncInfFerias_Funcionario_funcionarioId", table: "FuncInfFerias", column: "funcionarioId", principalTable: "Funcionario", principalColumn: "id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Funcionario_Departamento_departamentoId", table: "Funcionario", column: "departamentoId", principalTable: "Departamento", principalColumn: "Id", onDelete: ReferentialAction.Cascade); 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.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_Eventos_UnidadesSesi_UnidadeFavoritaId", table: "Eventos"); migrationBuilder.DropForeignKey( name: "FK_FuncionariosUnidadesFavoritas_UnidadesSesi_UnidadeSesiId", table: "FuncionariosUnidadesFavoritas"); migrationBuilder.DropForeignKey( name: "FK_Pesquisas_Empresas_EmpresaDomainId", table: "Pesquisas"); migrationBuilder.DropColumn( name: "DataAlteracao", table: "Dicas"); migrationBuilder.RenameColumn( name: "EmpresaDomainId", table: "Pesquisas", newName: "EmpresaId"); migrationBuilder.RenameIndex( name: "IX_Pesquisas_EmpresaDomainId", table: "Pesquisas", newName: "IX_Pesquisas_EmpresaId"); migrationBuilder.RenameColumn( name: "Permissao", table: "Permissoes", newName: "NomePermissao"); migrationBuilder.RenameColumn( name: "Pergunta", table: "Perguntas", newName: "Descricao"); migrationBuilder.RenameColumn( name: "UnidadeSesiId", table: "FuncionariosUnidadesFavoritas", newName: "UnidadeId"); migrationBuilder.RenameIndex( name: "IX_FuncionariosUnidadesFavoritas_UnidadeSesiId", table: "FuncionariosUnidadesFavoritas", newName: "IX_FuncionariosUnidadesFavoritas_UnidadeId"); migrationBuilder.RenameColumn( name: "UnidadeFavoritaId", table: "Eventos", newName: "UnidadeId"); migrationBuilder.RenameIndex( name: "IX_Eventos_UnidadeFavoritaId", table: "Eventos", newName: "IX_Eventos_UnidadeId"); migrationBuilder.RenameColumn( name: "Resposta", table: "Alternativas", newName: "Descricao"); migrationBuilder.AddForeignKey( name: "FK_Eventos_UnidadesSesi_UnidadeId", table: "Eventos", column: "UnidadeId", principalTable: "UnidadesSesi", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_FuncionariosUnidadesFavoritas_UnidadesSesi_UnidadeId", table: "FuncionariosUnidadesFavoritas", column: "UnidadeId", principalTable: "UnidadesSesi", principalColumn: "Id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "FK_Pesquisas_Empresas_EmpresaId", table: "Pesquisas", column: "EmpresaId", principalTable: "Empresas", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }
protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_ExchangeRates_Assets_AssetBaseAssetId_AssetBaseIsTypeCrypto", table: "ExchangeRates"); migrationBuilder.DropForeignKey( name: "FK_ExchangeRates_Assets_AssetQuoteAssetId_AssetQuoteIsTypeCrypto", table: "ExchangeRates"); migrationBuilder.DropIndex( name: "IX_ExchangeRates_AssetBaseAssetId_AssetBaseIsTypeCrypto", table: "ExchangeRates"); migrationBuilder.DropIndex( name: "IX_ExchangeRates_AssetQuoteAssetId_AssetQuoteIsTypeCrypto", table: "ExchangeRates"); migrationBuilder.DropPrimaryKey( name: "PK_Assets", table: "Assets"); migrationBuilder.DropColumn( name: "AssetBaseAssetId", table: "ExchangeRates"); migrationBuilder.DropColumn( name: "AssetBaseIsTypeCrypto", table: "ExchangeRates"); migrationBuilder.DropColumn( name: "AssetQuoteAssetId", table: "ExchangeRates"); migrationBuilder.DropColumn( name: "AssetQuoteIsTypeCrypto", table: "ExchangeRates"); migrationBuilder.AlterColumn <string>( name: "AssetQuoteId", table: "ExchangeRates", nullable: true, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AlterColumn <string>( name: "AssetBaseId", table: "ExchangeRates", nullable: true, oldClrType: typeof(string), oldNullable: true); migrationBuilder.AddPrimaryKey( name: "PK_Assets", table: "Assets", column: "AssetId"); migrationBuilder.CreateIndex( name: "IX_ExchangeRates_AssetBaseId", table: "ExchangeRates", column: "AssetBaseId"); migrationBuilder.CreateIndex( name: "IX_ExchangeRates_AssetQuoteId", table: "ExchangeRates", column: "AssetQuoteId"); migrationBuilder.AddForeignKey( name: "FK_ExchangeRates_Assets_AssetBaseId", table: "ExchangeRates", column: "AssetBaseId", principalTable: "Assets", principalColumn: "AssetId", onDelete: ReferentialAction.Restrict); migrationBuilder.AddForeignKey( name: "FK_ExchangeRates_Assets_AssetQuoteId", table: "ExchangeRates", column: "AssetQuoteId", principalTable: "Assets", principalColumn: "AssetId", onDelete: ReferentialAction.Restrict); }
protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropIndex( name: "UserNameIndex", table: "AspNetUsers"); migrationBuilder.DropIndex( name: "IX_AspNetUserRoles_UserId", table: "AspNetUserRoles"); migrationBuilder.DropIndex( name: "RoleNameIndex", table: "AspNetRoles"); migrationBuilder.CreateTable( name: "Conversationses", columns: table => new { ConversationId = table.Column <int>(nullable: false) .Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn), FirstUserId = table.Column <string>(nullable: true), SecondUserId = table.Column <string>(nullable: true) }, constraints: table => { table.PrimaryKey("PK_Conversationses", x => x.ConversationId); table.ForeignKey( name: "FK_Conversationses_AspNetUsers_FirstUserId", column: x => x.FirstUserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); table.ForeignKey( name: "FK_Conversationses_AspNetUsers_SecondUserId", column: x => x.SecondUserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Restrict); }); 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.CreateIndex( name: "IX_Conversationses_FirstUserId", table: "Conversationses", column: "FirstUserId"); migrationBuilder.CreateIndex( name: "IX_Conversationses_SecondUserId", table: "Conversationses", column: "SecondUserId"); migrationBuilder.AddForeignKey( name: "FK_AspNetUserTokens_AspNetUsers_UserId", table: "AspNetUserTokens", column: "UserId", principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }