# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Nov 25, 2003 at 12:23 PM
# Server version: 4.0.13
# PHP Version: 4.1.2
# 
# Database : `atitd`
# 
CREATE DATABASE `atitd`;
USE atitd;

# --------------------------------------------------------

#
# Table structure for table `yeast`
#

CREATE TABLE `yeast` (
  `yeast_id` int(11) NOT NULL default '0',
  `max_alcohol` int(11) default NULL,
  `min_glucose` int(11) NOT NULL default '0',
  `min_maltose` int(11) NOT NULL default '0',
  `vit_consume` float default NULL,
  `min_vit` int(11) NOT NULL default '0',
  `confirmed` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`yeast_id`)
) TYPE=MyISAM;

#
# Dumping data for table `yeast`
#

INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (48, 1200, 2, 108, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (74, 1026, 1, 90, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (42, 1300, 8, 31, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (57, 1200, 14, 182, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (41, 562, 9, 158, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (99, 325, 1, 200, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (73, 555, 9, 200, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (26, 971, 5, 202, '0.3', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (11, 1026, 3, 200, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (3, 1400, 1, 46, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (59, 992, 9, 192, '0.36', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (43, 443, 11, 166, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (72, 350, 10, 75, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (97, 713, 1, 148, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (17, 992, 13, 37, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (18, 1231, 2, 247, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (65, 1079, 14, 103, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (35, 396, 8, 128, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (91, 325, 13, 25, '0.15', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (8, 992, 1, 148, '0.4', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (49, 351, 14, 225, '0.085', 235, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (24, 1026, 7, 32, '0.28', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (34, 433, 10, 72, '0.1', 0, 0);
INSERT INTO `yeast` (`yeast_id`, `max_alcohol`, `min_glucose`, `min_maltose`, `vit_consume`, `min_vit`, `confirmed`) VALUES (40, 1241, 7, 218, '0.1', 0, 0);

# --------------------------------------------------------

#
# Table structure for table `yeast_flavor`
#

CREATE TABLE `yeast_flavor` (
  `yeast_id` int(11) NOT NULL default '0',
  `barley` float default '0',
  `orange` float default '0',
  `banana` float default '0',
  `cherry` float default '0',
  `date` float default '0',
  `honey` float default '0',
  `nutmeg` float default '0',
  `cinnamon` float default '0',
  `tannin` float default '0',
  `grassy` float default '0',
  `nasty` float default '0',
  UNIQUE KEY `yeast_id` (`yeast_id`)
) TYPE=MyISAM;

#
# Dumping data for table `yeast_flavor`
#

INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (48, NULL, '24.762', NULL, '45.217', '69.333', NULL, '25.366', '69.333', NULL, '22.6087', '76.667');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (74, NULL, '45.455', NULL, '71.429', '2.653', '45.455', '55.556', '21.277', NULL, '20.408', '21.277');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (42, NULL, '17.9', '4.33333', '68.5', '66.6', '0', '74.5', '4.64', NULL, '29.25', '50.85');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (57, NULL, '32', NULL, '26.8', '22.9', '14', NULL, NULL, NULL, '9.425', '36');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (41, '0', '7.69863', '0', '80.2857', '80.2857', '93.6667', '1.32547', '22.48', '0', '33.0588', '80.2857');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (73, '0', '30.8333', '0', '50.4545', '3.38415', '0', '20.5556', '8.40909', '0', '69.375', '8.04348');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (99, '0', '16.25', '0', '0.333333', '40.625', '0', '81.25', '1.67526', '0', '15.4762', '16.25');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (26, '0', '0', '0', '971', '0', '0', '194.2', '0', '0', '0', '0');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (11, '0', '85.5', '0', '68.4', '57', '0', '38', '38', '0', '0', '38');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (3, '0', '12.0244', '0', '98.6', '70.4286', '0', '17', '70.4286', '0', '44.8182', '19.72');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (43, '0', '5.95238', '0', '10.989', '66.6667', '50', '40', '33.3333', '0', '58.8235', '43.4783');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (72, '0', '111.111', '0', '40', '111.111', '0', '26.3158', '15.3846', '0', '2.93255', '13.6986');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (97, '0', '83.3333', '0', '41.6667', '34.4828', '18.8679', '47.619', '55.5556', '0', '40', '71.4286');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (59, '0', '22.7273', '0', '90.9091', '4.97512', '55.5556', '37.037', '0.666667', '0', '37.037', '71.4286');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (17, '0', '17.7143', '0', '0', '0', '0', '5.9759', '0', '0', '0', '0');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (18, '0', '69.25', '0', '33.24', '83.1', '0', '10.9342', '0', '0', '0', '0');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (1, '0', '71.3', '0', '89.125', '3.65641', '0', '32.4091', '71.3', '0', '0', '35.65');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (65, '22.4792', '98.0909', '0', '56.7895', '83', '1.12866', '23.9778', '51.381', '44.9583', '7.59859', '31.7353');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (35, '0', '66', '0', '198', '66', '66', '12.375', '39.6', '0', '0', '0');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (91, '0', '0.333333', '0', '111.111', '9.52381', '35.7143', '29.4118', '62.5', '0', '0', '55.5556');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (8, '26.7273', '36.75', '0', '20.0455', '11.025', '38.3478', '58.8', '7.73684', '882', '63', '73.5');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (82, '0', '6.93571', '69.3571', '88.2727', '80.9167', '0', '51.1053', '57.1176', '0', '69.3571', '74.6923');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (9, '0', '0', '0', '0', '5.02158', '0', '0', '0', '0', '0', '0');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (49, '0', '87.75', '16.4019', '57.541', '71.6327', '45.5844', '24.375', '125.357', '13.5', '5.66129', '117');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (88, '0', '32.3667', '3.96327', '57.1176', '14.9385', '19.0392', '88.2727', '97.1', '18.6731', '38.84', '97.1');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (83, '0', '50.2', '0', '83.6667', '83.6667', '0', '71.7143', '100.4', '0', '14.3429', '55.7778');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (24, '0', '14.9254', '83.3333', '45.4545', '38.4615', '52.6316', '22.7273', '4.29185', '0', '76.9231', '83.3333');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (34, '0', '10.3095', '72.1667', '16.037', '86.6', '17.32', '39.3636', '72.1667', '0', '3.00694', '72.1667');
INSERT INTO `yeast_flavor` (`yeast_id`, `barley`, `orange`, `banana`, `cherry`, `date`, `honey`, `nutmeg`, `cinnamon`, `tannin`, `grassy`, `nasty`) VALUES (40, '0', '73', '68.9444', '22.9815', '56.4091', '33.5405', '21.3966', '68.9444', '47.7308', '17.7286', '37.6061');