mirror of
https://github.com/zitadel/zitadel.git
synced 2024-12-04 23:45:07 +00:00
ccef67cefa
# Which Problems Are Solved When an org is removed, the corresponding fields are not deleted. This creates issues, such as recreating a new org with the same verified domain. # How the Problems Are Solved Remove the search fields by the org aggregate, instead of just setting the removed state. # Additional Changes - Cleanup migration script that removed current stale fields. # Additional Context - Closes https://github.com/zitadel/zitadel/issues/8943 - Related to https://github.com/zitadel/zitadel/pull/8790 --------- Co-authored-by: Silvan <silvan.reusser@gmail.com>
7 lines
123 B
SQL
7 lines
123 B
SQL
DELETE FROM eventstore.fields
|
|
WHERE aggregate_type = 'org'
|
|
AND aggregate_id NOT IN (
|
|
SELECT id
|
|
FROM projections.orgs1
|
|
);
|