diff options
Diffstat (limited to 'gentoobrowse-api/service/sql/maintenance/gitListCreate.sql')
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/gitListCreate.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql b/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql new file mode 100644 index 0000000..df9f947 --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql @@ -0,0 +1,11 @@ +CREATE TEMPORARY TABLE filelist AS +SELECT + fl.repoid, + fl.status, + fl.filename, + ft.filetypeid, + ft.updateOrder, + ft.phase, + (STRING_TO_ARRAY(fl.filename, '/')) pathparts +FROM filelistraw fl, gentoobrowse.filetypes ft +WHERE (STRING_TO_ARRAY(fl.filename, '/')) ~ ft.spec |