MovieBase_Project/MovieBase/Migrations/201905041110296_Initial.cs

namespace MovieBase.Migrations
{
	using System.Data.Entity.Migrations;

	public partial class Initial : DbMigration
	{
		public override void Up()
		{
			CreateTable(
				"dbo.Actors",
				c => new
				{
					ActorId = c.Guid(nullable: false, identity: true),
					FirstName = c.String(),
					LastName = c.String(),
				})
				.PrimaryKey(t => t.ActorId);

			CreateTable(
				"dbo.Movies",
				c => new
				{
					MovieId = c.Guid(nullable: false, identity: true),
					Name = c.String(),
					ProductionTime = c.DateTime(nullable: false),
				})
				.PrimaryKey(t => t.MovieId);

			CreateTable(
				"dbo.AspNetRoles",
				c => new
				{
					Id = c.String(nullable: false, maxLength: 128),
					Name = c.String(nullable: false, maxLength: 256),
				})
				.PrimaryKey(t => t.Id)
				.Index(t => t.Name, unique: true, name: "RoleNameIndex");

			CreateTable(
				"dbo.AspNetUserRoles",
				c => new
				{
					UserId = c.String(nullable: false, maxLength: 128),
					RoleId = c.String(nullable: false, maxLength: 128),
				})
				.PrimaryKey(t => new { t.UserId, t.RoleId })
				.ForeignKey("dbo.AspNetRoles", t => t.RoleId, cascadeDelete: true)
				.ForeignKey("dbo.AspNetUsers", t => t.UserId, cascadeDelete: true)
				.Index(t => t.UserId)
				.Index(t => t.RoleId);

			CreateTable(
				"dbo.AspNetUsers",
				c => new
				{
					Id = c.String(nullable: false, maxLength: 128),
					Email = c.String(maxLength: 256),
					EmailConfirmed = c.Boolean(nullable: false),
					PasswordHash = c.String(),
					SecurityStamp = c.String(),
					PhoneNumber = c.String(),
					PhoneNumberConfirmed = c.Boolean(nullable: false),
					TwoFactorEnabled = c.Boolean(nullable: false),
					LockoutEndDateUtc = c.DateTime(),
					LockoutEnabled = c.Boolean(nullable: false),
					AccessFailedCount = c.Int(nullable: false),
					UserName = c.String(nullable: false, maxLength: 256),
				})
				.PrimaryKey(t => t.Id)
				.Index(t => t.UserName, unique: true, name: "UserNameIndex");

			CreateTable(
				"dbo.AspNetUserClaims",
				c => new
				{
					Id = c.Int(nullable: false, identity: true),
					UserId = c.String(nullable: false, maxLength: 128),
					ClaimType = c.String(),
					ClaimValue = c.String(),
				})
				.PrimaryKey(t => t.Id)
				.ForeignKey("dbo.AspNetUsers", t => t.UserId, cascadeDelete: true)
				.Index(t => t.UserId);

			CreateTable(
				"dbo.AspNetUserLogins",
				c => new
				{
					LoginProvider = c.String(nullable: false, maxLength: 128),
					ProviderKey = c.String(nullable: false, maxLength: 128),
					UserId = c.String(nullable: false, maxLength: 128),
				})
				.PrimaryKey(t => new { t.LoginProvider, t.ProviderKey, t.UserId })
				.ForeignKey("dbo.AspNetUsers", t => t.UserId, cascadeDelete: true)
				.Index(t => t.UserId);

			CreateTable(
				"dbo.MovieActors",
				c => new
				{
					Movie_MovieId = c.Guid(nullable: false),
					Actor_ActorId = c.Guid(nullable: false),
				})
				.PrimaryKey(t => new { t.Movie_MovieId, t.Actor_ActorId })
				.ForeignKey("dbo.Movies", t => t.Movie_MovieId, cascadeDelete: true)
				.ForeignKey("dbo.Actors", t => t.Actor_ActorId, cascadeDelete: true)
				.Index(t => t.Movie_MovieId)
				.Index(t => t.Actor_ActorId);

		}

		public override void Down()
		{
			DropForeignKey("dbo.AspNetUserRoles", "UserId", "dbo.AspNetUsers");
			DropForeignKey("dbo.AspNetUserLogins", "UserId", "dbo.AspNetUsers");
			DropForeignKey("dbo.AspNetUserClaims", "UserId", "dbo.AspNetUsers");
			DropForeignKey("dbo.AspNetUserRoles", "RoleId", "dbo.AspNetRoles");
			DropForeignKey("dbo.MovieActors", "Actor_ActorId", "dbo.Actors");
			DropForeignKey("dbo.MovieActors", "Movie_MovieId", "dbo.Movies");
			DropIndex("dbo.MovieActors", new[] { "Actor_ActorId" });
			DropIndex("dbo.MovieActors", new[] { "Movie_MovieId" });
			DropIndex("dbo.AspNetUserLogins", new[] { "UserId" });
			DropIndex("dbo.AspNetUserClaims", new[] { "UserId" });
			DropIndex("dbo.AspNetUsers", "UserNameIndex");
			DropIndex("dbo.AspNetUserRoles", new[] { "RoleId" });
			DropIndex("dbo.AspNetUserRoles", new[] { "UserId" });
			DropIndex("dbo.AspNetRoles", "RoleNameIndex");
			DropTable("dbo.MovieActors");
			DropTable("dbo.AspNetUserLogins");
			DropTable("dbo.AspNetUserClaims");
			DropTable("dbo.AspNetUsers");
			DropTable("dbo.AspNetUserRoles");
			DropTable("dbo.AspNetRoles");
			DropTable("dbo.Movies");
			DropTable("dbo.Actors");
		}
	}
}