EditLog
From Species File Help
(Difference between revisions)
m |
m |
||
(One intermediate revision by one user not shown) | |||
Line 1: | Line 1: | ||
'''tblEditLog''' contains log of entries that alter the database. | '''tblEditLog''' contains log of entries that alter the database. | ||
− | *FileID, integer, | + | *FileID, integer, 4 bytes |
*DateTime, timestamp for time of entry | *DateTime, timestamp for time of entry | ||
− | *FileUserID, integer, | + | *FileUserID, integer, 4 bytes |
− | *EditLogTextID, integer, | + | *EditLogTextID, integer, 4 bytes = tblEditLogTexts.EditLogTextID |
*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 | ||
*OldData, text, 8000 bytes maximum, previously recorded data | *OldData, text, 8000 bytes maximum, previously recorded data |
Latest revision as of 16:35, 8 September 2014
tblEditLog contains log of entries that alter the database.
- FileID, integer, 4 bytes
- DateTime, timestamp for time of entry
- FileUserID, integer, 4 bytes
- EditLogTextID, integer, 4 bytes = tblEditLogTexts.EditLogTextID
- 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