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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2071 CREATE TABLE distribution_aliases (
2072 alias character varying NOT NULL,
2073 distribution character varying NOT NULL
2077 ALTER TABLE public.distribution_aliases OWNER TO wbadm;
2080 -- Name: distribution_architectures; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2083 CREATE TABLE distribution_architectures (
2084 distribution character varying NOT NULL,
2085 architecture character varying NOT NULL
2089 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2092 -- Name: distribution_architectures_statistics; Type: VIEW; Schema: public; Owner: wbadm
2095 CREATE VIEW distribution_architectures_statistics AS
2096 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;
2099 ALTER TABLE public.distribution_architectures_statistics OWNER TO wbadm;
2102 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2105 CREATE VIEW lastlog AS
2106 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;
2109 ALTER TABLE public.lastlog OWNER TO wbadm;
2112 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2116 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;
2119 ALTER TABLE public.log OWNER TO wbadm;
2122 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2125 CREATE VIEW packages_all AS
2126 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);
2129 ALTER TABLE public.packages_all OWNER TO wbadm;
2132 -- Name: packages_public; Type: VIEW; Schema: public; Owner: wbadm
2135 CREATE VIEW packages_public AS
2136 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);
2139 ALTER TABLE public.packages_public OWNER TO wbadm;
2141 SET search_path = s390, pg_catalog;
2144 -- Name: packages; Type: VIEW; Schema: s390; Owner: wbadm
2147 CREATE VIEW packages AS
2148 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);
2151 ALTER TABLE s390.packages OWNER TO wbadm;
2154 -- Name: pkg_history; Type: VIEW; Schema: s390; Owner: wbadm
2157 CREATE VIEW pkg_history AS
2158 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 's390'::text);
2161 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2164 -- Name: transactions; Type: VIEW; Schema: s390; Owner: wbadm
2167 CREATE VIEW transactions AS
2168 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);
2171 ALTER TABLE s390.transactions OWNER TO wbadm;
2174 -- Name: users; Type: VIEW; Schema: s390; Owner: wbadm
2177 CREATE VIEW users AS
2178 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 's390'::text);
2181 ALTER TABLE s390.users OWNER TO wbadm;
2183 SET search_path = s390_public, pg_catalog;
2186 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2189 CREATE VIEW packages AS
2190 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));
2193 ALTER TABLE s390_public.packages OWNER TO wbadm;
2196 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2199 CREATE VIEW pkg_history AS
2200 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 's390'::text));
2203 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2206 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2209 CREATE VIEW transactions AS
2210 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));
2213 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2216 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2219 CREATE VIEW users AS
2220 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));
2223 ALTER TABLE s390_public.users OWNER TO wbadm;
2225 SET search_path = sparc, pg_catalog;
2228 -- Name: packages; Type: VIEW; Schema: sparc; Owner: wbadm
2231 CREATE VIEW packages AS
2232 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);
2235 ALTER TABLE sparc.packages OWNER TO wbadm;
2238 -- Name: pkg_history; Type: VIEW; Schema: sparc; Owner: wbadm
2241 CREATE VIEW pkg_history AS
2242 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM public.pkg_history WHERE ((pkg_history.architecture)::text = 'sparc'::text);
2245 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2248 -- Name: transactions; Type: VIEW; Schema: sparc; Owner: wbadm
2251 CREATE VIEW transactions AS
2252 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);
2255 ALTER TABLE sparc.transactions OWNER TO wbadm;
2258 -- Name: users; Type: VIEW; Schema: sparc; Owner: wbadm
2261 CREATE VIEW users AS
2262 SELECT users.username, users.distribution, users.last_seen FROM public.users WHERE ((users.architecture)::text = 'sparc'::text);
2265 ALTER TABLE sparc.users OWNER TO wbadm;
2267 SET search_path = sparc_public, pg_catalog;
2270 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2273 CREATE VIEW packages AS
2274 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));
2277 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2280 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2283 CREATE VIEW pkg_history AS
2284 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM (public.pkg_history NATURAL JOIN public.distributions) WHERE ((distributions.public = true) AND ((pkg_history.architecture)::text = 'sparc'::text));
2287 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2290 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2293 CREATE VIEW transactions AS
2294 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));
2297 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2300 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2303 CREATE VIEW users AS
2304 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));
2307 ALTER TABLE sparc_public.users OWNER TO wbadm;
2309 SET search_path = public, pg_catalog;
2312 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2315 ALTER TABLE ONLY distribution_aliases
2316 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
2320 -- Name: distribution_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2323 ALTER TABLE ONLY distribution_architectures
2324 ADD CONSTRAINT distribution_architectures_pkey PRIMARY KEY (distribution, architecture);
2328 -- Name: packages_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2331 ALTER TABLE ONLY packages
2332 ADD CONSTRAINT packages_pkey PRIMARY KEY (architecture, package, distribution);
2336 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2339 ALTER TABLE ONLY pkg_history
2340 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (architecture, package, distribution, version, "timestamp");
2344 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
2347 ALTER TABLE ONLY users
2348 ADD CONSTRAINT users_pkey PRIMARY KEY (architecture, username, distribution);
2352 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2355 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
2359 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2362 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
2366 -- Name: packages_arch_dist_state; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2369 CREATE INDEX packages_arch_dist_state ON packages USING btree (architecture, distribution, upper((state)::text));
2373 -- Name: packages_distribution_package; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2376 CREATE INDEX packages_distribution_package ON packages USING btree (distribution, package);
2380 -- Name: pkg_history_timestamp; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
2383 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
2386 SET search_path = alpha, pg_catalog;
2389 -- Name: packages_delete; Type: RULE; Schema: alpha; Owner: wbadm
2392 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));
2396 -- Name: packages_insert; Type: RULE; Schema: alpha; Owner: wbadm
2399 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);
2403 -- Name: packages_update; Type: RULE; Schema: alpha; Owner: wbadm
2406 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));
2410 -- Name: pkg_history_delete; Type: RULE; Schema: alpha; Owner: wbadm
2413 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"));
2417 -- Name: pkg_history_insert; Type: RULE; Schema: alpha; Owner: wbadm
2420 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('alpha'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
2424 -- Name: pkg_history_update; Type: RULE; Schema: alpha; Owner: wbadm
2427 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
2431 -- Name: transactions_insert; Type: RULE; Schema: alpha; Owner: wbadm
2434 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");
2438 -- Name: users_delete; Type: RULE; Schema: alpha; Owner: wbadm
2441 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));
2445 -- Name: users_insert; Type: RULE; Schema: alpha; Owner: wbadm
2448 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);
2452 -- Name: users_update; Type: RULE; Schema: alpha; Owner: wbadm
2455 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));
2458 SET search_path = amd64, pg_catalog;
2461 -- Name: packages_delete; Type: RULE; Schema: amd64; Owner: wbadm
2464 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));
2468 -- Name: packages_insert; Type: RULE; Schema: amd64; Owner: wbadm
2471 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);
2475 -- Name: packages_update; Type: RULE; Schema: amd64; Owner: wbadm
2478 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));
2482 -- Name: pkg_history_delete; Type: RULE; Schema: amd64; Owner: wbadm
2485 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"));
2489 -- Name: pkg_history_insert; Type: RULE; Schema: amd64; Owner: wbadm
2492 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
2496 -- Name: pkg_history_update; Type: RULE; Schema: amd64; Owner: wbadm
2499 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
2503 -- Name: transactions_insert; Type: RULE; Schema: amd64; Owner: wbadm
2506 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");
2510 -- Name: users_delete; Type: RULE; Schema: amd64; Owner: wbadm
2513 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));
2517 -- Name: users_insert; Type: RULE; Schema: amd64; Owner: wbadm
2520 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);
2524 -- Name: users_update; Type: RULE; Schema: amd64; Owner: wbadm
2527 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));
2530 SET search_path = arm, pg_catalog;
2533 -- Name: packages_delete; Type: RULE; Schema: arm; Owner: wbadm
2536 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));
2540 -- Name: packages_insert; Type: RULE; Schema: arm; Owner: wbadm
2543 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);
2547 -- Name: packages_update; Type: RULE; Schema: arm; Owner: wbadm
2550 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));
2554 -- Name: pkg_history_delete; Type: RULE; Schema: arm; Owner: wbadm
2557 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"));
2561 -- Name: pkg_history_insert; Type: RULE; Schema: arm; Owner: wbadm
2564 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('arm'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
2568 -- Name: pkg_history_update; Type: RULE; Schema: arm; Owner: wbadm
2571 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
2575 -- Name: transactions_insert; Type: RULE; Schema: arm; Owner: wbadm
2578 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");
2582 -- Name: users_delete; Type: RULE; Schema: arm; Owner: wbadm
2585 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));
2589 -- Name: users_insert; Type: RULE; Schema: arm; Owner: wbadm
2592 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);
2596 -- Name: users_update; Type: RULE; Schema: arm; Owner: wbadm
2599 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));
2602 SET search_path = armel, pg_catalog;
2605 -- Name: packages_delete; Type: RULE; Schema: armel; Owner: wbadm
2608 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));
2612 -- Name: packages_insert; Type: RULE; Schema: armel; Owner: wbadm
2615 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);
2619 -- Name: packages_update; Type: RULE; Schema: armel; Owner: wbadm
2622 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));
2626 -- Name: pkg_history_delete; Type: RULE; Schema: armel; Owner: wbadm
2629 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"));
2633 -- Name: pkg_history_insert; Type: RULE; Schema: armel; Owner: wbadm
2636 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('armel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
2640 -- Name: pkg_history_update; Type: RULE; Schema: armel; Owner: wbadm
2643 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
2647 -- Name: transactions_insert; Type: RULE; Schema: armel; Owner: wbadm
2650 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");
2654 -- Name: users_delete; Type: RULE; Schema: armel; Owner: wbadm
2657 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));
2661 -- Name: users_insert; Type: RULE; Schema: armel; Owner: wbadm
2664 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);
2668 -- Name: users_update; Type: RULE; Schema: armel; Owner: wbadm
2671 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));
2674 SET search_path = hppa, pg_catalog;
2677 -- Name: packages_delete; Type: RULE; Schema: hppa; Owner: wbadm
2680 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));
2684 -- Name: packages_insert; Type: RULE; Schema: hppa; Owner: wbadm
2687 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);
2691 -- Name: packages_update; Type: RULE; Schema: hppa; Owner: wbadm
2694 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));
2698 -- Name: pkg_history_delete; Type: RULE; Schema: hppa; Owner: wbadm
2701 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"));
2705 -- Name: pkg_history_insert; Type: RULE; Schema: hppa; Owner: wbadm
2708 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('hppa'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
2712 -- Name: pkg_history_update; Type: RULE; Schema: hppa; Owner: wbadm
2715 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
2719 -- Name: transactions_insert; Type: RULE; Schema: hppa; Owner: wbadm
2722 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");
2726 -- Name: users_delete; Type: RULE; Schema: hppa; Owner: wbadm
2729 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));
2733 -- Name: users_insert; Type: RULE; Schema: hppa; Owner: wbadm
2736 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);
2740 -- Name: users_update; Type: RULE; Schema: hppa; Owner: wbadm
2743 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));
2746 SET search_path = "hurd-i386", pg_catalog;
2749 -- Name: packages_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
2752 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));
2756 -- Name: packages_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
2759 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);
2763 -- Name: packages_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
2766 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));
2770 -- Name: pkg_history_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
2773 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"));
2777 -- Name: pkg_history_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
2780 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('hurd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
2784 -- Name: pkg_history_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
2787 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
2791 -- Name: transactions_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
2794 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");
2798 -- Name: users_delete; Type: RULE; Schema: hurd-i386; Owner: wbadm
2801 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));
2805 -- Name: users_insert; Type: RULE; Schema: hurd-i386; Owner: wbadm
2808 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);
2812 -- Name: users_update; Type: RULE; Schema: hurd-i386; Owner: wbadm
2815 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));
2818 SET search_path = i386, pg_catalog;
2821 -- Name: packages_delete; Type: RULE; Schema: i386; Owner: wbadm
2824 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));
2828 -- Name: packages_insert; Type: RULE; Schema: i386; Owner: wbadm
2831 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);
2835 -- Name: packages_update; Type: RULE; Schema: i386; Owner: wbadm
2838 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));
2842 -- Name: pkg_history_delete; Type: RULE; Schema: i386; Owner: wbadm
2845 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"));
2849 -- Name: pkg_history_insert; Type: RULE; Schema: i386; Owner: wbadm
2852 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
2856 -- Name: pkg_history_update; Type: RULE; Schema: i386; Owner: wbadm
2859 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
2863 -- Name: transactions_insert; Type: RULE; Schema: i386; Owner: wbadm
2866 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");
2870 -- Name: users_delete; Type: RULE; Schema: i386; Owner: wbadm
2873 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));
2877 -- Name: users_insert; Type: RULE; Schema: i386; Owner: wbadm
2880 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);
2884 -- Name: users_update; Type: RULE; Schema: i386; Owner: wbadm
2887 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));
2890 SET search_path = ia64, pg_catalog;
2893 -- Name: packages_delete; Type: RULE; Schema: ia64; Owner: wbadm
2896 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));
2900 -- Name: packages_insert; Type: RULE; Schema: ia64; Owner: wbadm
2903 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);
2907 -- Name: packages_update; Type: RULE; Schema: ia64; Owner: wbadm
2910 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));
2914 -- Name: pkg_history_delete; Type: RULE; Schema: ia64; Owner: wbadm
2917 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"));
2921 -- Name: pkg_history_insert; Type: RULE; Schema: ia64; Owner: wbadm
2924 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('ia64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
2928 -- Name: pkg_history_update; Type: RULE; Schema: ia64; Owner: wbadm
2931 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
2935 -- Name: transactions_insert; Type: RULE; Schema: ia64; Owner: wbadm
2938 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");
2942 -- Name: users_delete; Type: RULE; Schema: ia64; Owner: wbadm
2945 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));
2949 -- Name: users_insert; Type: RULE; Schema: ia64; Owner: wbadm
2952 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);
2956 -- Name: users_update; Type: RULE; Schema: ia64; Owner: wbadm
2959 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));
2962 SET search_path = "kfreebsd-amd64", pg_catalog;
2965 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
2968 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));
2972 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
2975 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);
2979 -- Name: packages_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
2982 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));
2986 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
2989 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"));
2993 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
2996 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('kfreebsd-amd64'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
3000 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3003 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
3007 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3010 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");
3014 -- Name: users_delete; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3017 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));
3021 -- Name: users_insert; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3024 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);
3028 -- Name: users_update; Type: RULE; Schema: kfreebsd-amd64; Owner: wbadm
3031 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));
3034 SET search_path = "kfreebsd-i386", pg_catalog;
3037 -- Name: packages_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3040 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));
3044 -- Name: packages_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3047 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);
3051 -- Name: packages_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3054 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));
3058 -- Name: pkg_history_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3061 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"));
3065 -- Name: pkg_history_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3068 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('kfreebsd-i386'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
3072 -- Name: pkg_history_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3075 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
3079 -- Name: transactions_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3082 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");
3086 -- Name: users_delete; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3089 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));
3093 -- Name: users_insert; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3096 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);
3100 -- Name: users_update; Type: RULE; Schema: kfreebsd-i386; Owner: wbadm
3103 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));
3106 SET search_path = mips, pg_catalog;
3109 -- Name: packages_delete; Type: RULE; Schema: mips; Owner: wbadm
3112 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));
3116 -- Name: packages_insert; Type: RULE; Schema: mips; Owner: wbadm
3119 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);
3123 -- Name: packages_update; Type: RULE; Schema: mips; Owner: wbadm
3126 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));
3130 -- Name: pkg_history_delete; Type: RULE; Schema: mips; Owner: wbadm
3133 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"));
3137 -- Name: pkg_history_insert; Type: RULE; Schema: mips; Owner: wbadm
3140 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('mips'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
3144 -- Name: pkg_history_update; Type: RULE; Schema: mips; Owner: wbadm
3147 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
3151 -- Name: transactions_insert; Type: RULE; Schema: mips; Owner: wbadm
3154 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");
3158 -- Name: users_delete; Type: RULE; Schema: mips; Owner: wbadm
3161 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));
3165 -- Name: users_insert; Type: RULE; Schema: mips; Owner: wbadm
3168 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);
3172 -- Name: users_update; Type: RULE; Schema: mips; Owner: wbadm
3175 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));
3178 SET search_path = mipsel, pg_catalog;
3181 -- Name: packages_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3184 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));
3188 -- Name: packages_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3191 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);
3195 -- Name: packages_update; Type: RULE; Schema: mipsel; Owner: wbadm
3198 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));
3202 -- Name: pkg_history_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3205 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"));
3209 -- Name: pkg_history_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3212 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('mipsel'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
3216 -- Name: pkg_history_update; Type: RULE; Schema: mipsel; Owner: wbadm
3219 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
3223 -- Name: transactions_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3226 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");
3230 -- Name: users_delete; Type: RULE; Schema: mipsel; Owner: wbadm
3233 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));
3237 -- Name: users_insert; Type: RULE; Schema: mipsel; Owner: wbadm
3240 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);
3244 -- Name: users_update; Type: RULE; Schema: mipsel; Owner: wbadm
3247 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));
3250 SET search_path = powerpc, pg_catalog;
3253 -- Name: packages_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3256 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));
3260 -- Name: packages_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3263 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);
3267 -- Name: packages_update; Type: RULE; Schema: powerpc; Owner: wbadm
3270 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));
3274 -- Name: pkg_history_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3277 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"));
3281 -- Name: pkg_history_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3284 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('powerpc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
3288 -- Name: pkg_history_update; Type: RULE; Schema: powerpc; Owner: wbadm
3291 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
3295 -- Name: transactions_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3298 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");
3302 -- Name: users_delete; Type: RULE; Schema: powerpc; Owner: wbadm
3305 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));
3309 -- Name: users_insert; Type: RULE; Schema: powerpc; Owner: wbadm
3312 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);
3316 -- Name: users_update; Type: RULE; Schema: powerpc; Owner: wbadm
3319 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));
3322 SET search_path = s390, pg_catalog;
3325 -- Name: packages_delete; Type: RULE; Schema: s390; Owner: wbadm
3328 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));
3332 -- Name: packages_insert; Type: RULE; Schema: s390; Owner: wbadm
3335 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);
3339 -- Name: packages_update; Type: RULE; Schema: s390; Owner: wbadm
3342 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));
3346 -- Name: pkg_history_delete; Type: RULE; Schema: s390; Owner: wbadm
3349 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"));
3353 -- Name: pkg_history_insert; Type: RULE; Schema: s390; Owner: wbadm
3356 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('s390'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
3360 -- Name: pkg_history_update; Type: RULE; Schema: s390; Owner: wbadm
3363 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
3367 -- Name: transactions_insert; Type: RULE; Schema: s390; Owner: wbadm
3370 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");
3374 -- Name: users_delete; Type: RULE; Schema: s390; Owner: wbadm
3377 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));
3381 -- Name: users_insert; Type: RULE; Schema: s390; Owner: wbadm
3384 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);
3388 -- Name: users_update; Type: RULE; Schema: s390; Owner: wbadm
3391 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));
3394 SET search_path = sparc, pg_catalog;
3397 -- Name: packages_delete; Type: RULE; Schema: sparc; Owner: wbadm
3400 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));
3404 -- Name: packages_insert; Type: RULE; Schema: sparc; Owner: wbadm
3407 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);
3411 -- Name: packages_update; Type: RULE; Schema: sparc; Owner: wbadm
3414 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));
3418 -- Name: pkg_history_delete; Type: RULE; Schema: sparc; Owner: wbadm
3421 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"));
3425 -- Name: pkg_history_insert; Type: RULE; Schema: sparc; Owner: wbadm
3428 CREATE RULE pkg_history_insert AS ON INSERT TO pkg_history DO INSTEAD INSERT INTO public.pkg_history (architecture, package, distribution, version, "timestamp", result, build_time, disk_space) VALUES ('sparc'::character varying, new.package, new.distribution, new.version, new."timestamp", new.result, new.build_time, new.disk_space);
3432 -- Name: pkg_history_update; Type: RULE; Schema: sparc; Owner: wbadm
3435 CREATE RULE pkg_history_update AS ON UPDATE TO pkg_history DO INSTEAD UPDATE public.pkg_history p SET result = new.result, build_time = new.build_time, disk_space = new.disk_space WHERE ((((((p.architecture)::text = '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"));
3439 -- Name: transactions_insert; Type: RULE; Schema: sparc; Owner: wbadm
3442 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");
3446 -- Name: users_delete; Type: RULE; Schema: sparc; Owner: wbadm
3449 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));
3453 -- Name: users_insert; Type: RULE; Schema: sparc; Owner: wbadm
3456 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);
3460 -- Name: users_update; Type: RULE; Schema: sparc; Owner: wbadm
3463 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));
3466 SET search_path = public, pg_catalog;
3469 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3472 ALTER TABLE ONLY distribution_aliases
3473 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3477 -- Name: distribution_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3480 ALTER TABLE ONLY packages
3481 ADD CONSTRAINT distribution_architecture_fkey FOREIGN KEY (distribution, architecture) REFERENCES distribution_architectures(distribution, architecture);
3485 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3488 ALTER TABLE ONLY packages
3489 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3493 -- Name: pkg_history_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
3496 ALTER TABLE ONLY pkg_history
3497 ADD CONSTRAINT pkg_history_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
3501 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
3504 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
3505 REVOKE ALL ON SCHEMA alpha FROM wbadm;
3506 GRANT ALL ON SCHEMA alpha TO wbadm;
3507 GRANT USAGE ON SCHEMA alpha TO alpha;
3508 GRANT USAGE ON SCHEMA alpha TO wb_all;
3509 GRANT USAGE ON SCHEMA alpha TO wb_security;
3513 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
3516 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
3517 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
3518 GRANT ALL ON SCHEMA alpha_public TO wbadm;
3519 GRANT USAGE ON SCHEMA alpha_public TO alpha;
3520 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
3524 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
3527 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
3528 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
3529 GRANT ALL ON SCHEMA amd64 TO wbadm;
3530 GRANT USAGE ON SCHEMA amd64 TO amd64;
3531 GRANT USAGE ON SCHEMA amd64 TO wb_all;
3532 GRANT USAGE ON SCHEMA amd64 TO wb_security;
3536 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
3539 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
3540 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
3541 GRANT ALL ON SCHEMA amd64_public TO wbadm;
3542 GRANT USAGE ON SCHEMA amd64_public TO amd64;
3543 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
3547 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
3550 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
3551 REVOKE ALL ON SCHEMA arm FROM wbadm;
3552 GRANT ALL ON SCHEMA arm TO wbadm;
3553 GRANT USAGE ON SCHEMA arm TO arm;
3554 GRANT USAGE ON SCHEMA arm TO wb_all;
3555 GRANT USAGE ON SCHEMA arm TO wb_security;
3559 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
3562 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
3563 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
3564 GRANT ALL ON SCHEMA arm_public TO wbadm;
3565 GRANT USAGE ON SCHEMA arm_public TO arm;
3566 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
3570 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
3573 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
3574 REVOKE ALL ON SCHEMA armel FROM wbadm;
3575 GRANT ALL ON SCHEMA armel TO wbadm;
3576 GRANT USAGE ON SCHEMA armel TO armel;
3577 GRANT USAGE ON SCHEMA armel TO wb_all;
3578 GRANT USAGE ON SCHEMA armel TO wb_security;
3582 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
3585 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
3586 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
3587 GRANT ALL ON SCHEMA armel_public TO wbadm;
3588 GRANT USAGE ON SCHEMA armel_public TO armel;
3589 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
3593 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
3596 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
3597 REVOKE ALL ON SCHEMA hppa FROM wbadm;
3598 GRANT ALL ON SCHEMA hppa TO wbadm;
3599 GRANT USAGE ON SCHEMA hppa TO hppa;
3600 GRANT USAGE ON SCHEMA hppa TO wb_all;
3601 GRANT USAGE ON SCHEMA hppa TO wb_security;
3605 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
3608 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
3609 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
3610 GRANT ALL ON SCHEMA hppa_public TO wbadm;
3611 GRANT USAGE ON SCHEMA hppa_public TO hppa;
3612 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
3616 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
3619 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
3620 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
3621 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
3622 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
3623 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
3624 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
3628 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
3631 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
3632 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
3633 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
3634 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
3635 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
3639 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
3642 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
3643 REVOKE ALL ON SCHEMA i386 FROM wbadm;
3644 GRANT ALL ON SCHEMA i386 TO wbadm;
3645 GRANT USAGE ON SCHEMA i386 TO i386;
3646 GRANT USAGE ON SCHEMA i386 TO wb_all;
3647 GRANT USAGE ON SCHEMA i386 TO wb_security;
3651 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
3654 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
3655 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
3656 GRANT ALL ON SCHEMA i386_public TO wbadm;
3657 GRANT USAGE ON SCHEMA i386_public TO i386;
3658 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
3662 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
3665 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
3666 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
3667 GRANT ALL ON SCHEMA ia64 TO wbadm;
3668 GRANT USAGE ON SCHEMA ia64 TO ia64;
3669 GRANT USAGE ON SCHEMA ia64 TO wb_all;
3670 GRANT USAGE ON SCHEMA ia64 TO wb_security;
3674 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
3677 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
3678 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
3679 GRANT ALL ON SCHEMA ia64_public TO wbadm;
3680 GRANT USAGE ON SCHEMA ia64_public TO ia64;
3681 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
3685 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
3688 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
3689 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
3690 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
3691 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
3692 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
3693 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
3697 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
3700 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
3701 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
3702 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
3703 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
3704 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
3708 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
3711 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
3712 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
3713 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
3714 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
3715 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
3716 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
3720 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
3723 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
3724 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
3725 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
3726 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
3727 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
3731 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
3734 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
3735 REVOKE ALL ON SCHEMA mips FROM wbadm;
3736 GRANT ALL ON SCHEMA mips TO wbadm;
3737 GRANT USAGE ON SCHEMA mips TO mips;
3738 GRANT USAGE ON SCHEMA mips TO wb_all;
3739 GRANT USAGE ON SCHEMA mips TO wb_security;
3743 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
3746 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
3747 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
3748 GRANT ALL ON SCHEMA mips_public TO wbadm;
3749 GRANT USAGE ON SCHEMA mips_public TO mips;
3750 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
3754 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
3757 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
3758 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
3759 GRANT ALL ON SCHEMA mipsel TO wbadm;
3760 GRANT USAGE ON SCHEMA mipsel TO mipsel;
3761 GRANT USAGE ON SCHEMA mipsel TO wb_all;
3762 GRANT USAGE ON SCHEMA mipsel TO wb_security;
3766 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
3769 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
3770 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
3771 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
3772 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
3773 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
3777 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
3780 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
3781 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
3782 GRANT ALL ON SCHEMA powerpc TO wbadm;
3783 GRANT USAGE ON SCHEMA powerpc TO powerpc;
3784 GRANT USAGE ON SCHEMA powerpc TO wb_all;
3785 GRANT USAGE ON SCHEMA powerpc TO wb_security;
3789 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
3792 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
3793 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
3794 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
3795 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
3796 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
3800 -- Name: public; Type: ACL; Schema: -; Owner: postgres
3803 REVOKE ALL ON SCHEMA public FROM PUBLIC;
3804 REVOKE ALL ON SCHEMA public FROM postgres;
3805 GRANT ALL ON SCHEMA public TO postgres;
3806 GRANT ALL ON SCHEMA public TO PUBLIC;
3810 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
3813 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
3814 REVOKE ALL ON SCHEMA s390 FROM wbadm;
3815 GRANT ALL ON SCHEMA s390 TO wbadm;
3816 GRANT USAGE ON SCHEMA s390 TO s390;
3817 GRANT USAGE ON SCHEMA s390 TO wb_all;
3818 GRANT USAGE ON SCHEMA s390 TO wb_security;
3822 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
3825 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
3826 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
3827 GRANT ALL ON SCHEMA s390_public TO wbadm;
3828 GRANT USAGE ON SCHEMA s390_public TO s390;
3829 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
3833 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
3836 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
3837 REVOKE ALL ON SCHEMA sparc FROM wbadm;
3838 GRANT ALL ON SCHEMA sparc TO wbadm;
3839 GRANT USAGE ON SCHEMA sparc TO sparc;
3840 GRANT USAGE ON SCHEMA sparc TO wb_all;
3841 GRANT USAGE ON SCHEMA sparc TO wb_security;
3845 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
3848 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
3849 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
3850 GRANT ALL ON SCHEMA sparc_public TO wbadm;
3851 GRANT USAGE ON SCHEMA sparc_public TO sparc;
3852 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
3856 -- Name: packages; Type: ACL; Schema: public; Owner: wbadm
3859 REVOKE ALL ON TABLE packages FROM PUBLIC;
3860 REVOKE ALL ON TABLE packages FROM wbadm;
3861 GRANT ALL ON TABLE packages TO wbadm;
3864 SET search_path = alpha, pg_catalog;
3867 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
3870 REVOKE ALL ON TABLE packages FROM PUBLIC;
3871 REVOKE ALL ON TABLE packages FROM wbadm;
3872 GRANT ALL ON TABLE packages TO wbadm;
3873 GRANT SELECT ON TABLE packages TO wb_security;
3874 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
3877 SET search_path = public, pg_catalog;
3880 -- Name: pkg_history; Type: ACL; Schema: public; Owner: wbadm
3883 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
3884 REVOKE ALL ON TABLE pkg_history FROM wbadm;
3885 GRANT ALL ON TABLE pkg_history TO wbadm;
3888 SET search_path = alpha, pg_catalog;
3891 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
3894 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
3895 REVOKE ALL ON TABLE pkg_history FROM wbadm;
3896 GRANT ALL ON TABLE pkg_history TO wbadm;
3897 GRANT SELECT ON TABLE pkg_history TO wb_security;
3898 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
3901 SET search_path = public, pg_catalog;
3904 -- Name: transactions; Type: ACL; Schema: public; Owner: wbadm
3907 REVOKE ALL ON TABLE transactions FROM PUBLIC;
3908 REVOKE ALL ON TABLE transactions FROM wbadm;
3909 GRANT ALL ON TABLE transactions TO wbadm;
3912 SET search_path = alpha, pg_catalog;
3915 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
3918 REVOKE ALL ON TABLE transactions FROM PUBLIC;
3919 REVOKE ALL ON TABLE transactions FROM wbadm;
3920 GRANT ALL ON TABLE transactions TO wbadm;
3921 GRANT SELECT ON TABLE transactions TO wb_security;
3922 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
3925 SET search_path = public, pg_catalog;
3928 -- Name: users; Type: ACL; Schema: public; Owner: wbadm
3931 REVOKE ALL ON TABLE users FROM PUBLIC;
3932 REVOKE ALL ON TABLE users FROM wbadm;
3933 GRANT ALL ON TABLE users TO wbadm;
3936 SET search_path = alpha, pg_catalog;
3939 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
3942 REVOKE ALL ON TABLE users FROM PUBLIC;
3943 REVOKE ALL ON TABLE users FROM wbadm;
3944 GRANT ALL ON TABLE users TO wbadm;
3945 GRANT SELECT ON TABLE users TO wb_security;
3946 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
3949 SET search_path = public, pg_catalog;
3952 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
3955 REVOKE ALL ON TABLE distributions FROM PUBLIC;
3956 REVOKE ALL ON TABLE distributions FROM wbadm;
3957 GRANT ALL ON TABLE distributions TO wbadm;
3958 GRANT SELECT ON TABLE distributions TO PUBLIC;
3961 SET search_path = alpha_public, pg_catalog;
3964 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
3967 REVOKE ALL ON TABLE packages FROM PUBLIC;
3968 REVOKE ALL ON TABLE packages FROM wbadm;
3969 GRANT ALL ON TABLE packages TO wbadm;
3970 GRANT SELECT ON TABLE packages TO PUBLIC;
3974 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
3977 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
3978 REVOKE ALL ON TABLE pkg_history FROM wbadm;
3979 GRANT ALL ON TABLE pkg_history TO wbadm;
3980 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
3984 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
3987 REVOKE ALL ON TABLE transactions FROM PUBLIC;
3988 REVOKE ALL ON TABLE transactions FROM wbadm;
3989 GRANT ALL ON TABLE transactions TO wbadm;
3990 GRANT SELECT ON TABLE transactions TO PUBLIC;
3994 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
3997 REVOKE ALL ON TABLE users FROM PUBLIC;
3998 REVOKE ALL ON TABLE users FROM wbadm;
3999 GRANT ALL ON TABLE users TO wbadm;
4000 GRANT SELECT ON TABLE users TO PUBLIC;
4003 SET search_path = amd64, pg_catalog;
4006 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4009 REVOKE ALL ON TABLE packages FROM PUBLIC;
4010 REVOKE ALL ON TABLE packages FROM wbadm;
4011 GRANT ALL ON TABLE packages TO wbadm;
4012 GRANT SELECT ON TABLE packages TO wb_security;
4013 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4017 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4020 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4021 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4022 GRANT ALL ON TABLE pkg_history TO wbadm;
4023 GRANT SELECT ON TABLE pkg_history TO wb_security;
4024 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4028 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4031 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4032 REVOKE ALL ON TABLE transactions FROM wbadm;
4033 GRANT ALL ON TABLE transactions TO wbadm;
4034 GRANT SELECT ON TABLE transactions TO wb_security;
4035 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4039 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4042 REVOKE ALL ON TABLE users FROM PUBLIC;
4043 REVOKE ALL ON TABLE users FROM wbadm;
4044 GRANT ALL ON TABLE users TO wbadm;
4045 GRANT SELECT ON TABLE users TO wb_security;
4046 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4049 SET search_path = amd64_public, pg_catalog;
4052 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4055 REVOKE ALL ON TABLE packages FROM PUBLIC;
4056 REVOKE ALL ON TABLE packages FROM wbadm;
4057 GRANT ALL ON TABLE packages TO wbadm;
4058 GRANT SELECT ON TABLE packages TO PUBLIC;
4062 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4065 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4066 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4067 GRANT ALL ON TABLE pkg_history TO wbadm;
4068 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4072 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4075 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4076 REVOKE ALL ON TABLE transactions FROM wbadm;
4077 GRANT ALL ON TABLE transactions TO wbadm;
4078 GRANT SELECT ON TABLE transactions TO PUBLIC;
4082 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4085 REVOKE ALL ON TABLE users FROM PUBLIC;
4086 REVOKE ALL ON TABLE users FROM wbadm;
4087 GRANT ALL ON TABLE users TO wbadm;
4088 GRANT SELECT ON TABLE users TO PUBLIC;
4091 SET search_path = arm, pg_catalog;
4094 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4097 REVOKE ALL ON TABLE packages FROM PUBLIC;
4098 REVOKE ALL ON TABLE packages FROM wbadm;
4099 GRANT ALL ON TABLE packages TO wbadm;
4100 GRANT SELECT ON TABLE packages TO wb_security;
4101 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4105 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4108 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4109 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4110 GRANT ALL ON TABLE pkg_history TO wbadm;
4111 GRANT SELECT ON TABLE pkg_history TO wb_security;
4112 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4116 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4119 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4120 REVOKE ALL ON TABLE transactions FROM wbadm;
4121 GRANT ALL ON TABLE transactions TO wbadm;
4122 GRANT SELECT ON TABLE transactions TO wb_security;
4123 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4127 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4130 REVOKE ALL ON TABLE users FROM PUBLIC;
4131 REVOKE ALL ON TABLE users FROM wbadm;
4132 GRANT ALL ON TABLE users TO wbadm;
4133 GRANT SELECT ON TABLE users TO wb_security;
4134 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4137 SET search_path = arm_public, pg_catalog;
4140 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4143 REVOKE ALL ON TABLE packages FROM PUBLIC;
4144 REVOKE ALL ON TABLE packages FROM wbadm;
4145 GRANT ALL ON TABLE packages TO wbadm;
4146 GRANT SELECT ON TABLE packages TO PUBLIC;
4150 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4153 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4154 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4155 GRANT ALL ON TABLE pkg_history TO wbadm;
4156 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4160 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4163 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4164 REVOKE ALL ON TABLE transactions FROM wbadm;
4165 GRANT ALL ON TABLE transactions TO wbadm;
4166 GRANT SELECT ON TABLE transactions TO PUBLIC;
4170 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4173 REVOKE ALL ON TABLE users FROM PUBLIC;
4174 REVOKE ALL ON TABLE users FROM wbadm;
4175 GRANT ALL ON TABLE users TO wbadm;
4176 GRANT SELECT ON TABLE users TO PUBLIC;
4179 SET search_path = armel, pg_catalog;
4182 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4185 REVOKE ALL ON TABLE packages FROM PUBLIC;
4186 REVOKE ALL ON TABLE packages FROM wbadm;
4187 GRANT ALL ON TABLE packages TO wbadm;
4188 GRANT SELECT ON TABLE packages TO wb_security;
4189 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4193 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4196 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4197 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4198 GRANT ALL ON TABLE pkg_history TO wbadm;
4199 GRANT SELECT ON TABLE pkg_history TO wb_security;
4200 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4204 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4207 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4208 REVOKE ALL ON TABLE transactions FROM wbadm;
4209 GRANT ALL ON TABLE transactions TO wbadm;
4210 GRANT SELECT ON TABLE transactions TO wb_security;
4211 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4215 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4218 REVOKE ALL ON TABLE users FROM PUBLIC;
4219 REVOKE ALL ON TABLE users FROM wbadm;
4220 GRANT ALL ON TABLE users TO wbadm;
4221 GRANT SELECT ON TABLE users TO wb_security;
4222 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4225 SET search_path = armel_public, pg_catalog;
4228 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4231 REVOKE ALL ON TABLE packages FROM PUBLIC;
4232 REVOKE ALL ON TABLE packages FROM wbadm;
4233 GRANT ALL ON TABLE packages TO wbadm;
4234 GRANT SELECT ON TABLE packages TO PUBLIC;
4238 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4241 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4242 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4243 GRANT ALL ON TABLE pkg_history TO wbadm;
4244 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4248 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4251 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4252 REVOKE ALL ON TABLE transactions FROM wbadm;
4253 GRANT ALL ON TABLE transactions TO wbadm;
4254 GRANT SELECT ON TABLE transactions TO PUBLIC;
4258 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4261 REVOKE ALL ON TABLE users FROM PUBLIC;
4262 REVOKE ALL ON TABLE users FROM wbadm;
4263 GRANT ALL ON TABLE users TO wbadm;
4264 GRANT SELECT ON TABLE users TO PUBLIC;
4267 SET search_path = hppa, pg_catalog;
4270 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4273 REVOKE ALL ON TABLE packages FROM PUBLIC;
4274 REVOKE ALL ON TABLE packages FROM wbadm;
4275 GRANT ALL ON TABLE packages TO wbadm;
4276 GRANT SELECT ON TABLE packages TO wb_security;
4277 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4281 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4284 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4285 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4286 GRANT ALL ON TABLE pkg_history TO wbadm;
4287 GRANT SELECT ON TABLE pkg_history TO wb_security;
4288 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4292 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4295 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4296 REVOKE ALL ON TABLE transactions FROM wbadm;
4297 GRANT ALL ON TABLE transactions TO wbadm;
4298 GRANT SELECT ON TABLE transactions TO wb_security;
4299 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4303 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4306 REVOKE ALL ON TABLE users FROM PUBLIC;
4307 REVOKE ALL ON TABLE users FROM wbadm;
4308 GRANT ALL ON TABLE users TO wbadm;
4309 GRANT SELECT ON TABLE users TO wb_security;
4310 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4313 SET search_path = hppa_public, pg_catalog;
4316 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4319 REVOKE ALL ON TABLE packages FROM PUBLIC;
4320 REVOKE ALL ON TABLE packages FROM wbadm;
4321 GRANT ALL ON TABLE packages TO wbadm;
4322 GRANT SELECT ON TABLE packages TO PUBLIC;
4326 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4329 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4330 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4331 GRANT ALL ON TABLE pkg_history TO wbadm;
4332 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4336 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4339 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4340 REVOKE ALL ON TABLE transactions FROM wbadm;
4341 GRANT ALL ON TABLE transactions TO wbadm;
4342 GRANT SELECT ON TABLE transactions TO PUBLIC;
4346 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4349 REVOKE ALL ON TABLE users FROM PUBLIC;
4350 REVOKE ALL ON TABLE users FROM wbadm;
4351 GRANT ALL ON TABLE users TO wbadm;
4352 GRANT SELECT ON TABLE users TO PUBLIC;
4355 SET search_path = "hurd-i386", pg_catalog;
4358 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4361 REVOKE ALL ON TABLE packages FROM PUBLIC;
4362 REVOKE ALL ON TABLE packages FROM wbadm;
4363 GRANT ALL ON TABLE packages TO wbadm;
4364 GRANT SELECT ON TABLE packages TO wb_security;
4365 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4369 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4372 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4373 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4374 GRANT ALL ON TABLE pkg_history TO wbadm;
4375 GRANT SELECT ON TABLE pkg_history TO wb_security;
4376 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4380 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4383 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4384 REVOKE ALL ON TABLE transactions FROM wbadm;
4385 GRANT ALL ON TABLE transactions TO wbadm;
4386 GRANT SELECT ON TABLE transactions TO wb_security;
4387 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4391 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4394 REVOKE ALL ON TABLE users FROM PUBLIC;
4395 REVOKE ALL ON TABLE users FROM wbadm;
4396 GRANT ALL ON TABLE users TO wbadm;
4397 GRANT SELECT ON TABLE users TO wb_security;
4398 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4401 SET search_path = "hurd-i386_public", pg_catalog;
4404 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4407 REVOKE ALL ON TABLE packages FROM PUBLIC;
4408 REVOKE ALL ON TABLE packages FROM wbadm;
4409 GRANT ALL ON TABLE packages TO wbadm;
4410 GRANT SELECT ON TABLE packages TO PUBLIC;
4414 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4417 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4418 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4419 GRANT ALL ON TABLE pkg_history TO wbadm;
4420 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4424 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4427 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4428 REVOKE ALL ON TABLE transactions FROM wbadm;
4429 GRANT ALL ON TABLE transactions TO wbadm;
4430 GRANT SELECT ON TABLE transactions TO PUBLIC;
4434 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4437 REVOKE ALL ON TABLE users FROM PUBLIC;
4438 REVOKE ALL ON TABLE users FROM wbadm;
4439 GRANT ALL ON TABLE users TO wbadm;
4440 GRANT SELECT ON TABLE users TO PUBLIC;
4443 SET search_path = i386, pg_catalog;
4446 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4449 REVOKE ALL ON TABLE packages FROM PUBLIC;
4450 REVOKE ALL ON TABLE packages FROM wbadm;
4451 GRANT ALL ON TABLE packages TO wbadm;
4452 GRANT SELECT ON TABLE packages TO wb_security;
4453 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4457 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4460 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4461 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4462 GRANT ALL ON TABLE pkg_history TO wbadm;
4463 GRANT SELECT ON TABLE pkg_history TO wb_security;
4464 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4468 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
4471 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4472 REVOKE ALL ON TABLE transactions FROM wbadm;
4473 GRANT ALL ON TABLE transactions TO wbadm;
4474 GRANT SELECT ON TABLE transactions TO wb_security;
4475 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4479 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
4482 REVOKE ALL ON TABLE users FROM PUBLIC;
4483 REVOKE ALL ON TABLE users FROM wbadm;
4484 GRANT ALL ON TABLE users TO wbadm;
4485 GRANT SELECT ON TABLE users TO wb_security;
4486 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4489 SET search_path = i386_public, pg_catalog;
4492 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
4495 REVOKE ALL ON TABLE packages FROM PUBLIC;
4496 REVOKE ALL ON TABLE packages FROM wbadm;
4497 GRANT ALL ON TABLE packages TO wbadm;
4498 GRANT SELECT ON TABLE packages TO PUBLIC;
4502 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
4505 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4506 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4507 GRANT ALL ON TABLE pkg_history TO wbadm;
4508 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4512 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
4515 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4516 REVOKE ALL ON TABLE transactions FROM wbadm;
4517 GRANT ALL ON TABLE transactions TO wbadm;
4518 GRANT SELECT ON TABLE transactions TO PUBLIC;
4522 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
4525 REVOKE ALL ON TABLE users FROM PUBLIC;
4526 REVOKE ALL ON TABLE users FROM wbadm;
4527 GRANT ALL ON TABLE users TO wbadm;
4528 GRANT SELECT ON TABLE users TO PUBLIC;
4531 SET search_path = ia64, pg_catalog;
4534 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
4537 REVOKE ALL ON TABLE packages FROM PUBLIC;
4538 REVOKE ALL ON TABLE packages FROM wbadm;
4539 GRANT ALL ON TABLE packages TO wbadm;
4540 GRANT SELECT ON TABLE packages TO wb_security;
4541 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4545 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
4548 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4549 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4550 GRANT ALL ON TABLE pkg_history TO wbadm;
4551 GRANT SELECT ON TABLE pkg_history TO wb_security;
4552 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4556 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
4559 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4560 REVOKE ALL ON TABLE transactions FROM wbadm;
4561 GRANT ALL ON TABLE transactions TO wbadm;
4562 GRANT SELECT ON TABLE transactions TO wb_security;
4563 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4567 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
4570 REVOKE ALL ON TABLE users FROM PUBLIC;
4571 REVOKE ALL ON TABLE users FROM wbadm;
4572 GRANT ALL ON TABLE users TO wbadm;
4573 GRANT SELECT ON TABLE users TO wb_security;
4574 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4577 SET search_path = ia64_public, pg_catalog;
4580 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
4583 REVOKE ALL ON TABLE packages FROM PUBLIC;
4584 REVOKE ALL ON TABLE packages FROM wbadm;
4585 GRANT ALL ON TABLE packages TO wbadm;
4586 GRANT SELECT ON TABLE packages TO PUBLIC;
4590 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
4593 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4594 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4595 GRANT ALL ON TABLE pkg_history TO wbadm;
4596 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4600 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
4603 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4604 REVOKE ALL ON TABLE transactions FROM wbadm;
4605 GRANT ALL ON TABLE transactions TO wbadm;
4606 GRANT SELECT ON TABLE transactions TO PUBLIC;
4610 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
4613 REVOKE ALL ON TABLE users FROM PUBLIC;
4614 REVOKE ALL ON TABLE users FROM wbadm;
4615 GRANT ALL ON TABLE users TO wbadm;
4616 GRANT SELECT ON TABLE users TO PUBLIC;
4619 SET search_path = "kfreebsd-amd64", pg_catalog;
4622 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
4625 REVOKE ALL ON TABLE packages FROM PUBLIC;
4626 REVOKE ALL ON TABLE packages FROM wbadm;
4627 GRANT ALL ON TABLE packages TO wbadm;
4628 GRANT SELECT ON TABLE packages TO wb_security;
4629 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4633 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
4636 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4637 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4638 GRANT ALL ON TABLE pkg_history TO wbadm;
4639 GRANT SELECT ON TABLE pkg_history TO wb_security;
4640 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4644 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
4647 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4648 REVOKE ALL ON TABLE transactions FROM wbadm;
4649 GRANT ALL ON TABLE transactions TO wbadm;
4650 GRANT SELECT ON TABLE transactions TO wb_security;
4651 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4655 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
4658 REVOKE ALL ON TABLE users FROM PUBLIC;
4659 REVOKE ALL ON TABLE users FROM wbadm;
4660 GRANT ALL ON TABLE users TO wbadm;
4661 GRANT SELECT ON TABLE users TO wb_security;
4662 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4665 SET search_path = "kfreebsd-amd64_public", pg_catalog;
4668 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
4671 REVOKE ALL ON TABLE packages FROM PUBLIC;
4672 REVOKE ALL ON TABLE packages FROM wbadm;
4673 GRANT ALL ON TABLE packages TO wbadm;
4674 GRANT SELECT ON TABLE packages TO PUBLIC;
4678 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
4681 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4682 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4683 GRANT ALL ON TABLE pkg_history TO wbadm;
4684 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4688 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
4691 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4692 REVOKE ALL ON TABLE transactions FROM wbadm;
4693 GRANT ALL ON TABLE transactions TO wbadm;
4694 GRANT SELECT ON TABLE transactions TO PUBLIC;
4698 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
4701 REVOKE ALL ON TABLE users FROM PUBLIC;
4702 REVOKE ALL ON TABLE users FROM wbadm;
4703 GRANT ALL ON TABLE users TO wbadm;
4704 GRANT SELECT ON TABLE users TO PUBLIC;
4707 SET search_path = "kfreebsd-i386", pg_catalog;
4710 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
4713 REVOKE ALL ON TABLE packages FROM PUBLIC;
4714 REVOKE ALL ON TABLE packages FROM wbadm;
4715 GRANT ALL ON TABLE packages TO wbadm;
4716 GRANT SELECT ON TABLE packages TO wb_security;
4717 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4721 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
4724 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4725 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4726 GRANT ALL ON TABLE pkg_history TO wbadm;
4727 GRANT SELECT ON TABLE pkg_history TO wb_security;
4728 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4732 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
4735 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4736 REVOKE ALL ON TABLE transactions FROM wbadm;
4737 GRANT ALL ON TABLE transactions TO wbadm;
4738 GRANT SELECT ON TABLE transactions TO wb_security;
4739 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4743 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
4746 REVOKE ALL ON TABLE users FROM PUBLIC;
4747 REVOKE ALL ON TABLE users FROM wbadm;
4748 GRANT ALL ON TABLE users TO wbadm;
4749 GRANT SELECT ON TABLE users TO wb_security;
4750 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4753 SET search_path = "kfreebsd-i386_public", pg_catalog;
4756 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
4759 REVOKE ALL ON TABLE packages FROM PUBLIC;
4760 REVOKE ALL ON TABLE packages FROM wbadm;
4761 GRANT ALL ON TABLE packages TO wbadm;
4762 GRANT SELECT ON TABLE packages TO PUBLIC;
4766 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
4769 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4770 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4771 GRANT ALL ON TABLE pkg_history TO wbadm;
4772 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4776 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
4779 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4780 REVOKE ALL ON TABLE transactions FROM wbadm;
4781 GRANT ALL ON TABLE transactions TO wbadm;
4782 GRANT SELECT ON TABLE transactions TO PUBLIC;
4786 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
4789 REVOKE ALL ON TABLE users FROM PUBLIC;
4790 REVOKE ALL ON TABLE users FROM wbadm;
4791 GRANT ALL ON TABLE users TO wbadm;
4792 GRANT SELECT ON TABLE users TO PUBLIC;
4795 SET search_path = mips, pg_catalog;
4798 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
4801 REVOKE ALL ON TABLE packages FROM PUBLIC;
4802 REVOKE ALL ON TABLE packages FROM wbadm;
4803 GRANT ALL ON TABLE packages TO wbadm;
4804 GRANT SELECT ON TABLE packages TO wb_security;
4805 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4809 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
4812 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4813 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4814 GRANT ALL ON TABLE pkg_history TO wbadm;
4815 GRANT SELECT ON TABLE pkg_history TO wb_security;
4816 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4820 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
4823 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4824 REVOKE ALL ON TABLE transactions FROM wbadm;
4825 GRANT ALL ON TABLE transactions TO wbadm;
4826 GRANT SELECT ON TABLE transactions TO wb_security;
4827 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4831 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
4834 REVOKE ALL ON TABLE users FROM PUBLIC;
4835 REVOKE ALL ON TABLE users FROM wbadm;
4836 GRANT ALL ON TABLE users TO wbadm;
4837 GRANT SELECT ON TABLE users TO wb_security;
4838 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4841 SET search_path = mips_public, pg_catalog;
4844 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
4847 REVOKE ALL ON TABLE packages FROM PUBLIC;
4848 REVOKE ALL ON TABLE packages FROM wbadm;
4849 GRANT ALL ON TABLE packages TO wbadm;
4850 GRANT SELECT ON TABLE packages TO PUBLIC;
4854 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
4857 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4858 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4859 GRANT ALL ON TABLE pkg_history TO wbadm;
4860 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4864 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
4867 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4868 REVOKE ALL ON TABLE transactions FROM wbadm;
4869 GRANT ALL ON TABLE transactions TO wbadm;
4870 GRANT SELECT ON TABLE transactions TO PUBLIC;
4874 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
4877 REVOKE ALL ON TABLE users FROM PUBLIC;
4878 REVOKE ALL ON TABLE users FROM wbadm;
4879 GRANT ALL ON TABLE users TO wbadm;
4880 GRANT SELECT ON TABLE users TO PUBLIC;
4883 SET search_path = mipsel, pg_catalog;
4886 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
4889 REVOKE ALL ON TABLE packages FROM PUBLIC;
4890 REVOKE ALL ON TABLE packages FROM wbadm;
4891 GRANT ALL ON TABLE packages TO wbadm;
4892 GRANT SELECT ON TABLE packages TO wb_security;
4893 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4897 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
4900 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4901 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4902 GRANT ALL ON TABLE pkg_history TO wbadm;
4903 GRANT SELECT ON TABLE pkg_history TO wb_security;
4904 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4908 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
4911 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4912 REVOKE ALL ON TABLE transactions FROM wbadm;
4913 GRANT ALL ON TABLE transactions TO wbadm;
4914 GRANT SELECT ON TABLE transactions TO wb_security;
4915 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
4919 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
4922 REVOKE ALL ON TABLE users FROM PUBLIC;
4923 REVOKE ALL ON TABLE users FROM wbadm;
4924 GRANT ALL ON TABLE users TO wbadm;
4925 GRANT SELECT ON TABLE users TO wb_security;
4926 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
4929 SET search_path = mipsel_public, pg_catalog;
4932 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
4935 REVOKE ALL ON TABLE packages FROM PUBLIC;
4936 REVOKE ALL ON TABLE packages FROM wbadm;
4937 GRANT ALL ON TABLE packages TO wbadm;
4938 GRANT SELECT ON TABLE packages TO PUBLIC;
4942 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
4945 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4946 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4947 GRANT ALL ON TABLE pkg_history TO wbadm;
4948 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4952 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
4955 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4956 REVOKE ALL ON TABLE transactions FROM wbadm;
4957 GRANT ALL ON TABLE transactions TO wbadm;
4958 GRANT SELECT ON TABLE transactions TO PUBLIC;
4962 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
4965 REVOKE ALL ON TABLE users FROM PUBLIC;
4966 REVOKE ALL ON TABLE users FROM wbadm;
4967 GRANT ALL ON TABLE users TO wbadm;
4968 GRANT SELECT ON TABLE users TO PUBLIC;
4971 SET search_path = powerpc, pg_catalog;
4974 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
4977 REVOKE ALL ON TABLE packages FROM PUBLIC;
4978 REVOKE ALL ON TABLE packages FROM wbadm;
4979 GRANT ALL ON TABLE packages TO wbadm;
4980 GRANT SELECT ON TABLE packages TO wb_security;
4981 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
4985 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
4988 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4989 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4990 GRANT ALL ON TABLE pkg_history TO wbadm;
4991 GRANT SELECT ON TABLE pkg_history TO wb_security;
4992 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
4996 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
4999 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5000 REVOKE ALL ON TABLE transactions FROM wbadm;
5001 GRANT ALL ON TABLE transactions TO wbadm;
5002 GRANT SELECT ON TABLE transactions TO wb_security;
5003 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5007 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5010 REVOKE ALL ON TABLE users FROM PUBLIC;
5011 REVOKE ALL ON TABLE users FROM wbadm;
5012 GRANT ALL ON TABLE users TO wbadm;
5013 GRANT SELECT ON TABLE users TO wb_security;
5014 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5017 SET search_path = powerpc_public, pg_catalog;
5020 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5023 REVOKE ALL ON TABLE packages FROM PUBLIC;
5024 REVOKE ALL ON TABLE packages FROM wbadm;
5025 GRANT ALL ON TABLE packages TO wbadm;
5026 GRANT SELECT ON TABLE packages TO PUBLIC;
5030 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5033 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5034 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5035 GRANT ALL ON TABLE pkg_history TO wbadm;
5036 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5040 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5043 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5044 REVOKE ALL ON TABLE transactions FROM wbadm;
5045 GRANT ALL ON TABLE transactions TO wbadm;
5046 GRANT SELECT ON TABLE transactions TO PUBLIC;
5050 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5053 REVOKE ALL ON TABLE users FROM PUBLIC;
5054 REVOKE ALL ON TABLE users FROM wbadm;
5055 GRANT ALL ON TABLE users TO wbadm;
5056 GRANT SELECT ON TABLE users TO PUBLIC;
5059 SET search_path = public, pg_catalog;
5062 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5065 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5066 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5067 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5068 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5072 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5075 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5076 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5077 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5078 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5082 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5085 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5086 REVOKE ALL ON TABLE lastlog FROM wbadm;
5087 GRANT ALL ON TABLE lastlog TO wbadm;
5088 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5092 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5095 REVOKE ALL ON TABLE log FROM PUBLIC;
5096 REVOKE ALL ON TABLE log FROM wbadm;
5097 GRANT ALL ON TABLE log TO wbadm;
5098 GRANT SELECT ON TABLE log TO PUBLIC;
5102 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5105 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5106 REVOKE ALL ON TABLE packages_all FROM wbadm;
5107 GRANT ALL ON TABLE packages_all TO wbadm;
5108 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5112 -- Name: packages_public; Type: ACL; Schema: public; Owner: wbadm
5115 REVOKE ALL ON TABLE packages_public FROM PUBLIC;
5116 REVOKE ALL ON TABLE packages_public FROM wbadm;
5117 GRANT ALL ON TABLE packages_public TO wbadm;
5118 GRANT SELECT ON TABLE packages_public TO PUBLIC;
5121 SET search_path = s390, pg_catalog;
5124 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5127 REVOKE ALL ON TABLE packages FROM PUBLIC;
5128 REVOKE ALL ON TABLE packages FROM wbadm;
5129 GRANT ALL ON TABLE packages TO wbadm;
5130 GRANT SELECT ON TABLE packages TO wb_security;
5131 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5135 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5138 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5139 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5140 GRANT ALL ON TABLE pkg_history TO wbadm;
5141 GRANT SELECT ON TABLE pkg_history TO wb_security;
5142 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5146 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5149 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5150 REVOKE ALL ON TABLE transactions FROM wbadm;
5151 GRANT ALL ON TABLE transactions TO wbadm;
5152 GRANT SELECT ON TABLE transactions TO wb_security;
5153 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5157 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5160 REVOKE ALL ON TABLE users FROM PUBLIC;
5161 REVOKE ALL ON TABLE users FROM wbadm;
5162 GRANT ALL ON TABLE users TO wbadm;
5163 GRANT SELECT ON TABLE users TO wb_security;
5164 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5167 SET search_path = s390_public, pg_catalog;
5170 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5173 REVOKE ALL ON TABLE packages FROM PUBLIC;
5174 REVOKE ALL ON TABLE packages FROM wbadm;
5175 GRANT ALL ON TABLE packages TO wbadm;
5176 GRANT SELECT ON TABLE packages TO PUBLIC;
5180 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5183 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5184 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5185 GRANT ALL ON TABLE pkg_history TO wbadm;
5186 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5190 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5193 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5194 REVOKE ALL ON TABLE transactions FROM wbadm;
5195 GRANT ALL ON TABLE transactions TO wbadm;
5196 GRANT SELECT ON TABLE transactions TO PUBLIC;
5200 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5203 REVOKE ALL ON TABLE users FROM PUBLIC;
5204 REVOKE ALL ON TABLE users FROM wbadm;
5205 GRANT ALL ON TABLE users TO wbadm;
5206 GRANT SELECT ON TABLE users TO PUBLIC;
5209 SET search_path = sparc, pg_catalog;
5212 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5215 REVOKE ALL ON TABLE packages FROM PUBLIC;
5216 REVOKE ALL ON TABLE packages FROM wbadm;
5217 GRANT ALL ON TABLE packages TO wbadm;
5218 GRANT SELECT ON TABLE packages TO wb_security;
5219 GRANT SELECT,INSERT,UPDATE ON TABLE packages TO wb_all;
5223 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5226 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5227 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5228 GRANT ALL ON TABLE pkg_history TO wbadm;
5229 GRANT SELECT ON TABLE pkg_history TO wb_security;
5230 GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all;
5234 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5237 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5238 REVOKE ALL ON TABLE transactions FROM wbadm;
5239 GRANT ALL ON TABLE transactions TO wbadm;
5240 GRANT SELECT ON TABLE transactions TO wb_security;
5241 GRANT SELECT,INSERT ON TABLE transactions TO wb_all;
5245 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5248 REVOKE ALL ON TABLE users FROM PUBLIC;
5249 REVOKE ALL ON TABLE users FROM wbadm;
5250 GRANT ALL ON TABLE users TO wbadm;
5251 GRANT SELECT ON TABLE users TO wb_security;
5252 GRANT SELECT,INSERT,UPDATE ON TABLE users TO wb_all;
5255 SET search_path = sparc_public, pg_catalog;
5258 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5261 REVOKE ALL ON TABLE packages FROM PUBLIC;
5262 REVOKE ALL ON TABLE packages FROM wbadm;
5263 GRANT ALL ON TABLE packages TO wbadm;
5264 GRANT SELECT ON TABLE packages TO PUBLIC;
5268 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5271 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5272 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5273 GRANT ALL ON TABLE pkg_history TO wbadm;
5274 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5278 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5281 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5282 REVOKE ALL ON TABLE transactions FROM wbadm;
5283 GRANT ALL ON TABLE transactions TO wbadm;
5284 GRANT SELECT ON TABLE transactions TO PUBLIC;
5288 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5291 REVOKE ALL ON TABLE users FROM PUBLIC;
5292 REVOKE ALL ON TABLE users FROM wbadm;
5293 GRANT ALL ON TABLE users TO wbadm;
5294 GRANT SELECT ON TABLE users TO PUBLIC;
5298 -- PostgreSQL database dump complete