(195,'CASE FRONT V T R\n{\"fn\":\"MOUDILOU\",\"gn\":\"GOLVON RIVEL\",\"dob\":\"1991-07-16\",\"tg\":\"840539006\",\"tt\":\"LP6464-4\",\"ma\":\"RealStar SARS-CoV-2 RT-PCR Kit 1.0\",\"sc\":\"2022-03-12T10:32:16+01:00\",\"tr\":260415000,\"nm\":\"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\",\"tc\":\"Palais des congres\",\"pid\":\"104CHCACMS22\",\"dcc_type_id\":null,\"sd\":\"2\",\"ci\":\"URN:UVCI:01:BJ:60c1ed65c90fa64c828\",\"co\":\"BJ\",\"is\":\"Ministere de la Sante du Benin\",\"ver\":\"1.3.0\"}\n{\'fn\': \'MOUDILOU\', \'gn\': \'GOLVON RIVEL\', \'dob\': \'1991-07-16\', \'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'ma\': \'RealStar SARS-CoV-2 RT-PCR Kit 1.0\', \'sc\': \'2022-03-12T10:32:16+01:00\', \'tr\': 260415000, \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tc\': \'Palais des congres\', \'pid\': \'104CHCACMS22\', \'dcc_type_id\': None, \'sd\': \'2\', \'ci\': \'URN:UVCI:01:BJ:60c1ed65c90fa64c828\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ver\': \'1.3.0\'}\nT Type\nType 1 to start\nLoading T type_dcc\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T10:32:16+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:60c1ed65c90fa64c828\"}]\nafter case Starting\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T10:32:16+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:60c1ed65c90fa64c828\"}]\n\n JSON DATA { \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T10:32:16+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:60c1ed65c90fa64c828\"}], \"dob\": \"1991-07-16\", \"nam\": {\"fn\": \"MOUDILOU\", \"gn\": \"GOLVON RIVEL\", \"fnt\": \"MOUDILOU\", \"gnt\": \"GOLVON<RIVEL\"}, \"ver\": \"1.3.0\", \"pid\": \"104CHCACMS22\"}\n\n JSON DATA123\n b\'{ \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T10:32:16+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:60c1ed65c90fa64c828\"}], \"dob\": \"1991-07-16\", \"nam\": {\"fn\": \"MOUDILOU\", \"gn\": \"GOLVON RIVEL\", \"fnt\": \"MOUDILOU\", \"gnt\": \"GOLVON<RIVEL\"}, \"ver\": \"1.3.0\", \"pid\": \"104CHCACMS22\"}\'\n\n JSON PAYLOAD\n{\'t\': [{\'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'tc\': \'Palais des congres\', \'sc\': \'2022-03-12T10:32:16+01:00\', \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tr\': \'260415000\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ci\': \'URN:UVCI:01:BJ:60c1ed65c90fa64c828\'}], \'dob\': \'1991-07-16\', \'nam\': {\'fn\': \'MOUDILOU\', \'gn\': \'GOLVON RIVEL\', \'fnt\': \'MOUDILOU\', \'gnt\': \'GOLVON<RIVEL\'}, \'ver\': \'1.3.0\', \'pid\': \'104CHCACMS22\'}\n\n CBOR PAYLOAD : b\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c0\\x08\\x06\\x1ab.\\xe2\\x089\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T10:32:16+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:60c1ed65c90fa64c828cdobj1991-07-16cnam\\xa4bfnhMOUDILOUbgnlGOLVON RIVELcfnthMOUDILOUcgntlGOLVON<RIVELcvere1.3.0cpidl104CHCACMS22\'\n\n CBOR PAYLOAD\nb\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c0\\x08\\x06\\x1ab.\\xe2\\x089\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T10:32:16+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:60c1ed65c90fa64c828cdobj1991-07-16cnam\\xa4bfnhMOUDILOUbgnlGOLVON RIVELcfnthMOUDILOUcgntlGOLVON<RIVELcvere1.3.0cpidl104CHCACMS22\'\n\n Public Key\nb\'-----BEGIN CERTIFICATE-----\\nMIICRzCCAe2gAwIBAgIUVCPtXj+5X2ffP/Y/H4vOZB+h8pcwCgYIKoZIzj0EAwIw\\nRjELMAkGA1UEBhMCQkoxHjAcBgNVBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEX\\nMBUGA1UEAwwOQ1NDQV9ER0NfQkpfMDEwHhcNMjIwMjA2MTIxMzE0WhcNMjQwMjA2\\nMTIxMzE0WjBaMQswCQYDVQQGEwJCSjERMA8GA1UECAwITGl0dG9yYWwxHjAcBgNV\\nBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEYMBYGA1UEAwwPRFMtU2FuaXRhaXJl\\nLTAxMFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAE1eafQkFnEHdgmdO4ZkAnpznV\\nJlN2vhXb5czc/zO+82Kbp5PIUmtWid1wnLWcRv5NjVx3MtjpU8vRT4X2ej79JqOB\\npDCBoTAOBgNVHQ8BAf8EBAMCB4AwHQYDVR0OBBYEFCNn8De3BcTaAqyrWQg2wAH9\\n7fM9MB8GA1UdIwQYMBaAFNvCZnB3/atBycb4N5Su6LWnW0LpMDcGA1UdHwQwMC4w\\nLKAqoCiGJmh0dHA6Ly9hbnNzaS5iai9DUkwvQ1NDQV9ER0NfQkpfMDEuY3JsMBYG\\nA1UdJQQPMA0GCysGAQQBjjePZQEBMAoGCCqGSM49BAMCA0gAMEUCIQDOmh0KmGuH\\n2xwlpq/L1S7F855pLLkXkUCMZ70z8pfbvwIgIabBd8ZH7Tfajd/4xCoC53SLVe3Z\\n/gBUvIYvwhjZbPk=\\n-----END CERTIFICATE-----\\n\'\n\n Fingerprint :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5ctO\\x07\\x96\\xbdO\\x01\\xc3y\"E\\xbb\\xc7%\\xc6\\x9c\\xf6\\xaey\\xe4\\xf0\\x91r\'\n - Fingerprint HEX :  f6fe27e4cde022c563744f0796bd4f01c3792245bbc725c69cf6ae79e4f09172\n - Fingerprint BASE64 :  9v4n5M3gIsVjdE8Hlr1PAcN5IkW7xyXGnPaueeTwkXI=\n\n KID :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5\'\n - KID HEX :  f6fe27e4cde022c5\n - KID BASE64 :  9v4n5M3gIsU=\n\n Private Key : b\'Ij3orGEajvSqMDrRo7+3IBwqJtEdQyQHkeUtMIyJ0ig=\'\nKEY :  {<class \'cose.keys.keyparam.KpKty\'>: <class \'cose.keys.keytype.KtyEC2\'>, <class \'cose.keys.keyparam.KpAlg\'>: <class \'cose.algorithms.Es256\'>, <class \'cose.keys.keyparam.EC2KpCurve\'>: <class \'cose.keys.curves.P256\'>, <class \'cose.keys.keyparam.EC2KpD\'>: b\'\"=\\xe8\\xaca\\x1a\\x8e\\xf4\\xaa0:\\xd1\\xa3\\xbf\\xb7 \\x1c*&\\xd1\\x1dC$\\x07\\x91\\xe5-0\\x8c\\x89\\xd2(\'}\n\n COSE PACKAGING :  b\'[BLOB]\'\n\n ZLIB :  b\'x\\xda\\xbb\\xd4\\xe2\\xbb\\x88Q\\x8d\\xc5\\xe3\\xdb?\\xf5\\\'g\\x1f(\\x1d]\\x10\\xc9\\x18\\xb9\\x841\\xc9\\xc9\\x8bE*Y\\xc6\\x80\\x83M*I\\xef\\x11\\x87%#\\xf3B\\xc6\\xa5\\x89%\\x8d+\\x93J\\xd23-L\\x0cL\\x8d-\\r\\x0c\\xcc\\x92JJ2|\\x02\\xccL\\xccLtM\\x92J\\x92\\x8b\\x02\\x12s\\x123\\x8b\\x15RR\\x8b\\x15\\x92\\xf3\\xf3\\xd2\\x8bR\\x8b\\x93\\x8a\\x93+$\\x8d\\x0c\\x8c\\x8ct\\r\\x8cu\\r\\x8dB\\x0c\\r\\xac\\x8c\\x8d\\xac\\x0c\\xcd\\xb4\\r\\x0c\\xad\\x0c\\x0c\\x92\\xf2r+\\xd4\\\\}<CR\\x933\\xdc\\x8b\\xf2K\\x0bt\\x14\\x82\\x1d\\x83\\x82u\\x9d\\xf3\\xc3t\\x8d\\x14\\xc0\\x12\\n\\xbe\\xeeN\\n\\xde\\x99%I%E\\x99Ff\\x06&\\x86\\xa6\\x06@}\\xc9\\xf9@\\x07&e\\x16W\\xc8\\xf9f\\xe6e\\x16\\x97\\xa4\\x16\\xa5\\x02mU\\xc8IT\\x08N\\xcc+\\x01\\xb2K\\x15\\x9cR\\xf32\\xf3\\x92\\x923+\\x94B\\x83\\xfc\\xacB\\xc3\\x9c=\\xad\\x80v:yY\\x99\\x19$\\x1b\\xa6\\xa6\\x98\\x99&[\\x1a\\xa4%\\x9a\\x99$[\\x18Y$\\xa7\\xe4\\\'e\\x19ZZ\\x1a\\xea\\x1a\\x98\\xeb\\x1a\\x9a%\\xe7%\\xe6.IJ\\xcb\\xcb\\xf0\\xf5\\x0fu\\xf1\\xf4\\xf1\\x0fMJ\\xcf\\xcbq\\xf7\\xf7\\t\\xf3\\xf7S\\x08\\xf2\\x0cs\\xf5IN\\xcb+\\x81K&\\xa7\\xe7\\x95@em \\xb2e@\\xe7\\x18\\xea\\x19\\xeb\\x19$\\x17d\\xa6\\xe4\\x18\\x1a\\x988{8;:\\xfb\\x06\\x1b\\x19E8\\xf0\\x86\\x08\\xef\\xebx\\x11\\xf1\\xd8b\\x15\\xb3M\\x86\\xb8\\xe6\\x93i\\x11\\x7f\\x16\\xcd\\xb2\\xf2P[x\\xa4\\xa75\\xea\\xc8\\x8a\\xba\\x9b\\x1f\"\\x8e\\xa6\\xcc8+\\xe6\\xf8e\\x7f[\\xa6O\\xf1\\xdf\\xeb\\xf3t^8^l\\xf4\\xf5\\xe8\\x9f\\xe0({Uh\\x01\\x00{+\\x94\\x06\'\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52T531WG.MPDRH-F5B4P/QGPF51AU$3HNO4*J8W-KSX4+M5TK96L6SR9MU9DV5 R1AMI4H9LUFA$PA$PSVEAMIUNIZB0SOEAN6DV2QJAWW2 $UYRQQJAFTIARI.R4HQ11YH3W1+ZER%HPN1R L/+H$R1DYM5R1ON1/PIMJE4%QK$F:M8IRIT*RHSU7K1UQ2+W37MGP/J-VOQ$HUCO5G1V5U$G1AGJ5B9.Z8M+8:Y001HPZ0Q+F/MVU+03ZCH4B NVV5TN%2LXKW%K: DIEP2SAC/9TJ5DOM.W2+LA%J6$NI4L6JXI%UG/YL WO*Z7 AGTH7WEB183DM3X2LBGJCNB XKMOJ$Q4N33NS4.$S6ZC0JB5I3DG3LWT-LJ/9TL4T.B9GYPZKU..1KQUGLUVY95CQFIEGAV+$UGMA:QUUTE1C9 UPOFG+*4KCTF68 ZD*OMA98X63KC31833/2J4L523/AJ:PF.L72XV7J3ZX8EIU$51PYT3C2:FRKX21 9*GNRSIO92W*20SM67AEBFA6LTUT9OHLRJQG4+3LO47/8TI$CHQBZ4A%DS:YU0-B7.BO/UGIT9FSSQFU6DX20-M560\'\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52T531WG.MPDRH-F5B4P/QGPF51AU$3HNO4*J8W-KSX4+M5TK96L6SR9MU9DV5 R1AMI4H9LUFA$PA$PSVEAMIUNIZB0SOEAN6DV2QJAWW2 $UYRQQJAFTIARI.R4HQ11YH3W1+ZER%HPN1R L/+H$R1DYM5R1ON1/PIMJE4%QK$F:M8IRIT*RHSU7K1UQ2+W37MGP/J-VOQ$HUCO5G1V5U$G1AGJ5B9.Z8M+8:Y001HPZ0Q+F/MVU+03ZCH4B NVV5TN%2LXKW%K: DIEP2SAC/9TJ5DOM.W2+LA%J6$NI4L6JXI%UG/YL WO*Z7 AGTH7WEB183DM3X2LBGJCNB XKMOJ$Q4N33NS4.$S6ZC0JB5I3DG3LWT-LJ/9TL4T.B9GYPZKU..1KQUGLUVY95CQFIEGAV+$UGMA:QUUTE1C9 UPOFG+*4KCTF68 ZD*OMA98X63KC31833/2J4L523/AJ:PF.L72XV7J3ZX8EIU$51PYT3C2:FRKX21 9*GNRSIO92W*20SM67AEBFA6LTUT9OHLRJQG4+3LO47/8TI$CHQBZ4A%DS:YU0-B7.BO/UGIT9FSSQFU6DX20-M560\'\n\n QRCODE GENERATE\n','2022-03-14 06:34:48','2022-03-14 06:34:48'),
(196,'CASE FRONT V T R\n{\"fn\":\"JOBET\",\"gn\":\"ELFRIDA\",\"dob\":\"1962-02-20\",\"tg\":\"840539006\",\"tt\":\"LP6464-4\",\"ma\":\"RealStar SARS-CoV-2 RT-PCR Kit 1.0\",\"sc\":\"2022-03-12T12:32:12+01:00\",\"tr\":260415000,\"nm\":\"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\",\"tc\":\"Palais des congres\",\"pid\":\"18GA38847\",\"dcc_type_id\":null,\"sd\":\"2\",\"ci\":\"URN:UVCI:01:BJ:51850e002aaa7192c1e\",\"co\":\"BJ\",\"is\":\"Ministere de la Sante du Benin\",\"ver\":\"1.3.0\"}\n{\'fn\': \'JOBET\', \'gn\': \'ELFRIDA\', \'dob\': \'1962-02-20\', \'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'ma\': \'RealStar SARS-CoV-2 RT-PCR Kit 1.0\', \'sc\': \'2022-03-12T12:32:12+01:00\', \'tr\': 260415000, \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tc\': \'Palais des congres\', \'pid\': \'18GA38847\', \'dcc_type_id\': None, \'sd\': \'2\', \'ci\': \'URN:UVCI:01:BJ:51850e002aaa7192c1e\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ver\': \'1.3.0\'}\nT Type\nType 1 to start\nLoading T type_dcc\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T12:32:12+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:51850e002aaa7192c1e\"}]\nafter case Starting\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T12:32:12+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:51850e002aaa7192c1e\"}]\n\n JSON DATA { \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T12:32:12+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:51850e002aaa7192c1e\"}], \"dob\": \"1962-02-20\", \"nam\": {\"fn\": \"JOBET\", \"gn\": \"ELFRIDA\", \"fnt\": \"JOBET\", \"gnt\": \"ELFRIDA\"}, \"ver\": \"1.3.0\", \"pid\": \"18GA38847\"}\n\n JSON DATA123\n b\'{ \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T12:32:12+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:51850e002aaa7192c1e\"}], \"dob\": \"1962-02-20\", \"nam\": {\"fn\": \"JOBET\", \"gn\": \"ELFRIDA\", \"fnt\": \"JOBET\", \"gnt\": \"ELFRIDA\"}, \"ver\": \"1.3.0\", \"pid\": \"18GA38847\"}\'\n\n JSON PAYLOAD\n{\'t\': [{\'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'tc\': \'Palais des congres\', \'sc\': \'2022-03-12T12:32:12+01:00\', \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tr\': \'260415000\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ci\': \'URN:UVCI:01:BJ:51850e002aaa7192c1e\'}], \'dob\': \'1962-02-20\', \'nam\': {\'fn\': \'JOBET\', \'gn\': \'ELFRIDA\', \'fnt\': \'JOBET\', \'gnt\': \'ELFRIDA\'}, \'ver\': \'1.3.0\', \'pid\': \'18GA38847\'}\n\n CBOR PAYLOAD : b\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c0-\\x06\\x1ab.\\xe2-9\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T12:32:12+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:51850e002aaa7192c1ecdobj1962-02-20cnam\\xa4bfneJOBETbgngELFRIDAcfnteJOBETcgntgELFRIDAcvere1.3.0cpidi18GA38847\'\n\n CBOR PAYLOAD\nb\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c0-\\x06\\x1ab.\\xe2-9\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T12:32:12+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:51850e002aaa7192c1ecdobj1962-02-20cnam\\xa4bfneJOBETbgngELFRIDAcfnteJOBETcgntgELFRIDAcvere1.3.0cpidi18GA38847\'\n\n Public Key\nb\'-----BEGIN CERTIFICATE-----\\nMIICRzCCAe2gAwIBAgIUVCPtXj+5X2ffP/Y/H4vOZB+h8pcwCgYIKoZIzj0EAwIw\\nRjELMAkGA1UEBhMCQkoxHjAcBgNVBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEX\\nMBUGA1UEAwwOQ1NDQV9ER0NfQkpfMDEwHhcNMjIwMjA2MTIxMzE0WhcNMjQwMjA2\\nMTIxMzE0WjBaMQswCQYDVQQGEwJCSjERMA8GA1UECAwITGl0dG9yYWwxHjAcBgNV\\nBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEYMBYGA1UEAwwPRFMtU2FuaXRhaXJl\\nLTAxMFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAE1eafQkFnEHdgmdO4ZkAnpznV\\nJlN2vhXb5czc/zO+82Kbp5PIUmtWid1wnLWcRv5NjVx3MtjpU8vRT4X2ej79JqOB\\npDCBoTAOBgNVHQ8BAf8EBAMCB4AwHQYDVR0OBBYEFCNn8De3BcTaAqyrWQg2wAH9\\n7fM9MB8GA1UdIwQYMBaAFNvCZnB3/atBycb4N5Su6LWnW0LpMDcGA1UdHwQwMC4w\\nLKAqoCiGJmh0dHA6Ly9hbnNzaS5iai9DUkwvQ1NDQV9ER0NfQkpfMDEuY3JsMBYG\\nA1UdJQQPMA0GCysGAQQBjjePZQEBMAoGCCqGSM49BAMCA0gAMEUCIQDOmh0KmGuH\\n2xwlpq/L1S7F855pLLkXkUCMZ70z8pfbvwIgIabBd8ZH7Tfajd/4xCoC53SLVe3Z\\n/gBUvIYvwhjZbPk=\\n-----END CERTIFICATE-----\\n\'\n\n Fingerprint :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5ctO\\x07\\x96\\xbdO\\x01\\xc3y\"E\\xbb\\xc7%\\xc6\\x9c\\xf6\\xaey\\xe4\\xf0\\x91r\'\n - Fingerprint HEX :  f6fe27e4cde022c563744f0796bd4f01c3792245bbc725c69cf6ae79e4f09172\n - Fingerprint BASE64 :  9v4n5M3gIsVjdE8Hlr1PAcN5IkW7xyXGnPaueeTwkXI=\n\n KID :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5\'\n - KID HEX :  f6fe27e4cde022c5\n - KID BASE64 :  9v4n5M3gIsU=\n\n Private Key : b\'Ij3orGEajvSqMDrRo7+3IBwqJtEdQyQHkeUtMIyJ0ig=\'\nKEY :  {<class \'cose.keys.keyparam.KpKty\'>: <class \'cose.keys.keytype.KtyEC2\'>, <class \'cose.keys.keyparam.KpAlg\'>: <class \'cose.algorithms.Es256\'>, <class \'cose.keys.keyparam.EC2KpCurve\'>: <class \'cose.keys.curves.P256\'>, <class \'cose.keys.keyparam.EC2KpD\'>: b\'\"=\\xe8\\xaca\\x1a\\x8e\\xf4\\xaa0:\\xd1\\xa3\\xbf\\xb7 \\x1c*&\\xd1\\x1dC$\\x07\\x91\\xe5-0\\x8c\\x89\\xd2(\'}\n\n COSE PACKAGING :  b\'[BLOB]\'\n\n ZLIB :  b\"x\\xda\\xbb\\xd4\\xe2\\xbb\\x88Q\\x8d\\xc5\\xe3\\xdb?\\xf5\'g\\x1f(\\x1d]\\x10\\xc9\\xe8\\xb6\\x841\\xc9\\xc9\\x8bE*Y\\xc6@\\x97M*I\\xef\\x91\\xae%#\\xf3B\\xc6\\xa5\\x89%\\x8d+\\x93J\\xd23-L\\x0cL\\x8d-\\r\\x0c\\xcc\\x92JJ2|\\x02\\xccL\\xccLtM\\x92J\\x92\\x8b\\x02\\x12s\\x123\\x8b\\x15RR\\x8b\\x15\\x92\\xf3\\xf3\\xd2\\x8bR\\x8b\\x93\\x8a\\x93+$\\x8d\\x0c\\x8c\\x8ct\\r\\x8cu\\r\\x8dB\\x0c\\x8d\\xac\\x8c\\x8d\\xac\\x0c\\x8d\\xb4\\r\\x0c\\xad\\x0c\\x0c\\x92\\xf2r+\\xd4\\\\}<CR\\x933\\xdc\\x8b\\xf2K\\x0bt\\x14\\x82\\x1d\\x83\\x82u\\x9d\\xf3\\xc3t\\x8d\\x14\\xc0\\x12\\n\\xbe\\xeeN\\n\\xde\\x99%I%E\\x99Ff\\x06&\\x86\\xa6\\x06@}\\xc9\\xf9@\\x07&e\\x16W\\xc8\\xf9f\\xe6e\\x16\\x97\\xa4\\x16\\xa5\\x02mU\\xc8IT\\x08N\\xcc+\\x01\\xb2K\\x15\\x9cR\\xf32\\xf3\\x92\\x923+\\x94B\\x83\\xfc\\xacB\\xc3\\x9c=\\xad\\x80v:yY\\x99\\x1aZ\\x98\\x1a\\xa4\\x1a\\x18\\x18%&&\\x9a\\x1bZ\\x1a%\\x1b\\xa6&\\xa7\\xe4\'e\\x19Z\\x9a\\x01]i\\xa4kd\\x90\\x9c\\x97\\x98\\xbb$)-/\\xd5\\xcb\\xdf\\xc95$)=/\\xdd\\xd5\\xc7-\\xc8\\xd3\\xc519\\rh8X09=\\xaf\\x04.Z\\x06\\xb4\\xdeP\\xcfX\\xcf \\xb9 3%\\xd3\\xd0\\xc2\\xdd\\xd1\\xd8\\xc2\\xc2\\xc4<\\xc2!p\\xc7\\xfb\\xa8\\x88\\xa6\\x9bY\\xe1G\\x83O\\xcc\\xe28\\x92\\x93Pe\\xbeM\\xe8\\xf279-\\xbf\\xc87)\\xbd\\xc7-M\\xc5}\\x0cv\\x94}\\x0f7/\\x8a9\\xfbhU\\xdb\\xee?\\x1d\\x0b\\x85\\xc3gw\\xe7:Y\\xb4\\xad[\\xa5\\x17\\xce\\x08\\x00\\xads\\x8cw\"\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52*IT1WG.MPDRH-F5$2PX5JPF5*CUV0MNO4*J8W-KSX4+M5TK96L6SR9MU9DV5 R1AMI4H9LUFA$PA$PSVEAMIUNIZB0SOEAN6DV2QJAWW2 $UYRQQJAFTIARI.R4HQ11YH3W1+ZER%HIQ1R L/+HIQ1DYM5R1ON1/PIMJE4%QK$F:M8IRIT*RHSU7K1UQ2+W37MGP/J-VOQ$HUCO5G1V5U$G1AGJ5B9.Z8M+8:Y001HPZ0Q+F/MVU+03ZCH4B NVV5TN%2LXKW%K: DIEP2SAC/9TJ5DOM.W2+LA%J6$NI4L6JXI%UG/YL WO*Z7 AGTH7WEB-E3DAJPXK323FV4R*4RK3XD3DM3+*4.$S6ZCJKBY70:FD.PDUCII7JSTNB95526 YPTJPWP43X7:1S48PLHP -OP97+7DV6BSA7T5MV%56%0W4SP9QE8Q7IN/K6:YQPSOZNQ/ROG OHOOQBET VHCHYSJQLS0RGP+P$672SI %C9%9.RUCA71BO /6S:NWW5M/O+P1XYIP-1K06%E7O8D7 R2:7OK1SVO57F.G7%$MGQBJ03N01X-L4YH\'\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52*IT1WG.MPDRH-F5$2PX5JPF5*CUV0MNO4*J8W-KSX4+M5TK96L6SR9MU9DV5 R1AMI4H9LUFA$PA$PSVEAMIUNIZB0SOEAN6DV2QJAWW2 $UYRQQJAFTIARI.R4HQ11YH3W1+ZER%HIQ1R L/+HIQ1DYM5R1ON1/PIMJE4%QK$F:M8IRIT*RHSU7K1UQ2+W37MGP/J-VOQ$HUCO5G1V5U$G1AGJ5B9.Z8M+8:Y001HPZ0Q+F/MVU+03ZCH4B NVV5TN%2LXKW%K: DIEP2SAC/9TJ5DOM.W2+LA%J6$NI4L6JXI%UG/YL WO*Z7 AGTH7WEB-E3DAJPXK323FV4R*4RK3XD3DM3+*4.$S6ZCJKBY70:FD.PDUCII7JSTNB95526 YPTJPWP43X7:1S48PLHP -OP97+7DV6BSA7T5MV%56%0W4SP9QE8Q7IN/K6:YQPSOZNQ/ROG OHOOQBET VHCHYSJQLS0RGP+P$672SI %C9%9.RUCA71BO /6S:NWW5M/O+P1XYIP-1K06%E7O8D7 R2:7OK1SVO57F.G7%$MGQBJ03N01X-L4YH\'\n\n QRCODE GENERATE\n','2022-03-14 06:35:25','2022-03-14 06:35:25'),
(197,'CASE FRONT V T R\n{\"fn\":\"Dassanou\",\"gn\":\"AGOSSOU JACQUES\",\"dob\":\"1981-12-29\",\"tg\":\"840539006\",\"tt\":\"LP6464-4\",\"ma\":\"RealStar SARS-CoV-2 RT-PCR Kit 1.0\",\"sc\":\"2022-03-12T11:49:05+01:00\",\"tr\":260415000,\"nm\":\"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\",\"tc\":\"Palais des congres\",\"pid\":\"B0575598\",\"dcc_type_id\":null,\"sd\":\"2\",\"ci\":\"URN:UVCI:01:BJ:c44cf971c9ee51be2be\",\"co\":\"BJ\",\"is\":\"Ministere de la Sante du Benin\",\"ver\":\"1.3.0\"}\n{\'fn\': \'Dassanou\', \'gn\': \'AGOSSOU JACQUES\', \'dob\': \'1981-12-29\', \'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'ma\': \'RealStar SARS-CoV-2 RT-PCR Kit 1.0\', \'sc\': \'2022-03-12T11:49:05+01:00\', \'tr\': 260415000, \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tc\': \'Palais des congres\', \'pid\': \'B0575598\', \'dcc_type_id\': None, \'sd\': \'2\', \'ci\': \'URN:UVCI:01:BJ:c44cf971c9ee51be2be\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ver\': \'1.3.0\'}\nT Type\nType 1 to start\nLoading T type_dcc\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:49:05+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:c44cf971c9ee51be2be\"}]\nafter case Starting\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:49:05+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:c44cf971c9ee51be2be\"}]\n\n JSON DATA { \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:49:05+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:c44cf971c9ee51be2be\"}], \"dob\": \"1981-12-29\", \"nam\": {\"fn\": \"Dassanou\", \"gn\": \"AGOSSOU JACQUES\", \"fnt\": \"DASSANOU\", \"gnt\": \"AGOSSOU<JACQUES\"}, \"ver\": \"1.3.0\", \"pid\": \"B0575598\"}\n\n JSON DATA123\n b\'{ \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:49:05+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:c44cf971c9ee51be2be\"}], \"dob\": \"1981-12-29\", \"nam\": {\"fn\": \"Dassanou\", \"gn\": \"AGOSSOU JACQUES\", \"fnt\": \"DASSANOU\", \"gnt\": \"AGOSSOU<JACQUES\"}, \"ver\": \"1.3.0\", \"pid\": \"B0575598\"}\'\n\n JSON PAYLOAD\n{\'t\': [{\'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'tc\': \'Palais des congres\', \'sc\': \'2022-03-12T11:49:05+01:00\', \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tr\': \'260415000\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ci\': \'URN:UVCI:01:BJ:c44cf971c9ee51be2be\'}], \'dob\': \'1981-12-29\', \'nam\': {\'fn\': \'Dassanou\', \'gn\': \'AGOSSOU JACQUES\', \'fnt\': \'DASSANOU\', \'gnt\': \'AGOSSOU<JACQUES\'}, \'ver\': \'1.3.0\', \'pid\': \'B0575598\'}\n\n CBOR PAYLOAD : b\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c0\\xc9\\x06\\x1ab.\\xe2\\xc99\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T11:49:05+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:c44cf971c9ee51be2becdobj1981-12-29cnam\\xa4bfnhDassanoubgnoAGOSSOU JACQUEScfnthDASSANOUcgntoAGOSSOU<JACQUEScvere1.3.0cpidhB0575598\'\n\n CBOR PAYLOAD\nb\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c0\\xc9\\x06\\x1ab.\\xe2\\xc99\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T11:49:05+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:c44cf971c9ee51be2becdobj1981-12-29cnam\\xa4bfnhDassanoubgnoAGOSSOU JACQUEScfnthDASSANOUcgntoAGOSSOU<JACQUEScvere1.3.0cpidhB0575598\'\n\n Public Key\nb\'-----BEGIN CERTIFICATE-----\\nMIICRzCCAe2gAwIBAgIUVCPtXj+5X2ffP/Y/H4vOZB+h8pcwCgYIKoZIzj0EAwIw\\nRjELMAkGA1UEBhMCQkoxHjAcBgNVBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEX\\nMBUGA1UEAwwOQ1NDQV9ER0NfQkpfMDEwHhcNMjIwMjA2MTIxMzE0WhcNMjQwMjA2\\nMTIxMzE0WjBaMQswCQYDVQQGEwJCSjERMA8GA1UECAwITGl0dG9yYWwxHjAcBgNV\\nBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEYMBYGA1UEAwwPRFMtU2FuaXRhaXJl\\nLTAxMFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAE1eafQkFnEHdgmdO4ZkAnpznV\\nJlN2vhXb5czc/zO+82Kbp5PIUmtWid1wnLWcRv5NjVx3MtjpU8vRT4X2ej79JqOB\\npDCBoTAOBgNVHQ8BAf8EBAMCB4AwHQYDVR0OBBYEFCNn8De3BcTaAqyrWQg2wAH9\\n7fM9MB8GA1UdIwQYMBaAFNvCZnB3/atBycb4N5Su6LWnW0LpMDcGA1UdHwQwMC4w\\nLKAqoCiGJmh0dHA6Ly9hbnNzaS5iai9DUkwvQ1NDQV9ER0NfQkpfMDEuY3JsMBYG\\nA1UdJQQPMA0GCysGAQQBjjePZQEBMAoGCCqGSM49BAMCA0gAMEUCIQDOmh0KmGuH\\n2xwlpq/L1S7F855pLLkXkUCMZ70z8pfbvwIgIabBd8ZH7Tfajd/4xCoC53SLVe3Z\\n/gBUvIYvwhjZbPk=\\n-----END CERTIFICATE-----\\n\'\n\n Fingerprint :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5ctO\\x07\\x96\\xbdO\\x01\\xc3y\"E\\xbb\\xc7%\\xc6\\x9c\\xf6\\xaey\\xe4\\xf0\\x91r\'\n - Fingerprint HEX :  f6fe27e4cde022c563744f0796bd4f01c3792245bbc725c69cf6ae79e4f09172\n - Fingerprint BASE64 :  9v4n5M3gIsVjdE8Hlr1PAcN5IkW7xyXGnPaueeTwkXI=\n\n KID :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5\'\n - KID HEX :  f6fe27e4cde022c5\n - KID BASE64 :  9v4n5M3gIsU=\n\n Private Key : b\'Ij3orGEajvSqMDrRo7+3IBwqJtEdQyQHkeUtMIyJ0ig=\'\nKEY :  {<class \'cose.keys.keyparam.KpKty\'>: <class \'cose.keys.keytype.KtyEC2\'>, <class \'cose.keys.keyparam.KpAlg\'>: <class \'cose.algorithms.Es256\'>, <class \'cose.keys.keyparam.EC2KpCurve\'>: <class \'cose.keys.curves.P256\'>, <class \'cose.keys.keyparam.EC2KpD\'>: b\'\"=\\xe8\\xaca\\x1a\\x8e\\xf4\\xaa0:\\xd1\\xa3\\xbf\\xb7 \\x1c*&\\xd1\\x1dC$\\x07\\x91\\xe5-0\\x8c\\x89\\xd2(\'}\n\n COSE PACKAGING :  b\'[BLOB]\'\n\n ZLIB :  b\'x\\xda\\xbb\\xd4\\xe2\\xbb\\x88Q\\x8d\\xc5\\xe3\\xdb?\\xf5\\\'g\\x1f(\\x1d]\\x10\\xc9\\x18\\xbd\\x841\\xc9\\xc9\\x8bE*Y\\xc6\\xe0$\\x9bT\\x92\\xde\\xa3\\x93\\x96\\x8c\\xcc\\x0b\\x19\\x97&\\x964\\xaeL*I\\xcf\\xb40105\\xb6400K*)\\xc9\\xf0\\t0313\\xd15I*I.\\nH\\xccI\\xcc,VHI-VH\\xce\\xcfK/J-N*N\\xae\\x904202\\xd250\\xd654\\n14\\xb42\\xb1\\xb420\\xd560\\xb420H\\xca\\xcb\\xadPs\\xf5\\xf1\\x0cIM\\xcep/\\xca/-\\xd0Q\\x08v\\x0c\\n\\xd6u\\xce\\x0f\\xd35R\\x00K(\\xf8\\xba;)xg\\x96$\\x95\\x14e\\x1a\\x99\\x19\\x98\\x18\\x9a\\x1a\\x00\\xf5%\\xe7\\x03\\x1d\\x98\\x94Y\\\\!\\xe7\\x9b\\x99\\x97Y\\\\\\x92Z\\x94\\n\\xb4U!\\\'Q!81\\xaf\\x04\\xc8.UpJ\\xcd\\xcb\\xccKJ\\xce\\xacP\\n\\r\\xf2\\xb3\\n\\rs\\xf6\\xb4\\x02\\xda\\xe9\\xe4e\\x95lb\\x92\\x9cfin\\x98l\\x99\\x9ajj\\x98\\x94j\\x94\\x94\\x9a\\x9c\\x92\\x9f\\x94ehia\\x08t\\xa2\\xae\\x91er^b\\xee\\x92\\xa4\\xb4\\xbc\\x0c\\x97\\xc4\\xe2\\xe2\\xc4\\xbc\\xfc\\xd2\\xa4\\xf4\\xbc|Gw\\xff\\xe0`\\xffP\\x05/G\\xe7\\xc0P\\xd7\\xe0\\xe4\\xb4\\xbc\\x92\\x0c\\x17\\xc7\\xe0`G?\\xff\\xd0\\xe4\\xf4\\xbc\\x12\\x98\\x02\\x1b\\x98\\x822\\xa0\\xa3\\x0c\\xf5\\x8c\\xf5\\x0c\\x92\\x0b2S2\\x9c\\x0cL\\xcdMM--\"\\x1c\\x98^.P\\xd9Z\\xa8\\xf4\\x90_{\\xdbf\\xeb5\\\\o\\xd9\\xffg-\\x9b\\xfb\\xf0\\xb5X\\xc1\\x9dh\\xe1#\\xf5\\x9d\\x9d\\xcc\\xcb\\xdb/\\xac\\xb0\\xcd\\x99\\xd2\\xe5\\xb2w\\xedq3\\x1f\\xbf\\xcb\\xf2\\x96\\xb3u-\\xce\\xfby\\xfe\\xfd\\xa2\\xa6\\xf0\\xe6\\xed\\t\\x00\\xb2\\x88\\x97M\'\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52X531WG.MPDRH-F5H6PBS45VAP6SRTI:ZH6I1*4JM:IP1MPF5RBQ746B46O1N646RM9WC5OFU946+967KQAB9EB9MD17$PN P%+ADB9%+AN6QWM9:G9U*9R.9GAINF65J6QW6R3R2Q6-965ZM.KMNF6..Q376NF6499VXPU7A64V+O1S$998E9PPSZ5:AAP-ETG18+E102FX6U10385KON-A5D4D5S41Q2EG3RA3/43-C3R:U99TGX3.XI5TBQCTYIJGDBQMI8WI+ZMR84OBAU47T5M DP2 AOK9HYPEN9X5QF5AFY1OSMNV1L8VAG0QPT+$CQVD2OIR.C7:D WDKNJILDEYIBZIPOJ5OI9YI:8D0CCNXE43M5$C.-B97U: KZYNH8JWUS9*OC/VI%KC$NP19TFW BCA5A//5IDT+9AHJS8%M%KIC03KGSE09DFWM.S-YNY9J:L3UKG%DKWS1+ HNQ1VI1DNAXWJ-V9YY90W52E4 BJL%5MLR7GLEBIRTFM0DPX6D6E/CWKY5B%VT-MKLOTBDPO4T-J2+P-VRI$LS:PYTQCPMZ0U$K64BO2UU-UMQZ5RZVRAWDPKKKUL/T/302CHW1\'\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52X531WG.MPDRH-F5H6PBS45VAP6SRTI:ZH6I1*4JM:IP1MPF5RBQ746B46O1N646RM9WC5OFU946+967KQAB9EB9MD17$PN P%+ADB9%+AN6QWM9:G9U*9R.9GAINF65J6QW6R3R2Q6-965ZM.KMNF6..Q376NF6499VXPU7A64V+O1S$998E9PPSZ5:AAP-ETG18+E102FX6U10385KON-A5D4D5S41Q2EG3RA3/43-C3R:U99TGX3.XI5TBQCTYIJGDBQMI8WI+ZMR84OBAU47T5M DP2 AOK9HYPEN9X5QF5AFY1OSMNV1L8VAG0QPT+$CQVD2OIR.C7:D WDKNJILDEYIBZIPOJ5OI9YI:8D0CCNXE43M5$C.-B97U: KZYNH8JWUS9*OC/VI%KC$NP19TFW BCA5A//5IDT+9AHJS8%M%KIC03KGSE09DFWM.S-YNY9J:L3UKG%DKWS1+ HNQ1VI1DNAXWJ-V9YY90W52E4 BJL%5MLR7GLEBIRTFM0DPX6D6E/CWKY5B%VT-MKLOTBDPO4T-J2+P-VRI$LS:PYTQCPMZ0U$K64BO2UU-UMQZ5RZVRAWDPKKKUL/T/302CHW1\'\n\n QRCODE GENERATE\n','2022-03-14 06:38:01','2022-03-14 06:38:01'),
(198,'CASE FRONT V T R\n{\"fn\":\"Gbonon\",\"gn\":\"YAPO SERGE ALAIN\",\"dob\":\"1982-01-29\",\"tg\":\"840539006\",\"tt\":\"LP6464-4\",\"ma\":\"RealStar SARS-CoV-2 RT-PCR Kit 1.0\",\"sc\":\"2022-03-12T11:10:17+01:00\",\"tr\":260415000,\"nm\":\"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\",\"tc\":\"Palais des congres\",\"pid\":\"20AF39441\",\"dcc_type_id\":null,\"sd\":\"2\",\"ci\":\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\",\"co\":\"BJ\",\"is\":\"Ministere de la Sante du Benin\",\"ver\":\"1.3.0\"}\n{\'fn\': \'Gbonon\', \'gn\': \'YAPO SERGE ALAIN\', \'dob\': \'1982-01-29\', \'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'ma\': \'RealStar SARS-CoV-2 RT-PCR Kit 1.0\', \'sc\': \'2022-03-12T11:10:17+01:00\', \'tr\': 260415000, \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tc\': \'Palais des congres\', \'pid\': \'20AF39441\', \'dcc_type_id\': None, \'sd\': \'2\', \'ci\': \'URN:UVCI:01:BJ:a8a67f5b5cc806ab913\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ver\': \'1.3.0\'}\nT Type\nType 1 to start\nLoading T type_dcc\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}]\nafter case Starting\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}]\n\n JSON DATA { \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}], \"dob\": \"1982-01-29\", \"nam\": {\"fn\": \"Gbonon\", \"gn\": \"YAPO SERGE ALAIN\", \"fnt\": \"GBONON\", \"gnt\": \"YAPO<SERGE<ALAIN\"}, \"ver\": \"1.3.0\", \"pid\": \"20AF39441\"}\n\n JSON DATA123\n b\'{ \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}], \"dob\": \"1982-01-29\", \"nam\": {\"fn\": \"Gbonon\", \"gn\": \"YAPO SERGE ALAIN\", \"fnt\": \"GBONON\", \"gnt\": \"YAPO<SERGE<ALAIN\"}, \"ver\": \"1.3.0\", \"pid\": \"20AF39441\"}\'\n\n JSON PAYLOAD\n{\'t\': [{\'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'tc\': \'Palais des congres\', \'sc\': \'2022-03-12T11:10:17+01:00\', \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tr\': \'260415000\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ci\': \'URN:UVCI:01:BJ:a8a67f5b5cc806ab913\'}], \'dob\': \'1982-01-29\', \'nam\': {\'fn\': \'Gbonon\', \'gn\': \'YAPO SERGE ALAIN\', \'fnt\': \'GBONON\', \'gnt\': \'YAPO<SERGE<ALAIN\'}, \'ver\': \'1.3.0\', \'pid\': \'20AF39441\'}\n\n CBOR PAYLOAD : b\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c0\\xf9\\x06\\x1ab.\\xe2\\xf99\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T11:10:17+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913cdobj1982-01-29cnam\\xa4bfnfGbononbgnpYAPO SERGE ALAINcfntfGBONONcgntpYAPO<SERGE<ALAINcvere1.3.0cpidi20AF39441\'\n\n CBOR PAYLOAD\nb\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c0\\xf9\\x06\\x1ab.\\xe2\\xf99\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T11:10:17+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913cdobj1982-01-29cnam\\xa4bfnfGbononbgnpYAPO SERGE ALAINcfntfGBONONcgntpYAPO<SERGE<ALAINcvere1.3.0cpidi20AF39441\'\n\n Public Key\nb\'-----BEGIN CERTIFICATE-----\\nMIICRzCCAe2gAwIBAgIUVCPtXj+5X2ffP/Y/H4vOZB+h8pcwCgYIKoZIzj0EAwIw\\nRjELMAkGA1UEBhMCQkoxHjAcBgNVBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEX\\nMBUGA1UEAwwOQ1NDQV9ER0NfQkpfMDEwHhcNMjIwMjA2MTIxMzE0WhcNMjQwMjA2\\nMTIxMzE0WjBaMQswCQYDVQQGEwJCSjERMA8GA1UECAwITGl0dG9yYWwxHjAcBgNV\\nBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEYMBYGA1UEAwwPRFMtU2FuaXRhaXJl\\nLTAxMFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAE1eafQkFnEHdgmdO4ZkAnpznV\\nJlN2vhXb5czc/zO+82Kbp5PIUmtWid1wnLWcRv5NjVx3MtjpU8vRT4X2ej79JqOB\\npDCBoTAOBgNVHQ8BAf8EBAMCB4AwHQYDVR0OBBYEFCNn8De3BcTaAqyrWQg2wAH9\\n7fM9MB8GA1UdIwQYMBaAFNvCZnB3/atBycb4N5Su6LWnW0LpMDcGA1UdHwQwMC4w\\nLKAqoCiGJmh0dHA6Ly9hbnNzaS5iai9DUkwvQ1NDQV9ER0NfQkpfMDEuY3JsMBYG\\nA1UdJQQPMA0GCysGAQQBjjePZQEBMAoGCCqGSM49BAMCA0gAMEUCIQDOmh0KmGuH\\n2xwlpq/L1S7F855pLLkXkUCMZ70z8pfbvwIgIabBd8ZH7Tfajd/4xCoC53SLVe3Z\\n/gBUvIYvwhjZbPk=\\n-----END CERTIFICATE-----\\n\'\n\n Fingerprint :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5ctO\\x07\\x96\\xbdO\\x01\\xc3y\"E\\xbb\\xc7%\\xc6\\x9c\\xf6\\xaey\\xe4\\xf0\\x91r\'\n - Fingerprint HEX :  f6fe27e4cde022c563744f0796bd4f01c3792245bbc725c69cf6ae79e4f09172\n - Fingerprint BASE64 :  9v4n5M3gIsVjdE8Hlr1PAcN5IkW7xyXGnPaueeTwkXI=\n\n KID :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5\'\n - KID HEX :  f6fe27e4cde022c5\n - KID BASE64 :  9v4n5M3gIsU=\n\n Private Key : b\'Ij3orGEajvSqMDrRo7+3IBwqJtEdQyQHkeUtMIyJ0ig=\'\nKEY :  {<class \'cose.keys.keyparam.KpKty\'>: <class \'cose.keys.keytype.KtyEC2\'>, <class \'cose.keys.keyparam.KpAlg\'>: <class \'cose.algorithms.Es256\'>, <class \'cose.keys.keyparam.EC2KpCurve\'>: <class \'cose.keys.curves.P256\'>, <class \'cose.keys.keyparam.EC2KpD\'>: b\'\"=\\xe8\\xaca\\x1a\\x8e\\xf4\\xaa0:\\xd1\\xa3\\xbf\\xb7 \\x1c*&\\xd1\\x1dC$\\x07\\x91\\xe5-0\\x8c\\x89\\xd2(\'}\n\n COSE PACKAGING :  b\'[BLOB]\'\n\n ZLIB :  b\'x\\xda\\xbb\\xd4\\xe2\\xbb\\x88Q\\x8d\\xc5\\xe3\\xdb?\\xf5\\\'g\\x1f(\\x1d]\\x10\\xc9\\x18\\xb5\\x841\\xc9\\xc9\\x8bE*Y\\xc6\\xe0\\\'\\x9bT\\x92\\xde\\xa3\\x9f\\x96\\x8c\\xcc\\x0b\\x19\\x97&\\x964\\xaeL*I\\xcf\\xb40105\\xb6400K*)\\xc9\\xf0\\t0313\\xd15I*I.\\nH\\xccI\\xcc,VHI-VH\\xce\\xcfK/J-N*N\\xae\\x904202\\xd250\\xd654\\n14\\xb424\\xb024\\xd760\\xb420H\\xca\\xcb\\xadPs\\xf5\\xf1\\x0cIM\\xcep/\\xca/-\\xd0Q\\x08v\\x0c\\n\\xd6u\\xce\\x0f\\xd35R\\x00K(\\xf8\\xba;)xg\\x96$\\x95\\x14e\\x1a\\x99\\x19\\x98\\x18\\x9a\\x1a\\x00\\xf5%\\xe7\\x03\\x1d\\x98\\x94Y\\\\!\\xe7\\x9b\\x99\\x97Y\\\\\\x92Z\\x94\\n\\xb4U!\\\'Q!81\\xaf\\x04\\xc8.UpJ\\xcd\\xcb\\xccKJ\\xce\\xacP\\n\\r\\xf2\\xb3\\n\\rs\\xf6\\xb4\\x02\\xda\\xe9\\xe4e\\x95h\\x91hf\\x9ef\\x9ad\\x9a\\x9cla`\\x96\\x98dih\\x9c\\x9c\\x92\\x9f\\x94ehi\\x01t\\xa5\\xa1\\xae\\x91er^b\\xee\\x92\\xa4\\xb4\\xbc4\\xf7\\xa4\\xfc\\xbc\\xfc\\xbc\\xa4\\xf4\\xbc\\x82H\\xc7\\x00\\x7f\\x85`\\xd7 wW\\x05G\\x1fGO\\xbf\\xe4\\xb4\\xbc\\x924w\\\'\\x7f?\\x7f\\xbf\\xe4\\xf4\\xbc\\x12\\xb0\\xbc\\rX\\xde\\x06\"_\\x06t\\x92\\xa1\\x9e\\xb1\\x9eArAfJ\\xa6\\x91\\x81\\xa3\\x9b\\xb1\\xa5\\x89\\x89a\\x84\\xc3\\xdb;\\xa7\\xcfr\\\\\\xb8\\xec\\xba\\xd7m\\xc2\\xed\\xb8\\x9bJM\\xde\\xda\\xeb\\xfb\\xd6\\x1f\\xa8\\x14\\x7fo\\xf5\\xff\\xac}\\xca\\x8c\\x93\\x9c\\x9e\\x99i\\xe2k\\xdf\\xfe\\xf6\\x9f\\xb2\\xfa\\xcf\\xbf.\\x86\\xd7[Wx\\xa9\\xdb\\xf6_\\xf4\\x93\\xb3\\xd1I\\xbf\\x98x\\xcf\\x05\\x00\\xa1\\xcb\\x98\\x14\'\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52P531WG.MPDRH-F5H6PE055VAP6S*7K:ZH6I1*4JM:IP1MPF5RBQ746B46O1N646RM9WC5OFU946+967KQAB9EB9MD17$PN P%+ADB9%+AN6QWM9:G9U*9R.9GAINF65J6QW6R3R2Q6-965ZMXT6RF6E9R376NF6499VXPU7A64V+O1S$998E9PPSZ5:AAP-ETG18+E102FX6U10385KON-A5D4D5S41Q2EG3RA3/43-C3R:U99TGX3.XI5TBQCTYIJGDBQMI8WI+ZMR84OBAU47T5M DP2 AOK9HYPEN9X5QF5AFY1OSMNV1L8VAG0QPT+$C*9D-8D51KENJPOJPVDL9C.BJTED.ZJ5OI9YI:8DC80B.K43M5$C.-B97U: KUZN DVZ.VZ.VI%KI$N199$20Y%G$8R-3F1U0..3U3A3-SY$NLS6V:4A18TBOC.UEG2 YNPAB+Y0Q0C7XEJJKKKMEC82C8UJ9YHIXUKRKMJHHYEC9YOGO76AQLWBW-TOAR-SO9FNVH9Z7SL$T53R8BL/4GK4VC LCRPXTIB2KGHDUSDKAWM8K$VVR7O42HSOBJBFF R*5CBUIRKQ/9OCCFKS0JKK7AJ\'\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52P531WG.MPDRH-F5H6PE055VAP6S*7K:ZH6I1*4JM:IP1MPF5RBQ746B46O1N646RM9WC5OFU946+967KQAB9EB9MD17$PN P%+ADB9%+AN6QWM9:G9U*9R.9GAINF65J6QW6R3R2Q6-965ZMXT6RF6E9R376NF6499VXPU7A64V+O1S$998E9PPSZ5:AAP-ETG18+E102FX6U10385KON-A5D4D5S41Q2EG3RA3/43-C3R:U99TGX3.XI5TBQCTYIJGDBQMI8WI+ZMR84OBAU47T5M DP2 AOK9HYPEN9X5QF5AFY1OSMNV1L8VAG0QPT+$C*9D-8D51KENJPOJPVDL9C.BJTED.ZJ5OI9YI:8DC80B.K43M5$C.-B97U: KUZN DVZ.VZ.VI%KI$N199$20Y%G$8R-3F1U0..3U3A3-SY$NLS6V:4A18TBOC.UEG2 YNPAB+Y0Q0C7XEJJKKKMEC82C8UJ9YHIXUKRKMJHHYEC9YOGO76AQLWBW-TOAR-SO9FNVH9Z7SL$T53R8BL/4GK4VC LCRPXTIB2KGHDUSDKAWM8K$VVR7O42HSOBJBFF R*5CBUIRKQ/9OCCFKS0JKK7AJ\'\n\n QRCODE GENERATE\n','2022-03-14 06:38:49','2022-03-14 06:38:49'),
(199,'CASE FRONT V T R\n{\"fn\":\"Gbonon\",\"gn\":\"YAPO SERGE ALAIN\",\"dob\":\"1982-01-29\",\"tg\":\"840539006\",\"tt\":\"LP6464-4\",\"ma\":\"RealStar SARS-CoV-2 RT-PCR Kit 1.0\",\"sc\":\"2022-03-12T11:10:17+01:00\",\"tr\":260415000,\"nm\":\"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\",\"tc\":\"Palais des congres\",\"pid\":\"20AF39441\",\"dcc_type_id\":null,\"sd\":\"2\",\"ci\":\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\",\"co\":\"BJ\",\"is\":\"Ministere de la Sante du Benin\",\"ver\":\"1.3.0\"}\n{\'fn\': \'Gbonon\', \'gn\': \'YAPO SERGE ALAIN\', \'dob\': \'1982-01-29\', \'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'ma\': \'RealStar SARS-CoV-2 RT-PCR Kit 1.0\', \'sc\': \'2022-03-12T11:10:17+01:00\', \'tr\': 260415000, \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tc\': \'Palais des congres\', \'pid\': \'20AF39441\', \'dcc_type_id\': None, \'sd\': \'2\', \'ci\': \'URN:UVCI:01:BJ:a8a67f5b5cc806ab913\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ver\': \'1.3.0\'}\nT Type\nType 1 to start\nLoading T type_dcc\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}]\nafter case Starting\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}]\n\n JSON DATA { \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}], \"dob\": \"1982-01-29\", \"nam\": {\"fn\": \"Gbonon\", \"gn\": \"YAPO SERGE ALAIN\", \"fnt\": \"GBONON\", \"gnt\": \"YAPO<SERGE<ALAIN\"}, \"ver\": \"1.3.0\", \"pid\": \"20AF39441\"}\n\n JSON DATA123\n b\'{ \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}], \"dob\": \"1982-01-29\", \"nam\": {\"fn\": \"Gbonon\", \"gn\": \"YAPO SERGE ALAIN\", \"fnt\": \"GBONON\", \"gnt\": \"YAPO<SERGE<ALAIN\"}, \"ver\": \"1.3.0\", \"pid\": \"20AF39441\"}\'\n\n JSON PAYLOAD\n{\'t\': [{\'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'tc\': \'Palais des congres\', \'sc\': \'2022-03-12T11:10:17+01:00\', \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tr\': \'260415000\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ci\': \'URN:UVCI:01:BJ:a8a67f5b5cc806ab913\'}], \'dob\': \'1982-01-29\', \'nam\': {\'fn\': \'Gbonon\', \'gn\': \'YAPO SERGE ALAIN\', \'fnt\': \'GBONON\', \'gnt\': \'YAPO<SERGE<ALAIN\'}, \'ver\': \'1.3.0\', \'pid\': \'20AF39441\'}\n\n CBOR PAYLOAD : b\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c1B\\x06\\x1ab.\\xe3B9\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T11:10:17+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913cdobj1982-01-29cnam\\xa4bfnfGbononbgnpYAPO SERGE ALAINcfntfGBONONcgntpYAPO<SERGE<ALAINcvere1.3.0cpidi20AF39441\'\n\n CBOR PAYLOAD\nb\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c1B\\x06\\x1ab.\\xe3B9\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T11:10:17+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913cdobj1982-01-29cnam\\xa4bfnfGbononbgnpYAPO SERGE ALAINcfntfGBONONcgntpYAPO<SERGE<ALAINcvere1.3.0cpidi20AF39441\'\n\n Public Key\nb\'-----BEGIN CERTIFICATE-----\\nMIICRzCCAe2gAwIBAgIUVCPtXj+5X2ffP/Y/H4vOZB+h8pcwCgYIKoZIzj0EAwIw\\nRjELMAkGA1UEBhMCQkoxHjAcBgNVBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEX\\nMBUGA1UEAwwOQ1NDQV9ER0NfQkpfMDEwHhcNMjIwMjA2MTIxMzE0WhcNMjQwMjA2\\nMTIxMzE0WjBaMQswCQYDVQQGEwJCSjERMA8GA1UECAwITGl0dG9yYWwxHjAcBgNV\\nBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEYMBYGA1UEAwwPRFMtU2FuaXRhaXJl\\nLTAxMFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAE1eafQkFnEHdgmdO4ZkAnpznV\\nJlN2vhXb5czc/zO+82Kbp5PIUmtWid1wnLWcRv5NjVx3MtjpU8vRT4X2ej79JqOB\\npDCBoTAOBgNVHQ8BAf8EBAMCB4AwHQYDVR0OBBYEFCNn8De3BcTaAqyrWQg2wAH9\\n7fM9MB8GA1UdIwQYMBaAFNvCZnB3/atBycb4N5Su6LWnW0LpMDcGA1UdHwQwMC4w\\nLKAqoCiGJmh0dHA6Ly9hbnNzaS5iai9DUkwvQ1NDQV9ER0NfQkpfMDEuY3JsMBYG\\nA1UdJQQPMA0GCysGAQQBjjePZQEBMAoGCCqGSM49BAMCA0gAMEUCIQDOmh0KmGuH\\n2xwlpq/L1S7F855pLLkXkUCMZ70z8pfbvwIgIabBd8ZH7Tfajd/4xCoC53SLVe3Z\\n/gBUvIYvwhjZbPk=\\n-----END CERTIFICATE-----\\n\'\n\n Fingerprint :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5ctO\\x07\\x96\\xbdO\\x01\\xc3y\"E\\xbb\\xc7%\\xc6\\x9c\\xf6\\xaey\\xe4\\xf0\\x91r\'\n - Fingerprint HEX :  f6fe27e4cde022c563744f0796bd4f01c3792245bbc725c69cf6ae79e4f09172\n - Fingerprint BASE64 :  9v4n5M3gIsVjdE8Hlr1PAcN5IkW7xyXGnPaueeTwkXI=\n\n KID :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5\'\n - KID HEX :  f6fe27e4cde022c5\n - KID BASE64 :  9v4n5M3gIsU=\n\n Private Key : b\'Ij3orGEajvSqMDrRo7+3IBwqJtEdQyQHkeUtMIyJ0ig=\'\nKEY :  {<class \'cose.keys.keyparam.KpKty\'>: <class \'cose.keys.keytype.KtyEC2\'>, <class \'cose.keys.keyparam.KpAlg\'>: <class \'cose.algorithms.Es256\'>, <class \'cose.keys.keyparam.EC2KpCurve\'>: <class \'cose.keys.curves.P256\'>, <class \'cose.keys.keyparam.EC2KpD\'>: b\'\"=\\xe8\\xaca\\x1a\\x8e\\xf4\\xaa0:\\xd1\\xa3\\xbf\\xb7 \\x1c*&\\xd1\\x1dC$\\x07\\x91\\xe5-0\\x8c\\x89\\xd2(\'}\n\n COSE PACKAGING :  b\'[BLOB]\'\n\n ZLIB :  b\'x\\xda%\\x8e\\xcfk\\xd3`\\x1c\\x87\\t\\x1b\\xf5\\xe4\\xc1\\xf5R\\x8b\\x8c\\x97\\x1e*l&\\xbco\\x92fM\\xa8`2jl\\xd7_4\\xebp\\n\\xc2\\xfb}\\x9bt\\xef\\xd8\\xde\\xd4\\xe4\\xdd(\\xec$\\x08^\\xc5\\n^U\\xea\\xc1\\xff\\xc0\\xa3\\x17=\\x08\\x82\\xf5.\\x14\\x1d\\x88\\\'o\\x82\\x07\\xc5Po\\x1fx\\xf8\\xf0<\\x9f\\x1f\\xb6_*\\xe5\\xd5[\\xbf\\xfe^=\\xff\\xb8(\\xbd{\\xbe\\xaf\\xdc\\x99)\\xe05W\\x8b\\xec\\n\\xf1rE\\xd0\\xbey\\xb6\\xb2\\xf2ByE\\xe5\\x83\\xd7 G\\xbcj\\xe2\\x8aacl\\x81\\x94\\x07\\xad\\x9eeZ\\xa6j\\x82dI\\x8f\\x1eQ\\x9e\\xa2a\\x98\"\\x16\\x8bQ\\x12\\xa6\\x90\\xb2\\xc9e\\x1d\\xeb\\xba\\x8a\\r\\x95\\xe8\\xbb\\x848\\x04;dk\\x13\\x13\\x07c\\x10\\xc7\\x93r\\xbd\\xd5\\xd8\\r\\xd9\\x81\\x9f\\xc4\\\'\\xe3k(p\\xfb\\x81\\xba\\x1d\\xef\\xa9:Z\\x02\\xd4\\xf6=\\xb4\\xc3%\\xc8\\x84\\xeb\\x166I\\x05g?\\x16g\\x81\\xc0\\xd3\\xc9z\\x9b\\x0b\\x9e\\xca0\\t3+:\\xa2(\\xa0Bf\\xfb\\x04y\\xa1\\xe0\\x02\\x18\\x9f\\x94\\x06\\xfd\\x8e3\\xd8\\xdbn8\\x99\\xd3k:\\xb4J\\xad\\xad\\xa8\\x02\\x15\\xc6\\xaa\\xd8\\xa2`\\x13\\x83\\rc8$v5\\xab$\\xaan3A\\x8fg\\x10\\x89\\xc8\\x87X\\xc4\\x02Fb\\xbc\\xef\\xf6\\xba(\\xa8\\xf7\\xfd:r[n\\xa3\\xc3\"!#\\xdf\\xebv\\xba\\x1d6\\x12r\\xc9kK^\\xfb\\xcfO\\xb3$\\xa2\\x19\\x1afc>\\xe4:vo\\x1a\\xb6i\\x92\\xdb7~|*\\xbc_kv\\xf3+w?<q\\xe6\\xda\\xd9\\xc5E\\x1d\\x16\\x18\\xff\\xfcs\\xde\\xaa]\\x98k\\x8fK\\xbfy0\\xbd\\xf4\\xe6\\xfe\\xdb\\x8d\\xf1\\xd7{9\\xb1\\x86v\\xa6\\xeb\\xf3g\\xdf\\x0b\\xe5/\\x8dG\\xf9\\xeb\\xc5\\xa7\\xff\\x00~k\\x90<\'\n\n BASE45 :  b\'HC1:NCFTX4:9QMWQDR3 61%3VINOQJA YHR 3BUD: N%MIZ 9B7CJKDAAR2V6H7EATOP*FAZEXIR5-Q6/RH%TR21.+OT-BMUT.EW RK9W70PG6$50X3F:4WJGM.O72E8DFUGUA5KM2N1J5Y/QACO5-BYEWY65/SFKAMEGJMFS13B $TPNU7$8Q3OF4N8SU+EFU0T$8R4392NDAMHRPC7HGU/041KVKB-KDNUC84IEEAYNKLAJB%29BAP2L4RMAZC1 TGKH .IYVNU37*M76ODBI2PNCGAPXMEO1RZX1IHG+ZOYXS255ZZVZNNIDU/G74G0$5VF%M.Y47 GG 2IA9G2DK$26IG$YQMMF4L1APPF71-K5MMKVBK%0DKP0+KK-B0$7KY*0//HUIR1.D4KJ0PDTZM1/LZAL*X2-QLXNK0L27V1H47L.ERSLPOLQL6 5I342ZFP:9B.C0VLC5FU1ONAGLQ0WPKEI:D4UON84%DSJ0F8V3.E2%KPYN9N$VI3AIS4 73L.CZ.7QH722EW2NKPIV07GVFS NFQDGXUH3F%S7D8T*NR8X8VZ2CGW7TE8OL4CJ85IC9OC769/U%9WM.H%AR9D7.:GQ4LVYU*8S /SW%HYQVJ:OUAW8:FOAI\'\n\n BASE45 :  b\'HC1:NCFTX4:9QMWQDR3 61%3VINOQJA YHR 3BUD: N%MIZ 9B7CJKDAAR2V6H7EATOP*FAZEXIR5-Q6/RH%TR21.+OT-BMUT.EW RK9W70PG6$50X3F:4WJGM.O72E8DFUGUA5KM2N1J5Y/QACO5-BYEWY65/SFKAMEGJMFS13B $TPNU7$8Q3OF4N8SU+EFU0T$8R4392NDAMHRPC7HGU/041KVKB-KDNUC84IEEAYNKLAJB%29BAP2L4RMAZC1 TGKH .IYVNU37*M76ODBI2PNCGAPXMEO1RZX1IHG+ZOYXS255ZZVZNNIDU/G74G0$5VF%M.Y47 GG 2IA9G2DK$26IG$YQMMF4L1APPF71-K5MMKVBK%0DKP0+KK-B0$7KY*0//HUIR1.D4KJ0PDTZM1/LZAL*X2-QLXNK0L27V1H47L.ERSLPOLQL6 5I342ZFP:9B.C0VLC5FU1ONAGLQ0WPKEI:D4UON84%DSJ0F8V3.E2%KPYN9N$VI3AIS4 73L.CZ.7QH722EW2NKPIV07GVFS NFQDGXUH3F%S7D8T*NR8X8VZ2CGW7TE8OL4CJ85IC9OC769/U%9WM.H%AR9D7.:GQ4LVYU*8S /SW%HYQVJ:OUAW8:FOAI\'\n\n QRCODE GENERATE\n','2022-03-14 06:40:02','2022-03-14 06:40:02'),
(200,'CASE FRONT V T R\n{\"fn\":\"Gbonon\",\"gn\":\"YAPO SERGE ALAIN\",\"dob\":\"1982-01-29\",\"tg\":\"840539006\",\"tt\":\"LP6464-4\",\"ma\":\"RealStar SARS-CoV-2 RT-PCR Kit 1.0\",\"sc\":\"2022-03-12T11:10:17+01:00\",\"tr\":260415000,\"nm\":\"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\",\"tc\":\"Palais des congres\",\"pid\":\"20AF39441\",\"dcc_type_id\":null,\"sd\":\"2\",\"ci\":\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\",\"co\":\"BJ\",\"is\":\"Ministere de la Sante du Benin\",\"ver\":\"1.3.0\"}\n{\'fn\': \'Gbonon\', \'gn\': \'YAPO SERGE ALAIN\', \'dob\': \'1982-01-29\', \'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'ma\': \'RealStar SARS-CoV-2 RT-PCR Kit 1.0\', \'sc\': \'2022-03-12T11:10:17+01:00\', \'tr\': 260415000, \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tc\': \'Palais des congres\', \'pid\': \'20AF39441\', \'dcc_type_id\': None, \'sd\': \'2\', \'ci\': \'URN:UVCI:01:BJ:a8a67f5b5cc806ab913\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ver\': \'1.3.0\'}\nT Type\nType 1 to start\nLoading T type_dcc\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}]\nafter case Starting\n\"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}]\n\n JSON DATA { \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}], \"dob\": \"1982-01-29\", \"nam\": {\"fn\": \"Gbonon\", \"gn\": \"YAPO SERGE ALAIN\", \"fnt\": \"GBONON\", \"gnt\": \"YAPO<SERGE<ALAIN\"}, \"ver\": \"1.3.0\", \"pid\": \"20AF39441\"}\n\n JSON DATA123\n b\'{ \"t\": [{\"tg\": \"840539006\", \"tt\": \"LP6464-4\", \"tc\": \"Palais des congres\", \"sc\": \"2022-03-12T11:10:17+01:00\", \"nm\": \"ELITechGroup, SARS-CoV-2 ELITe MGB Kit\", \"tr\": \"260415000\", \"co\": \"BJ\", \"is\": \"Ministere de la Sante du Benin\", \"ci\": \"URN:UVCI:01:BJ:a8a67f5b5cc806ab913\"}], \"dob\": \"1982-01-29\", \"nam\": {\"fn\": \"Gbonon\", \"gn\": \"YAPO SERGE ALAIN\", \"fnt\": \"GBONON\", \"gnt\": \"YAPO<SERGE<ALAIN\"}, \"ver\": \"1.3.0\", \"pid\": \"20AF39441\"}\'\n\n JSON PAYLOAD\n{\'t\': [{\'tg\': \'840539006\', \'tt\': \'LP6464-4\', \'tc\': \'Palais des congres\', \'sc\': \'2022-03-12T11:10:17+01:00\', \'nm\': \'ELITechGroup, SARS-CoV-2 ELITe MGB Kit\', \'tr\': \'260415000\', \'co\': \'BJ\', \'is\': \'Ministere de la Sante du Benin\', \'ci\': \'URN:UVCI:01:BJ:a8a67f5b5cc806ab913\'}], \'dob\': \'1982-01-29\', \'nam\': {\'fn\': \'Gbonon\', \'gn\': \'YAPO SERGE ALAIN\', \'fnt\': \'GBONON\', \'gnt\': \'YAPO<SERGE<ALAIN\'}, \'ver\': \'1.3.0\', \'pid\': \'20AF39441\'}\n\n CBOR PAYLOAD : b\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c1W\\x06\\x1ab.\\xe3W9\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T11:10:17+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913cdobj1982-01-29cnam\\xa4bfnfGbononbgnpYAPO SERGE ALAINcfntfGBONONcgntpYAPO<SERGE<ALAINcvere1.3.0cpidi20AF39441\'\n\n CBOR PAYLOAD\nb\'\\xa4\\x01bBJ\\x04\\x1ac\\x1c1W\\x06\\x1ab.\\xe3W9\\x01\\x03\\xa1\\x01\\xa5at\\x81\\xa9btgi840539006btthLP6464-4btcrPalais des congresbscx\\x192022-03-12T11:10:17+01:00bnmx&ELITechGroup, SARS-CoV-2 ELITe MGB Kitbtri260415000bcobBJbisx\\x1eMinistere de la Sante du Beninbcix\"URN:UVCI:01:BJ:a8a67f5b5cc806ab913cdobj1982-01-29cnam\\xa4bfnfGbononbgnpYAPO SERGE ALAINcfntfGBONONcgntpYAPO<SERGE<ALAINcvere1.3.0cpidi20AF39441\'\n\n Public Key\nb\'-----BEGIN CERTIFICATE-----\\nMIICRzCCAe2gAwIBAgIUVCPtXj+5X2ffP/Y/H4vOZB+h8pcwCgYIKoZIzj0EAwIw\\nRjELMAkGA1UEBhMCQkoxHjAcBgNVBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEX\\nMBUGA1UEAwwOQ1NDQV9ER0NfQkpfMDEwHhcNMjIwMjA2MTIxMzE0WhcNMjQwMjA2\\nMTIxMzE0WjBaMQswCQYDVQQGEwJCSjERMA8GA1UECAwITGl0dG9yYWwxHjAcBgNV\\nBAoMFU1JTklTVEVSRSBERSBMQSBTQU5URTEYMBYGA1UEAwwPRFMtU2FuaXRhaXJl\\nLTAxMFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAE1eafQkFnEHdgmdO4ZkAnpznV\\nJlN2vhXb5czc/zO+82Kbp5PIUmtWid1wnLWcRv5NjVx3MtjpU8vRT4X2ej79JqOB\\npDCBoTAOBgNVHQ8BAf8EBAMCB4AwHQYDVR0OBBYEFCNn8De3BcTaAqyrWQg2wAH9\\n7fM9MB8GA1UdIwQYMBaAFNvCZnB3/atBycb4N5Su6LWnW0LpMDcGA1UdHwQwMC4w\\nLKAqoCiGJmh0dHA6Ly9hbnNzaS5iai9DUkwvQ1NDQV9ER0NfQkpfMDEuY3JsMBYG\\nA1UdJQQPMA0GCysGAQQBjjePZQEBMAoGCCqGSM49BAMCA0gAMEUCIQDOmh0KmGuH\\n2xwlpq/L1S7F855pLLkXkUCMZ70z8pfbvwIgIabBd8ZH7Tfajd/4xCoC53SLVe3Z\\n/gBUvIYvwhjZbPk=\\n-----END CERTIFICATE-----\\n\'\n\n Fingerprint :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5ctO\\x07\\x96\\xbdO\\x01\\xc3y\"E\\xbb\\xc7%\\xc6\\x9c\\xf6\\xaey\\xe4\\xf0\\x91r\'\n - Fingerprint HEX :  f6fe27e4cde022c563744f0796bd4f01c3792245bbc725c69cf6ae79e4f09172\n - Fingerprint BASE64 :  9v4n5M3gIsVjdE8Hlr1PAcN5IkW7xyXGnPaueeTwkXI=\n\n KID :  b\'\\xf6\\xfe\\\'\\xe4\\xcd\\xe0\"\\xc5\'\n - KID HEX :  f6fe27e4cde022c5\n - KID BASE64 :  9v4n5M3gIsU=\n\n Private Key : b\'Ij3orGEajvSqMDrRo7+3IBwqJtEdQyQHkeUtMIyJ0ig=\'\nKEY :  {<class \'cose.keys.keyparam.KpKty\'>: <class \'cose.keys.keytype.KtyEC2\'>, <class \'cose.keys.keyparam.KpAlg\'>: <class \'cose.algorithms.Es256\'>, <class \'cose.keys.keyparam.EC2KpCurve\'>: <class \'cose.keys.curves.P256\'>, <class \'cose.keys.keyparam.EC2KpD\'>: b\'\"=\\xe8\\xaca\\x1a\\x8e\\xf4\\xaa0:\\xd1\\xa3\\xbf\\xb7 \\x1c*&\\xd1\\x1dC$\\x07\\x91\\xe5-0\\x8c\\x89\\xd2(\'}\n\n COSE PACKAGING :  b\'[BLOB]\'\n\n ZLIB :  b\"x\\xda\\xbb\\xd4\\xe2\\xbb\\x88Q\\x8d\\xc5\\xe3\\xdb?\\xf5\'g\\x1f(\\x1d]\\x10\\xc9\\x18\\xb5\\x841\\xc9\\xc9\\x8bE*Y\\xc60\\x9cM*I\\xefq\\xb8%#\\xf3B\\xc6\\xa5\\x89%\\x8d+\\x93J\\xd23-L\\x0cL\\x8d-\\r\\x0c\\xcc\\x92JJ2|\\x02\\xccL\\xccLtM\\x92J\\x92\\x8b\\x02\\x12s\\x123\\x8b\\x15RR\\x8b\\x15\\x92\\xf3\\xf3\\xd2\\x8bR\\x8b\\x93\\x8a\\x93+$\\x8d\\x0c\\x8c\\x8ct\\r\\x8cu\\r\\x8dB\\x0c\\r\\xad\\x0c\\r\\xac\\x0c\\xcd\\xb5\\r\\x0c\\xad\\x0c\\x0c\\x92\\xf2r+\\xd4\\\\}<CR\\x933\\xdc\\x8b\\xf2K\\x0bt\\x14\\x82\\x1d\\x83\\x82u\\x9d\\xf3\\xc3t\\x8d\\x14\\xc0\\x12\\n\\xbe\\xeeN\\n\\xde\\x99%I%E\\x99Ff\\x06&\\x86\\xa6\\x06@}\\xc9\\xf9@\\x07&e\\x16W\\xc8\\xf9f\\xe6e\\x16\\x97\\xa4\\x16\\xa5\\x02mU\\xc8IT\\x08N\\xcc+\\x01\\xb2K\\x15\\x9cR\\xf32\\xf3\\x92\\x923+\\x94B\\x83\\xfc\\xacB\\xc3\\x9c=\\xad\\x80v:yY%Z$\\x9a\\x99\\xa7\\x99&\\x99&\'[\\x18\\x98%&Y\\x1a\\x1a\'\\xa7\\xe4\'e\\x19ZZ\\x00]i\\xa8kd\\x99\\x9c\\x97\\x98\\xbb$)-/\\xcd=)?/?/)=\\xaf \\xd21\\xc0_!\\xd85\\xc8\\xddU\\xc1\\xd1\\xc7\\xd1\\xd3/9-\\xaf$\\xcd\\xdd\\xc9\\xdf\\xcf\\xdf/9=\\xaf\\x04,o\\x03\\x96\\xb7\\x81\\xc8\\x97\\x01\\x9dd\\xa8g\\xacg\\x90\\\\\\x90\\x99\\x92id\\xe0\\xe8flibb\\x18\\xe1p\\xe8\\x92\\xe6\\xf7\\x05\\x99\\x0b\\xae\\xb3~j\\xee\\xfb\\xd0$Y\\xff\\xa5\\xec\\xd7\\xb79\\xef\\x82\\xee\\xe6>\\xfc\\x94\\xd4\\xb8\\xf5\\x99\\xf6\\x81c\\xdel\\x8f\\x9e^\\x8a\\xfbW-zo\\xc3\\x87l7\\xad\\xe3~Y\\xca\\xd7rW\\xf5\\xfah\\xda\\xae\\x12=\\xbd\\x0f\\x00\\x1d\\x9f\\x99\\xd6\"\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52P531WG.MPDRH-F5L2P8YJPF57CUQCNNO4*J8W-KSX4+M5TK96L6SR9MU9DV5 R1AMI4H9LUFA$PA$PSVEAMIUNIZB0SOEAN6DV2QJAWW2 $UYRQQJAFTIARI.R4HQ11YH3W1+ZER%HPN1K*LZW1$R1:*M5R1ON1/PIMJE4%QK$F:M8IRIT*RHSU7K1UQ2+W37MGP/J-VOQ$HUCO5G1V5U$G1AGJ5B9.Z8M+8:Y001HPZ0Q+F/MVU+03ZCH4B NVV5TN%2LXKW%K: DIEP2SAC/9TJ5DOM.W2+LA%J6$NI4L6JXI%UG/YL WO*Z7 AGTH76CB HBMOJK8LQ*42$4ANBOAJ7%4MD3Q05.$S6ZC0JB3203GD.PD*IJI7JSTNB95.16.W7K:7K:7R95C6MYPQHEOOC4/Z66:RRMOXBPIVQCA7G6M61QJNPPCQT/5-Z7XN0O1EI2JEIG24JH+J1DLZZLBBIRCI-MI*XC4HTXVDVJCO63ECEVPICAVTFJ%3M7:FO9U4EQ:GB-/K8CRQE7%OG$4T+-V6+Q82VF7V6SCQWD.0KTPH.0BNLFFWOSUDA:LZ/F.SPLKEF4VMBDC0MA 7F+1NX37KJ\'\n\n BASE45 :  b\'HC1:NCFOXN%TSMAHN-HB S%387:4B.32W3M52P531WG.MPDRH-F5L2P8YJPF57CUQCNNO4*J8W-KSX4+M5TK96L6SR9MU9DV5 R1AMI4H9LUFA$PA$PSVEAMIUNIZB0SOEAN6DV2QJAWW2 $UYRQQJAFTIARI.R4HQ11YH3W1+ZER%HPN1K*LZW1$R1:*M5R1ON1/PIMJE4%QK$F:M8IRIT*RHSU7K1UQ2+W37MGP/J-VOQ$HUCO5G1V5U$G1AGJ5B9.Z8M+8:Y001HPZ0Q+F/MVU+03ZCH4B NVV5TN%2LXKW%K: DIEP2SAC/9TJ5DOM.W2+LA%J6$NI4L6JXI%UG/YL WO*Z7 AGTH76CB HBMOJK8LQ*42$4ANBOAJ7%4MD3Q05.$S6ZC0JB3203GD.PD*IJI7JSTNB95.16.W7K:7K:7R95C6MYPQHEOOC4/Z66:RRMOXBPIVQCA7G6M61QJNPPCQT/5-Z7XN0O1EI2JEIG24JH+J1DLZZLBBIRCI-MI*XC4HTXVDVJCO63ECEVPICAVTFJ%3M7:FO9U4EQ:GB-/K8CRQE7%OG$4T+-V6+Q82VF7V6SCQWD.0KTPH.0BNLFFWOSUDA:LZ/F.SPLKEF4VMBDC0MA 7F+1NX37KJ\'\n\n QRCODE GENERATE\n','2022-03-14 06:40:23','2022-03-14 06:40:23'),
(233368,'N/a','2024-07-26 14:43:21','2024-07-26 14:43:21'),
(233369,'N/a','2024-07-26 14:53:10','2024-07-26 14:53:10'),
(233370,'N/a','2024-07-26 14:55:00','2024-07-26 14:55:00'),
(233371,'N/a','2024-07-26 15:20:45','2024-07-26 15:20:45');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES
(1,1),
(2,1),
(3,1),
(4,1),
(5,1),
(6,1),
(7,1),
(8,1),
(9,1),
(10,1),
(11,1),
(12,1),
(13,1),
(14,1),
(15,1),
(16,1),
(17,1),
(18,1),
(19,1),
(20,1),
(21,1),
(22,1),
(23,1),
(24,1),
(25,1),
(26,1),
(27,1),
(28,1),
(29,1),
(30,1),
(31,1),
(32,1),
(33,1),
(34,1),
(35,1),
(36,1),
(37,1),
(38,1),
(39,1),
(40,1),
(41,1),
(42,1),
(43,1),
(44,1),
(45,1),
(46,1),
(47,1),
(48,1),
(49,1),
(50,1),
(51,1),
(52,1),
(53,1),
(54,1),
(55,1),
(56,1),
(57,1),
(58,1),
(59,1),
(60,1),
(61,1),
(62,1),
(63,1),
(64,1),
(65,1),
(66,1),
(67,1),
(68,1),
(69,1),
(70,1),
(71,1),
(72,1),
(73,1),
(74,1),
(75,1),
(76,1),
(77,1),
(1,2),
(2,2),
(3,2),
(9,2),
(10,2),
(11,2),
(13,2),
(26,2),
(27,2),
(28,2),
(29,2),
(31,2),
(32,2),
(33,2),
(35,2),
(36,2),
(37,2),
(43,2),
(44,2),
(45,2),
(55,2),
(60,2),
(68,2),
(69,2),
(27,3),
(31,3),
(32,3),
(33,3),
(34,3),
(43,3),
(60,3),
(9,4),
(27,4),
(55,4),
(9,5),
(26,5),
(27,5),
(28,5),
(29,5),
(31,5),
(32,5),
(33,5),
(43,5),
(60,5),
(61,5),
(62,5),
(63,5),
(66,5),
(9,6),
(26,6),
(27,6),
(28,6),
(29,6),
(31,6),
(32,6),
(33,6),
(60,6),
(61,6),
(62,6),
(63,6),
(65,6),
(26,7),
(9,8),
(26,8),
(27,8),
(28,8),
(29,8),
(31,8),
(32,8),
(33,8),
(60,8),
(61,8),
(62,8),
(66,8),
(1,9),
(9,9),
(13,9),
(26,9),
(27,9),
(28,9),
(29,9),
(31,9),
(32,9),
(33,9),
(35,9),
(43,9),
(60,9),
(68,9),
(69,9);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES
(1,'superadmin','web','2021-12-26 21:38:31','2021-12-26 21:38:31'),
(2,'superviseur','web','2021-12-26 21:38:31','2021-12-26 21:38:31'),
(3,'employee','web','2021-12-26 21:38:31','2021-12-26 21:38:31'),
(4,'laboratoire','web','2021-12-26 21:38:31','2021-12-26 21:38:31'),
(5,'agent vaccination','web','2022-01-08 13:16:19','2022-01-08 13:16:19'),
(6,'agent test','web','2022-01-08 13:16:19','2022-01-08 13:16:19'),
(7,'Api','web','2022-03-10 20:58:05','2022-03-10 20:58:05'),
(8,'agent accueil','web','2022-03-15 18:14:12','2022-03-15 18:14:12'),
(9,'manager','web','2022-03-15 18:14:12','2022-03-15 18:14:12'),
(10,'medecin','web','2024-07-16 10:42:59','2024-07-16 10:42:59');

