in 006-AppModernization/Student/Resources/OnPremApp/IaaS2PaaSWeb/PartsUnlimitedWebsite/Migrations/201503130633247_InitialMigration.cs [10:235]
public override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.CreateTable("AspNetRoles",
c => new
{
Id = c.String(),
ConcurrencyStamp = c.String(),
Name = c.String(),
NormalizedName = c.String()
})
.PrimaryKey("PK_AspNetRoles", t => t.Id);
migrationBuilder.CreateTable("AspNetRoleClaims",
c => new
{
Id = c.Int(nullable: false, identity: true),
ClaimType = c.String(),
ClaimValue = c.String(),
RoleId = c.String()
})
.PrimaryKey("PK_AspNetRoleClaims", t => t.Id);
migrationBuilder.CreateTable("AspNetUserClaims",
c => new
{
Id = c.Int(nullable: false, identity: true),
ClaimType = c.String(),
ClaimValue = c.String(),
UserId = c.String()
})
.PrimaryKey("PK_AspNetUserClaims", t => t.Id);
migrationBuilder.CreateTable("AspNetUserLogins",
c => new
{
LoginProvider = c.String(),
ProviderKey = c.String(),
ProviderDisplayName = c.String(),
UserId = c.String()
})
.PrimaryKey("PK_AspNetUserLogins", t => new { t.LoginProvider, t.ProviderKey });
migrationBuilder.CreateTable("AspNetUserRoles",
c => new
{
UserId = c.String(),
RoleId = c.String()
})
.PrimaryKey("PK_AspNetUserRoles", t => new { t.UserId, t.RoleId });
migrationBuilder.CreateTable("AspNetUsers",
c => new
{
Id = c.String(),
AccessFailedCount = c.Int(nullable: false),
ConcurrencyStamp = c.String(),
Email = c.String(),
EmailConfirmed = c.Boolean(nullable: false),
LockoutEnabled = c.Boolean(nullable: false),
LockoutEnd = c.DateTimeOffset(),
Name = c.String(),
NormalizedEmail = c.String(),
NormalizedUserName = c.String(),
PasswordHash = c.String(),
PhoneNumber = c.String(),
PhoneNumberConfirmed = c.Boolean(nullable: false),
SecurityStamp = c.String(),
TwoFactorEnabled = c.Boolean(nullable: false),
UserName = c.String()
})
.PrimaryKey("PK_AspNetUsers", t => t.Id);
migrationBuilder.CreateTable("CartItem",
c => new
{
CartItemId = c.Int(nullable: false, identity: true),
CartId = c.String(),
Count = c.Int(nullable: false),
DateCreated = c.DateTime(nullable: false),
ProductId = c.Int(nullable: false)
})
.PrimaryKey("PK_CartItem", t => t.CartItemId);
migrationBuilder.CreateTable("Category",
c => new
{
CategoryId = c.Int(nullable: false, identity: true),
Description = c.String(),
Name = c.String()
})
.PrimaryKey("PK_Category", t => t.CategoryId);
migrationBuilder.CreateTable("Order",
c => new
{
OrderId = c.Int(nullable: false, identity: true),
Address = c.String(),
City = c.String(),
Country = c.String(),
Email = c.String(),
Name = c.String(),
OrderDate = c.DateTime(nullable: false),
Phone = c.String(),
PostalCode = c.String(),
State = c.String(),
Total = c.Decimal(nullable: false),
Username = c.String()
})
.PrimaryKey("PK_Order", t => t.OrderId);
migrationBuilder.CreateTable("OrderDetail",
c => new
{
OrderDetailId = c.Int(nullable: false, identity: true),
Quantity = c.Int(nullable: false),
UnitPrice = c.Decimal(nullable: false),
OrderId = c.Int(nullable: false),
ProductId = c.Int(nullable: false)
})
.PrimaryKey("PK_OrderDetail", t => t.OrderDetailId);
migrationBuilder.CreateTable("Product",
c => new
{
ProductId = c.Int(nullable: false, identity: true),
Created = c.DateTime(nullable: false),
Price = c.Decimal(nullable: false),
ProductArtUrl = c.String(),
SalePrice = c.Decimal(nullable: false),
Title = c.String(),
CategoryId = c.Int(nullable: false)
})
.PrimaryKey("PK_Product", t => t.ProductId);
migrationBuilder.CreateTable("Raincheck",
c => new
{
RaincheckId = c.Int(nullable: false, identity: true),
Name = c.String(),
Quantity = c.Int(nullable: false),
SalePrice = c.Double(nullable: false),
StoreId = c.Int(nullable: false),
ProductId = c.Int(nullable: false)
})
.PrimaryKey("PK_Raincheck", t => t.RaincheckId);
migrationBuilder.CreateTable("Store",
c => new
{
StoreId = c.Int(nullable: false, identity: true),
Name = c.String()
})
.PrimaryKey("PK_Store", t => t.StoreId);
migrationBuilder.AddForeignKey(
"AspNetRoleClaims",
"FK_AspNetRoleClaims_AspNetRoles_RoleId",
new[] { "RoleId" },
"AspNetRoles",
new[] { "Id" },
cascadeDelete: false);
migrationBuilder.AddForeignKey(
"AspNetUserClaims",
"FK_AspNetUserClaims_AspNetUsers_UserId",
new[] { "UserId" },
"AspNetUsers",
new[] { "Id" },
cascadeDelete: false);
migrationBuilder.AddForeignKey(
"AspNetUserLogins",
"FK_AspNetUserLogins_AspNetUsers_UserId",
new[] { "UserId" },
"AspNetUsers",
new[] { "Id" },
cascadeDelete: false);
migrationBuilder.AddForeignKey(
"CartItem",
"FK_CartItem_Product_ProductId",
new[] { "ProductId" },
"Product",
new[] { "ProductId" },
cascadeDelete: false);
migrationBuilder.AddForeignKey(
"OrderDetail",
"FK_OrderDetail_Order_OrderId",
new[] { "OrderId" },
"Order",
new[] { "OrderId" },
cascadeDelete: false);
migrationBuilder.AddForeignKey(
"OrderDetail",
"FK_OrderDetail_Product_ProductId",
new[] { "ProductId" },
"Product",
new[] { "ProductId" },
cascadeDelete: false);
migrationBuilder.AddForeignKey(
"Product",
"FK_Product_Category_CategoryId",
new[] { "CategoryId" },
"Category",
new[] { "CategoryId" },
cascadeDelete: false);
migrationBuilder.AddForeignKey(
"Raincheck",
"FK_Raincheck_Store_StoreId",
new[] { "StoreId" },
"Store",
new[] { "StoreId" },
cascadeDelete: false);
migrationBuilder.AddForeignKey(
"Raincheck",
"FK_Raincheck_Product_ProductId",
new[] { "ProductId" },
"Product",
new[] { "ProductId" },
cascadeDelete: false);
}