Index: branches/5.2.x/install/install_schema.sql =================================================================== diff -u -N -r15560 -r16706 --- branches/5.2.x/install/install_schema.sql (.../install_schema.sql) (revision 15560) +++ branches/5.2.x/install/install_schema.sql (.../install_schema.sql) (revision 16706) @@ -318,7 +318,7 @@ BackOrderDate int(11) DEFAULT NULL, CreatedOn int(10) unsigned DEFAULT NULL, Modified int(10) unsigned DEFAULT NULL, - Expire int(10) unsigned DEFAULT NULL, + `Expire` int(10) unsigned DEFAULT NULL, Hits double NOT NULL DEFAULT '0', CachedRating varchar(10) NOT NULL DEFAULT '0', CachedVotesQty int(11) NOT NULL DEFAULT '0', @@ -346,7 +346,7 @@ AccessDurationType tinyint(4) DEFAULT NULL, AccessStart int(11) DEFAULT NULL, AccessEnd int(11) DEFAULT NULL, - Virtual tinyint(4) NOT NULL DEFAULT '0', + `Virtual` tinyint(4) NOT NULL DEFAULT '0', ProcessingData text, PackageContent mediumtext, OptionsSelectionMode tinyint(4) DEFAULT '0', @@ -374,8 +374,8 @@ KEY HotItem (HotItem), KEY Featured (Featured), KEY OnSale (OnSale), - KEY Expire (Expire), - KEY Virtual (Virtual), + KEY `Expire` (`Expire`), + KEY `Virtual` (`Virtual`), KEY AccessGroupId (AccessGroupId) ); @@ -744,4 +744,4 @@ ADD INDEX (PrimaryCurrencyId), ADD INDEX (Currencies), ADD INDEX (PrimaryPaymentTypeId), - ADD INDEX (PaymentTypes); \ No newline at end of file + ADD INDEX (PaymentTypes);