2 -- PostgreSQL database dump
5 SET statement_timeout
= 0;
7 SET client_encoding
= 'UTF8';
8 SET standard_conforming_strings
= on;
9 SET check_function_bodies
= false;
10 SET client_min_messages
= warning
;
13 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
16 CREATE EXTENSION
IF NOT EXISTS plpgsql
WITH SCHEMA pg_catalog
;
20 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
23 COMMENT ON EXTENSION plpgsql
IS 'PL/pgSQL procedural language';
26 SET search_path
= public, pg_catalog
;
29 -- Name: arches_binary; Type: TYPE; Schema: public; Owner: pakfire
32 CREATE TYPE arches_binary
AS ENUM (
38 ALTER TYPE arches_binary
OWNER TO pakfire
;
41 -- Name: builders_disabled; Type: TYPE; Schema: public; Owner: pakfire
44 CREATE TYPE builders_disabled
AS ENUM (
50 ALTER TYPE builders_disabled
OWNER TO pakfire
;
53 -- Name: builders_history_action; Type: TYPE; Schema: public; Owner: pakfire
56 CREATE TYPE builders_history_action
AS ENUM (
64 ALTER TYPE builders_history_action
OWNER TO pakfire
;
67 -- Name: builders_overload; Type: TYPE; Schema: public; Owner: pakfire
70 CREATE TYPE builders_overload
AS ENUM (
76 ALTER TYPE builders_overload
OWNER TO pakfire
;
79 -- Name: builds_auto_move; Type: TYPE; Schema: public; Owner: pakfire
82 CREATE TYPE builds_auto_move
AS ENUM (
88 ALTER TYPE builds_auto_move
OWNER TO pakfire
;
91 -- Name: builds_history_action; Type: TYPE; Schema: public; Owner: pakfire
94 CREATE TYPE builds_history_action
AS ENUM (
101 ALTER TYPE builds_history_action
OWNER TO pakfire
;
104 -- Name: builds_severity; Type: TYPE; Schema: public; Owner: pakfire
107 CREATE TYPE builds_severity
AS ENUM (
115 ALTER TYPE builds_severity
OWNER TO pakfire
;
118 -- Name: builds_state; Type: TYPE; Schema: public; Owner: pakfire
121 CREATE TYPE builds_state
AS ENUM (
130 ALTER TYPE builds_state
OWNER TO pakfire
;
133 -- Name: builds_type; Type: TYPE; Schema: public; Owner: pakfire
136 CREATE TYPE builds_type
AS ENUM (
142 ALTER TYPE builds_type
OWNER TO pakfire
;
145 -- Name: filelists_config; Type: TYPE; Schema: public; Owner: pakfire
148 CREATE TYPE filelists_config
AS ENUM (
154 ALTER TYPE filelists_config
OWNER TO pakfire
;
157 -- Name: jobs_history_action; Type: TYPE; Schema: public; Owner: pakfire
160 CREATE TYPE jobs_history_action
AS ENUM (
169 ALTER TYPE jobs_history_action
OWNER TO pakfire
;
172 -- Name: jobs_history_state; Type: TYPE; Schema: public; Owner: pakfire
175 CREATE TYPE jobs_history_state
AS ENUM (
191 ALTER TYPE jobs_history_state
OWNER TO pakfire
;
194 -- Name: jobs_state; Type: TYPE; Schema: public; Owner: pakfire
197 CREATE TYPE jobs_state
AS ENUM (
213 ALTER TYPE jobs_state
OWNER TO pakfire
;
216 -- Name: jobs_type; Type: TYPE; Schema: public; Owner: pakfire
219 CREATE TYPE jobs_type
AS ENUM (
225 ALTER TYPE jobs_type
OWNER TO pakfire
;
228 -- Name: mirrors_history_action; Type: TYPE; Schema: public; Owner: pakfire
231 CREATE TYPE mirrors_history_action
AS ENUM (
239 ALTER TYPE mirrors_history_action
OWNER TO pakfire
;
242 -- Name: packages_deps_type; Type: TYPE; Schema: public; Owner: pakfire
245 CREATE TYPE packages_deps_type
AS ENUM (
256 ALTER TYPE packages_deps_type
OWNER TO pakfire
;
259 -- Name: packages_properties_critical_path; Type: TYPE; Schema: public; Owner: pakfire
262 CREATE TYPE packages_properties_critical_path
AS ENUM (
268 ALTER TYPE packages_properties_critical_path
OWNER TO pakfire
;
271 -- Name: packages_type; Type: TYPE; Schema: public; Owner: pakfire
274 CREATE TYPE packages_type
AS ENUM (
280 ALTER TYPE packages_type
OWNER TO pakfire
;
283 -- Name: repositories_aux_status; Type: TYPE; Schema: public; Owner: pakfire
286 CREATE TYPE repositories_aux_status
AS ENUM (
292 ALTER TYPE repositories_aux_status
OWNER TO pakfire
;
295 -- Name: repositories_enabled_for_builds; Type: TYPE; Schema: public; Owner: pakfire
298 CREATE TYPE repositories_enabled_for_builds
AS ENUM (
304 ALTER TYPE repositories_enabled_for_builds
OWNER TO pakfire
;
307 -- Name: repositories_history_action; Type: TYPE; Schema: public; Owner: pakfire
310 CREATE TYPE repositories_history_action
AS ENUM (
317 ALTER TYPE repositories_history_action
OWNER TO pakfire
;
320 -- Name: repositories_mirrored; Type: TYPE; Schema: public; Owner: pakfire
323 CREATE TYPE repositories_mirrored
AS ENUM (
329 ALTER TYPE repositories_mirrored
OWNER TO pakfire
;
332 -- Name: repositories_type; Type: TYPE; Schema: public; Owner: pakfire
335 CREATE TYPE repositories_type
AS ENUM (
342 ALTER TYPE repositories_type
OWNER TO pakfire
;
345 -- Name: sources_commits_state; Type: TYPE; Schema: public; Owner: pakfire
348 CREATE TYPE sources_commits_state
AS ENUM (
356 ALTER TYPE sources_commits_state
OWNER TO pakfire
;
359 -- Name: uploads_finished; Type: TYPE; Schema: public; Owner: pakfire
362 CREATE TYPE uploads_finished
AS ENUM (
368 ALTER TYPE uploads_finished
OWNER TO pakfire
;
371 -- Name: users_activated; Type: TYPE; Schema: public; Owner: pakfire
374 CREATE TYPE users_activated
AS ENUM (
380 ALTER TYPE users_activated
OWNER TO pakfire
;
383 -- Name: users_deleted; Type: TYPE; Schema: public; Owner: pakfire
386 CREATE TYPE users_deleted
AS ENUM (
392 ALTER TYPE users_deleted
OWNER TO pakfire
;
395 -- Name: users_emails_primary; Type: TYPE; Schema: public; Owner: pakfire
398 CREATE TYPE users_emails_primary
AS ENUM (
404 ALTER TYPE users_emails_primary
OWNER TO pakfire
;
407 -- Name: users_permissions_create_scratch_builds; Type: TYPE; Schema: public; Owner: pakfire
410 CREATE TYPE users_permissions_create_scratch_builds
AS ENUM (
416 ALTER TYPE users_permissions_create_scratch_builds
OWNER TO pakfire
;
419 -- Name: users_permissions_maintain_builders; Type: TYPE; Schema: public; Owner: pakfire
422 CREATE TYPE users_permissions_maintain_builders
AS ENUM (
428 ALTER TYPE users_permissions_maintain_builders
OWNER TO pakfire
;
431 -- Name: users_permissions_manage_critical_path; Type: TYPE; Schema: public; Owner: pakfire
434 CREATE TYPE users_permissions_manage_critical_path
AS ENUM (
440 ALTER TYPE users_permissions_manage_critical_path
OWNER TO pakfire
;
443 -- Name: users_permissions_manage_mirrors; Type: TYPE; Schema: public; Owner: pakfire
446 CREATE TYPE users_permissions_manage_mirrors
AS ENUM (
452 ALTER TYPE users_permissions_manage_mirrors
OWNER TO pakfire
;
455 -- Name: users_permissions_vote; Type: TYPE; Schema: public; Owner: pakfire
458 CREATE TYPE users_permissions_vote
AS ENUM (
464 ALTER TYPE users_permissions_vote
OWNER TO pakfire
;
467 -- Name: users_state; Type: TYPE; Schema: public; Owner: pakfire
470 CREATE TYPE users_state
AS ENUM (
477 ALTER TYPE users_state
OWNER TO pakfire
;
480 -- Name: on_update_current_timestamp_sources(); Type: FUNCTION; Schema: public; Owner: pakfire
483 CREATE FUNCTION on_update_current_timestamp_sources() RETURNS trigger
493 ALTER FUNCTION public.
on_update_current_timestamp_sources() OWNER TO pakfire
;
495 SET default_tablespace
= '';
497 SET default_with_oids
= false;
500 -- Name: arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
503 CREATE TABLE arches (
509 ALTER TABLE arches
OWNER TO pakfire
;
512 -- Name: arches_compat; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
515 CREATE TABLE arches_compat (
516 native_arch
text NOT NULL,
517 build_arch
text NOT NULL,
518 CONSTRAINT arches_compat_unique
CHECK ((native_arch
<> build_arch
))
522 ALTER TABLE arches_compat
OWNER TO pakfire
;
525 -- Name: arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
528 CREATE SEQUENCE arches_id_seq
536 ALTER TABLE arches_id_seq
OWNER TO pakfire
;
539 -- Name: arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
542 ALTER SEQUENCE arches_id_seq
OWNED BY arches.
id;
546 -- Name: builders; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
549 CREATE TABLE builders (
554 enabled
boolean DEFAULT false NOT NULL,
555 deleted
boolean DEFAULT false NOT NULL,
556 loadavg
text DEFAULT '0'::character varying NOT NULL,
557 testmode
boolean DEFAULT true NOT NULL,
558 max_jobs
bigint DEFAULT 1::bigint NOT NULL,
559 pakfire_version
text,
562 cpu_count
integer DEFAULT 1 NOT NULL,
564 cpu_bogomips
double precision,
565 memory
bigint DEFAULT 0 NOT NULL,
566 overload builders_overload
DEFAULT 'N'::builders_overload NOT NULL,
567 free_space
bigint DEFAULT 0 NOT NULL,
569 time_created
timestamp without time zone DEFAULT now() NOT NULL,
570 time_updated
timestamp without time zone,
571 time_keepalive
timestamp without time zone,
572 loadavg1
double precision,
573 loadavg5
double precision,
574 loadavg15
double precision,
583 ALTER TABLE builders
OWNER TO pakfire
;
586 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
589 CREATE TABLE builders_history (
591 builder_id
integer NOT NULL,
592 action builders_history_action
NOT NULL,
594 "time" timestamp without time zone NOT NULL
598 ALTER TABLE builders_history
OWNER TO pakfire
;
601 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
604 CREATE SEQUENCE builders_history_id_seq
612 ALTER TABLE builders_history_id_seq
OWNER TO pakfire
;
615 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
618 ALTER SEQUENCE builders_history_id_seq
OWNED BY builders_history.
id;
622 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
625 CREATE SEQUENCE builders_id_seq
633 ALTER TABLE builders_id_seq
OWNER TO pakfire
;
636 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
639 ALTER SEQUENCE builders_id_seq
OWNED BY builders.
id;
643 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
646 CREATE TABLE builds (
649 pkg_id
integer NOT NULL,
650 type builds_type
DEFAULT 'release'::builds_type NOT NULL,
651 state text DEFAULT 'building'::text NOT NULL,
652 severity builds_severity
,
654 time_created
timestamp without time zone DEFAULT now() NOT NULL,
658 distro_id
integer NOT NULL,
660 priority
integer DEFAULT 0 NOT NULL,
661 auto_move
boolean DEFAULT false NOT NULL
665 ALTER TABLE builds
OWNER TO pakfire
;
668 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
671 CREATE TABLE builds_bugs (
673 build_id
integer NOT NULL,
674 bug_id
integer NOT NULL
678 ALTER TABLE builds_bugs
OWNER TO pakfire
;
681 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
684 CREATE SEQUENCE builds_bugs_id_seq
692 ALTER TABLE builds_bugs_id_seq
OWNER TO pakfire
;
695 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
698 ALTER SEQUENCE builds_bugs_id_seq
OWNED BY builds_bugs.
id;
702 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
705 CREATE TABLE builds_bugs_updates (
707 bug_id
integer NOT NULL,
711 "time" timestamp without time zone NOT NULL,
712 error
boolean DEFAULT false NOT NULL,
717 ALTER TABLE builds_bugs_updates
OWNER TO pakfire
;
720 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
723 CREATE SEQUENCE builds_bugs_updates_id_seq
731 ALTER TABLE builds_bugs_updates_id_seq
OWNER TO pakfire
;
734 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
737 ALTER SEQUENCE builds_bugs_updates_id_seq
OWNED BY builds_bugs_updates.
id;
741 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
744 CREATE TABLE builds_comments (
746 build_id
integer NOT NULL,
747 user_id
integer NOT NULL,
749 score
integer NOT NULL,
750 time_created
timestamp without time zone NOT NULL,
751 time_updated
timestamp without time zone
755 ALTER TABLE builds_comments
OWNER TO pakfire
;
758 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
761 CREATE SEQUENCE builds_comments_id_seq
769 ALTER TABLE builds_comments_id_seq
OWNER TO pakfire
;
772 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
775 ALTER SEQUENCE builds_comments_id_seq
OWNED BY builds_comments.
id;
779 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
782 CREATE TABLE builds_history (
784 build_id
integer NOT NULL,
785 action builds_history_action
NOT NULL,
787 "time" timestamp without time zone NOT NULL,
792 ALTER TABLE builds_history
OWNER TO pakfire
;
795 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
798 CREATE SEQUENCE builds_history_id_seq
806 ALTER TABLE builds_history_id_seq
OWNER TO pakfire
;
809 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
812 ALTER SEQUENCE builds_history_id_seq
OWNED BY builds_history.
id;
816 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
819 CREATE SEQUENCE builds_id_seq
827 ALTER TABLE builds_id_seq
OWNER TO pakfire
;
830 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
833 ALTER SEQUENCE builds_id_seq
OWNED BY builds.
id;
837 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
843 build_id
integer NOT NULL,
844 state jobs_state
DEFAULT 'new'::jobs_state NOT NULL,
846 time_created
timestamp without time zone DEFAULT now() NOT NULL,
847 time_started
timestamp without time zone,
848 time_finished
timestamp without time zone,
849 start_not_before
timestamp without time zone,
851 aborted_state
integer DEFAULT 0 NOT NULL,
853 test
boolean DEFAULT true NOT NULL,
854 superseeded_by
integer,
855 deleted_at
timestamp without time zone
859 ALTER TABLE jobs
OWNER TO pakfire
;
862 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
865 CREATE VIEW builds_times
AS
866 SELECT jobs.build_id
,
868 (jobs.time_finished
- jobs.time_started
) AS duration
870 WHERE (((jobs.deleted_at
IS NULL) AND (jobs.test
IS FALSE)) AND (jobs.
state = 'finished'::jobs_state));
873 ALTER TABLE builds_times
OWNER TO pakfire
;
876 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
879 CREATE TABLE builds_watchers (
881 build_id
integer NOT NULL,
882 user_id
integer NOT NULL
886 ALTER TABLE builds_watchers
OWNER TO pakfire
;
889 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
892 CREATE SEQUENCE builds_watchers_id_seq
900 ALTER TABLE builds_watchers_id_seq
OWNER TO pakfire
;
903 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
906 ALTER SEQUENCE builds_watchers_id_seq
OWNED BY builds_watchers.
id;
910 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
913 CREATE TABLE distributions (
917 slogan
text NOT NULL,
919 vendor
text NOT NULL,
922 deleted
boolean DEFAULT false NOT NULL
926 ALTER TABLE distributions
OWNER TO pakfire
;
929 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
932 CREATE TABLE distributions_arches (
934 distro_id
integer NOT NULL,
939 ALTER TABLE distributions_arches
OWNER TO pakfire
;
942 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
945 CREATE SEQUENCE distributions_id_seq
953 ALTER TABLE distributions_id_seq
OWNER TO pakfire
;
956 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
959 ALTER SEQUENCE distributions_id_seq
OWNED BY distributions.
id;
963 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
966 CREATE SEQUENCE distro_arches_id_seq
974 ALTER TABLE distro_arches_id_seq
OWNER TO pakfire
;
977 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
980 ALTER SEQUENCE distro_arches_id_seq
OWNED BY distributions_arches.
id;
984 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
987 CREATE TABLE filelists (
988 pkg_id
integer NOT NULL,
990 size bigint NOT NULL,
992 type integer NOT NULL,
993 config
boolean NOT NULL,
994 mode integer NOT NULL,
995 "user" text NOT NULL,
996 "group" text NOT NULL,
997 mtime
timestamp without time zone NOT NULL,
1002 ALTER TABLE filelists
OWNER TO pakfire
;
1005 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1008 CREATE TABLE images_types (
1009 id integer NOT NULL,
1014 ALTER TABLE images_types
OWNER TO pakfire
;
1017 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1020 CREATE SEQUENCE images_types_id_seq
1028 ALTER TABLE images_types_id_seq
OWNER TO pakfire
;
1031 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1034 ALTER SEQUENCE images_types_id_seq
OWNED BY images_types.
id;
1038 -- Name: jobs_active; Type: VIEW; Schema: public; Owner: pakfire
1041 CREATE VIEW jobs_active
AS
1050 jobs.start_not_before
,
1055 WHERE (jobs.
state = ANY (ARRAY['dispatching'::jobs_state, 'running'::jobs_state, 'uploading'::jobs_state]))
1056 ORDER BY jobs.time_started
;
1059 ALTER TABLE jobs_active
OWNER TO pakfire
;
1062 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1065 CREATE TABLE jobs_buildroots (
1066 job_id
integer NOT NULL,
1067 pkg_uuid
text NOT NULL,
1068 pkg_name
text NOT NULL
1072 ALTER TABLE jobs_buildroots
OWNER TO pakfire
;
1075 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1078 CREATE TABLE jobs_history (
1079 job_id
integer NOT NULL,
1080 action jobs_history_action
NOT NULL,
1081 state jobs_history_state
,
1083 "time" timestamp without time zone NOT NULL,
1089 ALTER TABLE jobs_history
OWNER TO pakfire
;
1092 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1095 CREATE SEQUENCE jobs_id_seq
1103 ALTER TABLE jobs_id_seq
OWNER TO pakfire
;
1106 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1109 ALTER SEQUENCE jobs_id_seq
OWNED BY jobs.
id;
1113 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1116 CREATE TABLE jobs_packages (
1117 id integer NOT NULL,
1118 job_id
integer NOT NULL,
1119 pkg_id
integer NOT NULL
1123 ALTER TABLE jobs_packages
OWNER TO pakfire
;
1126 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1129 CREATE SEQUENCE jobs_packages_id_seq
1137 ALTER TABLE jobs_packages_id_seq
OWNER TO pakfire
;
1140 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1143 ALTER SEQUENCE jobs_packages_id_seq
OWNED BY jobs_packages.
id;
1147 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
1150 CREATE VIEW jobs_queue
AS
1153 rank() OVER (ORDER BY (NOT jobs.test
), builds.priority
DESC, jobs.time_created
) AS rank
1155 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
1156 WHERE (jobs.
state = 'pending'::jobs_state)
1158 SELECT queue.
id AS job_id
,
1163 ALTER TABLE jobs_queue
OWNER TO pakfire
;
1166 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1169 CREATE TABLE jobs_repos (
1170 job_id
integer NOT NULL,
1171 repo_id
integer NOT NULL
1175 ALTER TABLE jobs_repos
OWNER TO pakfire
;
1178 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1182 id integer NOT NULL,
1183 fingerprint
text NOT NULL,
1189 ALTER TABLE keys
OWNER TO pakfire
;
1192 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1195 CREATE SEQUENCE keys_id_seq
1203 ALTER TABLE keys_id_seq
OWNER TO pakfire
;
1206 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1209 ALTER SEQUENCE keys_id_seq
OWNED BY keys.
id;
1213 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1216 CREATE TABLE keys_subkeys (
1217 id integer NOT NULL,
1218 key_id
integer NOT NULL,
1219 fingerprint
text NOT NULL,
1220 time_created
timestamp without time zone NOT NULL,
1221 time_expires
timestamp without time zone,
1226 ALTER TABLE keys_subkeys
OWNER TO pakfire
;
1229 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1232 CREATE SEQUENCE keys_subkeys_id_seq
1240 ALTER TABLE keys_subkeys_id_seq
OWNER TO pakfire
;
1243 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1246 ALTER SEQUENCE keys_subkeys_id_seq
OWNED BY keys_subkeys.
id;
1250 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1253 CREATE TABLE logfiles (
1254 id integer NOT NULL,
1255 job_id
integer NOT NULL,
1257 filesize
bigint NOT NULL,
1258 hash_sha512
text NOT NULL
1262 ALTER TABLE logfiles
OWNER TO pakfire
;
1265 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1268 CREATE SEQUENCE logfiles_id_seq
1276 ALTER TABLE logfiles_id_seq
OWNER TO pakfire
;
1279 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1282 ALTER SEQUENCE logfiles_id_seq
OWNED BY logfiles.
id;
1286 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1289 CREATE TABLE mirrors (
1290 id integer NOT NULL,
1291 hostname
text NOT NULL,
1295 deleted
boolean DEFAULT false NOT NULL
1299 ALTER TABLE mirrors
OWNER TO pakfire
;
1302 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1305 CREATE TABLE mirrors_checks (
1306 id integer NOT NULL,
1307 mirror_id
integer NOT NULL,
1308 "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
1309 response_time
double precision,
1310 http_status
integer,
1311 last_sync_at
timestamp without time zone,
1312 status
text DEFAULT 'OK'::text NOT NULL
1316 ALTER TABLE mirrors_checks
OWNER TO pakfire
;
1319 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1322 CREATE SEQUENCE mirrors_checks_id_seq
1330 ALTER TABLE mirrors_checks_id_seq
OWNER TO pakfire
;
1333 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1336 ALTER SEQUENCE mirrors_checks_id_seq
OWNED BY mirrors_checks.
id;
1340 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1343 CREATE TABLE mirrors_history (
1344 id integer NOT NULL,
1345 mirror_id
integer NOT NULL,
1346 action mirrors_history_action
NOT NULL,
1348 "time" timestamp without time zone NOT NULL
1352 ALTER TABLE mirrors_history
OWNER TO pakfire
;
1355 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1358 CREATE SEQUENCE mirrors_history_id_seq
1366 ALTER TABLE mirrors_history_id_seq
OWNER TO pakfire
;
1369 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1372 ALTER SEQUENCE mirrors_history_id_seq
OWNED BY mirrors_history.
id;
1376 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1379 CREATE SEQUENCE mirrors_id_seq
1387 ALTER TABLE mirrors_id_seq
OWNER TO pakfire
;
1390 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1393 ALTER SEQUENCE mirrors_id_seq
OWNED BY mirrors.
id;
1397 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1400 CREATE TABLE packages (
1401 id integer NOT NULL,
1403 epoch
integer NOT NULL,
1404 version text NOT NULL,
1405 release text NOT NULL,
1406 type packages_type
NOT NULL,
1408 groups
text NOT NULL,
1409 maintainer
text NOT NULL,
1410 license
text NOT NULL,
1412 summary
text NOT NULL,
1413 description
text NOT NULL,
1414 size bigint NOT NULL,
1415 supported_arches
text,
1418 build_id
text NOT NULL,
1419 build_host
text NOT NULL,
1420 build_time
timestamp without time zone NOT NULL,
1422 filesize
bigint NOT NULL,
1423 hash_sha512
text NOT NULL
1427 ALTER TABLE packages
OWNER TO pakfire
;
1430 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1433 CREATE TABLE packages_deps (
1434 pkg_id
integer NOT NULL,
1435 type packages_deps_type
NOT NULL,
1440 ALTER TABLE packages_deps
OWNER TO pakfire
;
1443 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1446 CREATE SEQUENCE packages_id_seq
1454 ALTER TABLE packages_id_seq
OWNER TO pakfire
;
1457 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1460 ALTER SEQUENCE packages_id_seq
OWNED BY packages.
id;
1464 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1467 CREATE TABLE packages_properties (
1468 id integer NOT NULL,
1470 critical_path packages_properties_critical_path
DEFAULT 'N'::packages_properties_critical_path NOT NULL,
1471 priority
integer DEFAULT 0 NOT NULL
1475 ALTER TABLE packages_properties
OWNER TO pakfire
;
1478 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1481 CREATE SEQUENCE packages_properties_id_seq
1489 ALTER TABLE packages_properties_id_seq
OWNER TO pakfire
;
1492 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1495 ALTER SEQUENCE packages_properties_id_seq
OWNED BY packages_properties.
id;
1499 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1502 CREATE TABLE queue_delete (
1503 id integer NOT NULL,
1508 ALTER TABLE queue_delete
OWNER TO pakfire
;
1511 -- Name: queue_delete_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1514 CREATE SEQUENCE queue_delete_id_seq
1522 ALTER TABLE queue_delete_id_seq
OWNER TO pakfire
;
1525 -- Name: queue_delete_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1528 ALTER SEQUENCE queue_delete_id_seq
OWNED BY queue_delete.
id;
1532 -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: pakfire
1535 CREATE VIEW relation_sizes
AS
1536 SELECT c.relname
AS relation
,
1537 pg_size_pretty(pg_relation_size((c.oid
)::regclass)) AS size
1539 LEFT JOIN pg_namespace n
ON ((n.oid
= c.relnamespace
)))
1540 WHERE (n.nspname
<> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name]))
1541 ORDER BY pg_relation_size((c.oid
)::regclass) DESC;
1544 ALTER TABLE relation_sizes
OWNER TO pakfire
;
1547 -- Name: repositories; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1550 CREATE TABLE repositories (
1551 id integer NOT NULL,
1553 type repositories_type
DEFAULT 'testing'::repositories_type NOT NULL,
1554 description
text NOT NULL,
1555 distro_id
integer NOT NULL,
1558 mirrored
boolean DEFAULT false NOT NULL,
1559 enabled_for_builds
boolean DEFAULT false NOT NULL,
1560 score_needed
integer DEFAULT 0 NOT NULL,
1561 last_update
timestamp without time zone,
1562 time_min
integer DEFAULT 0 NOT NULL,
1563 time_max
integer DEFAULT 0 NOT NULL,
1564 update_started
timestamp without time zone,
1565 update_ended
timestamp without time zone,
1566 deleted
boolean DEFAULT false NOT NULL
1570 ALTER TABLE repositories
OWNER TO pakfire
;
1573 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1576 CREATE TABLE repositories_aux (
1577 id integer NOT NULL,
1581 distro_id
integer NOT NULL,
1582 status repositories_aux_status
DEFAULT 'disabled'::repositories_aux_status NOT NULL
1586 ALTER TABLE repositories_aux
OWNER TO pakfire
;
1589 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1592 CREATE SEQUENCE repositories_aux_id_seq
1600 ALTER TABLE repositories_aux_id_seq
OWNER TO pakfire
;
1603 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1606 ALTER SEQUENCE repositories_aux_id_seq
OWNED BY repositories_aux.
id;
1610 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1613 CREATE TABLE repositories_builds (
1614 id integer NOT NULL,
1615 repo_id
integer NOT NULL,
1616 build_id
bigint NOT NULL,
1617 time_added
timestamp without time zone NOT NULL
1621 ALTER TABLE repositories_builds
OWNER TO pakfire
;
1624 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1627 CREATE SEQUENCE repositories_builds_id_seq
1635 ALTER TABLE repositories_builds_id_seq
OWNER TO pakfire
;
1638 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1641 ALTER SEQUENCE repositories_builds_id_seq
OWNED BY repositories_builds.
id;
1645 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1648 CREATE TABLE repositories_history (
1649 build_id
bigint NOT NULL,
1650 action repositories_history_action
NOT NULL,
1651 from_repo_id
integer,
1654 "time" timestamp without time zone NOT NULL
1658 ALTER TABLE repositories_history
OWNER TO pakfire
;
1661 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1664 CREATE SEQUENCE repositories_id_seq
1672 ALTER TABLE repositories_id_seq
OWNER TO pakfire
;
1675 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1678 ALTER SEQUENCE repositories_id_seq
OWNED BY repositories.
id;
1682 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1685 CREATE TABLE sessions (
1686 id integer NOT NULL,
1687 session_id
text NOT NULL,
1688 created_at
timestamp without time zone DEFAULT now() NOT NULL,
1689 valid_until
timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1690 user_id
integer NOT NULL,
1691 impersonated_user_id
integer,
1694 CONSTRAINT sessions_impersonation_check
CHECK (((impersonated_user_id
IS NULL) OR (user_id
<> impersonated_user_id
)))
1698 ALTER TABLE sessions
OWNER TO pakfire
;
1701 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1704 CREATE SEQUENCE sessions_id_seq
1712 ALTER TABLE sessions_id_seq
OWNER TO pakfire
;
1715 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1718 ALTER SEQUENCE sessions_id_seq
OWNED BY sessions.
id;
1722 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1725 CREATE TABLE settings (
1731 ALTER TABLE settings
OWNER TO pakfire
;
1734 -- Name: slogans; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1737 CREATE TABLE slogans (
1738 id integer NOT NULL,
1739 message
text NOT NULL
1743 ALTER TABLE slogans
OWNER TO pakfire
;
1746 -- Name: slogans_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1749 CREATE SEQUENCE slogans_id_seq
1757 ALTER TABLE slogans_id_seq
OWNER TO pakfire
;
1760 -- Name: slogans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1763 ALTER SEQUENCE slogans_id_seq
OWNED BY slogans.
id;
1767 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1770 CREATE TABLE sources (
1771 id integer NOT NULL,
1773 identifier
text NOT NULL,
1776 revision
text NOT NULL,
1777 branch
text NOT NULL,
1778 updated
timestamp without time zone,
1779 distro_id
integer NOT NULL
1783 ALTER TABLE sources
OWNER TO pakfire
;
1786 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1789 CREATE TABLE sources_commits (
1790 id integer NOT NULL,
1791 source_id
integer NOT NULL,
1792 revision
text NOT NULL,
1793 author
text NOT NULL,
1794 committer
text NOT NULL,
1795 subject
text NOT NULL,
1797 date timestamp without time zone NOT NULL,
1798 state sources_commits_state
DEFAULT 'pending'::sources_commits_state NOT NULL,
1799 imported_at
timestamp without time zone DEFAULT now() NOT NULL
1803 ALTER TABLE sources_commits
OWNER TO pakfire
;
1806 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1809 CREATE SEQUENCE sources_commits_id_seq
1817 ALTER TABLE sources_commits_id_seq
OWNER TO pakfire
;
1820 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1823 ALTER SEQUENCE sources_commits_id_seq
OWNED BY sources_commits.
id;
1827 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1830 CREATE SEQUENCE sources_id_seq
1838 ALTER TABLE sources_id_seq
OWNER TO pakfire
;
1841 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1844 ALTER SEQUENCE sources_id_seq
OWNED BY sources.
id;
1848 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1851 CREATE TABLE uploads (
1852 id integer NOT NULL,
1856 filename
text NOT NULL,
1858 size bigint NOT NULL,
1859 progress
bigint DEFAULT 0 NOT NULL,
1860 finished uploads_finished
DEFAULT 'N'::uploads_finished NOT NULL,
1861 time_started
timestamp without time zone DEFAULT now() NOT NULL,
1862 time_finished
timestamp without time zone
1866 ALTER TABLE uploads
OWNER TO pakfire
;
1869 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1872 CREATE SEQUENCE uploads_id_seq
1880 ALTER TABLE uploads_id_seq
OWNER TO pakfire
;
1883 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1886 ALTER SEQUENCE uploads_id_seq
OWNED BY uploads.
id;
1890 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1893 CREATE TABLE user_messages (
1894 id integer NOT NULL,
1897 subject
text NOT NULL,
1899 time_added
timestamp without time zone DEFAULT now() NOT NULL
1903 ALTER TABLE user_messages
OWNER TO pakfire
;
1906 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1909 CREATE SEQUENCE user_messages_id_seq
1917 ALTER TABLE user_messages_id_seq
OWNER TO pakfire
;
1920 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1923 ALTER SEQUENCE user_messages_id_seq
OWNED BY user_messages.
id;
1927 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1930 CREATE TABLE users (
1931 id integer NOT NULL,
1934 passphrase
text NOT NULL,
1935 state users_state
NOT NULL,
1938 activated users_activated
DEFAULT 'N'::users_activated NOT NULL,
1939 activation_code
text,
1940 deleted users_deleted
DEFAULT 'N'::users_deleted NOT NULL,
1941 registered
timestamp without time zone DEFAULT now() NOT NULL
1945 ALTER TABLE users
OWNER TO pakfire
;
1948 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1951 CREATE TABLE users_emails (
1952 id integer NOT NULL,
1953 user_id
integer NOT NULL,
1954 email
text NOT NULL,
1955 "primary" users_emails_primary
DEFAULT 'N'::users_emails_primary NOT NULL
1959 ALTER TABLE users_emails
OWNER TO pakfire
;
1962 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1965 CREATE SEQUENCE users_emails_id_seq
1973 ALTER TABLE users_emails_id_seq
OWNER TO pakfire
;
1976 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1979 ALTER SEQUENCE users_emails_id_seq
OWNED BY users_emails.
id;
1983 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1986 CREATE SEQUENCE users_id_seq
1994 ALTER TABLE users_id_seq
OWNER TO pakfire
;
1997 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2000 ALTER SEQUENCE users_id_seq
OWNED BY users.
id;
2004 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2007 CREATE TABLE users_permissions (
2008 id integer NOT NULL,
2009 user_id
integer NOT NULL,
2010 create_scratch_builds users_permissions_create_scratch_builds
DEFAULT 'N'::users_permissions_create_scratch_builds NOT NULL,
2011 maintain_builders users_permissions_maintain_builders
DEFAULT 'N'::users_permissions_maintain_builders NOT NULL,
2012 manage_critical_path users_permissions_manage_critical_path
DEFAULT 'N'::users_permissions_manage_critical_path NOT NULL,
2013 manage_mirrors users_permissions_manage_mirrors
DEFAULT 'N'::users_permissions_manage_mirrors NOT NULL,
2014 vote users_permissions_vote
DEFAULT 'N'::users_permissions_vote NOT NULL
2018 ALTER TABLE users_permissions
OWNER TO pakfire
;
2021 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2024 CREATE SEQUENCE users_permissions_id_seq
2032 ALTER TABLE users_permissions_id_seq
OWNER TO pakfire
;
2035 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2038 ALTER SEQUENCE users_permissions_id_seq
OWNED BY users_permissions.
id;
2042 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2045 ALTER TABLE ONLY arches
ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
2049 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2052 ALTER TABLE ONLY builders
ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
2056 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2059 ALTER TABLE ONLY builders_history
ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
2063 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2066 ALTER TABLE ONLY builds
ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
2070 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2073 ALTER TABLE ONLY builds_bugs
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
2077 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2080 ALTER TABLE ONLY builds_bugs_updates
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
2084 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2087 ALTER TABLE ONLY builds_comments
ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
2091 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2094 ALTER TABLE ONLY builds_history
ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
2098 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2101 ALTER TABLE ONLY builds_watchers
ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
2105 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2108 ALTER TABLE ONLY distributions
ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
2112 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2115 ALTER TABLE ONLY distributions_arches
ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
2119 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2122 ALTER TABLE ONLY images_types
ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
2126 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2129 ALTER TABLE ONLY jobs
ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
2133 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2136 ALTER TABLE ONLY jobs_packages
ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
2140 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2143 ALTER TABLE ONLY keys
ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
2147 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2150 ALTER TABLE ONLY keys_subkeys
ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
2154 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2157 ALTER TABLE ONLY logfiles
ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
2161 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2164 ALTER TABLE ONLY mirrors
ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
2168 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2171 ALTER TABLE ONLY mirrors_checks
ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
2175 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2178 ALTER TABLE ONLY mirrors_history
ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
2182 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2185 ALTER TABLE ONLY packages
ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
2189 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2192 ALTER TABLE ONLY packages_properties
ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
2196 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2199 ALTER TABLE ONLY queue_delete
ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
2203 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2206 ALTER TABLE ONLY repositories
ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
2210 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2213 ALTER TABLE ONLY repositories_aux
ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
2217 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2220 ALTER TABLE ONLY repositories_builds
ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
2224 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2227 ALTER TABLE ONLY sessions
ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
2231 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2234 ALTER TABLE ONLY slogans
ALTER COLUMN id SET DEFAULT nextval('slogans_id_seq'::regclass);
2238 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2241 ALTER TABLE ONLY sources
ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
2245 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2248 ALTER TABLE ONLY sources_commits
ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
2252 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2255 ALTER TABLE ONLY uploads
ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
2259 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2262 ALTER TABLE ONLY user_messages
ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
2266 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2269 ALTER TABLE ONLY users
ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
2273 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2276 ALTER TABLE ONLY users_emails
ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
2280 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2283 ALTER TABLE ONLY users_permissions
ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
2287 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2290 ALTER TABLE ONLY arches_compat
2291 ADD CONSTRAINT arches_compat_unique
UNIQUE (native_arch
, build_arch
);
2295 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2298 ALTER TABLE ONLY arches
2299 ADD CONSTRAINT arches_name
UNIQUE (name);
2303 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2306 ALTER TABLE ONLY arches
2307 ADD CONSTRAINT idx_2197943_primary
PRIMARY KEY (id);
2311 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2314 ALTER TABLE ONLY builders
2315 ADD CONSTRAINT idx_2197954_primary
PRIMARY KEY (id);
2319 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2322 ALTER TABLE ONLY builders_history
2323 ADD CONSTRAINT idx_2197982_primary
PRIMARY KEY (id);
2327 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2330 ALTER TABLE ONLY builds
2331 ADD CONSTRAINT idx_2197988_primary
PRIMARY KEY (id);
2335 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2338 ALTER TABLE ONLY builds_bugs
2339 ADD CONSTRAINT idx_2198002_primary
PRIMARY KEY (id);
2343 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2346 ALTER TABLE ONLY builds_bugs_updates
2347 ADD CONSTRAINT idx_2198008_primary
PRIMARY KEY (id);
2351 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2354 ALTER TABLE ONLY builds_comments
2355 ADD CONSTRAINT idx_2198018_primary
PRIMARY KEY (id);
2359 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2362 ALTER TABLE ONLY builds_history
2363 ADD CONSTRAINT idx_2198027_primary
PRIMARY KEY (id);
2367 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2370 ALTER TABLE ONLY builds_watchers
2371 ADD CONSTRAINT idx_2198033_primary
PRIMARY KEY (id);
2375 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2378 ALTER TABLE ONLY distributions
2379 ADD CONSTRAINT idx_2198039_primary
PRIMARY KEY (id);
2383 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2386 ALTER TABLE ONLY distributions_arches
2387 ADD CONSTRAINT idx_2198048_primary
PRIMARY KEY (id);
2391 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2394 ALTER TABLE ONLY images_types
2395 ADD CONSTRAINT idx_2198057_primary
PRIMARY KEY (id);
2399 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2402 ALTER TABLE ONLY jobs
2403 ADD CONSTRAINT idx_2198063_primary
PRIMARY KEY (id);
2407 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2410 ALTER TABLE ONLY jobs_packages
2411 ADD CONSTRAINT idx_2198085_primary
PRIMARY KEY (id);
2415 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2418 ALTER TABLE ONLY keys
2419 ADD CONSTRAINT idx_2198094_primary
PRIMARY KEY (id);
2423 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2426 ALTER TABLE ONLY keys_subkeys
2427 ADD CONSTRAINT idx_2198103_primary
PRIMARY KEY (id);
2431 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2434 ALTER TABLE ONLY logfiles
2435 ADD CONSTRAINT idx_2198109_primary
PRIMARY KEY (id);
2439 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2442 ALTER TABLE ONLY mirrors
2443 ADD CONSTRAINT idx_2198115_primary
PRIMARY KEY (id);
2447 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2450 ALTER TABLE ONLY mirrors_history
2451 ADD CONSTRAINT idx_2198126_primary
PRIMARY KEY (id);
2455 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2458 ALTER TABLE ONLY packages
2459 ADD CONSTRAINT idx_2198132_primary
PRIMARY KEY (id);
2463 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2466 ALTER TABLE ONLY packages_properties
2467 ADD CONSTRAINT idx_2198147_primary
PRIMARY KEY (id);
2471 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2474 ALTER TABLE ONLY queue_delete
2475 ADD CONSTRAINT idx_2198155_primary
PRIMARY KEY (id);
2479 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2482 ALTER TABLE ONLY repositories
2483 ADD CONSTRAINT idx_2198164_primary
PRIMARY KEY (id);
2487 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2490 ALTER TABLE ONLY repositories_aux
2491 ADD CONSTRAINT idx_2198179_primary
PRIMARY KEY (id);
2495 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2498 ALTER TABLE ONLY repositories_builds
2499 ADD CONSTRAINT idx_2198189_primary
PRIMARY KEY (id);
2503 -- Name: idx_2198207_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2506 ALTER TABLE ONLY slogans
2507 ADD CONSTRAINT idx_2198207_primary
PRIMARY KEY (id);
2511 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2514 ALTER TABLE ONLY sources
2515 ADD CONSTRAINT idx_2198213_primary
PRIMARY KEY (id);
2519 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2522 ALTER TABLE ONLY sources_commits
2523 ADD CONSTRAINT idx_2198222_primary
PRIMARY KEY (id);
2527 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2530 ALTER TABLE ONLY uploads
2531 ADD CONSTRAINT idx_2198232_primary
PRIMARY KEY (id);
2535 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2538 ALTER TABLE ONLY users
2539 ADD CONSTRAINT idx_2198244_primary
PRIMARY KEY (id);
2543 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2546 ALTER TABLE ONLY users_emails
2547 ADD CONSTRAINT idx_2198256_primary
PRIMARY KEY (id);
2551 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2554 ALTER TABLE ONLY users_permissions
2555 ADD CONSTRAINT idx_2198263_primary
PRIMARY KEY (id);
2559 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2562 ALTER TABLE ONLY user_messages
2563 ADD CONSTRAINT idx_2198274_primary
PRIMARY KEY (id);
2567 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2570 ALTER TABLE ONLY jobs_packages
2571 ADD CONSTRAINT jobs_packages_unique
UNIQUE (job_id
, pkg_id
);
2575 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2578 ALTER TABLE ONLY mirrors_checks
2579 ADD CONSTRAINT mirrors_checks_pkey
PRIMARY KEY (id);
2583 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2586 ALTER TABLE ONLY sessions
2587 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (id);
2591 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2594 ALTER TABLE ONLY sessions
2595 ADD CONSTRAINT sessions_session_id_key
UNIQUE (session_id
);
2599 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2602 CREATE INDEX arches_compat_native_arch
ON arches_compat
USING btree (native_arch
);
2606 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2609 CREATE UNIQUE INDEX builders_name
ON builders
USING btree (name) WHERE (deleted
IS FALSE);
2613 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2616 CREATE INDEX builds_watchers_build_id
ON builds_watchers
USING btree (build_id
);
2620 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2623 CREATE INDEX distributions_arches_distro_id
ON distributions_arches
USING btree (distro_id
);
2627 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2630 CREATE UNIQUE INDEX distributions_sname
ON distributions
USING btree (sname
) WHERE (deleted
IS FALSE);
2634 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2637 CREATE INDEX filelists_name
ON filelists
USING btree (name);
2641 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2644 CREATE INDEX idx_2197982_builder_id
ON builders_history
USING btree (builder_id
);
2648 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2651 CREATE INDEX idx_2197988_pkg_id
ON builds
USING btree (pkg_id
);
2655 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2658 CREATE INDEX idx_2197988_state
ON builds
USING btree (state);
2662 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2665 CREATE INDEX idx_2197988_type
ON builds
USING btree (type);
2669 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2672 CREATE UNIQUE INDEX idx_2197988_uuid
ON builds
USING btree (uuid
);
2676 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2679 CREATE UNIQUE INDEX idx_2198002_build_id
ON builds_bugs
USING btree (build_id
, bug_id
);
2683 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2686 CREATE INDEX idx_2198018_build_id
ON builds_comments
USING btree (build_id
);
2690 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2693 CREATE INDEX idx_2198018_user_id
ON builds_comments
USING btree (user_id
);
2697 -- Name: idx_2198052_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2700 CREATE INDEX idx_2198052_pkg_id
ON filelists
USING btree (pkg_id
);
2704 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2707 CREATE INDEX idx_2198063_build_id
ON jobs
USING btree (build_id
);
2711 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2714 CREATE INDEX idx_2198063_state
ON jobs
USING btree (state);
2718 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2721 CREATE INDEX idx_2198063_time_finished
ON jobs
USING btree (time_finished
);
2725 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2728 CREATE UNIQUE INDEX idx_2198063_uuid
ON jobs
USING btree (uuid
);
2732 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2735 CREATE INDEX idx_2198080_job_id
ON jobs_history
USING btree (job_id
);
2739 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2742 CREATE UNIQUE INDEX idx_2198089_job_id
ON jobs_repos
USING btree (job_id
, repo_id
);
2746 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2749 CREATE UNIQUE INDEX idx_2198094_fingerprint
ON keys
USING btree (fingerprint
);
2753 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2756 CREATE INDEX idx_2198132_name
ON packages
USING btree (name);
2760 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2763 CREATE INDEX idx_2198132_type
ON packages
USING btree (type);
2767 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2770 CREATE INDEX idx_2198132_uuid
ON packages
USING btree (uuid
);
2774 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2777 CREATE INDEX idx_2198139_pkg_id
ON packages_deps
USING btree (pkg_id
);
2781 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2784 CREATE UNIQUE INDEX idx_2198147_name
ON packages_properties
USING btree (name);
2788 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2791 CREATE UNIQUE INDEX idx_2198189_build_id
ON repositories_builds
USING btree (build_id
);
2795 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2798 CREATE INDEX idx_2198193_build_id
ON repositories_history
USING btree (build_id
);
2802 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2805 CREATE UNIQUE INDEX idx_2198199_k
ON settings
USING btree (k
);
2809 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2812 CREATE UNIQUE INDEX idx_2198213_identifier
ON sources
USING btree (identifier
);
2816 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2819 CREATE INDEX idx_2198222_revision
ON sources_commits
USING btree (revision
);
2823 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2826 CREATE UNIQUE INDEX idx_2198232_uuid
ON uploads
USING btree (uuid
);
2830 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2833 CREATE UNIQUE INDEX idx_2198244_name
ON users
USING btree (name);
2837 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2840 CREATE UNIQUE INDEX idx_2198256_email
ON users_emails
USING btree (email
);
2844 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2847 CREATE INDEX idx_2198256_user_id
ON users_emails
USING btree (user_id
);
2851 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2854 CREATE INDEX jobs_arch
ON jobs
USING btree (arch
);
2858 -- Name: jobs_buildroots_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2861 CREATE INDEX jobs_buildroots_job_id
ON jobs_buildroots
USING btree (job_id
);
2863 ALTER TABLE jobs_buildroots
CLUSTER ON jobs_buildroots_job_id
;
2867 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2870 CREATE INDEX jobs_buildroots_pkg_uuid
ON jobs_buildroots
USING btree (pkg_uuid
);
2874 -- Name: jobs_test; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2877 CREATE INDEX jobs_test
ON jobs
USING btree (test
) WHERE (deleted_at
IS NULL);
2881 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2884 CREATE INDEX mirrors_checks_sort
ON mirrors_checks
USING btree (mirror_id
, "timestamp");
2886 ALTER TABLE mirrors_checks
CLUSTER ON mirrors_checks_sort
;
2890 -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2893 CREATE INDEX repositories_builds_repo_id
ON repositories_builds
USING btree (repo_id
);
2897 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
2900 CREATE TRIGGER on_update_current_timestamp
BEFORE UPDATE ON sources
FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
2904 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2907 ALTER TABLE ONLY arches_compat
2908 ADD CONSTRAINT arches_compat_build_arch
FOREIGN KEY (build_arch
) REFERENCES arches(name);
2912 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2915 ALTER TABLE ONLY builders_history
2916 ADD CONSTRAINT builders_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2920 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2923 ALTER TABLE ONLY builders_history
2924 ADD CONSTRAINT builders_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2928 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2931 ALTER TABLE ONLY builds_bugs
2932 ADD CONSTRAINT builds_bug_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2936 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2939 ALTER TABLE ONLY builds_comments
2940 ADD CONSTRAINT builds_comments_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2944 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2947 ALTER TABLE ONLY builds_comments
2948 ADD CONSTRAINT builds_comments_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2952 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2955 ALTER TABLE ONLY builds
2956 ADD CONSTRAINT builds_depends_on
FOREIGN KEY (depends_on
) REFERENCES builds(id);
2960 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2963 ALTER TABLE ONLY builds
2964 ADD CONSTRAINT builds_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2968 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2971 ALTER TABLE ONLY builds_history
2972 ADD CONSTRAINT builds_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2976 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2979 ALTER TABLE ONLY builds_history
2980 ADD CONSTRAINT builds_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2984 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2987 ALTER TABLE ONLY builds
2988 ADD CONSTRAINT builds_owner_id
FOREIGN KEY (owner_id
) REFERENCES users(id);
2992 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2995 ALTER TABLE ONLY builds
2996 ADD CONSTRAINT builds_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3000 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3003 ALTER TABLE ONLY builds_watchers
3004 ADD CONSTRAINT builds_watchers_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3008 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3011 ALTER TABLE ONLY builds_watchers
3012 ADD CONSTRAINT builds_watchers_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3016 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3019 ALTER TABLE ONLY distributions_arches
3020 ADD CONSTRAINT distributions_arches_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3024 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3027 ALTER TABLE ONLY distributions_arches
3028 ADD CONSTRAINT distro_arches_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3032 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3035 ALTER TABLE ONLY filelists
3036 ADD CONSTRAINT filelists_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3040 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3043 ALTER TABLE ONLY jobs
3044 ADD CONSTRAINT jobs_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3048 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3051 ALTER TABLE ONLY jobs
3052 ADD CONSTRAINT jobs_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3056 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3059 ALTER TABLE ONLY jobs
3060 ADD CONSTRAINT jobs_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3064 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3067 ALTER TABLE ONLY jobs_buildroots
3068 ADD CONSTRAINT jobs_buildroots_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3072 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3075 ALTER TABLE ONLY jobs_history
3076 ADD CONSTRAINT jobs_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3080 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3083 ALTER TABLE ONLY jobs_history
3084 ADD CONSTRAINT jobs_history_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3088 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3091 ALTER TABLE ONLY jobs_history
3092 ADD CONSTRAINT jobs_history_test_job_id
FOREIGN KEY (test_job_id
) REFERENCES jobs(id);
3096 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3099 ALTER TABLE ONLY jobs_history
3100 ADD CONSTRAINT jobs_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3104 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3107 ALTER TABLE ONLY jobs_packages
3108 ADD CONSTRAINT jobs_packaged_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3112 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3115 ALTER TABLE ONLY jobs_packages
3116 ADD CONSTRAINT jobs_packages_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3120 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3123 ALTER TABLE ONLY jobs_repos
3124 ADD CONSTRAINT jobs_repos_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3128 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3131 ALTER TABLE ONLY jobs_repos
3132 ADD CONSTRAINT jobs_repos_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3136 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3139 ALTER TABLE ONLY keys_subkeys
3140 ADD CONSTRAINT keys_subkeys_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3144 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3147 ALTER TABLE ONLY logfiles
3148 ADD CONSTRAINT logfiles_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3152 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3155 ALTER TABLE ONLY mirrors_checks
3156 ADD CONSTRAINT mirrors_checks_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3160 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3163 ALTER TABLE ONLY mirrors_history
3164 ADD CONSTRAINT mirrors_history_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3168 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3171 ALTER TABLE ONLY mirrors_history
3172 ADD CONSTRAINT mirrors_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3176 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3179 ALTER TABLE ONLY packages
3180 ADD CONSTRAINT packages_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3184 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3187 ALTER TABLE ONLY packages
3188 ADD CONSTRAINT packages_commit_id
FOREIGN KEY (commit_id
) REFERENCES sources_commits(id);
3192 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3195 ALTER TABLE ONLY packages_deps
3196 ADD CONSTRAINT packages_deps_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3200 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3203 ALTER TABLE ONLY repositories_aux
3204 ADD CONSTRAINT repositories_aux_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3208 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3211 ALTER TABLE ONLY repositories_builds
3212 ADD CONSTRAINT repositories_builds_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3216 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3219 ALTER TABLE ONLY repositories_builds
3220 ADD CONSTRAINT repositories_builds_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3224 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3227 ALTER TABLE ONLY repositories
3228 ADD CONSTRAINT repositories_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3232 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3235 ALTER TABLE ONLY repositories_history
3236 ADD CONSTRAINT repositories_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3240 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3243 ALTER TABLE ONLY repositories_history
3244 ADD CONSTRAINT repositories_history_from_repo_id
FOREIGN KEY (from_repo_id
) REFERENCES repositories(id);
3248 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3251 ALTER TABLE ONLY repositories_history
3252 ADD CONSTRAINT repositories_history_to_repo_id
FOREIGN KEY (to_repo_id
) REFERENCES repositories(id);
3256 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3259 ALTER TABLE ONLY repositories_history
3260 ADD CONSTRAINT repositories_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3264 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3267 ALTER TABLE ONLY repositories
3268 ADD CONSTRAINT repositories_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3272 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3275 ALTER TABLE ONLY repositories
3276 ADD CONSTRAINT repositories_parent_id
FOREIGN KEY (parent_id
) REFERENCES repositories(id);
3280 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3283 ALTER TABLE ONLY sessions
3284 ADD CONSTRAINT sessions_impersonated_user_id
FOREIGN KEY (impersonated_user_id
) REFERENCES users(id);
3288 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3291 ALTER TABLE ONLY sessions
3292 ADD CONSTRAINT sessions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3296 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3299 ALTER TABLE ONLY sources_commits
3300 ADD CONSTRAINT sources_commits_source_id
FOREIGN KEY (source_id
) REFERENCES sources(id);
3304 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3307 ALTER TABLE ONLY sources
3308 ADD CONSTRAINT sources_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3312 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3315 ALTER TABLE ONLY uploads
3316 ADD CONSTRAINT uploads_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3320 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3323 ALTER TABLE ONLY uploads
3324 ADD CONSTRAINT uploads_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3328 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3331 ALTER TABLE ONLY users_emails
3332 ADD CONSTRAINT users_emails_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3336 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3339 ALTER TABLE ONLY users_permissions
3340 ADD CONSTRAINT users_permissions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3344 -- PostgreSQL database dump complete