`pilot/morris_image_backfill_restore.sql`

7 lines
-- RESTORE: revert the backfill (all target rows were NULL before)
BEGIN;
UPDATE morris_feed_pricing SET image=NULL WHERE base_code IN ('DJA1A7102','DJA1A7103','DMY1BT101','DBPW216962','MCOW217105','DGW1CY101','DJA1CY103','DGW196101','DJA196102','MCOW217098','MCOW217099','DJA1D1102','DGW1FU101','DGW1FU102','DGW1FU103','DM6P210395','DM6P210396','DM6P210397','AARC510010','MSIM217084','MSIM217085','MSIM217086','MSIM217087','AARC510018','AARC510019','MCOW217102','MCOW217103','DMI1G3101','DMI1G3102','DMI1G3103','DMC1HS102','DMC1HS103','MCOW217094','MCOW217095','DMY1OJ108','DGW148101','DGW148107','DGW148108','DGW148113','DMC148118','MSIM217066','MSIM217067','DBPW216960','DBPW216961','DMC130101','MFRW217369','MFRW217370','DMC1W2101','DGW1WB101','DJA1WB103','DBPW216948','DBPW216949','DBPW216950','DBPW216951','DBPW216952','MSIM217080','MSIM217081','MSIM217082','MSIM217083','MCOW217088','MCOW217089','DMI1W6102','DMI1W6103','DMORBR103','DMORBR105','DMOWCH101','DMOWCH103','DMOWCH104','MSIM217068','MSIM217069','MSIM217070','DM6P210355','DM6P210398','DM6P210399','DM6P210400','DM6P210401','DM6P210402','DM6P210403','AARC510006','AARC510007','AARC510014','AARC510015','MVOW217330','DM6P210367','DM6P210368','DM6P210369','DM6P210370','DM6P210371','DM6P210372','DBPW216953','DBPW216954','DBPW216955','MCOW217090','MCOW217091','MCOW217092','MCOW217093','DM6P210347','DM6P210349','MFRW217366','MFRW217367','MFRW217368','DM6P210386','DM6P210387','DM6P210388','DM6P210389','DM6P210390','MVOW217331','MVOW217332','MVOW217333','MFRW217362','MFRW217363','MFRW217364','MFRW217365','DM6P210362','DM6P210363','DM6P210364','DM6P210365','DM6P210381','DM6P210382','DM6P210383','DM6P210384','DM6P210385','DBPW216963','DBPW216964','DBPW216965','DARW212550','DARW212551','DARW212552','DARW212553','DARW212554','DARW212537','DARW212538','DARW212539','DARW212540','DARW212545','DARW212546','DARW212547','DARW212548','DARW212549','DARW212559','DARW212560','DARW212561','DARW212562','AARC510005','AARC510020','AARC510034','DARW212555','DARW212556','DARW212557','DARW212558','DARW212541','DARW212542','DARW212543','DARW212544','MVOW217334','MVOW217335','DARW212566','DARW212567','DARW212568','DARW212569','DARW212563','DARW212564','DARW212565','DM3W214718','DM3W214719','DM3W214720','MFRW217356','DM3W214735','DBPW216959','MCOW217096','MCOW217097','DM3W214695','DM3W214700','DM3W214701','DM3W214703','DM3W214704','MFRW217371','DM3W214724','DM3W214728','DM3W214729','DM3W214730','DM3W214731','DM3W214712','DM3W214713','DM3W214714','DM3W214715','DM3W214716','DM3W214887','DM3W214888','DMPU216050','DMPU216051','DMPU216033','DMPU216040','DMPU216041','DMPU216042','DMPU216043','DMPU216044','DMPU216027','DMPU216028','DMPU216029','DMPU216030','DMPU216031','DMPU216036','DMPU216037','DMPU216038','DMPU216039','DMPU216032','DMPU216034','DMPU216035','DMPU216045','DMPU216046','DMPU216047','DMPU216048','DMPU216049','DMPU216022','DMPU216023','DMPU216024','DMPU216025','DMPU216026','DMA4216439','DMA4216440','DMA4216441','DMA4216442','DMA4216443','DMA4216444','DMA4216445','DMA4216431','DMA4216432','DMA4216433','DMA4216434','DMA4216435','DMA4216436','DMA4216437','DMA4216438','DMA4216425','DMA4216426','DMA4216427','DMA4216428','DMA4216429','DMA4216430','DMA4216420','DMA4216421','DMA4216423','DMA4216424','DMA4216422','DMPN216553','DMPN216554','DMPN216532','DMPN216530','DMPN216531','DMPN216533','DMPN216534','DMPN216520','DMPN216521','DMPN216522','DMPN216540','DMPN216541','DMPN216542','DMPN216543','DMPN216523','DMPN216524','DMPN216525','DMPN216526','DMPN216535','DMPN216536','DMPN216537','DMPN216538','DMPN216539','DMPN216544','DMPN216545','DMPN216546','DMPN216547','DMPN216548','DMPN216549','DMPN216550','DMPN216551','DMPN216552','DMPN216527','DMPN216528','DMPN216529','DMSW216688','DMSW216689','DMSW216690','DMSW216691','DMSW216692','DMSW216699','DMSW216700','DMSW216701','DMSW216702','DMSW216680','DMSW216684','DMSW216672','DMSW216673','DMSW216674','DMSW216675','DMSW216676','DMSW216677','DMSW216678','DMSW216679','MSIM217071','MSIM217072','DMSW216706','DMSW216707','DMSW216693','DMSW216694','DMSW216695','DMSW216696','DMSW216697','DMSW216698','DMSW216703','DMSW216704','DMSW216705','DMSW216685','DMSW216686','DMSW216687','DMSW216671','DBPW216958','DBPW216956','DBPW216957','DCMW217055','AARC510008','AARC510009','MSIM217062','MSIM217063','MSIM217064','MSIM217065','MSIM217073','MSIM217074','MSIM217075','MSIM217076','MSIM217058','MSIM217059','MSIM217060','MSIM217061','MSIM217077','MSIM217078','MSIM217079','AARC510021','AARC510022','AARC510016','AARC510017','AARC510030','MCOW217104','MCOW217100','MCOW217101','MEWW217192','MEWW217193','MEWW217194','MEWW217195','MEWW217196','MEWW217197','MEWW217198','MEWW217199','MEWW217203','MEWW217204','MEWW217205','MEWW217200','MEWW217201','MEWW217202','MEWW217183','MEWW217184','MEWW217185','MEWW217186','MEWW217206','MEWW217207','MEWW217208','MEWW217190','MEWW217191','MEWW217209','MEWW217210','MEWW217187','MEWW217188','MEWW217189','MVOW217350','MVOW217351','MVOW217352','MVOW217353','MVOW217341','MVOW217342','MVOW217354','MVOW217355','MVOW217343','MVOW217344','MVOW217345','MVOW217336','MVOW217337','MVOW217338','MVOW217339','MVOW217340','MVOW217346','MVOW217347','MVOW217348','MVOW217349','MFRW217357','MFRW217358','MFRW217359','MFRW217360','MFRW217361','MUNW217608','MUNW217609','MUNW217587','MUNW217588','MUNW217580','MUNW217581','MUNW217582','MUNW217583','MUNW217584','MUNW217585','MUNW217586','MUNW217603','MUNW217604','MUNW217566','MUNW217567','MUNW217568','MUNW217595','MUNW217596','MUNW217597','MUNW217592','MUNW217593','MUNW217594','MUNW217589','MUNW217590','MUNW217591','MUNW217612','MUNW217613','MUNW217569','MUNW217570','MUNW217571','MUNW217598','MUNW217599','MUNW217564','MUNW217565','MUNW217610','MUNW217611','MUNW217600','MUNW217601','MUNW217602','MUNW217576','MUNW217577','MUNW217578','MUNW217579','MUNW217572','MUNW217573','MUNW217574','MUNW217575','MOW0164-01','MOW0164-02','MOW0165-01','MOW0165-02','MOW0165-03','MOW0167-02','MOW0168-01','MOW0168-02','MOW0168-03','MOW0170-01','MOW0170-02','MOW0170-03','MOW0170-04','MOW0171-01','MOW0171-02','MOW0172-01','MOW0172-02','MOW0173-01','MOW0174-01','MOW0174-02','MOW0174-03','MOW0175-01','MOW0175-02','MOW0175-03','DMY1BT201','DJA196201','DJA196202','DMC196204','AARC520009','DMC1F1203','DJA1FU201','AARC520006','DMC1FU205','MSIM226906','MSIM226907','DMC1G4203','DMC1G4206','DMC1G3201','DMC1G3202','DMI1G3204','DJA1HS201','DMC1HS203','DMC130202','MFRF227240','MFRF227241','DMC1W2203','DMC1W2204','MLIF227243','MLIF227244','MLIF227245','DJA1WB203','DMC1WB209','DKH1WB206','DMORBR201','DMORBR202');
UPDATE morris_feed_pricing SET image=NULL WHERE base_code IN ('DMORBR205','DMORHO201','DMORHO202','DMORHO203','DMORHO204','DMCOGR201','DMCOLI202','MLIF227246','DMCOMA201','DMCOMA203','DMCOMA204','DM6W230271','DM6W230272','DM6W230273','DM6F220329','DM6W230284','DM6W230285','DM6W230286','DM6W230287','DM6E230343','DM6E230341','DM6E230342','DM6F220326','DM6F220327','DM6F220328','DM6F220322','DM6F220323','DM6F220324','DM6F220316','DM6F220317','DM6F220318','DM6F220319','DM6F220320','DM6F220321','DM6E230340','DM6F220304','DM6F220305','DM6F220306','DM6F220311','DM6F220312','DM6F220313','DM6F220314','DM6F220315','AARC520016','AARC520017','DM6W230288','DM6W230289','DM6W230290','DM6W230291','DARP222526','DARP222527','DARP222528','DARP222533','DARP222534','DARP222535','DARP222643','DARP222521','DARP222522','DARP222525','DARP222529','DARP222530','DARP222531','DARP222532','DMEM234544','DMEM234545','DM3P224462','DM3P224463','DM3P224465','MFRF227235','MFRF227236','DM3P224470','DM3P224471','DM3P224472','DM3P224491','DM3P224492','DM3P224493','DM3P224494','DM3P224484','DM3P224485','DM3P224486','DM3P224487','DM3P224488','DM3P224490','MLIF227260','DM3P224466','DM3P224467','DM3P224468','DM3P224469','DM3P224497','DM3P224561','DM3P224498','DMPU226063','DMPU236068','DMPU236069','DMPU236070','DMPU236074','DMPU236075','DMPU236076','DMPU236077','DMPU236078','DMPU236080','DMPU236081','DMPU236071','DMPU236072','DMPU236073','DMPU226060','DMPU226061','DMPU236167','DMPU236168','DMPU236064','DMPU236065','DMPU236066','DMPU236067','MAMB227114','MAMB227115','MAMB227116','DMA4226399','DMA4226400','DMA4226401','DMA4236507','DMA4236508','DMA4236510','DMA4236512','DMA4236513','DMA4236514','DMA4236515','DMA4236516','DMA4236517','DMA4236518','DMA4226392','DMA4226393','DMA4226394','DMA4226395','DMA4236519','DMA4236520','DMA4226406','DMA4226407','DMA4226408','DMA4226409','DMA4226402','DMA4226403','DMA4226404','DMA4226405','DMA4226396','DMA4226397','DMA4226398','DM4U226389','DM4U226390','DM4U226391','DM4U226419','DM4U236524','DM4U236527','MLIF237420','DMPN236625','DMPN236626','DMPN236618','DMPN236619','DMPN236620','DMPN236615','DMPN236616','DMPN236617','DMPN226485','DMPN226486','DMPN236621','DMPN236622','DMPN226477','DMPN236627','DMPN236628','DMPN236629','DMPN236632','DMPN236633','DMPN236650','DMPN226482','DMPN226481','DMPN226483','DMPN226484','DMPN236630','DMPN236631','DMPN236612','DMPN236613','DMPN236614','DMPN226480','DMPN226488','DMPN226479','DMPK236642','MLIF237424','MLIF237425','MLIF237426','MLIF237427','DMLF236846','DMLF236847','DMLF236848','DM5F236813','DM5F236814','DM5F236815','DM5F226597','DM5F226598','DM5F226599','DMLF236836','DMLF236837','DMLF236838','DMLF236839','DMLF236840','DM5F236823','DMLF236832','DMLF236833','DMLF236834','DMLF236835','DMLF236852','DM5F226600','DM5F226601','DM5F226602','DM5F236816','DM5F236817','DM5F236818','DMLF236827','DMLF236828','DMLF236829','DMLF236830','DMLF236831','DM5F236824','DM5F236825','DM5F226587','DM5F226588','DM5F226589','DM5F226590','DM5F226606','DM5F226614','DRUC236853','DRUC236854','DRUC236855','DRUC236856','DRUC236857','DRUC236858','DRUC236859','DRUC236860','DRUC236861','DRUC236862','DRUC236863','DRUC236864','DRUC236865','DRUC236866','DRUC236867','DRUC236868','DRUC236869','DRUC236870','DRUC236871','DRUC236872','DRUC236873','DRUC236874','DRUC236875','DRUC236876','DRUC236877','DRUC236878','DRUC236879','DRUC236880','DRUC236881','DRUC236882','DM5F236826','DM5F226591','DM5F226592','DM5F226593','DM5F236821','DM5F236822','DM5F226594','DM5F226595','DM5F226596','DMLF236841','DMLF236842','DMLF236843','DMLF236844','DMLF236845','DM5F236819','DM5F236820','DMLF236849','DMLF236850','DMLF236851','DM5F226603','DM5F226604','DM5F226605','DROF236924','DROF236925','DROF236926','DROF236927','DROF236938','DROF236939','DROF236940','DROF236943','DROF236944','DROF236935','DROF236936','DROF236937','DROF236931','DROF236932','DROF236933','DROF236928','DROF236929','DROF236930','DBPF226840','MCOP226986','MCOP226987','DBPF226848','DBPF226849','DBPF226855','DBPF226853','DBPF226854','MCOP226992','MCOP226993','DBPF226850','DBPF226851','MCOP226984','MCOP226985','DBPF226856','DBPF226857','DBPF226844','DBPF226845','DBPF226846','DBPF226847','MCOP226980','MCOP226981','MCOP226982','MCOP226983','DBPF226852','DBPF226841','DBPF226842','DBPF226843','MCOP226978','MCOP226979','AARC520007','AARC520003','AARC520004','AARC520005','MSIM226896','MSIM226897','MSIM226910','MSIM226911','MSIM226912','MSIM226909','MSIM226919','MSIM226920','MSIM226921','MSIM226898','MSIM226899','MSIM226900','MSIM226901','MSIM226902','MSIM226903','MSIM226904','MSIM226905','MSIM226915','MSIM226916','MSIM226917','MSIM226918','MSIM226922','MSIM226923','MSIM226893','MSIM226894','MSIM226895','AARC520015','AARC520013','AARC520014','AARC520020','MCOP226988','MCOP226989','MCOP226994','MCOP226995','MCOP226990','MCOP226991','MAMB227099','MAMB227100','MAMB227101','MAMB227117','MAMB227118','MAMB227119','MAMB227120','MAMB227122','MAMB227123','MAMB227102','MAMB227103','MAMB227104','MAMB227105','MAMB227106','MAMB227121','MAMB227107','MAMB227108','MAMB227109','MAMB227110','MAMB227111','MAMB227112','MAMB227113','MEWF237311','MEWF237312','MEWF227036','MEWF227037','MEWF227038','MEWF227031','MEWF227032','MEWF227033','MEWF227027','MEWF227028','MEWF227029','MEWF227030','MEWF237310','MEWF237306','MEWF237307','MEWF227019','MEWF227020','MEWF227021','MEWF237313','MEWF237308','MEWF237309','MEWF227035','MEWF227022','MEWF227023','MEWF227034','MEWF227024','MEWF227025','MEWF227026','MWAR227000','MWAR227001','MWAR227002','MWAR227003','MWAR237292','MWAR237293','MWAR237280','MWAR237281','MWAR237282','MWAR237283','MWAR237284','MWAR237285','MWAR237286','MWAR237294','MWAR237295','MWAR237296','MWAR237297','MWAR237298','MWAR237299','MWAR237300','MWAR237301','MWAR237302','MWAR237303','MWAR237304','MWAR237305','MWAR237287','MWAR237288','MWAR237289','MWAR237290','MWAR237291','MLIF227252','MLIF227253','MLIF227254','MLIF227255','MFRF227237','MFRF227238','MFRF227239','MFRF227242','MLIF227250','MLIF227251','MFRF227230','MVOF227212','MVOF227213','MVOF227214','MFRF227231','MFRF227232','MFRF227233','MLIF227247','MLIF227248','MLIF227249','MLIF237421','MLIF237422','MLIF227256','MLIF227257','MLIF227258','MLIF227259','MVOF227223','MVOF227222','MVOF227224','MVOF227205','MVOF227228','MVOF227229','MVOF227211','MVOF227209','MVOF227210','MVOF227219','MVOF227220','MVOF227221','MVOF227215','MVOF227216','MVOF227206','MVOF227208','MVOF227207','MVOF227217','MVOF227218','MVOF227225','MVOF227226','MVOF227227','MIND237569','MIND237570','MIND237571','MIND237585');
UPDATE morris_feed_pricing SET image=NULL WHERE base_code IN ('MIND237586','MIND237587','MIND237588','MIND237589','MIND237590','MIND237591','MIND237592','MIND237593','MIND237594','MIND237595','MSWW227274','MIND237559','MIND237560','MIND237579','MIND237580','MIND237581','MIND237582','MIND237583','MIND237584','MIND237556','MIND237557','MIND237558','MIND237562','MIND237563','MIND237564','MSWW227291','MSWW227292','MIND237576','MIND237577','MIND237578','MSWW227275','MSWW227281','MSWW227282','MSWW227283','MSWW227297','MSWW227277','MSWW227278','MSWW227300','MSWW227289','MSWW227290','MSWW227295','MSWW227276','MSWW227298','MSWW227299','MSWW227296','MSWW227279','MSWW227280','MSWW227286','MSWW227287','MSWW227288','MSWW227273','MIND237572','MIND237573','MIND237574','MIND237575','MIND237566','MIND237567','MIND237568','MSWW227293','MSWW227294','MSWW227284','MSWW227285','MSTR237685','MSTR237686','MSTR237702','MSTR237703','MSTR237704','MHTF237660','MHTF237661','MHTF237655','MHTF237657','MHTF227387','MHTF227388','MHCB237677','MHCB237678','MHCB237679','MHTF237656','MHTF237666','MHTF237707','MHTF227355','MHTF227356','MHTF227357','MHCB237674','MHCB237675','MHCB237676','MHTF227369','MHTF227370','MHTF227371','MHTF227372','MSTR237699','MSTR237700','MSTR237701','MSTR237682','MSTR237683','MSTR237684','MSTR237695','MSTR237696','MSTR237697','MSTR237698','MHTF227373','MHTF227374','MHTF227375','MSTR237687','MSTR237688','MSTR237689','MHTF237662','MHTF237663','MHTF227379','MHTF227380','MHTF227381','MHTF227366','MHTF227367','MHTF227368','MHTF237653','MHTF237654','MHTF227358','MHTF227359','MHCB227384','MHCB227385','MHCB227386','MHCB237668','MHCB237669','MHCB237670','MHTF237658','MHTF237659','MHCB227382','MHCB227383','MHCB237680','MHCB237681','MSTR237690','MSTR237691','MSTR237692','MHTF227360','MHTF227361','MHTF227362','MHTF227364','MHTF227365','MHTF237664','MHTF237665','MHTF227376','MHTF227377','MHTF227378','MHCB237671','MHCB237672','MHCB237673','MHTF237652','MHTF237708','MHTF237709','MSTR237705','MSTR237706','MSTR237693','MSTR237694');
COMMIT;