diff options
| -rw-r--r-- | gentoobrowse/console/fileimport.xml | 6 | ||||
| -rw-r--r-- | gentoobrowse/console/packagemetadata.xml | 7 |
2 files changed, 12 insertions, 1 deletions
diff --git a/gentoobrowse/console/fileimport.xml b/gentoobrowse/console/fileimport.xml index 1a422ab..2018361 100644 --- a/gentoobrowse/console/fileimport.xml +++ b/gentoobrowse/console/fileimport.xml @@ -71,6 +71,10 @@ </project2:sqlmerge> <project2:sqltask name="setCachedTime" datasource="postgres"> - <sql>UPDATE files SET cachedat = moddate WHERE cachedat != moddate OR cachedat IS NULL</sql> + <sql> + UPDATE files SET cachedat = moddate + WHERE (cachedat != moddate OR cachedat IS NULL) + AND filetypeid IN (SELECT filetypeid FROM filetypes WHERE content = TRUE) + </sql> </project2:sqltask> </packageimport> diff --git a/gentoobrowse/console/packagemetadata.xml b/gentoobrowse/console/packagemetadata.xml index fdcf870..1f89694 100644 --- a/gentoobrowse/console/packagemetadata.xml +++ b/gentoobrowse/console/packagemetadata.xml @@ -41,4 +41,11 @@ </project2:sqltask> </project2:iterate> </project2:iterate> + <project2:sqltask name="update" datasource="postgres"> + <sql> + UPDATE files SET + cachedat = moddate + WHERE filetypeid = 4 + </sql> + </project2:sqltask> </homepages> |