UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1883189184.gpc1:STS.PP5:2011:07:01:o5743g0279o.355584:o5743g0279o.355584.wrp.367579.skycell.2.02.wt.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1483958661.gpc1:ThreePi.nt:2011:10:23:o5857g0144o.412695:SR_o5857g0144o.412695.cm.306693.XY11.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='520808624.gpc1:MD09.nt:2010:11:03:o5503g0229o.250229:SR_o5503g0229o.250229.cm.136540.XY10.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1683507986.gpc1:LAP.ThreePi.20110809:2011:09:22:o5395g0084o.192791:o5395g0084o.192791.ch.296222.XY21.trace.update';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='988483711.gpc1:ThreePi.nt:2011:06:08:o5720g0079o.344914:SR_o5720g0079o.344914.cm.218106.XY27.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1531284312.gpc1:LAP.ThreePi.20110809:2011:11:03:o5839g0218o.402980:SR_o5839g0218o.402980.cm.314225.XY21.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1021928221.gpc1:ThreePi.nt:2011:06:19:o5731g0534o.351097:SR_o5731g0534o.351097.cm.222547.XY10.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1558328913.gpc1:LAP.ThreePi.20110809:2011:11:10:o5747g0614o.358319:SR_o5747g0614o.358319.cm.318498.XY11.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1054969069.gpc1:ThreePi.nt:2011:06:30:o5742g0019o.354716:SR_o5742g0019o.354716.cm.228096.XY10.mk.fits';

UPDATE Files_ipp008_00 
SET 
  size=1440, 
  md5sum='18ff93694978c78b9d7dcc2424f0e6b3',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.352924',
  stage='warp'
WHERE filename='1101520085.gpc1:ThreePi.nt:2011:07:16:o5758g0451o.363107:o5758g0451o.363107.wrp.222624.skycell.2291.068.stats';


UPDATE Files_ipp008_00 
SET 
  size=2880, 
  md5sum='054c8b02eba225ee9f1d1608c1b053ac',
  role='skycell',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.373189',
  stage='warp'
WHERE filename='955294039.gpc1:CNP.nt:2011:05:24:o5705g0196o.340332:o5705g0196o.340332.wrp.201744.skycell.092.skycell';


UPDATE Files_ipp008_00 
SET 
  size=569, 
  md5sum='206b65810d8d8af2ebd6c0406b986474',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.408771',
  stage='destreak'
WHERE filename='953509492.gpc1:destreak:ThreePi.nightlyscience:340076:chip:340076.mds.529739.235036.XY10.stats';


UPDATE Files_ipp008_00 
SET 
  size=368437, 
  md5sum='d3568c89ed44a464555b2dd4e711e77f',
  role='log',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.465492',
  stage='warp'
WHERE filename='945774470.gpc1:ThreePi.nt:2011:05:20:o5701g0045o.338786:o5701g0045o.338786.wrp.200553.log';


UPDATE Files_ipp008_00 
SET 
  size=0, 
  md5sum='d41d8cd98f00b204e9800998ecf8427e',
  role='trace',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.476153',
  stage='diff'
WHERE filename='944578949.gpc1:ThreePi.nt:2011:05:19:RINGS.V0:skycell.1900.092:RINGS.V0.skycell.1900.092.dif.133007.trace';


UPDATE Files_ipp008_00 
SET 
  size=1440, 
  md5sum='faebab9938ed4e7e89146e9f191567bb',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.493538',
  stage='warp'
WHERE filename='944151780.gpc1:ThreePi.nt:2011:05:19:o5700g0281o.338206:o5700g0281o.338206.wrp.200237.skycell.2383.128.stats';


UPDATE Files_ipp008_00 
SET 
  size=562969, 
  md5sum='07cced5838a1f40a43fc4d61d5b18d2e',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.555441',
  stage='diff'
WHERE filename='934293298.gpc1:ThreePi.nt:2011:05:15:RINGS.V0:skycell.2145.062:RINGS.V0.skycell.2145.062.dif.132242.b1.jpg';


UPDATE Files_ipp008_00 
SET 
  size=513291, 
  md5sum='335856d5c8b743e72bb1096e9768edd7',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.594400',
  stage='diff'
