X-Git-Url: http://git.ipfire.org/?a=blobdiff_plain;f=src%2Fdatabase.sql;h=5ea33a8d73ca5b9317db6af4136a1aed0ddfe4db;hb=fe47bbacb1547c42f03778a9dd42e82bf4bc15e0;hp=a31dd473140a5f9322b1e99fa2e864164d79628c;hpb=4b92e0a0c238277dee208e66a4a7a322fb4fdb74;p=people%2Fjschlag%2Fpbs.git

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
 --