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
946 ALTER TABLE alpha.packages OWNER TO wbadm;
949 -- Name: pkg_history; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
952 CREATE TABLE pkg_history (
953 package character varying NOT NULL,
954 distribution character varying NOT NULL,
955 version character varying NOT NULL,
956 "timestamp" timestamp without time zone NOT NULL,
957 result character varying NOT NULL,
963 ALTER TABLE alpha.pkg_history OWNER TO wbadm;
966 -- Name: transactions; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
969 CREATE TABLE transactions (
970 package character varying,
971 distribution character varying,
972 version character varying,
973 action character varying,
974 prevstate character varying,
975 state character varying,
976 real_user character varying,
977 set_user character varying,
978 "time" timestamp without time zone
982 ALTER TABLE alpha.transactions OWNER TO wbadm;
985 -- Name: users; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
989 username character varying NOT NULL,
990 distribution character varying NOT NULL,
991 last_seen timestamp without time zone
995 ALTER TABLE alpha.users OWNER TO wbadm;
997 SET search_path = alpha_public, pg_catalog;
1000 -- Name: packages; Type: VIEW; Schema: alpha_public; Owner: wbadm
1003 CREATE VIEW packages AS
1004 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 FROM alpha.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1007 ALTER TABLE alpha_public.packages OWNER TO wbadm;
1010 -- Name: pkg_history; Type: VIEW; Schema: alpha_public; Owner: wbadm
1013 CREATE VIEW pkg_history AS
1014 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);
1017 ALTER TABLE alpha_public.pkg_history OWNER TO wbadm;
1020 -- Name: transactions; Type: VIEW; Schema: alpha_public; Owner: wbadm
1023 CREATE VIEW transactions AS
1024 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);
1027 ALTER TABLE alpha_public.transactions OWNER TO wbadm;
1030 -- Name: users; Type: VIEW; Schema: alpha_public; Owner: wbadm
1033 CREATE VIEW users AS
1034 SELECT users.username, users.distribution, users.last_seen FROM alpha.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1037 ALTER TABLE alpha_public.users OWNER TO wbadm;
1039 SET search_path = amd64, pg_catalog;
1042 -- Name: packages; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1045 CREATE TABLE packages (
1046 package character varying NOT NULL,
1047 distribution character varying NOT NULL,
1048 version character varying,
1049 state character varying,
1050 section character varying,
1051 priority character varying,
1052 installed_version character varying,
1053 previous_state character varying,
1054 state_change timestamp without time zone,
1055 notes character varying,
1056 builder character varying,
1059 binary_nmu_version integer,
1060 binary_nmu_changelog character varying,
1061 failed_category character varying,
1062 permbuildpri integer,
1064 depends character varying,
1065 rel character varying,
1067 extra_depends character varying,
1068 extra_conflicts character varying
1072 ALTER TABLE amd64.packages OWNER TO wbadm;
1075 -- Name: pkg_history; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1078 CREATE TABLE pkg_history (
1079 package character varying NOT NULL,
1080 distribution character varying NOT NULL,
1081 version character varying NOT NULL,
1082 "timestamp" timestamp without time zone NOT NULL,
1083 result character varying NOT NULL,
1089 ALTER TABLE amd64.pkg_history OWNER TO wbadm;
1092 -- Name: transactions; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1095 CREATE TABLE transactions (
1096 package character varying,
1097 distribution character varying,
1098 version character varying,
1099 action character varying,
1100 prevstate character varying,
1101 state character varying,
1102 real_user character varying,
1103 set_user character varying,
1104 "time" timestamp without time zone
1108 ALTER TABLE amd64.transactions OWNER TO wbadm;
1111 -- Name: users; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1114 CREATE TABLE users (
1115 username character varying NOT NULL,
1116 distribution character varying NOT NULL,
1117 last_seen timestamp without time zone
1121 ALTER TABLE amd64.users OWNER TO wbadm;
1123 SET search_path = amd64_public, pg_catalog;
1126 -- Name: packages; Type: VIEW; Schema: amd64_public; Owner: wbadm
1129 CREATE VIEW packages AS
1130 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 FROM amd64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1133 ALTER TABLE amd64_public.packages OWNER TO wbadm;
1136 -- Name: pkg_history; Type: VIEW; Schema: amd64_public; Owner: wbadm
1139 CREATE VIEW pkg_history AS
1140 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);
1143 ALTER TABLE amd64_public.pkg_history OWNER TO wbadm;
1146 -- Name: transactions; Type: VIEW; Schema: amd64_public; Owner: wbadm
1149 CREATE VIEW transactions AS
1150 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);
1153 ALTER TABLE amd64_public.transactions OWNER TO wbadm;
1156 -- Name: users; Type: VIEW; Schema: amd64_public; Owner: wbadm
1159 CREATE VIEW users AS
1160 SELECT users.username, users.distribution, users.last_seen FROM amd64.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1163 ALTER TABLE amd64_public.users OWNER TO wbadm;
1165 SET search_path = arm, pg_catalog;
1168 -- Name: packages; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1171 CREATE TABLE packages (
1172 package character varying NOT NULL,
1173 distribution character varying NOT NULL,
1174 version character varying,
1175 state character varying,
1176 section character varying,
1177 priority character varying,
1178 installed_version character varying,
1179 previous_state character varying,
1180 state_change timestamp without time zone,
1181 notes character varying,
1182 builder character varying,
1185 binary_nmu_version integer,
1186 binary_nmu_changelog character varying,
1187 failed_category character varying,
1188 permbuildpri integer,
1190 depends character varying,
1191 rel character varying,
1193 extra_depends character varying,
1194 extra_conflicts character varying
1198 ALTER TABLE arm.packages OWNER TO wbadm;
1201 -- Name: pkg_history; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1204 CREATE TABLE pkg_history (
1205 package character varying NOT NULL,
1206 distribution character varying NOT NULL,
1207 version character varying NOT NULL,
1208 "timestamp" timestamp without time zone NOT NULL,
1209 result character varying NOT NULL,
1215 ALTER TABLE arm.pkg_history OWNER TO wbadm;
1218 -- Name: transactions; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1221 CREATE TABLE transactions (
1222 package character varying,
1223 distribution character varying,
1224 version character varying,
1225 action character varying,
1226 prevstate character varying,
1227 state character varying,
1228 real_user character varying,
1229 set_user character varying,
1230 "time" timestamp without time zone
1234 ALTER TABLE arm.transactions OWNER TO wbadm;
1237 -- Name: users; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1240 CREATE TABLE users (
1241 username character varying NOT NULL,
1242 distribution character varying NOT NULL,
1243 last_seen timestamp without time zone
1247 ALTER TABLE arm.users OWNER TO wbadm;
1249 SET search_path = arm_public, pg_catalog;
1252 -- Name: packages; Type: VIEW; Schema: arm_public; Owner: wbadm
1255 CREATE VIEW packages AS
1256 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 FROM arm.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1259 ALTER TABLE arm_public.packages OWNER TO wbadm;
1262 -- Name: pkg_history; Type: VIEW; Schema: arm_public; Owner: wbadm
1265 CREATE VIEW pkg_history AS
1266 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);
1269 ALTER TABLE arm_public.pkg_history OWNER TO wbadm;
1272 -- Name: transactions; Type: VIEW; Schema: arm_public; Owner: wbadm
1275 CREATE VIEW transactions AS
1276 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);
1279 ALTER TABLE arm_public.transactions OWNER TO wbadm;
1282 -- Name: users; Type: VIEW; Schema: arm_public; Owner: wbadm
1285 CREATE VIEW users AS
1286 SELECT users.username, users.distribution, users.last_seen FROM arm.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1289 ALTER TABLE arm_public.users OWNER TO wbadm;
1291 SET search_path = armel, pg_catalog;
1294 -- Name: packages; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1297 CREATE TABLE packages (
1298 package character varying NOT NULL,
1299 distribution character varying NOT NULL,
1300 version character varying,
1301 state character varying,
1302 section character varying,
1303 priority character varying,
1304 installed_version character varying,
1305 previous_state character varying,
1306 state_change timestamp without time zone,
1307 notes character varying,
1308 builder character varying,
1311 binary_nmu_version integer,
1312 binary_nmu_changelog character varying,
1313 failed_category character varying,
1314 permbuildpri integer,
1316 depends character varying,
1317 rel character varying,
1319 extra_depends character varying,
1320 extra_conflicts character varying
1324 ALTER TABLE armel.packages OWNER TO wbadm;
1327 -- Name: pkg_history; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1330 CREATE TABLE pkg_history (
1331 package character varying NOT NULL,
1332 distribution character varying NOT NULL,
1333 version character varying NOT NULL,
1334 "timestamp" timestamp without time zone NOT NULL,
1335 result character varying NOT NULL,
1341 ALTER TABLE armel.pkg_history OWNER TO wbadm;
1344 -- Name: transactions; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1347 CREATE TABLE transactions (
1348 package character varying,
1349 distribution character varying,
1350 version character varying,
1351 action character varying,
1352 prevstate character varying,
1353 state character varying,
1354 real_user character varying,
1355 set_user character varying,
1356 "time" timestamp without time zone
1360 ALTER TABLE armel.transactions OWNER TO wbadm;
1363 -- Name: users; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1366 CREATE TABLE users (
1367 username character varying NOT NULL,
1368 distribution character varying NOT NULL,
1369 last_seen timestamp without time zone
1373 ALTER TABLE armel.users OWNER TO wbadm;
1375 SET search_path = armel_public, pg_catalog;
1378 -- Name: packages; Type: VIEW; Schema: armel_public; Owner: wbadm
1381 CREATE VIEW packages AS
1382 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 FROM armel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1385 ALTER TABLE armel_public.packages OWNER TO wbadm;
1388 -- Name: pkg_history; Type: VIEW; Schema: armel_public; Owner: wbadm
1391 CREATE VIEW pkg_history AS
1392 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);
1395 ALTER TABLE armel_public.pkg_history OWNER TO wbadm;
1398 -- Name: transactions; Type: VIEW; Schema: armel_public; Owner: wbadm
1401 CREATE VIEW transactions AS
1402 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);
1405 ALTER TABLE armel_public.transactions OWNER TO wbadm;
1408 -- Name: users; Type: VIEW; Schema: armel_public; Owner: wbadm
1411 CREATE VIEW users AS
1412 SELECT users.username, users.distribution, users.last_seen FROM armel.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1415 ALTER TABLE armel_public.users OWNER TO wbadm;
1417 SET search_path = hppa, pg_catalog;
1420 -- Name: packages; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1423 CREATE TABLE packages (
1424 package character varying NOT NULL,
1425 distribution character varying NOT NULL,
1426 version character varying,
1427 state character varying,
1428 section character varying,
1429 priority character varying,
1430 installed_version character varying,
1431 previous_state character varying,
1432 state_change timestamp without time zone,
1433 notes character varying,
1434 builder character varying,
1437 binary_nmu_version integer,
1438 binary_nmu_changelog character varying,
1439 failed_category character varying,
1440 permbuildpri integer,
1442 depends character varying,
1443 rel character varying,
1445 extra_depends character varying,
1446 extra_conflicts character varying
1450 ALTER TABLE hppa.packages OWNER TO wbadm;
1453 -- Name: pkg_history; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1456 CREATE TABLE pkg_history (
1457 package character varying NOT NULL,
1458 distribution character varying NOT NULL,
1459 version character varying NOT NULL,
1460 "timestamp" timestamp without time zone NOT NULL,
1461 result character varying NOT NULL,
1467 ALTER TABLE hppa.pkg_history OWNER TO wbadm;
1470 -- Name: transactions; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1473 CREATE TABLE transactions (
1474 package character varying,
1475 distribution character varying,
1476 version character varying,
1477 action character varying,
1478 prevstate character varying,
1479 state character varying,
1480 real_user character varying,
1481 set_user character varying,
1482 "time" timestamp without time zone
1486 ALTER TABLE hppa.transactions OWNER TO wbadm;
1489 -- Name: users; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1492 CREATE TABLE users (
1493 username character varying NOT NULL,
1494 distribution character varying NOT NULL,
1495 last_seen timestamp without time zone
1499 ALTER TABLE hppa.users OWNER TO wbadm;
1501 SET search_path = hppa_public, pg_catalog;
1504 -- Name: packages; Type: VIEW; Schema: hppa_public; Owner: wbadm
1507 CREATE VIEW packages AS
1508 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 FROM hppa.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1511 ALTER TABLE hppa_public.packages OWNER TO wbadm;
1514 -- Name: pkg_history; Type: VIEW; Schema: hppa_public; Owner: wbadm
1517 CREATE VIEW pkg_history AS
1518 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);
1521 ALTER TABLE hppa_public.pkg_history OWNER TO wbadm;
1524 -- Name: transactions; Type: VIEW; Schema: hppa_public; Owner: wbadm
1527 CREATE VIEW transactions AS
1528 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);
1531 ALTER TABLE hppa_public.transactions OWNER TO wbadm;
1534 -- Name: users; Type: VIEW; Schema: hppa_public; Owner: wbadm
1537 CREATE VIEW users AS
1538 SELECT users.username, users.distribution, users.last_seen FROM hppa.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1541 ALTER TABLE hppa_public.users OWNER TO wbadm;
1543 SET search_path = "hurd-i386", pg_catalog;
1546 -- Name: packages; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1549 CREATE TABLE packages (
1550 package character varying NOT NULL,
1551 distribution character varying NOT NULL,
1552 version character varying,
1553 state character varying,
1554 section character varying,
1555 priority character varying,
1556 installed_version character varying,
1557 previous_state character varying,
1558 state_change timestamp without time zone,
1559 notes character varying,
1560 builder character varying,
1563 binary_nmu_version integer,
1564 binary_nmu_changelog character varying,
1565 failed_category character varying,
1566 permbuildpri integer,
1568 depends character varying,
1569 rel character varying,
1571 extra_depends character varying,
1572 extra_conflicts character varying
1576 ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
1579 -- Name: pkg_history; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1582 CREATE TABLE pkg_history (
1583 package character varying NOT NULL,
1584 distribution character varying NOT NULL,
1585 version character varying NOT NULL,
1586 "timestamp" timestamp without time zone NOT NULL,
1587 result character varying NOT NULL,
1593 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
1596 -- Name: transactions; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1599 CREATE TABLE transactions (
1600 package character varying,
1601 distribution character varying,
1602 version character varying,
1603 action character varying,
1604 prevstate character varying,
1605 state character varying,
1606 real_user character varying,
1607 set_user character varying,
1608 "time" timestamp without time zone
1612 ALTER TABLE "hurd-i386".transactions OWNER TO wbadm;
1615 -- Name: users; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1618 CREATE TABLE users (
1619 username character varying NOT NULL,
1620 distribution character varying NOT NULL,
1621 last_seen timestamp without time zone
1625 ALTER TABLE "hurd-i386".users OWNER TO wbadm;
1627 SET search_path = "hurd-i386_public", pg_catalog;
1630 -- Name: packages; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1633 CREATE VIEW packages AS
1634 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 FROM "hurd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1637 ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
1640 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1643 CREATE VIEW pkg_history AS
1644 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);
1647 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
1650 -- Name: transactions; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1653 CREATE VIEW transactions AS
1654 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);
1657 ALTER TABLE "hurd-i386_public".transactions OWNER TO wbadm;
1660 -- Name: users; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1663 CREATE VIEW users AS
1664 SELECT users.username, users.distribution, users.last_seen FROM "hurd-i386".users WHERE ((users.distribution)::text !~~ '%-security'::text);
1667 ALTER TABLE "hurd-i386_public".users OWNER TO wbadm;
1669 SET search_path = i386, pg_catalog;
1672 -- Name: packages; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1675 CREATE TABLE packages (
1676 package character varying NOT NULL,
1677 distribution character varying NOT NULL,
1678 version character varying,
1679 state character varying,
1680 section character varying,
1681 priority character varying,
1682 installed_version character varying,
1683 previous_state character varying,
1684 state_change timestamp without time zone,
1685 notes character varying,
1686 builder character varying,
1689 binary_nmu_version integer,
1690 binary_nmu_changelog character varying,
1691 failed_category character varying,
1692 permbuildpri integer,
1694 depends character varying,
1695 rel character varying,
1697 extra_depends character varying,
1698 extra_conflicts character varying
1702 ALTER TABLE i386.packages OWNER TO wbadm;
1705 -- Name: pkg_history; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1708 CREATE TABLE pkg_history (
1709 package character varying NOT NULL,
1710 distribution character varying NOT NULL,
1711 version character varying NOT NULL,
1712 "timestamp" timestamp without time zone NOT NULL,
1713 result character varying NOT NULL,
1719 ALTER TABLE i386.pkg_history OWNER TO wbadm;
1722 -- Name: transactions; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1725 CREATE TABLE transactions (
1726 package character varying,
1727 distribution character varying,
1728 version character varying,
1729 action character varying,
1730 prevstate character varying,
1731 state character varying,
1732 real_user character varying,
1733 set_user character varying,
1734 "time" timestamp without time zone
1738 ALTER TABLE i386.transactions OWNER TO wbadm;
1741 -- Name: users; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1744 CREATE TABLE users (
1745 username character varying NOT NULL,
1746 distribution character varying NOT NULL,
1747 last_seen timestamp without time zone
1751 ALTER TABLE i386.users OWNER TO wbadm;
1753 SET search_path = i386_public, pg_catalog;
1756 -- Name: packages; Type: VIEW; Schema: i386_public; Owner: wbadm
1759 CREATE VIEW packages AS
1760 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 FROM i386.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1763 ALTER TABLE i386_public.packages OWNER TO wbadm;
1766 -- Name: pkg_history; Type: VIEW; Schema: i386_public; Owner: wbadm
1769 CREATE VIEW pkg_history AS
1770 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);
1773 ALTER TABLE i386_public.pkg_history OWNER TO wbadm;
1776 -- Name: transactions; Type: VIEW; Schema: i386_public; Owner: wbadm
1779 CREATE VIEW transactions AS
1780 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);
1783 ALTER TABLE i386_public.transactions OWNER TO wbadm;
1786 -- Name: users; Type: VIEW; Schema: i386_public; Owner: wbadm
1789 CREATE VIEW users AS
1790 SELECT users.username, users.distribution, users.last_seen FROM i386.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1793 ALTER TABLE i386_public.users OWNER TO wbadm;
1795 SET search_path = ia64, pg_catalog;
1798 -- Name: packages; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1801 CREATE TABLE packages (
1802 package character varying NOT NULL,
1803 distribution character varying NOT NULL,
1804 version character varying,
1805 state character varying,
1806 section character varying,
1807 priority character varying,
1808 installed_version character varying,
1809 previous_state character varying,
1810 state_change timestamp without time zone,
1811 notes character varying,
1812 builder character varying,
1815 binary_nmu_version integer,
1816 binary_nmu_changelog character varying,
1817 failed_category character varying,
1818 permbuildpri integer,
1820 depends character varying,
1821 rel character varying,
1823 extra_depends character varying,
1824 extra_conflicts character varying
1828 ALTER TABLE ia64.packages OWNER TO wbadm;
1831 -- Name: pkg_history; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1834 CREATE TABLE pkg_history (
1835 package character varying NOT NULL,
1836 distribution character varying NOT NULL,
1837 version character varying NOT NULL,
1838 "timestamp" timestamp without time zone NOT NULL,
1839 result character varying NOT NULL,
1845 ALTER TABLE ia64.pkg_history OWNER TO wbadm;
1848 -- Name: transactions; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1851 CREATE TABLE transactions (
1852 package character varying,
1853 distribution character varying,
1854 version character varying,
1855 action character varying,
1856 prevstate character varying,
1857 state character varying,
1858 real_user character varying,
1859 set_user character varying,
1860 "time" timestamp without time zone
1864 ALTER TABLE ia64.transactions OWNER TO wbadm;
1867 -- Name: users; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1870 CREATE TABLE users (
1871 username character varying NOT NULL,
1872 distribution character varying NOT NULL,
1873 last_seen timestamp without time zone
1877 ALTER TABLE ia64.users OWNER TO wbadm;
1879 SET search_path = ia64_public, pg_catalog;
1882 -- Name: packages; Type: VIEW; Schema: ia64_public; Owner: wbadm
1885 CREATE VIEW packages AS
1886 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 FROM ia64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1889 ALTER TABLE ia64_public.packages OWNER TO wbadm;
1892 -- Name: pkg_history; Type: VIEW; Schema: ia64_public; Owner: wbadm
1895 CREATE VIEW pkg_history AS
1896 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);
1899 ALTER TABLE ia64_public.pkg_history OWNER TO wbadm;
1902 -- Name: transactions; Type: VIEW; Schema: ia64_public; Owner: wbadm
1905 CREATE VIEW transactions AS
1906 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);
1909 ALTER TABLE ia64_public.transactions OWNER TO wbadm;
1912 -- Name: users; Type: VIEW; Schema: ia64_public; Owner: wbadm
1915 CREATE VIEW users AS
1916 SELECT users.username, users.distribution, users.last_seen FROM ia64.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1919 ALTER TABLE ia64_public.users OWNER TO wbadm;
1921 SET search_path = "kfreebsd-amd64", pg_catalog;
1924 -- Name: packages; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1927 CREATE TABLE packages (
1928 package character varying NOT NULL,
1929 distribution character varying NOT NULL,
1930 version character varying,
1931 state character varying,
1932 section character varying,
1933 priority character varying,
1934 installed_version character varying,
1935 previous_state character varying,
1936 state_change timestamp without time zone,
1937 notes character varying,
1938 builder character varying,
1941 binary_nmu_version integer,
1942 binary_nmu_changelog character varying,
1943 failed_category character varying,
1944 permbuildpri integer,
1946 depends character varying,
1947 rel character varying,
1949 extra_depends character varying,
1950 extra_conflicts character varying
1954 ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
1957 -- Name: pkg_history; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1960 CREATE TABLE pkg_history (
1961 package character varying NOT NULL,
1962 distribution character varying NOT NULL,
1963 version character varying NOT NULL,
1964 "timestamp" timestamp without time zone NOT NULL,
1965 result character varying NOT NULL,
1971 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
1974 -- Name: transactions; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1977 CREATE TABLE transactions (
1978 package character varying,
1979 distribution character varying,
1980 version character varying,
1981 action character varying,
1982 prevstate character varying,
1983 state character varying,
1984 real_user character varying,
1985 set_user character varying,
1986 "time" timestamp without time zone
1990 ALTER TABLE "kfreebsd-amd64".transactions OWNER TO wbadm;
1993 -- Name: users; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1996 CREATE TABLE users (
1997 username character varying NOT NULL,
1998 distribution character varying NOT NULL,
1999 last_seen timestamp without time zone
2003 ALTER TABLE "kfreebsd-amd64".users OWNER TO wbadm;
2005 SET search_path = "kfreebsd-amd64_public", pg_catalog;
2008 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2011 CREATE VIEW packages AS
2012 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 FROM "kfreebsd-amd64".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2015 ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
2018 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2021 CREATE VIEW pkg_history AS
2022 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);
2025 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
2028 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2031 CREATE VIEW transactions AS
2032 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);
2035 ALTER TABLE "kfreebsd-amd64_public".transactions OWNER TO wbadm;
2038 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2041 CREATE VIEW users AS
2042 SELECT users.username, users.distribution, users.last_seen FROM "kfreebsd-amd64".users WHERE ((users.distribution)::text !~~ '%-security'::text);
2045 ALTER TABLE "kfreebsd-amd64_public".users OWNER TO wbadm;
2047 SET search_path = "kfreebsd-i386", pg_catalog;
2050 -- Name: packages; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2053 CREATE TABLE packages (
2054 package character varying NOT NULL,
2055 distribution character varying NOT NULL,
2056 version character varying,
2057 state character varying,
2058 section character varying,
2059 priority character varying,
2060 installed_version character varying,
2061 previous_state character varying,
2062 state_change timestamp without time zone,
2063 notes character varying,
2064 builder character varying,
2067 binary_nmu_version integer,
2068 binary_nmu_changelog character varying,
2069 failed_category character varying,
2070 permbuildpri integer,
2072 depends character varying,
2073 rel character varying,
2075 extra_depends character varying,
2076 extra_conflicts character varying
2080 ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
2083 -- Name: pkg_history; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2086 CREATE TABLE pkg_history (
2087 package character varying NOT NULL,
2088 distribution character varying NOT NULL,
2089 version character varying NOT NULL,
2090 "timestamp" timestamp without time zone NOT NULL,
2091 result character varying NOT NULL,
2097 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
2100 -- Name: transactions; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2103 CREATE TABLE transactions (
2104 package character varying,
2105 distribution character varying,
2106 version character varying,
2107 action character varying,
2108 prevstate character varying,
2109 state character varying,
2110 real_user character varying,
2111 set_user character varying,
2112 "time" timestamp without time zone
2116 ALTER TABLE "kfreebsd-i386".transactions OWNER TO wbadm;
2119 -- Name: users; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2122 CREATE TABLE users (
2123 username character varying NOT NULL,
2124 distribution character varying NOT NULL,
2125 last_seen timestamp without time zone
2129 ALTER TABLE "kfreebsd-i386".users OWNER TO wbadm;
2131 SET search_path = "kfreebsd-i386_public", pg_catalog;
2134 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2137 CREATE VIEW packages AS
2138 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 FROM "kfreebsd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2141 ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
2144 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2147 CREATE VIEW pkg_history AS
2148 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);
2151 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
2154 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2157 CREATE VIEW transactions AS
2158 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);
2161 ALTER TABLE "kfreebsd-i386_public".transactions OWNER TO wbadm;
2164 -- Name: users; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2167 CREATE VIEW users AS
2168 SELECT users.username, users.distribution, users.last_seen FROM "kfreebsd-i386".users WHERE ((users.distribution)::text !~~ '%-security'::text);
2171 ALTER TABLE "kfreebsd-i386_public".users OWNER TO wbadm;
2173 SET search_path = mips, pg_catalog;
2176 -- Name: packages; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2179 CREATE TABLE packages (
2180 package character varying NOT NULL,
2181 distribution character varying NOT NULL,
2182 version character varying,
2183 state character varying,
2184 section character varying,
2185 priority character varying,
2186 installed_version character varying,
2187 previous_state character varying,
2188 state_change timestamp without time zone,
2189 notes character varying,
2190 builder character varying,
2193 binary_nmu_version integer,
2194 binary_nmu_changelog character varying,
2195 failed_category character varying,
2196 permbuildpri integer,
2198 depends character varying,
2199 rel character varying,
2201 extra_depends character varying,
2202 extra_conflicts character varying
2206 ALTER TABLE mips.packages OWNER TO wbadm;
2209 -- Name: pkg_history; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2212 CREATE TABLE pkg_history (
2213 package character varying NOT NULL,
2214 distribution character varying NOT NULL,
2215 version character varying NOT NULL,
2216 "timestamp" timestamp without time zone NOT NULL,
2217 result character varying NOT NULL,
2223 ALTER TABLE mips.pkg_history OWNER TO wbadm;
2226 -- Name: transactions; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2229 CREATE TABLE transactions (
2230 package character varying,
2231 distribution character varying,
2232 version character varying,
2233 action character varying,
2234 prevstate character varying,
2235 state character varying,
2236 real_user character varying,
2237 set_user character varying,
2238 "time" timestamp without time zone
2242 ALTER TABLE mips.transactions OWNER TO wbadm;
2245 -- Name: users; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2248 CREATE TABLE users (
2249 username character varying NOT NULL,
2250 distribution character varying NOT NULL,
2251 last_seen timestamp without time zone
2255 ALTER TABLE mips.users OWNER TO wbadm;
2257 SET search_path = mips_public, pg_catalog;
2260 -- Name: packages; Type: VIEW; Schema: mips_public; Owner: wbadm
2263 CREATE VIEW packages AS
2264 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 FROM mips.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2267 ALTER TABLE mips_public.packages OWNER TO wbadm;
2270 -- Name: pkg_history; Type: VIEW; Schema: mips_public; Owner: wbadm
2273 CREATE VIEW pkg_history AS
2274 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);
2277 ALTER TABLE mips_public.pkg_history OWNER TO wbadm;
2280 -- Name: transactions; Type: VIEW; Schema: mips_public; Owner: wbadm
2283 CREATE VIEW transactions AS
2284 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);
2287 ALTER TABLE mips_public.transactions OWNER TO wbadm;
2290 -- Name: users; Type: VIEW; Schema: mips_public; Owner: wbadm
2293 CREATE VIEW users AS
2294 SELECT users.username, users.distribution, users.last_seen FROM mips.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2297 ALTER TABLE mips_public.users OWNER TO wbadm;
2299 SET search_path = mipsel, pg_catalog;
2302 -- Name: packages; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2305 CREATE TABLE packages (
2306 package character varying NOT NULL,
2307 distribution character varying NOT NULL,
2308 version character varying,
2309 state character varying,
2310 section character varying,
2311 priority character varying,
2312 installed_version character varying,
2313 previous_state character varying,
2314 state_change timestamp without time zone,
2315 notes character varying,
2316 builder character varying,
2319 binary_nmu_version integer,
2320 binary_nmu_changelog character varying,
2321 failed_category character varying,
2322 permbuildpri integer,
2324 depends character varying,
2325 rel character varying,
2327 extra_depends character varying,
2328 extra_conflicts character varying
2332 ALTER TABLE mipsel.packages OWNER TO wbadm;
2335 -- Name: pkg_history; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2338 CREATE TABLE pkg_history (
2339 package character varying NOT NULL,
2340 distribution character varying NOT NULL,
2341 version character varying NOT NULL,
2342 "timestamp" timestamp without time zone NOT NULL,
2343 result character varying NOT NULL,
2349 ALTER TABLE mipsel.pkg_history OWNER TO wbadm;
2352 -- Name: transactions; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2355 CREATE TABLE transactions (
2356 package character varying,
2357 distribution character varying,
2358 version character varying,
2359 action character varying,
2360 prevstate character varying,
2361 state character varying,
2362 real_user character varying,
2363 set_user character varying,
2364 "time" timestamp without time zone
2368 ALTER TABLE mipsel.transactions OWNER TO wbadm;
2371 -- Name: users; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2374 CREATE TABLE users (
2375 username character varying NOT NULL,
2376 distribution character varying NOT NULL,
2377 last_seen timestamp without time zone
2381 ALTER TABLE mipsel.users OWNER TO wbadm;
2383 SET search_path = mipsel_public, pg_catalog;
2386 -- Name: packages; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2389 CREATE VIEW packages AS
2390 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 FROM mipsel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2393 ALTER TABLE mipsel_public.packages OWNER TO wbadm;
2396 -- Name: pkg_history; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2399 CREATE VIEW pkg_history AS
2400 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);
2403 ALTER TABLE mipsel_public.pkg_history OWNER TO wbadm;
2406 -- Name: transactions; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2409 CREATE VIEW transactions AS
2410 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);
2413 ALTER TABLE mipsel_public.transactions OWNER TO wbadm;
2416 -- Name: users; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2419 CREATE VIEW users AS
2420 SELECT users.username, users.distribution, users.last_seen FROM mipsel.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2423 ALTER TABLE mipsel_public.users OWNER TO wbadm;
2425 SET search_path = powerpc, pg_catalog;
2428 -- Name: packages; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2431 CREATE TABLE packages (
2432 package character varying NOT NULL,
2433 distribution character varying NOT NULL,
2434 version character varying,
2435 state character varying,
2436 section character varying,
2437 priority character varying,
2438 installed_version character varying,
2439 previous_state character varying,
2440 state_change timestamp without time zone,
2441 notes character varying,
2442 builder character varying,
2445 binary_nmu_version integer,
2446 binary_nmu_changelog character varying,
2447 failed_category character varying,
2448 permbuildpri integer,
2450 depends character varying,
2451 rel character varying,
2453 extra_depends character varying,
2454 extra_conflicts character varying
2458 ALTER TABLE powerpc.packages OWNER TO wbadm;
2461 -- Name: pkg_history; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2464 CREATE TABLE pkg_history (
2465 package character varying NOT NULL,
2466 distribution character varying NOT NULL,
2467 version character varying NOT NULL,
2468 "timestamp" timestamp without time zone NOT NULL,
2469 result character varying NOT NULL,
2475 ALTER TABLE powerpc.pkg_history OWNER TO wbadm;
2478 -- Name: transactions; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2481 CREATE TABLE transactions (
2482 package character varying,
2483 distribution character varying,
2484 version character varying,
2485 action character varying,
2486 prevstate character varying,
2487 state character varying,
2488 real_user character varying,
2489 set_user character varying,
2490 "time" timestamp without time zone
2494 ALTER TABLE powerpc.transactions OWNER TO wbadm;
2497 -- Name: users; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2500 CREATE TABLE users (
2501 username character varying NOT NULL,
2502 distribution character varying NOT NULL,
2503 last_seen timestamp without time zone
2507 ALTER TABLE powerpc.users OWNER TO wbadm;
2509 SET search_path = powerpc_public, pg_catalog;
2512 -- Name: packages; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2515 CREATE VIEW packages AS
2516 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 FROM powerpc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2519 ALTER TABLE powerpc_public.packages OWNER TO wbadm;
2522 -- Name: pkg_history; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2525 CREATE VIEW pkg_history AS
2526 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);
2529 ALTER TABLE powerpc_public.pkg_history OWNER TO wbadm;
2532 -- Name: transactions; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2535 CREATE VIEW transactions AS
2536 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);
2539 ALTER TABLE powerpc_public.transactions OWNER TO wbadm;
2542 -- Name: users; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2545 CREATE VIEW users AS
2546 SELECT users.username, users.distribution, users.last_seen FROM powerpc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2549 ALTER TABLE powerpc_public.users OWNER TO wbadm;
2551 SET search_path = public, pg_catalog;
2554 -- Name: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2557 CREATE TABLE distribution_aliases (
2558 alias character varying NOT NULL,
2559 distribution character varying NOT NULL
2563 ALTER TABLE public.distribution_aliases OWNER TO wbadm;
2565 SET search_path = s390, pg_catalog;
2568 -- Name: packages; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2571 CREATE TABLE packages (
2572 package character varying NOT NULL,
2573 distribution character varying NOT NULL,
2574 version character varying,
2575 state character varying,
2576 section character varying,
2577 priority character varying,
2578 installed_version character varying,
2579 previous_state character varying,
2580 state_change timestamp without time zone,
2581 notes character varying,
2582 builder character varying,
2585 binary_nmu_version integer,
2586 binary_nmu_changelog character varying,
2587 failed_category character varying,
2588 permbuildpri integer,
2590 depends character varying,
2591 rel character varying,
2593 extra_depends character varying,
2594 extra_conflicts character varying
2598 ALTER TABLE s390.packages OWNER TO wbadm;
2600 SET search_path = sparc, pg_catalog;
2603 -- Name: packages; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2606 CREATE TABLE packages (
2607 package character varying NOT NULL,
2608 distribution character varying NOT NULL,
2609 version character varying,
2610 state character varying,
2611 section character varying,
2612 priority character varying,
2613 installed_version character varying,
2614 previous_state character varying,
2615 state_change timestamp without time zone,
2616 notes character varying,
2617 builder character varying,
2620 binary_nmu_version integer,
2621 binary_nmu_changelog character varying,
2622 failed_category character varying,
2623 permbuildpri integer,
2625 depends character varying,
2626 rel character varying,
2628 extra_depends character varying,
2629 extra_conflicts character varying
2633 ALTER TABLE sparc.packages OWNER TO wbadm;
2635 SET search_path = public, pg_catalog;
2638 -- Name: distribution_architectures; Type: VIEW; Schema: public; Owner: wbadm
2641 CREATE VIEW distribution_architectures AS (((((((((((((
2642 SELECT DISTINCT packages.distribution, 'alpha'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM alpha.packages group by packages.distribution
2644 SELECT DISTINCT packages.distribution, 'amd64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM amd64.packages group by packages.distribution
2646 SELECT DISTINCT packages.distribution, 'arm'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM arm.packages group by packages.distribution
2648 SELECT DISTINCT packages.distribution, 'armel'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM armel.packages group by packages.distribution
2650 SELECT DISTINCT packages.distribution, 'hppa'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM hppa.packages group by packages.distribution
2652 SELECT DISTINCT packages.distribution, 'hurd-i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "hurd-i386".packages group by packages.distribution
2654 SELECT DISTINCT packages.distribution, 'i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM i386.packages group by packages.distribution
2656 SELECT DISTINCT packages.distribution, 'ia64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM ia64.packages group by packages.distribution
2658 SELECT DISTINCT packages.distribution, 'kfreebsd-amd64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "kfreebsd-amd64".packages group by packages.distribution
2660 SELECT DISTINCT packages.distribution, 'kfreebsd-i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "kfreebsd-i386".packages group by packages.distribution
2662 SELECT DISTINCT packages.distribution, 'mips'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM mips.packages group by packages.distribution
2664 SELECT DISTINCT packages.distribution, 'mipsel'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM mipsel.packages group by packages.distribution
2666 SELECT DISTINCT packages.distribution, 'powerpc'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM powerpc.packages group by packages.distribution
2668 SELECT DISTINCT packages.distribution, 's390'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM s390.packages group by packages.distribution
2670 SELECT DISTINCT packages.distribution, 'sparc'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM sparc.packages group by packages.distribution
2674 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2677 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2680 CREATE TABLE distributions (
2681 distribution character varying NOT NULL,
2682 public boolean DEFAULT true NOT NULL,
2683 sort_order integer DEFAULT 0,
2684 auto_dep_wait boolean DEFAULT true,
2685 build_dep_resolver character varying,
2686 archive character varying
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,
2709 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2711 SET search_path = s390_public, pg_catalog;
2714 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2717 CREATE VIEW pkg_history AS
2718 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);
2721 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2723 SET search_path = sparc, pg_catalog;
2726 -- Name: pkg_history; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2729 CREATE TABLE pkg_history (
2730 package character varying NOT NULL,
2731 distribution character varying NOT NULL,
2732 version character varying NOT NULL,
2733 "timestamp" timestamp without time zone NOT NULL,
2734 result character varying NOT NULL,
2740 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2742 SET search_path = sparc_public, pg_catalog;
2745 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2748 CREATE VIEW pkg_history AS
2749 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);
2752 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2754 SET search_path = public, pg_catalog;
2757 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2760 CREATE VIEW lastlog AS
2761 ((((((((((((((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;
2764 ALTER TABLE public.lastlog OWNER TO wbadm;
2767 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2771 (((((((((((((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;
2774 ALTER TABLE public.log OWNER TO wbadm;
2777 -- Name: log_v2; Type: VIEW; Schema: public; Owner: pkern
2780 CREATE VIEW log_v2 AS
2781 (((((((((((((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;
2784 ALTER TABLE public.log_v2 OWNER TO pkern;
2786 SET search_path = s390_public, pg_catalog;
2789 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2792 CREATE VIEW packages AS
2793 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 FROM s390.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2796 ALTER TABLE s390_public.packages OWNER TO wbadm;
2798 SET search_path = sparc_public, pg_catalog;
2801 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2804 CREATE VIEW packages AS
2805 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 FROM sparc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2808 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2810 SET search_path = public, pg_catalog;
2813 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2816 CREATE VIEW packages_all AS
2817 (((((((((((((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;
2820 ALTER TABLE public.packages_all OWNER TO wbadm;
2822 SET search_path = s390, pg_catalog;
2825 -- Name: transactions; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2828 CREATE TABLE transactions (
2829 package character varying,
2830 distribution character varying,
2831 version character varying,
2832 action character varying,
2833 prevstate character varying,
2834 state character varying,
2835 real_user character varying,
2836 set_user character varying,
2837 "time" timestamp without time zone
2841 ALTER TABLE s390.transactions OWNER TO wbadm;
2844 -- Name: users; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2847 CREATE TABLE users (
2848 username character varying NOT NULL,
2849 distribution character varying NOT NULL,
2850 last_seen timestamp without time zone
2854 ALTER TABLE s390.users OWNER TO wbadm;
2856 SET search_path = s390_public, pg_catalog;
2859 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2862 CREATE VIEW transactions AS
2863 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);
2866 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2869 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2872 CREATE VIEW users AS
2873 SELECT users.username, users.distribution, users.last_seen FROM s390.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2876 ALTER TABLE s390_public.users OWNER TO wbadm;
2878 SET search_path = sparc, pg_catalog;
2881 -- Name: transactions; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2884 CREATE TABLE transactions (
2885 package character varying,
2886 distribution character varying,
2887 version character varying,
2888 action character varying,
2889 prevstate character varying,
2890 state character varying,
2891 real_user character varying,
2892 set_user character varying,
2893 "time" timestamp without time zone
2897 ALTER TABLE sparc.transactions OWNER TO wbadm;
2900 -- Name: users; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2903 CREATE TABLE users (
2904 username character varying NOT NULL,
2905 distribution character varying NOT NULL,
2906 last_seen timestamp without time zone
2910 ALTER TABLE sparc.users OWNER TO wbadm;
2912 SET search_path = sparc_public, pg_catalog;
2915 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2918 CREATE VIEW transactions AS
2919 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);
2922 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2925 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2928 CREATE VIEW users AS
2929 SELECT users.username, users.distribution, users.last_seen FROM sparc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2932 ALTER TABLE sparc_public.users OWNER TO wbadm;
2934 SET search_path = alpha, pg_catalog;
2937 -- Name: packages_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2940 ALTER TABLE ONLY packages
2941 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2945 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2948 ALTER TABLE ONLY pkg_history
2949 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2953 -- Name: users_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2956 ALTER TABLE ONLY users
2957 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2960 SET search_path = amd64, pg_catalog;
2963 -- Name: packages_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2966 ALTER TABLE ONLY packages
2967 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2971 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2974 ALTER TABLE ONLY pkg_history
2975 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2979 -- Name: users_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2982 ALTER TABLE ONLY users
2983 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2986 SET search_path = arm, pg_catalog;
2989 -- Name: packages_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2992 ALTER TABLE ONLY packages
2993 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2997 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
3000 ALTER TABLE ONLY pkg_history
3001 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3005 -- Name: users_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
3008 ALTER TABLE ONLY users
3009 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3012 SET search_path = armel, pg_catalog;
3015 -- Name: packages_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3018 ALTER TABLE ONLY packages
3019 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3023 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3026 ALTER TABLE ONLY pkg_history
3027 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3031 -- Name: users_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3034 ALTER TABLE ONLY users
3035 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3038 SET search_path = hppa, pg_catalog;
3041 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3044 ALTER TABLE ONLY packages
3045 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3049 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3052 ALTER TABLE ONLY pkg_history
3053 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3057 -- Name: users_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3060 ALTER TABLE ONLY users
3061 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3064 SET search_path = "hurd-i386", pg_catalog;
3067 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3070 ALTER TABLE ONLY packages
3071 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3075 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3078 ALTER TABLE ONLY pkg_history
3079 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3083 -- Name: users_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3086 ALTER TABLE ONLY users
3087 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3090 SET search_path = i386, pg_catalog;
3093 -- Name: packages_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3096 ALTER TABLE ONLY packages
3097 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3101 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3104 ALTER TABLE ONLY pkg_history
3105 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3109 -- Name: users_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3112 ALTER TABLE ONLY users
3113 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3116 SET search_path = ia64, pg_catalog;
3119 -- Name: packages_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3122 ALTER TABLE ONLY packages
3123 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3127 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3130 ALTER TABLE ONLY pkg_history
3131 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3135 -- Name: users_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3138 ALTER TABLE ONLY users
3139 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3142 SET search_path = "kfreebsd-amd64", pg_catalog;
3145 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3148 ALTER TABLE ONLY packages
3149 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3153 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3156 ALTER TABLE ONLY pkg_history
3157 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3161 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3164 ALTER TABLE ONLY users
3165 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3168 SET search_path = "kfreebsd-i386", pg_catalog;
3171 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3174 ALTER TABLE ONLY packages
3175 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3179 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3182 ALTER TABLE ONLY pkg_history
3183 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3187 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3190 ALTER TABLE ONLY users
3191 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3194 SET search_path = mips, pg_catalog;
3197 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3200 ALTER TABLE ONLY packages
3201 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3205 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3208 ALTER TABLE ONLY pkg_history
3209 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3213 -- Name: users_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3216 ALTER TABLE ONLY users
3217 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3220 SET search_path = mipsel, pg_catalog;
3223 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3226 ALTER TABLE ONLY packages
3227 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3231 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3234 ALTER TABLE ONLY pkg_history
3235 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3239 -- Name: users_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3242 ALTER TABLE ONLY users
3243 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3246 SET search_path = powerpc, pg_catalog;
3249 -- Name: packages_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3252 ALTER TABLE ONLY packages
3253 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3257 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3260 ALTER TABLE ONLY pkg_history
3261 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3265 -- Name: users_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3268 ALTER TABLE ONLY users
3269 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3272 SET search_path = public, pg_catalog;
3275 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
3278 ALTER TABLE ONLY distribution_aliases
3279 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
3282 SET search_path = s390, pg_catalog;
3285 -- Name: packages_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3288 ALTER TABLE ONLY packages
3289 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3293 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3296 ALTER TABLE ONLY pkg_history
3297 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3301 -- Name: users_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3304 ALTER TABLE ONLY users
3305 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3308 SET search_path = sparc, pg_catalog;
3311 -- Name: packages_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3314 ALTER TABLE ONLY packages
3315 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3319 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3322 ALTER TABLE ONLY pkg_history
3323 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3327 -- Name: users_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3330 ALTER TABLE ONLY users
3331 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3334 SET search_path = alpha, pg_catalog;
3337 -- Name: idx_alpha_state; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3340 CREATE INDEX idx_alpha_state ON packages USING btree (state);
3344 -- Name: pkg_history_distribution; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3347 CREATE INDEX pkg_history_distribution ON pkg_history USING hash (distribution);
3351 -- Name: pkg_history_index; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3354 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3358 -- Name: pkg_history_timestamp; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3361 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3364 SET search_path = amd64, pg_catalog;
3367 -- Name: idx_amd64_state; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3370 CREATE INDEX idx_amd64_state ON packages USING btree (state);
3374 -- Name: pkg_history_index; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3377 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3381 -- Name: pkg_history_timestamp; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3384 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3387 SET search_path = arm, pg_catalog;
3390 -- Name: idx_arm_state; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3393 CREATE INDEX idx_arm_state ON packages USING btree (state);
3397 -- Name: pkg_history_index; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3400 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3404 -- Name: pkg_history_timestamp; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3407 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3410 SET search_path = armel, pg_catalog;
3413 -- Name: idx_armel_state; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3416 CREATE INDEX idx_armel_state ON packages USING btree (state);
3420 -- Name: pkg_history_index; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3423 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3427 -- Name: pkg_history_timestamp; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3430 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3433 SET search_path = hppa, pg_catalog;
3436 -- Name: idx_hppa_state; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3439 CREATE INDEX idx_hppa_state ON packages USING btree (state);
3443 -- Name: pkg_history_index; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3446 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3450 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3453 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3456 SET search_path = "hurd-i386", pg_catalog;
3459 -- Name: idx_hurd-i386_state; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3462 CREATE INDEX "idx_hurd-i386_state" ON packages USING btree (state);
3466 -- Name: pkg_history_index; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3469 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3473 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3476 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3479 SET search_path = i386, pg_catalog;
3482 -- Name: idx_i386_state; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3485 CREATE INDEX idx_i386_state ON packages USING btree (state);
3489 -- Name: pkg_history_index; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3492 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3496 -- Name: pkg_history_timestamp; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3499 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3502 SET search_path = ia64, pg_catalog;
3505 -- Name: idx_ia64_state; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3508 CREATE INDEX idx_ia64_state ON packages USING btree (state);
3512 -- Name: pkg_history_index; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3515 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3519 -- Name: pkg_history_timestamp; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3522 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3525 SET search_path = "kfreebsd-amd64", pg_catalog;
3528 -- Name: idx_kfreebsd-amd64_state; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3531 CREATE INDEX "idx_kfreebsd-amd64_state" ON packages USING btree (state);
3535 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3538 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3542 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3545 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3548 SET search_path = "kfreebsd-i386", pg_catalog;
3551 -- Name: idx_kfreebsd-i386_state; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3554 CREATE INDEX "idx_kfreebsd-i386_state" ON packages USING btree (state);
3558 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3561 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3565 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3568 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3571 SET search_path = mips, pg_catalog;
3574 -- Name: idx_mips_state; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3577 CREATE INDEX idx_mips_state ON packages USING btree (state);
3581 -- Name: pkg_history_index; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3584 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3588 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3591 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3594 SET search_path = mipsel, pg_catalog;
3597 -- Name: idx_mipsel_state; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3600 CREATE INDEX idx_mipsel_state ON packages USING btree (state);
3604 -- Name: pkg_history_index; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3607 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3611 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3614 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3617 SET search_path = powerpc, pg_catalog;
3620 -- Name: idx_powerpc_state; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3623 CREATE INDEX idx_powerpc_state ON packages USING btree (state);
3627 -- Name: pkg_history_index; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3630 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3634 -- Name: pkg_history_timestamp; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3637 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3640 SET search_path = public, pg_catalog;
3643 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3646 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
3650 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3653 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
3656 SET search_path = s390, pg_catalog;
3659 -- Name: idx_s390_state; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3662 CREATE INDEX idx_s390_state ON packages USING btree (state);
3666 -- Name: pkg_history_index; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3669 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3673 -- Name: pkg_history_timestamp; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3676 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3679 SET search_path = sparc, pg_catalog;
3682 -- Name: idx_sparc_state; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3685 CREATE INDEX idx_sparc_state ON packages USING btree (state);
3689 -- Name: pkg_history_index; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3692 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3696 -- Name: pkg_history_timestamp; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3699 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3702 SET search_path = alpha, pg_catalog;
3705 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3708 ALTER TABLE ONLY packages
3709 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3713 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3716 ALTER TABLE ONLY pkg_history
3717 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3721 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3724 ALTER TABLE ONLY users
3725 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3728 SET search_path = amd64, pg_catalog;
3731 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3734 ALTER TABLE ONLY packages
3735 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3739 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3742 ALTER TABLE ONLY pkg_history
3743 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3747 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3750 ALTER TABLE ONLY users
3751 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3754 SET search_path = arm, pg_catalog;
3757 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3760 ALTER TABLE ONLY packages
3761 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3765 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3768 ALTER TABLE ONLY pkg_history
3769 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3773 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3776 ALTER TABLE ONLY users
3777 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3780 SET search_path = armel, pg_catalog;
3783 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3786 ALTER TABLE ONLY packages
3787 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3791 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3794 ALTER TABLE ONLY pkg_history
3795 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3799 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3802 ALTER TABLE ONLY users
3803 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3806 SET search_path = hppa, pg_catalog;
3809 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3812 ALTER TABLE ONLY packages
3813 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3817 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3820 ALTER TABLE ONLY pkg_history
3821 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3825 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3828 ALTER TABLE ONLY users
3829 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3832 SET search_path = "hurd-i386", pg_catalog;
3835 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3838 ALTER TABLE ONLY packages
3839 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3843 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3846 ALTER TABLE ONLY pkg_history
3847 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3851 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3854 ALTER TABLE ONLY users
3855 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3858 SET search_path = i386, pg_catalog;
3861 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3864 ALTER TABLE ONLY packages
3865 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3869 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3872 ALTER TABLE ONLY pkg_history
3873 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3877 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3880 ALTER TABLE ONLY users
3881 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3884 SET search_path = ia64, pg_catalog;
3887 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3890 ALTER TABLE ONLY packages
3891 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3895 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3898 ALTER TABLE ONLY pkg_history
3899 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3903 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3906 ALTER TABLE ONLY users
3907 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3910 SET search_path = "kfreebsd-amd64", pg_catalog;
3913 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3916 ALTER TABLE ONLY packages
3917 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3921 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3924 ALTER TABLE ONLY pkg_history
3925 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3929 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3932 ALTER TABLE ONLY users
3933 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3936 SET search_path = "kfreebsd-i386", pg_catalog;
3939 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3942 ALTER TABLE ONLY packages
3943 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3947 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3950 ALTER TABLE ONLY pkg_history
3951 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3955 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3958 ALTER TABLE ONLY users
3959 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3962 SET search_path = mips, pg_catalog;
3965 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3968 ALTER TABLE ONLY packages
3969 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3973 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3976 ALTER TABLE ONLY pkg_history
3977 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3981 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3984 ALTER TABLE ONLY users
3985 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3988 SET search_path = mipsel, pg_catalog;
3991 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3994 ALTER TABLE ONLY packages
3995 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3999 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
4002 ALTER TABLE ONLY pkg_history
4003 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4007 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
4010 ALTER TABLE ONLY users
4011 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4014 SET search_path = powerpc, pg_catalog;
4017 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4020 ALTER TABLE ONLY packages
4021 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4025 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4028 ALTER TABLE ONLY pkg_history
4029 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4033 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4036 ALTER TABLE ONLY users
4037 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4040 SET search_path = public, pg_catalog;
4043 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
4046 ALTER TABLE ONLY distribution_aliases
4047 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
4050 SET search_path = s390, pg_catalog;
4053 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4056 ALTER TABLE ONLY packages
4057 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4061 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4064 ALTER TABLE ONLY pkg_history
4065 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4069 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4072 ALTER TABLE ONLY users
4073 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4076 SET search_path = sparc, pg_catalog;
4079 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4082 ALTER TABLE ONLY packages
4083 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4087 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4090 ALTER TABLE ONLY pkg_history
4091 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4095 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4098 ALTER TABLE ONLY users
4099 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4103 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
4106 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
4107 REVOKE ALL ON SCHEMA alpha FROM wbadm;
4108 GRANT ALL ON SCHEMA alpha TO wbadm;
4109 GRANT USAGE ON SCHEMA alpha TO alpha;
4110 GRANT USAGE ON SCHEMA alpha TO wb_all;
4111 GRANT USAGE ON SCHEMA alpha TO wb_security;
4115 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
4118 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
4119 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
4120 GRANT ALL ON SCHEMA alpha_public TO wbadm;
4121 GRANT USAGE ON SCHEMA alpha_public TO alpha;
4122 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
4126 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
4129 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
4130 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
4131 GRANT ALL ON SCHEMA amd64 TO wbadm;
4132 GRANT USAGE ON SCHEMA amd64 TO amd64;
4133 GRANT USAGE ON SCHEMA amd64 TO wb_all;
4134 GRANT USAGE ON SCHEMA amd64 TO wb_security;
4138 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
4141 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
4142 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
4143 GRANT ALL ON SCHEMA amd64_public TO wbadm;
4144 GRANT USAGE ON SCHEMA amd64_public TO amd64;
4145 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
4149 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
4152 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
4153 REVOKE ALL ON SCHEMA arm FROM wbadm;
4154 GRANT ALL ON SCHEMA arm TO wbadm;
4155 GRANT USAGE ON SCHEMA arm TO arm;
4156 GRANT USAGE ON SCHEMA arm TO wb_all;
4157 GRANT USAGE ON SCHEMA arm TO wb_security;
4161 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
4164 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
4165 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
4166 GRANT ALL ON SCHEMA arm_public TO wbadm;
4167 GRANT USAGE ON SCHEMA arm_public TO arm;
4168 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
4172 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
4175 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
4176 REVOKE ALL ON SCHEMA armel FROM wbadm;
4177 GRANT ALL ON SCHEMA armel TO wbadm;
4178 GRANT USAGE ON SCHEMA armel TO armel;
4179 GRANT USAGE ON SCHEMA armel TO wb_all;
4180 GRANT USAGE ON SCHEMA armel TO wb_security;
4184 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
4187 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
4188 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
4189 GRANT ALL ON SCHEMA armel_public TO wbadm;
4190 GRANT USAGE ON SCHEMA armel_public TO armel;
4191 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
4195 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4198 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4199 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4200 GRANT ALL ON SCHEMA hppa TO wbadm;
4201 GRANT USAGE ON SCHEMA hppa TO hppa;
4202 GRANT USAGE ON SCHEMA hppa TO wb_all;
4203 GRANT USAGE ON SCHEMA hppa TO wb_security;
4207 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4210 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4211 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4212 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4213 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4214 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4218 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4221 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4222 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4223 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4224 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4225 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4226 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4230 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4233 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4234 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4235 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4236 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4237 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4241 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4244 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4245 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4246 GRANT ALL ON SCHEMA i386 TO wbadm;
4247 GRANT USAGE ON SCHEMA i386 TO i386;
4248 GRANT USAGE ON SCHEMA i386 TO wb_all;
4249 GRANT USAGE ON SCHEMA i386 TO wb_security;
4253 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4256 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4257 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4258 GRANT ALL ON SCHEMA i386_public TO wbadm;
4259 GRANT USAGE ON SCHEMA i386_public TO i386;
4260 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4264 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4267 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4268 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4269 GRANT ALL ON SCHEMA ia64 TO wbadm;
4270 GRANT USAGE ON SCHEMA ia64 TO ia64;
4271 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4272 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4276 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4279 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4280 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4281 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4282 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4283 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4287 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4290 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4291 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4292 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4293 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4294 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4295 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4299 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4302 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4303 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4304 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4305 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4306 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4310 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4313 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4314 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4315 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4316 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4317 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4318 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4322 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4325 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4326 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4327 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4328 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4329 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4333 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4336 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4337 REVOKE ALL ON SCHEMA mips FROM wbadm;
4338 GRANT ALL ON SCHEMA mips TO wbadm;
4339 GRANT USAGE ON SCHEMA mips TO mips;
4340 GRANT USAGE ON SCHEMA mips TO wb_all;
4341 GRANT USAGE ON SCHEMA mips TO wb_security;
4345 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4348 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4349 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4350 GRANT ALL ON SCHEMA mips_public TO wbadm;
4351 GRANT USAGE ON SCHEMA mips_public TO mips;
4352 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4356 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4359 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4360 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4361 GRANT ALL ON SCHEMA mipsel TO wbadm;
4362 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4363 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4364 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4368 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4371 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4372 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4373 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4374 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4375 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4379 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4382 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4383 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4384 GRANT ALL ON SCHEMA powerpc TO wbadm;
4385 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4386 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4387 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4391 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4394 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4395 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4396 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4397 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4398 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4402 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4405 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4406 REVOKE ALL ON SCHEMA public FROM postgres;
4407 GRANT ALL ON SCHEMA public TO postgres;
4408 GRANT ALL ON SCHEMA public TO PUBLIC;
4412 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4415 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4416 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4417 GRANT ALL ON SCHEMA s390 TO wbadm;
4418 GRANT USAGE ON SCHEMA s390 TO s390;
4419 GRANT USAGE ON SCHEMA s390 TO wb_all;
4420 GRANT USAGE ON SCHEMA s390 TO wb_security;
4424 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4427 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4428 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4429 GRANT ALL ON SCHEMA s390_public TO wbadm;
4430 GRANT USAGE ON SCHEMA s390_public TO s390;
4431 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4435 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4438 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4439 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4440 GRANT ALL ON SCHEMA sparc TO wbadm;
4441 GRANT USAGE ON SCHEMA sparc TO sparc;
4442 GRANT USAGE ON SCHEMA sparc TO wb_all;
4443 GRANT USAGE ON SCHEMA sparc TO wb_security;
4447 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4450 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4451 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4452 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4453 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4454 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4457 SET search_path = alpha, pg_catalog;
4460 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4463 REVOKE ALL ON TABLE packages FROM PUBLIC;
4464 REVOKE ALL ON TABLE packages FROM wbadm;
4465 GRANT ALL ON TABLE packages TO wbadm;
4466 GRANT ALL ON TABLE packages TO alpha;
4467 GRANT SELECT ON TABLE packages TO wb_security;
4471 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4474 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4475 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4476 GRANT ALL ON TABLE pkg_history TO wbadm;
4477 GRANT ALL ON TABLE pkg_history TO alpha;
4478 GRANT SELECT ON TABLE pkg_history TO wb_security;
4482 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4485 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4486 REVOKE ALL ON TABLE transactions FROM wbadm;
4487 GRANT ALL ON TABLE transactions TO wbadm;
4488 GRANT SELECT,INSERT ON TABLE transactions TO alpha;
4489 GRANT SELECT ON TABLE transactions TO wb_security;
4493 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4496 REVOKE ALL ON TABLE users FROM PUBLIC;
4497 REVOKE ALL ON TABLE users FROM wbadm;
4498 GRANT ALL ON TABLE users TO wbadm;
4499 GRANT ALL ON TABLE users TO alpha;
4502 SET search_path = alpha_public, pg_catalog;
4505 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4508 REVOKE ALL ON TABLE packages FROM PUBLIC;
4509 REVOKE ALL ON TABLE packages FROM wbadm;
4510 GRANT ALL ON TABLE packages TO wbadm;
4511 GRANT SELECT ON TABLE packages TO PUBLIC;
4515 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4518 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4519 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4520 GRANT ALL ON TABLE pkg_history TO wbadm;
4521 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4525 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4528 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4529 REVOKE ALL ON TABLE transactions FROM wbadm;
4530 GRANT ALL ON TABLE transactions TO wbadm;
4531 GRANT SELECT ON TABLE transactions TO PUBLIC;
4535 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4538 REVOKE ALL ON TABLE users FROM PUBLIC;
4539 REVOKE ALL ON TABLE users FROM wbadm;
4540 GRANT ALL ON TABLE users TO wbadm;
4541 GRANT SELECT ON TABLE users TO PUBLIC;
4544 SET search_path = amd64, pg_catalog;
4547 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4550 REVOKE ALL ON TABLE packages FROM PUBLIC;
4551 REVOKE ALL ON TABLE packages FROM wbadm;
4552 GRANT ALL ON TABLE packages TO wbadm;
4553 GRANT ALL ON TABLE packages TO amd64;
4554 GRANT SELECT ON TABLE packages TO wb_security;
4558 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4561 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4562 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4563 GRANT ALL ON TABLE pkg_history TO wbadm;
4564 GRANT ALL ON TABLE pkg_history TO amd64;
4565 GRANT SELECT ON TABLE pkg_history TO wb_security;
4569 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4572 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4573 REVOKE ALL ON TABLE transactions FROM wbadm;
4574 GRANT ALL ON TABLE transactions TO wbadm;
4575 GRANT SELECT,INSERT ON TABLE transactions TO amd64;
4576 GRANT SELECT ON TABLE transactions TO wb_security;
4580 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4583 REVOKE ALL ON TABLE users FROM PUBLIC;
4584 REVOKE ALL ON TABLE users FROM wbadm;
4585 GRANT ALL ON TABLE users TO wbadm;
4586 GRANT ALL ON TABLE users TO amd64;
4589 SET search_path = amd64_public, pg_catalog;
4592 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4595 REVOKE ALL ON TABLE packages FROM PUBLIC;
4596 REVOKE ALL ON TABLE packages FROM wbadm;
4597 GRANT ALL ON TABLE packages TO wbadm;
4598 GRANT SELECT ON TABLE packages TO PUBLIC;
4602 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4605 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4606 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4607 GRANT ALL ON TABLE pkg_history TO wbadm;
4608 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4612 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4615 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4616 REVOKE ALL ON TABLE transactions FROM wbadm;
4617 GRANT ALL ON TABLE transactions TO wbadm;
4618 GRANT SELECT ON TABLE transactions TO PUBLIC;
4622 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4625 REVOKE ALL ON TABLE users FROM PUBLIC;
4626 REVOKE ALL ON TABLE users FROM wbadm;
4627 GRANT ALL ON TABLE users TO wbadm;
4628 GRANT SELECT ON TABLE users TO PUBLIC;
4631 SET search_path = arm, pg_catalog;
4634 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4637 REVOKE ALL ON TABLE packages FROM PUBLIC;
4638 REVOKE ALL ON TABLE packages FROM wbadm;
4639 GRANT ALL ON TABLE packages TO wbadm;
4640 GRANT ALL ON TABLE packages TO arm;
4641 GRANT SELECT ON TABLE packages TO wb_security;
4645 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4648 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4649 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4650 GRANT ALL ON TABLE pkg_history TO wbadm;
4651 GRANT ALL ON TABLE pkg_history TO arm;
4652 GRANT SELECT ON TABLE pkg_history TO wb_security;
4656 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4659 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4660 REVOKE ALL ON TABLE transactions FROM wbadm;
4661 GRANT ALL ON TABLE transactions TO wbadm;
4662 GRANT SELECT,INSERT ON TABLE transactions TO arm;
4663 GRANT SELECT ON TABLE transactions TO wb_security;
4667 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4670 REVOKE ALL ON TABLE users FROM PUBLIC;
4671 REVOKE ALL ON TABLE users FROM wbadm;
4672 GRANT ALL ON TABLE users TO wbadm;
4673 GRANT ALL ON TABLE users TO arm;
4676 SET search_path = arm_public, pg_catalog;
4679 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4682 REVOKE ALL ON TABLE packages FROM PUBLIC;
4683 REVOKE ALL ON TABLE packages FROM wbadm;
4684 GRANT ALL ON TABLE packages TO wbadm;
4685 GRANT SELECT ON TABLE packages TO PUBLIC;
4689 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4692 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4693 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4694 GRANT ALL ON TABLE pkg_history TO wbadm;
4695 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4699 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4702 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4703 REVOKE ALL ON TABLE transactions FROM wbadm;
4704 GRANT ALL ON TABLE transactions TO wbadm;
4705 GRANT SELECT ON TABLE transactions TO PUBLIC;
4709 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4712 REVOKE ALL ON TABLE users FROM PUBLIC;
4713 REVOKE ALL ON TABLE users FROM wbadm;
4714 GRANT ALL ON TABLE users TO wbadm;
4715 GRANT SELECT ON TABLE users TO PUBLIC;
4718 SET search_path = armel, pg_catalog;
4721 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4724 REVOKE ALL ON TABLE packages FROM PUBLIC;
4725 REVOKE ALL ON TABLE packages FROM wbadm;
4726 GRANT ALL ON TABLE packages TO wbadm;
4727 GRANT ALL ON TABLE packages TO armel;
4728 GRANT SELECT ON TABLE packages TO wb_security;
4732 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4735 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4736 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4737 GRANT ALL ON TABLE pkg_history TO wbadm;
4738 GRANT ALL ON TABLE pkg_history TO armel;
4739 GRANT SELECT ON TABLE pkg_history TO wb_security;
4743 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4746 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4747 REVOKE ALL ON TABLE transactions FROM wbadm;
4748 GRANT ALL ON TABLE transactions TO wbadm;
4749 GRANT SELECT,INSERT ON TABLE transactions TO armel;
4750 GRANT SELECT ON TABLE transactions TO wb_security;
4754 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4757 REVOKE ALL ON TABLE users FROM PUBLIC;
4758 REVOKE ALL ON TABLE users FROM wbadm;
4759 GRANT ALL ON TABLE users TO wbadm;
4760 GRANT ALL ON TABLE users TO armel;
4763 SET search_path = armel_public, pg_catalog;
4766 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4769 REVOKE ALL ON TABLE packages FROM PUBLIC;
4770 REVOKE ALL ON TABLE packages FROM wbadm;
4771 GRANT ALL ON TABLE packages TO wbadm;
4772 GRANT SELECT ON TABLE packages TO PUBLIC;
4776 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4779 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4780 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4781 GRANT ALL ON TABLE pkg_history TO wbadm;
4782 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4786 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4789 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4790 REVOKE ALL ON TABLE transactions FROM wbadm;
4791 GRANT ALL ON TABLE transactions TO wbadm;
4792 GRANT SELECT ON TABLE transactions TO PUBLIC;
4796 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4799 REVOKE ALL ON TABLE users FROM PUBLIC;
4800 REVOKE ALL ON TABLE users FROM wbadm;
4801 GRANT ALL ON TABLE users TO wbadm;
4802 GRANT SELECT ON TABLE users TO PUBLIC;
4805 SET search_path = hppa, pg_catalog;
4808 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4811 REVOKE ALL ON TABLE packages FROM PUBLIC;
4812 REVOKE ALL ON TABLE packages FROM wbadm;
4813 GRANT ALL ON TABLE packages TO wbadm;
4814 GRANT ALL ON TABLE packages TO hppa;
4815 GRANT SELECT ON TABLE packages TO wb_security;
4819 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4822 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4823 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4824 GRANT ALL ON TABLE pkg_history TO wbadm;
4825 GRANT ALL ON TABLE pkg_history TO hppa;
4826 GRANT SELECT ON TABLE pkg_history TO wb_security;
4830 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4833 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4834 REVOKE ALL ON TABLE transactions FROM wbadm;
4835 GRANT ALL ON TABLE transactions TO wbadm;
4836 GRANT SELECT,INSERT ON TABLE transactions TO hppa;
4837 GRANT SELECT ON TABLE transactions TO wb_security;
4841 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4844 REVOKE ALL ON TABLE users FROM PUBLIC;
4845 REVOKE ALL ON TABLE users FROM wbadm;
4846 GRANT ALL ON TABLE users TO wbadm;
4847 GRANT ALL ON TABLE users TO hppa;
4850 SET search_path = hppa_public, pg_catalog;
4853 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4856 REVOKE ALL ON TABLE packages FROM PUBLIC;
4857 REVOKE ALL ON TABLE packages FROM wbadm;
4858 GRANT ALL ON TABLE packages TO wbadm;
4859 GRANT SELECT ON TABLE packages TO PUBLIC;
4863 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4866 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4867 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4868 GRANT ALL ON TABLE pkg_history TO wbadm;
4869 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4873 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4876 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4877 REVOKE ALL ON TABLE transactions FROM wbadm;
4878 GRANT ALL ON TABLE transactions TO wbadm;
4879 GRANT SELECT ON TABLE transactions TO PUBLIC;
4883 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4886 REVOKE ALL ON TABLE users FROM PUBLIC;
4887 REVOKE ALL ON TABLE users FROM wbadm;
4888 GRANT ALL ON TABLE users TO wbadm;
4889 GRANT SELECT ON TABLE users TO PUBLIC;
4892 SET search_path = "hurd-i386", pg_catalog;
4895 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4898 REVOKE ALL ON TABLE packages FROM PUBLIC;
4899 REVOKE ALL ON TABLE packages FROM wbadm;
4900 GRANT ALL ON TABLE packages TO wbadm;
4901 GRANT ALL ON TABLE packages TO "hurd-i386";
4902 GRANT SELECT ON TABLE packages TO wb_security;
4906 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4909 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4910 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4911 GRANT ALL ON TABLE pkg_history TO wbadm;
4912 GRANT ALL ON TABLE pkg_history TO "hurd-i386";
4913 GRANT SELECT ON TABLE pkg_history TO wb_security;
4917 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4920 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4921 REVOKE ALL ON TABLE transactions FROM wbadm;
4922 GRANT ALL ON TABLE transactions TO wbadm;
4923 GRANT SELECT,INSERT ON TABLE transactions TO "hurd-i386";
4924 GRANT SELECT ON TABLE transactions TO wb_security;
4928 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4931 REVOKE ALL ON TABLE users FROM PUBLIC;
4932 REVOKE ALL ON TABLE users FROM wbadm;
4933 GRANT ALL ON TABLE users TO wbadm;
4934 GRANT ALL ON TABLE users TO "hurd-i386";
4937 SET search_path = "hurd-i386_public", pg_catalog;
4940 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4943 REVOKE ALL ON TABLE packages FROM PUBLIC;
4944 REVOKE ALL ON TABLE packages FROM wbadm;
4945 GRANT ALL ON TABLE packages TO wbadm;
4946 GRANT SELECT ON TABLE packages TO PUBLIC;
4950 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4953 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4954 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4955 GRANT ALL ON TABLE pkg_history TO wbadm;
4956 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4960 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4963 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4964 REVOKE ALL ON TABLE transactions FROM wbadm;
4965 GRANT ALL ON TABLE transactions TO wbadm;
4966 GRANT SELECT ON TABLE transactions TO PUBLIC;
4970 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4973 REVOKE ALL ON TABLE users FROM PUBLIC;
4974 REVOKE ALL ON TABLE users FROM wbadm;
4975 GRANT ALL ON TABLE users TO wbadm;
4976 GRANT SELECT ON TABLE users TO PUBLIC;
4979 SET search_path = i386, pg_catalog;
4982 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4985 REVOKE ALL ON TABLE packages FROM PUBLIC;
4986 REVOKE ALL ON TABLE packages FROM wbadm;
4987 GRANT ALL ON TABLE packages TO wbadm;
4988 GRANT ALL ON TABLE packages TO i386;
4989 GRANT SELECT ON TABLE packages TO wb_security;
4993 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4996 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4997 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4998 GRANT ALL ON TABLE pkg_history TO wbadm;
4999 GRANT ALL ON TABLE pkg_history TO i386;
5000 GRANT SELECT ON TABLE pkg_history TO wb_security;
5004 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
5007 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5008 REVOKE ALL ON TABLE transactions FROM wbadm;
5009 GRANT ALL ON TABLE transactions TO wbadm;
5010 GRANT SELECT,INSERT ON TABLE transactions TO i386;
5011 GRANT SELECT ON TABLE transactions TO wb_security;
5015 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
5018 REVOKE ALL ON TABLE users FROM PUBLIC;
5019 REVOKE ALL ON TABLE users FROM wbadm;
5020 GRANT ALL ON TABLE users TO wbadm;
5021 GRANT ALL ON TABLE users TO i386;
5024 SET search_path = i386_public, pg_catalog;
5027 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5030 REVOKE ALL ON TABLE packages FROM PUBLIC;
5031 REVOKE ALL ON TABLE packages FROM wbadm;
5032 GRANT ALL ON TABLE packages TO wbadm;
5033 GRANT SELECT ON TABLE packages TO PUBLIC;
5037 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5040 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5041 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5042 GRANT ALL ON TABLE pkg_history TO wbadm;
5043 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5047 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5050 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5051 REVOKE ALL ON TABLE transactions FROM wbadm;
5052 GRANT ALL ON TABLE transactions TO wbadm;
5053 GRANT SELECT ON TABLE transactions TO PUBLIC;
5057 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5060 REVOKE ALL ON TABLE users FROM PUBLIC;
5061 REVOKE ALL ON TABLE users FROM wbadm;
5062 GRANT ALL ON TABLE users TO wbadm;
5063 GRANT SELECT ON TABLE users TO PUBLIC;
5066 SET search_path = ia64, pg_catalog;
5069 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5072 REVOKE ALL ON TABLE packages FROM PUBLIC;
5073 REVOKE ALL ON TABLE packages FROM wbadm;
5074 GRANT ALL ON TABLE packages TO wbadm;
5075 GRANT ALL ON TABLE packages TO ia64;
5076 GRANT SELECT ON TABLE packages TO wb_security;
5080 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5083 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5084 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5085 GRANT ALL ON TABLE pkg_history TO wbadm;
5086 GRANT ALL ON TABLE pkg_history TO ia64;
5087 GRANT SELECT ON TABLE pkg_history TO wb_security;
5091 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5094 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5095 REVOKE ALL ON TABLE transactions FROM wbadm;
5096 GRANT ALL ON TABLE transactions TO wbadm;
5097 GRANT SELECT,INSERT ON TABLE transactions TO ia64;
5098 GRANT SELECT ON TABLE transactions TO wb_security;
5102 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5105 REVOKE ALL ON TABLE users FROM PUBLIC;
5106 REVOKE ALL ON TABLE users FROM wbadm;
5107 GRANT ALL ON TABLE users TO wbadm;
5108 GRANT ALL ON TABLE users TO ia64;
5111 SET search_path = ia64_public, pg_catalog;
5114 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5117 REVOKE ALL ON TABLE packages FROM PUBLIC;
5118 REVOKE ALL ON TABLE packages FROM wbadm;
5119 GRANT ALL ON TABLE packages TO wbadm;
5120 GRANT SELECT ON TABLE packages TO PUBLIC;
5124 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5127 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5128 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5129 GRANT ALL ON TABLE pkg_history TO wbadm;
5130 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5134 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5137 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5138 REVOKE ALL ON TABLE transactions FROM wbadm;
5139 GRANT ALL ON TABLE transactions TO wbadm;
5140 GRANT SELECT ON TABLE transactions TO PUBLIC;
5144 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5147 REVOKE ALL ON TABLE users FROM PUBLIC;
5148 REVOKE ALL ON TABLE users FROM wbadm;
5149 GRANT ALL ON TABLE users TO wbadm;
5150 GRANT SELECT ON TABLE users TO PUBLIC;
5153 SET search_path = "kfreebsd-amd64", pg_catalog;
5156 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5159 REVOKE ALL ON TABLE packages FROM PUBLIC;
5160 REVOKE ALL ON TABLE packages FROM wbadm;
5161 GRANT ALL ON TABLE packages TO wbadm;
5162 GRANT ALL ON TABLE packages TO "kfreebsd-amd64";
5163 GRANT SELECT ON TABLE packages TO wb_security;
5167 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5170 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5171 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5172 GRANT ALL ON TABLE pkg_history TO wbadm;
5173 GRANT ALL ON TABLE pkg_history TO "kfreebsd-amd64";
5174 GRANT SELECT ON TABLE pkg_history TO wb_security;
5178 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5181 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5182 REVOKE ALL ON TABLE transactions FROM wbadm;
5183 GRANT ALL ON TABLE transactions TO wbadm;
5184 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-amd64";
5185 GRANT SELECT ON TABLE transactions TO wb_security;
5189 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5192 REVOKE ALL ON TABLE users FROM PUBLIC;
5193 REVOKE ALL ON TABLE users FROM wbadm;
5194 GRANT ALL ON TABLE users TO wbadm;
5195 GRANT ALL ON TABLE users TO "kfreebsd-amd64";
5198 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5201 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5204 REVOKE ALL ON TABLE packages FROM PUBLIC;
5205 REVOKE ALL ON TABLE packages FROM wbadm;
5206 GRANT ALL ON TABLE packages TO wbadm;
5207 GRANT SELECT ON TABLE packages TO PUBLIC;
5211 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5214 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5215 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5216 GRANT ALL ON TABLE pkg_history TO wbadm;
5217 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5221 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5224 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5225 REVOKE ALL ON TABLE transactions FROM wbadm;
5226 GRANT ALL ON TABLE transactions TO wbadm;
5227 GRANT SELECT ON TABLE transactions TO PUBLIC;
5231 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5234 REVOKE ALL ON TABLE users FROM PUBLIC;
5235 REVOKE ALL ON TABLE users FROM wbadm;
5236 GRANT ALL ON TABLE users TO wbadm;
5237 GRANT SELECT ON TABLE users TO PUBLIC;
5240 SET search_path = "kfreebsd-i386", pg_catalog;
5243 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5246 REVOKE ALL ON TABLE packages FROM PUBLIC;
5247 REVOKE ALL ON TABLE packages FROM wbadm;
5248 GRANT ALL ON TABLE packages TO wbadm;
5249 GRANT ALL ON TABLE packages TO "kfreebsd-i386";
5250 GRANT SELECT ON TABLE packages TO wb_security;
5254 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5257 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5258 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5259 GRANT ALL ON TABLE pkg_history TO wbadm;
5260 GRANT ALL ON TABLE pkg_history TO "kfreebsd-i386";
5261 GRANT SELECT ON TABLE pkg_history TO wb_security;
5265 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5268 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5269 REVOKE ALL ON TABLE transactions FROM wbadm;
5270 GRANT ALL ON TABLE transactions TO wbadm;
5271 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-i386";
5272 GRANT SELECT ON TABLE transactions TO wb_security;
5276 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5279 REVOKE ALL ON TABLE users FROM PUBLIC;
5280 REVOKE ALL ON TABLE users FROM wbadm;
5281 GRANT ALL ON TABLE users TO wbadm;
5282 GRANT ALL ON TABLE users TO "kfreebsd-i386";
5285 SET search_path = "kfreebsd-i386_public", pg_catalog;
5288 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5291 REVOKE ALL ON TABLE packages FROM PUBLIC;
5292 REVOKE ALL ON TABLE packages FROM wbadm;
5293 GRANT ALL ON TABLE packages TO wbadm;
5294 GRANT SELECT ON TABLE packages TO PUBLIC;
5298 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5301 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5302 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5303 GRANT ALL ON TABLE pkg_history TO wbadm;
5304 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5308 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5311 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5312 REVOKE ALL ON TABLE transactions FROM wbadm;
5313 GRANT ALL ON TABLE transactions TO wbadm;
5314 GRANT SELECT ON TABLE transactions TO PUBLIC;
5318 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5321 REVOKE ALL ON TABLE users FROM PUBLIC;
5322 REVOKE ALL ON TABLE users FROM wbadm;
5323 GRANT ALL ON TABLE users TO wbadm;
5324 GRANT SELECT ON TABLE users TO PUBLIC;
5327 SET search_path = mips, pg_catalog;
5330 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5333 REVOKE ALL ON TABLE packages FROM PUBLIC;
5334 REVOKE ALL ON TABLE packages FROM wbadm;
5335 GRANT ALL ON TABLE packages TO wbadm;
5336 GRANT ALL ON TABLE packages TO mips;
5337 GRANT SELECT ON TABLE packages TO wb_security;
5341 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5344 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5345 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5346 GRANT ALL ON TABLE pkg_history TO wbadm;
5347 GRANT ALL ON TABLE pkg_history TO mips;
5348 GRANT SELECT ON TABLE pkg_history TO wb_security;
5352 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5355 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5356 REVOKE ALL ON TABLE transactions FROM wbadm;
5357 GRANT ALL ON TABLE transactions TO wbadm;
5358 GRANT SELECT,INSERT ON TABLE transactions TO mips;
5359 GRANT SELECT ON TABLE transactions TO wb_security;
5363 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5366 REVOKE ALL ON TABLE users FROM PUBLIC;
5367 REVOKE ALL ON TABLE users FROM wbadm;
5368 GRANT ALL ON TABLE users TO wbadm;
5369 GRANT ALL ON TABLE users TO mips;
5372 SET search_path = mips_public, pg_catalog;
5375 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5378 REVOKE ALL ON TABLE packages FROM PUBLIC;
5379 REVOKE ALL ON TABLE packages FROM wbadm;
5380 GRANT ALL ON TABLE packages TO wbadm;
5381 GRANT SELECT ON TABLE packages TO PUBLIC;
5385 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5388 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5389 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5390 GRANT ALL ON TABLE pkg_history TO wbadm;
5391 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5395 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5398 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5399 REVOKE ALL ON TABLE transactions FROM wbadm;
5400 GRANT ALL ON TABLE transactions TO wbadm;
5401 GRANT SELECT ON TABLE transactions TO PUBLIC;
5405 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5408 REVOKE ALL ON TABLE users FROM PUBLIC;
5409 REVOKE ALL ON TABLE users FROM wbadm;
5410 GRANT ALL ON TABLE users TO wbadm;
5411 GRANT SELECT ON TABLE users TO PUBLIC;
5414 SET search_path = mipsel, pg_catalog;
5417 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5420 REVOKE ALL ON TABLE packages FROM PUBLIC;
5421 REVOKE ALL ON TABLE packages FROM wbadm;
5422 GRANT ALL ON TABLE packages TO wbadm;
5423 GRANT ALL ON TABLE packages TO mipsel;
5424 GRANT SELECT ON TABLE packages TO wb_security;
5428 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5431 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5432 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5433 GRANT ALL ON TABLE pkg_history TO wbadm;
5434 GRANT ALL ON TABLE pkg_history TO mipsel;
5435 GRANT SELECT ON TABLE pkg_history TO wb_security;
5439 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5442 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5443 REVOKE ALL ON TABLE transactions FROM wbadm;
5444 GRANT ALL ON TABLE transactions TO wbadm;
5445 GRANT SELECT,INSERT ON TABLE transactions TO mipsel;
5446 GRANT SELECT ON TABLE transactions TO wb_security;
5450 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5453 REVOKE ALL ON TABLE users FROM PUBLIC;
5454 REVOKE ALL ON TABLE users FROM wbadm;
5455 GRANT ALL ON TABLE users TO wbadm;
5456 GRANT ALL ON TABLE users TO mipsel;
5459 SET search_path = mipsel_public, pg_catalog;
5462 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5465 REVOKE ALL ON TABLE packages FROM PUBLIC;
5466 REVOKE ALL ON TABLE packages FROM wbadm;
5467 GRANT ALL ON TABLE packages TO wbadm;
5468 GRANT SELECT ON TABLE packages TO PUBLIC;
5472 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5475 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5476 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5477 GRANT ALL ON TABLE pkg_history TO wbadm;
5478 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5482 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5485 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5486 REVOKE ALL ON TABLE transactions FROM wbadm;
5487 GRANT ALL ON TABLE transactions TO wbadm;
5488 GRANT SELECT ON TABLE transactions TO PUBLIC;
5492 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5495 REVOKE ALL ON TABLE users FROM PUBLIC;
5496 REVOKE ALL ON TABLE users FROM wbadm;
5497 GRANT ALL ON TABLE users TO wbadm;
5498 GRANT SELECT ON TABLE users TO PUBLIC;
5501 SET search_path = powerpc, pg_catalog;
5504 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5507 REVOKE ALL ON TABLE packages FROM PUBLIC;
5508 REVOKE ALL ON TABLE packages FROM wbadm;
5509 GRANT ALL ON TABLE packages TO wbadm;
5510 GRANT ALL ON TABLE packages TO powerpc;
5511 GRANT SELECT ON TABLE packages TO wb_security;
5515 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5518 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5519 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5520 GRANT ALL ON TABLE pkg_history TO wbadm;
5521 GRANT ALL ON TABLE pkg_history TO powerpc;
5522 GRANT SELECT ON TABLE pkg_history TO wb_security;
5526 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5529 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5530 REVOKE ALL ON TABLE transactions FROM wbadm;
5531 GRANT ALL ON TABLE transactions TO wbadm;
5532 GRANT SELECT,INSERT ON TABLE transactions TO powerpc;
5533 GRANT SELECT ON TABLE transactions TO wb_security;
5537 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5540 REVOKE ALL ON TABLE users FROM PUBLIC;
5541 REVOKE ALL ON TABLE users FROM wbadm;
5542 GRANT ALL ON TABLE users TO wbadm;
5543 GRANT ALL ON TABLE users TO powerpc;
5546 SET search_path = powerpc_public, pg_catalog;
5549 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5552 REVOKE ALL ON TABLE packages FROM PUBLIC;
5553 REVOKE ALL ON TABLE packages FROM wbadm;
5554 GRANT ALL ON TABLE packages TO wbadm;
5555 GRANT SELECT ON TABLE packages TO PUBLIC;
5559 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5562 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5563 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5564 GRANT ALL ON TABLE pkg_history TO wbadm;
5565 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5569 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5572 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5573 REVOKE ALL ON TABLE transactions FROM wbadm;
5574 GRANT ALL ON TABLE transactions TO wbadm;
5575 GRANT SELECT ON TABLE transactions TO PUBLIC;
5579 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5582 REVOKE ALL ON TABLE users FROM PUBLIC;
5583 REVOKE ALL ON TABLE users FROM wbadm;
5584 GRANT ALL ON TABLE users TO wbadm;
5585 GRANT SELECT ON TABLE users TO PUBLIC;
5588 SET search_path = public, pg_catalog;
5591 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5594 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5595 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5596 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5597 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5600 SET search_path = s390, pg_catalog;
5603 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5606 REVOKE ALL ON TABLE packages FROM PUBLIC;
5607 REVOKE ALL ON TABLE packages FROM wbadm;
5608 GRANT ALL ON TABLE packages TO wbadm;
5609 GRANT ALL ON TABLE packages TO s390;
5610 GRANT SELECT ON TABLE packages TO wb_security;
5613 SET search_path = sparc, pg_catalog;
5616 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5619 REVOKE ALL ON TABLE packages FROM PUBLIC;
5620 REVOKE ALL ON TABLE packages FROM wbadm;
5621 GRANT ALL ON TABLE packages TO wbadm;
5622 GRANT ALL ON TABLE packages TO sparc;
5623 GRANT SELECT ON TABLE packages TO wb_security;
5626 SET search_path = public, pg_catalog;
5629 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5632 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5633 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5634 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5635 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5639 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
5642 REVOKE ALL ON TABLE distributions FROM PUBLIC;
5643 REVOKE ALL ON TABLE distributions FROM wbadm;
5644 GRANT ALL ON TABLE distributions TO wbadm;
5645 GRANT SELECT ON TABLE distributions TO PUBLIC;
5648 SET search_path = s390, pg_catalog;
5651 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5654 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5655 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5656 GRANT ALL ON TABLE pkg_history TO wbadm;
5657 GRANT ALL ON TABLE pkg_history TO s390;
5658 GRANT SELECT ON TABLE pkg_history TO wb_security;
5661 SET search_path = s390_public, pg_catalog;
5664 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5667 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5668 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5669 GRANT ALL ON TABLE pkg_history TO wbadm;
5670 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5673 SET search_path = sparc, pg_catalog;
5676 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5679 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5680 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5681 GRANT ALL ON TABLE pkg_history TO wbadm;
5682 GRANT ALL ON TABLE pkg_history TO sparc;
5683 GRANT SELECT ON TABLE pkg_history TO wb_security;
5686 SET search_path = sparc_public, pg_catalog;
5689 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5692 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5693 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5694 GRANT ALL ON TABLE pkg_history TO wbadm;
5695 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5698 SET search_path = public, pg_catalog;
5701 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5704 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5705 REVOKE ALL ON TABLE lastlog FROM wbadm;
5706 GRANT ALL ON TABLE lastlog TO wbadm;
5707 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5711 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5714 REVOKE ALL ON TABLE log FROM PUBLIC;
5715 REVOKE ALL ON TABLE log FROM wbadm;
5716 GRANT ALL ON TABLE log TO wbadm;
5717 GRANT SELECT ON TABLE log TO PUBLIC;
5721 -- Name: log_v2; Type: ACL; Schema: public; Owner: pkern
5724 REVOKE ALL ON TABLE log_v2 FROM PUBLIC;
5725 REVOKE ALL ON TABLE log_v2 FROM pkern;
5726 GRANT ALL ON TABLE log_v2 TO pkern;
5727 GRANT SELECT ON TABLE log_v2 TO PUBLIC;
5730 SET search_path = s390_public, pg_catalog;
5733 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5736 REVOKE ALL ON TABLE packages FROM PUBLIC;
5737 REVOKE ALL ON TABLE packages FROM wbadm;
5738 GRANT ALL ON TABLE packages TO wbadm;
5739 GRANT SELECT ON TABLE packages TO PUBLIC;
5742 SET search_path = sparc_public, pg_catalog;
5745 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5748 REVOKE ALL ON TABLE packages FROM PUBLIC;
5749 REVOKE ALL ON TABLE packages FROM wbadm;
5750 GRANT ALL ON TABLE packages TO wbadm;
5751 GRANT SELECT ON TABLE packages TO PUBLIC;
5754 SET search_path = public, pg_catalog;
5757 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5760 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5761 REVOKE ALL ON TABLE packages_all FROM wbadm;
5762 GRANT ALL ON TABLE packages_all TO wbadm;
5763 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5766 SET search_path = s390, pg_catalog;
5769 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5772 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5773 REVOKE ALL ON TABLE transactions FROM wbadm;
5774 GRANT ALL ON TABLE transactions TO wbadm;
5775 GRANT SELECT,INSERT ON TABLE transactions TO s390;
5776 GRANT SELECT ON TABLE transactions TO wb_security;
5780 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5783 REVOKE ALL ON TABLE users FROM PUBLIC;
5784 REVOKE ALL ON TABLE users FROM wbadm;
5785 GRANT ALL ON TABLE users TO wbadm;
5786 GRANT ALL ON TABLE users TO s390;
5789 SET search_path = s390_public, pg_catalog;
5792 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5795 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5796 REVOKE ALL ON TABLE transactions FROM wbadm;
5797 GRANT ALL ON TABLE transactions TO wbadm;
5798 GRANT SELECT ON TABLE transactions TO PUBLIC;
5802 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5805 REVOKE ALL ON TABLE users FROM PUBLIC;
5806 REVOKE ALL ON TABLE users FROM wbadm;
5807 GRANT ALL ON TABLE users TO wbadm;
5808 GRANT SELECT ON TABLE users TO PUBLIC;
5811 SET search_path = sparc, pg_catalog;
5814 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5817 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5818 REVOKE ALL ON TABLE transactions FROM wbadm;
5819 GRANT ALL ON TABLE transactions TO wbadm;
5820 GRANT SELECT,INSERT ON TABLE transactions TO sparc;
5821 GRANT SELECT ON TABLE transactions TO wb_security;
5825 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5828 REVOKE ALL ON TABLE users FROM PUBLIC;
5829 REVOKE ALL ON TABLE users FROM wbadm;
5830 GRANT ALL ON TABLE users TO wbadm;
5831 GRANT ALL ON TABLE users TO sparc;
5834 SET search_path = sparc_public, pg_catalog;
5837 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5840 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5841 REVOKE ALL ON TABLE transactions FROM wbadm;
5842 GRANT ALL ON TABLE transactions TO wbadm;
5843 GRANT SELECT ON TABLE transactions TO PUBLIC;
5847 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5850 REVOKE ALL ON TABLE users FROM PUBLIC;
5851 REVOKE ALL ON TABLE users FROM wbadm;
5852 GRANT ALL ON TABLE users TO wbadm;
5853 GRANT SELECT ON TABLE users TO PUBLIC;
5857 -- PostgreSQL database dump complete