2 -- PostgreSQL database dump
5 SET statement_timeout = 0;
6 SET client_encoding = 'SQL_ASCII';
7 SET standard_conforming_strings = off;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
10 SET escape_string_warning = off;
13 -- Name: alpha; Type: SCHEMA; Schema: -; Owner: wbadm
19 ALTER SCHEMA alpha OWNER TO wbadm;
22 -- Name: alpha_public; Type: SCHEMA; Schema: -; Owner: wbadm
25 CREATE SCHEMA alpha_public;
28 ALTER SCHEMA alpha_public OWNER TO wbadm;
31 -- Name: amd64; Type: SCHEMA; Schema: -; Owner: wbadm
37 ALTER SCHEMA amd64 OWNER TO wbadm;
40 -- Name: amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
43 CREATE SCHEMA amd64_public;
46 ALTER SCHEMA amd64_public OWNER TO wbadm;
49 -- Name: arm; Type: SCHEMA; Schema: -; Owner: wbadm
55 ALTER SCHEMA arm OWNER TO wbadm;
58 -- Name: arm_public; Type: SCHEMA; Schema: -; Owner: wbadm
61 CREATE SCHEMA arm_public;
64 ALTER SCHEMA arm_public OWNER TO wbadm;
67 -- Name: armel; Type: SCHEMA; Schema: -; Owner: wbadm
73 ALTER SCHEMA armel OWNER TO wbadm;
76 -- Name: armel_public; Type: SCHEMA; Schema: -; Owner: wbadm
79 CREATE SCHEMA armel_public;
82 ALTER SCHEMA armel_public OWNER TO wbadm;
85 -- Name: armhf; Type: SCHEMA; Schema: -; Owner: wbadm
91 ALTER SCHEMA armhf OWNER TO wbadm;
94 -- Name: armhf_public; Type: SCHEMA; Schema: -; Owner: wbadm
97 CREATE SCHEMA armhf_public;
100 ALTER SCHEMA armhf_public OWNER TO wbadm;
103 -- Name: hppa; Type: SCHEMA; Schema: -; Owner: wbadm
109 ALTER SCHEMA hppa OWNER TO wbadm;
112 -- Name: hppa_public; Type: SCHEMA; Schema: -; Owner: wbadm
115 CREATE SCHEMA hppa_public;
118 ALTER SCHEMA hppa_public OWNER TO wbadm;
121 -- Name: hurd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
124 CREATE SCHEMA "hurd-i386";
127 ALTER SCHEMA "hurd-i386" OWNER TO wbadm;
130 -- Name: hurd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
133 CREATE SCHEMA "hurd-i386_public";
136 ALTER SCHEMA "hurd-i386_public" OWNER TO wbadm;
139 -- Name: i386; Type: SCHEMA; Schema: -; Owner: wbadm
145 ALTER SCHEMA i386 OWNER TO wbadm;
148 -- Name: i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
151 CREATE SCHEMA i386_public;
154 ALTER SCHEMA i386_public OWNER TO wbadm;
157 -- Name: ia64; Type: SCHEMA; Schema: -; Owner: wbadm
163 ALTER SCHEMA ia64 OWNER TO wbadm;
166 -- Name: ia64_public; Type: SCHEMA; Schema: -; Owner: wbadm
169 CREATE SCHEMA ia64_public;
172 ALTER SCHEMA ia64_public OWNER TO wbadm;
175 -- Name: kfreebsd-amd64; Type: SCHEMA; Schema: -; Owner: wbadm
178 CREATE SCHEMA "kfreebsd-amd64";
181 ALTER SCHEMA "kfreebsd-amd64" OWNER TO wbadm;
184 -- Name: kfreebsd-amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
187 CREATE SCHEMA "kfreebsd-amd64_public";
190 ALTER SCHEMA "kfreebsd-amd64_public" OWNER TO wbadm;
193 -- Name: kfreebsd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
196 CREATE SCHEMA "kfreebsd-i386";
199 ALTER SCHEMA "kfreebsd-i386" OWNER TO wbadm;
202 -- Name: kfreebsd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
205 CREATE SCHEMA "kfreebsd-i386_public";
208 ALTER SCHEMA "kfreebsd-i386_public" OWNER TO wbadm;
211 -- Name: mips; Type: SCHEMA; Schema: -; Owner: wbadm
217 ALTER SCHEMA mips OWNER TO wbadm;
220 -- Name: mips_public; Type: SCHEMA; Schema: -; Owner: wbadm
223 CREATE SCHEMA mips_public;
226 ALTER SCHEMA mips_public OWNER TO wbadm;
229 -- Name: mipsel; Type: SCHEMA; Schema: -; Owner: wbadm
232 CREATE SCHEMA mipsel;
235 ALTER SCHEMA mipsel OWNER TO wbadm;
238 -- Name: mipsel_public; Type: SCHEMA; Schema: -; Owner: wbadm
241 CREATE SCHEMA mipsel_public;
244 ALTER SCHEMA mipsel_public OWNER TO wbadm;
247 -- Name: powerpc; Type: SCHEMA; Schema: -; Owner: wbadm
250 CREATE SCHEMA powerpc;
253 ALTER SCHEMA powerpc OWNER TO wbadm;
256 -- Name: powerpc_public; Type: SCHEMA; Schema: -; Owner: wbadm
259 CREATE SCHEMA powerpc_public;
262 ALTER SCHEMA powerpc_public OWNER TO wbadm;
265 -- Name: s390; Type: SCHEMA; Schema: -; Owner: wbadm
271 ALTER SCHEMA s390 OWNER TO wbadm;
274 -- Name: s390_public; Type: SCHEMA; Schema: -; Owner: wbadm
277 CREATE SCHEMA s390_public;
280 ALTER SCHEMA s390_public OWNER TO wbadm;
283 -- Name: s390x; Type: SCHEMA; Schema: -; Owner: wbadm
289 ALTER SCHEMA s390x OWNER TO wbadm;
292 -- Name: s390x_public; Type: SCHEMA; Schema: -; Owner: wbadm
295 CREATE SCHEMA s390x_public;
298 ALTER SCHEMA s390x_public OWNER TO wbadm;
301 -- Name: sparc; Type: SCHEMA; Schema: -; Owner: wbadm
307 ALTER SCHEMA sparc OWNER TO wbadm;
310 -- Name: sparc_public; Type: SCHEMA; Schema: -; Owner: wbadm
313 CREATE SCHEMA sparc_public;
316 ALTER SCHEMA sparc_public OWNER TO wbadm;
319 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: wbadm
322 CREATE PROCEDURAL LANGUAGE plpgsql;
325 ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO wbadm;
327 SET search_path = public, pg_catalog;
330 -- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres
333 CREATE TYPE debversion;
337 -- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres
340 CREATE FUNCTION debversionin(cstring) RETURNS debversion
341 LANGUAGE internal IMMUTABLE STRICT
345 ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres;
348 -- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres
351 CREATE FUNCTION debversionout(debversion) RETURNS cstring
352 LANGUAGE internal IMMUTABLE STRICT
356 ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres;
359 -- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres
362 CREATE FUNCTION debversionrecv(internal) RETURNS debversion
363 LANGUAGE internal STABLE STRICT
367 ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres;
370 -- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres
373 CREATE FUNCTION debversionsend(debversion) RETURNS bytea
374 LANGUAGE internal STABLE STRICT
378 ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres;
381 -- Name: debversion; Type: TYPE; Schema: public; Owner: postgres
384 CREATE TYPE debversion (
385 INTERNALLENGTH = variable,
386 INPUT = debversionin,
387 OUTPUT = debversionout,
388 RECEIVE = debversionrecv,
389 SEND = debversionsend,
396 ALTER TYPE public.debversion OWNER TO postgres;
399 -- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres
402 COMMENT ON TYPE debversion IS 'Debian package version number';
406 -- Name: commacat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
409 CREATE FUNCTION commacat(acc text, instr text) RETURNS text
413 IF acc IS NULL OR acc = '' THEN
416 RETURN acc || ', ' || instr;
422 ALTER FUNCTION public.commacat(acc text, instr text) OWNER TO pkern;
425 -- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres
428 CREATE FUNCTION debversion(character) RETURNS debversion
429 LANGUAGE internal IMMUTABLE STRICT
433 ALTER FUNCTION public.debversion(character) OWNER TO postgres;
436 -- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
439 CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer
440 LANGUAGE c IMMUTABLE STRICT
441 AS '$libdir/debversion', 'debversion_cmp';
444 ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres;
447 -- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
450 COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions';
454 -- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
457 CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean
458 LANGUAGE c IMMUTABLE STRICT
459 AS '$libdir/debversion', 'debversion_eq';
462 ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres;
465 -- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
468 COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal';
472 -- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
475 CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean
476 LANGUAGE c IMMUTABLE STRICT
477 AS '$libdir/debversion', 'debversion_ge';
480 ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres;
483 -- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
486 COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal';
490 -- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
493 CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean
494 LANGUAGE c IMMUTABLE STRICT
495 AS '$libdir/debversion', 'debversion_gt';
498 ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres;
501 -- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
504 COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than';
508 -- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres
511 CREATE FUNCTION debversion_hash(debversion) RETURNS integer
512 LANGUAGE c IMMUTABLE STRICT
513 AS '$libdir/debversion', 'debversion_hash';
516 ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres;
519 -- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
522 CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion
523 LANGUAGE c IMMUTABLE STRICT
524 AS '$libdir/debversion', 'debversion_larger';
527 ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres;
530 -- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
533 CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean
534 LANGUAGE c IMMUTABLE STRICT
535 AS '$libdir/debversion', 'debversion_le';
538 ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres;
541 -- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
544 COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal';
548 -- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
551 CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean
552 LANGUAGE c IMMUTABLE STRICT
553 AS '$libdir/debversion', 'debversion_lt';
556 ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres;
559 -- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
562 COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than';
566 -- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
569 CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean
570 LANGUAGE c IMMUTABLE STRICT
571 AS '$libdir/debversion', 'debversion_ne';
574 ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres;
577 -- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
580 COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal';
584 -- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
587 CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion
588 LANGUAGE c IMMUTABLE STRICT
589 AS '$libdir/debversion', 'debversion_smaller';
592 ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres;
595 -- Name: query_source_package(character varying, character varying); Type: FUNCTION; Schema: public; Owner: wbadm
598 CREATE FUNCTION query_source_package(param_dist character varying, param_srcpkg character varying) RETURNS SETOF record
602 RETURN QUERY SELECT packages.architecture, packages.package, packages.distribution, packages.version::character varying, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM packages_public packages WHERE distribution = param_dist AND package = param_srcpkg;
607 ALTER FUNCTION public.query_source_package(param_dist character varying, param_srcpkg character varying) OWNER TO wbadm;
610 -- Name: spacecat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
613 CREATE FUNCTION spacecat(acc text, instr text) RETURNS text
617 IF acc IS NULL OR acc = '' THEN
620 RETURN acc || ' ' || instr;
626 ALTER FUNCTION public.spacecat(acc text, instr text) OWNER TO pkern;
629 -- Name: commacat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
632 CREATE AGGREGATE commacat_all(text) (
639 ALTER AGGREGATE public.commacat_all(text) OWNER TO pkern;
642 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
646 PROCEDURE = debversion_gt,
647 LEFTARG = debversion,
648 RIGHTARG = debversion,
654 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
657 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
660 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
664 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
667 CREATE AGGREGATE max(debversion) (
668 SFUNC = debversion_larger,
674 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
677 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
681 PROCEDURE = debversion_lt,
682 LEFTARG = debversion,
683 RIGHTARG = debversion,
689 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
692 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
695 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
699 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
702 CREATE AGGREGATE min(debversion) (
703 SFUNC = debversion_smaller,
709 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
712 -- Name: spacecat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
715 CREATE AGGREGATE spacecat_all(text) (
722 ALTER AGGREGATE public.spacecat_all(text) OWNER TO pkern;
725 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
729 PROCEDURE = debversion_le,
730 LEFTARG = debversion,
731 RIGHTARG = debversion,
737 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
740 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
743 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
747 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
751 PROCEDURE = debversion_ne,
752 LEFTARG = debversion,
753 RIGHTARG = debversion,
759 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
762 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
765 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
769 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
773 PROCEDURE = debversion_eq,
774 LEFTARG = debversion,
775 RIGHTARG = debversion,
781 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
784 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
787 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
791 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
795 PROCEDURE = debversion_ge,
796 LEFTARG = debversion,
797 RIGHTARG = debversion,
803 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
806 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
809 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
813 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
816 CREATE OPERATOR CLASS debversion_ops
817 DEFAULT FOR TYPE debversion USING btree AS
818 OPERATOR 1 <(debversion,debversion) ,
819 OPERATOR 2 <=(debversion,debversion) ,
820 OPERATOR 3 =(debversion,debversion) ,
821 OPERATOR 4 >=(debversion,debversion) ,
822 OPERATOR 5 >(debversion,debversion) ,
823 FUNCTION 1 debversion_cmp(debversion,debversion);
826 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
829 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
832 CREATE OPERATOR CLASS debversion_ops
833 DEFAULT FOR TYPE debversion USING hash AS
834 OPERATOR 1 =(debversion,debversion) ,
835 FUNCTION 1 debversion_hash(debversion);
838 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
840 SET search_path = pg_catalog;
843 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
846 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
850 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
853 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
857 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
860 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
864 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
867 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
871 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
874 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
878 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
881 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
884 SET search_path = public, pg_catalog;
886 SET default_tablespace = '';
888 SET default_with_oids = false;
891 -- Name: packages; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
894 CREATE TABLE packages (
895 architecture character varying NOT NULL,
896 package character varying NOT NULL,
897 distribution character varying NOT NULL,
899 state character varying,
900 section character varying,
901 priority character varying,
902 installed_version character varying,
903 previous_state character varying,
904 state_change timestamp without time zone,
905 notes character varying,
906 builder character varying,
909 binary_nmu_version integer,
910 binary_nmu_changelog character varying,
911 failed_category character varying,
912 permbuildpri integer,
914 depends character varying,
915 rel character varying,
917 extra_depends character varying,
918 extra_conflicts character varying,
919 build_arch_all boolean DEFAULT false
923 ALTER TABLE public.packages OWNER TO wbadm;
925 SET search_path = alpha, pg_catalog;
928 -- Name: packages; Type: VIEW; Schema: alpha; Owner: wbadm
931 CREATE VIEW packages AS
932 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'alpha'::text);
935 ALTER TABLE alpha.packages OWNER TO wbadm;
937 SET search_path = public, pg_catalog;
940 -- Name: pkg_history; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
943 CREATE TABLE pkg_history (
944 architecture character varying NOT NULL,
945 package character varying NOT NULL,
946 distribution character varying NOT NULL,
947 version debversion NOT NULL,
948 "timestamp" timestamp without time zone NOT NULL,
949 result character varying NOT NULL,
952 builder character varying
956 ALTER TABLE public.pkg_history OWNER TO wbadm;
958 SET search_path = alpha, pg_catalog;
961 -- Name: pkg_history; Type: VIEW; Schema: alpha; Owner: wbadm
964 CREATE VIEW pkg_history AS
965 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'alpha'::text);
968 ALTER TABLE alpha.pkg_history OWNER TO wbadm;
970 SET search_path = public, pg_catalog;
973 -- Name: transactions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
976 CREATE TABLE transactions (
977 architecture character varying,
978 package character varying,
979 distribution character varying,
981 action character varying,
982 prevstate character varying,
983 state character varying,
984 real_user character varying,
985 set_user character varying,
986 "time" timestamp without time zone
990 ALTER TABLE public.transactions OWNER TO wbadm;
992 SET search_path = alpha, pg_catalog;
995 -- Name: transactions; Type: VIEW; Schema: alpha; Owner: wbadm
998 CREATE VIEW transactions AS
999 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'alpha'::text);
1002 ALTER TABLE alpha.transactions OWNER TO wbadm;
1004 SET search_path = public, pg_catalog;
1007 -- Name: users; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
1010 CREATE TABLE users (
1011 architecture character varying NOT NULL,
1012 username character varying NOT NULL,
1013 distribution character varying NOT NULL,
1014 last_seen timestamp without time zone
1018 ALTER TABLE public.users OWNER TO wbadm;
1020 SET search_path = alpha, pg_catalog;
1023 -- Name: users; Type: VIEW; Schema: alpha; Owner: wbadm
1026 CREATE VIEW users AS
1027 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'alpha'::text);
1030 ALTER TABLE alpha.users OWNER TO wbadm;
1032 SET search_path = public, pg_catalog;
1035 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
1038 CREATE TABLE distributions (
1039 distribution character varying NOT NULL,
1040 public boolean DEFAULT true NOT NULL,
1041 sort_order integer DEFAULT 0,
1042 auto_dep_wait boolean DEFAULT true,
1043 build_dep_resolver character varying,
1044 archive character varying,
1045 suppress_successful_logs boolean DEFAULT false NOT NULL
1049 ALTER TABLE public.distributions OWNER TO wbadm;
1051 SET search_path = alpha_public, pg_catalog;
1054 -- Name: packages; Type: VIEW; Schema: alpha_public; Owner: wbadm
1057 CREATE VIEW packages AS
1058 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'alpha'::text));
1061 ALTER TABLE alpha_public.packages OWNER TO wbadm;
1064 -- Name: pkg_history; Type: VIEW; Schema: alpha_public; Owner: wbadm
1067 CREATE VIEW pkg_history AS
1068 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'alpha'::text));
1071 ALTER TABLE alpha_public.pkg_history OWNER TO wbadm;
1074 -- Name: transactions; Type: VIEW; Schema: alpha_public; Owner: wbadm
1077 CREATE VIEW transactions AS
1078 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'alpha'::text));
1081 ALTER TABLE alpha_public.transactions OWNER TO wbadm;
1084 -- Name: users; Type: VIEW; Schema: alpha_public; Owner: wbadm
1087 CREATE VIEW users AS
1088 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'alpha'::text));
1091 ALTER TABLE alpha_public.users OWNER TO wbadm;
1093 SET search_path = amd64, pg_catalog;
1096 -- Name: packages; Type: VIEW; Schema: amd64; Owner: wbadm
1099 CREATE VIEW packages AS
1100 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'amd64'::text);
1103 ALTER TABLE amd64.packages OWNER TO wbadm;
1106 -- Name: pkg_history; Type: VIEW; Schema: amd64; Owner: wbadm
1109 CREATE VIEW pkg_history AS
1110 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'amd64'::text);
1113 ALTER TABLE amd64.pkg_history OWNER TO wbadm;
1116 -- Name: transactions; Type: VIEW; Schema: amd64; Owner: wbadm
1119 CREATE VIEW transactions AS
1120 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'amd64'::text);
1123 ALTER TABLE amd64.transactions OWNER TO wbadm;
1126 -- Name: users; Type: VIEW; Schema: amd64; Owner: wbadm
1129 CREATE VIEW users AS
1130 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'amd64'::text);
1133 ALTER TABLE amd64.users OWNER TO wbadm;
1135 SET search_path = amd64_public, pg_catalog;
1138 -- Name: packages; Type: VIEW; Schema: amd64_public; Owner: wbadm
1141 CREATE VIEW packages AS
1142 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'amd64'::text));
1145 ALTER TABLE amd64_public.packages OWNER TO wbadm;
1148 -- Name: pkg_history; Type: VIEW; Schema: amd64_public; Owner: wbadm
1151 CREATE VIEW pkg_history AS
1152 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'amd64'::text));
1155 ALTER TABLE amd64_public.pkg_history OWNER TO wbadm;
1158 -- Name: transactions; Type: VIEW; Schema: amd64_public; Owner: wbadm
1161 CREATE VIEW transactions AS
1162 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'amd64'::text));
1165 ALTER TABLE amd64_public.transactions OWNER TO wbadm;
1168 -- Name: users; Type: VIEW; Schema: amd64_public; Owner: wbadm
1171 CREATE VIEW users AS
1172 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'amd64'::text));
1175 ALTER TABLE amd64_public.users OWNER TO wbadm;
1177 SET search_path = arm, pg_catalog;
1180 -- Name: packages; Type: VIEW; Schema: arm; Owner: wbadm
1183 CREATE VIEW packages AS
1184 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'arm'::text);
1187 ALTER TABLE arm.packages OWNER TO wbadm;
1190 -- Name: pkg_history; Type: VIEW; Schema: arm; Owner: wbadm
1193 CREATE VIEW pkg_history AS
1194 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'arm'::text);
1197 ALTER TABLE arm.pkg_history OWNER TO wbadm;
1200 -- Name: transactions; Type: VIEW; Schema: arm; Owner: wbadm
1203 CREATE VIEW transactions AS
1204 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'arm'::text);
1207 ALTER TABLE arm.transactions OWNER TO wbadm;
1210 -- Name: users; Type: VIEW; Schema: arm; Owner: wbadm
1213 CREATE VIEW users AS
1214 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'arm'::text);
1217 ALTER TABLE arm.users OWNER TO wbadm;
1219 SET search_path = arm_public, pg_catalog;
1222 -- Name: packages; Type: VIEW; Schema: arm_public; Owner: wbadm
1225 CREATE VIEW packages AS
1226 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'arm'::text));
1229 ALTER TABLE arm_public.packages OWNER TO wbadm;
1232 -- Name: pkg_history; Type: VIEW; Schema: arm_public; Owner: wbadm
1235 CREATE VIEW pkg_history AS
1236 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'arm'::text));
1239 ALTER TABLE arm_public.pkg_history OWNER TO wbadm;
1242 -- Name: transactions; Type: VIEW; Schema: arm_public; Owner: wbadm
1245 CREATE VIEW transactions AS
1246 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'arm'::text));
1249 ALTER TABLE arm_public.transactions OWNER TO wbadm;
1252 -- Name: users; Type: VIEW; Schema: arm_public; Owner: wbadm
1255 CREATE VIEW users AS
1256 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'arm'::text));
1259 ALTER TABLE arm_public.users OWNER TO wbadm;
1261 SET search_path = armel, pg_catalog;
1264 -- Name: packages; Type: VIEW; Schema: armel; Owner: wbadm
1267 CREATE VIEW packages AS
1268 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'armel'::text);
1271 ALTER TABLE armel.packages OWNER TO wbadm;
1274 -- Name: pkg_history; Type: VIEW; Schema: armel; Owner: wbadm
1277 CREATE VIEW pkg_history AS
1278 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'armel'::text);
1281 ALTER TABLE armel.pkg_history OWNER TO wbadm;
1284 -- Name: transactions; Type: VIEW; Schema: armel; Owner: wbadm
1287 CREATE VIEW transactions AS
1288 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'armel'::text);
1291 ALTER TABLE armel.transactions OWNER TO wbadm;
1294 -- Name: users; Type: VIEW; Schema: armel; Owner: wbadm
1297 CREATE VIEW users AS
1298 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'armel'::text);
1301 ALTER TABLE armel.users OWNER TO wbadm;
1303 SET search_path = armel_public, pg_catalog;
1306 -- Name: packages; Type: VIEW; Schema: armel_public; Owner: wbadm
1309 CREATE VIEW packages AS
1310 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'armel'::text));
1313 ALTER TABLE armel_public.packages OWNER TO wbadm;
1316 -- Name: pkg_history; Type: VIEW; Schema: armel_public; Owner: wbadm
1319 CREATE VIEW pkg_history AS
1320 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'armel'::text));
1323 ALTER TABLE armel_public.pkg_history OWNER TO wbadm;
1326 -- Name: transactions; Type: VIEW; Schema: armel_public; Owner: wbadm
1329 CREATE VIEW transactions AS
1330 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'armel'::text));
1333 ALTER TABLE armel_public.transactions OWNER TO wbadm;
1336 -- Name: users; Type: VIEW; Schema: armel_public; Owner: wbadm
1339 CREATE VIEW users AS
1340 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'armel'::text));
1343 ALTER TABLE armel_public.users OWNER TO wbadm;
1345 SET search_path = armhf, pg_catalog;
1348 -- Name: packages; Type: VIEW; Schema: armhf; Owner: wbadm
1351 CREATE VIEW packages AS
1352 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'armhf'::text);
1355 ALTER TABLE armhf.packages OWNER TO wbadm;
1358 -- Name: pkg_history; Type: VIEW; Schema: armhf; Owner: wbadm
1361 CREATE VIEW pkg_history AS
1362 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'armhf'::text);
1365 ALTER TABLE armhf.pkg_history OWNER TO wbadm;
1368 -- Name: transactions; Type: VIEW; Schema: armhf; Owner: wbadm
1371 CREATE VIEW transactions AS
1372 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'armhf'::text);
1375 ALTER TABLE armhf.transactions OWNER TO wbadm;
1378 -- Name: users; Type: VIEW; Schema: armhf; Owner: wbadm
1381 CREATE VIEW users AS
1382 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'armhf'::text);
1385 ALTER TABLE armhf.users OWNER TO wbadm;
1387 SET search_path = armhf_public, pg_catalog;
1390 -- Name: packages; Type: VIEW; Schema: armhf_public; Owner: wbadm
1393 CREATE VIEW packages AS
1394 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'armhf'::text));
1397 ALTER TABLE armhf_public.packages OWNER TO wbadm;
1400 -- Name: pkg_history; Type: VIEW; Schema: armhf_public; Owner: wbadm
1403 CREATE VIEW pkg_history AS
1404 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'armhf'::text));
1407 ALTER TABLE armhf_public.pkg_history OWNER TO wbadm;
1410 -- Name: transactions; Type: VIEW; Schema: armhf_public; Owner: wbadm
1413 CREATE VIEW transactions AS
1414 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'armhf'::text));
1417 ALTER TABLE armhf_public.transactions OWNER TO wbadm;
1420 -- Name: users; Type: VIEW; Schema: armhf_public; Owner: wbadm
1423 CREATE VIEW users AS
1424 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'armhf'::text));
1427 ALTER TABLE armhf_public.users OWNER TO wbadm;
1429 SET search_path = hppa, pg_catalog;
1432 -- Name: packages; Type: VIEW; Schema: hppa; Owner: wbadm
1435 CREATE VIEW packages AS
1436 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'hppa'::text);
1439 ALTER TABLE hppa.packages OWNER TO wbadm;
1442 -- Name: pkg_history; Type: VIEW; Schema: hppa; Owner: wbadm
1445 CREATE VIEW pkg_history AS
1446 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'hppa'::text);
1449 ALTER TABLE hppa.pkg_history OWNER TO wbadm;
1452 -- Name: transactions; Type: VIEW; Schema: hppa; Owner: wbadm
1455 CREATE VIEW transactions AS
1456 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'hppa'::text);
1459 ALTER TABLE hppa.transactions OWNER TO wbadm;
1462 -- Name: users; Type: VIEW; Schema: hppa; Owner: wbadm
1465 CREATE VIEW users AS
1466 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'hppa'::text);
1469 ALTER TABLE hppa.users OWNER TO wbadm;
1471 SET search_path = hppa_public, pg_catalog;
1474 -- Name: packages; Type: VIEW; Schema: hppa_public; Owner: wbadm
1477 CREATE VIEW packages AS
1478 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'hppa'::text));
1481 ALTER TABLE hppa_public.packages OWNER TO wbadm;
1484 -- Name: pkg_history; Type: VIEW; Schema: hppa_public; Owner: wbadm
1487 CREATE VIEW pkg_history AS
1488 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'hppa'::text));
1491 ALTER TABLE hppa_public.pkg_history OWNER TO wbadm;
1494 -- Name: transactions; Type: VIEW; Schema: hppa_public; Owner: wbadm
1497 CREATE VIEW transactions AS
1498 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'hppa'::text));
1501 ALTER TABLE hppa_public.transactions OWNER TO wbadm;
1504 -- Name: users; Type: VIEW; Schema: hppa_public; Owner: wbadm
1507 CREATE VIEW users AS
1508 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'hppa'::text));
1511 ALTER TABLE hppa_public.users OWNER TO wbadm;
1513 SET search_path = "hurd-i386", pg_catalog;
1516 -- Name: packages; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1519 CREATE VIEW packages AS
1520 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'hurd-i386'::text);
1523 ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
1526 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1529 CREATE VIEW pkg_history AS
1530 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'hurd-i386'::text);
1533 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
1536 -- Name: transactions; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1539 CREATE VIEW transactions AS
1540 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'hurd-i386'::text);
1543 ALTER TABLE "hurd-i386".transactions OWNER TO wbadm;
1546 -- Name: users; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1549 CREATE VIEW users AS
1550 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'hurd-i386'::text);
1553 ALTER TABLE "hurd-i386".users OWNER TO wbadm;
1555 SET search_path = "hurd-i386_public", pg_catalog;
1558 -- Name: packages; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1561 CREATE VIEW packages AS
1562 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'hurd-i386'::text));
1565 ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
1568 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1571 CREATE VIEW pkg_history AS
1572 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'hurd-i386'::text));
1575 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
1578 -- Name: transactions; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1581 CREATE VIEW transactions AS
1582 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'hurd-i386'::text));
1585 ALTER TABLE "hurd-i386_public".transactions OWNER TO wbadm;
1588 -- Name: users; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1591 CREATE VIEW users AS
1592 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'hurd-i386'::text));
1595 ALTER TABLE "hurd-i386_public".users OWNER TO wbadm;
1597 SET search_path = i386, pg_catalog;
1600 -- Name: packages; Type: VIEW; Schema: i386; Owner: wbadm
1603 CREATE VIEW packages AS
1604 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'i386'::text);
1607 ALTER TABLE i386.packages OWNER TO wbadm;
1610 -- Name: pkg_history; Type: VIEW; Schema: i386; Owner: wbadm
1613 CREATE VIEW pkg_history AS
1614 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'i386'::text);
1617 ALTER TABLE i386.pkg_history OWNER TO wbadm;
1620 -- Name: transactions; Type: VIEW; Schema: i386; Owner: wbadm
1623 CREATE VIEW transactions AS
1624 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'i386'::text);
1627 ALTER TABLE i386.transactions OWNER TO wbadm;
1630 -- Name: users; Type: VIEW; Schema: i386; Owner: wbadm
1633 CREATE VIEW users AS
1634 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'i386'::text);
1637 ALTER TABLE i386.users OWNER TO wbadm;
1639 SET search_path = i386_public, pg_catalog;
1642 -- Name: packages; Type: VIEW; Schema: i386_public; Owner: wbadm
1645 CREATE VIEW packages AS
1646 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'i386'::text));
1649 ALTER TABLE i386_public.packages OWNER TO wbadm;
1652 -- Name: pkg_history; Type: VIEW; Schema: i386_public; Owner: wbadm
1655 CREATE VIEW pkg_history AS
1656 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'i386'::text));
1659 ALTER TABLE i386_public.pkg_history OWNER TO wbadm;
1662 -- Name: transactions; Type: VIEW; Schema: i386_public; Owner: wbadm
1665 CREATE VIEW transactions AS
1666 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'i386'::text));
1669 ALTER TABLE i386_public.transactions OWNER TO wbadm;
1672 -- Name: users; Type: VIEW; Schema: i386_public; Owner: wbadm
1675 CREATE VIEW users AS
1676 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'i386'::text));
1679 ALTER TABLE i386_public.users OWNER TO wbadm;
1681 SET search_path = ia64, pg_catalog;
1684 -- Name: packages; Type: VIEW; Schema: ia64; Owner: wbadm
1687 CREATE VIEW packages AS
1688 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'ia64'::text);
1691 ALTER TABLE ia64.packages OWNER TO wbadm;
1694 -- Name: pkg_history; Type: VIEW; Schema: ia64; Owner: wbadm
1697 CREATE VIEW pkg_history AS
1698 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'ia64'::text);
1701 ALTER TABLE ia64.pkg_history OWNER TO wbadm;
1704 -- Name: transactions; Type: VIEW; Schema: ia64; Owner: wbadm
1707 CREATE VIEW transactions AS
1708 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'ia64'::text);
1711 ALTER TABLE ia64.transactions OWNER TO wbadm;
1714 -- Name: users; Type: VIEW; Schema: ia64; Owner: wbadm
1717 CREATE VIEW users AS
1718 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'ia64'::text);
1721 ALTER TABLE ia64.users OWNER TO wbadm;
1723 SET search_path = ia64_public, pg_catalog;
1726 -- Name: packages; Type: VIEW; Schema: ia64_public; Owner: wbadm
1729 CREATE VIEW packages AS
1730 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'ia64'::text));
1733 ALTER TABLE ia64_public.packages OWNER TO wbadm;
1736 -- Name: pkg_history; Type: VIEW; Schema: ia64_public; Owner: wbadm
1739 CREATE VIEW pkg_history AS
1740 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'ia64'::text));
1743 ALTER TABLE ia64_public.pkg_history OWNER TO wbadm;
1746 -- Name: transactions; Type: VIEW; Schema: ia64_public; Owner: wbadm
1749 CREATE VIEW transactions AS
1750 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'ia64'::text));
1753 ALTER TABLE ia64_public.transactions OWNER TO wbadm;
1756 -- Name: users; Type: VIEW; Schema: ia64_public; Owner: wbadm
1759 CREATE VIEW users AS
1760 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'ia64'::text));
1763 ALTER TABLE ia64_public.users OWNER TO wbadm;
1765 SET search_path = "kfreebsd-amd64", pg_catalog;
1768 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1771 CREATE VIEW packages AS
1772 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'kfreebsd-amd64'::text);
1775 ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
1778 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1781 CREATE VIEW pkg_history AS
1782 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'kfreebsd-amd64'::text);
1785 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
1788 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1791 CREATE VIEW transactions AS
1792 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'kfreebsd-amd64'::text);
1795 ALTER TABLE "kfreebsd-amd64".transactions OWNER TO wbadm;
1798 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1801 CREATE VIEW users AS
1802 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'kfreebsd-amd64'::text);
1805 ALTER TABLE "kfreebsd-amd64".users OWNER TO wbadm;
1807 SET search_path = "kfreebsd-amd64_public", pg_catalog;
1810 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1813 CREATE VIEW packages AS
1814 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'kfreebsd-amd64'::text));
1817 ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
1820 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1823 CREATE VIEW pkg_history AS
1824 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'kfreebsd-amd64'::text));
1827 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
1830 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1833 CREATE VIEW transactions AS
1834 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'kfreebsd-amd64'::text));
1837 ALTER TABLE "kfreebsd-amd64_public".transactions OWNER TO wbadm;
1840 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1843 CREATE VIEW users AS
1844 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'kfreebsd-amd64'::text));
1847 ALTER TABLE "kfreebsd-amd64_public".users OWNER TO wbadm;
1849 SET search_path = "kfreebsd-i386", pg_catalog;
1852 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1855 CREATE VIEW packages AS
1856 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'kfreebsd-i386'::text);
1859 ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
1862 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1865 CREATE VIEW pkg_history AS
1866 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'kfreebsd-i386'::text);
1869 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
1872 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1875 CREATE VIEW transactions AS
1876 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'kfreebsd-i386'::text);
1879 ALTER TABLE "kfreebsd-i386".transactions OWNER TO wbadm;
1882 -- Name: users; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1885 CREATE VIEW users AS
1886 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'kfreebsd-i386'::text);
1889 ALTER TABLE "kfreebsd-i386".users OWNER TO wbadm;
1891 SET search_path = "kfreebsd-i386_public", pg_catalog;
1894 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1897 CREATE VIEW packages AS
1898 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'kfreebsd-i386'::text));
1901 ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
1904 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1907 CREATE VIEW pkg_history AS
1908 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'kfreebsd-i386'::text));
1911 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
1914 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1917 CREATE VIEW transactions AS
1918 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'kfreebsd-i386'::text));
1921 ALTER TABLE "kfreebsd-i386_public".transactions OWNER TO wbadm;
1924 -- Name: users; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1927 CREATE VIEW users AS
1928 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'kfreebsd-i386'::text));
1931 ALTER TABLE "kfreebsd-i386_public".users OWNER TO wbadm;
1933 SET search_path = mips, pg_catalog;
1936 -- Name: packages; Type: VIEW; Schema: mips; Owner: wbadm
1939 CREATE VIEW packages AS
1940 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'mips'::text);
1943 ALTER TABLE mips.packages OWNER TO wbadm;
1946 -- Name: pkg_history; Type: VIEW; Schema: mips; Owner: wbadm
1949 CREATE VIEW pkg_history AS
1950 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'mips'::text);
1953 ALTER TABLE mips.pkg_history OWNER TO wbadm;
1956 -- Name: transactions; Type: VIEW; Schema: mips; Owner: wbadm
1959 CREATE VIEW transactions AS
1960 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'mips'::text);
1963 ALTER TABLE mips.transactions OWNER TO wbadm;
1966 -- Name: users; Type: VIEW; Schema: mips; Owner: wbadm
1969 CREATE VIEW users AS
1970 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'mips'::text);
1973 ALTER TABLE mips.users OWNER TO wbadm;
1975 SET search_path = mips_public, pg_catalog;
1978 -- Name: packages; Type: VIEW; Schema: mips_public; Owner: wbadm
1981 CREATE VIEW packages AS
1982 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'mips'::text));
1985 ALTER TABLE mips_public.packages OWNER TO wbadm;
1988 -- Name: pkg_history; Type: VIEW; Schema: mips_public; Owner: wbadm
1991 CREATE VIEW pkg_history AS
1992 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'mips'::text));
1995 ALTER TABLE mips_public.pkg_history OWNER TO wbadm;
1998 -- Name: transactions; Type: VIEW; Schema: mips_public; Owner: wbadm
2001 CREATE VIEW transactions AS
2002 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'mips'::text));
2005 ALTER TABLE mips_public.transactions OWNER TO wbadm;
2008 -- Name: users; Type: VIEW; Schema: mips_public; Owner: wbadm
2011 CREATE VIEW users AS
2012 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'mips'::text));
2015 ALTER TABLE mips_public.users OWNER TO wbadm;
2017 SET search_path = mipsel, pg_catalog;
2020 -- Name: packages; Type: VIEW; Schema: mipsel; Owner: wbadm
2023 CREATE VIEW packages AS
2024 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'mipsel'::text);
2027 ALTER TABLE mipsel.packages OWNER TO wbadm;
2030 -- Name: pkg_history; Type: VIEW; Schema: mipsel; Owner: wbadm
2033 CREATE VIEW pkg_history AS
2034 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'mipsel'::text);
2037 ALTER TABLE mipsel.pkg_history OWNER TO wbadm;
2040 -- Name: transactions; Type: VIEW; Schema: mipsel; Owner: wbadm
2043 CREATE VIEW transactions AS
2044 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'mipsel'::text);
2047 ALTER TABLE mipsel.transactions OWNER TO wbadm;
2050 -- Name: users; Type: VIEW; Schema: mipsel; Owner: wbadm
2053 CREATE VIEW users AS
2054 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'mipsel'::text);
2057 ALTER TABLE mipsel.users OWNER TO wbadm;
2059 SET search_path = mipsel_public, pg_catalog;
2062 -- Name: packages; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2065 CREATE VIEW packages AS
2066 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'mipsel'::text));
2069 ALTER TABLE mipsel_public.packages OWNER TO wbadm;
2072 -- Name: pkg_history; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2075 CREATE VIEW pkg_history AS
2076 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'mipsel'::text));
2079 ALTER TABLE mipsel_public.pkg_history OWNER TO wbadm;
2082 -- Name: transactions; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2085 CREATE VIEW transactions AS
2086 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'mipsel'::text));
2089 ALTER TABLE mipsel_public.transactions OWNER TO wbadm;
2092 -- Name: users; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2095 CREATE VIEW users AS
2096 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'mipsel'::text));
2099 ALTER TABLE mipsel_public.users OWNER TO wbadm;
2101 SET search_path = powerpc, pg_catalog;
2104 -- Name: packages; Type: VIEW; Schema: powerpc; Owner: wbadm
2107 CREATE VIEW packages AS
2108 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'powerpc'::text);
2111 ALTER TABLE powerpc.packages OWNER TO wbadm;
2114 -- Name: pkg_history; Type: VIEW; Schema: powerpc; Owner: wbadm
2117 CREATE VIEW pkg_history AS
2118 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'powerpc'::text);
2121 ALTER TABLE powerpc.pkg_history OWNER TO wbadm;
2124 -- Name: transactions; Type: VIEW; Schema: powerpc; Owner: wbadm
2127 CREATE VIEW transactions AS
2128 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'powerpc'::text);
2131 ALTER TABLE powerpc.transactions OWNER TO wbadm;
2134 -- Name: users; Type: VIEW; Schema: powerpc; Owner: wbadm
2137 CREATE VIEW users AS
2138 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'powerpc'::text);
2141 ALTER TABLE powerpc.users OWNER TO wbadm;
2143 SET search_path = powerpc_public, pg_catalog;
2146 -- Name: packages; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2149 CREATE VIEW packages AS
2150 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'powerpc'::text));
2153 ALTER TABLE powerpc_public.packages OWNER TO wbadm;
2156 -- Name: pkg_history; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2159 CREATE VIEW pkg_history AS
2160 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'powerpc'::text));
2163 ALTER TABLE powerpc_public.pkg_history OWNER TO wbadm;
2166 -- Name: transactions; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2169 CREATE VIEW transactions AS
2170 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'powerpc'::text));
2173 ALTER TABLE powerpc_public.transactions OWNER TO wbadm;
2176 -- Name: users; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2179 CREATE VIEW users AS
2180 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'powerpc'::text));
2183 ALTER TABLE powerpc_public.users OWNER TO wbadm;
2185 SET search_path = public, pg_catalog;
2188 -- Name: architectures; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2191 CREATE TABLE architectures (
2192 architecture character varying NOT NULL
2196 ALTER TABLE public.architectures OWNER TO wbadm;
2199 -- Name: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2202 CREATE TABLE distribution_aliases (
2203 alias character varying NOT NULL,
2204 distribution character varying NOT NULL
2208 ALTER TABLE public.distribution_aliases OWNER TO wbadm;
2211 -- Name: distribution_architectures; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2214 CREATE TABLE distribution_architectures (
2215 distribution character varying NOT NULL,
2216 architecture character varying NOT NULL
2220 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2223 -- Name: distribution_architectures_statistics; Type: VIEW; Schema: public; Owner: wbadm
2226 CREATE VIEW distribution_architectures_statistics AS
2227 SELECT DISTINCT packages.distribution, packages.architecture, sum(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE 0 END) AS needsbuild, sum(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE 0 END) AS notinstalled FROM packages GROUP BY packages.distribution, packages.architecture;
2230 ALTER TABLE public.distribution_architectures_statistics OWNER TO wbadm;
2233 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2236 CREATE VIEW lastlog AS
2237 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.architecture FROM (pkg_history NATURAL JOIN distributions) WHERE (distributions.public = true) ORDER BY pkg_history."timestamp" DESC LIMIT 25;
2240 ALTER TABLE public.lastlog OWNER TO wbadm;
2243 -- Name: locks; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2246 CREATE TABLE locks (
2247 distribution character varying,
2248 architecture character varying
2252 ALTER TABLE public.locks OWNER TO wbadm;
2255 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2259 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.architecture FROM (pkg_history NATURAL JOIN distributions) WHERE (distributions.public = true) ORDER BY pkg_history."timestamp" DESC;
2262 ALTER TABLE public.log OWNER TO wbadm;
2265 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2268 CREATE VIEW packages_all AS
2269 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.architecture FROM (packages NATURAL JOIN distributions) WHERE (distributions.public = true);
2272 ALTER TABLE public.packages_all OWNER TO wbadm;
2275 -- Name: packages_public; Type: VIEW; Schema: public; Owner: wbadm
2278 CREATE VIEW packages_public AS
2279 SELECT packages.distribution, packages.architecture, packages.package, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all, distributions.public, distributions.sort_order, distributions.auto_dep_wait, distributions.build_dep_resolver, distributions.archive, distributions.suppress_successful_logs FROM (packages NATURAL JOIN distributions) WHERE (distributions.public = true);
2282 ALTER TABLE public.packages_public OWNER TO wbadm;
2284 SET search_path = s390, pg_catalog;
2287 -- Name: packages; Type: VIEW; Schema: s390; Owner: wbadm
2290 CREATE VIEW packages AS
2291 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 's390'::text);
2294 ALTER TABLE s390.packages OWNER TO wbadm;
2297 -- Name: pkg_history; Type: VIEW; Schema: s390; Owner: wbadm
2300 CREATE VIEW pkg_history AS
2301 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 's390'::text);
2304 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2307 -- Name: transactions; Type: VIEW; Schema: s390; Owner: wbadm
2310 CREATE VIEW transactions AS
2311 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 's390'::text);
2314 ALTER TABLE s390.transactions OWNER TO wbadm;
2317 -- Name: users; Type: VIEW; Schema: s390; Owner: wbadm
2320 CREATE VIEW users AS
2321 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390'::text);
2324 ALTER TABLE s390.users OWNER TO wbadm;
2326 SET search_path = s390_public, pg_catalog;
2329 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2332 CREATE VIEW packages AS
2333 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 's390'::text));
2336 ALTER TABLE s390_public.packages OWNER TO wbadm;
2339 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2342 CREATE VIEW pkg_history AS
2343 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 's390'::text));
2346 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2349 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2352 CREATE VIEW transactions AS
2353 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 's390'::text));
2356 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2359 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2362 CREATE VIEW users AS
2363 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 's390'::text));
2366 ALTER TABLE s390_public.users OWNER TO wbadm;
2368 SET search_path = s390x, pg_catalog;
2371 -- Name: packages; Type: VIEW; Schema: s390x; Owner: wbadm
2374 CREATE VIEW packages AS
2375 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 's390x'::text);
2378 ALTER TABLE s390x.packages OWNER TO wbadm;
2381 -- Name: pkg_history; Type: VIEW; Schema: s390x; Owner: wbadm
2384 CREATE VIEW pkg_history AS
2385 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 's390x'::text);
2388 ALTER TABLE s390x.pkg_history OWNER TO wbadm;
2391 -- Name: transactions; Type: VIEW; Schema: s390x; Owner: wbadm
2394 CREATE VIEW transactions AS
2395 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 's390x'::text);
2398 ALTER TABLE s390x.transactions OWNER TO wbadm;
2401 -- Name: users; Type: VIEW; Schema: s390x; Owner: wbadm
2404 CREATE VIEW users AS
2405 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390x'::text);
2408 ALTER TABLE s390x.users OWNER TO wbadm;
2410 SET search_path = s390x_public, pg_catalog;
2413 -- Name: packages; Type: VIEW; Schema: s390x_public; Owner: wbadm
2416 CREATE VIEW packages AS
2417 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 's390x'::text));
2420 ALTER TABLE s390x_public.packages OWNER TO wbadm;
2423 -- Name: pkg_history; Type: VIEW; Schema: s390x_public; Owner: wbadm
2426 CREATE VIEW pkg_history AS
2427 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 's390x'::text));
2430 ALTER TABLE s390x_public.pkg_history OWNER TO wbadm;
2433 -- Name: transactions; Type: VIEW; Schema: s390x_public; Owner: wbadm
2436 CREATE VIEW transactions AS
2437 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 's390x'::text));
2440 ALTER TABLE s390x_public.transactions OWNER TO wbadm;
2443 -- Name: users; Type: VIEW; Schema: s390x_public; Owner: wbadm
2446 CREATE VIEW users AS
2447 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 's390x'::text));
2450 ALTER TABLE s390x_public.users OWNER TO wbadm;
2452 SET search_path = sparc, pg_catalog;
2455 -- Name: packages; Type: VIEW; Schema: sparc; Owner: wbadm
2458 CREATE VIEW packages AS
2459 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM public.packages packages WHERE ((packages.architecture)::text = 'sparc'::text);
2462 ALTER TABLE sparc.packages OWNER TO wbadm;
2465 -- Name: pkg_history; Type: VIEW; Schema: sparc; Owner: wbadm
2468 CREATE VIEW pkg_history AS
2469 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'sparc'::text);
2472 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2475 -- Name: transactions; Type: VIEW; Schema: sparc; Owner: wbadm
2478 CREATE VIEW transactions AS
2479 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM public.transactions WHERE ((transactions.architecture)::text = 'sparc'::text);
2482 ALTER TABLE sparc.transactions OWNER TO wbadm;
2485 -- Name: users; Type: VIEW; Schema: sparc; Owner: wbadm
2488 CREATE VIEW users AS
2489 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'sparc'::text);
2492 ALTER TABLE sparc.users OWNER TO wbadm;
2494 SET search_path = sparc_public, pg_catalog;
2497 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2500 CREATE VIEW packages AS
2501 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM (public.packages NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((packages.architecture)::text = 'sparc'::text));
2504 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2507 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2510 CREATE VIEW pkg_history AS
2511 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space, pkg_history.builder FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'sparc'::text));
2514 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2517 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2520 CREATE VIEW transactions AS
2521 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM (public.transactions NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((transactions.architecture)::text = 'sparc'::text));
2524 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2527 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2530 CREATE VIEW users AS
2531 SELECT users.username, users.distribution, users.last_seen FROM (public.users NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((users.architecture)::text = 'sparc'::text));
2534 ALTER TABLE sparc_public.users OWNER TO wbadm;
2536 SET search_path = public, pg_catalog;
2539 -- Name: architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2542 ALTER TABLE ONLY architectures
2543 ADD CONSTRAINT architectures_pkey PRIMARY KEY (architecture);
2547 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2550 ALTER TABLE ONLY distribution_aliases
2551 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
2555 -- Name: distribution_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2558 ALTER TABLE ONLY distribution_architectures
2559 ADD CONSTRAINT distribution_architectures_pkey PRIMARY KEY (distribution, architecture);
2563 -- Name: packages_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2566 ALTER TABLE ONLY packages
2567 ADD CONSTRAINT packages_pkey PRIMARY KEY (architecture, package, distribution);
2571 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2574 ALTER TABLE ONLY pkg_history
2575 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (architecture, package, distribution, version, "timestamp");
2579 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2582 ALTER TABLE ONLY users
2583 ADD CONSTRAINT users_pkey PRIMARY KEY (architecture, username, distribution);
2587 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2590 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
2594 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2597 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
2601 -- Name: packages_arch_dist_state; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2604 CREATE INDEX packages_arch_dist_state ON packages USING btree (architecture, distribution, upper((state)::text));
2608 -- Name: pkg_history_timestamp; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2611 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
2614 SET search_path = alpha, pg_catalog;
2617 -- Name: packages_delete; Type: RULE; Schema: alpha; Owner: wbadm
2620 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));
2624 -- Name: packages_insert; Type: RULE; Schema: alpha; Owner: wbadm
2627 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);
2631 -- Name: packages_update; Type: RULE; Schema: alpha; Owner: wbadm
2634 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));
2638 -- Name: pkg_history_delete; Type: RULE; Schema: alpha; Owner: wbadm
2641 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"));
2645 -- Name: pkg_history_insert; Type: RULE; Schema: alpha; Owner: wbadm
2648 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);
2652 -- Name: pkg_history_update; Type: RULE; Schema: alpha; Owner: wbadm
2655 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"));
2659 -- Name: transactions_insert; Type: RULE; Schema: alpha; Owner: wbadm
2662 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");
2666 -- Name: users_delete; Type: RULE; Schema: alpha; Owner: wbadm
2669 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));
2673 -- Name: users_insert; Type: RULE; Schema: alpha; Owner: wbadm
2676 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);
2680 -- Name: users_update; Type: RULE; Schema: alpha; Owner: wbadm
2683 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));
2686 SET search_path = amd64, pg_catalog;
2689 -- Name: packages_delete; Type: RULE; Schema: amd64; Owner: wbadm
2692 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));
2696 -- Name: packages_insert; Type: RULE; Schema: amd64; Owner: wbadm
2699 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);
2703 -- Name: packages_update; Type: RULE; Schema: amd64; Owner: wbadm
2706 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));
2710 -- Name: pkg_history_delete; Type: RULE; Schema: amd64; Owner: wbadm
2713 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"));
2717 -- Name: pkg_history_insert; Type: RULE; Schema: amd64; Owner: wbadm
2720 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);
2724 -- Name: pkg_history_update; Type: RULE; Schema: amd64; Owner: wbadm
2727 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"));
2731 -- Name: transactions_insert; Type: RULE; Schema: amd64; Owner: wbadm
2734 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");
2738 -- Name: users_delete; Type: RULE; Schema: amd64; Owner: wbadm
2741 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));
2745 -- Name: users_insert; Type: RULE; Schema: amd64; Owner: wbadm
2748 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);
2752 -- Name: users_update; Type: RULE; Schema: amd64; Owner: wbadm
2755 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));
2758 SET search_path = arm, pg_catalog;
2761 -- Name: packages_delete; Type: RULE; Schema: arm; Owner: wbadm
2764 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));
2768 -- Name: packages_insert; Type: RULE; Schema: arm; Owner: wbadm
2771 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);
2775 -- Name: packages_update; Type: RULE; Schema: arm; Owner: wbadm
2778 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));
2782 -- Name: pkg_history_delete; Type: RULE; Schema: arm; Owner: wbadm
2785 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"));
2789 -- Name: pkg_history_insert; Type: RULE; Schema: arm; Owner: wbadm
2792 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);
2796 -- Name: pkg_history_update; Type: RULE; Schema: arm; Owner: wbadm
2799 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"));
2803 -- Name: transactions_insert; Type: RULE; Schema: arm; Owner: wbadm
2806 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");
2810 -- Name: users_delete; Type: RULE; Schema: arm; Owner: wbadm
2813 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));
2817 -- Name: users_insert; Type: RULE; Schema: arm; Owner: wbadm
2820 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);
2824 -- Name: users_update; Type: RULE; Schema: arm; Owner: wbadm
2827 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));
2830 SET search_path = armel, pg_catalog;
2833 -- Name: packages_delete; Type: RULE; Schema: armel; Owner: wbadm
2836 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));
2840 -- Name: packages_insert; Type: RULE; Schema: armel; Owner: wbadm
2843 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);
2847 -- Name: packages_update; Type: RULE; Schema: armel; Owner: wbadm
2850 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));
2854 -- Name: pkg_history_delete; Type: RULE; Schema: armel; Owner: wbadm
2857 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"));
2861 -- Name: pkg_history_insert; Type: RULE; Schema: armel; Owner: wbadm
2864 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);
2868 -- Name: pkg_history_update; Type: RULE; Schema: armel; Owner: wbadm
2871 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"));
2875 -- Name: transactions_insert; Type: RULE; Schema: armel; Owner: wbadm
2878 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");
2882 -- Name: users_delete; Type: RULE; Schema: armel; Owner: wbadm
2885 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));
2889 -- Name: users_insert; Type: RULE; Schema: armel; Owner: wbadm
2892 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);
2896 -- Name: users_update; Type: RULE; Schema: armel; Owner: wbadm
2899 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));
2902 SET search_path = armhf, pg_catalog;
2905 -- Name: packages_delete; Type: RULE; Schema: armhf; Owner: wbadm
2908 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));
2912 -- Name: packages_insert; Type: RULE; Schema: armhf; Owner: wbadm
2915 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);
2919 -- Name: packages_update; Type: RULE; Schema: armhf; Owner: wbadm
2922 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));
2926 -- Name: pkg_history_delete; Type: RULE; Schema: armhf; Owner: wbadm
2929 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"));
2933 -- Name: pkg_history_insert; Type: RULE; Schema: armhf; Owner: wbadm
2936 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);
2940 -- Name: pkg_history_update; Type: RULE; Schema: armhf; Owner: wbadm
2943 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"));
2947 -- Name: transactions_insert; Type: RULE; Schema: armhf; Owner: wbadm
2950 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");
2954 -- Name: users_delete; Type: RULE; Schema: armhf; Owner: wbadm
2957 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));
2961 -- Name: users_insert; Type: RULE; Schema: armhf; Owner: wbadm
2964 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);
2968 -- Name: users_update; Type: RULE; Schema: armhf; Owner: wbadm
2971 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));
2974 SET search_path = hppa, pg_catalog;
2977 -- Name: packages_delete; Type: RULE; Schema: hppa; Owner: wbadm
2980 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));
2984 -- Name: packages_insert; Type: RULE; Schema: hppa; Owner: wbadm
2987 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);
2991 -- Name: packages_update; Type: RULE; Schema: hppa; Owner: wbadm
2994 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));
2998 -- Name: pkg_history_delete; Type: RULE; Schema: hppa; Owner: wbadm
3001 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"));
3005 -- Name: pkg_history_insert; Type: RULE; Schema: hppa; Owner: wbadm
3008 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);
3012 -- Name: pkg_history_update; Type: RULE; Schema: hppa; Owner: wbadm
3015 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"));
3019 -- Name: transactions_insert; Type: RULE; Schema: hppa; Owner: wbadm
3022 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");
3026 -- Name: users_delete; Type: RULE; Schema: hppa; Owner: wbadm
3029 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));
3033 -- Name: users_insert; Type: RULE; Schema: hppa; Owner: wbadm
3036 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);
3040 -- Name: users_update; Type: RULE; Schema: hppa; Owner: wbadm
3043 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));
3046 SET search_path = "hurd-i386", pg_catalog;
3049 -- Name: packages_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3052 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));
3056 -- Name: packages_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3059 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);
3063 -- Name: packages_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3066 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));
3070 -- Name: pkg_history_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3073 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"));
3077 -- Name: pkg_history_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3080 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);
3084 -- Name: pkg_history_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3087 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"));
3091 -- Name: transactions_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3094 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");
3098 -- Name: users_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
3101 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));
3105 -- Name: users_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
3108 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);
3112 -- Name: users_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
3115 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));
3118 SET search_path = i386, pg_catalog;
3121 -- Name: packages_delete; Type: RULE; Schema: i386; Owner: wbadm
3124 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));
3128 -- Name: packages_insert; Type: RULE; Schema: i386; Owner: wbadm
3131 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);
3135 -- Name: packages_update; Type: RULE; Schema: i386; Owner: wbadm
3138 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));
3142 -- Name: pkg_history_delete; Type: RULE; Schema: i386; Owner: wbadm
3145 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"));
3149 -- Name: pkg_history_insert; Type: RULE; Schema: i386; Owner: wbadm
3152 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);
3156 -- Name: pkg_history_update; Type: RULE; Schema: i386; Owner: wbadm
3159 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"));
3163 -- Name: transactions_insert; Type: RULE; Schema: i386; Owner: wbadm
3166 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");
3170 -- Name: users_delete; Type: RULE; Schema: i386; Owner: wbadm
3173 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));
3177 -- Name: users_insert; Type: RULE; Schema: i386; Owner: wbadm
3180 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);
3184 -- Name: users_update; Type: RULE; Schema: i386; Owner: wbadm
3187 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));
3190 SET search_path = ia64, pg_catalog;
3193 -- Name: packages_delete; Type: RULE; Schema: ia64; Owner: wbadm
3196 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));
3200 -- Name: packages_insert; Type: RULE; Schema: ia64; Owner: wbadm
3203 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);
3207 -- Name: packages_update; Type: RULE; Schema: ia64; Owner: wbadm
3210 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));
3214 -- Name: pkg_history_delete; Type: RULE; Schema: ia64; Owner: wbadm
3217 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"));
3221 -- Name: pkg_history_insert; Type: RULE; Schema: ia64; Owner: wbadm
3224 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);
3228 -- Name: pkg_history_update; Type: RULE; Schema: ia64; Owner: wbadm
3231 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"));
3235 -- Name: transactions_insert; Type: RULE; Schema: ia64; Owner: wbadm
3238 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");
3242 -- Name: users_delete; Type: RULE; Schema: ia64; Owner: wbadm
3245 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));
3249 -- Name: users_insert; Type: RULE; Schema: ia64; Owner: wbadm
3252 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);
3256 -- Name: users_update; Type: RULE; Schema: ia64; Owner: wbadm
3259 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));
3262 SET search_path = "kfreebsd-amd64", pg_catalog;
3265 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3268 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));
3272 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3275 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);
3279 -- Name: packages_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3282 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));
3286 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3289 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"));
3293 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3296 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);
3300 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3303 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"));
3307 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3310 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");
3314 -- Name: users_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3317 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));
3321 -- Name: users_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3324 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);
3328 -- Name: users_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3331 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));
3334 SET search_path = "kfreebsd-i386", pg_catalog;
3337 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3340 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));
3344 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3347 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);
3351 -- Name: packages_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3354 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));
3358 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3361 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"));
3365 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3368 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);
3372 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3375 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"));
3379 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3382 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");
3386 -- Name: users_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3389 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));
3393 -- Name: users_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3396 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);
3400 -- Name: users_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3403 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));
3406 SET search_path = mips, pg_catalog;
3409 -- Name: packages_delete; Type: RULE; Schema: mips; Owner: wbadm
3412 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));
3416 -- Name: packages_insert; Type: RULE; Schema: mips; Owner: wbadm
3419 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);
3423 -- Name: packages_update; Type: RULE; Schema: mips; Owner: wbadm
3426 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));
3430 -- Name: pkg_history_delete; Type: RULE; Schema: mips; Owner: wbadm
3433 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"));
3437 -- Name: pkg_history_insert; Type: RULE; Schema: mips; Owner: wbadm
3440 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);
3444 -- Name: pkg_history_update; Type: RULE; Schema: mips; Owner: wbadm
3447 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"));
3451 -- Name: transactions_insert; Type: RULE; Schema: mips; Owner: wbadm
3454 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");
3458 -- Name: users_delete; Type: RULE; Schema: mips; Owner: wbadm
3461 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));
3465 -- Name: users_insert; Type: RULE; Schema: mips; Owner: wbadm
3468 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);
3472 -- Name: users_update; Type: RULE; Schema: mips; Owner: wbadm
3475 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));
3478 SET search_path = mipsel, pg_catalog;
3481 -- Name: packages_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3484 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));
3488 -- Name: packages_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3491 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);
3495 -- Name: packages_update; Type: RULE; Schema: mipsel; Owner: wbadm
3498 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));
3502 -- Name: pkg_history_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3505 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"));
3509 -- Name: pkg_history_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3512 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);
3516 -- Name: pkg_history_update; Type: RULE; Schema: mipsel; Owner: wbadm
3519 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"));
3523 -- Name: transactions_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3526 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");
3530 -- Name: users_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3533 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));
3537 -- Name: users_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3540 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);
3544 -- Name: users_update; Type: RULE; Schema: mipsel; Owner: wbadm
3547 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));
3550 SET search_path = powerpc, pg_catalog;
3553 -- Name: packages_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3556 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));
3560 -- Name: packages_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3563 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);
3567 -- Name: packages_update; Type: RULE; Schema: powerpc; Owner: wbadm
3570 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));
3574 -- Name: pkg_history_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3577 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"));
3581 -- Name: pkg_history_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3584 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);
3588 -- Name: pkg_history_update; Type: RULE; Schema: powerpc; Owner: wbadm
3591 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"));
3595 -- Name: transactions_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3598 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");
3602 -- Name: users_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3605 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));
3609 -- Name: users_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3612 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);
3616 -- Name: users_update; Type: RULE; Schema: powerpc; Owner: wbadm
3619 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));
3622 SET search_path = s390, pg_catalog;
3625 -- Name: packages_delete; Type: RULE; Schema: s390; Owner: wbadm
3628 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));
3632 -- Name: packages_insert; Type: RULE; Schema: s390; Owner: wbadm
3635 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);
3639 -- Name: packages_update; Type: RULE; Schema: s390; Owner: wbadm
3642 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));
3646 -- Name: pkg_history_delete; Type: RULE; Schema: s390; Owner: wbadm
3649 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"));
3653 -- Name: pkg_history_insert; Type: RULE; Schema: s390; Owner: wbadm
3656 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);
3660 -- Name: pkg_history_update; Type: RULE; Schema: s390; Owner: wbadm
3663 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"));
3667 -- Name: transactions_insert; Type: RULE; Schema: s390; Owner: wbadm
3670 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");
3674 -- Name: users_delete; Type: RULE; Schema: s390; Owner: wbadm
3677 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));
3681 -- Name: users_insert; Type: RULE; Schema: s390; Owner: wbadm
3684 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);
3688 -- Name: users_update; Type: RULE; Schema: s390; Owner: wbadm
3691 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));
3694 SET search_path = s390x, pg_catalog;
3697 -- Name: packages_delete; Type: RULE; Schema: s390x; Owner: wbadm
3700 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));
3704 -- Name: packages_insert; Type: RULE; Schema: s390x; Owner: wbadm
3707 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);
3711 -- Name: packages_update; Type: RULE; Schema: s390x; Owner: wbadm
3714 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));
3718 -- Name: pkg_history_delete; Type: RULE; Schema: s390x; Owner: wbadm
3721 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"));
3725 -- Name: pkg_history_insert; Type: RULE; Schema: s390x; Owner: wbadm
3728 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);
3732 -- Name: pkg_history_update; Type: RULE; Schema: s390x; Owner: wbadm
3735 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"));
3739 -- Name: transactions_insert; Type: RULE; Schema: s390x; Owner: wbadm
3742 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");
3746 -- Name: users_delete; Type: RULE; Schema: s390x; Owner: wbadm
3749 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));
3753 -- Name: users_insert; Type: RULE; Schema: s390x; Owner: wbadm
3756 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);
3760 -- Name: users_update; Type: RULE; Schema: s390x; Owner: wbadm
3763 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));
3766 SET search_path = sparc, pg_catalog;
3769 -- Name: packages_delete; Type: RULE; Schema: sparc; Owner: wbadm
3772 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));
3776 -- Name: packages_insert; Type: RULE; Schema: sparc; Owner: wbadm
3779 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);
3783 -- Name: packages_update; Type: RULE; Schema: sparc; Owner: wbadm
3786 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));
3790 -- Name: pkg_history_delete; Type: RULE; Schema: sparc; Owner: wbadm
3793 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"));
3797 -- Name: pkg_history_insert; Type: RULE; Schema: sparc; Owner: wbadm
3800 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);
3804 -- Name: pkg_history_update; Type: RULE; Schema: sparc; Owner: wbadm
3807 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"));
3811 -- Name: transactions_insert; Type: RULE; Schema: sparc; Owner: wbadm
3814 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");
3818 -- Name: users_delete; Type: RULE; Schema: sparc; Owner: wbadm
3821 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));
3825 -- Name: users_insert; Type: RULE; Schema: sparc; Owner: wbadm
3828 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);
3832 -- Name: users_update; Type: RULE; Schema: sparc; Owner: wbadm
3835 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));
3838 SET search_path = public, pg_catalog;
3841 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3844 ALTER TABLE ONLY distribution_aliases
3845 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3849 -- Name: distribution_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3852 ALTER TABLE ONLY packages
3853 ADD CONSTRAINT distribution_architecture_fkey FOREIGN KEY (distribution, architecture) REFERENCES distribution_architectures(distribution, architecture);
3857 -- Name: packages_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3860 ALTER TABLE ONLY packages
3861 ADD CONSTRAINT packages_architecture_fkey FOREIGN KEY (architecture) REFERENCES architectures(architecture);
3865 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3868 ALTER TABLE ONLY packages
3869 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3873 -- Name: pkg_history_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3876 ALTER TABLE ONLY pkg_history
3877 ADD CONSTRAINT pkg_history_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3881 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
3884 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
3885 REVOKE ALL ON SCHEMA alpha FROM wbadm;
3886 GRANT ALL ON SCHEMA alpha TO wbadm;
3887 GRANT USAGE ON SCHEMA alpha TO alpha;
3888 GRANT USAGE ON SCHEMA alpha TO wb_all;
3889 GRANT USAGE ON SCHEMA alpha TO wb_security;
3893 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
3896 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
3897 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
3898 GRANT ALL ON SCHEMA alpha_public TO wbadm;
3899 GRANT USAGE ON SCHEMA alpha_public TO alpha;
3900 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
3904 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
3907 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
3908 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
3909 GRANT ALL ON SCHEMA amd64 TO wbadm;
3910 GRANT USAGE ON SCHEMA amd64 TO amd64;
3911 GRANT USAGE ON SCHEMA amd64 TO wb_all;
3912 GRANT USAGE ON SCHEMA amd64 TO wb_security;
3916 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
3919 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
3920 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
3921 GRANT ALL ON SCHEMA amd64_public TO wbadm;
3922 GRANT USAGE ON SCHEMA amd64_public TO amd64;
3923 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
3927 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
3930 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
3931 REVOKE ALL ON SCHEMA arm FROM wbadm;
3932 GRANT ALL ON SCHEMA arm TO wbadm;
3933 GRANT USAGE ON SCHEMA arm TO arm;
3934 GRANT USAGE ON SCHEMA arm TO wb_all;
3935 GRANT USAGE ON SCHEMA arm TO wb_security;
3939 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
3942 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
3943 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
3944 GRANT ALL ON SCHEMA arm_public TO wbadm;
3945 GRANT USAGE ON SCHEMA arm_public TO arm;
3946 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
3950 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
3953 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
3954 REVOKE ALL ON SCHEMA armel FROM wbadm;
3955 GRANT ALL ON SCHEMA armel TO wbadm;
3956 GRANT USAGE ON SCHEMA armel TO armel;
3957 GRANT USAGE ON SCHEMA armel TO wb_all;
3958 GRANT USAGE ON SCHEMA armel TO wb_security;
3962 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
3965 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
3966 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
3967 GRANT ALL ON SCHEMA armel_public TO wbadm;
3968 GRANT USAGE ON SCHEMA armel_public TO armel;
3969 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
3973 -- Name: armhf; Type: ACL; Schema: -; Owner: wbadm
3976 REVOKE ALL ON SCHEMA armhf FROM PUBLIC;
3977 REVOKE ALL ON SCHEMA armhf FROM wbadm;
3978 GRANT ALL ON SCHEMA armhf TO wbadm;
3979 GRANT USAGE ON SCHEMA armhf TO wb_all;
3980 GRANT USAGE ON SCHEMA armhf TO wb_security;
3984 -- Name: armhf_public; Type: ACL; Schema: -; Owner: wbadm
3987 REVOKE ALL ON SCHEMA armhf_public FROM PUBLIC;
3988 REVOKE ALL ON SCHEMA armhf_public FROM wbadm;
3989 GRANT ALL ON SCHEMA armhf_public TO wbadm;
3990 GRANT USAGE ON SCHEMA armhf_public TO PUBLIC;
3994 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
3997 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
3998 REVOKE ALL ON SCHEMA hppa FROM wbadm;
3999 GRANT ALL ON SCHEMA hppa TO wbadm;
4000 GRANT USAGE ON SCHEMA hppa TO hppa;
4001 GRANT USAGE ON SCHEMA hppa TO wb_all;
4002 GRANT USAGE ON SCHEMA hppa TO wb_security;
4006 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4009 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4010 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4011 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4012 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4013 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4017 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4020 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4021 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4022 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4023 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4024 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4025 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4029 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4032 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4033 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4034 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4035 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4036 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4040 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4043 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4044 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4045 GRANT ALL ON SCHEMA i386 TO wbadm;
4046 GRANT USAGE ON SCHEMA i386 TO i386;
4047 GRANT USAGE ON SCHEMA i386 TO wb_all;
4048 GRANT USAGE ON SCHEMA i386 TO wb_security;
4052 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4055 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4056 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4057 GRANT ALL ON SCHEMA i386_public TO wbadm;
4058 GRANT USAGE ON SCHEMA i386_public TO i386;
4059 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4063 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4066 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4067 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4068 GRANT ALL ON SCHEMA ia64 TO wbadm;
4069 GRANT USAGE ON SCHEMA ia64 TO ia64;
4070 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4071 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4075 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4078 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4079 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4080 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4081 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4082 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4086 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4089 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4090 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4091 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4092 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4093 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4094 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4098 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4101 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4102 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4103 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4104 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4105 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4109 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4112 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4113 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4114 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4115 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4116 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4117 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4121 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4124 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4125 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4126 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4127 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4128 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4132 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4135 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4136 REVOKE ALL ON SCHEMA mips FROM wbadm;
4137 GRANT ALL ON SCHEMA mips TO wbadm;
4138 GRANT USAGE ON SCHEMA mips TO mips;
4139 GRANT USAGE ON SCHEMA mips TO wb_all;
4140 GRANT USAGE ON SCHEMA mips TO wb_security;
4144 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4147 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4148 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4149 GRANT ALL ON SCHEMA mips_public TO wbadm;
4150 GRANT USAGE ON SCHEMA mips_public TO mips;
4151 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4155 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4158 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4159 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4160 GRANT ALL ON SCHEMA mipsel TO wbadm;
4161 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4162 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4163 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4167 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4170 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4171 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4172 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4173 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4174 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4178 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4181 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4182 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4183 GRANT ALL ON SCHEMA powerpc TO wbadm;
4184 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4185 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4186 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4190 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4193 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4194 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4195 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4196 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4197 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4201 -- Name: public; Type: ACL; Schema: -; Owner: wbadm
4204 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4205 REVOKE ALL ON SCHEMA public FROM wbadm;
4206 GRANT ALL ON SCHEMA public TO wbadm;
4207 GRANT ALL ON SCHEMA public TO PUBLIC;
4211 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4214 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4215 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4216 GRANT ALL ON SCHEMA s390 TO wbadm;
4217 GRANT USAGE ON SCHEMA s390 TO s390;
4218 GRANT USAGE ON SCHEMA s390 TO wb_all;
4219 GRANT USAGE ON SCHEMA s390 TO wb_security;
4223 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4226 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4227 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4228 GRANT ALL ON SCHEMA s390_public TO wbadm;
4229 GRANT USAGE ON SCHEMA s390_public TO s390;
4230 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4234 -- Name: s390x; Type: ACL; Schema: -; Owner: wbadm
4237 REVOKE ALL ON SCHEMA s390x FROM PUBLIC;
4238 REVOKE ALL ON SCHEMA s390x FROM wbadm;
4239 GRANT ALL ON SCHEMA s390x TO wbadm;
4240 GRANT USAGE ON SCHEMA s390x TO wb_all;
4241 GRANT USAGE ON SCHEMA s390x TO wb_security;
4245 -- Name: s390x_public; Type: ACL; Schema: -; Owner: wbadm
4248 REVOKE ALL ON SCHEMA s390x_public FROM PUBLIC;
4249 REVOKE ALL ON SCHEMA s390x_public FROM wbadm;
4250 GRANT ALL ON SCHEMA s390x_public TO wbadm;
4251 GRANT USAGE ON SCHEMA s390x_public TO PUBLIC;
4255 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4258 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4259 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4260 GRANT ALL ON SCHEMA sparc TO wbadm;
4261 GRANT USAGE ON SCHEMA sparc TO sparc;
4262 GRANT USAGE ON SCHEMA sparc TO wb_all;
4263 GRANT USAGE ON SCHEMA sparc TO wb_security;
4267 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4270 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4271 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4272 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4273 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4274 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4278 -- Name: packages; Type: ACL; Schema: public; Owner: wbadm
4281 REVOKE ALL ON TABLE packages FROM PUBLIC;
4282 REVOKE ALL ON TABLE packages FROM wbadm;
4283 GRANT ALL ON TABLE packages TO wbadm;
4286 SET search_path = alpha, pg_catalog;
4289 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4292 REVOKE ALL ON TABLE packages FROM PUBLIC;
4293 REVOKE ALL ON TABLE packages FROM wbadm;
4294 GRANT ALL ON TABLE packages TO wbadm;
4295 GRANT SELECT ON TABLE packages TO wb_security;
4296 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4299 SET search_path = public, pg_catalog;
4302 -- Name: pkg_history; Type: ACL; Schema: public; Owner: wbadm
4305 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4306 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4307 GRANT ALL ON TABLE pkg_history TO wbadm;
4310 SET search_path = alpha, pg_catalog;
4313 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4316 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4317 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4318 GRANT ALL ON TABLE pkg_history TO wbadm;
4319 GRANT SELECT ON TABLE pkg_history TO wb_security;
4320 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4323 SET search_path = public, pg_catalog;
4326 -- Name: transactions; Type: ACL; Schema: public; Owner: wbadm
4329 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4330 REVOKE ALL ON TABLE transactions FROM wbadm;
4331 GRANT ALL ON TABLE transactions TO wbadm;
4334 SET search_path = alpha, pg_catalog;
4337 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4340 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4341 REVOKE ALL ON TABLE transactions FROM wbadm;
4342 GRANT ALL ON TABLE transactions TO wbadm;
4343 GRANT SELECT ON TABLE transactions TO wb_security;
4344 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4347 SET search_path = public, pg_catalog;
4350 -- Name: users; Type: ACL; Schema: public; Owner: wbadm
4353 REVOKE ALL ON TABLE users FROM PUBLIC;
4354 REVOKE ALL ON TABLE users FROM wbadm;
4355 GRANT ALL ON TABLE users TO wbadm;
4358 SET search_path = alpha, pg_catalog;
4361 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4364 REVOKE ALL ON TABLE users FROM PUBLIC;
4365 REVOKE ALL ON TABLE users FROM wbadm;
4366 GRANT ALL ON TABLE users TO wbadm;
4367 GRANT SELECT ON TABLE users TO wb_security;
4368 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4371 SET search_path = public, pg_catalog;
4374 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
4377 REVOKE ALL ON TABLE distributions FROM PUBLIC;
4378 REVOKE ALL ON TABLE distributions FROM wbadm;
4379 GRANT ALL ON TABLE distributions TO wbadm;
4380 GRANT SELECT ON TABLE distributions TO PUBLIC;
4383 SET search_path = alpha_public, pg_catalog;
4386 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4389 REVOKE ALL ON TABLE packages FROM PUBLIC;
4390 REVOKE ALL ON TABLE packages FROM wbadm;
4391 GRANT ALL ON TABLE packages TO wbadm;
4392 GRANT SELECT ON TABLE packages TO PUBLIC;
4396 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4399 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4400 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4401 GRANT ALL ON TABLE pkg_history TO wbadm;
4402 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4406 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4409 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4410 REVOKE ALL ON TABLE transactions FROM wbadm;
4411 GRANT ALL ON TABLE transactions TO wbadm;
4412 GRANT SELECT ON TABLE transactions TO PUBLIC;
4416 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4419 REVOKE ALL ON TABLE users FROM PUBLIC;
4420 REVOKE ALL ON TABLE users FROM wbadm;
4421 GRANT ALL ON TABLE users TO wbadm;
4422 GRANT SELECT ON TABLE users TO PUBLIC;
4425 SET search_path = amd64, pg_catalog;
4428 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4431 REVOKE ALL ON TABLE packages FROM PUBLIC;
4432 REVOKE ALL ON TABLE packages FROM wbadm;
4433 GRANT ALL ON TABLE packages TO wbadm;
4434 GRANT SELECT ON TABLE packages TO wb_security;
4435 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4439 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4442 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4443 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4444 GRANT ALL ON TABLE pkg_history TO wbadm;
4445 GRANT SELECT ON TABLE pkg_history TO wb_security;
4446 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4450 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4453 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4454 REVOKE ALL ON TABLE transactions FROM wbadm;
4455 GRANT ALL ON TABLE transactions TO wbadm;
4456 GRANT SELECT ON TABLE transactions TO wb_security;
4457 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4461 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4464 REVOKE ALL ON TABLE users FROM PUBLIC;
4465 REVOKE ALL ON TABLE users FROM wbadm;
4466 GRANT ALL ON TABLE users TO wbadm;
4467 GRANT SELECT ON TABLE users TO wb_security;
4468 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4471 SET search_path = amd64_public, pg_catalog;
4474 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4477 REVOKE ALL ON TABLE packages FROM PUBLIC;
4478 REVOKE ALL ON TABLE packages FROM wbadm;
4479 GRANT ALL ON TABLE packages TO wbadm;
4480 GRANT SELECT ON TABLE packages TO PUBLIC;
4484 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4487 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4488 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4489 GRANT ALL ON TABLE pkg_history TO wbadm;
4490 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4494 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4497 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4498 REVOKE ALL ON TABLE transactions FROM wbadm;
4499 GRANT ALL ON TABLE transactions TO wbadm;
4500 GRANT SELECT ON TABLE transactions TO PUBLIC;
4504 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4507 REVOKE ALL ON TABLE users FROM PUBLIC;
4508 REVOKE ALL ON TABLE users FROM wbadm;
4509 GRANT ALL ON TABLE users TO wbadm;
4510 GRANT SELECT ON TABLE users TO PUBLIC;
4513 SET search_path = arm, pg_catalog;
4516 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4519 REVOKE ALL ON TABLE packages FROM PUBLIC;
4520 REVOKE ALL ON TABLE packages FROM wbadm;
4521 GRANT ALL ON TABLE packages TO wbadm;
4522 GRANT SELECT ON TABLE packages TO wb_security;
4523 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4527 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4530 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4531 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4532 GRANT ALL ON TABLE pkg_history TO wbadm;
4533 GRANT SELECT ON TABLE pkg_history TO wb_security;
4534 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4538 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4541 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4542 REVOKE ALL ON TABLE transactions FROM wbadm;
4543 GRANT ALL ON TABLE transactions TO wbadm;
4544 GRANT SELECT ON TABLE transactions TO wb_security;
4545 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4549 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4552 REVOKE ALL ON TABLE users FROM PUBLIC;
4553 REVOKE ALL ON TABLE users FROM wbadm;
4554 GRANT ALL ON TABLE users TO wbadm;
4555 GRANT SELECT ON TABLE users TO wb_security;
4556 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4559 SET search_path = arm_public, pg_catalog;
4562 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4565 REVOKE ALL ON TABLE packages FROM PUBLIC;
4566 REVOKE ALL ON TABLE packages FROM wbadm;
4567 GRANT ALL ON TABLE packages TO wbadm;
4568 GRANT SELECT ON TABLE packages TO PUBLIC;
4572 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4575 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4576 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4577 GRANT ALL ON TABLE pkg_history TO wbadm;
4578 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4582 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4585 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4586 REVOKE ALL ON TABLE transactions FROM wbadm;
4587 GRANT ALL ON TABLE transactions TO wbadm;
4588 GRANT SELECT ON TABLE transactions TO PUBLIC;
4592 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4595 REVOKE ALL ON TABLE users FROM PUBLIC;
4596 REVOKE ALL ON TABLE users FROM wbadm;
4597 GRANT ALL ON TABLE users TO wbadm;
4598 GRANT SELECT ON TABLE users TO PUBLIC;
4601 SET search_path = armel, pg_catalog;
4604 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4607 REVOKE ALL ON TABLE packages FROM PUBLIC;
4608 REVOKE ALL ON TABLE packages FROM wbadm;
4609 GRANT ALL ON TABLE packages TO wbadm;
4610 GRANT SELECT ON TABLE packages TO wb_security;
4611 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4615 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4618 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4619 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4620 GRANT ALL ON TABLE pkg_history TO wbadm;
4621 GRANT SELECT ON TABLE pkg_history TO wb_security;
4622 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4626 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4629 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4630 REVOKE ALL ON TABLE transactions FROM wbadm;
4631 GRANT ALL ON TABLE transactions TO wbadm;
4632 GRANT SELECT ON TABLE transactions TO wb_security;
4633 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4637 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4640 REVOKE ALL ON TABLE users FROM PUBLIC;
4641 REVOKE ALL ON TABLE users FROM wbadm;
4642 GRANT ALL ON TABLE users TO wbadm;
4643 GRANT SELECT ON TABLE users TO wb_security;
4644 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4647 SET search_path = armel_public, pg_catalog;
4650 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4653 REVOKE ALL ON TABLE packages FROM PUBLIC;
4654 REVOKE ALL ON TABLE packages FROM wbadm;
4655 GRANT ALL ON TABLE packages TO wbadm;
4656 GRANT SELECT ON TABLE packages TO PUBLIC;
4660 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4663 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4664 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4665 GRANT ALL ON TABLE pkg_history TO wbadm;
4666 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4670 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4673 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4674 REVOKE ALL ON TABLE transactions FROM wbadm;
4675 GRANT ALL ON TABLE transactions TO wbadm;
4676 GRANT SELECT ON TABLE transactions TO PUBLIC;
4680 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4683 REVOKE ALL ON TABLE users FROM PUBLIC;
4684 REVOKE ALL ON TABLE users FROM wbadm;
4685 GRANT ALL ON TABLE users TO wbadm;
4686 GRANT SELECT ON TABLE users TO PUBLIC;
4689 SET search_path = armhf, pg_catalog;
4692 -- Name: packages; Type: ACL; Schema: armhf; Owner: wbadm
4695 REVOKE ALL ON TABLE packages FROM PUBLIC;
4696 REVOKE ALL ON TABLE packages FROM wbadm;
4697 GRANT ALL ON TABLE packages TO wbadm;
4698 GRANT SELECT ON TABLE packages TO wb_security;
4699 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4703 -- Name: pkg_history; Type: ACL; Schema: armhf; Owner: wbadm
4706 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4707 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4708 GRANT ALL ON TABLE pkg_history TO wbadm;
4709 GRANT SELECT ON TABLE pkg_history TO wb_security;
4710 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4714 -- Name: transactions; Type: ACL; Schema: armhf; Owner: wbadm
4717 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4718 REVOKE ALL ON TABLE transactions FROM wbadm;
4719 GRANT ALL ON TABLE transactions TO wbadm;
4720 GRANT SELECT ON TABLE transactions TO wb_security;
4721 GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
4725 -- Name: users; Type: ACL; Schema: armhf; Owner: wbadm
4728 REVOKE ALL ON TABLE users FROM PUBLIC;
4729 REVOKE ALL ON TABLE users FROM wbadm;
4730 GRANT ALL ON TABLE users TO wbadm;
4731 GRANT SELECT ON TABLE users TO wb_security;
4732 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4735 SET search_path = armhf_public, pg_catalog;
4738 -- Name: packages; Type: ACL; Schema: armhf_public; Owner: wbadm
4741 REVOKE ALL ON TABLE packages FROM PUBLIC;
4742 REVOKE ALL ON TABLE packages FROM wbadm;
4743 GRANT ALL ON TABLE packages TO wbadm;
4744 GRANT SELECT ON TABLE packages TO PUBLIC;
4748 -- Name: pkg_history; Type: ACL; Schema: armhf_public; Owner: wbadm
4751 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4752 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4753 GRANT ALL ON TABLE pkg_history TO wbadm;
4754 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4758 -- Name: transactions; Type: ACL; Schema: armhf_public; Owner: wbadm
4761 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4762 REVOKE ALL ON TABLE transactions FROM wbadm;
4763 GRANT ALL ON TABLE transactions TO wbadm;
4764 GRANT SELECT ON TABLE transactions TO PUBLIC;
4768 -- Name: users; Type: ACL; Schema: armhf_public; Owner: wbadm
4771 REVOKE ALL ON TABLE users FROM PUBLIC;
4772 REVOKE ALL ON TABLE users FROM wbadm;
4773 GRANT ALL ON TABLE users TO wbadm;
4774 GRANT SELECT ON TABLE users TO PUBLIC;
4777 SET search_path = hppa, pg_catalog;
4780 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4783 REVOKE ALL ON TABLE packages FROM PUBLIC;
4784 REVOKE ALL ON TABLE packages FROM wbadm;
4785 GRANT ALL ON TABLE packages TO wbadm;
4786 GRANT SELECT ON TABLE packages TO wb_security;
4787 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4791 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4794 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4795 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4796 GRANT ALL ON TABLE pkg_history TO wbadm;
4797 GRANT SELECT ON TABLE pkg_history TO wb_security;
4798 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4802 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4805 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4806 REVOKE ALL ON TABLE transactions FROM wbadm;
4807 GRANT ALL ON TABLE transactions TO wbadm;
4808 GRANT SELECT ON TABLE transactions TO wb_security;
4809 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4813 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4816 REVOKE ALL ON TABLE users FROM PUBLIC;
4817 REVOKE ALL ON TABLE users FROM wbadm;
4818 GRANT ALL ON TABLE users TO wbadm;
4819 GRANT SELECT ON TABLE users TO wb_security;
4820 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4823 SET search_path = hppa_public, pg_catalog;
4826 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4829 REVOKE ALL ON TABLE packages FROM PUBLIC;
4830 REVOKE ALL ON TABLE packages FROM wbadm;
4831 GRANT ALL ON TABLE packages TO wbadm;
4832 GRANT SELECT ON TABLE packages TO PUBLIC;
4836 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4839 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4840 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4841 GRANT ALL ON TABLE pkg_history TO wbadm;
4842 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4846 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4849 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4850 REVOKE ALL ON TABLE transactions FROM wbadm;
4851 GRANT ALL ON TABLE transactions TO wbadm;
4852 GRANT SELECT ON TABLE transactions TO PUBLIC;
4856 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4859 REVOKE ALL ON TABLE users FROM PUBLIC;
4860 REVOKE ALL ON TABLE users FROM wbadm;
4861 GRANT ALL ON TABLE users TO wbadm;
4862 GRANT SELECT ON TABLE users TO PUBLIC;
4865 SET search_path = "hurd-i386", pg_catalog;
4868 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4871 REVOKE ALL ON TABLE packages FROM PUBLIC;
4872 REVOKE ALL ON TABLE packages FROM wbadm;
4873 GRANT ALL ON TABLE packages TO wbadm;
4874 GRANT SELECT ON TABLE packages TO wb_security;
4875 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4879 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4882 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4883 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4884 GRANT ALL ON TABLE pkg_history TO wbadm;
4885 GRANT SELECT ON TABLE pkg_history TO wb_security;
4886 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4890 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4893 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4894 REVOKE ALL ON TABLE transactions FROM wbadm;
4895 GRANT ALL ON TABLE transactions TO wbadm;
4896 GRANT SELECT ON TABLE transactions TO wb_security;
4897 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4901 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4904 REVOKE ALL ON TABLE users FROM PUBLIC;
4905 REVOKE ALL ON TABLE users FROM wbadm;
4906 GRANT ALL ON TABLE users TO wbadm;
4907 GRANT SELECT ON TABLE users TO wb_security;
4908 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4911 SET search_path = "hurd-i386_public", pg_catalog;
4914 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4917 REVOKE ALL ON TABLE packages FROM PUBLIC;
4918 REVOKE ALL ON TABLE packages FROM wbadm;
4919 GRANT ALL ON TABLE packages TO wbadm;
4920 GRANT SELECT ON TABLE packages TO PUBLIC;
4924 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4927 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4928 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4929 GRANT ALL ON TABLE pkg_history TO wbadm;
4930 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4934 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4937 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4938 REVOKE ALL ON TABLE transactions FROM wbadm;
4939 GRANT ALL ON TABLE transactions TO wbadm;
4940 GRANT SELECT ON TABLE transactions TO PUBLIC;
4944 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4947 REVOKE ALL ON TABLE users FROM PUBLIC;
4948 REVOKE ALL ON TABLE users FROM wbadm;
4949 GRANT ALL ON TABLE users TO wbadm;
4950 GRANT SELECT ON TABLE users TO PUBLIC;
4953 SET search_path = i386, pg_catalog;
4956 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4959 REVOKE ALL ON TABLE packages FROM PUBLIC;
4960 REVOKE ALL ON TABLE packages FROM wbadm;
4961 GRANT ALL ON TABLE packages TO wbadm;
4962 GRANT SELECT ON TABLE packages TO wb_security;
4963 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4967 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4970 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4971 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4972 GRANT ALL ON TABLE pkg_history TO wbadm;
4973 GRANT SELECT ON TABLE pkg_history TO wb_security;
4974 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4978 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
4981 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4982 REVOKE ALL ON TABLE transactions FROM wbadm;
4983 GRANT ALL ON TABLE transactions TO wbadm;
4984 GRANT SELECT ON TABLE transactions TO wb_security;
4985 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4989 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
4992 REVOKE ALL ON TABLE users FROM PUBLIC;
4993 REVOKE ALL ON TABLE users FROM wbadm;
4994 GRANT ALL ON TABLE users TO wbadm;
4995 GRANT SELECT ON TABLE users TO wb_security;
4996 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4999 SET search_path = i386_public, pg_catalog;
5002 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5005 REVOKE ALL ON TABLE packages FROM PUBLIC;
5006 REVOKE ALL ON TABLE packages FROM wbadm;
5007 GRANT ALL ON TABLE packages TO wbadm;
5008 GRANT SELECT ON TABLE packages TO PUBLIC;
5012 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5015 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5016 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5017 GRANT ALL ON TABLE pkg_history TO wbadm;
5018 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5022 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5025 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5026 REVOKE ALL ON TABLE transactions FROM wbadm;
5027 GRANT ALL ON TABLE transactions TO wbadm;
5028 GRANT SELECT ON TABLE transactions TO PUBLIC;
5032 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5035 REVOKE ALL ON TABLE users FROM PUBLIC;
5036 REVOKE ALL ON TABLE users FROM wbadm;
5037 GRANT ALL ON TABLE users TO wbadm;
5038 GRANT SELECT ON TABLE users TO PUBLIC;
5041 SET search_path = ia64, pg_catalog;
5044 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5047 REVOKE ALL ON TABLE packages FROM PUBLIC;
5048 REVOKE ALL ON TABLE packages FROM wbadm;
5049 GRANT ALL ON TABLE packages TO wbadm;
5050 GRANT SELECT ON TABLE packages TO wb_security;
5051 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5055 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5058 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5059 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5060 GRANT ALL ON TABLE pkg_history TO wbadm;
5061 GRANT SELECT ON TABLE pkg_history TO wb_security;
5062 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5066 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5069 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5070 REVOKE ALL ON TABLE transactions FROM wbadm;
5071 GRANT ALL ON TABLE transactions TO wbadm;
5072 GRANT SELECT ON TABLE transactions TO wb_security;
5073 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5077 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5080 REVOKE ALL ON TABLE users FROM PUBLIC;
5081 REVOKE ALL ON TABLE users FROM wbadm;
5082 GRANT ALL ON TABLE users TO wbadm;
5083 GRANT SELECT ON TABLE users TO wb_security;
5084 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5087 SET search_path = ia64_public, pg_catalog;
5090 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5093 REVOKE ALL ON TABLE packages FROM PUBLIC;
5094 REVOKE ALL ON TABLE packages FROM wbadm;
5095 GRANT ALL ON TABLE packages TO wbadm;
5096 GRANT SELECT ON TABLE packages TO PUBLIC;
5100 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5103 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5104 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5105 GRANT ALL ON TABLE pkg_history TO wbadm;
5106 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5110 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5113 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5114 REVOKE ALL ON TABLE transactions FROM wbadm;
5115 GRANT ALL ON TABLE transactions TO wbadm;
5116 GRANT SELECT ON TABLE transactions TO PUBLIC;
5120 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5123 REVOKE ALL ON TABLE users FROM PUBLIC;
5124 REVOKE ALL ON TABLE users FROM wbadm;
5125 GRANT ALL ON TABLE users TO wbadm;
5126 GRANT SELECT ON TABLE users TO PUBLIC;
5129 SET search_path = "kfreebsd-amd64", pg_catalog;
5132 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5135 REVOKE ALL ON TABLE packages FROM PUBLIC;
5136 REVOKE ALL ON TABLE packages FROM wbadm;
5137 GRANT ALL ON TABLE packages TO wbadm;
5138 GRANT SELECT ON TABLE packages TO wb_security;
5139 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5143 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5146 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5147 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5148 GRANT ALL ON TABLE pkg_history TO wbadm;
5149 GRANT SELECT ON TABLE pkg_history TO wb_security;
5150 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5154 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5157 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5158 REVOKE ALL ON TABLE transactions FROM wbadm;
5159 GRANT ALL ON TABLE transactions TO wbadm;
5160 GRANT SELECT ON TABLE transactions TO wb_security;
5161 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5165 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5168 REVOKE ALL ON TABLE users FROM PUBLIC;
5169 REVOKE ALL ON TABLE users FROM wbadm;
5170 GRANT ALL ON TABLE users TO wbadm;
5171 GRANT SELECT ON TABLE users TO wb_security;
5172 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5175 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5178 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5181 REVOKE ALL ON TABLE packages FROM PUBLIC;
5182 REVOKE ALL ON TABLE packages FROM wbadm;
5183 GRANT ALL ON TABLE packages TO wbadm;
5184 GRANT SELECT ON TABLE packages TO PUBLIC;
5188 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5191 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5192 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5193 GRANT ALL ON TABLE pkg_history TO wbadm;
5194 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5198 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5201 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5202 REVOKE ALL ON TABLE transactions FROM wbadm;
5203 GRANT ALL ON TABLE transactions TO wbadm;
5204 GRANT SELECT ON TABLE transactions TO PUBLIC;
5208 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5211 REVOKE ALL ON TABLE users FROM PUBLIC;
5212 REVOKE ALL ON TABLE users FROM wbadm;
5213 GRANT ALL ON TABLE users TO wbadm;
5214 GRANT SELECT ON TABLE users TO PUBLIC;
5217 SET search_path = "kfreebsd-i386", pg_catalog;
5220 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5223 REVOKE ALL ON TABLE packages FROM PUBLIC;
5224 REVOKE ALL ON TABLE packages FROM wbadm;
5225 GRANT ALL ON TABLE packages TO wbadm;
5226 GRANT SELECT ON TABLE packages TO wb_security;
5227 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5231 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5234 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5235 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5236 GRANT ALL ON TABLE pkg_history TO wbadm;
5237 GRANT SELECT ON TABLE pkg_history TO wb_security;
5238 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5242 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5245 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5246 REVOKE ALL ON TABLE transactions FROM wbadm;
5247 GRANT ALL ON TABLE transactions TO wbadm;
5248 GRANT SELECT ON TABLE transactions TO wb_security;
5249 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5253 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5256 REVOKE ALL ON TABLE users FROM PUBLIC;
5257 REVOKE ALL ON TABLE users FROM wbadm;
5258 GRANT ALL ON TABLE users TO wbadm;
5259 GRANT SELECT ON TABLE users TO wb_security;
5260 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5263 SET search_path = "kfreebsd-i386_public", pg_catalog;
5266 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5269 REVOKE ALL ON TABLE packages FROM PUBLIC;
5270 REVOKE ALL ON TABLE packages FROM wbadm;
5271 GRANT ALL ON TABLE packages TO wbadm;
5272 GRANT SELECT ON TABLE packages TO PUBLIC;
5276 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5279 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5280 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5281 GRANT ALL ON TABLE pkg_history TO wbadm;
5282 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5286 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5289 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5290 REVOKE ALL ON TABLE transactions FROM wbadm;
5291 GRANT ALL ON TABLE transactions TO wbadm;
5292 GRANT SELECT ON TABLE transactions TO PUBLIC;
5296 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5299 REVOKE ALL ON TABLE users FROM PUBLIC;
5300 REVOKE ALL ON TABLE users FROM wbadm;
5301 GRANT ALL ON TABLE users TO wbadm;
5302 GRANT SELECT ON TABLE users TO PUBLIC;
5305 SET search_path = mips, pg_catalog;
5308 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5311 REVOKE ALL ON TABLE packages FROM PUBLIC;
5312 REVOKE ALL ON TABLE packages FROM wbadm;
5313 GRANT ALL ON TABLE packages TO wbadm;
5314 GRANT SELECT ON TABLE packages TO wb_security;
5315 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5319 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5322 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5323 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5324 GRANT ALL ON TABLE pkg_history TO wbadm;
5325 GRANT SELECT ON TABLE pkg_history TO wb_security;
5326 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5330 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5333 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5334 REVOKE ALL ON TABLE transactions FROM wbadm;
5335 GRANT ALL ON TABLE transactions TO wbadm;
5336 GRANT SELECT ON TABLE transactions TO wb_security;
5337 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5341 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5344 REVOKE ALL ON TABLE users FROM PUBLIC;
5345 REVOKE ALL ON TABLE users FROM wbadm;
5346 GRANT ALL ON TABLE users TO wbadm;
5347 GRANT SELECT ON TABLE users TO wb_security;
5348 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5351 SET search_path = mips_public, pg_catalog;
5354 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5357 REVOKE ALL ON TABLE packages FROM PUBLIC;
5358 REVOKE ALL ON TABLE packages FROM wbadm;
5359 GRANT ALL ON TABLE packages TO wbadm;
5360 GRANT SELECT ON TABLE packages TO PUBLIC;
5364 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5367 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5368 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5369 GRANT ALL ON TABLE pkg_history TO wbadm;
5370 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5374 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5377 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5378 REVOKE ALL ON TABLE transactions FROM wbadm;
5379 GRANT ALL ON TABLE transactions TO wbadm;
5380 GRANT SELECT ON TABLE transactions TO PUBLIC;
5384 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5387 REVOKE ALL ON TABLE users FROM PUBLIC;
5388 REVOKE ALL ON TABLE users FROM wbadm;
5389 GRANT ALL ON TABLE users TO wbadm;
5390 GRANT SELECT ON TABLE users TO PUBLIC;
5393 SET search_path = mipsel, pg_catalog;
5396 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5399 REVOKE ALL ON TABLE packages FROM PUBLIC;
5400 REVOKE ALL ON TABLE packages FROM wbadm;
5401 GRANT ALL ON TABLE packages TO wbadm;
5402 GRANT SELECT ON TABLE packages TO wb_security;
5403 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5407 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5410 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5411 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5412 GRANT ALL ON TABLE pkg_history TO wbadm;
5413 GRANT SELECT ON TABLE pkg_history TO wb_security;
5414 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5418 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5421 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5422 REVOKE ALL ON TABLE transactions FROM wbadm;
5423 GRANT ALL ON TABLE transactions TO wbadm;
5424 GRANT SELECT ON TABLE transactions TO wb_security;
5425 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5429 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5432 REVOKE ALL ON TABLE users FROM PUBLIC;
5433 REVOKE ALL ON TABLE users FROM wbadm;
5434 GRANT ALL ON TABLE users TO wbadm;
5435 GRANT SELECT ON TABLE users TO wb_security;
5436 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5439 SET search_path = mipsel_public, pg_catalog;
5442 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5445 REVOKE ALL ON TABLE packages FROM PUBLIC;
5446 REVOKE ALL ON TABLE packages FROM wbadm;
5447 GRANT ALL ON TABLE packages TO wbadm;
5448 GRANT SELECT ON TABLE packages TO PUBLIC;
5452 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5455 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5456 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5457 GRANT ALL ON TABLE pkg_history TO wbadm;
5458 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5462 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5465 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5466 REVOKE ALL ON TABLE transactions FROM wbadm;
5467 GRANT ALL ON TABLE transactions TO wbadm;
5468 GRANT SELECT ON TABLE transactions TO PUBLIC;
5472 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5475 REVOKE ALL ON TABLE users FROM PUBLIC;
5476 REVOKE ALL ON TABLE users FROM wbadm;
5477 GRANT ALL ON TABLE users TO wbadm;
5478 GRANT SELECT ON TABLE users TO PUBLIC;
5481 SET search_path = powerpc, pg_catalog;
5484 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5487 REVOKE ALL ON TABLE packages FROM PUBLIC;
5488 REVOKE ALL ON TABLE packages FROM wbadm;
5489 GRANT ALL ON TABLE packages TO wbadm;
5490 GRANT SELECT ON TABLE packages TO wb_security;
5491 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5495 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5498 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5499 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5500 GRANT ALL ON TABLE pkg_history TO wbadm;
5501 GRANT SELECT ON TABLE pkg_history TO wb_security;
5502 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5506 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5509 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5510 REVOKE ALL ON TABLE transactions FROM wbadm;
5511 GRANT ALL ON TABLE transactions TO wbadm;
5512 GRANT SELECT ON TABLE transactions TO wb_security;
5513 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5517 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5520 REVOKE ALL ON TABLE users FROM PUBLIC;
5521 REVOKE ALL ON TABLE users FROM wbadm;
5522 GRANT ALL ON TABLE users TO wbadm;
5523 GRANT SELECT ON TABLE users TO wb_security;
5524 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5527 SET search_path = powerpc_public, pg_catalog;
5530 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5533 REVOKE ALL ON TABLE packages FROM PUBLIC;
5534 REVOKE ALL ON TABLE packages FROM wbadm;
5535 GRANT ALL ON TABLE packages TO wbadm;
5536 GRANT SELECT ON TABLE packages TO PUBLIC;
5540 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5543 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5544 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5545 GRANT ALL ON TABLE pkg_history TO wbadm;
5546 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5550 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5553 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5554 REVOKE ALL ON TABLE transactions FROM wbadm;
5555 GRANT ALL ON TABLE transactions TO wbadm;
5556 GRANT SELECT ON TABLE transactions TO PUBLIC;
5560 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5563 REVOKE ALL ON TABLE users FROM PUBLIC;
5564 REVOKE ALL ON TABLE users FROM wbadm;
5565 GRANT ALL ON TABLE users TO wbadm;
5566 GRANT SELECT ON TABLE users TO PUBLIC;
5569 SET search_path = public, pg_catalog;
5572 -- Name: architectures; Type: ACL; Schema: public; Owner: wbadm
5575 REVOKE ALL ON TABLE architectures FROM PUBLIC;
5576 REVOKE ALL ON TABLE architectures FROM wbadm;
5577 GRANT ALL ON TABLE architectures TO wbadm;
5578 GRANT SELECT ON TABLE architectures TO PUBLIC;
5582 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5585 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5586 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5587 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5588 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5592 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5595 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5596 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5597 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5598 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5602 -- Name: distribution_architectures_statistics; Type: ACL; Schema: public; Owner: wbadm
5605 REVOKE ALL ON TABLE distribution_architectures_statistics FROM PUBLIC;
5606 REVOKE ALL ON TABLE distribution_architectures_statistics FROM wbadm;
5607 GRANT ALL ON TABLE distribution_architectures_statistics TO wbadm;
5608 GRANT SELECT ON TABLE distribution_architectures_statistics TO PUBLIC;
5612 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5615 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5616 REVOKE ALL ON TABLE lastlog FROM wbadm;
5617 GRANT ALL ON TABLE lastlog TO wbadm;
5618 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5622 -- Name: locks; Type: ACL; Schema: public; Owner: wbadm
5625 REVOKE ALL ON TABLE locks FROM PUBLIC;
5626 REVOKE ALL ON TABLE locks FROM wbadm;
5627 GRANT ALL ON TABLE locks TO wbadm;
5628 GRANT SELECT ON TABLE locks TO PUBLIC;
5629 GRANT UPDATE ON TABLE locks TO wb_all;
5633 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5636 REVOKE ALL ON TABLE log FROM PUBLIC;
5637 REVOKE ALL ON TABLE log FROM wbadm;
5638 GRANT ALL ON TABLE log TO wbadm;
5639 GRANT SELECT ON TABLE log TO PUBLIC;
5643 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5646 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5647 REVOKE ALL ON TABLE packages_all FROM wbadm;
5648 GRANT ALL ON TABLE packages_all TO wbadm;
5649 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5653 -- Name: packages_public; Type: ACL; Schema: public; Owner: wbadm
5656 REVOKE ALL ON TABLE packages_public FROM PUBLIC;
5657 REVOKE ALL ON TABLE packages_public FROM wbadm;
5658 GRANT ALL ON TABLE packages_public TO wbadm;
5659 GRANT SELECT ON TABLE packages_public TO PUBLIC;
5662 SET search_path = s390, pg_catalog;
5665 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5668 REVOKE ALL ON TABLE packages FROM PUBLIC;
5669 REVOKE ALL ON TABLE packages FROM wbadm;
5670 GRANT ALL ON TABLE packages TO wbadm;
5671 GRANT SELECT ON TABLE packages TO wb_security;
5672 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5676 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5679 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5680 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5681 GRANT ALL ON TABLE pkg_history TO wbadm;
5682 GRANT SELECT ON TABLE pkg_history TO wb_security;
5683 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5687 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5690 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5691 REVOKE ALL ON TABLE transactions FROM wbadm;
5692 GRANT ALL ON TABLE transactions TO wbadm;
5693 GRANT SELECT ON TABLE transactions TO wb_security;
5694 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5698 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5701 REVOKE ALL ON TABLE users FROM PUBLIC;
5702 REVOKE ALL ON TABLE users FROM wbadm;
5703 GRANT ALL ON TABLE users TO wbadm;
5704 GRANT SELECT ON TABLE users TO wb_security;
5705 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5708 SET search_path = s390_public, pg_catalog;
5711 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5714 REVOKE ALL ON TABLE packages FROM PUBLIC;
5715 REVOKE ALL ON TABLE packages FROM wbadm;
5716 GRANT ALL ON TABLE packages TO wbadm;
5717 GRANT SELECT ON TABLE packages TO PUBLIC;
5721 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5724 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5725 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5726 GRANT ALL ON TABLE pkg_history TO wbadm;
5727 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5731 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5734 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5735 REVOKE ALL ON TABLE transactions FROM wbadm;
5736 GRANT ALL ON TABLE transactions TO wbadm;
5737 GRANT SELECT ON TABLE transactions TO PUBLIC;
5741 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5744 REVOKE ALL ON TABLE users FROM PUBLIC;
5745 REVOKE ALL ON TABLE users FROM wbadm;
5746 GRANT ALL ON TABLE users TO wbadm;
5747 GRANT SELECT ON TABLE users TO PUBLIC;
5750 SET search_path = s390x, pg_catalog;
5753 -- Name: packages; Type: ACL; Schema: s390x; Owner: wbadm
5756 REVOKE ALL ON TABLE packages FROM PUBLIC;
5757 REVOKE ALL ON TABLE packages FROM wbadm;
5758 GRANT ALL ON TABLE packages TO wbadm;
5759 GRANT SELECT ON TABLE packages TO wb_security;
5760 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5764 -- Name: pkg_history; Type: ACL; Schema: s390x; Owner: wbadm
5767 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5768 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5769 GRANT ALL ON TABLE pkg_history TO wbadm;
5770 GRANT SELECT ON TABLE pkg_history TO wb_security;
5771 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5775 -- Name: transactions; Type: ACL; Schema: s390x; Owner: wbadm
5778 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5779 REVOKE ALL ON TABLE transactions FROM wbadm;
5780 GRANT ALL ON TABLE transactions TO wbadm;
5781 GRANT SELECT ON TABLE transactions TO wb_security;
5782 GRANT SELECT,INSERT,UPDATE ON TABLE transactions TO wb_all;
5786 -- Name: users; Type: ACL; Schema: s390x; Owner: wbadm
5789 REVOKE ALL ON TABLE users FROM PUBLIC;
5790 REVOKE ALL ON TABLE users FROM wbadm;
5791 GRANT ALL ON TABLE users TO wbadm;
5792 GRANT SELECT ON TABLE users TO wb_security;
5793 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5796 SET search_path = s390x_public, pg_catalog;
5799 -- Name: packages; Type: ACL; Schema: s390x_public; Owner: wbadm
5802 REVOKE ALL ON TABLE packages FROM PUBLIC;
5803 REVOKE ALL ON TABLE packages FROM wbadm;
5804 GRANT ALL ON TABLE packages TO wbadm;
5805 GRANT SELECT ON TABLE packages TO PUBLIC;
5809 -- Name: pkg_history; Type: ACL; Schema: s390x_public; Owner: wbadm
5812 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5813 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5814 GRANT ALL ON TABLE pkg_history TO wbadm;
5815 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5819 -- Name: transactions; Type: ACL; Schema: s390x_public; Owner: wbadm
5822 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5823 REVOKE ALL ON TABLE transactions FROM wbadm;
5824 GRANT ALL ON TABLE transactions TO wbadm;
5825 GRANT SELECT ON TABLE transactions TO PUBLIC;
5829 -- Name: users; Type: ACL; Schema: s390x_public; Owner: wbadm
5832 REVOKE ALL ON TABLE users FROM PUBLIC;
5833 REVOKE ALL ON TABLE users FROM wbadm;
5834 GRANT ALL ON TABLE users TO wbadm;
5835 GRANT SELECT ON TABLE users TO PUBLIC;
5838 SET search_path = sparc, pg_catalog;
5841 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5844 REVOKE ALL ON TABLE packages FROM PUBLIC;
5845 REVOKE ALL ON TABLE packages FROM wbadm;
5846 GRANT ALL ON TABLE packages TO wbadm;
5847 GRANT SELECT ON TABLE packages TO wb_security;
5848 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5852 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5855 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5856 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5857 GRANT ALL ON TABLE pkg_history TO wbadm;
5858 GRANT SELECT ON TABLE pkg_history TO wb_security;
5859 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5863 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5866 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5867 REVOKE ALL ON TABLE transactions FROM wbadm;
5868 GRANT ALL ON TABLE transactions TO wbadm;
5869 GRANT SELECT ON TABLE transactions TO wb_security;
5870 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5874 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5877 REVOKE ALL ON TABLE users FROM PUBLIC;
5878 REVOKE ALL ON TABLE users FROM wbadm;
5879 GRANT ALL ON TABLE users TO wbadm;
5880 GRANT SELECT ON TABLE users TO wb_security;
5881 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5884 SET search_path = sparc_public, pg_catalog;
5887 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5890 REVOKE ALL ON TABLE packages FROM PUBLIC;
5891 REVOKE ALL ON TABLE packages FROM wbadm;
5892 GRANT ALL ON TABLE packages TO wbadm;
5893 GRANT SELECT ON TABLE packages TO PUBLIC;
5897 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5900 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5901 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5902 GRANT ALL ON TABLE pkg_history TO wbadm;
5903 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5907 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5910 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5911 REVOKE ALL ON TABLE transactions FROM wbadm;
5912 GRANT ALL ON TABLE transactions TO wbadm;
5913 GRANT SELECT ON TABLE transactions TO PUBLIC;
5917 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5920 REVOKE ALL ON TABLE users FROM PUBLIC;
5921 REVOKE ALL ON TABLE users FROM wbadm;
5922 GRANT ALL ON TABLE users TO wbadm;
5923 GRANT SELECT ON TABLE users TO PUBLIC;
5927 -- PostgreSQL database dump complete