AddOrgIdToTenants creates a new "org_id" column with an index in the "tenants" table.

AddResourceOwnershipToApplicationTypes adds new column "resource_ownership" into table "application_types".

AddTenantsExternalTenantOrgIdUniqueIndex adds a unique index to the "external tenant" and "org id" columns to avoid a race condition that enabled having multiple rows of data sharing the same "external tenant" or "org id" values.

AddUserIdColumnIntoTables adds into tables "sources", "applications", "authentications" and "application_authentications" a new column "user_id" and creates in each table a foreign key, e.g.

AvailabilityStatusColumnsNotNullConstraintDefaultValue adds a NOT NULL constraint to the "availability_status" columns from all the tables that have it, and it also adds a default value "in_progress" for new insertions.

InitialSchema imports the legacy schema into the current database.

MakeEmptyExternalTenantsOrgIdsNull makes all the empty "external_tenant" and "org_id" values NULL in the database.

Migrate migrates the database schema to the latest version.

RemoveDuplicatedTenantIdsOrgIds fetches all the duplicated tenants, makes sure that they are indeed duplicated, and unifies all the subresources in a single tenant before deleting the duplicated one.

RemoveOldMigrationsTable removes the ActiveRecord migrations table.

RemoveProcessedDuplicatedTenants removes all the tenants that were marked as duplicates after running the migration "RemoveDuplicatedTenantIdsOrgIds" with ID "20220608090500".

RenameForeignKeysIndexes renames the foreign keys and indexes to what Postgres names them by default.

SourceTypesAddCategoryColumn adds a "category" column to the "source_types" table.

TranslateEbsAccountNumbersToOrgIds attempts to translate the current EBS account numbers to "org_id"s.