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: builders_history_action; Type: TYPE; Schema: public; Owner: pakfire
32 CREATE TYPE builders_history_action
AS ENUM (
40 ALTER TYPE builders_history_action
OWNER TO pakfire
;
43 -- Name: builds_history_action; Type: TYPE; Schema: public; Owner: pakfire
46 CREATE TYPE builds_history_action
AS ENUM (
53 ALTER TYPE builds_history_action
OWNER TO pakfire
;
56 -- Name: builds_severity; Type: TYPE; Schema: public; Owner: pakfire
59 CREATE TYPE builds_severity
AS ENUM (
67 ALTER TYPE builds_severity
OWNER TO pakfire
;
70 -- Name: builds_type; Type: TYPE; Schema: public; Owner: pakfire
73 CREATE TYPE builds_type
AS ENUM (
79 ALTER TYPE builds_type
OWNER TO pakfire
;
82 -- Name: jobs_history_action; Type: TYPE; Schema: public; Owner: pakfire
85 CREATE TYPE jobs_history_action
AS ENUM (
94 ALTER TYPE jobs_history_action
OWNER TO pakfire
;
97 -- Name: jobs_history_state; Type: TYPE; Schema: public; Owner: pakfire
100 CREATE TYPE jobs_history_state
AS ENUM (
116 ALTER TYPE jobs_history_state
OWNER TO pakfire
;
119 -- Name: mirrors_history_action; Type: TYPE; Schema: public; Owner: pakfire
122 CREATE TYPE mirrors_history_action
AS ENUM (
130 ALTER TYPE mirrors_history_action
OWNER TO pakfire
;
133 -- Name: packages_deps_type; Type: TYPE; Schema: public; Owner: pakfire
136 CREATE TYPE packages_deps_type
AS ENUM (
147 ALTER TYPE packages_deps_type
OWNER TO pakfire
;
150 -- Name: packages_type; Type: TYPE; Schema: public; Owner: pakfire
153 CREATE TYPE packages_type
AS ENUM (
159 ALTER TYPE packages_type
OWNER TO pakfire
;
162 -- Name: repositories_aux_status; Type: TYPE; Schema: public; Owner: pakfire
165 CREATE TYPE repositories_aux_status
AS ENUM (
171 ALTER TYPE repositories_aux_status
OWNER TO pakfire
;
174 -- Name: repositories_history_action; Type: TYPE; Schema: public; Owner: pakfire
177 CREATE TYPE repositories_history_action
AS ENUM (
184 ALTER TYPE repositories_history_action
OWNER TO pakfire
;
187 -- Name: repositories_type; Type: TYPE; Schema: public; Owner: pakfire
190 CREATE TYPE repositories_type
AS ENUM (
197 ALTER TYPE repositories_type
OWNER TO pakfire
;
200 -- Name: sources_commits_state; Type: TYPE; Schema: public; Owner: pakfire
203 CREATE TYPE sources_commits_state
AS ENUM (
211 ALTER TYPE sources_commits_state
OWNER TO pakfire
;
214 -- Name: users_state; Type: TYPE; Schema: public; Owner: pakfire
217 CREATE TYPE users_state
AS ENUM (
224 ALTER TYPE users_state
OWNER TO pakfire
;
227 -- Name: on_update_current_timestamp_sources(); Type: FUNCTION; Schema: public; Owner: pakfire
230 CREATE FUNCTION on_update_current_timestamp_sources() RETURNS trigger
240 ALTER FUNCTION public.
on_update_current_timestamp_sources() OWNER TO pakfire
;
242 SET default_tablespace
= '';
244 SET default_with_oids
= false;
247 -- Name: arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
250 CREATE TABLE arches (
256 ALTER TABLE arches
OWNER TO pakfire
;
259 -- Name: arches_compat; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
262 CREATE TABLE arches_compat (
263 native_arch
text NOT NULL,
264 build_arch
text NOT NULL,
265 CONSTRAINT arches_compat_unique
CHECK ((native_arch
<> build_arch
))
269 ALTER TABLE arches_compat
OWNER TO pakfire
;
272 -- Name: arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
275 CREATE SEQUENCE arches_id_seq
283 ALTER TABLE arches_id_seq
OWNER TO pakfire
;
286 -- Name: arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
289 ALTER SEQUENCE arches_id_seq
OWNED BY arches.
id;
293 -- Name: builders; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
296 CREATE TABLE builders (
301 enabled
boolean DEFAULT false NOT NULL,
302 deleted
boolean DEFAULT false NOT NULL,
303 loadavg
text DEFAULT '0'::character varying NOT NULL,
304 testmode
boolean DEFAULT true NOT NULL,
305 max_jobs
bigint DEFAULT 1::bigint NOT NULL,
306 pakfire_version
text,
309 cpu_count
integer DEFAULT 1 NOT NULL,
311 cpu_bogomips
double precision,
312 memory
bigint DEFAULT 0 NOT NULL,
313 free_space
bigint DEFAULT 0 NOT NULL,
315 time_created
timestamp without time zone DEFAULT now() NOT NULL,
316 time_updated
timestamp without time zone,
317 time_keepalive
timestamp without time zone,
318 loadavg1
double precision,
319 loadavg5
double precision,
320 loadavg15
double precision,
329 ALTER TABLE builders
OWNER TO pakfire
;
332 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
335 CREATE TABLE builders_history (
337 builder_id
integer NOT NULL,
338 action builders_history_action
NOT NULL,
340 "time" timestamp without time zone NOT NULL
344 ALTER TABLE builders_history
OWNER TO pakfire
;
347 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
350 CREATE SEQUENCE builders_history_id_seq
358 ALTER TABLE builders_history_id_seq
OWNER TO pakfire
;
361 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
364 ALTER SEQUENCE builders_history_id_seq
OWNED BY builders_history.
id;
368 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
371 CREATE SEQUENCE builders_id_seq
379 ALTER TABLE builders_id_seq
OWNER TO pakfire
;
382 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
385 ALTER SEQUENCE builders_id_seq
OWNED BY builders.
id;
389 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
392 CREATE TABLE builds (
395 pkg_id
integer NOT NULL,
396 type builds_type
DEFAULT 'release'::builds_type NOT NULL,
397 state text DEFAULT 'building'::text NOT NULL,
398 severity builds_severity
,
400 time_created
timestamp without time zone DEFAULT now() NOT NULL,
404 distro_id
integer NOT NULL,
406 priority
integer DEFAULT 0 NOT NULL,
407 auto_move
boolean DEFAULT false NOT NULL
411 ALTER TABLE builds
OWNER TO pakfire
;
414 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
417 CREATE TABLE builds_bugs (
419 build_id
integer NOT NULL,
420 bug_id
integer NOT NULL
424 ALTER TABLE builds_bugs
OWNER TO pakfire
;
427 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
430 CREATE SEQUENCE builds_bugs_id_seq
438 ALTER TABLE builds_bugs_id_seq
OWNER TO pakfire
;
441 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
444 ALTER SEQUENCE builds_bugs_id_seq
OWNED BY builds_bugs.
id;
448 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
451 CREATE TABLE builds_bugs_updates (
453 bug_id
integer NOT NULL,
457 "time" timestamp without time zone NOT NULL,
458 error
boolean DEFAULT false NOT NULL,
463 ALTER TABLE builds_bugs_updates
OWNER TO pakfire
;
466 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
469 CREATE SEQUENCE builds_bugs_updates_id_seq
477 ALTER TABLE builds_bugs_updates_id_seq
OWNER TO pakfire
;
480 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
483 ALTER SEQUENCE builds_bugs_updates_id_seq
OWNED BY builds_bugs_updates.
id;
487 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
490 CREATE TABLE builds_comments (
492 build_id
integer NOT NULL,
493 user_id
integer NOT NULL,
495 score
integer NOT NULL,
496 time_created
timestamp without time zone DEFAULT now() NOT NULL,
497 time_updated
timestamp without time zone
501 ALTER TABLE builds_comments
OWNER TO pakfire
;
504 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
507 CREATE SEQUENCE builds_comments_id_seq
515 ALTER TABLE builds_comments_id_seq
OWNER TO pakfire
;
518 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
521 ALTER SEQUENCE builds_comments_id_seq
OWNED BY builds_comments.
id;
525 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
528 CREATE TABLE builds_history (
530 build_id
integer NOT NULL,
531 action builds_history_action
NOT NULL,
533 "time" timestamp without time zone NOT NULL,
538 ALTER TABLE builds_history
OWNER TO pakfire
;
541 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
544 CREATE SEQUENCE builds_history_id_seq
552 ALTER TABLE builds_history_id_seq
OWNER TO pakfire
;
555 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
558 ALTER SEQUENCE builds_history_id_seq
OWNED BY builds_history.
id;
562 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
565 CREATE SEQUENCE builds_id_seq
573 ALTER TABLE builds_id_seq
OWNER TO pakfire
;
576 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
579 ALTER SEQUENCE builds_id_seq
OWNED BY builds.
id;
583 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
589 build_id
integer NOT NULL,
590 state text DEFAULT 'pending'::text NOT NULL,
592 time_created
timestamp without time zone DEFAULT now() NOT NULL,
593 time_started
timestamp without time zone,
594 time_finished
timestamp without time zone,
595 start_not_before
timestamp without time zone,
597 aborted_state
integer DEFAULT 0 NOT NULL,
599 test
boolean DEFAULT true NOT NULL,
600 superseeded_by
integer,
601 dependency_check_succeeded
boolean,
602 dependency_check_at
timestamp without time zone,
603 CONSTRAINT jobs_states
CHECK ((state = ANY (ARRAY['pending'::text, 'dispatching'::text, 'running'::text, 'uploading'::text, 'finished'::text, 'aborted'::text, 'download_error'::text, 'failed'::text])))
607 ALTER TABLE jobs
OWNER TO pakfire
;
610 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
613 CREATE VIEW builds_times
AS
614 SELECT jobs.build_id
,
616 date_part('epoch'::text, (jobs.time_finished
- jobs.time_started
)) AS duration
618 WHERE ((jobs.test
IS FALSE) AND (jobs.
state = 'finished'::text));
621 ALTER TABLE builds_times
OWNER TO pakfire
;
624 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
627 CREATE TABLE builds_watchers (
629 build_id
integer NOT NULL,
630 user_id
integer NOT NULL
634 ALTER TABLE builds_watchers
OWNER TO pakfire
;
637 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
640 CREATE SEQUENCE builds_watchers_id_seq
648 ALTER TABLE builds_watchers_id_seq
OWNER TO pakfire
;
651 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
654 ALTER SEQUENCE builds_watchers_id_seq
OWNED BY builds_watchers.
id;
658 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
661 CREATE TABLE distributions (
665 slogan
text NOT NULL,
667 vendor
text NOT NULL,
670 deleted
boolean DEFAULT false NOT NULL
674 ALTER TABLE distributions
OWNER TO pakfire
;
677 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
680 CREATE TABLE distributions_arches (
682 distro_id
integer NOT NULL,
687 ALTER TABLE distributions_arches
OWNER TO pakfire
;
690 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
693 CREATE SEQUENCE distributions_id_seq
701 ALTER TABLE distributions_id_seq
OWNER TO pakfire
;
704 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
707 ALTER SEQUENCE distributions_id_seq
OWNED BY distributions.
id;
711 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
714 CREATE SEQUENCE distro_arches_id_seq
722 ALTER TABLE distro_arches_id_seq
OWNER TO pakfire
;
725 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
728 ALTER SEQUENCE distro_arches_id_seq
OWNED BY distributions_arches.
id;
732 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
735 CREATE TABLE filelists (
736 pkg_id
integer NOT NULL,
738 size bigint NOT NULL,
740 type integer NOT NULL,
741 config
boolean NOT NULL,
742 mode integer NOT NULL,
743 "user" text NOT NULL,
744 "group" text NOT NULL,
745 mtime
timestamp without time zone NOT NULL,
750 ALTER TABLE filelists
OWNER TO pakfire
;
753 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
756 CREATE TABLE images_types (
762 ALTER TABLE images_types
OWNER TO pakfire
;
765 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
768 CREATE SEQUENCE images_types_id_seq
776 ALTER TABLE images_types_id_seq
OWNER TO pakfire
;
779 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
782 ALTER SEQUENCE images_types_id_seq
OWNED BY images_types.
id;
786 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
789 CREATE TABLE jobs_buildroots (
790 job_id
integer NOT NULL,
791 pkg_uuid
text NOT NULL,
792 pkg_name
text NOT NULL
796 ALTER TABLE jobs_buildroots
OWNER TO pakfire
;
799 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
802 CREATE TABLE jobs_history (
803 job_id
integer NOT NULL,
804 action jobs_history_action
NOT NULL,
805 state jobs_history_state
,
807 "time" timestamp without time zone NOT NULL,
813 ALTER TABLE jobs_history
OWNER TO pakfire
;
816 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
819 CREATE SEQUENCE jobs_id_seq
827 ALTER TABLE jobs_id_seq
OWNER TO pakfire
;
830 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
833 ALTER SEQUENCE jobs_id_seq
OWNED BY jobs.
id;
837 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
840 CREATE TABLE jobs_packages (
842 job_id
integer NOT NULL,
843 pkg_id
integer NOT NULL
847 ALTER TABLE jobs_packages
OWNER TO pakfire
;
850 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
853 CREATE SEQUENCE jobs_packages_id_seq
861 ALTER TABLE jobs_packages_id_seq
OWNER TO pakfire
;
864 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
867 ALTER SEQUENCE jobs_packages_id_seq
OWNED BY jobs_packages.
id;
871 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
874 CREATE VIEW jobs_queue
AS
877 rank() OVER (ORDER BY (NOT jobs.test
), builds.priority
DESC, jobs.time_created
) AS rank
879 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
880 WHERE ((jobs.
state = 'pending'::text) AND (jobs.dependency_check_succeeded
IS TRUE))
882 SELECT queue.
id AS job_id
,
887 ALTER TABLE jobs_queue
OWNER TO pakfire
;
890 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
893 CREATE TABLE jobs_repos (
894 job_id
integer NOT NULL,
895 repo_id
integer NOT NULL
899 ALTER TABLE jobs_repos
OWNER TO pakfire
;
902 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
907 fingerprint
text NOT NULL,
913 ALTER TABLE keys
OWNER TO pakfire
;
916 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
919 CREATE SEQUENCE keys_id_seq
927 ALTER TABLE keys_id_seq
OWNER TO pakfire
;
930 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
933 ALTER SEQUENCE keys_id_seq
OWNED BY keys.
id;
937 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
940 CREATE TABLE keys_subkeys (
942 key_id
integer NOT NULL,
943 fingerprint
text NOT NULL,
944 time_created
timestamp without time zone NOT NULL,
945 time_expires
timestamp without time zone,
950 ALTER TABLE keys_subkeys
OWNER TO pakfire
;
953 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
956 CREATE SEQUENCE keys_subkeys_id_seq
964 ALTER TABLE keys_subkeys_id_seq
OWNER TO pakfire
;
967 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
970 ALTER SEQUENCE keys_subkeys_id_seq
OWNED BY keys_subkeys.
id;
974 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
977 CREATE TABLE logfiles (
979 job_id
integer NOT NULL,
981 filesize
bigint NOT NULL,
982 hash_sha512
text NOT NULL
986 ALTER TABLE logfiles
OWNER TO pakfire
;
989 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
992 CREATE SEQUENCE logfiles_id_seq
1000 ALTER TABLE logfiles_id_seq
OWNER TO pakfire
;
1003 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1006 ALTER SEQUENCE logfiles_id_seq
OWNED BY logfiles.
id;
1010 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1013 CREATE TABLE mirrors (
1014 id integer NOT NULL,
1015 hostname
text NOT NULL,
1019 deleted
boolean DEFAULT false NOT NULL,
1020 supports_https
boolean DEFAULT false NOT NULL
1024 ALTER TABLE mirrors
OWNER TO pakfire
;
1027 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1030 CREATE TABLE mirrors_checks (
1031 id integer NOT NULL,
1032 mirror_id
integer NOT NULL,
1033 "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
1034 response_time
double precision,
1035 http_status
integer,
1036 last_sync_at
timestamp without time zone,
1037 status
text DEFAULT 'OK'::text NOT NULL
1041 ALTER TABLE mirrors_checks
OWNER TO pakfire
;
1044 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1047 CREATE SEQUENCE mirrors_checks_id_seq
1055 ALTER TABLE mirrors_checks_id_seq
OWNER TO pakfire
;
1058 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1061 ALTER SEQUENCE mirrors_checks_id_seq
OWNED BY mirrors_checks.
id;
1065 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1068 CREATE TABLE mirrors_history (
1069 id integer NOT NULL,
1070 mirror_id
integer NOT NULL,
1071 action mirrors_history_action
NOT NULL,
1073 "time" timestamp without time zone NOT NULL
1077 ALTER TABLE mirrors_history
OWNER TO pakfire
;
1080 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1083 CREATE SEQUENCE mirrors_history_id_seq
1091 ALTER TABLE mirrors_history_id_seq
OWNER TO pakfire
;
1094 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1097 ALTER SEQUENCE mirrors_history_id_seq
OWNED BY mirrors_history.
id;
1101 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1104 CREATE SEQUENCE mirrors_id_seq
1112 ALTER TABLE mirrors_id_seq
OWNER TO pakfire
;
1115 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1118 ALTER SEQUENCE mirrors_id_seq
OWNED BY mirrors.
id;
1122 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1125 CREATE TABLE packages (
1126 id integer NOT NULL,
1128 epoch
integer NOT NULL,
1129 version text NOT NULL,
1130 release text NOT NULL,
1131 type packages_type
NOT NULL,
1133 groups
text NOT NULL,
1134 maintainer
text NOT NULL,
1135 license
text NOT NULL,
1137 summary
text NOT NULL,
1138 description
text NOT NULL,
1139 size bigint NOT NULL,
1140 supported_arches
text,
1143 build_id
text NOT NULL,
1144 build_host
text NOT NULL,
1145 build_time
timestamp without time zone NOT NULL,
1147 filesize
bigint NOT NULL,
1148 hash_sha512
text NOT NULL
1152 ALTER TABLE packages
OWNER TO pakfire
;
1155 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1158 CREATE TABLE packages_deps (
1159 pkg_id
integer NOT NULL,
1160 type packages_deps_type
NOT NULL,
1165 ALTER TABLE packages_deps
OWNER TO pakfire
;
1168 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1171 CREATE SEQUENCE packages_id_seq
1179 ALTER TABLE packages_id_seq
OWNER TO pakfire
;
1182 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1185 ALTER SEQUENCE packages_id_seq
OWNED BY packages.
id;
1189 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1192 CREATE TABLE packages_properties (
1193 id integer NOT NULL,
1195 critical_path
boolean DEFAULT false NOT NULL,
1196 priority
integer DEFAULT 0 NOT NULL
1200 ALTER TABLE packages_properties
OWNER TO pakfire
;
1203 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1206 CREATE SEQUENCE packages_properties_id_seq
1214 ALTER TABLE packages_properties_id_seq
OWNER TO pakfire
;
1217 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1220 ALTER SEQUENCE packages_properties_id_seq
OWNED BY packages_properties.
id;
1224 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1227 CREATE TABLE queue_delete (
1228 id integer NOT NULL,
1230 not_before
timestamp without time zone
1234 ALTER TABLE queue_delete
OWNER TO pakfire
;
1237 -- Name: queue_delete_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1240 CREATE SEQUENCE queue_delete_id_seq
1248 ALTER TABLE queue_delete_id_seq
OWNER TO pakfire
;
1251 -- Name: queue_delete_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1254 ALTER SEQUENCE queue_delete_id_seq
OWNED BY queue_delete.
id;
1258 -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: pakfire
1261 CREATE VIEW relation_sizes
AS
1262 SELECT c.relname
AS relation
,
1263 pg_size_pretty(pg_relation_size((c.oid
)::regclass)) AS size
1265 LEFT JOIN pg_namespace n
ON ((n.oid
= c.relnamespace
)))
1266 WHERE (n.nspname
<> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name]))
1267 ORDER BY pg_relation_size((c.oid
)::regclass) DESC;
1270 ALTER TABLE relation_sizes
OWNER TO pakfire
;
1273 -- Name: repositories; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1276 CREATE TABLE repositories (
1277 id integer NOT NULL,
1279 type repositories_type
DEFAULT 'testing'::repositories_type NOT NULL,
1280 description
text NOT NULL,
1281 distro_id
integer NOT NULL,
1284 mirrored
boolean DEFAULT false NOT NULL,
1285 enabled_for_builds
boolean DEFAULT false NOT NULL,
1286 score_needed
integer DEFAULT 0 NOT NULL,
1287 last_update
timestamp without time zone,
1288 time_min
integer DEFAULT 0 NOT NULL,
1289 time_max
integer DEFAULT 0 NOT NULL,
1290 deleted
boolean DEFAULT false NOT NULL,
1293 update_forced
boolean DEFAULT false NOT NULL
1297 ALTER TABLE repositories
OWNER TO pakfire
;
1300 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1303 CREATE TABLE repositories_aux (
1304 id integer NOT NULL,
1308 distro_id
integer NOT NULL,
1309 status repositories_aux_status
DEFAULT 'disabled'::repositories_aux_status NOT NULL
1313 ALTER TABLE repositories_aux
OWNER TO pakfire
;
1316 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1319 CREATE SEQUENCE repositories_aux_id_seq
1327 ALTER TABLE repositories_aux_id_seq
OWNER TO pakfire
;
1330 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1333 ALTER SEQUENCE repositories_aux_id_seq
OWNED BY repositories_aux.
id;
1337 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1340 CREATE TABLE repositories_builds (
1341 id integer NOT NULL,
1342 repo_id
integer NOT NULL,
1343 build_id
bigint NOT NULL,
1344 time_added
timestamp without time zone NOT NULL
1348 ALTER TABLE repositories_builds
OWNER TO pakfire
;
1351 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1354 CREATE SEQUENCE repositories_builds_id_seq
1362 ALTER TABLE repositories_builds_id_seq
OWNER TO pakfire
;
1365 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1368 ALTER SEQUENCE repositories_builds_id_seq
OWNED BY repositories_builds.
id;
1372 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1375 CREATE TABLE repositories_history (
1376 build_id
bigint NOT NULL,
1377 action repositories_history_action
NOT NULL,
1378 from_repo_id
integer,
1381 "time" timestamp without time zone NOT NULL
1385 ALTER TABLE repositories_history
OWNER TO pakfire
;
1388 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1391 CREATE SEQUENCE repositories_id_seq
1399 ALTER TABLE repositories_id_seq
OWNER TO pakfire
;
1402 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1405 ALTER SEQUENCE repositories_id_seq
OWNED BY repositories.
id;
1409 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1412 CREATE TABLE sessions (
1413 id integer NOT NULL,
1414 session_id
text NOT NULL,
1415 created_at
timestamp without time zone DEFAULT now() NOT NULL,
1416 valid_until
timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1417 user_id
integer NOT NULL,
1418 impersonated_user_id
integer,
1421 CONSTRAINT sessions_impersonation_check
CHECK (((impersonated_user_id
IS NULL) OR (user_id
<> impersonated_user_id
)))
1425 ALTER TABLE sessions
OWNER TO pakfire
;
1428 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1431 CREATE SEQUENCE sessions_id_seq
1439 ALTER TABLE sessions_id_seq
OWNER TO pakfire
;
1442 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1445 ALTER SEQUENCE sessions_id_seq
OWNED BY sessions.
id;
1449 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1452 CREATE TABLE settings (
1458 ALTER TABLE settings
OWNER TO pakfire
;
1461 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1464 CREATE TABLE sources (
1465 id integer NOT NULL,
1467 identifier
text NOT NULL,
1470 revision
text NOT NULL,
1471 branch
text NOT NULL,
1472 updated
timestamp without time zone,
1473 distro_id
integer NOT NULL
1477 ALTER TABLE sources
OWNER TO pakfire
;
1480 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1483 CREATE TABLE sources_commits (
1484 id integer NOT NULL,
1485 source_id
integer NOT NULL,
1486 revision
text NOT NULL,
1487 author
text NOT NULL,
1488 committer
text NOT NULL,
1489 subject
text NOT NULL,
1491 date timestamp without time zone NOT NULL,
1492 state sources_commits_state
DEFAULT 'pending'::sources_commits_state NOT NULL,
1493 imported_at
timestamp without time zone DEFAULT now() NOT NULL
1497 ALTER TABLE sources_commits
OWNER TO pakfire
;
1500 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1503 CREATE SEQUENCE sources_commits_id_seq
1511 ALTER TABLE sources_commits_id_seq
OWNER TO pakfire
;
1514 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1517 ALTER SEQUENCE sources_commits_id_seq
OWNED BY sources_commits.
id;
1521 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1524 CREATE SEQUENCE sources_id_seq
1532 ALTER TABLE sources_id_seq
OWNER TO pakfire
;
1535 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1538 ALTER SEQUENCE sources_id_seq
OWNED BY sources.
id;
1542 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1545 CREATE TABLE uploads (
1546 id integer NOT NULL,
1550 filename
text NOT NULL,
1552 size bigint NOT NULL,
1553 progress
bigint DEFAULT 0 NOT NULL,
1554 finished
boolean DEFAULT false NOT NULL,
1555 time_started
timestamp without time zone DEFAULT now() NOT NULL,
1556 time_finished
timestamp without time zone
1560 ALTER TABLE uploads
OWNER TO pakfire
;
1563 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1566 CREATE SEQUENCE uploads_id_seq
1574 ALTER TABLE uploads_id_seq
OWNER TO pakfire
;
1577 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1580 ALTER SEQUENCE uploads_id_seq
OWNED BY uploads.
id;
1584 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1587 CREATE TABLE user_messages (
1588 id integer NOT NULL,
1591 subject
text NOT NULL,
1593 time_added
timestamp without time zone DEFAULT now() NOT NULL
1597 ALTER TABLE user_messages
OWNER TO pakfire
;
1600 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1603 CREATE SEQUENCE user_messages_id_seq
1611 ALTER TABLE user_messages_id_seq
OWNER TO pakfire
;
1614 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1617 ALTER SEQUENCE user_messages_id_seq
OWNED BY user_messages.
id;
1621 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1624 CREATE TABLE users (
1625 id integer NOT NULL,
1629 state users_state
DEFAULT 'user'::users_state NOT NULL,
1632 activated
boolean DEFAULT false NOT NULL,
1633 deleted
boolean DEFAULT false NOT NULL,
1634 registered
timestamp without time zone DEFAULT now() NOT NULL,
1639 ALTER TABLE users
OWNER TO pakfire
;
1642 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1645 CREATE TABLE users_emails (
1646 id integer NOT NULL,
1647 user_id
integer NOT NULL,
1648 email
text NOT NULL,
1649 "primary" boolean DEFAULT false NOT NULL,
1650 activated
boolean DEFAULT false NOT NULL,
1651 activation_code
text
1655 ALTER TABLE users_emails
OWNER TO pakfire
;
1658 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1661 CREATE SEQUENCE users_emails_id_seq
1669 ALTER TABLE users_emails_id_seq
OWNER TO pakfire
;
1672 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1675 ALTER SEQUENCE users_emails_id_seq
OWNED BY users_emails.
id;
1679 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1682 CREATE SEQUENCE users_id_seq
1690 ALTER TABLE users_id_seq
OWNER TO pakfire
;
1693 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1696 ALTER SEQUENCE users_id_seq
OWNED BY users.
id;
1700 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1703 CREATE TABLE users_permissions (
1704 id integer NOT NULL,
1705 user_id
integer NOT NULL,
1706 create_scratch_builds
boolean DEFAULT false NOT NULL,
1707 maintain_builders
boolean DEFAULT false NOT NULL,
1708 manage_critical_path
boolean DEFAULT false NOT NULL,
1709 manage_mirrors
boolean DEFAULT false NOT NULL,
1710 vote
boolean DEFAULT false NOT NULL
1714 ALTER TABLE users_permissions
OWNER TO pakfire
;
1717 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1720 CREATE SEQUENCE users_permissions_id_seq
1728 ALTER TABLE users_permissions_id_seq
OWNER TO pakfire
;
1731 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1734 ALTER SEQUENCE users_permissions_id_seq
OWNED BY users_permissions.
id;
1738 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1741 ALTER TABLE ONLY arches
ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
1745 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1748 ALTER TABLE ONLY builders
ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
1752 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1755 ALTER TABLE ONLY builders_history
ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
1759 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1762 ALTER TABLE ONLY builds
ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
1766 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1769 ALTER TABLE ONLY builds_bugs
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
1773 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1776 ALTER TABLE ONLY builds_bugs_updates
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
1780 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1783 ALTER TABLE ONLY builds_comments
ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
1787 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1790 ALTER TABLE ONLY builds_history
ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
1794 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1797 ALTER TABLE ONLY builds_watchers
ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
1801 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1804 ALTER TABLE ONLY distributions
ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
1808 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1811 ALTER TABLE ONLY distributions_arches
ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
1815 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1818 ALTER TABLE ONLY images_types
ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
1822 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1825 ALTER TABLE ONLY jobs
ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
1829 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1832 ALTER TABLE ONLY jobs_packages
ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
1836 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1839 ALTER TABLE ONLY keys
ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
1843 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1846 ALTER TABLE ONLY keys_subkeys
ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
1850 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1853 ALTER TABLE ONLY logfiles
ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
1857 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1860 ALTER TABLE ONLY mirrors
ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
1864 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1867 ALTER TABLE ONLY mirrors_checks
ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
1871 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1874 ALTER TABLE ONLY mirrors_history
ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
1878 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1881 ALTER TABLE ONLY packages
ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
1885 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1888 ALTER TABLE ONLY packages_properties
ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
1892 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1895 ALTER TABLE ONLY queue_delete
ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
1899 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1902 ALTER TABLE ONLY repositories
ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
1906 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1909 ALTER TABLE ONLY repositories_aux
ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
1913 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1916 ALTER TABLE ONLY repositories_builds
ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
1920 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1923 ALTER TABLE ONLY sessions
ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
1927 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1930 ALTER TABLE ONLY sources
ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
1934 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1937 ALTER TABLE ONLY sources_commits
ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
1941 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1944 ALTER TABLE ONLY uploads
ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
1948 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1951 ALTER TABLE ONLY user_messages
ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
1955 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1958 ALTER TABLE ONLY users
ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
1962 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1965 ALTER TABLE ONLY users_emails
ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
1969 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1972 ALTER TABLE ONLY users_permissions
ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
1976 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1979 ALTER TABLE ONLY arches_compat
1980 ADD CONSTRAINT arches_compat_unique
UNIQUE (native_arch
, build_arch
);
1984 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1987 ALTER TABLE ONLY arches
1988 ADD CONSTRAINT arches_name
UNIQUE (name);
1992 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1995 ALTER TABLE ONLY arches
1996 ADD CONSTRAINT idx_2197943_primary
PRIMARY KEY (id);
2000 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2003 ALTER TABLE ONLY builders
2004 ADD CONSTRAINT idx_2197954_primary
PRIMARY KEY (id);
2008 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2011 ALTER TABLE ONLY builders_history
2012 ADD CONSTRAINT idx_2197982_primary
PRIMARY KEY (id);
2016 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2019 ALTER TABLE ONLY builds
2020 ADD CONSTRAINT idx_2197988_primary
PRIMARY KEY (id);
2024 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2027 ALTER TABLE ONLY builds_bugs
2028 ADD CONSTRAINT idx_2198002_primary
PRIMARY KEY (id);
2032 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2035 ALTER TABLE ONLY builds_bugs_updates
2036 ADD CONSTRAINT idx_2198008_primary
PRIMARY KEY (id);
2040 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2043 ALTER TABLE ONLY builds_comments
2044 ADD CONSTRAINT idx_2198018_primary
PRIMARY KEY (id);
2048 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2051 ALTER TABLE ONLY builds_history
2052 ADD CONSTRAINT idx_2198027_primary
PRIMARY KEY (id);
2056 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2059 ALTER TABLE ONLY builds_watchers
2060 ADD CONSTRAINT idx_2198033_primary
PRIMARY KEY (id);
2064 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2067 ALTER TABLE ONLY distributions
2068 ADD CONSTRAINT idx_2198039_primary
PRIMARY KEY (id);
2072 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2075 ALTER TABLE ONLY distributions_arches
2076 ADD CONSTRAINT idx_2198048_primary
PRIMARY KEY (id);
2080 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2083 ALTER TABLE ONLY images_types
2084 ADD CONSTRAINT idx_2198057_primary
PRIMARY KEY (id);
2088 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2091 ALTER TABLE ONLY jobs
2092 ADD CONSTRAINT idx_2198063_primary
PRIMARY KEY (id);
2096 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2099 ALTER TABLE ONLY jobs_packages
2100 ADD CONSTRAINT idx_2198085_primary
PRIMARY KEY (id);
2104 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2107 ALTER TABLE ONLY keys
2108 ADD CONSTRAINT idx_2198094_primary
PRIMARY KEY (id);
2112 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2115 ALTER TABLE ONLY keys_subkeys
2116 ADD CONSTRAINT idx_2198103_primary
PRIMARY KEY (id);
2120 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2123 ALTER TABLE ONLY logfiles
2124 ADD CONSTRAINT idx_2198109_primary
PRIMARY KEY (id);
2128 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2131 ALTER TABLE ONLY mirrors
2132 ADD CONSTRAINT idx_2198115_primary
PRIMARY KEY (id);
2136 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2139 ALTER TABLE ONLY mirrors_history
2140 ADD CONSTRAINT idx_2198126_primary
PRIMARY KEY (id);
2144 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2147 ALTER TABLE ONLY packages
2148 ADD CONSTRAINT idx_2198132_primary
PRIMARY KEY (id);
2152 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2155 ALTER TABLE ONLY packages_properties
2156 ADD CONSTRAINT idx_2198147_primary
PRIMARY KEY (id);
2160 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2163 ALTER TABLE ONLY queue_delete
2164 ADD CONSTRAINT idx_2198155_primary
PRIMARY KEY (id);
2168 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2171 ALTER TABLE ONLY repositories
2172 ADD CONSTRAINT idx_2198164_primary
PRIMARY KEY (id);
2176 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2179 ALTER TABLE ONLY repositories_aux
2180 ADD CONSTRAINT idx_2198179_primary
PRIMARY KEY (id);
2184 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2187 ALTER TABLE ONLY repositories_builds
2188 ADD CONSTRAINT idx_2198189_primary
PRIMARY KEY (id);
2192 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2195 ALTER TABLE ONLY sources
2196 ADD CONSTRAINT idx_2198213_primary
PRIMARY KEY (id);
2200 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2203 ALTER TABLE ONLY sources_commits
2204 ADD CONSTRAINT idx_2198222_primary
PRIMARY KEY (id);
2208 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2211 ALTER TABLE ONLY uploads
2212 ADD CONSTRAINT idx_2198232_primary
PRIMARY KEY (id);
2216 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2219 ALTER TABLE ONLY users
2220 ADD CONSTRAINT idx_2198244_primary
PRIMARY KEY (id);
2224 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2227 ALTER TABLE ONLY users_emails
2228 ADD CONSTRAINT idx_2198256_primary
PRIMARY KEY (id);
2232 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2235 ALTER TABLE ONLY users_permissions
2236 ADD CONSTRAINT idx_2198263_primary
PRIMARY KEY (id);
2240 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2243 ALTER TABLE ONLY user_messages
2244 ADD CONSTRAINT idx_2198274_primary
PRIMARY KEY (id);
2248 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2251 ALTER TABLE ONLY jobs_packages
2252 ADD CONSTRAINT jobs_packages_unique
UNIQUE (job_id
, pkg_id
);
2256 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2259 ALTER TABLE ONLY mirrors_checks
2260 ADD CONSTRAINT mirrors_checks_pkey
PRIMARY KEY (id);
2264 -- Name: repositories_builds_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2267 ALTER TABLE ONLY repositories_builds
2268 ADD CONSTRAINT repositories_builds_unique
UNIQUE (repo_id
, build_id
);
2272 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2275 ALTER TABLE ONLY sessions
2276 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (id);
2280 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2283 ALTER TABLE ONLY sessions
2284 ADD CONSTRAINT sessions_session_id_key
UNIQUE (session_id
);
2288 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2291 CREATE INDEX arches_compat_native_arch
ON arches_compat
USING btree (native_arch
);
2295 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2298 CREATE UNIQUE INDEX builders_name
ON builders
USING btree (name) WHERE (deleted
IS FALSE);
2302 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2305 CREATE INDEX builds_watchers_build_id
ON builds_watchers
USING btree (build_id
);
2309 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2312 CREATE INDEX distributions_arches_distro_id
ON distributions_arches
USING btree (distro_id
);
2316 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2319 CREATE UNIQUE INDEX distributions_sname
ON distributions
USING btree (sname
) WHERE (deleted
IS FALSE);
2323 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2326 CREATE INDEX filelists_name
ON filelists
USING btree (name);
2330 -- Name: filelists_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2333 CREATE INDEX filelists_pkg_id
ON filelists
USING btree (pkg_id
);
2335 ALTER TABLE filelists
CLUSTER ON filelists_pkg_id
;
2339 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2342 CREATE INDEX idx_2197982_builder_id
ON builders_history
USING btree (builder_id
);
2346 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2349 CREATE INDEX idx_2197988_pkg_id
ON builds
USING btree (pkg_id
);
2353 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2356 CREATE INDEX idx_2197988_state
ON builds
USING btree (state);
2360 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2363 CREATE INDEX idx_2197988_type
ON builds
USING btree (type);
2367 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2370 CREATE UNIQUE INDEX idx_2197988_uuid
ON builds
USING btree (uuid
);
2374 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2377 CREATE UNIQUE INDEX idx_2198002_build_id
ON builds_bugs
USING btree (build_id
, bug_id
);
2381 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2384 CREATE INDEX idx_2198018_build_id
ON builds_comments
USING btree (build_id
);
2388 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2391 CREATE INDEX idx_2198018_user_id
ON builds_comments
USING btree (user_id
);
2395 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2398 CREATE INDEX idx_2198063_build_id
ON jobs
USING btree (build_id
);
2402 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2405 CREATE INDEX idx_2198063_state
ON jobs
USING btree (state);
2409 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2412 CREATE UNIQUE INDEX idx_2198063_uuid
ON jobs
USING btree (uuid
);
2416 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2419 CREATE INDEX idx_2198080_job_id
ON jobs_history
USING btree (job_id
);
2423 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2426 CREATE UNIQUE INDEX idx_2198089_job_id
ON jobs_repos
USING btree (job_id
, repo_id
);
2430 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2433 CREATE UNIQUE INDEX idx_2198094_fingerprint
ON keys
USING btree (fingerprint
);
2437 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2440 CREATE INDEX idx_2198132_name
ON packages
USING btree (name);
2444 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2447 CREATE INDEX idx_2198132_type
ON packages
USING btree (type);
2451 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2454 CREATE INDEX idx_2198132_uuid
ON packages
USING btree (uuid
);
2458 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2461 CREATE INDEX idx_2198139_pkg_id
ON packages_deps
USING btree (pkg_id
);
2465 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2468 CREATE UNIQUE INDEX idx_2198147_name
ON packages_properties
USING btree (name);
2472 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2475 CREATE UNIQUE INDEX idx_2198189_build_id
ON repositories_builds
USING btree (build_id
);
2479 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2482 CREATE INDEX idx_2198193_build_id
ON repositories_history
USING btree (build_id
);
2486 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2489 CREATE UNIQUE INDEX idx_2198199_k
ON settings
USING btree (k
);
2493 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2496 CREATE UNIQUE INDEX idx_2198213_identifier
ON sources
USING btree (identifier
);
2500 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2503 CREATE INDEX idx_2198222_revision
ON sources_commits
USING btree (revision
);
2507 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2510 CREATE UNIQUE INDEX idx_2198232_uuid
ON uploads
USING btree (uuid
);
2514 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2517 CREATE UNIQUE INDEX idx_2198244_name
ON users
USING btree (name);
2521 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2524 CREATE UNIQUE INDEX idx_2198256_email
ON users_emails
USING btree (email
);
2528 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2531 CREATE INDEX idx_2198256_user_id
ON users_emails
USING btree (user_id
);
2535 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2538 CREATE INDEX jobs_arch
ON jobs
USING btree (arch
);
2542 -- Name: jobs_buildroots_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2545 CREATE INDEX jobs_buildroots_job_id
ON jobs_buildroots
USING btree (job_id
);
2547 ALTER TABLE jobs_buildroots
CLUSTER ON jobs_buildroots_job_id
;
2551 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2554 CREATE INDEX jobs_buildroots_pkg_uuid
ON jobs_buildroots
USING btree (pkg_uuid
);
2558 -- Name: jobs_queue_ready; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2561 CREATE INDEX jobs_queue_ready
ON jobs
USING btree (id) WHERE ((state = 'new'::text) AND (dependency_check_succeeded
IS TRUE));
2565 -- Name: jobs_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2568 CREATE INDEX jobs_time_finished
ON jobs
USING btree (time_finished
DESC) WHERE (time_finished
IS NOT NULL);
2572 -- Name: jobs_time_started; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2575 CREATE INDEX jobs_time_started
ON jobs
USING btree (time_started
) WHERE ((time_started
IS NOT NULL) AND (time_finished
IS NULL));
2579 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2582 CREATE INDEX mirrors_checks_sort
ON mirrors_checks
USING btree (mirror_id
, "timestamp");
2584 ALTER TABLE mirrors_checks
CLUSTER ON mirrors_checks_sort
;
2588 -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2591 CREATE INDEX repositories_builds_repo_id
ON repositories_builds
USING btree (repo_id
);
2595 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
2598 CREATE TRIGGER on_update_current_timestamp
BEFORE UPDATE ON sources
FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
2602 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2605 ALTER TABLE ONLY arches_compat
2606 ADD CONSTRAINT arches_compat_build_arch
FOREIGN KEY (build_arch
) REFERENCES arches(name);
2610 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2613 ALTER TABLE ONLY builders_history
2614 ADD CONSTRAINT builders_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2618 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2621 ALTER TABLE ONLY builders_history
2622 ADD CONSTRAINT builders_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2626 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2629 ALTER TABLE ONLY builds_bugs
2630 ADD CONSTRAINT builds_bug_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2634 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2637 ALTER TABLE ONLY builds_comments
2638 ADD CONSTRAINT builds_comments_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2642 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2645 ALTER TABLE ONLY builds_comments
2646 ADD CONSTRAINT builds_comments_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2650 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2653 ALTER TABLE ONLY builds
2654 ADD CONSTRAINT builds_depends_on
FOREIGN KEY (depends_on
) REFERENCES builds(id);
2658 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2661 ALTER TABLE ONLY builds
2662 ADD CONSTRAINT builds_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2666 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2669 ALTER TABLE ONLY builds_history
2670 ADD CONSTRAINT builds_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2674 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2677 ALTER TABLE ONLY builds_history
2678 ADD CONSTRAINT builds_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2682 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2685 ALTER TABLE ONLY builds
2686 ADD CONSTRAINT builds_owner_id
FOREIGN KEY (owner_id
) REFERENCES users(id);
2690 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2693 ALTER TABLE ONLY builds
2694 ADD CONSTRAINT builds_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
2698 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2701 ALTER TABLE ONLY builds_watchers
2702 ADD CONSTRAINT builds_watchers_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2706 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2709 ALTER TABLE ONLY builds_watchers
2710 ADD CONSTRAINT builds_watchers_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2714 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2717 ALTER TABLE ONLY distributions_arches
2718 ADD CONSTRAINT distributions_arches_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
2722 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2725 ALTER TABLE ONLY distributions_arches
2726 ADD CONSTRAINT distro_arches_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2730 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2733 ALTER TABLE ONLY filelists
2734 ADD CONSTRAINT filelists_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
2738 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2741 ALTER TABLE ONLY jobs
2742 ADD CONSTRAINT jobs_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
2746 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2749 ALTER TABLE ONLY jobs
2750 ADD CONSTRAINT jobs_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2754 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2757 ALTER TABLE ONLY jobs
2758 ADD CONSTRAINT jobs_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2762 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2765 ALTER TABLE ONLY jobs_buildroots
2766 ADD CONSTRAINT jobs_buildroots_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2770 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2773 ALTER TABLE ONLY jobs_history
2774 ADD CONSTRAINT jobs_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2778 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2781 ALTER TABLE ONLY jobs_history
2782 ADD CONSTRAINT jobs_history_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2786 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2789 ALTER TABLE ONLY jobs_history
2790 ADD CONSTRAINT jobs_history_test_job_id
FOREIGN KEY (test_job_id
) REFERENCES jobs(id);
2794 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2797 ALTER TABLE ONLY jobs_history
2798 ADD CONSTRAINT jobs_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2802 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2805 ALTER TABLE ONLY jobs_packages
2806 ADD CONSTRAINT jobs_packaged_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2810 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2813 ALTER TABLE ONLY jobs_packages
2814 ADD CONSTRAINT jobs_packages_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
2818 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2821 ALTER TABLE ONLY jobs_repos
2822 ADD CONSTRAINT jobs_repos_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2826 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2829 ALTER TABLE ONLY jobs_repos
2830 ADD CONSTRAINT jobs_repos_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
2834 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2837 ALTER TABLE ONLY keys_subkeys
2838 ADD CONSTRAINT keys_subkeys_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
2842 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2845 ALTER TABLE ONLY logfiles
2846 ADD CONSTRAINT logfiles_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2850 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2853 ALTER TABLE ONLY mirrors_checks
2854 ADD CONSTRAINT mirrors_checks_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
2858 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2861 ALTER TABLE ONLY mirrors_history
2862 ADD CONSTRAINT mirrors_history_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
2866 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2869 ALTER TABLE ONLY mirrors_history
2870 ADD CONSTRAINT mirrors_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2874 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2877 ALTER TABLE ONLY packages
2878 ADD CONSTRAINT packages_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
2882 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2885 ALTER TABLE ONLY packages
2886 ADD CONSTRAINT packages_commit_id
FOREIGN KEY (commit_id
) REFERENCES sources_commits(id);
2890 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2893 ALTER TABLE ONLY packages_deps
2894 ADD CONSTRAINT packages_deps_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
2898 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2901 ALTER TABLE ONLY repositories_aux
2902 ADD CONSTRAINT repositories_aux_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2906 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2909 ALTER TABLE ONLY repositories_builds
2910 ADD CONSTRAINT repositories_builds_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2914 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2917 ALTER TABLE ONLY repositories_builds
2918 ADD CONSTRAINT repositories_builds_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
2922 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2925 ALTER TABLE ONLY repositories
2926 ADD CONSTRAINT repositories_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2930 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2933 ALTER TABLE ONLY repositories_history
2934 ADD CONSTRAINT repositories_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2938 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2941 ALTER TABLE ONLY repositories_history
2942 ADD CONSTRAINT repositories_history_from_repo_id
FOREIGN KEY (from_repo_id
) REFERENCES repositories(id);
2946 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2949 ALTER TABLE ONLY repositories_history
2950 ADD CONSTRAINT repositories_history_to_repo_id
FOREIGN KEY (to_repo_id
) REFERENCES repositories(id);
2954 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2957 ALTER TABLE ONLY repositories_history
2958 ADD CONSTRAINT repositories_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2962 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2965 ALTER TABLE ONLY repositories
2966 ADD CONSTRAINT repositories_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
2970 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2973 ALTER TABLE ONLY repositories
2974 ADD CONSTRAINT repositories_parent_id
FOREIGN KEY (parent_id
) REFERENCES repositories(id);
2978 -- Name: repositories_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2981 ALTER TABLE ONLY repositories
2982 ADD CONSTRAINT repositories_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2986 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2989 ALTER TABLE ONLY sessions
2990 ADD CONSTRAINT sessions_impersonated_user_id
FOREIGN KEY (impersonated_user_id
) REFERENCES users(id);
2994 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2997 ALTER TABLE ONLY sessions
2998 ADD CONSTRAINT sessions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3002 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3005 ALTER TABLE ONLY sources_commits
3006 ADD CONSTRAINT sources_commits_source_id
FOREIGN KEY (source_id
) REFERENCES sources(id);
3010 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3013 ALTER TABLE ONLY sources
3014 ADD CONSTRAINT sources_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3018 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3021 ALTER TABLE ONLY uploads
3022 ADD CONSTRAINT uploads_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3026 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3029 ALTER TABLE ONLY uploads
3030 ADD CONSTRAINT uploads_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3034 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3037 ALTER TABLE ONLY users_emails
3038 ADD CONSTRAINT users_emails_user_id
FOREIGN KEY (user_id
) REFERENCES users(id) ON DELETE CASCADE;
3042 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3045 ALTER TABLE ONLY users_permissions
3046 ADD CONSTRAINT users_permissions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id) ON DELETE CASCADE;
3050 -- PostgreSQL database dump complete