Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.13 Distrib 5.5.9, for Win32 (x86)
- --
- -- Host: localhost Database: mydb
- -- ------------------------------------------------------
- -- Server version 5.5.14
- /*!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 utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Current Database: `mydb`
- --
- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mydb` /*!40100 DEFAULT CHARACTER SET latin1 */;
- USE `mydb`;
- --
- -- Table structure for table `bebida`
- --
- DROP TABLE IF EXISTS `bebida`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `bebida` (
- `idbebida` int(11) NOT NULL AUTO_INCREMENT,
- `nombre` varchar(45) DEFAULT NULL,
- `menu_idmenu` int(11) NOT NULL,
- PRIMARY KEY (`idbebida`),
- KEY `fk_bebida_menu1` (`menu_idmenu`),
- CONSTRAINT `fk_bebida_menu1` FOREIGN KEY (`menu_idmenu`) REFERENCES `menu` (`idmenu`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `bebida`
- --
- LOCK TABLES `bebida` WRITE;
- /*!40000 ALTER TABLE `bebida` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `bebida` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `cliente`
- --
- DROP TABLE IF EXISTS `cliente`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `cliente` (
- `idcliente` varchar(20) NOT NULL,
- `nombre` varchar(45) DEFAULT NULL,
- `apellido` varchar(45) DEFAULT NULL,
- `dni` varchar(45) DEFAULT NULL,
- PRIMARY KEY (`idcliente`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `cliente`
- --
- LOCK TABLES `cliente` WRITE;
- /*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
- /*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `direccion`
- --
- DROP TABLE IF EXISTS `direccion`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `direccion` (
- `iddireccion` int(11) NOT NULL,
- `latitud` bigint(20) DEFAULT NULL,
- `longitud` bigint(20) DEFAULT NULL,
- `distrito` varchar(45) DEFAULT NULL,
- `calle` varchar(45) DEFAULT NULL,
- `manzana` varchar(45) DEFAULT NULL,
- `lote` varchar(45) DEFAULT NULL,
- `avenida` varchar(45) DEFAULT NULL,
- `restaurante_idrestaurante` int(11) NOT NULL,
- PRIMARY KEY (`iddireccion`),
- KEY `fk_direccion_restaurante1` (`restaurante_idrestaurante`),
- CONSTRAINT `fk_direccion_restaurante1` FOREIGN KEY (`restaurante_idrestaurante`) REFERENCES `restaurante` (`idrestaurante`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `direccion`
- --
- LOCK TABLES `direccion` WRITE;
- /*!40000 ALTER TABLE `direccion` DISABLE KEYS */;
- /*!40000 ALTER TABLE `direccion` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `entrada`
- --
- DROP TABLE IF EXISTS `entrada`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `entrada` (
- `identrada` int(11) NOT NULL AUTO_INCREMENT,
- `nombre` varchar(45) DEFAULT NULL,
- `menu_idmenu` int(11) NOT NULL,
- PRIMARY KEY (`identrada`),
- KEY `fk_entrada_menu1` (`menu_idmenu`),
- CONSTRAINT `fk_entrada_menu1` FOREIGN KEY (`menu_idmenu`) REFERENCES `menu` (`idmenu`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `entrada`
- --
- LOCK TABLES `entrada` WRITE;
- /*!40000 ALTER TABLE `entrada` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `entrada` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `menu`
- --
- DROP TABLE IF EXISTS `menu`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `menu` (
- `idmenu` int(11) NOT NULL AUTO_INCREMENT,
- `precio` double DEFAULT NULL,
- `votos` int(11) unsigned zerofill DEFAULT NULL,
- `restaurante_idrestaurante` int(11) NOT NULL,
- PRIMARY KEY (`idmenu`),
- KEY `fk_menu_restaurante` (`restaurante_idrestaurante`),
- CONSTRAINT `fk_menu_restaurante` FOREIGN KEY (`restaurante_idrestaurante`) REFERENCES `restaurante` (`idrestaurante`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `menu`
- --
- LOCK TABLES `menu` WRITE;
- /*!40000 ALTER TABLE `menu` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `menu` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `postre`
- --
- DROP TABLE IF EXISTS `postre`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `postre` (
- `idpostre` int(11) NOT NULL AUTO_INCREMENT,
- `nombre` varchar(45) DEFAULT NULL,
- `menu_idmenu` int(11) NOT NULL,
- PRIMARY KEY (`idpostre`),
- KEY `fk_postre_menu1` (`menu_idmenu`),
- CONSTRAINT `fk_postre_menu1` FOREIGN KEY (`menu_idmenu`) REFERENCES `menu` (`idmenu`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `postre`
- --
- LOCK TABLES `postre` WRITE;
- /*!40000 ALTER TABLE `postre` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `postre` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `restaurante`
- --
- DROP TABLE IF EXISTS `restaurante`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `restaurante` (
- `idrestaurante` int(11) NOT NULL AUTO_INCREMENT,
- `nombre` varchar(45) DEFAULT NULL,
- `ruc` varchar(45) DEFAULT NULL,
- `descripcion` varchar(45) DEFAULT NULL,
- `horarioInicio` time DEFAULT NULL,
- `horarioFin` time DEFAULT NULL,
- `telefono` varchar(45) DEFAULT NULL,
- `email` varchar(25) NOT NULL,
- `password` varchar(25) NOT NULL,
- `imagen` longblob,
- PRIMARY KEY (`idrestaurante`)
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `restaurante`
- --
- LOCK TABLES `restaurante` WRITE;
- /*!40000 ALTER TABLE `restaurante` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `restaurante` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `segundo`
- --
- DROP TABLE IF EXISTS `segundo`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `segundo` (
- `idsegundo` int(11) NOT NULL AUTO_INCREMENT,
- `nombre` varchar(45) DEFAULT NULL,
- `menu_idmenu` int(11) NOT NULL,
- PRIMARY KEY (`idsegundo`),
- KEY `fk_segundo_menu1` (`menu_idmenu`),
- CONSTRAINT `fk_segundo_menu1` FOREIGN KEY (`menu_idmenu`) REFERENCES `menu` (`idmenu`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `segundo`
- --
- LOCK TABLES `segundo` WRITE;
- /*!40000 ALTER TABLE `segundo` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `segundo` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!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 */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2011-11-13 19:00:43
Add Comment
Please, Sign In to add comment