-- http://www.phpmyadmin.net
--
-- Máquina: localhost
-- Data de Criação: 24-Out-2015 às 15:52
-- Versão do servidor: 5.5.41
-- versão do PHP: 5.4.41-0+deb7u1




--
-- Base de Dados: `xvwa`
--
CREATE DATABASE `xvwa` ;
-- --------------------------------------------------------

--
-- Estrutura da tabela `caffaine`
--

CREATE TABLE IF NOT EXISTS `caffaine` (
  `itemid` int(11) NOT NULL AUTO_INCREMENT,
  `itemcode` varchar(15) DEFAULT NULL,
  `itemdisplay` varchar(500) DEFAULT NULL,
  `itemname` varchar(50) DEFAULT NULL,
  `itemdesc` varchar(1000) DEFAULT NULL,
  `categ` varchar(200) DEFAULT NULL,
  `price` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Extraindo dados da tabela `caffaine`
--

INSERT INTO `caffaine` (`itemid`, `itemcode`, `itemdisplay`, `itemname`, `itemdesc`, `categ`, `price`) VALUES
(1, 'XVWA0987', '/xvwa/img/XVWA0987.png', 'Affogato', 'An affogato (Italian, "drowned") is a coffee-based beverage. It usually takes the form of a scoop of vanilla gelato or ice cream topped with a shot of hot espresso. Some variations also include a shot of Amaretto or other liqueur.', 'Espresso,Vanilla Gelato', '4.69'),
(2, 'XVWA3876', '/xvwa/img/XVWA3876.png', 'Americano', 'An affogato (Italian, "drowned") is a coffee-based beverage. It usually takes the form of a scoop of vanilla gelato or ice cream topped with a shot of hot espresso. Some variations also include a shot of Amaretto or other liqueur.', 'Espresso', '5'),
(3, 'XVWA4589', '/xvwa/img/XVWA4589.png', 'Bicerin', 'An Americano is an espresso-based drink designed to resemble coffee brewed in a drip filter, considered popular in the United States of America. This drink consists of a single or double-shot of espresso combined with up to four or five ounces of hot water in a two-demitasse cup.', 'Espresso, Chocolate, Milk', '8.9'),
(4, 'XVWA7619', '/xvwa/img/XVWA7619.png', 'Café Bombón', 'Cafe Bombon was made popular in Valencia, Spain, and spread gradually to the rest of the country. It might have been re-created and modified to suit European tastebuds as in many parts of Asia such as Malaysia, Thailand and Singapore the same recipe for coffee which is called "Kopi Susu Panas" (Malaysia) or "Kafe Ron" (Thailand) has already been around for decades and is very popular in "mamak" stalls or "kopitiams" in Malaysia.', 'Espresso, Sweetened Milk', '7.08'),
(5, 'XVWA5642', '/xvwa/img/XVWA5642.png', 'Café au lait', 'Café au lait is a French coffee drink. In Europe, "café au lait" stems from the same continental tradition as "caffè latte" in Italy, "café con leche" in Spain, "kawa biała" ("white coffee") in Poland, "Milchkaffee" in Germany, "Grosser Brauner" in Austria, "koffie verkeerd" in Netherlands, and "café com leite" in Portugal, simply "coffee with milk".', 'Coffee, Milk', '10.15'),
(6, 'XVWA7569', '/xvwa/img/XVWA7569.png', 'Caffé corretto', 'Caffè corretto is an Italian beverage that consists of a shot of espresso with a shot of liquor, usually grappa, and sometimes sambuca or brandy. It is also known (outside of Italy) as an "espresso corretto". It is ordered as "un caffè corretto alla grappa," "[…] corretto alla sambuca," or "[…] corretto al cognac," depending on the desired liquor.', 'Espresso, Liquor Shot', '6.01'),
(7, 'XVWA3671', '/xvwa/img/XVWA3671.png', 'Caffé latte', 'In Italy, latte means milk. What in English-speaking countries is now called a latte is shorthand for "caffelatte" or "caffellatte" ("caffè e latte"). The Italian form means "coffee and milk", similar to the French café au lait, the Spanish café con leche and the Portuguese café com leite. Other drinks commonly found in shops serving caffè lattes are cappuccinos and espressos. Ordering a "latte" in Italy will get the customer a glass of hot or cold milk. Caffè latte is a coffee-based drink made primarily from espresso and steamed milk. It consists of one-third espresso, two-thirds heated milk and about 1cm of foam. Depending on the skill of the barista, the foam can be poured in such a way to create a picture. Common pictures that appear in lattes are love hearts and ferns. Latte art is an interesting topic in itself.', 'Espresso, Milk', '6.04'),
(8, 'XVWA1672', '/xvwa/img/XVWA1672.png', 'Café mélange', 'In Italy, latte means milk. What in English-speaking countries is now called a latte is shorthand for "caffelatte" or "caffellatte" ("caffè e latte"). The Italian form means "coffee and milk", similar to the French café au lait, the Spanish café con leche and the Portuguese café com leite. Other drinks commonly found in shops serving caffè lattes are cappuccinos and espressos. Ordering a "latte" in Italy will get the customer a glass of hot or cold milk. Caffè latte is a coffee-based drink made primarily from espresso and steamed milk. It consists of one-third espresso, two-thirds heated milk and about 1cm of foam. Depending on the skill of the barista, the foam can be poured in such a way to create a picture. Common pictures that appear in lattes are love hearts and ferns. Latte art is an interesting topic in itself.', 'White Creame', '3.06'),
(9, 'XVWA4276', '/xvwa/img/XVWA4276.png', 'Cafe mocha', 'Café mélange is a black coffee mixed (french "mélange") or covered with whipped cream, very popular in Austria, Switzerland and the Netherlands.', 'Latte, Chocolate', '4.05'),
(10, 'XVWA9680', '/xvwa/img/XVWA9680.png', 'Cappuccino', 'Caffè Mocha or café mocha, is an American invention and a variant of a caffe latte, inspired by the Turin coffee beverage Bicerin. The term "caffe mocha" is not used in Italy nor in France, where it is referred to as a "mocha latte". Like a caffe latte, it is typically one third espresso and two thirds steamed milk, but a portion of chocolate is added, typically in the form of sweet cocoa powder, although many varieties use chocolate syrup. Mochas can contain dark or milk chocolate.', 'Espresso, Milk', '3.06');

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

--
-- Estrutura da tabela `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(30) DEFAULT NULL,
  `comment` varchar(100) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Extraindo dados da tabela `comments`
--

INSERT INTO `comments` (`id`, `user`, `comment`, `date`) VALUES
(1, 'admin', 'Keep posting your comments here ', '10 Aug 2015');

