# SOURCES

CREATE TABLE authsources (
                             id      INT AUTO_INCREMENT,
                             name    VARCHAR(64) NOT NULL,
                             source  LONGTEXT    NOT NULL,
                             PRIMARY KEY (id),
                             UNIQUE INDEX (name)
) CHARSET = utf8mb4;

INSERT INTO authsources (name, source)
VALUES ('decisionwise.com-microsoft','{
            "0": "saml:SP",
            "entityID": "DW-AUTH-APP-<ENVIRONMENT>",
            "idp": "https://sts.windows.net/049f19f8-8277-4757-8c70-42fd965a66b7/",
            "discoURL": null
        }');

INSERT INTO authsources (name, source)
VALUES ('decisionwise.com','{
            "0": "multiauth:MultiAuth",
            "sources": {
                "decisionwise.com-basic": {
                    "text": {
                        "en": "Log in with email and password",
                        "es": "Entrar usando correo electrónico y contraseña"
                    },
                    "help": {
                        "en": "Log in with email and password",
                        "es": "Entrar usando correo electrónico y contraseña"
                    },
                    "css-class": "SAML",
                    "AuthnContextClassRef": "urn:oasis:names:tc:SAML:2.0:ac:classes:InternetProtocolPassword"
                },
                "decisionwise.com-microsoft": {
                    "text": {
                        "en": "Log in using Microsoft",
                        "es": "Entrar usando Microsoft"
                    },
                    "help": {
                        "en": "Log in using Microsoft",
                        "es": "Entrar usando Microsoft"
                    },
                    "css-class": "SAML",
                    "AuthnContextClassRef": ["urn:oasis:names:tc:SAML:2.0:ac:classes:X509", "urn:oasis:names:tc:SAML:2.0:ac:classes:PreviousSession"]
                }
            }
        }');

INSERT INTO authsources (name, source)
VALUES ('ipmcinc.com-azure','{
        "0":"saml:SP",
        "entityID": "https://auth.spectiv.app/module.php/saml/sp/saml2-acs.php/ipmcinc.com-azure",
        "idp": "https://sts.windows.net/bffd8bb9-1e55-4d4a-b67e-8642a269006c/",
        "discoURL": null
    }');

INSERT INTO authsources (name, source)
VALUES ('ipmcinc.com','{
        "0": "multiauth:MultiAuth",
        "sources": {
            "decisionwise.com-basic": {
                "text": {
                    "en": "Log in with email and password",
                    "es": "Entrar usando correo electrónico y contraseña"
                },
                "help": {
                    "en": "Log in with email and password",
                    "es": "Entrar usando correo electrónico y contraseña"
                },
                "css-class": "SAML",
                "AuthnContextClassRef": "urn:oasis:names:tc:SAML:2.0:ac:classes:InternetProtocolPassword"
            },
            "ipmcinc.com-azure": {
                "text": {
                    "en": "Log in using Microsoft",
                    "es": "Entrar usando Microsoft"
                },
                "help": {
                    "en": "Log in using Microsoft",
                    "es": "Entrar usando Microsoft"
                },
                "css-class": "SAML",
                "AuthnContextClassRef": ["urn:oasis:names:tc:SAML:2.0:ac:classes:X509", "urn:oasis:names:tc:SAML:2.0:ac:classes:PreviousSession"]
            }
        }
    }');

INSERT INTO authsources (name, source)
VALUES ('westconsincu.org','{
            "0": "saml:SP",
            "entityID": "https://auth.spectiv.app/module.php/saml/sp/saml2-acs.php/westconsincu.org",
            "idp": "https://aar0279.my.idaptive.app/08b2576d-b9a5-4172-94fc-2e2dfe3e882c",
            "discoURL": null
        }');

INSERT INTO authsources (name, source)
VALUES ('victra.com','{
            "0": "saml:SP",
            "entityID": "https://auth.spectiv.app/module.php/saml/sp/saml2-acs.php/victra.com",
            "idp": "https://sts.windows.net/dfe182cd-80fc-443e-a510-771396aa19e8/",
            "discoURL": null
        }');

INSERT INTO authsources (name, source)
VALUES ('venerable.com','{
            "0": "saml:SP",
            "entityID": "https://auth.spectiv.app/module.php/saml/sp/saml2-acs.php/venerable.com",
            "idp": "https://sts.windows.net/5bc9119f-7f7f-466d-a282-7da42b24ea1c/",
            "discoURL": null
        }');

INSERT INTO authsources (name, source)
VALUES ('medallia.com','{
            "0": "saml:SP",
            "entityID": "DW-AUTH-APP-LOCAL",
            "idp": "https://sts.windows.net/049f19f8-8277-4757-8c70-42fd965a66b7/",
            "discoURL": null
        }');

INSERT INTO authsources (name, source)
VALUES ('akamai.com','{
            "0": "saml:SP",
            "entityID": "https://auth.spectiv.app/module.php/saml/sp/saml2-acs.php/akamai.com",
            "idp": "https://sso.akamai.com/saml2/idp",
            "discoURL": null
        }');

INSERT INTO authsources (name, source)
VALUES ('vizientinc.com','{
            "0": "saml:SP",
            "entityID": "DW-AUTH-APP-LOCAL",
            "idp": "https://sts.windows.net/049f19f8-8277-4757-8c70-42fd965a66b7/",
            "discoURL": null
        }');

INSERT INTO authsources (name, source)
VALUES ('beazley.com','{
            "0": "saml:SP",
            "entityID": "https://auth.spectiv.app/module.php/saml/sp/saml2-acs.php/beazley.com",
            "idp": "https://sts.windows.net/9a50eba8-7568-447a-bcb9-27a0d464aa80/",
            "discoURL": null
        }');


# METADATA

