2 CREATE TABLE video_frame (
3 frame_mean real, -- video average data
4 frame_std_dev real, -- video std dev data
5 frame_cx real, frame_cy real, -- video centroid
6 frame_moment real, -- video frame_cx+frame_cy
7 frame_data blob -- video data
10 CREATE INDEX frame_weight ON video_frame (frame_mean) ;
11 CREATE INDEX frame_center ON video_frame (frame_moment) ;
14 CREATE TABLE timeline (
15 clip_id int unsigned, -- label
16 sequence_no int unsigned, -- frame number in sequence
17 frame_id int unsigned, -- video_frame id
18 group int unsigned, -- prefix/suffix flags
19 time_offset real -- seconds
22 CREATE INDEX timelines ON timeline (frame_id) ;
23 CREATE UNIQUE INDEX sequences ON timeline (clip_id, sequence_no) ;
26 CREATE TABLE clip_set (
27 title text NOT NULL default '', -- title
28 asset_path text NOT NULL default '', -- original asset path
29 position real, -- orignal asset position
30 framerate real, -- framerate
31 average_weight real, -- average_weight
32 frames int unsigned, -- total frames
33 prefix_size int unsigned, -- prefix frame count
34 suffix_size int unsigned, -- suffix frame count
35 weights blob, -- frame weights[frames]
36 system_time bigint, -- stream system time
37 creation_time bigint -- record creation time
40 CREATE INDEX clip_title ON clip_set (title) ;
41 CREATE INDEX clip_system_time ON clip_set (system_time) ;
42 CREATE INDEX clip_creation_time ON clip_set (creation_time) ;
43 CREATE INDEX clip_path_pos ON clip_set (asset_path, position) ;
46 CREATE TABLE clip_views (
47 access_clip_id int unsigned, -- label
48 access_time bigint, -- last view time
49 access_count int unsigned -- total views
52 CREATE UNIQUE INDEX clip_access ON clip_views (access_clip_id) ;
53 CREATE INDEX last_view ON clip_views (access_time) ;
54 CREATE INDEX total_views ON clip_views (access_count, access_clip_id) ;