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,
989 ALTER TABLE public.archive OWNER TO dak;
992 -- Name: bin_contents; Type: TABLE; Schema: public; Owner: dak; Tablespace:
995 CREATE TABLE bin_contents (
997 binary_id integer NOT NULL,
998 created timestamp with time zone DEFAULT now() NOT NULL,
999 modified timestamp with time zone DEFAULT now() NOT NULL
1003 ALTER TABLE public.bin_contents OWNER TO dak;
1006 -- Name: binaries_metadata; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1009 CREATE TABLE binaries_metadata (
1010 bin_id integer NOT NULL,
1011 key_id integer NOT NULL,
1016 ALTER TABLE public.binaries_metadata OWNER TO dak;
1019 -- Name: suite_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1022 CREATE SEQUENCE suite_id_seq
1030 ALTER TABLE public.suite_id_seq OWNER TO dak;
1033 -- Name: suite; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1036 CREATE TABLE suite (
1037 id integer DEFAULT nextval('suite_id_seq'::regclass) NOT NULL,
1038 suite_name text NOT NULL,
1043 untouchable boolean DEFAULT false NOT NULL,
1044 announce text DEFAULT 'debian-devel-changes@lists.debian.org'::text NOT NULL,
1046 overridecodename text,
1047 validtime integer DEFAULT 604800 NOT NULL,
1048 priority integer DEFAULT 0 NOT NULL,
1049 notautomatic boolean DEFAULT false NOT NULL,
1052 policy_queue_id integer,
1053 created timestamp with time zone DEFAULT now() NOT NULL,
1054 modified timestamp with time zone DEFAULT now() NOT NULL,
1056 butautomaticupgrades boolean DEFAULT false NOT NULL,
1058 CONSTRAINT bau_needs_na_set CHECK (((NOT butautomaticupgrades) OR notautomatic))
1062 ALTER TABLE public.suite OWNER TO dak;
1065 -- Name: binaries_suite_arch; Type: VIEW; Schema: public; Owner: dak
1068 CREATE VIEW binaries_suite_arch AS
1069 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)));
1072 ALTER TABLE public.binaries_suite_arch OWNER TO dak;
1075 -- Name: binary_acl; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1078 CREATE TABLE binary_acl (
1079 id integer NOT NULL,
1080 access_level text NOT NULL,
1081 created timestamp with time zone DEFAULT now() NOT NULL,
1082 modified timestamp with time zone DEFAULT now() NOT NULL
1086 ALTER TABLE public.binary_acl OWNER TO dak;
1089 -- Name: binary_acl_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1092 CREATE SEQUENCE binary_acl_id_seq
1100 ALTER TABLE public.binary_acl_id_seq OWNER TO dak;
1103 -- Name: binary_acl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1106 ALTER SEQUENCE binary_acl_id_seq OWNED BY binary_acl.id;
1110 -- Name: binary_acl_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1113 CREATE TABLE binary_acl_map (
1114 id integer NOT NULL,
1115 fingerprint_id integer NOT NULL,
1116 architecture_id integer NOT NULL,
1117 created timestamp with time zone DEFAULT now() NOT NULL,
1118 modified timestamp with time zone DEFAULT now() NOT NULL
1122 ALTER TABLE public.binary_acl_map OWNER TO dak;
1125 -- Name: binary_acl_map_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1128 CREATE SEQUENCE binary_acl_map_id_seq
1136 ALTER TABLE public.binary_acl_map_id_seq OWNER TO dak;
1139 -- Name: binary_acl_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1142 ALTER SEQUENCE binary_acl_map_id_seq OWNED BY binary_acl_map.id;
1146 -- Name: files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1149 CREATE SEQUENCE files_id_seq
1157 ALTER TABLE public.files_id_seq OWNER TO dak;
1160 -- Name: files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1163 CREATE TABLE files (
1164 id integer DEFAULT nextval('files_id_seq'::regclass) NOT NULL,
1165 filename text NOT NULL,
1166 size bigint NOT NULL,
1167 md5sum text NOT NULL,
1168 location integer NOT NULL,
1169 last_used timestamp with time zone,
1172 created timestamp with time zone DEFAULT now() NOT NULL,
1173 modified timestamp with time zone DEFAULT now() NOT NULL
1177 ALTER TABLE public.files OWNER TO dak;
1180 -- Name: location_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1183 CREATE SEQUENCE location_id_seq
1191 ALTER TABLE public.location_id_seq OWNER TO dak;
1194 -- Name: location; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1197 CREATE TABLE location (
1198 id integer DEFAULT nextval('location_id_seq'::regclass) NOT NULL,
1203 created timestamp with time zone DEFAULT now() NOT NULL,
1204 modified timestamp with time zone DEFAULT now() NOT NULL
1208 ALTER TABLE public.location OWNER TO dak;
1211 -- Name: binfiles_suite_component_arch; Type: VIEW; Schema: public; Owner: dak
1214 CREATE VIEW binfiles_suite_component_arch AS
1215 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)));
1218 ALTER TABLE public.binfiles_suite_component_arch OWNER TO dak;
1221 -- Name: build_queue; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1224 CREATE TABLE build_queue (
1225 id integer NOT NULL,
1226 queue_name text NOT NULL,
1228 copy_files boolean DEFAULT false NOT NULL,
1229 generate_metadata boolean DEFAULT false NOT NULL,
1232 releasedescription text,
1234 stay_of_execution integer DEFAULT 86400 NOT NULL,
1235 created timestamp with time zone DEFAULT now() NOT NULL,
1236 modified timestamp with time zone DEFAULT now() NOT NULL,
1237 notautomatic boolean DEFAULT false NOT NULL,
1238 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)))),
1239 CONSTRAINT build_queue_stay_of_execution_check CHECK ((stay_of_execution >= 0))
1243 ALTER TABLE public.build_queue OWNER TO dak;
1246 -- Name: build_queue_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1249 CREATE TABLE build_queue_files (
1250 id integer NOT NULL,
1251 build_queue_id integer NOT NULL,
1252 insertdate timestamp without time zone DEFAULT now() NOT NULL,
1253 lastused timestamp without time zone,
1254 filename text NOT NULL,
1256 created timestamp with time zone DEFAULT now() NOT NULL,
1257 modified timestamp with time zone DEFAULT now() NOT NULL
1261 ALTER TABLE public.build_queue_files OWNER TO dak;
1264 -- Name: build_queue_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1267 CREATE SEQUENCE build_queue_files_id_seq
1275 ALTER TABLE public.build_queue_files_id_seq OWNER TO dak;
1278 -- Name: build_queue_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1281 ALTER SEQUENCE build_queue_files_id_seq OWNED BY build_queue_files.id;
1285 -- Name: build_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1288 CREATE SEQUENCE build_queue_id_seq
1296 ALTER TABLE public.build_queue_id_seq OWNER TO dak;
1299 -- Name: build_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1302 ALTER SEQUENCE build_queue_id_seq OWNED BY build_queue.id;
1306 -- Name: build_queue_policy_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1309 CREATE TABLE build_queue_policy_files (
1310 build_queue_id integer NOT NULL,
1311 file_id integer NOT NULL,
1312 filename text NOT NULL,
1313 created timestamp with time zone DEFAULT now() NOT NULL,
1314 lastused timestamp without time zone
1318 ALTER TABLE public.build_queue_policy_files OWNER TO dak;
1321 -- Name: changelogs_text; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1324 CREATE TABLE changelogs_text (
1325 id integer NOT NULL,
1330 ALTER TABLE public.changelogs_text OWNER TO dak;
1333 -- Name: changes; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1336 CREATE TABLE changes (
1337 id integer NOT NULL,
1338 changesname text NOT NULL,
1339 seen timestamp with time zone DEFAULT now() NOT NULL,
1340 source text NOT NULL,
1341 binaries text NOT NULL,
1342 architecture text NOT NULL,
1343 version text NOT NULL,
1344 distribution text NOT NULL,
1345 urgency text NOT NULL,
1346 maintainer text NOT NULL,
1347 fingerprint text NOT NULL,
1348 changedby text NOT NULL,
1351 approved_for integer,
1352 created timestamp with time zone DEFAULT now() NOT NULL,
1353 modified timestamp with time zone DEFAULT now() NOT NULL,
1354 changelog_id integer
1358 ALTER TABLE public.changes OWNER TO dak;
1361 -- Name: changelogs; Type: VIEW; Schema: public; Owner: dak
1364 CREATE VIEW changelogs AS
1365 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)));
1368 ALTER TABLE public.changelogs OWNER TO dak;
1371 -- Name: changelogs_text_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1374 CREATE SEQUENCE changelogs_text_id_seq
1382 ALTER TABLE public.changelogs_text_id_seq OWNER TO dak;
1385 -- Name: changelogs_text_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1388 ALTER SEQUENCE changelogs_text_id_seq OWNED BY changelogs_text.id;
1392 -- Name: changes_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1395 CREATE SEQUENCE changes_id_seq
1403 ALTER TABLE public.changes_id_seq OWNER TO dak;
1406 -- Name: changes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1409 ALTER SEQUENCE changes_id_seq OWNED BY changes.id;
1413 -- Name: changes_pending_binaries; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1416 CREATE TABLE changes_pending_binaries (
1417 id integer NOT NULL,
1418 change_id integer NOT NULL,
1419 package text NOT NULL,
1420 version debversion NOT NULL,
1421 architecture_id integer NOT NULL,
1423 pending_source_id integer,
1424 pending_file_id integer,
1425 created timestamp with time zone DEFAULT now() NOT NULL,
1426 modified timestamp with time zone DEFAULT now() NOT NULL,
1427 CONSTRAINT changes_pending_binaries_check CHECK (((source_id IS NOT NULL) OR (pending_source_id IS NOT NULL)))
1431 ALTER TABLE public.changes_pending_binaries OWNER TO dak;
1434 -- Name: changes_pending_binaries_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1437 CREATE SEQUENCE changes_pending_binaries_id_seq
1445 ALTER TABLE public.changes_pending_binaries_id_seq OWNER TO dak;
1448 -- Name: changes_pending_binaries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1451 ALTER SEQUENCE changes_pending_binaries_id_seq OWNED BY changes_pending_binaries.id;
1455 -- Name: changes_pending_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1458 CREATE TABLE changes_pending_files (
1459 id integer NOT NULL,
1460 filename text NOT NULL,
1461 size bigint NOT NULL,
1462 md5sum text NOT NULL,
1463 sha1sum text NOT NULL,
1464 sha256sum text NOT NULL,
1465 created timestamp with time zone DEFAULT now() NOT NULL,
1466 modified timestamp with time zone DEFAULT now() NOT NULL,
1467 processed boolean DEFAULT false
1471 ALTER TABLE public.changes_pending_files OWNER TO dak;
1474 -- Name: changes_pending_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1477 CREATE SEQUENCE changes_pending_files_id_seq
1485 ALTER TABLE public.changes_pending_files_id_seq OWNER TO dak;
1488 -- Name: changes_pending_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1491 ALTER SEQUENCE changes_pending_files_id_seq OWNED BY changes_pending_files.id;
1495 -- Name: changes_pending_files_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1498 CREATE TABLE changes_pending_files_map (
1499 file_id integer NOT NULL,
1500 change_id integer NOT NULL,
1501 created timestamp with time zone DEFAULT now() NOT NULL,
1502 modified timestamp with time zone DEFAULT now() NOT NULL
1506 ALTER TABLE public.changes_pending_files_map OWNER TO dak;
1509 -- Name: changes_pending_source; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1512 CREATE TABLE changes_pending_source (
1513 id integer NOT NULL,
1514 change_id integer NOT NULL,
1515 source text NOT NULL,
1516 version debversion NOT NULL,
1517 maintainer_id integer NOT NULL,
1518 changedby_id integer NOT NULL,
1519 sig_fpr integer NOT NULL,
1520 dm_upload_allowed boolean DEFAULT false NOT NULL,
1521 created timestamp with time zone DEFAULT now() NOT NULL,
1522 modified timestamp with time zone DEFAULT now() NOT NULL
1526 ALTER TABLE public.changes_pending_source OWNER TO dak;
1529 -- Name: changes_pending_source_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1532 CREATE TABLE changes_pending_source_files (
1533 pending_source_id integer NOT NULL,
1534 pending_file_id integer NOT NULL,
1535 created timestamp with time zone DEFAULT now() NOT NULL,
1536 modified timestamp with time zone DEFAULT now() NOT NULL
1540 ALTER TABLE public.changes_pending_source_files OWNER TO dak;
1543 -- Name: changes_pending_source_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1546 CREATE SEQUENCE changes_pending_source_id_seq
1554 ALTER TABLE public.changes_pending_source_id_seq OWNER TO dak;
1557 -- Name: changes_pending_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1560 ALTER SEQUENCE changes_pending_source_id_seq OWNED BY changes_pending_source.id;
1564 -- Name: changes_pool_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1567 CREATE TABLE changes_pool_files (
1568 changeid integer NOT NULL,
1569 fileid integer NOT NULL,
1570 created timestamp with time zone DEFAULT now() NOT NULL,
1571 modified timestamp with time zone DEFAULT now() NOT NULL
1575 ALTER TABLE public.changes_pool_files OWNER TO dak;
1578 -- Name: component_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1581 CREATE SEQUENCE component_id_seq
1589 ALTER TABLE public.component_id_seq OWNER TO dak;
1592 -- Name: component; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1595 CREATE TABLE component (
1596 id integer DEFAULT nextval('component_id_seq'::regclass) NOT NULL,
1600 created timestamp with time zone DEFAULT now() NOT NULL,
1601 modified timestamp with time zone DEFAULT now() NOT NULL
1605 ALTER TABLE public.component OWNER TO dak;
1608 -- Name: config; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1611 CREATE TABLE config (
1612 id integer NOT NULL,
1615 created timestamp with time zone DEFAULT now() NOT NULL,
1616 modified timestamp with time zone DEFAULT now() NOT NULL
1620 ALTER TABLE public.config OWNER TO dak;
1623 -- Name: config_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1626 CREATE SEQUENCE config_id_seq
1634 ALTER TABLE public.config_id_seq OWNER TO dak;
1637 -- Name: config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1640 ALTER SEQUENCE config_id_seq OWNED BY config.id;
1644 -- Name: dsc_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1647 CREATE SEQUENCE dsc_files_id_seq
1655 ALTER TABLE public.dsc_files_id_seq OWNER TO dak;
1658 -- Name: dsc_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1661 CREATE TABLE dsc_files (
1662 id integer DEFAULT nextval('dsc_files_id_seq'::regclass) NOT NULL,
1663 source integer NOT NULL,
1664 file integer NOT NULL,
1665 created timestamp with time zone DEFAULT now() NOT NULL,
1666 modified timestamp with time zone DEFAULT now() NOT NULL
1670 ALTER TABLE public.dsc_files OWNER TO dak;
1673 -- Name: external_overrides; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1676 CREATE TABLE external_overrides (
1677 package text NOT NULL,
1679 value text NOT NULL,
1680 suite integer NOT NULL,
1681 component integer NOT NULL
1685 ALTER TABLE public.external_overrides OWNER TO dak;
1688 -- Name: extra_src_references; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1691 CREATE TABLE extra_src_references (
1692 bin_id integer NOT NULL,
1693 src_id integer NOT NULL
1697 ALTER TABLE public.extra_src_references OWNER TO dak;
1700 -- Name: file_arch_suite; Type: VIEW; Schema: public; Owner: dak
1703 CREATE VIEW file_arch_suite AS
1704 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));
1707 ALTER TABLE public.file_arch_suite OWNER TO dak;
1710 -- Name: fingerprint_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1713 CREATE SEQUENCE fingerprint_id_seq
1721 ALTER TABLE public.fingerprint_id_seq OWNER TO dak;
1724 -- Name: fingerprint; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1727 CREATE TABLE fingerprint (
1728 id integer DEFAULT nextval('fingerprint_id_seq'::regclass) NOT NULL,
1729 fingerprint text NOT NULL,
1732 source_acl_id integer,
1733 binary_acl_id integer,
1734 binary_reject boolean DEFAULT true NOT NULL,
1735 created timestamp with time zone DEFAULT now() NOT NULL,
1736 modified timestamp with time zone DEFAULT now() NOT NULL
1740 ALTER TABLE public.fingerprint OWNER TO dak;
1743 -- Name: keyring_acl_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1746 CREATE TABLE keyring_acl_map (
1747 id integer NOT NULL,
1748 keyring_id integer NOT NULL,
1749 architecture_id integer NOT NULL,
1750 created timestamp with time zone DEFAULT now() NOT NULL,
1751 modified timestamp with time zone DEFAULT now() NOT NULL
1755 ALTER TABLE public.keyring_acl_map OWNER TO dak;
1758 -- Name: keyring_acl_map_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1761 CREATE SEQUENCE keyring_acl_map_id_seq
1769 ALTER TABLE public.keyring_acl_map_id_seq OWNER TO dak;
1772 -- Name: keyring_acl_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1775 ALTER SEQUENCE keyring_acl_map_id_seq OWNED BY keyring_acl_map.id;
1779 -- Name: keyrings; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1782 CREATE TABLE keyrings (
1783 id integer NOT NULL,
1785 default_source_acl_id integer,
1786 default_binary_acl_id integer,
1787 default_binary_reject boolean DEFAULT true NOT NULL,
1788 priority integer DEFAULT 100 NOT NULL,
1789 created timestamp with time zone DEFAULT now() NOT NULL,
1790 modified timestamp with time zone DEFAULT now() NOT NULL,
1791 active boolean DEFAULT true
1795 ALTER TABLE public.keyrings OWNER TO dak;
1798 -- Name: keyrings_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1801 CREATE SEQUENCE keyrings_id_seq
1809 ALTER TABLE public.keyrings_id_seq OWNER TO dak;
1812 -- Name: keyrings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1815 ALTER SEQUENCE keyrings_id_seq OWNED BY keyrings.id;
1819 -- Name: maintainer_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1822 CREATE SEQUENCE maintainer_id_seq
1830 ALTER TABLE public.maintainer_id_seq OWNER TO dak;
1833 -- Name: maintainer; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1836 CREATE TABLE maintainer (
1837 id integer DEFAULT nextval('maintainer_id_seq'::regclass) NOT NULL,
1839 created timestamp with time zone DEFAULT now() NOT NULL,
1840 modified timestamp with time zone DEFAULT now() NOT NULL
1844 ALTER TABLE public.maintainer OWNER TO dak;
1847 -- Name: metadata_keys; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1850 CREATE TABLE metadata_keys (
1851 key_id integer NOT NULL,
1853 ordering integer DEFAULT 0 NOT NULL
1857 ALTER TABLE public.metadata_keys OWNER TO dak;
1860 -- Name: metadata_keys_key_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1863 CREATE SEQUENCE metadata_keys_key_id_seq
1871 ALTER TABLE public.metadata_keys_key_id_seq OWNER TO dak;
1874 -- Name: metadata_keys_key_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1877 ALTER SEQUENCE metadata_keys_key_id_seq OWNED BY metadata_keys.key_id;
1881 -- Name: new_comments; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1884 CREATE TABLE new_comments (
1885 id integer NOT NULL,
1886 package text NOT NULL,
1887 version text NOT NULL,
1888 comment text NOT NULL,
1889 author text NOT NULL,
1890 notedate timestamp with time zone DEFAULT now() NOT NULL,
1891 trainee boolean DEFAULT false NOT NULL,
1892 created timestamp with time zone DEFAULT now() NOT NULL,
1893 modified timestamp with time zone DEFAULT now() NOT NULL
1897 ALTER TABLE public.new_comments OWNER TO dak;
1900 -- Name: new_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1903 CREATE SEQUENCE new_comments_id_seq
1911 ALTER TABLE public.new_comments_id_seq OWNER TO dak;
1914 -- Name: new_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1917 ALTER SEQUENCE new_comments_id_seq OWNED BY new_comments.id;
1921 -- Name: newest_all_associations; Type: VIEW; Schema: public; Owner: dak
1924 CREATE VIEW newest_all_associations AS
1925 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;
1928 ALTER TABLE public.newest_all_associations OWNER TO dak;
1931 -- Name: newest_any_associations; Type: VIEW; Schema: public; Owner: dak
1934 CREATE VIEW newest_any_associations AS
1935 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;
1938 ALTER TABLE public.newest_any_associations OWNER TO dak;
1941 -- Name: source_suite; Type: VIEW; Schema: public; Owner: dak
1944 CREATE VIEW source_suite AS
1945 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)));
1948 ALTER TABLE public.source_suite OWNER TO dak;
1951 -- Name: newest_source; Type: VIEW; Schema: public; Owner: dak
1954 CREATE VIEW newest_source AS
1955 SELECT source_suite.source, max(source_suite.version) AS version, source_suite.suite FROM source_suite GROUP BY source_suite.source, source_suite.suite;
1958 ALTER TABLE public.newest_source OWNER TO dak;
1961 -- Name: newest_src_association; Type: VIEW; Schema: public; Owner: dak
1964 CREATE VIEW newest_src_association AS
1965 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));
1968 ALTER TABLE public.newest_src_association OWNER TO dak;
1971 -- Name: obsolete_all_associations; Type: VIEW; Schema: public; Owner: dak
1974 CREATE VIEW obsolete_all_associations AS
1975 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))));
1978 ALTER TABLE public.obsolete_all_associations OWNER TO dak;
1981 -- Name: obsolete_any_associations; Type: VIEW; Schema: public; Owner: dak
1984 CREATE VIEW obsolete_any_associations AS
1985 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))));
1988 ALTER TABLE public.obsolete_any_associations OWNER TO dak;
1991 -- Name: obsolete_any_by_all_associations; Type: VIEW; Schema: public; Owner: dak
1994 CREATE VIEW obsolete_any_by_all_associations AS
1995 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))));
1998 ALTER TABLE public.obsolete_any_by_all_associations OWNER TO dak;
2001 -- Name: obsolete_src_associations; Type: VIEW; Schema: public; Owner: dak
2004 CREATE VIEW obsolete_src_associations AS
2005 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))));
2008 ALTER TABLE public.obsolete_src_associations OWNER TO dak;
2011 -- Name: override; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2014 CREATE TABLE override (
2015 package text NOT NULL,
2016 suite integer NOT NULL,
2017 component integer NOT NULL,
2019 section integer NOT NULL,
2020 type integer NOT NULL,
2022 created timestamp with time zone DEFAULT now() NOT NULL,
2023 modified timestamp with time zone DEFAULT now() NOT NULL
2027 ALTER TABLE public.override OWNER TO dak;
2030 -- Name: override_type_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2033 CREATE SEQUENCE override_type_id_seq
2041 ALTER TABLE public.override_type_id_seq OWNER TO dak;
2044 -- Name: override_type; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2047 CREATE TABLE override_type (
2048 id integer DEFAULT nextval('override_type_id_seq'::regclass) NOT NULL,
2050 created timestamp with time zone DEFAULT now() NOT NULL,
2051 modified timestamp with time zone DEFAULT now() NOT NULL
2055 ALTER TABLE public.override_type OWNER TO dak;
2058 -- Name: policy_queue; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2061 CREATE TABLE policy_queue (
2062 id integer NOT NULL,
2063 queue_name text NOT NULL,
2065 perms character(4) DEFAULT '0660'::bpchar NOT NULL,
2066 change_perms character(4) DEFAULT '0660'::bpchar NOT NULL,
2067 generate_metadata boolean DEFAULT false NOT NULL,
2070 releasedescription text,
2072 stay_of_execution integer DEFAULT 86400 NOT NULL,
2073 created timestamp with time zone DEFAULT now() NOT NULL,
2074 modified timestamp with time zone DEFAULT now() NOT NULL,
2075 send_to_build_queues boolean DEFAULT false NOT NULL,
2076 CONSTRAINT policy_queue_change_perms_check CHECK ((change_perms ~ similar_escape('[0-7][0-7][0-7][0-7]'::text, NULL::text))),
2077 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)))),
2078 CONSTRAINT policy_queue_perms_check CHECK ((perms ~ similar_escape('[0-7][0-7][0-7][0-7]'::text, NULL::text))),
2079 CONSTRAINT policy_queue_stay_of_execution_check CHECK ((stay_of_execution >= 0))
2083 ALTER TABLE public.policy_queue OWNER TO dak;
2086 -- Name: policy_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2089 CREATE SEQUENCE policy_queue_id_seq
2097 ALTER TABLE public.policy_queue_id_seq OWNER TO dak;
2100 -- Name: policy_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2103 ALTER SEQUENCE policy_queue_id_seq OWNED BY policy_queue.id;
2107 -- Name: priority_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2110 CREATE SEQUENCE priority_id_seq
2118 ALTER TABLE public.priority_id_seq OWNER TO dak;
2121 -- Name: priority; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2124 CREATE TABLE priority (
2125 id integer DEFAULT nextval('priority_id_seq'::regclass) NOT NULL,
2126 priority text NOT NULL,
2127 level integer NOT NULL,
2128 created timestamp with time zone DEFAULT now() NOT NULL,
2129 modified timestamp with time zone DEFAULT now() NOT NULL
2133 ALTER TABLE public.priority OWNER TO dak;
2136 -- Name: section_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2139 CREATE SEQUENCE section_id_seq
2147 ALTER TABLE public.section_id_seq OWNER TO dak;
2150 -- Name: section; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2153 CREATE TABLE section (
2154 id integer DEFAULT nextval('section_id_seq'::regclass) NOT NULL,
2155 section text NOT NULL,
2156 created timestamp with time zone DEFAULT now() NOT NULL,
2157 modified timestamp with time zone DEFAULT now() NOT NULL
2161 ALTER TABLE public.section OWNER TO dak;
2164 -- Name: source_acl; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2167 CREATE TABLE source_acl (
2168 id integer NOT NULL,
2169 access_level text NOT NULL,
2170 created timestamp with time zone DEFAULT now() NOT NULL,
2171 modified timestamp with time zone DEFAULT now() NOT NULL
2175 ALTER TABLE public.source_acl OWNER TO dak;
2178 -- Name: source_acl_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2181 CREATE SEQUENCE source_acl_id_seq
2189 ALTER TABLE public.source_acl_id_seq OWNER TO dak;
2192 -- Name: source_acl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2195 ALTER SEQUENCE source_acl_id_seq OWNED BY source_acl.id;
2199 -- Name: source_metadata; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2202 CREATE TABLE source_metadata (
2203 src_id integer NOT NULL,
2204 key_id integer NOT NULL,
2209 ALTER TABLE public.source_metadata OWNER TO dak;
2212 -- Name: src_contents; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2215 CREATE TABLE src_contents (
2217 source_id integer NOT NULL,
2218 created timestamp with time zone DEFAULT now() NOT NULL,
2219 modified timestamp with time zone DEFAULT now() NOT NULL
2223 ALTER TABLE public.src_contents OWNER TO dak;
2226 -- Name: src_format; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2229 CREATE TABLE src_format (
2230 id integer NOT NULL,
2231 format_name text NOT NULL,
2232 created timestamp with time zone DEFAULT now() NOT NULL,
2233 modified timestamp with time zone DEFAULT now() NOT NULL
2237 ALTER TABLE public.src_format OWNER TO dak;
2240 -- Name: src_format_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2243 CREATE SEQUENCE src_format_id_seq
2251 ALTER TABLE public.src_format_id_seq OWNER TO dak;
2254 -- Name: src_format_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2257 ALTER SEQUENCE src_format_id_seq OWNED BY src_format.id;
2261 -- Name: src_uploaders; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2264 CREATE TABLE src_uploaders (
2265 id integer NOT NULL,
2266 source integer NOT NULL,
2267 maintainer integer NOT NULL,
2268 created timestamp with time zone DEFAULT now() NOT NULL,
2269 modified timestamp with time zone DEFAULT now() NOT NULL
2273 ALTER TABLE public.src_uploaders OWNER TO dak;
2276 -- Name: src_uploaders_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2279 CREATE SEQUENCE src_uploaders_id_seq
2287 ALTER TABLE public.src_uploaders_id_seq OWNER TO dak;
2290 -- Name: src_uploaders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2293 ALTER SEQUENCE src_uploaders_id_seq OWNED BY src_uploaders.id;
2297 -- Name: suite_architectures; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2300 CREATE TABLE suite_architectures (
2301 suite integer NOT NULL,
2302 architecture integer NOT NULL,
2303 created timestamp with time zone DEFAULT now() NOT NULL,
2304 modified timestamp with time zone DEFAULT now() NOT NULL
2308 ALTER TABLE public.suite_architectures OWNER TO dak;
2311 -- Name: suite_arch_by_name; Type: VIEW; Schema: public; Owner: dak
2314 CREATE VIEW suite_arch_by_name AS
2315 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]));
2318 ALTER TABLE public.suite_arch_by_name OWNER TO dak;
2321 -- Name: suite_build_queue_copy; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2324 CREATE TABLE suite_build_queue_copy (
2325 suite integer NOT NULL,
2326 build_queue_id integer NOT NULL,
2327 created timestamp with time zone DEFAULT now() NOT NULL,
2328 modified timestamp with time zone DEFAULT now() NOT NULL
2332 ALTER TABLE public.suite_build_queue_copy OWNER TO dak;
2335 -- Name: suite_src_formats; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2338 CREATE TABLE suite_src_formats (
2339 suite integer NOT NULL,
2340 src_format integer NOT NULL,
2341 created timestamp with time zone DEFAULT now() NOT NULL,
2342 modified timestamp with time zone DEFAULT now() NOT NULL
2346 ALTER TABLE public.suite_src_formats OWNER TO dak;
2349 -- Name: uid_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2352 CREATE SEQUENCE uid_id_seq
2360 ALTER TABLE public.uid_id_seq OWNER TO dak;
2363 -- Name: uid; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2367 id integer DEFAULT nextval('uid_id_seq'::regclass) NOT NULL,
2370 created timestamp with time zone DEFAULT now() NOT NULL,
2371 modified timestamp with time zone DEFAULT now() NOT NULL
2375 ALTER TABLE public.uid OWNER TO dak;
2378 -- Name: upload_blocks; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2381 CREATE TABLE upload_blocks (
2382 id integer NOT NULL,
2383 source text NOT NULL,
2385 fingerprint_id integer,
2387 reason text NOT NULL,
2388 created timestamp with time zone DEFAULT now() NOT NULL,
2389 modified timestamp with time zone DEFAULT now() NOT NULL,
2390 CONSTRAINT upload_blocks_check CHECK (((fingerprint_id IS NOT NULL) OR (uid_id IS NOT NULL)))
2394 ALTER TABLE public.upload_blocks OWNER TO dak;
2397 -- Name: upload_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2400 CREATE SEQUENCE upload_blocks_id_seq
2408 ALTER TABLE public.upload_blocks_id_seq OWNER TO dak;
2411 -- Name: upload_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2414 ALTER SEQUENCE upload_blocks_id_seq OWNED BY upload_blocks.id;
2418 -- Name: version_check; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2421 CREATE TABLE version_check (
2422 suite integer NOT NULL,
2423 "check" text NOT NULL,
2424 reference integer NOT NULL,
2425 CONSTRAINT version_check_check_check CHECK (("check" = ANY (ARRAY['Enhances'::text, 'MustBeNewerThan'::text, 'MustBeOlderThan'::text])))
2429 ALTER TABLE public.version_check OWNER TO dak;
2432 -- Name: version_checks; Type: VIEW; Schema: public; Owner: dak
2435 CREATE VIEW version_checks AS
2436 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;
2439 ALTER TABLE public.version_checks OWNER TO dak;
2442 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2445 ALTER TABLE binary_acl ALTER COLUMN id SET DEFAULT nextval('binary_acl_id_seq'::regclass);
2449 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2452 ALTER TABLE binary_acl_map ALTER COLUMN id SET DEFAULT nextval('binary_acl_map_id_seq'::regclass);
2456 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2459 ALTER TABLE build_queue ALTER COLUMN id SET DEFAULT nextval('build_queue_id_seq'::regclass);
2463 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2466 ALTER TABLE build_queue_files ALTER COLUMN id SET DEFAULT nextval('build_queue_files_id_seq'::regclass);
2470 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2473 ALTER TABLE changelogs_text ALTER COLUMN id SET DEFAULT nextval('changelogs_text_id_seq'::regclass);
2477 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2480 ALTER TABLE changes ALTER COLUMN id SET DEFAULT nextval('changes_id_seq'::regclass);
2484 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2487 ALTER TABLE changes_pending_binaries ALTER COLUMN id SET DEFAULT nextval('changes_pending_binaries_id_seq'::regclass);
2491 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2494 ALTER TABLE changes_pending_files ALTER COLUMN id SET DEFAULT nextval('changes_pending_files_id_seq'::regclass);
2498 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2501 ALTER TABLE changes_pending_source ALTER COLUMN id SET DEFAULT nextval('changes_pending_source_id_seq'::regclass);
2505 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2508 ALTER TABLE config ALTER COLUMN id SET DEFAULT nextval('config_id_seq'::regclass);
2512 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2515 ALTER TABLE keyring_acl_map ALTER COLUMN id SET DEFAULT nextval('keyring_acl_map_id_seq'::regclass);
2519 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2522 ALTER TABLE keyrings ALTER COLUMN id SET DEFAULT nextval('keyrings_id_seq'::regclass);
2526 -- Name: key_id; Type: DEFAULT; Schema: public; Owner: dak
2529 ALTER TABLE metadata_keys ALTER COLUMN key_id SET DEFAULT nextval('metadata_keys_key_id_seq'::regclass);
2533 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2536 ALTER TABLE new_comments ALTER COLUMN id SET DEFAULT nextval('new_comments_id_seq'::regclass);
2540 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2543 ALTER TABLE policy_queue ALTER COLUMN id SET DEFAULT nextval('policy_queue_id_seq'::regclass);
2547 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2550 ALTER TABLE source_acl ALTER COLUMN id SET DEFAULT nextval('source_acl_id_seq'::regclass);
2554 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2557 ALTER TABLE src_format ALTER COLUMN id SET DEFAULT nextval('src_format_id_seq'::regclass);
2561 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2564 ALTER TABLE src_uploaders ALTER COLUMN id SET DEFAULT nextval('src_uploaders_id_seq'::regclass);
2568 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2571 ALTER TABLE upload_blocks ALTER COLUMN id SET DEFAULT nextval('upload_blocks_id_seq'::regclass);
2575 -- Name: architecture_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2578 ALTER TABLE ONLY architecture
2579 ADD CONSTRAINT architecture_pkey PRIMARY KEY (id);
2583 -- Name: archive_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2586 ALTER TABLE ONLY archive
2587 ADD CONSTRAINT archive_pkey PRIMARY KEY (id);
2591 -- Name: bin_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2594 ALTER TABLE ONLY bin_associations
2595 ADD CONSTRAINT bin_associations_pkey PRIMARY KEY (id);
2599 -- Name: bin_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2602 ALTER TABLE ONLY bin_contents
2603 ADD CONSTRAINT bin_contents_pkey PRIMARY KEY (file, binary_id);
2607 -- Name: binaries_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2610 ALTER TABLE ONLY binaries_metadata
2611 ADD CONSTRAINT binaries_metadata_pkey PRIMARY KEY (bin_id, key_id);
2615 -- Name: binaries_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2618 ALTER TABLE ONLY binaries
2619 ADD CONSTRAINT binaries_pkey PRIMARY KEY (id);
2623 -- Name: binary_acl_access_level_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2626 ALTER TABLE ONLY binary_acl
2627 ADD CONSTRAINT binary_acl_access_level_key UNIQUE (access_level);
2631 -- Name: binary_acl_map_fingerprint_id_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2634 ALTER TABLE ONLY binary_acl_map
2635 ADD CONSTRAINT binary_acl_map_fingerprint_id_key UNIQUE (fingerprint_id, architecture_id);
2639 -- Name: binary_acl_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2642 ALTER TABLE ONLY binary_acl_map
2643 ADD CONSTRAINT binary_acl_map_pkey PRIMARY KEY (id);
2647 -- Name: binary_acl_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2650 ALTER TABLE ONLY binary_acl
2651 ADD CONSTRAINT binary_acl_pkey PRIMARY KEY (id);
2655 -- Name: build_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2658 ALTER TABLE ONLY build_queue
2659 ADD CONSTRAINT build_queue_pkey PRIMARY KEY (id);
2663 -- Name: build_queue_policy_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2666 ALTER TABLE ONLY build_queue_policy_files
2667 ADD CONSTRAINT build_queue_policy_files_pkey PRIMARY KEY (build_queue_id, file_id);
2671 -- Name: build_queue_queue_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2674 ALTER TABLE ONLY build_queue
2675 ADD CONSTRAINT build_queue_queue_name_key UNIQUE (queue_name);
2679 -- Name: changelogs_text_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2682 ALTER TABLE ONLY changelogs_text
2683 ADD CONSTRAINT changelogs_text_pkey PRIMARY KEY (id);
2687 -- Name: changes_pending_binaries_package_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2690 ALTER TABLE ONLY changes_pending_binaries
2691 ADD CONSTRAINT changes_pending_binaries_package_key UNIQUE (package, version, architecture_id);
2695 -- Name: changes_pending_binaries_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2698 ALTER TABLE ONLY changes_pending_binaries
2699 ADD CONSTRAINT changes_pending_binaries_pkey PRIMARY KEY (id);
2703 -- Name: changes_pending_files_filename_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2706 ALTER TABLE ONLY changes_pending_files
2707 ADD CONSTRAINT changes_pending_files_filename_key UNIQUE (filename);
2711 -- Name: changes_pending_files_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2714 ALTER TABLE ONLY changes_pending_files_map
2715 ADD CONSTRAINT changes_pending_files_map_pkey PRIMARY KEY (file_id, change_id);
2719 -- Name: changes_pending_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2722 ALTER TABLE ONLY changes_pending_files
2723 ADD CONSTRAINT changes_pending_files_pkey PRIMARY KEY (id);
2727 -- Name: changes_pending_source_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2730 ALTER TABLE ONLY changes_pending_source_files
2731 ADD CONSTRAINT changes_pending_source_files_pkey PRIMARY KEY (pending_source_id, pending_file_id);
2735 -- Name: changes_pending_source_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2738 ALTER TABLE ONLY changes_pending_source
2739 ADD CONSTRAINT changes_pending_source_pkey PRIMARY KEY (id);
2743 -- Name: changes_pool_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2746 ALTER TABLE ONLY changes_pool_files
2747 ADD CONSTRAINT changes_pool_files_pkey PRIMARY KEY (changeid, fileid);
2751 -- Name: component_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2754 ALTER TABLE ONLY component
2755 ADD CONSTRAINT component_pkey PRIMARY KEY (id);
2759 -- Name: config_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2762 ALTER TABLE ONLY config
2763 ADD CONSTRAINT config_name_key UNIQUE (name);
2767 -- Name: config_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2770 ALTER TABLE ONLY config
2771 ADD CONSTRAINT config_pkey PRIMARY KEY (id);
2775 -- Name: dsc_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2778 ALTER TABLE ONLY dsc_files
2779 ADD CONSTRAINT dsc_files_pkey PRIMARY KEY (id);
2783 -- Name: external_overrides_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2786 ALTER TABLE ONLY external_overrides
2787 ADD CONSTRAINT external_overrides_pkey PRIMARY KEY (suite, component, package, key);
2791 -- Name: extra_src_references_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2794 ALTER TABLE ONLY extra_src_references
2795 ADD CONSTRAINT extra_src_references_pkey PRIMARY KEY (bin_id, src_id);
2799 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2802 ALTER TABLE ONLY files
2803 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
2807 -- Name: fingerprint_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2810 ALTER TABLE ONLY fingerprint
2811 ADD CONSTRAINT fingerprint_pkey PRIMARY KEY (id);
2815 -- Name: keyring_acl_map_keyring_id_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2818 ALTER TABLE ONLY keyring_acl_map
2819 ADD CONSTRAINT keyring_acl_map_keyring_id_key UNIQUE (keyring_id, architecture_id);
2823 -- Name: keyring_acl_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2826 ALTER TABLE ONLY keyring_acl_map
2827 ADD CONSTRAINT keyring_acl_map_pkey PRIMARY KEY (id);
2831 -- Name: keyrings_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2834 ALTER TABLE ONLY keyrings
2835 ADD CONSTRAINT keyrings_name_key UNIQUE (name);
2839 -- Name: keyrings_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2842 ALTER TABLE ONLY keyrings
2843 ADD CONSTRAINT keyrings_pkey PRIMARY KEY (id);
2847 -- Name: known_changes_changesname_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2850 ALTER TABLE ONLY changes
2851 ADD CONSTRAINT known_changes_changesname_key UNIQUE (changesname);
2855 -- Name: known_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2858 ALTER TABLE ONLY changes
2859 ADD CONSTRAINT known_changes_pkey PRIMARY KEY (id);
2863 -- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2866 ALTER TABLE ONLY location
2867 ADD CONSTRAINT location_pkey PRIMARY KEY (id);
2871 -- Name: maintainer_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2874 ALTER TABLE ONLY maintainer
2875 ADD CONSTRAINT maintainer_pkey PRIMARY KEY (id);
2879 -- Name: metadata_keys_key_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2882 ALTER TABLE ONLY metadata_keys
2883 ADD CONSTRAINT metadata_keys_key_key UNIQUE (key);
2887 -- Name: metadata_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2890 ALTER TABLE ONLY metadata_keys
2891 ADD CONSTRAINT metadata_keys_pkey PRIMARY KEY (key_id);
2895 -- Name: new_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2898 ALTER TABLE ONLY new_comments
2899 ADD CONSTRAINT new_comments_pkey PRIMARY KEY (id);
2903 -- Name: override_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2906 ALTER TABLE ONLY override
2907 ADD CONSTRAINT override_pkey PRIMARY KEY (suite, component, package, type);
2911 -- Name: override_type_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2914 ALTER TABLE ONLY override_type
2915 ADD CONSTRAINT override_type_pkey PRIMARY KEY (id);
2919 -- Name: policy_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2922 ALTER TABLE ONLY policy_queue
2923 ADD CONSTRAINT policy_queue_pkey PRIMARY KEY (id);
2927 -- Name: policy_queue_queue_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2930 ALTER TABLE ONLY policy_queue
2931 ADD CONSTRAINT policy_queue_queue_name_key UNIQUE (queue_name);
2935 -- Name: priority_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2938 ALTER TABLE ONLY priority
2939 ADD CONSTRAINT priority_pkey PRIMARY KEY (id);
2943 -- Name: queue_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2946 ALTER TABLE ONLY build_queue_files
2947 ADD CONSTRAINT queue_files_pkey PRIMARY KEY (id);
2951 -- Name: section_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2954 ALTER TABLE ONLY section
2955 ADD CONSTRAINT section_pkey PRIMARY KEY (id);
2959 -- Name: source_acl_access_level_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2962 ALTER TABLE ONLY source_acl
2963 ADD CONSTRAINT source_acl_access_level_key UNIQUE (access_level);
2967 -- Name: source_acl_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2970 ALTER TABLE ONLY source_acl
2971 ADD CONSTRAINT source_acl_pkey PRIMARY KEY (id);
2975 -- Name: source_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2978 ALTER TABLE ONLY source_metadata
2979 ADD CONSTRAINT source_metadata_pkey PRIMARY KEY (src_id, key_id);
2983 -- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2986 ALTER TABLE ONLY source
2987 ADD CONSTRAINT source_pkey PRIMARY KEY (id);
2991 -- Name: src_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2994 ALTER TABLE ONLY src_associations
2995 ADD CONSTRAINT src_associations_pkey PRIMARY KEY (id);
2999 -- Name: src_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3002 ALTER TABLE ONLY src_contents
3003 ADD CONSTRAINT src_contents_pkey PRIMARY KEY (file, source_id);
3007 -- Name: src_format_format_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3010 ALTER TABLE ONLY src_format
3011 ADD CONSTRAINT src_format_format_name_key UNIQUE (format_name);
3015 -- Name: src_format_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3018 ALTER TABLE ONLY src_format
3019 ADD CONSTRAINT src_format_pkey PRIMARY KEY (id);
3023 -- Name: src_uploaders_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3026 ALTER TABLE ONLY src_uploaders
3027 ADD CONSTRAINT src_uploaders_pkey PRIMARY KEY (id);
3031 -- Name: src_uploaders_source_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3034 ALTER TABLE ONLY src_uploaders
3035 ADD CONSTRAINT src_uploaders_source_key UNIQUE (source, maintainer);
3039 -- Name: suite_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3042 ALTER TABLE ONLY suite_architectures
3043 ADD CONSTRAINT suite_architectures_pkey PRIMARY KEY (suite, architecture);
3047 -- Name: suite_name_unique; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3050 ALTER TABLE ONLY suite
3051 ADD CONSTRAINT suite_name_unique UNIQUE (suite_name);
3055 -- Name: suite_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3058 ALTER TABLE ONLY suite
3059 ADD CONSTRAINT suite_pkey PRIMARY KEY (id);
3063 -- Name: suite_queue_copy_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3066 ALTER TABLE ONLY suite_build_queue_copy
3067 ADD CONSTRAINT suite_queue_copy_pkey PRIMARY KEY (suite, build_queue_id);
3071 -- Name: suite_src_formats_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3074 ALTER TABLE ONLY suite_src_formats
3075 ADD CONSTRAINT suite_src_formats_pkey PRIMARY KEY (suite, src_format);
3079 -- Name: suite_src_formats_suite_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3082 ALTER TABLE ONLY suite_src_formats
3083 ADD CONSTRAINT suite_src_formats_suite_key UNIQUE (suite, src_format);
3087 -- Name: uid_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3090 ALTER TABLE ONLY uid
3091 ADD CONSTRAINT uid_pkey PRIMARY KEY (id);
3095 -- Name: upload_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3098 ALTER TABLE ONLY upload_blocks
3099 ADD CONSTRAINT upload_blocks_pkey PRIMARY KEY (id);
3103 -- Name: version_check_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3106 ALTER TABLE ONLY version_check
3107 ADD CONSTRAINT version_check_pkey PRIMARY KEY (suite, "check", reference);
3111 -- Name: architecture_arch_string_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3114 CREATE UNIQUE INDEX architecture_arch_string_key ON architecture USING btree (arch_string);
3118 -- Name: archive_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3121 CREATE UNIQUE INDEX archive_name_key ON archive USING btree (name);
3125 -- Name: bin_associations_bin; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3128 CREATE INDEX bin_associations_bin ON bin_associations USING btree (bin);
3132 -- Name: bin_associations_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3135 CREATE UNIQUE INDEX bin_associations_suite_key ON bin_associations USING btree (suite, bin);
3139 -- Name: binaries_architecture_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3142 CREATE INDEX binaries_architecture_idx ON binaries USING btree (architecture);
3146 -- Name: binaries_by_package; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3149 CREATE INDEX binaries_by_package ON binaries USING btree (id, package);
3153 -- Name: binaries_file_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3156 CREATE UNIQUE INDEX binaries_file_key ON binaries USING btree (file);
3160 -- Name: binaries_files; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3163 CREATE INDEX binaries_files ON binaries USING btree (file);
3167 -- Name: binaries_fingerprint; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3170 CREATE INDEX binaries_fingerprint ON binaries USING btree (sig_fpr);
3174 -- Name: binaries_id; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3177 CREATE UNIQUE INDEX binaries_id ON binaries USING btree (id);
3181 -- Name: binaries_maintainer; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3184 CREATE INDEX binaries_maintainer ON binaries USING btree (maintainer);
3188 -- Name: binaries_package_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3191 CREATE UNIQUE INDEX binaries_package_key ON binaries USING btree (package, version, architecture);
3195 -- Name: changesapproved_for; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3198 CREATE INDEX changesapproved_for ON changes USING btree (approved_for);
3202 -- Name: changesdistribution_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3205 CREATE INDEX changesdistribution_ind ON changes USING btree (distribution);
3209 -- Name: changesin_queue; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3212 CREATE INDEX changesin_queue ON changes USING btree (in_queue);
3216 -- Name: changesin_queue_approved_for; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3219 CREATE INDEX changesin_queue_approved_for ON changes USING btree (in_queue, approved_for);
3223 -- Name: changesname_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3226 CREATE INDEX changesname_ind ON changes USING btree (changesname);
3230 -- Name: changessource_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3233 CREATE INDEX changessource_ind ON changes USING btree (source);
3237 -- Name: changestimestamp_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3240 CREATE INDEX changestimestamp_ind ON changes USING btree (seen);
3244 -- Name: changesurgency_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3247 CREATE INDEX changesurgency_ind ON changes USING btree (urgency);
3251 -- Name: component_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3254 CREATE UNIQUE INDEX component_name_key ON component USING btree (name);
3258 -- Name: dsc_files_file; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3261 CREATE INDEX dsc_files_file ON dsc_files USING btree (file);
3265 -- Name: dsc_files_source_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3268 CREATE UNIQUE INDEX dsc_files_source_key ON dsc_files USING btree (source, file);
3272 -- Name: files_filename_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3275 CREATE UNIQUE INDEX files_filename_key ON files USING btree (filename, location);
3279 -- Name: files_last_used; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3282 CREATE INDEX files_last_used ON files USING btree (last_used);
3286 -- Name: fingerprint_fingerprint_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3289 CREATE UNIQUE INDEX fingerprint_fingerprint_key ON fingerprint USING btree (fingerprint);
3293 -- Name: ind_bin_contents_binary; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3296 CREATE INDEX ind_bin_contents_binary ON bin_contents USING btree (binary_id);
3300 -- Name: jjt; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3303 CREATE INDEX jjt ON files USING btree (id);
3307 -- Name: jjt2; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3310 CREATE INDEX jjt2 ON files USING btree (location);
3314 -- Name: jjt3; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3317 CREATE INDEX jjt3 ON files USING btree (id, location);
3321 -- Name: jjt4; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3324 CREATE INDEX jjt4 ON binaries USING btree (source);
3328 -- Name: jjt5; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3331 CREATE INDEX jjt5 ON binaries USING btree (id, source);
3335 -- Name: jjt_override_type_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3338 CREATE INDEX jjt_override_type_idx ON override USING btree (type);
3342 -- Name: maintainer_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3345 CREATE UNIQUE INDEX maintainer_name_key ON maintainer USING btree (name);
3349 -- Name: override_by_package; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3352 CREATE INDEX override_by_package ON override USING btree (package);
3356 -- Name: override_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3359 CREATE UNIQUE INDEX override_suite_key ON override USING btree (suite, component, package, type);
3363 -- Name: override_type_type_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3366 CREATE UNIQUE INDEX override_type_type_key ON override_type USING btree (type);
3370 -- Name: priority_level_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3373 CREATE UNIQUE INDEX priority_level_key ON priority USING btree (level);
3377 -- Name: priority_priority_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3380 CREATE UNIQUE INDEX priority_priority_key ON priority USING btree (priority);
3384 -- Name: section_section_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3387 CREATE UNIQUE INDEX section_section_key ON section USING btree (section);
3391 -- Name: source_file_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3394 CREATE UNIQUE INDEX source_file_key ON source USING btree (file);
3398 -- Name: source_fingerprint; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3401 CREATE INDEX source_fingerprint ON source USING btree (sig_fpr);
3405 -- Name: source_maintainer; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3408 CREATE INDEX source_maintainer ON source USING btree (maintainer);
3412 -- Name: source_source_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3415 CREATE UNIQUE INDEX source_source_key ON source USING btree (source, version);
3419 -- Name: src_associations_source; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3422 CREATE INDEX src_associations_source ON src_associations USING btree (source);
3426 -- Name: src_associations_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3429 CREATE UNIQUE INDEX src_associations_suite_key ON src_associations USING btree (suite, source);
3433 -- Name: src_contents_source_id_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3436 CREATE INDEX src_contents_source_id_idx ON src_contents USING btree (source_id);
3440 -- Name: suite_architectures_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3443 CREATE UNIQUE INDEX suite_architectures_suite_key ON suite_architectures USING btree (suite, architecture);
3447 -- Name: suite_hash; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3450 CREATE INDEX suite_hash ON suite USING hash (suite_name);
3454 -- Name: uid_uid_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3457 CREATE UNIQUE INDEX uid_uid_key ON uid USING btree (uid);
3461 -- Name: modified_architecture; Type: TRIGGER; Schema: public; Owner: dak
3464 CREATE TRIGGER modified_architecture BEFORE UPDATE ON architecture FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3468 -- Name: modified_archive; Type: TRIGGER; Schema: public; Owner: dak
3471 CREATE TRIGGER modified_archive BEFORE UPDATE ON archive FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3475 -- Name: modified_bin_associations; Type: TRIGGER; Schema: public; Owner: dak
3478 CREATE TRIGGER modified_bin_associations BEFORE UPDATE ON bin_associations FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3482 -- Name: modified_bin_contents; Type: TRIGGER; Schema: public; Owner: dak
3485 CREATE TRIGGER modified_bin_contents BEFORE UPDATE ON bin_contents FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3489 -- Name: modified_binaries; Type: TRIGGER; Schema: public; Owner: dak
3492 CREATE TRIGGER modified_binaries BEFORE UPDATE ON binaries FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3496 -- Name: modified_binary_acl; Type: TRIGGER; Schema: public; Owner: dak
3499 CREATE TRIGGER modified_binary_acl BEFORE UPDATE ON binary_acl FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3503 -- Name: modified_binary_acl_map; Type: TRIGGER; Schema: public; Owner: dak
3506 CREATE TRIGGER modified_binary_acl_map BEFORE UPDATE ON binary_acl_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3510 -- Name: modified_build_queue; Type: TRIGGER; Schema: public; Owner: dak
3513 CREATE TRIGGER modified_build_queue BEFORE UPDATE ON build_queue FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3517 -- Name: modified_build_queue_files; Type: TRIGGER; Schema: public; Owner: dak
3520 CREATE TRIGGER modified_build_queue_files BEFORE UPDATE ON build_queue_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3524 -- Name: modified_changes; Type: TRIGGER; Schema: public; Owner: dak
3527 CREATE TRIGGER modified_changes BEFORE UPDATE ON changes FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3531 -- Name: modified_changes_pending_binaries; Type: TRIGGER; Schema: public; Owner: dak
3534 CREATE TRIGGER modified_changes_pending_binaries BEFORE UPDATE ON changes_pending_binaries FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3538 -- Name: modified_changes_pending_files; Type: TRIGGER; Schema: public; Owner: dak
3541 CREATE TRIGGER modified_changes_pending_files BEFORE UPDATE ON changes_pending_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3545 -- Name: modified_changes_pending_files_map; Type: TRIGGER; Schema: public; Owner: dak
3548 CREATE TRIGGER modified_changes_pending_files_map BEFORE UPDATE ON changes_pending_files_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3552 -- Name: modified_changes_pending_source; Type: TRIGGER; Schema: public; Owner: dak
3555 CREATE TRIGGER modified_changes_pending_source BEFORE UPDATE ON changes_pending_source FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3559 -- Name: modified_changes_pending_source_files; Type: TRIGGER; Schema: public; Owner: dak
3562 CREATE TRIGGER modified_changes_pending_source_files BEFORE UPDATE ON changes_pending_source_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3566 -- Name: modified_changes_pool_files; Type: TRIGGER; Schema: public; Owner: dak
3569 CREATE TRIGGER modified_changes_pool_files BEFORE UPDATE ON changes_pool_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3573 -- Name: modified_component; Type: TRIGGER; Schema: public; Owner: dak
3576 CREATE TRIGGER modified_component BEFORE UPDATE ON component FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3580 -- Name: modified_config; Type: TRIGGER; Schema: public; Owner: dak
3583 CREATE TRIGGER modified_config BEFORE UPDATE ON config FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3587 -- Name: modified_dsc_files; Type: TRIGGER; Schema: public; Owner: dak
3590 CREATE TRIGGER modified_dsc_files BEFORE UPDATE ON dsc_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3594 -- Name: modified_files; Type: TRIGGER; Schema: public; Owner: dak
3597 CREATE TRIGGER modified_files BEFORE UPDATE ON files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3601 -- Name: modified_fingerprint; Type: TRIGGER; Schema: public; Owner: dak
3604 CREATE TRIGGER modified_fingerprint BEFORE UPDATE ON fingerprint FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3608 -- Name: modified_keyring_acl_map; Type: TRIGGER; Schema: public; Owner: dak
3611 CREATE TRIGGER modified_keyring_acl_map BEFORE UPDATE ON keyring_acl_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3615 -- Name: modified_keyrings; Type: TRIGGER; Schema: public; Owner: dak
3618 CREATE TRIGGER modified_keyrings BEFORE UPDATE ON keyrings FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3622 -- Name: modified_location; Type: TRIGGER; Schema: public; Owner: dak
3625 CREATE TRIGGER modified_location BEFORE UPDATE ON location FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3629 -- Name: modified_maintainer; Type: TRIGGER; Schema: public; Owner: dak
3632 CREATE TRIGGER modified_maintainer BEFORE UPDATE ON maintainer FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3636 -- Name: modified_new_comments; Type: TRIGGER; Schema: public; Owner: dak
3639 CREATE TRIGGER modified_new_comments BEFORE UPDATE ON new_comments FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3643 -- Name: modified_override; Type: TRIGGER; Schema: public; Owner: dak
3646 CREATE TRIGGER modified_override BEFORE UPDATE ON override FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3650 -- Name: modified_override_type; Type: TRIGGER; Schema: public; Owner: dak
3653 CREATE TRIGGER modified_override_type BEFORE UPDATE ON override_type FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3657 -- Name: modified_policy_queue; Type: TRIGGER; Schema: public; Owner: dak
3660 CREATE TRIGGER modified_policy_queue BEFORE UPDATE ON policy_queue FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3664 -- Name: modified_priority; Type: TRIGGER; Schema: public; Owner: dak
3667 CREATE TRIGGER modified_priority BEFORE UPDATE ON priority FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3671 -- Name: modified_section; Type: TRIGGER; Schema: public; Owner: dak
3674 CREATE TRIGGER modified_section BEFORE UPDATE ON section FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3678 -- Name: modified_source; Type: TRIGGER; Schema: public; Owner: dak
3681 CREATE TRIGGER modified_source BEFORE UPDATE ON source FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3685 -- Name: modified_source_acl; Type: TRIGGER; Schema: public; Owner: dak
3688 CREATE TRIGGER modified_source_acl BEFORE UPDATE ON source_acl FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3692 -- Name: modified_src_associations; Type: TRIGGER; Schema: public; Owner: dak
3695 CREATE TRIGGER modified_src_associations BEFORE UPDATE ON src_associations FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3699 -- Name: modified_src_contents; Type: TRIGGER; Schema: public; Owner: dak
3702 CREATE TRIGGER modified_src_contents BEFORE UPDATE ON src_contents FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3706 -- Name: modified_src_format; Type: TRIGGER; Schema: public; Owner: dak
3709 CREATE TRIGGER modified_src_format BEFORE UPDATE ON src_format FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3713 -- Name: modified_src_uploaders; Type: TRIGGER; Schema: public; Owner: dak
3716 CREATE TRIGGER modified_src_uploaders BEFORE UPDATE ON src_uploaders FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3720 -- Name: modified_suite; Type: TRIGGER; Schema: public; Owner: dak
3723 CREATE TRIGGER modified_suite BEFORE UPDATE ON suite FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3727 -- Name: modified_suite_architectures; Type: TRIGGER; Schema: public; Owner: dak
3730 CREATE TRIGGER modified_suite_architectures BEFORE UPDATE ON suite_architectures FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3734 -- Name: modified_suite_build_queue_copy; Type: TRIGGER; Schema: public; Owner: dak
3737 CREATE TRIGGER modified_suite_build_queue_copy BEFORE UPDATE ON suite_build_queue_copy FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3741 -- Name: modified_suite_src_formats; Type: TRIGGER; Schema: public; Owner: dak
3744 CREATE TRIGGER modified_suite_src_formats BEFORE UPDATE ON suite_src_formats FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3748 -- Name: modified_uid; Type: TRIGGER; Schema: public; Owner: dak
3751 CREATE TRIGGER modified_uid BEFORE UPDATE ON uid FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3755 -- Name: modified_upload_blocks; Type: TRIGGER; Schema: public; Owner: dak
3758 CREATE TRIGGER modified_upload_blocks BEFORE UPDATE ON upload_blocks FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3762 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: dak
3765 ALTER TABLE ONLY fingerprint
3766 ADD CONSTRAINT "$1" FOREIGN KEY (keyring) REFERENCES keyrings(id);
3770 -- Name: bin_associations_bin; Type: FK CONSTRAINT; Schema: public; Owner: dak
3773 ALTER TABLE ONLY bin_associations
3774 ADD CONSTRAINT bin_associations_bin FOREIGN KEY (bin) REFERENCES binaries(id) MATCH FULL;
3778 -- Name: bin_associations_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
3781 ALTER TABLE ONLY bin_associations
3782 ADD CONSTRAINT bin_associations_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
3786 -- Name: bin_contents_bin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3789 ALTER TABLE ONLY bin_contents
3790 ADD CONSTRAINT bin_contents_bin_fkey FOREIGN KEY (binary_id) REFERENCES binaries(id) ON DELETE CASCADE;
3794 -- Name: binaries_architecture; Type: FK CONSTRAINT; Schema: public; Owner: dak
3797 ALTER TABLE ONLY binaries
3798 ADD CONSTRAINT binaries_architecture FOREIGN KEY (architecture) REFERENCES architecture(id) MATCH FULL;
3802 -- Name: binaries_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
3805 ALTER TABLE ONLY binaries
3806 ADD CONSTRAINT binaries_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
3810 -- Name: binaries_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
3813 ALTER TABLE ONLY binaries
3814 ADD CONSTRAINT binaries_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
3818 -- Name: binaries_metadata_bin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3821 ALTER TABLE ONLY binaries_metadata
3822 ADD CONSTRAINT binaries_metadata_bin_id_fkey FOREIGN KEY (bin_id) REFERENCES binaries(id) ON DELETE CASCADE;
3826 -- Name: binaries_metadata_key_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3829 ALTER TABLE ONLY binaries_metadata
3830 ADD CONSTRAINT binaries_metadata_key_id_fkey FOREIGN KEY (key_id) REFERENCES metadata_keys(key_id);
3834 -- Name: binaries_sig_fpr; Type: FK CONSTRAINT; Schema: public; Owner: dak
3837 ALTER TABLE ONLY binaries
3838 ADD CONSTRAINT binaries_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
3842 -- Name: binaries_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
3845 ALTER TABLE ONLY binaries
3846 ADD CONSTRAINT binaries_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
3850 -- Name: binary_acl_map_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3853 ALTER TABLE ONLY binary_acl_map
3854 ADD CONSTRAINT binary_acl_map_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
3858 -- Name: binary_acl_map_fingerprint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3861 ALTER TABLE ONLY binary_acl_map
3862 ADD CONSTRAINT binary_acl_map_fingerprint_id_fkey FOREIGN KEY (fingerprint_id) REFERENCES fingerprint(id);
3866 -- Name: build_queue_files_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3869 ALTER TABLE ONLY build_queue_files
3870 ADD CONSTRAINT build_queue_files_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE CASCADE;
3874 -- Name: build_queue_policy_files_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3877 ALTER TABLE ONLY build_queue_policy_files
3878 ADD CONSTRAINT build_queue_policy_files_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE CASCADE;
3882 -- Name: build_queue_policy_files_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3885 ALTER TABLE ONLY build_queue_policy_files
3886 ADD CONSTRAINT build_queue_policy_files_file_id_fkey FOREIGN KEY (file_id) REFERENCES changes_pending_files(id) ON DELETE CASCADE;
3890 -- Name: changes_pending_binaries_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3893 ALTER TABLE ONLY changes_pending_binaries
3894 ADD CONSTRAINT changes_pending_binaries_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
3898 -- Name: changes_pending_binaries_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3901 ALTER TABLE ONLY changes_pending_binaries
3902 ADD CONSTRAINT changes_pending_binaries_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3906 -- Name: changes_pending_binaries_pending_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3909 ALTER TABLE ONLY changes_pending_binaries
3910 ADD CONSTRAINT changes_pending_binaries_pending_file_id_fkey FOREIGN KEY (pending_file_id) REFERENCES changes_pending_files(id);
3914 -- Name: changes_pending_binaries_pending_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3917 ALTER TABLE ONLY changes_pending_binaries
3918 ADD CONSTRAINT changes_pending_binaries_pending_source_id_fkey FOREIGN KEY (pending_source_id) REFERENCES changes_pending_source(id);
3922 -- Name: changes_pending_binaries_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3925 ALTER TABLE ONLY changes_pending_binaries
3926 ADD CONSTRAINT changes_pending_binaries_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(id);
3930 -- Name: changes_pending_files_map_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3933 ALTER TABLE ONLY changes_pending_files_map
3934 ADD CONSTRAINT changes_pending_files_map_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3938 -- Name: changes_pending_files_map_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3941 ALTER TABLE ONLY changes_pending_files_map
3942 ADD CONSTRAINT changes_pending_files_map_file_id_fkey FOREIGN KEY (file_id) REFERENCES changes_pending_files(id);
3946 -- Name: changes_pending_source_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3949 ALTER TABLE ONLY changes_pending_source
3950 ADD CONSTRAINT changes_pending_source_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3954 -- Name: changes_pending_source_changedby_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3957 ALTER TABLE ONLY changes_pending_source
3958 ADD CONSTRAINT changes_pending_source_changedby_id_fkey FOREIGN KEY (changedby_id) REFERENCES maintainer(id);
3962 -- Name: changes_pending_source_files_pending_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3965 ALTER TABLE ONLY changes_pending_source_files
3966 ADD CONSTRAINT changes_pending_source_files_pending_file_id_fkey FOREIGN KEY (pending_file_id) REFERENCES changes_pending_files(id);
3970 -- Name: changes_pending_source_files_pending_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3973 ALTER TABLE ONLY changes_pending_source_files
3974 ADD CONSTRAINT changes_pending_source_files_pending_source_id_fkey FOREIGN KEY (pending_source_id) REFERENCES changes_pending_source(id);
3978 -- Name: changes_pending_source_maintainer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3981 ALTER TABLE ONLY changes_pending_source
3982 ADD CONSTRAINT changes_pending_source_maintainer_id_fkey FOREIGN KEY (maintainer_id) REFERENCES maintainer(id);
3986 -- Name: changes_pending_source_sig_fpr_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3989 ALTER TABLE ONLY changes_pending_source
3990 ADD CONSTRAINT changes_pending_source_sig_fpr_fkey FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id);
3994 -- Name: changes_pool_files_changeid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3997 ALTER TABLE ONLY changes_pool_files
3998 ADD CONSTRAINT changes_pool_files_changeid_fkey FOREIGN KEY (changeid) REFERENCES changes(id) ON DELETE CASCADE;
4002 -- Name: changes_pool_files_fileid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4005 ALTER TABLE ONLY changes_pool_files
4006 ADD CONSTRAINT changes_pool_files_fileid_fkey FOREIGN KEY (fileid) REFERENCES files(id) ON DELETE RESTRICT;
4010 -- Name: dsc_files_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
4013 ALTER TABLE ONLY dsc_files
4014 ADD CONSTRAINT dsc_files_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
4018 -- Name: dsc_files_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4021 ALTER TABLE ONLY dsc_files
4022 ADD CONSTRAINT dsc_files_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
4026 -- Name: external_overrides_component_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4029 ALTER TABLE ONLY external_overrides
4030 ADD CONSTRAINT external_overrides_component_fkey FOREIGN KEY (component) REFERENCES component(id);
4034 -- Name: external_overrides_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4037 ALTER TABLE ONLY external_overrides
4038 ADD CONSTRAINT external_overrides_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4042 -- Name: extra_src_references_bin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4045 ALTER TABLE ONLY extra_src_references
4046 ADD CONSTRAINT extra_src_references_bin_id_fkey FOREIGN KEY (bin_id) REFERENCES binaries(id) ON DELETE CASCADE;
4050 -- Name: extra_src_references_src_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4053 ALTER TABLE ONLY extra_src_references
4054 ADD CONSTRAINT extra_src_references_src_id_fkey FOREIGN KEY (src_id) REFERENCES source(id) ON DELETE RESTRICT;
4058 -- Name: files_location; Type: FK CONSTRAINT; Schema: public; Owner: dak
4061 ALTER TABLE ONLY files
4062 ADD CONSTRAINT files_location FOREIGN KEY (location) REFERENCES location(id) MATCH FULL;
4066 -- Name: fingerprint_binary_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4069 ALTER TABLE ONLY fingerprint
4070 ADD CONSTRAINT fingerprint_binary_acl_id_fkey FOREIGN KEY (binary_acl_id) REFERENCES binary_acl(id);
4074 -- Name: fingerprint_source_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4077 ALTER TABLE ONLY fingerprint
4078 ADD CONSTRAINT fingerprint_source_acl_id_fkey FOREIGN KEY (source_acl_id) REFERENCES source_acl(id);
4082 -- Name: fingerprint_uid; Type: FK CONSTRAINT; Schema: public; Owner: dak
4085 ALTER TABLE ONLY fingerprint
4086 ADD CONSTRAINT fingerprint_uid FOREIGN KEY (uid) REFERENCES uid(id) MATCH FULL;
4090 -- Name: keyring_acl_map_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4093 ALTER TABLE ONLY keyring_acl_map
4094 ADD CONSTRAINT keyring_acl_map_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
4098 -- Name: keyring_acl_map_keyring_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4101 ALTER TABLE ONLY keyring_acl_map
4102 ADD CONSTRAINT keyring_acl_map_keyring_id_fkey FOREIGN KEY (keyring_id) REFERENCES keyrings(id);
4106 -- Name: keyrings_default_binary_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4109 ALTER TABLE ONLY keyrings
4110 ADD CONSTRAINT keyrings_default_binary_acl_id_fkey FOREIGN KEY (default_binary_acl_id) REFERENCES binary_acl(id);
4114 -- Name: keyrings_default_source_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4117 ALTER TABLE ONLY keyrings
4118 ADD CONSTRAINT keyrings_default_source_acl_id_fkey FOREIGN KEY (default_source_acl_id) REFERENCES source_acl(id);
4122 -- Name: known_changes_approved_for_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4125 ALTER TABLE ONLY changes
4126 ADD CONSTRAINT known_changes_approved_for_fkey FOREIGN KEY (in_queue) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4130 -- Name: known_changes_in_queue_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4133 ALTER TABLE ONLY changes
4134 ADD CONSTRAINT known_changes_in_queue_fkey FOREIGN KEY (in_queue) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4138 -- Name: location_archive_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4141 ALTER TABLE ONLY location
4142 ADD CONSTRAINT location_archive_fkey FOREIGN KEY (archive) REFERENCES archive(id);
4146 -- Name: location_component_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4149 ALTER TABLE ONLY location
4150 ADD CONSTRAINT location_component_fkey FOREIGN KEY (component) REFERENCES component(id);
4154 -- Name: override_component; Type: FK CONSTRAINT; Schema: public; Owner: dak
4157 ALTER TABLE ONLY override
4158 ADD CONSTRAINT override_component FOREIGN KEY (component) REFERENCES component(id) MATCH FULL;
4162 -- Name: override_priority; Type: FK CONSTRAINT; Schema: public; Owner: dak
4165 ALTER TABLE ONLY override
4166 ADD CONSTRAINT override_priority FOREIGN KEY (priority) REFERENCES priority(id) MATCH FULL;
4170 -- Name: override_section; Type: FK CONSTRAINT; Schema: public; Owner: dak
4173 ALTER TABLE ONLY override
4174 ADD CONSTRAINT override_section FOREIGN KEY (section) REFERENCES section(id) MATCH FULL;
4178 -- Name: override_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4181 ALTER TABLE ONLY override
4182 ADD CONSTRAINT override_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4186 -- Name: override_type; Type: FK CONSTRAINT; Schema: public; Owner: dak
4189 ALTER TABLE ONLY override
4190 ADD CONSTRAINT override_type FOREIGN KEY (type) REFERENCES override_type(id) MATCH FULL;
4194 -- Name: queue_files_fileid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4197 ALTER TABLE ONLY build_queue_files
4198 ADD CONSTRAINT queue_files_fileid_fkey FOREIGN KEY (fileid) REFERENCES files(id) ON DELETE CASCADE;
4202 -- Name: source_changedby; Type: FK CONSTRAINT; Schema: public; Owner: dak
4205 ALTER TABLE ONLY source
4206 ADD CONSTRAINT source_changedby FOREIGN KEY (changedby) REFERENCES maintainer(id) MATCH FULL;
4210 -- Name: source_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
4213 ALTER TABLE ONLY source
4214 ADD CONSTRAINT source_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
4218 -- Name: source_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
4221 ALTER TABLE ONLY source
4222 ADD CONSTRAINT source_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
4226 -- Name: source_metadata_key_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4229 ALTER TABLE ONLY source_metadata
4230 ADD CONSTRAINT source_metadata_key_id_fkey FOREIGN KEY (key_id) REFERENCES metadata_keys(key_id);
4234 -- Name: source_metadata_src_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4237 ALTER TABLE ONLY source_metadata
4238 ADD CONSTRAINT source_metadata_src_id_fkey FOREIGN KEY (src_id) REFERENCES source(id) ON DELETE CASCADE;
4242 -- Name: source_sig_fpr; Type: FK CONSTRAINT; Schema: public; Owner: dak
4245 ALTER TABLE ONLY source
4246 ADD CONSTRAINT source_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
4250 -- Name: src_associations_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4253 ALTER TABLE ONLY src_associations
4254 ADD CONSTRAINT src_associations_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
4258 -- Name: src_associations_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4261 ALTER TABLE ONLY src_associations
4262 ADD CONSTRAINT src_associations_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4266 -- Name: src_contents_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4269 ALTER TABLE ONLY src_contents
4270 ADD CONSTRAINT src_contents_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(id) ON DELETE CASCADE;
4274 -- Name: src_format_key; Type: FK CONSTRAINT; Schema: public; Owner: dak
4277 ALTER TABLE ONLY suite_src_formats
4278 ADD CONSTRAINT src_format_key FOREIGN KEY (src_format) REFERENCES src_format(id);
4282 -- Name: src_uploaders_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
4285 ALTER TABLE ONLY src_uploaders
4286 ADD CONSTRAINT src_uploaders_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) ON DELETE CASCADE;
4290 -- Name: src_uploaders_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4293 ALTER TABLE ONLY src_uploaders
4294 ADD CONSTRAINT src_uploaders_source FOREIGN KEY (source) REFERENCES source(id) ON DELETE CASCADE;
4298 -- Name: suite_architectures_architectur; Type: FK CONSTRAINT; Schema: public; Owner: dak
4301 ALTER TABLE ONLY suite_architectures
4302 ADD CONSTRAINT suite_architectures_architectur FOREIGN KEY (architecture) REFERENCES architecture(id) MATCH FULL;
4306 -- Name: suite_architectures_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4309 ALTER TABLE ONLY suite_architectures
4310 ADD CONSTRAINT suite_architectures_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4314 -- Name: suite_build_queue_copy_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4317 ALTER TABLE ONLY suite_build_queue_copy
4318 ADD CONSTRAINT suite_build_queue_copy_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE RESTRICT;
4322 -- Name: suite_key; Type: FK CONSTRAINT; Schema: public; Owner: dak
4325 ALTER TABLE ONLY suite_src_formats
4326 ADD CONSTRAINT suite_key FOREIGN KEY (suite) REFERENCES suite(id);
4330 -- Name: suite_policy_queue_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4333 ALTER TABLE ONLY suite
4334 ADD CONSTRAINT suite_policy_queue_fkey FOREIGN KEY (policy_queue_id) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4338 -- Name: suite_queue_copy_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4341 ALTER TABLE ONLY suite_build_queue_copy
4342 ADD CONSTRAINT suite_queue_copy_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4346 -- Name: upload_blocks_fingerprint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4349 ALTER TABLE ONLY upload_blocks
4350 ADD CONSTRAINT upload_blocks_fingerprint_id_fkey FOREIGN KEY (fingerprint_id) REFERENCES fingerprint(id);
4354 -- Name: upload_blocks_uid_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4357 ALTER TABLE ONLY upload_blocks
4358 ADD CONSTRAINT upload_blocks_uid_id_fkey FOREIGN KEY (uid_id) REFERENCES uid(id);
4362 -- Name: version_check_reference_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4365 ALTER TABLE ONLY version_check
4366 ADD CONSTRAINT version_check_reference_fkey FOREIGN KEY (reference) REFERENCES suite(id);
4370 -- Name: version_check_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4373 ALTER TABLE ONLY version_check
4374 ADD CONSTRAINT version_check_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4378 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4381 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4382 REVOKE ALL ON SCHEMA public FROM postgres;
4383 GRANT ALL ON SCHEMA public TO postgres;
4384 GRANT ALL ON SCHEMA public TO PUBLIC;
4388 -- Name: bin_associations_id_seq; Type: ACL; Schema: public; Owner: dak
4391 REVOKE ALL ON SEQUENCE bin_associations_id_seq FROM PUBLIC;
4392 REVOKE ALL ON SEQUENCE bin_associations_id_seq FROM dak;
4393 GRANT ALL ON SEQUENCE bin_associations_id_seq TO dak;
4394 GRANT SELECT ON SEQUENCE bin_associations_id_seq TO PUBLIC;
4395 GRANT ALL ON SEQUENCE bin_associations_id_seq TO ftpmaster;
4399 -- Name: bin_associations; Type: ACL; Schema: public; Owner: dak
4402 REVOKE ALL ON TABLE bin_associations FROM PUBLIC;
4403 REVOKE ALL ON TABLE bin_associations FROM dak;
4404 GRANT ALL ON TABLE bin_associations TO dak;
4405 GRANT SELECT ON TABLE bin_associations TO PUBLIC;
4406 GRANT ALL ON TABLE bin_associations TO ftpmaster;
4407 GRANT DELETE ON TABLE bin_associations TO ftpteam;
4411 -- Name: binaries_id_seq; Type: ACL; Schema: public; Owner: dak
4414 REVOKE ALL ON SEQUENCE binaries_id_seq FROM PUBLIC;
4415 REVOKE ALL ON SEQUENCE binaries_id_seq FROM dak;
4416 GRANT ALL ON SEQUENCE binaries_id_seq TO dak;
4417 GRANT SELECT ON SEQUENCE binaries_id_seq TO PUBLIC;
4418 GRANT ALL ON SEQUENCE binaries_id_seq TO ftpmaster;
4422 -- Name: binaries; Type: ACL; Schema: public; Owner: dak
4425 REVOKE ALL ON TABLE binaries FROM PUBLIC;
4426 REVOKE ALL ON TABLE binaries FROM dak;
4427 GRANT ALL ON TABLE binaries TO dak;
4428 GRANT SELECT ON TABLE binaries TO PUBLIC;
4429 GRANT ALL ON TABLE binaries TO ftpmaster;
4433 -- Name: bin_associations_binaries; Type: ACL; Schema: public; Owner: dak
4436 REVOKE ALL ON TABLE bin_associations_binaries FROM PUBLIC;
4437 REVOKE ALL ON TABLE bin_associations_binaries FROM dak;
4438 GRANT ALL ON TABLE bin_associations_binaries TO dak;
4439 GRANT SELECT ON TABLE bin_associations_binaries TO ftpmaster;
4440 GRANT SELECT ON TABLE bin_associations_binaries TO PUBLIC;
4444 -- Name: source_id_seq; Type: ACL; Schema: public; Owner: dak
4447 REVOKE ALL ON SEQUENCE source_id_seq FROM PUBLIC;
4448 REVOKE ALL ON SEQUENCE source_id_seq FROM dak;
4449 GRANT ALL ON SEQUENCE source_id_seq TO dak;
4450 GRANT SELECT ON SEQUENCE source_id_seq TO PUBLIC;
4451 GRANT ALL ON SEQUENCE source_id_seq TO ftpmaster;
4455 -- Name: source; Type: ACL; Schema: public; Owner: dak
4458 REVOKE ALL ON TABLE source FROM PUBLIC;
4459 REVOKE ALL ON TABLE source FROM dak;
4460 GRANT ALL ON TABLE source TO dak;
4461 GRANT SELECT ON TABLE source TO PUBLIC;
4462 GRANT ALL ON TABLE source TO ftpmaster;
4466 -- Name: src_associations_id_seq; Type: ACL; Schema: public; Owner: dak
4469 REVOKE ALL ON SEQUENCE src_associations_id_seq FROM PUBLIC;
4470 REVOKE ALL ON SEQUENCE src_associations_id_seq FROM dak;
4471 GRANT ALL ON SEQUENCE src_associations_id_seq TO dak;
4472 GRANT SELECT ON SEQUENCE src_associations_id_seq TO PUBLIC;
4473 GRANT ALL ON SEQUENCE src_associations_id_seq TO ftpmaster;
4477 -- Name: src_associations; Type: ACL; Schema: public; Owner: dak
4480 REVOKE ALL ON TABLE src_associations FROM PUBLIC;
4481 REVOKE ALL ON TABLE src_associations FROM dak;
4482 GRANT ALL ON TABLE src_associations TO dak;
4483 GRANT SELECT ON TABLE src_associations TO PUBLIC;
4484 GRANT ALL ON TABLE src_associations TO ftpmaster;
4485 GRANT DELETE ON TABLE src_associations TO ftpteam;
4489 -- Name: src_associations_bin; Type: ACL; Schema: public; Owner: dak
4492 REVOKE ALL ON TABLE src_associations_bin FROM PUBLIC;
4493 REVOKE ALL ON TABLE src_associations_bin FROM dak;
4494 GRANT ALL ON TABLE src_associations_bin TO dak;
4495 GRANT SELECT ON TABLE src_associations_bin TO ftpmaster;
4496 GRANT SELECT ON TABLE src_associations_bin TO PUBLIC;
4500 -- Name: almost_obsolete_all_associations; Type: ACL; Schema: public; Owner: dak
4503 REVOKE ALL ON TABLE almost_obsolete_all_associations FROM PUBLIC;
4504 REVOKE ALL ON TABLE almost_obsolete_all_associations FROM dak;
4505 GRANT ALL ON TABLE almost_obsolete_all_associations TO dak;
4506 GRANT SELECT ON TABLE almost_obsolete_all_associations TO ftpmaster;
4507 GRANT SELECT ON TABLE almost_obsolete_all_associations TO PUBLIC;
4511 -- Name: any_associations_source; Type: ACL; Schema: public; Owner: dak
4514 REVOKE ALL ON TABLE any_associations_source FROM PUBLIC;
4515 REVOKE ALL ON TABLE any_associations_source FROM dak;
4516 GRANT ALL ON TABLE any_associations_source TO dak;
4517 GRANT SELECT ON TABLE any_associations_source TO ftpmaster;
4518 GRANT SELECT ON TABLE any_associations_source TO PUBLIC;
4522 -- Name: src_associations_src; Type: ACL; Schema: public; Owner: dak
4525 REVOKE ALL ON TABLE src_associations_src FROM PUBLIC;
4526 REVOKE ALL ON TABLE src_associations_src FROM dak;
4527 GRANT ALL ON TABLE src_associations_src TO dak;
4528 GRANT SELECT ON TABLE src_associations_src TO ftpmaster;
4529 GRANT SELECT ON TABLE src_associations_src TO PUBLIC;
4533 -- Name: almost_obsolete_src_associations; Type: ACL; Schema: public; Owner: dak
4536 REVOKE ALL ON TABLE almost_obsolete_src_associations FROM PUBLIC;
4537 REVOKE ALL ON TABLE almost_obsolete_src_associations FROM dak;
4538 GRANT ALL ON TABLE almost_obsolete_src_associations TO dak;
4539 GRANT SELECT ON TABLE almost_obsolete_src_associations TO ftpmaster;
4540 GRANT SELECT ON TABLE almost_obsolete_src_associations TO PUBLIC;
4544 -- Name: architecture_id_seq; Type: ACL; Schema: public; Owner: dak
4547 REVOKE ALL ON SEQUENCE architecture_id_seq FROM PUBLIC;
4548 REVOKE ALL ON SEQUENCE architecture_id_seq FROM dak;
4549 GRANT ALL ON SEQUENCE architecture_id_seq TO dak;
4550 GRANT SELECT ON SEQUENCE architecture_id_seq TO PUBLIC;
4551 GRANT ALL ON SEQUENCE architecture_id_seq TO ftpmaster;
4555 -- Name: architecture; Type: ACL; Schema: public; Owner: dak
4558 REVOKE ALL ON TABLE architecture FROM PUBLIC;
4559 REVOKE ALL ON TABLE architecture FROM dak;
4560 GRANT ALL ON TABLE architecture TO dak;
4561 GRANT SELECT ON TABLE architecture TO PUBLIC;
4562 GRANT ALL ON TABLE architecture TO ftpmaster;
4566 -- Name: archive_id_seq; Type: ACL; Schema: public; Owner: dak
4569 REVOKE ALL ON SEQUENCE archive_id_seq FROM PUBLIC;
4570 REVOKE ALL ON SEQUENCE archive_id_seq FROM dak;
4571 GRANT ALL ON SEQUENCE archive_id_seq TO dak;
4572 GRANT SELECT ON SEQUENCE archive_id_seq TO PUBLIC;
4573 GRANT ALL ON SEQUENCE archive_id_seq TO ftpmaster;
4577 -- Name: archive; Type: ACL; Schema: public; Owner: dak
4580 REVOKE ALL ON TABLE archive FROM PUBLIC;
4581 REVOKE ALL ON TABLE archive FROM dak;
4582 GRANT ALL ON TABLE archive TO dak;
4583 GRANT SELECT ON TABLE archive TO PUBLIC;
4584 GRANT ALL ON TABLE archive TO ftpmaster;
4588 -- Name: bin_contents; Type: ACL; Schema: public; Owner: dak
4591 REVOKE ALL ON TABLE bin_contents FROM PUBLIC;
4592 REVOKE ALL ON TABLE bin_contents FROM dak;
4593 GRANT ALL ON TABLE bin_contents TO dak;
4594 GRANT SELECT ON TABLE bin_contents TO PUBLIC;
4595 GRANT ALL ON TABLE bin_contents TO ftpmaster;
4599 -- Name: binaries_metadata; Type: ACL; Schema: public; Owner: dak
4602 REVOKE ALL ON TABLE binaries_metadata FROM PUBLIC;
4603 REVOKE ALL ON TABLE binaries_metadata FROM dak;
4604 GRANT ALL ON TABLE binaries_metadata TO dak;
4605 GRANT SELECT,INSERT,UPDATE ON TABLE binaries_metadata TO ftpmaster;
4606 GRANT SELECT ON TABLE binaries_metadata TO PUBLIC;
4610 -- Name: suite_id_seq; Type: ACL; Schema: public; Owner: dak
4613 REVOKE ALL ON SEQUENCE suite_id_seq FROM PUBLIC;
4614 REVOKE ALL ON SEQUENCE suite_id_seq FROM dak;
4615 GRANT ALL ON SEQUENCE suite_id_seq TO dak;
4616 GRANT SELECT ON SEQUENCE suite_id_seq TO PUBLIC;
4617 GRANT ALL ON SEQUENCE suite_id_seq TO ftpmaster;
4621 -- Name: suite; Type: ACL; Schema: public; Owner: dak
4624 REVOKE ALL ON TABLE suite FROM PUBLIC;
4625 REVOKE ALL ON TABLE suite FROM dak;
4626 GRANT ALL ON TABLE suite TO dak;
4627 GRANT SELECT ON TABLE suite TO PUBLIC;
4628 GRANT ALL ON TABLE suite TO ftpmaster;
4632 -- Name: binaries_suite_arch; Type: ACL; Schema: public; Owner: dak
4635 REVOKE ALL ON TABLE binaries_suite_arch FROM PUBLIC;
4636 REVOKE ALL ON TABLE binaries_suite_arch FROM dak;
4637 GRANT ALL ON TABLE binaries_suite_arch TO dak;
4638 GRANT SELECT ON TABLE binaries_suite_arch TO ftpmaster;
4639 GRANT SELECT ON TABLE binaries_suite_arch TO PUBLIC;
4643 -- Name: binary_acl; Type: ACL; Schema: public; Owner: dak
4646 REVOKE ALL ON TABLE binary_acl FROM PUBLIC;
4647 REVOKE ALL ON TABLE binary_acl FROM dak;
4648 GRANT ALL ON TABLE binary_acl TO dak;
4649 GRANT SELECT ON TABLE binary_acl TO PUBLIC;
4650 GRANT ALL ON TABLE binary_acl TO ftpmaster;
4654 -- Name: binary_acl_id_seq; Type: ACL; Schema: public; Owner: dak
4657 REVOKE ALL ON SEQUENCE binary_acl_id_seq FROM PUBLIC;
4658 REVOKE ALL ON SEQUENCE binary_acl_id_seq FROM dak;
4659 GRANT ALL ON SEQUENCE binary_acl_id_seq TO dak;
4660 GRANT ALL ON SEQUENCE binary_acl_id_seq TO ftpmaster;
4661 GRANT SELECT ON SEQUENCE binary_acl_id_seq TO PUBLIC;
4665 -- Name: binary_acl_map; Type: ACL; Schema: public; Owner: dak
4668 REVOKE ALL ON TABLE binary_acl_map FROM PUBLIC;
4669 REVOKE ALL ON TABLE binary_acl_map FROM dak;
4670 GRANT ALL ON TABLE binary_acl_map TO dak;
4671 GRANT SELECT ON TABLE binary_acl_map TO PUBLIC;
4672 GRANT ALL ON TABLE binary_acl_map TO ftpmaster;
4676 -- Name: binary_acl_map_id_seq; Type: ACL; Schema: public; Owner: dak
4679 REVOKE ALL ON SEQUENCE binary_acl_map_id_seq FROM PUBLIC;
4680 REVOKE ALL ON SEQUENCE binary_acl_map_id_seq FROM dak;
4681 GRANT ALL ON SEQUENCE binary_acl_map_id_seq TO dak;
4682 GRANT ALL ON SEQUENCE binary_acl_map_id_seq TO ftpmaster;
4683 GRANT SELECT ON SEQUENCE binary_acl_map_id_seq TO PUBLIC;
4687 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: dak
4690 REVOKE ALL ON SEQUENCE files_id_seq FROM PUBLIC;
4691 REVOKE ALL ON SEQUENCE files_id_seq FROM dak;
4692 GRANT ALL ON SEQUENCE files_id_seq TO dak;
4693 GRANT SELECT ON SEQUENCE files_id_seq TO PUBLIC;
4694 GRANT ALL ON SEQUENCE files_id_seq TO ftpmaster;
4698 -- Name: files; Type: ACL; Schema: public; Owner: dak
4701 REVOKE ALL ON TABLE files FROM PUBLIC;
4702 REVOKE ALL ON TABLE files FROM dak;
4703 GRANT ALL ON TABLE files TO dak;
4704 GRANT SELECT ON TABLE files TO PUBLIC;
4705 GRANT ALL ON TABLE files TO ftpmaster;
4709 -- Name: location_id_seq; Type: ACL; Schema: public; Owner: dak
4712 REVOKE ALL ON SEQUENCE location_id_seq FROM PUBLIC;
4713 REVOKE ALL ON SEQUENCE location_id_seq FROM dak;
4714 GRANT ALL ON SEQUENCE location_id_seq TO dak;
4715 GRANT SELECT ON SEQUENCE location_id_seq TO PUBLIC;
4716 GRANT ALL ON SEQUENCE location_id_seq TO ftpmaster;
4720 -- Name: location; Type: ACL; Schema: public; Owner: dak
4723 REVOKE ALL ON TABLE location FROM PUBLIC;
4724 REVOKE ALL ON TABLE location FROM dak;
4725 GRANT ALL ON TABLE location TO dak;
4726 GRANT SELECT ON TABLE location TO PUBLIC;
4727 GRANT ALL ON TABLE location TO ftpmaster;
4731 -- Name: binfiles_suite_component_arch; Type: ACL; Schema: public; Owner: dak
4734 REVOKE ALL ON TABLE binfiles_suite_component_arch FROM PUBLIC;
4735 REVOKE ALL ON TABLE binfiles_suite_component_arch FROM dak;
4736 GRANT ALL ON TABLE binfiles_suite_component_arch TO dak;
4737 GRANT SELECT ON TABLE binfiles_suite_component_arch TO ftpmaster;
4738 GRANT SELECT ON TABLE binfiles_suite_component_arch TO PUBLIC;
4742 -- Name: build_queue; Type: ACL; Schema: public; Owner: dak
4745 REVOKE ALL ON TABLE build_queue FROM PUBLIC;
4746 REVOKE ALL ON TABLE build_queue FROM dak;
4747 GRANT ALL ON TABLE build_queue TO dak;
4748 GRANT SELECT ON TABLE build_queue TO PUBLIC;
4749 GRANT ALL ON TABLE build_queue TO ftpmaster;
4753 -- Name: build_queue_files; Type: ACL; Schema: public; Owner: dak
4756 REVOKE ALL ON TABLE build_queue_files FROM PUBLIC;
4757 REVOKE ALL ON TABLE build_queue_files FROM dak;
4758 GRANT ALL ON TABLE build_queue_files TO dak;
4759 GRANT SELECT ON TABLE build_queue_files TO PUBLIC;
4760 GRANT ALL ON TABLE build_queue_files TO ftpmaster;
4764 -- Name: build_queue_files_id_seq; Type: ACL; Schema: public; Owner: dak
4767 REVOKE ALL ON SEQUENCE build_queue_files_id_seq FROM PUBLIC;
4768 REVOKE ALL ON SEQUENCE build_queue_files_id_seq FROM dak;
4769 GRANT ALL ON SEQUENCE build_queue_files_id_seq TO dak;
4770 GRANT ALL ON SEQUENCE build_queue_files_id_seq TO ftpmaster;
4771 GRANT SELECT ON SEQUENCE build_queue_files_id_seq TO PUBLIC;
4775 -- Name: build_queue_id_seq; Type: ACL; Schema: public; Owner: dak
4778 REVOKE ALL ON SEQUENCE build_queue_id_seq FROM PUBLIC;
4779 REVOKE ALL ON SEQUENCE build_queue_id_seq FROM dak;
4780 GRANT ALL ON SEQUENCE build_queue_id_seq TO dak;
4781 GRANT ALL ON SEQUENCE build_queue_id_seq TO ftpmaster;
4782 GRANT SELECT ON SEQUENCE build_queue_id_seq TO PUBLIC;
4786 -- Name: build_queue_policy_files; Type: ACL; Schema: public; Owner: dak
4789 REVOKE ALL ON TABLE build_queue_policy_files FROM PUBLIC;
4790 REVOKE ALL ON TABLE build_queue_policy_files FROM dak;
4791 GRANT ALL ON TABLE build_queue_policy_files TO dak;
4792 GRANT SELECT,INSERT,UPDATE ON TABLE build_queue_policy_files TO ftpmaster;
4793 GRANT SELECT ON TABLE build_queue_policy_files TO PUBLIC;
4797 -- Name: changelogs_text; Type: ACL; Schema: public; Owner: dak
4800 REVOKE ALL ON TABLE changelogs_text FROM PUBLIC;
4801 REVOKE ALL ON TABLE changelogs_text FROM dak;
4802 GRANT ALL ON TABLE changelogs_text TO dak;
4803 GRANT SELECT ON TABLE changelogs_text TO PUBLIC;
4804 GRANT ALL ON TABLE changelogs_text TO ftpmaster;
4808 -- Name: changes; Type: ACL; Schema: public; Owner: dak
4811 REVOKE ALL ON TABLE changes FROM PUBLIC;
4812 REVOKE ALL ON TABLE changes FROM dak;
4813 GRANT ALL ON TABLE changes TO dak;
4814 GRANT ALL ON TABLE changes TO ftpmaster;
4815 GRANT SELECT ON TABLE changes TO PUBLIC;
4816 GRANT DELETE,UPDATE ON TABLE changes TO ftpteam;
4820 -- Name: changelogs; Type: ACL; Schema: public; Owner: dak
4823 REVOKE ALL ON TABLE changelogs FROM PUBLIC;
4824 REVOKE ALL ON TABLE changelogs FROM dak;
4825 GRANT ALL ON TABLE changelogs TO dak;
4826 GRANT SELECT ON TABLE changelogs TO PUBLIC;
4827 GRANT ALL ON TABLE changelogs TO ftpmaster;
4831 -- Name: changelogs_text_id_seq; Type: ACL; Schema: public; Owner: dak
4834 REVOKE ALL ON SEQUENCE changelogs_text_id_seq FROM PUBLIC;
4835 REVOKE ALL ON SEQUENCE changelogs_text_id_seq FROM dak;
4836 GRANT ALL ON SEQUENCE changelogs_text_id_seq TO dak;
4837 GRANT ALL ON SEQUENCE changelogs_text_id_seq TO ftpmaster;
4838 GRANT SELECT ON SEQUENCE changelogs_text_id_seq TO PUBLIC;
4842 -- Name: changes_id_seq; Type: ACL; Schema: public; Owner: dak
4845 REVOKE ALL ON SEQUENCE changes_id_seq FROM PUBLIC;
4846 REVOKE ALL ON SEQUENCE changes_id_seq FROM dak;
4847 GRANT ALL ON SEQUENCE changes_id_seq TO dak;
4848 GRANT ALL ON SEQUENCE changes_id_seq TO ftpmaster;
4849 GRANT SELECT ON SEQUENCE changes_id_seq TO PUBLIC;
4853 -- Name: changes_pending_binaries; Type: ACL; Schema: public; Owner: dak
4856 REVOKE ALL ON TABLE changes_pending_binaries FROM PUBLIC;
4857 REVOKE ALL ON TABLE changes_pending_binaries FROM dak;
4858 GRANT ALL ON TABLE changes_pending_binaries TO dak;
4859 GRANT SELECT ON TABLE changes_pending_binaries TO PUBLIC;
4860 GRANT ALL ON TABLE changes_pending_binaries TO ftpmaster;
4864 -- Name: changes_pending_binaries_id_seq; Type: ACL; Schema: public; Owner: dak
4867 REVOKE ALL ON SEQUENCE changes_pending_binaries_id_seq FROM PUBLIC;
4868 REVOKE ALL ON SEQUENCE changes_pending_binaries_id_seq FROM dak;
4869 GRANT ALL ON SEQUENCE changes_pending_binaries_id_seq TO dak;
4870 GRANT ALL ON SEQUENCE changes_pending_binaries_id_seq TO ftpmaster;
4871 GRANT SELECT ON SEQUENCE changes_pending_binaries_id_seq TO PUBLIC;
4875 -- Name: changes_pending_files; Type: ACL; Schema: public; Owner: dak
4878 REVOKE ALL ON TABLE changes_pending_files FROM PUBLIC;
4879 REVOKE ALL ON TABLE changes_pending_files FROM dak;
4880 GRANT ALL ON TABLE changes_pending_files TO dak;
4881 GRANT SELECT ON TABLE changes_pending_files TO PUBLIC;
4882 GRANT ALL ON TABLE changes_pending_files TO ftpmaster;
4883 GRANT DELETE ON TABLE changes_pending_files TO ftpteam;
4887 -- Name: changes_pending_files_id_seq; Type: ACL; Schema: public; Owner: dak
4890 REVOKE ALL ON SEQUENCE changes_pending_files_id_seq FROM PUBLIC;
4891 REVOKE ALL ON SEQUENCE changes_pending_files_id_seq FROM dak;
4892 GRANT ALL ON SEQUENCE changes_pending_files_id_seq TO dak;
4893 GRANT ALL ON SEQUENCE changes_pending_files_id_seq TO ftpmaster;
4894 GRANT SELECT ON SEQUENCE changes_pending_files_id_seq TO PUBLIC;
4895 GRANT USAGE ON SEQUENCE changes_pending_files_id_seq TO ftpteam;
4899 -- Name: changes_pending_files_map; Type: ACL; Schema: public; Owner: dak
4902 REVOKE ALL ON TABLE changes_pending_files_map FROM PUBLIC;
4903 REVOKE ALL ON TABLE changes_pending_files_map FROM dak;
4904 GRANT ALL ON TABLE changes_pending_files_map TO dak;
4905 GRANT SELECT,INSERT,DELETE ON TABLE changes_pending_files_map TO ftpteam;
4906 GRANT SELECT ON TABLE changes_pending_files_map TO PUBLIC;
4910 -- Name: changes_pending_source; Type: ACL; Schema: public; Owner: dak
4913 REVOKE ALL ON TABLE changes_pending_source FROM PUBLIC;
4914 REVOKE ALL ON TABLE changes_pending_source FROM dak;
4915 GRANT ALL ON TABLE changes_pending_source TO dak;
4916 GRANT SELECT ON TABLE changes_pending_source TO PUBLIC;
4917 GRANT ALL ON TABLE changes_pending_source TO ftpmaster;
4921 -- Name: changes_pending_source_files; Type: ACL; Schema: public; Owner: dak
4924 REVOKE ALL ON TABLE changes_pending_source_files FROM PUBLIC;
4925 REVOKE ALL ON TABLE changes_pending_source_files FROM dak;
4926 GRANT ALL ON TABLE changes_pending_source_files TO dak;
4927 GRANT SELECT ON TABLE changes_pending_source_files TO PUBLIC;
4928 GRANT ALL ON TABLE changes_pending_source_files TO ftpmaster;
4932 -- Name: changes_pending_source_id_seq; Type: ACL; Schema: public; Owner: dak
4935 REVOKE ALL ON SEQUENCE changes_pending_source_id_seq FROM PUBLIC;
4936 REVOKE ALL ON SEQUENCE changes_pending_source_id_seq FROM dak;
4937 GRANT ALL ON SEQUENCE changes_pending_source_id_seq TO dak;
4938 GRANT ALL ON SEQUENCE changes_pending_source_id_seq TO ftpmaster;
4939 GRANT SELECT ON SEQUENCE changes_pending_source_id_seq TO PUBLIC;
4943 -- Name: changes_pool_files; Type: ACL; Schema: public; Owner: dak
4946 REVOKE ALL ON TABLE changes_pool_files FROM PUBLIC;
4947 REVOKE ALL ON TABLE changes_pool_files FROM dak;
4948 GRANT ALL ON TABLE changes_pool_files TO dak;
4949 GRANT SELECT ON TABLE changes_pool_files TO PUBLIC;
4950 GRANT ALL ON TABLE changes_pool_files TO ftpmaster;
4951 GRANT DELETE ON TABLE changes_pool_files TO ftpteam;
4955 -- Name: component_id_seq; Type: ACL; Schema: public; Owner: dak
4958 REVOKE ALL ON SEQUENCE component_id_seq FROM PUBLIC;
4959 REVOKE ALL ON SEQUENCE component_id_seq FROM dak;
4960 GRANT ALL ON SEQUENCE component_id_seq TO dak;
4961 GRANT SELECT ON SEQUENCE component_id_seq TO PUBLIC;
4962 GRANT ALL ON SEQUENCE component_id_seq TO ftpmaster;
4966 -- Name: component; Type: ACL; Schema: public; Owner: dak
4969 REVOKE ALL ON TABLE component FROM PUBLIC;
4970 REVOKE ALL ON TABLE component FROM dak;
4971 GRANT ALL ON TABLE component TO dak;
4972 GRANT SELECT ON TABLE component TO PUBLIC;
4973 GRANT ALL ON TABLE component TO ftpmaster;
4977 -- Name: config; Type: ACL; Schema: public; Owner: dak
4980 REVOKE ALL ON TABLE config FROM PUBLIC;
4981 REVOKE ALL ON TABLE config FROM dak;
4982 GRANT ALL ON TABLE config TO dak;
4983 GRANT ALL ON TABLE config TO ftpmaster;
4984 GRANT SELECT ON TABLE config TO ftpteam;
4985 GRANT SELECT ON TABLE config TO PUBLIC;
4989 -- Name: config_id_seq; Type: ACL; Schema: public; Owner: dak
4992 REVOKE ALL ON SEQUENCE config_id_seq FROM PUBLIC;
4993 REVOKE ALL ON SEQUENCE config_id_seq FROM dak;
4994 GRANT ALL ON SEQUENCE config_id_seq TO dak;
4995 GRANT ALL ON SEQUENCE config_id_seq TO ftpmaster;
4996 GRANT SELECT ON SEQUENCE config_id_seq TO PUBLIC;
5000 -- Name: dsc_files_id_seq; Type: ACL; Schema: public; Owner: dak
5003 REVOKE ALL ON SEQUENCE dsc_files_id_seq FROM PUBLIC;
5004 REVOKE ALL ON SEQUENCE dsc_files_id_seq FROM dak;
5005 GRANT ALL ON SEQUENCE dsc_files_id_seq TO dak;
5006 GRANT SELECT ON SEQUENCE dsc_files_id_seq TO PUBLIC;
5007 GRANT ALL ON SEQUENCE dsc_files_id_seq TO ftpmaster;
5011 -- Name: dsc_files; Type: ACL; Schema: public; Owner: dak
5014 REVOKE ALL ON TABLE dsc_files FROM PUBLIC;
5015 REVOKE ALL ON TABLE dsc_files FROM dak;
5016 GRANT ALL ON TABLE dsc_files TO dak;
5017 GRANT SELECT ON TABLE dsc_files TO PUBLIC;
5018 GRANT ALL ON TABLE dsc_files TO ftpmaster;
5022 -- Name: external_overrides; Type: ACL; Schema: public; Owner: dak
5025 REVOKE ALL ON TABLE external_overrides FROM PUBLIC;
5026 REVOKE ALL ON TABLE external_overrides FROM dak;
5027 GRANT ALL ON TABLE external_overrides TO dak;
5028 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE external_overrides TO ftpmaster;
5029 GRANT SELECT ON TABLE external_overrides TO PUBLIC;
5033 -- Name: extra_src_references; Type: ACL; Schema: public; Owner: dak
5036 REVOKE ALL ON TABLE extra_src_references FROM PUBLIC;
5037 REVOKE ALL ON TABLE extra_src_references FROM dak;
5038 GRANT ALL ON TABLE extra_src_references TO dak;
5039 GRANT SELECT,INSERT,UPDATE ON TABLE extra_src_references TO ftpmaster;
5040 GRANT SELECT ON TABLE extra_src_references TO PUBLIC;
5044 -- Name: file_arch_suite; Type: ACL; Schema: public; Owner: dak
5047 REVOKE ALL ON TABLE file_arch_suite FROM PUBLIC;
5048 REVOKE ALL ON TABLE file_arch_suite FROM dak;
5049 GRANT ALL ON TABLE file_arch_suite TO dak;
5050 GRANT ALL ON TABLE file_arch_suite TO ftpmaster;
5051 GRANT SELECT ON TABLE file_arch_suite TO PUBLIC;
5055 -- Name: fingerprint_id_seq; Type: ACL; Schema: public; Owner: dak
5058 REVOKE ALL ON SEQUENCE fingerprint_id_seq FROM PUBLIC;
5059 REVOKE ALL ON SEQUENCE fingerprint_id_seq FROM dak;
5060 GRANT ALL ON SEQUENCE fingerprint_id_seq TO dak;
5061 GRANT SELECT ON SEQUENCE fingerprint_id_seq TO PUBLIC;
5062 GRANT ALL ON SEQUENCE fingerprint_id_seq TO ftpmaster;
5066 -- Name: fingerprint; Type: ACL; Schema: public; Owner: dak
5069 REVOKE ALL ON TABLE fingerprint FROM PUBLIC;
5070 REVOKE ALL ON TABLE fingerprint FROM dak;
5071 GRANT ALL ON TABLE fingerprint TO dak;
5072 GRANT SELECT ON TABLE fingerprint TO PUBLIC;
5073 GRANT ALL ON TABLE fingerprint TO ftpmaster;
5077 -- Name: keyring_acl_map; Type: ACL; Schema: public; Owner: dak
5080 REVOKE ALL ON TABLE keyring_acl_map FROM PUBLIC;
5081 REVOKE ALL ON TABLE keyring_acl_map FROM dak;
5082 GRANT ALL ON TABLE keyring_acl_map TO dak;
5083 GRANT SELECT ON TABLE keyring_acl_map TO PUBLIC;
5084 GRANT ALL ON TABLE keyring_acl_map TO ftpmaster;
5088 -- Name: keyring_acl_map_id_seq; Type: ACL; Schema: public; Owner: dak
5091 REVOKE ALL ON SEQUENCE keyring_acl_map_id_seq FROM PUBLIC;
5092 REVOKE ALL ON SEQUENCE keyring_acl_map_id_seq FROM dak;
5093 GRANT ALL ON SEQUENCE keyring_acl_map_id_seq TO dak;
5094 GRANT ALL ON SEQUENCE keyring_acl_map_id_seq TO ftpmaster;
5095 GRANT SELECT ON SEQUENCE keyring_acl_map_id_seq TO PUBLIC;
5099 -- Name: keyrings; Type: ACL; Schema: public; Owner: dak
5102 REVOKE ALL ON TABLE keyrings FROM PUBLIC;
5103 REVOKE ALL ON TABLE keyrings FROM dak;
5104 GRANT ALL ON TABLE keyrings TO dak;
5105 GRANT SELECT ON TABLE keyrings TO PUBLIC;
5106 GRANT ALL ON TABLE keyrings TO ftpmaster;
5110 -- Name: keyrings_id_seq; Type: ACL; Schema: public; Owner: dak
5113 REVOKE ALL ON SEQUENCE keyrings_id_seq FROM PUBLIC;
5114 REVOKE ALL ON SEQUENCE keyrings_id_seq FROM dak;
5115 GRANT ALL ON SEQUENCE keyrings_id_seq TO dak;
5116 GRANT SELECT ON SEQUENCE keyrings_id_seq TO PUBLIC;
5117 GRANT ALL ON SEQUENCE keyrings_id_seq TO ftpmaster;
5121 -- Name: maintainer_id_seq; Type: ACL; Schema: public; Owner: dak
5124 REVOKE ALL ON SEQUENCE maintainer_id_seq FROM PUBLIC;
5125 REVOKE ALL ON SEQUENCE maintainer_id_seq FROM dak;
5126 GRANT ALL ON SEQUENCE maintainer_id_seq TO dak;
5127 GRANT SELECT ON SEQUENCE maintainer_id_seq TO PUBLIC;
5128 GRANT ALL ON SEQUENCE maintainer_id_seq TO ftpmaster;
5132 -- Name: maintainer; Type: ACL; Schema: public; Owner: dak
5135 REVOKE ALL ON TABLE maintainer FROM PUBLIC;
5136 REVOKE ALL ON TABLE maintainer FROM dak;
5137 GRANT ALL ON TABLE maintainer TO dak;
5138 GRANT SELECT ON TABLE maintainer TO PUBLIC;
5139 GRANT ALL ON TABLE maintainer TO ftpmaster;
5143 -- Name: metadata_keys; Type: ACL; Schema: public; Owner: dak
5146 REVOKE ALL ON TABLE metadata_keys FROM PUBLIC;
5147 REVOKE ALL ON TABLE metadata_keys FROM dak;
5148 GRANT ALL ON TABLE metadata_keys TO dak;
5149 GRANT SELECT,INSERT,UPDATE ON TABLE metadata_keys TO ftpmaster;
5150 GRANT SELECT ON TABLE metadata_keys TO PUBLIC;
5154 -- Name: metadata_keys_key_id_seq; Type: ACL; Schema: public; Owner: dak
5157 REVOKE ALL ON SEQUENCE metadata_keys_key_id_seq FROM PUBLIC;
5158 REVOKE ALL ON SEQUENCE metadata_keys_key_id_seq FROM dak;
5159 GRANT ALL ON SEQUENCE metadata_keys_key_id_seq TO dak;
5160 GRANT ALL ON SEQUENCE metadata_keys_key_id_seq TO ftpmaster;
5161 GRANT SELECT ON SEQUENCE metadata_keys_key_id_seq TO PUBLIC;
5165 -- Name: new_comments; Type: ACL; Schema: public; Owner: dak
5168 REVOKE ALL ON TABLE new_comments FROM PUBLIC;
5169 REVOKE ALL ON TABLE new_comments FROM dak;
5170 GRANT ALL ON TABLE new_comments TO dak;
5171 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE new_comments TO ftptrainee;
5172 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE new_comments TO ftpteam;
5173 GRANT ALL ON TABLE new_comments TO ftpmaster;
5177 -- Name: new_comments_id_seq; Type: ACL; Schema: public; Owner: dak
5180 REVOKE ALL ON SEQUENCE new_comments_id_seq FROM PUBLIC;
5181 REVOKE ALL ON SEQUENCE new_comments_id_seq FROM dak;
5182 GRANT ALL ON SEQUENCE new_comments_id_seq TO dak;
5183 GRANT SELECT,UPDATE ON SEQUENCE new_comments_id_seq TO ftptrainee;
5184 GRANT SELECT,UPDATE ON SEQUENCE new_comments_id_seq TO ftpteam;
5185 GRANT ALL ON SEQUENCE new_comments_id_seq TO ftpmaster;
5186 GRANT SELECT ON SEQUENCE new_comments_id_seq TO PUBLIC;
5190 -- Name: newest_all_associations; Type: ACL; Schema: public; Owner: dak
5193 REVOKE ALL ON TABLE newest_all_associations FROM PUBLIC;
5194 REVOKE ALL ON TABLE newest_all_associations FROM dak;
5195 GRANT ALL ON TABLE newest_all_associations TO dak;
5196 GRANT SELECT ON TABLE newest_all_associations TO ftpmaster;
5197 GRANT SELECT ON TABLE newest_all_associations TO PUBLIC;
5201 -- Name: newest_any_associations; Type: ACL; Schema: public; Owner: dak
5204 REVOKE ALL ON TABLE newest_any_associations FROM PUBLIC;
5205 REVOKE ALL ON TABLE newest_any_associations FROM dak;
5206 GRANT ALL ON TABLE newest_any_associations TO dak;
5207 GRANT SELECT ON TABLE newest_any_associations TO ftpmaster;
5208 GRANT SELECT ON TABLE newest_any_associations TO PUBLIC;
5212 -- Name: source_suite; Type: ACL; Schema: public; Owner: dak
5215 REVOKE ALL ON TABLE source_suite FROM PUBLIC;
5216 REVOKE ALL ON TABLE source_suite FROM dak;
5217 GRANT ALL ON TABLE source_suite TO dak;
5218 GRANT SELECT ON TABLE source_suite TO ftpmaster;
5219 GRANT SELECT ON TABLE source_suite TO PUBLIC;
5223 -- Name: newest_source; Type: ACL; Schema: public; Owner: dak
5226 REVOKE ALL ON TABLE newest_source FROM PUBLIC;
5227 REVOKE ALL ON TABLE newest_source FROM dak;
5228 GRANT ALL ON TABLE newest_source TO dak;
5229 GRANT SELECT ON TABLE newest_source TO ftpmaster;
5230 GRANT SELECT ON TABLE newest_source TO PUBLIC;
5234 -- Name: newest_src_association; Type: ACL; Schema: public; Owner: dak
5237 REVOKE ALL ON TABLE newest_src_association FROM PUBLIC;
5238 REVOKE ALL ON TABLE newest_src_association FROM dak;
5239 GRANT ALL ON TABLE newest_src_association TO dak;
5240 GRANT SELECT ON TABLE newest_src_association TO ftpmaster;
5241 GRANT SELECT ON TABLE newest_src_association TO PUBLIC;
5245 -- Name: obsolete_all_associations; Type: ACL; Schema: public; Owner: dak
5248 REVOKE ALL ON TABLE obsolete_all_associations FROM PUBLIC;
5249 REVOKE ALL ON TABLE obsolete_all_associations FROM dak;
5250 GRANT ALL ON TABLE obsolete_all_associations TO dak;
5251 GRANT SELECT ON TABLE obsolete_all_associations TO ftpmaster;
5252 GRANT SELECT ON TABLE obsolete_all_associations TO PUBLIC;
5256 -- Name: obsolete_any_associations; Type: ACL; Schema: public; Owner: dak
5259 REVOKE ALL ON TABLE obsolete_any_associations FROM PUBLIC;
5260 REVOKE ALL ON TABLE obsolete_any_associations FROM dak;
5261 GRANT ALL ON TABLE obsolete_any_associations TO dak;
5262 GRANT SELECT ON TABLE obsolete_any_associations TO ftpmaster;
5263 GRANT SELECT ON TABLE obsolete_any_associations TO PUBLIC;
5267 -- Name: obsolete_any_by_all_associations; Type: ACL; Schema: public; Owner: dak
5270 REVOKE ALL ON TABLE obsolete_any_by_all_associations FROM PUBLIC;
5271 REVOKE ALL ON TABLE obsolete_any_by_all_associations FROM dak;
5272 GRANT ALL ON TABLE obsolete_any_by_all_associations TO dak;
5273 GRANT SELECT ON TABLE obsolete_any_by_all_associations TO ftpmaster;
5274 GRANT SELECT ON TABLE obsolete_any_by_all_associations TO PUBLIC;
5278 -- Name: obsolete_src_associations; Type: ACL; Schema: public; Owner: dak
5281 REVOKE ALL ON TABLE obsolete_src_associations FROM PUBLIC;
5282 REVOKE ALL ON TABLE obsolete_src_associations FROM dak;
5283 GRANT ALL ON TABLE obsolete_src_associations TO dak;
5284 GRANT SELECT ON TABLE obsolete_src_associations TO ftpmaster;
5285 GRANT SELECT ON TABLE obsolete_src_associations TO PUBLIC;
5289 -- Name: override; Type: ACL; Schema: public; Owner: dak
5292 REVOKE ALL ON TABLE override FROM PUBLIC;
5293 REVOKE ALL ON TABLE override FROM dak;
5294 GRANT ALL ON TABLE override TO dak;
5295 GRANT SELECT ON TABLE override TO PUBLIC;
5296 GRANT ALL ON TABLE override TO ftpmaster;
5297 GRANT INSERT,DELETE,UPDATE ON TABLE override TO ftpteam;
5301 -- Name: override_type_id_seq; Type: ACL; Schema: public; Owner: dak
5304 REVOKE ALL ON SEQUENCE override_type_id_seq FROM PUBLIC;
5305 REVOKE ALL ON SEQUENCE override_type_id_seq FROM dak;
5306 GRANT ALL ON SEQUENCE override_type_id_seq TO dak;
5307 GRANT SELECT ON SEQUENCE override_type_id_seq TO PUBLIC;
5308 GRANT ALL ON SEQUENCE override_type_id_seq TO ftpmaster;
5312 -- Name: override_type; Type: ACL; Schema: public; Owner: dak
5315 REVOKE ALL ON TABLE override_type FROM PUBLIC;
5316 REVOKE ALL ON TABLE override_type FROM dak;
5317 GRANT ALL ON TABLE override_type TO dak;
5318 GRANT SELECT ON TABLE override_type TO PUBLIC;
5319 GRANT ALL ON TABLE override_type TO ftpmaster;
5323 -- Name: policy_queue; Type: ACL; Schema: public; Owner: dak
5326 REVOKE ALL ON TABLE policy_queue FROM PUBLIC;
5327 REVOKE ALL ON TABLE policy_queue FROM dak;
5328 GRANT ALL ON TABLE policy_queue TO dak;
5329 GRANT SELECT ON TABLE policy_queue TO PUBLIC;
5330 GRANT ALL ON TABLE policy_queue TO ftpmaster;
5334 -- Name: policy_queue_id_seq; Type: ACL; Schema: public; Owner: dak
5337 REVOKE ALL ON SEQUENCE policy_queue_id_seq FROM PUBLIC;
5338 REVOKE ALL ON SEQUENCE policy_queue_id_seq FROM dak;
5339 GRANT ALL ON SEQUENCE policy_queue_id_seq TO dak;
5340 GRANT ALL ON SEQUENCE policy_queue_id_seq TO ftpmaster;
5341 GRANT SELECT ON SEQUENCE policy_queue_id_seq TO PUBLIC;
5345 -- Name: priority_id_seq; Type: ACL; Schema: public; Owner: dak
5348 REVOKE ALL ON SEQUENCE priority_id_seq FROM PUBLIC;
5349 REVOKE ALL ON SEQUENCE priority_id_seq FROM dak;
5350 GRANT ALL ON SEQUENCE priority_id_seq TO dak;
5351 GRANT SELECT ON SEQUENCE priority_id_seq TO PUBLIC;
5352 GRANT ALL ON SEQUENCE priority_id_seq TO ftpmaster;
5356 -- Name: priority; Type: ACL; Schema: public; Owner: dak
5359 REVOKE ALL ON TABLE priority FROM PUBLIC;
5360 REVOKE ALL ON TABLE priority FROM dak;
5361 GRANT ALL ON TABLE priority TO dak;
5362 GRANT SELECT ON TABLE priority TO PUBLIC;
5363 GRANT ALL ON TABLE priority TO ftpmaster;
5367 -- Name: section_id_seq; Type: ACL; Schema: public; Owner: dak
5370 REVOKE ALL ON SEQUENCE section_id_seq FROM PUBLIC;
5371 REVOKE ALL ON SEQUENCE section_id_seq FROM dak;
5372 GRANT ALL ON SEQUENCE section_id_seq TO dak;
5373 GRANT SELECT ON SEQUENCE section_id_seq TO PUBLIC;
5374 GRANT ALL ON SEQUENCE section_id_seq TO ftpmaster;
5378 -- Name: section; Type: ACL; Schema: public; Owner: dak
5381 REVOKE ALL ON TABLE section FROM PUBLIC;
5382 REVOKE ALL ON TABLE section FROM dak;
5383 GRANT ALL ON TABLE section TO dak;
5384 GRANT SELECT ON TABLE section TO PUBLIC;
5385 GRANT ALL ON TABLE section TO ftpmaster;
5389 -- Name: source_acl; Type: ACL; Schema: public; Owner: dak
5392 REVOKE ALL ON TABLE source_acl FROM PUBLIC;
5393 REVOKE ALL ON TABLE source_acl FROM dak;
5394 GRANT ALL ON TABLE source_acl TO dak;
5395 GRANT SELECT ON TABLE source_acl TO PUBLIC;
5396 GRANT ALL ON TABLE source_acl TO ftpmaster;
5400 -- Name: source_acl_id_seq; Type: ACL; Schema: public; Owner: dak
5403 REVOKE ALL ON SEQUENCE source_acl_id_seq FROM PUBLIC;
5404 REVOKE ALL ON SEQUENCE source_acl_id_seq FROM dak;
5405 GRANT ALL ON SEQUENCE source_acl_id_seq TO dak;
5406 GRANT ALL ON SEQUENCE source_acl_id_seq TO ftpmaster;
5407 GRANT SELECT ON SEQUENCE source_acl_id_seq TO PUBLIC;
5411 -- Name: source_metadata; Type: ACL; Schema: public; Owner: dak
5414 REVOKE ALL ON TABLE source_metadata FROM PUBLIC;
5415 REVOKE ALL ON TABLE source_metadata FROM dak;
5416 GRANT ALL ON TABLE source_metadata TO dak;
5417 GRANT SELECT,INSERT,UPDATE ON TABLE source_metadata TO ftpmaster;
5418 GRANT SELECT ON TABLE source_metadata TO PUBLIC;
5422 -- Name: src_contents; Type: ACL; Schema: public; Owner: dak
5425 REVOKE ALL ON TABLE src_contents FROM PUBLIC;
5426 REVOKE ALL ON TABLE src_contents FROM dak;
5427 GRANT ALL ON TABLE src_contents TO dak;
5428 GRANT SELECT,INSERT,UPDATE ON TABLE src_contents TO ftpmaster;
5429 GRANT SELECT ON TABLE src_contents TO PUBLIC;
5433 -- Name: src_format; Type: ACL; Schema: public; Owner: dak
5436 REVOKE ALL ON TABLE src_format FROM PUBLIC;
5437 REVOKE ALL ON TABLE src_format FROM dak;
5438 GRANT ALL ON TABLE src_format TO dak;
5439 GRANT SELECT ON TABLE src_format TO PUBLIC;
5440 GRANT ALL ON TABLE src_format TO ftpmaster;
5444 -- Name: src_format_id_seq; Type: ACL; Schema: public; Owner: dak
5447 REVOKE ALL ON SEQUENCE src_format_id_seq FROM PUBLIC;
5448 REVOKE ALL ON SEQUENCE src_format_id_seq FROM dak;
5449 GRANT ALL ON SEQUENCE src_format_id_seq TO dak;
5450 GRANT ALL ON SEQUENCE src_format_id_seq TO ftpmaster;
5451 GRANT SELECT ON SEQUENCE src_format_id_seq TO PUBLIC;
5455 -- Name: src_uploaders; Type: ACL; Schema: public; Owner: dak
5458 REVOKE ALL ON TABLE src_uploaders FROM PUBLIC;
5459 REVOKE ALL ON TABLE src_uploaders FROM dak;
5460 GRANT ALL ON TABLE src_uploaders TO dak;
5461 GRANT SELECT ON TABLE src_uploaders TO PUBLIC;
5462 GRANT ALL ON TABLE src_uploaders TO ftpmaster;
5466 -- Name: src_uploaders_id_seq; Type: ACL; Schema: public; Owner: dak
5469 REVOKE ALL ON SEQUENCE src_uploaders_id_seq FROM PUBLIC;
5470 REVOKE ALL ON SEQUENCE src_uploaders_id_seq FROM dak;
5471 GRANT ALL ON SEQUENCE src_uploaders_id_seq TO dak;
5472 GRANT SELECT ON SEQUENCE src_uploaders_id_seq TO PUBLIC;
5473 GRANT ALL ON SEQUENCE src_uploaders_id_seq TO ftpmaster;
5477 -- Name: suite_architectures; Type: ACL; Schema: public; Owner: dak
5480 REVOKE ALL ON TABLE suite_architectures FROM PUBLIC;
5481 REVOKE ALL ON TABLE suite_architectures FROM dak;
5482 GRANT ALL ON TABLE suite_architectures TO dak;
5483 GRANT SELECT ON TABLE suite_architectures TO PUBLIC;
5484 GRANT ALL ON TABLE suite_architectures TO ftpmaster;
5488 -- Name: suite_arch_by_name; Type: ACL; Schema: public; Owner: dak
5491 REVOKE ALL ON TABLE suite_arch_by_name FROM PUBLIC;
5492 REVOKE ALL ON TABLE suite_arch_by_name FROM dak;
5493 GRANT ALL ON TABLE suite_arch_by_name TO dak;
5494 GRANT SELECT ON TABLE suite_arch_by_name TO PUBLIC;
5495 GRANT SELECT ON TABLE suite_arch_by_name TO ftpmaster;
5499 -- Name: suite_build_queue_copy; Type: ACL; Schema: public; Owner: dak
5502 REVOKE ALL ON TABLE suite_build_queue_copy FROM PUBLIC;
5503 REVOKE ALL ON TABLE suite_build_queue_copy FROM dak;
5504 GRANT ALL ON TABLE suite_build_queue_copy TO dak;
5505 GRANT SELECT ON TABLE suite_build_queue_copy TO PUBLIC;
5506 GRANT ALL ON TABLE suite_build_queue_copy TO ftpmaster;
5510 -- Name: suite_src_formats; Type: ACL; Schema: public; Owner: dak
5513 REVOKE ALL ON TABLE suite_src_formats FROM PUBLIC;
5514 REVOKE ALL ON TABLE suite_src_formats FROM dak;
5515 GRANT ALL ON TABLE suite_src_formats TO dak;
5516 GRANT SELECT ON TABLE suite_src_formats TO PUBLIC;
5517 GRANT ALL ON TABLE suite_src_formats TO ftpmaster;
5521 -- Name: uid_id_seq; Type: ACL; Schema: public; Owner: dak
5524 REVOKE ALL ON SEQUENCE uid_id_seq FROM PUBLIC;
5525 REVOKE ALL ON SEQUENCE uid_id_seq FROM dak;
5526 GRANT ALL ON SEQUENCE uid_id_seq TO dak;
5527 GRANT SELECT ON SEQUENCE uid_id_seq TO PUBLIC;
5528 GRANT ALL ON SEQUENCE uid_id_seq TO ftpmaster;
5532 -- Name: uid; Type: ACL; Schema: public; Owner: dak
5535 REVOKE ALL ON TABLE uid FROM PUBLIC;
5536 REVOKE ALL ON TABLE uid FROM dak;
5537 GRANT ALL ON TABLE uid TO dak;
5538 GRANT SELECT ON TABLE uid TO PUBLIC;
5539 GRANT ALL ON TABLE uid TO ftpmaster;
5543 -- Name: upload_blocks; Type: ACL; Schema: public; Owner: dak
5546 REVOKE ALL ON TABLE upload_blocks FROM PUBLIC;
5547 REVOKE ALL ON TABLE upload_blocks FROM dak;
5548 GRANT ALL ON TABLE upload_blocks TO dak;
5549 GRANT SELECT ON TABLE upload_blocks TO PUBLIC;
5550 GRANT ALL ON TABLE upload_blocks TO ftpmaster;
5554 -- Name: upload_blocks_id_seq; Type: ACL; Schema: public; Owner: dak
5557 REVOKE ALL ON SEQUENCE upload_blocks_id_seq FROM PUBLIC;
5558 REVOKE ALL ON SEQUENCE upload_blocks_id_seq FROM dak;
5559 GRANT ALL ON SEQUENCE upload_blocks_id_seq TO dak;
5560 GRANT ALL ON SEQUENCE upload_blocks_id_seq TO ftpmaster;
5561 GRANT SELECT ON SEQUENCE upload_blocks_id_seq TO PUBLIC;
5565 -- Name: version_check; Type: ACL; Schema: public; Owner: dak
5568 REVOKE ALL ON TABLE version_check FROM PUBLIC;
5569 REVOKE ALL ON TABLE version_check FROM dak;
5570 GRANT ALL ON TABLE version_check TO dak;
5571 GRANT SELECT,INSERT,UPDATE ON TABLE version_check TO ftpmaster;
5572 GRANT SELECT ON TABLE version_check TO PUBLIC;
5576 -- Name: version_checks; Type: ACL; Schema: public; Owner: dak
5579 REVOKE ALL ON TABLE version_checks FROM PUBLIC;
5580 REVOKE ALL ON TABLE version_checks FROM dak;
5581 GRANT ALL ON TABLE version_checks TO dak;
5582 GRANT SELECT ON TABLE version_checks TO PUBLIC;
5586 -- PostgreSQL database dump complete
5589 -- Set schema version
5590 INSERT INTO config (name, value) VALUES ('db_revision', 64);