/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_User` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `email` varchar(128) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` char(2) DEFAULT NULL,
  `zip` varchar(16) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `salt` char(8) NOT NULL,
  `autologinCode` char(32) DEFAULT NULL,
  `newPassword` char(32) DEFAULT NULL,
  `newSalt` char(8) DEFAULT NULL,
  `recoverCode` char(32) DEFAULT NULL,
  `recoverCodeExpirationDate` datetime DEFAULT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `recoverCode` (`recoverCode`),
  KEY `autologinCode` (`autologinCode`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_User` (`id`, `firstName`, `lastName`, `email`, `phone`, `address`, `city`, `state`, `zip`, `password`, `salt`, `autologinCode`, `newPassword`, `newSalt`, `recoverCode`, `recoverCodeExpirationDate`, `added`, `changed`) VALUES (2,'Юрій','Твардий','riddler@fr-wd.com',NULL,NULL,NULL,NULL,NULL,'635cafa71564e1055e98dc2a68a1bd5a','c5d0baec',NULL,'5aaeac83ce04a2c0a926d325ce70e7c6','J639ezbT','06c66c95b2f52cd961227d0cc9683c2f','2010-10-05 09:49:10','2009-12-30 17:18:05','2010-10-04 09:49:10'),(3,'Piter','Bishop','p.bishop@riddler-fr.wd.com','(111) 111-1111 ext. 11111','22222222222','dsdsdsd','AR','12333','e78351f4a92b0862281f94b355ed4f49','f7b266a4',NULL,NULL,NULL,NULL,NULL,'2009-12-30 17:18:33','2010-10-19 11:53:20'),(4,'Walter','Bishop','w.bishop@riddler-fr.wd.com',NULL,NULL,NULL,NULL,NULL,'896b124db60c1260d557255b45305b18','d8e2f7c3',NULL,NULL,NULL,NULL,NULL,'2009-12-30 17:19:25','2009-12-30 17:19:25'),(18,'Riddler','Riddler','r1@riddler.fr-wd.com','(222) 222-2222 ext. 22','Tantzorova st. 14','Ternopil','CO','46027','428e23c2f63a10095df98a6601a2a79a','tv5jsKxr',NULL,NULL,NULL,NULL,NULL,'2010-10-05 11:30:24','2010-10-05 11:49:17'),(19,'Test','Contact1','test@inna.fr-wd.com','(059) 048-5043','123 Minnetonka Str','Minneapolis','MN','55501','d4f303cf2df18497c457821299060a3f','SHRJKn2S',NULL,'095fa80185a14d74a19dd4058a9ffb22','7hGVRam4','881ed4094efa6aa645721ad2456202a8','2011-05-13 11:10:48','2010-10-14 16:33:07','2011-05-12 11:10:48'),(20,'riddler','riddler','r2@riddler-fr.wd.com','(111) 111-1111 ext. 1','222222222222','33333333333333','AZ','44444','7ece4216f86147b2bd2509a7031a5a07','3377a00c',NULL,NULL,NULL,NULL,NULL,'2010-10-19 12:23:03','2010-10-19 12:23:03'),(21,'Vitalii','Ternopilskyi','test@vityk.fr-wd.com','','','','','','484fc59a6391faae42813743b85ff157','d876b02b',NULL,NULL,NULL,NULL,NULL,'2011-04-05 11:55:06','2012-02-24 12:15:38'),(22,'Dozz','Tester','test@dozz.fr-wd.com','','','','IL','','7756b60abb06b970676a71ac6debce68','97679e8e',NULL,NULL,NULL,NULL,NULL,'2011-08-03 17:33:59','2011-08-10 17:46:21'),(23,'Irene','Povar','qsf@ira.fr-wd.com','','','','','','28b8e2bab0975279e5aadc8f9ea5424b','02f13b02',NULL,NULL,NULL,NULL,NULL,'2011-09-06 16:30:51','2011-09-06 16:30:51'),(24,'Victor','Demchuk','demovik@fr-wd.com','(123) 456-7890','Tanzorova 14 / App15','Ternopil','AK','12345','96532b052b82bd7bc7311a40218be543','83f034dc',NULL,NULL,NULL,NULL,NULL,'2011-10-11 12:33:28','2011-10-11 12:34:03'),(25,'Lily','Tester','me@sha.fr-wd.com','','','','','','5ed5f8da4dad6f686fb2fb7b3180c696','6382aa01',NULL,NULL,NULL,NULL,NULL,'2011-11-24 11:59:16','2011-11-24 11:59:16');
