#1485: V7.5.1.3__7.5.1.3-RELEASE-BookAttachments.sql
projectforge-business/src/main/resources/flyway/migrate/common/V7.5.1.3__7.5.1.3-RELEASE-BookAttachments.sql Type: SQL Migration · Role: Database Migration · Source: projectforge-business/src/main/resources/flyway/migrate/common/V7.5.1.3__7.5.1.3-RELEASE-BookAttachments.sql 7 lines · 6 code · 0 comments · 1 blank
Flyway database migration script. Part of the versioned migration chain that evolves the ProjectForge database schema.
Migration Details
- Alters table(s):
t_book, t_book, t_book, t_book, t_book - Added columns:
attachments_names, attachments_ids, attachments_counter, attachments_size, attachments_last_user_action
Source Code (abridged)
-- Attachment support for books.
ALTER TABLE t_book ADD COLUMN attachments_names CHARACTER VARYING(10000);
ALTER TABLE t_book ADD COLUMN attachments_ids CHARACTER VARYING(10000);
ALTER TABLE t_book ADD COLUMN attachments_counter SMALLINT;
ALTER TABLE t_book ADD COLUMN attachments_size BIGINT;
ALTER TABLE t_book ADD COLUMN attachments_last_user_action CHARACTER VARYING(10000);
Git History
c6d099d47 Book: attachments are now supported.