#1487: V8.0.12__RELEASE-TimesheetDO_AI-TimeSavings.sql
projectforge-business/src/main/resources/flyway/migrate/common/V8.0.12__RELEASE-TimesheetDO_AI-TimeSavings.sql Type: Flyway SQL Migration · Database: Common · Source: projectforge-business/src/main/resources/flyway/migrate/common/V8.0.12__RELEASE-TimesheetDO_AI-TimeSavings.sql 5 lines · 4 code · 0 comments · 1 blank
Flyway database migration script for Common. Contains SQL DDL/DML statements for schema evolution.
Table Alterations
ALTER TABLE t_timesheet
ALTER TABLE t_timesheet
ALTER TABLE t_timesheet
SQL Content
-- Add parameters: time savings by usage of AI to t_timesheet:
ALTER TABLE t_timesheet ADD COLUMN time_saved_by_ai NUMERIC(10, 2);
ALTER TABLE t_timesheet ADD COLUMN time_saved_by_ai_unit CHAR(10);
ALTER TABLE t_timesheet ADD COLUMN time_saved_by_ai_description VARCHAR(1000);
Git History
cbffabd60 WIP: time savings by AI
26a7fd093 WIP timesheet: saving by AI