Revision 59186
Added by Alessia Bardi over 3 years ago
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 |
|
Also available in: Unified diff
Instructions to address the path of multiple funding paths: see also #5695