Rapport de l'étude comparée des tables via sqldiff avec l'option --table  et via des pour requetes triées les bases :
 - Reference : https://d1cqiu28y3ja3g.cloudfront.net/pointdevente/db/spdv_mobile_res.sqlite.zip
 - Cible : https://d1cqiu28y3ja3g.cloudfront.net/pointdevente/backup/spdv_mobile_res.sqlite.zip

La référence contient 117 lignes.
La cible contient 122 lignes.

***********************************************************
RAPPORT CONSOLIDE
***********************************************************
liste des lignes manquantes dans la cible
marketbonus_id;market_id;status;match;pronostic;outcome_pos;event_id
"29073769";"29026961";"2";"Ath. Bilbao-FC Qarabag";"N.Williams et I.Williams";"5";"1214571"
"28953284";"28617813";"1";"Brighton Hove-Newcastle";"Brighton Hove";"1";"1213643"
"28955052";"28427561";"1";"Getafe-Real Madrid";"Real Madrid";"3";"1210527"
"29058198";"29026266";"0";"Leverkusen-Paris SG";"K.Kvaratskhelia ou B.Barcola";"8";"1213072"
"28953259";"28908036";"1";"Man. City-Everton";"E.Haaland ou I.Ndiaye";"6";"1213642"
"28955039";"28427234";"0";"Rennes-Auxerre";"Auxerre";"3";"1210460"
"28953179";"28940529";"0";"Chaves-Benfica";"Benfica / Oui";"5";"1218611"
"29073780";"29027250";"0";"Ein.Francfort-Liverpool";"Cody Gakpo";"4";"1213451"
"29027032";"28581838";"1";"Leverkusen-Paris SG";"Paris SG";"3";"1213072"
"28955029";"28889848";"0";"Tottenham-Aston Villa";"Oui et Tottenham";"1";"1213639"
"29073839";"29064287";"2";"J.Mensik-J.Fonseca";"0 - 2";"3";"1221342"
"29058200";"28998820";"0";"Arsenal-Atl. Madrid";"J.Alvarez ou A.Griezmann";"47";"1213064"
"28953305";"28427575";"1";"FC Barcelone-Gérone";"FC Barcelone";"1";"1210541"
"28953258";"28849174";"0";"Nottingham F.-Chelsea";"Chelsea - Chelsea";"9";"1213637"
"28953303";"28427493";"1";"Mayence-Leverkusen";"Leverkusen";"3";"1210477"
"28936075";"28191989";"0";"Grenoble-Pau";"Grenoble";"1";"1206623"
"28974090";"28963316";"0";"C.Moutet-A.Michelsen";"C.Moutet & +22.5 jeux";"1";"1219937"
"28953279";"28865055";"0";"Angers-Monaco";"Maghnes Akliouche";"27";"1210449"
"29058201";"28930054";"0";"PSV Eindhoven-Naples";"Naples / Oui";"5";"1214570"
"28997415";"28989588";"0";"U.Humbert-C.Ruud";"C.Ruud 6-3 ou 6-4";"5";"1220211"
"28953161";"28836215";"0";"Paris SG-Strasbourg";"Oui et Paris SG";"1";"1210445"
"28936082";"27898396";"0";"Al Feiha-Al Ittihad FC";"Al Feiha";"1";"1201190"
"28953302";"28857379";"0";"Man. City-Everton";"Philip Foden";"16";"1213642"
"29058199";"28929097";"1";"Leverkusen-Paris SG";"Paris SG et plus 3,5";"3";"1213072"
"28955047";"28617809";"1";"Tottenham-Aston Villa";"Aston Villa";"3";"1213639"
"29058333";"28929093";"1";"Leverkusen-Paris SG";"K.Kvaratskhelia";"46";"1213072"
"28953182";"28837182";"1";"Real Oviedo-Espanyol";"0:1, 0:2 ou 0:3";"2";"1210504"
"29027037";"28930082";"1";"PSV Eindhoven-Naples";"PSV Eindhoven";"1";"1214570"
"28953277";"28427239";"1";"Marseille-Le Havre";"Marseille";"1";"1210465"
"28955084";"28617808";"1";"West Ham-Brentford";"Brentford";"3";"1213638"
"28996157";"28986067";"1";"Toulon-Racing 92";"Gael Dréan";"5";"1197283"
"28955049";"28645844";"0";"Cagliari-Bologne";"Cagliari";"1";"1214003"
"28953256";"28865055";"0";"Angers-Monaco";"Ansu Fati";"24";"1210449"
"29058286";"29029454";"1";"J.Fearnley-A.Zverev";"A.Zverev & +22.5 jeux";"3";"1220408"
"29026940";"28917708";"0";"Nancy-Amiens";"Nancy et moins 2,5";"4";"1206597"
"28955043";"28427238";"0";"Nantes-Lille";"Nantes";"1";"1210464"
"28953277";"28427223";"0";"Angers-Monaco";"Angers";"1";"1210449"
"28955048";"28896954";"0";"Liverpool-Man. United";"Alexander Isak";"5";"1213644"
"29058317";"28940680";"0";"LA Lakers-GS Warriors";"Stephen Curry 28+";"4";"1200410"
"28955084";"28427546";"0";"Alaves-CF Valence";"CF Valence";"3";"1210512"
"28955047";"28617814";"0";"Liverpool-Man. United";"Liverpool";"1";"1213644"
"29058326";"28940633";"0";"OKC Thunder-HOU Rockets";"Kevin Durant 30+";"3";"1200409"
"28936067";"28191968";"0";"Troyes-Bastia";"Bastia";"3";"1206619"
"28953301";"28857432";"0";"Brighton Hove-Newcastle";"Newcastle";"3";"1213643"
"28953199";"28948573";"0";"Rodez-Reims";"Taïryk Arconte";"8";"1206612"
"28955043";"28427222";"1";"Lens-Paris FC";"Lens";"1";"1210448"
"28953303";"28427506";"0";"Wolfsburg-Stuttgart";"Wolfsburg";"1";"1210490"
"28974842";"28958841";"1";"Pau-Toulouse";"Ange Capuozzo";"16";"1197284"
"29073775";"29027199";"0";"Monaco-Tottenham";"M.Akliouche ou A.Fati";"37";"1214573"
"29058339";"28987618";"0";"AugerAliassime-G.Diallo";"3 sets";"2";"1220130"
"28936075";"28191968";"1";"Troyes-Bastia";"Troyes";"1";"1206619"
"28955052";"28427568";"0";"Elche-Ath. Bilbao";"Elche";"1";"1210534"
"28953271";"28908452";"0";"Bayern Munich-Dortmund";"Michael Olise";"4";"1210469"
"28936060";"28925915";"1";"J.Lehecka-B.Bonzi";"Oui";"1";"1219233"
"28953284";"28617805";"0";"Crystal Palace-Bournemouth";"Bournemouth";"3";"1213635"
"28953279";"28868122";"1";"Marseille-Le Havre";"Mason Greenwood";"5";"1210465"
"29058338";"29027330";"1";"Sporting-Marseille";"Igor Paixao";"12";"1214578"
"28955001";"28923868";"0";"Lens-Paris FC";"M.Simon ou I.Kebbal";"34";"1210448"
"28953200";"28948624";"1";"Boulogne-Guingamp";"Louis Mafouta";"22";"1206610"
"29027036";"28929385";"1";"Newcastle-Benfica";"Newcastle";"1";"1213068"
"28953200";"28948515";"0";"Troyes-Bastia";"Jaures Assoumou";"6";"1206619"
"29058337";"28581838";"1";"Leverkusen-Paris SG";"Paris SG";"3";"1213072"
"28953255";"28859923";"0";"Nice-Lyon";"Lyon / Non";"6";"1210444"
"29073770";"29027009";"0";"Galatasaray-Bodø/Glimt";"Leroy Sane";"5";"1214572"
"29027029";"29016921";"0";"D.Dzumhur-C.Moutet";"C.Moutet & +22.5 jeux";"3";"1220410"
"29073847";"29027284";"0";"Real Madrid-Juventus Turin";"Kylian Mbappe";"1";"1214577"
"28953188";"28947623";"0";"L.Musetti-G.Mpetshi";"G.Mpetshi & +25.5 jeux";"3";"1219607"
"28955049";"28641605";"1";"Milan AC-Fiorentina";"Milan AC";"1";"1213961"
"28953184";"28934042";"0";"Union Berlin-M'Gladbach";"Ilic, Andrej 1+";"1";"1210481"
"28955085";"28617808";"0";"West Ham-Brentford";"West Ham";"1";"1213638"
"28953302";"28857408";"1";"Crystal Palace-Bournemouth";"Jean Philippe Mateta";"21";"1213635"
"28955002";"28895960";"0";"Lorient-Brest";"Ludovic Ajorque";"41";"1210459"
"28953199";"28948515";"1";"Troyes-Bastia";"Tawfik Bentayeb";"7";"1206619"
"28953270";"28867291";"0";"AS Rome-Inter Milan";"Inter Milan et plus 2,5";"3";"1211191"
"29027032";"28629149";"0";"Kairat Almaty-Pafos FC";"Kairat Almaty";"1";"1213855"
"29058341";"28945496";"1";"Ein.Francfort-Liverpool";"Liverpool";"3";"1213451"
"29058333";"28929592";"0";"Arsenal-Atl. Madrid";"Julian Alvarez";"42";"1213064"
"29027023";"29020306";"1";"Leverkusen-Paris SG";"Vitinha Ferreira 1+";"2";"1213072"
"29073776";"28945039";"0";"Sporting-Marseille";"Marseille et plus 2,5";"3";"1214578"
"29027026";"28987598";"0";"G.Mpetshi-J.Fonseca";"2 - 0";"1";"1220133"
"28953305";"28427554";"0";"Villarreal-Betis Séville";"Betis Séville";"3";"1210520"
"28955054";"28923776";"0";"Liverpool-Man. United";"Mohamed Salah";"3";"1213644"
"28955039";"28427238";"1";"Nantes-Lille";"Lille";"3";"1210464"
"28953257";"28908710";"0";"Marseille-Le Havre";"P-E.Aubameyang";"2";"1210465"
"29058202";"29024223";"2";"Villarreal-Man. City";"Phil Foden 1+";"2";"1213065"
"28955037";"28934542";"2";"Getafe-Real Madrid";"Arda Guler 1+";"2";"1210527"
"28955027";"28923932";"1";"Nantes-Lille";"Olivier Giroud";"1";"1210464"
"28955007";"28895908";"0";"Rennes-Auxerre";"Rennes et plus 2,5";"1";"1210460"
"29027036";"28930082";"0";"PSV Eindhoven-Naples";"Naples";"3";"1214570"
"29058204";"28930524";"0";"Saint-Gilloise-Inter Milan";"1:2, 1:3 ou 1:4";"6";"1213063"
"29058337";"28688603";"0";"Sporting-Marseille";"Marseille";"3";"1214578"
"28953266";"28858402";"0";"FC Barcelone-Gérone";"Oui et FC Barcelone";"1";"1210541"
"29073847";"29027250";"1";"Ein.Francfort-Liverpool";"Hugo Ekitike";"3";"1213451"
"29026941";"28917644";"0";"US Cremonese-Udinese";"0:1, 0:2 ou 0:3";"2";"1210964"
"29058285";"28998904";"0";"Newcastle-Benfica";"Nick Woltemade";"1";"1213068"
"29027027";"28977850";"2";"S.Tsitsipas-L.Musetti";"Oui";"1";"1220143"

