Page Comparison

New Table:

• Id (PK, int)
• Name (nvarchar(255) not null)
• ScriptType (nvarchar(20), not null)
• ScriptContent (nvarchar(max) null)
• RequireOdsApiAccess (bit, not null)

Supports storage of PowerShell scripts.

EF Core note: Implement ScriptType as an enum.

New column:

• FileProcessorScriptId (FK, int, null)

Removed columns:

• RowProcessor (nvarchar(max), null)
• FileGenerator (nvarchar(max), null)

New columns:

• RowProcessorScriptId (FK, int, null)
• FileGeneratorScriptId (FK, int, null)

Replace Custom Row Processor and Custom File Generator filenames with database references.

This will require a specialized migration:

• Create a Script record with Name of the current value.
• Reference it from the new column, and drop the old column.
• On web application startup, for any Script records with a null ScriptContent value, get the file from the file system (by Name and known path per ScriptType) and populate contents into ScriptContent.