/*!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,
  `password` varchar(255) NOT NULL,
  `salt` char(8) NOT NULL,
  `autologinCode` char(32) 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=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_User` (`id`, `firstName`, `lastName`, `email`, `phone`, `password`, `salt`, `autologinCode`, `recoverCode`, `recoverCodeExpirationDate`, `added`, `changed`) VALUES (1,'Jaam','xXx','jaam@adaptainc.com','(123) 123-1231 ext. 23','b834776fa07b85856327edf90423c282','064b6759',NULL,NULL,NULL,'2012-10-19 15:04:35','2012-10-19 15:04:35'),(2,'Vitalii','Ternopilskyi','vityk@adaptainc.com','(067) 303-4004','efc6978bbae79ec476bfb08c14a16fa3','cc38a93e',NULL,NULL,NULL,'2012-10-19 19:27:56','2012-11-26 16:38:09'),(3,'Liudmyla','Chekhovska','customer@sha.fr-wd.com','(132) 453-4656 ext. 7','1906e73ca3bca3be813fd9cac3c6f608','69cc8ce2',NULL,NULL,NULL,'2012-10-29 09:38:00','2012-11-19 17:27:51'),(4,'Victor','Demchuk','demovik@adaptainc.com','(123) 456-7899','d25e203a81f3b0308d41ae68b2341ab2','81d8b1cb',NULL,NULL,NULL,'2012-11-06 10:53:05','2012-11-06 10:53:05'),(5,'M','Kloo','qsf@kloo.fr-wd.com','(123) 412-3123','33d28fadc9b907847dd10ece1b8a3daf','1bb4c9c7',NULL,NULL,NULL,'2012-11-14 15:30:07','2012-11-14 15:31:29'),(15,'TEST','TEST','test@kloo.fr-wd.com','(123) 123-4123','4d06f203dd2fc41501b8e63f6bb05e3d','a3dd2816',NULL,NULL,NULL,'2012-12-05 14:27:30','2012-12-05 14:27:30'),(14,'Andriy','Zhuk','test@gmail.com','(067) 895-3866','c350e6d008c52e1001e1f4d7c45091a8','35744390',NULL,NULL,NULL,'2012-12-04 17:26:08','2012-12-04 17:26:08');
