-- Align table names to singular (phabricator, bitbucket, etc...) ~> same convention as in the main archive for instance
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;