(104,'0','3,4,5,6,24,2,7,31,33,8,37,38,39,40,41,42,43,36,9,55,56,57,58,10,63,64,11,67,12,70,71,72,73,74,75,13,82,14,15,16,86,87,88,89,17,95,96,97,98,99,100,101,102,18,19,112,115,116,117,118,119,120,121,122,113,123,124,125,20,138,139,140','51','','','','','<div class=\"cmTitle\">Transforming Bridge Safety and Lifespan with Our Services in {location}</div>\r\n\r\n<p>The best Structural Steel Bridge Inspection Services are offered by Inspection &amp; Testing Engineers in <strong>{location}</strong> to maintain the resilience and safety of your bridge infrastructure. For those seeking dependable <strong>Structural Steel Bridge Inspection Services in {location}</strong>, we are your leading service provider among others. Our services in<strong> {location}</strong> involve a meticulous examination of all steel components of your bridge, utilizing advanced techniques and industry standards. By identifying potential issues such as corrosion, cracks, and wear early on, we help prevent minor problems from escalating into major concerns that could compromise the bridge&rsquo;s structural integrity in <strong>{location}</strong>. Our inspections are conducted according to strict guidelines to ensure that every aspect of the bridge&#39;s steel framework is thoroughly evaluated in <strong>{location}</strong>, ensuring continued safety and functionality.</p>\r\n\r\n<ul>\r\n	<li><strong>Comprehensive Inspections</strong>: We perform in-depth evaluations to check the condition of all structural steel elements in <strong>{location}</strong>.</li>\r\n	<li><strong>Early Issue Detection</strong>: Our inspections identify early signs of deterioration, corrosion, or damage that could lead to bigger problems in <strong>{location}</strong>.</li>\r\n	<li><strong>Enhanced Safety</strong>: By identifying and addressing issues early in <strong>{location}</strong>, we ensure the bridge remains safe for public use and compliant with safety standards.</li>\r\n	<li><strong>Regulatory Compliance</strong>: We adhere to relevant codes and standards in <strong>{location}</strong>, ensuring that your bridge meets all necessary safety regulations.</li>\r\n</ul>\r\n\r\n<div class=\"cmTitle\">Get Ahead with Our Inspection Edge: Key Benefits in {location}</div>\r\n\r\n<h3>Structural Steel Bridge Inspection Service Provider in {location}</h3>\r\n\r\n<p>Our expert team brings extensive experience and specialized knowledge to every inspection in <strong>{location}</strong>, providing you with accurate, reliable assessments and recommendations. As compared to any other <strong>Structural Steel Bridge Inspection Service Provider in {location}</strong>, we offer numerous advantages for maintaining the structural integrity and reliability of your bridge. By choosing our services in <strong>{location}</strong>, you benefit from cutting-edge inspection technology and a thorough approach that ensures your bridge remains in optimal condition. We help you make informed decisions about maintenance and repairs in <strong>{location}</strong>, extending the lifespan of your bridge and enhancing its overall performance.</p>\r\n\r\n<ul>\r\n	<li><strong>Expert Guidance</strong>: Our team consists of highly trained professionals in <strong>{location}</strong> who bring expertise in structural steel inspection.</li>\r\n	<li><strong>Advanced Technology</strong>: We use state-of-the-art equipment and techniques to deliver precise and reliable inspection results in <strong>{location}</strong>.</li>\r\n	<li><strong>Detailed Reports</strong>: Our inspections include comprehensive reports that provide clear insights and recommendations for maintenance in <strong>{location}</strong>.</li>\r\n	<li><strong>Long-Term Savings</strong>: Early detection of issues and proper maintenance help prevent costly repairs and extend the bridge&rsquo;s service life in <strong>{location}</strong>.</li>\r\n</ul>\r\n','','','The best Structural Steel Bridge Inspection Services are offered by Inspection & Testing Engineers in {location} to maintain the resilience and safety of your bridge infrastructure. For those seeking dependable Structural Steel Bridge Inspection Services in {location}, we are your leading service provider among others.');

--
-- Table structure for table `location_tbl`
--

