From f2f1efaf7bdec53a6b584d89d9c44e1a32a5b7f7 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Mon, 1 May 2017 18:51:20 +0100 Subject: Remove SQL files for old tree compare logic --- gentoobrowse-api/service/sql/maintenance/fileListCreate.sql | 12 ------------ .../service/sql/maintenance/fileListCreatePk.sql | 1 - .../service/sql/maintenance/fileListCreateRaw.sql | 4 ---- 3 files changed, 17 deletions(-) delete mode 100644 gentoobrowse-api/service/sql/maintenance/fileListCreate.sql delete mode 100644 gentoobrowse-api/service/sql/maintenance/fileListCreatePk.sql delete mode 100644 gentoobrowse-api/service/sql/maintenance/fileListCreateRaw.sql 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) -- cgit v1.2.3