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: pkern; 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 pkern;
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: pkern; 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: pkg_history_timestamp; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2632 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
2635 SET search_path = alpha, pg_catalog;
2638 -- Name: packages_delete; Type: RULE; Schema: alpha; Owner: wbadm
2641 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));
2645 -- Name: packages_insert; Type: RULE; Schema: alpha; Owner: wbadm
2648 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);
2652 -- Name: packages_update; Type: RULE; Schema: alpha; Owner: wbadm
2655 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));
2659 -- Name: pkg_history_delete; Type: RULE; Schema: alpha; Owner: wbadm
2662 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"));
2666 -- Name: pkg_history_insert; Type: RULE; Schema: alpha; Owner: wbadm
2669 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);
2673 -- Name: pkg_history_update; Type: RULE; Schema: alpha; Owner: wbadm
2676 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"));
2680 -- Name: transactions_insert; Type: RULE; Schema: alpha; Owner: wbadm
2683 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");
2687 -- Name: users_delete; Type: RULE; Schema: alpha; Owner: wbadm
2690 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));
2694 -- Name: users_insert; Type: RULE; Schema: alpha; Owner: wbadm
2697 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);
2701 -- Name: users_update; Type: RULE; Schema: alpha; Owner: wbadm
2704 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));
2707 SET search_path = amd64, pg_catalog;
2710 -- Name: packages_delete; Type: RULE; Schema: amd64; Owner: wbadm
2713 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));
2717 -- Name: packages_insert; Type: RULE; Schema: amd64; Owner: wbadm
2720 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);
2724 -- Name: packages_update; Type: RULE; Schema: amd64; Owner: wbadm
2727 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));
2731 -- Name: pkg_history_delete; Type: RULE; Schema: amd64; Owner: wbadm
2734 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"));
2738 -- Name: pkg_history_insert; Type: RULE; Schema: amd64; Owner: wbadm
2741 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);
2745 -- Name: pkg_history_update; Type: RULE; Schema: amd64; Owner: wbadm
2748 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"));
2752 -- Name: transactions_insert; Type: RULE; Schema: amd64; Owner: wbadm
2755 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");
2759 -- Name: users_delete; Type: RULE; Schema: amd64; Owner: wbadm
2762 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));
2766 -- Name: users_insert; Type: RULE; Schema: amd64; Owner: wbadm
2769 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);
2773 -- Name: users_update; Type: RULE; Schema: amd64; Owner: wbadm
2776 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));
2779 SET search_path = arm, pg_catalog;
2782 -- Name: packages_delete; Type: RULE; Schema: arm; Owner: wbadm
2785 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));
2789 -- Name: packages_insert; Type: RULE; Schema: arm; Owner: wbadm
2792 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);
2796 -- Name: packages_update; Type: RULE; Schema: arm; Owner: wbadm
2799 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));
2803 -- Name: pkg_history_delete; Type: RULE; Schema: arm; Owner: wbadm
2806 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"));
2810 -- Name: pkg_history_insert; Type: RULE; Schema: arm; Owner: wbadm
2813 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);
2817 -- Name: pkg_history_update; Type: RULE; Schema: arm; Owner: wbadm
2820 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"));
2824 -- Name: transactions_insert; Type: RULE; Schema: arm; Owner: wbadm
2827 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");
2831 -- Name: users_delete; Type: RULE; Schema: arm; Owner: wbadm
2834 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));
2838 -- Name: users_insert; Type: RULE; Schema: arm; Owner: wbadm
2841 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);
2845 -- Name: users_update; Type: RULE; Schema: arm; Owner: wbadm
2848 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));
2851 SET search_path = armel, pg_catalog;
2854 -- Name: packages_delete; Type: RULE; Schema: armel; Owner: wbadm
2857 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));
2861 -- Name: packages_insert; Type: RULE; Schema: armel; Owner: wbadm
2864 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);
2868 -- Name: packages_update; Type: RULE; Schema: armel; Owner: wbadm
2871 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));
2875 -- Name: pkg_history_delete; Type: RULE; Schema: armel; Owner: wbadm
2878 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"));
2882 -- Name: pkg_history_insert; Type: RULE; Schema: armel; Owner: wbadm
2885 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);
2889 -- Name: pkg_history_update; Type: RULE; Schema: armel; Owner: wbadm
2892 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"));
2896 -- Name: transactions_insert; Type: RULE; Schema: armel; Owner: wbadm
2899 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");
2903 -- Name: users_delete; Type: RULE; Schema: armel; Owner: wbadm
2906 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));
2910 -- Name: users_insert; Type: RULE; Schema: armel; Owner: wbadm
2913 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);
2917 -- Name: users_update; Type: RULE; Schema: armel; Owner: wbadm
2920 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));
2923 SET search_path = armhf, pg_catalog;
2926 -- Name: packages_delete; Type: RULE; Schema: armhf; Owner: wbadm
2929 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));
2933 -- Name: packages_insert; Type: RULE; Schema: armhf; Owner: wbadm
2936 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);
2940 -- Name: packages_update; Type: RULE; Schema: armhf; Owner: wbadm
2943 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));
2947 -- Name: pkg_history_delete; Type: RULE; Schema: armhf; Owner: wbadm
2950 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"));
2954 -- Name: pkg_history_insert; Type: RULE; Schema: armhf; Owner: wbadm
2957 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);
2961 -- Name: pkg_history_update; Type: RULE; Schema: armhf; Owner: wbadm
2964 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"));
2968 -- Name: transactions_insert; Type: RULE; Schema: armhf; Owner: wbadm
2971 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");
2975 -- Name: users_delete; Type: RULE; Schema: armhf; Owner: wbadm
2978 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));
2982 -- Name: users_insert; Type: RULE; Schema: armhf; Owner: wbadm
2985 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);
2989 -- Name: users_update; Type: RULE; Schema: armhf; Owner: wbadm
2992 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));
2995 SET search_path = hppa, pg_catalog;
2998 -- Name: packages_delete; Type: RULE; Schema: hppa; Owner: wbadm
3001 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));
3005 -- Name: packages_insert; Type: RULE; Schema: hppa; Owner: wbadm
3008 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);
3012 -- Name: packages_update; Type: RULE; Schema: hppa; Owner: wbadm
3015 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));
3019 -- Name: pkg_history_delete; Type: RULE; Schema: hppa; Owner: wbadm
3022 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"));
3026 -- Name: pkg_history_insert; Type: RULE; Schema: hppa; Owner: wbadm
3029 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);
3033 -- Name: pkg_history_update; Type: RULE; Schema: hppa; Owner: wbadm
3036 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"));
3040 -- Name: transactions_insert; Type: RULE; Schema: hppa; Owner: wbadm
3043 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");
3047 -- Name: users_delete; Type: RULE; Schema: hppa; Owner: wbadm
3050 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));
3054 -- Name: users_insert; Type: RULE; Schema: hppa; Owner: wbadm
3057 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);
3061 -- Name: users_update; Type: RULE; Schema: hppa; Owner: wbadm
3064 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));
3067 SET search_path = "hurd-i386", pg_catalog;
3070 -- Name: packages_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3073 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));
3077 -- Name: packages_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3080 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);
3084 -- Name: packages_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3087 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));
3091 -- Name: pkg_history_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3094 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"));
3098 -- Name: pkg_history_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3101 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);
3105 -- Name: pkg_history_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3108 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"));
3112 -- Name: transactions_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3115 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");
3119 -- Name: users_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3122 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));
3126 -- Name: users_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3129 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);
3133 -- Name: users_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3136 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));
3139 SET search_path = i386, pg_catalog;
3142 -- Name: packages_delete; Type: RULE; Schema: i386; Owner: wbadm
3145 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));
3149 -- Name: packages_insert; Type: RULE; Schema: i386; Owner: wbadm
3152 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);
3156 -- Name: packages_update; Type: RULE; Schema: i386; Owner: wbadm
3159 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));
3163 -- Name: pkg_history_delete; Type: RULE; Schema: i386; Owner: wbadm
3166 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"));
3170 -- Name: pkg_history_insert; Type: RULE; Schema: i386; Owner: wbadm
3173 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);
3177 -- Name: pkg_history_update; Type: RULE; Schema: i386; Owner: wbadm
3180 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"));
3184 -- Name: transactions_insert; Type: RULE; Schema: i386; Owner: wbadm
3187 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");
3191 -- Name: users_delete; Type: RULE; Schema: i386; Owner: wbadm
3194 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));
3198 -- Name: users_insert; Type: RULE; Schema: i386; Owner: wbadm
3201 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);
3205 -- Name: users_update; Type: RULE; Schema: i386; Owner: wbadm
3208 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));
3211 SET search_path = ia64, pg_catalog;
3214 -- Name: packages_delete; Type: RULE; Schema: ia64; Owner: wbadm
3217 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));
3221 -- Name: packages_insert; Type: RULE; Schema: ia64; Owner: wbadm
3224 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);
3228 -- Name: packages_update; Type: RULE; Schema: ia64; Owner: wbadm
3231 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));
3235 -- Name: pkg_history_delete; Type: RULE; Schema: ia64; Owner: wbadm
3238 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"));
3242 -- Name: pkg_history_insert; Type: RULE; Schema: ia64; Owner: wbadm
3245 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);
3249 -- Name: pkg_history_update; Type: RULE; Schema: ia64; Owner: wbadm
3252 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"));
3256 -- Name: transactions_insert; Type: RULE; Schema: ia64; Owner: wbadm
3259 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");
3263 -- Name: users_delete; Type: RULE; Schema: ia64; Owner: wbadm
3266 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));
3270 -- Name: users_insert; Type: RULE; Schema: ia64; Owner: wbadm
3273 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);
3277 -- Name: users_update; Type: RULE; Schema: ia64; Owner: wbadm
3280 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));
3283 SET search_path = "kfreebsd-amd64", pg_catalog;
3286 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3289 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));
3293 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3296 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);
3300 -- Name: packages_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3303 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));
3307 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3310 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"));
3314 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3317 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);
3321 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3324 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"));
3328 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3331 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");
3335 -- Name: users_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3338 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));
3342 -- Name: users_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3345 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);
3349 -- Name: users_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3352 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));
3355 SET search_path = "kfreebsd-i386", pg_catalog;
3358 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3361 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));
3365 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3368 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);
3372 -- Name: packages_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3375 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));
3379 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3382 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"));
3386 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3389 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);
3393 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3396 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"));
3400 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3403 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");
3407 -- Name: users_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3410 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));
3414 -- Name: users_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3417 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);
3421 -- Name: users_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3424 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));
3427 SET search_path = mips, pg_catalog;
3430 -- Name: packages_delete; Type: RULE; Schema: mips; Owner: wbadm
3433 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));
3437 -- Name: packages_insert; Type: RULE; Schema: mips; Owner: wbadm
3440 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);
3444 -- Name: packages_update; Type: RULE; Schema: mips; Owner: wbadm
3447 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));
3451 -- Name: pkg_history_delete; Type: RULE; Schema: mips; Owner: wbadm
3454 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"));
3458 -- Name: pkg_history_insert; Type: RULE; Schema: mips; Owner: wbadm
3461 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);
3465 -- Name: pkg_history_update; Type: RULE; Schema: mips; Owner: wbadm
3468 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"));
3472 -- Name: transactions_insert; Type: RULE; Schema: mips; Owner: wbadm
3475 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");
3479 -- Name: users_delete; Type: RULE; Schema: mips; Owner: wbadm
3482 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));
3486 -- Name: users_insert; Type: RULE; Schema: mips; Owner: wbadm
3489 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);
3493 -- Name: users_update; Type: RULE; Schema: mips; Owner: wbadm
3496 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));
3499 SET search_path = mipsel, pg_catalog;
3502 -- Name: packages_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3505 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));
3509 -- Name: packages_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3512 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);
3516 -- Name: packages_update; Type: RULE; Schema: mipsel; Owner: wbadm
3519 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));
3523 -- Name: pkg_history_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3526 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"));
3530 -- Name: pkg_history_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3533 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);
3537 -- Name: pkg_history_update; Type: RULE; Schema: mipsel; Owner: wbadm
3540 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"));
3544 -- Name: transactions_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3547 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");
3551 -- Name: users_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3554 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));
3558 -- Name: users_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3561 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);
3565 -- Name: users_update; Type: RULE; Schema: mipsel; Owner: wbadm
3568 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));
3571 SET search_path = powerpc, pg_catalog;
3574 -- Name: packages_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3577 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));
3581 -- Name: packages_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3584 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);
3588 -- Name: packages_update; Type: RULE; Schema: powerpc; Owner: wbadm
3591 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));
3595 -- Name: pkg_history_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3598 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"));
3602 -- Name: pkg_history_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3605 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);
3609 -- Name: pkg_history_update; Type: RULE; Schema: powerpc; Owner: wbadm
3612 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"));
3616 -- Name: transactions_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3619 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");
3623 -- Name: users_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3626 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));
3630 -- Name: users_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3633 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);
3637 -- Name: users_update; Type: RULE; Schema: powerpc; Owner: wbadm
3640 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));
3643 SET search_path = s390, pg_catalog;
3646 -- Name: packages_delete; Type: RULE; Schema: s390; Owner: wbadm
3649 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));
3653 -- Name: packages_insert; Type: RULE; Schema: s390; Owner: wbadm
3656 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);
3660 -- Name: packages_update; Type: RULE; Schema: s390; Owner: wbadm
3663 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));
3667 -- Name: pkg_history_delete; Type: RULE; Schema: s390; Owner: wbadm
3670 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"));
3674 -- Name: pkg_history_insert; Type: RULE; Schema: s390; Owner: wbadm
3677 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);
3681 -- Name: pkg_history_update; Type: RULE; Schema: s390; Owner: wbadm
3684 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"));
3688 -- Name: transactions_insert; Type: RULE; Schema: s390; Owner: wbadm
3691 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");
3695 -- Name: users_delete; Type: RULE; Schema: s390; Owner: wbadm
3698 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));
3702 -- Name: users_insert; Type: RULE; Schema: s390; Owner: wbadm
3705 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);
3709 -- Name: users_update; Type: RULE; Schema: s390; Owner: wbadm
3712 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));
3715 SET search_path = s390x, pg_catalog;
3718 -- Name: packages_delete; Type: RULE; Schema: s390x; Owner: wbadm
3721 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));
3725 -- Name: packages_insert; Type: RULE; Schema: s390x; Owner: wbadm
3728 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);
3732 -- Name: packages_update; Type: RULE; Schema: s390x; Owner: wbadm
3735 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));
3739 -- Name: pkg_history_delete; Type: RULE; Schema: s390x; Owner: wbadm
3742 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"));
3746 -- Name: pkg_history_insert; Type: RULE; Schema: s390x; Owner: wbadm
3749 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);
3753 -- Name: pkg_history_update; Type: RULE; Schema: s390x; Owner: wbadm
3756 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"));
3760 -- Name: transactions_insert; Type: RULE; Schema: s390x; Owner: wbadm
3763 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");
3767 -- Name: users_delete; Type: RULE; Schema: s390x; Owner: wbadm
3770 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));
3774 -- Name: users_insert; Type: RULE; Schema: s390x; Owner: wbadm
3777 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);
3781 -- Name: users_update; Type: RULE; Schema: s390x; Owner: wbadm
3784 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));
3787 SET search_path = sparc, pg_catalog;
3790 -- Name: packages_delete; Type: RULE; Schema: sparc; Owner: wbadm
3793 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));
3797 -- Name: packages_insert; Type: RULE; Schema: sparc; Owner: wbadm
3800 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);
3804 -- Name: packages_update; Type: RULE; Schema: sparc; Owner: wbadm
3807 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));
3811 -- Name: pkg_history_delete; Type: RULE; Schema: sparc; Owner: wbadm
3814 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"));
3818 -- Name: pkg_history_insert; Type: RULE; Schema: sparc; Owner: wbadm
3821 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);
3825 -- Name: pkg_history_update; Type: RULE; Schema: sparc; Owner: wbadm
3828 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"));
3832 -- Name: transactions_insert; Type: RULE; Schema: sparc; Owner: wbadm
3835 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");
3839 -- Name: users_delete; Type: RULE; Schema: sparc; Owner: wbadm
3842 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));
3846 -- Name: users_insert; Type: RULE; Schema: sparc; Owner: wbadm
3849 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);
3853 -- Name: users_update; Type: RULE; Schema: sparc; Owner: wbadm
3856 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));
3859 SET search_path = public, pg_catalog;
3862 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3865 ALTER TABLE ONLY distribution_aliases
3866 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3870 -- Name: distribution_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3873 ALTER TABLE ONLY packages
3874 ADD CONSTRAINT distribution_architecture_fkey FOREIGN KEY (distribution, architecture) REFERENCES distribution_architectures(distribution, architecture);
3878 -- Name: packages_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3881 ALTER TABLE ONLY packages
3882 ADD CONSTRAINT packages_architecture_fkey FOREIGN KEY (architecture) REFERENCES architectures(architecture);
3886 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3889 ALTER TABLE ONLY packages
3890 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3894 -- Name: pkg_history_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3897 ALTER TABLE ONLY pkg_history
3898 ADD CONSTRAINT pkg_history_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3902 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
3905 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
3906 REVOKE ALL ON SCHEMA alpha FROM wbadm;
3907 GRANT ALL ON SCHEMA alpha TO wbadm;
3908 GRANT USAGE ON SCHEMA alpha TO alpha;
3909 GRANT USAGE ON SCHEMA alpha TO wb_all;
3910 GRANT USAGE ON SCHEMA alpha TO wb_security;
3914 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
3917 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
3918 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
3919 GRANT ALL ON SCHEMA alpha_public TO wbadm;
3920 GRANT USAGE ON SCHEMA alpha_public TO alpha;
3921 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
3925 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
3928 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
3929 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
3930 GRANT ALL ON SCHEMA amd64 TO wbadm;
3931 GRANT USAGE ON SCHEMA amd64 TO amd64;
3932 GRANT USAGE ON SCHEMA amd64 TO wb_all;
3933 GRANT USAGE ON SCHEMA amd64 TO wb_security;
3937 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
3940 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
3941 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
3942 GRANT ALL ON SCHEMA amd64_public TO wbadm;
3943 GRANT USAGE ON SCHEMA amd64_public TO amd64;
3944 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
3948 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
3951 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
3952 REVOKE ALL ON SCHEMA arm FROM wbadm;
3953 GRANT ALL ON SCHEMA arm TO wbadm;
3954 GRANT USAGE ON SCHEMA arm TO arm;
3955 GRANT USAGE ON SCHEMA arm TO wb_all;
3956 GRANT USAGE ON SCHEMA arm TO wb_security;
3960 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
3963 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
3964 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
3965 GRANT ALL ON SCHEMA arm_public TO wbadm;
3966 GRANT USAGE ON SCHEMA arm_public TO arm;
3967 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
3971 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
3974 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
3975 REVOKE ALL ON SCHEMA armel FROM wbadm;
3976 GRANT ALL ON SCHEMA armel TO wbadm;
3977 GRANT USAGE ON SCHEMA armel TO armel;
3978 GRANT USAGE ON SCHEMA armel TO wb_all;
3979 GRANT USAGE ON SCHEMA armel TO wb_security;
3983 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
3986 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
3987 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
3988 GRANT ALL ON SCHEMA armel_public TO wbadm;
3989 GRANT USAGE ON SCHEMA armel_public TO armel;
3990 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
3994 -- Name: armhf; Type: ACL; Schema: -; Owner: wbadm
3997 REVOKE ALL ON SCHEMA armhf FROM PUBLIC;
3998 REVOKE ALL ON SCHEMA armhf FROM wbadm;
3999 GRANT ALL ON SCHEMA armhf TO wbadm;
4000 GRANT USAGE ON SCHEMA armhf TO wb_all;
4001 GRANT USAGE ON SCHEMA armhf TO wb_security;
4005 -- Name: armhf_public; Type: ACL; Schema: -; Owner: wbadm
4008 REVOKE ALL ON SCHEMA armhf_public FROM PUBLIC;
4009 REVOKE ALL ON SCHEMA armhf_public FROM wbadm;
4010 GRANT ALL ON SCHEMA armhf_public TO wbadm;
4011 GRANT USAGE ON SCHEMA armhf_public TO PUBLIC;
4015 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4018 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4019 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4020 GRANT ALL ON SCHEMA hppa TO wbadm;
4021 GRANT USAGE ON SCHEMA hppa TO hppa;
4022 GRANT USAGE ON SCHEMA hppa TO wb_all;
4023 GRANT USAGE ON SCHEMA hppa TO wb_security;
4027 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4030 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4031 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4032 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4033 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4034 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4038 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4041 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4042 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4043 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4044 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4045 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4046 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4050 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4053 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4054 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4055 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4056 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4057 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4061 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4064 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4065 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4066 GRANT ALL ON SCHEMA i386 TO wbadm;
4067 GRANT USAGE ON SCHEMA i386 TO i386;
4068 GRANT USAGE ON SCHEMA i386 TO wb_all;
4069 GRANT USAGE ON SCHEMA i386 TO wb_security;
4073 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4076 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4077 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4078 GRANT ALL ON SCHEMA i386_public TO wbadm;
4079 GRANT USAGE ON SCHEMA i386_public TO i386;
4080 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4084 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4087 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4088 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4089 GRANT ALL ON SCHEMA ia64 TO wbadm;
4090 GRANT USAGE ON SCHEMA ia64 TO ia64;
4091 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4092 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4096 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4099 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4100 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4101 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4102 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4103 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4107 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4110 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4111 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4112 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4113 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4114 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4115 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4119 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4122 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4123 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4124 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4125 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4126 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4130 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4133 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4134 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4135 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4136 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4137 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4138 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4142 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4145 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4146 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4147 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4148 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4149 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4153 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4156 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4157 REVOKE ALL ON SCHEMA mips FROM wbadm;
4158 GRANT ALL ON SCHEMA mips TO wbadm;
4159 GRANT USAGE ON SCHEMA mips TO mips;
4160 GRANT USAGE ON SCHEMA mips TO wb_all;
4161 GRANT USAGE ON SCHEMA mips TO wb_security;
4165 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4168 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4169 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4170 GRANT ALL ON SCHEMA mips_public TO wbadm;
4171 GRANT USAGE ON SCHEMA mips_public TO mips;
4172 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4176 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4179 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4180 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4181 GRANT ALL ON SCHEMA mipsel TO wbadm;
4182 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4183 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4184 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4188 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4191 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4192 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4193 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4194 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4195 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4199 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4202 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4203 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4204 GRANT ALL ON SCHEMA powerpc TO wbadm;
4205 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4206 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4207 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4211 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4214 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4215 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4216 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4217 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4218 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4222 -- Name: public; Type: ACL; Schema: -; Owner: wbadm
4225 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4226 REVOKE ALL ON SCHEMA public FROM wbadm;
4227 GRANT ALL ON SCHEMA public TO wbadm;
4228 GRANT ALL ON SCHEMA public TO PUBLIC;
4232 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4235 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4236 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4237 GRANT ALL ON SCHEMA s390 TO wbadm;
4238 GRANT USAGE ON SCHEMA s390 TO s390;
4239 GRANT USAGE ON SCHEMA s390 TO wb_all;
4240 GRANT USAGE ON SCHEMA s390 TO wb_security;
4244 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4247 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4248 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4249 GRANT ALL ON SCHEMA s390_public TO wbadm;
4250 GRANT USAGE ON SCHEMA s390_public TO s390;
4251 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4255 -- Name: s390x; Type: ACL; Schema: -; Owner: wbadm
4258 REVOKE ALL ON SCHEMA s390x FROM PUBLIC;
4259 REVOKE ALL ON SCHEMA s390x FROM wbadm;
4260 GRANT ALL ON SCHEMA s390x TO wbadm;
4261 GRANT USAGE ON SCHEMA s390x TO wb_all;
4262 GRANT USAGE ON SCHEMA s390x TO wb_security;
4266 -- Name: s390x_public; Type: ACL; Schema: -; Owner: wbadm
4269 REVOKE ALL ON SCHEMA s390x_public FROM PUBLIC;
4270 REVOKE ALL ON SCHEMA s390x_public FROM wbadm;
4271 GRANT ALL ON SCHEMA s390x_public TO wbadm;
4272 GRANT USAGE ON SCHEMA s390x_public TO PUBLIC;
4276 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4279 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4280 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4281 GRANT ALL ON SCHEMA sparc TO wbadm;
4282 GRANT USAGE ON SCHEMA sparc TO sparc;
4283 GRANT USAGE ON SCHEMA sparc TO wb_all;
4284 GRANT USAGE ON SCHEMA sparc TO wb_security;
4288 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4291 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4292 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4293 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4294 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4295 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4299 -- Name: packages; Type: ACL; Schema: public; Owner: wbadm
4302 REVOKE ALL ON TABLE packages FROM PUBLIC;
4303 REVOKE ALL ON TABLE packages FROM wbadm;
4304 GRANT ALL ON TABLE packages TO wbadm;
4307 SET search_path = alpha, pg_catalog;
4310 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4313 REVOKE ALL ON TABLE packages FROM PUBLIC;
4314 REVOKE ALL ON TABLE packages FROM wbadm;
4315 GRANT ALL ON TABLE packages TO wbadm;
4316 GRANT SELECT ON TABLE packages TO wb_security;
4317 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4320 SET search_path = public, pg_catalog;
4323 -- Name: pkg_history; Type: ACL; Schema: public; Owner: wbadm
4326 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4327 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4328 GRANT ALL ON TABLE pkg_history TO wbadm;
4331 SET search_path = alpha, pg_catalog;
4334 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4337 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4338 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4339 GRANT ALL ON TABLE pkg_history TO wbadm;
4340 GRANT SELECT ON TABLE pkg_history TO wb_security;
4341 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4344 SET search_path = public, pg_catalog;
4347 -- Name: transactions; Type: ACL; Schema: public; Owner: wbadm
4350 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4351 REVOKE ALL ON TABLE transactions FROM wbadm;
4352 GRANT ALL ON TABLE transactions TO wbadm;
4355 SET search_path = alpha, pg_catalog;
4358 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4361 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4362 REVOKE ALL ON TABLE transactions FROM wbadm;
4363 GRANT ALL ON TABLE transactions TO wbadm;
4364 GRANT SELECT ON TABLE transactions TO wb_security;
4365 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4368 SET search_path = public, pg_catalog;
4371 -- Name: users; Type: ACL; Schema: public; Owner: wbadm
4374 REVOKE ALL ON TABLE users FROM PUBLIC;
4375 REVOKE ALL ON TABLE users FROM wbadm;
4376 GRANT ALL ON TABLE users TO wbadm;
4379 SET search_path = alpha, pg_catalog;
4382 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4385 REVOKE ALL ON TABLE users FROM PUBLIC;
4386 REVOKE ALL ON TABLE users FROM wbadm;
4387 GRANT ALL ON TABLE users TO wbadm;
4388 GRANT SELECT ON TABLE users TO wb_security;
4389 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4392 SET search_path = public, pg_catalog;
4395 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
4398 REVOKE ALL ON TABLE distributions FROM PUBLIC;
4399 REVOKE ALL ON TABLE distributions FROM wbadm;
4400 GRANT ALL ON TABLE distributions TO wbadm;
4401 GRANT SELECT ON TABLE distributions TO PUBLIC;
4404 SET search_path = alpha_public, pg_catalog;
4407 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4410 REVOKE ALL ON TABLE packages FROM PUBLIC;
4411 REVOKE ALL ON TABLE packages FROM wbadm;
4412 GRANT ALL ON TABLE packages TO wbadm;
4413 GRANT SELECT ON TABLE packages TO PUBLIC;
4417 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4420 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4421 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4422 GRANT ALL ON TABLE pkg_history TO wbadm;
4423 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4427 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4430 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4431 REVOKE ALL ON TABLE transactions FROM wbadm;
4432 GRANT ALL ON TABLE transactions TO wbadm;
4433 GRANT SELECT ON TABLE transactions TO PUBLIC;
4437 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4440 REVOKE ALL ON TABLE users FROM PUBLIC;
4441 REVOKE ALL ON TABLE users FROM wbadm;
4442 GRANT ALL ON TABLE users TO wbadm;
4443 GRANT SELECT ON TABLE users TO PUBLIC;
4446 SET search_path = amd64, pg_catalog;
4449 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4452 REVOKE ALL ON TABLE packages FROM PUBLIC;
4453 REVOKE ALL ON TABLE packages FROM wbadm;
4454 GRANT ALL ON TABLE packages TO wbadm;
4455 GRANT SELECT ON TABLE packages TO wb_security;
4456 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4460 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4463 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4464 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4465 GRANT ALL ON TABLE pkg_history TO wbadm;
4466 GRANT SELECT ON TABLE pkg_history TO wb_security;
4467 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4471 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4474 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4475 REVOKE ALL ON TABLE transactions FROM wbadm;
4476 GRANT ALL ON TABLE transactions TO wbadm;
4477 GRANT SELECT ON TABLE transactions TO wb_security;
4478 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4482 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4485 REVOKE ALL ON TABLE users FROM PUBLIC;
4486 REVOKE ALL ON TABLE users FROM wbadm;
4487 GRANT ALL ON TABLE users TO wbadm;
4488 GRANT SELECT ON TABLE users TO wb_security;
4489 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4492 SET search_path = amd64_public, pg_catalog;
4495 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4498 REVOKE ALL ON TABLE packages FROM PUBLIC;
4499 REVOKE ALL ON TABLE packages FROM wbadm;
4500 GRANT ALL ON TABLE packages TO wbadm;
4501 GRANT SELECT ON TABLE packages TO PUBLIC;
4505 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4508 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4509 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4510 GRANT ALL ON TABLE pkg_history TO wbadm;
4511 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4515 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4518 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4519 REVOKE ALL ON TABLE transactions FROM wbadm;
4520 GRANT ALL ON TABLE transactions TO wbadm;
4521 GRANT SELECT ON TABLE transactions TO PUBLIC;
4525 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4528 REVOKE ALL ON TABLE users FROM PUBLIC;
4529 REVOKE ALL ON TABLE users FROM wbadm;
4530 GRANT ALL ON TABLE users TO wbadm;
4531 GRANT SELECT ON TABLE users TO PUBLIC;
4534 SET search_path = arm, pg_catalog;
4537 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4540 REVOKE ALL ON TABLE packages FROM PUBLIC;
4541 REVOKE ALL ON TABLE packages FROM wbadm;
4542 GRANT ALL ON TABLE packages TO wbadm;
4543 GRANT SELECT ON TABLE packages TO wb_security;
4544 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4548 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4551 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4552 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4553 GRANT ALL ON TABLE pkg_history TO wbadm;
4554 GRANT SELECT ON TABLE pkg_history TO wb_security;
4555 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4559 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4562 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4563 REVOKE ALL ON TABLE transactions FROM wbadm;
4564 GRANT ALL ON TABLE transactions TO wbadm;
4565 GRANT SELECT ON TABLE transactions TO wb_security;
4566 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4570 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4573 REVOKE ALL ON TABLE users FROM PUBLIC;
4574 REVOKE ALL ON TABLE users FROM wbadm;
4575 GRANT ALL ON TABLE users TO wbadm;
4576 GRANT SELECT ON TABLE users TO wb_security;
4577 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4580 SET search_path = arm_public, pg_catalog;
4583 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4586 REVOKE ALL ON TABLE packages FROM PUBLIC;
4587 REVOKE ALL ON TABLE packages FROM wbadm;
4588 GRANT ALL ON TABLE packages TO wbadm;
4589 GRANT SELECT ON TABLE packages TO PUBLIC;
4593 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4596 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4597 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4598 GRANT ALL ON TABLE pkg_history TO wbadm;
4599 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4603 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4606 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4607 REVOKE ALL ON TABLE transactions FROM wbadm;
4608 GRANT ALL ON TABLE transactions TO wbadm;
4609 GRANT SELECT ON TABLE transactions TO PUBLIC;
4613 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4616 REVOKE ALL ON TABLE users FROM PUBLIC;
4617 REVOKE ALL ON TABLE users FROM wbadm;
4618 GRANT ALL ON TABLE users TO wbadm;
4619 GRANT SELECT ON TABLE users TO PUBLIC;
4622 SET search_path = armel, pg_catalog;
4625 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4628 REVOKE ALL ON TABLE packages FROM PUBLIC;
4629 REVOKE ALL ON TABLE packages FROM wbadm;
4630 GRANT ALL ON TABLE packages TO wbadm;
4631 GRANT SELECT ON TABLE packages TO wb_security;
4632 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4636 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4639 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4640 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4641 GRANT ALL ON TABLE pkg_history TO wbadm;
4642 GRANT SELECT ON TABLE pkg_history TO wb_security;
4643 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4647 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4650 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4651 REVOKE ALL ON TABLE transactions FROM wbadm;
4652 GRANT ALL ON TABLE transactions TO wbadm;
4653 GRANT SELECT ON TABLE transactions TO wb_security;
4654 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4658 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4661 REVOKE ALL ON TABLE users FROM PUBLIC;
4662 REVOKE ALL ON TABLE users FROM wbadm;
4663 GRANT ALL ON TABLE users TO wbadm;
4664 GRANT SELECT ON TABLE users TO wb_security;
4665 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4668 SET search_path = armel_public, pg_catalog;
4671 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4674 REVOKE ALL ON TABLE packages FROM PUBLIC;
4675 REVOKE ALL ON TABLE packages FROM wbadm;
4676 GRANT ALL ON TABLE packages TO wbadm;
4677 GRANT SELECT ON TABLE packages TO PUBLIC;
4681 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4684 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4685 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4686 GRANT ALL ON TABLE pkg_history TO wbadm;
4687 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4691 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4694 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4695 REVOKE ALL ON TABLE transactions FROM wbadm;
4696 GRANT ALL ON TABLE transactions TO wbadm;
4697 GRANT SELECT ON TABLE transactions TO PUBLIC;
4701 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4704 REVOKE ALL ON TABLE users FROM PUBLIC;
4705 REVOKE ALL ON TABLE users FROM wbadm;
4706 GRANT ALL ON TABLE users TO wbadm;
4707 GRANT SELECT ON TABLE users TO PUBLIC;
4710 SET search_path = armhf, pg_catalog;
4713 -- Name: packages; Type: ACL; Schema: armhf; Owner: wbadm
4716 REVOKE ALL ON TABLE packages FROM PUBLIC;
4717 REVOKE ALL ON TABLE packages FROM wbadm;
4718 GRANT ALL ON TABLE packages TO wbadm;
4719 GRANT SELECT ON TABLE packages TO wb_security;
4720 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4724 -- Name: pkg_history; Type: ACL; Schema: armhf; Owner: wbadm
4727 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4728 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4729 GRANT ALL ON TABLE pkg_history TO wbadm;
4730 GRANT SELECT ON TABLE pkg_history TO wb_security;
4731 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4735 -- Name: transactions; Type: ACL; Schema: armhf; Owner: wbadm
4738 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4739 REVOKE ALL ON TABLE transactions FROM wbadm;
4740 GRANT ALL ON TABLE transactions TO wbadm;
4741 GRANT SELECT ON TABLE transactions TO wb_security;
4742 GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
4746 -- Name: users; Type: ACL; Schema: armhf; Owner: wbadm
4749 REVOKE ALL ON TABLE users FROM PUBLIC;
4750 REVOKE ALL ON TABLE users FROM wbadm;
4751 GRANT ALL ON TABLE users TO wbadm;
4752 GRANT SELECT ON TABLE users TO wb_security;
4753 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4756 SET search_path = armhf_public, pg_catalog;
4759 -- Name: packages; Type: ACL; Schema: armhf_public; Owner: wbadm
4762 REVOKE ALL ON TABLE packages FROM PUBLIC;
4763 REVOKE ALL ON TABLE packages FROM wbadm;
4764 GRANT ALL ON TABLE packages TO wbadm;
4765 GRANT SELECT ON TABLE packages TO PUBLIC;
4769 -- Name: pkg_history; Type: ACL; Schema: armhf_public; Owner: wbadm
4772 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4773 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4774 GRANT ALL ON TABLE pkg_history TO wbadm;
4775 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4779 -- Name: transactions; Type: ACL; Schema: armhf_public; Owner: wbadm
4782 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4783 REVOKE ALL ON TABLE transactions FROM wbadm;
4784 GRANT ALL ON TABLE transactions TO wbadm;
4785 GRANT SELECT ON TABLE transactions TO PUBLIC;
4789 -- Name: users; Type: ACL; Schema: armhf_public; Owner: wbadm
4792 REVOKE ALL ON TABLE users FROM PUBLIC;
4793 REVOKE ALL ON TABLE users FROM wbadm;
4794 GRANT ALL ON TABLE users TO wbadm;
4795 GRANT SELECT ON TABLE users TO PUBLIC;
4798 SET search_path = hppa, pg_catalog;
4801 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4804 REVOKE ALL ON TABLE packages FROM PUBLIC;
4805 REVOKE ALL ON TABLE packages FROM wbadm;
4806 GRANT ALL ON TABLE packages TO wbadm;
4807 GRANT SELECT ON TABLE packages TO wb_security;
4808 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4812 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4815 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4816 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4817 GRANT ALL ON TABLE pkg_history TO wbadm;
4818 GRANT SELECT ON TABLE pkg_history TO wb_security;
4819 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4823 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4826 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4827 REVOKE ALL ON TABLE transactions FROM wbadm;
4828 GRANT ALL ON TABLE transactions TO wbadm;
4829 GRANT SELECT ON TABLE transactions TO wb_security;
4830 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4834 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4837 REVOKE ALL ON TABLE users FROM PUBLIC;
4838 REVOKE ALL ON TABLE users FROM wbadm;
4839 GRANT ALL ON TABLE users TO wbadm;
4840 GRANT SELECT ON TABLE users TO wb_security;
4841 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4844 SET search_path = hppa_public, pg_catalog;
4847 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4850 REVOKE ALL ON TABLE packages FROM PUBLIC;
4851 REVOKE ALL ON TABLE packages FROM wbadm;
4852 GRANT ALL ON TABLE packages TO wbadm;
4853 GRANT SELECT ON TABLE packages TO PUBLIC;
4857 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4860 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4861 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4862 GRANT ALL ON TABLE pkg_history TO wbadm;
4863 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4867 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4870 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4871 REVOKE ALL ON TABLE transactions FROM wbadm;
4872 GRANT ALL ON TABLE transactions TO wbadm;
4873 GRANT SELECT ON TABLE transactions TO PUBLIC;
4877 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4880 REVOKE ALL ON TABLE users FROM PUBLIC;
4881 REVOKE ALL ON TABLE users FROM wbadm;
4882 GRANT ALL ON TABLE users TO wbadm;
4883 GRANT SELECT ON TABLE users TO PUBLIC;
4886 SET search_path = "hurd-i386", pg_catalog;
4889 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4892 REVOKE ALL ON TABLE packages FROM PUBLIC;
4893 REVOKE ALL ON TABLE packages FROM wbadm;
4894 GRANT ALL ON TABLE packages TO wbadm;
4895 GRANT SELECT ON TABLE packages TO wb_security;
4896 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4900 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4903 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4904 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4905 GRANT ALL ON TABLE pkg_history TO wbadm;
4906 GRANT SELECT ON TABLE pkg_history TO wb_security;
4907 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4911 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4914 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4915 REVOKE ALL ON TABLE transactions FROM wbadm;
4916 GRANT ALL ON TABLE transactions TO wbadm;
4917 GRANT SELECT ON TABLE transactions TO wb_security;
4918 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4922 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4925 REVOKE ALL ON TABLE users FROM PUBLIC;
4926 REVOKE ALL ON TABLE users FROM wbadm;
4927 GRANT ALL ON TABLE users TO wbadm;
4928 GRANT SELECT ON TABLE users TO wb_security;
4929 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4932 SET search_path = "hurd-i386_public", pg_catalog;
4935 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4938 REVOKE ALL ON TABLE packages FROM PUBLIC;
4939 REVOKE ALL ON TABLE packages FROM wbadm;
4940 GRANT ALL ON TABLE packages TO wbadm;
4941 GRANT SELECT ON TABLE packages TO PUBLIC;
4945 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4948 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4949 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4950 GRANT ALL ON TABLE pkg_history TO wbadm;
4951 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4955 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4958 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4959 REVOKE ALL ON TABLE transactions FROM wbadm;
4960 GRANT ALL ON TABLE transactions TO wbadm;
4961 GRANT SELECT ON TABLE transactions TO PUBLIC;
4965 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4968 REVOKE ALL ON TABLE users FROM PUBLIC;
4969 REVOKE ALL ON TABLE users FROM wbadm;
4970 GRANT ALL ON TABLE users TO wbadm;
4971 GRANT SELECT ON TABLE users TO PUBLIC;
4974 SET search_path = i386, pg_catalog;
4977 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4980 REVOKE ALL ON TABLE packages FROM PUBLIC;
4981 REVOKE ALL ON TABLE packages FROM wbadm;
4982 GRANT ALL ON TABLE packages TO wbadm;
4983 GRANT SELECT ON TABLE packages TO wb_security;
4984 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4988 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4991 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4992 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4993 GRANT ALL ON TABLE pkg_history TO wbadm;
4994 GRANT SELECT ON TABLE pkg_history TO wb_security;
4995 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4999 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
5002 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5003 REVOKE ALL ON TABLE transactions FROM wbadm;
5004 GRANT ALL ON TABLE transactions TO wbadm;
5005 GRANT SELECT ON TABLE transactions TO wb_security;
5006 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5010 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
5013 REVOKE ALL ON TABLE users FROM PUBLIC;
5014 REVOKE ALL ON TABLE users FROM wbadm;
5015 GRANT ALL ON TABLE users TO wbadm;
5016 GRANT SELECT ON TABLE users TO wb_security;
5017 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5020 SET search_path = i386_public, pg_catalog;
5023 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5026 REVOKE ALL ON TABLE packages FROM PUBLIC;
5027 REVOKE ALL ON TABLE packages FROM wbadm;
5028 GRANT ALL ON TABLE packages TO wbadm;
5029 GRANT SELECT ON TABLE packages TO PUBLIC;
5033 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5036 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5037 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5038 GRANT ALL ON TABLE pkg_history TO wbadm;
5039 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5043 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5046 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5047 REVOKE ALL ON TABLE transactions FROM wbadm;
5048 GRANT ALL ON TABLE transactions TO wbadm;
5049 GRANT SELECT ON TABLE transactions TO PUBLIC;
5053 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5056 REVOKE ALL ON TABLE users FROM PUBLIC;
5057 REVOKE ALL ON TABLE users FROM wbadm;
5058 GRANT ALL ON TABLE users TO wbadm;
5059 GRANT SELECT ON TABLE users TO PUBLIC;
5062 SET search_path = ia64, pg_catalog;
5065 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5068 REVOKE ALL ON TABLE packages FROM PUBLIC;
5069 REVOKE ALL ON TABLE packages FROM wbadm;
5070 GRANT ALL ON TABLE packages TO wbadm;
5071 GRANT SELECT ON TABLE packages TO wb_security;
5072 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5076 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5079 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5080 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5081 GRANT ALL ON TABLE pkg_history TO wbadm;
5082 GRANT SELECT ON TABLE pkg_history TO wb_security;
5083 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5087 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5090 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5091 REVOKE ALL ON TABLE transactions FROM wbadm;
5092 GRANT ALL ON TABLE transactions TO wbadm;
5093 GRANT SELECT ON TABLE transactions TO wb_security;
5094 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5098 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5101 REVOKE ALL ON TABLE users FROM PUBLIC;
5102 REVOKE ALL ON TABLE users FROM wbadm;
5103 GRANT ALL ON TABLE users TO wbadm;
5104 GRANT SELECT ON TABLE users TO wb_security;
5105 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5108 SET search_path = ia64_public, pg_catalog;
5111 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5114 REVOKE ALL ON TABLE packages FROM PUBLIC;
5115 REVOKE ALL ON TABLE packages FROM wbadm;
5116 GRANT ALL ON TABLE packages TO wbadm;
5117 GRANT SELECT ON TABLE packages TO PUBLIC;
5121 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5124 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5125 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5126 GRANT ALL ON TABLE pkg_history TO wbadm;
5127 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5131 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5134 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5135 REVOKE ALL ON TABLE transactions FROM wbadm;
5136 GRANT ALL ON TABLE transactions TO wbadm;
5137 GRANT SELECT ON TABLE transactions TO PUBLIC;
5141 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5144 REVOKE ALL ON TABLE users FROM PUBLIC;
5145 REVOKE ALL ON TABLE users FROM wbadm;
5146 GRANT ALL ON TABLE users TO wbadm;
5147 GRANT SELECT ON TABLE users TO PUBLIC;
5150 SET search_path = "kfreebsd-amd64", pg_catalog;
5153 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5156 REVOKE ALL ON TABLE packages FROM PUBLIC;
5157 REVOKE ALL ON TABLE packages FROM wbadm;
5158 GRANT ALL ON TABLE packages TO wbadm;
5159 GRANT SELECT ON TABLE packages TO wb_security;
5160 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5164 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5167 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5168 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5169 GRANT ALL ON TABLE pkg_history TO wbadm;
5170 GRANT SELECT ON TABLE pkg_history TO wb_security;
5171 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5175 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5178 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5179 REVOKE ALL ON TABLE transactions FROM wbadm;
5180 GRANT ALL ON TABLE transactions TO wbadm;
5181 GRANT SELECT ON TABLE transactions TO wb_security;
5182 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5186 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5189 REVOKE ALL ON TABLE users FROM PUBLIC;
5190 REVOKE ALL ON TABLE users FROM wbadm;
5191 GRANT ALL ON TABLE users TO wbadm;
5192 GRANT SELECT ON TABLE users TO wb_security;
5193 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5196 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5199 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5202 REVOKE ALL ON TABLE packages FROM PUBLIC;
5203 REVOKE ALL ON TABLE packages FROM wbadm;
5204 GRANT ALL ON TABLE packages TO wbadm;
5205 GRANT SELECT ON TABLE packages TO PUBLIC;
5209 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5212 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5213 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5214 GRANT ALL ON TABLE pkg_history TO wbadm;
5215 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5219 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5222 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5223 REVOKE ALL ON TABLE transactions FROM wbadm;
5224 GRANT ALL ON TABLE transactions TO wbadm;
5225 GRANT SELECT ON TABLE transactions TO PUBLIC;
5229 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5232 REVOKE ALL ON TABLE users FROM PUBLIC;
5233 REVOKE ALL ON TABLE users FROM wbadm;
5234 GRANT ALL ON TABLE users TO wbadm;
5235 GRANT SELECT ON TABLE users TO PUBLIC;
5238 SET search_path = "kfreebsd-i386", pg_catalog;
5241 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5244 REVOKE ALL ON TABLE packages FROM PUBLIC;
5245 REVOKE ALL ON TABLE packages FROM wbadm;
5246 GRANT ALL ON TABLE packages TO wbadm;
5247 GRANT SELECT ON TABLE packages TO wb_security;
5248 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5252 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5255 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5256 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5257 GRANT ALL ON TABLE pkg_history TO wbadm;
5258 GRANT SELECT ON TABLE pkg_history TO wb_security;
5259 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5263 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5266 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5267 REVOKE ALL ON TABLE transactions FROM wbadm;
5268 GRANT ALL ON TABLE transactions TO wbadm;
5269 GRANT SELECT ON TABLE transactions TO wb_security;
5270 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5274 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5277 REVOKE ALL ON TABLE users FROM PUBLIC;
5278 REVOKE ALL ON TABLE users FROM wbadm;
5279 GRANT ALL ON TABLE users TO wbadm;
5280 GRANT SELECT ON TABLE users TO wb_security;
5281 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5284 SET search_path = "kfreebsd-i386_public", pg_catalog;
5287 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5290 REVOKE ALL ON TABLE packages FROM PUBLIC;
5291 REVOKE ALL ON TABLE packages FROM wbadm;
5292 GRANT ALL ON TABLE packages TO wbadm;
5293 GRANT SELECT ON TABLE packages TO PUBLIC;
5297 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5300 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5301 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5302 GRANT ALL ON TABLE pkg_history TO wbadm;
5303 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5307 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5310 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5311 REVOKE ALL ON TABLE transactions FROM wbadm;
5312 GRANT ALL ON TABLE transactions TO wbadm;
5313 GRANT SELECT ON TABLE transactions TO PUBLIC;
5317 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5320 REVOKE ALL ON TABLE users FROM PUBLIC;
5321 REVOKE ALL ON TABLE users FROM wbadm;
5322 GRANT ALL ON TABLE users TO wbadm;
5323 GRANT SELECT ON TABLE users TO PUBLIC;
5326 SET search_path = mips, pg_catalog;
5329 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5332 REVOKE ALL ON TABLE packages FROM PUBLIC;
5333 REVOKE ALL ON TABLE packages FROM wbadm;
5334 GRANT ALL ON TABLE packages TO wbadm;
5335 GRANT SELECT ON TABLE packages TO wb_security;
5336 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5340 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5343 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5344 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5345 GRANT ALL ON TABLE pkg_history TO wbadm;
5346 GRANT SELECT ON TABLE pkg_history TO wb_security;
5347 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5351 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5354 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5355 REVOKE ALL ON TABLE transactions FROM wbadm;
5356 GRANT ALL ON TABLE transactions TO wbadm;
5357 GRANT SELECT ON TABLE transactions TO wb_security;
5358 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5362 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5365 REVOKE ALL ON TABLE users FROM PUBLIC;
5366 REVOKE ALL ON TABLE users FROM wbadm;
5367 GRANT ALL ON TABLE users TO wbadm;
5368 GRANT SELECT ON TABLE users TO wb_security;
5369 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5372 SET search_path = mips_public, pg_catalog;
5375 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5378 REVOKE ALL ON TABLE packages FROM PUBLIC;
5379 REVOKE ALL ON TABLE packages FROM wbadm;
5380 GRANT ALL ON TABLE packages TO wbadm;
5381 GRANT SELECT ON TABLE packages TO PUBLIC;
5385 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5388 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5389 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5390 GRANT ALL ON TABLE pkg_history TO wbadm;
5391 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5395 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5398 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5399 REVOKE ALL ON TABLE transactions FROM wbadm;
5400 GRANT ALL ON TABLE transactions TO wbadm;
5401 GRANT SELECT ON TABLE transactions TO PUBLIC;
5405 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5408 REVOKE ALL ON TABLE users FROM PUBLIC;
5409 REVOKE ALL ON TABLE users FROM wbadm;
5410 GRANT ALL ON TABLE users TO wbadm;
5411 GRANT SELECT ON TABLE users TO PUBLIC;
5414 SET search_path = mipsel, pg_catalog;
5417 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5420 REVOKE ALL ON TABLE packages FROM PUBLIC;
5421 REVOKE ALL ON TABLE packages FROM wbadm;
5422 GRANT ALL ON TABLE packages TO wbadm;
5423 GRANT SELECT ON TABLE packages TO wb_security;
5424 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5428 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5431 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5432 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5433 GRANT ALL ON TABLE pkg_history TO wbadm;
5434 GRANT SELECT ON TABLE pkg_history TO wb_security;
5435 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5439 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5442 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5443 REVOKE ALL ON TABLE transactions FROM wbadm;
5444 GRANT ALL ON TABLE transactions TO wbadm;
5445 GRANT SELECT ON TABLE transactions TO wb_security;
5446 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5450 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5453 REVOKE ALL ON TABLE users FROM PUBLIC;
5454 REVOKE ALL ON TABLE users FROM wbadm;
5455 GRANT ALL ON TABLE users TO wbadm;
5456 GRANT SELECT ON TABLE users TO wb_security;
5457 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5460 SET search_path = mipsel_public, pg_catalog;
5463 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5466 REVOKE ALL ON TABLE packages FROM PUBLIC;
5467 REVOKE ALL ON TABLE packages FROM wbadm;
5468 GRANT ALL ON TABLE packages TO wbadm;
5469 GRANT SELECT ON TABLE packages TO PUBLIC;
5473 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5476 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5477 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5478 GRANT ALL ON TABLE pkg_history TO wbadm;
5479 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5483 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5486 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5487 REVOKE ALL ON TABLE transactions FROM wbadm;
5488 GRANT ALL ON TABLE transactions TO wbadm;
5489 GRANT SELECT ON TABLE transactions TO PUBLIC;
5493 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5496 REVOKE ALL ON TABLE users FROM PUBLIC;
5497 REVOKE ALL ON TABLE users FROM wbadm;
5498 GRANT ALL ON TABLE users TO wbadm;
5499 GRANT SELECT ON TABLE users TO PUBLIC;
5502 SET search_path = powerpc, pg_catalog;
5505 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5508 REVOKE ALL ON TABLE packages FROM PUBLIC;
5509 REVOKE ALL ON TABLE packages FROM wbadm;
5510 GRANT ALL ON TABLE packages TO wbadm;
5511 GRANT SELECT ON TABLE packages TO wb_security;
5512 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5516 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5519 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5520 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5521 GRANT ALL ON TABLE pkg_history TO wbadm;
5522 GRANT SELECT ON TABLE pkg_history TO wb_security;
5523 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5527 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5530 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5531 REVOKE ALL ON TABLE transactions FROM wbadm;
5532 GRANT ALL ON TABLE transactions TO wbadm;
5533 GRANT SELECT ON TABLE transactions TO wb_security;
5534 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5538 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5541 REVOKE ALL ON TABLE users FROM PUBLIC;
5542 REVOKE ALL ON TABLE users FROM wbadm;
5543 GRANT ALL ON TABLE users TO wbadm;
5544 GRANT SELECT ON TABLE users TO wb_security;
5545 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5548 SET search_path = powerpc_public, pg_catalog;
5551 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5554 REVOKE ALL ON TABLE packages FROM PUBLIC;
5555 REVOKE ALL ON TABLE packages FROM wbadm;
5556 GRANT ALL ON TABLE packages TO wbadm;
5557 GRANT SELECT ON TABLE packages TO PUBLIC;
5561 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5564 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5565 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5566 GRANT ALL ON TABLE pkg_history TO wbadm;
5567 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5571 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5574 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5575 REVOKE ALL ON TABLE transactions FROM wbadm;
5576 GRANT ALL ON TABLE transactions TO wbadm;
5577 GRANT SELECT ON TABLE transactions TO PUBLIC;
5581 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5584 REVOKE ALL ON TABLE users FROM PUBLIC;
5585 REVOKE ALL ON TABLE users FROM wbadm;
5586 GRANT ALL ON TABLE users TO wbadm;
5587 GRANT SELECT ON TABLE users TO PUBLIC;
5590 SET search_path = public, pg_catalog;
5593 -- Name: architectures; Type: ACL; Schema: public; Owner: wbadm
5596 REVOKE ALL ON TABLE architectures FROM PUBLIC;
5597 REVOKE ALL ON TABLE architectures FROM wbadm;
5598 GRANT ALL ON TABLE architectures TO wbadm;
5599 GRANT SELECT ON TABLE architectures TO PUBLIC;
5603 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5606 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5607 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5608 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5609 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5613 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5616 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5617 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5618 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5619 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5623 -- Name: distribution_architectures_statistics; Type: ACL; Schema: public; Owner: wbadm
5626 REVOKE ALL ON TABLE distribution_architectures_statistics FROM PUBLIC;
5627 REVOKE ALL ON TABLE distribution_architectures_statistics FROM wbadm;
5628 GRANT ALL ON TABLE distribution_architectures_statistics TO wbadm;
5629 GRANT SELECT ON TABLE distribution_architectures_statistics TO PUBLIC;
5633 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5636 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5637 REVOKE ALL ON TABLE lastlog FROM wbadm;
5638 GRANT ALL ON TABLE lastlog TO wbadm;
5639 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5643 -- Name: locks; Type: ACL; Schema: public; Owner: wbadm
5646 REVOKE ALL ON TABLE locks FROM PUBLIC;
5647 REVOKE ALL ON TABLE locks FROM wbadm;
5648 GRANT ALL ON TABLE locks TO wbadm;
5649 GRANT SELECT ON TABLE locks TO PUBLIC;
5650 GRANT UPDATE ON TABLE locks TO wb_all;
5654 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5657 REVOKE ALL ON TABLE log FROM PUBLIC;
5658 REVOKE ALL ON TABLE log FROM wbadm;
5659 GRANT ALL ON TABLE log TO wbadm;
5660 GRANT SELECT ON TABLE log TO PUBLIC;
5664 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5667 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5668 REVOKE ALL ON TABLE packages_all FROM wbadm;
5669 GRANT ALL ON TABLE packages_all TO wbadm;
5670 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5674 -- Name: packages_public; Type: ACL; Schema: public; Owner: wbadm
5677 REVOKE ALL ON TABLE packages_public FROM PUBLIC;
5678 REVOKE ALL ON TABLE packages_public FROM wbadm;
5679 GRANT ALL ON TABLE packages_public TO wbadm;
5680 GRANT SELECT ON TABLE packages_public TO PUBLIC;
5684 -- Name: priorities; Type: ACL; Schema: public; Owner: pkern
5687 REVOKE ALL ON TABLE priorities FROM PUBLIC;
5688 REVOKE ALL ON TABLE priorities FROM pkern;
5689 GRANT ALL ON TABLE priorities TO pkern;
5690 GRANT SELECT ON TABLE priorities TO PUBLIC;
5693 SET search_path = s390, pg_catalog;
5696 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5699 REVOKE ALL ON TABLE packages FROM PUBLIC;
5700 REVOKE ALL ON TABLE packages FROM wbadm;
5701 GRANT ALL ON TABLE packages TO wbadm;
5702 GRANT SELECT ON TABLE packages TO wb_security;
5703 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5707 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5710 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5711 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5712 GRANT ALL ON TABLE pkg_history TO wbadm;
5713 GRANT SELECT ON TABLE pkg_history TO wb_security;
5714 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5718 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5721 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5722 REVOKE ALL ON TABLE transactions FROM wbadm;
5723 GRANT ALL ON TABLE transactions TO wbadm;
5724 GRANT SELECT ON TABLE transactions TO wb_security;
5725 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5729 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5732 REVOKE ALL ON TABLE users FROM PUBLIC;
5733 REVOKE ALL ON TABLE users FROM wbadm;
5734 GRANT ALL ON TABLE users TO wbadm;
5735 GRANT SELECT ON TABLE users TO wb_security;
5736 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5739 SET search_path = s390_public, pg_catalog;
5742 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5745 REVOKE ALL ON TABLE packages FROM PUBLIC;
5746 REVOKE ALL ON TABLE packages FROM wbadm;
5747 GRANT ALL ON TABLE packages TO wbadm;
5748 GRANT SELECT ON TABLE packages TO PUBLIC;
5752 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5755 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5756 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5757 GRANT ALL ON TABLE pkg_history TO wbadm;
5758 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5762 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5765 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5766 REVOKE ALL ON TABLE transactions FROM wbadm;
5767 GRANT ALL ON TABLE transactions TO wbadm;
5768 GRANT SELECT ON TABLE transactions TO PUBLIC;
5772 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5775 REVOKE ALL ON TABLE users FROM PUBLIC;
5776 REVOKE ALL ON TABLE users FROM wbadm;
5777 GRANT ALL ON TABLE users TO wbadm;
5778 GRANT SELECT ON TABLE users TO PUBLIC;
5781 SET search_path = s390x, pg_catalog;
5784 -- Name: packages; Type: ACL; Schema: s390x; Owner: wbadm
5787 REVOKE ALL ON TABLE packages FROM PUBLIC;
5788 REVOKE ALL ON TABLE packages FROM wbadm;
5789 GRANT ALL ON TABLE packages TO wbadm;
5790 GRANT SELECT ON TABLE packages TO wb_security;
5791 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5795 -- Name: pkg_history; Type: ACL; Schema: s390x; Owner: wbadm
5798 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5799 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5800 GRANT ALL ON TABLE pkg_history TO wbadm;
5801 GRANT SELECT ON TABLE pkg_history TO wb_security;
5802 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5806 -- Name: transactions; Type: ACL; Schema: s390x; Owner: wbadm
5809 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5810 REVOKE ALL ON TABLE transactions FROM wbadm;
5811 GRANT ALL ON TABLE transactions TO wbadm;
5812 GRANT SELECT ON TABLE transactions TO wb_security;
5813 GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
5817 -- Name: users; Type: ACL; Schema: s390x; Owner: wbadm
5820 REVOKE ALL ON TABLE users FROM PUBLIC;
5821 REVOKE ALL ON TABLE users FROM wbadm;
5822 GRANT ALL ON TABLE users TO wbadm;
5823 GRANT SELECT ON TABLE users TO wb_security;
5824 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5827 SET search_path = s390x_public, pg_catalog;
5830 -- Name: packages; Type: ACL; Schema: s390x_public; Owner: wbadm
5833 REVOKE ALL ON TABLE packages FROM PUBLIC;
5834 REVOKE ALL ON TABLE packages FROM wbadm;
5835 GRANT ALL ON TABLE packages TO wbadm;
5836 GRANT SELECT ON TABLE packages TO PUBLIC;
5840 -- Name: pkg_history; Type: ACL; Schema: s390x_public; Owner: wbadm
5843 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5844 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5845 GRANT ALL ON TABLE pkg_history TO wbadm;
5846 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5850 -- Name: transactions; Type: ACL; Schema: s390x_public; Owner: wbadm
5853 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5854 REVOKE ALL ON TABLE transactions FROM wbadm;
5855 GRANT ALL ON TABLE transactions TO wbadm;
5856 GRANT SELECT ON TABLE transactions TO PUBLIC;
5860 -- Name: users; Type: ACL; Schema: s390x_public; Owner: wbadm
5863 REVOKE ALL ON TABLE users FROM PUBLIC;
5864 REVOKE ALL ON TABLE users FROM wbadm;
5865 GRANT ALL ON TABLE users TO wbadm;
5866 GRANT SELECT ON TABLE users TO PUBLIC;
5869 SET search_path = sparc, pg_catalog;
5872 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5875 REVOKE ALL ON TABLE packages FROM PUBLIC;
5876 REVOKE ALL ON TABLE packages FROM wbadm;
5877 GRANT ALL ON TABLE packages TO wbadm;
5878 GRANT SELECT ON TABLE packages TO wb_security;
5879 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5883 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5886 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5887 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5888 GRANT ALL ON TABLE pkg_history TO wbadm;
5889 GRANT SELECT ON TABLE pkg_history TO wb_security;
5890 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5894 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5897 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5898 REVOKE ALL ON TABLE transactions FROM wbadm;
5899 GRANT ALL ON TABLE transactions TO wbadm;
5900 GRANT SELECT ON TABLE transactions TO wb_security;
5901 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5905 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5908 REVOKE ALL ON TABLE users FROM PUBLIC;
5909 REVOKE ALL ON TABLE users FROM wbadm;
5910 GRANT ALL ON TABLE users TO wbadm;
5911 GRANT SELECT ON TABLE users TO wb_security;
5912 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5915 SET search_path = sparc_public, pg_catalog;
5918 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5921 REVOKE ALL ON TABLE packages FROM PUBLIC;
5922 REVOKE ALL ON TABLE packages FROM wbadm;
5923 GRANT ALL ON TABLE packages TO wbadm;
5924 GRANT SELECT ON TABLE packages TO PUBLIC;
5928 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5931 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5932 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5933 GRANT ALL ON TABLE pkg_history TO wbadm;
5934 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5938 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5941 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5942 REVOKE ALL ON TABLE transactions FROM wbadm;
5943 GRANT ALL ON TABLE transactions TO wbadm;
5944 GRANT SELECT ON TABLE transactions TO PUBLIC;
5948 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5951 REVOKE ALL ON TABLE users FROM PUBLIC;
5952 REVOKE ALL ON TABLE users FROM wbadm;
5953 GRANT ALL ON TABLE users TO wbadm;
5954 GRANT SELECT ON TABLE users TO PUBLIC;
5958 -- PostgreSQL database dump complete