diff options
Diffstat (limited to 'gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql')
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql b/gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql new file mode 100644 index 0000000..ae33b65 --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql @@ -0,0 +1,8 @@ +( + SELECT DISTINCT ebuildid, packageid, e.version versionspec, flags, slot, op + FROM gentoobrowse.categories c, gentoobrowse.packages p, tmpEbuildDeps e + WHERE c.categoryid = p.categoryid + AND c.name = e.category + AND p.name = e.package + AND e.runtime = false +) |