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: audit; Type: SCHEMA; Schema: -; Owner: dak
19 ALTER SCHEMA audit 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;
30 SET search_path = public, pg_catalog;
33 -- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres
36 CREATE TYPE debversion;
40 -- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres
43 CREATE FUNCTION debversionin(cstring) RETURNS debversion
44 LANGUAGE internal IMMUTABLE STRICT
48 ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres;
51 -- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres
54 CREATE FUNCTION debversionout(debversion) RETURNS cstring
55 LANGUAGE internal IMMUTABLE STRICT
59 ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres;
62 -- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres
65 CREATE FUNCTION debversionrecv(internal) RETURNS debversion
66 LANGUAGE internal STABLE STRICT
70 ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres;
73 -- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres
76 CREATE FUNCTION debversionsend(debversion) RETURNS bytea
77 LANGUAGE internal STABLE STRICT
81 ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres;
84 -- Name: debversion; Type: TYPE; Schema: public; Owner: postgres
87 CREATE TYPE debversion (
88 INTERNALLENGTH = variable,
90 OUTPUT = debversionout,
91 RECEIVE = debversionrecv,
92 SEND = debversionsend,
99 ALTER TYPE public.debversion OWNER TO postgres;
102 -- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres
105 COMMENT ON TYPE debversion IS 'Debian package version number';
109 -- Name: bin_associations_id_max(); Type: FUNCTION; Schema: public; Owner: dak
112 CREATE FUNCTION bin_associations_id_max() RETURNS integer
114 AS $$SELECT max(id) FROM bin_associations$$;
117 ALTER FUNCTION public.bin_associations_id_max() OWNER TO dak;
120 -- Name: binaries_id_max(); Type: FUNCTION; Schema: public; Owner: dak
123 CREATE FUNCTION binaries_id_max() RETURNS integer
125 AS $$SELECT max(id) FROM binaries$$;
128 ALTER FUNCTION public.binaries_id_max() OWNER TO dak;
131 -- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres
134 CREATE FUNCTION debversion(character) RETURNS debversion
135 LANGUAGE internal IMMUTABLE STRICT
139 ALTER FUNCTION public.debversion(character) OWNER TO postgres;
142 -- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
145 CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer
146 LANGUAGE c IMMUTABLE STRICT
147 AS '$libdir/debversion', 'debversion_cmp';
150 ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres;
153 -- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
156 COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions';
160 -- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
163 CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean
164 LANGUAGE c IMMUTABLE STRICT
165 AS '$libdir/debversion', 'debversion_eq';
168 ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres;
171 -- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
174 COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal';
178 -- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
181 CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean
182 LANGUAGE c IMMUTABLE STRICT
183 AS '$libdir/debversion', 'debversion_ge';
186 ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres;
189 -- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
192 COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal';
196 -- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
199 CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean
200 LANGUAGE c IMMUTABLE STRICT
201 AS '$libdir/debversion', 'debversion_gt';
204 ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres;
207 -- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
210 COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than';
214 -- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres
217 CREATE FUNCTION debversion_hash(debversion) RETURNS integer
218 LANGUAGE c IMMUTABLE STRICT
219 AS '$libdir/debversion', 'debversion_hash';
222 ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres;
225 -- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
228 CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion
229 LANGUAGE c IMMUTABLE STRICT
230 AS '$libdir/debversion', 'debversion_larger';
233 ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres;
236 -- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
239 CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean
240 LANGUAGE c IMMUTABLE STRICT
241 AS '$libdir/debversion', 'debversion_le';
244 ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres;
247 -- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
250 COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal';
254 -- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
257 CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean
258 LANGUAGE c IMMUTABLE STRICT
259 AS '$libdir/debversion', 'debversion_lt';
262 ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres;
265 -- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
268 COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than';
272 -- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
275 CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean
276 LANGUAGE c IMMUTABLE STRICT
277 AS '$libdir/debversion', 'debversion_ne';
280 ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres;
283 -- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres
286 COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal';
290 -- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres
293 CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion
294 LANGUAGE c IMMUTABLE STRICT
295 AS '$libdir/debversion', 'debversion_smaller';
298 ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres;
301 -- Name: dsc_files_id_max(); Type: FUNCTION; Schema: public; Owner: dak
304 CREATE FUNCTION dsc_files_id_max() RETURNS integer
306 AS $$SELECT max(id) FROM dsc_files$$;
309 ALTER FUNCTION public.dsc_files_id_max() OWNER TO dak;
312 -- Name: files_id_max(); Type: FUNCTION; Schema: public; Owner: dak
315 CREATE FUNCTION files_id_max() RETURNS integer
317 AS $$SELECT max(id) FROM files$$;
320 ALTER FUNCTION public.files_id_max() OWNER TO dak;
323 -- Name: override_type_id_max(); Type: FUNCTION; Schema: public; Owner: dak
326 CREATE FUNCTION override_type_id_max() RETURNS integer
328 AS $$SELECT max(id) FROM override_type$$;
331 ALTER FUNCTION public.override_type_id_max() OWNER TO dak;
334 -- Name: priority_id_max(); Type: FUNCTION; Schema: public; Owner: dak
337 CREATE FUNCTION priority_id_max() RETURNS integer
339 AS $$SELECT max(id) FROM priority$$;
342 ALTER FUNCTION public.priority_id_max() OWNER TO dak;
345 -- Name: section_id_max(); Type: FUNCTION; Schema: public; Owner: dak
348 CREATE FUNCTION section_id_max() RETURNS integer
350 AS $$SELECT max(id) FROM section$$;
353 ALTER FUNCTION public.section_id_max() OWNER TO dak;
356 -- Name: source_id_max(); Type: FUNCTION; Schema: public; Owner: dak
359 CREATE FUNCTION source_id_max() RETURNS integer
361 AS $$SELECT max(id) FROM source$$;
364 ALTER FUNCTION public.source_id_max() OWNER TO dak;
367 -- Name: space_concat(text, text); Type: FUNCTION; Schema: public; Owner: dak
370 CREATE FUNCTION space_concat(text, text) RETURNS text
373 WHEN $2 is null or $2 = '' THEN $1
374 WHEN $1 is null or $1 = '' THEN $2
379 ALTER FUNCTION public.space_concat(text, text) OWNER TO dak;
382 -- Name: src_associations_id_max(); Type: FUNCTION; Schema: public; Owner: dak
385 CREATE FUNCTION src_associations_id_max() RETURNS integer
387 AS $$SELECT max(id) FROM src_associations$$;
390 ALTER FUNCTION public.src_associations_id_max() OWNER TO dak;
393 -- Name: tfunc_set_modified(); Type: FUNCTION; Schema: public; Owner: dak
396 CREATE FUNCTION tfunc_set_modified() RETURNS trigger
399 BEGIN NEW.modified = now(); return NEW; END;
403 ALTER FUNCTION public.tfunc_set_modified() OWNER TO dak;
406 -- Name: trigger_binsrc_assoc_update(); Type: FUNCTION; Schema: public; Owner: dak
409 CREATE FUNCTION trigger_binsrc_assoc_update() RETURNS trigger
410 LANGUAGE plpgsql SECURITY DEFINER
411 SET search_path TO public, pg_temp
416 v_package audit.package_changes.package%TYPE;
417 v_version audit.package_changes.version%TYPE;
418 v_architecture audit.package_changes.architecture%TYPE;
419 v_suite audit.package_changes.suite%TYPE;
420 v_event audit.package_changes.event%TYPE;
421 v_priority audit.package_changes.priority%TYPE;
422 v_component audit.package_changes.component%TYPE;
423 v_section audit.package_changes.section%TYPE;
426 WHEN 'INSERT' THEN v_event := 'I'; v_data := NEW;
427 WHEN 'DELETE' THEN v_event := 'D'; v_data := OLD;
428 ELSE RAISE EXCEPTION 'trigger called for invalid operation (%)', TG_OP;
431 SELECT suite_name INTO STRICT v_suite FROM suite WHERE id = v_data.suite;
434 WHEN 'bin_associations' THEN
435 SELECT package, version, arch_string
436 INTO STRICT v_package, v_version, v_architecture
437 FROM binaries LEFT JOIN architecture ON (architecture.id = binaries.architecture)
438 WHERE binaries.id = v_data.bin;
440 SELECT component.name, priority.priority, section.section
441 INTO v_component, v_priority, v_section
443 JOIN override_type ON (override.type = override_type.id)
444 JOIN priority ON (priority.id = override.priority)
445 JOIN section ON (section.id = override.section)
446 JOIN component ON (override.component = component.id)
447 JOIN suite ON (suite.id = override.suite)
448 WHERE override_type.type != 'dsc'
449 AND override.package = v_package AND suite.id = v_data.suite;
451 WHEN 'src_associations' THEN
452 SELECT source, version
453 INTO STRICT v_package, v_version
454 FROM source WHERE source.id = v_data.source;
455 v_architecture := 'source';
457 SELECT component.name, priority.priority, section.section
458 INTO v_component, v_priority, v_section
460 JOIN override_type ON (override.type = override_type.id)
461 JOIN priority ON (priority.id = override.priority)
462 JOIN section ON (section.id = override.section)
463 JOIN component ON (override.component = component.id)
464 JOIN suite ON (suite.id = override.suite)
465 WHERE override_type.type = 'dsc'
466 AND override.package = v_package AND suite.id = v_data.suite;
468 ELSE RAISE EXCEPTION 'trigger called for invalid table (%)', TG_TABLE_NAME;
471 INSERT INTO audit.package_changes
472 (package, version, architecture, suite, event, priority, component, section)
473 VALUES (v_package, v_version, v_architecture, v_suite, v_event, v_priority, v_component, v_section);
480 ALTER FUNCTION public.trigger_binsrc_assoc_update() OWNER TO dak;
483 -- Name: trigger_override_update(); Type: FUNCTION; Schema: public; Owner: dak
486 CREATE FUNCTION trigger_override_update() RETURNS trigger
487 LANGUAGE plpgsql SECURITY DEFINER
488 SET search_path TO public, pg_temp
491 v_src_override_id override_type.id%TYPE;
493 v_priority audit.package_changes.priority%TYPE := NULL;
494 v_component audit.package_changes.component%TYPE := NULL;
495 v_section audit.package_changes.section%TYPE := NULL;
498 IF TG_TABLE_NAME != 'override' THEN
499 RAISE EXCEPTION 'trigger called for invalid table (%)', TG_TABLE_NAME;
501 IF TG_OP != 'UPDATE' THEN
502 RAISE EXCEPTION 'trigger called for invalid event (%)', TG_OP;
505 IF OLD.package != NEW.package OR OLD.type != NEW.type OR OLD.suite != NEW.suite THEN
509 IF OLD.priority != NEW.priority THEN
510 SELECT priority INTO STRICT v_priority FROM priority WHERE id = NEW.priority;
513 IF OLD.component != NEW.component THEN
514 SELECT name INTO STRICT v_component FROM component WHERE id = NEW.component;
517 IF OLD.section != NEW.section THEN
518 SELECT section INTO STRICT v_section FROM section WHERE id = NEW.section;
521 -- Find out if we're doing src or binary overrides
522 SELECT id INTO STRICT v_src_override_id FROM override_type WHERE type = 'dsc';
523 IF OLD.type = v_src_override_id THEN
524 -- Doing a src_association link
525 INSERT INTO audit.package_changes
526 (package, version, architecture, suite, event, priority, component, section)
527 SELECT NEW.package, source.version, 'source', suite.suite_name, 'U', v_priority, v_component, v_section
529 JOIN src_associations ON (source.id = src_associations.source)
530 JOIN suite ON (suite.id = src_associations.suite)
531 WHERE source.source = NEW.package AND src_associations.suite = NEW.suite;
533 -- Doing a bin_association link
534 INSERT INTO audit.package_changes
535 (package, version, architecture, suite, event, priority, component, section)
536 SELECT NEW.package, binaries.version, architecture.arch_string, suite.suite_name, 'U', v_priority, v_component, v_section
538 JOIN bin_associations ON (binaries.id = bin_associations.bin)
539 JOIN architecture ON (architecture.id = binaries.architecture)
540 JOIN suite ON (suite.id = bin_associations.suite)
541 WHERE binaries.package = NEW.package AND bin_associations.suite = NEW.suite;
549 ALTER FUNCTION public.trigger_override_update() OWNER TO dak;
552 -- Name: >; Type: OPERATOR; Schema: public; Owner: postgres
556 PROCEDURE = debversion_gt,
557 LEFTARG = debversion,
558 RIGHTARG = debversion,
564 ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres;
567 -- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
570 COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than';
574 -- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
577 CREATE AGGREGATE max(debversion) (
578 SFUNC = debversion_larger,
584 ALTER AGGREGATE public.max(debversion) OWNER TO postgres;
587 -- Name: <; Type: OPERATOR; Schema: public; Owner: postgres
591 PROCEDURE = debversion_lt,
592 LEFTARG = debversion,
593 RIGHTARG = debversion,
599 ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres;
602 -- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
605 COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than';
609 -- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres
612 CREATE AGGREGATE min(debversion) (
613 SFUNC = debversion_smaller,
619 ALTER AGGREGATE public.min(debversion) OWNER TO postgres;
622 -- Name: space_separated_list(text); Type: AGGREGATE; Schema: public; Owner: dak
625 CREATE AGGREGATE space_separated_list(text) (
626 SFUNC = space_concat,
632 ALTER AGGREGATE public.space_separated_list(text) OWNER TO dak;
635 -- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres
639 PROCEDURE = debversion_le,
640 LEFTARG = debversion,
641 RIGHTARG = debversion,
647 ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres;
650 -- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
653 COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal';
657 -- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres
661 PROCEDURE = debversion_ne,
662 LEFTARG = debversion,
663 RIGHTARG = debversion,
669 ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres;
672 -- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
675 COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal';
679 -- Name: =; Type: OPERATOR; Schema: public; Owner: postgres
683 PROCEDURE = debversion_eq,
684 LEFTARG = debversion,
685 RIGHTARG = debversion,
691 ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres;
694 -- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
697 COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal';
701 -- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres
705 PROCEDURE = debversion_ge,
706 LEFTARG = debversion,
707 RIGHTARG = debversion,
713 ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres;
716 -- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres
719 COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal';
723 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
726 CREATE OPERATOR CLASS debversion_ops
727 DEFAULT FOR TYPE debversion USING btree AS
728 OPERATOR 1 <(debversion,debversion) ,
729 OPERATOR 2 <=(debversion,debversion) ,
730 OPERATOR 3 =(debversion,debversion) ,
731 OPERATOR 4 >=(debversion,debversion) ,
732 OPERATOR 5 >(debversion,debversion) ,
733 FUNCTION 1 debversion_cmp(debversion,debversion);
736 ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres;
739 -- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
742 CREATE OPERATOR CLASS debversion_ops
743 DEFAULT FOR TYPE debversion USING hash AS
744 OPERATOR 1 =(debversion,debversion) ,
745 FUNCTION 1 debversion_hash(debversion);
748 ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres;
750 SET search_path = pg_catalog;
753 -- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
756 CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character);
760 -- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner:
763 CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT;
767 -- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner:
770 CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT;
774 -- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner:
777 CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT;
781 -- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
784 CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
788 -- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner:
791 CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT;
794 SET search_path = audit, pg_catalog;
796 SET default_tablespace = '';
798 SET default_with_oids = false;
801 -- Name: package_changes; Type: TABLE; Schema: audit; Owner: dak; Tablespace:
804 CREATE TABLE package_changes (
805 changedate timestamp without time zone DEFAULT now() NOT NULL,
806 package text NOT NULL,
807 version public.debversion NOT NULL,
808 architecture text NOT NULL,
817 ALTER TABLE audit.package_changes OWNER TO dak;
819 SET search_path = public, pg_catalog;
822 -- Name: bin_associations_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
825 CREATE SEQUENCE bin_associations_id_seq
833 ALTER TABLE public.bin_associations_id_seq OWNER TO dak;
836 -- Name: bin_associations; Type: TABLE; Schema: public; Owner: dak; Tablespace:
839 CREATE TABLE bin_associations (
840 id integer DEFAULT nextval('bin_associations_id_seq'::regclass) NOT NULL,
841 suite integer NOT NULL,
842 bin integer NOT NULL,
843 created timestamp with time zone DEFAULT now() NOT NULL,
844 modified timestamp with time zone DEFAULT now() NOT NULL
848 ALTER TABLE public.bin_associations OWNER TO dak;
851 -- Name: binaries_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
854 CREATE SEQUENCE binaries_id_seq
862 ALTER TABLE public.binaries_id_seq OWNER TO dak;
865 -- Name: binaries; Type: TABLE; Schema: public; Owner: dak; Tablespace:
868 CREATE TABLE binaries (
869 id integer DEFAULT nextval('binaries_id_seq'::regclass) NOT NULL,
870 package text NOT NULL,
871 version debversion NOT NULL,
872 maintainer integer NOT NULL,
873 source integer NOT NULL,
874 architecture integer NOT NULL,
875 file integer NOT NULL,
878 install_date timestamp with time zone DEFAULT now(),
879 created timestamp with time zone DEFAULT now() NOT NULL,
880 modified timestamp with time zone DEFAULT now() NOT NULL,
885 ALTER TABLE public.binaries OWNER TO dak;
888 -- Name: bin_associations_binaries; Type: VIEW; Schema: public; Owner: dak
891 CREATE VIEW bin_associations_binaries AS
892 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)));
895 ALTER TABLE public.bin_associations_binaries OWNER TO dak;
898 -- Name: source_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
901 CREATE SEQUENCE source_id_seq
909 ALTER TABLE public.source_id_seq OWNER TO dak;
912 -- Name: source; Type: TABLE; Schema: public; Owner: dak; Tablespace:
915 CREATE TABLE source (
916 id integer DEFAULT nextval('source_id_seq'::regclass) NOT NULL,
917 source text NOT NULL,
918 version debversion NOT NULL,
919 maintainer integer NOT NULL,
920 file integer NOT NULL,
922 install_date timestamp with time zone NOT NULL,
923 changedby integer NOT NULL,
924 dm_upload_allowed boolean DEFAULT false NOT NULL,
925 created timestamp with time zone DEFAULT now() NOT NULL,
926 modified timestamp with time zone DEFAULT now() NOT NULL,
931 ALTER TABLE public.source OWNER TO dak;
934 -- Name: src_associations_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
937 CREATE SEQUENCE src_associations_id_seq
945 ALTER TABLE public.src_associations_id_seq OWNER TO dak;
948 -- Name: src_associations; Type: TABLE; Schema: public; Owner: dak; Tablespace:
951 CREATE TABLE src_associations (
952 id integer DEFAULT nextval('src_associations_id_seq'::regclass) NOT NULL,
953 suite integer NOT NULL,
954 source integer NOT NULL,
955 created timestamp with time zone DEFAULT now() NOT NULL,
956 modified timestamp with time zone DEFAULT now() NOT NULL
960 ALTER TABLE public.src_associations OWNER TO dak;
963 -- Name: src_associations_bin; Type: VIEW; Schema: public; Owner: dak
966 CREATE VIEW src_associations_bin AS
967 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)));
970 ALTER TABLE public.src_associations_bin OWNER TO dak;
973 -- Name: almost_obsolete_all_associations; Type: VIEW; Schema: public; Owner: dak
976 CREATE VIEW almost_obsolete_all_associations AS
977 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));
980 ALTER TABLE public.almost_obsolete_all_associations OWNER TO dak;
983 -- Name: any_associations_source; Type: VIEW; Schema: public; Owner: dak
986 CREATE VIEW any_associations_source AS
987 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)));
990 ALTER TABLE public.any_associations_source OWNER TO dak;
993 -- Name: src_associations_src; Type: VIEW; Schema: public; Owner: dak
996 CREATE VIEW src_associations_src AS
997 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)));
1000 ALTER TABLE public.src_associations_src OWNER TO dak;
1003 -- Name: almost_obsolete_src_associations; Type: VIEW; Schema: public; Owner: dak
1006 CREATE VIEW almost_obsolete_src_associations AS
1007 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);
1010 ALTER TABLE public.almost_obsolete_src_associations OWNER TO dak;
1013 -- Name: architecture_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1016 CREATE SEQUENCE architecture_id_seq
1024 ALTER TABLE public.architecture_id_seq OWNER TO dak;
1027 -- Name: architecture; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1030 CREATE TABLE architecture (
1031 id integer DEFAULT nextval('architecture_id_seq'::regclass) NOT NULL,
1032 arch_string text NOT NULL,
1034 created timestamp with time zone DEFAULT now() NOT NULL,
1035 modified timestamp with time zone DEFAULT now() NOT NULL
1039 ALTER TABLE public.architecture OWNER TO dak;
1042 -- Name: archive_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1045 CREATE SEQUENCE archive_id_seq
1053 ALTER TABLE public.archive_id_seq OWNER TO dak;
1056 -- Name: archive; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1059 CREATE TABLE archive (
1060 id integer DEFAULT nextval('archive_id_seq'::regclass) NOT NULL,
1064 created timestamp with time zone DEFAULT now() NOT NULL,
1065 modified timestamp with time zone DEFAULT now() NOT NULL,
1070 ALTER TABLE public.archive OWNER TO dak;
1073 -- Name: bin_contents; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1076 CREATE TABLE bin_contents (
1078 binary_id integer NOT NULL,
1079 created timestamp with time zone DEFAULT now() NOT NULL,
1080 modified timestamp with time zone DEFAULT now() NOT NULL
1084 ALTER TABLE public.bin_contents OWNER TO dak;
1087 -- Name: binaries_metadata; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1090 CREATE TABLE binaries_metadata (
1091 bin_id integer NOT NULL,
1092 key_id integer NOT NULL,
1097 ALTER TABLE public.binaries_metadata OWNER TO dak;
1100 -- Name: suite_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1103 CREATE SEQUENCE suite_id_seq
1111 ALTER TABLE public.suite_id_seq OWNER TO dak;
1114 -- Name: suite; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1117 CREATE TABLE suite (
1118 id integer DEFAULT nextval('suite_id_seq'::regclass) NOT NULL,
1119 suite_name text NOT NULL,
1124 untouchable boolean DEFAULT false NOT NULL,
1126 overridecodename text,
1127 validtime integer DEFAULT 604800 NOT NULL,
1128 priority integer DEFAULT 0 NOT NULL,
1129 notautomatic boolean DEFAULT false NOT NULL,
1132 policy_queue_id integer,
1133 created timestamp with time zone DEFAULT now() NOT NULL,
1134 modified timestamp with time zone DEFAULT now() NOT NULL,
1136 butautomaticupgrades boolean DEFAULT false NOT NULL,
1139 CONSTRAINT bau_needs_na_set CHECK (((NOT butautomaticupgrades) OR notautomatic))
1143 ALTER TABLE public.suite OWNER TO dak;
1146 -- Name: binaries_suite_arch; Type: VIEW; Schema: public; Owner: dak
1149 CREATE VIEW binaries_suite_arch AS
1150 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)));
1153 ALTER TABLE public.binaries_suite_arch OWNER TO dak;
1156 -- Name: binary_acl; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1159 CREATE TABLE binary_acl (
1160 id integer NOT NULL,
1161 access_level text NOT NULL,
1162 created timestamp with time zone DEFAULT now() NOT NULL,
1163 modified timestamp with time zone DEFAULT now() NOT NULL
1167 ALTER TABLE public.binary_acl OWNER TO dak;
1170 -- Name: binary_acl_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1173 CREATE SEQUENCE binary_acl_id_seq
1181 ALTER TABLE public.binary_acl_id_seq OWNER TO dak;
1184 -- Name: binary_acl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1187 ALTER SEQUENCE binary_acl_id_seq OWNED BY binary_acl.id;
1191 -- Name: binary_acl_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1194 CREATE TABLE binary_acl_map (
1195 id integer NOT NULL,
1196 fingerprint_id integer NOT NULL,
1197 architecture_id integer NOT NULL,
1198 created timestamp with time zone DEFAULT now() NOT NULL,
1199 modified timestamp with time zone DEFAULT now() NOT NULL
1203 ALTER TABLE public.binary_acl_map OWNER TO dak;
1206 -- Name: binary_acl_map_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1209 CREATE SEQUENCE binary_acl_map_id_seq
1217 ALTER TABLE public.binary_acl_map_id_seq OWNER TO dak;
1220 -- Name: binary_acl_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1223 ALTER SEQUENCE binary_acl_map_id_seq OWNED BY binary_acl_map.id;
1227 -- Name: files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1230 CREATE SEQUENCE files_id_seq
1238 ALTER TABLE public.files_id_seq OWNER TO dak;
1241 -- Name: files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1244 CREATE TABLE files (
1245 id integer DEFAULT nextval('files_id_seq'::regclass) NOT NULL,
1246 filename text NOT NULL,
1247 size bigint NOT NULL,
1248 md5sum text NOT NULL,
1249 location integer NOT NULL,
1250 last_used timestamp with time zone,
1253 created timestamp with time zone DEFAULT now() NOT NULL,
1254 modified timestamp with time zone DEFAULT now() NOT NULL
1258 ALTER TABLE public.files OWNER TO dak;
1261 -- Name: location_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1264 CREATE SEQUENCE location_id_seq
1272 ALTER TABLE public.location_id_seq OWNER TO dak;
1275 -- Name: location; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1278 CREATE TABLE location (
1279 id integer DEFAULT nextval('location_id_seq'::regclass) NOT NULL,
1284 created timestamp with time zone DEFAULT now() NOT NULL,
1285 modified timestamp with time zone DEFAULT now() NOT NULL
1289 ALTER TABLE public.location OWNER TO dak;
1292 -- Name: binfiles_suite_component_arch; Type: VIEW; Schema: public; Owner: dak
1295 CREATE VIEW binfiles_suite_component_arch AS
1296 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)));
1299 ALTER TABLE public.binfiles_suite_component_arch OWNER TO dak;
1302 -- Name: build_queue; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1305 CREATE TABLE build_queue (
1306 id integer NOT NULL,
1307 queue_name text NOT NULL,
1309 copy_files boolean DEFAULT false NOT NULL,
1310 generate_metadata boolean DEFAULT false NOT NULL,
1313 releasedescription text,
1315 stay_of_execution integer DEFAULT 86400 NOT NULL,
1316 created timestamp with time zone DEFAULT now() NOT NULL,
1317 modified timestamp with time zone DEFAULT now() NOT NULL,
1318 notautomatic boolean DEFAULT false NOT NULL,
1319 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)))),
1320 CONSTRAINT build_queue_stay_of_execution_check CHECK ((stay_of_execution >= 0))
1324 ALTER TABLE public.build_queue OWNER TO dak;
1327 -- Name: build_queue_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1330 CREATE TABLE build_queue_files (
1331 id integer NOT NULL,
1332 build_queue_id integer NOT NULL,
1333 insertdate timestamp without time zone DEFAULT now() NOT NULL,
1334 lastused timestamp without time zone,
1335 filename text NOT NULL,
1337 created timestamp with time zone DEFAULT now() NOT NULL,
1338 modified timestamp with time zone DEFAULT now() NOT NULL
1342 ALTER TABLE public.build_queue_files OWNER TO dak;
1345 -- Name: build_queue_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1348 CREATE SEQUENCE build_queue_files_id_seq
1356 ALTER TABLE public.build_queue_files_id_seq OWNER TO dak;
1359 -- Name: build_queue_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1362 ALTER SEQUENCE build_queue_files_id_seq OWNED BY build_queue_files.id;
1366 -- Name: build_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1369 CREATE SEQUENCE build_queue_id_seq
1377 ALTER TABLE public.build_queue_id_seq OWNER TO dak;
1380 -- Name: build_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1383 ALTER SEQUENCE build_queue_id_seq OWNED BY build_queue.id;
1387 -- Name: build_queue_policy_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1390 CREATE TABLE build_queue_policy_files (
1391 build_queue_id integer NOT NULL,
1392 file_id integer NOT NULL,
1393 filename text NOT NULL,
1394 created timestamp with time zone DEFAULT now() NOT NULL,
1395 lastused timestamp without time zone
1399 ALTER TABLE public.build_queue_policy_files OWNER TO dak;
1402 -- Name: changelogs_text; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1405 CREATE TABLE changelogs_text (
1406 id integer NOT NULL,
1411 ALTER TABLE public.changelogs_text OWNER TO dak;
1414 -- Name: changes; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1417 CREATE TABLE changes (
1418 id integer NOT NULL,
1419 changesname text NOT NULL,
1420 seen timestamp with time zone DEFAULT now() NOT NULL,
1421 source text NOT NULL,
1422 binaries text NOT NULL,
1423 architecture text NOT NULL,
1424 version text NOT NULL,
1425 distribution text NOT NULL,
1426 urgency text NOT NULL,
1427 maintainer text NOT NULL,
1428 fingerprint text NOT NULL,
1429 changedby text NOT NULL,
1432 approved_for integer,
1433 created timestamp with time zone DEFAULT now() NOT NULL,
1434 modified timestamp with time zone DEFAULT now() NOT NULL,
1435 changelog_id integer
1439 ALTER TABLE public.changes OWNER TO dak;
1442 -- Name: changelogs; Type: VIEW; Schema: public; Owner: dak
1445 CREATE VIEW changelogs AS
1446 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)));
1449 ALTER TABLE public.changelogs OWNER TO dak;
1452 -- Name: changelogs_text_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1455 CREATE SEQUENCE changelogs_text_id_seq
1463 ALTER TABLE public.changelogs_text_id_seq OWNER TO dak;
1466 -- Name: changelogs_text_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1469 ALTER SEQUENCE changelogs_text_id_seq OWNED BY changelogs_text.id;
1473 -- Name: changes_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1476 CREATE SEQUENCE changes_id_seq
1484 ALTER TABLE public.changes_id_seq OWNER TO dak;
1487 -- Name: changes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1490 ALTER SEQUENCE changes_id_seq OWNED BY changes.id;
1494 -- Name: changes_pending_binaries; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1497 CREATE TABLE changes_pending_binaries (
1498 id integer NOT NULL,
1499 change_id integer NOT NULL,
1500 package text NOT NULL,
1501 version debversion NOT NULL,
1502 architecture_id integer NOT NULL,
1504 pending_source_id integer,
1505 pending_file_id integer,
1506 created timestamp with time zone DEFAULT now() NOT NULL,
1507 modified timestamp with time zone DEFAULT now() NOT NULL,
1508 CONSTRAINT changes_pending_binaries_check CHECK (((source_id IS NOT NULL) OR (pending_source_id IS NOT NULL)))
1512 ALTER TABLE public.changes_pending_binaries OWNER TO dak;
1515 -- Name: changes_pending_binaries_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1518 CREATE SEQUENCE changes_pending_binaries_id_seq
1526 ALTER TABLE public.changes_pending_binaries_id_seq OWNER TO dak;
1529 -- Name: changes_pending_binaries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1532 ALTER SEQUENCE changes_pending_binaries_id_seq OWNED BY changes_pending_binaries.id;
1536 -- Name: changes_pending_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1539 CREATE TABLE changes_pending_files (
1540 id integer NOT NULL,
1541 filename text NOT NULL,
1542 size bigint NOT NULL,
1543 md5sum text NOT NULL,
1544 sha1sum text NOT NULL,
1545 sha256sum text NOT NULL,
1546 created timestamp with time zone DEFAULT now() NOT NULL,
1547 modified timestamp with time zone DEFAULT now() NOT NULL,
1548 processed boolean DEFAULT false
1552 ALTER TABLE public.changes_pending_files OWNER TO dak;
1555 -- Name: changes_pending_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1558 CREATE SEQUENCE changes_pending_files_id_seq
1566 ALTER TABLE public.changes_pending_files_id_seq OWNER TO dak;
1569 -- Name: changes_pending_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1572 ALTER SEQUENCE changes_pending_files_id_seq OWNED BY changes_pending_files.id;
1576 -- Name: changes_pending_files_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1579 CREATE TABLE changes_pending_files_map (
1580 file_id integer NOT NULL,
1581 change_id integer NOT NULL,
1582 created timestamp with time zone DEFAULT now() NOT NULL,
1583 modified timestamp with time zone DEFAULT now() NOT NULL
1587 ALTER TABLE public.changes_pending_files_map OWNER TO dak;
1590 -- Name: changes_pending_source; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1593 CREATE TABLE changes_pending_source (
1594 id integer NOT NULL,
1595 change_id integer NOT NULL,
1596 source text NOT NULL,
1597 version debversion NOT NULL,
1598 maintainer_id integer NOT NULL,
1599 changedby_id integer NOT NULL,
1600 sig_fpr integer NOT NULL,
1601 dm_upload_allowed boolean DEFAULT false NOT NULL,
1602 created timestamp with time zone DEFAULT now() NOT NULL,
1603 modified timestamp with time zone DEFAULT now() NOT NULL
1607 ALTER TABLE public.changes_pending_source OWNER TO dak;
1610 -- Name: changes_pending_source_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1613 CREATE TABLE changes_pending_source_files (
1614 pending_source_id integer NOT NULL,
1615 pending_file_id integer NOT NULL,
1616 created timestamp with time zone DEFAULT now() NOT NULL,
1617 modified timestamp with time zone DEFAULT now() NOT NULL
1621 ALTER TABLE public.changes_pending_source_files OWNER TO dak;
1624 -- Name: changes_pending_source_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1627 CREATE SEQUENCE changes_pending_source_id_seq
1635 ALTER TABLE public.changes_pending_source_id_seq OWNER TO dak;
1638 -- Name: changes_pending_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1641 ALTER SEQUENCE changes_pending_source_id_seq OWNED BY changes_pending_source.id;
1645 -- Name: changes_pool_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1648 CREATE TABLE changes_pool_files (
1649 changeid integer NOT NULL,
1650 fileid integer NOT NULL,
1651 created timestamp with time zone DEFAULT now() NOT NULL,
1652 modified timestamp with time zone DEFAULT now() NOT NULL
1656 ALTER TABLE public.changes_pool_files OWNER TO dak;
1659 -- Name: component_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1662 CREATE SEQUENCE component_id_seq
1670 ALTER TABLE public.component_id_seq OWNER TO dak;
1673 -- Name: component; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1676 CREATE TABLE component (
1677 id integer DEFAULT nextval('component_id_seq'::regclass) NOT NULL,
1681 created timestamp with time zone DEFAULT now() NOT NULL,
1682 modified timestamp with time zone DEFAULT now() NOT NULL
1686 ALTER TABLE public.component OWNER TO dak;
1689 -- Name: config; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1692 CREATE TABLE config (
1693 id integer NOT NULL,
1696 created timestamp with time zone DEFAULT now() NOT NULL,
1697 modified timestamp with time zone DEFAULT now() NOT NULL
1701 ALTER TABLE public.config OWNER TO dak;
1704 -- Name: config_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1707 CREATE SEQUENCE config_id_seq
1715 ALTER TABLE public.config_id_seq OWNER TO dak;
1718 -- Name: config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1721 ALTER SEQUENCE config_id_seq OWNED BY config.id;
1725 -- Name: dsc_files_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1728 CREATE SEQUENCE dsc_files_id_seq
1736 ALTER TABLE public.dsc_files_id_seq OWNER TO dak;
1739 -- Name: dsc_files; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1742 CREATE TABLE dsc_files (
1743 id integer DEFAULT nextval('dsc_files_id_seq'::regclass) NOT NULL,
1744 source integer NOT NULL,
1745 file integer NOT NULL,
1746 created timestamp with time zone DEFAULT now() NOT NULL,
1747 modified timestamp with time zone DEFAULT now() NOT NULL
1751 ALTER TABLE public.dsc_files OWNER TO dak;
1754 -- Name: external_overrides; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1757 CREATE TABLE external_overrides (
1758 package text NOT NULL,
1760 value text NOT NULL,
1761 suite integer NOT NULL,
1762 component integer NOT NULL
1766 ALTER TABLE public.external_overrides OWNER TO dak;
1769 -- Name: extra_src_references; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1772 CREATE TABLE extra_src_references (
1773 bin_id integer NOT NULL,
1774 src_id integer NOT NULL
1778 ALTER TABLE public.extra_src_references OWNER TO dak;
1781 -- Name: file_arch_suite; Type: VIEW; Schema: public; Owner: dak
1784 CREATE VIEW file_arch_suite AS
1785 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));
1788 ALTER TABLE public.file_arch_suite OWNER TO dak;
1791 -- Name: fingerprint_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1794 CREATE SEQUENCE fingerprint_id_seq
1802 ALTER TABLE public.fingerprint_id_seq OWNER TO dak;
1805 -- Name: fingerprint; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1808 CREATE TABLE fingerprint (
1809 id integer DEFAULT nextval('fingerprint_id_seq'::regclass) NOT NULL,
1810 fingerprint text NOT NULL,
1813 source_acl_id integer,
1814 binary_acl_id integer,
1815 binary_reject boolean DEFAULT true NOT NULL,
1816 created timestamp with time zone DEFAULT now() NOT NULL,
1817 modified timestamp with time zone DEFAULT now() NOT NULL
1821 ALTER TABLE public.fingerprint OWNER TO dak;
1824 -- Name: keyring_acl_map; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1827 CREATE TABLE keyring_acl_map (
1828 id integer NOT NULL,
1829 keyring_id integer NOT NULL,
1830 architecture_id integer NOT NULL,
1831 created timestamp with time zone DEFAULT now() NOT NULL,
1832 modified timestamp with time zone DEFAULT now() NOT NULL
1836 ALTER TABLE public.keyring_acl_map OWNER TO dak;
1839 -- Name: keyring_acl_map_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1842 CREATE SEQUENCE keyring_acl_map_id_seq
1850 ALTER TABLE public.keyring_acl_map_id_seq OWNER TO dak;
1853 -- Name: keyring_acl_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1856 ALTER SEQUENCE keyring_acl_map_id_seq OWNED BY keyring_acl_map.id;
1860 -- Name: keyrings; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1863 CREATE TABLE keyrings (
1864 id integer NOT NULL,
1866 default_source_acl_id integer,
1867 default_binary_acl_id integer,
1868 default_binary_reject boolean DEFAULT true NOT NULL,
1869 priority integer DEFAULT 100 NOT NULL,
1870 created timestamp with time zone DEFAULT now() NOT NULL,
1871 modified timestamp with time zone DEFAULT now() NOT NULL,
1872 active boolean DEFAULT true
1876 ALTER TABLE public.keyrings OWNER TO dak;
1879 -- Name: keyrings_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1882 CREATE SEQUENCE keyrings_id_seq
1890 ALTER TABLE public.keyrings_id_seq OWNER TO dak;
1893 -- Name: keyrings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1896 ALTER SEQUENCE keyrings_id_seq OWNED BY keyrings.id;
1900 -- Name: maintainer_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1903 CREATE SEQUENCE maintainer_id_seq
1911 ALTER TABLE public.maintainer_id_seq OWNER TO dak;
1914 -- Name: maintainer; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1917 CREATE TABLE maintainer (
1918 id integer DEFAULT nextval('maintainer_id_seq'::regclass) NOT NULL,
1920 created timestamp with time zone DEFAULT now() NOT NULL,
1921 modified timestamp with time zone DEFAULT now() NOT NULL
1925 ALTER TABLE public.maintainer OWNER TO dak;
1928 -- Name: metadata_keys; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1931 CREATE TABLE metadata_keys (
1932 key_id integer NOT NULL,
1934 ordering integer DEFAULT 0 NOT NULL
1938 ALTER TABLE public.metadata_keys OWNER TO dak;
1941 -- Name: metadata_keys_key_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1944 CREATE SEQUENCE metadata_keys_key_id_seq
1952 ALTER TABLE public.metadata_keys_key_id_seq OWNER TO dak;
1955 -- Name: metadata_keys_key_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1958 ALTER SEQUENCE metadata_keys_key_id_seq OWNED BY metadata_keys.key_id;
1962 -- Name: new_comments; Type: TABLE; Schema: public; Owner: dak; Tablespace:
1965 CREATE TABLE new_comments (
1966 id integer NOT NULL,
1967 package text NOT NULL,
1968 version text NOT NULL,
1969 comment text NOT NULL,
1970 author text NOT NULL,
1971 notedate timestamp with time zone DEFAULT now() NOT NULL,
1972 trainee boolean DEFAULT false NOT NULL,
1973 created timestamp with time zone DEFAULT now() NOT NULL,
1974 modified timestamp with time zone DEFAULT now() NOT NULL
1978 ALTER TABLE public.new_comments OWNER TO dak;
1981 -- Name: new_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
1984 CREATE SEQUENCE new_comments_id_seq
1992 ALTER TABLE public.new_comments_id_seq OWNER TO dak;
1995 -- Name: new_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
1998 ALTER SEQUENCE new_comments_id_seq OWNED BY new_comments.id;
2002 -- Name: newest_all_associations; Type: VIEW; Schema: public; Owner: dak
2005 CREATE VIEW newest_all_associations AS
2006 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;
2009 ALTER TABLE public.newest_all_associations OWNER TO dak;
2012 -- Name: newest_any_associations; Type: VIEW; Schema: public; Owner: dak
2015 CREATE VIEW newest_any_associations AS
2016 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;
2019 ALTER TABLE public.newest_any_associations OWNER TO dak;
2022 -- Name: source_suite; Type: VIEW; Schema: public; Owner: dak
2025 CREATE VIEW source_suite AS
2026 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)));
2029 ALTER TABLE public.source_suite OWNER TO dak;
2032 -- Name: newest_source; Type: VIEW; Schema: public; Owner: dak
2035 CREATE VIEW newest_source AS
2036 SELECT source_suite.source, max(source_suite.version) AS version, source_suite.suite FROM source_suite GROUP BY source_suite.source, source_suite.suite;
2039 ALTER TABLE public.newest_source OWNER TO dak;
2042 -- Name: newest_src_association; Type: VIEW; Schema: public; Owner: dak
2045 CREATE VIEW newest_src_association AS
2046 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));
2049 ALTER TABLE public.newest_src_association OWNER TO dak;
2052 -- Name: obsolete_all_associations; Type: VIEW; Schema: public; Owner: dak
2055 CREATE VIEW obsolete_all_associations AS
2056 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))));
2059 ALTER TABLE public.obsolete_all_associations OWNER TO dak;
2062 -- Name: obsolete_any_associations; Type: VIEW; Schema: public; Owner: dak
2065 CREATE VIEW obsolete_any_associations AS
2066 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))));
2069 ALTER TABLE public.obsolete_any_associations OWNER TO dak;
2072 -- Name: obsolete_any_by_all_associations; Type: VIEW; Schema: public; Owner: dak
2075 CREATE VIEW obsolete_any_by_all_associations AS
2076 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))));
2079 ALTER TABLE public.obsolete_any_by_all_associations OWNER TO dak;
2082 -- Name: obsolete_src_associations; Type: VIEW; Schema: public; Owner: dak
2085 CREATE VIEW obsolete_src_associations AS
2086 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))));
2089 ALTER TABLE public.obsolete_src_associations OWNER TO dak;
2092 -- Name: override; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2095 CREATE TABLE override (
2096 package text NOT NULL,
2097 suite integer NOT NULL,
2098 component integer NOT NULL,
2100 section integer NOT NULL,
2101 type integer NOT NULL,
2103 created timestamp with time zone DEFAULT now() NOT NULL,
2104 modified timestamp with time zone DEFAULT now() NOT NULL
2108 ALTER TABLE public.override OWNER TO dak;
2111 -- Name: override_type_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2114 CREATE SEQUENCE override_type_id_seq
2122 ALTER TABLE public.override_type_id_seq OWNER TO dak;
2125 -- Name: override_type; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2128 CREATE TABLE override_type (
2129 id integer DEFAULT nextval('override_type_id_seq'::regclass) NOT NULL,
2131 created timestamp with time zone DEFAULT now() NOT NULL,
2132 modified timestamp with time zone DEFAULT now() NOT NULL
2136 ALTER TABLE public.override_type OWNER TO dak;
2139 -- Name: policy_queue; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2142 CREATE TABLE policy_queue (
2143 id integer NOT NULL,
2144 queue_name text NOT NULL,
2146 perms character(4) DEFAULT '0660'::bpchar NOT NULL,
2147 change_perms character(4) DEFAULT '0660'::bpchar NOT NULL,
2148 generate_metadata boolean DEFAULT false NOT NULL,
2151 releasedescription text,
2153 stay_of_execution integer DEFAULT 86400 NOT NULL,
2154 created timestamp with time zone DEFAULT now() NOT NULL,
2155 modified timestamp with time zone DEFAULT now() NOT NULL,
2156 send_to_build_queues boolean DEFAULT false NOT NULL,
2157 CONSTRAINT policy_queue_change_perms_check CHECK ((change_perms ~ similar_escape('[0-7][0-7][0-7][0-7]'::text, NULL::text))),
2158 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)))),
2159 CONSTRAINT policy_queue_perms_check CHECK ((perms ~ similar_escape('[0-7][0-7][0-7][0-7]'::text, NULL::text))),
2160 CONSTRAINT policy_queue_stay_of_execution_check CHECK ((stay_of_execution >= 0))
2164 ALTER TABLE public.policy_queue OWNER TO dak;
2167 -- Name: policy_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2170 CREATE SEQUENCE policy_queue_id_seq
2178 ALTER TABLE public.policy_queue_id_seq OWNER TO dak;
2181 -- Name: policy_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2184 ALTER SEQUENCE policy_queue_id_seq OWNED BY policy_queue.id;
2188 -- Name: priority_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2191 CREATE SEQUENCE priority_id_seq
2199 ALTER TABLE public.priority_id_seq OWNER TO dak;
2202 -- Name: priority; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2205 CREATE TABLE priority (
2206 id integer DEFAULT nextval('priority_id_seq'::regclass) NOT NULL,
2207 priority text NOT NULL,
2208 level integer NOT NULL,
2209 created timestamp with time zone DEFAULT now() NOT NULL,
2210 modified timestamp with time zone DEFAULT now() NOT NULL
2214 ALTER TABLE public.priority OWNER TO dak;
2217 -- Name: section_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2220 CREATE SEQUENCE section_id_seq
2228 ALTER TABLE public.section_id_seq OWNER TO dak;
2231 -- Name: section; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2234 CREATE TABLE section (
2235 id integer DEFAULT nextval('section_id_seq'::regclass) NOT NULL,
2236 section text NOT NULL,
2237 created timestamp with time zone DEFAULT now() NOT NULL,
2238 modified timestamp with time zone DEFAULT now() NOT NULL
2242 ALTER TABLE public.section OWNER TO dak;
2245 -- Name: source_acl; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2248 CREATE TABLE source_acl (
2249 id integer NOT NULL,
2250 access_level text NOT NULL,
2251 created timestamp with time zone DEFAULT now() NOT NULL,
2252 modified timestamp with time zone DEFAULT now() NOT NULL
2256 ALTER TABLE public.source_acl OWNER TO dak;
2259 -- Name: source_acl_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2262 CREATE SEQUENCE source_acl_id_seq
2270 ALTER TABLE public.source_acl_id_seq OWNER TO dak;
2273 -- Name: source_acl_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2276 ALTER SEQUENCE source_acl_id_seq OWNED BY source_acl.id;
2280 -- Name: source_metadata; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2283 CREATE TABLE source_metadata (
2284 src_id integer NOT NULL,
2285 key_id integer NOT NULL,
2290 ALTER TABLE public.source_metadata OWNER TO dak;
2293 -- Name: src_contents; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2296 CREATE TABLE src_contents (
2298 source_id integer NOT NULL,
2299 created timestamp with time zone DEFAULT now() NOT NULL,
2300 modified timestamp with time zone DEFAULT now() NOT NULL
2304 ALTER TABLE public.src_contents OWNER TO dak;
2307 -- Name: src_format; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2310 CREATE TABLE src_format (
2311 id integer NOT NULL,
2312 format_name text NOT NULL,
2313 created timestamp with time zone DEFAULT now() NOT NULL,
2314 modified timestamp with time zone DEFAULT now() NOT NULL
2318 ALTER TABLE public.src_format OWNER TO dak;
2321 -- Name: src_format_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2324 CREATE SEQUENCE src_format_id_seq
2332 ALTER TABLE public.src_format_id_seq OWNER TO dak;
2335 -- Name: src_format_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2338 ALTER SEQUENCE src_format_id_seq OWNED BY src_format.id;
2342 -- Name: src_uploaders; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2345 CREATE TABLE src_uploaders (
2346 id integer NOT NULL,
2347 source integer NOT NULL,
2348 maintainer integer NOT NULL,
2349 created timestamp with time zone DEFAULT now() NOT NULL,
2350 modified timestamp with time zone DEFAULT now() NOT NULL
2354 ALTER TABLE public.src_uploaders OWNER TO dak;
2357 -- Name: src_uploaders_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2360 CREATE SEQUENCE src_uploaders_id_seq
2368 ALTER TABLE public.src_uploaders_id_seq OWNER TO dak;
2371 -- Name: src_uploaders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2374 ALTER SEQUENCE src_uploaders_id_seq OWNED BY src_uploaders.id;
2378 -- Name: suite_architectures; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2381 CREATE TABLE suite_architectures (
2382 suite integer NOT NULL,
2383 architecture integer NOT NULL,
2384 created timestamp with time zone DEFAULT now() NOT NULL,
2385 modified timestamp with time zone DEFAULT now() NOT NULL
2389 ALTER TABLE public.suite_architectures OWNER TO dak;
2392 -- Name: suite_arch_by_name; Type: VIEW; Schema: public; Owner: dak
2395 CREATE VIEW suite_arch_by_name AS
2396 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]));
2399 ALTER TABLE public.suite_arch_by_name OWNER TO dak;
2402 -- Name: suite_build_queue_copy; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2405 CREATE TABLE suite_build_queue_copy (
2406 suite integer NOT NULL,
2407 build_queue_id integer NOT NULL,
2408 created timestamp with time zone DEFAULT now() NOT NULL,
2409 modified timestamp with time zone DEFAULT now() NOT NULL
2413 ALTER TABLE public.suite_build_queue_copy OWNER TO dak;
2416 -- Name: suite_src_formats; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2419 CREATE TABLE suite_src_formats (
2420 suite integer NOT NULL,
2421 src_format integer NOT NULL,
2422 created timestamp with time zone DEFAULT now() NOT NULL,
2423 modified timestamp with time zone DEFAULT now() NOT NULL
2427 ALTER TABLE public.suite_src_formats OWNER TO dak;
2430 -- Name: uid_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2433 CREATE SEQUENCE uid_id_seq
2441 ALTER TABLE public.uid_id_seq OWNER TO dak;
2444 -- Name: uid; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2448 id integer DEFAULT nextval('uid_id_seq'::regclass) NOT NULL,
2451 created timestamp with time zone DEFAULT now() NOT NULL,
2452 modified timestamp with time zone DEFAULT now() NOT NULL
2456 ALTER TABLE public.uid OWNER TO dak;
2459 -- Name: upload_blocks; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2462 CREATE TABLE upload_blocks (
2463 id integer NOT NULL,
2464 source text NOT NULL,
2466 fingerprint_id integer,
2468 reason text NOT NULL,
2469 created timestamp with time zone DEFAULT now() NOT NULL,
2470 modified timestamp with time zone DEFAULT now() NOT NULL,
2471 CONSTRAINT upload_blocks_check CHECK (((fingerprint_id IS NOT NULL) OR (uid_id IS NOT NULL)))
2475 ALTER TABLE public.upload_blocks OWNER TO dak;
2478 -- Name: upload_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: dak
2481 CREATE SEQUENCE upload_blocks_id_seq
2489 ALTER TABLE public.upload_blocks_id_seq OWNER TO dak;
2492 -- Name: upload_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dak
2495 ALTER SEQUENCE upload_blocks_id_seq OWNED BY upload_blocks.id;
2499 -- Name: version_check; Type: TABLE; Schema: public; Owner: dak; Tablespace:
2502 CREATE TABLE version_check (
2503 suite integer NOT NULL,
2504 "check" text NOT NULL,
2505 reference integer NOT NULL,
2506 CONSTRAINT version_check_check_check CHECK (("check" = ANY (ARRAY['Enhances'::text, 'MustBeNewerThan'::text, 'MustBeOlderThan'::text])))
2510 ALTER TABLE public.version_check OWNER TO dak;
2513 -- Name: version_checks; Type: VIEW; Schema: public; Owner: dak
2516 CREATE VIEW version_checks AS
2517 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;
2520 ALTER TABLE public.version_checks OWNER TO dak;
2523 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2526 ALTER TABLE binary_acl ALTER COLUMN id SET DEFAULT nextval('binary_acl_id_seq'::regclass);
2530 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2533 ALTER TABLE binary_acl_map ALTER COLUMN id SET DEFAULT nextval('binary_acl_map_id_seq'::regclass);
2537 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2540 ALTER TABLE build_queue ALTER COLUMN id SET DEFAULT nextval('build_queue_id_seq'::regclass);
2544 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2547 ALTER TABLE build_queue_files ALTER COLUMN id SET DEFAULT nextval('build_queue_files_id_seq'::regclass);
2551 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2554 ALTER TABLE changelogs_text ALTER COLUMN id SET DEFAULT nextval('changelogs_text_id_seq'::regclass);
2558 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2561 ALTER TABLE changes ALTER COLUMN id SET DEFAULT nextval('changes_id_seq'::regclass);
2565 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2568 ALTER TABLE changes_pending_binaries ALTER COLUMN id SET DEFAULT nextval('changes_pending_binaries_id_seq'::regclass);
2572 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2575 ALTER TABLE changes_pending_files ALTER COLUMN id SET DEFAULT nextval('changes_pending_files_id_seq'::regclass);
2579 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2582 ALTER TABLE changes_pending_source ALTER COLUMN id SET DEFAULT nextval('changes_pending_source_id_seq'::regclass);
2586 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2589 ALTER TABLE config ALTER COLUMN id SET DEFAULT nextval('config_id_seq'::regclass);
2593 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2596 ALTER TABLE keyring_acl_map ALTER COLUMN id SET DEFAULT nextval('keyring_acl_map_id_seq'::regclass);
2600 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2603 ALTER TABLE keyrings ALTER COLUMN id SET DEFAULT nextval('keyrings_id_seq'::regclass);
2607 -- Name: key_id; Type: DEFAULT; Schema: public; Owner: dak
2610 ALTER TABLE metadata_keys ALTER COLUMN key_id SET DEFAULT nextval('metadata_keys_key_id_seq'::regclass);
2614 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2617 ALTER TABLE new_comments ALTER COLUMN id SET DEFAULT nextval('new_comments_id_seq'::regclass);
2621 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2624 ALTER TABLE policy_queue ALTER COLUMN id SET DEFAULT nextval('policy_queue_id_seq'::regclass);
2628 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2631 ALTER TABLE source_acl ALTER COLUMN id SET DEFAULT nextval('source_acl_id_seq'::regclass);
2635 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2638 ALTER TABLE src_format ALTER COLUMN id SET DEFAULT nextval('src_format_id_seq'::regclass);
2642 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2645 ALTER TABLE src_uploaders ALTER COLUMN id SET DEFAULT nextval('src_uploaders_id_seq'::regclass);
2649 -- Name: id; Type: DEFAULT; Schema: public; Owner: dak
2652 ALTER TABLE upload_blocks ALTER COLUMN id SET DEFAULT nextval('upload_blocks_id_seq'::regclass);
2656 -- Name: architecture_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2659 ALTER TABLE ONLY architecture
2660 ADD CONSTRAINT architecture_pkey PRIMARY KEY (id);
2664 -- Name: archive_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2667 ALTER TABLE ONLY archive
2668 ADD CONSTRAINT archive_pkey PRIMARY KEY (id);
2672 -- Name: bin_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2675 ALTER TABLE ONLY bin_associations
2676 ADD CONSTRAINT bin_associations_pkey PRIMARY KEY (id);
2680 -- Name: bin_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2683 ALTER TABLE ONLY bin_contents
2684 ADD CONSTRAINT bin_contents_pkey PRIMARY KEY (file, binary_id);
2688 -- Name: binaries_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2691 ALTER TABLE ONLY binaries_metadata
2692 ADD CONSTRAINT binaries_metadata_pkey PRIMARY KEY (bin_id, key_id);
2696 -- Name: binaries_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2699 ALTER TABLE ONLY binaries
2700 ADD CONSTRAINT binaries_pkey PRIMARY KEY (id);
2704 -- Name: binary_acl_access_level_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2707 ALTER TABLE ONLY binary_acl
2708 ADD CONSTRAINT binary_acl_access_level_key UNIQUE (access_level);
2712 -- Name: binary_acl_map_fingerprint_id_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2715 ALTER TABLE ONLY binary_acl_map
2716 ADD CONSTRAINT binary_acl_map_fingerprint_id_key UNIQUE (fingerprint_id, architecture_id);
2720 -- Name: binary_acl_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2723 ALTER TABLE ONLY binary_acl_map
2724 ADD CONSTRAINT binary_acl_map_pkey PRIMARY KEY (id);
2728 -- Name: binary_acl_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2731 ALTER TABLE ONLY binary_acl
2732 ADD CONSTRAINT binary_acl_pkey PRIMARY KEY (id);
2736 -- Name: build_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2739 ALTER TABLE ONLY build_queue
2740 ADD CONSTRAINT build_queue_pkey PRIMARY KEY (id);
2744 -- Name: build_queue_policy_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2747 ALTER TABLE ONLY build_queue_policy_files
2748 ADD CONSTRAINT build_queue_policy_files_pkey PRIMARY KEY (build_queue_id, file_id);
2752 -- Name: build_queue_queue_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2755 ALTER TABLE ONLY build_queue
2756 ADD CONSTRAINT build_queue_queue_name_key UNIQUE (queue_name);
2760 -- Name: changelogs_text_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2763 ALTER TABLE ONLY changelogs_text
2764 ADD CONSTRAINT changelogs_text_pkey PRIMARY KEY (id);
2768 -- Name: changes_pending_binaries_package_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2771 ALTER TABLE ONLY changes_pending_binaries
2772 ADD CONSTRAINT changes_pending_binaries_package_key UNIQUE (package, version, architecture_id);
2776 -- Name: changes_pending_binaries_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2779 ALTER TABLE ONLY changes_pending_binaries
2780 ADD CONSTRAINT changes_pending_binaries_pkey PRIMARY KEY (id);
2784 -- Name: changes_pending_files_filename_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2787 ALTER TABLE ONLY changes_pending_files
2788 ADD CONSTRAINT changes_pending_files_filename_key UNIQUE (filename);
2792 -- Name: changes_pending_files_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2795 ALTER TABLE ONLY changes_pending_files_map
2796 ADD CONSTRAINT changes_pending_files_map_pkey PRIMARY KEY (file_id, change_id);
2800 -- Name: changes_pending_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2803 ALTER TABLE ONLY changes_pending_files
2804 ADD CONSTRAINT changes_pending_files_pkey PRIMARY KEY (id);
2808 -- Name: changes_pending_source_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2811 ALTER TABLE ONLY changes_pending_source_files
2812 ADD CONSTRAINT changes_pending_source_files_pkey PRIMARY KEY (pending_source_id, pending_file_id);
2816 -- Name: changes_pending_source_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2819 ALTER TABLE ONLY changes_pending_source
2820 ADD CONSTRAINT changes_pending_source_pkey PRIMARY KEY (id);
2824 -- Name: changes_pool_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2827 ALTER TABLE ONLY changes_pool_files
2828 ADD CONSTRAINT changes_pool_files_pkey PRIMARY KEY (changeid, fileid);
2832 -- Name: component_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2835 ALTER TABLE ONLY component
2836 ADD CONSTRAINT component_pkey PRIMARY KEY (id);
2840 -- Name: config_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2843 ALTER TABLE ONLY config
2844 ADD CONSTRAINT config_name_key UNIQUE (name);
2848 -- Name: config_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2851 ALTER TABLE ONLY config
2852 ADD CONSTRAINT config_pkey PRIMARY KEY (id);
2856 -- Name: dsc_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2859 ALTER TABLE ONLY dsc_files
2860 ADD CONSTRAINT dsc_files_pkey PRIMARY KEY (id);
2864 -- Name: external_overrides_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2867 ALTER TABLE ONLY external_overrides
2868 ADD CONSTRAINT external_overrides_pkey PRIMARY KEY (suite, component, package, key);
2872 -- Name: extra_src_references_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2875 ALTER TABLE ONLY extra_src_references
2876 ADD CONSTRAINT extra_src_references_pkey PRIMARY KEY (bin_id, src_id);
2880 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2883 ALTER TABLE ONLY files
2884 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
2888 -- Name: fingerprint_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2891 ALTER TABLE ONLY fingerprint
2892 ADD CONSTRAINT fingerprint_pkey PRIMARY KEY (id);
2896 -- Name: keyring_acl_map_keyring_id_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2899 ALTER TABLE ONLY keyring_acl_map
2900 ADD CONSTRAINT keyring_acl_map_keyring_id_key UNIQUE (keyring_id, architecture_id);
2904 -- Name: keyring_acl_map_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2907 ALTER TABLE ONLY keyring_acl_map
2908 ADD CONSTRAINT keyring_acl_map_pkey PRIMARY KEY (id);
2912 -- Name: keyrings_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2915 ALTER TABLE ONLY keyrings
2916 ADD CONSTRAINT keyrings_name_key UNIQUE (name);
2920 -- Name: keyrings_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2923 ALTER TABLE ONLY keyrings
2924 ADD CONSTRAINT keyrings_pkey PRIMARY KEY (id);
2928 -- Name: known_changes_changesname_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2931 ALTER TABLE ONLY changes
2932 ADD CONSTRAINT known_changes_changesname_key UNIQUE (changesname);
2936 -- Name: known_changes_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2939 ALTER TABLE ONLY changes
2940 ADD CONSTRAINT known_changes_pkey PRIMARY KEY (id);
2944 -- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2947 ALTER TABLE ONLY location
2948 ADD CONSTRAINT location_pkey PRIMARY KEY (id);
2952 -- Name: maintainer_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2955 ALTER TABLE ONLY maintainer
2956 ADD CONSTRAINT maintainer_pkey PRIMARY KEY (id);
2960 -- Name: metadata_keys_key_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2963 ALTER TABLE ONLY metadata_keys
2964 ADD CONSTRAINT metadata_keys_key_key UNIQUE (key);
2968 -- Name: metadata_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2971 ALTER TABLE ONLY metadata_keys
2972 ADD CONSTRAINT metadata_keys_pkey PRIMARY KEY (key_id);
2976 -- Name: new_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2979 ALTER TABLE ONLY new_comments
2980 ADD CONSTRAINT new_comments_pkey PRIMARY KEY (id);
2984 -- Name: override_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2987 ALTER TABLE ONLY override
2988 ADD CONSTRAINT override_pkey PRIMARY KEY (suite, component, package, type);
2992 -- Name: override_type_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
2995 ALTER TABLE ONLY override_type
2996 ADD CONSTRAINT override_type_pkey PRIMARY KEY (id);
3000 -- Name: policy_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3003 ALTER TABLE ONLY policy_queue
3004 ADD CONSTRAINT policy_queue_pkey PRIMARY KEY (id);
3008 -- Name: policy_queue_queue_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3011 ALTER TABLE ONLY policy_queue
3012 ADD CONSTRAINT policy_queue_queue_name_key UNIQUE (queue_name);
3016 -- Name: priority_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3019 ALTER TABLE ONLY priority
3020 ADD CONSTRAINT priority_pkey PRIMARY KEY (id);
3024 -- Name: queue_files_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3027 ALTER TABLE ONLY build_queue_files
3028 ADD CONSTRAINT queue_files_pkey PRIMARY KEY (id);
3032 -- Name: section_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3035 ALTER TABLE ONLY section
3036 ADD CONSTRAINT section_pkey PRIMARY KEY (id);
3040 -- Name: source_acl_access_level_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3043 ALTER TABLE ONLY source_acl
3044 ADD CONSTRAINT source_acl_access_level_key UNIQUE (access_level);
3048 -- Name: source_acl_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3051 ALTER TABLE ONLY source_acl
3052 ADD CONSTRAINT source_acl_pkey PRIMARY KEY (id);
3056 -- Name: source_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3059 ALTER TABLE ONLY source_metadata
3060 ADD CONSTRAINT source_metadata_pkey PRIMARY KEY (src_id, key_id);
3064 -- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3067 ALTER TABLE ONLY source
3068 ADD CONSTRAINT source_pkey PRIMARY KEY (id);
3072 -- Name: src_associations_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3075 ALTER TABLE ONLY src_associations
3076 ADD CONSTRAINT src_associations_pkey PRIMARY KEY (id);
3080 -- Name: src_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3083 ALTER TABLE ONLY src_contents
3084 ADD CONSTRAINT src_contents_pkey PRIMARY KEY (file, source_id);
3088 -- Name: src_format_format_name_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3091 ALTER TABLE ONLY src_format
3092 ADD CONSTRAINT src_format_format_name_key UNIQUE (format_name);
3096 -- Name: src_format_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3099 ALTER TABLE ONLY src_format
3100 ADD CONSTRAINT src_format_pkey PRIMARY KEY (id);
3104 -- Name: src_uploaders_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3107 ALTER TABLE ONLY src_uploaders
3108 ADD CONSTRAINT src_uploaders_pkey PRIMARY KEY (id);
3112 -- Name: src_uploaders_source_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3115 ALTER TABLE ONLY src_uploaders
3116 ADD CONSTRAINT src_uploaders_source_key UNIQUE (source, maintainer);
3120 -- Name: suite_architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3123 ALTER TABLE ONLY suite_architectures
3124 ADD CONSTRAINT suite_architectures_pkey PRIMARY KEY (suite, architecture);
3128 -- Name: suite_name_unique; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3131 ALTER TABLE ONLY suite
3132 ADD CONSTRAINT suite_name_unique UNIQUE (suite_name);
3136 -- Name: suite_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3139 ALTER TABLE ONLY suite
3140 ADD CONSTRAINT suite_pkey PRIMARY KEY (id);
3144 -- Name: suite_queue_copy_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3147 ALTER TABLE ONLY suite_build_queue_copy
3148 ADD CONSTRAINT suite_queue_copy_pkey PRIMARY KEY (suite, build_queue_id);
3152 -- Name: suite_src_formats_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3155 ALTER TABLE ONLY suite_src_formats
3156 ADD CONSTRAINT suite_src_formats_pkey PRIMARY KEY (suite, src_format);
3160 -- Name: suite_src_formats_suite_key; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3163 ALTER TABLE ONLY suite_src_formats
3164 ADD CONSTRAINT suite_src_formats_suite_key UNIQUE (suite, src_format);
3168 -- Name: uid_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3171 ALTER TABLE ONLY uid
3172 ADD CONSTRAINT uid_pkey PRIMARY KEY (id);
3176 -- Name: upload_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3179 ALTER TABLE ONLY upload_blocks
3180 ADD CONSTRAINT upload_blocks_pkey PRIMARY KEY (id);
3184 -- Name: version_check_pkey; Type: CONSTRAINT; Schema: public; Owner: dak; Tablespace:
3187 ALTER TABLE ONLY version_check
3188 ADD CONSTRAINT version_check_pkey PRIMARY KEY (suite, "check", reference);
3192 -- Name: architecture_arch_string_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3195 CREATE UNIQUE INDEX architecture_arch_string_key ON architecture USING btree (arch_string);
3199 -- Name: archive_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3202 CREATE UNIQUE INDEX archive_name_key ON archive USING btree (name);
3206 -- Name: bin_associations_bin; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3209 CREATE INDEX bin_associations_bin ON bin_associations USING btree (bin);
3213 -- Name: bin_associations_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3216 CREATE UNIQUE INDEX bin_associations_suite_key ON bin_associations USING btree (suite, bin);
3220 -- Name: binaries_architecture_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3223 CREATE INDEX binaries_architecture_idx ON binaries USING btree (architecture);
3227 -- Name: binaries_by_package; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3230 CREATE INDEX binaries_by_package ON binaries USING btree (id, package);
3234 -- Name: binaries_file_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3237 CREATE UNIQUE INDEX binaries_file_key ON binaries USING btree (file);
3241 -- Name: binaries_files; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3244 CREATE INDEX binaries_files ON binaries USING btree (file);
3248 -- Name: binaries_fingerprint; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3251 CREATE INDEX binaries_fingerprint ON binaries USING btree (sig_fpr);
3255 -- Name: binaries_id; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3258 CREATE UNIQUE INDEX binaries_id ON binaries USING btree (id);
3262 -- Name: binaries_maintainer; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3265 CREATE INDEX binaries_maintainer ON binaries USING btree (maintainer);
3269 -- Name: binaries_metadata_depends; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3272 CREATE INDEX binaries_metadata_depends ON binaries_metadata USING btree (bin_id) WHERE (key_id = 44);
3276 -- Name: binaries_metadata_provides; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3279 CREATE INDEX binaries_metadata_provides ON binaries_metadata USING btree (bin_id) WHERE (key_id = 51);
3283 -- Name: binaries_package_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3286 CREATE UNIQUE INDEX binaries_package_key ON binaries USING btree (package, version, architecture);
3290 -- Name: changesapproved_for; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3293 CREATE INDEX changesapproved_for ON changes USING btree (approved_for);
3297 -- Name: changesdistribution_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3300 CREATE INDEX changesdistribution_ind ON changes USING btree (distribution);
3304 -- Name: changesin_queue; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3307 CREATE INDEX changesin_queue ON changes USING btree (in_queue);
3311 -- Name: changesin_queue_approved_for; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3314 CREATE INDEX changesin_queue_approved_for ON changes USING btree (in_queue, approved_for);
3318 -- Name: changesname_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3321 CREATE INDEX changesname_ind ON changes USING btree (changesname);
3325 -- Name: changessource_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3328 CREATE INDEX changessource_ind ON changes USING btree (source);
3332 -- Name: changestimestamp_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3335 CREATE INDEX changestimestamp_ind ON changes USING btree (seen);
3339 -- Name: changesurgency_ind; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3342 CREATE INDEX changesurgency_ind ON changes USING btree (urgency);
3346 -- Name: component_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3349 CREATE UNIQUE INDEX component_name_key ON component USING btree (name);
3353 -- Name: dsc_files_file; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3356 CREATE INDEX dsc_files_file ON dsc_files USING btree (file);
3360 -- Name: dsc_files_source_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3363 CREATE UNIQUE INDEX dsc_files_source_key ON dsc_files USING btree (source, file);
3367 -- Name: files_filename_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3370 CREATE UNIQUE INDEX files_filename_key ON files USING btree (filename, location);
3374 -- Name: files_last_used; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3377 CREATE INDEX files_last_used ON files USING btree (last_used);
3381 -- Name: fingerprint_fingerprint_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3384 CREATE UNIQUE INDEX fingerprint_fingerprint_key ON fingerprint USING btree (fingerprint);
3388 -- Name: ind_bin_contents_binary; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3391 CREATE INDEX ind_bin_contents_binary ON bin_contents USING btree (binary_id);
3395 -- Name: jjt; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3398 CREATE INDEX jjt ON files USING btree (id);
3402 -- Name: jjt2; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3405 CREATE INDEX jjt2 ON files USING btree (location);
3409 -- Name: jjt3; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3412 CREATE INDEX jjt3 ON files USING btree (id, location);
3416 -- Name: jjt4; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3419 CREATE INDEX jjt4 ON binaries USING btree (source);
3423 -- Name: jjt5; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3426 CREATE INDEX jjt5 ON binaries USING btree (id, source);
3430 -- Name: jjt_override_type_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3433 CREATE INDEX jjt_override_type_idx ON override USING btree (type);
3437 -- Name: maintainer_name_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3440 CREATE UNIQUE INDEX maintainer_name_key ON maintainer USING btree (name);
3444 -- Name: override_by_package; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3447 CREATE INDEX override_by_package ON override USING btree (package);
3451 -- Name: override_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3454 CREATE UNIQUE INDEX override_suite_key ON override USING btree (suite, component, package, type);
3458 -- Name: override_type_type_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3461 CREATE UNIQUE INDEX override_type_type_key ON override_type USING btree (type);
3465 -- Name: priority_level_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3468 CREATE UNIQUE INDEX priority_level_key ON priority USING btree (level);
3472 -- Name: priority_priority_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3475 CREATE UNIQUE INDEX priority_priority_key ON priority USING btree (priority);
3479 -- Name: section_section_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3482 CREATE UNIQUE INDEX section_section_key ON section USING btree (section);
3486 -- Name: source_file_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3489 CREATE UNIQUE INDEX source_file_key ON source USING btree (file);
3493 -- Name: source_fingerprint; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3496 CREATE INDEX source_fingerprint ON source USING btree (sig_fpr);
3500 -- Name: source_maintainer; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3503 CREATE INDEX source_maintainer ON source USING btree (maintainer);
3507 -- Name: source_source_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3510 CREATE UNIQUE INDEX source_source_key ON source USING btree (source, version);
3514 -- Name: src_associations_source; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3517 CREATE INDEX src_associations_source ON src_associations USING btree (source);
3521 -- Name: src_associations_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3524 CREATE UNIQUE INDEX src_associations_suite_key ON src_associations USING btree (suite, source);
3528 -- Name: src_contents_source_id_idx; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3531 CREATE INDEX src_contents_source_id_idx ON src_contents USING btree (source_id);
3535 -- Name: suite_architectures_suite_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3538 CREATE UNIQUE INDEX suite_architectures_suite_key ON suite_architectures USING btree (suite, architecture);
3542 -- Name: suite_hash; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3545 CREATE INDEX suite_hash ON suite USING hash (suite_name);
3549 -- Name: uid_uid_key; Type: INDEX; Schema: public; Owner: dak; Tablespace:
3552 CREATE UNIQUE INDEX uid_uid_key ON uid USING btree (uid);
3556 -- Name: modified_architecture; Type: TRIGGER; Schema: public; Owner: dak
3559 CREATE TRIGGER modified_architecture BEFORE UPDATE ON architecture FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3563 -- Name: modified_archive; Type: TRIGGER; Schema: public; Owner: dak
3566 CREATE TRIGGER modified_archive BEFORE UPDATE ON archive FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3570 -- Name: modified_bin_associations; Type: TRIGGER; Schema: public; Owner: dak
3573 CREATE TRIGGER modified_bin_associations BEFORE UPDATE ON bin_associations FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3577 -- Name: modified_bin_contents; Type: TRIGGER; Schema: public; Owner: dak
3580 CREATE TRIGGER modified_bin_contents BEFORE UPDATE ON bin_contents FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3584 -- Name: modified_binaries; Type: TRIGGER; Schema: public; Owner: dak
3587 CREATE TRIGGER modified_binaries BEFORE UPDATE ON binaries FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3591 -- Name: modified_binary_acl; Type: TRIGGER; Schema: public; Owner: dak
3594 CREATE TRIGGER modified_binary_acl BEFORE UPDATE ON binary_acl FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3598 -- Name: modified_binary_acl_map; Type: TRIGGER; Schema: public; Owner: dak
3601 CREATE TRIGGER modified_binary_acl_map BEFORE UPDATE ON binary_acl_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3605 -- Name: modified_build_queue; Type: TRIGGER; Schema: public; Owner: dak
3608 CREATE TRIGGER modified_build_queue BEFORE UPDATE ON build_queue FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3612 -- Name: modified_build_queue_files; Type: TRIGGER; Schema: public; Owner: dak
3615 CREATE TRIGGER modified_build_queue_files BEFORE UPDATE ON build_queue_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3619 -- Name: modified_changes; Type: TRIGGER; Schema: public; Owner: dak
3622 CREATE TRIGGER modified_changes BEFORE UPDATE ON changes FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3626 -- Name: modified_changes_pending_binaries; Type: TRIGGER; Schema: public; Owner: dak
3629 CREATE TRIGGER modified_changes_pending_binaries BEFORE UPDATE ON changes_pending_binaries FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3633 -- Name: modified_changes_pending_files; Type: TRIGGER; Schema: public; Owner: dak
3636 CREATE TRIGGER modified_changes_pending_files BEFORE UPDATE ON changes_pending_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3640 -- Name: modified_changes_pending_files_map; Type: TRIGGER; Schema: public; Owner: dak
3643 CREATE TRIGGER modified_changes_pending_files_map BEFORE UPDATE ON changes_pending_files_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3647 -- Name: modified_changes_pending_source; Type: TRIGGER; Schema: public; Owner: dak
3650 CREATE TRIGGER modified_changes_pending_source BEFORE UPDATE ON changes_pending_source FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3654 -- Name: modified_changes_pending_source_files; Type: TRIGGER; Schema: public; Owner: dak
3657 CREATE TRIGGER modified_changes_pending_source_files BEFORE UPDATE ON changes_pending_source_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3661 -- Name: modified_changes_pool_files; Type: TRIGGER; Schema: public; Owner: dak
3664 CREATE TRIGGER modified_changes_pool_files BEFORE UPDATE ON changes_pool_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3668 -- Name: modified_component; Type: TRIGGER; Schema: public; Owner: dak
3671 CREATE TRIGGER modified_component BEFORE UPDATE ON component FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3675 -- Name: modified_config; Type: TRIGGER; Schema: public; Owner: dak
3678 CREATE TRIGGER modified_config BEFORE UPDATE ON config FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3682 -- Name: modified_dsc_files; Type: TRIGGER; Schema: public; Owner: dak
3685 CREATE TRIGGER modified_dsc_files BEFORE UPDATE ON dsc_files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3689 -- Name: modified_files; Type: TRIGGER; Schema: public; Owner: dak
3692 CREATE TRIGGER modified_files BEFORE UPDATE ON files FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3696 -- Name: modified_fingerprint; Type: TRIGGER; Schema: public; Owner: dak
3699 CREATE TRIGGER modified_fingerprint BEFORE UPDATE ON fingerprint FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3703 -- Name: modified_keyring_acl_map; Type: TRIGGER; Schema: public; Owner: dak
3706 CREATE TRIGGER modified_keyring_acl_map BEFORE UPDATE ON keyring_acl_map FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3710 -- Name: modified_keyrings; Type: TRIGGER; Schema: public; Owner: dak
3713 CREATE TRIGGER modified_keyrings BEFORE UPDATE ON keyrings FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3717 -- Name: modified_location; Type: TRIGGER; Schema: public; Owner: dak
3720 CREATE TRIGGER modified_location BEFORE UPDATE ON location FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3724 -- Name: modified_maintainer; Type: TRIGGER; Schema: public; Owner: dak
3727 CREATE TRIGGER modified_maintainer BEFORE UPDATE ON maintainer FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3731 -- Name: modified_new_comments; Type: TRIGGER; Schema: public; Owner: dak
3734 CREATE TRIGGER modified_new_comments BEFORE UPDATE ON new_comments FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3738 -- Name: modified_override; Type: TRIGGER; Schema: public; Owner: dak
3741 CREATE TRIGGER modified_override BEFORE UPDATE ON override FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3745 -- Name: modified_override_type; Type: TRIGGER; Schema: public; Owner: dak
3748 CREATE TRIGGER modified_override_type BEFORE UPDATE ON override_type FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3752 -- Name: modified_policy_queue; Type: TRIGGER; Schema: public; Owner: dak
3755 CREATE TRIGGER modified_policy_queue BEFORE UPDATE ON policy_queue FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3759 -- Name: modified_priority; Type: TRIGGER; Schema: public; Owner: dak
3762 CREATE TRIGGER modified_priority BEFORE UPDATE ON priority FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3766 -- Name: modified_section; Type: TRIGGER; Schema: public; Owner: dak
3769 CREATE TRIGGER modified_section BEFORE UPDATE ON section FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3773 -- Name: modified_source; Type: TRIGGER; Schema: public; Owner: dak
3776 CREATE TRIGGER modified_source BEFORE UPDATE ON source FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3780 -- Name: modified_source_acl; Type: TRIGGER; Schema: public; Owner: dak
3783 CREATE TRIGGER modified_source_acl BEFORE UPDATE ON source_acl FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3787 -- Name: modified_src_associations; Type: TRIGGER; Schema: public; Owner: dak
3790 CREATE TRIGGER modified_src_associations BEFORE UPDATE ON src_associations FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3794 -- Name: modified_src_contents; Type: TRIGGER; Schema: public; Owner: dak
3797 CREATE TRIGGER modified_src_contents BEFORE UPDATE ON src_contents FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3801 -- Name: modified_src_format; Type: TRIGGER; Schema: public; Owner: dak
3804 CREATE TRIGGER modified_src_format BEFORE UPDATE ON src_format FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3808 -- Name: modified_src_uploaders; Type: TRIGGER; Schema: public; Owner: dak
3811 CREATE TRIGGER modified_src_uploaders BEFORE UPDATE ON src_uploaders FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3815 -- Name: modified_suite; Type: TRIGGER; Schema: public; Owner: dak
3818 CREATE TRIGGER modified_suite BEFORE UPDATE ON suite FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3822 -- Name: modified_suite_architectures; Type: TRIGGER; Schema: public; Owner: dak
3825 CREATE TRIGGER modified_suite_architectures BEFORE UPDATE ON suite_architectures FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3829 -- Name: modified_suite_build_queue_copy; Type: TRIGGER; Schema: public; Owner: dak
3832 CREATE TRIGGER modified_suite_build_queue_copy BEFORE UPDATE ON suite_build_queue_copy FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3836 -- Name: modified_suite_src_formats; Type: TRIGGER; Schema: public; Owner: dak
3839 CREATE TRIGGER modified_suite_src_formats BEFORE UPDATE ON suite_src_formats FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3843 -- Name: modified_uid; Type: TRIGGER; Schema: public; Owner: dak
3846 CREATE TRIGGER modified_uid BEFORE UPDATE ON uid FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3850 -- Name: modified_upload_blocks; Type: TRIGGER; Schema: public; Owner: dak
3853 CREATE TRIGGER modified_upload_blocks BEFORE UPDATE ON upload_blocks FOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified();
3857 -- Name: trigger_bin_associations_audit; Type: TRIGGER; Schema: public; Owner: dak
3860 CREATE TRIGGER trigger_bin_associations_audit AFTER INSERT OR DELETE ON bin_associations FOR EACH ROW EXECUTE PROCEDURE trigger_binsrc_assoc_update();
3864 -- Name: trigger_override_audit; Type: TRIGGER; Schema: public; Owner: dak
3867 CREATE TRIGGER trigger_override_audit AFTER UPDATE ON override FOR EACH ROW EXECUTE PROCEDURE trigger_override_update();
3871 -- Name: trigger_src_associations_audit; Type: TRIGGER; Schema: public; Owner: dak
3874 CREATE TRIGGER trigger_src_associations_audit AFTER INSERT OR DELETE ON src_associations FOR EACH ROW EXECUTE PROCEDURE trigger_binsrc_assoc_update();
3878 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: dak
3881 ALTER TABLE ONLY fingerprint
3882 ADD CONSTRAINT "$1" FOREIGN KEY (keyring) REFERENCES keyrings(id);
3886 -- Name: bin_associations_bin; Type: FK CONSTRAINT; Schema: public; Owner: dak
3889 ALTER TABLE ONLY bin_associations
3890 ADD CONSTRAINT bin_associations_bin FOREIGN KEY (bin) REFERENCES binaries(id) MATCH FULL;
3894 -- Name: bin_associations_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
3897 ALTER TABLE ONLY bin_associations
3898 ADD CONSTRAINT bin_associations_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
3902 -- Name: bin_contents_bin_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3905 ALTER TABLE ONLY bin_contents
3906 ADD CONSTRAINT bin_contents_bin_fkey FOREIGN KEY (binary_id) REFERENCES binaries(id) ON DELETE CASCADE;
3910 -- Name: binaries_architecture; Type: FK CONSTRAINT; Schema: public; Owner: dak
3913 ALTER TABLE ONLY binaries
3914 ADD CONSTRAINT binaries_architecture FOREIGN KEY (architecture) REFERENCES architecture(id) MATCH FULL;
3918 -- Name: binaries_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
3921 ALTER TABLE ONLY binaries
3922 ADD CONSTRAINT binaries_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
3926 -- Name: binaries_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
3929 ALTER TABLE ONLY binaries
3930 ADD CONSTRAINT binaries_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
3934 -- Name: binaries_metadata_bin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3937 ALTER TABLE ONLY binaries_metadata
3938 ADD CONSTRAINT binaries_metadata_bin_id_fkey FOREIGN KEY (bin_id) REFERENCES binaries(id) ON DELETE CASCADE;
3942 -- Name: binaries_metadata_key_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3945 ALTER TABLE ONLY binaries_metadata
3946 ADD CONSTRAINT binaries_metadata_key_id_fkey FOREIGN KEY (key_id) REFERENCES metadata_keys(key_id);
3950 -- Name: binaries_sig_fpr; Type: FK CONSTRAINT; Schema: public; Owner: dak
3953 ALTER TABLE ONLY binaries
3954 ADD CONSTRAINT binaries_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
3958 -- Name: binaries_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
3961 ALTER TABLE ONLY binaries
3962 ADD CONSTRAINT binaries_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
3966 -- Name: binary_acl_map_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3969 ALTER TABLE ONLY binary_acl_map
3970 ADD CONSTRAINT binary_acl_map_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
3974 -- Name: binary_acl_map_fingerprint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3977 ALTER TABLE ONLY binary_acl_map
3978 ADD CONSTRAINT binary_acl_map_fingerprint_id_fkey FOREIGN KEY (fingerprint_id) REFERENCES fingerprint(id);
3982 -- Name: build_queue_files_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3985 ALTER TABLE ONLY build_queue_files
3986 ADD CONSTRAINT build_queue_files_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE CASCADE;
3990 -- Name: build_queue_policy_files_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
3993 ALTER TABLE ONLY build_queue_policy_files
3994 ADD CONSTRAINT build_queue_policy_files_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE CASCADE;
3998 -- Name: build_queue_policy_files_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4001 ALTER TABLE ONLY build_queue_policy_files
4002 ADD CONSTRAINT build_queue_policy_files_file_id_fkey FOREIGN KEY (file_id) REFERENCES changes_pending_files(id) ON DELETE CASCADE;
4006 -- Name: changes_pending_binaries_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4009 ALTER TABLE ONLY changes_pending_binaries
4010 ADD CONSTRAINT changes_pending_binaries_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
4014 -- Name: changes_pending_binaries_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4017 ALTER TABLE ONLY changes_pending_binaries
4018 ADD CONSTRAINT changes_pending_binaries_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
4022 -- Name: changes_pending_binaries_pending_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4025 ALTER TABLE ONLY changes_pending_binaries
4026 ADD CONSTRAINT changes_pending_binaries_pending_file_id_fkey FOREIGN KEY (pending_file_id) REFERENCES changes_pending_files(id);
4030 -- Name: changes_pending_binaries_pending_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4033 ALTER TABLE ONLY changes_pending_binaries
4034 ADD CONSTRAINT changes_pending_binaries_pending_source_id_fkey FOREIGN KEY (pending_source_id) REFERENCES changes_pending_source(id);
4038 -- Name: changes_pending_binaries_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4041 ALTER TABLE ONLY changes_pending_binaries
4042 ADD CONSTRAINT changes_pending_binaries_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(id);
4046 -- Name: changes_pending_files_map_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4049 ALTER TABLE ONLY changes_pending_files_map
4050 ADD CONSTRAINT changes_pending_files_map_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
4054 -- Name: changes_pending_files_map_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4057 ALTER TABLE ONLY changes_pending_files_map
4058 ADD CONSTRAINT changes_pending_files_map_file_id_fkey FOREIGN KEY (file_id) REFERENCES changes_pending_files(id);
4062 -- Name: changes_pending_source_change_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4065 ALTER TABLE ONLY changes_pending_source
4066 ADD CONSTRAINT changes_pending_source_change_id_fkey FOREIGN KEY (change_id) REFERENCES changes(id);
4070 -- Name: changes_pending_source_changedby_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4073 ALTER TABLE ONLY changes_pending_source
4074 ADD CONSTRAINT changes_pending_source_changedby_id_fkey FOREIGN KEY (changedby_id) REFERENCES maintainer(id);
4078 -- Name: changes_pending_source_files_pending_file_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4081 ALTER TABLE ONLY changes_pending_source_files
4082 ADD CONSTRAINT changes_pending_source_files_pending_file_id_fkey FOREIGN KEY (pending_file_id) REFERENCES changes_pending_files(id);
4086 -- Name: changes_pending_source_files_pending_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4089 ALTER TABLE ONLY changes_pending_source_files
4090 ADD CONSTRAINT changes_pending_source_files_pending_source_id_fkey FOREIGN KEY (pending_source_id) REFERENCES changes_pending_source(id);
4094 -- Name: changes_pending_source_maintainer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4097 ALTER TABLE ONLY changes_pending_source
4098 ADD CONSTRAINT changes_pending_source_maintainer_id_fkey FOREIGN KEY (maintainer_id) REFERENCES maintainer(id);
4102 -- Name: changes_pending_source_sig_fpr_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4105 ALTER TABLE ONLY changes_pending_source
4106 ADD CONSTRAINT changes_pending_source_sig_fpr_fkey FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id);
4110 -- Name: changes_pool_files_changeid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4113 ALTER TABLE ONLY changes_pool_files
4114 ADD CONSTRAINT changes_pool_files_changeid_fkey FOREIGN KEY (changeid) REFERENCES changes(id) ON DELETE CASCADE;
4118 -- Name: changes_pool_files_fileid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4121 ALTER TABLE ONLY changes_pool_files
4122 ADD CONSTRAINT changes_pool_files_fileid_fkey FOREIGN KEY (fileid) REFERENCES files(id) ON DELETE RESTRICT;
4126 -- Name: dsc_files_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
4129 ALTER TABLE ONLY dsc_files
4130 ADD CONSTRAINT dsc_files_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
4134 -- Name: dsc_files_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4137 ALTER TABLE ONLY dsc_files
4138 ADD CONSTRAINT dsc_files_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
4142 -- Name: external_overrides_component_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4145 ALTER TABLE ONLY external_overrides
4146 ADD CONSTRAINT external_overrides_component_fkey FOREIGN KEY (component) REFERENCES component(id);
4150 -- Name: external_overrides_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4153 ALTER TABLE ONLY external_overrides
4154 ADD CONSTRAINT external_overrides_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4158 -- Name: extra_src_references_bin_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4161 ALTER TABLE ONLY extra_src_references
4162 ADD CONSTRAINT extra_src_references_bin_id_fkey FOREIGN KEY (bin_id) REFERENCES binaries(id) ON DELETE CASCADE;
4166 -- Name: extra_src_references_src_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4169 ALTER TABLE ONLY extra_src_references
4170 ADD CONSTRAINT extra_src_references_src_id_fkey FOREIGN KEY (src_id) REFERENCES source(id) ON DELETE RESTRICT;
4174 -- Name: files_location; Type: FK CONSTRAINT; Schema: public; Owner: dak
4177 ALTER TABLE ONLY files
4178 ADD CONSTRAINT files_location FOREIGN KEY (location) REFERENCES location(id) MATCH FULL;
4182 -- Name: fingerprint_binary_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4185 ALTER TABLE ONLY fingerprint
4186 ADD CONSTRAINT fingerprint_binary_acl_id_fkey FOREIGN KEY (binary_acl_id) REFERENCES binary_acl(id);
4190 -- Name: fingerprint_source_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4193 ALTER TABLE ONLY fingerprint
4194 ADD CONSTRAINT fingerprint_source_acl_id_fkey FOREIGN KEY (source_acl_id) REFERENCES source_acl(id);
4198 -- Name: fingerprint_uid; Type: FK CONSTRAINT; Schema: public; Owner: dak
4201 ALTER TABLE ONLY fingerprint
4202 ADD CONSTRAINT fingerprint_uid FOREIGN KEY (uid) REFERENCES uid(id) MATCH FULL;
4206 -- Name: keyring_acl_map_architecture_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4209 ALTER TABLE ONLY keyring_acl_map
4210 ADD CONSTRAINT keyring_acl_map_architecture_id_fkey FOREIGN KEY (architecture_id) REFERENCES architecture(id);
4214 -- Name: keyring_acl_map_keyring_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4217 ALTER TABLE ONLY keyring_acl_map
4218 ADD CONSTRAINT keyring_acl_map_keyring_id_fkey FOREIGN KEY (keyring_id) REFERENCES keyrings(id);
4222 -- Name: keyrings_default_binary_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4225 ALTER TABLE ONLY keyrings
4226 ADD CONSTRAINT keyrings_default_binary_acl_id_fkey FOREIGN KEY (default_binary_acl_id) REFERENCES binary_acl(id);
4230 -- Name: keyrings_default_source_acl_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4233 ALTER TABLE ONLY keyrings
4234 ADD CONSTRAINT keyrings_default_source_acl_id_fkey FOREIGN KEY (default_source_acl_id) REFERENCES source_acl(id);
4238 -- Name: known_changes_approved_for_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4241 ALTER TABLE ONLY changes
4242 ADD CONSTRAINT known_changes_approved_for_fkey FOREIGN KEY (in_queue) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4246 -- Name: known_changes_in_queue_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4249 ALTER TABLE ONLY changes
4250 ADD CONSTRAINT known_changes_in_queue_fkey FOREIGN KEY (in_queue) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4254 -- Name: location_archive_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4257 ALTER TABLE ONLY location
4258 ADD CONSTRAINT location_archive_fkey FOREIGN KEY (archive) REFERENCES archive(id);
4262 -- Name: location_component_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4265 ALTER TABLE ONLY location
4266 ADD CONSTRAINT location_component_fkey FOREIGN KEY (component) REFERENCES component(id);
4270 -- Name: override_component; Type: FK CONSTRAINT; Schema: public; Owner: dak
4273 ALTER TABLE ONLY override
4274 ADD CONSTRAINT override_component FOREIGN KEY (component) REFERENCES component(id) MATCH FULL;
4278 -- Name: override_priority; Type: FK CONSTRAINT; Schema: public; Owner: dak
4281 ALTER TABLE ONLY override
4282 ADD CONSTRAINT override_priority FOREIGN KEY (priority) REFERENCES priority(id) MATCH FULL;
4286 -- Name: override_section; Type: FK CONSTRAINT; Schema: public; Owner: dak
4289 ALTER TABLE ONLY override
4290 ADD CONSTRAINT override_section FOREIGN KEY (section) REFERENCES section(id) MATCH FULL;
4294 -- Name: override_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4297 ALTER TABLE ONLY override
4298 ADD CONSTRAINT override_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4302 -- Name: override_type; Type: FK CONSTRAINT; Schema: public; Owner: dak
4305 ALTER TABLE ONLY override
4306 ADD CONSTRAINT override_type FOREIGN KEY (type) REFERENCES override_type(id) MATCH FULL;
4310 -- Name: queue_files_fileid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4313 ALTER TABLE ONLY build_queue_files
4314 ADD CONSTRAINT queue_files_fileid_fkey FOREIGN KEY (fileid) REFERENCES files(id) ON DELETE CASCADE;
4318 -- Name: source_changedby; Type: FK CONSTRAINT; Schema: public; Owner: dak
4321 ALTER TABLE ONLY source
4322 ADD CONSTRAINT source_changedby FOREIGN KEY (changedby) REFERENCES maintainer(id) MATCH FULL;
4326 -- Name: source_file; Type: FK CONSTRAINT; Schema: public; Owner: dak
4329 ALTER TABLE ONLY source
4330 ADD CONSTRAINT source_file FOREIGN KEY (file) REFERENCES files(id) MATCH FULL;
4334 -- Name: source_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
4337 ALTER TABLE ONLY source
4338 ADD CONSTRAINT source_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) MATCH FULL;
4342 -- Name: source_metadata_key_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4345 ALTER TABLE ONLY source_metadata
4346 ADD CONSTRAINT source_metadata_key_id_fkey FOREIGN KEY (key_id) REFERENCES metadata_keys(key_id);
4350 -- Name: source_metadata_src_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4353 ALTER TABLE ONLY source_metadata
4354 ADD CONSTRAINT source_metadata_src_id_fkey FOREIGN KEY (src_id) REFERENCES source(id) ON DELETE CASCADE;
4358 -- Name: source_sig_fpr; Type: FK CONSTRAINT; Schema: public; Owner: dak
4361 ALTER TABLE ONLY source
4362 ADD CONSTRAINT source_sig_fpr FOREIGN KEY (sig_fpr) REFERENCES fingerprint(id) MATCH FULL;
4366 -- Name: src_associations_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4369 ALTER TABLE ONLY src_associations
4370 ADD CONSTRAINT src_associations_source FOREIGN KEY (source) REFERENCES source(id) MATCH FULL;
4374 -- Name: src_associations_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4377 ALTER TABLE ONLY src_associations
4378 ADD CONSTRAINT src_associations_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4382 -- Name: src_contents_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4385 ALTER TABLE ONLY src_contents
4386 ADD CONSTRAINT src_contents_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(id) ON DELETE CASCADE;
4390 -- Name: src_format_key; Type: FK CONSTRAINT; Schema: public; Owner: dak
4393 ALTER TABLE ONLY suite_src_formats
4394 ADD CONSTRAINT src_format_key FOREIGN KEY (src_format) REFERENCES src_format(id);
4398 -- Name: src_uploaders_maintainer; Type: FK CONSTRAINT; Schema: public; Owner: dak
4401 ALTER TABLE ONLY src_uploaders
4402 ADD CONSTRAINT src_uploaders_maintainer FOREIGN KEY (maintainer) REFERENCES maintainer(id) ON DELETE CASCADE;
4406 -- Name: src_uploaders_source; Type: FK CONSTRAINT; Schema: public; Owner: dak
4409 ALTER TABLE ONLY src_uploaders
4410 ADD CONSTRAINT src_uploaders_source FOREIGN KEY (source) REFERENCES source(id) ON DELETE CASCADE;
4414 -- Name: suite_architectures_architectur; Type: FK CONSTRAINT; Schema: public; Owner: dak
4417 ALTER TABLE ONLY suite_architectures
4418 ADD CONSTRAINT suite_architectures_architectur FOREIGN KEY (architecture) REFERENCES architecture(id) MATCH FULL;
4422 -- Name: suite_architectures_suite; Type: FK CONSTRAINT; Schema: public; Owner: dak
4425 ALTER TABLE ONLY suite_architectures
4426 ADD CONSTRAINT suite_architectures_suite FOREIGN KEY (suite) REFERENCES suite(id) MATCH FULL;
4430 -- Name: suite_build_queue_copy_build_queue_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4433 ALTER TABLE ONLY suite_build_queue_copy
4434 ADD CONSTRAINT suite_build_queue_copy_build_queue_id_fkey FOREIGN KEY (build_queue_id) REFERENCES build_queue(id) ON DELETE RESTRICT;
4438 -- Name: suite_key; Type: FK CONSTRAINT; Schema: public; Owner: dak
4441 ALTER TABLE ONLY suite_src_formats
4442 ADD CONSTRAINT suite_key FOREIGN KEY (suite) REFERENCES suite(id);
4446 -- Name: suite_policy_queue_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4449 ALTER TABLE ONLY suite
4450 ADD CONSTRAINT suite_policy_queue_fkey FOREIGN KEY (policy_queue_id) REFERENCES policy_queue(id) ON DELETE RESTRICT;
4454 -- Name: suite_queue_copy_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4457 ALTER TABLE ONLY suite_build_queue_copy
4458 ADD CONSTRAINT suite_queue_copy_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4462 -- Name: upload_blocks_fingerprint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4465 ALTER TABLE ONLY upload_blocks
4466 ADD CONSTRAINT upload_blocks_fingerprint_id_fkey FOREIGN KEY (fingerprint_id) REFERENCES fingerprint(id);
4470 -- Name: upload_blocks_uid_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4473 ALTER TABLE ONLY upload_blocks
4474 ADD CONSTRAINT upload_blocks_uid_id_fkey FOREIGN KEY (uid_id) REFERENCES uid(id);
4478 -- Name: version_check_reference_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4481 ALTER TABLE ONLY version_check
4482 ADD CONSTRAINT version_check_reference_fkey FOREIGN KEY (reference) REFERENCES suite(id);
4486 -- Name: version_check_suite_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dak
4489 ALTER TABLE ONLY version_check
4490 ADD CONSTRAINT version_check_suite_fkey FOREIGN KEY (suite) REFERENCES suite(id);
4494 -- Name: audit; Type: ACL; Schema: -; Owner: dak
4497 REVOKE ALL ON SCHEMA audit FROM PUBLIC;
4498 REVOKE ALL ON SCHEMA audit FROM dak;
4499 GRANT ALL ON SCHEMA audit TO dak;
4500 GRANT USAGE ON SCHEMA audit TO PUBLIC;
4501 GRANT USAGE ON SCHEMA audit TO ftpteam;
4502 GRANT USAGE ON SCHEMA audit TO ftpmaster;
4506 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4509 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4510 REVOKE ALL ON SCHEMA public FROM postgres;
4511 GRANT ALL ON SCHEMA public TO postgres;
4512 GRANT ALL ON SCHEMA public TO PUBLIC;
4515 SET search_path = audit, pg_catalog;
4518 -- Name: package_changes; Type: ACL; Schema: audit; Owner: dak
4521 REVOKE ALL ON TABLE package_changes FROM PUBLIC;
4522 REVOKE ALL ON TABLE package_changes FROM dak;
4523 GRANT ALL ON TABLE package_changes TO dak;
4524 GRANT SELECT ON TABLE package_changes TO PUBLIC;
4527 SET search_path = public, pg_catalog;
4530 -- Name: bin_associations_id_seq; Type: ACL; Schema: public; Owner: dak
4533 REVOKE ALL ON SEQUENCE bin_associations_id_seq FROM PUBLIC;
4534 REVOKE ALL ON SEQUENCE bin_associations_id_seq FROM dak;
4535 GRANT ALL ON SEQUENCE bin_associations_id_seq TO dak;
4536 GRANT SELECT ON SEQUENCE bin_associations_id_seq TO PUBLIC;
4537 GRANT ALL ON SEQUENCE bin_associations_id_seq TO ftpmaster;
4541 -- Name: bin_associations; Type: ACL; Schema: public; Owner: dak
4544 REVOKE ALL ON TABLE bin_associations FROM PUBLIC;
4545 REVOKE ALL ON TABLE bin_associations FROM dak;
4546 GRANT ALL ON TABLE bin_associations TO dak;
4547 GRANT SELECT ON TABLE bin_associations TO PUBLIC;
4548 GRANT ALL ON TABLE bin_associations TO ftpmaster;
4549 GRANT DELETE ON TABLE bin_associations TO ftpteam;
4553 -- Name: binaries_id_seq; Type: ACL; Schema: public; Owner: dak
4556 REVOKE ALL ON SEQUENCE binaries_id_seq FROM PUBLIC;
4557 REVOKE ALL ON SEQUENCE binaries_id_seq FROM dak;
4558 GRANT ALL ON SEQUENCE binaries_id_seq TO dak;
4559 GRANT SELECT ON SEQUENCE binaries_id_seq TO PUBLIC;
4560 GRANT ALL ON SEQUENCE binaries_id_seq TO ftpmaster;
4564 -- Name: binaries; Type: ACL; Schema: public; Owner: dak
4567 REVOKE ALL ON TABLE binaries FROM PUBLIC;
4568 REVOKE ALL ON TABLE binaries FROM dak;
4569 GRANT ALL ON TABLE binaries TO dak;
4570 GRANT SELECT ON TABLE binaries TO PUBLIC;
4571 GRANT ALL ON TABLE binaries TO ftpmaster;
4575 -- Name: bin_associations_binaries; Type: ACL; Schema: public; Owner: dak
4578 REVOKE ALL ON TABLE bin_associations_binaries FROM PUBLIC;
4579 REVOKE ALL ON TABLE bin_associations_binaries FROM dak;
4580 GRANT ALL ON TABLE bin_associations_binaries TO dak;
4581 GRANT SELECT ON TABLE bin_associations_binaries TO ftpmaster;
4582 GRANT SELECT ON TABLE bin_associations_binaries TO PUBLIC;
4586 -- Name: source_id_seq; Type: ACL; Schema: public; Owner: dak
4589 REVOKE ALL ON SEQUENCE source_id_seq FROM PUBLIC;
4590 REVOKE ALL ON SEQUENCE source_id_seq FROM dak;
4591 GRANT ALL ON SEQUENCE source_id_seq TO dak;
4592 GRANT SELECT ON SEQUENCE source_id_seq TO PUBLIC;
4593 GRANT ALL ON SEQUENCE source_id_seq TO ftpmaster;
4597 -- Name: source; Type: ACL; Schema: public; Owner: dak
4600 REVOKE ALL ON TABLE source FROM PUBLIC;
4601 REVOKE ALL ON TABLE source FROM dak;
4602 GRANT ALL ON TABLE source TO dak;
4603 GRANT SELECT ON TABLE source TO PUBLIC;
4604 GRANT ALL ON TABLE source TO ftpmaster;
4608 -- Name: src_associations_id_seq; Type: ACL; Schema: public; Owner: dak
4611 REVOKE ALL ON SEQUENCE src_associations_id_seq FROM PUBLIC;
4612 REVOKE ALL ON SEQUENCE src_associations_id_seq FROM dak;
4613 GRANT ALL ON SEQUENCE src_associations_id_seq TO dak;
4614 GRANT SELECT ON SEQUENCE src_associations_id_seq TO PUBLIC;
4615 GRANT ALL ON SEQUENCE src_associations_id_seq TO ftpmaster;
4619 -- Name: src_associations; Type: ACL; Schema: public; Owner: dak
4622 REVOKE ALL ON TABLE src_associations FROM PUBLIC;
4623 REVOKE ALL ON TABLE src_associations FROM dak;
4624 GRANT ALL ON TABLE src_associations TO dak;
4625 GRANT SELECT ON TABLE src_associations TO PUBLIC;
4626 GRANT ALL ON TABLE src_associations TO ftpmaster;
4627 GRANT DELETE ON TABLE src_associations TO ftpteam;
4631 -- Name: src_associations_bin; Type: ACL; Schema: public; Owner: dak
4634 REVOKE ALL ON TABLE src_associations_bin FROM PUBLIC;
4635 REVOKE ALL ON TABLE src_associations_bin FROM dak;
4636 GRANT ALL ON TABLE src_associations_bin TO dak;
4637 GRANT SELECT ON TABLE src_associations_bin TO ftpmaster;
4638 GRANT SELECT ON TABLE src_associations_bin TO PUBLIC;
4642 -- Name: almost_obsolete_all_associations; Type: ACL; Schema: public; Owner: dak
4645 REVOKE ALL ON TABLE almost_obsolete_all_associations FROM PUBLIC;
4646 REVOKE ALL ON TABLE almost_obsolete_all_associations FROM dak;
4647 GRANT ALL ON TABLE almost_obsolete_all_associations TO dak;
4648 GRANT SELECT ON TABLE almost_obsolete_all_associations TO ftpmaster;
4649 GRANT SELECT ON TABLE almost_obsolete_all_associations TO PUBLIC;
4653 -- Name: any_associations_source; Type: ACL; Schema: public; Owner: dak
4656 REVOKE ALL ON TABLE any_associations_source FROM PUBLIC;
4657 REVOKE ALL ON TABLE any_associations_source FROM dak;
4658 GRANT ALL ON TABLE any_associations_source TO dak;
4659 GRANT SELECT ON TABLE any_associations_source TO ftpmaster;
4660 GRANT SELECT ON TABLE any_associations_source TO PUBLIC;
4664 -- Name: src_associations_src; Type: ACL; Schema: public; Owner: dak
4667 REVOKE ALL ON TABLE src_associations_src FROM PUBLIC;
4668 REVOKE ALL ON TABLE src_associations_src FROM dak;
4669 GRANT ALL ON TABLE src_associations_src TO dak;
4670 GRANT SELECT ON TABLE src_associations_src TO ftpmaster;
4671 GRANT SELECT ON TABLE src_associations_src TO PUBLIC;
4675 -- Name: almost_obsolete_src_associations; Type: ACL; Schema: public; Owner: dak
4678 REVOKE ALL ON TABLE almost_obsolete_src_associations FROM PUBLIC;
4679 REVOKE ALL ON TABLE almost_obsolete_src_associations FROM dak;
4680 GRANT ALL ON TABLE almost_obsolete_src_associations TO dak;
4681 GRANT SELECT ON TABLE almost_obsolete_src_associations TO ftpmaster;
4682 GRANT SELECT ON TABLE almost_obsolete_src_associations TO PUBLIC;
4686 -- Name: architecture_id_seq; Type: ACL; Schema: public; Owner: dak
4689 REVOKE ALL ON SEQUENCE architecture_id_seq FROM PUBLIC;
4690 REVOKE ALL ON SEQUENCE architecture_id_seq FROM dak;
4691 GRANT ALL ON SEQUENCE architecture_id_seq TO dak;
4692 GRANT SELECT ON SEQUENCE architecture_id_seq TO PUBLIC;
4693 GRANT ALL ON SEQUENCE architecture_id_seq TO ftpmaster;
4697 -- Name: architecture; Type: ACL; Schema: public; Owner: dak
4700 REVOKE ALL ON TABLE architecture FROM PUBLIC;
4701 REVOKE ALL ON TABLE architecture FROM dak;
4702 GRANT ALL ON TABLE architecture TO dak;
4703 GRANT SELECT ON TABLE architecture TO PUBLIC;
4704 GRANT ALL ON TABLE architecture TO ftpmaster;
4708 -- Name: archive_id_seq; Type: ACL; Schema: public; Owner: dak
4711 REVOKE ALL ON SEQUENCE archive_id_seq FROM PUBLIC;
4712 REVOKE ALL ON SEQUENCE archive_id_seq FROM dak;
4713 GRANT ALL ON SEQUENCE archive_id_seq TO dak;
4714 GRANT SELECT ON SEQUENCE archive_id_seq TO PUBLIC;
4715 GRANT ALL ON SEQUENCE archive_id_seq TO ftpmaster;
4719 -- Name: archive; Type: ACL; Schema: public; Owner: dak
4722 REVOKE ALL ON TABLE archive FROM PUBLIC;
4723 REVOKE ALL ON TABLE archive FROM dak;
4724 GRANT ALL ON TABLE archive TO dak;
4725 GRANT SELECT ON TABLE archive TO PUBLIC;
4726 GRANT ALL ON TABLE archive TO ftpmaster;
4730 -- Name: bin_contents; Type: ACL; Schema: public; Owner: dak
4733 REVOKE ALL ON TABLE bin_contents FROM PUBLIC;
4734 REVOKE ALL ON TABLE bin_contents FROM dak;
4735 GRANT ALL ON TABLE bin_contents TO dak;
4736 GRANT SELECT ON TABLE bin_contents TO PUBLIC;
4737 GRANT ALL ON TABLE bin_contents TO ftpmaster;
4741 -- Name: binaries_metadata; Type: ACL; Schema: public; Owner: dak
4744 REVOKE ALL ON TABLE binaries_metadata FROM PUBLIC;
4745 REVOKE ALL ON TABLE binaries_metadata FROM dak;
4746 GRANT ALL ON TABLE binaries_metadata TO dak;
4747 GRANT SELECT,INSERT,UPDATE ON TABLE binaries_metadata TO ftpmaster;
4748 GRANT SELECT ON TABLE binaries_metadata TO PUBLIC;
4752 -- Name: suite_id_seq; Type: ACL; Schema: public; Owner: dak
4755 REVOKE ALL ON SEQUENCE suite_id_seq FROM PUBLIC;
4756 REVOKE ALL ON SEQUENCE suite_id_seq FROM dak;
4757 GRANT ALL ON SEQUENCE suite_id_seq TO dak;
4758 GRANT SELECT ON SEQUENCE suite_id_seq TO PUBLIC;
4759 GRANT ALL ON SEQUENCE suite_id_seq TO ftpmaster;
4763 -- Name: suite; Type: ACL; Schema: public; Owner: dak
4766 REVOKE ALL ON TABLE suite FROM PUBLIC;
4767 REVOKE ALL ON TABLE suite FROM dak;
4768 GRANT ALL ON TABLE suite TO dak;
4769 GRANT SELECT ON TABLE suite TO PUBLIC;
4770 GRANT ALL ON TABLE suite TO ftpmaster;
4774 -- Name: binaries_suite_arch; Type: ACL; Schema: public; Owner: dak
4777 REVOKE ALL ON TABLE binaries_suite_arch FROM PUBLIC;
4778 REVOKE ALL ON TABLE binaries_suite_arch FROM dak;
4779 GRANT ALL ON TABLE binaries_suite_arch TO dak;
4780 GRANT SELECT ON TABLE binaries_suite_arch TO ftpmaster;
4781 GRANT SELECT ON TABLE binaries_suite_arch TO PUBLIC;
4785 -- Name: binary_acl; Type: ACL; Schema: public; Owner: dak
4788 REVOKE ALL ON TABLE binary_acl FROM PUBLIC;
4789 REVOKE ALL ON TABLE binary_acl FROM dak;
4790 GRANT ALL ON TABLE binary_acl TO dak;
4791 GRANT SELECT ON TABLE binary_acl TO PUBLIC;
4792 GRANT ALL ON TABLE binary_acl TO ftpmaster;
4796 -- Name: binary_acl_id_seq; Type: ACL; Schema: public; Owner: dak
4799 REVOKE ALL ON SEQUENCE binary_acl_id_seq FROM PUBLIC;
4800 REVOKE ALL ON SEQUENCE binary_acl_id_seq FROM dak;
4801 GRANT ALL ON SEQUENCE binary_acl_id_seq TO dak;
4802 GRANT ALL ON SEQUENCE binary_acl_id_seq TO ftpmaster;
4803 GRANT SELECT ON SEQUENCE binary_acl_id_seq TO PUBLIC;
4807 -- Name: binary_acl_map; Type: ACL; Schema: public; Owner: dak
4810 REVOKE ALL ON TABLE binary_acl_map FROM PUBLIC;
4811 REVOKE ALL ON TABLE binary_acl_map FROM dak;
4812 GRANT ALL ON TABLE binary_acl_map TO dak;
4813 GRANT SELECT ON TABLE binary_acl_map TO PUBLIC;
4814 GRANT ALL ON TABLE binary_acl_map TO ftpmaster;
4818 -- Name: binary_acl_map_id_seq; Type: ACL; Schema: public; Owner: dak
4821 REVOKE ALL ON SEQUENCE binary_acl_map_id_seq FROM PUBLIC;
4822 REVOKE ALL ON SEQUENCE binary_acl_map_id_seq FROM dak;
4823 GRANT ALL ON SEQUENCE binary_acl_map_id_seq TO dak;
4824 GRANT ALL ON SEQUENCE binary_acl_map_id_seq TO ftpmaster;
4825 GRANT SELECT ON SEQUENCE binary_acl_map_id_seq TO PUBLIC;
4829 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: dak
4832 REVOKE ALL ON SEQUENCE files_id_seq FROM PUBLIC;
4833 REVOKE ALL ON SEQUENCE files_id_seq FROM dak;
4834 GRANT ALL ON SEQUENCE files_id_seq TO dak;
4835 GRANT SELECT ON SEQUENCE files_id_seq TO PUBLIC;
4836 GRANT ALL ON SEQUENCE files_id_seq TO ftpmaster;
4840 -- Name: files; Type: ACL; Schema: public; Owner: dak
4843 REVOKE ALL ON TABLE files FROM PUBLIC;
4844 REVOKE ALL ON TABLE files FROM dak;
4845 GRANT ALL ON TABLE files TO dak;
4846 GRANT SELECT ON TABLE files TO PUBLIC;
4847 GRANT ALL ON TABLE files TO ftpmaster;
4851 -- Name: location_id_seq; Type: ACL; Schema: public; Owner: dak
4854 REVOKE ALL ON SEQUENCE location_id_seq FROM PUBLIC;
4855 REVOKE ALL ON SEQUENCE location_id_seq FROM dak;
4856 GRANT ALL ON SEQUENCE location_id_seq TO dak;
4857 GRANT SELECT ON SEQUENCE location_id_seq TO PUBLIC;
4858 GRANT ALL ON SEQUENCE location_id_seq TO ftpmaster;
4862 -- Name: location; Type: ACL; Schema: public; Owner: dak
4865 REVOKE ALL ON TABLE location FROM PUBLIC;
4866 REVOKE ALL ON TABLE location FROM dak;
4867 GRANT ALL ON TABLE location TO dak;
4868 GRANT SELECT ON TABLE location TO PUBLIC;
4869 GRANT ALL ON TABLE location TO ftpmaster;
4873 -- Name: binfiles_suite_component_arch; Type: ACL; Schema: public; Owner: dak
4876 REVOKE ALL ON TABLE binfiles_suite_component_arch FROM PUBLIC;
4877 REVOKE ALL ON TABLE binfiles_suite_component_arch FROM dak;
4878 GRANT ALL ON TABLE binfiles_suite_component_arch TO dak;
4879 GRANT SELECT ON TABLE binfiles_suite_component_arch TO ftpmaster;
4880 GRANT SELECT ON TABLE binfiles_suite_component_arch TO PUBLIC;
4884 -- Name: build_queue; Type: ACL; Schema: public; Owner: dak
4887 REVOKE ALL ON TABLE build_queue FROM PUBLIC;
4888 REVOKE ALL ON TABLE build_queue FROM dak;
4889 GRANT ALL ON TABLE build_queue TO dak;
4890 GRANT SELECT ON TABLE build_queue TO PUBLIC;
4891 GRANT ALL ON TABLE build_queue TO ftpmaster;
4895 -- Name: build_queue_files; Type: ACL; Schema: public; Owner: dak
4898 REVOKE ALL ON TABLE build_queue_files FROM PUBLIC;
4899 REVOKE ALL ON TABLE build_queue_files FROM dak;
4900 GRANT ALL ON TABLE build_queue_files TO dak;
4901 GRANT SELECT ON TABLE build_queue_files TO PUBLIC;
4902 GRANT ALL ON TABLE build_queue_files TO ftpmaster;
4906 -- Name: build_queue_files_id_seq; Type: ACL; Schema: public; Owner: dak
4909 REVOKE ALL ON SEQUENCE build_queue_files_id_seq FROM PUBLIC;
4910 REVOKE ALL ON SEQUENCE build_queue_files_id_seq FROM dak;
4911 GRANT ALL ON SEQUENCE build_queue_files_id_seq TO dak;
4912 GRANT ALL ON SEQUENCE build_queue_files_id_seq TO ftpmaster;
4913 GRANT SELECT ON SEQUENCE build_queue_files_id_seq TO PUBLIC;
4917 -- Name: build_queue_id_seq; Type: ACL; Schema: public; Owner: dak
4920 REVOKE ALL ON SEQUENCE build_queue_id_seq FROM PUBLIC;
4921 REVOKE ALL ON SEQUENCE build_queue_id_seq FROM dak;
4922 GRANT ALL ON SEQUENCE build_queue_id_seq TO dak;
4923 GRANT ALL ON SEQUENCE build_queue_id_seq TO ftpmaster;
4924 GRANT SELECT ON SEQUENCE build_queue_id_seq TO PUBLIC;
4928 -- Name: build_queue_policy_files; Type: ACL; Schema: public; Owner: dak
4931 REVOKE ALL ON TABLE build_queue_policy_files FROM PUBLIC;
4932 REVOKE ALL ON TABLE build_queue_policy_files FROM dak;
4933 GRANT ALL ON TABLE build_queue_policy_files TO dak;
4934 GRANT SELECT,INSERT,UPDATE ON TABLE build_queue_policy_files TO ftpmaster;
4935 GRANT SELECT ON TABLE build_queue_policy_files TO PUBLIC;
4939 -- Name: changelogs_text; Type: ACL; Schema: public; Owner: dak
4942 REVOKE ALL ON TABLE changelogs_text FROM PUBLIC;
4943 REVOKE ALL ON TABLE changelogs_text FROM dak;
4944 GRANT ALL ON TABLE changelogs_text TO dak;
4945 GRANT SELECT ON TABLE changelogs_text TO PUBLIC;
4946 GRANT ALL ON TABLE changelogs_text TO ftpmaster;
4950 -- Name: changes; Type: ACL; Schema: public; Owner: dak
4953 REVOKE ALL ON TABLE changes FROM PUBLIC;
4954 REVOKE ALL ON TABLE changes FROM dak;
4955 GRANT ALL ON TABLE changes TO dak;
4956 GRANT ALL ON TABLE changes TO ftpmaster;
4957 GRANT SELECT ON TABLE changes TO PUBLIC;
4958 GRANT DELETE,UPDATE ON TABLE changes TO ftpteam;
4962 -- Name: changelogs; Type: ACL; Schema: public; Owner: dak
4965 REVOKE ALL ON TABLE changelogs FROM PUBLIC;
4966 REVOKE ALL ON TABLE changelogs FROM dak;
4967 GRANT ALL ON TABLE changelogs TO dak;
4968 GRANT SELECT ON TABLE changelogs TO PUBLIC;
4969 GRANT ALL ON TABLE changelogs TO ftpmaster;
4973 -- Name: changelogs_text_id_seq; Type: ACL; Schema: public; Owner: dak
4976 REVOKE ALL ON SEQUENCE changelogs_text_id_seq FROM PUBLIC;
4977 REVOKE ALL ON SEQUENCE changelogs_text_id_seq FROM dak;
4978 GRANT ALL ON SEQUENCE changelogs_text_id_seq TO dak;
4979 GRANT ALL ON SEQUENCE changelogs_text_id_seq TO ftpmaster;
4980 GRANT SELECT ON SEQUENCE changelogs_text_id_seq TO PUBLIC;
4984 -- Name: changes_id_seq; Type: ACL; Schema: public; Owner: dak
4987 REVOKE ALL ON SEQUENCE changes_id_seq FROM PUBLIC;
4988 REVOKE ALL ON SEQUENCE changes_id_seq FROM dak;
4989 GRANT ALL ON SEQUENCE changes_id_seq TO dak;
4990 GRANT ALL ON SEQUENCE changes_id_seq TO ftpmaster;
4991 GRANT SELECT ON SEQUENCE changes_id_seq TO PUBLIC;
4995 -- Name: changes_pending_binaries; Type: ACL; Schema: public; Owner: dak
4998 REVOKE ALL ON TABLE changes_pending_binaries FROM PUBLIC;
4999 REVOKE ALL ON TABLE changes_pending_binaries FROM dak;
5000 GRANT ALL ON TABLE changes_pending_binaries TO dak;
5001 GRANT SELECT ON TABLE changes_pending_binaries TO PUBLIC;
5002 GRANT ALL ON TABLE changes_pending_binaries TO ftpmaster;
5006 -- Name: changes_pending_binaries_id_seq; Type: ACL; Schema: public; Owner: dak
5009 REVOKE ALL ON SEQUENCE changes_pending_binaries_id_seq FROM PUBLIC;
5010 REVOKE ALL ON SEQUENCE changes_pending_binaries_id_seq FROM dak;
5011 GRANT ALL ON SEQUENCE changes_pending_binaries_id_seq TO dak;
5012 GRANT ALL ON SEQUENCE changes_pending_binaries_id_seq TO ftpmaster;
5013 GRANT SELECT ON SEQUENCE changes_pending_binaries_id_seq TO PUBLIC;
5017 -- Name: changes_pending_files; Type: ACL; Schema: public; Owner: dak
5020 REVOKE ALL ON TABLE changes_pending_files FROM PUBLIC;
5021 REVOKE ALL ON TABLE changes_pending_files FROM dak;
5022 GRANT ALL ON TABLE changes_pending_files TO dak;
5023 GRANT SELECT ON TABLE changes_pending_files TO PUBLIC;
5024 GRANT ALL ON TABLE changes_pending_files TO ftpmaster;
5025 GRANT DELETE ON TABLE changes_pending_files TO ftpteam;
5029 -- Name: changes_pending_files_id_seq; Type: ACL; Schema: public; Owner: dak
5032 REVOKE ALL ON SEQUENCE changes_pending_files_id_seq FROM PUBLIC;
5033 REVOKE ALL ON SEQUENCE changes_pending_files_id_seq FROM dak;
5034 GRANT ALL ON SEQUENCE changes_pending_files_id_seq TO dak;
5035 GRANT ALL ON SEQUENCE changes_pending_files_id_seq TO ftpmaster;
5036 GRANT SELECT ON SEQUENCE changes_pending_files_id_seq TO PUBLIC;
5037 GRANT USAGE ON SEQUENCE changes_pending_files_id_seq TO ftpteam;
5041 -- Name: changes_pending_files_map; Type: ACL; Schema: public; Owner: dak
5044 REVOKE ALL ON TABLE changes_pending_files_map FROM PUBLIC;
5045 REVOKE ALL ON TABLE changes_pending_files_map FROM dak;
5046 GRANT ALL ON TABLE changes_pending_files_map TO dak;
5047 GRANT SELECT,INSERT,DELETE ON TABLE changes_pending_files_map TO ftpteam;
5048 GRANT SELECT ON TABLE changes_pending_files_map TO PUBLIC;
5052 -- Name: changes_pending_source; Type: ACL; Schema: public; Owner: dak
5055 REVOKE ALL ON TABLE changes_pending_source FROM PUBLIC;
5056 REVOKE ALL ON TABLE changes_pending_source FROM dak;
5057 GRANT ALL ON TABLE changes_pending_source TO dak;
5058 GRANT SELECT ON TABLE changes_pending_source TO PUBLIC;
5059 GRANT ALL ON TABLE changes_pending_source TO ftpmaster;
5063 -- Name: changes_pending_source_files; Type: ACL; Schema: public; Owner: dak
5066 REVOKE ALL ON TABLE changes_pending_source_files FROM PUBLIC;
5067 REVOKE ALL ON TABLE changes_pending_source_files FROM dak;
5068 GRANT ALL ON TABLE changes_pending_source_files TO dak;
5069 GRANT SELECT ON TABLE changes_pending_source_files TO PUBLIC;
5070 GRANT ALL ON TABLE changes_pending_source_files TO ftpmaster;
5074 -- Name: changes_pending_source_id_seq; Type: ACL; Schema: public; Owner: dak
5077 REVOKE ALL ON SEQUENCE changes_pending_source_id_seq FROM PUBLIC;
5078 REVOKE ALL ON SEQUENCE changes_pending_source_id_seq FROM dak;
5079 GRANT ALL ON SEQUENCE changes_pending_source_id_seq TO dak;
5080 GRANT ALL ON SEQUENCE changes_pending_source_id_seq TO ftpmaster;
5081 GRANT SELECT ON SEQUENCE changes_pending_source_id_seq TO PUBLIC;
5085 -- Name: changes_pool_files; Type: ACL; Schema: public; Owner: dak
5088 REVOKE ALL ON TABLE changes_pool_files FROM PUBLIC;
5089 REVOKE ALL ON TABLE changes_pool_files FROM dak;
5090 GRANT ALL ON TABLE changes_pool_files TO dak;
5091 GRANT SELECT ON TABLE changes_pool_files TO PUBLIC;
5092 GRANT ALL ON TABLE changes_pool_files TO ftpmaster;
5093 GRANT DELETE ON TABLE changes_pool_files TO ftpteam;
5097 -- Name: component_id_seq; Type: ACL; Schema: public; Owner: dak
5100 REVOKE ALL ON SEQUENCE component_id_seq FROM PUBLIC;
5101 REVOKE ALL ON SEQUENCE component_id_seq FROM dak;
5102 GRANT ALL ON SEQUENCE component_id_seq TO dak;
5103 GRANT SELECT ON SEQUENCE component_id_seq TO PUBLIC;
5104 GRANT ALL ON SEQUENCE component_id_seq TO ftpmaster;
5108 -- Name: component; Type: ACL; Schema: public; Owner: dak
5111 REVOKE ALL ON TABLE component FROM PUBLIC;
5112 REVOKE ALL ON TABLE component FROM dak;
5113 GRANT ALL ON TABLE component TO dak;
5114 GRANT SELECT ON TABLE component TO PUBLIC;
5115 GRANT ALL ON TABLE component TO ftpmaster;
5119 -- Name: config; Type: ACL; Schema: public; Owner: dak
5122 REVOKE ALL ON TABLE config FROM PUBLIC;
5123 REVOKE ALL ON TABLE config FROM dak;
5124 GRANT ALL ON TABLE config TO dak;
5125 GRANT ALL ON TABLE config TO ftpmaster;
5126 GRANT SELECT ON TABLE config TO ftpteam;
5127 GRANT SELECT ON TABLE config TO PUBLIC;
5131 -- Name: config_id_seq; Type: ACL; Schema: public; Owner: dak
5134 REVOKE ALL ON SEQUENCE config_id_seq FROM PUBLIC;
5135 REVOKE ALL ON SEQUENCE config_id_seq FROM dak;
5136 GRANT ALL ON SEQUENCE config_id_seq TO dak;
5137 GRANT ALL ON SEQUENCE config_id_seq TO ftpmaster;
5138 GRANT SELECT ON SEQUENCE config_id_seq TO PUBLIC;
5142 -- Name: dsc_files_id_seq; Type: ACL; Schema: public; Owner: dak
5145 REVOKE ALL ON SEQUENCE dsc_files_id_seq FROM PUBLIC;
5146 REVOKE ALL ON SEQUENCE dsc_files_id_seq FROM dak;
5147 GRANT ALL ON SEQUENCE dsc_files_id_seq TO dak;
5148 GRANT SELECT ON SEQUENCE dsc_files_id_seq TO PUBLIC;
5149 GRANT ALL ON SEQUENCE dsc_files_id_seq TO ftpmaster;
5153 -- Name: dsc_files; Type: ACL; Schema: public; Owner: dak
5156 REVOKE ALL ON TABLE dsc_files FROM PUBLIC;
5157 REVOKE ALL ON TABLE dsc_files FROM dak;
5158 GRANT ALL ON TABLE dsc_files TO dak;
5159 GRANT SELECT ON TABLE dsc_files TO PUBLIC;
5160 GRANT ALL ON TABLE dsc_files TO ftpmaster;
5164 -- Name: external_overrides; Type: ACL; Schema: public; Owner: dak
5167 REVOKE ALL ON TABLE external_overrides FROM PUBLIC;
5168 REVOKE ALL ON TABLE external_overrides FROM dak;
5169 GRANT ALL ON TABLE external_overrides TO dak;
5170 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE external_overrides TO ftpmaster;
5171 GRANT SELECT ON TABLE external_overrides TO PUBLIC;
5175 -- Name: extra_src_references; Type: ACL; Schema: public; Owner: dak
5178 REVOKE ALL ON TABLE extra_src_references FROM PUBLIC;
5179 REVOKE ALL ON TABLE extra_src_references FROM dak;
5180 GRANT ALL ON TABLE extra_src_references TO dak;
5181 GRANT SELECT,INSERT,UPDATE ON TABLE extra_src_references TO ftpmaster;
5182 GRANT SELECT ON TABLE extra_src_references TO PUBLIC;
5186 -- Name: file_arch_suite; Type: ACL; Schema: public; Owner: dak
5189 REVOKE ALL ON TABLE file_arch_suite FROM PUBLIC;
5190 REVOKE ALL ON TABLE file_arch_suite FROM dak;
5191 GRANT ALL ON TABLE file_arch_suite TO dak;
5192 GRANT ALL ON TABLE file_arch_suite TO ftpmaster;
5193 GRANT SELECT ON TABLE file_arch_suite TO PUBLIC;
5197 -- Name: fingerprint_id_seq; Type: ACL; Schema: public; Owner: dak
5200 REVOKE ALL ON SEQUENCE fingerprint_id_seq FROM PUBLIC;
5201 REVOKE ALL ON SEQUENCE fingerprint_id_seq FROM dak;
5202 GRANT ALL ON SEQUENCE fingerprint_id_seq TO dak;
5203 GRANT SELECT ON SEQUENCE fingerprint_id_seq TO PUBLIC;
5204 GRANT ALL ON SEQUENCE fingerprint_id_seq TO ftpmaster;
5208 -- Name: fingerprint; Type: ACL; Schema: public; Owner: dak
5211 REVOKE ALL ON TABLE fingerprint FROM PUBLIC;
5212 REVOKE ALL ON TABLE fingerprint FROM dak;
5213 GRANT ALL ON TABLE fingerprint TO dak;
5214 GRANT SELECT ON TABLE fingerprint TO PUBLIC;
5215 GRANT ALL ON TABLE fingerprint TO ftpmaster;
5219 -- Name: keyring_acl_map; Type: ACL; Schema: public; Owner: dak
5222 REVOKE ALL ON TABLE keyring_acl_map FROM PUBLIC;
5223 REVOKE ALL ON TABLE keyring_acl_map FROM dak;
5224 GRANT ALL ON TABLE keyring_acl_map TO dak;
5225 GRANT SELECT ON TABLE keyring_acl_map TO PUBLIC;
5226 GRANT ALL ON TABLE keyring_acl_map TO ftpmaster;
5230 -- Name: keyring_acl_map_id_seq; Type: ACL; Schema: public; Owner: dak
5233 REVOKE ALL ON SEQUENCE keyring_acl_map_id_seq FROM PUBLIC;
5234 REVOKE ALL ON SEQUENCE keyring_acl_map_id_seq FROM dak;
5235 GRANT ALL ON SEQUENCE keyring_acl_map_id_seq TO dak;
5236 GRANT ALL ON SEQUENCE keyring_acl_map_id_seq TO ftpmaster;
5237 GRANT SELECT ON SEQUENCE keyring_acl_map_id_seq TO PUBLIC;
5241 -- Name: keyrings; Type: ACL; Schema: public; Owner: dak
5244 REVOKE ALL ON TABLE keyrings FROM PUBLIC;
5245 REVOKE ALL ON TABLE keyrings FROM dak;
5246 GRANT ALL ON TABLE keyrings TO dak;
5247 GRANT SELECT ON TABLE keyrings TO PUBLIC;
5248 GRANT ALL ON TABLE keyrings TO ftpmaster;
5252 -- Name: keyrings_id_seq; Type: ACL; Schema: public; Owner: dak
5255 REVOKE ALL ON SEQUENCE keyrings_id_seq FROM PUBLIC;
5256 REVOKE ALL ON SEQUENCE keyrings_id_seq FROM dak;
5257 GRANT ALL ON SEQUENCE keyrings_id_seq TO dak;
5258 GRANT SELECT ON SEQUENCE keyrings_id_seq TO PUBLIC;
5259 GRANT ALL ON SEQUENCE keyrings_id_seq TO ftpmaster;
5263 -- Name: maintainer_id_seq; Type: ACL; Schema: public; Owner: dak
5266 REVOKE ALL ON SEQUENCE maintainer_id_seq FROM PUBLIC;
5267 REVOKE ALL ON SEQUENCE maintainer_id_seq FROM dak;
5268 GRANT ALL ON SEQUENCE maintainer_id_seq TO dak;
5269 GRANT SELECT ON SEQUENCE maintainer_id_seq TO PUBLIC;
5270 GRANT ALL ON SEQUENCE maintainer_id_seq TO ftpmaster;
5274 -- Name: maintainer; Type: ACL; Schema: public; Owner: dak
5277 REVOKE ALL ON TABLE maintainer FROM PUBLIC;
5278 REVOKE ALL ON TABLE maintainer FROM dak;
5279 GRANT ALL ON TABLE maintainer TO dak;
5280 GRANT SELECT ON TABLE maintainer TO PUBLIC;
5281 GRANT ALL ON TABLE maintainer TO ftpmaster;
5285 -- Name: metadata_keys; Type: ACL; Schema: public; Owner: dak
5288 REVOKE ALL ON TABLE metadata_keys FROM PUBLIC;
5289 REVOKE ALL ON TABLE metadata_keys FROM dak;
5290 GRANT ALL ON TABLE metadata_keys TO dak;
5291 GRANT SELECT,INSERT,UPDATE ON TABLE metadata_keys TO ftpmaster;
5292 GRANT SELECT ON TABLE metadata_keys TO PUBLIC;
5296 -- Name: metadata_keys_key_id_seq; Type: ACL; Schema: public; Owner: dak
5299 REVOKE ALL ON SEQUENCE metadata_keys_key_id_seq FROM PUBLIC;
5300 REVOKE ALL ON SEQUENCE metadata_keys_key_id_seq FROM dak;
5301 GRANT ALL ON SEQUENCE metadata_keys_key_id_seq TO dak;
5302 GRANT ALL ON SEQUENCE metadata_keys_key_id_seq TO ftpmaster;
5303 GRANT SELECT ON SEQUENCE metadata_keys_key_id_seq TO PUBLIC;
5307 -- Name: new_comments; Type: ACL; Schema: public; Owner: dak
5310 REVOKE ALL ON TABLE new_comments FROM PUBLIC;
5311 REVOKE ALL ON TABLE new_comments FROM dak;
5312 GRANT ALL ON TABLE new_comments TO dak;
5313 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE new_comments TO ftptrainee;
5314 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE new_comments TO ftpteam;
5315 GRANT ALL ON TABLE new_comments TO ftpmaster;
5319 -- Name: new_comments_id_seq; Type: ACL; Schema: public; Owner: dak
5322 REVOKE ALL ON SEQUENCE new_comments_id_seq FROM PUBLIC;
5323 REVOKE ALL ON SEQUENCE new_comments_id_seq FROM dak;
5324 GRANT ALL ON SEQUENCE new_comments_id_seq TO dak;
5325 GRANT SELECT,UPDATE ON SEQUENCE new_comments_id_seq TO ftptrainee;
5326 GRANT SELECT,UPDATE ON SEQUENCE new_comments_id_seq TO ftpteam;
5327 GRANT ALL ON SEQUENCE new_comments_id_seq TO ftpmaster;
5328 GRANT SELECT ON SEQUENCE new_comments_id_seq TO PUBLIC;
5332 -- Name: newest_all_associations; Type: ACL; Schema: public; Owner: dak
5335 REVOKE ALL ON TABLE newest_all_associations FROM PUBLIC;
5336 REVOKE ALL ON TABLE newest_all_associations FROM dak;
5337 GRANT ALL ON TABLE newest_all_associations TO dak;
5338 GRANT SELECT ON TABLE newest_all_associations TO ftpmaster;
5339 GRANT SELECT ON TABLE newest_all_associations TO PUBLIC;
5343 -- Name: newest_any_associations; Type: ACL; Schema: public; Owner: dak
5346 REVOKE ALL ON TABLE newest_any_associations FROM PUBLIC;
5347 REVOKE ALL ON TABLE newest_any_associations FROM dak;
5348 GRANT ALL ON TABLE newest_any_associations TO dak;
5349 GRANT SELECT ON TABLE newest_any_associations TO ftpmaster;
5350 GRANT SELECT ON TABLE newest_any_associations TO PUBLIC;
5354 -- Name: source_suite; Type: ACL; Schema: public; Owner: dak
5357 REVOKE ALL ON TABLE source_suite FROM PUBLIC;
5358 REVOKE ALL ON TABLE source_suite FROM dak;
5359 GRANT ALL ON TABLE source_suite TO dak;
5360 GRANT SELECT ON TABLE source_suite TO ftpmaster;
5361 GRANT SELECT ON TABLE source_suite TO PUBLIC;
5365 -- Name: newest_source; Type: ACL; Schema: public; Owner: dak
5368 REVOKE ALL ON TABLE newest_source FROM PUBLIC;
5369 REVOKE ALL ON TABLE newest_source FROM dak;
5370 GRANT ALL ON TABLE newest_source TO dak;
5371 GRANT SELECT ON TABLE newest_source TO ftpmaster;
5372 GRANT SELECT ON TABLE newest_source TO PUBLIC;
5376 -- Name: newest_src_association; Type: ACL; Schema: public; Owner: dak
5379 REVOKE ALL ON TABLE newest_src_association FROM PUBLIC;
5380 REVOKE ALL ON TABLE newest_src_association FROM dak;
5381 GRANT ALL ON TABLE newest_src_association TO dak;
5382 GRANT SELECT ON TABLE newest_src_association TO ftpmaster;
5383 GRANT SELECT ON TABLE newest_src_association TO PUBLIC;
5387 -- Name: obsolete_all_associations; Type: ACL; Schema: public; Owner: dak
5390 REVOKE ALL ON TABLE obsolete_all_associations FROM PUBLIC;
5391 REVOKE ALL ON TABLE obsolete_all_associations FROM dak;
5392 GRANT ALL ON TABLE obsolete_all_associations TO dak;
5393 GRANT SELECT ON TABLE obsolete_all_associations TO ftpmaster;
5394 GRANT SELECT ON TABLE obsolete_all_associations TO PUBLIC;
5398 -- Name: obsolete_any_associations; Type: ACL; Schema: public; Owner: dak
5401 REVOKE ALL ON TABLE obsolete_any_associations FROM PUBLIC;
5402 REVOKE ALL ON TABLE obsolete_any_associations FROM dak;
5403 GRANT ALL ON TABLE obsolete_any_associations TO dak;
5404 GRANT SELECT ON TABLE obsolete_any_associations TO ftpmaster;
5405 GRANT SELECT ON TABLE obsolete_any_associations TO PUBLIC;
5409 -- Name: obsolete_any_by_all_associations; Type: ACL; Schema: public; Owner: dak
5412 REVOKE ALL ON TABLE obsolete_any_by_all_associations FROM PUBLIC;
5413 REVOKE ALL ON TABLE obsolete_any_by_all_associations FROM dak;
5414 GRANT ALL ON TABLE obsolete_any_by_all_associations TO dak;
5415 GRANT SELECT ON TABLE obsolete_any_by_all_associations TO ftpmaster;
5416 GRANT SELECT ON TABLE obsolete_any_by_all_associations TO PUBLIC;
5420 -- Name: obsolete_src_associations; Type: ACL; Schema: public; Owner: dak
5423 REVOKE ALL ON TABLE obsolete_src_associations FROM PUBLIC;
5424 REVOKE ALL ON TABLE obsolete_src_associations FROM dak;
5425 GRANT ALL ON TABLE obsolete_src_associations TO dak;
5426 GRANT SELECT ON TABLE obsolete_src_associations TO ftpmaster;
5427 GRANT SELECT ON TABLE obsolete_src_associations TO PUBLIC;
5431 -- Name: override; Type: ACL; Schema: public; Owner: dak
5434 REVOKE ALL ON TABLE override FROM PUBLIC;
5435 REVOKE ALL ON TABLE override FROM dak;
5436 GRANT ALL ON TABLE override TO dak;
5437 GRANT SELECT ON TABLE override TO PUBLIC;
5438 GRANT ALL ON TABLE override TO ftpmaster;
5439 GRANT INSERT,DELETE,UPDATE ON TABLE override TO ftpteam;
5443 -- Name: override_type_id_seq; Type: ACL; Schema: public; Owner: dak
5446 REVOKE ALL ON SEQUENCE override_type_id_seq FROM PUBLIC;
5447 REVOKE ALL ON SEQUENCE override_type_id_seq FROM dak;
5448 GRANT ALL ON SEQUENCE override_type_id_seq TO dak;
5449 GRANT SELECT ON SEQUENCE override_type_id_seq TO PUBLIC;
5450 GRANT ALL ON SEQUENCE override_type_id_seq TO ftpmaster;
5454 -- Name: override_type; Type: ACL; Schema: public; Owner: dak
5457 REVOKE ALL ON TABLE override_type FROM PUBLIC;
5458 REVOKE ALL ON TABLE override_type FROM dak;
5459 GRANT ALL ON TABLE override_type TO dak;
5460 GRANT SELECT ON TABLE override_type TO PUBLIC;
5461 GRANT ALL ON TABLE override_type TO ftpmaster;
5465 -- Name: policy_queue; Type: ACL; Schema: public; Owner: dak
5468 REVOKE ALL ON TABLE policy_queue FROM PUBLIC;
5469 REVOKE ALL ON TABLE policy_queue FROM dak;
5470 GRANT ALL ON TABLE policy_queue TO dak;
5471 GRANT SELECT ON TABLE policy_queue TO PUBLIC;
5472 GRANT ALL ON TABLE policy_queue TO ftpmaster;
5476 -- Name: policy_queue_id_seq; Type: ACL; Schema: public; Owner: dak
5479 REVOKE ALL ON SEQUENCE policy_queue_id_seq FROM PUBLIC;
5480 REVOKE ALL ON SEQUENCE policy_queue_id_seq FROM dak;
5481 GRANT ALL ON SEQUENCE policy_queue_id_seq TO dak;
5482 GRANT ALL ON SEQUENCE policy_queue_id_seq TO ftpmaster;
5483 GRANT SELECT ON SEQUENCE policy_queue_id_seq TO PUBLIC;
5487 -- Name: priority_id_seq; Type: ACL; Schema: public; Owner: dak
5490 REVOKE ALL ON SEQUENCE priority_id_seq FROM PUBLIC;
5491 REVOKE ALL ON SEQUENCE priority_id_seq FROM dak;
5492 GRANT ALL ON SEQUENCE priority_id_seq TO dak;
5493 GRANT SELECT ON SEQUENCE priority_id_seq TO PUBLIC;
5494 GRANT ALL ON SEQUENCE priority_id_seq TO ftpmaster;
5498 -- Name: priority; Type: ACL; Schema: public; Owner: dak
5501 REVOKE ALL ON TABLE priority FROM PUBLIC;
5502 REVOKE ALL ON TABLE priority FROM dak;
5503 GRANT ALL ON TABLE priority TO dak;
5504 GRANT SELECT ON TABLE priority TO PUBLIC;
5505 GRANT ALL ON TABLE priority TO ftpmaster;
5509 -- Name: section_id_seq; Type: ACL; Schema: public; Owner: dak
5512 REVOKE ALL ON SEQUENCE section_id_seq FROM PUBLIC;
5513 REVOKE ALL ON SEQUENCE section_id_seq FROM dak;
5514 GRANT ALL ON SEQUENCE section_id_seq TO dak;
5515 GRANT SELECT ON SEQUENCE section_id_seq TO PUBLIC;
5516 GRANT ALL ON SEQUENCE section_id_seq TO ftpmaster;
5520 -- Name: section; Type: ACL; Schema: public; Owner: dak
5523 REVOKE ALL ON TABLE section FROM PUBLIC;
5524 REVOKE ALL ON TABLE section FROM dak;
5525 GRANT ALL ON TABLE section TO dak;
5526 GRANT SELECT ON TABLE section TO PUBLIC;
5527 GRANT ALL ON TABLE section TO ftpmaster;
5531 -- Name: source_acl; Type: ACL; Schema: public; Owner: dak
5534 REVOKE ALL ON TABLE source_acl FROM PUBLIC;
5535 REVOKE ALL ON TABLE source_acl FROM dak;
5536 GRANT ALL ON TABLE source_acl TO dak;
5537 GRANT SELECT ON TABLE source_acl TO PUBLIC;
5538 GRANT ALL ON TABLE source_acl TO ftpmaster;
5542 -- Name: source_acl_id_seq; Type: ACL; Schema: public; Owner: dak
5545 REVOKE ALL ON SEQUENCE source_acl_id_seq FROM PUBLIC;
5546 REVOKE ALL ON SEQUENCE source_acl_id_seq FROM dak;
5547 GRANT ALL ON SEQUENCE source_acl_id_seq TO dak;
5548 GRANT ALL ON SEQUENCE source_acl_id_seq TO ftpmaster;
5549 GRANT SELECT ON SEQUENCE source_acl_id_seq TO PUBLIC;
5553 -- Name: source_metadata; Type: ACL; Schema: public; Owner: dak
5556 REVOKE ALL ON TABLE source_metadata FROM PUBLIC;
5557 REVOKE ALL ON TABLE source_metadata FROM dak;
5558 GRANT ALL ON TABLE source_metadata TO dak;
5559 GRANT SELECT,INSERT,UPDATE ON TABLE source_metadata TO ftpmaster;
5560 GRANT SELECT ON TABLE source_metadata TO PUBLIC;
5564 -- Name: src_contents; Type: ACL; Schema: public; Owner: dak
5567 REVOKE ALL ON TABLE src_contents FROM PUBLIC;
5568 REVOKE ALL ON TABLE src_contents FROM dak;
5569 GRANT ALL ON TABLE src_contents TO dak;
5570 GRANT SELECT,INSERT,UPDATE ON TABLE src_contents TO ftpmaster;
5571 GRANT SELECT ON TABLE src_contents TO PUBLIC;
5575 -- Name: src_format; Type: ACL; Schema: public; Owner: dak
5578 REVOKE ALL ON TABLE src_format FROM PUBLIC;
5579 REVOKE ALL ON TABLE src_format FROM dak;
5580 GRANT ALL ON TABLE src_format TO dak;
5581 GRANT SELECT ON TABLE src_format TO PUBLIC;
5582 GRANT ALL ON TABLE src_format TO ftpmaster;
5586 -- Name: src_format_id_seq; Type: ACL; Schema: public; Owner: dak
5589 REVOKE ALL ON SEQUENCE src_format_id_seq FROM PUBLIC;
5590 REVOKE ALL ON SEQUENCE src_format_id_seq FROM dak;
5591 GRANT ALL ON SEQUENCE src_format_id_seq TO dak;
5592 GRANT ALL ON SEQUENCE src_format_id_seq TO ftpmaster;
5593 GRANT SELECT ON SEQUENCE src_format_id_seq TO PUBLIC;
5597 -- Name: src_uploaders; Type: ACL; Schema: public; Owner: dak
5600 REVOKE ALL ON TABLE src_uploaders FROM PUBLIC;
5601 REVOKE ALL ON TABLE src_uploaders FROM dak;
5602 GRANT ALL ON TABLE src_uploaders TO dak;
5603 GRANT SELECT ON TABLE src_uploaders TO PUBLIC;
5604 GRANT ALL ON TABLE src_uploaders TO ftpmaster;
5608 -- Name: src_uploaders_id_seq; Type: ACL; Schema: public; Owner: dak
5611 REVOKE ALL ON SEQUENCE src_uploaders_id_seq FROM PUBLIC;
5612 REVOKE ALL ON SEQUENCE src_uploaders_id_seq FROM dak;
5613 GRANT ALL ON SEQUENCE src_uploaders_id_seq TO dak;
5614 GRANT SELECT ON SEQUENCE src_uploaders_id_seq TO PUBLIC;
5615 GRANT ALL ON SEQUENCE src_uploaders_id_seq TO ftpmaster;
5619 -- Name: suite_architectures; Type: ACL; Schema: public; Owner: dak
5622 REVOKE ALL ON TABLE suite_architectures FROM PUBLIC;
5623 REVOKE ALL ON TABLE suite_architectures FROM dak;
5624 GRANT ALL ON TABLE suite_architectures TO dak;
5625 GRANT SELECT ON TABLE suite_architectures TO PUBLIC;
5626 GRANT ALL ON TABLE suite_architectures TO ftpmaster;
5630 -- Name: suite_arch_by_name; Type: ACL; Schema: public; Owner: dak
5633 REVOKE ALL ON TABLE suite_arch_by_name FROM PUBLIC;
5634 REVOKE ALL ON TABLE suite_arch_by_name FROM dak;
5635 GRANT ALL ON TABLE suite_arch_by_name TO dak;
5636 GRANT SELECT ON TABLE suite_arch_by_name TO PUBLIC;
5637 GRANT SELECT ON TABLE suite_arch_by_name TO ftpmaster;
5641 -- Name: suite_build_queue_copy; Type: ACL; Schema: public; Owner: dak
5644 REVOKE ALL ON TABLE suite_build_queue_copy FROM PUBLIC;
5645 REVOKE ALL ON TABLE suite_build_queue_copy FROM dak;
5646 GRANT ALL ON TABLE suite_build_queue_copy TO dak;
5647 GRANT SELECT ON TABLE suite_build_queue_copy TO PUBLIC;
5648 GRANT ALL ON TABLE suite_build_queue_copy TO ftpmaster;
5652 -- Name: suite_src_formats; Type: ACL; Schema: public; Owner: dak
5655 REVOKE ALL ON TABLE suite_src_formats FROM PUBLIC;
5656 REVOKE ALL ON TABLE suite_src_formats FROM dak;
5657 GRANT ALL ON TABLE suite_src_formats TO dak;
5658 GRANT SELECT ON TABLE suite_src_formats TO PUBLIC;
5659 GRANT ALL ON TABLE suite_src_formats TO ftpmaster;
5663 -- Name: uid_id_seq; Type: ACL; Schema: public; Owner: dak
5666 REVOKE ALL ON SEQUENCE uid_id_seq FROM PUBLIC;
5667 REVOKE ALL ON SEQUENCE uid_id_seq FROM dak;
5668 GRANT ALL ON SEQUENCE uid_id_seq TO dak;
5669 GRANT SELECT ON SEQUENCE uid_id_seq TO PUBLIC;
5670 GRANT ALL ON SEQUENCE uid_id_seq TO ftpmaster;
5674 -- Name: uid; Type: ACL; Schema: public; Owner: dak
5677 REVOKE ALL ON TABLE uid FROM PUBLIC;
5678 REVOKE ALL ON TABLE uid FROM dak;
5679 GRANT ALL ON TABLE uid TO dak;
5680 GRANT SELECT ON TABLE uid TO PUBLIC;
5681 GRANT ALL ON TABLE uid TO ftpmaster;
5685 -- Name: upload_blocks; Type: ACL; Schema: public; Owner: dak
5688 REVOKE ALL ON TABLE upload_blocks FROM PUBLIC;
5689 REVOKE ALL ON TABLE upload_blocks FROM dak;
5690 GRANT ALL ON TABLE upload_blocks TO dak;
5691 GRANT SELECT ON TABLE upload_blocks TO PUBLIC;
5692 GRANT ALL ON TABLE upload_blocks TO ftpmaster;
5696 -- Name: upload_blocks_id_seq; Type: ACL; Schema: public; Owner: dak
5699 REVOKE ALL ON SEQUENCE upload_blocks_id_seq FROM PUBLIC;
5700 REVOKE ALL ON SEQUENCE upload_blocks_id_seq FROM dak;
5701 GRANT ALL ON SEQUENCE upload_blocks_id_seq TO dak;
5702 GRANT ALL ON SEQUENCE upload_blocks_id_seq TO ftpmaster;
5703 GRANT SELECT ON SEQUENCE upload_blocks_id_seq TO PUBLIC;
5707 -- Name: version_check; Type: ACL; Schema: public; Owner: dak
5710 REVOKE ALL ON TABLE version_check FROM PUBLIC;
5711 REVOKE ALL ON TABLE version_check FROM dak;
5712 GRANT ALL ON TABLE version_check TO dak;
5713 GRANT SELECT,INSERT,UPDATE ON TABLE version_check TO ftpmaster;
5714 GRANT SELECT ON TABLE version_check TO PUBLIC;
5718 -- Name: version_checks; Type: ACL; Schema: public; Owner: dak
5721 REVOKE ALL ON TABLE version_checks FROM PUBLIC;
5722 REVOKE ALL ON TABLE version_checks FROM dak;
5723 GRANT ALL ON TABLE version_checks TO dak;
5724 GRANT SELECT ON TABLE version_checks TO PUBLIC;
5728 -- PostgreSQL database dump complete
5731 -- Set schema version
5732 INSERT INTO config (name, value) VALUES ('db_revision', 68);