in src/Infrastructure/Data/Migrations/20190302011807_Initial.cs [12:193]
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.CreateSequence(
name: "catalog_brand_hilo",
incrementBy: 10);
migrationBuilder.CreateSequence(
name: "catalog_hilo",
incrementBy: 10);
migrationBuilder.CreateSequence(
name: "catalog_type_hilo",
incrementBy: 10);
migrationBuilder.CreateTable(
name: "Baskets",
columns: table => new
{
Id = table.Column<int>(nullable: false)
.Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
BuyerId = table.Column<string>(nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_Baskets", x => x.Id);
});
migrationBuilder.CreateTable(
name: "CatalogBrand",
columns: table => new
{
Id = table.Column<int>(nullable: false),
Brand = table.Column<string>(maxLength: 100, nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_CatalogBrand", x => x.Id);
});
migrationBuilder.CreateTable(
name: "CatalogType",
columns: table => new
{
Id = table.Column<int>(nullable: false),
Type = table.Column<string>(maxLength: 100, nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_CatalogType", x => x.Id);
});
migrationBuilder.CreateTable(
name: "Orders",
columns: table => new
{
Id = table.Column<int>(nullable: false)
.Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
BuyerId = table.Column<string>(nullable: true),
OrderDate = table.Column<DateTimeOffset>(nullable: false),
ShipToAddress_Street = table.Column<string>(nullable: true),
ShipToAddress_City = table.Column<string>(nullable: true),
ShipToAddress_State = table.Column<string>(nullable: true),
ShipToAddress_CountryRegion = table.Column<string>(nullable: true),
ShipToAddress_ZipCode = table.Column<string>(nullable: true),
PaymentDetails_CardholderName = table.Column<string>(nullable: true),
PaymentDetails_Last4DigitsCardNumber = table.Column<string>(nullable: true),
PaymentDetails_CardType = table.Column<string>(nullable: true),
PaymentDetails_CVV = table.Column<string>(nullable: true),
PaymentDetails_ExpirationDate = table.Column<string>(nullable: true),
Status = table.Column<int>(nullable: false),
ReturnOrChargebackReason = table.Column<string>(nullable: true),
AdminComments = table.Column<string>(nullable: true),
SubTotal = table.Column<decimal>(type: "Money", nullable: false),
Tax = table.Column<decimal>(type: "Money", nullable: false),
Total = table.Column<decimal>(type: "Money", nullable: false),
RiskChargebackJson = table.Column<string>(nullable: true),
RiskChargebackResponseJson = table.Column<string>(nullable: true),
RiskPurchaseJson = table.Column<string>(nullable: true),
RiskPurchaseResponseJson = table.Column<string>(nullable: true),
RiskRefundJson = table.Column<string>(nullable: true),
RiskRefundResponseJson = table.Column<string>(nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_Orders", x => x.Id);
});
migrationBuilder.CreateTable(
name: "BasketItem",
columns: table => new
{
Id = table.Column<int>(nullable: false)
.Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
UnitPrice = table.Column<decimal>(type: "Money", nullable: false),
Quantity = table.Column<int>(nullable: false),
CatalogItemId = table.Column<int>(nullable: false),
BasketId = table.Column<int>(nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_BasketItem", x => x.Id);
table.ForeignKey(
name: "FK_BasketItem_Baskets_BasketId",
column: x => x.BasketId,
principalTable: "Baskets",
principalColumn: "Id",
onDelete: ReferentialAction.Restrict);
});
migrationBuilder.CreateTable(
name: "Catalog",
columns: table => new
{
Id = table.Column<int>(nullable: false),
Name = table.Column<string>(maxLength: 50, nullable: false),
Description = table.Column<string>(nullable: true),
Price = table.Column<decimal>(type: "Money", nullable: false),
PictureUri = table.Column<string>(nullable: true),
CatalogTypeId = table.Column<int>(nullable: false),
CatalogBrandId = table.Column<int>(nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_Catalog", x => x.Id);
table.ForeignKey(
name: "FK_Catalog_CatalogBrand_CatalogBrandId",
column: x => x.CatalogBrandId,
principalTable: "CatalogBrand",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
table.ForeignKey(
name: "FK_Catalog_CatalogType_CatalogTypeId",
column: x => x.CatalogTypeId,
principalTable: "CatalogType",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
});
migrationBuilder.CreateTable(
name: "OrderItems",
columns: table => new
{
Id = table.Column<int>(nullable: false)
.Annotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn),
ItemOrdered_CatalogItemId = table.Column<int>(nullable: false),
ItemOrdered_ProductName = table.Column<string>(nullable: true),
ItemOrdered_PictureUri = table.Column<string>(nullable: true),
UnitPrice = table.Column<decimal>(type: "Money", nullable: false),
Units = table.Column<int>(nullable: false),
OrderId = table.Column<int>(nullable: true)
},
constraints: table =>
{
table.PrimaryKey("PK_OrderItems", x => x.Id);
table.ForeignKey(
name: "FK_OrderItems_Orders_OrderId",
column: x => x.OrderId,
principalTable: "Orders",
principalColumn: "Id",
onDelete: ReferentialAction.Restrict);
});
migrationBuilder.CreateIndex(
name: "IX_BasketItem_BasketId",
table: "BasketItem",
column: "BasketId");
migrationBuilder.CreateIndex(
name: "IX_Catalog_CatalogBrandId",
table: "Catalog",
column: "CatalogBrandId");
migrationBuilder.CreateIndex(
name: "IX_Catalog_CatalogTypeId",
table: "Catalog",
column: "CatalogTypeId");
migrationBuilder.CreateIndex(
name: "IX_OrderItems_OrderId",
table: "OrderItems",
column: "OrderId");
}