--- /dev/null
+/**********************************************************************
+ * Title: Diet-Survey
+ * Description: Application for calculating nutrient intake
+ * Author: Agnibho Mondal
+ * Website: http://code.agnibho.com
+ **********************************************************************
+ Copyright (c) 2013-2015 Agnibho Mondal
+ All rights reserved
+ **********************************************************************
+ This file is part of Diet-Survey.
+
+ Diet-Survey is free software: you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation, either version 3 of the License, or
+ (at your option) any later version.
+
+ Diet-Survey is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with Diet-Survey. If not, see <http://www.gnu.org/licenses/>.
+ **********************************************************************/
+-- phpMyAdmin SQL Dump
+-- version 4.5.2
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Dec 03, 2015 at 09:02 PM
+-- Server version: 10.0.22-MariaDB-log
+-- PHP Version: 5.6.15
+
+SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
+SET time_zone = "+00:00";
+
+
+/*!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 utf8mb4 */;
+
+--
+-- Database: `dietsurvey`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `food`
+--
+
+CREATE TABLE `food` (
+ `id` int(11) NOT NULL,
+ `name` varchar(128) NOT NULL,
+ `food_group` varchar(16) NOT NULL,
+ `energy` decimal(6,2) NOT NULL,
+ `protein` decimal(6,2) NOT NULL,
+ `fat` decimal(6,2) NOT NULL,
+ `iron` decimal(6,2) NOT NULL,
+ `calcium` decimal(6,2) NOT NULL,
+ `vitA` decimal(6,2) NOT NULL,
+ `vitC` decimal(6,2) NOT NULL,
+ `thiamine` decimal(6,2) NOT NULL,
+ `riboflavin` decimal(6,2) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `food`
+--
+
+INSERT INTO `food` (`id`, `name`, `food_group`, `energy`, `protein`, `fat`, `iron`, `calcium`, `vitA`, `vitC`, `thiamine`, `riboflavin`) VALUES
+(1, 'Rice', 'Cereals', '348.00', '6.40', '0.40', '1.00', '9.00', '0.00', '0.00', '0.21', '0.05'),
+(2, 'Wheat', 'Cereals', '341.00', '12.10', '1.70', '4.90', '48.00', '29.00', '0.00', '0.49', '0.17'),
+(3, 'Dal', 'Pulses', '348.00', '24.50', '1.20', '3.90', '75.00', '49.00', '0.00', '0.47', '0.21'),
+(4, 'Lentil', 'Pulses', '343.00', '25.10', '0.60', '7.60', '69.00', '270.00', '0.00', '0.45', '0.20'),
+(5, 'Soyabean', 'Pulses', '432.00', '43.20', '19.50', '10.40', '240.00', '426.00', '0.00', '0.73', '0.39'),
+(6, 'Ground Nut', 'Nuts & Oilseeds', '567.00', '25.30', '40.10', '2.50', '90.00', '37.00', '0.00', '0.90', '0.13'),
+(7, 'Amaranth', 'GLV', '45.00', '4.00', '0.50', '3.49', '397.00', '5520.00', '99.00', '0.03', '0.30'),
+(8, 'Cabbage', 'GLV', '27.00', '1.80', '0.10', '0.80', '39.00', '120.00', '124.00', '0.06', '0.09'),
+(9, 'Spinach', 'GLV', '26.00', '2.00', '0.70', '1.14', '73.00', '5580.00', '28.00', '0.03', '0.25'),
+(10, 'Bottle Guard', 'Other Vegetables', '12.00', '0.20', '0.10', '0.46', '20.00', '0.00', '0.00', '0.03', '0.01'),
+(11, 'Brinjal', 'Other Vegetables', '24.00', '1.40', '0.30', '0.38', '18.00', '74.00', '12.00', '0.04', '0.11'),
+(12, 'Cauliflower', 'Other Vegetables', '30.00', '2.60', '0.40', '1.23', '33.00', '30.00', '56.00', '0.04', '0.10'),
+(13, 'Cucumber', 'Other Vegetables', '13.00', '0.40', '0.10', '0.60', '10.00', '0.00', '7.00', '0.03', '0.00'),
+(14, 'Ladies Finger', 'Other Vegetables', '35.00', '1.90', '0.20', '0.35', '66.00', '52.00', '13.00', '0.07', '0.10'),
+(15, 'Papaya (green)', 'Other Vegetables', '27.00', '0.70', '0.20', '0.90', '28.00', '0.00', '12.00', '0.00', '0.00'),
+(16, 'Parwar', 'Other Vegetables', '20.00', '2.00', '0.30', '1.70', '30.00', '153.00', '29.00', '0.50', '0.60'),
+(17, 'Pumpkin', 'Other Vegetables', '25.00', '1.40', '0.10', '0.44', '10.00', '50.00', '2.00', '0.60', '0.40'),
+(18, 'Plantain', 'Other Vegetables', '64.00', '1.40', '0.20', '6.27', '10.00', '30.00', '24.00', '0.05', '0.02'),
+(19, 'Carrot', 'Roots & Tubers', '48.00', '0.90', '0.20', '1.03', '80.00', '1890.00', '3.00', '0.04', '0.02'),
+(20, 'Onion', 'Roots & Tubers', '50.00', '1.20', '0.10', '0.60', '47.00', '0.00', '11.00', '0.06', '0.01'),
+(21, 'Potato', 'Roots & Tubers', '97.00', '1.60', '0.10', '0.48', '10.00', '24.00', '17.00', '0.10', '0.01'),
+(22, 'Radish', 'Roots & Tubers', '32.00', '0.60', '0.30', '0.37', '50.00', '3.00', '17.00', '0.06', '0.02'),
+(23, 'Amla', 'Fruits', '58.00', '0.50', '0.10', '1.20', '50.00', '9.00', '600.00', '0.03', '0.01'),
+(24, 'Apple', 'Fruits', '59.00', '0.20', '0.66', '1.00', '10.00', '0.00', '1.00', '0.00', '0.00'),
+(25, 'Banana', 'Fruits', '116.00', '1.20', '0.36', '0.90', '17.00', '78.00', '7.00', '0.05', '0.08'),
+(26, 'Grape', 'Fruits', '71.00', '0.50', '0.30', '0.50', '20.00', '0.00', '1.00', '0.00', '0.00'),
+(27, 'Lemon', 'Fruits', '57.00', '1.00', '0.90', '0.26', '70.00', '0.00', '39.00', '0.02', '0.01'),
+(28, 'Guava', 'Fruits', '51.00', '0.90', '0.30', '0.27', '10.00', '0.00', '212.00', '0.03', '0.03'),
+(29, 'Mango', 'Fruits', '74.00', '0.60', '0.40', '1.30', '14.00', '2743.00', '16.00', '0.06', '0.09'),
+(30, 'Orange', 'Fruits', '48.00', '0.70', '0.20', '0.32', '26.00', '1104.00', '30.00', '0.00', '0.00'),
+(31, 'Papaya (ripe)', 'Fruits', '32.00', '0.60', '0.10', '0.50', '17.00', '666.00', '57.00', '0.04', '0.25'),
+(32, 'Tomato', 'Fruits', '20.00', '0.90', '0.20', '0.64', '48.00', '351.00', '27.00', '0.12', '0.06'),
+(33, 'Milk (cow)', 'Milk & Products', '67.00', '3.20', '4.10', '0.20', '120.00', '53.00', '2.00', '0.05', '0.19'),
+(34, 'Milk (human)', 'Milk & Products', '65.00', '1.10', '3.40', '0.00', '28.00', '41.00', '3.00', '0.02', '0.02'),
+(35, 'Egg', 'Flesh Foods', '173.00', '13.30', '13.30', '2.10', '60.00', '420.00', '0.00', '0.10', '0.40'),
+(36, 'Fish (rohu)', 'Flesh Foods', '92.00', '16.60', '1.40', '1.00', '650.00', '0.00', '22.00', '0.05', '0.07'),
+(37, 'Chillies', 'Spices', '29.00', '2.90', '0.60', '4.40', '30.00', '175.00', '111.00', '0.19', '0.39'),
+(38, 'Oil', 'Fats & Oils', '900.00', '0.00', '100.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'),
+(39, 'Sugar', 'Sugar & Jaggery', '398.00', '0.10', '0.00', '0.16', '12.00', '0.00', '0.00', '0.00', '0.00');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `rda`
+--
+
+CREATE TABLE `rda` (
+ `id` int(11) NOT NULL,
+ `subject` varchar(16) NOT NULL,
+ `energy` decimal(6,2) NOT NULL,
+ `protein` decimal(6,2) NOT NULL,
+ `iron` decimal(6,2) NOT NULL,
+ `vitA` decimal(6,2) NOT NULL,
+ `thiamine` decimal(6,2) NOT NULL,
+ `riboflavin` decimal(6,2) NOT NULL,
+ `vitC` decimal(6,2) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `rda`
+--
+
+INSERT INTO `rda` (`id`, `subject`, `energy`, `protein`, `iron`, `vitA`, `thiamine`, `riboflavin`, `vitC`) VALUES
+(1, 'infant_0m-6m', '500.00', '0.00', '0.00', '0.00', '0.20', '0.30', '25.00'),
+(2, 'infant_6m-9m', '670.00', '13.40', '5.00', '2100.00', '0.30', '0.40', '25.00'),
+(3, 'infant_9m-12m', '670.00', '14.90', '5.00', '2100.00', '0.30', '0.40', '25.00'),
+(4, 'male_1y', '1060.00', '15.10', '9.00', '3200.00', '0.50', '0.60', '40.00'),
+(5, 'male_2y', '1060.00', '16.00', '9.00', '3200.00', '0.50', '0.60', '40.00'),
+(6, 'male_3y', '1060.00', '17.20', '9.00', '3200.00', '0.50', '0.60', '40.00'),
+(7, 'male_4y', '1350.00', '18.30', '13.00', '3200.00', '0.70', '0.80', '40.00'),
+(8, 'male_5y', '1350.00', '19.80', '13.00', '3200.00', '0.70', '0.80', '40.00'),
+(9, 'male_6y', '1350.00', '23.50', '13.00', '3200.00', '0.70', '0.80', '40.00'),
+(10, 'male_7y', '1690.00', '26.60', '16.00', '4800.00', '0.80', '1.00', '40.00'),
+(11, 'male_8y', '1690.00', '29.70', '16.00', '4800.00', '0.80', '1.00', '40.00'),
+(12, 'male_9y', '1690.00', '33.00', '16.00', '4800.00', '0.80', '1.00', '40.00'),
+(13, 'male_10y', '2190.00', '36.30', '21.00', '4800.00', '1.10', '1.30', '40.00'),
+(14, 'male_11y', '2190.00', '39.60', '21.00', '4800.00', '1.10', '1.30', '40.00'),
+(15, 'male_12y', '2190.00', '43.70', '21.00', '4800.00', '1.10', '1.30', '40.00'),
+(16, 'male_13y', '2750.00', '49.80', '32.00', '4800.00', '1.40', '1.60', '40.00'),
+(17, 'male_14y', '2750.00', '54.70', '32.00', '4800.00', '1.40', '1.60', '40.00'),
+(18, 'male_15y', '2750.00', '58.20', '32.00', '4800.00', '1.40', '1.60', '40.00'),
+(19, 'male_16y', '3020.00', '60.80', '28.00', '4800.00', '1.50', '1.80', '40.00'),
+(20, 'male_17y', '3020.00', '62.20', '28.00', '4800.00', '1.50', '1.80', '40.00'),
+(21, 'female_1y', '1060.00', '14.10', '9.00', '3200.00', '0.50', '0.30', '40.00'),
+(22, 'female_2y', '1060.00', '15.10', '9.00', '3200.00', '0.50', '0.30', '40.00'),
+(23, 'female_3y', '1060.00', '16.80', '9.00', '3200.00', '0.50', '0.30', '40.00'),
+(24, 'female_4y', '1350.00', '17.80', '13.00', '3200.00', '0.70', '0.80', '40.00'),
+(25, 'female_5y', '1350.00', '19.30', '13.00', '3200.00', '0.70', '0.80', '40.00'),
+(26, 'female_6y', '1350.00', '23.00', '13.00', '3200.00', '0.70', '0.80', '40.00'),
+(27, 'female_7y', '1690.00', '26.10', '16.00', '4800.00', '0.80', '1.00', '40.00'),
+(28, 'female_8y', '1690.00', '29.50', '16.00', '4800.00', '0.80', '1.00', '40.00'),
+(29, 'female_9y', '1690.00', '32.60', '16.00', '4800.00', '0.80', '1.00', '40.00'),
+(30, 'female_10y', '2010.00', '36.80', '27.00', '4800.00', '1.00', '1.20', '40.00'),
+(31, 'female_11y', '2010.00', '40.00', '27.00', '4800.00', '1.00', '1.20', '40.00'),
+(32, 'female_12y', '2010.00', '44.50', '27.00', '4800.00', '1.00', '1.20', '40.00'),
+(33, 'female_13y', '2330.00', '49.00', '27.00', '4800.00', '1.20', '1.40', '40.00'),
+(34, 'female_14y', '2330.00', '52.80', '27.00', '4800.00', '1.20', '1.40', '40.00'),
+(35, 'female_15y', '2330.00', '53.80', '27.00', '4800.00', '1.20', '1.40', '40.00'),
+(36, 'female_16y', '2440.00', '54.90', '26.00', '4800.00', '1.00', '1.20', '40.00'),
+(37, 'female_17y', '2440.00', '56.00', '26.00', '4800.00', '1.00', '1.20', '40.00'),
+(38, 'male_sedentary', '2320.00', '60.00', '17.00', '4800.00', '1.20', '1.40', '40.00'),
+(39, 'male_moderate', '2730.00', '60.00', '17.00', '4800.00', '1.40', '1.60', '40.00'),
+(40, 'male_heavy', '3490.00', '60.00', '17.00', '4800.00', '1.70', '2.10', '40.00'),
+(41, 'female_sedentary', '1900.00', '55.00', '21.00', '4800.00', '1.00', '1.10', '40.00'),
+(42, 'female_moderate', '2230.00', '55.00', '21.00', '4800.00', '1.10', '1.30', '40.00'),
+(43, 'female_heavy', '2850.00', '55.00', '21.00', '4800.00', '1.40', '1.70', '40.00'),
+(44, 'pregnant', '350.00', '78.00', '35.00', '6400.00', '0.20', '0.30', '60.00'),
+(45, 'lactating_below6', '600.00', '74.00', '25.00', '7600.00', '0.30', '0.40', '80.00'),
+(46, 'lactating_above6', '520.00', '68.00', '21.00', '7600.00', '0.20', '0.30', '80.00');
+
+--
+-- Indexes for dumped tables
+--
+
+--
+-- Indexes for table `food`
+--
+ALTER TABLE `food`
+ ADD PRIMARY KEY (`id`);
+
+--
+-- Indexes for table `rda`
+--
+ALTER TABLE `rda`
+ ADD PRIMARY KEY (`id`);
+
+--
+-- AUTO_INCREMENT for dumped tables
+--
+
+--
+-- AUTO_INCREMENT for table `food`
+--
+ALTER TABLE `food`
+ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
+--
+-- AUTO_INCREMENT for table `rda`
+--
+ALTER TABLE `rda`
+ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
+/*!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 */;