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

START TRANSACTION;



--
-- Database: `handy_hardy_10_4_2024`
--

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

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

CREATE TABLE `client_logo` (
  `client_logo_id` int(11) NOT NULL,
  `logo_image_name` varchar(300) NOT NULL,
  `logo_name` varchar(200) NOT NULL,
  `sub_logo_name` varchar(200) NOT NULL,
  `logo_link` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `header_flash`
--

CREATE TABLE `header_flash` (
  `header_id` int(11) NOT NULL,
  `flash_title` varchar(280) NOT NULL,
  `flash_sub_title` varchar(280) NOT NULL,
  `flash_sub_sub_title` text NOT NULL,
  `flash_link` text NOT NULL,
  `header_image_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `header_flash`
--

INSERT INTO `header_flash` (`header_id`, `flash_title`, `flash_sub_title`, `flash_sub_sub_title`, `flash_link`, `header_image_name`) VALUES
(4, 'Best Quality Furniture Fittings & Solutions', 'Welcome To Handy Hardy', 'We are dedicated to providing you hardware products, with a focus on qaulity & price.                              ', '#', '1705552718_slider-1.3.jpg'),
(5, 'Put the Finishing Touch On <BR>Your Cabinets & Drawers', 'Welcome To Handy Hardy', 'Welcome to Handy Hardy, your one source for all things related to furniture and kitchen Hardware.           ', '#', '1705552766_slider-1.4.jpg');

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

--
-- Table structure for table `tbl_about_us`
--

CREATE TABLE `tbl_about_us` (
  `id` int(11) NOT NULL,
  `about_desc` text NOT NULL,
  `tech_desc` text NOT NULL,
  `benifit` text NOT NULL,
  `grc_desc` text NOT NULL,
  `about_image` varchar(100) NOT NULL,
  `about_image1` varchar(200) NOT NULL,
  `ns_t1` varchar(200) NOT NULL,
  `ns_t2` varchar(200) NOT NULL,
  `ns_t3` varchar(200) NOT NULL,
  `ns_n1` text,
  `ns_n2` varchar(250) DEFAULT NULL,
  `ns_n3` varchar(250) NOT NULL,
  `tech_histry` longtext,
  `value` text NOT NULL,
  `why_title` varchar(300) NOT NULL,
  `why_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_about_us`
--

INSERT INTO `tbl_about_us` (`id`, `about_desc`, `tech_desc`, `benifit`, `grc_desc`, `about_image`, `about_image1`, `ns_t1`, `ns_t2`, `ns_t3`, `ns_n1`, `ns_n2`, `ns_n3`, `tech_histry`, `value`, `why_title`, `why_desc`) VALUES
(1, 'We Assure Customer satisfaction with <span> Personal Care</span>', '', '', '24', '1705575396_', '1685092441_', '', '', '', 'It is an ancient mystic science for designing and building.', 'Through art of design, we alters and moulds the elements of natural environment.', 'Through art of design, we alters and moulds the elements of natural environment.', '<p>Welcome to Handy Hardy, your one source for all things related to furniture and kitchen hardware. We are dedicated to providing you the with very best of above mentioned hardware products, with a focus on quality &amp; price.</p>\r\n\r\n<p>Founded Handy Hardy In 2000 by Mr. Surjeet Singh, Handy Hardy come a lone way from its beginings in New Delhi with more than 30 years of experience, Mr Inderjeet Singh drove the company with tons of research and spearheaded market with the passion to serve the best quality and the most competitive price to customers.</p>\r\n\r\n<p>In the year 2019 we launched the brand name Handy Hardy under the umbrella of handy Hardy offers you hardware for Furniture, Kitchen &amp; Wardrobe with the world&#39;s most advances technology (germany). We now serve customers from all over India and thrilled that we are able to take our passion in the from of this website.</p>\r\n\r\n<p><em>We hope our products serve you to the best of your application.3</em></p>\r\n', '', '', '');

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

--
-- Table structure for table `tbl_add_list`
--

CREATE TABLE `tbl_add_list` (
  `id` int(11) NOT NULL,
  `list_name` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_add_list`
--

INSERT INTO `tbl_add_list` (`id`, `list_name`) VALUES
(5, 'cladding panel'),
(6, 'BOUNDRY WALL'),
(7, 'BALUSTRADES'),
(8, 'COLUMN & CAPITALS'),
(9, 'CORNICE'),
(10, 'SCREENS & MASHRABIYAS'),
(11, 'DOMES'),
(12, 'ARCHITECTURAL MOULDING'),
(13, 'CEILINGS'),
(17, 'KIOSKS');

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

--
-- Table structure for table `tbl_adventure`
--

CREATE TABLE `tbl_adventure` (
  `adventure_id` int(11) NOT NULL,
  `adventure_image_name` varchar(255) NOT NULL,
  `adventure_name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_adventure`
--

INSERT INTO `tbl_adventure` (`adventure_id`, `adventure_image_name`, `adventure_name`) VALUES
(1, '1499673374_1498648762_1 (1).jpg', 'ATV RIDES'),
(2, '1498648809_2.jpg', 'ARSHERY/DART'),
(4, '1498650994_3.jpg', 'SWIMING POOL'),
(5, '1498649350_4.jpg', 'SUMO RESTLING SUIT'),
(6, '1498649382_5.jpg', 'PAINT BALL SETUP'),
(10, '1498649424_6.jpg', 'TREMPOLINE'),
(11, '1498649461_7.jpg', 'ZORBING BALL'),
(12, '1498649481_8.jpg', 'CAMONDO NETS');

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

--
-- Table structure for table `tbl_application`
--

CREATE TABLE `tbl_application` (
  `app_id` int(11) NOT NULL,
  `app_name` varchar(255) NOT NULL,
  `app_desc` text NOT NULL,
  `app_desc1` text NOT NULL,
  `app_home` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_application`
--

INSERT INTO `tbl_application` (`app_id`, `app_name`, `app_desc`, `app_desc1`, `app_home`) VALUES
(1, 'Grade SS 202', '<p>It is a section with good mechanical properties of corrosion resistance, AISI 202 stainless steel high temperature strength than steel, toughness of grade 202 at low temperatures is excellent, It do has good oxidation resistance, and maintain a high intensity. It is one of the most widely used precipitation hardening grades, and possesses good corrosion resistance, toughness, high harness, and strength. Stainless steel Grade 202 is widely used in architectural decoration, municipal engineering, guardrail, hotel facilities, shopping mall, vitreous armrest, public facilities, etc.</p>\r\n', '', 'Home'),
(3, 'Grade SS 301', '<p>An austenitic stainless steel, because of its ability to attain high strength &amp; ductility through moderate or severe cold working, can be used for automobile trims, conveyor belts, transportation cars such as railway coaches, metal fixtures for construction process, roof drainage products, storm door frames, etc.</p>\r\n', '', 'Home'),
(4, 'Grade SS 304', '<p>It is most widely used austenitic stainless steel. It has excellent corrosion resistance and forming characteristics, used in Chemicals, Petro-Chemicals &amp; Fertilizer Industries , &amp; as equipment in Dairy, Food processing, Pharmaceutical Industries, in Hospitals, Households as Kitchenware, Sinks, Cutlery, Cryogenic Vessels &amp; as Heat Exchange in Air-Conditioning, Refrigeration for machinery in paper, pulp, textile, etc.</p>\r\n', '', 'Home'),
(5, 'Grade SS 304', '<p>It is most widely used austenitic stainless steel. It has excellent corrosion resistance and forming characteristics, used in Chemicals, Petro-Chemicals &amp; Fertilizer Industries , &amp; as equipment in Dairy, Food processing, Pharmaceutical Industries, in Hospitals, Households as Kitchenware, Sinks, Cutlery, Cryogenic Vessels &amp; as Heat Exchange in Air-Conditioning, Refrigeration for machinery in paper, pulp, textile, etc.</p>\r\n', '', 'Home'),
(6, 'Grade SS 304L', '<p>It is used in place of SS 304 for improved resistance to intergranular corrosion. It is used for parts &amp; Structure which cannot be heat treated for stress relieving after welding.</p>\r\n', '', 'Remove'),
(7, 'Grade SS 310S', '<p>These are austenitic types with higher Chromium &amp; Nickel content, because of their relatively high creep strength &amp; mechanical properties. At higher temperatures these steel find application for higher temperature &amp; server service conditions. Use for all heaters, annealing boxes, ovens, carburizing boxes, fire box sheets furnace linings, furnace stacks and dampers, gas turbine parts, nozzle diaphragm, mill equipment, textile finishing equipment, pollution control etc.</p>\r\n', '', 'Remove'),
(8, 'Grade SS 316', '<p>An austenitic stainless steel with 2.0% to 3.0% Mo. This improves corrosion resistance against halogens and imparts hot strength characteristics. Used for applications requiring resistance to pitting corrosion and in-halogens atmosphere. Typical applications architectural trims, marine, exteriors, chemical processing equipment, food processing equipment, petroleum refining equipment, pharmaceutical, photographic equipment, pollution control, etc.</p>\r\n', '', 'Remove'),
(9, 'Grade SS 316L', '<p>It has an extra-low carbon content and is a variation of SS 316. The low carbon content is necessary for welding applications where avoiding carbide precipitation is key. It is mainly used in welding applications where corrosion resistance is a concern.</p>\r\n', '', 'Remove'),
(10, 'Grade SS 321', '<p>An austenitic stainless steel similar to SS 304 but stabilized with titanium to avoid inter-granular corrosion. Stainless steel321 resists scaling and vibration fatigue. It is used for aircraft stacks and manifolds pressure vessels, large mufflers for stationery diesel engines, carburetors, stakes liners, etc.</p>\r\n', '', 'Remove'),
(11, 'Grade SS 409/ 409M', '<p>It is lowest alloyer straight chromium ferritic stainless steel. It replaces carbon steel and low alloy steel where some amount of heat &amp; corrosion resistance and higher strength is required and appearance is secondary. It is used for fins in heater tubes, automotive exhaust system including, mufflers, resonators, silencers, pipes and emission control units, high pressure agricultural spray tanks, farm equipment, etc.</p>\r\n', '', 'Remove'),
(12, 'Grade SS 410S', '<p>SS 410S is the most commonly used 12% chromium stainless steel, with Excellent condition of toughness and strength can be developed. It is good choice when good formability and high strength are the en use demands resistance to mildly corrosive environment. It is used for furnaces parts and burners operating below 650. C, micrometer parts, tray supports, caps and vaporizers in petroleum fractioning towers, lining for reaction chambers, coal screens fishing tacklets, keys, tapes, bucket covers, pump parts, Petro-chemical equipment, etc.</p>\r\n', '', 'Remove'),
(13, 'Grade SS 420', '<p>This grade of steel contains minimum 0.15% C and 12% C. It has been thermally hardened to develop very high strength. Extremely useful for cutlery, other applications include vegetable shoppers scissors, tweezers, hand dental &amp; surgical instruments, etc.</p>\r\n', '', 'Remove'),
(14, 'Grade SS 430', '<p>SS 430 with 17% is inferior to Ss304 as regards deep durability. Though it does not have good corrosion resistance properties due to the CR-Ni steel. It is used under less severe corrosive atmosphere for chemical processing equipment, furnace parts, oil-burner parts, petroleum rolling equipment, pyrometers protection tubes, recuperators, rubber plant machinery, scientific apparatus, storage vessels, tubing, television cones, electrical appliances, solar water heaters, air-conditioners, kitchenware, household appliances, parts for washing machine, etc.</p>\r\n', '', 'Remove');

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

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

CREATE TABLE `tbl_banner` (
  `banner_id` int(11) NOT NULL,
  `banner_name` varchar(300) NOT NULL,
  `banner_decs` varchar(300) NOT NULL,
  `banner_type` bigint(20) NOT NULL,
  `banner_image_name` varchar(300) NOT NULL,
  `banner_decs2` text NOT NULL,
  `banner_link` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_banner` (`banner_id`, `banner_name`, `banner_decs`, `banner_type`, `banner_image_name`, `banner_decs2`, `banner_link`) VALUES
(1, '7', 'Years Of Experience', 1, '1705491087_two.png', '', ''),
(2, '434', 'Products Served', 1, '1705491097_three.png', '', ''),
(3, '26', 'Expert Team', 1, '1705491105_four.png', '', ''),
(4, '20', 'Areas Covered', 1, '1705491113_five.png', '', ''),
(7, 'Complete Hardware Solution Under One Roof', '<p>&nbsp;Our brand philosophy is to touch upon key customer requirements and deliver superlative quality to ensure the highest levels of customer satisfaction.</p>\r\n', 2, '1705556951_lab-2.jpg', '', ''),
(10, 'Normal Hinge', 'Raerprazole Sodium 20 mg Gastro-resistant\r\nDomeperidone', 3, '1708511129_one.jpg', '', '#'),
(11, 'Telescopic Drawer Channel', 'Flexofenadine Hcl 120mg + Monetelukast Sodium 10mg', 3, '1708511285_two.jpg', '', '#'),
(12, ' Adyn - Zol', 'An Orally active antifungal agent\r\nItraconazole 100mg/200mg', 3, '1708511441_three.jpg', '', '#'),
(13, 'Double Track For One Door Fitting', 'L-Metaylfolate 1mg, Vitamin K2-7 45mcg, Cynocobalamin 2.2mcg', 3, '1708511657_four.jpg', '', '#'),
(14, 'G Profile', 'Aceclofenac 100mg, Paracetamol 325mg, Serratiopeptidase 15mg', 3, '1708511766_five.jpg', '', '#'),
(15, 'Jewellery Box', 'Amoxycillin (500mg) + Clavulanic Acid (125mg)', 3, '1708511890_six.jpg', '', '#'),
(16, 'Product Designer (UI/UX)', 'Lorem ipsum, dolor sit amet consectetur adipisicing elit. Ullam natus exercitationem repudiandae a autem nostrum.', 4, '1708340650_', '12th Pass', 'Delhi'),
(17, 'Product Designer (UI/UX)', 'Lorem ipsum, dolor sit amet consectetur adipisicing elit. Ullam natus exercitationem repudiandae a autem nostrum.', 4, '1708340476_', '12th Pass', 'Delhi');

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

--
-- Table structure for table `tbl_best_sell`
--

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

--
-- Dumping data for table `tbl_best_sell`
--

INSERT INTO `tbl_best_sell` (`id`, `image`) VALUES
(1, 'shop-sidebar.jpg'),
(1, 'shop-sidebar.jpg'),
(1, 'shop-sidebar.jpg');

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

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

CREATE TABLE `tbl_category` (
  `cat_id` int(11) NOT NULL,
  `cate_name` varchar(200) NOT NULL,
  `category_image` varchar(200) DEFAULT NULL,
  `cate_desc` text,
  `stastus` varchar(50) DEFAULT NULL,
  `home_status` varchar(11) DEFAULT NULL,
  `dat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_category` (`cat_id`, `cate_name`, `category_image`, `cate_desc`, `stastus`, `home_status`, `dat`) VALUES
(2, 'Hinge Series', NULL, '', NULL, NULL, '2024-02-21 10:03:57'),
(3, 'Kitchen Series', NULL, '', NULL, NULL, '2024-02-21 10:04:06'),
(9, 'Furniture Fitting Series', NULL, '', NULL, NULL, '2024-02-21 10:04:28'),
(10, 'Aluminium Profile Series', NULL, '', NULL, NULL, '2024-02-21 10:04:36'),
(11, 'Wordrobe Series', NULL, '', NULL, NULL, '2024-02-21 10:04:40'),
(12, 'Telescopic Series', NULL, '', NULL, NULL, '2024-02-27 12:28:48');

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

--
-- Table structure for table `tbl_category_img`
--

CREATE TABLE `tbl_category_img` (
  `img_id` int(11) NOT NULL,
  `category_parent_id` int(11) NOT NULL,
  `category_image_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_category_img`
--

INSERT INTO `tbl_category_img` (`img_id`, `category_parent_id`, `category_image_name`) VALUES
(110, 124, '1495276550_fiberss.jpg'),
(112, 128, '1495864597_37.jpg'),
(113, 129, '1495864619_17.jpg'),
(114, 131, '1495864873_20.jpg'),
(115, 133, '1495865159_21.jpg'),
(116, 134, '1495866026_lotuz.jpg'),
(117, 140, '1496395660_outer-1.jpg'),
(118, 162, '01-detail.jpg');

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

--
-- Table structure for table `tbl_contact_desc`
--

CREATE TABLE `tbl_contact_desc` (
  `id` int(11) NOT NULL,
  `introduction` text NOT NULL,
  `introduction1` text NOT NULL,
  `introduction2` text NOT NULL,
  `introduction3` text NOT NULL,
  `introduction4` text NOT NULL,
  `introduction5` text NOT NULL,
  `dat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_contact_desc`
--

INSERT INTO `tbl_contact_desc` (`id`, `introduction`, `introduction1`, `introduction2`, `introduction3`, `introduction4`, `introduction5`, `dat`) VALUES
(1, '<p>Our company is the most eminent name in the industry for manufacturer and service provider of GRC, FRP and concrete or precast concrete products. Creative GRC specialize in creating customized solutions using Glass fibre Reinforced Concrete (GRC) or also known as just Glass Reinforced Concrete. Creative GRC is a privately owned company; our management team remain personally involved in overseeing every project from concept to completion. Founded over years ago, Creative GRC has successfully completed a huge number of projects around India, from lightweight cladding panels for high rise commercial buildings, to intricate art installations in the urban landscape. Located and producing locally in Delhi, Creative GRC could be the perfect solution for your next project. Creative GRC welcomes visits from architects and designer&#39;s .We can offer complete customised solutions for your project. Every job is different and requires specialized input. With extensive experience from small scale residential bench tops to large scale high-rise commercial cladding projects we can project manage the production of your project from concept to completion.</p>\r\n', '<p>Since our incorporation in this industry, we have been steady in providing superior quality array of products in accordance with the requirements of our clients.</p>\r\n\r\n<h3>Following are some of the factors:</h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Strong focus on quality compliance</p>\r\n	</li>\r\n	<li>\r\n	<p>Easy mode of payment</p>\r\n	</li>\r\n	<li>\r\n	<p>Timely delivery</p>\r\n	</li>\r\n	<li>\r\n	<p>Innovative designs</p>\r\n	</li>\r\n</ul>\r\n', '<p>Our firm follows an ethical and grounded business policy and on based on it, we have gained a huge success. Our mission is to attain client satisfaction and therefore with each of our products, we meet the need. We have developed a competent infrastructure ensuring productivity and fulfil the demand. Our products are widely used because of its precise design, friendly pricing, supreme performance and easy to operate features.&nbsp;<br />\r\n<strong>Some of the merits that have received us consistency in the industry are:</strong></p>\r\n\r\n<ul>\r\n	<li>Excellent quality range</li>\r\n	<li>On-time dispatch</li>\r\n	<li>Easy payment modes</li>\r\n	<li>Wide shipment modes</li>\r\n	<li>Assiduous team</li>\r\n	<li>Huge ability to meet increasing demands</li>\r\n	<li>Affordable rates</li>\r\n</ul>\r\n', '<p>We have built a state-of-the-art infrastructure and have equipped it with highly efficient machineries and innovative technology. The competent equipments enables us in producing cutting-edge devices and helps in achieving top level productivity, thus meeting the rising demands. We have invested an adequate fund in the making of our unit and maintaining it on the regular basis. Our infrastructure includes production unit, warehouse, and testing laboratory.</p>\r\n', '<p>Our firm while developing these products has adopted a qualitative approach. Quality is another area which we cater to and delivers it through our product range. We maintain a quality measures during the production, apart from this, the components we use are accurately examined and sourced from authorized vendors. After the production of these products, we carry out a quality test and makes sure that all our products meets the parameters set by the accreditation body.</p>\r\n', '', '2018-09-25 05:21:17');

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

--
-- Table structure for table `tbl_domestic_category`
--

CREATE TABLE `tbl_domestic_category` (
  `cat_id` int(11) NOT NULL,
  `cate_name` varchar(200) NOT NULL,
  `category_image` varchar(200) NOT NULL,
  `cate_desc` text NOT NULL,
  `stastus` varchar(200) NOT NULL,
  `home_status` varchar(11) NOT NULL,
  `dat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_domestic_category`
--

INSERT INTO `tbl_domestic_category` (`cat_id`, `cate_name`, `category_image`, `cate_desc`, `stastus`, `home_status`, `dat`) VALUES
(1, 'Commercial Treadmill', '', '', '', '', '2022-05-11 12:08:49'),
(2, 'Light Commercial Treadmill', '', '', '', '', '2022-05-11 12:09:02'),
(3, 'Motorized Treadmill', '', '', '', '', '2022-05-11 12:09:13'),
(4, 'Light Commercial Elliptical', '', '', '', '', '2022-05-11 12:09:23'),
(5, 'Programable Magnetic Elliptical', '', '', '', '', '2022-05-11 12:09:28'),
(6, 'Magnetic Elliptical', '', '', '', '', '2022-05-11 12:09:32'),
(7, 'Metallic Double Burner', '', '', '', '', '2022-05-11 12:09:38'),
(8, 'Fashion Double Burner', '', '', '', '', '2022-05-11 12:09:48');

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

--
-- Table structure for table `tbl_domestic_product`
--

CREATE TABLE `tbl_domestic_product` (
  `pro_id` int(11) NOT NULL,
  `pro_category` varchar(250) NOT NULL,
  `pro_name` varchar(250) NOT NULL,
  `pro_type` varchar(250) NOT NULL,
  `pro_offer` varchar(250) NOT NULL,
  `pro_desc` text NOT NULL,
  `pro_brf` text NOT NULL,
  `pro_more` text NOT NULL,
  `pro_image` varchar(250) NOT NULL,
  `status` varchar(11) NOT NULL,
  `status_gal` varchar(11) NOT NULL,
  `pro_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_domestic_product`
--

INSERT INTO `tbl_domestic_product` (`pro_id`, `pro_category`, `pro_name`, `pro_type`, `pro_offer`, `pro_desc`, `pro_brf`, `pro_more`, `pro_image`, `status`, `status_gal`, `pro_date`) VALUES
(2, '1', 'T2400', '', '', '', '', '', '31350.jpg', 'Home', '', '2022-05-11 12:13:39'),
(3, '1', 'T2121', '', '', '', '', '', '3967.jpg', 'Home', '', '2022-05-11 12:13:38'),
(4, '1', 'T2323 ', '', '', '', '', '', '31564.jpg', 'Home', '', '2022-05-11 12:13:36'),
(5, '1', 'X8', '', '', '', '', '', '18434.jpg', 'Home', '', '2022-05-11 12:13:35'),
(6, '1', 'T2200', '', '', '', '', '', '29971.jpg', 'Home', '', '2022-05-11 12:13:33');

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

--
-- Table structure for table `tbl_domestic_product_image`
--

CREATE TABLE `tbl_domestic_product_image` (
  `gal_id` int(11) NOT NULL,
  `pro_id` int(11) NOT NULL,
  `gal_image` varchar(250) NOT NULL,
  `gal_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_domestic_product_image`
--

INSERT INTO `tbl_domestic_product_image` (`gal_id`, `pro_id`, `gal_image`, `gal_date`) VALUES
(3, 2, '1652271117_six.jpg', '2022-05-11 12:11:57'),
(4, 2, '1652271125_seven.jpg', '2022-05-11 12:12:05'),
(5, 2, '1652271137_eight.jpg', '2022-05-11 12:12:17');

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

--
-- Table structure for table `tbl_enquery`
--

CREATE TABLE `tbl_enquery` (
  `id` int(11) NOT NULL,
  `page` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1- career, 2- contact, 3- enquiry, 4- newsletter,  5-servicesenquiry,  6-productenquiry',
  `tilt1` varchar(244) DEFAULT NULL,
  `tilt2` varchar(244) DEFAULT NULL,
  `tilt3` varchar(244) DEFAULT NULL,
  `tilt4` varchar(244) DEFAULT NULL,
  `tilt5` varchar(244) DEFAULT NULL,
  `tilt6` varchar(244) DEFAULT NULL,
  `tilt7` varchar(244) DEFAULT NULL,
  `msg` text,
  `file` varchar(200) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_enquery`
--

INSERT INTO `tbl_enquery` (`id`, `page`, `tilt1`, `tilt2`, `tilt3`, `tilt4`, `tilt5`, `tilt6`, `tilt7`, `msg`, `file`, `created_date`) VALUES
(30, 4, NULL, NULL, 'test@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, '2024-01-18 12:10:00'),
(31, 5, 'Ravinder', '9315585244', 'test@gmail.com', 'Distribution supply chain management', NULL, NULL, NULL, 'Hello test', NULL, '2024-01-18 12:10:37'),
(32, 6, 'Ravinder', '9315585244', 'test@gmail.com', 'ADYN - DSR', NULL, NULL, NULL, 'Hello test', NULL, '2024-01-18 12:11:11'),
(28, 3, 'Ravinder', '9315585244', 'ravinderfivedesign@gmail.com', 'test', NULL, NULL, NULL, 'Hello test', 'resume-30493.pdf', '2024-01-18 12:08:44'),
(29, 1, 'Ravinder', '9315585244', 'ravinderfivedesign@gmail.com', 'BCA', 'test', NULL, NULL, 'Hello test', 'resume-15762.pdf', '2024-01-18 12:09:41'),
(27, 2, 'Ravinder', '9315585244', 'ravinderfivedesign@gmail.com', 'test', NULL, NULL, NULL, 'Hello test', NULL, '2024-01-18 12:08:02'),
(33, 1, 'meenakshi', '9898909878', 'fivedesign@gmail.com', '10', 'check career form 19-jan-24', NULL, NULL, 'check career form 19-jan-24', 'resume-1857682902.jpg', '2024-01-19 10:28:07'),
(34, 3, 'meenakshi', '9898909878', 'fivedesignindia@gmail.com', 'check form', NULL, NULL, NULL, '', 'resume-1216650587.jpg', '2024-01-19 10:29:02'),
(35, 2, 'meenakshi', '9898909878', 'fivedesign@gmail.com', 'check contact', NULL, NULL, NULL, 'check contact 19-jan-24', NULL, '2024-01-19 10:30:04'),
(36, 1, 'Ravinder', '9315585244', 'ravinder@gmail.com', 'bca', 'test', NULL, NULL, 'Hello', 'resume-540233289.pdf', '2024-01-19 10:35:50'),
(37, 1, 'Choose Your with AISM group 1', '0987654321', 'abhay@gmail.com', 'SADSA', 'SADSAD', NULL, NULL, 'fhgfhgfh', 'resume-1527025938.png', '2024-01-19 10:39:21'),
(38, 1, 'meenakshi', '9898909878', 'fivedesignindia@gmail.com', 'bca', 'kjjh', NULL, NULL, 'Hello test', 'resume-794210130.jpg', '2024-01-19 10:43:24'),
(39, 1, 'dev', '8888888888', 'abhay@gmail.com', 'mca', 'dev', NULL, NULL, 'dev testing ', 'resume-1631447418.png', '2024-01-19 10:49:11'),
(40, 3, 'test', '9315585244', 'test@gmail.com', 'test', NULL, NULL, NULL, 'Hello', 'resume-1916031418.pdf', '2024-01-19 10:59:08'),
(41, 2, 'Ravinder', '78965412332', 'ravinder@gmail.com', 'sdsd', NULL, NULL, NULL, 'ghgh', NULL, '2024-01-19 10:59:46'),
(42, 1, 'Sushil Kumar', '07838282220', 'Sushil10a@gmail.com', 'Bsc', 'For rsm', NULL, NULL, 'Looking for rsm', 'resume-1711025989.pdf', '2024-01-19 17:06:57'),
(43, 5, 'Sushil Kumar', '07838282220', 'Sushil10a@gmail.com', 'Distribution supply chain management', NULL, NULL, NULL, 'Hi supply of goods ?', NULL, '2024-01-23 17:21:18'),
(44, 1, 'Sushil Kumar', '07838282220', 'Sushil10a@gmail.com', 'Bsc', 'Yes', NULL, NULL, 'Hi', 'resume-129558948.jpg', '2024-01-24 07:36:25'),
(45, 1, 'Sushil Kumar', '07838282220', 'Sushil10a@gmail.com', 'Bsc', 'Marketing ', NULL, NULL, 'Please find my CV as an attachment ', 'resume-2131170491.pdf', '2024-02-14 07:30:40'),
(46, 1, 'nisha', '8882128440', 'saurabhfivedesig@gmail.com', 'student', 'check form', NULL, NULL, 'check form', 'resume-281388199.png', '2024-02-19 05:03:32'),
(47, 3, 'Sushil Kumar', '07838282220', 'Sushil10a@gmail.com', 'Job ', NULL, NULL, NULL, 'Hi', 'resume-1637093073.jpg', '2024-02-19 07:10:53'),
(48, 4, NULL, NULL, 'Sushil10a@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, '2024-02-19 07:11:19');

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

--
-- Table structure for table `tbl_footer_logo`
--

CREATE TABLE `tbl_footer_logo` (
  `logo_id` int(11) NOT NULL,
  `logo_image_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_footer_logo`
--

INSERT INTO `tbl_footer_logo` (`logo_id`, `logo_image_name`) VALUES
(2, '1708513511_flogo.png');

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

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

CREATE TABLE `tbl_gallery` (
  `gal_id` int(11) NOT NULL,
  `gal_name` varchar(255) NOT NULL,
  `gal_image` varchar(255) NOT NULL,
  `home_status` varchar(50) NOT NULL,
  `gal_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_gallery` (`gal_id`, `gal_name`, `gal_image`, `home_status`, `gal_date`) VALUES
(66, '', '1600506214_1.png', 'Home', '2020-09-18 20:35:41'),
(67, '', '1600506398_2.png', 'Home', '2020-09-18 20:38:15'),
(68, '', '1600506417_3.png', 'Home', '2020-09-18 20:38:23'),
(69, '', '1600506482_4.png', 'Home', '2020-09-18 20:38:31'),
(70, '', '1600506540_5.png', 'Home', '2020-09-18 20:52:21'),
(71, '', '1600507362_6.png', 'Home', '2020-09-18 20:52:50'),
(72, '', '1600507389_7.png', '', '2020-09-18 20:53:09'),
(73, '', '1600507814_8.png', '', '2020-09-18 21:00:14'),
(74, '', '1628569758_one.jpg', '', '2021-08-10 04:29:18'),
(75, '', '1628569779_one.jpg', '', '2021-08-10 04:29:39'),
(76, '', '1628569974_one.jpg', '', '2021-08-10 04:32:54'),
(77, '', '1628570037_one.jpg', '', '2021-08-10 04:33:57'),
(78, '', '1628570047_one.jpg', '', '2021-08-10 04:34:07'),
(79, '', '1652342219_01_gallery.jpg', '', '2022-05-12 07:56:59'),
(80, '', '1652342349_01_gallery.jpg', '', '2022-05-12 07:59:09'),
(81, '', '1652342470_01_gallery.jpg', '', '2022-05-12 08:01:10');

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

--
-- Table structure for table `tbl_grc`
--

CREATE TABLE `tbl_grc` (
  `id` int(11) NOT NULL,
  `grc_desc` text NOT NULL,
  `grc_desc2` text NOT NULL,
  `grc_image2` varchar(200) NOT NULL,
  `grc_image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_grc`
--

INSERT INTO `tbl_grc` (`id`, `grc_desc`, `grc_desc2`, `grc_image2`, `grc_image`) VALUES
(1, '<p>Baya aims to be a sustainable fashion brand and is continuously making efforts towards ethical production and slow fashion movement. Our parent organisation, Purvanchal Vikas Foundation helps us produce ethically and empower women by training them in cutting and stitching as well as provide them with employment opportunities.</p>\r\n', '<p>We have a topnotch position in this area with our foundation base. It comprises of all the advanced technology based machines. Our framework is segmented into various departments. we have had the option to finish the consignments within a limited time-frame to accomplish the total satisfaction.</p>\r\n\r\n<p><span style=\"color:#009a4e\"><span style=\"font-size:18px\"><strong>We have functional units in our facility:</strong></span></span></p>\r\n\r\n<ul>\r\n	<li>Manufacturing</li>\r\n	<li>Quality testing</li>\r\n	<li>Warehousing</li>\r\n	<li>Packaging</li>\r\n</ul>\r\n', 'side-image06.jpg', 'workign.jpg');

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

--
-- Table structure for table `tbl_home_about`
--

CREATE TABLE `tbl_home_about` (
  `id` int(11) NOT NULL,
  `introduction` text NOT NULL,
  `title1` varchar(255) NOT NULL,
  `title2` varchar(255) NOT NULL,
  `title3` varchar(255) NOT NULL,
  `title4` varchar(255) NOT NULL,
  `title5` varchar(255) NOT NULL,
  `title6` varchar(255) NOT NULL,
  `title7` varchar(200) NOT NULL,
  `title8` varchar(250) NOT NULL,
  `title9` varchar(250) NOT NULL,
  `desc1` text NOT NULL,
  `desc2` text NOT NULL,
  `desc3` text NOT NULL,
  `desc4` text NOT NULL,
  `desc5` text NOT NULL,
  `desc6` text NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_home_about`
--

INSERT INTO `tbl_home_about` (`id`, `introduction`, `title1`, `title2`, `title3`, `title4`, `title5`, `title6`, `title7`, `title8`, `title9`, `desc1`, `desc2`, `desc3`, `desc4`, `desc5`, `desc6`, `image`) VALUES
(1, '<p>Welcome to Handy Hardy, your one source for all things related to furniture and kitchen Hardware. We are dedicated to providing you th with very best of above mentioned hardware products, with a focus on qaulity &amp; price.</p>\r\n\r\n<ul>\r\n	<li>Premium quality in every product</li>\r\n	<li>Innovation &amp; expertise in our chosen field</li>\r\n	<li>Highest levels of customer satisfaction</li>\r\n</ul>\r\n', 'about.php', '24', 'Ensuring Premium Quality And Excellence In Every Product', '9000', '2000', '12', 'The Organization has approached various companies to support our Program. They appreciated our efforts and agreed to support the program. We are already tied-up with Singer as Sewing School', '#', '', '', '<p>Expertise serves as a combination of industry knowledge with fresh prospects and breakthrough project insights. We provide an assortment of products that varies from a small component to big equipment and set new criteria of excellence and leadership with a strong competing advantage.</p>\r\n', '', '', '', '', '1709033096_');

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

--
-- Table structure for table `tbl_home_about_flash`
--

CREATE TABLE `tbl_home_about_flash` (
  `client_logo_id` int(11) NOT NULL,
  `logo_image_name` varchar(300) NOT NULL,
  `logo_name` varchar(200) NOT NULL,
  `logo_link` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_home_about_flash`
--

INSERT INTO `tbl_home_about_flash` (`client_logo_id`, `logo_image_name`, `logo_name`, `logo_link`) VALUES
(82, '1652266192_1.png', 'Our Goal ', 'Our Goal is to be a leader in the area of Network Security Solutions by building a strong customer base. '),
(83, '1652266208_2.png', 'Our Mission', 'Our Mission is to build long term relationship with our esteemed customers by providing exceptional services through innovation and state of the art technology'),
(85, '1652259248_3.png', 'Our Vision', 'Our Vision is to be the leader in providing unmatched services in the field of Network Security. ');

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

--
-- Table structure for table `tbl_home_why_choose_us`
--

CREATE TABLE `tbl_home_why_choose_us` (
  `id` int(11) NOT NULL,
  `introduction` text NOT NULL,
  `title1` varchar(300) NOT NULL,
  `title2` varchar(300) NOT NULL,
  `title3` varchar(300) NOT NULL,
  `title4` varchar(300) NOT NULL,
  `title5` varchar(300) NOT NULL,
  `title6` varchar(300) NOT NULL,
  `title7` varchar(300) NOT NULL,
  `title8` varchar(300) NOT NULL,
  `title9` varchar(300) NOT NULL,
  `desc1` text NOT NULL,
  `desc2` text NOT NULL,
  `desc3` text NOT NULL,
  `desc4` text NOT NULL,
  `desc5` text NOT NULL,
  `desc6` text NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_home_why_choose_us`
--

INSERT INTO `tbl_home_why_choose_us` (`id`, `introduction`, `title1`, `title2`, `title3`, `title4`, `title5`, `title6`, `title7`, `title8`, `title9`, `desc1`, `desc2`, `desc3`, `desc4`, `desc5`, `desc6`, `image`) VALUES
(1, '<p>We have been producing state of the art top quality products for several years, as we are well equipped with modern and contemporary technology. We have a prevailing and powerful set up to fulfill our customer&#39;s great demands in time.</p>\r\n', '', '', 'We Are The Trusted Experts In Latest Technology', '', '', '', '', 'Our vision is to deliver excellent quality products at lowest price in shortest time at doorstep.', '', '', '', '', '', '', '', '1680262941_');

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

--
-- Table structure for table `tbl_infratruture`
--

CREATE TABLE `tbl_infratruture` (
  `flash_title` varchar(280) NOT NULL,
  `flash_sub_title` longtext,
  `flash_sub_sub_title` varchar(300) NOT NULL,
  `header_image_name` varchar(300) NOT NULL,
  `header_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_infratruture`
--

INSERT INTO `tbl_infratruture` (`flash_title`, `flash_sub_title`, `flash_sub_sub_title`, `header_image_name`, `header_id`) VALUES
('Self Employment & Skill Development', 'Service based Skill Development courses .  Repair & maintenance of Electric fan motor, washing machine, mixer-Juicer -Grinder , TV, Refrigerator, Air Conditioner ,Microwave, Fabrication, carpentering and Painting. Facilitating Loan through Banks. </br> <b>Job Placement</b> to skilled, semi-skilled & unskilled manpower creating a pool of Trained Manpower and Placement in Various companies.', '', '1629451293_4.jpg', 1),
(' Health and Education', 'We connect Unorganized workers with Government & Private Hospitals for better health services and, also help in free treatment . We also Encourage them to take Government Health Cards like Ayushman Bharat for Family Health Security. We also support their children to get admitted in Government and Private schools and help them financially if required .<br> We take initiatives to sensitize the communities about the importance of health. We  organize health camps which provide free medical check up and referral services.', '', '1627465959_health-education.jpg', 2),
('Women Empowerment', '<b>( Swaavalamban )</b> Promoting Gender equality, women Leadership, Self Independence, Skill Development, and entrepreneurship through stitching and income generation Program. </br>', '', '1627466490_women-employment.jpg', 3),
('Green Enviroments', 'Free from Plastic Pollution, Environment, Waste Disposal, Promotion of Cloth, Paper & Jute Bags. ', '', '1627466760_green-environment.jpg', 4),
('Child Labour', 'To seek child-labor free and safe environment for all children, aiming to ensure the holistic development and integration of deprived section into the mainstream of child rights.  ', '', '1627466934_child-labour.jpg', 5),
('Advocacy', '<b>Advocacy </b>with State & Central Government for social & Economic Development of Migrants. <br> To empower woman and equip them to promote gender equality and developed livelihood sustainable processes (and enhance their Employability).', '', '1628082963_1.jpg', 6);

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

--
-- Table structure for table `tbl_legal_desc`
--

CREATE TABLE `tbl_legal_desc` (
  `legl_id` int(11) NOT NULL,
  `legl_desc` text NOT NULL,
  `page_name` varchar(100) NOT NULL,
  `intro_title` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_legal_desc`
--

INSERT INTO `tbl_legal_desc` (`legl_id`, `legl_desc`, `page_name`, `intro_title`) VALUES
(1, '<p>hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here&nbsp;hello i am testing here hello i am testing here</p>\r\n', 'shinegold', 'legal');

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

--
-- Table structure for table `tbl_logo_client`
--

CREATE TABLE `tbl_logo_client` (
  `client_logo_id` int(11) NOT NULL,
  `logo_image_name` varchar(300) NOT NULL,
  `logo_name` varchar(200) NOT NULL,
  `sub_logo_name` varchar(200) NOT NULL,
  `logo_link` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_logo_client`
--

INSERT INTO `tbl_logo_client` (`client_logo_id`, `logo_image_name`, `logo_name`, `sub_logo_name`, `logo_link`) VALUES
(86, '1661838684_5.jpg', '', '', ''),
(87, '1661838678_4.jpg', '', '', ''),
(88, '1661838672_3.jpg', '', '', ''),
(89, '1661838722_2.jpg', '', '', ''),
(90, '1661838664_1.jpg', '', '', '');

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

--
-- Table structure for table `tbl_more_blog`
--

CREATE TABLE `tbl_more_blog` (
  `gal_id` int(11) NOT NULL,
  `pro_id` int(11) NOT NULL,
  `gal_image` varchar(255) NOT NULL,
  `gal_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_more_blog`
--

INSERT INTO `tbl_more_blog` (`gal_id`, `pro_id`, `gal_image`, `gal_date`, `description`) VALUES
(1, 6, '1705561843_comming.pdf', '2024-01-18 07:10:43', ''),
(5, 1, '1705562252_comming.pdf', '2024-01-18 07:17:32', '');

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

--
-- Table structure for table `tbl_news_letter`
--

CREATE TABLE `tbl_news_letter` (
  `news_letter_id` int(11) NOT NULL,
  `news_letter_email` varchar(100) NOT NULL,
  `news_letter_date` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_news_letter`
--

INSERT INTO `tbl_news_letter` (`news_letter_id`, `news_letter_email`, `news_letter_date`) VALUES
(2, 'shahilk289@gmail.com', ''),
(6, 'shahilk289@gmail.com', ''),
(12, '', '');

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

--
-- Table structure for table `tbl_new_blog`
--

CREATE TABLE `tbl_new_blog` (
  `id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `sub_title` text NOT NULL,
  `location` varchar(300) NOT NULL,
  `status` varchar(50) NOT NULL,
  `file` varchar(300) NOT NULL,
  `blog_desc` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_new_blog`
--

INSERT INTO `tbl_new_blog` (`id`, `title`, `sub_title`, `location`, `status`, `file`, `blog_desc`, `date`) VALUES
(1, 'Pharma Franchise Business Concept', 'The concept of PCD Pharma business is a new and unknown word for many common people but for the person who is associated with Pharma or healthcare sector is familiar with this word very well.', 'Admin', '', '26343.jpg', '<p>The concept of PCD Pharma business is a new and unknown word for many common people but for the person who is associated with Pharma or healthcare sector is familiar with this word very well. In the era of 2000 when India was developing rapidly in that period, there was one sector which is changing its path of progress and it was Indian Pharma sector. Pharma franchise and distribution concept has changed the direction of this field and provided the opportunity of growing to small PCD Pharma Companies and healthcare professionals to start their own business and grow with their own work.</p>\r\n\r\n<p>With over a decade of experience, we&rsquo;ve established ourselves as one of the pioneering agencies in the&nbsp;The term franchise which is used in Pharma franchise comes from French vocabulary. Its meaning is liberty and it was used before the 18th century. Again its use started in the new modern era of the 20th century and then it became very popular in various business sectors such as food, cloth, auto, medicine, etc. Between the eras of 1950-60 less than 100 companies in the US were working on the basis of the franchise business concept. In the current scenario, this business concept is working everywhere in the world even it is difficult to count.</p>\r\n', '2024-01-18 06:26:28'),
(2, 'Effect Of Digitalization In Pharma Industry', 'Digitalization is the new trending concept in the pharma and healthcare industry. In fact, technology driven PCD Pharma companies get maximum benefits of digital transformation.', 'Admin', '', '22513.jpg', '', '2024-01-18 05:04:37'),
(3, 'Marketing Tool For Pcd Pharma Company', 'Telemarketing is an important tool for all sectors, even in the pharma sector also. For Pharma franchise companies it has a very important role in marketing. Sometimes it is also proved to be an i..', 'Admin ', '', '25236.jpg', '', '2024-01-18 05:05:11'),
(4, 'Pharma Franchise Business Concept', 'The concept of PCD Pharma business is a new and unknown word for many common people but for the person who is associated with Pharma or healthcare sector is familiar with this word very well.', 'Admin', '', '16701.jpg', '', '2024-01-18 05:06:11'),
(5, 'Effect Of Digitalization In Pharma Industry', 'Digitalization is the new trending concept in the pharma and healthcare industry. In fact, technology driven PCD Pharma companies get maximum benefits of digital transformation.', 'Admin', '', '3378.jpg', '', '2024-01-18 05:07:34'),
(6, 'Marketing Tool For Pcd Pharma Company', 'Telemarketing is an important tool for all sectors, even in the pharma sector also. For Pharma franchise companies it has a very important role in marketing. Sometimes it is also proved to be an i..', 'Admin', '', '2691.jpg', '', '2024-01-18 05:07:59');

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

--
-- Table structure for table `tbl_our_mission`
--

CREATE TABLE `tbl_our_mission` (
  `id` int(11) NOT NULL,
  `our_mission` text NOT NULL,
  `our_mission_title` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_our_mission`
--

INSERT INTO `tbl_our_mission` (`id`, `our_mission`, `our_mission_title`) VALUES
(1, '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'hello i am testing here this ');

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

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

CREATE TABLE `tbl_product` (
  `pro_id` int(11) NOT NULL,
  `pro_category` varchar(255) NOT NULL,
  `pro_name` varchar(255) NOT NULL,
  `pro_type` varchar(200) NOT NULL,
  `pro_offer` varchar(100) NOT NULL,
  `pro_desc` text NOT NULL,
  `pro_brf` text NOT NULL,
  `pro_more` text NOT NULL,
  `pro_image` varchar(255) NOT NULL,
  `status` varchar(11) DEFAULT NULL,
  `status_gal` varchar(10) DEFAULT NULL,
  `pro_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dp_rate` varchar(250) NOT NULL,
  `percentage` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_product` (`pro_id`, `pro_category`, `pro_name`, `pro_type`, `pro_offer`, `pro_desc`, `pro_brf`, `pro_more`, `pro_image`, `status`, `status_gal`, `pro_date`, `dp_rate`, `percentage`) VALUES
(21, '2', 'Normal Hinge ', '', '', '', '', '<ul>\r\n	<li><strong>102GM</strong>&nbsp;(+/-2GM)</li>\r\n	<li><strong>Size Crank :</strong> 0/8/15</li>\r\n</ul>\r\n', '27231.jpg', NULL, NULL, '2024-04-10 06:12:18', '', ''),
(22, '2', '2D Slide On Soft Close Hinge', '', '', '', '', '<ul>\r\n	<li><strong>160GM</strong>&nbsp;(+/-2GM)</li>\r\n	<li><strong>Size Crank :</strong>&nbsp;0/8/15</li>\r\n</ul>\r\n', '21739.jpg', NULL, NULL, '2024-04-10 06:11:57', '', ''),
(23, '2', '2D MS Soft Close Hinge', '', '', '', '', '<ul>\r\n	<li><strong>A Shape 210GM</strong>&nbsp;(+/-2GM)</li>\r\n	<li><strong>Size Crank :</strong>&nbsp;0/8/15</li>\r\n</ul>\r\n', '29256.jpg', NULL, NULL, '2024-04-10 06:26:41', '', ''),
(24, '2', '2D MS Soft Close Hinge', '', '', '', '', '<ul>\r\n	<li><strong>Ultra 2D 240 GM</strong>&nbsp;(+/-2GM)</li>\r\n	<li><strong>Size Crank :</strong>&nbsp;0/8/15</li>\r\n</ul>\r\n', '9889.jpg', NULL, NULL, '2024-04-10 06:29:15', '', ''),
(25, '2', '3D SS Soft Close Hinge', '', '', '', '', '<ul>\r\n	<li><strong>250 GM </strong>(+/-2GM)&nbsp;</li>\r\n	<li><strong>Size Crank :</strong>&nbsp;0/8/15</li>\r\n</ul>\r\n', '18657.jpg', NULL, NULL, '2024-04-10 06:45:58', '', ''),
(26, '2', '3D MS Soft Close Hinge', '', '', '', '', '<ul>\r\n	<li><strong>250 GM&nbsp;</strong>(+/-2GM)&nbsp;</li>\r\n	<li><strong>Size Crank :</strong>&nbsp;0/8/15</li>\r\n</ul>\r\n', '17926.jpg', NULL, NULL, '2024-04-10 06:48:29', '', '');

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

--
-- Table structure for table `tbl_product_image`
--

CREATE TABLE `tbl_product_image` (
  `gal_id` int(11) NOT NULL,
  `pro_id` int(11) NOT NULL,
  `gal_image` varchar(255) NOT NULL,
  `gal_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_product_image`
--

INSERT INTO `tbl_product_image` (`gal_id`, `pro_id`, `gal_image`, `gal_date`) VALUES
(67, 69, '1595671362_Wall-Mounted-Pipeless-Filter.jpg', '2020-07-24 21:32:42'),
(68, 69, '1595671381_Fish-Pond-Bead-Filter.jpg', '2020-07-24 21:33:01'),
(71, 115, '1652269041_two.jpg', '2022-05-11 11:37:21'),
(72, 115, '1652269049_three.jpg', '2022-05-11 11:37:29'),
(73, 115, '1652269059_four.jpg', '2022-05-11 11:37:39'),
(75, 133, '1652262769_one.jpg', '2022-05-11 09:52:49'),
(76, 133, '1652262778_one.jpg', '2022-05-11 09:52:58'),
(77, 133, '1652262788_one.jpg', '2022-05-11 09:53:08'),
(78, 132, '1652262807_two.jpg', '2022-05-11 09:53:27'),
(79, 132, '1652262816_two.jpg', '2022-05-11 09:53:36'),
(80, 132, '1652262825_two.jpg', '2022-05-11 09:53:45'),
(81, 131, '1652262858_three.jpg', '2022-05-11 09:54:18'),
(82, 131, '1652262849_three.jpg', '2022-05-11 09:54:09'),
(83, 131, '1652262871_three.jpg', '2022-05-11 09:54:31'),
(84, 130, '1652262900_four.jpg', '2022-05-11 09:55:00'),
(85, 130, '1652262911_four.jpg', '2022-05-11 09:55:11'),
(86, 130, '1652262920_four.jpg', '2022-05-11 09:55:20'),
(88, 169, '1667633271_fortigate-fortiwifi-40f-series.pdf', '2022-11-05 07:27:51'),
(89, 168, '1667633249_fortigate-200f-series.pdf', '2022-11-05 07:27:29'),
(90, 156, '1667633287_fortigate-fortiwifi-60f-series.pdf', '2022-11-05 07:28:07'),
(91, 167, '1667633359_comming.pdf', '2022-11-05 07:29:19'),
(92, 166, '1667633376_comming.pdf', '2022-11-05 07:29:36'),
(93, 164, '1667633389_comming.pdf', '2022-11-05 07:29:49'),
(94, 160, '1667633421_comming.pdf', '2022-11-05 07:30:21'),
(95, 155, '1667633626_fortigate-fortiwifi-80f-series.pdf', '2022-11-05 07:33:46'),
(96, 154, '1667633591_fortigate-100f-series.pdf', '2022-11-05 07:33:11');

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

--
-- Table structure for table `tbl_product_pdf`
--

CREATE TABLE `tbl_product_pdf` (
  `gal_id` int(11) NOT NULL,
  `pro_id` int(11) NOT NULL,
  `gal_image` varchar(255) NOT NULL,
  `gal_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_pro_home`
--

CREATE TABLE `tbl_pro_home` (
  `pro_id` int(11) NOT NULL,
  `project_name` varchar(100) NOT NULL,
  `project_name_two` varchar(100) NOT NULL,
  `project_image` varchar(100) NOT NULL,
  `project_avtive` enum('Yes','No') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_selling`
--

CREATE TABLE `tbl_selling` (
  `selling_id` int(11) NOT NULL,
  `selling_image_name` varchar(255) NOT NULL,
  `selling_name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_selling`
--

INSERT INTO `tbl_selling` (`selling_id`, `selling_image_name`, `selling_name`) VALUES
(1, '1499673490_1497420176_1.jpg', 'Event Services'),
(2, '1497420207_2.jpg', 'Obstackle Course'),
(3, '1497420253_3.jpg', 'Inflatable Activities'),
(4, '1497420295_4.jpg', 'Inflatable Bounciese'),
(5, '1497423854_5.jpg', 'Adventure Park Manufacturer');

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

--
-- Table structure for table `tbl_sertificate`
--

CREATE TABLE `tbl_sertificate` (
  `sertificate_id` int(11) NOT NULL,
  `sertificate_image_name` varchar(500) NOT NULL,
  `sertificate_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_sertificate`
--

INSERT INTO `tbl_sertificate` (`sertificate_id`, `sertificate_image_name`, `sertificate_name`) VALUES
(30, '1496488062_01.jpg', 'A'),
(31, '1496488130_03.jpg', 'C'),
(32, '1496488092_02.jpg', 'B'),
(33, '1496488167_05.jpg', 'N'),
(35, '1496488183_04.jpg', 'D'),
(36, '1496488209_06.jpg', 'I'),
(37, '1496488223_07.jpg', 'S'),
(38, '1496488241_08.jpg', 'E');

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

--
-- Table structure for table `tbl_services`
--

CREATE TABLE `tbl_services` (
  `id` int(11) NOT NULL,
  `ser1` text NOT NULL,
  `ser2` text NOT NULL,
  `ser3` text NOT NULL,
  `ser4` text NOT NULL,
  `ser5` text NOT NULL,
  `ser6` text NOT NULL,
  `image` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_services`
--

INSERT INTO `tbl_services` (`id`, `ser1`, `ser2`, `ser3`, `ser4`, `ser5`, `ser6`, `image`) VALUES
(1, '', '', '', '', '', '', '1633512015_IMG_20211006_144758.JPG');

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

--
-- Table structure for table `tbl_services_category`
--

CREATE TABLE `tbl_services_category` (
  `cat_id` int(11) NOT NULL,
  `cate_name` varchar(200) NOT NULL,
  `category_image` varchar(200) NOT NULL,
  `cate_desc` text NOT NULL,
  `stastus` varchar(50) NOT NULL,
  `home_status` varchar(11) NOT NULL,
  `dat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_services_category`
--

INSERT INTO `tbl_services_category` (`cat_id`, `cate_name`, `category_image`, `cate_desc`, `stastus`, `home_status`, `dat`) VALUES
(10, 'Services', '', '', '', '', '2023-12-29 11:59:09');

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

--
-- Table structure for table `tbl_services_desc`
--

CREATE TABLE `tbl_services_desc` (
  `id` int(11) NOT NULL,
  `services_desc` text NOT NULL,
  `services_title` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_services_desc`
--

INSERT INTO `tbl_services_desc` (`id`, `services_desc`, `services_title`) VALUES
(1, '<p>Established in 1990, Shaka Electrical India, has emerged today as a leading company in the field of facility management services like Electrifying highways, Fly-overs, walkways&nbsp;</p>\r\n\r\n<p>Established in 1990, Shaka Electrical India, has emerged today as a leading company in the field of facility management services like Electrifying highways, Fly-overs, walkways&nbsp;</p>\r\n\r\n<p>Established in 1990, Shaka Electrical India, has emerged today as a leading company in the field of facility management services like Electrifying highways, Fly-overs, walkways&nbsp;</p>\r\n\r\n<p>Established in 1990, Shaka Electrical India, has emerged today as a leading company in the field of facility management services like Electrifying highways, Fly-overs, walkways&nbsp;</p>\r\n', '');

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

--
-- Table structure for table `tbl_services_product`
--

CREATE TABLE `tbl_services_product` (
  `pro_id` int(11) NOT NULL,
  `pro_category` varchar(250) NOT NULL,
  `pro_name` varchar(200) NOT NULL,
  `pro_type` varchar(200) NOT NULL,
  `pro_offer` varchar(200) NOT NULL,
  `pro_desc` text NOT NULL,
  `pro_brf` text NOT NULL,
  `pro_more` text NOT NULL,
  `pro_image` varchar(250) NOT NULL,
  `status` varchar(11) NOT NULL,
  `status_gal` varchar(11) NOT NULL,
  `pro_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dp_rate` varchar(250) NOT NULL,
  `percentage` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_services_product`
--

INSERT INTO `tbl_services_product` (`pro_id`, `pro_category`, `pro_name`, `pro_type`, `pro_offer`, `pro_desc`, `pro_brf`, `pro_more`, `pro_image`, `status`, `status_gal`, `pro_date`, `dp_rate`, `percentage`) VALUES
(10, '10', 'Distribution supply chain management', '', '', '', '', '<p>We are having enriched experience of more than 7 years to help the hospital and pharmacy to provide supply support on time for good coordination.We are also presence online home delivery system to serve the hospital and patient requirements.</p>\r\n', '29807.jpg', '', '', '2023-12-29 12:02:24', '', ''),
(11, '10', 'Pharmacy', '', '', '', '', '<p>We are having enriched experience of more than 7 years to help the &nbsp;patient support &nbsp;to provide knowledge &nbsp;&amp; supply support on time for good coordination as you know pharmacy plays the vital role in health care ,We are also presence online home delivery system to serve the patient requirements.</p>\r\n', '30674.jpg', '', '', '2024-01-15 06:51:04', '', ''),
(12, '10', 'Diagnostic', '', '', '', '', '<p>We are having enriched experience of more than 3 years to help the &nbsp;patient support &nbsp;to provide knowledge &nbsp;&amp; qualitative diagnostic &amp; Path lab collection center in Delhi ncr &nbsp; approved collection center &nbsp;NABL quality reports We are also presence online home collection system to meet the patient requirements.</p>\r\n', '12451.jpg', '', '', '2024-01-15 06:50:54', '', '');

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

--
-- Table structure for table `tbl_service_desc`
--

CREATE TABLE `tbl_service_desc` (
  `ser` int(11) NOT NULL,
  `ser_category` varchar(255) NOT NULL,
  `ser_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_service_desc`
--

INSERT INTO `tbl_service_desc` (`ser`, `ser_category`, `ser_desc`) VALUES
(5, 'Cut to Length', '<p>Precision cutting to any length desired is our specialty. Straight off our tube mills we run a Haven 873 cutoff machine, which gives us the flexibility and precision to bring you top quality tubing exactly to specification.</p>\r\n'),
(6, 'Special Packaging', '<p>Sometimes special circumstances require special packaging. RTF can package your steel tubing order to meet your specifications.</p>\r\n'),
(7, 'Regional Delivery', '<p>Ask your Steel Tube Inc. Sales representative about our in- house delivery service. We run our own fleet of trucks for deliveries throughout India.</p>\r\n');

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

--
-- Table structure for table `tbl_service_home`
--

CREATE TABLE `tbl_service_home` (
  `ser_id` int(11) NOT NULL,
  `title_ser1` varchar(200) NOT NULL,
  `title_ser2` varchar(200) NOT NULL,
  `title_ser3` varchar(200) NOT NULL,
  `desc_ser1` text NOT NULL,
  `desc_ser2` text NOT NULL,
  `desc_ser3` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_service_home`
--

INSERT INTO `tbl_service_home` (`ser_id`, `title_ser1`, `title_ser2`, `title_ser3`, `desc_ser1`, `desc_ser2`, `desc_ser3`) VALUES
(6, 'Cut to Length', 'Special Packaging', 'Regional Delivery', '<p><strong>Precision</strong> cutting to any length desired is our specialty. Straight off our tube mills we run a Haven 873 cutoff machine, which gives us the flexibility and precision to bring you top quality tubing exactly to specification.</p>\r\n\r\n<p><strong>Precision</strong> cutting to any length desired is our specialty. Straight off our tube mills we run a Haven 873 cutoff machine, which gives us the flexibility and precision to bring you top quality tubing exactly to specification.</p>\r\n', '<p>Sometimes special circumstances require special packaging. RTF can package your steel tubing order to meet your specifications.</p>\r\n', '<p>Ask your Steel Tube Inc. Sales representative about our in- house delivery service. We run our own fleet of trucks for deliveries throughout India.</p>\r\n');

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

--
-- Table structure for table `tbl_small_banner1`
--

CREATE TABLE `tbl_small_banner1` (
  `project_id` int(11) NOT NULL,
  `project_name` varchar(400) NOT NULL,
  `project_desc` text NOT NULL,
  `project_image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_small_banner1`
--

INSERT INTO `tbl_small_banner1` (`project_id`, `project_name`, `project_desc`, `project_image`) VALUES
(3, 'ISO', '', '1652352748_two.jpg'),
(4, 'UDYAM', '', '1652352756_three.jpg'),
(5, 'FSSAI', '', '1652352806_ome.jpg');

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

--
-- Table structure for table `tbl_small_banner2`
--

CREATE TABLE `tbl_small_banner2` (
  `project_id` int(11) NOT NULL,
  `project_name` varchar(400) NOT NULL,
  `project_image` varchar(100) NOT NULL,
  `flash_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_small_banner2`
--

INSERT INTO `tbl_small_banner2` (`project_id`, `project_name`, `project_image`, `flash_desc`) VALUES
(19, 'Latest Machines', '1652260194_four.png', 'We have a sophisticated infrastructure facility, which is well equipped by latest machines that enable us to deliver quality products to our clients'),
(22, 'Deliver Best Quality Products', '1652260466_five.png', 'Our vision is to deliver excellent quality products at lowest price in shortest time at doorstep.'),
(23, ' Manufacturing Unit', '1652260492_six.png', 'Our manufacturing unit is equipped with latest machines. All our machines are operated by our expert technocrats who have a rich domain experience.');

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

--
-- Table structure for table `tbl_social_media`
--

CREATE TABLE `tbl_social_media` (
  `social_id` int(11) NOT NULL,
  `fb_add` varchar(220) NOT NULL,
  `twitter_add` varchar(220) NOT NULL,
  `google_add` varchar(220) NOT NULL,
  `linkdn_add` varchar(220) NOT NULL,
  `sovial_active` enum('Yes','No') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_social_media`
--

INSERT INTO `tbl_social_media` (`social_id`, `fb_add`, `twitter_add`, `google_add`, `linkdn_add`, `sovial_active`) VALUES
(1, 'https://www.facebook.com/profile.php?id=61555279378873&is_tour_dismissed=true', 'https://www.instagram.com/adynlifesciencesin/', 'https://www.linkedin.com/in/adyn-lifesciences-4100b92a8/', 'https://twitter.com/AdynLifesc59914 ', '');

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

--
-- Table structure for table `tbl_stativ_pages`
--

CREATE TABLE `tbl_stativ_pages` (
  `id` int(11) NOT NULL,
  `footer_desc` text NOT NULL,
  `add_certificate` varchar(200) NOT NULL,
  `logo_certificate` varchar(255) NOT NULL,
  `intro_title` varchar(100) NOT NULL,
  `why_desc` text NOT NULL,
  `why_image` varchar(100) NOT NULL,
  `connectivity_acheivement` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_stativ_pages`
--

INSERT INTO `tbl_stativ_pages` (`id`, `footer_desc`, `add_certificate`, `logo_certificate`, `intro_title`, `why_desc`, `why_image`, `connectivity_acheivement`) VALUES
(3, '<p>Established in 2008, Real Tile is engaged in manufacturing of Paver Block and Wall Tiles. Working under the mentorship of Mohammad, we have acquired a reputed stature in the industry.</p>\r\n', '5090RASHTRIYA STAINLESS STEEL.jpg', '22770new-icon.png', '', '<p>Our firm follows an ethical and grounded business policy and on based on it, we have gained a huge success. Our mission is to attain client satisfaction and therefore with each of our products, we meet the need. We have developed a competent infrastructure ensuring productivity and fulfil the demand. Our products are widely used because of its precise design, friendly pricing, supreme performance and easy to operate features.&nbsp;<br />\r\n<strong>Some of the merits that have received us consistency in the industry are:</strong></p>\r\n', '25665about-main.png', '');

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

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

CREATE TABLE `tbl_testimonial` (
  `testi_id` int(11) NOT NULL,
  `testi_name` varchar(150) NOT NULL,
  `testi_desc` text NOT NULL,
  `t_rationg` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_testimonial` (`testi_id`, `testi_name`, `testi_desc`, `t_rationg`) VALUES
(18, 'Kajal Chauhan', '<p>Excellent products and exceptional service.&nbsp;&nbsp;Adyn Life Science is my go-to for all medical requirements.</p>\r\n', ''),
(19, 'RajVeer Singh', '<p>Reliable and effective. Their products have transformed our healthcare institution.&nbsp;</p>\r\n', ''),
(20, 'Nitin Aggarwal', '<p>Best quality and cost-effective products. They also recommended me which product will be more effective.</p>\r\n', '');

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

--
-- Table structure for table `tbl_web_logo`
--

CREATE TABLE `tbl_web_logo` (
  `logo_id` int(11) NOT NULL,
  `logo_image_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_web_logo`
--

INSERT INTO `tbl_web_logo` (`logo_id`, `logo_image_name`) VALUES
(9, '1708512783_two.png');

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

--
-- Table structure for table `tbl_why_us`
--

CREATE TABLE `tbl_why_us` (
  `why_id` int(11) NOT NULL,
  `why_us_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_why_us`
--

INSERT INTO `tbl_why_us` (`why_id`, `why_us_description`) VALUES
(1, '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;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. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n');

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

--
-- Table structure for table `t_services`
--

CREATE TABLE `t_services` (
  `header_id` int(11) NOT NULL,
  `flash_title` varchar(280) NOT NULL,
  `flash_sub_title` longtext,
  `flash_sub_sub_title` longtext,
  `header_image_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_services`
--

INSERT INTO `t_services` (`header_id`, `flash_title`, `flash_sub_title`, `flash_sub_sub_title`, `header_image_name`) VALUES
(67, 'About The Brand ', '<p><span style=\"font-family:Georgia,serif\"><span style=\"font-size:22px\"><span style=\"color:#f1c40f\"><strong>Sustainability and Limited stock&nbsp;&nbsp;</strong></span></span></span></p>\r\n\r\n<p><strong>Almost all of our products are part of a limited stock. This means that the launched collection of products will only have a small number or pieces and will not be reproduced (or only reproduced on demand and availability of fabrics). We have decided to make this project as sustainable as possible.&nbsp;</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n', '<p><span style=\"font-family:Georgia,serif\"><span style=\"font-size:22px\"><span style=\"color:#f1c40f\"><strong>Purvanchal Wears</strong></span></span></span><span style=\"font-size:14px\"><span style=\"color:#f1c40f\"><strong>&nbsp;</strong></span></span></p>\r\n\r\n<p><strong>Under our most current income generation&nbsp; program called &lsquo;Swaavalamban&rsquo;, we have been training women in tailoring. The aim of this program has been to make wage, domestic working and homemaker women self reliant and increase their employment prospects.</strong></p>\r\n\r\n<p><strong>We are happy to announce that after a year of training, the women under swaavalamban are now set to create and sell apparel under the brand name Purvanchal Wears.The proceeds from this will be used to support them&nbsp; as well to fund this program. Join us in our venture by clicking the &#39;<span style=\"color:#4e5f70\">Products&#39;</span>&nbsp;option under &#39;Purvanchal Wears&#39;. Happy shopping!</strong></p>\r\n', '1649318177_tag.jpg');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `header_flash`
--
ALTER TABLE `header_flash`
  ADD PRIMARY KEY (`header_id`);

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

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

--
-- Indexes for table `tbl_adventure`
--
ALTER TABLE `tbl_adventure`
  ADD PRIMARY KEY (`adventure_id`);

--
-- Indexes for table `tbl_application`
--
ALTER TABLE `tbl_application`
  ADD PRIMARY KEY (`app_id`);

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

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

--
-- Indexes for table `tbl_category_img`
--
ALTER TABLE `tbl_category_img`
  ADD PRIMARY KEY (`img_id`);

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

--
-- Indexes for table `tbl_domestic_category`
--
ALTER TABLE `tbl_domestic_category`
  ADD PRIMARY KEY (`cat_id`);

--
-- Indexes for table `tbl_domestic_product`
--
ALTER TABLE `tbl_domestic_product`
  ADD PRIMARY KEY (`pro_id`);

--
-- Indexes for table `tbl_domestic_product_image`
--
ALTER TABLE `tbl_domestic_product_image`
  ADD PRIMARY KEY (`gal_id`);

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

--
-- Indexes for table `tbl_footer_logo`
--
ALTER TABLE `tbl_footer_logo`
  ADD PRIMARY KEY (`logo_id`);

--
-- Indexes for table `tbl_gallery`
--
ALTER TABLE `tbl_gallery`
  ADD PRIMARY KEY (`gal_id`);

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

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

--
-- Indexes for table `tbl_home_about_flash`
--
ALTER TABLE `tbl_home_about_flash`
  ADD PRIMARY KEY (`client_logo_id`);

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

--
-- Indexes for table `tbl_infratruture`
--
ALTER TABLE `tbl_infratruture`
  ADD PRIMARY KEY (`header_id`);

--
-- Indexes for table `tbl_legal_desc`
--
ALTER TABLE `tbl_legal_desc`
  ADD PRIMARY KEY (`legl_id`);

--
-- Indexes for table `tbl_logo_client`
--
ALTER TABLE `tbl_logo_client`
  ADD PRIMARY KEY (`client_logo_id`);

--
-- Indexes for table `tbl_more_blog`
--
ALTER TABLE `tbl_more_blog`
  ADD PRIMARY KEY (`gal_id`);

--
-- Indexes for table `tbl_news_letter`
--
ALTER TABLE `tbl_news_letter`
  ADD PRIMARY KEY (`news_letter_id`);

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

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

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

--
-- Indexes for table `tbl_product_image`
--
ALTER TABLE `tbl_product_image`
  ADD PRIMARY KEY (`gal_id`);

--
-- Indexes for table `tbl_product_pdf`
--
ALTER TABLE `tbl_product_pdf`
  ADD PRIMARY KEY (`gal_id`);

--
-- Indexes for table `tbl_pro_home`
--
ALTER TABLE `tbl_pro_home`
  ADD PRIMARY KEY (`pro_id`);

--
-- Indexes for table `tbl_selling`
--
ALTER TABLE `tbl_selling`
  ADD PRIMARY KEY (`selling_id`);

--
-- Indexes for table `tbl_sertificate`
--
ALTER TABLE `tbl_sertificate`
  ADD PRIMARY KEY (`sertificate_id`);

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

--
-- Indexes for table `tbl_services_category`
--
ALTER TABLE `tbl_services_category`
  ADD PRIMARY KEY (`cat_id`);

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

--
-- Indexes for table `tbl_services_product`
--
ALTER TABLE `tbl_services_product`
  ADD PRIMARY KEY (`pro_id`);

--
-- Indexes for table `tbl_service_desc`
--
ALTER TABLE `tbl_service_desc`
  ADD PRIMARY KEY (`ser`);

--
-- Indexes for table `tbl_service_home`
--
ALTER TABLE `tbl_service_home`
  ADD PRIMARY KEY (`ser_id`);

--
-- Indexes for table `tbl_small_banner1`
--
ALTER TABLE `tbl_small_banner1`
  ADD PRIMARY KEY (`project_id`);

--
-- Indexes for table `tbl_small_banner2`
--
ALTER TABLE `tbl_small_banner2`
  ADD PRIMARY KEY (`project_id`),
  ADD UNIQUE KEY `project_image` (`project_image`);

--
-- Indexes for table `tbl_social_media`
--
ALTER TABLE `tbl_social_media`
  ADD PRIMARY KEY (`social_id`);

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

--
-- Indexes for table `tbl_testimonial`
--
ALTER TABLE `tbl_testimonial`
  ADD PRIMARY KEY (`testi_id`);

--
-- Indexes for table `tbl_web_logo`
--
ALTER TABLE `tbl_web_logo`
  ADD PRIMARY KEY (`logo_id`);

--
-- Indexes for table `tbl_why_us`
--
ALTER TABLE `tbl_why_us`
  ADD PRIMARY KEY (`why_id`);

--
-- Indexes for table `t_services`
--
ALTER TABLE `t_services`
  ADD PRIMARY KEY (`header_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `client_logo`
--
ALTER TABLE `client_logo`
  MODIFY `client_logo_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `header_flash`
--
ALTER TABLE `header_flash`
  MODIFY `header_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_add_list`
--
ALTER TABLE `tbl_add_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `tbl_adventure`
--
ALTER TABLE `tbl_adventure`
  MODIFY `adventure_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tbl_application`
--
ALTER TABLE `tbl_application`
  MODIFY `app_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_banner`
--
ALTER TABLE `tbl_banner`
  MODIFY `banner_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `tbl_category`
--
ALTER TABLE `tbl_category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tbl_category_img`
--
ALTER TABLE `tbl_category_img`
  MODIFY `img_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;

--
-- AUTO_INCREMENT for table `tbl_contact_desc`
--
ALTER TABLE `tbl_contact_desc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_domestic_category`
--
ALTER TABLE `tbl_domestic_category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_domestic_product`
--
ALTER TABLE `tbl_domestic_product`
  MODIFY `pro_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_domestic_product_image`
--
ALTER TABLE `tbl_domestic_product_image`
  MODIFY `gal_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_enquery`
--
ALTER TABLE `tbl_enquery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `tbl_footer_logo`
--
ALTER TABLE `tbl_footer_logo`
  MODIFY `logo_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_gallery`
--
ALTER TABLE `tbl_gallery`
  MODIFY `gal_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;

--
-- AUTO_INCREMENT for table `tbl_grc`
--
ALTER TABLE `tbl_grc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_home_about`
--
ALTER TABLE `tbl_home_about`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_home_about_flash`
--
ALTER TABLE `tbl_home_about_flash`
  MODIFY `client_logo_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- AUTO_INCREMENT for table `tbl_home_why_choose_us`
--
ALTER TABLE `tbl_home_why_choose_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_infratruture`
--
ALTER TABLE `tbl_infratruture`
  MODIFY `header_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_legal_desc`
--
ALTER TABLE `tbl_legal_desc`
  MODIFY `legl_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_logo_client`
--
ALTER TABLE `tbl_logo_client`
  MODIFY `client_logo_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

--
-- AUTO_INCREMENT for table `tbl_more_blog`
--
ALTER TABLE `tbl_more_blog`
  MODIFY `gal_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_news_letter`
--
ALTER TABLE `tbl_news_letter`
  MODIFY `news_letter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tbl_new_blog`
--
ALTER TABLE `tbl_new_blog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_our_mission`
--
ALTER TABLE `tbl_our_mission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_product`
--
ALTER TABLE `tbl_product`
  MODIFY `pro_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `tbl_product_image`
--
ALTER TABLE `tbl_product_image`
  MODIFY `gal_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;

--
-- AUTO_INCREMENT for table `tbl_product_pdf`
--
ALTER TABLE `tbl_product_pdf`
  MODIFY `gal_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_pro_home`
--
ALTER TABLE `tbl_pro_home`
  MODIFY `pro_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_selling`
--
ALTER TABLE `tbl_selling`
  MODIFY `selling_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_sertificate`
--
ALTER TABLE `tbl_sertificate`
  MODIFY `sertificate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `tbl_services`
--
ALTER TABLE `tbl_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_services_category`
--
ALTER TABLE `tbl_services_category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tbl_services_desc`
--
ALTER TABLE `tbl_services_desc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_services_product`
--
ALTER TABLE `tbl_services_product`
  MODIFY `pro_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tbl_service_desc`
--
ALTER TABLE `tbl_service_desc`
  MODIFY `ser` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_service_home`
--
ALTER TABLE `tbl_service_home`
  MODIFY `ser_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_small_banner1`
--
ALTER TABLE `tbl_small_banner1`
  MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_small_banner2`
--
ALTER TABLE `tbl_small_banner2`
  MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `tbl_social_media`
--
ALTER TABLE `tbl_social_media`
  MODIFY `social_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_stativ_pages`
--
ALTER TABLE `tbl_stativ_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_testimonial`
--
ALTER TABLE `tbl_testimonial`
  MODIFY `testi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `tbl_web_logo`
--
ALTER TABLE `tbl_web_logo`
  MODIFY `logo_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `tbl_why_us`
--
ALTER TABLE `tbl_why_us`
  MODIFY `why_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `t_services`
--
ALTER TABLE `t_services`
  MODIFY `header_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
COMMIT;

