-- MySQL dump 10.10
--
-- Host: localhost    Database: coco
-- ------------------------------------------------------
-- Server version	5.0.22

/*!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 */;
/*!40101 SET NAMES utf8 */;
/*!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 `Clones`
--

DROP TABLE IF EXISTS `Clones`;
CREATE TABLE `Clones` (
  `A_No` varchar(30) NOT NULL default '',
  `Pedigree` text,
  `Centre_of_Distribution` text,
  `Compatibility_Reaction` text,
  `Yiled_Potential` text,
  `Special_Feature` text,
  `Leaf_Character` text,
  `Fruit_Character` text,
  `Plant_Habit` text,
  `Tolerance_to_BPD` text,
  `Quality` text,
  PRIMARY KEY  (`A_No`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Clones`
--


/*!40000 ALTER TABLE `Clones` DISABLE KEYS */;
LOCK TABLES `Clones` WRITE;
INSERT INTO `Clones` VALUES ('IV - 20/VTLC 7','Landas 357','Sabah , Malaysia','Self Compatible','4.24','High Yielder\r\nGeneral combiner','Base - Obtuse\r\nApex - Long Acuminated\r\nPetiole - Non-Pulvinated\r\nColour of Young Leaf - Purple\r\n','Shape - Obovate Basal Constriction -Slight Apex - Mammelate Surface - Intermediate Prominence of Ridge & Furrow - Slight Hardness - Intermediate Colour Pattern - Green (Immature) to Yellow (Ripe)','Erect','Susceptible','Fat content(%) - 46.56\r\nBean size(g) - 1.06'),('IV – 84','Landas 361','Landas Estate, Malaysia','Self Incompatible','2.08','High yielder ','Base - Obtuse\r\nApex - Long Acuminate\r\nPetiole - Non-pulvinated\r\nColour of Young Leaf - Purple\r\n','Shape - Elliptical\r\nBasal Constriction - Slight\r\nApex  - Acute\r\nSurface  - Intense\r\nProminence of Ridge & Furrow - Distinct\r\nHardness - Intermediate\r\nColour Pattern - Green (Immature) to Yellow (Ripe)\r\n','Erect','Susceptible','Fat content (%)- 45.67\r\nBean size (g)  - 0.94 '),('IV - 84','Landas 361','Landas Estate, Malaysia','Self Incompatible','2.08','High yielder ','Base - Obtuse\r\nApex - Long Acuminate\r\nPetiole - Non-pulvinated\r\nColour of Young Leaf - Purple\r\n','Shape - Elliptical\r\nBasal Constriction - Slight\r\nApex  - Acute\r\nSurface  - Intense\r\nProminence of Ridge & Furrow - Distinct\r\nHardness - Intermediate\r\nColour Pattern - Green (Immature) to Yellow (Ripe)\r\n','Erect','Susceptible','Fat content (%)- 45.67\r\nBean size (g)  - 0.94 '),('II - 46/VTLC 6','Landas 365','Landas Estate, Malaysia,1968','Self Incompatible & Cross Compatible','2.29','Heavy bearer, Vigorous ','Base - Obtuse\r\nApex -  Long Acuminate\r\nPetiole - Non-pulvinated\r\nColour of Young Leaf – Green\r\n','Shape     - Obovate\r\nBasal Constriction - Slight\r\nApex      - Mammalate\r\nSurface  - Intermediate\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)\r\n','Intermediate to erect & Pendulous','Susceptible','Fat content (%) -\r\nBean size (g) - 0.9'),('II - 51/VTLC 2','Landas 356','Landas Estate, Malaysia,1968','Self Incompatible & Cross Compatible','2.32','Heavy bearer, Vigorous ','Base    - Obtuse\r\nApex    - Short  Acuminate Petiole   - Non- pulvinated\r\nColour of Young Leaf - Intermediate','Shape     - Obovate\r\nBasal Constriction - Intermediate\r\nApex      - Obtuse\r\nSurface  - Intermediate to smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)\r\n','Intermediate t','Susceptible','Fat content (%) - 42.11\r\nBean size (g) - 0.86'),('NC 26/VTLC 18','P6 x P4','Nigeria','Self Incompatible','1.29','Drought Tolerant	','Base      - \r\nApex      - \r\nPetiole   - \r\nColour of Young Leaf - ','Shape     - \r\nBasal Constriction - \r\nApex      - \r\nSurface  - I\r\nProminence of Ridge & Furrow - \r\nHardness - \r\nColour Pattern - Green (Immature) to Yellow (Ripe)\r\n',' ','Susceptible','Fat content (%) - 30.311\r\nBean size (g) - '),('NC - 55/VTLC 40','T17/ 11','Nigeria','Self Incompatible & Cross Compatible','0','Pre potent, Precocious, Attains stability by third year itself \r\n	','Base      - Obtuse\r\nApex      - Long Acuminate\r\nPetiole   - Pulvinated\r\nColour of Young Leaf - Intermediate\r\n','Shape     - Obovate\r\nBasal Constriction - Intermediate\r\nApex      - Mammalate\r\nSurface  - Rugose\r\nProminence of Ridge & Furrow - Distinct\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)',' Intermediate','Susceptible','Fat content (%)- 39.57 \r\nBean size (g) - 1.08 \r\nShelling  - 11'),('NC - 12/VTLC 46','Unknown','Nigeria','Self Incompatible & Cross Compatible','151',' \r\n	','Base      - Obtuse\r\nApex      - Short Acuminate\r\nPetiole   - Non- pulvinated\r\nColour of Young Leaf - Intermediate\r\n','Shape     - Obovate\r\nBasal Constriction - Slight\r\nApex      - Mammalate\r\nSurface  - Intermediate to smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Pink (Immature) to Orange (Ripe)\r\n','Intermediate to erect','Susceptible','Fat content (%) - 38.00 \r\nBean size (g)  -1.00 \r\nShelling       - 12'),('NC - 49/VTLC 35','C 78','Nigeria','Self Incompatible & Cross Compatible','1.51',' \r\n	','Base      - Obtuse\r\nApex      - Long Acuminate\r\nPetiole   - Pulvinated\r\nColour of Young Leaf - Intermediate','Shape     - Obovate\r\nBasal Constriction - Distinct\r\nApex      - Mammalate\r\nSurface  - Intermediate to smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Intermediate to erect','Susceptible','Fat content (%) - 40.10 \r\nBean size (g)  -1.02\r\nShelling - 11'),('NC - 21/VTLC 14','Pi 76 x TI 915','Nigeria','Self Incompatible & Cross Compatible','1.45 per 3.0 m3 canopy volume',' \r\n	','Base      - Acute\r\nApex      - Long Acuminate\r\nPetiole   - Pulvinated\r\nColour of Young Leaf – Purple','Shape     - Obovate\r\nBasal Constriction - Deep\r\nApex      - Mammalate\r\nSurface  - Intermediate to smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)\r\n','Intermediate to erect','Susceptible','Fat content (%)   - 38.00 \r\nBean size (g)     -1.05 \r\nShelling          -12'),('NC - 18/VTLC 34','Unknown','Nigeria','Self Incompatible & Cross Compatible','1.50 per 4.35 m3 canopy volume',' \r\n	','Base      - Acute\r\nApex      - Long Acuminate\r\nPetiole   - Pulvinated\r\nColour of Young Leaf – Purple','Shape     - Obovate\r\nBasal Constriction - Deep\r\nApex      - Mammalate\r\nSurface  - Rugose\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Pink (Immature) to Orange (Ripe)\r\n','Intermediate ','Susceptible','Fat content (%)     - 41.00 \r\nBean size (g)         -0.94 \r\nShelling                  - 12'),('NC 42/ 94/VTLC 56','T 86/ 2','Nigeria','Self Incompatible & Cross Compatible','1.1.3.03 per 2 storeyed canopy',' Heavy bearer, best combiner, pollen donor, kept in scion bank\r\n	','Base      - Obtuse\r\nApex      - Short  Acuminate\r\nPetiole   - Pulvinated\r\nColour of Young Leaf - Intermediate','Shape     - Arched\r\nBasal Constriction - Intermediate\r\nApex      - Mammalate\r\nSurface  - Intermediate Rugosity\r\nProminence of Ridge & Furrow - Distinct\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)\r\n','Intermediate ','Susceptible','Fat content (%)    - 48.23 \r\nBean size (g)        - 1.08\r\nShelling (%)          - 86 '),('ICS - 1/VTLC 24',' ','Kew garden thro. Lal Baugh, Bangalore','Self Incompatible & Cross Compatible','>1.00 per 4.00 m3 canopy volume','  \r\n	','Base      - Obtuse\r\nApex      - Long Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Pale purple','Shape     - Obovate\r\nBasal Constriction - Slight\r\nApex      - Mammalate\r\nSurface  - Warty\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Pink (Immature) to Orange (Ripe)','Pendulous ','Susceptible','Fat content (%)     - 33.40 \r\nBean size (g)         - 1.60 \r\nShelling                  - 94'),('ICS - 95/VTLC 18',' ','Kew garden thro. Lal Baugh, Bangalore','Self Incompatible & Cross Compatible','1.0 per 1.5 m3 canopy volume','Parental line','Base      - Acute\r\nApex      - Long Acuminate\r\nPetiole   - Pulvinated\r\nColour of Young Leaf – Purple','Shape     - Rounded\r\nBasal Constriction - Slight\r\nApex      - Mammalate\r\nSurface  - Intermediate\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Intermediate ','Susceptible','Fat content (%)     - 41.03 \r\nBean size (g)         -0.73 \r\nShelling                  - 91'),('IMC - 67/VTLC 21',' ','Kew garden thro. Lal Baugh, Bangalore','Self & Cross Compatible','1.0 per 3.5 m3 canopy volume',' ','Base      - Obtuse\r\nApex      - Short Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Purple','Shape     - Obovate\r\nBasal Constriction - Intermediat\r\nApex      - Attenuate\r\nSurface  - Intermediate\r\nProminence of Ridge & Furrow - Distinct\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Pendulous ','Susceptible','Fat content (%)     - 45.79 \r\nBean size (g)         - 1.17 \r\nShelling                  - 91'),('Na - 33/VTLC 20',' Nanay series','Kew garden thro. Lal Baugh, Bangalore','Self Incompatible & Cross Compatible','>1.0 per 1.0 m3 canopy volume>1.0 per 1.0 m3 canopy volume','Drought tolerant line','Base      - Obtuse\r\nApex      - Acuminate\r\nPetiole   - \r\nColour of Young Leaf – Purple','Shape     - Oblong to Elliptic\r\nBasal Constriction - Intermediate\r\nApex      - Attenuate\r\nSurface  - Intermediate\r\nProminence of Ridge & Furrow - Distinct\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe','Erect','Susceptible','Fat content (%)     - 41.43 \r\nBean size (g)         -0.76 \r\nShelling                  - 91'),('Na 31/VTLC 19',' Nanay series','Kew garden ','Self & Cross Compatible','0.5 per 4.0 m3 canopy volume',' ','Base      - Obtuse\r\nApex      - Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Purple','Shape     - Obovate\r\nBasal Constriction - Absent\r\nApex      - Mammalate\r\nSurface  - Smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Intermediate','Susceptible','Fat content (%)     - 33.39 \r\nBean size (g)         - 0.80 \r\nRecovery               - 91.25'),('Na 242/VTLC 59',' Nanay series','Kew garden ','','>1.5 kg ',' High yielder, stress tolerant','Base      - Acute\r\nApex      - Short  Acuminate\r\nPetiole   - Pulvinated\r\nColour of Young Leaf - Intermediate','Shape     - Obovate\r\nBasal Constriction - Intermediate\r\nApex      - Attenuate\r\nSurface  - \r\nProminence of Ridge & Furrow - \r\nHardness - \r\nColour Pattern - ','Erect','Susceptible','Fat content (%)    - 44.07 \r\nBean size (g)        - 1.06\r\nShelling (%)          - '),('SCA - 12/VTLC 67','SCA - 12','Kew garden thro. Lal Baugh, Bangalore ','Self & Cross Compatible','>1.0 per 2.0 m3 canopy volume ','Tolerant to VSD ','Base      - Obtuse\r\nApex      - Long Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Pale purple','Shape     - Obovate\r\nBasal Constriction - Absent\r\nApex      - Attenuate\r\nSurface  - Intermediate\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Pendulous','Not known','Fat content (%)    - 44.07 \r\nFat content (%)     - 37.95 \r\nBean size (g)         - 1.18 \r\nShelling                  - 90.5'),('ICS 6/VTLC 61','ICS 6','Kew garden thro. Lal Baugh, Bangalore ','Self Incompatible & Cross Compatible','0.5 per 1.71 m3 canopy volume','  ','Base      - Obtuse\r\nApex      - Short Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Pale purple','Shape     - Obovate\r\nBasal Constriction - Absent\r\nApex      - Mammalate\r\nSurface  - Slight Rugose\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Pendulous','Not known','Fat content (%)     - 33.69 \r\nBean size (g)         - 1.06 \r\nShelling                  - 95'),('SIAL 93/VTLC 56','SIAL 93','Kew garden thro. Lal Baugh, Bangalore','Self & Cross Compatible','0.5 per 3.0 m3 canopy volume',' ','Base      - Obtuse\r\nApex      - Long Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Pale purple','Shape     - Obovate\r\nBasal Constriction - Absent\r\nApex      - Mammalate\r\nSurface  - Smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Pendulous','Not known','Fat content (%)     - 36.22 \r\nBean size (g)         - 0.93 \r\nShelling                  - 0.95'),('EET 272/VTLC 58','EET 272','Kew Garden ','Self Incompatible & Cross Compatible','1.0 per 5.0 m3 canopy volume',' ','Base      - Acute \r\nApex      - Short Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Purple','Shape     - Cylindrical\r\nBasal Constriction - Slight\r\nApex      - Mammalate\r\nSurface  - Smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Pendulous','Not known','Fat content (%)     - 36.22 \r\nFat content (%)     - 33.45 \r\nBean size (g)         - 0.87 \r\nRecovery               - 89.4'),('IMC 10/VTLC 57','IMC 10','Kew Garden ','Self Incompatible & Cross Compatible','1.0 per 2.0 m3 canopy volume',' ','Base      - Acute\r\nApex      - Long Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Pale purple','Shape     - Obovate\r\nBasal Constriction - Slight\r\nApex      - Attenuate\r\nSurface  - Rugose\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Pendulous/ Intermediate','Susceptible','Fat content (%)     - 42.10 \r\nBean size (g)         - 1.37 \r\nRecovery               - 89'),('SCA 6/VTLC 66','Scavina group ','Kew Garden ','Self & Cross Compatibleble','1.0 per 1.0 m3 canopy volume',' ','Base      - Obtuse\r\nApex      - Long Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Purple','Shape     - Cylindrical \r\nBasal Constriction - Absent\r\nApex      - Mammalate\r\nSurface  - Smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Intermediate','Susceptible','Fat content (%)     - \r\nBean size (g)         - 0.45\r\nRecovery               - 89'),('V 1/VTLC 70','T 76/ 1224/ 1201 Amazon ','KAU, Vellanikkara ','Self Incompatible & Cross Compatible','1.0 per 4.0 m3 canopy volume',' ','Base      - Acute\r\nApex      - Short Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Pale purple to Green','Shape     - Round\r\nBasal Constriction - Absent\r\nApex      - Mammalate\r\nSurface  - Smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Erect','Susceptible','Fat content (%)     - 21.26\r\nBean size (g)         - 0.93\r\nRecovery               - 91.4'),('V 7/VTLC 75','T 72/ 1559 Nanay Iquitos ','KAU','Self & Cross Compatible','>1.00 per 4.00 m3 canopy volume',' ','Base      - Obtuse\r\nApex      - Acuminate\r\nPetiole   - \r\nColour of Young Leaf - Pale purple','Shape     - Round\r\nBasal Constriction - Absent\r\nApex      - Mammalate\r\nSurface  - Smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Intermediate','Susceptible','Fat content (%)     - \r\nBean size (g)         - 0.88\r\nRecovery               - 88.9\r\nShelling                  - 16.1'),('I - 14/VTLC 1','Jarangau Red Axil ','Landas estate, Malaysia','Self Incompatible & Cross Compatible','7.51 kg per 3 storeyed canopy','Heavy bearer, vigorous, parental line for hybridization, red axil marker used in rootstock preparation ','Base      - Obtuse\r\nApex      - Short Acuminate\r\nPetiole   - Non- pulvinated\r\nColour of Young Leaf – Intermediate','Shape     - Obovate\r\nBasal Constriction - Slight\r\nApex      - Mammalate\r\nSurface  - Smooth\r\nProminence of Ridge & Furrow - Slight\r\nHardness - Hard\r\nColour Pattern - Pink (Immature) to Orange (Ripe)','Erect, Pendulous & Intermediate','Susceptible','Fat content (%)     - 47.30\r\nBean size (g)         - 1.17\r\nShelling (%)           - 0.95'),('II - 65/VTLC 3','Landas 358 ','Sabah, Malaysia','Self Incompatible','3.9 per 2 storeyed canopy ','High yielder, heavy bean size','Base      - Obtuse\r\nApex      - Short  Acuminate\r\nPetiole   - Non- pulvinated\r\nColour of Young Leaf - Intermediate','Shape     - Obovate\r\nBasal Constriction - Absent\r\nApex      - Obtuse\r\nSurface  - Slight Rugosity\r\nProminence of Ridge & Furrow – Slight & super fine furrow \r\nHardness - Moderately Hard\r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Intermediate ','Susceptible','Fat content (%)    - 44.96 \r\nBean size (g)        - 1.50 '),('II - 67/VTLC 5','Landas 364 ','Sabah, Malaysia','Self Incompatible','2.16 kg ','General combiner, pollen parent','Base      - Obtuse\r\nApex      - Short  Acuminate\r\nPetiole   - Pulvinated\r\nColour of Young Leaf - Intermediate','Shape     - Obovate\r\nBasal Constriction - Intermediate\r\nApex      - Attenuate\r\nSurface  - \r\nProminence of Ridge & Furrow - \r\nHardness - \r\nColour Pattern - Green (Immature) to Yellow (Ripe)','Erect ','Susceptible','Fat content (%)    - 42.11 \r\nBean size (g)        - 0.86 ');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Clones` ENABLE KEYS */;

--
-- Table structure for table `Descriptor`
--

DROP TABLE IF EXISTS `Descriptor`;
CREATE TABLE `Descriptor` (
  `A_No` varchar(30) NOT NULL default '',
  `Pedigree_Parentage` text,
  `Centre` text,
  `Compatibiilty` text,
  `Yield_Potential` float default NULL,
  `Leaf_Character` text,
  `Fruit_Character` text,
  `Plant_habit` text,
  `Tolerance` text,
  `Quality` text,
  PRIMARY KEY  (`A_No`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Descriptor`