***********************************************************
RAPPORTS DETAILLES
CES DONNEES SONT DONNEES A TITRE INDICATIF
***********************************************************
Lignes de la référence manquantes dans la cible
Cette étude s'est faite sur toutes les colonnes sauf les exclues, mais le rapport présente toutes les colonnes

marketbonus_id;market_id;status;match;pronostic;outcome_pos;event_id
"28955054";"28923776";"0";"Liverpool-Man. United";"Mohamed Salah";"3";"1213644"
"28953182";"28837182";"1";"Real Oviedo-Espanyol";"0:1, 0:2 ou 0:3";"2";"1210504"
"28936082";"27898396";"0";"Al Feiha-Al Ittihad FC";"Al Feiha";"1";"1201190"
"28955043";"28427222";"1";"Lens-Paris FC";"Lens";"1";"1210448"
"29073780";"29027250";"0";"Ein.Francfort-Liverpool";"Cody Gakpo";"4";"1213451"
"29073839";"29064287";"2";"J.Mensik-J.Fonseca";"0 - 2";"3";"1221342"
"28955037";"28934542";"2";"Getafe-Real Madrid";"Arda Guler 1+";"2";"1210527"
"28955043";"28427238";"0";"Nantes-Lille";"Nantes";"1";"1210464"
"29027037";"28930082";"1";"PSV Eindhoven-Naples";"PSV Eindhoven";"1";"1214570"
"28955039";"28427238";"1";"Nantes-Lille";"Lille";"3";"1210464"
"29058201";"28930054";"0";"PSV Eindhoven-Naples";"Naples / Oui";"5";"1214570"
"28955039";"28427234";"0";"Rennes-Auxerre";"Auxerre";"3";"1210460"
"29027029";"29016921";"0";"D.Dzumhur-C.Moutet";"C.Moutet & +22.5 jeux";"3";"1220410"
"29058333";"28929592";"0";"Arsenal-Atl. Madrid";"Julian Alvarez";"42";"1213064"
"29058202";"29024223";"2";"Villarreal-Man. City";"Phil Foden 1+";"2";"1213065"
"29058333";"28929093";"1";"Leverkusen-Paris SG";"K.Kvaratskhelia";"46";"1213072"
"29058200";"28998820";"0";"Arsenal-Atl. Madrid";"J.Alvarez ou A.Griezmann";"47";"1213064"
"29058317";"28940680";"0";"LA Lakers-GS Warriors";"Stephen Curry 28+";"4";"1200410"
"28955027";"28923932";"1";"Nantes-Lille";"Olivier Giroud";"1";"1210464"
"28936067";"28191968";"0";"Troyes-Bastia";"Bastia";"3";"1206619"
"29027027";"28977850";"2";"S.Tsitsipas-L.Musetti";"Oui";"1";"1220143"
"28955029";"28889848";"0";"Tottenham-Aston Villa";"Oui et Tottenham";"1";"1213639"
"29058285";"28998904";"0";"Newcastle-Benfica";"Nick Woltemade";"1";"1213068"
"28953279";"28868122";"1";"Marseille-Le Havre";"Mason Greenwood";"5";"1210465"
"28953279";"28865055";"0";"Angers-Monaco";"Maghnes Akliouche";"27";"1210449"
"28953284";"28617805";"0";"Crystal Palace-Bournemouth";"Bournemouth";"3";"1213635"
"28953284";"28617813";"1";"Brighton Hove-Newcastle";"Brighton Hove";"1";"1213643"
"28953277";"28427239";"1";"Marseille-Le Havre";"Marseille";"1";"1210465"
"28953277";"28427223";"0";"Angers-Monaco";"Angers";"1";"1210449"
"29058286";"29029454";"1";"J.Fearnley-A.Zverev";"A.Zverev & +22.5 jeux";"3";"1220408"
"28953179";"28940529";"0";"Chaves-Benfica";"Benfica / Oui";"5";"1218611"
"28955084";"28617808";"1";"West Ham-Brentford";"Brentford";"3";"1213638"
"28953184";"28934042";"0";"Union Berlin-M'Gladbach";"Ilic, Andrej 1+";"1";"1210481"
"28955084";"28427546";"0";"Alaves-CF Valence";"CF Valence";"3";"1210512"
"28996157";"28986067";"1";"Toulon-Racing 92";"Gael Dréan";"5";"1197283"
"29058326";"28940633";"0";"OKC Thunder-HOU Rockets";"Kevin Durant 30+";"3";"1200409"
"28955085";"28617808";"0";"West Ham-Brentford";"West Ham";"1";"1213638"
"28997415";"28989588";"0";"U.Humbert-C.Ruud";"C.Ruud 6-3 ou 6-4";"5";"1220211"
"28953258";"28849174";"0";"Nottingham F.-Chelsea";"Chelsea - Chelsea";"9";"1213637"
"28953259";"28908036";"1";"Man. City-Everton";"E.Haaland ou I.Ndiaye";"6";"1213642"
"28955007";"28895908";"0";"Rennes-Auxerre";"Rennes et plus 2,5";"1";"1210460"
"29058341";"28945496";"1";"Ein.Francfort-Liverpool";"Liverpool";"3";"1213451"
"28953257";"28908710";"0";"Marseille-Le Havre";"P-E.Aubameyang";"2";"1210465"
"29073775";"29027199";"0";"Monaco-Tottenham";"M.Akliouche ou A.Fati";"37";"1214573"
"29027026";"28987598";"0";"G.Mpetshi-J.Fonseca";"2 - 0";"1";"1220133"
"29058338";"29027330";"1";"Sporting-Marseille";"Igor Paixao";"12";"1214578"
"28953271";"28908452";"0";"Bayern Munich-Dortmund";"Michael Olise";"4";"1210469"
"29026941";"28917644";"0";"US Cremonese-Udinese";"0:1, 0:2 ou 0:3";"2";"1210964"
"29073776";"28945039";"0";"Sporting-Marseille";"Marseille et plus 2,5";"3";"1214578"
"29058337";"28688603";"0";"Sporting-Marseille";"Marseille";"3";"1214578"
"29058337";"28581838";"1";"Leverkusen-Paris SG";"Paris SG";"3";"1213072"
"28953270";"28867291";"0";"AS Rome-Inter Milan";"Inter Milan et plus 2,5";"3";"1211191"
"28953161";"28836215";"0";"Paris SG-Strasbourg";"Oui et Paris SG";"1";"1210445"
"28974090";"28963316";"0";"C.Moutet-A.Michelsen";"C.Moutet & +22.5 jeux";"1";"1219937"
"29026940";"28917708";"0";"Nancy-Amiens";"Nancy et moins 2,5";"4";"1206597"
"29073770";"29027009";"0";"Galatasaray-Bodø/Glimt";"Leroy Sane";"5";"1214572"
"28953301";"28857432";"0";"Brighton Hove-Newcastle";"Newcastle";"3";"1213643"
"28953200";"28948624";"1";"Boulogne-Guingamp";"Louis Mafouta";"22";"1206610"
"29073847";"29027284";"0";"Real Madrid-Juventus Turin";"Kylian Mbappe";"1";"1214577"
"28953200";"28948515";"0";"Troyes-Bastia";"Jaures Assoumou";"6";"1206619"
"28953302";"28857408";"1";"Crystal Palace-Bournemouth";"Jean Philippe Mateta";"21";"1213635"
"29073847";"29027250";"1";"Ein.Francfort-Liverpool";"Hugo Ekitike";"3";"1213451"
"28953302";"28857379";"0";"Man. City-Everton";"Philip Foden";"16";"1213642"
"28953303";"28427493";"1";"Mayence-Leverkusen";"Leverkusen";"3";"1210477"
"28953303";"28427506";"0";"Wolfsburg-Stuttgart";"Wolfsburg";"1";"1210490"
"28955001";"28923868";"0";"Lens-Paris FC";"M.Simon ou I.Kebbal";"34";"1210448"
"28955047";"28617814";"0";"Liverpool-Man. United";"Liverpool";"1";"1213644"
"28955047";"28617809";"1";"Tottenham-Aston Villa";"Aston Villa";"3";"1213639"
"28955002";"28895960";"0";"Lorient-Brest";"Ludovic Ajorque";"41";"1210459"
"29058204";"28930524";"0";"Saint-Gilloise-Inter Milan";"1:2, 1:3 ou 1:4";"6";"1213063"
"28953188";"28947623";"0";"L.Musetti-G.Mpetshi";"G.Mpetshi & +25.5 jeux";"3";"1219607"
"28953266";"28858402";"0";"FC Barcelone-Gérone";"Oui et FC Barcelone";"1";"1210541"
"28955048";"28896954";"0";"Liverpool-Man. United";"Alexander Isak";"5";"1213644"
"29027032";"28581838";"1";"Leverkusen-Paris SG";"Paris SG";"3";"1213072"
"29027032";"28629149";"0";"Kairat Almaty-Pafos FC";"Kairat Almaty";"1";"1213855"
"28953305";"28427575";"1";"FC Barcelone-Gérone";"FC Barcelone";"1";"1210541"
"28953305";"28427554";"0";"Villarreal-Betis Séville";"Betis Séville";"3";"1210520"
"28953199";"28948573";"0";"Rodez-Reims";"Taïryk Arconte";"8";"1206612"
"28955049";"28645844";"0";"Cagliari-Bologne";"Cagliari";"1";"1214003"
"28953199";"28948515";"1";"Troyes-Bastia";"Tawfik Bentayeb";"7";"1206619"
"28955049";"28641605";"1";"Milan AC-Fiorentina";"Milan AC";"1";"1213961"
"29073769";"29026961";"2";"Ath. Bilbao-FC Qarabag";"N.Williams et I.Williams";"5";"1214571"
"29027023";"29020306";"1";"Leverkusen-Paris SG";"Vitinha Ferreira 1+";"2";"1213072"
"28953256";"28865055";"0";"Angers-Monaco";"Ansu Fati";"24";"1210449"
"29058339";"28987618";"0";"AugerAliassime-G.Diallo";"3 sets";"2";"1220130"
"28955052";"28427561";"1";"Getafe-Real Madrid";"Real Madrid";"3";"1210527"
"28936060";"28925915";"1";"J.Lehecka-B.Bonzi";"Oui";"1";"1219233"
"29027036";"28929385";"1";"Newcastle-Benfica";"Newcastle";"1";"1213068"
"29027036";"28930082";"0";"PSV Eindhoven-Naples";"Naples";"3";"1214570"
"28953255";"28859923";"0";"Nice-Lyon";"Lyon / Non";"6";"1210444"
"28936075";"28191989";"0";"Grenoble-Pau";"Grenoble";"1";"1206623"
"29058198";"29026266";"0";"Leverkusen-Paris SG";"K.Kvaratskhelia ou B.Barcola";"8";"1213072"
"28936075";"28191968";"1";"Troyes-Bastia";"Troyes";"1";"1206619"
"28974842";"28958841";"1";"Pau-Toulouse";"Ange Capuozzo";"16";"1197284"
"28955052";"28427568";"0";"Elche-Ath. Bilbao";"Elche";"1";"1210534"
"29058199";"28929097";"1";"Leverkusen-Paris SG";"Paris SG et plus 3,5";"3";"1213072"

Lignes de la cible manquantes dans la référence
Cette étude s'est faite sur toutes les colonnes sauf les exclues, mais le rapport présente toutes les colonnes

marketbonus_id;market_id;status;match;pronostic;outcome_pos;event_id