WHERE filename='919119171.gpc1:MD06.nightlyscience:2011:05:11:MD06:skycell.091:MD06.skycell.091.WS.dif.131027.b1.jpg';


UPDATE Files_ipp008_00 
SET 
  size=121543, 
  md5sum='9aabaae148068c4055b48f927f786a4d',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.622133',
  stage='warp'
WHERE filename='918366614.gpc1:MD05.nt:2011:05:11:o5692g0109o.334427:o5692g0109o.334427.wrp.196010.skycell.040.pswarp.mdc';


UPDATE Files_ipp008_00 
SET 
  size=164160, 
  md5sum='b4c3d52454756cebcdb80e8e4060f59d',
  role='fits',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:32.651507',
  stage='diff'
WHERE filename='911074293.gpc1:LAP.ThreePi.20110505:2011:05:09:RINGS.V3:skycell.1593.082:RINGS.V3.skycell.1593.082.dif.130130.mdl.fits';


UPDATE Files_ipp008_00 
SET 
  size=2534, 
  md5sum='0e415eee4f3d52b16b96a597ee2f1989',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.672170',
  stage='chip'
WHERE filename='902914799.gpc1:LAP.ThreePi.20110505:2011:05:07:o5404g0512o.197947:o5404g0512o.197947.ch.224684.XY11.stats';


UPDATE Files_ipp008_00 
SET 
  size=0, 
  md5sum='d41d8cd98f00b204e9800998ecf8427e',
  role='trace',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.686014',
  stage='chip'
WHERE filename='959472489.gpc1:STS.2010.b:o5448g0196o.221942:o5448g0196o.221942.ch.235897.XY10.trace';


UPDATE Files_ipp008_00 
SET 
  size=3340800, 
  md5sum='208f1d65e5475409bd7fe6a72556f102',
  role='psf',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:32.860225',
  stage='chip'
WHERE filename='963375169.megacam:u.MD04.20110527:1060436p.604:1060436p.604.ch.65.psf';


UPDATE Files_ipp008_00 
SET 
  size=1543680, 
  md5sum='f71f5e9d01c2898e9d497b37319e480c',
  role='mask',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.953653',
  stage='cam'
WHERE filename='964696798.gpc1:ThreePi.nt:2011:05:29:o5710g0333o.341778:o5710g0333o.341778.cm.214932.XY25.mk.fits';


UPDATE Files_ipp008_00 
SET 
  size=42912, 
  md5sum='9a757a514494fe27f3fc1b85be267b80',
  role='bttable',
  lifetime='permanent',
  last_check='2012-04-26 17:23:32.982883',
  stage='raw'
WHERE filename='1103253250.gpc1:20110717:o5759g0249o:o5759g0249o.ota11.burn.tbl';


UPDATE Files_ipp008_00 
SET 
  size=524, 
  md5sum='e96a6aff42844c4a0378d5423254eb25',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.002991',
  stage='destreak'
WHERE filename='1109169678.gpc1:destreak:ThreePi.nightlyscience:364058:warp:364058.mds.595857.223536.skycell.0766.073.stats';

UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1123722395.gpc1:ThreePi.nt:2011:07:20:o5762g0357o.365532:SR_o5762g0357o.365532.cm.237160.XY42.mk.fits';

UPDATE Files_ipp008_00 
SET 
  size=549164, 
  md5sum='401138bdf623c9e0ca71ced90265dfdf',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.067561',
  stage='diff'
WHERE filename='1126353513.gpc1:ThreePi.nt:2011:07:23:RINGS.V3:skycell.1587.060:RINGS.V3.skycell.1587.060.dif.147149.b1.jpg';


UPDATE Files_ipp008_00 
SET 
  size=1143360, 
  md5sum='e8f20250f0bb26e056720b08e2d95917',
  role='ptn',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:33.146752',
  stage='chip'
WHERE filename='1127408847.gpc1:ThreePi.nt:2011:07:24:o5766g0086o.367288:o5766g0086o.367288.ch.262201.XY63.ptn';

UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1257329234.gpc1:LAP.ThreePi.20110809:2011:09:03:o5358g0368o.179897:SR_o5358g0368o.179897.cm.259809.XY21.mk.fits';

UPDATE Files_ipp008_00 
SET 
  size=48960, 
  md5sum='b5b983c2d871163cb9bde979f96b75f6',
  role='catalog',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.167731',
  stage='diff'
WHERE filename='989595364.gpc1:ThreePi.nt:2011:06:08:RINGS.V0:skycell.0852.063:RINGS.V0.skycell.0852.063.dif.137054.cmf';


UPDATE Files_ipp008_00 
SET 
  size=466560, 
  md5sum='933b307ff5cbcb282b0566e2a65319c3',
  role='mask',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.202539',
  stage='cam'
WHERE filename='984784626.gpc1:ThreePi.nt:2011:06:06:o5718g0505o.344199:REC_o5718g0505o.344199.cm.217560.XY10.mk.fits';


UPDATE Files_ipp008_00 
SET 
  size=1932480, 
  md5sum='00632c3a3facf9e0f7e6941f914b9e59',
  role='catalog',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.356500',
  stage='diff'
WHERE filename='979774351.gpc1:STS.2009.b:2011:06:05:STS.V3:skycell.0.48:STS.V3.skycell.0.48.WS.dif.136241.cmf';


UPDATE Files_ipp008_00 
SET 
  size=2295360, 
  md5sum='78ad6388ebd2402cefaa02341719f67b',
  role='mask',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.506476',
  stage='cam'
WHERE filename='975584187.gpc1:ThreePi.nt:2011:06:02:o5714g0528o.343319:o5714g0528o.343319.cm.216658.XY02.mk.fits';


UPDATE Files_ipp008_00 
SET 
  size=37440, 
  md5sum='a0c819faf819305f8f1e31f8d37b507e',
  role='mdl',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:33.539729',
  stage='chip'
WHERE filename='899973120.gpc1:LAP.ThreePi.20110505:2011:05:06:o5475g0329o.235540:o5475g0329o.235540.ch.224092.XY66.mdl.fits';


UPDATE Files_ipp008_00 
SET 
  size=2429, 
  md5sum='7f93387d92d8dbbeb111f7ae6fe2c2f4',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.565876',
  stage='chip'
WHERE filename='899123624.gpc1:LAP.ThreePi.20110505:2011:05:06:o5096g0401o.99830:o5096g0401o.99830.ch.223876.XY11.stats';


UPDATE Files_ipp008_00 
SET 
  size=35438, 
  md5sum='b905d85693cd7e35ddb9fd184b47ca49',
  role='logupdate',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.589818',
  stage='warp'
WHERE filename='837232723.gpc1:ThreePi.nt:2010:09:24:o5463g0057o.229623:o5463g0057o.229623.wrp.109186.skycell.0948.043.log.update';


UPDATE Files_ipp008_00 
SET 
  size=3513600, 
  md5sum='68fd49105333920c7d16062befdaeec6',
  role='catalog',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.781228',
  stage='chip'
WHERE filename='827726608.gpc1:STS.2010.a:o5426g0077o.208584:SR_o5426g0077o.208584.ch.211782.XY10.cmf';


UPDATE Files_ipp008_00 
SET 
  size=57190, 
  md5sum='1ed29ff31e5cecaace356dd7cd56715c',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.810579',
  stage='chip'
WHERE filename='825720143.gpc1:ThreePi.nt:2010:05:19:o5335g0206o.170046:o5335g0206o.170046.ch.95896.XY30.ppImage.mdc';


UPDATE Files_ipp008_00 
SET 
  size=43200, 
  md5sum='1be53e33b050383c88c2ea042931ed2e',
  role='b1fits',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.830715',
  stage='chip'
WHERE filename='824688830.gpc1:STS.2010.a:o5426g0112o.208619:o5426g0112o.208619.ch.211817.XY10.b2.fits';


UPDATE Files_ipp008_00 
SET 
  size=54144, 
  md5sum='5ca6d1e15de4ba1a219085a444c5f361',
  role='bttable',
  lifetime='permanent',
  last_check='2012-04-26 17:23:33.857318',
  stage='raw'
WHERE filename='822780093.gpc1:20100206:o5233g0329q:o5233g0329q.ota72.burn.tbl';


UPDATE Files_ipp008_00 
SET 
  size=20237760, 
  md5sum='ad3e6ce0a113e686688c487d6ee5e5dd',
  role='fits',
  lifetime='raw',
  last_check='2012-04-26 17:23:34.129896',
  stage='raw'
WHERE filename='815735395.gpc1:20100731:o5408g0291a:o5408g0291a.ota57.fits';


UPDATE Files_ipp008_00 
SET 
  size=54720, 
  md5sum='f4ff24374d24e096ca431f7fad77ebc0',
  role='psf',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.165310',
  stage='warp'
WHERE filename='810627460.gpc1:MD09.jtrp:o5074g0238o.92290:o5074g0238o.92290.wrp.178137.skycell.103.psf';


UPDATE Files_ipp008_00 
SET 
  size=13049280, 
  md5sum='eb57b76c3953d58064d0e7efadd533ac',
  role='weight',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.346617',
  stage='stack'
WHERE filename='807387122.gpc1:SweetSpot.refstack.20100627:RINGS.V0:skycell.1414.137:RINGS.V0.skycell.1414.137.stk.123034.wt.fits';


UPDATE Files_ipp008_00 
SET 
  size=54720, 
  md5sum='3ccf3c44c1e03bebb27f32d7664041ad',
  role='psf',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.380447',
  stage='warp'
WHERE filename='798456150.gpc1:ThreePi.nt:2011:03:26:o5646g0604o.316988:o5646g0604o.316988.wrp.176440.skycell.2138.017.psf';


UPDATE Files_ipp008_00 
SET 
  size=7198, 
  md5sum='3314e35aaf52e029a59af667a256d073',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.406948',
  stage='diff'
WHERE filename='797091931.gpc1:ThreePi.nt:2011:03:26:RINGS.V0:skycell.1971.008:RINGS.V0.skycell.1971.008.dif.118195.b2.jpg';


UPDATE Files_ipp008_00 
SET 
  size=408960, 
  md5sum='074f0eaf048c88cd16659d833c6bf21d',
  role='b1fits',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.453153',
  stage='chip'
WHERE filename='843072961.gpc1:ThreePi.nt:2011:04:17:o5668g0441o.325413:o5668g0441o.325413.ch.214297.XY36.b1.fits';


UPDATE Files_ipp008_00 
SET 
  size=49401, 
  md5sum='65e5f1beaee8644e20a90f163dab1020',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.465278',
  stage='diff'
WHERE filename='850353026.gpc1:ThreePi.nt:2011:04:20:RINGS.V0:skycell.2209.017:RINGS.V0.skycell.2209.017.dif.123009.b2.jpg';


UPDATE Files_ipp008_00 
SET 
  size=796270, 
  md5sum='1a3097c3cc9816c71dabc4b31f9df2bd',
  role='log',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.548725',
  stage='raw'
WHERE filename='851892851.gpc1:20110421:o5672g0242o.327032:o5672g0242o.327032.reg.ota11.log';


UPDATE Files_ipp008_00 
SET 
  size=1431360, 
  md5sum='3e7cbb94db0321709ddbd1b3d52ae0a0',
  role='mask',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.670067',
  stage='cam'
WHERE filename='898934881.gpc1:LAP.ThreePi.20110505:2011:05:06:o5414g0471o.203860:o5414g0471o.203860.cm.203136.XY33.mk.fits';


UPDATE Files_ipp008_00 
SET 
  size=1913, 
  md5sum='e85cb74505194c274f25a6c7887ef91c',
  role='log',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.698541',
  stage='raw'
WHERE filename='885355958.gpc1:20110501:o5682g0158o:o5682g0158o.ota11.burn.log';


UPDATE Files_ipp008_00 
SET 
  size=121349, 
  md5sum='ced41387406326af2ed03cb11a46c5ca',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.729010',
  stage='warp'
WHERE filename='883517551.gpc1:ThreePi.nt:2011:04:30:o5681g0481o.332164:o5681g0481o.332164.wrp.188991.skycell.2327.080.pswarp.mdc';


