Add state to organizations and organization_details tables
## What
Add the database columns required to support organization soft-deletion:
- `organizations.state` — `smallint NOT NULL DEFAULT 0` with an index
- `organization_details.deletion_scheduled_at` — `datetime_with_timezone` (nullable)
- `organization_details.state_metadata` — `jsonb NOT NULL DEFAULT {}`
## Implementation plan
See https://gitlab.com/gitlab-org/gitlab/-/merge_requests/230540+s.
issue