diff options
| author | Grant Limberg <[email protected]> | 2022-09-28 13:04:08 -0700 |
|---|---|---|
| committer | Grant Limberg <[email protected]> | 2022-09-28 13:04:08 -0700 |
| commit | 638c868a07e32ea6882b36f702c4666914b1d85a (patch) | |
| tree | 9eac4b825141ceba36e2e7de78803387f8dfcfa8 /controller/PostgreSQL.cpp | |
| parent | b9093305189c5fd1b1fec1effc24be20814e7508 (diff) | |
Revert "query update for sso"
This reverts commit 3c343eb7752e81d933a73e526cac534469ac1a38.
Diffstat (limited to 'controller/PostgreSQL.cpp')
| -rw-r--r-- | controller/PostgreSQL.cpp | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/controller/PostgreSQL.cpp b/controller/PostgreSQL.cpp index 47300245..eb4c8c1e 100644 --- a/controller/PostgreSQL.cpp +++ b/controller/PostgreSQL.cpp @@ -547,11 +547,7 @@ void PostgreSQL::initializeNetworks() "ARRAY(SELECT CONCAT(host(address),'/',bits::text,'|',COALESCE(host(via), 'NULL'))FROM ztc_network_route WHERE network_id = n.id) AS routes " "FROM ztc_network n " "LEFT OUTER JOIN ztc_org o " - " ON o.owner_id = n.owner_id " - "LEFT OUTER JOIN ztc_network_oidc_config noc " - " ON noc.network_id = n.id " - "LEFT OUTER JOIN ztc_oidc_config oc " - " ON noc.client_id = oc.client_id AND o.org_id = oc.org_id " + " ON o.owner_id = n.owner_id " "LEFT OUTER JOIN ztc_network_dns d " " ON d.network_id = n.id " "WHERE deleted = false AND controller_id = '%s'", _myAddressStr.c_str()); |