mirror of
https://github.com/zitadel/zitadel.git
synced 2025-08-11 20:47:32 +00:00
10 lines
214 B
SQL
10 lines
214 B
SQL
DELETE FROM eventstore.fields
|
|
WHERE aggregate_type = 'org'
|
|
AND aggregate_id IN (
|
|
SELECT aggregate_id
|
|
FROM eventstore.events2
|
|
WHERE instance_id = $1
|
|
AND aggregate_type = 'org'
|
|
AND event_type = 'org.removed'
|
|
);
|