· 9 years ago · Apr 28, 2017, 06:38 PM
1CREATE DATABASE IF NOT EXISTS `carrefour` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `carrefour`;
3-- MySQL dump 10.13 Distrib 5.7.18, for macos10.12 (x86_64)
4--
5-- Host: localhost Database: carrefour
6-- ------------------------------------------------------
7-- Server version 5.7.18
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `categoria`
22--
23
24DROP TABLE IF EXISTS `categoria`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `categoria` (
28 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
29 `nombre` varchar(45) NOT NULL,
30 `id_categoria_padre` int(10) unsigned DEFAULT NULL,
31 PRIMARY KEY (`id`),
32 UNIQUE KEY `categoriacol_UNIQUE` (`nombre`),
33 KEY `id_categoria_padre_idx` (`id_categoria_padre`),
34 CONSTRAINT `id_categoria_padre` FOREIGN KEY (`id_categoria_padre`) REFERENCES `categoria` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
35) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `categoria`
40--
41
42LOCK TABLES `categoria` WRITE;
43/*!40000 ALTER TABLE `categoria` DISABLE KEYS */;
44INSERT INTO `categoria` (`id`, `nombre`, `id_categoria_padre`) VALUES (1,'Electrodomésticos',NULL),(2,'Consolas y videojuegos',NULL),(3,'Celulares',NULL),(4,'Aires acondicionados',NULL),(5,'Informática',NULL),(6,'Comida',NULL),(7,'Bebida',NULL),(8,'Fruta',6),(9,'Verdura',6),(10,'Carnes',6),(11,'Gaseosa',7),(12,'Bebidas alcohólicas',7),(13,'Aguas saborizadas',7),(14,'Aguas',7),(15,'Portátiles',2),(16,'Hornos',1),(17,'Lavarropas',1),(18,'Heladeras',1),(19,'Microondas',1),(20,'Aires acondicionados frÃo',4),(21,'Aires acondicionados frÃo/calor',4),(22,'Computadoras',5),(23,'Impresoras',5),(24,'Notebooks',5),(25,'Televisores',NULL),(26,'Pasta',6);
45/*!40000 ALTER TABLE `categoria` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `cliente`
50--
51
52DROP TABLE IF EXISTS `cliente`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `cliente` (
56 `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
57 `nombre` varchar(100) NOT NULL,
58 `apellido` varchar(100) NOT NULL,
59 `email` varchar(150) NOT NULL,
60 `telefono` varchar(8) DEFAULT NULL,
61 `celular` varchar(10) DEFAULT NULL,
62 `fecha_de_nacimiento` datetime NOT NULL,
63 `id_producto_preferido` int(10) unsigned DEFAULT NULL,
64 PRIMARY KEY (`Id`),
65 KEY `producto_preferido_idx` (`id_producto_preferido`),
66 CONSTRAINT `producto_preferido` FOREIGN KEY (`id_producto_preferido`) REFERENCES `producto` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
67) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Dumping data for table `cliente`
72--
73
74LOCK TABLES `cliente` WRITE;
75/*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
76INSERT INTO `cliente` (`Id`, `nombre`, `apellido`, `email`, `telefono`, `celular`, `fecha_de_nacimiento`, `id_producto_preferido`) VALUES (1,'Sacha','LIfszyc','sacha.lifszyc@gmail.com','46319613','1153980907','1990-08-12 00:00:00',37),(2,'DarÃo','Susnisky','dario@dh.com','49968901','1130315490','1990-10-03 00:00:00',22),(3,'Javier','Herrera','javi@dh.com','49074344',NULL,'1990-09-01 00:00:00',NULL),(4,'Carla','Zapata','carlazapata@gmail.com',NULL,'1156701024','1986-03-10 00:00:00',29),(5,'Laura','Cortés','laucortes14@hotmail.com',NULL,'1157843301','1978-05-06 00:00:00',NULL),(6,'Martina','Crespo','martucrespo84@hotmail.com','46338998',NULL,'1984-03-07 00:00:00',1);
77/*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `marca`
82--
83
84DROP TABLE IF EXISTS `marca`;
85/*!40101 SET @saved_cs_client = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `marca` (
88 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
89 `nombre` varchar(45) NOT NULL,
90 PRIMARY KEY (`id`),
91 UNIQUE KEY `nombre_UNIQUE` (`nombre`)
92) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `marca`
97--
98
99LOCK TABLES `marca` WRITE;
100/*!40000 ALTER TABLE `marca` DISABLE KEYS */;
101INSERT INTO `marca` (`id`, `nombre`) VALUES (8,'Apple'),(15,'Coca-Cola'),(1,'HP'),(13,'LG'),(7,'Microsoft'),(9,'Motorola'),(6,'Nintendo'),(14,'Panasonic'),(20,'Patagonia'),(12,'Philco'),(11,'Philips'),(18,'Quilmes'),(2,'Samsung'),(10,'Sanyo'),(17,'Ser'),(5,'Sony'),(16,'Sprite'),(19,'Stella Artois'),(3,'Toshiba'),(4,'TP Link');
102/*!40000 ALTER TABLE `marca` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `producto`
107--
108
109DROP TABLE IF EXISTS `producto`;
110/*!40101 SET @saved_cs_client = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `producto` (
113 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
114 `nombre` varchar(255) NOT NULL,
115 `modelo` varchar(255) DEFAULT NULL,
116 `id_marca` int(10) unsigned DEFAULT NULL,
117 `descripcion` varchar(500) DEFAULT NULL,
118 `id_categoria` int(10) unsigned NOT NULL,
119 `precio` varchar(45) NOT NULL,
120 `puntuacion` varchar(45) DEFAULT NULL,
121 PRIMARY KEY (`id`),
122 KEY `marca_idx` (`id_marca`),
123 KEY `categoria_idx` (`id_categoria`),
124 CONSTRAINT `categoria` FOREIGN KEY (`id_categoria`) REFERENCES `categoria` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
125 CONSTRAINT `marca` FOREIGN KEY (`id_marca`) REFERENCES `marca` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
126) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
127/*!40101 SET character_set_client = @saved_cs_client */;
128
129--
130-- Dumping data for table `producto`
131--
132
133LOCK TABLES `producto` WRITE;
134/*!40000 ALTER TABLE `producto` DISABLE KEYS */;
135INSERT INTO `producto` (`id`, `nombre`, `modelo`, `id_marca`, `descripcion`, `id_categoria`, `precio`, `puntuacion`) VALUES (1,'TV LED 32\"','SY-XFJQLP-32',10,'Este televisor tiene una pantalla de 32 pulgadas y resolución de 1366x768 (HD Ready)',25,'8000','3.1'),(2,'Manzana roja',NULL,NULL,'Manzana roja origen nacional',8,'5','2.5'),(3,'Manzana verde',NULL,NULL,'Manzana verde originel nacional',8,'5','2.5'),(4,'1kg de bife',NULL,NULL,NULL,10,'129','3.4'),(5,'1kg pechuga de pollo',NULL,NULL,NULL,10,'105','3'),(6,'Fideos tricolor',NULL,NULL,'Fideos de zapallo, zanahoria y espinaca',26,'40','1.9'),(7,'Caja de ravioles de verdura y pollo',NULL,NULL,'Los mejores ravioles de la Argentina',26,'64','2.4'),(8,'Caracolitos',NULL,NULL,'Rica pasta',26,'38','0.9'),(17,'Playstation 3','Slim',5,'Con 2 joysticks',2,'7000','3.6'),(18,'Playstation 4',NULL,5,'La nueva. Con un solo control y un videojuego',2,'8000','4.1'),(19,'Playstation 4 Slim','Slim',5,'Último modelo más finita',2,'8500','4.3'),(20,'Wii','Blanca 250gb',6,'Nintendo Wii excelente para jugar con tus niños',2,'7000','3.2'),(21,'Wii-U','Con mando externo tipo iPad',6,'Nintendo Wii-U que viene con un joystick tipo iPad para controlar a los personajes del videojuego',2,'8000','3.6'),(22,'Nintendo Switch','La última consola de Nintendo',6,'Mama mÃa',2,'12000','4.6'),(23,'TV Samsung 3D OLED 40\"','SMG-3D-40LXHFG',2,'Alta tele',25,'25000','3.7'),(24,'Smart TV Panasonic 50\"','PNSC-SM50JKGH',14,'Excelente para mirar fútbol',25,'26000','4'),(27,'iPhone 6s','64gb negro',8,'Buen iPhone',3,'14000','4'),(28,'iPhone 6s','128gb blanco',8,'Buen iPhone con mayor capacidad',3,'17000','4.5'),(29,'iPhone 7','128gb negro',8,'Muy buen iPhone',3,'24000','4.8'),(30,'Coca-Cola','1.5lts',15,'Una botella de Coca',11,'36','4.2'),(31,'Coca-Cola','2.25lts',15,'Una botella de Coca más grande',11,'42','3.8'),(32,'Sprite','1.5lts',16,'Una botella de Sprite',11,'34','3.6'),(33,'Agua sabor pomelo','1.5lts',17,'Una botella de agua saborizada',13,'28','3.4'),(34,'Agua sabor naranja','1.5lts',17,'Una botella de agua sabor naranja',13,'28','3.5'),(35,'Cerveza Quilmes','1lt',18,'El sabor del encuentro',12,'22','2.2'),(36,'Cerveza Stella Artois','1lt',19,'Ella es única',12,'30','3.2'),(37,'Cerveza Artesanal Patagonia Amber Ale','750cc',20,'La más rica',12,'42','4.3');
136/*!40000 ALTER TABLE `producto` ENABLE KEYS */;
137UNLOCK TABLES;
138
139--
140-- Table structure for table `venta`
141--
142
143DROP TABLE IF EXISTS `venta`;
144/*!40101 SET @saved_cs_client = @@character_set_client */;
145/*!40101 SET character_set_client = utf8 */;
146CREATE TABLE `venta` (
147 `Id` int(11) NOT NULL AUTO_INCREMENT,
148 `fecha` datetime NOT NULL,
149 `id_cliente` int(10) unsigned NOT NULL,
150 `id_producto` int(10) unsigned DEFAULT NULL,
151 `cantidad` int(11) NOT NULL,
152 PRIMARY KEY (`Id`),
153 KEY `cliente_idx` (`id_cliente`),
154 KEY `producto_idx` (`id_producto`),
155 CONSTRAINT `cliente` FOREIGN KEY (`id_cliente`) REFERENCES `cliente` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
156 CONSTRAINT `producto` FOREIGN KEY (`id_producto`) REFERENCES `producto` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
157) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
158/*!40101 SET character_set_client = @saved_cs_client */;
159
160--
161-- Dumping data for table `venta`
162--
163
164LOCK TABLES `venta` WRITE;
165/*!40000 ALTER TABLE `venta` DISABLE KEYS */;
166INSERT INTO `venta` (`Id`, `fecha`, `id_cliente`, `id_producto`, `cantidad`) VALUES (1,'2017-04-28 00:00:00',1,2,5),(2,'2017-04-28 00:00:00',1,3,4),(3,'2017-04-21 00:00:00',2,28,1),(4,'2017-04-20 00:00:00',3,28,1),(5,'2017-04-19 00:00:00',4,28,1),(6,'2017-04-07 00:00:00',1,29,1),(7,'2017-04-14 00:00:00',5,27,1),(8,'2017-03-14 00:00:00',5,29,3),(9,'2017-02-15 00:00:00',2,22,10),(10,'2017-02-15 00:00:00',1,19,1),(11,'2017-02-14 00:00:00',3,18,1),(12,'2016-12-08 00:00:00',5,35,12),(13,'2016-11-12 00:00:00',3,36,1),(14,'2016-11-07 00:00:00',3,35,4),(15,'2016-11-16 00:00:00',3,37,1),(16,'2016-11-12 00:00:00',4,36,6),(17,'2016-07-09 00:00:00',3,35,3),(18,'2016-11-12 00:00:00',1,37,2),(19,'2016-03-08 00:00:00',2,37,2),(20,'2016-08-12 00:00:00',5,35,6),(21,'2016-07-04 00:00:00',3,36,3),(22,'2016-09-10 00:00:00',1,37,1),(23,'2016-02-01 00:00:00',2,35,1),(24,'2015-12-25 00:00:00',2,37,12);
167/*!40000 ALTER TABLE `venta` ENABLE KEYS */;
168UNLOCK TABLES;
169/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
170
171/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
172/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
173/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
174/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
175/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
176/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
177/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
178
179-- Dump completed on 2017-04-28 15:17:02