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: hppa; Type: SCHEMA; Schema: -; Owner: wbadm
91 ALTER SCHEMA hppa OWNER TO wbadm;
94 -- Name: hppa_public; Type: SCHEMA; Schema: -; Owner: wbadm
97 CREATE SCHEMA hppa_public;
100 ALTER SCHEMA hppa_public OWNER TO wbadm;
103 -- Name: hurd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
106 CREATE SCHEMA "hurd-i386";
109 ALTER SCHEMA "hurd-i386" OWNER TO wbadm;
112 -- Name: hurd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
115 CREATE SCHEMA "hurd-i386_public";
118 ALTER SCHEMA "hurd-i386_public" OWNER TO wbadm;
121 -- Name: i386; Type: SCHEMA; Schema: -; Owner: wbadm
127 ALTER SCHEMA i386 OWNER TO wbadm;
130 -- Name: i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
133 CREATE SCHEMA i386_public;
136 ALTER SCHEMA i386_public OWNER TO wbadm;
139 -- Name: ia64; Type: SCHEMA; Schema: -; Owner: wbadm
145 ALTER SCHEMA ia64 OWNER TO wbadm;
148 -- Name: ia64_public; Type: SCHEMA; Schema: -; Owner: wbadm
151 CREATE SCHEMA ia64_public;
154 ALTER SCHEMA ia64_public OWNER TO wbadm;
157 -- Name: kfreebsd-amd64; Type: SCHEMA; Schema: -; Owner: wbadm
160 CREATE SCHEMA "kfreebsd-amd64";
163 ALTER SCHEMA "kfreebsd-amd64" OWNER TO wbadm;
166 -- Name: kfreebsd-amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
169 CREATE SCHEMA "kfreebsd-amd64_public";
172 ALTER SCHEMA "kfreebsd-amd64_public" OWNER TO wbadm;
175 -- Name: kfreebsd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
178 CREATE SCHEMA "kfreebsd-i386";
181 ALTER SCHEMA "kfreebsd-i386" OWNER TO wbadm;
184 -- Name: kfreebsd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
187 CREATE SCHEMA "kfreebsd-i386_public";
190 ALTER SCHEMA "kfreebsd-i386_public" OWNER TO wbadm;
193 -- Name: mips; Type: SCHEMA; Schema: -; Owner: wbadm
199 ALTER SCHEMA mips OWNER TO wbadm;
202 -- Name: mips_public; Type: SCHEMA; Schema: -; Owner: wbadm
205 CREATE SCHEMA mips_public;
208 ALTER SCHEMA mips_public OWNER TO wbadm;
211 -- Name: mipsel; Type: SCHEMA; Schema: -; Owner: wbadm
214 CREATE SCHEMA mipsel;
217 ALTER SCHEMA mipsel OWNER TO wbadm;
220 -- Name: mipsel_public; Type: SCHEMA; Schema: -; Owner: wbadm
223 CREATE SCHEMA mipsel_public;
226 ALTER SCHEMA mipsel_public OWNER TO wbadm;
229 -- Name: powerpc; Type: SCHEMA; Schema: -; Owner: wbadm
232 CREATE SCHEMA powerpc;
235 ALTER SCHEMA powerpc OWNER TO wbadm;
238 -- Name: powerpc_public; Type: SCHEMA; Schema: -; Owner: wbadm
241 CREATE SCHEMA powerpc_public;
244 ALTER SCHEMA powerpc_public OWNER TO wbadm;
247 -- Name: s390; Type: SCHEMA; Schema: -; Owner: wbadm
253 ALTER SCHEMA s390 OWNER TO wbadm;
256 -- Name: s390_public; Type: SCHEMA; Schema: -; Owner: wbadm
259 CREATE SCHEMA s390_public;
262 ALTER SCHEMA s390_public OWNER TO wbadm;
265 -- Name: sparc; Type: SCHEMA; Schema: -; Owner: wbadm
271 ALTER SCHEMA sparc OWNER TO wbadm;
274 -- Name: sparc_public; Type: SCHEMA; Schema: -; Owner: wbadm
277 CREATE SCHEMA sparc_public;
280 ALTER SCHEMA sparc_public OWNER TO wbadm;
283 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: wbadm
286 CREATE PROCEDURAL LANGUAGE plpgsql;
289 ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO wbadm;
291 SET search_path = public, pg_catalog;
294 -- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres
297 CREATE TYPE debversion;
301 -- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres
304 CREATE FUNCTION debversionin(cstring) RETURNS debversion
305 LANGUAGE internal IMMUTABLE STRICT
309 ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres;
312 -- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres
315 CREATE FUNCTION debversionout(debversion) RETURNS cstring
316 LANGUAGE internal IMMUTABLE STRICT
320 ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres;
323 -- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres
326 CREATE FUNCTION debversionrecv(internal) RETURNS debversion
327 LANGUAGE internal STABLE STRICT
331 ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres;
334 -- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres
337 CREATE FUNCTION debversionsend(debversion) RETURNS bytea
338 LANGUAGE internal STABLE STRICT
342 ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres;
345 -- Name: debversion; Type: TYPE; Schema: public; Owner: postgres
348 CREATE TYPE debversion (
349 INTERNALLENGTH = variable,
350 INPUT = debversionin,
351 OUTPUT = debversionout,
352 RECEIVE = debversionrecv,
353 SEND = debversionsend,
360 ALTER TYPE public.debversion OWNER TO postgres;
363 -- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres
366 COMMENT ON TYPE debversion IS 'Debian package version number';
370 -- Name: commacat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
373 CREATE FUNCTION commacat(acc text, instr text) RETURNS text
377 IF acc IS NULL OR acc = '' THEN
380 RETURN acc || ', ' || instr;
386 ALTER FUNCTION public.commacat(acc text, instr text) OWNER TO pkern;
389 -- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres
392 CREATE FUNCTION debversion(character) RETURNS debversion
393 LANGUAGE internal IMMUTABLE STRICT
397 ALTER FUNCTION public.debversion(character) OWNER TO postgres;
400 -- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
403 CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer
404 LANGUAGE c IMMUTABLE STRICT
405 AS '$libdir/debversion', 'debversion_cmp';
408 ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres;
411 -- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
414 COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions';
418 -- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
421 CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean
422 LANGUAGE c IMMUTABLE STRICT
423 AS '$libdir/debversion', 'debversion_eq';
426 ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres;
429 -- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
432 COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal';
436 -- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
439 CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean
440 LANGUAGE c IMMUTABLE STRICT
441 AS '$libdir/debversion', 'debversion_ge';
444 ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres;
447 -- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
450 COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal';
454 -- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
457 CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean
458 LANGUAGE c IMMUTABLE STRICT
459 AS '$libdir/debversion', 'debversion_gt';
462 ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres;
465 -- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
468 COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than';
472 -- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres
475 CREATE FUNCTION debversion_hash(debversion) RETURNS integer
476 LANGUAGE c IMMUTABLE STRICT
477 AS '$libdir/debversion', 'debversion_hash';
480 ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres;
483 -- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
486 CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion
487 LANGUAGE c IMMUTABLE STRICT
488 AS '$libdir/debversion', 'debversion_larger';
491 ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres;
494 -- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
497 CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean
498 LANGUAGE c IMMUTABLE STRICT
499 AS '$libdir/debversion', 'debversion_le';
502 ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres;
505 -- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
508 COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal';
512 -- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
515 CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean
516 LANGUAGE c IMMUTABLE STRICT
517 AS '$libdir/debversion', 'debversion_lt';
520 ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres;
523 -- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
526 COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than';
530 -- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
533 CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean
534 LANGUAGE c IMMUTABLE STRICT
535 AS '$libdir/debversion', 'debversion_ne';
538 ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres;
541 -- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
544 COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal';
548 -- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
551 CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion
552 LANGUAGE c IMMUTABLE STRICT
553 AS '$libdir/debversion', 'debversion_smaller';
556 ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres;
559 -- Name: query_source_package(character varying, character varying); Type: FUNCTION; Schema: public; Owner: wbadm
562 CREATE FUNCTION query_source_package(param_dist character varying, param_srcpkg character varying) RETURNS SETOF record
566 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;
571 ALTER FUNCTION public.query_source_package(param_dist character varying, param_srcpkg character varying) OWNER TO wbadm;
574 -- Name: spacecat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
577 CREATE FUNCTION spacecat(acc text, instr text) RETURNS text
581 IF acc IS NULL OR acc = '' THEN
584 RETURN acc || ' ' || instr;
590 ALTER FUNCTION public.spacecat(acc text, instr text) OWNER TO pkern;
593 -- Name: commacat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
596 CREATE AGGREGATE commacat_all(text) (
603 ALTER AGGREGATE public.commacat_all(text) OWNER TO pkern;
606 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
610 PROCEDURE = debversion_gt,
611 LEFTARG = debversion,
612 RIGHTARG = debversion,
618 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
621 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
624 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
628 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
631 CREATE AGGREGATE max(debversion) (
632 SFUNC = debversion_larger,
638 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
641 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
645 PROCEDURE = debversion_lt,
646 LEFTARG = debversion,
647 RIGHTARG = debversion,
653 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
656 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
659 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
663 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
666 CREATE AGGREGATE min(debversion) (
667 SFUNC = debversion_smaller,
673 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
676 -- Name: spacecat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
679 CREATE AGGREGATE spacecat_all(text) (
686 ALTER AGGREGATE public.spacecat_all(text) OWNER TO pkern;
689 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
693 PROCEDURE = debversion_le,
694 LEFTARG = debversion,
695 RIGHTARG = debversion,
701 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
704 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
707 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
711 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
715 PROCEDURE = debversion_ne,
716 LEFTARG = debversion,
717 RIGHTARG = debversion,
723 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
726 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
729 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
733 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
737 PROCEDURE = debversion_eq,
738 LEFTARG = debversion,
739 RIGHTARG = debversion,
745 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
748 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
751 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
755 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
759 PROCEDURE = debversion_ge,
760 LEFTARG = debversion,
761 RIGHTARG = debversion,
767 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
770 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
773 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
777 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
780 CREATE OPERATOR CLASS debversion_ops
781 DEFAULT FOR TYPE debversion USING btree AS
782 OPERATOR 1 <(debversion,debversion) ,
783 OPERATOR 2 <=(debversion,debversion) ,
784 OPERATOR 3 =(debversion,debversion) ,
785 OPERATOR 4 >=(debversion,debversion) ,
786 OPERATOR 5 >(debversion,debversion) ,
787 FUNCTION 1 debversion_cmp(debversion,debversion);
790 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
793 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
796 CREATE OPERATOR CLASS debversion_ops
797 DEFAULT FOR TYPE debversion USING hash AS
798 OPERATOR 1 =(debversion,debversion) ,
799 FUNCTION 1 debversion_hash(debversion);
802 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
804 SET search_path = pg_catalog;
807 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
810 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
814 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
817 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
821 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
824 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
828 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
831 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
835 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
838 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
842 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
845 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
848 SET search_path = public, pg_catalog;
850 SET default_tablespace = '';
852 SET default_with_oids = false;
855 -- Name: packages; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
858 CREATE TABLE packages (
859 architecture character varying NOT NULL,
860 package character varying NOT NULL,
861 distribution character varying NOT NULL,
863 state character varying,
864 section character varying,
865 priority character varying,
866 installed_version character varying,
867 previous_state character varying,
868 state_change timestamp without time zone,
869 notes character varying,
870 builder character varying,
873 binary_nmu_version integer,
874 binary_nmu_changelog character varying,
875 failed_category character varying,
876 permbuildpri integer,
878 depends character varying,
879 rel character varying,
881 extra_depends character varying,
882 extra_conflicts character varying,
883 build_arch_all boolean DEFAULT false
887 ALTER TABLE public.packages OWNER TO wbadm;
889 SET search_path = alpha, pg_catalog;
892 -- Name: packages; Type: VIEW; Schema: alpha; Owner: wbadm
895 CREATE VIEW packages AS
896 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);
899 ALTER TABLE alpha.packages OWNER TO wbadm;
901 SET search_path = public, pg_catalog;
904 -- Name: pkg_history; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
907 CREATE TABLE pkg_history (
908 architecture character varying NOT NULL,
909 package character varying NOT NULL,
910 distribution character varying NOT NULL,
911 version debversion NOT NULL,
912 "timestamp" timestamp without time zone NOT NULL,
913 result character varying NOT NULL,
916 builder character varying
920 ALTER TABLE public.pkg_history OWNER TO wbadm;
922 SET search_path = alpha, pg_catalog;
925 -- Name: pkg_history; Type: VIEW; Schema: alpha; Owner: wbadm
928 CREATE VIEW pkg_history AS
929 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);
932 ALTER TABLE alpha.pkg_history OWNER TO wbadm;
934 SET search_path = public, pg_catalog;
937 -- Name: transactions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
940 CREATE TABLE transactions (
941 architecture character varying,
942 package character varying,
943 distribution character varying,
945 action character varying,
946 prevstate character varying,
947 state character varying,
948 real_user character varying,
949 set_user character varying,
950 "time" timestamp without time zone
954 ALTER TABLE public.transactions OWNER TO wbadm;
956 SET search_path = alpha, pg_catalog;
959 -- Name: transactions; Type: VIEW; Schema: alpha; Owner: wbadm
962 CREATE VIEW transactions AS
963 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);
966 ALTER TABLE alpha.transactions OWNER TO wbadm;
968 SET search_path = public, pg_catalog;
971 -- Name: users; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
975 architecture character varying NOT NULL,
976 username character varying NOT NULL,
977 distribution character varying NOT NULL,
978 last_seen timestamp without time zone
982 ALTER TABLE public.users OWNER TO wbadm;
984 SET search_path = alpha, pg_catalog;
987 -- Name: users; Type: VIEW; Schema: alpha; Owner: wbadm
991 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'alpha'::text);
994 ALTER TABLE alpha.users OWNER TO wbadm;
996 SET search_path = public, pg_catalog;
999 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
1002 CREATE TABLE distributions (
1003 distribution character varying NOT NULL,
1004 public boolean DEFAULT true NOT NULL,
1005 sort_order integer DEFAULT 0,
1006 auto_dep_wait boolean DEFAULT true,
1007 build_dep_resolver character varying,
1008 archive character varying,
1009 suppress_successful_logs boolean DEFAULT false NOT NULL
1013 ALTER TABLE public.distributions OWNER TO wbadm;
1015 SET search_path = alpha_public, pg_catalog;
1018 -- Name: packages; Type: VIEW; Schema: alpha_public; Owner: wbadm
1021 CREATE VIEW packages AS
1022 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));
1025 ALTER TABLE alpha_public.packages OWNER TO wbadm;
1028 -- Name: pkg_history; Type: VIEW; Schema: alpha_public; Owner: wbadm
1031 CREATE VIEW pkg_history AS
1032 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));
1035 ALTER TABLE alpha_public.pkg_history OWNER TO wbadm;
1038 -- Name: transactions; Type: VIEW; Schema: alpha_public; Owner: wbadm
1041 CREATE VIEW transactions AS
1042 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));
1045 ALTER TABLE alpha_public.transactions OWNER TO wbadm;
1048 -- Name: users; Type: VIEW; Schema: alpha_public; Owner: wbadm
1051 CREATE VIEW users AS
1052 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));
1055 ALTER TABLE alpha_public.users OWNER TO wbadm;
1057 SET search_path = amd64, pg_catalog;
1060 -- Name: packages; Type: VIEW; Schema: amd64; Owner: wbadm
1063 CREATE VIEW packages AS
1064 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);
1067 ALTER TABLE amd64.packages OWNER TO wbadm;
1070 -- Name: pkg_history; Type: VIEW; Schema: amd64; Owner: wbadm
1073 CREATE VIEW pkg_history AS
1074 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);
1077 ALTER TABLE amd64.pkg_history OWNER TO wbadm;
1080 -- Name: transactions; Type: VIEW; Schema: amd64; Owner: wbadm
1083 CREATE VIEW transactions AS
1084 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);
1087 ALTER TABLE amd64.transactions OWNER TO wbadm;
1090 -- Name: users; Type: VIEW; Schema: amd64; Owner: wbadm
1093 CREATE VIEW users AS
1094 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'amd64'::text);
1097 ALTER TABLE amd64.users OWNER TO wbadm;
1099 SET search_path = amd64_public, pg_catalog;
1102 -- Name: packages; Type: VIEW; Schema: amd64_public; Owner: wbadm
1105 CREATE VIEW packages AS
1106 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));
1109 ALTER TABLE amd64_public.packages OWNER TO wbadm;
1112 -- Name: pkg_history; Type: VIEW; Schema: amd64_public; Owner: wbadm
1115 CREATE VIEW pkg_history AS
1116 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));
1119 ALTER TABLE amd64_public.pkg_history OWNER TO wbadm;
1122 -- Name: transactions; Type: VIEW; Schema: amd64_public; Owner: wbadm
1125 CREATE VIEW transactions AS
1126 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));
1129 ALTER TABLE amd64_public.transactions OWNER TO wbadm;
1132 -- Name: users; Type: VIEW; Schema: amd64_public; Owner: wbadm
1135 CREATE VIEW users AS
1136 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));
1139 ALTER TABLE amd64_public.users OWNER TO wbadm;
1141 SET search_path = arm, pg_catalog;
1144 -- Name: packages; Type: VIEW; Schema: arm; Owner: wbadm
1147 CREATE VIEW packages AS
1148 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);
1151 ALTER TABLE arm.packages OWNER TO wbadm;
1154 -- Name: pkg_history; Type: VIEW; Schema: arm; Owner: wbadm
1157 CREATE VIEW pkg_history AS
1158 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);
1161 ALTER TABLE arm.pkg_history OWNER TO wbadm;
1164 -- Name: transactions; Type: VIEW; Schema: arm; Owner: wbadm
1167 CREATE VIEW transactions AS
1168 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);
1171 ALTER TABLE arm.transactions OWNER TO wbadm;
1174 -- Name: users; Type: VIEW; Schema: arm; Owner: wbadm
1177 CREATE VIEW users AS
1178 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'arm'::text);
1181 ALTER TABLE arm.users OWNER TO wbadm;
1183 SET search_path = arm_public, pg_catalog;
1186 -- Name: packages; Type: VIEW; Schema: arm_public; Owner: wbadm
1189 CREATE VIEW packages AS
1190 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));
1193 ALTER TABLE arm_public.packages OWNER TO wbadm;
1196 -- Name: pkg_history; Type: VIEW; Schema: arm_public; Owner: wbadm
1199 CREATE VIEW pkg_history AS
1200 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));
1203 ALTER TABLE arm_public.pkg_history OWNER TO wbadm;
1206 -- Name: transactions; Type: VIEW; Schema: arm_public; Owner: wbadm
1209 CREATE VIEW transactions AS
1210 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));
1213 ALTER TABLE arm_public.transactions OWNER TO wbadm;
1216 -- Name: users; Type: VIEW; Schema: arm_public; Owner: wbadm
1219 CREATE VIEW users AS
1220 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));
1223 ALTER TABLE arm_public.users OWNER TO wbadm;
1225 SET search_path = armel, pg_catalog;
1228 -- Name: packages; Type: VIEW; Schema: armel; Owner: wbadm
1231 CREATE VIEW packages AS
1232 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);
1235 ALTER TABLE armel.packages OWNER TO wbadm;
1238 -- Name: pkg_history; Type: VIEW; Schema: armel; Owner: wbadm
1241 CREATE VIEW pkg_history AS
1242 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);
1245 ALTER TABLE armel.pkg_history OWNER TO wbadm;
1248 -- Name: transactions; Type: VIEW; Schema: armel; Owner: wbadm
1251 CREATE VIEW transactions AS
1252 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);
1255 ALTER TABLE armel.transactions OWNER TO wbadm;
1258 -- Name: users; Type: VIEW; Schema: armel; Owner: wbadm
1261 CREATE VIEW users AS
1262 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'armel'::text);
1265 ALTER TABLE armel.users OWNER TO wbadm;
1267 SET search_path = armel_public, pg_catalog;
1270 -- Name: packages; Type: VIEW; Schema: armel_public; Owner: wbadm
1273 CREATE VIEW packages AS
1274 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));
1277 ALTER TABLE armel_public.packages OWNER TO wbadm;
1280 -- Name: pkg_history; Type: VIEW; Schema: armel_public; Owner: wbadm
1283 CREATE VIEW pkg_history AS
1284 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));
1287 ALTER TABLE armel_public.pkg_history OWNER TO wbadm;
1290 -- Name: transactions; Type: VIEW; Schema: armel_public; Owner: wbadm
1293 CREATE VIEW transactions AS
1294 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));
1297 ALTER TABLE armel_public.transactions OWNER TO wbadm;
1300 -- Name: users; Type: VIEW; Schema: armel_public; Owner: wbadm
1303 CREATE VIEW users AS
1304 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));
1307 ALTER TABLE armel_public.users OWNER TO wbadm;
1309 SET search_path = hppa, pg_catalog;
1312 -- Name: packages; Type: VIEW; Schema: hppa; Owner: wbadm
1315 CREATE VIEW packages AS
1316 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);
1319 ALTER TABLE hppa.packages OWNER TO wbadm;
1322 -- Name: pkg_history; Type: VIEW; Schema: hppa; Owner: wbadm
1325 CREATE VIEW pkg_history AS
1326 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);
1329 ALTER TABLE hppa.pkg_history OWNER TO wbadm;
1332 -- Name: transactions; Type: VIEW; Schema: hppa; Owner: wbadm
1335 CREATE VIEW transactions AS
1336 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);
1339 ALTER TABLE hppa.transactions OWNER TO wbadm;
1342 -- Name: users; Type: VIEW; Schema: hppa; Owner: wbadm
1345 CREATE VIEW users AS
1346 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'hppa'::text);
1349 ALTER TABLE hppa.users OWNER TO wbadm;
1351 SET search_path = hppa_public, pg_catalog;
1354 -- Name: packages; Type: VIEW; Schema: hppa_public; Owner: wbadm
1357 CREATE VIEW packages AS
1358 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));
1361 ALTER TABLE hppa_public.packages OWNER TO wbadm;
1364 -- Name: pkg_history; Type: VIEW; Schema: hppa_public; Owner: wbadm
1367 CREATE VIEW pkg_history AS
1368 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));
1371 ALTER TABLE hppa_public.pkg_history OWNER TO wbadm;
1374 -- Name: transactions; Type: VIEW; Schema: hppa_public; Owner: wbadm
1377 CREATE VIEW transactions AS
1378 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));
1381 ALTER TABLE hppa_public.transactions OWNER TO wbadm;
1384 -- Name: users; Type: VIEW; Schema: hppa_public; Owner: wbadm
1387 CREATE VIEW users AS
1388 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));
1391 ALTER TABLE hppa_public.users OWNER TO wbadm;
1393 SET search_path = "hurd-i386", pg_catalog;
1396 -- Name: packages; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1399 CREATE VIEW packages AS
1400 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);
1403 ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
1406 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1409 CREATE VIEW pkg_history AS
1410 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);
1413 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
1416 -- Name: transactions; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1419 CREATE VIEW transactions AS
1420 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);
1423 ALTER TABLE "hurd-i386".transactions OWNER TO wbadm;
1426 -- Name: users; Type: VIEW; Schema: hurd-i386; Owner: wbadm
1429 CREATE VIEW users AS
1430 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'hurd-i386'::text);
1433 ALTER TABLE "hurd-i386".users OWNER TO wbadm;
1435 SET search_path = "hurd-i386_public", pg_catalog;
1438 -- Name: packages; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1441 CREATE VIEW packages AS
1442 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));
1445 ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
1448 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1451 CREATE VIEW pkg_history AS
1452 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));
1455 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
1458 -- Name: transactions; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1461 CREATE VIEW transactions AS
1462 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));
1465 ALTER TABLE "hurd-i386_public".transactions OWNER TO wbadm;
1468 -- Name: users; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1471 CREATE VIEW users AS
1472 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));
1475 ALTER TABLE "hurd-i386_public".users OWNER TO wbadm;
1477 SET search_path = i386, pg_catalog;
1480 -- Name: packages; Type: VIEW; Schema: i386; Owner: wbadm
1483 CREATE VIEW packages AS
1484 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);
1487 ALTER TABLE i386.packages OWNER TO wbadm;
1490 -- Name: pkg_history; Type: VIEW; Schema: i386; Owner: wbadm
1493 CREATE VIEW pkg_history AS
1494 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);
1497 ALTER TABLE i386.pkg_history OWNER TO wbadm;
1500 -- Name: transactions; Type: VIEW; Schema: i386; Owner: wbadm
1503 CREATE VIEW transactions AS
1504 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);
1507 ALTER TABLE i386.transactions OWNER TO wbadm;
1510 -- Name: users; Type: VIEW; Schema: i386; Owner: wbadm
1513 CREATE VIEW users AS
1514 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'i386'::text);
1517 ALTER TABLE i386.users OWNER TO wbadm;
1519 SET search_path = i386_public, pg_catalog;
1522 -- Name: packages; Type: VIEW; Schema: i386_public; Owner: wbadm
1525 CREATE VIEW packages AS
1526 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));
1529 ALTER TABLE i386_public.packages OWNER TO wbadm;
1532 -- Name: pkg_history; Type: VIEW; Schema: i386_public; Owner: wbadm
1535 CREATE VIEW pkg_history AS
1536 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));
1539 ALTER TABLE i386_public.pkg_history OWNER TO wbadm;
1542 -- Name: transactions; Type: VIEW; Schema: i386_public; Owner: wbadm
1545 CREATE VIEW transactions AS
1546 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));
1549 ALTER TABLE i386_public.transactions OWNER TO wbadm;
1552 -- Name: users; Type: VIEW; Schema: i386_public; Owner: wbadm
1555 CREATE VIEW users AS
1556 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));
1559 ALTER TABLE i386_public.users OWNER TO wbadm;
1561 SET search_path = ia64, pg_catalog;
1564 -- Name: packages; Type: VIEW; Schema: ia64; Owner: wbadm
1567 CREATE VIEW packages AS
1568 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);
1571 ALTER TABLE ia64.packages OWNER TO wbadm;
1574 -- Name: pkg_history; Type: VIEW; Schema: ia64; Owner: wbadm
1577 CREATE VIEW pkg_history AS
1578 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);
1581 ALTER TABLE ia64.pkg_history OWNER TO wbadm;
1584 -- Name: transactions; Type: VIEW; Schema: ia64; Owner: wbadm
1587 CREATE VIEW transactions AS
1588 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);
1591 ALTER TABLE ia64.transactions OWNER TO wbadm;
1594 -- Name: users; Type: VIEW; Schema: ia64; Owner: wbadm
1597 CREATE VIEW users AS
1598 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'ia64'::text);
1601 ALTER TABLE ia64.users OWNER TO wbadm;
1603 SET search_path = ia64_public, pg_catalog;
1606 -- Name: packages; Type: VIEW; Schema: ia64_public; Owner: wbadm
1609 CREATE VIEW packages AS
1610 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));
1613 ALTER TABLE ia64_public.packages OWNER TO wbadm;
1616 -- Name: pkg_history; Type: VIEW; Schema: ia64_public; Owner: wbadm
1619 CREATE VIEW pkg_history AS
1620 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));
1623 ALTER TABLE ia64_public.pkg_history OWNER TO wbadm;
1626 -- Name: transactions; Type: VIEW; Schema: ia64_public; Owner: wbadm
1629 CREATE VIEW transactions AS
1630 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));
1633 ALTER TABLE ia64_public.transactions OWNER TO wbadm;
1636 -- Name: users; Type: VIEW; Schema: ia64_public; Owner: wbadm
1639 CREATE VIEW users AS
1640 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));
1643 ALTER TABLE ia64_public.users OWNER TO wbadm;
1645 SET search_path = "kfreebsd-amd64", pg_catalog;
1648 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1651 CREATE VIEW packages AS
1652 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);
1655 ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
1658 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1661 CREATE VIEW pkg_history AS
1662 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);
1665 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
1668 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1671 CREATE VIEW transactions AS
1672 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);
1675 ALTER TABLE "kfreebsd-amd64".transactions OWNER TO wbadm;
1678 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64; Owner: wbadm
1681 CREATE VIEW users AS
1682 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'kfreebsd-amd64'::text);
1685 ALTER TABLE "kfreebsd-amd64".users OWNER TO wbadm;
1687 SET search_path = "kfreebsd-amd64_public", pg_catalog;
1690 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1693 CREATE VIEW packages AS
1694 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));
1697 ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
1700 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1703 CREATE VIEW pkg_history AS
1704 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));
1707 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
1710 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1713 CREATE VIEW transactions AS
1714 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));
1717 ALTER TABLE "kfreebsd-amd64_public".transactions OWNER TO wbadm;
1720 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
1723 CREATE VIEW users AS
1724 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));
1727 ALTER TABLE "kfreebsd-amd64_public".users OWNER TO wbadm;
1729 SET search_path = "kfreebsd-i386", pg_catalog;
1732 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1735 CREATE VIEW packages AS
1736 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);
1739 ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
1742 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1745 CREATE VIEW pkg_history AS
1746 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);
1749 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
1752 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1755 CREATE VIEW transactions AS
1756 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);
1759 ALTER TABLE "kfreebsd-i386".transactions OWNER TO wbadm;
1762 -- Name: users; Type: VIEW; Schema: kfreebsd-i386; Owner: wbadm
1765 CREATE VIEW users AS
1766 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'kfreebsd-i386'::text);
1769 ALTER TABLE "kfreebsd-i386".users OWNER TO wbadm;
1771 SET search_path = "kfreebsd-i386_public", pg_catalog;
1774 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1777 CREATE VIEW packages AS
1778 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));
1781 ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
1784 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1787 CREATE VIEW pkg_history AS
1788 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));
1791 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
1794 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1797 CREATE VIEW transactions AS
1798 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));
1801 ALTER TABLE "kfreebsd-i386_public".transactions OWNER TO wbadm;
1804 -- Name: users; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
1807 CREATE VIEW users AS
1808 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));
1811 ALTER TABLE "kfreebsd-i386_public".users OWNER TO wbadm;
1813 SET search_path = mips, pg_catalog;
1816 -- Name: packages; Type: VIEW; Schema: mips; Owner: wbadm
1819 CREATE VIEW packages AS
1820 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);
1823 ALTER TABLE mips.packages OWNER TO wbadm;
1826 -- Name: pkg_history; Type: VIEW; Schema: mips; Owner: wbadm
1829 CREATE VIEW pkg_history AS
1830 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);
1833 ALTER TABLE mips.pkg_history OWNER TO wbadm;
1836 -- Name: transactions; Type: VIEW; Schema: mips; Owner: wbadm
1839 CREATE VIEW transactions AS
1840 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);
1843 ALTER TABLE mips.transactions OWNER TO wbadm;
1846 -- Name: users; Type: VIEW; Schema: mips; Owner: wbadm
1849 CREATE VIEW users AS
1850 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'mips'::text);
1853 ALTER TABLE mips.users OWNER TO wbadm;
1855 SET search_path = mips_public, pg_catalog;
1858 -- Name: packages; Type: VIEW; Schema: mips_public; Owner: wbadm
1861 CREATE VIEW packages AS
1862 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));
1865 ALTER TABLE mips_public.packages OWNER TO wbadm;
1868 -- Name: pkg_history; Type: VIEW; Schema: mips_public; Owner: wbadm
1871 CREATE VIEW pkg_history AS
1872 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));
1875 ALTER TABLE mips_public.pkg_history OWNER TO wbadm;
1878 -- Name: transactions; Type: VIEW; Schema: mips_public; Owner: wbadm
1881 CREATE VIEW transactions AS
1882 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));
1885 ALTER TABLE mips_public.transactions OWNER TO wbadm;
1888 -- Name: users; Type: VIEW; Schema: mips_public; Owner: wbadm
1891 CREATE VIEW users AS
1892 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));
1895 ALTER TABLE mips_public.users OWNER TO wbadm;
1897 SET search_path = mipsel, pg_catalog;
1900 -- Name: packages; Type: VIEW; Schema: mipsel; Owner: wbadm
1903 CREATE VIEW packages AS
1904 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);
1907 ALTER TABLE mipsel.packages OWNER TO wbadm;
1910 -- Name: pkg_history; Type: VIEW; Schema: mipsel; Owner: wbadm
1913 CREATE VIEW pkg_history AS
1914 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);
1917 ALTER TABLE mipsel.pkg_history OWNER TO wbadm;
1920 -- Name: transactions; Type: VIEW; Schema: mipsel; Owner: wbadm
1923 CREATE VIEW transactions AS
1924 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);
1927 ALTER TABLE mipsel.transactions OWNER TO wbadm;
1930 -- Name: users; Type: VIEW; Schema: mipsel; Owner: wbadm
1933 CREATE VIEW users AS
1934 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'mipsel'::text);
1937 ALTER TABLE mipsel.users OWNER TO wbadm;
1939 SET search_path = mipsel_public, pg_catalog;
1942 -- Name: packages; Type: VIEW; Schema: mipsel_public; Owner: wbadm
1945 CREATE VIEW packages AS
1946 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));
1949 ALTER TABLE mipsel_public.packages OWNER TO wbadm;
1952 -- Name: pkg_history; Type: VIEW; Schema: mipsel_public; Owner: wbadm
1955 CREATE VIEW pkg_history AS
1956 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));
1959 ALTER TABLE mipsel_public.pkg_history OWNER TO wbadm;
1962 -- Name: transactions; Type: VIEW; Schema: mipsel_public; Owner: wbadm
1965 CREATE VIEW transactions AS
1966 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));
1969 ALTER TABLE mipsel_public.transactions OWNER TO wbadm;
1972 -- Name: users; Type: VIEW; Schema: mipsel_public; Owner: wbadm
1975 CREATE VIEW users AS
1976 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));
1979 ALTER TABLE mipsel_public.users OWNER TO wbadm;
1981 SET search_path = powerpc, pg_catalog;
1984 -- Name: packages; Type: VIEW; Schema: powerpc; Owner: wbadm
1987 CREATE VIEW packages AS
1988 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);
1991 ALTER TABLE powerpc.packages OWNER TO wbadm;
1994 -- Name: pkg_history; Type: VIEW; Schema: powerpc; Owner: wbadm
1997 CREATE VIEW pkg_history AS
1998 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);
2001 ALTER TABLE powerpc.pkg_history OWNER TO wbadm;
2004 -- Name: transactions; Type: VIEW; Schema: powerpc; Owner: wbadm
2007 CREATE VIEW transactions AS
2008 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);
2011 ALTER TABLE powerpc.transactions OWNER TO wbadm;
2014 -- Name: users; Type: VIEW; Schema: powerpc; Owner: wbadm
2017 CREATE VIEW users AS
2018 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'powerpc'::text);
2021 ALTER TABLE powerpc.users OWNER TO wbadm;
2023 SET search_path = powerpc_public, pg_catalog;
2026 -- Name: packages; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2029 CREATE VIEW packages AS
2030 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));
2033 ALTER TABLE powerpc_public.packages OWNER TO wbadm;
2036 -- Name: pkg_history; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2039 CREATE VIEW pkg_history AS
2040 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));
2043 ALTER TABLE powerpc_public.pkg_history OWNER TO wbadm;
2046 -- Name: transactions; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2049 CREATE VIEW transactions AS
2050 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));
2053 ALTER TABLE powerpc_public.transactions OWNER TO wbadm;
2056 -- Name: users; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2059 CREATE VIEW users AS
2060 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));
2063 ALTER TABLE powerpc_public.users OWNER TO wbadm;
2065 SET search_path = public, pg_catalog;
2068 -- Name: architectures; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2071 CREATE TABLE architectures (
2072 architecture character varying NOT NULL
2076 ALTER TABLE public.architectures OWNER TO wbadm;
2079 -- Name: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2082 CREATE TABLE distribution_aliases (
2083 alias character varying NOT NULL,
2084 distribution character varying NOT NULL
2088 ALTER TABLE public.distribution_aliases OWNER TO wbadm;
2091 -- Name: distribution_architectures; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2094 CREATE TABLE distribution_architectures (
2095 distribution character varying NOT NULL,
2096 architecture character varying NOT NULL
2100 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2103 -- Name: distribution_architectures_statistics; Type: VIEW; Schema: public; Owner: wbadm
2106 CREATE VIEW distribution_architectures_statistics AS
2107 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;
2110 ALTER TABLE public.distribution_architectures_statistics OWNER TO wbadm;
2113 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2116 CREATE VIEW lastlog AS
2117 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;
2120 ALTER TABLE public.lastlog OWNER TO wbadm;
2123 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2127 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;
2130 ALTER TABLE public.log OWNER TO wbadm;
2133 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2136 CREATE VIEW packages_all AS
2137 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);
2140 ALTER TABLE public.packages_all OWNER TO wbadm;
2143 -- Name: packages_public; Type: VIEW; Schema: public; Owner: wbadm
2146 CREATE VIEW packages_public AS
2147 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);
2150 ALTER TABLE public.packages_public OWNER TO wbadm;
2152 SET search_path = s390, pg_catalog;
2155 -- Name: packages; Type: VIEW; Schema: s390; Owner: wbadm
2158 CREATE VIEW packages AS
2159 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);
2162 ALTER TABLE s390.packages OWNER TO wbadm;
2165 -- Name: pkg_history; Type: VIEW; Schema: s390; Owner: wbadm
2168 CREATE VIEW pkg_history AS
2169 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);
2172 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2175 -- Name: transactions; Type: VIEW; Schema: s390; Owner: wbadm
2178 CREATE VIEW transactions AS
2179 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);
2182 ALTER TABLE s390.transactions OWNER TO wbadm;
2185 -- Name: users; Type: VIEW; Schema: s390; Owner: wbadm
2188 CREATE VIEW users AS
2189 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390'::text);
2192 ALTER TABLE s390.users OWNER TO wbadm;
2194 SET search_path = s390_public, pg_catalog;
2197 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2200 CREATE VIEW packages AS
2201 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));
2204 ALTER TABLE s390_public.packages OWNER TO wbadm;
2207 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2210 CREATE VIEW pkg_history AS
2211 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));
2214 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2217 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2220 CREATE VIEW transactions AS
2221 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));
2224 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2227 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2230 CREATE VIEW users AS
2231 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));
2234 ALTER TABLE s390_public.users OWNER TO wbadm;
2236 SET search_path = sparc, pg_catalog;
2239 -- Name: packages; Type: VIEW; Schema: sparc; Owner: wbadm
2242 CREATE VIEW packages AS
2243 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);
2246 ALTER TABLE sparc.packages OWNER TO wbadm;
2249 -- Name: pkg_history; Type: VIEW; Schema: sparc; Owner: wbadm
2252 CREATE VIEW pkg_history AS
2253 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);
2256 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2259 -- Name: transactions; Type: VIEW; Schema: sparc; Owner: wbadm
2262 CREATE VIEW transactions AS
2263 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);
2266 ALTER TABLE sparc.transactions OWNER TO wbadm;
2269 -- Name: users; Type: VIEW; Schema: sparc; Owner: wbadm
2272 CREATE VIEW users AS
2273 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'sparc'::text);
2276 ALTER TABLE sparc.users OWNER TO wbadm;
2278 SET search_path = sparc_public, pg_catalog;
2281 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2284 CREATE VIEW packages AS
2285 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));
2288 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2291 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2294 CREATE VIEW pkg_history AS
2295 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));
2298 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2301 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2304 CREATE VIEW transactions AS
2305 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));
2308 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2311 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2314 CREATE VIEW users AS
2315 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));
2318 ALTER TABLE sparc_public.users OWNER TO wbadm;
2320 SET search_path = public, pg_catalog;
2323 -- Name: architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2326 ALTER TABLE ONLY architectures
2327 ADD CONSTRAINT architectures_pkey PRIMARY KEY (architecture);
2331 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2334 ALTER TABLE ONLY distribution_aliases
2335 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
2339 -- Name: distribution_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2342 ALTER TABLE ONLY distribution_architectures
2343 ADD CONSTRAINT distribution_architectures_pkey PRIMARY KEY (distribution, architecture);
2347 -- Name: packages_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2350 ALTER TABLE ONLY packages
2351 ADD CONSTRAINT packages_pkey PRIMARY KEY (architecture, package, distribution);
2355 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2358 ALTER TABLE ONLY pkg_history
2359 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (architecture, package, distribution, version, "timestamp");
2363 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2366 ALTER TABLE ONLY users
2367 ADD CONSTRAINT users_pkey PRIMARY KEY (architecture, username, distribution);
2371 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2374 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
2378 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2381 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
2385 -- Name: packages_arch_dist_state; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2388 CREATE INDEX packages_arch_dist_state ON packages USING btree (architecture, distribution, upper((state)::text));
2392 -- Name: packages_distribution_package; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2395 CREATE INDEX packages_distribution_package ON packages USING btree (distribution, package);
2399 -- Name: pkg_history_timestamp; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2402 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
2405 SET search_path = alpha, pg_catalog;
2408 -- Name: packages_delete; Type: RULE; Schema: alpha; Owner: wbadm
2411 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));
2415 -- Name: packages_insert; Type: RULE; Schema: alpha; Owner: wbadm
2418 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);
2422 -- Name: packages_update; Type: RULE; Schema: alpha; Owner: wbadm
2425 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));
2429 -- Name: pkg_history_delete; Type: RULE; Schema: alpha; Owner: wbadm
2432 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"));
2436 -- Name: pkg_history_insert; Type: RULE; Schema: alpha; Owner: wbadm
2439 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);
2443 -- Name: pkg_history_update; Type: RULE; Schema: alpha; Owner: wbadm
2446 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"));
2450 -- Name: transactions_insert; Type: RULE; Schema: alpha; Owner: wbadm
2453 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");
2457 -- Name: users_delete; Type: RULE; Schema: alpha; Owner: wbadm
2460 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));
2464 -- Name: users_insert; Type: RULE; Schema: alpha; Owner: wbadm
2467 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);
2471 -- Name: users_update; Type: RULE; Schema: alpha; Owner: wbadm
2474 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));
2477 SET search_path = amd64, pg_catalog;
2480 -- Name: packages_delete; Type: RULE; Schema: amd64; Owner: wbadm
2483 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));
2487 -- Name: packages_insert; Type: RULE; Schema: amd64; Owner: wbadm
2490 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);
2494 -- Name: packages_update; Type: RULE; Schema: amd64; Owner: wbadm
2497 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));
2501 -- Name: pkg_history_delete; Type: RULE; Schema: amd64; Owner: wbadm
2504 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"));
2508 -- Name: pkg_history_insert; Type: RULE; Schema: amd64; Owner: wbadm
2511 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);
2515 -- Name: pkg_history_update; Type: RULE; Schema: amd64; Owner: wbadm
2518 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"));
2522 -- Name: transactions_insert; Type: RULE; Schema: amd64; Owner: wbadm
2525 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");
2529 -- Name: users_delete; Type: RULE; Schema: amd64; Owner: wbadm
2532 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));
2536 -- Name: users_insert; Type: RULE; Schema: amd64; Owner: wbadm
2539 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);
2543 -- Name: users_update; Type: RULE; Schema: amd64; Owner: wbadm
2546 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));
2549 SET search_path = arm, pg_catalog;
2552 -- Name: packages_delete; Type: RULE; Schema: arm; Owner: wbadm
2555 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));
2559 -- Name: packages_insert; Type: RULE; Schema: arm; Owner: wbadm
2562 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);
2566 -- Name: packages_update; Type: RULE; Schema: arm; Owner: wbadm
2569 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));
2573 -- Name: pkg_history_delete; Type: RULE; Schema: arm; Owner: wbadm
2576 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"));
2580 -- Name: pkg_history_insert; Type: RULE; Schema: arm; Owner: wbadm
2583 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);
2587 -- Name: pkg_history_update; Type: RULE; Schema: arm; Owner: wbadm
2590 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"));
2594 -- Name: transactions_insert; Type: RULE; Schema: arm; Owner: wbadm
2597 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");
2601 -- Name: users_delete; Type: RULE; Schema: arm; Owner: wbadm
2604 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));
2608 -- Name: users_insert; Type: RULE; Schema: arm; Owner: wbadm
2611 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);
2615 -- Name: users_update; Type: RULE; Schema: arm; Owner: wbadm
2618 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));
2621 SET search_path = armel, pg_catalog;
2624 -- Name: packages_delete; Type: RULE; Schema: armel; Owner: wbadm
2627 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));
2631 -- Name: packages_insert; Type: RULE; Schema: armel; Owner: wbadm
2634 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
2638 -- Name: packages_update; Type: RULE; Schema: armel; Owner: wbadm
2641 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'armel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2645 -- Name: pkg_history_delete; Type: RULE; Schema: armel; Owner: wbadm
2648 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
2652 -- Name: pkg_history_insert; Type: RULE; Schema: armel; Owner: wbadm
2655 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('armel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
2659 -- Name: pkg_history_update; Type: RULE; Schema: armel; Owner: wbadm
2662 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
2666 -- Name: transactions_insert; Type: RULE; Schema: armel; Owner: wbadm
2669 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('armel'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2673 -- Name: users_delete; Type: RULE; Schema: armel; Owner: wbadm
2676 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));
2680 -- Name: users_insert; Type: RULE; Schema: armel; Owner: wbadm
2683 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);
2687 -- Name: users_update; Type: RULE; Schema: armel; Owner: wbadm
2690 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'armel'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2693 SET search_path = hppa, pg_catalog;
2696 -- Name: packages_delete; Type: RULE; Schema: hppa; Owner: wbadm
2699 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));
2703 -- Name: packages_insert; Type: RULE; Schema: hppa; Owner: wbadm
2706 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
2710 -- Name: packages_update; Type: RULE; Schema: hppa; Owner: wbadm
2713 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'hppa'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2717 -- Name: pkg_history_delete; Type: RULE; Schema: hppa; Owner: wbadm
2720 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
2724 -- Name: pkg_history_insert; Type: RULE; Schema: hppa; Owner: wbadm
2727 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('hppa'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
2731 -- Name: pkg_history_update; Type: RULE; Schema: hppa; Owner: wbadm
2734 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
2738 -- Name: transactions_insert; Type: RULE; Schema: hppa; Owner: wbadm
2741 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('hppa'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2745 -- Name: users_delete; Type: RULE; Schema: hppa; Owner: wbadm
2748 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));
2752 -- Name: users_insert; Type: RULE; Schema: hppa; Owner: wbadm
2755 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);
2759 -- Name: users_update; Type: RULE; Schema: hppa; Owner: wbadm
2762 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'hppa'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2765 SET search_path = "hurd-i386", pg_catalog;
2768 -- Name: packages_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
2771 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));
2775 -- Name: packages_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
2778 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
2782 -- Name: packages_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
2785 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'hurd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2789 -- Name: pkg_history_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
2792 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
2796 -- Name: pkg_history_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
2799 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('hurd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
2803 -- Name: pkg_history_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
2806 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
2810 -- Name: transactions_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
2813 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('hurd-i386'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2817 -- Name: users_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
2820 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));
2824 -- Name: users_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
2827 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);
2831 -- Name: users_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
2834 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'hurd-i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2837 SET search_path = i386, pg_catalog;
2840 -- Name: packages_delete; Type: RULE; Schema: i386; Owner: wbadm
2843 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));
2847 -- Name: packages_insert; Type: RULE; Schema: i386; Owner: wbadm
2850 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
2854 -- Name: packages_update; Type: RULE; Schema: i386; Owner: wbadm
2857 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2861 -- Name: pkg_history_delete; Type: RULE; Schema: i386; Owner: wbadm
2864 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = 'i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text)) AND (p.version OPERATOR(public.=) old.version)) AND (p."timestamp" = old."timestamp"));
2868 -- Name: pkg_history_insert; Type: RULE; Schema: i386; Owner: wbadm
2871 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
2875 -- Name: pkg_history_update; Type: RULE; Schema: i386; Owner: wbadm
2878 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
2882 -- Name: transactions_insert; Type: RULE; Schema: i386; Owner: wbadm
2885 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('i386'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2889 -- Name: users_delete; Type: RULE; Schema: i386; Owner: wbadm
2892 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));
2896 -- Name: users_insert; Type: RULE; Schema: i386; Owner: wbadm
2899 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);
2903 -- Name: users_update; Type: RULE; Schema: i386; Owner: wbadm
2906 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2909 SET search_path = ia64, pg_catalog;
2912 -- Name: packages_delete; Type: RULE; Schema: ia64; Owner: wbadm
2915 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));
2919 -- Name: packages_insert; Type: RULE; Schema: ia64; Owner: wbadm
2922 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
2926 -- Name: packages_update; Type: RULE; Schema: ia64; Owner: wbadm
2929 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'ia64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
2933 -- Name: pkg_history_delete; Type: RULE; Schema: ia64; Owner: wbadm
2936 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
2940 -- Name: pkg_history_insert; Type: RULE; Schema: ia64; Owner: wbadm
2943 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('ia64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
2947 -- Name: pkg_history_update; Type: RULE; Schema: ia64; Owner: wbadm
2950 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, 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"));
2954 -- Name: transactions_insert; Type: RULE; Schema: ia64; Owner: wbadm
2957 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('ia64'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
2961 -- Name: users_delete; Type: RULE; Schema: ia64; Owner: wbadm
2964 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));
2968 -- Name: users_insert; Type: RULE; Schema: ia64; Owner: wbadm
2971 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);
2975 -- Name: users_update; Type: RULE; Schema: ia64; Owner: wbadm
2978 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'ia64'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
2981 SET search_path = "kfreebsd-amd64", pg_catalog;
2984 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
2987 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));
2991 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
2994 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
2998 -- Name: packages_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3001 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'kfreebsd-amd64'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3005 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3008 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
3012 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3015 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('kfreebsd-amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
3019 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3022 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
3026 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3029 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('kfreebsd-amd64'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3033 -- Name: users_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3036 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));
3040 -- Name: users_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3043 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);
3047 -- Name: users_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3050 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'kfreebsd-amd64'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3053 SET search_path = "kfreebsd-i386", pg_catalog;
3056 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3059 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));
3063 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3066 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
3070 -- Name: packages_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3073 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'kfreebsd-i386'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3077 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3080 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
3084 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3087 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('kfreebsd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
3091 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3094 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
3098 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3101 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('kfreebsd-i386'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3105 -- Name: users_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3108 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));
3112 -- Name: users_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3115 CREATE RULE users_insert AS ON INSERT TO users DO INSTEAD INSERT INTO public.users (architecture, username, distribution, last_seen) VALUES ('kfreebsd-i386'::character varying, new.username, new.distribution, new.last_seen);
3119 -- Name: users_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3122 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'kfreebsd-i386'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3125 SET search_path = mips, pg_catalog;
3128 -- Name: packages_delete; Type: RULE; Schema: mips; Owner: wbadm
3131 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));
3135 -- Name: packages_insert; Type: RULE; Schema: mips; Owner: wbadm
3138 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
3142 -- Name: packages_update; Type: RULE; Schema: mips; Owner: wbadm
3145 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'mips'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3149 -- Name: pkg_history_delete; Type: RULE; Schema: mips; Owner: wbadm
3152 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
3156 -- Name: pkg_history_insert; Type: RULE; Schema: mips; Owner: wbadm
3159 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('mips'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
3163 -- Name: pkg_history_update; Type: RULE; Schema: mips; Owner: wbadm
3166 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
3170 -- Name: transactions_insert; Type: RULE; Schema: mips; Owner: wbadm
3173 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('mips'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3177 -- Name: users_delete; Type: RULE; Schema: mips; Owner: wbadm
3180 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));
3184 -- Name: users_insert; Type: RULE; Schema: mips; Owner: wbadm
3187 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);
3191 -- Name: users_update; Type: RULE; Schema: mips; Owner: wbadm
3194 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'mips'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3197 SET search_path = mipsel, pg_catalog;
3200 -- Name: packages_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3203 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));
3207 -- Name: packages_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3210 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
3214 -- Name: packages_update; Type: RULE; Schema: mipsel; Owner: wbadm
3217 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'mipsel'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3221 -- Name: pkg_history_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3224 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
3228 -- Name: pkg_history_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3231 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('mipsel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
3235 -- Name: pkg_history_update; Type: RULE; Schema: mipsel; Owner: wbadm
3238 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
3242 -- Name: transactions_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3245 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('mipsel'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3249 -- Name: users_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3252 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));
3256 -- Name: users_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3259 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);
3263 -- Name: users_update; Type: RULE; Schema: mipsel; Owner: wbadm
3266 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'mipsel'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3269 SET search_path = powerpc, pg_catalog;
3272 -- Name: packages_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3275 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));
3279 -- Name: packages_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3282 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
3286 -- Name: packages_update; Type: RULE; Schema: powerpc; Owner: wbadm
3289 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'powerpc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3293 -- Name: pkg_history_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3296 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
3300 -- Name: pkg_history_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3303 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('powerpc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
3307 -- Name: pkg_history_update; Type: RULE; Schema: powerpc; Owner: wbadm
3310 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
3314 -- Name: transactions_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3317 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('powerpc'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3321 -- Name: users_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3324 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));
3328 -- Name: users_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3331 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);
3335 -- Name: users_update; Type: RULE; Schema: powerpc; Owner: wbadm
3338 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'powerpc'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3341 SET search_path = s390, pg_catalog;
3344 -- Name: packages_delete; Type: RULE; Schema: s390; Owner: wbadm
3347 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));
3351 -- Name: packages_insert; Type: RULE; Schema: s390; Owner: wbadm
3354 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
3358 -- Name: packages_update; Type: RULE; Schema: s390; Owner: wbadm
3361 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 's390'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3365 -- Name: pkg_history_delete; Type: RULE; Schema: s390; Owner: wbadm
3368 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
3372 -- Name: pkg_history_insert; Type: RULE; Schema: s390; Owner: wbadm
3375 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('s390'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
3379 -- Name: pkg_history_update; Type: RULE; Schema: s390; Owner: wbadm
3382 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
3386 -- Name: transactions_insert; Type: RULE; Schema: s390; Owner: wbadm
3389 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('s390'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3393 -- Name: users_delete; Type: RULE; Schema: s390; Owner: wbadm
3396 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));
3400 -- Name: users_insert; Type: RULE; Schema: s390; Owner: wbadm
3403 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);
3407 -- Name: users_update; Type: RULE; Schema: s390; Owner: wbadm
3410 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 's390'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3413 SET search_path = sparc, pg_catalog;
3416 -- Name: packages_delete; Type: RULE; Schema: sparc; Owner: wbadm
3419 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));
3423 -- Name: packages_insert; Type: RULE; Schema: sparc; Owner: wbadm
3426 CREATE RULE packages_insert AS ON INSERT TO packages DO INSTEAD INSERT INTO public.packages (architecture, package, distribution, version, state, section, priority, installed_version, previous_state, state_change, notes, builder, failed, old_failed, binary_nmu_version, binary_nmu_changelog, failed_category, permbuildpri, buildpri, depends, rel, bd_problem, extra_depends, extra_conflicts, build_arch_all) VALUES ('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);
3430 -- Name: packages_update; Type: RULE; Schema: sparc; Owner: wbadm
3433 CREATE RULE packages_update AS ON UPDATE TO packages DO INSTEAD UPDATE public.packages p SET version = new.version, state = new.state, section = new.section, priority = new.priority, installed_version = new.installed_version, previous_state = new.previous_state, state_change = new.state_change, notes = new.notes, builder = new.builder, failed = new.failed, old_failed = new.old_failed, binary_nmu_version = new.binary_nmu_version, binary_nmu_changelog = new.binary_nmu_changelog, failed_category = new.failed_category, permbuildpri = new.permbuildpri, buildpri = new.buildpri, depends = new.depends, rel = new.rel, bd_problem = new.bd_problem, extra_depends = new.extra_depends, extra_conflicts = new.extra_conflicts, build_arch_all = new.build_arch_all WHERE ((((p.architecture)::text = 'sparc'::text) AND ((p.package)::text = (old.package)::text)) AND ((p.distribution)::text = (old.distribution)::text));
3437 -- Name: pkg_history_delete; Type: RULE; Schema: sparc; Owner: wbadm
3440 CREATE RULE pkg_history_delete AS ON DELETE TO pkg_history DO INSTEAD DELETE FROM public.pkg_history p WHERE ((((((p.architecture)::text = '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"));
3444 -- Name: pkg_history_insert; Type: RULE; Schema: sparc; Owner: wbadm
3447 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space, builder) VALUES ('sparc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space, new.builder);
3451 -- Name: pkg_history_update; Type: RULE; Schema: sparc; Owner: wbadm
3454 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space, builder = new.builder WHERE ((((((p.architecture)::text = '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"));
3458 -- Name: transactions_insert; Type: RULE; Schema: sparc; Owner: wbadm
3461 CREATE RULE transactions_insert AS ON INSERT TO transactions DO INSTEAD INSERT INTO public.transactions (architecture, package, distribution, version, action, prevstate, state, real_user, set_user, "time") VALUES ('sparc'::character varying, new.package, new.distribution, new.version, new.action, new.prevstate, new.state, new.real_user, new.set_user, new."time");
3465 -- Name: users_delete; Type: RULE; Schema: sparc; Owner: wbadm
3468 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));
3472 -- Name: users_insert; Type: RULE; Schema: sparc; Owner: wbadm
3475 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);
3479 -- Name: users_update; Type: RULE; Schema: sparc; Owner: wbadm
3482 CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD UPDATE public.users u SET last_seen = new.last_seen WHERE ((((u.architecture)::text = 'sparc'::text) AND ((u.distribution)::text = (old.distribution)::text)) AND ((u.username)::text = (old.username)::text));
3485 SET search_path = public, pg_catalog;
3488 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3491 ALTER TABLE ONLY distribution_aliases
3492 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3496 -- Name: distribution_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3499 ALTER TABLE ONLY packages
3500 ADD CONSTRAINT distribution_architecture_fkey FOREIGN KEY (distribution, architecture) REFERENCES distribution_architectures(distribution, architecture);
3504 -- Name: packages_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3507 ALTER TABLE ONLY packages
3508 ADD CONSTRAINT packages_architecture_fkey FOREIGN KEY (architecture) REFERENCES architectures(architecture);
3512 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3515 ALTER TABLE ONLY packages
3516 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3520 -- Name: pkg_history_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3523 ALTER TABLE ONLY pkg_history
3524 ADD CONSTRAINT pkg_history_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3528 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
3531 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
3532 REVOKE ALL ON SCHEMA alpha FROM wbadm;
3533 GRANT ALL ON SCHEMA alpha TO wbadm;
3534 GRANT USAGE ON SCHEMA alpha TO alpha;
3535 GRANT USAGE ON SCHEMA alpha TO wb_all;
3536 GRANT USAGE ON SCHEMA alpha TO wb_security;
3540 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
3543 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
3544 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
3545 GRANT ALL ON SCHEMA alpha_public TO wbadm;
3546 GRANT USAGE ON SCHEMA alpha_public TO alpha;
3547 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
3551 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
3554 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
3555 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
3556 GRANT ALL ON SCHEMA amd64 TO wbadm;
3557 GRANT USAGE ON SCHEMA amd64 TO amd64;
3558 GRANT USAGE ON SCHEMA amd64 TO wb_all;
3559 GRANT USAGE ON SCHEMA amd64 TO wb_security;
3563 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
3566 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
3567 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
3568 GRANT ALL ON SCHEMA amd64_public TO wbadm;
3569 GRANT USAGE ON SCHEMA amd64_public TO amd64;
3570 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
3574 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
3577 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
3578 REVOKE ALL ON SCHEMA arm FROM wbadm;
3579 GRANT ALL ON SCHEMA arm TO wbadm;
3580 GRANT USAGE ON SCHEMA arm TO arm;
3581 GRANT USAGE ON SCHEMA arm TO wb_all;
3582 GRANT USAGE ON SCHEMA arm TO wb_security;
3586 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
3589 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
3590 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
3591 GRANT ALL ON SCHEMA arm_public TO wbadm;
3592 GRANT USAGE ON SCHEMA arm_public TO arm;
3593 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
3597 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
3600 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
3601 REVOKE ALL ON SCHEMA armel FROM wbadm;
3602 GRANT ALL ON SCHEMA armel TO wbadm;
3603 GRANT USAGE ON SCHEMA armel TO armel;
3604 GRANT USAGE ON SCHEMA armel TO wb_all;
3605 GRANT USAGE ON SCHEMA armel TO wb_security;
3609 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
3612 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
3613 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
3614 GRANT ALL ON SCHEMA armel_public TO wbadm;
3615 GRANT USAGE ON SCHEMA armel_public TO armel;
3616 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
3620 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
3623 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
3624 REVOKE ALL ON SCHEMA hppa FROM wbadm;
3625 GRANT ALL ON SCHEMA hppa TO wbadm;
3626 GRANT USAGE ON SCHEMA hppa TO hppa;
3627 GRANT USAGE ON SCHEMA hppa TO wb_all;
3628 GRANT USAGE ON SCHEMA hppa TO wb_security;
3632 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
3635 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
3636 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
3637 GRANT ALL ON SCHEMA hppa_public TO wbadm;
3638 GRANT USAGE ON SCHEMA hppa_public TO hppa;
3639 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
3643 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
3646 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
3647 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
3648 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
3649 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
3650 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
3651 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
3655 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
3658 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
3659 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
3660 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
3661 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
3662 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
3666 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
3669 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
3670 REVOKE ALL ON SCHEMA i386 FROM wbadm;
3671 GRANT ALL ON SCHEMA i386 TO wbadm;
3672 GRANT USAGE ON SCHEMA i386 TO i386;
3673 GRANT USAGE ON SCHEMA i386 TO wb_all;
3674 GRANT USAGE ON SCHEMA i386 TO wb_security;
3678 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
3681 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
3682 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
3683 GRANT ALL ON SCHEMA i386_public TO wbadm;
3684 GRANT USAGE ON SCHEMA i386_public TO i386;
3685 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
3689 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
3692 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
3693 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
3694 GRANT ALL ON SCHEMA ia64 TO wbadm;
3695 GRANT USAGE ON SCHEMA ia64 TO ia64;
3696 GRANT USAGE ON SCHEMA ia64 TO wb_all;
3697 GRANT USAGE ON SCHEMA ia64 TO wb_security;
3701 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
3704 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
3705 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
3706 GRANT ALL ON SCHEMA ia64_public TO wbadm;
3707 GRANT USAGE ON SCHEMA ia64_public TO ia64;
3708 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
3712 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
3715 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
3716 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
3717 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
3718 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
3719 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
3720 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
3724 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
3727 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
3728 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
3729 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
3730 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
3731 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
3735 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
3738 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
3739 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
3740 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
3741 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
3742 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
3743 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
3747 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
3750 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
3751 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
3752 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
3753 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
3754 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
3758 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
3761 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
3762 REVOKE ALL ON SCHEMA mips FROM wbadm;
3763 GRANT ALL ON SCHEMA mips TO wbadm;
3764 GRANT USAGE ON SCHEMA mips TO mips;
3765 GRANT USAGE ON SCHEMA mips TO wb_all;
3766 GRANT USAGE ON SCHEMA mips TO wb_security;
3770 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
3773 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
3774 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
3775 GRANT ALL ON SCHEMA mips_public TO wbadm;
3776 GRANT USAGE ON SCHEMA mips_public TO mips;
3777 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
3781 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
3784 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
3785 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
3786 GRANT ALL ON SCHEMA mipsel TO wbadm;
3787 GRANT USAGE ON SCHEMA mipsel TO mipsel;
3788 GRANT USAGE ON SCHEMA mipsel TO wb_all;
3789 GRANT USAGE ON SCHEMA mipsel TO wb_security;
3793 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
3796 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
3797 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
3798 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
3799 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
3800 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
3804 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
3807 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
3808 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
3809 GRANT ALL ON SCHEMA powerpc TO wbadm;
3810 GRANT USAGE ON SCHEMA powerpc TO powerpc;
3811 GRANT USAGE ON SCHEMA powerpc TO wb_all;
3812 GRANT USAGE ON SCHEMA powerpc TO wb_security;
3816 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
3819 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
3820 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
3821 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
3822 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
3823 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
3827 -- Name: public; Type: ACL; Schema: -; Owner: wbadm
3830 REVOKE ALL ON SCHEMA public FROM PUBLIC;
3831 REVOKE ALL ON SCHEMA public FROM wbadm;
3832 GRANT ALL ON SCHEMA public TO wbadm;
3833 GRANT ALL ON SCHEMA public TO PUBLIC;
3837 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
3840 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
3841 REVOKE ALL ON SCHEMA s390 FROM wbadm;
3842 GRANT ALL ON SCHEMA s390 TO wbadm;
3843 GRANT USAGE ON SCHEMA s390 TO s390;
3844 GRANT USAGE ON SCHEMA s390 TO wb_all;
3845 GRANT USAGE ON SCHEMA s390 TO wb_security;
3849 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
3852 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
3853 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
3854 GRANT ALL ON SCHEMA s390_public TO wbadm;
3855 GRANT USAGE ON SCHEMA s390_public TO s390;
3856 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
3860 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
3863 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
3864 REVOKE ALL ON SCHEMA sparc FROM wbadm;
3865 GRANT ALL ON SCHEMA sparc TO wbadm;
3866 GRANT USAGE ON SCHEMA sparc TO sparc;
3867 GRANT USAGE ON SCHEMA sparc TO wb_all;
3868 GRANT USAGE ON SCHEMA sparc TO wb_security;
3872 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
3875 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
3876 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
3877 GRANT ALL ON SCHEMA sparc_public TO wbadm;
3878 GRANT USAGE ON SCHEMA sparc_public TO sparc;
3879 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
3883 -- Name: packages; Type: ACL; Schema: public; Owner: wbadm
3886 REVOKE ALL ON TABLE packages FROM PUBLIC;
3887 REVOKE ALL ON TABLE packages FROM wbadm;
3888 GRANT ALL ON TABLE packages TO wbadm;
3891 SET search_path = alpha, pg_catalog;
3894 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
3897 REVOKE ALL ON TABLE packages FROM PUBLIC;
3898 REVOKE ALL ON TABLE packages FROM wbadm;
3899 GRANT ALL ON TABLE packages TO wbadm;
3900 GRANT SELECT ON TABLE packages TO wb_security;
3901 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
3904 SET search_path = public, pg_catalog;
3907 -- Name: pkg_history; Type: ACL; Schema: public; Owner: wbadm
3910 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
3911 REVOKE ALL ON TABLE pkg_history FROM wbadm;
3912 GRANT ALL ON TABLE pkg_history TO wbadm;
3915 SET search_path = alpha, pg_catalog;
3918 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
3921 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
3922 REVOKE ALL ON TABLE pkg_history FROM wbadm;
3923 GRANT ALL ON TABLE pkg_history TO wbadm;
3924 GRANT SELECT ON TABLE pkg_history TO wb_security;
3925 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
3928 SET search_path = public, pg_catalog;
3931 -- Name: transactions; Type: ACL; Schema: public; Owner: wbadm
3934 REVOKE ALL ON TABLE transactions FROM PUBLIC;
3935 REVOKE ALL ON TABLE transactions FROM wbadm;
3936 GRANT ALL ON TABLE transactions TO wbadm;
3939 SET search_path = alpha, pg_catalog;
3942 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
3945 REVOKE ALL ON TABLE transactions FROM PUBLIC;
3946 REVOKE ALL ON TABLE transactions FROM wbadm;
3947 GRANT ALL ON TABLE transactions TO wbadm;
3948 GRANT SELECT ON TABLE transactions TO wb_security;
3949 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
3952 SET search_path = public, pg_catalog;
3955 -- Name: users; Type: ACL; Schema: public; Owner: wbadm
3958 REVOKE ALL ON TABLE users FROM PUBLIC;
3959 REVOKE ALL ON TABLE users FROM wbadm;
3960 GRANT ALL ON TABLE users TO wbadm;
3963 SET search_path = alpha, pg_catalog;
3966 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
3969 REVOKE ALL ON TABLE users FROM PUBLIC;
3970 REVOKE ALL ON TABLE users FROM wbadm;
3971 GRANT ALL ON TABLE users TO wbadm;
3972 GRANT SELECT ON TABLE users TO wb_security;
3973 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
3976 SET search_path = public, pg_catalog;
3979 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
3982 REVOKE ALL ON TABLE distributions FROM PUBLIC;
3983 REVOKE ALL ON TABLE distributions FROM wbadm;
3984 GRANT ALL ON TABLE distributions TO wbadm;
3985 GRANT SELECT ON TABLE distributions TO PUBLIC;
3988 SET search_path = alpha_public, pg_catalog;
3991 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
3994 REVOKE ALL ON TABLE packages FROM PUBLIC;
3995 REVOKE ALL ON TABLE packages FROM wbadm;
3996 GRANT ALL ON TABLE packages TO wbadm;
3997 GRANT SELECT ON TABLE packages TO PUBLIC;
4001 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4004 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4005 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4006 GRANT ALL ON TABLE pkg_history TO wbadm;
4007 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4011 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4014 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4015 REVOKE ALL ON TABLE transactions FROM wbadm;
4016 GRANT ALL ON TABLE transactions TO wbadm;
4017 GRANT SELECT ON TABLE transactions TO PUBLIC;
4021 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4024 REVOKE ALL ON TABLE users FROM PUBLIC;
4025 REVOKE ALL ON TABLE users FROM wbadm;
4026 GRANT ALL ON TABLE users TO wbadm;
4027 GRANT SELECT ON TABLE users TO PUBLIC;
4030 SET search_path = amd64, pg_catalog;
4033 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4036 REVOKE ALL ON TABLE packages FROM PUBLIC;
4037 REVOKE ALL ON TABLE packages FROM wbadm;
4038 GRANT ALL ON TABLE packages TO wbadm;
4039 GRANT SELECT ON TABLE packages TO wb_security;
4040 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4044 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4047 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4048 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4049 GRANT ALL ON TABLE pkg_history TO wbadm;
4050 GRANT SELECT ON TABLE pkg_history TO wb_security;
4051 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4055 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4058 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4059 REVOKE ALL ON TABLE transactions FROM wbadm;
4060 GRANT ALL ON TABLE transactions TO wbadm;
4061 GRANT SELECT ON TABLE transactions TO wb_security;
4062 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4066 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4069 REVOKE ALL ON TABLE users FROM PUBLIC;
4070 REVOKE ALL ON TABLE users FROM wbadm;
4071 GRANT ALL ON TABLE users TO wbadm;
4072 GRANT SELECT ON TABLE users TO wb_security;
4073 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4076 SET search_path = amd64_public, pg_catalog;
4079 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4082 REVOKE ALL ON TABLE packages FROM PUBLIC;
4083 REVOKE ALL ON TABLE packages FROM wbadm;
4084 GRANT ALL ON TABLE packages TO wbadm;
4085 GRANT SELECT ON TABLE packages TO PUBLIC;
4089 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4092 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4093 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4094 GRANT ALL ON TABLE pkg_history TO wbadm;
4095 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4099 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4102 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4103 REVOKE ALL ON TABLE transactions FROM wbadm;
4104 GRANT ALL ON TABLE transactions TO wbadm;
4105 GRANT SELECT ON TABLE transactions TO PUBLIC;
4109 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4112 REVOKE ALL ON TABLE users FROM PUBLIC;
4113 REVOKE ALL ON TABLE users FROM wbadm;
4114 GRANT ALL ON TABLE users TO wbadm;
4115 GRANT SELECT ON TABLE users TO PUBLIC;
4118 SET search_path = arm, pg_catalog;
4121 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4124 REVOKE ALL ON TABLE packages FROM PUBLIC;
4125 REVOKE ALL ON TABLE packages FROM wbadm;
4126 GRANT ALL ON TABLE packages TO wbadm;
4127 GRANT SELECT ON TABLE packages TO wb_security;
4128 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4132 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4135 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4136 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4137 GRANT ALL ON TABLE pkg_history TO wbadm;
4138 GRANT SELECT ON TABLE pkg_history TO wb_security;
4139 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4143 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4146 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4147 REVOKE ALL ON TABLE transactions FROM wbadm;
4148 GRANT ALL ON TABLE transactions TO wbadm;
4149 GRANT SELECT ON TABLE transactions TO wb_security;
4150 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4154 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4157 REVOKE ALL ON TABLE users FROM PUBLIC;
4158 REVOKE ALL ON TABLE users FROM wbadm;
4159 GRANT ALL ON TABLE users TO wbadm;
4160 GRANT SELECT ON TABLE users TO wb_security;
4161 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4164 SET search_path = arm_public, pg_catalog;
4167 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4170 REVOKE ALL ON TABLE packages FROM PUBLIC;
4171 REVOKE ALL ON TABLE packages FROM wbadm;
4172 GRANT ALL ON TABLE packages TO wbadm;
4173 GRANT SELECT ON TABLE packages TO PUBLIC;
4177 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4180 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4181 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4182 GRANT ALL ON TABLE pkg_history TO wbadm;
4183 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4187 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4190 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4191 REVOKE ALL ON TABLE transactions FROM wbadm;
4192 GRANT ALL ON TABLE transactions TO wbadm;
4193 GRANT SELECT ON TABLE transactions TO PUBLIC;
4197 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4200 REVOKE ALL ON TABLE users FROM PUBLIC;
4201 REVOKE ALL ON TABLE users FROM wbadm;
4202 GRANT ALL ON TABLE users TO wbadm;
4203 GRANT SELECT ON TABLE users TO PUBLIC;
4206 SET search_path = armel, pg_catalog;
4209 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4212 REVOKE ALL ON TABLE packages FROM PUBLIC;
4213 REVOKE ALL ON TABLE packages FROM wbadm;
4214 GRANT ALL ON TABLE packages TO wbadm;
4215 GRANT SELECT ON TABLE packages TO wb_security;
4216 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4220 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4223 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4224 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4225 GRANT ALL ON TABLE pkg_history TO wbadm;
4226 GRANT SELECT ON TABLE pkg_history TO wb_security;
4227 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4231 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4234 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4235 REVOKE ALL ON TABLE transactions FROM wbadm;
4236 GRANT ALL ON TABLE transactions TO wbadm;
4237 GRANT SELECT ON TABLE transactions TO wb_security;
4238 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4242 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4245 REVOKE ALL ON TABLE users FROM PUBLIC;
4246 REVOKE ALL ON TABLE users FROM wbadm;
4247 GRANT ALL ON TABLE users TO wbadm;
4248 GRANT SELECT ON TABLE users TO wb_security;
4249 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4252 SET search_path = armel_public, pg_catalog;
4255 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4258 REVOKE ALL ON TABLE packages FROM PUBLIC;
4259 REVOKE ALL ON TABLE packages FROM wbadm;
4260 GRANT ALL ON TABLE packages TO wbadm;
4261 GRANT SELECT ON TABLE packages TO PUBLIC;
4265 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4268 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4269 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4270 GRANT ALL ON TABLE pkg_history TO wbadm;
4271 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4275 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4278 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4279 REVOKE ALL ON TABLE transactions FROM wbadm;
4280 GRANT ALL ON TABLE transactions TO wbadm;
4281 GRANT SELECT ON TABLE transactions TO PUBLIC;
4285 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4288 REVOKE ALL ON TABLE users FROM PUBLIC;
4289 REVOKE ALL ON TABLE users FROM wbadm;
4290 GRANT ALL ON TABLE users TO wbadm;
4291 GRANT SELECT ON TABLE users TO PUBLIC;
4294 SET search_path = hppa, pg_catalog;
4297 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4300 REVOKE ALL ON TABLE packages FROM PUBLIC;
4301 REVOKE ALL ON TABLE packages FROM wbadm;
4302 GRANT ALL ON TABLE packages TO wbadm;
4303 GRANT SELECT ON TABLE packages TO wb_security;
4304 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4308 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4311 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4312 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4313 GRANT ALL ON TABLE pkg_history TO wbadm;
4314 GRANT SELECT ON TABLE pkg_history TO wb_security;
4315 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4319 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4322 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4323 REVOKE ALL ON TABLE transactions FROM wbadm;
4324 GRANT ALL ON TABLE transactions TO wbadm;
4325 GRANT SELECT ON TABLE transactions TO wb_security;
4326 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4330 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4333 REVOKE ALL ON TABLE users FROM PUBLIC;
4334 REVOKE ALL ON TABLE users FROM wbadm;
4335 GRANT ALL ON TABLE users TO wbadm;
4336 GRANT SELECT ON TABLE users TO wb_security;
4337 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4340 SET search_path = hppa_public, pg_catalog;
4343 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4346 REVOKE ALL ON TABLE packages FROM PUBLIC;
4347 REVOKE ALL ON TABLE packages FROM wbadm;
4348 GRANT ALL ON TABLE packages TO wbadm;
4349 GRANT SELECT ON TABLE packages TO PUBLIC;
4353 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4356 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4357 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4358 GRANT ALL ON TABLE pkg_history TO wbadm;
4359 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4363 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4366 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4367 REVOKE ALL ON TABLE transactions FROM wbadm;
4368 GRANT ALL ON TABLE transactions TO wbadm;
4369 GRANT SELECT ON TABLE transactions TO PUBLIC;
4373 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4376 REVOKE ALL ON TABLE users FROM PUBLIC;
4377 REVOKE ALL ON TABLE users FROM wbadm;
4378 GRANT ALL ON TABLE users TO wbadm;
4379 GRANT SELECT ON TABLE users TO PUBLIC;
4382 SET search_path = "hurd-i386", pg_catalog;
4385 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4388 REVOKE ALL ON TABLE packages FROM PUBLIC;
4389 REVOKE ALL ON TABLE packages FROM wbadm;
4390 GRANT ALL ON TABLE packages TO wbadm;
4391 GRANT SELECT ON TABLE packages TO wb_security;
4392 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4396 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; 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 wb_security;
4403 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4407 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4410 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4411 REVOKE ALL ON TABLE transactions FROM wbadm;
4412 GRANT ALL ON TABLE transactions TO wbadm;
4413 GRANT SELECT ON TABLE transactions TO wb_security;
4414 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4418 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4421 REVOKE ALL ON TABLE users FROM PUBLIC;
4422 REVOKE ALL ON TABLE users FROM wbadm;
4423 GRANT ALL ON TABLE users TO wbadm;
4424 GRANT SELECT ON TABLE users TO wb_security;
4425 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4428 SET search_path = "hurd-i386_public", pg_catalog;
4431 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4434 REVOKE ALL ON TABLE packages FROM PUBLIC;
4435 REVOKE ALL ON TABLE packages FROM wbadm;
4436 GRANT ALL ON TABLE packages TO wbadm;
4437 GRANT SELECT ON TABLE packages TO PUBLIC;
4441 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4444 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4445 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4446 GRANT ALL ON TABLE pkg_history TO wbadm;
4447 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4451 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4454 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4455 REVOKE ALL ON TABLE transactions FROM wbadm;
4456 GRANT ALL ON TABLE transactions TO wbadm;
4457 GRANT SELECT ON TABLE transactions TO PUBLIC;
4461 -- Name: users; Type: ACL; Schema: hurd-i386_public; 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 PUBLIC;
4470 SET search_path = i386, pg_catalog;
4473 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4476 REVOKE ALL ON TABLE packages FROM PUBLIC;
4477 REVOKE ALL ON TABLE packages FROM wbadm;
4478 GRANT ALL ON TABLE packages TO wbadm;
4479 GRANT SELECT ON TABLE packages TO wb_security;
4480 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4484 -- Name: pkg_history; Type: ACL; Schema: i386; 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 wb_security;
4491 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4495 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
4498 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4499 REVOKE ALL ON TABLE transactions FROM wbadm;
4500 GRANT ALL ON TABLE transactions TO wbadm;
4501 GRANT SELECT ON TABLE transactions TO wb_security;
4502 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4506 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
4509 REVOKE ALL ON TABLE users FROM PUBLIC;
4510 REVOKE ALL ON TABLE users FROM wbadm;
4511 GRANT ALL ON TABLE users TO wbadm;
4512 GRANT SELECT ON TABLE users TO wb_security;
4513 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4516 SET search_path = i386_public, pg_catalog;
4519 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
4522 REVOKE ALL ON TABLE packages FROM PUBLIC;
4523 REVOKE ALL ON TABLE packages FROM wbadm;
4524 GRANT ALL ON TABLE packages TO wbadm;
4525 GRANT SELECT ON TABLE packages TO PUBLIC;
4529 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
4532 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4533 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4534 GRANT ALL ON TABLE pkg_history TO wbadm;
4535 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4539 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
4542 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4543 REVOKE ALL ON TABLE transactions FROM wbadm;
4544 GRANT ALL ON TABLE transactions TO wbadm;
4545 GRANT SELECT ON TABLE transactions TO PUBLIC;
4549 -- Name: users; Type: ACL; Schema: i386_public; 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 PUBLIC;
4558 SET search_path = ia64, pg_catalog;
4561 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
4564 REVOKE ALL ON TABLE packages FROM PUBLIC;
4565 REVOKE ALL ON TABLE packages FROM wbadm;
4566 GRANT ALL ON TABLE packages TO wbadm;
4567 GRANT SELECT ON TABLE packages TO wb_security;
4568 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4572 -- Name: pkg_history; Type: ACL; Schema: ia64; 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 wb_security;
4579 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4583 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
4586 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4587 REVOKE ALL ON TABLE transactions FROM wbadm;
4588 GRANT ALL ON TABLE transactions TO wbadm;
4589 GRANT SELECT ON TABLE transactions TO wb_security;
4590 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4594 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
4597 REVOKE ALL ON TABLE users FROM PUBLIC;
4598 REVOKE ALL ON TABLE users FROM wbadm;
4599 GRANT ALL ON TABLE users TO wbadm;
4600 GRANT SELECT ON TABLE users TO wb_security;
4601 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4604 SET search_path = ia64_public, pg_catalog;
4607 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
4610 REVOKE ALL ON TABLE packages FROM PUBLIC;
4611 REVOKE ALL ON TABLE packages FROM wbadm;
4612 GRANT ALL ON TABLE packages TO wbadm;
4613 GRANT SELECT ON TABLE packages TO PUBLIC;
4617 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
4620 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4621 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4622 GRANT ALL ON TABLE pkg_history TO wbadm;
4623 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4627 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
4630 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4631 REVOKE ALL ON TABLE transactions FROM wbadm;
4632 GRANT ALL ON TABLE transactions TO wbadm;
4633 GRANT SELECT ON TABLE transactions TO PUBLIC;
4637 -- Name: users; Type: ACL; Schema: ia64_public; 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 PUBLIC;
4646 SET search_path = "kfreebsd-amd64", pg_catalog;
4649 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
4652 REVOKE ALL ON TABLE packages FROM PUBLIC;
4653 REVOKE ALL ON TABLE packages FROM wbadm;
4654 GRANT ALL ON TABLE packages TO wbadm;
4655 GRANT SELECT ON TABLE packages TO wb_security;
4656 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4660 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; 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 wb_security;
4667 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4671 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
4674 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4675 REVOKE ALL ON TABLE transactions FROM wbadm;
4676 GRANT ALL ON TABLE transactions TO wbadm;
4677 GRANT SELECT ON TABLE transactions TO wb_security;
4678 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4682 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
4685 REVOKE ALL ON TABLE users FROM PUBLIC;
4686 REVOKE ALL ON TABLE users FROM wbadm;
4687 GRANT ALL ON TABLE users TO wbadm;
4688 GRANT SELECT ON TABLE users TO wb_security;
4689 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4692 SET search_path = "kfreebsd-amd64_public", pg_catalog;
4695 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
4698 REVOKE ALL ON TABLE packages FROM PUBLIC;
4699 REVOKE ALL ON TABLE packages FROM wbadm;
4700 GRANT ALL ON TABLE packages TO wbadm;
4701 GRANT SELECT ON TABLE packages TO PUBLIC;
4705 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
4708 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4709 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4710 GRANT ALL ON TABLE pkg_history TO wbadm;
4711 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4715 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
4718 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4719 REVOKE ALL ON TABLE transactions FROM wbadm;
4720 GRANT ALL ON TABLE transactions TO wbadm;
4721 GRANT SELECT ON TABLE transactions TO PUBLIC;
4725 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; 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 PUBLIC;
4734 SET search_path = "kfreebsd-i386", pg_catalog;
4737 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
4740 REVOKE ALL ON TABLE packages FROM PUBLIC;
4741 REVOKE ALL ON TABLE packages FROM wbadm;
4742 GRANT ALL ON TABLE packages TO wbadm;
4743 GRANT SELECT ON TABLE packages TO wb_security;
4744 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4748 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; 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 wb_security;
4755 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4759 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
4762 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4763 REVOKE ALL ON TABLE transactions FROM wbadm;
4764 GRANT ALL ON TABLE transactions TO wbadm;
4765 GRANT SELECT ON TABLE transactions TO wb_security;
4766 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4770 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
4773 REVOKE ALL ON TABLE users FROM PUBLIC;
4774 REVOKE ALL ON TABLE users FROM wbadm;
4775 GRANT ALL ON TABLE users TO wbadm;
4776 GRANT SELECT ON TABLE users TO wb_security;
4777 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4780 SET search_path = "kfreebsd-i386_public", pg_catalog;
4783 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
4786 REVOKE ALL ON TABLE packages FROM PUBLIC;
4787 REVOKE ALL ON TABLE packages FROM wbadm;
4788 GRANT ALL ON TABLE packages TO wbadm;
4789 GRANT SELECT ON TABLE packages TO PUBLIC;
4793 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
4796 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4797 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4798 GRANT ALL ON TABLE pkg_history TO wbadm;
4799 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4803 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
4806 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4807 REVOKE ALL ON TABLE transactions FROM wbadm;
4808 GRANT ALL ON TABLE transactions TO wbadm;
4809 GRANT SELECT ON TABLE transactions TO PUBLIC;
4813 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; 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 PUBLIC;
4822 SET search_path = mips, pg_catalog;
4825 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
4828 REVOKE ALL ON TABLE packages FROM PUBLIC;
4829 REVOKE ALL ON TABLE packages FROM wbadm;
4830 GRANT ALL ON TABLE packages TO wbadm;
4831 GRANT SELECT ON TABLE packages TO wb_security;
4832 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4836 -- Name: pkg_history; Type: ACL; Schema: mips; 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 wb_security;
4843 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4847 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
4850 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4851 REVOKE ALL ON TABLE transactions FROM wbadm;
4852 GRANT ALL ON TABLE transactions TO wbadm;
4853 GRANT SELECT ON TABLE transactions TO wb_security;
4854 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4858 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
4861 REVOKE ALL ON TABLE users FROM PUBLIC;
4862 REVOKE ALL ON TABLE users FROM wbadm;
4863 GRANT ALL ON TABLE users TO wbadm;
4864 GRANT SELECT ON TABLE users TO wb_security;
4865 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4868 SET search_path = mips_public, pg_catalog;
4871 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
4874 REVOKE ALL ON TABLE packages FROM PUBLIC;
4875 REVOKE ALL ON TABLE packages FROM wbadm;
4876 GRANT ALL ON TABLE packages TO wbadm;
4877 GRANT SELECT ON TABLE packages TO PUBLIC;
4881 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
4884 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4885 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4886 GRANT ALL ON TABLE pkg_history TO wbadm;
4887 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4891 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
4894 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4895 REVOKE ALL ON TABLE transactions FROM wbadm;
4896 GRANT ALL ON TABLE transactions TO wbadm;
4897 GRANT SELECT ON TABLE transactions TO PUBLIC;
4901 -- Name: users; Type: ACL; Schema: mips_public; 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 PUBLIC;
4910 SET search_path = mipsel, pg_catalog;
4913 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
4916 REVOKE ALL ON TABLE packages FROM PUBLIC;
4917 REVOKE ALL ON TABLE packages FROM wbadm;
4918 GRANT ALL ON TABLE packages TO wbadm;
4919 GRANT SELECT ON TABLE packages TO wb_security;
4920 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4924 -- Name: pkg_history; Type: ACL; Schema: mipsel; 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 wb_security;
4931 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4935 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
4938 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4939 REVOKE ALL ON TABLE transactions FROM wbadm;
4940 GRANT ALL ON TABLE transactions TO wbadm;
4941 GRANT SELECT ON TABLE transactions TO wb_security;
4942 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4946 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
4949 REVOKE ALL ON TABLE users FROM PUBLIC;
4950 REVOKE ALL ON TABLE users FROM wbadm;
4951 GRANT ALL ON TABLE users TO wbadm;
4952 GRANT SELECT ON TABLE users TO wb_security;
4953 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4956 SET search_path = mipsel_public, pg_catalog;
4959 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
4962 REVOKE ALL ON TABLE packages FROM PUBLIC;
4963 REVOKE ALL ON TABLE packages FROM wbadm;
4964 GRANT ALL ON TABLE packages TO wbadm;
4965 GRANT SELECT ON TABLE packages TO PUBLIC;
4969 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
4972 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4973 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4974 GRANT ALL ON TABLE pkg_history TO wbadm;
4975 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4979 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
4982 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4983 REVOKE ALL ON TABLE transactions FROM wbadm;
4984 GRANT ALL ON TABLE transactions TO wbadm;
4985 GRANT SELECT ON TABLE transactions TO PUBLIC;
4989 -- Name: users; Type: ACL; Schema: mipsel_public; 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 PUBLIC;
4998 SET search_path = powerpc, pg_catalog;
5001 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5004 REVOKE ALL ON TABLE packages FROM PUBLIC;
5005 REVOKE ALL ON TABLE packages FROM wbadm;
5006 GRANT ALL ON TABLE packages TO wbadm;
5007 GRANT SELECT ON TABLE packages TO wb_security;
5008 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5012 -- Name: pkg_history; Type: ACL; Schema: powerpc; 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 wb_security;
5019 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5023 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5026 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5027 REVOKE ALL ON TABLE transactions FROM wbadm;
5028 GRANT ALL ON TABLE transactions TO wbadm;
5029 GRANT SELECT ON TABLE transactions TO wb_security;
5030 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5034 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5037 REVOKE ALL ON TABLE users FROM PUBLIC;
5038 REVOKE ALL ON TABLE users FROM wbadm;
5039 GRANT ALL ON TABLE users TO wbadm;
5040 GRANT SELECT ON TABLE users TO wb_security;
5041 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5044 SET search_path = powerpc_public, pg_catalog;
5047 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5050 REVOKE ALL ON TABLE packages FROM PUBLIC;
5051 REVOKE ALL ON TABLE packages FROM wbadm;
5052 GRANT ALL ON TABLE packages TO wbadm;
5053 GRANT SELECT ON TABLE packages TO PUBLIC;
5057 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5060 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5061 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5062 GRANT ALL ON TABLE pkg_history TO wbadm;
5063 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5067 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5070 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5071 REVOKE ALL ON TABLE transactions FROM wbadm;
5072 GRANT ALL ON TABLE transactions TO wbadm;
5073 GRANT SELECT ON TABLE transactions TO PUBLIC;
5077 -- Name: users; Type: ACL; Schema: powerpc_public; 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 PUBLIC;
5086 SET search_path = public, pg_catalog;
5089 -- Name: architectures; Type: ACL; Schema: public; Owner: wbadm
5092 REVOKE ALL ON TABLE architectures FROM PUBLIC;
5093 REVOKE ALL ON TABLE architectures FROM wbadm;
5094 GRANT ALL ON TABLE architectures TO wbadm;
5095 GRANT SELECT ON TABLE architectures TO PUBLIC;
5099 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5102 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5103 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5104 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5105 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5109 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5112 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5113 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5114 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5115 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5119 -- Name: distribution_architectures_statistics; Type: ACL; Schema: public; Owner: wbadm
5122 REVOKE ALL ON TABLE distribution_architectures_statistics FROM PUBLIC;
5123 REVOKE ALL ON TABLE distribution_architectures_statistics FROM wbadm;
5124 GRANT ALL ON TABLE distribution_architectures_statistics TO wbadm;
5125 GRANT SELECT ON TABLE distribution_architectures_statistics TO PUBLIC;
5129 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5132 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5133 REVOKE ALL ON TABLE lastlog FROM wbadm;
5134 GRANT ALL ON TABLE lastlog TO wbadm;
5135 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5139 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5142 REVOKE ALL ON TABLE log FROM PUBLIC;
5143 REVOKE ALL ON TABLE log FROM wbadm;
5144 GRANT ALL ON TABLE log TO wbadm;
5145 GRANT SELECT ON TABLE log TO PUBLIC;
5149 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5152 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5153 REVOKE ALL ON TABLE packages_all FROM wbadm;
5154 GRANT ALL ON TABLE packages_all TO wbadm;
5155 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5159 -- Name: packages_public; Type: ACL; Schema: public; Owner: wbadm
5162 REVOKE ALL ON TABLE packages_public FROM PUBLIC;
5163 REVOKE ALL ON TABLE packages_public FROM wbadm;
5164 GRANT ALL ON TABLE packages_public TO wbadm;
5165 GRANT SELECT ON TABLE packages_public TO PUBLIC;
5168 SET search_path = s390, pg_catalog;
5171 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5174 REVOKE ALL ON TABLE packages FROM PUBLIC;
5175 REVOKE ALL ON TABLE packages FROM wbadm;
5176 GRANT ALL ON TABLE packages TO wbadm;
5177 GRANT SELECT ON TABLE packages TO wb_security;
5178 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5182 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5185 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5186 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5187 GRANT ALL ON TABLE pkg_history TO wbadm;
5188 GRANT SELECT ON TABLE pkg_history TO wb_security;
5189 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5193 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5196 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5197 REVOKE ALL ON TABLE transactions FROM wbadm;
5198 GRANT ALL ON TABLE transactions TO wbadm;
5199 GRANT SELECT ON TABLE transactions TO wb_security;
5200 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5204 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5207 REVOKE ALL ON TABLE users FROM PUBLIC;
5208 REVOKE ALL ON TABLE users FROM wbadm;
5209 GRANT ALL ON TABLE users TO wbadm;
5210 GRANT SELECT ON TABLE users TO wb_security;
5211 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5214 SET search_path = s390_public, pg_catalog;
5217 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5220 REVOKE ALL ON TABLE packages FROM PUBLIC;
5221 REVOKE ALL ON TABLE packages FROM wbadm;
5222 GRANT ALL ON TABLE packages TO wbadm;
5223 GRANT SELECT ON TABLE packages TO PUBLIC;
5227 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5230 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5231 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5232 GRANT ALL ON TABLE pkg_history TO wbadm;
5233 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5237 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5240 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5241 REVOKE ALL ON TABLE transactions FROM wbadm;
5242 GRANT ALL ON TABLE transactions TO wbadm;
5243 GRANT SELECT ON TABLE transactions TO PUBLIC;
5247 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5250 REVOKE ALL ON TABLE users FROM PUBLIC;
5251 REVOKE ALL ON TABLE users FROM wbadm;
5252 GRANT ALL ON TABLE users TO wbadm;
5253 GRANT SELECT ON TABLE users TO PUBLIC;
5256 SET search_path = sparc, pg_catalog;
5259 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5262 REVOKE ALL ON TABLE packages FROM PUBLIC;
5263 REVOKE ALL ON TABLE packages FROM wbadm;
5264 GRANT ALL ON TABLE packages TO wbadm;
5265 GRANT SELECT ON TABLE packages TO wb_security;
5266 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5270 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5273 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5274 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5275 GRANT ALL ON TABLE pkg_history TO wbadm;
5276 GRANT SELECT ON TABLE pkg_history TO wb_security;
5277 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5281 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5284 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5285 REVOKE ALL ON TABLE transactions FROM wbadm;
5286 GRANT ALL ON TABLE transactions TO wbadm;
5287 GRANT SELECT ON TABLE transactions TO wb_security;
5288 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5292 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5295 REVOKE ALL ON TABLE users FROM PUBLIC;
5296 REVOKE ALL ON TABLE users FROM wbadm;
5297 GRANT ALL ON TABLE users TO wbadm;
5298 GRANT SELECT ON TABLE users TO wb_security;
5299 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5302 SET search_path = sparc_public, pg_catalog;
5305 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5308 REVOKE ALL ON TABLE packages FROM PUBLIC;
5309 REVOKE ALL ON TABLE packages FROM wbadm;
5310 GRANT ALL ON TABLE packages TO wbadm;
5311 GRANT SELECT ON TABLE packages TO PUBLIC;
5315 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5318 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5319 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5320 GRANT ALL ON TABLE pkg_history TO wbadm;
5321 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5325 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5328 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5329 REVOKE ALL ON TABLE transactions FROM wbadm;
5330 GRANT ALL ON TABLE transactions TO wbadm;
5331 GRANT SELECT ON TABLE transactions TO PUBLIC;
5335 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5338 REVOKE ALL ON TABLE users FROM PUBLIC;
5339 REVOKE ALL ON TABLE users FROM wbadm;
5340 GRANT ALL ON TABLE users TO wbadm;
5341 GRANT SELECT ON TABLE users TO PUBLIC;
5345 -- PostgreSQL database dump complete