rginfotech.in DB leaked by #TrojanFM #GForce

DataBase leaked by #TrojanFM #GForce Pakistan
Greetz:- #Mr.Instinct, #Keyboard005, #XTAM4, #Sea Monster!!!

http://rginfotech.in



-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 10, 2014 at 09:20 AM
-- Server version: 5.5.20
-- PHP Version: 5.3.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `igeninfo_matrimonyshaadi_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `contactinformation`
--

CREATE TABLE IF NOT EXISTS `contactinformation` (
  `ProfileID` varchar(50) NOT NULL,
  `Address` varchar(200) NOT NULL,
  `Country` varchar(15) NOT NULL,
  `StateofResidence` varchar(20) NOT NULL,
  `CityofResidence` varchar(20) NOT NULL,
  `ResidencyStatus` varchar(10) NOT NULL,
  `Mobile_no` varchar(15) NOT NULL,
  `Telephone_no` varchar(20) NOT NULL,
  `Zip` varchar(15) NOT NULL,
  `AlternateEmail` varchar(30) NOT NULL,
  `ContactPerson` varchar(20) NOT NULL,
  `ContactNumber` varchar(20) NOT NULL,
  `Relationship` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contactinformation`
--

INSERT INTO `contactinformation` (`ProfileID`, `Address`, `Country`, `StateofResidence`, `CityofResidence`, `ResidencyStatus`, `Mobile_no`, `Telephone_no`, `Zip`, `AlternateEmail`, `ContactPerson`, `ContactNumber`, `Relationship`) VALUES
('102', 'Karnd Bhopal', 'INDIA', 'Andhra Pradesh', 'Bhopal', 'Permanent ', '2165465432', 'None', '462038', '[email protected]', 'sdf', '1234578', 'sdf'),
('raginee53a725f2966db', 'f gbfgfbdgd', 'INDIA', 'Arunachal Pradesh', 'gfdgfd', 'Student Vi', '+915454313435', '665464644445', '3454', '[email protected]', '64', '65876546764', 'single'),
('max53a9cbfd84821', 'kjhdfkd ', 'INDIA', 'Haryana', 'djfjkdhskj', 'Permanent ', '+913564635465', 'None', '54654654', '[email protected]', 'jdj', '656664646464', 'friend');

-- --------------------------------------------------------

--
-- Table structure for table `deleteyourinfo`
--