--
-- Table structure for table `sms_apis`
--

CREATE TABLE `sms_apis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `short_libelle` varchar(255) NOT NULL,
  `libelle` varchar(255) NOT NULL,
  `details` longtext NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_apis`
--

INSERT INTO `sms_apis` VALUES
(1,'ovh','OVH','{\"application_key\":\"YuRF5pT4JvPX2rnO\",\"secret_key\":\"wbLf4Jt5FEkHSqhL6sO7XZcELvUVwmaE\",\"endpoint\":\"ovh-eu\",\"consumer_key\":\"sgsJAhmL1lW2Piwk9696mzEZfUMHUw1u\"}',0,'2021-12-26 21:38:33','2021-12-26 21:38:33'),
(2,'tm4b','TM4B','{\"application_key\":\"db955ce8106368e6d21dfa02ac21facd\"}',0,'2021-12-26 21:38:33','2021-12-26 21:38:33'),
(3,'nexmo','Nexmo','{\"application_key\":\"db955ce8106368e6d21dfa02ac21facd\"}',1,'2021-12-26 21:38:33','2021-12-26 21:38:33');

--
-- Table structure for table `statistics`
--

CREATE TABLE `statistics` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dcc_type_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `statistics_dcc_type_id_foreign` (`dcc_type_id`),
  CONSTRAINT `statistics_dcc_type_id_foreign` FOREIGN KEY (`dcc_type_id`) REFERENCES `dcc_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statistics`
