Page Menu
Home
In-Portal Phabricator
Search
Configure Global Search
Log In
Files
F1025990
D403.diff
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Fri, Jun 13, 5:51 PM
Size
1 KB
Mime Type
text/x-diff
Expires
Sat, Jun 14, 5:51 PM (4 h, 19 m)
Engine
blob
Format
Raw Data
Handle
661648
Attached To
D403: MINC-199 - Escape MySQL 5.7 keywords in the "modules/in-commerce/install/install_schema.sql" file
D403.diff
View Options
Index: branches/5.2.x/install/install_schema.sql
===================================================================
--- branches/5.2.x/install/install_schema.sql
+++ branches/5.2.x/install/install_schema.sql
@@ -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);
Event Timeline
Log In to Comment