2 -- PostgreSQL database dump
5 SET statement_timeout = 0;
6 SET client_encoding = 'SQL_ASCII';
7 SET standard_conforming_strings = off;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
10 SET escape_string_warning = off;
13 -- Name: plperl; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: dak
16 CREATE OR REPLACE PROCEDURAL LANGUAGE plperl;
19 ALTER PROCEDURAL LANGUAGE plperl OWNER TO dak;
22 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: dak
25 CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
28 ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO dak;
31 -- Name: plpythonu; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: dak
34 CREATE OR REPLACE PROCEDURAL LANGUAGE plpythonu;
37 ALTER PROCEDURAL LANGUAGE plpythonu OWNER TO dak;
39 SET search_path = public, pg_catalog;
42 -- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres
45 CREATE TYPE debversion;
49 -- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres
52 CREATE FUNCTION debversionin(cstring) RETURNS debversion
53 LANGUAGE internal IMMUTABLE STRICT
57 ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres;
60 -- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres
63 CREATE FUNCTION debversionout(debversion) RETURNS cstring
64 LANGUAGE internal IMMUTABLE STRICT
68 ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres;
71 -- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres
74 CREATE FUNCTION debversionrecv(internal) RETURNS debversion
75 LANGUAGE internal STABLE STRICT
79 ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres;
82 -- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres
85 CREATE FUNCTION debversionsend(debversion) RETURNS bytea
86 LANGUAGE internal STABLE STRICT
90 ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres;
93 -- Name: debversion; Type: TYPE; Schema: public; Owner: postgres
96 CREATE TYPE debversion (
97 INTERNALLENGTH = variable,
99 OUTPUT = debversionout,
100 RECEIVE = debversionrecv,
101 SEND = debversionsend,
108 ALTER TYPE public.debversion OWNER TO postgres;
111 -- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres
114 COMMENT ON TYPE debversion IS 'Debian package version number';
118 -- Name: bin_associations_id_max(); Type: FUNCTION; Schema: public; Owner: dak
121 CREATE FUNCTION bin_associations_id_max() RETURNS integer
123 AS $$SELECT max(id) FROM bin_associations$$;
126 ALTER FUNCTION public.bin_associations_id_max() OWNER TO dak;
129 -- Name: binaries_id_max(); Type: FUNCTION; Schema: public; Owner: dak
132 CREATE FUNCTION binaries_id_max() RETURNS integer
134 AS $$SELECT max(id) FROM binaries$$;
137 ALTER FUNCTION public.binaries_id_max() OWNER TO dak;
140 -- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres
143 CREATE FUNCTION debversion(character) RETURNS debversion
144 LANGUAGE internal IMMUTABLE STRICT
148 ALTER FUNCTION public.debversion(character) OWNER TO postgres;
151 -- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
154 CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer
155 LANGUAGE c IMMUTABLE STRICT
156 AS '$libdir/debversion', 'debversion_cmp';
159 ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres;
162 -- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
165 COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions';
169 -- Name: debversion_compare_single(text, text); Type: FUNCTION; Schema: public; Owner: dak
172 CREATE FUNCTION debversion_compare_single(version1 text, version2 text) RETURNS integer
173 LANGUAGE plperl IMMUTABLE STRICT
177 ##define order(x) ((x) == '~' ? -1 # : cisdigit((x)) ? 0 # : !(x) ? 0 # : cisalpha((x)) ? (x) # : (x) + 256)
178 # This comparison is out of dpkg's order to avoid
179 # comparing things to undef and triggering warnings.
180 if (not defined $x or not length $x) {
186 elsif ($x =~ /^\d$/) {
189 elsif ($x =~ /^[A-Z]$/i) {
193 return ord($x) + 256;
199 return @{$a} ? shift @{$a} : undef;
201 my ($val, $ref) = @_;
202 $val = "" if not defined $val;
203 $ref = "" if not defined $ref;
204 my @val = split //,$val;
205 my @ref = split //,$ref;
206 my $vc = next_elem @val;
207 my $rc = next_elem @ref;
208 while (defined $vc or defined $rc) {
210 while ((defined $vc and $vc !~ /^\d$/) or
211 (defined $rc and $rc !~ /^\d$/)) {
212 my $vo = order($vc); my $ro = order($rc);
213 # Unlike dpkg's verrevcmp, we only return 1 or -1 here.
214 return (($vo - $ro > 0) ? 1 : -1) if $vo != $ro;
215 $vc = next_elem @val; $rc = next_elem @ref;
217 while (defined $vc and $vc eq '0') {
218 $vc = next_elem @val;
220 while (defined $rc and $rc eq '0') {
221 $rc = next_elem @ref;
223 while (defined $vc and $vc =~ /^\d$/ and
224 defined $rc and $rc =~ /^\d$/) {
225 $first_diff = ord($vc) - ord($rc) if !$first_diff;
226 $vc = next_elem @val; $rc = next_elem @ref;
228 return 1 if defined $vc and $vc =~ /^\d$/;
229 return -1 if defined $rc and $rc =~ /^\d$/;
230 return (($first_diff > 0) ? 1 : -1) if $first_diff;
236 ALTER FUNCTION public.debversion_compare_single(version1 text, version2 text) OWNER TO dak;
239 -- Name: FUNCTION debversion_compare_single(version1 text, version2 text); Type: COMMENT; Schema: public; Owner: dak
242 COMMENT ON FUNCTION debversion_compare_single(version1 text, version2 text) IS 'Compare upstream or revision parts of Debian versions';
246 -- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
249 CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean
250 LANGUAGE c IMMUTABLE STRICT
251 AS '$libdir/debversion', 'debversion_eq';
254 ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres;
257 -- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
260 COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal';
264 -- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
267 CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean
268 LANGUAGE c IMMUTABLE STRICT
269 AS '$libdir/debversion', 'debversion_ge';
272 ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres;
275 -- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
278 COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal';
282 -- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
285 CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean
286 LANGUAGE c IMMUTABLE STRICT
287 AS '$libdir/debversion', 'debversion_gt';
290 ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres;
293 -- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
296 COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than';
300 -- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres
303 CREATE FUNCTION debversion_hash(debversion) RETURNS integer
304 LANGUAGE c IMMUTABLE STRICT
305 AS '$libdir/debversion', 'debversion_hash';
308 ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres;
311 -- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
314 CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion
315 LANGUAGE c IMMUTABLE STRICT
316 AS '$libdir/debversion', 'debversion_larger';
319 ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres;
322 -- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
325 CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean
326 LANGUAGE c IMMUTABLE STRICT
327 AS '$libdir/debversion', 'debversion_le';
330 ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres;
333 -- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
336 COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal';
340 -- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
343 CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean
344 LANGUAGE c IMMUTABLE STRICT
345 AS '$libdir/debversion', 'debversion_lt';
348 ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres;
351 -- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
354 COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than';
358 -- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
361 CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean
362 LANGUAGE c IMMUTABLE STRICT
363 AS '$libdir/debversion', 'debversion_ne';
366 ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres;
369 -- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
372 COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal';
376 -- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
379 CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion
380 LANGUAGE c IMMUTABLE STRICT
381 AS '$libdir/debversion', 'debversion_smaller';
384 ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres;
387 -- Name: dsc_files_id_max(); Type: FUNCTION; Schema: public; Owner: dak
390 CREATE FUNCTION dsc_files_id_max() RETURNS integer
392 AS $$SELECT max(id) FROM dsc_files$$;
395 ALTER FUNCTION public.dsc_files_id_max() OWNER TO dak;
398 -- Name: files_id_max(); Type: FUNCTION; Schema: public; Owner: dak
401 CREATE FUNCTION files_id_max() RETURNS integer
403 AS $$SELECT max(id) FROM files$$;
406 ALTER FUNCTION public.files_id_max() OWNER TO dak;
409 -- Name: override_type_id_max(); Type: FUNCTION; Schema: public; Owner: dak
412 CREATE FUNCTION override_type_id_max() RETURNS integer
414 AS $$SELECT max(id) FROM override_type$$;
417 ALTER FUNCTION public.override_type_id_max() OWNER TO dak;
420 -- Name: priority_id_max(); Type: FUNCTION; Schema: public; Owner: dak
423 CREATE FUNCTION priority_id_max() RETURNS integer
425 AS $$SELECT max(id) FROM priority$$;
428 ALTER FUNCTION public.priority_id_max() OWNER TO dak;
431 -- Name: section_id_max(); Type: FUNCTION; Schema: public; Owner: dak
434 CREATE FUNCTION section_id_max() RETURNS integer
436 AS $$SELECT max(id) FROM section$$;
439 ALTER FUNCTION public.section_id_max() OWNER TO dak;
442 -- Name: source_id_max(); Type: FUNCTION; Schema: public; Owner: dak
445 CREATE FUNCTION source_id_max() RETURNS integer
447 AS $$SELECT max(id) FROM source$$;
450 ALTER FUNCTION public.source_id_max() OWNER TO dak;
453 -- Name: space_concat(text, text); Type: FUNCTION; Schema: public; Owner: dak
456 CREATE FUNCTION space_concat(text, text) RETURNS text
459 WHEN $2 is null or $2 = '' THEN $1
460 WHEN $1 is null or $1 = '' THEN $2
465 ALTER FUNCTION public.space_concat(text, text) OWNER TO dak;
468 -- Name: src_associations_id_max(); Type: FUNCTION; Schema: public; Owner: dak
471 CREATE FUNCTION src_associations_id_max() RETURNS integer
473 AS $$SELECT max(id) FROM src_associations$$;
476 ALTER FUNCTION public.src_associations_id_max() OWNER TO dak;
479 -- Name: tfunc_set_modified(); Type: FUNCTION; Schema: public; Owner: dak
482 CREATE FUNCTION tfunc_set_modified() RETURNS trigger
485 BEGIN NEW.modified = now(); return NEW; END;
489 ALTER FUNCTION public.tfunc_set_modified() OWNER TO dak;
492 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
496 PROCEDURE = debversion_gt,
497 LEFTARG = debversion,
498 RIGHTARG = debversion,
504 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
507 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
510 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
514 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
517 CREATE AGGREGATE max(debversion) (
518 SFUNC = debversion_larger,
524 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
527 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
531 PROCEDURE = debversion_lt,
532 LEFTARG = debversion,
533 RIGHTARG = debversion,
539 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
542 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
545 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
549 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
552 CREATE AGGREGATE min(debversion) (
553 SFUNC = debversion_smaller,
559 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
562 -- Name: space_separated_list(text); Type: AGGREGATE; Schema: public; Owner: dak
565 CREATE AGGREGATE space_separated_list(text) (
566 SFUNC = space_concat,
572 ALTER AGGREGATE public.space_separated_list(text) OWNER TO dak;
575 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
579 PROCEDURE = debversion_le,
580 LEFTARG = debversion,
581 RIGHTARG = debversion,
587 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
590 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
593 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
597 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
601 PROCEDURE = debversion_ne,
602 LEFTARG = debversion,
603 RIGHTARG = debversion,
609 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
612 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
615 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
619 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
623 PROCEDURE = debversion_eq,
624 LEFTARG = debversion,
625 RIGHTARG = debversion,
631 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
634 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
637 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
641 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
645 PROCEDURE = debversion_ge,
646 LEFTARG = debversion,
647 RIGHTARG = debversion,
653 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
656 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
659 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
663 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
666 CREATE OPERATOR CLASS debversion_ops
667 DEFAULT FOR TYPE debversion USING btree AS
668 OPERATOR 1 <(debversion,debversion) ,
669 OPERATOR 2 <=(debversion,debversion) ,
670 OPERATOR 3 =(debversion,debversion) ,
671 OPERATOR 4 >=(debversion,debversion) ,
672 OPERATOR 5 >(debversion,debversion) ,
673 FUNCTION 1 debversion_cmp(debversion,debversion);
676 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
679 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
682 CREATE OPERATOR CLASS debversion_ops
683 DEFAULT FOR TYPE debversion USING hash AS
684 OPERATOR 1 =(debversion,debversion) ,
685 FUNCTION 1 debversion_hash(debversion);
688 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
690 SET search_path = pg_catalog;
693 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
696 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
700 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
703 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
707 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
710 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
714 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
717 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
721 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
724 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
728 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
731 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
734 SET search_path = public, pg_catalog;
737 -- Name: bin_associations_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
740 CREATE SEQUENCE bin_associations_id_seq
748 ALTER TABLE public.bin_associations_id_seq OWNER TO dak;
750 SET default_tablespace = '';
752 SET default_with_oids = false;
755 -- Name: bin_associations; Type: TABLE; Schema: public; Owner: dak; Tablespace:
758 CREATE TABLE bin_associations (
759 id integer DEFAULT nextval('bin_associations_id_seq'::regclass) NOT NULL,
760 suite integer NOT NULL,
761 bin integer NOT NULL,
762 created timestamp with time zone DEFAULT now() NOT NULL,
763 modified timestamp with time zone DEFAULT now() NOT NULL
767 ALTER TABLE public.bin_associations OWNER TO dak;
770 -- Name: binaries_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
773 CREATE SEQUENCE binaries_id_seq
781 ALTER TABLE public.binaries_id_seq OWNER TO dak;
784 -- Name: binaries; Type: TABLE; Schema: public; Owner: dak; Tablespace:
787 CREATE TABLE binaries (
788 id integer DEFAULT nextval('binaries_id_seq'::regclass) NOT NULL,
789 package text NOT NULL,
790 version debversion NOT NULL,
791 maintainer integer NOT NULL,
792 source integer NOT NULL,
793 architecture integer NOT NULL,
794 file integer NOT NULL,
797 install_date timestamp with time zone DEFAULT now(),
798 created timestamp with time zone DEFAULT now() NOT NULL,
799 modified timestamp with time zone DEFAULT now() NOT NULL,
804 ALTER TABLE public.binaries OWNER TO dak;
807 -- Name: bin_associations_binaries; Type: VIEW; Schema: public; Owner: dak
810 CREATE VIEW bin_associations_binaries AS
811 SELECT bin_associations.id, bin_associations.bin, binaries.package, binaries.version, bin_associations.suite, binaries.architecture, binaries.source FROM (bin_associations JOIN binaries ON ((bin_associations.bin = binaries.id)));
814 ALTER TABLE public.bin_associations_binaries OWNER TO dak;
817 -- Name: source_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
820 CREATE SEQUENCE source_id_seq
828 ALTER TABLE public.source_id_seq OWNER TO dak;
831 -- Name: source; Type: TABLE; Schema: public; Owner: dak; Tablespace:
834 CREATE TABLE source (
835 id integer DEFAULT nextval('source_id_seq'::regclass) NOT NULL,
836 source text NOT NULL,
837 version debversion NOT NULL,
838 maintainer integer NOT NULL,
839 file integer NOT NULL,
841 install_date timestamp with time zone NOT NULL,
842 changedby integer NOT NULL,
843 dm_upload_allowed boolean DEFAULT false NOT NULL,
844 created timestamp with time zone DEFAULT now() NOT NULL,
845 modified timestamp with time zone DEFAULT now() NOT NULL,
850 ALTER TABLE public.source OWNER TO dak;
853 -- Name: src_associations_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
856 CREATE SEQUENCE src_associations_id_seq
864 ALTER TABLE public.src_associations_id_seq OWNER TO dak;
867 -- Name: src_associations; Type: TABLE; Schema: public; Owner: dak; Tablespace:
870 CREATE TABLE src_associations (
871 id integer DEFAULT nextval('src_associations_id_seq'::regclass) NOT NULL,
872 suite integer NOT NULL,
873 source integer NOT NULL,
874 created timestamp with time zone DEFAULT now() NOT NULL,
875 modified timestamp with time zone DEFAULT now() NOT NULL
879 ALTER TABLE public.src_associations OWNER TO dak;
882 -- Name: src_associations_bin; Type: VIEW; Schema: public; Owner: dak
885 CREATE VIEW src_associations_bin AS
886 SELECT src_associations.id, src_associations.source, src_associations.suite, binaries.id AS bin, binaries.architecture FROM ((src_associations JOIN source ON ((src_associations.source = source.id))) JOIN binaries ON ((source.id = binaries.source)));
889 ALTER TABLE public.src_associations_bin OWNER TO dak;
892 -- Name: almost_obsolete_all_associations; Type: VIEW; Schema: public; Owner: dak
895 CREATE VIEW almost_obsolete_all_associations AS
896 SELECT bin_associations_binaries.id, bin_associations_binaries.bin, bin_associations_binaries.package, bin_associations_binaries.version, bin_associations_binaries.suite FROM (bin_associations_binaries LEFT JOIN src_associations_bin USING (bin, suite, architecture)) WHERE ((src_associations_bin.source IS NULL) AND (bin_associations_binaries.architecture = 2));
899 ALTER TABLE public.almost_obsolete_all_associations OWNER TO dak;
902 -- Name: any_associations_source; Type: VIEW; Schema: public; Owner: dak
905 CREATE VIEW any_associations_source AS
906 SELECT bin_associations.id, bin_associations.suite, binaries.id AS bin, binaries.package, binaries.version AS binver, binaries.architecture, source.id AS src, source.source, source.version AS srcver FROM ((bin_associations JOIN binaries ON (((bin_associations.bin = binaries.id) AND (binaries.architecture <> 2)))) JOIN source ON ((binaries.source = source.id)));
909 ALTER TABLE public.any_associations_source OWNER TO dak;
912 -- Name: src_associations_src; Type: VIEW; Schema: public; Owner: dak
915 CREATE VIEW src_associations_src AS
916 SELECT src_associations.id, src_associations.suite, source.id AS src, source.source, source.version FROM (src_associations JOIN source ON ((src_associations.source = source.id)));
919 ALTER TABLE public.src_associations_src OWNER TO dak;
922 -- Name: almost_obsolete_src_associations; Type: VIEW; Schema: public; Owner: dak
925 CREATE VIEW almost_obsolete_src_associations AS
926 SELECT src_associations_src.id, src_associations_src.src, src_associations_src.source, src_associations_src.version, src_associations_src.suite FROM (src_associations_src LEFT JOIN any_associations_source USING (src, suite)) WHERE (any_associations_source.bin IS NULL);
929 ALTER TABLE public.almost_obsolete_src_associations OWNER TO dak;
932 -- Name: architecture_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
935 CREATE SEQUENCE architecture_id_seq
943 ALTER TABLE public.architecture_id_seq OWNER TO dak;
946 -- Name: architecture; Type: TABLE; Schema: public; Owner: dak; Tablespace:
949 CREATE TABLE architecture (
950 id integer DEFAULT nextval('architecture_id_seq'::regclass) NOT NULL,
951 arch_string text NOT NULL,
953 created timestamp with time zone DEFAULT now() NOT NULL,
954 modified timestamp with time zone DEFAULT now() NOT NULL
958 ALTER TABLE public.architecture OWNER TO dak;
961 -- Name: archive_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
964 CREATE SEQUENCE archive_id_seq
972 ALTER TABLE public.archive_id_seq OWNER TO dak;
975 -- Name: archive; Type: TABLE; Schema: public; Owner: dak; Tablespace:
978 CREATE TABLE archive (
979 id integer DEFAULT nextval('archive_id_seq'::regclass) NOT NULL,
983 created timestamp with time zone DEFAULT now() NOT NULL,
984 modified timestamp with time zone DEFAULT now() NOT NULL
988 ALTER TABLE public.archive OWNER TO dak;
991 -- Name: bin_contents; Type: TABLE; Schema: public; Owner: dak; Tablespace:
994 CREATE TABLE bin_contents (
996 binary_id integer NOT NULL,
997 created timestamp with time zone DEFAULT now() NOT NULL,
998 modified timestamp with time zone DEFAULT now() NOT NULL
1002 ALTER TABLE public.bin_contents OWNER TO dak;
1005 -- Name: binaries_metadata; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1008 CREATE TABLE binaries_metadata (
1009 bin_id integer NOT NULL,
1010 key_id integer NOT NULL,
1015 ALTER TABLE public.binaries_metadata OWNER TO dak;
1018 -- Name: suite_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1021 CREATE SEQUENCE suite_id_seq
1029 ALTER TABLE public.suite_id_seq OWNER TO dak;
1032 -- Name: suite; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1035 CREATE TABLE suite (
1036 id integer DEFAULT nextval('suite_id_seq'::regclass) NOT NULL,
1037 suite_name text NOT NULL,
1042 untouchable boolean DEFAULT false NOT NULL,
1043 announce text DEFAULT 'debian-devel-changes@lists.debian.org'::text NOT NULL,
1045 overridecodename text,
1046 validtime integer DEFAULT 604800 NOT NULL,
1047 priority integer DEFAULT 0 NOT NULL,
1048 notautomatic boolean DEFAULT false NOT NULL,
1051 policy_queue_id integer,
1052 created timestamp with time zone DEFAULT now() NOT NULL,
1053 modified timestamp with time zone DEFAULT now() NOT NULL,
1055 butautomaticupgrades boolean DEFAULT false NOT NULL,
1057 CONSTRAINT bau_needs_na_set CHECK (((NOT butautomaticupgrades) OR notautomatic))
1061 ALTER TABLE public.suite OWNER TO dak;
1064 -- Name: binaries_suite_arch; Type: VIEW; Schema: public; Owner: dak
1067 CREATE VIEW binaries_suite_arch AS
1068 SELECT bin_associations.id, binaries.id AS bin, binaries.package, binaries.version, binaries.source, bin_associations.suite, suite.suite_name, binaries.architecture, architecture.arch_string FROM (((binaries JOIN bin_associations ON ((binaries.id = bin_associations.bin))) JOIN suite ON ((suite.id = bin_associations.suite))) JOIN architecture ON ((binaries.architecture = architecture.id)));
1071 ALTER TABLE public.binaries_suite_arch OWNER TO dak;
1074 -- Name: binary_acl; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1077 CREATE TABLE binary_acl (
1078 id integer NOT NULL,
1079 access_level text NOT NULL,
1080 created timestamp with time zone DEFAULT now() NOT NULL,
1081 modified timestamp with time zone DEFAULT now() NOT NULL
1085 ALTER TABLE public.binary_acl OWNER TO dak;
1088 -- Name: binary_acl_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1091 CREATE SEQUENCE binary_acl_id_seq
1099 ALTER TABLE public.binary_acl_id_seq OWNER TO dak;
1102 -- Name: binary_acl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1105 ALTER SEQUENCE binary_acl_id_seq OWNED BY binary_acl.id;
1109 -- Name: binary_acl_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1112 CREATE TABLE binary_acl_map (
1113 id integer NOT NULL,
1114 fingerprint_id integer NOT NULL,
1115 architecture_id integer NOT NULL,
1116 created timestamp with time zone DEFAULT now() NOT NULL,
1117 modified timestamp with time zone DEFAULT now() NOT NULL
1121 ALTER TABLE public.binary_acl_map OWNER TO dak;
1124 -- Name: binary_acl_map_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1127 CREATE SEQUENCE binary_acl_map_id_seq
1135 ALTER TABLE public.binary_acl_map_id_seq OWNER TO dak;
1138 -- Name: binary_acl_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1141 ALTER SEQUENCE binary_acl_map_id_seq OWNED BY binary_acl_map.id;
1145 -- Name: files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1148 CREATE SEQUENCE files_id_seq
1156 ALTER TABLE public.files_id_seq OWNER TO dak;
1159 -- Name: files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1162 CREATE TABLE files (
1163 id integer DEFAULT nextval('files_id_seq'::regclass) NOT NULL,
1164 filename text NOT NULL,
1165 size bigint NOT NULL,
1166 md5sum text NOT NULL,
1167 location integer NOT NULL,
1168 last_used timestamp with time zone,
1171 created timestamp with time zone DEFAULT now() NOT NULL,
1172 modified timestamp with time zone DEFAULT now() NOT NULL
1176 ALTER TABLE public.files OWNER TO dak;
1179 -- Name: location_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1182 CREATE SEQUENCE location_id_seq
1190 ALTER TABLE public.location_id_seq OWNER TO dak;
1193 -- Name: location; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1196 CREATE TABLE location (
1197 id integer DEFAULT nextval('location_id_seq'::regclass) NOT NULL,
1202 created timestamp with time zone DEFAULT now() NOT NULL,
1203 modified timestamp with time zone DEFAULT now() NOT NULL
1207 ALTER TABLE public.location OWNER TO dak;
1210 -- Name: binfiles_suite_component_arch; Type: VIEW; Schema: public; Owner: dak
1213 CREATE VIEW binfiles_suite_component_arch AS
1214 SELECT files.filename, binaries.type, location.path, location.component, bin_associations.suite, binaries.architecture FROM (((binaries JOIN bin_associations ON ((binaries.id = bin_associations.bin))) JOIN files ON ((binaries.file = files.id))) JOIN location ON ((files.location = location.id)));
1217 ALTER TABLE public.binfiles_suite_component_arch OWNER TO dak;
1220 -- Name: build_queue; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1223 CREATE TABLE build_queue (
1224 id integer NOT NULL,
1225 queue_name text NOT NULL,
1227 copy_files boolean DEFAULT false NOT NULL,
1228 generate_metadata boolean DEFAULT false NOT NULL,
1231 releasedescription text,
1233 stay_of_execution integer DEFAULT 86400 NOT NULL,
1234 created timestamp with time zone DEFAULT now() NOT NULL,
1235 modified timestamp with time zone DEFAULT now() NOT NULL,
1236 notautomatic boolean DEFAULT false NOT NULL,
1237 CONSTRAINT build_queue_meta_sanity_check CHECK (((generate_metadata IS FALSE) OR (((origin IS NOT NULL) AND (label IS NOT NULL)) AND (releasedescription IS NOT NULL)))),
1238 CONSTRAINT build_queue_stay_of_execution_check CHECK ((stay_of_execution >= 0))
1242 ALTER TABLE public.build_queue OWNER TO dak;
1245 -- Name: build_queue_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1248 CREATE TABLE build_queue_files (
1249 id integer NOT NULL,
1250 build_queue_id integer NOT NULL,
1251 insertdate timestamp without time zone DEFAULT now() NOT NULL,
1252 lastused timestamp without time zone,
1253 filename text NOT NULL,
1255 created timestamp with time zone DEFAULT now() NOT NULL,
1256 modified timestamp with time zone DEFAULT now() NOT NULL
1260 ALTER TABLE public.build_queue_files OWNER TO dak;
1263 -- Name: build_queue_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1266 CREATE SEQUENCE build_queue_files_id_seq
1274 ALTER TABLE public.build_queue_files_id_seq OWNER TO dak;
1277 -- Name: build_queue_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1280 ALTER SEQUENCE build_queue_files_id_seq OWNED BY build_queue_files.id;
1284 -- Name: build_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1287 CREATE SEQUENCE build_queue_id_seq
1295 ALTER TABLE public.build_queue_id_seq OWNER TO dak;
1298 -- Name: build_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1301 ALTER SEQUENCE build_queue_id_seq OWNED BY build_queue.id;
1305 -- Name: build_queue_policy_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1308 CREATE TABLE build_queue_policy_files (
1309 build_queue_id integer NOT NULL,
1310 file_id integer NOT NULL,
1311 filename text NOT NULL,
1312 created timestamp with time zone DEFAULT now() NOT NULL,
1313 lastused timestamp without time zone
1317 ALTER TABLE public.build_queue_policy_files OWNER TO dak;
1320 -- Name: changelogs_text; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1323 CREATE TABLE changelogs_text (
1324 id integer NOT NULL,
1329 ALTER TABLE public.changelogs_text OWNER TO dak;
1332 -- Name: changes; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1335 CREATE TABLE changes (
1336 id integer NOT NULL,
1337 changesname text NOT NULL,
1338 seen timestamp with time zone DEFAULT now() NOT NULL,
1339 source text NOT NULL,
1340 binaries text NOT NULL,
1341 architecture text NOT NULL,
1342 version text NOT NULL,
1343 distribution text NOT NULL,
1344 urgency text NOT NULL,
1345 maintainer text NOT NULL,
1346 fingerprint text NOT NULL,
1347 changedby text NOT NULL,
1350 approved_for integer,
1351 created timestamp with time zone DEFAULT now() NOT NULL,
1352 modified timestamp with time zone DEFAULT now() NOT NULL,
1353 changelog_id integer
1357 ALTER TABLE public.changes OWNER TO dak;
1360 -- Name: changelogs; Type: VIEW; Schema: public; Owner: dak
1363 CREATE VIEW changelogs AS
1364 SELECT cl.id, c.source, (c.version)::debversion AS version, c.architecture, cl.changelog, c.distribution FROM (changes c JOIN changelogs_text cl ON ((cl.id = c.changelog_id)));
1367 ALTER TABLE public.changelogs OWNER TO dak;
1370 -- Name: changelogs_text_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1373 CREATE SEQUENCE changelogs_text_id_seq
1381 ALTER TABLE public.changelogs_text_id_seq OWNER TO dak;
1384 -- Name: changelogs_text_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1387 ALTER SEQUENCE changelogs_text_id_seq OWNED BY changelogs_text.id;
1391 -- Name: changes_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1394 CREATE SEQUENCE changes_id_seq
1402 ALTER TABLE public.changes_id_seq OWNER TO dak;
1405 -- Name: changes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1408 ALTER SEQUENCE changes_id_seq OWNED BY changes.id;
1412 -- Name: changes_pending_binaries; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1415 CREATE TABLE changes_pending_binaries (
1416 id integer NOT NULL,
1417 change_id integer NOT NULL,
1418 package text NOT NULL,
1419 version debversion NOT NULL,
1420 architecture_id integer NOT NULL,
1422 pending_source_id integer,
1423 pending_file_id integer,
1424 created timestamp with time zone DEFAULT now() NOT NULL,
1425 modified timestamp with time zone DEFAULT now() NOT NULL,
1426 CONSTRAINT changes_pending_binaries_check CHECK (((source_id IS NOT NULL) OR (pending_source_id IS NOT NULL)))
1430 ALTER TABLE public.changes_pending_binaries OWNER TO dak;
1433 -- Name: changes_pending_binaries_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1436 CREATE SEQUENCE changes_pending_binaries_id_seq
1444 ALTER TABLE public.changes_pending_binaries_id_seq OWNER TO dak;
1447 -- Name: changes_pending_binaries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1450 ALTER SEQUENCE changes_pending_binaries_id_seq OWNED BY changes_pending_binaries.id;
1454 -- Name: changes_pending_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1457 CREATE TABLE changes_pending_files (
1458 id integer NOT NULL,
1459 filename text NOT NULL,
1460 size bigint NOT NULL,
1461 md5sum text NOT NULL,
1462 sha1sum text NOT NULL,
1463 sha256sum text NOT NULL,
1464 created timestamp with time zone DEFAULT now() NOT NULL,
1465 modified timestamp with time zone DEFAULT now() NOT NULL,
1466 processed boolean DEFAULT false
1470 ALTER TABLE public.changes_pending_files OWNER TO dak;
1473 -- Name: changes_pending_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1476 CREATE SEQUENCE changes_pending_files_id_seq
1484 ALTER TABLE public.changes_pending_files_id_seq OWNER TO dak;
1487 -- Name: changes_pending_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1490 ALTER SEQUENCE changes_pending_files_id_seq OWNED BY changes_pending_files.id;
1494 -- Name: changes_pending_files_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1497 CREATE TABLE changes_pending_files_map (
1498 file_id integer NOT NULL,
1499 change_id integer NOT NULL,
1500 created timestamp with time zone DEFAULT now() NOT NULL,
1501 modified timestamp with time zone DEFAULT now() NOT NULL
1505 ALTER TABLE public.changes_pending_files_map OWNER TO dak;
1508 -- Name: changes_pending_source; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1511 CREATE TABLE changes_pending_source (
1512 id integer NOT NULL,
1513 change_id integer NOT NULL,
1514 source text NOT NULL,
1515 version debversion NOT NULL,
1516 maintainer_id integer NOT NULL,
1517 changedby_id integer NOT NULL,
1518 sig_fpr integer NOT NULL,
1519 dm_upload_allowed boolean DEFAULT false NOT NULL,
1520 created timestamp with time zone DEFAULT now() NOT NULL,
1521 modified timestamp with time zone DEFAULT now() NOT NULL
1525 ALTER TABLE public.changes_pending_source OWNER TO dak;
1528 -- Name: changes_pending_source_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1531 CREATE TABLE changes_pending_source_files (
1532 pending_source_id integer NOT NULL,
1533 pending_file_id integer NOT NULL,
1534 created timestamp with time zone DEFAULT now() NOT NULL,
1535 modified timestamp with time zone DEFAULT now() NOT NULL
1539 ALTER TABLE public.changes_pending_source_files OWNER TO dak;
1542 -- Name: changes_pending_source_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1545 CREATE SEQUENCE changes_pending_source_id_seq
1553 ALTER TABLE public.changes_pending_source_id_seq OWNER TO dak;
1556 -- Name: changes_pending_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1559 ALTER SEQUENCE changes_pending_source_id_seq OWNED BY changes_pending_source.id;
1563 -- Name: changes_pool_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1566 CREATE TABLE changes_pool_files (
1567 changeid integer NOT NULL,
1568 fileid integer NOT NULL,
1569 created timestamp with time zone DEFAULT now() NOT NULL,
1570 modified timestamp with time zone DEFAULT now() NOT NULL
1574 ALTER TABLE public.changes_pool_files OWNER TO dak;
1577 -- Name: component_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1580 CREATE SEQUENCE component_id_seq
1588 ALTER TABLE public.component_id_seq OWNER TO dak;
1591 -- Name: component; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1594 CREATE TABLE component (
1595 id integer DEFAULT nextval('component_id_seq'::regclass) NOT NULL,
1599 created timestamp with time zone DEFAULT now() NOT NULL,
1600 modified timestamp with time zone DEFAULT now() NOT NULL
1604 ALTER TABLE public.component OWNER TO dak;
1607 -- Name: config; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1610 CREATE TABLE config (
1611 id integer NOT NULL,
1614 created timestamp with time zone DEFAULT now() NOT NULL,
1615 modified timestamp with time zone DEFAULT now() NOT NULL
1619 ALTER TABLE public.config OWNER TO dak;
1622 -- Name: config_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1625 CREATE SEQUENCE config_id_seq
1633 ALTER TABLE public.config_id_seq OWNER TO dak;
1636 -- Name: config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1639 ALTER SEQUENCE config_id_seq OWNED BY config.id;
1643 -- Name: dsc_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1646 CREATE SEQUENCE dsc_files_id_seq
1654 ALTER TABLE public.dsc_files_id_seq OWNER TO dak;
1657 -- Name: dsc_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1660 CREATE TABLE dsc_files (
1661 id integer DEFAULT nextval('dsc_files_id_seq'::regclass) NOT NULL,
1662 source integer NOT NULL,
1663 file integer NOT NULL,
1664 created timestamp with time zone DEFAULT now() NOT NULL,
1665 modified timestamp with time zone DEFAULT now() NOT NULL
1669 ALTER TABLE public.dsc_files OWNER TO dak;
1672 -- Name: external_overrides; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1675 CREATE TABLE external_overrides (
1676 package text NOT NULL,
1678 value text NOT NULL,
1679 suite integer NOT NULL,
1680 component integer NOT NULL
1684 ALTER TABLE public.external_overrides OWNER TO dak;
1687 -- Name: extra_src_references; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1690 CREATE TABLE extra_src_references (
1691 bin_id integer NOT NULL,
1692 src_id integer NOT NULL
1696 ALTER TABLE public.extra_src_references OWNER TO dak;
1699 -- Name: file_arch_suite; Type: VIEW; Schema: public; Owner: dak
1702 CREATE VIEW file_arch_suite AS
1703 SELECT f.id AS file, f.size, b.architecture, s.id AS suite FROM files f, binaries b, bin_associations ba, suite s WHERE (((f.id = b.file) AND (b.id = ba.bin)) AND (ba.suite = s.id));
1706 ALTER TABLE public.file_arch_suite OWNER TO dak;
1709 -- Name: fingerprint_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1712 CREATE SEQUENCE fingerprint_id_seq
1720 ALTER TABLE public.fingerprint_id_seq OWNER TO dak;
1723 -- Name: fingerprint; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1726 CREATE TABLE fingerprint (
1727 id integer DEFAULT nextval('fingerprint_id_seq'::regclass) NOT NULL,
1728 fingerprint text NOT NULL,
1731 source_acl_id integer,
1732 binary_acl_id integer,
1733 binary_reject boolean DEFAULT true NOT NULL,
1734 created timestamp with time zone DEFAULT now() NOT NULL,
1735 modified timestamp with time zone DEFAULT now() NOT NULL
1739 ALTER TABLE public.fingerprint OWNER TO dak;
1742 -- Name: keyring_acl_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1745 CREATE TABLE keyring_acl_map (
1746 id integer NOT NULL,
1747 keyring_id integer NOT NULL,
1748 architecture_id integer NOT NULL,
1749 created timestamp with time zone DEFAULT now() NOT NULL,
1750 modified timestamp with time zone DEFAULT now() NOT NULL
1754 ALTER TABLE public.keyring_acl_map OWNER TO dak;
1757 -- Name: keyring_acl_map_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1760 CREATE SEQUENCE keyring_acl_map_id_seq
1768 ALTER TABLE public.keyring_acl_map_id_seq OWNER TO dak;
1771 -- Name: keyring_acl_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1774 ALTER SEQUENCE keyring_acl_map_id_seq OWNED BY keyring_acl_map.id;
1778 -- Name: keyrings; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1781 CREATE TABLE keyrings (
1782 id integer NOT NULL,
1784 default_source_acl_id integer,
1785 default_binary_acl_id integer,
1786 default_binary_reject boolean DEFAULT true NOT NULL,
1787 priority integer DEFAULT 100 NOT NULL,
1788 created timestamp with time zone DEFAULT now() NOT NULL,
1789 modified timestamp with time zone DEFAULT now() NOT NULL,
1790 active boolean DEFAULT true
1794 ALTER TABLE public.keyrings OWNER TO dak;
1797 -- Name: keyrings_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1800 CREATE SEQUENCE keyrings_id_seq
1808 ALTER TABLE public.keyrings_id_seq OWNER TO dak;
1811 -- Name: keyrings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1814 ALTER SEQUENCE keyrings_id_seq OWNED BY keyrings.id;
1818 -- Name: maintainer_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1821 CREATE SEQUENCE maintainer_id_seq
1829 ALTER TABLE public.maintainer_id_seq OWNER TO dak;
1832 -- Name: maintainer; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1835 CREATE TABLE maintainer (
1836 id integer DEFAULT nextval('maintainer_id_seq'::regclass) NOT NULL,
1838 created timestamp with time zone DEFAULT now() NOT NULL,
1839 modified timestamp with time zone DEFAULT now() NOT NULL
1843 ALTER TABLE public.maintainer OWNER TO dak;
1846 -- Name: metadata_keys; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1849 CREATE TABLE metadata_keys (
1850 key_id integer NOT NULL,
1852 ordering integer DEFAULT 0 NOT NULL
1856 ALTER TABLE public.metadata_keys OWNER TO dak;
1859 -- Name: metadata_keys_key_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1862 CREATE SEQUENCE metadata_keys_key_id_seq
1870 ALTER TABLE public.metadata_keys_key_id_seq OWNER TO dak;
1873 -- Name: metadata_keys_key_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1876 ALTER SEQUENCE metadata_keys_key_id_seq OWNED BY metadata_keys.key_id;
1880 -- Name: new_comments; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1883 CREATE TABLE new_comments (
1884 id integer NOT NULL,
1885 package text NOT NULL,
1886 version text NOT NULL,
1887 comment text NOT NULL,
1888 author text NOT NULL,
1889 notedate timestamp with time zone DEFAULT now() NOT NULL,
1890 trainee boolean DEFAULT false NOT NULL,
1891 created timestamp with time zone DEFAULT now() NOT NULL,
1892 modified timestamp with time zone DEFAULT now() NOT NULL
1896 ALTER TABLE public.new_comments OWNER TO dak;
1899 -- Name: new_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1902 CREATE SEQUENCE new_comments_id_seq
1910 ALTER TABLE public.new_comments_id_seq OWNER TO dak;
1913 -- Name: new_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1916 ALTER SEQUENCE new_comments_id_seq OWNED BY new_comments.id;
1920 -- Name: newest_all_associations; Type: VIEW; Schema: public; Owner: dak
1923 CREATE VIEW newest_all_associations AS
1924 SELECT binaries_suite_arch.package, max(binaries_suite_arch.version) AS version, binaries_suite_arch.suite, binaries_suite_arch.architecture FROM binaries_suite_arch WHERE (binaries_suite_arch.architecture = 2) GROUP BY binaries_suite_arch.package, binaries_suite_arch.suite, binaries_suite_arch.architecture;
1927 ALTER TABLE public.newest_all_associations OWNER TO dak;
1930 -- Name: newest_any_associations; Type: VIEW; Schema: public; Owner: dak
1933 CREATE VIEW newest_any_associations AS
1934 SELECT binaries_suite_arch.package, max(binaries_suite_arch.version) AS version, binaries_suite_arch.suite, binaries_suite_arch.architecture FROM binaries_suite_arch WHERE (binaries_suite_arch.architecture > 2) GROUP BY binaries_suite_arch.package, binaries_suite_arch.suite, binaries_suite_arch.architecture;
1937 ALTER TABLE public.newest_any_associations OWNER TO dak;
1940 -- Name: source_suite; Type: VIEW; Schema: public; Owner: dak
1943 CREATE VIEW source_suite AS
1944 SELECT src_associations.id, source.id AS src, source.source, source.version, src_associations.suite, suite.suite_name, source.install_date FROM ((source JOIN src_associations ON ((source.id = src_associations.source))) JOIN suite ON ((suite.id = src_associations.suite)));
1947 ALTER TABLE public.source_suite OWNER TO dak;
1950 -- Name: newest_source; Type: VIEW; Schema: public; Owner: dak
1953 CREATE VIEW newest_source AS
1954 SELECT source_suite.source, max(source_suite.version) AS version, source_suite.suite FROM source_suite GROUP BY source_suite.source, source_suite.suite;
1957 ALTER TABLE public.newest_source OWNER TO dak;
1960 -- Name: newest_src_association; Type: VIEW; Schema: public; Owner: dak
1963 CREATE VIEW newest_src_association AS
1964 SELECT source_suite.id, source_suite.src, source_suite.source, source_suite.version, source_suite.suite FROM (source_suite JOIN newest_source USING (source, version, suite));
1967 ALTER TABLE public.newest_src_association OWNER TO dak;
1970 -- Name: obsolete_all_associations; Type: VIEW; Schema: public; Owner: dak
1973 CREATE VIEW obsolete_all_associations AS
1974 SELECT almost.id, almost.bin, almost.package, almost.version, almost.suite FROM (almost_obsolete_all_associations almost JOIN newest_all_associations newest ON ((((almost.package = newest.package) AND (almost.version < newest.version)) AND (almost.suite = newest.suite))));
1977 ALTER TABLE public.obsolete_all_associations OWNER TO dak;
1980 -- Name: obsolete_any_associations; Type: VIEW; Schema: public; Owner: dak
1983 CREATE VIEW obsolete_any_associations AS
1984 SELECT binaries_suite_arch.id, binaries_suite_arch.architecture, binaries_suite_arch.version, binaries_suite_arch.package, binaries_suite_arch.suite FROM (binaries_suite_arch JOIN newest_any_associations ON (((((binaries_suite_arch.architecture = newest_any_associations.architecture) AND (binaries_suite_arch.package = newest_any_associations.package)) AND (binaries_suite_arch.suite = newest_any_associations.suite)) AND (binaries_suite_arch.version <> newest_any_associations.version))));
1987 ALTER TABLE public.obsolete_any_associations OWNER TO dak;
1990 -- Name: obsolete_any_by_all_associations; Type: VIEW; Schema: public; Owner: dak
1993 CREATE VIEW obsolete_any_by_all_associations AS
1994 SELECT binaries_suite_arch.id, binaries_suite_arch.package, binaries_suite_arch.version, binaries_suite_arch.suite, binaries_suite_arch.architecture FROM (binaries_suite_arch JOIN newest_all_associations ON (((((binaries_suite_arch.package = newest_all_associations.package) AND (binaries_suite_arch.version < newest_all_associations.version)) AND (binaries_suite_arch.suite = newest_all_associations.suite)) AND (binaries_suite_arch.architecture > 2))));
1997 ALTER TABLE public.obsolete_any_by_all_associations OWNER TO dak;
2000 -- Name: obsolete_src_associations; Type: VIEW; Schema: public; Owner: dak
2003 CREATE VIEW obsolete_src_associations AS
2004 SELECT almost.id, almost.src, almost.source, almost.version, almost.suite FROM (almost_obsolete_src_associations almost JOIN newest_src_association newest ON ((((almost.source = newest.source) AND (almost.version < newest.version)) AND (almost.suite = newest.suite))));
2007 ALTER TABLE public.obsolete_src_associations OWNER TO dak;
2010 -- Name: override; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2013 CREATE TABLE override (
2014 package text NOT NULL,
2015 suite integer NOT NULL,
2016 component integer NOT NULL,
2018 section integer NOT NULL,
2019 type integer NOT NULL,
2021 created timestamp with time zone DEFAULT now() NOT NULL,
2022 modified timestamp with time zone DEFAULT now() NOT NULL
2026 ALTER TABLE public.override OWNER TO dak;
2029 -- Name: override_type_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2032 CREATE SEQUENCE override_type_id_seq
2040 ALTER TABLE public.override_type_id_seq OWNER TO dak;
2043 -- Name: override_type; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2046 CREATE TABLE override_type (
2047 id integer DEFAULT nextval('override_type_id_seq'::regclass) NOT NULL,
2049 created timestamp with time zone DEFAULT now() NOT NULL,
2050 modified timestamp with time zone DEFAULT now() NOT NULL
2054 ALTER TABLE public.override_type OWNER TO dak;
2057 -- Name: policy_queue; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2060 CREATE TABLE policy_queue (
2061 id integer NOT NULL,
2062 queue_name text NOT NULL,
2064 perms character(4) DEFAULT '0660'::bpchar NOT NULL,
2065 change_perms character(4) DEFAULT '0660'::bpchar NOT NULL,
2066 generate_metadata boolean DEFAULT false NOT NULL,
2069 releasedescription text,
2071 stay_of_execution integer DEFAULT 86400 NOT NULL,
2072 created timestamp with time zone DEFAULT now() NOT NULL,
2073 modified timestamp with time zone DEFAULT now() NOT NULL,
2074 send_to_build_queues boolean DEFAULT false NOT NULL,
2075 CONSTRAINT policy_queue_change_perms_check CHECK ((change_perms ~ similar_escape('[0-7][0-7][0-7][0-7]'::text, NULL::text))),
2076 CONSTRAINT policy_queue_meta_sanity_check CHECK (((generate_metadata IS FALSE) OR (((origin IS NOT NULL) AND (label IS NOT NULL)) AND (releasedescription IS NOT NULL)))),
2077 CONSTRAINT policy_queue_perms_check CHECK ((perms ~ similar_escape('[0-7][0-7][0-7][0-7]'::text, NULL::text))),
2078 CONSTRAINT policy_queue_stay_of_execution_check CHECK ((stay_of_execution >= 0))
2082 ALTER TABLE public.policy_queue OWNER TO dak;
2085 -- Name: policy_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2088 CREATE SEQUENCE policy_queue_id_seq
2096 ALTER TABLE public.policy_queue_id_seq OWNER TO dak;
2099 -- Name: policy_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2102 ALTER SEQUENCE policy_queue_id_seq OWNED BY policy_queue.id;
2106 -- Name: priority_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2109 CREATE SEQUENCE priority_id_seq
2117 ALTER TABLE public.priority_id_seq OWNER TO dak;
2120 -- Name: priority; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2123 CREATE TABLE priority (
2124 id integer DEFAULT nextval('priority_id_seq'::regclass) NOT NULL,
2125 priority text NOT NULL,
2126 level integer NOT NULL,
2127 created timestamp with time zone DEFAULT now() NOT NULL,
2128 modified timestamp with time zone DEFAULT now() NOT NULL
2132 ALTER TABLE public.priority OWNER TO dak;
2135 -- Name: section_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2138 CREATE SEQUENCE section_id_seq
2146 ALTER TABLE public.section_id_seq OWNER TO dak;
2149 -- Name: section; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2152 CREATE TABLE section (
2153 id integer DEFAULT nextval('section_id_seq'::regclass) NOT NULL,
2154 section text NOT NULL,
2155 created timestamp with time zone DEFAULT now() NOT NULL,
2156 modified timestamp with time zone DEFAULT now() NOT NULL
2160 ALTER TABLE public.section OWNER TO dak;
2163 -- Name: source_acl; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2166 CREATE TABLE source_acl (
2167 id integer NOT NULL,
2168 access_level text NOT NULL,
2169 created timestamp with time zone DEFAULT now() NOT NULL,
2170 modified timestamp with time zone DEFAULT now() NOT NULL
2174 ALTER TABLE public.source_acl OWNER TO dak;
2177 -- Name: source_acl_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2180 CREATE SEQUENCE source_acl_id_seq
2188 ALTER TABLE public.source_acl_id_seq OWNER TO dak;
2191 -- Name: source_acl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2194 ALTER SEQUENCE source_acl_id_seq OWNED BY source_acl.id;
2198 -- Name: source_metadata; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2201 CREATE TABLE source_metadata (
2202 src_id integer NOT NULL,
2203 key_id integer NOT NULL,
2208 ALTER TABLE public.source_metadata OWNER TO dak;
2211 -- Name: src_contents; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2214 CREATE TABLE src_contents (
2216 source_id integer NOT NULL,
2217 created timestamp with time zone DEFAULT now() NOT NULL,
2218 modified timestamp with time zone DEFAULT now() NOT NULL
2222 ALTER TABLE public.src_contents OWNER TO dak;
2225 -- Name: src_format; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2228 CREATE TABLE src_format (
2229 id integer NOT NULL,
2230 format_name text NOT NULL,
2231 created timestamp with time zone DEFAULT now() NOT NULL,
2232 modified timestamp with time zone DEFAULT now() NOT NULL
2236 ALTER TABLE public.src_format OWNER TO dak;
2239 -- Name: src_format_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2242 CREATE SEQUENCE src_format_id_seq
2250 ALTER TABLE public.src_format_id_seq OWNER TO dak;
2253 -- Name: src_format_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2256 ALTER SEQUENCE src_format_id_seq OWNED BY src_format.id;
2260 -- Name: src_uploaders; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2263 CREATE TABLE src_uploaders (
2264 id integer NOT NULL,
2265 source integer NOT NULL,
2266 maintainer integer NOT NULL,
2267 created timestamp with time zone DEFAULT now() NOT NULL,
2268 modified timestamp with time zone DEFAULT now() NOT NULL
2272 ALTER TABLE public.src_uploaders OWNER TO dak;
2275 -- Name: src_uploaders_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2278 CREATE SEQUENCE src_uploaders_id_seq
2286 ALTER TABLE public.src_uploaders_id_seq OWNER TO dak;
2289 -- Name: src_uploaders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2292 ALTER SEQUENCE src_uploaders_id_seq OWNED BY src_uploaders.id;
2296 -- Name: suite_architectures; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2299 CREATE TABLE suite_architectures (
2300 suite integer NOT NULL,
2301 architecture integer NOT NULL,
2302 created timestamp with time zone DEFAULT now() NOT NULL,
2303 modified timestamp with time zone DEFAULT now() NOT NULL
2307 ALTER TABLE public.suite_architectures OWNER TO dak;
2310 -- Name: suite_arch_by_name; Type: VIEW; Schema: public; Owner: dak
2313 CREATE VIEW suite_arch_by_name AS
2314 SELECT suite.suite_name AS suite, a.arch_string AS arch FROM ((suite_architectures sa JOIN architecture a ON ((sa.architecture = a.id))) JOIN suite ON ((sa.suite = suite.id))) WHERE (a.arch_string <> ALL (ARRAY['all'::text, 'source'::text]));
2317 ALTER TABLE public.suite_arch_by_name OWNER TO dak;
2320 -- Name: suite_build_queue_copy; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2323 CREATE TABLE suite_build_queue_copy (
2324 suite integer NOT NULL,
2325 build_queue_id integer NOT NULL,
2326 created timestamp with time zone DEFAULT now() NOT NULL,
2327 modified timestamp with time zone DEFAULT now() NOT NULL
2331 ALTER TABLE public.suite_build_queue_copy OWNER TO dak;
2334 -- Name: suite_src_formats; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2337 CREATE TABLE suite_src_formats (
2338 suite integer NOT NULL,
2339 src_format integer NOT NULL,
2340 created timestamp with time zone DEFAULT now() NOT NULL,
2341 modified timestamp with time zone DEFAULT now() NOT NULL
2345 ALTER TABLE public.suite_src_formats OWNER TO dak;
2348 -- Name: uid_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2351 CREATE SEQUENCE uid_id_seq
2359 ALTER TABLE public.uid_id_seq OWNER TO dak;
2362 -- Name: uid; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2366 id integer DEFAULT nextval('uid_id_seq'::regclass) NOT NULL,
2369 created timestamp with time zone DEFAULT now() NOT NULL,
2370 modified timestamp with time zone DEFAULT now() NOT NULL
2374 ALTER TABLE public.uid OWNER TO dak;
2377 -- Name: upload_blocks; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2380 CREATE TABLE upload_blocks (
2381 id integer NOT NULL,
2382 source text NOT NULL,
2384 fingerprint_id integer,
2386 reason text NOT NULL,
2387 created timestamp with time zone DEFAULT now() NOT NULL,
2388 modified timestamp with time zone DEFAULT now() NOT NULL,
2389 CONSTRAINT upload_blocks_check CHECK (((fingerprint_id IS NOT NULL) OR (uid_id IS NOT NULL)))
2393 ALTER TABLE public.upload_blocks OWNER TO dak;
2396 -- Name: upload_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2399 CREATE SEQUENCE upload_blocks_id_seq
2407 ALTER TABLE public.upload_blocks_id_seq OWNER TO dak;
2410 -- Name: upload_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2413 ALTER SEQUENCE upload_blocks_id_seq OWNED BY upload_blocks.id;
2417 -- Name: version_check; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2420 CREATE TABLE version_check (
2421 suite integer NOT NULL,
2422 "check" text NOT NULL,
2423 reference integer NOT NULL,
2424 CONSTRAINT version_check_check_check CHECK (("check" = ANY (ARRAY['Enhances'::text, 'MustBeNewerThan'::text, 'MustBeOlderThan'::text])))
2428 ALTER TABLE public.version_check OWNER TO dak;
2431 -- Name: version_checks; Type: VIEW; Schema: public; Owner: dak
2434 CREATE VIEW version_checks AS
2435 SELECT s.suite_name AS source_suite, v."check" AS condition, t.suite_name AS target_suite FROM ((suite s JOIN version_check v ON ((s.id = v.suite))) JOIN suite t ON ((v.reference = t.id))) ORDER BY s.suite_name, v."check", t.suite_name;
2438 ALTER TABLE public.version_checks OWNER TO dak;
2441 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2444 ALTER TABLE binary_acl ALTER COLUMN id SET DEFAULT nextval('binary_acl_id_seq'::regclass);
2448 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2451 ALTER TABLE binary_acl_map ALTER COLUMN id SET DEFAULT nextval('binary_acl_map_id_seq'::regclass);
2455 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2458 ALTER TABLE build_queue ALTER COLUMN id SET DEFAULT nextval('build_queue_id_seq'::regclass);
2462 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2465 ALTER TABLE build_queue_files ALTER COLUMN id SET DEFAULT nextval('build_queue_files_id_seq'::regclass);
2469 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2472 ALTER TABLE changelogs_text ALTER COLUMN id SET DEFAULT nextval('changelogs_text_id_seq'::regclass);
2476 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2479 ALTER TABLE changes ALTER COLUMN id SET DEFAULT nextval('changes_id_seq'::regclass);
2483 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2486 ALTER TABLE changes_pending_binaries ALTER COLUMN id SET DEFAULT nextval('changes_pending_binaries_id_seq'::regclass);
2490 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2493 ALTER TABLE changes_pending_files ALTER COLUMN id SET DEFAULT nextval('changes_pending_files_id_seq'::regclass);
2497 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2500 ALTER TABLE changes_pending_source ALTER COLUMN id SET DEFAULT nextval('changes_pending_source_id_seq'::regclass);
2504 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2507 ALTER TABLE config ALTER COLUMN id SET DEFAULT nextval('config_id_seq'::regclass);
2511 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2514 ALTER TABLE keyring_acl_map ALTER COLUMN id SET DEFAULT nextval('keyring_acl_map_id_seq'::regclass);
2518 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2521 ALTER TABLE keyrings ALTER COLUMN id SET DEFAULT nextval('keyrings_id_seq'::regclass);
2525 -- Name: key_id; Type: DEFAULT; Schema: public; Owner: dak
2528 ALTER TABLE metadata_keys ALTER COLUMN key_id SET DEFAULT nextval('metadata_keys_key_id_seq'::regclass);
2532 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2535 ALTER TABLE new_comments ALTER COLUMN id SET DEFAULT nextval('new_comments_id_seq'::regclass);
2539 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2542 ALTER TABLE policy_queue ALTER COLUMN id SET DEFAULT nextval('policy_queue_id_seq'::regclass);
2546 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2549 ALTER TABLE source_acl ALTER COLUMN id SET DEFAULT nextval('source_acl_id_seq'::regclass);
2553 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2556 ALTER TABLE src_format ALTER COLUMN id SET DEFAULT nextval('src_format_id_seq'::regclass);
2560 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2563 ALTER TABLE src_uploaders ALTER COLUMN id SET DEFAULT nextval('src_uploaders_id_seq'::regclass);
2567 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2570 ALTER TABLE upload_blocks ALTER COLUMN id SET DEFAULT nextval('upload_blocks_id_seq'::regclass);
2574 -- Name: architecture_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2577 ALTER TABLE ONLY architecture
2578 ADD CONSTRAINT architecture_pkey PRIMARY KEY (id);
2582 -- Name: archive_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2585 ALTER TABLE ONLY archive
2586 ADD CONSTRAINT archive_pkey PRIMARY KEY (id);
2590 -- Name: bin_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2593 ALTER TABLE ONLY bin_associations
2594 ADD CONSTRAINT bin_associations_pkey PRIMARY KEY (id);
2598 -- Name: bin_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2601 ALTER TABLE ONLY bin_contents
2602 ADD CONSTRAINT bin_contents_pkey PRIMARY KEY (file, binary_id);
2606 -- Name: binaries_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2609 ALTER TABLE ONLY binaries_metadata
2610 ADD CONSTRAINT binaries_metadata_pkey PRIMARY KEY (bin_id, key_id);
2614 -- Name: binaries_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2617 ALTER TABLE ONLY binaries
2618 ADD CONSTRAINT binaries_pkey PRIMARY KEY (id);
2622 -- Name: binary_acl_access_level_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2625 ALTER TABLE ONLY binary_acl
2626 ADD CONSTRAINT binary_acl_access_level_key UNIQUE (access_level);
2630 -- Name: binary_acl_map_fingerprint_id_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2633 ALTER TABLE ONLY binary_acl_map
2634 ADD CONSTRAINT binary_acl_map_fingerprint_id_key UNIQUE (fingerprint_id, architecture_id);
2638 -- Name: binary_acl_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2641 ALTER TABLE ONLY binary_acl_map
2642 ADD CONSTRAINT binary_acl_map_pkey PRIMARY KEY (id);
2646 -- Name: binary_acl_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2649 ALTER TABLE ONLY binary_acl
2650 ADD CONSTRAINT binary_acl_pkey PRIMARY KEY (id);
2654 -- Name: build_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2657 ALTER TABLE ONLY build_queue
2658 ADD CONSTRAINT build_queue_pkey PRIMARY KEY (id);
2662 -- Name: build_queue_policy_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2665 ALTER TABLE ONLY build_queue_policy_files
2666 ADD CONSTRAINT build_queue_policy_files_pkey PRIMARY KEY (build_queue_id, file_id);
2670 -- Name: build_queue_queue_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2673 ALTER TABLE ONLY build_queue
2674 ADD CONSTRAINT build_queue_queue_name_key UNIQUE (queue_name);
2678 -- Name: changelogs_text_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2681 ALTER TABLE ONLY changelogs_text
2682 ADD CONSTRAINT changelogs_text_pkey PRIMARY KEY (id);
2686 -- Name: changes_pending_binaries_package_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2689 ALTER TABLE ONLY changes_pending_binaries
2690 ADD CONSTRAINT changes_pending_binaries_package_key UNIQUE (package, version, architecture_id);
2694 -- Name: changes_pending_binaries_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2697 ALTER TABLE ONLY changes_pending_binaries
2698 ADD CONSTRAINT changes_pending_binaries_pkey PRIMARY KEY (id);
2702 -- Name: changes_pending_files_filename_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2705 ALTER TABLE ONLY changes_pending_files
2706 ADD CONSTRAINT changes_pending_files_filename_key UNIQUE (filename);
2710 -- Name: changes_pending_files_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2713 ALTER TABLE ONLY changes_pending_files_map
2714 ADD CONSTRAINT changes_pending_files_map_pkey PRIMARY KEY (file_id, change_id);
2718 -- Name: changes_pending_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2721 ALTER TABLE ONLY changes_pending_files
2722 ADD CONSTRAINT changes_pending_files_pkey PRIMARY KEY (id);
2726 -- Name: changes_pending_source_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2729 ALTER TABLE ONLY changes_pending_source_files
2730 ADD CONSTRAINT changes_pending_source_files_pkey PRIMARY KEY (pending_source_id, pending_file_id);
2734 -- Name: changes_pending_source_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2737 ALTER TABLE ONLY changes_pending_source
2738 ADD CONSTRAINT changes_pending_source_pkey PRIMARY KEY (id);
2742 -- Name: changes_pool_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2745 ALTER TABLE ONLY changes_pool_files
2746 ADD CONSTRAINT changes_pool_files_pkey PRIMARY KEY (changeid, fileid);
2750 -- Name: component_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2753 ALTER TABLE ONLY component
2754 ADD CONSTRAINT component_pkey PRIMARY KEY (id);
2758 -- Name: config_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2761 ALTER TABLE ONLY config
2762 ADD CONSTRAINT config_name_key UNIQUE (name);
2766 -- Name: config_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2769 ALTER TABLE ONLY config
2770 ADD CONSTRAINT config_pkey PRIMARY KEY (id);
2774 -- Name: dsc_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2777 ALTER TABLE ONLY dsc_files
2778 ADD CONSTRAINT dsc_files_pkey PRIMARY KEY (id);
2782 -- Name: external_overrides_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2785 ALTER TABLE ONLY external_overrides
2786 ADD CONSTRAINT external_overrides_pkey PRIMARY KEY (suite, component, package, key);
2790 -- Name: extra_src_references_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2793 ALTER TABLE ONLY extra_src_references
2794 ADD CONSTRAINT extra_src_references_pkey PRIMARY KEY (bin_id, src_id);
2798 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2801 ALTER TABLE ONLY files
2802 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
2806 -- Name: fingerprint_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2809 ALTER TABLE ONLY fingerprint
2810 ADD CONSTRAINT fingerprint_pkey PRIMARY KEY (id);
2814 -- Name: keyring_acl_map_keyring_id_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2817 ALTER TABLE ONLY keyring_acl_map
2818 ADD CONSTRAINT keyring_acl_map_keyring_id_key UNIQUE (keyring_id, architecture_id);
2822 -- Name: keyring_acl_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2825 ALTER TABLE ONLY keyring_acl_map
2826 ADD CONSTRAINT keyring_acl_map_pkey PRIMARY KEY (id);
2830 -- Name: keyrings_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2833 ALTER TABLE ONLY keyrings
2834 ADD CONSTRAINT keyrings_name_key UNIQUE (name);
2838 -- Name: keyrings_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2841 ALTER TABLE ONLY keyrings
2842 ADD CONSTRAINT keyrings_pkey PRIMARY KEY (id);
2846 -- Name: known_changes_changesname_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2849 ALTER TABLE ONLY changes
2850 ADD CONSTRAINT known_changes_changesname_key UNIQUE (changesname);
2854 -- Name: known_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2857 ALTER TABLE ONLY changes
2858 ADD CONSTRAINT known_changes_pkey PRIMARY KEY (id);
2862 -- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2865 ALTER TABLE ONLY location
2866 ADD CONSTRAINT location_pkey PRIMARY KEY (id);
2870 -- Name: maintainer_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2873 ALTER TABLE ONLY maintainer
2874 ADD CONSTRAINT maintainer_pkey PRIMARY KEY (id);
2878 -- Name: metadata_keys_key_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2881 ALTER TABLE ONLY metadata_keys
2882 ADD CONSTRAINT metadata_keys_key_key UNIQUE (key);
2886 -- Name: metadata_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2889 ALTER TABLE ONLY metadata_keys
2890 ADD CONSTRAINT metadata_keys_pkey PRIMARY KEY (key_id);
2894 -- Name: new_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2897 ALTER TABLE ONLY new_comments
2898 ADD CONSTRAINT new_comments_pkey PRIMARY KEY (id);
2902 -- Name: override_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2905 ALTER TABLE ONLY override
2906 ADD CONSTRAINT override_pkey PRIMARY KEY (suite, component, package, type);
2910 -- Name: override_type_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2913 ALTER TABLE ONLY override_type
2914 ADD CONSTRAINT override_type_pkey PRIMARY KEY (id);
2918 -- Name: policy_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2921 ALTER TABLE ONLY policy_queue
2922 ADD CONSTRAINT policy_queue_pkey PRIMARY KEY (id);
2926 -- Name: policy_queue_queue_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2929 ALTER TABLE ONLY policy_queue
2930 ADD CONSTRAINT policy_queue_queue_name_key UNIQUE (queue_name);
2934 -- Name: priority_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2937 ALTER TABLE ONLY priority
2938 ADD CONSTRAINT priority_pkey PRIMARY KEY (id);
2942 -- Name: queue_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2945 ALTER TABLE ONLY build_queue_files
2946 ADD CONSTRAINT queue_files_pkey PRIMARY KEY (id);
2950 -- Name: section_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2953 ALTER TABLE ONLY section
2954 ADD CONSTRAINT section_pkey PRIMARY KEY (id);
2958 -- Name: source_acl_access_level_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2961 ALTER TABLE ONLY source_acl
2962 ADD CONSTRAINT source_acl_access_level_key UNIQUE (access_level);
2966 -- Name: source_acl_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2969 ALTER TABLE ONLY source_acl
2970 ADD CONSTRAINT source_acl_pkey PRIMARY KEY (id);
2974 -- Name: source_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2977 ALTER TABLE ONLY source_metadata
2978 ADD CONSTRAINT source_metadata_pkey PRIMARY KEY (src_id, key_id);
2982 -- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2985 ALTER TABLE ONLY source
2986 ADD CONSTRAINT source_pkey PRIMARY KEY (id);
2990 -- Name: src_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2993 ALTER TABLE ONLY src_associations
2994 ADD CONSTRAINT src_associations_pkey PRIMARY KEY (id);
2998 -- Name: src_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3001 ALTER TABLE ONLY src_contents
3002 ADD CONSTRAINT src_contents_pkey PRIMARY KEY (file, source_id);
3006 -- Name: src_format_format_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3009 ALTER TABLE ONLY src_format
3010 ADD CONSTRAINT src_format_format_name_key UNIQUE (format_name);
3014 -- Name: src_format_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3017 ALTER TABLE ONLY src_format
3018 ADD CONSTRAINT src_format_pkey PRIMARY KEY (id);
3022 -- Name: src_uploaders_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3025 ALTER TABLE ONLY src_uploaders
3026 ADD CONSTRAINT src_uploaders_pkey PRIMARY KEY (id);
3030 -- Name: src_uploaders_source_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3033 ALTER TABLE ONLY src_uploaders
3034 ADD CONSTRAINT src_uploaders_source_key UNIQUE (source, maintainer);
3038 -- Name: suite_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3041 ALTER TABLE ONLY suite_architectures
3042 ADD CONSTRAINT suite_architectures_pkey PRIMARY KEY (suite, architecture);
3046 -- Name: suite_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3049 ALTER TABLE ONLY suite
3050 ADD CONSTRAINT suite_pkey PRIMARY KEY (id);
3054 -- Name: suite_queue_copy_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3057 ALTER TABLE ONLY suite_build_queue_copy
3058 ADD CONSTRAINT suite_queue_copy_pkey PRIMARY KEY (suite, build_queue_id);
3062 -- Name: suite_src_formats_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3065 ALTER TABLE ONLY suite_src_formats
3066 ADD CONSTRAINT suite_src_formats_pkey PRIMARY KEY (suite, src_format);
3070 -- Name: suite_src_formats_suite_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3073 ALTER TABLE ONLY suite_src_formats
3074 ADD CONSTRAINT suite_src_formats_suite_key UNIQUE (suite, src_format);
3078 -- Name: uid_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3081 ALTER TABLE ONLY uid
3082 ADD CONSTRAINT uid_pkey PRIMARY KEY (id);
3086 -- Name: upload_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3089 ALTER TABLE ONLY upload_blocks
3090 ADD CONSTRAINT upload_blocks_pkey PRIMARY KEY (id);
3094 -- Name: version_check_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3097 ALTER TABLE ONLY version_check
3098 ADD CONSTRAINT version_check_pkey PRIMARY KEY (suite, "check", reference);
3102 -- Name: architecture_arch_string_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3105 CREATE UNIQUE INDEX architecture_arch_string_key ON architecture USING btree (arch_string);
3109 -- Name: archive_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3112 CREATE UNIQUE INDEX archive_name_key ON archive USING btree (name);
3116 -- Name: bin_associations_bin; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3119 CREATE INDEX bin_associations_bin ON bin_associations USING btree (bin);
3123 -- Name: bin_associations_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3126 CREATE UNIQUE INDEX bin_associations_suite_key ON bin_associations USING btree (suite, bin);
3130 -- Name: binaries_architecture_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3133 CREATE INDEX binaries_architecture_idx ON binaries USING btree (architecture);
3137 -- Name: binaries_by_package; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3140 CREATE INDEX binaries_by_package ON binaries USING btree (id, package);
3144 -- Name: binaries_file_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3147 CREATE UNIQUE INDEX binaries_file_key ON binaries USING btree (file);
3151 -- Name: binaries_files; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3154 CREATE INDEX binaries_files ON binaries USING btree (file);
3158 -- Name: binaries_fingerprint; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3161 CREATE INDEX binaries_fingerprint ON binaries USING btree (sig_fpr);
3165 -- Name: binaries_id; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3168 CREATE UNIQUE INDEX binaries_id ON binaries USING btree (id);
3172 -- Name: binaries_maintainer; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3175 CREATE INDEX binaries_maintainer ON binaries USING btree (maintainer);
3179 -- Name: binaries_package_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3182 CREATE UNIQUE INDEX binaries_package_key ON binaries USING btree (package, version, architecture);
3186 -- Name: changesapproved_for; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3189 CREATE INDEX changesapproved_for ON changes USING btree (approved_for);
3193 -- Name: changesdistribution_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3196 CREATE INDEX changesdistribution_ind ON changes USING btree (distribution);
3200 -- Name: changesin_queue; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3203 CREATE INDEX changesin_queue ON changes USING btree (in_queue);
3207 -- Name: changesin_queue_approved_for; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3210 CREATE INDEX changesin_queue_approved_for ON changes USING btree (in_queue, approved_for);
3214 -- Name: changesname_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3217 CREATE INDEX changesname_ind ON changes USING btree (changesname);
3221 -- Name: changessource_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3224 CREATE INDEX changessource_ind ON changes USING btree (source);
3228 -- Name: changestimestamp_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3231 CREATE INDEX changestimestamp_ind ON changes USING btree (seen);
3235 -- Name: changesurgency_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3238 CREATE INDEX changesurgency_ind ON changes USING btree (urgency);
3242 -- Name: component_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3245 CREATE UNIQUE INDEX component_name_key ON component USING btree (name);
3249 -- Name: dsc_files_file; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3252 CREATE INDEX dsc_files_file ON dsc_files USING btree (file);
3256 -- Name: dsc_files_source_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3259 CREATE UNIQUE INDEX dsc_files_source_key ON dsc_files USING btree (source, file);
3263 -- Name: files_filename_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3266 CREATE UNIQUE INDEX files_filename_key ON files USING btree (filename, location);
3270 -- Name: files_last_used; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3273 CREATE INDEX files_last_used ON files USING btree (last_used);
3277 -- Name: fingerprint_fingerprint_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3280 CREATE UNIQUE INDEX fingerprint_fingerprint_key ON fingerprint USING btree (fingerprint);
3284 -- Name: ind_bin_contents_binary; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3287 CREATE INDEX ind_bin_contents_binary ON bin_contents USING btree (binary_id);
3291 -- Name: jjt; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3294 CREATE INDEX jjt ON files USING btree (id);
3298 -- Name: jjt2; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3301 CREATE INDEX jjt2 ON files USING btree (location);
3305 -- Name: jjt3; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3308 CREATE INDEX jjt3 ON files USING btree (id, location);
3312 -- Name: jjt4; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3315 CREATE INDEX jjt4 ON binaries USING btree (source);
3319 -- Name: jjt5; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3322 CREATE INDEX jjt5 ON binaries USING btree (id, source);
3326 -- Name: jjt_override_type_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3329 CREATE INDEX jjt_override_type_idx ON override USING btree (type);
3333 -- Name: maintainer_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3336 CREATE UNIQUE INDEX maintainer_name_key ON maintainer USING btree (name);
3340 -- Name: override_by_package; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3343 CREATE INDEX override_by_package ON override USING btree (package);
3347 -- Name: override_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3350 CREATE UNIQUE INDEX override_suite_key ON override USING btree (suite, component, package, type);
3354 -- Name: override_type_type_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3357 CREATE UNIQUE INDEX override_type_type_key ON override_type USING btree (type);
3361 -- Name: priority_level_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3364 CREATE UNIQUE INDEX priority_level_key ON priority USING btree (level);
3368 -- Name: priority_priority_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3371 CREATE UNIQUE INDEX priority_priority_key ON priority USING btree (priority);
3375 -- Name: section_section_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3378 CREATE UNIQUE INDEX section_section_key ON section USING btree (section);
3382 -- Name: source_file_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3385 CREATE UNIQUE INDEX source_file_key ON source USING btree (file);
3389 -- Name: source_fingerprint; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3392 CREATE INDEX source_fingerprint ON source USING btree (sig_fpr);
3396 -- Name: source_maintainer; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3399 CREATE INDEX source_maintainer ON source USING btree (maintainer);
3403 -- Name: source_source_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3406 CREATE UNIQUE INDEX source_source_key ON source USING btree (source, version);
3410 -- Name: src_associations_source; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3413 CREATE INDEX src_associations_source ON src_associations USING btree (source);
3417 -- Name: src_associations_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3420 CREATE UNIQUE INDEX src_associations_suite_key ON src_associations USING btree (suite, source);
3424 -- Name: src_contents_source_id_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3427 CREATE INDEX src_contents_source_id_idx ON src_contents USING btree (source_id);
3431 -- Name: suite_architectures_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3434 CREATE UNIQUE INDEX suite_architectures_suite_key ON suite_architectures USING btree (suite, architecture);
3438 -- Name: suite_hash; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3441 CREATE INDEX suite_hash ON suite USING hash (suite_name);
3445 -- Name: uid_uid_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3448 CREATE UNIQUE INDEX uid_uid_key ON uid USING btree (uid);
3452 -- Name: modified_architecture; Type: TRIGGER; Schema: public; Owner: dak
3455 CREATE TRIGGER modified_architecture BEFORE UPDATE ON architecture FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3459 -- Name: modified_archive; Type: TRIGGER; Schema: public; Owner: dak
3462 CREATE TRIGGER modified_archive BEFORE UPDATE ON archive FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3466 -- Name: modified_bin_associations; Type: TRIGGER; Schema: public; Owner: dak
3469 CREATE TRIGGER modified_bin_associations BEFORE UPDATE ON bin_associations FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3473 -- Name: modified_bin_contents; Type: TRIGGER; Schema: public; Owner: dak
3476 CREATE TRIGGER modified_bin_contents BEFORE UPDATE ON bin_contents FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3480 -- Name: modified_binaries; Type: TRIGGER; Schema: public; Owner: dak
3483 CREATE TRIGGER modified_binaries BEFORE UPDATE ON binaries FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3487 -- Name: modified_binary_acl; Type: TRIGGER; Schema: public; Owner: dak
3490 CREATE TRIGGER modified_binary_acl BEFORE UPDATE ON binary_acl FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3494 -- Name: modified_binary_acl_map; Type: TRIGGER; Schema: public; Owner: dak
3497 CREATE TRIGGER modified_binary_acl_map BEFORE UPDATE ON binary_acl_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3501 -- Name: modified_build_queue; Type: TRIGGER; Schema: public; Owner: dak
3504 CREATE TRIGGER modified_build_queue BEFORE UPDATE ON build_queue FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3508 -- Name: modified_build_queue_files; Type: TRIGGER; Schema: public; Owner: dak
3511 CREATE TRIGGER modified_build_queue_files BEFORE UPDATE ON build_queue_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3515 -- Name: modified_changes; Type: TRIGGER; Schema: public; Owner: dak
3518 CREATE TRIGGER modified_changes BEFORE UPDATE ON changes FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3522 -- Name: modified_changes_pending_binaries; Type: TRIGGER; Schema: public; Owner: dak
3525 CREATE TRIGGER modified_changes_pending_binaries BEFORE UPDATE ON changes_pending_binaries FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3529 -- Name: modified_changes_pending_files; Type: TRIGGER; Schema: public; Owner: dak
3532 CREATE TRIGGER modified_changes_pending_files BEFORE UPDATE ON changes_pending_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3536 -- Name: modified_changes_pending_files_map; Type: TRIGGER; Schema: public; Owner: dak
3539 CREATE TRIGGER modified_changes_pending_files_map BEFORE UPDATE ON changes_pending_files_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3543 -- Name: modified_changes_pending_source; Type: TRIGGER; Schema: public; Owner: dak
3546 CREATE TRIGGER modified_changes_pending_source BEFORE UPDATE ON changes_pending_source FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3550 -- Name: modified_changes_pending_source_files; Type: TRIGGER; Schema: public; Owner: dak
3553 CREATE TRIGGER modified_changes_pending_source_files BEFORE UPDATE ON changes_pending_source_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3557 -- Name: modified_changes_pool_files; Type: TRIGGER; Schema: public; Owner: dak
3560 CREATE TRIGGER modified_changes_pool_files BEFORE UPDATE ON changes_pool_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3564 -- Name: modified_component; Type: TRIGGER; Schema: public; Owner: dak
3567 CREATE TRIGGER modified_component BEFORE UPDATE ON component FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3571 -- Name: modified_config; Type: TRIGGER; Schema: public; Owner: dak
3574 CREATE TRIGGER modified_config BEFORE UPDATE ON config FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3578 -- Name: modified_dsc_files; Type: TRIGGER; Schema: public; Owner: dak
3581 CREATE TRIGGER modified_dsc_files BEFORE UPDATE ON dsc_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3585 -- Name: modified_files; Type: TRIGGER; Schema: public; Owner: dak
3588 CREATE TRIGGER modified_files BEFORE UPDATE ON files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3592 -- Name: modified_fingerprint; Type: TRIGGER; Schema: public; Owner: dak
3595 CREATE TRIGGER modified_fingerprint BEFORE UPDATE ON fingerprint FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3599 -- Name: modified_keyring_acl_map; Type: TRIGGER; Schema: public; Owner: dak
3602 CREATE TRIGGER modified_keyring_acl_map BEFORE UPDATE ON keyring_acl_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3606 -- Name: modified_keyrings; Type: TRIGGER; Schema: public; Owner: dak
3609 CREATE TRIGGER modified_keyrings BEFORE UPDATE ON keyrings FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3613 -- Name: modified_location; Type: TRIGGER; Schema: public; Owner: dak
3616 CREATE TRIGGER modified_location BEFORE UPDATE ON location FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3620 -- Name: modified_maintainer; Type: TRIGGER; Schema: public; Owner: dak
3623 CREATE TRIGGER modified_maintainer BEFORE UPDATE ON maintainer FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3627 -- Name: modified_new_comments; Type: TRIGGER; Schema: public; Owner: dak
3630 CREATE TRIGGER modified_new_comments BEFORE UPDATE ON new_comments FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3634 -- Name: modified_override; Type: TRIGGER; Schema: public; Owner: dak
3637 CREATE TRIGGER modified_override BEFORE UPDATE ON override FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3641 -- Name: modified_override_type; Type: TRIGGER; Schema: public; Owner: dak
3644 CREATE TRIGGER modified_override_type BEFORE UPDATE ON override_type FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3648 -- Name: modified_policy_queue; Type: TRIGGER; Schema: public; Owner: dak
3651 CREATE TRIGGER modified_policy_queue BEFORE UPDATE ON policy_queue FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3655 -- Name: modified_priority; Type: TRIGGER; Schema: public; Owner: dak
3658 CREATE TRIGGER modified_priority BEFORE UPDATE ON priority FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3662 -- Name: modified_section; Type: TRIGGER; Schema: public; Owner: dak
3665 CREATE TRIGGER modified_section BEFORE UPDATE ON section FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3669 -- Name: modified_source; Type: TRIGGER; Schema: public; Owner: dak
3672 CREATE TRIGGER modified_source BEFORE UPDATE ON source FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3676 -- Name: modified_source_acl; Type: TRIGGER; Schema: public; Owner: dak
3679 CREATE TRIGGER modified_source_acl BEFORE UPDATE ON source_acl FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3683 -- Name: modified_src_associations; Type: TRIGGER; Schema: public; Owner: dak
3686 CREATE TRIGGER modified_src_associations BEFORE UPDATE ON src_associations FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3690 -- Name: modified_src_contents; Type: TRIGGER; Schema: public; Owner: dak
3693 CREATE TRIGGER modified_src_contents BEFORE UPDATE ON src_contents FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3697 -- Name: modified_src_format; Type: TRIGGER; Schema: public; Owner: dak
3700 CREATE TRIGGER modified_src_format BEFORE UPDATE ON src_format FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3704 -- Name: modified_src_uploaders; Type: TRIGGER; Schema: public; Owner: dak
3707 CREATE TRIGGER modified_src_uploaders BEFORE UPDATE ON src_uploaders FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3711 -- Name: modified_suite; Type: TRIGGER; Schema: public; Owner: dak
3714 CREATE TRIGGER modified_suite BEFORE UPDATE ON suite FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3718 -- Name: modified_suite_architectures; Type: TRIGGER; Schema: public; Owner: dak
3721 CREATE TRIGGER modified_suite_architectures BEFORE UPDATE ON suite_architectures FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3725 -- Name: modified_suite_build_queue_copy; Type: TRIGGER; Schema: public; Owner: dak
3728 CREATE TRIGGER modified_suite_build_queue_copy BEFORE UPDATE ON suite_build_queue_copy FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3732 -- Name: modified_suite_src_formats; Type: TRIGGER; Schema: public; Owner: dak
3735 CREATE TRIGGER modified_suite_src_formats BEFORE UPDATE ON suite_src_formats FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3739 -- Name: modified_uid; Type: TRIGGER; Schema: public; Owner: dak
3742 CREATE TRIGGER modified_uid BEFORE UPDATE ON uid FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3746 -- Name: modified_upload_blocks; Type: TRIGGER; Schema: public; Owner: dak
3749 CREATE TRIGGER modified_upload_blocks BEFORE UPDATE ON upload_blocks FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3753 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: dak
3756 ALTER TABLE ONLY fingerprint
3757 ADD CONSTRAINT "$1" FOREIGN KEY (keyring) REFERENCES keyrings(id);
3761 -- Name: bin_associations_bin; Type: FK CONSTRAINT; Schema: public; Owner: dak
3764 ALTER TABLE ONLY bin_associations
3765 ADD CONSTRAINT bin_associations_bin FOREIGN KEY (bin) REFERENCES binaries(id) MATCH FULL;
3769 -- Name: bin_associations_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
3772 ALTER TABLE ONLY bin_associations
3773 ADD CONSTRAINT bin_associations_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
3777 -- Name: bin_contents_bin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3780 ALTER TABLE ONLY bin_contents
3781 ADD CONSTRAINT bin_contents_bin_fkey FOREIGN KEY (binary_id) REFERENCES binaries(id) ON DELETE CASCADE;
3785 -- Name: binaries_architecture; Type: FK CONSTRAINT; Schema: public; Owner: dak
3788 ALTER TABLE ONLY binaries
3789 ADD CONSTRAINT binaries_architecture FOREIGN KEY (architecture) REFERENCES architecture(id) MATCH FULL;
3793 -- Name: binaries_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
3796 ALTER TABLE ONLY binaries
3797 ADD CONSTRAINT binaries_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
3801 -- Name: binaries_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
3804 ALTER TABLE ONLY binaries
3805 ADD CONSTRAINT binaries_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
3809 -- Name: binaries_metadata_bin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3812 ALTER TABLE ONLY binaries_metadata
3813 ADD CONSTRAINT binaries_metadata_bin_id_fkey FOREIGN KEY (bin_id) REFERENCES binaries(id) ON DELETE CASCADE;
3817 -- Name: binaries_metadata_key_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3820 ALTER TABLE ONLY binaries_metadata
3821 ADD CONSTRAINT binaries_metadata_key_id_fkey FOREIGN KEY (key_id) REFERENCES metadata_keys(key_id);
3825 -- Name: binaries_sig_fpr; Type: FK CONSTRAINT; Schema: public; Owner: dak
3828 ALTER TABLE ONLY binaries
3829 ADD CONSTRAINT binaries_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
3833 -- Name: binaries_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
3836 ALTER TABLE ONLY binaries
3837 ADD CONSTRAINT binaries_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
3841 -- Name: binary_acl_map_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3844 ALTER TABLE ONLY binary_acl_map
3845 ADD CONSTRAINT binary_acl_map_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
3849 -- Name: binary_acl_map_fingerprint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3852 ALTER TABLE ONLY binary_acl_map
3853 ADD CONSTRAINT binary_acl_map_fingerprint_id_fkey FOREIGN KEY (fingerprint_id) REFERENCES fingerprint(id);
3857 -- Name: build_queue_files_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3860 ALTER TABLE ONLY build_queue_files
3861 ADD CONSTRAINT build_queue_files_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE CASCADE;
3865 -- Name: build_queue_policy_files_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3868 ALTER TABLE ONLY build_queue_policy_files
3869 ADD CONSTRAINT build_queue_policy_files_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE CASCADE;
3873 -- Name: build_queue_policy_files_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3876 ALTER TABLE ONLY build_queue_policy_files
3877 ADD CONSTRAINT build_queue_policy_files_file_id_fkey FOREIGN KEY (file_id) REFERENCES changes_pending_files(id) ON DELETE CASCADE;
3881 -- Name: changes_pending_binaries_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3884 ALTER TABLE ONLY changes_pending_binaries
3885 ADD CONSTRAINT changes_pending_binaries_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
3889 -- Name: changes_pending_binaries_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3892 ALTER TABLE ONLY changes_pending_binaries
3893 ADD CONSTRAINT changes_pending_binaries_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3897 -- Name: changes_pending_binaries_pending_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3900 ALTER TABLE ONLY changes_pending_binaries
3901 ADD CONSTRAINT changes_pending_binaries_pending_file_id_fkey FOREIGN KEY (pending_file_id) REFERENCES changes_pending_files(id);
3905 -- Name: changes_pending_binaries_pending_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3908 ALTER TABLE ONLY changes_pending_binaries
3909 ADD CONSTRAINT changes_pending_binaries_pending_source_id_fkey FOREIGN KEY (pending_source_id) REFERENCES changes_pending_source(id);
3913 -- Name: changes_pending_binaries_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3916 ALTER TABLE ONLY changes_pending_binaries
3917 ADD CONSTRAINT changes_pending_binaries_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(id);
3921 -- Name: changes_pending_files_map_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3924 ALTER TABLE ONLY changes_pending_files_map
3925 ADD CONSTRAINT changes_pending_files_map_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3929 -- Name: changes_pending_files_map_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3932 ALTER TABLE ONLY changes_pending_files_map
3933 ADD CONSTRAINT changes_pending_files_map_file_id_fkey FOREIGN KEY (file_id) REFERENCES changes_pending_files(id);
3937 -- Name: changes_pending_source_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3940 ALTER TABLE ONLY changes_pending_source
3941 ADD CONSTRAINT changes_pending_source_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
3945 -- Name: changes_pending_source_changedby_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3948 ALTER TABLE ONLY changes_pending_source
3949 ADD CONSTRAINT changes_pending_source_changedby_id_fkey FOREIGN KEY (changedby_id) REFERENCES maintainer(id);
3953 -- Name: changes_pending_source_files_pending_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3956 ALTER TABLE ONLY changes_pending_source_files
3957 ADD CONSTRAINT changes_pending_source_files_pending_file_id_fkey FOREIGN KEY (pending_file_id) REFERENCES changes_pending_files(id);
3961 -- Name: changes_pending_source_files_pending_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3964 ALTER TABLE ONLY changes_pending_source_files
3965 ADD CONSTRAINT changes_pending_source_files_pending_source_id_fkey FOREIGN KEY (pending_source_id) REFERENCES changes_pending_source(id);
3969 -- Name: changes_pending_source_maintainer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3972 ALTER TABLE ONLY changes_pending_source
3973 ADD CONSTRAINT changes_pending_source_maintainer_id_fkey FOREIGN KEY (maintainer_id) REFERENCES maintainer(id);
3977 -- Name: changes_pending_source_sig_fpr_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3980 ALTER TABLE ONLY changes_pending_source
3981 ADD CONSTRAINT changes_pending_source_sig_fpr_fkey FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id);
3985 -- Name: changes_pool_files_changeid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3988 ALTER TABLE ONLY changes_pool_files
3989 ADD CONSTRAINT changes_pool_files_changeid_fkey FOREIGN KEY (changeid) REFERENCES changes(id) ON DELETE CASCADE;
3993 -- Name: changes_pool_files_fileid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3996 ALTER TABLE ONLY changes_pool_files
3997 ADD CONSTRAINT changes_pool_files_fileid_fkey FOREIGN KEY (fileid) REFERENCES files(id) ON DELETE RESTRICT;
4001 -- Name: dsc_files_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
4004 ALTER TABLE ONLY dsc_files
4005 ADD CONSTRAINT dsc_files_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
4009 -- Name: dsc_files_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4012 ALTER TABLE ONLY dsc_files
4013 ADD CONSTRAINT dsc_files_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
4017 -- Name: external_overrides_component_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4020 ALTER TABLE ONLY external_overrides
4021 ADD CONSTRAINT external_overrides_component_fkey FOREIGN KEY (component) REFERENCES component(id);
4025 -- Name: external_overrides_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4028 ALTER TABLE ONLY external_overrides
4029 ADD CONSTRAINT external_overrides_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4033 -- Name: extra_src_references_bin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4036 ALTER TABLE ONLY extra_src_references
4037 ADD CONSTRAINT extra_src_references_bin_id_fkey FOREIGN KEY (bin_id) REFERENCES binaries(id) ON DELETE CASCADE;
4041 -- Name: extra_src_references_src_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4044 ALTER TABLE ONLY extra_src_references
4045 ADD CONSTRAINT extra_src_references_src_id_fkey FOREIGN KEY (src_id) REFERENCES source(id) ON DELETE RESTRICT;
4049 -- Name: files_location; Type: FK CONSTRAINT; Schema: public; Owner: dak
4052 ALTER TABLE ONLY files
4053 ADD CONSTRAINT files_location FOREIGN KEY (location) REFERENCES location(id) MATCH FULL;
4057 -- Name: fingerprint_binary_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4060 ALTER TABLE ONLY fingerprint
4061 ADD CONSTRAINT fingerprint_binary_acl_id_fkey FOREIGN KEY (binary_acl_id) REFERENCES binary_acl(id);
4065 -- Name: fingerprint_source_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4068 ALTER TABLE ONLY fingerprint
4069 ADD CONSTRAINT fingerprint_source_acl_id_fkey FOREIGN KEY (source_acl_id) REFERENCES source_acl(id);
4073 -- Name: fingerprint_uid; Type: FK CONSTRAINT; Schema: public; Owner: dak
4076 ALTER TABLE ONLY fingerprint
4077 ADD CONSTRAINT fingerprint_uid FOREIGN KEY (uid) REFERENCES uid(id) MATCH FULL;
4081 -- Name: keyring_acl_map_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4084 ALTER TABLE ONLY keyring_acl_map
4085 ADD CONSTRAINT keyring_acl_map_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
4089 -- Name: keyring_acl_map_keyring_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4092 ALTER TABLE ONLY keyring_acl_map
4093 ADD CONSTRAINT keyring_acl_map_keyring_id_fkey FOREIGN KEY (keyring_id) REFERENCES keyrings(id);
4097 -- Name: keyrings_default_binary_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4100 ALTER TABLE ONLY keyrings
4101 ADD CONSTRAINT keyrings_default_binary_acl_id_fkey FOREIGN KEY (default_binary_acl_id) REFERENCES binary_acl(id);
4105 -- Name: keyrings_default_source_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4108 ALTER TABLE ONLY keyrings
4109 ADD CONSTRAINT keyrings_default_source_acl_id_fkey FOREIGN KEY (default_source_acl_id) REFERENCES source_acl(id);
4113 -- Name: known_changes_approved_for_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4116 ALTER TABLE ONLY changes
4117 ADD CONSTRAINT known_changes_approved_for_fkey FOREIGN KEY (in_queue) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4121 -- Name: known_changes_in_queue_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4124 ALTER TABLE ONLY changes
4125 ADD CONSTRAINT known_changes_in_queue_fkey FOREIGN KEY (in_queue) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4129 -- Name: location_archive_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4132 ALTER TABLE ONLY location
4133 ADD CONSTRAINT location_archive_fkey FOREIGN KEY (archive) REFERENCES archive(id);
4137 -- Name: location_component_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4140 ALTER TABLE ONLY location
4141 ADD CONSTRAINT location_component_fkey FOREIGN KEY (component) REFERENCES component(id);
4145 -- Name: override_component; Type: FK CONSTRAINT; Schema: public; Owner: dak
4148 ALTER TABLE ONLY override
4149 ADD CONSTRAINT override_component FOREIGN KEY (component) REFERENCES component(id) MATCH FULL;
4153 -- Name: override_priority; Type: FK CONSTRAINT; Schema: public; Owner: dak
4156 ALTER TABLE ONLY override
4157 ADD CONSTRAINT override_priority FOREIGN KEY (priority) REFERENCES priority(id) MATCH FULL;
4161 -- Name: override_section; Type: FK CONSTRAINT; Schema: public; Owner: dak
4164 ALTER TABLE ONLY override
4165 ADD CONSTRAINT override_section FOREIGN KEY (section) REFERENCES section(id) MATCH FULL;
4169 -- Name: override_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4172 ALTER TABLE ONLY override
4173 ADD CONSTRAINT override_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4177 -- Name: override_type; Type: FK CONSTRAINT; Schema: public; Owner: dak
4180 ALTER TABLE ONLY override
4181 ADD CONSTRAINT override_type FOREIGN KEY (type) REFERENCES override_type(id) MATCH FULL;
4185 -- Name: queue_files_fileid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4188 ALTER TABLE ONLY build_queue_files
4189 ADD CONSTRAINT queue_files_fileid_fkey FOREIGN KEY (fileid) REFERENCES files(id) ON DELETE CASCADE;
4193 -- Name: source_changedby; Type: FK CONSTRAINT; Schema: public; Owner: dak
4196 ALTER TABLE ONLY source
4197 ADD CONSTRAINT source_changedby FOREIGN KEY (changedby) REFERENCES maintainer(id) MATCH FULL;
4201 -- Name: source_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
4204 ALTER TABLE ONLY source
4205 ADD CONSTRAINT source_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
4209 -- Name: source_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
4212 ALTER TABLE ONLY source
4213 ADD CONSTRAINT source_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
4217 -- Name: source_metadata_key_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4220 ALTER TABLE ONLY source_metadata
4221 ADD CONSTRAINT source_metadata_key_id_fkey FOREIGN KEY (key_id) REFERENCES metadata_keys(key_id);
4225 -- Name: source_metadata_src_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4228 ALTER TABLE ONLY source_metadata
4229 ADD CONSTRAINT source_metadata_src_id_fkey FOREIGN KEY (src_id) REFERENCES source(id) ON DELETE CASCADE;
4233 -- Name: source_sig_fpr; Type: FK CONSTRAINT; Schema: public; Owner: dak
4236 ALTER TABLE ONLY source
4237 ADD CONSTRAINT source_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
4241 -- Name: src_associations_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4244 ALTER TABLE ONLY src_associations
4245 ADD CONSTRAINT src_associations_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
4249 -- Name: src_associations_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4252 ALTER TABLE ONLY src_associations
4253 ADD CONSTRAINT src_associations_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4257 -- Name: src_contents_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4260 ALTER TABLE ONLY src_contents
4261 ADD CONSTRAINT src_contents_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(id) ON DELETE CASCADE;
4265 -- Name: src_format_key; Type: FK CONSTRAINT; Schema: public; Owner: dak
4268 ALTER TABLE ONLY suite_src_formats
4269 ADD CONSTRAINT src_format_key FOREIGN KEY (src_format) REFERENCES src_format(id);
4273 -- Name: src_uploaders_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
4276 ALTER TABLE ONLY src_uploaders
4277 ADD CONSTRAINT src_uploaders_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) ON DELETE CASCADE;
4281 -- Name: src_uploaders_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4284 ALTER TABLE ONLY src_uploaders
4285 ADD CONSTRAINT src_uploaders_source FOREIGN KEY (source) REFERENCES source(id) ON DELETE CASCADE;
4289 -- Name: suite_architectures_architectur; Type: FK CONSTRAINT; Schema: public; Owner: dak
4292 ALTER TABLE ONLY suite_architectures
4293 ADD CONSTRAINT suite_architectures_architectur FOREIGN KEY (architecture) REFERENCES architecture(id) MATCH FULL;
4297 -- Name: suite_architectures_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4300 ALTER TABLE ONLY suite_architectures
4301 ADD CONSTRAINT suite_architectures_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4305 -- Name: suite_build_queue_copy_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4308 ALTER TABLE ONLY suite_build_queue_copy
4309 ADD CONSTRAINT suite_build_queue_copy_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE RESTRICT;
4313 -- Name: suite_key; Type: FK CONSTRAINT; Schema: public; Owner: dak
4316 ALTER TABLE ONLY suite_src_formats
4317 ADD CONSTRAINT suite_key FOREIGN KEY (suite) REFERENCES suite(id);
4321 -- Name: suite_policy_queue_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4324 ALTER TABLE ONLY suite
4325 ADD CONSTRAINT suite_policy_queue_fkey FOREIGN KEY (policy_queue_id) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4329 -- Name: suite_queue_copy_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4332 ALTER TABLE ONLY suite_build_queue_copy
4333 ADD CONSTRAINT suite_queue_copy_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4337 -- Name: upload_blocks_fingerprint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4340 ALTER TABLE ONLY upload_blocks
4341 ADD CONSTRAINT upload_blocks_fingerprint_id_fkey FOREIGN KEY (fingerprint_id) REFERENCES fingerprint(id);
4345 -- Name: upload_blocks_uid_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4348 ALTER TABLE ONLY upload_blocks
4349 ADD CONSTRAINT upload_blocks_uid_id_fkey FOREIGN KEY (uid_id) REFERENCES uid(id);
4353 -- Name: version_check_reference_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4356 ALTER TABLE ONLY version_check
4357 ADD CONSTRAINT version_check_reference_fkey FOREIGN KEY (reference) REFERENCES suite(id);
4361 -- Name: version_check_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4364 ALTER TABLE ONLY version_check
4365 ADD CONSTRAINT version_check_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4369 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4372 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4373 REVOKE ALL ON SCHEMA public FROM postgres;
4374 GRANT ALL ON SCHEMA public TO postgres;
4375 GRANT ALL ON SCHEMA public TO PUBLIC;
4379 -- Name: bin_associations_id_seq; Type: ACL; Schema: public; Owner: dak
4382 REVOKE ALL ON SEQUENCE bin_associations_id_seq FROM PUBLIC;
4383 REVOKE ALL ON SEQUENCE bin_associations_id_seq FROM dak;
4384 GRANT ALL ON SEQUENCE bin_associations_id_seq TO dak;
4385 GRANT SELECT ON SEQUENCE bin_associations_id_seq TO PUBLIC;
4386 GRANT ALL ON SEQUENCE bin_associations_id_seq TO ftpmaster;
4390 -- Name: bin_associations; Type: ACL; Schema: public; Owner: dak
4393 REVOKE ALL ON TABLE bin_associations FROM PUBLIC;
4394 REVOKE ALL ON TABLE bin_associations FROM dak;
4395 GRANT ALL ON TABLE bin_associations TO dak;
4396 GRANT SELECT ON TABLE bin_associations TO PUBLIC;
4397 GRANT ALL ON TABLE bin_associations TO ftpmaster;
4398 GRANT DELETE ON TABLE bin_associations TO ftpteam;
4402 -- Name: binaries_id_seq; Type: ACL; Schema: public; Owner: dak
4405 REVOKE ALL ON SEQUENCE binaries_id_seq FROM PUBLIC;
4406 REVOKE ALL ON SEQUENCE binaries_id_seq FROM dak;
4407 GRANT ALL ON SEQUENCE binaries_id_seq TO dak;
4408 GRANT SELECT ON SEQUENCE binaries_id_seq TO PUBLIC;
4409 GRANT ALL ON SEQUENCE binaries_id_seq TO ftpmaster;
4413 -- Name: binaries; Type: ACL; Schema: public; Owner: dak
4416 REVOKE ALL ON TABLE binaries FROM PUBLIC;
4417 REVOKE ALL ON TABLE binaries FROM dak;
4418 GRANT ALL ON TABLE binaries TO dak;
4419 GRANT SELECT ON TABLE binaries TO PUBLIC;
4420 GRANT ALL ON TABLE binaries TO ftpmaster;
4424 -- Name: bin_associations_binaries; Type: ACL; Schema: public; Owner: dak
4427 REVOKE ALL ON TABLE bin_associations_binaries FROM PUBLIC;
4428 REVOKE ALL ON TABLE bin_associations_binaries FROM dak;
4429 GRANT ALL ON TABLE bin_associations_binaries TO dak;
4430 GRANT SELECT ON TABLE bin_associations_binaries TO ftpmaster;
4431 GRANT SELECT ON TABLE bin_associations_binaries TO PUBLIC;
4435 -- Name: source_id_seq; Type: ACL; Schema: public; Owner: dak
4438 REVOKE ALL ON SEQUENCE source_id_seq FROM PUBLIC;
4439 REVOKE ALL ON SEQUENCE source_id_seq FROM dak;
4440 GRANT ALL ON SEQUENCE source_id_seq TO dak;
4441 GRANT SELECT ON SEQUENCE source_id_seq TO PUBLIC;
4442 GRANT ALL ON SEQUENCE source_id_seq TO ftpmaster;
4446 -- Name: source; Type: ACL; Schema: public; Owner: dak
4449 REVOKE ALL ON TABLE source FROM PUBLIC;
4450 REVOKE ALL ON TABLE source FROM dak;
4451 GRANT ALL ON TABLE source TO dak;
4452 GRANT SELECT ON TABLE source TO PUBLIC;
4453 GRANT ALL ON TABLE source TO ftpmaster;
4457 -- Name: src_associations_id_seq; Type: ACL; Schema: public; Owner: dak
4460 REVOKE ALL ON SEQUENCE src_associations_id_seq FROM PUBLIC;
4461 REVOKE ALL ON SEQUENCE src_associations_id_seq FROM dak;
4462 GRANT ALL ON SEQUENCE src_associations_id_seq TO dak;
4463 GRANT SELECT ON SEQUENCE src_associations_id_seq TO PUBLIC;
4464 GRANT ALL ON SEQUENCE src_associations_id_seq TO ftpmaster;
4468 -- Name: src_associations; Type: ACL; Schema: public; Owner: dak
4471 REVOKE ALL ON TABLE src_associations FROM PUBLIC;
4472 REVOKE ALL ON TABLE src_associations FROM dak;
4473 GRANT ALL ON TABLE src_associations TO dak;
4474 GRANT SELECT ON TABLE src_associations TO PUBLIC;
4475 GRANT ALL ON TABLE src_associations TO ftpmaster;
4476 GRANT DELETE ON TABLE src_associations TO ftpteam;
4480 -- Name: src_associations_bin; Type: ACL; Schema: public; Owner: dak
4483 REVOKE ALL ON TABLE src_associations_bin FROM PUBLIC;
4484 REVOKE ALL ON TABLE src_associations_bin FROM dak;
4485 GRANT ALL ON TABLE src_associations_bin TO dak;
4486 GRANT SELECT ON TABLE src_associations_bin TO ftpmaster;
4487 GRANT SELECT ON TABLE src_associations_bin TO PUBLIC;
4491 -- Name: almost_obsolete_all_associations; Type: ACL; Schema: public; Owner: dak
4494 REVOKE ALL ON TABLE almost_obsolete_all_associations FROM PUBLIC;
4495 REVOKE ALL ON TABLE almost_obsolete_all_associations FROM dak;
4496 GRANT ALL ON TABLE almost_obsolete_all_associations TO dak;
4497 GRANT SELECT ON TABLE almost_obsolete_all_associations TO ftpmaster;
4498 GRANT SELECT ON TABLE almost_obsolete_all_associations TO PUBLIC;
4502 -- Name: any_associations_source; Type: ACL; Schema: public; Owner: dak
4505 REVOKE ALL ON TABLE any_associations_source FROM PUBLIC;
4506 REVOKE ALL ON TABLE any_associations_source FROM dak;
4507 GRANT ALL ON TABLE any_associations_source TO dak;
4508 GRANT SELECT ON TABLE any_associations_source TO ftpmaster;
4509 GRANT SELECT ON TABLE any_associations_source TO PUBLIC;
4513 -- Name: src_associations_src; Type: ACL; Schema: public; Owner: dak
4516 REVOKE ALL ON TABLE src_associations_src FROM PUBLIC;
4517 REVOKE ALL ON TABLE src_associations_src FROM dak;
4518 GRANT ALL ON TABLE src_associations_src TO dak;
4519 GRANT SELECT ON TABLE src_associations_src TO ftpmaster;
4520 GRANT SELECT ON TABLE src_associations_src TO PUBLIC;
4524 -- Name: almost_obsolete_src_associations; Type: ACL; Schema: public; Owner: dak
4527 REVOKE ALL ON TABLE almost_obsolete_src_associations FROM PUBLIC;
4528 REVOKE ALL ON TABLE almost_obsolete_src_associations FROM dak;
4529 GRANT ALL ON TABLE almost_obsolete_src_associations TO dak;
4530 GRANT SELECT ON TABLE almost_obsolete_src_associations TO ftpmaster;
4531 GRANT SELECT ON TABLE almost_obsolete_src_associations TO PUBLIC;
4535 -- Name: architecture_id_seq; Type: ACL; Schema: public; Owner: dak
4538 REVOKE ALL ON SEQUENCE architecture_id_seq FROM PUBLIC;
4539 REVOKE ALL ON SEQUENCE architecture_id_seq FROM dak;
4540 GRANT ALL ON SEQUENCE architecture_id_seq TO dak;
4541 GRANT SELECT ON SEQUENCE architecture_id_seq TO PUBLIC;
4542 GRANT ALL ON SEQUENCE architecture_id_seq TO ftpmaster;
4546 -- Name: architecture; Type: ACL; Schema: public; Owner: dak
4549 REVOKE ALL ON TABLE architecture FROM PUBLIC;
4550 REVOKE ALL ON TABLE architecture FROM dak;
4551 GRANT ALL ON TABLE architecture TO dak;
4552 GRANT SELECT ON TABLE architecture TO PUBLIC;
4553 GRANT ALL ON TABLE architecture TO ftpmaster;
4557 -- Name: archive_id_seq; Type: ACL; Schema: public; Owner: dak
4560 REVOKE ALL ON SEQUENCE archive_id_seq FROM PUBLIC;
4561 REVOKE ALL ON SEQUENCE archive_id_seq FROM dak;
4562 GRANT ALL ON SEQUENCE archive_id_seq TO dak;
4563 GRANT SELECT ON SEQUENCE archive_id_seq TO PUBLIC;
4564 GRANT ALL ON SEQUENCE archive_id_seq TO ftpmaster;
4568 -- Name: archive; Type: ACL; Schema: public; Owner: dak
4571 REVOKE ALL ON TABLE archive FROM PUBLIC;
4572 REVOKE ALL ON TABLE archive FROM dak;
4573 GRANT ALL ON TABLE archive TO dak;
4574 GRANT SELECT ON TABLE archive TO PUBLIC;
4575 GRANT ALL ON TABLE archive TO ftpmaster;
4579 -- Name: bin_contents; Type: ACL; Schema: public; Owner: dak
4582 REVOKE ALL ON TABLE bin_contents FROM PUBLIC;
4583 REVOKE ALL ON TABLE bin_contents FROM dak;
4584 GRANT ALL ON TABLE bin_contents TO dak;
4585 GRANT SELECT ON TABLE bin_contents TO PUBLIC;
4586 GRANT ALL ON TABLE bin_contents TO ftpmaster;
4590 -- Name: binaries_metadata; Type: ACL; Schema: public; Owner: dak
4593 REVOKE ALL ON TABLE binaries_metadata FROM PUBLIC;
4594 REVOKE ALL ON TABLE binaries_metadata FROM dak;
4595 GRANT ALL ON TABLE binaries_metadata TO dak;
4596 GRANT SELECT,INSERT,UPDATE ON TABLE binaries_metadata TO ftpmaster;
4597 GRANT SELECT ON TABLE binaries_metadata TO PUBLIC;
4601 -- Name: suite_id_seq; Type: ACL; Schema: public; Owner: dak
4604 REVOKE ALL ON SEQUENCE suite_id_seq FROM PUBLIC;
4605 REVOKE ALL ON SEQUENCE suite_id_seq FROM dak;
4606 GRANT ALL ON SEQUENCE suite_id_seq TO dak;
4607 GRANT SELECT ON SEQUENCE suite_id_seq TO PUBLIC;
4608 GRANT ALL ON SEQUENCE suite_id_seq TO ftpmaster;
4612 -- Name: suite; Type: ACL; Schema: public; Owner: dak
4615 REVOKE ALL ON TABLE suite FROM PUBLIC;
4616 REVOKE ALL ON TABLE suite FROM dak;
4617 GRANT ALL ON TABLE suite TO dak;
4618 GRANT SELECT ON TABLE suite TO PUBLIC;
4619 GRANT ALL ON TABLE suite TO ftpmaster;
4623 -- Name: binaries_suite_arch; Type: ACL; Schema: public; Owner: dak
4626 REVOKE ALL ON TABLE binaries_suite_arch FROM PUBLIC;
4627 REVOKE ALL ON TABLE binaries_suite_arch FROM dak;
4628 GRANT ALL ON TABLE binaries_suite_arch TO dak;
4629 GRANT SELECT ON TABLE binaries_suite_arch TO ftpmaster;
4630 GRANT SELECT ON TABLE binaries_suite_arch TO PUBLIC;
4634 -- Name: binary_acl; Type: ACL; Schema: public; Owner: dak
4637 REVOKE ALL ON TABLE binary_acl FROM PUBLIC;
4638 REVOKE ALL ON TABLE binary_acl FROM dak;
4639 GRANT ALL ON TABLE binary_acl TO dak;
4640 GRANT SELECT ON TABLE binary_acl TO PUBLIC;
4641 GRANT ALL ON TABLE binary_acl TO ftpmaster;
4645 -- Name: binary_acl_id_seq; Type: ACL; Schema: public; Owner: dak
4648 REVOKE ALL ON SEQUENCE binary_acl_id_seq FROM PUBLIC;
4649 REVOKE ALL ON SEQUENCE binary_acl_id_seq FROM dak;
4650 GRANT ALL ON SEQUENCE binary_acl_id_seq TO dak;
4651 GRANT ALL ON SEQUENCE binary_acl_id_seq TO ftpmaster;
4652 GRANT SELECT ON SEQUENCE binary_acl_id_seq TO PUBLIC;
4656 -- Name: binary_acl_map; Type: ACL; Schema: public; Owner: dak
4659 REVOKE ALL ON TABLE binary_acl_map FROM PUBLIC;
4660 REVOKE ALL ON TABLE binary_acl_map FROM dak;
4661 GRANT ALL ON TABLE binary_acl_map TO dak;
4662 GRANT SELECT ON TABLE binary_acl_map TO PUBLIC;
4663 GRANT ALL ON TABLE binary_acl_map TO ftpmaster;
4667 -- Name: binary_acl_map_id_seq; Type: ACL; Schema: public; Owner: dak
4670 REVOKE ALL ON SEQUENCE binary_acl_map_id_seq FROM PUBLIC;
4671 REVOKE ALL ON SEQUENCE binary_acl_map_id_seq FROM dak;
4672 GRANT ALL ON SEQUENCE binary_acl_map_id_seq TO dak;
4673 GRANT ALL ON SEQUENCE binary_acl_map_id_seq TO ftpmaster;
4674 GRANT SELECT ON SEQUENCE binary_acl_map_id_seq TO PUBLIC;
4678 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: dak
4681 REVOKE ALL ON SEQUENCE files_id_seq FROM PUBLIC;
4682 REVOKE ALL ON SEQUENCE files_id_seq FROM dak;
4683 GRANT ALL ON SEQUENCE files_id_seq TO dak;
4684 GRANT SELECT ON SEQUENCE files_id_seq TO PUBLIC;
4685 GRANT ALL ON SEQUENCE files_id_seq TO ftpmaster;
4689 -- Name: files; Type: ACL; Schema: public; Owner: dak
4692 REVOKE ALL ON TABLE files FROM PUBLIC;
4693 REVOKE ALL ON TABLE files FROM dak;
4694 GRANT ALL ON TABLE files TO dak;
4695 GRANT SELECT ON TABLE files TO PUBLIC;
4696 GRANT ALL ON TABLE files TO ftpmaster;
4700 -- Name: location_id_seq; Type: ACL; Schema: public; Owner: dak
4703 REVOKE ALL ON SEQUENCE location_id_seq FROM PUBLIC;
4704 REVOKE ALL ON SEQUENCE location_id_seq FROM dak;
4705 GRANT ALL ON SEQUENCE location_id_seq TO dak;
4706 GRANT SELECT ON SEQUENCE location_id_seq TO PUBLIC;
4707 GRANT ALL ON SEQUENCE location_id_seq TO ftpmaster;
4711 -- Name: location; Type: ACL; Schema: public; Owner: dak
4714 REVOKE ALL ON TABLE location FROM PUBLIC;
4715 REVOKE ALL ON TABLE location FROM dak;
4716 GRANT ALL ON TABLE location TO dak;
4717 GRANT SELECT ON TABLE location TO PUBLIC;
4718 GRANT ALL ON TABLE location TO ftpmaster;
4722 -- Name: binfiles_suite_component_arch; Type: ACL; Schema: public; Owner: dak
4725 REVOKE ALL ON TABLE binfiles_suite_component_arch FROM PUBLIC;
4726 REVOKE ALL ON TABLE binfiles_suite_component_arch FROM dak;
4727 GRANT ALL ON TABLE binfiles_suite_component_arch TO dak;
4728 GRANT SELECT ON TABLE binfiles_suite_component_arch TO ftpmaster;
4729 GRANT SELECT ON TABLE binfiles_suite_component_arch TO PUBLIC;
4733 -- Name: build_queue; Type: ACL; Schema: public; Owner: dak
4736 REVOKE ALL ON TABLE build_queue FROM PUBLIC;
4737 REVOKE ALL ON TABLE build_queue FROM dak;
4738 GRANT ALL ON TABLE build_queue TO dak;
4739 GRANT SELECT ON TABLE build_queue TO PUBLIC;
4740 GRANT ALL ON TABLE build_queue TO ftpmaster;
4744 -- Name: build_queue_files; Type: ACL; Schema: public; Owner: dak
4747 REVOKE ALL ON TABLE build_queue_files FROM PUBLIC;
4748 REVOKE ALL ON TABLE build_queue_files FROM dak;
4749 GRANT ALL ON TABLE build_queue_files TO dak;
4750 GRANT SELECT ON TABLE build_queue_files TO PUBLIC;
4751 GRANT ALL ON TABLE build_queue_files TO ftpmaster;
4755 -- Name: build_queue_files_id_seq; Type: ACL; Schema: public; Owner: dak
4758 REVOKE ALL ON SEQUENCE build_queue_files_id_seq FROM PUBLIC;
4759 REVOKE ALL ON SEQUENCE build_queue_files_id_seq FROM dak;
4760 GRANT ALL ON SEQUENCE build_queue_files_id_seq TO dak;
4761 GRANT ALL ON SEQUENCE build_queue_files_id_seq TO ftpmaster;
4762 GRANT SELECT ON SEQUENCE build_queue_files_id_seq TO PUBLIC;
4766 -- Name: build_queue_id_seq; Type: ACL; Schema: public; Owner: dak
4769 REVOKE ALL ON SEQUENCE build_queue_id_seq FROM PUBLIC;
4770 REVOKE ALL ON SEQUENCE build_queue_id_seq FROM dak;
4771 GRANT ALL ON SEQUENCE build_queue_id_seq TO dak;
4772 GRANT ALL ON SEQUENCE build_queue_id_seq TO ftpmaster;
4773 GRANT SELECT ON SEQUENCE build_queue_id_seq TO PUBLIC;
4777 -- Name: build_queue_policy_files; Type: ACL; Schema: public; Owner: dak
4780 REVOKE ALL ON TABLE build_queue_policy_files FROM PUBLIC;
4781 REVOKE ALL ON TABLE build_queue_policy_files FROM dak;
4782 GRANT ALL ON TABLE build_queue_policy_files TO dak;
4783 GRANT SELECT,INSERT,UPDATE ON TABLE build_queue_policy_files TO ftpmaster;
4784 GRANT SELECT ON TABLE build_queue_policy_files TO PUBLIC;
4788 -- Name: changelogs_text; Type: ACL; Schema: public; Owner: dak
4791 REVOKE ALL ON TABLE changelogs_text FROM PUBLIC;
4792 REVOKE ALL ON TABLE changelogs_text FROM dak;
4793 GRANT ALL ON TABLE changelogs_text TO dak;
4794 GRANT SELECT ON TABLE changelogs_text TO PUBLIC;
4795 GRANT ALL ON TABLE changelogs_text TO ftpmaster;
4799 -- Name: changes; Type: ACL; Schema: public; Owner: dak
4802 REVOKE ALL ON TABLE changes FROM PUBLIC;
4803 REVOKE ALL ON TABLE changes FROM dak;
4804 GRANT ALL ON TABLE changes TO dak;
4805 GRANT ALL ON TABLE changes TO ftpmaster;
4806 GRANT SELECT ON TABLE changes TO PUBLIC;
4807 GRANT DELETE,UPDATE ON TABLE changes TO ftpteam;
4811 -- Name: changelogs; Type: ACL; Schema: public; Owner: dak
4814 REVOKE ALL ON TABLE changelogs FROM PUBLIC;
4815 REVOKE ALL ON TABLE changelogs FROM dak;
4816 GRANT ALL ON TABLE changelogs TO dak;
4817 GRANT SELECT ON TABLE changelogs TO PUBLIC;
4818 GRANT ALL ON TABLE changelogs TO ftpmaster;
4822 -- Name: changelogs_text_id_seq; Type: ACL; Schema: public; Owner: dak
4825 REVOKE ALL ON SEQUENCE changelogs_text_id_seq FROM PUBLIC;
4826 REVOKE ALL ON SEQUENCE changelogs_text_id_seq FROM dak;
4827 GRANT ALL ON SEQUENCE changelogs_text_id_seq TO dak;
4828 GRANT ALL ON SEQUENCE changelogs_text_id_seq TO ftpmaster;
4829 GRANT SELECT ON SEQUENCE changelogs_text_id_seq TO PUBLIC;
4833 -- Name: changes_id_seq; Type: ACL; Schema: public; Owner: dak
4836 REVOKE ALL ON SEQUENCE changes_id_seq FROM PUBLIC;
4837 REVOKE ALL ON SEQUENCE changes_id_seq FROM dak;
4838 GRANT ALL ON SEQUENCE changes_id_seq TO dak;
4839 GRANT ALL ON SEQUENCE changes_id_seq TO ftpmaster;
4840 GRANT SELECT ON SEQUENCE changes_id_seq TO PUBLIC;
4844 -- Name: changes_pending_binaries; Type: ACL; Schema: public; Owner: dak
4847 REVOKE ALL ON TABLE changes_pending_binaries FROM PUBLIC;
4848 REVOKE ALL ON TABLE changes_pending_binaries FROM dak;
4849 GRANT ALL ON TABLE changes_pending_binaries TO dak;
4850 GRANT SELECT ON TABLE changes_pending_binaries TO PUBLIC;
4851 GRANT ALL ON TABLE changes_pending_binaries TO ftpmaster;
4855 -- Name: changes_pending_binaries_id_seq; Type: ACL; Schema: public; Owner: dak
4858 REVOKE ALL ON SEQUENCE changes_pending_binaries_id_seq FROM PUBLIC;
4859 REVOKE ALL ON SEQUENCE changes_pending_binaries_id_seq FROM dak;
4860 GRANT ALL ON SEQUENCE changes_pending_binaries_id_seq TO dak;
4861 GRANT ALL ON SEQUENCE changes_pending_binaries_id_seq TO ftpmaster;
4862 GRANT SELECT ON SEQUENCE changes_pending_binaries_id_seq TO PUBLIC;
4866 -- Name: changes_pending_files; Type: ACL; Schema: public; Owner: dak
4869 REVOKE ALL ON TABLE changes_pending_files FROM PUBLIC;
4870 REVOKE ALL ON TABLE changes_pending_files FROM dak;
4871 GRANT ALL ON TABLE changes_pending_files TO dak;
4872 GRANT SELECT ON TABLE changes_pending_files TO PUBLIC;
4873 GRANT ALL ON TABLE changes_pending_files TO ftpmaster;
4874 GRANT DELETE ON TABLE changes_pending_files TO ftpteam;
4878 -- Name: changes_pending_files_id_seq; Type: ACL; Schema: public; Owner: dak
4881 REVOKE ALL ON SEQUENCE changes_pending_files_id_seq FROM PUBLIC;
4882 REVOKE ALL ON SEQUENCE changes_pending_files_id_seq FROM dak;
4883 GRANT ALL ON SEQUENCE changes_pending_files_id_seq TO dak;
4884 GRANT ALL ON SEQUENCE changes_pending_files_id_seq TO ftpmaster;
4885 GRANT SELECT ON SEQUENCE changes_pending_files_id_seq TO PUBLIC;
4886 GRANT USAGE ON SEQUENCE changes_pending_files_id_seq TO ftpteam;
4890 -- Name: changes_pending_files_map; Type: ACL; Schema: public; Owner: dak
4893 REVOKE ALL ON TABLE changes_pending_files_map FROM PUBLIC;
4894 REVOKE ALL ON TABLE changes_pending_files_map FROM dak;
4895 GRANT ALL ON TABLE changes_pending_files_map TO dak;
4896 GRANT SELECT,INSERT,DELETE ON TABLE changes_pending_files_map TO ftpteam;
4897 GRANT SELECT ON TABLE changes_pending_files_map TO PUBLIC;
4901 -- Name: changes_pending_source; Type: ACL; Schema: public; Owner: dak
4904 REVOKE ALL ON TABLE changes_pending_source FROM PUBLIC;
4905 REVOKE ALL ON TABLE changes_pending_source FROM dak;
4906 GRANT ALL ON TABLE changes_pending_source TO dak;
4907 GRANT SELECT ON TABLE changes_pending_source TO PUBLIC;
4908 GRANT ALL ON TABLE changes_pending_source TO ftpmaster;
4912 -- Name: changes_pending_source_files; Type: ACL; Schema: public; Owner: dak
4915 REVOKE ALL ON TABLE changes_pending_source_files FROM PUBLIC;
4916 REVOKE ALL ON TABLE changes_pending_source_files FROM dak;
4917 GRANT ALL ON TABLE changes_pending_source_files TO dak;
4918 GRANT SELECT ON TABLE changes_pending_source_files TO PUBLIC;
4919 GRANT ALL ON TABLE changes_pending_source_files TO ftpmaster;
4923 -- Name: changes_pending_source_id_seq; Type: ACL; Schema: public; Owner: dak
4926 REVOKE ALL ON SEQUENCE changes_pending_source_id_seq FROM PUBLIC;
4927 REVOKE ALL ON SEQUENCE changes_pending_source_id_seq FROM dak;
4928 GRANT ALL ON SEQUENCE changes_pending_source_id_seq TO dak;
4929 GRANT ALL ON SEQUENCE changes_pending_source_id_seq TO ftpmaster;
4930 GRANT SELECT ON SEQUENCE changes_pending_source_id_seq TO PUBLIC;
4934 -- Name: changes_pool_files; Type: ACL; Schema: public; Owner: dak
4937 REVOKE ALL ON TABLE changes_pool_files FROM PUBLIC;
4938 REVOKE ALL ON TABLE changes_pool_files FROM dak;
4939 GRANT ALL ON TABLE changes_pool_files TO dak;
4940 GRANT SELECT ON TABLE changes_pool_files TO PUBLIC;
4941 GRANT ALL ON TABLE changes_pool_files TO ftpmaster;
4942 GRANT INSERT ON TABLE changes_pool_files TO ftpteam;
4946 -- Name: component_id_seq; Type: ACL; Schema: public; Owner: dak
4949 REVOKE ALL ON SEQUENCE component_id_seq FROM PUBLIC;
4950 REVOKE ALL ON SEQUENCE component_id_seq FROM dak;
4951 GRANT ALL ON SEQUENCE component_id_seq TO dak;
4952 GRANT SELECT ON SEQUENCE component_id_seq TO PUBLIC;
4953 GRANT ALL ON SEQUENCE component_id_seq TO ftpmaster;
4957 -- Name: component; Type: ACL; Schema: public; Owner: dak
4960 REVOKE ALL ON TABLE component FROM PUBLIC;
4961 REVOKE ALL ON TABLE component FROM dak;
4962 GRANT ALL ON TABLE component TO dak;
4963 GRANT SELECT ON TABLE component TO PUBLIC;
4964 GRANT ALL ON TABLE component TO ftpmaster;
4968 -- Name: config; Type: ACL; Schema: public; Owner: dak
4971 REVOKE ALL ON TABLE config FROM PUBLIC;
4972 REVOKE ALL ON TABLE config FROM dak;
4973 GRANT ALL ON TABLE config TO dak;
4974 GRANT ALL ON TABLE config TO ftpmaster;
4975 GRANT SELECT ON TABLE config TO ftpteam;
4976 GRANT SELECT ON TABLE config TO PUBLIC;
4980 -- Name: config_id_seq; Type: ACL; Schema: public; Owner: dak
4983 REVOKE ALL ON SEQUENCE config_id_seq FROM PUBLIC;
4984 REVOKE ALL ON SEQUENCE config_id_seq FROM dak;
4985 GRANT ALL ON SEQUENCE config_id_seq TO dak;
4986 GRANT ALL ON SEQUENCE config_id_seq TO ftpmaster;
4987 GRANT SELECT ON SEQUENCE config_id_seq TO PUBLIC;
4991 -- Name: dsc_files_id_seq; Type: ACL; Schema: public; Owner: dak
4994 REVOKE ALL ON SEQUENCE dsc_files_id_seq FROM PUBLIC;
4995 REVOKE ALL ON SEQUENCE dsc_files_id_seq FROM dak;
4996 GRANT ALL ON SEQUENCE dsc_files_id_seq TO dak;
4997 GRANT SELECT ON SEQUENCE dsc_files_id_seq TO PUBLIC;
4998 GRANT ALL ON SEQUENCE dsc_files_id_seq TO ftpmaster;
5002 -- Name: dsc_files; Type: ACL; Schema: public; Owner: dak
5005 REVOKE ALL ON TABLE dsc_files FROM PUBLIC;
5006 REVOKE ALL ON TABLE dsc_files FROM dak;
5007 GRANT ALL ON TABLE dsc_files TO dak;
5008 GRANT SELECT ON TABLE dsc_files TO PUBLIC;
5009 GRANT ALL ON TABLE dsc_files TO ftpmaster;
5013 -- Name: external_overrides; Type: ACL; Schema: public; Owner: dak
5016 REVOKE ALL ON TABLE external_overrides FROM PUBLIC;
5017 REVOKE ALL ON TABLE external_overrides FROM dak;
5018 GRANT ALL ON TABLE external_overrides TO dak;
5019 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE external_overrides TO ftpmaster;
5020 GRANT SELECT ON TABLE external_overrides TO PUBLIC;
5024 -- Name: extra_src_references; Type: ACL; Schema: public; Owner: dak
5027 REVOKE ALL ON TABLE extra_src_references FROM PUBLIC;
5028 REVOKE ALL ON TABLE extra_src_references FROM dak;
5029 GRANT ALL ON TABLE extra_src_references TO dak;
5030 GRANT SELECT,INSERT,UPDATE ON TABLE extra_src_references TO ftpmaster;
5031 GRANT SELECT ON TABLE extra_src_references TO PUBLIC;
5035 -- Name: file_arch_suite; Type: ACL; Schema: public; Owner: dak
5038 REVOKE ALL ON TABLE file_arch_suite FROM PUBLIC;
5039 REVOKE ALL ON TABLE file_arch_suite FROM dak;
5040 GRANT ALL ON TABLE file_arch_suite TO dak;
5041 GRANT ALL ON TABLE file_arch_suite TO ftpmaster;
5042 GRANT SELECT ON TABLE file_arch_suite TO PUBLIC;
5046 -- Name: fingerprint_id_seq; Type: ACL; Schema: public; Owner: dak
5049 REVOKE ALL ON SEQUENCE fingerprint_id_seq FROM PUBLIC;
5050 REVOKE ALL ON SEQUENCE fingerprint_id_seq FROM dak;
5051 GRANT ALL ON SEQUENCE fingerprint_id_seq TO dak;
5052 GRANT SELECT ON SEQUENCE fingerprint_id_seq TO PUBLIC;
5053 GRANT ALL ON SEQUENCE fingerprint_id_seq TO ftpmaster;
5057 -- Name: fingerprint; Type: ACL; Schema: public; Owner: dak
5060 REVOKE ALL ON TABLE fingerprint FROM PUBLIC;
5061 REVOKE ALL ON TABLE fingerprint FROM dak;
5062 GRANT ALL ON TABLE fingerprint TO dak;
5063 GRANT SELECT ON TABLE fingerprint TO PUBLIC;
5064 GRANT ALL ON TABLE fingerprint TO ftpmaster;
5068 -- Name: keyring_acl_map; Type: ACL; Schema: public; Owner: dak
5071 REVOKE ALL ON TABLE keyring_acl_map FROM PUBLIC;
5072 REVOKE ALL ON TABLE keyring_acl_map FROM dak;
5073 GRANT ALL ON TABLE keyring_acl_map TO dak;
5074 GRANT SELECT ON TABLE keyring_acl_map TO PUBLIC;
5075 GRANT ALL ON TABLE keyring_acl_map TO ftpmaster;
5079 -- Name: keyring_acl_map_id_seq; Type: ACL; Schema: public; Owner: dak
5082 REVOKE ALL ON SEQUENCE keyring_acl_map_id_seq FROM PUBLIC;
5083 REVOKE ALL ON SEQUENCE keyring_acl_map_id_seq FROM dak;
5084 GRANT ALL ON SEQUENCE keyring_acl_map_id_seq TO dak;
5085 GRANT ALL ON SEQUENCE keyring_acl_map_id_seq TO ftpmaster;
5086 GRANT SELECT ON SEQUENCE keyring_acl_map_id_seq TO PUBLIC;
5090 -- Name: keyrings; Type: ACL; Schema: public; Owner: dak
5093 REVOKE ALL ON TABLE keyrings FROM PUBLIC;
5094 REVOKE ALL ON TABLE keyrings FROM dak;
5095 GRANT ALL ON TABLE keyrings TO dak;
5096 GRANT SELECT ON TABLE keyrings TO PUBLIC;
5097 GRANT ALL ON TABLE keyrings TO ftpmaster;
5101 -- Name: keyrings_id_seq; Type: ACL; Schema: public; Owner: dak
5104 REVOKE ALL ON SEQUENCE keyrings_id_seq FROM PUBLIC;
5105 REVOKE ALL ON SEQUENCE keyrings_id_seq FROM dak;
5106 GRANT ALL ON SEQUENCE keyrings_id_seq TO dak;
5107 GRANT SELECT ON SEQUENCE keyrings_id_seq TO PUBLIC;
5108 GRANT ALL ON SEQUENCE keyrings_id_seq TO ftpmaster;
5112 -- Name: maintainer_id_seq; Type: ACL; Schema: public; Owner: dak
5115 REVOKE ALL ON SEQUENCE maintainer_id_seq FROM PUBLIC;
5116 REVOKE ALL ON SEQUENCE maintainer_id_seq FROM dak;
5117 GRANT ALL ON SEQUENCE maintainer_id_seq TO dak;
5118 GRANT SELECT ON SEQUENCE maintainer_id_seq TO PUBLIC;
5119 GRANT ALL ON SEQUENCE maintainer_id_seq TO ftpmaster;
5123 -- Name: maintainer; Type: ACL; Schema: public; Owner: dak
5126 REVOKE ALL ON TABLE maintainer FROM PUBLIC;
5127 REVOKE ALL ON TABLE maintainer FROM dak;
5128 GRANT ALL ON TABLE maintainer TO dak;
5129 GRANT SELECT ON TABLE maintainer TO PUBLIC;
5130 GRANT ALL ON TABLE maintainer TO ftpmaster;
5134 -- Name: metadata_keys; Type: ACL; Schema: public; Owner: dak
5137 REVOKE ALL ON TABLE metadata_keys FROM PUBLIC;
5138 REVOKE ALL ON TABLE metadata_keys FROM dak;
5139 GRANT ALL ON TABLE metadata_keys TO dak;
5140 GRANT SELECT,INSERT,UPDATE ON TABLE metadata_keys TO ftpmaster;
5141 GRANT SELECT ON TABLE metadata_keys TO PUBLIC;
5145 -- Name: metadata_keys_key_id_seq; Type: ACL; Schema: public; Owner: dak
5148 REVOKE ALL ON SEQUENCE metadata_keys_key_id_seq FROM PUBLIC;
5149 REVOKE ALL ON SEQUENCE metadata_keys_key_id_seq FROM dak;
5150 GRANT ALL ON SEQUENCE metadata_keys_key_id_seq TO dak;
5151 GRANT ALL ON SEQUENCE metadata_keys_key_id_seq TO ftpmaster;
5152 GRANT SELECT ON SEQUENCE metadata_keys_key_id_seq TO PUBLIC;
5156 -- Name: new_comments; Type: ACL; Schema: public; Owner: dak
5159 REVOKE ALL ON TABLE new_comments FROM PUBLIC;
5160 REVOKE ALL ON TABLE new_comments FROM dak;
5161 GRANT ALL ON TABLE new_comments TO dak;
5162 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE new_comments TO ftptrainee;
5163 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE new_comments TO ftpteam;
5164 GRANT ALL ON TABLE new_comments TO ftpmaster;
5168 -- Name: new_comments_id_seq; Type: ACL; Schema: public; Owner: dak
5171 REVOKE ALL ON SEQUENCE new_comments_id_seq FROM PUBLIC;
5172 REVOKE ALL ON SEQUENCE new_comments_id_seq FROM dak;
5173 GRANT ALL ON SEQUENCE new_comments_id_seq TO dak;
5174 GRANT SELECT,UPDATE ON SEQUENCE new_comments_id_seq TO ftptrainee;
5175 GRANT SELECT,UPDATE ON SEQUENCE new_comments_id_seq TO ftpteam;
5176 GRANT ALL ON SEQUENCE new_comments_id_seq TO ftpmaster;
5177 GRANT SELECT ON SEQUENCE new_comments_id_seq TO PUBLIC;
5181 -- Name: newest_all_associations; Type: ACL; Schema: public; Owner: dak
5184 REVOKE ALL ON TABLE newest_all_associations FROM PUBLIC;
5185 REVOKE ALL ON TABLE newest_all_associations FROM dak;
5186 GRANT ALL ON TABLE newest_all_associations TO dak;
5187 GRANT SELECT ON TABLE newest_all_associations TO ftpmaster;
5188 GRANT SELECT ON TABLE newest_all_associations TO PUBLIC;
5192 -- Name: newest_any_associations; Type: ACL; Schema: public; Owner: dak
5195 REVOKE ALL ON TABLE newest_any_associations FROM PUBLIC;
5196 REVOKE ALL ON TABLE newest_any_associations FROM dak;
5197 GRANT ALL ON TABLE newest_any_associations TO dak;
5198 GRANT SELECT ON TABLE newest_any_associations TO ftpmaster;
5199 GRANT SELECT ON TABLE newest_any_associations TO PUBLIC;
5203 -- Name: source_suite; Type: ACL; Schema: public; Owner: dak
5206 REVOKE ALL ON TABLE source_suite FROM PUBLIC;
5207 REVOKE ALL ON TABLE source_suite FROM dak;
5208 GRANT ALL ON TABLE source_suite TO dak;
5209 GRANT SELECT ON TABLE source_suite TO ftpmaster;
5210 GRANT SELECT ON TABLE source_suite TO PUBLIC;
5214 -- Name: newest_source; Type: ACL; Schema: public; Owner: dak
5217 REVOKE ALL ON TABLE newest_source FROM PUBLIC;
5218 REVOKE ALL ON TABLE newest_source FROM dak;
5219 GRANT ALL ON TABLE newest_source TO dak;
5220 GRANT SELECT ON TABLE newest_source TO ftpmaster;
5221 GRANT SELECT ON TABLE newest_source TO PUBLIC;
5225 -- Name: newest_src_association; Type: ACL; Schema: public; Owner: dak
5228 REVOKE ALL ON TABLE newest_src_association FROM PUBLIC;
5229 REVOKE ALL ON TABLE newest_src_association FROM dak;
5230 GRANT ALL ON TABLE newest_src_association TO dak;
5231 GRANT SELECT ON TABLE newest_src_association TO ftpmaster;
5232 GRANT SELECT ON TABLE newest_src_association TO PUBLIC;
5236 -- Name: obsolete_all_associations; Type: ACL; Schema: public; Owner: dak
5239 REVOKE ALL ON TABLE obsolete_all_associations FROM PUBLIC;
5240 REVOKE ALL ON TABLE obsolete_all_associations FROM dak;
5241 GRANT ALL ON TABLE obsolete_all_associations TO dak;
5242 GRANT SELECT ON TABLE obsolete_all_associations TO ftpmaster;
5243 GRANT SELECT ON TABLE obsolete_all_associations TO PUBLIC;
5247 -- Name: obsolete_any_associations; Type: ACL; Schema: public; Owner: dak
5250 REVOKE ALL ON TABLE obsolete_any_associations FROM PUBLIC;
5251 REVOKE ALL ON TABLE obsolete_any_associations FROM dak;
5252 GRANT ALL ON TABLE obsolete_any_associations TO dak;
5253 GRANT SELECT ON TABLE obsolete_any_associations TO ftpmaster;
5254 GRANT SELECT ON TABLE obsolete_any_associations TO PUBLIC;
5258 -- Name: obsolete_any_by_all_associations; Type: ACL; Schema: public; Owner: dak
5261 REVOKE ALL ON TABLE obsolete_any_by_all_associations FROM PUBLIC;
5262 REVOKE ALL ON TABLE obsolete_any_by_all_associations FROM dak;
5263 GRANT ALL ON TABLE obsolete_any_by_all_associations TO dak;
5264 GRANT SELECT ON TABLE obsolete_any_by_all_associations TO ftpmaster;
5265 GRANT SELECT ON TABLE obsolete_any_by_all_associations TO PUBLIC;
5269 -- Name: obsolete_src_associations; Type: ACL; Schema: public; Owner: dak
5272 REVOKE ALL ON TABLE obsolete_src_associations FROM PUBLIC;
5273 REVOKE ALL ON TABLE obsolete_src_associations FROM dak;
5274 GRANT ALL ON TABLE obsolete_src_associations TO dak;
5275 GRANT SELECT ON TABLE obsolete_src_associations TO ftpmaster;
5276 GRANT SELECT ON TABLE obsolete_src_associations TO PUBLIC;
5280 -- Name: override; Type: ACL; Schema: public; Owner: dak
5283 REVOKE ALL ON TABLE override FROM PUBLIC;
5284 REVOKE ALL ON TABLE override FROM dak;
5285 GRANT ALL ON TABLE override TO dak;
5286 GRANT SELECT ON TABLE override TO PUBLIC;
5287 GRANT ALL ON TABLE override TO ftpmaster;
5288 GRANT INSERT,DELETE,UPDATE ON TABLE override TO ftpteam;
5292 -- Name: override_type_id_seq; Type: ACL; Schema: public; Owner: dak
5295 REVOKE ALL ON SEQUENCE override_type_id_seq FROM PUBLIC;
5296 REVOKE ALL ON SEQUENCE override_type_id_seq FROM dak;
5297 GRANT ALL ON SEQUENCE override_type_id_seq TO dak;
5298 GRANT SELECT ON SEQUENCE override_type_id_seq TO PUBLIC;
5299 GRANT ALL ON SEQUENCE override_type_id_seq TO ftpmaster;
5303 -- Name: override_type; Type: ACL; Schema: public; Owner: dak
5306 REVOKE ALL ON TABLE override_type FROM PUBLIC;
5307 REVOKE ALL ON TABLE override_type FROM dak;
5308 GRANT ALL ON TABLE override_type TO dak;
5309 GRANT SELECT ON TABLE override_type TO PUBLIC;
5310 GRANT ALL ON TABLE override_type TO ftpmaster;
5314 -- Name: policy_queue; Type: ACL; Schema: public; Owner: dak
5317 REVOKE ALL ON TABLE policy_queue FROM PUBLIC;
5318 REVOKE ALL ON TABLE policy_queue FROM dak;
5319 GRANT ALL ON TABLE policy_queue TO dak;
5320 GRANT SELECT ON TABLE policy_queue TO PUBLIC;
5321 GRANT ALL ON TABLE policy_queue TO ftpmaster;
5325 -- Name: policy_queue_id_seq; Type: ACL; Schema: public; Owner: dak
5328 REVOKE ALL ON SEQUENCE policy_queue_id_seq FROM PUBLIC;
5329 REVOKE ALL ON SEQUENCE policy_queue_id_seq FROM dak;
5330 GRANT ALL ON SEQUENCE policy_queue_id_seq TO dak;
5331 GRANT ALL ON SEQUENCE policy_queue_id_seq TO ftpmaster;
5332 GRANT SELECT ON SEQUENCE policy_queue_id_seq TO PUBLIC;
5336 -- Name: priority_id_seq; Type: ACL; Schema: public; Owner: dak
5339 REVOKE ALL ON SEQUENCE priority_id_seq FROM PUBLIC;
5340 REVOKE ALL ON SEQUENCE priority_id_seq FROM dak;
5341 GRANT ALL ON SEQUENCE priority_id_seq TO dak;
5342 GRANT SELECT ON SEQUENCE priority_id_seq TO PUBLIC;
5343 GRANT ALL ON SEQUENCE priority_id_seq TO ftpmaster;
5347 -- Name: priority; Type: ACL; Schema: public; Owner: dak
5350 REVOKE ALL ON TABLE priority FROM PUBLIC;
5351 REVOKE ALL ON TABLE priority FROM dak;
5352 GRANT ALL ON TABLE priority TO dak;
5353 GRANT SELECT ON TABLE priority TO PUBLIC;
5354 GRANT ALL ON TABLE priority TO ftpmaster;
5358 -- Name: section_id_seq; Type: ACL; Schema: public; Owner: dak
5361 REVOKE ALL ON SEQUENCE section_id_seq FROM PUBLIC;
5362 REVOKE ALL ON SEQUENCE section_id_seq FROM dak;
5363 GRANT ALL ON SEQUENCE section_id_seq TO dak;
5364 GRANT SELECT ON SEQUENCE section_id_seq TO PUBLIC;
5365 GRANT ALL ON SEQUENCE section_id_seq TO ftpmaster;
5369 -- Name: section; Type: ACL; Schema: public; Owner: dak
5372 REVOKE ALL ON TABLE section FROM PUBLIC;
5373 REVOKE ALL ON TABLE section FROM dak;
5374 GRANT ALL ON TABLE section TO dak;
5375 GRANT SELECT ON TABLE section TO PUBLIC;
5376 GRANT ALL ON TABLE section TO ftpmaster;
5380 -- Name: source_acl; Type: ACL; Schema: public; Owner: dak
5383 REVOKE ALL ON TABLE source_acl FROM PUBLIC;
5384 REVOKE ALL ON TABLE source_acl FROM dak;
5385 GRANT ALL ON TABLE source_acl TO dak;
5386 GRANT SELECT ON TABLE source_acl TO PUBLIC;
5387 GRANT ALL ON TABLE source_acl TO ftpmaster;
5391 -- Name: source_acl_id_seq; Type: ACL; Schema: public; Owner: dak
5394 REVOKE ALL ON SEQUENCE source_acl_id_seq FROM PUBLIC;
5395 REVOKE ALL ON SEQUENCE source_acl_id_seq FROM dak;
5396 GRANT ALL ON SEQUENCE source_acl_id_seq TO dak;
5397 GRANT ALL ON SEQUENCE source_acl_id_seq TO ftpmaster;
5398 GRANT SELECT ON SEQUENCE source_acl_id_seq TO PUBLIC;
5402 -- Name: source_metadata; Type: ACL; Schema: public; Owner: dak
5405 REVOKE ALL ON TABLE source_metadata FROM PUBLIC;
5406 REVOKE ALL ON TABLE source_metadata FROM dak;
5407 GRANT ALL ON TABLE source_metadata TO dak;
5408 GRANT SELECT,INSERT,UPDATE ON TABLE source_metadata TO ftpmaster;
5409 GRANT SELECT ON TABLE source_metadata TO PUBLIC;
5413 -- Name: src_contents; Type: ACL; Schema: public; Owner: dak
5416 REVOKE ALL ON TABLE src_contents FROM PUBLIC;
5417 REVOKE ALL ON TABLE src_contents FROM dak;
5418 GRANT ALL ON TABLE src_contents TO dak;
5419 GRANT SELECT,INSERT,UPDATE ON TABLE src_contents TO ftpmaster;
5420 GRANT SELECT ON TABLE src_contents TO PUBLIC;
5424 -- Name: src_format; Type: ACL; Schema: public; Owner: dak
5427 REVOKE ALL ON TABLE src_format FROM PUBLIC;
5428 REVOKE ALL ON TABLE src_format FROM dak;
5429 GRANT ALL ON TABLE src_format TO dak;
5430 GRANT SELECT ON TABLE src_format TO PUBLIC;
5431 GRANT ALL ON TABLE src_format TO ftpmaster;
5435 -- Name: src_format_id_seq; Type: ACL; Schema: public; Owner: dak
5438 REVOKE ALL ON SEQUENCE src_format_id_seq FROM PUBLIC;
5439 REVOKE ALL ON SEQUENCE src_format_id_seq FROM dak;
5440 GRANT ALL ON SEQUENCE src_format_id_seq TO dak;
5441 GRANT ALL ON SEQUENCE src_format_id_seq TO ftpmaster;
5442 GRANT SELECT ON SEQUENCE src_format_id_seq TO PUBLIC;
5446 -- Name: src_uploaders; Type: ACL; Schema: public; Owner: dak
5449 REVOKE ALL ON TABLE src_uploaders FROM PUBLIC;
5450 REVOKE ALL ON TABLE src_uploaders FROM dak;
5451 GRANT ALL ON TABLE src_uploaders TO dak;
5452 GRANT SELECT ON TABLE src_uploaders TO PUBLIC;
5453 GRANT ALL ON TABLE src_uploaders TO ftpmaster;
5457 -- Name: src_uploaders_id_seq; Type: ACL; Schema: public; Owner: dak
5460 REVOKE ALL ON SEQUENCE src_uploaders_id_seq FROM PUBLIC;
5461 REVOKE ALL ON SEQUENCE src_uploaders_id_seq FROM dak;
5462 GRANT ALL ON SEQUENCE src_uploaders_id_seq TO dak;
5463 GRANT SELECT ON SEQUENCE src_uploaders_id_seq TO PUBLIC;
5464 GRANT ALL ON SEQUENCE src_uploaders_id_seq TO ftpmaster;
5468 -- Name: suite_architectures; Type: ACL; Schema: public; Owner: dak
5471 REVOKE ALL ON TABLE suite_architectures FROM PUBLIC;
5472 REVOKE ALL ON TABLE suite_architectures FROM dak;
5473 GRANT ALL ON TABLE suite_architectures TO dak;
5474 GRANT SELECT ON TABLE suite_architectures TO PUBLIC;
5475 GRANT ALL ON TABLE suite_architectures TO ftpmaster;
5479 -- Name: suite_arch_by_name; Type: ACL; Schema: public; Owner: dak
5482 REVOKE ALL ON TABLE suite_arch_by_name FROM PUBLIC;
5483 REVOKE ALL ON TABLE suite_arch_by_name FROM dak;
5484 GRANT ALL ON TABLE suite_arch_by_name TO dak;
5485 GRANT SELECT ON TABLE suite_arch_by_name TO PUBLIC;
5486 GRANT SELECT ON TABLE suite_arch_by_name TO ftpmaster;
5490 -- Name: suite_build_queue_copy; Type: ACL; Schema: public; Owner: dak
5493 REVOKE ALL ON TABLE suite_build_queue_copy FROM PUBLIC;
5494 REVOKE ALL ON TABLE suite_build_queue_copy FROM dak;
5495 GRANT ALL ON TABLE suite_build_queue_copy TO dak;
5496 GRANT SELECT ON TABLE suite_build_queue_copy TO PUBLIC;
5497 GRANT ALL ON TABLE suite_build_queue_copy TO ftpmaster;
5501 -- Name: suite_src_formats; Type: ACL; Schema: public; Owner: dak
5504 REVOKE ALL ON TABLE suite_src_formats FROM PUBLIC;
5505 REVOKE ALL ON TABLE suite_src_formats FROM dak;
5506 GRANT ALL ON TABLE suite_src_formats TO dak;
5507 GRANT SELECT ON TABLE suite_src_formats TO PUBLIC;
5508 GRANT ALL ON TABLE suite_src_formats TO ftpmaster;
5512 -- Name: uid_id_seq; Type: ACL; Schema: public; Owner: dak
5515 REVOKE ALL ON SEQUENCE uid_id_seq FROM PUBLIC;
5516 REVOKE ALL ON SEQUENCE uid_id_seq FROM dak;
5517 GRANT ALL ON SEQUENCE uid_id_seq TO dak;
5518 GRANT SELECT ON SEQUENCE uid_id_seq TO PUBLIC;
5519 GRANT ALL ON SEQUENCE uid_id_seq TO ftpmaster;
5523 -- Name: uid; Type: ACL; Schema: public; Owner: dak
5526 REVOKE ALL ON TABLE uid FROM PUBLIC;
5527 REVOKE ALL ON TABLE uid FROM dak;
5528 GRANT ALL ON TABLE uid TO dak;
5529 GRANT SELECT ON TABLE uid TO PUBLIC;
5530 GRANT ALL ON TABLE uid TO ftpmaster;
5534 -- Name: upload_blocks; Type: ACL; Schema: public; Owner: dak
5537 REVOKE ALL ON TABLE upload_blocks FROM PUBLIC;
5538 REVOKE ALL ON TABLE upload_blocks FROM dak;
5539 GRANT ALL ON TABLE upload_blocks TO dak;
5540 GRANT SELECT ON TABLE upload_blocks TO PUBLIC;
5541 GRANT ALL ON TABLE upload_blocks TO ftpmaster;
5545 -- Name: upload_blocks_id_seq; Type: ACL; Schema: public; Owner: dak
5548 REVOKE ALL ON SEQUENCE upload_blocks_id_seq FROM PUBLIC;
5549 REVOKE ALL ON SEQUENCE upload_blocks_id_seq FROM dak;
5550 GRANT ALL ON SEQUENCE upload_blocks_id_seq TO dak;
5551 GRANT ALL ON SEQUENCE upload_blocks_id_seq TO ftpmaster;
5552 GRANT SELECT ON SEQUENCE upload_blocks_id_seq TO PUBLIC;
5556 -- Name: version_check; Type: ACL; Schema: public; Owner: dak
5559 REVOKE ALL ON TABLE version_check FROM PUBLIC;
5560 REVOKE ALL ON TABLE version_check FROM dak;
5561 GRANT ALL ON TABLE version_check TO dak;
5562 GRANT SELECT,INSERT,UPDATE ON TABLE version_check TO ftpmaster;
5563 GRANT SELECT ON TABLE version_check TO PUBLIC;
5567 -- Name: version_checks; Type: ACL; Schema: public; Owner: dak
5570 REVOKE ALL ON TABLE version_checks FROM PUBLIC;
5571 REVOKE ALL ON TABLE version_checks FROM dak;
5572 GRANT ALL ON TABLE version_checks TO dak;
5573 GRANT SELECT ON TABLE version_checks TO PUBLIC;
5577 -- PostgreSQL database dump complete
5580 -- Set schema version
5581 INSERT INTO config (name, value) VALUES ('db_revision', 61);