X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fwanna-build.sql;h=a3c89ee0ac03a32e80f6f9b0a4cb04dad063b16c;hb=9f15f6d282fb3ad92792a94c1b0310ca6958d2cf;hp=f3862fde59266f80d5c00955108081a2dc0700c5;hpb=51ebf1b6945841a470de91e3fac9626fa51e2b43;p=wannabuild.git

diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql
index f3862fd..a3c89ee 100644
--- a/schema/wanna-build.sql
+++ b/schema/wanna-build.sql
@@ -81,6 +81,24 @@ CREATE SCHEMA armel_public;
 
 ALTER SCHEMA armel_public OWNER TO wbadm;
 
+--
+-- Name: armhf; Type: SCHEMA; Schema: -; Owner: wbadm
+--
+
+CREATE SCHEMA armhf;
+
+
+ALTER SCHEMA armhf OWNER TO wbadm;
+
+--
+-- Name: armhf_public; Type: SCHEMA; Schema: -; Owner: wbadm
+--
+
+CREATE SCHEMA armhf_public;
+
+
+ALTER SCHEMA armhf_public OWNER TO wbadm;
+
 --
 -- Name: hppa; Type: SCHEMA; Schema: -; Owner: wbadm
 --
@@ -261,6 +279,24 @@ CREATE SCHEMA s390_public;
 
 ALTER SCHEMA s390_public OWNER TO wbadm;
 
+--
+-- Name: s390x; Type: SCHEMA; Schema: -; Owner: wbadm
+--
+
+CREATE SCHEMA s390x;
+
+
+ALTER SCHEMA s390x OWNER TO wbadm;
+
+--
+-- Name: s390x_public; Type: SCHEMA; Schema: -; Owner: wbadm
+--
+
+CREATE SCHEMA s390x_public;
+
+
+ALTER SCHEMA s390x_public OWNER TO wbadm;
+
 --
 -- Name: sparc; Type: SCHEMA; Schema: -; Owner: wbadm
 --
@@ -926,7 +962,7 @@ SET search_path = alpha, pg_catalog;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'alpha'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'alpha'::text);
 
 
 ALTER TABLE alpha.pkg_history OWNER TO wbadm;
@@ -1029,7 +1065,7 @@ ALTER TABLE alpha_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'alpha'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'alpha'::text));
 
 
 ALTER TABLE alpha_public.pkg_history OWNER TO wbadm;
@@ -1071,7 +1107,7 @@ ALTER TABLE amd64.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'amd64'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'amd64'::text);
 
 
 ALTER TABLE amd64.pkg_history OWNER TO wbadm;
@@ -1113,7 +1149,7 @@ ALTER TABLE amd64_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'amd64'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'amd64'::text));
 
 
 ALTER TABLE amd64_public.pkg_history OWNER TO wbadm;
@@ -1155,7 +1191,7 @@ ALTER TABLE arm.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'arm'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'arm'::text);
 
 
 ALTER TABLE arm.pkg_history OWNER TO wbadm;
@@ -1197,7 +1233,7 @@ ALTER TABLE arm_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'arm'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'arm'::text));
 
 
 ALTER TABLE arm_public.pkg_history OWNER TO wbadm;
@@ -1239,7 +1275,7 @@ ALTER TABLE armel.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'armel'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'armel'::text);
 
 
 ALTER TABLE armel.pkg_history OWNER TO wbadm;
@@ -1281,7 +1317,7 @@ ALTER TABLE armel_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'armel'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'armel'::text));
 
 
 ALTER TABLE armel_public.pkg_history OWNER TO wbadm;
@@ -1306,6 +1342,90 @@ CREATE VIEW users AS
 
 ALTER TABLE armel_public.users OWNER TO wbadm;
 
