JSP.zip_netbeans jsp

-- phpMyAdmin SQL Dump -- version 3.3.9 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 09, 2012 at 04:26 AM -- Server version: 5.5.8 -- PHP Version: 5.3.5 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: `es_410_mp_2` -- -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE IF NOT EXISTS `category` ( `category_id` int(11) NOT NULL AUTO_INCREMENT, `category_desc` varchar(255) NOT NULL, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `category` -- INSERT INTO `category` (`category_id`, `category_desc`) VALUES (1, 'Dog'), (2, 'Cat'), (3, 'Fish'); -- -------------------------------------------------------- -- -- Table structure for table `pet` -- CREATE TABLE IF NOT EXISTS `pet` ( `pet_id` int(11) NOT NULL AUTO_INCREMENT, `pet_desc` varchar(255) NOT NULL, `category_id` int(11) NOT NULL, PRIMARY KEY (`pet_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `pet` -- INSERT INTO `pet` (`pet_id`, `pet_desc`, `category_id`) VALUES (1, 'Labrador', 1), (2, 'Akita', 1), (3, 'Goldfish', 3), (4, 'Flower Horn', 3); -- -------------------------------------------------------- -- -- Table structure for table `shopping_cart` -- CREATE TABLE IF NOT EXISTS `shopping_cart` ( `shopping_cart_id` int(11) NOT NULL AUTO_INCREMENT, `item_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, PRIMARY KEY (`shopping_cart_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `shopping_cart` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `users` -- INSERT INTO `users` (`user_id`, `first_name`, `last_name`) VALUES (1, 'Cup', 'Spoon'), (2, 'Saucer', 'Fork');