-- MySQL dump 10.13  Distrib 8.0.27, for Linux (x86_64)
--
-- Host: localhost    Database: essoildb
-- ------------------------------------------------------
-- Server version	8.0.27

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `compoundactivity`
--

DROP TABLE IF EXISTS `compoundactivity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `compoundactivity` (
  `caid` int NOT NULL AUTO_INCREMENT,
  `caname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`caid`)
) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `compoundactivity`
--

LOCK TABLES `compoundactivity` WRITE;
/*!40000 ALTER TABLE `compoundactivity` DISABLE KEYS */;
INSERT INTO `compoundactivity` VALUES (1,'ACE-Inhibitor Acaricide Aldose-Reductase-Inhibitor - Antiacetylcholinesterase â Antifeedant Antioxidant Insectifuge Irritant Perfumery Pesticide'),(2,'AChE-Inhibitor'),(3,'Abortifacient'),(4,'Acaricide'),(5,'Allelochemic'),(6,'Allelopathic'),(7,'Allergenic'),(8,'Analgesic'),(9,'Anesthetic'),(10,'AntiTnf'),(11,'Antiacetylcholinesterase'),(12,'Antiacne'),(13,'Antiacne Antiallergic'),(14,'Antiaggregant'),(15,'Antiallergic'),(16,'Antialzheimeran'),(17,'Antianaphylactic'),(18,'Antiarachidonate'),(19,'Antiasthmatic'),(20,'Antiasthmatic Antibacterial'),(21,'Antibacteria'),(22,'Antibacterial'),(23,'Anticancer'),(24,'Anticariogenic'),(25,'Anticonvulsant'),(26,'Anticonvulsant Antiedemic'),(27,'Antidiarrheic Antidysenteric'),(28,'Antiedemic'),(29,'Antiedemic Antiglutamaergic'),(30,'Antiemetic'),(31,'Antiestrogenic'),(32,'Antifeedant'),(33,'Antifibrositic Antineuralgic'),(34,'Antiflu'),(35,'Antigenotoxic'),(36,'Antiherpetic'),(37,'Antihistaminic'),(38,'Antihistaminic Antiseptic'),(39,'Antiinflammatory'),(40,'Antiinflammatory Antilithic'),(41,'Antikeratotic'),(42,'Antileishmanial Activity'),(43,'Antileukemic Antilymphomic'),(44,'Antilithic'),(45,'Antilymphomic'),(46,'Antimange'),(47,'Antimicrobial'),(48,'Antimitotic'),(49,'Antimutagenic'),(50,'Antinitrosaminic Antioxidant'),(51,'Antinitrosating'),(52,'Antiobesity Antiseptic'),(53,'Antioxidant'),(54,'Antioxidant Antiseptic'),(55,'Antipneumonic'),(56,'Antiprostaglandin Antipyretic'),(57,'Antipruritic'),(58,'Antiradicular'),(59,'Antirhinoviral'),(60,'Antisalmonella'),(61,'Antiseptic'),(62,'Antiseptic Antispasmodic'),(63,'Antishock'),(64,'Antispasmodic'),(65,'Antistaphylococcic'),(66,'Antithromboxane Antitumor'),(67,'Antitumor'),(68,'Antitumor (Breast) - Antitumor (Pancreas)'),(69,'Antitumor (Prostate)'),(70,'Antitussive'),(71,'Antiulce Bacteriostatic'),(72,'Antiulcer'),(73,'Antiviral'),(74,'Antiviral Apoptotic'),(75,'Apifuge'),(76,'Barbituate-Synergist - Bronchorelaxant'),(77,'Bronchoprotectant'),(78,'CNS-Depressant'),(79,'CNS-Stimulant'),(80,'COX-1-Inhibitor'),(81,'COX-2-Inhibitor'),(82,'Calcium-Antagonist'),(83,'Cancer Preventive'),(84,'Cancer preventive'),(85,'Cancer-Preventive'),(86,'Cancer-Preventive Candidistat'),(87,'Candidicide'),(88,'Candidistat'),(89,'Carcinogenic'),(90,'Carminative'),(91,'Carminative Choleretic'),(92,'Chemopreventive'),(93,'Coleoptophile'),(94,'Convulsant'),(95,'Cosmetic'),(96,'Counterirritant'),(97,'Culicide Expectorant'),(98,'Cytochrome-P450-Inhibitor'),(99,'Cytotoxic'),(100,'Decongestant'),(101,'Deliriant'),(102,'Deodorant'),(103,'Dermatitigenic'),(104,'Dermatitigenic Enterorelaxant'),(105,'Detoxicant'),(106,'Diuretic'),(107,'Ecbolic Emetic'),(108,'Enterocontractant Expectorant'),(109,'Epileptigenic'),(110,'Expectorant'),(111,'FLavor Fungicide'),(112,'FLavor Herbicide'),(113,'Flavor'),(114,'Fungicide'),(115,'Fungicide MYCOPATH'),(116,'Fungiphilic'),(117,'Fungistat'),(118,'GABA-nergic'),(119,'GST-Inducer'),(120,'Glaucomagenic'),(121,'Hepatoprotective'),(122,'Herbicide'),(123,'Herbicide Histaminic'),(124,'Herbicide Insect-Repellent'),(125,'Herbicide Insecticide'),(126,'Hypnotic'),(127,'Hypocholesterolemic'),(128,'Hypothermic Insecticide'),(129,'Immunomodulator'),(130,'Insect repellent.'),(131,'Insecticide'),(132,'Insectifuge'),(133,'Insectifuge Irritant'),(134,'Insectiphile'),(135,'Irritant'),(136,'Juvabional'),(137,'L. braziliensis'),(138,'Larvicide'),(139,'Larvicide Motor-Depressant'),(140,'Lipolytic'),(141,'Motor-Depressant'),(142,'Myorelaxant'),(143,'NO-Genic'),(144,'Nematicide'),(145,'Nematicide Ornithine-Decarboxylase-Inhibitor'),(146,'Neurotoxic'),(147,'Occuloirritant'),(148,'Ozone-Scavenger'),(149,'P450-2B1-Inhibitor'),(150,'P450-Inducer'),(151,'Perfumery'),(152,'Perfumery Pesticide'),(153,'Pesticide'),(154,'Pheromone'),(155,'Photosensitizer'),(156,'Prooxidant'),(157,'Prostaglandin Synthesis-Inhibitor'),(158,'Prostatitigenic'),(159,'Renoirritant'),(160,'Respirainhibitor'),(161,'Respirastimulant Rubefacient'),(162,'Sedative'),(163,'Sedative Teratogenic'),(164,'Spasmogenic'),(165,'Spasmogenic Tranquilizer'),(166,'Spermicide'),(167,'Stimulant'),(168,'Stomachic'),(169,'Termiticide'),(170,'Termitifuge'),(171,'Transdermal'),(172,'Trichomonicide'),(173,'Trichomonistat Trypsin-Enhancer'),(174,'Tumor-Promoter'),(175,'Tyrosinase-Inhibito'),(176,'Ulcerogenic'),(177,'Varroacide'),(178,'Vasodilator Vermifuge'),(179,'Verrucolytic'),(180,'Vibriocide'),(181,'Vulnerary'),(182,'aCE-Inhibitor Acaricide Aldose-Reductase-Inhibitor - Antiacetylcholinesterase â Antifeedant Antioxidant Insectifuge Irritant Perfumery Pesticide'),(183,'and L. chagasi promastigotes and L. amazonensis amastigotes'),(184,'anti-inflammatory and anti-microbial'),(185,'anti-tumor'),(186,'antialzheimeran'),(187,'anticholinesterase'),(188,'antifungal'),(189,'antimalarial'),(190,'antimicrobial'),(191,'antioxidant'),(192,'antiplasmodial'),(193,'antiseptic'),(194,'bactericidal'),(195,'cancer preventive'),(196,'chinese drug-moxa'),(197,'counterirritant'),(198,'flammable'),(199,'for preparation of vitamins E and K1'),(200,'fragrance'),(201,'fungicidal activity'),(202,'herbicide'),(203,'insect attractant'),(204,'insect repelllent'),(205,'insecticide'),(206,'lipid anchor in biomembranes'),(207,'mild carcinogenic'),(208,'mosquito attractant'),(209,'pesticide'),(210,'pheromone'),(211,'pungency'),(212,'secreted by insect for defence'),(213,'secretolytic'),(214,'skin healing properties-anti-irritant'),(215,'skin penetration enhancer'),(216,'under testing as a skin penetration enhancer for the transdermal delivery of therapeutic drugs'),(217,'used in manufacture of MDMA(ecstasy)'),(218,'used in traditional chinese medicine'),(219,'vitamin A stabiliser'),(220,'was evaluated against Leishmania species. Nerolidol inhibited the growth of Leishmania amazonensis');
/*!40000 ALTER TABLE `compoundactivity` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-28  7:55:13
