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: on_update_current_timestamp_sources(); Type: FUNCTION; Schema: public; Owner: pakfire
32 CREATE FUNCTION on_update_current_timestamp_sources() RETURNS trigger
42 ALTER FUNCTION public.
on_update_current_timestamp_sources() OWNER TO pakfire
;
44 SET default_tablespace
= '';
46 SET default_with_oids
= false;
49 -- Name: arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
58 ALTER TABLE arches
OWNER TO pakfire
;
61 -- Name: arches_compat; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
64 CREATE TABLE arches_compat (
65 native_arch
text NOT NULL,
66 build_arch
text NOT NULL,
67 CONSTRAINT arches_compat_unique
CHECK ((native_arch
<> build_arch
))
71 ALTER TABLE arches_compat
OWNER TO pakfire
;
74 -- Name: arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
77 CREATE SEQUENCE arches_id_seq
85 ALTER TABLE arches_id_seq
OWNER TO pakfire
;
88 -- Name: arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
91 ALTER SEQUENCE arches_id_seq
OWNED BY arches.
id;
95 -- Name: builders; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
98 CREATE TABLE builders (
103 enabled
boolean DEFAULT false NOT NULL,
104 deleted
boolean DEFAULT false NOT NULL,
105 loadavg
text DEFAULT '0'::character varying NOT NULL,
106 testmode
boolean DEFAULT true NOT NULL,
107 max_jobs
bigint DEFAULT 1::bigint NOT NULL,
108 pakfire_version
text,
111 cpu_count
integer DEFAULT 1 NOT NULL,
113 cpu_bogomips
double precision,
114 memory
bigint DEFAULT 0 NOT NULL,
115 free_space
bigint DEFAULT 0 NOT NULL,
117 time_created
timestamp without time zone DEFAULT now() NOT NULL,
118 time_updated
timestamp without time zone,
119 time_keepalive
timestamp without time zone,
120 loadavg1
double precision,
121 loadavg5
double precision,
122 loadavg15
double precision,
128 online_until
timestamp without time zone
132 ALTER TABLE builders
OWNER TO pakfire
;
135 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
138 CREATE TABLE builders_history (
140 builder_id
integer NOT NULL,
141 action text NOT NULL,
143 "time" timestamp without time zone NOT NULL
147 ALTER TABLE builders_history
OWNER TO pakfire
;
150 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
153 CREATE SEQUENCE builders_history_id_seq
161 ALTER TABLE builders_history_id_seq
OWNER TO pakfire
;
164 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
167 ALTER SEQUENCE builders_history_id_seq
OWNED BY builders_history.
id;
171 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
174 CREATE SEQUENCE builders_id_seq
182 ALTER TABLE builders_id_seq
OWNER TO pakfire
;
185 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
188 ALTER SEQUENCE builders_id_seq
OWNED BY builders.
id;
192 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
195 CREATE TABLE builds (
198 pkg_id
integer NOT NULL,
199 type text DEFAULT 'release'::text NOT NULL,
200 state text DEFAULT 'building'::text NOT NULL,
203 time_created
timestamp without time zone DEFAULT now() NOT NULL,
207 distro_id
integer NOT NULL,
209 priority
integer DEFAULT 0 NOT NULL,
210 auto_move
boolean DEFAULT false NOT NULL
214 ALTER TABLE builds
OWNER TO pakfire
;
217 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
220 CREATE TABLE builds_bugs (
222 build_id
integer NOT NULL,
223 bug_id
integer NOT NULL
227 ALTER TABLE builds_bugs
OWNER TO pakfire
;
230 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
233 CREATE SEQUENCE builds_bugs_id_seq
241 ALTER TABLE builds_bugs_id_seq
OWNER TO pakfire
;
244 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
247 ALTER SEQUENCE builds_bugs_id_seq
OWNED BY builds_bugs.
id;
251 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
254 CREATE TABLE builds_bugs_updates (
256 bug_id
integer NOT NULL,
260 "time" timestamp without time zone NOT NULL,
261 error
boolean DEFAULT false NOT NULL,
266 ALTER TABLE builds_bugs_updates
OWNER TO pakfire
;
269 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
272 CREATE SEQUENCE builds_bugs_updates_id_seq
280 ALTER TABLE builds_bugs_updates_id_seq
OWNER TO pakfire
;
283 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
286 ALTER SEQUENCE builds_bugs_updates_id_seq
OWNED BY builds_bugs_updates.
id;
290 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
293 CREATE TABLE builds_comments (
295 build_id
integer NOT NULL,
296 user_id
integer NOT NULL,
298 score
integer NOT NULL,
299 time_created
timestamp without time zone DEFAULT now() NOT NULL,
300 time_updated
timestamp without time zone
304 ALTER TABLE builds_comments
OWNER TO pakfire
;
307 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
310 CREATE SEQUENCE builds_comments_id_seq
318 ALTER TABLE builds_comments_id_seq
OWNER TO pakfire
;
321 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
324 ALTER SEQUENCE builds_comments_id_seq
OWNED BY builds_comments.
id;
328 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
331 CREATE TABLE builds_history (
333 build_id
integer NOT NULL,
334 action text NOT NULL,
336 "time" timestamp without time zone NOT NULL,
341 ALTER TABLE builds_history
OWNER TO pakfire
;
344 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
347 CREATE SEQUENCE builds_history_id_seq
355 ALTER TABLE builds_history_id_seq
OWNER TO pakfire
;
358 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
361 ALTER SEQUENCE builds_history_id_seq
OWNED BY builds_history.
id;
365 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
368 CREATE SEQUENCE builds_id_seq
376 ALTER TABLE builds_id_seq
OWNER TO pakfire
;
379 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
382 ALTER SEQUENCE builds_id_seq
OWNED BY builds.
id;
386 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
392 build_id
integer NOT NULL,
393 state text DEFAULT 'pending'::text NOT NULL,
395 time_created
timestamp without time zone DEFAULT now() NOT NULL,
396 time_started
timestamp without time zone,
397 time_finished
timestamp without time zone,
398 start_not_before
timestamp without time zone,
400 aborted_state
integer DEFAULT 0 NOT NULL,
402 test
boolean DEFAULT true NOT NULL,
403 superseeded_by
integer,
404 dependency_check_succeeded
boolean,
405 dependency_check_at
timestamp without time zone,
406 CONSTRAINT jobs_states
CHECK ((state = ANY (ARRAY['pending'::text, 'dispatching'::text, 'running'::text, 'uploading'::text, 'finished'::text, 'aborted'::text, 'download_error'::text, 'failed'::text])))
410 ALTER TABLE jobs
OWNER TO pakfire
;
413 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
416 CREATE VIEW builds_times
AS
417 SELECT jobs.build_id
,
419 date_part('epoch'::text, (jobs.time_finished
- jobs.time_started
)) AS duration
421 WHERE ((jobs.test
IS FALSE) AND (jobs.
state = 'finished'::text));
424 ALTER TABLE builds_times
OWNER TO pakfire
;
427 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
430 CREATE TABLE builds_watchers (
432 build_id
integer NOT NULL,
433 user_id
integer NOT NULL
437 ALTER TABLE builds_watchers
OWNER TO pakfire
;
440 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
443 CREATE SEQUENCE builds_watchers_id_seq
451 ALTER TABLE builds_watchers_id_seq
OWNER TO pakfire
;
454 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
457 ALTER SEQUENCE builds_watchers_id_seq
OWNED BY builds_watchers.
id;
461 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
464 CREATE TABLE distributions (
468 slogan
text NOT NULL,
470 vendor
text NOT NULL,
473 deleted
boolean DEFAULT false NOT NULL
477 ALTER TABLE distributions
OWNER TO pakfire
;
480 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
483 CREATE TABLE distributions_arches (
485 distro_id
integer NOT NULL,
490 ALTER TABLE distributions_arches
OWNER TO pakfire
;
493 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
496 CREATE SEQUENCE distributions_id_seq
504 ALTER TABLE distributions_id_seq
OWNER TO pakfire
;
507 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
510 ALTER SEQUENCE distributions_id_seq
OWNED BY distributions.
id;
514 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
517 CREATE SEQUENCE distro_arches_id_seq
525 ALTER TABLE distro_arches_id_seq
OWNER TO pakfire
;
528 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
531 ALTER SEQUENCE distro_arches_id_seq
OWNED BY distributions_arches.
id;
535 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
538 CREATE TABLE filelists (
539 pkg_id
integer NOT NULL,
541 size bigint NOT NULL,
543 type integer NOT NULL,
544 config
boolean NOT NULL,
545 mode integer NOT NULL,
546 "user" text NOT NULL,
547 "group" text NOT NULL,
548 mtime
timestamp without time zone NOT NULL,
553 ALTER TABLE filelists
OWNER TO pakfire
;
556 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
559 CREATE TABLE images_types (
565 ALTER TABLE images_types
OWNER TO pakfire
;
568 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
571 CREATE SEQUENCE images_types_id_seq
579 ALTER TABLE images_types_id_seq
OWNER TO pakfire
;
582 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
585 ALTER SEQUENCE images_types_id_seq
OWNED BY images_types.
id;
589 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
592 CREATE TABLE jobs_buildroots (
593 job_id
integer NOT NULL,
594 pkg_uuid
text NOT NULL,
595 pkg_name
text NOT NULL
599 ALTER TABLE jobs_buildroots
OWNER TO pakfire
;
602 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
605 CREATE TABLE jobs_history (
606 job_id
integer NOT NULL,
607 action text NOT NULL,
610 "time" timestamp without time zone NOT NULL,
616 ALTER TABLE jobs_history
OWNER TO pakfire
;
619 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
622 CREATE SEQUENCE jobs_id_seq
630 ALTER TABLE jobs_id_seq
OWNER TO pakfire
;
633 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
636 ALTER SEQUENCE jobs_id_seq
OWNED BY jobs.
id;
640 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
643 CREATE TABLE jobs_packages (
645 job_id
integer NOT NULL,
646 pkg_id
integer NOT NULL
650 ALTER TABLE jobs_packages
OWNER TO pakfire
;
653 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
656 CREATE SEQUENCE jobs_packages_id_seq
664 ALTER TABLE jobs_packages_id_seq
OWNER TO pakfire
;
667 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
670 ALTER SEQUENCE jobs_packages_id_seq
OWNED BY jobs_packages.
id;
674 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
677 CREATE VIEW jobs_queue
AS
680 rank() OVER (ORDER BY (NOT jobs.test
), builds.priority
DESC, jobs.time_created
) AS rank
682 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
683 WHERE ((jobs.
state = 'pending'::text) AND (jobs.dependency_check_succeeded
IS TRUE))
685 SELECT queue.
id AS job_id
,
690 ALTER TABLE jobs_queue
OWNER TO pakfire
;
693 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
696 CREATE TABLE jobs_repos (
697 job_id
integer NOT NULL,
698 repo_id
integer NOT NULL
702 ALTER TABLE jobs_repos
OWNER TO pakfire
;
705 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
710 fingerprint
text NOT NULL,
716 ALTER TABLE keys
OWNER TO pakfire
;
719 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
722 CREATE SEQUENCE keys_id_seq
730 ALTER TABLE keys_id_seq
OWNER TO pakfire
;
733 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
736 ALTER SEQUENCE keys_id_seq
OWNED BY keys.
id;
740 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
743 CREATE TABLE keys_subkeys (
745 key_id
integer NOT NULL,
746 fingerprint
text NOT NULL,
747 time_created
timestamp without time zone NOT NULL,
748 time_expires
timestamp without time zone,
753 ALTER TABLE keys_subkeys
OWNER TO pakfire
;
756 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
759 CREATE SEQUENCE keys_subkeys_id_seq
767 ALTER TABLE keys_subkeys_id_seq
OWNER TO pakfire
;
770 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
773 ALTER SEQUENCE keys_subkeys_id_seq
OWNED BY keys_subkeys.
id;
777 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
780 CREATE TABLE logfiles (
782 job_id
integer NOT NULL,
784 filesize
bigint NOT NULL,
785 hash_sha512
text NOT NULL
789 ALTER TABLE logfiles
OWNER TO pakfire
;
792 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
795 CREATE SEQUENCE logfiles_id_seq
803 ALTER TABLE logfiles_id_seq
OWNER TO pakfire
;
806 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
809 ALTER SEQUENCE logfiles_id_seq
OWNED BY logfiles.
id;
813 -- Name: messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
816 CREATE TABLE messages (
818 message
text NOT NULL,
819 queued_at
timestamp without time zone DEFAULT now() NOT NULL,
820 sent_at
timestamp without time zone
824 ALTER TABLE messages
OWNER TO pakfire
;
827 -- Name: messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
830 CREATE SEQUENCE messages_id_seq
838 ALTER TABLE messages_id_seq
OWNER TO pakfire
;
841 -- Name: messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
844 ALTER SEQUENCE messages_id_seq
OWNED BY messages.
id;
848 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
851 CREATE TABLE mirrors (
853 hostname
text NOT NULL,
857 deleted
boolean DEFAULT false NOT NULL,
858 supports_https
boolean DEFAULT false NOT NULL
862 ALTER TABLE mirrors
OWNER TO pakfire
;
865 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
868 CREATE TABLE mirrors_checks (
870 mirror_id
integer NOT NULL,
871 "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
872 response_time
double precision,
874 last_sync_at
timestamp without time zone,
875 status
text DEFAULT 'OK'::text NOT NULL
879 ALTER TABLE mirrors_checks
OWNER TO pakfire
;
882 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
885 CREATE SEQUENCE mirrors_checks_id_seq
893 ALTER TABLE mirrors_checks_id_seq
OWNER TO pakfire
;
896 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
899 ALTER SEQUENCE mirrors_checks_id_seq
OWNED BY mirrors_checks.
id;
903 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
906 CREATE TABLE mirrors_history (
908 mirror_id
integer NOT NULL,
909 action text NOT NULL,
911 "time" timestamp without time zone NOT NULL
915 ALTER TABLE mirrors_history
OWNER TO pakfire
;
918 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
921 CREATE SEQUENCE mirrors_history_id_seq
929 ALTER TABLE mirrors_history_id_seq
OWNER TO pakfire
;
932 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
935 ALTER SEQUENCE mirrors_history_id_seq
OWNED BY mirrors_history.
id;
939 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
942 CREATE SEQUENCE mirrors_id_seq
950 ALTER TABLE mirrors_id_seq
OWNER TO pakfire
;
953 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
956 ALTER SEQUENCE mirrors_id_seq
OWNED BY mirrors.
id;
960 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
963 CREATE TABLE packages (
966 epoch
integer NOT NULL,
967 version text NOT NULL,
968 release text NOT NULL,
971 groups
text NOT NULL,
972 maintainer
text NOT NULL,
973 license
text NOT NULL,
975 summary
text NOT NULL,
976 description
text NOT NULL,
977 size bigint NOT NULL,
978 supported_arches
text,
981 build_id
text NOT NULL,
982 build_host
text NOT NULL,
983 build_time
timestamp without time zone NOT NULL,
985 filesize
bigint NOT NULL,
986 hash_sha512
text NOT NULL
990 ALTER TABLE packages
OWNER TO pakfire
;
993 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
996 CREATE TABLE packages_deps (
997 pkg_id
integer NOT NULL,
1003 ALTER TABLE packages_deps
OWNER TO pakfire
;
1006 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1009 CREATE SEQUENCE packages_id_seq
1017 ALTER TABLE packages_id_seq
OWNER TO pakfire
;
1020 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1023 ALTER SEQUENCE packages_id_seq
OWNED BY packages.
id;
1027 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1030 CREATE TABLE packages_properties (
1031 id integer NOT NULL,
1033 critical_path
boolean DEFAULT false NOT NULL,
1034 priority
integer DEFAULT 0 NOT NULL
1038 ALTER TABLE packages_properties
OWNER TO pakfire
;
1041 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1044 CREATE SEQUENCE packages_properties_id_seq
1052 ALTER TABLE packages_properties_id_seq
OWNER TO pakfire
;
1055 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1058 ALTER SEQUENCE packages_properties_id_seq
OWNED BY packages_properties.
id;
1062 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1065 CREATE TABLE queue_delete (
1066 id integer NOT NULL,
1068 not_before
timestamp without time zone
1072 ALTER TABLE queue_delete
OWNER TO pakfire
;
1075 -- Name: queue_delete_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1078 CREATE SEQUENCE queue_delete_id_seq
1086 ALTER TABLE queue_delete_id_seq
OWNER TO pakfire
;
1089 -- Name: queue_delete_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1092 ALTER SEQUENCE queue_delete_id_seq
OWNED BY queue_delete.
id;
1096 -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: pakfire
1099 CREATE VIEW relation_sizes
AS
1100 SELECT c.relname
AS relation
,
1101 pg_size_pretty(pg_relation_size((c.oid
)::regclass)) AS size
1103 LEFT JOIN pg_namespace n
ON ((n.oid
= c.relnamespace
)))
1104 WHERE (n.nspname
<> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name]))
1105 ORDER BY pg_relation_size((c.oid
)::regclass) DESC;
1108 ALTER TABLE relation_sizes
OWNER TO pakfire
;
1111 -- Name: repositories; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1114 CREATE TABLE repositories (
1115 id integer NOT NULL,
1117 type text DEFAULT 'testing'::text NOT NULL,
1118 description
text NOT NULL,
1119 distro_id
integer NOT NULL,
1122 mirrored
boolean DEFAULT false NOT NULL,
1123 enabled_for_builds
boolean DEFAULT false NOT NULL,
1124 score_needed
integer DEFAULT 0 NOT NULL,
1125 last_update
timestamp without time zone,
1126 time_min
integer DEFAULT 0 NOT NULL,
1127 time_max
integer DEFAULT 0 NOT NULL,
1128 deleted
boolean DEFAULT false NOT NULL,
1131 update_forced
boolean DEFAULT false NOT NULL
1135 ALTER TABLE repositories
OWNER TO pakfire
;
1138 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1141 CREATE TABLE repositories_aux (
1142 id integer NOT NULL,
1146 distro_id
integer NOT NULL,
1147 status
text DEFAULT 'disabled'::text NOT NULL
1151 ALTER TABLE repositories_aux
OWNER TO pakfire
;
1154 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1157 CREATE SEQUENCE repositories_aux_id_seq
1165 ALTER TABLE repositories_aux_id_seq
OWNER TO pakfire
;
1168 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1171 ALTER SEQUENCE repositories_aux_id_seq
OWNED BY repositories_aux.
id;
1175 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1178 CREATE TABLE repositories_builds (
1179 id integer NOT NULL,
1180 repo_id
integer NOT NULL,
1181 build_id
bigint NOT NULL,
1182 time_added
timestamp without time zone NOT NULL
1186 ALTER TABLE repositories_builds
OWNER TO pakfire
;
1189 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1192 CREATE SEQUENCE repositories_builds_id_seq
1200 ALTER TABLE repositories_builds_id_seq
OWNER TO pakfire
;
1203 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1206 ALTER SEQUENCE repositories_builds_id_seq
OWNED BY repositories_builds.
id;
1210 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1213 CREATE TABLE repositories_history (
1214 build_id
bigint NOT NULL,
1215 action text NOT NULL,
1216 from_repo_id
integer,
1219 "time" timestamp without time zone NOT NULL
1223 ALTER TABLE repositories_history
OWNER TO pakfire
;
1226 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1229 CREATE SEQUENCE repositories_id_seq
1237 ALTER TABLE repositories_id_seq
OWNER TO pakfire
;
1240 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1243 ALTER SEQUENCE repositories_id_seq
OWNED BY repositories.
id;
1247 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1250 CREATE TABLE sessions (
1251 id integer NOT NULL,
1252 session_id
text NOT NULL,
1253 created_at
timestamp without time zone DEFAULT now() NOT NULL,
1254 valid_until
timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1255 user_id
integer NOT NULL,
1256 impersonated_user_id
integer,
1259 CONSTRAINT sessions_impersonation_check
CHECK (((impersonated_user_id
IS NULL) OR (user_id
<> impersonated_user_id
)))
1263 ALTER TABLE sessions
OWNER TO pakfire
;
1266 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1269 CREATE SEQUENCE sessions_id_seq
1277 ALTER TABLE sessions_id_seq
OWNER TO pakfire
;
1280 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1283 ALTER SEQUENCE sessions_id_seq
OWNED BY sessions.
id;
1287 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1290 CREATE TABLE settings (
1296 ALTER TABLE settings
OWNER TO pakfire
;
1299 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1302 CREATE TABLE sources (
1303 id integer NOT NULL,
1305 identifier
text NOT NULL,
1308 revision
text NOT NULL,
1309 branch
text NOT NULL,
1310 updated
timestamp without time zone,
1311 distro_id
integer NOT NULL
1315 ALTER TABLE sources
OWNER TO pakfire
;
1318 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1321 CREATE TABLE sources_commits (
1322 id integer NOT NULL,
1323 source_id
integer NOT NULL,
1324 revision
text NOT NULL,
1325 author
text NOT NULL,
1326 committer
text NOT NULL,
1327 subject
text NOT NULL,
1329 date timestamp without time zone NOT NULL,
1330 state text DEFAULT 'pending'::text NOT NULL,
1331 imported_at
timestamp without time zone DEFAULT now() NOT NULL
1335 ALTER TABLE sources_commits
OWNER TO pakfire
;
1338 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1341 CREATE SEQUENCE sources_commits_id_seq
1349 ALTER TABLE sources_commits_id_seq
OWNER TO pakfire
;
1352 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1355 ALTER SEQUENCE sources_commits_id_seq
OWNED BY sources_commits.
id;
1359 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1362 CREATE SEQUENCE sources_id_seq
1370 ALTER TABLE sources_id_seq
OWNER TO pakfire
;
1373 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1376 ALTER SEQUENCE sources_id_seq
OWNED BY sources.
id;
1380 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1383 CREATE TABLE uploads (
1384 id integer NOT NULL,
1388 filename
text NOT NULL,
1390 size bigint NOT NULL,
1391 progress
bigint DEFAULT 0 NOT NULL,
1392 finished
boolean DEFAULT false NOT NULL,
1393 time_started
timestamp without time zone DEFAULT now() NOT NULL,
1394 time_finished
timestamp without time zone
1398 ALTER TABLE uploads
OWNER TO pakfire
;
1401 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1404 CREATE SEQUENCE uploads_id_seq
1412 ALTER TABLE uploads_id_seq
OWNER TO pakfire
;
1415 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1418 ALTER SEQUENCE uploads_id_seq
OWNED BY uploads.
id;
1422 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1425 CREATE TABLE users (
1426 id integer NOT NULL,
1432 activated
boolean DEFAULT false NOT NULL,
1433 deleted
boolean DEFAULT false NOT NULL,
1434 registered_at
timestamp without time zone DEFAULT now() NOT NULL,
1436 password_recovery_code
text,
1437 password_recovery_code_expires_at
timestamp without time zone,
1438 admin boolean DEFAULT false NOT NULL
1442 ALTER TABLE users
OWNER TO pakfire
;
1445 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1448 CREATE TABLE users_emails (
1449 id integer NOT NULL,
1450 user_id
integer NOT NULL,
1451 email
text NOT NULL,
1452 "primary" boolean DEFAULT false NOT NULL,
1453 activated
boolean DEFAULT false NOT NULL,
1454 activation_code
text
1458 ALTER TABLE users_emails
OWNER TO pakfire
;
1461 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1464 CREATE SEQUENCE users_emails_id_seq
1472 ALTER TABLE users_emails_id_seq
OWNER TO pakfire
;
1475 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1478 ALTER SEQUENCE users_emails_id_seq
OWNED BY users_emails.
id;
1482 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1485 CREATE SEQUENCE users_id_seq
1493 ALTER TABLE users_id_seq
OWNER TO pakfire
;
1496 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1499 ALTER SEQUENCE users_id_seq
OWNED BY users.
id;
1503 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1506 CREATE TABLE users_permissions (
1507 id integer NOT NULL,
1508 user_id
integer NOT NULL,
1509 create_scratch_builds
boolean DEFAULT false NOT NULL,
1510 maintain_builders
boolean DEFAULT false NOT NULL,
1511 manage_critical_path
boolean DEFAULT false NOT NULL,
1512 manage_mirrors
boolean DEFAULT false NOT NULL,
1513 vote
boolean DEFAULT false NOT NULL
1517 ALTER TABLE users_permissions
OWNER TO pakfire
;
1520 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1523 CREATE SEQUENCE users_permissions_id_seq
1531 ALTER TABLE users_permissions_id_seq
OWNER TO pakfire
;
1534 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1537 ALTER SEQUENCE users_permissions_id_seq
OWNED BY users_permissions.
id;
1541 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1544 ALTER TABLE ONLY arches
ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
1548 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1551 ALTER TABLE ONLY builders
ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
1555 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1558 ALTER TABLE ONLY builders_history
ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
1562 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1565 ALTER TABLE ONLY builds
ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
1569 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1572 ALTER TABLE ONLY builds_bugs
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
1576 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1579 ALTER TABLE ONLY builds_bugs_updates
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
1583 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1586 ALTER TABLE ONLY builds_comments
ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
1590 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1593 ALTER TABLE ONLY builds_history
ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
1597 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1600 ALTER TABLE ONLY builds_watchers
ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
1604 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1607 ALTER TABLE ONLY distributions
ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
1611 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1614 ALTER TABLE ONLY distributions_arches
ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
1618 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1621 ALTER TABLE ONLY images_types
ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
1625 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1628 ALTER TABLE ONLY jobs
ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
1632 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1635 ALTER TABLE ONLY jobs_packages
ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
1639 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1642 ALTER TABLE ONLY keys
ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
1646 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1649 ALTER TABLE ONLY keys_subkeys
ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
1653 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1656 ALTER TABLE ONLY logfiles
ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
1660 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1663 ALTER TABLE ONLY messages
ALTER COLUMN id SET DEFAULT nextval('messages_id_seq'::regclass);
1667 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1670 ALTER TABLE ONLY mirrors
ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
1674 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1677 ALTER TABLE ONLY mirrors_checks
ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
1681 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1684 ALTER TABLE ONLY mirrors_history
ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
1688 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1691 ALTER TABLE ONLY packages
ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
1695 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1698 ALTER TABLE ONLY packages_properties
ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
1702 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1705 ALTER TABLE ONLY queue_delete
ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
1709 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1712 ALTER TABLE ONLY repositories
ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
1716 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1719 ALTER TABLE ONLY repositories_aux
ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
1723 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1726 ALTER TABLE ONLY repositories_builds
ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
1730 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1733 ALTER TABLE ONLY sessions
ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
1737 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1740 ALTER TABLE ONLY sources
ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
1744 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1747 ALTER TABLE ONLY sources_commits
ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
1751 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1754 ALTER TABLE ONLY uploads
ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
1758 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1761 ALTER TABLE ONLY users
ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
1765 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1768 ALTER TABLE ONLY users_emails
ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
1772 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
1775 ALTER TABLE ONLY users_permissions
ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
1779 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1782 ALTER TABLE ONLY arches_compat
1783 ADD CONSTRAINT arches_compat_unique
UNIQUE (native_arch
, build_arch
);
1787 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1790 ALTER TABLE ONLY arches
1791 ADD CONSTRAINT arches_name
UNIQUE (name);
1795 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1798 ALTER TABLE ONLY arches
1799 ADD CONSTRAINT idx_2197943_primary
PRIMARY KEY (id);
1803 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1806 ALTER TABLE ONLY builders
1807 ADD CONSTRAINT idx_2197954_primary
PRIMARY KEY (id);
1811 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1814 ALTER TABLE ONLY builders_history
1815 ADD CONSTRAINT idx_2197982_primary
PRIMARY KEY (id);
1819 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1822 ALTER TABLE ONLY builds
1823 ADD CONSTRAINT idx_2197988_primary
PRIMARY KEY (id);
1827 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1830 ALTER TABLE ONLY builds_bugs
1831 ADD CONSTRAINT idx_2198002_primary
PRIMARY KEY (id);
1835 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1838 ALTER TABLE ONLY builds_bugs_updates
1839 ADD CONSTRAINT idx_2198008_primary
PRIMARY KEY (id);
1843 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1846 ALTER TABLE ONLY builds_comments
1847 ADD CONSTRAINT idx_2198018_primary
PRIMARY KEY (id);
1851 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1854 ALTER TABLE ONLY builds_history
1855 ADD CONSTRAINT idx_2198027_primary
PRIMARY KEY (id);
1859 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1862 ALTER TABLE ONLY builds_watchers
1863 ADD CONSTRAINT idx_2198033_primary
PRIMARY KEY (id);
1867 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1870 ALTER TABLE ONLY distributions
1871 ADD CONSTRAINT idx_2198039_primary
PRIMARY KEY (id);
1875 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1878 ALTER TABLE ONLY distributions_arches
1879 ADD CONSTRAINT idx_2198048_primary
PRIMARY KEY (id);
1883 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1886 ALTER TABLE ONLY images_types
1887 ADD CONSTRAINT idx_2198057_primary
PRIMARY KEY (id);
1891 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1894 ALTER TABLE ONLY jobs
1895 ADD CONSTRAINT idx_2198063_primary
PRIMARY KEY (id);
1899 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1902 ALTER TABLE ONLY jobs_packages
1903 ADD CONSTRAINT idx_2198085_primary
PRIMARY KEY (id);
1907 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1910 ALTER TABLE ONLY keys
1911 ADD CONSTRAINT idx_2198094_primary
PRIMARY KEY (id);
1915 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1918 ALTER TABLE ONLY keys_subkeys
1919 ADD CONSTRAINT idx_2198103_primary
PRIMARY KEY (id);
1923 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1926 ALTER TABLE ONLY logfiles
1927 ADD CONSTRAINT idx_2198109_primary
PRIMARY KEY (id);
1931 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1934 ALTER TABLE ONLY mirrors
1935 ADD CONSTRAINT idx_2198115_primary
PRIMARY KEY (id);
1939 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1942 ALTER TABLE ONLY mirrors_history
1943 ADD CONSTRAINT idx_2198126_primary
PRIMARY KEY (id);
1947 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1950 ALTER TABLE ONLY packages
1951 ADD CONSTRAINT idx_2198132_primary
PRIMARY KEY (id);
1955 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1958 ALTER TABLE ONLY packages_properties
1959 ADD CONSTRAINT idx_2198147_primary
PRIMARY KEY (id);
1963 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1966 ALTER TABLE ONLY queue_delete
1967 ADD CONSTRAINT idx_2198155_primary
PRIMARY KEY (id);
1971 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1974 ALTER TABLE ONLY repositories
1975 ADD CONSTRAINT idx_2198164_primary
PRIMARY KEY (id);
1979 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1982 ALTER TABLE ONLY repositories_aux
1983 ADD CONSTRAINT idx_2198179_primary
PRIMARY KEY (id);
1987 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1990 ALTER TABLE ONLY repositories_builds
1991 ADD CONSTRAINT idx_2198189_primary
PRIMARY KEY (id);
1995 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
1998 ALTER TABLE ONLY sources
1999 ADD CONSTRAINT idx_2198213_primary
PRIMARY KEY (id);
2003 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2006 ALTER TABLE ONLY sources_commits
2007 ADD CONSTRAINT idx_2198222_primary
PRIMARY KEY (id);
2011 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2014 ALTER TABLE ONLY uploads
2015 ADD CONSTRAINT idx_2198232_primary
PRIMARY KEY (id);
2019 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2022 ALTER TABLE ONLY users
2023 ADD CONSTRAINT idx_2198244_primary
PRIMARY KEY (id);
2027 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2030 ALTER TABLE ONLY users_emails
2031 ADD CONSTRAINT idx_2198256_primary
PRIMARY KEY (id);
2035 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2038 ALTER TABLE ONLY users_permissions
2039 ADD CONSTRAINT idx_2198263_primary
PRIMARY KEY (id);
2043 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2046 ALTER TABLE ONLY messages
2047 ADD CONSTRAINT idx_2198274_primary
PRIMARY KEY (id);
2051 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2054 ALTER TABLE ONLY jobs_packages
2055 ADD CONSTRAINT jobs_packages_unique
UNIQUE (job_id
, pkg_id
);
2059 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2062 ALTER TABLE ONLY mirrors_checks
2063 ADD CONSTRAINT mirrors_checks_pkey
PRIMARY KEY (id);
2067 -- Name: repositories_builds_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2070 ALTER TABLE ONLY repositories_builds
2071 ADD CONSTRAINT repositories_builds_unique
UNIQUE (repo_id
, build_id
);
2075 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2078 ALTER TABLE ONLY sessions
2079 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (id);
2083 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2086 ALTER TABLE ONLY sessions
2087 ADD CONSTRAINT sessions_session_id_key
UNIQUE (session_id
);
2091 -- Name: users_password_recovery_code; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2094 ALTER TABLE ONLY users
2095 ADD CONSTRAINT users_password_recovery_code
UNIQUE (password_recovery_code
);
2099 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2102 CREATE INDEX arches_compat_native_arch
ON arches_compat
USING btree (native_arch
);
2106 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2109 CREATE UNIQUE INDEX builders_name
ON builders
USING btree (name) WHERE (deleted
IS FALSE);
2113 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2116 CREATE INDEX builds_watchers_build_id
ON builds_watchers
USING btree (build_id
);
2120 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2123 CREATE INDEX distributions_arches_distro_id
ON distributions_arches
USING btree (distro_id
);
2127 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2130 CREATE UNIQUE INDEX distributions_sname
ON distributions
USING btree (sname
) WHERE (deleted
IS FALSE);
2134 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2137 CREATE INDEX filelists_name
ON filelists
USING btree (name);
2141 -- Name: filelists_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2144 CREATE INDEX filelists_pkg_id
ON filelists
USING btree (pkg_id
);
2146 ALTER TABLE filelists
CLUSTER ON filelists_pkg_id
;
2150 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2153 CREATE INDEX idx_2197982_builder_id
ON builders_history
USING btree (builder_id
);
2157 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2160 CREATE INDEX idx_2197988_pkg_id
ON builds
USING btree (pkg_id
);
2164 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2167 CREATE INDEX idx_2197988_state
ON builds
USING btree (state);
2171 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2174 CREATE INDEX idx_2197988_type
ON builds
USING btree (type);
2178 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2181 CREATE UNIQUE INDEX idx_2197988_uuid
ON builds
USING btree (uuid
);
2185 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2188 CREATE UNIQUE INDEX idx_2198002_build_id
ON builds_bugs
USING btree (build_id
, bug_id
);
2192 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2195 CREATE INDEX idx_2198018_build_id
ON builds_comments
USING btree (build_id
);
2199 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2202 CREATE INDEX idx_2198018_user_id
ON builds_comments
USING btree (user_id
);
2206 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2209 CREATE INDEX idx_2198063_build_id
ON jobs
USING btree (build_id
);
2213 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2216 CREATE INDEX idx_2198063_state
ON jobs
USING btree (state);
2220 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2223 CREATE UNIQUE INDEX idx_2198063_uuid
ON jobs
USING btree (uuid
);
2227 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2230 CREATE INDEX idx_2198080_job_id
ON jobs_history
USING btree (job_id
);
2234 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2237 CREATE UNIQUE INDEX idx_2198089_job_id
ON jobs_repos
USING btree (job_id
, repo_id
);
2241 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2244 CREATE UNIQUE INDEX idx_2198094_fingerprint
ON keys
USING btree (fingerprint
);
2248 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2251 CREATE INDEX idx_2198132_name
ON packages
USING btree (name);
2255 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2258 CREATE INDEX idx_2198132_type
ON packages
USING btree (type);
2262 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2265 CREATE INDEX idx_2198132_uuid
ON packages
USING btree (uuid
);
2269 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2272 CREATE INDEX idx_2198139_pkg_id
ON packages_deps
USING btree (pkg_id
);
2276 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2279 CREATE UNIQUE INDEX idx_2198147_name
ON packages_properties
USING btree (name);
2283 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2286 CREATE UNIQUE INDEX idx_2198189_build_id
ON repositories_builds
USING btree (build_id
);
2290 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2293 CREATE INDEX idx_2198193_build_id
ON repositories_history
USING btree (build_id
);
2297 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2300 CREATE UNIQUE INDEX idx_2198199_k
ON settings
USING btree (k
);
2304 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2307 CREATE UNIQUE INDEX idx_2198213_identifier
ON sources
USING btree (identifier
);
2311 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2314 CREATE INDEX idx_2198222_revision
ON sources_commits
USING btree (revision
);
2318 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2321 CREATE UNIQUE INDEX idx_2198232_uuid
ON uploads
USING btree (uuid
);
2325 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2328 CREATE UNIQUE INDEX idx_2198244_name
ON users
USING btree (name);
2332 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2335 CREATE UNIQUE INDEX idx_2198256_email
ON users_emails
USING btree (email
);
2339 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2342 CREATE INDEX idx_2198256_user_id
ON users_emails
USING btree (user_id
);
2346 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2349 CREATE INDEX jobs_arch
ON jobs
USING btree (arch
);
2353 -- Name: jobs_builders_active_jobs; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2356 CREATE INDEX jobs_builders_active_jobs
ON jobs
USING btree (builder_id
) WHERE (state = ANY (ARRAY['dispatching'::text, 'running'::text]));
2360 -- Name: jobs_buildroots_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2363 CREATE INDEX jobs_buildroots_job_id
ON jobs_buildroots
USING btree (job_id
);
2365 ALTER TABLE jobs_buildroots
CLUSTER ON jobs_buildroots_job_id
;
2369 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2372 CREATE INDEX jobs_buildroots_pkg_uuid
ON jobs_buildroots
USING btree (pkg_uuid
);
2376 -- Name: jobs_queue_ready; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2379 CREATE INDEX jobs_queue_ready
ON jobs
USING btree (id) WHERE ((state = 'new'::text) AND (dependency_check_succeeded
IS TRUE));
2383 -- Name: jobs_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2386 CREATE INDEX jobs_time_finished
ON jobs
USING btree (time_finished
DESC) WHERE (time_finished
IS NOT NULL);
2390 -- Name: jobs_time_started; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2393 CREATE INDEX jobs_time_started
ON jobs
USING btree (time_started
) WHERE ((time_started
IS NOT NULL) AND (time_finished
IS NULL));
2397 -- Name: messages_order; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2400 CREATE INDEX messages_order
ON messages
USING btree (queued_at
) WHERE (sent_at
IS NULL);
2404 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2407 CREATE INDEX mirrors_checks_sort
ON mirrors_checks
USING btree (mirror_id
, "timestamp");
2409 ALTER TABLE mirrors_checks
CLUSTER ON mirrors_checks_sort
;
2413 -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2416 CREATE INDEX repositories_builds_repo_id
ON repositories_builds
USING btree (repo_id
);
2420 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
2423 CREATE TRIGGER on_update_current_timestamp
BEFORE UPDATE ON sources
FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
2427 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2430 ALTER TABLE ONLY arches_compat
2431 ADD CONSTRAINT arches_compat_build_arch
FOREIGN KEY (build_arch
) REFERENCES arches(name);
2435 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2438 ALTER TABLE ONLY builders_history
2439 ADD CONSTRAINT builders_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2443 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2446 ALTER TABLE ONLY builders_history
2447 ADD CONSTRAINT builders_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2451 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2454 ALTER TABLE ONLY builds_bugs
2455 ADD CONSTRAINT builds_bug_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2459 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2462 ALTER TABLE ONLY builds_comments
2463 ADD CONSTRAINT builds_comments_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2467 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2470 ALTER TABLE ONLY builds_comments
2471 ADD CONSTRAINT builds_comments_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2475 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2478 ALTER TABLE ONLY builds
2479 ADD CONSTRAINT builds_depends_on
FOREIGN KEY (depends_on
) REFERENCES builds(id);
2483 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2486 ALTER TABLE ONLY builds
2487 ADD CONSTRAINT builds_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2491 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2494 ALTER TABLE ONLY builds_history
2495 ADD CONSTRAINT builds_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2499 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2502 ALTER TABLE ONLY builds_history
2503 ADD CONSTRAINT builds_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2507 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2510 ALTER TABLE ONLY builds
2511 ADD CONSTRAINT builds_owner_id
FOREIGN KEY (owner_id
) REFERENCES users(id);
2515 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2518 ALTER TABLE ONLY builds
2519 ADD CONSTRAINT builds_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
2523 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2526 ALTER TABLE ONLY builds_watchers
2527 ADD CONSTRAINT builds_watchers_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2531 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2534 ALTER TABLE ONLY builds_watchers
2535 ADD CONSTRAINT builds_watchers_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2539 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2542 ALTER TABLE ONLY distributions_arches
2543 ADD CONSTRAINT distributions_arches_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
2547 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2550 ALTER TABLE ONLY distributions_arches
2551 ADD CONSTRAINT distro_arches_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2555 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2558 ALTER TABLE ONLY filelists
2559 ADD CONSTRAINT filelists_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
2563 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2566 ALTER TABLE ONLY jobs
2567 ADD CONSTRAINT jobs_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
2571 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2574 ALTER TABLE ONLY jobs
2575 ADD CONSTRAINT jobs_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2579 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2582 ALTER TABLE ONLY jobs
2583 ADD CONSTRAINT jobs_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2587 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2590 ALTER TABLE ONLY jobs_buildroots
2591 ADD CONSTRAINT jobs_buildroots_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2595 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2598 ALTER TABLE ONLY jobs_history
2599 ADD CONSTRAINT jobs_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2603 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2606 ALTER TABLE ONLY jobs_history
2607 ADD CONSTRAINT jobs_history_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2611 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2614 ALTER TABLE ONLY jobs_history
2615 ADD CONSTRAINT jobs_history_test_job_id
FOREIGN KEY (test_job_id
) REFERENCES jobs(id);
2619 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2622 ALTER TABLE ONLY jobs_history
2623 ADD CONSTRAINT jobs_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2627 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2630 ALTER TABLE ONLY jobs_packages
2631 ADD CONSTRAINT jobs_packaged_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2635 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2638 ALTER TABLE ONLY jobs_packages
2639 ADD CONSTRAINT jobs_packages_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
2643 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2646 ALTER TABLE ONLY jobs_repos
2647 ADD CONSTRAINT jobs_repos_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2651 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2654 ALTER TABLE ONLY jobs_repos
2655 ADD CONSTRAINT jobs_repos_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
2659 -- Name: jobs_superseeded_by; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2662 ALTER TABLE ONLY jobs
2663 ADD CONSTRAINT jobs_superseeded_by
FOREIGN KEY (superseeded_by
) REFERENCES jobs(id);
2667 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2670 ALTER TABLE ONLY keys_subkeys
2671 ADD CONSTRAINT keys_subkeys_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
2675 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2678 ALTER TABLE ONLY logfiles
2679 ADD CONSTRAINT logfiles_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
2683 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2686 ALTER TABLE ONLY mirrors_checks
2687 ADD CONSTRAINT mirrors_checks_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
2691 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2694 ALTER TABLE ONLY mirrors_history
2695 ADD CONSTRAINT mirrors_history_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
2699 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2702 ALTER TABLE ONLY mirrors_history
2703 ADD CONSTRAINT mirrors_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2707 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2710 ALTER TABLE ONLY packages
2711 ADD CONSTRAINT packages_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
2715 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2718 ALTER TABLE ONLY packages
2719 ADD CONSTRAINT packages_commit_id
FOREIGN KEY (commit_id
) REFERENCES sources_commits(id);
2723 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2726 ALTER TABLE ONLY packages_deps
2727 ADD CONSTRAINT packages_deps_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
2731 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2734 ALTER TABLE ONLY repositories_aux
2735 ADD CONSTRAINT repositories_aux_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2739 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2742 ALTER TABLE ONLY repositories_builds
2743 ADD CONSTRAINT repositories_builds_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2747 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2750 ALTER TABLE ONLY repositories_builds
2751 ADD CONSTRAINT repositories_builds_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
2755 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2758 ALTER TABLE ONLY repositories
2759 ADD CONSTRAINT repositories_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2763 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2766 ALTER TABLE ONLY repositories_history
2767 ADD CONSTRAINT repositories_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2771 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2774 ALTER TABLE ONLY repositories_history
2775 ADD CONSTRAINT repositories_history_from_repo_id
FOREIGN KEY (from_repo_id
) REFERENCES repositories(id);
2779 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2782 ALTER TABLE ONLY repositories_history
2783 ADD CONSTRAINT repositories_history_to_repo_id
FOREIGN KEY (to_repo_id
) REFERENCES repositories(id);
2787 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2790 ALTER TABLE ONLY repositories_history
2791 ADD CONSTRAINT repositories_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2795 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2798 ALTER TABLE ONLY repositories
2799 ADD CONSTRAINT repositories_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
2803 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2806 ALTER TABLE ONLY repositories
2807 ADD CONSTRAINT repositories_parent_id
FOREIGN KEY (parent_id
) REFERENCES repositories(id);
2811 -- Name: repositories_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2814 ALTER TABLE ONLY repositories
2815 ADD CONSTRAINT repositories_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2819 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2822 ALTER TABLE ONLY sessions
2823 ADD CONSTRAINT sessions_impersonated_user_id
FOREIGN KEY (impersonated_user_id
) REFERENCES users(id);
2827 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2830 ALTER TABLE ONLY sessions
2831 ADD CONSTRAINT sessions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2835 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2838 ALTER TABLE ONLY sources_commits
2839 ADD CONSTRAINT sources_commits_source_id
FOREIGN KEY (source_id
) REFERENCES sources(id);
2843 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2846 ALTER TABLE ONLY sources
2847 ADD CONSTRAINT sources_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2851 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2854 ALTER TABLE ONLY uploads
2855 ADD CONSTRAINT uploads_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2859 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2862 ALTER TABLE ONLY uploads
2863 ADD CONSTRAINT uploads_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2867 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2870 ALTER TABLE ONLY users_emails
2871 ADD CONSTRAINT users_emails_user_id
FOREIGN KEY (user_id
) REFERENCES users(id) ON DELETE CASCADE;
2875 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2878 ALTER TABLE ONLY users_permissions
2879 ADD CONSTRAINT users_permissions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id) ON DELETE CASCADE;
2883 -- PostgreSQL database dump complete