CREATE TABLE metadata (
                          id       INT            AUTO_INCREMENT,
                          name     VARCHAR(64)    NULL,
                          idp      TEXT           NOT NULL,
                          metadata LONGTEXT       NOT NULL,
                          PRIMARY KEY (id),
                          FOREIGN KEY (name) REFERENCES authsources (name)
                              ON UPDATE CASCADE
                              ON DELETE CASCADE
) CHARSET = utf8mb4;

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('decisionwise.com-microsoft', 'https://sts.windows.net/049f19f8-8277-4757-8c70-42fd965a66b7/', '{
    "entityid": "https://sts.windows.net/049f19f8-8277-4757-8c70-42fd965a66b7/",
    "contacts": [],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/049f19f8-8277-4757-8c70-42fd965a66b7/saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://login.microsoftonline.com/049f19f8-8277-4757-8c70-42fd965a66b7/saml2"
        }
    ],
    "SingleLogoutService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/049f19f8-8277-4757-8c70-42fd965a66b7/saml2"
        }
    ],
    "ArtifactResolutionService": [],
    "NameIDFormats": [],
    "keys": [
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQPGNcKUc1fINJ4w6D/0KskzANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yMTA3MjYxOTA0NDlaFw0yNDA3MjYxOTA0NDlaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA24ukhwto5i06v09IZAc0CZZcdJu3BwVYbtsSvw9pNZVoEYyEHPlQmvo2RSpy4QRYgiBryOovGuhOuoVzh/IF5NCkTXib61C/pVlXiIENboEIfDDV+HQ78YTAIzU8nu8Bvnsk+d3XSQJIX3qDnJBqxk/L1cv4GhgDcw7zg8aPIgpTJ4fjwFjme6GXiB67AcLyJpr5QeR0/hjSQ0dGatqeyVJN/HYtdHtZn8D1Z+xHJhXcO6CvCflgKNmuX/d4OXnHhIPO24aYRO9EGRp9cwd9jV8NoxT6zHGhVPre21GbweDfU9lpu3xDe7iOPmeUTZfGU8UZXaAT641TnJBIaUlUyQIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQDOlndlpIDhEbTnJYHm6oIpx3FZ+YMrAep+GlArhS0Q4nau62gOIhJx7Rbe5k7lFqoTDETCdc10h9UUNTwpshSCXI4gayzDjy0D+OxWiqszRqDtbLN3vj0kYBKULEQuq9YKJvB+2iK6BKf+svTXgpLymhN4j1IROrvC3hUzFjAHYmq0zlUoAD9v8MoMi3f2j0csD08KpyPnOJVJP3Hfl9y5dG4918DEeRClTZd7hGWU/HXPmKyNksmWjPhdi6TxWdfXcTUw71XsYtLC48Zxbwqty/0DvigjMWv6jr5pZFQmt7aXpy+x6UtXeRZ8sCjvWBMCdrX9DnGHff8ATXwUk7kG"
        },
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQQq3rRCOFVqZBP3KeUEqQKTANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yMTA0MjcyMTQ3NTlaFw0yNDA0MjcyMTQ3NTlaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyxpHeT+BvitGmmVvVQJh5n3w+LuUYydvolCu6sESQuw9Ys/23b3LKHxUrG0tqjuumvE5ktIs62rjlq6neCbwQvZlO8jCqYQuv+CoXbUWr0A2tZKQZGvFJfQ6rcrqTiCD/m68g/db/hx/+Q3roZ5df9FVG4nxyZSqM4njfvu3MTVRS0os24D5n7/hZkIQux6ZAUGKu5a57Zx3fAiaTjaABvQWqi52NXUPUfBKbHmIQMskuGeyg6mixbfcmknADWMrIcODSLPK5Q++tbYeQWuIhGkFvIWCpAKNKOHqvCnzvd69j6eb4wKlWL84Gc3KUz9yZxaV4/gG7xzWzN3ZYgYuCQIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQCUJfs3r4cdQefTj/hFAKH0olRFgtuq2py/Lx4bIOCun65MwYdNtjzQunQC/KDGxUqshBiKMjV1IXgdQCh5vdS5thUZ3zxuEdqlznxn7eHN7t3BI0Tq3VIxk0VmECu6FAqDNIfNkBruIxpD4vdEOhOGDnk/gor5UnM0BUgxF4SPrqeYJm74H3OOJk008A8aDWctfVrjuAIEbDzAgHNQY0ySRxXx5cMcDUeEnfTEXHRfKMbFQmq8YUbxj4HYT7pNK4pl/uu+BQrwqU9rlMiPr2kBUrj9LRjNoKynoqco4t9a1ew8WGf/uPVd3i4rovWYuE9TDw9xYyzpFzZXEi7bA85v"
        },
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQFPA/HUzQcJJO8mm4bMSRGDANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yMTEyMjAyMzIzMThaFw0yNDEyMjAyMzIzMThaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAzGLHJNDR3HREDxc1eETSCIdCGZ8Lwplsj50kcGqUZSVozTBz/1I/TTH1qxDoLxWvFyrJJWE53KZEZmQUrVzpu9olply8DrxyIxmf6D3yoJ41UeRodfQSFudBEqEti00pNLMO4LvLch2Bi31OpMn93I2dyuHjvZIUIFLVFJUahwqHBOAWu308ujCkmBsJUe9WOuCIBMpDBkAG4VJDn0zFEAqBrCZl003nMp9EUR35wVobX3K08fvNjj9sH7zOgyKaVZ8N59OFSU7Pa3yOj87R1egNm+1i9yuwVORI2W63kHWOPQW1p8giJqo4BRmwTBGnJnsVawNN368ZtjIj16EnJQIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQB1S/F9EEcCkkhKltOReVP0itAhOttKYiNHK9rNb4ohrulqKDA/FNYNllFieyKTXW6XixHAlyToxEX/OFE9hxelNTI7XoMQJALP1DURfd9hfMW+0hf6UIusXZZz4l1eOKg2Og+PY4F/RPf25IxbuldEVzMy2NBcLjcDMIngTmNbeNnvj0JyRHvtKmyc+jTpNndwfL73cZB3QSrGJh9bT65InQEJODkjxgeOC3cn+aJlP5usyDTkBAQLt0a1M/qORUbPgR9TWrSZbiQYt6gCfSozQNzbw6XMwbF18pqamilZtM1K4txzP2AIJe5v+3vVXyHLAWrMQClezqoa7u8szvNK"
        },
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQWnKRMgtNgrpCi4mVAxGuIjANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yMjAxMDcyMDEzMzJaFw0yNTAxMDcyMDEzMzJaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAuz5C+XQhren+saCI6y6nbw94ZsigOvNH65Kl/uTKZEn9cYrwHgnifmsr0W1WXeIQdcQ+gxqLG/PZYf76k09lmEgIgKZlVB1aARrhX7Q+E1t5nvuPAGmsLih6+DTF07n9BJ9eardzAJeHT+0T0H/f9r8Q6KYBHCrmana9aOriydocCoeuzLTyk4ov6aleyjZ0pptSk5xCnLKQhKXYC/dMtqbGZOI/uS4rLDX+G99bB/fjeDmylnEHp8KGZlwcHrhbrJr5jvPMoxpPKePCpRQk/IIr8kbPGR1K2MNnaolb9ktMcU+Pwq6AcbbjDiwQUMvLg74Ka2aE8szlFbuOq0AUrQIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQBZLZEWim6Euph6Rc7ok7bIx1Bq9TVmFencTB6acdhVng6T+ICuCZF3MRpuWfxaIlubofq9tFiCxrFXr3X9rzdBO3fCjJFljnQUnJa1FIBvHNow8G+1xMbU+DnQDZsPqzqIYxgdz2ZiWmpG0u5Z58qC5soAaPTjHJ6FmoCDQ095E+s2aBHRYBBIW3QfwkmjkT3sc6D3Ia+rJOgKW+zPh3+iyAQBum6fz+eWiPiQ5oMPLeR9rJm18G9DjTTBri6zbt7L/8WvzAuT37b9H/G/6jbSyVLCAeRspFDQmtSE45uHc6lxk8P+M4LnOPam1SNOltuSmTo4YHbE1l21Xwh56fB5"
        },
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQRMFD5aPCgJZHAW/beFvAjzANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yMjAxMjUyMDI5MTdaFw0yNTAxMjUyMDI5MTdaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA1a23Yo7GsffArj2OfkkSs7t29rZv2P/tUGZ/5o9qC0wQsKQIcZlmKnim+8uRhnO7bGohNJIr3WIdPVZt6MzaP8xsN+il4SGwgcGH1emYKUU6hqooKLb8K0k9x9fFrORA02SkNA9S63ZDnnPpphH/61b4ac3AP2ZEpb7gay3gLLgbxjA0UqkinfNJNyQTVBOtEw7VlskE3K5BmuEcsQWrNMpk9aJKC27d+3UttFFztPQgts4XI26tEMr1FbGqaFiuK3C/V74bvHmkyE3GKyi89fcIOpT0cz1WD8Kg5+RSdNIiGMoEVYUR5rn8cpCNdCu5gXj0t6FdffWiEtqBNAAK/QIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQAw76JcZNqAz5ie4ZiX6xNmGb5bUwck5v3s1ftmNtZi0XrPo94XiX1uSzT+fxYfhsWiMwxzGGYxc6W9v9rjw2B7JqVjmRjxCBosdlPircikODI57tvHT7XYl0j5vSLagCAn9t1xkBdTPmjKvix5vhSkNemcHtczeNTnqdsKbXjz/C7dxIBGXFKQ4GnlCSYRx0/XYokNURWKDgmZZYf5mDD9Iq8/dQBDpKEh6786vgirBowaF9oSOLPBlUU0N3N3Bq2WZVWMigt61wDBBauIh4bd5EoDXmiTMWAndwMrAo8KXj6Lcfg1LXFe2GXGlOHn+cNP6Ew/NsR1LtIkserG6lju"
        },
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQeSWfMf6UfplLdQmA1LMWrDANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yMjAxMjUyMDMxNDJaFw0yNTAxMjUyMDMxNDJaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAorri6FIZ5ZFTlw/VScP7WQy3bSmmhXvroTkbL/VSMBlaSVGyhuTG3FqKRHpw4qxpaiZ8Wlm6feYR2n9Rn7X6+jHqRhZJkSJwKP40r23bW7I/5145JryenjSZFa+b1ClhXh2M9TLNA7Us0o6ErmV8oZA4CbhX1Xj6DlOOoBEklX7r8dsdHi6CGCFlGtQeoaBQuZGHNa43yPOVSFjVVDmJYYnMNpzpSmLqcEZWjTc+eF9jLsRn4lNGdlv0VhpV/WPfSReACfphAFkhsFDPMdNNSLFDkOF2p3Ck7h/L00NPboKw5ArM64aTRhJxnERBT182SkxZtm6i9lMbohTpnkKerQIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQCL48iZr4zCWmQrP4Lzcdp2+KzQukHjUoBxCCUIuSIc5sAwHB3nvDSSHhQGl6yfsAruTGfz0o7B34xc2B/knacowD0Quq5Uc9wF0tjS5kY57vI7X7kQcOtVAOfTBtEaJfTNwxiGdM6GaaJXHCpzfrGljAa2rQrp5dhlYdPO1os7DJ3I/XPG3SfVm6UO2gZTOeK/DcHYMmr+aQ9FcKcwhGPEKEOQnJt71o+vyNDBQXxwtaW5JknO8FrR6bVMwRA/K0TsIphN2+5egLKkm4+/EzBg7vJBgghIoyMpJMOO+SchPqPbCvbfYqeQa8LW4ouiWJ9tbEdaE6HMRl5JrA0myhp1"
        },
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQK7Uyxs5lZ7pIF3lMw5bBLzANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yNDAyMjcxNjIyMzFaFw0yNzAyMjcxNjIyMjNaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAqlxieSiDyH5P5Yl0hp5F2lh3TZMtA2J1chy+JafhJbf4mZVM8jkSi+vC3EA6t+1gzXrmV3+t0+63gw1OJTReGYZbpUieaIFrQchw02XXahq8yvVl/rpjBGJ0r1TrfidSkqiecuUAqyGHZaEaS4t0+D7L6UdTLThnyiki1fYWBx7k3SP7Ib1R1yIMolPRGyDtxjvpI2aA4F4CkyTgPA3zsvOlzxlDrbD05TJ6WNd+/+pX0b6BPnyKyw5os4JUjqFCf6/zjmfyxfS0HFRg/tRf4/7YERVNQED/PrNzNroJhnw93hOyRxS/FH/4trLAxgJacouXcHgslpi39N8zt4te/QIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQA9k8L1psdtk+UCngOpzOM37e/RHAGz5doX4cxmh11vveHvkcu9Fk449kj3o96I9bI5+dJ3Pk7eYyjp08BB2yrUEZZ+zWDVcZZXCZXvtz29CGmyXwl2DMho5GebdmbfqYouAvWIJIO9hYq9B1rA2hpjQ95+Gg3JgzojRzhc5AKy/72I1F5KMyQ7fL4zy25tJNPHpxcuHMTlKKmAuDN7kAFhMVDOALvTqhA+5rDelaF4gvKyMtNCzJat04+YdNpiuTUgmZt+mUxzojBTuctHHN6SCHX4H5B0hU3fvmE0Kvoc7BB1ZvfP57exv+CR31dgio3J8f+F42oZX27d+/ZhcTFc"
        }
    ]
}');

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('ipmcinc.com-azure', 'https://sts.windows.net/bffd8bb9-1e55-4d4a-b67e-8642a269006c/', '{
    "entityid": "https://sts.windows.net/bffd8bb9-1e55-4d4a-b67e-8642a269006c/",
    "contacts": [],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/bffd8bb9-1e55-4d4a-b67e-8642a269006c/saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://login.microsoftonline.com/bffd8bb9-1e55-4d4a-b67e-8642a269006c/saml2"
        }
    ],
    "SingleLogoutService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/bffd8bb9-1e55-4d4a-b67e-8642a269006c/saml2"
        }
    ],
    "ArtifactResolutionService": [],
    "NameIDFormats": [],
    "keys": [
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQY5uiR8or/KxFk3s/XFixRDANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yMjA4MjkxODIwMzJaFw0yNTA4MjkxODIwMzJaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAzz5zeldcDaii+Y6JjmRH8WJjAKrlcUl/nIJtvO1++WjrS6IT6CGBBya0XKqDLaiXk369zIwJj6Lc+FD2MfIlPK6e7v5q2OdesXhseM4pOJjYcN2cjLDYc0Ovey4vMSsK1JAQUhCq7d3xYSB3mTK/bqdWZs4ZIaAqMuxjGgTzw5fS8MBokC1M3dYV/DyT1u4f5vVgY2WA4OSdel5aWB/7zKivrgXe5vw2jNpojljSKUWq6UDu5CPf0hlBeVUoGMOniggMj9+v6ZBh8+6Qq4XgHbBdpcF/1TX6ZB5NpqBcSBvGdFNwJhOCEMfXFdeHE288nLq0YvcTutPRQAC4iN9e+QIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQB8WdHh803dqoGkfFWYtqfVG/8UIcTHmQrgHY+oubxwPbgvSOfm6rP1uvCU6SYqEbkbm+5n7JcRSiKRCM5gQ0aJIwiyXDdevmOsd/W7qn7fvnaV+EQ0L4+2ObpsqkDS99fhcKKAZ4hksU2mYpMEyAr1NV04Cyv0ZfXOxCuUvoS2Doxt2U39riVgj4r1qT34VOO/cdneU9qk41v6uCeQomjR/wwrzCTx7Ps7C+ZWfsJ/4xBB2AWUv8+Yw+yycYu5IqtUDeJjglqB/xxrN/qn0kzGJpQNWBfhHOWn6BlP1THD6YmxiUUMDfSTeNBHomZnEioHd8fO+WUYUMUqebfF7Wq/"
        }
    ]
}');

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('westconsincu.org', 'https://aar0279.my.idaptive.app/08b2576d-b9a5-4172-94fc-2e2dfe3e882c', '{
    "entityid": "https://aar0279.my.idaptive.app/08b2576d-b9a5-4172-94fc-2e2dfe3e882c",
    "contacts": [],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://aar0279.my.idaptive.app/applogin/appKey/08b2576d-b9a5-4172-94fc-2e2dfe3e882c/customerId/AAR0279"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://aar0279.my.idaptive.app/applogin/appKey/08b2576d-b9a5-4172-94fc-2e2dfe3e882c/customerId/AAR0279"
        }
    ],
    "SingleLogoutService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://aar0279.my.idaptive.app/applogout/appkey/08b2576d-b9a5-4172-94fc-2e2dfe3e882c/customerid/AAR0279"
        }
    ],
    "ArtifactResolutionService": [],
    "NameIDFormats": [
        "urn:oasis:names:tc:SAML:1.1:nameid-format:unspecified",
        "urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress",
        "urn:oasis:names:tc:SAML:1.1:nameid-format:X509SubjectName",
        "urn:oasis:names:tc:SAML:1.1:nameid-format:WindowsDomainQualifiedName",
        "urn:oasis:names:tc:SAML:2.0:nameid-format:kerberos",
        "urn:oasis:names:tc:SAML:2.0:nameid-format:entity",
        "urn:oasis:names:tc:SAML:2.0:nameid-format:persistent",
        "urn:oasis:names:tc:SAML:2.0:nameid-format:transient"
    ],
    "keys": [
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIDfzCCAmegAwIBAgIQR2FfuyYvz0ayjh2yYuw9FjANBgkqhkiG9w0BAQsFADAkMSIwIAYDVQQDDBlDZW50cmlmeSBDdXN0b21lciBBQVIwMjc5MB4XDTIwMDgyMDAwMjQzN1oXDTM5MDEwMTAwMDAwMFowMjEwMC4GA1UEAwwnQUFSMDI3OSBBcHBsaWNhdGlvbiBTaWduaW5nIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA13Esgs0RhF15hgnbl+JtySMGP8ApYyLFMZUJowAepGBXYEdtqdEDbLuhQfSDftPxxuvhsfHIeo1ziraZp6HZO3aLyWiEmqZMrTUtdkzVP3iSq9DwNqYr7Ri84KvviQBMm1QykA16wXEv7kusKSbhLol29b4CnA3BYCwZOhbIS4f1uZW4nTPXvN10LpBkmBaKuX8+ZBelTOIL/w4qDIFukJ+MxkLkRp177j2ANfC2r3nnuzb2bO6WtJqDimVBKS0IJYltew2JmP/VbmQdGkvn2hgGjW1l5Sqhza8CW1YHVJc/91MOqWo8zU8SoFBEptc2/ST1i5q8oz/saZ5hpcM36QIDAQABo4GeMIGbMBMGCisGAQQBgqZwAQkEBQwDMS4wMBcGCisGAQQBgqZwAQMECQwHQUFSMDI3OTAfBgNVHSMEGDAWgBTYCjr4cQP28zm2ITVkUDnE+71RvTAdBgNVHQ4EFgQUJIazaUW/ExmGO+1UQJKRHi+KE4UwDgYDVR0PAQH/BAQDAgWgMBsGCisGAQQBgqZwAQQEDQwLQXBwbGljYXRpb24wDQYJKoZIhvcNAQELBQADggEBAH8z7fKikKxnjXC9Eo5pGVOedPLtEPl32+TV99Kb6SnOBfoz0pjNeFcVZt+CeMD/qNdSHVteLk1fCdaIc3TnsCzindWdxvLKu/BtGnskyc32PRiFLEfKW7ahMR3Su++2VbcSMuQTesIuxFHJNqXeTAp4baMVYl1BOKmLkTQWA76d/rrLphyV5XlEXLAg9ySsOCg6q20RsyzwoHVDXcBNgmp947qUIaZbeD8+IS9LbkerxaBfNASNCfDCTKwF4/C2i7hglSutZNCgLLiRUx3v/RQl3m326ycFXZSqGHK4xhVhl96qWLsbb1BQCfcDtx366WGDlBkkxgzL+Tl0a0SoiCA="
        }
    ]
}');

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('victra.com', 'https://sts.windows.net/dfe182cd-80fc-443e-a510-771396aa19e8/', '{
    "entityid": "https://sts.windows.net/dfe182cd-80fc-443e-a510-771396aa19e8/",
    "contacts": [],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/dfe182cd-80fc-443e-a510-771396aa19e8/saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://login.microsoftonline.com/dfe182cd-80fc-443e-a510-771396aa19e8/saml2"
        }
    ],
    "SingleLogoutService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/dfe182cd-80fc-443e-a510-771396aa19e8/saml2"
        }
    ],
    "ArtifactResolutionService": [],
    "NameIDFormats": [],
    "keys": [
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQV7Awr4RGzo5EgtczI92T1zANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yMzA1MDIxOTU4MTJaFw0yNjA1MDIxOTU4MTJaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvUvhamvtoCciDTARvXLM9fTECq2+hBXT4nZ21e/lXbueVmFVrLOL0WDm60DgwUCCejcvrBf85pBvA8fLgacVy5l4HIzBNsxk5wJSVo7e9Qx+XSiNpmQXu3zHhtMbjm+9fW29c/+Wf0RpHLymiZ+2cbCMVk/50mgzOe3L8X4opDhp1SCFIAJV5h71SmeVh+0XVYhTAwKCuvvIdsU/Kte5H+6ylJVuB3h1VJ/yEwtI0QTrzEVxfGc6jQPGFlQiU84iZNzvqE5YUY9n+bqiF7bXBO0YovDEDDCR6bJRQ72HGVxPDxRdpKJ4mfmZwiR5vBE9MQGwqpEKaUzY71kXHDC83QIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQBJTLusi8f+ljL6u+3amA0QfaxTi0WdavF7L2WFdh6yIJWJ7k/P4P/hEgTVb38qm7iF0Iz2c2A2oGggfmaf6yOFKVHJUddFX2cVGVPqvYzoNo8pHPuzFGmXwhY+1X/7WVv5NEcCkHXPUbQx3GB1EmhNl+YKKBm/1OeO6NGS0XUQDvl+XsSuZF+6TDOjiqNOBAY2LSFfJHCOb0YVmWYOjeJIdQQK9EA8pIDj2f5JtMIXnY/5SlszRfbAabCcm4z55zWzx3QdMOLyiLWra7iim05bkXMpzthaAQ8Gr/9/zyBYckcFUPixkATqHdKXZoQWKfdrWVbOcCZ9S+CHasmGEyhg"
        }
    ]
}');

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('venerable.com', 'https://sts.windows.net/5bc9119f-7f7f-466d-a282-7da42b24ea1c/', '{
    "entityid": "https://sts.windows.net/5bc9119f-7f7f-466d-a282-7da42b24ea1c/",
    "contacts": [],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/5bc9119f-7f7f-466d-a282-7da42b24ea1c/saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://login.microsoftonline.com/5bc9119f-7f7f-466d-a282-7da42b24ea1c/saml2"
        }
    ],
    "SingleLogoutService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/5bc9119f-7f7f-466d-a282-7da42b24ea1c/saml2"
        }
    ],
    "ArtifactResolutionService": [],
    "NameIDFormats": [],
    "keys": [
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQdGhNN7R7UbxHbddek3jVUjANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yNTA0MDcxNjU1MTRaFw0yODA0MDcxNjU1MTRaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxr9xiDqTfTi9jLnWhY6OzqRu+DtzaDGMOykj5l7r2lfrAWOvZsnMD9IbgT7TvL79K5fAKPyZpmjXpnwDg13IryRN1fK9YObKSnIg7vOaiKk+AuaYVJHbbiXDWlKfqsY1TMchgK6JwLvXhzQvFZXzpkh2M+A/4VUMLZN0u7/sOQbgPB9E4EwcPaNgpIsLwOYisf8+GcKT+rYX4cWoQsn6ilNJu8/75f4VKabInDWS2r7DvOCiE7GGOG9LUxj+XToPLQddwhhFgWI/hxI+/MsOsGiIxeJhiNmgK6UtTgZtg/g3GqX83LQktZXtAOGftiqVonKrMiOWZjHvxdWX10tB/QIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQC7s+3ItnR1rejIjFEm2kSSLRq/ExJZQcxvw/6xh7H6OCsCNs8kV3rnoCsxYyp0PlWfRjkK2blMeScxJrnIt6a1ly1wFf3jmIkHOgbhUHnf80N6nIpq5ttMu30Oe2eNgPPym0Fud+Xda09HTL4OZwzzI1gZ4mKJyyAaW6R4P9IziK0zjp44TNxW45D/J2ubImvYtWPsqPkPfv3s9WBkghAhKe9lmht41NplEevdSh8PNk+bUTkaaM8pDBbgRXXiMPMwpW1TnDxXRg2l56c9L2Q0eypJkghowKppSRDogdEKe3UfP10aDuye35VU9RorTZEbZcIpMO7lM6fsauv52l7e"
        }
    ]
}');

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('medallia.com', 'https://exbestdarn-apps-apps.sbx.sea1.medallia.com/sso/apps', '{
    "entityid": "https://exbestdarn-apps-apps.sbx.sea1.medallia.com/sso/apps",
    "contacts": [],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://exbestdarn-apps-apps.sbx.sea1.medallia.com/sso/apps/idpSubmit?AppName=iamtest"
        }
    ],
    "SingleLogoutService": [],
    "ArtifactResolutionService": [],
    "NameIDFormats": [
        ""
    ],
    "keys": [
        {
            "encryption": true,
            "signing": false,
            "type": "X509Certificate",
            "X509Certificate": "MIIHNjCCBR6gAwIBAgIQZqgkp6CnaV/N7nBy/0qiajANBgkqhkiG9w0BAQsFADBpMQswCQYDVQQGEwJVUzEOMAwGA1UECAwFVGV4YXMxEDAOBgNVBAcMB0hvdXN0b24xGDAWBgNVBAoMD1NTTCBDb3Jwb3JhdGlvbjEeMBwGA1UEAwwVU1NMLmNvbSBSU0EgU1NMIHN1YkNBMB4XDTI0MDUzMTIyMTIyMloXDTI1MDcwMTIyMTIyMlowITEfMB0GA1UEAwwWc2FtbC0yMDI0Lm1lZGFsbGlhLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBANqC1zVlJ+q6laJZzYW0/2qkEDreVMJr6f21e7kcXRIU/jQT/2t03Gn2w0dYmThEEy2Je3pg/Ea2zC1DNSj86YhwNqOkxJwZ4WLpPNB4JfFmvNOKIJWbaQqasRfl2AfSldcNn+8nGMXWwrd2AIqbFXIUl9Ka7t51Coy/D8x8O9oiu+ORM+HGCXJyENjGl0o1y/kHsA3uBIFVMpIkrIPhe2nq4Tb+655v7MGTl+stn6Z/mdc0AxV2dNwlsB40XS+tiYo0PoiymGu8yf9yZvW+gmOCZRLZjg4RASUHSM703HauWY3bCVteUcy2vLvm0UmpA2q5j+/VpLvMRnywlnOk+S8CAwEAAaOCAyAwggMcMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUJhR+4NzXpvfi1AQn32HxwuznMsowcgYIKwYBBQUHAQEEZjBkMEAGCCsGAQUFBzAChjRodHRwOi8vY2VydC5zc2wuY29tL1NTTGNvbS1TdWJDQS1TU0wtUlNBLTQwOTYtUjEuY2VyMCAGCCsGAQUFBzABhhRodHRwOi8vb2NzcHMuc3NsLmNvbTA9BgNVHREENjA0ghZzYW1sLTIwMjQubWVkYWxsaWEuY29tghp3d3cuc2FtbC0yMDI0Lm1lZGFsbGlhLmNvbTAjBgNVHSAEHDAaMAgGBmeBDAECATAOBgwrBgEEAYKpMAEDAQEwHQYDVR0lBBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMBMEUGA1UdHwQ+MDwwOqA4oDaGNGh0dHA6Ly9jcmxzLnNzbC5jb20vU1NMY29tLVN1YkNBLVNTTC1SU0EtNDA5Ni1SMS5jcmwwHQYDVR0OBBYEFPLAcIRruUcBIXpNhGaljE9M0QanMA4GA1UdDwEB/wQEAwIFoDCCAXwGCisGAQQB1nkCBAIEggFsBIIBaAFmAHUADeHyMCvTDcFAYhIJ6lUu/Ed0fLHX6TDvDkIetH5OqjQAAAGP0L83mgAABAMARjBEAiBxHk+sKZhykyDsdOS8Ey5lyzWES8fWCmKSTzDCnGmxsAIgLTBdjI3O9Kp+WrqkyC6Sm0ruN/Bc8rEUjxwYE6K5BskAdQB9WR4S4XgqexxhZ3xe/fjQh1wUoE6VnrkDL9kOjC55uAAAAY/QvzeaAAAEAwBGMEQCIEAwuL9+utCt+SKJsdGnQJlZ6jVkR8R47lAO9dGDGSZ2AiA7p9iObpI0hxaiQBnt2rbBhH3I26eeV7vi+ewVm+dVqwB2AN3cyjSV1+EWBeeVMvrHn/g9HFDf2wA6FBJ2Ciysu8gqAAABj9C/N3EAAAQDAEcwRQIgejZ0WVVjnAIrmN2AOVLdQraGl2RaXTgXlP+ZNf5rcrACIQC+XlnwArmsVRYBx+I7tUc2IgbVUQG8Kf3T4DmH0eAyYDANBgkqhkiG9w0BAQsFAAOCAgEAe2l3pn20fXyNfWg3X5ba7cmwreTl+tyvmJAzw/ACwhuY3RN7pQoV/kP05ooTprcEb8uRnu2fh0C5FD8pGc3iS9TH8hUbRqLw0I7Yzpz+uHGRAVR0tzZMGX+MKBEXI/UacP3SFBb4CwDUWhq8r62teApDVY16IqE9svZW5Z5fc2l13MCtDZaznYX8gvWH2yuVrXE72WyJev6OxVsHCAc4ynSsjVnABWK07E7dJN8D+KWne63KWtg7JstyphomjzsZ4N/w5L5U08breROvgItJNKqEOxYHyoXJIl2bHFXiVA5YAhk0Ng9v6jBJPSg3upQMPQiUpvHaUEsCrR+z45cCweOpAhfwcr+xqdzUnYss8LhVvnKtKQ+8zIyHC2y2HNllPV8Z6c6yVGzC9CpH2pwzPf8VqmcNTbXP2Qe+yBdELhQKQ8ZZXVYC3ZwggdVrzIXYybIvYDGj5eYZiUx1FyKgrCD8Wyop/Act/c6aWrlct3JBYu2/k5v/hUNcEEMjN8aorgDB1l+GIo27UvguMaQ/izOQ3+hfWPfUGvST2xbZfiPr7RpDfvFZbSC+U98QXBKOmouxTGqfsMKT3galkWFWkeG61EOoiEJ5ze2RIT3RWzV+hSKqiu98jcoZiob9qpMoJ9hBw5eNy2Bw2H6z4avx7Th+g+fQ7B86Tx3KtYUY2uI="
        },
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIHNjCCBR6gAwIBAgIQZqgkp6CnaV/N7nBy/0qiajANBgkqhkiG9w0BAQsFADBpMQswCQYDVQQGEwJVUzEOMAwGA1UECAwFVGV4YXMxEDAOBgNVBAcMB0hvdXN0b24xGDAWBgNVBAoMD1NTTCBDb3Jwb3JhdGlvbjEeMBwGA1UEAwwVU1NMLmNvbSBSU0EgU1NMIHN1YkNBMB4XDTI0MDUzMTIyMTIyMloXDTI1MDcwMTIyMTIyMlowITEfMB0GA1UEAwwWc2FtbC0yMDI0Lm1lZGFsbGlhLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBANqC1zVlJ+q6laJZzYW0/2qkEDreVMJr6f21e7kcXRIU/jQT/2t03Gn2w0dYmThEEy2Je3pg/Ea2zC1DNSj86YhwNqOkxJwZ4WLpPNB4JfFmvNOKIJWbaQqasRfl2AfSldcNn+8nGMXWwrd2AIqbFXIUl9Ka7t51Coy/D8x8O9oiu+ORM+HGCXJyENjGl0o1y/kHsA3uBIFVMpIkrIPhe2nq4Tb+655v7MGTl+stn6Z/mdc0AxV2dNwlsB40XS+tiYo0PoiymGu8yf9yZvW+gmOCZRLZjg4RASUHSM703HauWY3bCVteUcy2vLvm0UmpA2q5j+/VpLvMRnywlnOk+S8CAwEAAaOCAyAwggMcMAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUJhR+4NzXpvfi1AQn32HxwuznMsowcgYIKwYBBQUHAQEEZjBkMEAGCCsGAQUFBzAChjRodHRwOi8vY2VydC5zc2wuY29tL1NTTGNvbS1TdWJDQS1TU0wtUlNBLTQwOTYtUjEuY2VyMCAGCCsGAQUFBzABhhRodHRwOi8vb2NzcHMuc3NsLmNvbTA9BgNVHREENjA0ghZzYW1sLTIwMjQubWVkYWxsaWEuY29tghp3d3cuc2FtbC0yMDI0Lm1lZGFsbGlhLmNvbTAjBgNVHSAEHDAaMAgGBmeBDAECATAOBgwrBgEEAYKpMAEDAQEwHQYDVR0lBBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMBMEUGA1UdHwQ+MDwwOqA4oDaGNGh0dHA6Ly9jcmxzLnNzbC5jb20vU1NMY29tLVN1YkNBLVNTTC1SU0EtNDA5Ni1SMS5jcmwwHQYDVR0OBBYEFPLAcIRruUcBIXpNhGaljE9M0QanMA4GA1UdDwEB/wQEAwIFoDCCAXwGCisGAQQB1nkCBAIEggFsBIIBaAFmAHUADeHyMCvTDcFAYhIJ6lUu/Ed0fLHX6TDvDkIetH5OqjQAAAGP0L83mgAABAMARjBEAiBxHk+sKZhykyDsdOS8Ey5lyzWES8fWCmKSTzDCnGmxsAIgLTBdjI3O9Kp+WrqkyC6Sm0ruN/Bc8rEUjxwYE6K5BskAdQB9WR4S4XgqexxhZ3xe/fjQh1wUoE6VnrkDL9kOjC55uAAAAY/QvzeaAAAEAwBGMEQCIEAwuL9+utCt+SKJsdGnQJlZ6jVkR8R47lAO9dGDGSZ2AiA7p9iObpI0hxaiQBnt2rbBhH3I26eeV7vi+ewVm+dVqwB2AN3cyjSV1+EWBeeVMvrHn/g9HFDf2wA6FBJ2Ciysu8gqAAABj9C/N3EAAAQDAEcwRQIgejZ0WVVjnAIrmN2AOVLdQraGl2RaXTgXlP+ZNf5rcrACIQC+XlnwArmsVRYBx+I7tUc2IgbVUQG8Kf3T4DmH0eAyYDANBgkqhkiG9w0BAQsFAAOCAgEAe2l3pn20fXyNfWg3X5ba7cmwreTl+tyvmJAzw/ACwhuY3RN7pQoV/kP05ooTprcEb8uRnu2fh0C5FD8pGc3iS9TH8hUbRqLw0I7Yzpz+uHGRAVR0tzZMGX+MKBEXI/UacP3SFBb4CwDUWhq8r62teApDVY16IqE9svZW5Z5fc2l13MCtDZaznYX8gvWH2yuVrXE72WyJev6OxVsHCAc4ynSsjVnABWK07E7dJN8D+KWne63KWtg7JstyphomjzsZ4N/w5L5U08breROvgItJNKqEOxYHyoXJIl2bHFXiVA5YAhk0Ng9v6jBJPSg3upQMPQiUpvHaUEsCrR+z45cCweOpAhfwcr+xqdzUnYss8LhVvnKtKQ+8zIyHC2y2HNllPV8Z6c6yVGzC9CpH2pwzPf8VqmcNTbXP2Qe+yBdELhQKQ8ZZXVYC3ZwggdVrzIXYybIvYDGj5eYZiUx1FyKgrCD8Wyop/Act/c6aWrlct3JBYu2/k5v/hUNcEEMjN8aorgDB1l+GIo27UvguMaQ/izOQ3+hfWPfUGvST2xbZfiPr7RpDfvFZbSC+U98QXBKOmouxTGqfsMKT3galkWFWkeG61EOoiEJ5ze2RIT3RWzV+hSKqiu98jcoZiob9qpMoJ9hBw5eNy2Bw2H6z4avx7Th+g+fQ7B86Tx3KtYUY2uI="
        }
    ]
}');

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('akamai.com', 'https://sso.akamai.com/saml2/idp', '{
    "entityid": "https://sso.akamai.com/saml2/idp",
    "contacts": [
        {
            "contactType": "administrative",
            "company": "Akamai Technologies Inc.,",
            "givenName": "Corp",
            "surName": "SSO Admins",
            "emailAddress": [
                "dl-idp-admins@akamai.com"
            ]
        }
    ],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://sso.akamai.com/idp/SSO.saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://sso.akamai.com/idp/SSO.saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Artifact",
            "Location": "https://sso.akamai.com/idp/SSO.saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:SOAP",
            "Location": "https://sso.akamai.com/idp/SSO.saml2"
        }
    ],
    "SingleLogoutService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://sso.akamai.com/idp/SLO.saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://sso.akamai.com/idp/SLO.saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Artifact",
            "Location": "https://sso.akamai.com/idp/SLO.saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:SOAP",
            "Location": "https://sso.akamai.com/idp/SLO.ssaml2"
        }
    ],
    "ArtifactResolutionService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:SOAP",
            "Location": "https://sso.akamai.com/idp/ARS.ssaml2",
            "index": 0,
            "isDefault": true
        }
    ],
    "NameIDFormats": [],
    "keys": [
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIDcjCCAlqgAwIBAgIGAZKsnEqXMA0GCSqGSIb3DQEBCwUAMHoxCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJNQTESMBAGA1UEBxMJQ2FtYnJpZGdlMSIwIAYDVQQKExlBa2FtYWkgVGVjaG5vbG9naWVzIEluYy4sMQwwCgYDVQQLEwNFSVMxGDAWBgNVBAMTD0FrYW1haS1TU08tU2FhUzAeFw0yNDEwMjEwMTA2MTZaFw0yNjEwMjEwMTA2MTZaMHoxCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJNQTESMBAGA1UEBxMJQ2FtYnJpZGdlMSIwIAYDVQQKExlBa2FtYWkgVGVjaG5vbG9naWVzIEluYy4sMQwwCgYDVQQLEwNFSVMxGDAWBgNVBAMTD0FrYW1haS1TU08tU2FhUzCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAJxyiNgjnSDKs9vxQAhsW72lA0ZIt2W0AI1nTvP/NtWDPzZ3HN4T7TM52nSDxu9OtjKQVN6XRIVsblAd6vgznfglWDUoJvGMkiCgbfg8DgPkjF0cj/spE1v7kqEha2vShXho3ACWRQTq+1GW24/g0c4iHhIQvG2gc/RjVtpuFHuU9bGaalsSIATY0BRDwagZCm+Ysszu4ifUDSwF55z11N40NS3pyR/Pvw3NwgrxsCxuStxLZXR0ncH4nXd5IAlExxGV7IvkdNgrS6yXMJYk2We0CbX2OUmys0GT3U/I+EwmOG9Er9C7zM91u7M3qV2m/U9FElhZq4LxYLJq/PBxaF8CAwEAATANBgkqhkiG9w0BAQsFAAOCAQEAhlsb7/czmura8jqs97T9gf1bGZJAJoDqS4eTrYhaAYz2789WTSE7DTMN4G+T/UKelSweQ4rzavJztRnOfYYdBDqDbGmCG8fw5NfIo21/aCn6l+vJXzDybFCMPJuITBD98prJ5zoQk+ZJPNsJL2ZdS6TGH2XMWVVlXu1YWKaik/HY7jroeXc7ukX7osPrJFaxV3XPNBFgpQbrmZMON00WWU++GVEnPECGgrHDwoLcvLpIxj5zBJdvMs62HfBr05tzbjfpesMciDKffHbBMmCR59MvWwiUeoikQCk180uNX8JlFbQwMALY4ACd3yxjcT+PVKMvA/MzxvTNTOWT66DNFA=="
        }
    ]
}');

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('vizientinc.com','http://www.okta.com/exk21as5z4fdTDK2F0h8', '{
    "entityid": "http://www.okta.com/exk21as5z4fdTDK2F0h8",
    "contacts": [],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://vizientinc.okta.com/app/vizientinc_spectiv_1/exk21as5z4fdTDK2F0h8/sso/saml"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://vizientinc.okta.com/app/vizientinc_spectiv_1/exk21as5z4fdTDK2F0h8/sso/saml"
        }
    ],
    "SingleLogoutService": [],
    "ArtifactResolutionService": [],
    "NameIDFormats": [
        "urn:oasis:names:tc:SAML:1.1:nameid-format:unspecified",
        "urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress"
    ],
    "keys": [
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIDpDCCAoygAwIBAgIGAZUazEPTMA0GCSqGSIb3DQEBCwUAMIGSMQswCQYDVQQGEwJVUzETMBEGA1UECAwKQ2FsaWZvcm5pYTEWMBQGA1UEBwwNU2FuIEZyYW5jaXNjbzENMAsGA1UECgwET2t0YTEUMBIGA1UECwwLU1NPUHJvdmlkZXIxEzARBgNVBAMMCnZpemllbnRpbmMxHDAaBgkqhkiG9w0BCQEWDWluZm9Ab2t0YS5jb20wHhcNMjUwMjE4MjA0MTI5WhcNMzUwMjE4MjA0MjI5WjCBkjELMAkGA1UEBhMCVVMxEzARBgNVBAgMCkNhbGlmb3JuaWExFjAUBgNVBAcMDVNhbiBGcmFuY2lzY28xDTALBgNVBAoMBE9rdGExFDASBgNVBAsMC1NTT1Byb3ZpZGVyMRMwEQYDVQQDDAp2aXppZW50aW5jMRwwGgYJKoZIhvcNAQkBFg1pbmZvQG9rdGEuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkGPpUA+VmAaMi6TJtfK7atZ01PXsZxtT+aZ/ofrPTHdSj66XyX3qFxefs+V9CwkqNtB55qgkwwKkswf+Dv2wNRqettVfHmnWWXoUFpjgfigZBB99zd4BShZdDhL/dhTd8EAC3lnt7nNSuj0nD8L2PrzoC1JiuB6AweBMMJm5GvaOi5Ysc9CA82SHwUS0gNrSU1VQ4MoTaeLGGuh0gnBXNa2xrPYa57Ip4mgu6kDJHvbL0iJGWdBs9d+A3dtOXkRsl1SYR9ipDimmLybSFUcfPQ7A+ITlrbSf4T1I2WW5XrqX0Z/WXb7RJ0d1W1I2NQEtb+PuoFVW3MnFRx9IU51MiwIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQBg7FI2YSSO18AxASpmBL0bpp7sFL6UZVxqOiphABZfR8qGtlB4WF0csHn6yLgaB4O92gLaY8FCydlNNa0ph+aWkoybNcqMATGRCd0uPXnN+53wsxtXGRoLUvNKbRYaBvVLvqn7f8al3HoNhpr2WD+G8R/xHLo2aj2Fnsn5jvHtciI73gmEfJdcpwiTQ1xwe+s2OJsAvvfPHfeiaZnQivePit4n2bAIFO+WZzW0bgDgy0r642FlAwK9cZ8d68DERcg6D2KkgV+/Jgty2gVA2VO7VqvymcjTx1bXp7jY7oSs+KgD/GUshvRAEJLR5SIVp9ZHqS+xq8ubBzOnhC+nO4wu"
        }
    ]
}');

