Revision 29679
Added by Eri Katsari over 10 years ago
| modules/dnet-openaire-stats/trunk/src/main/resources/eu/dnetlib/data/mapreduce/hbase/statsExport/stats_db_schema.sql | ||
|---|---|---|
| 151 | 151 |
|
| 152 | 152 |
UPDATE "shadow"."project" SET daysforlastpub = |
| 153 | 153 |
(SELECT maxdays FROM "shadow".daysfromend WHERE "shadow".daysfromend.project_results = shadow.project.project_results) |
| 154 |
where "shadow"."project".project_results in (select SELECT "shadow".daysfromend.project_results FROM "shadow".daysfromend );
|
|
| 154 |
where "shadow"."project".project_results in ( SELECT "shadow".daysfromend.project_results FROM "shadow".daysfromend );
|
|
| 155 | 155 |
|
| 156 | 156 |
UPDATE "shadow"."result" SET delayed = 'yes' WHERE result.id IN (SELECT result from shadow.project_results_publication where daysfromend >0); |
| 157 | 157 |
|
Also available in: Unified diff