Changeset View
Changeset View
Standalone View
Standalone View
modules/in-commerce/install/install_schema.sql
| Show First 20 Lines • Show All 667 Lines • ▼ Show 20 Line(s) | |||||
| AccumulatedAmount decimal(10,2) NOT NULL DEFAULT '0.00', | AccumulatedAmount decimal(10,2) NOT NULL DEFAULT '0.00', | ||||
| AmountToPay decimal(10,2) NOT NULL DEFAULT '0.00', | AmountToPay decimal(10,2) NOT NULL DEFAULT '0.00', | ||||
| LastPaymentDate int(11) unsigned DEFAULT NULL, | LastPaymentDate int(11) unsigned DEFAULT NULL, | ||||
| LastOrderDate int(11) unsigned DEFAULT NULL, | LastOrderDate int(11) unsigned DEFAULT NULL, | ||||
| `Status` tinyint(4) NOT NULL DEFAULT '2', | `Status` tinyint(4) NOT NULL DEFAULT '2', | ||||
| AffiliateCode varchar(30) NOT NULL DEFAULT '', | AffiliateCode varchar(30) NOT NULL DEFAULT '', | ||||
| ItemsSold int(10) unsigned NOT NULL DEFAULT '0', | ItemsSold int(10) unsigned NOT NULL DEFAULT '0', | ||||
| PaymentTypeId int(11) NOT NULL DEFAULT '0', | PaymentTypeId int(11) NOT NULL DEFAULT '0', | ||||
| SSN varchar(100) NOT NULL DEFAULT '', | |||||
| Comments text, | Comments text, | ||||
| CreatedOn int(11) DEFAULT NULL, | CreatedOn int(11) DEFAULT NULL, | ||||
| PRIMARY KEY (AffiliateId), | PRIMARY KEY (AffiliateId), | ||||
| UNIQUE KEY AffiliateCode (AffiliateCode), | UNIQUE KEY AffiliateCode (AffiliateCode), | ||||
| UNIQUE KEY PortalUserId (PortalUserId), | UNIQUE KEY PortalUserId (PortalUserId), | ||||
| KEY LastOrderDate (LastOrderDate), | KEY LastOrderDate (LastOrderDate), | ||||
| KEY AffiliatePlanId (AffiliatePlanId), | KEY AffiliatePlanId (AffiliatePlanId), | ||||
| KEY `Status` (`Status`), | KEY `Status` (`Status`), | ||||
| ▲ Show 20 Lines • Show All 54 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 | |||||