--


--
-- Table structure for table `stock_histories`
--

CREATE TABLE `stock_histories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uo_id` bigint(20) unsigned NOT NULL,
  `covid_product_id` bigint(20) unsigned NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `quantity_before_update` bigint(20) unsigned NOT NULL,
  `quantity_after_update` bigint(20) unsigned NOT NULL,
  `comment` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stock_histories`
--


--
-- Table structure for table `stock_transfers`
--

CREATE TABLE `stock_transfers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `receiving_uo_id` bigint(20) unsigned NOT NULL,
  `sending_uo_id` bigint(20) unsigned NOT NULL,
  `sent_by` bigint(20) unsigned NOT NULL COMMENT 'User who sent the stock',
  `received_by` bigint(20) unsigned DEFAULT NULL COMMENT 'User who received the stock',
  `covid_product_id` bigint(20) unsigned NOT NULL,
  `quantity_sent` bigint(20) unsigned NOT NULL,
  `quantity_received` bigint(20) unsigned DEFAULT NULL,
  `broken_quantity` bigint(20) unsigned NOT NULL DEFAULT 0,
  `notes_for_receiving_uo` text DEFAULT NULL,
  `notes_for_sending_uo` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stock_transfers`
--


--
-- Table structure for table `test_marketing_manufacturers`
--

CREATE TABLE `test_marketing_manufacturers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `lang` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `system_oid` varchar(255) DEFAULT NULL,
  `version` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `test_marketing_manufacturers`
