-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 28, 2019 at 09:47 AM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `adowoods`
--

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

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE IF NOT EXISTS `tbl_admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_user_type` varchar(50) NOT NULL,
  `admin_access` varchar(500) NOT NULL,
  `admin_userid` varchar(70) NOT NULL,
  `admin_password` varchar(70) NOT NULL,
  `admin_company_name` varchar(150) NOT NULL,
  `admin_name` varchar(100) NOT NULL,
  `admin_email` varchar(100) NOT NULL,
  `admin_alt_email` varchar(100) NOT NULL,
  `admin_mobile` varchar(50) NOT NULL,
  `admin_phone` varchar(50) NOT NULL,
  `admin_fax` varchar(50) NOT NULL,
  `admin_address` varchar(200) NOT NULL,
  `admin_city` varchar(70) NOT NULL,
  `admin_state` varchar(50) NOT NULL,
  `admin_country` varchar(50) NOT NULL,
  `admin_zip_code` varchar(20) NOT NULL,
  `admin_website_url` varchar(200) NOT NULL,
  `admin_catalog_url` varchar(100) NOT NULL,
  `admin_language_option` enum('Yes','No') NOT NULL DEFAULT 'No',
  `admin_visitor_counter_option` enum('Yes','No') NOT NULL,
  `admin_search_option` enum('Yes','No') NOT NULL,
  `admin_video_option` enum('Yes','No') NOT NULL DEFAULT 'No',
  `admin_etrust_option` enum('Yes','No') NOT NULL DEFAULT 'No',
  `admin_etrust_link` varchar(300) NOT NULL,
  `admin_quick_enq_option` enum('Yes','No') NOT NULL DEFAULT 'No',
  `admin_product_option` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `admin_flipbook_option` enum('Yes','No') NOT NULL DEFAULT 'No',
  `admin_facebook_link` varchar(150) NOT NULL,
  `admin_twitter_link` varchar(150) NOT NULL,
  `admin_insta_link` varchar(150) NOT NULL,
  `admin_pin_link` varchar(150) NOT NULL,
  `admin_all_right_reserved` varchar(100) NOT NULL,
  `admin_website_design_by` varchar(100) NOT NULL,
  `admin_contactus_map` enum('Yes','No') NOT NULL DEFAULT 'No',
  `admin_contactus_map_link` text NOT NULL,
  `admin_site_down` enum('Yes','No') NOT NULL DEFAULT 'No',
  `admin_site_down_message` varchar(200) NOT NULL,
  `admin_copyright` varchar(20) NOT NULL,
  `admin_member_of` varchar(100) NOT NULL,
  `admin_keyword` varchar(50) NOT NULL,
  `admin_keyword_link` varchar(150) NOT NULL,
  `admin_is_meta_fb_id` varchar(10) NOT NULL,
  `admin_is_meta_alexa_id` varchar(10) NOT NULL,
  `admin_is_meta_msvalidate_id` varchar(10) NOT NULL,
  `admin_index_follow` varchar(20) NOT NULL,
  `admin_meta_fb_id` varchar(100) NOT NULL,
  `admin_youtube_link` varchar(300) NOT NULL,
  `admin_meta_alexa_id` varchar(100) NOT NULL,
  `admin_meta_msvalidate_id` varchar(100) NOT NULL,
  `admin_site_verification_code` varchar(200) NOT NULL,
  `admin_google_analytic_code` varchar(1000) NOT NULL,
  `admin_add_date` date NOT NULL,
  `admin_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`admin_id`, `admin_user_type`, `admin_access`, `admin_userid`, `admin_password`, `admin_company_name`, `admin_name`, `admin_email`, `admin_alt_email`, `admin_mobile`, `admin_phone`, `admin_fax`, `admin_address`, `admin_city`, `admin_state`, `admin_country`, `admin_zip_code`, `admin_website_url`, `admin_catalog_url`, `admin_language_option`, `admin_visitor_counter_option`, `admin_search_option`, `admin_video_option`, `admin_etrust_option`, `admin_etrust_link`, `admin_quick_enq_option`, `admin_product_option`, `admin_flipbook_option`, `admin_facebook_link`, `admin_twitter_link`, `admin_insta_link`, `admin_pin_link`, `admin_all_right_reserved`, `admin_website_design_by`, `admin_contactus_map`, `admin_contactus_map_link`, `admin_site_down`, `admin_site_down_message`, `admin_copyright`, `admin_member_of`, `admin_keyword`, `admin_keyword_link`, `admin_is_meta_fb_id`, `admin_is_meta_alexa_id`, `admin_is_meta_msvalidate_id`, `admin_index_follow`, `admin_meta_fb_id`, `admin_youtube_link`, `admin_meta_alexa_id`, `admin_meta_msvalidate_id`, `admin_site_verification_code`, `admin_google_analytic_code`, `admin_add_date`, `admin_status`) VALUES
(1, 'Admin', '', 'resadmin', 'resadmin', 'Malik Traders', 'Mohd Faizan', 'malik502782@gmail.com', '', '+91 8859743003/ 9084934646', '0751- 4016220', '', 'ISBT Turner Road, Clement Town, Lane No. C13', 'Dehradun', 'Uttarakhand', 'India', '248002', 'http://localhost/adowoods', 'https://www.tradekeyindia.com/malik-refrigeration/', 'Yes', 'Yes', 'Yes', 'No', 'No', '', 'No', 'No', 'No', 'https://www.facebook.com/b2b.tradekeyindia', 'https://twitter.com/tradekeyindia', 'https://instogram.pro/user/astechsolutions', 'http://in.linkedin.com/in/b2btradekeyindia', 'Malik Refrigeration', '', 'Yes', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3502.1671259055674!2d77.06240011508245!3d28.62475278242084!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x390d05ca8dc16d31%3A0xee55ec04c2a320d4!2sBest+Website+Designing+Company+in+Delhi+-+Astech+Media+(P)+Limited.!5e0!3m2!1sen!2sin!4v1561628020810!5m2!1sen!2sin"  frameborder="0" style="border:0; width:100%; height:400px;" allowfullscreen></iframe>', 'No', '', '2018-2019', 'Tradekeyindia.com', 'B2B Portal in india', 'http://www.tradekeyindia.com', '', '', '', 'Yes', '', 'https://www.youtube.com/watch?v=wl4Hg23RQHQ', '', '', 'yddYgta-gcupJhgc5dxKEe_jx_kpBNvsY-pEqnOdRgg', '<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src="https://www.googletagmanager.com/gtag/js?id=UA-128214727-30"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(''js'', new Date());\r\n\r\n  gtag(''config'', ''UA-128214727-30'');\r\n</script>', '2014-12-19', 'Active'),
(22, 'Sub Admin', '2,3,4,5,14,15', 'tkiseo', 'tkiankush', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'No', 'Yes', 'Yes', 'No', 'No', '', 'No', 'Yes', 'No', '', '', '', '', '', '', 'No', '', 'No', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2018-09-17', 'Active'),
(23, 'Sub Admin', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,20,16,17,18,15,22', 'tkicoard', 'tkiseema', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'No', 'Yes', 'Yes', 'No', 'No', '', 'No', 'Yes', 'No', '', '', '', '', '', '', 'No', '', 'No', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2018-09-17', 'Active');

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

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

CREATE TABLE IF NOT EXISTS `tbl_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_parent_id` int(11) NOT NULL,
  `category_name` varchar(100) NOT NULL,
  `category_image_name` varchar(100) NOT NULL,
  `category_description` text NOT NULL,
  `category_is_hot` enum('Yes','No') NOT NULL DEFAULT 'No',
  `category_is_featured` enum('Yes','No') NOT NULL DEFAULT 'No',
  `category_for_gallery` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `category_for_falsh` enum('Yes','No') NOT NULL DEFAULT 'No',
  `category_meta_title` varchar(200) NOT NULL,
  `category_meta_description` varchar(300) NOT NULL,
  `category_meta_keywords` varchar(500) NOT NULL,
  `category_is_product` enum('Yes','No') NOT NULL DEFAULT 'No',
  `category_url` varchar(100) NOT NULL,
  `category_order_by` varchar(10) NOT NULL,
  `category_add_date` date NOT NULL,
  `category_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