--


/*!40000 ALTER TABLE `Descriptor` DISABLE KEYS */;
LOCK TABLES `Descriptor` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Descriptor` ENABLE KEYS */;

--
-- Table structure for table `Hybrids`
--

DROP TABLE IF EXISTS `Hybrids`;
CREATE TABLE `Hybrids` (
  `A_No` varchar(30) NOT NULL default '',
  `Pedigree` text,
  `Centre_of_Distribution` text,
  `Compatibility_Reaction` text,
  `Yiled_Potential` float default NULL,
  `Special_Feature` text,
  `Leaf_Character` text,
  `Fruit_Character` text,
  `Plant_Habit` text,
  `Tolerance_to_BPD` text,
  `Quality` text,
  PRIMARY KEY  (`A_No`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Hybrids`
--


/*!40000 ALTER TABLE `Hybrids` DISABLE KEYS */;
LOCK TABLES `Hybrids` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Hybrids` ENABLE KEYS */;

--
-- Table structure for table `ICS_6`
--

DROP TABLE IF EXISTS `ICS_6`;
CREATE TABLE `ICS_6` (
  `Name` varchar(30) NOT NULL default '',
  `Pedigree` text,
  `Centre` text,
  `Compatibility` text,
  `Yield` text,
  `Dry_Bean` text,
  `Special_Features` text,
  `Plant_Habit` text,
  `Stem_Girth` float default NULL,
  `Height` float default NULL,
  `Canopy_Height` float default NULL,
  `No_of_Branches` float default NULL,
  `Pods` float default NULL,
  `Pod_Value` float default NULL,
  `Wet` float default NULL,
  `Fruit_Shape` text,
  `Ridge_Furrow` text,
  `Hardness` text,
  `Colour_Pattern` text,
  `Fat_Content` text,
  `Bean_Size` text,
  `Shelling` text,
  `Recovery_Percent` text,
  PRIMARY KEY  (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ICS_6`
