2 -- PostgreSQL database dump
5 SET statement_timeout
= 0;
7 SET client_encoding
= 'UTF8';
8 SET standard_conforming_strings
= on;
9 SET check_function_bodies
= false;
10 SET client_min_messages
= warning
;
13 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
16 CREATE EXTENSION
IF NOT EXISTS plpgsql
WITH SCHEMA pg_catalog
;
20 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
23 COMMENT ON EXTENSION plpgsql
IS 'PL/pgSQL procedural language';
26 SET search_path
= public, pg_catalog
;
29 -- Name: arches_binary; Type: TYPE; Schema: public; Owner: pakfire
32 CREATE TYPE arches_binary
AS ENUM (
38 ALTER TYPE arches_binary
OWNER TO pakfire
;
41 -- Name: builders_arches_enabled; Type: TYPE; Schema: public; Owner: pakfire
44 CREATE TYPE builders_arches_enabled
AS ENUM (
50 ALTER TYPE builders_arches_enabled
OWNER TO pakfire
;
53 -- Name: builders_build_release; Type: TYPE; Schema: public; Owner: pakfire
56 CREATE TYPE builders_build_release
AS ENUM (
62 ALTER TYPE builders_build_release
OWNER TO pakfire
;
65 -- Name: builders_build_scratch; Type: TYPE; Schema: public; Owner: pakfire
68 CREATE TYPE builders_build_scratch
AS ENUM (
74 ALTER TYPE builders_build_scratch
OWNER TO pakfire
;
77 -- Name: builders_build_test; Type: TYPE; Schema: public; Owner: pakfire
80 CREATE TYPE builders_build_test
AS ENUM (
86 ALTER TYPE builders_build_test
OWNER TO pakfire
;
89 -- Name: builders_deleted; Type: TYPE; Schema: public; Owner: pakfire
92 CREATE TYPE builders_deleted
AS ENUM (
98 ALTER TYPE builders_deleted
OWNER TO pakfire
;
101 -- Name: builders_disabled; Type: TYPE; Schema: public; Owner: pakfire
104 CREATE TYPE builders_disabled
AS ENUM (
110 ALTER TYPE builders_disabled
OWNER TO pakfire
;
113 -- Name: builders_history_action; Type: TYPE; Schema: public; Owner: pakfire
116 CREATE TYPE builders_history_action
AS ENUM (
124 ALTER TYPE builders_history_action
OWNER TO pakfire
;
127 -- Name: builders_overload; Type: TYPE; Schema: public; Owner: pakfire
130 CREATE TYPE builders_overload
AS ENUM (
136 ALTER TYPE builders_overload
OWNER TO pakfire
;
139 -- Name: builders_status; Type: TYPE; Schema: public; Owner: pakfire
142 CREATE TYPE builders_status
AS ENUM (
149 ALTER TYPE builders_status
OWNER TO pakfire
;
152 -- Name: builds_auto_move; Type: TYPE; Schema: public; Owner: pakfire
155 CREATE TYPE builds_auto_move
AS ENUM (
161 ALTER TYPE builds_auto_move
OWNER TO pakfire
;
164 -- Name: builds_bugs_updates_error; Type: TYPE; Schema: public; Owner: pakfire
167 CREATE TYPE builds_bugs_updates_error
AS ENUM (
173 ALTER TYPE builds_bugs_updates_error
OWNER TO pakfire
;
176 -- Name: builds_history_action; Type: TYPE; Schema: public; Owner: pakfire
179 CREATE TYPE builds_history_action
AS ENUM (
186 ALTER TYPE builds_history_action
OWNER TO pakfire
;
189 -- Name: builds_public; Type: TYPE; Schema: public; Owner: pakfire
192 CREATE TYPE builds_public
AS ENUM (
198 ALTER TYPE builds_public
OWNER TO pakfire
;
201 -- Name: builds_severity; Type: TYPE; Schema: public; Owner: pakfire
204 CREATE TYPE builds_severity
AS ENUM (
212 ALTER TYPE builds_severity
OWNER TO pakfire
;
215 -- Name: builds_state; Type: TYPE; Schema: public; Owner: pakfire
218 CREATE TYPE builds_state
AS ENUM (
227 ALTER TYPE builds_state
OWNER TO pakfire
;
230 -- Name: builds_type; Type: TYPE; Schema: public; Owner: pakfire
233 CREATE TYPE builds_type
AS ENUM (
239 ALTER TYPE builds_type
OWNER TO pakfire
;
242 -- Name: filelists_config; Type: TYPE; Schema: public; Owner: pakfire
245 CREATE TYPE filelists_config
AS ENUM (
251 ALTER TYPE filelists_config
OWNER TO pakfire
;
254 -- Name: jobs_history_action; Type: TYPE; Schema: public; Owner: pakfire
257 CREATE TYPE jobs_history_action
AS ENUM (
266 ALTER TYPE jobs_history_action
OWNER TO pakfire
;
269 -- Name: jobs_history_state; Type: TYPE; Schema: public; Owner: pakfire
272 CREATE TYPE jobs_history_state
AS ENUM (
288 ALTER TYPE jobs_history_state
OWNER TO pakfire
;
291 -- Name: jobs_state; Type: TYPE; Schema: public; Owner: pakfire
294 CREATE TYPE jobs_state
AS ENUM (
310 ALTER TYPE jobs_state
OWNER TO pakfire
;
313 -- Name: jobs_type; Type: TYPE; Schema: public; Owner: pakfire
316 CREATE TYPE jobs_type
AS ENUM (
322 ALTER TYPE jobs_type
OWNER TO pakfire
;
325 -- Name: mirrors_check_status; Type: TYPE; Schema: public; Owner: pakfire
328 CREATE TYPE mirrors_check_status
AS ENUM (
335 ALTER TYPE mirrors_check_status
OWNER TO pakfire
;
338 -- Name: mirrors_history_action; Type: TYPE; Schema: public; Owner: pakfire
341 CREATE TYPE mirrors_history_action
AS ENUM (
349 ALTER TYPE mirrors_history_action
OWNER TO pakfire
;
352 -- Name: mirrors_status; Type: TYPE; Schema: public; Owner: pakfire
355 CREATE TYPE mirrors_status
AS ENUM (
362 ALTER TYPE mirrors_status
OWNER TO pakfire
;
365 -- Name: packages_deps_type; Type: TYPE; Schema: public; Owner: pakfire
368 CREATE TYPE packages_deps_type
AS ENUM (
379 ALTER TYPE packages_deps_type
OWNER TO pakfire
;
382 -- Name: packages_properties_critical_path; Type: TYPE; Schema: public; Owner: pakfire
385 CREATE TYPE packages_properties_critical_path
AS ENUM (
391 ALTER TYPE packages_properties_critical_path
OWNER TO pakfire
;
394 -- Name: packages_type; Type: TYPE; Schema: public; Owner: pakfire
397 CREATE TYPE packages_type
AS ENUM (
403 ALTER TYPE packages_type
OWNER TO pakfire
;
406 -- Name: repositories_aux_status; Type: TYPE; Schema: public; Owner: pakfire
409 CREATE TYPE repositories_aux_status
AS ENUM (
415 ALTER TYPE repositories_aux_status
OWNER TO pakfire
;
418 -- Name: repositories_enabled_for_builds; Type: TYPE; Schema: public; Owner: pakfire
421 CREATE TYPE repositories_enabled_for_builds
AS ENUM (
427 ALTER TYPE repositories_enabled_for_builds
OWNER TO pakfire
;
430 -- Name: repositories_history_action; Type: TYPE; Schema: public; Owner: pakfire
433 CREATE TYPE repositories_history_action
AS ENUM (
440 ALTER TYPE repositories_history_action
OWNER TO pakfire
;
443 -- Name: repositories_mirrored; Type: TYPE; Schema: public; Owner: pakfire
446 CREATE TYPE repositories_mirrored
AS ENUM (
452 ALTER TYPE repositories_mirrored
OWNER TO pakfire
;
455 -- Name: repositories_type; Type: TYPE; Schema: public; Owner: pakfire
458 CREATE TYPE repositories_type
AS ENUM (
465 ALTER TYPE repositories_type
OWNER TO pakfire
;
468 -- Name: sources_commits_state; Type: TYPE; Schema: public; Owner: pakfire
471 CREATE TYPE sources_commits_state
AS ENUM (
479 ALTER TYPE sources_commits_state
OWNER TO pakfire
;
482 -- Name: uploads_finished; Type: TYPE; Schema: public; Owner: pakfire
485 CREATE TYPE uploads_finished
AS ENUM (
491 ALTER TYPE uploads_finished
OWNER TO pakfire
;
494 -- Name: users_activated; Type: TYPE; Schema: public; Owner: pakfire
497 CREATE TYPE users_activated
AS ENUM (
503 ALTER TYPE users_activated
OWNER TO pakfire
;
506 -- Name: users_deleted; Type: TYPE; Schema: public; Owner: pakfire
509 CREATE TYPE users_deleted
AS ENUM (
515 ALTER TYPE users_deleted
OWNER TO pakfire
;
518 -- Name: users_emails_primary; Type: TYPE; Schema: public; Owner: pakfire
521 CREATE TYPE users_emails_primary
AS ENUM (
527 ALTER TYPE users_emails_primary
OWNER TO pakfire
;
530 -- Name: users_permissions_create_scratch_builds; Type: TYPE; Schema: public; Owner: pakfire
533 CREATE TYPE users_permissions_create_scratch_builds
AS ENUM (
539 ALTER TYPE users_permissions_create_scratch_builds
OWNER TO pakfire
;
542 -- Name: users_permissions_maintain_builders; Type: TYPE; Schema: public; Owner: pakfire
545 CREATE TYPE users_permissions_maintain_builders
AS ENUM (
551 ALTER TYPE users_permissions_maintain_builders
OWNER TO pakfire
;
554 -- Name: users_permissions_manage_critical_path; Type: TYPE; Schema: public; Owner: pakfire
557 CREATE TYPE users_permissions_manage_critical_path
AS ENUM (
563 ALTER TYPE users_permissions_manage_critical_path
OWNER TO pakfire
;
566 -- Name: users_permissions_manage_mirrors; Type: TYPE; Schema: public; Owner: pakfire
569 CREATE TYPE users_permissions_manage_mirrors
AS ENUM (
575 ALTER TYPE users_permissions_manage_mirrors
OWNER TO pakfire
;
578 -- Name: users_permissions_vote; Type: TYPE; Schema: public; Owner: pakfire
581 CREATE TYPE users_permissions_vote
AS ENUM (
587 ALTER TYPE users_permissions_vote
OWNER TO pakfire
;
590 -- Name: users_state; Type: TYPE; Schema: public; Owner: pakfire
593 CREATE TYPE users_state
AS ENUM (
600 ALTER TYPE users_state
OWNER TO pakfire
;
603 -- Name: on_update_current_timestamp_sources(); Type: FUNCTION; Schema: public; Owner: pakfire
606 CREATE FUNCTION on_update_current_timestamp_sources() RETURNS trigger
616 ALTER FUNCTION public.
on_update_current_timestamp_sources() OWNER TO pakfire
;
618 SET default_tablespace
= '';
620 SET default_with_oids
= false;
623 -- Name: arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
626 CREATE TABLE arches (
629 prio
integer DEFAULT 0 NOT NULL,
630 "binary" arches_binary
DEFAULT 'Y'::arches_binary NOT NULL,
635 ALTER TABLE arches
OWNER TO pakfire
;
638 -- Name: arches_compat; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
641 CREATE TABLE arches_compat (
642 host_arch
text NOT NULL,
643 build_arch
text NOT NULL
647 ALTER TABLE arches_compat
OWNER TO pakfire
;
650 -- Name: builders; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
653 CREATE TABLE builders (
658 status builders_status
DEFAULT 'disabled'::builders_status NOT NULL,
659 disabled builders_disabled
DEFAULT 'Y'::builders_disabled NOT NULL,
660 loadavg
text DEFAULT '0'::character varying NOT NULL,
662 build_release builders_build_release
DEFAULT 'N'::builders_build_release NOT NULL,
663 build_scratch builders_build_scratch
DEFAULT 'N'::builders_build_scratch NOT NULL,
664 build_test builders_build_test
DEFAULT 'N'::builders_build_test NOT NULL,
665 max_jobs
bigint DEFAULT 1::bigint NOT NULL,
666 pakfire_version
text,
669 cpu_count
integer DEFAULT 1 NOT NULL,
671 cpu_bogomips
double precision,
672 memory
bigint DEFAULT 0 NOT NULL,
673 overload builders_overload
DEFAULT 'N'::builders_overload NOT NULL,
674 free_space
bigint DEFAULT 0 NOT NULL,
676 deleted builders_deleted
DEFAULT 'N'::builders_deleted NOT NULL,
677 time_created
timestamp without time zone NOT NULL,
678 time_updated
timestamp without time zone,
679 time_keepalive
timestamp without time zone,
680 loadavg1
double precision,
681 loadavg5
double precision,
682 loadavg15
double precision,
691 ALTER TABLE builders
OWNER TO pakfire
;
694 -- Name: arches_builders; Type: VIEW; Schema: public; Owner: pakfire
697 CREATE VIEW arches_builders
AS
698 SELECT arches_compat.build_arch
AS arch
,
699 builders.
id AS builder_id
701 LEFT JOIN builders
ON ((arches_compat.host_arch
= builders.cpu_arch
)));
704 ALTER TABLE arches_builders
OWNER TO pakfire
;
707 -- Name: arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
710 CREATE SEQUENCE arches_id_seq
718 ALTER TABLE arches_id_seq
OWNER TO pakfire
;
721 -- Name: arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
724 ALTER SEQUENCE arches_id_seq
OWNED BY arches.
id;
728 -- Name: builders_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
731 CREATE TABLE builders_arches (
733 builder_id
integer NOT NULL,
734 arch_id
integer NOT NULL,
735 enabled builders_arches_enabled
DEFAULT 'Y'::builders_arches_enabled NOT NULL
739 ALTER TABLE builders_arches
OWNER TO pakfire
;
742 -- Name: builders_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
745 CREATE SEQUENCE builders_arches_id_seq
753 ALTER TABLE builders_arches_id_seq
OWNER TO pakfire
;
756 -- Name: builders_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
759 ALTER SEQUENCE builders_arches_id_seq
OWNED BY builders_arches.
id;
763 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
766 CREATE TABLE builders_history (
768 builder_id
integer NOT NULL,
769 action builders_history_action
NOT NULL,
771 "time" timestamp without time zone NOT NULL
775 ALTER TABLE builders_history
OWNER TO pakfire
;
778 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
781 CREATE SEQUENCE builders_history_id_seq
789 ALTER TABLE builders_history_id_seq
OWNER TO pakfire
;
792 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
795 ALTER SEQUENCE builders_history_id_seq
OWNED BY builders_history.
id;
799 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
802 CREATE SEQUENCE builders_id_seq
810 ALTER TABLE builders_id_seq
OWNER TO pakfire
;
813 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
816 ALTER SEQUENCE builders_id_seq
OWNED BY builders.
id;
820 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
826 type jobs_type
DEFAULT 'build'::jobs_type NOT NULL,
827 build_id
integer NOT NULL,
828 state jobs_state
DEFAULT 'new'::jobs_state NOT NULL,
830 time_created
timestamp without time zone NOT NULL,
831 time_started
timestamp without time zone,
832 time_finished
timestamp without time zone,
833 start_not_before
timestamp without time zone,
835 tries
integer DEFAULT 0 NOT NULL,
836 aborted_state
integer DEFAULT 0 NOT NULL,
841 ALTER TABLE jobs
OWNER TO pakfire
;
844 -- Name: jobs_active; Type: VIEW; Schema: public; Owner: pakfire
847 CREATE VIEW jobs_active
AS
857 jobs.start_not_before
,
863 WHERE (jobs.
state = ANY (ARRAY['dispatching'::jobs_state, 'running'::jobs_state, 'uploading'::jobs_state]))
864 ORDER BY jobs.time_started
;
867 ALTER TABLE jobs_active
OWNER TO pakfire
;
870 -- Name: builders_ready; Type: VIEW; Schema: public; Owner: pakfire
873 CREATE VIEW builders_ready
AS
874 SELECT builders.
id AS builder_id
,
875 builders.cpu_arch
AS builder_arch
,
876 builders.build_release
,
877 builders.build_scratch
,
880 WHERE (((builders.status
= 'enabled'::builders_status) AND (builders.time_keepalive
>= (now() - '00:05:00'::interval))) AND (builders.max_jobs
> ( SELECT count(*) AS count
882 WHERE (jobs_active.builder_id
= builders.
id))))
883 ORDER BY ( SELECT count(*) AS count
885 WHERE (jobs_active.builder_id
= builders.
id)), builders.cpu_bogomips
DESC;
888 ALTER TABLE builders_ready
OWNER TO pakfire
;
891 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
894 CREATE TABLE builds (
897 pkg_id
integer NOT NULL,
898 type builds_type
DEFAULT 'release'::builds_type NOT NULL,
899 state builds_state
DEFAULT 'building'::builds_state NOT NULL,
900 severity builds_severity
,
902 time_created
timestamp without time zone NOT NULL,
906 distro_id
integer NOT NULL,
908 public builds_public
DEFAULT 'Y'::builds_public NOT NULL,
909 priority
integer DEFAULT 0 NOT NULL,
910 auto_move builds_auto_move
DEFAULT 'N'::builds_auto_move NOT NULL
914 ALTER TABLE builds
OWNER TO pakfire
;
917 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
920 CREATE TABLE builds_bugs (
922 build_id
integer NOT NULL,
923 bug_id
integer NOT NULL
927 ALTER TABLE builds_bugs
OWNER TO pakfire
;
930 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
933 CREATE SEQUENCE builds_bugs_id_seq
941 ALTER TABLE builds_bugs_id_seq
OWNER TO pakfire
;
944 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
947 ALTER SEQUENCE builds_bugs_id_seq
OWNED BY builds_bugs.
id;
951 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
954 CREATE TABLE builds_bugs_updates (
956 bug_id
integer NOT NULL,
960 "time" timestamp without time zone NOT NULL,
961 error builds_bugs_updates_error
DEFAULT 'N'::builds_bugs_updates_error NOT NULL,
966 ALTER TABLE builds_bugs_updates
OWNER TO pakfire
;
969 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
972 CREATE SEQUENCE builds_bugs_updates_id_seq
980 ALTER TABLE builds_bugs_updates_id_seq
OWNER TO pakfire
;
983 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
986 ALTER SEQUENCE builds_bugs_updates_id_seq
OWNED BY builds_bugs_updates.
id;
990 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
993 CREATE TABLE builds_comments (
995 build_id
integer NOT NULL,
996 user_id
integer NOT NULL,
998 credit
integer NOT NULL,
999 time_created
timestamp without time zone NOT NULL,
1000 time_updated
timestamp without time zone
1004 ALTER TABLE builds_comments
OWNER TO pakfire
;
1007 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1010 CREATE SEQUENCE builds_comments_id_seq
1018 ALTER TABLE builds_comments_id_seq
OWNER TO pakfire
;
1021 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1024 ALTER SEQUENCE builds_comments_id_seq
OWNED BY builds_comments.
id;
1028 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1031 CREATE TABLE builds_history (
1032 id integer NOT NULL,
1033 build_id
integer NOT NULL,
1034 action builds_history_action
NOT NULL,
1036 "time" timestamp without time zone NOT NULL,
1041 ALTER TABLE builds_history
OWNER TO pakfire
;
1044 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1047 CREATE SEQUENCE builds_history_id_seq
1055 ALTER TABLE builds_history_id_seq
OWNER TO pakfire
;
1058 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1061 ALTER SEQUENCE builds_history_id_seq
OWNED BY builds_history.
id;
1065 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1068 CREATE SEQUENCE builds_id_seq
1076 ALTER TABLE builds_id_seq
OWNER TO pakfire
;
1079 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1082 ALTER SEQUENCE builds_id_seq
OWNED BY builds.
id;
1086 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1089 CREATE TABLE packages (
1090 id integer NOT NULL,
1092 epoch
integer NOT NULL,
1093 version text NOT NULL,
1094 release text NOT NULL,
1095 type packages_type
NOT NULL,
1096 arch
integer NOT NULL,
1097 groups
text NOT NULL,
1098 maintainer
text NOT NULL,
1099 license
text NOT NULL,
1101 summary
text NOT NULL,
1102 description
text NOT NULL,
1103 size bigint NOT NULL,
1104 supported_arches
text,
1107 build_id
text NOT NULL,
1108 build_host
text NOT NULL,
1109 build_time
timestamp without time zone NOT NULL,
1111 filesize
bigint NOT NULL,
1112 hash_sha512
text NOT NULL
1116 ALTER TABLE packages
OWNER TO pakfire
;
1119 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1122 CREATE TABLE repositories_builds (
1123 id integer NOT NULL,
1124 repo_id
integer NOT NULL,
1125 build_id
bigint NOT NULL,
1126 time_added
timestamp without time zone NOT NULL
1130 ALTER TABLE repositories_builds
OWNER TO pakfire
;
1133 -- Name: builds_latest; Type: VIEW; Schema: public; Owner: pakfire
1136 CREATE VIEW builds_latest
AS
1137 SELECT builds.
id AS build_id
,
1138 builds.
type AS build_type
,
1139 builds.
state AS build_state
,
1140 packages.
name AS package_name
,
1143 LEFT JOIN packages
ON ((builds.pkg_id
= packages.
id)))
1144 WHERE ((builds.
id IN ( SELECT repositories_builds.build_id
1145 FROM repositories_builds
)) OR ((builds.time_created
>= ( SELECT builds_1.time_created
1146 FROM ((builds builds_1
1147 LEFT JOIN repositories_builds
ON ((builds_1.
id = repositories_builds.build_id
)))
1148 LEFT JOIN packages p
ON ((builds_1.pkg_id
= p.
id)))
1149 WHERE (p.
name = packages.
name)
1150 ORDER BY builds_1.time_created
1151 LIMIT 1)) AND (builds.
state <> ALL (ARRAY['obsolete'::builds_state, 'broken'::builds_state]))));
1154 ALTER TABLE builds_latest
OWNER TO pakfire
;
1157 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
1160 CREATE VIEW builds_times
AS
1161 SELECT builds.
id AS build_id
,
1164 jobs.
type AS job_type
,
1165 (jobs.time_finished
- jobs.time_started
) AS duration
1167 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
1168 LEFT JOIN packages
ON ((builds.pkg_id
= packages.
id)))
1169 LEFT JOIN arches
ON ((jobs.arch
= arches.
name)))
1170 WHERE (jobs.
state = 'finished'::jobs_state);
1173 ALTER TABLE builds_times
OWNER TO pakfire
;
1176 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1179 CREATE TABLE builds_watchers (
1180 id integer NOT NULL,
1181 build_id
integer NOT NULL,
1182 user_id
integer NOT NULL
1186 ALTER TABLE builds_watchers
OWNER TO pakfire
;
1189 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1192 CREATE SEQUENCE builds_watchers_id_seq
1200 ALTER TABLE builds_watchers_id_seq
OWNER TO pakfire
;
1203 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1206 ALTER SEQUENCE builds_watchers_id_seq
OWNED BY builds_watchers.
id;
1210 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1213 CREATE TABLE distributions (
1214 id integer NOT NULL,
1216 sname
text NOT NULL,
1217 slogan
text NOT NULL,
1219 vendor
text NOT NULL,
1225 ALTER TABLE distributions
OWNER TO pakfire
;
1228 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1231 CREATE SEQUENCE distributions_id_seq
1239 ALTER TABLE distributions_id_seq
OWNER TO pakfire
;
1242 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1245 ALTER SEQUENCE distributions_id_seq
OWNED BY distributions.
id;
1249 -- Name: distro_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1252 CREATE TABLE distro_arches (
1253 id integer NOT NULL,
1254 distro_id
integer NOT NULL,
1255 arch_id
integer NOT NULL
1259 ALTER TABLE distro_arches
OWNER TO pakfire
;
1262 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1265 CREATE SEQUENCE distro_arches_id_seq
1273 ALTER TABLE distro_arches_id_seq
OWNER TO pakfire
;
1276 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1279 ALTER SEQUENCE distro_arches_id_seq
OWNED BY distro_arches.
id;
1283 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1286 CREATE TABLE filelists (
1287 pkg_id
integer NOT NULL,
1289 size bigint NOT NULL,
1291 type integer NOT NULL,
1292 config filelists_config
NOT NULL,
1293 mode integer NOT NULL,
1294 "user" text NOT NULL,
1295 "group" text NOT NULL,
1296 mtime
timestamp without time zone NOT NULL,
1301 ALTER TABLE filelists
OWNER TO pakfire
;
1304 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1307 CREATE TABLE images_types (
1308 id integer NOT NULL,
1313 ALTER TABLE images_types
OWNER TO pakfire
;
1316 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1319 CREATE SEQUENCE images_types_id_seq
1327 ALTER TABLE images_types_id_seq
OWNER TO pakfire
;
1330 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1333 ALTER SEQUENCE images_types_id_seq
OWNED BY images_types.
id;
1337 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1340 CREATE TABLE jobs_buildroots (
1341 job_id
integer NOT NULL,
1342 tries
integer NOT NULL,
1343 pkg_uuid
text NOT NULL,
1344 pkg_name
text NOT NULL
1348 ALTER TABLE jobs_buildroots
OWNER TO pakfire
;
1351 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1354 CREATE TABLE jobs_history (
1355 job_id
integer NOT NULL,
1356 action jobs_history_action
NOT NULL,
1357 state jobs_history_state
,
1359 "time" timestamp without time zone NOT NULL,
1365 ALTER TABLE jobs_history
OWNER TO pakfire
;
1368 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1371 CREATE SEQUENCE jobs_id_seq
1379 ALTER TABLE jobs_id_seq
OWNER TO pakfire
;
1382 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1385 ALTER SEQUENCE jobs_id_seq
OWNED BY jobs.
id;
1389 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1392 CREATE TABLE jobs_packages (
1393 id integer NOT NULL,
1394 job_id
integer NOT NULL,
1395 pkg_id
integer NOT NULL
1399 ALTER TABLE jobs_packages
OWNER TO pakfire
;
1402 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1405 CREATE SEQUENCE jobs_packages_id_seq
1413 ALTER TABLE jobs_packages_id_seq
OWNER TO pakfire
;
1416 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1419 ALTER SEQUENCE jobs_packages_id_seq
OWNED BY jobs_packages.
id;
1423 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
1426 CREATE VIEW jobs_queue
AS
1428 arches.
name AS arch
,
1429 ( SELECT builders_ready.builder_id
1431 WHERE (builders_ready.builder_id
IN ( SELECT arches_builders.builder_id
1432 FROM arches_builders
1433 WHERE ((arches_builders.arch
= arches.
name) AND
1435 WHEN ((builds.
type = 'release'::builds_type) AND (jobs.
type = 'build'::jobs_type)) THEN (builders_ready.build_release
= 'Y'::builders_build_release)
1436 WHEN ((builds.
type = 'scratch'::builds_type) AND (jobs.
type = 'build'::jobs_type)) THEN (builders_ready.build_scratch
= 'Y'::builders_build_scratch)
1437 WHEN (jobs.
type = 'test'::jobs_type) THEN (builders_ready.build_test
= 'Y'::builders_build_test)
1440 LIMIT 1) AS designated_builder_id
1442 LEFT JOIN arches
ON ((jobs.arch
= arches.
name)))
1443 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
1444 WHERE ((jobs.
state = ANY (ARRAY['pending'::jobs_state, 'new'::jobs_state])) AND ((jobs.start_not_before
IS NULL) OR (jobs.start_not_before
<= now())))
1447 WHEN (jobs.
type = 'build'::jobs_type) THEN 0
1448 WHEN (jobs.
type = 'test'::jobs_type) THEN 1
1450 END, builds.priority
DESC, jobs.tries
, jobs.time_created
;
1453 ALTER TABLE jobs_queue
OWNER TO pakfire
;
1456 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1459 CREATE TABLE jobs_repos (
1460 job_id
integer NOT NULL,
1461 repo_id
integer NOT NULL
1465 ALTER TABLE jobs_repos
OWNER TO pakfire
;
1468 -- Name: jobs_waiting; Type: VIEW; Schema: public; Owner: pakfire
1471 CREATE VIEW jobs_waiting
AS
1472 SELECT jobs_queue.
id,
1473 (now() - (jobs.time_created
)::timestamp with time zone) AS time_waiting
1475 LEFT JOIN jobs
ON ((jobs_queue.
id = jobs.
id)))
1476 WHERE (jobs.start_not_before
IS NULL)
1478 SELECT jobs_queue.
id,
1479 (now() - (jobs.start_not_before
)::timestamp with time zone) AS time_waiting
1481 LEFT JOIN jobs
ON ((jobs_queue.
id = jobs.
id)))
1482 WHERE (jobs.start_not_before
IS NOT NULL);
1485 ALTER TABLE jobs_waiting
OWNER TO pakfire
;
1488 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1492 id integer NOT NULL,
1493 fingerprint
text NOT NULL,
1499 ALTER TABLE keys
OWNER TO pakfire
;
1502 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1505 CREATE SEQUENCE keys_id_seq
1513 ALTER TABLE keys_id_seq
OWNER TO pakfire
;
1516 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1519 ALTER SEQUENCE keys_id_seq
OWNED BY keys.
id;
1523 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1526 CREATE TABLE keys_subkeys (
1527 id integer NOT NULL,
1528 key_id
integer NOT NULL,
1529 fingerprint
text NOT NULL,
1530 time_created
timestamp without time zone NOT NULL,
1531 time_expires
timestamp without time zone,
1536 ALTER TABLE keys_subkeys
OWNER TO pakfire
;
1539 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1542 CREATE SEQUENCE keys_subkeys_id_seq
1550 ALTER TABLE keys_subkeys_id_seq
OWNER TO pakfire
;
1553 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1556 ALTER SEQUENCE keys_subkeys_id_seq
OWNED BY keys_subkeys.
id;
1560 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1563 CREATE TABLE logfiles (
1564 id integer NOT NULL,
1565 job_id
integer NOT NULL,
1567 filesize
bigint NOT NULL,
1568 hash_sha512
text NOT NULL
1572 ALTER TABLE logfiles
OWNER TO pakfire
;
1575 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1578 CREATE SEQUENCE logfiles_id_seq
1586 ALTER TABLE logfiles_id_seq
OWNER TO pakfire
;
1589 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1592 ALTER SEQUENCE logfiles_id_seq
OWNED BY logfiles.
id;
1596 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1599 CREATE TABLE mirrors (
1600 id integer NOT NULL,
1601 hostname
text NOT NULL,
1605 deleted
boolean DEFAULT false NOT NULL
1609 ALTER TABLE mirrors
OWNER TO pakfire
;
1612 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1615 CREATE TABLE mirrors_checks (
1616 id integer NOT NULL,
1617 mirror_id
integer NOT NULL,
1618 "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
1619 response_time
double precision,
1620 http_status
integer,
1621 last_sync_at
timestamp without time zone,
1622 status
text DEFAULT 'OK'::text NOT NULL
1626 ALTER TABLE mirrors_checks
OWNER TO pakfire
;
1629 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1632 CREATE SEQUENCE mirrors_checks_id_seq
1640 ALTER TABLE mirrors_checks_id_seq
OWNER TO pakfire
;
1643 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1646 ALTER SEQUENCE mirrors_checks_id_seq
OWNED BY mirrors_checks.
id;
1650 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1653 CREATE TABLE mirrors_history (
1654 id integer NOT NULL,
1655 mirror_id
integer NOT NULL,
1656 action mirrors_history_action
NOT NULL,
1658 "time" timestamp without time zone NOT NULL
1662 ALTER TABLE mirrors_history
OWNER TO pakfire
;
1665 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1668 CREATE SEQUENCE mirrors_history_id_seq
1676 ALTER TABLE mirrors_history_id_seq
OWNER TO pakfire
;
1679 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1682 ALTER SEQUENCE mirrors_history_id_seq
OWNED BY mirrors_history.
id;
1686 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1689 CREATE SEQUENCE mirrors_id_seq
1697 ALTER TABLE mirrors_id_seq
OWNER TO pakfire
;
1700 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1703 ALTER SEQUENCE mirrors_id_seq
OWNED BY mirrors.
id;
1707 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1710 CREATE TABLE packages_deps (
1711 pkg_id
integer NOT NULL,
1712 type packages_deps_type
NOT NULL,
1717 ALTER TABLE packages_deps
OWNER TO pakfire
;
1720 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1723 CREATE SEQUENCE packages_id_seq
1731 ALTER TABLE packages_id_seq
OWNER TO pakfire
;
1734 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1737 ALTER SEQUENCE packages_id_seq
OWNED BY packages.
id;
1741 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1744 CREATE TABLE packages_properties (
1745 id integer NOT NULL,
1747 critical_path packages_properties_critical_path
DEFAULT 'N'::packages_properties_critical_path NOT NULL,
1748 priority
integer DEFAULT 0 NOT NULL
1752 ALTER TABLE packages_properties
OWNER TO pakfire
;
1755 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1758 CREATE SEQUENCE packages_properties_id_seq
1766 ALTER TABLE packages_properties_id_seq
OWNER TO pakfire
;
1769 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1772 ALTER SEQUENCE packages_properties_id_seq
OWNED BY packages_properties.
id;
1776 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1779 CREATE TABLE queue_delete (
1780 id integer NOT NULL,
1785 ALTER TABLE queue_delete
OWNER TO pakfire
;
1788 -- Name: queue_delete_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1791 CREATE SEQUENCE queue_delete_id_seq
1799 ALTER TABLE queue_delete_id_seq
OWNER TO pakfire
;
1802 -- Name: queue_delete_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1805 ALTER SEQUENCE queue_delete_id_seq
OWNED BY queue_delete.
id;
1809 -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: pakfire
1812 CREATE VIEW relation_sizes
AS
1813 SELECT c.relname
AS relation
,
1814 pg_size_pretty(pg_relation_size((c.oid
)::regclass)) AS size
1816 LEFT JOIN pg_namespace n
ON ((n.oid
= c.relnamespace
)))
1817 WHERE (n.nspname
<> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name]))
1818 ORDER BY pg_relation_size((c.oid
)::regclass) DESC;
1821 ALTER TABLE relation_sizes
OWNER TO pakfire
;
1824 -- Name: repositories; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1827 CREATE TABLE repositories (
1828 id integer NOT NULL,
1830 type repositories_type
DEFAULT 'testing'::repositories_type NOT NULL,
1831 description
text NOT NULL,
1832 distro_id
integer NOT NULL,
1835 mirrored repositories_mirrored
DEFAULT 'N'::repositories_mirrored NOT NULL,
1836 enabled_for_builds repositories_enabled_for_builds
DEFAULT 'N'::repositories_enabled_for_builds NOT NULL,
1837 score_needed
integer DEFAULT 0 NOT NULL,
1838 last_update
timestamp without time zone,
1839 time_min
integer DEFAULT 0 NOT NULL,
1840 time_max
integer DEFAULT 0 NOT NULL,
1841 update_started
timestamp without time zone,
1842 update_ended
timestamp without time zone
1846 ALTER TABLE repositories
OWNER TO pakfire
;
1849 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1852 CREATE TABLE repositories_aux (
1853 id integer NOT NULL,
1857 distro_id
integer NOT NULL,
1858 status repositories_aux_status
DEFAULT 'disabled'::repositories_aux_status NOT NULL
1862 ALTER TABLE repositories_aux
OWNER TO pakfire
;
1865 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1868 CREATE SEQUENCE repositories_aux_id_seq
1876 ALTER TABLE repositories_aux_id_seq
OWNER TO pakfire
;
1879 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1882 ALTER SEQUENCE repositories_aux_id_seq
OWNED BY repositories_aux.
id;
1886 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1889 CREATE SEQUENCE repositories_builds_id_seq
1897 ALTER TABLE repositories_builds_id_seq
OWNER TO pakfire
;
1900 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1903 ALTER SEQUENCE repositories_builds_id_seq
OWNED BY repositories_builds.
id;
1907 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1910 CREATE TABLE repositories_history (
1911 build_id
bigint NOT NULL,
1912 action repositories_history_action
NOT NULL,
1913 from_repo_id
integer,
1916 "time" timestamp without time zone NOT NULL
1920 ALTER TABLE repositories_history
OWNER TO pakfire
;
1923 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1926 CREATE SEQUENCE repositories_id_seq
1934 ALTER TABLE repositories_id_seq
OWNER TO pakfire
;
1937 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1940 ALTER SEQUENCE repositories_id_seq
OWNED BY repositories.
id;
1944 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1947 CREATE TABLE sessions (
1948 id integer NOT NULL,
1949 session_id
text NOT NULL,
1950 created_at
timestamp without time zone DEFAULT now() NOT NULL,
1951 valid_until
timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1952 user_id
integer NOT NULL,
1953 impersonated_user_id
integer,
1956 CONSTRAINT sessions_impersonation_check
CHECK (((impersonated_user_id
IS NULL) OR (user_id
<> impersonated_user_id
)))
1960 ALTER TABLE sessions
OWNER TO pakfire
;
1963 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1966 CREATE SEQUENCE sessions_id_seq
1974 ALTER TABLE sessions_id_seq
OWNER TO pakfire
;
1977 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1980 ALTER SEQUENCE sessions_id_seq
OWNED BY sessions.
id;
1984 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1987 CREATE TABLE settings (
1993 ALTER TABLE settings
OWNER TO pakfire
;
1996 -- Name: slogans; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1999 CREATE TABLE slogans (
2000 id integer NOT NULL,
2001 message
text NOT NULL
2005 ALTER TABLE slogans
OWNER TO pakfire
;
2008 -- Name: slogans_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2011 CREATE SEQUENCE slogans_id_seq
2019 ALTER TABLE slogans_id_seq
OWNER TO pakfire
;
2022 -- Name: slogans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2025 ALTER SEQUENCE slogans_id_seq
OWNED BY slogans.
id;
2029 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2032 CREATE TABLE sources (
2033 id integer NOT NULL,
2035 identifier
text NOT NULL,
2038 revision
text NOT NULL,
2039 branch
text NOT NULL,
2040 updated
timestamp without time zone,
2041 distro_id
integer NOT NULL
2045 ALTER TABLE sources
OWNER TO pakfire
;
2048 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2051 CREATE TABLE sources_commits (
2052 id integer NOT NULL,
2053 source_id
integer NOT NULL,
2054 revision
text NOT NULL,
2055 author
text NOT NULL,
2056 committer
text NOT NULL,
2057 subject
text NOT NULL,
2059 date timestamp without time zone NOT NULL,
2060 state sources_commits_state
DEFAULT 'pending'::sources_commits_state NOT NULL
2064 ALTER TABLE sources_commits
OWNER TO pakfire
;
2067 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2070 CREATE SEQUENCE sources_commits_id_seq
2078 ALTER TABLE sources_commits_id_seq
OWNER TO pakfire
;
2081 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2084 ALTER SEQUENCE sources_commits_id_seq
OWNED BY sources_commits.
id;
2088 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2091 CREATE SEQUENCE sources_id_seq
2099 ALTER TABLE sources_id_seq
OWNER TO pakfire
;
2102 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2105 ALTER SEQUENCE sources_id_seq
OWNED BY sources.
id;
2109 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2112 CREATE TABLE uploads (
2113 id integer NOT NULL,
2117 filename
text NOT NULL,
2119 size bigint NOT NULL,
2120 progress
bigint DEFAULT 0 NOT NULL,
2121 finished uploads_finished
DEFAULT 'N'::uploads_finished NOT NULL,
2122 time_started
timestamp without time zone DEFAULT now() NOT NULL,
2123 time_finished
timestamp without time zone
2127 ALTER TABLE uploads
OWNER TO pakfire
;
2130 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2133 CREATE SEQUENCE uploads_id_seq
2141 ALTER TABLE uploads_id_seq
OWNER TO pakfire
;
2144 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2147 ALTER SEQUENCE uploads_id_seq
OWNED BY uploads.
id;
2151 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2154 CREATE TABLE user_messages (
2155 id integer NOT NULL,
2158 subject
text NOT NULL,
2160 time_added
timestamp without time zone DEFAULT now() NOT NULL
2164 ALTER TABLE user_messages
OWNER TO pakfire
;
2167 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2170 CREATE SEQUENCE user_messages_id_seq
2178 ALTER TABLE user_messages_id_seq
OWNER TO pakfire
;
2181 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2184 ALTER SEQUENCE user_messages_id_seq
OWNED BY user_messages.
id;
2188 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2191 CREATE TABLE users (
2192 id integer NOT NULL,
2195 passphrase
text NOT NULL,
2196 state users_state
NOT NULL,
2199 activated users_activated
DEFAULT 'N'::users_activated NOT NULL,
2200 activation_code
text,
2201 deleted users_deleted
DEFAULT 'N'::users_deleted NOT NULL,
2202 registered
timestamp without time zone DEFAULT now() NOT NULL
2206 ALTER TABLE users
OWNER TO pakfire
;
2209 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2212 CREATE TABLE users_emails (
2213 id integer NOT NULL,
2214 user_id
integer NOT NULL,
2215 email
text NOT NULL,
2216 "primary" users_emails_primary
DEFAULT 'N'::users_emails_primary NOT NULL
2220 ALTER TABLE users_emails
OWNER TO pakfire
;
2223 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2226 CREATE SEQUENCE users_emails_id_seq
2234 ALTER TABLE users_emails_id_seq
OWNER TO pakfire
;
2237 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2240 ALTER SEQUENCE users_emails_id_seq
OWNED BY users_emails.
id;
2244 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2247 CREATE SEQUENCE users_id_seq
2255 ALTER TABLE users_id_seq
OWNER TO pakfire
;
2258 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2261 ALTER SEQUENCE users_id_seq
OWNED BY users.
id;
2265 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2268 CREATE TABLE users_permissions (
2269 id integer NOT NULL,
2270 user_id
integer NOT NULL,
2271 create_scratch_builds users_permissions_create_scratch_builds
DEFAULT 'N'::users_permissions_create_scratch_builds NOT NULL,
2272 maintain_builders users_permissions_maintain_builders
DEFAULT 'N'::users_permissions_maintain_builders NOT NULL,
2273 manage_critical_path users_permissions_manage_critical_path
DEFAULT 'N'::users_permissions_manage_critical_path NOT NULL,
2274 manage_mirrors users_permissions_manage_mirrors
DEFAULT 'N'::users_permissions_manage_mirrors NOT NULL,
2275 vote users_permissions_vote
DEFAULT 'N'::users_permissions_vote NOT NULL
2279 ALTER TABLE users_permissions
OWNER TO pakfire
;
2282 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2285 CREATE SEQUENCE users_permissions_id_seq
2293 ALTER TABLE users_permissions_id_seq
OWNER TO pakfire
;
2296 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2299 ALTER SEQUENCE users_permissions_id_seq
OWNED BY users_permissions.
id;
2303 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2306 ALTER TABLE ONLY arches
ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
2310 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2313 ALTER TABLE ONLY builders
ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
2317 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2320 ALTER TABLE ONLY builders_arches
ALTER COLUMN id SET DEFAULT nextval('builders_arches_id_seq'::regclass);
2324 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2327 ALTER TABLE ONLY builders_history
ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
2331 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2334 ALTER TABLE ONLY builds
ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
2338 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2341 ALTER TABLE ONLY builds_bugs
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
2345 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2348 ALTER TABLE ONLY builds_bugs_updates
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
2352 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2355 ALTER TABLE ONLY builds_comments
ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
2359 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2362 ALTER TABLE ONLY builds_history
ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
2366 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2369 ALTER TABLE ONLY builds_watchers
ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
2373 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2376 ALTER TABLE ONLY distributions
ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
2380 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2383 ALTER TABLE ONLY distro_arches
ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
2387 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2390 ALTER TABLE ONLY images_types
ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
2394 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2397 ALTER TABLE ONLY jobs
ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
2401 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2404 ALTER TABLE ONLY jobs_packages
ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
2408 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2411 ALTER TABLE ONLY keys
ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
2415 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2418 ALTER TABLE ONLY keys_subkeys
ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
2422 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2425 ALTER TABLE ONLY logfiles
ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
2429 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2432 ALTER TABLE ONLY mirrors
ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
2436 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2439 ALTER TABLE ONLY mirrors_checks
ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
2443 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2446 ALTER TABLE ONLY mirrors_history
ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
2450 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2453 ALTER TABLE ONLY packages
ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
2457 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2460 ALTER TABLE ONLY packages_properties
ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
2464 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2467 ALTER TABLE ONLY queue_delete
ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
2471 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2474 ALTER TABLE ONLY repositories
ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
2478 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2481 ALTER TABLE ONLY repositories_aux
ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
2485 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2488 ALTER TABLE ONLY repositories_builds
ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
2492 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2495 ALTER TABLE ONLY sessions
ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
2499 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2502 ALTER TABLE ONLY slogans
ALTER COLUMN id SET DEFAULT nextval('slogans_id_seq'::regclass);
2506 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2509 ALTER TABLE ONLY sources
ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
2513 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2516 ALTER TABLE ONLY sources_commits
ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
2520 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2523 ALTER TABLE ONLY uploads
ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
2527 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2530 ALTER TABLE ONLY user_messages
ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
2534 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2537 ALTER TABLE ONLY users
ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
2541 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2544 ALTER TABLE ONLY users_emails
ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
2548 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2551 ALTER TABLE ONLY users_permissions
ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
2555 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2558 ALTER TABLE ONLY arches
2559 ADD CONSTRAINT arches_name
UNIQUE (name);
2563 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2566 ALTER TABLE ONLY arches
2567 ADD CONSTRAINT idx_2197943_primary
PRIMARY KEY (id);
2571 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2574 ALTER TABLE ONLY builders
2575 ADD CONSTRAINT idx_2197954_primary
PRIMARY KEY (id);
2579 -- Name: idx_2197975_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2582 ALTER TABLE ONLY builders_arches
2583 ADD CONSTRAINT idx_2197975_primary
PRIMARY KEY (id);
2587 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2590 ALTER TABLE ONLY builders_history
2591 ADD CONSTRAINT idx_2197982_primary
PRIMARY KEY (id);
2595 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2598 ALTER TABLE ONLY builds
2599 ADD CONSTRAINT idx_2197988_primary
PRIMARY KEY (id);
2603 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2606 ALTER TABLE ONLY builds_bugs
2607 ADD CONSTRAINT idx_2198002_primary
PRIMARY KEY (id);
2611 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2614 ALTER TABLE ONLY builds_bugs_updates
2615 ADD CONSTRAINT idx_2198008_primary
PRIMARY KEY (id);
2619 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2622 ALTER TABLE ONLY builds_comments
2623 ADD CONSTRAINT idx_2198018_primary
PRIMARY KEY (id);
2627 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2630 ALTER TABLE ONLY builds_history
2631 ADD CONSTRAINT idx_2198027_primary
PRIMARY KEY (id);
2635 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2638 ALTER TABLE ONLY builds_watchers
2639 ADD CONSTRAINT idx_2198033_primary
PRIMARY KEY (id);
2643 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2646 ALTER TABLE ONLY distributions
2647 ADD CONSTRAINT idx_2198039_primary
PRIMARY KEY (id);
2651 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2654 ALTER TABLE ONLY distro_arches
2655 ADD CONSTRAINT idx_2198048_primary
PRIMARY KEY (id);
2659 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2662 ALTER TABLE ONLY images_types
2663 ADD CONSTRAINT idx_2198057_primary
PRIMARY KEY (id);
2667 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2670 ALTER TABLE ONLY jobs
2671 ADD CONSTRAINT idx_2198063_primary
PRIMARY KEY (id);
2675 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2678 ALTER TABLE ONLY jobs_packages
2679 ADD CONSTRAINT idx_2198085_primary
PRIMARY KEY (id);
2683 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2686 ALTER TABLE ONLY keys
2687 ADD CONSTRAINT idx_2198094_primary
PRIMARY KEY (id);
2691 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2694 ALTER TABLE ONLY keys_subkeys
2695 ADD CONSTRAINT idx_2198103_primary
PRIMARY KEY (id);
2699 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2702 ALTER TABLE ONLY logfiles
2703 ADD CONSTRAINT idx_2198109_primary
PRIMARY KEY (id);
2707 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2710 ALTER TABLE ONLY mirrors
2711 ADD CONSTRAINT idx_2198115_primary
PRIMARY KEY (id);
2715 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2718 ALTER TABLE ONLY mirrors_history
2719 ADD CONSTRAINT idx_2198126_primary
PRIMARY KEY (id);
2723 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2726 ALTER TABLE ONLY packages
2727 ADD CONSTRAINT idx_2198132_primary
PRIMARY KEY (id);
2731 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2734 ALTER TABLE ONLY packages_properties
2735 ADD CONSTRAINT idx_2198147_primary
PRIMARY KEY (id);
2739 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2742 ALTER TABLE ONLY queue_delete
2743 ADD CONSTRAINT idx_2198155_primary
PRIMARY KEY (id);
2747 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2750 ALTER TABLE ONLY repositories
2751 ADD CONSTRAINT idx_2198164_primary
PRIMARY KEY (id);
2755 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2758 ALTER TABLE ONLY repositories_aux
2759 ADD CONSTRAINT idx_2198179_primary
PRIMARY KEY (id);
2763 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2766 ALTER TABLE ONLY repositories_builds
2767 ADD CONSTRAINT idx_2198189_primary
PRIMARY KEY (id);
2771 -- Name: idx_2198207_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2774 ALTER TABLE ONLY slogans
2775 ADD CONSTRAINT idx_2198207_primary
PRIMARY KEY (id);
2779 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2782 ALTER TABLE ONLY sources
2783 ADD CONSTRAINT idx_2198213_primary
PRIMARY KEY (id);
2787 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2790 ALTER TABLE ONLY sources_commits
2791 ADD CONSTRAINT idx_2198222_primary
PRIMARY KEY (id);
2795 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2798 ALTER TABLE ONLY uploads
2799 ADD CONSTRAINT idx_2198232_primary
PRIMARY KEY (id);
2803 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2806 ALTER TABLE ONLY users
2807 ADD CONSTRAINT idx_2198244_primary
PRIMARY KEY (id);
2811 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2814 ALTER TABLE ONLY users_emails
2815 ADD CONSTRAINT idx_2198256_primary
PRIMARY KEY (id);
2819 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2822 ALTER TABLE ONLY users_permissions
2823 ADD CONSTRAINT idx_2198263_primary
PRIMARY KEY (id);
2827 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2830 ALTER TABLE ONLY user_messages
2831 ADD CONSTRAINT idx_2198274_primary
PRIMARY KEY (id);
2835 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2838 ALTER TABLE ONLY jobs_packages
2839 ADD CONSTRAINT jobs_packages_unique
UNIQUE (job_id
, pkg_id
);
2843 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2846 ALTER TABLE ONLY mirrors_checks
2847 ADD CONSTRAINT mirrors_checks_pkey
PRIMARY KEY (id);
2851 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2854 ALTER TABLE ONLY sessions
2855 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (id);
2859 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2862 ALTER TABLE ONLY sessions
2863 ADD CONSTRAINT sessions_session_id_key
UNIQUE (session_id
);
2867 -- Name: builders_arches_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2870 CREATE INDEX builders_arches_builder_id
ON builders_arches
USING btree (builder_id
);
2874 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2877 CREATE INDEX builds_watchers_build_id
ON builds_watchers
USING btree (build_id
);
2881 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2884 CREATE INDEX filelists_name
ON filelists
USING btree (name);
2888 -- Name: idx_2197949_host_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2891 CREATE INDEX idx_2197949_host_arch
ON arches_compat
USING btree (host_arch
);
2895 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2898 CREATE INDEX idx_2197982_builder_id
ON builders_history
USING btree (builder_id
);
2902 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2905 CREATE INDEX idx_2197988_pkg_id
ON builds
USING btree (pkg_id
);
2909 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2912 CREATE INDEX idx_2197988_state
ON builds
USING btree (state);
2916 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2919 CREATE INDEX idx_2197988_type
ON builds
USING btree (type);
2923 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2926 CREATE UNIQUE INDEX idx_2197988_uuid
ON builds
USING btree (uuid
);
2930 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2933 CREATE UNIQUE INDEX idx_2198002_build_id
ON builds_bugs
USING btree (build_id
, bug_id
);
2937 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2940 CREATE INDEX idx_2198018_build_id
ON builds_comments
USING btree (build_id
);
2944 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2947 CREATE INDEX idx_2198018_user_id
ON builds_comments
USING btree (user_id
);
2951 -- Name: idx_2198052_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2954 CREATE INDEX idx_2198052_pkg_id
ON filelists
USING btree (pkg_id
);
2958 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2961 CREATE INDEX idx_2198063_build_id
ON jobs
USING btree (build_id
);
2965 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2968 CREATE INDEX idx_2198063_state
ON jobs
USING btree (state);
2972 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2975 CREATE INDEX idx_2198063_time_finished
ON jobs
USING btree (time_finished
);
2979 -- Name: idx_2198063_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2982 CREATE INDEX idx_2198063_type
ON jobs
USING btree (type);
2986 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2989 CREATE UNIQUE INDEX idx_2198063_uuid
ON jobs
USING btree (uuid
);
2993 -- Name: idx_2198074_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2996 CREATE INDEX idx_2198074_job_id
ON jobs_buildroots
USING btree (job_id
);
3000 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3003 CREATE INDEX idx_2198080_job_id
ON jobs_history
USING btree (job_id
);
3007 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3010 CREATE UNIQUE INDEX idx_2198089_job_id
ON jobs_repos
USING btree (job_id
, repo_id
);
3014 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3017 CREATE UNIQUE INDEX idx_2198094_fingerprint
ON keys
USING btree (fingerprint
);
3021 -- Name: idx_2198132_epoch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3024 CREATE INDEX idx_2198132_epoch
ON packages
USING btree (epoch
);
3028 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3031 CREATE INDEX idx_2198132_name
ON packages
USING btree (name);
3035 -- Name: idx_2198132_release; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3038 CREATE INDEX idx_2198132_release
ON packages
USING btree (release);
3042 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3045 CREATE INDEX idx_2198132_type
ON packages
USING btree (type);
3049 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3052 CREATE INDEX idx_2198132_uuid
ON packages
USING btree (uuid
);
3056 -- Name: idx_2198132_version; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3059 CREATE INDEX idx_2198132_version
ON packages
USING btree (version);
3063 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3066 CREATE INDEX idx_2198139_pkg_id
ON packages_deps
USING btree (pkg_id
);
3070 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3073 CREATE UNIQUE INDEX idx_2198147_name
ON packages_properties
USING btree (name);
3077 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3080 CREATE UNIQUE INDEX idx_2198189_build_id
ON repositories_builds
USING btree (build_id
);
3084 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3087 CREATE INDEX idx_2198193_build_id
ON repositories_history
USING btree (build_id
);
3091 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3094 CREATE UNIQUE INDEX idx_2198199_k
ON settings
USING btree (k
);
3098 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3101 CREATE UNIQUE INDEX idx_2198213_identifier
ON sources
USING btree (identifier
);
3105 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3108 CREATE INDEX idx_2198222_revision
ON sources_commits
USING btree (revision
);
3112 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3115 CREATE UNIQUE INDEX idx_2198232_uuid
ON uploads
USING btree (uuid
);
3119 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3122 CREATE UNIQUE INDEX idx_2198244_name
ON users
USING btree (name);
3126 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3129 CREATE UNIQUE INDEX idx_2198256_email
ON users_emails
USING btree (email
);
3133 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3136 CREATE INDEX idx_2198256_user_id
ON users_emails
USING btree (user_id
);
3140 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3143 CREATE INDEX jobs_arch
ON jobs
USING btree (arch
);
3147 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3150 CREATE INDEX jobs_buildroots_pkg_uuid
ON jobs_buildroots
USING btree (pkg_uuid
);
3154 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3157 CREATE INDEX mirrors_checks_sort
ON mirrors_checks
USING btree (mirror_id
, "timestamp");
3159 ALTER TABLE mirrors_checks
CLUSTER ON mirrors_checks_sort
;
3163 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
3166 CREATE TRIGGER on_update_current_timestamp
BEFORE UPDATE ON sources
FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
3170 -- Name: builders_arches_arch_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3173 ALTER TABLE ONLY builders_arches
3174 ADD CONSTRAINT builders_arches_arch_id
FOREIGN KEY (arch_id
) REFERENCES arches(id);
3178 -- Name: builders_arches_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3181 ALTER TABLE ONLY builders_arches
3182 ADD CONSTRAINT builders_arches_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3186 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3189 ALTER TABLE ONLY builders_history
3190 ADD CONSTRAINT builders_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3194 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3197 ALTER TABLE ONLY builders_history
3198 ADD CONSTRAINT builders_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3202 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3205 ALTER TABLE ONLY builds_bugs
3206 ADD CONSTRAINT builds_bug_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3210 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3213 ALTER TABLE ONLY builds_comments
3214 ADD CONSTRAINT builds_comments_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3218 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3221 ALTER TABLE ONLY builds_comments
3222 ADD CONSTRAINT builds_comments_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3226 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3229 ALTER TABLE ONLY builds
3230 ADD CONSTRAINT builds_depends_on
FOREIGN KEY (depends_on
) REFERENCES builds(id);
3234 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3237 ALTER TABLE ONLY builds
3238 ADD CONSTRAINT builds_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3242 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3245 ALTER TABLE ONLY builds_history
3246 ADD CONSTRAINT builds_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3250 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3253 ALTER TABLE ONLY builds_history
3254 ADD CONSTRAINT builds_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3258 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3261 ALTER TABLE ONLY builds
3262 ADD CONSTRAINT builds_owner_id
FOREIGN KEY (owner_id
) REFERENCES users(id);
3266 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3269 ALTER TABLE ONLY builds
3270 ADD CONSTRAINT builds_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3274 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3277 ALTER TABLE ONLY builds_watchers
3278 ADD CONSTRAINT builds_watchers_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3282 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3285 ALTER TABLE ONLY builds_watchers
3286 ADD CONSTRAINT builds_watchers_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3290 -- Name: distro_arches_arch_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3293 ALTER TABLE ONLY distro_arches
3294 ADD CONSTRAINT distro_arches_arch_id
FOREIGN KEY (arch_id
) REFERENCES arches(id);
3298 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3301 ALTER TABLE ONLY distro_arches
3302 ADD CONSTRAINT distro_arches_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3306 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3309 ALTER TABLE ONLY filelists
3310 ADD CONSTRAINT filelists_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3314 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3317 ALTER TABLE ONLY jobs
3318 ADD CONSTRAINT jobs_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3322 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3325 ALTER TABLE ONLY jobs
3326 ADD CONSTRAINT jobs_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3330 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3333 ALTER TABLE ONLY jobs
3334 ADD CONSTRAINT jobs_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3338 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3341 ALTER TABLE ONLY jobs_buildroots
3342 ADD CONSTRAINT jobs_buildroots_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3346 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3349 ALTER TABLE ONLY jobs_history
3350 ADD CONSTRAINT jobs_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3354 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3357 ALTER TABLE ONLY jobs_history
3358 ADD CONSTRAINT jobs_history_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3362 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3365 ALTER TABLE ONLY jobs_history
3366 ADD CONSTRAINT jobs_history_test_job_id
FOREIGN KEY (test_job_id
) REFERENCES jobs(id);
3370 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3373 ALTER TABLE ONLY jobs_history
3374 ADD CONSTRAINT jobs_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3378 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3381 ALTER TABLE ONLY jobs_packages
3382 ADD CONSTRAINT jobs_packaged_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3386 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3389 ALTER TABLE ONLY jobs_packages
3390 ADD CONSTRAINT jobs_packages_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3394 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3397 ALTER TABLE ONLY jobs_repos
3398 ADD CONSTRAINT jobs_repos_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3402 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3405 ALTER TABLE ONLY jobs_repos
3406 ADD CONSTRAINT jobs_repos_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3410 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3413 ALTER TABLE ONLY keys_subkeys
3414 ADD CONSTRAINT keys_subkeys_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3418 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3421 ALTER TABLE ONLY logfiles
3422 ADD CONSTRAINT logfiles_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3426 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3429 ALTER TABLE ONLY mirrors_checks
3430 ADD CONSTRAINT mirrors_checks_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3434 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3437 ALTER TABLE ONLY mirrors_history
3438 ADD CONSTRAINT mirrors_history_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3442 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3445 ALTER TABLE ONLY mirrors_history
3446 ADD CONSTRAINT mirrors_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3450 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3453 ALTER TABLE ONLY packages
3454 ADD CONSTRAINT packages_arch
FOREIGN KEY (arch
) REFERENCES arches(id);
3458 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3461 ALTER TABLE ONLY packages
3462 ADD CONSTRAINT packages_commit_id
FOREIGN KEY (commit_id
) REFERENCES sources_commits(id);
3466 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3469 ALTER TABLE ONLY packages_deps
3470 ADD CONSTRAINT packages_deps_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3474 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3477 ALTER TABLE ONLY repositories_aux
3478 ADD CONSTRAINT repositories_aux_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3482 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3485 ALTER TABLE ONLY repositories_builds
3486 ADD CONSTRAINT repositories_builds_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3490 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3493 ALTER TABLE ONLY repositories_builds
3494 ADD CONSTRAINT repositories_builds_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3498 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3501 ALTER TABLE ONLY repositories
3502 ADD CONSTRAINT repositories_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3506 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3509 ALTER TABLE ONLY repositories_history
3510 ADD CONSTRAINT repositories_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3514 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3517 ALTER TABLE ONLY repositories_history
3518 ADD CONSTRAINT repositories_history_from_repo_id
FOREIGN KEY (from_repo_id
) REFERENCES repositories(id);
3522 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3525 ALTER TABLE ONLY repositories_history
3526 ADD CONSTRAINT repositories_history_to_repo_id
FOREIGN KEY (to_repo_id
) REFERENCES repositories(id);
3530 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3533 ALTER TABLE ONLY repositories_history
3534 ADD CONSTRAINT repositories_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3538 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3541 ALTER TABLE ONLY repositories
3542 ADD CONSTRAINT repositories_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3546 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3549 ALTER TABLE ONLY repositories
3550 ADD CONSTRAINT repositories_parent_id
FOREIGN KEY (parent_id
) REFERENCES repositories(id);
3554 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3557 ALTER TABLE ONLY sessions
3558 ADD CONSTRAINT sessions_impersonated_user_id
FOREIGN KEY (impersonated_user_id
) REFERENCES users(id);
3562 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3565 ALTER TABLE ONLY sessions
3566 ADD CONSTRAINT sessions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3570 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3573 ALTER TABLE ONLY sources_commits
3574 ADD CONSTRAINT sources_commits_source_id
FOREIGN KEY (source_id
) REFERENCES sources(id);
3578 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3581 ALTER TABLE ONLY sources
3582 ADD CONSTRAINT sources_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3586 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3589 ALTER TABLE ONLY uploads
3590 ADD CONSTRAINT uploads_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3594 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3597 ALTER TABLE ONLY uploads
3598 ADD CONSTRAINT uploads_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3602 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3605 ALTER TABLE ONLY users_emails
3606 ADD CONSTRAINT users_emails_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3610 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3613 ALTER TABLE ONLY users_permissions
3614 ADD CONSTRAINT users_permissions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3618 -- PostgreSQL database dump complete