#1464: V7.0.0.19__7.0.0.19-RELEASE-AddressText.sql
projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.19__7.0.0.19-RELEASE-AddressText.sql Type: SQL Migration · Role: Database Migration · Source: projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.19__7.0.0.19-RELEASE-AddressText.sql 3 lines · 3 code · 0 comments · 0 blank
Flyway database migration script. Part of the versioned migration chain that evolves the ProjectForge database schema.
Migration Details
- Alters table(s):
T_ADDRESS, T_ADDRESS, T_ADDRESS - Added columns:
addressText2, postal_addresstext2, private_addresstext2
Source Code (abridged)
ALTER TABLE T_ADDRESS ADD COLUMN addressText2 VARCHAR(255);
ALTER TABLE T_ADDRESS ADD COLUMN postal_addresstext2 VARCHAR(255);
ALTER TABLE T_ADDRESS ADD COLUMN private_addresstext2 VARCHAR(255);
Git History
d02faab3d AddressDO: addressText2, privateAddressText2, postalAddressText2