SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;

/*!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 */;


CREATE DATABASE /*!32312 IF NOT EXISTS*/ `arecadb`;
USE `arecadb`;
CREATE TABLE `indisland` (
  `acc_no` text,
  `acc_name` text,
  `scientific_name` text,
  `place_coll` text,
  `year_acq` int(11) default NULL,
  `poll_group` text,
  `growth_habit` text,
  `suckering_habit` text,
  `crown_shape` text,
  `average_year` float default NULL,
  `colour_ripenuts` text,
  `shape_ripenuts` text,
  `pot_yeild` float default NULL,
  `average_yeild` float default NULL,
  `add_inf` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `indisland` (`acc_no`,`acc_name`,`scientific_name`,`place_coll`,`year_acq`,`poll_group`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('VTL-29-I','Andaman-I','Areca catechu L.','Andaman Islands',1964,'Cross Pollinated','Semi Tall','Non suckering','Partially drooping',2.5,'Orange yellow','Oval to round',3.2,2.62,'-\r'),('VTL-29-II','Andaman-II','Areca catechu L.','Andaman Islands',1964,'Cross Pollinated','Semi Tall','Non suckering','Partially drooping',3,'Orange yellow','Oblong',3.86,2.56,'-\r'),('VTL-30','Calicut-1','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',3,'Orange yellow','Oval',3.85,3.08,'-\r'),('VTL-31','Calicut-2','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',2.6,'Yellow','Oval to round',3.97,3.1,'-\r'),('VTL-32','Calicut-4','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',3.15,'Yellow','Oval to oblong',4.27,3.62,'-\r'),('VTL-34','Calicut-6','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',3.16,'Orange red','Oval to round',2.85,2.54,'-\r');
INSERT INTO `indisland` (`acc_no`,`acc_name`,`scientific_name`,`place_coll`,`year_acq`,`poll_group`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('VTL-35','Calicut-7','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',3.05,'Orange ','Oval to oblong',3.56,3.1,'-\r'),('VTL-36','Calicut-10','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping to errect',3.28,'Orange ','Oval to oblong',3.01,2.68,'-\r'),('VTL-40','Calicut-29','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',3.2,'Orange ','Oval to oblong',2.85,2.17,'-\r'),('VTL-41','Calicut-32','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',3.55,'Orange yellow','Oval to round',3.48,2.92,'-\r'),('VTL-42','Calicut-33','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',2.75,'Orange yellow','Oblong',3.37,2.81,'-\r'),('VTL-44','SCRDTC-18','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',2.65,'Orange ','Oval to oblong',2.81,1.88,'-\r');
INSERT INTO `indisland` (`acc_no`,`acc_name`,`scientific_name`,`place_coll`,`year_acq`,`poll_group`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('VTL-45','SCRDTC-43','Areca catechu L.','Andaman Islands',1982,'Cross pollinated','Tall','Non suckering','Partially drooping',2.9,'Orange ','Oval to oblong',3.43,2.71,'-\r');
CREATE TABLE `indmainsland` (
  `acc_no` text,
  `acc_name` text,
  `scientific_name` text,
  `place_coll` text,
  `year_acq` int(11) default NULL,
  `poll_group` text,
  `growth_habit` text,
  `suckering_habit` text,
  `crown_shape` text,
  `average_year` float default NULL,
  `colour_ripenuts` text,
  `shape_ripenuts` text,
  `pot_yeild` float default NULL,
  `average_yeild` float default NULL,
  `add_inf` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `indmainsland` (`acc_no`,`acc_name`,`scientific_name`,`place_coll`,`year_acq`,`poll_group`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('VTL-53','Thirthahalli (over lapping)','Areca catechu L.','Thirthahalli (Karnataka)',1964,'Cross Pollinated','Tall','Non suckering','Partially drooping',3.15,'Orange yellow','Oval and small',4.03,3.17,'-\r'),('VTL-56','Hirehalli Dwarf','Areca catechu L.','Tumkur (Karnataka)',1964,'Cross Pollinated','Dwarf ','Non suckering','Erect',2.67,'Orange Red','Round',1.12,0.65,'Dwarfing character\r'),('VTL-61','Dapoli','Areca catechu L.','Maharashtra',1982,'Cross Pollinated','Tall','Non suckering','Partially drooping',3.1,'Yellow','Oval to round',3.81,2.83,'-\r');
CREATE TABLE `released` (
  `name_variety` text,
  `acc_no` text,
  `count_coll` text,
  `sci_name` text,
  `poll_group` text,
  `year_released` int(11) default NULL,
  `rec_re` text,
  `growth_habit` text,
  `suc_habit` text,
  `crown_shape` text,
  `averages_bunch` text,
  `colour_ripe` text,
  `shape_ripe` text,
  `pot_yeild` float default NULL,
  `average_yeild` float default NULL,
  `add_inf` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `released` (`name_variety`,`acc_no`,`count_coll`,`sci_name`,`poll_group`,`year_released`,`rec_re`,`growth_habit`,`suc_habit`,`crown_shape`,`averages_bunch`,`colour_ripe`,`shape_ripe`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('Mangala','VTL-3','China','Areca catechu L.','Cross pollinated',1972,'Coastal region of Karnataka and Kerala','Semi tall ','Non suckering','Partially drooping','4.50','Orange yellow ','Oval',4.65,3,'Early bearing habit\r'),('Sumangala','VTL-11','Indonesia-VI','Areca catechu L.','Cross pollinated',1985,'Areca growing tracts in Karnataka and Kerala','Tall ','Non suckering','Partially drooping','4.44','Orange yellow ','Oval',5.13,3.3,'High chali recovery\r'),('Sreemangala','VTL-17','Singapore','Areca catechu L.','Cross pollinated',1985,'Karnataka ,Kerala Maharastra and Tamil Nadu','Tall ','Non suckering','Partially drooping','4.00','Deep yellow','Round to Bold',4.35,3.18,'-\r'),('Mohitnagar','VTL-60','Mohitnagar','Areca catechu L.','Cross pollinated',1991,'Karnataka ,Kerala Maharastra and West Bengal','Tall ','Non suckering','Partially drooping','4.67','Orange yellow ','Oval',5.63,3.67,'Uniformity in bearing\r'),('SAS-I','VTL-52','Sirsi (Karnataka)','Areca catechu L.','Cross pollinated',1995,'Sirsi hill zone of Karnataka','Tall ','Non suckering','Compact canopy','4.00','Orange yellow ','Oval',5.6,4.6,'-\r');
INSERT INTO `released` (`name_variety`,`acc_no`,`count_coll`,`sci_name`,`poll_group`,`year_released`,`rec_re`,`growth_habit`,`suc_habit`,`crown_shape`,`averages_bunch`,`colour_ripe`,`shape_ripe`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('Calicut-17','VTL-37','Andaman Islands','Areca catechu L.','Cross pollinated',1995,'Andaman and Nicobar group of Islands','Tall ','Non suckering','Partially drooping','3.65','Orange yellow','Oval',4.6,3.98,'Large size fruits'),('Saigon/Subhamangala','VTL-12','Saigon-I','Areca catechu L.','Cross pollinated',0,'Irrigated  areas of Karnataka and Kerala','Semi tall to tall','Non suckering','Partially drooping','3.90','Orange to deep yellow','Oblong to round',6.28,3.88,'-\r');
CREATE TABLE `traditional` (
  `name_cultivar` text,
  `acc_no` text,
  `scientific_name` text,
  `poll_group` text,
  `area_adapt` text,
  `growth_habit` text,
  `suckering_habit` text,
  `crown_shape` text,
  `average_year` float default NULL,
  `colour_ripenuts` text,
  `shape_ripenuts` text,
  `pot_yeild` float default NULL,
  `average_yeild` float default NULL,
  `add_inf` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `traditional` (`name_cultivar`,`acc_no`,`scientific_name`,`poll_group`,`area_adapt`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('South Kanara local','VTL-47','Areca catechu L.','Cross pollinated','Dakshina Kannada district of Karnataka and Kasaragod district of Kerala','Tall ','Non suckering','Partially drooping',3.02,'Orange red','Oval to round',3.48,2.6,'Regular bearer with large size fruits\r'),('Sreewardhan-I','VTL-62','Areca catechu L.','Cross pollinated','Konkan Region, Raigad and Rathnagiri districts of Maharashtra ','Semi Tall to Tall ','Non suckering','Partially drooping to erect',2.24,'Orange yellow','Oval to round',3.65,2.2,'Larger endosperm and tastier than other varieties\r'),('Thirthahalli','VTL-48','Areca catechu L.','Cross pollinated','Malnad areas of Shimoga and Chickamagalur districts of Karnataka','Tall ','Non suckering','Partially drooping',3.56,'Orange yellow','Oval to round',4.17,3.48,'Greater number of fruits per bunch\r'),('Sagar','VTL-49','Areca catechu L.','Cross pollinated','Shimoga and Uttara Kannada districts of Karnataka','Tall ','Non suckering','Partially drooping',2.48,'Orange yellow','Round',3.77,2.85,'-\r');
INSERT INTO `traditional` (`name_cultivar`,`acc_no`,`scientific_name`,`poll_group`,`area_adapt`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('Hirehalli Tall','VTL-55','Areca catechu L.','Cross pollinated','Tumakur, Mandya and parts of Hassan and Bangalore districts of Karnataka','Tall ','Non suckering','Partially drooping',3.5,'Deep yellow','Medium , Round to Oval',3.9,3.2,'-\r');
CREATE TABLE `exotic` (
  `acc_no` text,
  `acc_name` text,
  `country_colect` text,
  `scientific_name` text,
  `year_acq` int(11) default NULL,
  `poll_group` text,
  `growth_habit` text,
  `suckering_habit` text,
  `crown_shape` text,
  `average_year` float default NULL,
  `colour_ripenuts` text,
  `shape_ripenuts` text,
  `pot_yeild` float default NULL,
  `average_yeild` float default NULL,
  `add_inf` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `exotic` (`acc_no`,`acc_name`,`country_colect`,`scientific_name`,`year_acq`,`poll_group`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('VTL-14','Saigon-III','Saigon','Areca catechu L.',1961,'Cross Pollinated','Semi Tall','Non suckering','Partially drooping',2.4,'Orange','Oval',3.96,2.81,'-\r'),('VTL-18-I','Br.Sol.Islands-I','British Soloman Islands ','Areca catechu L.',1959,'Cross Pollinated','Semi Tall','Non suckering','Partially drooping',3.22,'Orange Yellow','Oval',4.74,3.42,'-\r'),('VTL-21','Srilanka-III','Srilanka','Areca concinna Thw.',1961,'Cross pollinated','Dwarf to semitall','Suckering (5 to 6 suckers)','Drooping ',13,'Red','Oblong',0.97,0.69,'-\r'),('VTL-23','Australia','Australia (Brisbane)','Areca normanbyii',1963,'Cross pollinated','Semi Tall','Non suckering','Drooping',3.2,'Red','Pear shaped',2.2,1.43,'-\r'),('VTL-26','Fiji-II','Fiji Islands (Suva)','Areca catechu L.',1959,'Cross Pollinated','Semi tall to Tall','Non suckering','Partially drooping',3.57,'Orange','Oblong',4.83,2.65,'-\r'),('VTL-27','Saigon-IV','Saigon','Actinorhytis calapparia',1964,'Cross Pollinated','Tall','Non suckering','Drooping (Spreading)',2.86,'Pinkish Red','Oval to bold',5.31,3.28,'Fruits have medicinal value\r');
INSERT INTO `exotic` (`acc_no`,`acc_name`,`country_colect`,`scientific_name`,`year_acq`,`poll_group`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('VTL-28-I','Saigon-V','Saigon ','Areca catechu L.',1964,'Cross Pollinated','Tall','Non suckering','Partially drooping',3.35,'Orange to yellow','Oval to elongated',4.24,3.58,'-\r'),('VTL-28-II','Saigon-VI','Saigon ','Areca catechu L.',1964,'Cross Pollinated','Semi tall','Non suckering','Partially drooping',2.57,'Orange ','Oblong',2.79,2.22,'-\r'),('VTL-28-III','Saigon-VII','Saigon ','Areca catechu L.',1964,'Cross Pollinated','Semi tall','Non suckering','Partially drooping',3.3,'Orange ','Oval',5.24,3.69,'-'),('VTL-2','Mauritius','Mauritius','Areca triandra Roxb.',1961,'Cross Pollinated','Semi tall to Tall','Suckering','Partially drooping',9.5,'Pinkish red','Oblong',1.2,0.68,'-\r'),('VTL-6','Indonasia-I','Indonasia','Areca triandra Roxb.',1961,'Cross Pollinated','Semi tall to Tall','Suckering','Drooping',11.25,'Red','Oblong',1.32,0.8,'-\r'),('VTL-7','Indonasia-II','Indonasia','Areca triandra Roxb.',1964,'Cross Pollinated','Semi tall ','Suckering','Partially drooping',2.43,'Red','Oblong',0.9,0.52,'-\r');
INSERT INTO `exotic` (`acc_no`,`acc_name`,`country_colect`,`scientific_name`,`year_acq`,`poll_group`,`growth_habit`,`suckering_habit`,`crown_shape`,`average_year`,`colour_ripenuts`,`shape_ripenuts`,`pot_yeild`,`average_yeild`,`add_inf`) VALUES ('VTL-9','Indonasia-IV','Indonasia','Areca catechu L.',1959,'Cross Pollinated','Semi tall to Tall','Non suckering','Partially drooping',2.37,'Orange','Oval',3.3,2.36,'-\r'),('VTL-13','Saigon-II','Saigon','Areca catechu L.',1961,'Cross Pollinated','Tall','Non suckering','Partially drooping',3.2,'Orange','Oblong to round',3.89,2.81,'-');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;