diff options
Diffstat (limited to 'gentoobrowse-api/service/sql')
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql | 7 |
1 files changed, 7 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..801c877 --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql @@ -0,0 +1,7 @@ +( + 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 +) |