 CREATE TABLE `tarefas_contrato` (
   `id_tarefas_contrato` int(11) NOT NULL,
   `id_departamento_contrato` int(11) DEFAULT NULL,
+  `data_inicio` varchar(20) DEFAULT NULL,
   `data_fim` varchar(20) DEFAULT NULL,
-  `id_tarefa` int(11) DEFAULT NULL,
-  `id_consultor` int(10) DEFAULT NULL,
-  `horas` int(11) DEFAULT NULL,
-  `id_status_tarefa` int(11) DEFAULT NULL
+  `id_tarefa` int(11) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 --
 -- Extraindo dados da tabela `tarefas_contrato`
 --
 
-INSERT INTO `tarefas_contrato` (`id_tarefas_contrato`, `id_departamento_contrato`, `data_fim`, `id_tarefa`, `id_consultor`, `horas`, `id_status_tarefa`) VALUES
-(1, 1, '20/10/2017', 1, 10, 100, 1),
-(2, 1, '20/10/2017', 2, 10, 1000, 1),
-(3, 1, NULL, 3, NULL, NULL, 1),
-(4, 1, NULL, 4, NULL, NULL, 1),
-(5, 1, NULL, 5, NULL, NULL, 1),
-(6, 1, NULL, 6, NULL, NULL, 1),
-(7, 1, NULL, 7, NULL, NULL, 1),
-(8, 1, NULL, 8, NULL, NULL, 1),
-(9, 2, NULL, 1, NULL, NULL, 1),
-(10, 2, NULL, 2, NULL, NULL, 1),
-(11, 2, NULL, 3, NULL, NULL, 1),
-(12, 2, NULL, 4, NULL, NULL, 1),
-(13, 2, NULL, 5, NULL, NULL, 1),
-(14, 2, NULL, 6, NULL, NULL, 1),
-(15, 2, NULL, 7, NULL, NULL, 1),
-(16, 2, NULL, 8, NULL, NULL, 1),
-(17, 3, NULL, 1, NULL, NULL, 1),
-(18, 3, NULL, 2, NULL, NULL, 1),
-(19, 3, NULL, 3, NULL, NULL, 1),
-(20, 3, NULL, 4, NULL, NULL, 1),
-(21, 3, NULL, 5, NULL, NULL, 1),
-(22, 3, NULL, 6, NULL, NULL, 1),
-(23, 3, NULL, 7, NULL, NULL, 1),
-(24, 3, NULL, 8, NULL, NULL, 1),
-(25, 4, NULL, 1, NULL, NULL, 1),
-(26, 4, NULL, 2, NULL, NULL, 1),
-(27, 4, NULL, 3, NULL, NULL, 1),
-(28, 4, NULL, 4, NULL, NULL, 1),
-(29, 4, NULL, 5, NULL, NULL, 1),
-(30, 4, NULL, 6, NULL, NULL, 1),
-(31, 4, NULL, 7, NULL, NULL, 1),
-(32, 4, NULL, 8, NULL, NULL, 1),
-(33, 9, NULL, 1, NULL, NULL, 1),
-(34, 9, NULL, 2, NULL, NULL, 1),
-(35, 9, NULL, 3, NULL, NULL, 1),
-(36, 9, NULL, 4, NULL, NULL, 1),
-(37, 9, NULL, 5, NULL, NULL, 1),
-(38, 9, NULL, 6, NULL, NULL, 1),
-(39, 9, NULL, 7, NULL, NULL, 1),
-(40, 9, NULL, 8, NULL, NULL, 1),
-(41, 10, NULL, 1, NULL, NULL, 1),
-(42, 10, NULL, 2, NULL, NULL, 1),
-(43, 10, NULL, 3, NULL, NULL, 1),
-(44, 10, NULL, 4, NULL, NULL, 1),
-(45, 10, NULL, 5, NULL, NULL, 1),
-(46, 10, NULL, 6, NULL, NULL, 1),
-(47, 10, NULL, 7, NULL, NULL, 1),
-(48, 10, NULL, 8, NULL, NULL, 1);
+INSERT INTO `tarefas_contrato` (`id_tarefas_contrato`, `id_departamento_contrato`, `data_inicio`, `data_fim`, `id_tarefa`) VALUES
+(1, 1, '20/10/2017', '', 1),
+(2, 1, NULL, NULL, 2),
+(3, 1, NULL, NULL, 3),
+(4, 1, NULL, NULL, 4),
+(5, 1, NULL, NULL, 5),
+(6, 1, NULL, NULL, 6),
+(7, 1, NULL, NULL, 7),
+(8, 1, NULL, NULL, 8),
+(9, 2, NULL, NULL, 1),
+(10, 2, NULL, NULL, 2),
+(11, 2, NULL, NULL, 3),
+(12, 2, NULL, NULL, 4),
+(13, 2, NULL, NULL, 5),
+(14, 2, NULL, NULL, 6),
+(15, 2, NULL, NULL, 7),
+(16, 2, NULL, NULL, 8),
+(17, 3, NULL, NULL, 1),
+(18, 3, NULL, NULL, 2),
+(19, 3, NULL, NULL, 3),
+(20, 3, NULL, NULL, 4),
+(21, 3, NULL, NULL, 5),
+(22, 3, NULL, NULL, 6),
+(23, 3, NULL, NULL, 7),
+(24, 3, NULL, NULL, 8),
+(25, 4, NULL, NULL, 1),
+(26, 4, NULL, NULL, 2),
+(27, 4, NULL, NULL, 3),
+(28, 4, NULL, NULL, 4),
+(29, 4, NULL, NULL, 5),
+(30, 4, NULL, NULL, 6),
+(31, 4, NULL, NULL, 7),
+(32, 4, NULL, NULL, 8);
 
 -- --------------------------------------------------------
 

-- Extraindo dados da tabela `suspects`
--

INSERT INTO `suspects` (`contato`, `data`, `status`, `hora`, `id_consultor`, `id_suspect`, `id_clientes`, `tel`, `email`) VALUES
('WENDERSON MARTINS DE ALMEIDA', '19.09.2017', 'Realizado', '14:00', 10, 12, 40, '(71) 98233-3333', 'wenderson@p7go.com'),
('Petro Petrobras', '05.10.2017', 'Realizado', '12:20', 10, 14, 55, '(71) 98443-4445', 'petro@petrobras.com.br'),
('Maria Ford', '01.01.2034', 'Agendado', '01:23', 15, 16, 61, '(71) 98984-4444', 'maria@ford.com');

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


--

INSERT INTO `pos_venda` (`id_pos_venda`, `id_clientes`, `id_feedback`, `n_contrato`) VALUES
(9, 40, NULL, '44444444');

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

