Add state to organizations and organization_details tables

Rémy Coutablerequested to merge
594305-add-state-to-organizations-and-organization-details-tables into master

What does this MR do and why?

Adds the database columns required to support organization soft-deletion:

  • organizations.state (smallint NOT NULL DEFAULT 0) with a concurrent index
  • organization_details.deletion_scheduled_at (datetime_with_timezone, nullable)
  • organization_details.state_metadata (jsonb NOT NULL DEFAULT {})

References

Part of Add state to organizations and organization_det... (#594305 - closed).

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Rémy Coutable

Merge request reports