 values
 (2010, 1);
 
-update state set status = "PLACED" where name like '%Place Illum%' and status != 'FINAL';
+update state set status = "COMPLETED" where name like '%Place Illum%' and status != 'FINALIZED';
 
 -- BREAK POINT --
 

-- --
-- simulate illumina qc screen ok

update state set status = "APPROVED" where name like '%Qc Appr%';


-- BREAK POINT --


insert into jobsample values (4, 1, 3, now(), 1);

update state set status = "COMPLETED" where name like '%Create Library%' and status != 'FINALIZED';


-- BREAK POINT --

-- --
-- rereceive library?
update state set status = "COMPLETED" where name like '%Receiv%' and status != 'FINALIZED';

-- --
-- simulates flowcell creation
