Mark the Order.OrderGuid field as unique in the database

[skoshelev]

At the moment, it is only implied that the Order.OrderGuid field will be unique for a specific database, but in reality, there are no corresponding checks, which can lead to collisions, for example, when importing data from external sources

[skoshelev]

Closed #7377

[Hakkology]

If you are just making a nopcommerce site, this gives an error as constraint is already available.
Perhaps another boolean check could be considered ?

        if (!Schema.Table(nameof(Order)).Index("AK_Order_OrderGuid").Exists()
            && !Schema.Table(nameof(Order)).Constraint("AK_Order_OrderGuid").Exists())
        {
            var orders = _dataProvider.GetTable<Order>().GroupBy(p => p.OrderGuid, p => p)
                .Where(p => p.Count() > 1)
                .SelectMany(p => p)
                .ToList();

            if (orders.Any())
            {
                foreach (var order in orders)
                    order.OrderGuid = Guid.NewGuid();

                _dataProvider.UpdateEntities(orders);
            }

            Create.UniqueConstraint("AK_Order_OrderGuid")
                .OnTable(nameof(Order))
                .Column(nameof(Order.OrderGuid));
        }

[skoshelev]

Hi @Hakkology.

Thank you for your help