CREATE TABLE IF NOT EXISTS `module_hr_compl_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `func` int NOT NULL,
  `civil` int NULL,
  `skin` int NULL,
  `func_sector` int NULL,
  `func_carg` int NULL,
  `func_salary` varchar(20) NULL,
  `naturalit` varchar(100) NULL,
  `nationalit` varchar(100) NULL,
  `name_conj` varchar(100) NULL,
  `cpf_conj` varchar(20) NULL,
  `num_reservista` int NULL,
  `num_ctps` int NULL,
  `ser_ctps` varchar(20) NULL,
  `uf_ctps` int NULL,
  `dt_ctps` date NULL,
  `pis` int NULL,
  `rg_org_emiss` varchar(20) NULL,
  `rg_uf` int NULL,
  `rg_dt_emiss` date NULL,
  `dgr_instruction` int NULL,
  `num_titulo_eleit` int NULL,
  `zon_titulo_eleit` varchar(20) NULL,
  `sec_titulo_eleit` varchar(20) NULL,
  `cnh` int NULL,
  `cat_cnh` int NULL,
  `bank` int NULL,
  `bank_cc` varchar(12) NULL,
  `bank_dg` varchar(5) NULL,
  `bank_ag` varchar(10) NULL,
  `func_dt_admss` date NULL,
  `cost_center` int NULL,
  `payment_type` int NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `module_hr_empl_files` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `func` int NULL,
  `file_rg` varchar(50) NULL,
  `file_cpf` varchar(100) NULL,
  `file_tit_eleitor` varchar(100) NULL,
  `file_compr_escolaridade` varchar(100) NULL,
  `file_cnh` varchar(100) NULL,
  `file_reservista` varchar(100) NULL,
  `file_compr_residencia` varchar(100) NULL,
  `file_ctps` varchar(100) NULL,
  `file_ex_med_ocu_adm` varchar(100) NULL,
  `file_pic_employe` varchar(100) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `module_hr_job_journey` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `func` int NOT NULL,
  `ind_dia` int NOT NULL,
  `hr_ini_manha` varchar(5) NULL,
  `hr_fim_manha` varchar(5) NULL,
  `hr_ini_tarde` varchar(5) NULL,
  `hr_fim_tarde` varchar(5) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `module_hr_sectors` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `module_hr_functions` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `module_hr_suns` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `func` int NOT NULL,
  `nome` varchar(70) NULL,
  `nascto_dt` date NULL,
  `nascto_local` varchar(100) NULL,
  `livro` varchar(100) NULL,
  `cartorio` varchar(100) NULL,
  `registro` varchar(100) NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `module_hr_points` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `func` int NOT NULL,
  `time_entry` varchar(8) NOT NULL,
  `time_out` varchar(8) NULL,
  `date` datetime default now(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ERP-402 André CAMARGO 01/2018
ALTER TABLE `sys_users` 
ADD COLUMN `crm_accounts_id` INT NULL;

ALTER TABLE `module_hr_empl_files` 
ADD COLUMN `file_digit_signature` VARCHAR(100) NULL AFTER `file_pic_employe`;

ALTER TABLE `module_hr_compl_data` 
ADD COLUMN `sales_comission` DECIMAL(20,2) NULL AFTER `payment_type`,
ADD COLUMN `profission` INT NULL AFTER `sales_comission`,
ADD COLUMN `registry_advice` VARCHAR(45) NULL AFTER `profission`,
ADD COLUMN `registry_uf` INT NULL AFTER `registry_advice`,
ADD COLUMN `registry_desc` VARCHAR(45) NULL AFTER `registry_uf`,
ADD COLUMN `obs_registry_professional` VARCHAR(100) NULL AFTER `registry_desc`;

INSERT INTO `sys_roles` (`rname`) VALUES ('Provider');

-- LEONARDO LOPES RAMOS 
-- 23/05/2019
ALTER TABLE `module_hr_compl_data` 
ADD COLUMN `cbos` INT(10) NULL,
ADD COLUMN `cnes` INT(10) NULL;


-- LEONARDO LOPES RAMOS 
-- 17/04/2020
ALTER TABLE `module_hr_compl_data` 
ADD COLUMN `product_category` VARCHAR(45) NULL;