/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 10.4.10-MariaDB : Database - jacob
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
create database /*!32312 IF NOT EXISTS*/`jacob` /*!40100 DEFAULT CHARACTER SET latin1 */;

use `jacob`;

/*Table structure for table `rast_cli` */

drop table if exists `academ_cli`;

create table `academ_cli` (
  `idinstituicao_academ_cli` int(11) default null,
  `id_academ_cli` int(11) not null auto_increment,
  `idpessoa_academ_cli` int(11) default null,
  `idpessoasub_academ_cli` int(11) default 0,
  `cadastro_academ_cli` date default null,
  `foto_academ_cli` varchar(200) default null,
  `idstatus_academ_cli` int(11) default null,
  `criacao_academ_cli` timestamp not null default current_timestamp(),
  `idcriacao_academ_cli` int(11) default null,
  `modificacao_academ_cli` timestamp not null default current_timestamp() on update current_timestamp(),
  `idmodificacao_academ_cli` int(11) default null,
  `delete_academ_cli` int(1) default 0,
  `iddelete_academ_cli` int(11) default null,
  primary key (`id_academ_cli`),
  key `fk_pessoa_academcli` (`idpessoa_academ_cli`),
  key `fk_status_academcli` (`idstatus_academ_cli`),
  key `fk_instituicao_rastcli` (`idinstituicao_academ_cli`),
  constraint `fk_instituicao_academcli` foreign key (`idinstituicao_academ_cli`) references `global_instituicao` (`id_instituicao`),
  constraint `fk_pessoa_academcli` foreign key (`idpessoa_academ_cli`) references `global_pessoa` (`id_pessoa`),
  constraint `fk_status_academcli` foreign key (`idstatus_academ_cli`) references `global_status` (`id_status`)
) engine=innodb auto_increment=103 default charset=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;