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




--
-- Database: `kque`
--
CREATE DATABASE IF NOT EXISTS `kque` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `kque`;

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

--
-- Table structure for table `contents`
--

CREATE TABLE IF NOT EXISTS `contents` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `meta_keywords` varchar(255) CHARACTER SET utf8 NOT NULL,
  `meta_description` varchar(255) CHARACTER SET utf8 NOT NULL,
  `url` varchar(255) CHARACTER SET utf8 NOT NULL,
  `content` text CHARACTER SET utf8 NOT NULL,
  `modified_date` datetime NOT NULL,
  `seller` varchar(20) NOT NULL DEFAULT 'Inactive',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` (`id`, `title`, `meta_title`, `meta_keywords`, `meta_description`, `url`, `content`, `modified_date`, `seller`) VALUES
(1, 'Welcome', 'About us', 'About us', 'About us', 'welcome', '&lt;h4&gt;Who are we?&lt;/h4&gt;\r\n&lt;p&gt;Welcome to PriceGlobe! We are an international price comparison website based in Thisted, Denmark.&lt;/p&gt;\r\n&lt;h4&gt;Our plan&lt;/h4&gt;\r\n&lt;p&gt;With the growth of the internet and the globalisation, it has never been easier to purchase products from around the world. But how to find the best prices? Until now, price comparison websites only cover a country or region. PriceGlobe searches all the world to find the best price for you! We even consider shipping price and toll for your specific country! &lt;br /&gt;\r\nWhy only choose retailers from your own contry, when there might be retailers even cheaper in contries around you?&lt;br /&gt;\r\nPriceGlobe - Price Comparison Around the Globe.&lt;/p&gt;\r\n&lt;h4&gt;Contact &amp;amp; Location&lt;/h4&gt;\r\n&lt;p&gt;PriceGlobe&amp;nbsp;&lt;br /&gt;\r\n7700 Thisted&lt;br /&gt;\r\nDenmark&lt;br /&gt;\r\n&lt;br /&gt;\r\nMerchant and user support&lt;br /&gt;\r\nMail: contact@priceglobe.com&lt;br /&gt;\r\nPhone: +45 00 00 00 00&lt;br /&gt;\r\nCall time Mon-Fri 14:00-16:00 CET&lt;/p&gt;', '2013-12-02 06:08:54', 'Inactive'),
(2, 'Privacy Policy', 'Privacy Policy', 'Privacy Policy', 'Privacy Policy', 'privacy-policy', '&lt;h4&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas?&lt;/h4&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam    cursus. Morbi ut mi. Nullam enim leo, egestas id, condimentum at,    laoreet mattis, massa. Sed eleifend nonummy diam. Praesent mauris ante,    elementum et, bibendum at, posuere sit amet, nibh. Duis tincidunt   lectus  quis dui viverra vestibulum. Suspendisse vulputate aliquam dui.   Nulla  elementum dui ut augue. Aliquam vehicula mi at mauris. Maecenas    placerat, nisl at consequat rhoncus, sem nunc gravida justo, quis    eleifend arcu velit quis lacus. Morbi magna magna, tincidunt a, mattis    non, imperdiet vitae, tellus. Sed odio est, auctor ac, sollicitudin in,    consequat vitae, orci. Fusce id felis. Vivamus sollicitudin metus  eget   eros.&lt;/p&gt;\r\n&lt;h4&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas?&lt;/h4&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam    cursus. Morbi ut mi. Nullam enim leo, egestas id, condimentum at,    laoreet mattis, massa. Sed eleifend nonummy diam. Praesent mauris ante,    elementum et, bibendum at, posuere sit amet, nibh. Duis tincidunt   lectus  quis dui viverra vestibulum. Suspendisse vulputate aliquam dui.   Nulla  elementum dui ut augue. Aliquam vehicula mi at mauris. Maecenas    placerat, nisl at consequat rhoncus, sem nunc gravida justo, quis    eleifend arcu velit quis lacus. Morbi magna magna, tincidunt a, mattis    non, imperdiet vitae, tellus. Sed odio est, auctor ac, sollicitudin in,    consequat vitae, orci. Fusce id felis. Vivamus sollicitudin metus  eget   eros.&lt;/p&gt;\r\n&lt;h4&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas?&lt;/h4&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam    cursus. Morbi ut mi. Nullam enim leo, egestas id, condimentum at,    laoreet mattis, massa. Sed eleifend nonummy diam. Praesent mauris ante,    elementum et, bibendum at, posuere sit amet, nibh. Duis tincidunt   lectus  quis dui viverra vestibulum. Suspendisse vulputate aliquam dui.   Nulla  elementum dui ut augue. Aliquam vehicula mi at mauris. Maecenas    placerat, nisl at consequat rhoncus, sem nunc gravida justo, quis    eleifend arcu velit quis lacus. Morbi magna magna, tincidunt a, mattis    non, imperdiet vitae, tellus. Sed odio est, auctor ac, sollicitudin in,    consequat vitae, orci. Fusce id felis. Vivamus sollicitudin metus  eget   eros.&lt;/p&gt;\r\n&lt;h4&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas?&lt;/h4&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam    cursus. Morbi ut mi. Nullam enim leo, egestas id, condimentum at,    laoreet mattis, massa. Sed eleifend nonummy diam. Praesent mauris ante,    elementum et, bibendum at, posuere sit amet, nibh. Duis tincidunt   lectus  quis dui viverra vestibulum. Suspendisse vulputate aliquam dui.   Nulla  elementum dui ut augue. Aliquam vehicula mi at mauris. Maecenas    placerat, nisl at consequat rhoncus, sem nunc gravida justo, quis    eleifend arcu velit quis lacus. Morbi magna magna, tincidunt a, mattis    non, imperdiet vitae, tellus. Sed odio est, auctor ac, sollicitudin in,    consequat vitae, orci. Fusce id felis. Vivamus sollicitudin metus  eget   eros.&lt;/p&gt;\r\n&lt;h4&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas?&lt;/h4&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam    cursus. Morbi ut mi. Nullam enim leo, egestas id, condimentum at,    laoreet mattis, massa. Sed eleifend nonummy diam. Praesent mauris ante,    elementum et, bibendum at, posuere sit amet, nibh. Duis tincidunt   lectus  quis dui viverra vestibulum. Suspendisse vulputate aliquam dui.   Nulla  elementum dui ut augue. Aliquam vehicula mi at mauris. Maecenas    placerat, nisl at consequat rhoncus, sem nunc gravida justo, quis    eleifend arcu velit quis lacus. Morbi magna magna, tincidunt a, mattis    non, imperdiet vitae, tellus. Sed odio est, auctor ac, sollicitudin in,    consequat vitae, orci. Fusce id felis. Vivamus sollicitudin metus  eget   eros.&lt;/p&gt;\r\n&lt;h4&gt;Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas?&lt;/h4&gt;\r\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam    cursus. Morbi ut mi. Nullam enim leo, egestas id, condimentum at,    laoreet mattis, massa. Sed eleifend nonummy diam. Praesent mauris ante,    elementum et, bibendum at, posuere sit amet, nibh. Duis tincidunt   lectus  quis dui viverra vestibulum. Suspendisse vulputate aliquam dui.   Nulla  elementum dui ut augue. Aliquam vehicula mi at mauris. Maecenas    placerat, nisl at consequat rhoncus, sem nunc gravida justo, quis    eleifend arcu velit quis lacus. Morbi magna magna, tincidunt a, mattis    non, imperdiet vitae, tellus. Sed odio est, auctor ac, sollicitudin in,    consequat vitae, orci. Fusce id felis. Vivamus sollicitudin metus  eget   eros.&lt;/p&gt;', '2013-08-31 15:25:17', 'Inactive'),
(3, 'Experience your sales grow', 'Experience your sales grow', 'Experience your sales grow', 'Experience your sales grow', 'experience-your-sales-grow', '&lt;p&gt;Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took&lt;/p&gt;', '2013-10-22 16:06:13', 'Active'),
(4, 'Control your marketing', 'Control your marketing', 'Control your marketing', 'Control your marketing', 'control-your-marketing', '&lt;p&gt;Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took &lt;/p&gt;', '2013-10-23 13:37:35', 'Active'),
(5, 'Watch statistics for your products', 'Watch statistics for your products', 'Watch statistics for your products', 'Watch statistics for your products', 'watch-statistics-for-your-products', '&lt;p&gt;Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took&lt;/p&gt;', '2013-10-22 16:15:31', 'Active'),
(6, 'Benefits of a Retailer', 'Benefits of a Retailer', 'Benefits of a Retailer', 'Benefits of a Retailer', 'benefits-of-a-retailer', '&lt;p&gt;Join PriceGlobe to increase your sales and control your marketing  through the great opportunities PriceGlobe offer. Create a free retailer  account for no cost today!&amp;quot;&lt;/p&gt;', '2013-10-22 18:26:07', 'Inactive'),
(7, 'Benefits of a Manufactor Advertising', 'Benefits of a Manufactor Advertising', 'Benefits of a Manufactor Advertising', 'Benefits of a Manufactor Advertising', 'benefits-of-a-manufactor-advertising', '&lt;p&gt;If you want to advertise your products through the opportunities that we  provide at PriceGlobe, you will watch you sales increase in no time.  All the visitors at PriceGlobe intend to buy products, making PriceGlobe  an ideal website to marketing your products. Create a free account to  experience the opportunities PriceGlobe provide&lt;/p&gt;', '2013-10-22 18:26:53', 'Inactive'),
(8, 'Frequently asked questions', 'Frequently asked questions', 'Frequently asked questions', 'Frequently asked questions', 'frequently-asked-questions', '&lt;ul&gt;\r\n    &lt;li&gt;Why should I list my products on priceglobe?&lt;/li&gt;\r\n    &lt;li&gt;I have a site and I want to become a partner! What are the conditions I have to meet and what do I have to do?&lt;/li&gt;\r\n    &lt;li&gt;My products do not match any of the categories on PriceGlobe. Can I still list my products?&lt;/li&gt;\r\n&lt;/ul&gt;', '2013-10-22 18:27:40', 'Inactive'),
(9, 'Create your account', 'Create your account', 'Create your account', 'Create your account', 'create-your-account', '&lt;p&gt;Register for an account on Priceglobe, by using the options available on this page.&lt;/p&gt;', '2013-10-22 19:03:46', 'Inactive'),
(10, 'Customize your page', 'Customize your page', 'Customize your page', 'Customize your page', 'customize-your-page', '&lt;p&gt;Add your shop logo and enter your business contact details and your shop description.&lt;/p&gt;', '2013-10-22 19:04:23', 'Inactive'),
(11, 'Upload your products', 'Upload your products', 'Upload your products', 'Upload your products', 'upload-your-products', '&lt;p&gt;Enter the URL to your product datafeed file. The system supports txt, CSV or XML files.&lt;/p&gt;', '2013-10-22 19:05:02', 'Inactive'),
(12, 'Start receiving quality traffic', 'Start receiving quality traffic', 'Start receiving quality traffic', 'Start receiving quality traffic', 'start-receiving-quality-traffic', '&lt;p&gt;Once your products are online on ShopMania, we begin delivering potential buyers to your site.&lt;/p&gt;', '2013-10-22 19:05:38', 'Inactive'),
(13, 'Expand your online business', 'Expand your online business', 'Expand your online business', 'Expand your online business', 'expand-your-online-business', '&lt;p&gt;Set up your &lt;a href=&quot;http://localhost/priceglobe/merchant/sellerinterface/#&quot;&gt;Facebook shop&lt;/a&gt;, Mini Shop widget or create a new online shop with Priceglobe.&lt;/p&gt;', '2013-10-22 19:06:22', 'Inactive'),
(14, 'Dashboard', 'Dashboard', 'Dashboard', 'Dashboard', 'dashboard', '&lt;p&gt;After logging into your account, you are directed to your Partner  Dashboard that provides access to all the features and tools for  managing the listing of your products, your campaign and for optimizing  your presence on Priceglobe.&lt;/p&gt;', '2013-10-22 19:07:17', 'Inactive'),
(15, 'Upload your logo and shop description', 'Upload your logo and shop description', 'Upload your logo and shop description', 'Upload your logo and shop description', 'upload-your-logo-and-shop-description', '&lt;p&gt;Customize your shop page by uploading your logo. Inform your customers  about the benefits that they can enjoy by purchasing from your shop.  Make sure that you are convincing and that you highlight all your  strengths.&lt;/p&gt;', '2013-10-22 19:07:43', 'Inactive'),
(16, 'Add your shipping notes and rates', 'Add your shipping notes and rates', 'Add your shipping notes and rates', 'Add your shipping notes and rates', 'add-your-shipping-notes-and-rates', '&lt;p&gt;Don''t forget to enter your shipping policy and rates. These can also play a role in the buying decision.&lt;/p&gt;', '2013-10-22 19:08:14', 'Inactive'),
(17, 'Set up your Daily Deals', 'Set up your Daily Deals', 'Set up your Daily Deals', 'Set up your Daily Deals', 'set-up-your-daily-deals', '&lt;p&gt;Buyers are always attracted to promotional offers. Get the best results  by setting your Daily Deals, which are displayed in top positions on the  ShopMania pages.&lt;/p&gt;', '2013-10-22 19:08:41', 'Inactive'),
(18, 'Book advertisments', 'Book advertisments', 'Book advertisments', 'Book advertisments', 'book-advertisments', '&lt;p&gt;By booking your advertisements your products will be shown on PriceGlobe, and you will experience a growth in your sale.&lt;/p&gt;', '2013-10-22 19:09:12', 'Inactive');

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

--
-- Table structure for table `exam_body`
--

CREATE TABLE IF NOT EXISTS `exam_body` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `validity` int(11) NOT NULL,
  `post_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `exam_body`
