Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement