Revision 60978
Added by Miriam Baglioni almost 3 years ago
patch-unidentifiedProjects.sql | ||
---|---|---|
1 |
INSERT INTO projects (id, code, title, collectedfrom, provenanceactionclass) VALUES ('wt__________::unidentified', 'unidentified', 'unidentified', 'infrastruct_::openaire', 'sysimport:crosswalk:entityregistry');
|
|
1 |
INSERT INTO projects (id, code, title, collectedfrom, provenanceactionclass) VALUES ('wt__________::unidentified', 'unidentified', 'unidentified', 'openaire____::wellcometrust', 'sysimport:crosswalk:entityregistry');
|
|
2 | 2 |
INSERT INTO project_fundingpath (funding, project) VALUES ('wt__________::WT', 'wt__________::unidentified'); |
3 | 3 |
|
4 |
INSERT INTO projects (id, code, title, collectedfrom, provenanceactionclass) VALUES ('miur________::unidentified', 'unidentified', 'unidentified', 'infrastruct_::openaire', 'sysimport:crosswalk:entityregistry');
|
|
4 |
INSERT INTO projects (id, code, title, collectedfrom, provenanceactionclass) VALUES ('miur________::unidentified', 'unidentified', 'unidentified', 'openaire____::miur', 'sysimport:crosswalk:entityregistry');
|
|
5 | 5 |
INSERT INTO project_fundingpath (funding, project) VALUES ('miur________::MIUR', 'miur________::unidentified'); |
Also available in: Unified diff
changed the collectedfrom to the one of the datasource of the funder instead of openaire (to have the collectedfrom as the id of the openaire datasource made the projects to be associated to openaire)