LumiDB/doc/initializePIXELtag.sql

0001 insert into pixeltagruns (tagid,runnum) (select distinct 0, runnum from pixellumidata);
0002 update pixeltagruns set  lumidataid=(select max(data_id) from pixellumidata where pixellumidata.runnum=pixeltagruns.runnum);
0003 update pixeltagruns set  trgdataid=(select max(data_id) from trgdata where trgdata.runnum=pixeltagruns.runnum);
0004 update pixeltagruns set  hltdataid=(select max(data_id) from hltdata where hltdata.runnum=pixeltagruns.runnum);