2 -- PostgreSQL database dump
5 SET statement_timeout = 0;
6 SET client_encoding = 'SQL_ASCII';
7 SET standard_conforming_strings = off;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
10 SET escape_string_warning = off;
13 -- Name: alpha; Type: SCHEMA; Schema: -; Owner: wbadm
19 ALTER SCHEMA alpha OWNER TO wbadm;
22 -- Name: alpha_public; Type: SCHEMA; Schema: -; Owner: wbadm
25 CREATE SCHEMA alpha_public;
28 ALTER SCHEMA alpha_public OWNER TO wbadm;
31 -- Name: amd64; Type: SCHEMA; Schema: -; Owner: wbadm
37 ALTER SCHEMA amd64 OWNER TO wbadm;
40 -- Name: amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
43 CREATE SCHEMA amd64_public;
46 ALTER SCHEMA amd64_public OWNER TO wbadm;
49 -- Name: arm; Type: SCHEMA; Schema: -; Owner: wbadm
55 ALTER SCHEMA arm OWNER TO wbadm;
58 -- Name: arm_public; Type: SCHEMA; Schema: -; Owner: wbadm
61 CREATE SCHEMA arm_public;
64 ALTER SCHEMA arm_public OWNER TO wbadm;
67 -- Name: armel; Type: SCHEMA; Schema: -; Owner: wbadm
73 ALTER SCHEMA armel OWNER TO wbadm;
76 -- Name: armel_public; Type: SCHEMA; Schema: -; Owner: wbadm
79 CREATE SCHEMA armel_public;
82 ALTER SCHEMA armel_public OWNER TO wbadm;
85 -- Name: armhf; Type: SCHEMA; Schema: -; Owner: wbadm
91 ALTER SCHEMA armhf OWNER TO wbadm;
94 -- Name: armhf_public; Type: SCHEMA; Schema: -; Owner: wbadm
97 CREATE SCHEMA armhf_public;
100 ALTER SCHEMA armhf_public OWNER TO wbadm;
103 -- Name: hppa; Type: SCHEMA; Schema: -; Owner: wbadm
109 ALTER SCHEMA hppa OWNER TO wbadm;
112 -- Name: hppa_public; Type: SCHEMA; Schema: -; Owner: wbadm
115 CREATE SCHEMA hppa_public;
118 ALTER SCHEMA hppa_public OWNER TO wbadm;
121 -- Name: hurd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
124 CREATE SCHEMA "hurd-i386";
127 ALTER SCHEMA "hurd-i386" OWNER TO wbadm;
130 -- Name: hurd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
133 CREATE SCHEMA "hurd-i386_public";
136 ALTER SCHEMA "hurd-i386_public" OWNER TO wbadm;
139 -- Name: i386; Type: SCHEMA; Schema: -; Owner: wbadm
145 ALTER SCHEMA i386 OWNER TO wbadm;
148 -- Name: i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
151 CREATE SCHEMA i386_public;
154 ALTER SCHEMA i386_public OWNER TO wbadm;
157 -- Name: ia64; Type: SCHEMA; Schema: -; Owner: wbadm
163 ALTER SCHEMA ia64 OWNER TO wbadm;
166 -- Name: ia64_public; Type: SCHEMA; Schema: -; Owner: wbadm
169 CREATE SCHEMA ia64_public;
172 ALTER SCHEMA ia64_public OWNER TO wbadm;
175 -- Name: kfreebsd-amd64; Type: SCHEMA; Schema: -; Owner: wbadm
178 CREATE SCHEMA "kfreebsd-amd64";
181 ALTER SCHEMA "kfreebsd-amd64" OWNER TO wbadm;
184 -- Name: kfreebsd-amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
187 CREATE SCHEMA "kfreebsd-amd64_public";
190 ALTER SCHEMA "kfreebsd-amd64_public" OWNER TO wbadm;
193 -- Name: kfreebsd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
196 CREATE SCHEMA "kfreebsd-i386";
199 ALTER SCHEMA "kfreebsd-i386" OWNER TO wbadm;
202 -- Name: kfreebsd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
205 CREATE SCHEMA "kfreebsd-i386_public";
208 ALTER SCHEMA "kfreebsd-i386_public" OWNER TO wbadm;
211 -- Name: mips; Type: SCHEMA; Schema: -; Owner: wbadm
217 ALTER SCHEMA mips OWNER TO wbadm;
220 -- Name: mips_public; Type: SCHEMA; Schema: -; Owner: wbadm
223 CREATE SCHEMA mips_public;
226 ALTER SCHEMA mips_public OWNER TO wbadm;
229 -- Name: mipsel; Type: SCHEMA; Schema: -; Owner: wbadm
232 CREATE SCHEMA mipsel;
235 ALTER SCHEMA mipsel OWNER TO wbadm;
238 -- Name: mipsel_public; Type: SCHEMA; Schema: -; Owner: wbadm
241 CREATE SCHEMA mipsel_public;
244 ALTER SCHEMA mipsel_public OWNER TO wbadm;
247 -- Name: powerpc; Type: SCHEMA; Schema: -; Owner: wbadm
250 CREATE SCHEMA powerpc;
253 ALTER SCHEMA powerpc OWNER TO wbadm;
256 -- Name: powerpc_public; Type: SCHEMA; Schema: -; Owner: wbadm
259 CREATE SCHEMA powerpc_public;
262 ALTER SCHEMA powerpc_public OWNER TO wbadm;
265 -- Name: s390; Type: SCHEMA; Schema: -; Owner: wbadm
271 ALTER SCHEMA s390 OWNER TO wbadm;
274 -- Name: s390_public; Type: SCHEMA; Schema: -; Owner: wbadm
277 CREATE SCHEMA s390_public;
280 ALTER SCHEMA s390_public OWNER TO wbadm;
283 -- Name: s390x; Type: SCHEMA; Schema: -; Owner: wbadm
289 ALTER SCHEMA s390x OWNER TO wbadm;
292 -- Name: s390x_public; Type: SCHEMA; Schema: -; Owner: wbadm
295 CREATE SCHEMA s390x_public;
298 ALTER SCHEMA s390x_public OWNER TO wbadm;
301 -- Name: sparc; Type: SCHEMA; Schema: -; Owner: wbadm
307 ALTER SCHEMA sparc OWNER TO wbadm;
310 -- Name: sparc_public; Type: SCHEMA; Schema: -; Owner: wbadm
313 CREATE SCHEMA sparc_public;
316 ALTER SCHEMA sparc_public OWNER TO wbadm;
319 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: wbadm
322 CREATE PROCEDURAL LANGUAGE plpgsql;
325 ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO wbadm;
327 SET search_path = public, pg_catalog;
330 -- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres
333 CREATE TYPE debversion;
337 -- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres
340 CREATE FUNCTION debversionin(cstring) RETURNS debversion
341 LANGUAGE internal IMMUTABLE STRICT
345 ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres;
348 -- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres
351 CREATE FUNCTION debversionout(debversion) RETURNS cstring
352 LANGUAGE internal IMMUTABLE STRICT
356 ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres;
359 -- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres
362 CREATE FUNCTION debversionrecv(internal) RETURNS debversion
363 LANGUAGE internal STABLE STRICT
367 ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres;
370 -- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres
373 CREATE FUNCTION debversionsend(debversion) RETURNS bytea
374 LANGUAGE internal STABLE STRICT
378 ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres;
381 -- Name: debversion; Type: TYPE; Schema: public; Owner: postgres
384 CREATE TYPE debversion (
385 INTERNALLENGTH = variable,
386 INPUT = debversionin,
387 OUTPUT = debversionout,
388 RECEIVE = debversionrecv,
389 SEND = debversionsend,
396 ALTER TYPE public.debversion OWNER TO postgres;
399 -- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres
402 COMMENT ON TYPE debversion IS 'Debian package version number';
406 -- Name: commacat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
409 CREATE FUNCTION commacat(acc text, instr text) RETURNS text
413 IF acc IS NULL OR acc = '' THEN
416 RETURN acc || ', ' || instr;
422 ALTER FUNCTION public.commacat(acc text, instr text) OWNER TO pkern;
425 -- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres
428 CREATE FUNCTION debversion(character) RETURNS debversion
429 LANGUAGE internal IMMUTABLE STRICT
433 ALTER FUNCTION public.debversion(character) OWNER TO postgres;
436 -- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
439 CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer
440 LANGUAGE c IMMUTABLE STRICT
441 AS '$libdir/debversion', 'debversion_cmp';
444 ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres;
447 -- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
450 COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions';
454 -- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
457 CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean
458 LANGUAGE c IMMUTABLE STRICT
459 AS '$libdir/debversion', 'debversion_eq';
462 ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres;
465 -- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
468 COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal';
472 -- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
475 CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean
476 LANGUAGE c IMMUTABLE STRICT
477 AS '$libdir/debversion', 'debversion_ge';
480 ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres;
483 -- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
486 COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal';
490 -- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
493 CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean
494 LANGUAGE c IMMUTABLE STRICT
495 AS '$libdir/debversion', 'debversion_gt';
498 ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres;
501 -- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
504 COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than';
508 -- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres
511 CREATE FUNCTION debversion_hash(debversion) RETURNS integer
512 LANGUAGE c IMMUTABLE STRICT
513 AS '$libdir/debversion', 'debversion_hash';
516 ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres;
519 -- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
522 CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion
523 LANGUAGE c IMMUTABLE STRICT
524 AS '$libdir/debversion', 'debversion_larger';
527 ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres;
530 -- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
533 CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean
534 LANGUAGE c IMMUTABLE STRICT
535 AS '$libdir/debversion', 'debversion_le';
538 ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres;
541 -- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
544 COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal';
548 -- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
551 CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean
552 LANGUAGE c IMMUTABLE STRICT
553 AS '$libdir/debversion', 'debversion_lt';
556 ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres;
559 -- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
562 COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than';
566 -- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
569 CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean
570 LANGUAGE c IMMUTABLE STRICT
571 AS '$libdir/debversion', 'debversion_ne';
574 ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres;
577 -- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
580 COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal';
584 -- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
587 CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion
588 LANGUAGE c IMMUTABLE STRICT
589 AS '$libdir/debversion', 'debversion_smaller';
592 ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres;
595 -- Name: query_source_package(character varying, character varying); Type: FUNCTION; Schema: public; Owner: wbadm
598 CREATE FUNCTION query_source_package(param_dist character varying, param_srcpkg character varying) RETURNS SETOF record
602 RETURN QUERY SELECT packages.architecture, packages.package, packages.distribution, packages.version::character varying, 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 packages_public packages WHERE distribution = param_dist AND package = param_srcpkg;
607 ALTER FUNCTION public.query_source_package(param_dist character varying, param_srcpkg character varying) OWNER TO wbadm;
610 -- Name: spacecat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
613 CREATE FUNCTION spacecat(acc text, instr text) RETURNS text
617 IF acc IS NULL OR acc = '' THEN
620 RETURN acc || ' ' || instr;
626 ALTER FUNCTION public.spacecat(acc text, instr text) OWNER TO pkern;
629 -- Name: commacat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
632 CREATE AGGREGATE commacat_all(text) (
639 ALTER AGGREGATE public.commacat_all(text) OWNER TO pkern;
642 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
646 PROCEDURE = debversion_gt,
647 LEFTARG = debversion,
648 RIGHTARG = debversion,
654 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
657 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
660 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
664 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
667 CREATE AGGREGATE max(debversion) (
668 SFUNC = debversion_larger,
674 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
677 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
681 PROCEDURE = debversion_lt,
682 LEFTARG = debversion,
683 RIGHTARG = debversion,
689 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
692 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
695 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
699 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
702 CREATE AGGREGATE min(debversion) (
703 SFUNC = debversion_smaller,
709 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
712 -- Name: spacecat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
715 CREATE AGGREGATE spacecat_all(text) (
722 ALTER AGGREGATE public.spacecat_all(text) OWNER TO pkern;
725 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
729 PROCEDURE = debversion_le,
730 LEFTARG = debversion,
731 RIGHTARG = debversion,
737 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
740 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
743 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
747 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
751 PROCEDURE = debversion_ne,
752 LEFTARG = debversion,
753 RIGHTARG = debversion,
759 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
762 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
765 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
769 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
773 PROCEDURE = debversion_eq,
774 LEFTARG = debversion,
775 RIGHTARG = debversion,
781 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
784 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
787 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
791 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
795 PROCEDURE = debversion_ge,
796 LEFTARG = debversion,
797 RIGHTARG = debversion,
803 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
806 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
809 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
813 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
816 CREATE OPERATOR CLASS debversion_ops
817 DEFAULT FOR TYPE debversion USING btree AS
818 OPERATOR 1 <(debversion,debversion) ,
819 OPERATOR 2 <=(debversion,debversion) ,
820 OPERATOR 3 =(debversion,debversion) ,
821 OPERATOR 4 >=(debversion,debversion) ,
822 OPERATOR 5 >(debversion,debversion) ,
823 FUNCTION 1 debversion_cmp(debversion,debversion);
826 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
829 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
832 CREATE OPERATOR CLASS debversion_ops
833 DEFAULT FOR TYPE debversion USING hash AS
834 OPERATOR 1 =(debversion,debversion) ,
835 FUNCTION 1 debversion_hash(debversion);
838 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
840 SET search_path = pg_catalog;
843 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
846 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
850 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
853 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
857 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
860 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
864 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
867 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
871 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
874 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
878 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
881 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
884 SET search_path = public, pg_catalog;
886 SET default_tablespace = '';
888 SET default_with_oids = false;
891 -- Name: packages; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
894 CREATE TABLE packages (
895 architecture character varying NOT NULL,
896 package character varying NOT NULL,
897 distribution character varying NOT NULL,
899 state character varying,
900 section character varying,
901 priority character varying,
902 installed_version character varying,
903 previous_state character varying,
904 state_change timestamp without time zone,
905 notes character varying,
906 builder character varying,
909 binary_nmu_version integer,
910 binary_nmu_changelog character varying,
911 failed_category character varying,
912 permbuildpri integer,
914 depends character varying,
915 rel character varying,
917 extra_depends character varying,
918 extra_conflicts character varying,
919 build_arch_all boolean DEFAULT false
923 ALTER TABLE public.packages OWNER TO wbadm;
925 SET search_path = alpha, pg_catalog;
928 -- Name: packages; Type: VIEW; Schema: alpha; Owner: wbadm
931 CREATE VIEW packages AS
932 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 = 'alpha'::text);
935 ALTER TABLE alpha.packages OWNER TO wbadm;
937 SET search_path = public, pg_catalog;
940 -- Name: pkg_history; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
943 CREATE TABLE pkg_history (
944 architecture character varying NOT NULL,
945 package character varying NOT NULL,
946 distribution character varying NOT NULL,
947 version debversion NOT NULL,
948 "timestamp" timestamp without time zone NOT NULL,
949 result character varying NOT NULL,
952 builder character varying
956 ALTER TABLE public.pkg_history OWNER TO wbadm;
958 SET search_path = alpha, pg_catalog;
961 -- Name: pkg_history; Type: VIEW; Schema: alpha; Owner: wbadm
964 CREATE VIEW pkg_history AS
965 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);
968 ALTER TABLE alpha.pkg_history OWNER TO wbadm;
970 SET search_path = public, pg_catalog;
973 -- Name: transactions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
976 CREATE TABLE transactions (
977 architecture character varying,
978 package character varying,
979 distribution character varying,
981 action character varying,
982 prevstate character varying,
983 state character varying,
984 real_user character varying,
985 set_user character varying,
986 "time" timestamp without time zone
990 ALTER TABLE public.transactions OWNER TO wbadm;
992 SET search_path = alpha, pg_catalog;
995 -- Name: transactions; Type: VIEW; Schema: alpha; Owner: wbadm
998 CREATE VIEW transactions AS
999 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 = 'alpha'::text);
1002 ALTER TABLE alpha.transactions OWNER TO wbadm;
1004 SET search_path = public, pg_catalog;
1007 -- Name: users; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
1010 CREATE TABLE users (
1011 architecture character varying NOT NULL,
1012 username character varying NOT NULL,
1013 distribution character varying NOT NULL,
1014 last_seen timestamp without time zone
1018 ALTER TABLE public.users OWNER TO wbadm;
1020 SET search_path = alpha, pg_catalog;
1023 -- Name: users; Type: VIEW; Schema: alpha; Owner: wbadm
1026 CREATE VIEW users AS
1027 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'alpha'::text);
1030 ALTER TABLE alpha.users OWNER TO wbadm;
1032 SET search_path = public, pg_catalog;
1035 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
1038 CREATE TABLE distributions (
1039 distribution character varying NOT NULL,
1040 public boolean DEFAULT true NOT NULL,
1041 sort_order integer DEFAULT 0,
1042 auto_dep_wait boolean DEFAULT true,
1043 build_dep_resolver character varying,
1044 archive character varying,
1045 suppress_successful_logs boolean DEFAULT false NOT NULL
1049 ALTER TABLE public.distributions OWNER TO wbadm;
1051 SET search_path = alpha_public, pg_catalog;
1054 -- Name: packages; Type: VIEW; Schema: alpha_public; Owner: wbadm
1057 CREATE VIEW packages AS
1058 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 = 'alpha'::text));
1061 ALTER TABLE alpha_public.packages OWNER TO wbadm;
1064 -- Name: pkg_history; Type: VIEW; Schema: alpha_public; Owner: wbadm
1067 CREATE VIEW pkg_history AS
1068 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));
1071 ALTER TABLE alpha_public.pkg_history OWNER TO wbadm;
1074 -- Name: transactions; Type: VIEW; Schema: alpha_public; Owner: wbadm
1077 CREATE VIEW transactions AS
1078 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 = 'alpha'::text));
1081 ALTER TABLE alpha_public.transactions OWNER TO wbadm;
1084 -- Name: users; Type: VIEW; Schema: alpha_public; Owner: wbadm
1087 CREATE VIEW users AS
1088 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'alpha'::text));
1091 ALTER TABLE alpha_public.users OWNER TO wbadm;
1093 SET search_path = amd64, pg_catalog;
1096 -- Name: packages; Type: VIEW; Schema: amd64; Owner: wbadm
1099 CREATE VIEW packages AS
1100 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 = 'amd64'::text);
1103 ALTER TABLE amd64.packages OWNER TO wbadm;
1106 -- Name: pkg_history; Type: VIEW; Schema: amd64; Owner: wbadm
1109 CREATE VIEW pkg_history AS
1110 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);
1113 ALTER TABLE amd64.pkg_history OWNER TO wbadm;
1116 -- Name: transactions; Type: VIEW; Schema: amd64; Owner: wbadm
1119 CREATE VIEW transactions AS
1120 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 = 'amd64'::text);
1123 ALTER TABLE amd64.transactions OWNER TO wbadm;
1126 -- Name: users; Type: VIEW; Schema: amd64; Owner: wbadm
1129 CREATE VIEW users AS
1130 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'amd64'::text);
1133 ALTER TABLE amd64.users OWNER TO wbadm;
1135 SET search_path = amd64_public, pg_catalog;
1138 -- Name: packages; Type: VIEW; Schema: amd64_public; Owner: wbadm
1141 CREATE VIEW packages AS
1142 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 = 'amd64'::text));
1145 ALTER TABLE amd64_public.packages OWNER TO wbadm;
1148 -- Name: pkg_history; Type: VIEW; Schema: amd64_public; Owner: wbadm
1151 CREATE VIEW pkg_history AS
1152 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));
1155 ALTER TABLE amd64_public.pkg_history OWNER TO wbadm;
1158 -- Name: transactions; Type: VIEW; Schema: amd64_public; Owner: wbadm
1161 CREATE VIEW transactions AS
1162 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 = 'amd64'::text));
1165 ALTER TABLE amd64_public.transactions OWNER TO wbadm;
1168 -- Name: users; Type: VIEW; Schema: amd64_public; Owner: wbadm
1171 CREATE VIEW users AS
1172 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'amd64'::text));
1175 ALTER TABLE amd64_public.users OWNER TO wbadm;
1177 SET search_path = arm, pg_catalog;
1180 -- Name: packages; Type: VIEW; Schema: arm; Owner: wbadm
1183 CREATE VIEW packages AS
1184 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 = 'arm'::text);
1187 ALTER TABLE arm.packages OWNER TO wbadm;
1190 -- Name: pkg_history; Type: VIEW; Schema: arm; Owner: wbadm
1193 CREATE VIEW pkg_history AS
1194 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);
1197 ALTER TABLE arm.pkg_history OWNER TO wbadm;
1200 -- Name: transactions; Type: VIEW; Schema: arm; Owner: wbadm
1203 CREATE VIEW transactions AS
1204 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 = 'arm'::text);
1207 ALTER TABLE arm.transactions OWNER TO wbadm;
1210 -- Name: users; Type: VIEW; Schema: arm; Owner: wbadm
1213 CREATE VIEW users AS
1214 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'arm'::text);
1217 ALTER TABLE arm.users OWNER TO wbadm;
1219 SET search_path = arm_public, pg_catalog;
1222 -- Name: packages; Type: VIEW; Schema: arm_public; Owner: wbadm
1225 CREATE VIEW packages AS
1226 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 = 'arm'::text));
1229 ALTER TABLE arm_public.packages OWNER TO wbadm;
1232 -- Name: pkg_history; Type: VIEW; Schema: arm_public; Owner: wbadm
1235 CREATE VIEW pkg_history AS
1236 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));
1239 ALTER TABLE arm_public.pkg_history OWNER TO wbadm;
1242 -- Name: transactions; Type: VIEW; Schema: arm_public; Owner: wbadm
1245 CREATE VIEW transactions AS
1246 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 = 'arm'::text));
1249 ALTER TABLE arm_public.transactions OWNER TO wbadm;
1252 -- Name: users; Type: VIEW; Schema: arm_public; Owner: wbadm
1255 CREATE VIEW users AS
1256 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'arm'::text));
1259 ALTER TABLE arm_public.users OWNER TO wbadm;
1261 SET search_path = armel, pg_catalog;
1264 -- Name: packages; Type: VIEW; Schema: armel; Owner: wbadm
1267 CREATE VIEW packages AS
1268 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 = 'armel'::text);
1271 ALTER TABLE armel.packages OWNER TO wbadm;
1274 -- Name: pkg_history; Type: VIEW; Schema: armel; Owner: wbadm
1277 CREATE VIEW pkg_history AS
1278 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);
1281 ALTER TABLE armel.pkg_history OWNER TO wbadm;
1284 -- Name: transactions; Type: VIEW; Schema: armel; Owner: wbadm
1287 CREATE VIEW transactions AS
1288 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 = 'armel'::text);
1291 ALTER TABLE armel.transactions OWNER TO wbadm;
1294 -- Name: users; Type: VIEW; Schema: armel; Owner: wbadm
1297 CREATE VIEW users AS
1298 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'armel'::text);
1301 ALTER TABLE armel.users OWNER TO wbadm;
1303 SET search_path = armel_public, pg_catalog;
1306 -- Name: packages; Type: VIEW; Schema: armel_public; Owner: wbadm
1309 CREATE VIEW packages AS
1310 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 = 'armel'::text));
1313 ALTER TABLE armel_public.packages OWNER TO wbadm;
1316 -- Name: pkg_history; Type: VIEW; Schema: armel_public; Owner: wbadm
1319 CREATE VIEW pkg_history AS
1320 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));
1323 ALTER TABLE armel_public.pkg_history OWNER TO wbadm;
1326 -- Name: transactions; Type: VIEW; Schema: armel_public; Owner: wbadm
1329 CREATE VIEW transactions AS
1330 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 = 'armel'::text));
1333 ALTER TABLE armel_public.transactions OWNER TO wbadm;
1336 -- Name: users; Type: VIEW; Schema: armel_public; Owner: wbadm
1339 CREATE VIEW users AS
1340 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'armel'::text));
1343 ALTER TABLE armel_public.users OWNER TO wbadm;
1345 SET search_path = armhf, pg_catalog;
1348 -- Name: packages; Type: VIEW; Schema: armhf; Owner: wbadm
1351 CREATE VIEW packages AS
1352 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);
1355 ALTER TABLE armhf.packages OWNER TO wbadm;
1358 -- Name: pkg_history; Type: VIEW; Schema: armhf; Owner: wbadm
1361 CREATE VIEW pkg_history AS
1362 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);
1365 ALTER TABLE armhf.pkg_history OWNER TO wbadm;
1368 -- Name: transactions; Type: VIEW; Schema: armhf; Owner: wbadm
1371 CREATE VIEW transactions AS
1372 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);
1375 ALTER TABLE armhf.transactions OWNER TO wbadm;
1378 -- Name: users; Type: VIEW; Schema: armhf; Owner: wbadm
1381 CREATE VIEW users AS
1382 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'armhf'::text);
1385 ALTER TABLE armhf.users OWNER TO wbadm;
1387 SET search_path = armhf_public, pg_catalog;
1390 -- Name: packages; Type: VIEW; Schema: armhf_public; Owner: wbadm
1393 CREATE VIEW packages AS
1394 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));
1397 ALTER TABLE armhf_public.packages OWNER TO wbadm;
1400 -- Name: pkg_history; Type: VIEW; Schema: armhf_public; Owner: wbadm
1403 CREATE VIEW pkg_history AS
1404 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));
1407 ALTER TABLE armhf_public.pkg_history OWNER TO wbadm;
1410 -- Name: transactions; Type: VIEW; Schema: armhf_public; Owner: wbadm
1413 CREATE VIEW transactions AS
1414 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));
1417 ALTER TABLE armhf_public.transactions OWNER TO wbadm;
1420 -- Name: users; Type: VIEW; Schema: armhf_public; Owner: wbadm
1423 CREATE VIEW users AS
1424 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));
1427 ALTER TABLE armhf_public.users OWNER TO wbadm;
1429 SET search_path = hppa, pg_catalog;
1432 -- Name: packages; Type: VIEW; Schema: hppa; Owner: wbadm
1435 CREATE VIEW packages AS
1436 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 = 'hppa'::text);
1439 ALTER TABLE hppa.packages OWNER TO wbadm;
1442 -- Name: pkg_history; Type: VIEW; Schema: hppa; Owner: wbadm
1445 CREATE VIEW pkg_history AS
1446 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);
1449 ALTER TABLE hppa.pkg_history OWNER TO wbadm;
1452 -- Name: transactions; Type: VIEW; Schema: hppa; Owner: wbadm
1455 CREATE VIEW transactions AS
1456 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 = 'hppa'::text);
1459 ALTER TABLE hppa.transactions OWNER TO wbadm;
1462 -- Name: users; Type: VIEW; Schema: hppa; Owner: wbadm
1465 CREATE VIEW users AS
1466 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'hppa'::text);
1469 ALTER TABLE hppa.users OWNER TO wbadm;
1471 SET search_path = hppa_public, pg_catalog;
1474 -- Name: packages; Type: VIEW; Schema: hppa_public; Owner: wbadm
1477 CREATE VIEW packages AS
1478 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 = 'hppa'::text));
1481 ALTER TABLE hppa_public.packages OWNER TO wbadm;
1484 -- Name: pkg_history; Type: VIEW; Schema: hppa_public; Owner: wbadm
1487 CREATE VIEW pkg_history AS
1488 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));
1491 ALTER TABLE hppa_public.pkg_history OWNER TO wbadm;
1494 -- Name: transactions; Type: VIEW; Schema: hppa_public; Owner: wbadm
1497 CREATE VIEW transactions AS
1498 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 = 'hppa'::text));
1501 ALTER TABLE hppa_public.transactions OWNER TO wbadm;
1504 -- Name: users; Type: VIEW; Schema: hppa_public; Owner: wbadm
1507 CREATE VIEW users AS
1508 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'hppa'::text));
1511 ALTER TABLE hppa_public.users OWNER TO wbadm;
1513 SET search_path = "hurd-i386", pg_catalog;
1516 -- Name: packages; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1519 CREATE VIEW packages AS
1520 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 = 'hurd-i386'::text);
1523 ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
1526 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1529 CREATE VIEW pkg_history AS
1530 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);
1533 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
1536 -- Name: transactions; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1539 CREATE VIEW transactions AS
1540 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 = 'hurd-i386'::text);
1543 ALTER TABLE "hurd-i386".transactions OWNER TO wbadm;
1546 -- Name: users; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1549 CREATE VIEW users AS
1550 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'hurd-i386'::text);
1553 ALTER TABLE "hurd-i386".users OWNER TO wbadm;
1555 SET search_path = "hurd-i386_public", pg_catalog;
1558 -- Name: packages; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1561 CREATE VIEW packages AS
1562 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 = 'hurd-i386'::text));
1565 ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
1568 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1571 CREATE VIEW pkg_history AS
1572 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));
1575 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
1578 -- Name: transactions; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1581 CREATE VIEW transactions AS
1582 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 = 'hurd-i386'::text));
1585 ALTER TABLE "hurd-i386_public".transactions OWNER TO wbadm;
1588 -- Name: users; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1591 CREATE VIEW users AS
1592 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'hurd-i386'::text));
1595 ALTER TABLE "hurd-i386_public".users OWNER TO wbadm;
1597 SET search_path = i386, pg_catalog;
1600 -- Name: packages; Type: VIEW; Schema: i386; Owner: wbadm
1603 CREATE VIEW packages AS
1604 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 = 'i386'::text);
1607 ALTER TABLE i386.packages OWNER TO wbadm;
1610 -- Name: pkg_history; Type: VIEW; Schema: i386; Owner: wbadm
1613 CREATE VIEW pkg_history AS
1614 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);
1617 ALTER TABLE i386.pkg_history OWNER TO wbadm;
1620 -- Name: transactions; Type: VIEW; Schema: i386; Owner: wbadm
1623 CREATE VIEW transactions AS
1624 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 = 'i386'::text);
1627 ALTER TABLE i386.transactions OWNER TO wbadm;
1630 -- Name: users; Type: VIEW; Schema: i386; Owner: wbadm
1633 CREATE VIEW users AS
1634 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'i386'::text);
1637 ALTER TABLE i386.users OWNER TO wbadm;
1639 SET search_path = i386_public, pg_catalog;
1642 -- Name: packages; Type: VIEW; Schema: i386_public; Owner: wbadm
1645 CREATE VIEW packages AS
1646 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 = 'i386'::text));
1649 ALTER TABLE i386_public.packages OWNER TO wbadm;
1652 -- Name: pkg_history; Type: VIEW; Schema: i386_public; Owner: wbadm
1655 CREATE VIEW pkg_history AS
1656 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));
1659 ALTER TABLE i386_public.pkg_history OWNER TO wbadm;
1662 -- Name: transactions; Type: VIEW; Schema: i386_public; Owner: wbadm
1665 CREATE VIEW transactions AS
1666 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 = 'i386'::text));
1669 ALTER TABLE i386_public.transactions OWNER TO wbadm;
1672 -- Name: users; Type: VIEW; Schema: i386_public; Owner: wbadm
1675 CREATE VIEW users AS
1676 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'i386'::text));
1679 ALTER TABLE i386_public.users OWNER TO wbadm;
1681 SET search_path = ia64, pg_catalog;
1684 -- Name: packages; Type: VIEW; Schema: ia64; Owner: wbadm
1687 CREATE VIEW packages AS
1688 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 = 'ia64'::text);
1691 ALTER TABLE ia64.packages OWNER TO wbadm;
1694 -- Name: pkg_history; Type: VIEW; Schema: ia64; Owner: wbadm
1697 CREATE VIEW pkg_history AS
1698 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);
1701 ALTER TABLE ia64.pkg_history OWNER TO wbadm;
1704 -- Name: transactions; Type: VIEW; Schema: ia64; Owner: wbadm
1707 CREATE VIEW transactions AS
1708 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 = 'ia64'::text);
1711 ALTER TABLE ia64.transactions OWNER TO wbadm;
1714 -- Name: users; Type: VIEW; Schema: ia64; Owner: wbadm
1717 CREATE VIEW users AS
1718 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'ia64'::text);
1721 ALTER TABLE ia64.users OWNER TO wbadm;
1723 SET search_path = ia64_public, pg_catalog;
1726 -- Name: packages; Type: VIEW; Schema: ia64_public; Owner: wbadm
1729 CREATE VIEW packages AS
1730 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 = 'ia64'::text));
1733 ALTER TABLE ia64_public.packages OWNER TO wbadm;
1736 -- Name: pkg_history; Type: VIEW; Schema: ia64_public; Owner: wbadm
1739 CREATE VIEW pkg_history AS
1740 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));
1743 ALTER TABLE ia64_public.pkg_history OWNER TO wbadm;
1746 -- Name: transactions; Type: VIEW; Schema: ia64_public; Owner: wbadm
1749 CREATE VIEW transactions AS
1750 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 = 'ia64'::text));
1753 ALTER TABLE ia64_public.transactions OWNER TO wbadm;
1756 -- Name: users; Type: VIEW; Schema: ia64_public; Owner: wbadm
1759 CREATE VIEW users AS
1760 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'ia64'::text));
1763 ALTER TABLE ia64_public.users OWNER TO wbadm;
1765 SET search_path = "kfreebsd-amd64", pg_catalog;
1768 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1771 CREATE VIEW packages AS
1772 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 = 'kfreebsd-amd64'::text);
1775 ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
1778 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1781 CREATE VIEW pkg_history AS
1782 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);
1785 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
1788 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1791 CREATE VIEW transactions AS
1792 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 = 'kfreebsd-amd64'::text);
1795 ALTER TABLE "kfreebsd-amd64".transactions OWNER TO wbadm;
1798 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1801 CREATE VIEW users AS
1802 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'kfreebsd-amd64'::text);
1805 ALTER TABLE "kfreebsd-amd64".users OWNER TO wbadm;
1807 SET search_path = "kfreebsd-amd64_public", pg_catalog;
1810 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1813 CREATE VIEW packages AS
1814 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 = 'kfreebsd-amd64'::text));
1817 ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
1820 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1823 CREATE VIEW pkg_history AS
1824 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));
1827 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
1830 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1833 CREATE VIEW transactions AS
1834 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 = 'kfreebsd-amd64'::text));
1837 ALTER TABLE "kfreebsd-amd64_public".transactions OWNER TO wbadm;
1840 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1843 CREATE VIEW users AS
1844 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'kfreebsd-amd64'::text));
1847 ALTER TABLE "kfreebsd-amd64_public".users OWNER TO wbadm;
1849 SET search_path = "kfreebsd-i386", pg_catalog;
1852 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1855 CREATE VIEW packages AS
1856 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 = 'kfreebsd-i386'::text);
1859 ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
1862 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1865 CREATE VIEW pkg_history AS
1866 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);
1869 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
1872 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1875 CREATE VIEW transactions AS
1876 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 = 'kfreebsd-i386'::text);
1879 ALTER TABLE "kfreebsd-i386".transactions OWNER TO wbadm;
1882 -- Name: users; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1885 CREATE VIEW users AS
1886 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'kfreebsd-i386'::text);
1889 ALTER TABLE "kfreebsd-i386".users OWNER TO wbadm;
1891 SET search_path = "kfreebsd-i386_public", pg_catalog;
1894 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1897 CREATE VIEW packages AS
1898 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 = 'kfreebsd-i386'::text));
1901 ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
1904 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1907 CREATE VIEW pkg_history AS
1908 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));
1911 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
1914 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1917 CREATE VIEW transactions AS
1918 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 = 'kfreebsd-i386'::text));
1921 ALTER TABLE "kfreebsd-i386_public".transactions OWNER TO wbadm;
1924 -- Name: users; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1927 CREATE VIEW users AS
1928 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'kfreebsd-i386'::text));
1931 ALTER TABLE "kfreebsd-i386_public".users OWNER TO wbadm;
1933 SET search_path = mips, pg_catalog;
1936 -- Name: packages; Type: VIEW; Schema: mips; Owner: wbadm
1939 CREATE VIEW packages AS
1940 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 = 'mips'::text);
1943 ALTER TABLE mips.packages OWNER TO wbadm;
1946 -- Name: pkg_history; Type: VIEW; Schema: mips; Owner: wbadm
1949 CREATE VIEW pkg_history AS
1950 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);
1953 ALTER TABLE mips.pkg_history OWNER TO wbadm;
1956 -- Name: transactions; Type: VIEW; Schema: mips; Owner: wbadm
1959 CREATE VIEW transactions AS
1960 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 = 'mips'::text);
1963 ALTER TABLE mips.transactions OWNER TO wbadm;
1966 -- Name: users; Type: VIEW; Schema: mips; Owner: wbadm
1969 CREATE VIEW users AS
1970 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'mips'::text);
1973 ALTER TABLE mips.users OWNER TO wbadm;
1975 SET search_path = mips_public, pg_catalog;
1978 -- Name: packages; Type: VIEW; Schema: mips_public; Owner: wbadm
1981 CREATE VIEW packages AS
1982 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 = 'mips'::text));
1985 ALTER TABLE mips_public.packages OWNER TO wbadm;
1988 -- Name: pkg_history; Type: VIEW; Schema: mips_public; Owner: wbadm
1991 CREATE VIEW pkg_history AS
1992 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));
1995 ALTER TABLE mips_public.pkg_history OWNER TO wbadm;
1998 -- Name: transactions; Type: VIEW; Schema: mips_public; Owner: wbadm
2001 CREATE VIEW transactions AS
2002 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 = 'mips'::text));
2005 ALTER TABLE mips_public.transactions OWNER TO wbadm;
2008 -- Name: users; Type: VIEW; Schema: mips_public; Owner: wbadm
2011 CREATE VIEW users AS
2012 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'mips'::text));
2015 ALTER TABLE mips_public.users OWNER TO wbadm;
2017 SET search_path = mipsel, pg_catalog;
2020 -- Name: packages; Type: VIEW; Schema: mipsel; Owner: wbadm
2023 CREATE VIEW packages AS
2024 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 = 'mipsel'::text);
2027 ALTER TABLE mipsel.packages OWNER TO wbadm;
2030 -- Name: pkg_history; Type: VIEW; Schema: mipsel; Owner: wbadm
2033 CREATE VIEW pkg_history AS
2034 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);
2037 ALTER TABLE mipsel.pkg_history OWNER TO wbadm;
2040 -- Name: transactions; Type: VIEW; Schema: mipsel; Owner: wbadm
2043 CREATE VIEW transactions AS
2044 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 = 'mipsel'::text);
2047 ALTER TABLE mipsel.transactions OWNER TO wbadm;
2050 -- Name: users; Type: VIEW; Schema: mipsel; Owner: wbadm
2053 CREATE VIEW users AS
2054 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'mipsel'::text);
2057 ALTER TABLE mipsel.users OWNER TO wbadm;
2059 SET search_path = mipsel_public, pg_catalog;
2062 -- Name: packages; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2065 CREATE VIEW packages AS
2066 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 = 'mipsel'::text));
2069 ALTER TABLE mipsel_public.packages OWNER TO wbadm;
2072 -- Name: pkg_history; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2075 CREATE VIEW pkg_history AS
2076 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));
2079 ALTER TABLE mipsel_public.pkg_history OWNER TO wbadm;
2082 -- Name: transactions; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2085 CREATE VIEW transactions AS
2086 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 = 'mipsel'::text));
2089 ALTER TABLE mipsel_public.transactions OWNER TO wbadm;
2092 -- Name: users; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2095 CREATE VIEW users AS
2096 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'mipsel'::text));
2099 ALTER TABLE mipsel_public.users OWNER TO wbadm;
2101 SET search_path = powerpc, pg_catalog;
2104 -- Name: packages; Type: VIEW; Schema: powerpc; Owner: wbadm
2107 CREATE VIEW packages AS
2108 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 = 'powerpc'::text);
2111 ALTER TABLE powerpc.packages OWNER TO wbadm;
2114 -- Name: pkg_history; Type: VIEW; Schema: powerpc; Owner: wbadm
2117 CREATE VIEW pkg_history AS
2118 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);
2121 ALTER TABLE powerpc.pkg_history OWNER TO wbadm;
2124 -- Name: transactions; Type: VIEW; Schema: powerpc; Owner: wbadm
2127 CREATE VIEW transactions AS
2128 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 = 'powerpc'::text);
2131 ALTER TABLE powerpc.transactions OWNER TO wbadm;
2134 -- Name: users; Type: VIEW; Schema: powerpc; Owner: wbadm
2137 CREATE VIEW users AS
2138 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'powerpc'::text);
2141 ALTER TABLE powerpc.users OWNER TO wbadm;
2143 SET search_path = powerpc_public, pg_catalog;
2146 -- Name: packages; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2149 CREATE VIEW packages AS
2150 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 = 'powerpc'::text));
2153 ALTER TABLE powerpc_public.packages OWNER TO wbadm;
2156 -- Name: pkg_history; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2159 CREATE VIEW pkg_history AS
2160 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));
2163 ALTER TABLE powerpc_public.pkg_history OWNER TO wbadm;
2166 -- Name: transactions; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2169 CREATE VIEW transactions AS
2170 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 = 'powerpc'::text));
2173 ALTER TABLE powerpc_public.transactions OWNER TO wbadm;
2176 -- Name: users; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2179 CREATE VIEW users AS
2180 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'powerpc'::text));
2183 ALTER TABLE powerpc_public.users OWNER TO wbadm;
2185 SET search_path = public, pg_catalog;
2188 -- Name: architectures; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2191 CREATE TABLE architectures (
2192 architecture character varying NOT NULL
2196 ALTER TABLE public.architectures OWNER TO wbadm;
2199 -- Name: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2202 CREATE TABLE distribution_aliases (
2203 alias character varying NOT NULL,
2204 distribution character varying NOT NULL
2208 ALTER TABLE public.distribution_aliases OWNER TO wbadm;
2211 -- Name: distribution_architectures; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2214 CREATE TABLE distribution_architectures (
2215 distribution character varying NOT NULL,
2216 architecture character varying NOT NULL
2220 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2223 -- Name: distribution_architectures_statistics; Type: VIEW; Schema: public; Owner: wbadm
2226 CREATE VIEW distribution_architectures_statistics AS
2227 SELECT DISTINCT packages.distribution, packages.architecture, sum(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE 0 END) AS needsbuild, sum(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE 0 END) AS notinstalled FROM packages GROUP BY packages.distribution, packages.architecture;
2230 ALTER TABLE public.distribution_architectures_statistics OWNER TO wbadm;
2233 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2236 CREATE VIEW lastlog AS
2237 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.architecture FROM (pkg_history NATURAL JOIN distributions) WHERE (distributions.public = true) ORDER BY pkg_history."timestamp" DESC LIMIT 25;
2240 ALTER TABLE public.lastlog OWNER TO wbadm;
2243 -- Name: locks; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2246 CREATE TABLE locks (
2247 distribution character varying,
2248 architecture character varying
2252 ALTER TABLE public.locks OWNER TO wbadm;
2255 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2259 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.architecture FROM (pkg_history NATURAL JOIN distributions) WHERE (distributions.public = true) ORDER BY pkg_history."timestamp" DESC;
2262 ALTER TABLE public.log OWNER TO wbadm;
2265 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2268 CREATE VIEW packages_all AS
2269 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.architecture FROM (packages NATURAL JOIN distributions) WHERE (distributions.public = true);
2272 ALTER TABLE public.packages_all OWNER TO wbadm;
2275 -- Name: packages_public; Type: VIEW; Schema: public; Owner: wbadm
2278 CREATE VIEW packages_public AS
2279 SELECT packages.distribution, packages.architecture, packages.package, 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, distributions.public, distributions.sort_order, distributions.auto_dep_wait, distributions.build_dep_resolver, distributions.archive, distributions.suppress_successful_logs FROM (packages NATURAL JOIN distributions) WHERE (distributions.public = true);
2282 ALTER TABLE public.packages_public OWNER TO wbadm;
2284 SET search_path = s390, pg_catalog;
2287 -- Name: packages; Type: VIEW; Schema: s390; Owner: wbadm
2290 CREATE VIEW packages AS
2291 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 = 's390'::text);
2294 ALTER TABLE s390.packages OWNER TO wbadm;
2297 -- Name: pkg_history; Type: VIEW; Schema: s390; Owner: wbadm
2300 CREATE VIEW pkg_history AS
2301 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);
2304 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2307 -- Name: transactions; Type: VIEW; Schema: s390; Owner: wbadm
2310 CREATE VIEW transactions AS
2311 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 = 's390'::text);
2314 ALTER TABLE s390.transactions OWNER TO wbadm;
2317 -- Name: users; Type: VIEW; Schema: s390; Owner: wbadm
2320 CREATE VIEW users AS
2321 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390'::text);
2324 ALTER TABLE s390.users OWNER TO wbadm;
2326 SET search_path = s390_public, pg_catalog;
2329 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2332 CREATE VIEW packages AS
2333 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 = 's390'::text));
2336 ALTER TABLE s390_public.packages OWNER TO wbadm;
2339 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2342 CREATE VIEW pkg_history AS
2343 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));
2346 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2349 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2352 CREATE VIEW transactions AS
2353 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 = 's390'::text));
2356 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2359 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2362 CREATE VIEW users AS
2363 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 's390'::text));
2366 ALTER TABLE s390_public.users OWNER TO wbadm;
2368 SET search_path = s390x, pg_catalog;
2371 -- Name: packages; Type: VIEW; Schema: s390x; Owner: wbadm
2374 CREATE VIEW packages AS
2375 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);
2378 ALTER TABLE s390x.packages OWNER TO wbadm;
2381 -- Name: pkg_history; Type: VIEW; Schema: s390x; Owner: wbadm
2384 CREATE VIEW pkg_history AS
2385 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);
2388 ALTER TABLE s390x.pkg_history OWNER TO wbadm;
2391 -- Name: transactions; Type: VIEW; Schema: s390x; Owner: wbadm
2394 CREATE VIEW transactions AS
2395 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);
2398 ALTER TABLE s390x.transactions OWNER TO wbadm;
2401 -- Name: users; Type: VIEW; Schema: s390x; Owner: wbadm
2404 CREATE VIEW users AS
2405 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390x'::text);
2408 ALTER TABLE s390x.users OWNER TO wbadm;
2410 SET search_path = s390x_public, pg_catalog;
2413 -- Name: packages; Type: VIEW; Schema: s390x_public; Owner: wbadm
2416 CREATE VIEW packages AS
2417 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));
2420 ALTER TABLE s390x_public.packages OWNER TO wbadm;
2423 -- Name: pkg_history; Type: VIEW; Schema: s390x_public; Owner: wbadm
2426 CREATE VIEW pkg_history AS
2427 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));
2430 ALTER TABLE s390x_public.pkg_history OWNER TO wbadm;
2433 -- Name: transactions; Type: VIEW; Schema: s390x_public; Owner: wbadm
2436 CREATE VIEW transactions AS
2437 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));
2440 ALTER TABLE s390x_public.transactions OWNER TO wbadm;
2443 -- Name: users; Type: VIEW; Schema: s390x_public; Owner: wbadm
2446 CREATE VIEW users AS
2447 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));
2450 ALTER TABLE s390x_public.users OWNER TO wbadm;
2452 SET search_path = sparc, pg_catalog;
2455 -- Name: packages; Type: VIEW; Schema: sparc; Owner: wbadm
2458 CREATE VIEW packages AS
2459 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 = 'sparc'::text);
2462 ALTER TABLE sparc.packages OWNER TO wbadm;
2465 -- Name: pkg_history; Type: VIEW; Schema: sparc; Owner: wbadm
2468 CREATE VIEW pkg_history AS
2469 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);
2472 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2475 -- Name: transactions; Type: VIEW; Schema: sparc; Owner: wbadm
2478 CREATE VIEW transactions AS
2479 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 = 'sparc'::text);
2482 ALTER TABLE sparc.transactions OWNER TO wbadm;
2485 -- Name: users; Type: VIEW; Schema: sparc; Owner: wbadm
2488 CREATE VIEW users AS
2489 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'sparc'::text);
2492 ALTER TABLE sparc.users OWNER TO wbadm;
2494 SET search_path = sparc_public, pg_catalog;
2497 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2500 CREATE VIEW packages AS
2501 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 = 'sparc'::text));
2504 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2507 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2510 CREATE VIEW pkg_history AS
2511 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));
2514 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2517 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2520 CREATE VIEW transactions AS
2521 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 = 'sparc'::text));
2524 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2527 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2530 CREATE VIEW users AS
2531 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'sparc'::text));
2534 ALTER TABLE sparc_public.users OWNER TO wbadm;
2536 SET search_path = public, pg_catalog;
2539 -- Name: architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2542 ALTER TABLE ONLY architectures
2543 ADD CONSTRAINT architectures_pkey PRIMARY KEY (architecture);
2547 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2550 ALTER TABLE ONLY distribution_aliases
2551 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
2555 -- Name: distribution_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2558 ALTER TABLE ONLY distribution_architectures
2559 ADD CONSTRAINT distribution_architectures_pkey PRIMARY KEY (distribution, architecture);
2563 -- Name: packages_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2566 ALTER TABLE ONLY packages
2567 ADD CONSTRAINT packages_pkey PRIMARY KEY (architecture, package, distribution);
2571 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2574 ALTER TABLE ONLY pkg_history
2575 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (architecture, package, distribution, version, "timestamp");
2579 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2582 ALTER TABLE ONLY users
2583 ADD CONSTRAINT users_pkey PRIMARY KEY (architecture, username, distribution);
2587 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2590 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
2594 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2597 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
2601 -- Name: packages_arch_dist_state; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2604 CREATE INDEX packages_arch_dist_state ON packages USING btree (architecture, distribution, upper((state)::text));
2608 -- Name: packages_distribution_package; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2611 CREATE INDEX packages_distribution_package ON packages USING btree (distribution, package);
2615 -- Name: pkg_history_timestamp; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2618 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
2621 SET search_path = alpha, pg_catalog;
2624 -- Name: packages_delete; Type: RULE; Schema: alpha; Owner: wbadm
2627 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'alpha'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2631 -- Name: packages_insert; Type: RULE; Schema: alpha; Owner: wbadm
2634 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 ('alpha'::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);
2638 -- Name: packages_update; Type: RULE; Schema: alpha; Owner: wbadm
2641 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 = 'alpha'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2645 -- Name: pkg_history_delete; Type: RULE; Schema: alpha; Owner: wbadm
2648 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
2652 -- Name: pkg_history_insert; Type: RULE; Schema: alpha; Owner: wbadm
2655 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);
2659 -- Name: pkg_history_update; Type: RULE; Schema: alpha; Owner: wbadm
2662 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"));
2666 -- Name: transactions_insert; Type: RULE; Schema: alpha; Owner: wbadm
2669 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 ('alpha'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2673 -- Name: users_delete; Type: RULE; Schema: alpha; Owner: wbadm
2676 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'alpha'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2680 -- Name: users_insert; Type: RULE; Schema: alpha; Owner: wbadm
2683 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('alpha'::character varying, new.username, new.distribution, new.last_seen);
2687 -- Name: users_update; Type: RULE; Schema: alpha; Owner: wbadm
2690 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 = 'alpha'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2693 SET search_path = amd64, pg_catalog;
2696 -- Name: packages_delete; Type: RULE; Schema: amd64; Owner: wbadm
2699 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2703 -- Name: packages_insert; Type: RULE; Schema: amd64; Owner: wbadm
2706 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 ('amd64'::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);
2710 -- Name: packages_update; Type: RULE; Schema: amd64; Owner: wbadm
2713 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 = 'amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2717 -- Name: pkg_history_delete; Type: RULE; Schema: amd64; Owner: wbadm
2720 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
2724 -- Name: pkg_history_insert; Type: RULE; Schema: amd64; Owner: wbadm
2727 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);
2731 -- Name: pkg_history_update; Type: RULE; Schema: amd64; Owner: wbadm
2734 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"));
2738 -- Name: transactions_insert; Type: RULE; Schema: amd64; Owner: wbadm
2741 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 ('amd64'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2745 -- Name: users_delete; Type: RULE; Schema: amd64; Owner: wbadm
2748 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'amd64'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2752 -- Name: users_insert; Type: RULE; Schema: amd64; Owner: wbadm
2755 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('amd64'::character varying, new.username, new.distribution, new.last_seen);
2759 -- Name: users_update; Type: RULE; Schema: amd64; Owner: wbadm
2762 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 = 'amd64'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2765 SET search_path = arm, pg_catalog;
2768 -- Name: packages_delete; Type: RULE; Schema: arm; Owner: wbadm
2771 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'arm'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2775 -- Name: packages_insert; Type: RULE; Schema: arm; Owner: wbadm
2778 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 ('arm'::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);
2782 -- Name: packages_update; Type: RULE; Schema: arm; Owner: wbadm
2785 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 = 'arm'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2789 -- Name: pkg_history_delete; Type: RULE; Schema: arm; Owner: wbadm
2792 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
2796 -- Name: pkg_history_insert; Type: RULE; Schema: arm; Owner: wbadm
2799 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);
2803 -- Name: pkg_history_update; Type: RULE; Schema: arm; Owner: wbadm
2806 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"));
2810 -- Name: transactions_insert; Type: RULE; Schema: arm; Owner: wbadm
2813 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 ('arm'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2817 -- Name: users_delete; Type: RULE; Schema: arm; Owner: wbadm
2820 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'arm'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2824 -- Name: users_insert; Type: RULE; Schema: arm; Owner: wbadm
2827 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('arm'::character varying, new.username, new.distribution, new.last_seen);
2831 -- Name: users_update; Type: RULE; Schema: arm; Owner: wbadm
2834 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 = 'arm'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2837 SET search_path = armel, pg_catalog;
2840 -- Name: packages_delete; Type: RULE; Schema: armel; Owner: wbadm
2843 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'armel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2847 -- Name: packages_insert; Type: RULE; Schema: armel; Owner: wbadm
2850 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 ('armel'::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);
2854 -- Name: packages_update; Type: RULE; Schema: armel; Owner: wbadm
2857 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 = 'armel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2861 -- Name: pkg_history_delete; Type: RULE; Schema: armel; Owner: wbadm
2864 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
2868 -- Name: pkg_history_insert; Type: RULE; Schema: armel; Owner: wbadm
2871 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);
2875 -- Name: pkg_history_update; Type: RULE; Schema: armel; Owner: wbadm
2878 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"));
2882 -- Name: transactions_insert; Type: RULE; Schema: armel; Owner: wbadm
2885 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 ('armel'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2889 -- Name: users_delete; Type: RULE; Schema: armel; Owner: wbadm
2892 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'armel'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2896 -- Name: users_insert; Type: RULE; Schema: armel; Owner: wbadm
2899 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('armel'::character varying, new.username, new.distribution, new.last_seen);
2903 -- Name: users_update; Type: RULE; Schema: armel; Owner: wbadm
2906 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));
2909 SET search_path = armhf, pg_catalog;
2912 -- Name: packages_delete; Type: RULE; Schema: armhf; Owner: wbadm
2915 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));
2919 -- Name: packages_insert; Type: RULE; Schema: armhf; Owner: wbadm
2922 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);
2926 -- Name: packages_update; Type: RULE; Schema: armhf; Owner: wbadm
2929 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));
2933 -- Name: pkg_history_delete; Type: RULE; Schema: armhf; Owner: wbadm
2936 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"));
2940 -- Name: pkg_history_insert; Type: RULE; Schema: armhf; Owner: wbadm
2943 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);
2947 -- Name: pkg_history_update; Type: RULE; Schema: armhf; Owner: wbadm
2950 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"));
2954 -- Name: transactions_insert; Type: RULE; Schema: armhf; Owner: wbadm
2957 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");
2961 -- Name: users_delete; Type: RULE; Schema: armhf; Owner: wbadm
2964 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));
2968 -- Name: users_insert; Type: RULE; Schema: armhf; Owner: wbadm
2971 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);
2975 -- Name: users_update; Type: RULE; Schema: armhf; Owner: wbadm
2978 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));
2981 SET search_path = hppa, pg_catalog;
2984 -- Name: packages_delete; Type: RULE; Schema: hppa; Owner: wbadm
2987 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'hppa'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2991 -- Name: packages_insert; Type: RULE; Schema: hppa; Owner: wbadm
2994 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 ('hppa'::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);
2998 -- Name: packages_update; Type: RULE; Schema: hppa; Owner: wbadm
3001 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 = 'hppa'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3005 -- Name: pkg_history_delete; Type: RULE; Schema: hppa; Owner: wbadm
3008 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3012 -- Name: pkg_history_insert; Type: RULE; Schema: hppa; Owner: wbadm
3015 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);
3019 -- Name: pkg_history_update; Type: RULE; Schema: hppa; Owner: wbadm
3022 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"));
3026 -- Name: transactions_insert; Type: RULE; Schema: hppa; Owner: wbadm
3029 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 ('hppa'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3033 -- Name: users_delete; Type: RULE; Schema: hppa; Owner: wbadm
3036 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'hppa'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3040 -- Name: users_insert; Type: RULE; Schema: hppa; Owner: wbadm
3043 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('hppa'::character varying, new.username, new.distribution, new.last_seen);
3047 -- Name: users_update; Type: RULE; Schema: hppa; Owner: wbadm
3050 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 = 'hppa'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3053 SET search_path = "hurd-i386", pg_catalog;
3056 -- Name: packages_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3059 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'hurd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3063 -- Name: packages_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3066 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 ('hurd-i386'::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);
3070 -- Name: packages_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3073 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 = 'hurd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3077 -- Name: pkg_history_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3080 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3084 -- Name: pkg_history_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3087 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);
3091 -- Name: pkg_history_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3094 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"));
3098 -- Name: transactions_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3101 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 ('hurd-i386'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3105 -- Name: users_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3108 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'hurd-i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3112 -- Name: users_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3115 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('hurd-i386'::character varying, new.username, new.distribution, new.last_seen);
3119 -- Name: users_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3122 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 = 'hurd-i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3125 SET search_path = i386, pg_catalog;
3128 -- Name: packages_delete; Type: RULE; Schema: i386; Owner: wbadm
3131 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3135 -- Name: packages_insert; Type: RULE; Schema: i386; Owner: wbadm
3138 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 ('i386'::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);
3142 -- Name: packages_update; Type: RULE; Schema: i386; Owner: wbadm
3145 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 = 'i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3149 -- Name: pkg_history_delete; Type: RULE; Schema: i386; Owner: wbadm
3152 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3156 -- Name: pkg_history_insert; Type: RULE; Schema: i386; Owner: wbadm
3159 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);
3163 -- Name: pkg_history_update; Type: RULE; Schema: i386; Owner: wbadm
3166 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"));
3170 -- Name: transactions_insert; Type: RULE; Schema: i386; Owner: wbadm
3173 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 ('i386'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3177 -- Name: users_delete; Type: RULE; Schema: i386; Owner: wbadm
3180 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3184 -- Name: users_insert; Type: RULE; Schema: i386; Owner: wbadm
3187 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('i386'::character varying, new.username, new.distribution, new.last_seen);
3191 -- Name: users_update; Type: RULE; Schema: i386; Owner: wbadm
3194 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 = 'i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3197 SET search_path = ia64, pg_catalog;
3200 -- Name: packages_delete; Type: RULE; Schema: ia64; Owner: wbadm
3203 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'ia64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3207 -- Name: packages_insert; Type: RULE; Schema: ia64; Owner: wbadm
3210 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 ('ia64'::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);
3214 -- Name: packages_update; Type: RULE; Schema: ia64; Owner: wbadm
3217 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 = 'ia64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3221 -- Name: pkg_history_delete; Type: RULE; Schema: ia64; Owner: wbadm
3224 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3228 -- Name: pkg_history_insert; Type: RULE; Schema: ia64; Owner: wbadm
3231 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);
3235 -- Name: pkg_history_update; Type: RULE; Schema: ia64; Owner: wbadm
3238 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"));
3242 -- Name: transactions_insert; Type: RULE; Schema: ia64; Owner: wbadm
3245 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 ('ia64'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3249 -- Name: users_delete; Type: RULE; Schema: ia64; Owner: wbadm
3252 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'ia64'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3256 -- Name: users_insert; Type: RULE; Schema: ia64; Owner: wbadm
3259 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('ia64'::character varying, new.username, new.distribution, new.last_seen);
3263 -- Name: users_update; Type: RULE; Schema: ia64; Owner: wbadm
3266 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 = 'ia64'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3269 SET search_path = "kfreebsd-amd64", pg_catalog;
3272 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3275 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'kfreebsd-amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3279 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3282 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 ('kfreebsd-amd64'::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);
3286 -- Name: packages_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3289 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 = 'kfreebsd-amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3293 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3296 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3300 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3303 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);
3307 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3310 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"));
3314 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3317 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 ('kfreebsd-amd64'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3321 -- Name: users_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3324 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'kfreebsd-amd64'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3328 -- Name: users_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3331 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('kfreebsd-amd64'::character varying, new.username, new.distribution, new.last_seen);
3335 -- Name: users_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3338 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 = 'kfreebsd-amd64'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3341 SET search_path = "kfreebsd-i386", pg_catalog;
3344 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3347 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'kfreebsd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3351 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3354 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 ('kfreebsd-i386'::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);
3358 -- Name: packages_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3361 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 = 'kfreebsd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3365 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3368 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3372 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3375 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);
3379 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3382 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"));
3386 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3389 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 ('kfreebsd-i386'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3393 -- Name: users_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3396 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'kfreebsd-i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3400 -- Name: users_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3403 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('kfreebsd-i386'::character varying, new.username, new.distribution, new.last_seen);
3407 -- Name: users_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3410 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 = 'kfreebsd-i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3413 SET search_path = mips, pg_catalog;
3416 -- Name: packages_delete; Type: RULE; Schema: mips; Owner: wbadm
3419 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'mips'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3423 -- Name: packages_insert; Type: RULE; Schema: mips; Owner: wbadm
3426 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 ('mips'::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);
3430 -- Name: packages_update; Type: RULE; Schema: mips; Owner: wbadm
3433 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 = 'mips'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3437 -- Name: pkg_history_delete; Type: RULE; Schema: mips; Owner: wbadm
3440 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3444 -- Name: pkg_history_insert; Type: RULE; Schema: mips; Owner: wbadm
3447 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);
3451 -- Name: pkg_history_update; Type: RULE; Schema: mips; Owner: wbadm
3454 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"));
3458 -- Name: transactions_insert; Type: RULE; Schema: mips; Owner: wbadm
3461 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 ('mips'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3465 -- Name: users_delete; Type: RULE; Schema: mips; Owner: wbadm
3468 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'mips'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3472 -- Name: users_insert; Type: RULE; Schema: mips; Owner: wbadm
3475 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('mips'::character varying, new.username, new.distribution, new.last_seen);
3479 -- Name: users_update; Type: RULE; Schema: mips; Owner: wbadm
3482 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 = 'mips'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3485 SET search_path = mipsel, pg_catalog;
3488 -- Name: packages_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3491 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'mipsel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3495 -- Name: packages_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3498 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 ('mipsel'::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);
3502 -- Name: packages_update; Type: RULE; Schema: mipsel; Owner: wbadm
3505 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 = 'mipsel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3509 -- Name: pkg_history_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3512 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3516 -- Name: pkg_history_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3519 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);
3523 -- Name: pkg_history_update; Type: RULE; Schema: mipsel; Owner: wbadm
3526 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"));
3530 -- Name: transactions_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3533 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 ('mipsel'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3537 -- Name: users_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3540 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'mipsel'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3544 -- Name: users_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3547 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('mipsel'::character varying, new.username, new.distribution, new.last_seen);
3551 -- Name: users_update; Type: RULE; Schema: mipsel; Owner: wbadm
3554 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 = 'mipsel'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3557 SET search_path = powerpc, pg_catalog;
3560 -- Name: packages_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3563 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'powerpc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3567 -- Name: packages_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3570 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 ('powerpc'::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);
3574 -- Name: packages_update; Type: RULE; Schema: powerpc; Owner: wbadm
3577 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 = 'powerpc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3581 -- Name: pkg_history_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3584 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3588 -- Name: pkg_history_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3591 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);
3595 -- Name: pkg_history_update; Type: RULE; Schema: powerpc; Owner: wbadm
3598 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"));
3602 -- Name: transactions_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3605 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 ('powerpc'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3609 -- Name: users_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3612 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'powerpc'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3616 -- Name: users_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3619 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('powerpc'::character varying, new.username, new.distribution, new.last_seen);
3623 -- Name: users_update; Type: RULE; Schema: powerpc; Owner: wbadm
3626 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 = 'powerpc'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3629 SET search_path = s390, pg_catalog;
3632 -- Name: packages_delete; Type: RULE; Schema: s390; Owner: wbadm
3635 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 's390'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3639 -- Name: packages_insert; Type: RULE; Schema: s390; Owner: wbadm
3642 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 ('s390'::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);
3646 -- Name: packages_update; Type: RULE; Schema: s390; Owner: wbadm
3649 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 = 's390'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3653 -- Name: pkg_history_delete; Type: RULE; Schema: s390; Owner: wbadm
3656 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3660 -- Name: pkg_history_insert; Type: RULE; Schema: s390; Owner: wbadm
3663 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);
3667 -- Name: pkg_history_update; Type: RULE; Schema: s390; Owner: wbadm
3670 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"));
3674 -- Name: transactions_insert; Type: RULE; Schema: s390; Owner: wbadm
3677 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 ('s390'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3681 -- Name: users_delete; Type: RULE; Schema: s390; Owner: wbadm
3684 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 's390'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3688 -- Name: users_insert; Type: RULE; Schema: s390; Owner: wbadm
3691 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('s390'::character varying, new.username, new.distribution, new.last_seen);
3695 -- Name: users_update; Type: RULE; Schema: s390; Owner: wbadm
3698 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));
3701 SET search_path = s390x, pg_catalog;
3704 -- Name: packages_delete; Type: RULE; Schema: s390x; Owner: wbadm
3707 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));
3711 -- Name: packages_insert; Type: RULE; Schema: s390x; Owner: wbadm
3714 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);
3718 -- Name: packages_update; Type: RULE; Schema: s390x; Owner: wbadm
3721 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));
3725 -- Name: pkg_history_delete; Type: RULE; Schema: s390x; Owner: wbadm
3728 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"));
3732 -- Name: pkg_history_insert; Type: RULE; Schema: s390x; Owner: wbadm
3735 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);
3739 -- Name: pkg_history_update; Type: RULE; Schema: s390x; Owner: wbadm
3742 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"));
3746 -- Name: transactions_insert; Type: RULE; Schema: s390x; Owner: wbadm
3749 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");
3753 -- Name: users_delete; Type: RULE; Schema: s390x; Owner: wbadm
3756 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));
3760 -- Name: users_insert; Type: RULE; Schema: s390x; Owner: wbadm
3763 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);
3767 -- Name: users_update; Type: RULE; Schema: s390x; Owner: wbadm
3770 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));
3773 SET search_path = sparc, pg_catalog;
3776 -- Name: packages_delete; Type: RULE; Schema: sparc; Owner: wbadm
3779 CREATE RULE packages_delete AS ON DELETE TO packages DO INSTEAD DELETE FROM public.packages p WHERE ((((p.architecture)::text = 'sparc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3783 -- Name: packages_insert; Type: RULE; Schema: sparc; Owner: wbadm
3786 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 ('sparc'::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);
3790 -- Name: packages_update; Type: RULE; Schema: sparc; Owner: wbadm
3793 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 = 'sparc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3797 -- Name: pkg_history_delete; Type: RULE; Schema: sparc; Owner: wbadm
3800 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p 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"));
3804 -- Name: pkg_history_insert; Type: RULE; Schema: sparc; Owner: wbadm
3807 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);
3811 -- Name: pkg_history_update; Type: RULE; Schema: sparc; Owner: wbadm
3814 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"));
3818 -- Name: transactions_insert; Type: RULE; Schema: sparc; Owner: wbadm
3821 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 ('sparc'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3825 -- Name: users_delete; Type: RULE; Schema: sparc; Owner: wbadm
3828 CREATE RULE users_delete AS ON DELETE TO users DO INSTEAD DELETE FROM public.users u WHERE ((((u.architecture)::text = 'sparc'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3832 -- Name: users_insert; Type: RULE; Schema: sparc; Owner: wbadm
3835 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('sparc'::character varying, new.username, new.distribution, new.last_seen);
3839 -- Name: users_update; Type: RULE; Schema: sparc; Owner: wbadm
3842 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 = 'sparc'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3845 SET search_path = public, pg_catalog;
3848 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3851 ALTER TABLE ONLY distribution_aliases
3852 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3856 -- Name: distribution_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3859 ALTER TABLE ONLY packages
3860 ADD CONSTRAINT distribution_architecture_fkey FOREIGN KEY (distribution, architecture) REFERENCES distribution_architectures(distribution, architecture);
3864 -- Name: packages_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3867 ALTER TABLE ONLY packages
3868 ADD CONSTRAINT packages_architecture_fkey FOREIGN KEY (architecture) REFERENCES architectures(architecture);
3872 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3875 ALTER TABLE ONLY packages
3876 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3880 -- Name: pkg_history_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3883 ALTER TABLE ONLY pkg_history
3884 ADD CONSTRAINT pkg_history_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3888 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
3891 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
3892 REVOKE ALL ON SCHEMA alpha FROM wbadm;
3893 GRANT ALL ON SCHEMA alpha TO wbadm;
3894 GRANT USAGE ON SCHEMA alpha TO alpha;
3895 GRANT USAGE ON SCHEMA alpha TO wb_all;
3896 GRANT USAGE ON SCHEMA alpha TO wb_security;
3900 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
3903 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
3904 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
3905 GRANT ALL ON SCHEMA alpha_public TO wbadm;
3906 GRANT USAGE ON SCHEMA alpha_public TO alpha;
3907 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
3911 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
3914 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
3915 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
3916 GRANT ALL ON SCHEMA amd64 TO wbadm;
3917 GRANT USAGE ON SCHEMA amd64 TO amd64;
3918 GRANT USAGE ON SCHEMA amd64 TO wb_all;
3919 GRANT USAGE ON SCHEMA amd64 TO wb_security;
3923 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
3926 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
3927 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
3928 GRANT ALL ON SCHEMA amd64_public TO wbadm;
3929 GRANT USAGE ON SCHEMA amd64_public TO amd64;
3930 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
3934 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
3937 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
3938 REVOKE ALL ON SCHEMA arm FROM wbadm;
3939 GRANT ALL ON SCHEMA arm TO wbadm;
3940 GRANT USAGE ON SCHEMA arm TO arm;
3941 GRANT USAGE ON SCHEMA arm TO wb_all;
3942 GRANT USAGE ON SCHEMA arm TO wb_security;
3946 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
3949 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
3950 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
3951 GRANT ALL ON SCHEMA arm_public TO wbadm;
3952 GRANT USAGE ON SCHEMA arm_public TO arm;
3953 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
3957 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
3960 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
3961 REVOKE ALL ON SCHEMA armel FROM wbadm;
3962 GRANT ALL ON SCHEMA armel TO wbadm;
3963 GRANT USAGE ON SCHEMA armel TO armel;
3964 GRANT USAGE ON SCHEMA armel TO wb_all;
3965 GRANT USAGE ON SCHEMA armel TO wb_security;
3969 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
3972 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
3973 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
3974 GRANT ALL ON SCHEMA armel_public TO wbadm;
3975 GRANT USAGE ON SCHEMA armel_public TO armel;
3976 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
3980 -- Name: armhf; Type: ACL; Schema: -; Owner: wbadm
3983 REVOKE ALL ON SCHEMA armhf FROM PUBLIC;
3984 REVOKE ALL ON SCHEMA armhf FROM wbadm;
3985 GRANT ALL ON SCHEMA armhf TO wbadm;
3986 GRANT USAGE ON SCHEMA armhf TO wb_all;
3987 GRANT USAGE ON SCHEMA armhf TO wb_security;
3991 -- Name: armhf_public; Type: ACL; Schema: -; Owner: wbadm
3994 REVOKE ALL ON SCHEMA armhf_public FROM PUBLIC;
3995 REVOKE ALL ON SCHEMA armhf_public FROM wbadm;
3996 GRANT ALL ON SCHEMA armhf_public TO wbadm;
3997 GRANT USAGE ON SCHEMA armhf_public TO PUBLIC;
4001 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4004 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4005 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4006 GRANT ALL ON SCHEMA hppa TO wbadm;
4007 GRANT USAGE ON SCHEMA hppa TO hppa;
4008 GRANT USAGE ON SCHEMA hppa TO wb_all;
4009 GRANT USAGE ON SCHEMA hppa TO wb_security;
4013 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4016 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4017 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4018 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4019 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4020 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4024 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4027 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4028 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4029 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4030 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4031 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4032 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4036 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4039 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4040 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4041 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4042 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4043 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4047 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4050 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4051 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4052 GRANT ALL ON SCHEMA i386 TO wbadm;
4053 GRANT USAGE ON SCHEMA i386 TO i386;
4054 GRANT USAGE ON SCHEMA i386 TO wb_all;
4055 GRANT USAGE ON SCHEMA i386 TO wb_security;
4059 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4062 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4063 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4064 GRANT ALL ON SCHEMA i386_public TO wbadm;
4065 GRANT USAGE ON SCHEMA i386_public TO i386;
4066 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4070 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4073 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4074 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4075 GRANT ALL ON SCHEMA ia64 TO wbadm;
4076 GRANT USAGE ON SCHEMA ia64 TO ia64;
4077 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4078 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4082 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4085 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4086 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4087 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4088 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4089 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4093 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4096 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4097 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4098 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4099 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4100 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4101 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4105 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4108 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4109 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4110 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4111 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4112 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4116 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4119 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4120 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4121 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4122 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4123 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4124 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4128 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4131 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4132 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4133 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4134 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4135 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4139 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4142 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4143 REVOKE ALL ON SCHEMA mips FROM wbadm;
4144 GRANT ALL ON SCHEMA mips TO wbadm;
4145 GRANT USAGE ON SCHEMA mips TO mips;
4146 GRANT USAGE ON SCHEMA mips TO wb_all;
4147 GRANT USAGE ON SCHEMA mips TO wb_security;
4151 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4154 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4155 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4156 GRANT ALL ON SCHEMA mips_public TO wbadm;
4157 GRANT USAGE ON SCHEMA mips_public TO mips;
4158 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4162 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4165 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4166 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4167 GRANT ALL ON SCHEMA mipsel TO wbadm;
4168 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4169 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4170 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4174 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4177 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4178 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4179 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4180 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4181 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4185 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4188 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4189 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4190 GRANT ALL ON SCHEMA powerpc TO wbadm;
4191 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4192 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4193 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4197 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4200 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4201 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4202 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4203 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4204 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4208 -- Name: public; Type: ACL; Schema: -; Owner: wbadm
4211 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4212 REVOKE ALL ON SCHEMA public FROM wbadm;
4213 GRANT ALL ON SCHEMA public TO wbadm;
4214 GRANT ALL ON SCHEMA public TO PUBLIC;
4218 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4221 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4222 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4223 GRANT ALL ON SCHEMA s390 TO wbadm;
4224 GRANT USAGE ON SCHEMA s390 TO s390;
4225 GRANT USAGE ON SCHEMA s390 TO wb_all;
4226 GRANT USAGE ON SCHEMA s390 TO wb_security;
4230 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4233 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4234 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4235 GRANT ALL ON SCHEMA s390_public TO wbadm;
4236 GRANT USAGE ON SCHEMA s390_public TO s390;
4237 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4241 -- Name: s390x; Type: ACL; Schema: -; Owner: wbadm
4244 REVOKE ALL ON SCHEMA s390x FROM PUBLIC;
4245 REVOKE ALL ON SCHEMA s390x FROM wbadm;
4246 GRANT ALL ON SCHEMA s390x TO wbadm;
4247 GRANT USAGE ON SCHEMA s390x TO wb_all;
4248 GRANT USAGE ON SCHEMA s390x TO wb_security;
4252 -- Name: s390x_public; Type: ACL; Schema: -; Owner: wbadm
4255 REVOKE ALL ON SCHEMA s390x_public FROM PUBLIC;
4256 REVOKE ALL ON SCHEMA s390x_public FROM wbadm;
4257 GRANT ALL ON SCHEMA s390x_public TO wbadm;
4258 GRANT USAGE ON SCHEMA s390x_public TO PUBLIC;
4262 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4265 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4266 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4267 GRANT ALL ON SCHEMA sparc TO wbadm;
4268 GRANT USAGE ON SCHEMA sparc TO sparc;
4269 GRANT USAGE ON SCHEMA sparc TO wb_all;
4270 GRANT USAGE ON SCHEMA sparc TO wb_security;
4274 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4277 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4278 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4279 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4280 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4281 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4285 -- Name: packages; Type: ACL; Schema: public; Owner: wbadm
4288 REVOKE ALL ON TABLE packages FROM PUBLIC;
4289 REVOKE ALL ON TABLE packages FROM wbadm;
4290 GRANT ALL ON TABLE packages TO wbadm;
4293 SET search_path = alpha, pg_catalog;
4296 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4299 REVOKE ALL ON TABLE packages FROM PUBLIC;
4300 REVOKE ALL ON TABLE packages FROM wbadm;
4301 GRANT ALL ON TABLE packages TO wbadm;
4302 GRANT SELECT ON TABLE packages TO wb_security;
4303 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4306 SET search_path = public, pg_catalog;
4309 -- Name: pkg_history; Type: ACL; Schema: public; Owner: wbadm
4312 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4313 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4314 GRANT ALL ON TABLE pkg_history TO wbadm;
4317 SET search_path = alpha, pg_catalog;
4320 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4323 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4324 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4325 GRANT ALL ON TABLE pkg_history TO wbadm;
4326 GRANT SELECT ON TABLE pkg_history TO wb_security;
4327 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4330 SET search_path = public, pg_catalog;
4333 -- Name: transactions; Type: ACL; Schema: public; Owner: wbadm
4336 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4337 REVOKE ALL ON TABLE transactions FROM wbadm;
4338 GRANT ALL ON TABLE transactions TO wbadm;
4341 SET search_path = alpha, pg_catalog;
4344 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4347 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4348 REVOKE ALL ON TABLE transactions FROM wbadm;
4349 GRANT ALL ON TABLE transactions TO wbadm;
4350 GRANT SELECT ON TABLE transactions TO wb_security;
4351 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4354 SET search_path = public, pg_catalog;
4357 -- Name: users; Type: ACL; Schema: public; Owner: wbadm
4360 REVOKE ALL ON TABLE users FROM PUBLIC;
4361 REVOKE ALL ON TABLE users FROM wbadm;
4362 GRANT ALL ON TABLE users TO wbadm;
4365 SET search_path = alpha, pg_catalog;
4368 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4371 REVOKE ALL ON TABLE users FROM PUBLIC;
4372 REVOKE ALL ON TABLE users FROM wbadm;
4373 GRANT ALL ON TABLE users TO wbadm;
4374 GRANT SELECT ON TABLE users TO wb_security;
4375 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4378 SET search_path = public, pg_catalog;
4381 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
4384 REVOKE ALL ON TABLE distributions FROM PUBLIC;
4385 REVOKE ALL ON TABLE distributions FROM wbadm;
4386 GRANT ALL ON TABLE distributions TO wbadm;
4387 GRANT SELECT ON TABLE distributions TO PUBLIC;
4390 SET search_path = alpha_public, pg_catalog;
4393 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4396 REVOKE ALL ON TABLE packages FROM PUBLIC;
4397 REVOKE ALL ON TABLE packages FROM wbadm;
4398 GRANT ALL ON TABLE packages TO wbadm;
4399 GRANT SELECT ON TABLE packages TO PUBLIC;
4403 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4406 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4407 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4408 GRANT ALL ON TABLE pkg_history TO wbadm;
4409 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4413 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4416 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4417 REVOKE ALL ON TABLE transactions FROM wbadm;
4418 GRANT ALL ON TABLE transactions TO wbadm;
4419 GRANT SELECT ON TABLE transactions TO PUBLIC;
4423 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4426 REVOKE ALL ON TABLE users FROM PUBLIC;
4427 REVOKE ALL ON TABLE users FROM wbadm;
4428 GRANT ALL ON TABLE users TO wbadm;
4429 GRANT SELECT ON TABLE users TO PUBLIC;
4432 SET search_path = amd64, pg_catalog;
4435 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4438 REVOKE ALL ON TABLE packages FROM PUBLIC;
4439 REVOKE ALL ON TABLE packages FROM wbadm;
4440 GRANT ALL ON TABLE packages TO wbadm;
4441 GRANT SELECT ON TABLE packages TO wb_security;
4442 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4446 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4449 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4450 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4451 GRANT ALL ON TABLE pkg_history TO wbadm;
4452 GRANT SELECT ON TABLE pkg_history TO wb_security;
4453 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4457 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4460 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4461 REVOKE ALL ON TABLE transactions FROM wbadm;
4462 GRANT ALL ON TABLE transactions TO wbadm;
4463 GRANT SELECT ON TABLE transactions TO wb_security;
4464 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4468 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4471 REVOKE ALL ON TABLE users FROM PUBLIC;
4472 REVOKE ALL ON TABLE users FROM wbadm;
4473 GRANT ALL ON TABLE users TO wbadm;
4474 GRANT SELECT ON TABLE users TO wb_security;
4475 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4478 SET search_path = amd64_public, pg_catalog;
4481 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4484 REVOKE ALL ON TABLE packages FROM PUBLIC;
4485 REVOKE ALL ON TABLE packages FROM wbadm;
4486 GRANT ALL ON TABLE packages TO wbadm;
4487 GRANT SELECT ON TABLE packages TO PUBLIC;
4491 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4494 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4495 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4496 GRANT ALL ON TABLE pkg_history TO wbadm;
4497 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4501 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4504 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4505 REVOKE ALL ON TABLE transactions FROM wbadm;
4506 GRANT ALL ON TABLE transactions TO wbadm;
4507 GRANT SELECT ON TABLE transactions TO PUBLIC;
4511 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4514 REVOKE ALL ON TABLE users FROM PUBLIC;
4515 REVOKE ALL ON TABLE users FROM wbadm;
4516 GRANT ALL ON TABLE users TO wbadm;
4517 GRANT SELECT ON TABLE users TO PUBLIC;
4520 SET search_path = arm, pg_catalog;
4523 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4526 REVOKE ALL ON TABLE packages FROM PUBLIC;
4527 REVOKE ALL ON TABLE packages FROM wbadm;
4528 GRANT ALL ON TABLE packages TO wbadm;
4529 GRANT SELECT ON TABLE packages TO wb_security;
4530 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4534 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4537 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4538 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4539 GRANT ALL ON TABLE pkg_history TO wbadm;
4540 GRANT SELECT ON TABLE pkg_history TO wb_security;
4541 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4545 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4548 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4549 REVOKE ALL ON TABLE transactions FROM wbadm;
4550 GRANT ALL ON TABLE transactions TO wbadm;
4551 GRANT SELECT ON TABLE transactions TO wb_security;
4552 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4556 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4559 REVOKE ALL ON TABLE users FROM PUBLIC;
4560 REVOKE ALL ON TABLE users FROM wbadm;
4561 GRANT ALL ON TABLE users TO wbadm;
4562 GRANT SELECT ON TABLE users TO wb_security;
4563 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4566 SET search_path = arm_public, pg_catalog;
4569 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4572 REVOKE ALL ON TABLE packages FROM PUBLIC;
4573 REVOKE ALL ON TABLE packages FROM wbadm;
4574 GRANT ALL ON TABLE packages TO wbadm;
4575 GRANT SELECT ON TABLE packages TO PUBLIC;
4579 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4582 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4583 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4584 GRANT ALL ON TABLE pkg_history TO wbadm;
4585 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4589 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4592 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4593 REVOKE ALL ON TABLE transactions FROM wbadm;
4594 GRANT ALL ON TABLE transactions TO wbadm;
4595 GRANT SELECT ON TABLE transactions TO PUBLIC;
4599 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4602 REVOKE ALL ON TABLE users FROM PUBLIC;
4603 REVOKE ALL ON TABLE users FROM wbadm;
4604 GRANT ALL ON TABLE users TO wbadm;
4605 GRANT SELECT ON TABLE users TO PUBLIC;
4608 SET search_path = armel, pg_catalog;
4611 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4614 REVOKE ALL ON TABLE packages FROM PUBLIC;
4615 REVOKE ALL ON TABLE packages FROM wbadm;
4616 GRANT ALL ON TABLE packages TO wbadm;
4617 GRANT SELECT ON TABLE packages TO wb_security;
4618 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4622 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4625 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4626 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4627 GRANT ALL ON TABLE pkg_history TO wbadm;
4628 GRANT SELECT ON TABLE pkg_history TO wb_security;
4629 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4633 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4636 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4637 REVOKE ALL ON TABLE transactions FROM wbadm;
4638 GRANT ALL ON TABLE transactions TO wbadm;
4639 GRANT SELECT ON TABLE transactions TO wb_security;
4640 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4644 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4647 REVOKE ALL ON TABLE users FROM PUBLIC;
4648 REVOKE ALL ON TABLE users FROM wbadm;
4649 GRANT ALL ON TABLE users TO wbadm;
4650 GRANT SELECT ON TABLE users TO wb_security;
4651 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4654 SET search_path = armel_public, pg_catalog;
4657 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4660 REVOKE ALL ON TABLE packages FROM PUBLIC;
4661 REVOKE ALL ON TABLE packages FROM wbadm;
4662 GRANT ALL ON TABLE packages TO wbadm;
4663 GRANT SELECT ON TABLE packages TO PUBLIC;
4667 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4670 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4671 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4672 GRANT ALL ON TABLE pkg_history TO wbadm;
4673 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4677 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4680 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4681 REVOKE ALL ON TABLE transactions FROM wbadm;
4682 GRANT ALL ON TABLE transactions TO wbadm;
4683 GRANT SELECT ON TABLE transactions TO PUBLIC;
4687 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4690 REVOKE ALL ON TABLE users FROM PUBLIC;
4691 REVOKE ALL ON TABLE users FROM wbadm;
4692 GRANT ALL ON TABLE users TO wbadm;
4693 GRANT SELECT ON TABLE users TO PUBLIC;
4696 SET search_path = armhf, pg_catalog;
4699 -- Name: packages; Type: ACL; Schema: armhf; Owner: wbadm
4702 REVOKE ALL ON TABLE packages FROM PUBLIC;
4703 REVOKE ALL ON TABLE packages FROM wbadm;
4704 GRANT ALL ON TABLE packages TO wbadm;
4705 GRANT SELECT ON TABLE packages TO wb_security;
4706 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4710 -- Name: pkg_history; Type: ACL; Schema: armhf; Owner: wbadm
4713 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4714 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4715 GRANT ALL ON TABLE pkg_history TO wbadm;
4716 GRANT SELECT ON TABLE pkg_history TO wb_security;
4717 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4721 -- Name: transactions; Type: ACL; Schema: armhf; Owner: wbadm
4724 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4725 REVOKE ALL ON TABLE transactions FROM wbadm;
4726 GRANT ALL ON TABLE transactions TO wbadm;
4727 GRANT SELECT ON TABLE transactions TO wb_security;
4728 GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
4732 -- Name: users; Type: ACL; Schema: armhf; Owner: wbadm
4735 REVOKE ALL ON TABLE users FROM PUBLIC;
4736 REVOKE ALL ON TABLE users FROM wbadm;
4737 GRANT ALL ON TABLE users TO wbadm;
4738 GRANT SELECT ON TABLE users TO wb_security;
4739 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4742 SET search_path = armhf_public, pg_catalog;
4745 -- Name: packages; Type: ACL; Schema: armhf_public; Owner: wbadm
4748 REVOKE ALL ON TABLE packages FROM PUBLIC;
4749 REVOKE ALL ON TABLE packages FROM wbadm;
4750 GRANT ALL ON TABLE packages TO wbadm;
4751 GRANT SELECT ON TABLE packages TO PUBLIC;
4755 -- Name: pkg_history; Type: ACL; Schema: armhf_public; Owner: wbadm
4758 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4759 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4760 GRANT ALL ON TABLE pkg_history TO wbadm;
4761 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4765 -- Name: transactions; Type: ACL; Schema: armhf_public; Owner: wbadm
4768 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4769 REVOKE ALL ON TABLE transactions FROM wbadm;
4770 GRANT ALL ON TABLE transactions TO wbadm;
4771 GRANT SELECT ON TABLE transactions TO PUBLIC;
4775 -- Name: users; Type: ACL; Schema: armhf_public; Owner: wbadm
4778 REVOKE ALL ON TABLE users FROM PUBLIC;
4779 REVOKE ALL ON TABLE users FROM wbadm;
4780 GRANT ALL ON TABLE users TO wbadm;
4781 GRANT SELECT ON TABLE users TO PUBLIC;
4784 SET search_path = hppa, pg_catalog;
4787 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4790 REVOKE ALL ON TABLE packages FROM PUBLIC;
4791 REVOKE ALL ON TABLE packages FROM wbadm;
4792 GRANT ALL ON TABLE packages TO wbadm;
4793 GRANT SELECT ON TABLE packages TO wb_security;
4794 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4798 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4801 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4802 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4803 GRANT ALL ON TABLE pkg_history TO wbadm;
4804 GRANT SELECT ON TABLE pkg_history TO wb_security;
4805 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4809 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4812 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4813 REVOKE ALL ON TABLE transactions FROM wbadm;
4814 GRANT ALL ON TABLE transactions TO wbadm;
4815 GRANT SELECT ON TABLE transactions TO wb_security;
4816 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4820 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4823 REVOKE ALL ON TABLE users FROM PUBLIC;
4824 REVOKE ALL ON TABLE users FROM wbadm;
4825 GRANT ALL ON TABLE users TO wbadm;
4826 GRANT SELECT ON TABLE users TO wb_security;
4827 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4830 SET search_path = hppa_public, pg_catalog;
4833 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4836 REVOKE ALL ON TABLE packages FROM PUBLIC;
4837 REVOKE ALL ON TABLE packages FROM wbadm;
4838 GRANT ALL ON TABLE packages TO wbadm;
4839 GRANT SELECT ON TABLE packages TO PUBLIC;
4843 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4846 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4847 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4848 GRANT ALL ON TABLE pkg_history TO wbadm;
4849 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4853 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4856 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4857 REVOKE ALL ON TABLE transactions FROM wbadm;
4858 GRANT ALL ON TABLE transactions TO wbadm;
4859 GRANT SELECT ON TABLE transactions TO PUBLIC;
4863 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4866 REVOKE ALL ON TABLE users FROM PUBLIC;
4867 REVOKE ALL ON TABLE users FROM wbadm;
4868 GRANT ALL ON TABLE users TO wbadm;
4869 GRANT SELECT ON TABLE users TO PUBLIC;
4872 SET search_path = "hurd-i386", pg_catalog;
4875 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4878 REVOKE ALL ON TABLE packages FROM PUBLIC;
4879 REVOKE ALL ON TABLE packages FROM wbadm;
4880 GRANT ALL ON TABLE packages TO wbadm;
4881 GRANT SELECT ON TABLE packages TO wb_security;
4882 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4886 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4889 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4890 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4891 GRANT ALL ON TABLE pkg_history TO wbadm;
4892 GRANT SELECT ON TABLE pkg_history TO wb_security;
4893 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4897 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4900 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4901 REVOKE ALL ON TABLE transactions FROM wbadm;
4902 GRANT ALL ON TABLE transactions TO wbadm;
4903 GRANT SELECT ON TABLE transactions TO wb_security;
4904 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4908 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4911 REVOKE ALL ON TABLE users FROM PUBLIC;
4912 REVOKE ALL ON TABLE users FROM wbadm;
4913 GRANT ALL ON TABLE users TO wbadm;
4914 GRANT SELECT ON TABLE users TO wb_security;
4915 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4918 SET search_path = "hurd-i386_public", pg_catalog;
4921 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4924 REVOKE ALL ON TABLE packages FROM PUBLIC;
4925 REVOKE ALL ON TABLE packages FROM wbadm;
4926 GRANT ALL ON TABLE packages TO wbadm;
4927 GRANT SELECT ON TABLE packages TO PUBLIC;
4931 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4934 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4935 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4936 GRANT ALL ON TABLE pkg_history TO wbadm;
4937 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4941 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4944 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4945 REVOKE ALL ON TABLE transactions FROM wbadm;
4946 GRANT ALL ON TABLE transactions TO wbadm;
4947 GRANT SELECT ON TABLE transactions TO PUBLIC;
4951 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4954 REVOKE ALL ON TABLE users FROM PUBLIC;
4955 REVOKE ALL ON TABLE users FROM wbadm;
4956 GRANT ALL ON TABLE users TO wbadm;
4957 GRANT SELECT ON TABLE users TO PUBLIC;
4960 SET search_path = i386, pg_catalog;
4963 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4966 REVOKE ALL ON TABLE packages FROM PUBLIC;
4967 REVOKE ALL ON TABLE packages FROM wbadm;
4968 GRANT ALL ON TABLE packages TO wbadm;
4969 GRANT SELECT ON TABLE packages TO wb_security;
4970 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4974 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4977 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4978 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4979 GRANT ALL ON TABLE pkg_history TO wbadm;
4980 GRANT SELECT ON TABLE pkg_history TO wb_security;
4981 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4985 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
4988 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4989 REVOKE ALL ON TABLE transactions FROM wbadm;
4990 GRANT ALL ON TABLE transactions TO wbadm;
4991 GRANT SELECT ON TABLE transactions TO wb_security;
4992 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4996 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
4999 REVOKE ALL ON TABLE users FROM PUBLIC;
5000 REVOKE ALL ON TABLE users FROM wbadm;
5001 GRANT ALL ON TABLE users TO wbadm;
5002 GRANT SELECT ON TABLE users TO wb_security;
5003 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5006 SET search_path = i386_public, pg_catalog;
5009 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5012 REVOKE ALL ON TABLE packages FROM PUBLIC;
5013 REVOKE ALL ON TABLE packages FROM wbadm;
5014 GRANT ALL ON TABLE packages TO wbadm;
5015 GRANT SELECT ON TABLE packages TO PUBLIC;
5019 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5022 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5023 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5024 GRANT ALL ON TABLE pkg_history TO wbadm;
5025 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5029 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5032 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5033 REVOKE ALL ON TABLE transactions FROM wbadm;
5034 GRANT ALL ON TABLE transactions TO wbadm;
5035 GRANT SELECT ON TABLE transactions TO PUBLIC;
5039 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5042 REVOKE ALL ON TABLE users FROM PUBLIC;
5043 REVOKE ALL ON TABLE users FROM wbadm;
5044 GRANT ALL ON TABLE users TO wbadm;
5045 GRANT SELECT ON TABLE users TO PUBLIC;
5048 SET search_path = ia64, pg_catalog;
5051 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5054 REVOKE ALL ON TABLE packages FROM PUBLIC;
5055 REVOKE ALL ON TABLE packages FROM wbadm;
5056 GRANT ALL ON TABLE packages TO wbadm;
5057 GRANT SELECT ON TABLE packages TO wb_security;
5058 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5062 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5065 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5066 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5067 GRANT ALL ON TABLE pkg_history TO wbadm;
5068 GRANT SELECT ON TABLE pkg_history TO wb_security;
5069 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5073 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5076 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5077 REVOKE ALL ON TABLE transactions FROM wbadm;
5078 GRANT ALL ON TABLE transactions TO wbadm;
5079 GRANT SELECT ON TABLE transactions TO wb_security;
5080 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5084 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5087 REVOKE ALL ON TABLE users FROM PUBLIC;
5088 REVOKE ALL ON TABLE users FROM wbadm;
5089 GRANT ALL ON TABLE users TO wbadm;
5090 GRANT SELECT ON TABLE users TO wb_security;
5091 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5094 SET search_path = ia64_public, pg_catalog;
5097 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5100 REVOKE ALL ON TABLE packages FROM PUBLIC;
5101 REVOKE ALL ON TABLE packages FROM wbadm;
5102 GRANT ALL ON TABLE packages TO wbadm;
5103 GRANT SELECT ON TABLE packages TO PUBLIC;
5107 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5110 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5111 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5112 GRANT ALL ON TABLE pkg_history TO wbadm;
5113 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5117 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5120 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5121 REVOKE ALL ON TABLE transactions FROM wbadm;
5122 GRANT ALL ON TABLE transactions TO wbadm;
5123 GRANT SELECT ON TABLE transactions TO PUBLIC;
5127 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5130 REVOKE ALL ON TABLE users FROM PUBLIC;
5131 REVOKE ALL ON TABLE users FROM wbadm;
5132 GRANT ALL ON TABLE users TO wbadm;
5133 GRANT SELECT ON TABLE users TO PUBLIC;
5136 SET search_path = "kfreebsd-amd64", pg_catalog;
5139 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5142 REVOKE ALL ON TABLE packages FROM PUBLIC;
5143 REVOKE ALL ON TABLE packages FROM wbadm;
5144 GRANT ALL ON TABLE packages TO wbadm;
5145 GRANT SELECT ON TABLE packages TO wb_security;
5146 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5150 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5153 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5154 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5155 GRANT ALL ON TABLE pkg_history TO wbadm;
5156 GRANT SELECT ON TABLE pkg_history TO wb_security;
5157 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5161 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5164 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5165 REVOKE ALL ON TABLE transactions FROM wbadm;
5166 GRANT ALL ON TABLE transactions TO wbadm;
5167 GRANT SELECT ON TABLE transactions TO wb_security;
5168 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5172 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5175 REVOKE ALL ON TABLE users FROM PUBLIC;
5176 REVOKE ALL ON TABLE users FROM wbadm;
5177 GRANT ALL ON TABLE users TO wbadm;
5178 GRANT SELECT ON TABLE users TO wb_security;
5179 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5182 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5185 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5188 REVOKE ALL ON TABLE packages FROM PUBLIC;
5189 REVOKE ALL ON TABLE packages FROM wbadm;
5190 GRANT ALL ON TABLE packages TO wbadm;
5191 GRANT SELECT ON TABLE packages TO PUBLIC;
5195 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5198 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5199 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5200 GRANT ALL ON TABLE pkg_history TO wbadm;
5201 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5205 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5208 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5209 REVOKE ALL ON TABLE transactions FROM wbadm;
5210 GRANT ALL ON TABLE transactions TO wbadm;
5211 GRANT SELECT ON TABLE transactions TO PUBLIC;
5215 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5218 REVOKE ALL ON TABLE users FROM PUBLIC;
5219 REVOKE ALL ON TABLE users FROM wbadm;
5220 GRANT ALL ON TABLE users TO wbadm;
5221 GRANT SELECT ON TABLE users TO PUBLIC;
5224 SET search_path = "kfreebsd-i386", pg_catalog;
5227 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5230 REVOKE ALL ON TABLE packages FROM PUBLIC;
5231 REVOKE ALL ON TABLE packages FROM wbadm;
5232 GRANT ALL ON TABLE packages TO wbadm;
5233 GRANT SELECT ON TABLE packages TO wb_security;
5234 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5238 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5241 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5242 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5243 GRANT ALL ON TABLE pkg_history TO wbadm;
5244 GRANT SELECT ON TABLE pkg_history TO wb_security;
5245 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5249 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5252 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5253 REVOKE ALL ON TABLE transactions FROM wbadm;
5254 GRANT ALL ON TABLE transactions TO wbadm;
5255 GRANT SELECT ON TABLE transactions TO wb_security;
5256 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5260 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5263 REVOKE ALL ON TABLE users FROM PUBLIC;
5264 REVOKE ALL ON TABLE users FROM wbadm;
5265 GRANT ALL ON TABLE users TO wbadm;
5266 GRANT SELECT ON TABLE users TO wb_security;
5267 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5270 SET search_path = "kfreebsd-i386_public", pg_catalog;
5273 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5276 REVOKE ALL ON TABLE packages FROM PUBLIC;
5277 REVOKE ALL ON TABLE packages FROM wbadm;
5278 GRANT ALL ON TABLE packages TO wbadm;
5279 GRANT SELECT ON TABLE packages TO PUBLIC;
5283 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5286 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5287 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5288 GRANT ALL ON TABLE pkg_history TO wbadm;
5289 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5293 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5296 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5297 REVOKE ALL ON TABLE transactions FROM wbadm;
5298 GRANT ALL ON TABLE transactions TO wbadm;
5299 GRANT SELECT ON TABLE transactions TO PUBLIC;
5303 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5306 REVOKE ALL ON TABLE users FROM PUBLIC;
5307 REVOKE ALL ON TABLE users FROM wbadm;
5308 GRANT ALL ON TABLE users TO wbadm;
5309 GRANT SELECT ON TABLE users TO PUBLIC;
5312 SET search_path = mips, pg_catalog;
5315 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5318 REVOKE ALL ON TABLE packages FROM PUBLIC;
5319 REVOKE ALL ON TABLE packages FROM wbadm;
5320 GRANT ALL ON TABLE packages TO wbadm;
5321 GRANT SELECT ON TABLE packages TO wb_security;
5322 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5326 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5329 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5330 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5331 GRANT ALL ON TABLE pkg_history TO wbadm;
5332 GRANT SELECT ON TABLE pkg_history TO wb_security;
5333 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5337 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5340 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5341 REVOKE ALL ON TABLE transactions FROM wbadm;
5342 GRANT ALL ON TABLE transactions TO wbadm;
5343 GRANT SELECT ON TABLE transactions TO wb_security;
5344 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5348 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5351 REVOKE ALL ON TABLE users FROM PUBLIC;
5352 REVOKE ALL ON TABLE users FROM wbadm;
5353 GRANT ALL ON TABLE users TO wbadm;
5354 GRANT SELECT ON TABLE users TO wb_security;
5355 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5358 SET search_path = mips_public, pg_catalog;
5361 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5364 REVOKE ALL ON TABLE packages FROM PUBLIC;
5365 REVOKE ALL ON TABLE packages FROM wbadm;
5366 GRANT ALL ON TABLE packages TO wbadm;
5367 GRANT SELECT ON TABLE packages TO PUBLIC;
5371 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5374 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5375 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5376 GRANT ALL ON TABLE pkg_history TO wbadm;
5377 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5381 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5384 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5385 REVOKE ALL ON TABLE transactions FROM wbadm;
5386 GRANT ALL ON TABLE transactions TO wbadm;
5387 GRANT SELECT ON TABLE transactions TO PUBLIC;
5391 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5394 REVOKE ALL ON TABLE users FROM PUBLIC;
5395 REVOKE ALL ON TABLE users FROM wbadm;
5396 GRANT ALL ON TABLE users TO wbadm;
5397 GRANT SELECT ON TABLE users TO PUBLIC;
5400 SET search_path = mipsel, pg_catalog;
5403 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5406 REVOKE ALL ON TABLE packages FROM PUBLIC;
5407 REVOKE ALL ON TABLE packages FROM wbadm;
5408 GRANT ALL ON TABLE packages TO wbadm;
5409 GRANT SELECT ON TABLE packages TO wb_security;
5410 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5414 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5417 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5418 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5419 GRANT ALL ON TABLE pkg_history TO wbadm;
5420 GRANT SELECT ON TABLE pkg_history TO wb_security;
5421 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5425 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5428 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5429 REVOKE ALL ON TABLE transactions FROM wbadm;
5430 GRANT ALL ON TABLE transactions TO wbadm;
5431 GRANT SELECT ON TABLE transactions TO wb_security;
5432 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5436 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5439 REVOKE ALL ON TABLE users FROM PUBLIC;
5440 REVOKE ALL ON TABLE users FROM wbadm;
5441 GRANT ALL ON TABLE users TO wbadm;
5442 GRANT SELECT ON TABLE users TO wb_security;
5443 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5446 SET search_path = mipsel_public, pg_catalog;
5449 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5452 REVOKE ALL ON TABLE packages FROM PUBLIC;
5453 REVOKE ALL ON TABLE packages FROM wbadm;
5454 GRANT ALL ON TABLE packages TO wbadm;
5455 GRANT SELECT ON TABLE packages TO PUBLIC;
5459 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5462 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5463 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5464 GRANT ALL ON TABLE pkg_history TO wbadm;
5465 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5469 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5472 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5473 REVOKE ALL ON TABLE transactions FROM wbadm;
5474 GRANT ALL ON TABLE transactions TO wbadm;
5475 GRANT SELECT ON TABLE transactions TO PUBLIC;
5479 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5482 REVOKE ALL ON TABLE users FROM PUBLIC;
5483 REVOKE ALL ON TABLE users FROM wbadm;
5484 GRANT ALL ON TABLE users TO wbadm;
5485 GRANT SELECT ON TABLE users TO PUBLIC;
5488 SET search_path = powerpc, pg_catalog;
5491 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5494 REVOKE ALL ON TABLE packages FROM PUBLIC;
5495 REVOKE ALL ON TABLE packages FROM wbadm;
5496 GRANT ALL ON TABLE packages TO wbadm;
5497 GRANT SELECT ON TABLE packages TO wb_security;
5498 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5502 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5505 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5506 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5507 GRANT ALL ON TABLE pkg_history TO wbadm;
5508 GRANT SELECT ON TABLE pkg_history TO wb_security;
5509 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5513 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5516 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5517 REVOKE ALL ON TABLE transactions FROM wbadm;
5518 GRANT ALL ON TABLE transactions TO wbadm;
5519 GRANT SELECT ON TABLE transactions TO wb_security;
5520 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5524 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5527 REVOKE ALL ON TABLE users FROM PUBLIC;
5528 REVOKE ALL ON TABLE users FROM wbadm;
5529 GRANT ALL ON TABLE users TO wbadm;
5530 GRANT SELECT ON TABLE users TO wb_security;
5531 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5534 SET search_path = powerpc_public, pg_catalog;
5537 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5540 REVOKE ALL ON TABLE packages FROM PUBLIC;
5541 REVOKE ALL ON TABLE packages FROM wbadm;
5542 GRANT ALL ON TABLE packages TO wbadm;
5543 GRANT SELECT ON TABLE packages TO PUBLIC;
5547 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5550 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5551 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5552 GRANT ALL ON TABLE pkg_history TO wbadm;
5553 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5557 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5560 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5561 REVOKE ALL ON TABLE transactions FROM wbadm;
5562 GRANT ALL ON TABLE transactions TO wbadm;
5563 GRANT SELECT ON TABLE transactions TO PUBLIC;
5567 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5570 REVOKE ALL ON TABLE users FROM PUBLIC;
5571 REVOKE ALL ON TABLE users FROM wbadm;
5572 GRANT ALL ON TABLE users TO wbadm;
5573 GRANT SELECT ON TABLE users TO PUBLIC;
5576 SET search_path = public, pg_catalog;
5579 -- Name: architectures; Type: ACL; Schema: public; Owner: wbadm
5582 REVOKE ALL ON TABLE architectures FROM PUBLIC;
5583 REVOKE ALL ON TABLE architectures FROM wbadm;
5584 GRANT ALL ON TABLE architectures TO wbadm;
5585 GRANT SELECT ON TABLE architectures TO PUBLIC;
5589 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5592 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5593 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5594 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5595 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5599 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5602 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5603 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5604 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5605 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5609 -- Name: distribution_architectures_statistics; Type: ACL; Schema: public; Owner: wbadm
5612 REVOKE ALL ON TABLE distribution_architectures_statistics FROM PUBLIC;
5613 REVOKE ALL ON TABLE distribution_architectures_statistics FROM wbadm;
5614 GRANT ALL ON TABLE distribution_architectures_statistics TO wbadm;
5615 GRANT SELECT ON TABLE distribution_architectures_statistics TO PUBLIC;
5619 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5622 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5623 REVOKE ALL ON TABLE lastlog FROM wbadm;
5624 GRANT ALL ON TABLE lastlog TO wbadm;
5625 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5629 -- Name: locks; Type: ACL; Schema: public; Owner: wbadm
5632 REVOKE ALL ON TABLE locks FROM PUBLIC;
5633 REVOKE ALL ON TABLE locks FROM wbadm;
5634 GRANT ALL ON TABLE locks TO wbadm;
5635 GRANT SELECT ON TABLE locks TO PUBLIC;
5636 GRANT UPDATE ON TABLE locks TO wb_all;
5640 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5643 REVOKE ALL ON TABLE log FROM PUBLIC;
5644 REVOKE ALL ON TABLE log FROM wbadm;
5645 GRANT ALL ON TABLE log TO wbadm;
5646 GRANT SELECT ON TABLE log TO PUBLIC;
5650 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5653 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5654 REVOKE ALL ON TABLE packages_all FROM wbadm;
5655 GRANT ALL ON TABLE packages_all TO wbadm;
5656 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5660 -- Name: packages_public; Type: ACL; Schema: public; Owner: wbadm
5663 REVOKE ALL ON TABLE packages_public FROM PUBLIC;
5664 REVOKE ALL ON TABLE packages_public FROM wbadm;
5665 GRANT ALL ON TABLE packages_public TO wbadm;
5666 GRANT SELECT ON TABLE packages_public TO PUBLIC;
5669 SET search_path = s390, pg_catalog;
5672 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5675 REVOKE ALL ON TABLE packages FROM PUBLIC;
5676 REVOKE ALL ON TABLE packages FROM wbadm;
5677 GRANT ALL ON TABLE packages TO wbadm;
5678 GRANT SELECT ON TABLE packages TO wb_security;
5679 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5683 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5686 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5687 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5688 GRANT ALL ON TABLE pkg_history TO wbadm;
5689 GRANT SELECT ON TABLE pkg_history TO wb_security;
5690 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5694 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5697 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5698 REVOKE ALL ON TABLE transactions FROM wbadm;
5699 GRANT ALL ON TABLE transactions TO wbadm;
5700 GRANT SELECT ON TABLE transactions TO wb_security;
5701 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5705 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5708 REVOKE ALL ON TABLE users FROM PUBLIC;
5709 REVOKE ALL ON TABLE users FROM wbadm;
5710 GRANT ALL ON TABLE users TO wbadm;
5711 GRANT SELECT ON TABLE users TO wb_security;
5712 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5715 SET search_path = s390_public, pg_catalog;
5718 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5721 REVOKE ALL ON TABLE packages FROM PUBLIC;
5722 REVOKE ALL ON TABLE packages FROM wbadm;
5723 GRANT ALL ON TABLE packages TO wbadm;
5724 GRANT SELECT ON TABLE packages TO PUBLIC;
5728 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5731 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5732 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5733 GRANT ALL ON TABLE pkg_history TO wbadm;
5734 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5738 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5741 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5742 REVOKE ALL ON TABLE transactions FROM wbadm;
5743 GRANT ALL ON TABLE transactions TO wbadm;
5744 GRANT SELECT ON TABLE transactions TO PUBLIC;
5748 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5751 REVOKE ALL ON TABLE users FROM PUBLIC;
5752 REVOKE ALL ON TABLE users FROM wbadm;
5753 GRANT ALL ON TABLE users TO wbadm;
5754 GRANT SELECT ON TABLE users TO PUBLIC;
5757 SET search_path = s390x, pg_catalog;
5760 -- Name: packages; Type: ACL; Schema: s390x; Owner: wbadm
5763 REVOKE ALL ON TABLE packages FROM PUBLIC;
5764 REVOKE ALL ON TABLE packages FROM wbadm;
5765 GRANT ALL ON TABLE packages TO wbadm;
5766 GRANT SELECT ON TABLE packages TO wb_security;
5767 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5771 -- Name: pkg_history; Type: ACL; Schema: s390x; Owner: wbadm
5774 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5775 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5776 GRANT ALL ON TABLE pkg_history TO wbadm;
5777 GRANT SELECT ON TABLE pkg_history TO wb_security;
5778 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5782 -- Name: transactions; Type: ACL; Schema: s390x; Owner: wbadm
5785 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5786 REVOKE ALL ON TABLE transactions FROM wbadm;
5787 GRANT ALL ON TABLE transactions TO wbadm;
5788 GRANT SELECT ON TABLE transactions TO wb_security;
5789 GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
5793 -- Name: users; Type: ACL; Schema: s390x; Owner: wbadm
5796 REVOKE ALL ON TABLE users FROM PUBLIC;
5797 REVOKE ALL ON TABLE users FROM wbadm;
5798 GRANT ALL ON TABLE users TO wbadm;
5799 GRANT SELECT ON TABLE users TO wb_security;
5800 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5803 SET search_path = s390x_public, pg_catalog;
5806 -- Name: packages; Type: ACL; Schema: s390x_public; Owner: wbadm
5809 REVOKE ALL ON TABLE packages FROM PUBLIC;
5810 REVOKE ALL ON TABLE packages FROM wbadm;
5811 GRANT ALL ON TABLE packages TO wbadm;
5812 GRANT SELECT ON TABLE packages TO PUBLIC;
5816 -- Name: pkg_history; Type: ACL; Schema: s390x_public; Owner: wbadm
5819 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5820 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5821 GRANT ALL ON TABLE pkg_history TO wbadm;
5822 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5826 -- Name: transactions; Type: ACL; Schema: s390x_public; Owner: wbadm
5829 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5830 REVOKE ALL ON TABLE transactions FROM wbadm;
5831 GRANT ALL ON TABLE transactions TO wbadm;
5832 GRANT SELECT ON TABLE transactions TO PUBLIC;
5836 -- Name: users; Type: ACL; Schema: s390x_public; Owner: wbadm
5839 REVOKE ALL ON TABLE users FROM PUBLIC;
5840 REVOKE ALL ON TABLE users FROM wbadm;
5841 GRANT ALL ON TABLE users TO wbadm;
5842 GRANT SELECT ON TABLE users TO PUBLIC;
5845 SET search_path = sparc, pg_catalog;
5848 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5851 REVOKE ALL ON TABLE packages FROM PUBLIC;
5852 REVOKE ALL ON TABLE packages FROM wbadm;
5853 GRANT ALL ON TABLE packages TO wbadm;
5854 GRANT SELECT ON TABLE packages TO wb_security;
5855 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5859 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5862 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5863 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5864 GRANT ALL ON TABLE pkg_history TO wbadm;
5865 GRANT SELECT ON TABLE pkg_history TO wb_security;
5866 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5870 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5873 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5874 REVOKE ALL ON TABLE transactions FROM wbadm;
5875 GRANT ALL ON TABLE transactions TO wbadm;
5876 GRANT SELECT ON TABLE transactions TO wb_security;
5877 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5881 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5884 REVOKE ALL ON TABLE users FROM PUBLIC;
5885 REVOKE ALL ON TABLE users FROM wbadm;
5886 GRANT ALL ON TABLE users TO wbadm;
5887 GRANT SELECT ON TABLE users TO wb_security;
5888 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5891 SET search_path = sparc_public, pg_catalog;
5894 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5897 REVOKE ALL ON TABLE packages FROM PUBLIC;
5898 REVOKE ALL ON TABLE packages FROM wbadm;
5899 GRANT ALL ON TABLE packages TO wbadm;
5900 GRANT SELECT ON TABLE packages TO PUBLIC;
5904 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5907 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5908 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5909 GRANT ALL ON TABLE pkg_history TO wbadm;
5910 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5914 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5917 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5918 REVOKE ALL ON TABLE transactions FROM wbadm;
5919 GRANT ALL ON TABLE transactions TO wbadm;
5920 GRANT SELECT ON TABLE transactions TO PUBLIC;
5924 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5927 REVOKE ALL ON TABLE users FROM PUBLIC;
5928 REVOKE ALL ON TABLE users FROM wbadm;
5929 GRANT ALL ON TABLE users TO wbadm;
5930 GRANT SELECT ON TABLE users TO PUBLIC;
5934 -- PostgreSQL database dump complete