| Scripts | New Table: - Id (PK, int)
- Name (nvarchar(255) not null)
- ScriptType (nvarchar(20), not null)
- ScriptContent (nvarchar(max) null)
- RequiresOdsApi (bit, not null)
| Supports storage of PowerShell scripts. EF Core note: Implement ScriptType as an enum. |
| Agents | 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.
|