Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P440
Migrate lister db
Active
Public
Actions
Authored by
ardumont
on Jun 19 2019, 10:34 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
Lister
Subscribers
None
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
;
Event Timeline
ardumont
created this paste.
Jun 19 2019, 10:34 AM
2019-06-19 10:34:54 (UTC+2)
Comment Actions
Related
D1606
ardumont
mentioned this in
D1606: Remove columns 'description' and 'origin_id'.
.
Jun 19 2019, 10:37 AM
2019-06-19 10:37:39 (UTC+2)
vlorentz
updated the paste's language from
autodetect
to
sql
.
Jun 19 2019, 10:41 AM
2019-06-19 10:41:29 (UTC+2)
ardumont
edited the content of this paste.
(Show Details)
Jun 20 2019, 1:29 PM
2019-06-20 13:29:36 (UTC+2)
Log In to Comment