#1491: V8.0.17__RELEASE-KeycloakPasswordSync.sql
projectforge-business/src/main/resources/flyway/migrate/common/V8.0.17__RELEASE-KeycloakPasswordSync.sql Type: SQL Migration · Role: Database Migration · Source: projectforge-business/src/main/resources/flyway/migrate/common/V8.0.17__RELEASE-KeycloakPasswordSync.sql 8 lines · 7 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_PF_USER, T_PF_USER - Added columns:
last_keycloak_password_sync, keycloak_id
Source Code (abridged)
-- Add Keycloak password sync tracking column to T_PF_USER.
-- Null means the user's password has never been synced to Keycloak.
ALTER TABLE T_PF_USER ADD COLUMN last_keycloak_password_sync TIMESTAMP;
-- Add Keycloak user ID column to T_PF_USER.
-- Stores the Keycloak UUID so users can be looked up by ID instead of username.
-- Null for users that have not yet been synced with Keycloak.
ALTER TABLE T_PF_USER ADD COLUMN keycloak_id VARCHAR(100);
Git History
570213d36 Fix recurring false-positive sync updates; add keycloakId to PFUserDO; remove KeycloakMigrationRest
b78148558 Add Keycloak integration: new projectforge-keycloak module