-- https://www.phpmyadmin.net/
--




--
-- Database: `revateam_thelantern`
--

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

--
-- Table structure for table `client_logo`
--

CREATE TABLE `client_logo` (
  `id` int(11) NOT NULL,
  `website_title` varchar(225) NOT NULL,
  `small_logo_image` varchar(255) NOT NULL,
  `home_image` varchar(225) NOT NULL,
  `home_desc` longtext NOT NULL,
  `lux_title` varchar(225) NOT NULL,
  `lux_lamp_image` varchar(225) NOT NULL,
  `lux_lamp_content` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_logo`
--

INSERT INTO `client_logo` (`id`, `website_title`, `small_logo_image`, `home_image`, `home_desc`, `lux_title`, `lux_lamp_image`, `lux_lamp_content`) VALUES
(1, 'The-Lantern-new', 'top_logo.png', 'ft_logo.png', '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', 'Luxury & Contemporary Lamps', '3.jpg', '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 a galley of type and scrambled it to make a type specimen book.\r\n\r\nLorem 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 a galley of type and scrambled it to make a type specimen book. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.\r\nLorem 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 a galley of type and scrambled it to make a type specimen book.\r\n\r\nLorem 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 a galley of type and scrambled it to make a type specimen book. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.');

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

--
-- Table structure for table `company_address`
--

CREATE TABLE `company_address` (
  `id` int(11) NOT NULL,
  `mobile` longtext NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company_address`
--

INSERT INTO `company_address` (`id`, `mobile`, `email`, `address`) VALUES
(1, '+91- 141-4044576/ 4034576 9414073496, 9314508905$+91- 141- 4036759, 9929509002', 'thelanternjaipur@gmail.com$thelantern_ajit@yahoo.in', 'Shop no. 3, Sahakar Marg, Opp. Laxmi Mandir Rly. Crossing, Jaipur. Rajasthan. India.$D-29, Subhash Marg, C- Scheme, jaipur, Rajasthan. India.');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(200) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `name`, `email`, `mobile`, `subject`, `message`, `date`) VALUES
(1, 'yogita', 'ybindal@gmail.com', '9694383547', 'asking', '', '2017-06-13');

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

--
-- Table structure for table `tbl_banner`
--

