CREATE TABLE clip ( clip_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, name varchar(255) binary NOT NULL default '', width int unsigned, height int unsigned, length int unsigned, media_type int unsigned ) ; CREATE TABLE prefix ( clip_id int unsigned, prefix_seq_no int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, time_offset real, key_data media ) ; CREATE UNIQUE INDEX prefix_key_data ON prefix (key_data) ; CREATE TABLE suffix ( clip_id int unsigned, suffix_seq_no int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, time_offset real, key_data media ) ; CREATE UNIQUE INDEX suffix_key_data ON suffix (key_data) ;