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		PRI	0
starttime	datetime		PRI	0000-00-00 00:00:00
mark	bigint(20)		PRI	0
offset	varchar(32)			NULL
type	int(11)		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 N.B. Not all of the following marktypes apply to the recordedmarkup table, they may be used in the recordedseek table instead.

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;