EditLog

From Species File Help
Revision as of 09:42, 31 August 2012 by Maehr (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox