CREATE TABLE `zp_orcamentos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_lead` int(11),
  `id_produto` int(11),
  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `id_lead` (`id_lead`),
  KEY `id_produto` (`id_produto`),
  CONSTRAINT `zp_orcamentos_ibfk_1` FOREIGN KEY (`id_lead`) REFERENCES `zp_leads` (`id`),
  CONSTRAINT `zp_orcamentos_ibfk_2` FOREIGN KEY (`id_produto`) REFERENCES `zp_produtos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `zp_leads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `zp_produtos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;