Here is the complete HTML translated into French, with the language set to `fr` and the FR link marked as active. ```html #1469 : V7.0.0.5__7.0.0.5-RELEASE.sql [FR]
EN · DE · RU · FR · ES
← Index · ← Index des fichiers · ← Précédent · Suivant → · 📄 source

#1469 : V7.0.0.5__7.0.0.5-RELEASE.sql

projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.5__7.0.0.5-RELEASE.sql Type : Migration SQL Flyway · Base de données : Commune · Source : projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.5__7.0.0.5-RELEASE.sql 25 lignes · 20 lignes de code · 0 commentaires · 5 lignes vides
Script de migration de base de données Flyway pour la base commune. Contient des instructions SQL DDL/DML pour l'évolution du schéma.

Modifications du schéma

CREATE TABLE t_employee_vacation_remaining

Modifications de tables

ALTER TABLE t_employee_vacation_remaining
ALTER TABLE t_employee_vacation_remaining
ALTER TABLE t_employee_vacation_remaining
ALTER TABLE t_employee_vacation_remaining

Contenu SQL

CREATE TABLE t_employee_vacation_remaining (
  pk                                     INTEGER                      NOT NULL,
  deleted                                BOOLEAN                      NOT NULL,
  created                                TIMESTAMP WITHOUT TIME ZONE,
  last_update                            TIMESTAMP WITHOUT TIME ZONE,
  tenant_id                              INTEGER,
  employee_id                            INTEGER                      NOT NULL,
  year                                   INTEGER                      NOT NULL,
  carry_vacation_days_from_previous_year NUMERIC(5, 2)                NOT NULL
);

ALTER TABLE t_employee_vacation_remaining
  ADD CONSTRAINT t_employee_vacation_remaining_pkey PRIMARY KEY (pk);

ALTER TABLE t_employee_vacation_remaining
  ADD CONSTRAINT unique_t_employee_vacation_remaining UNIQUE (tenant_id, employee_id, year);

CREATE INDEX idx_fk_t_vacation_remaining_employee_id
  ON t_employee_vacation_remaining (pk);

ALTER TABLE t_employee_vacation_remaining
  ADD CONSTRAINT t_employee_vacation_remaining_tenant_fk FOREIGN KEY (tenant_id) REFERENCES t_tenant (pk);

ALTER TABLE t_employee_vacation_remaining
  ADD CONSTRAINT t_employee_vacation_remaining_employee_fk FOREIGN KEY (employee_id) REFERENCES t_fibu_employee (pk);

Historique Git

3f3d6460a Migration des jours de congés reportés de l'attribut employé vers une nouvelle table.
9a68e0062 WIP : Migration des congés : VacationService.java -> VacationCalendarService.java, VacationSendMailService.java et VacationService.kt.
64ff77aa1 Ajout de RemainingDaysOfVacationDO/Dao.