ND2MeLPf

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : localhost
5Source Server Version : 50558
6Source Host           : localhost:3306
7Source Database       : mailing
8
9Target Server Type    : MYSQL
10Target Server Version : 50558
11File Encoding         : 65001
12
13Date: 2017-12-11 15:45:27
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for contatos
20-- ----------------------------
21DROP TABLE IF EXISTS `contatos`;
22CREATE TABLE `contatos` (
23  `id_contato` int(11) unsigned NOT NULL AUTO_INCREMENT,
24  `email` varchar(255) NOT NULL,
25  PRIMARY KEY (`id_contato`)
26) ENGINE=InnoDB AUTO_INCREMENT=15096 DEFAULT CHARSET=utf8;
27
28-- ----------------------------
29-- Table structure for envios
30-- ----------------------------
31DROP TABLE IF EXISTS `envios`;
32CREATE TABLE `envios` (
33  `id_envio` int(11) unsigned NOT NULL AUTO_INCREMENT,
34  `id_mensagem` int(11) unsigned NOT NULL,
35  `id_contato` int(11) unsigned NOT NULL,
36  `id_remetente` int(11) unsigned NOT NULL,
37  `data_registro` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
38  `status` enum('ENVIADO','AGUARDANDO','ENVIANDO','ERRO') NOT NULL DEFAULT 'AGUARDANDO',
39  PRIMARY KEY (`id_envio`),
40  KEY `id_mensagem` (`id_mensagem`) USING BTREE,
41  KEY `id_contato` (`id_contato`) USING BTREE,
42  KEY `id_remetente` (`id_remetente`) USING BTREE,
43  CONSTRAINT `envios_ibfk_1` FOREIGN KEY (`id_remetente`) REFERENCES `remetentes` (`id_remetente`) ON DELETE CASCADE ON UPDATE CASCADE,
44  CONSTRAINT `envios_ibfk_2` FOREIGN KEY (`id_mensagem`) REFERENCES `mensagens` (`id_mensagem`) ON DELETE CASCADE ON UPDATE CASCADE,
45  CONSTRAINT `envios_ibfk_3` FOREIGN KEY (`id_contato`) REFERENCES `contatos` (`id_contato`) ON DELETE CASCADE ON UPDATE CASCADE
46) ENGINE=InnoDB AUTO_INCREMENT=14946 DEFAULT CHARSET=utf8;
47
48-- ----------------------------
49-- Table structure for mensagens
50-- ----------------------------
51DROP TABLE IF EXISTS `mensagens`;
52CREATE TABLE `mensagens` (
53  `id_mensagem` int(11) unsigned NOT NULL AUTO_INCREMENT,
54  `remetente` varchar(255) NOT NULL,
55  `assunto` varchar(255) NOT NULL,
56  `conteudo` longtext NOT NULL,
57  `data_envio` datetime DEFAULT NULL,
58  `request_url` text NOT NULL,
59  `data_registro` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
60  PRIMARY KEY (`id_mensagem`)
61) ENGINE=InnoDB AUTO_INCREMENT=15202 DEFAULT CHARSET=utf8;
62
63-- ----------------------------
64-- Table structure for remetentes
65-- ----------------------------
66DROP TABLE IF EXISTS `remetentes`;
67CREATE TABLE `remetentes` (
68  `id_remetente` int(11) unsigned NOT NULL AUTO_INCREMENT,
69  `email` varchar(60) NOT NULL,
70  `senha` varchar(32) NOT NULL,
71  `status` enum('A','I') NOT NULL DEFAULT 'A',
72  PRIMARY KEY (`id_remetente`)
73) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
74SET FOREIGN_KEY_CHECKS=1;