2 -- PostgreSQL database dump
5 SET statement_timeout = 0;
6 SET client_encoding = 'SQL_ASCII';
7 SET standard_conforming_strings = off;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
10 SET escape_string_warning = off;
13 -- Name: alpha; Type: SCHEMA; Schema: -; Owner: wbadm
19 ALTER SCHEMA alpha OWNER TO wbadm;
22 -- Name: alpha_public; Type: SCHEMA; Schema: -; Owner: wbadm
25 CREATE SCHEMA alpha_public;
28 ALTER SCHEMA alpha_public OWNER TO wbadm;
31 -- Name: amd64; Type: SCHEMA; Schema: -; Owner: wbadm
37 ALTER SCHEMA amd64 OWNER TO wbadm;
40 -- Name: amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
43 CREATE SCHEMA amd64_public;
46 ALTER SCHEMA amd64_public OWNER TO wbadm;
49 -- Name: arm; Type: SCHEMA; Schema: -; Owner: wbadm
55 ALTER SCHEMA arm OWNER TO wbadm;
58 -- Name: arm_public; Type: SCHEMA; Schema: -; Owner: wbadm
61 CREATE SCHEMA arm_public;
64 ALTER SCHEMA arm_public OWNER TO wbadm;
67 -- Name: armel; Type: SCHEMA; Schema: -; Owner: wbadm
73 ALTER SCHEMA armel OWNER TO wbadm;
76 -- Name: armel_public; Type: SCHEMA; Schema: -; Owner: wbadm
79 CREATE SCHEMA armel_public;
82 ALTER SCHEMA armel_public OWNER TO wbadm;
85 -- Name: hppa; Type: SCHEMA; Schema: -; Owner: wbadm
91 ALTER SCHEMA hppa OWNER TO wbadm;
94 -- Name: hppa_public; Type: SCHEMA; Schema: -; Owner: wbadm
97 CREATE SCHEMA hppa_public;
100 ALTER SCHEMA hppa_public OWNER TO wbadm;
103 -- Name: hurd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
106 CREATE SCHEMA "hurd-i386";
109 ALTER SCHEMA "hurd-i386" OWNER TO wbadm;
112 -- Name: hurd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
115 CREATE SCHEMA "hurd-i386_public";
118 ALTER SCHEMA "hurd-i386_public" OWNER TO wbadm;
121 -- Name: i386; Type: SCHEMA; Schema: -; Owner: wbadm
127 ALTER SCHEMA i386 OWNER TO wbadm;
130 -- Name: i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
133 CREATE SCHEMA i386_public;
136 ALTER SCHEMA i386_public OWNER TO wbadm;
139 -- Name: ia64; Type: SCHEMA; Schema: -; Owner: wbadm
145 ALTER SCHEMA ia64 OWNER TO wbadm;
148 -- Name: ia64_public; Type: SCHEMA; Schema: -; Owner: wbadm
151 CREATE SCHEMA ia64_public;
154 ALTER SCHEMA ia64_public OWNER TO wbadm;
157 -- Name: kfreebsd-amd64; Type: SCHEMA; Schema: -; Owner: wbadm
160 CREATE SCHEMA "kfreebsd-amd64";
163 ALTER SCHEMA "kfreebsd-amd64" OWNER TO wbadm;
166 -- Name: kfreebsd-amd64_public; Type: SCHEMA; Schema: -; Owner: wbadm
169 CREATE SCHEMA "kfreebsd-amd64_public";
172 ALTER SCHEMA "kfreebsd-amd64_public" OWNER TO wbadm;
175 -- Name: kfreebsd-i386; Type: SCHEMA; Schema: -; Owner: wbadm
178 CREATE SCHEMA "kfreebsd-i386";
181 ALTER SCHEMA "kfreebsd-i386" OWNER TO wbadm;
184 -- Name: kfreebsd-i386_public; Type: SCHEMA; Schema: -; Owner: wbadm
187 CREATE SCHEMA "kfreebsd-i386_public";
190 ALTER SCHEMA "kfreebsd-i386_public" OWNER TO wbadm;
193 -- Name: mips; Type: SCHEMA; Schema: -; Owner: wbadm
199 ALTER SCHEMA mips OWNER TO wbadm;
202 -- Name: mips_public; Type: SCHEMA; Schema: -; Owner: wbadm
205 CREATE SCHEMA mips_public;
208 ALTER SCHEMA mips_public OWNER TO wbadm;
211 -- Name: mipsel; Type: SCHEMA; Schema: -; Owner: wbadm
214 CREATE SCHEMA mipsel;
217 ALTER SCHEMA mipsel OWNER TO wbadm;
220 -- Name: mipsel_public; Type: SCHEMA; Schema: -; Owner: wbadm
223 CREATE SCHEMA mipsel_public;
226 ALTER SCHEMA mipsel_public OWNER TO wbadm;
229 -- Name: powerpc; Type: SCHEMA; Schema: -; Owner: wbadm
232 CREATE SCHEMA powerpc;
235 ALTER SCHEMA powerpc OWNER TO wbadm;
238 -- Name: powerpc_public; Type: SCHEMA; Schema: -; Owner: wbadm
241 CREATE SCHEMA powerpc_public;
244 ALTER SCHEMA powerpc_public OWNER TO wbadm;
247 -- Name: s390; Type: SCHEMA; Schema: -; Owner: wbadm
253 ALTER SCHEMA s390 OWNER TO wbadm;
256 -- Name: s390_public; Type: SCHEMA; Schema: -; Owner: wbadm
259 CREATE SCHEMA s390_public;
262 ALTER SCHEMA s390_public OWNER TO wbadm;
265 -- Name: sparc; Type: SCHEMA; Schema: -; Owner: wbadm
271 ALTER SCHEMA sparc OWNER TO wbadm;
274 -- Name: sparc_public; Type: SCHEMA; Schema: -; Owner: wbadm
277 CREATE SCHEMA sparc_public;
280 ALTER SCHEMA sparc_public OWNER TO wbadm;
283 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: wbadm
286 CREATE PROCEDURAL LANGUAGE plpgsql;
289 ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO wbadm;
291 SET search_path = public, pg_catalog;
294 -- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres
297 CREATE TYPE debversion;
301 -- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres
304 CREATE FUNCTION debversionin(cstring) RETURNS debversion
305 LANGUAGE internal IMMUTABLE STRICT
309 ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres;
312 -- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres
315 CREATE FUNCTION debversionout(debversion) RETURNS cstring
316 LANGUAGE internal IMMUTABLE STRICT
320 ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres;
323 -- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres
326 CREATE FUNCTION debversionrecv(internal) RETURNS debversion
327 LANGUAGE internal STABLE STRICT
331 ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres;
334 -- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres
337 CREATE FUNCTION debversionsend(debversion) RETURNS bytea
338 LANGUAGE internal STABLE STRICT
342 ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres;
345 -- Name: debversion; Type: TYPE; Schema: public; Owner: postgres
348 CREATE TYPE debversion (
349 INTERNALLENGTH = variable,
350 INPUT = debversionin,
351 OUTPUT = debversionout,
352 RECEIVE = debversionrecv,
353 SEND = debversionsend,
360 ALTER TYPE public.debversion OWNER TO postgres;
363 -- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres
366 COMMENT ON TYPE debversion IS 'Debian package version number';
370 -- Name: commacat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
373 CREATE FUNCTION commacat(acc text, instr text) RETURNS text
377 IF acc IS NULL OR acc = '' THEN
380 RETURN acc || ', ' || instr;
386 ALTER FUNCTION public.commacat(acc text, instr text) OWNER TO pkern;
389 -- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres
392 CREATE FUNCTION debversion(character) RETURNS debversion
393 LANGUAGE internal IMMUTABLE STRICT
397 ALTER FUNCTION public.debversion(character) OWNER TO postgres;
400 -- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
403 CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer
404 LANGUAGE c IMMUTABLE STRICT
405 AS '$libdir/debversion', 'debversion_cmp';
408 ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres;
411 -- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
414 COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions';
418 -- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
421 CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean
422 LANGUAGE c IMMUTABLE STRICT
423 AS '$libdir/debversion', 'debversion_eq';
426 ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres;
429 -- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
432 COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal';
436 -- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
439 CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean
440 LANGUAGE c IMMUTABLE STRICT
441 AS '$libdir/debversion', 'debversion_ge';
444 ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres;
447 -- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
450 COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal';
454 -- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
457 CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean
458 LANGUAGE c IMMUTABLE STRICT
459 AS '$libdir/debversion', 'debversion_gt';
462 ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres;
465 -- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
468 COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than';
472 -- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres
475 CREATE FUNCTION debversion_hash(debversion) RETURNS integer
476 LANGUAGE c IMMUTABLE STRICT
477 AS '$libdir/debversion', 'debversion_hash';
480 ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres;
483 -- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
486 CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion
487 LANGUAGE c IMMUTABLE STRICT
488 AS '$libdir/debversion', 'debversion_larger';
491 ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres;
494 -- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
497 CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean
498 LANGUAGE c IMMUTABLE STRICT
499 AS '$libdir/debversion', 'debversion_le';
502 ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres;
505 -- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
508 COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal';
512 -- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
515 CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean
516 LANGUAGE c IMMUTABLE STRICT
517 AS '$libdir/debversion', 'debversion_lt';
520 ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres;
523 -- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
526 COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than';
530 -- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
533 CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean
534 LANGUAGE c IMMUTABLE STRICT
535 AS '$libdir/debversion', 'debversion_ne';
538 ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres;
541 -- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
544 COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal';
548 -- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
551 CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion
552 LANGUAGE c IMMUTABLE STRICT
553 AS '$libdir/debversion', 'debversion_smaller';
556 ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres;
559 -- Name: query_source_package(character varying, character varying); Type: FUNCTION; Schema: public; Owner: wbadm
562 CREATE FUNCTION query_source_package(param_dist character varying, param_srcpkg character varying) RETURNS SETOF record
568 SELECT 'alpha'::character varying AS arch, * INTO temp_row FROM "alpha_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
570 RETURN NEXT temp_row;
572 SELECT 'amd64'::character varying AS arch, * INTO temp_row FROM "amd64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
574 RETURN NEXT temp_row;
576 SELECT 'arm'::character varying AS arch, * INTO temp_row FROM "arm_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
578 RETURN NEXT temp_row;
580 SELECT 'armel'::character varying AS arch, * INTO temp_row FROM "armel_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
582 RETURN NEXT temp_row;
584 SELECT 'hppa'::character varying AS arch, * INTO temp_row FROM "hppa_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
586 RETURN NEXT temp_row;
588 SELECT 'hurd-i386'::character varying AS arch, * INTO temp_row FROM "hurd-i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
590 RETURN NEXT temp_row;
592 SELECT 'i386'::character varying AS arch, * INTO temp_row FROM "i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
594 RETURN NEXT temp_row;
596 SELECT 'ia64'::character varying AS arch, * INTO temp_row FROM "ia64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
598 RETURN NEXT temp_row;
600 SELECT 'kfreebsd-amd64'::character varying AS arch, * INTO temp_row FROM "kfreebsd-amd64_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
602 RETURN NEXT temp_row;
604 SELECT 'freebsd-i386'::character varying AS arch, * INTO temp_row FROM "kfreebsd-i386_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
606 RETURN NEXT temp_row;
608 SELECT 'mips'::character varying AS arch, * INTO temp_row FROM "mips_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
610 RETURN NEXT temp_row;
612 SELECT 'mipsel'::character varying AS arch, * INTO temp_row FROM "mipsel_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
614 RETURN NEXT temp_row;
616 SELECT 'powerpc'::character varying AS arch, * INTO temp_row FROM "powerpc_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
618 RETURN NEXT temp_row;
620 SELECT 's390'::character varying AS arch, * INTO temp_row FROM "s390_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
622 RETURN NEXT temp_row;
624 SELECT 'sparc'::character varying AS arch, * INTO temp_row FROM "sparc_public".packages WHERE distribution = param_dist AND package = param_srcpkg;
626 RETURN NEXT temp_row;
632 ALTER FUNCTION public.query_source_package(param_dist character varying, param_srcpkg character varying) OWNER TO wbadm;
635 -- Name: spacecat(text, text); Type: FUNCTION; Schema: public; Owner: pkern
638 CREATE FUNCTION spacecat(acc text, instr text) RETURNS text
642 IF acc IS NULL OR acc = '' THEN
645 RETURN acc || ' ' || instr;
651 ALTER FUNCTION public.spacecat(acc text, instr text) OWNER TO pkern;
654 -- Name: commacat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
657 CREATE AGGREGATE commacat_all(text) (
664 ALTER AGGREGATE public.commacat_all(text) OWNER TO pkern;
667 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
671 PROCEDURE = debversion_gt,
672 LEFTARG = debversion,
673 RIGHTARG = debversion,
679 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
682 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
685 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
689 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
692 CREATE AGGREGATE max(debversion) (
693 SFUNC = debversion_larger,
699 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
702 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
706 PROCEDURE = debversion_lt,
707 LEFTARG = debversion,
708 RIGHTARG = debversion,
714 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
717 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
720 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
724 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
727 CREATE AGGREGATE min(debversion) (
728 SFUNC = debversion_smaller,
734 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
737 -- Name: spacecat_all(text); Type: AGGREGATE; Schema: public; Owner: pkern
740 CREATE AGGREGATE spacecat_all(text) (
747 ALTER AGGREGATE public.spacecat_all(text) OWNER TO pkern;
750 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
754 PROCEDURE = debversion_le,
755 LEFTARG = debversion,
756 RIGHTARG = debversion,
762 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
765 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
768 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
772 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
776 PROCEDURE = debversion_ne,
777 LEFTARG = debversion,
778 RIGHTARG = debversion,
784 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
787 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
790 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
794 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
798 PROCEDURE = debversion_eq,
799 LEFTARG = debversion,
800 RIGHTARG = debversion,
806 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
809 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
812 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
816 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
820 PROCEDURE = debversion_ge,
821 LEFTARG = debversion,
822 RIGHTARG = debversion,
828 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
831 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
834 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
838 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
841 CREATE OPERATOR CLASS debversion_ops
842 DEFAULT FOR TYPE debversion USING btree AS
843 OPERATOR 1 <(debversion,debversion) ,
844 OPERATOR 2 <=(debversion,debversion) ,
845 OPERATOR 3 =(debversion,debversion) ,
846 OPERATOR 4 >=(debversion,debversion) ,
847 OPERATOR 5 >(debversion,debversion) ,
848 FUNCTION 1 debversion_cmp(debversion,debversion);
851 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
854 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
857 CREATE OPERATOR CLASS debversion_ops
858 DEFAULT FOR TYPE debversion USING hash AS
859 OPERATOR 1 =(debversion,debversion) ,
860 FUNCTION 1 debversion_hash(debversion);
863 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
865 SET search_path = pg_catalog;
868 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
871 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
875 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
878 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
882 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
885 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
889 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
892 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
896 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
899 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
903 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
906 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
909 SET search_path = alpha, pg_catalog;
911 SET default_tablespace = '';
913 SET default_with_oids = false;
916 -- Name: packages; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
919 CREATE TABLE packages (
920 package character varying NOT NULL,
921 distribution character varying NOT NULL,
922 version character varying,
923 state character varying,
924 section character varying,
925 priority character varying,
926 installed_version character varying,
927 previous_state character varying,
928 state_change timestamp without time zone,
929 notes character varying,
930 builder character varying,
933 binary_nmu_version integer,
934 binary_nmu_changelog character varying,
935 failed_category character varying,
936 permbuildpri integer,
938 depends character varying,
939 rel character varying,
941 extra_depends character varying,
942 extra_conflicts character varying
946 ALTER TABLE alpha.packages OWNER TO wbadm;
949 -- Name: pkg_history; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
952 CREATE TABLE pkg_history (
953 package character varying NOT NULL,
954 distribution character varying NOT NULL,
955 version character varying NOT NULL,
956 "timestamp" timestamp without time zone NOT NULL,
957 result character varying NOT NULL,
963 ALTER TABLE alpha.pkg_history OWNER TO wbadm;
966 -- Name: transactions; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
969 CREATE TABLE transactions (
970 package character varying,
971 distribution character varying,
972 version character varying,
973 action character varying,
974 prevstate character varying,
975 state character varying,
976 real_user character varying,
977 set_user character varying,
978 "time" timestamp without time zone
982 ALTER TABLE alpha.transactions OWNER TO wbadm;
985 -- Name: users; Type: TABLE; Schema: alpha; Owner: wbadm; Tablespace:
989 username character varying NOT NULL,
990 distribution character varying NOT NULL,
991 last_seen timestamp without time zone
995 ALTER TABLE alpha.users OWNER TO wbadm;
997 SET search_path = alpha_public, pg_catalog;
1000 -- Name: packages; Type: VIEW; Schema: alpha_public; Owner: wbadm
1003 CREATE VIEW packages AS
1004 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM alpha.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1007 ALTER TABLE alpha_public.packages OWNER TO wbadm;
1010 -- Name: pkg_history; Type: VIEW; Schema: alpha_public; Owner: wbadm
1013 CREATE VIEW pkg_history AS
1014 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM alpha.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1017 ALTER TABLE alpha_public.pkg_history OWNER TO wbadm;
1020 -- Name: transactions; Type: VIEW; Schema: alpha_public; Owner: wbadm
1023 CREATE VIEW transactions AS
1024 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM alpha.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1027 ALTER TABLE alpha_public.transactions OWNER TO wbadm;
1030 -- Name: users; Type: VIEW; Schema: alpha_public; Owner: wbadm
1033 CREATE VIEW users AS
1034 SELECT users.username, users.distribution, users.last_seen FROM alpha.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1037 ALTER TABLE alpha_public.users OWNER TO wbadm;
1039 SET search_path = amd64, pg_catalog;
1042 -- Name: packages; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1045 CREATE TABLE packages (
1046 package character varying NOT NULL,
1047 distribution character varying NOT NULL,
1048 version character varying,
1049 state character varying,
1050 section character varying,
1051 priority character varying,
1052 installed_version character varying,
1053 previous_state character varying,
1054 state_change timestamp without time zone,
1055 notes character varying,
1056 builder character varying,
1059 binary_nmu_version integer,
1060 binary_nmu_changelog character varying,
1061 failed_category character varying,
1062 permbuildpri integer,
1064 depends character varying,
1065 rel character varying,
1067 extra_depends character varying,
1068 extra_conflicts character varying
1072 ALTER TABLE amd64.packages OWNER TO wbadm;
1075 -- Name: pkg_history; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1078 CREATE TABLE pkg_history (
1079 package character varying NOT NULL,
1080 distribution character varying NOT NULL,
1081 version character varying NOT NULL,
1082 "timestamp" timestamp without time zone NOT NULL,
1083 result character varying NOT NULL,
1089 ALTER TABLE amd64.pkg_history OWNER TO wbadm;
1092 -- Name: transactions; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1095 CREATE TABLE transactions (
1096 package character varying,
1097 distribution character varying,
1098 version character varying,
1099 action character varying,
1100 prevstate character varying,
1101 state character varying,
1102 real_user character varying,
1103 set_user character varying,
1104 "time" timestamp without time zone
1108 ALTER TABLE amd64.transactions OWNER TO wbadm;
1111 -- Name: users; Type: TABLE; Schema: amd64; Owner: wbadm; Tablespace:
1114 CREATE TABLE users (
1115 username character varying NOT NULL,
1116 distribution character varying NOT NULL,
1117 last_seen timestamp without time zone
1121 ALTER TABLE amd64.users OWNER TO wbadm;
1123 SET search_path = amd64_public, pg_catalog;
1126 -- Name: packages; Type: VIEW; Schema: amd64_public; Owner: wbadm
1129 CREATE VIEW packages AS
1130 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM amd64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1133 ALTER TABLE amd64_public.packages OWNER TO wbadm;
1136 -- Name: pkg_history; Type: VIEW; Schema: amd64_public; Owner: wbadm
1139 CREATE VIEW pkg_history AS
1140 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM amd64.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1143 ALTER TABLE amd64_public.pkg_history OWNER TO wbadm;
1146 -- Name: transactions; Type: VIEW; Schema: amd64_public; Owner: wbadm
1149 CREATE VIEW transactions AS
1150 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM amd64.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1153 ALTER TABLE amd64_public.transactions OWNER TO wbadm;
1156 -- Name: users; Type: VIEW; Schema: amd64_public; Owner: wbadm
1159 CREATE VIEW users AS
1160 SELECT users.username, users.distribution, users.last_seen FROM amd64.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1163 ALTER TABLE amd64_public.users OWNER TO wbadm;
1165 SET search_path = arm, pg_catalog;
1168 -- Name: packages; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1171 CREATE TABLE packages (
1172 package character varying NOT NULL,
1173 distribution character varying NOT NULL,
1174 version character varying,
1175 state character varying,
1176 section character varying,
1177 priority character varying,
1178 installed_version character varying,
1179 previous_state character varying,
1180 state_change timestamp without time zone,
1181 notes character varying,
1182 builder character varying,
1185 binary_nmu_version integer,
1186 binary_nmu_changelog character varying,
1187 failed_category character varying,
1188 permbuildpri integer,
1190 depends character varying,
1191 rel character varying,
1193 extra_depends character varying,
1194 extra_conflicts character varying
1198 ALTER TABLE arm.packages OWNER TO wbadm;
1201 -- Name: pkg_history; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1204 CREATE TABLE pkg_history (
1205 package character varying NOT NULL,
1206 distribution character varying NOT NULL,
1207 version character varying NOT NULL,
1208 "timestamp" timestamp without time zone NOT NULL,
1209 result character varying NOT NULL,
1215 ALTER TABLE arm.pkg_history OWNER TO wbadm;
1218 -- Name: transactions; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1221 CREATE TABLE transactions (
1222 package character varying,
1223 distribution character varying,
1224 version character varying,
1225 action character varying,
1226 prevstate character varying,
1227 state character varying,
1228 real_user character varying,
1229 set_user character varying,
1230 "time" timestamp without time zone
1234 ALTER TABLE arm.transactions OWNER TO wbadm;
1237 -- Name: users; Type: TABLE; Schema: arm; Owner: wbadm; Tablespace:
1240 CREATE TABLE users (
1241 username character varying NOT NULL,
1242 distribution character varying NOT NULL,
1243 last_seen timestamp without time zone
1247 ALTER TABLE arm.users OWNER TO wbadm;
1249 SET search_path = arm_public, pg_catalog;
1252 -- Name: packages; Type: VIEW; Schema: arm_public; Owner: wbadm
1255 CREATE VIEW packages AS
1256 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM arm.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1259 ALTER TABLE arm_public.packages OWNER TO wbadm;
1262 -- Name: pkg_history; Type: VIEW; Schema: arm_public; Owner: wbadm
1265 CREATE VIEW pkg_history AS
1266 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM arm.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1269 ALTER TABLE arm_public.pkg_history OWNER TO wbadm;
1272 -- Name: transactions; Type: VIEW; Schema: arm_public; Owner: wbadm
1275 CREATE VIEW transactions AS
1276 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM arm.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1279 ALTER TABLE arm_public.transactions OWNER TO wbadm;
1282 -- Name: users; Type: VIEW; Schema: arm_public; Owner: wbadm
1285 CREATE VIEW users AS
1286 SELECT users.username, users.distribution, users.last_seen FROM arm.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1289 ALTER TABLE arm_public.users OWNER TO wbadm;
1291 SET search_path = armel, pg_catalog;
1294 -- Name: packages; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1297 CREATE TABLE packages (
1298 package character varying NOT NULL,
1299 distribution character varying NOT NULL,
1300 version character varying,
1301 state character varying,
1302 section character varying,
1303 priority character varying,
1304 installed_version character varying,
1305 previous_state character varying,
1306 state_change timestamp without time zone,
1307 notes character varying,
1308 builder character varying,
1311 binary_nmu_version integer,
1312 binary_nmu_changelog character varying,
1313 failed_category character varying,
1314 permbuildpri integer,
1316 depends character varying,
1317 rel character varying,
1319 extra_depends character varying,
1320 extra_conflicts character varying
1324 ALTER TABLE armel.packages OWNER TO wbadm;
1327 -- Name: pkg_history; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1330 CREATE TABLE pkg_history (
1331 package character varying NOT NULL,
1332 distribution character varying NOT NULL,
1333 version character varying NOT NULL,
1334 "timestamp" timestamp without time zone NOT NULL,
1335 result character varying NOT NULL,
1341 ALTER TABLE armel.pkg_history OWNER TO wbadm;
1344 -- Name: transactions; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1347 CREATE TABLE transactions (
1348 package character varying,
1349 distribution character varying,
1350 version character varying,
1351 action character varying,
1352 prevstate character varying,
1353 state character varying,
1354 real_user character varying,
1355 set_user character varying,
1356 "time" timestamp without time zone
1360 ALTER TABLE armel.transactions OWNER TO wbadm;
1363 -- Name: users; Type: TABLE; Schema: armel; Owner: wbadm; Tablespace:
1366 CREATE TABLE users (
1367 username character varying NOT NULL,
1368 distribution character varying NOT NULL,
1369 last_seen timestamp without time zone
1373 ALTER TABLE armel.users OWNER TO wbadm;
1375 SET search_path = armel_public, pg_catalog;
1378 -- Name: packages; Type: VIEW; Schema: armel_public; Owner: wbadm
1381 CREATE VIEW packages AS
1382 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM armel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1385 ALTER TABLE armel_public.packages OWNER TO wbadm;
1388 -- Name: pkg_history; Type: VIEW; Schema: armel_public; Owner: wbadm
1391 CREATE VIEW pkg_history AS
1392 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM armel.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1395 ALTER TABLE armel_public.pkg_history OWNER TO wbadm;
1398 -- Name: transactions; Type: VIEW; Schema: armel_public; Owner: wbadm
1401 CREATE VIEW transactions AS
1402 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM armel.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1405 ALTER TABLE armel_public.transactions OWNER TO wbadm;
1408 -- Name: users; Type: VIEW; Schema: armel_public; Owner: wbadm
1411 CREATE VIEW users AS
1412 SELECT users.username, users.distribution, users.last_seen FROM armel.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1415 ALTER TABLE armel_public.users OWNER TO wbadm;
1417 SET search_path = hppa, pg_catalog;
1420 -- Name: packages; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1423 CREATE TABLE packages (
1424 package character varying NOT NULL,
1425 distribution character varying NOT NULL,
1426 version character varying,
1427 state character varying,
1428 section character varying,
1429 priority character varying,
1430 installed_version character varying,
1431 previous_state character varying,
1432 state_change timestamp without time zone,
1433 notes character varying,
1434 builder character varying,
1437 binary_nmu_version integer,
1438 binary_nmu_changelog character varying,
1439 failed_category character varying,
1440 permbuildpri integer,
1442 depends character varying,
1443 rel character varying,
1445 extra_depends character varying,
1446 extra_conflicts character varying
1450 ALTER TABLE hppa.packages OWNER TO wbadm;
1453 -- Name: pkg_history; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1456 CREATE TABLE pkg_history (
1457 package character varying NOT NULL,
1458 distribution character varying NOT NULL,
1459 version character varying NOT NULL,
1460 "timestamp" timestamp without time zone NOT NULL,
1461 result character varying NOT NULL,
1467 ALTER TABLE hppa.pkg_history OWNER TO wbadm;
1470 -- Name: transactions; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1473 CREATE TABLE transactions (
1474 package character varying,
1475 distribution character varying,
1476 version character varying,
1477 action character varying,
1478 prevstate character varying,
1479 state character varying,
1480 real_user character varying,
1481 set_user character varying,
1482 "time" timestamp without time zone
1486 ALTER TABLE hppa.transactions OWNER TO wbadm;
1489 -- Name: users; Type: TABLE; Schema: hppa; Owner: wbadm; Tablespace:
1492 CREATE TABLE users (
1493 username character varying NOT NULL,
1494 distribution character varying NOT NULL,
1495 last_seen timestamp without time zone
1499 ALTER TABLE hppa.users OWNER TO wbadm;
1501 SET search_path = hppa_public, pg_catalog;
1504 -- Name: packages; Type: VIEW; Schema: hppa_public; Owner: wbadm
1507 CREATE VIEW packages AS
1508 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM hppa.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1511 ALTER TABLE hppa_public.packages OWNER TO wbadm;
1514 -- Name: pkg_history; Type: VIEW; Schema: hppa_public; Owner: wbadm
1517 CREATE VIEW pkg_history AS
1518 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM hppa.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1521 ALTER TABLE hppa_public.pkg_history OWNER TO wbadm;
1524 -- Name: transactions; Type: VIEW; Schema: hppa_public; Owner: wbadm
1527 CREATE VIEW transactions AS
1528 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM hppa.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1531 ALTER TABLE hppa_public.transactions OWNER TO wbadm;
1534 -- Name: users; Type: VIEW; Schema: hppa_public; Owner: wbadm
1537 CREATE VIEW users AS
1538 SELECT users.username, users.distribution, users.last_seen FROM hppa.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1541 ALTER TABLE hppa_public.users OWNER TO wbadm;
1543 SET search_path = "hurd-i386", pg_catalog;
1546 -- Name: packages; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1549 CREATE TABLE packages (
1550 package character varying NOT NULL,
1551 distribution character varying NOT NULL,
1552 version character varying,
1553 state character varying,
1554 section character varying,
1555 priority character varying,
1556 installed_version character varying,
1557 previous_state character varying,
1558 state_change timestamp without time zone,
1559 notes character varying,
1560 builder character varying,
1563 binary_nmu_version integer,
1564 binary_nmu_changelog character varying,
1565 failed_category character varying,
1566 permbuildpri integer,
1568 depends character varying,
1569 rel character varying,
1571 extra_depends character varying,
1572 extra_conflicts character varying
1576 ALTER TABLE "hurd-i386".packages OWNER TO wbadm;
1579 -- Name: pkg_history; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1582 CREATE TABLE pkg_history (
1583 package character varying NOT NULL,
1584 distribution character varying NOT NULL,
1585 version character varying NOT NULL,
1586 "timestamp" timestamp without time zone NOT NULL,
1587 result character varying NOT NULL,
1593 ALTER TABLE "hurd-i386".pkg_history OWNER TO wbadm;
1596 -- Name: transactions; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1599 CREATE TABLE transactions (
1600 package character varying,
1601 distribution character varying,
1602 version character varying,
1603 action character varying,
1604 prevstate character varying,
1605 state character varying,
1606 real_user character varying,
1607 set_user character varying,
1608 "time" timestamp without time zone
1612 ALTER TABLE "hurd-i386".transactions OWNER TO wbadm;
1615 -- Name: users; Type: TABLE; Schema: hurd-i386; Owner: wbadm; Tablespace:
1618 CREATE TABLE users (
1619 username character varying NOT NULL,
1620 distribution character varying NOT NULL,
1621 last_seen timestamp without time zone
1625 ALTER TABLE "hurd-i386".users OWNER TO wbadm;
1627 SET search_path = "hurd-i386_public", pg_catalog;
1630 -- Name: packages; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1633 CREATE VIEW packages AS
1634 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM "hurd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1637 ALTER TABLE "hurd-i386_public".packages OWNER TO wbadm;
1640 -- Name: pkg_history; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1643 CREATE VIEW pkg_history AS
1644 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM "hurd-i386".pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1647 ALTER TABLE "hurd-i386_public".pkg_history OWNER TO wbadm;
1650 -- Name: transactions; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1653 CREATE VIEW transactions AS
1654 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM "hurd-i386".transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1657 ALTER TABLE "hurd-i386_public".transactions OWNER TO wbadm;
1660 -- Name: users; Type: VIEW; Schema: hurd-i386_public; Owner: wbadm
1663 CREATE VIEW users AS
1664 SELECT users.username, users.distribution, users.last_seen FROM "hurd-i386".users WHERE ((users.distribution)::text !~~ '%-security'::text);
1667 ALTER TABLE "hurd-i386_public".users OWNER TO wbadm;
1669 SET search_path = i386, pg_catalog;
1672 -- Name: packages; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1675 CREATE TABLE packages (
1676 package character varying NOT NULL,
1677 distribution character varying NOT NULL,
1678 version character varying,
1679 state character varying,
1680 section character varying,
1681 priority character varying,
1682 installed_version character varying,
1683 previous_state character varying,
1684 state_change timestamp without time zone,
1685 notes character varying,
1686 builder character varying,
1689 binary_nmu_version integer,
1690 binary_nmu_changelog character varying,
1691 failed_category character varying,
1692 permbuildpri integer,
1694 depends character varying,
1695 rel character varying,
1697 extra_depends character varying,
1698 extra_conflicts character varying
1702 ALTER TABLE i386.packages OWNER TO wbadm;
1705 -- Name: pkg_history; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1708 CREATE TABLE pkg_history (
1709 package character varying NOT NULL,
1710 distribution character varying NOT NULL,
1711 version character varying NOT NULL,
1712 "timestamp" timestamp without time zone NOT NULL,
1713 result character varying NOT NULL,
1719 ALTER TABLE i386.pkg_history OWNER TO wbadm;
1722 -- Name: transactions; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1725 CREATE TABLE transactions (
1726 package character varying,
1727 distribution character varying,
1728 version character varying,
1729 action character varying,
1730 prevstate character varying,
1731 state character varying,
1732 real_user character varying,
1733 set_user character varying,
1734 "time" timestamp without time zone
1738 ALTER TABLE i386.transactions OWNER TO wbadm;
1741 -- Name: users; Type: TABLE; Schema: i386; Owner: wbadm; Tablespace:
1744 CREATE TABLE users (
1745 username character varying NOT NULL,
1746 distribution character varying NOT NULL,
1747 last_seen timestamp without time zone
1751 ALTER TABLE i386.users OWNER TO wbadm;
1753 SET search_path = i386_public, pg_catalog;
1756 -- Name: packages; Type: VIEW; Schema: i386_public; Owner: wbadm
1759 CREATE VIEW packages AS
1760 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM i386.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1763 ALTER TABLE i386_public.packages OWNER TO wbadm;
1766 -- Name: pkg_history; Type: VIEW; Schema: i386_public; Owner: wbadm
1769 CREATE VIEW pkg_history AS
1770 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM i386.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1773 ALTER TABLE i386_public.pkg_history OWNER TO wbadm;
1776 -- Name: transactions; Type: VIEW; Schema: i386_public; Owner: wbadm
1779 CREATE VIEW transactions AS
1780 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM i386.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1783 ALTER TABLE i386_public.transactions OWNER TO wbadm;
1786 -- Name: users; Type: VIEW; Schema: i386_public; Owner: wbadm
1789 CREATE VIEW users AS
1790 SELECT users.username, users.distribution, users.last_seen FROM i386.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1793 ALTER TABLE i386_public.users OWNER TO wbadm;
1795 SET search_path = ia64, pg_catalog;
1798 -- Name: packages; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1801 CREATE TABLE packages (
1802 package character varying NOT NULL,
1803 distribution character varying NOT NULL,
1804 version character varying,
1805 state character varying,
1806 section character varying,
1807 priority character varying,
1808 installed_version character varying,
1809 previous_state character varying,
1810 state_change timestamp without time zone,
1811 notes character varying,
1812 builder character varying,
1815 binary_nmu_version integer,
1816 binary_nmu_changelog character varying,
1817 failed_category character varying,
1818 permbuildpri integer,
1820 depends character varying,
1821 rel character varying,
1823 extra_depends character varying,
1824 extra_conflicts character varying
1828 ALTER TABLE ia64.packages OWNER TO wbadm;
1831 -- Name: pkg_history; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1834 CREATE TABLE pkg_history (
1835 package character varying NOT NULL,
1836 distribution character varying NOT NULL,
1837 version character varying NOT NULL,
1838 "timestamp" timestamp without time zone NOT NULL,
1839 result character varying NOT NULL,
1845 ALTER TABLE ia64.pkg_history OWNER TO wbadm;
1848 -- Name: transactions; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1851 CREATE TABLE transactions (
1852 package character varying,
1853 distribution character varying,
1854 version character varying,
1855 action character varying,
1856 prevstate character varying,
1857 state character varying,
1858 real_user character varying,
1859 set_user character varying,
1860 "time" timestamp without time zone
1864 ALTER TABLE ia64.transactions OWNER TO wbadm;
1867 -- Name: users; Type: TABLE; Schema: ia64; Owner: wbadm; Tablespace:
1870 CREATE TABLE users (
1871 username character varying NOT NULL,
1872 distribution character varying NOT NULL,
1873 last_seen timestamp without time zone
1877 ALTER TABLE ia64.users OWNER TO wbadm;
1879 SET search_path = ia64_public, pg_catalog;
1882 -- Name: packages; Type: VIEW; Schema: ia64_public; Owner: wbadm
1885 CREATE VIEW packages AS
1886 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM ia64.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
1889 ALTER TABLE ia64_public.packages OWNER TO wbadm;
1892 -- Name: pkg_history; Type: VIEW; Schema: ia64_public; Owner: wbadm
1895 CREATE VIEW pkg_history AS
1896 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM ia64.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
1899 ALTER TABLE ia64_public.pkg_history OWNER TO wbadm;
1902 -- Name: transactions; Type: VIEW; Schema: ia64_public; Owner: wbadm
1905 CREATE VIEW transactions AS
1906 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM ia64.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
1909 ALTER TABLE ia64_public.transactions OWNER TO wbadm;
1912 -- Name: users; Type: VIEW; Schema: ia64_public; Owner: wbadm
1915 CREATE VIEW users AS
1916 SELECT users.username, users.distribution, users.last_seen FROM ia64.users WHERE ((users.distribution)::text !~~ '%-security'::text);
1919 ALTER TABLE ia64_public.users OWNER TO wbadm;
1921 SET search_path = "kfreebsd-amd64", pg_catalog;
1924 -- Name: packages; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1927 CREATE TABLE packages (
1928 package character varying NOT NULL,
1929 distribution character varying NOT NULL,
1930 version character varying,
1931 state character varying,
1932 section character varying,
1933 priority character varying,
1934 installed_version character varying,
1935 previous_state character varying,
1936 state_change timestamp without time zone,
1937 notes character varying,
1938 builder character varying,
1941 binary_nmu_version integer,
1942 binary_nmu_changelog character varying,
1943 failed_category character varying,
1944 permbuildpri integer,
1946 depends character varying,
1947 rel character varying,
1949 extra_depends character varying,
1950 extra_conflicts character varying
1954 ALTER TABLE "kfreebsd-amd64".packages OWNER TO wbadm;
1957 -- Name: pkg_history; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1960 CREATE TABLE pkg_history (
1961 package character varying NOT NULL,
1962 distribution character varying NOT NULL,
1963 version character varying NOT NULL,
1964 "timestamp" timestamp without time zone NOT NULL,
1965 result character varying NOT NULL,
1971 ALTER TABLE "kfreebsd-amd64".pkg_history OWNER TO wbadm;
1974 -- Name: transactions; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1977 CREATE TABLE transactions (
1978 package character varying,
1979 distribution character varying,
1980 version character varying,
1981 action character varying,
1982 prevstate character varying,
1983 state character varying,
1984 real_user character varying,
1985 set_user character varying,
1986 "time" timestamp without time zone
1990 ALTER TABLE "kfreebsd-amd64".transactions OWNER TO wbadm;
1993 -- Name: users; Type: TABLE; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
1996 CREATE TABLE users (
1997 username character varying NOT NULL,
1998 distribution character varying NOT NULL,
1999 last_seen timestamp without time zone
2003 ALTER TABLE "kfreebsd-amd64".users OWNER TO wbadm;
2005 SET search_path = "kfreebsd-amd64_public", pg_catalog;
2008 -- Name: packages; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2011 CREATE VIEW packages AS
2012 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM "kfreebsd-amd64".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2015 ALTER TABLE "kfreebsd-amd64_public".packages OWNER TO wbadm;
2018 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2021 CREATE VIEW pkg_history AS
2022 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM "kfreebsd-amd64".pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2025 ALTER TABLE "kfreebsd-amd64_public".pkg_history OWNER TO wbadm;
2028 -- Name: transactions; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2031 CREATE VIEW transactions AS
2032 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM "kfreebsd-amd64".transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2035 ALTER TABLE "kfreebsd-amd64_public".transactions OWNER TO wbadm;
2038 -- Name: users; Type: VIEW; Schema: kfreebsd-amd64_public; Owner: wbadm
2041 CREATE VIEW users AS
2042 SELECT users.username, users.distribution, users.last_seen FROM "kfreebsd-amd64".users WHERE ((users.distribution)::text !~~ '%-security'::text);
2045 ALTER TABLE "kfreebsd-amd64_public".users OWNER TO wbadm;
2047 SET search_path = "kfreebsd-i386", pg_catalog;
2050 -- Name: packages; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2053 CREATE TABLE packages (
2054 package character varying NOT NULL,
2055 distribution character varying NOT NULL,
2056 version character varying,
2057 state character varying,
2058 section character varying,
2059 priority character varying,
2060 installed_version character varying,
2061 previous_state character varying,
2062 state_change timestamp without time zone,
2063 notes character varying,
2064 builder character varying,
2067 binary_nmu_version integer,
2068 binary_nmu_changelog character varying,
2069 failed_category character varying,
2070 permbuildpri integer,
2072 depends character varying,
2073 rel character varying,
2075 extra_depends character varying,
2076 extra_conflicts character varying
2080 ALTER TABLE "kfreebsd-i386".packages OWNER TO wbadm;
2083 -- Name: pkg_history; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2086 CREATE TABLE pkg_history (
2087 package character varying NOT NULL,
2088 distribution character varying NOT NULL,
2089 version character varying NOT NULL,
2090 "timestamp" timestamp without time zone NOT NULL,
2091 result character varying NOT NULL,
2097 ALTER TABLE "kfreebsd-i386".pkg_history OWNER TO wbadm;
2100 -- Name: transactions; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2103 CREATE TABLE transactions (
2104 package character varying,
2105 distribution character varying,
2106 version character varying,
2107 action character varying,
2108 prevstate character varying,
2109 state character varying,
2110 real_user character varying,
2111 set_user character varying,
2112 "time" timestamp without time zone
2116 ALTER TABLE "kfreebsd-i386".transactions OWNER TO wbadm;
2119 -- Name: users; Type: TABLE; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
2122 CREATE TABLE users (
2123 username character varying NOT NULL,
2124 distribution character varying NOT NULL,
2125 last_seen timestamp without time zone
2129 ALTER TABLE "kfreebsd-i386".users OWNER TO wbadm;
2131 SET search_path = "kfreebsd-i386_public", pg_catalog;
2134 -- Name: packages; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2137 CREATE VIEW packages AS
2138 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM "kfreebsd-i386".packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2141 ALTER TABLE "kfreebsd-i386_public".packages OWNER TO wbadm;
2144 -- Name: pkg_history; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2147 CREATE VIEW pkg_history AS
2148 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM "kfreebsd-i386".pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2151 ALTER TABLE "kfreebsd-i386_public".pkg_history OWNER TO wbadm;
2154 -- Name: transactions; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2157 CREATE VIEW transactions AS
2158 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM "kfreebsd-i386".transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2161 ALTER TABLE "kfreebsd-i386_public".transactions OWNER TO wbadm;
2164 -- Name: users; Type: VIEW; Schema: kfreebsd-i386_public; Owner: wbadm
2167 CREATE VIEW users AS
2168 SELECT users.username, users.distribution, users.last_seen FROM "kfreebsd-i386".users WHERE ((users.distribution)::text !~~ '%-security'::text);
2171 ALTER TABLE "kfreebsd-i386_public".users OWNER TO wbadm;
2173 SET search_path = mips, pg_catalog;
2176 -- Name: packages; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2179 CREATE TABLE packages (
2180 package character varying NOT NULL,
2181 distribution character varying NOT NULL,
2182 version character varying,
2183 state character varying,
2184 section character varying,
2185 priority character varying,
2186 installed_version character varying,
2187 previous_state character varying,
2188 state_change timestamp without time zone,
2189 notes character varying,
2190 builder character varying,
2193 binary_nmu_version integer,
2194 binary_nmu_changelog character varying,
2195 failed_category character varying,
2196 permbuildpri integer,
2198 depends character varying,
2199 rel character varying,
2201 extra_depends character varying,
2202 extra_conflicts character varying
2206 ALTER TABLE mips.packages OWNER TO wbadm;
2209 -- Name: pkg_history; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2212 CREATE TABLE pkg_history (
2213 package character varying NOT NULL,
2214 distribution character varying NOT NULL,
2215 version character varying NOT NULL,
2216 "timestamp" timestamp without time zone NOT NULL,
2217 result character varying NOT NULL,
2223 ALTER TABLE mips.pkg_history OWNER TO wbadm;
2226 -- Name: transactions; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2229 CREATE TABLE transactions (
2230 package character varying,
2231 distribution character varying,
2232 version character varying,
2233 action character varying,
2234 prevstate character varying,
2235 state character varying,
2236 real_user character varying,
2237 set_user character varying,
2238 "time" timestamp without time zone
2242 ALTER TABLE mips.transactions OWNER TO wbadm;
2245 -- Name: users; Type: TABLE; Schema: mips; Owner: wbadm; Tablespace:
2248 CREATE TABLE users (
2249 username character varying NOT NULL,
2250 distribution character varying NOT NULL,
2251 last_seen timestamp without time zone
2255 ALTER TABLE mips.users OWNER TO wbadm;
2257 SET search_path = mips_public, pg_catalog;
2260 -- Name: packages; Type: VIEW; Schema: mips_public; Owner: wbadm
2263 CREATE VIEW packages AS
2264 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM mips.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2267 ALTER TABLE mips_public.packages OWNER TO wbadm;
2270 -- Name: pkg_history; Type: VIEW; Schema: mips_public; Owner: wbadm
2273 CREATE VIEW pkg_history AS
2274 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM mips.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2277 ALTER TABLE mips_public.pkg_history OWNER TO wbadm;
2280 -- Name: transactions; Type: VIEW; Schema: mips_public; Owner: wbadm
2283 CREATE VIEW transactions AS
2284 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM mips.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2287 ALTER TABLE mips_public.transactions OWNER TO wbadm;
2290 -- Name: users; Type: VIEW; Schema: mips_public; Owner: wbadm
2293 CREATE VIEW users AS
2294 SELECT users.username, users.distribution, users.last_seen FROM mips.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2297 ALTER TABLE mips_public.users OWNER TO wbadm;
2299 SET search_path = mipsel, pg_catalog;
2302 -- Name: packages; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2305 CREATE TABLE packages (
2306 package character varying NOT NULL,
2307 distribution character varying NOT NULL,
2308 version character varying,
2309 state character varying,
2310 section character varying,
2311 priority character varying,
2312 installed_version character varying,
2313 previous_state character varying,
2314 state_change timestamp without time zone,
2315 notes character varying,
2316 builder character varying,
2319 binary_nmu_version integer,
2320 binary_nmu_changelog character varying,
2321 failed_category character varying,
2322 permbuildpri integer,
2324 depends character varying,
2325 rel character varying,
2327 extra_depends character varying,
2328 extra_conflicts character varying
2332 ALTER TABLE mipsel.packages OWNER TO wbadm;
2335 -- Name: pkg_history; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2338 CREATE TABLE pkg_history (
2339 package character varying NOT NULL,
2340 distribution character varying NOT NULL,
2341 version character varying NOT NULL,
2342 "timestamp" timestamp without time zone NOT NULL,
2343 result character varying NOT NULL,
2349 ALTER TABLE mipsel.pkg_history OWNER TO wbadm;
2352 -- Name: transactions; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2355 CREATE TABLE transactions (
2356 package character varying,
2357 distribution character varying,
2358 version character varying,
2359 action character varying,
2360 prevstate character varying,
2361 state character varying,
2362 real_user character varying,
2363 set_user character varying,
2364 "time" timestamp without time zone
2368 ALTER TABLE mipsel.transactions OWNER TO wbadm;
2371 -- Name: users; Type: TABLE; Schema: mipsel; Owner: wbadm; Tablespace:
2374 CREATE TABLE users (
2375 username character varying NOT NULL,
2376 distribution character varying NOT NULL,
2377 last_seen timestamp without time zone
2381 ALTER TABLE mipsel.users OWNER TO wbadm;
2383 SET search_path = mipsel_public, pg_catalog;
2386 -- Name: packages; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2389 CREATE VIEW packages AS
2390 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM mipsel.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2393 ALTER TABLE mipsel_public.packages OWNER TO wbadm;
2396 -- Name: pkg_history; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2399 CREATE VIEW pkg_history AS
2400 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM mipsel.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2403 ALTER TABLE mipsel_public.pkg_history OWNER TO wbadm;
2406 -- Name: transactions; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2409 CREATE VIEW transactions AS
2410 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM mipsel.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2413 ALTER TABLE mipsel_public.transactions OWNER TO wbadm;
2416 -- Name: users; Type: VIEW; Schema: mipsel_public; Owner: wbadm
2419 CREATE VIEW users AS
2420 SELECT users.username, users.distribution, users.last_seen FROM mipsel.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2423 ALTER TABLE mipsel_public.users OWNER TO wbadm;
2425 SET search_path = powerpc, pg_catalog;
2428 -- Name: packages; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2431 CREATE TABLE packages (
2432 package character varying NOT NULL,
2433 distribution character varying NOT NULL,
2434 version character varying,
2435 state character varying,
2436 section character varying,
2437 priority character varying,
2438 installed_version character varying,
2439 previous_state character varying,
2440 state_change timestamp without time zone,
2441 notes character varying,
2442 builder character varying,
2445 binary_nmu_version integer,
2446 binary_nmu_changelog character varying,
2447 failed_category character varying,
2448 permbuildpri integer,
2450 depends character varying,
2451 rel character varying,
2453 extra_depends character varying,
2454 extra_conflicts character varying
2458 ALTER TABLE powerpc.packages OWNER TO wbadm;
2461 -- Name: pkg_history; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2464 CREATE TABLE pkg_history (
2465 package character varying NOT NULL,
2466 distribution character varying NOT NULL,
2467 version character varying NOT NULL,
2468 "timestamp" timestamp without time zone NOT NULL,
2469 result character varying NOT NULL,
2475 ALTER TABLE powerpc.pkg_history OWNER TO wbadm;
2478 -- Name: transactions; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2481 CREATE TABLE transactions (
2482 package character varying,
2483 distribution character varying,
2484 version character varying,
2485 action character varying,
2486 prevstate character varying,
2487 state character varying,
2488 real_user character varying,
2489 set_user character varying,
2490 "time" timestamp without time zone
2494 ALTER TABLE powerpc.transactions OWNER TO wbadm;
2497 -- Name: users; Type: TABLE; Schema: powerpc; Owner: wbadm; Tablespace:
2500 CREATE TABLE users (
2501 username character varying NOT NULL,
2502 distribution character varying NOT NULL,
2503 last_seen timestamp without time zone
2507 ALTER TABLE powerpc.users OWNER TO wbadm;
2509 SET search_path = powerpc_public, pg_catalog;
2512 -- Name: packages; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2515 CREATE VIEW packages AS
2516 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM powerpc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2519 ALTER TABLE powerpc_public.packages OWNER TO wbadm;
2522 -- Name: pkg_history; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2525 CREATE VIEW pkg_history AS
2526 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM powerpc.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2529 ALTER TABLE powerpc_public.pkg_history OWNER TO wbadm;
2532 -- Name: transactions; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2535 CREATE VIEW transactions AS
2536 SELECT transactions.package, transactions.distribution, transactions.version, transactions.action, transactions.prevstate, transactions.state, transactions.real_user, transactions.set_user, transactions."time" FROM powerpc.transactions WHERE ((transactions.distribution)::text !~~ '%-security'::text);
2539 ALTER TABLE powerpc_public.transactions OWNER TO wbadm;
2542 -- Name: users; Type: VIEW; Schema: powerpc_public; Owner: wbadm
2545 CREATE VIEW users AS
2546 SELECT users.username, users.distribution, users.last_seen FROM powerpc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2549 ALTER TABLE powerpc_public.users OWNER TO wbadm;
2551 SET search_path = public, pg_catalog;
2554 -- Name: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2557 CREATE TABLE distribution_aliases (
2558 alias character varying NOT NULL,
2559 distribution character varying NOT NULL
2563 ALTER TABLE public.distribution_aliases OWNER TO wbadm;
2565 SET search_path = s390, pg_catalog;
2568 -- Name: packages; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2571 CREATE TABLE packages (
2572 package character varying NOT NULL,
2573 distribution character varying NOT NULL,
2574 version character varying,
2575 state character varying,
2576 section character varying,
2577 priority character varying,
2578 installed_version character varying,
2579 previous_state character varying,
2580 state_change timestamp without time zone,
2581 notes character varying,
2582 builder character varying,
2585 binary_nmu_version integer,
2586 binary_nmu_changelog character varying,
2587 failed_category character varying,
2588 permbuildpri integer,
2590 depends character varying,
2591 rel character varying,
2593 extra_depends character varying,
2594 extra_conflicts character varying
2598 ALTER TABLE s390.packages OWNER TO wbadm;
2600 SET search_path = sparc, pg_catalog;
2603 -- Name: packages; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2606 CREATE TABLE packages (
2607 package character varying NOT NULL,
2608 distribution character varying NOT NULL,
2609 version character varying,
2610 state character varying,
2611 section character varying,
2612 priority character varying,
2613 installed_version character varying,
2614 previous_state character varying,
2615 state_change timestamp without time zone,
2616 notes character varying,
2617 builder character varying,
2620 binary_nmu_version integer,
2621 binary_nmu_changelog character varying,
2622 failed_category character varying,
2623 permbuildpri integer,
2625 depends character varying,
2626 rel character varying,
2628 extra_depends character varying,
2629 extra_conflicts character varying
2633 ALTER TABLE sparc.packages OWNER TO wbadm;
2635 SET search_path = public, pg_catalog;
2638 -- Name: distribution_architectures; Type: VIEW; Schema: public; Owner: wbadm
2641 CREATE VIEW distribution_architectures AS
2642 (((((((((((((SELECT DISTINCT packages.distribution, 'alpha'::character varying AS architecture FROM alpha.packages UNION SELECT DISTINCT packages.distribution, 'amd64'::character varying AS architecture FROM amd64.packages) UNION SELECT DISTINCT packages.distribution, 'arm'::character varying AS architecture FROM arm.packages) UNION SELECT DISTINCT packages.distribution, 'armel'::character varying AS architecture FROM armel.packages) UNION SELECT DISTINCT packages.distribution, 'hppa'::character varying AS architecture FROM hppa.packages) UNION SELECT DISTINCT packages.distribution, 'hurd-i386'::character varying AS architecture FROM "hurd-i386".packages) UNION SELECT DISTINCT packages.distribution, 'i386'::character varying AS architecture FROM i386.packages) UNION SELECT DISTINCT packages.distribution, 'ia64'::character varying AS architecture FROM ia64.packages) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-amd64'::character varying AS architecture FROM "kfreebsd-amd64".packages) UNION SELECT DISTINCT packages.distribution, 'kfreebsd-i386'::character varying AS architecture FROM "kfreebsd-i386".packages) UNION SELECT DISTINCT packages.distribution, 'mips'::character varying AS architecture FROM mips.packages) UNION SELECT DISTINCT packages.distribution, 'mipsel'::character varying AS architecture FROM mipsel.packages) UNION SELECT DISTINCT packages.distribution, 'powerpc'::character varying AS architecture FROM powerpc.packages) UNION SELECT DISTINCT packages.distribution, 's390'::character varying AS architecture FROM s390.packages) UNION SELECT DISTINCT packages.distribution, 'sparc'::character varying AS architecture FROM sparc.packages;
2645 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2648 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2651 CREATE TABLE distributions (
2652 distribution character varying NOT NULL,
2653 public boolean DEFAULT true NOT NULL,
2654 sort_order integer DEFAULT 0,
2655 auto_dep_wait boolean DEFAULT true
2659 ALTER TABLE public.distributions OWNER TO wbadm;
2661 SET search_path = s390, pg_catalog;
2664 -- Name: pkg_history; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2667 CREATE TABLE pkg_history (
2668 package character varying NOT NULL,
2669 distribution character varying NOT NULL,
2670 version character varying NOT NULL,
2671 "timestamp" timestamp without time zone NOT NULL,
2672 result character varying NOT NULL,
2678 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2680 SET search_path = s390_public, pg_catalog;
2683 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2686 CREATE VIEW pkg_history AS
2687 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);
2690 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2692 SET search_path = sparc, pg_catalog;
2695 -- Name: pkg_history; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2698 CREATE TABLE pkg_history (
2699 package character varying NOT NULL,
2700 distribution character varying NOT NULL,
2701 version character varying NOT NULL,
2702 "timestamp" timestamp without time zone NOT NULL,
2703 result character varying NOT NULL,
2709 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2711 SET search_path = sparc_public, pg_catalog;
2714 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2717 CREATE VIEW pkg_history AS
2718 SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, pkg_history.build_time, pkg_history.disk_space FROM sparc.pkg_history WHERE ((pkg_history.distribution)::text !~~ '%-security'::text);
2721 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2723 SET search_path = public, pg_catalog;
2726 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2729 CREATE VIEW lastlog AS
2730 ((((((((((((((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;
2733 ALTER TABLE public.lastlog OWNER TO wbadm;
2736 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2740 (((((((((((((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;
2743 ALTER TABLE public.log OWNER TO wbadm;
2746 -- Name: log_v2; Type: VIEW; Schema: public; Owner: pkern
2749 CREATE VIEW log_v2 AS
2750 (((((((((((((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;
2753 ALTER TABLE public.log_v2 OWNER TO pkern;
2755 SET search_path = s390_public, pg_catalog;
2758 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2761 CREATE VIEW packages AS
2762 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM s390.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2765 ALTER TABLE s390_public.packages OWNER TO wbadm;
2767 SET search_path = sparc_public, pg_catalog;
2770 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2773 CREATE VIEW packages AS
2774 SELECT packages.package, packages.distribution, packages.version, packages.state, packages.section, packages.priority, packages.installed_version, packages.previous_state, packages.state_change, packages.notes, packages.builder, packages.failed, packages.old_failed, packages.binary_nmu_version, packages.binary_nmu_changelog, packages.failed_category, packages.permbuildpri, packages.buildpri, packages.depends, packages.rel, packages.bd_problem, packages.extra_depends, packages.extra_conflicts FROM sparc.packages WHERE ((packages.distribution)::text !~~ '%-security'::text);
2777 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2779 SET search_path = public, pg_catalog;
2782 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2785 CREATE VIEW packages_all AS
2786 (((((((((((((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;
2789 ALTER TABLE public.packages_all OWNER TO wbadm;
2791 SET search_path = s390, pg_catalog;
2794 -- Name: transactions; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2797 CREATE TABLE transactions (
2798 package character varying,
2799 distribution character varying,
2800 version character varying,
2801 action character varying,
2802 prevstate character varying,
2803 state character varying,
2804 real_user character varying,
2805 set_user character varying,
2806 "time" timestamp without time zone
2810 ALTER TABLE s390.transactions OWNER TO wbadm;
2813 -- Name: users; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2816 CREATE TABLE users (
2817 username character varying NOT NULL,
2818 distribution character varying NOT NULL,
2819 last_seen timestamp without time zone
2823 ALTER TABLE s390.users OWNER TO wbadm;
2825 SET search_path = s390_public, pg_catalog;
2828 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2831 CREATE VIEW transactions AS
2832 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);
2835 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2838 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2841 CREATE VIEW users AS
2842 SELECT users.username, users.distribution, users.last_seen FROM s390.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2845 ALTER TABLE s390_public.users OWNER TO wbadm;
2847 SET search_path = sparc, pg_catalog;
2850 -- Name: transactions; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2853 CREATE TABLE transactions (
2854 package character varying,
2855 distribution character varying,
2856 version character varying,
2857 action character varying,
2858 prevstate character varying,
2859 state character varying,
2860 real_user character varying,
2861 set_user character varying,
2862 "time" timestamp without time zone
2866 ALTER TABLE sparc.transactions OWNER TO wbadm;
2869 -- Name: users; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2872 CREATE TABLE users (
2873 username character varying NOT NULL,
2874 distribution character varying NOT NULL,
2875 last_seen timestamp without time zone
2879 ALTER TABLE sparc.users OWNER TO wbadm;
2881 SET search_path = sparc_public, pg_catalog;
2884 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2887 CREATE VIEW transactions AS
2888 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);
2891 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2894 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2897 CREATE VIEW users AS
2898 SELECT users.username, users.distribution, users.last_seen FROM sparc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2901 ALTER TABLE sparc_public.users OWNER TO wbadm;
2903 SET search_path = alpha, pg_catalog;
2906 -- Name: packages_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2909 ALTER TABLE ONLY packages
2910 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2914 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2917 ALTER TABLE ONLY pkg_history
2918 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2922 -- Name: users_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2925 ALTER TABLE ONLY users
2926 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2929 SET search_path = amd64, pg_catalog;
2932 -- Name: packages_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2935 ALTER TABLE ONLY packages
2936 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2940 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2943 ALTER TABLE ONLY pkg_history
2944 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2948 -- Name: users_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2951 ALTER TABLE ONLY users
2952 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2955 SET search_path = arm, pg_catalog;
2958 -- Name: packages_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2961 ALTER TABLE ONLY packages
2962 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2966 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2969 ALTER TABLE ONLY pkg_history
2970 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2974 -- Name: users_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2977 ALTER TABLE ONLY users
2978 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2981 SET search_path = armel, pg_catalog;
2984 -- Name: packages_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
2987 ALTER TABLE ONLY packages
2988 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2992 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
2995 ALTER TABLE ONLY pkg_history
2996 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3000 -- Name: users_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3003 ALTER TABLE ONLY users
3004 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3007 SET search_path = hppa, pg_catalog;
3010 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3013 ALTER TABLE ONLY packages
3014 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3018 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3021 ALTER TABLE ONLY pkg_history
3022 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3026 -- Name: users_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3029 ALTER TABLE ONLY users
3030 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3033 SET search_path = "hurd-i386", pg_catalog;
3036 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3039 ALTER TABLE ONLY packages
3040 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3044 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3047 ALTER TABLE ONLY pkg_history
3048 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3052 -- Name: users_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3055 ALTER TABLE ONLY users
3056 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3059 SET search_path = i386, pg_catalog;
3062 -- Name: packages_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3065 ALTER TABLE ONLY packages
3066 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3070 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3073 ALTER TABLE ONLY pkg_history
3074 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3078 -- Name: users_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3081 ALTER TABLE ONLY users
3082 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3085 SET search_path = ia64, pg_catalog;
3088 -- Name: packages_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3091 ALTER TABLE ONLY packages
3092 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3096 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3099 ALTER TABLE ONLY pkg_history
3100 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3104 -- Name: users_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3107 ALTER TABLE ONLY users
3108 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3111 SET search_path = "kfreebsd-amd64", pg_catalog;
3114 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3117 ALTER TABLE ONLY packages
3118 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3122 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3125 ALTER TABLE ONLY pkg_history
3126 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3130 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3133 ALTER TABLE ONLY users
3134 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3137 SET search_path = "kfreebsd-i386", pg_catalog;
3140 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3143 ALTER TABLE ONLY packages
3144 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3148 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3151 ALTER TABLE ONLY pkg_history
3152 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3156 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3159 ALTER TABLE ONLY users
3160 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3163 SET search_path = mips, pg_catalog;
3166 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3169 ALTER TABLE ONLY packages
3170 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3174 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3177 ALTER TABLE ONLY pkg_history
3178 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3182 -- Name: users_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3185 ALTER TABLE ONLY users
3186 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3189 SET search_path = mipsel, pg_catalog;
3192 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3195 ALTER TABLE ONLY packages
3196 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3200 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3203 ALTER TABLE ONLY pkg_history
3204 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3208 -- Name: users_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3211 ALTER TABLE ONLY users
3212 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3215 SET search_path = powerpc, pg_catalog;
3218 -- Name: packages_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3221 ALTER TABLE ONLY packages
3222 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3226 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3229 ALTER TABLE ONLY pkg_history
3230 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3234 -- Name: users_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3237 ALTER TABLE ONLY users
3238 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3241 SET search_path = public, pg_catalog;
3244 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
3247 ALTER TABLE ONLY distribution_aliases
3248 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
3251 SET search_path = s390, pg_catalog;
3254 -- Name: packages_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3257 ALTER TABLE ONLY packages
3258 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3262 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3265 ALTER TABLE ONLY pkg_history
3266 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3270 -- Name: users_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3273 ALTER TABLE ONLY users
3274 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3277 SET search_path = sparc, pg_catalog;
3280 -- Name: packages_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3283 ALTER TABLE ONLY packages
3284 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3288 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3291 ALTER TABLE ONLY pkg_history
3292 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3296 -- Name: users_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3299 ALTER TABLE ONLY users
3300 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3303 SET search_path = alpha, pg_catalog;
3306 -- Name: idx_alpha_state; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3309 CREATE INDEX idx_alpha_state ON packages USING btree (state);
3313 -- Name: pkg_history_distribution; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3316 CREATE INDEX pkg_history_distribution ON pkg_history USING hash (distribution);
3320 -- Name: pkg_history_index; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3323 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3327 -- Name: pkg_history_timestamp; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3330 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3333 SET search_path = amd64, pg_catalog;
3336 -- Name: idx_amd64_state; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3339 CREATE INDEX idx_amd64_state ON packages USING btree (state);
3343 -- Name: pkg_history_index; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3346 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3350 -- Name: pkg_history_timestamp; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3353 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3356 SET search_path = arm, pg_catalog;
3359 -- Name: idx_arm_state; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3362 CREATE INDEX idx_arm_state ON packages USING btree (state);
3366 -- Name: pkg_history_index; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3369 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3373 -- Name: pkg_history_timestamp; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3376 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3379 SET search_path = armel, pg_catalog;
3382 -- Name: idx_armel_state; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3385 CREATE INDEX idx_armel_state ON packages USING btree (state);
3389 -- Name: pkg_history_index; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3392 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3396 -- Name: pkg_history_timestamp; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3399 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3402 SET search_path = hppa, pg_catalog;
3405 -- Name: idx_hppa_state; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3408 CREATE INDEX idx_hppa_state ON packages USING btree (state);
3412 -- Name: pkg_history_index; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3415 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3419 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3422 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3425 SET search_path = "hurd-i386", pg_catalog;
3428 -- Name: idx_hurd-i386_state; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3431 CREATE INDEX "idx_hurd-i386_state" ON packages USING btree (state);
3435 -- Name: pkg_history_index; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3438 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3442 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3445 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3448 SET search_path = i386, pg_catalog;
3451 -- Name: idx_i386_state; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3454 CREATE INDEX idx_i386_state ON packages USING btree (state);
3458 -- Name: pkg_history_index; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3461 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3465 -- Name: pkg_history_timestamp; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3468 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3471 SET search_path = ia64, pg_catalog;
3474 -- Name: idx_ia64_state; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3477 CREATE INDEX idx_ia64_state ON packages USING btree (state);
3481 -- Name: pkg_history_index; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3484 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3488 -- Name: pkg_history_timestamp; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3491 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3494 SET search_path = "kfreebsd-amd64", pg_catalog;
3497 -- Name: idx_kfreebsd-amd64_state; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3500 CREATE INDEX "idx_kfreebsd-amd64_state" ON packages USING btree (state);
3504 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3507 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3511 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3514 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3517 SET search_path = "kfreebsd-i386", pg_catalog;
3520 -- Name: idx_kfreebsd-i386_state; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3523 CREATE INDEX "idx_kfreebsd-i386_state" ON packages USING btree (state);
3527 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3530 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3534 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3537 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3540 SET search_path = mips, pg_catalog;
3543 -- Name: idx_mips_state; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3546 CREATE INDEX idx_mips_state ON packages USING btree (state);
3550 -- Name: pkg_history_index; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3553 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3557 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3560 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3563 SET search_path = mipsel, pg_catalog;
3566 -- Name: idx_mipsel_state; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3569 CREATE INDEX idx_mipsel_state ON packages USING btree (state);
3573 -- Name: pkg_history_index; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3576 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3580 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3583 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3586 SET search_path = powerpc, pg_catalog;
3589 -- Name: idx_powerpc_state; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3592 CREATE INDEX idx_powerpc_state ON packages USING btree (state);
3596 -- Name: pkg_history_index; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3599 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3603 -- Name: pkg_history_timestamp; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3606 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3609 SET search_path = public, pg_catalog;
3612 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3615 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
3619 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3622 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
3625 SET search_path = s390, pg_catalog;
3628 -- Name: idx_s390_state; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3631 CREATE INDEX idx_s390_state ON packages USING btree (state);
3635 -- Name: pkg_history_index; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3638 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3642 -- Name: pkg_history_timestamp; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3645 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3648 SET search_path = sparc, pg_catalog;
3651 -- Name: idx_sparc_state; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3654 CREATE INDEX idx_sparc_state ON packages USING btree (state);
3658 -- Name: pkg_history_index; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3661 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3665 -- Name: pkg_history_timestamp; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3668 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3671 SET search_path = alpha, pg_catalog;
3674 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3677 ALTER TABLE ONLY packages
3678 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3682 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3685 ALTER TABLE ONLY pkg_history
3686 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3690 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3693 ALTER TABLE ONLY users
3694 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3697 SET search_path = amd64, pg_catalog;
3700 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3703 ALTER TABLE ONLY packages
3704 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3708 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3711 ALTER TABLE ONLY pkg_history
3712 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3716 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3719 ALTER TABLE ONLY users
3720 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3723 SET search_path = arm, pg_catalog;
3726 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3729 ALTER TABLE ONLY packages
3730 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3734 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3737 ALTER TABLE ONLY pkg_history
3738 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3742 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3745 ALTER TABLE ONLY users
3746 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3749 SET search_path = armel, pg_catalog;
3752 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3755 ALTER TABLE ONLY packages
3756 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3760 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3763 ALTER TABLE ONLY pkg_history
3764 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3768 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3771 ALTER TABLE ONLY users
3772 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3775 SET search_path = hppa, pg_catalog;
3778 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3781 ALTER TABLE ONLY packages
3782 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3786 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3789 ALTER TABLE ONLY pkg_history
3790 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3794 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3797 ALTER TABLE ONLY users
3798 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3801 SET search_path = "hurd-i386", pg_catalog;
3804 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3807 ALTER TABLE ONLY packages
3808 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3812 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3815 ALTER TABLE ONLY pkg_history
3816 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3820 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3823 ALTER TABLE ONLY users
3824 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3827 SET search_path = i386, pg_catalog;
3830 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3833 ALTER TABLE ONLY packages
3834 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3838 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3841 ALTER TABLE ONLY pkg_history
3842 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3846 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3849 ALTER TABLE ONLY users
3850 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3853 SET search_path = ia64, pg_catalog;
3856 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3859 ALTER TABLE ONLY packages
3860 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3864 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3867 ALTER TABLE ONLY pkg_history
3868 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3872 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3875 ALTER TABLE ONLY users
3876 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3879 SET search_path = "kfreebsd-amd64", pg_catalog;
3882 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3885 ALTER TABLE ONLY packages
3886 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3890 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3893 ALTER TABLE ONLY pkg_history
3894 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3898 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3901 ALTER TABLE ONLY users
3902 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3905 SET search_path = "kfreebsd-i386", pg_catalog;
3908 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3911 ALTER TABLE ONLY packages
3912 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3916 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3919 ALTER TABLE ONLY pkg_history
3920 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3924 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3927 ALTER TABLE ONLY users
3928 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3931 SET search_path = mips, pg_catalog;
3934 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3937 ALTER TABLE ONLY packages
3938 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3942 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3945 ALTER TABLE ONLY pkg_history
3946 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3950 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3953 ALTER TABLE ONLY users
3954 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3957 SET search_path = mipsel, pg_catalog;
3960 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3963 ALTER TABLE ONLY packages
3964 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3968 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3971 ALTER TABLE ONLY pkg_history
3972 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3976 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3979 ALTER TABLE ONLY users
3980 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3983 SET search_path = powerpc, pg_catalog;
3986 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
3989 ALTER TABLE ONLY packages
3990 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3994 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
3997 ALTER TABLE ONLY pkg_history
3998 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4002 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4005 ALTER TABLE ONLY users
4006 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4009 SET search_path = public, pg_catalog;
4012 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
4015 ALTER TABLE ONLY distribution_aliases
4016 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
4019 SET search_path = s390, pg_catalog;
4022 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4025 ALTER TABLE ONLY packages
4026 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4030 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4033 ALTER TABLE ONLY pkg_history
4034 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4038 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4041 ALTER TABLE ONLY users
4042 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4045 SET search_path = sparc, pg_catalog;
4048 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4051 ALTER TABLE ONLY packages
4052 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4056 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4059 ALTER TABLE ONLY pkg_history
4060 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4064 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4067 ALTER TABLE ONLY users
4068 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4072 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
4075 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
4076 REVOKE ALL ON SCHEMA alpha FROM wbadm;
4077 GRANT ALL ON SCHEMA alpha TO wbadm;
4078 GRANT USAGE ON SCHEMA alpha TO alpha;
4079 GRANT USAGE ON SCHEMA alpha TO wb_all;
4080 GRANT USAGE ON SCHEMA alpha TO wb_security;
4084 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
4087 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
4088 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
4089 GRANT ALL ON SCHEMA alpha_public TO wbadm;
4090 GRANT USAGE ON SCHEMA alpha_public TO alpha;
4091 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
4095 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
4098 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
4099 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
4100 GRANT ALL ON SCHEMA amd64 TO wbadm;
4101 GRANT USAGE ON SCHEMA amd64 TO amd64;
4102 GRANT USAGE ON SCHEMA amd64 TO wb_all;
4103 GRANT USAGE ON SCHEMA amd64 TO wb_security;
4107 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
4110 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
4111 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
4112 GRANT ALL ON SCHEMA amd64_public TO wbadm;
4113 GRANT USAGE ON SCHEMA amd64_public TO amd64;
4114 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
4118 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
4121 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
4122 REVOKE ALL ON SCHEMA arm FROM wbadm;
4123 GRANT ALL ON SCHEMA arm TO wbadm;
4124 GRANT USAGE ON SCHEMA arm TO arm;
4125 GRANT USAGE ON SCHEMA arm TO wb_all;
4126 GRANT USAGE ON SCHEMA arm TO wb_security;
4130 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
4133 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
4134 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
4135 GRANT ALL ON SCHEMA arm_public TO wbadm;
4136 GRANT USAGE ON SCHEMA arm_public TO arm;
4137 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
4141 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
4144 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
4145 REVOKE ALL ON SCHEMA armel FROM wbadm;
4146 GRANT ALL ON SCHEMA armel TO wbadm;
4147 GRANT USAGE ON SCHEMA armel TO armel;
4148 GRANT USAGE ON SCHEMA armel TO wb_all;
4149 GRANT USAGE ON SCHEMA armel TO wb_security;
4153 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
4156 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
4157 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
4158 GRANT ALL ON SCHEMA armel_public TO wbadm;
4159 GRANT USAGE ON SCHEMA armel_public TO armel;
4160 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
4164 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4167 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4168 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4169 GRANT ALL ON SCHEMA hppa TO wbadm;
4170 GRANT USAGE ON SCHEMA hppa TO hppa;
4171 GRANT USAGE ON SCHEMA hppa TO wb_all;
4172 GRANT USAGE ON SCHEMA hppa TO wb_security;
4176 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4179 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4180 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4181 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4182 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4183 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4187 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4190 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4191 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4192 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4193 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4194 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4195 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4199 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4202 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4203 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4204 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4205 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4206 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4210 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4213 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4214 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4215 GRANT ALL ON SCHEMA i386 TO wbadm;
4216 GRANT USAGE ON SCHEMA i386 TO i386;
4217 GRANT USAGE ON SCHEMA i386 TO wb_all;
4218 GRANT USAGE ON SCHEMA i386 TO wb_security;
4222 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4225 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4226 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4227 GRANT ALL ON SCHEMA i386_public TO wbadm;
4228 GRANT USAGE ON SCHEMA i386_public TO i386;
4229 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4233 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4236 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4237 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4238 GRANT ALL ON SCHEMA ia64 TO wbadm;
4239 GRANT USAGE ON SCHEMA ia64 TO ia64;
4240 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4241 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4245 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4248 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4249 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4250 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4251 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4252 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4256 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4259 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4260 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4261 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4262 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4263 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4264 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4268 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4271 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4272 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4273 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4274 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4275 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4279 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4282 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4283 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4284 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4285 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4286 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4287 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4291 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4294 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4295 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4296 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4297 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4298 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4302 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4305 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4306 REVOKE ALL ON SCHEMA mips FROM wbadm;
4307 GRANT ALL ON SCHEMA mips TO wbadm;
4308 GRANT USAGE ON SCHEMA mips TO mips;
4309 GRANT USAGE ON SCHEMA mips TO wb_all;
4310 GRANT USAGE ON SCHEMA mips TO wb_security;
4314 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4317 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4318 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4319 GRANT ALL ON SCHEMA mips_public TO wbadm;
4320 GRANT USAGE ON SCHEMA mips_public TO mips;
4321 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4325 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4328 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4329 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4330 GRANT ALL ON SCHEMA mipsel TO wbadm;
4331 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4332 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4333 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4337 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4340 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4341 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4342 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4343 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4344 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4348 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4351 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4352 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4353 GRANT ALL ON SCHEMA powerpc TO wbadm;
4354 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4355 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4356 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4360 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4363 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4364 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4365 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4366 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4367 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4371 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4374 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4375 REVOKE ALL ON SCHEMA public FROM postgres;
4376 GRANT ALL ON SCHEMA public TO postgres;
4377 GRANT ALL ON SCHEMA public TO PUBLIC;
4381 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4384 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4385 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4386 GRANT ALL ON SCHEMA s390 TO wbadm;
4387 GRANT USAGE ON SCHEMA s390 TO s390;
4388 GRANT USAGE ON SCHEMA s390 TO wb_all;
4389 GRANT USAGE ON SCHEMA s390 TO wb_security;
4393 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4396 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4397 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4398 GRANT ALL ON SCHEMA s390_public TO wbadm;
4399 GRANT USAGE ON SCHEMA s390_public TO s390;
4400 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4404 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4407 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4408 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4409 GRANT ALL ON SCHEMA sparc TO wbadm;
4410 GRANT USAGE ON SCHEMA sparc TO sparc;
4411 GRANT USAGE ON SCHEMA sparc TO wb_all;
4412 GRANT USAGE ON SCHEMA sparc TO wb_security;
4416 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4419 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4420 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4421 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4422 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4423 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4426 SET search_path = alpha, pg_catalog;
4429 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4432 REVOKE ALL ON TABLE packages FROM PUBLIC;
4433 REVOKE ALL ON TABLE packages FROM wbadm;
4434 GRANT ALL ON TABLE packages TO wbadm;
4435 GRANT ALL ON TABLE packages TO alpha;
4436 GRANT SELECT ON TABLE packages TO wb_security;
4440 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4443 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4444 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4445 GRANT ALL ON TABLE pkg_history TO wbadm;
4446 GRANT ALL ON TABLE pkg_history TO alpha;
4447 GRANT SELECT ON TABLE pkg_history TO wb_security;
4451 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4454 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4455 REVOKE ALL ON TABLE transactions FROM wbadm;
4456 GRANT ALL ON TABLE transactions TO wbadm;
4457 GRANT SELECT,INSERT ON TABLE transactions TO alpha;
4458 GRANT SELECT ON TABLE transactions TO wb_security;
4462 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4465 REVOKE ALL ON TABLE users FROM PUBLIC;
4466 REVOKE ALL ON TABLE users FROM wbadm;
4467 GRANT ALL ON TABLE users TO wbadm;
4468 GRANT ALL ON TABLE users TO alpha;
4471 SET search_path = alpha_public, pg_catalog;
4474 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4477 REVOKE ALL ON TABLE packages FROM PUBLIC;
4478 REVOKE ALL ON TABLE packages FROM wbadm;
4479 GRANT ALL ON TABLE packages TO wbadm;
4480 GRANT SELECT ON TABLE packages TO PUBLIC;
4484 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4487 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4488 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4489 GRANT ALL ON TABLE pkg_history TO wbadm;
4490 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4494 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4497 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4498 REVOKE ALL ON TABLE transactions FROM wbadm;
4499 GRANT ALL ON TABLE transactions TO wbadm;
4500 GRANT SELECT ON TABLE transactions TO PUBLIC;
4504 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4507 REVOKE ALL ON TABLE users FROM PUBLIC;
4508 REVOKE ALL ON TABLE users FROM wbadm;
4509 GRANT ALL ON TABLE users TO wbadm;
4510 GRANT SELECT ON TABLE users TO PUBLIC;
4513 SET search_path = amd64, pg_catalog;
4516 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4519 REVOKE ALL ON TABLE packages FROM PUBLIC;
4520 REVOKE ALL ON TABLE packages FROM wbadm;
4521 GRANT ALL ON TABLE packages TO wbadm;
4522 GRANT ALL ON TABLE packages TO amd64;
4523 GRANT SELECT ON TABLE packages TO wb_security;
4527 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4530 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4531 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4532 GRANT ALL ON TABLE pkg_history TO wbadm;
4533 GRANT ALL ON TABLE pkg_history TO amd64;
4534 GRANT SELECT ON TABLE pkg_history TO wb_security;
4538 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4541 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4542 REVOKE ALL ON TABLE transactions FROM wbadm;
4543 GRANT ALL ON TABLE transactions TO wbadm;
4544 GRANT SELECT,INSERT ON TABLE transactions TO amd64;
4545 GRANT SELECT ON TABLE transactions TO wb_security;
4549 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4552 REVOKE ALL ON TABLE users FROM PUBLIC;
4553 REVOKE ALL ON TABLE users FROM wbadm;
4554 GRANT ALL ON TABLE users TO wbadm;
4555 GRANT ALL ON TABLE users TO amd64;
4558 SET search_path = amd64_public, pg_catalog;
4561 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4564 REVOKE ALL ON TABLE packages FROM PUBLIC;
4565 REVOKE ALL ON TABLE packages FROM wbadm;
4566 GRANT ALL ON TABLE packages TO wbadm;
4567 GRANT SELECT ON TABLE packages TO PUBLIC;
4571 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4574 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4575 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4576 GRANT ALL ON TABLE pkg_history TO wbadm;
4577 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4581 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4584 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4585 REVOKE ALL ON TABLE transactions FROM wbadm;
4586 GRANT ALL ON TABLE transactions TO wbadm;
4587 GRANT SELECT ON TABLE transactions TO PUBLIC;
4591 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4594 REVOKE ALL ON TABLE users FROM PUBLIC;
4595 REVOKE ALL ON TABLE users FROM wbadm;
4596 GRANT ALL ON TABLE users TO wbadm;
4597 GRANT SELECT ON TABLE users TO PUBLIC;
4600 SET search_path = arm, pg_catalog;
4603 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4606 REVOKE ALL ON TABLE packages FROM PUBLIC;
4607 REVOKE ALL ON TABLE packages FROM wbadm;
4608 GRANT ALL ON TABLE packages TO wbadm;
4609 GRANT ALL ON TABLE packages TO arm;
4610 GRANT SELECT ON TABLE packages TO wb_security;
4614 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4617 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4618 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4619 GRANT ALL ON TABLE pkg_history TO wbadm;
4620 GRANT ALL ON TABLE pkg_history TO arm;
4621 GRANT SELECT ON TABLE pkg_history TO wb_security;
4625 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4628 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4629 REVOKE ALL ON TABLE transactions FROM wbadm;
4630 GRANT ALL ON TABLE transactions TO wbadm;
4631 GRANT SELECT,INSERT ON TABLE transactions TO arm;
4632 GRANT SELECT ON TABLE transactions TO wb_security;
4636 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4639 REVOKE ALL ON TABLE users FROM PUBLIC;
4640 REVOKE ALL ON TABLE users FROM wbadm;
4641 GRANT ALL ON TABLE users TO wbadm;
4642 GRANT ALL ON TABLE users TO arm;
4645 SET search_path = arm_public, pg_catalog;
4648 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4651 REVOKE ALL ON TABLE packages FROM PUBLIC;
4652 REVOKE ALL ON TABLE packages FROM wbadm;
4653 GRANT ALL ON TABLE packages TO wbadm;
4654 GRANT SELECT ON TABLE packages TO PUBLIC;
4658 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4661 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4662 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4663 GRANT ALL ON TABLE pkg_history TO wbadm;
4664 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4668 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4671 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4672 REVOKE ALL ON TABLE transactions FROM wbadm;
4673 GRANT ALL ON TABLE transactions TO wbadm;
4674 GRANT SELECT ON TABLE transactions TO PUBLIC;
4678 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4681 REVOKE ALL ON TABLE users FROM PUBLIC;
4682 REVOKE ALL ON TABLE users FROM wbadm;
4683 GRANT ALL ON TABLE users TO wbadm;
4684 GRANT SELECT ON TABLE users TO PUBLIC;
4687 SET search_path = armel, pg_catalog;
4690 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4693 REVOKE ALL ON TABLE packages FROM PUBLIC;
4694 REVOKE ALL ON TABLE packages FROM wbadm;
4695 GRANT ALL ON TABLE packages TO wbadm;
4696 GRANT ALL ON TABLE packages TO armel;
4697 GRANT SELECT ON TABLE packages TO wb_security;
4701 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4704 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4705 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4706 GRANT ALL ON TABLE pkg_history TO wbadm;
4707 GRANT ALL ON TABLE pkg_history TO armel;
4708 GRANT SELECT ON TABLE pkg_history TO wb_security;
4712 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4715 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4716 REVOKE ALL ON TABLE transactions FROM wbadm;
4717 GRANT ALL ON TABLE transactions TO wbadm;
4718 GRANT SELECT,INSERT ON TABLE transactions TO armel;
4719 GRANT SELECT ON TABLE transactions TO wb_security;
4723 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4726 REVOKE ALL ON TABLE users FROM PUBLIC;
4727 REVOKE ALL ON TABLE users FROM wbadm;
4728 GRANT ALL ON TABLE users TO wbadm;
4729 GRANT ALL ON TABLE users TO armel;
4732 SET search_path = armel_public, pg_catalog;
4735 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4738 REVOKE ALL ON TABLE packages FROM PUBLIC;
4739 REVOKE ALL ON TABLE packages FROM wbadm;
4740 GRANT ALL ON TABLE packages TO wbadm;
4741 GRANT SELECT ON TABLE packages TO PUBLIC;
4745 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4748 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4749 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4750 GRANT ALL ON TABLE pkg_history TO wbadm;
4751 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4755 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4758 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4759 REVOKE ALL ON TABLE transactions FROM wbadm;
4760 GRANT ALL ON TABLE transactions TO wbadm;
4761 GRANT SELECT ON TABLE transactions TO PUBLIC;
4765 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4768 REVOKE ALL ON TABLE users FROM PUBLIC;
4769 REVOKE ALL ON TABLE users FROM wbadm;
4770 GRANT ALL ON TABLE users TO wbadm;
4771 GRANT SELECT ON TABLE users TO PUBLIC;
4774 SET search_path = hppa, pg_catalog;
4777 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4780 REVOKE ALL ON TABLE packages FROM PUBLIC;
4781 REVOKE ALL ON TABLE packages FROM wbadm;
4782 GRANT ALL ON TABLE packages TO wbadm;
4783 GRANT ALL ON TABLE packages TO hppa;
4784 GRANT SELECT ON TABLE packages TO wb_security;
4788 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4791 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4792 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4793 GRANT ALL ON TABLE pkg_history TO wbadm;
4794 GRANT ALL ON TABLE pkg_history TO hppa;
4795 GRANT SELECT ON TABLE pkg_history TO wb_security;
4799 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4802 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4803 REVOKE ALL ON TABLE transactions FROM wbadm;
4804 GRANT ALL ON TABLE transactions TO wbadm;
4805 GRANT SELECT,INSERT ON TABLE transactions TO hppa;
4806 GRANT SELECT ON TABLE transactions TO wb_security;
4810 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4813 REVOKE ALL ON TABLE users FROM PUBLIC;
4814 REVOKE ALL ON TABLE users FROM wbadm;
4815 GRANT ALL ON TABLE users TO wbadm;
4816 GRANT ALL ON TABLE users TO hppa;
4819 SET search_path = hppa_public, pg_catalog;
4822 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4825 REVOKE ALL ON TABLE packages FROM PUBLIC;
4826 REVOKE ALL ON TABLE packages FROM wbadm;
4827 GRANT ALL ON TABLE packages TO wbadm;
4828 GRANT SELECT ON TABLE packages TO PUBLIC;
4832 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4835 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4836 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4837 GRANT ALL ON TABLE pkg_history TO wbadm;
4838 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4842 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4845 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4846 REVOKE ALL ON TABLE transactions FROM wbadm;
4847 GRANT ALL ON TABLE transactions TO wbadm;
4848 GRANT SELECT ON TABLE transactions TO PUBLIC;
4852 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4855 REVOKE ALL ON TABLE users FROM PUBLIC;
4856 REVOKE ALL ON TABLE users FROM wbadm;
4857 GRANT ALL ON TABLE users TO wbadm;
4858 GRANT SELECT ON TABLE users TO PUBLIC;
4861 SET search_path = "hurd-i386", pg_catalog;
4864 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4867 REVOKE ALL ON TABLE packages FROM PUBLIC;
4868 REVOKE ALL ON TABLE packages FROM wbadm;
4869 GRANT ALL ON TABLE packages TO wbadm;
4870 GRANT ALL ON TABLE packages TO "hurd-i386";
4871 GRANT SELECT ON TABLE packages TO wb_security;
4875 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4878 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4879 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4880 GRANT ALL ON TABLE pkg_history TO wbadm;
4881 GRANT ALL ON TABLE pkg_history TO "hurd-i386";
4882 GRANT SELECT ON TABLE pkg_history TO wb_security;
4886 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4889 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4890 REVOKE ALL ON TABLE transactions FROM wbadm;
4891 GRANT ALL ON TABLE transactions TO wbadm;
4892 GRANT SELECT,INSERT ON TABLE transactions TO "hurd-i386";
4893 GRANT SELECT ON TABLE transactions TO wb_security;
4897 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4900 REVOKE ALL ON TABLE users FROM PUBLIC;
4901 REVOKE ALL ON TABLE users FROM wbadm;
4902 GRANT ALL ON TABLE users TO wbadm;
4903 GRANT ALL ON TABLE users TO "hurd-i386";
4906 SET search_path = "hurd-i386_public", pg_catalog;
4909 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4912 REVOKE ALL ON TABLE packages FROM PUBLIC;
4913 REVOKE ALL ON TABLE packages FROM wbadm;
4914 GRANT ALL ON TABLE packages TO wbadm;
4915 GRANT SELECT ON TABLE packages TO PUBLIC;
4919 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4922 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4923 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4924 GRANT ALL ON TABLE pkg_history TO wbadm;
4925 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4929 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4932 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4933 REVOKE ALL ON TABLE transactions FROM wbadm;
4934 GRANT ALL ON TABLE transactions TO wbadm;
4935 GRANT SELECT ON TABLE transactions TO PUBLIC;
4939 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4942 REVOKE ALL ON TABLE users FROM PUBLIC;
4943 REVOKE ALL ON TABLE users FROM wbadm;
4944 GRANT ALL ON TABLE users TO wbadm;
4945 GRANT SELECT ON TABLE users TO PUBLIC;
4948 SET search_path = i386, pg_catalog;
4951 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4954 REVOKE ALL ON TABLE packages FROM PUBLIC;
4955 REVOKE ALL ON TABLE packages FROM wbadm;
4956 GRANT ALL ON TABLE packages TO wbadm;
4957 GRANT ALL ON TABLE packages TO i386;
4958 GRANT SELECT ON TABLE packages TO wb_security;
4962 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4965 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4966 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4967 GRANT ALL ON TABLE pkg_history TO wbadm;
4968 GRANT ALL ON TABLE pkg_history TO i386;
4969 GRANT SELECT ON TABLE pkg_history TO wb_security;
4973 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
4976 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4977 REVOKE ALL ON TABLE transactions FROM wbadm;
4978 GRANT ALL ON TABLE transactions TO wbadm;
4979 GRANT SELECT,INSERT ON TABLE transactions TO i386;
4980 GRANT SELECT ON TABLE transactions TO wb_security;
4984 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
4987 REVOKE ALL ON TABLE users FROM PUBLIC;
4988 REVOKE ALL ON TABLE users FROM wbadm;
4989 GRANT ALL ON TABLE users TO wbadm;
4990 GRANT ALL ON TABLE users TO i386;
4993 SET search_path = i386_public, pg_catalog;
4996 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
4999 REVOKE ALL ON TABLE packages FROM PUBLIC;
5000 REVOKE ALL ON TABLE packages FROM wbadm;
5001 GRANT ALL ON TABLE packages TO wbadm;
5002 GRANT SELECT ON TABLE packages TO PUBLIC;
5006 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5009 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5010 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5011 GRANT ALL ON TABLE pkg_history TO wbadm;
5012 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5016 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5019 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5020 REVOKE ALL ON TABLE transactions FROM wbadm;
5021 GRANT ALL ON TABLE transactions TO wbadm;
5022 GRANT SELECT ON TABLE transactions TO PUBLIC;
5026 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5029 REVOKE ALL ON TABLE users FROM PUBLIC;
5030 REVOKE ALL ON TABLE users FROM wbadm;
5031 GRANT ALL ON TABLE users TO wbadm;
5032 GRANT SELECT ON TABLE users TO PUBLIC;
5035 SET search_path = ia64, pg_catalog;
5038 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5041 REVOKE ALL ON TABLE packages FROM PUBLIC;
5042 REVOKE ALL ON TABLE packages FROM wbadm;
5043 GRANT ALL ON TABLE packages TO wbadm;
5044 GRANT ALL ON TABLE packages TO ia64;
5045 GRANT SELECT ON TABLE packages TO wb_security;
5049 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5052 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5053 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5054 GRANT ALL ON TABLE pkg_history TO wbadm;
5055 GRANT ALL ON TABLE pkg_history TO ia64;
5056 GRANT SELECT ON TABLE pkg_history TO wb_security;
5060 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5063 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5064 REVOKE ALL ON TABLE transactions FROM wbadm;
5065 GRANT ALL ON TABLE transactions TO wbadm;
5066 GRANT SELECT,INSERT ON TABLE transactions TO ia64;
5067 GRANT SELECT ON TABLE transactions TO wb_security;
5071 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5074 REVOKE ALL ON TABLE users FROM PUBLIC;
5075 REVOKE ALL ON TABLE users FROM wbadm;
5076 GRANT ALL ON TABLE users TO wbadm;
5077 GRANT ALL ON TABLE users TO ia64;
5080 SET search_path = ia64_public, pg_catalog;
5083 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5086 REVOKE ALL ON TABLE packages FROM PUBLIC;
5087 REVOKE ALL ON TABLE packages FROM wbadm;
5088 GRANT ALL ON TABLE packages TO wbadm;
5089 GRANT SELECT ON TABLE packages TO PUBLIC;
5093 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5096 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5097 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5098 GRANT ALL ON TABLE pkg_history TO wbadm;
5099 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5103 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5106 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5107 REVOKE ALL ON TABLE transactions FROM wbadm;
5108 GRANT ALL ON TABLE transactions TO wbadm;
5109 GRANT SELECT ON TABLE transactions TO PUBLIC;
5113 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5116 REVOKE ALL ON TABLE users FROM PUBLIC;
5117 REVOKE ALL ON TABLE users FROM wbadm;
5118 GRANT ALL ON TABLE users TO wbadm;
5119 GRANT SELECT ON TABLE users TO PUBLIC;
5122 SET search_path = "kfreebsd-amd64", pg_catalog;
5125 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5128 REVOKE ALL ON TABLE packages FROM PUBLIC;
5129 REVOKE ALL ON TABLE packages FROM wbadm;
5130 GRANT ALL ON TABLE packages TO wbadm;
5131 GRANT ALL ON TABLE packages TO "kfreebsd-amd64";
5132 GRANT SELECT ON TABLE packages TO wb_security;
5136 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5139 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5140 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5141 GRANT ALL ON TABLE pkg_history TO wbadm;
5142 GRANT ALL ON TABLE pkg_history TO "kfreebsd-amd64";
5143 GRANT SELECT ON TABLE pkg_history TO wb_security;
5147 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5150 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5151 REVOKE ALL ON TABLE transactions FROM wbadm;
5152 GRANT ALL ON TABLE transactions TO wbadm;
5153 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-amd64";
5154 GRANT SELECT ON TABLE transactions TO wb_security;
5158 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5161 REVOKE ALL ON TABLE users FROM PUBLIC;
5162 REVOKE ALL ON TABLE users FROM wbadm;
5163 GRANT ALL ON TABLE users TO wbadm;
5164 GRANT ALL ON TABLE users TO "kfreebsd-amd64";
5167 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5170 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5173 REVOKE ALL ON TABLE packages FROM PUBLIC;
5174 REVOKE ALL ON TABLE packages FROM wbadm;
5175 GRANT ALL ON TABLE packages TO wbadm;
5176 GRANT SELECT ON TABLE packages TO PUBLIC;
5180 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5183 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5184 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5185 GRANT ALL ON TABLE pkg_history TO wbadm;
5186 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5190 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5193 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5194 REVOKE ALL ON TABLE transactions FROM wbadm;
5195 GRANT ALL ON TABLE transactions TO wbadm;
5196 GRANT SELECT ON TABLE transactions TO PUBLIC;
5200 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5203 REVOKE ALL ON TABLE users FROM PUBLIC;
5204 REVOKE ALL ON TABLE users FROM wbadm;
5205 GRANT ALL ON TABLE users TO wbadm;
5206 GRANT SELECT ON TABLE users TO PUBLIC;
5209 SET search_path = "kfreebsd-i386", pg_catalog;
5212 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5215 REVOKE ALL ON TABLE packages FROM PUBLIC;
5216 REVOKE ALL ON TABLE packages FROM wbadm;
5217 GRANT ALL ON TABLE packages TO wbadm;
5218 GRANT ALL ON TABLE packages TO "kfreebsd-i386";
5219 GRANT SELECT ON TABLE packages TO wb_security;
5223 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5226 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5227 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5228 GRANT ALL ON TABLE pkg_history TO wbadm;
5229 GRANT ALL ON TABLE pkg_history TO "kfreebsd-i386";
5230 GRANT SELECT ON TABLE pkg_history TO wb_security;
5234 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5237 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5238 REVOKE ALL ON TABLE transactions FROM wbadm;
5239 GRANT ALL ON TABLE transactions TO wbadm;
5240 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-i386";
5241 GRANT SELECT ON TABLE transactions TO wb_security;
5245 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5248 REVOKE ALL ON TABLE users FROM PUBLIC;
5249 REVOKE ALL ON TABLE users FROM wbadm;
5250 GRANT ALL ON TABLE users TO wbadm;
5251 GRANT ALL ON TABLE users TO "kfreebsd-i386";
5254 SET search_path = "kfreebsd-i386_public", pg_catalog;
5257 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5260 REVOKE ALL ON TABLE packages FROM PUBLIC;
5261 REVOKE ALL ON TABLE packages FROM wbadm;
5262 GRANT ALL ON TABLE packages TO wbadm;
5263 GRANT SELECT ON TABLE packages TO PUBLIC;
5267 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5270 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5271 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5272 GRANT ALL ON TABLE pkg_history TO wbadm;
5273 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5277 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5280 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5281 REVOKE ALL ON TABLE transactions FROM wbadm;
5282 GRANT ALL ON TABLE transactions TO wbadm;
5283 GRANT SELECT ON TABLE transactions TO PUBLIC;
5287 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5290 REVOKE ALL ON TABLE users FROM PUBLIC;
5291 REVOKE ALL ON TABLE users FROM wbadm;
5292 GRANT ALL ON TABLE users TO wbadm;
5293 GRANT SELECT ON TABLE users TO PUBLIC;
5296 SET search_path = mips, pg_catalog;
5299 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5302 REVOKE ALL ON TABLE packages FROM PUBLIC;
5303 REVOKE ALL ON TABLE packages FROM wbadm;
5304 GRANT ALL ON TABLE packages TO wbadm;
5305 GRANT ALL ON TABLE packages TO mips;
5306 GRANT SELECT ON TABLE packages TO wb_security;
5310 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5313 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5314 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5315 GRANT ALL ON TABLE pkg_history TO wbadm;
5316 GRANT ALL ON TABLE pkg_history TO mips;
5317 GRANT SELECT ON TABLE pkg_history TO wb_security;
5321 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5324 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5325 REVOKE ALL ON TABLE transactions FROM wbadm;
5326 GRANT ALL ON TABLE transactions TO wbadm;
5327 GRANT SELECT,INSERT ON TABLE transactions TO mips;
5328 GRANT SELECT ON TABLE transactions TO wb_security;
5332 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5335 REVOKE ALL ON TABLE users FROM PUBLIC;
5336 REVOKE ALL ON TABLE users FROM wbadm;
5337 GRANT ALL ON TABLE users TO wbadm;
5338 GRANT ALL ON TABLE users TO mips;
5341 SET search_path = mips_public, pg_catalog;
5344 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5347 REVOKE ALL ON TABLE packages FROM PUBLIC;
5348 REVOKE ALL ON TABLE packages FROM wbadm;
5349 GRANT ALL ON TABLE packages TO wbadm;
5350 GRANT SELECT ON TABLE packages TO PUBLIC;
5354 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5357 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5358 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5359 GRANT ALL ON TABLE pkg_history TO wbadm;
5360 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5364 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5367 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5368 REVOKE ALL ON TABLE transactions FROM wbadm;
5369 GRANT ALL ON TABLE transactions TO wbadm;
5370 GRANT SELECT ON TABLE transactions TO PUBLIC;
5374 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5377 REVOKE ALL ON TABLE users FROM PUBLIC;
5378 REVOKE ALL ON TABLE users FROM wbadm;
5379 GRANT ALL ON TABLE users TO wbadm;
5380 GRANT SELECT ON TABLE users TO PUBLIC;
5383 SET search_path = mipsel, pg_catalog;
5386 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5389 REVOKE ALL ON TABLE packages FROM PUBLIC;
5390 REVOKE ALL ON TABLE packages FROM wbadm;
5391 GRANT ALL ON TABLE packages TO wbadm;
5392 GRANT ALL ON TABLE packages TO mipsel;
5393 GRANT SELECT ON TABLE packages TO wb_security;
5397 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5400 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5401 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5402 GRANT ALL ON TABLE pkg_history TO wbadm;
5403 GRANT ALL ON TABLE pkg_history TO mipsel;
5404 GRANT SELECT ON TABLE pkg_history TO wb_security;
5408 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5411 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5412 REVOKE ALL ON TABLE transactions FROM wbadm;
5413 GRANT ALL ON TABLE transactions TO wbadm;
5414 GRANT SELECT,INSERT ON TABLE transactions TO mipsel;
5415 GRANT SELECT ON TABLE transactions TO wb_security;
5419 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5422 REVOKE ALL ON TABLE users FROM PUBLIC;
5423 REVOKE ALL ON TABLE users FROM wbadm;
5424 GRANT ALL ON TABLE users TO wbadm;
5425 GRANT ALL ON TABLE users TO mipsel;
5428 SET search_path = mipsel_public, pg_catalog;
5431 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5434 REVOKE ALL ON TABLE packages FROM PUBLIC;
5435 REVOKE ALL ON TABLE packages FROM wbadm;
5436 GRANT ALL ON TABLE packages TO wbadm;
5437 GRANT SELECT ON TABLE packages TO PUBLIC;
5441 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5444 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5445 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5446 GRANT ALL ON TABLE pkg_history TO wbadm;
5447 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5451 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5454 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5455 REVOKE ALL ON TABLE transactions FROM wbadm;
5456 GRANT ALL ON TABLE transactions TO wbadm;
5457 GRANT SELECT ON TABLE transactions TO PUBLIC;
5461 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5464 REVOKE ALL ON TABLE users FROM PUBLIC;
5465 REVOKE ALL ON TABLE users FROM wbadm;
5466 GRANT ALL ON TABLE users TO wbadm;
5467 GRANT SELECT ON TABLE users TO PUBLIC;
5470 SET search_path = powerpc, pg_catalog;
5473 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5476 REVOKE ALL ON TABLE packages FROM PUBLIC;
5477 REVOKE ALL ON TABLE packages FROM wbadm;
5478 GRANT ALL ON TABLE packages TO wbadm;
5479 GRANT ALL ON TABLE packages TO powerpc;
5480 GRANT SELECT ON TABLE packages TO wb_security;
5484 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5487 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5488 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5489 GRANT ALL ON TABLE pkg_history TO wbadm;
5490 GRANT ALL ON TABLE pkg_history TO powerpc;
5491 GRANT SELECT ON TABLE pkg_history TO wb_security;
5495 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5498 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5499 REVOKE ALL ON TABLE transactions FROM wbadm;
5500 GRANT ALL ON TABLE transactions TO wbadm;
5501 GRANT SELECT,INSERT ON TABLE transactions TO powerpc;
5502 GRANT SELECT ON TABLE transactions TO wb_security;
5506 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5509 REVOKE ALL ON TABLE users FROM PUBLIC;
5510 REVOKE ALL ON TABLE users FROM wbadm;
5511 GRANT ALL ON TABLE users TO wbadm;
5512 GRANT ALL ON TABLE users TO powerpc;
5515 SET search_path = powerpc_public, pg_catalog;
5518 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5521 REVOKE ALL ON TABLE packages FROM PUBLIC;
5522 REVOKE ALL ON TABLE packages FROM wbadm;
5523 GRANT ALL ON TABLE packages TO wbadm;
5524 GRANT SELECT ON TABLE packages TO PUBLIC;
5528 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5531 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5532 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5533 GRANT ALL ON TABLE pkg_history TO wbadm;
5534 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5538 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5541 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5542 REVOKE ALL ON TABLE transactions FROM wbadm;
5543 GRANT ALL ON TABLE transactions TO wbadm;
5544 GRANT SELECT ON TABLE transactions TO PUBLIC;
5548 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5551 REVOKE ALL ON TABLE users FROM PUBLIC;
5552 REVOKE ALL ON TABLE users FROM wbadm;
5553 GRANT ALL ON TABLE users TO wbadm;
5554 GRANT SELECT ON TABLE users TO PUBLIC;
5557 SET search_path = public, pg_catalog;
5560 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5563 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5564 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5565 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5566 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5569 SET search_path = s390, pg_catalog;
5572 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5575 REVOKE ALL ON TABLE packages FROM PUBLIC;
5576 REVOKE ALL ON TABLE packages FROM wbadm;
5577 GRANT ALL ON TABLE packages TO wbadm;
5578 GRANT ALL ON TABLE packages TO s390;
5579 GRANT SELECT ON TABLE packages TO wb_security;
5582 SET search_path = sparc, pg_catalog;
5585 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5588 REVOKE ALL ON TABLE packages FROM PUBLIC;
5589 REVOKE ALL ON TABLE packages FROM wbadm;
5590 GRANT ALL ON TABLE packages TO wbadm;
5591 GRANT ALL ON TABLE packages TO sparc;
5592 GRANT SELECT ON TABLE packages TO wb_security;
5595 SET search_path = public, pg_catalog;
5598 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5601 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5602 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5603 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5604 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5608 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
5611 REVOKE ALL ON TABLE distributions FROM PUBLIC;
5612 REVOKE ALL ON TABLE distributions FROM wbadm;
5613 GRANT ALL ON TABLE distributions TO wbadm;
5614 GRANT SELECT ON TABLE distributions TO PUBLIC;
5617 SET search_path = s390, pg_catalog;
5620 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5623 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5624 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5625 GRANT ALL ON TABLE pkg_history TO wbadm;
5626 GRANT ALL ON TABLE pkg_history TO s390;
5627 GRANT SELECT ON TABLE pkg_history TO wb_security;
5630 SET search_path = s390_public, pg_catalog;
5633 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5636 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5637 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5638 GRANT ALL ON TABLE pkg_history TO wbadm;
5639 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5642 SET search_path = sparc, pg_catalog;
5645 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5648 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5649 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5650 GRANT ALL ON TABLE pkg_history TO wbadm;
5651 GRANT ALL ON TABLE pkg_history TO sparc;
5652 GRANT SELECT ON TABLE pkg_history TO wb_security;
5655 SET search_path = sparc_public, pg_catalog;
5658 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5661 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5662 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5663 GRANT ALL ON TABLE pkg_history TO wbadm;
5664 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5667 SET search_path = public, pg_catalog;
5670 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5673 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5674 REVOKE ALL ON TABLE lastlog FROM wbadm;
5675 GRANT ALL ON TABLE lastlog TO wbadm;
5676 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5680 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5683 REVOKE ALL ON TABLE log FROM PUBLIC;
5684 REVOKE ALL ON TABLE log FROM wbadm;
5685 GRANT ALL ON TABLE log TO wbadm;
5686 GRANT SELECT ON TABLE log TO PUBLIC;
5690 -- Name: log_v2; Type: ACL; Schema: public; Owner: pkern
5693 REVOKE ALL ON TABLE log_v2 FROM PUBLIC;
5694 REVOKE ALL ON TABLE log_v2 FROM pkern;
5695 GRANT ALL ON TABLE log_v2 TO pkern;
5696 GRANT SELECT ON TABLE log_v2 TO PUBLIC;
5699 SET search_path = s390_public, pg_catalog;
5702 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5705 REVOKE ALL ON TABLE packages FROM PUBLIC;
5706 REVOKE ALL ON TABLE packages FROM wbadm;
5707 GRANT ALL ON TABLE packages TO wbadm;
5708 GRANT SELECT ON TABLE packages TO PUBLIC;
5711 SET search_path = sparc_public, pg_catalog;
5714 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5717 REVOKE ALL ON TABLE packages FROM PUBLIC;
5718 REVOKE ALL ON TABLE packages FROM wbadm;
5719 GRANT ALL ON TABLE packages TO wbadm;
5720 GRANT SELECT ON TABLE packages TO PUBLIC;
5723 SET search_path = public, pg_catalog;
5726 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5729 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5730 REVOKE ALL ON TABLE packages_all FROM wbadm;
5731 GRANT ALL ON TABLE packages_all TO wbadm;
5732 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5735 SET search_path = s390, pg_catalog;
5738 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5741 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5742 REVOKE ALL ON TABLE transactions FROM wbadm;
5743 GRANT ALL ON TABLE transactions TO wbadm;
5744 GRANT SELECT,INSERT ON TABLE transactions TO s390;
5745 GRANT SELECT ON TABLE transactions TO wb_security;
5749 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5752 REVOKE ALL ON TABLE users FROM PUBLIC;
5753 REVOKE ALL ON TABLE users FROM wbadm;
5754 GRANT ALL ON TABLE users TO wbadm;
5755 GRANT ALL ON TABLE users TO s390;
5758 SET search_path = s390_public, pg_catalog;
5761 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5764 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5765 REVOKE ALL ON TABLE transactions FROM wbadm;
5766 GRANT ALL ON TABLE transactions TO wbadm;
5767 GRANT SELECT ON TABLE transactions TO PUBLIC;
5771 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5774 REVOKE ALL ON TABLE users FROM PUBLIC;
5775 REVOKE ALL ON TABLE users FROM wbadm;
5776 GRANT ALL ON TABLE users TO wbadm;
5777 GRANT SELECT ON TABLE users TO PUBLIC;
5780 SET search_path = sparc, pg_catalog;
5783 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5786 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5787 REVOKE ALL ON TABLE transactions FROM wbadm;
5788 GRANT ALL ON TABLE transactions TO wbadm;
5789 GRANT SELECT,INSERT ON TABLE transactions TO sparc;
5790 GRANT SELECT ON TABLE transactions TO wb_security;
5794 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5797 REVOKE ALL ON TABLE users FROM PUBLIC;
5798 REVOKE ALL ON TABLE users FROM wbadm;
5799 GRANT ALL ON TABLE users TO wbadm;
5800 GRANT ALL ON TABLE users TO sparc;
5803 SET search_path = sparc_public, pg_catalog;
5806 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5809 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5810 REVOKE ALL ON TABLE transactions FROM wbadm;
5811 GRANT ALL ON TABLE transactions TO wbadm;
5812 GRANT SELECT ON TABLE transactions TO PUBLIC;
5816 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5819 REVOKE ALL ON TABLE users FROM PUBLIC;
5820 REVOKE ALL ON TABLE users FROM wbadm;
5821 GRANT ALL ON TABLE users TO wbadm;
5822 GRANT SELECT ON TABLE users TO PUBLIC;
5826 -- PostgreSQL database dump complete