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

Schema Changes

Table Alterations

SQL Content

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

Git History

3f3d6460a Migration of carry vacation days from employee attribute to new table.
9a68e0062 WIP: Migration of vacation: VacationService.java -> VacationCalendarService.java, VacationSendMailService.java and VacationService.kt.
64ff77aa1 RemainingDaysOfVacationDO/Dao added.