public void Downgrade(IDotEntityTransaction transaction)
{
Db.DropConstraint(Relation.Create <User, ConnectedAccount>("Id", "UserId"), transaction);
Db.DropTable <ConnectedAccount>(transaction);
Db.DropColumn <Product>(nameof(Product.RestrictedToRoles), transaction);
Db.DropTable <EntityRole>(transaction);
}
public void Downgrade(IDotEntityTransaction transaction)
{
Db.DropColumn <OrderFulfillment>(nameof(OrderFulfillment.Locked), transaction);
Db.DropConstraint(Relation.Create <Store, EntityStore>("Id", "StoreId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductCatalog>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <Catalog, ProductCatalog>("Id", "CatalogId"), transaction);
Db.DropTable <Store>(transaction);
Db.DropTable <Catalog>(transaction);
Db.DropTable <EntityStore>(transaction);
Db.DropTable <ProductCatalog>(transaction);
Db.DropTable <CatalogCountry>(transaction);
}
public void Downgrade(IDotEntityTransaction transaction)
{
Db.DropConstraint(Relation.Create <User, StoreCredit>("Id", "UserId"), transaction);
Db.DropTable <StoreCredit>(transaction);
Db.DropColumn <User>(nameof(User.FirstActivationDate), transaction);
Db.DropColumn <User>(nameof(User.IsAffiliate), transaction);
Db.DropColumn <User>(nameof(User.AffiliateActive), transaction);
Db.DropColumn <User>(nameof(User.AffiliateFirstActivationDate), transaction);
Db.DropColumn <Order>(nameof(Order.UsedStoreCredits), transaction);
Db.DropColumn <Order>(nameof(Order.StoreCredits), transaction);
Db.DropColumn <Order>(nameof(Order.StoreCreditAmount), transaction);
Db.DropColumn <Cart>(nameof(Cart.UseStoreCredits), transaction);
}
public void Downgrade(IDotEntityTransaction transaction)
{
Db.DropTable <EntityTag>(transaction);
Db.DropColumn <MenuItem>(nameof(MenuItem.OpenInNewWindow), transaction);
var parentCategoryIdCol = DotEntityDb.Provider.SafeEnclose(nameof(Category.ParentCategoryId));
var parentIdCol = DotEntityDb.Provider.SafeEnclose(nameof(Category.ParentId));
var categoryTable = DotEntityDb.GetTableNameForType <Category>();
Db.AddColumn <Category, int>(nameof(Category.ParentCategoryId), 0, transaction);
Db.Query($"UPDATE {categoryTable} SET {parentCategoryIdCol}={parentIdCol}", null, transaction);
Db.DropColumn <Category>(nameof(Category.ParentId), transaction);
Db.DropColumn <ContentPage>(nameof(ContentPage.ParentId), transaction);
}
public void Downgrade(IDotEntityTransaction transaction)
{
Db.DropConstraint(Relation.Create <User, UserRole>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Role, UserRole>("Id", "RoleId"), transaction);
Db.DropConstraint(Relation.Create <Role, RoleCapability>("Id", "RoleId"), transaction);
Db.DropConstraint(Relation.Create <Capability, RoleCapability>("Id", "CapabilityId"), transaction);
Db.DropConstraint(Relation.Create <Capability, UserCapability>("Id", "CapabilityId"), transaction);
Db.DropConstraint(Relation.Create <User, UserCapability>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <User, VendorUser>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Vendor, VendorUser>("Id", "VendorId"), transaction);
Db.DropConstraint(Relation.Create <Country, Address>("Id", "CountryId"), transaction);
Db.DropConstraint(Relation.Create <User, UserPoint>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <User, Notification>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductCategory>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <Category, ProductCategory>("Id", "CategoryId"), transaction);
Db.DropConstraint(Relation.Create <AvailableAttribute, AvailableAttributeValue>("Id", "AvailableAttributeId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductAttribute>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <AvailableAttribute, ProductAttribute>("Id", "AvailableAttributeId"), transaction);
Db.DropConstraint(Relation.Create <AvailableAttributeValue, ProductAttributeValue>("Id", "AvailableAttributeValueId"), transaction);
Db.DropConstraint(Relation.Create <ProductAttribute, ProductAttributeValue>("Id", "ProductAttributeId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductVendor>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <Vendor, ProductVendor>("Id", "VendorId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductVariant>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <ProductVariant, ProductVariantAttribute>("Id", "ProductVariantId"), transaction);
Db.DropConstraint(Relation.Create <ProductAttribute, ProductVariantAttribute>("Id", "ProductAttributeId"), transaction);
Db.DropConstraint(Relation.Create <ProductAttributeValue, ProductVariantAttribute>("Id", "ProductAttributeValueId"), transaction);
Db.DropConstraint(Relation.Create <Media, ProductMedia>("Id", "MediaId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductMedia>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <User, Review>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Product, Review>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <Order, Review>("Id", "OrderId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductSpecificationGroup>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductSpecification>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <ProductSpecification, ProductSpecificationValue>("Id", "ProductSpecificationId"), transaction);
Db.DropConstraint(Relation.Create <AvailableAttribute, ProductSpecification>("Id", "AvailableAttributeId"), transaction);
Db.DropConstraint(Relation.Create <AvailableAttributeValue, ProductSpecificationValue>("Id", "AvailableAttributeValueId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductRelation>("Id", "SourceProductId"), transaction);
Db.DropConstraint(Relation.Create <Product, ProductRelation>("Id", "DestinationProductId"), transaction);
Db.DropConstraint(Relation.Create <Product, Download>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <DiscountCoupon, RestrictionValue>("Id", "DiscountCouponId"), transaction);
Db.DropConstraint(Relation.Create <Tax, TaxRate>("Id", "TaxId"), transaction);
Db.DropConstraint(Relation.Create <EmailAccount, EmailTemplate>("Id", "EmailAccountId"), transaction);
Db.DropConstraint(Relation.Create <Cart, CartItem>("Id", "CartId"), transaction);
Db.DropConstraint(Relation.Create <User, Cart>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Order, OrderItem>("Id", "OrderId"), transaction);
Db.DropConstraint(Relation.Create <User, Order>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Product, CartItem>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <Product, OrderItem>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <Shipment, ShipmentItem>("Id", "ShipmentId"), transaction);
Db.DropConstraint(Relation.Create <Shipment, ShipmentHistory>("Id", "ShipmentId"), transaction);
Db.DropConstraint(Relation.Create <Order, OrderFulfillment>("Id", "OrderId"), transaction);
Db.DropConstraint(Relation.Create <User, ContentPage>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Menu, MenuItem>("Id", "MenuId"), transaction);
Db.DropConstraint(Relation.Create <User, PreviousPassword>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Consent, ConsentLog>("Id", "ConsentId"), transaction);
Db.DropConstraint(Relation.Create <Consent, UserConsent>("Id", "ConsentId"), transaction);
Db.DropConstraint(Relation.Create <User, UserConsent>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Product, WarehouseInventory>("Id", "ProductId"), transaction);
Db.DropConstraint(Relation.Create <Warehouse, WarehouseInventory>("Id", "WarehouseId"), transaction);
//Db.DropConstraint(Relation.Create<ProductVariant, WarehouseInventory>("Id", "ProductVariantId"), transaction, false);
Db.DropConstraint(Relation.Create <Address, Warehouse>("Id", "AddressId"), transaction);
Db.DropConstraint(Relation.Create <User, Upload>("Id", "UserId"), transaction);
Db.DropConstraint(Relation.Create <Download, ItemDownload>("Id", "DownloadId"), transaction);
//user
Db.DropTable <User>(transaction);
Db.DropTable <Role>(transaction);
Db.DropTable <Capability>(transaction);
Db.DropTable <UserRole>(transaction);
Db.DropTable <RoleCapability>(transaction);
Db.DropTable <UserCapability>(transaction);
Db.DropTable <Vendor>(transaction);
Db.DropTable <VendorUser>(transaction);
Db.DropTable <Address>(transaction);
Db.DropTable <Country>(transaction);
Db.DropTable <StateOrProvince>(transaction);
Db.DropTable <InviteRequest>(transaction);
Db.DropTable <UserPoint>(transaction);
Db.DropTable <NotificationEvent>(transaction);
Db.DropTable <Notification>(transaction);
//shop
Db.DropTable <Product>(transaction);
Db.DropTable <Category>(transaction);
Db.DropTable <ProductCategory>(transaction);
Db.DropTable <AvailableAttribute>(transaction);
Db.DropTable <AvailableAttributeValue>(transaction);
Db.DropTable <ProductAttribute>(transaction);
Db.DropTable <ProductAttributeValue>(transaction);
Db.DropTable <Manufacturer>(transaction);
Db.DropTable <ProductVendor>(transaction);
Db.DropTable <ProductVariant>(transaction);
Db.DropTable <ProductVariantAttribute>(transaction);
Db.DropTable <Media>(transaction);
Db.DropTable <ProductMedia>(transaction);
Db.DropTable <Review>(transaction);
Db.DropTable <ProductSpecificationGroup>(transaction);
Db.DropTable <ProductSpecification>(transaction);
Db.DropTable <ProductSpecificationValue>(transaction);
Db.DropTable <ProductRelation>(transaction);
Db.DropTable <Download>(transaction);
Db.DropTable <ItemDownload>(transaction);
//cart
Db.DropTable <Cart>(transaction);
Db.DropTable <CartItem>(transaction);
Db.DropTable <Order>(transaction);
Db.DropTable <OrderItem>(transaction);
Db.DropTable <OrderFulfillment>(transaction);
Db.DropTable <Shipment>(transaction);
Db.DropTable <ShipmentItem>(transaction);
Db.DropTable <ShipmentHistory>(transaction);
Db.DropTable <PaymentTransaction>(transaction);
Db.DropTable <ReturnRequest>(transaction);
Db.DropTable <DiscountCoupon>(transaction);
Db.DropTable <RestrictionValue>(transaction);
//tax
Db.DropTable <Tax>(transaction);
Db.DropTable <TaxRate>(transaction);
//content
Db.DropTable <ContentPage>(transaction);
//emails
Db.DropTable <EmailAccount>(transaction);
Db.DropTable <EmailTemplate>(transaction);
Db.DropTable <EmailMessage>(transaction);
//menus
Db.DropTable <Menu>(transaction);
Db.DropTable <MenuItem>(transaction);
//old password and active codes
Db.DropTable <PreviousPassword>(transaction);
Db.DropTable <UserCode>(transaction);
Db.DropTable <Currency>(transaction);
//gdpr
Db.DropTable <Consent>(transaction);
Db.DropTable <ConsentLog>(transaction);
Db.DropTable <UserConsent>(transaction);
Db.DropTable <ConsentGroup>(transaction);
//warehouses
Db.DropTable <Warehouse>(transaction);
Db.DropTable <WarehouseInventory>(transaction);
//settings, logs, and others
Db.DropTable <Setting>(transaction);
Db.DropTable <Log>(transaction);
Db.DropTable <SeoMeta>(transaction);
Db.DropTable <ScheduledTask>(transaction);
Db.DropTable <CustomLabel>(transaction);
Db.DropTable <EntityProperty>(transaction);
Db.DropTable <Subscription>(transaction);
Db.DropTable <Upload>(transaction);
}
public void Downgrade(IDotEntityTransaction transaction)
{
Db.DropTable <SearchTerm>(transaction);
}
public void Downgrade(IDotEntityTransaction transaction)
{
Db.DropConstraint(Relation.Create <Media, UiSlider>("Id", "MediaId"), transaction);
Db.DropTable <UiSlider>(transaction);
}