--


--
-- Table structure for table `uos`
--

CREATE TABLE `uos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type_id` bigint(20) unsigned DEFAULT NULL,
  `formejuridique_id` bigint(20) unsigned DEFAULT NULL,
  `activite_id` bigint(20) unsigned DEFAULT NULL,
  `filiation_id` bigint(20) unsigned DEFAULT NULL,
  `raison_sociale` varchar(255) NOT NULL,
  `denomination_ciale` varchar(255) DEFAULT NULL,
  `num_compte` varchar(255) NOT NULL,
  `trigramme` varchar(255) DEFAULT NULL COMMENT 'Acronyme ou Sigle',
  `typevoie_id` bigint(20) unsigned DEFAULT NULL,
  `adresse` varchar(255) NOT NULL,
  `adresse_suite` varchar(255) DEFAULT NULL,
  `csbp` varchar(255) DEFAULT NULL,
  `cp` varchar(255) DEFAULT NULL,
  `country_id` bigint(20) unsigned DEFAULT NULL,
  `city_id` bigint(20) unsigned DEFAULT NULL,
  `arr_id` bigint(20) unsigned DEFAULT 0,
  `lat` varchar(255) DEFAULT NULL COMMENT 'Latitude',
  `lng` varchar(255) DEFAULT NULL COMMENT 'Longitude',
  `telephone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `rcs` varchar(255) DEFAULT NULL,
  `rccm` varchar(255) DEFAULT NULL,
  `date_rccm` varchar(255) DEFAULT NULL,
  `siren` varchar(255) DEFAULT NULL,
  `idfiscal` varchar(255) DEFAULT NULL,
  `capital` varchar(255) DEFAULT NULL,
  `civilite_id` bigint(20) unsigned DEFAULT NULL,
  `fn_representant` varchar(255) DEFAULT NULL,
  `gn_representant` varchar(255) DEFAULT NULL,
  `uo_logo` varchar(255) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `qrcode` varchar(255) DEFAULT NULL,
  `flg_uo` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `updated_by` bigint(20) unsigned DEFAULT NULL,
  `etat` tinyint(1) NOT NULL DEFAULT 0,
  `ordre` smallint(5) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uos_updated_by_foreign` (`updated_by`),
  KEY `uos_created_by_foreign` (`created_by`),
  KEY `uos_type_id_foreign` (`type_id`),
  KEY `uos_typevoie_id_foreign` (`typevoie_id`),
  KEY `uos_formejuridique_id_foreign` (`formejuridique_id`),
  KEY `uos_activite_id_foreign` (`activite_id`),
  KEY `uos_filiation_id_foreign` (`filiation_id`),
  CONSTRAINT `uos_activite_id_foreign` FOREIGN KEY (`activite_id`) REFERENCES `intitules` (`id`),
  CONSTRAINT `uos_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `uos_filiation_id_foreign` FOREIGN KEY (`filiation_id`) REFERENCES `intitules` (`id`),
  CONSTRAINT `uos_formejuridique_id_foreign` FOREIGN KEY (`formejuridique_id`) REFERENCES `intitules` (`id`),
  CONSTRAINT `uos_type_id_foreign` FOREIGN KEY (`type_id`) REFERENCES `intitules` (`id`),
  CONSTRAINT `uos_typevoie_id_foreign` FOREIGN KEY (`typevoie_id`) REFERENCES `intitules` (`id`),
  CONSTRAINT `uos_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `uos`
