Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
increase_size_re3data_fields.sql 474 Bytes 56553 over 4 years Alessia Bardi #4689: changed type for missionstatementurl on ...
incrementalTransformation_migration.xqueries 2.06 KB 52390 almost 6 years Alessia Bardi Updated instructions to migrate to incremental ...
materialised_views.sql 8.73 KB 57353 over 4 years Claudio Atzori added summary, totalcost and fundedamount to th...
migrate_dsm.sql 8.26 KB 53133 over 5 years Claudio Atzori updated materialised view update script. Adjust...
patch-constraints.sql 2.93 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-fct.sql 2.43 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-fundingpaths.sql 1.53 KB 59000 almost 4 years Alessia Bardi No UNKNOWN funding streams for FP7
patch-identities.sql 5.1 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-jsonextrainfo.sql 66 Bytes 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch-projects-summary-amount.sql 411 Bytes 57652 over 4 years Alessia Bardi #4962: patching db for summary and funded amount
patch-unidentifiedProjects.sql 646 Bytes 52973 over 5 years Alessia Bardi SQL INSERTs to add the unidentified project for...
patch.sql 19.6 KB 55762 almost 5 years Claudio Atzori reintegrated branch solr75 -r53774:HEAD
patch_arc_and_ands.sql 2.45 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_canadian_funder.sql 2.58 KB 55762 almost 5 years Claudio Atzori reintegrated branch solr75 -r53774:HEAD
patch_countries_yugoslavia.sql 1.47 KB 58842 almost 4 years Alessia Bardi #5603: Yugoslavian orgs
patch_dsTypes.sql 1.25 KB 55762 almost 5 years Claudio Atzori reintegrated branch solr75 -r53774:HEAD
patch_erc_pubsrepository.sql 1.27 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_funder_countries.sql 103 Bytes 57678 over 4 years Alessia Bardi Query to patch the missing countries for funders.
patch_h2020.sql 3.16 KB 48139 over 6 years Alessia Bardi integrated (hopefully) all required changes fro...
patch_hostedbymap.sql 140 Bytes 49745 over 6 years Alessia Bardi new patch db file for manually added hostedby e...
patch_org_countries.sql 1.04 KB 57810 over 4 years Alessia Bardi Fixing countries for organizations coming from ...
patch_pangaea_doaj.sql 6.92 KB 50489 about 6 years Michele Artini merged branch dsm into trunk
triggers.sql 1.02 KB 53725 over 5 years Alessia Bardi updated to new tables of dsm

Latest revisions

# Date Author Comment
59000 26/06/2020 03:00 PM Alessia Bardi

No UNKNOWN funding streams for FP7

58842 04/06/2020 05:03 PM Alessia Bardi

#5603: Yugoslavian orgs

57810 04/12/2019 03:24 PM Alessia Bardi

Fixing countries for organizations coming from NSF annd not only

57678 25/11/2019 05:25 PM Alessia Bardi

Query to patch the missing countries for funders.

57652 20/11/2019 05:10 PM Alessia Bardi

#4962: patching db for summary and funded amount

57353 11/10/2019 05:38 PM Claudio Atzori

added summary, totalcost and fundedamount to the projects_mv materialized view

57300 08/10/2019 10:21 AM Alessia Bardi

#4967: change for datasources

57268 04/10/2019 02:32 PM Claudio Atzori

removed optional2 and optional2 from project_details table

56553 15/07/2019 04:14 PM Alessia Bardi

#4689: changed type for missionstatementurl on dsm_datasources

55762 28/05/2019 11:26 AM Claudio Atzori

reintegrated branch solr75 -r53774:HEAD

View revisions

Also available in: Atom