INSERT INTO `tbl_category` (`category_id`, `category_parent_id`, `category_name`, `category_image_name`, `category_description`, `category_is_hot`, `category_is_featured`, `category_for_gallery`, `category_for_falsh`, `category_meta_title`, `category_meta_description`, `category_meta_keywords`, `category_is_product`, `category_url`, `category_order_by`, `category_add_date`, `category_status`) VALUES
(1, 0, 'Door-and-Window-Frames', '5892daba2b34cd.jpg', '<p>WPC door frames are manufactured with a special composite technology which is secret to its beautiful looks. Ado Woods Wpc door frames don&#39;t change in shape or wrap. Ado woods frames don&#39;t even shrink, crack or fade. Adowoods wpc door frames are synoymous to safety, stability and longevity. Wpc frames are an excellent amalgamation of technology &amp; design. Adowoods frames don&#39;t absorb water from cement during concrete work.</p>\r\n\r\n<p>Adowoods WPC frames are 100% water proof, termite proof 100%, fire retardant, overall they have superior qyality than other WPC. Ado Woods WPC Door Frames density is 960kg/m3(cube). and weight is +700 g (90x45mm) &amp; +1400g(125x60mm).</p>\r\n\r\n<p>We are a leading manufacturer and supplier of wide range of doors frames that are crafted using hi- tech machinery for unique designing. Our door frames are appreciated among the clients due their qualitative features such as fine finishing, perfect polishing and durability. Door frames are offered at affordable prices.</p>', 'Yes', 'No', 'Yes', 'Yes', 'meta title for ado-doors category', 'meta description for ado-doors category', 'meta keyword for ado-doors category', 'Yes', 'Door-Frames', '', '0000-00-00', 'Active'),
(2, 0, 'wall-paneling', '5729a389568146.jpg', '<p>Pre-finished with latest trendy colors (need no further painting nor vanishing works) Water/damp proofed + termite free + durable + maintenance free Fast, neat &amp; effective installation method</p>', 'Yes', 'No', 'Yes', 'Yes', 'meta title for wall-paneling', 'meta description for wall-paneling', 'meta keyword for wall-paneling', 'Yes', 'wall-paneling', '', '0000-00-00', 'Active'),
(3, 0, 'False-Ceiling', '520a51dc083b2a.jpg', '<p>&nbsp;</p>\r\n\r\n<p>Pre-finished with latest trendy colors (need no further painting nor vanishing works)</p>\r\n\r\n<p>Water/damp proofed + termite free + durable + maintenance free</p>\r\n\r\n<p>Fast, neat &amp; effective installation method</p>\r\n\r\n<p>&nbsp;</p>', 'Yes', 'Yes', 'Yes', 'Yes', 'meta title for false ceiling', 'meta description for false ceiling', 'meta keyword for false ceiling', 'Yes', 'false-ceiling', '', '0000-00-00', 'Active'),
(4, 0, 'Front-Elevation', '218c2026c3acab.jpg', '<p>Pre-finished with latest trendy colors (need no further painting nor vanishing works).</p>\r\n\r\n<p>Water/damp proofed + termite free + durable + maintenance free.</p>\r\n\r\n<p>Fast, neat &amp; effective installation method</p>', 'Yes', 'Yes', 'Yes', 'Yes', 'meta title for front elevation', 'meta description for front elevation', 'meta keyword for front elevation', 'Yes', 'front-elevation', '', '0000-00-00', 'Active'),
(5, 0, 'Picket-Fencing', 'aad9d74459b6c6.jpg', '<p>Pre-finished with latest trendy colors</p>\r\n\r\n<p>Water/damp proofed + termite free + durable + maintenance free</p>\r\n\r\n<p>Fast, neat &amp; effective installation method</p>\r\n\r\n<p>Picket fence sizes are available as per the requirement</p>\r\n\r\n<p>&nbsp;</p>', 'Yes', 'Yes', 'Yes', 'Yes', 'meta title for picket fencing', 'meta decsription for Picket Fencing', 'meta keyword for Picket Fencing', 'Yes', 'picket-fencing', '', '0000-00-00', 'Active'),
(6, 0, 'Gates', 'bd8d7ca5988edf.jpg', '<p>Architect WPC principle entryway have style just as a class. The keen utilization of wood in the planning procedure gives an ideal look to our items which increment their interest in market. The handles on doors are planned while remembering their broad use. These items are made for customers according to their necessity fit as a fiddle and size which causes us in giving agreeable answers for customers in an increasingly effective way. ADO WOODS is one the best producer organization of WPC Gate in Gwalior Madhya Pradesh India, we fabricate WPC Gate in reasonable expense.</p>\r\n\r\n<p><strong>WPC Benches DESCRIPTION</strong></p>\r\n\r\n<p>We WPC Benches manufacturer, supplier and exporter from India.</p>', 'Yes', 'Yes', 'Yes', 'Yes', 'meta title for gates', 'meta description for Gates', 'meta keyword for Gates', 'Yes', 'gates', '', '0000-00-00', 'Active'),
(7, 0, 'Test', '0a81c870b81b31.jpg', '<p>Testing by admin</p>', 'Yes', 'Yes', 'Yes', 'Yes', 'Testing by admin', 'Testing by admin', 'Testing by admin', 'Yes', 'test', '', '0000-00-00', 'Active');

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

