From fe47bbacb1547c42f03778a9dd42e82bf4bc15e0 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Mon, 9 Oct 2017 22:22:49 +0100 Subject: [PATCH] Import latest database layout changes Signed-off-by: Michael Tremer --- src/database.sql | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) diff --git a/src/database.sql b/src/database.sql index a31dd47..5ea33a8 100644 --- a/src/database.sql +++ b/src/database.sql @@ -1616,8 +1616,8 @@ CREATE TABLE repositories ( distro_id integer NOT NULL, parent_id integer, key_id integer, - mirrored repositories_mirrored DEFAULT 'N'::repositories_mirrored NOT NULL, - enabled_for_builds repositories_enabled_for_builds DEFAULT 'N'::repositories_enabled_for_builds NOT NULL, + mirrored boolean DEFAULT false NOT NULL, + enabled_for_builds boolean DEFAULT false NOT NULL, score_needed integer DEFAULT 0 NOT NULL, last_update timestamp without time zone, time_min integer DEFAULT 0 NOT NULL, @@ -2930,6 +2930,13 @@ CREATE INDEX mirrors_checks_sort ON mirrors_checks USING btree (mirror_id, "time ALTER TABLE mirrors_checks CLUSTER ON mirrors_checks_sort; +-- +-- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: +-- + +CREATE INDEX repositories_builds_repo_id ON repositories_builds USING btree (repo_id); + + -- -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire -- -- 2.39.2