Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- namespace MaranelloClassicParts.DataAccess.Migrations
- {
- using System;
- using System.Data.Entity.Migrations;
- public partial class AddNewFieldsForPartClasses : DbMigration
- {
- public override void Up()
- {
- DropForeignKey("dbo.PartClassCategoryMap", "PartClassId", "dbo.PartClass");
- CreateTable(
- "dbo.PartClass",
- c => new
- {
- ID = c.Int(nullable: false),
- Code = c.String(maxLength: 4),
- Description = c.String(maxLength: 256),
- ObsPeriod = c.Int(),
- CreatedAt = c.DateTimeOffset(precision: 7),
- CreatedByUserId = c.Int(),
- ModifiedAt = c.DateTimeOffset(precision: 7),
- ModifiedByUserId = c.Int(),
- })
- .PrimaryKey(t => t.ID)
- .ForeignKey("dbo.CPUser", t => t.CreatedByUserId)
- .ForeignKey("dbo.CPUser", t => t.ModifiedByUserId)
- .Index(t => t.CreatedByUserId)
- .Index(t => t.ModifiedByUserId);
- AddColumn("dbo.VehicleManufacturer", "CreatedAt", c => c.DateTimeOffset(precision: 7));
- AddColumn("dbo.VehicleManufacturer", "CreatedByUserId", c => c.Int());
- AddColumn("dbo.VehicleManufacturer", "ModifiedAt", c => c.DateTimeOffset(precision: 7));
- AddColumn("dbo.VehicleManufacturer", "ModifiedByUserId", c => c.Int());
- AddColumn("dbo.PartSadCode", "IsObsolete", c => c.Boolean(nullable: false));
- AddColumn("dbo.PartSadCode", "ObsoleteDate", c => c.DateTimeOffset(precision: 7));
- AlterColumn("dbo.VehicleManufacturer", "Name", c => c.String(maxLength: 128));
- CreateIndex("dbo.VehicleManufacturer", "CreatedByUserId");
- CreateIndex("dbo.VehicleManufacturer", "ModifiedByUserId");
- AddForeignKey("dbo.VehicleManufacturer", "CreatedByUserId", "dbo.CPUser", "ID");
- AddForeignKey("dbo.VehicleManufacturer", "ModifiedByUserId", "dbo.CPUser", "ID");
- AddForeignKey("dbo.PartClassCategoryMap", "PartClassId", "dbo.PartClass", "ID", cascadeDelete: true);
- DropTable("dbo.PartClass");
- }
- public override void Down()
- {
- CreateTable(
- "dbo.PartClass",
- c => new
- {
- ID = c.Int(nullable: false),
- Code = c.String(maxLength: 50),
- Description = c.String(maxLength: 100),
- ObsPeriod = c.Int(),
- })
- .PrimaryKey(t => t.ID);
- DropForeignKey("dbo.PartClassCategoryMap", "PartClassId", "dbo.PartClass");
- DropForeignKey("dbo.PartClass", "ModifiedByUserId", "dbo.CPUser");
- DropForeignKey("dbo.PartClass", "CreatedByUserId", "dbo.CPUser");
- DropForeignKey("dbo.VehicleManufacturer", "ModifiedByUserId", "dbo.CPUser");
- DropForeignKey("dbo.VehicleManufacturer", "CreatedByUserId", "dbo.CPUser");
- DropIndex("dbo.PartClass", new[] { "ModifiedByUserId" });
- DropIndex("dbo.PartClass", new[] { "CreatedByUserId" });
- DropIndex("dbo.VehicleManufacturer", new[] { "ModifiedByUserId" });
- DropIndex("dbo.VehicleManufacturer", new[] { "CreatedByUserId" });
- AlterColumn("dbo.VehicleManufacturer", "Name", c => c.String(maxLength: 50));
- DropColumn("dbo.PartSadCode", "ObsoleteDate");
- DropColumn("dbo.PartSadCode", "IsObsolete");
- DropColumn("dbo.VehicleManufacturer", "ModifiedByUserId");
- DropColumn("dbo.VehicleManufacturer", "ModifiedAt");
- DropColumn("dbo.VehicleManufacturer", "CreatedByUserId");
- DropColumn("dbo.VehicleManufacturer", "CreatedAt");
- DropTable("dbo.PartClass");
- AddForeignKey("dbo.PartClassCategoryMap", "PartClassId", "dbo.PartClass", "ID", cascadeDelete: true);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement