#1495: V8.0.9__RELEASE_MGC_additions2.sql
projectforge-business/src/main/resources/flyway/migrate/common/V8.0.9__RELEASE_MGC_additions2.sql Type: Flyway SQL Migration · Database: Common · Source: projectforge-business/src/main/resources/flyway/migrate/common/V8.0.9__RELEASE_MGC_additions2.sql 11 lines · 9 code · 0 comments · 2 blank
Flyway database migration script for Common. Contains SQL DDL/DML statements for schema evolution.
SQL Content
-- Remove unused tables after successful remove of MGC.
DROP TABLE t_orga_visitorbook_timedattrdata;
DROP TABLE t_orga_visitorbook_timedattr;
DROP TABLE t_orga_visitorbook_timed;
DROP TABLE t_fibu_employee_attrdata;
DROP TABLE t_fibu_employee_attr;
DROP TABLE t_fibu_employee_timedattrdata;
DROP TABLE t_fibu_employee_timedattr;
DROP TABLE t_fibu_employee_timed;
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.