EditLog
From Species File Help
(Difference between revisions)
(created page) |
(formatting) |
||
| Line 1: | Line 1: | ||
'''tblEditLog''' contains log of entries that alter the database. | '''tblEditLog''' contains log of entries that alter the database. | ||
| − | + | *DateTime, timestamp for time of entry | |
| − | + | *SFuserID, integer, 2 bytes, identifier for species file signon that did the edit, special values -1 for a service pack, -2 for an editor from the software website | |
| − | + | *SFSuserID, integer, 2 bytes, identifer for Species File Software signon that did the edit (except special codes for certain administrative procedures) | |
| − | + | **-3 = change from a different species file (from species file merging process) | |
| − | + | **-2 = change from the Species File Software website | |
| − | + | **-1 = change from a service pack | |
| − | + | *UnitName, text, 100 bytes maximum, program unit that generated the entry | |
| − | + | *Description, text, 400 bytes maximum, description of change | |
| − | + | *WhereClause, text, 200 bytes maximum, information used in the where clause of a SQL query | |
| − | + | *DataSpecs, text, 400 bytes maximum, a listing of the data specifications as they appear in OldData and NewData | |
| − | + | *OldData, text, 8000 bytes maximum, previously recorded data | |
| − | + | *NewData, text, 8000 bytes maximum, newly recorded data | |
[[Category:AdminTables]] | [[Category:AdminTables]] | ||
Revision as of 15:42, 31 August 2012
tblEditLog contains log of entries that alter the database.
- DateTime, timestamp for time of entry
- SFuserID, integer, 2 bytes, identifier for species file signon that did the edit, special values -1 for a service pack, -2 for an editor from the software website
- SFSuserID, integer, 2 bytes, identifer for Species File Software signon that did the edit (except special codes for certain administrative procedures)
- -3 = change from a different species file (from species file merging process)
- -2 = change from the Species File Software website
- -1 = change from a service pack
- UnitName, text, 100 bytes maximum, program unit that generated the entry
- Description, text, 400 bytes maximum, description of change
- WhereClause, text, 200 bytes maximum, information used in the where clause of a SQL query
- DataSpecs, text, 400 bytes maximum, a listing of the data specifications as they appear in OldData and NewData
- OldData, text, 8000 bytes maximum, previously recorded data
- NewData, text, 8000 bytes maximum, newly recorded data
