/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_Promo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `value` float NOT NULL,
  `type` varchar(15) NOT NULL,
  `isRelated` enum('y','n') NOT NULL DEFAULT 'n',
  `productId` int(11) DEFAULT NULL,
  `minOrderValue` float NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date DEFAULT NULL,
  `hasNoExpirationDate` enum('y','n') NOT NULL,
  `usageCount` int(11) NOT NULL,
  `sorter` int(11) NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sorter` (`sorter`),
  KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_Promo` (`id`, `code`, `value`, `type`, `isRelated`, `productId`, `minOrderValue`, `startDate`, `endDate`, `hasNoExpirationDate`, `usageCount`, `sorter`, `added`, `changed`) VALUES (1,'96FA5D',20,'dollar','n',0,10,'2012-10-19','2012-11-19','n',0,0,'2012-10-19 18:16:52','2012-10-19 18:16:52'),(2,'E2FA8C',10,'dollar','y',7,5,'2012-11-22',NULL,'y',0,-1,'2012-11-22 12:26:46','2012-12-12 15:45:05');