-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Tempo de geração: 23/07/2024 às 10:53
-- Versão do servidor: 5.7.23-23
-- Versão do PHP: 8.1.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Banco de dados: `clock_Narreal`
--

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

--
-- Estrutura para tabela `info_cervejas`
--

CREATE TABLE `info_cervejas` (
  `torneira` int(2) NOT NULL,
  `rotulo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `cervejaria` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `estilo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `abv` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `ibu` int(2) NOT NULL,
  `preco` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(60) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Despejando dados para a tabela `info_cervejas`
--

INSERT INTO `info_cervejas` (`torneira`, `rotulo`, `cervejaria`, `estilo`, `abv`, `ibu`, `preco`, `logo`) VALUES
(1, 'RUSTY ', 'THREE MONKEYS ', 'IRISH RED ALE ', '5,0', 24, '5,98', 'Arte-Rusty_1.jpg'),
(2, 'HOUSE WIT', 'THREE MONKEYS ', 'BELGIAN WITBIER ', '4,5', 0, '4,72', 'arte house wit.jpg'),
(3, 'HOUSE WEISS ', 'THREE MONKEYS ', 'WEIZENBIER', '5,1', 0, '5,33', 'Arte house-weiss.jpg'),
(4, 'PARANOID ABOUT PAÇOCA ', 'THREE MONKEYS ', 'IMPERIAL STOUT COM CACAU AVELÃ NOZES E PAÇOCA ', '12', 33, '11,85', 'Arte-Paranoid-Paçoca1.jpg'),
(5, 'S³', 'THREE MONKEYS ', 'JUICE PALE LAGER ', '6,1', 0, '7,90', 'IMG-20240203-WA0002.jpg');

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

--
-- Estrutura para tabela `info_cervejas_02`
--

CREATE TABLE `info_cervejas_02` (
  `torneira` int(2) NOT NULL,
  `rotulo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `cervejaria` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `estilo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `abv` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `ibu` int(2) NOT NULL,
  `preco` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(60) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Despejando dados para a tabela `info_cervejas_02`
--

INSERT INTO `info_cervejas_02` (`torneira`, `rotulo`, `cervejaria`, `estilo`, `abv`, `ibu`, `preco`, `logo`) VALUES
(1, 'SOURSSENTIALS TANGERINAE', 'THREE MONKEYS ', 'SOUR COM TANGERINA ', '4', 0, '6,90', 'sourssentials-02.jpg'),
(2, 'MONKEYSHINE', 'THREE MONKEYS & DOM HAUS', 'SOUR ALE COM MARACUJA GOIABA MORANGO E BAUNILHA', '5,5', 5, '7,47', 'WhatsApp Image 2024-07-18 at 20.20.38.jpeg'),
(3, 'SOURSSENTIALS LEMON ', 'THREE MONKEYS ', 'SOUR COM LIMÃO ', '4', 0, '6,90', 'IMG-20240120-WA0007.jpg'),
(4, 'GAZPACHO', 'THREE MONKEYS ', 'SOUR COM TOMATE E PICLES DE PEPINO', '4,6', 8, '7,11', 'IMG-20240221-WA0006.jpg'),
(5, 'TRUE GOLD (ULTRA FRESH)', 'THREE MONKEYS ', 'PILSNER', '5,3', 15, '4,40', 'arte-true-gold.png');

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

--
-- Estrutura para tabela `info_cervejas_03`
--

CREATE TABLE `info_cervejas_03` (
  `torneira` int(2) NOT NULL,
  `rotulo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `cervejaria` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `estilo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `abv` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `ibu` int(2) NOT NULL,
  `preco` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `promocao` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Despejando dados para a tabela `info_cervejas_03`
--

INSERT INTO `info_cervejas_03` (`torneira`, `rotulo`, `cervejaria`, `estilo`, `abv`, `ibu`, `preco`, `logo`, `promocao`) VALUES
(1, 'TRUE GOLD (ULTRA FRESH)', 'THREE MONKEYS ', 'PILSNER', '5', 15, '4,40', 'arte-true-gold.png', 1),
(2, 'EASY IPA ', 'THREE MONKEYS ', 'SESSION IPA ', '4,5', 30, '5,90', 'Arte Easy IPA-1.png', 0),
(3, 'HOUSE IPA ', 'THREE MONKEYS ', 'AMERICAN IPA ', '6,3', 45, '7,11', 'IMG-20240114-WA0015.jpg', 0),
(4, 'HOUSE TRIPEL ', 'THREE MONKEYS ', 'BELGIAN TRIPEL ', '10', 0, '7,00', 'Arte House-tripel.jpg', 0),
(5, 'GALAXY DETOX ', 'THREE MONKEYS ', 'NEW ENGLAND IPA ', '6,5', 0, '8,55', 'IMG-20240308-WA0028.jpg', 0);

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

--
-- Estrutura para tabela `info_cervejas_04`
--

CREATE TABLE `info_cervejas_04` (
  `torneira` int(2) NOT NULL,
  `rotulo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `cervejaria` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `estilo` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `abv` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `ibu` int(2) NOT NULL,
  `preco` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(60) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Despejando dados para a tabela `info_cervejas_04`
--

INSERT INTO `info_cervejas_04` (`torneira`, `rotulo`, `cervejaria`, `estilo`, `abv`, `ibu`, `preco`, `logo`) VALUES
(1, 'APPLE BARBECUE ', 'THREE MONKEYS ', 'LICHTENHAINER ', '5,0', 0, '5,68', 'Screenshot_20240404_210617_Untappd.jpg'),
(2, 'CALVINS LAB ', 'NARREAL & QUATRO GRAUS ', 'IMPERIAL SOUR COM KIWI ', '10', 5, '7,69', 'Narreal - Quatro Graus - Calvins Lab - TV-3.png'),
(3, 'PINEAPLE BARBECUE ', 'THREE MONKEYS ', 'LICHTENHAINER ', '5,0', 0, '5,68', 'Arte pineapple.jpg'),
(4, 'TROPICALISM ', 'THREE MONKEYS ', 'SOUR ALE COM MARACUJÁ MANGA E COCO ', '4,7', 5, '7,47', 'Arte-Tropicalism.jpg'),
(5, 'KIRO SOUR', 'THREE MONKEYS ', 'SOUR COM GENGIBRE VINAGRE DE MAÇA E MEL', '4,6', 0, '8,00', 'arte kiro.jpg');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
