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: arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
654 CREATE SEQUENCE arches_id_seq
662 ALTER TABLE arches_id_seq
OWNER TO pakfire
;
665 -- Name: arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
668 ALTER SEQUENCE arches_id_seq
OWNED BY arches.
id;
672 -- Name: builders; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
675 CREATE TABLE builders (
680 enabled
boolean DEFAULT false NOT NULL,
681 deleted
boolean DEFAULT false NOT NULL,
682 loadavg
text DEFAULT '0'::character varying NOT NULL,
684 testmode
boolean DEFAULT true NOT NULL,
685 max_jobs
bigint DEFAULT 1::bigint NOT NULL,
686 pakfire_version
text,
689 cpu_count
integer DEFAULT 1 NOT NULL,
691 cpu_bogomips
double precision,
692 memory
bigint DEFAULT 0 NOT NULL,
693 overload builders_overload
DEFAULT 'N'::builders_overload NOT NULL,
694 free_space
bigint DEFAULT 0 NOT NULL,
696 time_created
timestamp without time zone DEFAULT now() NOT NULL,
697 time_updated
timestamp without time zone,
698 time_keepalive
timestamp without time zone,
699 loadavg1
double precision,
700 loadavg5
double precision,
701 loadavg15
double precision,
710 ALTER TABLE builders
OWNER TO pakfire
;
713 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
716 CREATE TABLE builders_history (
718 builder_id
integer NOT NULL,
719 action builders_history_action
NOT NULL,
721 "time" timestamp without time zone NOT NULL
725 ALTER TABLE builders_history
OWNER TO pakfire
;
728 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
731 CREATE SEQUENCE builders_history_id_seq
739 ALTER TABLE builders_history_id_seq
OWNER TO pakfire
;
742 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
745 ALTER SEQUENCE builders_history_id_seq
OWNED BY builders_history.
id;
749 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
752 CREATE SEQUENCE builders_id_seq
760 ALTER TABLE builders_id_seq
OWNER TO pakfire
;
763 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
766 ALTER SEQUENCE builders_id_seq
OWNED BY builders.
id;
770 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
773 CREATE TABLE builds (
776 pkg_id
integer NOT NULL,
777 type builds_type
DEFAULT 'release'::builds_type NOT NULL,
778 state builds_state
DEFAULT 'building'::builds_state NOT NULL,
779 severity builds_severity
,
781 time_created
timestamp without time zone NOT NULL,
785 distro_id
integer NOT NULL,
787 public builds_public
DEFAULT 'Y'::builds_public NOT NULL,
788 priority
integer DEFAULT 0 NOT NULL,
789 auto_move builds_auto_move
DEFAULT 'N'::builds_auto_move NOT NULL
793 ALTER TABLE builds
OWNER TO pakfire
;
796 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
799 CREATE TABLE builds_bugs (
801 build_id
integer NOT NULL,
802 bug_id
integer NOT NULL
806 ALTER TABLE builds_bugs
OWNER TO pakfire
;
809 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
812 CREATE SEQUENCE builds_bugs_id_seq
820 ALTER TABLE builds_bugs_id_seq
OWNER TO pakfire
;
823 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
826 ALTER SEQUENCE builds_bugs_id_seq
OWNED BY builds_bugs.
id;
830 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
833 CREATE TABLE builds_bugs_updates (
835 bug_id
integer NOT NULL,
839 "time" timestamp without time zone NOT NULL,
840 error
boolean DEFAULT false NOT NULL,
845 ALTER TABLE builds_bugs_updates
OWNER TO pakfire
;
848 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
851 CREATE SEQUENCE builds_bugs_updates_id_seq
859 ALTER TABLE builds_bugs_updates_id_seq
OWNER TO pakfire
;
862 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
865 ALTER SEQUENCE builds_bugs_updates_id_seq
OWNED BY builds_bugs_updates.
id;
869 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
872 CREATE TABLE builds_comments (
874 build_id
integer NOT NULL,
875 user_id
integer NOT NULL,
877 credit
integer NOT NULL,
878 time_created
timestamp without time zone NOT NULL,
879 time_updated
timestamp without time zone
883 ALTER TABLE builds_comments
OWNER TO pakfire
;
886 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
889 CREATE SEQUENCE builds_comments_id_seq
897 ALTER TABLE builds_comments_id_seq
OWNER TO pakfire
;
900 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
903 ALTER SEQUENCE builds_comments_id_seq
OWNED BY builds_comments.
id;
907 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
910 CREATE TABLE builds_history (
912 build_id
integer NOT NULL,
913 action builds_history_action
NOT NULL,
915 "time" timestamp without time zone NOT NULL,
920 ALTER TABLE builds_history
OWNER TO pakfire
;
923 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
926 CREATE SEQUENCE builds_history_id_seq
934 ALTER TABLE builds_history_id_seq
OWNER TO pakfire
;
937 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
940 ALTER SEQUENCE builds_history_id_seq
OWNED BY builds_history.
id;
944 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
947 CREATE SEQUENCE builds_id_seq
955 ALTER TABLE builds_id_seq
OWNER TO pakfire
;
958 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
961 ALTER SEQUENCE builds_id_seq
OWNED BY builds.
id;
965 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
968 CREATE TABLE packages (
971 epoch
integer NOT NULL,
972 version text NOT NULL,
973 release text NOT NULL,
974 type packages_type
NOT NULL,
975 arch
integer NOT NULL,
976 groups
text NOT NULL,
977 maintainer
text NOT NULL,
978 license
text NOT NULL,
980 summary
text NOT NULL,
981 description
text NOT NULL,
982 size bigint NOT NULL,
983 supported_arches
text,
986 build_id
text NOT NULL,
987 build_host
text NOT NULL,
988 build_time
timestamp without time zone NOT NULL,
990 filesize
bigint NOT NULL,
991 hash_sha512
text NOT NULL
995 ALTER TABLE packages
OWNER TO pakfire
;
998 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1001 CREATE TABLE repositories_builds (
1002 id integer NOT NULL,
1003 repo_id
integer NOT NULL,
1004 build_id
bigint NOT NULL,
1005 time_added
timestamp without time zone NOT NULL
1009 ALTER TABLE repositories_builds
OWNER TO pakfire
;
1012 -- Name: builds_latest; Type: VIEW; Schema: public; Owner: pakfire
1015 CREATE VIEW builds_latest
AS
1016 SELECT builds.
id AS build_id
,
1017 builds.
type AS build_type
,
1018 builds.
state AS build_state
,
1019 packages.
name AS package_name
,
1022 LEFT JOIN packages
ON ((builds.pkg_id
= packages.
id)))
1023 WHERE ((builds.
id IN ( SELECT repositories_builds.build_id
1024 FROM repositories_builds
)) OR ((builds.time_created
>= ( SELECT builds_1.time_created
1025 FROM ((builds builds_1
1026 LEFT JOIN repositories_builds
ON ((builds_1.
id = repositories_builds.build_id
)))
1027 LEFT JOIN packages p
ON ((builds_1.pkg_id
= p.
id)))
1028 WHERE (p.
name = packages.
name)
1029 ORDER BY builds_1.time_created
1030 LIMIT 1)) AND (builds.
state <> ALL (ARRAY['obsolete'::builds_state, 'broken'::builds_state]))));
1033 ALTER TABLE builds_latest
OWNER TO pakfire
;
1036 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1040 id integer NOT NULL,
1042 type jobs_type
DEFAULT 'build'::jobs_type NOT NULL,
1043 build_id
integer NOT NULL,
1044 state jobs_state
DEFAULT 'new'::jobs_state NOT NULL,
1046 time_created
timestamp without time zone NOT NULL,
1047 time_started
timestamp without time zone,
1048 time_finished
timestamp without time zone,
1049 start_not_before
timestamp without time zone,
1051 tries
integer DEFAULT 0 NOT NULL,
1052 aborted_state
integer DEFAULT 0 NOT NULL,
1057 ALTER TABLE jobs
OWNER TO pakfire
;
1060 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
1063 CREATE VIEW builds_times
AS
1064 SELECT builds.
id AS build_id
,
1067 jobs.
type AS job_type
,
1068 (jobs.time_finished
- jobs.time_started
) AS duration
1070 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
1071 LEFT JOIN packages
ON ((builds.pkg_id
= packages.
id)))
1072 LEFT JOIN arches
ON ((jobs.arch
= arches.
name)))
1073 WHERE (jobs.
state = 'finished'::jobs_state);
1076 ALTER TABLE builds_times
OWNER TO pakfire
;
1079 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1082 CREATE TABLE builds_watchers (
1083 id integer NOT NULL,
1084 build_id
integer NOT NULL,
1085 user_id
integer NOT NULL
1089 ALTER TABLE builds_watchers
OWNER TO pakfire
;
1092 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1095 CREATE SEQUENCE builds_watchers_id_seq
1103 ALTER TABLE builds_watchers_id_seq
OWNER TO pakfire
;
1106 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1109 ALTER SEQUENCE builds_watchers_id_seq
OWNED BY builds_watchers.
id;
1113 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1116 CREATE TABLE distributions (
1117 id integer NOT NULL,
1119 sname
text NOT NULL,
1120 slogan
text NOT NULL,
1122 vendor
text NOT NULL,
1125 deleted
boolean DEFAULT false NOT NULL
1129 ALTER TABLE distributions
OWNER TO pakfire
;
1132 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1135 CREATE TABLE distributions_arches (
1136 id integer NOT NULL,
1137 distro_id
integer NOT NULL,
1142 ALTER TABLE distributions_arches
OWNER TO pakfire
;
1145 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1148 CREATE SEQUENCE distributions_id_seq
1156 ALTER TABLE distributions_id_seq
OWNER TO pakfire
;
1159 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1162 ALTER SEQUENCE distributions_id_seq
OWNED BY distributions.
id;
1166 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1169 CREATE SEQUENCE distro_arches_id_seq
1177 ALTER TABLE distro_arches_id_seq
OWNER TO pakfire
;
1180 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1183 ALTER SEQUENCE distro_arches_id_seq
OWNED BY distributions_arches.
id;
1187 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1190 CREATE TABLE filelists (
1191 pkg_id
integer NOT NULL,
1193 size bigint NOT NULL,
1195 type integer NOT NULL,
1196 config filelists_config
NOT NULL,
1197 mode integer NOT NULL,
1198 "user" text NOT NULL,
1199 "group" text NOT NULL,
1200 mtime
timestamp without time zone NOT NULL,
1205 ALTER TABLE filelists
OWNER TO pakfire
;
1208 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1211 CREATE TABLE images_types (
1212 id integer NOT NULL,
1217 ALTER TABLE images_types
OWNER TO pakfire
;
1220 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1223 CREATE SEQUENCE images_types_id_seq
1231 ALTER TABLE images_types_id_seq
OWNER TO pakfire
;
1234 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1237 ALTER SEQUENCE images_types_id_seq
OWNED BY images_types.
id;
1241 -- Name: jobs_active; Type: VIEW; Schema: public; Owner: pakfire
1244 CREATE VIEW jobs_active
AS
1254 jobs.start_not_before
,
1260 WHERE (jobs.
state = ANY (ARRAY['dispatching'::jobs_state, 'running'::jobs_state, 'uploading'::jobs_state]))
1261 ORDER BY jobs.time_started
;
1264 ALTER TABLE jobs_active
OWNER TO pakfire
;
1267 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1270 CREATE TABLE jobs_buildroots (
1271 job_id
integer NOT NULL,
1272 tries
integer NOT NULL,
1273 pkg_uuid
text NOT NULL,
1274 pkg_name
text NOT NULL
1278 ALTER TABLE jobs_buildroots
OWNER TO pakfire
;
1281 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1284 CREATE TABLE jobs_history (
1285 job_id
integer NOT NULL,
1286 action jobs_history_action
NOT NULL,
1287 state jobs_history_state
,
1289 "time" timestamp without time zone NOT NULL,
1295 ALTER TABLE jobs_history
OWNER TO pakfire
;
1298 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1301 CREATE SEQUENCE jobs_id_seq
1309 ALTER TABLE jobs_id_seq
OWNER TO pakfire
;
1312 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1315 ALTER SEQUENCE jobs_id_seq
OWNED BY jobs.
id;
1319 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1322 CREATE TABLE jobs_packages (
1323 id integer NOT NULL,
1324 job_id
integer NOT NULL,
1325 pkg_id
integer NOT NULL
1329 ALTER TABLE jobs_packages
OWNER TO pakfire
;
1332 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1335 CREATE SEQUENCE jobs_packages_id_seq
1343 ALTER TABLE jobs_packages_id_seq
OWNER TO pakfire
;
1346 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1349 ALTER SEQUENCE jobs_packages_id_seq
OWNED BY jobs_packages.
id;
1353 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
1356 CREATE VIEW jobs_queue
AS
1359 rank() OVER (ORDER BY jobs.
type, builds.priority
DESC, jobs.tries
, jobs.time_created
) AS rank
1361 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
1362 WHERE (jobs.
state = 'pending'::jobs_state)
1364 SELECT queue.
id AS job_id
,
1369 ALTER TABLE jobs_queue
OWNER TO pakfire
;
1372 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1375 CREATE TABLE jobs_repos (
1376 job_id
integer NOT NULL,
1377 repo_id
integer NOT NULL
1381 ALTER TABLE jobs_repos
OWNER TO pakfire
;
1384 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1388 id integer NOT NULL,
1389 fingerprint
text NOT NULL,
1395 ALTER TABLE keys
OWNER TO pakfire
;
1398 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1401 CREATE SEQUENCE keys_id_seq
1409 ALTER TABLE keys_id_seq
OWNER TO pakfire
;
1412 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1415 ALTER SEQUENCE keys_id_seq
OWNED BY keys.
id;
1419 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1422 CREATE TABLE keys_subkeys (
1423 id integer NOT NULL,
1424 key_id
integer NOT NULL,
1425 fingerprint
text NOT NULL,
1426 time_created
timestamp without time zone NOT NULL,
1427 time_expires
timestamp without time zone,
1432 ALTER TABLE keys_subkeys
OWNER TO pakfire
;
1435 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1438 CREATE SEQUENCE keys_subkeys_id_seq
1446 ALTER TABLE keys_subkeys_id_seq
OWNER TO pakfire
;
1449 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1452 ALTER SEQUENCE keys_subkeys_id_seq
OWNED BY keys_subkeys.
id;
1456 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1459 CREATE TABLE logfiles (
1460 id integer NOT NULL,
1461 job_id
integer NOT NULL,
1463 filesize
bigint NOT NULL,
1464 hash_sha512
text NOT NULL
1468 ALTER TABLE logfiles
OWNER TO pakfire
;
1471 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1474 CREATE SEQUENCE logfiles_id_seq
1482 ALTER TABLE logfiles_id_seq
OWNER TO pakfire
;
1485 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1488 ALTER SEQUENCE logfiles_id_seq
OWNED BY logfiles.
id;
1492 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1495 CREATE TABLE mirrors (
1496 id integer NOT NULL,
1497 hostname
text NOT NULL,
1501 deleted
boolean DEFAULT false NOT NULL
1505 ALTER TABLE mirrors
OWNER TO pakfire
;
1508 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1511 CREATE TABLE mirrors_checks (
1512 id integer NOT NULL,
1513 mirror_id
integer NOT NULL,
1514 "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
1515 response_time
double precision,
1516 http_status
integer,
1517 last_sync_at
timestamp without time zone,
1518 status
text DEFAULT 'OK'::text NOT NULL
1522 ALTER TABLE mirrors_checks
OWNER TO pakfire
;
1525 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1528 CREATE SEQUENCE mirrors_checks_id_seq
1536 ALTER TABLE mirrors_checks_id_seq
OWNER TO pakfire
;
1539 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1542 ALTER SEQUENCE mirrors_checks_id_seq
OWNED BY mirrors_checks.
id;
1546 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1549 CREATE TABLE mirrors_history (
1550 id integer NOT NULL,
1551 mirror_id
integer NOT NULL,
1552 action mirrors_history_action
NOT NULL,
1554 "time" timestamp without time zone NOT NULL
1558 ALTER TABLE mirrors_history
OWNER TO pakfire
;
1561 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1564 CREATE SEQUENCE mirrors_history_id_seq
1572 ALTER TABLE mirrors_history_id_seq
OWNER TO pakfire
;
1575 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1578 ALTER SEQUENCE mirrors_history_id_seq
OWNED BY mirrors_history.
id;
1582 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1585 CREATE SEQUENCE mirrors_id_seq
1593 ALTER TABLE mirrors_id_seq
OWNER TO pakfire
;
1596 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1599 ALTER SEQUENCE mirrors_id_seq
OWNED BY mirrors.
id;
1603 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1606 CREATE TABLE packages_deps (
1607 pkg_id
integer NOT NULL,
1608 type packages_deps_type
NOT NULL,
1613 ALTER TABLE packages_deps
OWNER TO pakfire
;
1616 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1619 CREATE SEQUENCE packages_id_seq
1627 ALTER TABLE packages_id_seq
OWNER TO pakfire
;
1630 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1633 ALTER SEQUENCE packages_id_seq
OWNED BY packages.
id;
1637 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1640 CREATE TABLE packages_properties (
1641 id integer NOT NULL,
1643 critical_path packages_properties_critical_path
DEFAULT 'N'::packages_properties_critical_path NOT NULL,
1644 priority
integer DEFAULT 0 NOT NULL
1648 ALTER TABLE packages_properties
OWNER TO pakfire
;
1651 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1654 CREATE SEQUENCE packages_properties_id_seq
1662 ALTER TABLE packages_properties_id_seq
OWNER TO pakfire
;
1665 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1668 ALTER SEQUENCE packages_properties_id_seq
OWNED BY packages_properties.
id;
1672 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1675 CREATE TABLE queue_delete (
1676 id integer NOT NULL,
1681 ALTER TABLE queue_delete
OWNER TO pakfire
;
1684 -- Name: queue_delete_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1687 CREATE SEQUENCE queue_delete_id_seq
1695 ALTER TABLE queue_delete_id_seq
OWNER TO pakfire
;
1698 -- Name: queue_delete_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1701 ALTER SEQUENCE queue_delete_id_seq
OWNED BY queue_delete.
id;
1705 -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: pakfire
1708 CREATE VIEW relation_sizes
AS
1709 SELECT c.relname
AS relation
,
1710 pg_size_pretty(pg_relation_size((c.oid
)::regclass)) AS size
1712 LEFT JOIN pg_namespace n
ON ((n.oid
= c.relnamespace
)))
1713 WHERE (n.nspname
<> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name]))
1714 ORDER BY pg_relation_size((c.oid
)::regclass) DESC;
1717 ALTER TABLE relation_sizes
OWNER TO pakfire
;
1720 -- Name: repositories; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1723 CREATE TABLE repositories (
1724 id integer NOT NULL,
1726 type repositories_type
DEFAULT 'testing'::repositories_type NOT NULL,
1727 description
text NOT NULL,
1728 distro_id
integer NOT NULL,
1731 mirrored repositories_mirrored
DEFAULT 'N'::repositories_mirrored NOT NULL,
1732 enabled_for_builds repositories_enabled_for_builds
DEFAULT 'N'::repositories_enabled_for_builds NOT NULL,
1733 score_needed
integer DEFAULT 0 NOT NULL,
1734 last_update
timestamp without time zone,
1735 time_min
integer DEFAULT 0 NOT NULL,
1736 time_max
integer DEFAULT 0 NOT NULL,
1737 update_started
timestamp without time zone,
1738 update_ended
timestamp without time zone,
1739 deleted
boolean DEFAULT false NOT NULL
1743 ALTER TABLE repositories
OWNER TO pakfire
;
1746 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1749 CREATE TABLE repositories_aux (
1750 id integer NOT NULL,
1754 distro_id
integer NOT NULL,
1755 status repositories_aux_status
DEFAULT 'disabled'::repositories_aux_status NOT NULL
1759 ALTER TABLE repositories_aux
OWNER TO pakfire
;
1762 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1765 CREATE SEQUENCE repositories_aux_id_seq
1773 ALTER TABLE repositories_aux_id_seq
OWNER TO pakfire
;
1776 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1779 ALTER SEQUENCE repositories_aux_id_seq
OWNED BY repositories_aux.
id;
1783 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1786 CREATE SEQUENCE repositories_builds_id_seq
1794 ALTER TABLE repositories_builds_id_seq
OWNER TO pakfire
;
1797 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1800 ALTER SEQUENCE repositories_builds_id_seq
OWNED BY repositories_builds.
id;
1804 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1807 CREATE TABLE repositories_history (
1808 build_id
bigint NOT NULL,
1809 action repositories_history_action
NOT NULL,
1810 from_repo_id
integer,
1813 "time" timestamp without time zone NOT NULL
1817 ALTER TABLE repositories_history
OWNER TO pakfire
;
1820 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1823 CREATE SEQUENCE repositories_id_seq
1831 ALTER TABLE repositories_id_seq
OWNER TO pakfire
;
1834 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1837 ALTER SEQUENCE repositories_id_seq
OWNED BY repositories.
id;
1841 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1844 CREATE TABLE sessions (
1845 id integer NOT NULL,
1846 session_id
text NOT NULL,
1847 created_at
timestamp without time zone DEFAULT now() NOT NULL,
1848 valid_until
timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1849 user_id
integer NOT NULL,
1850 impersonated_user_id
integer,
1853 CONSTRAINT sessions_impersonation_check
CHECK (((impersonated_user_id
IS NULL) OR (user_id
<> impersonated_user_id
)))
1857 ALTER TABLE sessions
OWNER TO pakfire
;
1860 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1863 CREATE SEQUENCE sessions_id_seq
1871 ALTER TABLE sessions_id_seq
OWNER TO pakfire
;
1874 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1877 ALTER SEQUENCE sessions_id_seq
OWNED BY sessions.
id;
1881 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1884 CREATE TABLE settings (
1890 ALTER TABLE settings
OWNER TO pakfire
;
1893 -- Name: slogans; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1896 CREATE TABLE slogans (
1897 id integer NOT NULL,
1898 message
text NOT NULL
1902 ALTER TABLE slogans
OWNER TO pakfire
;
1905 -- Name: slogans_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1908 CREATE SEQUENCE slogans_id_seq
1916 ALTER TABLE slogans_id_seq
OWNER TO pakfire
;
1919 -- Name: slogans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1922 ALTER SEQUENCE slogans_id_seq
OWNED BY slogans.
id;
1926 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1929 CREATE TABLE sources (
1930 id integer NOT NULL,
1932 identifier
text NOT NULL,
1935 revision
text NOT NULL,
1936 branch
text NOT NULL,
1937 updated
timestamp without time zone,
1938 distro_id
integer NOT NULL
1942 ALTER TABLE sources
OWNER TO pakfire
;
1945 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1948 CREATE TABLE sources_commits (
1949 id integer NOT NULL,
1950 source_id
integer NOT NULL,
1951 revision
text NOT NULL,
1952 author
text NOT NULL,
1953 committer
text NOT NULL,
1954 subject
text NOT NULL,
1956 date timestamp without time zone NOT NULL,
1957 state sources_commits_state
DEFAULT 'pending'::sources_commits_state NOT NULL
1961 ALTER TABLE sources_commits
OWNER TO pakfire
;
1964 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1967 CREATE SEQUENCE sources_commits_id_seq
1975 ALTER TABLE sources_commits_id_seq
OWNER TO pakfire
;
1978 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1981 ALTER SEQUENCE sources_commits_id_seq
OWNED BY sources_commits.
id;
1985 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1988 CREATE SEQUENCE sources_id_seq
1996 ALTER TABLE sources_id_seq
OWNER TO pakfire
;
1999 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2002 ALTER SEQUENCE sources_id_seq
OWNED BY sources.
id;
2006 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2009 CREATE TABLE uploads (
2010 id integer NOT NULL,
2014 filename
text NOT NULL,
2016 size bigint NOT NULL,
2017 progress
bigint DEFAULT 0 NOT NULL,
2018 finished uploads_finished
DEFAULT 'N'::uploads_finished NOT NULL,
2019 time_started
timestamp without time zone DEFAULT now() NOT NULL,
2020 time_finished
timestamp without time zone
2024 ALTER TABLE uploads
OWNER TO pakfire
;
2027 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2030 CREATE SEQUENCE uploads_id_seq
2038 ALTER TABLE uploads_id_seq
OWNER TO pakfire
;
2041 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2044 ALTER SEQUENCE uploads_id_seq
OWNED BY uploads.
id;
2048 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2051 CREATE TABLE user_messages (
2052 id integer NOT NULL,
2055 subject
text NOT NULL,
2057 time_added
timestamp without time zone DEFAULT now() NOT NULL
2061 ALTER TABLE user_messages
OWNER TO pakfire
;
2064 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2067 CREATE SEQUENCE user_messages_id_seq
2075 ALTER TABLE user_messages_id_seq
OWNER TO pakfire
;
2078 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2081 ALTER SEQUENCE user_messages_id_seq
OWNED BY user_messages.
id;
2085 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2088 CREATE TABLE users (
2089 id integer NOT NULL,
2092 passphrase
text NOT NULL,
2093 state users_state
NOT NULL,
2096 activated users_activated
DEFAULT 'N'::users_activated NOT NULL,
2097 activation_code
text,
2098 deleted users_deleted
DEFAULT 'N'::users_deleted NOT NULL,
2099 registered
timestamp without time zone DEFAULT now() NOT NULL
2103 ALTER TABLE users
OWNER TO pakfire
;
2106 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2109 CREATE TABLE users_emails (
2110 id integer NOT NULL,
2111 user_id
integer NOT NULL,
2112 email
text NOT NULL,
2113 "primary" users_emails_primary
DEFAULT 'N'::users_emails_primary NOT NULL
2117 ALTER TABLE users_emails
OWNER TO pakfire
;
2120 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2123 CREATE SEQUENCE users_emails_id_seq
2131 ALTER TABLE users_emails_id_seq
OWNER TO pakfire
;
2134 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2137 ALTER SEQUENCE users_emails_id_seq
OWNED BY users_emails.
id;
2141 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2144 CREATE SEQUENCE users_id_seq
2152 ALTER TABLE users_id_seq
OWNER TO pakfire
;
2155 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2158 ALTER SEQUENCE users_id_seq
OWNED BY users.
id;
2162 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2165 CREATE TABLE users_permissions (
2166 id integer NOT NULL,
2167 user_id
integer NOT NULL,
2168 create_scratch_builds users_permissions_create_scratch_builds
DEFAULT 'N'::users_permissions_create_scratch_builds NOT NULL,
2169 maintain_builders users_permissions_maintain_builders
DEFAULT 'N'::users_permissions_maintain_builders NOT NULL,
2170 manage_critical_path users_permissions_manage_critical_path
DEFAULT 'N'::users_permissions_manage_critical_path NOT NULL,
2171 manage_mirrors users_permissions_manage_mirrors
DEFAULT 'N'::users_permissions_manage_mirrors NOT NULL,
2172 vote users_permissions_vote
DEFAULT 'N'::users_permissions_vote NOT NULL
2176 ALTER TABLE users_permissions
OWNER TO pakfire
;
2179 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2182 CREATE SEQUENCE users_permissions_id_seq
2190 ALTER TABLE users_permissions_id_seq
OWNER TO pakfire
;
2193 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2196 ALTER SEQUENCE users_permissions_id_seq
OWNED BY users_permissions.
id;
2200 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2203 ALTER TABLE ONLY arches
ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
2207 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2210 ALTER TABLE ONLY builders
ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
2214 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2217 ALTER TABLE ONLY builders_history
ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
2221 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2224 ALTER TABLE ONLY builds
ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
2228 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2231 ALTER TABLE ONLY builds_bugs
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
2235 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2238 ALTER TABLE ONLY builds_bugs_updates
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
2242 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2245 ALTER TABLE ONLY builds_comments
ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
2249 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2252 ALTER TABLE ONLY builds_history
ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
2256 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2259 ALTER TABLE ONLY builds_watchers
ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
2263 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2266 ALTER TABLE ONLY distributions
ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
2270 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2273 ALTER TABLE ONLY distributions_arches
ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
2277 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2280 ALTER TABLE ONLY images_types
ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
2284 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2287 ALTER TABLE ONLY jobs
ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
2291 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2294 ALTER TABLE ONLY jobs_packages
ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
2298 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2301 ALTER TABLE ONLY keys
ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
2305 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2308 ALTER TABLE ONLY keys_subkeys
ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
2312 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2315 ALTER TABLE ONLY logfiles
ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
2319 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2322 ALTER TABLE ONLY mirrors
ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
2326 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2329 ALTER TABLE ONLY mirrors_checks
ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
2333 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2336 ALTER TABLE ONLY mirrors_history
ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
2340 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2343 ALTER TABLE ONLY packages
ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
2347 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2350 ALTER TABLE ONLY packages_properties
ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
2354 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2357 ALTER TABLE ONLY queue_delete
ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
2361 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2364 ALTER TABLE ONLY repositories
ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
2368 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2371 ALTER TABLE ONLY repositories_aux
ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
2375 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2378 ALTER TABLE ONLY repositories_builds
ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
2382 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2385 ALTER TABLE ONLY sessions
ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
2389 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2392 ALTER TABLE ONLY slogans
ALTER COLUMN id SET DEFAULT nextval('slogans_id_seq'::regclass);
2396 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2399 ALTER TABLE ONLY sources
ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
2403 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2406 ALTER TABLE ONLY sources_commits
ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
2410 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2413 ALTER TABLE ONLY uploads
ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
2417 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2420 ALTER TABLE ONLY user_messages
ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
2424 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2427 ALTER TABLE ONLY users
ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
2431 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2434 ALTER TABLE ONLY users_emails
ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
2438 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2441 ALTER TABLE ONLY users_permissions
ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
2445 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2448 ALTER TABLE ONLY arches_compat
2449 ADD CONSTRAINT arches_compat_unique
UNIQUE (native_arch
, build_arch
);
2453 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2456 ALTER TABLE ONLY arches
2457 ADD CONSTRAINT arches_name
UNIQUE (name);
2461 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2464 ALTER TABLE ONLY arches
2465 ADD CONSTRAINT idx_2197943_primary
PRIMARY KEY (id);
2469 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2472 ALTER TABLE ONLY builders
2473 ADD CONSTRAINT idx_2197954_primary
PRIMARY KEY (id);
2477 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2480 ALTER TABLE ONLY builders_history
2481 ADD CONSTRAINT idx_2197982_primary
PRIMARY KEY (id);
2485 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2488 ALTER TABLE ONLY builds
2489 ADD CONSTRAINT idx_2197988_primary
PRIMARY KEY (id);
2493 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2496 ALTER TABLE ONLY builds_bugs
2497 ADD CONSTRAINT idx_2198002_primary
PRIMARY KEY (id);
2501 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2504 ALTER TABLE ONLY builds_bugs_updates
2505 ADD CONSTRAINT idx_2198008_primary
PRIMARY KEY (id);
2509 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2512 ALTER TABLE ONLY builds_comments
2513 ADD CONSTRAINT idx_2198018_primary
PRIMARY KEY (id);
2517 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2520 ALTER TABLE ONLY builds_history
2521 ADD CONSTRAINT idx_2198027_primary
PRIMARY KEY (id);
2525 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2528 ALTER TABLE ONLY builds_watchers
2529 ADD CONSTRAINT idx_2198033_primary
PRIMARY KEY (id);
2533 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2536 ALTER TABLE ONLY distributions
2537 ADD CONSTRAINT idx_2198039_primary
PRIMARY KEY (id);
2541 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2544 ALTER TABLE ONLY distributions_arches
2545 ADD CONSTRAINT idx_2198048_primary
PRIMARY KEY (id);
2549 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2552 ALTER TABLE ONLY images_types
2553 ADD CONSTRAINT idx_2198057_primary
PRIMARY KEY (id);
2557 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2560 ALTER TABLE ONLY jobs
2561 ADD CONSTRAINT idx_2198063_primary
PRIMARY KEY (id);
2565 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2568 ALTER TABLE ONLY jobs_packages
2569 ADD CONSTRAINT idx_2198085_primary
PRIMARY KEY (id);
2573 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2576 ALTER TABLE ONLY keys
2577 ADD CONSTRAINT idx_2198094_primary
PRIMARY KEY (id);
2581 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2584 ALTER TABLE ONLY keys_subkeys
2585 ADD CONSTRAINT idx_2198103_primary
PRIMARY KEY (id);
2589 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2592 ALTER TABLE ONLY logfiles
2593 ADD CONSTRAINT idx_2198109_primary
PRIMARY KEY (id);
2597 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2600 ALTER TABLE ONLY mirrors
2601 ADD CONSTRAINT idx_2198115_primary
PRIMARY KEY (id);
2605 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2608 ALTER TABLE ONLY mirrors_history
2609 ADD CONSTRAINT idx_2198126_primary
PRIMARY KEY (id);
2613 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2616 ALTER TABLE ONLY packages
2617 ADD CONSTRAINT idx_2198132_primary
PRIMARY KEY (id);
2621 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2624 ALTER TABLE ONLY packages_properties
2625 ADD CONSTRAINT idx_2198147_primary
PRIMARY KEY (id);
2629 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2632 ALTER TABLE ONLY queue_delete
2633 ADD CONSTRAINT idx_2198155_primary
PRIMARY KEY (id);
2637 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2640 ALTER TABLE ONLY repositories
2641 ADD CONSTRAINT idx_2198164_primary
PRIMARY KEY (id);
2645 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2648 ALTER TABLE ONLY repositories_aux
2649 ADD CONSTRAINT idx_2198179_primary
PRIMARY KEY (id);
2653 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2656 ALTER TABLE ONLY repositories_builds
2657 ADD CONSTRAINT idx_2198189_primary
PRIMARY KEY (id);
2661 -- Name: idx_2198207_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2664 ALTER TABLE ONLY slogans
2665 ADD CONSTRAINT idx_2198207_primary
PRIMARY KEY (id);
2669 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2672 ALTER TABLE ONLY sources
2673 ADD CONSTRAINT idx_2198213_primary
PRIMARY KEY (id);
2677 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2680 ALTER TABLE ONLY sources_commits
2681 ADD CONSTRAINT idx_2198222_primary
PRIMARY KEY (id);
2685 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2688 ALTER TABLE ONLY uploads
2689 ADD CONSTRAINT idx_2198232_primary
PRIMARY KEY (id);
2693 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2696 ALTER TABLE ONLY users
2697 ADD CONSTRAINT idx_2198244_primary
PRIMARY KEY (id);
2701 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2704 ALTER TABLE ONLY users_emails
2705 ADD CONSTRAINT idx_2198256_primary
PRIMARY KEY (id);
2709 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2712 ALTER TABLE ONLY users_permissions
2713 ADD CONSTRAINT idx_2198263_primary
PRIMARY KEY (id);
2717 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2720 ALTER TABLE ONLY user_messages
2721 ADD CONSTRAINT idx_2198274_primary
PRIMARY KEY (id);
2725 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2728 ALTER TABLE ONLY jobs_packages
2729 ADD CONSTRAINT jobs_packages_unique
UNIQUE (job_id
, pkg_id
);
2733 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2736 ALTER TABLE ONLY mirrors_checks
2737 ADD CONSTRAINT mirrors_checks_pkey
PRIMARY KEY (id);
2741 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2744 ALTER TABLE ONLY sessions
2745 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (id);
2749 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2752 ALTER TABLE ONLY sessions
2753 ADD CONSTRAINT sessions_session_id_key
UNIQUE (session_id
);
2757 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2760 CREATE INDEX arches_compat_native_arch
ON arches_compat
USING btree (native_arch
);
2764 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2767 CREATE UNIQUE INDEX builders_name
ON builders
USING btree (name) WHERE (deleted
IS FALSE);
2771 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2774 CREATE INDEX builds_watchers_build_id
ON builds_watchers
USING btree (build_id
);
2778 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2781 CREATE INDEX distributions_arches_distro_id
ON distributions_arches
USING btree (distro_id
);
2785 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2788 CREATE UNIQUE INDEX distributions_sname
ON distributions
USING btree (sname
) WHERE (deleted
IS FALSE);
2792 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2795 CREATE INDEX filelists_name
ON filelists
USING btree (name);
2799 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2802 CREATE INDEX idx_2197982_builder_id
ON builders_history
USING btree (builder_id
);
2806 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2809 CREATE INDEX idx_2197988_pkg_id
ON builds
USING btree (pkg_id
);
2813 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2816 CREATE INDEX idx_2197988_state
ON builds
USING btree (state);
2820 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2823 CREATE INDEX idx_2197988_type
ON builds
USING btree (type);
2827 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2830 CREATE UNIQUE INDEX idx_2197988_uuid
ON builds
USING btree (uuid
);
2834 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2837 CREATE UNIQUE INDEX idx_2198002_build_id
ON builds_bugs
USING btree (build_id
, bug_id
);
2841 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2844 CREATE INDEX idx_2198018_build_id
ON builds_comments
USING btree (build_id
);
2848 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2851 CREATE INDEX idx_2198018_user_id
ON builds_comments
USING btree (user_id
);
2855 -- Name: idx_2198052_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2858 CREATE INDEX idx_2198052_pkg_id
ON filelists
USING btree (pkg_id
);
2862 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2865 CREATE INDEX idx_2198063_build_id
ON jobs
USING btree (build_id
);
2869 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2872 CREATE INDEX idx_2198063_state
ON jobs
USING btree (state);
2876 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2879 CREATE INDEX idx_2198063_time_finished
ON jobs
USING btree (time_finished
);
2883 -- Name: idx_2198063_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2886 CREATE INDEX idx_2198063_type
ON jobs
USING btree (type);
2890 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2893 CREATE UNIQUE INDEX idx_2198063_uuid
ON jobs
USING btree (uuid
);
2897 -- Name: idx_2198074_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2900 CREATE INDEX idx_2198074_job_id
ON jobs_buildroots
USING btree (job_id
);
2904 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2907 CREATE INDEX idx_2198080_job_id
ON jobs_history
USING btree (job_id
);
2911 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2914 CREATE UNIQUE INDEX idx_2198089_job_id
ON jobs_repos
USING btree (job_id
, repo_id
);
2918 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2921 CREATE UNIQUE INDEX idx_2198094_fingerprint
ON keys
USING btree (fingerprint
);
2925 -- Name: idx_2198132_epoch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2928 CREATE INDEX idx_2198132_epoch
ON packages
USING btree (epoch
);
2932 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2935 CREATE INDEX idx_2198132_name
ON packages
USING btree (name);
2939 -- Name: idx_2198132_release; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2942 CREATE INDEX idx_2198132_release
ON packages
USING btree (release);
2946 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2949 CREATE INDEX idx_2198132_type
ON packages
USING btree (type);
2953 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2956 CREATE INDEX idx_2198132_uuid
ON packages
USING btree (uuid
);
2960 -- Name: idx_2198132_version; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2963 CREATE INDEX idx_2198132_version
ON packages
USING btree (version);
2967 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2970 CREATE INDEX idx_2198139_pkg_id
ON packages_deps
USING btree (pkg_id
);
2974 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2977 CREATE UNIQUE INDEX idx_2198147_name
ON packages_properties
USING btree (name);
2981 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2984 CREATE UNIQUE INDEX idx_2198189_build_id
ON repositories_builds
USING btree (build_id
);
2988 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2991 CREATE INDEX idx_2198193_build_id
ON repositories_history
USING btree (build_id
);
2995 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2998 CREATE UNIQUE INDEX idx_2198199_k
ON settings
USING btree (k
);
3002 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3005 CREATE UNIQUE INDEX idx_2198213_identifier
ON sources
USING btree (identifier
);
3009 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3012 CREATE INDEX idx_2198222_revision
ON sources_commits
USING btree (revision
);
3016 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3019 CREATE UNIQUE INDEX idx_2198232_uuid
ON uploads
USING btree (uuid
);
3023 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3026 CREATE UNIQUE INDEX idx_2198244_name
ON users
USING btree (name);
3030 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3033 CREATE UNIQUE INDEX idx_2198256_email
ON users_emails
USING btree (email
);
3037 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3040 CREATE INDEX idx_2198256_user_id
ON users_emails
USING btree (user_id
);
3044 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3047 CREATE INDEX jobs_arch
ON jobs
USING btree (arch
);
3051 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3054 CREATE INDEX jobs_buildroots_pkg_uuid
ON jobs_buildroots
USING btree (pkg_uuid
);
3058 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
3061 CREATE INDEX mirrors_checks_sort
ON mirrors_checks
USING btree (mirror_id
, "timestamp");
3063 ALTER TABLE mirrors_checks
CLUSTER ON mirrors_checks_sort
;
3067 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
3070 CREATE TRIGGER on_update_current_timestamp
BEFORE UPDATE ON sources
FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
3074 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3077 ALTER TABLE ONLY arches_compat
3078 ADD CONSTRAINT arches_compat_build_arch
FOREIGN KEY (build_arch
) REFERENCES arches(name);
3082 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3085 ALTER TABLE ONLY builders_history
3086 ADD CONSTRAINT builders_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3090 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3093 ALTER TABLE ONLY builders_history
3094 ADD CONSTRAINT builders_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3098 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3101 ALTER TABLE ONLY builds_bugs
3102 ADD CONSTRAINT builds_bug_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3106 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3109 ALTER TABLE ONLY builds_comments
3110 ADD CONSTRAINT builds_comments_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3114 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3117 ALTER TABLE ONLY builds_comments
3118 ADD CONSTRAINT builds_comments_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3122 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3125 ALTER TABLE ONLY builds
3126 ADD CONSTRAINT builds_depends_on
FOREIGN KEY (depends_on
) REFERENCES builds(id);
3130 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3133 ALTER TABLE ONLY builds
3134 ADD CONSTRAINT builds_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3138 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3141 ALTER TABLE ONLY builds_history
3142 ADD CONSTRAINT builds_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3146 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3149 ALTER TABLE ONLY builds_history
3150 ADD CONSTRAINT builds_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3154 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3157 ALTER TABLE ONLY builds
3158 ADD CONSTRAINT builds_owner_id
FOREIGN KEY (owner_id
) REFERENCES users(id);
3162 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3165 ALTER TABLE ONLY builds
3166 ADD CONSTRAINT builds_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3170 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3173 ALTER TABLE ONLY builds_watchers
3174 ADD CONSTRAINT builds_watchers_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3178 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3181 ALTER TABLE ONLY builds_watchers
3182 ADD CONSTRAINT builds_watchers_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3186 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3189 ALTER TABLE ONLY distributions_arches
3190 ADD CONSTRAINT distributions_arches_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3194 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3197 ALTER TABLE ONLY distributions_arches
3198 ADD CONSTRAINT distro_arches_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3202 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3205 ALTER TABLE ONLY filelists
3206 ADD CONSTRAINT filelists_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3210 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3213 ALTER TABLE ONLY jobs
3214 ADD CONSTRAINT jobs_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3218 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3221 ALTER TABLE ONLY jobs
3222 ADD CONSTRAINT jobs_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3226 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3229 ALTER TABLE ONLY jobs
3230 ADD CONSTRAINT jobs_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3234 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3237 ALTER TABLE ONLY jobs_buildroots
3238 ADD CONSTRAINT jobs_buildroots_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3242 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3245 ALTER TABLE ONLY jobs_history
3246 ADD CONSTRAINT jobs_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3250 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3253 ALTER TABLE ONLY jobs_history
3254 ADD CONSTRAINT jobs_history_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3258 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3261 ALTER TABLE ONLY jobs_history
3262 ADD CONSTRAINT jobs_history_test_job_id
FOREIGN KEY (test_job_id
) REFERENCES jobs(id);
3266 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3269 ALTER TABLE ONLY jobs_history
3270 ADD CONSTRAINT jobs_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3274 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3277 ALTER TABLE ONLY jobs_packages
3278 ADD CONSTRAINT jobs_packaged_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3282 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3285 ALTER TABLE ONLY jobs_packages
3286 ADD CONSTRAINT jobs_packages_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3290 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3293 ALTER TABLE ONLY jobs_repos
3294 ADD CONSTRAINT jobs_repos_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3298 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3301 ALTER TABLE ONLY jobs_repos
3302 ADD CONSTRAINT jobs_repos_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3306 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3309 ALTER TABLE ONLY keys_subkeys
3310 ADD CONSTRAINT keys_subkeys_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3314 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3317 ALTER TABLE ONLY logfiles
3318 ADD CONSTRAINT logfiles_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3322 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3325 ALTER TABLE ONLY mirrors_checks
3326 ADD CONSTRAINT mirrors_checks_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3330 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3333 ALTER TABLE ONLY mirrors_history
3334 ADD CONSTRAINT mirrors_history_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3338 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3341 ALTER TABLE ONLY mirrors_history
3342 ADD CONSTRAINT mirrors_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3346 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3349 ALTER TABLE ONLY packages
3350 ADD CONSTRAINT packages_arch
FOREIGN KEY (arch
) REFERENCES arches(id);
3354 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3357 ALTER TABLE ONLY packages
3358 ADD CONSTRAINT packages_commit_id
FOREIGN KEY (commit_id
) REFERENCES sources_commits(id);
3362 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3365 ALTER TABLE ONLY packages_deps
3366 ADD CONSTRAINT packages_deps_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3370 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3373 ALTER TABLE ONLY repositories_aux
3374 ADD CONSTRAINT repositories_aux_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3378 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3381 ALTER TABLE ONLY repositories_builds
3382 ADD CONSTRAINT repositories_builds_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3386 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3389 ALTER TABLE ONLY repositories_builds
3390 ADD CONSTRAINT repositories_builds_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3394 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3397 ALTER TABLE ONLY repositories
3398 ADD CONSTRAINT repositories_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3402 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3405 ALTER TABLE ONLY repositories_history
3406 ADD CONSTRAINT repositories_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3410 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3413 ALTER TABLE ONLY repositories_history
3414 ADD CONSTRAINT repositories_history_from_repo_id
FOREIGN KEY (from_repo_id
) REFERENCES repositories(id);
3418 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3421 ALTER TABLE ONLY repositories_history
3422 ADD CONSTRAINT repositories_history_to_repo_id
FOREIGN KEY (to_repo_id
) REFERENCES repositories(id);
3426 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3429 ALTER TABLE ONLY repositories_history
3430 ADD CONSTRAINT repositories_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3434 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3437 ALTER TABLE ONLY repositories
3438 ADD CONSTRAINT repositories_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3442 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3445 ALTER TABLE ONLY repositories
3446 ADD CONSTRAINT repositories_parent_id
FOREIGN KEY (parent_id
) REFERENCES repositories(id);
3450 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3453 ALTER TABLE ONLY sessions
3454 ADD CONSTRAINT sessions_impersonated_user_id
FOREIGN KEY (impersonated_user_id
) REFERENCES users(id);
3458 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3461 ALTER TABLE ONLY sessions
3462 ADD CONSTRAINT sessions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3466 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3469 ALTER TABLE ONLY sources_commits
3470 ADD CONSTRAINT sources_commits_source_id
FOREIGN KEY (source_id
) REFERENCES sources(id);
3474 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3477 ALTER TABLE ONLY sources
3478 ADD CONSTRAINT sources_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3482 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3485 ALTER TABLE ONLY uploads
3486 ADD CONSTRAINT uploads_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3490 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3493 ALTER TABLE ONLY uploads
3494 ADD CONSTRAINT uploads_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3498 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3501 ALTER TABLE ONLY users_emails
3502 ADD CONSTRAINT users_emails_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3506 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3509 ALTER TABLE ONLY users_permissions
3510 ADD CONSTRAINT users_permissions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3514 -- PostgreSQL database dump complete