2 -- PostgreSQL database dump
5 SET statement_timeout
= 0;
7 SET client_encoding
= 'UTF8';
8 SET standard_conforming_strings
= on;
9 SET check_function_bodies
= false;
10 SET client_min_messages
= warning
;
13 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
16 CREATE EXTENSION
IF NOT EXISTS plpgsql
WITH SCHEMA pg_catalog
;
20 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
23 COMMENT ON EXTENSION plpgsql
IS 'PL/pgSQL procedural language';
26 SET search_path
= public, pg_catalog
;
29 -- Name: arches_binary; Type: TYPE; Schema: public; Owner: pakfire
32 CREATE TYPE arches_binary
AS ENUM (
38 ALTER TYPE arches_binary
OWNER TO pakfire
;
41 -- Name: builders_arches_enabled; Type: TYPE; Schema: public; Owner: pakfire
44 CREATE TYPE builders_arches_enabled
AS ENUM (
50 ALTER TYPE builders_arches_enabled
OWNER TO pakfire
;
53 -- Name: builders_build_release; Type: TYPE; Schema: public; Owner: pakfire
56 CREATE TYPE builders_build_release
AS ENUM (
62 ALTER TYPE builders_build_release
OWNER TO pakfire
;
65 -- Name: builders_build_scratch; Type: TYPE; Schema: public; Owner: pakfire
68 CREATE TYPE builders_build_scratch
AS ENUM (
74 ALTER TYPE builders_build_scratch
OWNER TO pakfire
;
77 -- Name: builders_build_test; Type: TYPE; Schema: public; Owner: pakfire
80 CREATE TYPE builders_build_test
AS ENUM (
86 ALTER TYPE builders_build_test
OWNER TO pakfire
;
89 -- Name: builders_deleted; Type: TYPE; Schema: public; Owner: pakfire
92 CREATE TYPE builders_deleted
AS ENUM (
98 ALTER TYPE builders_deleted
OWNER TO pakfire
;
101 -- Name: builders_disabled; Type: TYPE; Schema: public; Owner: pakfire
104 CREATE TYPE builders_disabled
AS ENUM (
110 ALTER TYPE builders_disabled
OWNER TO pakfire
;
113 -- Name: builders_history_action; Type: TYPE; Schema: public; Owner: pakfire
116 CREATE TYPE builders_history_action
AS ENUM (
124 ALTER TYPE builders_history_action
OWNER TO pakfire
;
127 -- Name: builders_overload; Type: TYPE; Schema: public; Owner: pakfire
130 CREATE TYPE builders_overload
AS ENUM (
136 ALTER TYPE builders_overload
OWNER TO pakfire
;
139 -- Name: builders_status; Type: TYPE; Schema: public; Owner: pakfire
142 CREATE TYPE builders_status
AS ENUM (
149 ALTER TYPE builders_status
OWNER TO pakfire
;
152 -- Name: builds_auto_move; Type: TYPE; Schema: public; Owner: pakfire
155 CREATE TYPE builds_auto_move
AS ENUM (
161 ALTER TYPE builds_auto_move
OWNER TO pakfire
;
164 -- Name: builds_bugs_updates_error; Type: TYPE; Schema: public; Owner: pakfire
167 CREATE TYPE builds_bugs_updates_error
AS ENUM (
173 ALTER TYPE builds_bugs_updates_error
OWNER TO pakfire
;
176 -- Name: builds_history_action; Type: TYPE; Schema: public; Owner: pakfire
179 CREATE TYPE builds_history_action
AS ENUM (
186 ALTER TYPE builds_history_action
OWNER TO pakfire
;
189 -- Name: builds_public; Type: TYPE; Schema: public; Owner: pakfire
192 CREATE TYPE builds_public
AS ENUM (
198 ALTER TYPE builds_public
OWNER TO pakfire
;
201 -- Name: builds_severity; Type: TYPE; Schema: public; Owner: pakfire
204 CREATE TYPE builds_severity
AS ENUM (
212 ALTER TYPE builds_severity
OWNER TO pakfire
;
215 -- Name: builds_state; Type: TYPE; Schema: public; Owner: pakfire
218 CREATE TYPE builds_state
AS ENUM (
227 ALTER TYPE builds_state
OWNER TO pakfire
;
230 -- Name: builds_type; Type: TYPE; Schema: public; Owner: pakfire
233 CREATE TYPE builds_type
AS ENUM (
239 ALTER TYPE builds_type
OWNER TO pakfire
;
242 -- Name: filelists_config; Type: TYPE; Schema: public; Owner: pakfire
245 CREATE TYPE filelists_config
AS ENUM (
251 ALTER TYPE filelists_config
OWNER TO pakfire
;
254 -- Name: jobs_history_action; Type: TYPE; Schema: public; Owner: pakfire
257 CREATE TYPE jobs_history_action
AS ENUM (
266 ALTER TYPE jobs_history_action
OWNER TO pakfire
;
269 -- Name: jobs_history_state; Type: TYPE; Schema: public; Owner: pakfire
272 CREATE TYPE jobs_history_state
AS ENUM (
288 ALTER TYPE jobs_history_state
OWNER TO pakfire
;
291 -- Name: jobs_state; Type: TYPE; Schema: public; Owner: pakfire
294 CREATE TYPE jobs_state
AS ENUM (
310 ALTER TYPE jobs_state
OWNER TO pakfire
;
313 -- Name: jobs_type; Type: TYPE; Schema: public; Owner: pakfire
316 CREATE TYPE jobs_type
AS ENUM (
322 ALTER TYPE jobs_type
OWNER TO pakfire
;
325 -- Name: mirrors_check_status; Type: TYPE; Schema: public; Owner: pakfire
328 CREATE TYPE mirrors_check_status
AS ENUM (
335 ALTER TYPE mirrors_check_status
OWNER TO pakfire
;
338 -- Name: mirrors_history_action; Type: TYPE; Schema: public; Owner: pakfire
341 CREATE TYPE mirrors_history_action
AS ENUM (
349 ALTER TYPE mirrors_history_action
OWNER TO pakfire
;
352 -- Name: mirrors_status; Type: TYPE; Schema: public; Owner: pakfire
355 CREATE TYPE mirrors_status
AS ENUM (
362 ALTER TYPE mirrors_status
OWNER TO pakfire
;
365 -- Name: packages_deps_type; Type: TYPE; Schema: public; Owner: pakfire
368 CREATE TYPE packages_deps_type
AS ENUM (
379 ALTER TYPE packages_deps_type
OWNER TO pakfire
;
382 -- Name: packages_properties_critical_path; Type: TYPE; Schema: public; Owner: pakfire
385 CREATE TYPE packages_properties_critical_path
AS ENUM (
391 ALTER TYPE packages_properties_critical_path
OWNER TO pakfire
;
394 -- Name: packages_type; Type: TYPE; Schema: public; Owner: pakfire
397 CREATE TYPE packages_type
AS ENUM (
403 ALTER TYPE packages_type
OWNER TO pakfire
;
406 -- Name: repositories_aux_status; Type: TYPE; Schema: public; Owner: pakfire
409 CREATE TYPE repositories_aux_status
AS ENUM (
415 ALTER TYPE repositories_aux_status
OWNER TO pakfire
;
418 -- Name: repositories_enabled_for_builds; Type: TYPE; Schema: public; Owner: pakfire
421 CREATE TYPE repositories_enabled_for_builds
AS ENUM (
427 ALTER TYPE repositories_enabled_for_builds
OWNER TO pakfire
;
430 -- Name: repositories_history_action; Type: TYPE; Schema: public; Owner: pakfire
433 CREATE TYPE repositories_history_action
AS ENUM (
440 ALTER TYPE repositories_history_action
OWNER TO pakfire
;
443 -- Name: repositories_mirrored; Type: TYPE; Schema: public; Owner: pakfire
446 CREATE TYPE repositories_mirrored
AS ENUM (
452 ALTER TYPE repositories_mirrored
OWNER TO pakfire
;
455 -- Name: repositories_type; Type: TYPE; Schema: public; Owner: pakfire
458 CREATE TYPE repositories_type
AS ENUM (
465 ALTER TYPE repositories_type
OWNER TO pakfire
;
468 -- Name: sources_commits_state; Type: TYPE; Schema: public; Owner: pakfire
471 CREATE TYPE sources_commits_state
AS ENUM (
479 ALTER TYPE sources_commits_state
OWNER TO pakfire
;
482 -- Name: uploads_finished; Type: TYPE; Schema: public; Owner: pakfire
485 CREATE TYPE uploads_finished
AS ENUM (
491 ALTER TYPE uploads_finished
OWNER TO pakfire
;
494 -- Name: users_activated; Type: TYPE; Schema: public; Owner: pakfire
497 CREATE TYPE users_activated
AS ENUM (
503 ALTER TYPE users_activated
OWNER TO pakfire
;
506 -- Name: users_deleted; Type: TYPE; Schema: public; Owner: pakfire
509 CREATE TYPE users_deleted
AS ENUM (
515 ALTER TYPE users_deleted
OWNER TO pakfire
;
518 -- Name: users_emails_primary; Type: TYPE; Schema: public; Owner: pakfire
521 CREATE TYPE users_emails_primary
AS ENUM (
527 ALTER TYPE users_emails_primary
OWNER TO pakfire
;
530 -- Name: users_permissions_create_scratch_builds; Type: TYPE; Schema: public; Owner: pakfire
533 CREATE TYPE users_permissions_create_scratch_builds
AS ENUM (
539 ALTER TYPE users_permissions_create_scratch_builds
OWNER TO pakfire
;
542 -- Name: users_permissions_maintain_builders; Type: TYPE; Schema: public; Owner: pakfire
545 CREATE TYPE users_permissions_maintain_builders
AS ENUM (
551 ALTER TYPE users_permissions_maintain_builders
OWNER TO pakfire
;
554 -- Name: users_permissions_manage_critical_path; Type: TYPE; Schema: public; Owner: pakfire
557 CREATE TYPE users_permissions_manage_critical_path
AS ENUM (
563 ALTER TYPE users_permissions_manage_critical_path
OWNER TO pakfire
;
566 -- Name: users_permissions_manage_mirrors; Type: TYPE; Schema: public; Owner: pakfire
569 CREATE TYPE users_permissions_manage_mirrors
AS ENUM (
575 ALTER TYPE users_permissions_manage_mirrors
OWNER TO pakfire
;
578 -- Name: users_permissions_vote; Type: TYPE; Schema: public; Owner: pakfire
581 CREATE TYPE users_permissions_vote
AS ENUM (
587 ALTER TYPE users_permissions_vote
OWNER TO pakfire
;
590 -- Name: users_state; Type: TYPE; Schema: public; Owner: pakfire
593 CREATE TYPE users_state
AS ENUM (
600 ALTER TYPE users_state
OWNER TO pakfire
;
603 -- Name: on_update_current_timestamp_sources(); Type: FUNCTION; Schema: public; Owner: pakfire
606 CREATE FUNCTION on_update_current_timestamp_sources() RETURNS trigger
616 ALTER FUNCTION public.
on_update_current_timestamp_sources() OWNER TO pakfire
;
618 SET default_tablespace
= '';
620 SET default_with_oids
= false;
623 -- Name: arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
626 CREATE TABLE arches (
629 prio
integer DEFAULT 0 NOT NULL,
630 "binary" arches_binary
DEFAULT 'Y'::arches_binary NOT NULL,
635 ALTER TABLE arches
OWNER TO pakfire
;
638 -- Name: arches_compat; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
641 CREATE TABLE arches_compat (
642 native_arch
text NOT NULL,
643 build_arch
text NOT NULL,
644 CONSTRAINT arches_compat_unique
CHECK ((native_arch
<> build_arch
))
648 ALTER TABLE arches_compat
OWNER TO pakfire
;
651 -- Name: builders; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
654 CREATE TABLE builders (
659 enabled
boolean DEFAULT false NOT NULL,
660 deleted
boolean DEFAULT false NOT NULL,
661 loadavg
text DEFAULT '0'::character varying NOT NULL,
663 build_release builders_build_release
DEFAULT 'N'::builders_build_release NOT NULL,
664 build_scratch builders_build_scratch
DEFAULT 'N'::builders_build_scratch NOT NULL,
665 build_test builders_build_test
DEFAULT 'N'::builders_build_test NOT NULL,
666 max_jobs
bigint DEFAULT 1::bigint NOT NULL,
667 pakfire_version
text,
670 cpu_count
integer DEFAULT 1 NOT NULL,
672 cpu_bogomips
double precision,
673 memory
bigint DEFAULT 0 NOT NULL,
674 overload builders_overload
DEFAULT 'N'::builders_overload NOT NULL,
675 free_space
bigint DEFAULT 0 NOT NULL,
677 time_created
timestamp without time zone DEFAULT now() NOT NULL,
678 time_updated
timestamp without time zone,
679 time_keepalive
timestamp without time zone,
680 loadavg1
double precision,
681 loadavg5
double precision,
682 loadavg15
double precision,
691 ALTER TABLE builders
OWNER TO pakfire
;
694 -- Name: arches_builders; Type: VIEW; Schema: public; Owner: pakfire
697 CREATE VIEW arches_builders
AS
698 SELECT arches_compat.build_arch
AS arch
,
699 builders.
id AS builder_id
701 LEFT JOIN builders
ON ((arches_compat.native_arch
= builders.cpu_arch
)));
704 ALTER TABLE arches_builders
OWNER TO pakfire
;
707 -- Name: arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
710 CREATE SEQUENCE arches_id_seq
718 ALTER TABLE arches_id_seq
OWNER TO pakfire
;
721 -- Name: arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
724 ALTER SEQUENCE arches_id_seq
OWNED BY arches.
id;
728 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
731 CREATE TABLE builders_history (
733 builder_id
integer NOT NULL,
734 action builders_history_action
NOT NULL,
736 "time" timestamp without time zone NOT NULL
740 ALTER TABLE builders_history
OWNER TO pakfire
;
743 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
746 CREATE SEQUENCE builders_history_id_seq
754 ALTER TABLE builders_history_id_seq
OWNER TO pakfire
;
757 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
760 ALTER SEQUENCE builders_history_id_seq
OWNED BY builders_history.
id;
764 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
767 CREATE SEQUENCE builders_id_seq
775 ALTER TABLE builders_id_seq
OWNER TO pakfire
;
778 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
781 ALTER SEQUENCE builders_id_seq
OWNED BY builders.
id;
785 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
791 type jobs_type
DEFAULT 'build'::jobs_type NOT NULL,
792 build_id
integer NOT NULL,
793 state jobs_state
DEFAULT 'new'::jobs_state NOT NULL,
795 time_created
timestamp without time zone NOT NULL,
796 time_started
timestamp without time zone,
797 time_finished
timestamp without time zone,
798 start_not_before
timestamp without time zone,
800 tries
integer DEFAULT 0 NOT NULL,
801 aborted_state
integer DEFAULT 0 NOT NULL,
806 ALTER TABLE jobs
OWNER TO pakfire
;
809 -- Name: jobs_active; Type: VIEW; Schema: public; Owner: pakfire
812 CREATE VIEW jobs_active
AS
822 jobs.start_not_before
,
828 WHERE (jobs.
state = ANY (ARRAY['dispatching'::jobs_state, 'running'::jobs_state, 'uploading'::jobs_state]))
829 ORDER BY jobs.time_started
;
832 ALTER TABLE jobs_active
OWNER TO pakfire
;
835 -- Name: builders_ready; Type: VIEW; Schema: public; Owner: pakfire
838 CREATE VIEW builders_ready
AS
839 SELECT builders.
id AS builder_id
,
840 builders.cpu_arch
AS builder_arch
,
841 builders.build_release
,
842 builders.build_scratch
,
845 WHERE ((((builders.deleted
IS FALSE) AND (builders.enabled
IS TRUE)) AND (builders.time_keepalive
>= (now() - '00:05:00'::interval))) AND (builders.max_jobs
> ( SELECT count(*) AS count
847 WHERE (jobs_active.builder_id
= builders.
id))))
848 ORDER BY ( SELECT count(*) AS count
850 WHERE (jobs_active.builder_id
= builders.
id)), builders.cpu_bogomips
DESC;
853 ALTER TABLE builders_ready
OWNER TO pakfire
;
856 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
859 CREATE TABLE builds (
862 pkg_id
integer NOT NULL,
863 type builds_type
DEFAULT 'release'::builds_type NOT NULL,
864 state builds_state
DEFAULT 'building'::builds_state NOT NULL,
865 severity builds_severity
,
867 time_created
timestamp without time zone NOT NULL,
871 distro_id
integer NOT NULL,
873 public builds_public
DEFAULT 'Y'::builds_public NOT NULL,
874 priority
integer DEFAULT 0 NOT NULL,
875 auto_move builds_auto_move
DEFAULT 'N'::builds_auto_move NOT NULL
879 ALTER TABLE builds
OWNER TO pakfire
;
882 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
885 CREATE TABLE builds_bugs (
887 build_id
integer NOT NULL,
888 bug_id
integer NOT NULL
892 ALTER TABLE builds_bugs
OWNER TO pakfire
;
895 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
898 CREATE SEQUENCE builds_bugs_id_seq
906 ALTER TABLE builds_bugs_id_seq
OWNER TO pakfire
;
909 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
912 ALTER SEQUENCE builds_bugs_id_seq
OWNED BY builds_bugs.
id;
916 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
919 CREATE TABLE builds_bugs_updates (
921 bug_id
integer NOT NULL,
925 "time" timestamp without time zone NOT NULL,
926 error builds_bugs_updates_error
DEFAULT 'N'::builds_bugs_updates_error NOT NULL,
931 ALTER TABLE builds_bugs_updates
OWNER TO pakfire
;
934 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
937 CREATE SEQUENCE builds_bugs_updates_id_seq
945 ALTER TABLE builds_bugs_updates_id_seq
OWNER TO pakfire
;
948 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
951 ALTER SEQUENCE builds_bugs_updates_id_seq
OWNED BY builds_bugs_updates.
id;
955 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
958 CREATE TABLE builds_comments (
960 build_id
integer NOT NULL,
961 user_id
integer NOT NULL,
963 credit
integer NOT NULL,
964 time_created
timestamp without time zone NOT NULL,
965 time_updated
timestamp without time zone
969 ALTER TABLE builds_comments
OWNER TO pakfire
;
972 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
975 CREATE SEQUENCE builds_comments_id_seq
983 ALTER TABLE builds_comments_id_seq
OWNER TO pakfire
;
986 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
989 ALTER SEQUENCE builds_comments_id_seq
OWNED BY builds_comments.
id;
993 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
996 CREATE TABLE builds_history (
998 build_id
integer NOT NULL,
999 action builds_history_action
NOT NULL,
1001 "time" timestamp without time zone NOT NULL,
1006 ALTER TABLE builds_history
OWNER TO pakfire
;
1009 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1012 CREATE SEQUENCE builds_history_id_seq
1020 ALTER TABLE builds_history_id_seq
OWNER TO pakfire
;
1023 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1026 ALTER SEQUENCE builds_history_id_seq
OWNED BY builds_history.
id;
1030 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1033 CREATE SEQUENCE builds_id_seq
1041 ALTER TABLE builds_id_seq
OWNER TO pakfire
;
1044 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1047 ALTER SEQUENCE builds_id_seq
OWNED BY builds.
id;
1051 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1054 CREATE TABLE packages (
1055 id integer NOT NULL,
1057 epoch
integer NOT NULL,
1058 version text NOT NULL,
1059 release text NOT NULL,
1060 type packages_type
NOT NULL,
1061 arch
integer NOT NULL,
1062 groups
text NOT NULL,
1063 maintainer
text NOT NULL,
1064 license
text NOT NULL,
1066 summary
text NOT NULL,
1067 description
text NOT NULL,
1068 size bigint NOT NULL,
1069 supported_arches
text,
1072 build_id
text NOT NULL,
1073 build_host
text NOT NULL,
1074 build_time
timestamp without time zone NOT NULL,
1076 filesize
bigint NOT NULL,
1077 hash_sha512
text NOT NULL
1081 ALTER TABLE packages
OWNER TO pakfire
;
1084 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1087 CREATE TABLE repositories_builds (
1088 id integer NOT NULL,
1089 repo_id
integer NOT NULL,
1090 build_id
bigint NOT NULL,
1091 time_added
timestamp without time zone NOT NULL
1095 ALTER TABLE repositories_builds
OWNER TO pakfire
;
1098 -- Name: builds_latest; Type: VIEW; Schema: public; Owner: pakfire
1101 CREATE VIEW builds_latest
AS
1102 SELECT builds.
id AS build_id
,
1103 builds.
type AS build_type
,
1104 builds.
state AS build_state
,
1105 packages.
name AS package_name
,
1108 LEFT JOIN packages
ON ((builds.pkg_id
= packages.
id)))
1109 WHERE ((builds.
id IN ( SELECT repositories_builds.build_id
1110 FROM repositories_builds
)) OR ((builds.time_created
>= ( SELECT builds_1.time_created
1111 FROM ((builds builds_1
1112 LEFT JOIN repositories_builds
ON ((builds_1.
id = repositories_builds.build_id
)))
1113 LEFT JOIN packages p
ON ((builds_1.pkg_id
= p.
id)))
1114 WHERE (p.
name = packages.
name)
1115 ORDER BY builds_1.time_created
1116 LIMIT 1)) AND (builds.
state <> ALL (ARRAY['obsolete'::builds_state, 'broken'::builds_state]))));
1119 ALTER TABLE builds_latest
OWNER TO pakfire
;
1122 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
1125 CREATE VIEW builds_times
AS
1126 SELECT builds.
id AS build_id
,
1129 jobs.
type AS job_type
,
1130 (jobs.time_finished
- jobs.time_started
) AS duration
1132 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
1133 LEFT JOIN packages
ON ((builds.pkg_id
= packages.
id)))
1134 LEFT JOIN arches
ON ((jobs.arch
= arches.
name)))
1135 WHERE (jobs.
state = 'finished'::jobs_state);
1138 ALTER TABLE builds_times
OWNER TO pakfire
;
1141 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1144 CREATE TABLE builds_watchers (
1145 id integer NOT NULL,
1146 build_id
integer NOT NULL,
1147 user_id
integer NOT NULL
1151 ALTER TABLE builds_watchers
OWNER TO pakfire
;
1154 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1157 CREATE SEQUENCE builds_watchers_id_seq
1165 ALTER TABLE builds_watchers_id_seq
OWNER TO pakfire
;
1168 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1171 ALTER SEQUENCE builds_watchers_id_seq
OWNED BY builds_watchers.
id;
1175 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1178 CREATE TABLE distributions (
1179 id integer NOT NULL,
1181 sname
text NOT NULL,
1182 slogan
text NOT NULL,
1184 vendor
text NOT NULL,
1187 deleted
boolean DEFAULT false NOT NULL
1191 ALTER TABLE distributions
OWNER TO pakfire
;
1194 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1197 CREATE TABLE distributions_arches (
1198 id integer NOT NULL,
1199 distro_id
integer NOT NULL,
1204 ALTER TABLE distributions_arches
OWNER TO pakfire
;
1207 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1210 CREATE SEQUENCE distributions_id_seq
1218 ALTER TABLE distributions_id_seq
OWNER TO pakfire
;
1221 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1224 ALTER SEQUENCE distributions_id_seq
OWNED BY distributions.
id;
1228 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1231 CREATE SEQUENCE distro_arches_id_seq
1239 ALTER TABLE distro_arches_id_seq
OWNER TO pakfire
;
1242 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1245 ALTER SEQUENCE distro_arches_id_seq
OWNED BY distributions_arches.
id;
1249 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1252 CREATE TABLE filelists (
1253 pkg_id
integer NOT NULL,
1255 size bigint NOT NULL,
1257 type integer NOT NULL,
1258 config filelists_config
NOT NULL,
1259 mode integer NOT NULL,
1260 "user" text NOT NULL,
1261 "group" text NOT NULL,
1262 mtime
timestamp without time zone NOT NULL,
1267 ALTER TABLE filelists
OWNER TO pakfire
;
1270 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1273 CREATE TABLE images_types (
1274 id integer NOT NULL,
1279 ALTER TABLE images_types
OWNER TO pakfire
;
1282 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1285 CREATE SEQUENCE images_types_id_seq
1293 ALTER TABLE images_types_id_seq
OWNER TO pakfire
;
1296 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1299 ALTER SEQUENCE images_types_id_seq
OWNED BY images_types.
id;
1303 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1306 CREATE TABLE jobs_buildroots (
1307 job_id
integer NOT NULL,
1308 tries
integer NOT NULL,
1309 pkg_uuid
text NOT NULL,
1310 pkg_name
text NOT NULL
1314 ALTER TABLE jobs_buildroots
OWNER TO pakfire
;
1317 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1320 CREATE TABLE jobs_history (
1321 job_id
integer NOT NULL,
1322 action jobs_history_action
NOT NULL,
1323 state jobs_history_state
,
1325 "time" timestamp without time zone NOT NULL,
1331 ALTER TABLE jobs_history
OWNER TO pakfire
;
1334 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1337 CREATE SEQUENCE jobs_id_seq
1345 ALTER TABLE jobs_id_seq
OWNER TO pakfire
;
1348 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1351 ALTER SEQUENCE jobs_id_seq
OWNED BY jobs.
id;
1355 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1358 CREATE TABLE jobs_packages (
1359 id integer NOT NULL,
1360 job_id
integer NOT NULL,
1361 pkg_id
integer NOT NULL
1365 ALTER TABLE jobs_packages
OWNER TO pakfire
;
1368 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1371 CREATE SEQUENCE jobs_packages_id_seq
1379 ALTER TABLE jobs_packages_id_seq
OWNER TO pakfire
;
1382 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1385 ALTER SEQUENCE jobs_packages_id_seq
OWNED BY jobs_packages.
id;
1389 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
1392 CREATE VIEW jobs_queue
AS
1394 arches.
name AS arch
,
1395 ( SELECT builders_ready.builder_id
1397 WHERE (builders_ready.builder_id
IN ( SELECT arches_builders.builder_id
1398 FROM arches_builders
1399 WHERE ((arches_builders.arch
= arches.
name) AND
1401 WHEN ((builds.
type = 'release'::builds_type) AND (jobs.
type = 'build'::jobs_type)) THEN (builders_ready.build_release
= 'Y'::builders_build_release)
1402 WHEN ((builds.
type = 'scratch'::builds_type) AND (jobs.
type = 'build'::jobs_type)) THEN (builders_ready.build_scratch
= 'Y'::builders_build_scratch)
1403 WHEN (jobs.
type = 'test'::jobs_type) THEN (builders_ready.build_test
= 'Y'::builders_build_test)
1406 LIMIT 1) AS designated_builder_id
1408 LEFT JOIN arches
ON ((jobs.arch
= arches.
name)))
1409 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
1410 WHERE ((jobs.
state = ANY (ARRAY['pending'::jobs_state, 'new'::jobs_state])) AND ((jobs.start_not_before
IS NULL) OR (jobs.start_not_before
<= now())))
1413 WHEN (jobs.
type = 'build'::jobs_type) THEN 0
1414 WHEN (jobs.
type = 'test'::jobs_type) THEN 1
1416 END, builds.priority
DESC, jobs.tries
, jobs.time_created
;
1419 ALTER TABLE jobs_queue
OWNER TO pakfire
;
1422 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1425 CREATE TABLE jobs_repos (
1426 job_id
integer NOT NULL,
1427 repo_id
integer NOT NULL
1431 ALTER TABLE jobs_repos
OWNER TO pakfire
;
1434 -- Name: jobs_waiting; Type: VIEW; Schema: public; Owner: pakfire
1437 CREATE VIEW jobs_waiting
AS
1438 SELECT jobs_queue.
id,
1439 (now() - (jobs.time_created
)::timestamp with time zone) AS time_waiting
1441 LEFT JOIN jobs
ON ((jobs_queue.
id = jobs.
id)))
1442 WHERE (jobs.start_not_before
IS NULL)
1444 SELECT jobs_queue.
id,
1445 (now() - (jobs.start_not_before
)::timestamp with time zone) AS time_waiting
1447 LEFT JOIN jobs
ON ((jobs_queue.
id = jobs.
id)))
1448 WHERE (jobs.start_not_before
IS NOT NULL);
1451 ALTER TABLE jobs_waiting
OWNER TO pakfire
;
1454 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1458 id integer NOT NULL,
1459 fingerprint
text NOT NULL,
1465 ALTER TABLE keys
OWNER TO pakfire
;
1468 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1471 CREATE SEQUENCE keys_id_seq
1479 ALTER TABLE keys_id_seq
OWNER TO pakfire
;
1482 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1485 ALTER SEQUENCE keys_id_seq
OWNED BY keys.
id;
1489 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1492 CREATE TABLE keys_subkeys (
1493 id integer NOT NULL,
1494 key_id
integer NOT NULL,
1495 fingerprint
text NOT NULL,
1496 time_created
timestamp without time zone NOT NULL,
1497 time_expires
timestamp without time zone,
1502 ALTER TABLE keys_subkeys
OWNER TO pakfire
;
1505 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1508 CREATE SEQUENCE keys_subkeys_id_seq
1516 ALTER TABLE keys_subkeys_id_seq
OWNER TO pakfire
;
1519 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1522 ALTER SEQUENCE keys_subkeys_id_seq
OWNED BY keys_subkeys.
id;
1526 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1529 CREATE TABLE logfiles (
1530 id integer NOT NULL,
1531 job_id
integer NOT NULL,
1533 filesize
bigint NOT NULL,
1534 hash_sha512
text NOT NULL
1538 ALTER TABLE logfiles
OWNER TO pakfire
;
1541 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1544 CREATE SEQUENCE logfiles_id_seq
1552 ALTER TABLE logfiles_id_seq
OWNER TO pakfire
;
1555 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1558 ALTER SEQUENCE logfiles_id_seq
OWNED BY logfiles.
id;
1562 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1565 CREATE TABLE mirrors (
1566 id integer NOT NULL,
1567 hostname
text NOT NULL,
1571 deleted
boolean DEFAULT false NOT NULL
1575 ALTER TABLE mirrors
OWNER TO pakfire
;
1578 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1581 CREATE TABLE mirrors_checks (
1582 id integer NOT NULL,
1583 mirror_id
integer NOT NULL,
1584 "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
1585 response_time
double precision,
1586 http_status
integer,
1587 last_sync_at
timestamp without time zone,
1588 status
text DEFAULT 'OK'::text NOT NULL
1592 ALTER TABLE mirrors_checks
OWNER TO pakfire
;
1595 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1598 CREATE SEQUENCE mirrors_checks_id_seq
1606 ALTER TABLE mirrors_checks_id_seq
OWNER TO pakfire
;
1609 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1612 ALTER SEQUENCE mirrors_checks_id_seq
OWNED BY mirrors_checks.
id;
1616 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1619 CREATE TABLE mirrors_history (
1620 id integer NOT NULL,
1621 mirror_id
integer NOT NULL,
1622 action mirrors_history_action
NOT NULL,
1624 "time" timestamp without time zone NOT NULL
1628 ALTER TABLE mirrors_history
OWNER TO pakfire
;
1631 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1634 CREATE SEQUENCE mirrors_history_id_seq
1642 ALTER TABLE mirrors_history_id_seq
OWNER TO pakfire
;
1645 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1648 ALTER SEQUENCE mirrors_history_id_seq
OWNED BY mirrors_history.
id;
1652 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1655 CREATE SEQUENCE mirrors_id_seq
1663 ALTER TABLE mirrors_id_seq
OWNER TO pakfire
;
1666 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1669 ALTER SEQUENCE mirrors_id_seq
OWNED BY mirrors.
id;
1673 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1676 CREATE TABLE packages_deps (
1677 pkg_id
integer NOT NULL,
1678 type packages_deps_type
NOT NULL,
1683 ALTER TABLE packages_deps
OWNER TO pakfire
;
1686 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1689 CREATE SEQUENCE packages_id_seq
1697 ALTER TABLE packages_id_seq
OWNER TO pakfire
;
1700 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1703 ALTER SEQUENCE packages_id_seq
OWNED BY packages.
id;
1707 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1710 CREATE TABLE packages_properties (
1711 id integer NOT NULL,
1713 critical_path packages_properties_critical_path
DEFAULT 'N'::packages_properties_critical_path NOT NULL,
1714 priority
integer DEFAULT 0 NOT NULL
1718 ALTER TABLE packages_properties
OWNER TO pakfire
;
1721 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1724 CREATE SEQUENCE packages_properties_id_seq
1732 ALTER TABLE packages_properties_id_seq
OWNER TO pakfire
;
1735 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1738 ALTER SEQUENCE packages_properties_id_seq
OWNED BY packages_properties.
id;
1742 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1745 CREATE TABLE queue_delete (
1746 id integer NOT NULL,
1751 ALTER TABLE queue_delete
OWNER TO pakfire
;
1754 -- Name: queue_delete_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1757 CREATE SEQUENCE queue_delete_id_seq
1765 ALTER TABLE queue_delete_id_seq
OWNER TO pakfire
;
1768 -- Name: queue_delete_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1771 ALTER SEQUENCE queue_delete_id_seq
OWNED BY queue_delete.
id;
1775 -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: pakfire
1778 CREATE VIEW relation_sizes
AS
1779 SELECT c.relname
AS relation
,
1780 pg_size_pretty(pg_relation_size((c.oid
)::regclass)) AS size
1782 LEFT JOIN pg_namespace n
ON ((n.oid
= c.relnamespace
)))
1783 WHERE (n.nspname
<> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name]))
1784 ORDER BY pg_relation_size((c.oid
)::regclass) DESC;
1787 ALTER TABLE relation_sizes
OWNER TO pakfire
;
1790 -- Name: repositories; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1793 CREATE TABLE repositories (
1794 id integer NOT NULL,
1796 type repositories_type
DEFAULT 'testing'::repositories_type NOT NULL,
1797 description
text NOT NULL,
1798 distro_id
integer NOT NULL,
1801 mirrored repositories_mirrored
DEFAULT 'N'::repositories_mirrored NOT NULL,
1802 enabled_for_builds repositories_enabled_for_builds
DEFAULT 'N'::repositories_enabled_for_builds NOT NULL,
1803 score_needed
integer DEFAULT 0 NOT NULL,
1804 last_update
timestamp without time zone,
1805 time_min
integer DEFAULT 0 NOT NULL,
1806 time_max
integer DEFAULT 0 NOT NULL,
1807 update_started
timestamp without time zone,
1808 update_ended
timestamp without time zone,
1809 deleted
boolean DEFAULT false NOT NULL
1813 ALTER TABLE repositories
OWNER TO pakfire
;
1816 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1819 CREATE TABLE repositories_aux (
1820 id integer NOT NULL,
1824 distro_id
integer NOT NULL,
1825 status repositories_aux_status
DEFAULT 'disabled'::repositories_aux_status NOT NULL
1829 ALTER TABLE repositories_aux
OWNER TO pakfire
;
1832 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1835 CREATE SEQUENCE repositories_aux_id_seq
1843 ALTER TABLE repositories_aux_id_seq
OWNER TO pakfire
;
1846 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1849 ALTER SEQUENCE repositories_aux_id_seq
OWNED BY repositories_aux.
id;
1853 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1856 CREATE SEQUENCE repositories_builds_id_seq
1864 ALTER TABLE repositories_builds_id_seq
OWNER TO pakfire
;
1867 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1870 ALTER SEQUENCE repositories_builds_id_seq
OWNED BY repositories_builds.
id;
1874 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1877 CREATE TABLE repositories_history (
1878 build_id
bigint NOT NULL,
1879 action repositories_history_action
NOT NULL,
1880 from_repo_id
integer,
1883 "time" timestamp without time zone NOT NULL
1887 ALTER TABLE repositories_history
OWNER TO pakfire
;
1890 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1893 CREATE SEQUENCE repositories_id_seq
1901 ALTER TABLE repositories_id_seq
OWNER TO pakfire
;
1904 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1907 ALTER SEQUENCE repositories_id_seq
OWNED BY repositories.
id;
1911 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1914 CREATE TABLE sessions (
1915 id integer NOT NULL,
1916 session_id
text NOT NULL,
1917 created_at
timestamp without time zone DEFAULT now() NOT NULL,
1918 valid_until
timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1919 user_id
integer NOT NULL,
1920 impersonated_user_id
integer,
1923 CONSTRAINT sessions_impersonation_check
CHECK (((impersonated_user_id
IS NULL) OR (user_id
<> impersonated_user_id
)))
1927 ALTER TABLE sessions
OWNER TO pakfire
;
1930 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1933 CREATE SEQUENCE sessions_id_seq
1941 ALTER TABLE sessions_id_seq
OWNER TO pakfire
;
1944 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1947 ALTER SEQUENCE sessions_id_seq
OWNED BY sessions.
id;
1951 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1954 CREATE TABLE settings (
1960 ALTER TABLE settings
OWNER TO pakfire
;
1963 -- Name: slogans; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1966 CREATE TABLE slogans (
1967 id integer NOT NULL,
1968 message
text NOT NULL
1972 ALTER TABLE slogans
OWNER TO pakfire
;
1975 -- Name: slogans_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1978 CREATE SEQUENCE slogans_id_seq
1986 ALTER TABLE slogans_id_seq
OWNER TO pakfire
;
1989 -- Name: slogans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1992 ALTER SEQUENCE slogans_id_seq
OWNED BY slogans.
id;
1996 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1999 CREATE TABLE sources (
2000 id integer NOT NULL,
2002 identifier
text NOT NULL,
2005 revision
text NOT NULL,
2006 branch
text NOT NULL,
2007 updated
timestamp without time zone,
2008 distro_id
integer NOT NULL
2012 ALTER TABLE sources
OWNER TO pakfire
;
2015 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2018 CREATE TABLE sources_commits (
2019 id integer NOT NULL,
2020 source_id
integer NOT NULL,
2021 revision
text NOT NULL,
2022 author
text NOT NULL,
2023 committer
text NOT NULL,
2024 subject
text NOT NULL,
2026 date timestamp without time zone NOT NULL,
2027 state sources_commits_state
DEFAULT 'pending'::sources_commits_state NOT NULL
2031 ALTER TABLE sources_commits
OWNER TO pakfire
;
2034 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2037 CREATE SEQUENCE sources_commits_id_seq
2045 ALTER TABLE sources_commits_id_seq
OWNER TO pakfire
;
2048 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2051 ALTER SEQUENCE sources_commits_id_seq
OWNED BY sources_commits.
id;
2055 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2058 CREATE SEQUENCE sources_id_seq
2066 ALTER TABLE sources_id_seq
OWNER TO pakfire
;
2069 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2072 ALTER SEQUENCE sources_id_seq
OWNED BY sources.
id;
2076 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2079 CREATE TABLE uploads (
2080 id integer NOT NULL,
2084 filename
text NOT NULL,
2086 size bigint NOT NULL,
2087 progress
bigint DEFAULT 0 NOT NULL,
2088 finished uploads_finished
DEFAULT 'N'::uploads_finished NOT NULL,
2089 time_started
timestamp without time zone DEFAULT now() NOT NULL,
2090 time_finished
timestamp without time zone
2094 ALTER TABLE uploads
OWNER TO pakfire
;
2097 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2100 CREATE SEQUENCE uploads_id_seq
2108 ALTER TABLE uploads_id_seq
OWNER TO pakfire
;
2111 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2114 ALTER SEQUENCE uploads_id_seq
OWNED BY uploads.
id;
2118 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2121 CREATE TABLE user_messages (
2122 id integer NOT NULL,
2125 subject
text NOT NULL,
2127 time_added
timestamp without time zone DEFAULT now() NOT NULL
2131 ALTER TABLE user_messages
OWNER TO pakfire
;
2134 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2137 CREATE SEQUENCE user_messages_id_seq
2145 ALTER TABLE user_messages_id_seq
OWNER TO pakfire
;
2148 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2151 ALTER SEQUENCE user_messages_id_seq
OWNED BY user_messages.
id;
2155 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2158 CREATE TABLE users (
2159 id integer NOT NULL,
2162 passphrase
text NOT NULL,
2163 state users_state
NOT NULL,
2166 activated users_activated
DEFAULT 'N'::users_activated NOT NULL,
2167 activation_code
text,
2168 deleted users_deleted
DEFAULT 'N'::users_deleted NOT NULL,
2169 registered
timestamp without time zone DEFAULT now() NOT NULL
2173 ALTER TABLE users
OWNER TO pakfire
;
2176 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2179 CREATE TABLE users_emails (
2180 id integer NOT NULL,
2181 user_id
integer NOT NULL,
2182 email
text NOT NULL,
2183 "primary" users_emails_primary
DEFAULT 'N'::users_emails_primary NOT NULL
2187 ALTER TABLE users_emails
OWNER TO pakfire
;
2190 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2193 CREATE SEQUENCE users_emails_id_seq
2201 ALTER TABLE users_emails_id_seq
OWNER TO pakfire
;
2204 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2207 ALTER SEQUENCE users_emails_id_seq
OWNED BY users_emails.
id;
2211 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2214 CREATE SEQUENCE users_id_seq
2222 ALTER TABLE users_id_seq
OWNER TO pakfire
;
2225 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2228 ALTER SEQUENCE users_id_seq
OWNED BY users.
id;
2232 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2235 CREATE TABLE users_permissions (
2236 id integer NOT NULL,
2237 user_id
integer NOT NULL,
2238 create_scratch_builds users_permissions_create_scratch_builds
DEFAULT 'N'::users_permissions_create_scratch_builds NOT NULL,
2239 maintain_builders users_permissions_maintain_builders
DEFAULT 'N'::users_permissions_maintain_builders NOT NULL,
2240 manage_critical_path users_permissions_manage_critical_path
DEFAULT 'N'::users_permissions_manage_critical_path NOT NULL,
2241 manage_mirrors users_permissions_manage_mirrors
DEFAULT 'N'::users_permissions_manage_mirrors NOT NULL,
2242 vote users_permissions_vote
DEFAULT 'N'::users_permissions_vote NOT NULL
2246 ALTER TABLE users_permissions
OWNER TO pakfire
;
2249 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2252 CREATE SEQUENCE users_permissions_id_seq
2260 ALTER TABLE users_permissions_id_seq
OWNER TO pakfire
;
2263 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2266 ALTER SEQUENCE users_permissions_id_seq
OWNED BY users_permissions.
id;
2270 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2273 ALTER TABLE ONLY arches
ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
2277 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2280 ALTER TABLE ONLY builders
ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
2284 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2287 ALTER TABLE ONLY builders_history
ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
2291 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2294 ALTER TABLE ONLY builds
ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
2298 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2301 ALTER TABLE ONLY builds_bugs
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
2305 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2308 ALTER TABLE ONLY builds_bugs_updates
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
2312 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2315 ALTER TABLE ONLY builds_comments
ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
2319 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2322 ALTER TABLE ONLY builds_history
ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
2326 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2329 ALTER TABLE ONLY builds_watchers
ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
2333 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2336 ALTER TABLE ONLY distributions
ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
2340 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2343 ALTER TABLE ONLY distributions_arches
ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
2347 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2350 ALTER TABLE ONLY images_types
ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
2354 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2357 ALTER TABLE ONLY jobs
ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
2361 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2364 ALTER TABLE ONLY jobs_packages
ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
2368 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2371 ALTER TABLE ONLY keys
ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
2375 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2378 ALTER TABLE ONLY keys_subkeys
ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
2382 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2385 ALTER TABLE ONLY logfiles
ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
2389 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2392 ALTER TABLE ONLY mirrors
ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
2396 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2399 ALTER TABLE ONLY mirrors_checks
ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
2403 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2406 ALTER TABLE ONLY mirrors_history
ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
2410 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2413 ALTER TABLE ONLY packages
ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
2417 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2420 ALTER TABLE ONLY packages_properties
ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
2424 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2427 ALTER TABLE ONLY queue_delete
ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
2431 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2434 ALTER TABLE ONLY repositories
ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
2438 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2441 ALTER TABLE ONLY repositories_aux
ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
2445 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2448 ALTER TABLE ONLY repositories_builds
ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
2452 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2455 ALTER TABLE ONLY sessions
ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
2459 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2462 ALTER TABLE ONLY slogans
ALTER COLUMN id SET DEFAULT nextval('slogans_id_seq'::regclass);
2466 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2469 ALTER TABLE ONLY sources
ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
2473 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2476 ALTER TABLE ONLY sources_commits
ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
2480 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2483 ALTER TABLE ONLY uploads
ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
2487 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2490 ALTER TABLE ONLY user_messages
ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
2494 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2497 ALTER TABLE ONLY users
ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
2501 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2504 ALTER TABLE ONLY users_emails
ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
2508 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2511 ALTER TABLE ONLY users_permissions
ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
2515 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2518 ALTER TABLE ONLY arches_compat
2519 ADD CONSTRAINT arches_compat_unique
UNIQUE (native_arch
, build_arch
);
2523 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2526 ALTER TABLE ONLY arches
2527 ADD CONSTRAINT arches_name
UNIQUE (name);
2531 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2534 ALTER TABLE ONLY arches
2535 ADD CONSTRAINT idx_2197943_primary
PRIMARY KEY (id);
2539 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2542 ALTER TABLE ONLY builders
2543 ADD CONSTRAINT idx_2197954_primary
PRIMARY KEY (id);
2547 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2550 ALTER TABLE ONLY builders_history
2551 ADD CONSTRAINT idx_2197982_primary
PRIMARY KEY (id);
2555 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2558 ALTER TABLE ONLY builds
2559 ADD CONSTRAINT idx_2197988_primary
PRIMARY KEY (id);
2563 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2566 ALTER TABLE ONLY builds_bugs
2567 ADD CONSTRAINT idx_2198002_primary
PRIMARY KEY (id);
2571 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2574 ALTER TABLE ONLY builds_bugs_updates
2575 ADD CONSTRAINT idx_2198008_primary
PRIMARY KEY (id);
2579 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2582 ALTER TABLE ONLY builds_comments
2583 ADD CONSTRAINT idx_2198018_primary
PRIMARY KEY (id);
2587 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2590 ALTER TABLE ONLY builds_history
2591 ADD CONSTRAINT idx_2198027_primary
PRIMARY KEY (id);
2595 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2598 ALTER TABLE ONLY builds_watchers
2599 ADD CONSTRAINT idx_2198033_primary
PRIMARY KEY (id);
2603 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2606 ALTER TABLE ONLY distributions
2607 ADD CONSTRAINT idx_2198039_primary
PRIMARY KEY (id);
2611 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2614 ALTER TABLE ONLY distributions_arches
2615 ADD CONSTRAINT idx_2198048_primary
PRIMARY KEY (id);
2619 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2622 ALTER TABLE ONLY images_types
2623 ADD CONSTRAINT idx_2198057_primary
PRIMARY KEY (id);
2627 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2630 ALTER TABLE ONLY jobs
2631 ADD CONSTRAINT idx_2198063_primary
PRIMARY KEY (id);
2635 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2638 ALTER TABLE ONLY jobs_packages
2639 ADD CONSTRAINT idx_2198085_primary
PRIMARY KEY (id);
2643 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2646 ALTER TABLE ONLY keys
2647 ADD CONSTRAINT idx_2198094_primary
PRIMARY KEY (id);
2651 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2654 ALTER TABLE ONLY keys_subkeys
2655 ADD CONSTRAINT idx_2198103_primary
PRIMARY KEY (id);
2659 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2662 ALTER TABLE ONLY logfiles
2663 ADD CONSTRAINT idx_2198109_primary
PRIMARY KEY (id);
2667 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2670 ALTER TABLE ONLY mirrors
2671 ADD CONSTRAINT idx_2198115_primary
PRIMARY KEY (id);
2675 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2678 ALTER TABLE ONLY mirrors_history
2679 ADD CONSTRAINT idx_2198126_primary
PRIMARY KEY (id);
2683 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2686 ALTER TABLE ONLY packages
2687 ADD CONSTRAINT idx_2198132_primary
PRIMARY KEY (id);
2691 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2694 ALTER TABLE ONLY packages_properties
2695 ADD CONSTRAINT idx_2198147_primary
PRIMARY KEY (id);
2699 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2702 ALTER TABLE ONLY queue_delete
2703 ADD CONSTRAINT idx_2198155_primary
PRIMARY KEY (id);
2707 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2710 ALTER TABLE ONLY repositories
2711 ADD CONSTRAINT idx_2198164_primary
PRIMARY KEY (id);
2715 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2718 ALTER TABLE ONLY repositories_aux
2719 ADD CONSTRAINT idx_2198179_primary
PRIMARY KEY (id);
2723 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2726 ALTER TABLE ONLY repositories_builds
2727 ADD CONSTRAINT idx_2198189_primary
PRIMARY KEY (id);
2731 -- Name: idx_2198207_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2734 ALTER TABLE ONLY slogans
2735 ADD CONSTRAINT idx_2198207_primary
PRIMARY KEY (id);
2739 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2742 ALTER TABLE ONLY sources
2743 ADD CONSTRAINT idx_2198213_primary
PRIMARY KEY (id);
2747 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2750 ALTER TABLE ONLY sources_commits
2751 ADD CONSTRAINT idx_2198222_primary
PRIMARY KEY (id);
2755 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2758 ALTER TABLE ONLY uploads
2759 ADD CONSTRAINT idx_2198232_primary
PRIMARY KEY (id);
2763 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2766 ALTER TABLE ONLY users
2767 ADD CONSTRAINT idx_2198244_primary
PRIMARY KEY (id);
2771 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2774 ALTER TABLE ONLY users_emails
2775 ADD CONSTRAINT idx_2198256_primary
PRIMARY KEY (id);
2779 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2782 ALTER TABLE ONLY users_permissions
2783 ADD CONSTRAINT idx_2198263_primary
PRIMARY KEY (id);
2787 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2790 ALTER TABLE ONLY user_messages
2791 ADD CONSTRAINT idx_2198274_primary
PRIMARY KEY (id);
2795 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2798 ALTER TABLE ONLY jobs_packages
2799 ADD CONSTRAINT jobs_packages_unique
UNIQUE (job_id
, pkg_id
);
2803 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2806 ALTER TABLE ONLY mirrors_checks
2807 ADD CONSTRAINT mirrors_checks_pkey
PRIMARY KEY (id);
2811 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2814 ALTER TABLE ONLY sessions
2815 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (id);
2819 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2822 ALTER TABLE ONLY sessions
2823 ADD CONSTRAINT sessions_session_id_key
UNIQUE (session_id
);
2827 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2830 CREATE INDEX arches_compat_native_arch
ON arches_compat
USING btree (native_arch
);
2834 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2837 CREATE UNIQUE INDEX builders_name
ON builders
USING btree (name) WHERE (deleted
IS FALSE);
2841 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2844 CREATE INDEX builds_watchers_build_id
ON builds_watchers
USING btree (build_id
);
2848 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2851 CREATE INDEX distributions_arches_distro_id
ON distributions_arches
USING btree (distro_id
);
2855 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2858 CREATE UNIQUE INDEX distributions_sname
ON distributions
USING btree (sname
) WHERE (deleted
IS FALSE);
2862 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2865 CREATE INDEX filelists_name
ON filelists
USING btree (name);
2869 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2872 CREATE INDEX idx_2197982_builder_id
ON builders_history
USING btree (builder_id
);
2876 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2879 CREATE INDEX idx_2197988_pkg_id
ON builds
USING btree (pkg_id
);
2883 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2886 CREATE INDEX idx_2197988_state
ON builds
USING btree (state);
2890 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2893 CREATE INDEX idx_2197988_type
ON builds
USING btree (type);
2897 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2900 CREATE UNIQUE INDEX idx_2197988_uuid
ON builds
USING btree (uuid
);
2904 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2907 CREATE UNIQUE INDEX idx_2198002_build_id
ON builds_bugs
USING btree (build_id
, bug_id
);
2911 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2914 CREATE INDEX idx_2198018_build_id
ON builds_comments
USING btree (build_id
);
2918 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2921 CREATE INDEX idx_2198018_user_id
ON builds_comments
USING btree (user_id
);
2925 -- Name: idx_2198052_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2928 CREATE INDEX idx_2198052_pkg_id
ON filelists
USING btree (pkg_id
);
2932 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2935 CREATE INDEX idx_2198063_build_id
ON jobs
USING btree (build_id
);
2939 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2942 CREATE INDEX idx_2198063_state
ON jobs
USING btree (state);
2946 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2949 CREATE INDEX idx_2198063_time_finished
ON jobs
USING btree (time_finished
);
2953 -- Name: idx_2198063_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2956 CREATE INDEX idx_2198063_type
ON jobs
USING btree (type);
2960 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2963 CREATE UNIQUE INDEX idx_2198063_uuid
ON jobs
USING btree (uuid
);
2967 -- Name: idx_2198074_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2970 CREATE INDEX idx_2198074_job_id
ON jobs_buildroots
USING btree (job_id
);
2974 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2977 CREATE INDEX idx_2198080_job_id
ON jobs_history
USING btree (job_id
);
2981 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2984 CREATE UNIQUE INDEX idx_2198089_job_id
ON jobs_repos
USING btree (job_id
, repo_id
);
2988 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2991 CREATE UNIQUE INDEX idx_2198094_fingerprint
ON keys
USING btree (fingerprint
);
2995 -- Name: idx_2198132_epoch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2998 CREATE INDEX idx_2198132_epoch
ON packages
USING btree (epoch
);
3002 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3005 CREATE INDEX idx_2198132_name
ON packages
USING btree (name);
3009 -- Name: idx_2198132_release; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3012 CREATE INDEX idx_2198132_release
ON packages
USING btree (release);
3016 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3019 CREATE INDEX idx_2198132_type
ON packages
USING btree (type);
3023 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3026 CREATE INDEX idx_2198132_uuid
ON packages
USING btree (uuid
);
3030 -- Name: idx_2198132_version; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3033 CREATE INDEX idx_2198132_version
ON packages
USING btree (version);
3037 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3040 CREATE INDEX idx_2198139_pkg_id
ON packages_deps
USING btree (pkg_id
);
3044 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3047 CREATE UNIQUE INDEX idx_2198147_name
ON packages_properties
USING btree (name);
3051 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3054 CREATE UNIQUE INDEX idx_2198189_build_id
ON repositories_builds
USING btree (build_id
);
3058 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3061 CREATE INDEX idx_2198193_build_id
ON repositories_history
USING btree (build_id
);
3065 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3068 CREATE UNIQUE INDEX idx_2198199_k
ON settings
USING btree (k
);
3072 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3075 CREATE UNIQUE INDEX idx_2198213_identifier
ON sources
USING btree (identifier
);
3079 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3082 CREATE INDEX idx_2198222_revision
ON sources_commits
USING btree (revision
);
3086 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3089 CREATE UNIQUE INDEX idx_2198232_uuid
ON uploads
USING btree (uuid
);
3093 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3096 CREATE UNIQUE INDEX idx_2198244_name
ON users
USING btree (name);
3100 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3103 CREATE UNIQUE INDEX idx_2198256_email
ON users_emails
USING btree (email
);
3107 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3110 CREATE INDEX idx_2198256_user_id
ON users_emails
USING btree (user_id
);
3114 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3117 CREATE INDEX jobs_arch
ON jobs
USING btree (arch
);
3121 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3124 CREATE INDEX jobs_buildroots_pkg_uuid
ON jobs_buildroots
USING btree (pkg_uuid
);
3128 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3131 CREATE INDEX mirrors_checks_sort
ON mirrors_checks
USING btree (mirror_id
, "timestamp");
3133 ALTER TABLE mirrors_checks
CLUSTER ON mirrors_checks_sort
;
3137 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
3140 CREATE TRIGGER on_update_current_timestamp
BEFORE UPDATE ON sources
FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
3144 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3147 ALTER TABLE ONLY arches_compat
3148 ADD CONSTRAINT arches_compat_build_arch
FOREIGN KEY (build_arch
) REFERENCES arches(name);
3152 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3155 ALTER TABLE ONLY builders_history
3156 ADD CONSTRAINT builders_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3160 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3163 ALTER TABLE ONLY builders_history
3164 ADD CONSTRAINT builders_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3168 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3171 ALTER TABLE ONLY builds_bugs
3172 ADD CONSTRAINT builds_bug_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3176 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3179 ALTER TABLE ONLY builds_comments
3180 ADD CONSTRAINT builds_comments_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3184 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3187 ALTER TABLE ONLY builds_comments
3188 ADD CONSTRAINT builds_comments_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3192 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3195 ALTER TABLE ONLY builds
3196 ADD CONSTRAINT builds_depends_on
FOREIGN KEY (depends_on
) REFERENCES builds(id);
3200 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3203 ALTER TABLE ONLY builds
3204 ADD CONSTRAINT builds_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3208 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3211 ALTER TABLE ONLY builds_history
3212 ADD CONSTRAINT builds_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3216 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3219 ALTER TABLE ONLY builds_history
3220 ADD CONSTRAINT builds_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3224 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3227 ALTER TABLE ONLY builds
3228 ADD CONSTRAINT builds_owner_id
FOREIGN KEY (owner_id
) REFERENCES users(id);
3232 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3235 ALTER TABLE ONLY builds
3236 ADD CONSTRAINT builds_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3240 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3243 ALTER TABLE ONLY builds_watchers
3244 ADD CONSTRAINT builds_watchers_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3248 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3251 ALTER TABLE ONLY builds_watchers
3252 ADD CONSTRAINT builds_watchers_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3256 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3259 ALTER TABLE ONLY distributions_arches
3260 ADD CONSTRAINT distributions_arches_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3264 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3267 ALTER TABLE ONLY distributions_arches
3268 ADD CONSTRAINT distro_arches_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3272 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3275 ALTER TABLE ONLY filelists
3276 ADD CONSTRAINT filelists_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3280 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3283 ALTER TABLE ONLY jobs
3284 ADD CONSTRAINT jobs_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3288 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3291 ALTER TABLE ONLY jobs
3292 ADD CONSTRAINT jobs_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3296 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3299 ALTER TABLE ONLY jobs
3300 ADD CONSTRAINT jobs_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3304 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3307 ALTER TABLE ONLY jobs_buildroots
3308 ADD CONSTRAINT jobs_buildroots_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3312 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3315 ALTER TABLE ONLY jobs_history
3316 ADD CONSTRAINT jobs_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3320 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3323 ALTER TABLE ONLY jobs_history
3324 ADD CONSTRAINT jobs_history_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3328 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3331 ALTER TABLE ONLY jobs_history
3332 ADD CONSTRAINT jobs_history_test_job_id
FOREIGN KEY (test_job_id
) REFERENCES jobs(id);
3336 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3339 ALTER TABLE ONLY jobs_history
3340 ADD CONSTRAINT jobs_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3344 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3347 ALTER TABLE ONLY jobs_packages
3348 ADD CONSTRAINT jobs_packaged_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3352 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3355 ALTER TABLE ONLY jobs_packages
3356 ADD CONSTRAINT jobs_packages_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3360 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3363 ALTER TABLE ONLY jobs_repos
3364 ADD CONSTRAINT jobs_repos_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3368 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3371 ALTER TABLE ONLY jobs_repos
3372 ADD CONSTRAINT jobs_repos_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3376 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3379 ALTER TABLE ONLY keys_subkeys
3380 ADD CONSTRAINT keys_subkeys_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3384 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3387 ALTER TABLE ONLY logfiles
3388 ADD CONSTRAINT logfiles_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3392 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3395 ALTER TABLE ONLY mirrors_checks
3396 ADD CONSTRAINT mirrors_checks_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3400 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3403 ALTER TABLE ONLY mirrors_history
3404 ADD CONSTRAINT mirrors_history_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3408 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3411 ALTER TABLE ONLY mirrors_history
3412 ADD CONSTRAINT mirrors_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3416 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3419 ALTER TABLE ONLY packages
3420 ADD CONSTRAINT packages_arch
FOREIGN KEY (arch
) REFERENCES arches(id);
3424 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3427 ALTER TABLE ONLY packages
3428 ADD CONSTRAINT packages_commit_id
FOREIGN KEY (commit_id
) REFERENCES sources_commits(id);
3432 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3435 ALTER TABLE ONLY packages_deps
3436 ADD CONSTRAINT packages_deps_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3440 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3443 ALTER TABLE ONLY repositories_aux
3444 ADD CONSTRAINT repositories_aux_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3448 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3451 ALTER TABLE ONLY repositories_builds
3452 ADD CONSTRAINT repositories_builds_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3456 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3459 ALTER TABLE ONLY repositories_builds
3460 ADD CONSTRAINT repositories_builds_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3464 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3467 ALTER TABLE ONLY repositories
3468 ADD CONSTRAINT repositories_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3472 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3475 ALTER TABLE ONLY repositories_history
3476 ADD CONSTRAINT repositories_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3480 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3483 ALTER TABLE ONLY repositories_history
3484 ADD CONSTRAINT repositories_history_from_repo_id
FOREIGN KEY (from_repo_id
) REFERENCES repositories(id);
3488 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3491 ALTER TABLE ONLY repositories_history
3492 ADD CONSTRAINT repositories_history_to_repo_id
FOREIGN KEY (to_repo_id
) REFERENCES repositories(id);
3496 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3499 ALTER TABLE ONLY repositories_history
3500 ADD CONSTRAINT repositories_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3504 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3507 ALTER TABLE ONLY repositories
3508 ADD CONSTRAINT repositories_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3512 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3515 ALTER TABLE ONLY repositories
3516 ADD CONSTRAINT repositories_parent_id
FOREIGN KEY (parent_id
) REFERENCES repositories(id);
3520 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3523 ALTER TABLE ONLY sessions
3524 ADD CONSTRAINT sessions_impersonated_user_id
FOREIGN KEY (impersonated_user_id
) REFERENCES users(id);
3528 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3531 ALTER TABLE ONLY sessions
3532 ADD CONSTRAINT sessions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3536 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3539 ALTER TABLE ONLY sources_commits
3540 ADD CONSTRAINT sources_commits_source_id
FOREIGN KEY (source_id
) REFERENCES sources(id);
3544 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3547 ALTER TABLE ONLY sources
3548 ADD CONSTRAINT sources_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3552 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3555 ALTER TABLE ONLY uploads
3556 ADD CONSTRAINT uploads_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3560 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3563 ALTER TABLE ONLY uploads
3564 ADD CONSTRAINT uploads_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3568 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3571 ALTER TABLE ONLY users_emails
3572 ADD CONSTRAINT users_emails_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3576 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3579 ALTER TABLE ONLY users_permissions
3580 ADD CONSTRAINT users_permissions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3584 -- PostgreSQL database dump complete