UPDATE Files_ipp008_00 
SET 
  size=818023, 
  md5sum='44701653b0048afd7842816bf4580df6',
  role='log',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.786591',
  stage='raw'
WHERE filename='881945881.gpc1:20110430:o5681g0246a.331928:o5681g0246a.331928.reg.ota11.log';


UPDATE Files_ipp008_00 
SET 
  size=37440, 
  md5sum='9ca06ce8f28a8b2cc4fa64dea9d0acba',
  role='mdl',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:34.798968',
  stage='chip'
WHERE filename='880475525.gpc1:ThreePi.nt:2010:03:23:o5278g0117o.150748:o5278g0117o.150748.ch.75984.XY75.mdl.fits';


UPDATE Files_ipp008_00 
SET 
  size=839447, 
  md5sum='7b668155155d1cc7a217c111aff4db50',
  role='log',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.875715',
  stage='raw'
WHERE filename='872970799.gpc1:20110427:o5678g0279o.330402:o5678g0279o.330402.reg.ota11.log';


UPDATE Files_ipp008_00 
SET 
  size=0, 
  md5sum='d41d8cd98f00b204e9800998ecf8427e',
  role='trace',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.884533',
  stage='diff'
WHERE filename='864675705.gpc1:STS.2010.b:2011:04:24:STS.V3:skycell.1.02:STS.V3.skycell.1.02.WS.dif.124301.trace';


UPDATE Files_ipp008_00 
SET 
  size=119034, 
  md5sum='cd0096c90bfc3c5cd41a9a53eac25bb2',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.916090',
  stage='warp'
WHERE filename='863103882.gpc1:CNP.nt:2011:04:24:o5675g0288o.328912:o5675g0288o.328912.wrp.185849.skycell.079.pswarp.mdc';


UPDATE Files_ipp008_00 
SET 
  size=120149, 
  md5sum='c745a7b893e4c86b61a7489919757f6f',
  role='bttable',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.943455',
  stage='raw'
WHERE filename='862729668.gpc1:20100826:o5434g0357o:o5434g0357o.ota65.burn.tbl';


UPDATE Files_ipp008_00 
SET 
  size=116074, 
  md5sum='627fa1efe097730cc41ac79f844be2e7',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.949409',
  stage='chip'
WHERE filename='852192579.gpc1:ThreePi.nt:2011:04:21:o5672g0289o.327079:o5672g0289o.327079.ch.215672.XY11.ppImage.mdc';


UPDATE Files_ipp008_00 
SET 
  size=36071, 
  md5sum='60e33c377cc50d4aba6874cc8f28903a',
  role='bttable',
  lifetime='permanent',
  last_check='2012-04-26 17:23:34.990221',
  stage='raw'
WHERE filename='796782681.gpc1:20101008:o5477g0034o:o5477g0034o.ota31.burn.tbl';


UPDATE Files_ipp008_00 
SET 
  size=47205, 
  md5sum='f68e881fb628efcabe6a88eddeee89ed',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.012169',
  stage='diff'
WHERE filename='1100813228.gpc1:ThreePi.nt:2011:07:16:RINGS.V0:skycell.1985.079:RINGS.V0.skycell.1985.079.dif.145157.b2.jpg';

UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1407043769.gpc1:ThreePi.nt:2011:10:07:o5841g0054o.403324:SR_o5841g0054o.403324.cm.290047.XY10.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1221266234.gpc1:ThreePi.nt:2011:08:24:o5797g0421o.381914:SR_o5797g0421o.381914.cm.253188.XY11.mk.fits';

UPDATE Files_ipp008_00 
SET 
  size=392, 
  md5sum='40cfe68524244a06c72c83e41394da08',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.040865',
  stage='destreak'
WHERE filename='1469665453.gpc1:destreak:ThreePi.nightlyscience:408974:diff:408974.mds.789898.181359.skycell.1154.072.stats';


UPDATE Files_ipp008_00 
SET 
  size=43200, 
  md5sum='f74abfb6ef79201f2a79270b5ada545d',
  role='mdl',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:35.061761',
  stage='chip'
