-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 22, 2005 at 01:48 PM
-- Server version: 4.1.11
-- PHP Version: 5.0.4
-- 
-- Database: `nationalEx`
-- 

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

-- 
-- Table structure for table `category`
-- 

CREATE TABLE `category` (
  `categoryID` int(11) NOT NULL auto_increment,
  `categoryName` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`categoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `category`
-- 

INSERT INTO `category` VALUES (1, 'Video');
INSERT INTO `category` VALUES (2, 'Books');
INSERT INTO `category` VALUES (3, 'Celebrity Memorabilia');
INSERT INTO `category` VALUES (4, 'Hats');
INSERT INTO `category` VALUES (5, 'Shirts');
INSERT INTO `category` VALUES (6, 'Weird Stuff');

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

-- 
-- Table structure for table `products`
-- 

CREATE TABLE `products` (
  `prodID` int(11) NOT NULL auto_increment,
  `prodName` varchar(32) NOT NULL default '',
  `prodPrice` float NOT NULL default '0',
  `prodDesc` text NOT NULL,
  `prodInventory` varchar(32) NOT NULL default '',
  `vendorID` int(11) NOT NULL default '0',
  `categoryID` int(11) NOT NULL default '0',
  `imagePath` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`prodID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

-- 
-- Dumping data for table `products`
-- 

INSERT INTO `products` VALUES (2, 'Alien Autopsy II Video', 29.95, 'Continuing where Alien Autopsy left off, Alien Autopsy II shows never before seen footage of one of the most bizarre alien autopsies ever.', 'In Stock', 1, 1, 'images/alien.jpg');
INSERT INTO `products` VALUES (3, 'Alien Autopsy III Video', 29.95, 'How did we ever find this stuff? More incredible footage -- this time from Siberia -- shows Russian doctors engaged in an "alien crash recovery" mission.', 'In Stock', 1, 1, 'images/alien.jpg');
INSERT INTO `products` VALUES (4, 'Alien Autopsy IV Video', 29.95, 'OK. So this one is a fake. But it''s a really good fake. You''ll be convinced that aliens ARE real, even though the ones here are not.', 'In Stock', 1, 1, 'images/alien.jpg');
INSERT INTO `products` VALUES (7, 'Alien Autopsy VII Video', 39.95, 'The final one in the series. The most frightening, convincing and utterly repulsive Alien Autopsy to date.', 'Back Order', 1, 1, 'images/alien.jpg');
INSERT INTO `products` VALUES (8, 'J. Lo''s Unread Newspaper', 150, 'A copy of the Miami Herald, delivered directly to the pop diva''s hotel room.', 'In Stock', 2, 3, 'images/newspaper.jpg');
INSERT INTO `products` VALUES (9, 'Crop Ovals and Other Lesser Know', 0, 'This fascinating tome looks at some of the lesser known signs of alien visitation such as crop ovals and presents several cases of possible alien abductees, who have experience moments of "lost time" at long company meetings.', 'In Stock', 3, 2, 'images/crop_ovals.jpg');
INSERT INTO `products` VALUES (10, 'Plaster Impression of Saskwatch', 0, 'This one of a kind plaster impression of a Saskwatch footprint is over 3 feet long. Pictured here is the actual footprint, undoubtedly made as Saskwatch took a quiet, reflective stroll along the beach before terrorizing unlucky campers. This item is only available in the continental United States.', 'In Stock', 6, 6, 'images/saskwatch.jpg');
INSERT INTO `products` VALUES (11, 'Real Dinosaur Egg', 375, 'Don''t settle for imitations. This is the real deal. Keep egg under heat lamp for 4-5 years. No returns.', 'Back Order', 6, 6, 'images/dino_egg.jpg');
INSERT INTO `products` VALUES (13, 'National Exasperator Baseball Ca', 15, 'Help keep quality journalism alive! Support the National Exasperater by purchasing this dapper cap. Makes great XMAS gift.', 'In Stock', 4, 4, 'images/nat_ex_hat.jpg');
INSERT INTO `products` VALUES (16, 'National Exasperater T-Shirt', 20, 'Get this great shirt!', 'In Stock', 5, 5, 'images/ne_shirt.jpg');
INSERT INTO `products` VALUES (17, 'Alien Abduction T-Shirt', 20, 'This hilarious shirt is a great conversation starter. Unless, of course, it happens to be true. In which case you may encounter uncomfortable silences from those around you.', 'In Stock', 5, 5, 'images/ab_shirt.jpg');
INSERT INTO `products` VALUES (18, 'Big Foot T', 20, 'Say it loud; say it proud!', 'In Stock', 5, 5, 'images/bigfoot_t.jpg');
INSERT INTO `products` VALUES (19, 'Alien Love T-Shirt', 20, 'Even aliens have big hearts (in fact, most have several.)', 'In Stock', 5, 5, 'images/alien_shirt.jpg');
INSERT INTO `products` VALUES (20, 'Paparazzi Memories', 45, 'Learn about the wacky life of the paparazzi in this touching memoir. From living in garbage cans to mercilessly invading people''s privacy.', 'Back Order', 2, 2, 'images/book.jpg');
INSERT INTO `products` VALUES (22, 'Tom Cruise''s Sunglasses', 325, 'Own a pair of sunglasses that Tom Cruise wore in a Beverly Hills Boutique. (Note: Mr. Cruise never actually owned these glasses, but he did try them on.)', 'In Stock', 2, 3, 'images/cruise_sunglass.jpg');
INSERT INTO `products` VALUES (23, 'My Son, the Oyster', 4.5, 'This touching real-life story reveals the love between a hapless beach comber and the oyster he raised as his own.', 'In Stock', 2, 2, 'images/book.jpg');
INSERT INTO `products` VALUES (24, 'World''s Largest Shark Tooth', 39.95, 'The world''s largest shark tooth. This is rare and incredible. Weighs 15 lbs and is over 3 feet in length.', 'In Stock', 6, 6, 'images/tooth.jpg');

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

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `userID` int(11) NOT NULL auto_increment,
  `userName` varchar(32) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `accessLevel` varchar(12) NOT NULL default '',
  PRIMARY KEY  (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `users`
-- 

INSERT INTO `users` VALUES (1, 'bigcheese', 'sesame', 'admin');
INSERT INTO `users` VALUES (2, 'littlecheese', 'openUp', 'guest');
INSERT INTO `users` VALUES (3, 'dave@sawmac.com', 'dreamweaver', 'admin');

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

-- 
-- Table structure for table `vendors`
-- 

CREATE TABLE `vendors` (
  `vendorID` int(11) NOT NULL auto_increment,
  `vendorName` varchar(32) NOT NULL default '',
  `vendorStreet` varchar(32) NOT NULL default '',
  `vendorCity` varchar(32) NOT NULL default '',
  `vendorState` varchar(32) NOT NULL default '',
  `vendorZip` varchar(10) NOT NULL default '',
  `vendorPhone` varchar(14) NOT NULL default '',
  PRIMARY KEY  (`vendorID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `vendors`
-- 

INSERT INTO `vendors` VALUES (1, 'Area 51 Films', '58 Elm St.', 'Grook Lake', 'Nevada', '89173', '702-555-1212');
INSERT INTO `vendors` VALUES (2, 'Celebrity Notions', '237 5th St', 'New York', 'New York', '21222', '212-555-1232');
INSERT INTO `vendors` VALUES (3, 'Lone Gunman Publications', '11234 Capitol Blvd.', 'Washington', 'DC', '20500', '415-555-4858');
INSERT INTO `vendors` VALUES (4, 'National Hat Company', '4578 A Street.', 'Portland', 'Oregon', '97213', '503-555-2983');
INSERT INTO `vendors` VALUES (5, 'International Garment Corp.', '4578 A Steet', 'Portland', 'Oregon', '97213', '503-555-2983');
INSERT INTO `vendors` VALUES (6, 'Strange Stuff, Inc.', '9988 Bainbridge Place', 'Athens', 'Georgia', '30602', '706-555-9348');