-- http://www.phpmyadmin.net
--




--
-- Database: `whitelakemobile`
--

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

--
-- Table structure for table `mx_admin_menu`
--

CREATE TABLE `mx_admin_menu` (
  `adminMenuID` int(10) unsigned NOT NULL auto_increment,
  `menuType` tinyint(1) NOT NULL default '0',
  `menuTitle` varchar(100) collate utf8_unicode_ci NOT NULL,
  `seoUri` varchar(100) collate utf8_unicode_ci NOT NULL default '#',
  `xOrder` int(3) NOT NULL default '0',
  `parentID` int(11) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`adminMenuID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=50 ;

--
-- Dumping data for table `mx_admin_menu`
--

INSERT INTO `mx_admin_menu` VALUES(23, 0, 'Menu', 'menu', 0, 0, 1);
INSERT INTO `mx_admin_menu` VALUES(24, 0, 'Page', 'page', 1, 0, 1);
INSERT INTO `mx_admin_menu` VALUES(25, 0, 'Post', 'post', 1, 0, 1);
INSERT INTO `mx_admin_menu` VALUES(42, 0, 'Survey Name', 'survey-title', 0, 0, 1);
INSERT INTO `mx_admin_menu` VALUES(44, 0, 'Survey Questions', 'survey', 0, 0, 1);
INSERT INTO `mx_admin_menu` VALUES(46, 0, 'Survey participants', 'survey-participants', 0, 0, 1);
INSERT INTO `mx_admin_menu` VALUES(48, 0, 'Suggestions', 'suggestions', 0, 0, 1);
INSERT INTO `mx_admin_menu` VALUES(49, 0, 'Survey stats', 'survey-stats', 0, 0, 1);

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

--
-- Table structure for table `mx_admin_role`
--

CREATE TABLE `mx_admin_role` (
  `roleAID` int(10) unsigned NOT NULL auto_increment,
  `roleName` varchar(255) collate utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`roleAID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `mx_admin_role`
--

INSERT INTO `mx_admin_role` VALUES(1, 'Admin', 1);
INSERT INTO `mx_admin_role` VALUES(2, 'Author', 1);
INSERT INTO `mx_admin_role` VALUES(3, 'User', 1);

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

--
-- Table structure for table `mx_admin_setting`
--

CREATE TABLE `mx_admin_setting` (
  `settingID` int(11) NOT NULL auto_increment,
  `settingName` varchar(100) NOT NULL,
  `settingVal` varchar(255) NOT NULL,
  `settingDefault` varchar(255) NOT NULL,
  PRIMARY KEY  (`settingID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `mx_admin_setting`
--

INSERT INTO `mx_admin_setting` VALUES(1, 'Logo', 'cms/images/logo.png', 'cms/images/logo.png');
INSERT INTO `mx_admin_setting` VALUES(2, 'Favicon', 'cms/images/favicon.png', 'cms/images/favicon.png');
INSERT INTO `mx_admin_setting` VALUES(3, 'Theme', 'other', 'other');

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

--
-- Table structure for table `mx_admin_user_access`
--

CREATE TABLE `mx_admin_user_access` (
  `userAccessID` int(11) NOT NULL auto_increment,
  `roleAID` int(11) NOT NULL,
  `adminMenuID` int(11) NOT NULL,
  `accessType` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`userAccessID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=105 ;

--
-- Dumping data for table `mx_admin_user_access`
--

INSERT INTO `mx_admin_user_access` VALUES(104, 2, 49, '["view"]');
INSERT INTO `mx_admin_user_access` VALUES(103, 2, 48, '["view","delete","trash","restore"]');
INSERT INTO `mx_admin_user_access` VALUES(99, 1, 49, '["view"]');
INSERT INTO `mx_admin_user_access` VALUES(102, 2, 46, '["view","delete","trash","restore"]');
INSERT INTO `mx_admin_user_access` VALUES(101, 2, 44, '["view","add","edit","delete","trash","restore"]');
INSERT INTO `mx_admin_user_access` VALUES(98, 1, 48, '["view","delete","trash","restore"]');
INSERT INTO `mx_admin_user_access` VALUES(97, 1, 46, '["view","delete","trash","restore"]');
INSERT INTO `mx_admin_user_access` VALUES(100, 2, 42, '["view","add","edit","delete","trash","restore"]');
INSERT INTO `mx_admin_user_access` VALUES(96, 1, 44, '["view","add","edit","delete","trash","restore"]');
INSERT INTO `mx_admin_user_access` VALUES(95, 1, 42, '["view","add","edit","delete","trash","restore"]');
INSERT INTO `mx_admin_user_access` VALUES(94, 1, 23, '["view","add","edit","delete","trash","restore"]');

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

--
-- Table structure for table `mx_category`
--

CREATE TABLE `mx_category` (
  `categoryID` int(11) NOT NULL auto_increment,
  `parentID` int(11) NOT NULL,
  `categoryTitle` varchar(255) NOT NULL,
  `imageName` varchar(255) NOT NULL,
  `seoUri` varchar(255) NOT NULL,
  `templateFile` varchar(100) NOT NULL,
  `dateAdded` datetime NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`categoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `mx_category`
--


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

--
-- Table structure for table `mx_menu`
--

CREATE TABLE `mx_menu` (
  `menuID` int(11) NOT NULL auto_increment,
  `parentID` int(11) NOT NULL,
  `menuTitle` varchar(255) NOT NULL,
  `synopsis` text NOT NULL,
  `metaKeyword` text NOT NULL,
  `metaDesc` text NOT NULL,
  `menuType` varchar(100) NOT NULL,
  `seoUri` varchar(255) NOT NULL,
  `menuClass` varchar(50) NOT NULL,
  `xOrder` int(2) NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`menuID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `mx_menu`
--


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

--
-- Table structure for table `mx_page`
--

CREATE TABLE `mx_page` (
  `pageID` int(11) NOT NULL auto_increment,
  `seoUri` varchar(255) NOT NULL,
  `pageTitle` varchar(255) NOT NULL,
  `synopsis` text NOT NULL,
  `pageContent` text NOT NULL,
  `pageImage` varchar(100) NOT NULL,
  `templateFile` varchar(100) NOT NULL,
  `dateAdded` datetime NOT NULL,
  `dateModified` datetime NOT NULL default '0000-00-00 00:00:00',
  `modifiedBy` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`pageID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `mx_page`
--


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

--
-- Table structure for table `mx_post`
--

CREATE TABLE `mx_post` (
  `postID` int(11) NOT NULL auto_increment,
  `categoryID` int(11) NOT NULL,
  `albumID` int(11) NOT NULL,
  `postTitle` varchar(255) NOT NULL,
  `seoUri` varchar(255) NOT NULL,
  `synopsis` text NOT NULL,
  `postDesc` text NOT NULL,
  `thumbnails` varchar(100) NOT NULL,
  `imageName` varchar(100) NOT NULL,
  `metaTitle` text NOT NULL,
  `metaDesc` text NOT NULL,
  `metaKeyword` text NOT NULL,
  `featuredPost` tinyint(1) NOT NULL default '0',
  `dateAdded` datetime NOT NULL,
  `dateModified` datetime NOT NULL,
  `datePublish` datetime NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`postID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `mx_post`
--


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

--
-- Table structure for table `mx_survey_data`
--

CREATE TABLE `mx_survey_data` (
  `surveyDataID` int(11) NOT NULL auto_increment,
  `surveyUserID` int(10) NOT NULL,
  `questionID` int(10) NOT NULL,
  `optionID` int(10) NOT NULL,
  PRIMARY KEY  (`surveyDataID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;

--
-- Dumping data for table `mx_survey_data`
--

INSERT INTO `mx_survey_data` VALUES(1, 1, 1, 3);
INSERT INTO `mx_survey_data` VALUES(2, 1, 3, 10);
INSERT INTO `mx_survey_data` VALUES(3, 2, 1, 2);
INSERT INTO `mx_survey_data` VALUES(4, 2, 3, 10);
INSERT INTO `mx_survey_data` VALUES(5, 3, 1, 2);
INSERT INTO `mx_survey_data` VALUES(6, 3, 3, 10);
INSERT INTO `mx_survey_data` VALUES(7, 4, 1, 1);
INSERT INTO `mx_survey_data` VALUES(8, 4, 3, 10);
INSERT INTO `mx_survey_data` VALUES(9, 5, 1, 2);
INSERT INTO `mx_survey_data` VALUES(10, 5, 3, 10);
INSERT INTO `mx_survey_data` VALUES(11, 6, 1, 2);
INSERT INTO `mx_survey_data` VALUES(12, 6, 3, 10);
INSERT INTO `mx_survey_data` VALUES(13, 7, 1, 3);
INSERT INTO `mx_survey_data` VALUES(14, 7, 3, 23);
INSERT INTO `mx_survey_data` VALUES(15, 7, 6, 25);
INSERT INTO `mx_survey_data` VALUES(16, 7, 7, 27);
INSERT INTO `mx_survey_data` VALUES(17, 7, 8, 31);
INSERT INTO `mx_survey_data` VALUES(18, 8, 1, 1);
INSERT INTO `mx_survey_data` VALUES(19, 8, 3, 10);
INSERT INTO `mx_survey_data` VALUES(20, 8, 6, 25);
INSERT INTO `mx_survey_data` VALUES(21, 8, 7, 27);
INSERT INTO `mx_survey_data` VALUES(22, 8, 8, 29);
INSERT INTO `mx_survey_data` VALUES(23, 9, 1, 5);
INSERT INTO `mx_survey_data` VALUES(24, 9, 3, 10);
INSERT INTO `mx_survey_data` VALUES(25, 9, 6, 24);
INSERT INTO `mx_survey_data` VALUES(26, 9, 7, 26);
INSERT INTO `mx_survey_data` VALUES(27, 9, 8, 32);
INSERT INTO `mx_survey_data` VALUES(28, 10, 9, 33);
INSERT INTO `mx_survey_data` VALUES(29, 10, 10, 38);
INSERT INTO `mx_survey_data` VALUES(30, 10, 11, 43);
INSERT INTO `mx_survey_data` VALUES(31, 10, 12, 48);
INSERT INTO `mx_survey_data` VALUES(32, 11, 10, 39);
INSERT INTO `mx_survey_data` VALUES(33, 11, 11, 42);
INSERT INTO `mx_survey_data` VALUES(34, 11, 9, 35);
INSERT INTO `mx_survey_data` VALUES(35, 11, 12, 45);
INSERT INTO `mx_survey_data` VALUES(36, 12, 9, 34);
INSERT INTO `mx_survey_data` VALUES(37, 12, 10, 40);
INSERT INTO `mx_survey_data` VALUES(38, 12, 11, 44);
INSERT INTO `mx_survey_data` VALUES(39, 12, 12, 45);
INSERT INTO `mx_survey_data` VALUES(40, 13, 9, 33);
INSERT INTO `mx_survey_data` VALUES(41, 13, 10, 38);
INSERT INTO `mx_survey_data` VALUES(42, 13, 11, 44);
INSERT INTO `mx_survey_data` VALUES(43, 13, 12, 46);
INSERT INTO `mx_survey_data` VALUES(44, 14, 13, 49);
INSERT INTO `mx_survey_data` VALUES(45, 14, 14, 54);
INSERT INTO `mx_survey_data` VALUES(46, 15, 13, 50);
INSERT INTO `mx_survey_data` VALUES(47, 15, 14, 53);
INSERT INTO `mx_survey_data` VALUES(48, 16, 13, 51);
INSERT INTO `mx_survey_data` VALUES(49, 16, 14, 55);
INSERT INTO `mx_survey_data` VALUES(50, 17, 13, 50);
INSERT INTO `mx_survey_data` VALUES(51, 17, 14, 53);
INSERT INTO `mx_survey_data` VALUES(52, 18, 13, 52);
INSERT INTO `mx_survey_data` VALUES(53, 18, 14, 55);
INSERT INTO `mx_survey_data` VALUES(54, 19, 13, 50);
INSERT INTO `mx_survey_data` VALUES(55, 19, 14, 54);
INSERT INTO `mx_survey_data` VALUES(56, 20, 9, 33);
INSERT INTO `mx_survey_data` VALUES(57, 20, 10, 37);
INSERT INTO `mx_survey_data` VALUES(58, 20, 11, 41);
INSERT INTO `mx_survey_data` VALUES(59, 20, 13, 49);
INSERT INTO `mx_survey_data` VALUES(60, 20, 14, 53);
INSERT INTO `mx_survey_data` VALUES(61, 21, 14, 54);
INSERT INTO `mx_survey_data` VALUES(62, 21, 13, 51);
INSERT INTO `mx_survey_data` VALUES(63, 22, 1, 1);
INSERT INTO `mx_survey_data` VALUES(64, 22, 3, 10);
INSERT INTO `mx_survey_data` VALUES(65, 22, 6, 24);
INSERT INTO `mx_survey_data` VALUES(66, 22, 7, 26);
INSERT INTO `mx_survey_data` VALUES(67, 22, 8, 32);
INSERT INTO `mx_survey_data` VALUES(68, 23, 1, 1);
INSERT INTO `mx_survey_data` VALUES(69, 23, 3, 10);
INSERT INTO `mx_survey_data` VALUES(70, 23, 6, 25);
INSERT INTO `mx_survey_data` VALUES(71, 23, 7, 27);
INSERT INTO `mx_survey_data` VALUES(72, 23, 8, 29);

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

--
-- Table structure for table `mx_survey_option`
--

CREATE TABLE `mx_survey_option` (
  `optionID` int(11) NOT NULL auto_increment,
  `questionID` int(10) NOT NULL,
  `surveyOption` text NOT NULL,
  `dateAdded` datetime NOT NULL,
  PRIMARY KEY  (`optionID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;

--
-- Dumping data for table `mx_survey_option`
--

INSERT INTO `mx_survey_option` VALUES(1, 1, 'Good', '2012-06-27 19:46:29');
INSERT INTO `mx_survey_option` VALUES(2, 1, 'Average', '2012-06-27 19:46:29');
INSERT INTO `mx_survey_option` VALUES(3, 1, 'Poor', '2012-06-27 19:46:29');
INSERT INTO `mx_survey_option` VALUES(5, 1, 'Very Good', '2012-06-28 12:14:36');
INSERT INTO `mx_survey_option` VALUES(10, 3, 'Outstanding', '2012-06-28 12:40:37');
INSERT INTO `mx_survey_option` VALUES(15, 4, 'Banana', '2012-06-28 19:04:20');
INSERT INTO `mx_survey_option` VALUES(16, 4, 'Mango', '2012-06-28 19:04:20');
INSERT INTO `mx_survey_option` VALUES(17, 4, 'Apple', '2012-06-28 19:04:20');
INSERT INTO `mx_survey_option` VALUES(21, 5, 'Suzuki', '2012-07-01 14:41:49');
INSERT INTO `mx_survey_option` VALUES(20, 5, 'Honda', '2012-07-01 14:41:28');
INSERT INTO `mx_survey_option` VALUES(22, 5, 'R!', '2012-07-01 14:42:03');
INSERT INTO `mx_survey_option` VALUES(23, 3, 'Average', '2012-07-04 09:07:47');
INSERT INTO `mx_survey_option` VALUES(24, 6, 'Yes', '2012-07-04 09:09:20');
INSERT INTO `mx_survey_option` VALUES(25, 6, 'No', '2012-07-04 09:09:31');
INSERT INTO `mx_survey_option` VALUES(26, 7, 'Best in the world !', '2012-07-07 07:05:53');
INSERT INTO `mx_survey_option` VALUES(27, 7, 'Cats me out !', '2012-07-07 07:06:16');
INSERT INTO `mx_survey_option` VALUES(28, 8, '1', '2012-07-07 08:48:57');
INSERT INTO `mx_survey_option` VALUES(29, 8, '2', '2012-07-07 08:49:05');
INSERT INTO `mx_survey_option` VALUES(30, 8, '3', '2012-07-07 08:49:14');
INSERT INTO `mx_survey_option` VALUES(31, 8, '4', '2012-07-07 08:49:23');
INSERT INTO `mx_survey_option` VALUES(32, 8, '5', '2012-07-07 08:49:33');
INSERT INTO `mx_survey_option` VALUES(33, 9, '1', '2012-07-10 11:05:39');
INSERT INTO `mx_survey_option` VALUES(34, 9, '2', '2012-07-10 11:05:39');
INSERT INTO `mx_survey_option` VALUES(35, 9, '3', '2012-07-10 11:05:39');
INSERT INTO `mx_survey_option` VALUES(36, 9, '4', '2012-07-10 11:05:39');
INSERT INTO `mx_survey_option` VALUES(37, 10, '1', '2012-07-10 11:06:11');
INSERT INTO `mx_survey_option` VALUES(38, 10, '2', '2012-07-10 11:06:11');
INSERT INTO `mx_survey_option` VALUES(39, 10, '3', '2012-07-10 11:06:11');
INSERT INTO `mx_survey_option` VALUES(40, 10, '4', '2012-07-10 11:06:11');
INSERT INTO `mx_survey_option` VALUES(41, 11, '1', '2012-07-10 11:06:37');
INSERT INTO `mx_survey_option` VALUES(42, 11, '2', '2012-07-10 11:06:37');
INSERT INTO `mx_survey_option` VALUES(43, 11, '3', '2012-07-10 11:06:37');
INSERT INTO `mx_survey_option` VALUES(44, 11, '4', '2012-07-10 11:06:37');
INSERT INTO `mx_survey_option` VALUES(45, 12, '1', '2012-07-10 11:07:07');
INSERT INTO `mx_survey_option` VALUES(46, 12, '2', '2012-07-10 11:07:07');
INSERT INTO `mx_survey_option` VALUES(47, 12, '3', '2012-07-10 11:07:07');
INSERT INTO `mx_survey_option` VALUES(48, 12, '4', '2012-07-10 11:07:07');
INSERT INTO `mx_survey_option` VALUES(49, 13, '1', '2012-07-10 11:33:41');
INSERT INTO `mx_survey_option` VALUES(50, 13, '2', '2012-07-10 11:33:41');
INSERT INTO `mx_survey_option` VALUES(51, 13, '3', '2012-07-10 11:33:41');
INSERT INTO `mx_survey_option` VALUES(52, 13, '4', '2012-07-10 11:33:41');
INSERT INTO `mx_survey_option` VALUES(53, 14, '1', '2012-07-10 11:33:58');
INSERT INTO `mx_survey_option` VALUES(54, 14, '2', '2012-07-10 11:33:58');
INSERT INTO `mx_survey_option` VALUES(55, 14, '3', '2012-07-10 11:33:58');

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

--
-- Table structure for table `mx_survey_question`
--

CREATE TABLE `mx_survey_question` (
  `questionID` int(11) NOT NULL auto_increment,
  `titleID` int(10) NOT NULL,
  `question` text NOT NULL,
  `dateAdded` datetime NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`questionID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `mx_survey_question`
--

INSERT INTO `mx_survey_question` VALUES(1, 1, 'How is our Service.', '2012-06-27 19:46:29', 1);
INSERT INTO `mx_survey_question` VALUES(3, 1, 'Please rate our service.', '2012-06-28 12:29:22', 1);
INSERT INTO `mx_survey_question` VALUES(4, 2, 'Your Favourite Fruit?', '2012-06-28 19:04:20', 1);
INSERT INTO `mx_survey_question` VALUES(5, 3, 'Your Fav brand.', '2012-07-01 14:41:28', 1);
INSERT INTO `mx_survey_question` VALUES(6, 1, 'Will you come back again ??', '2012-07-04 09:09:20', 1);
INSERT INTO `mx_survey_question` VALUES(7, 1, 'How do you like Top This ?', '2012-07-07 07:05:53', 1);
INSERT INTO `mx_survey_question` VALUES(8, 1, 'Rate our service on a scale of 1-5 ?', '2012-07-07 08:48:57', 1);
INSERT INTO `mx_survey_question` VALUES(9, 4, 'One?', '2012-07-10 11:05:39', 1);
INSERT INTO `mx_survey_question` VALUES(10, 4, 'Two?', '2012-07-10 11:06:11', 1);
INSERT INTO `mx_survey_question` VALUES(11, 4, 'Three?', '2012-07-10 11:06:37', 1);
INSERT INTO `mx_survey_question` VALUES(12, 4, 'Four?eeeeeeeee eeeeeee eeeeeeeeee eeeeeee eeeeee eeeeee eeeeeee ee eeeeeee eeee ee eeeeeeeee eeeeeeee eeeeeeeeeeeeeee eeeeeeeeee eeeeee?', '2012-07-10 11:07:07', 1);
INSERT INTO `mx_survey_question` VALUES(13, 5, 'one?', '2012-07-10 11:33:41', 1);
INSERT INTO `mx_survey_question` VALUES(14, 5, 'two', '2012-07-10 11:33:58', 1);

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

--
-- Table structure for table `mx_survey_title`
--

CREATE TABLE `mx_survey_title` (
  `titleID` int(11) NOT NULL auto_increment,
  `userID` int(10) NOT NULL,
  `title` varchar(255) NOT NULL,
  `synopsis` varchar(255) NOT NULL,
  `dateAdded` datetime NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`titleID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `mx_survey_title`
--

INSERT INTO `mx_survey_title` VALUES(1, 1, 'My test Survey', 'My test Survey1 ', '2012-06-27 19:35:01', 1);
INSERT INTO `mx_survey_title` VALUES(2, 13, 'Naim first survey', 'Test Synopsis ', '2012-06-28 18:29:06', 1);
INSERT INTO `mx_survey_title` VALUES(3, 1, 'test Survey 1', '', '2012-07-01 14:40:41', 1);
INSERT INTO `mx_survey_title` VALUES(4, 1, 'TEST SURVEY MAX', 'TEST SURVEY MAX', '2012-07-10 11:01:22', 1);
INSERT INTO `mx_survey_title` VALUES(5, 13, 'Author Survey test', 'Author Survey test', '2012-07-10 11:33:01', 1);
INSERT INTO `mx_survey_title` VALUES(6, 1, 'Test Survey WHS', 'Test Survey', '2012-07-14 08:11:57', 1);

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

--
-- Table structure for table `mx_survey_user`
--

CREATE TABLE `mx_survey_user` (
  `surveyUserID` int(11) NOT NULL auto_increment,
  `surveyID` int(10) NOT NULL,
  `ipAddress` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `dateAdded` datetime NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`surveyUserID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `mx_survey_user`
--

INSERT INTO `mx_survey_user` VALUES(1, 1, '192.168.1.14', 'hjhjhk', 'nn@ff.vom', 'dasdy', '2012-07-01 11:24:46', 1);
INSERT INTO `mx_survey_user` VALUES(2, 1, '49.248.52.234', 'pratik', 'pratik@maxdigi.com', 'Hiii', '2012-07-01 13:26:56', 1);
INSERT INTO `mx_survey_user` VALUES(3, 1, '49.248.52.234', 'wsumit', 'sumit@gmail.com', 'hey', '2012-07-01 14:47:10', 1);
INSERT INTO `mx_survey_user` VALUES(4, 1, '166.147.102.234', 'Nausher', 'Rehan25@hotmail.com', 'Test', '2012-07-03 15:47:49', 1);
INSERT INTO `mx_survey_user` VALUES(5, 1, '71.175.124.179', 'Nausher', 'Rehan25@hotmail.com', 'This is a test', '2012-07-03 17:19:26', 1);
INSERT INTO `mx_survey_user` VALUES(6, 1, '71.175.124.179', 'Jim test', 'Test@test.com', 'This is a test', '2012-07-04 09:04:19', 1);
INSERT INTO `mx_survey_user` VALUES(7, 1, '71.175.124.179', 'Nausher', 'Rehan25@hotmail.con', 'This is a test !!', '2012-07-07 08:51:16', 1);
INSERT INTO `mx_survey_user` VALUES(8, 1, '69.253.45.150', 'Nausher', 'Tehan24@hotmail.com', 'This is a test !', '2012-07-09 21:21:05', 1);
INSERT INTO `mx_survey_user` VALUES(9, 1, '49.248.58.190', 'Prince', 'max@max.com', 'HEllo', '2012-07-10 10:58:28', 1);
INSERT INTO `mx_survey_user` VALUES(10, 4, '49.248.58.190', '1', '1@1.com', '1', '2012-07-10 11:08:04', 1);
INSERT INTO `mx_survey_user` VALUES(11, 4, '49.248.58.190', '1', '1@1.b', '12', '2012-07-10 11:08:54', 1);
INSERT INTO `mx_survey_user` VALUES(12, 4, '49.248.58.190', 'a', 'fsad@dgsa.ca', 'GASFDGS', '2012-07-10 11:09:34', 1);
INSERT INTO `mx_survey_user` VALUES(13, 4, '49.248.58.190', 'pratij mob', 'mom@mob.cim', 'Mob testing', '2012-07-10 11:27:41', 1);
INSERT INTO `mx_survey_user` VALUES(14, 5, '49.248.58.190', 'Pratik', 'pratik@pratik.com', 'Uthor servey test', '2012-07-10 11:34:35', 1);
INSERT INTO `mx_survey_user` VALUES(15, 5, '49.248.58.190', 'tr', '1@1.com', '1@1.com', '2012-07-10 11:40:11', 1);
INSERT INTO `mx_survey_user` VALUES(16, 5, '49.248.58.190', '1@1.com', '1@1.com', '1@1.com', '2012-07-10 11:40:23', 1);
INSERT INTO `mx_survey_user` VALUES(17, 5, '49.248.58.190', '1@1.com', '1@1.com', '1@1.com', '2012-07-10 11:40:35', 1);
INSERT INTO `mx_survey_user` VALUES(18, 5, '49.248.58.190', '1@1.com', '1@1.com', '1@1.com', '2012-07-10 11:40:45', 1);
INSERT INTO `mx_survey_user` VALUES(19, 5, '49.248.58.190', '1@1.com', '1@1.com', '1@1.com', '2012-07-10 11:41:07', 1);
INSERT INTO `mx_survey_user` VALUES(20, 5, '49.248.58.190', '1@1.com', '1@1.com', '1@1.com', '2012-07-10 11:41:37', 1);
INSERT INTO `mx_survey_user` VALUES(21, 5, '49.248.58.190', '1@1.com', '1@1.com', '1@1.com', '2012-07-10 11:42:08', 1);
INSERT INTO `mx_survey_user` VALUES(22, 1, '71.185.143.53', 'Kahkashan parveen', 'Kahkashanparveen@yahoo.co.in', 'There should be more questions', '2012-07-13 22:22:23', 1);
INSERT INTO `mx_survey_user` VALUES(23, 1, '198.228.200.151', 'Erin', 'Re@test.con', 'This os a test', '2012-07-14 01:25:53', 1);
