/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_GiftCard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cardCode` varchar(255) NOT NULL,
  `cardValue` float NOT NULL,
  `expirationDate` date NOT NULL,
  `userId` int(11) NOT NULL,
  `statusId` enum('new','send','redeemed') NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userId` (`userId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_GiftCard` (`id`, `cardCode`, `cardValue`, `expirationDate`, `userId`, `statusId`, `added`, `changed`) VALUES (1,'5D35B0',10,'2012-12-24',3,'new','2012-11-22 12:45:34','2012-11-22 14:06:26');