Import latest database layout changes

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

diff --git a/src/database.sql b/src/database.sql
index a31dd473140a5f9322b1e99fa2e864164d79628c..5ea33a8d73ca5b9317db6af4136a1aed0ddfe4db 100644 (file)
--- 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
 --