
--
-- Table structure for table `productgallery_tbl`
--

CREATE TABLE `productgallery_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) NOT NULL,
  `product_code` varchar(700) NOT NULL,
  `product_image` varchar(500) NOT NULL,
  `product_alt` varchar(500) NOT NULL,
  `product_desc` text NOT NULL,
  `product_metatitle` varchar(300) NOT NULL,
  `product_metadesc` varchar(800) NOT NULL,
  `product_metakeyword` varchar(800) NOT NULL,
  `product_cat` varchar(400) NOT NULL,
  `prodcut_subcat` varchar(400) NOT NULL,
  `product_subsubcat` varchar(400) NOT NULL,
  `product_date` varchar(400) NOT NULL,
  `prodcut_status` int(11) NOT NULL DEFAULT '0',
  `product_finalcat` varchar(600) NOT NULL,
  `product_min_order` varchar(400) NOT NULL,
  `product_supply` varchar(600) NOT NULL,
  `product_origin` varchar(600) NOT NULL,
  `product_pterms` varchar(600) NOT NULL,
  `product_price` varchar(600) NOT NULL,
  `product_swearType` varchar(100) NOT NULL,
  `product_supplyType` varchar(100) NOT NULL,
  `product_Gender` varchar(100) NOT NULL,
  `product_ageGroup` varchar(100) NOT NULL,
  `product_size` varchar(100) NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productgallery_tbl`
--


--
-- Table structure for table `safe_business_tbl`
--

CREATE TABLE `safe_business_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `person_city` varchar(1000) DEFAULT NULL,
  `description` longtext NOT NULL,
  `sbtOrder` int(11) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `safe_business_tbl`
--

INSERT INTO `safe_business_tbl` VALUES (1,'Saurav Shukla','','I’m thrilled with the carved bed I got from {companyName}. The detail and craftsmanship are exceptional, adding a touch of elegance to my bedroom. Highly recommend!',1,'2024-09-12','Y',''),(2,'Neha Dayani','','The carved sofa set from {companyName} is a game changer for my living room. It’s not only beautiful but also incredibly comfortable. I’m absolutely delighted!',2,'2024-09-12','Y',''),(3,'Koel Singh','','I love the wooden center table from {companyName}. It’s stylish and solid, making my living space look sophisticated. The quality and service were outstanding.',3,'2024-09-12','Y',''),(4,'Abhinav Mukherjee','','The wooden door I purchased from {companyName} is fantastic. It has a rich finish and feels very sturdy. It’s a perfect addition to my home. Highly satisfied! ',4,'2024-09-12','Y',''),(5,'Jai Kumar','','The wooden swing from {companyName} is gorgeous and comfortable. It’s become a favorite spot in my garden. I’m so impressed with the craftsmanship and service!',5,'2024-09-12','Y','');

--
-- Table structure for table `slink_tbl`
--

CREATE TABLE `slink_tbl` (
  `slink_id` int(11) NOT NULL AUTO_INCREMENT,
  `slink_icon` varchar(700) NOT NULL,
  `slink_url` varchar(800) NOT NULL,
  PRIMARY KEY (`slink_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slink_tbl`
--


--
-- Table structure for table `sponsor_banner_tbl`
--

CREATE TABLE `sponsor_banner_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `memberID` int(11) NOT NULL DEFAULT '0',
  `bannerPosition` varchar(50) NOT NULL,
  `bannerUrl` varchar(80) NOT NULL DEFAULT '',
  `bannerImage` varchar(50) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sponsor_banner_tbl`
--


--
-- Table structure for table `sponsor_tbl`
--

CREATE TABLE `sponsor_tbl` (
  `slno` int(11) NOT NULL AUTO_INCREMENT,
  `memberID` int(11) NOT NULL,
  `sponsoredCategories` varchar(250) NOT NULL,
  `sponsorDuration` int(11) NOT NULL,
  `sponsorStatus` char(1) NOT NULL DEFAULT 'N',
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `recvDate` date NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sponsor_tbl`
--


--
-- Table structure for table `standard_meta_tags_pages`
--

CREATE TABLE `standard_meta_tags_pages` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `standard_meta_tags_pages`
--


--
-- Table structure for table `static_pages`
--

