diff options
Diffstat (limited to 'gentoobrowse-api/service/sql/maintenance')
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/createTempFileListTable.sql | 5 | ||||
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/fileListCreate.sql (renamed from gentoobrowse-api/service/sql/maintenance/fileList.sql) | 5 | ||||
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/fileListCreatePk.sql | 1 | ||||
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/fileListCreateRaw.sql | 4 |
4 files changed, 7 insertions, 8 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/createTempFileListTable.sql b/gentoobrowse-api/service/sql/maintenance/createTempFileListTable.sql deleted file mode 100644 index dd6f33c..0000000 --- a/gentoobrowse-api/service/sql/maintenance/createTempFileListTable.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE TEMPORARY TABLE filelist( - filename TEXT NOT NULL, - filesize INTEGER NOT NULL, - filemtime TIMESTAMP WITHOUT TIME ZONE NOT NULL, - PRIMARY KEY(filename)) diff --git a/gentoobrowse-api/service/sql/maintenance/fileList.sql b/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql index dd1c9da..d8d627c 100644 --- a/gentoobrowse-api/service/sql/maintenance/fileList.sql +++ b/gentoobrowse-api/service/sql/maintenance/fileListCreate.sql @@ -1,4 +1,4 @@ -( +CREATE TEMPORARY TABLE filelist AS SELECT r.repoid, fl.filename, @@ -7,7 +7,6 @@ SELECT (STRING_TO_ARRAY(fl.filename, '/'))[2:100] pathparts, fl.filesize, fl.filemtime moddate -FROM filelist fl, gentoobrowse.repos r, gentoobrowse.filetypes ft +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 new file mode 100644 index 0000000..1e56d8b --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/fileListCreatePk.sql @@ -0,0 +1 @@ +ALTER TABLE filelist ADD CONSTRAINT pk_filelist PRIMARY KEY(filename) diff --git a/gentoobrowse-api/service/sql/maintenance/fileListCreateRaw.sql b/gentoobrowse-api/service/sql/maintenance/fileListCreateRaw.sql new file mode 100644 index 0000000..0fa576a --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/fileListCreateRaw.sql @@ -0,0 +1,4 @@ +CREATE TEMPORARY TABLE filelistraw ( + filename TEXT NOT NULL, + filesize INTEGER NOT NULL, + filemtime TIMESTAMP WITHOUT TIME ZONE NOT NULL) |