/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_UserAddress` (
  `userId` int(11) unsigned NOT NULL,
  `type` set('billing','shipping') NOT NULL,
  `firstName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` char(2) NOT NULL,
  `zip` varchar(16) NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`userId`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_UserAddress` (`userId`, `type`, `firstName`, `lastName`, `address`, `city`, `state`, `zip`, `added`, `changed`) VALUES (1,'billing,shipping','Jaam','xXx','11 Suite','Plymoth','MN','55441','2012-10-19 15:04:35','2012-10-19 15:04:35'),(2,'billing,shipping','Vitalii','Tornopilskyi','KoNovaltsa 2','Minnetonka','MN','55345','2012-11-26 16:38:09','2012-11-26 16:38:09'),(3,'billing,shipping','Liudmyla','Chekhovska','address','city','PA','16801','2012-11-19 17:27:51','2012-11-19 17:27:51'),(4,'billing,shipping','Victor','Demchuk','Tancorova 14','Minnetonka','MN','55441','2012-11-06 10:53:05','2012-11-06 10:53:05'),(5,'billing,shipping','M','Kloo','address','Minnetonka','MN','55343','2012-11-14 15:31:29','2012-11-14 15:31:29'),(15,'billing,shipping','TEST','TEST','test','test','IL','1234','2012-12-05 14:27:30','2012-12-05 14:27:30'),(14,'billing,shipping','Andriy','Zhuk','sgs','Ternopil','AK','57576','2012-12-04 17:26:08','2012-12-04 17:26:08');