REVISIONRUNLOG
The REVISIONRUNLOG table contains information about a revision run, including the starting revision, the total number of revisions and any errors that may have been encountered.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PROCESSID | uniqueidentifier | yes | Identifies the set of related revisions that were executed by a single process | |
| STARTASSEMBLY | nvarchar(260) | The name of the .NET assembly that contains this set of revisions | ||
| STARTREVISIONNUM | int | yes | The revision number for this set of revisions | |
| STARTREVISIONID | int | yes | The starting revision ID for this revision set | |
| STARTINGREVISIONISPAGEREVISION | bit | Default = 0 | Tells if the starting revision for this run is a page revision | |
| STARTINGPAGE | nvarchar(150) | yes | The page that this revision run started with | |
| TOTALREVISIONS | int | The total number of standard revisions to execute for this revision run | ||
| TOTALALTEREDSPECS | int | Default = 0 | The total number of altered specs to execute for this revision run | |
| TOTALPAGEREVISIONS | int | Default = 0 | The total number of page revisions to execute for this revision run | |
| DATESTARTED | datetime | Default = getdate() | The date the revision run was started | |
| DATEFINISHED | datetime | yes | The date the revision run finished | |
| CURRENTASSEMBLY | nvarchar(260) | yes | The name of the .NET assembly that contains the current revision | |
| CURRENTREVISIONNUM | int | yes | The current revision number | |
| CURRENTREVISIONID | int | yes | The current revision ID | |
| CURRENTREVISION | nvarchar(max) | yes | The current revision text | |
| TOTALREVISIONSCOMPLETED | int | Default = 0 | The number of revisions executed during this revision run | |
| TOTALALTEREDSPECSCOMPLETED | int | Default = 0 | The number of altered specs loaded during this revision run | |
| TOTALPAGEREVISIONSCOMPLETED | int | Default = 0 | The number of page revisions loaded during this revision run | |
| DATELASTUPDATED | datetime | yes | The date the log entry was last updated | |
| WINUSER | nvarchar(255) | The Windows user who initiated the revision run | ||
| FAILED | bit | Default = 0 | Indicates whether or not the revision run failed | |
| FAILEDREVISIONERROR | nvarchar(max) | yes | The failed revision error message, if any |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_REVISIONRUNLOG_DATESTARTED | DATESTARTED | yes | ||
| PK_REVISIONRUNLOG | ID | yes | yes |