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: plperl; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: dak
16 CREATE OR REPLACE PROCEDURAL LANGUAGE plperl;
19 ALTER PROCEDURAL LANGUAGE plperl OWNER TO dak;
22 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: dak
25 CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
28 ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO dak;
31 -- Name: plpythonu; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: dak
34 CREATE OR REPLACE PROCEDURAL LANGUAGE plpythonu;
37 ALTER PROCEDURAL LANGUAGE plpythonu OWNER TO dak;
39 SET search_path = public, pg_catalog;
42 -- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres
45 CREATE TYPE debversion;
49 -- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres
52 CREATE FUNCTION debversionin(cstring) RETURNS debversion
53 LANGUAGE internal IMMUTABLE STRICT
57 ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres;
60 -- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres
63 CREATE FUNCTION debversionout(debversion) RETURNS cstring
64 LANGUAGE internal IMMUTABLE STRICT
68 ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres;
71 -- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres
74 CREATE FUNCTION debversionrecv(internal) RETURNS debversion
75 LANGUAGE internal STABLE STRICT
79 ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres;
82 -- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres
85 CREATE FUNCTION debversionsend(debversion) RETURNS bytea
86 LANGUAGE internal STABLE STRICT
90 ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres;
93 -- Name: debversion; Type: TYPE; Schema: public; Owner: postgres
96 CREATE TYPE debversion (
97 INTERNALLENGTH = variable,
99 OUTPUT = debversionout,
100 RECEIVE = debversionrecv,
101 SEND = debversionsend,
108 ALTER TYPE public.debversion OWNER TO postgres;
111 -- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres
114 COMMENT ON TYPE debversion IS 'Debian package version number';
118 -- Name: bin_associations_id_max(); Type: FUNCTION; Schema: public; Owner: dak
121 CREATE FUNCTION bin_associations_id_max() RETURNS integer
123 AS $$SELECT max(id) FROM bin_associations$$;
126 ALTER FUNCTION public.bin_associations_id_max() OWNER TO dak;
129 -- Name: binaries_id_max(); Type: FUNCTION; Schema: public; Owner: dak
132 CREATE FUNCTION binaries_id_max() RETURNS integer
134 AS $$SELECT max(id) FROM binaries$$;
137 ALTER FUNCTION public.binaries_id_max() OWNER TO dak;
140 -- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres
143 CREATE FUNCTION debversion(character) RETURNS debversion
144 LANGUAGE internal IMMUTABLE STRICT
148 ALTER FUNCTION public.debversion(character) OWNER TO postgres;
151 -- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
154 CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer
155 LANGUAGE c IMMUTABLE STRICT
156 AS '$libdir/debversion', 'debversion_cmp';
159 ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres;
162 -- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
165 COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions';
169 -- Name: debversion_compare_single(text, text); Type: FUNCTION; Schema: public; Owner: dak
172 CREATE FUNCTION debversion_compare_single(version1 text, version2 text) RETURNS integer
173 LANGUAGE plperl IMMUTABLE STRICT
177 ##define order(x) ((x) == '~' ? -1 # : cisdigit((x)) ? 0 # : !(x) ? 0 # : cisalpha((x)) ? (x) # : (x) + 256)
178 # This comparison is out of dpkg's order to avoid
179 # comparing things to undef and triggering warnings.
180 if (not defined $x or not length $x) {
186 elsif ($x =~ /^\d$/) {
189 elsif ($x =~ /^[A-Z]$/i) {
193 return ord($x) + 256;
199 return @{$a} ? shift @{$a} : undef;
201 my ($val, $ref) = @_;
202 $val = "" if not defined $val;
203 $ref = "" if not defined $ref;
204 my @val = split //,$val;
205 my @ref = split //,$ref;
206 my $vc = next_elem @val;
207 my $rc = next_elem @ref;
208 while (defined $vc or defined $rc) {
210 while ((defined $vc and $vc !~ /^\d$/) or
211 (defined $rc and $rc !~ /^\d$/)) {
212 my $vo = order($vc); my $ro = order($rc);
213 # Unlike dpkg's verrevcmp, we only return 1 or -1 here.
214 return (($vo - $ro > 0) ? 1 : -1) if $vo != $ro;
215 $vc = next_elem @val; $rc = next_elem @ref;
217 while (defined $vc and $vc eq '0') {
218 $vc = next_elem @val;
220 while (defined $rc and $rc eq '0') {
221 $rc = next_elem @ref;
223 while (defined $vc and $vc =~ /^\d$/ and
224 defined $rc and $rc =~ /^\d$/) {
225 $first_diff = ord($vc) - ord($rc) if !$first_diff;
226 $vc = next_elem @val; $rc = next_elem @ref;
228 return 1 if defined $vc and $vc =~ /^\d$/;
229 return -1 if defined $rc and $rc =~ /^\d$/;
230 return (($first_diff > 0) ? 1 : -1) if $first_diff;
236 ALTER FUNCTION public.debversion_compare_single(version1 text, version2 text) OWNER TO dak;
239 -- Name: FUNCTION debversion_compare_single(version1 text, version2 text); Type: COMMENT; Schema: public; Owner: dak
242 COMMENT ON FUNCTION debversion_compare_single(version1 text, version2 text) IS 'Compare upstream or revision parts of Debian versions';
246 -- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
249 CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean
250 LANGUAGE c IMMUTABLE STRICT
251 AS '$libdir/debversion', 'debversion_eq';
254 ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres;
257 -- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
260 COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal';
264 -- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
267 CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean
268 LANGUAGE c IMMUTABLE STRICT
269 AS '$libdir/debversion', 'debversion_ge';
272 ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres;
275 -- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
278 COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal';
282 -- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
285 CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean
286 LANGUAGE c IMMUTABLE STRICT
287 AS '$libdir/debversion', 'debversion_gt';
290 ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres;
293 -- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
296 COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than';
300 -- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres
303 CREATE FUNCTION debversion_hash(debversion) RETURNS integer
304 LANGUAGE c IMMUTABLE STRICT
305 AS '$libdir/debversion', 'debversion_hash';
308 ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres;
311 -- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
314 CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion
315 LANGUAGE c IMMUTABLE STRICT
316 AS '$libdir/debversion', 'debversion_larger';
319 ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres;
322 -- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
325 CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean
326 LANGUAGE c IMMUTABLE STRICT
327 AS '$libdir/debversion', 'debversion_le';
330 ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres;
333 -- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
336 COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal';
340 -- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
343 CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean
344 LANGUAGE c IMMUTABLE STRICT
345 AS '$libdir/debversion', 'debversion_lt';
348 ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres;
351 -- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
354 COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than';
358 -- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
361 CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean
362 LANGUAGE c IMMUTABLE STRICT
363 AS '$libdir/debversion', 'debversion_ne';
366 ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres;
369 -- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
372 COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal';
376 -- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
379 CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion
380 LANGUAGE c IMMUTABLE STRICT
381 AS '$libdir/debversion', 'debversion_smaller';
384 ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres;
387 -- Name: dsc_files_id_max(); Type: FUNCTION; Schema: public; Owner: dak
390 CREATE FUNCTION dsc_files_id_max() RETURNS integer
392 AS $$SELECT max(id) FROM dsc_files$$;
395 ALTER FUNCTION public.dsc_files_id_max() OWNER TO dak;
398 -- Name: files_id_max(); Type: FUNCTION; Schema: public; Owner: dak
401 CREATE FUNCTION files_id_max() RETURNS integer
403 AS $$SELECT max(id) FROM files$$;
406 ALTER FUNCTION public.files_id_max() OWNER TO dak;
409 -- Name: override_type_id_max(); Type: FUNCTION; Schema: public; Owner: dak
412 CREATE FUNCTION override_type_id_max() RETURNS integer
414 AS $$SELECT max(id) FROM override_type$$;
417 ALTER FUNCTION public.override_type_id_max() OWNER TO dak;
420 -- Name: priority_id_max(); Type: FUNCTION; Schema: public; Owner: dak
423 CREATE FUNCTION priority_id_max() RETURNS integer
425 AS $$SELECT max(id) FROM priority$$;
428 ALTER FUNCTION public.priority_id_max() OWNER TO dak;
431 -- Name: section_id_max(); Type: FUNCTION; Schema: public; Owner: dak
434 CREATE FUNCTION section_id_max() RETURNS integer
436 AS $$SELECT max(id) FROM section$$;
439 ALTER FUNCTION public.section_id_max() OWNER TO dak;
442 -- Name: source_id_max(); Type: FUNCTION; Schema: public; Owner: dak
445 CREATE FUNCTION source_id_max() RETURNS integer
447 AS $$SELECT max(id) FROM source$$;
450 ALTER FUNCTION public.source_id_max() OWNER TO dak;
453 -- Name: space_concat(text, text); Type: FUNCTION; Schema: public; Owner: dak
456 CREATE FUNCTION space_concat(text, text) RETURNS text
459 WHEN $2 is null or $2 = '' THEN $1
460 WHEN $1 is null or $1 = '' THEN $2
465 ALTER FUNCTION public.space_concat(text, text) OWNER TO dak;
468 -- Name: src_associations_id_max(); Type: FUNCTION; Schema: public; Owner: dak
471 CREATE FUNCTION src_associations_id_max() RETURNS integer
473 AS $$SELECT max(id) FROM src_associations$$;
476 ALTER FUNCTION public.src_associations_id_max() OWNER TO dak;
479 -- Name: tfunc_set_modified(); Type: FUNCTION; Schema: public; Owner: dak
482 CREATE FUNCTION tfunc_set_modified() RETURNS trigger
485 BEGIN NEW.modified = now(); return NEW; END;
489 ALTER FUNCTION public.tfunc_set_modified() OWNER TO dak;
492 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
496 PROCEDURE = debversion_gt,
497 LEFTARG = debversion,
498 RIGHTARG = debversion,
504 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
507 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
510 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
514 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
517 CREATE AGGREGATE max(debversion) (
518 SFUNC = debversion_larger,
524 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
527 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
531 PROCEDURE = debversion_lt,
532 LEFTARG = debversion,
533 RIGHTARG = debversion,
539 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
542 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
545 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
549 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
552 CREATE AGGREGATE min(debversion) (
553 SFUNC = debversion_smaller,
559 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
562 -- Name: space_separated_list(text); Type: AGGREGATE; Schema: public; Owner: dak
565 CREATE AGGREGATE space_separated_list(text) (
566 SFUNC = space_concat,
572 ALTER AGGREGATE public.space_separated_list(text) OWNER TO dak;
575 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
579 PROCEDURE = debversion_le,
580 LEFTARG = debversion,
581 RIGHTARG = debversion,
587 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
590 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
593 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
597 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
601 PROCEDURE = debversion_ne,
602 LEFTARG = debversion,
603 RIGHTARG = debversion,
609 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
612 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
615 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
619 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
623 PROCEDURE = debversion_eq,
624 LEFTARG = debversion,
625 RIGHTARG = debversion,
631 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
634 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
637 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
641 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
645 PROCEDURE = debversion_ge,
646 LEFTARG = debversion,
647 RIGHTARG = debversion,
653 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
656 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
659 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
663 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
666 CREATE OPERATOR CLASS debversion_ops
667 DEFAULT FOR TYPE debversion USING btree AS
668 OPERATOR 1 <(debversion,debversion) ,
669 OPERATOR 2 <=(debversion,debversion) ,
670 OPERATOR 3 =(debversion,debversion) ,
671 OPERATOR 4 >=(debversion,debversion) ,
672 OPERATOR 5 >(debversion,debversion) ,
673 FUNCTION 1 debversion_cmp(debversion,debversion);
676 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
679 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
682 CREATE OPERATOR CLASS debversion_ops
683 DEFAULT FOR TYPE debversion USING hash AS
684 OPERATOR 1 =(debversion,debversion) ,
685 FUNCTION 1 debversion_hash(debversion);
688 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
690 SET search_path = pg_catalog;
693 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
696 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
700 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
703 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
707 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
710 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
714 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
717 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
721 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
724 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
728 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
731 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
734 SET search_path = public, pg_catalog;
737 -- Name: bin_associations_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
740 CREATE SEQUENCE bin_associations_id_seq
748 ALTER TABLE public.bin_associations_id_seq OWNER TO dak;
750 SET default_tablespace = '';
752 SET default_with_oids = false;
755 -- Name: bin_associations; Type: TABLE; Schema: public; Owner: dak; Tablespace:
758 CREATE TABLE bin_associations (
759 id integer DEFAULT nextval('bin_associations_id_seq'::regclass) NOT NULL,
760 suite integer NOT NULL,
761 bin integer NOT NULL,
762 created timestamp with time zone DEFAULT now() NOT NULL,
763 modified timestamp with time zone DEFAULT now() NOT NULL
767 ALTER TABLE public.bin_associations OWNER TO dak;
770 -- Name: binaries_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
773 CREATE SEQUENCE binaries_id_seq
781 ALTER TABLE public.binaries_id_seq OWNER TO dak;
784 -- Name: binaries; Type: TABLE; Schema: public; Owner: dak; Tablespace:
787 CREATE TABLE binaries (
788 id integer DEFAULT nextval('binaries_id_seq'::regclass) NOT NULL,
789 package text NOT NULL,
790 version debversion NOT NULL,
791 maintainer integer NOT NULL,
792 source integer NOT NULL,
793 architecture integer NOT NULL,
794 file integer NOT NULL,
797 install_date timestamp with time zone DEFAULT now(),
798 created timestamp with time zone DEFAULT now() NOT NULL,
799 modified timestamp with time zone DEFAULT now() NOT NULL,
804 ALTER TABLE public.binaries OWNER TO dak;
807 -- Name: bin_associations_binaries; Type: VIEW; Schema: public; Owner: dak
810 CREATE VIEW bin_associations_binaries AS
811 SELECT bin_associations.id, bin_associations.bin, binaries.package, binaries.version, bin_associations.suite, binaries.architecture, binaries.source FROM (bin_associations JOIN binaries ON ((bin_associations.bin = binaries.id)));
814 ALTER TABLE public.bin_associations_binaries OWNER TO dak;
817 -- Name: source_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
820 CREATE SEQUENCE source_id_seq
828 ALTER TABLE public.source_id_seq OWNER TO dak;
831 -- Name: source; Type: TABLE; Schema: public; Owner: dak; Tablespace:
834 CREATE TABLE source (
835 id integer DEFAULT nextval('source_id_seq'::regclass) NOT NULL,
836 source text NOT NULL,
837 version debversion NOT NULL,
838 maintainer integer NOT NULL,
839 file integer NOT NULL,
841 install_date timestamp with time zone NOT NULL,
842 changedby integer NOT NULL,
843 dm_upload_allowed boolean DEFAULT false NOT NULL,
844 created timestamp with time zone DEFAULT now() NOT NULL,
845 modified timestamp with time zone DEFAULT now() NOT NULL,
850 ALTER TABLE public.source OWNER TO dak;
853 -- Name: src_associations_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
856 CREATE SEQUENCE src_associations_id_seq
864 ALTER TABLE public.src_associations_id_seq OWNER TO dak;
867 -- Name: src_associations; Type: TABLE; Schema: public; Owner: dak; Tablespace:
870 CREATE TABLE src_associations (
871 id integer DEFAULT nextval('src_associations_id_seq'::regclass) NOT NULL,
872 suite integer NOT NULL,
873 source integer NOT NULL,
874 created timestamp with time zone DEFAULT now() NOT NULL,
875 modified timestamp with time zone DEFAULT now() NOT NULL
879 ALTER TABLE public.src_associations OWNER TO dak;
882 -- Name: src_associations_bin; Type: VIEW; Schema: public; Owner: dak
885 CREATE VIEW src_associations_bin AS
886 SELECT src_associations.id, src_associations.source, src_associations.suite, binaries.id AS bin, binaries.architecture FROM ((src_associations JOIN source ON ((src_associations.source = source.id))) JOIN binaries ON ((source.id = binaries.source)));
889 ALTER TABLE public.src_associations_bin OWNER TO dak;
892 -- Name: almost_obsolete_all_associations; Type: VIEW; Schema: public; Owner: dak
895 CREATE VIEW almost_obsolete_all_associations AS
896 SELECT bin_associations_binaries.id, bin_associations_binaries.bin, bin_associations_binaries.package, bin_associations_binaries.version, bin_associations_binaries.suite FROM (bin_associations_binaries LEFT JOIN src_associations_bin USING (bin, suite, architecture)) WHERE ((src_associations_bin.source IS NULL) AND (bin_associations_binaries.architecture = 2));
899 ALTER TABLE public.almost_obsolete_all_associations OWNER TO dak;
902 -- Name: any_associations_source; Type: VIEW; Schema: public; Owner: dak
905 CREATE VIEW any_associations_source AS
906 SELECT bin_associations.id, bin_associations.suite, binaries.id AS bin, binaries.package, binaries.version AS binver, binaries.architecture, source.id AS src, source.source, source.version AS srcver FROM ((bin_associations JOIN binaries ON (((bin_associations.bin = binaries.id) AND (binaries.architecture <> 2)))) JOIN source ON ((binaries.source = source.id)));
909 ALTER TABLE public.any_associations_source OWNER TO dak;
912 -- Name: src_associations_src; Type: VIEW; Schema: public; Owner: dak
915 CREATE VIEW src_associations_src AS
916 SELECT src_associations.id, src_associations.suite, source.id AS src, source.source, source.version FROM (src_associations JOIN source ON ((src_associations.source = source.id)));
919 ALTER TABLE public.src_associations_src OWNER TO dak;
922 -- Name: almost_obsolete_src_associations; Type: VIEW; Schema: public; Owner: dak
925 CREATE VIEW almost_obsolete_src_associations AS
926 SELECT src_associations_src.id, src_associations_src.src, src_associations_src.source, src_associations_src.version, src_associations_src.suite FROM (src_associations_src LEFT JOIN any_associations_source USING (src, suite)) WHERE (any_associations_source.bin IS NULL);
929 ALTER TABLE public.almost_obsolete_src_associations OWNER TO dak;
932 -- Name: architecture_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
935 CREATE SEQUENCE architecture_id_seq
943 ALTER TABLE public.architecture_id_seq OWNER TO dak;
946 -- Name: architecture; Type: TABLE; Schema: public; Owner: dak; Tablespace:
949 CREATE TABLE architecture (
950 id integer DEFAULT nextval('architecture_id_seq'::regclass) NOT NULL,
951 arch_string text NOT NULL,
953 created timestamp with time zone DEFAULT now() NOT NULL,
954 modified timestamp with time zone DEFAULT now() NOT NULL
958 ALTER TABLE public.architecture OWNER TO dak;
961 -- Name: archive_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
964 CREATE SEQUENCE archive_id_seq
972 ALTER TABLE public.archive_id_seq OWNER TO dak;
975 -- Name: archive; Type: TABLE; Schema: public; Owner: dak; Tablespace:
978 CREATE TABLE archive (
979 id integer DEFAULT nextval('archive_id_seq'::regclass) NOT NULL,
983 created timestamp with time zone DEFAULT now() NOT NULL,
984 modified timestamp with time zone DEFAULT now() NOT NULL
988 ALTER TABLE public.archive OWNER TO dak;
991 -- Name: bin_contents; Type: TABLE; Schema: public; Owner: dak; Tablespace:
994 CREATE TABLE bin_contents (
996 binary_id integer NOT NULL,
997 created timestamp with time zone DEFAULT now() NOT NULL,
998 modified timestamp with time zone DEFAULT now() NOT NULL
1002 ALTER TABLE public.bin_contents OWNER TO dak;
1005 -- Name: binaries_metadata; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1008 CREATE TABLE binaries_metadata (
1009 bin_id integer NOT NULL,
1010 key_id integer NOT NULL,
1015 ALTER TABLE public.binaries_metadata OWNER TO dak;
1018 -- Name: suite_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1021 CREATE SEQUENCE suite_id_seq
1029 ALTER TABLE public.suite_id_seq OWNER TO dak;
1032 -- Name: suite; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1035 CREATE TABLE suite (
1036 id integer DEFAULT nextval('suite_id_seq'::regclass) NOT NULL,
1037 suite_name text NOT NULL,
1042 untouchable boolean DEFAULT false NOT NULL,
1043 announce text DEFAULT 'debian-devel-changes@lists.debian.org'::text NOT NULL,
1045 overridecodename text,
1046 validtime integer DEFAULT 604800 NOT NULL,
1047 priority integer DEFAULT 0 NOT NULL,
1048 notautomatic boolean DEFAULT false NOT NULL,
1051 policy_queue_id integer,
1052 created timestamp with time zone DEFAULT now() NOT NULL,
1053 modified timestamp with time zone DEFAULT now() NOT NULL,
1055 butautomaticupgrades boolean DEFAULT false NOT NULL,
1057 CONSTRAINT bau_needs_na_set CHECK (((NOT butautomaticupgrades) OR notautomatic))
1061 ALTER TABLE public.suite OWNER TO dak;
1064 -- Name: binaries_suite_arch; Type: VIEW; Schema: public; Owner: dak
1067 CREATE VIEW binaries_suite_arch AS
1068 SELECT bin_associations.id, binaries.id AS bin, binaries.package, binaries.version, binaries.source, bin_associations.suite, suite.suite_name, binaries.architecture, architecture.arch_string FROM (((binaries JOIN bin_associations ON ((binaries.id = bin_associations.bin))) JOIN suite ON ((suite.id = bin_associations.suite))) JOIN architecture ON ((binaries.architecture = architecture.id)));
1071 ALTER TABLE public.binaries_suite_arch OWNER TO dak;
1074 -- Name: binary_acl; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1077 CREATE TABLE binary_acl (
1078 id integer NOT NULL,
1079 access_level text NOT NULL,
1080 created timestamp with time zone DEFAULT now() NOT NULL,
1081 modified timestamp with time zone DEFAULT now() NOT NULL
1085 ALTER TABLE public.binary_acl OWNER TO dak;
1088 -- Name: binary_acl_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1091 CREATE SEQUENCE binary_acl_id_seq
1099 ALTER TABLE public.binary_acl_id_seq OWNER TO dak;
1102 -- Name: binary_acl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1105 ALTER SEQUENCE binary_acl_id_seq OWNED BY binary_acl.id;
1109 -- Name: binary_acl_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1112 CREATE TABLE binary_acl_map (
1113 id integer NOT NULL,
1114 fingerprint_id integer NOT NULL,
1115 architecture_id integer NOT NULL,
1116 created timestamp with time zone DEFAULT now() NOT NULL,
1117 modified timestamp with time zone DEFAULT now() NOT NULL
1121 ALTER TABLE public.binary_acl_map OWNER TO dak;
1124 -- Name: binary_acl_map_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1127 CREATE SEQUENCE binary_acl_map_id_seq
1135 ALTER TABLE public.binary_acl_map_id_seq OWNER TO dak;
1138 -- Name: binary_acl_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1141 ALTER SEQUENCE binary_acl_map_id_seq OWNED BY binary_acl_map.id;
1145 -- Name: files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1148 CREATE SEQUENCE files_id_seq
1156 ALTER TABLE public.files_id_seq OWNER TO dak;
1159 -- Name: files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1162 CREATE TABLE files (
1163 id integer DEFAULT nextval('files_id_seq'::regclass) NOT NULL,
1164 filename text NOT NULL,
1165 size bigint NOT NULL,
1166 md5sum text NOT NULL,
1167 location integer NOT NULL,
1168 last_used timestamp with time zone,
1171 created timestamp with time zone DEFAULT now() NOT NULL,
1172 modified timestamp with time zone DEFAULT now() NOT NULL
1176 ALTER TABLE public.files OWNER TO dak;
1179 -- Name: location_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1182 CREATE SEQUENCE location_id_seq
1190 ALTER TABLE public.location_id_seq OWNER TO dak;
1193 -- Name: location; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1196 CREATE TABLE location (
1197 id integer DEFAULT nextval('location_id_seq'::regclass) NOT NULL,
1202 created timestamp with time zone DEFAULT now() NOT NULL,
1203 modified timestamp with time zone DEFAULT now() NOT NULL
1207 ALTER TABLE public.location OWNER TO dak;
1210 -- Name: binfiles_suite_component_arch; Type: VIEW; Schema: public; Owner: dak
1213 CREATE VIEW binfiles_suite_component_arch AS
1214 SELECT files.filename, binaries.type, location.path, location.component, bin_associations.suite, binaries.architecture FROM (((binaries JOIN bin_associations ON ((binaries.id = bin_associations.bin))) JOIN files ON ((binaries.file = files.id))) JOIN location ON ((files.location = location.id)));
1217 ALTER TABLE public.binfiles_suite_component_arch OWNER TO dak;
1220 -- Name: build_queue; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1223 CREATE TABLE build_queue (
1224 id integer NOT NULL,
1225 queue_name text NOT NULL,
1227 copy_files boolean DEFAULT false NOT NULL,
1228 generate_metadata boolean DEFAULT false NOT NULL,
1231 releasedescription text,
1233 stay_of_execution integer DEFAULT 86400 NOT NULL,
1234 created timestamp with time zone DEFAULT now() NOT NULL,
1235 modified timestamp with time zone DEFAULT now() NOT NULL,
1236 notautomatic boolean DEFAULT false NOT NULL,
1237 CONSTRAINT build_queue_meta_sanity_check CHECK (((generate_metadata IS FALSE) OR (((origin IS NOT NULL) AND (label IS NOT NULL)) AND (releasedescription IS NOT NULL)))),
1238 CONSTRAINT build_queue_stay_of_execution_check CHECK ((stay_of_execution >= 0))
1242 ALTER TABLE public.build_queue OWNER TO dak;
1245 -- Name: build_queue_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1248 CREATE TABLE build_queue_files (
1249 id integer NOT NULL,
1250 build_queue_id integer NOT NULL,
1251 insertdate timestamp without time zone DEFAULT now() NOT NULL,
1252 lastused timestamp without time zone,
1253 filename text NOT NULL,
1255 created timestamp with time zone DEFAULT now() NOT NULL,
1256 modified timestamp with time zone DEFAULT now() NOT NULL
1260 ALTER TABLE public.build_queue_files OWNER TO dak;
1263 -- Name: build_queue_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1266 CREATE SEQUENCE build_queue_files_id_seq
1274 ALTER TABLE public.build_queue_files_id_seq OWNER TO dak;
1277 -- Name: build_queue_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1280 ALTER SEQUENCE build_queue_files_id_seq OWNED BY build_queue_files.id;
1284 -- Name: build_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1287 CREATE SEQUENCE build_queue_id_seq
1295 ALTER TABLE public.build_queue_id_seq OWNER TO dak;
1298 -- Name: build_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1301 ALTER SEQUENCE build_queue_id_seq OWNED BY build_queue.id;
1305 -- Name: build_queue_policy_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1308 CREATE TABLE build_queue_policy_files (
1309 build_queue_id integer NOT NULL,
1310 file_id integer NOT NULL,
1311 filename text NOT NULL,
1312 created timestamp with time zone DEFAULT now() NOT NULL,
1313 lastused timestamp without time zone
1317 ALTER TABLE public.build_queue_policy_files OWNER TO dak;
1320 -- Name: changelogs_text; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1323 CREATE TABLE changelogs_text (
1324 id integer NOT NULL,
1329 ALTER TABLE public.changelogs_text OWNER TO dak;
1332 -- Name: changes; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1335 CREATE TABLE changes (
1336 id integer NOT NULL,
1337 changesname text NOT NULL,
1338 seen timestamp with time zone DEFAULT now() NOT NULL,
1339 source text NOT NULL,
1340 binaries text NOT NULL,
1341 architecture text NOT NULL,
1342 version text NOT NULL,
1343 distribution text NOT NULL,
1344 urgency text NOT NULL,
1345 maintainer text NOT NULL,
1346 fingerprint text NOT NULL,
1347 changedby text NOT NULL,
1350 approved_for integer,
1351 created timestamp with time zone DEFAULT now() NOT NULL,
1352 modified timestamp with time zone DEFAULT now() NOT NULL,
1353 changelog_id integer
1357 ALTER TABLE public.changes OWNER TO dak;
1360 -- Name: changelogs; Type: VIEW; Schema: public; Owner: dak
1363 CREATE VIEW changelogs AS
1364 SELECT cl.id, c.source, (c.version)::debversion AS version, c.architecture, cl.changelog, c.distribution FROM (changes c JOIN changelogs_text cl ON ((cl.id = c.changelog_id)));
1367 ALTER TABLE public.changelogs OWNER TO dak;
1370 -- Name: changelogs_text_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1373 CREATE SEQUENCE changelogs_text_id_seq
1381 ALTER TABLE public.changelogs_text_id_seq OWNER TO dak;
1384 -- Name: changelogs_text_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1387 ALTER SEQUENCE changelogs_text_id_seq OWNED BY changelogs_text.id;
1391 -- Name: changes_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1394 CREATE SEQUENCE changes_id_seq
1402 ALTER TABLE public.changes_id_seq OWNER TO dak;
1405 -- Name: changes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1408 ALTER SEQUENCE changes_id_seq OWNED BY changes.id;
1412 -- Name: changes_pending_binaries; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1415 CREATE TABLE changes_pending_binaries (
1416 id integer NOT NULL,
1417 change_id integer NOT NULL,
1418 package text NOT NULL,
1419 version debversion NOT NULL,
1420 architecture_id integer NOT NULL,
1422 pending_source_id integer,
1423 pending_file_id integer,
1424 created timestamp with time zone DEFAULT now() NOT NULL,
1425 modified timestamp with time zone DEFAULT now() NOT NULL,
1426 CONSTRAINT changes_pending_binaries_check CHECK (((source_id IS NOT NULL) OR (pending_source_id IS NOT NULL)))
1430 ALTER TABLE public.changes_pending_binaries OWNER TO dak;
1433 -- Name: changes_pending_binaries_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1436 CREATE SEQUENCE changes_pending_binaries_id_seq
1444 ALTER TABLE public.changes_pending_binaries_id_seq OWNER TO dak;
1447 -- Name: changes_pending_binaries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1450 ALTER SEQUENCE changes_pending_binaries_id_seq OWNED BY changes_pending_binaries.id;
1454 -- Name: changes_pending_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1457 CREATE TABLE changes_pending_files (
1458 id integer NOT NULL,
1459 filename text NOT NULL,
1460 size bigint NOT NULL,
1461 md5sum text NOT NULL,
1462 sha1sum text NOT NULL,
1463 sha256sum text NOT NULL,
1464 created timestamp with time zone DEFAULT now() NOT NULL,
1465 modified timestamp with time zone DEFAULT now() NOT NULL,
1466 processed boolean DEFAULT false
1470 ALTER TABLE public.changes_pending_files OWNER TO dak;
1473 -- Name: changes_pending_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1476 CREATE SEQUENCE changes_pending_files_id_seq
1484 ALTER TABLE public.changes_pending_files_id_seq OWNER TO dak;
1487 -- Name: changes_pending_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1490 ALTER SEQUENCE changes_pending_files_id_seq OWNED BY changes_pending_files.id;
1494 -- Name: changes_pending_files_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1497 CREATE TABLE changes_pending_files_map (
1498 file_id integer NOT NULL,
1499 change_id integer NOT NULL,
1500 created timestamp with time zone DEFAULT now() NOT NULL,
1501 modified timestamp with time zone DEFAULT now() NOT NULL
1505 ALTER TABLE public.changes_pending_files_map OWNER TO dak;
1508 -- Name: changes_pending_source; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1511 CREATE TABLE changes_pending_source (
1512 id integer NOT NULL,
1513 change_id integer NOT NULL,
1514 source text NOT NULL,
1515 version debversion NOT NULL,
1516 maintainer_id integer NOT NULL,
1517 changedby_id integer NOT NULL,
1518 sig_fpr integer NOT NULL,
1519 dm_upload_allowed boolean DEFAULT false NOT NULL,
1520 created timestamp with time zone DEFAULT now() NOT NULL,
1521 modified timestamp with time zone DEFAULT now() NOT NULL
1525 ALTER TABLE public.changes_pending_source OWNER TO dak;
1528 -- Name: changes_pending_source_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1531 CREATE TABLE changes_pending_source_files (
1532 pending_source_id integer NOT NULL,
1533 pending_file_id integer NOT NULL,
1534 created timestamp with time zone DEFAULT now() NOT NULL,
1535 modified timestamp with time zone DEFAULT now() NOT NULL
1539 ALTER TABLE public.changes_pending_source_files OWNER TO dak;
1542 -- Name: changes_pending_source_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1545 CREATE SEQUENCE changes_pending_source_id_seq
1553 ALTER TABLE public.changes_pending_source_id_seq OWNER TO dak;
1556 -- Name: changes_pending_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1559 ALTER SEQUENCE changes_pending_source_id_seq OWNED BY changes_pending_source.id;
1563 -- Name: changes_pool_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1566 CREATE TABLE changes_pool_files (
1567 changeid integer NOT NULL,
1568 fileid integer NOT NULL,
1569 created timestamp with time zone DEFAULT now() NOT NULL,
1570 modified timestamp with time zone DEFAULT now() NOT NULL
1574 ALTER TABLE public.changes_pool_files OWNER TO dak;
1577 -- Name: component_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1580 CREATE SEQUENCE component_id_seq
1588 ALTER TABLE public.component_id_seq OWNER TO dak;
1591 -- Name: component; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1594 CREATE TABLE component (
1595 id integer DEFAULT nextval('component_id_seq'::regclass) NOT NULL,
1599 created timestamp with time zone DEFAULT now() NOT NULL,
1600 modified timestamp with time zone DEFAULT now() NOT NULL
1604 ALTER TABLE public.component OWNER TO dak;
1607 -- Name: config; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1610 CREATE TABLE config (
1611 id integer NOT NULL,
1614 created timestamp with time zone DEFAULT now() NOT NULL,
1615 modified timestamp with time zone DEFAULT now() NOT NULL
1619 ALTER TABLE public.config OWNER TO dak;
1622 -- Name: config_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1625 CREATE SEQUENCE config_id_seq
1633 ALTER TABLE public.config_id_seq OWNER TO dak;
1636 -- Name: config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1639 ALTER SEQUENCE config_id_seq OWNED BY config.id;
1643 -- Name: dsc_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1646 CREATE SEQUENCE dsc_files_id_seq
1654 ALTER TABLE public.dsc_files_id_seq OWNER TO dak;
1657 -- Name: dsc_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1660 CREATE TABLE dsc_files (
1661 id integer DEFAULT nextval('dsc_files_id_seq'::regclass) NOT NULL,
1662 source integer NOT NULL,
1663 file integer NOT NULL,
1664 created timestamp with time zone DEFAULT now() NOT NULL,
1665 modified timestamp with time zone DEFAULT now() NOT NULL
1669 ALTER TABLE public.dsc_files OWNER TO dak;
1672 -- Name: external_overrides; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1675 CREATE TABLE external_overrides (
1676 package text NOT NULL,
1678 value text NOT NULL,
1679 suite integer NOT NULL,
1680 component integer NOT NULL
1684 ALTER TABLE public.external_overrides OWNER TO dak;
1687 -- Name: extra_src_references; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1690 CREATE TABLE extra_src_references (
1691 bin_id integer NOT NULL,
1692 src_id integer NOT NULL
1696 ALTER TABLE public.extra_src_references OWNER TO dak;
1699 -- Name: file_arch_suite; Type: VIEW; Schema: public; Owner: dak
1702 CREATE VIEW file_arch_suite AS
1703 SELECT f.id AS file, f.size, b.architecture, s.id AS suite FROM files f, binaries b, bin_associations ba, suite s WHERE (((f.id = b.file) AND (b.id = ba.bin)) AND (ba.suite = s.id));
1706 ALTER TABLE public.file_arch_suite OWNER TO dak;
1709 -- Name: fingerprint_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1712 CREATE SEQUENCE fingerprint_id_seq
1720 ALTER TABLE public.fingerprint_id_seq OWNER TO dak;
1723 -- Name: fingerprint; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1726 CREATE TABLE fingerprint (
1727 id integer DEFAULT nextval('fingerprint_id_seq'::regclass) NOT NULL,
1728 fingerprint text NOT NULL,
1731 source_acl_id integer,
1732 binary_acl_id integer,
1733 binary_reject boolean DEFAULT true NOT NULL,
1734 created timestamp with time zone DEFAULT now() NOT NULL,
1735 modified timestamp with time zone DEFAULT now() NOT NULL
1739 ALTER TABLE public.fingerprint OWNER TO dak;
1742 -- Name: keyring_acl_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1745 CREATE TABLE keyring_acl_map (
1746 id integer NOT NULL,
1747 keyring_id integer NOT NULL,
1748 architecture_id integer NOT NULL,
1749 created timestamp with time zone DEFAULT now() NOT NULL,
1750 modified timestamp with time zone DEFAULT now() NOT NULL
1754 ALTER TABLE public.keyring_acl_map OWNER TO dak;
1757 -- Name: keyring_acl_map_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1760 CREATE SEQUENCE keyring_acl_map_id_seq
1768 ALTER TABLE public.keyring_acl_map_id_seq OWNER TO dak;
1771 -- Name: keyring_acl_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1774 ALTER SEQUENCE keyring_acl_map_id_seq OWNED BY keyring_acl_map.id;
1778 -- Name: keyrings; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1781 CREATE TABLE keyrings (
1782 id integer NOT NULL,
1784 default_source_acl_id integer,
1785 default_binary_acl_id integer,
1786 default_binary_reject boolean DEFAULT true NOT NULL,
1787 priority integer DEFAULT 100 NOT NULL,
1788 created timestamp with time zone DEFAULT now() NOT NULL,
1789 modified timestamp with time zone DEFAULT now() NOT NULL,
1790 active boolean DEFAULT true
1794 ALTER TABLE public.keyrings OWNER TO dak;
1797 -- Name: keyrings_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1800 CREATE SEQUENCE keyrings_id_seq
1808 ALTER TABLE public.keyrings_id_seq OWNER TO dak;
1811 -- Name: keyrings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1814 ALTER SEQUENCE keyrings_id_seq OWNED BY keyrings.id;
1818 -- Name: maintainer_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1821 CREATE SEQUENCE maintainer_id_seq
1829 ALTER TABLE public.maintainer_id_seq OWNER TO dak;
1832 -- Name: maintainer; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1835 CREATE TABLE maintainer (
1836 id integer DEFAULT nextval('maintainer_id_seq'::regclass) NOT NULL,
1838 created timestamp with time zone DEFAULT now() NOT NULL,
1839 modified timestamp with time zone DEFAULT now() NOT NULL
1843 ALTER TABLE public.maintainer OWNER TO dak;
1846 -- Name: metadata_keys; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1849 CREATE TABLE metadata_keys (
1850 key_id integer NOT NULL,
1852 ordering integer DEFAULT 0 NOT NULL
1856 ALTER TABLE public.metadata_keys OWNER TO dak;
1859 -- Name: metadata_keys_key_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1862 CREATE SEQUENCE metadata_keys_key_id_seq
1870 ALTER TABLE public.metadata_keys_key_id_seq OWNER TO dak;
1873 -- Name: metadata_keys_key_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1876 ALTER SEQUENCE metadata_keys_key_id_seq OWNED BY metadata_keys.key_id;
1880 -- Name: new_comments; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1883 CREATE TABLE new_comments (
1884 id integer NOT NULL,
1885 package text NOT NULL,
1886 version text NOT NULL,
1887 comment text NOT NULL,
1888 author text NOT NULL,
1889 notedate timestamp with time zone DEFAULT now() NOT NULL,
1890 trainee boolean DEFAULT false NOT NULL,
1891 created timestamp with time zone DEFAULT now() NOT NULL,
1892 modified timestamp with time zone DEFAULT now() NOT NULL
1896 ALTER TABLE public.new_comments OWNER TO dak;
1899 -- Name: new_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1902 CREATE SEQUENCE new_comments_id_seq
1910 ALTER TABLE public.new_comments_id_seq OWNER TO dak;
1913 -- Name: new_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1916 ALTER SEQUENCE new_comments_id_seq OWNED BY new_comments.id;
1920 -- Name: newest_all_associations; Type: VIEW; Schema: public; Owner: dak
1923 CREATE VIEW newest_all_associations AS
1924 SELECT binaries_suite_arch.package, max(binaries_suite_arch.version) AS version, binaries_suite_arch.suite, binaries_suite_arch.architecture FROM binaries_suite_arch WHERE (binaries_suite_arch.architecture = 2) GROUP BY binaries_suite_arch.package, binaries_suite_arch.suite, binaries_suite_arch.architecture;
1927 ALTER TABLE public.newest_all_associations OWNER TO dak;
1930 -- Name: newest_any_associations; Type: VIEW; Schema: public; Owner: dak
1933 CREATE VIEW newest_any_associations AS
1934 SELECT binaries_suite_arch.package, max(binaries_suite_arch.version) AS version, binaries_suite_arch.suite, binaries_suite_arch.architecture FROM binaries_suite_arch WHERE (binaries_suite_arch.architecture > 2) GROUP BY binaries_suite_arch.package, binaries_suite_arch.suite, binaries_suite_arch.architecture;
1937 ALTER TABLE public.newest_any_associations OWNER TO dak;
1940 -- Name: source_suite; Type: VIEW; Schema: public; Owner: dak
1943 CREATE VIEW source_suite AS
1944 SELECT src_associations.id, source.id AS src, source.source, source.version, src_associations.suite, suite.suite_name, source.install_date FROM ((source JOIN src_associations ON ((source.id = src_associations.source))) JOIN suite ON ((suite.id = src_associations.suite)));
1947 ALTER TABLE public.source_suite OWNER TO dak;
1950 -- Name: newest_source; Type: VIEW; Schema: public; Owner: dak
1953 CREATE VIEW newest_source AS
1954 SELECT source_suite.source, max(source_suite.version) AS version, source_suite.suite FROM source_suite GROUP BY source_suite.source, source_suite.suite;
1957 ALTER TABLE public.newest_source OWNER TO dak;
1960 -- Name: newest_src_association; Type: VIEW; Schema: public; Owner: dak
1963 CREATE VIEW newest_src_association AS
1964 SELECT source_suite.id, source_suite.src, source_suite.source, source_suite.version, source_suite.suite FROM (source_suite JOIN newest_source USING (source, version, suite));
1967 ALTER TABLE public.newest_src_association OWNER TO dak;
1970 -- Name: obsolete_all_associations; Type: VIEW; Schema: public; Owner: dak
1973 CREATE VIEW obsolete_all_associations AS
1974 SELECT almost.id, almost.bin, almost.package, almost.version, almost.suite FROM (almost_obsolete_all_associations almost JOIN newest_all_associations newest ON ((((almost.package = newest.package) AND (almost.version < newest.version)) AND (almost.suite = newest.suite))));
1977 ALTER TABLE public.obsolete_all_associations OWNER TO dak;
1980 -- Name: obsolete_any_associations; Type: VIEW; Schema: public; Owner: dak
1983 CREATE VIEW obsolete_any_associations AS
1984 SELECT binaries_suite_arch.id, binaries_suite_arch.architecture, binaries_suite_arch.version, binaries_suite_arch.package, binaries_suite_arch.suite FROM (binaries_suite_arch JOIN newest_any_associations ON (((((binaries_suite_arch.architecture = newest_any_associations.architecture) AND (binaries_suite_arch.package = newest_any_associations.package)) AND (binaries_suite_arch.suite = newest_any_associations.suite)) AND (binaries_suite_arch.version <> newest_any_associations.version))));
1987 ALTER TABLE public.obsolete_any_associations OWNER TO dak;
1990 -- Name: obsolete_any_by_all_associations; Type: VIEW; Schema: public; Owner: dak
1993 CREATE VIEW obsolete_any_by_all_associations AS
1994 SELECT binaries_suite_arch.id, binaries_suite_arch.package, binaries_suite_arch.version, binaries_suite_arch.suite, binaries_suite_arch.architecture FROM (binaries_suite_arch JOIN newest_all_associations ON (((((binaries_suite_arch.package = newest_all_associations.package) AND (binaries_suite_arch.version < newest_all_associations.version)) AND (binaries_suite_arch.suite = newest_all_associations.suite)) AND (binaries_suite_arch.architecture > 2))));
1997 ALTER TABLE public.obsolete_any_by_all_associations OWNER TO dak;
2000 -- Name: obsolete_src_associations; Type: VIEW; Schema: public; Owner: dak
2003 CREATE VIEW obsolete_src_associations AS
2004 SELECT almost.id, almost.src, almost.source, almost.version, almost.suite FROM (almost_obsolete_src_associations almost JOIN newest_src_association newest ON ((((almost.source = newest.source) AND (almost.version < newest.version)) AND (almost.suite = newest.suite))));
2007 ALTER TABLE public.obsolete_src_associations OWNER TO dak;
2010 -- Name: override; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2013 CREATE TABLE override (
2014 package text NOT NULL,
2015 suite integer NOT NULL,
2016 component integer NOT NULL,
2018 section integer NOT NULL,
2019 type integer NOT NULL,
2021 created timestamp with time zone DEFAULT now() NOT NULL,
2022 modified timestamp with time zone DEFAULT now() NOT NULL
2026 ALTER TABLE public.override OWNER TO dak;
2029 -- Name: override_type_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2032 CREATE SEQUENCE override_type_id_seq
2040 ALTER TABLE public.override_type_id_seq OWNER TO dak;
2043 -- Name: override_type; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2046 CREATE TABLE override_type (
2047 id integer DEFAULT nextval('override_type_id_seq'::regclass) NOT NULL,
2049 created timestamp with time zone DEFAULT now() NOT NULL,
2050 modified timestamp with time zone DEFAULT now() NOT NULL
2054 ALTER TABLE public.override_type OWNER TO dak;
2057 -- Name: policy_queue; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2060 CREATE TABLE policy_queue (
2061 id integer NOT NULL,
2062 queue_name text NOT NULL,
2064 perms character(4) DEFAULT '0660'::bpchar NOT NULL,
2065 change_perms character(4) DEFAULT '0660'::bpchar NOT NULL,
2066 generate_metadata boolean DEFAULT false NOT NULL,
2069 releasedescription text,
2071 stay_of_execution integer DEFAULT 86400 NOT NULL,
2072 created timestamp with time zone DEFAULT now() NOT NULL,
2073 modified timestamp with time zone DEFAULT now() NOT NULL,
2074 send_to_build_queues boolean DEFAULT false NOT NULL,
2075 CONSTRAINT policy_queue_change_perms_check CHECK ((change_perms ~ similar_escape('[0-7][0-7][0-7][0-7]'::text, NULL::text))),
2076 CONSTRAINT policy_queue_meta_sanity_check CHECK (((generate_metadata IS FALSE) OR (((origin IS NOT NULL) AND (label IS NOT NULL)) AND (releasedescription IS NOT NULL)))),
2077 CONSTRAINT policy_queue_perms_check CHECK ((perms ~ similar_escape('[0-7][0-7][0-7][0-7]'::text, NULL::text))),
2078 CONSTRAINT policy_queue_stay_of_execution_check CHECK ((stay_of_execution >= 0))
2082 ALTER TABLE public.policy_queue OWNER TO dak;
2085 -- Name: policy_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2088 CREATE SEQUENCE policy_queue_id_seq
2096 ALTER TABLE public.policy_queue_id_seq OWNER TO dak;
2099 -- Name: policy_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2102 ALTER SEQUENCE policy_queue_id_seq OWNED BY policy_queue.id;
2106 -- Name: priority_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2109 CREATE SEQUENCE priority_id_seq
2117 ALTER TABLE public.priority_id_seq OWNER TO dak;
2120 -- Name: priority; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2123 CREATE TABLE priority (
2124 id integer DEFAULT nextval('priority_id_seq'::regclass) NOT NULL,
2125 priority text NOT NULL,
2126 level integer NOT NULL,
2127 created timestamp with time zone DEFAULT now() NOT NULL,
2128 modified timestamp with time zone DEFAULT now() NOT NULL
2132 ALTER TABLE public.priority OWNER TO dak;
2135 -- Name: section_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2138 CREATE SEQUENCE section_id_seq
2146 ALTER TABLE public.section_id_seq OWNER TO dak;
2149 -- Name: section; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2152 CREATE TABLE section (
2153 id integer DEFAULT nextval('section_id_seq'::regclass) NOT NULL,
2154 section text NOT NULL,
2155 created timestamp with time zone DEFAULT now() NOT NULL,
2156 modified timestamp with time zone DEFAULT now() NOT NULL
2160 ALTER TABLE public.section OWNER TO dak;
2163 -- Name: source_acl; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2166 CREATE TABLE source_acl (
2167 id integer NOT NULL,
2168 access_level text NOT NULL,
2169 created timestamp with time zone DEFAULT now() NOT NULL,
2170 modified timestamp with time zone DEFAULT now() NOT NULL
2174 ALTER TABLE public.source_acl OWNER TO dak;
2177 -- Name: source_acl_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2180 CREATE SEQUENCE source_acl_id_seq
2188 ALTER TABLE public.source_acl_id_seq OWNER TO dak;
2191 -- Name: source_acl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2194 ALTER SEQUENCE source_acl_id_seq OWNED BY source_acl.id;
2198 -- Name: source_metadata; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2201 CREATE TABLE source_metadata (
2202 src_id integer NOT NULL,
2203 key_id integer NOT NULL,
2208 ALTER TABLE public.source_metadata OWNER TO dak;
2211 -- Name: src_contents; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2214 CREATE TABLE src_contents (
2216 source_id integer NOT NULL,
2217 created timestamp with time zone DEFAULT now() NOT NULL,
2218 modified timestamp with time zone DEFAULT now() NOT NULL
2222 ALTER TABLE public.src_contents OWNER TO dak;
2225 -- Name: src_format; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2228 CREATE TABLE src_format (
2229 id integer NOT NULL,
2230 format_name text NOT NULL,
2231 created timestamp with time zone DEFAULT now() NOT NULL,
2232 modified timestamp with time zone DEFAULT now() NOT NULL
2236 ALTER TABLE public.src_format OWNER TO dak;
2239 -- Name: src_format_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2242 CREATE SEQUENCE src_format_id_seq
2250 ALTER TABLE public.src_format_id_seq OWNER TO dak;
2253 -- Name: src_format_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2256 ALTER SEQUENCE src_format_id_seq OWNED BY src_format.id;
2260 -- Name: src_uploaders; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2263 CREATE TABLE src_uploaders (
2264 id integer NOT NULL,
2265 source integer NOT NULL,
2266 maintainer integer NOT NULL,
2267 created timestamp with time zone DEFAULT now() NOT NULL,
2268 modified timestamp with time zone DEFAULT now() NOT NULL
2272 ALTER TABLE public.src_uploaders OWNER TO dak;
2275 -- Name: src_uploaders_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2278 CREATE SEQUENCE src_uploaders_id_seq
2286 ALTER TABLE public.src_uploaders_id_seq OWNER TO dak;
2289 -- Name: src_uploaders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2292 ALTER SEQUENCE src_uploaders_id_seq OWNED BY src_uploaders.id;
2296 -- Name: suite_architectures; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2299 CREATE TABLE suite_architectures (
2300 suite integer NOT NULL,
2301 architecture integer NOT NULL,
2302 created timestamp with time zone DEFAULT now() NOT NULL,
2303 modified timestamp with time zone DEFAULT now() NOT NULL
2307 ALTER TABLE public.suite_architectures OWNER TO dak;
2310 -- Name: suite_arch_by_name; Type: VIEW; Schema: public; Owner: dak
2313 CREATE VIEW suite_arch_by_name AS
2314 SELECT suite.suite_name AS suite, a.arch_string AS arch FROM ((suite_architectures sa JOIN architecture a ON ((sa.architecture = a.id))) JOIN suite ON ((sa.suite = suite.id))) WHERE (a.arch_string <> ALL (ARRAY['all'::text, 'source'::text]));
2317 ALTER TABLE public.suite_arch_by_name OWNER TO dak;
2320 -- Name: suite_build_queue_copy; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2323 CREATE TABLE suite_build_queue_copy (
2324 suite integer NOT NULL,
2325 build_queue_id integer NOT NULL,
2326 created timestamp with time zone DEFAULT now() NOT NULL,
2327 modified timestamp with time zone DEFAULT now() NOT NULL
2331 ALTER TABLE public.suite_build_queue_copy OWNER TO dak;
2334 -- Name: suite_src_formats; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2337 CREATE TABLE suite_src_formats (
2338 suite integer NOT NULL,
2339 src_format integer NOT NULL,
2340 created timestamp with time zone DEFAULT now() NOT NULL,
2341 modified timestamp with time zone DEFAULT now() NOT NULL
2345 ALTER TABLE public.suite_src_formats OWNER TO dak;
2348 -- Name: uid_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2351 CREATE SEQUENCE uid_id_seq
2359 ALTER TABLE public.uid_id_seq OWNER TO dak;
2362 -- Name: uid; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2366 id integer DEFAULT nextval('uid_id_seq'::regclass) NOT NULL,
2369 created timestamp with time zone DEFAULT now() NOT NULL,
2370 modified timestamp with time zone DEFAULT now() NOT NULL
2374 ALTER TABLE public.uid OWNER TO dak;
2377 -- Name: upload_blocks; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2380 CREATE TABLE upload_blocks (
2381 id integer NOT NULL,
2382 source text NOT NULL,
2384 fingerprint_id integer,
2386 reason text NOT NULL,
2387 created timestamp with time zone DEFAULT now() NOT NULL,
2388 modified timestamp with time zone DEFAULT now() NOT NULL,
2389 CONSTRAINT upload_blocks_check CHECK (((fingerprint_id IS NOT NULL) OR (uid_id IS NOT NULL)))
2393 ALTER TABLE public.upload_blocks OWNER TO dak;
2396 -- Name: upload_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2399 CREATE SEQUENCE upload_blocks_id_seq
2407 ALTER TABLE public.upload_blocks_id_seq OWNER TO dak;
2410 -- Name: upload_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2413 ALTER SEQUENCE upload_blocks_id_seq OWNED BY upload_blocks.id;
2417 -- Name: version_check; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2420 CREATE TABLE version_check (
2421 suite integer NOT NULL,
2422 "check" text NOT NULL,
2423 reference integer NOT NULL,
2424 CONSTRAINT version_check_check_check CHECK (("check" = ANY (ARRAY['Enhances'::text, 'MustBeNewerThan'::text, 'MustBeOlderThan'::text])))
2428 ALTER TABLE public.version_check OWNER TO dak;
2431 -- Name: version_checks; Type: VIEW; Schema: public; Owner: dak
2434 CREATE VIEW version_checks AS
2435 SELECT s.suite_name AS source_suite, v."check" AS condition, t.suite_name AS target_suite FROM ((suite s JOIN version_check v ON ((s.id = v.suite))) JOIN suite t ON ((v.reference = t.id))) ORDER BY s.suite_name, v."check", t.suite_name;
2438 ALTER TABLE public.version_checks OWNER TO dak;
2441 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2444 ALTER TABLE binary_acl ALTER COLUMN id SET DEFAULT nextval('binary_acl_id_seq'::regclass);
2448 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2451 ALTER TABLE binary_acl_map ALTER COLUMN id SET DEFAULT nextval('binary_acl_map_id_seq'::regclass);
2455 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2458 ALTER TABLE build_queue ALTER COLUMN id SET DEFAULT nextval('build_queue_id_seq'::regclass);
2462 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2465 ALTER TABLE build_queue_files ALTER COLUMN id SET DEFAULT nextval('build_queue_files_id_seq'::regclass);
2469 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2472 ALTER TABLE changelogs_text ALTER COLUMN id SET DEFAULT nextval('changelogs_text_id_seq'::regclass);
2476 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2479 ALTER TABLE changes ALTER COLUMN id SET DEFAULT nextval('changes_id_seq'::regclass);
2483 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2486 ALTER TABLE changes_pending_binaries ALTER COLUMN id SET DEFAULT nextval('changes_pending_binaries_id_seq'::regclass);
2490 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2493 ALTER TABLE changes_pending_files ALTER COLUMN id SET DEFAULT nextval('changes_pending_files_id_seq'::regclass);
2497 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2500 ALTER TABLE changes_pending_source ALTER COLUMN id SET DEFAULT nextval('changes_pending_source_id_seq'::regclass);
2504 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2507 ALTER TABLE config ALTER COLUMN id SET DEFAULT nextval('config_id_seq'::regclass);
2511 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2514 ALTER TABLE keyring_acl_map ALTER COLUMN id SET DEFAULT nextval('keyring_acl_map_id_seq'::regclass);
2518 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2521 ALTER TABLE keyrings ALTER COLUMN id SET DEFAULT nextval('keyrings_id_seq'::regclass);
2525 -- Name: key_id; Type: DEFAULT; Schema: public; Owner: dak
2528 ALTER TABLE metadata_keys ALTER COLUMN key_id SET DEFAULT nextval('metadata_keys_key_id_seq'::regclass);
2532 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2535 ALTER TABLE new_comments ALTER COLUMN id SET DEFAULT nextval('new_comments_id_seq'::regclass);
2539 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2542 ALTER TABLE policy_queue ALTER COLUMN id SET DEFAULT nextval('policy_queue_id_seq'::regclass);
2546 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2549 ALTER TABLE source_acl ALTER COLUMN id SET DEFAULT nextval('source_acl_id_seq'::regclass);
2553 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2556 ALTER TABLE src_format ALTER COLUMN id SET DEFAULT nextval('src_format_id_seq'::regclass);
2560 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2563 ALTER TABLE src_uploaders ALTER COLUMN id SET DEFAULT nextval('src_uploaders_id_seq'::regclass);
2567 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2570 ALTER TABLE upload_blocks ALTER COLUMN id SET DEFAULT nextval('upload_blocks_id_seq'::regclass);
2574 -- Name: architecture_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2577 ALTER TABLE ONLY architecture
2578 ADD CONSTRAINT architecture_pkey PRIMARY KEY (id);
2582 -- Name: archive_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2585 ALTER TABLE ONLY archive
2586 ADD CONSTRAINT archive_pkey PRIMARY KEY (id);
2590 -- Name: bin_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2593 ALTER TABLE ONLY bin_associations
2594 ADD CONSTRAINT bin_associations_pkey PRIMARY KEY (id);
2598 -- Name: bin_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2601 ALTER TABLE ONLY bin_contents
2602 ADD CONSTRAINT bin_contents_pkey PRIMARY KEY (file, binary_id);
2606 -- Name: binaries_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2609 ALTER TABLE ONLY binaries_metadata
2610 ADD CONSTRAINT binaries_metadata_pkey PRIMARY KEY (bin_id, key_id);
2614 -- Name: binaries_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2617 ALTER TABLE ONLY binaries
2618 ADD CONSTRAINT binaries_pkey PRIMARY KEY (id);
2622 -- Name: binary_acl_access_level_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2625 ALTER TABLE ONLY binary_acl
2626 ADD CONSTRAINT binary_acl_access_level_key UNIQUE (access_level);
2630 -- Name: binary_acl_map_fingerprint_id_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2633 ALTER TABLE ONLY binary_acl_map
2634 ADD CONSTRAINT binary_acl_map_fingerprint_id_key UNIQUE (fingerprint_id, architecture_id);
2638 -- Name: binary_acl_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2641 ALTER TABLE ONLY binary_acl_map
2642 ADD CONSTRAINT binary_acl_map_pkey PRIMARY KEY (id);
2646 -- Name: binary_acl_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2649 ALTER TABLE ONLY binary_acl
2650 ADD CONSTRAINT binary_acl_pkey PRIMARY KEY (id);
2654 -- Name: build_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2657 ALTER TABLE ONLY build_queue
2658 ADD CONSTRAINT build_queue_pkey PRIMARY KEY (id);
2662 -- Name: build_queue_policy_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2665 ALTER TABLE ONLY build_queue_policy_files
2666 ADD CONSTRAINT build_queue_policy_files_pkey PRIMARY KEY (build_queue_id, file_id);
2670 -- Name: build_queue_queue_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2673 ALTER TABLE ONLY build_queue
2674 ADD CONSTRAINT build_queue_queue_name_key UNIQUE (queue_name);
2678 -- Name: changelogs_text_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2681 ALTER TABLE ONLY changelogs_text
2682 ADD CONSTRAINT changelogs_text_pkey PRIMARY KEY (id);
2686 -- Name: changes_pending_binaries_package_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2689 ALTER TABLE ONLY changes_pending_binaries
2690 ADD CONSTRAINT changes_pending_binaries_package_key UNIQUE (package, version, architecture_id);
2694 -- Name: changes_pending_binaries_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2697 ALTER TABLE ONLY changes_pending_binaries
2698 ADD CONSTRAINT changes_pending_binaries_pkey PRIMARY KEY (id);
2702 -- Name: changes_pending_files_filename_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2705 ALTER TABLE ONLY changes_pending_files
2706 ADD CONSTRAINT changes_pending_files_filename_key UNIQUE (filename);
2710 -- Name: changes_pending_files_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2713 ALTER TABLE ONLY changes_pending_files_map
2714 ADD CONSTRAINT changes_pending_files_map_pkey PRIMARY KEY (file_id, change_id);
2718 -- Name: changes_pending_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2721 ALTER TABLE ONLY changes_pending_files
2722 ADD CONSTRAINT changes_pending_files_pkey PRIMARY KEY (id);
2726 -- Name: changes_pending_source_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2729 ALTER TABLE ONLY changes_pending_source_files
2730 ADD CONSTRAINT changes_pending_source_files_pkey PRIMARY KEY (pending_source_id, pending_file_id);
2734 -- Name: changes_pending_source_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2737 ALTER TABLE ONLY changes_pending_source
2738 ADD CONSTRAINT changes_pending_source_pkey PRIMARY KEY (id);
2742 -- Name: changes_pool_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2745 ALTER TABLE ONLY changes_pool_files
2746 ADD CONSTRAINT changes_pool_files_pkey PRIMARY KEY (changeid, fileid);
2750 -- Name: component_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2753 ALTER TABLE ONLY component
2754 ADD CONSTRAINT component_pkey PRIMARY KEY (id);
2758 -- Name: config_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2761 ALTER TABLE ONLY config
2762 ADD CONSTRAINT config_name_key UNIQUE (name);
2766 -- Name: config_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2769 ALTER TABLE ONLY config
2770 ADD CONSTRAINT config_pkey PRIMARY KEY (id);
2774 -- Name: dsc_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2777 ALTER TABLE ONLY dsc_files
2778 ADD CONSTRAINT dsc_files_pkey PRIMARY KEY (id);
2782 -- Name: external_overrides_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2785 ALTER TABLE ONLY external_overrides
2786 ADD CONSTRAINT external_overrides_pkey PRIMARY KEY (suite, component, package, key);
2790 -- Name: extra_src_references_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2793 ALTER TABLE ONLY extra_src_references
2794 ADD CONSTRAINT extra_src_references_pkey PRIMARY KEY (bin_id, src_id);
2798 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2801 ALTER TABLE ONLY files
2802 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
2806 -- Name: fingerprint_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2809 ALTER TABLE ONLY fingerprint
2810 ADD CONSTRAINT fingerprint_pkey PRIMARY KEY (id);
2814 -- Name: keyring_acl_map_keyring_id_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2817 ALTER TABLE ONLY keyring_acl_map
2818 ADD CONSTRAINT keyring_acl_map_keyring_id_key UNIQUE (keyring_id, architecture_id);
2822 -- Name: keyring_acl_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2825 ALTER TABLE ONLY keyring_acl_map
2826 ADD CONSTRAINT keyring_acl_map_pkey PRIMARY KEY (id);
2830 -- Name: keyrings_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2833 ALTER TABLE ONLY keyrings
2834 ADD CONSTRAINT keyrings_name_key UNIQUE (name);
2838 -- Name: keyrings_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2841 ALTER TABLE ONLY keyrings
2842 ADD CONSTRAINT keyrings_pkey PRIMARY KEY (id);
2846 -- Name: known_changes_changesname_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2849 ALTER TABLE ONLY changes
2850 ADD CONSTRAINT known_changes_changesname_key UNIQUE (changesname);
2854 -- Name: known_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2857 ALTER TABLE ONLY changes
2858 ADD CONSTRAINT known_changes_pkey PRIMARY KEY (id);
2862 -- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2865 ALTER TABLE ONLY location
2866 ADD CONSTRAINT location_pkey PRIMARY KEY (id);
2870 -- Name: maintainer_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2873 ALTER TABLE ONLY maintainer
2874 ADD CONSTRAINT maintainer_pkey PRIMARY KEY (id);
2878 -- Name: metadata_keys_key_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2881 ALTER TABLE ONLY metadata_keys
2882 ADD CONSTRAINT metadata_keys_key_key UNIQUE (key);
2886 -- Name: metadata_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2889 ALTER TABLE ONLY metadata_keys
2890 ADD CONSTRAINT metadata_keys_pkey PRIMARY KEY (key_id);
2894 -- Name: new_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2897 ALTER TABLE ONLY new_comments
2898 ADD CONSTRAINT new_comments_pkey PRIMARY KEY (id);
2902 -- Name: override_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2905 ALTER TABLE ONLY override
2906 ADD CONSTRAINT override_pkey PRIMARY KEY (suite, component, package, type);
2910 -- Name: override_type_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2913 ALTER TABLE ONLY override_type
2914 ADD CONSTRAINT override_type_pkey PRIMARY KEY (id);
2918 -- Name: policy_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2921 ALTER TABLE ONLY policy_queue
2922 ADD CONSTRAINT policy_queue_pkey PRIMARY KEY (id);
2926 -- Name: policy_queue_queue_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2929 ALTER TABLE ONLY policy_queue
2930 ADD CONSTRAINT policy_queue_queue_name_key UNIQUE (queue_name);
2934 -- Name: priority_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2937 ALTER TABLE ONLY priority
2938 ADD CONSTRAINT priority_pkey PRIMARY KEY (id);
2942 -- Name: queue_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2945 ALTER TABLE ONLY build_queue_files
2946 ADD CONSTRAINT queue_files_pkey PRIMARY KEY (id);
2950 -- Name: section_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2953 ALTER TABLE ONLY section
2954 ADD CONSTRAINT section_pkey PRIMARY KEY (id);
2958 -- Name: source_acl_access_level_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2961 ALTER TABLE ONLY source_acl
2962 ADD CONSTRAINT source_acl_access_level_key UNIQUE (access_level);
2966 -- Name: source_acl_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2969 ALTER TABLE ONLY source_acl
2970 ADD CONSTRAINT source_acl_pkey PRIMARY KEY (id);
2974 -- Name: source_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2977 ALTER TABLE ONLY source_metadata
2978 ADD CONSTRAINT source_metadata_pkey PRIMARY KEY (src_id, key_id);
2982 -- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2985 ALTER TABLE ONLY source
2986 ADD CONSTRAINT source_pkey PRIMARY KEY (id);
2990 -- Name: src_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2993 ALTER TABLE ONLY src_associations
2994 ADD CONSTRAINT src_associations_pkey PRIMARY KEY (id);
2998 -- Name: src_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3001 ALTER TABLE ONLY src_contents
3002 ADD CONSTRAINT src_contents_pkey PRIMARY KEY (file, source_id);
3006 -- Name: src_format_format_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3009 ALTER TABLE ONLY src_format
3010 ADD CONSTRAINT src_format_format_name_key UNIQUE (format_name);
3014 -- Name: src_format_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3017 ALTER TABLE ONLY src_format
3018 ADD CONSTRAINT src_format_pkey PRIMARY KEY (id);
3022 -- Name: src_uploaders_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3025 ALTER TABLE ONLY src_uploaders
3026 ADD CONSTRAINT src_uploaders_pkey PRIMARY KEY (id);
3030 -- Name: src_uploaders_source_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3033 ALTER TABLE ONLY src_uploaders
3034 ADD CONSTRAINT src_uploaders_source_key UNIQUE (source, maintainer);
3038 -- Name: suite_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3041 ALTER TABLE ONLY suite_architectures
3042 ADD CONSTRAINT suite_architectures_pkey PRIMARY KEY (suite, architecture);
3046 -- Name: suite_name_unique; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3049 ALTER TABLE ONLY suite
3050 ADD CONSTRAINT suite_name_unique UNIQUE (suite_name);
3054 -- Name: suite_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3057 ALTER TABLE ONLY suite
3058 ADD CONSTRAINT suite_pkey PRIMARY KEY (id);
3062 -- Name: suite_queue_copy_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3065 ALTER TABLE ONLY suite_build_queue_copy
3066 ADD CONSTRAINT suite_queue_copy_pkey PRIMARY KEY (suite, build_queue_id);
3070 -- Name: suite_src_formats_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3073 ALTER TABLE ONLY suite_src_formats
3074 ADD CONSTRAINT suite_src_formats_pkey PRIMARY KEY (suite, src_format);
3078 -- Name: suite_src_formats_suite_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3081 ALTER TABLE ONLY suite_src_formats
3082 ADD CONSTRAINT suite_src_formats_suite_key UNIQUE (suite, src_format);
3086 -- Name: uid_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3089 ALTER TABLE ONLY uid
3090 ADD CONSTRAINT uid_pkey PRIMARY KEY (id);
3094 -- Name: upload_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3097 ALTER TABLE ONLY upload_blocks
3098 ADD CONSTRAINT upload_blocks_pkey PRIMARY KEY (id);
3102 -- Name: version_check_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3105 ALTER TABLE ONLY version_check
3106 ADD CONSTRAINT version_check_pkey PRIMARY KEY (suite, "check", reference);
3110 -- Name: architecture_arch_string_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3113 CREATE UNIQUE INDEX architecture_arch_string_key ON architecture USING btree (arch_string);
3117 -- Name: archive_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3120 CREATE UNIQUE INDEX archive_name_key ON archive USING btree (name);
3124 -- Name: bin_associations_bin; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3127 CREATE INDEX bin_associations_bin ON bin_associations USING btree (bin);
3131 -- Name: bin_associations_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3134 CREATE UNIQUE INDEX bin_associations_suite_key ON bin_associations USING btree (suite, bin);
3138 -- Name: binaries_architecture_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3141 CREATE INDEX binaries_architecture_idx ON binaries USING btree (architecture);
3145 -- Name: binaries_by_package; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3148 CREATE INDEX binaries_by_package ON binaries USING btree (id, package);
3152 -- Name: binaries_file_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3155 CREATE UNIQUE INDEX binaries_file_key ON binaries USING btree (file);
3159 -- Name: binaries_files; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3162 CREATE INDEX binaries_files ON binaries USING btree (file);
3166 -- Name: binaries_fingerprint; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3169 CREATE INDEX binaries_fingerprint ON binaries USING btree (sig_fpr);
3173 -- Name: binaries_id; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3176 CREATE UNIQUE INDEX binaries_id ON binaries USING btree (id);
3180 -- Name: binaries_maintainer; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3183 CREATE INDEX binaries_maintainer ON binaries USING btree (maintainer);
3187 -- Name: binaries_package_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3190 CREATE UNIQUE INDEX binaries_package_key ON binaries USING btree (package, version, architecture);
3194 -- Name: changesapproved_for; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3197 CREATE INDEX changesapproved_for ON changes USING btree (approved_for);
3201 -- Name: changesdistribution_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3204 CREATE INDEX changesdistribution_ind ON changes USING btree (distribution);
3208 -- Name: changesin_queue; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3211 CREATE INDEX changesin_queue ON changes USING btree (in_queue);
3215 -- Name: changesin_queue_approved_for; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3218 CREATE INDEX changesin_queue_approved_for ON changes USING btree (in_queue, approved_for);
3222 -- Name: changesname_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3225 CREATE INDEX changesname_ind ON changes USING btree (changesname);
3229 -- Name: changessource_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3232 CREATE INDEX changessource_ind ON changes USING btree (source);
3236 -- Name: changestimestamp_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3239 CREATE INDEX changestimestamp_ind ON changes USING btree (seen);
3243 -- Name: changesurgency_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3246 CREATE INDEX changesurgency_ind ON changes USING btree (urgency);
3250 -- Name: component_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3253 CREATE UNIQUE INDEX component_name_key ON component USING btree (name);
3257 -- Name: dsc_files_file; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3260 CREATE INDEX dsc_files_file ON dsc_files USING btree (file);
3264 -- Name: dsc_files_source_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3267 CREATE UNIQUE INDEX dsc_files_source_key ON dsc_files USING btree (source, file);
3271 -- Name: files_filename_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3274 CREATE UNIQUE INDEX files_filename_key ON files USING btree (filename, location);
3278 -- Name: files_last_used; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3281 CREATE INDEX files_last_used ON files USING btree (last_used);
3285 -- Name: fingerprint_fingerprint_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3288 CREATE UNIQUE INDEX fingerprint_fingerprint_key ON fingerprint USING btree (fingerprint);
3292 -- Name: ind_bin_contents_binary; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3295 CREATE INDEX ind_bin_contents_binary ON bin_contents USING btree (binary_id);
3299 -- Name: jjt; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3302 CREATE INDEX jjt ON files USING btree (id);
3306 -- Name: jjt2; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3309 CREATE INDEX jjt2 ON files USING btree (location);
3313 -- Name: jjt3; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3316 CREATE INDEX jjt3 ON files USING btree (id, location);
3320 -- Name: jjt4; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3323 CREATE INDEX jjt4 ON binaries USING btree (source);
3327 -- Name: jjt5; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3330 CREATE INDEX jjt5 ON binaries USING btree (id, source);
3334 -- Name: jjt_override_type_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3337 CREATE INDEX jjt_override_type_idx ON override USING btree (type);
3341 -- Name: maintainer_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3344 CREATE UNIQUE INDEX maintainer_name_key ON maintainer USING btree (name);
3348 -- Name: override_by_package; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3351 CREATE INDEX override_by_package ON override USING btree (package);
3355 -- Name: override_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3358 CREATE UNIQUE INDEX override_suite_key ON override USING btree (suite, component, package, type);
3362 -- Name: override_type_type_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3365 CREATE UNIQUE INDEX override_type_type_key ON override_type USING btree (type);
3369 -- Name: priority_level_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3372 CREATE UNIQUE INDEX priority_level_key ON priority USING btree (level);
3376 -- Name: priority_priority_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3379 CREATE UNIQUE INDEX priority_priority_key ON priority USING btree (priority);
3383 -- Name: section_section_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3386 CREATE UNIQUE INDEX section_section_key ON section USING btree (section);
3390 -- Name: source_file_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3393 CREATE UNIQUE INDEX source_file_key ON source USING btree (file);
3397 -- Name: source_fingerprint; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3400 CREATE INDEX source_fingerprint ON source USING btree (sig_fpr);
3404 -- Name: source_maintainer; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3407 CREATE INDEX source_maintainer ON source USING btree (maintainer);
3411 -- Name: source_source_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3414 CREATE UNIQUE INDEX source_source_key ON source USING btree (source, version);
3418 -- Name: src_associations_source; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3421 CREATE INDEX src_associations_source ON src_associations USING btree (source);
3425 -- Name: src_associations_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3428 CREATE UNIQUE INDEX src_associations_suite_key ON src_associations USING btree (suite, source);
3432 -- Name: src_contents_source_id_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3435 CREATE INDEX src_contents_source_id_idx ON src_contents USING btree (source_id);
3439 -- Name: suite_architectures_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3442 CREATE UNIQUE INDEX suite_architectures_suite_key ON suite_architectures USING btree (suite, architecture);
3446 -- Name: suite_hash; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3449 CREATE INDEX suite_hash ON suite USING hash (suite_name);
3453 -- Name: uid_uid_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3456 CREATE UNIQUE INDEX uid_uid_key ON uid USING btree (uid);
3460 -- Name: modified_architecture; Type: TRIGGER; Schema: public; Owner: dak
3463 CREATE TRIGGER modified_architecture BEFORE UPDATE ON architecture FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3467 -- Name: modified_archive; Type: TRIGGER; Schema: public; Owner: dak
3470 CREATE TRIGGER modified_archive BEFORE UPDATE ON archive FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3474 -- Name: modified_bin_associations; Type: TRIGGER; Schema: public; Owner: dak
3477 CREATE TRIGGER modified_bin_associations BEFORE UPDATE ON bin_associations FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3481 -- Name: modified_bin_contents; Type: TRIGGER; Schema: public; Owner: dak
3484 CREATE TRIGGER modified_bin_contents BEFORE UPDATE ON bin_contents FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3488 -- Name: modified_binaries; Type: TRIGGER; Schema: public; Owner: dak
3491 CREATE TRIGGER modified_binaries BEFORE UPDATE ON binaries FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3495 -- Name: modified_binary_acl; Type: TRIGGER; Schema: public; Owner: dak
3498 CREATE TRIGGER modified_binary_acl BEFORE UPDATE ON binary_acl FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3502 -- Name: modified_binary_acl_map; Type: TRIGGER; Schema: public; Owner: dak
3505 CREATE TRIGGER modified_binary_acl_map BEFORE UPDATE ON binary_acl_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3509 -- Name: modified_build_queue; Type: TRIGGER; Schema: public; Owner: dak
3512 CREATE TRIGGER modified_build_queue BEFORE UPDATE ON build_queue FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3516 -- Name: modified_build_queue_files; Type: TRIGGER; Schema: public; Owner: dak
3519 CREATE TRIGGER modified_build_queue_files BEFORE UPDATE ON build_queue_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3523 -- Name: modified_changes; Type: TRIGGER; Schema: public; Owner: dak
3526 CREATE TRIGGER modified_changes BEFORE UPDATE ON changes FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3530 -- Name: modified_changes_pending_binaries; Type: TRIGGER; Schema: public; Owner: dak
3533 CREATE TRIGGER modified_changes_pending_binaries BEFORE UPDATE ON changes_pending_binaries FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3537 -- Name: modified_changes_pending_files; Type: TRIGGER; Schema: public; Owner: dak
3540 CREATE TRIGGER modified_changes_pending_files BEFORE UPDATE ON changes_pending_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3544 -- Name: modified_changes_pending_files_map; Type: TRIGGER; Schema: public; Owner: dak
3547 CREATE TRIGGER modified_changes_pending_files_map BEFORE UPDATE ON changes_pending_files_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3551 -- Name: modified_changes_pending_source; Type: TRIGGER; Schema: public; Owner: dak
3554 CREATE TRIGGER modified_changes_pending_source BEFORE UPDATE ON changes_pending_source FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3558 -- Name: modified_changes_pending_source_files; Type: TRIGGER; Schema: public; Owner: dak
3561 CREATE TRIGGER modified_changes_pending_source_files BEFORE UPDATE ON changes_pending_source_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3565 -- Name: modified_changes_pool_files; Type: TRIGGER; Schema: public; Owner: dak
3568 CREATE TRIGGER modified_changes_pool_files BEFORE UPDATE ON changes_pool_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3572 -- Name: modified_component; Type: TRIGGER; Schema: public; Owner: dak
3575 CREATE TRIGGER modified_component BEFORE UPDATE ON component FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3579 -- Name: modified_config; Type: TRIGGER; Schema: public; Owner: dak
3582 CREATE TRIGGER modified_config BEFORE UPDATE ON config FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3586 -- Name: modified_dsc_files; Type: TRIGGER; Schema: public; Owner: dak
3589 CREATE TRIGGER modified_dsc_files BEFORE UPDATE ON dsc_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3593 -- Name: modified_files; Type: TRIGGER; Schema: public; Owner: dak
3596 CREATE TRIGGER modified_files BEFORE UPDATE ON files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3600 -- Name: modified_fingerprint; Type: TRIGGER; Schema: public; Owner: dak
3603 CREATE TRIGGER modified_fingerprint BEFORE UPDATE ON fingerprint FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3607 -- Name: modified_keyring_acl_map; Type: TRIGGER; Schema: public; Owner: dak
3610 CREATE TRIGGER modified_keyring_acl_map BEFORE UPDATE ON keyring_acl_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3614 -- Name: modified_keyrings; Type: TRIGGER; Schema: public; Owner: dak
3617 CREATE TRIGGER modified_keyrings BEFORE UPDATE ON keyrings FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3621 -- Name: modified_location; Type: TRIGGER; Schema: public; Owner: dak
3624 CREATE TRIGGER modified_location BEFORE UPDATE ON location FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3628 -- Name: modified_maintainer; Type: TRIGGER; Schema: public; Owner: dak
3631 CREATE TRIGGER modified_maintainer BEFORE UPDATE ON maintainer FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3635 -- Name: modified_new_comments; Type: TRIGGER; Schema: public; Owner: dak
3638 CREATE TRIGGER modified_new_comments BEFORE UPDATE ON new_comments FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3642 -- Name: modified_override; Type: TRIGGER; Schema: public; Owner: dak
3645 CREATE TRIGGER modified_override BEFORE UPDATE ON override FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3649 -- Name: modified_override_type; Type: TRIGGER; Schema: public; Owner: dak
3652 CREATE TRIGGER modified_override_type BEFORE UPDATE ON override_type FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3656 -- Name: modified_policy_queue; Type: TRIGGER; Schema: public; Owner: dak
3659 CREATE TRIGGER modified_policy_queue BEFORE UPDATE ON policy_queue FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3663 -- Name: modified_priority; Type: TRIGGER; Schema: public; Owner: dak
3666 CREATE TRIGGER modified_priority BEFORE UPDATE ON priority FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3670 -- Name: modified_section; Type: TRIGGER; Schema: public; Owner: dak
3673 CREATE TRIGGER modified_section BEFORE UPDATE ON section FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3677 -- Name: modified_source; Type: TRIGGER; Schema: public; Owner: dak
3680 CREATE TRIGGER modified_source BEFORE UPDATE ON source FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3684 -- Name: modified_source_acl; Type: TRIGGER; Schema: public; Owner: dak
3687 CREATE TRIGGER modified_source_acl BEFORE UPDATE ON source_acl FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3691 -- Name: modified_src_associations; Type: TRIGGER; Schema: public; Owner: dak
3694 CREATE TRIGGER modified_src_associations BEFORE UPDATE ON src_associations FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3698 -- Name: modified_src_contents; Type: TRIGGER; Schema: public; Owner: dak
3701 CREATE TRIGGER modified_src_contents BEFORE UPDATE ON src_contents FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3705 -- Name: modified_src_format; Type: TRIGGER; Schema: public; Owner: dak
3708 CREATE TRIGGER modified_src_format BEFORE UPDATE ON src_format FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3712 -- Name: modified_src_uploaders; Type: TRIGGER; Schema: public; Owner: dak
3715 CREATE TRIGGER modified_src_uploaders BEFORE UPDATE ON src_uploaders FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3719 -- Name: modified_suite; Type: TRIGGER; Schema: public; Owner: dak
3722 CREATE TRIGGER modified_suite BEFORE UPDATE ON suite FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3726 -- Name: modified_suite_architectures; Type: TRIGGER; Schema: public; Owner: dak
3729 CREATE TRIGGER modified_suite_architectures BEFORE UPDATE ON suite_architectures FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3733 -- Name: modified_suite_build_queue_copy; Type: TRIGGER; Schema: public; Owner: dak
3736 CREATE TRIGGER modified_suite_build_queue_copy BEFORE UPDATE ON suite_build_queue_copy FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3740 -- Name: modified_suite_src_formats; Type: TRIGGER; Schema: public; Owner: dak
3743 CREATE TRIGGER modified_suite_src_formats BEFORE UPDATE ON suite_src_formats FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3747 -- Name: modified_uid; Type: TRIGGER; Schema: public; Owner: dak
3750 CREATE TRIGGER modified_uid BEFORE UPDATE ON uid FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3754 -- Name: modified_upload_blocks; Type: TRIGGER; Schema: public; Owner: dak
3757 CREATE TRIGGER modified_upload_blocks BEFORE UPDATE ON upload_blocks FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3761 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: dak
3764 ALTER TABLE ONLY fingerprint
3765 ADD CONSTRAINT "$1" FOREIGN KEY (keyring) REFERENCES keyrings(id);
3769 -- Name: bin_associations_bin; Type: FK CONSTRAINT; Schema: public; Owner: dak
3772 ALTER TABLE ONLY bin_associations
3773 ADD CONSTRAINT bin_associations_bin FOREIGN KEY (bin) REFERENCES binaries(id) MATCH FULL;
3777 -- Name: bin_associations_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
3780 ALTER TABLE ONLY bin_associations
3781 ADD CONSTRAINT bin_associations_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
3785 -- Name: bin_contents_bin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3788 ALTER TABLE ONLY bin_contents
3789 ADD CONSTRAINT bin_contents_bin_fkey FOREIGN KEY (binary_id) REFERENCES binaries(id) ON DELETE CASCADE;
3793 -- Name: binaries_architecture; Type: FK CONSTRAINT; Schema: public; Owner: dak
3796 ALTER TABLE ONLY binaries
3797 ADD CONSTRAINT binaries_architecture FOREIGN KEY (architecture) REFERENCES architecture(id) MATCH FULL;
3801 -- Name: binaries_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
3804 ALTER TABLE ONLY binaries
3805 ADD CONSTRAINT binaries_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
3809 -- Name: binaries_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
3812 ALTER TABLE ONLY binaries
3813 ADD CONSTRAINT binaries_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
3817 -- Name: binaries_metadata_bin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3820 ALTER TABLE ONLY binaries_metadata
3821 ADD CONSTRAINT binaries_metadata_bin_id_fkey FOREIGN KEY (bin_id) REFERENCES binaries(id) ON DELETE CASCADE;
3825 -- Name: binaries_metadata_key_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3828 ALTER TABLE ONLY binaries_metadata
3829 ADD CONSTRAINT binaries_metadata_key_id_fkey FOREIGN KEY (key_id) REFERENCES metadata_keys(key_id);
3833 -- Name: binaries_sig_fpr; Type: FK CONSTRAINT; Schema: public; Owner: dak
3836 ALTER TABLE ONLY binaries
3837 ADD CONSTRAINT binaries_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
3841 -- Name: binaries_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
3844 ALTER TABLE ONLY binaries
3845 ADD CONSTRAINT binaries_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
3849 -- Name: binary_acl_map_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3852 ALTER TABLE ONLY binary_acl_map
3853 ADD CONSTRAINT binary_acl_map_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
3857 -- Name: binary_acl_map_fingerprint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3860 ALTER TABLE ONLY binary_acl_map
3861 ADD CONSTRAINT binary_acl_map_fingerprint_id_fkey FOREIGN KEY (fingerprint_id) REFERENCES fingerprint(id);
3865 -- Name: build_queue_files_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3868 ALTER TABLE ONLY build_queue_files
3869 ADD CONSTRAINT build_queue_files_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE CASCADE;
3873 -- Name: build_queue_policy_files_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3876 ALTER TABLE ONLY build_queue_policy_files
3877 ADD CONSTRAINT build_queue_policy_files_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE CASCADE;
3881 -- Name: build_queue_policy_files_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3884 ALTER TABLE ONLY build_queue_policy_files
3885 ADD CONSTRAINT build_queue_policy_files_file_id_fkey FOREIGN KEY (file_id) REFERENCES changes_pending_files(id) ON DELETE CASCADE;
3889 -- Name: changes_pending_binaries_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3892 ALTER TABLE ONLY changes_pending_binaries
3893 ADD CONSTRAINT changes_pending_binaries_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
3897 -- Name: changes_pending_binaries_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3900 ALTER TABLE ONLY changes_pending_binaries
3901 ADD CONSTRAINT changes_pending_binaries_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3905 -- Name: changes_pending_binaries_pending_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3908 ALTER TABLE ONLY changes_pending_binaries
3909 ADD CONSTRAINT changes_pending_binaries_pending_file_id_fkey FOREIGN KEY (pending_file_id) REFERENCES changes_pending_files(id);
3913 -- Name: changes_pending_binaries_pending_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3916 ALTER TABLE ONLY changes_pending_binaries
3917 ADD CONSTRAINT changes_pending_binaries_pending_source_id_fkey FOREIGN KEY (pending_source_id) REFERENCES changes_pending_source(id);
3921 -- Name: changes_pending_binaries_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3924 ALTER TABLE ONLY changes_pending_binaries
3925 ADD CONSTRAINT changes_pending_binaries_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(id);
3929 -- Name: changes_pending_files_map_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3932 ALTER TABLE ONLY changes_pending_files_map
3933 ADD CONSTRAINT changes_pending_files_map_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3937 -- Name: changes_pending_files_map_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3940 ALTER TABLE ONLY changes_pending_files_map
3941 ADD CONSTRAINT changes_pending_files_map_file_id_fkey FOREIGN KEY (file_id) REFERENCES changes_pending_files(id);
3945 -- Name: changes_pending_source_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3948 ALTER TABLE ONLY changes_pending_source
3949 ADD CONSTRAINT changes_pending_source_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3953 -- Name: changes_pending_source_changedby_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3956 ALTER TABLE ONLY changes_pending_source
3957 ADD CONSTRAINT changes_pending_source_changedby_id_fkey FOREIGN KEY (changedby_id) REFERENCES maintainer(id);
3961 -- Name: changes_pending_source_files_pending_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3964 ALTER TABLE ONLY changes_pending_source_files
3965 ADD CONSTRAINT changes_pending_source_files_pending_file_id_fkey FOREIGN KEY (pending_file_id) REFERENCES changes_pending_files(id);
3969 -- Name: changes_pending_source_files_pending_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3972 ALTER TABLE ONLY changes_pending_source_files
3973 ADD CONSTRAINT changes_pending_source_files_pending_source_id_fkey FOREIGN KEY (pending_source_id) REFERENCES changes_pending_source(id);
3977 -- Name: changes_pending_source_maintainer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3980 ALTER TABLE ONLY changes_pending_source
3981 ADD CONSTRAINT changes_pending_source_maintainer_id_fkey FOREIGN KEY (maintainer_id) REFERENCES maintainer(id);
3985 -- Name: changes_pending_source_sig_fpr_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3988 ALTER TABLE ONLY changes_pending_source
3989 ADD CONSTRAINT changes_pending_source_sig_fpr_fkey FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id);
3993 -- Name: changes_pool_files_changeid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3996 ALTER TABLE ONLY changes_pool_files
3997 ADD CONSTRAINT changes_pool_files_changeid_fkey FOREIGN KEY (changeid) REFERENCES changes(id) ON DELETE CASCADE;
4001 -- Name: changes_pool_files_fileid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4004 ALTER TABLE ONLY changes_pool_files
4005 ADD CONSTRAINT changes_pool_files_fileid_fkey FOREIGN KEY (fileid) REFERENCES files(id) ON DELETE RESTRICT;
4009 -- Name: dsc_files_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
4012 ALTER TABLE ONLY dsc_files
4013 ADD CONSTRAINT dsc_files_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
4017 -- Name: dsc_files_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4020 ALTER TABLE ONLY dsc_files
4021 ADD CONSTRAINT dsc_files_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
4025 -- Name: external_overrides_component_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4028 ALTER TABLE ONLY external_overrides
4029 ADD CONSTRAINT external_overrides_component_fkey FOREIGN KEY (component) REFERENCES component(id);
4033 -- Name: external_overrides_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4036 ALTER TABLE ONLY external_overrides
4037 ADD CONSTRAINT external_overrides_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4041 -- Name: extra_src_references_bin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4044 ALTER TABLE ONLY extra_src_references
4045 ADD CONSTRAINT extra_src_references_bin_id_fkey FOREIGN KEY (bin_id) REFERENCES binaries(id) ON DELETE CASCADE;
4049 -- Name: extra_src_references_src_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4052 ALTER TABLE ONLY extra_src_references
4053 ADD CONSTRAINT extra_src_references_src_id_fkey FOREIGN KEY (src_id) REFERENCES source(id) ON DELETE RESTRICT;
4057 -- Name: files_location; Type: FK CONSTRAINT; Schema: public; Owner: dak
4060 ALTER TABLE ONLY files
4061 ADD CONSTRAINT files_location FOREIGN KEY (location) REFERENCES location(id) MATCH FULL;
4065 -- Name: fingerprint_binary_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4068 ALTER TABLE ONLY fingerprint
4069 ADD CONSTRAINT fingerprint_binary_acl_id_fkey FOREIGN KEY (binary_acl_id) REFERENCES binary_acl(id);
4073 -- Name: fingerprint_source_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4076 ALTER TABLE ONLY fingerprint
4077 ADD CONSTRAINT fingerprint_source_acl_id_fkey FOREIGN KEY (source_acl_id) REFERENCES source_acl(id);
4081 -- Name: fingerprint_uid; Type: FK CONSTRAINT; Schema: public; Owner: dak
4084 ALTER TABLE ONLY fingerprint
4085 ADD CONSTRAINT fingerprint_uid FOREIGN KEY (uid) REFERENCES uid(id) MATCH FULL;
4089 -- Name: keyring_acl_map_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4092 ALTER TABLE ONLY keyring_acl_map
4093 ADD CONSTRAINT keyring_acl_map_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
4097 -- Name: keyring_acl_map_keyring_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4100 ALTER TABLE ONLY keyring_acl_map
4101 ADD CONSTRAINT keyring_acl_map_keyring_id_fkey FOREIGN KEY (keyring_id) REFERENCES keyrings(id);
4105 -- Name: keyrings_default_binary_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4108 ALTER TABLE ONLY keyrings
4109 ADD CONSTRAINT keyrings_default_binary_acl_id_fkey FOREIGN KEY (default_binary_acl_id) REFERENCES binary_acl(id);
4113 -- Name: keyrings_default_source_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4116 ALTER TABLE ONLY keyrings
4117 ADD CONSTRAINT keyrings_default_source_acl_id_fkey FOREIGN KEY (default_source_acl_id) REFERENCES source_acl(id);
4121 -- Name: known_changes_approved_for_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4124 ALTER TABLE ONLY changes
4125 ADD CONSTRAINT known_changes_approved_for_fkey FOREIGN KEY (in_queue) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4129 -- Name: known_changes_in_queue_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4132 ALTER TABLE ONLY changes
4133 ADD CONSTRAINT known_changes_in_queue_fkey FOREIGN KEY (in_queue) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4137 -- Name: location_archive_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4140 ALTER TABLE ONLY location
4141 ADD CONSTRAINT location_archive_fkey FOREIGN KEY (archive) REFERENCES archive(id);
4145 -- Name: location_component_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4148 ALTER TABLE ONLY location
4149 ADD CONSTRAINT location_component_fkey FOREIGN KEY (component) REFERENCES component(id);
4153 -- Name: override_component; Type: FK CONSTRAINT; Schema: public; Owner: dak
4156 ALTER TABLE ONLY override
4157 ADD CONSTRAINT override_component FOREIGN KEY (component) REFERENCES component(id) MATCH FULL;
4161 -- Name: override_priority; Type: FK CONSTRAINT; Schema: public; Owner: dak
4164 ALTER TABLE ONLY override
4165 ADD CONSTRAINT override_priority FOREIGN KEY (priority) REFERENCES priority(id) MATCH FULL;
4169 -- Name: override_section; Type: FK CONSTRAINT; Schema: public; Owner: dak
4172 ALTER TABLE ONLY override
4173 ADD CONSTRAINT override_section FOREIGN KEY (section) REFERENCES section(id) MATCH FULL;
4177 -- Name: override_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4180 ALTER TABLE ONLY override
4181 ADD CONSTRAINT override_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4185 -- Name: override_type; Type: FK CONSTRAINT; Schema: public; Owner: dak
4188 ALTER TABLE ONLY override
4189 ADD CONSTRAINT override_type FOREIGN KEY (type) REFERENCES override_type(id) MATCH FULL;
4193 -- Name: queue_files_fileid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4196 ALTER TABLE ONLY build_queue_files
4197 ADD CONSTRAINT queue_files_fileid_fkey FOREIGN KEY (fileid) REFERENCES files(id) ON DELETE CASCADE;
4201 -- Name: source_changedby; Type: FK CONSTRAINT; Schema: public; Owner: dak
4204 ALTER TABLE ONLY source
4205 ADD CONSTRAINT source_changedby FOREIGN KEY (changedby) REFERENCES maintainer(id) MATCH FULL;
4209 -- Name: source_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
4212 ALTER TABLE ONLY source
4213 ADD CONSTRAINT source_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
4217 -- Name: source_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
4220 ALTER TABLE ONLY source
4221 ADD CONSTRAINT source_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
4225 -- Name: source_metadata_key_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4228 ALTER TABLE ONLY source_metadata
4229 ADD CONSTRAINT source_metadata_key_id_fkey FOREIGN KEY (key_id) REFERENCES metadata_keys(key_id);
4233 -- Name: source_metadata_src_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4236 ALTER TABLE ONLY source_metadata
4237 ADD CONSTRAINT source_metadata_src_id_fkey FOREIGN KEY (src_id) REFERENCES source(id) ON DELETE CASCADE;
4241 -- Name: source_sig_fpr; Type: FK CONSTRAINT; Schema: public; Owner: dak
4244 ALTER TABLE ONLY source
4245 ADD CONSTRAINT source_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
4249 -- Name: src_associations_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4252 ALTER TABLE ONLY src_associations
4253 ADD CONSTRAINT src_associations_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
4257 -- Name: src_associations_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4260 ALTER TABLE ONLY src_associations
4261 ADD CONSTRAINT src_associations_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4265 -- Name: src_contents_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4268 ALTER TABLE ONLY src_contents
4269 ADD CONSTRAINT src_contents_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(id) ON DELETE CASCADE;
4273 -- Name: src_format_key; Type: FK CONSTRAINT; Schema: public; Owner: dak
4276 ALTER TABLE ONLY suite_src_formats
4277 ADD CONSTRAINT src_format_key FOREIGN KEY (src_format) REFERENCES src_format(id);
4281 -- Name: src_uploaders_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
4284 ALTER TABLE ONLY src_uploaders
4285 ADD CONSTRAINT src_uploaders_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) ON DELETE CASCADE;
4289 -- Name: src_uploaders_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4292 ALTER TABLE ONLY src_uploaders
4293 ADD CONSTRAINT src_uploaders_source FOREIGN KEY (source) REFERENCES source(id) ON DELETE CASCADE;
4297 -- Name: suite_architectures_architectur; Type: FK CONSTRAINT; Schema: public; Owner: dak
4300 ALTER TABLE ONLY suite_architectures
4301 ADD CONSTRAINT suite_architectures_architectur FOREIGN KEY (architecture) REFERENCES architecture(id) MATCH FULL;
4305 -- Name: suite_architectures_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4308 ALTER TABLE ONLY suite_architectures
4309 ADD CONSTRAINT suite_architectures_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4313 -- Name: suite_build_queue_copy_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4316 ALTER TABLE ONLY suite_build_queue_copy
4317 ADD CONSTRAINT suite_build_queue_copy_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE RESTRICT;
4321 -- Name: suite_key; Type: FK CONSTRAINT; Schema: public; Owner: dak
4324 ALTER TABLE ONLY suite_src_formats
4325 ADD CONSTRAINT suite_key FOREIGN KEY (suite) REFERENCES suite(id);
4329 -- Name: suite_policy_queue_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4332 ALTER TABLE ONLY suite
4333 ADD CONSTRAINT suite_policy_queue_fkey FOREIGN KEY (policy_queue_id) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4337 -- Name: suite_queue_copy_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4340 ALTER TABLE ONLY suite_build_queue_copy
4341 ADD CONSTRAINT suite_queue_copy_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4345 -- Name: upload_blocks_fingerprint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4348 ALTER TABLE ONLY upload_blocks
4349 ADD CONSTRAINT upload_blocks_fingerprint_id_fkey FOREIGN KEY (fingerprint_id) REFERENCES fingerprint(id);
4353 -- Name: upload_blocks_uid_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4356 ALTER TABLE ONLY upload_blocks
4357 ADD CONSTRAINT upload_blocks_uid_id_fkey FOREIGN KEY (uid_id) REFERENCES uid(id);
4361 -- Name: version_check_reference_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4364 ALTER TABLE ONLY version_check
4365 ADD CONSTRAINT version_check_reference_fkey FOREIGN KEY (reference) REFERENCES suite(id);
4369 -- Name: version_check_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4372 ALTER TABLE ONLY version_check
4373 ADD CONSTRAINT version_check_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4377 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4380 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4381 REVOKE ALL ON SCHEMA public FROM postgres;
4382 GRANT ALL ON SCHEMA public TO postgres;
4383 GRANT ALL ON SCHEMA public TO PUBLIC;
4387 -- Name: bin_associations_id_seq; Type: ACL; Schema: public; Owner: dak
4390 REVOKE ALL ON SEQUENCE bin_associations_id_seq FROM PUBLIC;
4391 REVOKE ALL ON SEQUENCE bin_associations_id_seq FROM dak;
4392 GRANT ALL ON SEQUENCE bin_associations_id_seq TO dak;
4393 GRANT SELECT ON SEQUENCE bin_associations_id_seq TO PUBLIC;
4394 GRANT ALL ON SEQUENCE bin_associations_id_seq TO ftpmaster;
4398 -- Name: bin_associations; Type: ACL; Schema: public; Owner: dak
4401 REVOKE ALL ON TABLE bin_associations FROM PUBLIC;
4402 REVOKE ALL ON TABLE bin_associations FROM dak;
4403 GRANT ALL ON TABLE bin_associations TO dak;
4404 GRANT SELECT ON TABLE bin_associations TO PUBLIC;
4405 GRANT ALL ON TABLE bin_associations TO ftpmaster;
4406 GRANT DELETE ON TABLE bin_associations TO ftpteam;
4410 -- Name: binaries_id_seq; Type: ACL; Schema: public; Owner: dak
4413 REVOKE ALL ON SEQUENCE binaries_id_seq FROM PUBLIC;
4414 REVOKE ALL ON SEQUENCE binaries_id_seq FROM dak;
4415 GRANT ALL ON SEQUENCE binaries_id_seq TO dak;
4416 GRANT SELECT ON SEQUENCE binaries_id_seq TO PUBLIC;
4417 GRANT ALL ON SEQUENCE binaries_id_seq TO ftpmaster;
4421 -- Name: binaries; Type: ACL; Schema: public; Owner: dak
4424 REVOKE ALL ON TABLE binaries FROM PUBLIC;
4425 REVOKE ALL ON TABLE binaries FROM dak;
4426 GRANT ALL ON TABLE binaries TO dak;
4427 GRANT SELECT ON TABLE binaries TO PUBLIC;
4428 GRANT ALL ON TABLE binaries TO ftpmaster;
4432 -- Name: bin_associations_binaries; Type: ACL; Schema: public; Owner: dak
4435 REVOKE ALL ON TABLE bin_associations_binaries FROM PUBLIC;
4436 REVOKE ALL ON TABLE bin_associations_binaries FROM dak;
4437 GRANT ALL ON TABLE bin_associations_binaries TO dak;
4438 GRANT SELECT ON TABLE bin_associations_binaries TO ftpmaster;
4439 GRANT SELECT ON TABLE bin_associations_binaries TO PUBLIC;
4443 -- Name: source_id_seq; Type: ACL; Schema: public; Owner: dak
4446 REVOKE ALL ON SEQUENCE source_id_seq FROM PUBLIC;
4447 REVOKE ALL ON SEQUENCE source_id_seq FROM dak;
4448 GRANT ALL ON SEQUENCE source_id_seq TO dak;
4449 GRANT SELECT ON SEQUENCE source_id_seq TO PUBLIC;
4450 GRANT ALL ON SEQUENCE source_id_seq TO ftpmaster;
4454 -- Name: source; Type: ACL; Schema: public; Owner: dak
4457 REVOKE ALL ON TABLE source FROM PUBLIC;
4458 REVOKE ALL ON TABLE source FROM dak;
4459 GRANT ALL ON TABLE source TO dak;
4460 GRANT SELECT ON TABLE source TO PUBLIC;
4461 GRANT ALL ON TABLE source TO ftpmaster;
4465 -- Name: src_associations_id_seq; Type: ACL; Schema: public; Owner: dak
4468 REVOKE ALL ON SEQUENCE src_associations_id_seq FROM PUBLIC;
4469 REVOKE ALL ON SEQUENCE src_associations_id_seq FROM dak;
4470 GRANT ALL ON SEQUENCE src_associations_id_seq TO dak;
4471 GRANT SELECT ON SEQUENCE src_associations_id_seq TO PUBLIC;
4472 GRANT ALL ON SEQUENCE src_associations_id_seq TO ftpmaster;
4476 -- Name: src_associations; Type: ACL; Schema: public; Owner: dak
4479 REVOKE ALL ON TABLE src_associations FROM PUBLIC;
4480 REVOKE ALL ON TABLE src_associations FROM dak;
4481 GRANT ALL ON TABLE src_associations TO dak;
4482 GRANT SELECT ON TABLE src_associations TO PUBLIC;
4483 GRANT ALL ON TABLE src_associations TO ftpmaster;
4484 GRANT DELETE ON TABLE src_associations TO ftpteam;
4488 -- Name: src_associations_bin; Type: ACL; Schema: public; Owner: dak
4491 REVOKE ALL ON TABLE src_associations_bin FROM PUBLIC;
4492 REVOKE ALL ON TABLE src_associations_bin FROM dak;
4493 GRANT ALL ON TABLE src_associations_bin TO dak;
4494 GRANT SELECT ON TABLE src_associations_bin TO ftpmaster;
4495 GRANT SELECT ON TABLE src_associations_bin TO PUBLIC;
4499 -- Name: almost_obsolete_all_associations; Type: ACL; Schema: public; Owner: dak
4502 REVOKE ALL ON TABLE almost_obsolete_all_associations FROM PUBLIC;
4503 REVOKE ALL ON TABLE almost_obsolete_all_associations FROM dak;
4504 GRANT ALL ON TABLE almost_obsolete_all_associations TO dak;
4505 GRANT SELECT ON TABLE almost_obsolete_all_associations TO ftpmaster;
4506 GRANT SELECT ON TABLE almost_obsolete_all_associations TO PUBLIC;
4510 -- Name: any_associations_source; Type: ACL; Schema: public; Owner: dak
4513 REVOKE ALL ON TABLE any_associations_source FROM PUBLIC;
4514 REVOKE ALL ON TABLE any_associations_source FROM dak;
4515 GRANT ALL ON TABLE any_associations_source TO dak;
4516 GRANT SELECT ON TABLE any_associations_source TO ftpmaster;
4517 GRANT SELECT ON TABLE any_associations_source TO PUBLIC;
4521 -- Name: src_associations_src; Type: ACL; Schema: public; Owner: dak
4524 REVOKE ALL ON TABLE src_associations_src FROM PUBLIC;
4525 REVOKE ALL ON TABLE src_associations_src FROM dak;
4526 GRANT ALL ON TABLE src_associations_src TO dak;
4527 GRANT SELECT ON TABLE src_associations_src TO ftpmaster;
4528 GRANT SELECT ON TABLE src_associations_src TO PUBLIC;
4532 -- Name: almost_obsolete_src_associations; Type: ACL; Schema: public; Owner: dak
4535 REVOKE ALL ON TABLE almost_obsolete_src_associations FROM PUBLIC;
4536 REVOKE ALL ON TABLE almost_obsolete_src_associations FROM dak;
4537 GRANT ALL ON TABLE almost_obsolete_src_associations TO dak;
4538 GRANT SELECT ON TABLE almost_obsolete_src_associations TO ftpmaster;
4539 GRANT SELECT ON TABLE almost_obsolete_src_associations TO PUBLIC;
4543 -- Name: architecture_id_seq; Type: ACL; Schema: public; Owner: dak
4546 REVOKE ALL ON SEQUENCE architecture_id_seq FROM PUBLIC;
4547 REVOKE ALL ON SEQUENCE architecture_id_seq FROM dak;
4548 GRANT ALL ON SEQUENCE architecture_id_seq TO dak;
4549 GRANT SELECT ON SEQUENCE architecture_id_seq TO PUBLIC;
4550 GRANT ALL ON SEQUENCE architecture_id_seq TO ftpmaster;
4554 -- Name: architecture; Type: ACL; Schema: public; Owner: dak
4557 REVOKE ALL ON TABLE architecture FROM PUBLIC;
4558 REVOKE ALL ON TABLE architecture FROM dak;
4559 GRANT ALL ON TABLE architecture TO dak;
4560 GRANT SELECT ON TABLE architecture TO PUBLIC;
4561 GRANT ALL ON TABLE architecture TO ftpmaster;
4565 -- Name: archive_id_seq; Type: ACL; Schema: public; Owner: dak
4568 REVOKE ALL ON SEQUENCE archive_id_seq FROM PUBLIC;
4569 REVOKE ALL ON SEQUENCE archive_id_seq FROM dak;
4570 GRANT ALL ON SEQUENCE archive_id_seq TO dak;
4571 GRANT SELECT ON SEQUENCE archive_id_seq TO PUBLIC;
4572 GRANT ALL ON SEQUENCE archive_id_seq TO ftpmaster;
4576 -- Name: archive; Type: ACL; Schema: public; Owner: dak
4579 REVOKE ALL ON TABLE archive FROM PUBLIC;
4580 REVOKE ALL ON TABLE archive FROM dak;
4581 GRANT ALL ON TABLE archive TO dak;
4582 GRANT SELECT ON TABLE archive TO PUBLIC;
4583 GRANT ALL ON TABLE archive TO ftpmaster;
4587 -- Name: bin_contents; Type: ACL; Schema: public; Owner: dak
4590 REVOKE ALL ON TABLE bin_contents FROM PUBLIC;
4591 REVOKE ALL ON TABLE bin_contents FROM dak;
4592 GRANT ALL ON TABLE bin_contents TO dak;
4593 GRANT SELECT ON TABLE bin_contents TO PUBLIC;
4594 GRANT ALL ON TABLE bin_contents TO ftpmaster;
4598 -- Name: binaries_metadata; Type: ACL; Schema: public; Owner: dak
4601 REVOKE ALL ON TABLE binaries_metadata FROM PUBLIC;
4602 REVOKE ALL ON TABLE binaries_metadata FROM dak;
4603 GRANT ALL ON TABLE binaries_metadata TO dak;
4604 GRANT SELECT,INSERT,UPDATE ON TABLE binaries_metadata TO ftpmaster;
4605 GRANT SELECT ON TABLE binaries_metadata TO PUBLIC;
4609 -- Name: suite_id_seq; Type: ACL; Schema: public; Owner: dak
4612 REVOKE ALL ON SEQUENCE suite_id_seq FROM PUBLIC;
4613 REVOKE ALL ON SEQUENCE suite_id_seq FROM dak;
4614 GRANT ALL ON SEQUENCE suite_id_seq TO dak;
4615 GRANT SELECT ON SEQUENCE suite_id_seq TO PUBLIC;
4616 GRANT ALL ON SEQUENCE suite_id_seq TO ftpmaster;
4620 -- Name: suite; Type: ACL; Schema: public; Owner: dak
4623 REVOKE ALL ON TABLE suite FROM PUBLIC;
4624 REVOKE ALL ON TABLE suite FROM dak;
4625 GRANT ALL ON TABLE suite TO dak;
4626 GRANT SELECT ON TABLE suite TO PUBLIC;
4627 GRANT ALL ON TABLE suite TO ftpmaster;
4631 -- Name: binaries_suite_arch; Type: ACL; Schema: public; Owner: dak
4634 REVOKE ALL ON TABLE binaries_suite_arch FROM PUBLIC;
4635 REVOKE ALL ON TABLE binaries_suite_arch FROM dak;
4636 GRANT ALL ON TABLE binaries_suite_arch TO dak;
4637 GRANT SELECT ON TABLE binaries_suite_arch TO ftpmaster;
4638 GRANT SELECT ON TABLE binaries_suite_arch TO PUBLIC;
4642 -- Name: binary_acl; Type: ACL; Schema: public; Owner: dak
4645 REVOKE ALL ON TABLE binary_acl FROM PUBLIC;
4646 REVOKE ALL ON TABLE binary_acl FROM dak;
4647 GRANT ALL ON TABLE binary_acl TO dak;
4648 GRANT SELECT ON TABLE binary_acl TO PUBLIC;
4649 GRANT ALL ON TABLE binary_acl TO ftpmaster;
4653 -- Name: binary_acl_id_seq; Type: ACL; Schema: public; Owner: dak
4656 REVOKE ALL ON SEQUENCE binary_acl_id_seq FROM PUBLIC;
4657 REVOKE ALL ON SEQUENCE binary_acl_id_seq FROM dak;
4658 GRANT ALL ON SEQUENCE binary_acl_id_seq TO dak;
4659 GRANT ALL ON SEQUENCE binary_acl_id_seq TO ftpmaster;
4660 GRANT SELECT ON SEQUENCE binary_acl_id_seq TO PUBLIC;
4664 -- Name: binary_acl_map; Type: ACL; Schema: public; Owner: dak
4667 REVOKE ALL ON TABLE binary_acl_map FROM PUBLIC;
4668 REVOKE ALL ON TABLE binary_acl_map FROM dak;
4669 GRANT ALL ON TABLE binary_acl_map TO dak;
4670 GRANT SELECT ON TABLE binary_acl_map TO PUBLIC;
4671 GRANT ALL ON TABLE binary_acl_map TO ftpmaster;
4675 -- Name: binary_acl_map_id_seq; Type: ACL; Schema: public; Owner: dak
4678 REVOKE ALL ON SEQUENCE binary_acl_map_id_seq FROM PUBLIC;
4679 REVOKE ALL ON SEQUENCE binary_acl_map_id_seq FROM dak;
4680 GRANT ALL ON SEQUENCE binary_acl_map_id_seq TO dak;
4681 GRANT ALL ON SEQUENCE binary_acl_map_id_seq TO ftpmaster;
4682 GRANT SELECT ON SEQUENCE binary_acl_map_id_seq TO PUBLIC;
4686 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: dak
4689 REVOKE ALL ON SEQUENCE files_id_seq FROM PUBLIC;
4690 REVOKE ALL ON SEQUENCE files_id_seq FROM dak;
4691 GRANT ALL ON SEQUENCE files_id_seq TO dak;
4692 GRANT SELECT ON SEQUENCE files_id_seq TO PUBLIC;
4693 GRANT ALL ON SEQUENCE files_id_seq TO ftpmaster;
4697 -- Name: files; Type: ACL; Schema: public; Owner: dak
4700 REVOKE ALL ON TABLE files FROM PUBLIC;
4701 REVOKE ALL ON TABLE files FROM dak;
4702 GRANT ALL ON TABLE files TO dak;
4703 GRANT SELECT ON TABLE files TO PUBLIC;
4704 GRANT ALL ON TABLE files TO ftpmaster;
4708 -- Name: location_id_seq; Type: ACL; Schema: public; Owner: dak
4711 REVOKE ALL ON SEQUENCE location_id_seq FROM PUBLIC;
4712 REVOKE ALL ON SEQUENCE location_id_seq FROM dak;
4713 GRANT ALL ON SEQUENCE location_id_seq TO dak;
4714 GRANT SELECT ON SEQUENCE location_id_seq TO PUBLIC;
4715 GRANT ALL ON SEQUENCE location_id_seq TO ftpmaster;
4719 -- Name: location; Type: ACL; Schema: public; Owner: dak
4722 REVOKE ALL ON TABLE location FROM PUBLIC;
4723 REVOKE ALL ON TABLE location FROM dak;
4724 GRANT ALL ON TABLE location TO dak;
4725 GRANT SELECT ON TABLE location TO PUBLIC;
4726 GRANT ALL ON TABLE location TO ftpmaster;
4730 -- Name: binfiles_suite_component_arch; Type: ACL; Schema: public; Owner: dak
4733 REVOKE ALL ON TABLE binfiles_suite_component_arch FROM PUBLIC;
4734 REVOKE ALL ON TABLE binfiles_suite_component_arch FROM dak;
4735 GRANT ALL ON TABLE binfiles_suite_component_arch TO dak;
4736 GRANT SELECT ON TABLE binfiles_suite_component_arch TO ftpmaster;
4737 GRANT SELECT ON TABLE binfiles_suite_component_arch TO PUBLIC;
4741 -- Name: build_queue; Type: ACL; Schema: public; Owner: dak
4744 REVOKE ALL ON TABLE build_queue FROM PUBLIC;
4745 REVOKE ALL ON TABLE build_queue FROM dak;
4746 GRANT ALL ON TABLE build_queue TO dak;
4747 GRANT SELECT ON TABLE build_queue TO PUBLIC;
4748 GRANT ALL ON TABLE build_queue TO ftpmaster;
4752 -- Name: build_queue_files; Type: ACL; Schema: public; Owner: dak
4755 REVOKE ALL ON TABLE build_queue_files FROM PUBLIC;
4756 REVOKE ALL ON TABLE build_queue_files FROM dak;
4757 GRANT ALL ON TABLE build_queue_files TO dak;
4758 GRANT SELECT ON TABLE build_queue_files TO PUBLIC;
4759 GRANT ALL ON TABLE build_queue_files TO ftpmaster;
4763 -- Name: build_queue_files_id_seq; Type: ACL; Schema: public; Owner: dak
4766 REVOKE ALL ON SEQUENCE build_queue_files_id_seq FROM PUBLIC;
4767 REVOKE ALL ON SEQUENCE build_queue_files_id_seq FROM dak;
4768 GRANT ALL ON SEQUENCE build_queue_files_id_seq TO dak;
4769 GRANT ALL ON SEQUENCE build_queue_files_id_seq TO ftpmaster;
4770 GRANT SELECT ON SEQUENCE build_queue_files_id_seq TO PUBLIC;
4774 -- Name: build_queue_id_seq; Type: ACL; Schema: public; Owner: dak
4777 REVOKE ALL ON SEQUENCE build_queue_id_seq FROM PUBLIC;
4778 REVOKE ALL ON SEQUENCE build_queue_id_seq FROM dak;
4779 GRANT ALL ON SEQUENCE build_queue_id_seq TO dak;
4780 GRANT ALL ON SEQUENCE build_queue_id_seq TO ftpmaster;
4781 GRANT SELECT ON SEQUENCE build_queue_id_seq TO PUBLIC;
4785 -- Name: build_queue_policy_files; Type: ACL; Schema: public; Owner: dak
4788 REVOKE ALL ON TABLE build_queue_policy_files FROM PUBLIC;
4789 REVOKE ALL ON TABLE build_queue_policy_files FROM dak;
4790 GRANT ALL ON TABLE build_queue_policy_files TO dak;
4791 GRANT SELECT,INSERT,UPDATE ON TABLE build_queue_policy_files TO ftpmaster;
4792 GRANT SELECT ON TABLE build_queue_policy_files TO PUBLIC;
4796 -- Name: changelogs_text; Type: ACL; Schema: public; Owner: dak
4799 REVOKE ALL ON TABLE changelogs_text FROM PUBLIC;
4800 REVOKE ALL ON TABLE changelogs_text FROM dak;
4801 GRANT ALL ON TABLE changelogs_text TO dak;
4802 GRANT SELECT ON TABLE changelogs_text TO PUBLIC;
4803 GRANT ALL ON TABLE changelogs_text TO ftpmaster;
4807 -- Name: changes; Type: ACL; Schema: public; Owner: dak
4810 REVOKE ALL ON TABLE changes FROM PUBLIC;
4811 REVOKE ALL ON TABLE changes FROM dak;
4812 GRANT ALL ON TABLE changes TO dak;
4813 GRANT ALL ON TABLE changes TO ftpmaster;
4814 GRANT SELECT ON TABLE changes TO PUBLIC;
4815 GRANT DELETE,UPDATE ON TABLE changes TO ftpteam;
4819 -- Name: changelogs; Type: ACL; Schema: public; Owner: dak
4822 REVOKE ALL ON TABLE changelogs FROM PUBLIC;
4823 REVOKE ALL ON TABLE changelogs FROM dak;
4824 GRANT ALL ON TABLE changelogs TO dak;
4825 GRANT SELECT ON TABLE changelogs TO PUBLIC;
4826 GRANT ALL ON TABLE changelogs TO ftpmaster;
4830 -- Name: changelogs_text_id_seq; Type: ACL; Schema: public; Owner: dak
4833 REVOKE ALL ON SEQUENCE changelogs_text_id_seq FROM PUBLIC;
4834 REVOKE ALL ON SEQUENCE changelogs_text_id_seq FROM dak;
4835 GRANT ALL ON SEQUENCE changelogs_text_id_seq TO dak;
4836 GRANT ALL ON SEQUENCE changelogs_text_id_seq TO ftpmaster;
4837 GRANT SELECT ON SEQUENCE changelogs_text_id_seq TO PUBLIC;
4841 -- Name: changes_id_seq; Type: ACL; Schema: public; Owner: dak
4844 REVOKE ALL ON SEQUENCE changes_id_seq FROM PUBLIC;
4845 REVOKE ALL ON SEQUENCE changes_id_seq FROM dak;
4846 GRANT ALL ON SEQUENCE changes_id_seq TO dak;
4847 GRANT ALL ON SEQUENCE changes_id_seq TO ftpmaster;
4848 GRANT SELECT ON SEQUENCE changes_id_seq TO PUBLIC;
4852 -- Name: changes_pending_binaries; Type: ACL; Schema: public; Owner: dak
4855 REVOKE ALL ON TABLE changes_pending_binaries FROM PUBLIC;
4856 REVOKE ALL ON TABLE changes_pending_binaries FROM dak;
4857 GRANT ALL ON TABLE changes_pending_binaries TO dak;
4858 GRANT SELECT ON TABLE changes_pending_binaries TO PUBLIC;
4859 GRANT ALL ON TABLE changes_pending_binaries TO ftpmaster;
4863 -- Name: changes_pending_binaries_id_seq; Type: ACL; Schema: public; Owner: dak
4866 REVOKE ALL ON SEQUENCE changes_pending_binaries_id_seq FROM PUBLIC;
4867 REVOKE ALL ON SEQUENCE changes_pending_binaries_id_seq FROM dak;
4868 GRANT ALL ON SEQUENCE changes_pending_binaries_id_seq TO dak;
4869 GRANT ALL ON SEQUENCE changes_pending_binaries_id_seq TO ftpmaster;
4870 GRANT SELECT ON SEQUENCE changes_pending_binaries_id_seq TO PUBLIC;
4874 -- Name: changes_pending_files; Type: ACL; Schema: public; Owner: dak
4877 REVOKE ALL ON TABLE changes_pending_files FROM PUBLIC;
4878 REVOKE ALL ON TABLE changes_pending_files FROM dak;
4879 GRANT ALL ON TABLE changes_pending_files TO dak;
4880 GRANT SELECT ON TABLE changes_pending_files TO PUBLIC;
4881 GRANT ALL ON TABLE changes_pending_files TO ftpmaster;
4882 GRANT DELETE ON TABLE changes_pending_files TO ftpteam;
4886 -- Name: changes_pending_files_id_seq; Type: ACL; Schema: public; Owner: dak
4889 REVOKE ALL ON SEQUENCE changes_pending_files_id_seq FROM PUBLIC;
4890 REVOKE ALL ON SEQUENCE changes_pending_files_id_seq FROM dak;
4891 GRANT ALL ON SEQUENCE changes_pending_files_id_seq TO dak;
4892 GRANT ALL ON SEQUENCE changes_pending_files_id_seq TO ftpmaster;
4893 GRANT SELECT ON SEQUENCE changes_pending_files_id_seq TO PUBLIC;
4894 GRANT USAGE ON SEQUENCE changes_pending_files_id_seq TO ftpteam;
4898 -- Name: changes_pending_files_map; Type: ACL; Schema: public; Owner: dak
4901 REVOKE ALL ON TABLE changes_pending_files_map FROM PUBLIC;
4902 REVOKE ALL ON TABLE changes_pending_files_map FROM dak;
4903 GRANT ALL ON TABLE changes_pending_files_map TO dak;
4904 GRANT SELECT,INSERT,DELETE ON TABLE changes_pending_files_map TO ftpteam;
4905 GRANT SELECT ON TABLE changes_pending_files_map TO PUBLIC;
4909 -- Name: changes_pending_source; Type: ACL; Schema: public; Owner: dak
4912 REVOKE ALL ON TABLE changes_pending_source FROM PUBLIC;
4913 REVOKE ALL ON TABLE changes_pending_source FROM dak;
4914 GRANT ALL ON TABLE changes_pending_source TO dak;
4915 GRANT SELECT ON TABLE changes_pending_source TO PUBLIC;
4916 GRANT ALL ON TABLE changes_pending_source TO ftpmaster;
4920 -- Name: changes_pending_source_files; Type: ACL; Schema: public; Owner: dak
4923 REVOKE ALL ON TABLE changes_pending_source_files FROM PUBLIC;
4924 REVOKE ALL ON TABLE changes_pending_source_files FROM dak;
4925 GRANT ALL ON TABLE changes_pending_source_files TO dak;
4926 GRANT SELECT ON TABLE changes_pending_source_files TO PUBLIC;
4927 GRANT ALL ON TABLE changes_pending_source_files TO ftpmaster;
4931 -- Name: changes_pending_source_id_seq; Type: ACL; Schema: public; Owner: dak
4934 REVOKE ALL ON SEQUENCE changes_pending_source_id_seq FROM PUBLIC;
4935 REVOKE ALL ON SEQUENCE changes_pending_source_id_seq FROM dak;
4936 GRANT ALL ON SEQUENCE changes_pending_source_id_seq TO dak;
4937 GRANT ALL ON SEQUENCE changes_pending_source_id_seq TO ftpmaster;
4938 GRANT SELECT ON SEQUENCE changes_pending_source_id_seq TO PUBLIC;
4942 -- Name: changes_pool_files; Type: ACL; Schema: public; Owner: dak
4945 REVOKE ALL ON TABLE changes_pool_files FROM PUBLIC;
4946 REVOKE ALL ON TABLE changes_pool_files FROM dak;
4947 GRANT ALL ON TABLE changes_pool_files TO dak;
4948 GRANT SELECT ON TABLE changes_pool_files TO PUBLIC;
4949 GRANT ALL ON TABLE changes_pool_files TO ftpmaster;
4950 GRANT INSERT ON TABLE changes_pool_files TO ftpteam;
4954 -- Name: component_id_seq; Type: ACL; Schema: public; Owner: dak
4957 REVOKE ALL ON SEQUENCE component_id_seq FROM PUBLIC;
4958 REVOKE ALL ON SEQUENCE component_id_seq FROM dak;
4959 GRANT ALL ON SEQUENCE component_id_seq TO dak;
4960 GRANT SELECT ON SEQUENCE component_id_seq TO PUBLIC;
4961 GRANT ALL ON SEQUENCE component_id_seq TO ftpmaster;
4965 -- Name: component; Type: ACL; Schema: public; Owner: dak
4968 REVOKE ALL ON TABLE component FROM PUBLIC;
4969 REVOKE ALL ON TABLE component FROM dak;
4970 GRANT ALL ON TABLE component TO dak;
4971 GRANT SELECT ON TABLE component TO PUBLIC;
4972 GRANT ALL ON TABLE component TO ftpmaster;
4976 -- Name: config; Type: ACL; Schema: public; Owner: dak
4979 REVOKE ALL ON TABLE config FROM PUBLIC;
4980 REVOKE ALL ON TABLE config FROM dak;
4981 GRANT ALL ON TABLE config TO dak;
4982 GRANT ALL ON TABLE config TO ftpmaster;
4983 GRANT SELECT ON TABLE config TO ftpteam;
4984 GRANT SELECT ON TABLE config TO PUBLIC;
4988 -- Name: config_id_seq; Type: ACL; Schema: public; Owner: dak
4991 REVOKE ALL ON SEQUENCE config_id_seq FROM PUBLIC;
4992 REVOKE ALL ON SEQUENCE config_id_seq FROM dak;
4993 GRANT ALL ON SEQUENCE config_id_seq TO dak;
4994 GRANT ALL ON SEQUENCE config_id_seq TO ftpmaster;
4995 GRANT SELECT ON SEQUENCE config_id_seq TO PUBLIC;
4999 -- Name: dsc_files_id_seq; Type: ACL; Schema: public; Owner: dak
5002 REVOKE ALL ON SEQUENCE dsc_files_id_seq FROM PUBLIC;
5003 REVOKE ALL ON SEQUENCE dsc_files_id_seq FROM dak;
5004 GRANT ALL ON SEQUENCE dsc_files_id_seq TO dak;
5005 GRANT SELECT ON SEQUENCE dsc_files_id_seq TO PUBLIC;
5006 GRANT ALL ON SEQUENCE dsc_files_id_seq TO ftpmaster;
5010 -- Name: dsc_files; Type: ACL; Schema: public; Owner: dak
5013 REVOKE ALL ON TABLE dsc_files FROM PUBLIC;
5014 REVOKE ALL ON TABLE dsc_files FROM dak;
5015 GRANT ALL ON TABLE dsc_files TO dak;
5016 GRANT SELECT ON TABLE dsc_files TO PUBLIC;
5017 GRANT ALL ON TABLE dsc_files TO ftpmaster;
5021 -- Name: external_overrides; Type: ACL; Schema: public; Owner: dak
5024 REVOKE ALL ON TABLE external_overrides FROM PUBLIC;
5025 REVOKE ALL ON TABLE external_overrides FROM dak;
5026 GRANT ALL ON TABLE external_overrides TO dak;
5027 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE external_overrides TO ftpmaster;
5028 GRANT SELECT ON TABLE external_overrides TO PUBLIC;
5032 -- Name: extra_src_references; Type: ACL; Schema: public; Owner: dak
5035 REVOKE ALL ON TABLE extra_src_references FROM PUBLIC;
5036 REVOKE ALL ON TABLE extra_src_references FROM dak;
5037 GRANT ALL ON TABLE extra_src_references TO dak;
5038 GRANT SELECT,INSERT,UPDATE ON TABLE extra_src_references TO ftpmaster;
5039 GRANT SELECT ON TABLE extra_src_references TO PUBLIC;
5043 -- Name: file_arch_suite; Type: ACL; Schema: public; Owner: dak
5046 REVOKE ALL ON TABLE file_arch_suite FROM PUBLIC;
5047 REVOKE ALL ON TABLE file_arch_suite FROM dak;
5048 GRANT ALL ON TABLE file_arch_suite TO dak;
5049 GRANT ALL ON TABLE file_arch_suite TO ftpmaster;
5050 GRANT SELECT ON TABLE file_arch_suite TO PUBLIC;
5054 -- Name: fingerprint_id_seq; Type: ACL; Schema: public; Owner: dak
5057 REVOKE ALL ON SEQUENCE fingerprint_id_seq FROM PUBLIC;
5058 REVOKE ALL ON SEQUENCE fingerprint_id_seq FROM dak;
5059 GRANT ALL ON SEQUENCE fingerprint_id_seq TO dak;
5060 GRANT SELECT ON SEQUENCE fingerprint_id_seq TO PUBLIC;
5061 GRANT ALL ON SEQUENCE fingerprint_id_seq TO ftpmaster;
5065 -- Name: fingerprint; Type: ACL; Schema: public; Owner: dak
5068 REVOKE ALL ON TABLE fingerprint FROM PUBLIC;
5069 REVOKE ALL ON TABLE fingerprint FROM dak;
5070 GRANT ALL ON TABLE fingerprint TO dak;
5071 GRANT SELECT ON TABLE fingerprint TO PUBLIC;
5072 GRANT ALL ON TABLE fingerprint TO ftpmaster;
5076 -- Name: keyring_acl_map; Type: ACL; Schema: public; Owner: dak
5079 REVOKE ALL ON TABLE keyring_acl_map FROM PUBLIC;
5080 REVOKE ALL ON TABLE keyring_acl_map FROM dak;
5081 GRANT ALL ON TABLE keyring_acl_map TO dak;
5082 GRANT SELECT ON TABLE keyring_acl_map TO PUBLIC;
5083 GRANT ALL ON TABLE keyring_acl_map TO ftpmaster;
5087 -- Name: keyring_acl_map_id_seq; Type: ACL; Schema: public; Owner: dak
5090 REVOKE ALL ON SEQUENCE keyring_acl_map_id_seq FROM PUBLIC;
5091 REVOKE ALL ON SEQUENCE keyring_acl_map_id_seq FROM dak;
5092 GRANT ALL ON SEQUENCE keyring_acl_map_id_seq TO dak;
5093 GRANT ALL ON SEQUENCE keyring_acl_map_id_seq TO ftpmaster;
5094 GRANT SELECT ON SEQUENCE keyring_acl_map_id_seq TO PUBLIC;
5098 -- Name: keyrings; Type: ACL; Schema: public; Owner: dak
5101 REVOKE ALL ON TABLE keyrings FROM PUBLIC;
5102 REVOKE ALL ON TABLE keyrings FROM dak;
5103 GRANT ALL ON TABLE keyrings TO dak;
5104 GRANT SELECT ON TABLE keyrings TO PUBLIC;
5105 GRANT ALL ON TABLE keyrings TO ftpmaster;
5109 -- Name: keyrings_id_seq; Type: ACL; Schema: public; Owner: dak
5112 REVOKE ALL ON SEQUENCE keyrings_id_seq FROM PUBLIC;
5113 REVOKE ALL ON SEQUENCE keyrings_id_seq FROM dak;
5114 GRANT ALL ON SEQUENCE keyrings_id_seq TO dak;
5115 GRANT SELECT ON SEQUENCE keyrings_id_seq TO PUBLIC;
5116 GRANT ALL ON SEQUENCE keyrings_id_seq TO ftpmaster;
5120 -- Name: maintainer_id_seq; Type: ACL; Schema: public; Owner: dak
5123 REVOKE ALL ON SEQUENCE maintainer_id_seq FROM PUBLIC;
5124 REVOKE ALL ON SEQUENCE maintainer_id_seq FROM dak;
5125 GRANT ALL ON SEQUENCE maintainer_id_seq TO dak;
5126 GRANT SELECT ON SEQUENCE maintainer_id_seq TO PUBLIC;
5127 GRANT ALL ON SEQUENCE maintainer_id_seq TO ftpmaster;
5131 -- Name: maintainer; Type: ACL; Schema: public; Owner: dak
5134 REVOKE ALL ON TABLE maintainer FROM PUBLIC;
5135 REVOKE ALL ON TABLE maintainer FROM dak;
5136 GRANT ALL ON TABLE maintainer TO dak;
5137 GRANT SELECT ON TABLE maintainer TO PUBLIC;
5138 GRANT ALL ON TABLE maintainer TO ftpmaster;
5142 -- Name: metadata_keys; Type: ACL; Schema: public; Owner: dak
5145 REVOKE ALL ON TABLE metadata_keys FROM PUBLIC;
5146 REVOKE ALL ON TABLE metadata_keys FROM dak;
5147 GRANT ALL ON TABLE metadata_keys TO dak;
5148 GRANT SELECT,INSERT,UPDATE ON TABLE metadata_keys TO ftpmaster;
5149 GRANT SELECT ON TABLE metadata_keys TO PUBLIC;
5153 -- Name: metadata_keys_key_id_seq; Type: ACL; Schema: public; Owner: dak
5156 REVOKE ALL ON SEQUENCE metadata_keys_key_id_seq FROM PUBLIC;
5157 REVOKE ALL ON SEQUENCE metadata_keys_key_id_seq FROM dak;
5158 GRANT ALL ON SEQUENCE metadata_keys_key_id_seq TO dak;
5159 GRANT ALL ON SEQUENCE metadata_keys_key_id_seq TO ftpmaster;
5160 GRANT SELECT ON SEQUENCE metadata_keys_key_id_seq TO PUBLIC;
5164 -- Name: new_comments; Type: ACL; Schema: public; Owner: dak
5167 REVOKE ALL ON TABLE new_comments FROM PUBLIC;
5168 REVOKE ALL ON TABLE new_comments FROM dak;
5169 GRANT ALL ON TABLE new_comments TO dak;
5170 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE new_comments TO ftptrainee;
5171 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE new_comments TO ftpteam;
5172 GRANT ALL ON TABLE new_comments TO ftpmaster;
5176 -- Name: new_comments_id_seq; Type: ACL; Schema: public; Owner: dak
5179 REVOKE ALL ON SEQUENCE new_comments_id_seq FROM PUBLIC;
5180 REVOKE ALL ON SEQUENCE new_comments_id_seq FROM dak;
5181 GRANT ALL ON SEQUENCE new_comments_id_seq TO dak;
5182 GRANT SELECT,UPDATE ON SEQUENCE new_comments_id_seq TO ftptrainee;
5183 GRANT SELECT,UPDATE ON SEQUENCE new_comments_id_seq TO ftpteam;
5184 GRANT ALL ON SEQUENCE new_comments_id_seq TO ftpmaster;
5185 GRANT SELECT ON SEQUENCE new_comments_id_seq TO PUBLIC;
5189 -- Name: newest_all_associations; Type: ACL; Schema: public; Owner: dak
5192 REVOKE ALL ON TABLE newest_all_associations FROM PUBLIC;
5193 REVOKE ALL ON TABLE newest_all_associations FROM dak;
5194 GRANT ALL ON TABLE newest_all_associations TO dak;
5195 GRANT SELECT ON TABLE newest_all_associations TO ftpmaster;
5196 GRANT SELECT ON TABLE newest_all_associations TO PUBLIC;
5200 -- Name: newest_any_associations; Type: ACL; Schema: public; Owner: dak
5203 REVOKE ALL ON TABLE newest_any_associations FROM PUBLIC;
5204 REVOKE ALL ON TABLE newest_any_associations FROM dak;
5205 GRANT ALL ON TABLE newest_any_associations TO dak;
5206 GRANT SELECT ON TABLE newest_any_associations TO ftpmaster;
5207 GRANT SELECT ON TABLE newest_any_associations TO PUBLIC;
5211 -- Name: source_suite; Type: ACL; Schema: public; Owner: dak
5214 REVOKE ALL ON TABLE source_suite FROM PUBLIC;
5215 REVOKE ALL ON TABLE source_suite FROM dak;
5216 GRANT ALL ON TABLE source_suite TO dak;
5217 GRANT SELECT ON TABLE source_suite TO ftpmaster;
5218 GRANT SELECT ON TABLE source_suite TO PUBLIC;
5222 -- Name: newest_source; Type: ACL; Schema: public; Owner: dak
5225 REVOKE ALL ON TABLE newest_source FROM PUBLIC;
5226 REVOKE ALL ON TABLE newest_source FROM dak;
5227 GRANT ALL ON TABLE newest_source TO dak;
5228 GRANT SELECT ON TABLE newest_source TO ftpmaster;
5229 GRANT SELECT ON TABLE newest_source TO PUBLIC;
5233 -- Name: newest_src_association; Type: ACL; Schema: public; Owner: dak
5236 REVOKE ALL ON TABLE newest_src_association FROM PUBLIC;
5237 REVOKE ALL ON TABLE newest_src_association FROM dak;
5238 GRANT ALL ON TABLE newest_src_association TO dak;
5239 GRANT SELECT ON TABLE newest_src_association TO ftpmaster;
5240 GRANT SELECT ON TABLE newest_src_association TO PUBLIC;
5244 -- Name: obsolete_all_associations; Type: ACL; Schema: public; Owner: dak
5247 REVOKE ALL ON TABLE obsolete_all_associations FROM PUBLIC;
5248 REVOKE ALL ON TABLE obsolete_all_associations FROM dak;
5249 GRANT ALL ON TABLE obsolete_all_associations TO dak;
5250 GRANT SELECT ON TABLE obsolete_all_associations TO ftpmaster;
5251 GRANT SELECT ON TABLE obsolete_all_associations TO PUBLIC;
5255 -- Name: obsolete_any_associations; Type: ACL; Schema: public; Owner: dak
5258 REVOKE ALL ON TABLE obsolete_any_associations FROM PUBLIC;
5259 REVOKE ALL ON TABLE obsolete_any_associations FROM dak;
5260 GRANT ALL ON TABLE obsolete_any_associations TO dak;
5261 GRANT SELECT ON TABLE obsolete_any_associations TO ftpmaster;
5262 GRANT SELECT ON TABLE obsolete_any_associations TO PUBLIC;
5266 -- Name: obsolete_any_by_all_associations; Type: ACL; Schema: public; Owner: dak
5269 REVOKE ALL ON TABLE obsolete_any_by_all_associations FROM PUBLIC;
5270 REVOKE ALL ON TABLE obsolete_any_by_all_associations FROM dak;
5271 GRANT ALL ON TABLE obsolete_any_by_all_associations TO dak;
5272 GRANT SELECT ON TABLE obsolete_any_by_all_associations TO ftpmaster;
5273 GRANT SELECT ON TABLE obsolete_any_by_all_associations TO PUBLIC;
5277 -- Name: obsolete_src_associations; Type: ACL; Schema: public; Owner: dak
5280 REVOKE ALL ON TABLE obsolete_src_associations FROM PUBLIC;
5281 REVOKE ALL ON TABLE obsolete_src_associations FROM dak;
5282 GRANT ALL ON TABLE obsolete_src_associations TO dak;
5283 GRANT SELECT ON TABLE obsolete_src_associations TO ftpmaster;
5284 GRANT SELECT ON TABLE obsolete_src_associations TO PUBLIC;
5288 -- Name: override; Type: ACL; Schema: public; Owner: dak
5291 REVOKE ALL ON TABLE override FROM PUBLIC;
5292 REVOKE ALL ON TABLE override FROM dak;
5293 GRANT ALL ON TABLE override TO dak;
5294 GRANT SELECT ON TABLE override TO PUBLIC;
5295 GRANT ALL ON TABLE override TO ftpmaster;
5296 GRANT INSERT,DELETE,UPDATE ON TABLE override TO ftpteam;
5300 -- Name: override_type_id_seq; Type: ACL; Schema: public; Owner: dak
5303 REVOKE ALL ON SEQUENCE override_type_id_seq FROM PUBLIC;
5304 REVOKE ALL ON SEQUENCE override_type_id_seq FROM dak;
5305 GRANT ALL ON SEQUENCE override_type_id_seq TO dak;
5306 GRANT SELECT ON SEQUENCE override_type_id_seq TO PUBLIC;
5307 GRANT ALL ON SEQUENCE override_type_id_seq TO ftpmaster;
5311 -- Name: override_type; Type: ACL; Schema: public; Owner: dak
5314 REVOKE ALL ON TABLE override_type FROM PUBLIC;
5315 REVOKE ALL ON TABLE override_type FROM dak;
5316 GRANT ALL ON TABLE override_type TO dak;
5317 GRANT SELECT ON TABLE override_type TO PUBLIC;
5318 GRANT ALL ON TABLE override_type TO ftpmaster;
5322 -- Name: policy_queue; Type: ACL; Schema: public; Owner: dak
5325 REVOKE ALL ON TABLE policy_queue FROM PUBLIC;
5326 REVOKE ALL ON TABLE policy_queue FROM dak;
5327 GRANT ALL ON TABLE policy_queue TO dak;
5328 GRANT SELECT ON TABLE policy_queue TO PUBLIC;
5329 GRANT ALL ON TABLE policy_queue TO ftpmaster;
5333 -- Name: policy_queue_id_seq; Type: ACL; Schema: public; Owner: dak
5336 REVOKE ALL ON SEQUENCE policy_queue_id_seq FROM PUBLIC;
5337 REVOKE ALL ON SEQUENCE policy_queue_id_seq FROM dak;
5338 GRANT ALL ON SEQUENCE policy_queue_id_seq TO dak;
5339 GRANT ALL ON SEQUENCE policy_queue_id_seq TO ftpmaster;
5340 GRANT SELECT ON SEQUENCE policy_queue_id_seq TO PUBLIC;
5344 -- Name: priority_id_seq; Type: ACL; Schema: public; Owner: dak
5347 REVOKE ALL ON SEQUENCE priority_id_seq FROM PUBLIC;
5348 REVOKE ALL ON SEQUENCE priority_id_seq FROM dak;
5349 GRANT ALL ON SEQUENCE priority_id_seq TO dak;
5350 GRANT SELECT ON SEQUENCE priority_id_seq TO PUBLIC;
5351 GRANT ALL ON SEQUENCE priority_id_seq TO ftpmaster;
5355 -- Name: priority; Type: ACL; Schema: public; Owner: dak
5358 REVOKE ALL ON TABLE priority FROM PUBLIC;
5359 REVOKE ALL ON TABLE priority FROM dak;
5360 GRANT ALL ON TABLE priority TO dak;
5361 GRANT SELECT ON TABLE priority TO PUBLIC;
5362 GRANT ALL ON TABLE priority TO ftpmaster;
5366 -- Name: section_id_seq; Type: ACL; Schema: public; Owner: dak
5369 REVOKE ALL ON SEQUENCE section_id_seq FROM PUBLIC;
5370 REVOKE ALL ON SEQUENCE section_id_seq FROM dak;
5371 GRANT ALL ON SEQUENCE section_id_seq TO dak;
5372 GRANT SELECT ON SEQUENCE section_id_seq TO PUBLIC;
5373 GRANT ALL ON SEQUENCE section_id_seq TO ftpmaster;
5377 -- Name: section; Type: ACL; Schema: public; Owner: dak
5380 REVOKE ALL ON TABLE section FROM PUBLIC;
5381 REVOKE ALL ON TABLE section FROM dak;
5382 GRANT ALL ON TABLE section TO dak;
5383 GRANT SELECT ON TABLE section TO PUBLIC;
5384 GRANT ALL ON TABLE section TO ftpmaster;
5388 -- Name: source_acl; Type: ACL; Schema: public; Owner: dak
5391 REVOKE ALL ON TABLE source_acl FROM PUBLIC;
5392 REVOKE ALL ON TABLE source_acl FROM dak;
5393 GRANT ALL ON TABLE source_acl TO dak;
5394 GRANT SELECT ON TABLE source_acl TO PUBLIC;
5395 GRANT ALL ON TABLE source_acl TO ftpmaster;
5399 -- Name: source_acl_id_seq; Type: ACL; Schema: public; Owner: dak
5402 REVOKE ALL ON SEQUENCE source_acl_id_seq FROM PUBLIC;
5403 REVOKE ALL ON SEQUENCE source_acl_id_seq FROM dak;
5404 GRANT ALL ON SEQUENCE source_acl_id_seq TO dak;
5405 GRANT ALL ON SEQUENCE source_acl_id_seq TO ftpmaster;
5406 GRANT SELECT ON SEQUENCE source_acl_id_seq TO PUBLIC;
5410 -- Name: source_metadata; Type: ACL; Schema: public; Owner: dak
5413 REVOKE ALL ON TABLE source_metadata FROM PUBLIC;
5414 REVOKE ALL ON TABLE source_metadata FROM dak;
5415 GRANT ALL ON TABLE source_metadata TO dak;
5416 GRANT SELECT,INSERT,UPDATE ON TABLE source_metadata TO ftpmaster;
5417 GRANT SELECT ON TABLE source_metadata TO PUBLIC;
5421 -- Name: src_contents; Type: ACL; Schema: public; Owner: dak
5424 REVOKE ALL ON TABLE src_contents FROM PUBLIC;
5425 REVOKE ALL ON TABLE src_contents FROM dak;
5426 GRANT ALL ON TABLE src_contents TO dak;
5427 GRANT SELECT,INSERT,UPDATE ON TABLE src_contents TO ftpmaster;
5428 GRANT SELECT ON TABLE src_contents TO PUBLIC;
5432 -- Name: src_format; Type: ACL; Schema: public; Owner: dak
5435 REVOKE ALL ON TABLE src_format FROM PUBLIC;
5436 REVOKE ALL ON TABLE src_format FROM dak;
5437 GRANT ALL ON TABLE src_format TO dak;
5438 GRANT SELECT ON TABLE src_format TO PUBLIC;
5439 GRANT ALL ON TABLE src_format TO ftpmaster;
5443 -- Name: src_format_id_seq; Type: ACL; Schema: public; Owner: dak
5446 REVOKE ALL ON SEQUENCE src_format_id_seq FROM PUBLIC;
5447 REVOKE ALL ON SEQUENCE src_format_id_seq FROM dak;
5448 GRANT ALL ON SEQUENCE src_format_id_seq TO dak;
5449 GRANT ALL ON SEQUENCE src_format_id_seq TO ftpmaster;
5450 GRANT SELECT ON SEQUENCE src_format_id_seq TO PUBLIC;
5454 -- Name: src_uploaders; Type: ACL; Schema: public; Owner: dak
5457 REVOKE ALL ON TABLE src_uploaders FROM PUBLIC;
5458 REVOKE ALL ON TABLE src_uploaders FROM dak;
5459 GRANT ALL ON TABLE src_uploaders TO dak;
5460 GRANT SELECT ON TABLE src_uploaders TO PUBLIC;
5461 GRANT ALL ON TABLE src_uploaders TO ftpmaster;
5465 -- Name: src_uploaders_id_seq; Type: ACL; Schema: public; Owner: dak
5468 REVOKE ALL ON SEQUENCE src_uploaders_id_seq FROM PUBLIC;
5469 REVOKE ALL ON SEQUENCE src_uploaders_id_seq FROM dak;
5470 GRANT ALL ON SEQUENCE src_uploaders_id_seq TO dak;
5471 GRANT SELECT ON SEQUENCE src_uploaders_id_seq TO PUBLIC;
5472 GRANT ALL ON SEQUENCE src_uploaders_id_seq TO ftpmaster;
5476 -- Name: suite_architectures; Type: ACL; Schema: public; Owner: dak
5479 REVOKE ALL ON TABLE suite_architectures FROM PUBLIC;
5480 REVOKE ALL ON TABLE suite_architectures FROM dak;
5481 GRANT ALL ON TABLE suite_architectures TO dak;
5482 GRANT SELECT ON TABLE suite_architectures TO PUBLIC;
5483 GRANT ALL ON TABLE suite_architectures TO ftpmaster;
5487 -- Name: suite_arch_by_name; Type: ACL; Schema: public; Owner: dak
5490 REVOKE ALL ON TABLE suite_arch_by_name FROM PUBLIC;
5491 REVOKE ALL ON TABLE suite_arch_by_name FROM dak;
5492 GRANT ALL ON TABLE suite_arch_by_name TO dak;
5493 GRANT SELECT ON TABLE suite_arch_by_name TO PUBLIC;
5494 GRANT SELECT ON TABLE suite_arch_by_name TO ftpmaster;
5498 -- Name: suite_build_queue_copy; Type: ACL; Schema: public; Owner: dak
5501 REVOKE ALL ON TABLE suite_build_queue_copy FROM PUBLIC;
5502 REVOKE ALL ON TABLE suite_build_queue_copy FROM dak;
5503 GRANT ALL ON TABLE suite_build_queue_copy TO dak;
5504 GRANT SELECT ON TABLE suite_build_queue_copy TO PUBLIC;
5505 GRANT ALL ON TABLE suite_build_queue_copy TO ftpmaster;
5509 -- Name: suite_src_formats; Type: ACL; Schema: public; Owner: dak
5512 REVOKE ALL ON TABLE suite_src_formats FROM PUBLIC;
5513 REVOKE ALL ON TABLE suite_src_formats FROM dak;
5514 GRANT ALL ON TABLE suite_src_formats TO dak;
5515 GRANT SELECT ON TABLE suite_src_formats TO PUBLIC;
5516 GRANT ALL ON TABLE suite_src_formats TO ftpmaster;
5520 -- Name: uid_id_seq; Type: ACL; Schema: public; Owner: dak
5523 REVOKE ALL ON SEQUENCE uid_id_seq FROM PUBLIC;
5524 REVOKE ALL ON SEQUENCE uid_id_seq FROM dak;
5525 GRANT ALL ON SEQUENCE uid_id_seq TO dak;
5526 GRANT SELECT ON SEQUENCE uid_id_seq TO PUBLIC;
5527 GRANT ALL ON SEQUENCE uid_id_seq TO ftpmaster;
5531 -- Name: uid; Type: ACL; Schema: public; Owner: dak
5534 REVOKE ALL ON TABLE uid FROM PUBLIC;
5535 REVOKE ALL ON TABLE uid FROM dak;
5536 GRANT ALL ON TABLE uid TO dak;
5537 GRANT SELECT ON TABLE uid TO PUBLIC;
5538 GRANT ALL ON TABLE uid TO ftpmaster;
5542 -- Name: upload_blocks; Type: ACL; Schema: public; Owner: dak
5545 REVOKE ALL ON TABLE upload_blocks FROM PUBLIC;
5546 REVOKE ALL ON TABLE upload_blocks FROM dak;
5547 GRANT ALL ON TABLE upload_blocks TO dak;
5548 GRANT SELECT ON TABLE upload_blocks TO PUBLIC;
5549 GRANT ALL ON TABLE upload_blocks TO ftpmaster;
5553 -- Name: upload_blocks_id_seq; Type: ACL; Schema: public; Owner: dak
5556 REVOKE ALL ON SEQUENCE upload_blocks_id_seq FROM PUBLIC;
5557 REVOKE ALL ON SEQUENCE upload_blocks_id_seq FROM dak;
5558 GRANT ALL ON SEQUENCE upload_blocks_id_seq TO dak;
5559 GRANT ALL ON SEQUENCE upload_blocks_id_seq TO ftpmaster;
5560 GRANT SELECT ON SEQUENCE upload_blocks_id_seq TO PUBLIC;
5564 -- Name: version_check; Type: ACL; Schema: public; Owner: dak
5567 REVOKE ALL ON TABLE version_check FROM PUBLIC;
5568 REVOKE ALL ON TABLE version_check FROM dak;
5569 GRANT ALL ON TABLE version_check TO dak;
5570 GRANT SELECT,INSERT,UPDATE ON TABLE version_check TO ftpmaster;
5571 GRANT SELECT ON TABLE version_check TO PUBLIC;
5575 -- Name: version_checks; Type: ACL; Schema: public; Owner: dak
5578 REVOKE ALL ON TABLE version_checks FROM PUBLIC;
5579 REVOKE ALL ON TABLE version_checks FROM dak;
5580 GRANT ALL ON TABLE version_checks TO dak;
5581 GRANT SELECT ON TABLE version_checks TO PUBLIC;
5585 -- PostgreSQL database dump complete
5588 -- Set schema version
5589 INSERT INTO config (name, value) VALUES ('db_revision', 62);