--
-- Table structure for table `tbl_category_image`
--

CREATE TABLE IF NOT EXISTS `tbl_category_image` (
  `category_image_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_image_cat_id` int(11) NOT NULL,
  `category_image_name` varchar(150) NOT NULL,
  `category_image_title` varchar(100) NOT NULL,
  `category_image_add_date` date NOT NULL,
  `category_image_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`category_image_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `tbl_category_image`
--

INSERT INTO `tbl_category_image` (`category_image_id`, `category_image_cat_id`, `category_image_name`, `category_image_title`, `category_image_add_date`, `category_image_status`) VALUES
(1, 1, 'door-frames-3.jpg', '', '2019-06-26', 'Active'),
(2, 1, 'door-frames-2.jpg', '', '2019-06-26', 'Active'),
(3, 2, 'wall-paneling-1.jpg', '', '2019-06-26', 'Active'),
(4, 2, 'wall-paneling-2.jpg', '', '2019-06-26', 'Active'),
(5, 2, 'wall-paneling-3.jpg', '', '2019-06-26', 'Active'),
(6, 3, 'skirting-cornice.jpg', '', '2019-06-26', 'Active'),
(7, 4, 'front-elevation-2.jpg', '', '2019-06-26', 'Active'),
(8, 4, 'front-elevation-1.jpg', '', '2019-06-26', 'Active'),
(9, 4, 'front-elevation-4.jpg', '', '2019-06-26', 'Active'),
(10, 7, 'front-elevation-7.jpg', '', '2019-06-27', 'Active'),
(11, 7, 'front-elevation-11.jpg', '', '2019-06-27', 'Active');

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

--
-- Table structure for table `tbl_certificate`
--

CREATE TABLE IF NOT EXISTS `tbl_certificate` (
  `certificate_id` int(11) NOT NULL AUTO_INCREMENT,
  `certificate_image_name` varchar(100) NOT NULL,
  `certificate_add_date` date NOT NULL,
  `certificate_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`certificate_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_certificate`
--

INSERT INTO `tbl_certificate` (`certificate_id`, `certificate_image_name`, `certificate_add_date`, `certificate_status`) VALUES
(1, 'download.jpg', '2019-06-27', 'Active'),
(2, 'download.png', '2019-06-27', 'Active');

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

--
-- Table structure for table `tbl_client_logo`
--

CREATE TABLE IF NOT EXISTS `tbl_client_logo` (
  `client_logo_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_logo_image_name` varchar(100) NOT NULL,
  `client_logo_add_date` date NOT NULL,
  `client_logo_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`client_logo_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_client_logo`
--

INSERT INTO `tbl_client_logo` (`client_logo_id`, `client_logo_image_name`, `client_logo_add_date`, `client_logo_status`) VALUES
(1, '3.jpg', '2019-06-26', 'Active'),
(2, '1.jpg', '2019-06-26', 'Active'),
(3, '2.jpg', '2019-06-26', 'Active');

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

--
-- Table structure for table `tbl_country`
--

CREATE TABLE IF NOT EXISTS `tbl_country` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_code` varchar(10) DEFAULT NULL,
  `country_name` varchar(100) DEFAULT NULL,
  `country_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`country_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_country`
--


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

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

CREATE TABLE IF NOT EXISTS `tbl_enquiry` (
  `enquiry_id` int(11) NOT NULL AUTO_INCREMENT,
  `enquiry_name` varchar(100) NOT NULL,
  `enquiry_comp_name` varchar(100) NOT NULL,
  `enquiry_mobile` varchar(50) NOT NULL,
  `enquiry_email` varchar(100) NOT NULL,
  `enquiry_address` varchar(200) NOT NULL,
  `enquiry_subject` varchar(100) NOT NULL,
  `enquiry_detail` varchar(400) NOT NULL,
  `enquiry_source` varchar(50) NOT NULL,
  `enquiry_add_date` date NOT NULL,
  `enquiry_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`enquiry_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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


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

--
-- Table structure for table `tbl_gallery`
--

CREATE TABLE IF NOT EXISTS `tbl_gallery` (
  `gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_image_name` varchar(100) NOT NULL,
  `gallery_image_title` varchar(150) NOT NULL,
  `gallery_add_date` date NOT NULL,
  `gallery_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`gallery_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_gallery`
--

INSERT INTO `tbl_gallery` (`gallery_id`, `gallery_image_name`, `gallery_image_title`, `gallery_add_date`, `gallery_status`) VALUES
(1, 'ceiling-strip.jpg', '', '2019-06-26', 'Active'),
(2, 'ado-doors.jpg', '', '2019-06-26', 'Active');

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

--
-- Table structure for table `tbl_header`
--

CREATE TABLE IF NOT EXISTS `tbl_header` (
  `header_id` int(11) NOT NULL AUTO_INCREMENT,
  `header_logo` varchar(100) NOT NULL,
  `header_welcome_image` varchar(100) NOT NULL,
  `header_add_date` date NOT NULL,
  `header_status` enum('Active','Inactive') NOT NULL,
  PRIMARY KEY (`header_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_header`
--

INSERT INTO `tbl_header` (`header_id`, `header_logo`, `header_welcome_image`, `header_add_date`, `header_status`) VALUES
(1, 'ado-wood-logo.png', '', '2019-06-25', 'Active');

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

--
-- Table structure for table `tbl_header_flash`
--

CREATE TABLE IF NOT EXISTS `tbl_header_flash` (
  `header_flash_id` int(11) NOT NULL AUTO_INCREMENT,
  `header_flash_image_name` varchar(100) NOT NULL,
  `header_flash_title` varchar(100) NOT NULL,
  `header_flash_type` varchar(50) NOT NULL,
  `header_flash_add_date` date NOT NULL,
  `header_flash_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`header_flash_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_header_flash`
--

INSERT INTO `tbl_header_flash` (`header_flash_id`, `header_flash_image_name`, `header_flash_title`, `header_flash_type`, `header_flash_add_date`, `header_flash_status`) VALUES
(3, 'calltoaction-2.jpg', '', 'Main', '2019-06-26', 'Active'),
(5, 'calltoaction.jpg', '', 'Main', '2019-06-26', 'Active');

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

--
-- Table structure for table `tbl_job_opening`
--

CREATE TABLE IF NOT EXISTS `tbl_job_opening` (
  `job_opening_id` int(11) NOT NULL AUTO_INCREMENT,
  `job_opening_title` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `job_opening_description` text COLLATE utf8_unicode_ci NOT NULL,
  `job_opening_status` enum('Active','Inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Inactive',
  `job_opening_add_date` date NOT NULL,
  PRIMARY KEY (`job_opening_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_job_opening`
--


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

--
-- Table structure for table `tbl_press_realeases`
--

CREATE TABLE IF NOT EXISTS `tbl_press_realeases` (
  `press_rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `press_rel_date` date NOT NULL,
  `press_rel_name` varchar(100) NOT NULL,
  `press_rel_type` varchar(100) NOT NULL,
  `press_rel_url` varchar(100) NOT NULL,
  `press_headline_url` varchar(100) NOT NULL,
  `press_rel_desc` text NOT NULL,
  `press_rel_image` varchar(100) NOT NULL,
  `press_rel_add_date` date NOT NULL,
  `press_rel_status` enum('Active','Inactive') NOT NULL DEFAULT 'Inactive',
  PRIMARY KEY (`press_rel_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_press_realeases`
--

INSERT INTO `tbl_press_realeases` (`press_rel_id`, `press_rel_date`, `press_rel_name`, `press_rel_type`, `press_rel_url`, `press_headline_url`, `press_rel_desc`, `press_rel_image`, `press_rel_add_date`, `press_rel_status`) VALUES
(1, '0000-00-00', 'Every day I Supply Oxygen', 'Print Media', '', 'Save Tress', '<p>Canada with 318 billion trees and Brazil with 302 billion. The United Statescomes in fourth with 228 billion trees. Other countries with significant tree wealth include China (140 billion), the Democratic Republic of the Congo (100 billion),Indonesia (81 billion) and Australia (77 billion)........</p>\r\n\r\n<p><strong>Where as ............</strong></p>\r\n\r\n<p>Among highly populous countries, India (population,1.267 billion) has a tree population of only 35 billion, leading to just 28 trees per person. Compared to Brazil which has 301 billion trees (1,494 per person), Canada 318 billion (8,953 per person), and China 139 billion (102 trees per person)........</p>\r\n\r\n<p><strong>lets save tree..............</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Established in 2001,<strong>&nbsp;Ado woods&nbsp;</strong>is a leading manufacturer of wood plastic composite (wpc) products. Revolutionising today&#39;s furniture scenario, Ado woods has launched its new product &quot;WPC door frames&quot; which are not only more eco friendly as compared to timber, but also more durable than wooden furniture . WPC don&#39;t corrode and are highly resistant to rot, decay and marine borer attack, though they do absorb water into the wood fibers embedded with in the material. They have good workability and can be shaped using conventional wood working tools.WPC are often considered a sustainable material because they can be made using recycled plastics and the waste products of the wood industry. One advantage over wood is the ability of the material to be molded to meet almost any desired shape. A WPC member can be bent and fixed to form strong arching curves. Another major selling point of these material is their lack of need for paint. They are manufactured in a variety of. Colours but are widely available in grays and earth tones. Despite up to 70per. Cellulose content the mechanical behaviour of wpc is most similar to neat polymers. Neat polymers are polymerized without added solvents. This means that WPCs have a lower strength and stiffness than wood, and they experience time and temperature dependent behaviour.It is possible that the strength and stiffness may be reduced by moisture absorption and freeze thaw cycling. WPC is eco friendly, so you no longer have to be guilty of the fact that you are cutting trees to make your furniture . Save the environment with WPC and be proud it.</p>\r\n\r\n<p><strong>&quot;The rain forests are the green lungs of our world &quot;.</strong><br />\r\nWe show that environment protection and economic success can go hand in hand. And in some ways it&#39;s better than the real thing we developed a weather and water resistant material which truly has the noble look and feel of wood.And it doesn&#39;t splinter or rot over time.</p>\r\n\r\n<p><strong>We are simply saving a precious resource &quot;&quot;TREES&quot;&quot;!!!!!!</strong><br />\r\nAs a manufacturer AVS is an ISO 9001-2008certified company dealing in international trade, flexible packing , wall paneling ( outdoors and indoors) and wpc flooring.Also approved by the international body Be Green Consortium,AVS has received both domestic and foreign acclaim. Committed to providing quality products that need no aftercare , whatsoever, AVS gives away a limited warranty of upto 25 years on Ado Woods WPC door frames. The product comes with a limited warranty of 15 years against abrasion. The laminate flooring is warrantied for 25 years against fading ,staining and wearing through.</p>', '', '2019-06-26', 'Active'),
(2, '0000-00-00', 'Why everyone should go for WPC (Wood Plastic Composite)?', 'Print Media', '', 'Benifites of WPC', '<p>WPC is one of the revolutionary alternative that is formed with the composition of various materials like Wood, Plastic, dust, bamboo dust etc. The best part of the WPC is that it makes of recycled material and the WPC itself can recycled again to make different patterns.</p>\r\n\r\n<p>Some more attributes of WPC:</p>\r\n\r\n<ul>\r\n	<li>1) It has the property to be Resistant to corrosion. It never corrode.</li>\r\n	<li>2) It has water proof property plus moisture proof</li>\r\n	<li>3) It is Environmentally friendly. Now we can save trees actually by adopting WPC.</li>\r\n	<li>4) WPC don&#39;t catches Fire which makes it fire resistant</li>\r\n	<li>5) Termite proof guarantee</li>\r\n	<li>6) Durable and stronger than Wood</li>\r\n</ul>\r\n\r\n<p>Where you can use it:</p>\r\n\r\n<ul>\r\n	<li>1) Fencing outside your home, farmhouse etc.</li>\r\n	<li>2) Wall Ceilings</li>\r\n	<li>3) Wall panelling</li>\r\n	<li>4) Flooring in offices, home, Malls, game zones, other utility areas and Many more.</li>\r\n</ul>', '', '2019-06-26', 'Active');

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

--
-- Table structure for table `tbl_site_pages`
--

CREATE TABLE IF NOT EXISTS `tbl_site_pages` (
  `site_pages_id` int(11) NOT NULL AUTO_INCREMENT,
  `site_pages_name` varchar(100) NOT NULL,
  `site_pages_link` varchar(80) NOT NULL,
  `site_pages_show_in_header` enum('Yes','No') NOT NULL DEFAULT 'No',
  `site_pages_show_in_footer` enum('Yes','No') NOT NULL DEFAULT 'No',
  `site_pages_url` varchar(100) NOT NULL,
  `site_pages_image_name` varchar(300) NOT NULL,
  `site_pages_meta_title` varchar(200) NOT NULL,
  `site_pages_meta_description` varchar(200) NOT NULL,
  `site_pages_meta_keyword` varchar(500) NOT NULL,
  `site_pages_description` text NOT NULL,
  `site_pages_order_by` int(11) NOT NULL,
  `site_pages_add_date` date NOT NULL,
  `site_pages_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`site_pages_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tbl_site_pages`
--

INSERT INTO `tbl_site_pages` (`site_pages_id`, `site_pages_name`, `site_pages_link`, `site_pages_show_in_header`, `site_pages_show_in_footer`, `site_pages_url`, `site_pages_image_name`, `site_pages_meta_title`, `site_pages_meta_description`, `site_pages_meta_keyword`, `site_pages_description`, `site_pages_order_by`, `site_pages_add_date`, `site_pages_status`) VALUES
(1, 'home', 'index', 'Yes', 'Yes', 'home', '', 'meta title for home page in adowoods', 'ADO WOODS is one of the best Companies in India to manufacturer of Waterproof Chokhat and Louvers in Gwalior Madhya Pradesh India, we manufacture Waterproof Chokhat and Louvers in low cost.', 'waterproof chokhat manufacturer in gwalior madhya pradesh india, louvers manufacturer in gwalior madhya pradesh india, wpc door frame manufacturer in gwalior madhya pradesh india, artificial wood manufacturer in gwalior madhya pradesh india, digital wall panel manufacturer in gwalior madhya pradesh india, wpc wall panel manufacturer in gwalior madhya pradesh india, wpc window frame manufacturer in gwalior madhya pradesh india', '', 1, '0000-00-00', 'Active'),
(2, 'blog', 'blog', 'Yes', 'Yes', 'blog', '', 'meta title for blog page in adowoods', 'meta description for blog page in adowoods', 'meta keyword for blog page in adowoods', '', 8, '0000-00-00', 'Inactive'),
(3, 'products', 'products', 'Yes', 'Yes', 'products', '', 'meta title for products page', 'ADO WOODS manufacture best quality Artificial Wood and Wood Cladding in Madhya Pradesh India, we manufacture Artificial Wood and Wood Cladding in affordable cost.', 'artificial wood manufacturer in gwalior madhya pradesh india, wood cladding manufacturer in gwalior india, wood facade manufacturer in gwalior madhya pradesh india, wpc ceiling manufacturer in gwalior madhya pradesh india, wpc gate manufacturer in gwalior india, manufacturer of waterproof chokhat in gwalior madhya pradesh india, manufacturer of wpc door frame in gwalior madhya pradesh india, manufacturer of digital wall panel in gwalior madhya pradesh india', '', 3, '0000-00-00', 'Active'),
(4, 'gallery', 'gallery', 'Yes', 'Yes', 'gallery', '', 'meta title for gallery page', 'meta description for gallery page', 'meta keyword for gallery page', '', 4, '0000-00-00', 'Active'),
(5, 'how-to-buy', 'how-to-buy', 'Yes', 'Yes', 'how-to-buy', '', 'meta title for how to buy page', 'Whenever You Have Any Enquiry You Can Contact ADO WOODS - How to Buy', 'Whenever You Have Any Enquiry You Can Contact ADO WOODS - How to Buy', '', 5, '0000-00-00', 'Active'),
(6, 'about-us', 'about-us', 'Yes', 'Yes', 'about-us', 'about-us.jpg', 'WPC Door Frame | WPC Gate | Manufacturer in Gwalior Madhya Pradesh', 'ADO WOODS Company is the best WPC Door Frame and WPC Gate Manufacturer in Gwalior Madhya Pradesh India, We manufacture best quality WPC Door Frame and WPC Gate in reasonable cost.', 'wpc door frame manufacturer in gwalior madhya pradesh, wpc gate manufacturer in gwalior madhya pradesh, waterproof wood manufacturer in gwalior madhya pradesh, wood cladding manufacturer in gwalior madhya pradesh india, exterior wood manufacturer in gwalior madhya pradesh india, wpc front elevation manufacturer in gwalior madhya pradesh india, termite proof wood manufacturer in gwalior madhya pradesh india', '<p>Founded in the year 2001 AVS has set up new standards of success. We are the most reckoned name as the wood plastic composite Manufacturer in India. The wood plastic composite fabricated at AVS is an artificial wood, which is first of its kind in India. We also manufacture high class packaging films for use in various industries.</p>\r\n\r\n<p>Being a monetarily and mechanically sovereign association, ADO WOODS. has seen the exceptional advancement and extension in this aggressive industry., we are ably serving to our profoundly respected customers by bringing in, providing, and exchanging a broad range of Laminated Wooden Flooring, WPC Wall Panels, PVC Wall Panel, Artificial Grass, WPC Decking Floor and Cladding and WPC Pergola. Our items are profoundly valued by customers for their quality and consistency. Our customers consistency of rumored association, developers, emergency clinics, schools, showrooms, private, condos, home and farmhouses.</p>\r\n\r\n<p>Our appropriation office houses a quality confirmation office, which guarantees that the secured building development material is produced using predominant evaluation crude materials. The quality affirmation division guarantees that the sourced, materials are consistently measured and thickened. Also, our wholesaled, development material is generally utilized at the common development extends in urban and country territories. Furthermore, our demographic incorporates building development organizations, the nation over.</p>\r\n\r\n<p>In the short span AVS has become an established name and having annual turnover in two digit Cr. We owe our feat of success in business to the trust of our valued clients and devote our heartfelt gratitude to them and promise to be committed towards delivering best products. WPC material manufactured by us is first of its kind in India. These composites are termite proof and water proof and ensure longevity.</p>\r\n\r\n<p>We manufacture an optimum end product: Wood Plastic Composites granules with reproducible quality affecting a wide material spectrum at low cost. The granule produced, is further processed in additional production processes such as extrusion, roto-molding, pressing, etc into high quality end products. AVS is reckoned as the leading WPC manufacturer. The wood plastic composites are used in the fabrication of walls for interior and exterior and wooden flooring. These composites are sturdy in composition and are long lasting due to its highly durable raw materials.</p>\r\n\r\n<p>The objective and corporate philosophy of the company has been to provide high grade Wood-plastic composites and premium quality flexible packaging films through optimum use of resources by building and maintaining a team of motivated and committed work force which meets professional and human standards of excellence</p>\r\n\r\n<p>We have sufficient testing labs with latest machinery for checking micron, tensile strength, dimension, colour etc. We employ cutting edge technology and state of art machines in the manufacturing of WPC and Packaging Films material.</p>', 2, '0000-00-00', 'Active'),
(7, 'contact-us', 'contact-us', 'Yes', 'Yes', 'contact-us', '', 'meta title for contact us page', 'Contact us via email, Phone, address and Get the complete detail about Waterproof Chokhat, WPC Door Frame and Artificial Wood with acceptable price in Gwalior Madhya Pradesh India.', 'Contact ADO WOODS, customer care ADO WOODS, online support ADO WOODS', '', 6, '0000-00-00', 'Active'),
(8, 'sitemap', 'site-map', 'No', 'Yes', 'sitemap', '', 'meta title of site map', 'meta description of site map', 'meta keyword of site map', '', 7, '0000-00-00', 'Inactive');

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

--
-- Table structure for table `tbl_testimonial`
--

CREATE TABLE IF NOT EXISTS `tbl_testimonial` (
  `test_id` int(11) NOT NULL AUTO_INCREMENT,
  `test_given_by` varchar(100) NOT NULL,
  `test_image_name` varchar(300) NOT NULL,
  `test_comp_name` varchar(400) NOT NULL,
  `test_description` text NOT NULL,
  `test_add_date` date NOT NULL,
  `test_status` enum('Active','Inactive') NOT NULL DEFAULT 'Inactive',
  PRIMARY KEY (`test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_testimonial`
--


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

--
-- Table structure for table `tbl_video`
--

CREATE TABLE IF NOT EXISTS `tbl_video` (
  `video_id` int(11) NOT NULL AUTO_INCREMENT,
  `video_title` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `video_clip` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `video_link` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'www.google.com',
  `video_add_date` date NOT NULL,
  `video_status` enum('Active','Inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`video_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_video`
--

INSERT INTO `tbl_video` (`video_id`, `video_title`, `video_clip`, `video_link`, `video_add_date`, `video_status`) VALUES
(1, 'samsung', 'Geqjvl7x3PA', 'www.google.com', '2019-06-26', 'Active'),
(2, 'samsung refrigerator', '6jcclMDjb_8', 'www.google.com', '2019-06-26', 'Active');

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