diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2017-05-01 18:51:20 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2017-05-01 18:51:20 +0100 |
| commit | f2f1efaf7bdec53a6b584d89d9c44e1a32a5b7f7 (patch) | |
| tree | 5866d56af9397fc57537a5f9c1f61d8b03dd98d2 | |
| parent | Remove no-longer required vcsMode flag (diff) | |
| download | gentoobrowse-api-f2f1efaf7bdec53a6b584d89d9c44e1a32a5b7f7.tar.bz2 gentoobrowse-api-f2f1efaf7bdec53a6b584d89d9c44e1a32a5b7f7.tar.xz gentoobrowse-api-f2f1efaf7bdec53a6b584d89d9c44e1a32a5b7f7.zip | |
Remove SQL files for old tree compare logic
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) |