WHERE filename='1533047618.gpc1:ThreePi.nt:2011:11:05:o5870g0016o.416965:o5870g0016o.416965.ch.337706.XY21.mdl.fits';

UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1549623588.gpc1:LAP.ThreePi.20110809:2011:11:08:o5478g0239o.237016:SR_o5478g0239o.237016.cm.316900.XY11.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='932656438.gpc1:ThreePi.nt:2011:05:15:o5696g0097o.336092:SR_o5696g0097o.336092.cm.210296.XY10.mk.fits';

UPDATE Files_ipp008_00 
SET 
  size=48402, 
  md5sum='d297d433fd785359a2f7d205f99a22aa',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.076547',
  stage='diff'
WHERE filename='934896160.gpc1:ThreePi.nt:2011:05:16:RINGS.V0:skycell.1712.073:RINGS.V0.skycell.1712.073.dif.132284.b2.jpg';


UPDATE Files_ipp008_00 
SET 
  size=52433, 
  md5sum='a3d9f188e60c0be2e9fd4474591646e4',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.093525',
  stage='diff'
WHERE filename='953587223.gpc1:STS.2010.b:2011:05:23:STS.V3:skycell.0.03:STS.V3.skycell.0.03.WS.dif.133815.b2.jpg';


UPDATE Files_ipp008_00 
SET 
  size=469440, 
  md5sum='731478793608f9a836b79c72c2ac0006',
  role='catalog',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.179479',
  stage='chip'
WHERE filename='955673061.gpc1:ThreePi.nt:2011:05:24:o5705g0172o.340308:SR_o5705g0172o.340308.ch.235359.XY10.cmf';

UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='957898427.gpc1:ThreePi.nt:2011:05:24:o5705g0562o.340698:SR_o5705g0562o.340698.cm.213598.XY10.mk.fits';

UPDATE Files_ipp008_00 
SET 
  size=121611, 
  md5sum='ee8e54cd1bbeb3f34e07a2ecd6508fc7',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.192353',
  stage='warp'
WHERE filename='999788561.gpc1:ThreePi.nt:2011:06:12:o5724g0263o.347160:o5724g0263o.347160.wrp.207962.skycell.1657.015.pswarp.mdc';

UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='781250321.gpc1:ThreePi.nt:2011:03:17:o5637g0479o.312212:SR_o5637g0479o.312212.cm.185468.XY10.mk.fits';

UPDATE Files_ipp008_00 
SET 
  size=118961, 
  md5sum='63278780c5896a67af7fe97081faffd2',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.216919',
  stage='chip'
WHERE filename='1245281598.gpc1:LAP.ThreePi.20110809:2011:09:01:o5362g0466o.181725:o5362g0466o.181725.ch.280483.XY31.ppImage.mdc';

UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1263706200.gpc1:ThreePi.nt:2011:09:06:o5810g0194o.387805:SR_o5810g0194o.387805.cm.260727.XY01.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='575563415.gpc1:ThreePi.nt:2010:12:15:o5545g0065o.264466:SR_o5545g0065o.264466.cm.150428.XY10.mk.fits';
UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1330963359.gpc1:LAP.ThreePi.20110809:2011:09:22:o5389g0402o.191736:o5389g0402o.191736.ch.296171.XY10.stats';

UPDATE Files_ipp008_00 
SET 
  size=2812, 
  md5sum='4b81e6453de914b6aa6faeb973c0df5b',
  role='log',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.241551',
  stage='stack'
WHERE filename='1472871063.gpc1:LAP.ThreePi.20110809:2011:10:17:RINGS.V3:skycell.2001.089:RINGS.V3.skycell.2001.089.stk.89171.add.396125.log';


UPDATE Files_ipp008_00 
SET 
  size=40320, 
  md5sum='ef328bed71629aeee797ce8fd5d690b6',
  role='catalog',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.266039',
  stage='diff'
WHERE filename='1473392402.gpc1:ThreePi.nt:2011:10:19:RINGS.V3:skycell.1237.058:SR_RINGS.V3.skycell.1237.058.dif.181692.cmf';


