2 -- PostgreSQL database dump
5 SET statement_timeout
= 0;
7 SET client_encoding
= 'UTF8';
8 SET standard_conforming_strings
= on;
9 SET check_function_bodies
= false;
10 SET client_min_messages
= warning
;
13 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
16 CREATE EXTENSION
IF NOT EXISTS plpgsql
WITH SCHEMA pg_catalog
;
20 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
23 COMMENT ON EXTENSION plpgsql
IS 'PL/pgSQL procedural language';
26 SET search_path
= public, pg_catalog
;
29 -- Name: arches_binary; Type: TYPE; Schema: public; Owner: pakfire
32 CREATE TYPE arches_binary
AS ENUM (
38 ALTER TYPE arches_binary
OWNER TO pakfire
;
41 -- Name: builders_disabled; Type: TYPE; Schema: public; Owner: pakfire
44 CREATE TYPE builders_disabled
AS ENUM (
50 ALTER TYPE builders_disabled
OWNER TO pakfire
;
53 -- Name: builders_history_action; Type: TYPE; Schema: public; Owner: pakfire
56 CREATE TYPE builders_history_action
AS ENUM (
64 ALTER TYPE builders_history_action
OWNER TO pakfire
;
67 -- Name: builders_overload; Type: TYPE; Schema: public; Owner: pakfire
70 CREATE TYPE builders_overload
AS ENUM (
76 ALTER TYPE builders_overload
OWNER TO pakfire
;
79 -- Name: builds_auto_move; Type: TYPE; Schema: public; Owner: pakfire
82 CREATE TYPE builds_auto_move
AS ENUM (
88 ALTER TYPE builds_auto_move
OWNER TO pakfire
;
91 -- Name: builds_history_action; Type: TYPE; Schema: public; Owner: pakfire
94 CREATE TYPE builds_history_action
AS ENUM (
101 ALTER TYPE builds_history_action
OWNER TO pakfire
;
104 -- Name: builds_public; Type: TYPE; Schema: public; Owner: pakfire
107 CREATE TYPE builds_public
AS ENUM (
113 ALTER TYPE builds_public
OWNER TO pakfire
;
116 -- Name: builds_severity; Type: TYPE; Schema: public; Owner: pakfire
119 CREATE TYPE builds_severity
AS ENUM (
127 ALTER TYPE builds_severity
OWNER TO pakfire
;
130 -- Name: builds_state; Type: TYPE; Schema: public; Owner: pakfire
133 CREATE TYPE builds_state
AS ENUM (
142 ALTER TYPE builds_state
OWNER TO pakfire
;
145 -- Name: builds_type; Type: TYPE; Schema: public; Owner: pakfire
148 CREATE TYPE builds_type
AS ENUM (
154 ALTER TYPE builds_type
OWNER TO pakfire
;
157 -- Name: filelists_config; Type: TYPE; Schema: public; Owner: pakfire
160 CREATE TYPE filelists_config
AS ENUM (
166 ALTER TYPE filelists_config
OWNER TO pakfire
;
169 -- Name: jobs_history_action; Type: TYPE; Schema: public; Owner: pakfire
172 CREATE TYPE jobs_history_action
AS ENUM (
181 ALTER TYPE jobs_history_action
OWNER TO pakfire
;
184 -- Name: jobs_history_state; Type: TYPE; Schema: public; Owner: pakfire
187 CREATE TYPE jobs_history_state
AS ENUM (
203 ALTER TYPE jobs_history_state
OWNER TO pakfire
;
206 -- Name: jobs_state; Type: TYPE; Schema: public; Owner: pakfire
209 CREATE TYPE jobs_state
AS ENUM (
225 ALTER TYPE jobs_state
OWNER TO pakfire
;
228 -- Name: jobs_type; Type: TYPE; Schema: public; Owner: pakfire
231 CREATE TYPE jobs_type
AS ENUM (
237 ALTER TYPE jobs_type
OWNER TO pakfire
;
240 -- Name: mirrors_history_action; Type: TYPE; Schema: public; Owner: pakfire
243 CREATE TYPE mirrors_history_action
AS ENUM (
251 ALTER TYPE mirrors_history_action
OWNER TO pakfire
;
254 -- Name: packages_deps_type; Type: TYPE; Schema: public; Owner: pakfire
257 CREATE TYPE packages_deps_type
AS ENUM (
268 ALTER TYPE packages_deps_type
OWNER TO pakfire
;
271 -- Name: packages_properties_critical_path; Type: TYPE; Schema: public; Owner: pakfire
274 CREATE TYPE packages_properties_critical_path
AS ENUM (
280 ALTER TYPE packages_properties_critical_path
OWNER TO pakfire
;
283 -- Name: packages_type; Type: TYPE; Schema: public; Owner: pakfire
286 CREATE TYPE packages_type
AS ENUM (
292 ALTER TYPE packages_type
OWNER TO pakfire
;
295 -- Name: repositories_aux_status; Type: TYPE; Schema: public; Owner: pakfire
298 CREATE TYPE repositories_aux_status
AS ENUM (
304 ALTER TYPE repositories_aux_status
OWNER TO pakfire
;
307 -- Name: repositories_enabled_for_builds; Type: TYPE; Schema: public; Owner: pakfire
310 CREATE TYPE repositories_enabled_for_builds
AS ENUM (
316 ALTER TYPE repositories_enabled_for_builds
OWNER TO pakfire
;
319 -- Name: repositories_history_action; Type: TYPE; Schema: public; Owner: pakfire
322 CREATE TYPE repositories_history_action
AS ENUM (
329 ALTER TYPE repositories_history_action
OWNER TO pakfire
;
332 -- Name: repositories_mirrored; Type: TYPE; Schema: public; Owner: pakfire
335 CREATE TYPE repositories_mirrored
AS ENUM (
341 ALTER TYPE repositories_mirrored
OWNER TO pakfire
;
344 -- Name: repositories_type; Type: TYPE; Schema: public; Owner: pakfire
347 CREATE TYPE repositories_type
AS ENUM (
354 ALTER TYPE repositories_type
OWNER TO pakfire
;
357 -- Name: sources_commits_state; Type: TYPE; Schema: public; Owner: pakfire
360 CREATE TYPE sources_commits_state
AS ENUM (
368 ALTER TYPE sources_commits_state
OWNER TO pakfire
;
371 -- Name: uploads_finished; Type: TYPE; Schema: public; Owner: pakfire
374 CREATE TYPE uploads_finished
AS ENUM (
380 ALTER TYPE uploads_finished
OWNER TO pakfire
;
383 -- Name: users_activated; Type: TYPE; Schema: public; Owner: pakfire
386 CREATE TYPE users_activated
AS ENUM (
392 ALTER TYPE users_activated
OWNER TO pakfire
;
395 -- Name: users_deleted; Type: TYPE; Schema: public; Owner: pakfire
398 CREATE TYPE users_deleted
AS ENUM (
404 ALTER TYPE users_deleted
OWNER TO pakfire
;
407 -- Name: users_emails_primary; Type: TYPE; Schema: public; Owner: pakfire
410 CREATE TYPE users_emails_primary
AS ENUM (
416 ALTER TYPE users_emails_primary
OWNER TO pakfire
;
419 -- Name: users_permissions_create_scratch_builds; Type: TYPE; Schema: public; Owner: pakfire
422 CREATE TYPE users_permissions_create_scratch_builds
AS ENUM (
428 ALTER TYPE users_permissions_create_scratch_builds
OWNER TO pakfire
;
431 -- Name: users_permissions_maintain_builders; Type: TYPE; Schema: public; Owner: pakfire
434 CREATE TYPE users_permissions_maintain_builders
AS ENUM (
440 ALTER TYPE users_permissions_maintain_builders
OWNER TO pakfire
;
443 -- Name: users_permissions_manage_critical_path; Type: TYPE; Schema: public; Owner: pakfire
446 CREATE TYPE users_permissions_manage_critical_path
AS ENUM (
452 ALTER TYPE users_permissions_manage_critical_path
OWNER TO pakfire
;
455 -- Name: users_permissions_manage_mirrors; Type: TYPE; Schema: public; Owner: pakfire
458 CREATE TYPE users_permissions_manage_mirrors
AS ENUM (
464 ALTER TYPE users_permissions_manage_mirrors
OWNER TO pakfire
;
467 -- Name: users_permissions_vote; Type: TYPE; Schema: public; Owner: pakfire
470 CREATE TYPE users_permissions_vote
AS ENUM (
476 ALTER TYPE users_permissions_vote
OWNER TO pakfire
;
479 -- Name: users_state; Type: TYPE; Schema: public; Owner: pakfire
482 CREATE TYPE users_state
AS ENUM (
489 ALTER TYPE users_state
OWNER TO pakfire
;
492 -- Name: on_update_current_timestamp_sources(); Type: FUNCTION; Schema: public; Owner: pakfire
495 CREATE FUNCTION on_update_current_timestamp_sources() RETURNS trigger
505 ALTER FUNCTION public.
on_update_current_timestamp_sources() OWNER TO pakfire
;
507 SET default_tablespace
= '';
509 SET default_with_oids
= false;
512 -- Name: arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
515 CREATE TABLE arches (
521 ALTER TABLE arches
OWNER TO pakfire
;
524 -- Name: arches_compat; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
527 CREATE TABLE arches_compat (
528 native_arch
text NOT NULL,
529 build_arch
text NOT NULL,
530 CONSTRAINT arches_compat_unique
CHECK ((native_arch
<> build_arch
))
534 ALTER TABLE arches_compat
OWNER TO pakfire
;
537 -- Name: arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
540 CREATE SEQUENCE arches_id_seq
548 ALTER TABLE arches_id_seq
OWNER TO pakfire
;
551 -- Name: arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
554 ALTER SEQUENCE arches_id_seq
OWNED BY arches.
id;
558 -- Name: builders; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
561 CREATE TABLE builders (
566 enabled
boolean DEFAULT false NOT NULL,
567 deleted
boolean DEFAULT false NOT NULL,
568 loadavg
text DEFAULT '0'::character varying NOT NULL,
569 testmode
boolean DEFAULT true NOT NULL,
570 max_jobs
bigint DEFAULT 1::bigint NOT NULL,
571 pakfire_version
text,
574 cpu_count
integer DEFAULT 1 NOT NULL,
576 cpu_bogomips
double precision,
577 memory
bigint DEFAULT 0 NOT NULL,
578 overload builders_overload
DEFAULT 'N'::builders_overload NOT NULL,
579 free_space
bigint DEFAULT 0 NOT NULL,
581 time_created
timestamp without time zone DEFAULT now() NOT NULL,
582 time_updated
timestamp without time zone,
583 time_keepalive
timestamp without time zone,
584 loadavg1
double precision,
585 loadavg5
double precision,
586 loadavg15
double precision,
595 ALTER TABLE builders
OWNER TO pakfire
;
598 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
601 CREATE TABLE builders_history (
603 builder_id
integer NOT NULL,
604 action builders_history_action
NOT NULL,
606 "time" timestamp without time zone NOT NULL
610 ALTER TABLE builders_history
OWNER TO pakfire
;
613 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
616 CREATE SEQUENCE builders_history_id_seq
624 ALTER TABLE builders_history_id_seq
OWNER TO pakfire
;
627 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
630 ALTER SEQUENCE builders_history_id_seq
OWNED BY builders_history.
id;
634 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
637 CREATE SEQUENCE builders_id_seq
645 ALTER TABLE builders_id_seq
OWNER TO pakfire
;
648 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
651 ALTER SEQUENCE builders_id_seq
OWNED BY builders.
id;
655 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
658 CREATE TABLE builds (
661 pkg_id
integer NOT NULL,
662 type builds_type
DEFAULT 'release'::builds_type NOT NULL,
663 state text DEFAULT 'building'::text NOT NULL,
664 severity builds_severity
,
666 time_created
timestamp without time zone NOT NULL,
670 distro_id
integer NOT NULL,
672 public builds_public
DEFAULT 'Y'::builds_public NOT NULL,
673 priority
integer DEFAULT 0 NOT NULL,
674 auto_move builds_auto_move
DEFAULT 'N'::builds_auto_move NOT NULL
678 ALTER TABLE builds
OWNER TO pakfire
;
681 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
684 CREATE TABLE builds_bugs (
686 build_id
integer NOT NULL,
687 bug_id
integer NOT NULL
691 ALTER TABLE builds_bugs
OWNER TO pakfire
;
694 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
697 CREATE SEQUENCE builds_bugs_id_seq
705 ALTER TABLE builds_bugs_id_seq
OWNER TO pakfire
;
708 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
711 ALTER SEQUENCE builds_bugs_id_seq
OWNED BY builds_bugs.
id;
715 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
718 CREATE TABLE builds_bugs_updates (
720 bug_id
integer NOT NULL,
724 "time" timestamp without time zone NOT NULL,
725 error
boolean DEFAULT false NOT NULL,
730 ALTER TABLE builds_bugs_updates
OWNER TO pakfire
;
733 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
736 CREATE SEQUENCE builds_bugs_updates_id_seq
744 ALTER TABLE builds_bugs_updates_id_seq
OWNER TO pakfire
;
747 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
750 ALTER SEQUENCE builds_bugs_updates_id_seq
OWNED BY builds_bugs_updates.
id;
754 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
757 CREATE TABLE builds_comments (
759 build_id
integer NOT NULL,
760 user_id
integer NOT NULL,
762 credit
integer NOT NULL,
763 time_created
timestamp without time zone NOT NULL,
764 time_updated
timestamp without time zone
768 ALTER TABLE builds_comments
OWNER TO pakfire
;
771 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
774 CREATE SEQUENCE builds_comments_id_seq
782 ALTER TABLE builds_comments_id_seq
OWNER TO pakfire
;
785 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
788 ALTER SEQUENCE builds_comments_id_seq
OWNED BY builds_comments.
id;
792 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
795 CREATE TABLE builds_history (
797 build_id
integer NOT NULL,
798 action builds_history_action
NOT NULL,
800 "time" timestamp without time zone NOT NULL,
805 ALTER TABLE builds_history
OWNER TO pakfire
;
808 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
811 CREATE SEQUENCE builds_history_id_seq
819 ALTER TABLE builds_history_id_seq
OWNER TO pakfire
;
822 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
825 ALTER SEQUENCE builds_history_id_seq
OWNED BY builds_history.
id;
829 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
832 CREATE SEQUENCE builds_id_seq
840 ALTER TABLE builds_id_seq
OWNER TO pakfire
;
843 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
846 ALTER SEQUENCE builds_id_seq
OWNED BY builds.
id;
850 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
856 type jobs_type
DEFAULT 'build'::jobs_type NOT NULL,
857 build_id
integer NOT NULL,
858 state jobs_state
DEFAULT 'new'::jobs_state NOT NULL,
860 time_created
timestamp without time zone NOT NULL,
861 time_started
timestamp without time zone,
862 time_finished
timestamp without time zone,
863 start_not_before
timestamp without time zone,
865 tries
integer DEFAULT 0 NOT NULL,
866 aborted_state
integer DEFAULT 0 NOT NULL,
871 ALTER TABLE jobs
OWNER TO pakfire
;
874 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
877 CREATE VIEW builds_times
AS
878 SELECT builds.
id AS build_id
,
880 jobs.
type AS job_type
,
881 (jobs.time_finished
- jobs.time_started
) AS duration
883 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
884 WHERE (jobs.
state = 'finished'::jobs_state);
887 ALTER TABLE builds_times
OWNER TO pakfire
;
890 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
893 CREATE TABLE builds_watchers (
895 build_id
integer NOT NULL,
896 user_id
integer NOT NULL
900 ALTER TABLE builds_watchers
OWNER TO pakfire
;
903 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
906 CREATE SEQUENCE builds_watchers_id_seq
914 ALTER TABLE builds_watchers_id_seq
OWNER TO pakfire
;
917 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
920 ALTER SEQUENCE builds_watchers_id_seq
OWNED BY builds_watchers.
id;
924 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
927 CREATE TABLE distributions (
931 slogan
text NOT NULL,
933 vendor
text NOT NULL,
936 deleted
boolean DEFAULT false NOT NULL
940 ALTER TABLE distributions
OWNER TO pakfire
;
943 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
946 CREATE TABLE distributions_arches (
948 distro_id
integer NOT NULL,
953 ALTER TABLE distributions_arches
OWNER TO pakfire
;
956 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
959 CREATE SEQUENCE distributions_id_seq
967 ALTER TABLE distributions_id_seq
OWNER TO pakfire
;
970 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
973 ALTER SEQUENCE distributions_id_seq
OWNED BY distributions.
id;
977 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
980 CREATE SEQUENCE distro_arches_id_seq
988 ALTER TABLE distro_arches_id_seq
OWNER TO pakfire
;
991 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
994 ALTER SEQUENCE distro_arches_id_seq
OWNED BY distributions_arches.
id;
998 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1001 CREATE TABLE filelists (
1002 pkg_id
integer NOT NULL,
1004 size bigint NOT NULL,
1006 type integer NOT NULL,
1007 config filelists_config
NOT NULL,
1008 mode integer NOT NULL,
1009 "user" text NOT NULL,
1010 "group" text NOT NULL,
1011 mtime
timestamp without time zone NOT NULL,
1016 ALTER TABLE filelists
OWNER TO pakfire
;
1019 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1022 CREATE TABLE images_types (
1023 id integer NOT NULL,
1028 ALTER TABLE images_types
OWNER TO pakfire
;
1031 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1034 CREATE SEQUENCE images_types_id_seq
1042 ALTER TABLE images_types_id_seq
OWNER TO pakfire
;
1045 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1048 ALTER SEQUENCE images_types_id_seq
OWNED BY images_types.
id;
1052 -- Name: jobs_active; Type: VIEW; Schema: public; Owner: pakfire
1055 CREATE VIEW jobs_active
AS
1065 jobs.start_not_before
,
1071 WHERE (jobs.
state = ANY (ARRAY['dispatching'::jobs_state, 'running'::jobs_state, 'uploading'::jobs_state]))
1072 ORDER BY jobs.time_started
;
1075 ALTER TABLE jobs_active
OWNER TO pakfire
;
1078 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1081 CREATE TABLE jobs_buildroots (
1082 job_id
integer NOT NULL,
1083 tries
integer NOT NULL,
1084 pkg_uuid
text NOT NULL,
1085 pkg_name
text NOT NULL
1089 ALTER TABLE jobs_buildroots
OWNER TO pakfire
;
1092 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1095 CREATE TABLE jobs_history (
1096 job_id
integer NOT NULL,
1097 action jobs_history_action
NOT NULL,
1098 state jobs_history_state
,
1100 "time" timestamp without time zone NOT NULL,
1106 ALTER TABLE jobs_history
OWNER TO pakfire
;
1109 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1112 CREATE SEQUENCE jobs_id_seq
1120 ALTER TABLE jobs_id_seq
OWNER TO pakfire
;
1123 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1126 ALTER SEQUENCE jobs_id_seq
OWNED BY jobs.
id;
1130 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1133 CREATE TABLE jobs_packages (
1134 id integer NOT NULL,
1135 job_id
integer NOT NULL,
1136 pkg_id
integer NOT NULL
1140 ALTER TABLE jobs_packages
OWNER TO pakfire
;
1143 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1146 CREATE SEQUENCE jobs_packages_id_seq
1154 ALTER TABLE jobs_packages_id_seq
OWNER TO pakfire
;
1157 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1160 ALTER SEQUENCE jobs_packages_id_seq
OWNED BY jobs_packages.
id;
1164 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
1167 CREATE VIEW jobs_queue
AS
1170 rank() OVER (ORDER BY jobs.
type, builds.priority
DESC, jobs.tries
, jobs.time_created
) AS rank
1172 LEFT JOIN builds
ON ((jobs.build_id
= builds.
id)))
1173 WHERE (jobs.
state = 'pending'::jobs_state)
1175 SELECT queue.
id AS job_id
,
1180 ALTER TABLE jobs_queue
OWNER TO pakfire
;
1183 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1186 CREATE TABLE jobs_repos (
1187 job_id
integer NOT NULL,
1188 repo_id
integer NOT NULL
1192 ALTER TABLE jobs_repos
OWNER TO pakfire
;
1195 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1199 id integer NOT NULL,
1200 fingerprint
text NOT NULL,
1206 ALTER TABLE keys
OWNER TO pakfire
;
1209 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1212 CREATE SEQUENCE keys_id_seq
1220 ALTER TABLE keys_id_seq
OWNER TO pakfire
;
1223 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1226 ALTER SEQUENCE keys_id_seq
OWNED BY keys.
id;
1230 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1233 CREATE TABLE keys_subkeys (
1234 id integer NOT NULL,
1235 key_id
integer NOT NULL,
1236 fingerprint
text NOT NULL,
1237 time_created
timestamp without time zone NOT NULL,
1238 time_expires
timestamp without time zone,
1243 ALTER TABLE keys_subkeys
OWNER TO pakfire
;
1246 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1249 CREATE SEQUENCE keys_subkeys_id_seq
1257 ALTER TABLE keys_subkeys_id_seq
OWNER TO pakfire
;
1260 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1263 ALTER SEQUENCE keys_subkeys_id_seq
OWNED BY keys_subkeys.
id;
1267 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1270 CREATE TABLE logfiles (
1271 id integer NOT NULL,
1272 job_id
integer NOT NULL,
1274 filesize
bigint NOT NULL,
1275 hash_sha512
text NOT NULL
1279 ALTER TABLE logfiles
OWNER TO pakfire
;
1282 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1285 CREATE SEQUENCE logfiles_id_seq
1293 ALTER TABLE logfiles_id_seq
OWNER TO pakfire
;
1296 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1299 ALTER SEQUENCE logfiles_id_seq
OWNED BY logfiles.
id;
1303 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1306 CREATE TABLE mirrors (
1307 id integer NOT NULL,
1308 hostname
text NOT NULL,
1312 deleted
boolean DEFAULT false NOT NULL
1316 ALTER TABLE mirrors
OWNER TO pakfire
;
1319 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1322 CREATE TABLE mirrors_checks (
1323 id integer NOT NULL,
1324 mirror_id
integer NOT NULL,
1325 "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
1326 response_time
double precision,
1327 http_status
integer,
1328 last_sync_at
timestamp without time zone,
1329 status
text DEFAULT 'OK'::text NOT NULL
1333 ALTER TABLE mirrors_checks
OWNER TO pakfire
;
1336 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1339 CREATE SEQUENCE mirrors_checks_id_seq
1347 ALTER TABLE mirrors_checks_id_seq
OWNER TO pakfire
;
1350 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1353 ALTER SEQUENCE mirrors_checks_id_seq
OWNED BY mirrors_checks.
id;
1357 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1360 CREATE TABLE mirrors_history (
1361 id integer NOT NULL,
1362 mirror_id
integer NOT NULL,
1363 action mirrors_history_action
NOT NULL,
1365 "time" timestamp without time zone NOT NULL
1369 ALTER TABLE mirrors_history
OWNER TO pakfire
;
1372 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1375 CREATE SEQUENCE mirrors_history_id_seq
1383 ALTER TABLE mirrors_history_id_seq
OWNER TO pakfire
;
1386 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1389 ALTER SEQUENCE mirrors_history_id_seq
OWNED BY mirrors_history.
id;
1393 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1396 CREATE SEQUENCE mirrors_id_seq
1404 ALTER TABLE mirrors_id_seq
OWNER TO pakfire
;
1407 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1410 ALTER SEQUENCE mirrors_id_seq
OWNED BY mirrors.
id;
1414 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1417 CREATE TABLE packages (
1418 id integer NOT NULL,
1420 epoch
integer NOT NULL,
1421 version text NOT NULL,
1422 release text NOT NULL,
1423 type packages_type
NOT NULL,
1425 groups
text NOT NULL,
1426 maintainer
text NOT NULL,
1427 license
text NOT NULL,
1429 summary
text NOT NULL,
1430 description
text NOT NULL,
1431 size bigint NOT NULL,
1432 supported_arches
text,
1435 build_id
text NOT NULL,
1436 build_host
text NOT NULL,
1437 build_time
timestamp without time zone NOT NULL,
1439 filesize
bigint NOT NULL,
1440 hash_sha512
text NOT NULL
1444 ALTER TABLE packages
OWNER TO pakfire
;
1447 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1450 CREATE TABLE packages_deps (
1451 pkg_id
integer NOT NULL,
1452 type packages_deps_type
NOT NULL,
1457 ALTER TABLE packages_deps
OWNER TO pakfire
;
1460 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1463 CREATE SEQUENCE packages_id_seq
1471 ALTER TABLE packages_id_seq
OWNER TO pakfire
;
1474 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1477 ALTER SEQUENCE packages_id_seq
OWNED BY packages.
id;
1481 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1484 CREATE TABLE packages_properties (
1485 id integer NOT NULL,
1487 critical_path packages_properties_critical_path
DEFAULT 'N'::packages_properties_critical_path NOT NULL,
1488 priority
integer DEFAULT 0 NOT NULL
1492 ALTER TABLE packages_properties
OWNER TO pakfire
;
1495 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1498 CREATE SEQUENCE packages_properties_id_seq
1506 ALTER TABLE packages_properties_id_seq
OWNER TO pakfire
;
1509 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1512 ALTER SEQUENCE packages_properties_id_seq
OWNED BY packages_properties.
id;
1516 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1519 CREATE TABLE queue_delete (
1520 id integer NOT NULL,
1525 ALTER TABLE queue_delete
OWNER TO pakfire
;
1528 -- Name: queue_delete_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1531 CREATE SEQUENCE queue_delete_id_seq
1539 ALTER TABLE queue_delete_id_seq
OWNER TO pakfire
;
1542 -- Name: queue_delete_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1545 ALTER SEQUENCE queue_delete_id_seq
OWNED BY queue_delete.
id;
1549 -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: pakfire
1552 CREATE VIEW relation_sizes
AS
1553 SELECT c.relname
AS relation
,
1554 pg_size_pretty(pg_relation_size((c.oid
)::regclass)) AS size
1556 LEFT JOIN pg_namespace n
ON ((n.oid
= c.relnamespace
)))
1557 WHERE (n.nspname
<> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name]))
1558 ORDER BY pg_relation_size((c.oid
)::regclass) DESC;
1561 ALTER TABLE relation_sizes
OWNER TO pakfire
;
1564 -- Name: repositories; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1567 CREATE TABLE repositories (
1568 id integer NOT NULL,
1570 type repositories_type
DEFAULT 'testing'::repositories_type NOT NULL,
1571 description
text NOT NULL,
1572 distro_id
integer NOT NULL,
1575 mirrored
boolean DEFAULT false NOT NULL,
1576 enabled_for_builds
boolean DEFAULT false NOT NULL,
1577 score_needed
integer DEFAULT 0 NOT NULL,
1578 last_update
timestamp without time zone,
1579 time_min
integer DEFAULT 0 NOT NULL,
1580 time_max
integer DEFAULT 0 NOT NULL,
1581 update_started
timestamp without time zone,
1582 update_ended
timestamp without time zone,
1583 deleted
boolean DEFAULT false NOT NULL
1587 ALTER TABLE repositories
OWNER TO pakfire
;
1590 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1593 CREATE TABLE repositories_aux (
1594 id integer NOT NULL,
1598 distro_id
integer NOT NULL,
1599 status repositories_aux_status
DEFAULT 'disabled'::repositories_aux_status NOT NULL
1603 ALTER TABLE repositories_aux
OWNER TO pakfire
;
1606 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1609 CREATE SEQUENCE repositories_aux_id_seq
1617 ALTER TABLE repositories_aux_id_seq
OWNER TO pakfire
;
1620 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1623 ALTER SEQUENCE repositories_aux_id_seq
OWNED BY repositories_aux.
id;
1627 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1630 CREATE TABLE repositories_builds (
1631 id integer NOT NULL,
1632 repo_id
integer NOT NULL,
1633 build_id
bigint NOT NULL,
1634 time_added
timestamp without time zone NOT NULL
1638 ALTER TABLE repositories_builds
OWNER TO pakfire
;
1641 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1644 CREATE SEQUENCE repositories_builds_id_seq
1652 ALTER TABLE repositories_builds_id_seq
OWNER TO pakfire
;
1655 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1658 ALTER SEQUENCE repositories_builds_id_seq
OWNED BY repositories_builds.
id;
1662 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1665 CREATE TABLE repositories_history (
1666 build_id
bigint NOT NULL,
1667 action repositories_history_action
NOT NULL,
1668 from_repo_id
integer,
1671 "time" timestamp without time zone NOT NULL
1675 ALTER TABLE repositories_history
OWNER TO pakfire
;
1678 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1681 CREATE SEQUENCE repositories_id_seq
1689 ALTER TABLE repositories_id_seq
OWNER TO pakfire
;
1692 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1695 ALTER SEQUENCE repositories_id_seq
OWNED BY repositories.
id;
1699 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1702 CREATE TABLE sessions (
1703 id integer NOT NULL,
1704 session_id
text NOT NULL,
1705 created_at
timestamp without time zone DEFAULT now() NOT NULL,
1706 valid_until
timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1707 user_id
integer NOT NULL,
1708 impersonated_user_id
integer,
1711 CONSTRAINT sessions_impersonation_check
CHECK (((impersonated_user_id
IS NULL) OR (user_id
<> impersonated_user_id
)))
1715 ALTER TABLE sessions
OWNER TO pakfire
;
1718 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1721 CREATE SEQUENCE sessions_id_seq
1729 ALTER TABLE sessions_id_seq
OWNER TO pakfire
;
1732 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1735 ALTER SEQUENCE sessions_id_seq
OWNED BY sessions.
id;
1739 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1742 CREATE TABLE settings (
1748 ALTER TABLE settings
OWNER TO pakfire
;
1751 -- Name: slogans; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1754 CREATE TABLE slogans (
1755 id integer NOT NULL,
1756 message
text NOT NULL
1760 ALTER TABLE slogans
OWNER TO pakfire
;
1763 -- Name: slogans_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1766 CREATE SEQUENCE slogans_id_seq
1774 ALTER TABLE slogans_id_seq
OWNER TO pakfire
;
1777 -- Name: slogans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1780 ALTER SEQUENCE slogans_id_seq
OWNED BY slogans.
id;
1784 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1787 CREATE TABLE sources (
1788 id integer NOT NULL,
1790 identifier
text NOT NULL,
1793 revision
text NOT NULL,
1794 branch
text NOT NULL,
1795 updated
timestamp without time zone,
1796 distro_id
integer NOT NULL
1800 ALTER TABLE sources
OWNER TO pakfire
;
1803 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1806 CREATE TABLE sources_commits (
1807 id integer NOT NULL,
1808 source_id
integer NOT NULL,
1809 revision
text NOT NULL,
1810 author
text NOT NULL,
1811 committer
text NOT NULL,
1812 subject
text NOT NULL,
1814 date timestamp without time zone NOT NULL,
1815 state sources_commits_state
DEFAULT 'pending'::sources_commits_state NOT NULL,
1816 imported_at
timestamp without time zone DEFAULT now() NOT NULL
1820 ALTER TABLE sources_commits
OWNER TO pakfire
;
1823 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1826 CREATE SEQUENCE sources_commits_id_seq
1834 ALTER TABLE sources_commits_id_seq
OWNER TO pakfire
;
1837 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1840 ALTER SEQUENCE sources_commits_id_seq
OWNED BY sources_commits.
id;
1844 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1847 CREATE SEQUENCE sources_id_seq
1855 ALTER TABLE sources_id_seq
OWNER TO pakfire
;
1858 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1861 ALTER SEQUENCE sources_id_seq
OWNED BY sources.
id;
1865 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1868 CREATE TABLE uploads (
1869 id integer NOT NULL,
1873 filename
text NOT NULL,
1875 size bigint NOT NULL,
1876 progress
bigint DEFAULT 0 NOT NULL,
1877 finished uploads_finished
DEFAULT 'N'::uploads_finished NOT NULL,
1878 time_started
timestamp without time zone DEFAULT now() NOT NULL,
1879 time_finished
timestamp without time zone
1883 ALTER TABLE uploads
OWNER TO pakfire
;
1886 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1889 CREATE SEQUENCE uploads_id_seq
1897 ALTER TABLE uploads_id_seq
OWNER TO pakfire
;
1900 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1903 ALTER SEQUENCE uploads_id_seq
OWNED BY uploads.
id;
1907 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1910 CREATE TABLE user_messages (
1911 id integer NOT NULL,
1914 subject
text NOT NULL,
1916 time_added
timestamp without time zone DEFAULT now() NOT NULL
1920 ALTER TABLE user_messages
OWNER TO pakfire
;
1923 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1926 CREATE SEQUENCE user_messages_id_seq
1934 ALTER TABLE user_messages_id_seq
OWNER TO pakfire
;
1937 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1940 ALTER SEQUENCE user_messages_id_seq
OWNED BY user_messages.
id;
1944 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1947 CREATE TABLE users (
1948 id integer NOT NULL,
1951 passphrase
text NOT NULL,
1952 state users_state
NOT NULL,
1955 activated users_activated
DEFAULT 'N'::users_activated NOT NULL,
1956 activation_code
text,
1957 deleted users_deleted
DEFAULT 'N'::users_deleted NOT NULL,
1958 registered
timestamp without time zone DEFAULT now() NOT NULL
1962 ALTER TABLE users
OWNER TO pakfire
;
1965 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1968 CREATE TABLE users_emails (
1969 id integer NOT NULL,
1970 user_id
integer NOT NULL,
1971 email
text NOT NULL,
1972 "primary" users_emails_primary
DEFAULT 'N'::users_emails_primary NOT NULL
1976 ALTER TABLE users_emails
OWNER TO pakfire
;
1979 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1982 CREATE SEQUENCE users_emails_id_seq
1990 ALTER TABLE users_emails_id_seq
OWNER TO pakfire
;
1993 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1996 ALTER SEQUENCE users_emails_id_seq
OWNED BY users_emails.
id;
2000 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2003 CREATE SEQUENCE users_id_seq
2011 ALTER TABLE users_id_seq
OWNER TO pakfire
;
2014 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2017 ALTER SEQUENCE users_id_seq
OWNED BY users.
id;
2021 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2024 CREATE TABLE users_permissions (
2025 id integer NOT NULL,
2026 user_id
integer NOT NULL,
2027 create_scratch_builds users_permissions_create_scratch_builds
DEFAULT 'N'::users_permissions_create_scratch_builds NOT NULL,
2028 maintain_builders users_permissions_maintain_builders
DEFAULT 'N'::users_permissions_maintain_builders NOT NULL,
2029 manage_critical_path users_permissions_manage_critical_path
DEFAULT 'N'::users_permissions_manage_critical_path NOT NULL,
2030 manage_mirrors users_permissions_manage_mirrors
DEFAULT 'N'::users_permissions_manage_mirrors NOT NULL,
2031 vote users_permissions_vote
DEFAULT 'N'::users_permissions_vote NOT NULL
2035 ALTER TABLE users_permissions
OWNER TO pakfire
;
2038 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2041 CREATE SEQUENCE users_permissions_id_seq
2049 ALTER TABLE users_permissions_id_seq
OWNER TO pakfire
;
2052 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2055 ALTER SEQUENCE users_permissions_id_seq
OWNED BY users_permissions.
id;
2059 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2062 ALTER TABLE ONLY arches
ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
2066 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2069 ALTER TABLE ONLY builders
ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
2073 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2076 ALTER TABLE ONLY builders_history
ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
2080 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2083 ALTER TABLE ONLY builds
ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
2087 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2090 ALTER TABLE ONLY builds_bugs
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
2094 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2097 ALTER TABLE ONLY builds_bugs_updates
ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
2101 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2104 ALTER TABLE ONLY builds_comments
ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
2108 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2111 ALTER TABLE ONLY builds_history
ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
2115 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2118 ALTER TABLE ONLY builds_watchers
ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
2122 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2125 ALTER TABLE ONLY distributions
ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
2129 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2132 ALTER TABLE ONLY distributions_arches
ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
2136 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2139 ALTER TABLE ONLY images_types
ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
2143 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2146 ALTER TABLE ONLY jobs
ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
2150 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2153 ALTER TABLE ONLY jobs_packages
ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
2157 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2160 ALTER TABLE ONLY keys
ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
2164 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2167 ALTER TABLE ONLY keys_subkeys
ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
2171 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2174 ALTER TABLE ONLY logfiles
ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
2178 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2181 ALTER TABLE ONLY mirrors
ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
2185 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2188 ALTER TABLE ONLY mirrors_checks
ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
2192 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2195 ALTER TABLE ONLY mirrors_history
ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
2199 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2202 ALTER TABLE ONLY packages
ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
2206 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2209 ALTER TABLE ONLY packages_properties
ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
2213 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2216 ALTER TABLE ONLY queue_delete
ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
2220 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2223 ALTER TABLE ONLY repositories
ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
2227 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2230 ALTER TABLE ONLY repositories_aux
ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
2234 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2237 ALTER TABLE ONLY repositories_builds
ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
2241 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2244 ALTER TABLE ONLY sessions
ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
2248 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2251 ALTER TABLE ONLY slogans
ALTER COLUMN id SET DEFAULT nextval('slogans_id_seq'::regclass);
2255 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2258 ALTER TABLE ONLY sources
ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
2262 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2265 ALTER TABLE ONLY sources_commits
ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
2269 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2272 ALTER TABLE ONLY uploads
ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
2276 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2279 ALTER TABLE ONLY user_messages
ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
2283 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2286 ALTER TABLE ONLY users
ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
2290 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2293 ALTER TABLE ONLY users_emails
ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
2297 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2300 ALTER TABLE ONLY users_permissions
ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
2304 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2307 ALTER TABLE ONLY arches_compat
2308 ADD CONSTRAINT arches_compat_unique
UNIQUE (native_arch
, build_arch
);
2312 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2315 ALTER TABLE ONLY arches
2316 ADD CONSTRAINT arches_name
UNIQUE (name);
2320 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2323 ALTER TABLE ONLY arches
2324 ADD CONSTRAINT idx_2197943_primary
PRIMARY KEY (id);
2328 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2331 ALTER TABLE ONLY builders
2332 ADD CONSTRAINT idx_2197954_primary
PRIMARY KEY (id);
2336 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2339 ALTER TABLE ONLY builders_history
2340 ADD CONSTRAINT idx_2197982_primary
PRIMARY KEY (id);
2344 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2347 ALTER TABLE ONLY builds
2348 ADD CONSTRAINT idx_2197988_primary
PRIMARY KEY (id);
2352 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2355 ALTER TABLE ONLY builds_bugs
2356 ADD CONSTRAINT idx_2198002_primary
PRIMARY KEY (id);
2360 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2363 ALTER TABLE ONLY builds_bugs_updates
2364 ADD CONSTRAINT idx_2198008_primary
PRIMARY KEY (id);
2368 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2371 ALTER TABLE ONLY builds_comments
2372 ADD CONSTRAINT idx_2198018_primary
PRIMARY KEY (id);
2376 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2379 ALTER TABLE ONLY builds_history
2380 ADD CONSTRAINT idx_2198027_primary
PRIMARY KEY (id);
2384 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2387 ALTER TABLE ONLY builds_watchers
2388 ADD CONSTRAINT idx_2198033_primary
PRIMARY KEY (id);
2392 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2395 ALTER TABLE ONLY distributions
2396 ADD CONSTRAINT idx_2198039_primary
PRIMARY KEY (id);
2400 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2403 ALTER TABLE ONLY distributions_arches
2404 ADD CONSTRAINT idx_2198048_primary
PRIMARY KEY (id);
2408 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2411 ALTER TABLE ONLY images_types
2412 ADD CONSTRAINT idx_2198057_primary
PRIMARY KEY (id);
2416 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2419 ALTER TABLE ONLY jobs
2420 ADD CONSTRAINT idx_2198063_primary
PRIMARY KEY (id);
2424 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2427 ALTER TABLE ONLY jobs_packages
2428 ADD CONSTRAINT idx_2198085_primary
PRIMARY KEY (id);
2432 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2435 ALTER TABLE ONLY keys
2436 ADD CONSTRAINT idx_2198094_primary
PRIMARY KEY (id);
2440 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2443 ALTER TABLE ONLY keys_subkeys
2444 ADD CONSTRAINT idx_2198103_primary
PRIMARY KEY (id);
2448 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2451 ALTER TABLE ONLY logfiles
2452 ADD CONSTRAINT idx_2198109_primary
PRIMARY KEY (id);
2456 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2459 ALTER TABLE ONLY mirrors
2460 ADD CONSTRAINT idx_2198115_primary
PRIMARY KEY (id);
2464 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2467 ALTER TABLE ONLY mirrors_history
2468 ADD CONSTRAINT idx_2198126_primary
PRIMARY KEY (id);
2472 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2475 ALTER TABLE ONLY packages
2476 ADD CONSTRAINT idx_2198132_primary
PRIMARY KEY (id);
2480 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2483 ALTER TABLE ONLY packages_properties
2484 ADD CONSTRAINT idx_2198147_primary
PRIMARY KEY (id);
2488 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2491 ALTER TABLE ONLY queue_delete
2492 ADD CONSTRAINT idx_2198155_primary
PRIMARY KEY (id);
2496 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2499 ALTER TABLE ONLY repositories
2500 ADD CONSTRAINT idx_2198164_primary
PRIMARY KEY (id);
2504 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2507 ALTER TABLE ONLY repositories_aux
2508 ADD CONSTRAINT idx_2198179_primary
PRIMARY KEY (id);
2512 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2515 ALTER TABLE ONLY repositories_builds
2516 ADD CONSTRAINT idx_2198189_primary
PRIMARY KEY (id);
2520 -- Name: idx_2198207_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2523 ALTER TABLE ONLY slogans
2524 ADD CONSTRAINT idx_2198207_primary
PRIMARY KEY (id);
2528 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2531 ALTER TABLE ONLY sources
2532 ADD CONSTRAINT idx_2198213_primary
PRIMARY KEY (id);
2536 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2539 ALTER TABLE ONLY sources_commits
2540 ADD CONSTRAINT idx_2198222_primary
PRIMARY KEY (id);
2544 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2547 ALTER TABLE ONLY uploads
2548 ADD CONSTRAINT idx_2198232_primary
PRIMARY KEY (id);
2552 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2555 ALTER TABLE ONLY users
2556 ADD CONSTRAINT idx_2198244_primary
PRIMARY KEY (id);
2560 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2563 ALTER TABLE ONLY users_emails
2564 ADD CONSTRAINT idx_2198256_primary
PRIMARY KEY (id);
2568 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2571 ALTER TABLE ONLY users_permissions
2572 ADD CONSTRAINT idx_2198263_primary
PRIMARY KEY (id);
2576 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2579 ALTER TABLE ONLY user_messages
2580 ADD CONSTRAINT idx_2198274_primary
PRIMARY KEY (id);
2584 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2587 ALTER TABLE ONLY jobs_packages
2588 ADD CONSTRAINT jobs_packages_unique
UNIQUE (job_id
, pkg_id
);
2592 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2595 ALTER TABLE ONLY mirrors_checks
2596 ADD CONSTRAINT mirrors_checks_pkey
PRIMARY KEY (id);
2600 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2603 ALTER TABLE ONLY sessions
2604 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (id);
2608 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2611 ALTER TABLE ONLY sessions
2612 ADD CONSTRAINT sessions_session_id_key
UNIQUE (session_id
);
2616 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2619 CREATE INDEX arches_compat_native_arch
ON arches_compat
USING btree (native_arch
);
2623 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2626 CREATE UNIQUE INDEX builders_name
ON builders
USING btree (name) WHERE (deleted
IS FALSE);
2630 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2633 CREATE INDEX builds_watchers_build_id
ON builds_watchers
USING btree (build_id
);
2637 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2640 CREATE INDEX distributions_arches_distro_id
ON distributions_arches
USING btree (distro_id
);
2644 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2647 CREATE UNIQUE INDEX distributions_sname
ON distributions
USING btree (sname
) WHERE (deleted
IS FALSE);
2651 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2654 CREATE INDEX filelists_name
ON filelists
USING btree (name);
2658 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2661 CREATE INDEX idx_2197982_builder_id
ON builders_history
USING btree (builder_id
);
2665 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2668 CREATE INDEX idx_2197988_pkg_id
ON builds
USING btree (pkg_id
);
2672 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2675 CREATE INDEX idx_2197988_state
ON builds
USING btree (state);
2679 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2682 CREATE INDEX idx_2197988_type
ON builds
USING btree (type);
2686 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2689 CREATE UNIQUE INDEX idx_2197988_uuid
ON builds
USING btree (uuid
);
2693 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2696 CREATE UNIQUE INDEX idx_2198002_build_id
ON builds_bugs
USING btree (build_id
, bug_id
);
2700 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2703 CREATE INDEX idx_2198018_build_id
ON builds_comments
USING btree (build_id
);
2707 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2710 CREATE INDEX idx_2198018_user_id
ON builds_comments
USING btree (user_id
);
2714 -- Name: idx_2198052_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2717 CREATE INDEX idx_2198052_pkg_id
ON filelists
USING btree (pkg_id
);
2721 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2724 CREATE INDEX idx_2198063_build_id
ON jobs
USING btree (build_id
);
2728 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2731 CREATE INDEX idx_2198063_state
ON jobs
USING btree (state);
2735 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2738 CREATE INDEX idx_2198063_time_finished
ON jobs
USING btree (time_finished
);
2742 -- Name: idx_2198063_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2745 CREATE INDEX idx_2198063_type
ON jobs
USING btree (type);
2749 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2752 CREATE UNIQUE INDEX idx_2198063_uuid
ON jobs
USING btree (uuid
);
2756 -- Name: idx_2198074_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2759 CREATE INDEX idx_2198074_job_id
ON jobs_buildroots
USING btree (job_id
);
2763 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2766 CREATE INDEX idx_2198080_job_id
ON jobs_history
USING btree (job_id
);
2770 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2773 CREATE UNIQUE INDEX idx_2198089_job_id
ON jobs_repos
USING btree (job_id
, repo_id
);
2777 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2780 CREATE UNIQUE INDEX idx_2198094_fingerprint
ON keys
USING btree (fingerprint
);
2784 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2787 CREATE INDEX idx_2198132_name
ON packages
USING btree (name);
2791 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2794 CREATE INDEX idx_2198132_type
ON packages
USING btree (type);
2798 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2801 CREATE INDEX idx_2198132_uuid
ON packages
USING btree (uuid
);
2805 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2808 CREATE INDEX idx_2198139_pkg_id
ON packages_deps
USING btree (pkg_id
);
2812 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2815 CREATE UNIQUE INDEX idx_2198147_name
ON packages_properties
USING btree (name);
2819 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2822 CREATE UNIQUE INDEX idx_2198189_build_id
ON repositories_builds
USING btree (build_id
);
2826 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2829 CREATE INDEX idx_2198193_build_id
ON repositories_history
USING btree (build_id
);
2833 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2836 CREATE UNIQUE INDEX idx_2198199_k
ON settings
USING btree (k
);
2840 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2843 CREATE UNIQUE INDEX idx_2198213_identifier
ON sources
USING btree (identifier
);
2847 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2850 CREATE INDEX idx_2198222_revision
ON sources_commits
USING btree (revision
);
2854 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2857 CREATE UNIQUE INDEX idx_2198232_uuid
ON uploads
USING btree (uuid
);
2861 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2864 CREATE UNIQUE INDEX idx_2198244_name
ON users
USING btree (name);
2868 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2871 CREATE UNIQUE INDEX idx_2198256_email
ON users_emails
USING btree (email
);
2875 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2878 CREATE INDEX idx_2198256_user_id
ON users_emails
USING btree (user_id
);
2882 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2885 CREATE INDEX jobs_arch
ON jobs
USING btree (arch
);
2889 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2892 CREATE INDEX jobs_buildroots_pkg_uuid
ON jobs_buildroots
USING btree (pkg_uuid
);
2896 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2899 CREATE INDEX mirrors_checks_sort
ON mirrors_checks
USING btree (mirror_id
, "timestamp");
2901 ALTER TABLE mirrors_checks
CLUSTER ON mirrors_checks_sort
;
2905 -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2908 CREATE INDEX repositories_builds_repo_id
ON repositories_builds
USING btree (repo_id
);
2912 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
2915 CREATE TRIGGER on_update_current_timestamp
BEFORE UPDATE ON sources
FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
2919 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2922 ALTER TABLE ONLY arches_compat
2923 ADD CONSTRAINT arches_compat_build_arch
FOREIGN KEY (build_arch
) REFERENCES arches(name);
2927 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2930 ALTER TABLE ONLY builders_history
2931 ADD CONSTRAINT builders_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
2935 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2938 ALTER TABLE ONLY builders_history
2939 ADD CONSTRAINT builders_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2943 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2946 ALTER TABLE ONLY builds_bugs
2947 ADD CONSTRAINT builds_bug_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2951 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2954 ALTER TABLE ONLY builds_comments
2955 ADD CONSTRAINT builds_comments_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2959 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2962 ALTER TABLE ONLY builds_comments
2963 ADD CONSTRAINT builds_comments_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2967 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2970 ALTER TABLE ONLY builds
2971 ADD CONSTRAINT builds_depends_on
FOREIGN KEY (depends_on
) REFERENCES builds(id);
2975 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2978 ALTER TABLE ONLY builds
2979 ADD CONSTRAINT builds_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
2983 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2986 ALTER TABLE ONLY builds_history
2987 ADD CONSTRAINT builds_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
2991 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2994 ALTER TABLE ONLY builds_history
2995 ADD CONSTRAINT builds_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
2999 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3002 ALTER TABLE ONLY builds
3003 ADD CONSTRAINT builds_owner_id
FOREIGN KEY (owner_id
) REFERENCES users(id);
3007 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3010 ALTER TABLE ONLY builds
3011 ADD CONSTRAINT builds_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3015 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3018 ALTER TABLE ONLY builds_watchers
3019 ADD CONSTRAINT builds_watchers_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3023 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3026 ALTER TABLE ONLY builds_watchers
3027 ADD CONSTRAINT builds_watchers_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3031 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3034 ALTER TABLE ONLY distributions_arches
3035 ADD CONSTRAINT distributions_arches_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3039 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3042 ALTER TABLE ONLY distributions_arches
3043 ADD CONSTRAINT distro_arches_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3047 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3050 ALTER TABLE ONLY filelists
3051 ADD CONSTRAINT filelists_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3055 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3058 ALTER TABLE ONLY jobs
3059 ADD CONSTRAINT jobs_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3063 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3066 ALTER TABLE ONLY jobs
3067 ADD CONSTRAINT jobs_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3071 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3074 ALTER TABLE ONLY jobs
3075 ADD CONSTRAINT jobs_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3079 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3082 ALTER TABLE ONLY jobs_buildroots
3083 ADD CONSTRAINT jobs_buildroots_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3087 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3090 ALTER TABLE ONLY jobs_history
3091 ADD CONSTRAINT jobs_history_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3095 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3098 ALTER TABLE ONLY jobs_history
3099 ADD CONSTRAINT jobs_history_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3103 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3106 ALTER TABLE ONLY jobs_history
3107 ADD CONSTRAINT jobs_history_test_job_id
FOREIGN KEY (test_job_id
) REFERENCES jobs(id);
3111 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3114 ALTER TABLE ONLY jobs_history
3115 ADD CONSTRAINT jobs_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3119 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3122 ALTER TABLE ONLY jobs_packages
3123 ADD CONSTRAINT jobs_packaged_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3127 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3130 ALTER TABLE ONLY jobs_packages
3131 ADD CONSTRAINT jobs_packages_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3135 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3138 ALTER TABLE ONLY jobs_repos
3139 ADD CONSTRAINT jobs_repos_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3143 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3146 ALTER TABLE ONLY jobs_repos
3147 ADD CONSTRAINT jobs_repos_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3151 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3154 ALTER TABLE ONLY keys_subkeys
3155 ADD CONSTRAINT keys_subkeys_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3159 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3162 ALTER TABLE ONLY logfiles
3163 ADD CONSTRAINT logfiles_job_id
FOREIGN KEY (job_id
) REFERENCES jobs(id);
3167 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3170 ALTER TABLE ONLY mirrors_checks
3171 ADD CONSTRAINT mirrors_checks_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3175 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3178 ALTER TABLE ONLY mirrors_history
3179 ADD CONSTRAINT mirrors_history_mirror_id
FOREIGN KEY (mirror_id
) REFERENCES mirrors(id);
3183 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3186 ALTER TABLE ONLY mirrors_history
3187 ADD CONSTRAINT mirrors_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3191 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3194 ALTER TABLE ONLY packages
3195 ADD CONSTRAINT packages_arch
FOREIGN KEY (arch
) REFERENCES arches(name);
3199 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3202 ALTER TABLE ONLY packages
3203 ADD CONSTRAINT packages_commit_id
FOREIGN KEY (commit_id
) REFERENCES sources_commits(id);
3207 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3210 ALTER TABLE ONLY packages_deps
3211 ADD CONSTRAINT packages_deps_pkg_id
FOREIGN KEY (pkg_id
) REFERENCES packages(id);
3215 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3218 ALTER TABLE ONLY repositories_aux
3219 ADD CONSTRAINT repositories_aux_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3223 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3226 ALTER TABLE ONLY repositories_builds
3227 ADD CONSTRAINT repositories_builds_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3231 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3234 ALTER TABLE ONLY repositories_builds
3235 ADD CONSTRAINT repositories_builds_repo_id
FOREIGN KEY (repo_id
) REFERENCES repositories(id);
3239 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3242 ALTER TABLE ONLY repositories
3243 ADD CONSTRAINT repositories_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3247 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3250 ALTER TABLE ONLY repositories_history
3251 ADD CONSTRAINT repositories_history_build_id
FOREIGN KEY (build_id
) REFERENCES builds(id);
3255 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3258 ALTER TABLE ONLY repositories_history
3259 ADD CONSTRAINT repositories_history_from_repo_id
FOREIGN KEY (from_repo_id
) REFERENCES repositories(id);
3263 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3266 ALTER TABLE ONLY repositories_history
3267 ADD CONSTRAINT repositories_history_to_repo_id
FOREIGN KEY (to_repo_id
) REFERENCES repositories(id);
3271 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3274 ALTER TABLE ONLY repositories_history
3275 ADD CONSTRAINT repositories_history_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3279 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3282 ALTER TABLE ONLY repositories
3283 ADD CONSTRAINT repositories_key_id
FOREIGN KEY (key_id
) REFERENCES keys(id);
3287 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3290 ALTER TABLE ONLY repositories
3291 ADD CONSTRAINT repositories_parent_id
FOREIGN KEY (parent_id
) REFERENCES repositories(id);
3295 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3298 ALTER TABLE ONLY sessions
3299 ADD CONSTRAINT sessions_impersonated_user_id
FOREIGN KEY (impersonated_user_id
) REFERENCES users(id);
3303 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3306 ALTER TABLE ONLY sessions
3307 ADD CONSTRAINT sessions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3311 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3314 ALTER TABLE ONLY sources_commits
3315 ADD CONSTRAINT sources_commits_source_id
FOREIGN KEY (source_id
) REFERENCES sources(id);
3319 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3322 ALTER TABLE ONLY sources
3323 ADD CONSTRAINT sources_distro_id
FOREIGN KEY (distro_id
) REFERENCES distributions(id);
3327 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3330 ALTER TABLE ONLY uploads
3331 ADD CONSTRAINT uploads_builder_id
FOREIGN KEY (builder_id
) REFERENCES builders(id);
3335 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3338 ALTER TABLE ONLY uploads
3339 ADD CONSTRAINT uploads_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3343 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3346 ALTER TABLE ONLY users_emails
3347 ADD CONSTRAINT users_emails_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3351 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3354 ALTER TABLE ONLY users_permissions
3355 ADD CONSTRAINT users_permissions_user_id
FOREIGN KEY (user_id
) REFERENCES users(id);
3359 -- PostgreSQL database dump complete