Index: branches/5.1.x/install/install_schema.sql =================================================================== diff -u -r13100 -r13558 --- branches/5.1.x/install/install_schema.sql (.../install_schema.sql) (revision 13100) +++ branches/5.1.x/install/install_schema.sql (.../install_schema.sql) (revision 13558) @@ -711,4 +711,18 @@ ResourceId int(10) unsigned NOT NULL default '0', KEY ResourceId (ResourceId), PRIMARY KEY (CustomDataId) -); \ No newline at end of file +); + +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