Difference between revisions of "Housekeeping table"
From MythTV Official Wiki
(One intermediate revision by one other user not shown) | |||
Line 1: | Line 1: | ||
+ | {{Wrongtitle|housekeeping table}} | ||
The '''housekeeping table''' lists housekeeping events (cleanup and recovery tasks) and the time at which they were last performed. | The '''housekeeping table''' lists housekeeping events (cleanup and recovery tasks) and the time at which they were last performed. | ||
+ | |||
+ | == Table Description == | ||
+ | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | ||
+ | |- style="background: lightsteelblue" | ||
+ | ! Field name !! Type !! Null !! Key !! Default !! Extras | ||
+ | |- | ||
+ | || tag || varchar(64) || || PRI || || | ||
+ | |- | ||
+ | || lastrun || datetime || YES || || NULL || | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | |||
+ | == Example Entries == | ||
+ | <pre> | ||
+ | tag: JobQueueCleanup | ||
+ | lastrun: 2006-10-11 11:10:14 | ||
+ | </pre> | ||
+ | <pre> | ||
+ | tag: InUseProgramsCleanup | ||
+ | lastrun: 2006-10-11 11:05:14 | ||
+ | </pre> | ||
+ | <pre> | ||
+ | tag: JobQueueRecover-localhost.localdomain | ||
+ | lastrun: 2007-03-12 09:36:17 | ||
+ | </pre> | ||
+ | <pre> | ||
+ | tag: MythFillDB | ||
+ | lastrun: 2007-03-12 18:40:58 | ||
+ | </pre> | ||
+ | <pre> | ||
+ | tag: DailyCleanup | ||
+ | lastrun: 2007-03-12 09:36:17 | ||
+ | </pre> | ||
+ | [[Category:DB Table]] |
Revision as of 04:06, 13 March 2007
Note: The correct title of this article is housekeeping table. It appears incorrectly here due to technical restrictions.
The housekeeping table lists housekeeping events (cleanup and recovery tasks) and the time at which they were last performed.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
tag | varchar(64) | PRI | |||
lastrun | datetime | YES | NULL |
Example Entries
tag: JobQueueCleanup lastrun: 2006-10-11 11:10:14
tag: InUseProgramsCleanup lastrun: 2006-10-11 11:05:14
tag: JobQueueRecover-localhost.localdomain lastrun: 2007-03-12 09:36:17
tag: MythFillDB lastrun: 2007-03-12 18:40:58
tag: DailyCleanup lastrun: 2007-03-12 09:36:17