CREATE TABLE ogg_file (
	of_name varbinary(255) not null,
	of_timestamp binary(14) not null,
	of_version int,
	of_length float,
	of_size int,
	
	/* Audio: 1, Video: 2, Error: 128 */
	of_stream_types tinyint unsigned default 0,
	
	PRIMARY KEY (of_name),
	INDEX (of_length),
	INDEX (of_stream_types)
);

CREATE TABLE ogg_stream (
	os_id int not null auto_increment, 
	os_file varbinary(255) not null,
	os_stream_id int not null,
	
	os_type varbinary(255) not null,
	os_size int not null,
	os_length int not null,
	os_bitrate float not null,

	os_width int,
	os_height int,
	os_framerate float,
	
	os_channels int,
	os_samplerate int,
	
	PRIMARY KEY(os_id),
	INDEX (os_file)
);