riceCalcDB.sql

CREATE DATABASE  IF NOT EXISTS `ricecalcdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `ricecalcdb`;
-- MySQL dump 10.13  Distrib 5.6.11, for Win32 (x86)
--
-- Host: localhost    Database: ricecalcdb
-- ------------------------------------------------------
-- Server version	5.5.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 */;
/*!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 `irri_users`
--

DROP TABLE IF EXISTS `irri_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `irri_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(200) NOT NULL,
  `contact` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `irri_users`
--

LOCK TABLES `irri_users` WRITE;
/*!40000 ALTER TABLE `irri_users` DISABLE KEYS */;
INSERT INTO `irri_users` VALUES (1,'hello','7d793037a0760186574b0282f2f435e7','hello','world','helloworld@localhost','09999999999'),(3,'diony','c7d6b104c0de626eec6ff23c6fd454a5','Diony','Guillen','dionyfguillen@gmail.com','099999999'),(4,'dionyfguillen','5f7709310d6dea18e0407594b065b3c9','Diony','Guillen','me@dionyfguillen.info','+639065130480');
/*!40000 ALTER TABLE `irri_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rice_varieties`
--

DROP TABLE IF EXISTS `rice_varieties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rice_varieties` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ecosystem` varchar(200) NOT NULL,
  `variety` varchar(200) NOT NULL,
  `lineDesignation` varchar(200) NOT NULL,
  `yearApproved` int(5) NOT NULL,
  `breedingInstitution` varchar(50) NOT NULL,
  `averageYield` float NOT NULL,
  `maxYield` float NOT NULL,
  `maturity` int(10) NOT NULL,
  `height` int(100) NOT NULL,
  `tillers` int(255) NOT NULL,
  `blast` varchar(50) NOT NULL,
  `blb` varchar(50) NOT NULL,
  `tungro` varchar(50) NOT NULL,
  `bph` varchar(50) NOT NULL,
  `glh` varchar(50) NOT NULL,
  `stemborerDH` varchar(50) NOT NULL,
  `stemborerDHWSB` varchar(50) NOT NULL,
  `deadheartswhiteWSB` varchar(50) NOT NULL,
  `YSB` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rice_varieties`
--

LOCK TABLES `rice_varieties` WRITE;
/*!40000 ALTER TABLE `rice_varieties` DISABLE KEYS */;
INSERT INTO `rice_varieties` VALUES (1,'COOL ELEVATED','PSB Rc44 (GOHANG)','IR59469-B-B-3-2',1995,'IRRI',4.1,5.7,144,98,16,'I','S','S','S','-','R','-','-','-'),(2,'COOL ELEVATED','PSB Rc46 (SUMADEL)','IR25976-12-2-2-2-1-1',1995,'IRRI',4.3,5.8,135,98,13,'I','I','-','MS','I','-','-','-','-'),(3,'COOL ELEVATED','PSB Rc92 (SAGADA)','IR9202-25-1-3',2001,'IRRI',3.6,6.7,131,94,15,'S','S','I/S','I','S','-','-','-','-'),(4,'COOL ELEVATED','PSB Rc94 (HUNGDUAN)','IR61336-4B-14-3-2',2001,'IRRI',3.3,8.6,133,80,16,'S','S','S','I','S','-','-','-','-'),(5,'COOL ELEVATED','PSB Rc96 (IBULAO)','IR61608-3B-20-2-2-1-1',2001,'IRRI',3.6,5.3,136,80,16,'S','S','S','MR','S','-','-','-','-'),(6,'COOL ELEVATED','NSIC Rc104 (BALILI)','PR26770-PJ2',2001,'PHILRICE',4.3,6.3,154,93,16,'I','I','S','I','MS','S','-','-','-'),(7,'SALINE PRONE IRRIGATED LOWLAND','PSB Rc48 (HAGONOY)','IR9884-54-3-IE-PI',1995,'IRRI',2.7,5.3,126,88,19,'S','I','S','S','I','-','-','-','-'),(8,'SALINE PRONE IRRIGATED LOWLAND','PSB Rc50 (BICOL)','IR51500-AC11-1',1995,'IRRI',3,4.3,118,90,18,'S','R','S','I','-','R','-','-','-'),(9,'SALINE PRONE IRRIGATED LOWLAND','PSB Rc84 (SIPOCOT)','IR65185-3B-8-3-2',2000,'IRRI',2,3.7,111,77,19,'S','I','S','MR','MS','I','-','-','-'),(10,'SALINE PRONE IRRIGATED LOWLAND','PSB Rc86 (MATNOG)','IR65195-3B-8-2-3',2000,'IRRI',2.1,4.3,113,82,16,'S','I','S','MR','MS','MS','-','-','-'),(11,'SALINE PRONE IRRIGATED LOWLAND','PSB Rc88 (NAGA)','IR52713-2B-8-2B-1-2',2000,'IRRI',2.2,7,116,88,17,'I','S','S','I','-','I','-','-','-'),(12,'SALINE PRONE IRRIGATED LOWLAND','PSB Rc90 (BUGUEY)','PR25989-2-4B',2001,'PHILRICE',3.4,4.2,124,86,16,'I','S','S','MS','MS','-','-','-','-'),(13,'SALINE PRONE IRRIGATED LOWLAND','NSIC Rc106 (SUMILAO)','IR61920-3B-22-1-1',2001,'IRRI',2.9,4.8,117,77,14,'I','S','S','MS','MS','R','-','-','-'),(14,'SALINE PRONE IRRIGATED LOWLAND','NSIC Rc108 (ANAHAWAN)','PR26008-8-4B',2001,'PHILRICE',2.9,3.8,128,85,15,'I','S','S','MS','MS','MR','-','-','-'),(15,'SALINE PRONE IRRIGATED LOWLAND','NSIC Rc182 (SALINAS 1)','IR63307-4B-4-3',2009,'IRRI',2.8,5.7,113,86,13,'S','I','S','MS','S','(MR)','-','-','-'),(16,'SALINE PRONE IRRIGATED LOWLAND','NSIC Rc184 (SALINAS 2)','PR26016-16-B-B-B',2009,'PHILRICE',3.1,6.3,120,87,14,'R','I','S','MS','MS','(R)','-','-','-'),(17,'SALINE PRONE IRRIGATED LOWLAND','NSIC Rc186 (SALINAS 3)','PR30244-AC-V2',2009,'PHILRICE',3.1,4.2,115,84,15,'S','S','S','MS','MS','(MS)','-','-','-'),(18,'SALINE PRONE IRRIGATED LOWLAND','NSIC Rc188 (SALINAS 4)','PR28524-AC97-55',2009,'PHILRICE',3.2,3.8,114,81,15,'I','S','S','MS','MS','(I)','-','-','-'),(19,'SALINE PRONE IRRIGATED LOWLAND','NSIC Rc190 (SALINAS 5)','PR25997-B-B-B',2009,'PHILRICE',2.9,5.1,120,86,14,'I','I','S','MS','I','(MS)','-','-','-'),(20,'UPLAND','PSB Rc1 (MAKILING)','IR10147-113-5-1-1-1-5',1990,'IRRI',2.4,3.9,121,104,45,'R','I','S','MS','-','MR','-','-','-'),(21,'UPLAND','PSB Rc3 (GINILINGAN PUTI)','GINILINGAN PUTI',1997,'Trad. Variety',2.9,6,123,106,83,'R','I','S','I','S','I','-','-','-'),(22,'UPLAND','PSB Rc5 (ARAYAT)','IR47686-30-3-2',1997,'IRRI',2.9,4.2,122,104,89,'R','I','S','S','S','S','-','-','-'),(23,'UPLAND','PSB Rc7 (BANAHAW)','PR23336-10',2001,'PHILRICE',2.9,4,121,119,75,'R','I','S','MS','S','I','-','-','-'),(24,'UPLAND','NSIC Rc9 (APO)','IR55423-1',2001,'IRRI',2.9,5.5,119,98,79,'I','I','S','MS','S','MR','-','-','-'),(25,'UPLAND','NSIC Rc11 (CANLAON)','PR23722-20',2001,'PHILRICE',2.6,4.9,125,104,75,'I','I','S','S','S','R','-','-','-'),(26,'IRRIGATED LOWLAND','PSB Rc2  (NAHALIN)','IR32809-26-3-3',1991,'IRRI',5.1,7.1,123,99,15,'I','I','R','MR','MR','I','-','-','-'),(27,'IRRIGATED LOWLAND','PSB Rc4 (MOLAWIN)','IR41985-111-3-2-2',1991,'IRRI',4.6,6.1,104,81,17,'R','I','I','MS','MR','I','-','-','-'),(28,'IRRIGATED LOWLAND','PSB Rc6 (CARRANGLAN)','MRC19390-1215',1992,'PHILRICE',5.2,6.8,112,84,14,'I','I','I','S','I','MR','-','-','-'),(29,'IRRIGATED LOWLAND','PSB Rc8 (TALAVERA)','MRC19399-1224',1992,'PHILRICE',5,7.1,108,82,13,'I','I','I','S','I','MR','-','-','-'),(30,'IRRIGATED LOWLAND','PSB Rc10 (PAGSANJAN)','IR50404-57-2-2-3',1992,'IRRI',4.8,7.5,106,77,16,'R','I','I','R','MR','I','-','-','-'),(31,'IRRIGATED LOWLAND','PSB Rc18 (ALA)','IR51672-62-1-1-2-3',1994,'IRRI',5.1,8.1,123,102,15,'I','I','I','I','I','MS','-','-','-'),(32,'IRRIGATED LOWLAND','PSB Rc20 (CHICO)','IR57301-195-3-3',1994,'IRRI',4.9,7.1,111,86,16,'I','I','I','I','I','I','-','-','-'),(33,'IRRIGATED LOWLAND','PSB Rc22 (LILIW)','C3098-41-1-1',1994,'UPLB',5,7.2,129,96,15,'I','I','I','I','I','S','-','-','-'),(34,'IRRIGATED LOWLAND','PSB Rc28 (AGNO)','IR56381-139-2-2',1995,'IRRI',5,7.6,111,93,16,'R','I','I','I','I','I','-','-','-'),(35,'IRRIGATED LOWLAND','PSB Rc30 (AGUS)','IR58099-41-2-3',1995,'IRRI',5,8,118,88,16,'I','I','I','I','I','I','-','-','-'),(36,'IRRIGATED LOWLAND','PSB Rc32 (JARO)','C3563-B-5-1',1995,'UPLB',5.2,8.8,112,94,16,'I','R','I','R','I','S','-','-','-'),(37,'IRRIGATED LOWLAND','PSB Rc34 (BURDAGOL)','BURDAGOL',1995,'Trad. Variety',4.8,10.3,124,101,16,'R','R','I','R','I','I','-','-','-'),(38,'IRRIGATED LOWLAND','PSB Rc52 (GANDARA)','IR59682-132-1-1-2',1997,'IRRI',5.3,5.3,115,86,16,'I','I','I','I','I','I','-','-','-'),(39,'IRRIGATED LOWLAND','PSB Rc54 (ABRA)','IR60819-34-2-1',1997,'IRRI',5,6.6,113,91,15,'R','I','I','I','I','I','-','-','-'),(40,'IRRIGATED LOWLAND','PSB Rc56 (DAPITAN)','PR23416-34',1997,'PHILRICE',5.3,7.5,114,88,17,'I','I','I','I','I','I','-','-','-'),(41,'IRRIGATED LOWLAND','PSB Rc58 (MAYAPA)','C2732-10-2-1-1-1',1997,'UPLB',4.9,7.3,124,93,14,'I','R','S','I','I','I','-','-','-'),(42,'IRRIGATED LOWLAND','PSB Rc64 (KABACAN)','IR59552-21-3-2-2',1997,'IRRI',5,8.9,124,96,14,'I','I','I','I','I','I','-','-','-'),(43,'IRRIGATED LOWLAND','PSB Rc66 (AGUSAN)','PR23426-66',1997,'PHILRICE',5.2,10.2,123,90,17,'I','R','I','I','I','MS','-','-','-'),(44,'IRRIGATED LOWLAND','PSB Rc74 (AKLAN)','C3559-B-18-3-2-1-1',1998,'UPLB',5.2,8.3,114,92,15,'S','I','S','MR','R','MR','-','-','-'),(45,'IRRIGATED LOWLAND','PSB Rc78 (PAMPANGA)','PR26305-M32',2000,'PHILRICE',5,9.5,111,94,15,'I','R','S','MS','MS','I','-','-','-'),(46,'IRRIGATED LOWLAND','PSB Rc80 (PASIG)','IR62141-114-3-2-2-2',2000,'IRRI',5,8.7,112,92,14,'I','I','S','I','MS','I','-','-','-'),(47,'IRRIGATED LOWLAND','PSB Rc82 (PE?ARANDA)','IR64683-87-2-2-3-3',2000,'IRRI',5.4,12,110,100,15,'R','I','S','I','MS','I','-','-','-'),(48,'IRRIGATED LOWLAND','IR69726-29-1-2-2-2 (MATATAG2)','IR69726-29-1-2-2-2',2001,'IRRI',4.4,7.6,116,105,13,'I','I','R/S','MR','I','MR','-','-','-'),(49,'IRRIGATED LOWLAND','NSIC Rc110 (TUBIGAN 1)','IR71606-1-1-4-2-3-1-2',2002,'IRRI',4.8,6.6,113,91,14,'I','I','I','MS','S','I','-','-','-'),(50,'IRRIGATED LOWLAND','NSIC Rc112 (TUBIGAN 2)','IR72102-4-159-1-3-3-3',2002,'IRRI',4.6,7.3,111,92,14,'I','I','S','I','I','I','-','-','-'),(51,'IRRIGATED LOWLAND','IR73885-1-4-3-2-1-6 (MATATAG 9)','IR73885-1-4-3-2-1-6',2002,'IRRI',4.3,5.7,115,102,14,'I','I','R','MS','I','MR','-','-','-'),(52,'IRRIGATED LOWLAND','NSIC Rc118 (MATATAG 3)','IR68305-18-1-1',2003,'IRRI',4.6,6.7,107,95,14,'I','I','I','S','S','S','-','-','-'),(53,'IRRIGATED LOWLAND','NSIC Rc120 (MATATAG 6)','LF-31-28-1',2003,'PHILRICE',4.8,6.6,109,91,15,'I','I','R','MR','MR','MR','-','-','-'),(54,'IRRIGATED LOWLAND','NSIC Rc122 (ANGELICA)','IR61979-138-1-3-2-3',2003,'IRRI',4.7,8.9,121,106,14,'R','I','I','I','I','R','-','-','-'),(55,'IRRIGATED LOWLAND','NSIC Rc128 (MABANGO 1)  (A)','PR26645-B-7 (A)',2004,'PHILRICE',5.5,6.2,118,99,14,'S','I','S','MS','MS','R (I)','-','-','-'),(56,'IRRIGATED LOWLAND','NSIC Rc130 (TUBIGAN 3)','PR30244-AC-9-1',2004,'PHILRICE',4.9,7.6,108,89,14,'I','I','S','MS','I','MR (I)','-','-','-'),(58,'IRRIGATED LOWLAND','NSIC Rc134 (TUBIGAN 4)','PR26873-PJ21-2-1',2005,'PHILRICE',5.4,9.8,107,90,14,'I','I','S','MS','MS','MR(I)','-','-','-'),(60,'IRRIGATED LOWLAND','NSIC Rc138 (TUBIGAN 5)','PR26703-3B-PJ25',2006,'PHILRICE',5.4,8,111,94,15,'S','I','S','I','I','MR','-','-','-'),(62,'IRRIGATED LOWLAND','NSIC Rc140 (TUBIGAN 6)','IR77298-5-6',2006,'IRRI',5.7,8.7,110,94,14,'I','S','I (S)','I','I','MR','-','-','-'),(64,'IRRIGATED LOWLAND','NSIC Rc142 (TUBIGAN 7)','PR31563-AR32-19-3-3',2006,'PHILRICE',5.6,7.8,112,88,14,'S','I','S','I','I','MR','-','-','-'),(66,'IRRIGATED LOWLAND','NSIC Rc144 (TUBIGAN 8)','C6053-B-1-2-1-2',2006,'UPLB',5.3,7.9,107,94,14,'I','S','S','MS','MS','MR','-','-','-'),(68,'IRRIGATED LOWLAND','NSIC Rc146 (PJ7)','PR26703-3B-PJ7',2006,'PHILRICE',4.6,6.9,110,101,14,'S','I','S','S','MS','MR (MS)','-','-','-'),(70,'IRRIGATED LOWLAND','NSIC Rc148 (MABANGO 2)','IR71137-243-2-2-3-3',2007,'IRRI',4.6,6,111,91,14,'I','I','S (S)','I','I','-','-','I','S'),(71,'IRRIGATED LOWLAND','NSIC Rc150 (TUBIGAN 9)','PR27842-PJ27',2007,'PHILRICE',5.9,8.5,109,96,14,'I','I','S (S)','MS','MS','-','-','I','R'),(73,'IRRIGATED LOWLAND','NSIC Rc152 (TUBIGAN 10)','PR30138-21-2',2007,'PHILRICE',6,8.7,109,97,15,'I','I','S (S)','MS','I','-','-','MR','-'),(75,'IRRIGATED LOWLAND','NSIC Rc154 (TUBIGAN 11)','PR31561-AR32-11-83-1-4-1',2007,'PHILRICE',5.9,8.1,110,95,14,'S','I','S (S)','I','I','-','-','I','-'),(76,'IRRIGATED LOWLAND','NSIC Rc156 (TUBIGAN 12)','C6824-B-1-2',2007,'UPLB',5.7,8.5,111,92,14,'S','S','S (S)','I','MS','-','-','I','R'),(78,'IRRIGATED LOWLAND','NSIC Rc158 (TUBIGAN 13)','IR77186-122-2-2-3',2007,'IRRI',6,8.1,113,94,15,'I','I','S (I)','MS','I','-','MR','R','-'),(79,'IRRIGATED LOWLAND','NSIC Rc160 (TUBIGAN 14)','PR30536-B-48-2',2007,'PHILRICE',5.6,8.2,107,96,314,'I','I','S (S)','MS','I','-','-','MR','R'),(81,'IRRIGATED LOWLAND','NSIC Rc170 (MS 11)','IR68333-R-R-B-22',2008,'IRRI',4.5,6.7,112,90,16,'R','I','I (I)','S','MS','(I)','-','-','-'),(82,'IRRIGATED LOWLAND','NSIC Rc172 (MS 13)','IR68144-2B-2-2-3-2',2008,'IRRI',4.6,5.9,112,78,16,'I','I','S (S)','S','MS','(I)','-','-','-'),(83,'IRRIGATED LOWLAND','NSIC Rc212 (TUBIGAN 15)','IR77495-10-2-6-2',2009,'IRRI',6,10,115,109,15,'I','I','S (S)','MR','MR','-','-','-','R'),(85,'IRRIGATED LOWLAND','NSIC Rc214 (TUBIGAN 16)','IR78566-1-2-1-2',2009,'IRRI',6,10.2,116,106,15,'I','I','S (S)','MR','MR','-','-','-','R'),(87,'IRRIGATED LOWLAND','NSIC Rc216 (TUBIGAN 17)','PR34141-38-1-J2',2009,'PHILRICE',6,9.7,112,96,14,'S','I','S (S)','MR','MR','-','-','-','MR'),(89,'IRRIGATED LOWLAND','NSIC Rc218 SR (MABANGO 3)','PR34201-2B-3-1-1 (A)',2009,'PHILRICE',3.8,8,120,106,14,'S','I','S (S)','I','MS','-','MS','I','-'),(90,'IRRIGATED LOWLAND','NSIC Rc220 SR (JAPONICA 1)','IR81551-15-1-2-3 (J)',2009,'IRRI',2.8,5.8,109,89,13,'S','I','S (S)','MS','S','-','MR','MS','-'),(91,'IRRIGATED LOWLAND','NSIC Rc222 (TUBIGAN 18)','IR78581-12-3-2-2',2009,'IRRI',6.1,10,114,101,14,'I','I','S (I)','MR','MR','-','-','-','MR'),(93,'IRRIGATED LOWLAND','NSIC Rc224 (TUBIGAN 19)','PR31091-17-3-1',2010,'PHILRICE',5.8,9.1,111,104,14,'I','S','S (S)','MR','MR','-','-','MS','I'),(94,'IRRIGATED LOWLAND','NSIC Rc226 (TUBIGAN 20)','PR33373-10-1-1-B',2010,'PHILRICE',6.2,9.8,112,102,14,'S','S','S (S)','MR','MR','-','-','MS','I'),(95,'IRRIGATED LOWLAND (HYBRID)','PSB Rc26H (MAGAT)','IR64616H',1994,'IRRI',5.6,7.6,110,88,17,'R','I','S','I','I','MS','','',''),(96,'IRRIGATED LOWLAND (HYBRID)','PSB Rc72H (MESTIZO 1)','IR68284H',1997,'IRRI',5.4,9.9,123,97,15,'I','I','I','S','I','S','','',''),(97,'IRRIGATED LOWLAND (HYBRID)','PSB Rc76H (PANAY)','CRH 05',1998,'MONSANTO',4.8,7.9,106,102,13,'R','I','S','MS','I','R','','',''),(98,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc114H (MESTISO 2)','IR75207H',2002,'IRRI',5.8,8.7,106,98,14,'I','I','S','MS','MS','MR','','',''),(99,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc116H (MESTISO 3)','IR75217H',2002,'IRRI',5.8,8.6,106,108,13,'I','I','S','I','I','MR','','',''),(100,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc124H (MESTISO 4)','BIGANTE',2004,'BAYER',5.7,9.1,118,108,13,'R','I','S','MS','MS','I','','',''),(101,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc126H (MESTISO 5)','MRH 005',2004,'MONSANTO',6.2,9.5,110,120,12,'R','I','I (S)','MS','I','S','','',''),(102,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc132H (MESTISO 6)','SL 8',2004,'SL Agritech',5.9,8.7,113,107,11,'R','I','S','MS','I','MS','','',''),(103,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc136H (MESTISO 7)','IR78386H',2006,'IRRI',6.7,10.6,107,108,13,'I','I','S','MS','MS','MR(MS)','','',''),(104,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc162H (MESTISO 8)','BIO 401',2007,'BIOSEED',5.8,7.7,111,109,13,'I','S','S (S)','MS','MS','-','MR','MR','MR'),(105,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc164H (MESTISO 9)','RIZALINA 28',2007,'HYRICE',6.4,8.5,106,105,14,'I','S','S (S)','MS','I','-','MR','MR','-'),(106,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc166H (MESTISO 10)','PSD 3',2007,'SYNGENTA',6.5,10.6,110,107,13,'I','S','S (S)','MS','I','-','MR','I','MR'),(107,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc168H (MESTISO 11)','BCS O64',2007,'BAYER',6.5,10.5,113,115,14,'I','S','S (S)','I','I','-','MR','I','R'),(108,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc174H (MESTISO 12)','LP 0331',2008,'PHILSCAT',7.1,8.9,112,110,12,'I','S','S (S)','MS','I','-','R','I','R'),(109,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc176H (MESTISO 13)','LP 0353',2008,'PHILSCAT',6.5,8.3,113,112,12,'I','I','S (S)','MS','MS','-','MR','MS','MR'),(110,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc178H (MESTISO 14)','LP 0330',2008,'PHILSCAT',6.3,8.8,104,100,13,'I','S','S (S)','MS','MS','-','MR','MR','I'),(111,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc180H (MESTISO 15)','BCHR 4172',2008,'BIOSEED',6.4,9.9,110,113,14,'I','S','S (S)','I','I','-','MR','I','MR'),(112,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc196H (MESTISO 16)','PR31191H',2009,'PHILRICE',6.2,10.4,103,100,14,'I','S','S (S)','I','MR','-','MR','R','MS'),(113,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc198H (MESTISO 17)','PR31204H',2009,'PHILRICE',6.6,9.7,105,100,14,'I','S','S (S)','MS','I','-','-','R','I'),(114,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc200H (MESTISO 18)','BCS 065',2009,'BAYER',6.5,10.6,111,112,13,'I','S','S (S)','MS','MS','-','MR','MS','MR'),(115,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc202H (MESTISO 19)','PRUP 7',2009,'PHILRICE & UPLB',6.7,10.7,110,108,13,'I','S','S (I)','I','MR','-','-','I','R'),(116,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc204H (MESTISO 20)','PRUP 9',2009,'PHILRICE & UPLB',6.4,11.7,111,112,13,'I','S','S (S)','MR','MR','-','-','I','MR'),(117,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc206H (MESTISO 21)','IR83199H',2009,'IRRI',6.4,11.3,107,110,14,'I','S','S (S)','I','MR','-','-','MS','R'),(118,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc208H (MESTISO 22)','NK 6401',2009,'SYNGENTA',5.9,10.3,115,114,12,'I','I','S (S)','MS','S','-','-','I','MR'),(119,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc210H (MESTISO 23)','PHB 71',2009,'PIONEER',6.4,10.8,113,116,13,'I','S','S (S)','MS','MS','-','-','MS','MR'),(120,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc228H (MESTISO 24)','HR4842H',2010,'HYRICE',7.3,10.3,108,103,14,'I','S','S (S)','I','I','-','-','MR','MS'),(121,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc230H (MESTISO 25)','IR82363H',2010,'IRRI',6.7,10.6,108,103,14,'I','S','S (S)','I','MR','-','-','R','I'),(122,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc232H (MESTISO 26)','IR82372H',2010,'IRRI',7,10.7,110,110,14,'I','S','S (S)','MS','I','-','-','R','MS'),(123,'IRRIGATED LOWLAND (HYBRID)','NSIC  Rc234H (MESTISO 27)','NK 5017',2010,'SYNGENTA',6.5,9.8,115,119,13,'I','I','S (S)','I','MS','-','-','I','I'),(124,'IRRIGATED LOWLAND (HYBRID)','NSIC Rc236H (MESTISO 28)','SW 836',2010,'SEEDWORKS',6.2,10.9,114,115,13,'I','I','S (S)','MS','I','-','-','MR','I'),(125,'IRRIGATED LOWLAND (GLUTINOUS)','UPL Ri1','C229-1',1977,'UPLB',4,0,130,97,0,'MR','MS','MR','-','-','MR','','',''),(126,'IRRIGATED LOWLAND (GLUTINOUS)','BPI Ri1','MRC 1240',1979,'BPI',4.3,0,120,91,0,'R','R','R','-','-','-','','',''),(127,'IRRIGATED LOWLAND (GLUTINOUS)','IR65','IR21015-196-3-1-3',1985,'IRRI',4.7,0,115,86,0,'R','R','R','S','R','MR','','',''),(128,'IRRIGATED LOWLAND (GLUTINOUS)','NSIC Rc13 (MALAGKIT 1)','C4063-2B-7-1-1',2004,'UPLB',4.7,6.1,120,92,17,'S','I','S','MS','MS','I','','',''),(129,'IRRIGATED LOWLAND (GLUTINOUS)','NSIC Rc15 (MALAGKIT 2)','PR25965-14-3',2004,'PHILRICE',5.4,7.6,121,100,14,'I','I','S','S','MS','I','','',''),(130,'IRRIGATED LOWLAND (GLUTINOUS)','NSIC Rc17 (MALAGKIT 3)','PR25959-3-3-4-4-1',2004,'PHILRICE',4.2,8.3,117,91,14,'I','I','I (S)','MS','MS','I','','',''),(131,'IRRIGATED LOWLAND (GLUTINOUS)','NSIC Rc19 (MALAGKIT 4)','PR29332-52-1',2005,'PHILRICE',4.5,5.6,125,101,18,'I','I','S','MS','MS','MR (I)','','',''),(132,'RAINFED LOWLAND (TRANSPLANTED)','PSB Rc12 (CALIRAYA)','C2757-22-1-1-1-1',1992,'UPLB',3.5,6,109,89,13,'I','I','S','I','I','MS','','',''),(133,'RAINFED LOWLAND (TRANSPLANTED)','PSB Rc14 (RIO GRANDE)','C2764-10-2',1992,'UPLB',3.6,6.1,110,92,14,'I','I','S','I','I','S','','',''),(134,'RAINFED LOWLAND (TRANSPLANTED)','PSB Rc36 (MA-AYON)','ENNANO II',1995,'Trad. Variety',3.1,5.3,127,121,11,'I','I','MS','S','I','MS','','',''),(135,'RAINFED LOWLAND (TRANSPLANTED)','PSB Rc38 (RINARA)','RINARA',1995,'Trad. Variety',3.2,5,127,119,11,'I','I','MS','S','I','I','','',''),(136,'RAINFED LOWLAND (TRANSPLANTED)','PSB Rc40 (CHAYONG)','CHAYONG',1995,'Trad. Variety',3.1,4.9,130,126,10,'R','I','MS','S','I','MS','','',''),(137,'RAINFED LOWLAND (TRANSPLANTED)','PSB Rc98 (LIAN)','C3419-10-1-2',2001,'UPLB',2.6,4.5,116,98,13,'I','I','I/S','R','I','I','','',''),(138,'RAINFED LOWLAND (TRANSPLANTED)','PSB Rc100 (SANTIAGO)','MRC22965-4955',2001,'PHILRICE',4.1,4.1,118,111,12,'I','I','S','I','S','R','','',''),(139,'RAINFED LOWLAND (TRANSPLANTED)','PSB Rc102 (MAMBURAO)','IR54068-B-60-1-3-3',2001,'IRRI',2.3,4.4,117,101,13,'I','I','S','I','I','I','','',''),(140,'RAINFED LOWLAND (Drought Prone)','NSIC Rc192 (SAHOD ULAN 1)','IR74371-54-1-1',2009,'IRRI',3.7,5.5,106,109,91,'I','S','S','MS','S','-','MR','MR','R'),(141,'RAINFED LOWLAND (Dry Seeded)','PSB Rc16 (ENNANO)','ENNANO',1993,'Trad. Variety',2.7,4.5,125,112,77,'I','I','S','S','I','-','','',''),(142,'RAINFED LOWLAND (Dry Seeded)','PSB Rc24 (CAGAYAN)','MRC22095-265',1994,'PHILRICE',3.1,5.8,117,99,84,'I','I','I','S','I','MS','','',''),(143,'RAINFED LOWLAND (Dry Seeded)','PSB Rc42 (BALIWAG)','MRC22939-24-2',1995,'PHILRICE',3.2,4.9,114,113,75,'R','I','MS','S','S','MS','','',''),(144,'RAINFED LOWLAND (Dry Seeded)','PSB Rc60 (TUGATOG)','IR41431-6-1-2-3',1997,'IRRI',3.6,4.5,113,100,86,'I','I','S','I','I','MR','','',''),(145,'RAINFED LOWLAND (Dry Seeded)','PSB Rc62 (NAGUILIAN)','PR23765-23',1997,'PHILRICE',3.7,4.7,117,116,75,'R','I','S','S','S','I','','',''),(146,'RAINFED LOWLAND (Dry Seeded)','PSB Rc68 (SACOBIA)','IR57515-PMI-8-1-1-SRN-1-1',1997,'IRRI',3.4,4.4,116,116,87,'I','I','S','I','I','I','','',''),(147,'RAINFED LOWLAND (Dry Seeded)','PSB Rc70 (BAMBAN)','IR60267-11-2-2-1',1997,'IRRI',3.2,4.5,114,116,79,'R','I','S','S','S','MS','','','');
/*!40000 ALTER TABLE `rice_varieties` 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 2013-09-11 15:03:31