Page MenuHomeSoftware Heritage
Paste P440

Migrate lister db
ActivePublic

Authored by ardumont on Jun 19 2019, 10:34 AM.
alter table gnu_repo drop column origin_id;
alter table gnu_repo drop column description;
alter table phabricator_repo drop column origin_id;
alter table phabricator_repo drop column description;
alter table pypi_repo drop column origin_id;
alter table pypi_repo drop column description;
alter table bitbucket_repo drop column origin_id;
alter table bitbucket_repo drop column description;
-- if we created that table already:
-- alter table cran_repo drop column origin_id;
-- alter table cran_repo drop column description;
alter table github_repo drop column origin_id;
alter table github_repo drop column description cascade;
alter table npm_repo drop column origin_id;
alter table npm_repo drop column description;
alter table gitlab_repo drop column origin_id;
alter table gitlab_repo drop column description;