wb10d59p

1CREATE DATABASE  IF NOT EXISTS `empresa` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `empresa`;
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
9/*!40103 SET TIME_ZONE='+00:00' */;
10/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
14
15--
16-- Table structure for table `comissao`
17--
18
19DROP TABLE IF EXISTS `comissao`;
20/*!40101 SET @saved_cs_client     = @@character_set_client */;
21/*!40101 SET character_set_client = utf8 */;
22CREATE TABLE `comissao` (
23  `pes_codigo` int(11) NOT NULL,
24  `men_codigo` int(11) NOT NULL,
25  `com_valor` decimal(8,2) NOT NULL,
26  PRIMARY KEY (`pes_codigo`,`men_codigo`),
27  KEY `Id_Msg` (`men_codigo`),
28  CONSTRAINT `comissao_ibfk_1` FOREIGN KEY (`pes_codigo`) REFERENCES `pessoa` (`pes_codigo`),
29  CONSTRAINT `comissao_ibfk_2` FOREIGN KEY (`men_codigo`) REFERENCES `mensagem` (`men_codigo`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `comissao`
35--
36
37LOCK TABLES `comissao` WRITE;
38/*!40000 ALTER TABLE `comissao` DISABLE KEYS */;
39INSERT INTO `comissao` VALUES (14,10,10500.00),(14,60,2600.00),(14,70,400.00),(14,100,3750.00),(25,10,2500.00),(25,30,370.00),(37,10,5500.00),(37,30,14230.00),(37,40,20.00),(37,50,120.00),(42,20,20.00),(42,30,170.00),(49,20,2300.00);
40/*!40000 ALTER TABLE `comissao` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `mensagem`
45--
46
47DROP TABLE IF EXISTS `mensagem`;
48/*!40101 SET @saved_cs_client     = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `mensagem` (
51  `men_codigo` int(11) NOT NULL,
52  `men_descricao` varchar(30) NOT NULL,
53  PRIMARY KEY (`men_codigo`)
54) ENGINE=InnoDB DEFAULT CHARSET=utf8;
55/*!40101 SET character_set_client = @saved_cs_client */;
56
57--
58-- Dumping data for table `mensagem`
59--
60
61LOCK TABLES `mensagem` WRITE;
62/*!40000 ALTER TABLE `mensagem` DISABLE KEYS */;
63INSERT INTO `mensagem` VALUES (10,'Comissão de Vendas'),(20,'Fretes Individuais'),(30,'Fretes Empresas'),(40,'Vendas Extra'),(50,'Deslocações'),(60,'Refeições'),(70,'Combustíveis'),(80,'Transportes'),(90,'Telefonemas'),(100,'Ofertas');
64/*!40000 ALTER TABLE `mensagem` ENABLE KEYS */;
65UNLOCK TABLES;
66
67--
68-- Table structure for table `pessoa`
69--
70
71DROP TABLE IF EXISTS `pessoa`;
72/*!40101 SET @saved_cs_client     = @@character_set_client */;
73/*!40101 SET character_set_client = utf8 */;
74CREATE TABLE `pessoa` (
75  `pes_codigo` int(11) NOT NULL,
76  `pes_nome` varchar(30) NOT NULL,
77  `pes_idade` int(11) NOT NULL,
78  `pes_salario` decimal(8,2) NOT NULL,
79  `pes_telefone` varchar(12) DEFAULT NULL,
80  `pos_codigo` int(11) NOT NULL,
81  PRIMARY KEY (`pes_codigo`),
82  KEY `Cod_Postal` (`pos_codigo`),
83  CONSTRAINT `pessoa_ibfk_1` FOREIGN KEY (`pos_codigo`) REFERENCES `postal` (`pos_codigo`)
84) ENGINE=InnoDB DEFAULT CHARSET=utf8;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `pessoa`
89--
90
91LOCK TABLES `pessoa` WRITE;
92/*!40000 ALTER TABLE `pessoa` DISABLE KEYS */;
93INSERT INTO `pessoa` VALUES (5,'Célia Morais',26,170000.00,'123456',1100),(14,'Nascimento Augusto',35,220000.00,'456123',2300),(25,'Paulo Viegas',32,95000.00,NULL,1500),(32,'Florinda Simões',35,147000.00,NULL,4000),(37,'Isabel Espada',28,86000.00,NULL,1100),(42,'António Dias',43,74000.00,'789654',1500),(49,'José António',17,210000.00,NULL,1500);
94/*!40000 ALTER TABLE `pessoa` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `postal`
99--
100
101DROP TABLE IF EXISTS `postal`;
102/*!40101 SET @saved_cs_client     = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `postal` (
105  `pos_codigo` int(11) NOT NULL,
106  `pos_localidade` varchar(30) NOT NULL,
107  PRIMARY KEY (`pos_codigo`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Dumping data for table `postal`
113--
114
115LOCK TABLES `postal` WRITE;
116/*!40000 ALTER TABLE `postal` DISABLE KEYS */;
117INSERT INTO `postal` VALUES (1000,'LISBOA'),(1100,'LISBOA'),(1200,'LISBOA'),(1500,'LISBOA'),(2000,'SANTAREM'),(2300,'TOMAR'),(3000,'COIMBRA'),(4000,'PORTO'),(9000,'FUNCHAL');
118/*!40000 ALTER TABLE `postal` ENABLE KEYS */;
119UNLOCK TABLES;
120/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
121
122/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
123/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
124/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
125/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
126/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
127/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
128/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
129
130-- Dump completed on 2018-05-08 20:56:52
131