+SET search_path = armhf, pg_catalog;
+
+--
+-- Name: packages; Type: VIEW; Schema: armhf; Owner: wbadm
+--
+
+CREATE VIEW packages AS
+    SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'armhf'::text);
+
+
+ALTER TABLE armhf.packages OWNER TO wbadm;
+
+--
+-- Name: pkg_history; Type: VIEW; Schema: armhf; Owner: wbadm
+--
+
+CREATE VIEW pkg_history AS
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'armhf'::text);
+
+
+ALTER TABLE armhf.pkg_history OWNER TO wbadm;
+
+--
+-- Name: transactions; Type: VIEW; Schema: armhf; Owner: wbadm
+--
+
+CREATE VIEW transactions AS
+    SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'armhf'::text);
+
+
+ALTER TABLE armhf.transactions OWNER TO wbadm;
+
+--
+-- Name: users; Type: VIEW; Schema: armhf; Owner: wbadm
+--
+
+CREATE VIEW users AS
+    SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'armhf'::text);
+
+
+ALTER TABLE armhf.users OWNER TO wbadm;
+
+SET search_path = armhf_public, pg_catalog;
+
+--
+-- Name: packages; Type: VIEW; Schema: armhf_public; Owner: wbadm
+--
+
+CREATE VIEW packages AS
+    SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'armhf'::text));
+
+
+ALTER TABLE armhf_public.packages OWNER TO wbadm;
+
+--
+-- Name: pkg_history; Type: VIEW; Schema: armhf_public; Owner: wbadm
+--
+
+CREATE VIEW pkg_history AS
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'armhf'::text));
+
+
+ALTER TABLE armhf_public.pkg_history OWNER TO wbadm;
+
+--
+-- Name: transactions; Type: VIEW; Schema: armhf_public; Owner: wbadm
+--
+
+CREATE VIEW transactions AS
+    SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'armhf'::text));
+
+
+ALTER TABLE armhf_public.transactions OWNER TO wbadm;
+
+--
+-- Name: users; Type: VIEW; Schema: armhf_public; Owner: wbadm
+--
+
+CREATE VIEW users AS
+    SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'armhf'::text));
+
+
+ALTER TABLE armhf_public.users OWNER TO wbadm;
+
 SET search_path = hppa, pg_catalog;
 
 --
@@ -1323,7 +1443,7 @@ ALTER TABLE hppa.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'hppa'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'hppa'::text);
 
 
 ALTER TABLE hppa.pkg_history OWNER TO wbadm;
@@ -1365,7 +1485,7 @@ ALTER TABLE hppa_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'hppa'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'hppa'::text));
 
 
 ALTER TABLE hppa_public.pkg_history OWNER TO wbadm;
@@ -1407,7 +1527,7 @@ ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'hurd-i386'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'hurd-i386'::text);
 
 
 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
@@ -1449,7 +1569,7 @@ ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'hurd-i386'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'hurd-i386'::text));
 
 
 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
@@ -1491,7 +1611,7 @@ ALTER TABLE i386.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'i386'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'i386'::text);
 
 
 ALTER TABLE i386.pkg_history OWNER TO wbadm;
@@ -1533,7 +1653,7 @@ ALTER TABLE i386_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'i386'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'i386'::text));
 
 
 ALTER TABLE i386_public.pkg_history OWNER TO wbadm;
@@ -1575,7 +1695,7 @@ ALTER TABLE ia64.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'ia64'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'ia64'::text);
 
 
 ALTER TABLE ia64.pkg_history OWNER TO wbadm;
@@ -1617,7 +1737,7 @@ ALTER TABLE ia64_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'ia64'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'ia64'::text));
 
 
 ALTER TABLE ia64_public.pkg_history OWNER TO wbadm;
@@ -1659,7 +1779,7 @@ ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'kfreebsd-amd64'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'kfreebsd-amd64'::text);
 
 
 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
@@ -1701,7 +1821,7 @@ ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'kfreebsd-amd64'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'kfreebsd-amd64'::text));
 
 
 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
@@ -1743,7 +1863,7 @@ ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'kfreebsd-i386'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'kfreebsd-i386'::text);
 
 
 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
@@ -1785,7 +1905,7 @@ ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'kfreebsd-i386'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'kfreebsd-i386'::text));
 
 
 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