--


/*!40000 ALTER TABLE `ICS_6` DISABLE KEYS */;
LOCK TABLES `ICS_6` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ICS_6` ENABLE KEYS */;

--
-- Table structure for table `II_67`
--

DROP TABLE IF EXISTS `II_67`;
CREATE TABLE `II_67` (
  `Name` varchar(30) NOT NULL default '',
  `Pedigree` text,
  `Centre` text,
  `Compatiblity` text,
  `Yield` text,
  `Dry_Bean` text,
  `Special_Features` text,
  `Plant_Habit` text,
  `Stem_Girth` float default NULL,
  `Height` float default NULL,
  `Cnopy_height` float default NULL,
  `Canopy_Volume` float default NULL,
  `No_of_Branches` float default NULL,
  `Pods` float default NULL,
  `Pod_Value` float default NULL,
  `Pod_index` float default NULL,
  `Fresh_Pod_Wight` float default NULL,
  `No_of_Beans` float default NULL,
  `Wet_Bean_weight` float default NULL,
  `Fruit_Shape` text,
  `Ridge` text,
  `Hardness` text,
  `Colour_Pattern` text,
  `Bean_Size` text,
  `Shelling` text,
  `Recovery` text,
  `Stomatal_Resist` text,
  PRIMARY KEY  (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `II_67`
--


/*!40000 ALTER TABLE `II_67` DISABLE KEYS */;
LOCK TABLES `II_67` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `II_67` ENABLE KEYS */;

--
-- Table structure for table `Lalbaugh`
--

DROP TABLE IF EXISTS `Lalbaugh`;
CREATE TABLE `Lalbaugh` (
  `S_No` int(11) default NULL,
  `Accession_No` varchar(30) NOT NULL default '',
  `Parentage` text,
  `Yr_of_proc` int(11) default NULL,
  `Planting_material` text,
  `Origin` text,
  PRIMARY KEY  (`Accession_No`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Lalbaugh`
--


/*!40000 ALTER TABLE `Lalbaugh` DISABLE KEYS */;
LOCK TABLES `Lalbaugh` WRITE;
INSERT INTO `Lalbaugh` VALUES (1,'ICS 6','ICS 6',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore'),(2,'ICS 95','ICS 65',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore'),(3,'Na 31','Na 31',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore'),(4,'Na 33','Na 33',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore'),(5,'IMC 67','IMC 67',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore'),(6,'SCA 6','SCA 6',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore'),(7,'SCA 12','SCA 12',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore'),(8,'ICS 1','ICS 1',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore'),(9,'ICS 89','ICS 89',1982,'Clones (stem  cutting)','Lalbaugh gardens,Bangalore');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Lalbaugh` ENABLE KEYS */;

--
-- Table structure for table `NC_45`
--

DROP TABLE IF EXISTS `NC_45`;
CREATE TABLE `NC_45` (
  `Name` varchar(30) NOT NULL default '',
  `Pedigree` text,
  `Centre` text,
  `Compatibilty` text,
  `Yield` text,
  `Special_Feature` text,
  `Plant_Habit` text,
  `Stem_Diameter` float default NULL,
  `Height` text,
  `Total` float default NULL,
  `Canopy` float default NULL,
  `Canopy_Volume` float default NULL,
  `No_of_Branches` float default NULL,
  `Fruit_Shape` text,
  `Ridge` text,
  `Hardness` text,
  `Colour` text,
  `No_of_pods` float default NULL,
  `No_of_Beans` float default NULL,
  `Pod_Value` float default NULL,
  `Single_pod_weight` text,
  `1000_seed_weight` text,
  `Beans` text,
  `Dry_wet` text,
  `Fat_Content` text,
  `Bean_size` text,
  `Shelling` text,
  PRIMARY KEY  (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NC_45`
--


/*!40000 ALTER TABLE `NC_45` DISABLE KEYS */;
LOCK TABLES `NC_45` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `NC_45` ENABLE KEYS */;

--
-- Table structure for table `Nigerian`
--

