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;
2285 -- Name: priorities; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2288 CREATE TABLE priorities (
2289 type character varying NOT NULL,
2290 value character varying NOT NULL,
2291 priority integer DEFAULT 0 NOT NULL
2295 ALTER TABLE public.priorities OWNER TO wbadm;
2297 SET search_path = s390, pg_catalog;
2300 -- Name: packages; Type: VIEW; Schema: s390; Owner: wbadm
2303 CREATE VIEW packages AS
2304 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);
2307 ALTER TABLE s390.packages OWNER TO wbadm;
2310 -- Name: pkg_history; Type: VIEW; Schema: s390; Owner: wbadm
2313 CREATE VIEW pkg_history AS
2314 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);
2317 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2320 -- Name: transactions; Type: VIEW; Schema: s390; Owner: wbadm
2323 CREATE VIEW transactions AS
2324 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);
2327 ALTER TABLE s390.transactions OWNER TO wbadm;
2330 -- Name: users; Type: VIEW; Schema: s390; Owner: wbadm
2333 CREATE VIEW users AS
2334 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390'::text);
2337 ALTER TABLE s390.users OWNER TO wbadm;
2339 SET search_path = s390_public, pg_catalog;
2342 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2345 CREATE VIEW packages AS
2346 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));
2349 ALTER TABLE s390_public.packages OWNER TO wbadm;
2352 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2355 CREATE VIEW pkg_history AS
2356 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));
2359 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2362 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2365 CREATE VIEW transactions AS
2366 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));
2369 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2372 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2375 CREATE VIEW users AS
2376 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));
2379 ALTER TABLE s390_public.users OWNER TO wbadm;
2381 SET search_path = s390x, pg_catalog;
2384 -- Name: packages; Type: VIEW; Schema: s390x; Owner: wbadm
2387 CREATE VIEW packages AS
2388 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);
2391 ALTER TABLE s390x.packages OWNER TO wbadm;
2394 -- Name: pkg_history; Type: VIEW; Schema: s390x; Owner: wbadm
2397 CREATE VIEW pkg_history AS
2398 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);
2401 ALTER TABLE s390x.pkg_history OWNER TO wbadm;
2404 -- Name: transactions; Type: VIEW; Schema: s390x; Owner: wbadm
2407 CREATE VIEW transactions AS
2408 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);
2411 ALTER TABLE s390x.transactions OWNER TO wbadm;
2414 -- Name: users; Type: VIEW; Schema: s390x; Owner: wbadm
2417 CREATE VIEW users AS
2418 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390x'::text);
2421 ALTER TABLE s390x.users OWNER TO wbadm;
2423 SET search_path = s390x_public, pg_catalog;
2426 -- Name: packages; Type: VIEW; Schema: s390x_public; Owner: wbadm
2429 CREATE VIEW packages AS
2430 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));
2433 ALTER TABLE s390x_public.packages OWNER TO wbadm;
2436 -- Name: pkg_history; Type: VIEW; Schema: s390x_public; Owner: wbadm
2439 CREATE VIEW pkg_history AS
2440 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));
2443 ALTER TABLE s390x_public.pkg_history OWNER TO wbadm;
2446 -- Name: transactions; Type: VIEW; Schema: s390x_public; Owner: wbadm
2449 CREATE VIEW transactions AS
2450 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));
2453 ALTER TABLE s390x_public.transactions OWNER TO wbadm;
2456 -- Name: users; Type: VIEW; Schema: s390x_public; Owner: wbadm
2459 CREATE VIEW users AS
2460 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));
2463 ALTER TABLE s390x_public.users OWNER TO wbadm;
2465 SET search_path = sparc, pg_catalog;
2468 -- Name: packages; Type: VIEW; Schema: sparc; Owner: wbadm
2471 CREATE VIEW packages AS
2472 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);
2475 ALTER TABLE sparc.packages OWNER TO wbadm;
2478 -- Name: pkg_history; Type: VIEW; Schema: sparc; Owner: wbadm
2481 CREATE VIEW pkg_history AS
2482 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);
2485 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2488 -- Name: transactions; Type: VIEW; Schema: sparc; Owner: wbadm
2491 CREATE VIEW transactions AS
2492 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);
2495 ALTER TABLE sparc.transactions OWNER TO wbadm;
2498 -- Name: users; Type: VIEW; Schema: sparc; Owner: wbadm
2501 CREATE VIEW users AS
2502 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'sparc'::text);
2505 ALTER TABLE sparc.users OWNER TO wbadm;
2507 SET search_path = sparc_public, pg_catalog;
2510 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2513 CREATE VIEW packages AS
2514 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));
2517 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2520 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2523 CREATE VIEW pkg_history AS
2524 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));
2527 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2530 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2533 CREATE VIEW transactions AS
2534 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));
2537 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2540 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2543 CREATE VIEW users AS
2544 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));
2547 ALTER TABLE sparc_public.users OWNER TO wbadm;
2549 SET search_path = public, pg_catalog;
2552 -- Name: architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2555 ALTER TABLE ONLY architectures
2556 ADD CONSTRAINT architectures_pkey PRIMARY KEY (architecture);
2560 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2563 ALTER TABLE ONLY distribution_aliases
2564 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
2568 -- Name: distribution_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2571 ALTER TABLE ONLY distribution_architectures
2572 ADD CONSTRAINT distribution_architectures_pkey PRIMARY KEY (distribution, architecture);
2576 -- Name: packages_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2579 ALTER TABLE ONLY packages
2580 ADD CONSTRAINT packages_pkey PRIMARY KEY (architecture, package, distribution);
2584 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2587 ALTER TABLE ONLY pkg_history
2588 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (architecture, package, distribution, version, "timestamp");
2592 -- Name: priorities_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2595 ALTER TABLE ONLY priorities
2596 ADD CONSTRAINT priorities_pkey PRIMARY KEY (type, value);
2600 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2603 ALTER TABLE ONLY users
2604 ADD CONSTRAINT users_pkey PRIMARY KEY (architecture, username, distribution);
2608 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2611 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
2615 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2618 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
2622 -- Name: packages_arch_dist_state; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2625 CREATE INDEX packages_arch_dist_state ON packages USING btree (architecture, distribution, upper((state)::text));
2629 -- Name: packages_dist_pkg; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2632 CREATE INDEX packages_dist_pkg ON packages USING btree (distribution, package);
2636 -- Name: pkg_history_timestamp; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2639 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
2642 SET search_path = alpha, pg_catalog;
2645 -- Name: packages_delete; Type: RULE; Schema: alpha; Owner: wbadm
2648 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));
2652 -- Name: packages_insert; Type: RULE; Schema: alpha; Owner: wbadm
2655 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);
2659 -- Name: packages_update; Type: RULE; Schema: alpha; Owner: wbadm
2662 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));
2666 -- Name: pkg_history_delete; Type: RULE; Schema: alpha; Owner: wbadm
2669 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"));
2673 -- Name: pkg_history_insert; Type: RULE; Schema: alpha; Owner: wbadm
2676 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);
2680 -- Name: pkg_history_update; Type: RULE; Schema: alpha; Owner: wbadm
2683 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"));
2687 -- Name: transactions_insert; Type: RULE; Schema: alpha; Owner: wbadm
2690 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");
2694 -- Name: users_delete; Type: RULE; Schema: alpha; Owner: wbadm
2697 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));
2701 -- Name: users_insert; Type: RULE; Schema: alpha; Owner: wbadm
2704 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);
2708 -- Name: users_update; Type: RULE; Schema: alpha; Owner: wbadm
2711 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));
2714 SET search_path = amd64, pg_catalog;
2717 -- Name: packages_delete; Type: RULE; Schema: amd64; Owner: wbadm
2720 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));
2724 -- Name: packages_insert; Type: RULE; Schema: amd64; Owner: wbadm
2727 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);
2731 -- Name: packages_update; Type: RULE; Schema: amd64; Owner: wbadm
2734 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));
2738 -- Name: pkg_history_delete; Type: RULE; Schema: amd64; Owner: wbadm
2741 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"));
2745 -- Name: pkg_history_insert; Type: RULE; Schema: amd64; Owner: wbadm
2748 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);
2752 -- Name: pkg_history_update; Type: RULE; Schema: amd64; Owner: wbadm
2755 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"));
2759 -- Name: transactions_insert; Type: RULE; Schema: amd64; Owner: wbadm
2762 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");
2766 -- Name: users_delete; Type: RULE; Schema: amd64; Owner: wbadm
2769 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));
2773 -- Name: users_insert; Type: RULE; Schema: amd64; Owner: wbadm
2776 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);
2780 -- Name: users_update; Type: RULE; Schema: amd64; Owner: wbadm
2783 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));
2786 SET search_path = arm, pg_catalog;
2789 -- Name: packages_delete; Type: RULE; Schema: arm; Owner: wbadm
2792 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));
2796 -- Name: packages_insert; Type: RULE; Schema: arm; Owner: wbadm
2799 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);
2803 -- Name: packages_update; Type: RULE; Schema: arm; Owner: wbadm
2806 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));
2810 -- Name: pkg_history_delete; Type: RULE; Schema: arm; Owner: wbadm
2813 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"));
2817 -- Name: pkg_history_insert; Type: RULE; Schema: arm; Owner: wbadm
2820 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);
2824 -- Name: pkg_history_update; Type: RULE; Schema: arm; Owner: wbadm
2827 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"));
2831 -- Name: transactions_insert; Type: RULE; Schema: arm; Owner: wbadm
2834 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");
2838 -- Name: users_delete; Type: RULE; Schema: arm; Owner: wbadm
2841 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));
2845 -- Name: users_insert; Type: RULE; Schema: arm; Owner: wbadm
2848 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);
2852 -- Name: users_update; Type: RULE; Schema: arm; Owner: wbadm
2855 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));
2858 SET search_path = armel, pg_catalog;
2861 -- Name: packages_delete; Type: RULE; Schema: armel; Owner: wbadm
2864 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));
2868 -- Name: packages_insert; Type: RULE; Schema: armel; Owner: wbadm
2871 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);
2875 -- Name: packages_update; Type: RULE; Schema: armel; Owner: wbadm
2878 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));
2882 -- Name: pkg_history_delete; Type: RULE; Schema: armel; Owner: wbadm
2885 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"));
2889 -- Name: pkg_history_insert; Type: RULE; Schema: armel; Owner: wbadm
2892 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);
2896 -- Name: pkg_history_update; Type: RULE; Schema: armel; Owner: wbadm
2899 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"));
2903 -- Name: transactions_insert; Type: RULE; Schema: armel; Owner: wbadm
2906 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");
2910 -- Name: users_delete; Type: RULE; Schema: armel; Owner: wbadm
2913 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));
2917 -- Name: users_insert; Type: RULE; Schema: armel; Owner: wbadm
2920 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);
2924 -- Name: users_update; Type: RULE; Schema: armel; Owner: wbadm
2927 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));
2930 SET search_path = armhf, pg_catalog;
2933 -- Name: packages_delete; Type: RULE; Schema: armhf; Owner: wbadm
2936 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));
2940 -- Name: packages_insert; Type: RULE; Schema: armhf; Owner: wbadm
2943 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);
2947 -- Name: packages_update; Type: RULE; Schema: armhf; Owner: wbadm
2950 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));
2954 -- Name: pkg_history_delete; Type: RULE; Schema: armhf; Owner: wbadm
2957 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"));
2961 -- Name: pkg_history_insert; Type: RULE; Schema: armhf; Owner: wbadm
2964 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);
2968 -- Name: pkg_history_update; Type: RULE; Schema: armhf; Owner: wbadm
2971 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"));
2975 -- Name: transactions_insert; Type: RULE; Schema: armhf; Owner: wbadm
2978 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");
2982 -- Name: users_delete; Type: RULE; Schema: armhf; Owner: wbadm
2985 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));
2989 -- Name: users_insert; Type: RULE; Schema: armhf; Owner: wbadm
2992 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);
2996 -- Name: users_update; Type: RULE; Schema: armhf; Owner: wbadm
2999 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));
3002 SET search_path = hppa, pg_catalog;
3005 -- Name: packages_delete; Type: RULE; Schema: hppa; Owner: wbadm
3008 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));
3012 -- Name: packages_insert; Type: RULE; Schema: hppa; Owner: wbadm
3015 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);
3019 -- Name: packages_update; Type: RULE; Schema: hppa; Owner: wbadm
3022 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));
3026 -- Name: pkg_history_delete; Type: RULE; Schema: hppa; Owner: wbadm
3029 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"));
3033 -- Name: pkg_history_insert; Type: RULE; Schema: hppa; Owner: wbadm
3036 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);
3040 -- Name: pkg_history_update; Type: RULE; Schema: hppa; Owner: wbadm
3043 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"));
3047 -- Name: transactions_insert; Type: RULE; Schema: hppa; Owner: wbadm
3050 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");
3054 -- Name: users_delete; Type: RULE; Schema: hppa; Owner: wbadm
3057 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));
3061 -- Name: users_insert; Type: RULE; Schema: hppa; Owner: wbadm
3064 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);
3068 -- Name: users_update; Type: RULE; Schema: hppa; Owner: wbadm
3071 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));
3074 SET search_path = "hurd-i386", pg_catalog;
3077 -- Name: packages_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3080 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));
3084 -- Name: packages_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3087 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);
3091 -- Name: packages_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3094 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));
3098 -- Name: pkg_history_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3101 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"));
3105 -- Name: pkg_history_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3108 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);
3112 -- Name: pkg_history_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3115 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"));
3119 -- Name: transactions_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3122 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");
3126 -- Name: users_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3129 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));
3133 -- Name: users_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3136 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);
3140 -- Name: users_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3143 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));
3146 SET search_path = i386, pg_catalog;
3149 -- Name: packages_delete; Type: RULE; Schema: i386; Owner: wbadm
3152 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));
3156 -- Name: packages_insert; Type: RULE; Schema: i386; Owner: wbadm
3159 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);
3163 -- Name: packages_update; Type: RULE; Schema: i386; Owner: wbadm
3166 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));
3170 -- Name: pkg_history_delete; Type: RULE; Schema: i386; Owner: wbadm
3173 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"));
3177 -- Name: pkg_history_insert; Type: RULE; Schema: i386; Owner: wbadm
3180 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);
3184 -- Name: pkg_history_update; Type: RULE; Schema: i386; Owner: wbadm
3187 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"));
3191 -- Name: transactions_insert; Type: RULE; Schema: i386; Owner: wbadm
3194 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");
3198 -- Name: users_delete; Type: RULE; Schema: i386; Owner: wbadm
3201 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));
3205 -- Name: users_insert; Type: RULE; Schema: i386; Owner: wbadm
3208 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);
3212 -- Name: users_update; Type: RULE; Schema: i386; Owner: wbadm
3215 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));
3218 SET search_path = ia64, pg_catalog;
3221 -- Name: packages_delete; Type: RULE; Schema: ia64; Owner: wbadm
3224 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));
3228 -- Name: packages_insert; Type: RULE; Schema: ia64; Owner: wbadm
3231 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);
3235 -- Name: packages_update; Type: RULE; Schema: ia64; Owner: wbadm
3238 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));
3242 -- Name: pkg_history_delete; Type: RULE; Schema: ia64; Owner: wbadm
3245 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"));
3249 -- Name: pkg_history_insert; Type: RULE; Schema: ia64; Owner: wbadm
3252 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);
3256 -- Name: pkg_history_update; Type: RULE; Schema: ia64; Owner: wbadm
3259 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"));
3263 -- Name: transactions_insert; Type: RULE; Schema: ia64; Owner: wbadm
3266 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");
3270 -- Name: users_delete; Type: RULE; Schema: ia64; Owner: wbadm
3273 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));
3277 -- Name: users_insert; Type: RULE; Schema: ia64; Owner: wbadm
3280 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);
3284 -- Name: users_update; Type: RULE; Schema: ia64; Owner: wbadm
3287 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));
3290 SET search_path = "kfreebsd-amd64", pg_catalog;
3293 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3296 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));
3300 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3303 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);
3307 -- Name: packages_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3310 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));
3314 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3317 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"));
3321 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3324 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);
3328 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3331 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"));
3335 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3338 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");
3342 -- Name: users_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3345 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));
3349 -- Name: users_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3352 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);
3356 -- Name: users_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3359 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));
3362 SET search_path = "kfreebsd-i386", pg_catalog;
3365 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3368 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));
3372 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3375 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);
3379 -- Name: packages_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3382 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));
3386 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3389 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"));
3393 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3396 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);
3400 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3403 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"));
3407 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3410 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");
3414 -- Name: users_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3417 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));
3421 -- Name: users_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3424 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);
3428 -- Name: users_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3431 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));
3434 SET search_path = mips, pg_catalog;
3437 -- Name: packages_delete; Type: RULE; Schema: mips; Owner: wbadm
3440 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));
3444 -- Name: packages_insert; Type: RULE; Schema: mips; Owner: wbadm
3447 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);
3451 -- Name: packages_update; Type: RULE; Schema: mips; Owner: wbadm
3454 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));
3458 -- Name: pkg_history_delete; Type: RULE; Schema: mips; Owner: wbadm
3461 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"));
3465 -- Name: pkg_history_insert; Type: RULE; Schema: mips; Owner: wbadm
3468 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);
3472 -- Name: pkg_history_update; Type: RULE; Schema: mips; Owner: wbadm
3475 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"));
3479 -- Name: transactions_insert; Type: RULE; Schema: mips; Owner: wbadm
3482 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");
3486 -- Name: users_delete; Type: RULE; Schema: mips; Owner: wbadm
3489 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));
3493 -- Name: users_insert; Type: RULE; Schema: mips; Owner: wbadm
3496 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);
3500 -- Name: users_update; Type: RULE; Schema: mips; Owner: wbadm
3503 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));
3506 SET search_path = mipsel, pg_catalog;
3509 -- Name: packages_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3512 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));
3516 -- Name: packages_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3519 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);
3523 -- Name: packages_update; Type: RULE; Schema: mipsel; Owner: wbadm
3526 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));
3530 -- Name: pkg_history_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3533 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"));
3537 -- Name: pkg_history_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3540 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);
3544 -- Name: pkg_history_update; Type: RULE; Schema: mipsel; Owner: wbadm
3547 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"));
3551 -- Name: transactions_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3554 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");
3558 -- Name: users_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3561 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));
3565 -- Name: users_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3568 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);
3572 -- Name: users_update; Type: RULE; Schema: mipsel; Owner: wbadm
3575 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));
3578 SET search_path = powerpc, pg_catalog;
3581 -- Name: packages_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3584 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));
3588 -- Name: packages_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3591 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);
3595 -- Name: packages_update; Type: RULE; Schema: powerpc; Owner: wbadm
3598 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));
3602 -- Name: pkg_history_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3605 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"));
3609 -- Name: pkg_history_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3612 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);
3616 -- Name: pkg_history_update; Type: RULE; Schema: powerpc; Owner: wbadm
3619 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"));
3623 -- Name: transactions_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3626 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");
3630 -- Name: users_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3633 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));
3637 -- Name: users_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3640 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);
3644 -- Name: users_update; Type: RULE; Schema: powerpc; Owner: wbadm
3647 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));
3650 SET search_path = s390, pg_catalog;
3653 -- Name: packages_delete; Type: RULE; Schema: s390; Owner: wbadm
3656 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));
3660 -- Name: packages_insert; Type: RULE; Schema: s390; Owner: wbadm
3663 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);
3667 -- Name: packages_update; Type: RULE; Schema: s390; Owner: wbadm
3670 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));
3674 -- Name: pkg_history_delete; Type: RULE; Schema: s390; Owner: wbadm
3677 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"));
3681 -- Name: pkg_history_insert; Type: RULE; Schema: s390; Owner: wbadm
3684 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);
3688 -- Name: pkg_history_update; Type: RULE; Schema: s390; Owner: wbadm
3691 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"));
3695 -- Name: transactions_insert; Type: RULE; Schema: s390; Owner: wbadm
3698 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");
3702 -- Name: users_delete; Type: RULE; Schema: s390; Owner: wbadm
3705 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));
3709 -- Name: users_insert; Type: RULE; Schema: s390; Owner: wbadm
3712 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);
3716 -- Name: users_update; Type: RULE; Schema: s390; Owner: wbadm
3719 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));
3722 SET search_path = s390x, pg_catalog;
3725 -- Name: packages_delete; Type: RULE; Schema: s390x; Owner: wbadm
3728 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));
3732 -- Name: packages_insert; Type: RULE; Schema: s390x; Owner: wbadm
3735 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);
3739 -- Name: packages_update; Type: RULE; Schema: s390x; Owner: wbadm
3742 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));
3746 -- Name: pkg_history_delete; Type: RULE; Schema: s390x; Owner: wbadm
3749 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"));
3753 -- Name: pkg_history_insert; Type: RULE; Schema: s390x; Owner: wbadm
3756 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);
3760 -- Name: pkg_history_update; Type: RULE; Schema: s390x; Owner: wbadm
3763 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"));
3767 -- Name: transactions_insert; Type: RULE; Schema: s390x; Owner: wbadm
3770 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");
3774 -- Name: users_delete; Type: RULE; Schema: s390x; Owner: wbadm
3777 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));
3781 -- Name: users_insert; Type: RULE; Schema: s390x; Owner: wbadm
3784 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);
3788 -- Name: users_update; Type: RULE; Schema: s390x; Owner: wbadm
3791 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));
3794 SET search_path = sparc, pg_catalog;
3797 -- Name: packages_delete; Type: RULE; Schema: sparc; Owner: wbadm
3800 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));
3804 -- Name: packages_insert; Type: RULE; Schema: sparc; Owner: wbadm
3807 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);
3811 -- Name: packages_update; Type: RULE; Schema: sparc; Owner: wbadm
3814 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));
3818 -- Name: pkg_history_delete; Type: RULE; Schema: sparc; Owner: wbadm
3821 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"));
3825 -- Name: pkg_history_insert; Type: RULE; Schema: sparc; Owner: wbadm
3828 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);
3832 -- Name: pkg_history_update; Type: RULE; Schema: sparc; Owner: wbadm
3835 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"));
3839 -- Name: transactions_insert; Type: RULE; Schema: sparc; Owner: wbadm
3842 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");
3846 -- Name: users_delete; Type: RULE; Schema: sparc; Owner: wbadm
3849 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));
3853 -- Name: users_insert; Type: RULE; Schema: sparc; Owner: wbadm
3856 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);
3860 -- Name: users_update; Type: RULE; Schema: sparc; Owner: wbadm
3863 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));
3866 SET search_path = public, pg_catalog;
3869 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3872 ALTER TABLE ONLY distribution_aliases
3873 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3877 -- Name: distribution_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3880 ALTER TABLE ONLY packages
3881 ADD CONSTRAINT distribution_architecture_fkey FOREIGN KEY (distribution, architecture) REFERENCES distribution_architectures(distribution, architecture);
3885 -- Name: packages_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3888 ALTER TABLE ONLY packages
3889 ADD CONSTRAINT packages_architecture_fkey FOREIGN KEY (architecture) REFERENCES architectures(architecture);
3893 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3896 ALTER TABLE ONLY packages
3897 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3901 -- Name: pkg_history_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3904 ALTER TABLE ONLY pkg_history
3905 ADD CONSTRAINT pkg_history_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3909 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
3912 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
3913 REVOKE ALL ON SCHEMA alpha FROM wbadm;
3914 GRANT ALL ON SCHEMA alpha TO wbadm;
3915 GRANT USAGE ON SCHEMA alpha TO alpha;
3916 GRANT USAGE ON SCHEMA alpha TO wb_all;
3917 GRANT USAGE ON SCHEMA alpha TO wb_security;
3921 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
3924 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
3925 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
3926 GRANT ALL ON SCHEMA alpha_public TO wbadm;
3927 GRANT USAGE ON SCHEMA alpha_public TO alpha;
3928 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
3932 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
3935 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
3936 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
3937 GRANT ALL ON SCHEMA amd64 TO wbadm;
3938 GRANT USAGE ON SCHEMA amd64 TO amd64;
3939 GRANT USAGE ON SCHEMA amd64 TO wb_all;
3940 GRANT USAGE ON SCHEMA amd64 TO wb_security;
3944 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
3947 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
3948 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
3949 GRANT ALL ON SCHEMA amd64_public TO wbadm;
3950 GRANT USAGE ON SCHEMA amd64_public TO amd64;
3951 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
3955 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
3958 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
3959 REVOKE ALL ON SCHEMA arm FROM wbadm;
3960 GRANT ALL ON SCHEMA arm TO wbadm;
3961 GRANT USAGE ON SCHEMA arm TO arm;
3962 GRANT USAGE ON SCHEMA arm TO wb_all;
3963 GRANT USAGE ON SCHEMA arm TO wb_security;
3967 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
3970 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
3971 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
3972 GRANT ALL ON SCHEMA arm_public TO wbadm;
3973 GRANT USAGE ON SCHEMA arm_public TO arm;
3974 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
3978 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
3981 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
3982 REVOKE ALL ON SCHEMA armel FROM wbadm;
3983 GRANT ALL ON SCHEMA armel TO wbadm;
3984 GRANT USAGE ON SCHEMA armel TO armel;
3985 GRANT USAGE ON SCHEMA armel TO wb_all;
3986 GRANT USAGE ON SCHEMA armel TO wb_security;
3990 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
3993 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
3994 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
3995 GRANT ALL ON SCHEMA armel_public TO wbadm;
3996 GRANT USAGE ON SCHEMA armel_public TO armel;
3997 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
4001 -- Name: armhf; Type: ACL; Schema: -; Owner: wbadm
4004 REVOKE ALL ON SCHEMA armhf FROM PUBLIC;
4005 REVOKE ALL ON SCHEMA armhf FROM wbadm;
4006 GRANT ALL ON SCHEMA armhf TO wbadm;
4007 GRANT USAGE ON SCHEMA armhf TO wb_all;
4008 GRANT USAGE ON SCHEMA armhf TO wb_security;
4012 -- Name: armhf_public; Type: ACL; Schema: -; Owner: wbadm
4015 REVOKE ALL ON SCHEMA armhf_public FROM PUBLIC;
4016 REVOKE ALL ON SCHEMA armhf_public FROM wbadm;
4017 GRANT ALL ON SCHEMA armhf_public TO wbadm;
4018 GRANT USAGE ON SCHEMA armhf_public TO PUBLIC;
4022 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4025 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4026 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4027 GRANT ALL ON SCHEMA hppa TO wbadm;
4028 GRANT USAGE ON SCHEMA hppa TO hppa;
4029 GRANT USAGE ON SCHEMA hppa TO wb_all;
4030 GRANT USAGE ON SCHEMA hppa TO wb_security;
4034 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4037 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4038 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4039 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4040 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4041 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4045 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4048 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4049 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4050 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4051 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4052 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4053 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4057 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4060 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4061 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4062 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4063 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4064 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4068 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4071 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4072 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4073 GRANT ALL ON SCHEMA i386 TO wbadm;
4074 GRANT USAGE ON SCHEMA i386 TO i386;
4075 GRANT USAGE ON SCHEMA i386 TO wb_all;
4076 GRANT USAGE ON SCHEMA i386 TO wb_security;
4080 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4083 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4084 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4085 GRANT ALL ON SCHEMA i386_public TO wbadm;
4086 GRANT USAGE ON SCHEMA i386_public TO i386;
4087 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4091 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4094 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4095 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4096 GRANT ALL ON SCHEMA ia64 TO wbadm;
4097 GRANT USAGE ON SCHEMA ia64 TO ia64;
4098 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4099 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4103 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4106 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4107 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4108 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4109 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4110 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4114 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4117 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4118 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4119 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4120 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4121 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4122 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4126 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4129 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4130 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4131 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4132 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4133 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4137 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4140 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4141 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4142 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4143 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4144 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4145 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4149 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4152 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4153 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4154 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4155 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4156 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4160 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4163 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4164 REVOKE ALL ON SCHEMA mips FROM wbadm;
4165 GRANT ALL ON SCHEMA mips TO wbadm;
4166 GRANT USAGE ON SCHEMA mips TO mips;
4167 GRANT USAGE ON SCHEMA mips TO wb_all;
4168 GRANT USAGE ON SCHEMA mips TO wb_security;
4172 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4175 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4176 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4177 GRANT ALL ON SCHEMA mips_public TO wbadm;
4178 GRANT USAGE ON SCHEMA mips_public TO mips;
4179 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4183 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4186 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4187 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4188 GRANT ALL ON SCHEMA mipsel TO wbadm;
4189 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4190 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4191 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4195 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4198 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4199 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4200 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4201 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4202 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4206 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4209 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4210 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4211 GRANT ALL ON SCHEMA powerpc TO wbadm;
4212 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4213 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4214 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4218 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4221 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4222 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4223 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4224 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4225 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4229 -- Name: public; Type: ACL; Schema: -; Owner: wbadm
4232 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4233 REVOKE ALL ON SCHEMA public FROM wbadm;
4234 GRANT ALL ON SCHEMA public TO wbadm;
4235 GRANT ALL ON SCHEMA public TO PUBLIC;
4239 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4242 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4243 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4244 GRANT ALL ON SCHEMA s390 TO wbadm;
4245 GRANT USAGE ON SCHEMA s390 TO s390;
4246 GRANT USAGE ON SCHEMA s390 TO wb_all;
4247 GRANT USAGE ON SCHEMA s390 TO wb_security;
4251 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4254 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4255 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4256 GRANT ALL ON SCHEMA s390_public TO wbadm;
4257 GRANT USAGE ON SCHEMA s390_public TO s390;
4258 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4262 -- Name: s390x; Type: ACL; Schema: -; Owner: wbadm
4265 REVOKE ALL ON SCHEMA s390x FROM PUBLIC;
4266 REVOKE ALL ON SCHEMA s390x FROM wbadm;
4267 GRANT ALL ON SCHEMA s390x TO wbadm;
4268 GRANT USAGE ON SCHEMA s390x TO wb_all;
4269 GRANT USAGE ON SCHEMA s390x TO wb_security;
4273 -- Name: s390x_public; Type: ACL; Schema: -; Owner: wbadm
4276 REVOKE ALL ON SCHEMA s390x_public FROM PUBLIC;
4277 REVOKE ALL ON SCHEMA s390x_public FROM wbadm;
4278 GRANT ALL ON SCHEMA s390x_public TO wbadm;
4279 GRANT USAGE ON SCHEMA s390x_public TO PUBLIC;
4283 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4286 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4287 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4288 GRANT ALL ON SCHEMA sparc TO wbadm;
4289 GRANT USAGE ON SCHEMA sparc TO sparc;
4290 GRANT USAGE ON SCHEMA sparc TO wb_all;
4291 GRANT USAGE ON SCHEMA sparc TO wb_security;
4295 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4298 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4299 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4300 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4301 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4302 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4306 -- Name: packages; Type: ACL; Schema: public; Owner: wbadm
4309 REVOKE ALL ON TABLE packages FROM PUBLIC;
4310 REVOKE ALL ON TABLE packages FROM wbadm;
4311 GRANT ALL ON TABLE packages TO wbadm;
4314 SET search_path = alpha, pg_catalog;
4317 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4320 REVOKE ALL ON TABLE packages FROM PUBLIC;
4321 REVOKE ALL ON TABLE packages FROM wbadm;
4322 GRANT ALL ON TABLE packages TO wbadm;
4323 GRANT SELECT ON TABLE packages TO wb_security;
4324 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4327 SET search_path = public, pg_catalog;
4330 -- Name: pkg_history; Type: ACL; Schema: public; Owner: wbadm
4333 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4334 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4335 GRANT ALL ON TABLE pkg_history TO wbadm;
4338 SET search_path = alpha, pg_catalog;
4341 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4344 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4345 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4346 GRANT ALL ON TABLE pkg_history TO wbadm;
4347 GRANT SELECT ON TABLE pkg_history TO wb_security;
4348 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4351 SET search_path = public, pg_catalog;
4354 -- Name: transactions; Type: ACL; Schema: public; Owner: wbadm
4357 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4358 REVOKE ALL ON TABLE transactions FROM wbadm;
4359 GRANT ALL ON TABLE transactions TO wbadm;
4362 SET search_path = alpha, pg_catalog;
4365 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4368 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4369 REVOKE ALL ON TABLE transactions FROM wbadm;
4370 GRANT ALL ON TABLE transactions TO wbadm;
4371 GRANT SELECT ON TABLE transactions TO wb_security;
4372 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4375 SET search_path = public, pg_catalog;
4378 -- Name: users; Type: ACL; Schema: public; Owner: wbadm
4381 REVOKE ALL ON TABLE users FROM PUBLIC;
4382 REVOKE ALL ON TABLE users FROM wbadm;
4383 GRANT ALL ON TABLE users TO wbadm;
4386 SET search_path = alpha, pg_catalog;
4389 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4392 REVOKE ALL ON TABLE users FROM PUBLIC;
4393 REVOKE ALL ON TABLE users FROM wbadm;
4394 GRANT ALL ON TABLE users TO wbadm;
4395 GRANT SELECT ON TABLE users TO wb_security;
4396 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4399 SET search_path = public, pg_catalog;
4402 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
4405 REVOKE ALL ON TABLE distributions FROM PUBLIC;
4406 REVOKE ALL ON TABLE distributions FROM wbadm;
4407 GRANT ALL ON TABLE distributions TO wbadm;
4408 GRANT SELECT ON TABLE distributions TO PUBLIC;
4411 SET search_path = alpha_public, pg_catalog;
4414 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4417 REVOKE ALL ON TABLE packages FROM PUBLIC;
4418 REVOKE ALL ON TABLE packages FROM wbadm;
4419 GRANT ALL ON TABLE packages TO wbadm;
4420 GRANT SELECT ON TABLE packages TO PUBLIC;
4424 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4427 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4428 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4429 GRANT ALL ON TABLE pkg_history TO wbadm;
4430 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4434 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4437 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4438 REVOKE ALL ON TABLE transactions FROM wbadm;
4439 GRANT ALL ON TABLE transactions TO wbadm;
4440 GRANT SELECT ON TABLE transactions TO PUBLIC;
4444 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4447 REVOKE ALL ON TABLE users FROM PUBLIC;
4448 REVOKE ALL ON TABLE users FROM wbadm;
4449 GRANT ALL ON TABLE users TO wbadm;
4450 GRANT SELECT ON TABLE users TO PUBLIC;
4453 SET search_path = amd64, pg_catalog;
4456 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4459 REVOKE ALL ON TABLE packages FROM PUBLIC;
4460 REVOKE ALL ON TABLE packages FROM wbadm;
4461 GRANT ALL ON TABLE packages TO wbadm;
4462 GRANT SELECT ON TABLE packages TO wb_security;
4463 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4467 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4470 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4471 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4472 GRANT ALL ON TABLE pkg_history TO wbadm;
4473 GRANT SELECT ON TABLE pkg_history TO wb_security;
4474 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4478 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4481 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4482 REVOKE ALL ON TABLE transactions FROM wbadm;
4483 GRANT ALL ON TABLE transactions TO wbadm;
4484 GRANT SELECT ON TABLE transactions TO wb_security;
4485 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4489 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4492 REVOKE ALL ON TABLE users FROM PUBLIC;
4493 REVOKE ALL ON TABLE users FROM wbadm;
4494 GRANT ALL ON TABLE users TO wbadm;
4495 GRANT SELECT ON TABLE users TO wb_security;
4496 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4499 SET search_path = amd64_public, pg_catalog;
4502 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4505 REVOKE ALL ON TABLE packages FROM PUBLIC;
4506 REVOKE ALL ON TABLE packages FROM wbadm;
4507 GRANT ALL ON TABLE packages TO wbadm;
4508 GRANT SELECT ON TABLE packages TO PUBLIC;
4512 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4515 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4516 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4517 GRANT ALL ON TABLE pkg_history TO wbadm;
4518 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4522 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4525 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4526 REVOKE ALL ON TABLE transactions FROM wbadm;
4527 GRANT ALL ON TABLE transactions TO wbadm;
4528 GRANT SELECT ON TABLE transactions TO PUBLIC;
4532 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4535 REVOKE ALL ON TABLE users FROM PUBLIC;
4536 REVOKE ALL ON TABLE users FROM wbadm;
4537 GRANT ALL ON TABLE users TO wbadm;
4538 GRANT SELECT ON TABLE users TO PUBLIC;
4541 SET search_path = arm, pg_catalog;
4544 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4547 REVOKE ALL ON TABLE packages FROM PUBLIC;
4548 REVOKE ALL ON TABLE packages FROM wbadm;
4549 GRANT ALL ON TABLE packages TO wbadm;
4550 GRANT SELECT ON TABLE packages TO wb_security;
4551 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4555 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4558 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4559 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4560 GRANT ALL ON TABLE pkg_history TO wbadm;
4561 GRANT SELECT ON TABLE pkg_history TO wb_security;
4562 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4566 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4569 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4570 REVOKE ALL ON TABLE transactions FROM wbadm;
4571 GRANT ALL ON TABLE transactions TO wbadm;
4572 GRANT SELECT ON TABLE transactions TO wb_security;
4573 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4577 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4580 REVOKE ALL ON TABLE users FROM PUBLIC;
4581 REVOKE ALL ON TABLE users FROM wbadm;
4582 GRANT ALL ON TABLE users TO wbadm;
4583 GRANT SELECT ON TABLE users TO wb_security;
4584 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4587 SET search_path = arm_public, pg_catalog;
4590 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4593 REVOKE ALL ON TABLE packages FROM PUBLIC;
4594 REVOKE ALL ON TABLE packages FROM wbadm;
4595 GRANT ALL ON TABLE packages TO wbadm;
4596 GRANT SELECT ON TABLE packages TO PUBLIC;
4600 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4603 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4604 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4605 GRANT ALL ON TABLE pkg_history TO wbadm;
4606 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4610 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4613 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4614 REVOKE ALL ON TABLE transactions FROM wbadm;
4615 GRANT ALL ON TABLE transactions TO wbadm;
4616 GRANT SELECT ON TABLE transactions TO PUBLIC;
4620 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4623 REVOKE ALL ON TABLE users FROM PUBLIC;
4624 REVOKE ALL ON TABLE users FROM wbadm;
4625 GRANT ALL ON TABLE users TO wbadm;
4626 GRANT SELECT ON TABLE users TO PUBLIC;
4629 SET search_path = armel, pg_catalog;
4632 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4635 REVOKE ALL ON TABLE packages FROM PUBLIC;
4636 REVOKE ALL ON TABLE packages FROM wbadm;
4637 GRANT ALL ON TABLE packages TO wbadm;
4638 GRANT SELECT ON TABLE packages TO wb_security;
4639 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4643 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4646 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4647 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4648 GRANT ALL ON TABLE pkg_history TO wbadm;
4649 GRANT SELECT ON TABLE pkg_history TO wb_security;
4650 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4654 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4657 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4658 REVOKE ALL ON TABLE transactions FROM wbadm;
4659 GRANT ALL ON TABLE transactions TO wbadm;
4660 GRANT SELECT ON TABLE transactions TO wb_security;
4661 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4665 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4668 REVOKE ALL ON TABLE users FROM PUBLIC;
4669 REVOKE ALL ON TABLE users FROM wbadm;
4670 GRANT ALL ON TABLE users TO wbadm;
4671 GRANT SELECT ON TABLE users TO wb_security;
4672 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4675 SET search_path = armel_public, pg_catalog;
4678 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4681 REVOKE ALL ON TABLE packages FROM PUBLIC;
4682 REVOKE ALL ON TABLE packages FROM wbadm;
4683 GRANT ALL ON TABLE packages TO wbadm;
4684 GRANT SELECT ON TABLE packages TO PUBLIC;
4688 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4691 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4692 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4693 GRANT ALL ON TABLE pkg_history TO wbadm;
4694 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4698 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4701 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4702 REVOKE ALL ON TABLE transactions FROM wbadm;
4703 GRANT ALL ON TABLE transactions TO wbadm;
4704 GRANT SELECT ON TABLE transactions TO PUBLIC;
4708 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4711 REVOKE ALL ON TABLE users FROM PUBLIC;
4712 REVOKE ALL ON TABLE users FROM wbadm;
4713 GRANT ALL ON TABLE users TO wbadm;
4714 GRANT SELECT ON TABLE users TO PUBLIC;
4717 SET search_path = armhf, pg_catalog;
4720 -- Name: packages; Type: ACL; Schema: armhf; Owner: wbadm
4723 REVOKE ALL ON TABLE packages FROM PUBLIC;
4724 REVOKE ALL ON TABLE packages FROM wbadm;
4725 GRANT ALL ON TABLE packages TO wbadm;
4726 GRANT SELECT ON TABLE packages TO wb_security;
4727 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4731 -- Name: pkg_history; Type: ACL; Schema: armhf; Owner: wbadm
4734 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4735 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4736 GRANT ALL ON TABLE pkg_history TO wbadm;
4737 GRANT SELECT ON TABLE pkg_history TO wb_security;
4738 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4742 -- Name: transactions; Type: ACL; Schema: armhf; Owner: wbadm
4745 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4746 REVOKE ALL ON TABLE transactions FROM wbadm;
4747 GRANT ALL ON TABLE transactions TO wbadm;
4748 GRANT SELECT ON TABLE transactions TO wb_security;
4749 GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
4753 -- Name: users; Type: ACL; Schema: armhf; Owner: wbadm
4756 REVOKE ALL ON TABLE users FROM PUBLIC;
4757 REVOKE ALL ON TABLE users FROM wbadm;
4758 GRANT ALL ON TABLE users TO wbadm;
4759 GRANT SELECT ON TABLE users TO wb_security;
4760 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4763 SET search_path = armhf_public, pg_catalog;
4766 -- Name: packages; Type: ACL; Schema: armhf_public; Owner: wbadm
4769 REVOKE ALL ON TABLE packages FROM PUBLIC;
4770 REVOKE ALL ON TABLE packages FROM wbadm;
4771 GRANT ALL ON TABLE packages TO wbadm;
4772 GRANT SELECT ON TABLE packages TO PUBLIC;
4776 -- Name: pkg_history; Type: ACL; Schema: armhf_public; Owner: wbadm
4779 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4780 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4781 GRANT ALL ON TABLE pkg_history TO wbadm;
4782 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4786 -- Name: transactions; Type: ACL; Schema: armhf_public; Owner: wbadm
4789 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4790 REVOKE ALL ON TABLE transactions FROM wbadm;
4791 GRANT ALL ON TABLE transactions TO wbadm;
4792 GRANT SELECT ON TABLE transactions TO PUBLIC;
4796 -- Name: users; Type: ACL; Schema: armhf_public; Owner: wbadm
4799 REVOKE ALL ON TABLE users FROM PUBLIC;
4800 REVOKE ALL ON TABLE users FROM wbadm;
4801 GRANT ALL ON TABLE users TO wbadm;
4802 GRANT SELECT ON TABLE users TO PUBLIC;
4805 SET search_path = hppa, pg_catalog;
4808 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4811 REVOKE ALL ON TABLE packages FROM PUBLIC;
4812 REVOKE ALL ON TABLE packages FROM wbadm;
4813 GRANT ALL ON TABLE packages TO wbadm;
4814 GRANT SELECT ON TABLE packages TO wb_security;
4815 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4819 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4822 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4823 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4824 GRANT ALL ON TABLE pkg_history TO wbadm;
4825 GRANT SELECT ON TABLE pkg_history TO wb_security;
4826 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4830 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4833 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4834 REVOKE ALL ON TABLE transactions FROM wbadm;
4835 GRANT ALL ON TABLE transactions TO wbadm;
4836 GRANT SELECT ON TABLE transactions TO wb_security;
4837 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4841 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4844 REVOKE ALL ON TABLE users FROM PUBLIC;
4845 REVOKE ALL ON TABLE users FROM wbadm;
4846 GRANT ALL ON TABLE users TO wbadm;
4847 GRANT SELECT ON TABLE users TO wb_security;
4848 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4851 SET search_path = hppa_public, pg_catalog;
4854 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4857 REVOKE ALL ON TABLE packages FROM PUBLIC;
4858 REVOKE ALL ON TABLE packages FROM wbadm;
4859 GRANT ALL ON TABLE packages TO wbadm;
4860 GRANT SELECT ON TABLE packages TO PUBLIC;
4864 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4867 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4868 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4869 GRANT ALL ON TABLE pkg_history TO wbadm;
4870 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4874 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4877 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4878 REVOKE ALL ON TABLE transactions FROM wbadm;
4879 GRANT ALL ON TABLE transactions TO wbadm;
4880 GRANT SELECT ON TABLE transactions TO PUBLIC;
4884 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4887 REVOKE ALL ON TABLE users FROM PUBLIC;
4888 REVOKE ALL ON TABLE users FROM wbadm;
4889 GRANT ALL ON TABLE users TO wbadm;
4890 GRANT SELECT ON TABLE users TO PUBLIC;
4893 SET search_path = "hurd-i386", pg_catalog;
4896 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4899 REVOKE ALL ON TABLE packages FROM PUBLIC;
4900 REVOKE ALL ON TABLE packages FROM wbadm;
4901 GRANT ALL ON TABLE packages TO wbadm;
4902 GRANT SELECT ON TABLE packages TO wb_security;
4903 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4907 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4910 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4911 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4912 GRANT ALL ON TABLE pkg_history TO wbadm;
4913 GRANT SELECT ON TABLE pkg_history TO wb_security;
4914 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4918 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4921 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4922 REVOKE ALL ON TABLE transactions FROM wbadm;
4923 GRANT ALL ON TABLE transactions TO wbadm;
4924 GRANT SELECT ON TABLE transactions TO wb_security;
4925 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4929 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4932 REVOKE ALL ON TABLE users FROM PUBLIC;
4933 REVOKE ALL ON TABLE users FROM wbadm;
4934 GRANT ALL ON TABLE users TO wbadm;
4935 GRANT SELECT ON TABLE users TO wb_security;
4936 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4939 SET search_path = "hurd-i386_public", pg_catalog;
4942 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4945 REVOKE ALL ON TABLE packages FROM PUBLIC;
4946 REVOKE ALL ON TABLE packages FROM wbadm;
4947 GRANT ALL ON TABLE packages TO wbadm;
4948 GRANT SELECT ON TABLE packages TO PUBLIC;
4952 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4955 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4956 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4957 GRANT ALL ON TABLE pkg_history TO wbadm;
4958 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4962 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4965 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4966 REVOKE ALL ON TABLE transactions FROM wbadm;
4967 GRANT ALL ON TABLE transactions TO wbadm;
4968 GRANT SELECT ON TABLE transactions TO PUBLIC;
4972 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4975 REVOKE ALL ON TABLE users FROM PUBLIC;
4976 REVOKE ALL ON TABLE users FROM wbadm;
4977 GRANT ALL ON TABLE users TO wbadm;
4978 GRANT SELECT ON TABLE users TO PUBLIC;
4981 SET search_path = i386, pg_catalog;
4984 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4987 REVOKE ALL ON TABLE packages FROM PUBLIC;
4988 REVOKE ALL ON TABLE packages FROM wbadm;
4989 GRANT ALL ON TABLE packages TO wbadm;
4990 GRANT SELECT ON TABLE packages TO wb_security;
4991 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4995 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4998 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4999 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5000 GRANT ALL ON TABLE pkg_history TO wbadm;
5001 GRANT SELECT ON TABLE pkg_history TO wb_security;
5002 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5006 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
5009 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5010 REVOKE ALL ON TABLE transactions FROM wbadm;
5011 GRANT ALL ON TABLE transactions TO wbadm;
5012 GRANT SELECT ON TABLE transactions TO wb_security;
5013 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5017 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
5020 REVOKE ALL ON TABLE users FROM PUBLIC;
5021 REVOKE ALL ON TABLE users FROM wbadm;
5022 GRANT ALL ON TABLE users TO wbadm;
5023 GRANT SELECT ON TABLE users TO wb_security;
5024 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5027 SET search_path = i386_public, pg_catalog;
5030 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5033 REVOKE ALL ON TABLE packages FROM PUBLIC;
5034 REVOKE ALL ON TABLE packages FROM wbadm;
5035 GRANT ALL ON TABLE packages TO wbadm;
5036 GRANT SELECT ON TABLE packages TO PUBLIC;
5040 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5043 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5044 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5045 GRANT ALL ON TABLE pkg_history TO wbadm;
5046 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5050 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5053 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5054 REVOKE ALL ON TABLE transactions FROM wbadm;
5055 GRANT ALL ON TABLE transactions TO wbadm;
5056 GRANT SELECT ON TABLE transactions TO PUBLIC;
5060 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5063 REVOKE ALL ON TABLE users FROM PUBLIC;
5064 REVOKE ALL ON TABLE users FROM wbadm;
5065 GRANT ALL ON TABLE users TO wbadm;
5066 GRANT SELECT ON TABLE users TO PUBLIC;
5069 SET search_path = ia64, pg_catalog;
5072 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5075 REVOKE ALL ON TABLE packages FROM PUBLIC;
5076 REVOKE ALL ON TABLE packages FROM wbadm;
5077 GRANT ALL ON TABLE packages TO wbadm;
5078 GRANT SELECT ON TABLE packages TO wb_security;
5079 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5083 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5086 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5087 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5088 GRANT ALL ON TABLE pkg_history TO wbadm;
5089 GRANT SELECT ON TABLE pkg_history TO wb_security;
5090 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5094 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5097 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5098 REVOKE ALL ON TABLE transactions FROM wbadm;
5099 GRANT ALL ON TABLE transactions TO wbadm;
5100 GRANT SELECT ON TABLE transactions TO wb_security;
5101 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5105 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5108 REVOKE ALL ON TABLE users FROM PUBLIC;
5109 REVOKE ALL ON TABLE users FROM wbadm;
5110 GRANT ALL ON TABLE users TO wbadm;
5111 GRANT SELECT ON TABLE users TO wb_security;
5112 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5115 SET search_path = ia64_public, pg_catalog;
5118 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5121 REVOKE ALL ON TABLE packages FROM PUBLIC;
5122 REVOKE ALL ON TABLE packages FROM wbadm;
5123 GRANT ALL ON TABLE packages TO wbadm;
5124 GRANT SELECT ON TABLE packages TO PUBLIC;
5128 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5131 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5132 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5133 GRANT ALL ON TABLE pkg_history TO wbadm;
5134 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5138 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5141 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5142 REVOKE ALL ON TABLE transactions FROM wbadm;
5143 GRANT ALL ON TABLE transactions TO wbadm;
5144 GRANT SELECT ON TABLE transactions TO PUBLIC;
5148 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5151 REVOKE ALL ON TABLE users FROM PUBLIC;
5152 REVOKE ALL ON TABLE users FROM wbadm;
5153 GRANT ALL ON TABLE users TO wbadm;
5154 GRANT SELECT ON TABLE users TO PUBLIC;
5157 SET search_path = "kfreebsd-amd64", pg_catalog;
5160 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5163 REVOKE ALL ON TABLE packages FROM PUBLIC;
5164 REVOKE ALL ON TABLE packages FROM wbadm;
5165 GRANT ALL ON TABLE packages TO wbadm;
5166 GRANT SELECT ON TABLE packages TO wb_security;
5167 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5171 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5174 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5175 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5176 GRANT ALL ON TABLE pkg_history TO wbadm;
5177 GRANT SELECT ON TABLE pkg_history TO wb_security;
5178 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5182 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5185 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5186 REVOKE ALL ON TABLE transactions FROM wbadm;
5187 GRANT ALL ON TABLE transactions TO wbadm;
5188 GRANT SELECT ON TABLE transactions TO wb_security;
5189 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5193 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5196 REVOKE ALL ON TABLE users FROM PUBLIC;
5197 REVOKE ALL ON TABLE users FROM wbadm;
5198 GRANT ALL ON TABLE users TO wbadm;
5199 GRANT SELECT ON TABLE users TO wb_security;
5200 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5203 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5206 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5209 REVOKE ALL ON TABLE packages FROM PUBLIC;
5210 REVOKE ALL ON TABLE packages FROM wbadm;
5211 GRANT ALL ON TABLE packages TO wbadm;
5212 GRANT SELECT ON TABLE packages TO PUBLIC;
5216 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5219 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5220 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5221 GRANT ALL ON TABLE pkg_history TO wbadm;
5222 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5226 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5229 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5230 REVOKE ALL ON TABLE transactions FROM wbadm;
5231 GRANT ALL ON TABLE transactions TO wbadm;
5232 GRANT SELECT ON TABLE transactions TO PUBLIC;
5236 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5239 REVOKE ALL ON TABLE users FROM PUBLIC;
5240 REVOKE ALL ON TABLE users FROM wbadm;
5241 GRANT ALL ON TABLE users TO wbadm;
5242 GRANT SELECT ON TABLE users TO PUBLIC;
5245 SET search_path = "kfreebsd-i386", pg_catalog;
5248 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5251 REVOKE ALL ON TABLE packages FROM PUBLIC;
5252 REVOKE ALL ON TABLE packages FROM wbadm;
5253 GRANT ALL ON TABLE packages TO wbadm;
5254 GRANT SELECT ON TABLE packages TO wb_security;
5255 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5259 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5262 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5263 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5264 GRANT ALL ON TABLE pkg_history TO wbadm;
5265 GRANT SELECT ON TABLE pkg_history TO wb_security;
5266 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5270 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5273 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5274 REVOKE ALL ON TABLE transactions FROM wbadm;
5275 GRANT ALL ON TABLE transactions TO wbadm;
5276 GRANT SELECT ON TABLE transactions TO wb_security;
5277 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5281 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5284 REVOKE ALL ON TABLE users FROM PUBLIC;
5285 REVOKE ALL ON TABLE users FROM wbadm;
5286 GRANT ALL ON TABLE users TO wbadm;
5287 GRANT SELECT ON TABLE users TO wb_security;
5288 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5291 SET search_path = "kfreebsd-i386_public", pg_catalog;
5294 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5297 REVOKE ALL ON TABLE packages FROM PUBLIC;
5298 REVOKE ALL ON TABLE packages FROM wbadm;
5299 GRANT ALL ON TABLE packages TO wbadm;
5300 GRANT SELECT ON TABLE packages TO PUBLIC;
5304 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5307 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5308 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5309 GRANT ALL ON TABLE pkg_history TO wbadm;
5310 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5314 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5317 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5318 REVOKE ALL ON TABLE transactions FROM wbadm;
5319 GRANT ALL ON TABLE transactions TO wbadm;
5320 GRANT SELECT ON TABLE transactions TO PUBLIC;
5324 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5327 REVOKE ALL ON TABLE users FROM PUBLIC;
5328 REVOKE ALL ON TABLE users FROM wbadm;
5329 GRANT ALL ON TABLE users TO wbadm;
5330 GRANT SELECT ON TABLE users TO PUBLIC;
5333 SET search_path = mips, pg_catalog;
5336 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5339 REVOKE ALL ON TABLE packages FROM PUBLIC;
5340 REVOKE ALL ON TABLE packages FROM wbadm;
5341 GRANT ALL ON TABLE packages TO wbadm;
5342 GRANT SELECT ON TABLE packages TO wb_security;
5343 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5347 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5350 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5351 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5352 GRANT ALL ON TABLE pkg_history TO wbadm;
5353 GRANT SELECT ON TABLE pkg_history TO wb_security;
5354 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5358 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5361 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5362 REVOKE ALL ON TABLE transactions FROM wbadm;
5363 GRANT ALL ON TABLE transactions TO wbadm;
5364 GRANT SELECT ON TABLE transactions TO wb_security;
5365 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5369 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5372 REVOKE ALL ON TABLE users FROM PUBLIC;
5373 REVOKE ALL ON TABLE users FROM wbadm;
5374 GRANT ALL ON TABLE users TO wbadm;
5375 GRANT SELECT ON TABLE users TO wb_security;
5376 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5379 SET search_path = mips_public, pg_catalog;
5382 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5385 REVOKE ALL ON TABLE packages FROM PUBLIC;
5386 REVOKE ALL ON TABLE packages FROM wbadm;
5387 GRANT ALL ON TABLE packages TO wbadm;
5388 GRANT SELECT ON TABLE packages TO PUBLIC;
5392 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5395 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5396 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5397 GRANT ALL ON TABLE pkg_history TO wbadm;
5398 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5402 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5405 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5406 REVOKE ALL ON TABLE transactions FROM wbadm;
5407 GRANT ALL ON TABLE transactions TO wbadm;
5408 GRANT SELECT ON TABLE transactions TO PUBLIC;
5412 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5415 REVOKE ALL ON TABLE users FROM PUBLIC;
5416 REVOKE ALL ON TABLE users FROM wbadm;
5417 GRANT ALL ON TABLE users TO wbadm;
5418 GRANT SELECT ON TABLE users TO PUBLIC;
5421 SET search_path = mipsel, pg_catalog;
5424 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5427 REVOKE ALL ON TABLE packages FROM PUBLIC;
5428 REVOKE ALL ON TABLE packages FROM wbadm;
5429 GRANT ALL ON TABLE packages TO wbadm;
5430 GRANT SELECT ON TABLE packages TO wb_security;
5431 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5435 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5438 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5439 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5440 GRANT ALL ON TABLE pkg_history TO wbadm;
5441 GRANT SELECT ON TABLE pkg_history TO wb_security;
5442 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5446 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5449 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5450 REVOKE ALL ON TABLE transactions FROM wbadm;
5451 GRANT ALL ON TABLE transactions TO wbadm;
5452 GRANT SELECT ON TABLE transactions TO wb_security;
5453 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5457 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5460 REVOKE ALL ON TABLE users FROM PUBLIC;
5461 REVOKE ALL ON TABLE users FROM wbadm;
5462 GRANT ALL ON TABLE users TO wbadm;
5463 GRANT SELECT ON TABLE users TO wb_security;
5464 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5467 SET search_path = mipsel_public, pg_catalog;
5470 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5473 REVOKE ALL ON TABLE packages FROM PUBLIC;
5474 REVOKE ALL ON TABLE packages FROM wbadm;
5475 GRANT ALL ON TABLE packages TO wbadm;
5476 GRANT SELECT ON TABLE packages TO PUBLIC;
5480 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5483 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5484 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5485 GRANT ALL ON TABLE pkg_history TO wbadm;
5486 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5490 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5493 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5494 REVOKE ALL ON TABLE transactions FROM wbadm;
5495 GRANT ALL ON TABLE transactions TO wbadm;
5496 GRANT SELECT ON TABLE transactions TO PUBLIC;
5500 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5503 REVOKE ALL ON TABLE users FROM PUBLIC;
5504 REVOKE ALL ON TABLE users FROM wbadm;
5505 GRANT ALL ON TABLE users TO wbadm;
5506 GRANT SELECT ON TABLE users TO PUBLIC;
5509 SET search_path = powerpc, pg_catalog;
5512 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5515 REVOKE ALL ON TABLE packages FROM PUBLIC;
5516 REVOKE ALL ON TABLE packages FROM wbadm;
5517 GRANT ALL ON TABLE packages TO wbadm;
5518 GRANT SELECT ON TABLE packages TO wb_security;
5519 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5523 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5526 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5527 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5528 GRANT ALL ON TABLE pkg_history TO wbadm;
5529 GRANT SELECT ON TABLE pkg_history TO wb_security;
5530 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5534 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5537 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5538 REVOKE ALL ON TABLE transactions FROM wbadm;
5539 GRANT ALL ON TABLE transactions TO wbadm;
5540 GRANT SELECT ON TABLE transactions TO wb_security;
5541 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5545 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5548 REVOKE ALL ON TABLE users FROM PUBLIC;
5549 REVOKE ALL ON TABLE users FROM wbadm;
5550 GRANT ALL ON TABLE users TO wbadm;
5551 GRANT SELECT ON TABLE users TO wb_security;
5552 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5555 SET search_path = powerpc_public, pg_catalog;
5558 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5561 REVOKE ALL ON TABLE packages FROM PUBLIC;
5562 REVOKE ALL ON TABLE packages FROM wbadm;
5563 GRANT ALL ON TABLE packages TO wbadm;
5564 GRANT SELECT ON TABLE packages TO PUBLIC;
5568 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5571 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5572 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5573 GRANT ALL ON TABLE pkg_history TO wbadm;
5574 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5578 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5581 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5582 REVOKE ALL ON TABLE transactions FROM wbadm;
5583 GRANT ALL ON TABLE transactions TO wbadm;
5584 GRANT SELECT ON TABLE transactions TO PUBLIC;
5588 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5591 REVOKE ALL ON TABLE users FROM PUBLIC;
5592 REVOKE ALL ON TABLE users FROM wbadm;
5593 GRANT ALL ON TABLE users TO wbadm;
5594 GRANT SELECT ON TABLE users TO PUBLIC;
5597 SET search_path = public, pg_catalog;
5600 -- Name: architectures; Type: ACL; Schema: public; Owner: wbadm
5603 REVOKE ALL ON TABLE architectures FROM PUBLIC;
5604 REVOKE ALL ON TABLE architectures FROM wbadm;
5605 GRANT ALL ON TABLE architectures TO wbadm;
5606 GRANT SELECT ON TABLE architectures TO PUBLIC;
5610 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5613 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5614 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5615 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5616 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5620 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5623 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5624 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5625 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5626 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5630 -- Name: distribution_architectures_statistics; Type: ACL; Schema: public; Owner: wbadm
5633 REVOKE ALL ON TABLE distribution_architectures_statistics FROM PUBLIC;
5634 REVOKE ALL ON TABLE distribution_architectures_statistics FROM wbadm;
5635 GRANT ALL ON TABLE distribution_architectures_statistics TO wbadm;
5636 GRANT SELECT ON TABLE distribution_architectures_statistics TO PUBLIC;
5640 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5643 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5644 REVOKE ALL ON TABLE lastlog FROM wbadm;
5645 GRANT ALL ON TABLE lastlog TO wbadm;
5646 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5650 -- Name: locks; Type: ACL; Schema: public; Owner: wbadm
5653 REVOKE ALL ON TABLE locks FROM PUBLIC;
5654 REVOKE ALL ON TABLE locks FROM wbadm;
5655 GRANT ALL ON TABLE locks TO wbadm;
5656 GRANT SELECT ON TABLE locks TO PUBLIC;
5657 GRANT UPDATE ON TABLE locks TO wb_all;
5661 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5664 REVOKE ALL ON TABLE log FROM PUBLIC;
5665 REVOKE ALL ON TABLE log FROM wbadm;
5666 GRANT ALL ON TABLE log TO wbadm;
5667 GRANT SELECT ON TABLE log TO PUBLIC;
5671 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5674 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5675 REVOKE ALL ON TABLE packages_all FROM wbadm;
5676 GRANT ALL ON TABLE packages_all TO wbadm;
5677 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5681 -- Name: packages_public; Type: ACL; Schema: public; Owner: wbadm
5684 REVOKE ALL ON TABLE packages_public FROM PUBLIC;
5685 REVOKE ALL ON TABLE packages_public FROM wbadm;
5686 GRANT ALL ON TABLE packages_public TO wbadm;
5687 GRANT SELECT ON TABLE packages_public TO PUBLIC;
5691 -- Name: priorities; Type: ACL; Schema: public; Owner: wbadm
5694 REVOKE ALL ON TABLE priorities FROM PUBLIC;
5695 REVOKE ALL ON TABLE priorities FROM wbadm;
5696 GRANT ALL ON TABLE priorities TO wbadm;
5697 GRANT SELECT ON TABLE priorities TO PUBLIC;
5700 SET search_path = s390, pg_catalog;
5703 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5706 REVOKE ALL ON TABLE packages FROM PUBLIC;
5707 REVOKE ALL ON TABLE packages FROM wbadm;
5708 GRANT ALL ON TABLE packages TO wbadm;
5709 GRANT SELECT ON TABLE packages TO wb_security;
5710 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5714 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5717 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5718 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5719 GRANT ALL ON TABLE pkg_history TO wbadm;
5720 GRANT SELECT ON TABLE pkg_history TO wb_security;
5721 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5725 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5728 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5729 REVOKE ALL ON TABLE transactions FROM wbadm;
5730 GRANT ALL ON TABLE transactions TO wbadm;
5731 GRANT SELECT ON TABLE transactions TO wb_security;
5732 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5736 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5739 REVOKE ALL ON TABLE users FROM PUBLIC;
5740 REVOKE ALL ON TABLE users FROM wbadm;
5741 GRANT ALL ON TABLE users TO wbadm;
5742 GRANT SELECT ON TABLE users TO wb_security;
5743 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5746 SET search_path = s390_public, pg_catalog;
5749 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5752 REVOKE ALL ON TABLE packages FROM PUBLIC;
5753 REVOKE ALL ON TABLE packages FROM wbadm;
5754 GRANT ALL ON TABLE packages TO wbadm;
5755 GRANT SELECT ON TABLE packages TO PUBLIC;
5759 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5762 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5763 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5764 GRANT ALL ON TABLE pkg_history TO wbadm;
5765 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5769 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5772 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5773 REVOKE ALL ON TABLE transactions FROM wbadm;
5774 GRANT ALL ON TABLE transactions TO wbadm;
5775 GRANT SELECT ON TABLE transactions TO PUBLIC;
5779 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5782 REVOKE ALL ON TABLE users FROM PUBLIC;
5783 REVOKE ALL ON TABLE users FROM wbadm;
5784 GRANT ALL ON TABLE users TO wbadm;
5785 GRANT SELECT ON TABLE users TO PUBLIC;
5788 SET search_path = s390x, pg_catalog;
5791 -- Name: packages; Type: ACL; Schema: s390x; Owner: wbadm
5794 REVOKE ALL ON TABLE packages FROM PUBLIC;
5795 REVOKE ALL ON TABLE packages FROM wbadm;
5796 GRANT ALL ON TABLE packages TO wbadm;
5797 GRANT SELECT ON TABLE packages TO wb_security;
5798 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5802 -- Name: pkg_history; Type: ACL; Schema: s390x; Owner: wbadm
5805 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5806 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5807 GRANT ALL ON TABLE pkg_history TO wbadm;
5808 GRANT SELECT ON TABLE pkg_history TO wb_security;
5809 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5813 -- Name: transactions; Type: ACL; Schema: s390x; Owner: wbadm
5816 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5817 REVOKE ALL ON TABLE transactions FROM wbadm;
5818 GRANT ALL ON TABLE transactions TO wbadm;
5819 GRANT SELECT ON TABLE transactions TO wb_security;
5820 GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
5824 -- Name: users; Type: ACL; Schema: s390x; Owner: wbadm
5827 REVOKE ALL ON TABLE users FROM PUBLIC;
5828 REVOKE ALL ON TABLE users FROM wbadm;
5829 GRANT ALL ON TABLE users TO wbadm;
5830 GRANT SELECT ON TABLE users TO wb_security;
5831 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5834 SET search_path = s390x_public, pg_catalog;
5837 -- Name: packages; Type: ACL; Schema: s390x_public; Owner: wbadm
5840 REVOKE ALL ON TABLE packages FROM PUBLIC;
5841 REVOKE ALL ON TABLE packages FROM wbadm;
5842 GRANT ALL ON TABLE packages TO wbadm;
5843 GRANT SELECT ON TABLE packages TO PUBLIC;
5847 -- Name: pkg_history; Type: ACL; Schema: s390x_public; Owner: wbadm
5850 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5851 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5852 GRANT ALL ON TABLE pkg_history TO wbadm;
5853 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5857 -- Name: transactions; Type: ACL; Schema: s390x_public; Owner: wbadm
5860 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5861 REVOKE ALL ON TABLE transactions FROM wbadm;
5862 GRANT ALL ON TABLE transactions TO wbadm;
5863 GRANT SELECT ON TABLE transactions TO PUBLIC;
5867 -- Name: users; Type: ACL; Schema: s390x_public; Owner: wbadm
5870 REVOKE ALL ON TABLE users FROM PUBLIC;
5871 REVOKE ALL ON TABLE users FROM wbadm;
5872 GRANT ALL ON TABLE users TO wbadm;
5873 GRANT SELECT ON TABLE users TO PUBLIC;
5876 SET search_path = sparc, pg_catalog;
5879 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5882 REVOKE ALL ON TABLE packages FROM PUBLIC;
5883 REVOKE ALL ON TABLE packages FROM wbadm;
5884 GRANT ALL ON TABLE packages TO wbadm;
5885 GRANT SELECT ON TABLE packages TO wb_security;
5886 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5890 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5893 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5894 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5895 GRANT ALL ON TABLE pkg_history TO wbadm;
5896 GRANT SELECT ON TABLE pkg_history TO wb_security;
5897 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5901 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5904 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5905 REVOKE ALL ON TABLE transactions FROM wbadm;
5906 GRANT ALL ON TABLE transactions TO wbadm;
5907 GRANT SELECT ON TABLE transactions TO wb_security;
5908 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5912 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5915 REVOKE ALL ON TABLE users FROM PUBLIC;
5916 REVOKE ALL ON TABLE users FROM wbadm;
5917 GRANT ALL ON TABLE users TO wbadm;
5918 GRANT SELECT ON TABLE users TO wb_security;
5919 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5922 SET search_path = sparc_public, pg_catalog;
5925 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5928 REVOKE ALL ON TABLE packages FROM PUBLIC;
5929 REVOKE ALL ON TABLE packages FROM wbadm;
5930 GRANT ALL ON TABLE packages TO wbadm;
5931 GRANT SELECT ON TABLE packages TO PUBLIC;
5935 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5938 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5939 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5940 GRANT ALL ON TABLE pkg_history TO wbadm;
5941 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5945 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5948 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5949 REVOKE ALL ON TABLE transactions FROM wbadm;
5950 GRANT ALL ON TABLE transactions TO wbadm;
5951 GRANT SELECT ON TABLE transactions TO PUBLIC;
5955 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5958 REVOKE ALL ON TABLE users FROM PUBLIC;
5959 REVOKE ALL ON TABLE users FROM wbadm;
5960 GRANT ALL ON TABLE users TO wbadm;
5961 GRANT SELECT ON TABLE users TO PUBLIC;
5965 -- PostgreSQL database dump complete