-- MySQL dump 10.13 Distrib 5.5.37, for Linux (x86_64) -- -- Host: localhost Database: ammanewe_ak -- ------------------------------------------------------ -- Server version 5.5.37-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `person` -- DROP TABLE IF EXISTS `person`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `person` ( `user_name` varchar(30) NOT NULL, `first_name` varchar(30) DEFAULT NULL, `last_name` varchar(30) DEFAULT NULL, `email` varchar(60) NOT NULL, `phone` varchar(20) DEFAULT NULL, PRIMARY KEY (`user_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `person` -- LOCK TABLES `person` WRITE; /*!40000 ALTER TABLE `person` DISABLE KEYS */; INSERT INTO `person` (`user_name`, `first_name`, `last_name`, `email`, `phone`) VALUES ('ajitha','Ajitha','Kymal','MiAmmaTour@aol.com','734-604-9388'),('akshay','Akshay','Schneiderhan','akshay.schneiderhan@gmail.com',NULL),('amal','Amalendu','Haldar','amalenduh@yahoo.com','702-443-1534'),('anugraha','Anugraha',NULL,'whrn123@aol.com',NULL),('anui','Anu','Iyer','aiyer1008@gmail.com',NULL),('apoorva','Apoorva','V','ammasapoorva@gmail.com',NULL),('benjamin','Benjamin','Merkle','benjamin.merkle@yahoo.ca',NULL),('debbie','Debbie','Pogel','dpogel@lisco.com','641-455-8400'),('harishree','Harishree','Achutan','harishree@gmail.com','661-361-2105'),('julie','Julie','Rose','rose1359@aol.com','505-577-4356'),('jyoti','Jyoti','Moore','equinerehab@gmail.com','541-377-7770'),('kasi','Kasi','Annamalai','kasi_a@yahoo.com','773-354-4209'),('krishna','Krishna','Shankar','kshankar_98@yahoo.com','978-394-1487'),('lalitha','Lalitha','Russel','designs108@gmail.com',NULL),('majithus','Majithus',NULL,'majithus@yahoo.com','508-369-3062'),('malini','Malini','Frey','frey1457@hotmail.com',NULL),('manjula','Manjula',NULL,'anamaria@arumi.com','917-655-0341'),('manorama','Manorama','Basu','hoimonti@yahoo.com','702-443-1538'),('mark','Mark','Miller','markmiller63@yahoo.com','816-729-7061'),('meera','Meera','Menon','a.meeramenon@gmail.com','508-369-8456'),('mohan','Mohan','Sookdeo','mohan.sookdeo@escadaota.com','647-206-0766'),('prana','Prana','Thoppil','ammasprana@gmail.com',NULL),('priya','Priya','Thoppil','ammaspriya@gmail.com','817-937-1660'),('ramak','Ramakrishna','Sayyed','ramakrishnamrita@yahoo.com','512-581-1297'),('roopa','Roopa','Lele','roopalele@gmail.com','972-740-6951'),('sahaja','Sahaja','Hughes','martimrth@aol.com','714-394-3579'),('shalini','Shalini','Nair','snair108@gmail.com','214-315-6945'),('shirley','Shirley','Hemmingson','hemmpike@msn.com','319-329-2434'),('sridevi','Sridevi','Shankaran','ammassridevi@gmail.com',NULL),('suku','Suku','Nair','intercon_ent@yahoo.com','571-221-2037'),('triptta','Triptta','Cohen','triptta108@yahoo.com','510-828-4830'); /*!40000 ALTER TABLE `person` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `userpie_users` -- DROP TABLE IF EXISTS `userpie_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `userpie_users` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(150) NOT NULL, `username_clean` varchar(150) NOT NULL, `password` varchar(225) NOT NULL, `email` varchar(150) NOT NULL, `activationtoken` varchar(225) NOT NULL, `last_activation_request` int(11) NOT NULL, `LostpasswordRequest` int(1) NOT NULL DEFAULT '0', `active` int(1) NOT NULL, `group_id` int(11) NOT NULL, `sign_up_date` int(11) NOT NULL, `last_sign_in` int(11) NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `userpie_users` -- LOCK TABLES `userpie_users` WRITE; /*!40000 ALTER TABLE `userpie_users` DISABLE KEYS */; INSERT INTO `userpie_users` (`user_id`, `username`, `username_clean`, `password`, `email`, `activationtoken`, `last_activation_request`, `LostpasswordRequest`, `active`, `group_id`, `sign_up_date`, `last_sign_in`) VALUES (1,'ajitha','ajitha','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','MiAmmaTour@aol.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(2,'akshay','akshay','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','akshay.schneiderhan@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(3,'amal','amal','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','amalenduh@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(4,'anugraha','anugraha','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','whrn123@aol.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(5,'anui','anui','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','aiyer1008@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(6,'apoorva','apoorva','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','ammasapoorva@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(9,'benjamin','benjamin','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','benjamin.merkle@yahoo.ca','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(10,'debbie','debbie','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','dpogel@lisco.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(14,'harishree','harishree','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','harishree@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(15,'julie','julie','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','rose1359@aol.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(16,'jyoti','jyoti','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','equinerehab@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,1397153255),(17,'kasi','kasi','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','kasi_a@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(18,'krishna','krishna','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','kshankar_98@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(19,'lalitha','lalitha','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','designs108@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(20,'majithus','majithus','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','majithus@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(21,'malini','malini','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','frey1457@hotmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(22,'manjula','manjula','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','anamaria@arumi.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(23,'manorama','manorama','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','hoimonti@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(24,'mark','mark','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','markmiller63@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(25,'meera','meera','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','a.meeramenon@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(26,'mohan','mohan','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','mohan.sookdeo@escadaota.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(27,'prana','prana','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','ammasprana@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(28,'priya','priya','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','ammaspriya@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(29,'ramak','ramak','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','ramakrishnamrita@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(31,'roopa','roopa','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','roopalele@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(32,'sahaja','sahaja','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','martimrth@aol.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(34,'shalini','shalini','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','snair108@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(35,'shirley','shirley','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','hemmpike@msn.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(36,'sridevi','sridevi','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','ammassridevi@gmail.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,1397162661),(37,'suku','suku','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','intercon_ent@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,0),(39,'triptta','triptta','a2ca43191effea2754f6a7ebb827ca96bef599a14808b5041a515f2da8ba4ff69','triptta108@yahoo.com','7fd22fa403aa612d87e9f162a827f4f1',1391393883,0,1,1,1391393883,1397162784); /*!40000 ALTER TABLE `userpie_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `userpie_groups` -- DROP TABLE IF EXISTS `userpie_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `userpie_groups` ( `group_id` int(11) NOT NULL AUTO_INCREMENT, `group_name` varchar(225) NOT NULL, PRIMARY KEY (`group_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `userpie_groups` -- LOCK TABLES `userpie_groups` WRITE; /*!40000 ALTER TABLE `userpie_groups` DISABLE KEYS */; INSERT INTO `userpie_groups` (`group_id`, `group_name`) VALUES (1,'Standard User'); /*!40000 ALTER TABLE `userpie_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `userpie_sessions` -- DROP TABLE IF EXISTS `userpie_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `userpie_sessions` ( `session_start` int(11) NOT NULL, `session_data` text NOT NULL, `session_id` varchar(255) NOT NULL, PRIMARY KEY (`session_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `userpie_sessions` -- LOCK TABLES `userpie_sessions` WRITE; /*!40000 ALTER TABLE `userpie_sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `userpie_sessions` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2014-04-10 16:32:36