/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_CartItemPromo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `promoId` int(11) NOT NULL,
  `cartId` int(11) NOT NULL,
  `productId` int(11) DEFAULT NULL,
  `code` varchar(255) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `type` enum('dollar','percent') NOT NULL,
  `minOrderValue` decimal(10,2) NOT NULL,
  `added` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cartId` (`cartId`,`productId`),
  KEY `promoId` (`promoId`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_CartItemPromo` (`id`, `promoId`, `cartId`, `productId`, `code`, `value`, `type`, `minOrderValue`, `added`) VALUES (1,1,24,0,'96FA5D',20.00,'dollar',10.00,'2012-10-19 18:17:04'),(2,2,243,0,'D99C57',10.00,'dollar',5.00,'2012-11-22 12:32:05'),(3,2,248,0,'D99C57',10.00,'dollar',5.00,'2012-11-26 09:59:08');