LmTdWHLh

1-- phpMyAdmin SQL Dump
2-- version 3.5.1
3-- http://www.phpmyadmin.net
4--
5-- Machine: localhost
6-- Genereertijd: 04 mrt 2013 om 19:05
7-- Serverversie: 5.5.24-log
8-- PHP-versie: 5.3.13
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Databank: `coffeedb`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabelstructuur voor tabel `coffee`
27--
28
29CREATE TABLE IF NOT EXISTS `coffee` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `name` varchar(255) DEFAULT NULL,
32  `type` varchar(255) DEFAULT NULL,
33  `price` double DEFAULT NULL,
34  `roast` varchar(255) DEFAULT NULL,
35  `country` varchar(255) DEFAULT NULL,
36  `image` varchar(255) DEFAULT NULL,
37  `review` text,
38  `ide` text,
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
41
42--
43-- Gegevens worden uitgevoerd voor tabel `coffee`
44--
45
46INSERT INTO `coffee` (`id`, `name`, `type`, `price`, `roast`, `country`, `image`, `review`) VALUES
47(1, 'Cafe au Lait', 'Classic', 2.25, 'Medium', 'France', 'Images/Coffee/Cafe-Au-Lait.jpg', 'A coffee beverage consisting strong or bold coffee (sometimes espresso) mixed with scalded milk in approximately a 1:1 ratio.'')'),
48(2, 'Caffe Americano', 'Espresso', 3.25, 'Medium', 'Italy', 'Images/coffee/caffe_americano.jpg', 'Similar in strength and taste to American-style brewed coffee, there are subtle differences achieved by pulling a fresh shot of espresso for the beverage base.'),
49(3, 'Peppermint White Chocolate Mocha', 'Espresso', 3.25, 'Medium', 'Italy', 'Images/coffee/white-chocolate-peppermint-mocha.jpg', 'Espresso with white chocolate and peppermint flavored syrups and steamed milk. Topped with sweetened whipped cream and dark chocolate curls.'),
50(4, 'Galao', 'Latte', 4.2, 'Light', 'Portugal', 'Images/Coffee/galao_kaffee_portugal.jpg', 'Galao is a hot drink from Portugal made of espresso and foamed milk');
51
52/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
53/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
54/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;