Skip to content

3.5.4

Choose a tag to compare

@nilsonLazarin nilsonLazarin released this 01 Dec 13:10
· 800 commits to master since this release
7b0139c

What's Changed

Full Changelog: 3.5.3...3.5.4

Banco de dados

Tabelas novas

CREATE TABLE IF NOT EXISTS `wegia`.`contato_instituicao` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `descricao` VARCHAR(256) NOT NULL,
  `contato` VARCHAR(256) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `wegia`.`contribuicao_recibo` (
  `id_recibo` INT(11) NOT NULL AUTO_INCREMENT,
  `codigo` VARCHAR(64) NOT NULL,
  `id_socio` INT(11) NOT NULL,
  `email` VARCHAR(256) NULL DEFAULT NULL,
  `data_inicio` DATE NOT NULL,
  `data_fim` DATE NOT NULL,
  `valor_total` DECIMAL(10,2) NOT NULL,
  `total_contribuicoes` INT NOT NULL,
  `data_geracao` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_recibo`),
  INDEX `fk_contribuicao_recibo_socio` (`id_socio` ASC),
  CONSTRAINT `fk_contribuicao_recibo_socio`
    FOREIGN KEY (`id_socio`)
    REFERENCES `wegia`.`socio` (`id_socio`)
    ON DELETE NO ACTION
    ON UPDATE CASCADE 
)
ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_unicode_ci;

Dados novos

INSERT INTO `contato_instituicao`(`id`, `descricao`, `contato`) VALUES
(1, 'Apoio aos doadores', 'telefone_ou_@email.com');