 join typesample t on t.typesampleid in (1, 3)
 join subtypesample st on concat(w.iname, t.iname, 'Sample') = st.iname;
 
--- insert into workflowresource(workflowid, resourceid)
--- values
--- (1, 10), (1, 11), (1, 2), (1, 3), (1, 4), (1, 5);
-
-
-drop TABLE if exists `wasp`.`task_mapping` ;
--- drop TABLE if exists `wasp`.`taskmapping` ;
 
 CREATE TABLE IF NOT EXISTS `taskmapping` (
   `taskmappingid` int(10) NOT NULL AUTO_INCREMENT,

  constraint unique index u_jobresource_rid_jdid (resourceid, jobid)
) ENGINE=InnoDB charset=utf8;

--
-- job draft
--

(11, 1),
(11, 2),
(11, 3),
(11, 5),
(11, 16),
(16, 1),
(16, 2),
(16, 3),
(16, 11),
(16, 5);

-- USER.ROLE
--
