pAssessments GG_User_Edited
Adds GG_User_Edited to pAssessments on every agency_* database.
When a user changes a GG answer on the OASIS/Eval Edit page, that answer's column is saved in this list and the
GG auto-populate rules (PT/OT Eval, SOC, ROC and Recert saves) no longer overwrite it.
Important: Always backup databases before running migrations.
Safe to re-run: databases that already have the column are skipped. Existing assessments start with an empty list,
so only GG answers changed on the Edit page after this runs are kept.
SQL preview (per agency database)
ALTER TABLE {agency_db}.pAssessments ADD COLUMN `#newCol.name#` #newCol.ddl#;
Migration Progress
SELECT SCHEMA_NAME AS db_name
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME LIKE 'agency\_%' ESCAPE '\\'
AND SCHEMA_NAME NOT LIKE '%lookup%'
ORDER BY SCHEMA_NAME
Found #getAgencies.recordCount# agency database(s)
SELECT TABLE_NAME FROM information_schema.TABLES
WHERE TABLE_SCHEMA =
AND TABLE_NAME = 'pAssessments'
SELECT COLUMN_NAME FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA =
AND TABLE_NAME = 'pAssessments'
AND COLUMN_NAME =
ALTER TABLE #db_name#.pAssessments ADD COLUMN `#newCol.name#` #newCol.ddl#
Error: #EncodeForHTML(cfcatch.message)# #EncodeForHTML(cfcatch.detail)#
| Database | Status | Message |
|---|
| #r.db# |
#r.status# |
#EncodeForHTML(r.message)# |
Done. #ArrayLen(results)# database(s), #totalErrors# error(s).