--

INSERT INTO `uos` VALUES
(1,148,NULL,NULL,NULL,'Ministère  de la Santé',NULL,'MI-0','MDS',157,'Les Cocotiers',NULL,NULL,NULL,25,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 00:27:24','2021-12-26 00:27:24',NULL),
(2,149,NULL,NULL,1,'Agence  Nationale des Soins de Santé Primaire',NULL,'AG-0','ANSSP',157,'Akpakpa senandé',NULL,NULL,NULL,25,48,0,NULL,NULL,NULL,NULL,'+229',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 00:27:24','2022-01-18 17:16:03',NULL),
(3,150,NULL,NULL,2,'CS KANDI ',NULL,'CE3','NC',NULL,'NC',NULL,NULL,NULL,1,3,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:09:56',NULL),
(4,150,NULL,NULL,2,'CS GOGOUNOU',NULL,'CE4','NC',NULL,'NC',NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:09:56',NULL),
(5,150,NULL,NULL,2,'CS SEGBANA',NULL,'CE5','NC',NULL,'NC',NULL,NULL,NULL,1,6,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(6,150,NULL,NULL,2,'CS BANIKOARA',NULL,'CE6','NC',NULL,'NC',NULL,NULL,NULL,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(7,150,NULL,NULL,2,'CS MALANVILLE',NULL,'CE7','NC',NULL,'NC',NULL,NULL,NULL,1,5,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(8,150,NULL,NULL,2,'CS KARIMAMA',NULL,'CE8','NC',NULL,'NC',NULL,NULL,NULL,1,4,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(9,150,NULL,NULL,2,'CS APLAHOUE',NULL,'CE9','NC',NULL,'NC',NULL,NULL,NULL,1,38,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(10,150,NULL,NULL,2,'CS ATOMEY',NULL,'CE10','NC',NULL,'NC',NULL,NULL,NULL,1,38,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(11,150,NULL,NULL,2,' CS DJAKOTOMEY',NULL,'CE11','NC',NULL,'NC',NULL,NULL,NULL,1,39,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(12,150,NULL,NULL,2,'CS DOGBO',NULL,'CE12','NC',NULL,'NC',NULL,NULL,NULL,1,40,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(13,150,NULL,NULL,2,'CS KLOUEKANME',NULL,'CE13','NC',NULL,'NC',NULL,NULL,NULL,1,41,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(14,150,NULL,NULL,2,'CS LALO',NULL,'CE14','NC',NULL,'NC',NULL,NULL,NULL,1,42,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(15,150,NULL,NULL,2,'CS TOVIKLIN',NULL,'CE15','NC',NULL,'NC',NULL,NULL,NULL,1,43,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(16,150,NULL,NULL,2,'CSC NATITINGOU',NULL,'CE16','NC',NULL,'NC',NULL,NULL,NULL,1,12,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(17,150,NULL,NULL,2,'PRISON CIVILE DE NATITINGOU',NULL,'CE17','NC',NULL,'NC',NULL,NULL,NULL,1,12,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(18,150,NULL,NULL,2,'EQUIPE DDS',NULL,'CE18','NC',NULL,'NC',NULL,NULL,NULL,1,12,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(19,150,NULL,NULL,2,'CS BOUKOMBE',NULL,'CE19','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(20,150,NULL,NULL,2,'CS TOUCOUNTOUNA',NULL,'CE20','NC',NULL,'NC',NULL,NULL,NULL,1,15,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(21,150,NULL,NULL,2,' CS KOUANDE',NULL,'CE21','NC',NULL,'NC',NULL,NULL,NULL,1,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(22,150,NULL,NULL,2,'CS KEROU',NULL,'CE22','NC',NULL,'NC',NULL,NULL,NULL,1,9,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(23,150,NULL,NULL,2,'CS PEHUNCO',NULL,'CE23','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(24,150,NULL,NULL,2,'CS TANGUIETA',NULL,'CE24','NC',NULL,'NC',NULL,NULL,NULL,1,14,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(25,150,NULL,NULL,2,'CS MATERI',NULL,'CE25','NC',NULL,'NC',NULL,NULL,NULL,1,11,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(26,150,NULL,NULL,2,'CS COBLY',NULL,'CE26','NC',NULL,'NC',NULL,NULL,NULL,1,8,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(27,150,NULL,NULL,2,'HZ LOKOSSA',NULL,'CE27','NC',NULL,'NC',NULL,NULL,NULL,1,54,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(28,150,NULL,NULL,2,'CS ATHIEME',NULL,'CE28','NC',NULL,'NC',NULL,NULL,NULL,1,49,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(29,150,NULL,NULL,2,'CS COME',NULL,'CE29','NC',NULL,'NC',NULL,NULL,NULL,1,51,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(30,150,NULL,NULL,2,'CS BOPA ',NULL,'CE30','NC',NULL,'NC',NULL,NULL,NULL,1,50,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(31,150,NULL,NULL,2,'CS GRAND-POPO',NULL,'CE31','NC',NULL,'NC',NULL,NULL,NULL,1,52,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(32,150,NULL,NULL,2,'CS HOUEYOGBE',NULL,'CE32','NC',NULL,'NC',NULL,NULL,NULL,1,53,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(33,150,NULL,NULL,2,'CS PARAKOU',NULL,'CE33','NC',NULL,'NC',NULL,NULL,NULL,1,28,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(34,150,NULL,NULL,2,'CHUD BORGOU',NULL,'CE34','NC',NULL,'NC',NULL,NULL,NULL,1,28,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(35,150,NULL,NULL,2,'CS N\'DALI',NULL,'CE35','NC',NULL,'NC',NULL,NULL,NULL,1,26,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(36,150,NULL,NULL,2,'CS TCHAOUROU',NULL,'CE36','NC',NULL,'NC',NULL,NULL,NULL,1,31,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(37,150,NULL,NULL,2,'CSC NIKKI',NULL,'CE37','NC',NULL,'NC',NULL,NULL,NULL,1,27,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(38,150,NULL,NULL,2,'CS KALALE',NULL,'CE38','NC',NULL,'NC',NULL,NULL,NULL,1,25,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(39,150,NULL,NULL,2,'CS PERERE',NULL,'CE39','NC',NULL,'NC',NULL,NULL,NULL,1,29,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(40,150,NULL,NULL,2,'CS BEMBEREKE',NULL,'CE40','NC',NULL,'NC',NULL,NULL,NULL,1,24,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(41,150,NULL,NULL,2,'CS SINENDE',NULL,'CE41','NC',NULL,'NC',NULL,NULL,NULL,1,30,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(42,150,NULL,NULL,2,'CHD ZOU',NULL,'CE42','NC',NULL,'NC',NULL,NULL,NULL,1,16,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(43,150,NULL,NULL,2,'CS VIDOLE',NULL,'CE43','NC',NULL,'NC',NULL,NULL,NULL,1,16,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(44,150,NULL,NULL,2,'CS AGBANGNIZOUN',NULL,'CE44','NC',NULL,'NC',NULL,NULL,NULL,1,70,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(45,150,NULL,NULL,2,'CS DJIDJA',NULL,'CE45','NC',NULL,'NC',NULL,NULL,NULL,1,73,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(46,150,NULL,NULL,2,'HZ DAA',NULL,'CE46','NC',NULL,'NC',NULL,NULL,NULL,1,73,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(47,150,NULL,NULL,2,'CS COVE',NULL,'CE47','NC',NULL,'NC',NULL,NULL,NULL,1,72,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(48,150,NULL,NULL,2,'CS ZAGNANADO',NULL,'CE48','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(49,150,NULL,NULL,2,'CS OUINHI',NULL,'CE49','NC',NULL,'NC',NULL,NULL,NULL,1,74,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(50,150,NULL,NULL,2,'CS ZOGBODOMEY',NULL,'CE50','NC',NULL,'NC',NULL,NULL,NULL,1,77,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(51,150,NULL,NULL,2,'CS BOHICON',NULL,'CE51','NC',NULL,'NC',NULL,NULL,NULL,1,71,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(52,150,NULL,NULL,2,'CS ZAKPOTA',NULL,'CE52','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(53,150,NULL,NULL,2,'HOPITAL DE ZONE POBE',NULL,'CE53','NC',NULL,'NC',NULL,NULL,NULL,1,67,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(54,150,NULL,NULL,2,'CS ISSABA  DDS',NULL,'CE54','NC',NULL,'NC',NULL,NULL,NULL,1,67,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(55,150,NULL,NULL,2,'CS KETOU',NULL,'CE55','NC',NULL,'NC',NULL,NULL,NULL,1,66,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(56,150,NULL,NULL,2,'CS KPANKOU',NULL,'CE56','NC',NULL,'NC',NULL,NULL,NULL,1,66,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(57,150,NULL,NULL,2,'CS ADJA -OUERE',NULL,'CE57','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(58,150,NULL,NULL,2,'CS IKPINLE',NULL,'CE58','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(59,150,NULL,NULL,2,'CS MASSE',NULL,'CE59','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(60,150,NULL,NULL,2,'CS SAKETE1',NULL,'CE60','NC',NULL,'NC',NULL,NULL,NULL,1,68,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(61,150,NULL,NULL,2,'CS SAKETE2',NULL,'CE61','NC',NULL,'NC',NULL,NULL,NULL,1,68,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(62,150,NULL,NULL,2,'CS ITADJEBOU',NULL,'CE62','NC',NULL,'NC',NULL,NULL,NULL,1,68,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(63,150,NULL,NULL,2,'CS TAKON',NULL,'CE63','NC',NULL,'NC',NULL,NULL,NULL,1,68,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(64,150,NULL,NULL,2,'CS YOKO',NULL,'CE64','NC',NULL,'NC',NULL,NULL,NULL,1,68,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(65,150,NULL,NULL,2,'CS  IFANGNI',NULL,'CE65','NC',NULL,'NC',NULL,NULL,NULL,1,65,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(66,150,NULL,NULL,2,'CS  BANIGBE',NULL,'CE66','NC',NULL,'NC',NULL,NULL,NULL,1,65,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(67,150,NULL,NULL,2,'CS  KOKOUMOLOU',NULL,'CE67','NC',NULL,'NC',NULL,NULL,NULL,1,65,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(68,150,NULL,NULL,2,'CS  TCHAADA',NULL,'CE68','NC',NULL,'NC',NULL,NULL,NULL,1,65,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(69,150,NULL,NULL,2,'CS  DAAGBE',NULL,'CE69','NC',NULL,'NC',NULL,NULL,NULL,1,65,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(70,150,NULL,NULL,2,'CS  LAGBE',NULL,'CE70','NC',NULL,'NC',NULL,NULL,NULL,1,65,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(71,150,NULL,NULL,2,'CS ABOMEY-CALAVI',NULL,'CE71','NC',NULL,'NC',NULL,NULL,NULL,1,16,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(72,150,NULL,NULL,2,'CS HEVIE',NULL,'CE72','NC',NULL,'NC',NULL,NULL,NULL,1,16,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(73,150,NULL,NULL,2,'CS GODOMEY',NULL,'CE73','NC',NULL,'NC',NULL,NULL,NULL,1,16,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(74,150,NULL,NULL,2,'CS SO-AVA',NULL,'CE74','NC',NULL,'NC',NULL,NULL,NULL,1,20,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(75,150,NULL,NULL,2,'CS KINDJI',NULL,'CE75','NC',NULL,'NC',NULL,NULL,NULL,1,19,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(76,150,NULL,NULL,2,'CS PAHOU',NULL,'CE76','NC',NULL,'NC',NULL,NULL,NULL,1,19,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(77,150,NULL,NULL,2,'CS TORI-BOSSITO',NULL,'CE77','NC',NULL,'NC',NULL,NULL,NULL,1,22,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(78,150,NULL,NULL,2,'CS KPOMASSE',NULL,'CE78','NC',NULL,'NC',NULL,NULL,NULL,1,18,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(79,150,NULL,NULL,2,' CS ALLADA',NULL,'CE79','NC',NULL,'NC',NULL,NULL,NULL,1,17,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(80,150,NULL,NULL,2,' CS TOFFO ',NULL,'CE80','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(81,150,NULL,NULL,2,'CS ZE ',NULL,'CE81','NC',NULL,'NC',NULL,NULL,NULL,1,23,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(82,150,NULL,NULL,2,'CS OGANLA',NULL,'CE82','NC',NULL,'NC',NULL,NULL,NULL,1,62,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(83,150,NULL,NULL,2,'CS ATTAKE',NULL,'CE83','NC',NULL,'NC',NULL,NULL,NULL,1,62,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(84,150,NULL,NULL,2,'CS HOUINME',NULL,'CE84','NC',NULL,'NC',NULL,NULL,NULL,1,62,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(85,150,NULL,NULL,2,'CS DOWA',NULL,'CE85','NC',NULL,'NC',NULL,NULL,NULL,1,62,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(86,150,NULL,NULL,2,'DDS OUEME',NULL,'CE86','NC',NULL,'NC',NULL,NULL,NULL,1,62,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(87,150,NULL,NULL,2,'CS HOUEDOME',NULL,'CE87','NC',NULL,'NC',NULL,NULL,NULL,1,57,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(88,150,NULL,NULL,2,'CS SEME-KPODJI',NULL,'CE88','NC',NULL,'NC',NULL,NULL,NULL,1,63,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(89,150,NULL,NULL,2,'CS AGBLANGANDAN',NULL,'CE89','NC',NULL,'NC',NULL,NULL,NULL,1,63,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(90,150,NULL,NULL,2,'PRISON CIVILE AKPRO MISSERETE',NULL,'CE90','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(91,150,NULL,NULL,2,'CS AKPRO MISSERETE',NULL,'CE91','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(92,150,NULL,NULL,2,'CS AVRANKOU',NULL,'CE92','NC',NULL,'NC',NULL,NULL,NULL,1,59,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(93,150,NULL,NULL,2,'CS ADJARRA',NULL,'CE93','NC',NULL,'NC',NULL,NULL,NULL,1,55,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(94,150,NULL,NULL,2,'HZ ADJOHOUN',NULL,'CE94','NC',NULL,'NC',NULL,NULL,NULL,1,56,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(95,150,NULL,NULL,2,'CS BONOU',NULL,'CE95','NC',NULL,'NC',NULL,NULL,NULL,1,60,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(96,150,NULL,NULL,2,'CS DANGBO',NULL,'CE96','NC',NULL,'NC',NULL,NULL,NULL,1,61,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(97,150,NULL,NULL,2,'CSC DJOUGOU',NULL,'CE97','NC',NULL,'NC',NULL,NULL,NULL,1,46,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(98,150,NULL,NULL,2,'HZ Ordre de MALTE',NULL,'CE98','NC',NULL,'NC',NULL,NULL,NULL,1,46,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(99,150,NULL,NULL,2,'CSC COPARGO',NULL,'CE99','NC',NULL,'NC',NULL,NULL,NULL,1,45,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(100,150,NULL,NULL,2,'CSC OUAKE',NULL,'CE100','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(101,150,NULL,NULL,2,'CSC BASSILA',NULL,'CE101','NC',NULL,'NC',NULL,NULL,NULL,1,44,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(102,150,NULL,NULL,2,'CS DASSA ZOUME',NULL,'CE102','NC',NULL,'NC',NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(103,150,NULL,NULL,2,'CS GLAZOUE',NULL,'CE103','NC',NULL,'NC',NULL,NULL,NULL,1,34,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(104,150,NULL,NULL,2,'CS SAVALOU',NULL,'CE104','NC',NULL,'NC',NULL,NULL,NULL,1,36,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(105,150,NULL,NULL,2,'CS BANTE',NULL,'CE105','NC',NULL,'NC',NULL,NULL,NULL,1,32,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(106,150,NULL,NULL,2,'CS SAVE',NULL,'CE106','NC',NULL,'NC',NULL,NULL,NULL,1,37,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(107,150,NULL,NULL,2,'CS OUESSE',NULL,'CE107','NC',NULL,'NC',NULL,NULL,NULL,1,35,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(108,150,NULL,NULL,2,'CS COTONOU 1',NULL,'CE108','NC',NULL,'NC',NULL,NULL,NULL,1,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(109,150,NULL,NULL,2,'CHUMEL 2',NULL,'CE109','NC',NULL,'NC',NULL,NULL,NULL,1,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(110,150,NULL,NULL,2,'CNHU-HKM',NULL,'CE110','NC',NULL,'NC',NULL,NULL,NULL,1,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(111,150,NULL,NULL,2,'PALAIS DES CONGRES',NULL,'CE111','NC',NULL,'NC',NULL,NULL,NULL,1,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(112,150,NULL,NULL,2,'CS AIDJEDO',NULL,'CE112','NC',NULL,'NC',NULL,NULL,NULL,1,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(113,150,NULL,NULL,2,'CHUMEL 1',NULL,'CE113','NC',NULL,'NC',NULL,NULL,NULL,1,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(114,150,NULL,NULL,2,'CS ZOGBO ',NULL,'CE114','NC',NULL,'NC',NULL,NULL,NULL,1,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(115,150,NULL,NULL,2,'CS GBEGAMEY',NULL,'CE115','NC',NULL,'NC',NULL,NULL,NULL,1,48,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:02:10','2021-12-26 14:02:10',NULL),
(116,151,NULL,NULL,2,'Laboratoire National de Cotonou',NULL,'LAB-116','LNC',157,'Les Cocotiers','NC',NULL,NULL,25,48,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2021-12-26 14:09:47','2021-12-26 14:10:07',NULL);

--
-- Table structure for table `vaccine_marketing_manufacturers`
--

CREATE TABLE `vaccine_marketing_manufacturers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `lang` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `system_oid` varchar(255) DEFAULT NULL,
  `version` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vaccine_marketing_manufacturers`
--

INSERT INTO `vaccine_marketing_manufacturers` VALUES
(1,'ORG-100001699','AstraZeneca AB','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(2,'ORG-100030215','Biontech Manufacturing GmbH','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(3,'ORG-100001417','Janssen-Cilag International','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(4,'ORG-100031184','Moderna Biotech Spain S.L.','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(5,'ORG-100006270','Curevac AG','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(6,'ORG-100013793','CanSino Biologics','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(7,'ORG-100020693','China Sinopharm International Corp. - Beijing location','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(8,'ORG-100010771','Sinopharm Weiqida Europe Pharmaceutical s.r.o. - Prague location','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(9,'ORG-100024420','Sinopharm Zhijun (Shenzhen) Pharmaceutical Co. Ltd. - Shenzhen location','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(10,'ORG-100032020','Novavax CZ AS','en','https://spor.ema.europa.eu/v1/organisations',NULL,'','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(11,'Gamaleya-Research-Institute','Gamaleya Research Institute','en','http://ec.europa.eu/temp/vaccinemanufacturer',NULL,'1.0','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(12,'Vector-Institute','Vector Institute','en','http://ec.europa.eu/temp/vaccinemanufacturer',NULL,'1.0','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(13,'Sinovac-Biotech','Sinovac Biotech','en','http://ec.europa.eu/temp/vaccinemanufacturer',NULL,'1.0','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(14,'Bharat-Biotech','Bharat Biotech','en','http://ec.europa.eu/temp/vaccinemanufacturer',NULL,'1.0','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(15,'ORG-100001981','Serum Institute Of India Private Limited','en','n/a',NULL,'1.0','2022-03-13 06:34:59','2022-03-13 06:34:59'),
(16,'Sanofi Pasteur','Amaril','fr',NULL,NULL,NULL,NULL,NULL),
(17,'MedImmune','YF-VAX','en',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `vaccine_medicinals`
--

CREATE TABLE `vaccine_medicinals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `lang` varchar(255) NOT NULL,
  `system` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vaccine_medicinals`
--

INSERT INTO `vaccine_medicinals` VALUES
(1,'EU/1/20/1528','Comirnaty','en','https://ec.europa.eu/health/documents/community-register/html/','','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(2,'EU/1/20/1507','COVID-19 Vaccine Moderna','en','https://ec.europa.eu/health/documents/community-register/html/','','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(3,'EU/1/21/1529','Vaxzevria','en','https://ec.europa.eu/health/documents/community-register/html/','','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(4,'EU/1/20/1525','COVID-19 Vaccine Janssen','en','https://ec.europa.eu/health/documents/community-register/html/','','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(5,'CVnCoV','CVnCoV','en','http://ec.europa.eu/temp/vaccineproductname','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(6,'Sputnik-V','Sputnik-V','en','http://ec.europa.eu/temp/vaccineproductname','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(7,'Convidecia','Convidecia','en','http://ec.europa.eu/temp/vaccineproductname','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(8,'EpiVacCorona','EpiVacCorona','en','http://ec.europa.eu/temp/vaccineproductname','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(9,'BBIBP-CorV','BBIBP-CorV','en','http://ec.europa.eu/temp/vaccineproductname','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(10,'Inactivated-SARS-CoV-2-Vero-Cell','Inactivated SARS-CoV-2 (Vero Cell)','en','http://ec.europa.eu/temp/vaccineproductname','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(11,'CoronaVac','CoronaVac','en','http://ec.europa.eu/temp/vaccineproductname','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(12,'Covaxin','Covaxin (also known as BBV152 A, B, C)','en','http://ec.europa.eu/temp/vaccineproductname','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(13,'Sinovac-Biotech','Sinovac-Biotech','en','http://www.sinovac.com/index.php','1.0','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(14,'Amaril','Amaril','en','','','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(15,'Stamaril','Stamaril','en','','','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(16,'Arilvax','Arilvax','en','','','2021-12-26 21:38:37','2021-12-26 21:38:37'),
(17,'YF-VAX','YF-VAX','en','','','2021-12-26 21:38:37','2021-12-26 21:38:37');

--
-- Table structure for table `vaccine_prophylaxes`
--

CREATE TABLE `vaccine_prophylaxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `lang` varchar(255) NOT NULL,
  `system` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vaccine_prophylaxes`
--

INSERT INTO `vaccine_prophylaxes` VALUES
(1,'1119349007','SARS-CoV-2 mRNA vaccine','en','http://snomed.info/sct','http://snomed.info/sct/900000000000207008/version/20210131','2021-12-26 21:38:36','2021-12-26 21:38:36'),
(2,'1119305005','SARS-CoV-2 antigen vaccine','en','http://snomed.info/sct','http://snomed.info/sct/900000000000207008/version/20210131','2021-12-26 21:38:36','2021-12-26 21:38:36'),
(3,'J07BX03','covid-19 vaccines','en','http://www.whocc.no/atc','2021-01','2021-12-26 21:38:36','2021-12-26 21:38:36'),
(4,'0000000000','Vaccin \n Fievre Jaune','en','https://www.mesvaccins.net/','','2021-12-26 21:38:36','2021-12-26 21:38:36');

--
-- Table structure for table `validity_rules`
--

CREATE TABLE `validity_rules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `string_id` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `validity_rules`
--

INSERT INTO `validity_rules` VALUES
(2,'ln9XDKPKDeJh9BpyEacgVj83NXtMjblU0K9uNkYP2M2vASqi','261','AppName','Surveillance Sanitaire BJ',NULL,'2022-02-01 17:08:01','2022-03-14 08:46:15'),
(3,'OWh8o6IFnoLkLEsPwRHDL2eKCRO5DUenmIjkXqNYq1W9w3s2','261','AppUrl','https://passsanitaire.gouv.bj',NULL,'2022-02-01 17:45:47','2022-03-14 06:16:06'),
(4,'VT8SIFjWRH9L8erHTKPSo9w9RdNCYEVlqmrlbVzMhY9HG6OA','262','TestNegativePcrPeriode','48','Durée de validité d\'un Test PCR de base','2022-02-01 17:46:18','2022-03-14 08:43:46'),
(5,'EomusCUhLSHkXO6bEaIT8D8GXF6Diet1logWQWOs4LAEOCmy','262','TestNegativeAntigenicPeriode','24','Durée de validité d\'un Test Antigénique de base','2022-02-01 17:46:45','2022-03-14 05:48:35'),
(6,'Tlcb1M2IeoAMK1JGuIEsP1hHJHTMjHNGPKnAP7LTfSb4q7S3','262','PassVaccinalActif','7','Pass Vaccinal actif 7 jours après la 2eme dose selon le vaccin administré','2022-02-02 09:01:20','2022-03-14 05:48:54'),
(7,'CmUYQE4bcFk56JUDbip54Ch8nO5eZQBONuyzacaJ6bkKKLa9','262','TestPositivePcrPeriode','15','Durée d\'isolement de base d\'un cas  testé positif','2022-02-02 09:07:16','2022-03-14 05:49:15'),
(8,'kvFF1tvcbEmODmqBG3WgLMW6JfijQTu0OQIZOw9lg3Ye3eaK','262','RecoveryPeriode','15','Guérison d\'un cas testé positif après  15 jours d\'incubation','2022-02-02 09:11:55','2022-03-14 05:49:33'),
(9,'WxjH81YwK2i5O4oF2jXAb4nwjX4FaRKEghb6vjrfOkCssXYi','262','RecoveryProtection','180','Protection naturelle durant 180 jours après la guérison','2022-02-02 09:35:51','2022-03-14 05:49:49'),
(10,'RWisIe110zS9Lsx2QmflhDqC8XEDkZlYRIfdU5lDoLQIaYwL','262','VaccinalProtection','180','Protection Vaccinale durant 180 jours après la 2eme dose','2022-02-02 09:38:37','2022-03-14 05:50:10'),
(11,'1isFedS9ZlxK60TiKodzAdFSi5A8g3jyvBOgYsySqpfDYQWt','263','PassVaccinal','0','Benin: Pass Vaccinal actif 0 jour après la 2eme dose selon vaccin ( série dose vaccin)','2022-02-02 09:39:59','2022-03-18 19:15:30'),
(12,'0wRH0McDSiljJcxuu5zjlxrcgMLU9pkngL5LuL9zlmtiFtF6','263','VaccinalProtection','180','Benin: Pass Vaccinal délai maximum de protection avant et après  dose de rappel','2022-02-02 09:47:03','2022-03-14 05:51:55'),
(13,'0jgxHP0YEFQSLADNmFdjHyH5jkbeDzjg3XzFyGK1PDttCef7','264','TestNegativePcrPeriode','120','Benin: Durée de validité d\'un Test PCR à partir de la date d\'échantillonnage','2022-02-02 09:50:41','2022-03-14 05:53:31'),
(14,'zqKTQE43idLigSL0tru8SMYXzx8Z6biN4cP0YoNIldRbieyU','264','TestNegativeAntigeniquePeriode','0','Benin: Durée de validité d\'un Test Antigénique','2022-02-02 09:54:16','2022-03-27 22:27:59'),
(15,'4jitVuhDwTedqK9h4xDdkE4MssDcXuqtrzNiYmRNf9rKlvaf','265','RecoveryProtection','180','Benin: N\'est pas accepteR mais...','2022-02-02 09:56:12','2022-03-14 08:45:06'),
(16,'lmOKn0M2gHmbHIOda8hEj2vGwmVN0PCnD9gw0GLdxi1i3iWP','261','ApiLogin','https://passsanitaire.gouv.bj/api/login',NULL,'2022-03-14 06:00:36','2022-03-14 06:17:12'),
(17,'ZgaVjgkccV3U2lhk8DovIXQUkGPdk3nnLk0vrMIcXG1sI9af','261','ApiValidityRule','https://passsanitaire.gouv.bj/api/validity-rules',NULL,'2022-03-14 06:03:39','2022-03-14 06:17:36'),
(18,'79nCKZjCuRN2sIQAvyVpYMyTInH21J9Co4VyQIZvTKm1fNap','261','ApiNationalDsc','https://passsanitaire.gouv.bj/api/trust-list2',NULL,'2022-03-14 06:04:28','2022-03-14 06:18:01'),
(19,'v50N6KfPw3olKDNw3SOZtjIYxnXKMXDBM0X993SJhjhRrRXb','261','ApiUeTrustlist','https://passsanitaire.gouv.bj/api/trust-list',NULL,'2022-03-14 06:05:22','2022-03-14 06:18:24'),
(20,'FwTIq9nwALVR7lgXMmH2ZH11grq2op1dVZaeibLPJnfA7d1b','261','Country','BJ',NULL,'2022-03-14 06:06:08','2022-03-14 06:06:08'),
(21,'2nmusjahElgZSpim8tKbEq1taP2Rw13gIPu4Y18yZ1vw9FWP','261','MajUrl','https://passsanitaire.gouv.bj/download',NULL,'2022-03-14 06:07:01','2022-03-28 06:33:18'),
(22,'RjfhVpLHyiZHF8XJXo8dtTBK64vMhYmGic2T2KQPXcpMmPbr','261','CnxUrl','https://passsanitaire.gouv.bj/api/licence',NULL,'2022-03-14 06:07:49','2022-03-14 06:19:10'),
(23,'G8gpy6eEQWxJPJLV1AMLAKH9VTTVeiFjpss4F3Bl8tCiwOeb','261','DocWalletUrl','https://passsanitaire.gouv.bj/ewallet.pdf',NULL,'2022-03-14 06:08:30','2022-03-28 06:32:32'),
(24,'C1XMDA7kPdSmF9vLWSUpDTugE9Gct9tmSegNhjk60HI91uxR','261','DocVerifierUrl','https://passsanitaire.gouv.bj/everifier.pdf',NULL,'2022-03-14 06:09:35','2022-03-28 06:32:50'),
(25,'FHZXfc1ok3nCaAwujz3yao2aPLhwmrFTfbHHWWzd1vYVOZKV','263','Pfizer','2',NULL,'2022-03-14 23:27:30','2022-03-14 23:27:30'),
(26,'SrxWitckyFuk0xTniCgfhghDuSFw8DIhwAJsTPcHyd1RISEz','263','Moderna','2',NULL,'2022-03-14 23:28:05','2022-03-14 23:28:05'),
(27,'fp18DRFeKfFKgANiPSIvJGnJgi886sCB9px37Ojwnnet41qY','263','Janssen','1',NULL,'2022-03-14 23:29:05','2022-03-14 23:29:05'),
(28,'APpZ8HiqKpJkgfE0RlUk4chwAEGHs8G7926KmzZnDGtYZRQd','263','AstraZeneca','2',NULL,'2022-03-14 23:29:45','2022-03-14 23:29:45'),
(29,'FXaetpZr36xfvMKCeOM4QmR98H1v3kfyPty31mozCVH23fFM','263','SputnikLight','1',NULL,'2022-03-14 23:30:16','2022-03-14 23:30:16'),
(30,'HyNuoZi9dyd3k4kcVjQqTLQ4xvjwrWES1BLu3PnFqTLagaAj','263','SinovacBiotech','2',NULL,'2022-03-14 23:35:00','2022-03-14 23:35:00'),
(31,'ULZKImq8Pc1fGi3mEgZTWvJSglXGznw3zyavqDJieEzJBdSR','263','ORG-100001699','AstraZeneca',NULL,'2022-03-14 23:39:00','2022-03-14 23:39:00'),
(32,'Mozsw3MVbehsXKxhq1Zp7cR2HcdiIYH4ZPVR43Rdf9eng5YA','263','ORG-100030215','Pfizer','\"ORG-100001417\": \"Janssen\",         \"ORG-100031184\": \"Moderna\",         \"Sputnik-Light\": \"SputnikLight\"','2022-03-14 23:39:38','2022-03-14 23:39:38'),
(33,'2VvgX4hmYZ5Q8CHD3Qvf9HMueE5DfH6mhrMsCwvROTNvdr5K','263','ORG-100001417','Janssen',NULL,'2022-03-14 23:40:15','2022-03-14 23:40:15'),
(34,'vblIuUbLOKe1NWrjEilCYdh6sm1BjulhI9ZOWI8mw74jgdWj','263','ORG-100031184','Moderna',NULL,'2022-03-14 23:41:02','2022-03-14 23:41:02'),
(35,'5TM2Rx84wBABTECTCN8E2W4ho3xWeg3Fj3e2v9kymBktu1zD','263','Sputnik-Light','SputnikLight',NULL,'2022-03-14 23:42:18','2022-03-14 23:42:18'),
(36,'CY3TfyTodHxX1xgUsnQKLYPbvtIpqeAi74mf0knNFhYPnoFL','263','Sinovac-Biotech','SinovacBiotech',NULL,'2022-03-14 23:42:44','2022-03-14 23:42:44'),
(37,'Gd5OLXFMCGuYAMAjuimxpjrHNJVEk1Wrjsbuvsr3DQOKb6j1','261','ApiBusiness-Rules','https://passsanitaire.gouv.bj/api/national-rules','Business Rules','2022-07-07 13:08:23','2022-07-08 12:25:22');


