pairness.sql

-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 24, 2013 at 08:32 AM
-- Server version: 5.6.12-log
-- PHP Version: 5.4.16

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: `pairness`
--
CREATE DATABASE IF NOT EXISTS `pairness` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE `pairness`;

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

--
-- Table structure for table `candidate`
--

CREATE TABLE IF NOT EXISTS `candidate` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `parientid` int(10) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `userpassword` varchar(20) NOT NULL,
  `dateofregistration` datetime NOT NULL,
  `dateofvarification` datetime NOT NULL,
  `picture` varchar(250) NOT NULL,
  `lastlogin` datetime NOT NULL,
  `lastpage` varchar(10) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `candidate`
--

INSERT INTO `candidate` (`id`, `parientid`, `ip`, `email`, `username`, `userpassword`, `dateofregistration`, `dateofvarification`, `picture`, `lastlogin`, `lastpage`) VALUES
(1, 0, '127.0.0.1', 'abcze7', 'sdgfjsdgf', 'gjhgsd', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
(2, 0, '127.0.0.1', 'abcxyz', 'rfytfff', 'tsafhgv6', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
(3, 0, '127.0.0.1', 'rahber', 'asd', 'asdasd', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
(4, 0, '127.0.0.1', 'asdasd', 'asdasd', 'asdasd', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', '');

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

--
-- Table structure for table `family`
--

CREATE TABLE IF NOT EXISTS `family` (
  `ip` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `userpassword` varchar(20) NOT NULL,
  `dateofregistration` datetime NOT NULL,
  `dateofverfication` datetime NOT NULL,
  `picture` varchar(250) NOT NULL,
  `lastlogin` datetime NOT NULL,
  `lastpage` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `family`
--

INSERT INTO `family` (`ip`, `email`, `username`, `userpassword`, `dateofregistration`, `dateofverfication`, `picture`, `lastlogin`, `lastpage`) VALUES
('0', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
('0', 'hjkh', 'jkhkl;hkl;h', 'kgdg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
('0', 'jgjkgj', 'hjkhjkhjklhj', 'gfghdgh', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
('0', 'xczxcz', 'gjhghh', 'jhkh', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
('1270', 'dfsdfdfg', 'sagfgjh', 'dftyg54y', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
('127', 'dfsdfdfg', 'sagfgjh', 'dftyg54y', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', ''),
('127.0.0.1', 'dfsdfdfg', 'sagfgjh', 'dftyg54y', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'default.png', '0000-00-00 00:00:00', '');

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

--
-- Table structure for table `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `logid` int(11) NOT NULL AUTO_INCREMENT,
  `action` longtext COLLATE utf8_bin NOT NULL,
  `uid` int(11) NOT NULL,
  `logtime` int(11) NOT NULL,
  PRIMARY KEY (`logid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=536 ;

--
-- Dumping data for table `log`
--

INSERT INTO `log` (`logid`, `action`, `uid`, `logtime`) VALUES
(1, 'User successfully logged in!', 2, 1375854102),
(2, 'User successfully logged out!', 2, 1375854116),
(3, 'User successfully logged in!', 2, 1375860062),
(4, 'User successfully logged in!', 2, 1375863871),
(5, 'User successfully logged in!', 2, 1375867181),
(6, 'User successfully logged in!', 2, 1375870766),
(7, 'User successfully logged out!', 2, 1375870775),
(8, 'User successfully logged in!', 2, 1375870926),
(9, 'User successfully logged out!', 2, 1375870939),
(10, 'User successfully logged in!', 2, 1375871585),
(11, 'User successfully logged out!', 2, 1375871606),
(12, 'User successfully logged in!', 2, 1375871658),
(13, 'User successfully logged out!', 2, 1375871664),
(14, 'User successfully logged in!', 2, 1375871676),
(15, 'User successfully logged out!', 2, 1375871939),
(16, 'User successfully logged in!', 2, 1375939146),
(17, 'User successfully logged in!', 2, 1375941834),
(18, 'User successfully logged out!', 2, 1375941854),
(19, 'User successfully logged in!', 2, 1375941871),
(20, 'User successfully logged out!', 2, 1375942014),
(21, 'User successfully logged out!', 0, 1375942015),
(22, 'User successfully logged out!', 0, 1375942016),
(23, 'User successfully logged in!', 2, 1375942040),
(24, 'User successfully logged out!', 2, 1375942171),
(25, 'User successfully logged in!', 2, 1375942175),
(26, 'User successfully logged in!', 2, 1375943462),
(27, 'User session was expired!', 0, 1375946711),
(28, 'User session was expired!', 0, 1375946711),
(29, 'User session was expired!', 0, 1375949927),
(30, 'User session was expired!', 0, 1375950049),
(31, 'User session was expired!', 0, 1375950049),
(32, 'User session was expired!', 0, 1375950151),
(33, 'User session was expired!', 0, 1375950167),
(34, 'User session was expired!', 0, 1375950219),
(35, 'User session was expired!', 0, 1375950287),
(36, 'User session was expired!', 0, 1375950310),
(37, 'User session was expired!', 0, 1375950310),
(38, 'User session was expired!', 0, 1375950433),
(39, 'User session was expired!', 0, 1375950433),
(40, 'User session was expired!', 0, 1375950447),
(41, 'User session was expired!', 0, 1375950447),
(42, 'User successfully logged in!', 2, 1375950452),
(43, 'User successfully logged out!', 2, 1375950573),
(44, 'User session was expired!', 0, 1375950573),
(45, 'User session was expired!', 0, 1375950573),
(46, 'User session was expired!', 0, 1375950594),
(47, 'User session was expired!', 0, 1375950594),
(48, 'User successfully logged in!', 2, 1375950608),
(49, 'User session was expired!', 0, 1375951640),
(50, 'User session was expired!', 0, 1375951640),
(51, 'User session was expired!', 0, 1375953786),
(52, 'User session was expired!', 0, 1375953786),
(53, 'User session was expired!', 0, 1375953803),
(54, 'User session was expired!', 0, 1375953803),
(55, 'User session was expired!', 0, 1375953803),
(56, 'User session was expired!', 0, 1375953803),
(57, 'User session was expired!', 0, 1375953803),
(58, 'User successfully logged in!', 2, 1375953813),
(59, 'User session was expired!', 0, 1376368812),
(60, 'User session was expired!', 0, 1376368812),
(61, 'User successfully logged in!', 2, 1376378997),
(62, 'User successfully logged out!', 2, 1376379242),
(63, 'User session was expired!', 0, 1376379243),
(64, 'User session was expired!', 0, 1376379243),
(65, 'User session was expired!', 0, 1376379245),
(66, 'User session was expired!', 0, 1376379245),
(67, 'User session was expired!', 0, 1376379245),
(68, 'User session was expired!', 0, 1376379245),
(69, 'User session was expired!', 0, 1376379573),
(70, 'User session was expired!', 0, 1376379573),
(71, 'User session was expired!', 0, 1376379685),
(72, 'User session was expired!', 0, 1376379685),
(73, 'User successfully logged in!', 2, 1376379690),
(74, 'User successfully logged out!', 2, 1376379773),
(75, 'User session was expired!', 0, 1376379773),
(76, 'User session was expired!', 0, 1376379773),
(77, 'User successfully logged out!', 0, 1376379775),
(78, 'User session was expired!', 0, 1376379775),
(79, 'User session was expired!', 0, 1376379775),
(80, 'User session was expired!', 0, 1376379775),
(81, 'User session was expired!', 0, 1376379775),
(82, 'User session was expired!', 0, 1376379778),
(83, 'User session was expired!', 0, 1376379778),
(84, 'User successfully logged in!', 2, 1376379783),
(85, 'User successfully logged out!', 2, 1376379809),
(86, 'User session was expired!', 0, 1376379809),
(87, 'User session was expired!', 0, 1376379809),
(88, 'User successfully logged out!', 0, 1376379810),
(89, 'User session was expired!', 0, 1376379810),
(90, 'User session was expired!', 0, 1376379810),
(91, 'User successfully logged out!', 0, 1376379810),
(92, 'User session was expired!', 0, 1376379810),
(93, 'User session was expired!', 0, 1376379810),
(94, 'User session was expired!', 0, 1376379813),
(95, 'User session was expired!', 0, 1376379813),
(96, 'User session was expired!', 0, 1376379814),
(97, 'User session was expired!', 0, 1376379814),
(98, 'User successfully logged in!', 2, 1376379818),
(99, 'User session was expired!', 0, 1376383082),
(100, 'User session was expired!', 0, 1376383082),
(101, 'User session was expired!', 0, 1376383082),
(102, 'User session was expired!', 0, 1376383082),
(103, 'User session was expired!', 0, 1376383085),
(104, 'User session was expired!', 0, 1376383085),
(105, 'User successfully logged in!', 2, 1376383091),
(106, 'User successfully logged out!', 2, 1376383276),
(107, 'User session was expired!', 0, 1376383276),
(108, 'User session was expired!', 0, 1376383276),
(109, 'User session was expired!', 0, 1376383278),
(110, 'User session was expired!', 0, 1376383278),
(111, 'User session was expired!', 0, 1376383278),
(112, 'User session was expired!', 0, 1376383278),
(113, 'User successfully logged in!', 2, 1376383287),
(114, 'User successfully logged out!', 2, 1376383542),
(115, 'User successfully logged out!', 0, 1376383542),
(116, 'User successfully logged out!', 0, 1376383542),
(117, 'User successfully logged out!', 0, 1376383542),
(118, 'User successfully logged out!', 0, 1376383542),
(119, 'User successfully logged out!', 0, 1376383542),
(120, 'User successfully logged out!', 0, 1376383542),
(121, 'User successfully logged out!', 0, 1376383542),
(122, 'User successfully logged out!', 0, 1376383542),
(123, 'User successfully logged out!', 0, 1376383542),
(124, 'User successfully logged out!', 0, 1376383543),
(125, 'User successfully logged out!', 0, 1376383543),
(126, 'User successfully logged out!', 0, 1376383543),
(127, 'User successfully logged out!', 0, 1376383543),
(128, 'User successfully logged out!', 0, 1376383543),
(129, 'User successfully logged out!', 0, 1376383543),
(130, 'User successfully logged out!', 0, 1376383543),
(131, 'User successfully logged out!', 0, 1376383543),
(132, 'User successfully logged out!', 0, 1376383543),
(133, 'User successfully logged out!', 0, 1376383544),
(134, 'User successfully logged out!', 0, 1376383544),
(135, 'User successfully logged out!', 0, 1376383544),
(136, 'User successfully logged out!', 0, 1376383544),
(137, 'User successfully logged out!', 0, 1376383544),
(138, 'User successfully logged out!', 0, 1376383544),
(139, 'User successfully logged out!', 0, 1376383544),
(140, 'User successfully logged out!', 0, 1376383544),
(141, 'User successfully logged out!', 0, 1376383544),
(142, 'User successfully logged out!', 0, 1376383544),
(143, 'User successfully logged out!', 0, 1376383544),
(144, 'User successfully logged out!', 0, 1376383545),
(145, 'User successfully logged out!', 0, 1376383552),
(146, 'User session was expired!', 0, 1376383552),
(147, 'User session was expired!', 0, 1376383552),
(148, 'User session was expired!', 0, 1376383558),
(149, 'User session was expired!', 0, 1376383558),
(150, 'User session was expired!', 0, 1376383558),
(151, 'User session was expired!', 0, 1376383558),
(152, 'User successfully logged in!', 2, 1376383564),
(153, 'User successfully logged out!', 2, 1376383569),
(154, 'User session was expired!', 0, 1376383569),
(155, 'User session was expired!', 0, 1376383569),
(156, 'User session was expired!', 0, 1376383571),
(157, 'User session was expired!', 0, 1376383571),
(158, 'User session was expired!', 0, 1376383571),
(159, 'User session was expired!', 0, 1376383571),
(160, 'User successfully logged in!', 2, 1376383576),
(161, 'User session was expired!', 0, 1376384494),
(162, 'User session was expired!', 0, 1376384494),
(163, 'User session was expired!', 0, 1376384494),
(164, 'User session was expired!', 0, 1376384494),
(165, 'User successfully logged in!', 2, 1376384516),
(166, 'User successfully logged out!', 0, 1376385296),
(167, 'User session was expired!', 0, 1376385296),
(168, 'User session was expired!', 0, 1376385296),
(169, 'User session was expired!', 0, 1376539727),
(170, 'User session was expired!', 0, 1376539727),
(171, 'User session was expired!', 0, 1376539728),
(172, 'User session was expired!', 0, 1376539728),
(173, 'User session was expired!', 0, 1376539729),
(174, 'User session was expired!', 0, 1376539729),
(175, 'User successfully logged in!', 2, 1376539736),
(176, 'User session was expired!', 0, 1376541417),
(177, 'User session was expired!', 0, 1376541417),
(178, 'User session was expired!', 0, 1376541417),
(179, 'User session was expired!', 0, 1376541417),
(180, 'User successfully logged in!', 2, 1376541426),
(181, 'User successfully logged out!', 2, 1376541614),
(182, 'User session was expired!', 0, 1376541614),
(183, 'User session was expired!', 0, 1376541614),
(184, 'User successfully logged in!', 2, 1376541638),
(185, 'User successfully logged out!', 0, 1376542927),
(186, 'User session was expired!', 0, 1376542927),
(187, 'User session was expired!', 0, 1376542927),
(188, 'User session was expired!', 0, 1376545772),
(189, 'User session was expired!', 0, 1376545772),
(190, 'User session was expired!', 0, 1376548403),
(191, 'User session was expired!', 0, 1376548426),
(192, 'User session was expired!', 0, 1376549681),
(193, 'User session was expired!', 0, 1376549681),
(194, 'User session was expired!', 0, 1376549681),
(195, 'User session was expired!', 0, 1376549681),
(196, 'User session was expired!', 0, 1376550433),
(197, 'User session was expired!', 0, 1376550555),
(198, 'User session was expired!', 0, 1376551254),
(199, 'User session was expired!', 0, 1376551254),
(200, 'User session was expired!', 0, 1376551303),
(201, 'User session was expired!', 0, 1376551305),
(202, 'User session was expired!', 0, 1376551474),
(203, 'User session was expired!', 0, 1376552412),
(204, 'User session was expired!', 0, 1376552413),
(205, 'User session was expired!', 0, 1376552433),
(206, 'User session was expired!', 0, 1376552462),
(207, 'User session was expired!', 0, 1376552502),
(208, 'User session was expired!', 0, 1376552714),
(209, 'User session was expired!', 0, 1376552714),
(210, 'User session was expired!', 0, 1376552718),
(211, 'User session was expired!', 0, 1376552718),
(212, 'User session was expired!', 0, 1376552736),
(213, 'User session was expired!', 0, 1376552736),
(214, 'User session was expired!', 0, 1376552771),
(215, 'User session was expired!', 0, 1376552771),
(216, 'User session was expired!', 0, 1376552838),
(217, 'User session was expired!', 0, 1376552838),
(218, 'User session was expired!', 0, 1376552851),
(219, 'User session was expired!', 0, 1376552851),
(220, 'User session was expired!', 0, 1376552883),
(221, 'User session was expired!', 0, 1376552883),
(222, 'User session was expired!', 0, 1376552954),
(223, 'User session was expired!', 0, 1376552954),
(224, 'User session was expired!', 0, 1376552963),
(225, 'User session was expired!', 0, 1376552963),
(226, 'User session was expired!', 0, 1376553063),
(227, 'User session was expired!', 0, 1376553063),
(228, 'User session was expired!', 0, 1376553198),
(229, 'User session was expired!', 0, 1376553198),
(230, 'User session was expired!', 0, 1376553200),
(231, 'User session was expired!', 0, 1376553200),
(232, 'User session was expired!', 0, 1376553258),
(233, 'User session was expired!', 0, 1376553258),
(234, 'User session was expired!', 0, 1376553318),
(235, 'User session was expired!', 0, 1376553318),
(236, 'User session was expired!', 0, 1376553368),
(237, 'User session was expired!', 0, 1376553368),
(238, 'User session was expired!', 0, 1376553389),
(239, 'User session was expired!', 0, 1376553389),
(240, 'User session was expired!', 0, 1376553407),
(241, 'User session was expired!', 0, 1376553407),
(242, 'User session was expired!', 0, 1376553415),
(243, 'User session was expired!', 0, 1376553415),
(244, 'User session was expired!', 0, 1376553430),
(245, 'User session was expired!', 0, 1376553430),
(246, 'User session was expired!', 0, 1376556319),
(247, 'User session was expired!', 0, 1376556319),
(248, 'User session was expired!', 0, 1376557204),
(249, 'User session was expired!', 0, 1376557204),
(250, 'User session was expired!', 0, 1376557217),
(251, 'User session was expired!', 0, 1376557217),
(252, 'User session was expired!', 0, 1376557268),
(253, 'User session was expired!', 0, 1376557268),
(254, 'User session was expired!', 0, 1376557380),
(255, 'User session was expired!', 0, 1376557380),
(256, 'User session was expired!', 0, 1376557401),
(257, 'User session was expired!', 0, 1376557401),
(258, 'User session was expired!', 0, 1376557860),
(259, 'User session was expired!', 0, 1376557860),
(260, 'User session was expired!', 0, 1376559236),
(261, 'User session was expired!', 0, 1376559236),
(262, 'User session was expired!', 0, 1376559248),
(263, 'User session was expired!', 0, 1376559248),
(264, 'User session was expired!', 0, 1376559261),
(265, 'User session was expired!', 0, 1376559262),
(266, 'User session was expired!', 0, 1376559272),
(267, 'User session was expired!', 0, 1376559272),
(268, 'User session was expired!', 0, 1376563053),
(269, 'User session was expired!', 0, 1376563053),
(270, 'User session was expired!', 0, 1376563071),
(271, 'User session was expired!', 0, 1376563071),
(272, 'User session was expired!', 0, 1376563735),
(273, 'User session was expired!', 0, 1376563735),
(274, 'User session was expired!', 0, 1376563811),
(275, 'User session was expired!', 0, 1376563811),
(276, 'User session was expired!', 0, 1376563831),
(277, 'User session was expired!', 0, 1376563831),
(278, 'User session was expired!', 0, 1376563857),
(279, 'User session was expired!', 0, 1376563857),
(280, 'User session was expired!', 0, 1376563857),
(281, 'User session was expired!', 0, 1376563857),
(282, 'User session was expired!', 0, 1376563861),
(283, 'User session was expired!', 0, 1376563861),
(284, 'User session was expired!', 0, 1376563967),
(285, 'User session was expired!', 0, 1376563967),
(286, 'User session was expired!', 0, 1376563970),
(287, 'User session was expired!', 0, 1376563970),
(288, 'User session was expired!', 0, 1376564017),
(289, 'User session was expired!', 0, 1376564017),
(290, 'User session was expired!', 0, 1376564137),
(291, 'User session was expired!', 0, 1376564137),
(292, 'User session was expired!', 0, 1376564137),
(293, 'User session was expired!', 0, 1376564137),
(294, 'User session was expired!', 0, 1376564244),
(295, 'User session was expired!', 0, 1376564244),
(296, 'User session was expired!', 0, 1376564248),
(297, 'User session was expired!', 0, 1376564248),
(298, 'User session was expired!', 0, 1376564302),
(299, 'User session was expired!', 0, 1376564302),
(300, 'User session was expired!', 0, 1376564402),
(301, 'User session was expired!', 0, 1376564402),
(302, 'User session was expired!', 0, 1376564739),
(303, 'User session was expired!', 0, 1376564739),
(304, 'User session was expired!', 0, 1376564799),
(305, 'User session was expired!', 0, 1376564799),
(306, 'User session was expired!', 0, 1376564808),
(307, 'User session was expired!', 0, 1376564808),
(308, 'User session was expired!', 0, 1376564863),
(309, 'User session was expired!', 0, 1376564863),
(310, 'User session was expired!', 0, 1376564922),
(311, 'User session was expired!', 0, 1376564922),
(312, 'User session was expired!', 0, 1376565183),
(313, 'User session was expired!', 0, 1376565183),
(314, 'User session was expired!', 0, 1376565189),
(315, 'User session was expired!', 0, 1376565189),
(316, 'User session was expired!', 0, 1376565264),
(317, 'User session was expired!', 0, 1376565264),
(318, 'User session was expired!', 0, 1376565378),
(319, 'User session was expired!', 0, 1376565378),
(320, 'User session was expired!', 0, 1376565470),
(321, 'User session was expired!', 0, 1376565470),
(322, 'User session was expired!', 0, 1376565522),
(323, 'User session was expired!', 0, 1376565522),
(324, 'User session was expired!', 0, 1376565570),
(325, 'User session was expired!', 0, 1376565570),
(326, 'User session was expired!', 0, 1376565616),
(327, 'User session was expired!', 0, 1376565616),
(328, 'User session was expired!', 0, 1376565630),
(329, 'User session was expired!', 0, 1376565630),
(330, 'User session was expired!', 0, 1376565660),
(331, 'User session was expired!', 0, 1376565660),
(332, 'User session was expired!', 0, 1376565686),
(333, 'User session was expired!', 0, 1376565686),
(334, 'User session was expired!', 0, 1376565720),
(335, 'User session was expired!', 0, 1376565720),
(336, 'User session was expired!', 0, 1376565731),
(337, 'User session was expired!', 0, 1376565731),
(338, 'User session was expired!', 0, 1376565785),
(339, 'User session was expired!', 0, 1376565785),
(340, 'User session was expired!', 0, 1376565808),
(341, 'User session was expired!', 0, 1376565808),
(342, 'User session was expired!', 0, 1376565836),
(343, 'User session was expired!', 0, 1376565836),
(344, 'User session was expired!', 0, 1376565861),
(345, 'User session was expired!', 0, 1376565861),
(346, 'User session was expired!', 0, 1376565941),
(347, 'User session was expired!', 0, 1376565941),
(348, 'User session was expired!', 0, 1376565965),
(349, 'User session was expired!', 0, 1376565965),
(350, 'User session was expired!', 0, 1376565970),
(351, 'User session was expired!', 0, 1376565970),
(352, 'User session was expired!', 0, 1376566158),
(353, 'User session was expired!', 0, 1376566158),
(354, 'User session was expired!', 0, 1376566328),
(355, 'User session was expired!', 0, 1376566328),
(356, 'User session was expired!', 0, 1376566369),
(357, 'User session was expired!', 0, 1376566369),
(358, 'User session was expired!', 0, 1376566369),
(359, 'User session was expired!', 0, 1376566369),
(360, 'User session was expired!', 0, 1376566431),
(361, 'User session was expired!', 0, 1376566431),
(362, 'User session was expired!', 0, 1376566444),
(363, 'User session was expired!', 0, 1376566444),
(364, 'User session was expired!', 0, 1376566482),
(365, 'User session was expired!', 0, 1376566482),
(366, 'User session was expired!', 0, 1376566560),
(367, 'User session was expired!', 0, 1376566560),
(368, 'User successfully logged in!', 2, 1376566603),
(369, 'User successfully logged out!', 2, 1376566846),
(370, 'User session was expired!', 0, 1376566846),
(371, 'User session was expired!', 0, 1376566846),
(372, 'User session was expired!', 0, 1376566882),
(373, 'User session was expired!', 0, 1376566882),
(374, 'User session was expired!', 0, 1376566923),
(375, 'User session was expired!', 0, 1376566923),
(376, 'User session was expired!', 0, 1376566945),
(377, 'User session was expired!', 0, 1376566945),
(378, 'User session was expired!', 0, 1376567001),
(379, 'User session was expired!', 0, 1376567001),
(380, 'User session was expired!', 0, 1376567041),
(381, 'User session was expired!', 0, 1376567041),
(382, 'User session was expired!', 0, 1376567124),
(383, 'User session was expired!', 0, 1376567124),
(384, 'User session was expired!', 0, 1376567307),
(385, 'User session was expired!', 0, 1376567307),
(386, 'User session was expired!', 0, 1376567354),
(387, 'User session was expired!', 0, 1376567354),
(388, 'User session was expired!', 0, 1376567614),
(389, 'User session was expired!', 0, 1376567614),
(390, 'User session was expired!', 0, 1376567658),
(391, 'User session was expired!', 0, 1376567659),
(392, 'User session was expired!', 0, 1376567961),
(393, 'User session was expired!', 0, 1376567961),
(394, 'User session was expired!', 0, 1376567961),
(395, 'User session was expired!', 0, 1376567961),
(396, 'User session was expired!', 0, 1376567967),
(397, 'User session was expired!', 0, 1376567967),
(398, 'User session was expired!', 0, 1376568000),
(399, 'User session was expired!', 0, 1376568000),
(400, 'User session was expired!', 0, 1376568021),
(401, 'User session was expired!', 0, 1376568021),
(402, 'User session was expired!', 0, 1376568022),
(403, 'User session was expired!', 0, 1376568022),
(404, 'User session was expired!', 0, 1376568173),
(405, 'User session was expired!', 0, 1376568174),
(406, 'User session was expired!', 0, 1376568206),
(407, 'User session was expired!', 0, 1376568207),
(408, 'User session was expired!', 0, 1376568207),
(409, 'User session was expired!', 0, 1376568207),
(410, 'User session was expired!', 0, 1376568228),
(411, 'User session was expired!', 0, 1376568228),
(412, 'User session was expired!', 0, 1376568430),
(413, 'User session was expired!', 0, 1376568430),
(414, 'User session was expired!', 0, 1376568768),
(415, 'User session was expired!', 0, 1376568768),
(416, 'User session was expired!', 0, 1376568815),
(417, 'User session was expired!', 0, 1376568815),
(418, 'User session was expired!', 0, 1376568885),
(419, 'User session was expired!', 0, 1376568885),
(420, 'User session was expired!', 0, 1376569183),
(421, 'User session was expired!', 0, 1376569183),
(422, 'User session was expired!', 0, 1376569201),
(423, 'User session was expired!', 0, 1376569201),
(424, 'User session was expired!', 0, 1376569508),
(425, 'User session was expired!', 0, 1376569514),
(426, 'User session was expired!', 0, 1376569940),
(427, 'User session was expired!', 0, 1376569940),
(428, 'User session was expired!', 0, 1376569950),
(429, 'User session was expired!', 0, 1376569961),
(430, 'User session was expired!', 0, 1376570280),
(431, 'User session was expired!', 0, 1376570280),
(432, 'User session was expired!', 0, 1376570346),
(433, 'User session was expired!', 0, 1376570346),
(434, 'User session was expired!', 0, 1376570383),
(435, 'User session was expired!', 0, 1376570383),
(436, 'User session was expired!', 0, 1376570420),
(437, 'User session was expired!', 0, 1376570420),
(438, 'User session was expired!', 0, 1376570488),
(439, 'User session was expired!', 0, 1376570488),
(440, 'User session was expired!', 0, 1376570636),
(441, 'User session was expired!', 0, 1376570641),
(442, 'User session was expired!', 0, 1376570799),
(443, 'User session was expired!', 0, 1376570805),
(444, 'User session was expired!', 0, 1376570805),
(445, 'User session was expired!', 0, 1376570805),
(446, 'User session was expired!', 0, 1376570806),
(447, 'User session was expired!', 0, 1376570806),
(448, 'User session was expired!', 0, 1376570806),
(449, 'User session was expired!', 0, 1376570806),
(450, 'User session was expired!', 0, 1376570806),
(451, 'User session was expired!', 0, 1376570806),
(452, 'User session was expired!', 0, 1376570806),
(453, 'User session was expired!', 0, 1376570806),
(454, 'User session was expired!', 0, 1376570806),
(455, 'User session was expired!', 0, 1376570806),
(456, 'User session was expired!', 0, 1376570806),
(457, 'User session was expired!', 0, 1376570807),
(458, 'User session was expired!', 0, 1376570810),
(459, 'User session was expired!', 0, 1376570810),
(460, 'User session was expired!', 0, 1376570810),
(461, 'User session was expired!', 0, 1376570810),
(462, 'User session was expired!', 0, 1376570810),
(463, 'User session was expired!', 0, 1376570810),
(464, 'User session was expired!', 0, 1376570810),
(465, 'User session was expired!', 0, 1376570810),
(466, 'User session was expired!', 0, 1376570810),
(467, 'User session was expired!', 0, 1376570811),
(468, 'User session was expired!', 0, 1376570811),
(469, 'User session was expired!', 0, 1376570811),
(470, 'User session was expired!', 0, 1376570811),
(471, 'User session was expired!', 0, 1376570811),
(472, 'User session was expired!', 0, 1376570818),
(473, 'User session was expired!', 0, 1376570818),
(474, 'User session was expired!', 0, 1376570818),
(475, 'User session was expired!', 0, 1376570818),
(476, 'User session was expired!', 0, 1376570819),
(477, 'User session was expired!', 0, 1376570819),
(478, 'User session was expired!', 0, 1376570819),
(479, 'User session was expired!', 0, 1376570819),
(480, 'User session was expired!', 0, 1376570819),
(481, 'User session was expired!', 0, 1376570819),
(482, 'User session was expired!', 0, 1376570819),
(483, 'User session was expired!', 0, 1376570819),
(484, 'User session was expired!', 0, 1376570819),
(485, 'User session was expired!', 0, 1376570819),
(486, 'User session was expired!', 0, 1376570823),
(487, 'User session was expired!', 0, 1376570823),
(488, 'User session was expired!', 0, 1376570823),
(489, 'User session was expired!', 0, 1376570823),
(490, 'User session was expired!', 0, 1376570824),
(491, 'User session was expired!', 0, 1376570824),
(492, 'User session was expired!', 0, 1376570824),
(493, 'User session was expired!', 0, 1376570824),
(494, 'User session was expired!', 0, 1376570824),
(495, 'User session was expired!', 0, 1376570824),
(496, 'User session was expired!', 0, 1376570824),
(497, 'User session was expired!', 0, 1376570824),
(498, 'User session was expired!', 0, 1376570824),
(499, 'User session was expired!', 0, 1376570824),
(500, 'User session was expired!', 0, 1376570830),
(501, 'User session was expired!', 0, 1376632144),
(502, 'User session was expired!', 0, 1376632161),
(503, 'User session was expired!', 0, 1376632161),
(504, 'User session was expired!', 0, 1376639913),
(505, 'User session was expired!', 0, 1376639913),
(506, 'User session was expired!', 0, 1376640269),
(507, 'User session was expired!', 0, 1376640269),
(508, 'User session was expired!', 0, 1376650536),
(509, 'User session was expired!', 0, 1376650536),
(510, 'User session was expired!', 0, 1376650619),
(511, 'User session was expired!', 0, 1376650619),
(512, 'User session was expired!', 0, 1376715458),
(513, 'User session was expired!', 0, 1376715458),
(514, 'User session was expired!', 0, 1376715473),
(515, 'User session was expired!', 0, 1376715473),
(516, 'User session was expired!', 0, 1376887280),
(517, 'User session was expired!', 0, 1376887280),
(518, 'User session was expired!', 0, 1376913722),
(519, 'User session was expired!', 0, 1376913722),
(520, 'User session was expired!', 0, 1376914190),
(521, 'User session was expired!', 0, 1376914190),
(522, 'User session was expired!', 0, 1376974598),
(523, 'User session was expired!', 0, 1376974598),
(524, 'User session was expired!', 0, 1377000709),
(525, 'User session was expired!', 0, 1377000709),
(526, 'User session was expired!', 0, 1377060402),
(527, 'User session was expired!', 0, 1377060402),
(528, 'User session was expired!', 0, 1377060417),
(529, 'User session was expired!', 0, 1377060417),
(530, 'User session was expired!', 0, 1377146317),
(531, 'User session was expired!', 0, 1377146317),
(532, 'User session was expired!', 0, 1377146322),
(533, 'User session was expired!', 0, 1377146322),
(534, 'User session was expired!', 0, 1377235548),
(535, 'User session was expired!', 0, 1377319676);

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

--
-- Table structure for table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_bin NOT NULL,
  `email` varchar(255) COLLATE utf8_bin NOT NULL,
  `password` varchar(255) COLLATE utf8_bin NOT NULL,
  `registertime` int(11) NOT NULL,
  `mobileverification` int(11) NOT NULL,
  `emailverification` int(11) NOT NULL,
  `sc` varchar(255) COLLATE utf8_bin NOT NULL,
  `verificationdate` int(11) NOT NULL,
  `privacylevel` int(11) NOT NULL,
  `lastpage` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `uid` (`uid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3 ;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`uid`, `username`, `email`, `password`, `registertime`, `mobileverification`, `emailverification`, `sc`, `verificationdate`, `privacylevel`, `lastpage`) VALUES
(2, 'rahber', 'rahber50@gmail.com', '123', 0, 0, 1, 'apple', 1375853558, 0, 'home.php');

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

--
-- Table structure for table `pairness_family`
--

CREATE TABLE IF NOT EXISTS `pairness_family` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) NOT NULL,
  `familyid` int(10) NOT NULL,
  `familyfullname` varchar(100) NOT NULL,
  `familyemailaddress` varchar(200) NOT NULL,
  `familypassword` varchar(20) NOT NULL,
  `familygender` varchar(10) NOT NULL,
  `familyseekinggender` varchar(10) NOT NULL,
  `familydateofbirth` date NOT NULL,
  `familycountry` varchar(50) NOT NULL,
  `familystate` varchar(100) NOT NULL,
  `familycity` varchar(100) NOT NULL,
  `familyterms` varchar(255) NOT NULL,
  `familyfirstname` varchar(50) NOT NULL,
  `familylastname` varchar(50) NOT NULL,
  `familyphone` int(20) NOT NULL,
  `familycell` int(20) NOT NULL,
  `familyprofileimage` varchar(255) NOT NULL,
  `familyprofiledate` datetime NOT NULL,
  `familyprofiletime` time NOT NULL,
  `familyhaircolor` int(10) NOT NULL,
  `familyhairtype` int(10) NOT NULL,
  `familyeyecolor` int(10) NOT NULL,
  `familyeyewear` int(10) NOT NULL,
  `familyheight` int(10) NOT NULL,
  `familyweight` int(10) NOT NULL,
  `familybodytype` int(10) NOT NULL,
  `familyappearance` int(10) NOT NULL,
  `familyfacialhair` int(10) NOT NULL,
  `familyphysicalstatus` int(10) NOT NULL,
  `familymaritalstatus` int(10) NOT NULL,
  `familyhavechildrens` int(10) NOT NULL,
  `familyvalues` int(10) NOT NULL,
  `familylivingsituation` int(10) NOT NULL,
  `familylikes` varchar(255) NOT NULL,
  `familydislikes` varchar(255) NOT NULL,
  `familyzodiachormony` varchar(30) NOT NULL,
  `familyfoodhabits` int(10) NOT NULL,
  `familyeducation` int(10) NOT NULL,
  `familyoccupation` int(10) NOT NULL,
  `familyrelocate` int(10) NOT NULL,
  `familyreligion` int(10) NOT NULL,
  `familybornreverted` int(10) NOT NULL,
  `familyreligiousvalues` int(10) NOT NULL,
  `familyattendreligiousservices` int(10) NOT NULL,
  `familymothertongue` int(10) NOT NULL,
  `familyethnicity` int(10) NOT NULL,
  `familycast` varchar(50) NOT NULL,
  `familynationality` int(10) NOT NULL,
  `familyplaceofbirth` int(10) NOT NULL,
  `familylanguagesspoken` int(10) NOT NULL,
  `familyambition` varchar(255) NOT NULL,
  `familyhobbies` varchar(255) NOT NULL,
  `familydreams` varchar(255) NOT NULL,
  `familygetmarried` int(10) NOT NULL,
  `familywantmorechildrens` int(10) NOT NULL,
  `familydowry` int(10) NOT NULL,
  `familycnicnumber` int(20) NOT NULL,
  `familycnicimage` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `pairness_family`
--

INSERT INTO `pairness_family` (`id`, `ip`, `familyid`, `familyfullname`, `familyemailaddress`, `familypassword`, `familygender`, `familyseekinggender`, `familydateofbirth`, `familycountry`, `familystate`, `familycity`, `familyterms`, `familyfirstname`, `familylastname`, `familyphone`, `familycell`, `familyprofileimage`, `familyprofiledate`, `familyprofiletime`, `familyhaircolor`, `familyhairtype`, `familyeyecolor`, `familyeyewear`, `familyheight`, `familyweight`, `familybodytype`, `familyappearance`, `familyfacialhair`, `familyphysicalstatus`, `familymaritalstatus`, `familyhavechildrens`, `familyvalues`, `familylivingsituation`, `familylikes`, `familydislikes`, `familyzodiachormony`, `familyfoodhabits`, `familyeducation`, `familyoccupation`, `familyrelocate`, `familyreligion`, `familybornreverted`, `familyreligiousvalues`, `familyattendreligiousservices`, `familymothertongue`, `familyethnicity`, `familycast`, `familynationality`, `familyplaceofbirth`, `familylanguagesspoken`, `familyambition`, `familyhobbies`, `familydreams`, `familygetmarried`, `familywantmorechildrens`, `familydowry`, `familycnicnumber`, `familycnicimage`) VALUES
(1, '127.0.0.1', 0, 'hdfgsdfg', 'dfgjksdgq', 'kjhkhgdfg', '', '', '0000-00-00', '', '', '', '', '', '', 0, 0, 'default.png', '0000-00-00 00:00:00', '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', '', '', 0, 0, 0, 0, ''),
(2, '127.0.0.1', 0, 'jkgjkgjkg', 'gfjsg', 'kjgkh', '', '', '0000-00-00', '', '', '', '', '', '', 0, 0, 'default.png', '0000-00-00 00:00:00', '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', '', '', 0, 0, 0, 0, ''),
(3, '127.0.0.1', 0, 'jkhjklh', 'tyjhgh', 'jkhjkhkj', '', '', '0000-00-00', '', '', '', '', '', '', 0, 0, 'default.png', '0000-00-00 00:00:00', '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', '', '', 0, 0, 0, 0, ''),
(4, '127.0.0.1', 0, 'ozil11', 'gmailozil', 'hghjkgh', '', '', '0000-00-00', '', '', '', '', '', '', 0, 0, 'default.png', '0000-00-00 00:00:00', '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', '', '', 0, 0, 0, 0, ''),
(5, '127.0.0.1', 0, 'ghjhgjhg', 'fgsdjg', 'hjgjhgj', '', '', '0000-00-00', '', '', '', '', '', '', 0, 0, 'default.png', '0000-00-00 00:00:00', '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', '', '', 0, 0, 0, 0, ''),
(10, '127.0.0.1', 0, 'hgjhg', 'dgcd', 'jhg', '', '', '0000-00-00', '', '', '', '', '', '', 0, 0, 'default.png', '0000-00-00 00:00:00', '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', '', '', 0, 0, 0, 0, ''),
(11, '127.0.0.1', 0, 'alskdjsa', 'rahber', 'asdas;ld', '', '', '0000-00-00', '', '', '', '', '', '', 0, 0, 'default.png', '0000-00-00 00:00:00', '00:00:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', '', '', 0, 0, 0, 0, ''),
(12, '127.0.0.1', 0, 'ali_baba', 'muhammadzubair107@gmail.com', 'abcxyzz7', 'male', 'female', '1989-06-26', 'Pakistan', 'Punjab', 'Rawlpindi', 'Testing', 'Muhammad', 'Zubair', 514479815, 346598174, 'images.jpg', '2013-08-16 00:00:00', '11:20:00', 371, 384, 355, 358, 166, 50, 276, 257, 368, 922, 556, 285, 822, 551, 'Testing', 'Testing', 'Testing', 299, 316, 573, 701, 644, 822, 698, 691, 5, 2, 'Chaudry', 169, 169, 980, 'Testing', 'Testing', 'Testing', 826, 289, 822, 2147483647, 'beautiful_landscape-wide.jpg');

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

--
-- Table structure for table `pairness_features`
--

CREATE TABLE IF NOT EXISTS `pairness_features` (
  `id` int(10) NOT NULL,
  `category_id` int(10) NOT NULL,
  `name` varchar(200) COLLATE utf8_bin NOT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `pairness_features`
--

INSERT INTO `pairness_features` (`id`, `category_id`, `name`) VALUES
(1062, 29, 'prefer not to say'),
(1063, 29, 'interested'),
(1064, 29, 'Never interested'),
(1065, 28, 'No'),
(1066, 28, 'Not Sure'),
(1067, 28, 'Yes'),
(1068, 27, 'Other'),
(1069, 27, 'After 2 years'),
(1070, 27, 'After 1 year'),
(1071, 27, 'After 6 months'),
(1072, 27, 'After 3 months'),
(1073, 26, 'Other'),
(1074, 26, 'Welsh'),
(1075, 26, 'Vietnamese'),
(1076, 26, 'Uzbek'),
(1077, 26, 'Urdu'),
(1078, 26, 'Ukrainian'),
(1079, 26, 'Ugaritic'),
(1080, 26, 'Turkmen'),
(1081, 26, 'Turkish'),
(1082, 26, 'Tongan'),
(1083, 26, 'Tibetan'),
(1084, 26, 'Thai'),
(1085, 26, 'Telugu'),
(1086, 26, 'Tamil'),
(1087, 26, 'Tagalog'),
(1088, 26, 'Swedish'),
(1089, 26, 'Swahili'),
(1090, 26, 'Spanish'),
(1091, 26, 'Somali'),
(1092, 26, 'Slovene'),
(1093, 26, 'Slovak'),
(1094, 26, 'Sinhala'),
(1095, 26, 'Sindhi'),
(1096, 26, 'Serbian'),
(1097, 26, 'Russian'),
(1098, 26, 'Romanian'),
(1099, 26, 'Quechua'),
(1100, 26, 'Portuguese'),
(1101, 26, 'Polish'),
(1102, 26, 'Pidgin'),
(1103, 26, 'Persian'),
(1104, 26, 'Pashto'),
(1105, 26, 'Norwegian'),
(1106, 26, 'Nepali'),
(1107, 26, 'Mongolian'),
(1108, 26, 'Marathi'),
(1109, 26, 'Maltese'),
(1110, 26, 'Maldivian'),
(1111, 26, 'Malayalam'),
(1112, 26, 'Malagasy'),
(1113, 26, 'Macedonian'),
(1114, 26, 'Lithuanian'),
(1115, 26, 'Latvian'),
(1114, 26, 'Lithuanian'),
(1115, 26, 'Latvian'),
(1116, 26, 'Laotian'),
(1117, 26, 'Kyrgiz'),
(1118, 26, 'Kutchi'),
(1119, 26, 'Kurdish'),
(1120, 26, 'Korean'),
(1121, 26, 'Kirgiz'),
(1122, 26, 'Khmer'),
(1123, 26, 'Kazakh'),
(1124, 26, 'Japanese'),
(1125, 26, 'Italian'),
(1126, 26, 'Inuktitut'),
(1127, 26, 'Iilocano'),
(1128, 26, 'Icelandic'),
(1129, 26, 'Hungarian'),
(1130, 26, 'Hindi'),
(1131, 26, 'Hebrew'),
(1132, 26, 'Hausa'),
(1133, 26, 'Gujarati'),
(1134, 26, 'Greek'),
(1135, 26, 'German'),
(1136, 26, 'Georgian'),
(1137, 26, 'French'),
(1138, 26, 'Finnish'),
(1139, 26, 'Farsi'),
(1140, 26, 'Estonian'),
(1141, 26, 'Eritrean'),
(1142, 26, 'English'),
(1143, 26, 'Dutch'),
(1144, 26, 'Danish'),
(1145, 26, 'Czech'),
(1146, 26, 'Croatian'),
(1147, 26, 'Creole'),
(1148, 26, 'Chinese (Mandarin)'),
(1149, 26, 'Chinese (Cantonese)'),
(1150, 26, 'Cebuano'),
(1151, 26, 'Burmese'),
(1152, 26, 'Bulgarian'),
(1153, 26, 'Berber'),
(1154, 26, 'Bengali'),
(1155, 26, 'Belorussian'),
(1156, 26, 'Bahasa Malay / Indonesian'),
(1157, 26, 'Azerbaijani'),
(1158, 26, 'Assyrian'),
(1159, 26, 'Armenian'),
(1160, 26, 'Arabic'),
(1161, 26, 'Amharic'),
(1162, 26, 'Albanian'),
(1163, 26, 'Afrikaans'),
(1164, 25, 'Zimbabwe'),
(1165, 25, 'Zambia'),
(1166, 25, 'Yemen'),
(1167, 25, 'Western Sahara'),
(1168, 25, 'Wallis and Futuna'),
(1169, 25, 'Virgin Islands (US)'),
(1170, 25, 'Virgin Islands (British)'),
(1171, 25, 'Vietnam'),
(1172, 25, 'Venezuela'),
(1173, 25, 'Vanuatu'),
(1174, 25, 'Uzbekistan'),
(1175, 25, 'US Minor Outlying Is'),
(1176, 25, 'Uruguay'),
(1177, 25, 'United States'),
(1178, 25, 'United Kingdom'),
(1179, 25, 'United Arab Emirates'),
(1180, 25, 'Ukraine'),
(1181, 25, 'Uganda'),
(1182, 25, 'Tuvalu'),
(1183, 25, 'Turks & Caicos Is'),
(1184, 25, 'Turkmenistan'),
(1185, 25, 'Turkey'),
(1186, 25, 'Tunisia'),
(1187, 25, 'Trinidad and Tobago'),
(1188, 25, 'Tonga'),
(1189, 25, 'Tokelau'),
(1190, 25, 'Togo'),
(1191, 25, 'Thailand'),
(1192, 25, 'Tanzania'),
(1193, 25, 'Tajikistan'),
(1194, 25, 'Taiwan'),
(1195, 25, 'Syria'),
(1196, 25, 'Switzerland'),
(1197, 25, 'Sweden'),
(1198, 25, 'Swaziland'),
(1199, 25, 'Svalbard & Jan Mayen'),
(1200, 25, 'Suriname'),
(1201, 25, 'Sudan'),
(1202, 25, 'St Vincent Grenadines'),
(1203, 25, 'St Pierre &  Miquelon'),
(1204, 25, 'St Kitts & Nevis'),
(1205, 25, 'Sri Lanka'),
(1206, 25, 'Spain'),
(1207, 25, 'South Georgia Island'),
(1208, 25, 'South Africa'),
(1209, 25, 'Somalia'),
(1210, 25, 'Solomon Islands'),
(1211, 25, 'Slovenia'),
(1212, 25, 'Slovakia'),
(1213, 25, 'Singapore'),
(1214, 25, 'Sierra Leone'),
(1215, 25, 'Seychelles'),
(1216, 25, 'Serbia'),
(1217, 25, 'Senegal'),
(1218, 25, 'Saudi Arabia'),
(1219, 25, 'Sao Tome & Principe'),
(1220, 25, 'San Marino'),
(1221, 25, 'Samoa'),
(1222, 25, 'Saint Lucia'),
(1223, 25, 'Saint Helena'),
(1224, 25, 'Rwanda'),
(1225, 25, 'Russia'),
(1226, 25, 'Romania'),
(1227, 25, 'Reunion'),
(1228, 25, 'Qatar'),
(1229, 25, 'Puerto Rico'),
(1230, 25, 'Portugal'),
(1231, 25, 'Poland'),
(1232, 25, 'Pitcairn Islands'),
(1233, 25, 'Philippines'),
(1234, 25, 'Peru'),
(1235, 25, 'Paraguay'),
(1236, 25, 'Papua New Guinea'),
(1237, 25, 'Panama'),
(1238, 25, 'Palestine'),
(1239, 25, 'Palau'),
(1240, 25, 'Pakistan'),
(1241, 25, 'Oman'),
(1242, 25, 'Norway'),
(1243, 25, 'Northern Mariana Is'),
(1244, 25, 'Norfolk Island'),
(1245, 25, 'Niue'),
(1246, 25, 'Nigeria'),
(1247, 25, 'Niger'),
(1248, 25, 'Nicaragua'),
(1249, 25, 'New Zealand'),
(1250, 25, 'New Caledonia'),
(1251, 25, 'Netherlands Antilles'),
(1252, 25, 'Netherlands'),
(1253, 25, 'Nepal'),
(1254, 25, 'Nauru'),
(1255, 25, 'Namibia'),
(1256, 25, 'Myanmar'),
(1257, 25, 'Mozambique'),
(1258, 25, 'Morocco'),
(1259, 25, 'Montserrat'),
(1260, 25, 'Mongolia'),
(1261, 25, 'Monaco'),
(1262, 25, 'Moldova'),
(1263, 25, 'Micronesia'),
(1264, 25, 'Mexico'),
(1265, 25, 'Mayotte'),
(1266, 25, 'Mauritius'),
(1267, 25, 'Mauritania'),
(1268, 25, 'Martinique'),
(1269, 25, 'Marshall Islands'),
(1270, 25, 'Malta'),
(1271, 25, 'Mali'),
(1272, 25, 'Maldives'),
(1273, 25, 'Malaysia'),
(1274, 25, 'Malawi'),
(1275, 25, 'Madagascar'),
(1276, 25, 'Macedonia (FYR)'),
(1277, 25, 'Macau'),
(1278, 25, 'Luxembourg'),
(1279, 25, 'Lithuania'),
(1280, 25, 'Liechtenstein'),
(1281, 25, 'Libya'),
(1282, 25, 'Liberia'),
(1283, 25, 'Lesotho'),
(1284, 25, 'Lebanon'),
(1285, 25, 'Latvia'),
(1286, 25, 'Laos'),
(1287, 25, 'Kyrgyzstan'),
(1288, 25, 'Kuwait'),
(1289, 25, 'Korea, South'),
(1290, 25, 'Korea, North'),
(1291, 25, 'Kiribati'),
(1292, 25, 'Kenya'),
(1293, 25, 'Kazakhstan'),
(1294, 25, 'Jordan'),
(1295, 25, 'Jersey'),
(1296, 25, 'Japan'),
(1297, 25, 'Jamaica'),
(1298, 25, 'Italy'),
(1299, 25, 'Israel'),
(1300, 25, 'Isle of Man'),
(1301, 25, 'Ireland'),
(1302, 25, 'Iraq'),
(1303, 25, 'Iran'),
(1304, 25, 'Indonesia'),
(1305, 25, 'India'),
(1306, 25, 'Iceland'),
(1307, 25, 'Hungary'),
(1308, 25, 'Hong Kong'),
(1309, 25, 'Honduras'),
(1310, 25, 'Holy See (Vatican City)'),
(1311, 25, 'Heard & McDonald Is'),
(1312, 25, 'Haiti'),
(1313, 25, 'Guyana'),
(0, 0, ''),
(0, 0, ''),
(1314, 25, 'Guinea-Bissau'),
(1315, 25, 'Guinea'),
(1316, 25, 'Guernsey'),
(1317, 25, 'Guatemala'),
(1318, 25, 'Guam'),
(1319, 25, 'Guadeloupe'),
(1320, 25, 'Grenada'),
(1321, 25, 'Greenland'),
(1322, 25, 'Greece'),
(1323, 25, 'Gibraltar'),
(1324, 25, 'Ghana'),
(1325, 25, 'Germany'),
(1326, 25, 'Georgia'),
(1327, 25, 'Gambia'),
(1328, 25, 'Gabon'),
(1329, 25, 'French Polynesia'),
(1330, 25, 'French Guiana'),
(1331, 25, 'French Antarctic'),
(1332, 25, 'France'),
(1333, 25, 'Finland'),
(1334, 25, 'Fiji'),
(1335, 25, 'Faroe Islands'),
(1336, 25, 'Falkland Islands'),
(1337, 25, 'Ethiopia'),
(1338, 25, 'Estonia'),
(1339, 25, 'Eritrea'),
(1340, 25, 'Equatorial Guinea'),
(1341, 25, 'El Salvador'),
(1342, 25, 'Egypt'),
(1343, 25, 'Ecuador'),
(1344, 25, 'East Timor'),
(1345, 25, 'Dominican Republic'),
(1346, 25, 'Dominica'),
(1347, 25, 'Djibouti'),
(1348, 25, 'Denmark'),
(0, 0, ''),
(0, 0, ''),
(1349, 25, 'Czech Republic'),
(1350, 25, 'Cyprus'),
(1351, 25, 'Cuba'),
(1352, 25, 'Croatia'),
(1353, 25, 'Cote d''Ivoire'),
(1354, 25, 'Costa Rica'),
(1355, 25, 'Cook Islands'),
(1356, 25, 'Congo, Republic'),
(1357, 25, 'Congo, Dem. Rep'),
(1358, 25, 'Comoros'),
(1359, 25, 'Colombia'),
(1360, 25, 'Cocos (Keeling) Is'),
(1361, 25, 'Christmas Island'),
(1362, 25, 'China'),
(1363, 25, 'Chile'),
(1364, 25, 'Chad'),
(1365, 25, 'Central African Rep'),
(1366, 25, 'Cayman Islands'),
(1367, 25, 'Cape Verde'),
(1368, 25, 'Canada'),
(1369, 25, 'Cameroon'),
(1370, 25, 'Cambodia'),
(1371, 25, 'Burundi'),
(1372, 25, 'Burkina Faso'),
(1373, 25, 'Bulgaria'),
(1374, 25, 'Brunei'),
(1375, 25, 'British Indian Ocean'),
(1376, 25, 'Brazil'),
(1377, 25, 'Bouvet Island'),
(1378, 25, 'Botswana'),
(1379, 25, 'Bosnia & Herzegovina'),
(1380, 25, 'Bolivia'),
(1381, 25, 'Bhutan'),
(1382, 25, 'Bermuda'),
(1383, 25, 'Benin'),
(1384, 25, 'Belize'),
(1385, 25, 'Belgium'),
(1386, 25, 'Belarus'),
(1387, 25, 'Barbados'),
(1388, 25, 'Bangladesh'),
(1389, 25, 'Bahrain'),
(1390, 25, 'Bahamas'),
(1391, 25, 'Azerbaijan'),
(1392, 25, 'Austria'),
(1393, 25, 'Aruba'),
(1395, 25, 'Armenia'),
(1396, 25, 'Argentina'),
(1397, 25, 'Antigua and Barbuda'),
(1398, 25, 'Antarctica'),
(1399, 25, 'Anguilla'),
(1400, 25, 'Angola'),
(1401, 25, 'Andorra'),
(1402, 25, 'American Samoa'),
(1403, 25, 'Algeria'),
(1404, 25, 'Albania'),
(1405, 25, 'Afghanistan'),
(1406, 24, 'Other'),
(1407, 24, 'West European'),
(1408, 24, 'Spanish'),
(1409, 24, 'Russian'),
(1410, 24, 'Pakistani'),
(1411, 24, 'Other'),
(1412, 24, 'North African'),
(1413, 24, 'Native American'),
(1414, 24, 'Middle Eastern'),
(1415, 24, 'Mexican'),
(1416, 24, 'Indian'),
(1417, 24, 'French'),
(1418, 24, 'East European'),
(1419, 24, 'Caucasian'),
(1420, 24, 'Canadian'),
(1421, 24, 'Australian'),
(1422, 24, 'Asian'),
(1423, 24, 'American'),
(1424, 24, 'African Other'),
(1425, 24, 'African American'),
(1426, 23, '--Other--'),
(1427, 23, 'Vietnamese'),
(1428, 23, 'Uzbek'),
(1430, 23, 'Ukrainian'),
(1431, 23, 'Turkish'),
(1432, 23, 'Tulu'),
(1433, 23, 'Thai'),
(1434, 23, 'Telugu'),
(1435, 23, 'Tamil'),
(1436, 23, 'Tagalog'),
(1437, 23, 'Swedish'),
(1438, 23, 'Swahili'),
(1439, 23, 'Sundanese'),
(1440, 23, 'Spanish'),
(1441, 23, 'Siraiki'),
(1442, 23, 'Sindhi'),
(1443, 23, 'Serbian'),
(1444, 23, 'Santhali'),
(1445, 23, 'Sanskrit'),
(1446, 23, 'Russian'),
(1447, 23, 'Rajasthani'),
(1448, 23, 'Punjabi'),
(1449, 23, 'Portuguese'),
(1450, 23, 'Polish'),
(1451, 23, 'Persian (Farsi)'),
(1452, 23, 'Persian'),
(1453, 23, 'Pashtu'),
(1454, 23, 'Pashai'),
(1455, 23, 'Oriya'),
(1456, 23, 'Nubian'),
(1457, 23, 'Norwegian'),
(1458, 23, 'Nepali'),
(1459, 23, 'Monpa'),
(1460, 23, 'Mizo'),
(1461, 23, 'Miji'),
(1462, 23, 'Marwari'),
(1463, 23, 'Marathi'),
(1464, 23, 'Manipuri'),
(1465, 23, 'Mandarin Chinese'),
(1466, 23, 'Malayalam'),
(1467, 23, 'Malay'),
(1468, 23, 'Maithili'),
(1469, 23, 'Magahi'),
(1470, 23, 'Luri'),
(1471, 23, 'Lepcha'),
(1472, 23, 'Latin'),
(1473, 23, 'Kutchi'),
(1474, 23, 'Kurdish'),
(1475, 23, 'Kumoani'),
(1476, 23, 'Koshali'),
(1477, 23, 'Korean'),
(1478, 23, 'Konkani'),
(1479, 23, 'Khasi'),
(1480, 23, 'Kashmiri'),
(1481, 23, 'Kannada'),
(1482, 23, 'Kanauji'),
(1483, 23, 'Kakbarak'),
(1484, 23, 'Javanese'),
(1485, 23, 'Japanese'),
(1486, 23, 'Italian'),
(1487, 23, 'Indonesian'),
(1488, 23, 'Hungarian'),
(1489, 23, 'Hindi'),
(1490, 23, 'Hebrew'),
(1491, 23, 'Haryanvi'),
(1492, 23, 'Gujarati'),
(1493, 23, 'Greek'),
(1494, 23, 'German'),
(1495, 23, 'Garhwali'),
(1496, 23, 'French'),
(1497, 23, 'Finnish'),
(1498, 23, 'Farsi (Persian)'),
(1499, 23, 'English'),
(1500, 23, 'Dutch'),
(1501, 23, 'Dogri'),
(1502, 23, 'Danish'),
(1503, 23, 'Czech'),
(1504, 23, 'Croatian'),
(1505, 23, 'Circassi'),
(1506, 23, 'Chinese'),
(1507, 23, 'Chatlisgarhi'),
(1508, 23, 'Cantonese'),
(1509, 23, 'Cambodian'),
(1510, 23, 'Bulgarian'),
(1511, 23, 'Bhutia'),
(1512, 23, 'Bhojpuri'),
(1513, 23, 'Berber'),
(1514, 23, 'Bengali'),
(1515, 23, 'Baluchi'),
(1516, 23, 'Balochi'),
(1517, 23, 'Balinese'),
(1518, 23, 'Awadhi'),
(1519, 23, 'Assyrian'),
(1520, 23, 'Assamese'),
(1521, 23, 'Arminian'),
(1522, 23, 'Armenian'),
(1523, 23, 'Aramaic'),
(1524, 23, 'Arabic'),
(1525, 23, 'Aka'),
(1526, 23, 'Nubian'),
(1527, 23, 'Greek'),
(1528, 23, 'Circassi'),
(1529, 23, 'Aramaic'),
(1530, 23, 'Siraiki'),
(1531, 23, 'Sindhi'),
(1532, 23, 'Punjabi'),
(1533, 23, 'Baluchi'),
(1534, 23, 'Hindi'),
(1535, 23, 'Hebrew'),
(1536, 23, 'Armenian'),
(1537, 23, 'Assyrian'),
(1538, 23, 'Luri'),
(1539, 23, 'French'),
(1540, 23, 'Pashai'),
(1541, 23, 'Balochi'),
(1542, 23, 'Uzbek'),
(1543, 23, 'Berber'),
(1544, 23, 'Kurdish'),
(1545, 23, 'Arminian'),
(1546, 23, 'Farsi (Persian)'),
(1547, 23, 'Pashtu'),
(1548, 23, 'Malay'),
(1549, 23, 'Urdu'),
(1550, 23, 'Arabic'),
(1551, 23, 'Mandarin Chinese'),
(1552, 23, 'Balinese'),
(1553, 23, 'Sundanese'),
(1554, 23, 'Javanese'),
(1555, 23, 'Indonesian'),
(1556, 22, 'Never'),
(1557, 22, 'Only During Ramadan'),
(1558, 22, 'Sometimes'),
(1559, 22, 'Only on Jummah / Fridays'),
(1560, 22, 'Daily'),
(1561, 21, 'Not Religious'),
(1562, 21, 'Religious'),
(1563, 21, 'Very Religious'),
(0, 0, ''),
(0, 0, ''),
(0, 0, ''),
(1564, 20, 'Plan to revert to Islam'),
(1565, 20, 'Reverted to Islam'),
(1564, 20, 'Plan to revert to Islam'),
(1565, 20, 'Reverted to Islam'),
(1566, 20, 'Born a muslim'),
(1567, 19, 'Other'),
(1568, 19, 'Willing to revert'),
(1569, 19, 'Islam - Other'),
(1570, 19, 'Islam - Ahmadiyya'),
(1571, 19, 'Islam - Sufism'),
(1567, 19, 'Other'),
(1568, 19, 'Willing to revert'),
(1569, 19, 'Islam - Other'),
(1570, 19, 'Islam - Ahmadiyya'),
(1571, 19, 'Islam - Sufism'),
(1572, 19, 'Islam - Shiite'),
(1573, 19, 'Islam - Sunni'),
(1574, 18, 'Not sure about relocating'),
(1575, 18, 'Not willing to relocate'),
(1574, 18, 'Not sure about relocating'),
(1575, 18, 'Not willing to relocate'),
(1576, 18, 'Willing to relocate to another country'),
(1577, 18, 'illing to relocate within my country'),
(1578, 17, 'Other'),
(1579, 17, 'Unemployed'),
(1580, 17, 'Travel / Hospitality'),
(1581, 17, 'Transportation'),
(1582, 17, 'Technical / Science / Engineering'),
(1583, 17, 'Student'),
(1584, 17, 'Sports / recreation'),
(1585, 17, 'Self Employed'),
(1586, 17, 'Sales / Marketing'),
(1587, 17, 'Retired'),
(1588, 17, 'Retail / Food services'),
(1589, 17, 'Political / Govt / Civil Service'),
(1590, 17, 'Non-profit / clergy / social services'),
(1591, 17, 'No occupation / Stay at home'),
(1592, 17, 'Nanny / Child care'),
(1593, 17, 'Military'),
(1594, 17, 'Medical / Dental / Veterinary'),
(1595, 17, 'Legal'),
(1596, 17, 'Laborer / Manufacturing'),
(1597, 17, 'IT / Communications'),
(1598, 17, 'Hair Dresser / Personal Grooming'),
(1599, 17, 'Fire / law enforcement / security'),
(1600, 17, 'Finance / Banking / Real Estate'),
(1601, 17, 'Farming / Agriculture'),
(1602, 17, 'Executive / Management / HR'),
(1603, 17, 'Entertainment / Media'),
(1604, 17, 'Education / Academic'),
(1605, 17, 'Domestic Helper'),
(1606, 17, 'Construction / Trades'),
(1607, 17, 'Artistic / Creative / Performance'),
(1608, 17, 'Advertising / Media'),
(1609, 17, 'Administrative / Secretarial / Clerical'),
(1610, 16, 'PhD or Doctorate'),
(1611, 16, 'Masters Degree'),
(1612, 16, 'Bachelors Degree'),
(1613, 16, 'Vocational College'),
(1614, 16, 'High School'),
(1610, 16, 'PhD or Doctorate'),
(1611, 16, 'Masters Degree'),
(1612, 16, 'Bachelors Degree'),
(1613, 16, 'Vocational College'),
(1614, 16, 'High School'),
(1615, 16, 'Middle School / Junior High'),
(1616, 16, 'Primary (Elementary) School'),
(1617, 15, 'No special restrictions'),
(1618, 15, 'Halal foods when I can'),
(1617, 15, 'No special restrictions'),
(1618, 15, 'Halal foods when I can'),
(1619, 15, 'Halal foods always'),
(1620, 14, 'Prefer not to say'),
(1621, 14, 'Other'),
(1622, 14, 'Live with spouse'),
(1623, 14, 'Live with kids'),
(1624, 14, 'Live with family'),
(1620, 14, 'Prefer not to say'),
(1621, 14, 'Other'),
(1622, 14, 'Live with spouse'),
(1623, 14, 'Live with kids'),
(1624, 14, 'Live with family'),
(1625, 14, 'Live with friends'),
(1626, 14, 'Live Alone'),
(1627, 13, 'Liberal'),
(1628, 13, 'Moderate'),
(1627, 13, 'Liberal'),
(1628, 13, 'Moderate'),
(1629, 13, 'Traditional'),
(1630, 12, 'Yes - live at home'),
(1631, 12, 'Yes - sometimes live at home'),
(1732, 12, 'Yes - don''t live at home'),
(1733, 12, 'No'),
(1734, 12, 'Married'),
(1735, 11, 'Divorced'),
(1736, 11, 'Widowed'),
(1737, 11, 'Separated'),
(1738, 11, 'Single'),
(1739, 10, 'Prefer not to say'),
(1740, 10, 'Major Physical Disability'),
(1741, 10, 'Minor Physical Disability'),
(1742, 10, 'Serious Health Issues'),
(1743, 10, 'Minor Health Issues'),
(1739, 10, 'Prefer not to say'),
(1740, 10, 'Major Physical Disability'),
(1741, 10, 'Minor Physical Disability'),
(1742, 10, 'Serious Health Issues'),
(1743, 10, 'Minor Health Issues'),
(1744, 10, 'Normal'),
(1745, 9, 'Other'),
(1746, 9, 'Long Beard'),
(1747, 9, 'Medium Beard'),
(1748, 9, 'Short Beard'),
(1749, 9, 'Goatee'),
(1750, 9, 'Mustache'),
(1751, 9, 'Sideburns'),
(1750, 9, 'Mustache'),
(1751, 9, 'Sideburns'),
(1752, 9, 'Clean Shaven'),
(1753, 8, 'Very attractive'),
(1754, 8, 'Attractive'),
(1755, 8, 'Average'),
(1757, 8, 'Below average'),
(1758, 7, 'Large and Lovely'),
(1759, 7, 'Full Figured'),
(1760, 7, 'Few Extra Pounds'),
(1761, 7, 'Average'),
(1762, 7, 'Athletic'),
(1763, 7, 'Slim'),
(1764, 7, 'Petite'),
(1765, 6, '220 kg (485 lb)'),
(1766, 6, '219 kg (483 lb)'),
(1767, 6, '218 kg (481 lb)'),
(1768, 6, '217 kg (478 lb)'),
(1769, 6, '216 kg (476 lb)'),
(1770, 6, '215 kg (474 lb)'),
(1771, 6, '214 kg (472 lb)'),
(1772, 6, '213 kg (470 lb)'),
(1773, 6, '212 kg (467 lb)'),
(1774, 6, '211 kg (465 lb)'),
(1775, 6, '210 kg (463 lb)'),
(1776, 6, '209 kg (461 lb)'),
(1777, 6, '208 kg (459 lb)'),
(1778, 6, '207 kg (456 lb)'),
(1779, 6, '206 kg (454 lb)'),
(1781, 6, '204 kg (450 lb)'),
(1782, 6, '203 kg (448 lb)'),
(1783, 6, '202 kg (445 lb)'),
(1784, 6, '201 kg (443 lb)'),
(1785, 6, '200 kg (441 lb)'),
(1786, 6, '199 kg (439 lb)'),
(1787, 6, '198 kg (437 lb)'),
(1788, 6, '197 kg (434 lb)'),
(1789, 6, '196 kg (432 lb)'),
(1790, 6, '195 kg (430 lb)'),
(1791, 6, '194 kg (428 lb)'),
(1792, 6, '193 kg (425 lb)'),
(1793, 6, '192 kg (423 lb)'),
(1794, 6, '191 kg (421 lb)'),
(1795, 6, '190 kg (419 lb)'),
(1796, 6, '189 kg (417 lb)'),
(1797, 6, '188 kg (414 lb)'),
(1798, 6, '187 kg (412 lb)'),
(1799, 6, '186 kg (410 lb)'),
(1800, 6, '185 kg (408 lb)'),
(1801, 6, '184 kg (406 lb)'),
(1802, 6, '183 kg (403 lb)'),
(1803, 6, '182 kg (401 lb)'),
(1804, 6, '181 kg (399 lb)'),
(1805, 6, '180 kg (397 lb)'),
(1806, 6, '179 kg (395 lb)'),
(1807, 6, '178 kg (392 lb)'),
(1808, 6, '177 kg (390 lb)'),
(1809, 6, '176 kg (388 lb)'),
(1810, 6, '175 kg (386 lb)'),
(1811, 6, '174 kg (384 lb)'),
(1812, 6, '173 kg (381 lb)'),
(1813, 6, '172 kg (379 lb)'),
(1814, 6, '171 kg (377 lb)'),
(1815, 6, '170 kg (375 lb)'),
(1816, 6, '169 kg (373 lb)'),
(1817, 6, '168 kg (370 lb)'),
(1818, 6, '167 kg (368 lb)'),
(1819, 6, '166 kg (366 lb)'),
(1820, 6, '165 kg (364 lb)'),
(1821, 6, '164 kg (362 lb)'),
(1822, 6, '163 kg (359 lb)'),
(1823, 6, '162 kg (357 lb)'),
(1824, 6, '161 kg (355 lb)'),
(1825, 6, '160 kg (353 lb)'),
(1826, 6, '159 kg (351 lb)'),
(1827, 6, '158 kg (348 lb)'),
(1828, 6, '157 kg (346 lb)'),
(1829, 6, '156 kg (344 lb)'),
(1830, 6, '155 kg (342 lb)'),
(1831, 6, '154 kg (340 lb)'),
(1832, 6, '153 kg (337 lb)'),
(1833, 6, '152 kg (335 lb)'),
(1834, 6, '151 kg (333 lb)'),
(1835, 6, '150 kg (331 lb)'),
(1834, 6, '149 kg (328 lb)'),
(1835, 6, '148 kg (326 lb)'),
(1836, 6, '147 kg (324 lb)'),
(1837, 6, '146 kg (322 lb)'),
(1838, 6, '145 kg (320 lb)'),
(1839, 6, '144 kg (317 lb)'),
(1840, 6, '143 kg (315 lb)'),
(1841, 6, '142 kg (313 lb)'),
(1842, 6, '141 kg (311 lb)'),
(1843, 6, '140 kg (309 lb)'),
(1844, 6, '139 kg (306 lb)'),
(1845, 6, '138 kg (304 lb)'),
(1846, 6, '137 kg (302 lb)'),
(1847, 6, '136 kg (300 lb)'),
(1848, 6, '135 kg (298 lb)'),
(1849, 6, '134 kg (295 lb)'),
(1850, 6, '133 kg (293 lb)'),
(1851, 6, '132 kg (291 lb)'),
(1852, 6, '131 kg (289 lb)'),
(1853, 6, '130 kg (287 lb)'),
(1854, 6, '129 kg (284 lb)'),
(1855, 6, '128 kg (282 lb)'),
(1856, 6, '127 kg (280 lb)'),
(1857, 6, '126 kg (278 lb)'),
(1858, 6, '125 kg (276 lb)'),
(1859, 6, '124 kg (273 lb)'),
(1860, 6, '123 kg (271 lb)'),
(1861, 6, '122 kg (269 lb)'),
(1862, 6, '121 kg (267 lb)'),
(1863, 6, '120 kg (265 lb)'),
(1864, 6, '119 kg (262 lb)'),
(1865, 6, '118 kg (260 lb)'),
(1866, 6, '117 kg (258 lb)'),
(1867, 6, '116 kg (256 lb)'),
(1868, 6, '115 kg (254 lb)'),
(1869, 6, '114 kg (251 lb)'),
(1870, 6, '113 kg (249 lb)'),
(1871, 6, '112 kg (247 lb)'),
(1872, 6, '111 kg (245 lb)'),
(1873, 6, '110 kg (243 lb)'),
(1874, 6, '109 kg (240 lb)'),
(1875, 6, '108 kg (238 lb)'),
(1876, 6, '107 kg (236 lb)'),
(1877, 6, '106 kg (234 lb)'),
(1878, 6, '105 kg (231 lb)'),
(1879, 6, '104 kg (229 lb)'),
(1880, 6, '103 kg (227 lb)'),
(1881, 6, '102 kg (225 lb)'),
(1882, 6, '101 kg (223 lb)'),
(1883, 6, '100 kg (220 lb)'),
(1884, 6, '99 kg (218 lb)'),
(1885, 6, '98 kg (216 lb)'),
(1886, 6, '97 kg (214 lb)'),
(1887, 6, '96 kg (212 lb)'),
(1888, 6, '95 kg (209 lb)'),
(1889, 6, '94 kg (207 lb)'),
(1890, 6, '93 kg (205 lb)'),
(1891, 6, '92 kg (203 lb)'),
(1892, 6, '91 kg (201 lb)'),
(1893, 6, '90 kg (198 lb)'),
(1894, 6, '89 kg (196 lb)'),
(1895, 6, '88 kg (194 lb)'),
(1896, 6, '87 kg (192 lb)'),
(1897, 6, '86 kg (190 lb)'),
(1898, 6, '85 kg (187 lb)'),
(1899, 6, '84 kg (185 lb)'),
(1900, 6, '83 kg (183 lb)'),
(1901, 6, '82 kg (181 lb)'),
(1902, 6, '81 kg (179 lb)'),
(1903, 6, '80 kg (176 lb)'),
(1904, 6, '79 kg (174 lb)'),
(1905, 6, '78 kg (172 lb)'),
(1906, 6, '77 kg (170 lb)'),
(1907, 6, '76 kg (168 lb)'),
(1908, 6, '75 kg (165 lb)'),
(1909, 6, '74 kg (163 lb)'),
(1910, 6, '73 kg (161 lb)'),
(1911, 6, '72 kg (159 lb)'),
(1912, 6, '71 kg (157 lb)'),
(1913, 6, '70 kg (154 lb)'),
(1914, 6, '69 kg (152 lb)'),
(1915, 6, '68 kg (150 lb)'),
(1916, 6, '67 kg (148 lb)'),
(1917, 6, '66 kg (146 lb)'),
(1918, 6, '65 kg (143 lb)'),
(1919, 6, '64 kg (141 lb)'),
(1920, 6, '63 kg (139 lb)'),
(1921, 6, '62 kg (137 lb)'),
(1922, 6, '61 kg (134 lb)'),
(1922, 6, '60 kg (132 lb)'),
(1923, 6, '59 kg (130 lb)'),
(1924, 6, '58 kg (128 lb)'),
(1925, 6, '57 kg (126 lb)'),
(1926, 6, '56 kg (123 lb)'),
(1927, 6, '55 kg (121 lb)'),
(1928, 6, '54 kg (119 lb)'),
(1929, 6, '53 kg (117 lb)'),
(1930, 6, '52 kg (115 lb)'),
(1931, 6, '51 kg (112 lb)'),
(1932, 6, '50 kg (110 lb)'),
(1933, 6, '49 kg (108 lb)'),
(1934, 6, '48 kg (106 lb)'),
(1935, 6, '47 kg (104 lb)'),
(1936, 6, '46 kg (101 lb)'),
(1937, 6, '45 kg (99 lb)'),
(1938, 6, '44 kg (97 lb)'),
(1939, 6, '43 kg (95 lb)'),
(1940, 6, '42 kg (93 lb)'),
(1941, 6, '41 kg (90 lb)'),
(1942, 6, '40 kg (88 lb)'),
(1943, 5, '7.2 (219 cm)'),
(1944, 5, '7.1 (216 cm)'),
(1945, 5, '7 (214 cm)'),
(1946, 5, '6.11 (211 cm)'),
(1947, 5, '6.10 (209 cm)'),
(1948, 5, '6.9 (206 cm)'),
(1949, 5, '6.8 (204 cm)'),
(1950, 5, '6.7 (201 cm)'),
(1951, 5, '6.6 (199 cm)'),
(1952, 5, '6.5 (196 cm)'),
(1953, 5, '6.4 (194 cm)'),
(1954, 5, '6.3 (191 cm)'),
(1955, 5, '6.2 (188 cm)'),
(1956, 5, '6.1 (186 cm)'),
(1957, 5, '6 (183 cm)'),
(1958, 5, '5.11 (181 cm)'),
(1959, 5, '5.10 (178 cm)'),
(1960, 5, '5.9 (176 cm)'),
(1961, 5, '5.8 (173 cm)'),
(1962, 5, '5.7 (171 cm)'),
(1963, 5, '5.6 (168 cm)'),
(1964, 5, '5.5 (166 cm)'),
(1965, 5, '5.4 (163 cm)'),
(1966, 5, '5.3 (161 cm)'),
(1967, 5, '5.2 (158 cm)'),
(1968, 5, '5.1 (155 cm)'),
(1969, 5, '5 (153 cm)'),
(1970, 5, '4.11 (150 cm)'),
(1971, 5, '4.10 (148 cm)'),
(1972, 5, '4.9 (145 cm)'),
(1973, 5, '4.8 (143 cm)'),
(1974, 5, '4.7 (140 cm)'),
(1975, 4, 'Prefer not to say'),
(1976, 4, 'Other'),
(1977, 4, 'None'),
(1978, 4, 'Glasses'),
(1979, 4, 'Contacts'),
(1980, 3, 'Other'),
(1981, 3, 'Hazel'),
(1982, 3, 'Grey'),
(1983, 3, 'Green'),
(1984, 3, 'Brown'),
(1980, 3, 'Other'),
(1981, 3, 'Hazel'),
(1982, 3, 'Grey'),
(1983, 3, 'Green'),
(1984, 3, 'Brown'),
(1985, 3, 'Blue'),
(1986, 3, 'Black'),
(1987, 2, 'Prefer not to say'),
(1988, 2, 'Other'),
(1989, 2, 'Curly'),
(1990, 2, 'Wavy'),
(1991, 2, 'Straight'),
(1992, 1, 'Prefer not to say'),
(1993, 1, 'Other'),
(1994, 1, 'Changes frequently'),
(1995, 1, 'Red'),
(1996, 1, 'Light Brown'),
(1997, 1, 'Grey / White'),
(1998, 1, 'Brown'),
(1999, 1, 'Blonde'),
(2000, 1, 'Black'),
(2001, 1, 'Bald / Shaved');

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

--
-- Table structure for table `session`
--

CREATE TABLE IF NOT EXISTS `session` (
  `sessionid` varchar(255) COLLATE utf8_bin NOT NULL,
  `uid` int(11) NOT NULL,
  `t` int(11) NOT NULL,
  `ip` varchar(255) COLLATE utf8_bin NOT NULL,
  `ip2` varchar(255) COLLATE utf8_bin NOT NULL,
  `ais` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ais`),
  FULLTEXT KEY `sessionid` (`sessionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

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