· 8 years ago · Mar 13, 2018, 05:58 PM
1-- MySQL dump 10.13 Distrib 5.5.9, for Win32 (x86)
2--
3-- Host: localhost Database: mydb
4-- ------------------------------------------------------
5-- Server version 5.5.14
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-- Current Database: `mydb`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mydb` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `mydb`;
25
26--
27-- Table structure for table `bebida`
28--
29
30DROP TABLE IF EXISTS `bebida`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `bebida` (
34 `idbebida` int(11) NOT NULL AUTO_INCREMENT,
35 `nombre` varchar(45) DEFAULT NULL,
36 `menu_idmenu` int(11) NOT NULL,
37 PRIMARY KEY (`idbebida`),
38 KEY `fk_bebida_menu1` (`menu_idmenu`),
39 CONSTRAINT `fk_bebida_menu1` FOREIGN KEY (`menu_idmenu`) REFERENCES `menu` (`idmenu`) ON DELETE NO ACTION ON UPDATE NO ACTION
40) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `bebida`
45--
46
47LOCK TABLES `bebida` WRITE;
48/*!40000 ALTER TABLE `bebida` DISABLE KEYS */;
49INSERT INTO `bebida` VALUES (1,'Surtido',1),(2,'Limonada',1),(3,'Fresa',2),(4,'Lucuma',2),(5,'Carambola',3),(6,'Papaya',3),(7,'Naranja',4),(8,'Gaseosa',4),(9,'Granadilla',5),(10,'Piña',5),(11,'Platano',6),(12,'Sandia',6);
50/*!40000 ALTER TABLE `bebida` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `cliente`
55--
56
57DROP TABLE IF EXISTS `cliente`;
58/*!40101 SET @saved_cs_client = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `cliente` (
61 `idcliente` varchar(20) NOT NULL,
62 `nombre` varchar(45) DEFAULT NULL,
63 `apellido` varchar(45) DEFAULT NULL,
64 `dni` varchar(45) DEFAULT NULL,
65 PRIMARY KEY (`idcliente`)
66) ENGINE=InnoDB DEFAULT CHARSET=latin1;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `cliente`
71--
72
73LOCK TABLES `cliente` WRITE;
74/*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
75/*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `direccion`
80--
81
82DROP TABLE IF EXISTS `direccion`;
83/*!40101 SET @saved_cs_client = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `direccion` (
86 `iddireccion` int(11) NOT NULL,
87 `latitud` bigint(20) DEFAULT NULL,
88 `longitud` bigint(20) DEFAULT NULL,
89 `distrito` varchar(45) DEFAULT NULL,
90 `calle` varchar(45) DEFAULT NULL,
91 `manzana` varchar(45) DEFAULT NULL,
92 `lote` varchar(45) DEFAULT NULL,
93 `avenida` varchar(45) DEFAULT NULL,
94 `restaurante_idrestaurante` int(11) NOT NULL,
95 PRIMARY KEY (`iddireccion`),
96 KEY `fk_direccion_restaurante1` (`restaurante_idrestaurante`),
97 CONSTRAINT `fk_direccion_restaurante1` FOREIGN KEY (`restaurante_idrestaurante`) REFERENCES `restaurante` (`idrestaurante`) ON DELETE NO ACTION ON UPDATE NO ACTION
98) ENGINE=InnoDB DEFAULT CHARSET=latin1;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `direccion`
103--
104
105LOCK TABLES `direccion` WRITE;
106/*!40000 ALTER TABLE `direccion` DISABLE KEYS */;
107/*!40000 ALTER TABLE `direccion` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `entrada`
112--
113
114DROP TABLE IF EXISTS `entrada`;
115/*!40101 SET @saved_cs_client = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `entrada` (
118 `identrada` int(11) NOT NULL AUTO_INCREMENT,
119 `nombre` varchar(45) DEFAULT NULL,
120 `menu_idmenu` int(11) NOT NULL,
121 PRIMARY KEY (`identrada`),
122 KEY `fk_entrada_menu1` (`menu_idmenu`),
123 CONSTRAINT `fk_entrada_menu1` FOREIGN KEY (`menu_idmenu`) REFERENCES `menu` (`idmenu`) ON DELETE NO ACTION ON UPDATE NO ACTION
124) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
125/*!40101 SET character_set_client = @saved_cs_client */;
126
127--
128-- Dumping data for table `entrada`
129--
130
131LOCK TABLES `entrada` WRITE;
132/*!40000 ALTER TABLE `entrada` DISABLE KEYS */;
133INSERT INTO `entrada` VALUES (1,'Causa Rellena',1),(2,'Papa Rellena',1),(3,'Ensalada Salada',1),(4,'Tequeños',2),(5,'Huevo a la rusa',2),(6,'Tamales',2),(7,'Palta rellena',3),(8,'Leche de tigre',3),(9,'Papa a la huancaina',3),(10,'Conchitas a la parmesana',4),(11,'Pastel de queso',4),(12,'Brochetas de pollo',4),(13,'Rocoto relleno',5),(14,'Ocopa',5),(15,'Ensalada 7 colores',5),(16,'Wan tan frito',6),(17,'Sopa Ramen',6),(18,'Siu mai',6);
134/*!40000 ALTER TABLE `entrada` ENABLE KEYS */;
135UNLOCK TABLES;
136
137--
138-- Table structure for table `menu`
139--
140
141DROP TABLE IF EXISTS `menu`;
142/*!40101 SET @saved_cs_client = @@character_set_client */;
143/*!40101 SET character_set_client = utf8 */;
144CREATE TABLE `menu` (
145 `idmenu` int(11) NOT NULL AUTO_INCREMENT,
146 `precio` double DEFAULT NULL,
147 `votos` int(11) unsigned zerofill DEFAULT NULL,
148 `restaurante_idrestaurante` int(11) NOT NULL,
149 PRIMARY KEY (`idmenu`),
150 KEY `fk_menu_restaurante` (`restaurante_idrestaurante`),
151 CONSTRAINT `fk_menu_restaurante` FOREIGN KEY (`restaurante_idrestaurante`) REFERENCES `restaurante` (`idrestaurante`) ON DELETE NO ACTION ON UPDATE NO ACTION
152) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
153/*!40101 SET character_set_client = @saved_cs_client */;
154
155--
156-- Dumping data for table `menu`
157--
158
159LOCK TABLES `menu` WRITE;
160/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
161INSERT INTO `menu` VALUES (1,5,NULL,1),(2,8,NULL,2),(3,10,NULL,3),(4,7,NULL,4),(5,6,NULL,5),(6,4,NULL,6);
162/*!40000 ALTER TABLE `menu` ENABLE KEYS */;
163UNLOCK TABLES;
164
165--
166-- Table structure for table `postre`
167--
168
169DROP TABLE IF EXISTS `postre`;
170/*!40101 SET @saved_cs_client = @@character_set_client */;
171/*!40101 SET character_set_client = utf8 */;
172CREATE TABLE `postre` (
173 `idpostre` int(11) NOT NULL AUTO_INCREMENT,
174 `nombre` varchar(45) DEFAULT NULL,
175 `menu_idmenu` int(11) NOT NULL,
176 PRIMARY KEY (`idpostre`),
177 KEY `fk_postre_menu1` (`menu_idmenu`),
178 CONSTRAINT `fk_postre_menu1` FOREIGN KEY (`menu_idmenu`) REFERENCES `menu` (`idmenu`) ON DELETE NO ACTION ON UPDATE NO ACTION
179) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
180/*!40101 SET character_set_client = @saved_cs_client */;
181
182--
183-- Dumping data for table `postre`
184--
185
186LOCK TABLES `postre` WRITE;
187/*!40000 ALTER TABLE `postre` DISABLE KEYS */;
188INSERT INTO `postre` VALUES (1,'Kekon de susi',1),(2,'Tres leches',1),(3,'Arroz zambito',1),(4,'Mazamorra',2),(5,'Flan',2),(6,'Helado',2),(7,'Suspiro a la limeña',3),(8,'Pie de limon',3),(9,'Selva negra',3),(10,'Arroz con leche',4),(11,'Picarones',4),(12,'Leche asada',4),(13,'Panqueques',5),(14,'Turron',5),(15,'Pie de manzana',5),(16,'Min pao',6),(17,'Dulce de leche',6),(18,'Pastel de arroz',6);
189/*!40000 ALTER TABLE `postre` ENABLE KEYS */;
190UNLOCK TABLES;
191
192--
193-- Table structure for table `restaurante`
194--
195
196DROP TABLE IF EXISTS `restaurante`;
197/*!40101 SET @saved_cs_client = @@character_set_client */;
198/*!40101 SET character_set_client = utf8 */;
199CREATE TABLE `restaurante` (
200 `idrestaurante` int(11) NOT NULL AUTO_INCREMENT,
201 `nombre` varchar(45) DEFAULT NULL,
202 `ruc` varchar(45) DEFAULT NULL,
203 `descripcion` varchar(45) DEFAULT NULL,
204 `horarioInicio` time DEFAULT NULL,
205 `horarioFin` time DEFAULT NULL,
206 `telefono` varchar(45) DEFAULT NULL,
207 `email` varchar(25) NOT NULL,
208 `password` varchar(25) NOT NULL,
209 `imagen` longblob,
210 PRIMARY KEY (`idrestaurante`)
211) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
212/*!40101 SET character_set_client = @saved_cs_client */;
213
214--
215-- Dumping data for table `restaurante`
216--
217
218LOCK TABLES `restaurante` WRITE;
219/*!40000 ALTER TABLE `restaurante` DISABLE KEYS */;
220INSERT INTO `restaurante` VALUES (1,'Las tias','111111','Restaurante','07:00:00','20:00:00','4351124','tias@yahoo.com.ar','123',NULL),(2,'Hikari','222222','Restaurante','07:00:00','20:00:00','2254465','hikari@hotmail.com','456',NULL),(3,'El rincon','333333','Restaurante','07:00:00','20:00:00','4457843','rincon@gmail.com','789',NULL),(4,'El climax','444444','Restaurante','07:00:00','20:00:00','2246895','climax@yahoo.com.ar','987',NULL),(5,'La seleccion','555555','Restaurante','07:00:00','20:00:00','3565485','seleccion@yahoo.com','654',NULL),(6,'Te encantala','666666','Restaurante','07:00:00','20:00:00','2164875','encantala@hotmail.com','321',NULL);
221/*!40000 ALTER TABLE `restaurante` ENABLE KEYS */;
222UNLOCK TABLES;
223
224--
225-- Table structure for table `segundo`
226--
227
228DROP TABLE IF EXISTS `segundo`;
229/*!40101 SET @saved_cs_client = @@character_set_client */;
230/*!40101 SET character_set_client = utf8 */;
231CREATE TABLE `segundo` (
232 `idsegundo` int(11) NOT NULL AUTO_INCREMENT,
233 `nombre` varchar(45) DEFAULT NULL,
234 `menu_idmenu` int(11) NOT NULL,
235 PRIMARY KEY (`idsegundo`),
236 KEY `fk_segundo_menu1` (`menu_idmenu`),
237 CONSTRAINT `fk_segundo_menu1` FOREIGN KEY (`menu_idmenu`) REFERENCES `menu` (`idmenu`) ON DELETE NO ACTION ON UPDATE NO ACTION
238) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
239/*!40101 SET character_set_client = @saved_cs_client */;
240
241--
242-- Dumping data for table `segundo`
243--
244
245LOCK TABLES `segundo` WRITE;
246/*!40000 ALTER TABLE `segundo` DISABLE KEYS */;
247INSERT INTO `segundo` VALUES (1,'Arroz con pollo',1),(2,'Seco de carne',1),(3,'Arroz con huevo',1),(4,'Lomo saltado',2),(5,'Tallarin rojo',2),(6,'Olluquito',2),(7,'Pollo a la plancha',3),(8,'Pepian de choclo',3),(9,'Estofado de pollo',3),(10,'Pure con asado',4),(11,'Arroz chaufa',4),(12,'Pescado frito',4),(13,'Carapulcra',5),(14,'Aji de gallina',5),(15,'Lentejitas',5),(16,'Arroz chaufa',6),(17,'Tallarin saltado',6),(18,'Pejesapo',6);
248/*!40000 ALTER TABLE `segundo` ENABLE KEYS */;
249UNLOCK TABLES;
250/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
251
252/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
253/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
254/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
255/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
256/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
257/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
258/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
259
260-- Dump completed on 2011-11-13 19:00:43