UPDATE Files_ipp008_00 
SET 
  size=2551, 
  md5sum='8837e0116fbc0a04fd26ab97d49acf60',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.279330',
  stage='diff'
WHERE filename='1473556677.gpc1:LAP.ThreePi.20110809:2011:10:19:RINGS.V3:skycell.1758.029:RINGS.V3.skycell.1758.029.dif.181752.stats';


UPDATE Files_ipp008_00 
SET 
  size=117815, 
  md5sum='a75e739ec709bc9d73bbd6345dd00374',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.308075',
  stage='chip'
WHERE filename='1474009876.gpc1:ThreePi.nt:2011:10:19:o5853g0564o.409712:o5853g0564o.409712.ch.328338.XY11.ppImage.mdc';


UPDATE Files_ipp008_00 
SET 
  size=524, 
  md5sum='fbe9aa43e5a0d353cf26590876e286dc',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.341196',
  stage='destreak'
WHERE filename='1475215505.gpc1:destreak:ThreePi.nightlyscience:409596:warp:409596.mds.793080.290015.skycell.1336.060.stats';


UPDATE Files_ipp008_00 
SET 
  size=38135, 
  md5sum='e8d0c26ab91d282625b745e85fb1aa00',
  role='log',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.364066',
  stage='warp'
WHERE filename='1478614018.gpc1:ThreePi.nt:2011:10:20:o5854g0365o.410098:o5854g0365o.410098.wrp.290820.skycell.1780.054.log';


UPDATE Files_ipp008_00 
SET 
  size=22345920, 
  md5sum='fc2a7785ed777c8f04f37866ad244e08',
  role='fits',
  lifetime='raw',
  last_check='2012-04-26 17:23:35.833648',
  stage='raw'
WHERE filename='1480160478.gpc1:20111021:o5855g0176o:o5855g0176o.ota10.fits';

UPDATE Files_ipp008_00 SET role='DELETED' WHERE filename='1495032700.gpc1:ThreePi.nt:2011:10:26:o5860g0164o.414391:SR_o5860g0164o.414391.cm.308414.XY10.mk.fits';

UPDATE Files_ipp008_00 
SET 
  size=449280, 
  md5sum='0c0c139c0296bd5a56303bf3fc7187a2',
  role='catalog',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.897298',
  stage='warp'
WHERE filename='999867099.gpc1:MSS.nt:2011:06:12:o5724g0302o.347203:SR_o5724g0302o.347203.wrp.207993.skycell.1324.123.cmf';


UPDATE Files_ipp008_00 
SET 
  size=118807, 
  md5sum='abcebf1e29025b6b5c6b0c7ab4f61fea',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.929583',
  stage='chip'
WHERE filename='1004414303.gpc1:STS.nt:2011:06:14:o5726g0233o.348168:o5726g0233o.348168.ch.242262.XY10.ppImage.mdc';


UPDATE Files_ipp008_00 
SET 
  size=569, 
  md5sum='87eae31e8bfb386ab0092d3d9ac6998f',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:35.961154',
  stage='destreak'
WHERE filename='1061730239.gpc1:destreak:ThreePi.nightlyscience:355025:chip:355025.mds.576142.251278.XY11.stats';


UPDATE Files_ipp008_00 
SET 
  size=60480, 
  md5sum='26b63b3e31fb47b3d20d178e84d7c531',
  role='psf',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.023198',
  stage='warp'
WHERE filename='1068560070.gpc1:ThreePi.nt:2011:07:04:o5746g0370o.357406:o5746g0370o.357406.wrp.218020.skycell.2146.134.psf';


UPDATE Files_ipp008_00 
SET 
  size=411840, 
  md5sum='79b2f0fa08d53e2559d335c58dee301e',
  role='b1fits',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.138774',
  stage='chip'
WHERE filename='1070506154.gpc1:MSS.nt:2011:07:05:o5747g0581o.358287:o5747g0581o.358287.ch.253371.XY04.b1.fits';


UPDATE Files_ipp008_00 
SET 
  size=95040, 
  md5sum='52b33c540936458a6add230c1f00e340',
  role='psf',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:36.188765',
  stage='chip'
