Recordedmarkup table

The recordedmarkup table stores bookmarks, edit markup and commercial flagging markup for each recording in the recorded table.

Field	Type	Null	Key	Default
chanid	int(10) unsigned	NO	PRI	0
starttime	datetime	NO	PRI	0000-00-00 00:00:00
mark	bigint(20)	NO	PRI	0
offset	varchar(32)	YES		NULL
type	int(11)	NO	PRI	0

The offset field is redundant and remains for backwards compatibility.

The type field shows what kind of marker it is, such as a keyframe, scene change, a flagged commercial, etc. Possible values for type are defined in the MarkTypes enum

typedef enum {
   MARK_UNSET = -10,
   MARK_UPDATED_CUT = -3,
   MARK_EDIT_MODE = -2,
   MARK_CUT_END = 0,
   MARK_CUT_START = 1,
   MARK_BOOKMARK = 2,
   MARK_BLANK_FRAME = 3,
   MARK_COMM_START = 4,
   MARK_COMM_END = 5,
   MARK_GOP_START = 6,
   MARK_KEYFRAME = 7,
   MARK_SCENE_CHANGE = 8,
   MARK_GOP_BYFRAME = 9
} MarkTypes;