· 6 years ago · Mar 26, 2019, 12:58 PM
1-- MySQL dump 10.13 Distrib 5.7.25, for Linux (x86_64)
2--
3-- Host: localhost Database: restaurante
4-- ------------------------------------------------------
5-- Server version 5.7.25-0ubuntu0.16.04.2
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `CONTEM`
20--
21
22DROP TABLE IF EXISTS `CONTEM`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `CONTEM` (
26 `id_pedido` int(11) NOT NULL,
27 `id_item_consumo` int(11) NOT NULL,
28 `quantidade` int(11) NOT NULL,
29 PRIMARY KEY (`id_pedido`,`id_item_consumo`),
30 KEY `id_item_consumo` (`id_item_consumo`),
31 CONSTRAINT `CONTEM_ibfk_1` FOREIGN KEY (`id_pedido`) REFERENCES `pedido` (`id`),
32 CONSTRAINT `CONTEM_ibfk_2` FOREIGN KEY (`id_item_consumo`) REFERENCES `item_consumo` (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `CONTEM`
38--
39
40LOCK TABLES `CONTEM` WRITE;
41/*!40000 ALTER TABLE `CONTEM` DISABLE KEYS */;
42INSERT INTO `CONTEM` VALUES (2,2,4),(2,4,1),(3,1,3),(3,3,5);
43/*!40000 ALTER TABLE `CONTEM` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `cliente`
48--
49
50DROP TABLE IF EXISTS `cliente`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!40101 SET character_set_client = utf8 */;
53CREATE TABLE `cliente` (
54 `idCliente` int(11) NOT NULL,
55 `nomeCliente` varchar(50) NOT NULL,
56 PRIMARY KEY (`idCliente`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `cliente`
62--
63
64LOCK TABLES `cliente` WRITE;
65/*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
66INSERT INTO `cliente` VALUES (1,'rodrigo'),(2,'uilly'),(3,'saraiva'),(4,'douglinhas');
67/*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `item_consumo`
72--
73
74DROP TABLE IF EXISTS `item_consumo`;
75/*!40101 SET @saved_cs_client = @@character_set_client */;
76/*!40101 SET character_set_client = utf8 */;
77CREATE TABLE `item_consumo` (
78 `id` int(11) NOT NULL,
79 `categoria` char(15) NOT NULL,
80 `descricao` varchar(20) DEFAULT NULL,
81 `nomeItem` varchar(15) DEFAULT NULL,
82 `precoUnit` double(3,2) DEFAULT NULL,
83 PRIMARY KEY (`id`)
84) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `item_consumo`
89--
90
91LOCK TABLES `item_consumo` WRITE;
92/*!40000 ALTER TABLE `item_consumo` DISABLE KEYS */;
93INSERT INTO `item_consumo` VALUES (1,'bebida','bebida quente','cafe',2.00),(2,'sobremesa','Iguaria cremosa','sorvete',5.50),(3,'alimento','comida oleosa','pastel',5.00),(4,'sobremesa','pedaço pequeno','pudim',3.00);
94/*!40000 ALTER TABLE `item_consumo` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `mesa`
99--
100
101DROP TABLE IF EXISTS `mesa`;
102/*!40101 SET @saved_cs_client = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `mesa` (
105 `idMesa` int(11) NOT NULL,
106 `numeroMesas` int(11) DEFAULT NULL,
107 PRIMARY KEY (`idMesa`)
108) ENGINE=InnoDB DEFAULT CHARSET=latin1;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Dumping data for table `mesa`
113--
114
115LOCK TABLES `mesa` WRITE;
116/*!40000 ALTER TABLE `mesa` DISABLE KEYS */;
117INSERT INTO `mesa` VALUES (1,5),(2,10);
118/*!40000 ALTER TABLE `mesa` ENABLE KEYS */;
119UNLOCK TABLES;
120
121--
122-- Table structure for table `nota`
123--
124
125DROP TABLE IF EXISTS `nota`;
126/*!40101 SET @saved_cs_client = @@character_set_client */;
127/*!40101 SET character_set_client = utf8 */;
128CREATE TABLE `nota` (
129 `numeroNota` int(11) NOT NULL,
130 `dataPagamento` int(11) NOT NULL,
131 PRIMARY KEY (`numeroNota`,`dataPagamento`)
132) ENGINE=InnoDB DEFAULT CHARSET=latin1;
133/*!40101 SET character_set_client = @saved_cs_client */;
134
135--
136-- Dumping data for table `nota`
137--
138
139LOCK TABLES `nota` WRITE;
140/*!40000 ALTER TABLE `nota` DISABLE KEYS */;
141/*!40000 ALTER TABLE `nota` ENABLE KEYS */;
142UNLOCK TABLES;
143
144--
145-- Table structure for table `pedido`
146--
147
148DROP TABLE IF EXISTS `pedido`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `pedido` (
152 `id` int(11) NOT NULL,
153 `data_pedido` datetime DEFAULT NULL,
154 `situacao` varchar(15) DEFAULT NULL,
155 `motivoCancel` varchar(50) DEFAULT NULL,
156 `id_cliente` int(11) NOT NULL,
157 PRIMARY KEY (`id`),
158 KEY `id_cliente` (`id_cliente`),
159 CONSTRAINT `pedido_ibfk_1` FOREIGN KEY (`id_cliente`) REFERENCES `cliente` (`idCliente`)
160) ENGINE=InnoDB DEFAULT CHARSET=latin1;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Dumping data for table `pedido`
165--
166
167LOCK TABLES `pedido` WRITE;
168/*!40000 ALTER TABLE `pedido` DISABLE KEYS */;
169INSERT INTO `pedido` VALUES (1,'2019-03-18 08:37:35','CALOTE','tentou sair sem pagar',3),(2,'2019-03-25 08:33:00','PAGO',NULL,4),(3,'2019-03-25 08:33:00','PAGO',NULL,3),(4,'2019-03-25 08:33:00','CANCELADO','CLIENTE INDECISO',3);
170/*!40000 ALTER TABLE `pedido` ENABLE KEYS */;
171UNLOCK TABLES;
172
173--
174-- Table structure for table `telefone`
175--
176
177DROP TABLE IF EXISTS `telefone`;
178/*!40101 SET @saved_cs_client = @@character_set_client */;
179/*!40101 SET character_set_client = utf8 */;
180CREATE TABLE `telefone` (
181 `numtel` int(11) NOT NULL,
182 `id_cliente` int(11) NOT NULL,
183 PRIMARY KEY (`numtel`,`id_cliente`),
184 KEY `id_cliente` (`id_cliente`),
185 CONSTRAINT `telefone_ibfk_1` FOREIGN KEY (`id_cliente`) REFERENCES `cliente` (`idCliente`)
186) ENGINE=InnoDB DEFAULT CHARSET=latin1;
187/*!40101 SET character_set_client = @saved_cs_client */;
188
189--
190-- Dumping data for table `telefone`
191--
192
193LOCK TABLES `telefone` WRITE;
194/*!40000 ALTER TABLE `telefone` DISABLE KEYS */;
195/*!40000 ALTER TABLE `telefone` ENABLE KEYS */;
196UNLOCK TABLES;
197/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
198
199/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
200/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
201/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
202/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
203/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
204/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
205/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
206
207-- Dump completed on 2019-03-26 9:42:35