Guest User

Untitled

a guest
Mar 13th, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.56 KB | None | 0 0
  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.  
  22. CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mydb` /*!40100 DEFAULT CHARACTER SET latin1 */;
  23.  
  24. USE `mydb`;
  25.  
  26. --
  27. -- Table structure for table `bebida`
  28. --
  29.  
  30. DROP TABLE IF EXISTS `bebida`;
  31. /*!40101 SET @saved_cs_client = @@character_set_client */;
  32. /*!40101 SET character_set_client = utf8 */;
  33. CREATE 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.  
  47. LOCK TABLES `bebida` WRITE;
  48. /*!40000 ALTER TABLE `bebida` DISABLE KEYS */;
  49. 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);
  50. /*!40000 ALTER TABLE `bebida` ENABLE KEYS */;
  51. UNLOCK TABLES;
  52.  
  53. --
  54. -- Table structure for table `cliente`
  55. --
  56.  
  57. DROP TABLE IF EXISTS `cliente`;
  58. /*!40101 SET @saved_cs_client = @@character_set_client */;
  59. /*!40101 SET character_set_client = utf8 */;
  60. CREATE 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.  
  73. LOCK TABLES `cliente` WRITE;
  74. /*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
  75. /*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
  76. UNLOCK TABLES;
  77.  
  78. --
  79. -- Table structure for table `direccion`
  80. --
  81.  
  82. DROP TABLE IF EXISTS `direccion`;
  83. /*!40101 SET @saved_cs_client = @@character_set_client */;
  84. /*!40101 SET character_set_client = utf8 */;
  85. CREATE 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.  
  105. LOCK TABLES `direccion` WRITE;
  106. /*!40000 ALTER TABLE `direccion` DISABLE KEYS */;
  107. /*!40000 ALTER TABLE `direccion` ENABLE KEYS */;
  108. UNLOCK TABLES;
  109.  
  110. --
  111. -- Table structure for table `entrada`
  112. --
  113.  
  114. DROP TABLE IF EXISTS `entrada`;
  115. /*!40101 SET @saved_cs_client = @@character_set_client */;
  116. /*!40101 SET character_set_client = utf8 */;
  117. CREATE 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.  
  131. LOCK TABLES `entrada` WRITE;
  132. /*!40000 ALTER TABLE `entrada` DISABLE KEYS */;
  133. 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);
  134. /*!40000 ALTER TABLE `entrada` ENABLE KEYS */;
  135. UNLOCK TABLES;
  136.  
  137. --
  138. -- Table structure for table `menu`
  139. --
  140.  
  141. DROP TABLE IF EXISTS `menu`;
  142. /*!40101 SET @saved_cs_client = @@character_set_client */;
  143. /*!40101 SET character_set_client = utf8 */;
  144. CREATE 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.  
  159. LOCK TABLES `menu` WRITE;
  160. /*!40000 ALTER TABLE `menu` DISABLE KEYS */;
  161. 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);
  162. /*!40000 ALTER TABLE `menu` ENABLE KEYS */;
  163. UNLOCK TABLES;
  164.  
  165. --
  166. -- Table structure for table `postre`
  167. --
  168.  
  169. DROP TABLE IF EXISTS `postre`;
  170. /*!40101 SET @saved_cs_client = @@character_set_client */;
  171. /*!40101 SET character_set_client = utf8 */;
  172. CREATE 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.  
  186. LOCK TABLES `postre` WRITE;
  187. /*!40000 ALTER TABLE `postre` DISABLE KEYS */;
  188. 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);
  189. /*!40000 ALTER TABLE `postre` ENABLE KEYS */;
  190. UNLOCK TABLES;
  191.  
  192. --
  193. -- Table structure for table `restaurante`
  194. --
  195.  
  196. DROP TABLE IF EXISTS `restaurante`;
  197. /*!40101 SET @saved_cs_client = @@character_set_client */;
  198. /*!40101 SET character_set_client = utf8 */;
  199. CREATE 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.  
  218. LOCK TABLES `restaurante` WRITE;
  219. /*!40000 ALTER TABLE `restaurante` DISABLE KEYS */;
  220. 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);
  221. /*!40000 ALTER TABLE `restaurante` ENABLE KEYS */;
  222. UNLOCK TABLES;
  223.  
  224. --
  225. -- Table structure for table `segundo`
  226. --
  227.  
  228. DROP TABLE IF EXISTS `segundo`;
  229. /*!40101 SET @saved_cs_client = @@character_set_client */;
  230. /*!40101 SET character_set_client = utf8 */;
  231. CREATE 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.  
  245. LOCK TABLES `segundo` WRITE;
  246. /*!40000 ALTER TABLE `segundo` DISABLE KEYS */;
  247. 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);
  248. /*!40000 ALTER TABLE `segundo` ENABLE KEYS */;
  249. UNLOCK 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
Add Comment
Please, Sign In to add comment