diff options
Diffstat (limited to 'gentoobrowse-api/service/sql/maintenance/gitListCreate.sql')
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/gitListCreate.sql | 10 |
1 files changed, 0 insertions, 10 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql b/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql deleted file mode 100644 index 20ca804..0000000 --- a/gentoobrowse-api/service/sql/maintenance/gitListCreate.sql +++ /dev/null @@ -1,10 +0,0 @@ -CREATE TEMPORARY TABLE filelist AS -SELECT - fl.repoid, - fl.status, - 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 |