diff options
3 files changed, 0 insertions, 17 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql b/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql deleted file mode 100644 index 008b154..0000000 --- a/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql +++ /dev/null @@ -1,12 +0,0 @@ -CREATE TEMPORARY TABLE filelist AS -SELECT - r.repoid, - ft.filetypeid, - ft.updateOrder, - ft.phase, - (STRING_TO_ARRAY(fl.filename, '/'))[2:100] pathparts, - fl.filesize, - fl.filemtime moddate -FROM filelistraw fl, gentoobrowse.repos r, gentoobrowse.filetypes ft -WHERE (STRING_TO_ARRAY(fl.filename, '/'))[1] = r.name -AND (STRING_TO_ARRAY(fl.filename, '/'))[2:100] ~ ft.spec diff --git a/gentoobrowse-api/service/sql/maintenance/fileListCreatePk.sql b/gentoobrowse-api/service/sql/maintenance/fileListCreatePk.sql deleted file mode 100644 index 20985e5..0000000 --- a/gentoobrowse-api/service/sql/maintenance/fileListCreatePk.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE filelist ADD CONSTRAINT pk_filelist PRIMARY KEY(repoid, pathparts) diff --git a/gentoobrowse-api/service/sql/maintenance/fileListCreateRaw.sql b/gentoobrowse-api/service/sql/maintenance/fileListCreateRaw.sql deleted file mode 100644 index 0fa576a..0000000 --- a/gentoobrowse-api/service/sql/maintenance/fileListCreateRaw.sql +++ /dev/null @@ -1,4 +0,0 @@ -CREATE TEMPORARY TABLE filelistraw ( - filename TEXT NOT NULL, - filesize INTEGER NOT NULL, - filemtime TIMESTAMP WITHOUT TIME ZONE NOT NULL) |