SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';


-- -----------------------------------------------------
-- Table `osw_clientes`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `osw_clientes` ;

CREATE  TABLE IF NOT EXISTS `osw_clientes` (
  `ows_cli_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `ows_cli_nome` VARCHAR(45) NOT NULL ,
  `ows_cli_username` VARCHAR(25) NOT NULL ,
  `ows_cli_senha` VARCHAR(32) NOT NULL ,
  `ows_cli_ativo` TINYINT(1)  NOT NULL ,
  `ows_cli_ip` VARCHAR(45) NULL ,
  PRIMARY KEY (`ows_cli_id`) ,
  UNIQUE INDEX `ows_cli_nome_UNIQUE` (`ows_cli_nome` ASC) ,
  UNIQUE INDEX `ows_cli_username_UNIQUE` (`ows_cli_username` ASC) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `osw_chamados`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `osw_chamados` ;

CREATE  TABLE IF NOT EXISTS `osw_chamados` (
  `ows_cha_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `ows_cha_cliente` INT UNSIGNED NOT NULL ,
  `ows_cha_codigo` VARCHAR(20) NOT NULL ,
  `ows_cha_nome` VARCHAR(50) NULL ,
  `ows_cha_pessoa` VARCHAR(1) NULL ,
  `ows_cha_pfisica` VARCHAR(12) NULL ,
  `ows_cha_cgc` VARCHAR(14) NULL ,
  `ows_cha_email` VARCHAR(40) NULL ,
  `ows_cha_tipo` VARCHAR(1) NULL ,
  `ows_cha_endereco` VARCHAR(50) NULL ,
  `ows_cha_compl` VARCHAR(40) NULL ,
  `ows_cha_bairro` VARCHAR(40) NULL ,
  `ows_cha_mun` VARCHAR(40) NULL ,
  `ows_cha_est` VARCHAR(2) NULL ,
  `ows_cha_cep` VARCHAR(8) NULL ,
  `ows_cha_ddd` VARCHAR(2) NULL ,
  `ows_cha_tel` VARCHAR(9) NULL ,
  `ows_cha_ddd2` VARCHAR(2) NULL ,
  `ows_cha_tel2` VARCHAR(9) NULL ,
  `ows_cha_dddcel` VARCHAR(2) NULL ,
  `ows_cha_cel` VARCHAR(10) NULL ,
  `ows_cha_nreduz` VARCHAR(30) NULL ,
  `ows_cha_dtipee` VARCHAR(1) NULL ,
  `ows_cha_endent` VARCHAR(40) NULL ,
  `ows_cha_comple` VARCHAR(40) NULL ,
  `ows_cha_bairroe` VARCHAR(40) NULL ,
  `ows_cha_mune` VARCHAR(40) NULL ,
  `ows_cha_este` VARCHAR(2) NULL ,
  `ows_cha_cepe` VARCHAR(8) NULL ,
  `ows_cha_ptref` VARCHAR(40) NULL ,
  `ows_cha_coderp` INT NULL ,
  `ows_cha_dt_registro` DATETIME NOT NULL ,
  `ows_cha_dt_retorno` DATETIME NULL ,
  `ows_ate_atendente` VARCHAR(30) NULL ,
  `ows_ate_autoagendamento` VARCHAR(1) NULL ,
  `ows_ate_codobs` VARCHAR(100) NULL ,
  `ows_ate_dtagendamento` VARCHAR(10) NULL ,
  `ows_ate_dtempresa` VARCHAR(10) NULL ,
  `ows_ate_hrempresa` VARCHAR(5) NULL ,
  `ows_ate_prioridade` VARCHAR(20) NULL ,
  `ows_ate_visita` VARCHAR(1) NULL ,
  PRIMARY KEY (`ows_cha_id`) ,
  INDEX `fk_osw_chamados_osw_clientes` (`ows_cha_cliente` ASC) ,
  CONSTRAINT `fk_osw_chamados_osw_clientes`
    FOREIGN KEY (`ows_cha_cliente` )
    REFERENCES `osw_clientes` (`ows_cli_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ows_itens_atendimento`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `ows_itens_atendimento` ;

CREATE  TABLE IF NOT EXISTS `ows_itens_atendimento` (
  `ows_ia_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `ows_ia_chamado` INT UNSIGNED NOT NULL ,
  `ows_ia_condicao` VARCHAR(45) NULL ,
  `ows_ia_tipo_atendimento` VARCHAR(30) NULL ,
  `ows_ia_produtorec` VARCHAR(15) NULL ,
  `ows_ia_descprodrec` VARCHAR(80) NULL ,
  `ows_ia_qtdret` DECIMAL(7,2) NULL ,
  `ows_ia_quant` DECIMAL(7,2) NULL ,
  `ows_ia_lote` VARCHAR(10) NULL ,
  `ows_ia_validlote` VARCHAR(10) NULL ,
  `ows_ia_destino` VARCHAR(30) NULL ,
  `ows_ia_observacao` VARCHAR(100) NULL ,
  `ows_ia_descprod` VARCHAR(85) NULL ,
  `ows_ia_produto` VARCHAR(15) NULL ,
  `ows_ia_qtdberta` DECIMAL(7,2) NULL ,
  `ows_ia_fabrlote` VARCHAR(10) NULL ,
  `ows_ia_item` VARCHAR(3) NULL ,
  `ows_ia_reclamacao` VARCHAR(40) NULL ,
  `ows_ia_sequencia` VARCHAR(10) NULL ,
  `ows_ia_um` VARCHAR(2) NULL ,
  `ows_ia_vlritem` DECIMAL(7,2) NULL ,
  `ows_ia_vrunit` DECIMAL(7,2) NULL ,
  `ows_ia_coderp` INT NULL ,
  `ows_ia_dt_retorno` DATETIME NULL ,
  PRIMARY KEY (`ows_ia_id`) ,
  INDEX `fk_ows_itens_atendimento_osw_chamados1` (`ows_ia_chamado` ASC) ,
  CONSTRAINT `fk_ows_itens_atendimento_osw_chamados1`
    FOREIGN KEY (`ows_ia_chamado` )
    REFERENCES `osw_chamados` (`ows_cha_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ows_followup_prestador`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `ows_followup_prestador` ;

CREATE  TABLE IF NOT EXISTS `ows_followup_prestador` (
  `ows_fwp_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `ows_fwp_empresa` VARCHAR(2) NULL ,
  `ows_fwp_filial` VARCHAR(2) NULL ,
  `ows_fwp_usuario` VARCHAR(6) NULL ,
  `ows_fwp_protocolo` VARCHAR(20) NULL ,
  `ows_fwp_tipo` VARCHAR(60) NULL ,
  `ows_fwp_sequencia` VARCHAR(2) NULL ,
  `ows_fwp_produto` VARCHAR(15) NULL ,
  `ows_fwp_texto` VARCHAR(255) NULL ,
  `ows_fwp_emissao` VARCHAR(10) NULL ,
  `ows_fwp_acao` VARCHAR(10) NULL ,
  `ows_fwp_dt_registro` DATETIME NOT NULL ,
  `ows_fwp_dt_retorno` DATETIME NULL ,
  `ows_fwp_coderp` INT NULL ,
  `ows_fwp_cliente` INT UNSIGNED NOT NULL ,
  PRIMARY KEY (`ows_fwp_id`) ,
  INDEX `fk_ows_followup_prestador_osw_clientes1` (`ows_fwp_cliente` ASC) ,
  CONSTRAINT `fk_ows_followup_prestador_osw_clientes1`
    FOREIGN KEY (`ows_fwp_cliente` )
    REFERENCES `osw_clientes` (`ows_cli_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ows_followup_cliente`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `ows_followup_cliente` ;

CREATE  TABLE IF NOT EXISTS `ows_followup_cliente` (
  `ows_fwc_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `ows_fwc_str_id_chamado` VARCHAR(20) NULL ,
  `ows_fwc_str_produto` VARCHAR(20) NULL ,
  `ows_fwc_str_evento_foup` VARCHAR(60) NULL ,
  `ows_fwc_str_ds_foup` VARCHAR(255) NULL ,
  `ows_fwc_dt_registro` DATE NULL ,
  `ows_fwc_dt_acao` DATE NULL ,
  `ows_fwc_sem_amostra` VARCHAR(45) NULL ,
  `ows_fwc_recebido_por` VARCHAR(50) NULL ,
  `ows_fwc_id_idioma` VARCHAR(1) NULL ,
  `ows_fwc_str_num_sedex` VARCHAR(20) NULL ,
  `ows_fwc_coderp` INT NULL ,
  `ows_fwc_dt_importacao` DATETIME NULL ,
  `ows_fwc_dt_envio` DATETIME NULL ,
  `ows_fwc_retorno` VARCHAR(255) NULL ,
  `ows_fwc_cliente` INT UNSIGNED NOT NULL ,
  PRIMARY KEY (`ows_fwc_id`) ,
  INDEX `fk_ows_followup_cliente_osw_chamados1` (`ows_fwc_cliente` ASC) ,
  CONSTRAINT `fk_ows_followup_cliente_osw_chamados1`
    FOREIGN KEY (`ows_fwc_cliente` )
    REFERENCES `osw_chamados` (`ows_cha_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ows_cli_log`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `ows_cli_log` ;

CREATE  TABLE IF NOT EXISTS `ows_cli_log` (
  `ows_cl_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `ows_cl_data` DATETIME NOT NULL ,
  `ows_cl_alerta` TINYINT(1)  NOT NULL ,
  `ows_cl_ip` VARCHAR(45) NULL ,
  `ows_cl_info` VARCHAR(255) NULL ,
  `ows_cl_cliente` INT UNSIGNED NOT NULL ,
  PRIMARY KEY (`ows_cl_id`) ,
  INDEX `fk_ows_cli_log_osw_clientes1` (`ows_cl_cliente` ASC) ,
  CONSTRAINT `fk_ows_cli_log_osw_clientes1`
    FOREIGN KEY (`ows_cl_cliente` )
    REFERENCES `osw_clientes` (`ows_cli_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;



SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;