EditLog

From Species File Help
(Difference between revisions)
Jump to: navigation, search
m
Line 1: Line 1:
 
'''tblEditLog''' contains log of entries that alter the database.
 
'''tblEditLog''' contains log of entries that alter the database.
  
 +
*FileID, integer, 2 bytes
 
*DateTime, timestamp for time of entry
 
*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
+
*FileuserID, integer, 2 bytes
*SFSuserID, integer, 2 bytes, identifer for Species File Software signon that did the edit (except special codes for certain administrative procedures)
+
*EditLogTextID, integer, 2 bytes
**-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
 
*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
 
*OldData, text, 8000 bytes maximum, previously recorded data
 
*NewData, text, 8000 bytes maximum, newly recorded data  
 
*NewData, text, 8000 bytes maximum, newly recorded data  

Revision as of 15:34, 8 September 2014

tblEditLog contains log of entries that alter the database.

  • FileID, integer, 2 bytes
  • DateTime, timestamp for time of entry
  • FileuserID, integer, 2 bytes
  • EditLogTextID, integer, 2 bytes
  • WhereClause, text, 200 bytes maximum, information used in the where clause of a SQL query
  • 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