#1497: V7.0.0.24__7.0.0.24-RELEASE-ContractAttachments.sql
projectforge-business/src/main/resources/flyway/migrate/hsqldb/V7.0.0.24__7.0.0.24-RELEASE-ContractAttachments.sql Type: Flyway SQL Migration · Database: HSQLDB · Source: projectforge-business/src/main/resources/flyway/migrate/hsqldb/V7.0.0.24__7.0.0.24-RELEASE-ContractAttachments.sql 2 lines · 2 code · 0 comments · 0 blank
Flyway database migration script for HSQLDB. Contains SQL DDL/DML statements for schema evolution.
Table Alterations
ALTER TABLE t_contract
ALTER TABLE t_contract
SQL Content
ALTER TABLE t_contract ALTER COLUMN attachments_size RENAME TO attachments_counter;
ALTER TABLE t_contract ADD COLUMN attachments_size BIGINT;
Git History
c50a6feae Attachments: counter and size of attachments in sum implemented.