Column Name

Type

Constraints

Notes

Id

Integer

Primary Key, Not Null

same as the RowId

path

Text

Not Null

The directoy path for the file being queued

filename

Text

Not Null

The file name for the file being queued

action

Text

One of "UPDATE", "STAT", "DELETE", "MOVE_FROM", "MOVE_TO"

The action to be carried out for this file

include_stat

Integer

0 or 1 (False or True)

A flag to say if a stat operation should be included in this action

size

Integer

Not Null

The size of the file in bytes

timestamp

Integer

Not Null

Unix timestamp of the m_time of the file

eventtime

Integer

Not Null

Unix timestamp of the entry being added to the Queue

inprogresstime

timestamp

Not Null

Unix timestamp when this entry moves to "IN_PROGRESS"

completiontime

timestamp

Not Null

Unix timestamp when this entry moves to "COMPLETED"

status

Text

One of "NEW", "DISPATCHED", "IN PROGESS", "COMPLETED"

The status of the queued items