CREATE TABLE IF NOT EXISTS `deleteyourinfo` (
  `ProfileID` varchar(30) NOT NULL,
  `Name` varchar(30) NOT NULL,
  `Email` varchar(25) NOT NULL,
  `Reason` varchar(1000) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `familyinformation`
--

CREATE TABLE IF NOT EXISTS `familyinformation` (
  `ProfileID` varchar(50) NOT NULL,
  `FatherName` varchar(20) NOT NULL,
  `FatherOccupation` varchar(20) NOT NULL,
  `FatherAlive` varchar(10) NOT NULL,
  `MotherName` varchar(25) NOT NULL,
  `MotherOccupation` varchar(20) NOT NULL,
  `MotherAlive` varchar(10) NOT NULL,
  `NoOfBrother` varchar(10) NOT NULL,
  `MarriedBrothers` varchar(10) NOT NULL,
  `NoOfSister` varchar(10) NOT NULL,
  `MarriedSisters` varchar(10) NOT NULL,
  `MotherTongue` varchar(15) NOT NULL,
  `Religion` varchar(20) NOT NULL,
  `Caste` varchar(15) NOT NULL,
  `SubCaste` varchar(15) NOT NULL,
  `Gothram` varchar(15) NOT NULL,
  `FamilyValue` varchar(15) NOT NULL,
  `AboutFamily` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `familyinformation`
--

INSERT INTO `familyinformation` (`ProfileID`, `FatherName`, `FatherOccupation`, `FatherAlive`, `MotherName`, `MotherOccupation`, `MotherAlive`, `NoOfBrother`, `MarriedBrothers`, `NoOfSister`, `MarriedSisters`, `MotherTongue`, `Religion`, `Caste`, `SubCaste`, `Gothram`, `FamilyValue`, `AboutFamily`) VALUES
('102', 'Rahual', 'Business', 'No', 'ksdjfl', 'Business', 'No', '0', '0', '0', '0', 'Arabic', 'Hindu', 'Arunthathiyar', 'i dont know', 'sdf', 'Moderate', 'sdffffffffsfsdfsdfsdfsdfdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd'),
('raginee53a725f2966db', 'gfdg', 'Business', 'Yes', 'fg', 'HouseWife', 'Yes', '0', '0', '0', '0', 'Hindi', 'Hindu', 'OBC  Barber Naa', 'None', 'None', 'Traditional', 'xbjhdfdfhdifhdifhdfhdkjjf f dfhdfdh ddkfhdfk dfkjdhfkdfhdk fdfhdfdhfdkhfdfhdfhdfhdkf df ddf dfhdfhdfhdfhdfh'),
('max53a9cbfd84821', 'hdfj', 'Business', 'Yes', 'kjflk', 'HouseWife', 'Yes', '1', '0', '0', '0', 'English', 'No Religion', 'Adi Dravida', 'sd', 'None', 'Moderate', ',d djhk fdfjdkjjjddjudjudjudjudjudjuddjuddddddddddduuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuiiiii');

-- --------------------------------------------------------

--
-- Table structure for table `msg_inbox`
--

CREATE TABLE IF NOT EXISTS `msg_inbox` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `rProfileID` varchar(50) NOT NULL,
  `sender_name` varchar(20) NOT NULL,
  `sProfileID` varchar(50) NOT NULL,
  `msg` varchar(200) NOT NULL,
  `time` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `msg_sent`
--

CREATE TABLE IF NOT EXISTS `msg_sent` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `rProfileID` varchar(50) NOT NULL,
  `sProfileID` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `msg` varchar(200) NOT NULL,
  `time` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `partnerpreference`
--

CREATE TABLE IF NOT EXISTS `partnerpreference` (
  `ProfileID` varchar(50) NOT NULL,
  `Gender` varchar(10) NOT NULL,
  `Partner_Age_From` varchar(3) NOT NULL,
  `Partner_Age_To` varchar(3) NOT NULL,
  `MaritalStatus` varchar(30) NOT NULL,
  `Height` varchar(30) NOT NULL,
  `BodyType` varchar(20) NOT NULL,
  `Manglik` varchar(20) NOT NULL,
  `MotherTongue` varchar(20) NOT NULL,
  `Education` varchar(20) NOT NULL,
  `PersonalValues` varchar(20) NOT NULL,
  `Partner_Description` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `partnerpreference`
--

INSERT INTO `partnerpreference` (`ProfileID`, `Gender`, `Partner_Age_From`, `Partner_Age_To`, `MaritalStatus`, `Height`, `BodyType`, `Manglik`, `MotherTongue`, `Education`, `PersonalValues`, `Partner_Description`) VALUES
('102', 'Female', '20', '22', 'Never Married', '4ft 6in To 4ft 7in', 'Slim', 'DontKnow', 'Arabic', 'Doctrate', 'Moderate', 'vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv'),
('max53a9cbfd84821', 'Female', '20', '22', 'Never Married', '5ft 1in To 5ft 1in', 'Slim', 'DoesntManglik', 'Aka', 'Bachelors', 'Moderate', 'bj fhdhfhfhfhffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy'),
('raginee53a725f2966db', 'Female', '20', '22', 'Never Married', '5ft 2in To 5ft 2in', 'Slim', 'DoesntManglik', 'Hindi', 'Bachelors', 'Traditional', 'dfdgfddfdffdfd idfdksjhf fkjfhf ffdhdf dfhfdkhfdkfhdfhdfhdfkdhkhfdkhfdkf dkfd  fkdfdkf hdkhdkf dfhdfdhfd fdff dkfh');

-- --------------------------------------------------------

--
-- Table structure for table `personalinformation`
--

CREATE TABLE IF NOT EXISTS `personalinformation` (
  `ProfileID` varchar(50) NOT NULL,
  `MaritalStatus` varchar(30) NOT NULL,
  `HaveChildren` varchar(20) NOT NULL,
  `NumberofKids` varchar(10) DEFAULT NULL,
  `Height` varchar(20) NOT NULL,
  `user_age` varchar(20) NOT NULL,
  `Diet` varchar(10) NOT NULL,
  `Smoke` varchar(10) NOT NULL,
  `Drink` varchar(10) NOT NULL,
  `PersonalValues` varchar(15) NOT NULL,
  `Complexion` varchar(25) NOT NULL,
  `BodyType` varchar(20) NOT NULL,
  `SpecialCases` varchar(20) NOT NULL,
  `Describeyourself` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `personalinformation`
--

INSERT INTO `personalinformation` (`ProfileID`, `MaritalStatus`, `HaveChildren`, `NumberofKids`, `Height`, `user_age`, `Diet`, `Smoke`, `Drink`, `PersonalValues`, `Complexion`, `BodyType`, `SpecialCases`, `Describeyourself`) VALUES
('102', 'Divorced', 'No', '0', '4ft 7in - 139cm', '', 'Non-Veg', 'No', 'No', 'Moderate', 'Very Fair', 'Average', 'None', 'sjdflkjsdlfk jdjflsakdjflksdjf lksjdlkf sldfj lsdjflsjdfl sdlfsld flsdjf sdfklsdfksjd fljsdlf slkdjf lsdjflkjdflkj slfj'),
('max53a9cbfd84821', 'Divorced', 'No', '0', '5ft 4in - 162cm', '20', 'Veg', 'No', 'No', 'Moderate', 'Fair', 'Slim', 'None', 'jzhdfd fhdh fjdhfd kdhg gjhghgkghfkhfkghfg gdf kfjg khdgkdfhgkfd gfkjg fdgf gg fgfgfghfgjhgkghfkdfkghfdgkhfg'),
('raginee53a725f2966db', 'Never Married', 'No', '1', '4ft 6in - 137cm', '21', 'Veg', 'No', 'No', 'Moderate', 'Fair', 'Average', 'None', 'xdffmjdhfddf fhhdd fdhfd df fhsdfhsjfhdjhfdjhfhdfdhfkdhdkfhdkfhdkfhdf df dfhdkf dfkhdf kdhfkdhfdkhfdkfhdkfhdk');

-- --------------------------------------------------------

--
-- Table structure for table `professionalinformation`
--

CREATE TABLE IF NOT EXISTS `professionalinformation` (
  `ProfileID` varchar(50) NOT NULL,
  `EducationLevel` varchar(20) NOT NULL,
  `EducationField` varchar(20) NOT NULL,
  `Profession` varchar(20) NOT NULL,
  `Organisation` varchar(20) NOT NULL,
  `OrganizationSector` varchar(20) NOT NULL,
  `Position` varchar(20) NOT NULL,
  `AnnualIncome` varchar(35) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `professionalinformation`
--

INSERT INTO `professionalinformation` (`ProfileID`, `EducationLevel`, `EducationField`, `Profession`, `Organisation`, `OrganizationSector`, `Position`, `AnnualIncome`) VALUES
('102', 'High school', 'Science', 'Student', 'Igen infotech', 'Government', 'software developer', 'Rs 30 lakhs and above'),
('raginee53a725f2966db', 'Bachelors', 'Computers/ IT', 'Self-employed Person', 'jhg', 'Private', 'jhkjh', 'Rs 4 lakhs to 5 lakhs'),
('max53a9cbfd84821', 'Bachelors', 'Law', 'Self-employed Person', 'dsnf', 'Private', 'jsndfkjs', 'Rs 50 thousand to 1 lakh');

-- --------------------------------------------------------

--
-- Table structure for table `userbasicinformation`
--

CREATE TABLE IF NOT EXISTS `userbasicinformation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ProfileID` varchar(50) NOT NULL,
  `ProfileCreatedfor` varchar(20) NOT NULL,
  `Email` varchar(30) NOT NULL,
  `Password` varchar(20) NOT NULL,
  `FirstName` varchar(30) NOT NULL,
  `LastName` varchar(30) NOT NULL,
  `Gender` varchar(10) NOT NULL,
  `DOB` varchar(30) NOT NULL,
  `Religion` varchar(30) NOT NULL,
  `MotherTongue` varchar(30) NOT NULL,
  `CountryofResidence` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `userbasicinformation`
--

INSERT INTO `userbasicinformation` (`id`, `ProfileID`, `ProfileCreatedfor`, `Email`, `Password`, `FirstName`, `LastName`, `Gender`, `DOB`, `Religion`, `MotherTongue`, `CountryofResidence`) VALUES
(1, '102', 'Self', '[email protected]', 'gini', 'aaa', 'singh', 'Male', '12/01/1977', 'Hindu', 'Sindhi', 'Albania'),
(2, 'Rahual4d1334f1f', 'Son', '[email protected]', '12345', 'Rahual', 'Singh', 'Male', '03/06/1986', 'Muslim', 'Hindi', 'India'),
(3, 'raginee53a725f2966db', 'Self', '[email protected]', '123', 'abc', 'xyz', 'Female', '02/01/1988', 'Hindu', 'Hindi', 'India'),
(4, 'max53a9cbfd84821', 'Self', '[email protected]', '123', 'max', 'max', 'Male', '01/01/1989', 'Hindu', 'Punjabi', 'India'),
(5, 'RENU53ba7dbe40ee0', 'Self', '[email protected]', '123', 'RENU', 'JAT', 'Female', '14/08/1989', 'Hindu', 'Hindi', 'India');

-- --------------------------------------------------------

--
-- Table structure for table `userphoto`
--

CREATE TABLE IF NOT EXISTS `userphoto` (
  `ID` int(150) NOT NULL AUTO_INCREMENT,
  `ProfileID` varchar(50) NOT NULL,
  `Image` varchar(100) NOT NULL,
  `Image1` varchar(100) NOT NULL,
  `Image2` varchar(100) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `userphoto`
--

INSERT INTO `userphoto` (`ID`, `ProfileID`, `Image`, `Image1`, `Image2`) VALUES
(9, 'max53a9cbfd84821', 'Admin/pictures/140496937221949.jpg', '', ''),
(8, 'raginee53a725f2966db', 'Admin/pictures/14049294975358.png', '', ''),
(7, 'raginee53a725f2966db', 'Admin/pictures/140492933327570.png', '', ''),
(5, '102', 'Admin/pictures/14048961771280.png', '', ''),
(6, '102', 'Admin/pictures/140489619320793.png', '', ''),
(10, 'max53a9cbfd84821', 'Admin/pictures/140496939710623.jpg', '', '');

/*!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 */;