2 -- PostgreSQL database dump
5 SET statement_timeout = 0;
6 SET client_encoding = 'SQL_ASCII';
7 SET standard_conforming_strings = off;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
10 SET escape_string_warning = off;
13 -- Name: alpha; Type: SCHEMA; Schema: -; Owner: wbadm
19 ALTER SCHEMA alpha OWNER TO wbadm;
22 -- Name: alpha_public; Type: SCHEMA; Schema: -; Owner: wbadm
25 CREATE SCHEMA alpha_public;
28 ALTER SCHEMA alpha_public OWNER TO wbadm;
31 -- Name: amd64; Type: SCHEMA; Schema: -; Owner: wbadm
37 ALTER SCHEMA amd64 OWNER TO wbadm;
40 -- Name: amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
43 CREATE SCHEMA amd64_public;
46 ALTER SCHEMA amd64_public OWNER TO wbadm;
49 -- Name: arm; Type: SCHEMA; Schema: -; Owner: wbadm
55 ALTER SCHEMA arm OWNER TO wbadm;
58 -- Name: arm_public; Type: SCHEMA; Schema: -; Owner: wbadm
61 CREATE SCHEMA arm_public;
64 ALTER SCHEMA arm_public OWNER TO wbadm;
67 -- Name: armel; Type: SCHEMA; Schema: -; Owner: wbadm
73 ALTER SCHEMA armel OWNER TO wbadm;
76 -- Name: armel_public; Type: SCHEMA; Schema: -; Owner: wbadm
79 CREATE SCHEMA armel_public;
82 ALTER SCHEMA armel_public OWNER TO wbadm;
85 -- Name: hppa; Type: SCHEMA; Schema: -; Owner: wbadm
91 ALTER SCHEMA hppa OWNER TO wbadm;
94 -- Name: hppa_public; Type: SCHEMA; Schema: -; Owner: wbadm
97 CREATE SCHEMA hppa_public;
100 ALTER SCHEMA hppa_public OWNER TO wbadm;
103 -- Name: hurd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
106 CREATE SCHEMA "hurd-i386";
109 ALTER SCHEMA "hurd-i386" OWNER TO wbadm;
112 -- Name: hurd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
115 CREATE SCHEMA "hurd-i386_public";
118 ALTER SCHEMA "hurd-i386_public" OWNER TO wbadm;
121 -- Name: i386; Type: SCHEMA; Schema: -; Owner: wbadm
127 ALTER SCHEMA i386 OWNER TO wbadm;
130 -- Name: i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
133 CREATE SCHEMA i386_public;
136 ALTER SCHEMA i386_public OWNER TO wbadm;
139 -- Name: ia64; Type: SCHEMA; Schema: -; Owner: wbadm
145 ALTER SCHEMA ia64 OWNER TO wbadm;
148 -- Name: ia64_public; Type: SCHEMA; Schema: -; Owner: wbadm
151 CREATE SCHEMA ia64_public;
154 ALTER SCHEMA ia64_public OWNER TO wbadm;
157 -- Name: kfreebsd-amd64; Type: SCHEMA; Schema: -; Owner: wbadm
160 CREATE SCHEMA "kfreebsd-amd64";
163 ALTER SCHEMA "kfreebsd-amd64" OWNER TO wbadm;
166 -- Name: kfreebsd-amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
169 CREATE SCHEMA "kfreebsd-amd64_public";
172 ALTER SCHEMA "kfreebsd-amd64_public" OWNER TO wbadm;
175 -- Name: kfreebsd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
178 CREATE SCHEMA "kfreebsd-i386";
181 ALTER SCHEMA "kfreebsd-i386" OWNER TO wbadm;
184 -- Name: kfreebsd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
187 CREATE SCHEMA "kfreebsd-i386_public";
190 ALTER SCHEMA "kfreebsd-i386_public" OWNER TO wbadm;
193 -- Name: mips; Type: SCHEMA; Schema: -; Owner: wbadm
199 ALTER SCHEMA mips OWNER TO wbadm;
202 -- Name: mips_public; Type: SCHEMA; Schema: -; Owner: wbadm
205 CREATE SCHEMA mips_public;
208 ALTER SCHEMA mips_public OWNER TO wbadm;
211 -- Name: mipsel; Type: SCHEMA; Schema: -; Owner: wbadm
214 CREATE SCHEMA mipsel;
217 ALTER SCHEMA mipsel OWNER TO wbadm;
220 -- Name: mipsel_public; Type: SCHEMA; Schema: -; Owner: wbadm
223 CREATE SCHEMA mipsel_public;
226 ALTER SCHEMA mipsel_public OWNER TO wbadm;
229 -- Name: powerpc; Type: SCHEMA; Schema: -; Owner: wbadm
232 CREATE SCHEMA powerpc;
235 ALTER SCHEMA powerpc OWNER TO wbadm;
238 -- Name: powerpc_public; Type: SCHEMA; Schema: -; Owner: wbadm
241 CREATE SCHEMA powerpc_public;
244 ALTER SCHEMA powerpc_public OWNER TO wbadm;
247 -- Name: s390; Type: SCHEMA; Schema: -; Owner: wbadm
253 ALTER SCHEMA s390 OWNER TO wbadm;
256 -- Name: s390_public; Type: SCHEMA; Schema: -; Owner: wbadm
259 CREATE SCHEMA s390_public;
262 ALTER SCHEMA s390_public OWNER TO wbadm;
265 -- Name: sparc; Type: SCHEMA; Schema: -; Owner: wbadm
271 ALTER SCHEMA sparc OWNER TO wbadm;
274 -- Name: sparc_public; Type: SCHEMA; Schema: -; Owner: wbadm
277 CREATE SCHEMA sparc_public;
280 ALTER SCHEMA sparc_public OWNER TO wbadm;
283 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: wbadm
286 CREATE PROCEDURAL LANGUAGE plpgsql;
289 ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO wbadm;
291 SET search_path = public, pg_catalog;
294 -- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres
297 CREATE TYPE debversion;
301 -- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres
304 CREATE FUNCTION debversionin(cstring) RETURNS debversion
305 LANGUAGE internal IMMUTABLE STRICT
309 ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres;
312 -- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres
315 CREATE FUNCTION debversionout(debversion) RETURNS cstring
316 LANGUAGE internal IMMUTABLE STRICT
320 ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres;
323 -- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres
326 CREATE FUNCTION debversionrecv(internal) RETURNS debversion
327 LANGUAGE internal STABLE STRICT
331 ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres;
334 -- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres
337 CREATE FUNCTION debversionsend(debversion) RETURNS bytea
338 LANGUAGE internal STABLE STRICT
342 ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres;
345 -- Name: debversion; Type: TYPE; Schema: public; Owner: postgres
348 CREATE TYPE debversion (
349 INTERNALLENGTH = variable,
350 INPUT = debversionin,
351 OUTPUT = debversionout,
352 RECEIVE = debversionrecv,
353 SEND = debversionsend,
360 ALTER TYPE public.debversion OWNER TO postgres;
363 -- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres
366 COMMENT ON TYPE debversion IS 'Debian package version number';
370 -- Name: commacat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
373 CREATE FUNCTION commacat(acc text, instr text) RETURNS text
377 IF acc IS NULL OR acc = '' THEN
380 RETURN acc || ', ' || instr;
386 ALTER FUNCTION public.commacat(acc text, instr text) OWNER TO pkern;
389 -- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres
392 CREATE FUNCTION debversion(character) RETURNS debversion
393 LANGUAGE internal IMMUTABLE STRICT
397 ALTER FUNCTION public.debversion(character) OWNER TO postgres;
400 -- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
403 CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer
404 LANGUAGE c IMMUTABLE STRICT
405 AS '$libdir/debversion', 'debversion_cmp';
408 ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres;
411 -- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
414 COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions';
418 -- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
421 CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean
422 LANGUAGE c IMMUTABLE STRICT
423 AS '$libdir/debversion', 'debversion_eq';
426 ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres;
429 -- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
432 COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal';
436 -- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
439 CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean
440 LANGUAGE c IMMUTABLE STRICT
441 AS '$libdir/debversion', 'debversion_ge';
444 ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres;
447 -- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
450 COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal';
454 -- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
457 CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean
458 LANGUAGE c IMMUTABLE STRICT
459 AS '$libdir/debversion', 'debversion_gt';
462 ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres;
465 -- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
468 COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than';
472 -- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres
475 CREATE FUNCTION debversion_hash(debversion) RETURNS integer
476 LANGUAGE c IMMUTABLE STRICT
477 AS '$libdir/debversion', 'debversion_hash';
480 ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres;
483 -- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
486 CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion
487 LANGUAGE c IMMUTABLE STRICT
488 AS '$libdir/debversion', 'debversion_larger';
491 ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres;
494 -- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
497 CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean
498 LANGUAGE c IMMUTABLE STRICT
499 AS '$libdir/debversion', 'debversion_le';
502 ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres;
505 -- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
508 COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal';
512 -- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
515 CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean
516 LANGUAGE c IMMUTABLE STRICT
517 AS '$libdir/debversion', 'debversion_lt';
520 ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres;
523 -- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
526 COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than';
530 -- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
533 CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean
534 LANGUAGE c IMMUTABLE STRICT
535 AS '$libdir/debversion', 'debversion_ne';
538 ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres;
541 -- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
544 COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal';
548 -- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
551 CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion
552 LANGUAGE c IMMUTABLE STRICT
553 AS '$libdir/debversion', 'debversion_smaller';
556 ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres;
559 -- Name: query_source_package(character varying, character varying); Type: FUNCTION; Schema: public; Owner: wbadm
562 CREATE FUNCTION query_source_package(param_dist character varying, param_srcpkg character varying) RETURNS SETOF record
568 SELECT 'alpha'::character varying AS arch, * INTO temp_row FROM "alpha_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
570 RETURN NEXT temp_row;
572 SELECT 'amd64'::character varying AS arch, * INTO temp_row FROM "amd64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
574 RETURN NEXT temp_row;
576 SELECT 'arm'::character varying AS arch, * INTO temp_row FROM "arm_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
578 RETURN NEXT temp_row;
580 SELECT 'armel'::character varying AS arch, * INTO temp_row FROM "armel_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
582 RETURN NEXT temp_row;
584 SELECT 'hppa'::character varying AS arch, * INTO temp_row FROM "hppa_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
586 RETURN NEXT temp_row;
588 SELECT 'hurd-i386'::character varying AS arch, * INTO temp_row FROM "hurd-i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
590 RETURN NEXT temp_row;
592 SELECT 'i386'::character varying AS arch, * INTO temp_row FROM "i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
594 RETURN NEXT temp_row;
596 SELECT 'ia64'::character varying AS arch, * INTO temp_row FROM "ia64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
598 RETURN NEXT temp_row;
600 SELECT 'kfreebsd-amd64'::character varying AS arch, * INTO temp_row FROM "kfreebsd-amd64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
602 RETURN NEXT temp_row;
604 SELECT 'freebsd-i386'::character varying AS arch, * INTO temp_row FROM "kfreebsd-i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
606 RETURN NEXT temp_row;
608 SELECT 'mips'::character varying AS arch, * INTO temp_row FROM "mips_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
610 RETURN NEXT temp_row;
612 SELECT 'mipsel'::character varying AS arch, * INTO temp_row FROM "mipsel_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
614 RETURN NEXT temp_row;
616 SELECT 'powerpc'::character varying AS arch, * INTO temp_row FROM "powerpc_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
618 RETURN NEXT temp_row;
620 SELECT 's390'::character varying AS arch, * INTO temp_row FROM "s390_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
622 RETURN NEXT temp_row;
624 SELECT 'sparc'::character varying AS arch, * INTO temp_row FROM "sparc_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
626 RETURN NEXT temp_row;
632 ALTER FUNCTION public.query_source_package(param_dist character varying, param_srcpkg character varying) OWNER TO wbadm;
635 -- Name: spacecat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
638 CREATE FUNCTION spacecat(acc text, instr text) RETURNS text
642 IF acc IS NULL OR acc = '' THEN
645 RETURN acc || ' ' || instr;
651 ALTER FUNCTION public.spacecat(acc text, instr text) OWNER TO pkern;
654 -- Name: commacat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
657 CREATE AGGREGATE commacat_all(text) (
664 ALTER AGGREGATE public.commacat_all(text) OWNER TO pkern;
667 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
671 PROCEDURE = debversion_gt,
672 LEFTARG = debversion,
673 RIGHTARG = debversion,
679 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
682 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
685 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
689 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
692 CREATE AGGREGATE max(debversion) (
693 SFUNC = debversion_larger,
699 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
702 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
706 PROCEDURE = debversion_lt,
707 LEFTARG = debversion,
708 RIGHTARG = debversion,
714 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
717 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
720 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
724 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
727 CREATE AGGREGATE min(debversion) (
728 SFUNC = debversion_smaller,
734 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
737 -- Name: spacecat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
740 CREATE AGGREGATE spacecat_all(text) (
747 ALTER AGGREGATE public.spacecat_all(text) OWNER TO pkern;
750 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
754 PROCEDURE = debversion_le,
755 LEFTARG = debversion,
756 RIGHTARG = debversion,
762 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
765 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
768 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
772 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
776 PROCEDURE = debversion_ne,
777 LEFTARG = debversion,
778 RIGHTARG = debversion,
784 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
787 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
790 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
794 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
798 PROCEDURE = debversion_eq,
799 LEFTARG = debversion,
800 RIGHTARG = debversion,
806 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
809 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
812 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
816 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
820 PROCEDURE = debversion_ge,
821 LEFTARG = debversion,
822 RIGHTARG = debversion,
828 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
831 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
834 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
838 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
841 CREATE OPERATOR CLASS debversion_ops
842 DEFAULT FOR TYPE debversion USING btree AS
843 OPERATOR 1 <(debversion,debversion) ,
844 OPERATOR 2 <=(debversion,debversion) ,
845 OPERATOR 3 =(debversion,debversion) ,
846 OPERATOR 4 >=(debversion,debversion) ,
847 OPERATOR 5 >(debversion,debversion) ,
848 FUNCTION 1 debversion_cmp(debversion,debversion);
851 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
854 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
857 CREATE OPERATOR CLASS debversion_ops
858 DEFAULT FOR TYPE debversion USING hash AS
859 OPERATOR 1 =(debversion,debversion) ,
860 FUNCTION 1 debversion_hash(debversion);
863 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
865 SET search_path = pg_catalog;
868 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
871 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
875 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
878 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
882 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
885 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
889 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
892 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
896 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
899 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
903 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
906 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
909 SET search_path = alpha, pg_catalog;
911 SET default_tablespace = '';
913 SET default_with_oids = false;
916 -- Name: packages; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
919 CREATE TABLE packages (
920 package character varying NOT NULL,
921 distribution character varying NOT NULL,
922 version character varying,
923 state character varying,
924 section character varying,
925 priority character varying,
926 installed_version character varying,
927 previous_state character varying,
928 state_change timestamp without time zone,
929 notes character varying,
930 builder character varying,
933 binary_nmu_version integer,
934 binary_nmu_changelog character varying,
935 failed_category character varying,
936 permbuildpri integer,
938 depends character varying,
939 rel character varying,
941 extra_depends character varying,
942 extra_conflicts character varying,
943 build_arch_all boolean DEFAULT false NOT NULL
947 ALTER TABLE alpha.packages OWNER TO wbadm;
950 -- Name: pkg_history; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
953 CREATE TABLE pkg_history (
954 package character varying NOT NULL,
955 distribution character varying NOT NULL,
956 version character varying NOT NULL,
957 "timestamp" timestamp without time zone NOT NULL,
958 result character varying NOT NULL,
964 ALTER TABLE alpha.pkg_history OWNER TO wbadm;
967 -- Name: transactions; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
970 CREATE TABLE transactions (
971 package character varying,
972 distribution character varying,
973 version character varying,
974 action character varying,
975 prevstate character varying,
976 state character varying,
977 real_user character varying,
978 set_user character varying,
979 "time" timestamp without time zone
983 ALTER TABLE alpha.transactions OWNER TO wbadm;
986 -- Name: users; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
990 username character varying NOT NULL,
991 distribution character varying NOT NULL,
992 last_seen timestamp without time zone
996 ALTER TABLE alpha.users OWNER TO wbadm;
998 SET search_path = alpha_public, pg_catalog;
1001 -- Name: packages; Type: VIEW; Schema: alpha_public; Owner: wbadm
1004 CREATE VIEW packages AS
1005 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM alpha.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1008 ALTER TABLE alpha_public.packages OWNER TO wbadm;
1011 -- Name: pkg_history; Type: VIEW; Schema: alpha_public; Owner: wbadm
1014 CREATE VIEW pkg_history AS
1015 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);
1018 ALTER TABLE alpha_public.pkg_history OWNER TO wbadm;
1021 -- Name: transactions; Type: VIEW; Schema: alpha_public; Owner: wbadm
1024 CREATE VIEW transactions AS
1025 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);
1028 ALTER TABLE alpha_public.transactions OWNER TO wbadm;
1031 -- Name: users; Type: VIEW; Schema: alpha_public; Owner: wbadm
1034 CREATE VIEW users AS
1035 SELECT users.username, users.distribution, users.last_seen FROM alpha.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1038 ALTER TABLE alpha_public.users OWNER TO wbadm;
1040 SET search_path = amd64, pg_catalog;
1043 -- Name: packages; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1046 CREATE TABLE packages (
1047 package character varying NOT NULL,
1048 distribution character varying NOT NULL,
1049 version character varying,
1050 state character varying,
1051 section character varying,
1052 priority character varying,
1053 installed_version character varying,
1054 previous_state character varying,
1055 state_change timestamp without time zone,
1056 notes character varying,
1057 builder character varying,
1060 binary_nmu_version integer,
1061 binary_nmu_changelog character varying,
1062 failed_category character varying,
1063 permbuildpri integer,
1065 depends character varying,
1066 rel character varying,
1068 extra_depends character varying,
1069 extra_conflicts character varying,
1070 build_arch_all boolean DEFAULT false NOT NULL
1074 ALTER TABLE amd64.packages OWNER TO wbadm;
1077 -- Name: pkg_history; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1080 CREATE TABLE pkg_history (
1081 package character varying NOT NULL,
1082 distribution character varying NOT NULL,
1083 version character varying NOT NULL,
1084 "timestamp" timestamp without time zone NOT NULL,
1085 result character varying NOT NULL,
1091 ALTER TABLE amd64.pkg_history OWNER TO wbadm;
1094 -- Name: transactions; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1097 CREATE TABLE transactions (
1098 package character varying,
1099 distribution character varying,
1100 version character varying,
1101 action character varying,
1102 prevstate character varying,
1103 state character varying,
1104 real_user character varying,
1105 set_user character varying,
1106 "time" timestamp without time zone
1110 ALTER TABLE amd64.transactions OWNER TO wbadm;
1113 -- Name: users; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1116 CREATE TABLE users (
1117 username character varying NOT NULL,
1118 distribution character varying NOT NULL,
1119 last_seen timestamp without time zone
1123 ALTER TABLE amd64.users OWNER TO wbadm;
1125 SET search_path = amd64_public, pg_catalog;
1128 -- Name: packages; Type: VIEW; Schema: amd64_public; Owner: wbadm
1131 CREATE VIEW packages AS
1132 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM amd64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1135 ALTER TABLE amd64_public.packages OWNER TO wbadm;
1138 -- Name: pkg_history; Type: VIEW; Schema: amd64_public; Owner: wbadm
1141 CREATE VIEW pkg_history AS
1142 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);
1145 ALTER TABLE amd64_public.pkg_history OWNER TO wbadm;
1148 -- Name: transactions; Type: VIEW; Schema: amd64_public; Owner: wbadm
1151 CREATE VIEW transactions AS
1152 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);
1155 ALTER TABLE amd64_public.transactions OWNER TO wbadm;
1158 -- Name: users; Type: VIEW; Schema: amd64_public; Owner: wbadm
1161 CREATE VIEW users AS
1162 SELECT users.username, users.distribution, users.last_seen FROM amd64.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1165 ALTER TABLE amd64_public.users OWNER TO wbadm;
1167 SET search_path = arm, pg_catalog;
1170 -- Name: packages; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1173 CREATE TABLE packages (
1174 package character varying NOT NULL,
1175 distribution character varying NOT NULL,
1176 version character varying,
1177 state character varying,
1178 section character varying,
1179 priority character varying,
1180 installed_version character varying,
1181 previous_state character varying,
1182 state_change timestamp without time zone,
1183 notes character varying,
1184 builder character varying,
1187 binary_nmu_version integer,
1188 binary_nmu_changelog character varying,
1189 failed_category character varying,
1190 permbuildpri integer,
1192 depends character varying,
1193 rel character varying,
1195 extra_depends character varying,
1196 extra_conflicts character varying,
1197 build_arch_all boolean DEFAULT false NOT NULL
1201 ALTER TABLE arm.packages OWNER TO wbadm;
1204 -- Name: pkg_history; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1207 CREATE TABLE pkg_history (
1208 package character varying NOT NULL,
1209 distribution character varying NOT NULL,
1210 version character varying NOT NULL,
1211 "timestamp" timestamp without time zone NOT NULL,
1212 result character varying NOT NULL,
1218 ALTER TABLE arm.pkg_history OWNER TO wbadm;
1221 -- Name: transactions; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1224 CREATE TABLE transactions (
1225 package character varying,
1226 distribution character varying,
1227 version character varying,
1228 action character varying,
1229 prevstate character varying,
1230 state character varying,
1231 real_user character varying,
1232 set_user character varying,
1233 "time" timestamp without time zone
1237 ALTER TABLE arm.transactions OWNER TO wbadm;
1240 -- Name: users; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1243 CREATE TABLE users (
1244 username character varying NOT NULL,
1245 distribution character varying NOT NULL,
1246 last_seen timestamp without time zone
1250 ALTER TABLE arm.users OWNER TO wbadm;
1252 SET search_path = arm_public, pg_catalog;
1255 -- Name: packages; Type: VIEW; Schema: arm_public; Owner: wbadm
1258 CREATE VIEW packages AS
1259 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM arm.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1262 ALTER TABLE arm_public.packages OWNER TO wbadm;
1265 -- Name: pkg_history; Type: VIEW; Schema: arm_public; Owner: wbadm
1268 CREATE VIEW pkg_history AS
1269 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);
1272 ALTER TABLE arm_public.pkg_history OWNER TO wbadm;
1275 -- Name: transactions; Type: VIEW; Schema: arm_public; Owner: wbadm
1278 CREATE VIEW transactions AS
1279 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);
1282 ALTER TABLE arm_public.transactions OWNER TO wbadm;
1285 -- Name: users; Type: VIEW; Schema: arm_public; Owner: wbadm
1288 CREATE VIEW users AS
1289 SELECT users.username, users.distribution, users.last_seen FROM arm.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1292 ALTER TABLE arm_public.users OWNER TO wbadm;
1294 SET search_path = armel, pg_catalog;
1297 -- Name: packages; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1300 CREATE TABLE packages (
1301 package character varying NOT NULL,
1302 distribution character varying NOT NULL,
1303 version character varying,
1304 state character varying,
1305 section character varying,
1306 priority character varying,
1307 installed_version character varying,
1308 previous_state character varying,
1309 state_change timestamp without time zone,
1310 notes character varying,
1311 builder character varying,
1314 binary_nmu_version integer,
1315 binary_nmu_changelog character varying,
1316 failed_category character varying,
1317 permbuildpri integer,
1319 depends character varying,
1320 rel character varying,
1322 extra_depends character varying,
1323 extra_conflicts character varying,
1324 build_arch_all boolean DEFAULT false NOT NULL
1328 ALTER TABLE armel.packages OWNER TO wbadm;
1331 -- Name: pkg_history; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1334 CREATE TABLE pkg_history (
1335 package character varying NOT NULL,
1336 distribution character varying NOT NULL,
1337 version character varying NOT NULL,
1338 "timestamp" timestamp without time zone NOT NULL,
1339 result character varying NOT NULL,
1345 ALTER TABLE armel.pkg_history OWNER TO wbadm;
1348 -- Name: transactions; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1351 CREATE TABLE transactions (
1352 package character varying,
1353 distribution character varying,
1354 version character varying,
1355 action character varying,
1356 prevstate character varying,
1357 state character varying,
1358 real_user character varying,
1359 set_user character varying,
1360 "time" timestamp without time zone
1364 ALTER TABLE armel.transactions OWNER TO wbadm;
1367 -- Name: users; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1370 CREATE TABLE users (
1371 username character varying NOT NULL,
1372 distribution character varying NOT NULL,
1373 last_seen timestamp without time zone
1377 ALTER TABLE armel.users OWNER TO wbadm;
1379 SET search_path = armel_public, pg_catalog;
1382 -- Name: packages; Type: VIEW; Schema: armel_public; Owner: wbadm
1385 CREATE VIEW packages AS
1386 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM armel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1389 ALTER TABLE armel_public.packages OWNER TO wbadm;
1392 -- Name: pkg_history; Type: VIEW; Schema: armel_public; Owner: wbadm
1395 CREATE VIEW pkg_history AS
1396 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);
1399 ALTER TABLE armel_public.pkg_history OWNER TO wbadm;
1402 -- Name: transactions; Type: VIEW; Schema: armel_public; Owner: wbadm
1405 CREATE VIEW transactions AS
1406 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);
1409 ALTER TABLE armel_public.transactions OWNER TO wbadm;
1412 -- Name: users; Type: VIEW; Schema: armel_public; Owner: wbadm
1415 CREATE VIEW users AS
1416 SELECT users.username, users.distribution, users.last_seen FROM armel.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1419 ALTER TABLE armel_public.users OWNER TO wbadm;
1421 SET search_path = hppa, pg_catalog;
1424 -- Name: packages; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1427 CREATE TABLE packages (
1428 package character varying NOT NULL,
1429 distribution character varying NOT NULL,
1430 version character varying,
1431 state character varying,
1432 section character varying,
1433 priority character varying,
1434 installed_version character varying,
1435 previous_state character varying,
1436 state_change timestamp without time zone,
1437 notes character varying,
1438 builder character varying,
1441 binary_nmu_version integer,
1442 binary_nmu_changelog character varying,
1443 failed_category character varying,
1444 permbuildpri integer,
1446 depends character varying,
1447 rel character varying,
1449 extra_depends character varying,
1450 extra_conflicts character varying,
1451 build_arch_all boolean DEFAULT false NOT NULL
1455 ALTER TABLE hppa.packages OWNER TO wbadm;
1458 -- Name: pkg_history; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1461 CREATE TABLE pkg_history (
1462 package character varying NOT NULL,
1463 distribution character varying NOT NULL,
1464 version character varying NOT NULL,
1465 "timestamp" timestamp without time zone NOT NULL,
1466 result character varying NOT NULL,
1472 ALTER TABLE hppa.pkg_history OWNER TO wbadm;
1475 -- Name: transactions; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1478 CREATE TABLE transactions (
1479 package character varying,
1480 distribution character varying,
1481 version character varying,
1482 action character varying,
1483 prevstate character varying,
1484 state character varying,
1485 real_user character varying,
1486 set_user character varying,
1487 "time" timestamp without time zone
1491 ALTER TABLE hppa.transactions OWNER TO wbadm;
1494 -- Name: users; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1497 CREATE TABLE users (
1498 username character varying NOT NULL,
1499 distribution character varying NOT NULL,
1500 last_seen timestamp without time zone
1504 ALTER TABLE hppa.users OWNER TO wbadm;
1506 SET search_path = hppa_public, pg_catalog;
1509 -- Name: packages; Type: VIEW; Schema: hppa_public; Owner: wbadm
1512 CREATE VIEW packages AS
1513 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM hppa.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1516 ALTER TABLE hppa_public.packages OWNER TO wbadm;
1519 -- Name: pkg_history; Type: VIEW; Schema: hppa_public; Owner: wbadm
1522 CREATE VIEW pkg_history AS
1523 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);
1526 ALTER TABLE hppa_public.pkg_history OWNER TO wbadm;
1529 -- Name: transactions; Type: VIEW; Schema: hppa_public; Owner: wbadm
1532 CREATE VIEW transactions AS
1533 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);
1536 ALTER TABLE hppa_public.transactions OWNER TO wbadm;
1539 -- Name: users; Type: VIEW; Schema: hppa_public; Owner: wbadm
1542 CREATE VIEW users AS
1543 SELECT users.username, users.distribution, users.last_seen FROM hppa.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1546 ALTER TABLE hppa_public.users OWNER TO wbadm;
1548 SET search_path = "hurd-i386", pg_catalog;
1551 -- Name: packages; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1554 CREATE TABLE packages (
1555 package character varying NOT NULL,
1556 distribution character varying NOT NULL,
1557 version character varying,
1558 state character varying,
1559 section character varying,
1560 priority character varying,
1561 installed_version character varying,
1562 previous_state character varying,
1563 state_change timestamp without time zone,
1564 notes character varying,
1565 builder character varying,
1568 binary_nmu_version integer,
1569 binary_nmu_changelog character varying,
1570 failed_category character varying,
1571 permbuildpri integer,
1573 depends character varying,
1574 rel character varying,
1576 extra_depends character varying,
1577 extra_conflicts character varying,
1578 build_arch_all boolean DEFAULT false NOT NULL
1582 ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
1585 -- Name: pkg_history; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1588 CREATE TABLE pkg_history (
1589 package character varying NOT NULL,
1590 distribution character varying NOT NULL,
1591 version character varying NOT NULL,
1592 "timestamp" timestamp without time zone NOT NULL,
1593 result character varying NOT NULL,
1599 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
1602 -- Name: transactions; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1605 CREATE TABLE transactions (
1606 package character varying,
1607 distribution character varying,
1608 version character varying,
1609 action character varying,
1610 prevstate character varying,
1611 state character varying,
1612 real_user character varying,
1613 set_user character varying,
1614 "time" timestamp without time zone
1618 ALTER TABLE "hurd-i386".transactions OWNER TO wbadm;
1621 -- Name: users; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1624 CREATE TABLE users (
1625 username character varying NOT NULL,
1626 distribution character varying NOT NULL,
1627 last_seen timestamp without time zone
1631 ALTER TABLE "hurd-i386".users OWNER TO wbadm;
1633 SET search_path = "hurd-i386_public", pg_catalog;
1636 -- Name: packages; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1639 CREATE VIEW packages AS
1640 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM "hurd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1643 ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
1646 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1649 CREATE VIEW pkg_history AS
1650 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);
1653 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
1656 -- Name: transactions; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1659 CREATE VIEW transactions AS
1660 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);
1663 ALTER TABLE "hurd-i386_public".transactions OWNER TO wbadm;
1666 -- Name: users; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1669 CREATE VIEW users AS
1670 SELECT users.username, users.distribution, users.last_seen FROM "hurd-i386".users WHERE ((users.distribution)::text !~~ '%-security'::text);
1673 ALTER TABLE "hurd-i386_public".users OWNER TO wbadm;
1675 SET search_path = i386, pg_catalog;
1678 -- Name: packages; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1681 CREATE TABLE packages (
1682 package character varying NOT NULL,
1683 distribution character varying NOT NULL,
1684 version character varying,
1685 state character varying,
1686 section character varying,
1687 priority character varying,
1688 installed_version character varying,
1689 previous_state character varying,
1690 state_change timestamp without time zone,
1691 notes character varying,
1692 builder character varying,
1695 binary_nmu_version integer,
1696 binary_nmu_changelog character varying,
1697 failed_category character varying,
1698 permbuildpri integer,
1700 depends character varying,
1701 rel character varying,
1703 extra_depends character varying,
1704 extra_conflicts character varying,
1705 build_arch_all boolean DEFAULT false NOT NULL
1709 ALTER TABLE i386.packages OWNER TO wbadm;
1712 -- Name: pkg_history; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1715 CREATE TABLE pkg_history (
1716 package character varying NOT NULL,
1717 distribution character varying NOT NULL,
1718 version character varying NOT NULL,
1719 "timestamp" timestamp without time zone NOT NULL,
1720 result character varying NOT NULL,
1726 ALTER TABLE i386.pkg_history OWNER TO wbadm;
1729 -- Name: transactions; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1732 CREATE TABLE transactions (
1733 package character varying,
1734 distribution character varying,
1735 version character varying,
1736 action character varying,
1737 prevstate character varying,
1738 state character varying,
1739 real_user character varying,
1740 set_user character varying,
1741 "time" timestamp without time zone
1745 ALTER TABLE i386.transactions OWNER TO wbadm;
1748 -- Name: users; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1751 CREATE TABLE users (
1752 username character varying NOT NULL,
1753 distribution character varying NOT NULL,
1754 last_seen timestamp without time zone
1758 ALTER TABLE i386.users OWNER TO wbadm;
1760 SET search_path = i386_public, pg_catalog;
1763 -- Name: packages; Type: VIEW; Schema: i386_public; Owner: wbadm
1766 CREATE VIEW packages AS
1767 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM i386.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1770 ALTER TABLE i386_public.packages OWNER TO wbadm;
1773 -- Name: pkg_history; Type: VIEW; Schema: i386_public; Owner: wbadm
1776 CREATE VIEW pkg_history AS
1777 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);
1780 ALTER TABLE i386_public.pkg_history OWNER TO wbadm;
1783 -- Name: transactions; Type: VIEW; Schema: i386_public; Owner: wbadm
1786 CREATE VIEW transactions AS
1787 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);
1790 ALTER TABLE i386_public.transactions OWNER TO wbadm;
1793 -- Name: users; Type: VIEW; Schema: i386_public; Owner: wbadm
1796 CREATE VIEW users AS
1797 SELECT users.username, users.distribution, users.last_seen FROM i386.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1800 ALTER TABLE i386_public.users OWNER TO wbadm;
1802 SET search_path = ia64, pg_catalog;
1805 -- Name: packages; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1808 CREATE TABLE packages (
1809 package character varying NOT NULL,
1810 distribution character varying NOT NULL,
1811 version character varying,
1812 state character varying,
1813 section character varying,
1814 priority character varying,
1815 installed_version character varying,
1816 previous_state character varying,
1817 state_change timestamp without time zone,
1818 notes character varying,
1819 builder character varying,
1822 binary_nmu_version integer,
1823 binary_nmu_changelog character varying,
1824 failed_category character varying,
1825 permbuildpri integer,
1827 depends character varying,
1828 rel character varying,
1830 extra_depends character varying,
1831 extra_conflicts character varying,
1832 build_arch_all boolean DEFAULT false NOT NULL
1836 ALTER TABLE ia64.packages OWNER TO wbadm;
1839 -- Name: pkg_history; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1842 CREATE TABLE pkg_history (
1843 package character varying NOT NULL,
1844 distribution character varying NOT NULL,
1845 version character varying NOT NULL,
1846 "timestamp" timestamp without time zone NOT NULL,
1847 result character varying NOT NULL,
1853 ALTER TABLE ia64.pkg_history OWNER TO wbadm;
1856 -- Name: transactions; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1859 CREATE TABLE transactions (
1860 package character varying,
1861 distribution character varying,
1862 version character varying,
1863 action character varying,
1864 prevstate character varying,
1865 state character varying,
1866 real_user character varying,
1867 set_user character varying,
1868 "time" timestamp without time zone
1872 ALTER TABLE ia64.transactions OWNER TO wbadm;
1875 -- Name: users; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1878 CREATE TABLE users (
1879 username character varying NOT NULL,
1880 distribution character varying NOT NULL,
1881 last_seen timestamp without time zone
1885 ALTER TABLE ia64.users OWNER TO wbadm;
1887 SET search_path = ia64_public, pg_catalog;
1890 -- Name: packages; Type: VIEW; Schema: ia64_public; Owner: wbadm
1893 CREATE VIEW packages AS
1894 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM ia64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1897 ALTER TABLE ia64_public.packages OWNER TO wbadm;
1900 -- Name: pkg_history; Type: VIEW; Schema: ia64_public; Owner: wbadm
1903 CREATE VIEW pkg_history AS
1904 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);
1907 ALTER TABLE ia64_public.pkg_history OWNER TO wbadm;
1910 -- Name: transactions; Type: VIEW; Schema: ia64_public; Owner: wbadm
1913 CREATE VIEW transactions AS
1914 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);
1917 ALTER TABLE ia64_public.transactions OWNER TO wbadm;
1920 -- Name: users; Type: VIEW; Schema: ia64_public; Owner: wbadm
1923 CREATE VIEW users AS
1924 SELECT users.username, users.distribution, users.last_seen FROM ia64.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1927 ALTER TABLE ia64_public.users OWNER TO wbadm;
1929 SET search_path = "kfreebsd-amd64", pg_catalog;
1932 -- Name: packages; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1935 CREATE TABLE packages (
1936 package character varying NOT NULL,
1937 distribution character varying NOT NULL,
1938 version character varying,
1939 state character varying,
1940 section character varying,
1941 priority character varying,
1942 installed_version character varying,
1943 previous_state character varying,
1944 state_change timestamp without time zone,
1945 notes character varying,
1946 builder character varying,
1949 binary_nmu_version integer,
1950 binary_nmu_changelog character varying,
1951 failed_category character varying,
1952 permbuildpri integer,
1954 depends character varying,
1955 rel character varying,
1957 extra_depends character varying,
1958 extra_conflicts character varying,
1959 build_arch_all boolean DEFAULT false NOT NULL
1963 ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
1966 -- Name: pkg_history; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1969 CREATE TABLE pkg_history (
1970 package character varying NOT NULL,
1971 distribution character varying NOT NULL,
1972 version character varying NOT NULL,
1973 "timestamp" timestamp without time zone NOT NULL,
1974 result character varying NOT NULL,
1980 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
1983 -- Name: transactions; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1986 CREATE TABLE transactions (
1987 package character varying,
1988 distribution character varying,
1989 version character varying,
1990 action character varying,
1991 prevstate character varying,
1992 state character varying,
1993 real_user character varying,
1994 set_user character varying,
1995 "time" timestamp without time zone
1999 ALTER TABLE "kfreebsd-amd64".transactions OWNER TO wbadm;
2002 -- Name: users; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
2005 CREATE TABLE users (
2006 username character varying NOT NULL,
2007 distribution character varying NOT NULL,
2008 last_seen timestamp without time zone
2012 ALTER TABLE "kfreebsd-amd64".users OWNER TO wbadm;
2014 SET search_path = "kfreebsd-amd64_public", pg_catalog;
2017 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2020 CREATE VIEW packages AS
2021 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM "kfreebsd-amd64".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2024 ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
2027 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2030 CREATE VIEW pkg_history AS
2031 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);
2034 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
2037 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2040 CREATE VIEW transactions AS
2041 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);
2044 ALTER TABLE "kfreebsd-amd64_public".transactions OWNER TO wbadm;
2047 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2050 CREATE VIEW users AS
2051 SELECT users.username, users.distribution, users.last_seen FROM "kfreebsd-amd64".users WHERE ((users.distribution)::text !~~ '%-security'::text);
2054 ALTER TABLE "kfreebsd-amd64_public".users OWNER TO wbadm;
2056 SET search_path = "kfreebsd-i386", pg_catalog;
2059 -- Name: packages; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2062 CREATE TABLE packages (
2063 package character varying NOT NULL,
2064 distribution character varying NOT NULL,
2065 version character varying,
2066 state character varying,
2067 section character varying,
2068 priority character varying,
2069 installed_version character varying,
2070 previous_state character varying,
2071 state_change timestamp without time zone,
2072 notes character varying,
2073 builder character varying,
2076 binary_nmu_version integer,
2077 binary_nmu_changelog character varying,
2078 failed_category character varying,
2079 permbuildpri integer,
2081 depends character varying,
2082 rel character varying,
2084 extra_depends character varying,
2085 extra_conflicts character varying,
2086 build_arch_all boolean DEFAULT false NOT NULL
2090 ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
2093 -- Name: pkg_history; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2096 CREATE TABLE pkg_history (
2097 package character varying NOT NULL,
2098 distribution character varying NOT NULL,
2099 version character varying NOT NULL,
2100 "timestamp" timestamp without time zone NOT NULL,
2101 result character varying NOT NULL,
2107 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
2110 -- Name: transactions; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2113 CREATE TABLE transactions (
2114 package character varying,
2115 distribution character varying,
2116 version character varying,
2117 action character varying,
2118 prevstate character varying,
2119 state character varying,
2120 real_user character varying,
2121 set_user character varying,
2122 "time" timestamp without time zone
2126 ALTER TABLE "kfreebsd-i386".transactions OWNER TO wbadm;
2129 -- Name: users; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2132 CREATE TABLE users (
2133 username character varying NOT NULL,
2134 distribution character varying NOT NULL,
2135 last_seen timestamp without time zone
2139 ALTER TABLE "kfreebsd-i386".users OWNER TO wbadm;
2141 SET search_path = "kfreebsd-i386_public", pg_catalog;
2144 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2147 CREATE VIEW packages AS
2148 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM "kfreebsd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2151 ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
2154 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2157 CREATE VIEW pkg_history AS
2158 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM "kfreebsd-i386".pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2161 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
2164 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2167 CREATE VIEW transactions AS
2168 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM "kfreebsd-i386".transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2171 ALTER TABLE "kfreebsd-i386_public".transactions OWNER TO wbadm;
2174 -- Name: users; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2177 CREATE VIEW users AS
2178 SELECT users.username, users.distribution, users.last_seen FROM "kfreebsd-i386".users WHERE ((users.distribution)::text !~~ '%-security'::text);
2181 ALTER TABLE "kfreebsd-i386_public".users OWNER TO wbadm;
2183 SET search_path = mips, pg_catalog;
2186 -- Name: packages; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2189 CREATE TABLE packages (
2190 package character varying NOT NULL,
2191 distribution character varying NOT NULL,
2192 version character varying,
2193 state character varying,
2194 section character varying,
2195 priority character varying,
2196 installed_version character varying,
2197 previous_state character varying,
2198 state_change timestamp without time zone,
2199 notes character varying,
2200 builder character varying,
2203 binary_nmu_version integer,
2204 binary_nmu_changelog character varying,
2205 failed_category character varying,
2206 permbuildpri integer,
2208 depends character varying,
2209 rel character varying,
2211 extra_depends character varying,
2212 extra_conflicts character varying,
2213 build_arch_all boolean DEFAULT false NOT NULL
2217 ALTER TABLE mips.packages OWNER TO wbadm;
2220 -- Name: pkg_history; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2223 CREATE TABLE pkg_history (
2224 package character varying NOT NULL,
2225 distribution character varying NOT NULL,
2226 version character varying NOT NULL,
2227 "timestamp" timestamp without time zone NOT NULL,
2228 result character varying NOT NULL,
2234 ALTER TABLE mips.pkg_history OWNER TO wbadm;
2237 -- Name: transactions; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2240 CREATE TABLE transactions (
2241 package character varying,
2242 distribution character varying,
2243 version character varying,
2244 action character varying,
2245 prevstate character varying,
2246 state character varying,
2247 real_user character varying,
2248 set_user character varying,
2249 "time" timestamp without time zone
2253 ALTER TABLE mips.transactions OWNER TO wbadm;
2256 -- Name: users; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2259 CREATE TABLE users (
2260 username character varying NOT NULL,
2261 distribution character varying NOT NULL,
2262 last_seen timestamp without time zone
2266 ALTER TABLE mips.users OWNER TO wbadm;
2268 SET search_path = mips_public, pg_catalog;
2271 -- Name: packages; Type: VIEW; Schema: mips_public; Owner: wbadm
2274 CREATE VIEW packages AS
2275 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM mips.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2278 ALTER TABLE mips_public.packages OWNER TO wbadm;
2281 -- Name: pkg_history; Type: VIEW; Schema: mips_public; Owner: wbadm
2284 CREATE VIEW pkg_history AS
2285 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);
2288 ALTER TABLE mips_public.pkg_history OWNER TO wbadm;
2291 -- Name: transactions; Type: VIEW; Schema: mips_public; Owner: wbadm
2294 CREATE VIEW transactions AS
2295 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);
2298 ALTER TABLE mips_public.transactions OWNER TO wbadm;
2301 -- Name: users; Type: VIEW; Schema: mips_public; Owner: wbadm
2304 CREATE VIEW users AS
2305 SELECT users.username, users.distribution, users.last_seen FROM mips.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2308 ALTER TABLE mips_public.users OWNER TO wbadm;
2310 SET search_path = mipsel, pg_catalog;
2313 -- Name: packages; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2316 CREATE TABLE packages (
2317 package character varying NOT NULL,
2318 distribution character varying NOT NULL,
2319 version character varying,
2320 state character varying,
2321 section character varying,
2322 priority character varying,
2323 installed_version character varying,
2324 previous_state character varying,
2325 state_change timestamp without time zone,
2326 notes character varying,
2327 builder character varying,
2330 binary_nmu_version integer,
2331 binary_nmu_changelog character varying,
2332 failed_category character varying,
2333 permbuildpri integer,
2335 depends character varying,
2336 rel character varying,
2338 extra_depends character varying,
2339 extra_conflicts character varying,
2340 build_arch_all boolean DEFAULT false NOT NULL
2344 ALTER TABLE mipsel.packages OWNER TO wbadm;
2347 -- Name: pkg_history; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2350 CREATE TABLE pkg_history (
2351 package character varying NOT NULL,
2352 distribution character varying NOT NULL,
2353 version character varying NOT NULL,
2354 "timestamp" timestamp without time zone NOT NULL,
2355 result character varying NOT NULL,
2361 ALTER TABLE mipsel.pkg_history OWNER TO wbadm;
2364 -- Name: transactions; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2367 CREATE TABLE transactions (
2368 package character varying,
2369 distribution character varying,
2370 version character varying,
2371 action character varying,
2372 prevstate character varying,
2373 state character varying,
2374 real_user character varying,
2375 set_user character varying,
2376 "time" timestamp without time zone
2380 ALTER TABLE mipsel.transactions OWNER TO wbadm;
2383 -- Name: users; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2386 CREATE TABLE users (
2387 username character varying NOT NULL,
2388 distribution character varying NOT NULL,
2389 last_seen timestamp without time zone
2393 ALTER TABLE mipsel.users OWNER TO wbadm;
2395 SET search_path = mipsel_public, pg_catalog;
2398 -- Name: packages; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2401 CREATE VIEW packages AS
2402 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM mipsel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2405 ALTER TABLE mipsel_public.packages OWNER TO wbadm;
2408 -- Name: pkg_history; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2411 CREATE VIEW pkg_history AS
2412 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);
2415 ALTER TABLE mipsel_public.pkg_history OWNER TO wbadm;
2418 -- Name: transactions; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2421 CREATE VIEW transactions AS
2422 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);
2425 ALTER TABLE mipsel_public.transactions OWNER TO wbadm;
2428 -- Name: users; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2431 CREATE VIEW users AS
2432 SELECT users.username, users.distribution, users.last_seen FROM mipsel.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2435 ALTER TABLE mipsel_public.users OWNER TO wbadm;
2437 SET search_path = powerpc, pg_catalog;
2440 -- Name: packages; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2443 CREATE TABLE packages (
2444 package character varying NOT NULL,
2445 distribution character varying NOT NULL,
2446 version character varying,
2447 state character varying,
2448 section character varying,
2449 priority character varying,
2450 installed_version character varying,
2451 previous_state character varying,
2452 state_change timestamp without time zone,
2453 notes character varying,
2454 builder character varying,
2457 binary_nmu_version integer,
2458 binary_nmu_changelog character varying,
2459 failed_category character varying,
2460 permbuildpri integer,
2462 depends character varying,
2463 rel character varying,
2465 extra_depends character varying,
2466 extra_conflicts character varying,
2467 build_arch_all boolean DEFAULT false NOT NULL
2471 ALTER TABLE powerpc.packages OWNER TO wbadm;
2474 -- Name: pkg_history; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2477 CREATE TABLE pkg_history (
2478 package character varying NOT NULL,
2479 distribution character varying NOT NULL,
2480 version character varying NOT NULL,
2481 "timestamp" timestamp without time zone NOT NULL,
2482 result character varying NOT NULL,
2488 ALTER TABLE powerpc.pkg_history OWNER TO wbadm;
2491 -- Name: transactions; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2494 CREATE TABLE transactions (
2495 package character varying,
2496 distribution character varying,
2497 version character varying,
2498 action character varying,
2499 prevstate character varying,
2500 state character varying,
2501 real_user character varying,
2502 set_user character varying,
2503 "time" timestamp without time zone
2507 ALTER TABLE powerpc.transactions OWNER TO wbadm;
2510 -- Name: users; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2513 CREATE TABLE users (
2514 username character varying NOT NULL,
2515 distribution character varying NOT NULL,
2516 last_seen timestamp without time zone
2520 ALTER TABLE powerpc.users OWNER TO wbadm;
2522 SET search_path = powerpc_public, pg_catalog;
2525 -- Name: packages; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2528 CREATE VIEW packages AS
2529 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM powerpc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2532 ALTER TABLE powerpc_public.packages OWNER TO wbadm;
2535 -- Name: pkg_history; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2538 CREATE VIEW pkg_history AS
2539 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);
2542 ALTER TABLE powerpc_public.pkg_history OWNER TO wbadm;
2545 -- Name: transactions; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2548 CREATE VIEW transactions AS
2549 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);
2552 ALTER TABLE powerpc_public.transactions OWNER TO wbadm;
2555 -- Name: users; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2558 CREATE VIEW users AS
2559 SELECT users.username, users.distribution, users.last_seen FROM powerpc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2562 ALTER TABLE powerpc_public.users OWNER TO wbadm;
2564 SET search_path = public, pg_catalog;
2567 -- Name: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2570 CREATE TABLE distribution_aliases (
2571 alias character varying NOT NULL,
2572 distribution character varying NOT NULL
2576 ALTER TABLE public.distribution_aliases OWNER TO wbadm;
2578 SET search_path = s390, pg_catalog;
2581 -- Name: packages; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2584 CREATE TABLE packages (
2585 package character varying NOT NULL,
2586 distribution character varying NOT NULL,
2587 version character varying,
2588 state character varying,
2589 section character varying,
2590 priority character varying,
2591 installed_version character varying,
2592 previous_state character varying,
2593 state_change timestamp without time zone,
2594 notes character varying,
2595 builder character varying,
2598 binary_nmu_version integer,
2599 binary_nmu_changelog character varying,
2600 failed_category character varying,
2601 permbuildpri integer,
2603 depends character varying,
2604 rel character varying,
2606 extra_depends character varying,
2607 extra_conflicts character varying,
2608 build_arch_all boolean DEFAULT false NOT NULL
2612 ALTER TABLE s390.packages OWNER TO wbadm;
2614 SET search_path = sparc, pg_catalog;
2617 -- Name: packages; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2620 CREATE TABLE packages (
2621 package character varying NOT NULL,
2622 distribution character varying NOT NULL,
2623 version character varying,
2624 state character varying,
2625 section character varying,
2626 priority character varying,
2627 installed_version character varying,
2628 previous_state character varying,
2629 state_change timestamp without time zone,
2630 notes character varying,
2631 builder character varying,
2634 binary_nmu_version integer,
2635 binary_nmu_changelog character varying,
2636 failed_category character varying,
2637 permbuildpri integer,
2639 depends character varying,
2640 rel character varying,
2642 extra_depends character varying,
2643 extra_conflicts character varying,
2644 build_arch_all boolean DEFAULT false NOT NULL
2648 ALTER TABLE sparc.packages OWNER TO wbadm;
2650 SET search_path = public, pg_catalog;
2653 -- Name: distribution_architectures; Type: VIEW; Schema: public; Owner: wbadm
2656 CREATE VIEW distribution_architectures AS
2657 (((((((((((((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;
2660 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2663 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2666 CREATE TABLE distributions (
2667 distribution character varying NOT NULL,
2668 public boolean DEFAULT true NOT NULL,
2669 sort_order integer DEFAULT 0,
2670 auto_dep_wait boolean DEFAULT true,
2671 build_dep_resolver character varying,
2672 archive character varying,
2673 suppress_successful_logs boolean DEFAULT false NOT NULL
2677 ALTER TABLE public.distributions OWNER TO wbadm;
2679 SET search_path = s390, pg_catalog;
2682 -- Name: pkg_history; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2685 CREATE TABLE pkg_history (
2686 package character varying NOT NULL,
2687 distribution character varying NOT NULL,
2688 version character varying NOT NULL,
2689 "timestamp" timestamp without time zone NOT NULL,
2690 result character varying NOT NULL,
2696 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2698 SET search_path = s390_public, pg_catalog;
2701 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2704 CREATE VIEW pkg_history AS
2705 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);
2708 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2710 SET search_path = sparc, pg_catalog;
2713 -- Name: pkg_history; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2716 CREATE TABLE pkg_history (
2717 package character varying NOT NULL,
2718 distribution character varying NOT NULL,
2719 version character varying NOT NULL,
2720 "timestamp" timestamp without time zone NOT NULL,
2721 result character varying NOT NULL,
2727 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2729 SET search_path = sparc_public, pg_catalog;
2732 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2735 CREATE VIEW pkg_history AS
2736 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);
2739 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2741 SET search_path = public, pg_catalog;
2744 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2747 CREATE VIEW lastlog AS
2748 ((((((((((((((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;
2751 ALTER TABLE public.lastlog OWNER TO wbadm;
2754 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2758 (((((((((((((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;
2761 ALTER TABLE public.log OWNER TO wbadm;
2764 -- Name: log_v2; Type: VIEW; Schema: public; Owner: pkern
2767 CREATE VIEW log_v2 AS
2768 (((((((((((((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;
2771 ALTER TABLE public.log_v2 OWNER TO pkern;
2773 SET search_path = s390_public, pg_catalog;
2776 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2779 CREATE VIEW packages AS
2780 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM s390.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2783 ALTER TABLE s390_public.packages OWNER TO wbadm;
2785 SET search_path = sparc_public, pg_catalog;
2788 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2791 CREATE VIEW packages AS
2792 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts, packages.build_arch_all FROM sparc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2795 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2797 SET search_path = public, pg_catalog;
2800 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2803 CREATE VIEW packages_all AS
2804 (((((((((((((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;
2807 ALTER TABLE public.packages_all OWNER TO wbadm;
2809 SET search_path = s390, pg_catalog;
2812 -- Name: transactions; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2815 CREATE TABLE transactions (
2816 package character varying,
2817 distribution character varying,
2818 version character varying,
2819 action character varying,
2820 prevstate character varying,
2821 state character varying,
2822 real_user character varying,
2823 set_user character varying,
2824 "time" timestamp without time zone
2828 ALTER TABLE s390.transactions OWNER TO wbadm;
2831 -- Name: users; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2834 CREATE TABLE users (
2835 username character varying NOT NULL,
2836 distribution character varying NOT NULL,
2837 last_seen timestamp without time zone
2841 ALTER TABLE s390.users OWNER TO wbadm;
2843 SET search_path = s390_public, pg_catalog;
2846 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2849 CREATE VIEW transactions AS
2850 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);
2853 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2856 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2859 CREATE VIEW users AS
2860 SELECT users.username, users.distribution, users.last_seen FROM s390.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2863 ALTER TABLE s390_public.users OWNER TO wbadm;
2865 SET search_path = sparc, pg_catalog;
2868 -- Name: transactions; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2871 CREATE TABLE transactions (
2872 package character varying,
2873 distribution character varying,
2874 version character varying,
2875 action character varying,
2876 prevstate character varying,
2877 state character varying,
2878 real_user character varying,
2879 set_user character varying,
2880 "time" timestamp without time zone
2884 ALTER TABLE sparc.transactions OWNER TO wbadm;
2887 -- Name: users; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2890 CREATE TABLE users (
2891 username character varying NOT NULL,
2892 distribution character varying NOT NULL,
2893 last_seen timestamp without time zone
2897 ALTER TABLE sparc.users OWNER TO wbadm;
2899 SET search_path = sparc_public, pg_catalog;
2902 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2905 CREATE VIEW transactions AS
2906 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);
2909 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2912 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2915 CREATE VIEW users AS
2916 SELECT users.username, users.distribution, users.last_seen FROM sparc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2919 ALTER TABLE sparc_public.users OWNER TO wbadm;
2921 SET search_path = alpha, pg_catalog;
2924 -- Name: packages_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2927 ALTER TABLE ONLY packages
2928 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2932 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2935 ALTER TABLE ONLY pkg_history
2936 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2940 -- Name: users_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2943 ALTER TABLE ONLY users
2944 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2947 SET search_path = amd64, pg_catalog;
2950 -- Name: packages_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2953 ALTER TABLE ONLY packages
2954 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2958 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2961 ALTER TABLE ONLY pkg_history
2962 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2966 -- Name: users_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2969 ALTER TABLE ONLY users
2970 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2973 SET search_path = arm, pg_catalog;
2976 -- Name: packages_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2979 ALTER TABLE ONLY packages
2980 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2984 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2987 ALTER TABLE ONLY pkg_history
2988 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2992 -- Name: users_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2995 ALTER TABLE ONLY users
2996 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2999 SET search_path = armel, pg_catalog;
3002 -- Name: packages_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3005 ALTER TABLE ONLY packages
3006 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3010 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3013 ALTER TABLE ONLY pkg_history
3014 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3018 -- Name: users_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3021 ALTER TABLE ONLY users
3022 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3025 SET search_path = hppa, pg_catalog;
3028 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3031 ALTER TABLE ONLY packages
3032 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3036 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3039 ALTER TABLE ONLY pkg_history
3040 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3044 -- Name: users_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3047 ALTER TABLE ONLY users
3048 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3051 SET search_path = "hurd-i386", pg_catalog;
3054 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3057 ALTER TABLE ONLY packages
3058 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3062 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3065 ALTER TABLE ONLY pkg_history
3066 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3070 -- Name: users_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3073 ALTER TABLE ONLY users
3074 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3077 SET search_path = i386, pg_catalog;
3080 -- Name: packages_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3083 ALTER TABLE ONLY packages
3084 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3088 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3091 ALTER TABLE ONLY pkg_history
3092 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3096 -- Name: users_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3099 ALTER TABLE ONLY users
3100 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3103 SET search_path = ia64, pg_catalog;
3106 -- Name: packages_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3109 ALTER TABLE ONLY packages
3110 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3114 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3117 ALTER TABLE ONLY pkg_history
3118 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3122 -- Name: users_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3125 ALTER TABLE ONLY users
3126 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3129 SET search_path = "kfreebsd-amd64", pg_catalog;
3132 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3135 ALTER TABLE ONLY packages
3136 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3140 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3143 ALTER TABLE ONLY pkg_history
3144 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3148 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3151 ALTER TABLE ONLY users
3152 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3155 SET search_path = "kfreebsd-i386", pg_catalog;
3158 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3161 ALTER TABLE ONLY packages
3162 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3166 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3169 ALTER TABLE ONLY pkg_history
3170 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3174 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3177 ALTER TABLE ONLY users
3178 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3181 SET search_path = mips, pg_catalog;
3184 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3187 ALTER TABLE ONLY packages
3188 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3192 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3195 ALTER TABLE ONLY pkg_history
3196 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3200 -- Name: users_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3203 ALTER TABLE ONLY users
3204 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3207 SET search_path = mipsel, pg_catalog;
3210 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3213 ALTER TABLE ONLY packages
3214 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3218 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3221 ALTER TABLE ONLY pkg_history
3222 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3226 -- Name: users_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3229 ALTER TABLE ONLY users
3230 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3233 SET search_path = powerpc, pg_catalog;
3236 -- Name: packages_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3239 ALTER TABLE ONLY packages
3240 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3244 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3247 ALTER TABLE ONLY pkg_history
3248 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3252 -- Name: users_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3255 ALTER TABLE ONLY users
3256 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3259 SET search_path = public, pg_catalog;
3262 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
3265 ALTER TABLE ONLY distribution_aliases
3266 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
3269 SET search_path = s390, pg_catalog;
3272 -- Name: packages_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3275 ALTER TABLE ONLY packages
3276 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3280 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3283 ALTER TABLE ONLY pkg_history
3284 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3288 -- Name: users_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3291 ALTER TABLE ONLY users
3292 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3295 SET search_path = sparc, pg_catalog;
3298 -- Name: packages_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3301 ALTER TABLE ONLY packages
3302 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3306 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3309 ALTER TABLE ONLY pkg_history
3310 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3314 -- Name: users_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3317 ALTER TABLE ONLY users
3318 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3321 SET search_path = alpha, pg_catalog;
3324 -- Name: idx_alpha_state; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3327 CREATE INDEX idx_alpha_state ON packages USING btree (state);
3331 -- Name: pkg_history_distribution; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3334 CREATE INDEX pkg_history_distribution ON pkg_history USING hash (distribution);
3338 -- Name: pkg_history_index; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3341 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3345 -- Name: pkg_history_timestamp; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3348 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3351 SET search_path = amd64, pg_catalog;
3354 -- Name: idx_amd64_state; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3357 CREATE INDEX idx_amd64_state ON packages USING btree (state);
3361 -- Name: pkg_history_index; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3364 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3368 -- Name: pkg_history_timestamp; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3371 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3374 SET search_path = arm, pg_catalog;
3377 -- Name: idx_arm_state; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3380 CREATE INDEX idx_arm_state ON packages USING btree (state);
3384 -- Name: pkg_history_index; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3387 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3391 -- Name: pkg_history_timestamp; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3394 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3397 SET search_path = armel, pg_catalog;
3400 -- Name: idx_armel_state; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3403 CREATE INDEX idx_armel_state ON packages USING btree (state);
3407 -- Name: pkg_history_index; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3410 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3414 -- Name: pkg_history_timestamp; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3417 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3420 SET search_path = hppa, pg_catalog;
3423 -- Name: idx_hppa_state; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3426 CREATE INDEX idx_hppa_state ON packages USING btree (state);
3430 -- Name: pkg_history_index; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3433 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3437 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3440 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3443 SET search_path = "hurd-i386", pg_catalog;
3446 -- Name: idx_hurd-i386_state; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3449 CREATE INDEX "idx_hurd-i386_state" ON packages USING btree (state);
3453 -- Name: pkg_history_index; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3456 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3460 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3463 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3466 SET search_path = i386, pg_catalog;
3469 -- Name: idx_i386_state; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3472 CREATE INDEX idx_i386_state ON packages USING btree (state);
3476 -- Name: pkg_history_index; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3479 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3483 -- Name: pkg_history_timestamp; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3486 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3489 SET search_path = ia64, pg_catalog;
3492 -- Name: idx_ia64_state; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3495 CREATE INDEX idx_ia64_state ON packages USING btree (state);
3499 -- Name: pkg_history_index; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3502 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3506 -- Name: pkg_history_timestamp; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3509 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3512 SET search_path = "kfreebsd-amd64", pg_catalog;
3515 -- Name: idx_kfreebsd-amd64_state; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3518 CREATE INDEX "idx_kfreebsd-amd64_state" ON packages USING btree (state);
3522 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3525 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3529 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3532 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3535 SET search_path = "kfreebsd-i386", pg_catalog;
3538 -- Name: idx_kfreebsd-i386_state; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3541 CREATE INDEX "idx_kfreebsd-i386_state" ON packages USING btree (state);
3545 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3548 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3552 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3555 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3558 SET search_path = mips, pg_catalog;
3561 -- Name: idx_mips_state; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3564 CREATE INDEX idx_mips_state ON packages USING btree (state);
3568 -- Name: pkg_history_index; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3571 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3575 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3578 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3581 SET search_path = mipsel, pg_catalog;
3584 -- Name: idx_mipsel_state; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3587 CREATE INDEX idx_mipsel_state ON packages USING btree (state);
3591 -- Name: pkg_history_index; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3594 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3598 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3601 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3604 SET search_path = powerpc, pg_catalog;
3607 -- Name: idx_powerpc_state; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3610 CREATE INDEX idx_powerpc_state ON packages USING btree (state);
3614 -- Name: pkg_history_index; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3617 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3621 -- Name: pkg_history_timestamp; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3624 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3627 SET search_path = public, pg_catalog;
3630 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3633 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
3637 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3640 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
3643 SET search_path = s390, pg_catalog;
3646 -- Name: idx_s390_state; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3649 CREATE INDEX idx_s390_state ON packages USING btree (state);
3653 -- Name: pkg_history_index; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3656 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3660 -- Name: pkg_history_timestamp; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3663 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3666 SET search_path = sparc, pg_catalog;
3669 -- Name: idx_sparc_state; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3672 CREATE INDEX idx_sparc_state ON packages USING btree (state);
3676 -- Name: pkg_history_index; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3679 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3683 -- Name: pkg_history_timestamp; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3686 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3689 SET search_path = alpha, pg_catalog;
3692 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3695 ALTER TABLE ONLY packages
3696 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3700 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3703 ALTER TABLE ONLY pkg_history
3704 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3708 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3711 ALTER TABLE ONLY users
3712 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3715 SET search_path = amd64, pg_catalog;
3718 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3721 ALTER TABLE ONLY packages
3722 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3726 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3729 ALTER TABLE ONLY pkg_history
3730 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3734 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3737 ALTER TABLE ONLY users
3738 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3741 SET search_path = arm, pg_catalog;
3744 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3747 ALTER TABLE ONLY packages
3748 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3752 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3755 ALTER TABLE ONLY pkg_history
3756 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3760 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3763 ALTER TABLE ONLY users
3764 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3767 SET search_path = armel, pg_catalog;
3770 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3773 ALTER TABLE ONLY packages
3774 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3778 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3781 ALTER TABLE ONLY pkg_history
3782 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3786 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3789 ALTER TABLE ONLY users
3790 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3793 SET search_path = hppa, pg_catalog;
3796 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3799 ALTER TABLE ONLY packages
3800 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3804 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3807 ALTER TABLE ONLY pkg_history
3808 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3812 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3815 ALTER TABLE ONLY users
3816 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3819 SET search_path = "hurd-i386", pg_catalog;
3822 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3825 ALTER TABLE ONLY packages
3826 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3830 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3833 ALTER TABLE ONLY pkg_history
3834 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3838 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3841 ALTER TABLE ONLY users
3842 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3845 SET search_path = i386, pg_catalog;
3848 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3851 ALTER TABLE ONLY packages
3852 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3856 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3859 ALTER TABLE ONLY pkg_history
3860 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3864 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3867 ALTER TABLE ONLY users
3868 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3871 SET search_path = ia64, pg_catalog;
3874 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3877 ALTER TABLE ONLY packages
3878 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3882 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3885 ALTER TABLE ONLY pkg_history
3886 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3890 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3893 ALTER TABLE ONLY users
3894 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3897 SET search_path = "kfreebsd-amd64", pg_catalog;
3900 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3903 ALTER TABLE ONLY packages
3904 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3908 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3911 ALTER TABLE ONLY pkg_history
3912 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3916 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3919 ALTER TABLE ONLY users
3920 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3923 SET search_path = "kfreebsd-i386", pg_catalog;
3926 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3929 ALTER TABLE ONLY packages
3930 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3934 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3937 ALTER TABLE ONLY pkg_history
3938 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3942 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3945 ALTER TABLE ONLY users
3946 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3949 SET search_path = mips, pg_catalog;
3952 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3955 ALTER TABLE ONLY packages
3956 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3960 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3963 ALTER TABLE ONLY pkg_history
3964 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3968 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3971 ALTER TABLE ONLY users
3972 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3975 SET search_path = mipsel, pg_catalog;
3978 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3981 ALTER TABLE ONLY packages
3982 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3986 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3989 ALTER TABLE ONLY pkg_history
3990 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3994 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3997 ALTER TABLE ONLY users
3998 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4001 SET search_path = powerpc, pg_catalog;
4004 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4007 ALTER TABLE ONLY packages
4008 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4012 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4015 ALTER TABLE ONLY pkg_history
4016 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4020 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4023 ALTER TABLE ONLY users
4024 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4027 SET search_path = public, pg_catalog;
4030 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
4033 ALTER TABLE ONLY distribution_aliases
4034 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
4037 SET search_path = s390, pg_catalog;
4040 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4043 ALTER TABLE ONLY packages
4044 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4048 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4051 ALTER TABLE ONLY pkg_history
4052 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4056 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4059 ALTER TABLE ONLY users
4060 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4063 SET search_path = sparc, pg_catalog;
4066 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4069 ALTER TABLE ONLY packages
4070 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4074 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4077 ALTER TABLE ONLY pkg_history
4078 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4082 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4085 ALTER TABLE ONLY users
4086 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4090 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
4093 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
4094 REVOKE ALL ON SCHEMA alpha FROM wbadm;
4095 GRANT ALL ON SCHEMA alpha TO wbadm;
4096 GRANT USAGE ON SCHEMA alpha TO alpha;
4097 GRANT USAGE ON SCHEMA alpha TO wb_all;
4098 GRANT USAGE ON SCHEMA alpha TO wb_security;
4102 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
4105 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
4106 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
4107 GRANT ALL ON SCHEMA alpha_public TO wbadm;
4108 GRANT USAGE ON SCHEMA alpha_public TO alpha;
4109 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
4113 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
4116 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
4117 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
4118 GRANT ALL ON SCHEMA amd64 TO wbadm;
4119 GRANT USAGE ON SCHEMA amd64 TO amd64;
4120 GRANT USAGE ON SCHEMA amd64 TO wb_all;
4121 GRANT USAGE ON SCHEMA amd64 TO wb_security;
4125 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
4128 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
4129 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
4130 GRANT ALL ON SCHEMA amd64_public TO wbadm;
4131 GRANT USAGE ON SCHEMA amd64_public TO amd64;
4132 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
4136 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
4139 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
4140 REVOKE ALL ON SCHEMA arm FROM wbadm;
4141 GRANT ALL ON SCHEMA arm TO wbadm;
4142 GRANT USAGE ON SCHEMA arm TO arm;
4143 GRANT USAGE ON SCHEMA arm TO wb_all;
4144 GRANT USAGE ON SCHEMA arm TO wb_security;
4148 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
4151 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
4152 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
4153 GRANT ALL ON SCHEMA arm_public TO wbadm;
4154 GRANT USAGE ON SCHEMA arm_public TO arm;
4155 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
4159 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
4162 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
4163 REVOKE ALL ON SCHEMA armel FROM wbadm;
4164 GRANT ALL ON SCHEMA armel TO wbadm;
4165 GRANT USAGE ON SCHEMA armel TO armel;
4166 GRANT USAGE ON SCHEMA armel TO wb_all;
4167 GRANT USAGE ON SCHEMA armel TO wb_security;
4171 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
4174 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
4175 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
4176 GRANT ALL ON SCHEMA armel_public TO wbadm;
4177 GRANT USAGE ON SCHEMA armel_public TO armel;
4178 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
4182 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4185 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4186 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4187 GRANT ALL ON SCHEMA hppa TO wbadm;
4188 GRANT USAGE ON SCHEMA hppa TO hppa;
4189 GRANT USAGE ON SCHEMA hppa TO wb_all;
4190 GRANT USAGE ON SCHEMA hppa TO wb_security;
4194 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4197 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4198 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4199 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4200 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4201 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4205 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4208 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4209 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4210 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4211 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4212 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4213 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4217 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4220 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4221 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4222 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4223 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4224 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4228 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4231 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4232 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4233 GRANT ALL ON SCHEMA i386 TO wbadm;
4234 GRANT USAGE ON SCHEMA i386 TO i386;
4235 GRANT USAGE ON SCHEMA i386 TO wb_all;
4236 GRANT USAGE ON SCHEMA i386 TO wb_security;
4240 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4243 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4244 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4245 GRANT ALL ON SCHEMA i386_public TO wbadm;
4246 GRANT USAGE ON SCHEMA i386_public TO i386;
4247 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4251 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4254 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4255 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4256 GRANT ALL ON SCHEMA ia64 TO wbadm;
4257 GRANT USAGE ON SCHEMA ia64 TO ia64;
4258 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4259 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4263 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4266 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4267 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4268 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4269 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4270 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4274 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4277 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4278 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4279 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4280 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4281 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4282 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4286 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4289 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4290 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4291 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4292 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4293 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4297 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4300 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4301 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4302 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4303 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4304 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4305 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4309 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4312 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4313 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4314 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4315 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4316 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4320 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4323 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4324 REVOKE ALL ON SCHEMA mips FROM wbadm;
4325 GRANT ALL ON SCHEMA mips TO wbadm;
4326 GRANT USAGE ON SCHEMA mips TO mips;
4327 GRANT USAGE ON SCHEMA mips TO wb_all;
4328 GRANT USAGE ON SCHEMA mips TO wb_security;
4332 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4335 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4336 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4337 GRANT ALL ON SCHEMA mips_public TO wbadm;
4338 GRANT USAGE ON SCHEMA mips_public TO mips;
4339 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4343 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4346 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4347 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4348 GRANT ALL ON SCHEMA mipsel TO wbadm;
4349 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4350 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4351 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4355 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4358 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4359 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4360 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4361 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4362 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4366 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4369 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4370 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4371 GRANT ALL ON SCHEMA powerpc TO wbadm;
4372 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4373 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4374 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4378 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4381 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4382 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4383 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4384 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4385 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4389 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4392 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4393 REVOKE ALL ON SCHEMA public FROM postgres;
4394 GRANT ALL ON SCHEMA public TO postgres;
4395 GRANT ALL ON SCHEMA public TO PUBLIC;
4399 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4402 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4403 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4404 GRANT ALL ON SCHEMA s390 TO wbadm;
4405 GRANT USAGE ON SCHEMA s390 TO s390;
4406 GRANT USAGE ON SCHEMA s390 TO wb_all;
4407 GRANT USAGE ON SCHEMA s390 TO wb_security;
4411 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4414 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4415 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4416 GRANT ALL ON SCHEMA s390_public TO wbadm;
4417 GRANT USAGE ON SCHEMA s390_public TO s390;
4418 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4422 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4425 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4426 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4427 GRANT ALL ON SCHEMA sparc TO wbadm;
4428 GRANT USAGE ON SCHEMA sparc TO sparc;
4429 GRANT USAGE ON SCHEMA sparc TO wb_all;
4430 GRANT USAGE ON SCHEMA sparc TO wb_security;
4434 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4437 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4438 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4439 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4440 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4441 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4444 SET search_path = alpha, pg_catalog;
4447 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4450 REVOKE ALL ON TABLE packages FROM PUBLIC;
4451 REVOKE ALL ON TABLE packages FROM wbadm;
4452 GRANT ALL ON TABLE packages TO wbadm;
4453 GRANT ALL ON TABLE packages TO alpha;
4454 GRANT SELECT ON TABLE packages TO wb_security;
4458 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4461 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4462 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4463 GRANT ALL ON TABLE pkg_history TO wbadm;
4464 GRANT ALL ON TABLE pkg_history TO alpha;
4465 GRANT SELECT ON TABLE pkg_history TO wb_security;
4469 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4472 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4473 REVOKE ALL ON TABLE transactions FROM wbadm;
4474 GRANT ALL ON TABLE transactions TO wbadm;
4475 GRANT SELECT,INSERT ON TABLE transactions TO alpha;
4476 GRANT SELECT ON TABLE transactions TO wb_security;
4480 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4483 REVOKE ALL ON TABLE users FROM PUBLIC;
4484 REVOKE ALL ON TABLE users FROM wbadm;
4485 GRANT ALL ON TABLE users TO wbadm;
4486 GRANT ALL ON TABLE users TO alpha;
4489 SET search_path = alpha_public, pg_catalog;
4492 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4495 REVOKE ALL ON TABLE packages FROM PUBLIC;
4496 REVOKE ALL ON TABLE packages FROM wbadm;
4497 GRANT ALL ON TABLE packages TO wbadm;
4498 GRANT SELECT ON TABLE packages TO PUBLIC;
4502 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4505 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4506 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4507 GRANT ALL ON TABLE pkg_history TO wbadm;
4508 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4512 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4515 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4516 REVOKE ALL ON TABLE transactions FROM wbadm;
4517 GRANT ALL ON TABLE transactions TO wbadm;
4518 GRANT SELECT ON TABLE transactions TO PUBLIC;
4522 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4525 REVOKE ALL ON TABLE users FROM PUBLIC;
4526 REVOKE ALL ON TABLE users FROM wbadm;
4527 GRANT ALL ON TABLE users TO wbadm;
4528 GRANT SELECT ON TABLE users TO PUBLIC;
4531 SET search_path = amd64, pg_catalog;
4534 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4537 REVOKE ALL ON TABLE packages FROM PUBLIC;
4538 REVOKE ALL ON TABLE packages FROM wbadm;
4539 GRANT ALL ON TABLE packages TO wbadm;
4540 GRANT ALL ON TABLE packages TO amd64;
4541 GRANT SELECT ON TABLE packages TO wb_security;
4545 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4548 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4549 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4550 GRANT ALL ON TABLE pkg_history TO wbadm;
4551 GRANT ALL ON TABLE pkg_history TO amd64;
4552 GRANT SELECT ON TABLE pkg_history TO wb_security;
4556 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4559 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4560 REVOKE ALL ON TABLE transactions FROM wbadm;
4561 GRANT ALL ON TABLE transactions TO wbadm;
4562 GRANT SELECT,INSERT ON TABLE transactions TO amd64;
4563 GRANT SELECT ON TABLE transactions TO wb_security;
4567 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4570 REVOKE ALL ON TABLE users FROM PUBLIC;
4571 REVOKE ALL ON TABLE users FROM wbadm;
4572 GRANT ALL ON TABLE users TO wbadm;
4573 GRANT ALL ON TABLE users TO amd64;
4576 SET search_path = amd64_public, pg_catalog;
4579 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4582 REVOKE ALL ON TABLE packages FROM PUBLIC;
4583 REVOKE ALL ON TABLE packages FROM wbadm;
4584 GRANT ALL ON TABLE packages TO wbadm;
4585 GRANT SELECT ON TABLE packages TO PUBLIC;
4589 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4592 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4593 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4594 GRANT ALL ON TABLE pkg_history TO wbadm;
4595 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4599 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4602 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4603 REVOKE ALL ON TABLE transactions FROM wbadm;
4604 GRANT ALL ON TABLE transactions TO wbadm;
4605 GRANT SELECT ON TABLE transactions TO PUBLIC;
4609 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4612 REVOKE ALL ON TABLE users FROM PUBLIC;
4613 REVOKE ALL ON TABLE users FROM wbadm;
4614 GRANT ALL ON TABLE users TO wbadm;
4615 GRANT SELECT ON TABLE users TO PUBLIC;
4618 SET search_path = arm, pg_catalog;
4621 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4624 REVOKE ALL ON TABLE packages FROM PUBLIC;
4625 REVOKE ALL ON TABLE packages FROM wbadm;
4626 GRANT ALL ON TABLE packages TO wbadm;
4627 GRANT ALL ON TABLE packages TO arm;
4628 GRANT SELECT ON TABLE packages TO wb_security;
4632 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4635 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4636 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4637 GRANT ALL ON TABLE pkg_history TO wbadm;
4638 GRANT ALL ON TABLE pkg_history TO arm;
4639 GRANT SELECT ON TABLE pkg_history TO wb_security;
4643 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4646 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4647 REVOKE ALL ON TABLE transactions FROM wbadm;
4648 GRANT ALL ON TABLE transactions TO wbadm;
4649 GRANT SELECT,INSERT ON TABLE transactions TO arm;
4650 GRANT SELECT ON TABLE transactions TO wb_security;
4654 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4657 REVOKE ALL ON TABLE users FROM PUBLIC;
4658 REVOKE ALL ON TABLE users FROM wbadm;
4659 GRANT ALL ON TABLE users TO wbadm;
4660 GRANT ALL ON TABLE users TO arm;
4663 SET search_path = arm_public, pg_catalog;
4666 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4669 REVOKE ALL ON TABLE packages FROM PUBLIC;
4670 REVOKE ALL ON TABLE packages FROM wbadm;
4671 GRANT ALL ON TABLE packages TO wbadm;
4672 GRANT SELECT ON TABLE packages TO PUBLIC;
4676 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4679 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4680 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4681 GRANT ALL ON TABLE pkg_history TO wbadm;
4682 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4686 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4689 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4690 REVOKE ALL ON TABLE transactions FROM wbadm;
4691 GRANT ALL ON TABLE transactions TO wbadm;
4692 GRANT SELECT ON TABLE transactions TO PUBLIC;
4696 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4699 REVOKE ALL ON TABLE users FROM PUBLIC;
4700 REVOKE ALL ON TABLE users FROM wbadm;
4701 GRANT ALL ON TABLE users TO wbadm;
4702 GRANT SELECT ON TABLE users TO PUBLIC;
4705 SET search_path = armel, pg_catalog;
4708 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4711 REVOKE ALL ON TABLE packages FROM PUBLIC;
4712 REVOKE ALL ON TABLE packages FROM wbadm;
4713 GRANT ALL ON TABLE packages TO wbadm;
4714 GRANT ALL ON TABLE packages TO armel;
4715 GRANT SELECT ON TABLE packages TO wb_security;
4719 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4722 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4723 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4724 GRANT ALL ON TABLE pkg_history TO wbadm;
4725 GRANT ALL ON TABLE pkg_history TO armel;
4726 GRANT SELECT ON TABLE pkg_history TO wb_security;
4730 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4733 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4734 REVOKE ALL ON TABLE transactions FROM wbadm;
4735 GRANT ALL ON TABLE transactions TO wbadm;
4736 GRANT SELECT,INSERT ON TABLE transactions TO armel;
4737 GRANT SELECT ON TABLE transactions TO wb_security;
4741 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4744 REVOKE ALL ON TABLE users FROM PUBLIC;
4745 REVOKE ALL ON TABLE users FROM wbadm;
4746 GRANT ALL ON TABLE users TO wbadm;
4747 GRANT ALL ON TABLE users TO armel;
4750 SET search_path = armel_public, pg_catalog;
4753 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4756 REVOKE ALL ON TABLE packages FROM PUBLIC;
4757 REVOKE ALL ON TABLE packages FROM wbadm;
4758 GRANT ALL ON TABLE packages TO wbadm;
4759 GRANT SELECT ON TABLE packages TO PUBLIC;
4763 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4766 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4767 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4768 GRANT ALL ON TABLE pkg_history TO wbadm;
4769 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4773 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4776 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4777 REVOKE ALL ON TABLE transactions FROM wbadm;
4778 GRANT ALL ON TABLE transactions TO wbadm;
4779 GRANT SELECT ON TABLE transactions TO PUBLIC;
4783 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4786 REVOKE ALL ON TABLE users FROM PUBLIC;
4787 REVOKE ALL ON TABLE users FROM wbadm;
4788 GRANT ALL ON TABLE users TO wbadm;
4789 GRANT SELECT ON TABLE users TO PUBLIC;
4792 SET search_path = hppa, pg_catalog;
4795 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4798 REVOKE ALL ON TABLE packages FROM PUBLIC;
4799 REVOKE ALL ON TABLE packages FROM wbadm;
4800 GRANT ALL ON TABLE packages TO wbadm;
4801 GRANT ALL ON TABLE packages TO hppa;
4802 GRANT SELECT ON TABLE packages TO wb_security;
4806 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4809 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4810 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4811 GRANT ALL ON TABLE pkg_history TO wbadm;
4812 GRANT ALL ON TABLE pkg_history TO hppa;
4813 GRANT SELECT ON TABLE pkg_history TO wb_security;
4817 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4820 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4821 REVOKE ALL ON TABLE transactions FROM wbadm;
4822 GRANT ALL ON TABLE transactions TO wbadm;
4823 GRANT SELECT,INSERT ON TABLE transactions TO hppa;
4824 GRANT SELECT ON TABLE transactions TO wb_security;
4828 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4831 REVOKE ALL ON TABLE users FROM PUBLIC;
4832 REVOKE ALL ON TABLE users FROM wbadm;
4833 GRANT ALL ON TABLE users TO wbadm;
4834 GRANT ALL ON TABLE users TO hppa;
4837 SET search_path = hppa_public, pg_catalog;
4840 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4843 REVOKE ALL ON TABLE packages FROM PUBLIC;
4844 REVOKE ALL ON TABLE packages FROM wbadm;
4845 GRANT ALL ON TABLE packages TO wbadm;
4846 GRANT SELECT ON TABLE packages TO PUBLIC;
4850 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4853 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4854 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4855 GRANT ALL ON TABLE pkg_history TO wbadm;
4856 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4860 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4863 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4864 REVOKE ALL ON TABLE transactions FROM wbadm;
4865 GRANT ALL ON TABLE transactions TO wbadm;
4866 GRANT SELECT ON TABLE transactions TO PUBLIC;
4870 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4873 REVOKE ALL ON TABLE users FROM PUBLIC;
4874 REVOKE ALL ON TABLE users FROM wbadm;
4875 GRANT ALL ON TABLE users TO wbadm;
4876 GRANT SELECT ON TABLE users TO PUBLIC;
4879 SET search_path = "hurd-i386", pg_catalog;
4882 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4885 REVOKE ALL ON TABLE packages FROM PUBLIC;
4886 REVOKE ALL ON TABLE packages FROM wbadm;
4887 GRANT ALL ON TABLE packages TO wbadm;
4888 GRANT ALL ON TABLE packages TO "hurd-i386";
4889 GRANT SELECT ON TABLE packages TO wb_security;
4893 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4896 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4897 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4898 GRANT ALL ON TABLE pkg_history TO wbadm;
4899 GRANT ALL ON TABLE pkg_history TO "hurd-i386";
4900 GRANT SELECT ON TABLE pkg_history TO wb_security;
4904 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4907 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4908 REVOKE ALL ON TABLE transactions FROM wbadm;
4909 GRANT ALL ON TABLE transactions TO wbadm;
4910 GRANT SELECT,INSERT ON TABLE transactions TO "hurd-i386";
4911 GRANT SELECT ON TABLE transactions TO wb_security;
4915 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4918 REVOKE ALL ON TABLE users FROM PUBLIC;
4919 REVOKE ALL ON TABLE users FROM wbadm;
4920 GRANT ALL ON TABLE users TO wbadm;
4921 GRANT ALL ON TABLE users TO "hurd-i386";
4924 SET search_path = "hurd-i386_public", pg_catalog;
4927 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4930 REVOKE ALL ON TABLE packages FROM PUBLIC;
4931 REVOKE ALL ON TABLE packages FROM wbadm;
4932 GRANT ALL ON TABLE packages TO wbadm;
4933 GRANT SELECT ON TABLE packages TO PUBLIC;
4937 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4940 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4941 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4942 GRANT ALL ON TABLE pkg_history TO wbadm;
4943 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4947 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4950 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4951 REVOKE ALL ON TABLE transactions FROM wbadm;
4952 GRANT ALL ON TABLE transactions TO wbadm;
4953 GRANT SELECT ON TABLE transactions TO PUBLIC;
4957 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4960 REVOKE ALL ON TABLE users FROM PUBLIC;
4961 REVOKE ALL ON TABLE users FROM wbadm;
4962 GRANT ALL ON TABLE users TO wbadm;
4963 GRANT SELECT ON TABLE users TO PUBLIC;
4966 SET search_path = i386, pg_catalog;
4969 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4972 REVOKE ALL ON TABLE packages FROM PUBLIC;
4973 REVOKE ALL ON TABLE packages FROM wbadm;
4974 GRANT ALL ON TABLE packages TO wbadm;
4975 GRANT ALL ON TABLE packages TO i386;
4976 GRANT SELECT ON TABLE packages TO wb_security;
4980 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4983 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4984 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4985 GRANT ALL ON TABLE pkg_history TO wbadm;
4986 GRANT ALL ON TABLE pkg_history TO i386;
4987 GRANT SELECT ON TABLE pkg_history TO wb_security;
4991 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
4994 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4995 REVOKE ALL ON TABLE transactions FROM wbadm;
4996 GRANT ALL ON TABLE transactions TO wbadm;
4997 GRANT SELECT,INSERT ON TABLE transactions TO i386;
4998 GRANT SELECT ON TABLE transactions TO wb_security;
5002 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
5005 REVOKE ALL ON TABLE users FROM PUBLIC;
5006 REVOKE ALL ON TABLE users FROM wbadm;
5007 GRANT ALL ON TABLE users TO wbadm;
5008 GRANT ALL ON TABLE users TO i386;
5011 SET search_path = i386_public, pg_catalog;
5014 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5017 REVOKE ALL ON TABLE packages FROM PUBLIC;
5018 REVOKE ALL ON TABLE packages FROM wbadm;
5019 GRANT ALL ON TABLE packages TO wbadm;
5020 GRANT SELECT ON TABLE packages TO PUBLIC;
5024 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5027 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5028 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5029 GRANT ALL ON TABLE pkg_history TO wbadm;
5030 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5034 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5037 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5038 REVOKE ALL ON TABLE transactions FROM wbadm;
5039 GRANT ALL ON TABLE transactions TO wbadm;
5040 GRANT SELECT ON TABLE transactions TO PUBLIC;
5044 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5047 REVOKE ALL ON TABLE users FROM PUBLIC;
5048 REVOKE ALL ON TABLE users FROM wbadm;
5049 GRANT ALL ON TABLE users TO wbadm;
5050 GRANT SELECT ON TABLE users TO PUBLIC;
5053 SET search_path = ia64, pg_catalog;
5056 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5059 REVOKE ALL ON TABLE packages FROM PUBLIC;
5060 REVOKE ALL ON TABLE packages FROM wbadm;
5061 GRANT ALL ON TABLE packages TO wbadm;
5062 GRANT ALL ON TABLE packages TO ia64;
5063 GRANT SELECT ON TABLE packages TO wb_security;
5067 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5070 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5071 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5072 GRANT ALL ON TABLE pkg_history TO wbadm;
5073 GRANT ALL ON TABLE pkg_history TO ia64;
5074 GRANT SELECT ON TABLE pkg_history TO wb_security;
5078 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5081 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5082 REVOKE ALL ON TABLE transactions FROM wbadm;
5083 GRANT ALL ON TABLE transactions TO wbadm;
5084 GRANT SELECT,INSERT ON TABLE transactions TO ia64;
5085 GRANT SELECT ON TABLE transactions TO wb_security;
5089 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5092 REVOKE ALL ON TABLE users FROM PUBLIC;
5093 REVOKE ALL ON TABLE users FROM wbadm;
5094 GRANT ALL ON TABLE users TO wbadm;
5095 GRANT ALL ON TABLE users TO ia64;
5098 SET search_path = ia64_public, pg_catalog;
5101 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5104 REVOKE ALL ON TABLE packages FROM PUBLIC;
5105 REVOKE ALL ON TABLE packages FROM wbadm;
5106 GRANT ALL ON TABLE packages TO wbadm;
5107 GRANT SELECT ON TABLE packages TO PUBLIC;
5111 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5114 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5115 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5116 GRANT ALL ON TABLE pkg_history TO wbadm;
5117 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5121 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5124 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5125 REVOKE ALL ON TABLE transactions FROM wbadm;
5126 GRANT ALL ON TABLE transactions TO wbadm;
5127 GRANT SELECT ON TABLE transactions TO PUBLIC;
5131 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5134 REVOKE ALL ON TABLE users FROM PUBLIC;
5135 REVOKE ALL ON TABLE users FROM wbadm;
5136 GRANT ALL ON TABLE users TO wbadm;
5137 GRANT SELECT ON TABLE users TO PUBLIC;
5140 SET search_path = "kfreebsd-amd64", pg_catalog;
5143 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5146 REVOKE ALL ON TABLE packages FROM PUBLIC;
5147 REVOKE ALL ON TABLE packages FROM wbadm;
5148 GRANT ALL ON TABLE packages TO wbadm;
5149 GRANT ALL ON TABLE packages TO "kfreebsd-amd64";
5150 GRANT SELECT ON TABLE packages TO wb_security;
5154 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5157 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5158 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5159 GRANT ALL ON TABLE pkg_history TO wbadm;
5160 GRANT ALL ON TABLE pkg_history TO "kfreebsd-amd64";
5161 GRANT SELECT ON TABLE pkg_history TO wb_security;
5165 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5168 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5169 REVOKE ALL ON TABLE transactions FROM wbadm;
5170 GRANT ALL ON TABLE transactions TO wbadm;
5171 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-amd64";
5172 GRANT SELECT ON TABLE transactions TO wb_security;
5176 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5179 REVOKE ALL ON TABLE users FROM PUBLIC;
5180 REVOKE ALL ON TABLE users FROM wbadm;
5181 GRANT ALL ON TABLE users TO wbadm;
5182 GRANT ALL ON TABLE users TO "kfreebsd-amd64";
5185 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5188 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5191 REVOKE ALL ON TABLE packages FROM PUBLIC;
5192 REVOKE ALL ON TABLE packages FROM wbadm;
5193 GRANT ALL ON TABLE packages TO wbadm;
5194 GRANT SELECT ON TABLE packages TO PUBLIC;
5198 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5201 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5202 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5203 GRANT ALL ON TABLE pkg_history TO wbadm;
5204 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5208 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5211 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5212 REVOKE ALL ON TABLE transactions FROM wbadm;
5213 GRANT ALL ON TABLE transactions TO wbadm;
5214 GRANT SELECT ON TABLE transactions TO PUBLIC;
5218 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5221 REVOKE ALL ON TABLE users FROM PUBLIC;
5222 REVOKE ALL ON TABLE users FROM wbadm;
5223 GRANT ALL ON TABLE users TO wbadm;
5224 GRANT SELECT ON TABLE users TO PUBLIC;
5227 SET search_path = "kfreebsd-i386", pg_catalog;
5230 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5233 REVOKE ALL ON TABLE packages FROM PUBLIC;
5234 REVOKE ALL ON TABLE packages FROM wbadm;
5235 GRANT ALL ON TABLE packages TO wbadm;
5236 GRANT ALL ON TABLE packages TO "kfreebsd-i386";
5237 GRANT SELECT ON TABLE packages TO wb_security;
5241 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5244 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5245 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5246 GRANT ALL ON TABLE pkg_history TO wbadm;
5247 GRANT ALL ON TABLE pkg_history TO "kfreebsd-i386";
5248 GRANT SELECT ON TABLE pkg_history TO wb_security;
5252 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5255 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5256 REVOKE ALL ON TABLE transactions FROM wbadm;
5257 GRANT ALL ON TABLE transactions TO wbadm;
5258 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-i386";
5259 GRANT SELECT ON TABLE transactions TO wb_security;
5263 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5266 REVOKE ALL ON TABLE users FROM PUBLIC;
5267 REVOKE ALL ON TABLE users FROM wbadm;
5268 GRANT ALL ON TABLE users TO wbadm;
5269 GRANT ALL ON TABLE users TO "kfreebsd-i386";
5272 SET search_path = "kfreebsd-i386_public", pg_catalog;
5275 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5278 REVOKE ALL ON TABLE packages FROM PUBLIC;
5279 REVOKE ALL ON TABLE packages FROM wbadm;
5280 GRANT ALL ON TABLE packages TO wbadm;
5281 GRANT SELECT ON TABLE packages TO PUBLIC;
5285 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5288 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5289 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5290 GRANT ALL ON TABLE pkg_history TO wbadm;
5291 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5295 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5298 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5299 REVOKE ALL ON TABLE transactions FROM wbadm;
5300 GRANT ALL ON TABLE transactions TO wbadm;
5301 GRANT SELECT ON TABLE transactions TO PUBLIC;
5305 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5308 REVOKE ALL ON TABLE users FROM PUBLIC;
5309 REVOKE ALL ON TABLE users FROM wbadm;
5310 GRANT ALL ON TABLE users TO wbadm;
5311 GRANT SELECT ON TABLE users TO PUBLIC;
5314 SET search_path = mips, pg_catalog;
5317 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5320 REVOKE ALL ON TABLE packages FROM PUBLIC;
5321 REVOKE ALL ON TABLE packages FROM wbadm;
5322 GRANT ALL ON TABLE packages TO wbadm;
5323 GRANT ALL ON TABLE packages TO mips;
5324 GRANT SELECT ON TABLE packages TO wb_security;
5328 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5331 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5332 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5333 GRANT ALL ON TABLE pkg_history TO wbadm;
5334 GRANT ALL ON TABLE pkg_history TO mips;
5335 GRANT SELECT ON TABLE pkg_history TO wb_security;
5339 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5342 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5343 REVOKE ALL ON TABLE transactions FROM wbadm;
5344 GRANT ALL ON TABLE transactions TO wbadm;
5345 GRANT SELECT,INSERT ON TABLE transactions TO mips;
5346 GRANT SELECT ON TABLE transactions TO wb_security;
5350 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5353 REVOKE ALL ON TABLE users FROM PUBLIC;
5354 REVOKE ALL ON TABLE users FROM wbadm;
5355 GRANT ALL ON TABLE users TO wbadm;
5356 GRANT ALL ON TABLE users TO mips;
5359 SET search_path = mips_public, pg_catalog;
5362 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5365 REVOKE ALL ON TABLE packages FROM PUBLIC;
5366 REVOKE ALL ON TABLE packages FROM wbadm;
5367 GRANT ALL ON TABLE packages TO wbadm;
5368 GRANT SELECT ON TABLE packages TO PUBLIC;
5372 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5375 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5376 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5377 GRANT ALL ON TABLE pkg_history TO wbadm;
5378 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5382 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5385 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5386 REVOKE ALL ON TABLE transactions FROM wbadm;
5387 GRANT ALL ON TABLE transactions TO wbadm;
5388 GRANT SELECT ON TABLE transactions TO PUBLIC;
5392 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5395 REVOKE ALL ON TABLE users FROM PUBLIC;
5396 REVOKE ALL ON TABLE users FROM wbadm;
5397 GRANT ALL ON TABLE users TO wbadm;
5398 GRANT SELECT ON TABLE users TO PUBLIC;
5401 SET search_path = mipsel, pg_catalog;
5404 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5407 REVOKE ALL ON TABLE packages FROM PUBLIC;
5408 REVOKE ALL ON TABLE packages FROM wbadm;
5409 GRANT ALL ON TABLE packages TO wbadm;
5410 GRANT ALL ON TABLE packages TO mipsel;
5411 GRANT SELECT ON TABLE packages TO wb_security;
5415 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5418 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5419 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5420 GRANT ALL ON TABLE pkg_history TO wbadm;
5421 GRANT ALL ON TABLE pkg_history TO mipsel;
5422 GRANT SELECT ON TABLE pkg_history TO wb_security;
5426 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5429 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5430 REVOKE ALL ON TABLE transactions FROM wbadm;
5431 GRANT ALL ON TABLE transactions TO wbadm;
5432 GRANT SELECT,INSERT ON TABLE transactions TO mipsel;
5433 GRANT SELECT ON TABLE transactions TO wb_security;
5437 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5440 REVOKE ALL ON TABLE users FROM PUBLIC;
5441 REVOKE ALL ON TABLE users FROM wbadm;
5442 GRANT ALL ON TABLE users TO wbadm;
5443 GRANT ALL ON TABLE users TO mipsel;
5446 SET search_path = mipsel_public, pg_catalog;
5449 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5452 REVOKE ALL ON TABLE packages FROM PUBLIC;
5453 REVOKE ALL ON TABLE packages FROM wbadm;
5454 GRANT ALL ON TABLE packages TO wbadm;
5455 GRANT SELECT ON TABLE packages TO PUBLIC;
5459 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5462 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5463 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5464 GRANT ALL ON TABLE pkg_history TO wbadm;
5465 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5469 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5472 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5473 REVOKE ALL ON TABLE transactions FROM wbadm;
5474 GRANT ALL ON TABLE transactions TO wbadm;
5475 GRANT SELECT ON TABLE transactions TO PUBLIC;
5479 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5482 REVOKE ALL ON TABLE users FROM PUBLIC;
5483 REVOKE ALL ON TABLE users FROM wbadm;
5484 GRANT ALL ON TABLE users TO wbadm;
5485 GRANT SELECT ON TABLE users TO PUBLIC;
5488 SET search_path = powerpc, pg_catalog;
5491 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5494 REVOKE ALL ON TABLE packages FROM PUBLIC;
5495 REVOKE ALL ON TABLE packages FROM wbadm;
5496 GRANT ALL ON TABLE packages TO wbadm;
5497 GRANT ALL ON TABLE packages TO powerpc;
5498 GRANT SELECT ON TABLE packages TO wb_security;
5502 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5505 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5506 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5507 GRANT ALL ON TABLE pkg_history TO wbadm;
5508 GRANT ALL ON TABLE pkg_history TO powerpc;
5509 GRANT SELECT ON TABLE pkg_history TO wb_security;
5513 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5516 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5517 REVOKE ALL ON TABLE transactions FROM wbadm;
5518 GRANT ALL ON TABLE transactions TO wbadm;
5519 GRANT SELECT,INSERT ON TABLE transactions TO powerpc;
5520 GRANT SELECT ON TABLE transactions TO wb_security;
5524 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5527 REVOKE ALL ON TABLE users FROM PUBLIC;
5528 REVOKE ALL ON TABLE users FROM wbadm;
5529 GRANT ALL ON TABLE users TO wbadm;
5530 GRANT ALL ON TABLE users TO powerpc;
5533 SET search_path = powerpc_public, pg_catalog;
5536 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5539 REVOKE ALL ON TABLE packages FROM PUBLIC;
5540 REVOKE ALL ON TABLE packages FROM wbadm;
5541 GRANT ALL ON TABLE packages TO wbadm;
5542 GRANT SELECT ON TABLE packages TO PUBLIC;
5546 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5549 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5550 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5551 GRANT ALL ON TABLE pkg_history TO wbadm;
5552 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5556 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5559 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5560 REVOKE ALL ON TABLE transactions FROM wbadm;
5561 GRANT ALL ON TABLE transactions TO wbadm;
5562 GRANT SELECT ON TABLE transactions TO PUBLIC;
5566 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5569 REVOKE ALL ON TABLE users FROM PUBLIC;
5570 REVOKE ALL ON TABLE users FROM wbadm;
5571 GRANT ALL ON TABLE users TO wbadm;
5572 GRANT SELECT ON TABLE users TO PUBLIC;
5575 SET search_path = public, pg_catalog;
5578 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5581 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5582 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5583 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5584 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5587 SET search_path = s390, pg_catalog;
5590 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5593 REVOKE ALL ON TABLE packages FROM PUBLIC;
5594 REVOKE ALL ON TABLE packages FROM wbadm;
5595 GRANT ALL ON TABLE packages TO wbadm;
5596 GRANT ALL ON TABLE packages TO s390;
5597 GRANT SELECT ON TABLE packages TO wb_security;
5600 SET search_path = sparc, pg_catalog;
5603 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5606 REVOKE ALL ON TABLE packages FROM PUBLIC;
5607 REVOKE ALL ON TABLE packages FROM wbadm;
5608 GRANT ALL ON TABLE packages TO wbadm;
5609 GRANT ALL ON TABLE packages TO sparc;
5610 GRANT SELECT ON TABLE packages TO wb_security;
5613 SET search_path = public, pg_catalog;
5616 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5619 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5620 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5621 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5622 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5626 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
5629 REVOKE ALL ON TABLE distributions FROM PUBLIC;
5630 REVOKE ALL ON TABLE distributions FROM wbadm;
5631 GRANT ALL ON TABLE distributions TO wbadm;
5632 GRANT SELECT ON TABLE distributions TO PUBLIC;
5635 SET search_path = s390, pg_catalog;
5638 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5641 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5642 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5643 GRANT ALL ON TABLE pkg_history TO wbadm;
5644 GRANT ALL ON TABLE pkg_history TO s390;
5645 GRANT SELECT ON TABLE pkg_history TO wb_security;
5648 SET search_path = s390_public, pg_catalog;
5651 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5654 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5655 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5656 GRANT ALL ON TABLE pkg_history TO wbadm;
5657 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5660 SET search_path = sparc, pg_catalog;
5663 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5666 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5667 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5668 GRANT ALL ON TABLE pkg_history TO wbadm;
5669 GRANT ALL ON TABLE pkg_history TO sparc;
5670 GRANT SELECT ON TABLE pkg_history TO wb_security;
5673 SET search_path = sparc_public, pg_catalog;
5676 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5679 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5680 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5681 GRANT ALL ON TABLE pkg_history TO wbadm;
5682 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5685 SET search_path = public, pg_catalog;
5688 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5691 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5692 REVOKE ALL ON TABLE lastlog FROM wbadm;
5693 GRANT ALL ON TABLE lastlog TO wbadm;
5694 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5698 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5701 REVOKE ALL ON TABLE log FROM PUBLIC;
5702 REVOKE ALL ON TABLE log FROM wbadm;
5703 GRANT ALL ON TABLE log TO wbadm;
5704 GRANT SELECT ON TABLE log TO PUBLIC;
5708 -- Name: log_v2; Type: ACL; Schema: public; Owner: pkern
5711 REVOKE ALL ON TABLE log_v2 FROM PUBLIC;
5712 REVOKE ALL ON TABLE log_v2 FROM pkern;
5713 GRANT ALL ON TABLE log_v2 TO pkern;
5714 GRANT SELECT ON TABLE log_v2 TO PUBLIC;
5717 SET search_path = s390_public, pg_catalog;
5720 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5723 REVOKE ALL ON TABLE packages FROM PUBLIC;
5724 REVOKE ALL ON TABLE packages FROM wbadm;
5725 GRANT ALL ON TABLE packages TO wbadm;
5726 GRANT SELECT ON TABLE packages TO PUBLIC;
5729 SET search_path = sparc_public, pg_catalog;
5732 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5735 REVOKE ALL ON TABLE packages FROM PUBLIC;
5736 REVOKE ALL ON TABLE packages FROM wbadm;
5737 GRANT ALL ON TABLE packages TO wbadm;
5738 GRANT SELECT ON TABLE packages TO PUBLIC;
5741 SET search_path = public, pg_catalog;
5744 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5747 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5748 REVOKE ALL ON TABLE packages_all FROM wbadm;
5749 GRANT ALL ON TABLE packages_all TO wbadm;
5750 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5753 SET search_path = s390, pg_catalog;
5756 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5759 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5760 REVOKE ALL ON TABLE transactions FROM wbadm;
5761 GRANT ALL ON TABLE transactions TO wbadm;
5762 GRANT SELECT,INSERT ON TABLE transactions TO s390;
5763 GRANT SELECT ON TABLE transactions TO wb_security;
5767 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5770 REVOKE ALL ON TABLE users FROM PUBLIC;
5771 REVOKE ALL ON TABLE users FROM wbadm;
5772 GRANT ALL ON TABLE users TO wbadm;
5773 GRANT ALL ON TABLE users TO s390;
5776 SET search_path = s390_public, pg_catalog;
5779 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5782 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5783 REVOKE ALL ON TABLE transactions FROM wbadm;
5784 GRANT ALL ON TABLE transactions TO wbadm;
5785 GRANT SELECT ON TABLE transactions TO PUBLIC;
5789 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5792 REVOKE ALL ON TABLE users FROM PUBLIC;
5793 REVOKE ALL ON TABLE users FROM wbadm;
5794 GRANT ALL ON TABLE users TO wbadm;
5795 GRANT SELECT ON TABLE users TO PUBLIC;
5798 SET search_path = sparc, pg_catalog;
5801 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5804 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5805 REVOKE ALL ON TABLE transactions FROM wbadm;
5806 GRANT ALL ON TABLE transactions TO wbadm;
5807 GRANT SELECT,INSERT ON TABLE transactions TO sparc;
5808 GRANT SELECT ON TABLE transactions TO wb_security;
5812 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5815 REVOKE ALL ON TABLE users FROM PUBLIC;
5816 REVOKE ALL ON TABLE users FROM wbadm;
5817 GRANT ALL ON TABLE users TO wbadm;
5818 GRANT ALL ON TABLE users TO sparc;
5821 SET search_path = sparc_public, pg_catalog;
5824 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5827 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5828 REVOKE ALL ON TABLE transactions FROM wbadm;
5829 GRANT ALL ON TABLE transactions TO wbadm;
5830 GRANT SELECT ON TABLE transactions TO PUBLIC;
5834 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5837 REVOKE ALL ON TABLE users FROM PUBLIC;
5838 REVOKE ALL ON TABLE users FROM wbadm;
5839 GRANT ALL ON TABLE users TO wbadm;
5840 GRANT SELECT ON TABLE users TO PUBLIC;
5844 -- PostgreSQL database dump complete