Here is the HTML translated to Spanish, with the language set to `es`, the ES link marked as active, and the title updated with `[ES]`. ```html #1469: V7.0.0.5__7.0.0.5-RELEASE.sql [ES]
EN · DE · RU · FR · ES
← Índice · ← Índice de archivos · ← Anterior · Siguiente → · 📄 fuente

#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 Tipo: Migración SQL Flyway · Base de datos: Común · Fuente: projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.5__7.0.0.5-RELEASE.sql 25 líneas · 20 código · 0 comentarios · 5 en blanco
Script de migración de base de datos Flyway para Común. Contiene sentencias SQL DDL/DML para la evolución del esquema.

Cambios en el esquema

CREATE TABLE t_employee_vacation_remaining

Alteraciones de tablas

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

Contenido 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);

Historial de Git

3f3d6460a Migración de días de vacaciones transferidos del atributo de empleado a nueva tabla.
9a68e0062 WIP: Migración de vacaciones: VacationService.java -> VacationCalendarService.java, VacationSendMailService.java y VacationService.kt.
64ff77aa1 RemainingDaysOfVacationDO/Dao añadido.