= TimeWarp Queue Database =

The queue database is implemented in sqllite3. There is a TimeWarp supplied database class which provides access to all the common database functionality. 

== Tables ==

=== Queue ===

||'''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||