# <pre>
-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 21, 2008 at 11:40 AM
-- Server version: 5.0.26
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Database: `DB0jstudent0`
--

-- --------------------------------------------------------

--
-- Table structure for table `fruit`
--

CREATE TABLE IF NOT EXISTS `fruit` (
  `fruitID` smallint(6) unsigned NOT NULL auto_increment COMMENT 'Primary Key for each fruit',
  `name` varchar(8) default NULL COMMENT 'Full Name for fruit',
  `price` double(5,2) default NULL COMMENT 'Current Market Price of fruit',
  PRIMARY KEY  (`fruitID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `fruit`
--

INSERT INTO `fruit` (`fruitID`, `name`, `price`) VALUES
(1, 'apple', 2.50),
(2, 'pear', 3.00),
(4, 'Grpe', 0.75),
(8, 'pluot', 4.50),
(6, 'plum', 1.25),
(3, 'banana', 1.00);