--

INSERT INTO `exam_body` (`id`, `name`, `full_name`, `logo`, `validity`, `post_date`, `modify_date`, `status`) VALUES
(1, 'test', 'test', '1402585209-Penguins.jpg', 0, '2014-06-10 16:56:08', '2014-06-12 20:30:09', 'Active'),
(2, 'Test 2', 'Testing Name 2', '1402585229-Tulips.jpg', 0, '2014-06-11 12:36:52', '2014-06-12 20:30:29', 'Active');

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

--
-- Table structure for table `exam_body_pin`
--

CREATE TABLE IF NOT EXISTS `exam_body_pin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pin_id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `exam_paper`
--

CREATE TABLE IF NOT EXISTS `exam_paper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exam_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `paper_name` varchar(255) NOT NULL,
  `pass_marks` float(10,2) NOT NULL,
  `post_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `exam_paper`
--

INSERT INTO `exam_paper` (`id`, `exam_id`, `subject_id`, `paper_name`, `pass_marks`, `post_date`, `modify_date`, `status`) VALUES
(1, 2, 4, 'wee', 0.00, '2014-06-12 14:09:39', '0000-00-00 00:00:00', 'Active'),
(2, 2, 10, 'hfthfgjgjhgjghjghj', 66.00, '2014-06-12 14:11:21', '2014-06-12 16:03:26', 'Active'),
(3, 1, 8, 'Test Question', 40.00, '2014-06-12 16:13:26', '2014-06-12 16:17:06', 'Active'),
(4, 1, 15, 'csq', 56.00, '2014-06-13 16:04:54', '0000-00-00 00:00:00', 'Active');

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

--
-- Table structure for table `exam_question`
--

CREATE TABLE IF NOT EXISTS `exam_question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exam_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `paper_id` int(11) NOT NULL,
  `question` text NOT NULL,
  `ans1` text NOT NULL,
  `ans2` text NOT NULL,
  `ans3` text NOT NULL,
  `ans4` text NOT NULL,
  `ans5` text NOT NULL,
  `correct_ans` tinyint(4) NOT NULL,
  `post_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `exam_question`
--

INSERT INTO `exam_question` (`id`, `exam_id`, `subject_id`, `paper_id`, `question`, `ans1`, `ans2`, `ans3`, `ans4`, `ans5`, `correct_ans`, `post_date`, `modify_date`, `status`) VALUES
(3, 2, 4, 1, '<p>qqq</p>\r\n', '<p>r</p>\r\n', '<p>r</p>\r\n', '<p>r</p>\r\n', '<p>r</p>\r\n', '<p>r</p>\r\n', 5, '2014-06-13 14:11:16', '0000-00-00 00:00:00', 'Active'),
(4, 2, 4, 1, '<p>iiiiiiiiiiiiiiiiiiiiiiiii</p>\r\n', '<p>i</p>\r\n', '<p>i</p>\r\n', '<p>i</p>\r\n', '<p>i</p>\r\n', '<p>i</p>\r\n', 3, '2014-06-13 15:57:08', '0000-00-00 00:00:00', 'Active'),
(5, 2, 4, 1, '<p>44442//</p>\r\n', '<p>42</p>\r\n', '<p>42</p>\r\n', '<p>42</p>\r\n', '<p>42</p>\r\n', '<p>42</p>\r\n', 2, '2014-06-13 16:06:06', '2014-06-13 18:52:23', 'Active');

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

--
-- Table structure for table `exam_subject`
--

CREATE TABLE IF NOT EXISTS `exam_subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exam_id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `pass_marks` float(10,2) NOT NULL,
  `post_date` datetime NOT NULL,
  `modify_date` datetime NOT NULL,
  `compulsory` enum('1','0') NOT NULL DEFAULT '1',
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `exam_subject`
--

