-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 22, 2010 at 04:37 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

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: `inventorydb`
--

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

--
-- Table structure for table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `ItemNumber` int(11) NOT NULL,
  `ItemName` varchar(100) NOT NULL,
  `Price` double NOT NULL,
  `AvailableQuantity` int(11) NOT NULL,
  `Updated_Dt` datetime NOT NULL,
  PRIMARY KEY (`ItemNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`ItemNumber`, `ItemName`, `Price`, `AvailableQuantity`, `Updated_Dt`) VALUES
(1, 'Papers', 11, 5, '2010-03-22 14:59:33'),
(2, 'Pencils', 2, 10, '2010-03-22 15:01:17'),
(3, 'Staplers', 5.3, 1, '2010-03-22 15:01:49'),
(4, 'Books', 12, 7, '2010-03-22 14:59:34');