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

START TRANSACTION;



--
-- Database: `adarshaf`
--

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

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

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

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

INSERT INTO `client_logo` (`client_logo_id`, `logo_link`, `logo_image_name`, `type`) VALUES
(117, '', '1609746005_logo1.png', '1'),
(118, '', '1609746009_logo2.png', '1'),
(119, '', '1609746016_logo3.png', '1'),
(120, '', '1609746020_logo4.png', '1'),
(121, '', '1609746025_logo5.png', '1'),
(122, '', '1609746030_logo6.png', '1');

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

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

CREATE TABLE `header_flash` (
  `header_id` int(11) NOT NULL,
  `header_image_name` varchar(300) NOT NULL,
  `flash_title` varchar(200) NOT NULL,
  `pro_name_one` varchar(200) NOT NULL,
  `pro_name_two` varchar(200) NOT NULL,
  `pro_name_three` varchar(300) NOT NULL,
  `pro_name_four` varchar(300) NOT NULL,
  `pro_name_five` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `header_flash` (`header_id`, `header_image_name`, `flash_title`, `pro_name_one`, `pro_name_two`, `pro_name_three`, `pro_name_four`, `pro_name_five`) VALUES
(52, '1662636041_1.jpg', ' QUALITY <span>ORTHOPADEIC CARE</span> AT <br>AFFORDABLEPRICE SERVICES', 'Adarsha Orthopaedic Centre is hospital with world class infrastructure and facilities.', '', 'Hydraulics, Pneumatics', 'and Automation', 'right'),
(59, '1662636034_1.png', 'COMPUTER NAVIGATION <span>JOINT <br>REPLACEMENT SURGEON</span>', 'We dares to care for its patients at any time irrespective of the nature of his/her problem.', '', 'Quality Brass Fittings', 'Components', 'left');

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

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

CREATE TABLE `tbl_about_us` (
  `id` int(11) NOT NULL,
  `about_desc` 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,
  `benifit` text NOT NULL,
  `technique` text NOT NULL,
  `grc_screen` text NOT NULL,
  `benifite_desc` text NOT NULL,
  `technique_desc` text NOT NULL,
  `grc_desc` text NOT NULL,
  `ta1` varchar(300) NOT NULL,
  `ta2` varchar(300) NOT NULL,
  `ta3` varchar(300) NOT NULL,
  `ta4` varchar(300) NOT NULL,
  `ta5` varchar(300) NOT NULL,
  `ta6` varchar(300) NOT NULL,
  `about_image` varchar(100) NOT NULL,
  `about_image2` varchar(200) NOT NULL,
  `about_image3` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_about_us` (`id`, `about_desc`, `title1`, `title2`, `title3`, `title4`, `title5`, `title6`, `title7`, `benifit`, `technique`, `grc_screen`, `benifite_desc`, `technique_desc`, `grc_desc`, `ta1`, `ta2`, `ta3`, `ta4`, `ta5`, `ta6`, `about_image`, `about_image2`, `about_image3`) VALUES
(1, '<h1><strong><span style=\"color:#0cb8b6\">WE ARE THE BEST</span><br />\r\n<span style=\"color:#111d30\">JOINT REPLACEMENT &amp; RESEARCH&nbsp;CENTER</span></strong></h1>\r\n\r\n<p>Adarsha Orthopaedic&nbsp;Centre is one of the best hospitals of its kind in Visakhapatnam,&nbsp;Andhra Pradesh. This hospital is established by a team of highly qualified, dedicated,diligent and devoted doctors.We have highly qualified and devoted team of both medico and paramedico staff members.&nbsp;We work with the latest and new technology for better work experience in this field.</p>\r\n\r\n<ul>\r\n	<li>Highly Qualified Doctors</li>\r\n	<li>24&times;7 Emergency Services</li>\r\n	<li>Patient Centered Care</li>\r\n	<li>Online Service</li>\r\n</ul>\r\n\r\n<p>We offer world-class solutions to patients suffering from the ailments of bone and joints. This facility is equipped with all the latest state-of-the-art machines to undertake all the surgical procedures listed.</p>\r\n', '', 'We help customers development', 'We provide 24x7 support Center\r\n\r\n', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1609837154_medical-center-2.jpg', '', '');

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

--
-- 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_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(10) NOT NULL DEFAULT '1',
  `banner_image_name` varchar(200) NOT NULL,
  `banner_link` varchar(200) 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_link`) VALUES
(34, '24 Hours X-Ray', 'We provide X-Ray services at affoprdable price with our high-speed technologies.', 1, '1661576643_one.png', '#'),
(35, '24 Hours Lab', 'We offer 24 Hours Lab services to our patients. We used latest technologies.', 1, '1661576433_two.png', '#'),
(38, '24 Hours Accident Care', 'We are the best 24 Hours Accident Care Service Providers in Delhi.', 1, '1661576534_three.png', '#'),
(39, '24 Hours X-Ray', 'The x-ray machine sends individual x-ray particles, called photons. These particles pass through the body and a computer or special film is used to record the images that are created. We are a top-notch digital X-ray service provider, offering all types of portable facilities with state-of-the-art e', 2, '1662701479_1609827025_department_1_column.jpg', ''),
(40, '24 Hours Lab', 'Being the pioneers in the healthcare sector since the last 36 years, the Adarsha has a legacy of providing excellence in all aspects of healthcare blood tests at home.  Carrying the same ethos of quality healthcare forward.', 2, '1662701746_1609827636_department_1_column2.jpg', ''),
(41, ' 24 Hours Accident Care', 'We are one of the largest accident and emergency medicine departments with years of expertise in the field, treating thousands of patients each year. The wards in the department are well furnished with the latest technology machines.', 2, '1662703912_1609827739_department_1_column3.jpg', ''),
(42, 'MLC Cases Taken ', 'We will take MLC Cases also. A Medico-Legal Case can be defined as a case of injury or ailment, etc., in which investigations by the law-enforcing agencies are essential to fix the responsibility regarding the causation of the injury or ailment.', 2, '1662703966_1609827765_department_1_column4.jpg', ''),
(43, 'MLC Cases Taken', 'We will accept the MLC Cases and provide best quality services.', 1, '1661576804_four.png', '#'),
(44, 'Team Of Ortho Neuro and Plastic Surgeons', 'We have a experience tesm of ortho neuro and plastic surgeons.', 1, '1661576893_five.png', '#'),
(45, 'Exclusive Orthopaedic Operation Theatre', 'We provide a Exclusive Orthopaedic Operation Theatre to our patients.', 1, '1661577103_six.png', '#'),
(46, 'Full Fledged Physiotheraphy unit', 'Adarsha Orthopaedic center have a Full Fledged Physiotheraphy unit.', 1, '1661577199_seven.png', '#'),
(48, 'Ambulance Service', 'Adarsha Orthopaedic center also provide a Ambulance Service to our patients.', 1, '1661577296_eight.png', '#'),
(49, 'Dr. I Satish Raju', '\r\n                                MS (Ortho). MCh (Ortho), FCIR (Germany) \r\nHOD & Chief Robotic Joint Replacement Surgeon\r\n                                ', 3, '1662362265_one.jpg', ''),
(50, 'Dr. M Satish', ' MS (Ortho), FISS, FUR (Switzerland), FICT (China) Consultant Spine & Orthopaedic Surgeon', 3, '1662362311_one.jpg', ''),
(51, 'Dr. G Srinivas', 'MS (Ortho ), FUR, FIAS Consultant Arthroscopy Surgeon & Sport Medicine Specialist', 3, '1662362341_one.jpg', ''),
(52, 'Dr. G Santosh', 'MS (Ortho), FNB Trauma Care Consultant Orthopaedic & Polyrauma Specialist', 3, '1662362367_one.jpg', ''),
(53, 'Dr. T Alekhya', 'Ms (Ortho)\r\nFellow in Orthopaedic Trauma', 3, '1662362398_two.jpg', ''),
(54, 'Teleradiology', 'Best place for Teleradiology Solutions<br>at very reasonable prices', 4, '1609910241_test.png', ''),
(55, 'Radiologists', 'We provide Radiologists services to<br>our valued paitents.', 4, '1609910187_three.png', ''),
(56, 'Artifical Intelligence', 'Rad-heal, your partner in the department of Artifical Intelligence.', 4, '1609910197_two.png', ''),
(57, 'Imaging Services', 'We provide 3D Imaging Services. Our<br>Imaging Services are the best in class.', 4, '1609910258_one.png', ''),
(58, 'Team Of Ortho Neuro and Plastic Surgeons', 'The Hospital specializes in Accident & Trauma care, Joint Replacement, Spine Surgery, Arthroscopy, Plastic Surgery and Facial Surgeries providing a total and integrated trauma care available 24x7.', 2, '1662704060_1661577632_one.jpg', ''),
(59, 'Dr. Y Surendra', 'Ms (Ortho)\r\nFellow in Orthopaedic Trauma', 3, '1662362409_one.jpg', ''),
(60, 'Exclusive Orthopaedic Operation Theatre', 'It’s the ultramodern and ultraclean OT matching all international sterility protocols and standards. All joint replacement surgeries, spine surgeries, major cancer surgeries, supra-major gastrointestinal and hepatobiliary surgeries, advanced laparoscopic surgeries, cochlear implant surgeries etc are', 2, '1662704296_123.jpg', ''),
(61, 'Full Fledged Physiotheraphy Unit', 'We are a team of highly qualified and committed physiotherapists dedicated to help you gain full functional independence. All our are treatment plans are evidence based and updated periodically. We understand the importance of humane, compassionate care and resonate the same in all spheres of our tr', 2, '1662704838_3.jpg', ''),
(62, 'Rammurthy Trust (Free Surgical Care) For Poor Patient', 'The Scheme provides for financial assistance to patients, living below poverty line and who is suffering from major life threatening diseases, to receive medical treatment at any of the super specialty Government hospitals / institutes.', 2, '1662704941_12344.jpg', ''),
(63, 'Ambulance Service', 'We providing best ambulance services. Many people have experienced our services and have said that our services are the most effective and on-time ambulance services available. You will not find so much customized options like this anywhere else with the quality of service which we provide.', 2, '1662364473_one.jpg', '');

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

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

CREATE TABLE `tbl_best_sell` (
  `id` int(11) NOT NULL,
  `linking` varchar(300) 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`, `linking`, `image`) VALUES
(1, 'about.php', '1609915318_testimonials.png');

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

--
-- 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) 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_category`
--

INSERT INTO `tbl_category` (`cat_id`, `cate_name`, `category_image`, `cate_desc`, `stastus`, `home_status`, `dat`) VALUES
(15, '3 In 1', '', '', '', '', '2021-01-04 10:03:00'),
(16, 'Appu 8 Band Grip', '', '', '', '', '2021-01-04 10:03:06'),
(17, 'Butterfly 8 Band Grip', '', '', '', '', '2021-01-04 10:03:16'),
(18, ' Delux Swing', '', '', '', '', '2021-01-04 10:03:23'),
(19, 'Duckling Adjustable Walker', '', '', '', '', '2021-01-04 10:03:33'),
(20, ' Mickey Walker', '', '', '', '', '2021-01-04 10:03:42');

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

--
-- 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_event`
--

CREATE TABLE `tbl_event` (
  `id` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `A_name` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `home_status` varchar(50) NOT NULL,
  `image` varchar(200) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_event`
--

INSERT INTO `tbl_event` (`id`, `name`, `A_name`, `time`, `home_status`, `image`, `date`, `desc`) VALUES
(17, 'Students Workshop', 'APS Grand', 'JUNE 6, 2016', 'Home', '18755.jpg', '2020-10-01 10:34:43', '<p>Workshops are regularly organized by the school. Resource people and experts are invited for this purpose.&nbsp;While conducting workshop emphasis is given in the field of art and craft, dramatics, social awareness, manners, science etc.</p>\r\n'),
(18, 'Parents are requested to attend a meeting on Monday', 'APS Grand', 'JUNE 6, 2016', 'Remove', '7070.jpg', '2020-10-01 10:38:39', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n'),
(19, 'Parents are requested to attend a meeting on Monday', 'APS Grand', 'JUNE 6, 2016', '', '10316.jpg', '2020-10-01 10:39:16', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</p>\r\n');

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

--
-- 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, '1609750652_footer-logo.png');

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

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

CREATE TABLE `tbl_gallery` (
  `gal_id` int(11) NOT NULL,
  `gal_name` varchar(255) NOT NULL,
  `gal_category` varchar(255) 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_gallery`
--

INSERT INTO `tbl_gallery` (`gal_id`, `gal_name`, `gal_category`, `gal_image`, `gal_date`) VALUES
(74, '', '', '1662363527_one.jpeg', '2022-09-05 07:38:47'),
(76, '', '', '1662363539_two.jpeg', '2022-09-05 07:38:59'),
(77, '', '', '1662363545_three.jpeg', '2022-09-05 07:39:05'),
(78, '', '', '1662363551_four.jpeg', '2022-09-05 07:39:11'),
(79, '', '', '1662363555_five.jpeg', '2022-09-05 07:39:15'),
(80, '', '', '1662363562_six.jpeg', '2022-09-05 07:39:22'),
(81, '', '', '1662363571_seven.jpeg', '2022-09-05 07:39:31'),
(82, '', '', '1662363576_eight.jpeg', '2022-09-05 07:39:36'),
(83, '', '', '1662363581_nine.jpeg', '2022-09-05 07:39:41'),
(84, '', '', '1662363588_ten.jpeg', '2022-09-05 07:39:48'),
(85, '', '', '1662363594_eleven.jpeg', '2022-09-05 07:39:54'),
(86, '', '', '1662363599_twelve.jpeg', '2022-09-05 07:39:59'),
(87, '', '', '1662363606_thirteen.jpeg', '2022-09-05 07:40:06'),
(88, '', '', '1662363614_fourteen.jpeg', '2022-09-05 07:40:14'),
(89, '', '', '1662363619_fifteen.jpeg', '2022-09-05 07:40:19'),
(90, '', '', '1662363626_sixteen.jpeg', '2022-09-05 07:40:26'),
(91, '', '', '1662363633_seventeen.jpeg', '2022-09-05 07:40:33'),
(92, '', '', '1662363638_eighteen.jpeg', '2022-09-05 07:40:38'),
(93, '', '', '1662363646_nineteen.jpeg', '2022-09-05 07:40:46');

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

--
-- 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(200) NOT NULL,
  `title9` varchar(200) NOT NULL,
  `title10` varchar(300) NOT NULL,
  `title11` varchar(300) NOT NULL,
  `title12` 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,
  `home_image` varchar(200) 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`, `title10`, `title11`, `title12`, `desc1`, `desc2`, `desc3`, `desc4`, `desc5`, `desc6`, `image`, `home_image`) VALUES
(1, '<p>Rapid Safety Solutions is a progressive enterprise initiated by its promoter<br />\r\n<strong>Mr. Lalit Dutt</strong>, a mechanical engineer by qualification, having in-depth knowledge and wide experience in Fire Safety &amp; Personal Protection industry. He has been in this field for last 22 years.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are the&nbsp;<strong>Authorized Dealers</strong>&nbsp;of Ravels - Fire Alarm &amp; Detection Systems.</p>\r\n', 'Our mission is to care for patients,<br>families, communities, and one another.', 'Dr. I Satish Raju', '29', '', 'We have a Strong client credentials and references. Our team brings important experience and knowledge.', 'Exceptionally high-quality specialist surgeons trained at top universities.', 'We work with the latest and new technology for better work experience in thsi field.', 'Over a decade of experience in orthopaedic care, We have a yet a boutique experience.', '150k', 'For over 15 years, we have delighted our customers and provide them with the necessary services', '100%', 'Absolutely all our clients are ready to assure you of the high quality of our services', '', '<h5>who we are</h5>\r\n\r\n<h1><span style=\"color:#2c5485\"><strong>JOINT REPLACEMENT</strong></span><br />\r\n<strong><span style=\"color:#333333\">CLINIC</span></strong></h1>\r\n\r\n<h2>We offer Best quality services at affordable pricing.</h2>\r\n\r\n<p>Adarsha Orthopaedic&nbsp;Centre is one of the best hospitals of its kind in Visakhapatnam,&nbsp;Andhra Pradesh. This hospital is established by a team of highly qualified, dedicated,diligent and devoted doctors.We have highly qualified and devoted team of both medico and paramedico staff members.&nbsp;We work with the latest and new technology for better work experience in this field.</p>\r\n', '<p><span style=\"color:#000000\"><span style=\"font-size:17px\"><strong>The Best Product For You</strong></span></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are manufacturing an extensive collection of Industrial Hydraulic, Hydraulic Cylinders, Pneumatic Cylinders and more. Our well-equipped infrastructure has enabled us to produce the high quality products.</p>\r\n', '<ul>\r\n	<li>GMR Indra Gandhi Airport</li>\r\n	<li>MES</li>\r\n	<li>Air Force</li>\r\n	<li>Nhai</li>\r\n	<li>Sub Register Of Authority</li>\r\n	<li>New Oxford School</li>\r\n	<li>Adarsh Public School</li>\r\n	<li>Aggarwal Sweets</li>\r\n	<li>Bikaner Sweets</li>\r\n	<li>Aap Ka Bazar</li>\r\n	<li>Ozone GYM</li>\r\n</ul>\r\n', '', '', '1662637430_signature.png', '1609911442_about-img.jpg');

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

--
-- Table structure for table `tbl_news`
--

CREATE TABLE `tbl_news` (
  `id` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `A_name` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `home_status` varchar(50) NOT NULL,
  `image` varchar(200) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_news`
--

INSERT INTO `tbl_news` (`id`, `name`, `A_name`, `time`, `home_status`, `image`, `date`, `desc`) VALUES
(17, 'Professor Albert joint research on mobile money in Tanzania', 'JOHN SMITH', 'JUNE 6, 2016', 'Home', '30784.jpg', '2020-10-01 08:58:40', '<p>A wonderful serenity has taken possession of my entire soul, like these sweet mornings of spring which I enjoy with my whole heart. I am alone, and feel the charm of existence in this spot, which was created for the bliss of souls like mine. I am so happy, my dear friend, so absorbed in the exquisite sense of mere tranquil existence, that I neglect my talents.</p>\r\n'),
(18, 'A Global MBA for the next generation of business leaders', 'BYJOHN SMITH', 'JUNE 6, 2016', 'Remove', '7070.jpg', '2020-10-01 08:57:38', ''),
(19, 'Professor Tom comments on voluntary recalls by snack brands', 'John Smith', 'JUNE 6, 2016', '', '10316.jpg', '2020-10-01 04:15:41', ''),
(20, 'Professor Tom comments on voluntary recalls by snack brands', 'John Smith', 'JUNE 6, 2016', '', '5759.jpg', '2020-10-01 04:16:20', '');

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

--
-- 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` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 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_price` varchar(100) NOT NULL,
  `pro_Pack` varchar(300) 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) NOT NULL,
  `status_gal` varchar(10) NOT NULL,
  `pro_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 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
(20, 154, '1608116456_pro-back-10.png', '2020-12-16 11:00:56'),
(21, 154, '1608116461_pro-back-10.png', '2020-12-16 11:01:01'),
(22, 154, '1608116486_pro-back-03.png', '2020-12-16 11:01:26'),
(23, 154, '1608116490_pro-back-04.png', '2020-12-16 11:01:30');

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

--
-- Table structure for table `tbl_pro_gallery`
--

CREATE TABLE `tbl_pro_gallery` (
  `gal_id` int(11) NOT NULL,
  `pro_id` varchar(50) NOT NULL,
  `gal_name` varchar(255) NOT NULL,
  `gal_category` varchar(255) 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_pro_gallery`
--

INSERT INTO `tbl_pro_gallery` (`gal_id`, `pro_id`, `gal_name`, `gal_category`, `gal_image`, `gal_date`) VALUES
(68, '18', 'Fire Bell', 'Fire Alarm', '19371.jpg', '2020-08-20 14:55:04'),
(71, '18', 'MCP Fire Flarm', 'Fire Alarm', '30883.jpg', '2020-08-20 14:55:52'),
(73, '18', 'Cnventional System', 'Fire Alarm', '14240.jpg', '2020-08-20 14:56:43'),
(74, '18', 'Addressable System', 'Fire Alarm', '32161.jpg', '2020-08-20 14:57:28'),
(75, '18', 'Public Address System', 'Fire Alarm', '23782.jpg', '2020-08-20 14:58:00'),
(76, '18', 'Smoke Detector', 'Fire Alarm', '31743.jpg', '2020-08-20 14:59:28');

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

--
-- 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_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_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, '#', '#', '', '#', '');

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

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

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

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

INSERT INTO `tbl_testimonial` (`testi_id`, `testi_name`, `testi_loction`, `testi_desc`) VALUES
(2, 'Rohan Verma', '', '<p>Adarsha helping us with high volume reporting. Strong surgeon team makes it possible. Best part is they keep demanding history, previous scans or report. And never try to cut corners.</p>\r\n'),
(6, 'Deepak Singh', '', '<p>We are very pleased with the services of yours surgeons preliminary reads. I have also received positive feedback from the clinicians, including the x ray docs who are very happy with the service...</p>\r\n'),
(13, 'Jasmeet Kaur', '', '<p>We are very pleased with the services of yours surgeons preliminary reads. I have also received positive feedback from the clinicians, including the x ray docs who are very happy with the service...</p>\r\n'),
(14, 'Rashmi Gupta', '', '<p>Rad Heal helping us with high volume reporting. Strong radiology team makes it possible. Best part is they keep demanding history, previous scans or report. And never try to cut corners.</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,
  `new_and_update` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_web_logo` (`logo_id`, `logo_image_name`, `new_and_update`) VALUES
(9, '1662357119_logos.png', '1609565830_certificate.pdf');

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

--
-- 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');

--
-- 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_banner`
--
ALTER TABLE `tbl_banner`
  ADD PRIMARY KEY (`banner_id`);

--
-- Indexes for table `tbl_best_sell`
--
ALTER TABLE `tbl_best_sell`
  ADD PRIMARY KEY (`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_event`
--
ALTER TABLE `tbl_event`
  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_home_about`
--
ALTER TABLE `tbl_home_about`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `tbl_news_letter`
--
ALTER TABLE `tbl_news_letter`
  ADD PRIMARY KEY (`news_letter_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_pro_gallery`
--
ALTER TABLE `tbl_pro_gallery`
  ADD PRIMARY KEY (`gal_id`);

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

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

--
-- Indexes for table `tbl_social_media`
--
ALTER TABLE `tbl_social_media`
  ADD PRIMARY KEY (`social_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`);

--
-- 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=123;

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

--
-- 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_banner`
--
ALTER TABLE `tbl_banner`
  MODIFY `banner_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

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

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

--
-- 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_event`
--
ALTER TABLE `tbl_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- 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=94;

--
-- 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_news`
--
ALTER TABLE `tbl_news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

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

--
-- 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 for table `tbl_product_image`
--
ALTER TABLE `tbl_product_image`
  MODIFY `gal_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

--
-- 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_service_desc`
--
ALTER TABLE `tbl_service_desc`
  MODIFY `ser` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- 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_testimonial`
--
ALTER TABLE `tbl_testimonial`
  MODIFY `testi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- 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;
COMMIT;