WHERE filename='1070942881.gpc1:LAP.ThreePi.20110621:2011:07:05:o5237g0319o.133244:o5237g0319o.133244.ch.253485.XY44.psf';


UPDATE Files_ipp008_00 
SET 
  size=40320, 
  md5sum='83cc239ecba0f3c427e6b8db2ef7d699',
  role='mdl',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:36.221508',
  stage='chip'
WHERE filename='1072681397.gpc1:ThreePi.nt:2011:07:06:o5748g0112o.358499:o5748g0112o.358499.ch.254282.XY01.mdl.fits';


UPDATE Files_ipp008_00 
SET 
  size=552609, 
  md5sum='19b26afa3e1fa2bb5bef6e5c60808f30',
  role='b1jpg',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.300380',
  stage='diff'
WHERE filename='1075890741.gpc1:ThreePi.nt:2011:07:06:RINGS.V0:skycell.0962.063:RINGS.V0.skycell.0962.063.dif.143499.b1.jpg';


UPDATE Files_ipp008_00 
SET 
  size=60480, 
  md5sum='2fb14645d5e948a940fa94737f9e5424',
  role='psf',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.315930',
  stage='warp'
WHERE filename='1077901104.gpc1:LAP.ThreePi.20110621:2011:07:05:o5238g0452o.133778:o5238g0452o.133778.wrp.219297.skycell.1290.045.psf';


UPDATE Files_ipp008_00 
SET 
  size=1440, 
  md5sum='a952e3612d3f1f0107376eeb4144ee62',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.350513',
  stage='warp'
WHERE filename='1086489119.gpc1:ThreePi.nt:2011:07:12:o5754g0509o.360742:o5754g0509o.360742.wrp.220781.skycell.0795.120.stats';


UPDATE Files_ipp008_00 
SET 
  size=119005, 
  md5sum='c27d0a183b8bac93463a30260e3a3255',
  role='mdc',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.381286',
  stage='diff'
WHERE filename='1094105389.gpc1:ThreePi.nt:2011:07:14:RINGS.V0:skycell.2084.108:RINGS.V0.skycell.2084.108.dif.144731.ppSub.mdc';


UPDATE Files_ipp008_00 
SET 
  size=569, 
  md5sum='efd6ef4ffa2b951d0bc9b1a8e07bb8b0',
  role='stats',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.403089',
  stage='destreak'
WHERE filename='1096170693.gpc1:destreak:ThreePi.nightlyscience:362283:chip:362283.mds.590820.256861.XY10.stats';


UPDATE Files_ipp008_00 
SET 
  size=60480, 
  md5sum='4e0a4fe8a7cbbdb41e86fbc4a9782d2c',
  role='psf',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.425751',
  stage='warp'
WHERE filename='1060025415.gpc1:ThreePi.nt:2011:07:01:o5743g0597o.355900:o5743g0597o.355900.wrp.216752.skycell.1500.075.psf';


UPDATE Files_ipp008_00 
SET 
  size=100800, 
  md5sum='d0c08545703c7d1dab758cfd59b4ee07',
  role='psf',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:36.456045',
  stage='chip'
WHERE filename='1057100047.gpc1:ThreePi.nt:2011:07:01:o5743g0054o.355359:o5743g0054o.355359.ch.251492.XY10.psf';


UPDATE Files_ipp008_00 
SET 
  size=43200, 
  md5sum='63a85188dab3bf284787dcd087ebea5a',
  role='catalog',
  lifetime='permanent',
  last_check='2012-04-26 17:23:36.477608',
  stage='diff'
WHERE filename='1047544439.gpc1:ThreePi.nt:2011:06:27:RINGS.V0:skycell.0877.038:SR_RINGS.V0.skycell.0877.038.dif.141323.inv.cmf';


UPDATE Files_ipp008_00 
SET 
  size=40320, 
  md5sum='dddfcb59429784dfdf78545d19252631',
  role='mdl',
  lifetime='ephemeral',
  last_check='2012-04-26 17:23:36.494033',
  stage='chip'
WHERE filename='1005250237.gpc1:STD:2011:06:14:o5708g0083o.341186:o5708g0083o.341186.ch.242447.XY62.mdl.fits';

