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 ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM alpha.packages GROUP BY packages.distribution UNION SELECT DISTINCT packages.distribution, 'amd64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM amd64.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'arm'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM arm.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'armel'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM armel.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'hppa'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM hppa.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'hurd-i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM "hurd-i386".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM i386.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'ia64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM ia64.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-amd64'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM "kfreebsd-amd64".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-i386'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM "kfreebsd-i386".packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'mips'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM mips.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'mipsel'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM mipsel.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'powerpc'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM powerpc.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 's390'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM s390.packages GROUP BY packages.distribution) UNION SELECT DISTINCT packages.distribution, 'sparc'::character varying AS architecture, count(CASE WHEN ((packages.state)::text = 'Needs-Build'::text) THEN 1 ELSE NULL::integer END) AS needsbuild FROM sparc.packages GROUP BY packages.distribution;
2645 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2648 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2651 CREATE TABLE distributions (
2652 distribution character varying NOT NULL,
2653 public boolean DEFAULT true NOT NULL,
2654 sort_order integer DEFAULT 0,
2655 auto_dep_wait boolean DEFAULT true,
2656 build_dep_resolver character varying,
2657 archive character varying
2661 ALTER TABLE public.distributions OWNER TO wbadm;
2663 SET search_path = s390, pg_catalog;
2666 -- Name: pkg_history; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2669 CREATE TABLE pkg_history (
2670 package character varying NOT NULL,
2671 distribution character varying NOT NULL,
2672 version character varying NOT NULL,
2673 "timestamp" timestamp without time zone NOT NULL,
2674 result character varying NOT NULL,
2680 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2682 SET search_path = s390_public, pg_catalog;
2685 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2688 CREATE VIEW pkg_history AS
2689 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);
2692 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2694 SET search_path = sparc, pg_catalog;
2697 -- Name: pkg_history; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2700 CREATE TABLE pkg_history (
2701 package character varying NOT NULL,
2702 distribution character varying NOT NULL,
2703 version character varying NOT NULL,
2704 "timestamp" timestamp without time zone NOT NULL,
2705 result character varying NOT NULL,
2711 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2713 SET search_path = sparc_public, pg_catalog;
2716 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2719 CREATE VIEW pkg_history AS
2720 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);
2723 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2725 SET search_path = public, pg_catalog;
2728 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2731 CREATE VIEW lastlog AS
2732 ((((((((((((((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;
2735 ALTER TABLE public.lastlog OWNER TO wbadm;
2738 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2742 (((((((((((((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;
2745 ALTER TABLE public.log OWNER TO wbadm;
2748 -- Name: log_v2; Type: VIEW; Schema: public; Owner: pkern
2751 CREATE VIEW log_v2 AS
2752 (((((((((((((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;
2755 ALTER TABLE public.log_v2 OWNER TO pkern;
2757 SET search_path = s390_public, pg_catalog;
2760 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2763 CREATE VIEW packages AS
2764 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);
2767 ALTER TABLE s390_public.packages OWNER TO wbadm;
2769 SET search_path = sparc_public, pg_catalog;
2772 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2775 CREATE VIEW packages AS
2776 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);
2779 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2781 SET search_path = public, pg_catalog;
2784 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2787 CREATE VIEW packages_all AS
2788 (((((((((((((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;
2791 ALTER TABLE public.packages_all OWNER TO wbadm;
2793 SET search_path = s390, pg_catalog;
2796 -- Name: transactions; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2799 CREATE TABLE transactions (
2800 package character varying,
2801 distribution character varying,
2802 version character varying,
2803 action character varying,
2804 prevstate character varying,
2805 state character varying,
2806 real_user character varying,
2807 set_user character varying,
2808 "time" timestamp without time zone
2812 ALTER TABLE s390.transactions OWNER TO wbadm;
2815 -- Name: users; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2818 CREATE TABLE users (
2819 username character varying NOT NULL,
2820 distribution character varying NOT NULL,
2821 last_seen timestamp without time zone
2825 ALTER TABLE s390.users OWNER TO wbadm;
2827 SET search_path = s390_public, pg_catalog;
2830 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2833 CREATE VIEW transactions AS
2834 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);
2837 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2840 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2843 CREATE VIEW users AS
2844 SELECT users.username, users.distribution, users.last_seen FROM s390.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2847 ALTER TABLE s390_public.users OWNER TO wbadm;
2849 SET search_path = sparc, pg_catalog;
2852 -- Name: transactions; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2855 CREATE TABLE transactions (
2856 package character varying,
2857 distribution character varying,
2858 version character varying,
2859 action character varying,
2860 prevstate character varying,
2861 state character varying,
2862 real_user character varying,
2863 set_user character varying,
2864 "time" timestamp without time zone
2868 ALTER TABLE sparc.transactions OWNER TO wbadm;
2871 -- Name: users; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2874 CREATE TABLE users (
2875 username character varying NOT NULL,
2876 distribution character varying NOT NULL,
2877 last_seen timestamp without time zone
2881 ALTER TABLE sparc.users OWNER TO wbadm;
2883 SET search_path = sparc_public, pg_catalog;
2886 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2889 CREATE VIEW transactions AS
2890 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);
2893 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2896 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2899 CREATE VIEW users AS
2900 SELECT users.username, users.distribution, users.last_seen FROM sparc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2903 ALTER TABLE sparc_public.users OWNER TO wbadm;
2905 SET search_path = alpha, pg_catalog;
2908 -- Name: packages_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2911 ALTER TABLE ONLY packages
2912 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2916 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2919 ALTER TABLE ONLY pkg_history
2920 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2924 -- Name: users_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2927 ALTER TABLE ONLY users
2928 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2931 SET search_path = amd64, pg_catalog;
2934 -- Name: packages_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2937 ALTER TABLE ONLY packages
2938 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2942 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2945 ALTER TABLE ONLY pkg_history
2946 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2950 -- Name: users_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2953 ALTER TABLE ONLY users
2954 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2957 SET search_path = arm, pg_catalog;
2960 -- Name: packages_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2963 ALTER TABLE ONLY packages
2964 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2968 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2971 ALTER TABLE ONLY pkg_history
2972 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2976 -- Name: users_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2979 ALTER TABLE ONLY users
2980 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2983 SET search_path = armel, pg_catalog;
2986 -- Name: packages_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
2989 ALTER TABLE ONLY packages
2990 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2994 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
2997 ALTER TABLE ONLY pkg_history
2998 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3002 -- Name: users_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3005 ALTER TABLE ONLY users
3006 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3009 SET search_path = hppa, pg_catalog;
3012 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3015 ALTER TABLE ONLY packages
3016 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3020 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3023 ALTER TABLE ONLY pkg_history
3024 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3028 -- Name: users_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3031 ALTER TABLE ONLY users
3032 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3035 SET search_path = "hurd-i386", pg_catalog;
3038 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3041 ALTER TABLE ONLY packages
3042 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3046 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3049 ALTER TABLE ONLY pkg_history
3050 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3054 -- Name: users_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3057 ALTER TABLE ONLY users
3058 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3061 SET search_path = i386, pg_catalog;
3064 -- Name: packages_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3067 ALTER TABLE ONLY packages
3068 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3072 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3075 ALTER TABLE ONLY pkg_history
3076 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3080 -- Name: users_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3083 ALTER TABLE ONLY users
3084 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3087 SET search_path = ia64, pg_catalog;
3090 -- Name: packages_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3093 ALTER TABLE ONLY packages
3094 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3098 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3101 ALTER TABLE ONLY pkg_history
3102 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3106 -- Name: users_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3109 ALTER TABLE ONLY users
3110 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3113 SET search_path = "kfreebsd-amd64", pg_catalog;
3116 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3119 ALTER TABLE ONLY packages
3120 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3124 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3127 ALTER TABLE ONLY pkg_history
3128 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3132 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3135 ALTER TABLE ONLY users
3136 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3139 SET search_path = "kfreebsd-i386", pg_catalog;
3142 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3145 ALTER TABLE ONLY packages
3146 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3150 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3153 ALTER TABLE ONLY pkg_history
3154 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3158 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3161 ALTER TABLE ONLY users
3162 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3165 SET search_path = mips, pg_catalog;
3168 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3171 ALTER TABLE ONLY packages
3172 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3176 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3179 ALTER TABLE ONLY pkg_history
3180 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3184 -- Name: users_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3187 ALTER TABLE ONLY users
3188 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3191 SET search_path = mipsel, pg_catalog;
3194 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3197 ALTER TABLE ONLY packages
3198 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3202 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3205 ALTER TABLE ONLY pkg_history
3206 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3210 -- Name: users_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3213 ALTER TABLE ONLY users
3214 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3217 SET search_path = powerpc, pg_catalog;
3220 -- Name: packages_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3223 ALTER TABLE ONLY packages
3224 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3228 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3231 ALTER TABLE ONLY pkg_history
3232 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3236 -- Name: users_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3239 ALTER TABLE ONLY users
3240 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3243 SET search_path = public, pg_catalog;
3246 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
3249 ALTER TABLE ONLY distribution_aliases
3250 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
3253 SET search_path = s390, pg_catalog;
3256 -- Name: packages_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3259 ALTER TABLE ONLY packages
3260 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3264 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3267 ALTER TABLE ONLY pkg_history
3268 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3272 -- Name: users_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3275 ALTER TABLE ONLY users
3276 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3279 SET search_path = sparc, pg_catalog;
3282 -- Name: packages_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3285 ALTER TABLE ONLY packages
3286 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3290 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3293 ALTER TABLE ONLY pkg_history
3294 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3298 -- Name: users_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3301 ALTER TABLE ONLY users
3302 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3305 SET search_path = alpha, pg_catalog;
3308 -- Name: idx_alpha_state; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3311 CREATE INDEX idx_alpha_state ON packages USING btree (state);
3315 -- Name: pkg_history_distribution; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3318 CREATE INDEX pkg_history_distribution ON pkg_history USING hash (distribution);
3322 -- Name: pkg_history_index; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3325 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3329 -- Name: pkg_history_timestamp; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3332 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3335 SET search_path = amd64, pg_catalog;
3338 -- Name: idx_amd64_state; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3341 CREATE INDEX idx_amd64_state ON packages USING btree (state);
3345 -- Name: pkg_history_index; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3348 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3352 -- Name: pkg_history_timestamp; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3355 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3358 SET search_path = arm, pg_catalog;
3361 -- Name: idx_arm_state; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3364 CREATE INDEX idx_arm_state ON packages USING btree (state);
3368 -- Name: pkg_history_index; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3371 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3375 -- Name: pkg_history_timestamp; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3378 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3381 SET search_path = armel, pg_catalog;
3384 -- Name: idx_armel_state; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3387 CREATE INDEX idx_armel_state ON packages USING btree (state);
3391 -- Name: pkg_history_index; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3394 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3398 -- Name: pkg_history_timestamp; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3401 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3404 SET search_path = hppa, pg_catalog;
3407 -- Name: idx_hppa_state; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3410 CREATE INDEX idx_hppa_state ON packages USING btree (state);
3414 -- Name: pkg_history_index; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3417 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3421 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3424 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3427 SET search_path = "hurd-i386", pg_catalog;
3430 -- Name: idx_hurd-i386_state; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3433 CREATE INDEX "idx_hurd-i386_state" ON packages USING btree (state);
3437 -- Name: pkg_history_index; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3440 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3444 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3447 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3450 SET search_path = i386, pg_catalog;
3453 -- Name: idx_i386_state; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3456 CREATE INDEX idx_i386_state ON packages USING btree (state);
3460 -- Name: pkg_history_index; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3463 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3467 -- Name: pkg_history_timestamp; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3470 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3473 SET search_path = ia64, pg_catalog;
3476 -- Name: idx_ia64_state; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3479 CREATE INDEX idx_ia64_state ON packages USING btree (state);
3483 -- Name: pkg_history_index; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3486 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3490 -- Name: pkg_history_timestamp; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3493 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3496 SET search_path = "kfreebsd-amd64", pg_catalog;
3499 -- Name: idx_kfreebsd-amd64_state; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3502 CREATE INDEX "idx_kfreebsd-amd64_state" ON packages USING btree (state);
3506 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3509 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3513 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3516 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3519 SET search_path = "kfreebsd-i386", pg_catalog;
3522 -- Name: idx_kfreebsd-i386_state; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3525 CREATE INDEX "idx_kfreebsd-i386_state" ON packages USING btree (state);
3529 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3532 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3536 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3539 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3542 SET search_path = mips, pg_catalog;
3545 -- Name: idx_mips_state; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3548 CREATE INDEX idx_mips_state ON packages USING btree (state);
3552 -- Name: pkg_history_index; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3555 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3559 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3562 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3565 SET search_path = mipsel, pg_catalog;
3568 -- Name: idx_mipsel_state; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3571 CREATE INDEX idx_mipsel_state ON packages USING btree (state);
3575 -- Name: pkg_history_index; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3578 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3582 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3585 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3588 SET search_path = powerpc, pg_catalog;
3591 -- Name: idx_powerpc_state; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3594 CREATE INDEX idx_powerpc_state ON packages USING btree (state);
3598 -- Name: pkg_history_index; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3601 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3605 -- Name: pkg_history_timestamp; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3608 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3611 SET search_path = public, pg_catalog;
3614 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3617 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
3621 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3624 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
3627 SET search_path = s390, pg_catalog;
3630 -- Name: idx_s390_state; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3633 CREATE INDEX idx_s390_state ON packages USING btree (state);
3637 -- Name: pkg_history_index; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3640 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3644 -- Name: pkg_history_timestamp; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3647 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3650 SET search_path = sparc, pg_catalog;
3653 -- Name: idx_sparc_state; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3656 CREATE INDEX idx_sparc_state ON packages USING btree (state);
3660 -- Name: pkg_history_index; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3663 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3667 -- Name: pkg_history_timestamp; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3670 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3673 SET search_path = alpha, pg_catalog;
3676 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3679 ALTER TABLE ONLY packages
3680 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3684 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3687 ALTER TABLE ONLY pkg_history
3688 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3692 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3695 ALTER TABLE ONLY users
3696 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3699 SET search_path = amd64, pg_catalog;
3702 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3705 ALTER TABLE ONLY packages
3706 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3710 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3713 ALTER TABLE ONLY pkg_history
3714 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3718 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3721 ALTER TABLE ONLY users
3722 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3725 SET search_path = arm, pg_catalog;
3728 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3731 ALTER TABLE ONLY packages
3732 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3736 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3739 ALTER TABLE ONLY pkg_history
3740 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3744 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3747 ALTER TABLE ONLY users
3748 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3751 SET search_path = armel, pg_catalog;
3754 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3757 ALTER TABLE ONLY packages
3758 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3762 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3765 ALTER TABLE ONLY pkg_history
3766 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3770 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3773 ALTER TABLE ONLY users
3774 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3777 SET search_path = hppa, pg_catalog;
3780 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3783 ALTER TABLE ONLY packages
3784 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3788 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3791 ALTER TABLE ONLY pkg_history
3792 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3796 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3799 ALTER TABLE ONLY users
3800 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3803 SET search_path = "hurd-i386", pg_catalog;
3806 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3809 ALTER TABLE ONLY packages
3810 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3814 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3817 ALTER TABLE ONLY pkg_history
3818 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3822 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3825 ALTER TABLE ONLY users
3826 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3829 SET search_path = i386, pg_catalog;
3832 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3835 ALTER TABLE ONLY packages
3836 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3840 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3843 ALTER TABLE ONLY pkg_history
3844 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3848 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3851 ALTER TABLE ONLY users
3852 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3855 SET search_path = ia64, pg_catalog;
3858 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3861 ALTER TABLE ONLY packages
3862 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3866 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3869 ALTER TABLE ONLY pkg_history
3870 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3874 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3877 ALTER TABLE ONLY users
3878 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3881 SET search_path = "kfreebsd-amd64", pg_catalog;
3884 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3887 ALTER TABLE ONLY packages
3888 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3892 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3895 ALTER TABLE ONLY pkg_history
3896 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3900 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3903 ALTER TABLE ONLY users
3904 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3907 SET search_path = "kfreebsd-i386", pg_catalog;
3910 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3913 ALTER TABLE ONLY packages
3914 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3918 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3921 ALTER TABLE ONLY pkg_history
3922 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3926 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3929 ALTER TABLE ONLY users
3930 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3933 SET search_path = mips, pg_catalog;
3936 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3939 ALTER TABLE ONLY packages
3940 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3944 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3947 ALTER TABLE ONLY pkg_history
3948 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3952 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3955 ALTER TABLE ONLY users
3956 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3959 SET search_path = mipsel, pg_catalog;
3962 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3965 ALTER TABLE ONLY packages
3966 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3970 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3973 ALTER TABLE ONLY pkg_history
3974 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3978 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3981 ALTER TABLE ONLY users
3982 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3985 SET search_path = powerpc, pg_catalog;
3988 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
3991 ALTER TABLE ONLY packages
3992 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3996 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
3999 ALTER TABLE ONLY pkg_history
4000 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4004 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4007 ALTER TABLE ONLY users
4008 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4011 SET search_path = public, pg_catalog;
4014 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
4017 ALTER TABLE ONLY distribution_aliases
4018 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
4021 SET search_path = s390, pg_catalog;
4024 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4027 ALTER TABLE ONLY packages
4028 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4032 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4035 ALTER TABLE ONLY pkg_history
4036 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4040 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4043 ALTER TABLE ONLY users
4044 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4047 SET search_path = sparc, pg_catalog;
4050 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4053 ALTER TABLE ONLY packages
4054 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4058 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4061 ALTER TABLE ONLY pkg_history
4062 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4066 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4069 ALTER TABLE ONLY users
4070 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4074 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
4077 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
4078 REVOKE ALL ON SCHEMA alpha FROM wbadm;
4079 GRANT ALL ON SCHEMA alpha TO wbadm;
4080 GRANT USAGE ON SCHEMA alpha TO alpha;
4081 GRANT USAGE ON SCHEMA alpha TO wb_all;
4082 GRANT USAGE ON SCHEMA alpha TO wb_security;
4086 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
4089 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
4090 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
4091 GRANT ALL ON SCHEMA alpha_public TO wbadm;
4092 GRANT USAGE ON SCHEMA alpha_public TO alpha;
4093 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
4097 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
4100 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
4101 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
4102 GRANT ALL ON SCHEMA amd64 TO wbadm;
4103 GRANT USAGE ON SCHEMA amd64 TO amd64;
4104 GRANT USAGE ON SCHEMA amd64 TO wb_all;
4105 GRANT USAGE ON SCHEMA amd64 TO wb_security;
4109 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
4112 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
4113 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
4114 GRANT ALL ON SCHEMA amd64_public TO wbadm;
4115 GRANT USAGE ON SCHEMA amd64_public TO amd64;
4116 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
4120 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
4123 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
4124 REVOKE ALL ON SCHEMA arm FROM wbadm;
4125 GRANT ALL ON SCHEMA arm TO wbadm;
4126 GRANT USAGE ON SCHEMA arm TO arm;
4127 GRANT USAGE ON SCHEMA arm TO wb_all;
4128 GRANT USAGE ON SCHEMA arm TO wb_security;
4132 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
4135 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
4136 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
4137 GRANT ALL ON SCHEMA arm_public TO wbadm;
4138 GRANT USAGE ON SCHEMA arm_public TO arm;
4139 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
4143 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
4146 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
4147 REVOKE ALL ON SCHEMA armel FROM wbadm;
4148 GRANT ALL ON SCHEMA armel TO wbadm;
4149 GRANT USAGE ON SCHEMA armel TO armel;
4150 GRANT USAGE ON SCHEMA armel TO wb_all;
4151 GRANT USAGE ON SCHEMA armel TO wb_security;
4155 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
4158 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
4159 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
4160 GRANT ALL ON SCHEMA armel_public TO wbadm;
4161 GRANT USAGE ON SCHEMA armel_public TO armel;
4162 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
4166 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4169 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4170 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4171 GRANT ALL ON SCHEMA hppa TO wbadm;
4172 GRANT USAGE ON SCHEMA hppa TO hppa;
4173 GRANT USAGE ON SCHEMA hppa TO wb_all;
4174 GRANT USAGE ON SCHEMA hppa TO wb_security;
4178 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4181 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4182 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4183 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4184 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4185 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4189 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4192 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4193 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4194 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4195 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4196 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4197 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4201 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4204 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4205 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4206 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4207 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4208 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4212 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4215 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4216 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4217 GRANT ALL ON SCHEMA i386 TO wbadm;
4218 GRANT USAGE ON SCHEMA i386 TO i386;
4219 GRANT USAGE ON SCHEMA i386 TO wb_all;
4220 GRANT USAGE ON SCHEMA i386 TO wb_security;
4224 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4227 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4228 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4229 GRANT ALL ON SCHEMA i386_public TO wbadm;
4230 GRANT USAGE ON SCHEMA i386_public TO i386;
4231 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4235 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4238 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4239 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4240 GRANT ALL ON SCHEMA ia64 TO wbadm;
4241 GRANT USAGE ON SCHEMA ia64 TO ia64;
4242 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4243 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4247 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4250 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4251 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4252 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4253 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4254 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4258 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4261 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4262 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4263 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4264 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4265 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4266 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4270 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4273 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4274 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4275 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4276 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4277 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4281 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4284 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4285 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4286 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4287 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4288 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4289 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4293 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4296 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4297 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4298 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4299 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4300 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4304 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4307 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4308 REVOKE ALL ON SCHEMA mips FROM wbadm;
4309 GRANT ALL ON SCHEMA mips TO wbadm;
4310 GRANT USAGE ON SCHEMA mips TO mips;
4311 GRANT USAGE ON SCHEMA mips TO wb_all;
4312 GRANT USAGE ON SCHEMA mips TO wb_security;
4316 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4319 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4320 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4321 GRANT ALL ON SCHEMA mips_public TO wbadm;
4322 GRANT USAGE ON SCHEMA mips_public TO mips;
4323 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4327 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4330 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4331 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4332 GRANT ALL ON SCHEMA mipsel TO wbadm;
4333 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4334 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4335 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4339 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4342 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4343 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4344 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4345 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4346 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4350 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4353 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4354 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4355 GRANT ALL ON SCHEMA powerpc TO wbadm;
4356 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4357 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4358 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4362 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4365 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4366 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4367 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4368 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4369 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4373 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4376 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4377 REVOKE ALL ON SCHEMA public FROM postgres;
4378 GRANT ALL ON SCHEMA public TO postgres;
4379 GRANT ALL ON SCHEMA public TO PUBLIC;
4383 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4386 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4387 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4388 GRANT ALL ON SCHEMA s390 TO wbadm;
4389 GRANT USAGE ON SCHEMA s390 TO s390;
4390 GRANT USAGE ON SCHEMA s390 TO wb_all;
4391 GRANT USAGE ON SCHEMA s390 TO wb_security;
4395 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4398 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4399 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4400 GRANT ALL ON SCHEMA s390_public TO wbadm;
4401 GRANT USAGE ON SCHEMA s390_public TO s390;
4402 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4406 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4409 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4410 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4411 GRANT ALL ON SCHEMA sparc TO wbadm;
4412 GRANT USAGE ON SCHEMA sparc TO sparc;
4413 GRANT USAGE ON SCHEMA sparc TO wb_all;
4414 GRANT USAGE ON SCHEMA sparc TO wb_security;
4418 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4421 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4422 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4423 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4424 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4425 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4428 SET search_path = alpha, pg_catalog;
4431 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4434 REVOKE ALL ON TABLE packages FROM PUBLIC;
4435 REVOKE ALL ON TABLE packages FROM wbadm;
4436 GRANT ALL ON TABLE packages TO wbadm;
4437 GRANT ALL ON TABLE packages TO alpha;
4438 GRANT SELECT ON TABLE packages TO wb_security;
4442 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4445 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4446 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4447 GRANT ALL ON TABLE pkg_history TO wbadm;
4448 GRANT ALL ON TABLE pkg_history TO alpha;
4449 GRANT SELECT ON TABLE pkg_history TO wb_security;
4453 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4456 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4457 REVOKE ALL ON TABLE transactions FROM wbadm;
4458 GRANT ALL ON TABLE transactions TO wbadm;
4459 GRANT SELECT,INSERT ON TABLE transactions TO alpha;
4460 GRANT SELECT ON TABLE transactions TO wb_security;
4464 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4467 REVOKE ALL ON TABLE users FROM PUBLIC;
4468 REVOKE ALL ON TABLE users FROM wbadm;
4469 GRANT ALL ON TABLE users TO wbadm;
4470 GRANT ALL ON TABLE users TO alpha;
4473 SET search_path = alpha_public, pg_catalog;
4476 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4479 REVOKE ALL ON TABLE packages FROM PUBLIC;
4480 REVOKE ALL ON TABLE packages FROM wbadm;
4481 GRANT ALL ON TABLE packages TO wbadm;
4482 GRANT SELECT ON TABLE packages TO PUBLIC;
4486 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4489 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4490 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4491 GRANT ALL ON TABLE pkg_history TO wbadm;
4492 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4496 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4499 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4500 REVOKE ALL ON TABLE transactions FROM wbadm;
4501 GRANT ALL ON TABLE transactions TO wbadm;
4502 GRANT SELECT ON TABLE transactions TO PUBLIC;
4506 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4509 REVOKE ALL ON TABLE users FROM PUBLIC;
4510 REVOKE ALL ON TABLE users FROM wbadm;
4511 GRANT ALL ON TABLE users TO wbadm;
4512 GRANT SELECT ON TABLE users TO PUBLIC;
4515 SET search_path = amd64, pg_catalog;
4518 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4521 REVOKE ALL ON TABLE packages FROM PUBLIC;
4522 REVOKE ALL ON TABLE packages FROM wbadm;
4523 GRANT ALL ON TABLE packages TO wbadm;
4524 GRANT ALL ON TABLE packages TO amd64;
4525 GRANT SELECT ON TABLE packages TO wb_security;
4529 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4532 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4533 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4534 GRANT ALL ON TABLE pkg_history TO wbadm;
4535 GRANT ALL ON TABLE pkg_history TO amd64;
4536 GRANT SELECT ON TABLE pkg_history TO wb_security;
4540 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4543 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4544 REVOKE ALL ON TABLE transactions FROM wbadm;
4545 GRANT ALL ON TABLE transactions TO wbadm;
4546 GRANT SELECT,INSERT ON TABLE transactions TO amd64;
4547 GRANT SELECT ON TABLE transactions TO wb_security;
4551 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4554 REVOKE ALL ON TABLE users FROM PUBLIC;
4555 REVOKE ALL ON TABLE users FROM wbadm;
4556 GRANT ALL ON TABLE users TO wbadm;
4557 GRANT ALL ON TABLE users TO amd64;
4560 SET search_path = amd64_public, pg_catalog;
4563 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4566 REVOKE ALL ON TABLE packages FROM PUBLIC;
4567 REVOKE ALL ON TABLE packages FROM wbadm;
4568 GRANT ALL ON TABLE packages TO wbadm;
4569 GRANT SELECT ON TABLE packages TO PUBLIC;
4573 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4576 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4577 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4578 GRANT ALL ON TABLE pkg_history TO wbadm;
4579 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4583 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4586 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4587 REVOKE ALL ON TABLE transactions FROM wbadm;
4588 GRANT ALL ON TABLE transactions TO wbadm;
4589 GRANT SELECT ON TABLE transactions TO PUBLIC;
4593 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4596 REVOKE ALL ON TABLE users FROM PUBLIC;
4597 REVOKE ALL ON TABLE users FROM wbadm;
4598 GRANT ALL ON TABLE users TO wbadm;
4599 GRANT SELECT ON TABLE users TO PUBLIC;
4602 SET search_path = arm, pg_catalog;
4605 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4608 REVOKE ALL ON TABLE packages FROM PUBLIC;
4609 REVOKE ALL ON TABLE packages FROM wbadm;
4610 GRANT ALL ON TABLE packages TO wbadm;
4611 GRANT ALL ON TABLE packages TO arm;
4612 GRANT SELECT ON TABLE packages TO wb_security;
4616 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4619 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4620 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4621 GRANT ALL ON TABLE pkg_history TO wbadm;
4622 GRANT ALL ON TABLE pkg_history TO arm;
4623 GRANT SELECT ON TABLE pkg_history TO wb_security;
4627 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4630 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4631 REVOKE ALL ON TABLE transactions FROM wbadm;
4632 GRANT ALL ON TABLE transactions TO wbadm;
4633 GRANT SELECT,INSERT ON TABLE transactions TO arm;
4634 GRANT SELECT ON TABLE transactions TO wb_security;
4638 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4641 REVOKE ALL ON TABLE users FROM PUBLIC;
4642 REVOKE ALL ON TABLE users FROM wbadm;
4643 GRANT ALL ON TABLE users TO wbadm;
4644 GRANT ALL ON TABLE users TO arm;
4647 SET search_path = arm_public, pg_catalog;
4650 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4653 REVOKE ALL ON TABLE packages FROM PUBLIC;
4654 REVOKE ALL ON TABLE packages FROM wbadm;
4655 GRANT ALL ON TABLE packages TO wbadm;
4656 GRANT SELECT ON TABLE packages TO PUBLIC;
4660 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4663 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4664 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4665 GRANT ALL ON TABLE pkg_history TO wbadm;
4666 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4670 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4673 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4674 REVOKE ALL ON TABLE transactions FROM wbadm;
4675 GRANT ALL ON TABLE transactions TO wbadm;
4676 GRANT SELECT ON TABLE transactions TO PUBLIC;
4680 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4683 REVOKE ALL ON TABLE users FROM PUBLIC;
4684 REVOKE ALL ON TABLE users FROM wbadm;
4685 GRANT ALL ON TABLE users TO wbadm;
4686 GRANT SELECT ON TABLE users TO PUBLIC;
4689 SET search_path = armel, pg_catalog;
4692 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4695 REVOKE ALL ON TABLE packages FROM PUBLIC;
4696 REVOKE ALL ON TABLE packages FROM wbadm;
4697 GRANT ALL ON TABLE packages TO wbadm;
4698 GRANT ALL ON TABLE packages TO armel;
4699 GRANT SELECT ON TABLE packages TO wb_security;
4703 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4706 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4707 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4708 GRANT ALL ON TABLE pkg_history TO wbadm;
4709 GRANT ALL ON TABLE pkg_history TO armel;
4710 GRANT SELECT ON TABLE pkg_history TO wb_security;
4714 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4717 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4718 REVOKE ALL ON TABLE transactions FROM wbadm;
4719 GRANT ALL ON TABLE transactions TO wbadm;
4720 GRANT SELECT,INSERT ON TABLE transactions TO armel;
4721 GRANT SELECT ON TABLE transactions TO wb_security;
4725 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4728 REVOKE ALL ON TABLE users FROM PUBLIC;
4729 REVOKE ALL ON TABLE users FROM wbadm;
4730 GRANT ALL ON TABLE users TO wbadm;
4731 GRANT ALL ON TABLE users TO armel;
4734 SET search_path = armel_public, pg_catalog;
4737 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4740 REVOKE ALL ON TABLE packages FROM PUBLIC;
4741 REVOKE ALL ON TABLE packages FROM wbadm;
4742 GRANT ALL ON TABLE packages TO wbadm;
4743 GRANT SELECT ON TABLE packages TO PUBLIC;
4747 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4750 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4751 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4752 GRANT ALL ON TABLE pkg_history TO wbadm;
4753 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4757 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4760 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4761 REVOKE ALL ON TABLE transactions FROM wbadm;
4762 GRANT ALL ON TABLE transactions TO wbadm;
4763 GRANT SELECT ON TABLE transactions TO PUBLIC;
4767 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4770 REVOKE ALL ON TABLE users FROM PUBLIC;
4771 REVOKE ALL ON TABLE users FROM wbadm;
4772 GRANT ALL ON TABLE users TO wbadm;
4773 GRANT SELECT ON TABLE users TO PUBLIC;
4776 SET search_path = hppa, pg_catalog;
4779 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4782 REVOKE ALL ON TABLE packages FROM PUBLIC;
4783 REVOKE ALL ON TABLE packages FROM wbadm;
4784 GRANT ALL ON TABLE packages TO wbadm;
4785 GRANT ALL ON TABLE packages TO hppa;
4786 GRANT SELECT ON TABLE packages TO wb_security;
4790 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4793 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4794 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4795 GRANT ALL ON TABLE pkg_history TO wbadm;
4796 GRANT ALL ON TABLE pkg_history TO hppa;
4797 GRANT SELECT ON TABLE pkg_history TO wb_security;
4801 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4804 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4805 REVOKE ALL ON TABLE transactions FROM wbadm;
4806 GRANT ALL ON TABLE transactions TO wbadm;
4807 GRANT SELECT,INSERT ON TABLE transactions TO hppa;
4808 GRANT SELECT ON TABLE transactions TO wb_security;
4812 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4815 REVOKE ALL ON TABLE users FROM PUBLIC;
4816 REVOKE ALL ON TABLE users FROM wbadm;
4817 GRANT ALL ON TABLE users TO wbadm;
4818 GRANT ALL ON TABLE users TO hppa;
4821 SET search_path = hppa_public, pg_catalog;
4824 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4827 REVOKE ALL ON TABLE packages FROM PUBLIC;
4828 REVOKE ALL ON TABLE packages FROM wbadm;
4829 GRANT ALL ON TABLE packages TO wbadm;
4830 GRANT SELECT ON TABLE packages TO PUBLIC;
4834 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4837 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4838 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4839 GRANT ALL ON TABLE pkg_history TO wbadm;
4840 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4844 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4847 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4848 REVOKE ALL ON TABLE transactions FROM wbadm;
4849 GRANT ALL ON TABLE transactions TO wbadm;
4850 GRANT SELECT ON TABLE transactions TO PUBLIC;
4854 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4857 REVOKE ALL ON TABLE users FROM PUBLIC;
4858 REVOKE ALL ON TABLE users FROM wbadm;
4859 GRANT ALL ON TABLE users TO wbadm;
4860 GRANT SELECT ON TABLE users TO PUBLIC;
4863 SET search_path = "hurd-i386", pg_catalog;
4866 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4869 REVOKE ALL ON TABLE packages FROM PUBLIC;
4870 REVOKE ALL ON TABLE packages FROM wbadm;
4871 GRANT ALL ON TABLE packages TO wbadm;
4872 GRANT ALL ON TABLE packages TO "hurd-i386";
4873 GRANT SELECT ON TABLE packages TO wb_security;
4877 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4880 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4881 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4882 GRANT ALL ON TABLE pkg_history TO wbadm;
4883 GRANT ALL ON TABLE pkg_history TO "hurd-i386";
4884 GRANT SELECT ON TABLE pkg_history TO wb_security;
4888 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4891 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4892 REVOKE ALL ON TABLE transactions FROM wbadm;
4893 GRANT ALL ON TABLE transactions TO wbadm;
4894 GRANT SELECT,INSERT ON TABLE transactions TO "hurd-i386";
4895 GRANT SELECT ON TABLE transactions TO wb_security;
4899 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4902 REVOKE ALL ON TABLE users FROM PUBLIC;
4903 REVOKE ALL ON TABLE users FROM wbadm;
4904 GRANT ALL ON TABLE users TO wbadm;
4905 GRANT ALL ON TABLE users TO "hurd-i386";
4908 SET search_path = "hurd-i386_public", pg_catalog;
4911 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4914 REVOKE ALL ON TABLE packages FROM PUBLIC;
4915 REVOKE ALL ON TABLE packages FROM wbadm;
4916 GRANT ALL ON TABLE packages TO wbadm;
4917 GRANT SELECT ON TABLE packages TO PUBLIC;
4921 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4924 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4925 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4926 GRANT ALL ON TABLE pkg_history TO wbadm;
4927 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4931 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4934 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4935 REVOKE ALL ON TABLE transactions FROM wbadm;
4936 GRANT ALL ON TABLE transactions TO wbadm;
4937 GRANT SELECT ON TABLE transactions TO PUBLIC;
4941 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4944 REVOKE ALL ON TABLE users FROM PUBLIC;
4945 REVOKE ALL ON TABLE users FROM wbadm;
4946 GRANT ALL ON TABLE users TO wbadm;
4947 GRANT SELECT ON TABLE users TO PUBLIC;
4950 SET search_path = i386, pg_catalog;
4953 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4956 REVOKE ALL ON TABLE packages FROM PUBLIC;
4957 REVOKE ALL ON TABLE packages FROM wbadm;
4958 GRANT ALL ON TABLE packages TO wbadm;
4959 GRANT ALL ON TABLE packages TO i386;
4960 GRANT SELECT ON TABLE packages TO wb_security;
4964 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4967 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4968 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4969 GRANT ALL ON TABLE pkg_history TO wbadm;
4970 GRANT ALL ON TABLE pkg_history TO i386;
4971 GRANT SELECT ON TABLE pkg_history TO wb_security;
4975 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
4978 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4979 REVOKE ALL ON TABLE transactions FROM wbadm;
4980 GRANT ALL ON TABLE transactions TO wbadm;
4981 GRANT SELECT,INSERT ON TABLE transactions TO i386;
4982 GRANT SELECT ON TABLE transactions TO wb_security;
4986 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
4989 REVOKE ALL ON TABLE users FROM PUBLIC;
4990 REVOKE ALL ON TABLE users FROM wbadm;
4991 GRANT ALL ON TABLE users TO wbadm;
4992 GRANT ALL ON TABLE users TO i386;
4995 SET search_path = i386_public, pg_catalog;
4998 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5001 REVOKE ALL ON TABLE packages FROM PUBLIC;
5002 REVOKE ALL ON TABLE packages FROM wbadm;
5003 GRANT ALL ON TABLE packages TO wbadm;
5004 GRANT SELECT ON TABLE packages TO PUBLIC;
5008 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5011 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5012 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5013 GRANT ALL ON TABLE pkg_history TO wbadm;
5014 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5018 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5021 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5022 REVOKE ALL ON TABLE transactions FROM wbadm;
5023 GRANT ALL ON TABLE transactions TO wbadm;
5024 GRANT SELECT ON TABLE transactions TO PUBLIC;
5028 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5031 REVOKE ALL ON TABLE users FROM PUBLIC;
5032 REVOKE ALL ON TABLE users FROM wbadm;
5033 GRANT ALL ON TABLE users TO wbadm;
5034 GRANT SELECT ON TABLE users TO PUBLIC;
5037 SET search_path = ia64, pg_catalog;
5040 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5043 REVOKE ALL ON TABLE packages FROM PUBLIC;
5044 REVOKE ALL ON TABLE packages FROM wbadm;
5045 GRANT ALL ON TABLE packages TO wbadm;
5046 GRANT ALL ON TABLE packages TO ia64;
5047 GRANT SELECT ON TABLE packages TO wb_security;
5051 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5054 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5055 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5056 GRANT ALL ON TABLE pkg_history TO wbadm;
5057 GRANT ALL ON TABLE pkg_history TO ia64;
5058 GRANT SELECT ON TABLE pkg_history TO wb_security;
5062 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5065 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5066 REVOKE ALL ON TABLE transactions FROM wbadm;
5067 GRANT ALL ON TABLE transactions TO wbadm;
5068 GRANT SELECT,INSERT ON TABLE transactions TO ia64;
5069 GRANT SELECT ON TABLE transactions TO wb_security;
5073 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5076 REVOKE ALL ON TABLE users FROM PUBLIC;
5077 REVOKE ALL ON TABLE users FROM wbadm;
5078 GRANT ALL ON TABLE users TO wbadm;
5079 GRANT ALL ON TABLE users TO ia64;
5082 SET search_path = ia64_public, pg_catalog;
5085 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5088 REVOKE ALL ON TABLE packages FROM PUBLIC;
5089 REVOKE ALL ON TABLE packages FROM wbadm;
5090 GRANT ALL ON TABLE packages TO wbadm;
5091 GRANT SELECT ON TABLE packages TO PUBLIC;
5095 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5098 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5099 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5100 GRANT ALL ON TABLE pkg_history TO wbadm;
5101 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5105 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5108 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5109 REVOKE ALL ON TABLE transactions FROM wbadm;
5110 GRANT ALL ON TABLE transactions TO wbadm;
5111 GRANT SELECT ON TABLE transactions TO PUBLIC;
5115 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5118 REVOKE ALL ON TABLE users FROM PUBLIC;
5119 REVOKE ALL ON TABLE users FROM wbadm;
5120 GRANT ALL ON TABLE users TO wbadm;
5121 GRANT SELECT ON TABLE users TO PUBLIC;
5124 SET search_path = "kfreebsd-amd64", pg_catalog;
5127 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5130 REVOKE ALL ON TABLE packages FROM PUBLIC;
5131 REVOKE ALL ON TABLE packages FROM wbadm;
5132 GRANT ALL ON TABLE packages TO wbadm;
5133 GRANT ALL ON TABLE packages TO "kfreebsd-amd64";
5134 GRANT SELECT ON TABLE packages TO wb_security;
5138 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5141 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5142 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5143 GRANT ALL ON TABLE pkg_history TO wbadm;
5144 GRANT ALL ON TABLE pkg_history TO "kfreebsd-amd64";
5145 GRANT SELECT ON TABLE pkg_history TO wb_security;
5149 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5152 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5153 REVOKE ALL ON TABLE transactions FROM wbadm;
5154 GRANT ALL ON TABLE transactions TO wbadm;
5155 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-amd64";
5156 GRANT SELECT ON TABLE transactions TO wb_security;
5160 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5163 REVOKE ALL ON TABLE users FROM PUBLIC;
5164 REVOKE ALL ON TABLE users FROM wbadm;
5165 GRANT ALL ON TABLE users TO wbadm;
5166 GRANT ALL ON TABLE users TO "kfreebsd-amd64";
5169 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5172 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5175 REVOKE ALL ON TABLE packages FROM PUBLIC;
5176 REVOKE ALL ON TABLE packages FROM wbadm;
5177 GRANT ALL ON TABLE packages TO wbadm;
5178 GRANT SELECT ON TABLE packages TO PUBLIC;
5182 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5185 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5186 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5187 GRANT ALL ON TABLE pkg_history TO wbadm;
5188 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5192 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5195 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5196 REVOKE ALL ON TABLE transactions FROM wbadm;
5197 GRANT ALL ON TABLE transactions TO wbadm;
5198 GRANT SELECT ON TABLE transactions TO PUBLIC;
5202 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5205 REVOKE ALL ON TABLE users FROM PUBLIC;
5206 REVOKE ALL ON TABLE users FROM wbadm;
5207 GRANT ALL ON TABLE users TO wbadm;
5208 GRANT SELECT ON TABLE users TO PUBLIC;
5211 SET search_path = "kfreebsd-i386", pg_catalog;
5214 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5217 REVOKE ALL ON TABLE packages FROM PUBLIC;
5218 REVOKE ALL ON TABLE packages FROM wbadm;
5219 GRANT ALL ON TABLE packages TO wbadm;
5220 GRANT ALL ON TABLE packages TO "kfreebsd-i386";
5221 GRANT SELECT ON TABLE packages TO wb_security;
5225 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5228 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5229 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5230 GRANT ALL ON TABLE pkg_history TO wbadm;
5231 GRANT ALL ON TABLE pkg_history TO "kfreebsd-i386";
5232 GRANT SELECT ON TABLE pkg_history TO wb_security;
5236 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5239 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5240 REVOKE ALL ON TABLE transactions FROM wbadm;
5241 GRANT ALL ON TABLE transactions TO wbadm;
5242 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-i386";
5243 GRANT SELECT ON TABLE transactions TO wb_security;
5247 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5250 REVOKE ALL ON TABLE users FROM PUBLIC;
5251 REVOKE ALL ON TABLE users FROM wbadm;
5252 GRANT ALL ON TABLE users TO wbadm;
5253 GRANT ALL ON TABLE users TO "kfreebsd-i386";
5256 SET search_path = "kfreebsd-i386_public", pg_catalog;
5259 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5262 REVOKE ALL ON TABLE packages FROM PUBLIC;
5263 REVOKE ALL ON TABLE packages FROM wbadm;
5264 GRANT ALL ON TABLE packages TO wbadm;
5265 GRANT SELECT ON TABLE packages TO PUBLIC;
5269 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5272 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5273 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5274 GRANT ALL ON TABLE pkg_history TO wbadm;
5275 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5279 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5282 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5283 REVOKE ALL ON TABLE transactions FROM wbadm;
5284 GRANT ALL ON TABLE transactions TO wbadm;
5285 GRANT SELECT ON TABLE transactions TO PUBLIC;
5289 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5292 REVOKE ALL ON TABLE users FROM PUBLIC;
5293 REVOKE ALL ON TABLE users FROM wbadm;
5294 GRANT ALL ON TABLE users TO wbadm;
5295 GRANT SELECT ON TABLE users TO PUBLIC;
5298 SET search_path = mips, pg_catalog;
5301 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5304 REVOKE ALL ON TABLE packages FROM PUBLIC;
5305 REVOKE ALL ON TABLE packages FROM wbadm;
5306 GRANT ALL ON TABLE packages TO wbadm;
5307 GRANT ALL ON TABLE packages TO mips;
5308 GRANT SELECT ON TABLE packages TO wb_security;
5312 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5315 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5316 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5317 GRANT ALL ON TABLE pkg_history TO wbadm;
5318 GRANT ALL ON TABLE pkg_history TO mips;
5319 GRANT SELECT ON TABLE pkg_history TO wb_security;
5323 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5326 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5327 REVOKE ALL ON TABLE transactions FROM wbadm;
5328 GRANT ALL ON TABLE transactions TO wbadm;
5329 GRANT SELECT,INSERT ON TABLE transactions TO mips;
5330 GRANT SELECT ON TABLE transactions TO wb_security;
5334 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5337 REVOKE ALL ON TABLE users FROM PUBLIC;
5338 REVOKE ALL ON TABLE users FROM wbadm;
5339 GRANT ALL ON TABLE users TO wbadm;
5340 GRANT ALL ON TABLE users TO mips;
5343 SET search_path = mips_public, pg_catalog;
5346 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5349 REVOKE ALL ON TABLE packages FROM PUBLIC;
5350 REVOKE ALL ON TABLE packages FROM wbadm;
5351 GRANT ALL ON TABLE packages TO wbadm;
5352 GRANT SELECT ON TABLE packages TO PUBLIC;
5356 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5359 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5360 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5361 GRANT ALL ON TABLE pkg_history TO wbadm;
5362 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5366 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5369 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5370 REVOKE ALL ON TABLE transactions FROM wbadm;
5371 GRANT ALL ON TABLE transactions TO wbadm;
5372 GRANT SELECT ON TABLE transactions TO PUBLIC;
5376 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5379 REVOKE ALL ON TABLE users FROM PUBLIC;
5380 REVOKE ALL ON TABLE users FROM wbadm;
5381 GRANT ALL ON TABLE users TO wbadm;
5382 GRANT SELECT ON TABLE users TO PUBLIC;
5385 SET search_path = mipsel, pg_catalog;
5388 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5391 REVOKE ALL ON TABLE packages FROM PUBLIC;
5392 REVOKE ALL ON TABLE packages FROM wbadm;
5393 GRANT ALL ON TABLE packages TO wbadm;
5394 GRANT ALL ON TABLE packages TO mipsel;
5395 GRANT SELECT ON TABLE packages TO wb_security;
5399 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5402 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5403 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5404 GRANT ALL ON TABLE pkg_history TO wbadm;
5405 GRANT ALL ON TABLE pkg_history TO mipsel;
5406 GRANT SELECT ON TABLE pkg_history TO wb_security;
5410 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5413 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5414 REVOKE ALL ON TABLE transactions FROM wbadm;
5415 GRANT ALL ON TABLE transactions TO wbadm;
5416 GRANT SELECT,INSERT ON TABLE transactions TO mipsel;
5417 GRANT SELECT ON TABLE transactions TO wb_security;
5421 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5424 REVOKE ALL ON TABLE users FROM PUBLIC;
5425 REVOKE ALL ON TABLE users FROM wbadm;
5426 GRANT ALL ON TABLE users TO wbadm;
5427 GRANT ALL ON TABLE users TO mipsel;
5430 SET search_path = mipsel_public, pg_catalog;
5433 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5436 REVOKE ALL ON TABLE packages FROM PUBLIC;
5437 REVOKE ALL ON TABLE packages FROM wbadm;
5438 GRANT ALL ON TABLE packages TO wbadm;
5439 GRANT SELECT ON TABLE packages TO PUBLIC;
5443 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5446 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5447 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5448 GRANT ALL ON TABLE pkg_history TO wbadm;
5449 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5453 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5456 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5457 REVOKE ALL ON TABLE transactions FROM wbadm;
5458 GRANT ALL ON TABLE transactions TO wbadm;
5459 GRANT SELECT ON TABLE transactions TO PUBLIC;
5463 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5466 REVOKE ALL ON TABLE users FROM PUBLIC;
5467 REVOKE ALL ON TABLE users FROM wbadm;
5468 GRANT ALL ON TABLE users TO wbadm;
5469 GRANT SELECT ON TABLE users TO PUBLIC;
5472 SET search_path = powerpc, pg_catalog;
5475 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5478 REVOKE ALL ON TABLE packages FROM PUBLIC;
5479 REVOKE ALL ON TABLE packages FROM wbadm;
5480 GRANT ALL ON TABLE packages TO wbadm;
5481 GRANT ALL ON TABLE packages TO powerpc;
5482 GRANT SELECT ON TABLE packages TO wb_security;
5486 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5489 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5490 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5491 GRANT ALL ON TABLE pkg_history TO wbadm;
5492 GRANT ALL ON TABLE pkg_history TO powerpc;
5493 GRANT SELECT ON TABLE pkg_history TO wb_security;
5497 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5500 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5501 REVOKE ALL ON TABLE transactions FROM wbadm;
5502 GRANT ALL ON TABLE transactions TO wbadm;
5503 GRANT SELECT,INSERT ON TABLE transactions TO powerpc;
5504 GRANT SELECT ON TABLE transactions TO wb_security;
5508 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5511 REVOKE ALL ON TABLE users FROM PUBLIC;
5512 REVOKE ALL ON TABLE users FROM wbadm;
5513 GRANT ALL ON TABLE users TO wbadm;
5514 GRANT ALL ON TABLE users TO powerpc;
5517 SET search_path = powerpc_public, pg_catalog;
5520 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5523 REVOKE ALL ON TABLE packages FROM PUBLIC;
5524 REVOKE ALL ON TABLE packages FROM wbadm;
5525 GRANT ALL ON TABLE packages TO wbadm;
5526 GRANT SELECT ON TABLE packages TO PUBLIC;
5530 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5533 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5534 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5535 GRANT ALL ON TABLE pkg_history TO wbadm;
5536 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5540 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5543 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5544 REVOKE ALL ON TABLE transactions FROM wbadm;
5545 GRANT ALL ON TABLE transactions TO wbadm;
5546 GRANT SELECT ON TABLE transactions TO PUBLIC;
5550 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5553 REVOKE ALL ON TABLE users FROM PUBLIC;
5554 REVOKE ALL ON TABLE users FROM wbadm;
5555 GRANT ALL ON TABLE users TO wbadm;
5556 GRANT SELECT ON TABLE users TO PUBLIC;
5559 SET search_path = public, pg_catalog;
5562 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5565 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5566 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5567 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5568 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5571 SET search_path = s390, pg_catalog;
5574 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5577 REVOKE ALL ON TABLE packages FROM PUBLIC;
5578 REVOKE ALL ON TABLE packages FROM wbadm;
5579 GRANT ALL ON TABLE packages TO wbadm;
5580 GRANT ALL ON TABLE packages TO s390;
5581 GRANT SELECT ON TABLE packages TO wb_security;
5584 SET search_path = sparc, pg_catalog;
5587 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5590 REVOKE ALL ON TABLE packages FROM PUBLIC;
5591 REVOKE ALL ON TABLE packages FROM wbadm;
5592 GRANT ALL ON TABLE packages TO wbadm;
5593 GRANT ALL ON TABLE packages TO sparc;
5594 GRANT SELECT ON TABLE packages TO wb_security;
5597 SET search_path = public, pg_catalog;
5600 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5603 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5604 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5605 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5606 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5610 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
5613 REVOKE ALL ON TABLE distributions FROM PUBLIC;
5614 REVOKE ALL ON TABLE distributions FROM wbadm;
5615 GRANT ALL ON TABLE distributions TO wbadm;
5616 GRANT SELECT ON TABLE distributions TO PUBLIC;
5619 SET search_path = s390, pg_catalog;
5622 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5625 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5626 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5627 GRANT ALL ON TABLE pkg_history TO wbadm;
5628 GRANT ALL ON TABLE pkg_history TO s390;
5629 GRANT SELECT ON TABLE pkg_history TO wb_security;
5632 SET search_path = s390_public, pg_catalog;
5635 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5638 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5639 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5640 GRANT ALL ON TABLE pkg_history TO wbadm;
5641 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5644 SET search_path = sparc, pg_catalog;
5647 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5650 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5651 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5652 GRANT ALL ON TABLE pkg_history TO wbadm;
5653 GRANT ALL ON TABLE pkg_history TO sparc;
5654 GRANT SELECT ON TABLE pkg_history TO wb_security;
5657 SET search_path = sparc_public, pg_catalog;
5660 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5663 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5664 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5665 GRANT ALL ON TABLE pkg_history TO wbadm;
5666 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5669 SET search_path = public, pg_catalog;
5672 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5675 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5676 REVOKE ALL ON TABLE lastlog FROM wbadm;
5677 GRANT ALL ON TABLE lastlog TO wbadm;
5678 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5682 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5685 REVOKE ALL ON TABLE log FROM PUBLIC;
5686 REVOKE ALL ON TABLE log FROM wbadm;
5687 GRANT ALL ON TABLE log TO wbadm;
5688 GRANT SELECT ON TABLE log TO PUBLIC;
5692 -- Name: log_v2; Type: ACL; Schema: public; Owner: pkern
5695 REVOKE ALL ON TABLE log_v2 FROM PUBLIC;
5696 REVOKE ALL ON TABLE log_v2 FROM pkern;
5697 GRANT ALL ON TABLE log_v2 TO pkern;
5698 GRANT SELECT ON TABLE log_v2 TO PUBLIC;
5701 SET search_path = s390_public, pg_catalog;
5704 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5707 REVOKE ALL ON TABLE packages FROM PUBLIC;
5708 REVOKE ALL ON TABLE packages FROM wbadm;
5709 GRANT ALL ON TABLE packages TO wbadm;
5710 GRANT SELECT ON TABLE packages TO PUBLIC;
5713 SET search_path = sparc_public, pg_catalog;
5716 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5719 REVOKE ALL ON TABLE packages FROM PUBLIC;
5720 REVOKE ALL ON TABLE packages FROM wbadm;
5721 GRANT ALL ON TABLE packages TO wbadm;
5722 GRANT SELECT ON TABLE packages TO PUBLIC;
5725 SET search_path = public, pg_catalog;
5728 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5731 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5732 REVOKE ALL ON TABLE packages_all FROM wbadm;
5733 GRANT ALL ON TABLE packages_all TO wbadm;
5734 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5737 SET search_path = s390, pg_catalog;
5740 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5743 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5744 REVOKE ALL ON TABLE transactions FROM wbadm;
5745 GRANT ALL ON TABLE transactions TO wbadm;
5746 GRANT SELECT,INSERT ON TABLE transactions TO s390;
5747 GRANT SELECT ON TABLE transactions TO wb_security;
5751 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5754 REVOKE ALL ON TABLE users FROM PUBLIC;
5755 REVOKE ALL ON TABLE users FROM wbadm;
5756 GRANT ALL ON TABLE users TO wbadm;
5757 GRANT ALL ON TABLE users TO s390;
5760 SET search_path = s390_public, pg_catalog;
5763 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5766 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5767 REVOKE ALL ON TABLE transactions FROM wbadm;
5768 GRANT ALL ON TABLE transactions TO wbadm;
5769 GRANT SELECT ON TABLE transactions TO PUBLIC;
5773 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5776 REVOKE ALL ON TABLE users FROM PUBLIC;
5777 REVOKE ALL ON TABLE users FROM wbadm;
5778 GRANT ALL ON TABLE users TO wbadm;
5779 GRANT SELECT ON TABLE users TO PUBLIC;
5782 SET search_path = sparc, pg_catalog;
5785 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5788 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5789 REVOKE ALL ON TABLE transactions FROM wbadm;
5790 GRANT ALL ON TABLE transactions TO wbadm;
5791 GRANT SELECT,INSERT ON TABLE transactions TO sparc;
5792 GRANT SELECT ON TABLE transactions TO wb_security;
5796 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5799 REVOKE ALL ON TABLE users FROM PUBLIC;
5800 REVOKE ALL ON TABLE users FROM wbadm;
5801 GRANT ALL ON TABLE users TO wbadm;
5802 GRANT ALL ON TABLE users TO sparc;
5805 SET search_path = sparc_public, pg_catalog;
5808 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5811 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5812 REVOKE ALL ON TABLE transactions FROM wbadm;
5813 GRANT ALL ON TABLE transactions TO wbadm;
5814 GRANT SELECT ON TABLE transactions TO PUBLIC;
5818 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5821 REVOKE ALL ON TABLE users FROM PUBLIC;
5822 REVOKE ALL ON TABLE users FROM wbadm;
5823 GRANT ALL ON TABLE users TO wbadm;
5824 GRANT SELECT ON TABLE users TO PUBLIC;
5828 -- PostgreSQL database dump complete