db: Cluster filelists table by package ID

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/database.sql b/src/database.sql
index 01a133106a42b7ef35a7fd12e3471d49c41f2d34..5f7c572b4da32254e20cfa98de5b7e175f11b810 100644 (file)
--- a/src/database.sql
+++ b/src/database.sql
@@ -2637,6 +2637,15 @@ CREATE UNIQUE INDEX distributions_sname ON distributions USING btree (sname) WHE
 CREATE INDEX filelists_name ON filelists USING btree (name);
 
 
+--
+-- Name: filelists_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: 
+--
+
+CREATE INDEX filelists_pkg_id ON filelists USING btree (pkg_id);
+
+ALTER TABLE filelists CLUSTER ON filelists_pkg_id;
+
+
 --
 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: 
 --
@@ -2693,13 +2702,6 @@ CREATE INDEX idx_2198018_build_id ON builds_comments USING btree (build_id);
 CREATE INDEX idx_2198018_user_id ON builds_comments USING btree (user_id);
 
 
---
--- Name: idx_2198052_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: 
---
-
-CREATE INDEX idx_2198052_pkg_id ON filelists USING btree (pkg_id);
-
-
 --
 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: 
 --