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
2643 SELECT DISTINCT packages.distribution, 'alpha'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM alpha.packages
2645 SELECT DISTINCT packages.distribution, 'amd64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM amd64.packages
2647 SELECT DISTINCT packages.distribution, 'arm'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM arm.packages
2649 SELECT DISTINCT packages.distribution, 'armel'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM armel.packages
2651 SELECT DISTINCT packages.distribution, 'hppa'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM hppa.packages
2653 SELECT DISTINCT packages.distribution, 'hurd-i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "hurd-i386".packages
2655 SELECT DISTINCT packages.distribution, 'i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM i386.packages
2657 SELECT DISTINCT packages.distribution, 'ia64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM ia64.packages
2659 SELECT DISTINCT packages.distribution, 'kfreebsd-amd64'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "kfreebsd-amd64".packages
2661 SELECT DISTINCT packages.distribution, 'kfreebsd-i386'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM "kfreebsd-i386".packages
2663 SELECT DISTINCT packages.distribution, 'mips'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM mips.packages
2665 SELECT DISTINCT packages.distribution, 'mipsel'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM mipsel.packages
2667 SELECT DISTINCT packages.distribution, 'powerpc'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM powerpc.packages
2669 SELECT DISTINCT packages.distribution, 's390'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM s390.packages
2671 SELECT DISTINCT packages.distribution, 'sparc'::character varying AS architecture, count(case when state='Needs-Build' then 1 end) as needsbuild FROM sparc.packages;
2674 ALTER TABLE public.distribution_architectures OWNER TO wbadm;
2677 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace:
2680 CREATE TABLE distributions (
2681 distribution character varying NOT NULL,
2682 public boolean DEFAULT true NOT NULL,
2683 sort_order integer DEFAULT 0,
2684 auto_dep_wait boolean DEFAULT true
2688 ALTER TABLE public.distributions OWNER TO wbadm;
2690 SET search_path = s390, pg_catalog;
2693 -- Name: pkg_history; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2696 CREATE TABLE pkg_history (
2697 package character varying NOT NULL,
2698 distribution character varying NOT NULL,
2699 version character varying NOT NULL,
2700 "timestamp" timestamp without time zone NOT NULL,
2701 result character varying NOT NULL,
2707 ALTER TABLE s390.pkg_history OWNER TO wbadm;
2709 SET search_path = s390_public, pg_catalog;
2712 -- Name: pkg_history; Type: VIEW; Schema: s390_public; Owner: wbadm
2715 CREATE VIEW pkg_history AS
2716 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);
2719 ALTER TABLE s390_public.pkg_history OWNER TO wbadm;
2721 SET search_path = sparc, pg_catalog;
2724 -- Name: pkg_history; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2727 CREATE TABLE pkg_history (
2728 package character varying NOT NULL,
2729 distribution character varying NOT NULL,
2730 version character varying NOT NULL,
2731 "timestamp" timestamp without time zone NOT NULL,
2732 result character varying NOT NULL,
2738 ALTER TABLE sparc.pkg_history OWNER TO wbadm;
2740 SET search_path = sparc_public, pg_catalog;
2743 -- Name: pkg_history; Type: VIEW; Schema: sparc_public; Owner: wbadm
2746 CREATE VIEW pkg_history AS
2747 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);
2750 ALTER TABLE sparc_public.pkg_history OWNER TO wbadm;
2752 SET search_path = public, pg_catalog;
2755 -- Name: lastlog; Type: VIEW; Schema: public; Owner: wbadm
2758 CREATE VIEW lastlog AS
2759 ((((((((((((((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;
2762 ALTER TABLE public.lastlog OWNER TO wbadm;
2765 -- Name: log; Type: VIEW; Schema: public; Owner: wbadm
2769 (((((((((((((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;
2772 ALTER TABLE public.log OWNER TO wbadm;
2775 -- Name: log_v2; Type: VIEW; Schema: public; Owner: pkern
2778 CREATE VIEW log_v2 AS
2779 (((((((((((((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;
2782 ALTER TABLE public.log_v2 OWNER TO pkern;
2784 SET search_path = s390_public, pg_catalog;
2787 -- Name: packages; Type: VIEW; Schema: s390_public; Owner: wbadm
2790 CREATE VIEW packages AS
2791 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);
2794 ALTER TABLE s390_public.packages OWNER TO wbadm;
2796 SET search_path = sparc_public, pg_catalog;
2799 -- Name: packages; Type: VIEW; Schema: sparc_public; Owner: wbadm
2802 CREATE VIEW packages AS
2803 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);
2806 ALTER TABLE sparc_public.packages OWNER TO wbadm;
2808 SET search_path = public, pg_catalog;
2811 -- Name: packages_all; Type: VIEW; Schema: public; Owner: wbadm
2814 CREATE VIEW packages_all AS
2815 (((((((((((((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;
2818 ALTER TABLE public.packages_all OWNER TO wbadm;
2820 SET search_path = s390, pg_catalog;
2823 -- Name: transactions; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2826 CREATE TABLE transactions (
2827 package character varying,
2828 distribution character varying,
2829 version character varying,
2830 action character varying,
2831 prevstate character varying,
2832 state character varying,
2833 real_user character varying,
2834 set_user character varying,
2835 "time" timestamp without time zone
2839 ALTER TABLE s390.transactions OWNER TO wbadm;
2842 -- Name: users; Type: TABLE; Schema: s390; Owner: wbadm; Tablespace:
2845 CREATE TABLE users (
2846 username character varying NOT NULL,
2847 distribution character varying NOT NULL,
2848 last_seen timestamp without time zone
2852 ALTER TABLE s390.users OWNER TO wbadm;
2854 SET search_path = s390_public, pg_catalog;
2857 -- Name: transactions; Type: VIEW; Schema: s390_public; Owner: wbadm
2860 CREATE VIEW transactions AS
2861 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);
2864 ALTER TABLE s390_public.transactions OWNER TO wbadm;
2867 -- Name: users; Type: VIEW; Schema: s390_public; Owner: wbadm
2870 CREATE VIEW users AS
2871 SELECT users.username, users.distribution, users.last_seen FROM s390.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2874 ALTER TABLE s390_public.users OWNER TO wbadm;
2876 SET search_path = sparc, pg_catalog;
2879 -- Name: transactions; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2882 CREATE TABLE transactions (
2883 package character varying,
2884 distribution character varying,
2885 version character varying,
2886 action character varying,
2887 prevstate character varying,
2888 state character varying,
2889 real_user character varying,
2890 set_user character varying,
2891 "time" timestamp without time zone
2895 ALTER TABLE sparc.transactions OWNER TO wbadm;
2898 -- Name: users; Type: TABLE; Schema: sparc; Owner: wbadm; Tablespace:
2901 CREATE TABLE users (
2902 username character varying NOT NULL,
2903 distribution character varying NOT NULL,
2904 last_seen timestamp without time zone
2908 ALTER TABLE sparc.users OWNER TO wbadm;
2910 SET search_path = sparc_public, pg_catalog;
2913 -- Name: transactions; Type: VIEW; Schema: sparc_public; Owner: wbadm
2916 CREATE VIEW transactions AS
2917 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);
2920 ALTER TABLE sparc_public.transactions OWNER TO wbadm;
2923 -- Name: users; Type: VIEW; Schema: sparc_public; Owner: wbadm
2926 CREATE VIEW users AS
2927 SELECT users.username, users.distribution, users.last_seen FROM sparc.users WHERE ((users.distribution)::text !~~ '%-security'::text);
2930 ALTER TABLE sparc_public.users OWNER TO wbadm;
2932 SET search_path = alpha, pg_catalog;
2935 -- Name: packages_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2938 ALTER TABLE ONLY packages
2939 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2943 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2946 ALTER TABLE ONLY pkg_history
2947 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2951 -- Name: users_pkey; Type: CONSTRAINT; Schema: alpha; Owner: wbadm; Tablespace:
2954 ALTER TABLE ONLY users
2955 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2958 SET search_path = amd64, pg_catalog;
2961 -- Name: packages_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2964 ALTER TABLE ONLY packages
2965 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2969 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2972 ALTER TABLE ONLY pkg_history
2973 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
2977 -- Name: users_pkey; Type: CONSTRAINT; Schema: amd64; Owner: wbadm; Tablespace:
2980 ALTER TABLE ONLY users
2981 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
2984 SET search_path = arm, pg_catalog;
2987 -- Name: packages_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2990 ALTER TABLE ONLY packages
2991 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
2995 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
2998 ALTER TABLE ONLY pkg_history
2999 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3003 -- Name: users_pkey; Type: CONSTRAINT; Schema: arm; Owner: wbadm; Tablespace:
3006 ALTER TABLE ONLY users
3007 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3010 SET search_path = armel, pg_catalog;
3013 -- Name: packages_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3016 ALTER TABLE ONLY packages
3017 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3021 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3024 ALTER TABLE ONLY pkg_history
3025 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3029 -- Name: users_pkey; Type: CONSTRAINT; Schema: armel; Owner: wbadm; Tablespace:
3032 ALTER TABLE ONLY users
3033 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3036 SET search_path = hppa, pg_catalog;
3039 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3042 ALTER TABLE ONLY packages
3043 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3047 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3050 ALTER TABLE ONLY pkg_history
3051 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3055 -- Name: users_pkey; Type: CONSTRAINT; Schema: hppa; Owner: wbadm; Tablespace:
3058 ALTER TABLE ONLY users
3059 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3062 SET search_path = "hurd-i386", pg_catalog;
3065 -- Name: packages_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3068 ALTER TABLE ONLY packages
3069 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3073 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3076 ALTER TABLE ONLY pkg_history
3077 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3081 -- Name: users_pkey; Type: CONSTRAINT; Schema: hurd-i386; Owner: wbadm; Tablespace:
3084 ALTER TABLE ONLY users
3085 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3088 SET search_path = i386, pg_catalog;
3091 -- Name: packages_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3094 ALTER TABLE ONLY packages
3095 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3099 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3102 ALTER TABLE ONLY pkg_history
3103 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3107 -- Name: users_pkey; Type: CONSTRAINT; Schema: i386; Owner: wbadm; Tablespace:
3110 ALTER TABLE ONLY users
3111 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3114 SET search_path = ia64, pg_catalog;
3117 -- Name: packages_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3120 ALTER TABLE ONLY packages
3121 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3125 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3128 ALTER TABLE ONLY pkg_history
3129 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3133 -- Name: users_pkey; Type: CONSTRAINT; Schema: ia64; Owner: wbadm; Tablespace:
3136 ALTER TABLE ONLY users
3137 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3140 SET search_path = "kfreebsd-amd64", pg_catalog;
3143 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3146 ALTER TABLE ONLY packages
3147 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3151 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3154 ALTER TABLE ONLY pkg_history
3155 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3159 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3162 ALTER TABLE ONLY users
3163 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3166 SET search_path = "kfreebsd-i386", pg_catalog;
3169 -- Name: packages_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3172 ALTER TABLE ONLY packages
3173 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3177 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3180 ALTER TABLE ONLY pkg_history
3181 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3185 -- Name: users_pkey; Type: CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3188 ALTER TABLE ONLY users
3189 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3192 SET search_path = mips, pg_catalog;
3195 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3198 ALTER TABLE ONLY packages
3199 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3203 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3206 ALTER TABLE ONLY pkg_history
3207 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3211 -- Name: users_pkey; Type: CONSTRAINT; Schema: mips; Owner: wbadm; Tablespace:
3214 ALTER TABLE ONLY users
3215 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3218 SET search_path = mipsel, pg_catalog;
3221 -- Name: packages_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3224 ALTER TABLE ONLY packages
3225 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3229 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3232 ALTER TABLE ONLY pkg_history
3233 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3237 -- Name: users_pkey; Type: CONSTRAINT; Schema: mipsel; Owner: wbadm; Tablespace:
3240 ALTER TABLE ONLY users
3241 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3244 SET search_path = powerpc, pg_catalog;
3247 -- Name: packages_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3250 ALTER TABLE ONLY packages
3251 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3255 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3258 ALTER TABLE ONLY pkg_history
3259 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3263 -- Name: users_pkey; Type: CONSTRAINT; Schema: powerpc; Owner: wbadm; Tablespace:
3266 ALTER TABLE ONLY users
3267 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3270 SET search_path = public, pg_catalog;
3273 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace:
3276 ALTER TABLE ONLY distribution_aliases
3277 ADD CONSTRAINT distribution_aliases_pkey PRIMARY KEY (alias);
3280 SET search_path = s390, pg_catalog;
3283 -- Name: packages_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3286 ALTER TABLE ONLY packages
3287 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3291 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3294 ALTER TABLE ONLY pkg_history
3295 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3299 -- Name: users_pkey; Type: CONSTRAINT; Schema: s390; Owner: wbadm; Tablespace:
3302 ALTER TABLE ONLY users
3303 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3306 SET search_path = sparc, pg_catalog;
3309 -- Name: packages_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3312 ALTER TABLE ONLY packages
3313 ADD CONSTRAINT packages_pkey PRIMARY KEY (package, distribution);
3317 -- Name: pkg_history_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3320 ALTER TABLE ONLY pkg_history
3321 ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (package, distribution, version, "timestamp");
3325 -- Name: users_pkey; Type: CONSTRAINT; Schema: sparc; Owner: wbadm; Tablespace:
3328 ALTER TABLE ONLY users
3329 ADD CONSTRAINT users_pkey PRIMARY KEY (username, distribution);
3332 SET search_path = alpha, pg_catalog;
3335 -- Name: idx_alpha_state; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3338 CREATE INDEX idx_alpha_state ON packages USING btree (state);
3342 -- Name: pkg_history_distribution; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3345 CREATE INDEX pkg_history_distribution ON pkg_history USING hash (distribution);
3349 -- Name: pkg_history_index; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3352 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3356 -- Name: pkg_history_timestamp; Type: INDEX; Schema: alpha; Owner: wbadm; Tablespace:
3359 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3362 SET search_path = amd64, pg_catalog;
3365 -- Name: idx_amd64_state; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3368 CREATE INDEX idx_amd64_state ON packages USING btree (state);
3372 -- Name: pkg_history_index; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3375 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3379 -- Name: pkg_history_timestamp; Type: INDEX; Schema: amd64; Owner: wbadm; Tablespace:
3382 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3385 SET search_path = arm, pg_catalog;
3388 -- Name: idx_arm_state; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3391 CREATE INDEX idx_arm_state ON packages USING btree (state);
3395 -- Name: pkg_history_index; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3398 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3402 -- Name: pkg_history_timestamp; Type: INDEX; Schema: arm; Owner: wbadm; Tablespace:
3405 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3408 SET search_path = armel, pg_catalog;
3411 -- Name: idx_armel_state; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3414 CREATE INDEX idx_armel_state ON packages USING btree (state);
3418 -- Name: pkg_history_index; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3421 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3425 -- Name: pkg_history_timestamp; Type: INDEX; Schema: armel; Owner: wbadm; Tablespace:
3428 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3431 SET search_path = hppa, pg_catalog;
3434 -- Name: idx_hppa_state; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3437 CREATE INDEX idx_hppa_state ON packages USING btree (state);
3441 -- Name: pkg_history_index; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3444 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3448 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hppa; Owner: wbadm; Tablespace:
3451 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3454 SET search_path = "hurd-i386", pg_catalog;
3457 -- Name: idx_hurd-i386_state; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3460 CREATE INDEX "idx_hurd-i386_state" ON packages USING btree (state);
3464 -- Name: pkg_history_index; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3467 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3471 -- Name: pkg_history_timestamp; Type: INDEX; Schema: hurd-i386; Owner: wbadm; Tablespace:
3474 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3477 SET search_path = i386, pg_catalog;
3480 -- Name: idx_i386_state; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3483 CREATE INDEX idx_i386_state ON packages USING btree (state);
3487 -- Name: pkg_history_index; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3490 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3494 -- Name: pkg_history_timestamp; Type: INDEX; Schema: i386; Owner: wbadm; Tablespace:
3497 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3500 SET search_path = ia64, pg_catalog;
3503 -- Name: idx_ia64_state; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3506 CREATE INDEX idx_ia64_state ON packages USING btree (state);
3510 -- Name: pkg_history_index; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3513 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3517 -- Name: pkg_history_timestamp; Type: INDEX; Schema: ia64; Owner: wbadm; Tablespace:
3520 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3523 SET search_path = "kfreebsd-amd64", pg_catalog;
3526 -- Name: idx_kfreebsd-amd64_state; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3529 CREATE INDEX "idx_kfreebsd-amd64_state" ON packages USING btree (state);
3533 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3536 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3540 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-amd64; Owner: wbadm; Tablespace:
3543 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3546 SET search_path = "kfreebsd-i386", pg_catalog;
3549 -- Name: idx_kfreebsd-i386_state; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3552 CREATE INDEX "idx_kfreebsd-i386_state" ON packages USING btree (state);
3556 -- Name: pkg_history_index; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3559 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3563 -- Name: pkg_history_timestamp; Type: INDEX; Schema: kfreebsd-i386; Owner: wbadm; Tablespace:
3566 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3569 SET search_path = mips, pg_catalog;
3572 -- Name: idx_mips_state; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3575 CREATE INDEX idx_mips_state ON packages USING btree (state);
3579 -- Name: pkg_history_index; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3582 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3586 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mips; Owner: wbadm; Tablespace:
3589 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3592 SET search_path = mipsel, pg_catalog;
3595 -- Name: idx_mipsel_state; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3598 CREATE INDEX idx_mipsel_state ON packages USING btree (state);
3602 -- Name: pkg_history_index; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3605 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3609 -- Name: pkg_history_timestamp; Type: INDEX; Schema: mipsel; Owner: wbadm; Tablespace:
3612 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3615 SET search_path = powerpc, pg_catalog;
3618 -- Name: idx_powerpc_state; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3621 CREATE INDEX idx_powerpc_state ON packages USING btree (state);
3625 -- Name: pkg_history_index; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3628 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3632 -- Name: pkg_history_timestamp; Type: INDEX; Schema: powerpc; Owner: wbadm; Tablespace:
3635 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3638 SET search_path = public, pg_catalog;
3641 -- Name: distribution_unique; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3644 CREATE UNIQUE INDEX distribution_unique ON distributions USING btree (distribution);
3648 -- Name: distributions_distribution; Type: INDEX; Schema: public; Owner: wbadm; Tablespace:
3651 CREATE INDEX distributions_distribution ON distributions USING hash (distribution);
3654 SET search_path = s390, pg_catalog;
3657 -- Name: idx_s390_state; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3660 CREATE INDEX idx_s390_state ON packages USING btree (state);
3664 -- Name: pkg_history_index; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3667 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3671 -- Name: pkg_history_timestamp; Type: INDEX; Schema: s390; Owner: wbadm; Tablespace:
3674 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3677 SET search_path = sparc, pg_catalog;
3680 -- Name: idx_sparc_state; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3683 CREATE INDEX idx_sparc_state ON packages USING btree (state);
3687 -- Name: pkg_history_index; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3690 CREATE INDEX pkg_history_index ON pkg_history USING btree (package, distribution, "timestamp" DESC, result);
3694 -- Name: pkg_history_timestamp; Type: INDEX; Schema: sparc; Owner: wbadm; Tablespace:
3697 CREATE INDEX pkg_history_timestamp ON pkg_history USING btree ("timestamp");
3700 SET search_path = alpha, pg_catalog;
3703 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3706 ALTER TABLE ONLY packages
3707 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3711 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3714 ALTER TABLE ONLY pkg_history
3715 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3719 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: alpha; Owner: wbadm
3722 ALTER TABLE ONLY users
3723 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3726 SET search_path = amd64, pg_catalog;
3729 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3732 ALTER TABLE ONLY packages
3733 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3737 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3740 ALTER TABLE ONLY pkg_history
3741 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3745 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: amd64; Owner: wbadm
3748 ALTER TABLE ONLY users
3749 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3752 SET search_path = arm, pg_catalog;
3755 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3758 ALTER TABLE ONLY packages
3759 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3763 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3766 ALTER TABLE ONLY pkg_history
3767 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3771 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: arm; Owner: wbadm
3774 ALTER TABLE ONLY users
3775 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3778 SET search_path = armel, pg_catalog;
3781 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3784 ALTER TABLE ONLY packages
3785 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3789 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3792 ALTER TABLE ONLY pkg_history
3793 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3797 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: armel; Owner: wbadm
3800 ALTER TABLE ONLY users
3801 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3804 SET search_path = hppa, pg_catalog;
3807 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3810 ALTER TABLE ONLY packages
3811 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3815 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3818 ALTER TABLE ONLY pkg_history
3819 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3823 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hppa; Owner: wbadm
3826 ALTER TABLE ONLY users
3827 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3830 SET search_path = "hurd-i386", pg_catalog;
3833 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3836 ALTER TABLE ONLY packages
3837 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3841 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3844 ALTER TABLE ONLY pkg_history
3845 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3849 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: hurd-i386; Owner: wbadm
3852 ALTER TABLE ONLY users
3853 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3856 SET search_path = i386, pg_catalog;
3859 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3862 ALTER TABLE ONLY packages
3863 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3867 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3870 ALTER TABLE ONLY pkg_history
3871 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3875 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: i386; Owner: wbadm
3878 ALTER TABLE ONLY users
3879 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3882 SET search_path = ia64, pg_catalog;
3885 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3888 ALTER TABLE ONLY packages
3889 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3893 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3896 ALTER TABLE ONLY pkg_history
3897 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3901 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: ia64; Owner: wbadm
3904 ALTER TABLE ONLY users
3905 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3908 SET search_path = "kfreebsd-amd64", pg_catalog;
3911 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3914 ALTER TABLE ONLY packages
3915 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3919 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3922 ALTER TABLE ONLY pkg_history
3923 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3927 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-amd64; Owner: wbadm
3930 ALTER TABLE ONLY users
3931 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3934 SET search_path = "kfreebsd-i386", pg_catalog;
3937 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3940 ALTER TABLE ONLY packages
3941 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3945 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3948 ALTER TABLE ONLY pkg_history
3949 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3953 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: kfreebsd-i386; Owner: wbadm
3956 ALTER TABLE ONLY users
3957 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3960 SET search_path = mips, pg_catalog;
3963 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3966 ALTER TABLE ONLY packages
3967 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3971 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3974 ALTER TABLE ONLY pkg_history
3975 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
3979 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mips; Owner: wbadm
3982 ALTER TABLE ONLY users
3983 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3986 SET search_path = mipsel, pg_catalog;
3989 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
3992 ALTER TABLE ONLY packages
3993 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
3997 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
4000 ALTER TABLE ONLY pkg_history
4001 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4005 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: mipsel; Owner: wbadm
4008 ALTER TABLE ONLY users
4009 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4012 SET search_path = powerpc, pg_catalog;
4015 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4018 ALTER TABLE ONLY packages
4019 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4023 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4026 ALTER TABLE ONLY pkg_history
4027 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4031 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: powerpc; Owner: wbadm
4034 ALTER TABLE ONLY users
4035 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4038 SET search_path = public, pg_catalog;
4041 -- Name: distribution_aliases_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
4044 ALTER TABLE ONLY distribution_aliases
4045 ADD CONSTRAINT distribution_aliases_distribution_fkey FOREIGN KEY (distribution) REFERENCES distributions(distribution);
4048 SET search_path = s390, pg_catalog;
4051 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4054 ALTER TABLE ONLY packages
4055 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4059 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4062 ALTER TABLE ONLY pkg_history
4063 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4067 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: s390; Owner: wbadm
4070 ALTER TABLE ONLY users
4071 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4074 SET search_path = sparc, pg_catalog;
4077 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4080 ALTER TABLE ONLY packages
4081 ADD CONSTRAINT packages_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4085 -- Name: pkg_history_distribution_fk; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4088 ALTER TABLE ONLY pkg_history
4089 ADD CONSTRAINT pkg_history_distribution_fk FOREIGN KEY (distribution) REFERENCES public.distributions(distribution) MATCH FULL;
4093 -- Name: users_distribution_fkey; Type: FK CONSTRAINT; Schema: sparc; Owner: wbadm
4096 ALTER TABLE ONLY users
4097 ADD CONSTRAINT users_distribution_fkey FOREIGN KEY (distribution) REFERENCES public.distributions(distribution);
4101 -- Name: alpha; Type: ACL; Schema: -; Owner: wbadm
4104 REVOKE ALL ON SCHEMA alpha FROM PUBLIC;
4105 REVOKE ALL ON SCHEMA alpha FROM wbadm;
4106 GRANT ALL ON SCHEMA alpha TO wbadm;
4107 GRANT USAGE ON SCHEMA alpha TO alpha;
4108 GRANT USAGE ON SCHEMA alpha TO wb_all;
4109 GRANT USAGE ON SCHEMA alpha TO wb_security;
4113 -- Name: alpha_public; Type: ACL; Schema: -; Owner: wbadm
4116 REVOKE ALL ON SCHEMA alpha_public FROM PUBLIC;
4117 REVOKE ALL ON SCHEMA alpha_public FROM wbadm;
4118 GRANT ALL ON SCHEMA alpha_public TO wbadm;
4119 GRANT USAGE ON SCHEMA alpha_public TO alpha;
4120 GRANT USAGE ON SCHEMA alpha_public TO PUBLIC;
4124 -- Name: amd64; Type: ACL; Schema: -; Owner: wbadm
4127 REVOKE ALL ON SCHEMA amd64 FROM PUBLIC;
4128 REVOKE ALL ON SCHEMA amd64 FROM wbadm;
4129 GRANT ALL ON SCHEMA amd64 TO wbadm;
4130 GRANT USAGE ON SCHEMA amd64 TO amd64;
4131 GRANT USAGE ON SCHEMA amd64 TO wb_all;
4132 GRANT USAGE ON SCHEMA amd64 TO wb_security;
4136 -- Name: amd64_public; Type: ACL; Schema: -; Owner: wbadm
4139 REVOKE ALL ON SCHEMA amd64_public FROM PUBLIC;
4140 REVOKE ALL ON SCHEMA amd64_public FROM wbadm;
4141 GRANT ALL ON SCHEMA amd64_public TO wbadm;
4142 GRANT USAGE ON SCHEMA amd64_public TO amd64;
4143 GRANT USAGE ON SCHEMA amd64_public TO PUBLIC;
4147 -- Name: arm; Type: ACL; Schema: -; Owner: wbadm
4150 REVOKE ALL ON SCHEMA arm FROM PUBLIC;
4151 REVOKE ALL ON SCHEMA arm FROM wbadm;
4152 GRANT ALL ON SCHEMA arm TO wbadm;
4153 GRANT USAGE ON SCHEMA arm TO arm;
4154 GRANT USAGE ON SCHEMA arm TO wb_all;
4155 GRANT USAGE ON SCHEMA arm TO wb_security;
4159 -- Name: arm_public; Type: ACL; Schema: -; Owner: wbadm
4162 REVOKE ALL ON SCHEMA arm_public FROM PUBLIC;
4163 REVOKE ALL ON SCHEMA arm_public FROM wbadm;
4164 GRANT ALL ON SCHEMA arm_public TO wbadm;
4165 GRANT USAGE ON SCHEMA arm_public TO arm;
4166 GRANT USAGE ON SCHEMA arm_public TO PUBLIC;
4170 -- Name: armel; Type: ACL; Schema: -; Owner: wbadm
4173 REVOKE ALL ON SCHEMA armel FROM PUBLIC;
4174 REVOKE ALL ON SCHEMA armel FROM wbadm;
4175 GRANT ALL ON SCHEMA armel TO wbadm;
4176 GRANT USAGE ON SCHEMA armel TO armel;
4177 GRANT USAGE ON SCHEMA armel TO wb_all;
4178 GRANT USAGE ON SCHEMA armel TO wb_security;
4182 -- Name: armel_public; Type: ACL; Schema: -; Owner: wbadm
4185 REVOKE ALL ON SCHEMA armel_public FROM PUBLIC;
4186 REVOKE ALL ON SCHEMA armel_public FROM wbadm;
4187 GRANT ALL ON SCHEMA armel_public TO wbadm;
4188 GRANT USAGE ON SCHEMA armel_public TO armel;
4189 GRANT USAGE ON SCHEMA armel_public TO PUBLIC;
4193 -- Name: hppa; Type: ACL; Schema: -; Owner: wbadm
4196 REVOKE ALL ON SCHEMA hppa FROM PUBLIC;
4197 REVOKE ALL ON SCHEMA hppa FROM wbadm;
4198 GRANT ALL ON SCHEMA hppa TO wbadm;
4199 GRANT USAGE ON SCHEMA hppa TO hppa;
4200 GRANT USAGE ON SCHEMA hppa TO wb_all;
4201 GRANT USAGE ON SCHEMA hppa TO wb_security;
4205 -- Name: hppa_public; Type: ACL; Schema: -; Owner: wbadm
4208 REVOKE ALL ON SCHEMA hppa_public FROM PUBLIC;
4209 REVOKE ALL ON SCHEMA hppa_public FROM wbadm;
4210 GRANT ALL ON SCHEMA hppa_public TO wbadm;
4211 GRANT USAGE ON SCHEMA hppa_public TO hppa;
4212 GRANT USAGE ON SCHEMA hppa_public TO PUBLIC;
4216 -- Name: hurd-i386; Type: ACL; Schema: -; Owner: wbadm
4219 REVOKE ALL ON SCHEMA "hurd-i386" FROM PUBLIC;
4220 REVOKE ALL ON SCHEMA "hurd-i386" FROM wbadm;
4221 GRANT ALL ON SCHEMA "hurd-i386" TO wbadm;
4222 GRANT USAGE ON SCHEMA "hurd-i386" TO "hurd-i386";
4223 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_all;
4224 GRANT USAGE ON SCHEMA "hurd-i386" TO wb_security;
4228 -- Name: hurd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4231 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM PUBLIC;
4232 REVOKE ALL ON SCHEMA "hurd-i386_public" FROM wbadm;
4233 GRANT ALL ON SCHEMA "hurd-i386_public" TO wbadm;
4234 GRANT USAGE ON SCHEMA "hurd-i386_public" TO "hurd-i386";
4235 GRANT USAGE ON SCHEMA "hurd-i386_public" TO PUBLIC;
4239 -- Name: i386; Type: ACL; Schema: -; Owner: wbadm
4242 REVOKE ALL ON SCHEMA i386 FROM PUBLIC;
4243 REVOKE ALL ON SCHEMA i386 FROM wbadm;
4244 GRANT ALL ON SCHEMA i386 TO wbadm;
4245 GRANT USAGE ON SCHEMA i386 TO i386;
4246 GRANT USAGE ON SCHEMA i386 TO wb_all;
4247 GRANT USAGE ON SCHEMA i386 TO wb_security;
4251 -- Name: i386_public; Type: ACL; Schema: -; Owner: wbadm
4254 REVOKE ALL ON SCHEMA i386_public FROM PUBLIC;
4255 REVOKE ALL ON SCHEMA i386_public FROM wbadm;
4256 GRANT ALL ON SCHEMA i386_public TO wbadm;
4257 GRANT USAGE ON SCHEMA i386_public TO i386;
4258 GRANT USAGE ON SCHEMA i386_public TO PUBLIC;
4262 -- Name: ia64; Type: ACL; Schema: -; Owner: wbadm
4265 REVOKE ALL ON SCHEMA ia64 FROM PUBLIC;
4266 REVOKE ALL ON SCHEMA ia64 FROM wbadm;
4267 GRANT ALL ON SCHEMA ia64 TO wbadm;
4268 GRANT USAGE ON SCHEMA ia64 TO ia64;
4269 GRANT USAGE ON SCHEMA ia64 TO wb_all;
4270 GRANT USAGE ON SCHEMA ia64 TO wb_security;
4274 -- Name: ia64_public; Type: ACL; Schema: -; Owner: wbadm
4277 REVOKE ALL ON SCHEMA ia64_public FROM PUBLIC;
4278 REVOKE ALL ON SCHEMA ia64_public FROM wbadm;
4279 GRANT ALL ON SCHEMA ia64_public TO wbadm;
4280 GRANT USAGE ON SCHEMA ia64_public TO ia64;
4281 GRANT USAGE ON SCHEMA ia64_public TO PUBLIC;
4285 -- Name: kfreebsd-amd64; Type: ACL; Schema: -; Owner: wbadm
4288 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM PUBLIC;
4289 REVOKE ALL ON SCHEMA "kfreebsd-amd64" FROM wbadm;
4290 GRANT ALL ON SCHEMA "kfreebsd-amd64" TO wbadm;
4291 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO "kfreebsd-amd64";
4292 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_all;
4293 GRANT USAGE ON SCHEMA "kfreebsd-amd64" TO wb_security;
4297 -- Name: kfreebsd-amd64_public; Type: ACL; Schema: -; Owner: wbadm
4300 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM PUBLIC;
4301 REVOKE ALL ON SCHEMA "kfreebsd-amd64_public" FROM wbadm;
4302 GRANT ALL ON SCHEMA "kfreebsd-amd64_public" TO wbadm;
4303 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO "kfreebsd-amd64";
4304 GRANT USAGE ON SCHEMA "kfreebsd-amd64_public" TO PUBLIC;
4308 -- Name: kfreebsd-i386; Type: ACL; Schema: -; Owner: wbadm
4311 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM PUBLIC;
4312 REVOKE ALL ON SCHEMA "kfreebsd-i386" FROM wbadm;
4313 GRANT ALL ON SCHEMA "kfreebsd-i386" TO wbadm;
4314 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO "kfreebsd-i386";
4315 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_all;
4316 GRANT USAGE ON SCHEMA "kfreebsd-i386" TO wb_security;
4320 -- Name: kfreebsd-i386_public; Type: ACL; Schema: -; Owner: wbadm
4323 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM PUBLIC;
4324 REVOKE ALL ON SCHEMA "kfreebsd-i386_public" FROM wbadm;
4325 GRANT ALL ON SCHEMA "kfreebsd-i386_public" TO wbadm;
4326 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO "kfreebsd-i386";
4327 GRANT USAGE ON SCHEMA "kfreebsd-i386_public" TO PUBLIC;
4331 -- Name: mips; Type: ACL; Schema: -; Owner: wbadm
4334 REVOKE ALL ON SCHEMA mips FROM PUBLIC;
4335 REVOKE ALL ON SCHEMA mips FROM wbadm;
4336 GRANT ALL ON SCHEMA mips TO wbadm;
4337 GRANT USAGE ON SCHEMA mips TO mips;
4338 GRANT USAGE ON SCHEMA mips TO wb_all;
4339 GRANT USAGE ON SCHEMA mips TO wb_security;
4343 -- Name: mips_public; Type: ACL; Schema: -; Owner: wbadm
4346 REVOKE ALL ON SCHEMA mips_public FROM PUBLIC;
4347 REVOKE ALL ON SCHEMA mips_public FROM wbadm;
4348 GRANT ALL ON SCHEMA mips_public TO wbadm;
4349 GRANT USAGE ON SCHEMA mips_public TO mips;
4350 GRANT USAGE ON SCHEMA mips_public TO PUBLIC;
4354 -- Name: mipsel; Type: ACL; Schema: -; Owner: wbadm
4357 REVOKE ALL ON SCHEMA mipsel FROM PUBLIC;
4358 REVOKE ALL ON SCHEMA mipsel FROM wbadm;
4359 GRANT ALL ON SCHEMA mipsel TO wbadm;
4360 GRANT USAGE ON SCHEMA mipsel TO mipsel;
4361 GRANT USAGE ON SCHEMA mipsel TO wb_all;
4362 GRANT USAGE ON SCHEMA mipsel TO wb_security;
4366 -- Name: mipsel_public; Type: ACL; Schema: -; Owner: wbadm
4369 REVOKE ALL ON SCHEMA mipsel_public FROM PUBLIC;
4370 REVOKE ALL ON SCHEMA mipsel_public FROM wbadm;
4371 GRANT ALL ON SCHEMA mipsel_public TO wbadm;
4372 GRANT USAGE ON SCHEMA mipsel_public TO mipsel;
4373 GRANT USAGE ON SCHEMA mipsel_public TO PUBLIC;
4377 -- Name: powerpc; Type: ACL; Schema: -; Owner: wbadm
4380 REVOKE ALL ON SCHEMA powerpc FROM PUBLIC;
4381 REVOKE ALL ON SCHEMA powerpc FROM wbadm;
4382 GRANT ALL ON SCHEMA powerpc TO wbadm;
4383 GRANT USAGE ON SCHEMA powerpc TO powerpc;
4384 GRANT USAGE ON SCHEMA powerpc TO wb_all;
4385 GRANT USAGE ON SCHEMA powerpc TO wb_security;
4389 -- Name: powerpc_public; Type: ACL; Schema: -; Owner: wbadm
4392 REVOKE ALL ON SCHEMA powerpc_public FROM PUBLIC;
4393 REVOKE ALL ON SCHEMA powerpc_public FROM wbadm;
4394 GRANT ALL ON SCHEMA powerpc_public TO wbadm;
4395 GRANT USAGE ON SCHEMA powerpc_public TO powerpc;
4396 GRANT USAGE ON SCHEMA powerpc_public TO PUBLIC;
4400 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4403 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4404 REVOKE ALL ON SCHEMA public FROM postgres;
4405 GRANT ALL ON SCHEMA public TO postgres;
4406 GRANT ALL ON SCHEMA public TO PUBLIC;
4410 -- Name: s390; Type: ACL; Schema: -; Owner: wbadm
4413 REVOKE ALL ON SCHEMA s390 FROM PUBLIC;
4414 REVOKE ALL ON SCHEMA s390 FROM wbadm;
4415 GRANT ALL ON SCHEMA s390 TO wbadm;
4416 GRANT USAGE ON SCHEMA s390 TO s390;
4417 GRANT USAGE ON SCHEMA s390 TO wb_all;
4418 GRANT USAGE ON SCHEMA s390 TO wb_security;
4422 -- Name: s390_public; Type: ACL; Schema: -; Owner: wbadm
4425 REVOKE ALL ON SCHEMA s390_public FROM PUBLIC;
4426 REVOKE ALL ON SCHEMA s390_public FROM wbadm;
4427 GRANT ALL ON SCHEMA s390_public TO wbadm;
4428 GRANT USAGE ON SCHEMA s390_public TO s390;
4429 GRANT USAGE ON SCHEMA s390_public TO PUBLIC;
4433 -- Name: sparc; Type: ACL; Schema: -; Owner: wbadm
4436 REVOKE ALL ON SCHEMA sparc FROM PUBLIC;
4437 REVOKE ALL ON SCHEMA sparc FROM wbadm;
4438 GRANT ALL ON SCHEMA sparc TO wbadm;
4439 GRANT USAGE ON SCHEMA sparc TO sparc;
4440 GRANT USAGE ON SCHEMA sparc TO wb_all;
4441 GRANT USAGE ON SCHEMA sparc TO wb_security;
4445 -- Name: sparc_public; Type: ACL; Schema: -; Owner: wbadm
4448 REVOKE ALL ON SCHEMA sparc_public FROM PUBLIC;
4449 REVOKE ALL ON SCHEMA sparc_public FROM wbadm;
4450 GRANT ALL ON SCHEMA sparc_public TO wbadm;
4451 GRANT USAGE ON SCHEMA sparc_public TO sparc;
4452 GRANT USAGE ON SCHEMA sparc_public TO PUBLIC;
4455 SET search_path = alpha, pg_catalog;
4458 -- Name: packages; Type: ACL; Schema: alpha; Owner: wbadm
4461 REVOKE ALL ON TABLE packages FROM PUBLIC;
4462 REVOKE ALL ON TABLE packages FROM wbadm;
4463 GRANT ALL ON TABLE packages TO wbadm;
4464 GRANT ALL ON TABLE packages TO alpha;
4465 GRANT SELECT ON TABLE packages TO wb_security;
4469 -- Name: pkg_history; Type: ACL; Schema: alpha; Owner: wbadm
4472 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4473 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4474 GRANT ALL ON TABLE pkg_history TO wbadm;
4475 GRANT ALL ON TABLE pkg_history TO alpha;
4476 GRANT SELECT ON TABLE pkg_history TO wb_security;
4480 -- Name: transactions; Type: ACL; Schema: alpha; Owner: wbadm
4483 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4484 REVOKE ALL ON TABLE transactions FROM wbadm;
4485 GRANT ALL ON TABLE transactions TO wbadm;
4486 GRANT SELECT,INSERT ON TABLE transactions TO alpha;
4487 GRANT SELECT ON TABLE transactions TO wb_security;
4491 -- Name: users; Type: ACL; Schema: alpha; Owner: wbadm
4494 REVOKE ALL ON TABLE users FROM PUBLIC;
4495 REVOKE ALL ON TABLE users FROM wbadm;
4496 GRANT ALL ON TABLE users TO wbadm;
4497 GRANT ALL ON TABLE users TO alpha;
4500 SET search_path = alpha_public, pg_catalog;
4503 -- Name: packages; Type: ACL; Schema: alpha_public; Owner: wbadm
4506 REVOKE ALL ON TABLE packages FROM PUBLIC;
4507 REVOKE ALL ON TABLE packages FROM wbadm;
4508 GRANT ALL ON TABLE packages TO wbadm;
4509 GRANT SELECT ON TABLE packages TO PUBLIC;
4513 -- Name: pkg_history; Type: ACL; Schema: alpha_public; Owner: wbadm
4516 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4517 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4518 GRANT ALL ON TABLE pkg_history TO wbadm;
4519 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4523 -- Name: transactions; Type: ACL; Schema: alpha_public; Owner: wbadm
4526 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4527 REVOKE ALL ON TABLE transactions FROM wbadm;
4528 GRANT ALL ON TABLE transactions TO wbadm;
4529 GRANT SELECT ON TABLE transactions TO PUBLIC;
4533 -- Name: users; Type: ACL; Schema: alpha_public; Owner: wbadm
4536 REVOKE ALL ON TABLE users FROM PUBLIC;
4537 REVOKE ALL ON TABLE users FROM wbadm;
4538 GRANT ALL ON TABLE users TO wbadm;
4539 GRANT SELECT ON TABLE users TO PUBLIC;
4542 SET search_path = amd64, pg_catalog;
4545 -- Name: packages; Type: ACL; Schema: amd64; Owner: wbadm
4548 REVOKE ALL ON TABLE packages FROM PUBLIC;
4549 REVOKE ALL ON TABLE packages FROM wbadm;
4550 GRANT ALL ON TABLE packages TO wbadm;
4551 GRANT ALL ON TABLE packages TO amd64;
4552 GRANT SELECT ON TABLE packages TO wb_security;
4556 -- Name: pkg_history; Type: ACL; Schema: amd64; Owner: wbadm
4559 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4560 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4561 GRANT ALL ON TABLE pkg_history TO wbadm;
4562 GRANT ALL ON TABLE pkg_history TO amd64;
4563 GRANT SELECT ON TABLE pkg_history TO wb_security;
4567 -- Name: transactions; Type: ACL; Schema: amd64; Owner: wbadm
4570 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4571 REVOKE ALL ON TABLE transactions FROM wbadm;
4572 GRANT ALL ON TABLE transactions TO wbadm;
4573 GRANT SELECT,INSERT ON TABLE transactions TO amd64;
4574 GRANT SELECT ON TABLE transactions TO wb_security;
4578 -- Name: users; Type: ACL; Schema: amd64; Owner: wbadm
4581 REVOKE ALL ON TABLE users FROM PUBLIC;
4582 REVOKE ALL ON TABLE users FROM wbadm;
4583 GRANT ALL ON TABLE users TO wbadm;
4584 GRANT ALL ON TABLE users TO amd64;
4587 SET search_path = amd64_public, pg_catalog;
4590 -- Name: packages; Type: ACL; Schema: amd64_public; Owner: wbadm
4593 REVOKE ALL ON TABLE packages FROM PUBLIC;
4594 REVOKE ALL ON TABLE packages FROM wbadm;
4595 GRANT ALL ON TABLE packages TO wbadm;
4596 GRANT SELECT ON TABLE packages TO PUBLIC;
4600 -- Name: pkg_history; Type: ACL; Schema: amd64_public; Owner: wbadm
4603 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4604 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4605 GRANT ALL ON TABLE pkg_history TO wbadm;
4606 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4610 -- Name: transactions; Type: ACL; Schema: amd64_public; Owner: wbadm
4613 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4614 REVOKE ALL ON TABLE transactions FROM wbadm;
4615 GRANT ALL ON TABLE transactions TO wbadm;
4616 GRANT SELECT ON TABLE transactions TO PUBLIC;
4620 -- Name: users; Type: ACL; Schema: amd64_public; Owner: wbadm
4623 REVOKE ALL ON TABLE users FROM PUBLIC;
4624 REVOKE ALL ON TABLE users FROM wbadm;
4625 GRANT ALL ON TABLE users TO wbadm;
4626 GRANT SELECT ON TABLE users TO PUBLIC;
4629 SET search_path = arm, pg_catalog;
4632 -- Name: packages; Type: ACL; Schema: arm; Owner: wbadm
4635 REVOKE ALL ON TABLE packages FROM PUBLIC;
4636 REVOKE ALL ON TABLE packages FROM wbadm;
4637 GRANT ALL ON TABLE packages TO wbadm;
4638 GRANT ALL ON TABLE packages TO arm;
4639 GRANT SELECT ON TABLE packages TO wb_security;
4643 -- Name: pkg_history; Type: ACL; Schema: arm; Owner: wbadm
4646 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4647 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4648 GRANT ALL ON TABLE pkg_history TO wbadm;
4649 GRANT ALL ON TABLE pkg_history TO arm;
4650 GRANT SELECT ON TABLE pkg_history TO wb_security;
4654 -- Name: transactions; Type: ACL; Schema: arm; Owner: wbadm
4657 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4658 REVOKE ALL ON TABLE transactions FROM wbadm;
4659 GRANT ALL ON TABLE transactions TO wbadm;
4660 GRANT SELECT,INSERT ON TABLE transactions TO arm;
4661 GRANT SELECT ON TABLE transactions TO wb_security;
4665 -- Name: users; Type: ACL; Schema: arm; Owner: wbadm
4668 REVOKE ALL ON TABLE users FROM PUBLIC;
4669 REVOKE ALL ON TABLE users FROM wbadm;
4670 GRANT ALL ON TABLE users TO wbadm;
4671 GRANT ALL ON TABLE users TO arm;
4674 SET search_path = arm_public, pg_catalog;
4677 -- Name: packages; Type: ACL; Schema: arm_public; Owner: wbadm
4680 REVOKE ALL ON TABLE packages FROM PUBLIC;
4681 REVOKE ALL ON TABLE packages FROM wbadm;
4682 GRANT ALL ON TABLE packages TO wbadm;
4683 GRANT SELECT ON TABLE packages TO PUBLIC;
4687 -- Name: pkg_history; Type: ACL; Schema: arm_public; Owner: wbadm
4690 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4691 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4692 GRANT ALL ON TABLE pkg_history TO wbadm;
4693 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4697 -- Name: transactions; Type: ACL; Schema: arm_public; Owner: wbadm
4700 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4701 REVOKE ALL ON TABLE transactions FROM wbadm;
4702 GRANT ALL ON TABLE transactions TO wbadm;
4703 GRANT SELECT ON TABLE transactions TO PUBLIC;
4707 -- Name: users; Type: ACL; Schema: arm_public; Owner: wbadm
4710 REVOKE ALL ON TABLE users FROM PUBLIC;
4711 REVOKE ALL ON TABLE users FROM wbadm;
4712 GRANT ALL ON TABLE users TO wbadm;
4713 GRANT SELECT ON TABLE users TO PUBLIC;
4716 SET search_path = armel, pg_catalog;
4719 -- Name: packages; Type: ACL; Schema: armel; Owner: wbadm
4722 REVOKE ALL ON TABLE packages FROM PUBLIC;
4723 REVOKE ALL ON TABLE packages FROM wbadm;
4724 GRANT ALL ON TABLE packages TO wbadm;
4725 GRANT ALL ON TABLE packages TO armel;
4726 GRANT SELECT ON TABLE packages TO wb_security;
4730 -- Name: pkg_history; Type: ACL; Schema: armel; Owner: wbadm
4733 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4734 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4735 GRANT ALL ON TABLE pkg_history TO wbadm;
4736 GRANT ALL ON TABLE pkg_history TO armel;
4737 GRANT SELECT ON TABLE pkg_history TO wb_security;
4741 -- Name: transactions; Type: ACL; Schema: armel; Owner: wbadm
4744 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4745 REVOKE ALL ON TABLE transactions FROM wbadm;
4746 GRANT ALL ON TABLE transactions TO wbadm;
4747 GRANT SELECT,INSERT ON TABLE transactions TO armel;
4748 GRANT SELECT ON TABLE transactions TO wb_security;
4752 -- Name: users; Type: ACL; Schema: armel; Owner: wbadm
4755 REVOKE ALL ON TABLE users FROM PUBLIC;
4756 REVOKE ALL ON TABLE users FROM wbadm;
4757 GRANT ALL ON TABLE users TO wbadm;
4758 GRANT ALL ON TABLE users TO armel;
4761 SET search_path = armel_public, pg_catalog;
4764 -- Name: packages; Type: ACL; Schema: armel_public; Owner: wbadm
4767 REVOKE ALL ON TABLE packages FROM PUBLIC;
4768 REVOKE ALL ON TABLE packages FROM wbadm;
4769 GRANT ALL ON TABLE packages TO wbadm;
4770 GRANT SELECT ON TABLE packages TO PUBLIC;
4774 -- Name: pkg_history; Type: ACL; Schema: armel_public; Owner: wbadm
4777 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4778 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4779 GRANT ALL ON TABLE pkg_history TO wbadm;
4780 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4784 -- Name: transactions; Type: ACL; Schema: armel_public; Owner: wbadm
4787 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4788 REVOKE ALL ON TABLE transactions FROM wbadm;
4789 GRANT ALL ON TABLE transactions TO wbadm;
4790 GRANT SELECT ON TABLE transactions TO PUBLIC;
4794 -- Name: users; Type: ACL; Schema: armel_public; Owner: wbadm
4797 REVOKE ALL ON TABLE users FROM PUBLIC;
4798 REVOKE ALL ON TABLE users FROM wbadm;
4799 GRANT ALL ON TABLE users TO wbadm;
4800 GRANT SELECT ON TABLE users TO PUBLIC;
4803 SET search_path = hppa, pg_catalog;
4806 -- Name: packages; Type: ACL; Schema: hppa; Owner: wbadm
4809 REVOKE ALL ON TABLE packages FROM PUBLIC;
4810 REVOKE ALL ON TABLE packages FROM wbadm;
4811 GRANT ALL ON TABLE packages TO wbadm;
4812 GRANT ALL ON TABLE packages TO hppa;
4813 GRANT SELECT ON TABLE packages TO wb_security;
4817 -- Name: pkg_history; Type: ACL; Schema: hppa; Owner: wbadm
4820 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4821 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4822 GRANT ALL ON TABLE pkg_history TO wbadm;
4823 GRANT ALL ON TABLE pkg_history TO hppa;
4824 GRANT SELECT ON TABLE pkg_history TO wb_security;
4828 -- Name: transactions; Type: ACL; Schema: hppa; Owner: wbadm
4831 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4832 REVOKE ALL ON TABLE transactions FROM wbadm;
4833 GRANT ALL ON TABLE transactions TO wbadm;
4834 GRANT SELECT,INSERT ON TABLE transactions TO hppa;
4835 GRANT SELECT ON TABLE transactions TO wb_security;
4839 -- Name: users; Type: ACL; Schema: hppa; Owner: wbadm
4842 REVOKE ALL ON TABLE users FROM PUBLIC;
4843 REVOKE ALL ON TABLE users FROM wbadm;
4844 GRANT ALL ON TABLE users TO wbadm;
4845 GRANT ALL ON TABLE users TO hppa;
4848 SET search_path = hppa_public, pg_catalog;
4851 -- Name: packages; Type: ACL; Schema: hppa_public; Owner: wbadm
4854 REVOKE ALL ON TABLE packages FROM PUBLIC;
4855 REVOKE ALL ON TABLE packages FROM wbadm;
4856 GRANT ALL ON TABLE packages TO wbadm;
4857 GRANT SELECT ON TABLE packages TO PUBLIC;
4861 -- Name: pkg_history; Type: ACL; Schema: hppa_public; Owner: wbadm
4864 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4865 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4866 GRANT ALL ON TABLE pkg_history TO wbadm;
4867 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4871 -- Name: transactions; Type: ACL; Schema: hppa_public; Owner: wbadm
4874 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4875 REVOKE ALL ON TABLE transactions FROM wbadm;
4876 GRANT ALL ON TABLE transactions TO wbadm;
4877 GRANT SELECT ON TABLE transactions TO PUBLIC;
4881 -- Name: users; Type: ACL; Schema: hppa_public; Owner: wbadm
4884 REVOKE ALL ON TABLE users FROM PUBLIC;
4885 REVOKE ALL ON TABLE users FROM wbadm;
4886 GRANT ALL ON TABLE users TO wbadm;
4887 GRANT SELECT ON TABLE users TO PUBLIC;
4890 SET search_path = "hurd-i386", pg_catalog;
4893 -- Name: packages; Type: ACL; Schema: hurd-i386; Owner: wbadm
4896 REVOKE ALL ON TABLE packages FROM PUBLIC;
4897 REVOKE ALL ON TABLE packages FROM wbadm;
4898 GRANT ALL ON TABLE packages TO wbadm;
4899 GRANT ALL ON TABLE packages TO "hurd-i386";
4900 GRANT SELECT ON TABLE packages TO wb_security;
4904 -- Name: pkg_history; Type: ACL; Schema: hurd-i386; Owner: wbadm
4907 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4908 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4909 GRANT ALL ON TABLE pkg_history TO wbadm;
4910 GRANT ALL ON TABLE pkg_history TO "hurd-i386";
4911 GRANT SELECT ON TABLE pkg_history TO wb_security;
4915 -- Name: transactions; Type: ACL; Schema: hurd-i386; Owner: wbadm
4918 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4919 REVOKE ALL ON TABLE transactions FROM wbadm;
4920 GRANT ALL ON TABLE transactions TO wbadm;
4921 GRANT SELECT,INSERT ON TABLE transactions TO "hurd-i386";
4922 GRANT SELECT ON TABLE transactions TO wb_security;
4926 -- Name: users; Type: ACL; Schema: hurd-i386; Owner: wbadm
4929 REVOKE ALL ON TABLE users FROM PUBLIC;
4930 REVOKE ALL ON TABLE users FROM wbadm;
4931 GRANT ALL ON TABLE users TO wbadm;
4932 GRANT ALL ON TABLE users TO "hurd-i386";
4935 SET search_path = "hurd-i386_public", pg_catalog;
4938 -- Name: packages; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4941 REVOKE ALL ON TABLE packages FROM PUBLIC;
4942 REVOKE ALL ON TABLE packages FROM wbadm;
4943 GRANT ALL ON TABLE packages TO wbadm;
4944 GRANT SELECT ON TABLE packages TO PUBLIC;
4948 -- Name: pkg_history; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4951 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4952 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4953 GRANT ALL ON TABLE pkg_history TO wbadm;
4954 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
4958 -- Name: transactions; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4961 REVOKE ALL ON TABLE transactions FROM PUBLIC;
4962 REVOKE ALL ON TABLE transactions FROM wbadm;
4963 GRANT ALL ON TABLE transactions TO wbadm;
4964 GRANT SELECT ON TABLE transactions TO PUBLIC;
4968 -- Name: users; Type: ACL; Schema: hurd-i386_public; Owner: wbadm
4971 REVOKE ALL ON TABLE users FROM PUBLIC;
4972 REVOKE ALL ON TABLE users FROM wbadm;
4973 GRANT ALL ON TABLE users TO wbadm;
4974 GRANT SELECT ON TABLE users TO PUBLIC;
4977 SET search_path = i386, pg_catalog;
4980 -- Name: packages; Type: ACL; Schema: i386; Owner: wbadm
4983 REVOKE ALL ON TABLE packages FROM PUBLIC;
4984 REVOKE ALL ON TABLE packages FROM wbadm;
4985 GRANT ALL ON TABLE packages TO wbadm;
4986 GRANT ALL ON TABLE packages TO i386;
4987 GRANT SELECT ON TABLE packages TO wb_security;
4991 -- Name: pkg_history; Type: ACL; Schema: i386; Owner: wbadm
4994 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
4995 REVOKE ALL ON TABLE pkg_history FROM wbadm;
4996 GRANT ALL ON TABLE pkg_history TO wbadm;
4997 GRANT ALL ON TABLE pkg_history TO i386;
4998 GRANT SELECT ON TABLE pkg_history TO wb_security;
5002 -- Name: transactions; Type: ACL; Schema: i386; Owner: wbadm
5005 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5006 REVOKE ALL ON TABLE transactions FROM wbadm;
5007 GRANT ALL ON TABLE transactions TO wbadm;
5008 GRANT SELECT,INSERT ON TABLE transactions TO i386;
5009 GRANT SELECT ON TABLE transactions TO wb_security;
5013 -- Name: users; Type: ACL; Schema: i386; Owner: wbadm
5016 REVOKE ALL ON TABLE users FROM PUBLIC;
5017 REVOKE ALL ON TABLE users FROM wbadm;
5018 GRANT ALL ON TABLE users TO wbadm;
5019 GRANT ALL ON TABLE users TO i386;
5022 SET search_path = i386_public, pg_catalog;
5025 -- Name: packages; Type: ACL; Schema: i386_public; Owner: wbadm
5028 REVOKE ALL ON TABLE packages FROM PUBLIC;
5029 REVOKE ALL ON TABLE packages FROM wbadm;
5030 GRANT ALL ON TABLE packages TO wbadm;
5031 GRANT SELECT ON TABLE packages TO PUBLIC;
5035 -- Name: pkg_history; Type: ACL; Schema: i386_public; Owner: wbadm
5038 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5039 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5040 GRANT ALL ON TABLE pkg_history TO wbadm;
5041 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5045 -- Name: transactions; Type: ACL; Schema: i386_public; Owner: wbadm
5048 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5049 REVOKE ALL ON TABLE transactions FROM wbadm;
5050 GRANT ALL ON TABLE transactions TO wbadm;
5051 GRANT SELECT ON TABLE transactions TO PUBLIC;
5055 -- Name: users; Type: ACL; Schema: i386_public; Owner: wbadm
5058 REVOKE ALL ON TABLE users FROM PUBLIC;
5059 REVOKE ALL ON TABLE users FROM wbadm;
5060 GRANT ALL ON TABLE users TO wbadm;
5061 GRANT SELECT ON TABLE users TO PUBLIC;
5064 SET search_path = ia64, pg_catalog;
5067 -- Name: packages; Type: ACL; Schema: ia64; Owner: wbadm
5070 REVOKE ALL ON TABLE packages FROM PUBLIC;
5071 REVOKE ALL ON TABLE packages FROM wbadm;
5072 GRANT ALL ON TABLE packages TO wbadm;
5073 GRANT ALL ON TABLE packages TO ia64;
5074 GRANT SELECT ON TABLE packages TO wb_security;
5078 -- Name: pkg_history; Type: ACL; Schema: ia64; Owner: wbadm
5081 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5082 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5083 GRANT ALL ON TABLE pkg_history TO wbadm;
5084 GRANT ALL ON TABLE pkg_history TO ia64;
5085 GRANT SELECT ON TABLE pkg_history TO wb_security;
5089 -- Name: transactions; Type: ACL; Schema: ia64; Owner: wbadm
5092 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5093 REVOKE ALL ON TABLE transactions FROM wbadm;
5094 GRANT ALL ON TABLE transactions TO wbadm;
5095 GRANT SELECT,INSERT ON TABLE transactions TO ia64;
5096 GRANT SELECT ON TABLE transactions TO wb_security;
5100 -- Name: users; Type: ACL; Schema: ia64; Owner: wbadm
5103 REVOKE ALL ON TABLE users FROM PUBLIC;
5104 REVOKE ALL ON TABLE users FROM wbadm;
5105 GRANT ALL ON TABLE users TO wbadm;
5106 GRANT ALL ON TABLE users TO ia64;
5109 SET search_path = ia64_public, pg_catalog;
5112 -- Name: packages; Type: ACL; Schema: ia64_public; Owner: wbadm
5115 REVOKE ALL ON TABLE packages FROM PUBLIC;
5116 REVOKE ALL ON TABLE packages FROM wbadm;
5117 GRANT ALL ON TABLE packages TO wbadm;
5118 GRANT SELECT ON TABLE packages TO PUBLIC;
5122 -- Name: pkg_history; Type: ACL; Schema: ia64_public; Owner: wbadm
5125 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5126 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5127 GRANT ALL ON TABLE pkg_history TO wbadm;
5128 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5132 -- Name: transactions; Type: ACL; Schema: ia64_public; Owner: wbadm
5135 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5136 REVOKE ALL ON TABLE transactions FROM wbadm;
5137 GRANT ALL ON TABLE transactions TO wbadm;
5138 GRANT SELECT ON TABLE transactions TO PUBLIC;
5142 -- Name: users; Type: ACL; Schema: ia64_public; Owner: wbadm
5145 REVOKE ALL ON TABLE users FROM PUBLIC;
5146 REVOKE ALL ON TABLE users FROM wbadm;
5147 GRANT ALL ON TABLE users TO wbadm;
5148 GRANT SELECT ON TABLE users TO PUBLIC;
5151 SET search_path = "kfreebsd-amd64", pg_catalog;
5154 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5157 REVOKE ALL ON TABLE packages FROM PUBLIC;
5158 REVOKE ALL ON TABLE packages FROM wbadm;
5159 GRANT ALL ON TABLE packages TO wbadm;
5160 GRANT ALL ON TABLE packages TO "kfreebsd-amd64";
5161 GRANT SELECT ON TABLE packages TO wb_security;
5165 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5168 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5169 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5170 GRANT ALL ON TABLE pkg_history TO wbadm;
5171 GRANT ALL ON TABLE pkg_history TO "kfreebsd-amd64";
5172 GRANT SELECT ON TABLE pkg_history TO wb_security;
5176 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5179 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5180 REVOKE ALL ON TABLE transactions FROM wbadm;
5181 GRANT ALL ON TABLE transactions TO wbadm;
5182 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-amd64";
5183 GRANT SELECT ON TABLE transactions TO wb_security;
5187 -- Name: users; Type: ACL; Schema: kfreebsd-amd64; Owner: wbadm
5190 REVOKE ALL ON TABLE users FROM PUBLIC;
5191 REVOKE ALL ON TABLE users FROM wbadm;
5192 GRANT ALL ON TABLE users TO wbadm;
5193 GRANT ALL ON TABLE users TO "kfreebsd-amd64";
5196 SET search_path = "kfreebsd-amd64_public", pg_catalog;
5199 -- Name: packages; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5202 REVOKE ALL ON TABLE packages FROM PUBLIC;
5203 REVOKE ALL ON TABLE packages FROM wbadm;
5204 GRANT ALL ON TABLE packages TO wbadm;
5205 GRANT SELECT ON TABLE packages TO PUBLIC;
5209 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5212 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5213 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5214 GRANT ALL ON TABLE pkg_history TO wbadm;
5215 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5219 -- Name: transactions; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5222 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5223 REVOKE ALL ON TABLE transactions FROM wbadm;
5224 GRANT ALL ON TABLE transactions TO wbadm;
5225 GRANT SELECT ON TABLE transactions TO PUBLIC;
5229 -- Name: users; Type: ACL; Schema: kfreebsd-amd64_public; Owner: wbadm
5232 REVOKE ALL ON TABLE users FROM PUBLIC;
5233 REVOKE ALL ON TABLE users FROM wbadm;
5234 GRANT ALL ON TABLE users TO wbadm;
5235 GRANT SELECT ON TABLE users TO PUBLIC;
5238 SET search_path = "kfreebsd-i386", pg_catalog;
5241 -- Name: packages; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5244 REVOKE ALL ON TABLE packages FROM PUBLIC;
5245 REVOKE ALL ON TABLE packages FROM wbadm;
5246 GRANT ALL ON TABLE packages TO wbadm;
5247 GRANT ALL ON TABLE packages TO "kfreebsd-i386";
5248 GRANT SELECT ON TABLE packages TO wb_security;
5252 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5255 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5256 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5257 GRANT ALL ON TABLE pkg_history TO wbadm;
5258 GRANT ALL ON TABLE pkg_history TO "kfreebsd-i386";
5259 GRANT SELECT ON TABLE pkg_history TO wb_security;
5263 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5266 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5267 REVOKE ALL ON TABLE transactions FROM wbadm;
5268 GRANT ALL ON TABLE transactions TO wbadm;
5269 GRANT SELECT,INSERT ON TABLE transactions TO "kfreebsd-i386";
5270 GRANT SELECT ON TABLE transactions TO wb_security;
5274 -- Name: users; Type: ACL; Schema: kfreebsd-i386; Owner: wbadm
5277 REVOKE ALL ON TABLE users FROM PUBLIC;
5278 REVOKE ALL ON TABLE users FROM wbadm;
5279 GRANT ALL ON TABLE users TO wbadm;
5280 GRANT ALL ON TABLE users TO "kfreebsd-i386";
5283 SET search_path = "kfreebsd-i386_public", pg_catalog;
5286 -- Name: packages; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5289 REVOKE ALL ON TABLE packages FROM PUBLIC;
5290 REVOKE ALL ON TABLE packages FROM wbadm;
5291 GRANT ALL ON TABLE packages TO wbadm;
5292 GRANT SELECT ON TABLE packages TO PUBLIC;
5296 -- Name: pkg_history; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5299 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5300 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5301 GRANT ALL ON TABLE pkg_history TO wbadm;
5302 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5306 -- Name: transactions; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5309 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5310 REVOKE ALL ON TABLE transactions FROM wbadm;
5311 GRANT ALL ON TABLE transactions TO wbadm;
5312 GRANT SELECT ON TABLE transactions TO PUBLIC;
5316 -- Name: users; Type: ACL; Schema: kfreebsd-i386_public; Owner: wbadm
5319 REVOKE ALL ON TABLE users FROM PUBLIC;
5320 REVOKE ALL ON TABLE users FROM wbadm;
5321 GRANT ALL ON TABLE users TO wbadm;
5322 GRANT SELECT ON TABLE users TO PUBLIC;
5325 SET search_path = mips, pg_catalog;
5328 -- Name: packages; Type: ACL; Schema: mips; Owner: wbadm
5331 REVOKE ALL ON TABLE packages FROM PUBLIC;
5332 REVOKE ALL ON TABLE packages FROM wbadm;
5333 GRANT ALL ON TABLE packages TO wbadm;
5334 GRANT ALL ON TABLE packages TO mips;
5335 GRANT SELECT ON TABLE packages TO wb_security;
5339 -- Name: pkg_history; Type: ACL; Schema: mips; Owner: wbadm
5342 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5343 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5344 GRANT ALL ON TABLE pkg_history TO wbadm;
5345 GRANT ALL ON TABLE pkg_history TO mips;
5346 GRANT SELECT ON TABLE pkg_history TO wb_security;
5350 -- Name: transactions; Type: ACL; Schema: mips; Owner: wbadm
5353 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5354 REVOKE ALL ON TABLE transactions FROM wbadm;
5355 GRANT ALL ON TABLE transactions TO wbadm;
5356 GRANT SELECT,INSERT ON TABLE transactions TO mips;
5357 GRANT SELECT ON TABLE transactions TO wb_security;
5361 -- Name: users; Type: ACL; Schema: mips; Owner: wbadm
5364 REVOKE ALL ON TABLE users FROM PUBLIC;
5365 REVOKE ALL ON TABLE users FROM wbadm;
5366 GRANT ALL ON TABLE users TO wbadm;
5367 GRANT ALL ON TABLE users TO mips;
5370 SET search_path = mips_public, pg_catalog;
5373 -- Name: packages; Type: ACL; Schema: mips_public; Owner: wbadm
5376 REVOKE ALL ON TABLE packages FROM PUBLIC;
5377 REVOKE ALL ON TABLE packages FROM wbadm;
5378 GRANT ALL ON TABLE packages TO wbadm;
5379 GRANT SELECT ON TABLE packages TO PUBLIC;
5383 -- Name: pkg_history; Type: ACL; Schema: mips_public; Owner: wbadm
5386 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5387 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5388 GRANT ALL ON TABLE pkg_history TO wbadm;
5389 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5393 -- Name: transactions; Type: ACL; Schema: mips_public; Owner: wbadm
5396 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5397 REVOKE ALL ON TABLE transactions FROM wbadm;
5398 GRANT ALL ON TABLE transactions TO wbadm;
5399 GRANT SELECT ON TABLE transactions TO PUBLIC;
5403 -- Name: users; Type: ACL; Schema: mips_public; Owner: wbadm
5406 REVOKE ALL ON TABLE users FROM PUBLIC;
5407 REVOKE ALL ON TABLE users FROM wbadm;
5408 GRANT ALL ON TABLE users TO wbadm;
5409 GRANT SELECT ON TABLE users TO PUBLIC;
5412 SET search_path = mipsel, pg_catalog;
5415 -- Name: packages; Type: ACL; Schema: mipsel; Owner: wbadm
5418 REVOKE ALL ON TABLE packages FROM PUBLIC;
5419 REVOKE ALL ON TABLE packages FROM wbadm;
5420 GRANT ALL ON TABLE packages TO wbadm;
5421 GRANT ALL ON TABLE packages TO mipsel;
5422 GRANT SELECT ON TABLE packages TO wb_security;
5426 -- Name: pkg_history; Type: ACL; Schema: mipsel; Owner: wbadm
5429 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5430 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5431 GRANT ALL ON TABLE pkg_history TO wbadm;
5432 GRANT ALL ON TABLE pkg_history TO mipsel;
5433 GRANT SELECT ON TABLE pkg_history TO wb_security;
5437 -- Name: transactions; Type: ACL; Schema: mipsel; Owner: wbadm
5440 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5441 REVOKE ALL ON TABLE transactions FROM wbadm;
5442 GRANT ALL ON TABLE transactions TO wbadm;
5443 GRANT SELECT,INSERT ON TABLE transactions TO mipsel;
5444 GRANT SELECT ON TABLE transactions TO wb_security;
5448 -- Name: users; Type: ACL; Schema: mipsel; Owner: wbadm
5451 REVOKE ALL ON TABLE users FROM PUBLIC;
5452 REVOKE ALL ON TABLE users FROM wbadm;
5453 GRANT ALL ON TABLE users TO wbadm;
5454 GRANT ALL ON TABLE users TO mipsel;
5457 SET search_path = mipsel_public, pg_catalog;
5460 -- Name: packages; Type: ACL; Schema: mipsel_public; Owner: wbadm
5463 REVOKE ALL ON TABLE packages FROM PUBLIC;
5464 REVOKE ALL ON TABLE packages FROM wbadm;
5465 GRANT ALL ON TABLE packages TO wbadm;
5466 GRANT SELECT ON TABLE packages TO PUBLIC;
5470 -- Name: pkg_history; Type: ACL; Schema: mipsel_public; Owner: wbadm
5473 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5474 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5475 GRANT ALL ON TABLE pkg_history TO wbadm;
5476 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5480 -- Name: transactions; Type: ACL; Schema: mipsel_public; Owner: wbadm
5483 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5484 REVOKE ALL ON TABLE transactions FROM wbadm;
5485 GRANT ALL ON TABLE transactions TO wbadm;
5486 GRANT SELECT ON TABLE transactions TO PUBLIC;
5490 -- Name: users; Type: ACL; Schema: mipsel_public; Owner: wbadm
5493 REVOKE ALL ON TABLE users FROM PUBLIC;
5494 REVOKE ALL ON TABLE users FROM wbadm;
5495 GRANT ALL ON TABLE users TO wbadm;
5496 GRANT SELECT ON TABLE users TO PUBLIC;
5499 SET search_path = powerpc, pg_catalog;
5502 -- Name: packages; Type: ACL; Schema: powerpc; Owner: wbadm
5505 REVOKE ALL ON TABLE packages FROM PUBLIC;
5506 REVOKE ALL ON TABLE packages FROM wbadm;
5507 GRANT ALL ON TABLE packages TO wbadm;
5508 GRANT ALL ON TABLE packages TO powerpc;
5509 GRANT SELECT ON TABLE packages TO wb_security;
5513 -- Name: pkg_history; Type: ACL; Schema: powerpc; Owner: wbadm
5516 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5517 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5518 GRANT ALL ON TABLE pkg_history TO wbadm;
5519 GRANT ALL ON TABLE pkg_history TO powerpc;
5520 GRANT SELECT ON TABLE pkg_history TO wb_security;
5524 -- Name: transactions; Type: ACL; Schema: powerpc; Owner: wbadm
5527 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5528 REVOKE ALL ON TABLE transactions FROM wbadm;
5529 GRANT ALL ON TABLE transactions TO wbadm;
5530 GRANT SELECT,INSERT ON TABLE transactions TO powerpc;
5531 GRANT SELECT ON TABLE transactions TO wb_security;
5535 -- Name: users; Type: ACL; Schema: powerpc; Owner: wbadm
5538 REVOKE ALL ON TABLE users FROM PUBLIC;
5539 REVOKE ALL ON TABLE users FROM wbadm;
5540 GRANT ALL ON TABLE users TO wbadm;
5541 GRANT ALL ON TABLE users TO powerpc;
5544 SET search_path = powerpc_public, pg_catalog;
5547 -- Name: packages; Type: ACL; Schema: powerpc_public; Owner: wbadm
5550 REVOKE ALL ON TABLE packages FROM PUBLIC;
5551 REVOKE ALL ON TABLE packages FROM wbadm;
5552 GRANT ALL ON TABLE packages TO wbadm;
5553 GRANT SELECT ON TABLE packages TO PUBLIC;
5557 -- Name: pkg_history; Type: ACL; Schema: powerpc_public; Owner: wbadm
5560 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5561 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5562 GRANT ALL ON TABLE pkg_history TO wbadm;
5563 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5567 -- Name: transactions; Type: ACL; Schema: powerpc_public; Owner: wbadm
5570 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5571 REVOKE ALL ON TABLE transactions FROM wbadm;
5572 GRANT ALL ON TABLE transactions TO wbadm;
5573 GRANT SELECT ON TABLE transactions TO PUBLIC;
5577 -- Name: users; Type: ACL; Schema: powerpc_public; Owner: wbadm
5580 REVOKE ALL ON TABLE users FROM PUBLIC;
5581 REVOKE ALL ON TABLE users FROM wbadm;
5582 GRANT ALL ON TABLE users TO wbadm;
5583 GRANT SELECT ON TABLE users TO PUBLIC;
5586 SET search_path = public, pg_catalog;
5589 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
5592 REVOKE ALL ON TABLE distribution_aliases FROM PUBLIC;
5593 REVOKE ALL ON TABLE distribution_aliases FROM wbadm;
5594 GRANT ALL ON TABLE distribution_aliases TO wbadm;
5595 GRANT SELECT ON TABLE distribution_aliases TO PUBLIC;
5598 SET search_path = s390, pg_catalog;
5601 -- Name: packages; Type: ACL; Schema: s390; Owner: wbadm
5604 REVOKE ALL ON TABLE packages FROM PUBLIC;
5605 REVOKE ALL ON TABLE packages FROM wbadm;
5606 GRANT ALL ON TABLE packages TO wbadm;
5607 GRANT ALL ON TABLE packages TO s390;
5608 GRANT SELECT ON TABLE packages TO wb_security;
5611 SET search_path = sparc, pg_catalog;
5614 -- Name: packages; Type: ACL; Schema: sparc; Owner: wbadm
5617 REVOKE ALL ON TABLE packages FROM PUBLIC;
5618 REVOKE ALL ON TABLE packages FROM wbadm;
5619 GRANT ALL ON TABLE packages TO wbadm;
5620 GRANT ALL ON TABLE packages TO sparc;
5621 GRANT SELECT ON TABLE packages TO wb_security;
5624 SET search_path = public, pg_catalog;
5627 -- Name: distribution_architectures; Type: ACL; Schema: public; Owner: wbadm
5630 REVOKE ALL ON TABLE distribution_architectures FROM PUBLIC;
5631 REVOKE ALL ON TABLE distribution_architectures FROM wbadm;
5632 GRANT ALL ON TABLE distribution_architectures TO wbadm;
5633 GRANT SELECT ON TABLE distribution_architectures TO PUBLIC;
5637 -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm
5640 REVOKE ALL ON TABLE distributions FROM PUBLIC;
5641 REVOKE ALL ON TABLE distributions FROM wbadm;
5642 GRANT ALL ON TABLE distributions TO wbadm;
5643 GRANT SELECT ON TABLE distributions TO PUBLIC;
5646 SET search_path = s390, pg_catalog;
5649 -- Name: pkg_history; Type: ACL; Schema: s390; Owner: wbadm
5652 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5653 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5654 GRANT ALL ON TABLE pkg_history TO wbadm;
5655 GRANT ALL ON TABLE pkg_history TO s390;
5656 GRANT SELECT ON TABLE pkg_history TO wb_security;
5659 SET search_path = s390_public, pg_catalog;
5662 -- Name: pkg_history; Type: ACL; Schema: s390_public; Owner: wbadm
5665 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5666 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5667 GRANT ALL ON TABLE pkg_history TO wbadm;
5668 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5671 SET search_path = sparc, pg_catalog;
5674 -- Name: pkg_history; Type: ACL; Schema: sparc; Owner: wbadm
5677 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5678 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5679 GRANT ALL ON TABLE pkg_history TO wbadm;
5680 GRANT ALL ON TABLE pkg_history TO sparc;
5681 GRANT SELECT ON TABLE pkg_history TO wb_security;
5684 SET search_path = sparc_public, pg_catalog;
5687 -- Name: pkg_history; Type: ACL; Schema: sparc_public; Owner: wbadm
5690 REVOKE ALL ON TABLE pkg_history FROM PUBLIC;
5691 REVOKE ALL ON TABLE pkg_history FROM wbadm;
5692 GRANT ALL ON TABLE pkg_history TO wbadm;
5693 GRANT SELECT ON TABLE pkg_history TO PUBLIC;
5696 SET search_path = public, pg_catalog;
5699 -- Name: lastlog; Type: ACL; Schema: public; Owner: wbadm
5702 REVOKE ALL ON TABLE lastlog FROM PUBLIC;
5703 REVOKE ALL ON TABLE lastlog FROM wbadm;
5704 GRANT ALL ON TABLE lastlog TO wbadm;
5705 GRANT SELECT ON TABLE lastlog TO PUBLIC;
5709 -- Name: log; Type: ACL; Schema: public; Owner: wbadm
5712 REVOKE ALL ON TABLE log FROM PUBLIC;
5713 REVOKE ALL ON TABLE log FROM wbadm;
5714 GRANT ALL ON TABLE log TO wbadm;
5715 GRANT SELECT ON TABLE log TO PUBLIC;
5719 -- Name: log_v2; Type: ACL; Schema: public; Owner: pkern
5722 REVOKE ALL ON TABLE log_v2 FROM PUBLIC;
5723 REVOKE ALL ON TABLE log_v2 FROM pkern;
5724 GRANT ALL ON TABLE log_v2 TO pkern;
5725 GRANT SELECT ON TABLE log_v2 TO PUBLIC;
5728 SET search_path = s390_public, pg_catalog;
5731 -- Name: packages; Type: ACL; Schema: s390_public; Owner: wbadm
5734 REVOKE ALL ON TABLE packages FROM PUBLIC;
5735 REVOKE ALL ON TABLE packages FROM wbadm;
5736 GRANT ALL ON TABLE packages TO wbadm;
5737 GRANT SELECT ON TABLE packages TO PUBLIC;
5740 SET search_path = sparc_public, pg_catalog;
5743 -- Name: packages; Type: ACL; Schema: sparc_public; Owner: wbadm
5746 REVOKE ALL ON TABLE packages FROM PUBLIC;
5747 REVOKE ALL ON TABLE packages FROM wbadm;
5748 GRANT ALL ON TABLE packages TO wbadm;
5749 GRANT SELECT ON TABLE packages TO PUBLIC;
5752 SET search_path = public, pg_catalog;
5755 -- Name: packages_all; Type: ACL; Schema: public; Owner: wbadm
5758 REVOKE ALL ON TABLE packages_all FROM PUBLIC;
5759 REVOKE ALL ON TABLE packages_all FROM wbadm;
5760 GRANT ALL ON TABLE packages_all TO wbadm;
5761 GRANT SELECT ON TABLE packages_all TO PUBLIC;
5764 SET search_path = s390, pg_catalog;
5767 -- Name: transactions; Type: ACL; Schema: s390; Owner: wbadm
5770 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5771 REVOKE ALL ON TABLE transactions FROM wbadm;
5772 GRANT ALL ON TABLE transactions TO wbadm;
5773 GRANT SELECT,INSERT ON TABLE transactions TO s390;
5774 GRANT SELECT ON TABLE transactions TO wb_security;
5778 -- Name: users; Type: ACL; Schema: s390; Owner: wbadm
5781 REVOKE ALL ON TABLE users FROM PUBLIC;
5782 REVOKE ALL ON TABLE users FROM wbadm;
5783 GRANT ALL ON TABLE users TO wbadm;
5784 GRANT ALL ON TABLE users TO s390;
5787 SET search_path = s390_public, pg_catalog;
5790 -- Name: transactions; Type: ACL; Schema: s390_public; Owner: wbadm
5793 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5794 REVOKE ALL ON TABLE transactions FROM wbadm;
5795 GRANT ALL ON TABLE transactions TO wbadm;
5796 GRANT SELECT ON TABLE transactions TO PUBLIC;
5800 -- Name: users; Type: ACL; Schema: s390_public; Owner: wbadm
5803 REVOKE ALL ON TABLE users FROM PUBLIC;
5804 REVOKE ALL ON TABLE users FROM wbadm;
5805 GRANT ALL ON TABLE users TO wbadm;
5806 GRANT SELECT ON TABLE users TO PUBLIC;
5809 SET search_path = sparc, pg_catalog;
5812 -- Name: transactions; Type: ACL; Schema: sparc; Owner: wbadm
5815 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5816 REVOKE ALL ON TABLE transactions FROM wbadm;
5817 GRANT ALL ON TABLE transactions TO wbadm;
5818 GRANT SELECT,INSERT ON TABLE transactions TO sparc;
5819 GRANT SELECT ON TABLE transactions TO wb_security;
5823 -- Name: users; Type: ACL; Schema: sparc; Owner: wbadm
5826 REVOKE ALL ON TABLE users FROM PUBLIC;
5827 REVOKE ALL ON TABLE users FROM wbadm;
5828 GRANT ALL ON TABLE users TO wbadm;
5829 GRANT ALL ON TABLE users TO sparc;
5832 SET search_path = sparc_public, pg_catalog;
5835 -- Name: transactions; Type: ACL; Schema: sparc_public; Owner: wbadm
5838 REVOKE ALL ON TABLE transactions FROM PUBLIC;
5839 REVOKE ALL ON TABLE transactions FROM wbadm;
5840 GRANT ALL ON TABLE transactions TO wbadm;
5841 GRANT SELECT ON TABLE transactions TO PUBLIC;
5845 -- Name: users; Type: ACL; Schema: sparc_public; Owner: wbadm
5848 REVOKE ALL ON TABLE users FROM PUBLIC;
5849 REVOKE ALL ON TABLE users FROM wbadm;
5850 GRANT ALL ON TABLE users TO wbadm;
5851 GRANT SELECT ON TABLE users TO PUBLIC;
5855 -- PostgreSQL database dump complete