CREATE TABLE `tbl_banner` (
  `id` int(11) NOT NULL,
  `left_banner_image` varchar(225) NOT NULL,
  `left_banner_link` varchar(225) NOT NULL,
  `right_top_banner` varchar(225) NOT NULL,
  `right_top_banner_link` varchar(225) NOT NULL,
  `right_down_banner` varchar(225) NOT NULL,
  `right_down_banner_link` varchar(225) NOT NULL,
  `publish` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_banner`
--

INSERT INTO `tbl_banner` (`id`, `left_banner_image`, `left_banner_link`, `right_top_banner`, `right_top_banner_link`, `right_down_banner`, `right_down_banner_link`, `publish`) VALUES
(1, 'post_ad.jpg', 'product_list.php?id=1', 'post_1.jpg', 'index1.php?page_id=1', 'post_2.jpg', 'product.php?page_id=2', 1);

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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`id`, `name`, `image`) VALUES
(1, 'Ceiling Lights', 'product_1.jpg'),
(2, 'Outdoor Lights', 'product_2.jpg'),
(3, 'Recessed Lights', 'product_3.jpg'),
(4, 'Floor Lamps', 'product_4.jpg'),
(5, 'Mirror Lights', 'product_5.jpg'),
(6, 'Pendant Lights', 'product_6.jpg'),
(7, 'Wall Lights', 'product_7.jpg'),
(8, 'Chandeliers', 'product_8.jpg');

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

--
-- Table structure for table `tbl_enquiry`
--

CREATE TABLE `tbl_enquiry` (
  `id` int(11) NOT NULL,
  `name` varchar(225) NOT NULL,
  `mobile` varchar(225) NOT NULL,
  `email` varchar(225) NOT NULL,
  `product_id` int(11) NOT NULL,
  `message` longtext NOT NULL,
  `date` date NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_enquiry`
--

INSERT INTO `tbl_enquiry` (`id`, `name`, `mobile`, `email`, `product_id`, `message`, `date`, `status`) VALUES
(1, 'yogita', '9694383547', 'ybindal1@gmail.com', 1, '', '2017-06-13', 0);

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

--
-- Table structure for table `tbl_menu`
--

CREATE TABLE `tbl_menu` (
  `id` int(11) NOT NULL,
  `page_name` varchar(100) DEFAULT NULL,
  `header_show` int(2) DEFAULT '0',
  `footer_show` int(2) DEFAULT '0',
  `content_information` text,
  `banner` varchar(100) NOT NULL,
  `page_title` varchar(100) DEFAULT NULL,
  `page_order` int(100) NOT NULL,
  `publish` int(2) DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_menu`
--

INSERT INTO `tbl_menu` (`id`, `page_name`, `header_show`, `footer_show`, `content_information`, `banner`, `page_title`, `page_order`, `publish`) VALUES
(1, 'About Us', 1, 1, '<p>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 a galley of type and  scrambled it to make a type specimen book. It has survived not only five  centuries, but also the leap into electronic typesetting, remaining  essentially unchanged.</p>\r\n<p>It is a long established fact that a reader will  be distracted by the readable content of a page when looking at its  layout. The point of using Lorem Ipsum is that it has a more-or-less  normal distribution of letters, as opposed to using \'Content here,  content here\', making it look like readable English. Many desktop  publishing packages and web page editors now use Lorem Ipsum as their  default model text, and a search for \'lorem ipsum\' will uncover many web  sites still in their infancy.</p>\r\n<p>There are many variations of passages of Lorem  Ipsum available, but the majority have suffered alteration in some form,  by injected humour, or randomised words which don\'t look even slightly  believable. If you are going to use a passage of Lorem Ipsum, you need  to be sure there isn\'t anything embarrassing hidden in the middle of  text. All the Lorem Ipsum generators on the Internet tend to repeat  predefined chunks as necessary, making this the first true generator on  the Internet. It uses a dictionary of over 200 Latin words, combined  with a handful of model sentence structures, to generate Lorem Ipsum  which looks reasonable. The generated Lorem Ipsum is therefore always  free from repetition, injected humour, or non-characteristic words etc.</p>\r\n<p>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 a galley  of type and scrambled it to make a type specimen book. It has survived  not only five centuries, but also the leap into electronic typesetting,  remaining essentially unchanged.</p>\r\n<p>It is a long established fact that a reader will  be distracted by the readable content of a page when looking at its  layout. The point of using Lorem Ipsum is that it has a more-or-less  normal distribution of letters, as opposed to using \'Content here,  content here\', making it look like readable English. Many desktop  publishing packages and web page editors now use Lorem Ipsum as their  default model text, and a search for \'lorem ipsum\' will uncover many web  sites still in their infancy.</p>\r\n<p>There are many variations of passages of Lorem  Ipsum available, but the majority have suffered alteration in some form,  by injected humour, or randomised words which don\'t look even slightly  believable. If you are going to use a passage of Lorem Ipsum, you need  to be sure there isn\'t anything embarrassing hidden in the middle of  text. All the Lorem Ipsum generators on the Internet tend to repeat  predefined chunks as necessary, making this the first true generator on  the Internet. It uses a dictionary of over 200 Latin words, combined  with a handful of model sentence structures, to generate Lorem Ipsum  which looks reasonable. The generated Lorem Ipsum is therefore always  free from repetition, injected humour, or non-characteristic words etc.</p>', 'banner_1.jpg', 'About Us', 1, 1),
(2, 'Products', 1, 1, 'Content Not Available<br />', 'banner_1.jpg', 'Products', 2, 1),
(3, 'Blogs', 1, 1, 'Content Not Available<br />', 'banner_1.jpg', 'Blogs', 3, 0);

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

--
-- Table structure for table `tbl_menu_copy`
--

CREATE TABLE `tbl_menu_copy` (
  `id` int(11) NOT NULL,
  `page_name` varchar(100) DEFAULT NULL,
  `header_show` int(2) DEFAULT '0',
  `footer_show` int(2) DEFAULT '0',
  `links` int(1) NOT NULL DEFAULT '0',
  `policy` int(1) NOT NULL DEFAULT '0',
  `menu_show` int(2) DEFAULT '0',
  `content_information` text,
  `image` varchar(100) NOT NULL,
  `product_menu_show` int(2) DEFAULT NULL,
  `page_title` varchar(100) DEFAULT NULL,
  `sort_order` int(11) NOT NULL,
  `keyword_des` varchar(100) NOT NULL,
  `publish` int(2) DEFAULT '1',
  `image_title` varchar(255) NOT NULL,
  `image_description` longtext NOT NULL,
  `type` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_menu_copy`
--

INSERT INTO `tbl_menu_copy` (`id`, `page_name`, `header_show`, `footer_show`, `links`, `policy`, `menu_show`, `content_information`, `image`, `product_menu_show`, `page_title`, `sort_order`, `keyword_des`, `publish`, `image_title`, `image_description`, `type`) VALUES
(1, 'About Us', 1, 1, 0, 0, 0, '<p>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 a galley of type and  scrambled it to make a type specimen book. It has survived not only five  centuries, but also the leap into electronic typesetting, remaining  essentially unchanged.</p>\r\n<p>It is a long established fact that a reader will  be distracted by the readable content of a page when looking at its  layout. The point of using Lorem Ipsum is that it has a more-or-less  normal distribution of letters, as opposed to using \'Content here,  content here\', making it look like readable English. Many desktop  publishing packages and web page editors now use Lorem Ipsum as their  default model text, and a search for \'lorem ipsum\' will uncover many web  sites still in their infancy.</p>\r\n<p>There are many variations of passages of Lorem  Ipsum available, but the majority have suffered alteration in some form,  by injected humour, or randomised words which don\'t look even slightly  believable. If you are going to use a passage of Lorem Ipsum, you need  to be sure there isn\'t anything embarrassing hidden in the middle of  text. All the Lorem Ipsum generators on the Internet tend to repeat  predefined chunks as necessary, making this the first true generator on  the Internet. It uses a dictionary of over 200 Latin words, combined  with a handful of model sentence structures, to generate Lorem Ipsum  which looks reasonable. The generated Lorem Ipsum is therefore always  free from repetition, injected humour, or non-characteristic words etc.</p>\r\n<p>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 a galley  of type and scrambled it to make a type specimen book. It has survived  not only five centuries, but also the leap into electronic typesetting,  remaining essentially unchanged.</p>\r\n<p>It is a long established fact that a reader will  be distracted by the readable content of a page when looking at its  layout. The point of using Lorem Ipsum is that it has a more-or-less  normal distribution of letters, as opposed to using \'Content here,  content here\', making it look like readable English. Many desktop  publishing packages and web page editors now use Lorem Ipsum as their  default model text, and a search for \'lorem ipsum\' will uncover many web  sites still in their infancy.</p>\r\n<p>There are many variations of passages of Lorem  Ipsum available, but the majority have suffered alteration in some form,  by injected humour, or randomised words which don\'t look even slightly  believable. If you are going to use a passage of Lorem Ipsum, you need  to be sure there isn\'t anything embarrassing hidden in the middle of  text. All the Lorem Ipsum generators on the Internet tend to repeat  predefined chunks as necessary, making this the first true generator on  the Internet. It uses a dictionary of over 200 Latin words, combined  with a handful of model sentence structures, to generate Lorem Ipsum  which looks reasonable. The generated Lorem Ipsum is therefore always  free from repetition, injected humour, or non-characteristic words etc.</p>', 'banner_1.jpg', NULL, 'About Us', 0, '', 1, '', '', ''),
(2, 'services', 1, 1, 0, 0, 0, 'Content Not Available<br />', 'banner_2.jpg', NULL, 'services', 0, '', 1, '', '', ''),
(3, 'blogs', 1, 1, 0, 0, 0, 'Content Not Available<br />', 'banner_2.jpg', NULL, 'blogs', 0, '', 1, '', '', ''),
(4, 'product', 0, 0, 0, 0, 0, '<br />', '', NULL, 'product', 0, '', 1, '', '', '');

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

--
-- Table structure for table `tbl_product`
--

CREATE TABLE `tbl_product` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `product_name` varchar(225) NOT NULL,
  `image` varchar(225) NOT NULL,
  `publish` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_product`
--

INSERT INTO `tbl_product` (`id`, `cat_id`, `product_name`, `image`, `publish`) VALUES
(1, 1, 'ceiling lights', '7086794ceiling_lights_1.jpg$7755434ceiling_lights_2.jpg$2043464ceiling_lights_3.jpg$2719428ceiling_lights_4.jpg$4055792ceiling_lights_5.jpg$4250799ceiling_lights_6.jpg$9412842ceiling_lights_7.jpg$8463746ceiling_lights_8.jpg', 1);

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

--
-- Table structure for table `tbl_slider`
--

CREATE TABLE `tbl_slider` (
  `id` int(10) NOT NULL,
  `title` varchar(200) NOT NULL,
  `image` varchar(300) NOT NULL,
  `publish` int(2) NOT NULL DEFAULT '0',
  `description` longtext NOT NULL,
  `type` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_slider`
--

INSERT INTO `tbl_slider` (`id`, `title`, `image`, `publish`, `description`, `type`) VALUES
(1, 'image1', 'slider-1.jpg', 1, 'The-Lantern Bird Silla Colgante A good-looking, comfortable traditional collection from Softaly', 'mainslider'),
(3, 'image2', 'slider-2.jpg', 1, ' The-Lantern\r\nBird Silla Colgante\r\nA good-looking, comfortable traditional collection from Softaly', 'mainslider'),
(4, 'image3', 'slider-3.jpg', 1, ' The-Lantern\r\nBird Silla Colgante\r\nA good-looking, comfortable traditional collection from Softaly', 'mainslider'),
(5, '1', '1.jpg', 1, '', 'downslider'),
(6, '2', '2.jpg', 1, '', 'downslider'),
(7, '3', '3.jpg', 1, '', 'downslider'),
(8, '4', '4.jpg', 1, '', 'downslider'),
(9, '5', '5.jpg', 1, '', 'downslider'),
(10, '6', '6.jpg', 1, '', 'downslider'),
(11, '7', '7.jpg', 1, '', 'downslider');

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

--
-- Table structure for table `tbl_social`
--

CREATE TABLE `tbl_social` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_social`
--

INSERT INTO `tbl_social` (`id`, `title`, `link`) VALUES
(1, 'facebook', 'https://facebook.com/');

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

--
-- Table structure for table `tbl_sub_pages`
--

CREATE TABLE `tbl_sub_pages` (
  `id` int(11) NOT NULL,
  `maincontent_id` int(11) NOT NULL,
  `page_name` varchar(2000) NOT NULL,
  `banner` varchar(255) NOT NULL,
  `header_show` int(11) NOT NULL DEFAULT '1',
  `footer_show` int(11) NOT NULL DEFAULT '1',
  `content_information` text NOT NULL,
  `page_title` varchar(2000) NOT NULL,
  `publish` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_sub_pages_copy`
--

CREATE TABLE `tbl_sub_pages_copy` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `image_title` varchar(255) NOT NULL,
  `image_description` longtext NOT NULL,
  `maincontent_id` int(11) NOT NULL,
  `subpage_name` varchar(2000) NOT NULL,
  `header_show` int(11) NOT NULL DEFAULT '1',
  `footer_show` int(11) NOT NULL DEFAULT '1',
  `menu_show` varchar(2000) NOT NULL,
  `subpage_information` text NOT NULL,
  `product_menu_show` varchar(2000) NOT NULL,
  `subpage_title` varchar(2000) NOT NULL,
  `page_keyword` varchar(2000) NOT NULL,
  `publish` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_sub_pages_copy`
--

INSERT INTO `tbl_sub_pages_copy` (`id`, `image`, `image_title`, `image_description`, `maincontent_id`, `subpage_name`, `header_show`, `footer_show`, `menu_show`, `subpage_information`, `product_menu_show`, `subpage_title`, `page_keyword`, `publish`) VALUES
(1, '', '', '', 2, 'service1', 1, 1, '', 'content not available<br />', '', 'service1', '', 1);

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

--
-- Table structure for table `user_login_detail`
--

CREATE TABLE `user_login_detail` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `last_login` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_login_detail`
--

INSERT INTO `user_login_detail` (`id`, `uid`, `ip`, `last_login`) VALUES
(1, 1, '127.0.0.1', '2017-05-30 15:03:52'),
(2, 1, '127.0.0.1', '2017-05-30 15:05:06'),
(3, 1, '127.0.0.1', '2017-05-30 15:05:39'),
(4, 1, '127.0.0.1', '2017-05-30 15:06:36'),
(5, 1, '127.0.0.1', '2017-05-30 15:09:28'),
(6, 1, '127.0.0.1', '2017-05-30 15:15:33'),
(7, 1, '127.0.0.1', '2017-05-30 15:20:55'),
(8, 1, '127.0.0.1', '2017-05-30 16:15:55'),
(9, 1, '127.0.0.1', '2017-05-30 16:16:31'),
(10, 1, '127.0.0.1', '2017-05-31 10:41:55'),
(11, 1, '127.0.0.1', '2017-05-31 17:26:32'),
(12, 1, '127.0.0.1', '2017-06-03 16:18:02'),
(13, 1, '122.160.165.131', '2017-06-03 16:39:28'),
(14, 1, '122.160.165.131', '2017-06-06 17:31:09'),
(15, 1, '122.160.165.131', '2017-06-06 18:38:34'),
(16, 1, '122.160.165.131', '2017-06-06 18:58:19'),
(17, 1, '122.160.165.131', '2017-06-07 18:28:32'),
(18, 1, '122.160.165.131', '2017-06-08 10:50:18'),
(19, 1, '122.160.165.131', '2017-06-08 18:30:12'),
(20, 1, '122.160.165.131', '2017-06-09 12:57:08'),
(21, 1, '122.160.165.131', '2017-06-09 15:24:08'),
(22, 1, '122.160.165.131', '2017-06-13 13:01:27');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `client_logo`
--
ALTER TABLE `client_logo`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `company_address`
--
ALTER TABLE `company_address`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_us`
--
ALTER TABLE `contact_us`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_category`
--
ALTER TABLE `tbl_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_enquiry`
--
ALTER TABLE `tbl_enquiry`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_menu_copy`
--
ALTER TABLE `tbl_menu_copy`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_product`
--
ALTER TABLE `tbl_product`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_slider`
--
ALTER TABLE `tbl_slider`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_social`
--
ALTER TABLE `tbl_social`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sub_pages`
--
ALTER TABLE `tbl_sub_pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sub_pages_copy`
--
ALTER TABLE `tbl_sub_pages_copy`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_login_detail`
--
ALTER TABLE `user_login_detail`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `client_logo`
--
ALTER TABLE `client_logo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `company_address`
--
ALTER TABLE `company_address`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_category`
--
ALTER TABLE `tbl_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `tbl_enquiry`
--
ALTER TABLE `tbl_enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_menu_copy`
--
ALTER TABLE `tbl_menu_copy`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_product`
--
ALTER TABLE `tbl_product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_slider`
--
ALTER TABLE `tbl_slider`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `tbl_social`
--
ALTER TABLE `tbl_social`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tbl_sub_pages`
--
ALTER TABLE `tbl_sub_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_sub_pages_copy`
--
ALTER TABLE `tbl_sub_pages_copy`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `user_login_detail`
--
ALTER TABLE `user_login_detail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
