EditLog
From Species File Help
(Difference between revisions)
(formatting) |
|||
Line 15: | Line 15: | ||
[[Category:AdminTables]] | [[Category:AdminTables]] | ||
+ | [[Category:Tables]] |
Revision as of 12:37, 8 September 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