INSERT INTO `exam_subject` (`id`, `exam_id`, `subject`, `pass_marks`, `post_date`, `modify_date`, `compulsory`, `status`) VALUES
(1, 2, 'bengali', 60.00, '2014-06-05 00:00:00', '2014-06-11 00:00:00', '1', 'Active'),
(2, 2, 'Hindi', 60.00, '2014-06-04 00:00:00', '2014-06-05 00:00:00', '1', 'Active'),
(3, 3, 'Nepali', 60.00, '2014-06-17 00:00:00', '2014-06-18 00:00:00', '1', 'Active'),
(4, 2, 'Physics', 60.00, '2014-06-11 13:09:50', '0000-00-00 00:00:00', '1', 'Active'),
(5, 1, 'Chemistry', 55.00, '2014-06-11 13:13:03', '0000-00-00 00:00:00', '1', 'Active'),
(6, 1, 'Bio', 45.00, '2014-06-11 13:13:34', '0000-00-00 00:00:00', '1', 'Active'),
(7, 2, ',hj,hj,', 0.00, '2014-06-11 14:08:08', '0000-00-00 00:00:00', '0', 'Active'),
(8, 1, 'Test Sub', 35.00, '2014-06-11 16:01:37', '2014-06-11 16:08:34', '1', 'Active'),
(9, 1, 'test', 65.00, '2014-06-11 16:07:27', '2014-06-11 16:08:50', '1', 'Active'),
(10, 2, 'subject', 45.00, '2014-06-11 16:09:17', '2014-06-11 16:10:10', '0', 'Active'),
(11, 2, 'yyyy', 50.00, '2014-06-11 16:10:29', '2014-06-11 17:05:43', '1', 'Active'),
(12, 2, 'erere', 10.00, '2014-06-11 17:06:04', '0000-00-00 00:00:00', '1', 'Active'),
(13, 1, 'yyyy', 50.00, '2014-06-12 17:06:56', '0000-00-00 00:00:00', '0', 'Active'),
(14, 2, 'yyy', 78.00, '2014-06-12 17:09:52', '0000-00-00 00:00:00', '0', 'Active'),
(15, 1, 'cs', 50.00, '2014-06-13 16:02:28', '2014-06-13 18:52:42', '0', 'Active');

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