INSERT INTO auth.metadata(name, idp, metadata) VALUES ('beazley.com','https://sts.windows.net/9a50eba8-7568-447a-bcb9-27a0d464aa80/', '{
    "entityid": "https://sts.windows.net/9a50eba8-7568-447a-bcb9-27a0d464aa80/",
    "contacts": [],
    "metadata-set": "saml20-idp-remote",
    "SingleSignOnService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/9a50eba8-7568-447a-bcb9-27a0d464aa80/saml2"
        },
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST",
            "Location": "https://login.microsoftonline.com/9a50eba8-7568-447a-bcb9-27a0d464aa80/saml2"
        }
    ],
    "SingleLogoutService": [
        {
            "Binding": "urn:oasis:names:tc:SAML:2.0:bindings:HTTP-Redirect",
            "Location": "https://login.microsoftonline.com/9a50eba8-7568-447a-bcb9-27a0d464aa80/saml2"
        }
    ],
    "ArtifactResolutionService": [],
    "NameIDFormats": [],
    "keys": [
        {
            "encryption": false,
            "signing": true,
            "type": "X509Certificate",
            "X509Certificate": "MIIC8DCCAdigAwIBAgIQLGw6aFIcsrdC2oqBLDHNiTANBgkqhkiG9w0BAQsFADA0MTIwMAYDVQQDEylNaWNyb3NvZnQgQXp1cmUgRmVkZXJhdGVkIFNTTyBDZXJ0aWZpY2F0ZTAeFw0yNTA1MjMxNTE2MzJaFw0yODA1MjMxNTE2MzJaMDQxMjAwBgNVBAMTKU1pY3Jvc29mdCBBenVyZSBGZWRlcmF0ZWQgU1NPIENlcnRpZmljYXRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0UKOf8LyntHSGUsGie7QHHrpgzcrYiq2bqsz4wrj729rSpcbIa2bZ3BErpWtGOnn0q4BU8fqSI7U6jnC4oVzTKldTHPAkyRdj7pY/MeH7WaTTbNSmadhJsygGnFWjduHsbTBhsFSzbCcDJnLm6Niu7fJvXNNePuF3orMTd9n6u95V6E0aSOPYliNq2xnc/YzbkzRWXkpaDDCqns3vTUbjt/jf1wQX7xPP7WO9ukJQDMDSsEzqzLxgOktkOoFwRtVZXBp3xeA2kR8QTGpxk6P2VcrVqc1YSyMuo45MKm/KYKOkoO/W5Gmy/9XvdwV/6Yhx7fxlQksxAm6n3rAqUBqWQIDAQABMA0GCSqGSIb3DQEBCwUAA4IBAQDHQScZ1U5ijvQquAa5nqsOziaYew8GPUwTzQ57Xz+MVjmPULOkR6yp6FsUZojNaolmVJ+fPodMh1mRoAL8sHkZfwoC8wdblxUa8AHtwfm41c1/OaytADEQcdgxDUBGKtJlyzoSkSBQY7bJNgwUH5MsaZCUgis66nsEavXD4Hmr9JjMNKM5unsicqyNLaMXALKuWJtjt7ELxJ1sx/Hy2rKWosjxJFlkQNYCg51dC+C0MpY0I7/lO9+bz+vZLlP0CGPRO4TgLn+FKDy+l/KQzR6DvUx6ws6Niol4KvcwL5ex01Zb9TPx2MIsU5OjT7qkfIeojm2IvGcvZMEnTL33FGwi"
        }
    ]
}');