@@ -1827,7 +1947,7 @@ ALTER TABLE mips.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'mips'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'mips'::text);
 
 
 ALTER TABLE mips.pkg_history OWNER TO wbadm;
@@ -1869,7 +1989,7 @@ ALTER TABLE mips_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'mips'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'mips'::text));
 
 
 ALTER TABLE mips_public.pkg_history OWNER TO wbadm;
@@ -1911,7 +2031,7 @@ ALTER TABLE mipsel.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'mipsel'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'mipsel'::text);
 
 
 ALTER TABLE mipsel.pkg_history OWNER TO wbadm;
@@ -1953,7 +2073,7 @@ ALTER TABLE mipsel_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'mipsel'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'mipsel'::text));
 
 
 ALTER TABLE mipsel_public.pkg_history OWNER TO wbadm;
@@ -1995,7 +2115,7 @@ ALTER TABLE powerpc.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'powerpc'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'powerpc'::text);
 
 
 ALTER TABLE powerpc.pkg_history OWNER TO wbadm;
@@ -2037,7 +2157,7 @@ ALTER TABLE powerpc_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'powerpc'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'powerpc'::text));
 
 
 ALTER TABLE powerpc_public.pkg_history OWNER TO wbadm;
@@ -2119,6 +2239,18 @@ CREATE VIEW lastlog AS
 
 ALTER TABLE public.lastlog OWNER TO wbadm;
 
+--
+-- Name: locks; Type: TABLE; Schema: public; Owner: wbadm; Tablespace: 
+--
+
+CREATE TABLE locks (
+    distribution character varying,
+    architecture character varying
+);
+
+
+ALTER TABLE public.locks OWNER TO wbadm;
+
 --
 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
 --
@@ -2149,6 +2281,19 @@ CREATE VIEW packages_public AS
 
 ALTER TABLE public.packages_public OWNER TO wbadm;
 
+--
+-- Name: priorities; Type: TABLE; Schema: public; Owner: wbadm; Tablespace: 
+--
+
+CREATE TABLE priorities (
+    type character varying NOT NULL,
+    value character varying NOT NULL,
+    priority integer DEFAULT 0 NOT NULL
+);
+
+
+ALTER TABLE public.priorities OWNER TO wbadm;
+
 SET search_path = s390, pg_catalog;
 
 --
@@ -2166,7 +2311,7 @@ ALTER TABLE s390.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 's390'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 's390'::text);
 
 
 ALTER TABLE s390.pkg_history OWNER TO wbadm;
@@ -2208,7 +2353,7 @@ ALTER TABLE s390_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 's390'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 's390'::text));
 
 
 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
@@ -2233,6 +2378,90 @@ CREATE VIEW users AS
 
 ALTER TABLE s390_public.users OWNER TO wbadm;
 
+SET search_path = s390x, pg_catalog;
+
+--
+-- Name: packages; Type: VIEW; Schema: s390x; Owner: wbadm
+--
+
+CREATE VIEW packages AS
+    SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 's390x'::text);
+
+
+ALTER TABLE s390x.packages OWNER TO wbadm;
+
+--
+-- Name: pkg_history; Type: VIEW; Schema: s390x; Owner: wbadm
+--
+
+CREATE VIEW pkg_history AS
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 's390x'::text);
+
+
+ALTER TABLE s390x.pkg_history OWNER TO wbadm;
+
+--
+-- Name: transactions; Type: VIEW; Schema: s390x; Owner: wbadm
+--
+
+CREATE VIEW transactions AS
+    SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 's390x'::text);
+
+
+ALTER TABLE s390x.transactions OWNER TO wbadm;
+
+--
+-- Name: users; Type: VIEW; Schema: s390x; Owner: wbadm
+--
+
+CREATE VIEW users AS
+    SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390x'::text);
+
+
+ALTER TABLE s390x.users OWNER TO wbadm;
+
+SET search_path = s390x_public, pg_catalog;
+
+--
+-- Name: packages; Type: VIEW; Schema: s390x_public; Owner: wbadm
+--
+
+CREATE VIEW packages AS
+    SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 's390x'::text));
+
+
+ALTER TABLE s390x_public.packages OWNER TO wbadm;
+
+--
+-- Name: pkg_history; Type: VIEW; Schema: s390x_public; Owner: wbadm
+--
+
+CREATE VIEW pkg_history AS
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 's390x'::text));
+
+
+ALTER TABLE s390x_public.pkg_history OWNER TO wbadm;
+
+--
+-- Name: transactions; Type: VIEW; Schema: s390x_public; Owner: wbadm
+--
+
+CREATE VIEW transactions AS
+    SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 's390x'::text));
+
+
+ALTER TABLE s390x_public.transactions OWNER TO wbadm;
+
+--
+-- Name: users; Type: VIEW; Schema: s390x_public; Owner: wbadm
+--
+
+CREATE VIEW users AS
+    SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 's390x'::text));
+
+
+ALTER TABLE s390x_public.users OWNER TO wbadm;
+
 SET search_path = sparc, pg_catalog;
 
 --
