 insert into schema_information(schema_version, upgrading_soon, upgrading_currently)
 values ('2008123000', false, false);
 
-
+create table if not exists test_index (
+	id int primary key auto_increment,
+	start_time timestamp not null default current_timestamp on update current_timestamp,
+	comment varchar(1000) default null
+) engine=InnoDB;
 
 -- a lookup table of possible transcode outcomes
 create table if not exists transcoder_failures (

-- schema_information must be updated and looked at before committing schema changes
-- schema_version is YYYYMMDDXX where XX is 00 for the first schema change on
-- particular day, extra changes same day should increment the XX
create table if not exists schema_information (
        schema_version int(9) not null,
        upgrading_soon boolean default false,

from
        transcoder_reports
group by
	test_id,
        customer_id,
        profile_id,
        file_checksum;

create or replace view unique_transcoder_outcomes_per_profile as
select
	test_id,
        customer_id,
        profile_id,
        sum(case when outcome then 1 else 0 end) as successful_transcods,
