EditLog
From Species File Help
(Difference between revisions)
(created page) |
m |
||
| (6 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 | |
| − | + | *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 | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
[[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