--
-- Table structure for table `exam_user`
--

CREATE TABLE IF NOT EXISTS `exam_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pin_id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email_id` varchar(255) NOT NULL,
  `pin_no` varchar(255) NOT NULL,
  `marks` float(10,2) NOT NULL,
  `post_date` datetime NOT NULL,
  `expiry_date` datetime NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `exam_user_archive`
--

CREATE TABLE IF NOT EXISTS `exam_user_archive` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pin_id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email_id` varchar(255) NOT NULL,
  `pin_no` varchar(255) NOT NULL,
  `marks` float(10,2) NOT NULL,
  `post_date` datetime NOT NULL,
  `expiry_date` datetime NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `exam_user_paper`
--

CREATE TABLE IF NOT EXISTS `exam_user_paper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` int(11) NOT NULL,
  `paper_id` int(11) NOT NULL,
  `marks` float(10,2) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `exam_user_paper_archive`
--

CREATE TABLE IF NOT EXISTS `exam_user_paper_archive` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` int(11) NOT NULL,
  `paper_id` int(11) NOT NULL,
  `marks` float(10,2) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `global_config`
--

CREATE TABLE IF NOT EXISTS `global_config` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `field_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `field_value` text CHARACTER SET utf8 NOT NULL,
  `field_key` varchar(50) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `global_config`
--

INSERT INTO `global_config` (`id`, `field_name`, `field_value`, `field_key`) VALUES
(1, 'Site Name', 'TEST', 'global_site_name'),
(2, 'Meta Title', 'TEST', 'global_meta_title'),
(3, 'Meta Keywords', 'TEST', 'global_meta_keywords'),
(4, 'Meta Description', 'TEST', 'global_meta_description'),
(9, 'Facebook', '', 'global_facebook_url'),
(10, 'Twitter', '', 'global_twitter_url'),
(12, 'Webadmin Name', '', 'global_web_admin_name'),
(13, 'Webadmin Email', '', 'global_webadmin_email'),
(14, 'Email Signature', '', 'global_email_signature'),
(22, 'Phone Number', '+91 123 456 7890', 'global_phone_number'),
(23, 'Paypal Business Email', '', 'global_paypal_business_email'),
(24, 'Paypal Mode', '', 'global_paypal_mode'),
(26, 'Number of Products On each Page', '', 'global_product_page_count');

