Changeset View
Changeset View
Standalone View
Standalone View
modules/in-commerce/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 | |||||