Index: branches/5.1.x/install/upgrades.sql =================================================================== diff -u -r13549 -r13558 --- branches/5.1.x/install/upgrades.sql (.../upgrades.sql) (revision 13549) +++ branches/5.1.x/install/upgrades.sql (.../upgrades.sql) (revision 13558) @@ -140,4 +140,18 @@ UPDATE ConfigurationValues SET ValueList = '0=lu_none||SELECT l%3$s_Name AS OptionName, CountryStateId AS OptionValue FROM CountryStates WHERE Type = 1 ORDER BY OptionName' -WHERE ValueList = '0=lu_none||SELECT DestName AS OptionName, DestAbbr AS OptionValue FROM StdDestinations WHERE DestParentId IS NULL Order BY OptionName'; \ No newline at end of file +WHERE ValueList = '0=lu_none||SELECT DestName AS OptionName, DestAbbr AS OptionValue FROM StdDestinations WHERE DestParentId IS NULL Order BY OptionName'; + +ALTER TABLE SiteDomains + ADD COLUMN BillingCountry varchar(3) NOT NULL DEFAULT '', + ADD COLUMN ShippingCountry varchar(3) NOT NULL DEFAULT '', + ADD COLUMN PrimaryCurrencyId int(11) NOT NULL DEFAULT '0', + ADD COLUMN Currencies varchar(255) NOT NULL DEFAULT '', + ADD COLUMN PrimaryPaymentTypeId int(11) NOT NULL DEFAULT '0', + ADD COLUMN PaymentTypes varchar(255) NOT NULL DEFAULT '', + ADD INDEX (BillingCountry), + ADD INDEX (ShippingCountry), + ADD INDEX (PrimaryCurrencyId), + ADD INDEX (Currencies), + ADD INDEX (PrimaryPaymentTypeId), + ADD INDEX (PaymentTypes); \ No newline at end of file