CREATE TABLE `location_tbl` (
  `locationID` int(11) NOT NULL AUTO_INCREMENT,
  `locationType` varchar(10) DEFAULT NULL,
  `locationurl` varchar(100) DEFAULT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `locationName` varchar(800) NOT NULL DEFAULT '',
  `locationtDesc` text,
  `locationDesc1` text,
  `locationImage` varchar(50) NOT NULL DEFAULT '',
  `toplocation` char(1) NOT NULL DEFAULT 'N',
  `locationOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text,
  `pageDescription` text,
  `pageTitle1` varchar(250) DEFAULT NULL,
  `pageDescription1` text,
  `pageKeywords1` text,
  `locationPosition` int(11) NOT NULL DEFAULT '0',
  `locationIcon` varchar(100) DEFAULT NULL,
  `loc_url` varchar(250) DEFAULT NULL,
  `old_url` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`locationID`)
) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `location_tbl`
--

INSERT INTO `location_tbl` VALUES (1,'',NULL,0,'India',NULL,NULL,'','N',1,'N','',NULL,NULL,NULL,NULL,NULL,0,NULL,'india',NULL),(2,'',NULL,1,'Delhi',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'delhi',NULL),(3,'',NULL,1,'Arunachal Pradesh',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'arunachal-pradesh',NULL),(4,'',NULL,1,'Assam',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'assam',NULL),(5,'',NULL,1,'Bihar',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bihar',NULL),(6,'',NULL,1,'Chhattisgarh',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'chhattisgarh',NULL),(7,'',NULL,1,'Gujarat',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'gujarat',NULL),(8,'',NULL,1,'Haryana',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'haryana',NULL),(9,'',NULL,1,'Himachal Pradesh',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'himachal-pradesh',NULL),(10,'',NULL,1,'Jammu And Kashmir',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jammu-and-kashmir',NULL),(11,'',NULL,1,'Jharkhand',NULL,NULL,'','N',10,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jharkhand',NULL),(12,'',NULL,1,'Madhya Pradesh',NULL,NULL,'','N',11,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'madhya-pradesh',NULL),(13,'',NULL,1,'Maharashtra',NULL,NULL,'','N',12,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'maharashtra',NULL),(14,'',NULL,1,'Meghalaya',NULL,NULL,'','N',13,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'meghalaya',NULL),(15,'',NULL,1,'Mizoram',NULL,NULL,'','N',14,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'mizoram',NULL),(16,'',NULL,1,'Punjab',NULL,NULL,'','N',15,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'punjab',NULL),(17,'',NULL,1,'Rajasthan',NULL,NULL,'','N',16,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'rajasthan',NULL),(18,'',NULL,1,'Sikkim',NULL,NULL,'','N',17,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'sikkim',NULL),(19,'',NULL,1,'Uttar Pradesh',NULL,NULL,'','N',18,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'uttar-pradesh',NULL),(20,'',NULL,1,'Uttarakhand',NULL,NULL,'','N',19,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'uttarakhand',NULL),(21,'',NULL,3,'Itanagar',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'itanagar',NULL),(22,'',NULL,4,'Guwahati',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'guwahati',NULL),(23,'',NULL,5,'Patna',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'patna',NULL),(24,'',NULL,6,'Bhilai',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bhilai',NULL),(25,'',NULL,6,'Bilaspur',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bilaspur',NULL),(33,'',NULL,7,'Jamnagar',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jamnagar',NULL),(32,'',NULL,7,'Vadodara',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'vadodara',NULL),(31,'',NULL,7,'Ahmedabad',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ahmedabad',NULL),(29,'',NULL,6,'Raipur',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'raipur',NULL),(34,'',NULL,7,'Kandla',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kandla',NULL),(35,'',NULL,7,'Rajkot',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'rajkot',NULL),(36,'',NULL,8,'Jhajjar',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jhajjar',NULL),(37,'',NULL,8,'Ambala',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ambala',NULL),(38,'',NULL,8,'Bhiwani',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bhiwani',NULL),(39,'',NULL,8,'Chandigarh',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'chandigarh',NULL),(40,'',NULL,8,'Faridabad',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'faridabad',NULL),(41,'',NULL,8,'Gurgaon',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'gurgaon',NULL),(42,'',NULL,8,'Hansi',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'hansi',NULL),(43,'',NULL,8,'Hisar',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'hisar',NULL),(44,'',NULL,8,'Jind',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jind',NULL),(45,'',NULL,8,'Kaithal',NULL,NULL,'','N',10,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kaithal',NULL),(46,'',NULL,8,'Karnal',NULL,NULL,'','N',11,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'karnal',NULL),(47,'',NULL,8,'Kurukshetra',NULL,NULL,'','N',12,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kurukshetra',NULL),(48,'',NULL,8,'Panipat',NULL,NULL,'','N',13,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'panipat',NULL),(53,'',NULL,8,'Sonipat',NULL,NULL,'','N',18,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'sonipat',NULL),(54,'',NULL,8,'Rewari',NULL,NULL,'','N',19,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'rewari',NULL),(51,'',NULL,8,'Rohtak',NULL,NULL,'','N',16,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'rohtak',NULL),(52,'',NULL,8,'Sirsa',NULL,NULL,'','N',17,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'sirsa',NULL),(55,'',NULL,9,'Bilaspur',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bilaspur',NULL),(56,'',NULL,9,'Chamba',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'chamba',NULL),(57,'',NULL,9,'Dalhousie',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'dalhousie',NULL),(58,'',NULL,9,'Dharamshala',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'dharamshala',NULL),(59,'',NULL,9,'Kullu',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kullu','hamirpur'),(60,'',NULL,9,'Mandi',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'mandi',NULL),(61,'',NULL,9,'Shimla',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'shimla',NULL),(62,'',NULL,9,'Una',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'una',NULL),(63,'',NULL,10,'Jammu',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jammu','jammu'),(64,'',NULL,10,'Leh',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'leh',NULL),(65,'',NULL,10,'Srinagar',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'srinagar',NULL),(66,'',NULL,10,'Udhampur',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'udhampur',NULL),(67,'',NULL,11,'Dhanbad',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'dhanbad',NULL),(68,'',NULL,11,'Jamshedpur',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jamshedpur',NULL),(69,'',NULL,11,'Ranchi',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ranchi',NULL),(70,'',NULL,12,'Bhopal',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bhopal',NULL),(71,'',NULL,12,'Damoh',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'damoh',NULL),(72,'',NULL,12,'Dhar',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'dhar',NULL),(73,'',NULL,12,'Guna',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'guna',NULL),(74,'',NULL,12,'Gwalior',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'gwalior',NULL),(75,'',NULL,12,'Indore',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'indore',NULL),(76,'',NULL,12,'Jabalpur',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jabalpur',NULL),(77,'',NULL,12,'Narsinghgarh',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'narsinghgarh',NULL),(78,'',NULL,12,'Neemuch',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'neemuch',NULL),(79,'',NULL,12,'Panna',NULL,NULL,'','N',10,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'panna',NULL),(80,'',NULL,12,'Satna',NULL,NULL,'','N',11,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'satna',NULL),(81,'',NULL,12,'Ujjain',NULL,NULL,'','N',12,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ujjain',NULL),(82,'',NULL,13,'Mumbai',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'mumbai',NULL),(83,'',NULL,13,'Pune',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'pune',NULL),(84,'',NULL,14,'Shillong',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'shillong',NULL),(85,'',NULL,15,'Aizawl',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'aizawl',NULL),(86,'',NULL,16,'Amritsar',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'amritsar',NULL),(87,'',NULL,16,'Bathinda',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bathinda',NULL),(88,'',NULL,16,'Hoshiarpur',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'hoshiarpur',NULL),(89,'',NULL,16,'Jalandhar',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jalandhar',NULL),(90,'',NULL,16,'Kapurthala',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kapurthala',NULL),(91,'',NULL,16,'Ludhiana',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ludhiana',NULL),(92,'',NULL,16,'Nabha',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nabha',NULL),(93,'',NULL,16,'Patiala',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'patiala',NULL),(94,'',NULL,16,'Rupnagar',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'rupnagar',NULL),(95,'',NULL,17,'Ajmer',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ajmer',NULL),(96,'',NULL,17,'Alwar',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'alwar',NULL),(97,'',NULL,17,'Barmer',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'barmer',NULL),(98,'',NULL,17,'Beawar',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'beawar',NULL),(99,'',NULL,17,'Bhilwara',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bhilwara',NULL),(100,'',NULL,17,'Bikaner',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bikaner',NULL),(101,'',NULL,17,'Chittorgarh',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'chittorgarh',NULL),(102,'',NULL,17,'Hanumangarh',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'hanumangarh',NULL),(103,'',NULL,17,'Jaipur',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jaipur',NULL),(104,'',NULL,17,'Jaisalmer',NULL,NULL,'','N',10,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jaisalmer',NULL),(105,'',NULL,17,'Jhalawar',NULL,NULL,'','N',11,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jhalawar',NULL),(106,'',NULL,17,'Jodhpur',NULL,NULL,'','N',12,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jodhpur',NULL),(107,'',NULL,17,'Kishangarh',NULL,NULL,'','N',13,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kishangarh',NULL),(108,'',NULL,17,'Kota',NULL,NULL,'','N',14,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kota',NULL),(109,'',NULL,17,'Nagaur',NULL,NULL,'','N',15,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nagaur',NULL),(110,'',NULL,17,'Udaipur',NULL,NULL,'','N',16,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'udaipur',NULL),(111,'',NULL,18,'Gangtok',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'gangtok',NULL),(112,'',NULL,19,'Agra',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'agra',NULL),(113,'',NULL,19,'Greater Noida',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'greater-noida',NULL),(114,'',NULL,19,'Noida',NULL,NULL,'','N',3,'N','',NULL,NULL,NULL,NULL,NULL,0,NULL,'noida',NULL),(115,'',NULL,19,'Aligarh',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'aligarh',NULL),(116,'',NULL,19,'Amroha',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'amroha',NULL),(117,'',NULL,19,'Ayodhya',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ayodhya',NULL),(118,'',NULL,19,'Barabanki',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'barabanki',NULL),(119,'',NULL,19,'Bareilly',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bareilly',NULL),(120,'',NULL,19,'Bijnor',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bijnor',NULL),(121,'',NULL,19,'Bulandshahr',NULL,NULL,'','N',10,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bulandshahr',NULL),(122,'',NULL,19,'Ghaziabad',NULL,NULL,'','N',11,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ghaziabad',NULL),(123,'',NULL,19,'Jhansi',NULL,NULL,'','N',12,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jhansi',NULL),(124,'',NULL,19,'Kanpur',NULL,NULL,'','N',13,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kanpur',NULL),(125,'',NULL,19,'Lakhimpur',NULL,NULL,'','N',14,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'lakhimpur',NULL),(126,'',NULL,19,'Lalitpur',NULL,NULL,'','N',15,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'lalitpur',NULL),(127,'',NULL,19,'Lucknow',NULL,NULL,'','N',16,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'lucknow',NULL),(128,'',NULL,19,'Mathura',NULL,NULL,'','N',17,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'mathura',NULL),(129,'',NULL,19,'Meerut',NULL,NULL,'','N',18,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'meerut',NULL),(130,'',NULL,19,'Moradabad',NULL,NULL,'','N',19,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'moradabad',NULL),(131,'',NULL,19,'Muzaffarnagar',NULL,NULL,'','N',20,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'muzaffarnagar',NULL),(132,'',NULL,19,'Prayagraj',NULL,NULL,'','N',21,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'prayagraj',NULL),(133,'',NULL,19,'Raebareli',NULL,NULL,'','N',22,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'raebareli',NULL),(134,'',NULL,19,'Shahjahanpur',NULL,NULL,'','N',23,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'shahjahanpur',NULL),(135,'',NULL,19,'Sitapur',NULL,NULL,'','N',24,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'sitapur',NULL),(136,'',NULL,19,'Sultanpur',NULL,NULL,'','N',25,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'sultanpur',NULL),(137,'',NULL,19,'Varanasi',NULL,NULL,'','N',26,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'varanasi',NULL),(138,'',NULL,20,'Dehradun',NULL,NULL,'','N',1,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'dehradun',NULL),(139,'',NULL,20,'Haridwar',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'haridwar',NULL),(140,'',NULL,20,'Mussoorie',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'mussoorie',NULL),(141,'',NULL,20,'Nainital',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nainital',NULL),(142,'',NULL,20,'Rudrapur',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'rudrapur',NULL),(143,'',NULL,20,'Sitarganj',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'sitarganj',NULL),(144,'',NULL,3,'Tawang',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'tawang',NULL),(145,'',NULL,3,'Bomdila',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bomdila',NULL),(146,'',NULL,3,'Ziro',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ziro',NULL),(147,'',NULL,3,'Bhalukpong',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bhalukpong',NULL),(148,'',NULL,3,'Pasighat',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'pasighat',NULL),(149,'',NULL,3,'Dirang',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'dirang',NULL),(150,'',NULL,3,'Daporijo',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'daporijo',NULL),(151,'',NULL,4,'Jorhat',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jorhat',NULL),(152,'',NULL,4,'Dibrugarh',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'dibrugarh',NULL),(153,'',NULL,4,'Tezpur',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'tezpur',NULL),(154,'',NULL,4,'Silchar',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'silchar',NULL),(155,'',NULL,4,'Bongaigaon',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bongaigaon',NULL),(156,'',NULL,4,'Nagaon',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nagaon',NULL),(157,'',NULL,4,'Kokrajhar',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kokrajhar',NULL),(158,'',NULL,4,'Diphu',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'diphu',NULL),(159,'',NULL,4,'Tinsukia',NULL,NULL,'','N',10,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'tinsukia',NULL),(160,'',NULL,5,'Gaya',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'gaya',NULL),(161,'',NULL,5,'Bhagalpur',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bhagalpur',NULL),(162,'',NULL,5,'Muzaffarpur',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'muzaffarpur',NULL),(163,'',NULL,5,'Darbhanga',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'darbhanga',NULL),(164,'',NULL,5,'Purnia',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'purnia',NULL),(165,'',NULL,5,'Nalanda',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nalanda',NULL),(166,'',NULL,5,'Bihar Sharif',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bihar-sharif',NULL),(167,'',NULL,5,'Sasaram',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'sasaram',NULL),(168,'',NULL,11,'Bokaro',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'bokaro',NULL),(169,'',NULL,11,'Deoghar',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'deoghar',NULL),(170,'',NULL,11,'Hazaribagh',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'hazaribagh',NULL),(171,'',NULL,11,'Giridih',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'giridih',NULL),(172,'',NULL,11,'Ramgarh',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ramgarh',NULL),(173,'',NULL,13,'Nashik',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nashik',NULL),(174,'',NULL,13,'Nagpur',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nagpur',NULL),(175,'',NULL,13,'Solapur',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'solapur',NULL),(176,'',NULL,13,'Jalgaon',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'jalgaon',NULL),(177,'',NULL,13,'Kolhapur',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kolhapur',NULL),(178,'',NULL,13,'Amravati',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'amravati',NULL),(179,'',NULL,13,'Nanded',NULL,NULL,'','N',9,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nanded',NULL),(180,'',NULL,14,'Mawlynnong',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'mawlynnong',NULL),(181,'',NULL,14,'Nongpoh',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'nongpoh',NULL),(182,'',NULL,14,'Tura',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'tura',NULL),(183,'',NULL,14,'Mawphlang',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'mawphlang',NULL),(184,'',NULL,14,'Williamnagar',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'williamnagar',NULL),(185,'',NULL,15,'Champhai',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'champhai',NULL),(186,'',NULL,15,'Lunglei',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'lunglei',NULL),(187,'',NULL,15,'Siaha',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'siaha',NULL),(188,'',NULL,15,'Serchhip',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'serchhip',NULL),(189,'',NULL,15,'Kolasib',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'kolasib',NULL),(190,'',NULL,15,'Thenzawl',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'thenzawl',NULL),(191,'',NULL,15,'Darlawn',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'darlawn',NULL),(192,'',NULL,18,'Namchi',NULL,NULL,'','N',2,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'namchi',NULL),(193,'',NULL,18,'Pelling',NULL,NULL,'','N',3,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'pelling',NULL),(194,'',NULL,18,'Ravangla',NULL,NULL,'','N',4,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'ravangla',NULL),(195,'',NULL,18,'Lachung',NULL,NULL,'','N',5,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'lachung',NULL),(196,'',NULL,18,'Yuksom',NULL,NULL,'','N',6,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'yuksom',NULL),(197,'',NULL,18,'Geyzing',NULL,NULL,'','N',7,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'geyzing',NULL),(198,'',NULL,18,'Lachen',NULL,NULL,'','N',8,'Y','',NULL,NULL,NULL,NULL,NULL,0,NULL,'lachen',NULL);

--
-- Table structure for table `logfile`
--

CREATE TABLE `logfile` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `newsletter` text NOT NULL,
  `subject` text NOT NULL,
  `newsletterOther` text NOT NULL,
  `subjectOther` text NOT NULL,
  `flash_banner` varchar(50) NOT NULL DEFAULT '',
  `shippingPrice` float NOT NULL DEFAULT '0',
  `vat` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logfile`
--


--
-- Table structure for table `mailer_list`
--

CREATE TABLE `mailer_list` (
  `mailer_id` int(10) NOT NULL AUTO_INCREMENT,
  `mailer_title` varchar(200) NOT NULL,
  `mailer_reply` varchar(200) NOT NULL,
  `mailer_code` text NOT NULL,
  `message` varchar(500) NOT NULL,
  `country` varchar(100) NOT NULL,
  `memberType` varchar(10) NOT NULL,
  `keyword` varchar(100) NOT NULL,
  `databasestatus` varchar(10) NOT NULL,
  `status` varchar(1) NOT NULL,
  PRIMARY KEY (`mailer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mailer_list`
--


--
-- Table structure for table `manufacturing_tbl`
--

CREATE TABLE `manufacturing_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) DEFAULT NULL,
  `team_group_id` varchar(20) DEFAULT NULL,
  `image` varchar(400) DEFAULT NULL,
  `short_description` text,
  `prod_capacity` text,
  `establishment` varchar(300) DEFAULT NULL,
  `prodw_area` varchar(500) DEFAULT NULL,
  `prod_manufacture` varchar(200) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT '1',
  `total_area` varchar(500) DEFAULT NULL,
  `instagram_link` varchar(500) DEFAULT NULL,
  `linkedin_link` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `manufacturing_tbl`
--


--
-- Table structure for table `mass_mail`
--

CREATE TABLE `mass_mail` (
  `mailID` int(20) NOT NULL AUTO_INCREMENT,
  `mailerID` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `companyName` varchar(150) NOT NULL,
  `memberName` varchar(150) NOT NULL,
  `memberID` varchar(50) NOT NULL,
  `status` varchar(1) NOT NULL,
  PRIMARY KEY (`mailID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mass_mail`
--


--
-- Table structure for table `newsletter_member`
--

CREATE TABLE `newsletter_member` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `snewsletter` char(1) NOT NULL DEFAULT 'N',
  `cnewsletter` char(1) NOT NULL DEFAULT 'N',
  `mType` char(1) NOT NULL DEFAULT 'B',
  `join_date` date NOT NULL DEFAULT '0000-00-00',
  `status` char(2) NOT NULL DEFAULT 'Y',
  `mail_status` char(2) NOT NULL DEFAULT 'N',
  `ip` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `newsletter_member`
--


--
-- Table structure for table `photo_tbl`
--

CREATE TABLE `photo_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `description` text,
  `gallery_cat` int(7) DEFAULT NULL,
  `photo_order` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `photo_tbl`
--

INSERT INTO `photo_tbl` VALUES (27,1,'Phased Array Ultrasonic Testing (PAUT)','Phased Array Ultrasonic Testing (PAUT)','gallery_19.jpg','',0,NULL,'2024-08-22 12:36:19','2024-08-22 12:36:19'),(28,1,'Helium-Leak-Testing','Helium-Leak-Testing','gallery_22.jpg','',0,NULL,'2024-08-22 12:44:22','2024-08-22 12:44:22'),(29,1,'Helium-Leak-Testing3','Helium-Leak-Testing3','gallery_32.jpg','',0,NULL,'2024-08-22 12:44:32','2024-08-22 12:44:32'),(31,1,'Helium-Leak-Testing','Helium-Leak-Testing','gallery_07.jpg','',0,NULL,'2024-08-22 12:45:07','2024-08-22 12:45:07'),(32,1,'MFL-Tank-Floor-Scanning-Services','MFL-Tank-Floor-Scanning-Services','gallery_17.jpg','',0,NULL,'2024-08-22 12:45:17','2024-08-22 12:45:17'),(33,1,'Phased-Array-Ultrasonic-Testing-(PAUT)','Phased-Array-Ultrasonic-Testing-(PAUT)','gallery_30.jpg','',0,NULL,'2024-08-22 12:45:30','2024-08-22 12:45:30'),(34,1,'Phased-Array-Ultrasonic-Testing-(PAUT)','Phased-Array-Ultrasonic-Testing-(PAUT)','gallery_43.jpg','',0,NULL,'2024-08-22 12:45:43','2024-08-22 12:45:43'),(35,1,'Phased-Array-Ultrasonic-Testing-(PAUT)','Phased-Array-Ultrasonic-Testing-(PAUT)','gallery_58.jpg','',0,NULL,'2024-08-22 12:45:58','2024-08-22 12:45:58'),(36,1,'Remote-Field-Electromagnetic-Testing-Services','Remote-Field-Electromagnetic-Testing-Services','gallery_10.jpg','',0,NULL,'2024-08-22 12:46:10','2024-08-22 12:46:10'),(37,1,'Ultrasonic-Testing-Services','Ultrasonic-Testing-Services','gallery_21.jpg','',0,NULL,'2024-08-22 12:46:21','2024-08-22 12:46:21'),(38,1,'Advanced NDT Services','Advanced NDT Services','gallery_08.png','',0,NULL,'2024-11-13 09:20:08','2024-11-13 09:20:08'),(39,1,'Helium Leak Testing','Helium Leak Testing','gallery_50.png','',0,NULL,'2024-11-13 09:20:50','2024-11-13 09:20:50');

--
-- Table structure for table `procategory_tbl`
--

CREATE TABLE `procategory_tbl` (
  `catID` int(11) NOT NULL AUTO_INCREMENT,
  `catgType` int(1) NOT NULL,
  `catgurl` varchar(100) NOT NULL,
  `parentID` int(11) NOT NULL DEFAULT '0',
  `catName` varchar(255) NOT NULL DEFAULT '',
  `catDesc` text NOT NULL,
  `catDesc1` text NOT NULL,
  `catImage` varchar(50) NOT NULL DEFAULT '',
  `topBusinessCategory` char(1) NOT NULL DEFAULT 'N',
  `catOrder` int(11) NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL DEFAULT 'Y',
  `pageTitle` varchar(250) NOT NULL DEFAULT '',
  `pageKeywords` text NOT NULL,
  `pageDescription` text NOT NULL,
  `pageTitle1` varchar(250) NOT NULL,
  `pageDescription1` text NOT NULL,
  `pageKeywords1` text NOT NULL,
  `footerContent` text NOT NULL,
  `catalogImage` varchar(500) NOT NULL,
  `catalogLink` varchar(600) NOT NULL,
  PRIMARY KEY (`catID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `procategory_tbl`
--


--
-- Table structure for table `product_tbl`
--

CREATE TABLE `product_tbl` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_title` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_name` varchar(250) DEFAULT NULL,
  `product_code` varchar(700) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `homecategory` int(11) NOT NULL DEFAULT '0',
  `homeorder` int(11) DEFAULT NULL,
  `product_image` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_image1` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image2` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_image3` varchar(500) CHARACTER SET utf16 COLLATE utf16_unicode_ci DEFAULT NULL,
  `product_alt` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_metatitle` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_metadesc` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_metakeyword` varchar(800) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_cat` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `prodcut_subcat` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_subsubcat` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_specfi` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `product_video` varchar(150) DEFAULT NULL,
  `product_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_status` int(11) NOT NULL DEFAULT '1',
  `product_finalcat` varchar(600) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_min_order` varchar(400) DEFAULT NULL,
  `product_supply` varchar(600) DEFAULT NULL,
  `product_origin` varchar(600) DEFAULT NULL,
  `product_pterms` varchar(600) DEFAULT NULL,
  `product_price` varchar(600) DEFAULT NULL,
  `product_swearType` varchar(100) DEFAULT NULL,
  `product_supplyType` varchar(100) DEFAULT NULL,
  `product_Gender` varchar(100) DEFAULT NULL,
  `product_ageGroup` varchar(100) DEFAULT NULL,
  `product_size` varchar(100) DEFAULT NULL,
  `product_fabric` varchar(250) DEFAULT NULL,
  `product_type` varchar(200) DEFAULT NULL,
  `catalog` varchar(255) DEFAULT NULL,
  `product_mcq` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_tbl`
--


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

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

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


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

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

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

INSERT INTO `safe_business_tbl` VALUES (1,'Aarav Patel','','{companyName} provided outstanding helium leak testing. Their meticulous approach and swift results saved us significant time and resources. We highly recommend them for their accuracy and efficiency!',1,'2024-08-21','Y',''),(2,'Richa Sharma','','Excellent welding inspection services by {companyName}. Their comprehensive reports and thorough analysis ensured our project’s success. Professional, reliable, and highly detailed—exactly what we needed!',2,'2024-08-21','Y',''),(3,'Rajesh Kumar','','{companyName} delivered precise hardness testing services with exceptional professionalism. Their prompt and accurate results were crucial for our quality control processes. We trust their expertise to meet all our testing needs!',3,'2024-08-23','Y',''),(4,'Ananya Desai','','The In Situ metallography service from {companyName} was exemplary. Their detailed analysis and expert insights into our materials were invaluable. Reliable, accurate, and efficient service every time!',4,'2024-08-23','Y',''),(5,'Ravi Mehta','','{companyName} provided accurate positive material identification with impressive efficiency. Their expertise and thorough approach ensured reliable results for our project. We’re extremely satisfied with their exceptional service!',5,'2024-08-23','Y','');

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `static_pages` VALUES (1,'banner01.jpg','image53.jpg','Home','<p>Welcome to {companyName}, where our commitment to excellence is at the heart of everything we do. We are proud to be recognized for delivering the <strong>Best Ultrasonic Testing Services in Noida</strong>. Our team of highly skilled professionals utilizes the latest testing technology to provide precise and detailed assessments. This non-destructive testing method allows us to evaluate the integrity of materials and structures without causing any damage. Whether you are dealing with welds, castings, or structural components, our ultrasonic testing services offer the accuracy and reliability you need to ensure safety and compliance with industry standards. Our state-of-the-art ultrasonic equipment is complemented by our technicians&rsquo; extensive training and experience. This combination ensures that we can detect even the smallest defects and irregularities, providing you with a comprehensive understanding of your assets&#39; condition. We understand that timely and accurate testing is crucial for maintaining operational efficiency and preventing potential failures. That&rsquo;s why we are dedicated to delivering results that meet the highest standards of quality and precision.</p>\r\n\r\n<h2>Radiography Testing Service Provider in India</h2>\r\n\r\n<p>Radiography testing, utilizing X-rays or gamma rays, is an essential method for inspecting the internal structures of materials to identify hidden flaws. Our services are designed to offer in-depth insights into the structural integrity of your components, ensuring that any potential issues are identified and addressed promptly. In addition to our ultrasonic testing capabilities, we stand out as a premier <strong>Radiography Testing Service Provider in India</strong>. This method is especially valuable for detecting internal cracks, voids, and other inconsistencies that may not be visible through other testing methods. Our radiography testing services are conducted by certified professionals who adhere to rigorous safety and quality standards. By employing advanced techniques and equipment, we provide detailed images and analyses that support your quality assurance processes. Here, we are committed to being your trusted partner in safeguarding the quality and safety of your products and infrastructure. With our expert testing services, you can be confident that your assets are thoroughly inspected and meet the highest standards of excellence.</p>\r\n','<p>Welcome to {companyName}, where our commitment to excellence is at the heart of everything we do. We are proud to be recognized for delivering the Best Ultrasonic Testing Services in Noida. Our team of highly skilled professionals utilizes the latest testing technology to provide precise and detailed assessments. This non-destructive testing method allows us to evaluate the integrity of materials and structures without causing any damage.</p>\r\n','','Y','Best Ultrasonic Testing Services in Noida, Radiography Testing Service Provider in India','Best Ultrasonic Testing Services, Best Ultrasonic Testing Services in Noida, Radiography Testing Service, Radiography Testing Service Provider in India','Looking for reliable Ultrasonic Testing Services in Noida? Inspection & Testing Engineers offers top-notch Radiography services in India in various industries, ensuring product quality and safety. Contact us today!','',''),(2,'banner33.jpg','image15.jpg','About us','<p>{companyName}, <strong>established in 1997</strong>, has been a pioneering force in the realm of inspection and testing services. Founded by <strong>Mr. Ashok Kumar Pawar</strong>, our company has steadily built a legacy of excellence through unwavering commitment to quality and precision. With a strong focus on advancing industry standards, we provide a comprehensive range of services, including non-destructive testing (NDT), mechanical testing, and material testing. Our state-of-the-art facilities in Noida are equipped with the latest technology to ensure that we meet the rigorous demands of various sectors, from construction and aerospace to automotive and manufacturing. Our company has earned a distinguished reputation and is recognized as the provider of the <strong>Top 5 Mechanical Testing Services in Noida</strong><strong>, India</strong>. This accolade reflects our dedication to providing accurate, reliable, and timely results that adhere to the highest standards. Our success is a testament to our ability to adapt to evolving industry needs while maintaining the quality and integrity of our services.</p>\r\n\r\n<p>Led by Mr. Ashok Kumar Pawar, our team comprises highly skilled professionals certified by prominent industry organizations. Their expertise and experience are the cornerstones of our service offerings. We pride ourselves on our ability to deliver tailored solutions that address the specific requirements of each project, ensuring enhanced safety, performance, and regulatory compliance. Our laboratory is NABL accredited, underscoring our commitment to quality assurance and excellence in testing. We continually invest in cutting-edge technology and stay abreast of industry advancements to provide innovative solutions. At {companyName}, we prioritize customer satisfaction and build long-term relationships based on trust and transparency. Our comprehensive approach ensures that we thoroughly understand our clients&rsquo; needs and deliver solutions that exceed their expectations. Join us for all your inspection and testing requirements, and experience the unparalleled quality and expertise that sets us apart.</p>\r\n','<p>{companyName}, established in 1997, has been a pioneering force in the realm of inspection and testing services. Founded by Mr. Ashok Kumar Pawar, our company has steadily built a legacy of excellence through unwavering commitment to quality and precision.</p>\r\n','','Y','Top 5 Mechanical Testing Services in Noida | Inspection & Testing Services','Top 5 Mechanical testing services, Top 5 Mechanical testing services in Noida, Inspection & Testing Engineers in India','Discover the Top 5 Mechanical testing services in Noida. Inspection & Testing Engineers offers comprehensive solutions for product quality and reliability with our expert services.','',''),(4,NULL,'image04.jpg','Our Infrastructure','','<p>Our Infrastructure</p>\r\n',NULL,'Y','Our Infrastructure','Our Infrastructure','Our Infrastructure',NULL,NULL),(3,'banner54.jpg','image34.jpg','our founder','','<p>our founder</p>\r\n',NULL,'Y','our founder','our founder','our founder',NULL,NULL),(5,'banner11.jpg','image43.jpg','About Home Page','','<p>About DSK</p>\r\n',NULL,'Y','About DSK','About DSK','About DSK',NULL,NULL),(6,'banner29.jpg','','Privacy Policy','','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nemo similique corrupti, temporibus suscipit commodi sapiente blanditiis, maiores tempora quo ipsa inventore odio animi iusto ut, nesciunt architecto doloribus rem? Ratione.</p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. Nemo similique corrupti, temporibus suscipit commodi sapiente blanditiis, maiores tempora quo ipsa inventore odio animi iusto ut, nesciunt architecto doloribus rem? Ratione.</p>\r\n',NULL,'Y','Him Trail Adventure','Him Trail Adventure','Him Trail Adventure',NULL,NULL);

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `video_tbl` VALUES (1,'Radiography Testing of Components','gOJ8-t_mmUs',2,'Select Category','2024-11-04 07:28:36','2024-11-04 07:28:36');

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

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

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



