11 lines
188 B
PL/PgSQL
11 lines
188 B
PL/PgSQL
BEGIN;
|
|
|
|
INSERT INTO tenant_oauth_clients (tenant_id, client_id)
|
|
SELECT t.id, c.client_id
|
|
FROM tenants t
|
|
CROSS JOIN oauth_clients c
|
|
ON CONFLICT (tenant_id, client_id) DO NOTHING;
|
|
|
|
COMMIT;
|
|
|