update formats prog crossmedia

-- TABELLARE
UPDATE formats SET progr = 1 WHERE id = 1; -- SPOT
UPDATE formats SET progr = 2 WHERE id = 2; -- INLOGO
UPDATE formats SET progr = 2 WHERE id = 229; -- SPOT IN APERTURA
UPDATE formats SET progr = 1 WHERE id = 12; -- DISPLAY STANDARD
UPDATE formats SET progr = 2 WHERE id = 13; -- DISPLAY ALTO IMPATTO
UPDATE formats SET progr = 1 WHERE id = 21; -- SPOT
UPDATE formats SET progr = 1 WHERE id = 26; -- SPOT

-- INIZIATIVE SPECIALI
UPDATE formats SET progr = 1 WHERE id = 3; -- LONG VIDEO FREE
UPDATE formats SET progr = 2 WHERE id = 4; -- SHORT VIDEO FREE
UPDATE formats SET progr = 3 WHERE id = 6; -- BRAND VIDEO FREE
UPDATE formats SET progr = 1 WHERE id = 9; -- LONG VIDEO PAY
UPDATE formats SET progr = 2 WHERE id = 8; -- SHORT VIDEO PAY
UPDATE formats SET progr = 3 WHERE id = 247; -- BRAND VIDEO PAY
UPDATE formats SET progr = 4 WHERE id = 10; -- SPONSORIZZAZIONE LIB PAY
UPDATE formats SET progr = 1 WHERE id = 14; -- SPECIALI EDITORIALI DIGITAL
UPDATE formats SET progr = 2 WHERE id = 248; -- NATIVE ADV DIGITAL
UPDATE formats SET progr = 3 WHERE id = 249; -- INFLUENCERS DIGITAL
UPDATE formats SET progr = 4 WHERE id = 18; -- ADVERGAME DIGITAL
UPDATE formats SET progr = 5 WHERE id = 250; -- OPINION DIGITAL
UPDATE formats SET progr = 1 WHERE id = 24; -- BILLBOARD
UPDATE formats SET progr = 2 WHERE id = 25; -- CITAZIONI
UPDATE formats SET progr = 3 WHERE id = 251; -- TOP E DOMINATION
UPDATE formats SET progr = 1 WHERE id = 27; -- ADVERTORIAL
UPDATE formats SET progr = 2 WHERE id = 34; -- CONCORSI
UPDATE formats SET progr = 3 WHERE id = 30; -- INSERTI
UPDATE formats SET progr = 4 WHERE id = 29; -- VEICOLAZIONI
UPDATE formats SET progr = 5 WHERE id = 37; -- FORMATI SPECIALI

-- CROSSMEDIA
UPDATE formats SET progr = 1 WHERE id = 41; -- CROSSMEDIA BRANDED
UPDATE formats SET progr = 2 WHERE id = 42; -- BRAND INTEGRATION
UPDATE formats SET progr = 3 WHERE id = 43; -- BRANDED CONTENT

-- ADV TECHNOLOGY
UPDATE formats SET progr = 1 WHERE id = 252; -- BBTV
UPDATE formats SET progr = 1 WHERE id = 253; -- ADDRESSABLE
UPDATE formats SET progr = 1 WHERE id = 255; -- SHAZAM ADV SYNC
UPDATE formats SET progr = 1 WHERE id = 256; -- PROGRAMMATIC
UPDATE formats SET progr = 2 WHERE id = 258; -- SHAZAM FOR RADIO
UPDATE formats SET progr = 1 WHERE id = 257; -- SHAZAM AUGMENTED

-- EVENTI
UPDATE formats SET progr = 1 WHERE id = 20; -- EVENTI DIGITAL
UPDATE formats SET progr = 1 WHERE id = 23; -- EVENTI RADIO
UPDATE formats SET progr = 1 WHERE id = 39; -- EVENTI STAMPA

-- PUNTI VENDITA
UPDATE formats SET progr = 1 WHERE id = 40; -- PUNTI VENDITA