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.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.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("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("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.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.RemoveColumn("Tariffs", "TarifficationType");
}
public override void Apply()
{
Database.RemoveColumn("Orders", "ClientName");
Database.RemoveColumn("Orders", "SoldTo");
Database.AddColumn("Orders", new Column("ClientId", DbType.Guid, ColumnProperty.Null));
}
public override void Apply()
{
Database.RemoveColumn("Warehouses", "CustomerWarehouse");
}
public override void Apply()
{
Database.RemoveColumn("Warehouses", "UsePickingType");
}