CREATE TABLE `static_pages` (
  `pageID` int(11) NOT NULL AUTO_INCREMENT,
  `pageBanner` varchar(500) DEFAULT NULL,
  `pageImage` varchar(500) DEFAULT NULL,
  `pageTitle` varchar(255) NOT NULL DEFAULT '',
  `pageDesc` text NOT NULL,
  `pageDesc1` longtext NOT NULL,
  `pageDesc2` longtext,
  `status` char(1) NOT NULL DEFAULT 'Y',
  `page_metatitle` varchar(500) NOT NULL,
  `page_keyword` varchar(500) NOT NULL,
  `page_metadesc` text NOT NULL,
  `keyword1` varchar(500) DEFAULT NULL,
  `keyword2` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`pageID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `static_pages`
--

INSERT INTO `static_pages` VALUES (1,'banner25.jpg','image25.jpg','Home','<p>Welcome to {companyName}, where we take pride in our extensive collection of beautifully crafted wooden furniture, designed to elevate your living spaces with timeless elegance. Our dedication to quality and craftsmanship positions us as the leading provider of the <strong>Top Designer Wooden Bed in Saharanpur</strong>. Each of our designer beds is a testament to our commitment to excellence, featuring intricate designs and superior materials that blend seamlessly with any decor. From classic to contemporary styles, our beds are meticulously crafted to ensure not only a stunning visual appeal but also lasting durability. We use high-quality wood and cutting-edge techniques to create beds that are as functional as they are beautiful, making them a perfect centerpiece for your bedroom.</p>\r\n\r\n<h2>Get Premium Products Directly from Top Designer Wooden Bed Manufacturers in Saharanpur</h2>\r\n\r\n<p>Our manufacturing process is characterized by meticulous attention to detail and a passion for craftsmanship. Each piece is crafted by skilled artisans who bring years of experience and expertise to their work, ensuring that every bed meets our exacting standards. We understand that a well-designed bed is crucial to creating a comfortable and stylish bedroom, and our products are designed to meet both aesthetic and practical needs. As one of the <strong>Top Designer Wooden Bed Manufacturers in Saharanpur</strong>, we are committed to offering a wide range of options that cater to diverse tastes and preferences. By combining traditional techniques with modern design, we offer beds that not only enhance the beauty of your home but also provide enduring comfort.</p>\r\n\r\n<h3>Looking for Wooden Partition Suppliers in Uttar Pradesh?</h3>\r\n\r\n<p>Beyond our exceptional beds, we are also a leading name in wooden partitions, offering stylish and practical solutions for various interior needs. As reputable <strong>Wooden Partition Suppliers in Uttar Pradesh</strong>, we provide a range of partition designs that help define and organize spaces effectively. Our wooden partitions are crafted from high-quality materials, ensuring they are both durable and aesthetically pleasing. Whether you&#39;re looking to create private areas in a commercial setting or add a touch of elegance to your home, our partitions are designed to meet your needs with sophistication and functionality. Each partition is crafted to enhance the versatility of your space while maintaining a high standard of craftsmanship.</p>\r\n\r\n<h3>Most Trusted Wooden Partition Exporters in Uttar Pradesh</h3>\r\n\r\n<p>We handle every aspect of the export process with precision, ensuring that our products reach international clients with the same level of quality and care as they do locally. Our commitment to maintaining high standards and timely delivery ensures that our wooden partitions are well-received across various markets. In addition to serving the local market, {companyName} is also a prominent player in the international arena as <strong>Wooden Partition Exporters in Uttar Pradesh</strong>. By expanding our reach beyond local borders, we aim to bring our exceptional craftsmanship and elegant designs to a global audience, further solidifying our reputation as a leading provider of fine wooden furniture and partitions.</p>\r\n','<p>Ace Wood Crafts</p>\r\n','','Y','','','','Top Designer Wooden Bed','Wooden Partition'),(2,'banner33.jpg','image50.jpg','About us','<p>Since our <strong>Inception in 1996</strong>, {companyName} has built a reputation for excellence in the wooden furniture industry under the expert leadership of <strong>Mr.</strong> <strong>Mohammad Farhan Ahmad</strong>. What started as a modest workshop has evolved into a distinguished enterprise, recognized for its superior craftsmanship and innovative designs. Our commitment to blending traditional woodworking techniques with modern aesthetics has earned us a prestigious spot among the <strong>Top 5 Luxury Sofa Set Manufacturers in Saharanpur</strong>. We take immense pride in offering an extensive range of finely crafted furniture, including luxurious sofa sets, sophisticated dining tables, and multifunctional sofa beds. Each product is meticulously designed to enhance both the beauty and functionality of any space, reflecting our dedication to quality and design.</p>\r\n\r\n<p>Our focus on quality is evident in every piece of furniture we create. We source only the finest materials, such as solid teak and sheesham wood, known for their durability and timeless elegance. These premium woods are selected to ensure that our furniture not only meets high standards of craftsmanship but also stands the test of time. Our skilled artisans employ a combination of traditional techniques and contemporary methods to achieve detailed carvings and modern finishes. This meticulous approach ensures that each piece is a true work of art, combining functionality with aesthetic appeal. As a trusted supplier and exporter, we are dedicated to upholding rigorous quality standards and delivering exceptional service. From the initial design phase to the final delivery, we ensure that our products meet our clients&rsquo;s exact expectations. Experience the unmatched quality and elegance of {companyName}&rsquo; furniture and discover why we are the preferred choice for clients seeking high-quality, beautifully crafted wooden furnishings.</p>\r\n','<p>Since our Inception in 1996, {companyName} has built a reputation for excellence in the wooden furniture industry under the expert leadership of Mr. Mohammad Farhan Ahmad. What started as a modest workshop has evolved into a distinguished enterprise, recognized for its superior craftsmanship and innovative designs.</p>\r\n','','Y','Top 5 Luxury Sofa Set Manufacturer in Saharanpur, Uttar Pradesh, India | Ace Wood Crafts','Luxury Sofa Set Manufacturer, Luxury Sofa Set Manufacturer in Saharanpur, Top 5 Luxury Sofa Set Manufacturer, Wholesale Luxury Sofa Set Saharanpur','Ace Wood Crafts - Top 5 Luxury Sofa Set Manufacturer Saharanpur (Uttar Pradesh), India, Wholesale Supplier, Exporter ✓ Factory Price. Call +91-9997595553.','',''),(4,NULL,'image04.jpg','Our Infrastructure','','<p>Our Infrastructure</p>\r\n',NULL,'Y','Our Infrastructure','Our Infrastructure','Our Infrastructure',NULL,NULL),(3,'banner54.jpg','image34.jpg','our founder','','<p>our founder</p>\r\n',NULL,'Y','our founder','our founder','our founder',NULL,NULL),(5,'banner11.jpg','image43.jpg','About Home Page','','<p>About DSK</p>\r\n',NULL,'Y','About DSK','About DSK','About DSK',NULL,NULL),(6,'banner29.jpg','','Privacy Policy','','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nemo similique corrupti, temporibus suscipit commodi sapiente blanditiis, maiores tempora quo ipsa inventore odio animi iusto ut, nesciunt architecto doloribus rem? Ratione.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nemo similique corrupti, temporibus suscipit commodi sapiente blanditiis, maiores tempora quo ipsa inventore odio animi iusto ut, nesciunt architecto doloribus rem? Ratione.</p>\r\n',NULL,'Y','Him Trail Adventure','Him Trail Adventure','Him Trail Adventure',NULL,NULL);

--
-- Table structure for table `subcontent_tbl`
--

CREATE TABLE `subcontent_tbl` (
  `subcontent_id` int(11) NOT NULL AUTO_INCREMENT,
  `subcontent_cat` varchar(400) NOT NULL,
  `subcontent_subcat` varchar(800) NOT NULL,
  `subcontent_desc` longtext,
  `subcontent_metatitle` text NOT NULL,
  `subcontent_mrtakey` text NOT NULL,
  `subcontent_metadesc` text NOT NULL,
  `subcontent_country` varchar(700) NOT NULL,
  `subcontent_date` varchar(300) NOT NULL,
  `short_desc` varchar(500) NOT NULL,
  `prodcut_subcat` varchar(200) NOT NULL,
  `product_subsubcat` varchar(200) NOT NULL,
  `product_finalcat` int(11) NOT NULL,
  `location` varchar(1000) NOT NULL,
  `product_subsubsubcat` varchar(1000) NOT NULL,
  PRIMARY KEY (`subcontent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subcontent_tbl`
--


--
-- Table structure for table `subdomainmetatag_pages`
--

CREATE TABLE `subdomainmetatag_pages` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `catDesc1` text NOT NULL,
  `catDesc` text NOT NULL,
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subdomainmetatag_pages`
--


--
-- Table structure for table `tbl_corder`
--

CREATE TABLE `tbl_corder` (
  `corder_id` int(11) NOT NULL AUTO_INCREMENT,
  `corder_name` varchar(600) NOT NULL,
  `corder_email` varchar(200) NOT NULL,
  `corder_mobile` varchar(100) NOT NULL,
  `corder_country` varchar(300) NOT NULL,
  `corder_product` varchar(500) NOT NULL,
  `corder_artwork` varchar(300) NOT NULL,
  `corder_plname` varchar(600) NOT NULL,
  `corder_plno` varchar(200) NOT NULL,
  `corder_plsize` varchar(300) NOT NULL,
  `corder_plqty` varchar(500) NOT NULL,
  `corder_date` varchar(200) NOT NULL,
  PRIMARY KEY (`corder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_corder`
--


--
-- Table structure for table `team_group_tbl`
--

CREATE TABLE `team_group_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team_group_tbl`
--


--
-- Table structure for table `team_tbl`
--

CREATE TABLE `team_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) DEFAULT NULL,
  `team_group_id` varchar(20) DEFAULT NULL,
  `image` varchar(400) DEFAULT NULL,
  `short_description` text,
  `description` text,
  `designation` varchar(300) DEFAULT NULL,
  `facebook_link` varchar(500) DEFAULT NULL,
  `experience` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  `twitter_link` varchar(500) DEFAULT NULL,
  `instagram_link` varchar(500) DEFAULT NULL,
  `linkedin_link` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team_tbl`
--


--
-- Table structure for table `technology_tbl`
--

CREATE TABLE `technology_tbl` (
  `technology_id` int(200) NOT NULL AUTO_INCREMENT,
  `technology_name` varchar(500) NOT NULL,
  `technology_detail` varchar(200) NOT NULL,
  `technology_images` varchar(200) NOT NULL,
  PRIMARY KEY (`technology_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `technology_tbl`
--


--
-- Table structure for table `testimonial_tbl`
--

CREATE TABLE `testimonial_tbl` (
  `slno` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `image` varchar(60) NOT NULL,
  `email` varchar(80) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `addedBy` varchar(10) NOT NULL,
  `recvDate` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) NOT NULL DEFAULT 'N',
  `replyStatus` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`slno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial_tbl`
--


--
-- Table structure for table `transplant_result_tbl`
--

CREATE TABLE `transplant_result_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(500) DEFAULT NULL,
  `gallery_image` varchar(500) DEFAULT NULL,
  `description` text,
  `image_name` varchar(400) DEFAULT NULL,
  `gallery_order` varchar(300) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transplant_result_tbl`
--


--
-- Table structure for table `video_tbl`
--

CREATE TABLE `video_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slink_title` varchar(700) NOT NULL,
  `slink_url` varchar(800) NOT NULL,
  `gallery_id` int(11) DEFAULT NULL,
  `gallery_cat` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `video_tbl`
--

INSERT INTO `video_tbl` VALUES (1,'Exquisite Teak Wood Sofa Set | Handcrafted Luxury Furniture by Ace Wood Crafts | Global Delivery','KV7uccIzLfg',2,'Select Category','2024-10-01 11:40:40','2024-10-01 11:40:40'),(2,'22 Wooden Handmade Customized Carved Bed Design made in Teak Wood in Ace Wood Crafts Saharanpur','4Ubzvs606-8',2,'Select Category','2024-10-01 11:42:18','2024-10-01 06:16:19'),(3,'24 Handcrafted Wooden Pillar /Baluster Made in sheesham wood customized in Ace Wood Crafts','CCfB1LFRQdg',2,'Select Category','2024-10-01 11:44:16','2024-10-01 06:15:38'),(4,'','',2,'Select Category','2024-11-16 15:29:31','2024-11-16 15:29:31'),(6,'Polishing Process of Handcrafted Wooden Pillar | 30x2.5x2.5 Inch | Ace Wood Crafts','CgSCK16oodc',2,'2','2024-12-05 07:34:24','2024-12-05 07:34:24'),(9,'Timeless Teakwood Carved Furniture: Luxury Craftsmanship by Ace Wood Crafts','7BBgDbFoV-k',2,'2','2024-12-05 08:44:39','2024-12-05 08:44:39');

--
-- Table structure for table `whatsapp_enquiry`
--

CREATE TABLE `whatsapp_enquiry` (
  `en_id` int(11) NOT NULL AUTO_INCREMENT,
  `en_name` varchar(800) DEFAULT NULL,
  `en_mobile` varchar(100) DEFAULT NULL,
  `en_email` varchar(100) DEFAULT NULL,
  `en_country` varchar(100) DEFAULT NULL,
  `en_comment` varchar(900) DEFAULT NULL,
  `en_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `en_url` varchar(500) DEFAULT NULL,
  `locationID` varchar(100) DEFAULT NULL,
  `en_product_name` varchar(300) DEFAULT NULL,
  `en_ip` varchar(300) DEFAULT NULL,
  `en_doc_name` varchar(300) DEFAULT NULL,
  `en_doc_id` varchar(300) DEFAULT NULL,
  `booking_date` varchar(300) DEFAULT NULL,
  `en_time` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`en_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whatsapp_enquiry`
--