@@ -2250,7 +2479,7 @@ ALTER TABLE sparc.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'sparc'::text);
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'sparc'::text);
 
 
 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
@@ -2292,7 +2521,7 @@ ALTER TABLE sparc_public.packages OWNER TO wbadm;
 --
 
 CREATE VIEW pkg_history AS
-    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'sparc'::text));
+    SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'sparc'::text));
 
 
 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
@@ -2359,6 +2588,14 @@ ALTER TABLE ONLY pkg_history
     ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (architecture, package, distribution, version, "timestamp");
 
 
+--
+-- Name: priorities_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace: 
+--
+
+ALTER TABLE ONLY priorities
+    ADD CONSTRAINT priorities_pkey PRIMARY KEY (type, value);
+
+
 --
 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace: 
 --
@@ -2389,10 +2626,10 @@ CREATE INDEX packages_arch_dist_state ON packages USING btree (architecture, dis
 
 
 --
--- Name: packages_distribution_package; Type: INDEX; Schema: public; Owner: wbadm; Tablespace: 
+-- Name: packages_dist_pkg; Type: INDEX; Schema: public; Owner: wbadm; Tablespace: 
 --
 
-CREATE INDEX packages_distribution_package ON packages USING btree (distribution, package);
+CREATE INDEX packages_dist_pkg ON packages USING btree (distribution, package);
 
 
 --
@@ -2436,14 +2673,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: alpha; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('alpha'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('alpha'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: alpha; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'alpha'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'alpha'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -2508,14 +2745,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: amd64; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: amd64; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -2580,14 +2817,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: arm; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('arm'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('arm'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: arm; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'arm'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'arm'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -2652,14 +2889,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: armel; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('armel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('armel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: armel; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'armel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'armel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -2690,6 +2927,78 @@ CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.use
 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'armel'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
 
 
+SET search_path = armhf, pg_catalog;
+
+--
+-- Name: packages_delete; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'armhf'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
+
+
+--
+-- Name: packages_insert; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('armhf'::character varying, new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
+
+
+--
+-- Name: packages_update; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'armhf'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
+
+
+--
+-- Name: pkg_history_delete; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'armhf'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+
+
+--
+-- Name: pkg_history_insert; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('armhf'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+
+
+--
+-- Name: pkg_history_update; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'armhf'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+
+
+--
+-- Name: transactions_insert; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('armhf'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
+
+
+--
+-- Name: users_delete; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'armhf'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
+
+
+--
+-- Name: users_insert; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('armhf'::character varying, new.username, new.distribution, new.last_seen);
+
+
+--
+-- Name: users_update; Type: RULE; Schema: armhf; Owner: wbadm
+--
+
+CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'armhf'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
+
+
 SET search_path = hppa, pg_catalog;
 
 --
@@ -2724,14 +3033,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: hppa; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('hppa'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('hppa'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: hppa; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'hppa'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'hppa'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -2796,14 +3105,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('hurd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('hurd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'hurd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'hurd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -2868,14 +3177,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: i386; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: i386; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -2940,14 +3249,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: ia64; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('ia64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('ia64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: ia64; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'ia64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'ia64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -3012,14 +3321,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('kfreebsd-amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('kfreebsd-amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'kfreebsd-amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'kfreebsd-amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -3084,14 +3393,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('kfreebsd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('kfreebsd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'kfreebsd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'kfreebsd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -3156,14 +3465,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: mips; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('mips'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('mips'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: mips; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'mips'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'mips'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -3228,14 +3537,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: mipsel; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('mipsel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('mipsel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: mipsel; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'mipsel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'mipsel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -3300,14 +3609,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: powerpc; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('powerpc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('powerpc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: powerpc; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'powerpc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'powerpc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -3372,14 +3681,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: s390; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('s390'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('s390'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: s390; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 's390'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 's390'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -3410,6 +3719,78 @@ CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.use
 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 's390'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
 
 
+SET search_path = s390x, pg_catalog;
+
+--
+-- Name: packages_delete; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 's390x'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
+
+
+--
+-- Name: packages_insert; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('s390x'::character varying, new.package, new.distribution, new.version, new.state, new.section, new.priority, new.installed_version, new.previous_state, new.state_change, new.notes, new.builder, new.failed, new.old_failed, new.binary_nmu_version, new.binary_nmu_changelog, new.failed_category, new.permbuildpri, new.buildpri, new.depends, new.rel, new.bd_problem, new.extra_depends, new.extra_conflicts, new.build_arch_all);
+
+
+--
+-- Name: packages_update; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 's390x'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
+
+
+--
+-- Name: pkg_history_delete; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 's390x'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+
+
+--
+-- Name: pkg_history_insert; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('s390x'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+
+
+--
+-- Name: pkg_history_update; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 's390x'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+
+
+--
+-- Name: transactions_insert; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('s390x'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
+
+
+--
+-- Name: users_delete; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 's390x'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
+
+
+--
+-- Name: users_insert; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('s390x'::character varying, new.username, new.distribution, new.last_seen);
+
+
+--
+-- Name: users_update; Type: RULE; Schema: s390x; Owner: wbadm
+--
+
+CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 's390x'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
+
+
 SET search_path = sparc, pg_catalog;
 
 --
@@ -3444,14 +3825,14 @@ CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FRO
 -- Name: pkg_history_insert; Type: RULE; Schema: sparc; Owner: wbadm
 --
 
-CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('sparc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
+CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('sparc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
 
 
 --
 -- Name: pkg_history_update; Type: RULE; Schema: sparc; Owner: wbadm
 --
 
-CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = 'sparc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
+CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = 'sparc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
 
 
 --
@@ -3616,6 +3997,27 @@ GRANT USAGE ON SCHEMA armel_public TO armel;
 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
 
 
+--
+-- Name: armhf; Type: ACL; Schema: -; Owner: wbadm
+--
+
+REVOKE ALL ON SCHEMA armhf FROM PUBLIC;
+REVOKE ALL ON SCHEMA armhf FROM wbadm;
+GRANT ALL ON SCHEMA armhf TO wbadm;
+GRANT USAGE ON SCHEMA armhf TO wb_all;
+GRANT USAGE ON SCHEMA armhf TO wb_security;
+
+
+--
+-- Name: armhf_public; Type: ACL; Schema: -; Owner: wbadm
+--
+
+REVOKE ALL ON SCHEMA armhf_public FROM PUBLIC;
+REVOKE ALL ON SCHEMA armhf_public FROM wbadm;
+GRANT ALL ON SCHEMA armhf_public TO wbadm;
+GRANT USAGE ON SCHEMA armhf_public TO PUBLIC;
+
+
 --
 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
 --
@@ -3824,12 +4226,12 @@ GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
 
 
 --
--- Name: public; Type: ACL; Schema: -; Owner: postgres
+-- Name: public; Type: ACL; Schema: -; Owner: wbadm
 --
 
 REVOKE ALL ON SCHEMA public FROM PUBLIC;
-REVOKE ALL ON SCHEMA public FROM postgres;
-GRANT ALL ON SCHEMA public TO postgres;
+REVOKE ALL ON SCHEMA public FROM wbadm;
+GRANT ALL ON SCHEMA public TO wbadm;
 GRANT ALL ON SCHEMA public TO PUBLIC;
 
 
@@ -3856,6 +4258,27 @@ GRANT USAGE ON SCHEMA s390_public TO s390;
 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
 
 
+--
+-- Name: s390x; Type: ACL; Schema: -; Owner: wbadm
+--
+
+REVOKE ALL ON SCHEMA s390x FROM PUBLIC;
+REVOKE ALL ON SCHEMA s390x FROM wbadm;
+GRANT ALL ON SCHEMA s390x TO wbadm;
+GRANT USAGE ON SCHEMA s390x TO wb_all;
+GRANT USAGE ON SCHEMA s390x TO wb_security;
+
+
+--
+-- Name: s390x_public; Type: ACL; Schema: -; Owner: wbadm
+--
+
+REVOKE ALL ON SCHEMA s390x_public FROM PUBLIC;
+REVOKE ALL ON SCHEMA s390x_public FROM wbadm;
+GRANT ALL ON SCHEMA s390x_public TO wbadm;
+GRANT USAGE ON SCHEMA s390x_public TO PUBLIC;
+
+
 --
 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
 --
@@ -4291,6 +4714,94 @@ GRANT ALL ON TABLE users TO wbadm;
 GRANT SELECT ON TABLE users TO PUBLIC;
 
 
+SET search_path = armhf, pg_catalog;
+
+--
+-- Name: packages; Type: ACL; Schema: armhf; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE packages FROM PUBLIC;
+REVOKE ALL ON TABLE packages FROM wbadm;
+GRANT ALL ON TABLE packages TO wbadm;
+GRANT SELECT ON TABLE packages TO wb_security;
+GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
+
+
+--
+-- Name: pkg_history; Type: ACL; Schema: armhf; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
+REVOKE ALL ON TABLE pkg_history FROM wbadm;
+GRANT ALL ON TABLE pkg_history TO wbadm;
+GRANT SELECT ON TABLE pkg_history TO wb_security;
+GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
+
+
+--
+-- Name: transactions; Type: ACL; Schema: armhf; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE transactions FROM PUBLIC;
+REVOKE ALL ON TABLE transactions FROM wbadm;
+GRANT ALL ON TABLE transactions TO wbadm;
+GRANT SELECT ON TABLE transactions TO wb_security;
+GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
+
+
+--
+-- Name: users; Type: ACL; Schema: armhf; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE users FROM PUBLIC;
+REVOKE ALL ON TABLE users FROM wbadm;
+GRANT ALL ON TABLE users TO wbadm;
+GRANT SELECT ON TABLE users TO wb_security;
+GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
+
+
+SET search_path = armhf_public, pg_catalog;
+
+--
+-- Name: packages; Type: ACL; Schema: armhf_public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE packages FROM PUBLIC;
+REVOKE ALL ON TABLE packages FROM wbadm;
+GRANT ALL ON TABLE packages TO wbadm;
+GRANT SELECT ON TABLE packages TO PUBLIC;
+
+
+--
+-- Name: pkg_history; Type: ACL; Schema: armhf_public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
+REVOKE ALL ON TABLE pkg_history FROM wbadm;
+GRANT ALL ON TABLE pkg_history TO wbadm;
+GRANT SELECT ON TABLE pkg_history TO PUBLIC;
+
+
+--
+-- Name: transactions; Type: ACL; Schema: armhf_public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE transactions FROM PUBLIC;
+REVOKE ALL ON TABLE transactions FROM wbadm;
+GRANT ALL ON TABLE transactions TO wbadm;
+GRANT SELECT ON TABLE transactions TO PUBLIC;
+
+
+--
+-- Name: users; Type: ACL; Schema: armhf_public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE users FROM PUBLIC;
+REVOKE ALL ON TABLE users FROM wbadm;
+GRANT ALL ON TABLE users TO wbadm;
+GRANT SELECT ON TABLE users TO PUBLIC;
+
+
 SET search_path = hppa, pg_catalog;
 
 --
@@ -5135,6 +5646,17 @@ GRANT ALL ON TABLE lastlog TO wbadm;
 GRANT SELECT ON TABLE lastlog TO PUBLIC;
 
 
+--
+-- Name: locks; Type: ACL; Schema: public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE locks FROM PUBLIC;
+REVOKE ALL ON TABLE locks FROM wbadm;
+GRANT ALL ON TABLE locks TO wbadm;
+GRANT SELECT ON TABLE locks TO PUBLIC;
+GRANT UPDATE ON TABLE locks TO wb_all;
+
+
 --
 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
 --
@@ -5165,6 +5687,16 @@ GRANT ALL ON TABLE packages_public TO wbadm;
 GRANT SELECT ON TABLE packages_public TO PUBLIC;
 
 
+--
+-- Name: priorities; Type: ACL; Schema: public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE priorities FROM PUBLIC;
+REVOKE ALL ON TABLE priorities FROM wbadm;
+GRANT ALL ON TABLE priorities TO wbadm;
+GRANT SELECT ON TABLE priorities TO PUBLIC;
+
+
 SET search_path = s390, pg_catalog;
 
 --
@@ -5253,6 +5785,94 @@ GRANT ALL ON TABLE users TO wbadm;
 GRANT SELECT ON TABLE users TO PUBLIC;
 
 
+SET search_path = s390x, pg_catalog;
+
+--
+-- Name: packages; Type: ACL; Schema: s390x; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE packages FROM PUBLIC;
+REVOKE ALL ON TABLE packages FROM wbadm;
+GRANT ALL ON TABLE packages TO wbadm;
+GRANT SELECT ON TABLE packages TO wb_security;
+GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
+
+
+--
+-- Name: pkg_history; Type: ACL; Schema: s390x; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
+REVOKE ALL ON TABLE pkg_history FROM wbadm;
+GRANT ALL ON TABLE pkg_history TO wbadm;
+GRANT SELECT ON TABLE pkg_history TO wb_security;
+GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
+
+
+--
+-- Name: transactions; Type: ACL; Schema: s390x; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE transactions FROM PUBLIC;
+REVOKE ALL ON TABLE transactions FROM wbadm;
+GRANT ALL ON TABLE transactions TO wbadm;
+GRANT SELECT ON TABLE transactions TO wb_security;
+GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
+
+
+--
+-- Name: users; Type: ACL; Schema: s390x; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE users FROM PUBLIC;
+REVOKE ALL ON TABLE users FROM wbadm;
+GRANT ALL ON TABLE users TO wbadm;
+GRANT SELECT ON TABLE users TO wb_security;
+GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
+
+
+SET search_path = s390x_public, pg_catalog;
+
+--
+-- Name: packages; Type: ACL; Schema: s390x_public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE packages FROM PUBLIC;
+REVOKE ALL ON TABLE packages FROM wbadm;
+GRANT ALL ON TABLE packages TO wbadm;
+GRANT SELECT ON TABLE packages TO PUBLIC;
+
+
+--
+-- Name: pkg_history; Type: ACL; Schema: s390x_public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
+REVOKE ALL ON TABLE pkg_history FROM wbadm;
+GRANT ALL ON TABLE pkg_history TO wbadm;
+GRANT SELECT ON TABLE pkg_history TO PUBLIC;
+
+
+--
+-- Name: transactions; Type: ACL; Schema: s390x_public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE transactions FROM PUBLIC;
+REVOKE ALL ON TABLE transactions FROM wbadm;
+GRANT ALL ON TABLE transactions TO wbadm;
+GRANT SELECT ON TABLE transactions TO PUBLIC;
+
+
+--
+-- Name: users; Type: ACL; Schema: s390x_public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE users FROM PUBLIC;
+REVOKE ALL ON TABLE users FROM wbadm;
+GRANT ALL ON TABLE users TO wbadm;
+GRANT SELECT ON TABLE users TO PUBLIC;
+
+
 SET search_path = sparc, pg_catalog;
 
 --