croprecommendationsql.sql

DROP TABLE IF EXISTS `croprecommendationapp_crop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `croprecommendationapp_crop` (
  `crop_id` int NOT NULL AUTO_INCREMENT,
  `crop_name` varchar(100) NOT NULL,
  `crop_details` longtext NOT NULL,
  `crop_category` varchar(20) NOT NULL,
  `crop_image` varchar(100) NOT NULL,
  PRIMARY KEY (`crop_id`),
  UNIQUE KEY `crop_name` (`crop_name`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `croprecommendationapp_crop`
--

LOCK TABLES `croprecommendationapp_crop` WRITE;
/*!40000 ALTER TABLE `croprecommendationapp_crop` DISABLE KEYS */;
INSERT INTO `croprecommendationapp_crop` VALUES (1,'rice','Rice is the seed of the grass species Oryza sativa or less commonly Oryza glaberrima. The name wild rice is usually used for species of the genera Zizania and Porteresia, both wild and domesticated, although the term may also be used for primitive or uncultivated varieties of Oryza.','Cereal grain','upload_images/crop/rice.jpg'),(2,'maize','Maize, also known as corn, is a cereal grain first domesticated by indigenous peoples in southern Mexico about 10,000 years ago. The leafy stalk of the plant produces pollen inflorescences and separate ovuliferous inflorescences called ears that yield kernels or seeds, which are fruits.','Plant','upload_images/crop/maize.jpg'),(3,'chickpea','The chickpea or chick pea is an annual legume of the family Fabaceae, subfamily Faboideae. Its different types are variously known as gram or Bengal gram, garbanzo or garbanzo bean, or Egyptian pea. Chickpea seeds are high in protein.','Legume','upload_images/crop/chickpea.jpg'),(4,'kidneybeans','The kidney bean is a variety of the common bean. It is named for its visual resemblance in shape and – for the red variety – colour to a human kidney. Red kidney beans should not be confused with other red beans, such as adzuki beans.','Bean','upload_images/crop/Kidneybean.jpg'),(5,'pigeonpeas','The pigeon pea, also known as arhar, tur, red gram, or gungo peas in Jamaica is a perennial legume from the family Fabaceae. Since its domestication in the Indian subcontinent at least 3,500 years ago, its seeds have become a common food in Asia, Africa, and Latin America. It is consumed on a large scale in South Asia and is a major source of protein for the population of the Indian subcontinent.','Legume','upload_images/crop/pigeonpeas.jpg'),(6,'mothbeans','Vigna aconitifolia is a drought-resistant legume, commonly grown in arid and semi-arid regions of India. It is commonly called mat bean, moth bean, matki or dew bean. The pods, sprouts and protein-rich seeds of this crop are commonly consumed in India. Moth bean can be grown on many soil types, and can also act as a pasture legume.','Legume','upload_images/crop/mothbeans.jpg'),(7,'mungbean','The mung bean, alternatively known as the green gram, maash, moong, monggo, or munggo, is a plant species in the legume family. The mung bean is mainly cultivated in East Asia, Southeast Asia and the Indian subcontinent. It is used as an ingredient in both savoury and sweet dishes.','Plant','upload_images/crop/mungbean.jpg'),(8,'blackgram','Vigna mungo, the black gram, urad bean, ulundu paruppu, minapa pappu, mungo bean or black matpe bean is a bean grown in South Asia. Like its relative, the mung bean, it has been reclassified from the Phaseolus to the Vigna genus. The product sold as black lentil is usually the whole urad bean, whereas the split bean is called white lentil.','Bean','upload_images/crop/blackgram.jpeg'),(9,'lentil','The lentil is an edible legume. It is an annual plant known for its lens-shaped seeds. It is about 40 cm tall, and the seeds grow in pods, usually with two seeds in each. As a food crop, the majority of world production comes from Canada and India, producing 58% combined of the world total.','Legume','upload_images/crop/lentil.jpg'),(10,'pomegranate','The pomegranate is a fruit-bearing deciduous shrub in the family Lythraceae, subfamily Punicoideae, that grows between 5 and 10 m tall. The pomegranate was originally described throughout the Mediterranean region. It was introduced into Spanish America in the late 16th century and into California by Spanish settlers in 1769.','Fruit','upload_images/crop/pomegranate.jpg'),(11,'banana','A banana is an elongated, edible fruit – botanically a berry – produced by several kinds of large herbaceous flowering plants in the genus Musa. In some countries, bananas used for cooking may be called \"plantains\", distinguishing them from dessert bananas. The fruit is variable in size, color, and firmness, but is usually elongated and curved, with soft flesh rich in starchcovered with a rind.','Fruit','upload_images/crop/banana.jpg'),(12,'mango','A mango is an edible stone fruit produced by the tropical tree Mangifera indica which is believed to have originated from the region between northwestern Myanmar, Bangladesh, and northeastern India. M. indica has been cultivated in South and Southeast Asia since ancient times resulting in two distinct types of modern mango cultivars: the \"Indian type\" and the \"Southeast Asian type\".','Fruit','upload_images/crop/mango.jpg'),(13,'grapes','Commercially cultivated grapes can usually be classified as either table or wine grapes, based on their intended method of consumption: eaten raw (table grapes) or used to make wine (wine grapes). While almost all of them belong to the same species, Vitis vinifera, table and wine grapes have significant differences, brought about through selective breeding.','Fruit','upload_images/crop/grapes.jpg'),(14,'watermelon','Watermelon (Citrullus lanatus) is a flowering plant species of the Cucurbitaceae family. A scrambling and trailing vine-like plant, it was originally domesticated in Africa. It is a highly cultivated fruit worldwide, with more than 1,000 varieties. Wild watermelon seeds have been found in the prehistoric Libyan site of Uan Muhuggiag.','Fruit','upload_images/crop/watermelon.jpg'),(15,'muskmelon','Cucumis melo, also known as melon, is a species of Cucumis that has been developed into many cultivated varieties. The fruit is a pepo. The flesh is either sweet or bland, with or without a musky aroma, and the rind can be smooth (such as honeydew), ribbed (such as cantaloupe), wrinkled (such as casaba melon), or netted (such as muskmelon).','Fruit','upload_images/crop/muskmelon.jpg'),(16,'apple','An apple is an edible fruit produced by an apple tree (Malus domestica). Apple trees are cultivated worldwide and are the most widely grown species in the genus Malus. The tree originated in Central Asia, where its wild ancestor, Malus sieversii, is still found today. Apples have been grown for thousands of years in Asia and Europe and were brought to North America by European colonists.','Fruit','upload_images/crop/apple.jpg'),(17,'orange','The orange is the fruit of various citrus species in the family Rutaceae (see list of plants known as orange); it primarily refers to Citrus × sinensis, which is also called sweet orange, to distinguish it from the related Citrus × aurantium, referred to as bitter orange. The sweet orange reproduces asexually (apomixis through nucellar embryony); varieties of sweet orange arise through mutations.','Fruit','upload_images/crop/orange.jpg'),(18,'papaya','The papaya, papaw, or pawpaw is the plant Carica papaya, one of the 22 accepted species in the genus Carica of the family Caricaceae. Its origin is in the tropics of the Americas, perhaps from Central America and southern Mexico.','Plant','upload_images/crop/papaya.jpg'),(19,'coconut','The name coconut is derived from the 16th-century Portuguese word coco, meaning \'head\' or \'skull\' after the three indentations on the coconut shell that resemble facial features. Coco and coconut apparently came from 1521 encounters by Portuguese and Spanish explorers with Pacific islanders, with the coconut shell reminding them of a ghost or witch in Portuguese folklore called coco (also côca).','Fruit','upload_images/crop/coconut.jpg'),(20,'cotton','Cotton is a soft, fluffy staple fiber that grows in a boll, or protective case, around the seeds of the cotton plants of the genus Gossypium in the mallow family Malvaceae. The fiber is almost pure cellulose. Under natural conditions, the cotton bolls will increase the dispersal of the seeds.','Plant','upload_images/crop/cotton.jpg'),(21,'jute','Jute is a long, soft, shiny bast fiber that can be spun into coarse, strong threads. It is produced from flowering plants in the genus Corchorus, which is in the mallow family Malvaceae. The primary source of the fiber is Corchorus olitorius, but such fiber is considered inferior to that derived from Corchorus capsularis.','Plant','upload_images/crop/jute.jpg'),(22,'coffee','Coffea is a genus of flowering plants in the family Rubiaceae. Coffea species are shrubs or small trees native to tropical and southern Africa and tropical Asia. The seeds of some species, called coffee beans, are used to flavor various beverages and products. The fruits, like the seeds, contain a large amount of caffeine, and have a distinct sweet taste and are often juiced.','Plant','upload_images/crop/coffee.jpg');
/*!40000 ALTER TABLE `croprecommendationapp_crop` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `croprecommendationapp_crop_recommed`
--

DROP TABLE IF EXISTS `croprecommendationapp_crop_recommed`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `croprecommendationapp_crop_recommed` (
  `cr_id` int NOT NULL AUTO_INCREMENT,
  `cr_farmername` varchar(100) NOT NULL,
  `cr_nitrogen` int unsigned NOT NULL,
  `cr_phosphorous` int unsigned NOT NULL,
  `cr_potassium` int unsigned NOT NULL,
  `cr_ph` double NOT NULL,
  `cr_temperature` double NOT NULL,
  `cr_humidity` double NOT NULL,
  `cr_rainfall` double NOT NULL,
  `cr_crop` varchar(100) NOT NULL,
  PRIMARY KEY (`cr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;