-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Tempo de geração: 02-Mar-2022 às 21:36
-- Versão do servidor: 5.7.37
-- versão do PHP: 7.3.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Banco de dados: `grupo3w_newsletter`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `ws_queue_contacts`
--

CREATE TABLE `ws_queue_contacts` (
  `contact_id` int(11) UNSIGNED NOT NULL,
  `contact_name` varchar(60) NOT NULL DEFAULT '',
  `contact_email` varchar(160) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `ws_queue_contacts`
--

INSERT INTO `ws_queue_contacts` (`contact_id`, `contact_name`, `contact_email`) VALUES
(1, 'wildner', 'wildner@3wnetcom.com.br');

-- --------------------------------------------------------

--
-- Estrutura da tabela `ws_queue_email`
--

CREATE TABLE `ws_queue_email` (
  `email_id` int(11) UNSIGNED NOT NULL,
  `email_fromname` varchar(60) NOT NULL DEFAULT '',
  `email_fromemail` varchar(160) NOT NULL DEFAULT '',
  `email_subject` varchar(255) NOT NULL DEFAULT '(sem assunto)',
  `email_body` text NOT NULL,
  `email_priority` int(1) NOT NULL DEFAULT '3',
  `email_limitsend` int(6) NOT NULL DEFAULT '0',
  `email_end` int(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `ws_queue_email`
--

INSERT INTO `ws_queue_email` (`email_id`, `email_fromname`, `email_fromemail`, `email_subject`, `email_body`, `email_priority`, `email_limitsend`, `email_end`) VALUES
(1, '3wnetcom', 'ge@grupo3w.com.br', 'Teste', 'Teste do sistema de newsletter', 3, 0, 0);

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `ws_queue_contacts`
--
ALTER TABLE `ws_queue_contacts`
  ADD PRIMARY KEY (`contact_id`),
  ADD UNIQUE KEY `EMAIL` (`contact_email`);

--
-- Índices para tabela `ws_queue_email`
--
ALTER TABLE `ws_queue_email`
  ADD PRIMARY KEY (`email_id`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `ws_queue_contacts`
--
ALTER TABLE `ws_queue_contacts`
  MODIFY `contact_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `ws_queue_email`
--
ALTER TABLE `ws_queue_email`
  MODIFY `email_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
