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
568 SELECT 'alpha'::character varying AS arch, * INTO temp_row FROM "alpha_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
570 RETURN NEXT temp_row;
572 SELECT 'amd64'::character varying AS arch, * INTO temp_row FROM "amd64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
574 RETURN NEXT temp_row;
576 SELECT 'arm'::character varying AS arch, * INTO temp_row FROM "arm_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
578 RETURN NEXT temp_row;
580 SELECT 'armel'::character varying AS arch, * INTO temp_row FROM "armel_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
582 RETURN NEXT temp_row;
584 SELECT 'hppa'::character varying AS arch, * INTO temp_row FROM "hppa_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
586 RETURN NEXT temp_row;
588 SELECT 'hurd-i386'::character varying AS arch, * INTO temp_row FROM "hurd-i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
590 RETURN NEXT temp_row;
592 SELECT 'i386'::character varying AS arch, * INTO temp_row FROM "i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
594 RETURN NEXT temp_row;
596 SELECT 'ia64'::character varying AS arch, * INTO temp_row FROM "ia64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
598 RETURN NEXT temp_row;
600 SELECT 'kfreebsd-amd64'::character varying AS arch, * INTO temp_row FROM "kfreebsd-amd64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
602 RETURN NEXT temp_row;
604 SELECT 'freebsd-i386'::character varying AS arch, * INTO temp_row FROM "kfreebsd-i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
606 RETURN NEXT temp_row;
608 SELECT 'mips'::character varying AS arch, * INTO temp_row FROM "mips_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
610 RETURN NEXT temp_row;
612 SELECT 'mipsel'::character varying AS arch, * INTO temp_row FROM "mipsel_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
614 RETURN NEXT temp_row;
616 SELECT 'powerpc'::character varying AS arch, * INTO temp_row FROM "powerpc_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
618 RETURN NEXT temp_row;
620 SELECT 's390'::character varying AS arch, * INTO temp_row FROM "s390_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
622 RETURN NEXT temp_row;
624 SELECT 'sparc'::character varying AS arch, * INTO temp_row FROM "sparc_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
626 RETURN NEXT temp_row;
632 ALTER FUNCTION public.query_source_package(param_dist character varying, param_srcpkg character varying) OWNER TO wbadm;
635 -- Name: spacecat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
638 CREATE FUNCTION spacecat(acc text, instr text) RETURNS text
642 IF acc IS NULL OR acc = '' THEN
645 RETURN acc || ' ' || instr;
651 ALTER FUNCTION public.spacecat(acc text, instr text) OWNER TO pkern;
654 -- Name: commacat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
657 CREATE AGGREGATE commacat_all(text) (
664 ALTER AGGREGATE public.commacat_all(text) OWNER TO pkern;
667 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
671 PROCEDURE = debversion_gt,
672 LEFTARG = debversion,
673 RIGHTARG = debversion,
679 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
682 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
685 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
689 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
692 CREATE AGGREGATE max(debversion) (
693 SFUNC = debversion_larger,
699 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
702 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
706 PROCEDURE = debversion_lt,
707 LEFTARG = debversion,
708 RIGHTARG = debversion,
714 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
717 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
720 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
724 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
727 CREATE AGGREGATE min(debversion) (
728 SFUNC = debversion_smaller,
734 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
737 -- Name: spacecat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
740 CREATE AGGREGATE spacecat_all(text) (
747 ALTER AGGREGATE public.spacecat_all(text) OWNER TO pkern;
750 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
754 PROCEDURE = debversion_le,
755 LEFTARG = debversion,
756 RIGHTARG = debversion,
762 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
765 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
768 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
772 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
776 PROCEDURE = debversion_ne,
777 LEFTARG = debversion,
778 RIGHTARG = debversion,
784 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
787 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
790 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
794 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
798 PROCEDURE = debversion_eq,
799 LEFTARG = debversion,
800 RIGHTARG = debversion,
806 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
809 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
812 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
816 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
820 PROCEDURE = debversion_ge,
821 LEFTARG = debversion,
822 RIGHTARG = debversion,
828 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
831 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
834 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
838 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
841 CREATE OPERATOR CLASS debversion_ops
842 DEFAULT FOR TYPE debversion USING btree AS
843 OPERATOR 1 <(debversion,debversion) ,
844 OPERATOR 2 <=(debversion,debversion) ,
845 OPERATOR 3 =(debversion,debversion) ,
846 OPERATOR 4 >=(debversion,debversion) ,
847 OPERATOR 5 >(debversion,debversion) ,
848 FUNCTION 1 debversion_cmp(debversion,debversion);
851 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
854 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
857 CREATE OPERATOR CLASS debversion_ops
858 DEFAULT FOR TYPE debversion USING hash AS
859 OPERATOR 1 =(debversion,debversion) ,
860 FUNCTION 1 debversion_hash(debversion);
863 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
865 SET search_path = pg_catalog;
868 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
871 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
875 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
878 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
882 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
885 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
889 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
892 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
896 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
899 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
903 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
906 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
909 SET search_path = alpha, pg_catalog;
911 SET default_tablespace = '';
913 SET default_with_oids = false;
916 -- Name: packages; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
919 CREATE TABLE packages (
920 package character varying NOT NULL,
921 distribution character varying NOT NULL,
922 version character varying,
923 state character varying,
924 section character varying,
925 priority character varying,
926 installed_version character varying,
927 previous_state character varying,
928 state_change timestamp without time zone,
929 notes character varying,
930 builder character varying,
933 binary_nmu_version integer,
934 binary_nmu_changelog character varying,
935 failed_category character varying,
936 permbuildpri integer,
938 depends character varying,
939 rel character varying,
941 extra_depends character varying,
942 extra_conflicts character varying,
943 build_arch_all boolean DEFAULT false NOT NULL
947 ALTER TABLE alpha.packages OWNER TO wbadm;
950 -- Name: pkg_history; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
953 CREATE TABLE pkg_history (
954 package character varying NOT NULL,
955 distribution character varying NOT NULL,
956 version character varying NOT NULL,
957 "timestamp" timestamp without time zone NOT NULL,
958 result character varying NOT NULL,
961 builder character varying
965 ALTER TABLE alpha.pkg_history OWNER TO wbadm;
968 -- Name: transactions; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
971 CREATE TABLE transactions (
972 package character varying,
973 distribution character varying,
974 version character varying,
975 action character varying,
976 prevstate character varying,
977 state character varying,
978 real_user character varying,
979 set_user character varying,
980 "time" timestamp without time zone
984 ALTER TABLE alpha.transactions OWNER TO wbadm;
987 -- Name: users; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
991 username character varying NOT NULL,
992 distribution character varying NOT NULL,
993 last_seen timestamp without time zone
997 ALTER TABLE alpha.users OWNER TO wbadm;
999 SET search_path = alpha_public, pg_catalog;
1002 -- Name: packages; Type: VIEW; Schema: alpha_public; Owner: wbadm
1005 CREATE VIEW packages AS
1006 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 alpha.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1009 ALTER TABLE alpha_public.packages OWNER TO wbadm;
1012 -- Name: pkg_history; Type: VIEW; Schema: alpha_public; Owner: wbadm
1015 CREATE VIEW pkg_history AS
1016 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 alpha.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1019 ALTER TABLE alpha_public.pkg_history OWNER TO wbadm;
1022 -- Name: transactions; Type: VIEW; Schema: alpha_public; Owner: wbadm
1025 CREATE VIEW transactions AS
1026 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM alpha.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1029 ALTER TABLE alpha_public.transactions OWNER TO wbadm;
1032 -- Name: users; Type: VIEW; Schema: alpha_public; Owner: wbadm
1035 CREATE VIEW users AS
1036 SELECT users.username, users.distribution, users.last_seen FROM alpha.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1039 ALTER TABLE alpha_public.users OWNER TO wbadm;
1041 SET search_path = amd64, pg_catalog;
1044 -- Name: packages; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1047 CREATE TABLE packages (
1048 package character varying NOT NULL,
1049 distribution character varying NOT NULL,
1050 version character varying,
1051 state character varying,
1052 section character varying,
1053 priority character varying,
1054 installed_version character varying,
1055 previous_state character varying,
1056 state_change timestamp without time zone,
1057 notes character varying,
1058 builder character varying,
1061 binary_nmu_version integer,
1062 binary_nmu_changelog character varying,
1063 failed_category character varying,
1064 permbuildpri integer,
1066 depends character varying,
1067 rel character varying,
1069 extra_depends character varying,
1070 extra_conflicts character varying,
1071 build_arch_all boolean DEFAULT false NOT NULL
1075 ALTER TABLE amd64.packages OWNER TO wbadm;
1078 -- Name: pkg_history; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1081 CREATE TABLE pkg_history (
1082 package character varying NOT NULL,
1083 distribution character varying NOT NULL,
1084 version character varying NOT NULL,
1085 "timestamp" timestamp without time zone NOT NULL,
1086 result character varying NOT NULL,
1089 builder character varying
1093 ALTER TABLE amd64.pkg_history OWNER TO wbadm;
1096 -- Name: transactions; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1099 CREATE TABLE transactions (
1100 package character varying,
1101 distribution character varying,
1102 version character varying,
1103 action character varying,
1104 prevstate character varying,
1105 state character varying,
1106 real_user character varying,
1107 set_user character varying,
1108 "time" timestamp without time zone
1112 ALTER TABLE amd64.transactions OWNER TO wbadm;
1115 -- Name: users; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1118 CREATE TABLE users (
1119 username character varying NOT NULL,
1120 distribution character varying NOT NULL,
1121 last_seen timestamp without time zone
1125 ALTER TABLE amd64.users OWNER TO wbadm;
1127 SET search_path = amd64_public, pg_catalog;
1130 -- Name: packages; Type: VIEW; Schema: amd64_public; Owner: wbadm
1133 CREATE VIEW packages AS
1134 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 amd64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1137 ALTER TABLE amd64_public.packages OWNER TO wbadm;
1140 -- Name: pkg_history; Type: VIEW; Schema: amd64_public; Owner: wbadm
1143 CREATE VIEW pkg_history AS
1144 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 amd64.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1147 ALTER TABLE amd64_public.pkg_history OWNER TO wbadm;
1150 -- Name: transactions; Type: VIEW; Schema: amd64_public; Owner: wbadm
1153 CREATE VIEW transactions AS
1154 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM amd64.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1157 ALTER TABLE amd64_public.transactions OWNER TO wbadm;
1160 -- Name: users; Type: VIEW; Schema: amd64_public; Owner: wbadm
1163 CREATE VIEW users AS
1164 SELECT users.username, users.distribution, users.last_seen FROM amd64.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1167 ALTER TABLE amd64_public.users OWNER TO wbadm;
1169 SET search_path = arm, pg_catalog;
1172 -- Name: packages; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1175 CREATE TABLE packages (
1176 package character varying NOT NULL,
1177 distribution character varying NOT NULL,
1178 version character varying,
1179 state character varying,
1180 section character varying,
1181 priority character varying,
1182 installed_version character varying,
1183 previous_state character varying,
1184 state_change timestamp without time zone,
1185 notes character varying,
1186 builder character varying,
1189 binary_nmu_version integer,
1190 binary_nmu_changelog character varying,
1191 failed_category character varying,
1192 permbuildpri integer,
1194 depends character varying,
1195 rel character varying,
1197 extra_depends character varying,
1198 extra_conflicts character varying,
1199 build_arch_all boolean DEFAULT false NOT NULL
1203 ALTER TABLE arm.packages OWNER TO wbadm;
1206 -- Name: pkg_history; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1209 CREATE TABLE pkg_history (
1210 package character varying NOT NULL,
1211 distribution character varying NOT NULL,
1212 version character varying NOT NULL,
1213 "timestamp" timestamp without time zone NOT NULL,
1214 result character varying NOT NULL,
1217 builder character varying
1221 ALTER TABLE arm.pkg_history OWNER TO wbadm;
1224 -- Name: transactions; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1227 CREATE TABLE transactions (
1228 package character varying,
1229 distribution character varying,
1230 version character varying,
1231 action character varying,
1232 prevstate character varying,
1233 state character varying,
1234 real_user character varying,
1235 set_user character varying,
1236 "time" timestamp without time zone
1240 ALTER TABLE arm.transactions OWNER TO wbadm;
1243 -- Name: users; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1246 CREATE TABLE users (
1247 username character varying NOT NULL,
1248 distribution character varying NOT NULL,
1249 last_seen timestamp without time zone
1253 ALTER TABLE arm.users OWNER TO wbadm;
1255 SET search_path = arm_public, pg_catalog;
1258 -- Name: packages; Type: VIEW; Schema: arm_public; Owner: wbadm
1261 CREATE VIEW packages AS
1262 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 arm.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1265 ALTER TABLE arm_public.packages OWNER TO wbadm;
1268 -- Name: pkg_history; Type: VIEW; Schema: arm_public; Owner: wbadm
1271 CREATE VIEW pkg_history AS
1272 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 arm.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1275 ALTER TABLE arm_public.pkg_history OWNER TO wbadm;
1278 -- Name: transactions; Type: VIEW; Schema: arm_public; Owner: wbadm
1281 CREATE VIEW transactions AS
1282 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM arm.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1285 ALTER TABLE arm_public.transactions OWNER TO wbadm;
1288 -- Name: users; Type: VIEW; Schema: arm_public; Owner: wbadm
1291 CREATE VIEW users AS
1292 SELECT users.username, users.distribution, users.last_seen FROM arm.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1295 ALTER TABLE arm_public.users OWNER TO wbadm;
1297 SET search_path = armel, pg_catalog;
1300 -- Name: packages; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1303 CREATE TABLE packages (
1304 package character varying NOT NULL,
1305 distribution character varying NOT NULL,
1306 version character varying,
1307 state character varying,
1308 section character varying,
1309 priority character varying,
1310 installed_version character varying,
1311 previous_state character varying,
1312 state_change timestamp without time zone,
1313 notes character varying,
1314 builder character varying,
1317 binary_nmu_version integer,
1318 binary_nmu_changelog character varying,
1319 failed_category character varying,
1320 permbuildpri integer,
1322 depends character varying,
1323 rel character varying,
1325 extra_depends character varying,
1326 extra_conflicts character varying,
1327 build_arch_all boolean DEFAULT false NOT NULL
1331 ALTER TABLE armel.packages OWNER TO wbadm;
1334 -- Name: pkg_history; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1337 CREATE TABLE pkg_history (
1338 package character varying NOT NULL,
1339 distribution character varying NOT NULL,
1340 version character varying NOT NULL,
1341 "timestamp" timestamp without time zone NOT NULL,
1342 result character varying NOT NULL,
1345 builder character varying
1349 ALTER TABLE armel.pkg_history OWNER TO wbadm;
1352 -- Name: transactions; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1355 CREATE TABLE transactions (
1356 package character varying,
1357 distribution character varying,
1358 version character varying,
1359 action character varying,
1360 prevstate character varying,
1361 state character varying,
1362 real_user character varying,
1363 set_user character varying,
1364 "time" timestamp without time zone
1368 ALTER TABLE armel.transactions OWNER TO wbadm;
1371 -- Name: users; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1374 CREATE TABLE users (
1375 username character varying NOT NULL,
1376 distribution character varying NOT NULL,
1377 last_seen timestamp without time zone
1381 ALTER TABLE armel.users OWNER TO wbadm;
1383 SET search_path = armel_public, pg_catalog;
1386 -- Name: packages; Type: VIEW; Schema: armel_public; Owner: wbadm
1389 CREATE VIEW packages AS
1390 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 armel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1393 ALTER TABLE armel_public.packages OWNER TO wbadm;
1396 -- Name: pkg_history; Type: VIEW; Schema: armel_public; Owner: wbadm
1399 CREATE VIEW pkg_history AS
1400 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 armel.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1403 ALTER TABLE armel_public.pkg_history OWNER TO wbadm;
1406 -- Name: transactions; Type: VIEW; Schema: armel_public; Owner: wbadm
1409 CREATE VIEW transactions AS
1410 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM armel.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1413 ALTER TABLE armel_public.transactions OWNER TO wbadm;
1416 -- Name: users; Type: VIEW; Schema: armel_public; Owner: wbadm
1419 CREATE VIEW users AS
1420 SELECT users.username, users.distribution, users.last_seen FROM armel.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1423 ALTER TABLE armel_public.users OWNER TO wbadm;
1425 SET search_path = hppa, pg_catalog;
1428 -- Name: packages; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1431 CREATE TABLE packages (
1432 package character varying NOT NULL,
1433 distribution character varying NOT NULL,
1434 version character varying,
1435 state character varying,
1436 section character varying,
1437 priority character varying,
1438 installed_version character varying,
1439 previous_state character varying,
1440 state_change timestamp without time zone,
1441 notes character varying,
1442 builder character varying,
1445 binary_nmu_version integer,
1446 binary_nmu_changelog character varying,
1447 failed_category character varying,
1448 permbuildpri integer,
1450 depends character varying,
1451 rel character varying,
1453 extra_depends character varying,
1454 extra_conflicts character varying,
1455 build_arch_all boolean DEFAULT false NOT NULL
1459 ALTER TABLE hppa.packages OWNER TO wbadm;
1462 -- Name: pkg_history; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1465 CREATE TABLE pkg_history (
1466 package character varying NOT NULL,
1467 distribution character varying NOT NULL,
1468 version character varying NOT NULL,
1469 "timestamp" timestamp without time zone NOT NULL,
1470 result character varying NOT NULL,
1473 builder character varying
1477 ALTER TABLE hppa.pkg_history OWNER TO wbadm;
1480 -- Name: transactions; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1483 CREATE TABLE transactions (
1484 package character varying,
1485 distribution character varying,
1486 version character varying,
1487 action character varying,
1488 prevstate character varying,
1489 state character varying,
1490 real_user character varying,
1491 set_user character varying,
1492 "time" timestamp without time zone
1496 ALTER TABLE hppa.transactions OWNER TO wbadm;
1499 -- Name: users; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1502 CREATE TABLE users (
1503 username character varying NOT NULL,
1504 distribution character varying NOT NULL,
1505 last_seen timestamp without time zone
1509 ALTER TABLE hppa.users OWNER TO wbadm;
1511 SET search_path = hppa_public, pg_catalog;
1514 -- Name: packages; Type: VIEW; Schema: hppa_public; Owner: wbadm
1517 CREATE VIEW packages AS
1518 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 hppa.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1521 ALTER TABLE hppa_public.packages OWNER TO wbadm;
1524 -- Name: pkg_history; Type: VIEW; Schema: hppa_public; Owner: wbadm
1527 CREATE VIEW pkg_history AS
1528 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 hppa.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1531 ALTER TABLE hppa_public.pkg_history OWNER TO wbadm;
1534 -- Name: transactions; Type: VIEW; Schema: hppa_public; Owner: wbadm
1537 CREATE VIEW transactions AS
1538 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM hppa.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1541 ALTER TABLE hppa_public.transactions OWNER TO wbadm;
1544 -- Name: users; Type: VIEW; Schema: hppa_public; Owner: wbadm
1547 CREATE VIEW users AS
1548 SELECT users.username, users.distribution, users.last_seen FROM hppa.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1551 ALTER TABLE hppa_public.users OWNER TO wbadm;
1553 SET search_path = "hurd-i386", pg_catalog;
1556 -- Name: packages; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1559 CREATE TABLE packages (
1560 package character varying NOT NULL,
1561 distribution character varying NOT NULL,
1562 version character varying,
1563 state character varying,
1564 section character varying,
1565 priority character varying,
1566 installed_version character varying,
1567 previous_state character varying,
1568 state_change timestamp without time zone,
1569 notes character varying,
1570 builder character varying,
1573 binary_nmu_version integer,
1574 binary_nmu_changelog character varying,
1575 failed_category character varying,
1576 permbuildpri integer,
1578 depends character varying,
1579 rel character varying,
1581 extra_depends character varying,
1582 extra_conflicts character varying,
1583 build_arch_all boolean DEFAULT false NOT NULL
1587 ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
1590 -- Name: pkg_history; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1593 CREATE TABLE pkg_history (
1594 package character varying NOT NULL,
1595 distribution character varying NOT NULL,
1596 version character varying NOT NULL,
1597 "timestamp" timestamp without time zone NOT NULL,
1598 result character varying NOT NULL,
1601 builder character varying
1605 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
1608 -- Name: transactions; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1611 CREATE TABLE transactions (
1612 package character varying,
1613 distribution character varying,
1614 version character varying,
1615 action character varying,
1616 prevstate character varying,
1617 state character varying,
1618 real_user character varying,
1619 set_user character varying,
1620 "time" timestamp without time zone
1624 ALTER TABLE "hurd-i386".transactions OWNER TO wbadm;
1627 -- Name: users; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1630 CREATE TABLE users (
1631 username character varying NOT NULL,
1632 distribution character varying NOT NULL,
1633 last_seen timestamp without time zone
1637 ALTER TABLE "hurd-i386".users OWNER TO wbadm;
1639 SET search_path = "hurd-i386_public", pg_catalog;
1642 -- Name: packages; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1645 CREATE VIEW packages AS
1646 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM "hurd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1649 ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
1652 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1655 CREATE VIEW pkg_history AS
1656 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM "hurd-i386".pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1659 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
1662 -- Name: transactions; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1665 CREATE VIEW transactions AS
1666 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM "hurd-i386".transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1669 ALTER TABLE "hurd-i386_public".transactions OWNER TO wbadm;
1672 -- Name: users; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1675 CREATE VIEW users AS
1676 SELECT users.username, users.distribution, users.last_seen FROM "hurd-i386".users WHERE ((users.distribution)::text !~~ '%-security'::text);
1679 ALTER TABLE "hurd-i386_public".users OWNER TO wbadm;
1681 SET search_path = i386, pg_catalog;
1684 -- Name: packages; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1687 CREATE TABLE packages (
1688 package character varying NOT NULL,
1689 distribution character varying NOT NULL,
1690 version character varying,
1691 state character varying,
1692 section character varying,
1693 priority character varying,
1694 installed_version character varying,
1695 previous_state character varying,
1696 state_change timestamp without time zone,
1697 notes character varying,
1698 builder character varying,
1701 binary_nmu_version integer,
1702 binary_nmu_changelog character varying,
1703 failed_category character varying,
1704 permbuildpri integer,
1706 depends character varying,
1707 rel character varying,
1709 extra_depends character varying,
1710 extra_conflicts character varying,
1711 build_arch_all boolean DEFAULT false NOT NULL
1715 ALTER TABLE i386.packages OWNER TO wbadm;
1718 -- Name: pkg_history; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1721 CREATE TABLE pkg_history (
1722 package character varying NOT NULL,
1723 distribution character varying NOT NULL,
1724 version character varying NOT NULL,
1725 "timestamp" timestamp without time zone NOT NULL,
1726 result character varying NOT NULL,
1729 builder character varying
1733 ALTER TABLE i386.pkg_history OWNER TO wbadm;
1736 -- Name: transactions; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1739 CREATE TABLE transactions (
1740 package character varying,
1741 distribution character varying,
1742 version character varying,
1743 action character varying,
1744 prevstate character varying,
1745 state character varying,
1746 real_user character varying,
1747 set_user character varying,
1748 "time" timestamp without time zone
1752 ALTER TABLE i386.transactions OWNER TO wbadm;
1755 -- Name: users; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1758 CREATE TABLE users (
1759 username character varying NOT NULL,
1760 distribution character varying NOT NULL,
1761 last_seen timestamp without time zone
1765 ALTER TABLE i386.users OWNER TO wbadm;
1767 SET search_path = i386_public, pg_catalog;
1770 -- Name: packages; Type: VIEW; Schema: i386_public; Owner: wbadm
1773 CREATE VIEW packages AS
1774 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 i386.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1777 ALTER TABLE i386_public.packages OWNER TO wbadm;
1780 -- Name: pkg_history; Type: VIEW; Schema: i386_public; Owner: wbadm
1783 CREATE VIEW pkg_history AS
1784 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 i386.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1787 ALTER TABLE i386_public.pkg_history OWNER TO wbadm;
1790 -- Name: transactions; Type: VIEW; Schema: i386_public; Owner: wbadm
1793 CREATE VIEW transactions AS
1794 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM i386.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1797 ALTER TABLE i386_public.transactions OWNER TO wbadm;
1800 -- Name: users; Type: VIEW; Schema: i386_public; Owner: wbadm
1803 CREATE VIEW users AS
1804 SELECT users.username, users.distribution, users.last_seen FROM i386.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1807 ALTER TABLE i386_public.users OWNER TO wbadm;
1809 SET search_path = ia64, pg_catalog;
1812 -- Name: packages; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1815 CREATE TABLE packages (
1816 package character varying NOT NULL,
1817 distribution character varying NOT NULL,
1818 version character varying,
1819 state character varying,
1820 section character varying,
1821 priority character varying,
1822 installed_version character varying,
1823 previous_state character varying,
1824 state_change timestamp without time zone,
1825 notes character varying,
1826 builder character varying,
1829 binary_nmu_version integer,
1830 binary_nmu_changelog character varying,
1831 failed_category character varying,
1832 permbuildpri integer,
1834 depends character varying,
1835 rel character varying,
1837 extra_depends character varying,
1838 extra_conflicts character varying,
1839 build_arch_all boolean DEFAULT false NOT NULL
1843 ALTER TABLE ia64.packages OWNER TO wbadm;
1846 -- Name: pkg_history; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1849 CREATE TABLE pkg_history (
1850 package character varying NOT NULL,
1851 distribution character varying NOT NULL,
1852 version character varying NOT NULL,
1853 "timestamp" timestamp without time zone NOT NULL,
1854 result character varying NOT NULL,
1857 builder character varying
1861 ALTER TABLE ia64.pkg_history OWNER TO wbadm;
1864 -- Name: transactions; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1867 CREATE TABLE transactions (
1868 package character varying,
1869 distribution character varying,
1870 version character varying,
1871 action character varying,
1872 prevstate character varying,
1873 state character varying,
1874 real_user character varying,
1875 set_user character varying,
1876 "time" timestamp without time zone
1880 ALTER TABLE ia64.transactions OWNER TO wbadm;
1883 -- Name: users; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1886 CREATE TABLE users (
1887 username character varying NOT NULL,
1888 distribution character varying NOT NULL,
1889 last_seen timestamp without time zone
1893 ALTER TABLE ia64.users OWNER TO wbadm;
1895 SET search_path = ia64_public, pg_catalog;
1898 -- Name: packages; Type: VIEW; Schema: ia64_public; Owner: wbadm
1901 CREATE VIEW packages AS
1902 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 ia64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1905 ALTER TABLE ia64_public.packages OWNER TO wbadm;
1908 -- Name: pkg_history; Type: VIEW; Schema: ia64_public; Owner: wbadm
1911 CREATE VIEW pkg_history AS
1912 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 ia64.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1915 ALTER TABLE ia64_public.pkg_history OWNER TO wbadm;
1918 -- Name: transactions; Type: VIEW; Schema: ia64_public; Owner: wbadm
1921 CREATE VIEW transactions AS
1922 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM ia64.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1925 ALTER TABLE ia64_public.transactions OWNER TO wbadm;
1928 -- Name: users; Type: VIEW; Schema: ia64_public; Owner: wbadm
1931 CREATE VIEW users AS
1932 SELECT users.username, users.distribution, users.last_seen FROM ia64.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1935 ALTER TABLE ia64_public.users OWNER TO wbadm;
1937 SET search_path = "kfreebsd-amd64", pg_catalog;
1940 -- Name: packages; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1943 CREATE TABLE packages (
1944 package character varying NOT NULL,
1945 distribution character varying NOT NULL,
1946 version character varying,
1947 state character varying,
1948 section character varying,
1949 priority character varying,
1950 installed_version character varying,
1951 previous_state character varying,
1952 state_change timestamp without time zone,
1953 notes character varying,
1954 builder character varying,
1957 binary_nmu_version integer,
1958 binary_nmu_changelog character varying,
1959 failed_category character varying,
1960 permbuildpri integer,
1962 depends character varying,
1963 rel character varying,
1965 extra_depends character varying,
1966 extra_conflicts character varying,
1967 build_arch_all boolean DEFAULT false NOT NULL
1971 ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
1974 -- Name: pkg_history; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1977 CREATE TABLE pkg_history (
1978 package character varying NOT NULL,
1979 distribution character varying NOT NULL,
1980 version character varying NOT NULL,
1981 "timestamp" timestamp without time zone NOT NULL,
1982 result character varying NOT NULL,
1985 builder character varying
1989 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
1992 -- Name: transactions; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1995 CREATE TABLE transactions (
1996 package character varying,
1997 distribution character varying,
1998 version character varying,
1999 action character varying,
2000 prevstate character varying,
2001 state character varying,
2002 real_user character varying,
2003 set_user character varying,
2004 "time" timestamp without time zone
2008 ALTER TABLE "kfreebsd-amd64".transactions OWNER TO wbadm;
2011 -- Name: users; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
2014 CREATE TABLE users (
2015 username character varying NOT NULL,
2016 distribution character varying NOT NULL,
2017 last_seen timestamp without time zone
2021 ALTER TABLE "kfreebsd-amd64".users OWNER TO wbadm;
2023 SET search_path = "kfreebsd-amd64_public", pg_catalog;
2026 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64_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 "kfreebsd-amd64".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2033 ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
2036 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64_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 "kfreebsd-amd64".pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2043 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
2046 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64_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 "kfreebsd-amd64".transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2053 ALTER TABLE "kfreebsd-amd64_public".transactions OWNER TO wbadm;
2056 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2059 CREATE VIEW users AS
2060 SELECT users.username, users.distribution, users.last_seen FROM "kfreebsd-amd64".users WHERE ((users.distribution)::text !~~ '%-security'::text);
2063 ALTER TABLE "kfreebsd-amd64_public".users OWNER TO wbadm;
2065 SET search_path = "kfreebsd-i386", pg_catalog;
2068 -- Name: packages; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2071 CREATE TABLE packages (
2072 package character varying NOT NULL,
2073 distribution character varying NOT NULL,
2074 version character varying,
2075 state character varying,
2076 section character varying,
2077 priority character varying,
2078 installed_version character varying,
2079 previous_state character varying,
2080 state_change timestamp without time zone,
2081 notes character varying,
2082 builder character varying,
2085 binary_nmu_version integer,
2086 binary_nmu_changelog character varying,
2087 failed_category character varying,
2088 permbuildpri integer,
2090 depends character varying,
2091 rel character varying,
2093 extra_depends character varying,
2094 extra_conflicts character varying,
2095 build_arch_all boolean DEFAULT false NOT NULL
2099 ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
2102 -- Name: pkg_history; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2105 CREATE TABLE pkg_history (
2106 package character varying NOT NULL,
2107 distribution character varying NOT NULL,
2108 version character varying NOT NULL,
2109 "timestamp" timestamp without time zone NOT NULL,
2110 result character varying NOT NULL,
2113 builder character varying
2117 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
2120 -- Name: transactions; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2123 CREATE TABLE transactions (
2124 package character varying,
2125 distribution character varying,
2126 version character varying,
2127 action character varying,
2128 prevstate character varying,
2129 state character varying,
2130 real_user character varying,
2131 set_user character varying,
2132 "time" timestamp without time zone
2136 ALTER TABLE "kfreebsd-i386".transactions OWNER TO wbadm;
2139 -- Name: users; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2142 CREATE TABLE users (
2143 username character varying NOT NULL,
2144 distribution character varying NOT NULL,
2145 last_seen timestamp without time zone
2149 ALTER TABLE "kfreebsd-i386".users OWNER TO wbadm;
2151 SET search_path = "kfreebsd-i386_public", pg_catalog;
2154 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2157 CREATE VIEW packages AS
2158 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 "kfreebsd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2161 ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
2164 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2167 CREATE VIEW pkg_history AS
2168 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 "kfreebsd-i386".pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2171 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
2174 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2177 CREATE VIEW transactions AS
2178 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM "kfreebsd-i386".transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2181 ALTER TABLE "kfreebsd-i386_public".transactions OWNER TO wbadm;
2184 -- Name: users; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2187 CREATE VIEW users AS
2188 SELECT users.username, users.distribution, users.last_seen FROM "kfreebsd-i386".users WHERE ((users.distribution)::text !~~ '%-security'::text);
2191 ALTER TABLE "kfreebsd-i386_public".users OWNER TO wbadm;
2193 SET search_path = mips, pg_catalog;
2196 -- Name: packages; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2199 CREATE TABLE packages (
2200 package character varying NOT NULL,
2201 distribution character varying NOT NULL,
2202 version character varying,
2203 state character varying,
2204 section character varying,
2205 priority character varying,
2206 installed_version character varying,
2207 previous_state character varying,
2208 state_change timestamp without time zone,
2209 notes character varying,
2210 builder character varying,
2213 binary_nmu_version integer,
2214 binary_nmu_changelog character varying,
2215 failed_category character varying,
2216 permbuildpri integer,
2218 depends character varying,
2219 rel character varying,
2221 extra_depends character varying,
2222 extra_conflicts character varying,
2223 build_arch_all boolean DEFAULT false NOT NULL
2227 ALTER TABLE mips.packages OWNER TO wbadm;
2230 -- Name: pkg_history; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2233 CREATE TABLE pkg_history (
2234 package character varying NOT NULL,
2235 distribution character varying NOT NULL,
2236 version character varying NOT NULL,
2237 "timestamp" timestamp without time zone NOT NULL,
2238 result character varying NOT NULL,
2241 builder character varying
2245 ALTER TABLE mips.pkg_history OWNER TO wbadm;
2248 -- Name: transactions; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2251 CREATE TABLE transactions (
2252 package character varying,
2253 distribution character varying,
2254 version character varying,
2255 action character varying,
2256 prevstate character varying,
2257 state character varying,
2258 real_user character varying,
2259 set_user character varying,
2260 "time" timestamp without time zone
2264 ALTER TABLE mips.transactions OWNER TO wbadm;
2267 -- Name: users; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2270 CREATE TABLE users (
2271 username character varying NOT NULL,
2272 distribution character varying NOT NULL,
2273 last_seen timestamp without time zone
2277 ALTER TABLE mips.users OWNER TO wbadm;
2279 SET search_path = mips_public, pg_catalog;
2282 -- Name: packages; Type: VIEW; Schema: mips_public; Owner: wbadm
2285 CREATE VIEW packages AS
2286 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 mips.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2289 ALTER TABLE mips_public.packages OWNER TO wbadm;
2292 -- Name: pkg_history; Type: VIEW; Schema: mips_public; Owner: wbadm
2295 CREATE VIEW pkg_history AS
2296 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 mips.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2299 ALTER TABLE mips_public.pkg_history OWNER TO wbadm;
2302 -- Name: transactions; Type: VIEW; Schema: mips_public; Owner: wbadm
2305 CREATE VIEW transactions AS
2306 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM mips.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2309 ALTER TABLE mips_public.transactions OWNER TO wbadm;
2312 -- Name: users; Type: VIEW; Schema: mips_public; Owner: wbadm
2315 CREATE VIEW users AS
2316 SELECT users.username, users.distribution, users.last_seen FROM mips.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2319 ALTER TABLE mips_public.users OWNER TO wbadm;
2321 SET search_path = mipsel, pg_catalog;
2324 -- Name: packages; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2327 CREATE TABLE packages (
2328 package character varying NOT NULL,
2329 distribution character varying NOT NULL,
2330 version character varying,
2331 state character varying,
2332 section character varying,
2333 priority character varying,
2334 installed_version character varying,
2335 previous_state character varying,
2336 state_change timestamp without time zone,
2337 notes character varying,
2338 builder character varying,
2341 binary_nmu_version integer,
2342 binary_nmu_changelog character varying,
2343 failed_category character varying,
2344 permbuildpri integer,
2346 depends character varying,
2347 rel character varying,
2349 extra_depends character varying,
2350 extra_conflicts character varying,
2351 build_arch_all boolean DEFAULT false NOT NULL
2355 ALTER TABLE mipsel.packages OWNER TO wbadm;
2358 -- Name: pkg_history; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2361 CREATE TABLE pkg_history (
2362 package character varying NOT NULL,
2363 distribution character varying NOT NULL,
2364 version character varying NOT NULL,
2365 "timestamp" timestamp without time zone NOT NULL,
2366 result character varying NOT NULL,
2369 builder character varying
2373 ALTER TABLE mipsel.pkg_history OWNER TO wbadm;
2376 -- Name: transactions; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2379 CREATE TABLE transactions (
2380 package character varying,
2381 distribution character varying,
2382 version character varying,
2383 action character varying,
2384 prevstate character varying,
2385 state character varying,
2386 real_user character varying,
2387 set_user character varying,
2388 "time" timestamp without time zone
2392 ALTER TABLE mipsel.transactions OWNER TO wbadm;
2395 -- Name: users; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2398 CREATE TABLE users (
2399 username character varying NOT NULL,
2400 distribution character varying NOT NULL,
2401 last_seen timestamp without time zone
2405 ALTER TABLE mipsel.users OWNER TO wbadm;
2407 SET search_path = mipsel_public, pg_catalog;
2410 -- Name: packages; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2413 CREATE VIEW packages AS
2414 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 mipsel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2417 ALTER TABLE mipsel_public.packages OWNER TO wbadm;
2420 -- Name: pkg_history; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2423 CREATE VIEW pkg_history AS
2424 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 mipsel.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2427 ALTER TABLE mipsel_public.pkg_history OWNER TO wbadm;
2430 -- Name: transactions; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2433 CREATE VIEW transactions AS
2434 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM mipsel.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2437 ALTER TABLE mipsel_public.transactions OWNER TO wbadm;
2440 -- Name: users; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2443 CREATE VIEW users AS
2444 SELECT users.username, users.distribution, users.last_seen FROM mipsel.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2447 ALTER TABLE mipsel_public.users OWNER TO wbadm;
2449 SET search_path = powerpc, pg_catalog;
2452 -- Name: packages; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2455 CREATE TABLE packages (
2456 package character varying NOT NULL,
2457 distribution character varying NOT NULL,
2458 version character varying,
2459 state character varying,
2460 section character varying,
2461 priority character varying,
2462 installed_version character varying,
2463 previous_state character varying,
2464 state_change timestamp without time zone,
2465 notes character varying,
2466 builder character varying,
2469 binary_nmu_version integer,
2470 binary_nmu_changelog character varying,
2471 failed_category character varying,
2472 permbuildpri integer,
2474 depends character varying,
2475 rel character varying,
2477 extra_depends character varying,
2478 extra_conflicts character varying,
2479 build_arch_all boolean DEFAULT false NOT NULL
2483 ALTER TABLE powerpc.packages OWNER TO wbadm;
2486 -- Name: pkg_history; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2489 CREATE TABLE pkg_history (
2490 package character varying NOT NULL,
2491 distribution character varying NOT NULL,
2492 version character varying NOT NULL,
2493 "timestamp" timestamp without time zone NOT NULL,
2494 result character varying NOT NULL,
2497 builder character varying
2501 ALTER TABLE powerpc.pkg_history OWNER TO wbadm;
2504 -- Name: transactions; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2507 CREATE TABLE transactions (
2508 package character varying,
2509 distribution character varying,
2510 version character varying,
2511 action character varying,
2512 prevstate character varying,
2513 state character varying,
2514 real_user character varying,
2515 set_user character varying,
2516 "time" timestamp without time zone
2520 ALTER TABLE powerpc.transactions OWNER TO wbadm;
2523 -- Name: users; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2526 CREATE TABLE users (
2527 username character varying NOT NULL,
2528 distribution character varying NOT NULL,
2529 last_seen timestamp without time zone
2533 ALTER TABLE powerpc.users OWNER TO wbadm;
2535 SET search_path = powerpc_public, pg_catalog;
2538 -- Name: packages; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2541 CREATE VIEW packages AS
2542 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 powerpc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2545 ALTER TABLE powerpc_public.packages OWNER TO wbadm;
2548 -- Name: pkg_history; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2551 CREATE VIEW pkg_history AS
2552 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 powerpc.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2555 ALTER TABLE powerpc_public.pkg_history OWNER TO wbadm;
2558 -- Name: transactions; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2561 CREATE VIEW transactions AS
2562 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM powerpc.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2565 ALTER TABLE powerpc_public.transactions OWNER TO wbadm;
2568 -- Name: users; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2571 CREATE VIEW users AS
2572 SELECT users.username, users.distribution, users.last_seen FROM powerpc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2575 ALTER TABLE powerpc_public.users OWNER TO wbadm;
2577 SET search_path = public, pg_catalog;
2580 -- Name: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2583 CREATE TABLE distribution_aliases (
2584 alias character varying NOT NULL,
2585 distribution character varying NOT NULL
2589 ALTER TABLE public.distribution_aliases OWNER TO wbadm;
2591 SET search_path = s390, pg_catalog;
2594 -- Name: packages; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2597 CREATE TABLE packages (
2598 package character varying NOT NULL,
2599 distribution character varying NOT NULL,
2600 version character varying,
2601 state character varying,
2602 section character varying,
2603 priority character varying,
2604 installed_version character varying,
2605 previous_state character varying,
2606 state_change timestamp without time zone,
2607 notes character varying,
2608 builder character varying,
2611 binary_nmu_version integer,
2612 binary_nmu_changelog character varying,
2613 failed_category character varying,
2614 permbuildpri integer,
2616 depends character varying,
2617 rel character varying,
2619 extra_depends character varying,
2620 extra_conflicts character varying,
2621 build_arch_all boolean DEFAULT false NOT NULL
2625 ALTER TABLE s390.packages OWNER TO wbadm;
2627 SET search_path = sparc, pg_catalog;
2630 -- Name: packages; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2633 CREATE TABLE packages (
2634 package character varying NOT NULL,
2635 distribution character varying NOT NULL,
2636 version character varying,
2637 state character varying,
2638 section character varying,
2639 priority character varying,
2640 installed_version character varying,
2641 previous_state character varying,
2642 state_change timestamp without time zone,
2643 notes character varying,
2644 builder character varying,
2647 binary_nmu_version integer,
2648 binary_nmu_changelog character varying,
2649 failed_category character varying,
2650 permbuildpri integer,
2652 depends character varying,
2653 rel character varying,
2655 extra_depends character varying,
2656 extra_conflicts character varying,
2657 build_arch_all boolean DEFAULT false NOT NULL
2661 ALTER TABLE sparc.packages OWNER TO wbadm;
2663 SET search_path = public, pg_catalog;
2666 -- Name: distribution_architectures; Type: VIEW; Schema: public; Owner: wbadm
2669 CREATE VIEW distribution_architectures AS
2670 (((((((((((((SELECT DISTINCT packages.distribution, 'alpha'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM alpha.packages GROUP BY packages.distribution UNION SELECT DISTINCT packages.distribution, 'amd64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM amd64.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'arm'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM arm.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'armel'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM armel.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'hppa'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM hppa.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'hurd-i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM "hurd-i386".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM i386.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'ia64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM ia64.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-amd64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM "kfreebsd-amd64".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM "kfreebsd-i386".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'mips'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM mips.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'mipsel'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM mipsel.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'powerpc'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM powerpc.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 's390'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM s390.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'sparc'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild, count(CASE WHEN ((packages.state_change < (now() - '1 day'::interval)) AND (((packages.state)::text = 'Built'::text) OR ((packages.state)::text = 'Uploaded'::text))) THEN 1 ELSE NULL::integer END) AS notinstalled FROM sparc.packages GROUP BY packages.distribution;
2673 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2676 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2679 CREATE TABLE distributions (
2680 distribution character varying NOT NULL,
2681 public boolean DEFAULT true NOT NULL,
2682 sort_order integer DEFAULT 0,
2683 auto_dep_wait boolean DEFAULT true,
2684 build_dep_resolver character varying,
2685 archive character varying,
2686 suppress_successful_logs boolean DEFAULT false NOT NULL
2690 ALTER TABLE public.distributions OWNER TO wbadm;
2692 SET search_path = s390, pg_catalog;
2695 -- Name: pkg_history; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2698 CREATE TABLE pkg_history (
2699 package character varying NOT NULL,
2700 distribution character varying NOT NULL,
2701 version character varying NOT NULL,
2702 "timestamp" timestamp without time zone NOT NULL,
2703 result character varying NOT NULL,
2706 builder character varying
2710 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2712 SET search_path = s390_public, pg_catalog;
2715 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2718 CREATE VIEW pkg_history AS
2719 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 s390.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2722 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2724 SET search_path = sparc, pg_catalog;
2727 -- Name: pkg_history; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2730 CREATE TABLE pkg_history (
2731 package character varying NOT NULL,
2732 distribution character varying NOT NULL,
2733 version character varying NOT NULL,
2734 "timestamp" timestamp without time zone NOT NULL,
2735 result character varying NOT NULL,
2738 builder character varying
2742 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2744 SET search_path = sparc_public, pg_catalog;
2747 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2750 CREATE VIEW pkg_history AS
2751 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 sparc.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2754 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2756 SET search_path = public, pg_catalog;
2759 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2762 CREATE VIEW lastlog AS
2763 ((((((((((((((SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'alpha'::character varying AS architecture FROM alpha_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'amd64'::character varying AS architecture FROM amd64_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'arm'::character varying AS architecture FROM arm_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'armel'::character varying AS architecture FROM armel_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'hppa'::character varying AS architecture FROM hppa_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'hurd-i386'::character varying AS architecture FROM "hurd-i386_public".pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'i386'::character varying AS architecture FROM i386_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'ia64'::character varying AS architecture FROM ia64_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'kfreebsd-amd64'::character varying AS architecture FROM "kfreebsd-amd64_public".pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'kfreebsd-i386'::character varying AS architecture FROM "kfreebsd-i386_public".pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'mips'::character varying AS architecture FROM mips_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'mipsel'::character varying AS architecture FROM mipsel_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'powerpc'::character varying AS architecture FROM powerpc_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 's390'::character varying AS architecture FROM s390_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25)) UNION (SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'sparc'::character varying AS architecture FROM sparc_public.pkg_history ORDER BY pkg_history."timestamp" DESC LIMIT 25) ORDER BY 4 DESC LIMIT 25;
2766 ALTER TABLE public.lastlog OWNER TO wbadm;
2769 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2773 (((((((((((((SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'alpha'::character varying AS architecture FROM alpha_public.pkg_history UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'amd64'::character varying AS architecture FROM amd64_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'arm'::character varying AS architecture FROM arm_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'armel'::character varying AS architecture FROM armel_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'hppa'::character varying AS architecture FROM hppa_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'hurd-i386'::character varying AS architecture FROM "hurd-i386_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'i386'::character varying AS architecture FROM i386_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'ia64'::character varying AS architecture FROM ia64_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'kfreebsd-amd64'::character varying AS architecture FROM "kfreebsd-amd64_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'kfreebsd-i386'::character varying AS architecture FROM "kfreebsd-i386_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'mips'::character varying AS architecture FROM mips_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'mipsel'::character varying AS architecture FROM mipsel_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'powerpc'::character varying AS architecture FROM powerpc_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 's390'::character varying AS architecture FROM s390_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", 'sparc'::character varying AS architecture FROM sparc_public.pkg_history ORDER BY 4 DESC;
2776 ALTER TABLE public.log OWNER TO wbadm;
2779 -- Name: log_v2; Type: VIEW; Schema: public; Owner: pkern
2782 CREATE VIEW log_v2 AS
2783 (((((((((((((SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'alpha'::character varying AS architecture FROM alpha_public.pkg_history UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'amd64'::character varying AS architecture FROM amd64_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'arm'::character varying AS architecture FROM arm_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'armel'::character varying AS architecture FROM armel_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'hppa'::character varying AS architecture FROM hppa_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'hurd-i386'::character varying AS architecture FROM "hurd-i386_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'i386'::character varying AS architecture FROM i386_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'ia64'::character varying AS architecture FROM ia64_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'kfreebsd-amd64'::character varying AS architecture FROM "kfreebsd-amd64_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'kfreebsd-i386'::character varying AS architecture FROM "kfreebsd-i386_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'mips'::character varying AS architecture FROM mips_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'mipsel'::character varying AS architecture FROM mipsel_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'powerpc'::character varying AS architecture FROM powerpc_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 's390'::character varying AS architecture FROM s390_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'sparc'::character varying AS architecture FROM sparc_public.pkg_history ORDER BY 4 DESC;
2786 ALTER TABLE public.log_v2 OWNER TO pkern;
2788 SET search_path = s390_public, pg_catalog;
2791 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2794 CREATE VIEW packages AS
2795 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 s390.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2798 ALTER TABLE s390_public.packages OWNER TO wbadm;
2800 SET search_path = sparc_public, pg_catalog;
2803 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2806 CREATE VIEW packages AS
2807 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 sparc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2810 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2812 SET search_path = public, pg_catalog;
2815 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2818 CREATE VIEW packages_all AS
2819 (((((((((((((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, 'alpha'::character varying AS architecture FROM alpha_public.packages UNION ALL 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, 'amd64'::character varying AS architecture FROM amd64_public.packages) UNION ALL 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, 'arm'::character varying AS architecture FROM arm_public.packages) UNION ALL 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, 'armel'::character varying AS architecture FROM armel_public.packages) UNION ALL 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, 'hppa'::character varying AS architecture FROM hppa_public.packages) UNION ALL 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, 'hurd-i386'::character varying AS architecture FROM "hurd-i386_public".packages) UNION ALL 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, 'i386'::character varying AS architecture FROM i386_public.packages) UNION ALL 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, 'ia64'::character varying AS architecture FROM ia64_public.packages) UNION ALL 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, 'kfreebsd-amd64'::character varying AS architecture FROM "kfreebsd-amd64_public".packages) UNION ALL 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, 'kfreebsd-i386'::character varying AS architecture FROM "kfreebsd-i386_public".packages) UNION ALL 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, 'mips'::character varying AS architecture FROM mips_public.packages) UNION ALL 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, 'mipsel'::character varying AS architecture FROM mipsel_public.packages) UNION ALL 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, 'powerpc'::character varying AS architecture FROM powerpc_public.packages) UNION ALL 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, 's390'::character varying AS architecture FROM s390_public.packages) UNION ALL 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, 'sparc'::character varying AS architecture FROM sparc_public.packages;
2822 ALTER TABLE public.packages_all OWNER TO wbadm;
2824 SET search_path = s390, pg_catalog;
2827 -- Name: transactions; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2830 CREATE TABLE transactions (
2831 package character varying,
2832 distribution character varying,
2833 version character varying,
2834 action character varying,
2835 prevstate character varying,
2836 state character varying,
2837 real_user character varying,
2838 set_user character varying,
2839 "time" timestamp without time zone
2843 ALTER TABLE s390.transactions OWNER TO wbadm;
2846 -- Name: users; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2849 CREATE TABLE users (
2850 username character varying NOT NULL,
2851 distribution character varying NOT NULL,
2852 last_seen timestamp without time zone
2856 ALTER TABLE s390.users OWNER TO wbadm;
2858 SET search_path = s390_public, pg_catalog;
2861 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2864 CREATE VIEW transactions AS
2865 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM s390.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2868 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2871 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2874 CREATE VIEW users AS
2875 SELECT users.username, users.distribution, users.last_seen FROM s390.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2878 ALTER TABLE s390_public.users OWNER TO wbadm;
2880 SET search_path = sparc, pg_catalog;
2883 -- Name: transactions; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2886 CREATE TABLE transactions (
2887 package character varying,
2888 distribution character varying,
2889 version character varying,
2890 action character varying,
2891 prevstate character varying,
2892 state character varying,
2893 real_user character varying,
2894 set_user character varying,
2895 "time" timestamp without time zone
2899 ALTER TABLE sparc.transactions OWNER TO wbadm;
2902 -- Name: users; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2905 CREATE TABLE users (
2906 username character varying NOT NULL,
2907 distribution character varying NOT NULL,
2908 last_seen timestamp without time zone
2912 ALTER TABLE sparc.users OWNER TO wbadm;
2914 SET search_path = sparc_public, pg_catalog;
2917 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2920 CREATE VIEW transactions AS
2921 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM sparc.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2924 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2927 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2930 CREATE VIEW users AS
2931 SELECT users.username, users.distribution, users.last_seen FROM sparc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2934 ALTER TABLE sparc_public.users OWNER TO wbadm;
2936 SET search_path = alpha, pg_catalog;
2939 -- Name: packages_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2942 ALTER TABLE ONLY packages
2943 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2947 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2950 ALTER TABLE ONLY pkg_history
2951 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2955 -- Name: users_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2958 ALTER TABLE ONLY users
2959 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2962 SET search_path = amd64, pg_catalog;
2965 -- Name: packages_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2968 ALTER TABLE ONLY packages
2969 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2973 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2976 ALTER TABLE ONLY pkg_history
2977 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2981 -- Name: users_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2984 ALTER TABLE ONLY users
2985 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2988 SET search_path = arm, pg_catalog;
2991 -- Name: packages_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2994 ALTER TABLE ONLY packages
2995 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2999 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
3002 ALTER TABLE ONLY pkg_history
3003 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3007 -- Name: users_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
3010 ALTER TABLE ONLY users
3011 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3014 SET search_path = armel, pg_catalog;
3017 -- Name: packages_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3020 ALTER TABLE ONLY packages
3021 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3025 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3028 ALTER TABLE ONLY pkg_history
3029 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3033 -- Name: users_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3036 ALTER TABLE ONLY users
3037 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3040 SET search_path = hppa, pg_catalog;
3043 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3046 ALTER TABLE ONLY packages
3047 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3051 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3054 ALTER TABLE ONLY pkg_history
3055 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3059 -- Name: users_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3062 ALTER TABLE ONLY users
3063 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3066 SET search_path = "hurd-i386", pg_catalog;
3069 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3072 ALTER TABLE ONLY packages
3073 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3077 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3080 ALTER TABLE ONLY pkg_history
3081 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3085 -- Name: users_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3088 ALTER TABLE ONLY users
3089 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3092 SET search_path = i386, pg_catalog;
3095 -- Name: packages_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3098 ALTER TABLE ONLY packages
3099 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3103 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3106 ALTER TABLE ONLY pkg_history
3107 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3111 -- Name: users_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3114 ALTER TABLE ONLY users
3115 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3118 SET search_path = ia64, pg_catalog;
3121 -- Name: packages_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3124 ALTER TABLE ONLY packages
3125 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3129 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3132 ALTER TABLE ONLY pkg_history
3133 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3137 -- Name: users_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3140 ALTER TABLE ONLY users
3141 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3144 SET search_path = "kfreebsd-amd64", pg_catalog;
3147 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3150 ALTER TABLE ONLY packages
3151 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3155 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3158 ALTER TABLE ONLY pkg_history
3159 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3163 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3166 ALTER TABLE ONLY users
3167 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3170 SET search_path = "kfreebsd-i386", pg_catalog;
3173 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3176 ALTER TABLE ONLY packages
3177 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3181 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3184 ALTER TABLE ONLY pkg_history
3185 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3189 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3192 ALTER TABLE ONLY users
3193 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3196 SET search_path = mips, pg_catalog;
3199 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3202 ALTER TABLE ONLY packages
3203 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3207 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3210 ALTER TABLE ONLY pkg_history
3211 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3215 -- Name: users_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3218 ALTER TABLE ONLY users
3219 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3222 SET search_path = mipsel, pg_catalog;
3225 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3228 ALTER TABLE ONLY packages
3229 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3233 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3236 ALTER TABLE ONLY pkg_history
3237 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3241 -- Name: users_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3244 ALTER TABLE ONLY users
3245 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3248 SET search_path = powerpc, pg_catalog;
3251 -- Name: packages_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3254 ALTER TABLE ONLY packages
3255 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3259 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3262 ALTER TABLE ONLY pkg_history
3263 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3267 -- Name: users_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3270 ALTER TABLE ONLY users
3271 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3274 SET search_path = public, pg_catalog;
3277 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
3280 ALTER TABLE ONLY distribution_aliases
3281 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
3284 SET search_path = s390, pg_catalog;
3287 -- Name: packages_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3290 ALTER TABLE ONLY packages
3291 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3295 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3298 ALTER TABLE ONLY pkg_history
3299 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3303 -- Name: users_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3306 ALTER TABLE ONLY users
3307 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3310 SET search_path = sparc, pg_catalog;
3313 -- Name: packages_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3316 ALTER TABLE ONLY packages
3317 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3321 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3324 ALTER TABLE ONLY pkg_history
3325 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3329 -- Name: users_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3332 ALTER TABLE ONLY users
3333 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3336 SET search_path = alpha, pg_catalog;
3339 -- Name: idx_alpha_state; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3342 CREATE INDEX idx_alpha_state ON packages USING btree (state);
3346 -- Name: pkg_history_distribution; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3349 CREATE INDEX pkg_history_distribution ON pkg_history USING hash (distribution);
3353 -- Name: pkg_history_index; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3356 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3360 -- Name: pkg_history_timestamp; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3363 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3366 SET search_path = amd64, pg_catalog;
3369 -- Name: idx_amd64_state; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3372 CREATE INDEX idx_amd64_state ON packages USING btree (state);
3376 -- Name: pkg_history_index; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3379 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3383 -- Name: pkg_history_timestamp; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3386 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3389 SET search_path = arm, pg_catalog;
3392 -- Name: idx_arm_state; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3395 CREATE INDEX idx_arm_state ON packages USING btree (state);
3399 -- Name: pkg_history_index; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3402 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3406 -- Name: pkg_history_timestamp; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3409 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3412 SET search_path = armel, pg_catalog;
3415 -- Name: idx_armel_state; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3418 CREATE INDEX idx_armel_state ON packages USING btree (state);
3422 -- Name: pkg_history_index; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3425 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3429 -- Name: pkg_history_timestamp; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3432 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3435 SET search_path = hppa, pg_catalog;
3438 -- Name: idx_hppa_state; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3441 CREATE INDEX idx_hppa_state ON packages USING btree (state);
3445 -- Name: pkg_history_index; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3448 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3452 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3455 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3458 SET search_path = "hurd-i386", pg_catalog;
3461 -- Name: idx_hurd-i386_state; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3464 CREATE INDEX "idx_hurd-i386_state" ON packages USING btree (state);
3468 -- Name: pkg_history_index; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3471 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3475 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3478 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3481 SET search_path = i386, pg_catalog;
3484 -- Name: idx_i386_state; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3487 CREATE INDEX idx_i386_state ON packages USING btree (state);
3491 -- Name: pkg_history_index; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3494 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3498 -- Name: pkg_history_timestamp; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3501 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3504 SET search_path = ia64, pg_catalog;
3507 -- Name: idx_ia64_state; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3510 CREATE INDEX idx_ia64_state ON packages USING btree (state);
3514 -- Name: pkg_history_index; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3517 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3521 -- Name: pkg_history_timestamp; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3524 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3527 SET search_path = "kfreebsd-amd64", pg_catalog;
3530 -- Name: idx_kfreebsd-amd64_state; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3533 CREATE INDEX "idx_kfreebsd-amd64_state" ON packages USING btree (state);
3537 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3540 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3544 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3547 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3550 SET search_path = "kfreebsd-i386", pg_catalog;
3553 -- Name: idx_kfreebsd-i386_state; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3556 CREATE INDEX "idx_kfreebsd-i386_state" ON packages USING btree (state);
3560 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3563 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3567 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3570 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3573 SET search_path = mips, pg_catalog;
3576 -- Name: idx_mips_state; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3579 CREATE INDEX idx_mips_state ON packages USING btree (state);
3583 -- Name: pkg_history_index; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3586 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3590 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3593 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3596 SET search_path = mipsel, pg_catalog;
3599 -- Name: idx_mipsel_state; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3602 CREATE INDEX idx_mipsel_state ON packages USING btree (state);
3606 -- Name: pkg_history_index; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3609 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3613 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3616 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3619 SET search_path = powerpc, pg_catalog;
3622 -- Name: idx_powerpc_state; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3625 CREATE INDEX idx_powerpc_state ON packages USING btree (state);
3629 -- Name: pkg_history_index; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3632 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3636 -- Name: pkg_history_timestamp; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3639 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3642 SET search_path = public, pg_catalog;
3645 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3648 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
3652 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3655 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
3658 SET search_path = s390, pg_catalog;
3661 -- Name: idx_s390_state; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3664 CREATE INDEX idx_s390_state ON packages USING btree (state);
3668 -- Name: pkg_history_index; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3671 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3675 -- Name: pkg_history_timestamp; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3678 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3681 SET search_path = sparc, pg_catalog;
3684 -- Name: idx_sparc_state; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3687 CREATE INDEX idx_sparc_state ON packages USING btree (state);
3691 -- Name: pkg_history_index; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3694 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3698 -- Name: pkg_history_timestamp; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3701 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3704 SET search_path = alpha, pg_catalog;
3707 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3710 ALTER TABLE ONLY packages
3711 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3715 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3718 ALTER TABLE ONLY pkg_history
3719 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3723 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3726 ALTER TABLE ONLY users
3727 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3730 SET search_path = amd64, pg_catalog;
3733 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3736 ALTER TABLE ONLY packages
3737 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3741 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3744 ALTER TABLE ONLY pkg_history
3745 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3749 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3752 ALTER TABLE ONLY users
3753 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3756 SET search_path = arm, pg_catalog;
3759 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3762 ALTER TABLE ONLY packages
3763 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3767 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3770 ALTER TABLE ONLY pkg_history
3771 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3775 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3778 ALTER TABLE ONLY users
3779 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3782 SET search_path = armel, pg_catalog;
3785 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3788 ALTER TABLE ONLY packages
3789 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3793 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3796 ALTER TABLE ONLY pkg_history
3797 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3801 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3804 ALTER TABLE ONLY users
3805 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3808 SET search_path = hppa, pg_catalog;
3811 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3814 ALTER TABLE ONLY packages
3815 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3819 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3822 ALTER TABLE ONLY pkg_history
3823 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3827 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3830 ALTER TABLE ONLY users
3831 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3834 SET search_path = "hurd-i386", pg_catalog;
3837 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3840 ALTER TABLE ONLY packages
3841 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3845 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3848 ALTER TABLE ONLY pkg_history
3849 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3853 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3856 ALTER TABLE ONLY users
3857 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3860 SET search_path = i386, pg_catalog;
3863 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3866 ALTER TABLE ONLY packages
3867 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3871 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3874 ALTER TABLE ONLY pkg_history
3875 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3879 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3882 ALTER TABLE ONLY users
3883 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3886 SET search_path = ia64, pg_catalog;
3889 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3892 ALTER TABLE ONLY packages
3893 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3897 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3900 ALTER TABLE ONLY pkg_history
3901 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3905 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3908 ALTER TABLE ONLY users
3909 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3912 SET search_path = "kfreebsd-amd64", pg_catalog;
3915 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3918 ALTER TABLE ONLY packages
3919 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3923 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3926 ALTER TABLE ONLY pkg_history
3927 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3931 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3934 ALTER TABLE ONLY users
3935 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3938 SET search_path = "kfreebsd-i386", pg_catalog;
3941 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3944 ALTER TABLE ONLY packages
3945 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3949 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3952 ALTER TABLE ONLY pkg_history
3953 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3957 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3960 ALTER TABLE ONLY users
3961 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3964 SET search_path = mips, pg_catalog;
3967 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3970 ALTER TABLE ONLY packages
3971 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3975 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3978 ALTER TABLE ONLY pkg_history
3979 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3983 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3986 ALTER TABLE ONLY users
3987 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3990 SET search_path = mipsel, pg_catalog;
3993 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3996 ALTER TABLE ONLY packages
3997 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4001 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
4004 ALTER TABLE ONLY pkg_history
4005 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4009 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
4012 ALTER TABLE ONLY users
4013 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4016 SET search_path = powerpc, pg_catalog;
4019 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4022 ALTER TABLE ONLY packages
4023 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4027 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4030 ALTER TABLE ONLY pkg_history
4031 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4035 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4038 ALTER TABLE ONLY users
4039 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4042 SET search_path = public, pg_catalog;
4045 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
4048 ALTER TABLE ONLY distribution_aliases
4049 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
4052 SET search_path = s390, pg_catalog;
4055 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4058 ALTER TABLE ONLY packages
4059 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4063 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4066 ALTER TABLE ONLY pkg_history
4067 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4071 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4074 ALTER TABLE ONLY users
4075 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4078 SET search_path = sparc, pg_catalog;
4081 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4084 ALTER TABLE ONLY packages
4085 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4089 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4092 ALTER TABLE ONLY pkg_history
4093 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4097 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4100 ALTER TABLE ONLY users
4101 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4105 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
4108 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
4109 REVOKE ALL ON SCHEMA alpha FROM wbadm;
4110 GRANT ALL ON SCHEMA alpha TO wbadm;
4111 GRANT USAGE ON SCHEMA alpha TO alpha;
4112 GRANT USAGE ON SCHEMA alpha TO wb_all;
4113 GRANT USAGE ON SCHEMA alpha TO wb_security;
4117 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
4120 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
4121 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
4122 GRANT ALL ON SCHEMA alpha_public TO wbadm;
4123 GRANT USAGE ON SCHEMA alpha_public TO alpha;
4124 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
4128 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
4131 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
4132 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
4133 GRANT ALL ON SCHEMA amd64 TO wbadm;
4134 GRANT USAGE ON SCHEMA amd64 TO amd64;
4135 GRANT USAGE ON SCHEMA amd64 TO wb_all;
4136 GRANT USAGE ON SCHEMA amd64 TO wb_security;
4140 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
4143 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
4144 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
4145 GRANT ALL ON SCHEMA amd64_public TO wbadm;
4146 GRANT USAGE ON SCHEMA amd64_public TO amd64;
4147 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
4151 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
4154 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
4155 REVOKE ALL ON SCHEMA arm FROM wbadm;
4156 GRANT ALL ON SCHEMA arm TO wbadm;
4157 GRANT USAGE ON SCHEMA arm TO arm;
4158 GRANT USAGE ON SCHEMA arm TO wb_all;
4159 GRANT USAGE ON SCHEMA arm TO wb_security;
4163 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
4166 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
4167 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
4168 GRANT ALL ON SCHEMA arm_public TO wbadm;
4169 GRANT USAGE ON SCHEMA arm_public TO arm;
4170 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
4174 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
4177 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
4178 REVOKE ALL ON SCHEMA armel FROM wbadm;
4179 GRANT ALL ON SCHEMA armel TO wbadm;
4180 GRANT USAGE ON SCHEMA armel TO armel;
4181 GRANT USAGE ON SCHEMA armel TO wb_all;
4182 GRANT USAGE ON SCHEMA armel TO wb_security;
4186 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
4189 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
4190 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
4191 GRANT ALL ON SCHEMA armel_public TO wbadm;
4192 GRANT USAGE ON SCHEMA armel_public TO armel;
4193 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
4197 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4200 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4201 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4202 GRANT ALL ON SCHEMA hppa TO wbadm;
4203 GRANT USAGE ON SCHEMA hppa TO hppa;
4204 GRANT USAGE ON SCHEMA hppa TO wb_all;
4205 GRANT USAGE ON SCHEMA hppa TO wb_security;
4209 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4212 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4213 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4214 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4215 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4216 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4220 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4223 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4224 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4225 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4226 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4227 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4228 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4232 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4235 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4236 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4237 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4238 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4239 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4243 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4246 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4247 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4248 GRANT ALL ON SCHEMA i386 TO wbadm;
4249 GRANT USAGE ON SCHEMA i386 TO i386;
4250 GRANT USAGE ON SCHEMA i386 TO wb_all;
4251 GRANT USAGE ON SCHEMA i386 TO wb_security;
4255 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4258 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4259 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4260 GRANT ALL ON SCHEMA i386_public TO wbadm;
4261 GRANT USAGE ON SCHEMA i386_public TO i386;
4262 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4266 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4269 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4270 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4271 GRANT ALL ON SCHEMA ia64 TO wbadm;
4272 GRANT USAGE ON SCHEMA ia64 TO ia64;
4273 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4274 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4278 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4281 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4282 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4283 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4284 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4285 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4289 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4292 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4293 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4294 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4295 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4296 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4297 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4301 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4304 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4305 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4306 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4307 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4308 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4312 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4315 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4316 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4317 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4318 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4319 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4320 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4324 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4327 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4328 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4329 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4330 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4331 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4335 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4338 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4339 REVOKE ALL ON SCHEMA mips FROM wbadm;
4340 GRANT ALL ON SCHEMA mips TO wbadm;
4341 GRANT USAGE ON SCHEMA mips TO mips;
4342 GRANT USAGE ON SCHEMA mips TO wb_all;
4343 GRANT USAGE ON SCHEMA mips TO wb_security;
4347 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4350 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4351 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4352 GRANT ALL ON SCHEMA mips_public TO wbadm;
4353 GRANT USAGE ON SCHEMA mips_public TO mips;
4354 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4358 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4361 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4362 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4363 GRANT ALL ON SCHEMA mipsel TO wbadm;
4364 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4365 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4366 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4370 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4373 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4374 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4375 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4376 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4377 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4381 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4384 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4385 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4386 GRANT ALL ON SCHEMA powerpc TO wbadm;
4387 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4388 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4389 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4393 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4396 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4397 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4398 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4399 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4400 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4404 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4407 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4408 REVOKE ALL ON SCHEMA public FROM postgres;
4409 GRANT ALL ON SCHEMA public TO postgres;
4410 GRANT ALL ON SCHEMA public TO PUBLIC;
4414 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4417 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4418 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4419 GRANT ALL ON SCHEMA s390 TO wbadm;
4420 GRANT USAGE ON SCHEMA s390 TO s390;
4421 GRANT USAGE ON SCHEMA s390 TO wb_all;
4422 GRANT USAGE ON SCHEMA s390 TO wb_security;
4426 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4429 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4430 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4431 GRANT ALL ON SCHEMA s390_public TO wbadm;
4432 GRANT USAGE ON SCHEMA s390_public TO s390;
4433 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4437 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4440 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4441 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4442 GRANT ALL ON SCHEMA sparc TO wbadm;
4443 GRANT USAGE ON SCHEMA sparc TO sparc;
4444 GRANT USAGE ON SCHEMA sparc TO wb_all;
4445 GRANT USAGE ON SCHEMA sparc TO wb_security;
4449 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4452 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4453 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4454 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4455 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4456 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4459 SET search_path = alpha, pg_catalog;
4462 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4465 REVOKE ALL ON TABLE packages FROM PUBLIC;
4466 REVOKE ALL ON TABLE packages FROM wbadm;
4467 GRANT ALL ON TABLE packages TO wbadm;
4468 GRANT ALL ON TABLE packages TO alpha;
4469 GRANT SELECT ON TABLE packages TO wb_security;
4473 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4476 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4477 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4478 GRANT ALL ON TABLE pkg_history TO wbadm;
4479 GRANT ALL ON TABLE pkg_history TO alpha;
4480 GRANT SELECT ON TABLE pkg_history TO wb_security;
4484 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4487 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4488 REVOKE ALL ON TABLE transactions FROM wbadm;
4489 GRANT ALL ON TABLE transactions TO wbadm;
4490 GRANT SELECT,INSERT ON TABLE transactions TO alpha;
4491 GRANT SELECT ON TABLE transactions TO wb_security;
4495 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4498 REVOKE ALL ON TABLE users FROM PUBLIC;
4499 REVOKE ALL ON TABLE users FROM wbadm;
4500 GRANT ALL ON TABLE users TO wbadm;
4501 GRANT ALL ON TABLE users TO alpha;
4504 SET search_path = alpha_public, pg_catalog;
4507 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4510 REVOKE ALL ON TABLE packages FROM PUBLIC;
4511 REVOKE ALL ON TABLE packages FROM wbadm;
4512 GRANT ALL ON TABLE packages TO wbadm;
4513 GRANT SELECT ON TABLE packages TO PUBLIC;
4517 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4520 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4521 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4522 GRANT ALL ON TABLE pkg_history TO wbadm;
4523 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4527 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4530 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4531 REVOKE ALL ON TABLE transactions FROM wbadm;
4532 GRANT ALL ON TABLE transactions TO wbadm;
4533 GRANT SELECT ON TABLE transactions TO PUBLIC;
4537 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4540 REVOKE ALL ON TABLE users FROM PUBLIC;
4541 REVOKE ALL ON TABLE users FROM wbadm;
4542 GRANT ALL ON TABLE users TO wbadm;
4543 GRANT SELECT ON TABLE users TO PUBLIC;
4546 SET search_path = amd64, pg_catalog;
4549 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4552 REVOKE ALL ON TABLE packages FROM PUBLIC;
4553 REVOKE ALL ON TABLE packages FROM wbadm;
4554 GRANT ALL ON TABLE packages TO wbadm;
4555 GRANT ALL ON TABLE packages TO amd64;
4556 GRANT SELECT ON TABLE packages TO wb_security;
4560 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4563 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4564 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4565 GRANT ALL ON TABLE pkg_history TO wbadm;
4566 GRANT ALL ON TABLE pkg_history TO amd64;
4567 GRANT SELECT ON TABLE pkg_history TO wb_security;
4571 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4574 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4575 REVOKE ALL ON TABLE transactions FROM wbadm;
4576 GRANT ALL ON TABLE transactions TO wbadm;
4577 GRANT SELECT,INSERT ON TABLE transactions TO amd64;
4578 GRANT SELECT ON TABLE transactions TO wb_security;
4582 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4585 REVOKE ALL ON TABLE users FROM PUBLIC;
4586 REVOKE ALL ON TABLE users FROM wbadm;
4587 GRANT ALL ON TABLE users TO wbadm;
4588 GRANT ALL ON TABLE users TO amd64;
4591 SET search_path = amd64_public, pg_catalog;
4594 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4597 REVOKE ALL ON TABLE packages FROM PUBLIC;
4598 REVOKE ALL ON TABLE packages FROM wbadm;
4599 GRANT ALL ON TABLE packages TO wbadm;
4600 GRANT SELECT ON TABLE packages TO PUBLIC;
4604 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4607 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4608 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4609 GRANT ALL ON TABLE pkg_history TO wbadm;
4610 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4614 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4617 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4618 REVOKE ALL ON TABLE transactions FROM wbadm;
4619 GRANT ALL ON TABLE transactions TO wbadm;
4620 GRANT SELECT ON TABLE transactions TO PUBLIC;
4624 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4627 REVOKE ALL ON TABLE users FROM PUBLIC;
4628 REVOKE ALL ON TABLE users FROM wbadm;
4629 GRANT ALL ON TABLE users TO wbadm;
4630 GRANT SELECT ON TABLE users TO PUBLIC;
4633 SET search_path = arm, pg_catalog;
4636 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4639 REVOKE ALL ON TABLE packages FROM PUBLIC;
4640 REVOKE ALL ON TABLE packages FROM wbadm;
4641 GRANT ALL ON TABLE packages TO wbadm;
4642 GRANT ALL ON TABLE packages TO arm;
4643 GRANT SELECT ON TABLE packages TO wb_security;
4647 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4650 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4651 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4652 GRANT ALL ON TABLE pkg_history TO wbadm;
4653 GRANT ALL ON TABLE pkg_history TO arm;
4654 GRANT SELECT ON TABLE pkg_history TO wb_security;
4658 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4661 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4662 REVOKE ALL ON TABLE transactions FROM wbadm;
4663 GRANT ALL ON TABLE transactions TO wbadm;
4664 GRANT SELECT,INSERT ON TABLE transactions TO arm;
4665 GRANT SELECT ON TABLE transactions TO wb_security;
4669 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4672 REVOKE ALL ON TABLE users FROM PUBLIC;
4673 REVOKE ALL ON TABLE users FROM wbadm;
4674 GRANT ALL ON TABLE users TO wbadm;
4675 GRANT ALL ON TABLE users TO arm;
4678 SET search_path = arm_public, pg_catalog;
4681 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4684 REVOKE ALL ON TABLE packages FROM PUBLIC;
4685 REVOKE ALL ON TABLE packages FROM wbadm;
4686 GRANT ALL ON TABLE packages TO wbadm;
4687 GRANT SELECT ON TABLE packages TO PUBLIC;
4691 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4694 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4695 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4696 GRANT ALL ON TABLE pkg_history TO wbadm;
4697 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4701 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4704 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4705 REVOKE ALL ON TABLE transactions FROM wbadm;
4706 GRANT ALL ON TABLE transactions TO wbadm;
4707 GRANT SELECT ON TABLE transactions TO PUBLIC;
4711 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4714 REVOKE ALL ON TABLE users FROM PUBLIC;
4715 REVOKE ALL ON TABLE users FROM wbadm;
4716 GRANT ALL ON TABLE users TO wbadm;
4717 GRANT SELECT ON TABLE users TO PUBLIC;
4720 SET search_path = armel, pg_catalog;
4723 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4726 REVOKE ALL ON TABLE packages FROM PUBLIC;
4727 REVOKE ALL ON TABLE packages FROM wbadm;
4728 GRANT ALL ON TABLE packages TO wbadm;
4729 GRANT ALL ON TABLE packages TO armel;
4730 GRANT SELECT ON TABLE packages TO wb_security;
4734 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4737 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4738 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4739 GRANT ALL ON TABLE pkg_history TO wbadm;
4740 GRANT ALL ON TABLE pkg_history TO armel;
4741 GRANT SELECT ON TABLE pkg_history TO wb_security;
4745 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4748 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4749 REVOKE ALL ON TABLE transactions FROM wbadm;
4750 GRANT ALL ON TABLE transactions TO wbadm;
4751 GRANT SELECT,INSERT ON TABLE transactions TO armel;
4752 GRANT SELECT ON TABLE transactions TO wb_security;
4756 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4759 REVOKE ALL ON TABLE users FROM PUBLIC;
4760 REVOKE ALL ON TABLE users FROM wbadm;
4761 GRANT ALL ON TABLE users TO wbadm;
4762 GRANT ALL ON TABLE users TO armel;
4765 SET search_path = armel_public, pg_catalog;
4768 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4771 REVOKE ALL ON TABLE packages FROM PUBLIC;
4772 REVOKE ALL ON TABLE packages FROM wbadm;
4773 GRANT ALL ON TABLE packages TO wbadm;
4774 GRANT SELECT ON TABLE packages TO PUBLIC;
4778 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4781 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4782 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4783 GRANT ALL ON TABLE pkg_history TO wbadm;
4784 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4788 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4791 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4792 REVOKE ALL ON TABLE transactions FROM wbadm;
4793 GRANT ALL ON TABLE transactions TO wbadm;
4794 GRANT SELECT ON TABLE transactions TO PUBLIC;
4798 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4801 REVOKE ALL ON TABLE users FROM PUBLIC;
4802 REVOKE ALL ON TABLE users FROM wbadm;
4803 GRANT ALL ON TABLE users TO wbadm;
4804 GRANT SELECT ON TABLE users TO PUBLIC;
4807 SET search_path = hppa, pg_catalog;
4810 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4813 REVOKE ALL ON TABLE packages FROM PUBLIC;
4814 REVOKE ALL ON TABLE packages FROM wbadm;
4815 GRANT ALL ON TABLE packages TO wbadm;
4816 GRANT ALL ON TABLE packages TO hppa;
4817 GRANT SELECT ON TABLE packages TO wb_security;
4821 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4824 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4825 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4826 GRANT ALL ON TABLE pkg_history TO wbadm;
4827 GRANT ALL ON TABLE pkg_history TO hppa;
4828 GRANT SELECT ON TABLE pkg_history TO wb_security;
4832 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4835 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4836 REVOKE ALL ON TABLE transactions FROM wbadm;
4837 GRANT ALL ON TABLE transactions TO wbadm;
4838 GRANT SELECT,INSERT ON TABLE transactions TO hppa;
4839 GRANT SELECT ON TABLE transactions TO wb_security;
4843 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4846 REVOKE ALL ON TABLE users FROM PUBLIC;
4847 REVOKE ALL ON TABLE users FROM wbadm;
4848 GRANT ALL ON TABLE users TO wbadm;
4849 GRANT ALL ON TABLE users TO hppa;
4852 SET search_path = hppa_public, pg_catalog;
4855 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4858 REVOKE ALL ON TABLE packages FROM PUBLIC;
4859 REVOKE ALL ON TABLE packages FROM wbadm;
4860 GRANT ALL ON TABLE packages TO wbadm;
4861 GRANT SELECT ON TABLE packages TO PUBLIC;
4865 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4868 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4869 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4870 GRANT ALL ON TABLE pkg_history TO wbadm;
4871 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4875 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4878 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4879 REVOKE ALL ON TABLE transactions FROM wbadm;
4880 GRANT ALL ON TABLE transactions TO wbadm;
4881 GRANT SELECT ON TABLE transactions TO PUBLIC;
4885 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4888 REVOKE ALL ON TABLE users FROM PUBLIC;
4889 REVOKE ALL ON TABLE users FROM wbadm;
4890 GRANT ALL ON TABLE users TO wbadm;
4891 GRANT SELECT ON TABLE users TO PUBLIC;
4894 SET search_path = "hurd-i386", pg_catalog;
4897 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4900 REVOKE ALL ON TABLE packages FROM PUBLIC;
4901 REVOKE ALL ON TABLE packages FROM wbadm;
4902 GRANT ALL ON TABLE packages TO wbadm;
4903 GRANT ALL ON TABLE packages TO "hurd-i386";
4904 GRANT SELECT ON TABLE packages TO wb_security;
4908 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4911 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4912 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4913 GRANT ALL ON TABLE pkg_history TO wbadm;
4914 GRANT ALL ON TABLE pkg_history TO "hurd-i386";
4915 GRANT SELECT ON TABLE pkg_history TO wb_security;
4919 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4922 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4923 REVOKE ALL ON TABLE transactions FROM wbadm;
4924 GRANT ALL ON TABLE transactions TO wbadm;
4925 GRANT SELECT,INSERT ON TABLE transactions TO "hurd-i386";
4926 GRANT SELECT ON TABLE transactions TO wb_security;
4930 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4933 REVOKE ALL ON TABLE users FROM PUBLIC;
4934 REVOKE ALL ON TABLE users FROM wbadm;
4935 GRANT ALL ON TABLE users TO wbadm;
4936 GRANT ALL ON TABLE users TO "hurd-i386";
4939 SET search_path = "hurd-i386_public", pg_catalog;
4942 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4945 REVOKE ALL ON TABLE packages FROM PUBLIC;
4946 REVOKE ALL ON TABLE packages FROM wbadm;
4947 GRANT ALL ON TABLE packages TO wbadm;
4948 GRANT SELECT ON TABLE packages TO PUBLIC;
4952 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4955 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4956 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4957 GRANT ALL ON TABLE pkg_history TO wbadm;
4958 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4962 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4965 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4966 REVOKE ALL ON TABLE transactions FROM wbadm;
4967 GRANT ALL ON TABLE transactions TO wbadm;
4968 GRANT SELECT ON TABLE transactions TO PUBLIC;
4972 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4975 REVOKE ALL ON TABLE users FROM PUBLIC;
4976 REVOKE ALL ON TABLE users FROM wbadm;
4977 GRANT ALL ON TABLE users TO wbadm;
4978 GRANT SELECT ON TABLE users TO PUBLIC;
4981 SET search_path = i386, pg_catalog;
4984 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4987 REVOKE ALL ON TABLE packages FROM PUBLIC;
4988 REVOKE ALL ON TABLE packages FROM wbadm;
4989 GRANT ALL ON TABLE packages TO wbadm;
4990 GRANT ALL ON TABLE packages TO i386;
4991 GRANT SELECT ON TABLE packages TO wb_security;
4995 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4998 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4999 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5000 GRANT ALL ON TABLE pkg_history TO wbadm;
5001 GRANT ALL ON TABLE pkg_history TO i386;
5002 GRANT SELECT ON TABLE pkg_history TO wb_security;
5006 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
5009 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5010 REVOKE ALL ON TABLE transactions FROM wbadm;
5011 GRANT ALL ON TABLE transactions TO wbadm;
5012 GRANT SELECT,INSERT ON TABLE transactions TO i386;
5013 GRANT SELECT ON TABLE transactions TO wb_security;
5017 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
5020 REVOKE ALL ON TABLE users FROM PUBLIC;
5021 REVOKE ALL ON TABLE users FROM wbadm;
5022 GRANT ALL ON TABLE users TO wbadm;
5023 GRANT ALL ON TABLE users TO i386;
5026 SET search_path = i386_public, pg_catalog;
5029 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5032 REVOKE ALL ON TABLE packages FROM PUBLIC;
5033 REVOKE ALL ON TABLE packages FROM wbadm;
5034 GRANT ALL ON TABLE packages TO wbadm;
5035 GRANT SELECT ON TABLE packages TO PUBLIC;
5039 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5042 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5043 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5044 GRANT ALL ON TABLE pkg_history TO wbadm;
5045 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5049 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5052 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5053 REVOKE ALL ON TABLE transactions FROM wbadm;
5054 GRANT ALL ON TABLE transactions TO wbadm;
5055 GRANT SELECT ON TABLE transactions TO PUBLIC;
5059 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5062 REVOKE ALL ON TABLE users FROM PUBLIC;
5063 REVOKE ALL ON TABLE users FROM wbadm;
5064 GRANT ALL ON TABLE users TO wbadm;
5065 GRANT SELECT ON TABLE users TO PUBLIC;
5068 SET search_path = ia64, pg_catalog;
5071 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5074 REVOKE ALL ON TABLE packages FROM PUBLIC;
5075 REVOKE ALL ON TABLE packages FROM wbadm;
5076 GRANT ALL ON TABLE packages TO wbadm;
5077 GRANT ALL ON TABLE packages TO ia64;
5078 GRANT SELECT ON TABLE packages TO wb_security;
5082 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5085 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5086 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5087 GRANT ALL ON TABLE pkg_history TO wbadm;
5088 GRANT ALL ON TABLE pkg_history TO ia64;
5089 GRANT SELECT ON TABLE pkg_history TO wb_security;
5093 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5096 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5097 REVOKE ALL ON TABLE transactions FROM wbadm;
5098 GRANT ALL ON TABLE transactions TO wbadm;
5099 GRANT SELECT,INSERT ON TABLE transactions TO ia64;
5100 GRANT SELECT ON TABLE transactions TO wb_security;
5104 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5107 REVOKE ALL ON TABLE users FROM PUBLIC;
5108 REVOKE ALL ON TABLE users FROM wbadm;
5109 GRANT ALL ON TABLE users TO wbadm;
5110 GRANT ALL ON TABLE users TO ia64;
5113 SET search_path = ia64_public, pg_catalog;
5116 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5119 REVOKE ALL ON TABLE packages FROM PUBLIC;
5120 REVOKE ALL ON TABLE packages FROM wbadm;
5121 GRANT ALL ON TABLE packages TO wbadm;
5122 GRANT SELECT ON TABLE packages TO PUBLIC;
5126 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5129 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5130 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5131 GRANT ALL ON TABLE pkg_history TO wbadm;
5132 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5136 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5139 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5140 REVOKE ALL ON TABLE transactions FROM wbadm;
5141 GRANT ALL ON TABLE transactions TO wbadm;
5142 GRANT SELECT ON TABLE transactions TO PUBLIC;
5146 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5149 REVOKE ALL ON TABLE users FROM PUBLIC;
5150 REVOKE ALL ON TABLE users FROM wbadm;
5151 GRANT ALL ON TABLE users TO wbadm;
5152 GRANT SELECT ON TABLE users TO PUBLIC;
5155 SET search_path = "kfreebsd-amd64", pg_catalog;
5158 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5161 REVOKE ALL ON TABLE packages FROM PUBLIC;
5162 REVOKE ALL ON TABLE packages FROM wbadm;
5163 GRANT ALL ON TABLE packages TO wbadm;
5164 GRANT ALL ON TABLE packages TO "kfreebsd-amd64";
5165 GRANT SELECT ON TABLE packages TO wb_security;
5169 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5172 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5173 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5174 GRANT ALL ON TABLE pkg_history TO wbadm;
5175 GRANT ALL ON TABLE pkg_history TO "kfreebsd-amd64";
5176 GRANT SELECT ON TABLE pkg_history TO wb_security;
5180 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5183 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5184 REVOKE ALL ON TABLE transactions FROM wbadm;
5185 GRANT ALL ON TABLE transactions TO wbadm;
5186 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-amd64";
5187 GRANT SELECT ON TABLE transactions TO wb_security;
5191 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5194 REVOKE ALL ON TABLE users FROM PUBLIC;
5195 REVOKE ALL ON TABLE users FROM wbadm;
5196 GRANT ALL ON TABLE users TO wbadm;
5197 GRANT ALL ON TABLE users TO "kfreebsd-amd64";
5200 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5203 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5206 REVOKE ALL ON TABLE packages FROM PUBLIC;
5207 REVOKE ALL ON TABLE packages FROM wbadm;
5208 GRANT ALL ON TABLE packages TO wbadm;
5209 GRANT SELECT ON TABLE packages TO PUBLIC;
5213 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5216 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5217 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5218 GRANT ALL ON TABLE pkg_history TO wbadm;
5219 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5223 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5226 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5227 REVOKE ALL ON TABLE transactions FROM wbadm;
5228 GRANT ALL ON TABLE transactions TO wbadm;
5229 GRANT SELECT ON TABLE transactions TO PUBLIC;
5233 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5236 REVOKE ALL ON TABLE users FROM PUBLIC;
5237 REVOKE ALL ON TABLE users FROM wbadm;
5238 GRANT ALL ON TABLE users TO wbadm;
5239 GRANT SELECT ON TABLE users TO PUBLIC;
5242 SET search_path = "kfreebsd-i386", pg_catalog;
5245 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5248 REVOKE ALL ON TABLE packages FROM PUBLIC;
5249 REVOKE ALL ON TABLE packages FROM wbadm;
5250 GRANT ALL ON TABLE packages TO wbadm;
5251 GRANT ALL ON TABLE packages TO "kfreebsd-i386";
5252 GRANT SELECT ON TABLE packages TO wb_security;
5256 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5259 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5260 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5261 GRANT ALL ON TABLE pkg_history TO wbadm;
5262 GRANT ALL ON TABLE pkg_history TO "kfreebsd-i386";
5263 GRANT SELECT ON TABLE pkg_history TO wb_security;
5267 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5270 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5271 REVOKE ALL ON TABLE transactions FROM wbadm;
5272 GRANT ALL ON TABLE transactions TO wbadm;
5273 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-i386";
5274 GRANT SELECT ON TABLE transactions TO wb_security;
5278 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5281 REVOKE ALL ON TABLE users FROM PUBLIC;
5282 REVOKE ALL ON TABLE users FROM wbadm;
5283 GRANT ALL ON TABLE users TO wbadm;
5284 GRANT ALL ON TABLE users TO "kfreebsd-i386";
5287 SET search_path = "kfreebsd-i386_public", pg_catalog;
5290 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5293 REVOKE ALL ON TABLE packages FROM PUBLIC;
5294 REVOKE ALL ON TABLE packages FROM wbadm;
5295 GRANT ALL ON TABLE packages TO wbadm;
5296 GRANT SELECT ON TABLE packages TO PUBLIC;
5300 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5303 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5304 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5305 GRANT ALL ON TABLE pkg_history TO wbadm;
5306 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5310 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5313 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5314 REVOKE ALL ON TABLE transactions FROM wbadm;
5315 GRANT ALL ON TABLE transactions TO wbadm;
5316 GRANT SELECT ON TABLE transactions TO PUBLIC;
5320 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5323 REVOKE ALL ON TABLE users FROM PUBLIC;
5324 REVOKE ALL ON TABLE users FROM wbadm;
5325 GRANT ALL ON TABLE users TO wbadm;
5326 GRANT SELECT ON TABLE users TO PUBLIC;
5329 SET search_path = mips, pg_catalog;
5332 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5335 REVOKE ALL ON TABLE packages FROM PUBLIC;
5336 REVOKE ALL ON TABLE packages FROM wbadm;
5337 GRANT ALL ON TABLE packages TO wbadm;
5338 GRANT ALL ON TABLE packages TO mips;
5339 GRANT SELECT ON TABLE packages TO wb_security;
5343 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5346 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5347 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5348 GRANT ALL ON TABLE pkg_history TO wbadm;
5349 GRANT ALL ON TABLE pkg_history TO mips;
5350 GRANT SELECT ON TABLE pkg_history TO wb_security;
5354 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5357 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5358 REVOKE ALL ON TABLE transactions FROM wbadm;
5359 GRANT ALL ON TABLE transactions TO wbadm;
5360 GRANT SELECT,INSERT ON TABLE transactions TO mips;
5361 GRANT SELECT ON TABLE transactions TO wb_security;
5365 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5368 REVOKE ALL ON TABLE users FROM PUBLIC;
5369 REVOKE ALL ON TABLE users FROM wbadm;
5370 GRANT ALL ON TABLE users TO wbadm;
5371 GRANT ALL ON TABLE users TO mips;
5374 SET search_path = mips_public, pg_catalog;
5377 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5380 REVOKE ALL ON TABLE packages FROM PUBLIC;
5381 REVOKE ALL ON TABLE packages FROM wbadm;
5382 GRANT ALL ON TABLE packages TO wbadm;
5383 GRANT SELECT ON TABLE packages TO PUBLIC;
5387 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5390 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5391 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5392 GRANT ALL ON TABLE pkg_history TO wbadm;
5393 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5397 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5400 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5401 REVOKE ALL ON TABLE transactions FROM wbadm;
5402 GRANT ALL ON TABLE transactions TO wbadm;
5403 GRANT SELECT ON TABLE transactions TO PUBLIC;
5407 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5410 REVOKE ALL ON TABLE users FROM PUBLIC;
5411 REVOKE ALL ON TABLE users FROM wbadm;
5412 GRANT ALL ON TABLE users TO wbadm;
5413 GRANT SELECT ON TABLE users TO PUBLIC;
5416 SET search_path = mipsel, pg_catalog;
5419 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5422 REVOKE ALL ON TABLE packages FROM PUBLIC;
5423 REVOKE ALL ON TABLE packages FROM wbadm;
5424 GRANT ALL ON TABLE packages TO wbadm;
5425 GRANT ALL ON TABLE packages TO mipsel;
5426 GRANT SELECT ON TABLE packages TO wb_security;
5430 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5433 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5434 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5435 GRANT ALL ON TABLE pkg_history TO wbadm;
5436 GRANT ALL ON TABLE pkg_history TO mipsel;
5437 GRANT SELECT ON TABLE pkg_history TO wb_security;
5441 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5444 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5445 REVOKE ALL ON TABLE transactions FROM wbadm;
5446 GRANT ALL ON TABLE transactions TO wbadm;
5447 GRANT SELECT,INSERT ON TABLE transactions TO mipsel;
5448 GRANT SELECT ON TABLE transactions TO wb_security;
5452 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5455 REVOKE ALL ON TABLE users FROM PUBLIC;
5456 REVOKE ALL ON TABLE users FROM wbadm;
5457 GRANT ALL ON TABLE users TO wbadm;
5458 GRANT ALL ON TABLE users TO mipsel;
5461 SET search_path = mipsel_public, pg_catalog;
5464 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5467 REVOKE ALL ON TABLE packages FROM PUBLIC;
5468 REVOKE ALL ON TABLE packages FROM wbadm;
5469 GRANT ALL ON TABLE packages TO wbadm;
5470 GRANT SELECT ON TABLE packages TO PUBLIC;
5474 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5477 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5478 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5479 GRANT ALL ON TABLE pkg_history TO wbadm;
5480 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5484 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5487 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5488 REVOKE ALL ON TABLE transactions FROM wbadm;
5489 GRANT ALL ON TABLE transactions TO wbadm;
5490 GRANT SELECT ON TABLE transactions TO PUBLIC;
5494 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5497 REVOKE ALL ON TABLE users FROM PUBLIC;
5498 REVOKE ALL ON TABLE users FROM wbadm;
5499 GRANT ALL ON TABLE users TO wbadm;
5500 GRANT SELECT ON TABLE users TO PUBLIC;
5503 SET search_path = powerpc, pg_catalog;
5506 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5509 REVOKE ALL ON TABLE packages FROM PUBLIC;
5510 REVOKE ALL ON TABLE packages FROM wbadm;
5511 GRANT ALL ON TABLE packages TO wbadm;
5512 GRANT ALL ON TABLE packages TO powerpc;
5513 GRANT SELECT ON TABLE packages TO wb_security;
5517 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5520 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5521 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5522 GRANT ALL ON TABLE pkg_history TO wbadm;
5523 GRANT ALL ON TABLE pkg_history TO powerpc;
5524 GRANT SELECT ON TABLE pkg_history TO wb_security;
5528 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5531 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5532 REVOKE ALL ON TABLE transactions FROM wbadm;
5533 GRANT ALL ON TABLE transactions TO wbadm;
5534 GRANT SELECT,INSERT ON TABLE transactions TO powerpc;
5535 GRANT SELECT ON TABLE transactions TO wb_security;
5539 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5542 REVOKE ALL ON TABLE users FROM PUBLIC;
5543 REVOKE ALL ON TABLE users FROM wbadm;
5544 GRANT ALL ON TABLE users TO wbadm;
5545 GRANT ALL ON TABLE users TO powerpc;
5548 SET search_path = powerpc_public, pg_catalog;
5551 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5554 REVOKE ALL ON TABLE packages FROM PUBLIC;
5555 REVOKE ALL ON TABLE packages FROM wbadm;
5556 GRANT ALL ON TABLE packages TO wbadm;
5557 GRANT SELECT ON TABLE packages TO PUBLIC;
5561 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5564 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5565 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5566 GRANT ALL ON TABLE pkg_history TO wbadm;
5567 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5571 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5574 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5575 REVOKE ALL ON TABLE transactions FROM wbadm;
5576 GRANT ALL ON TABLE transactions TO wbadm;
5577 GRANT SELECT ON TABLE transactions TO PUBLIC;
5581 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5584 REVOKE ALL ON TABLE users FROM PUBLIC;
5585 REVOKE ALL ON TABLE users FROM wbadm;
5586 GRANT ALL ON TABLE users TO wbadm;
5587 GRANT SELECT ON TABLE users TO PUBLIC;
5590 SET search_path = public, pg_catalog;
5593 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5596 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5597 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5598 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5599 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5602 SET search_path = s390, pg_catalog;
5605 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5608 REVOKE ALL ON TABLE packages FROM PUBLIC;
5609 REVOKE ALL ON TABLE packages FROM wbadm;
5610 GRANT ALL ON TABLE packages TO wbadm;
5611 GRANT ALL ON TABLE packages TO s390;
5612 GRANT SELECT ON TABLE packages TO wb_security;
5615 SET search_path = sparc, pg_catalog;
5618 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5621 REVOKE ALL ON TABLE packages FROM PUBLIC;
5622 REVOKE ALL ON TABLE packages FROM wbadm;
5623 GRANT ALL ON TABLE packages TO wbadm;
5624 GRANT ALL ON TABLE packages TO sparc;
5625 GRANT SELECT ON TABLE packages TO wb_security;
5628 SET search_path = public, pg_catalog;
5631 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5634 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5635 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5636 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5637 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5641 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
5644 REVOKE ALL ON TABLE distributions FROM PUBLIC;
5645 REVOKE ALL ON TABLE distributions FROM wbadm;
5646 GRANT ALL ON TABLE distributions TO wbadm;
5647 GRANT SELECT ON TABLE distributions TO PUBLIC;
5650 SET search_path = s390, pg_catalog;
5653 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5656 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5657 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5658 GRANT ALL ON TABLE pkg_history TO wbadm;
5659 GRANT ALL ON TABLE pkg_history TO s390;
5660 GRANT SELECT ON TABLE pkg_history TO wb_security;
5663 SET search_path = s390_public, pg_catalog;
5666 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5669 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5670 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5671 GRANT ALL ON TABLE pkg_history TO wbadm;
5672 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5675 SET search_path = sparc, pg_catalog;
5678 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5681 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5682 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5683 GRANT ALL ON TABLE pkg_history TO wbadm;
5684 GRANT ALL ON TABLE pkg_history TO sparc;
5685 GRANT SELECT ON TABLE pkg_history TO wb_security;
5688 SET search_path = sparc_public, pg_catalog;
5691 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5694 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5695 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5696 GRANT ALL ON TABLE pkg_history TO wbadm;
5697 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5700 SET search_path = public, pg_catalog;
5703 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5706 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5707 REVOKE ALL ON TABLE lastlog FROM wbadm;
5708 GRANT ALL ON TABLE lastlog TO wbadm;
5709 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5713 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5716 REVOKE ALL ON TABLE log FROM PUBLIC;
5717 REVOKE ALL ON TABLE log FROM wbadm;
5718 GRANT ALL ON TABLE log TO wbadm;
5719 GRANT SELECT ON TABLE log TO PUBLIC;
5723 -- Name: log_v2; Type: ACL; Schema: public; Owner: pkern
5726 REVOKE ALL ON TABLE log_v2 FROM PUBLIC;
5727 REVOKE ALL ON TABLE log_v2 FROM pkern;
5728 GRANT ALL ON TABLE log_v2 TO pkern;
5729 GRANT SELECT ON TABLE log_v2 TO PUBLIC;
5732 SET search_path = s390_public, pg_catalog;
5735 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5738 REVOKE ALL ON TABLE packages FROM PUBLIC;
5739 REVOKE ALL ON TABLE packages FROM wbadm;
5740 GRANT ALL ON TABLE packages TO wbadm;
5741 GRANT SELECT ON TABLE packages TO PUBLIC;
5744 SET search_path = sparc_public, pg_catalog;
5747 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5750 REVOKE ALL ON TABLE packages FROM PUBLIC;
5751 REVOKE ALL ON TABLE packages FROM wbadm;
5752 GRANT ALL ON TABLE packages TO wbadm;
5753 GRANT SELECT ON TABLE packages TO PUBLIC;
5756 SET search_path = public, pg_catalog;
5759 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5762 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5763 REVOKE ALL ON TABLE packages_all FROM wbadm;
5764 GRANT ALL ON TABLE packages_all TO wbadm;
5765 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5768 SET search_path = s390, pg_catalog;
5771 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5774 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5775 REVOKE ALL ON TABLE transactions FROM wbadm;
5776 GRANT ALL ON TABLE transactions TO wbadm;
5777 GRANT SELECT,INSERT ON TABLE transactions TO s390;
5778 GRANT SELECT ON TABLE transactions TO wb_security;
5782 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5785 REVOKE ALL ON TABLE users FROM PUBLIC;
5786 REVOKE ALL ON TABLE users FROM wbadm;
5787 GRANT ALL ON TABLE users TO wbadm;
5788 GRANT ALL ON TABLE users TO s390;
5791 SET search_path = s390_public, pg_catalog;
5794 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5797 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5798 REVOKE ALL ON TABLE transactions FROM wbadm;
5799 GRANT ALL ON TABLE transactions TO wbadm;
5800 GRANT SELECT ON TABLE transactions TO PUBLIC;
5804 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5807 REVOKE ALL ON TABLE users FROM PUBLIC;
5808 REVOKE ALL ON TABLE users FROM wbadm;
5809 GRANT ALL ON TABLE users TO wbadm;
5810 GRANT SELECT ON TABLE users TO PUBLIC;
5813 SET search_path = sparc, pg_catalog;
5816 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5819 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5820 REVOKE ALL ON TABLE transactions FROM wbadm;
5821 GRANT ALL ON TABLE transactions TO wbadm;
5822 GRANT SELECT,INSERT ON TABLE transactions TO sparc;
5823 GRANT SELECT ON TABLE transactions TO wb_security;
5827 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5830 REVOKE ALL ON TABLE users FROM PUBLIC;
5831 REVOKE ALL ON TABLE users FROM wbadm;
5832 GRANT ALL ON TABLE users TO wbadm;
5833 GRANT ALL ON TABLE users TO sparc;
5836 SET search_path = sparc_public, pg_catalog;
5839 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5842 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5843 REVOKE ALL ON TABLE transactions FROM wbadm;
5844 GRANT ALL ON TABLE transactions TO wbadm;
5845 GRANT SELECT ON TABLE transactions TO PUBLIC;
5849 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5852 REVOKE ALL ON TABLE users FROM PUBLIC;
5853 REVOKE ALL ON TABLE users FROM wbadm;
5854 GRANT ALL ON TABLE users TO wbadm;
5855 GRANT SELECT ON TABLE users TO PUBLIC;
5859 -- PostgreSQL database dump complete