Revision 29682
Added by Eri Katsari almost 10 years ago
stats_db_schema.sql | ||
---|---|---|
139 | 139 |
--HAS PUBS |
140 | 140 |
UPDATE "shadow"."project" SET haspubs='yes' WHERE project_results in (select project_results from shadow.project_results_publication ); |
141 | 141 |
|
142 |
--COUNT PUBS
|
|
142 |
--COUNT PUBS |
|
143 | 143 |
|
144 | 144 |
|
145 |
UPDATE "shadow"."project" SET numpubs=(SELECT count from shadow.project_pub_count WHERE shadow.project_pub_count.project_results = shadow.project.project_results ); |
|
145 |
UPDATE "shadow"."project" SET numpubs=(SELECT count from shadow.project_pub_count |
|
146 |
WHERE shadow.project_pub_count.project_results = shadow.project.project_results ) |
|
147 |
where "shadow"."project".project_results in ( SELECT "shadow".project_results_publication.project_results FROM shadow.project_results_publication ); |
|
146 | 148 |
|
147 | 149 |
--delayedpubs PUBS |
148 | 150 |
|
149 | 151 |
UPDATE "shadow"."project" SET delayedpubs = ( SELECT count from shadow.daysfromend |
150 |
WHERE shadow.daysfromend.project_results = shadow.project.project_results) where "shadow"."project".project_results in ( SELECT "shadow".project_results_publication.project_results FROM shadow.project_results_publication ); |
|
152 |
WHERE shadow.daysfromend.project_results = shadow.project.project_results) |
|
153 |
where "shadow"."project".project_results in ( SELECT "shadow".project_results_publication.project_results FROM shadow.project_results_publication ); |
|
151 | 154 |
|
152 | 155 |
UPDATE "shadow"."project" SET daysforlastpub = |
153 | 156 |
(SELECT maxdays FROM "shadow".daysfromend WHERE "shadow".daysfromend.project_results = shadow.project.project_results) |
Also available in: Unified diff