Change Details

-- Align to singular the name of the phabricator repository table alter table phabricator_repos rename to phabricator_repo; -- Add the missing instance column alter table phabricator_repo add column instance varchar; -- Update the instance value update phabricator_repo set instance='swh'; -- Modify schema appropriately alter table phabricator_repo alter column instance set not null;

-- Align table names to singular (phabricator, bitbucket, etc...) alter table phabricator_repos rename to phabricator_repo; alter table bitbucket_repos rename to bitbucket_repo; alter table github_repos rename to github_repo; -- Add the missing instance column alter table phabricator_repo add column instance varchar; -- Update the instance value update phabricator_repo set instance='swh'; -- Modify schema appropriately alter table phabricator_repo alter column instance set not null;

-- Align to singular the name of the able names to singular (phabricator repository table, bitbucket, etc...) alter table phabricator_repos rename to phabricator_repo; alter table bitbucket_repos rename to bitbucket_repo; alter table github_repos rename to github_repo; -- Add the missing instance column alter table phabricator_repo add column instance varchar; -- Update the instance value update phabricator_repo set instance='swh'; -- Modify schema appropriately alter table phabricator_repo alter column instance set not null;