Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
beta_projects_drop.sql 1.21 KB 59460 over 3 years Alessia Bardi #5976: remove from beta the funders already in ...
fix_org_ids.sql 2.22 KB 59676 over 3 years Alessia Bardi Procedure for #6000
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 9.13 KB 59018 over 3 years Alessia Bardi exclude projects from BETA funders in the view ...
migrate-projects.sql 4.15 KB 59015 over 3 years Alessia Bardi Missing ';' to properly end statements
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 3.77 KB 59186 over 3 years Alessia Bardi Instructions to address the path of multiple fu...
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 647 Bytes 60978 almost 3 years Miriam Baglioni changed the collectedfrom to the one of the dat...
patch.sql 19.6 KB 55762 almost 5 years Claudio Atzori reintegrated branch solr75 -r53774:HEAD
patch_arc_and_ands.sql 2.72 KB 59186 over 3 years Alessia Bardi Instructions to address the path of multiple fu...
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
60978 07/05/2021 02:51 PM Miriam Baglioni

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)

59676 23/10/2020 05:44 PM Alessia Bardi

Procedure for #6000

59460 23/09/2020 06:03 PM Alessia Bardi

#5976: remove from beta the funders already in production

59186 29/07/2020 11:52 AM Alessia Bardi

Instructions to address the path of multiple funding paths: see also #5695

59020 29/06/2020 06:07 PM Alessia Bardi

#5695 : addressing the cleanup of projects with multiple funding paths

59018 29/06/2020 05:52 PM Alessia Bardi

exclude projects from BETA funders in the view used by the IIS in production

59015 29/06/2020 04:55 PM Alessia Bardi

Missing ';' to properly end statements

59013 29/06/2020 04:37 PM Alessia Bardi

fixed table name

59012 29/06/2020 04:29 PM Alessia Bardi

SQL commands to copy projects from beta to prod

59000 26/06/2020 03:00 PM Alessia Bardi

No UNKNOWN funding streams for FP7

View revisions

Also available in: Atom