EditLog
From Species File Help
(Difference between revisions)
(formatting) |
m |
||
(5 intermediate revisions 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, 4 bytes | ||
*DateTime, timestamp for time of entry | *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 | *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 | ||
*NewData, text, 8000 bytes maximum, newly recorded data | *NewData, text, 8000 bytes maximum, newly recorded data | ||
[[Category:AdminTables]] | [[Category:AdminTables]] | ||
+ | [[Category:Tables]] |
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