+
+CREATE TABLE clip (
+ name text NOT NULL default '', -- title
+ width int unsigned,
+ height int unsigned,
+ duration real,
+ prefix_id_count int unsigned,
+ prefix_ids blob, -- media id list
+ suffix_id_count int unsigned,
+ suffix_ids blob, -- media id list
+ media_type int unsigned, -- video, audio
+ action int unsigned -- delete, mute, none
+) ;
+
+CREATE TABLE video_data (
+ clip_id int unsigned,
+ time_offset real,
+ key_data media
+) ;
+
+CREATE INDEX video_key ON video_data (key_data) ;
+