EN · DE · RU · FR · ES
← Index · ← File index · ← Prev · Next → · 📄 source

#1505: V8.0.8__RELEASE-MGC_additions.sql

projectforge-business/src/main/resources/flyway/migrate/hsqldb/V8.0.8__RELEASE-MGC_additions.sql Type: Flyway SQL Migration · Database: HSQLDB · Source: projectforge-business/src/main/resources/flyway/migrate/hsqldb/V8.0.8__RELEASE-MGC_additions.sql 10 lines · 9 code · 0 comments · 1 blank
Flyway database migration script for HSQLDB. Contains SQL DDL/DML statements for schema evolution.

Table Alterations

ALTER TABLE t_fibu_employee
ALTER TABLE t_fibu_employee
ALTER TABLE t_fibu_employee
ALTER TABLE t_fibu_employee
ALTER TABLE t_fibu_employee
ALTER TABLE t_fibu_employee

SQL Content

-- Fix columns in table employee.
ALTER TABLE t_fibu_employee ADD COLUMN new_eintritt DATE;
UPDATE t_fibu_employee SET new_eintritt = CAST(eintritt AS DATE);
ALTER TABLE t_fibu_employee DROP COLUMN eintritt;
ALTER TABLE t_fibu_employee ALTER COLUMN new_eintritt RENAME TO eintritt;

ALTER TABLE t_fibu_employee ADD COLUMN new_austritt DATE;
UPDATE t_fibu_employee SET new_austritt = CAST(austritt AS DATE);
ALTER TABLE t_fibu_employee DROP COLUMN austritt;
ALTER TABLE t_fibu_employee ALTER COLUMN new_austritt RENAME TO austritt;

Git History

28efde264 Employee: weeklyWorkingHours now as time-dependent attr. eintritt/austritt: timestamp -> date Drop old DB tables. in MGC release, some fk in the db were forgotten to switch type from int to bigint.