DROP TABLE IF EXISTS `Nigerian`;
CREATE TABLE `Nigerian` (
  `S_No` int(11) default NULL,
  `Accession_No` varchar(30) NOT NULL default '',
  `Parentage` text,
  `Yr_of_Proc` int(11) default NULL,
  `Planting_material` text,
  `Origin` text,
  PRIMARY KEY  (`Accession_No`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Nigerian`
--


/*!40000 ALTER TABLE `Nigerian` DISABLE KEYS */;
LOCK TABLES `Nigerian` WRITE;
INSERT INTO `Nigerian` VALUES (1,'NC 16','P 6 x P 6',1974,'Seeds','Nigeria'),(2,'NC 20','P 4 x P 1',1974,'Seeds','Nigeria'),(3,'NC 21','PI 76 x TI 915',1974,'','Nigeria'),(4,'NC 23','P 3 x P-',1974,'Seeds','Nigeria'),(5,'NC 24','P 6 x PI 14',1974,'Seeds','Nigeria'),(6,'NC 25','T 30/10 x Na 32',1974,'Seeds','Nigeria'),(7,'NC 26','P 6 xP 4(doubt)',1974,'Seeds','Nigeria'),(8,'NC 29','P 6 xP 4',1974,'Seeds','Nigeria'),(9,'NC 30','P 3 xP 4',1974,'Seeds','Nigeria'),(10,'NC 31','P 12 x P 3',1974,'Seeds','Nigeria'),(11,'NC 32','P 9 x P 4',1974,'Seeds','Nigeria'),(12,'NC 34','P 9 x P 7',1974,'Seeds','Nigeria'),(13,'NC 36','T 85/5 x Na 32',1974,'Seeds','Nigeria'),(14,'NC 37','P 7 x P 6',1974,'Seeds','Nigeria'),(15,'NC 38','P 10 x P16',1974,'Seeds','Nigeria'),(16,'NC 39','T 7/12 ',1974,'Seeds','Nigeria'),(17,'NC 40','WS/15 (T63/881)',1974,'Seeds','Nigeria'),(18,'NC 41','T 65/7',1974,'Seeds','Nigeria'),(19,'NC 42','T 86/2',1974,'Seeds','Nigeria'),(20,'NC 43','W6/56 (T63/910)',1974,'Seeds','Nigeria'),(21,'NC 45','-',1974,'Seeds','Nigeria'),(22,'NC 46','-',1974,'Seeds','Nigeria'),(23,'NC 48','-',1974,'Seeds','Nigeria'),(24,'NC 49','C-78',1974,'Seeds','Nigeria'),(25,'NC 50','C-79',1974,'Seeds','Nigeria'),(26,'NC 51','C-44',1974,'Seeds','Nigeria'),(27,'NC 52','C-83',1974,'Seeds','Nigeria'),(28,'NC 53','C-76',1974,'Seeds','Nigeria'),(29,'NC 55','T 17/11',1974,'Seeds','Nigeria'),(30,'NC 56','642',1974,'Seeds','Nigeria'),(31,'NC 57','ICS 1',1974,'Seeds','Nigeria'),(32,'NC 14','-',1974,'Seeds','Nigeria'),(33,'NC 15','-',1974,'Seeds','Nigeria'),(34,'NC 13','-',1974,'Seeds','Nigeria'),(35,'NC 12','-',1974,'Seeds','Nigeria'),(36,'NC 11','-',1974,'Seeds','Nigeria'),(37,'NC 10','-',1974,'Seeds','Nigeria'),(38,'NC 9','-',1974,'Seeds','Nigeria'),(39,'NC 8','-',1974,'Seeds','Nigeria'),(40,'NC 7','-',1974,'Seeds','Nigeria'),(41,'NC 6','-',1974,'Seeds','Nigeria'),(42,'NC 5','-',1974,'Seeds','Nigeria'),(43,'NC 3','-',1974,'Seeds','Nigeria'),(44,'NC 2','-',1974,'Seeds','Nigeria');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Nigerian` ENABLE KEYS */;

--
-- Table structure for table `Released`
--

DROP TABLE IF EXISTS `Released`;
CREATE TABLE `Released` (
  `Name` varchar(30) NOT NULL default '',
  `Pedigree` text,
  `Centre` text,
  `Compatibility` text,
  `Yield_Potential` text,
  `Dry_Bean_Yield` text,
  `Special_Features` text,
  `Plant_habit` text,
  `Girth` float default NULL,
  `Height` float default NULL,
  `Height_m` float default NULL,
  `Canopy_Volume` float default NULL,
  `Pruning_weight` float default NULL,
  `Pods_Tree` float default NULL,
  `Fruit_Shape` text,
  `Ridge_Furrow` text,
  `Hardness` text,
  `Colour` text,
  `Fat_Content` text,
  `Bean_Size` text,
  `Shelling` text,
  `Stem_Girth` float default NULL,
  `Canopy_Height` float default NULL,
  `No_of_Br` float default NULL,
  `Pod_Value` float default NULL,
  `Wet_Dry_Bean` float default NULL,
  `Recovery_Percent` text,
  `Pod_index` float default NULL,
  `Fresh_Pod_wgt` float default NULL,
  `No_of_Beans` float default NULL,
  `Wet_Bean_Weight` float default NULL,
  `Stomatal_Resistence` float default NULL,
  `Stem_Diameter` float default NULL,
  `Total_Height` float default NULL,
  `Single_Pod_Weight` float default NULL,
  `1000_Seed_Weight` float default NULL,
  `Beans` text,
  `Dry_Wet_Bean` text,
  PRIMARY KEY  (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Released`
--


/*!40000 ALTER TABLE `Released` DISABLE KEYS */;
LOCK TABLES `Released` WRITE;
INSERT INTO `Released` VALUES ('I-56 x II-67','I-56 x II-67','CPCRI, RS,Vittal','SI & CC','1.481 kg/ 16 m3','1.117 kg/tree/year','Early bearer','Erect',50.66,1.29,4.56,16.82,19.01,46.93,'Acute, Mammallate','Smooth, Prominent','Hard','Green (immature), Yellow (ripe)','53.57%','1.0 g','13%',0,0,0,0,0,'',0,0,0,0,0,0,0,0,0,'',''),('II 67 x NC 29/ 66','II-67 x NC 29/ 66','CPCRI, RS, Vittal','Self Incomaptible & Cross Compatible','1005.4 kg dry bean/ ha/ year','1.478 kg/ tree/ year','Early & Heavy bearer,Drought Tolerant','Intermediate',0,1.98,6.04,22.24,0,38.21,'Obovate, Mammallate','Intermediate','Intermediate','Red (immature), Pink (ripe)','0','1.066','13.70 %',14.97,6.04,2.89,46.17,0,'89.06 %',21.72,436.62,43.32,109.32,2.42,0,0,0,0,'0','0'),('II 67 x NC 42/ 94','II 67 x NC 42/ 94','CPCRI, RS, Vittal','Self Incomaptible & Cross Compatible','846.87 kg dry bean/ ha/ year','1.245 kg/ tree/ year','Early & Heavy bearer,Drought Tolerant','Intermediate',0,2.09,0,18.46,0,34.31,'Obovate, Mammallate','Prominent','Hard','Green (immature), Yellow (ripe)','0','0.994 g','12.14 %',13.54,5.55,3.28,41.25,0,'50.92 %',24.74,429.5,41.5,99.78,2.42,0,0,0,0,'0','0'),('ICS 6 x SCA 6','ICS 6 x SCA 6','CPCRI, RS, Vittal','SI & CC','5.0 kg/ 20 m3','1.145 kg/ tree/ year','Early & Heavy bearer','Pendulous',0,1.43,0,9.1,0,70,'Obovate, Mammallate','Prominent, Slight','Hard','Green (immature), Yellow (ripe)','53.58%','1.10 g','10.94',9.74,2.38,2.58,41.32,3.62,'89.06 %',0,0,0,0,0,0,0,0,0,'0','0'),('NC 45/ 53','Unknown','Nigeria','Self compatible','2.5 kg/ 3.0 m3 canopy volume','--','Heavy bearer, Selected Nigerian Clone','Intermediate',0,1.65,0,12.86,0,75,'Obovate, Mammallate','Prominent','Hard','Green (immature), Yellow (ripe)','42.50%','1.05 g','12 %',0,2.51,2.6,31.48,0,'0',0,0,36.7,0,0,11.86,4.16,321,0.874,'24 %','41.86 %');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Released` ENABLE KEYS */;

--
-- Table structure for table `ReleasedDescription`
--

DROP TABLE IF EXISTS `ReleasedDescription`;
CREATE TABLE `ReleasedDescription` (
  `Name` varchar(30) NOT NULL default '',
  `Pedigree` text,
  `Centre` text,
  `Compatibility` text,
  `Yield_Potential` text,
  `Dry_Bean_Yield` text,
  `Special_Features` text,
  `Plant_Habit` text,
  `Girth` float default NULL,
  `Height_Br` float default NULL,
  `Height` float default NULL,
  `Canopy_Volume` float default NULL,
  `Pruning_Weight` float default NULL,
  `Pods` float default NULL,
  `Fruit_Shape` text,
  `Ridge_Furrow` text,
  `Hardness` text,
  `Colour_Pattern` text,
  `Fat_Content` text,
  `Bean_Size` text,
  `Shelling` text,
  PRIMARY KEY  (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ReleasedDescription`
--


/*!40000 ALTER TABLE `ReleasedDescription` DISABLE KEYS */;
LOCK TABLES `ReleasedDescription` WRITE;
INSERT INTO `ReleasedDescription` VALUES ('I-56 x II-67','I-56 x II-67','CPCRI, RS, Vittal','SI & CC','1.481 kg/ 16 m3','1.117 kg/tree/year','Early bearer','Erect',50.66,1.29,4.56,16.82,19.01,46.93,'Acute,Mammalate','Smooth, Prominent','Hard','Green(Immature),Yellow(ripe)','53.57%','1.0 g','13 %');
UNLOCK TABLES;
/*!40000 ALTER TABLE `ReleasedDescription` ENABLE KEYS */;

--
-- Table structure for table `ReleasedVarieties`
--

DROP TABLE IF EXISTS `ReleasedVarieties`;
CREATE TABLE `ReleasedVarieties` (
  `Name` varchar(30) NOT NULL default '',
  `Proposed_Name` text,
  `Breeding_Method` text,
  `Source_of_material` text,
  `Specific_area_of_adaption` text,
  PRIMARY KEY  (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ReleasedVarieties`
--


/*!40000 ALTER TABLE `ReleasedVarieties` DISABLE KEYS */;
LOCK TABLES `ReleasedVarieties` WRITE;
INSERT INTO `ReleasedVarieties` VALUES ('I-56 x II-67','Vittal Cocoa Hybrid- Selection','Introduction-Evaluation-Slection\r\nHybraddization-Evaluation-Selction','Landas Estate, Malaysia','Areca Gardens of Coastal Karnataka'),('II 67 x NC 29/ 66','Vittal Cocoa Hybrid- 3','Hybradization- Evaluation- Selection','Landas Estate, Malaysia & Nigeria','Rain fed and irrigated Coconut & Areca gardens of Karnataka, Kerala, Tamil Nadu, Andhra, Maharashtra & Goa'),('II 67 x NC 42/ 94','II 67 x NC 42/ 94','Hybradization- Evaluation- Selection','Landas Estate, Malaysia & Nigeria','Rain fed and irrigated Coconut & Areca gardens of Karnataka, Kerala, Tamil Nadu, Andhra, Maharashtra & Goa'),('ICS 6 x SCA 6','Vittal Cocoa Hybrid- 2','Introduction- Evaluation-Selection\r\nHybradization- Evaluation- Selection','Kew Garden, England via Lalbaugh Garden, Bangalore','Areca gardens of Coastal Karnataka'),('NC 45/ 53','Vittal Cocoa Clone- 1','Introduction- Evaluation-Selection\r\n- Evaluation- Selection','Nigerian Collections- Nigerian Estate','Areca gardens of Coastal Karnataka');
UNLOCK TABLES;
/*!40000 ALTER TABLE `ReleasedVarieties` ENABLE KEYS */;

--
-- Table structure for table `aa`
--

DROP TABLE IF EXISTS `aa`;
CREATE TABLE `aa` (
  `hh` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aa`
--


/*!40000 ALTER TABLE `aa` DISABLE KEYS */;
LOCK TABLES `aa` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `aa` ENABLE KEYS */;

--
-- Table structure for table `bestyielders`
--

DROP TABLE IF EXISTS `bestyielders`;
CREATE TABLE `bestyielders` (
  `crosses` text,
  `plant_no` varchar(20) default NULL,
  `shelling_percent` float default NULL,
  `recovery_percent` float default NULL,
  `pod_value` float default NULL,
  `pod_no_maxim` int(11) default NULL,
  `pod_bean_wt` float default NULL,
  `wet_dry_bean` float default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bestyielders`
--


/*!40000 ALTER TABLE `bestyielders` DISABLE KEYS */;
LOCK TABLES `bestyielders` WRITE;
INSERT INTO `bestyielders` VALUES ('Amelonado x Pa 7','III-13',8.73,91.27,41.67,178,15.83,4.83),('ICS 6 x SCA 6','I-8',10.94,89.06,41.32,121,10.69,3.62),('ICS 1 x SCA 12','I-14',15.33,84.67,25,84,9.15,2.15),('Pa 7 x Na 32','II-87',7.19,92.81,71.43,93,14.64,3.21),('Pa 7 x Na 32','II-89',6.89,93.11,64.94,88,14.29,3.64),('IMC 67 x ICS 6','I-23',9.35,90.65,53.19,81,14.79,5.27),('IMC 67 x ICS 6','III-20',11.54,88.46,41.32,81,11.28,2.72),('Na 31 x ICS 1','II-54',12.92,87.08,44.64,80,11.16,2.72);
UNLOCK TABLES;
/*!40000 ALTER TABLE `bestyielders` ENABLE KEYS */;

--
-- Table structure for table `ger`
--

DROP TABLE IF EXISTS `ger`;
CREATE TABLE `ger` (
  `nm` int(11) NOT NULL default '0',
  `tr` text,
  `er` text,
  `fdf` float default NULL,
  PRIMARY KEY  (`nm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ger`
--


/*!40000 ALTER TABLE `ger` DISABLE KEYS */;
LOCK TABLES `ger` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ger` ENABLE KEYS */;

--
-- Table structure for table `gh`
--

DROP TABLE IF EXISTS `gh`;
CREATE TABLE `gh` (
  `dd` text,
  `kk` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gh`
--


/*!40000 ALTER TABLE `gh` DISABLE KEYS */;
LOCK TABLES `gh` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `gh` ENABLE KEYS */;

--
-- Table structure for table `growth`
--

DROP TABLE IF EXISTS `growth`;
CREATE TABLE `growth` (
  `treatments` varchar(30) NOT NULL default '',
  `girth` float default NULL,
  `hafb` float default NULL,
  `canopy_ht` float default NULL,
  `canopy_vol` float default NULL,
  `noofbranch` float default NULL,
  `pruning` float default NULL,
  PRIMARY KEY  (`treatments`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `growth`
--


/*!40000 ALTER TABLE `growth` DISABLE KEYS */;
LOCK TABLES `growth` WRITE;
INSERT INTO `growth` VALUES ('Na 33 x ICS 89',9,1.51,2.79,12.92,3,15.4),('SCA 6 x IMC 67',9.39,1.61,2.61,9.97,2.83,17.35),('Na 31 x ICS 89',10.44,1.51,2.93,14.26,2.87,20.21),('SCA 6 x ICS 6',9.22,1.62,2.4,9.63,3.05,16.33),('Na 31 X ICS 95',9.81,1.66,2.59,12.67,2.87,22.45);
UNLOCK TABLES;
/*!40000 ALTER TABLE `growth` ENABLE KEYS */;

--
-- Table structure for table `growthparameters`
--

DROP TABLE IF EXISTS `growthparameters`;
CREATE TABLE `growthparameters` (
  `crosses` varchar(30) NOT NULL default '',
  `pruning_wt` float default NULL,
  `height` float default NULL,
  `girth` float default NULL,
  `hafb` float default NULL,
  `canopy_volume` float default NULL,
  `bean_yield` float default NULL,
  PRIMARY KEY  (`crosses`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `growthparameters`
--


/*!40000 ALTER TABLE `growthparameters` DISABLE KEYS */;
LOCK TABLES `growthparameters` WRITE;
INSERT INTO `growthparameters` VALUES ('I-14xNC42/94',11.845,4.61,42.44,2.03,15.89,0.835),('I-14xIV-20',14.932,4.29,47.97,1.54,8.92,0.684),('I-14xI-56',21.73,4.77,42.77,1.81,8.34,0.939),('I-14xIII-35',14.22,4.66,45.33,2.06,7.23,1.008),('I-14xIII-105',19.61,4.38,46.88,1.6,12.32,0.584),('I-56xNC42/94',9.64,4.04,41.66,1.38,9.12,0.51),('I-56xIV-20',13.23,4.51,47.99,1.62,14.28,1.193),('I-56xII-67',19.01,4.56,50.66,1.29,16.82,1.117),('I-56xIII-35',15.07,4.44,46.66,1.7,4.75,1.293),('I-56xIII-105',12.62,4.22,39.33,1.55,7.84,0.916),('II-67xNC42/94',11.19,4.42,39.55,1.89,10.02,0.758),('II-67xIV-20',10.08,4.46,43.11,1.58,10.66,0.629),('III-35xNC42/94',21.67,4.44,46.22,1.3,11.43,0.508),('III-35xIV-20',11.04,4.34,45.11,1.53,12.05,0.9),('III-105xNC42/94',19.33,4.35,47.72,1.19,8.78,1.056),('III-105xIV-20',13.09,4.41,45.22,1.7,13.82,0.747),('III-105xI-56',18.22,3.94,46.78,1.6,13.05,0.858),('I-14',13.28,4.18,45.66,1.54,14.35,0.659),('I-56',14.39,3.99,39.44,1.45,8045,0.758),('II-67',12.77,4.15,33.22,1.48,9.52,0.598),('III-35',8.67,4.47,45.66,2.13,8.45,0.938),('III-105',7.71,4.19,32.78,1.7,8.32,0.608),('IV-20',5.22,4.39,44.55,1.45,10.91,0.74),('NC42/94',7.47,4.1,41.55,1.82,10.74,0.452),('1-56 SEEDING',8,4.38,50.11,1.63,10.79,0.747);
UNLOCK TABLES;
/*!40000 ALTER TABLE `growthparameters` ENABLE KEYS */;

--
-- Table structure for table `hybrid`
--

DROP TABLE IF EXISTS `hybrid`;
CREATE TABLE `hybrid` (
  `a_no` varchar(30) NOT NULL default '',
  `pedigree` text,
  `center` text,
  `compatibility` text,
  `yield` text,
  `s_feature` text,
  `l_character` text,
  `f_character` text,
  `P_habit` text,
  `tolerance` text,
  `quality` text,
  PRIMARY KEY  (`a_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hybrid`
--


/*!40000 ALTER TABLE `hybrid` DISABLE KEYS */;
LOCK TABLES `hybrid` WRITE;
INSERT INTO `hybrid` VALUES ('III-35 vtlc 9','Amelonado x Na 33','Sabah, Malaysia','Self Incomptible','4.03','High Yielder\r\nParental line in hybridization','Base -Obtuse\r\nApex -Short Acuminated\r\nPetiole -Pulvinated\r\nColour of Young Leaf - Purple','Shape -Obovate\r\nBasal Constriction -Slight\r\nApex -Attenuate\r\nSurface -Intense Rugosity\r\nProminence of Ridge & Furrow -Distinct\r\nHardness -Hard\r\nColour Pattern -Green(Immature)to yellow(Ripe)','Intermediate','Susceptible','Fat content(%) -46.8\r\nBean size(g) -1.09'),('III-105 VTLC 8','Amelonado x Pa 7','Sabah, Malaysia','Self Incomptible','2.61','High Yielder\r\nParental line in hybridization','Base -Obtuse\r\nApex -Short Acuminated\r\nPetiole -Pulvinated\r\nColour of Young Leaf - Intermediate','Shape -Obovate\r\nBasal Constriction -Intermediate\r\nApex -Attenuate\r\nSurface -Intermediate\r\nProminence of Ridge & Furrow -Distinct\r\nHardness -Intermediate\r\nColour Pattern -Green(Immature)to yellow(Ripe)','Erect','Susceptible','Fat content(%) -43.03\r\nBean size(g) -0.98'),('I-21 VTLC','Amelonado x Na 33','Landas estate,Malaysia','Self Incomptible & Cross Compatible','3.51','Heavy bearer,parental line for hybridization','Base -Obtuse\r\nApex -Short Acuminated\r\nPetiole -Pulvinated\r\nColour of Young Leaf - purple','Shape -Obovate\r\nBasal Constriction -Intermediate\r\nApex -Obtuse\r\nSurface -Moderate Rugosity\r\nProminence of Ridge & Furrow -Distinct & medium furrow depth\r\nHardness -Moderate Hard\r\nColour Pattern -Green(Immature)to yellow(Ripe)','Erect','Susceptible','Fat content(%) -38.87\r\nBean size(g) -1.03\r\nShelling(%) -0.93'),('I-56 VTLC 2','Pa 7 x Na 32','Malaysia,1968','Self Incomptible ','6.99','Potential high yielder Parental line \r\nLarge no. of beans/pod','Base -Obtuse\r\nApex -Short Acuminated\r\nPetiole -Non-Pulvinated\r\nColour of Young Leaf - Intermediate','Shape -Elliptical\r\nBasal Constriction -Deep\r\nApex -Attenuated\r\nSurface -Rough\r\nProminence of Ridge & Furrow -Slight\r\nHardness -Hard\r\nColour Pattern -Green(Immature)to yellow(Ripe)','Intermediate','Susceptible','Fat content(%) -42.18\r\nBean size(g) -1.20\r\nShelling(%) -91');
UNLOCK TABLES;
/*!40000 ALTER TABLE `hybrid` ENABLE KEYS */;

--
-- Table structure for table `hybrid1`
--

DROP TABLE IF EXISTS `hybrid1`;
CREATE TABLE `hybrid1` (
  `hybrid` varchar(30) NOT NULL default '',
  `plant_no` text,
  `plant_grith` float default NULL,
  `h_first_branch` float default NULL,
  `c_height` float default NULL,
  `c_vol` float default NULL,
  `no_of_branch` int(11) default NULL,
  `p_weight` float default NULL,
  `s_percent` float default NULL,
  `r_percent` float default NULL,
  `pod_value` float default NULL,
  `pod_no` int(11) default NULL,
  `dry_bean_weight` float default NULL,
  PRIMARY KEY  (`hybrid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hybrid1`
--


/*!40000 ALTER TABLE `hybrid1` DISABLE KEYS */;
LOCK TABLES `hybrid1` WRITE;
INSERT INTO `hybrid1` VALUES ('Na 33 x ICS 89','I-18',9,1.51,2.79,12.92,3,15.4,10.64,89.36,29.59,109,1.005);
UNLOCK TABLES;
/*!40000 ALTER TABLE `hybrid1` ENABLE KEYS */;

--
-- Table structure for table `hybrid2`
--

DROP TABLE IF EXISTS `hybrid2`;
CREATE TABLE `hybrid2` (
  `hybrid` varchar(30) NOT NULL default '',
  `p_height` float default NULL,
  `p_girth` float default NULL,
  `height_at_f_branch` float default NULL,
  `c_vol` float default NULL,
  `p_weight` float default NULL,
  `bean_yield` float default NULL,
  `d_b_weight` float default NULL,
  PRIMARY KEY  (`hybrid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hybrid2`
--


/*!40000 ALTER TABLE `hybrid2` DISABLE KEYS */;
LOCK TABLES `hybrid2` WRITE;
INSERT INTO `hybrid2` VALUES ('I-14 x I-56',4.77,42.77,1.81,8.34,21.73,0.939,1.465),('III-35 x IV-20',4.34,45.11,1.53,12.05,11.04,0.9,1.391),('I-56 x IV-20',4.51,47.99,1.62,14.28,13.23,1.193,1.358);
UNLOCK TABLES;
/*!40000 ALTER TABLE `hybrid2` ENABLE KEYS */;

--
-- Table structure for table `hybrid3`
--

DROP TABLE IF EXISTS `hybrid3`;
CREATE TABLE `hybrid3` (
  `hybrid` varchar(30) NOT NULL default '',
  `p_no` text,
  `p_girth` float default NULL,
  `height_at_f_branch` float default NULL,
  `c_height` float default NULL,
  `c_vol` float default NULL,
  `selling_percent` float default NULL,
  `recovery_percent` float default NULL,
  `pod_value` float default NULL,
  `pod_no` int(11) default NULL,
  `pod_bean_wt` float default NULL,
  `wet_dry_bean` float default NULL,
  `dry_bean_yield` float default NULL,
  PRIMARY KEY  (`hybrid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hybrid3`
--


/*!40000 ALTER TABLE `hybrid3` DISABLE KEYS */;
LOCK TABLES `hybrid3` WRITE;
INSERT INTO `hybrid3` VALUES ('ICS 1 x SCA 6','I-14',11.48,1.17,3.12,16.35,15.33,84.67,25,84,9.15,2.15,0.815),('Pa 7 x Na 32','II-87',10.43,0.98,2.82,11.42,7.19,92.81,71.43,93,14.64,3.21,0.763),('IMC 67 x ICS 6','I-23',11.72,1.35,2.9,13.81,9.35,90.65,53.19,8193,14.79,5.27,0.941);
UNLOCK TABLES;
/*!40000 ALTER TABLE `hybrid3` ENABLE KEYS */;

--
-- Table structure for table `ik`
--

DROP TABLE IF EXISTS `ik`;
CREATE TABLE `ik` (
  `nm` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ik`
--


/*!40000 ALTER TABLE `ik` DISABLE KEYS */;
LOCK TABLES `ik` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `ik` ENABLE KEYS */;

--
-- Table structure for table `kau`
--

DROP TABLE IF EXISTS `kau`;
CREATE TABLE `kau` (
  `S_No` int(11) default NULL,
  `Accession_no` varchar(20) NOT NULL default '',
  `Parentage` text,
  `Yr_of_Proc` int(11) default NULL,
  `Planting_mat` text,
  `Origin` text,
  PRIMARY KEY  (`Accession_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kau`
--


/*!40000 ALTER TABLE `kau` DISABLE KEYS */;
LOCK TABLES `kau` WRITE;
INSERT INTO `kau` VALUES (1,'V 1','T 76/1224/1201 Amazon',1986,'Clones','KAU, Vellanikkara, Thrissur'),(2,'V 2','WBE 6/830 WARI series II C',1986,'Clones','KAU'),(3,'V 3','TF 20/19 Amelonado',1986,'Clones','KAU'),(4,'V 4','T 12/613/972 Amazon, Scavina',1986,'Clones','KAU'),(5,'V 5','IMV 60/31',1986,'Clones','KAU'),(6,'V 6','T 72/1559 Nanay Iquitos',1986,'Clones','KAU'),(7,'V 8','T 85/799/233 Amazon',1986,'Clones','KAU'),(8,'V 9','T 79/501/1494 Amazon',1986,'Clones','KAU'),(9,'V 10','T 63/967/61 Amazon',1986,'Clones','KAU'),(10,'V 12','W 41/1768 Trinitario',1986,'Clones','KAU'),(11,'V 13','ICS 1/1037 Amazon',1986,'Clones','KAU'),(12,'V 15','T 16/613/972 Iquitos',1986,'Clones','KAU'),(13,'BE 10','BE 10',1986,'Clones','KAU'),(14,'EQX-2','EQX 2',1986,'Clones','KAU'),(15,'ICS-16','ICS 16',1986,'Clones','KAU'),(17,'IMC-20','IMC 20',1986,'Clones','KAU'),(16,'ICS 100','ICS 100',1986,'Clones','KAU'),(18,'LCT/EEN 162/1010','LCT/EEn 162/1010',1986,'Clones','KAU'),(19,'MAN 15-60','MAN 15-60',1986,'Clones','KAU'),(20,'UF 676','UF 676',1986,'Clones','KAU'),(21,'Pa 56','Pa 56',1986,'Clones','KAU'),(22,'TJ 1','TJ 1',1986,'Clones','KAU'),(23,'EQX 78','EQX 78',1986,'Clones','KAU'),(24,'CC-11','CC-11',1991,'Clones(Buds)','KAU'),(25,'170','-',1996,'clones','KAU'),(26,'171','Amz-3-2',1996,'Clones','KAU'),(27,'174','BE 3',1996,'Clones','KAU'),(28,'179','AEQX 78',1996,'Clones','KAU'),(29,'183','LAF 1',1996,'Clones','KAU'),(30,'186','MAN 15-2',1996,'Clones','KAU'),(31,'190','SC 1',1996,'Clones','KAU'),(32,'192','VF 221',1996,'Clones','KAU'),(33,'198','-',1996,'Clones','KAU'),(35,'V 11','T 48/1716 Criollo',1996,'Clones','KAU'),(37,'218','-',1996,'Clones','KAU'),(38,'220','-',1996,'Clones','KAU'),(39,'223','-',1996,'Clones','KAU'),(40,'152','-',1996,'Clones','KAU'),(41,'243','-',1996,'Clones','KAU'),(42,'254','-',1996,'Clones','KAU'),(43,'267','-',1996,'Clones','KAU'),(44,'268','-',1996,'Clones','KAU');
UNLOCK TABLES;
/*!40000 ALTER TABLE `kau` ENABLE KEYS */;

--
-- Table structure for table `kew`
--

DROP TABLE IF EXISTS `kew`;
CREATE TABLE `kew` (
  `S_no` int(11) default NULL,
  `Accession_no` varchar(30) NOT NULL default '',
  `Parentage` text,
  `Yr_of_proc` int(11) default NULL,
  `Planting_mat` text,
  `Origin` text,
  PRIMARY KEY  (`Accession_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kew`
--


/*!40000 ALTER TABLE `kew` DISABLE KEYS */;
LOCK TABLES `kew` WRITE;
INSERT INTO `kew` VALUES (1,'SIAL 93','SIAL 93',1981,'Clones(Buds)','Kew gardens,England'),(2,'IMC 10','IMC 10',1981,'Clones(Buds)','Kew gardens,England'),(3,'EET 272','EET 272',1981,'Clones(Buds)','Kew gardens,England'),(4,'Na 242','Na 242',1981,'Clones(Buds)','Kew gardens,England'),(4,'MOQ 413','MOQ 413',1981,'Clones(Buds)','Kew gardens,England');
UNLOCK TABLES;
/*!40000 ALTER TABLE `kew` ENABLE KEYS */;

--
-- Table structure for table `kewcollections`
--

DROP TABLE IF EXISTS `kewcollections`;
CREATE TABLE `kewcollections` (
  `No` int(11) default NULL,
  `Accession_No` text,
  `Parentage` text,
  `Year_of_Proc` date default NULL,
  `Planting_mat` text,
  `Origin` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kewcollections`
--


/*!40000 ALTER TABLE `kewcollections` DISABLE KEYS */;
LOCK TABLES `kewcollections` WRITE;
INSERT INTO `kewcollections` VALUES (1,'SIAL 93','SIAL 93','0000-00-00','Clones(Buds)','Kew gardens,England'),(1,'V 1','T 76/1224/1201 Amazon','0000-00-00','Clones','KAU, Vellanikkara, Thrissur');
UNLOCK TABLES;
/*!40000 ALTER TABLE `kewcollections` ENABLE KEYS */;

--
-- Table structure for table `kk`
--

DROP TABLE IF EXISTS `kk`;
CREATE TABLE `kk` (
  `name` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kk`
--


/*!40000 ALTER TABLE `kk` DISABLE KEYS */;
LOCK TABLES `kk` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `kk` ENABLE KEYS */;

--
-- Table structure for table `malaysian`
--

DROP TABLE IF EXISTS `malaysian`;
CREATE TABLE `malaysian` (
  `S_no` int(11) default NULL,
  `Accession_no` varchar(30) NOT NULL default '',
  `Parentage` text,
  `Yr_of_Proc` int(11) default NULL,
  `Planting_mat` text,
  `Origin` text,
  PRIMARY KEY  (`Accession_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `malaysian`
--


/*!40000 ALTER TABLE `malaysian` DISABLE KEYS */;
LOCK TABLES `malaysian` WRITE;
INSERT INTO `malaysian` VALUES (1,'Jaranagau Red Axil-I-14','-',1968,'Seeds','Landas estate,Malaysia'),(2,'Landas 356- II-51','-',1968,'Seeds','Landas estate,Malaysia'),(3,'Landas 358- II-65','-',1968,'Seeds','Landas estate,Malaysia'),(4,'Landas 361- IV-46','-',1968,'Seeds','Landas estate,Malaysia'),(5,'Landas 364- II-67','-',1968,'Seeds','Landas estate,Malaysia'),(6,'Landas 365- II-46','-',1968,'Seeds','Landas estate,Malaysia'),(7,'Landas 357- IV-420','-',1968,'Seeds','Landas estate,Malaysia'),(8,'Amelonado x Pa 7','-',1968,'Seeds','Landas estate,Malaysia'),(9,'Amelonado x Na 33','-',1968,'Seeds','Landas estate,Malaysia'),(10,'Amelonado x Na 32','-',1968,'Seeds','Landas estate,Malaysia'),(11,'Pa 7 x Na 32','-',1968,'Seeds','Landas estate,Malaysia');
UNLOCK TABLES;
/*!40000 ALTER TABLE `malaysian` ENABLE KEYS */;

--
-- Table structure for table `nigerianclones`
--

DROP TABLE IF EXISTS `nigerianclones`;
CREATE TABLE `nigerianclones` (
  `nigerian_clone` varchar(30) NOT NULL default '',
  `stem_diam` float default NULL,
  `hafb` float default NULL,
  `total_ht` float default NULL,
  `no_of_branch` float default NULL,
  `canopy_ht` float default NULL,
  `canopy_vol` float default NULL,
  PRIMARY KEY  (`nigerian_clone`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nigerianclones`
--


/*!40000 ALTER TABLE `nigerianclones` DISABLE KEYS */;
LOCK TABLES `nigerianclones` WRITE;
INSERT INTO `nigerianclones` VALUES ('NC 39/102',10.21,1.35,3.49,2.2,2.15,13.22),('NC 38/119',12.18,1.43,3.77,2,2.35,11.78),('NC 29/63',10.61,1.36,3.4,2,2.04,8.34),('NC 26/73',10.84,1.54,3.65,22,2.11,8.72),('NC 34/113',12.39,1.35,4.03,2.17,2.68,12.52),('NC 40/116',12.73,11.65,4.47,2.1,3.13,22.59),('NC 45/53',11.86,1.65,4.16,2.6,2.51,12.86),('NC 55/8',9.16,1.38,2.89,2,1.52,4.12),('I-14 Clone',11.32,1.4,3.86,2,2.46,12.23),('I-14 Seedling',12.36,1.73,4.78,2.47,3.05,18.37);
UNLOCK TABLES;
/*!40000 ALTER TABLE `nigerianclones` ENABLE KEYS */;

--
-- Table structure for table `observation`
--

DROP TABLE IF EXISTS `observation`;
CREATE TABLE `observation` (
  `s_no` int(11) default NULL,
  `hybrids` varchar(30) NOT NULL default '',
  `stemgirth` float default NULL,
  `hafb` float default NULL,
  `canopy_ht` float default NULL,
  `canopy_vol` float default NULL,
  `dry_bean_yield` float default NULL,
  PRIMARY KEY  (`hybrids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `observation`
--


/*!40000 ALTER TABLE `observation` DISABLE KEYS */;
LOCK TABLES `observation` WRITE;
INSERT INTO `observation` VALUES (1,'ICS1 x SCA 6',11.83,1.57,2.87,14.77,0.952),(2,'ICS1 x SCA 12',11.48,1.17,3.12,16.35,0.815),(3,'Na 31 x ICS 1',11.75,1.07,3,12.32,0.868),(4,'ICS 6 x SCA 6',9.74,1.43,2.38,9.1,1.145),(5,'ICS 6 x SCA 12',11.8,1.35,2.97,13.83,0.952),(6,'ICS 6 x Na 33',11.67,1.16,2.84,12.93,0.846),(7,'IMC 67 X ICS 6',11.72,1.35,2.9,13.81,0.941),(8,'Na 31 x ICS 6',11.92,1.23,3.06,16.8,0.869),(9,'ICS89 x SCA 6',12.15,1.38,2.83,14.36,0.855),(10,'Pa7 x Na 32',10.43,0.98,2.82,11.42,0.763),(11,'Amel. x Pa7',9.8,1.03,2.45,7.22,0.824),(12,'Amel. x Na 32',9.82,1.17,2.52,8.68,0.834),(13,'Amel. x Na33',10.89,1.09,2.49,10.38,1.082),(14,'Check',11.15,1.22,2.73,12.87,0.904);
UNLOCK TABLES;
/*!40000 ALTER TABLE `observation` ENABLE KEYS */;

--
-- Table structure for table `tab`
--

DROP TABLE IF EXISTS `tab`;
CREATE TABLE `tab` (
  `tabname` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tab`
--


/*!40000 ALTER TABLE `tab` DISABLE KEYS */;
LOCK TABLES `tab` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `tab` ENABLE KEYS */;

--
-- Table structure for table `table1`
--

DROP TABLE IF EXISTS `table1`;
CREATE TABLE `table1` (
  `name` text,
  `age` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `table1`
--


/*!40000 ALTER TABLE `table1` DISABLE KEYS */;
LOCK TABLES `table1` WRITE;
INSERT INTO `table1` VALUES ('sooraj',24),('sujeesh',24);
UNLOCK TABLES;
/*!40000 ALTER TABLE `table1` ENABLE KEYS */;

--
-- Table structure for table `tableinfo`
--

DROP TABLE IF EXISTS `tableinfo`;
CREATE TABLE `tableinfo` (
  `att` text,
  `tp` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tableinfo`
--


/*!40000 ALTER TABLE `tableinfo` DISABLE KEYS */;
LOCK TABLES `tableinfo` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `tableinfo` ENABLE KEYS */;

--
-- Table structure for table `test`
--

DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `treatments` text,
  `girth` text,
  `hafb` text,
  `can` text,
  `can1` text,
  `noof` text,
  `pruning` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test`
--


/*!40000 ALTER TABLE `test` DISABLE KEYS */;
LOCK TABLES `test` WRITE;
INSERT INTO `test` VALUES ('Na 33 x ICS 89','a','b','c','d','e','f');
UNLOCK TABLES;
/*!40000 ALTER TABLE `test` ENABLE KEYS */;

--
-- Table structure for table `uk`
--

DROP TABLE IF EXISTS `uk`;
CREATE TABLE `uk` (
  `S_no` int(11) default NULL,
  `Accession_no` varchar(30) NOT NULL default '',
  `Parentage` text,
  `Yr_of_proc` int(11) default NULL,
  `Plant_Mat` text,
  `Origin` text,
  PRIMARY KEY  (`Accession_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uk`
--


/*!40000 ALTER TABLE `uk` DISABLE KEYS */;
LOCK TABLES `uk` WRITE;
INSERT INTO `uk` VALUES (1,'EC 478229,Amaz.12','-',2002,'Clones','Reading University,UK'),(2,'EC 478230,EET 397','-',2002,'Clones','Reading University,UK'),(3,'EC 478232, IMC 6','-',2002,'Clones','Reading University,UK'),(4,'EC 478234, Pa 56','-',2002,'Clones','Reading University,UK'),(5,'EC 478235, REDAMEL','-',2002,'Clones','Reading University,UK'),(6,'EC 478236, RIM 10','-',2002,'Clones','Reading University,UK'),(7,'EC 478238, UF 11','-',2002,'Clones','Reading University,UK'),(8,'EC 478239, UF 221','-',2002,'Clones','Reading University,UK'),(9,'EC 478240, UF667','-',2002,'Clones','Reading University,UK');
UNLOCK TABLES;
/*!40000 ALTER TABLE `uk` ENABLE KEYS */;

--
-- Table structure for table `wynad`
--

DROP TABLE IF EXISTS `wynad`;
CREATE TABLE `wynad` (
  `S_no` int(11) default NULL,
  `Accession_no` varchar(30) NOT NULL default '',
  `Parentage` text,
  `Yr_of_proc` int(11) default NULL,
  `Plant_Mat` text,
  `Origin` text,
  PRIMARY KEY  (`Accession_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wynad`
--


/*!40000 ALTER TABLE `wynad` DISABLE KEYS */;
LOCK TABLES `wynad` WRITE;
INSERT INTO `wynad` VALUES (1,'Wynad 1','-',1997,'Clones','Farmer\'s garden,Wynad'),(2,'Wynad 2','-',1997,'Clones','Farmer\'s garden,Wynad'),(3,'Wynad 3','-',1997,'Clones','Farmer\'s garden,Wynad'),(4,'Wynad 4','-',1997,'Clones','Farmer\'s garden,Wynad'),(5,'Wynad 5','-',1997,'Clones','Farmer\'s garden,Wynad'),(6,'Wynad 6','-',1997,'Clones','Farmer\'s garden,Wynad'),(7,'Wynad 7','-',1997,'Clones','Farmer\'s garden,Wynad'),(8,'Wynad 8','-',1997,'Clones','Farmer\'s garden,Wynad'),(9,'Wynad 9','-',1997,'Clones','Farmer\'s garden,Wynad'),(10,'Wynad 10','-',1997,'Clones','Chundale garden, Wynad'),(11,'Wynad 11','-',1997,'Clones','Chundale garden, Wynad'),(12,'Wynad 12','-',1997,'Clones','Chundale garden, Wynad'),(13,'Wynad 13','-',1997,'Clones','Chundale garden, Wynad'),(14,'Criollo','-',1997,'Clones','Kallar Fruit Research Station');
UNLOCK TABLES;
/*!40000 ALTER TABLE `wynad` ENABLE KEYS */;

--
-- Table structure for table `yield`
--

DROP TABLE IF EXISTS `yield`;
CREATE TABLE `yield` (
  `crosses` text,
  `plant_no` varchar(30) NOT NULL default '',
  `shelling_percent` float default NULL,
  `recovery_percent` float default NULL,
  `podvalue` float default NULL,
  `pod_no_maxim` int(11) default NULL,
  `pooled_dry_bean` float default NULL,
  PRIMARY KEY  (`plant_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `yield`
--


/*!40000 ALTER TABLE `yield` DISABLE KEYS */;
LOCK TABLES `yield` WRITE;
INSERT INTO `yield` VALUES ('Na 33 X ICS 89','I-18',10.64,89.36,29.59,109,1.005),('Na 33 X ICS 89','IV-440',8.44,91.56,32.47,110,1.1),('SCA 6 x IMC 67','I-78',8.11,9189,38.76,124,0.965),('SCA 6 x IMC 67','I-106',5.53,94.47,36.5,115,0.731),('SCA 6 x IMC 67','III-400',13.41,86.59,40,109,0.825),('Na 31 x ICS 89','IV-478',11.29,88.71,37.71,116,0.787),('SCA 6 x ICS 6','I-38',7.65,92.35,36.76,119,0.934);
UNLOCK TABLES;
/*!40000 ALTER TABLE `yield` ENABLE KEYS */;

--
-- Table structure for table `yieldattributes`
--

DROP TABLE IF EXISTS `yieldattributes`;
CREATE TABLE `yieldattributes` (
  `clones` varchar(30) NOT NULL default '',
  `no_of_beans` float default NULL,
  `single_pod` float default NULL,
  `seed_wt` float default NULL,
  `bean_pod` float default NULL,
  `dry_bean_wet_bean` float default NULL,
  `pod_value` float default NULL,
  PRIMARY KEY  (`clones`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `yieldattributes`
--


/*!40000 ALTER TABLE `yieldattributes` DISABLE KEYS */;
LOCK TABLES `yieldattributes` WRITE;
INSERT INTO `yieldattributes` VALUES ('NC 39/102',41.8,0.374,0.928,24.3,43.44,26.03),('NC 38/119',37.6,0.371,1.068,27,38.47,26.2),('NC 26/73',40.3,0.307,0.889,28.9,40.26,28.18),('NC 29/63',41.7,0.333,0.96,30.4,40.44,25.04),('NC 34/113',44.5,0.481,1.121,24.6,42.22,20.08),('NC 40/116',38.9,0.479,1.32,22.9,40.2,22.85),('NC 45/53',36.7,0.321,0.874,24,41.86,31.48),('NC 55/8',39.6,0.352,0.854,25,38.36,30.21),('I-14 clones',39.6,0.388,1.029,22.8,46.73,24.7),('I-14 seedlings',42.3,0.393,0.92,26.6,37.76,26.3);
UNLOCK TABLES;
/*!40000 ALTER TABLE `yieldattributes` ENABLE KEYS */;
/*!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 */;

