Changeset View
Changeset View
Standalone View
Standalone View
branches/5.2.x/install/install_schema.sql
Show First 20 Lines • Show All 312 Lines • ▼ Show 20 Line(s) | |||||
l5_DescriptionExcerpt text, | l5_DescriptionExcerpt text, | ||||
Weight double(10,4) DEFAULT NULL, | Weight double(10,4) DEFAULT NULL, | ||||
ManufacturerId int(11) NOT NULL DEFAULT '0', | ManufacturerId int(11) NOT NULL DEFAULT '0', | ||||
MSRP double DEFAULT NULL, | MSRP double DEFAULT NULL, | ||||
BackOrder tinyint(3) unsigned NOT NULL DEFAULT '2', | BackOrder tinyint(3) unsigned NOT NULL DEFAULT '2', | ||||
BackOrderDate int(11) DEFAULT NULL, | BackOrderDate int(11) DEFAULT NULL, | ||||
CreatedOn int(10) unsigned DEFAULT NULL, | CreatedOn int(10) unsigned DEFAULT NULL, | ||||
Modified 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', | Hits double NOT NULL DEFAULT '0', | ||||
CachedRating varchar(10) NOT NULL DEFAULT '0', | CachedRating varchar(10) NOT NULL DEFAULT '0', | ||||
CachedVotesQty int(11) NOT NULL DEFAULT '0', | CachedVotesQty int(11) NOT NULL DEFAULT '0', | ||||
CachedReviewsQty int(11) NOT NULL DEFAULT '0', | CachedReviewsQty int(11) NOT NULL DEFAULT '0', | ||||
CreatedById int(11) DEFAULT NULL, | CreatedById int(11) DEFAULT NULL, | ||||
ModifiedById int(11) DEFAULT NULL, | ModifiedById int(11) DEFAULT NULL, | ||||
Priority int(11) NOT NULL DEFAULT '0', | Priority int(11) NOT NULL DEFAULT '0', | ||||
`Status` tinyint(4) NOT NULL DEFAULT '2', | `Status` tinyint(4) NOT NULL DEFAULT '2', | ||||
Show All 11 Lines | |||||
QtyBackOrdered int(11) NOT NULL DEFAULT '0', | QtyBackOrdered int(11) NOT NULL DEFAULT '0', | ||||
QtyOnOrder int(11) NOT NULL DEFAULT '0', | QtyOnOrder int(11) NOT NULL DEFAULT '0', | ||||
InventoryComment text, | InventoryComment text, | ||||
AccessGroupId int(11) DEFAULT NULL, | AccessGroupId int(11) DEFAULT NULL, | ||||
AccessDuration int(11) DEFAULT NULL, | AccessDuration int(11) DEFAULT NULL, | ||||
AccessDurationType tinyint(4) DEFAULT NULL, | AccessDurationType tinyint(4) DEFAULT NULL, | ||||
AccessStart int(11) DEFAULT NULL, | AccessStart int(11) DEFAULT NULL, | ||||
AccessEnd 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, | ProcessingData text, | ||||
PackageContent mediumtext, | PackageContent mediumtext, | ||||
OptionsSelectionMode tinyint(4) DEFAULT '0', | OptionsSelectionMode tinyint(4) DEFAULT '0', | ||||
HasRequiredOptions tinyint(1) NOT NULL DEFAULT '0', | HasRequiredOptions tinyint(1) NOT NULL DEFAULT '0', | ||||
IsRecurringBilling tinyint(3) unsigned NOT NULL DEFAULT '0', | IsRecurringBilling tinyint(3) unsigned NOT NULL DEFAULT '0', | ||||
ShippingMode tinyint(1) NOT NULL DEFAULT '0', | ShippingMode tinyint(1) NOT NULL DEFAULT '0', | ||||
ShippingLimitation text, | ShippingLimitation text, | ||||
AssignedCoupon int(11) NOT NULL DEFAULT '0', | AssignedCoupon int(11) NOT NULL DEFAULT '0', | ||||
Show All 11 Lines | |||||
KEY l1_Name (l1_Name), | KEY l1_Name (l1_Name), | ||||
KEY Priority (Priority), | KEY Priority (Priority), | ||||
KEY ManufacturerId (ManufacturerId), | KEY ManufacturerId (ManufacturerId), | ||||
KEY NewItem (NewItem), | KEY NewItem (NewItem), | ||||
KEY PopItem (PopItem), | KEY PopItem (PopItem), | ||||
KEY HotItem (HotItem), | KEY HotItem (HotItem), | ||||
KEY Featured (Featured), | KEY Featured (Featured), | ||||
KEY OnSale (OnSale), | KEY OnSale (OnSale), | ||||
KEY Expire (Expire), | KEY `Expire` (`Expire`), | ||||
KEY Virtual (Virtual), | KEY `Virtual` (`Virtual`), | ||||
KEY AccessGroupId (AccessGroupId) | KEY AccessGroupId (AccessGroupId) | ||||
); | ); | ||||
CREATE TABLE ProductsCouponItems ( | CREATE TABLE ProductsCouponItems ( | ||||
CouponItemId int(11) NOT NULL auto_increment, | CouponItemId int(11) NOT NULL auto_increment, | ||||
CouponId int(11) default NULL, | CouponId int(11) default NULL, | ||||
ItemResourceId int(11) default NULL, | ItemResourceId int(11) default NULL, | ||||
ItemType TINYINT(4) NOT NULL DEFAULT '1', | ItemType TINYINT(4) NOT NULL DEFAULT '1', | ||||
▲ Show 20 Lines • Show All 352 Lines • ▼ Show 20 Line(s) | |||||
ADD COLUMN Currencies varchar(255) NOT NULL DEFAULT '', | ADD COLUMN Currencies varchar(255) NOT NULL DEFAULT '', | ||||
ADD COLUMN PrimaryPaymentTypeId int(11) NOT NULL DEFAULT '0', | ADD COLUMN PrimaryPaymentTypeId int(11) NOT NULL DEFAULT '0', | ||||
ADD COLUMN PaymentTypes varchar(255) NOT NULL DEFAULT '', | ADD COLUMN PaymentTypes varchar(255) NOT NULL DEFAULT '', | ||||
ADD INDEX (BillingCountry), | ADD INDEX (BillingCountry), | ||||
ADD INDEX (ShippingCountry), | ADD INDEX (ShippingCountry), | ||||
ADD INDEX (PrimaryCurrencyId), | ADD INDEX (PrimaryCurrencyId), | ||||
ADD INDEX (Currencies), | ADD INDEX (Currencies), | ||||
ADD INDEX (PrimaryPaymentTypeId), | ADD INDEX (PrimaryPaymentTypeId), | ||||
ADD INDEX (PaymentTypes); | ADD INDEX (PaymentTypes); | ||||
No newline at end of file |