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 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.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
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

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

#5603: Yugoslavian orgs

View revisions

Also available in: Atom