· 10 years ago · Apr 26, 2016, 03:24 AM
1-- MySQL dump 10.13 Distrib 5.6.28, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost Database: SISTEMAREVENDEDOR2
4-- ------------------------------------------------------
5-- Server version 5.6.28-0ubuntu0.14.04.1
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 `administra`
20--
21DROP DATABASE IF EXISTS SISTEMAREVENDEDOR2;
22
23CREATE DATABASE SISTEMAREVENDEDOR2;
24
25USE SISTEMAREVENDEDOR2;
26
27
28DROP TABLE IF EXISTS `administra`;
29/*!40101 SET @saved_cs_client = @@character_set_client */;
30/*!40101 SET character_set_client = utf8 */;
31CREATE TABLE `administra` (
32 `id_revendedor` int(11) NOT NULL DEFAULT '0',
33 `email` varchar(30) DEFAULT NULL,
34 `telefone` varchar(14) DEFAULT NULL,
35 `nome` varchar(50) NOT NULL DEFAULT '',
36 PRIMARY KEY (`id_revendedor`,`nome`),
37 CONSTRAINT `administra_ibfk_1` FOREIGN KEY (`id_revendedor`) REFERENCES `revendedor` (`id_revendedor`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Dumping data for table `administra`
43--
44
45LOCK TABLES `administra` WRITE;
46/*!40000 ALTER TABLE `administra` DISABLE KEYS */;
47INSERT INTO `administra` VALUES (1,'norma@mail.com','778140-5520','Norma Cruz');
48/*!40000 ALTER TABLE `administra` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `cliente`
53--
54
55DROP TABLE IF EXISTS `cliente`;
56/*!40101 SET @saved_cs_client = @@character_set_client */;
57/*!40101 SET character_set_client = utf8 */;
58CREATE TABLE `cliente` (
59 `nome` varchar(50) DEFAULT NULL,
60 `sobrenome` varchar(50) DEFAULT NULL,
61 `cpf` varchar(15) DEFAULT NULL,
62 `id_cliente` int(11) NOT NULL AUTO_INCREMENT,
63 `rua` varchar(50) DEFAULT NULL,
64 `numero` char(10) DEFAULT NULL,
65 `bairro` varchar(50) DEFAULT NULL,
66 `complemento` varchar(30) DEFAULT NULL,
67 `cep` char(11) DEFAULT NULL,
68 `cidade_estado` varchar(30) DEFAULT NULL,
69 `email` varchar(30) DEFAULT NULL,
70 `telefone` char(13) DEFAULT NULL,
71 `celular` char(13) DEFAULT NULL,
72 PRIMARY KEY (`id_cliente`)
73) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
74/*!40101 SET character_set_client = @saved_cs_client */;
75
76--
77-- Dumping data for table `cliente`
78--
79
80LOCK TABLES `cliente` WRITE;
81/*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
82INSERT INTO `cliente` VALUES ('Isaac','Jesus','999876222-12',1,'Alvorada','3-B','Jurema','Proximo a Garagem Azul','45020-123','Vitoria da Conquista-BA','isaacjesus@gmail.com','77-3424-3635','77-991134875'),('Alana','Mirela','103148981-90',2,'Pará','15','Santa Terezinha I','Proximo a Padaria','35171-130','Vitoria da Conquista-BA','alanamir@gmail.com','77-3424-7812','77-988524784'),('Brenda','Heloisa','553675195-63',3,'Raizinha','20-A','Canelas','Proximo a Praça','78148-150','Vitoria da Conquista-BA','brenda_helo@hotmail.com','','77-988011521'),('Paulo','Enrico','671505322-76',4,'Angico','50','Jardim Imperial II','Proximo ao Supermercado','78076-090','Vitoria da Conquista-BA','p_enrico@live.com','77-3424-9645',''),('Aline','Macedo','207148189-90',5,'Amazonas','153','Santa Terezinha III','Proximo a Padaria','35171-130','Vitoria da Conquista-BA','alinemac@gmail.com','','77-988524784'),('João','Pedro','282627230-66',6,'Canela','80','Ceilãndia','Proximo a Igreja','72255-316','Vitoria da Conquista-BA','joaopedr@gmail.com','77-3424-0124','77-991175601'),('Isaac','Souza','554423999-20',7,'Itapuã','52','Brasil','Igreja','45000-500','VCA/BA','isaacsouza@mail.com','778855-2000','779520-3020');
83/*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
84UNLOCK TABLES;
85
86--
87-- Table structure for table `compra`
88--
89
90DROP TABLE IF EXISTS `compra`;
91/*!40101 SET @saved_cs_client = @@character_set_client */;
92/*!40101 SET character_set_client = utf8 */;
93CREATE TABLE `compra` (
94 `entrega_cliente` enum('Entregue','Pendente','Cancelado') DEFAULT NULL,
95 `status_compra` enum('Pago','Pendente','Cancelado') DEFAULT NULL,
96 `id_produto` int(11) DEFAULT NULL,
97 `id_revendedor` int(11) DEFAULT NULL,
98 `id_cliente` int(11) DEFAULT NULL,
99 `data_compra` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
100 `data_entrega` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
101 `codigo_compra` int(11) NOT NULL,
102 `id_chave` int(11) NOT NULL AUTO_INCREMENT,
103 PRIMARY KEY (`id_chave`),
104 KEY `id_revendedor` (`id_revendedor`),
105 KEY `id_cliente` (`id_cliente`),
106 KEY `id_produto` (`id_produto`),
107 CONSTRAINT `compra_ibfk_1` FOREIGN KEY (`id_revendedor`) REFERENCES `revendedor` (`id_revendedor`),
108 CONSTRAINT `compra_ibfk_2` FOREIGN KEY (`id_cliente`) REFERENCES `cliente` (`id_cliente`),
109 CONSTRAINT `compra_ibfk_3` FOREIGN KEY (`id_produto`) REFERENCES `produto` (`id_produto`)
110) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `compra`
115--
116
117LOCK TABLES `compra` WRITE;
118/*!40000 ALTER TABLE `compra` DISABLE KEYS */;
119INSERT INTO `compra` VALUES ('Entregue','Pago',6,1,2,'2016-04-24 22:51:39','2016-04-24 22:51:39',5,1),('Pendente','Pendente',1,1,2,'2016-04-24 22:51:39','2016-04-24 22:51:39',5,2),('Entregue','Pago',4,1,2,'2016-04-24 22:51:39','2016-04-24 22:51:39',5,3),('Entregue','Pago',2,1,6,'2016-04-24 22:53:06','2016-04-24 22:53:06',11,4),('Pendente','Pendente',5,1,6,'2016-04-24 22:53:06','2016-04-24 22:53:06',11,5),('Pendente','Pago',2,1,6,'2016-04-24 22:53:06','2016-04-24 22:53:06',11,6),('Entregue','Pendente',6,1,6,'2016-04-24 22:53:06','2016-04-24 22:53:06',11,7),('Entregue','Pago',3,1,6,'2016-04-24 22:53:06','2016-04-24 22:53:06',11,8),('Entregue','Pago',6,1,7,'2016-04-25 18:19:58','2016-04-25 18:19:58',9,9),('Entregue','Pago',1,1,7,'2016-04-25 18:19:58','2016-04-25 18:19:58',9,10),('Entregue','Pago',2,1,1,'2016-04-25 20:04:37','2016-04-25 20:04:37',2,11);
120/*!40000 ALTER TABLE `compra` ENABLE KEYS */;
121UNLOCK TABLES;
122
123--
124-- Table structure for table `produto`
125--
126
127DROP TABLE IF EXISTS `produto`;
128/*!40101 SET @saved_cs_client = @@character_set_client */;
129/*!40101 SET character_set_client = utf8 */;
130CREATE TABLE `produto` (
131 `nome_produto` varchar(50) DEFAULT NULL,
132 `id_produto` int(11) NOT NULL AUTO_INCREMENT,
133 `codigo_revista` varchar(11) DEFAULT NULL,
134 `descricao` varchar(80) DEFAULT NULL,
135 `valor` double DEFAULT NULL,
136 `unid_medida` enum('Mililitros','Gramas') DEFAULT NULL,
137 `quantidade_ml` int(11) DEFAULT NULL,
138 `fornecedor` varchar(20) DEFAULT NULL,
139 `ciclo_campanha` varchar(11) DEFAULT NULL,
140 PRIMARY KEY (`id_produto`)
141) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `produto`
146--
147
148LOCK TABLES `produto` WRITE;
149/*!40000 ALTER TABLE `produto` DISABLE KEYS */;
150INSERT INTO `produto` VALUES ('Musk',1,'90-BE','Perfume',14,'Mililitros',100,'Avon','15'),('Kaiak',2,'50-GB','Perfume',30.99,'Mililitros',100,'O Boticário','15'),('Egeo',3,'60-DV','Creme',12.9,'Gramas',40,'Natura','45'),('Lily',4,'3B-45','Creme',15.99,'Gramas',80,'Natura','45'),('Galbe',5,'20-DF','Perfume',12.4,'Mililitros',120,'O Boticário','12'),('Renew',6,'10-87','Creme',47.99,'Gramas',30,'Avon','15');
151/*!40000 ALTER TABLE `produto` ENABLE KEYS */;
152UNLOCK TABLES;
153
154--
155-- Table structure for table `revendedor`
156--
157
158DROP TABLE IF EXISTS `revendedor`;
159/*!40101 SET @saved_cs_client = @@character_set_client */;
160/*!40101 SET character_set_client = utf8 */;
161CREATE TABLE `revendedor` (
162 `nome` varchar(50) DEFAULT NULL,
163 `sobrenome` varchar(50) DEFAULT NULL,
164 `cpf_revendedor` varchar(15) DEFAULT NULL,
165 `id_revendedor` int(11) NOT NULL AUTO_INCREMENT,
166 `email` varchar(50) DEFAULT NULL,
167 PRIMARY KEY (`id_revendedor`)
168) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
169/*!40101 SET character_set_client = @saved_cs_client */;
170
171--
172-- Dumping data for table `revendedor`
173--
174
175LOCK TABLES `revendedor` WRITE;
176/*!40000 ALTER TABLE `revendedor` DISABLE KEYS */;
177INSERT INTO `revendedor` VALUES ('Jose','Amaral','88899900-23',1,'jose@mail.com');
178/*!40000 ALTER TABLE `revendedor` ENABLE KEYS */;
179UNLOCK TABLES;
180/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
181
182/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
183/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
184/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
185/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
186/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
187/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
188/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
189
190-- Dump completed on 2016-04-25 19:36:24