public override void Apply()
{
Database.AddColumn("VehicleTypes", new Column("TonnageId", DbType.Guid, property: ColumnProperty.Null));
Database.AddColumn("VehicleTypes", new Column("BodyTypeId", DbType.Guid, property: ColumnProperty.Null));
Database.AddColumn("VehicleTypes", new Column("PalletsCount", DbType.Int32, property: ColumnProperty.Null));
Database.AddColumn("VehicleTypes", new Column("IsActive", DbType.Boolean, defaultValue: true));
}
public override void Apply()
{
Database.RemoveColumn("Warehouses", "PickingFeatures");
Database.RemoveColumn("Warehouses", "SoldToNumber");
Database.AddColumn("Warehouses", new Column("ClientId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("Warehouses", new Column("Gln", DbType.String));
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("WaybillTorg12", DbType.Boolean, defaultValue: false));
Database.AddColumn("Orders", new Column("Invoice", DbType.Boolean, defaultValue: false));
Database.AddColumn("Orders", new Column("DocumentsReturnDate", DbType.DateTime, ColumnProperty.Null));
Database.AddColumn("Orders", new Column("ActualDocumentsReturnDate", DbType.DateTime, ColumnProperty.Null));
Database.AddColumn("Orders", new Column("OrderShippingStatus", DbType.Int32, ColumnProperty.Null));
}
public override void Apply()
{
Database.AddColumn("OrderItems", new Column("Description", DbType.String.WithSize(255), ColumnProperty.Null));
Database.AddColumn("OrderItems", new Column("CountryOfOrigin", DbType.String.WithSize(255), ColumnProperty.Null));
Database.AddColumn("OrderItems", new Column("SPGR", DbType.String.WithSize(100), ColumnProperty.Null));
Database.AddColumn("OrderItems", new Column("Ean", DbType.String.WithSize(100), ColumnProperty.Null));
Database.AddColumn("OrderItems", new Column("ShelfLife", DbType.Int32, ColumnProperty.Null));
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("ProductTypeId", DbType.Guid));
Database.AddColumn("Orders", new Column("ItemsNumber", DbType.Int32));
Database.AddColumn("Orders", new Column("ShippingWarehouseGln", DbType.String));
Database.AddColumn("Orders", new Column("DeliveryWarehouseGln", DbType.String));
Database.AddColumn("Orders", new Column("ShippingRegion", DbType.String));
}
public override void Apply()
{
Database.RemoveColumn("TransportCompanies", "ContractNumber");
Database.RemoveColumn("TransportCompanies", "DateOfPowerOfAttorney");
Database.AddColumn("TransportCompanies", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("TransportCompanies", new Column("PoolingId", DbType.String, ColumnProperty.Null));
}
public override void Apply()
{
Database.RemoveColumn("Tariffs", "ShipmentCity");
Database.RemoveColumn("Tariffs", "DeliveryCity");
Database.AddColumn("Tariffs", new Column("ShippingWarehouseId", DbType.Guid));
Database.AddColumn("Tariffs", new Column("DeliveryWarehouseId", DbType.Guid));
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("ShippingCity", DbType.String));
Database.ExecuteNonQuery($@"
update ""Orders""
set ""ShippingCity"" = (select ""City"" from ""ShippingWarehouses"" where ""ShippingWarehouseId"" = ""ShippingWarehouses"".""Id"")
where ""ShippingWarehouseId"" is not null
");
}
public override void Apply()
{
Database.AddColumn("Warehouses", new Column("PostalCode", DbType.String.WithSize(100)));
Database.AddColumn("Warehouses", new Column("Area", DbType.String.WithSize(255)));
Database.AddColumn("Warehouses", new Column("Street", DbType.String.WithSize(255)));
Database.AddColumn("Warehouses", new Column("House", DbType.String.WithSize(100)));
Database.AddColumn("Warehouses", new Column("ValidAddress", DbType.String.WithSize(500)));
Database.AddColumn("Warehouses", new Column("UnparsedAddressParts", DbType.String.WithSize(500)));
Database.AddColumn("Warehouses", new Column("IsActive", DbType.Boolean, defaultValue: true));
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("PickingFeatures", DbType.String.WithSize(255)));
this.Database.ExecuteNonQuery(@"
update ""Orders"" SET ""PickingFeatures"" = ""Warehouses"".""PickingFeatures""
FROM ""Warehouses""
Where ""Warehouses"".""SoldToNumber"" = ""Orders"".""SoldTo""
");
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("ClientOrderNumber", DbType.String.WithSize(100)));
Database.ExecuteNonQuery(@"
update ""Orders"" set ""ClientOrderNumber""=""OrderNumber"";
update ""Orders"" set ""OrderNumber""=""BdfInvoiceNumber"";
");
Database.RemoveColumn("Orders", "BdfInvoiceNumber");
}
public override void Apply()
{
Database.AddColumn("Users", new Column("PoolingLogin", DbType.String.WithSize(50)));
Database.AddColumn("Users", new Column("PoolingPassword", DbType.String.WithSize(50)));
Database.AddColumn("Users", new Column("PoolingAccessToken", DbType.String.WithSize(1000)));
Database.AddColumn("Users", new Column("PoolingRefreshToken", DbType.String.WithSize(1000)));
Database.AddColumn("Users", new Column("FmCPLogin", DbType.String.WithSize(50)));
Database.AddColumn("Users", new Column("FmCPPassword", DbType.String.WithSize(50)));
Database.AddColumn("Users", new Column("FmCPAccessToken", DbType.String.WithSize(1000)));
Database.AddColumn("Users", new Column("FmCPRefreshToken", DbType.String.WithSize(1000)));
}
public override void Apply()
{
Database.RemoveColumn("ShippingWarehouses", "Code");
Database.RemoveColumn("ShippingWarehouses", "ValidAddress");
Database.AddColumn("ShippingWarehouses", new Column("Gln", DbType.String));
Database.AddColumn("ShippingWarehouses", new Column("Settlement", DbType.String));
Database.AddColumn("ShippingWarehouses", new Column("Block", DbType.String.WithSize(100)));
Database.AddColumn("ShippingWarehouses", new Column("RegionId", DbType.String.WithSize(100)));
Database.AddColumn("ShippingWarehouses", new Column("UnparsedParts", DbType.String.WithSize(1000)));
}
public override void Apply()
{
Database.AddColumn("DocumentTypes", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("Tonnages", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("BodyTypes", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("VehicleTypes", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("PickingTypes", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("Articles", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("ShippingWarehouses", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("Warehouses", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("Users", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("Roles", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("Tariffs", new Column("CompanyId", DbType.Guid, ColumnProperty.Null));
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("CarrierId", DbType.Guid, ColumnProperty.Null));
Database.AddColumn("Orders", new Column("DeliveryType", DbType.Int32, ColumnProperty.Null));
Database.AddColumn("Orders", new Column("DeviationsComment", DbType.String.WithSize(1000), ColumnProperty.Null));
Database.AddColumn("Orders", new Column("DeliveryCost", DbType.Decimal.WithSize(19, 5), ColumnProperty.Null));
Database.AddColumn("Orders", new Column("ActualDeliveryCost", DbType.Decimal.WithSize(19, 5), ColumnProperty.Null));
Database.ExecuteNonQuery($@"
update ""Orders""
set ""CarrierId"" = (select ""Shippings"".""CarrierId"" from ""Shippings"" where ""Shippings"".""Id"" = ""Orders"".""ShippingId"" limit 1)
where ""ShippingId"" is not null;
update ""Orders""
set ""DeliveryType"" = (select ""Warehouses"".""DeliveryType"" from ""Warehouses"" where ""Warehouses"".""Id"" = ""Orders"".""DeliveryWarehouseId"" limit 1)
where ""DeliveryWarehouseId"" is not null;
");
}
public override void Apply()
{
Database.AddColumn("Clients", new Column("Inn", DbType.String.WithSize(12)));
Database.AddColumn("Clients", new Column("Cpp", DbType.String.WithSize(10)));
Database.AddColumn("Clients", new Column("LegalAddress", DbType.String.WithSize(250)));
Database.AddColumn("Clients", new Column("ActualAddress", DbType.String.WithSize(250)));
Database.AddColumn("Clients", new Column("ContactPerson", DbType.String.WithSize(300)));
Database.AddColumn("Clients", new Column("ContactPhone", DbType.String.WithSize(16)));
Database.AddColumn("Clients", new Column("Email", DbType.String.WithSize(70)));
Database.AddColumn("TransportCompanies", new Column("Inn", DbType.String.WithSize(12)));
Database.AddColumn("TransportCompanies", new Column("Cpp", DbType.String.WithSize(10)));
Database.AddColumn("TransportCompanies", new Column("LegalAddress", DbType.String.WithSize(250)));
Database.AddColumn("TransportCompanies", new Column("ActualAddress", DbType.String.WithSize(250)));
Database.AddColumn("TransportCompanies", new Column("ContactPerson", DbType.String.WithSize(300)));
Database.AddColumn("TransportCompanies", new Column("ContactPhone", DbType.String.WithSize(16)));
Database.AddColumn("TransportCompanies", new Column("Email", DbType.String.WithSize(70)));
}
public override void Apply()
{
Database.AddTable("Providers",
new Column("Id", DbType.Guid, ColumnProperty.PrimaryKey),
new Column("Name", DbType.String.WithSize(200)),
new Column("Inn", DbType.String.WithSize(12)),
new Column("Cpp", DbType.String.WithSize(10)),
new Column("LegalAddress", DbType.String.WithSize(250)),
new Column("ActualAddress", DbType.String.WithSize(250)),
new Column("ContactPerson", DbType.String.WithSize(300)),
new Column("ContactPhone", DbType.String.WithSize(16)),
new Column("Email", DbType.String.WithSize(70)),
new Column("IsActive", DbType.Boolean, defaultValue: true)
);
Database.AddColumn("Users", new Column("ProviderId", DbType.Guid));
Database.AddColumn("Tariffs", new Column("ProviderId", DbType.Guid));
Database.RemoveColumn("Tariffs", "CompanyId");
}
public override void Apply()
{
Database.AddColumn("Users", new Column("ClientId", DbType.Guid));
Database.RemoveColumn("Users", "CompanyId");
Database.RemoveColumn("BodyTypes", "CompanyId");
Database.RemoveColumn("Clients", "CompanyId");
Database.RemoveColumn("DocumentTypes", "CompanyId");
Database.RemoveColumn("FieldPropertyItems", "CompanyId");
Database.RemoveColumn("FieldPropertyVisibilityItems", "CompanyId");
Database.RemoveColumn("Orders", "CompanyId");
Database.RemoveColumn("PickingTypes", "CompanyId");
Database.RemoveColumn("ProductTypes", "CompanyId");
Database.RemoveColumn("Roles", "CompanyId");
Database.RemoveColumn("ShippingWarehouses", "CompanyId");
Database.AddColumn("ShippingWarehouses", new Column("ClientId", DbType.Guid));
Database.RemoveColumn("Warehouses", "CompanyId");
Database.AddColumn("Warehouses", new Column("ProviderId", DbType.Guid));
Database.RemoveColumn("Shippings", "CompanyId");
Database.RemoveColumn("Tonnages", "CompanyId");
Database.RemoveColumn("TransportCompanies", "CompanyId");
Database.RemoveColumn("VehicleTypes", "CompanyId");
Database.RemoveTable("Companies");
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("UserCreatorId", DbType.Guid, ColumnProperty.Null));
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("Depositor", DbType.String));
}
public override void Apply()
{
Database.AddColumn("Shippings", new Column("Driver", DbType.String));
Database.AddColumn("Shippings", new Column("VehicleNumber", DbType.String.WithSize(50)));
}
public override void Apply()
{
Database.AddColumn("BodyTypes", new Column("PoolingId", DbType.String, ColumnProperty.Null));
}
public override void Apply()
{
Database.AddColumn("Clients", new Column("ReportId", DbType.String));
Database.AddColumn("TransportCompanies", new Column("ReportId", DbType.String));
}
public override void Apply()
{
Database.AddColumn("Tariffs", new Column("StartWinterPeriod", DbType.DateTime, property: ColumnProperty.Null));
Database.AddColumn("Tariffs", new Column("EndWinterPeriod", DbType.DateTime, property: ColumnProperty.Null));
Database.AddColumn("Tariffs", new Column("WinterAllowance", DbType.Decimal, property: ColumnProperty.Null));
}
public override void Apply()
{
Database.AddColumn("Shippings", new Column("Route", DbType.String));
}
public override void Apply()
{
Database.AddColumn("Providers", new Column("ReportPageNameForMobile", DbType.String, ColumnProperty.Null));
}
public override void Apply()
{
Database.AddColumn("Shippings", new Column("FmcpWaybillId", DbType.String.WithSize(50)));
}
public override void Apply()
{
Database.AddColumn("Shippings", new Column("BodyTypeId", DbType.Guid, property: ColumnProperty.Null));
}
public override void Apply()
{
Database.AddColumn("Orders", new Column("DocumentReturnStatus", DbType.Boolean, defaultValue: false));
}
public override void Apply()
{
Database.AddColumn("Warehouses", new Column("Longitude", DbType.String));
Database.AddColumn("Warehouses", new Column("Latitude", DbType.String));
}
