After swh phabricator lister deployment: Alter swh-lister's phabricator table
ActivePublic
Actions

Authored by ardumont on Jun 18 2019, 7:05 AM.

Tags

Subscribers

None

	-- 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;

ardumont edited the content of this paste. (Show Details)

Migration done.

After swh phabricator lister deployment: Alter swh-lister's phabricator tableActivePublicActions