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;