Revision 59186
Added by Alessia Bardi over 3 years ago
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch-fundingpaths.sql | ||
---|---|---|
64 | 64 |
delete from fundingpaths where id = 'sfi_________::SFI::SFI US Ireland R&D Partnership - Planning Grant'; |
65 | 65 |
select count(distinct project) from project_fundingpath where project like 'sfi%'; |
66 | 66 |
select count(distinct id) from projects where id like 'sfi%'; |
67 |
|
|
68 |
-- WT |
|
69 |
delete from project_fundingpath where project like 'wt%'; |
|
70 |
delete from fundingpaths where id like 'wt%'; |
|
71 |
|
|
72 |
-- SNSF |
|
73 |
delete from project_fundingpath where project like 'snsf%'; |
|
74 |
delete from fundingpaths where id like 'snsf%'; |
|
75 |
|
|
76 |
-- ARC |
|
77 |
delete from project_fundingpath where project like 'arc%'; |
|
78 |
delete from fundingpaths where id like 'arc%'; |
|
79 |
|
|
80 |
-- RCUK |
|
81 |
delete from project_fundingpath where project like 'rcuk%'; |
|
82 |
delete from fundingpaths where id like 'rcuk%'; |
|
83 |
|
|
84 |
|
|
85 |
|
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch_arc_and_ands.sql | ||
---|---|---|
21 | 21 |
|
22 | 22 |
UPDATE apicollections |
23 | 23 |
SET _dnet_resource_identifier_ = api || '@@' || param; |
24 |
|
|
25 |
insert into dsm_organizations(id, legalname, legalshortname, country, dateofcollection, _dnet_resource_identifier_, lastupdate, trust) VALUES ('arc_________::ARC', 'Australian Research Council (ARC)', 'ARC', 'AU', '2018-06-08', 'arc_________::ARC', '2020-07-18', 0.9); |
Also available in: Unified diff
Instructions to address the path of multiple funding paths: see also #5695