]>
Commit | Line | Data |
---|---|---|
9050c160 | 1 | -- |
64316541 MT |
2 | -- PostgreSQL database dump |
3 | -- | |
4 | ||
9936b6b5 MT |
5 | -- Dumped from database version 13.8 (Debian 13.8-0+deb11u1) |
6 | -- Dumped by pg_dump version 13.8 (Debian 13.8-0+deb11u1) | |
67fb52de | 7 | |
64316541 MT |
8 | SET statement_timeout = 0; |
9 | SET lock_timeout = 0; | |
67fb52de | 10 | SET idle_in_transaction_session_timeout = 0; |
64316541 MT |
11 | SET client_encoding = 'UTF8'; |
12 | SET standard_conforming_strings = on; | |
67fb52de | 13 | SELECT pg_catalog.set_config('search_path', '', false); |
64316541 | 14 | SET check_function_bodies = false; |
67fb52de | 15 | SET xmloption = content; |
64316541 | 16 | SET client_min_messages = warning; |
67fb52de | 17 | SET row_security = off; |
64316541 | 18 | |
9050c160 | 19 | -- |
c734cf6c | 20 | -- Name: on_update_current_timestamp_sources(); Type: FUNCTION; Schema: public; Owner: - |
9050c160 MT |
21 | -- |
22 | ||
67fb52de | 23 | CREATE FUNCTION public.on_update_current_timestamp_sources() RETURNS trigger |
64316541 MT |
24 | LANGUAGE plpgsql |
25 | AS $$ | |
26 | BEGIN | |
27 | NEW.updated = now(); | |
28 | RETURN NEW; | |
29 | END; | |
30 | $$; | |
31 | ||
32 | ||
64316541 | 33 | SET default_tablespace = ''; |
9050c160 | 34 | |
67fb52de | 35 | SET default_table_access_method = heap; |
9050c160 | 36 | |
d0f83268 MT |
37 | -- |
38 | -- Name: build_comments; Type: TABLE; Schema: public; Owner: - | |
39 | -- | |
40 | ||
41 | CREATE TABLE public.build_comments ( | |
42 | id integer NOT NULL, | |
43 | build_id integer NOT NULL, | |
44 | user_id integer NOT NULL, | |
45 | text text DEFAULT ''::text NOT NULL, | |
46 | score integer NOT NULL, | |
47 | created_at timestamp without time zone DEFAULT now() NOT NULL, | |
48 | deleted boolean DEFAULT false NOT NULL | |
49 | ); | |
50 | ||
51 | ||
44f74dd6 | 52 | -- |
c734cf6c | 53 | -- Name: build_packages; Type: TABLE; Schema: public; Owner: - |
44f74dd6 MT |
54 | -- |
55 | ||
56 | CREATE TABLE public.build_packages ( | |
57 | build_id integer NOT NULL, | |
58 | package_id integer NOT NULL, | |
59 | job_id integer NOT NULL, | |
60 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL | |
61 | ); | |
62 | ||
63 | ||
6c6380e1 MT |
64 | -- |
65 | -- Name: build_watchers; Type: TABLE; Schema: public; Owner: - | |
66 | -- | |
67 | ||
68 | CREATE TABLE public.build_watchers ( | |
69 | build_id integer NOT NULL, | |
70 | user_id integer NOT NULL, | |
71 | added_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, | |
72 | deleted_at timestamp without time zone | |
73 | ); | |
74 | ||
75 | ||
3a4c6436 | 76 | -- |
c734cf6c | 77 | -- Name: builder_stats; Type: TABLE; Schema: public; Owner: - |
3a4c6436 MT |
78 | -- |
79 | ||
80 | CREATE TABLE public.builder_stats ( | |
81 | builder_id integer NOT NULL, | |
82 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, | |
83 | cpu_user double precision NOT NULL, | |
84 | cpu_nice double precision NOT NULL, | |
85 | cpu_system double precision NOT NULL, | |
86 | cpu_idle double precision NOT NULL, | |
87 | cpu_iowait double precision NOT NULL, | |
88 | cpu_irq double precision NOT NULL, | |
89 | cpu_softirq double precision NOT NULL, | |
90 | cpu_steal double precision NOT NULL, | |
91 | cpu_guest double precision NOT NULL, | |
92 | cpu_guest_nice double precision NOT NULL, | |
93 | loadavg1 double precision NOT NULL, | |
94 | loadavg5 double precision NOT NULL, | |
95 | loadavg15 double precision NOT NULL, | |
96 | mem_total bigint NOT NULL, | |
97 | mem_available bigint NOT NULL, | |
98 | mem_used bigint NOT NULL, | |
99 | mem_free bigint NOT NULL, | |
100 | mem_active bigint NOT NULL, | |
101 | mem_inactive bigint NOT NULL, | |
102 | mem_buffers bigint NOT NULL, | |
103 | mem_cached bigint NOT NULL, | |
104 | mem_shared bigint NOT NULL, | |
105 | swap_total bigint NOT NULL, | |
106 | swap_used bigint NOT NULL, | |
107 | swap_free bigint NOT NULL | |
108 | ); | |
109 | ||
110 | ||
64316541 | 111 | -- |
c734cf6c | 112 | -- Name: builders; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
113 | -- |
114 | ||
67fb52de | 115 | CREATE TABLE public.builders ( |
f835411e MT |
116 | id integer NOT NULL, |
117 | name text NOT NULL, | |
64316541 | 118 | description text, |
e704b8e2 MT |
119 | enabled boolean DEFAULT false NOT NULL, |
120 | deleted boolean DEFAULT false NOT NULL, | |
f835411e | 121 | loadavg text DEFAULT '0'::character varying NOT NULL, |
fd43d5e1 | 122 | testmode boolean DEFAULT true NOT NULL, |
67fb52de | 123 | max_jobs bigint DEFAULT (1)::bigint NOT NULL, |
f835411e MT |
124 | pakfire_version text, |
125 | os_name text, | |
126 | cpu_model text, | |
127 | cpu_count integer DEFAULT 1 NOT NULL, | |
f835411e | 128 | host_key_id text, |
e704b8e2 | 129 | time_created timestamp without time zone DEFAULT now() NOT NULL, |
3a4c6436 | 130 | updated_at timestamp without time zone, |
f835411e | 131 | time_keepalive timestamp without time zone, |
3a4c6436 | 132 | online_until timestamp without time zone, |
316268ce | 133 | cpu_arch text, |
7d81ab17 MT |
134 | instance_id text, |
135 | instance_type text | |
64316541 | 136 | ); |
9050c160 | 137 | |
64316541 | 138 | |
9050c160 | 139 | -- |
c734cf6c | 140 | -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
9050c160 MT |
141 | -- |
142 | ||
67fb52de | 143 | CREATE SEQUENCE public.builders_id_seq |
64316541 MT |
144 | START WITH 1 |
145 | INCREMENT BY 1 | |
146 | NO MINVALUE | |
147 | NO MAXVALUE | |
148 | CACHE 1; | |
149 | ||
9050c160 | 150 | |
9050c160 | 151 | -- |
c734cf6c | 152 | -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
9050c160 MT |
153 | -- |
154 | ||
67fb52de | 155 | ALTER SEQUENCE public.builders_id_seq OWNED BY public.builders.id; |
9050c160 | 156 | |
9050c160 | 157 | |
9050c160 | 158 | -- |
c734cf6c | 159 | -- Name: builds; Type: TABLE; Schema: public; Owner: - |
9050c160 MT |
160 | -- |
161 | ||
67fb52de | 162 | CREATE TABLE public.builds ( |
f835411e | 163 | id integer NOT NULL, |
d7a64543 | 164 | uuid uuid DEFAULT gen_random_uuid() NOT NULL, |
f835411e | 165 | pkg_id integer NOT NULL, |
cb866740 | 166 | state text DEFAULT 'building'::text NOT NULL, |
287235e3 | 167 | severity text, |
64316541 | 168 | message text, |
44f74dd6 | 169 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, |
64d74848 | 170 | build_repo_id integer NOT NULL, |
f835411e | 171 | owner_id integer, |
f835411e | 172 | priority integer DEFAULT 0 NOT NULL, |
44f74dd6 MT |
173 | bug_ids integer[] DEFAULT ARRAY[]::integer[] NOT NULL, |
174 | finished_at timestamp without time zone, | |
7ff8f45a MT |
175 | failed boolean DEFAULT false NOT NULL, |
176 | deleted_at timestamp without time zone, | |
177 | deleted_by integer | |
64316541 MT |
178 | ); |
179 | ||
9050c160 | 180 | |
9050c160 | 181 | -- |
c734cf6c | 182 | -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: - |
9050c160 MT |
183 | -- |
184 | ||
67fb52de | 185 | CREATE TABLE public.builds_bugs_updates ( |
f835411e MT |
186 | id integer NOT NULL, |
187 | bug_id integer NOT NULL, | |
188 | status text, | |
189 | resolution text, | |
64316541 | 190 | comment text, |
f835411e | 191 | "time" timestamp without time zone NOT NULL, |
fd43d5e1 | 192 | error boolean DEFAULT false NOT NULL, |
64316541 MT |
193 | error_msg text |
194 | ); | |
195 | ||
9050c160 | 196 | |
9050c160 | 197 | -- |
c734cf6c | 198 | -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
9050c160 MT |
199 | -- |
200 | ||
67fb52de | 201 | CREATE SEQUENCE public.builds_bugs_updates_id_seq |
64316541 MT |
202 | START WITH 1 |
203 | INCREMENT BY 1 | |
204 | NO MINVALUE | |
205 | NO MAXVALUE | |
206 | CACHE 1; | |
207 | ||
9050c160 | 208 | |
9050c160 | 209 | -- |
c734cf6c | 210 | -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
9050c160 MT |
211 | -- |
212 | ||
67fb52de | 213 | ALTER SEQUENCE public.builds_bugs_updates_id_seq OWNED BY public.builds_bugs_updates.id; |
189ba95b | 214 | |
189ba95b | 215 | |
189ba95b | 216 | -- |
c734cf6c | 217 | -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
189ba95b | 218 | -- |
189ba95b | 219 | |
67fb52de | 220 | CREATE SEQUENCE public.builds_comments_id_seq |
64316541 MT |
221 | START WITH 1 |
222 | INCREMENT BY 1 | |
223 | NO MINVALUE | |
224 | NO MAXVALUE | |
225 | CACHE 1; | |
226 | ||
227 | ||
64316541 | 228 | -- |
c734cf6c | 229 | -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
230 | -- |
231 | ||
d0f83268 | 232 | ALTER SEQUENCE public.builds_comments_id_seq OWNED BY public.build_comments.id; |
64316541 MT |
233 | |
234 | ||
64316541 | 235 | -- |
c734cf6c | 236 | -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
237 | -- |
238 | ||
67fb52de | 239 | CREATE SEQUENCE public.builds_id_seq |
64316541 MT |
240 | START WITH 1 |
241 | INCREMENT BY 1 | |
242 | NO MINVALUE | |
243 | NO MAXVALUE | |
244 | CACHE 1; | |
245 | ||
246 | ||
64316541 | 247 | -- |
c734cf6c | 248 | -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
249 | -- |
250 | ||
67fb52de | 251 | ALTER SEQUENCE public.builds_id_seq OWNED BY public.builds.id; |
64316541 MT |
252 | |
253 | ||
64316541 | 254 | -- |
c734cf6c | 255 | -- Name: distributions; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
256 | -- |
257 | ||
67fb52de | 258 | CREATE TABLE public.distributions ( |
f835411e MT |
259 | id integer NOT NULL, |
260 | name text NOT NULL, | |
88221a11 | 261 | slug text NOT NULL, |
8dc57b8f MT |
262 | slogan text DEFAULT ''::text NOT NULL, |
263 | description text DEFAULT ''::text NOT NULL, | |
264 | vendor text DEFAULT ''::text NOT NULL, | |
265 | contact text DEFAULT ''::text NOT NULL, | |
e459cbba | 266 | tag text NOT NULL, |
7ed93a91 MT |
267 | deleted boolean DEFAULT false NOT NULL, |
268 | arches text[] DEFAULT ARRAY[]::text[] NOT NULL, | |
19e05f59 | 269 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, |
f3e27209 | 270 | custom_config text DEFAULT ''::text NOT NULL |
64316541 MT |
271 | ); |
272 | ||
273 | ||
64316541 | 274 | -- |
c734cf6c | 275 | -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
276 | -- |
277 | ||
67fb52de | 278 | CREATE SEQUENCE public.distributions_id_seq |
64316541 MT |
279 | START WITH 1 |
280 | INCREMENT BY 1 | |
281 | NO MINVALUE | |
282 | NO MAXVALUE | |
283 | CACHE 1; | |
284 | ||
285 | ||
64316541 | 286 | -- |
c734cf6c | 287 | -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
288 | -- |
289 | ||
67fb52de | 290 | ALTER SEQUENCE public.distributions_id_seq OWNED BY public.distributions.id; |
64316541 MT |
291 | |
292 | ||
64316541 | 293 | -- |
c734cf6c | 294 | -- Name: filelists; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
295 | -- |
296 | ||
67fb52de | 297 | CREATE TABLE public.filelists ( |
f835411e | 298 | pkg_id integer NOT NULL, |
fab782ff | 299 | path text NOT NULL, |
64316541 | 300 | size bigint NOT NULL, |
fab782ff | 301 | config boolean DEFAULT false NOT NULL, |
f835411e | 302 | mode integer NOT NULL, |
9936b6b5 MT |
303 | uname text NOT NULL, |
304 | gname text NOT NULL, | |
fab782ff MT |
305 | capabilities text, |
306 | ctime timestamp without time zone NOT NULL, | |
599c1a33 | 307 | mtime timestamp without time zone NOT NULL, |
b640ad8f MT |
308 | digest_sha2_512 bytea, |
309 | digest_sha2_256 bytea, | |
310 | digest_blake2b512 bytea, | |
311 | digest_blake2s256 bytea, | |
312 | digest_sha3_512 bytea, | |
313 | digest_sha3_256 bytea | |
64316541 MT |
314 | ); |
315 | ||
316 | ||
64316541 | 317 | -- |
c734cf6c | 318 | -- Name: images_types; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
319 | -- |
320 | ||
67fb52de | 321 | CREATE TABLE public.images_types ( |
f835411e MT |
322 | id integer NOT NULL, |
323 | type text NOT NULL | |
64316541 MT |
324 | ); |
325 | ||
326 | ||
64316541 | 327 | -- |
c734cf6c | 328 | -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
329 | -- |
330 | ||
67fb52de | 331 | CREATE SEQUENCE public.images_types_id_seq |
64316541 MT |
332 | START WITH 1 |
333 | INCREMENT BY 1 | |
334 | NO MINVALUE | |
335 | NO MAXVALUE | |
336 | CACHE 1; | |
337 | ||
338 | ||
64316541 | 339 | -- |
c734cf6c | 340 | -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
341 | -- |
342 | ||
67fb52de | 343 | ALTER SEQUENCE public.images_types_id_seq OWNED BY public.images_types.id; |
64316541 MT |
344 | |
345 | ||
02de33ff | 346 | -- |
c734cf6c | 347 | -- Name: jobs; Type: TABLE; Schema: public; Owner: - |
02de33ff MT |
348 | -- |
349 | ||
350 | CREATE TABLE public.jobs ( | |
351 | id integer NOT NULL, | |
352 | uuid uuid DEFAULT gen_random_uuid() NOT NULL, | |
353 | build_id integer NOT NULL, | |
354 | arch text NOT NULL, | |
355 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, | |
356 | started_at timestamp without time zone, | |
357 | finished_at timestamp without time zone, | |
358 | builder_id integer, | |
359 | message text, | |
360 | test boolean DEFAULT true NOT NULL, | |
361 | superseeded_by integer, | |
6a988440 MT |
362 | depcheck_succeeded boolean, |
363 | depcheck_performed_at timestamp without time zone, | |
02de33ff | 364 | deleted boolean DEFAULT false NOT NULL, |
ba4d413b MT |
365 | failed boolean DEFAULT false NOT NULL, |
366 | log_path text, | |
367 | log_size bigint, | |
368 | log_digest_blake2s bytea | |
02de33ff MT |
369 | ); |
370 | ||
371 | ||
d287a114 | 372 | -- |
c734cf6c | 373 | -- Name: job_queue; Type: VIEW; Schema: public; Owner: - |
d287a114 MT |
374 | -- |
375 | ||
376 | CREATE VIEW public.job_queue AS | |
377 | SELECT jobs.id AS job_id, | |
02de33ff | 378 | rank() OVER (ORDER BY (NOT jobs.test), builds.priority DESC, jobs.created_at) AS rank, |
d287a114 MT |
379 | jobs.arch |
380 | FROM (public.jobs | |
381 | LEFT JOIN public.builds ON ((jobs.build_id = builds.id))) | |
6a988440 | 382 | WHERE ((jobs.deleted IS FALSE) AND (jobs.started_at IS NULL) AND (jobs.finished_at IS NULL) AND (jobs.depcheck_succeeded IS TRUE)); |
d287a114 MT |
383 | |
384 | ||
64316541 | 385 | -- |
c734cf6c | 386 | -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
387 | -- |
388 | ||
67fb52de | 389 | CREATE TABLE public.jobs_buildroots ( |
f835411e | 390 | job_id integer NOT NULL, |
d7a64543 | 391 | pkg_uuid uuid NOT NULL, |
f835411e | 392 | pkg_name text NOT NULL |
64316541 MT |
393 | ); |
394 | ||
395 | ||
64316541 | 396 | -- |
c734cf6c | 397 | -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
398 | -- |
399 | ||
67fb52de | 400 | CREATE SEQUENCE public.jobs_id_seq |
64316541 MT |
401 | START WITH 1 |
402 | INCREMENT BY 1 | |
403 | NO MINVALUE | |
404 | NO MAXVALUE | |
405 | CACHE 1; | |
406 | ||
407 | ||
64316541 | 408 | -- |
c734cf6c | 409 | -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
410 | -- |
411 | ||
67fb52de | 412 | ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id; |
64316541 MT |
413 | |
414 | ||
415 | -- | |
c734cf6c | 416 | -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
417 | -- |
418 | ||
67fb52de | 419 | CREATE TABLE public.jobs_packages ( |
f835411e MT |
420 | id integer NOT NULL, |
421 | job_id integer NOT NULL, | |
422 | pkg_id integer NOT NULL | |
64316541 MT |
423 | ); |
424 | ||
425 | ||
64316541 | 426 | -- |
c734cf6c | 427 | -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
428 | -- |
429 | ||
67fb52de | 430 | CREATE SEQUENCE public.jobs_packages_id_seq |
64316541 MT |
431 | START WITH 1 |
432 | INCREMENT BY 1 | |
433 | NO MINVALUE | |
434 | NO MAXVALUE | |
435 | CACHE 1; | |
436 | ||
437 | ||
64316541 | 438 | -- |
c734cf6c | 439 | -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
440 | -- |
441 | ||
67fb52de | 442 | ALTER SEQUENCE public.jobs_packages_id_seq OWNED BY public.jobs_packages.id; |
64316541 MT |
443 | |
444 | ||
64316541 | 445 | -- |
c734cf6c | 446 | -- Name: keys; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
447 | -- |
448 | ||
67fb52de | 449 | CREATE TABLE public.keys ( |
f835411e MT |
450 | id integer NOT NULL, |
451 | fingerprint text NOT NULL, | |
2cb08e49 MT |
452 | uid text NOT NULL, |
453 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, | |
454 | expires_at timestamp without time zone, | |
455 | public_key text NOT NULL, | |
456 | secret_key text NOT NULL, | |
457 | name text NOT NULL, | |
458 | email text NOT NULL, | |
459 | deleted boolean DEFAULT false NOT NULL, | |
460 | algo text NOT NULL, | |
461 | length integer NOT NULL, | |
0f20e05c MT |
462 | parent_key_id integer, |
463 | revoked_at timestamp without time zone | |
64316541 MT |
464 | ); |
465 | ||
466 | ||
64316541 | 467 | -- |
c734cf6c | 468 | -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
469 | -- |
470 | ||
67fb52de | 471 | CREATE SEQUENCE public.keys_id_seq |
64316541 MT |
472 | START WITH 1 |
473 | INCREMENT BY 1 | |
474 | NO MINVALUE | |
475 | NO MAXVALUE | |
476 | CACHE 1; | |
477 | ||
478 | ||
64316541 | 479 | -- |
c734cf6c | 480 | -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
481 | -- |
482 | ||
67fb52de | 483 | ALTER SEQUENCE public.keys_id_seq OWNED BY public.keys.id; |
64316541 MT |
484 | |
485 | ||
64316541 | 486 | -- |
c734cf6c | 487 | -- Name: logfiles; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
488 | -- |
489 | ||
67fb52de | 490 | CREATE TABLE public.logfiles ( |
f835411e MT |
491 | id integer NOT NULL, |
492 | job_id integer NOT NULL, | |
493 | path text NOT NULL, | |
64316541 | 494 | filesize bigint NOT NULL, |
f835411e | 495 | hash_sha512 text NOT NULL |
64316541 MT |
496 | ); |
497 | ||
498 | ||
64316541 | 499 | -- |
c734cf6c | 500 | -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
501 | -- |
502 | ||
67fb52de | 503 | CREATE SEQUENCE public.logfiles_id_seq |
64316541 MT |
504 | START WITH 1 |
505 | INCREMENT BY 1 | |
506 | NO MINVALUE | |
507 | NO MAXVALUE | |
508 | CACHE 1; | |
509 | ||
510 | ||
64316541 | 511 | -- |
c734cf6c | 512 | -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
513 | -- |
514 | ||
67fb52de | 515 | ALTER SEQUENCE public.logfiles_id_seq OWNED BY public.logfiles.id; |
64316541 MT |
516 | |
517 | ||
68dd077d | 518 | -- |
c734cf6c | 519 | -- Name: messages; Type: TABLE; Schema: public; Owner: - |
68dd077d MT |
520 | -- |
521 | ||
67fb52de | 522 | CREATE TABLE public.messages ( |
68dd077d MT |
523 | id integer NOT NULL, |
524 | message text NOT NULL, | |
525 | queued_at timestamp without time zone DEFAULT now() NOT NULL, | |
c58cb031 MT |
526 | sent_at timestamp without time zone, |
527 | priority integer DEFAULT 0 NOT NULL, | |
528 | error_message text | |
68dd077d MT |
529 | ); |
530 | ||
531 | ||
68dd077d | 532 | -- |
c734cf6c | 533 | -- Name: messages_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
68dd077d MT |
534 | -- |
535 | ||
67fb52de | 536 | CREATE SEQUENCE public.messages_id_seq |
68dd077d MT |
537 | START WITH 1 |
538 | INCREMENT BY 1 | |
539 | NO MINVALUE | |
540 | NO MAXVALUE | |
541 | CACHE 1; | |
542 | ||
543 | ||
68dd077d | 544 | -- |
c734cf6c | 545 | -- Name: messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
68dd077d MT |
546 | -- |
547 | ||
67fb52de | 548 | ALTER SEQUENCE public.messages_id_seq OWNED BY public.messages.id; |
68dd077d MT |
549 | |
550 | ||
64316541 | 551 | -- |
c734cf6c | 552 | -- Name: mirrors; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
553 | -- |
554 | ||
67fb52de | 555 | CREATE TABLE public.mirrors ( |
f835411e MT |
556 | id integer NOT NULL, |
557 | hostname text NOT NULL, | |
558 | path text NOT NULL, | |
559 | owner text, | |
560 | contact text, | |
3163c789 MT |
561 | deleted boolean DEFAULT false NOT NULL, |
562 | supports_https boolean DEFAULT false NOT NULL | |
64316541 MT |
563 | ); |
564 | ||
565 | ||
c660ff59 | 566 | -- |
c734cf6c | 567 | -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: - |
c660ff59 MT |
568 | -- |
569 | ||
67fb52de | 570 | CREATE TABLE public.mirrors_checks ( |
c660ff59 MT |
571 | id integer NOT NULL, |
572 | mirror_id integer NOT NULL, | |
573 | "timestamp" timestamp without time zone DEFAULT now() NOT NULL, | |
574 | response_time double precision, | |
575 | http_status integer, | |
576 | last_sync_at timestamp without time zone, | |
577 | status text DEFAULT 'OK'::text NOT NULL | |
578 | ); | |
579 | ||
580 | ||
c660ff59 | 581 | -- |
c734cf6c | 582 | -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
c660ff59 MT |
583 | -- |
584 | ||
67fb52de | 585 | CREATE SEQUENCE public.mirrors_checks_id_seq |
c660ff59 MT |
586 | START WITH 1 |
587 | INCREMENT BY 1 | |
588 | NO MINVALUE | |
589 | NO MAXVALUE | |
590 | CACHE 1; | |
591 | ||
592 | ||
c660ff59 | 593 | -- |
c734cf6c | 594 | -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
c660ff59 MT |
595 | -- |
596 | ||
67fb52de | 597 | ALTER SEQUENCE public.mirrors_checks_id_seq OWNED BY public.mirrors_checks.id; |
c660ff59 MT |
598 | |
599 | ||
64316541 | 600 | -- |
c734cf6c | 601 | -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
602 | -- |
603 | ||
67fb52de | 604 | CREATE SEQUENCE public.mirrors_id_seq |
64316541 MT |
605 | START WITH 1 |
606 | INCREMENT BY 1 | |
607 | NO MINVALUE | |
608 | NO MAXVALUE | |
609 | CACHE 1; | |
610 | ||
611 | ||
64316541 | 612 | -- |
c734cf6c | 613 | -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
614 | -- |
615 | ||
67fb52de | 616 | ALTER SEQUENCE public.mirrors_id_seq OWNED BY public.mirrors.id; |
64316541 MT |
617 | |
618 | ||
cb866740 | 619 | -- |
c734cf6c | 620 | -- Name: packages; Type: TABLE; Schema: public; Owner: - |
cb866740 MT |
621 | -- |
622 | ||
67fb52de | 623 | CREATE TABLE public.packages ( |
cb866740 MT |
624 | id integer NOT NULL, |
625 | name text NOT NULL, | |
2bdb1f71 | 626 | evr text NOT NULL, |
cb866740 MT |
627 | arch text NOT NULL, |
628 | groups text NOT NULL, | |
dc398a6f | 629 | maintainer text, |
cb866740 MT |
630 | license text NOT NULL, |
631 | url text NOT NULL, | |
632 | summary text NOT NULL, | |
633 | description text NOT NULL, | |
634 | size bigint NOT NULL, | |
635 | supported_arches text, | |
d7a64543 | 636 | uuid uuid NOT NULL, |
cb866740 | 637 | commit_id integer, |
dc398a6f | 638 | build_id text, |
cb866740 MT |
639 | build_host text NOT NULL, |
640 | build_time timestamp without time zone NOT NULL, | |
3d849bc3 | 641 | path text, |
cb866740 | 642 | filesize bigint NOT NULL, |
dc398a6f MT |
643 | prerequires text[] DEFAULT ARRAY[]::text[] NOT NULL, |
644 | requires text[] DEFAULT ARRAY[]::text[] NOT NULL, | |
645 | provides text[] DEFAULT ARRAY[]::text[] NOT NULL, | |
646 | obsoletes text[] DEFAULT ARRAY[]::text[] NOT NULL, | |
647 | conflicts text[] DEFAULT ARRAY[]::text[] NOT NULL, | |
648 | recommends text[] DEFAULT ARRAY[]::text[] NOT NULL, | |
091eb763 MT |
649 | suggests text[] DEFAULT ARRAY[]::text[] NOT NULL, |
650 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, | |
cb753b5e MT |
651 | deleted boolean DEFAULT false NOT NULL, |
652 | digest_type text NOT NULL, | |
c734cf6c | 653 | digest bytea NOT NULL |
cb866740 MT |
654 | ); |
655 | ||
656 | ||
ea2d036d | 657 | -- |
c734cf6c | 658 | -- Name: package_estimated_build_times; Type: VIEW; Schema: public; Owner: - |
ea2d036d MT |
659 | -- |
660 | ||
661 | CREATE VIEW public.package_estimated_build_times AS | |
662 | SELECT packages.name, | |
663 | jobs.arch, | |
02de33ff | 664 | avg((jobs.finished_at - jobs.started_at)) AS build_time |
ea2d036d MT |
665 | FROM ((public.jobs |
666 | LEFT JOIN public.builds ON ((jobs.build_id = builds.id))) | |
667 | LEFT JOIN public.packages ON ((builds.pkg_id = packages.id))) | |
02de33ff | 668 | WHERE ((jobs.deleted IS FALSE) AND (jobs.started_at IS NOT NULL) AND (jobs.finished_at IS NOT NULL) AND (jobs.failed IS FALSE) AND (jobs.test IS FALSE)) |
ea2d036d MT |
669 | GROUP BY packages.name, jobs.arch; |
670 | ||
671 | ||
ea2d036d | 672 | -- |
c734cf6c | 673 | -- Name: VIEW package_estimated_build_times; Type: COMMENT; Schema: public; Owner: - |
ea2d036d MT |
674 | -- |
675 | ||
676 | COMMENT ON VIEW public.package_estimated_build_times IS 'Should add this later: AND jobs.time_finished >= (CURRENT_TIMESTAMP - ''180 days''::interval)'; | |
677 | ||
678 | ||
091eb763 | 679 | -- |
c734cf6c | 680 | -- Name: package_search_index_generator; Type: VIEW; Schema: public; Owner: - |
091eb763 MT |
681 | -- |
682 | ||
683 | CREATE VIEW public.package_search_index_generator AS | |
684 | WITH p AS ( | |
685 | SELECT DISTINCT ON (packages.name) packages.id, | |
686 | packages.name, | |
687 | packages.summary, | |
688 | packages.description | |
689 | FROM public.packages | |
690 | WHERE ((packages.deleted IS FALSE) AND (packages.arch = 'src'::text)) | |
691 | ORDER BY packages.name, packages.created_at DESC | |
692 | ) | |
693 | SELECT p.id AS package_id, | |
694 | ((setweight(to_tsvector('simple'::regconfig, p.name), 'A'::"char") || setweight(to_tsvector('english'::regconfig, p.summary), 'B'::"char")) || setweight(to_tsvector('english'::regconfig, p.description), 'C'::"char")) AS document | |
695 | FROM p; | |
696 | ||
697 | ||
091eb763 | 698 | -- |
c734cf6c | 699 | -- Name: package_search_index; Type: MATERIALIZED VIEW; Schema: public; Owner: - |
091eb763 MT |
700 | -- |
701 | ||
702 | CREATE MATERIALIZED VIEW public.package_search_index AS | |
703 | SELECT package_search_index_generator.package_id, | |
704 | package_search_index_generator.document | |
705 | FROM public.package_search_index_generator | |
706 | WITH NO DATA; | |
707 | ||
708 | ||
64316541 | 709 | -- |
c734cf6c | 710 | -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
711 | -- |
712 | ||
67fb52de | 713 | CREATE SEQUENCE public.packages_id_seq |
64316541 MT |
714 | START WITH 1 |
715 | INCREMENT BY 1 | |
716 | NO MINVALUE | |
717 | NO MAXVALUE | |
718 | CACHE 1; | |
719 | ||
720 | ||
64316541 | 721 | -- |
c734cf6c | 722 | -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
723 | -- |
724 | ||
67fb52de | 725 | ALTER SEQUENCE public.packages_id_seq OWNED BY public.packages.id; |
64316541 MT |
726 | |
727 | ||
728 | -- | |
c734cf6c | 729 | -- Name: packages_properties; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
730 | -- |
731 | ||
67fb52de | 732 | CREATE TABLE public.packages_properties ( |
f835411e MT |
733 | id integer NOT NULL, |
734 | name text NOT NULL, | |
f835411e | 735 | priority integer DEFAULT 0 NOT NULL |
64316541 MT |
736 | ); |
737 | ||
738 | ||
64316541 | 739 | -- |
c734cf6c | 740 | -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
741 | -- |
742 | ||
67fb52de | 743 | CREATE SEQUENCE public.packages_properties_id_seq |
64316541 MT |
744 | START WITH 1 |
745 | INCREMENT BY 1 | |
746 | NO MINVALUE | |
747 | NO MAXVALUE | |
748 | CACHE 1; | |
749 | ||
750 | ||
64316541 | 751 | -- |
c734cf6c | 752 | -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
753 | -- |
754 | ||
67fb52de | 755 | ALTER SEQUENCE public.packages_properties_id_seq OWNED BY public.packages_properties.id; |
64316541 MT |
756 | |
757 | ||
57e6621b | 758 | -- |
c734cf6c | 759 | -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: - |
57e6621b MT |
760 | -- |
761 | ||
67fb52de | 762 | CREATE VIEW public.relation_sizes AS |
57e6621b MT |
763 | SELECT c.relname AS relation, |
764 | pg_size_pretty(pg_relation_size((c.oid)::regclass)) AS size | |
765 | FROM (pg_class c | |
766 | LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) | |
767 | WHERE (n.nspname <> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name])) | |
67fb52de | 768 | ORDER BY (pg_relation_size((c.oid)::regclass)) DESC; |
57e6621b MT |
769 | |
770 | ||
44f74dd6 | 771 | -- |
c734cf6c | 772 | -- Name: repo_builds; Type: TABLE; Schema: public; Owner: - |
44f74dd6 MT |
773 | -- |
774 | ||
775 | CREATE TABLE public.repo_builds ( | |
776 | repo_id integer NOT NULL, | |
777 | build_id integer NOT NULL, | |
778 | added_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, | |
779 | added_by integer, | |
780 | removed_at timestamp without time zone, | |
781 | removed_by integer | |
782 | ); | |
783 | ||
784 | ||
64316541 | 785 | -- |
c734cf6c | 786 | -- Name: repositories; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
787 | -- |
788 | ||
67fb52de | 789 | CREATE TABLE public.repositories ( |
f835411e MT |
790 | id integer NOT NULL, |
791 | name text NOT NULL, | |
f87d64a2 | 792 | slug text, |
19e05f59 | 793 | description text DEFAULT ''::text NOT NULL, |
f835411e MT |
794 | distro_id integer NOT NULL, |
795 | parent_id integer, | |
9fb4cda3 | 796 | key_id integer NOT NULL, |
fe47bbac | 797 | mirrored boolean DEFAULT false NOT NULL, |
ed2e72d4 | 798 | updated_at timestamp without time zone, |
5bc58fba | 799 | deleted boolean DEFAULT false NOT NULL, |
a7a18be1 | 800 | priority integer, |
f87d64a2 | 801 | owner_id integer, |
f87d64a2 MT |
802 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, |
803 | listed boolean DEFAULT true NOT NULL | |
64316541 MT |
804 | ); |
805 | ||
806 | ||
cb866740 | 807 | -- |
c734cf6c | 808 | -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: - |
cb866740 MT |
809 | -- |
810 | ||
67fb52de | 811 | CREATE TABLE public.repositories_builds ( |
cb866740 MT |
812 | id integer NOT NULL, |
813 | repo_id integer NOT NULL, | |
814 | build_id bigint NOT NULL, | |
815 | time_added timestamp without time zone NOT NULL | |
816 | ); | |
817 | ||
818 | ||
64316541 | 819 | -- |
c734cf6c | 820 | -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
821 | -- |
822 | ||
67fb52de | 823 | CREATE SEQUENCE public.repositories_builds_id_seq |
64316541 MT |
824 | START WITH 1 |
825 | INCREMENT BY 1 | |
826 | NO MINVALUE | |
827 | NO MAXVALUE | |
828 | CACHE 1; | |
829 | ||
830 | ||
64316541 | 831 | -- |
c734cf6c | 832 | -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
833 | -- |
834 | ||
67fb52de | 835 | ALTER SEQUENCE public.repositories_builds_id_seq OWNED BY public.repositories_builds.id; |
64316541 MT |
836 | |
837 | ||
64316541 | 838 | -- |
c734cf6c | 839 | -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
840 | -- |
841 | ||
67fb52de | 842 | CREATE SEQUENCE public.repositories_id_seq |
64316541 MT |
843 | START WITH 1 |
844 | INCREMENT BY 1 | |
845 | NO MINVALUE | |
846 | NO MAXVALUE | |
847 | CACHE 1; | |
848 | ||
849 | ||
64316541 | 850 | -- |
c734cf6c | 851 | -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
852 | -- |
853 | ||
67fb52de | 854 | ALTER SEQUENCE public.repositories_id_seq OWNED BY public.repositories.id; |
64316541 MT |
855 | |
856 | ||
857 | -- | |
c734cf6c | 858 | -- Name: sessions; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
859 | -- |
860 | ||
67fb52de | 861 | CREATE TABLE public.sessions ( |
d2738057 | 862 | id integer NOT NULL, |
f835411e | 863 | session_id text NOT NULL, |
d2738057 MT |
864 | created_at timestamp without time zone DEFAULT now() NOT NULL, |
865 | valid_until timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL, | |
f835411e | 866 | user_id integer NOT NULL, |
d2738057 | 867 | address inet, |
70987fab | 868 | user_agent text |
64316541 MT |
869 | ); |
870 | ||
871 | ||
d2738057 | 872 | -- |
c734cf6c | 873 | -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
d2738057 MT |
874 | -- |
875 | ||
67fb52de | 876 | CREATE SEQUENCE public.sessions_id_seq |
d2738057 MT |
877 | START WITH 1 |
878 | INCREMENT BY 1 | |
879 | NO MINVALUE | |
880 | NO MAXVALUE | |
881 | CACHE 1; | |
882 | ||
883 | ||
d2738057 | 884 | -- |
c734cf6c | 885 | -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
d2738057 MT |
886 | -- |
887 | ||
67fb52de | 888 | ALTER SEQUENCE public.sessions_id_seq OWNED BY public.sessions.id; |
d2738057 MT |
889 | |
890 | ||
64316541 | 891 | -- |
c734cf6c | 892 | -- Name: settings; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
893 | -- |
894 | ||
67fb52de | 895 | CREATE TABLE public.settings ( |
f835411e MT |
896 | k text NOT NULL, |
897 | v text NOT NULL | |
64316541 MT |
898 | ); |
899 | ||
900 | ||
64316541 | 901 | -- |
c734cf6c | 902 | -- Name: sources; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
903 | -- |
904 | ||
67fb52de | 905 | CREATE TABLE public.sources ( |
f835411e MT |
906 | id integer NOT NULL, |
907 | name text NOT NULL, | |
908 | identifier text NOT NULL, | |
909 | url text NOT NULL, | |
910 | gitweb text, | |
911 | revision text NOT NULL, | |
912 | branch text NOT NULL, | |
913 | updated timestamp without time zone, | |
914 | distro_id integer NOT NULL | |
64316541 MT |
915 | ); |
916 | ||
917 | ||
64316541 | 918 | -- |
c734cf6c | 919 | -- Name: sources_commits; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
920 | -- |
921 | ||
67fb52de | 922 | CREATE TABLE public.sources_commits ( |
f835411e MT |
923 | id integer NOT NULL, |
924 | source_id integer NOT NULL, | |
925 | revision text NOT NULL, | |
926 | author text NOT NULL, | |
927 | committer text NOT NULL, | |
928 | subject text NOT NULL, | |
64316541 | 929 | body text NOT NULL, |
f835411e | 930 | date timestamp without time zone NOT NULL, |
287235e3 | 931 | state text DEFAULT 'pending'::text NOT NULL, |
cb866740 | 932 | imported_at timestamp without time zone DEFAULT now() NOT NULL |
64316541 MT |
933 | ); |
934 | ||
935 | ||
64316541 | 936 | -- |
c734cf6c | 937 | -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
938 | -- |
939 | ||
67fb52de | 940 | CREATE SEQUENCE public.sources_commits_id_seq |
64316541 MT |
941 | START WITH 1 |
942 | INCREMENT BY 1 | |
943 | NO MINVALUE | |
944 | NO MAXVALUE | |
945 | CACHE 1; | |
946 | ||
947 | ||
64316541 | 948 | -- |
c734cf6c | 949 | -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
950 | -- |
951 | ||
67fb52de | 952 | ALTER SEQUENCE public.sources_commits_id_seq OWNED BY public.sources_commits.id; |
64316541 MT |
953 | |
954 | ||
955 | -- | |
c734cf6c | 956 | -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
957 | -- |
958 | ||
67fb52de | 959 | CREATE SEQUENCE public.sources_id_seq |
64316541 MT |
960 | START WITH 1 |
961 | INCREMENT BY 1 | |
962 | NO MINVALUE | |
963 | NO MAXVALUE | |
964 | CACHE 1; | |
965 | ||
966 | ||
64316541 | 967 | -- |
c734cf6c | 968 | -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
969 | -- |
970 | ||
67fb52de | 971 | ALTER SEQUENCE public.sources_id_seq OWNED BY public.sources.id; |
64316541 MT |
972 | |
973 | ||
974 | -- | |
c734cf6c | 975 | -- Name: uploads; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
976 | -- |
977 | ||
96bcb9e7 | 978 | CREATE TABLE public.uploads ( |
f835411e | 979 | id integer NOT NULL, |
1614a144 | 980 | uuid uuid DEFAULT gen_random_uuid() NOT NULL, |
f835411e MT |
981 | user_id integer, |
982 | builder_id integer, | |
983 | filename text NOT NULL, | |
96bcb9e7 | 984 | path text NOT NULL, |
64316541 | 985 | size bigint NOT NULL, |
96bcb9e7 MT |
986 | created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, |
987 | expires_at timestamp without time zone DEFAULT (CURRENT_TIMESTAMP + '24:00:00'::interval) NOT NULL | |
64316541 MT |
988 | ); |
989 | ||
990 | ||
64316541 | 991 | -- |
c734cf6c | 992 | -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
993 | -- |
994 | ||
96bcb9e7 | 995 | CREATE SEQUENCE public.uploads_id_seq |
64316541 MT |
996 | START WITH 1 |
997 | INCREMENT BY 1 | |
998 | NO MINVALUE | |
999 | NO MAXVALUE | |
1000 | CACHE 1; | |
1001 | ||
1002 | ||
64316541 | 1003 | -- |
c734cf6c | 1004 | -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
1005 | -- |
1006 | ||
96bcb9e7 | 1007 | ALTER SEQUENCE public.uploads_id_seq OWNED BY public.uploads.id; |
64316541 MT |
1008 | |
1009 | ||
50533a78 | 1010 | -- |
c734cf6c | 1011 | -- Name: user_disk_usages; Type: VIEW; Schema: public; Owner: - |
50533a78 MT |
1012 | -- |
1013 | ||
1014 | CREATE VIEW public.user_disk_usages AS | |
1015 | WITH objects AS ( | |
1016 | SELECT uploads.user_id, | |
1017 | uploads.size | |
1018 | FROM public.uploads | |
1019 | WHERE (uploads.expires_at > CURRENT_TIMESTAMP) | |
1020 | UNION ALL | |
1021 | SELECT builds.owner_id, | |
1022 | packages.size | |
1023 | FROM (public.builds | |
1024 | LEFT JOIN public.packages ON ((builds.pkg_id = packages.id))) | |
7ff8f45a | 1025 | WHERE ((builds.deleted_at IS NULL) AND (builds.owner_id IS NOT NULL)) |
78bdce7b MT |
1026 | UNION ALL |
1027 | SELECT builds.owner_id, | |
1028 | jobs.log_size | |
1029 | FROM (public.jobs | |
1030 | LEFT JOIN public.builds ON ((builds.id = jobs.build_id))) | |
7ff8f45a | 1031 | WHERE ((builds.deleted_at IS NULL) AND (jobs.deleted IS FALSE) AND (builds.owner_id IS NOT NULL) AND (jobs.log_size IS NOT NULL)) |
50533a78 MT |
1032 | ) |
1033 | SELECT objects.user_id, | |
1034 | sum(objects.size) AS disk_usage | |
1035 | FROM objects | |
1036 | GROUP BY objects.user_id; | |
1037 | ||
1038 | ||
64316541 | 1039 | -- |
c734cf6c | 1040 | -- Name: users; Type: TABLE; Schema: public; Owner: - |
64316541 MT |
1041 | -- |
1042 | ||
67fb52de | 1043 | CREATE TABLE public.users ( |
f835411e MT |
1044 | id integer NOT NULL, |
1045 | name text NOT NULL, | |
26fe80df | 1046 | deleted boolean DEFAULT false NOT NULL, |
b01825aa | 1047 | registered_at timestamp without time zone DEFAULT now() NOT NULL, |
50533a78 | 1048 | admin boolean DEFAULT false NOT NULL, |
09d78b55 | 1049 | quota bigint, |
857a7836 | 1050 | perms text[] DEFAULT ARRAY[]::text[] NOT NULL, |
69922f6b | 1051 | _attrs bytea |
64316541 MT |
1052 | ); |
1053 | ||
1054 | ||
64316541 | 1055 | -- |
c734cf6c | 1056 | -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
64316541 MT |
1057 | -- |
1058 | ||
67fb52de | 1059 | CREATE SEQUENCE public.users_id_seq |
64316541 MT |
1060 | START WITH 1 |
1061 | INCREMENT BY 1 | |
1062 | NO MINVALUE | |
1063 | NO MAXVALUE | |
1064 | CACHE 1; | |
1065 | ||
1066 | ||
64316541 | 1067 | -- |
c734cf6c | 1068 | -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
64316541 MT |
1069 | -- |
1070 | ||
67fb52de | 1071 | ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id; |
64316541 MT |
1072 | |
1073 | ||
d0f83268 MT |
1074 | -- |
1075 | -- Name: build_comments id; Type: DEFAULT; Schema: public; Owner: - | |
1076 | -- | |
1077 | ||
1078 | ALTER TABLE ONLY public.build_comments ALTER COLUMN id SET DEFAULT nextval('public.builds_comments_id_seq'::regclass); | |
1079 | ||
1080 | ||
64316541 | 1081 | -- |
c734cf6c | 1082 | -- Name: builders id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1083 | -- |
1084 | ||
67fb52de | 1085 | ALTER TABLE ONLY public.builders ALTER COLUMN id SET DEFAULT nextval('public.builders_id_seq'::regclass); |
64316541 MT |
1086 | |
1087 | ||
64316541 | 1088 | -- |
c734cf6c | 1089 | -- Name: builds id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1090 | -- |
1091 | ||
67fb52de | 1092 | ALTER TABLE ONLY public.builds ALTER COLUMN id SET DEFAULT nextval('public.builds_id_seq'::regclass); |
64316541 MT |
1093 | |
1094 | ||
64316541 | 1095 | -- |
c734cf6c | 1096 | -- Name: builds_bugs_updates id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1097 | -- |
1098 | ||
67fb52de | 1099 | ALTER TABLE ONLY public.builds_bugs_updates ALTER COLUMN id SET DEFAULT nextval('public.builds_bugs_updates_id_seq'::regclass); |
64316541 MT |
1100 | |
1101 | ||
64316541 | 1102 | -- |
c734cf6c | 1103 | -- Name: distributions id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1104 | -- |
1105 | ||
67fb52de | 1106 | ALTER TABLE ONLY public.distributions ALTER COLUMN id SET DEFAULT nextval('public.distributions_id_seq'::regclass); |
64316541 MT |
1107 | |
1108 | ||
64316541 | 1109 | -- |
c734cf6c | 1110 | -- Name: images_types id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1111 | -- |
1112 | ||
67fb52de | 1113 | ALTER TABLE ONLY public.images_types ALTER COLUMN id SET DEFAULT nextval('public.images_types_id_seq'::regclass); |
64316541 MT |
1114 | |
1115 | ||
1116 | -- | |
c734cf6c | 1117 | -- Name: jobs id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1118 | -- |
1119 | ||
67fb52de | 1120 | ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass); |
64316541 MT |
1121 | |
1122 | ||
1123 | -- | |
c734cf6c | 1124 | -- Name: jobs_packages id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1125 | -- |
1126 | ||
67fb52de | 1127 | ALTER TABLE ONLY public.jobs_packages ALTER COLUMN id SET DEFAULT nextval('public.jobs_packages_id_seq'::regclass); |
64316541 MT |
1128 | |
1129 | ||
1130 | -- | |
c734cf6c | 1131 | -- Name: keys id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1132 | -- |
1133 | ||
67fb52de | 1134 | ALTER TABLE ONLY public.keys ALTER COLUMN id SET DEFAULT nextval('public.keys_id_seq'::regclass); |
64316541 MT |
1135 | |
1136 | ||
64316541 | 1137 | -- |
c734cf6c | 1138 | -- Name: logfiles id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1139 | -- |
1140 | ||
67fb52de | 1141 | ALTER TABLE ONLY public.logfiles ALTER COLUMN id SET DEFAULT nextval('public.logfiles_id_seq'::regclass); |
64316541 MT |
1142 | |
1143 | ||
68dd077d | 1144 | -- |
c734cf6c | 1145 | -- Name: messages id; Type: DEFAULT; Schema: public; Owner: - |
68dd077d MT |
1146 | -- |
1147 | ||
67fb52de | 1148 | ALTER TABLE ONLY public.messages ALTER COLUMN id SET DEFAULT nextval('public.messages_id_seq'::regclass); |
68dd077d MT |
1149 | |
1150 | ||
64316541 | 1151 | -- |
c734cf6c | 1152 | -- Name: mirrors id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1153 | -- |
1154 | ||
67fb52de | 1155 | ALTER TABLE ONLY public.mirrors ALTER COLUMN id SET DEFAULT nextval('public.mirrors_id_seq'::regclass); |
64316541 MT |
1156 | |
1157 | ||
c660ff59 | 1158 | -- |
c734cf6c | 1159 | -- Name: mirrors_checks id; Type: DEFAULT; Schema: public; Owner: - |
c660ff59 MT |
1160 | -- |
1161 | ||
67fb52de | 1162 | ALTER TABLE ONLY public.mirrors_checks ALTER COLUMN id SET DEFAULT nextval('public.mirrors_checks_id_seq'::regclass); |
c660ff59 MT |
1163 | |
1164 | ||
64316541 | 1165 | -- |
c734cf6c | 1166 | -- Name: packages id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1167 | -- |
1168 | ||
67fb52de | 1169 | ALTER TABLE ONLY public.packages ALTER COLUMN id SET DEFAULT nextval('public.packages_id_seq'::regclass); |
64316541 MT |
1170 | |
1171 | ||
1172 | -- | |
c734cf6c | 1173 | -- Name: packages_properties id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1174 | -- |
1175 | ||
67fb52de | 1176 | ALTER TABLE ONLY public.packages_properties ALTER COLUMN id SET DEFAULT nextval('public.packages_properties_id_seq'::regclass); |
64316541 MT |
1177 | |
1178 | ||
64316541 | 1179 | -- |
c734cf6c | 1180 | -- Name: repositories id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1181 | -- |
1182 | ||
67fb52de | 1183 | ALTER TABLE ONLY public.repositories ALTER COLUMN id SET DEFAULT nextval('public.repositories_id_seq'::regclass); |
64316541 MT |
1184 | |
1185 | ||
64316541 | 1186 | -- |
c734cf6c | 1187 | -- Name: repositories_builds id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1188 | -- |
1189 | ||
67fb52de | 1190 | ALTER TABLE ONLY public.repositories_builds ALTER COLUMN id SET DEFAULT nextval('public.repositories_builds_id_seq'::regclass); |
64316541 MT |
1191 | |
1192 | ||
d2738057 | 1193 | -- |
c734cf6c | 1194 | -- Name: sessions id; Type: DEFAULT; Schema: public; Owner: - |
d2738057 MT |
1195 | -- |
1196 | ||
67fb52de | 1197 | ALTER TABLE ONLY public.sessions ALTER COLUMN id SET DEFAULT nextval('public.sessions_id_seq'::regclass); |
d2738057 MT |
1198 | |
1199 | ||
64316541 | 1200 | -- |
c734cf6c | 1201 | -- Name: sources id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1202 | -- |
1203 | ||
67fb52de | 1204 | ALTER TABLE ONLY public.sources ALTER COLUMN id SET DEFAULT nextval('public.sources_id_seq'::regclass); |
64316541 MT |
1205 | |
1206 | ||
1207 | -- | |
c734cf6c | 1208 | -- Name: sources_commits id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1209 | -- |
1210 | ||
67fb52de | 1211 | ALTER TABLE ONLY public.sources_commits ALTER COLUMN id SET DEFAULT nextval('public.sources_commits_id_seq'::regclass); |
64316541 MT |
1212 | |
1213 | ||
1214 | -- | |
c734cf6c | 1215 | -- Name: uploads id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1216 | -- |
1217 | ||
67fb52de | 1218 | ALTER TABLE ONLY public.uploads ALTER COLUMN id SET DEFAULT nextval('public.uploads_id_seq'::regclass); |
64316541 MT |
1219 | |
1220 | ||
64316541 | 1221 | -- |
c734cf6c | 1222 | -- Name: users id; Type: DEFAULT; Schema: public; Owner: - |
64316541 MT |
1223 | -- |
1224 | ||
67fb52de | 1225 | ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass); |
64316541 MT |
1226 | |
1227 | ||
d0f83268 MT |
1228 | -- |
1229 | -- Name: build_comments build_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
1230 | -- | |
1231 | ||
1232 | ALTER TABLE ONLY public.build_comments | |
1233 | ADD CONSTRAINT build_comments_pkey PRIMARY KEY (id); | |
1234 | ||
1235 | ||
44f74dd6 | 1236 | -- |
c734cf6c | 1237 | -- Name: builds builds_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
44f74dd6 MT |
1238 | -- |
1239 | ||
1240 | ALTER TABLE ONLY public.builds | |
1241 | ADD CONSTRAINT builds_pkey PRIMARY KEY (id); | |
1242 | ||
1243 | ||
7ed93a91 | 1244 | -- |
c734cf6c | 1245 | -- Name: distributions distributions_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
7ed93a91 MT |
1246 | -- |
1247 | ||
1248 | ALTER TABLE ONLY public.distributions | |
1249 | ADD CONSTRAINT distributions_pkey PRIMARY KEY (id); | |
1250 | ||
1251 | ||
64316541 | 1252 | -- |
c734cf6c | 1253 | -- Name: builders idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1254 | -- |
1255 | ||
67fb52de | 1256 | ALTER TABLE ONLY public.builders |
64316541 MT |
1257 | ADD CONSTRAINT idx_2197954_primary PRIMARY KEY (id); |
1258 | ||
1259 | ||
64316541 | 1260 | -- |
c734cf6c | 1261 | -- Name: builds_bugs_updates idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1262 | -- |
1263 | ||
67fb52de | 1264 | ALTER TABLE ONLY public.builds_bugs_updates |
64316541 MT |
1265 | ADD CONSTRAINT idx_2198008_primary PRIMARY KEY (id); |
1266 | ||
1267 | ||
64316541 | 1268 | -- |
c734cf6c | 1269 | -- Name: images_types idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1270 | -- |
1271 | ||
67fb52de | 1272 | ALTER TABLE ONLY public.images_types |
64316541 MT |
1273 | ADD CONSTRAINT idx_2198057_primary PRIMARY KEY (id); |
1274 | ||
1275 | ||
64316541 | 1276 | -- |
c734cf6c | 1277 | -- Name: jobs_packages idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1278 | -- |
1279 | ||
67fb52de | 1280 | ALTER TABLE ONLY public.jobs_packages |
64316541 MT |
1281 | ADD CONSTRAINT idx_2198085_primary PRIMARY KEY (id); |
1282 | ||
1283 | ||
64316541 | 1284 | -- |
c734cf6c | 1285 | -- Name: logfiles idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1286 | -- |
1287 | ||
67fb52de | 1288 | ALTER TABLE ONLY public.logfiles |
64316541 MT |
1289 | ADD CONSTRAINT idx_2198109_primary PRIMARY KEY (id); |
1290 | ||
1291 | ||
1292 | -- | |
c734cf6c | 1293 | -- Name: mirrors idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1294 | -- |
1295 | ||
67fb52de | 1296 | ALTER TABLE ONLY public.mirrors |
64316541 MT |
1297 | ADD CONSTRAINT idx_2198115_primary PRIMARY KEY (id); |
1298 | ||
1299 | ||
64316541 | 1300 | -- |
c734cf6c | 1301 | -- Name: packages_properties idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1302 | -- |
1303 | ||
67fb52de | 1304 | ALTER TABLE ONLY public.packages_properties |
64316541 MT |
1305 | ADD CONSTRAINT idx_2198147_primary PRIMARY KEY (id); |
1306 | ||
1307 | ||
64316541 | 1308 | -- |
c734cf6c | 1309 | -- Name: repositories_builds idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1310 | -- |
1311 | ||
67fb52de | 1312 | ALTER TABLE ONLY public.repositories_builds |
64316541 MT |
1313 | ADD CONSTRAINT idx_2198189_primary PRIMARY KEY (id); |
1314 | ||
1315 | ||
64316541 | 1316 | -- |
c734cf6c | 1317 | -- Name: sources idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1318 | -- |
1319 | ||
67fb52de | 1320 | ALTER TABLE ONLY public.sources |
64316541 MT |
1321 | ADD CONSTRAINT idx_2198213_primary PRIMARY KEY (id); |
1322 | ||
1323 | ||
1324 | -- | |
c734cf6c | 1325 | -- Name: sources_commits idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1326 | -- |
1327 | ||
67fb52de | 1328 | ALTER TABLE ONLY public.sources_commits |
64316541 MT |
1329 | ADD CONSTRAINT idx_2198222_primary PRIMARY KEY (id); |
1330 | ||
1331 | ||
1332 | -- | |
c734cf6c | 1333 | -- Name: users idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: - |
64316541 MT |
1334 | -- |
1335 | ||
67fb52de | 1336 | ALTER TABLE ONLY public.users |
64316541 MT |
1337 | ADD CONSTRAINT idx_2198244_primary PRIMARY KEY (id); |
1338 | ||
1339 | ||
439d364e | 1340 | -- |
c734cf6c | 1341 | -- Name: jobs_packages jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1342 | -- |
1343 | ||
67fb52de | 1344 | ALTER TABLE ONLY public.jobs_packages |
439d364e MT |
1345 | ADD CONSTRAINT jobs_packages_unique UNIQUE (job_id, pkg_id); |
1346 | ||
439d364e | 1347 | |
02de33ff | 1348 | -- |
c734cf6c | 1349 | -- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
02de33ff MT |
1350 | -- |
1351 | ||
1352 | ALTER TABLE ONLY public.jobs | |
1353 | ADD CONSTRAINT jobs_pkey PRIMARY KEY (id); | |
1354 | ||
1355 | ||
2cb08e49 | 1356 | -- |
c734cf6c | 1357 | -- Name: keys keys_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
2cb08e49 MT |
1358 | -- |
1359 | ||
1360 | ALTER TABLE ONLY public.keys | |
1361 | ADD CONSTRAINT keys_pkey PRIMARY KEY (id); | |
1362 | ||
1363 | ||
c58cb031 MT |
1364 | -- |
1365 | -- Name: messages messages_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
1366 | -- | |
1367 | ||
1368 | ALTER TABLE ONLY public.messages | |
1369 | ADD CONSTRAINT messages_pkey PRIMARY KEY (id); | |
1370 | ||
1371 | ||
c660ff59 | 1372 | -- |
c734cf6c | 1373 | -- Name: mirrors_checks mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
c660ff59 MT |
1374 | -- |
1375 | ||
67fb52de | 1376 | ALTER TABLE ONLY public.mirrors_checks |
c660ff59 MT |
1377 | ADD CONSTRAINT mirrors_checks_pkey PRIMARY KEY (id); |
1378 | ||
1379 | ||
650791fb | 1380 | -- |
c734cf6c | 1381 | -- Name: packages packages_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
650791fb MT |
1382 | -- |
1383 | ||
1384 | ALTER TABLE ONLY public.packages | |
1385 | ADD CONSTRAINT packages_pkey PRIMARY KEY (id); | |
1386 | ||
1387 | ||
29fb7c98 | 1388 | -- |
c734cf6c | 1389 | -- Name: repositories_builds repositories_builds_unique; Type: CONSTRAINT; Schema: public; Owner: - |
29fb7c98 MT |
1390 | -- |
1391 | ||
67fb52de | 1392 | ALTER TABLE ONLY public.repositories_builds |
29fb7c98 MT |
1393 | ADD CONSTRAINT repositories_builds_unique UNIQUE (repo_id, build_id); |
1394 | ||
1395 | ||
f87d64a2 | 1396 | -- |
c734cf6c | 1397 | -- Name: repositories repositories_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
f87d64a2 MT |
1398 | -- |
1399 | ||
1400 | ALTER TABLE ONLY public.repositories | |
1401 | ADD CONSTRAINT repositories_pkey PRIMARY KEY (id); | |
1402 | ||
1403 | ||
d2738057 | 1404 | -- |
c734cf6c | 1405 | -- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: - |
d2738057 MT |
1406 | -- |
1407 | ||
67fb52de | 1408 | ALTER TABLE ONLY public.sessions |
d2738057 MT |
1409 | ADD CONSTRAINT sessions_pkey PRIMARY KEY (id); |
1410 | ||
1411 | ||
1412 | -- | |
c734cf6c | 1413 | -- Name: sessions sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: - |
d2738057 MT |
1414 | -- |
1415 | ||
67fb52de | 1416 | ALTER TABLE ONLY public.sessions |
d2738057 MT |
1417 | ADD CONSTRAINT sessions_session_id_key UNIQUE (session_id); |
1418 | ||
1419 | ||
8b4010c2 | 1420 | -- |
c734cf6c | 1421 | -- Name: uploads uploads_id; Type: CONSTRAINT; Schema: public; Owner: - |
8b4010c2 MT |
1422 | -- |
1423 | ||
67fb52de MT |
1424 | ALTER TABLE ONLY public.uploads |
1425 | ADD CONSTRAINT uploads_id PRIMARY KEY (id); | |
8b4010c2 MT |
1426 | |
1427 | ||
d0f83268 MT |
1428 | -- |
1429 | -- Name: build_comments_build_id; Type: INDEX; Schema: public; Owner: - | |
1430 | -- | |
1431 | ||
1432 | CREATE INDEX build_comments_build_id ON public.build_comments USING btree (build_id) WHERE (deleted IS FALSE); | |
1433 | ||
1434 | ||
1435 | -- | |
1436 | -- Name: build_comments_created_at; Type: INDEX; Schema: public; Owner: - | |
1437 | -- | |
1438 | ||
1439 | CREATE INDEX build_comments_created_at ON public.build_comments USING btree (created_at) WHERE (deleted IS FALSE); | |
1440 | ||
1441 | ||
1442 | -- | |
1443 | -- Name: build_comments_user_id; Type: INDEX; Schema: public; Owner: - | |
1444 | -- | |
1445 | ||
1446 | CREATE INDEX build_comments_user_id ON public.build_comments USING btree (user_id) WHERE (deleted IS FALSE); | |
1447 | ||
1448 | ||
e704b8e2 | 1449 | -- |
c734cf6c | 1450 | -- Name: build_packages_build_id; Type: INDEX; Schema: public; Owner: - |
e704b8e2 MT |
1451 | -- |
1452 | ||
44f74dd6 | 1453 | CREATE INDEX build_packages_build_id ON public.build_packages USING btree (build_id); |
439d364e MT |
1454 | |
1455 | ||
6c6380e1 MT |
1456 | -- |
1457 | -- Name: build_watchers_unique; Type: INDEX; Schema: public; Owner: - | |
1458 | -- | |
1459 | ||
1460 | CREATE UNIQUE INDEX build_watchers_unique ON public.build_watchers USING btree (build_id, user_id) WHERE (deleted_at IS NULL); | |
1461 | ||
1462 | ||
e459cbba | 1463 | -- |
c734cf6c | 1464 | -- Name: builders_name; Type: INDEX; Schema: public; Owner: - |
e459cbba MT |
1465 | -- |
1466 | ||
44f74dd6 | 1467 | CREATE UNIQUE INDEX builders_name ON public.builders USING btree (name) WHERE (deleted IS FALSE); |
e459cbba MT |
1468 | |
1469 | ||
64316541 | 1470 | -- |
c734cf6c | 1471 | -- Name: builds_created_at; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1472 | -- |
1473 | ||
7ff8f45a | 1474 | CREATE INDEX builds_created_at ON public.builds USING btree (created_at DESC) WHERE (deleted_at IS NULL); |
64316541 MT |
1475 | |
1476 | ||
b6463980 MT |
1477 | -- |
1478 | -- Name: builds_deleted; Type: INDEX; Schema: public; Owner: - | |
1479 | -- | |
1480 | ||
1481 | CREATE INDEX builds_deleted ON public.builds USING btree (deleted_at) WHERE (deleted_at IS NOT NULL); | |
1482 | ||
1483 | ||
8066bbf3 | 1484 | -- |
c734cf6c | 1485 | -- Name: builds_pkg_id; Type: INDEX; Schema: public; Owner: - |
8066bbf3 MT |
1486 | -- |
1487 | ||
7ff8f45a | 1488 | CREATE INDEX builds_pkg_id ON public.builds USING btree (pkg_id) WHERE (deleted_at IS NULL); |
8066bbf3 MT |
1489 | |
1490 | ||
64316541 | 1491 | -- |
c734cf6c | 1492 | -- Name: builds_uuid; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1493 | -- |
1494 | ||
7ff8f45a | 1495 | CREATE UNIQUE INDEX builds_uuid ON public.builds USING btree (uuid) WHERE (deleted_at IS NULL); |
64316541 MT |
1496 | |
1497 | ||
64316541 | 1498 | -- |
c734cf6c | 1499 | -- Name: distributions_slug; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1500 | -- |
1501 | ||
44f74dd6 | 1502 | CREATE UNIQUE INDEX distributions_slug ON public.distributions USING btree (slug) WHERE (deleted IS FALSE); |
64316541 MT |
1503 | |
1504 | ||
1505 | -- | |
c734cf6c | 1506 | -- Name: filelists_path; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1507 | -- |
1508 | ||
fab782ff | 1509 | CREATE INDEX filelists_path ON public.filelists USING btree (path); |
64316541 MT |
1510 | |
1511 | ||
1512 | -- | |
c734cf6c | 1513 | -- Name: filelists_pkg_id; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1514 | -- |
1515 | ||
44f74dd6 MT |
1516 | CREATE INDEX filelists_pkg_id ON public.filelists USING btree (pkg_id); |
1517 | ||
1518 | ALTER TABLE public.filelists CLUSTER ON filelists_pkg_id; | |
64316541 MT |
1519 | |
1520 | ||
64316541 | 1521 | -- |
c734cf6c | 1522 | -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1523 | -- |
1524 | ||
67fb52de | 1525 | CREATE UNIQUE INDEX idx_2198147_name ON public.packages_properties USING btree (name); |
64316541 MT |
1526 | |
1527 | ||
1528 | -- | |
c734cf6c | 1529 | -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1530 | -- |
1531 | ||
67fb52de | 1532 | CREATE UNIQUE INDEX idx_2198189_build_id ON public.repositories_builds USING btree (build_id); |
64316541 MT |
1533 | |
1534 | ||
64316541 | 1535 | -- |
c734cf6c | 1536 | -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1537 | -- |
1538 | ||
67fb52de | 1539 | CREATE UNIQUE INDEX idx_2198199_k ON public.settings USING btree (k); |
64316541 MT |
1540 | |
1541 | ||
1542 | -- | |
c734cf6c | 1543 | -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1544 | -- |
1545 | ||
67fb52de | 1546 | CREATE UNIQUE INDEX idx_2198213_identifier ON public.sources USING btree (identifier); |
64316541 MT |
1547 | |
1548 | ||
1549 | -- | |
c734cf6c | 1550 | -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1551 | -- |
1552 | ||
67fb52de | 1553 | CREATE INDEX idx_2198222_revision ON public.sources_commits USING btree (revision); |
64316541 MT |
1554 | |
1555 | ||
1556 | -- | |
c734cf6c | 1557 | -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: - |
64316541 MT |
1558 | -- |
1559 | ||
67fb52de | 1560 | CREATE UNIQUE INDEX idx_2198244_name ON public.users USING btree (name); |
64316541 MT |
1561 | |
1562 | ||
3d743a8e | 1563 | -- |
c734cf6c | 1564 | -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: - |
3d743a8e MT |
1565 | -- |
1566 | ||
67fb52de | 1567 | CREATE INDEX jobs_arch ON public.jobs USING btree (arch); |
3d743a8e MT |
1568 | |
1569 | ||
0a0d8db7 | 1570 | -- |
c734cf6c | 1571 | -- Name: jobs_build_id; Type: INDEX; Schema: public; Owner: - |
0a0d8db7 MT |
1572 | -- |
1573 | ||
02de33ff | 1574 | CREATE INDEX jobs_build_id ON public.jobs USING btree (build_id) WHERE (deleted IS FALSE); |
0a0d8db7 MT |
1575 | |
1576 | ||
6990cac2 | 1577 | -- |
c734cf6c | 1578 | -- Name: jobs_buildroots_job_id; Type: INDEX; Schema: public; Owner: - |
6990cac2 MT |
1579 | -- |
1580 | ||
67fb52de | 1581 | CREATE INDEX jobs_buildroots_job_id ON public.jobs_buildroots USING btree (job_id); |
6990cac2 | 1582 | |
67fb52de | 1583 | ALTER TABLE public.jobs_buildroots CLUSTER ON jobs_buildroots_job_id; |
6990cac2 MT |
1584 | |
1585 | ||
439d364e | 1586 | -- |
c734cf6c | 1587 | -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: - |
439d364e MT |
1588 | -- |
1589 | ||
67fb52de | 1590 | CREATE INDEX jobs_buildroots_pkg_uuid ON public.jobs_buildroots USING btree (pkg_uuid); |
439d364e MT |
1591 | |
1592 | ||
e0e14322 | 1593 | -- |
c734cf6c | 1594 | -- Name: jobs_finished_at; Type: INDEX; Schema: public; Owner: - |
02de33ff MT |
1595 | -- |
1596 | ||
1597 | CREATE INDEX jobs_finished_at ON public.jobs USING btree (finished_at DESC) WHERE (finished_at IS NOT NULL); | |
1598 | ||
1599 | ||
1600 | -- | |
c734cf6c | 1601 | -- Name: jobs_pending; Type: INDEX; Schema: public; Owner: - |
e0e14322 MT |
1602 | -- |
1603 | ||
6a988440 | 1604 | CREATE INDEX jobs_pending ON public.jobs USING btree (id) WHERE ((deleted IS FALSE) AND (started_at IS NULL) AND (finished_at IS NULL) AND (depcheck_succeeded IS TRUE)); |
e0e14322 MT |
1605 | |
1606 | ||
1b1f4a37 | 1607 | -- |
c734cf6c | 1608 | -- Name: jobs_running; Type: INDEX; Schema: public; Owner: - |
1b1f4a37 MT |
1609 | -- |
1610 | ||
650791fb | 1611 | CREATE INDEX jobs_running ON public.jobs USING btree (started_at) WHERE ((started_at IS NOT NULL) AND (finished_at IS NULL)); |
1b1f4a37 MT |
1612 | |
1613 | ||
de667c37 | 1614 | -- |
c734cf6c | 1615 | -- Name: jobs_uuid; Type: INDEX; Schema: public; Owner: - |
de667c37 MT |
1616 | -- |
1617 | ||
02de33ff | 1618 | CREATE UNIQUE INDEX jobs_uuid ON public.jobs USING btree (uuid) WHERE (deleted IS FALSE); |
de667c37 MT |
1619 | |
1620 | ||
2cb08e49 | 1621 | -- |
c734cf6c | 1622 | -- Name: keys_fingerprint; Type: INDEX; Schema: public; Owner: - |
2cb08e49 MT |
1623 | -- |
1624 | ||
1625 | CREATE UNIQUE INDEX keys_fingerprint ON public.keys USING btree (fingerprint) WHERE (deleted IS FALSE); | |
1626 | ||
1627 | ||
68dd077d | 1628 | -- |
c58cb031 | 1629 | -- Name: messages_queued; Type: INDEX; Schema: public; Owner: - |
68dd077d MT |
1630 | -- |
1631 | ||
c58cb031 | 1632 | CREATE INDEX messages_queued ON public.messages USING btree (priority DESC, queued_at) WHERE (sent_at IS NULL); |
68dd077d MT |
1633 | |
1634 | ||
c660ff59 | 1635 | -- |
c734cf6c | 1636 | -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: - |
c660ff59 MT |
1637 | -- |
1638 | ||
67fb52de MT |
1639 | CREATE INDEX mirrors_checks_sort ON public.mirrors_checks USING btree (mirror_id, "timestamp"); |
1640 | ||
1641 | ALTER TABLE public.mirrors_checks CLUSTER ON mirrors_checks_sort; | |
1642 | ||
1643 | ||
091eb763 | 1644 | -- |
c734cf6c | 1645 | -- Name: package_search_index_unique; Type: INDEX; Schema: public; Owner: - |
091eb763 MT |
1646 | -- |
1647 | ||
1648 | CREATE UNIQUE INDEX package_search_index_unique ON public.package_search_index USING btree (package_id); | |
1649 | ||
1650 | ||
650791fb | 1651 | -- |
c734cf6c | 1652 | -- Name: packages_name; Type: INDEX; Schema: public; Owner: - |
650791fb MT |
1653 | -- |
1654 | ||
1655 | CREATE INDEX packages_name ON public.packages USING btree (name); | |
1656 | ||
1657 | ||
091eb763 | 1658 | -- |
c734cf6c | 1659 | -- Name: packages_src_created_at; Type: INDEX; Schema: public; Owner: - |
091eb763 MT |
1660 | -- |
1661 | ||
1662 | CREATE INDEX packages_src_created_at ON public.packages USING btree (created_at DESC) WHERE ((deleted IS FALSE) AND (arch = 'src'::text)); | |
1663 | ||
1664 | ||
650791fb | 1665 | -- |
c734cf6c | 1666 | -- Name: packages_uuid; Type: INDEX; Schema: public; Owner: - |
650791fb MT |
1667 | -- |
1668 | ||
1669 | CREATE UNIQUE INDEX packages_uuid ON public.packages USING btree (uuid) WHERE (deleted IS FALSE); | |
1670 | ||
1671 | ||
44f74dd6 | 1672 | -- |
c734cf6c | 1673 | -- Name: repo_builds_build_id; Type: INDEX; Schema: public; Owner: - |
44f74dd6 MT |
1674 | -- |
1675 | ||
1676 | CREATE INDEX repo_builds_build_id ON public.repo_builds USING btree (build_id); | |
1677 | ||
1678 | ||
1679 | -- | |
c734cf6c | 1680 | -- Name: repo_builds_repo_id; Type: INDEX; Schema: public; Owner: - |
44f74dd6 MT |
1681 | -- |
1682 | ||
1683 | CREATE INDEX repo_builds_repo_id ON public.repo_builds USING btree (repo_id); | |
1684 | ||
1685 | ||
1686 | -- | |
c734cf6c | 1687 | -- Name: repo_builds_unique; Type: INDEX; Schema: public; Owner: - |
44f74dd6 MT |
1688 | -- |
1689 | ||
1690 | CREATE UNIQUE INDEX repo_builds_unique ON public.repo_builds USING btree (repo_id, build_id) WHERE ((added_at IS NOT NULL) AND (removed_at IS NULL)); | |
1691 | ||
1692 | ||
67fb52de | 1693 | -- |
c734cf6c | 1694 | -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: - |
67fb52de | 1695 | -- |
c660ff59 | 1696 | |
67fb52de | 1697 | CREATE INDEX repositories_builds_repo_id ON public.repositories_builds USING btree (repo_id); |
c660ff59 MT |
1698 | |
1699 | ||
f87d64a2 | 1700 | -- |
c734cf6c | 1701 | -- Name: repositories_unique; Type: INDEX; Schema: public; Owner: - |
f87d64a2 MT |
1702 | -- |
1703 | ||
650791fb | 1704 | CREATE UNIQUE INDEX repositories_unique ON public.repositories USING btree (owner_id, distro_id, slug) WHERE (deleted IS FALSE); |
f87d64a2 MT |
1705 | |
1706 | ||
fe47bbac | 1707 | -- |
c734cf6c | 1708 | -- Name: uploads_uuid; Type: INDEX; Schema: public; Owner: - |
fe47bbac MT |
1709 | -- |
1710 | ||
67fb52de | 1711 | CREATE UNIQUE INDEX uploads_uuid ON public.uploads USING btree (uuid); |
fe47bbac MT |
1712 | |
1713 | ||
64316541 | 1714 | -- |
c734cf6c | 1715 | -- Name: sources on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: - |
64316541 MT |
1716 | -- |
1717 | ||
67fb52de | 1718 | CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON public.sources FOR EACH ROW EXECUTE FUNCTION public.on_update_current_timestamp_sources(); |
64316541 MT |
1719 | |
1720 | ||
44f74dd6 | 1721 | -- |
c734cf6c | 1722 | -- Name: build_packages build_packages_build_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
44f74dd6 MT |
1723 | -- |
1724 | ||
1725 | ALTER TABLE ONLY public.build_packages | |
1726 | ADD CONSTRAINT build_packages_build_id FOREIGN KEY (build_id) REFERENCES public.builds(id); | |
1727 | ||
1728 | ||
1729 | -- | |
c734cf6c | 1730 | -- Name: build_packages build_packages_job_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
44f74dd6 MT |
1731 | -- |
1732 | ||
1733 | ALTER TABLE ONLY public.build_packages | |
1734 | ADD CONSTRAINT build_packages_job_id FOREIGN KEY (job_id) REFERENCES public.jobs(id); | |
1735 | ||
1736 | ||
1737 | -- | |
c734cf6c | 1738 | -- Name: build_packages build_packages_package_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
44f74dd6 MT |
1739 | -- |
1740 | ||
1741 | ALTER TABLE ONLY public.build_packages | |
1742 | ADD CONSTRAINT build_packages_package_id FOREIGN KEY (package_id) REFERENCES public.packages(id); | |
1743 | ||
1744 | ||
6c6380e1 MT |
1745 | -- |
1746 | -- Name: build_watchers build_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: - | |
1747 | -- | |
1748 | ||
1749 | ALTER TABLE ONLY public.build_watchers | |
1750 | ADD CONSTRAINT build_watchers_build_id FOREIGN KEY (build_id) REFERENCES public.builds(id); | |
1751 | ||
1752 | ||
1753 | -- | |
1754 | -- Name: build_watchers build_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - | |
1755 | -- | |
1756 | ||
1757 | ALTER TABLE ONLY public.build_watchers | |
1758 | ADD CONSTRAINT build_watchers_user_id FOREIGN KEY (user_id) REFERENCES public.users(id); | |
1759 | ||
1760 | ||
3a4c6436 | 1761 | -- |
c734cf6c | 1762 | -- Name: builder_stats builder_stats_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
3a4c6436 MT |
1763 | -- |
1764 | ||
1765 | ALTER TABLE ONLY public.builder_stats | |
1766 | ADD CONSTRAINT builder_stats_builder_id FOREIGN KEY (builder_id) REFERENCES public.builders(id); | |
1767 | ||
1768 | ||
439d364e | 1769 | -- |
c734cf6c | 1770 | -- Name: builds builds_build_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1771 | -- |
1772 | ||
64d74848 MT |
1773 | ALTER TABLE ONLY public.builds |
1774 | ADD CONSTRAINT builds_build_repo_id FOREIGN KEY (build_repo_id) REFERENCES public.repositories(id); | |
439d364e MT |
1775 | |
1776 | ||
1777 | -- | |
d0f83268 | 1778 | -- Name: build_comments builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1779 | -- |
1780 | ||
d0f83268 | 1781 | ALTER TABLE ONLY public.build_comments |
64d74848 | 1782 | ADD CONSTRAINT builds_comments_build_id FOREIGN KEY (build_id) REFERENCES public.builds(id); |
439d364e MT |
1783 | |
1784 | ||
439d364e | 1785 | -- |
d0f83268 | 1786 | -- Name: build_comments builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1787 | -- |
1788 | ||
d0f83268 | 1789 | ALTER TABLE ONLY public.build_comments |
64d74848 | 1790 | ADD CONSTRAINT builds_comments_user_id FOREIGN KEY (user_id) REFERENCES public.users(id); |
439d364e MT |
1791 | |
1792 | ||
7ff8f45a MT |
1793 | -- |
1794 | -- Name: builds builds_deleted_by; Type: FK CONSTRAINT; Schema: public; Owner: - | |
1795 | -- | |
1796 | ||
1797 | ALTER TABLE ONLY public.builds | |
1798 | ADD CONSTRAINT builds_deleted_by FOREIGN KEY (deleted_by) REFERENCES public.users(id); | |
1799 | ||
1800 | ||
439d364e | 1801 | -- |
c734cf6c | 1802 | -- Name: builds builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1803 | -- |
1804 | ||
67fb52de MT |
1805 | ALTER TABLE ONLY public.builds |
1806 | ADD CONSTRAINT builds_owner_id FOREIGN KEY (owner_id) REFERENCES public.users(id); | |
439d364e MT |
1807 | |
1808 | ||
1809 | -- | |
c734cf6c | 1810 | -- Name: builds builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1811 | -- |
1812 | ||
67fb52de MT |
1813 | ALTER TABLE ONLY public.builds |
1814 | ADD CONSTRAINT builds_pkg_id FOREIGN KEY (pkg_id) REFERENCES public.packages(id); | |
439d364e MT |
1815 | |
1816 | ||
439d364e | 1817 | -- |
c734cf6c | 1818 | -- Name: filelists filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1819 | -- |
1820 | ||
67fb52de MT |
1821 | ALTER TABLE ONLY public.filelists |
1822 | ADD CONSTRAINT filelists_pkg_id FOREIGN KEY (pkg_id) REFERENCES public.packages(id); | |
439d364e MT |
1823 | |
1824 | ||
439d364e | 1825 | -- |
c734cf6c | 1826 | -- Name: jobs jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1827 | -- |
1828 | ||
67fb52de MT |
1829 | ALTER TABLE ONLY public.jobs |
1830 | ADD CONSTRAINT jobs_build_id FOREIGN KEY (build_id) REFERENCES public.builds(id); | |
439d364e MT |
1831 | |
1832 | ||
1833 | -- | |
c734cf6c | 1834 | -- Name: jobs jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1835 | -- |
1836 | ||
67fb52de MT |
1837 | ALTER TABLE ONLY public.jobs |
1838 | ADD CONSTRAINT jobs_builder_id FOREIGN KEY (builder_id) REFERENCES public.builders(id); | |
439d364e MT |
1839 | |
1840 | ||
1841 | -- | |
c734cf6c | 1842 | -- Name: jobs_buildroots jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1843 | -- |
1844 | ||
67fb52de MT |
1845 | ALTER TABLE ONLY public.jobs_buildroots |
1846 | ADD CONSTRAINT jobs_buildroots_job_id FOREIGN KEY (job_id) REFERENCES public.jobs(id); | |
439d364e MT |
1847 | |
1848 | ||
439d364e | 1849 | -- |
c734cf6c | 1850 | -- Name: jobs_packages jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1851 | -- |
1852 | ||
67fb52de MT |
1853 | ALTER TABLE ONLY public.jobs_packages |
1854 | ADD CONSTRAINT jobs_packaged_job_id FOREIGN KEY (job_id) REFERENCES public.jobs(id); | |
439d364e MT |
1855 | |
1856 | ||
1857 | -- | |
c734cf6c | 1858 | -- Name: jobs_packages jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1859 | -- |
1860 | ||
67fb52de MT |
1861 | ALTER TABLE ONLY public.jobs_packages |
1862 | ADD CONSTRAINT jobs_packages_pkg_id FOREIGN KEY (pkg_id) REFERENCES public.packages(id); | |
439d364e MT |
1863 | |
1864 | ||
84f143b0 | 1865 | -- |
c734cf6c | 1866 | -- Name: jobs jobs_superseeded_by; Type: FK CONSTRAINT; Schema: public; Owner: - |
84f143b0 MT |
1867 | -- |
1868 | ||
67fb52de MT |
1869 | ALTER TABLE ONLY public.jobs |
1870 | ADD CONSTRAINT jobs_superseeded_by FOREIGN KEY (superseeded_by) REFERENCES public.jobs(id); | |
84f143b0 MT |
1871 | |
1872 | ||
439d364e | 1873 | -- |
c734cf6c | 1874 | -- Name: keys keys_parent_key_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1875 | -- |
1876 | ||
2cb08e49 MT |
1877 | ALTER TABLE ONLY public.keys |
1878 | ADD CONSTRAINT keys_parent_key_id FOREIGN KEY (parent_key_id) REFERENCES public.keys(id); | |
439d364e MT |
1879 | |
1880 | ||
1881 | -- | |
c734cf6c | 1882 | -- Name: logfiles logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1883 | -- |
1884 | ||
67fb52de MT |
1885 | ALTER TABLE ONLY public.logfiles |
1886 | ADD CONSTRAINT logfiles_job_id FOREIGN KEY (job_id) REFERENCES public.jobs(id); | |
439d364e MT |
1887 | |
1888 | ||
c660ff59 | 1889 | -- |
c734cf6c | 1890 | -- Name: mirrors_checks mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
c660ff59 MT |
1891 | -- |
1892 | ||
67fb52de MT |
1893 | ALTER TABLE ONLY public.mirrors_checks |
1894 | ADD CONSTRAINT mirrors_checks_mirror_id FOREIGN KEY (mirror_id) REFERENCES public.mirrors(id); | |
c660ff59 MT |
1895 | |
1896 | ||
f835411e | 1897 | -- |
c734cf6c | 1898 | -- Name: packages packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
f835411e MT |
1899 | -- |
1900 | ||
67fb52de MT |
1901 | ALTER TABLE ONLY public.packages |
1902 | ADD CONSTRAINT packages_commit_id FOREIGN KEY (commit_id) REFERENCES public.sources_commits(id); | |
f835411e MT |
1903 | |
1904 | ||
44f74dd6 | 1905 | -- |
c734cf6c | 1906 | -- Name: repo_builds repo_builds_added_by; Type: FK CONSTRAINT; Schema: public; Owner: - |
44f74dd6 MT |
1907 | -- |
1908 | ||
1909 | ALTER TABLE ONLY public.repo_builds | |
1910 | ADD CONSTRAINT repo_builds_added_by FOREIGN KEY (added_by) REFERENCES public.users(id); | |
1911 | ||
1912 | ||
1913 | -- | |
c734cf6c | 1914 | -- Name: repo_builds repo_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
44f74dd6 MT |
1915 | -- |
1916 | ||
1917 | ALTER TABLE ONLY public.repo_builds | |
1918 | ADD CONSTRAINT repo_builds_build_id FOREIGN KEY (build_id) REFERENCES public.builds(id); | |
1919 | ||
1920 | ||
1921 | -- | |
c734cf6c | 1922 | -- Name: repo_builds repo_builds_removed_by; Type: FK CONSTRAINT; Schema: public; Owner: - |
44f74dd6 MT |
1923 | -- |
1924 | ||
1925 | ALTER TABLE ONLY public.repo_builds | |
1926 | ADD CONSTRAINT repo_builds_removed_by FOREIGN KEY (removed_by) REFERENCES public.users(id); | |
1927 | ||
1928 | ||
1929 | -- | |
c734cf6c | 1930 | -- Name: repo_builds repo_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
44f74dd6 MT |
1931 | -- |
1932 | ||
1933 | ALTER TABLE ONLY public.repo_builds | |
1934 | ADD CONSTRAINT repo_builds_repo_id FOREIGN KEY (repo_id) REFERENCES public.repositories(id); | |
1935 | ||
1936 | ||
439d364e | 1937 | -- |
c734cf6c | 1938 | -- Name: repositories_builds repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1939 | -- |
1940 | ||
67fb52de MT |
1941 | ALTER TABLE ONLY public.repositories_builds |
1942 | ADD CONSTRAINT repositories_builds_build_id FOREIGN KEY (build_id) REFERENCES public.builds(id); | |
439d364e MT |
1943 | |
1944 | ||
1945 | -- | |
c734cf6c | 1946 | -- Name: repositories_builds repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1947 | -- |
1948 | ||
67fb52de MT |
1949 | ALTER TABLE ONLY public.repositories_builds |
1950 | ADD CONSTRAINT repositories_builds_repo_id FOREIGN KEY (repo_id) REFERENCES public.repositories(id); | |
439d364e MT |
1951 | |
1952 | ||
1953 | -- | |
c734cf6c | 1954 | -- Name: repositories repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1955 | -- |
1956 | ||
67fb52de MT |
1957 | ALTER TABLE ONLY public.repositories |
1958 | ADD CONSTRAINT repositories_distro_id FOREIGN KEY (distro_id) REFERENCES public.distributions(id); | |
439d364e MT |
1959 | |
1960 | ||
439d364e | 1961 | -- |
c734cf6c | 1962 | -- Name: repositories repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1963 | -- |
1964 | ||
67fb52de MT |
1965 | ALTER TABLE ONLY public.repositories |
1966 | ADD CONSTRAINT repositories_key_id FOREIGN KEY (key_id) REFERENCES public.keys(id); | |
439d364e MT |
1967 | |
1968 | ||
1969 | -- | |
c734cf6c | 1970 | -- Name: repositories repositories_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1971 | -- |
1972 | ||
67fb52de | 1973 | ALTER TABLE ONLY public.repositories |
f87d64a2 | 1974 | ADD CONSTRAINT repositories_owner_id FOREIGN KEY (owner_id) REFERENCES public.users(id); |
439d364e MT |
1975 | |
1976 | ||
a7a18be1 | 1977 | -- |
c734cf6c | 1978 | -- Name: repositories repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
a7a18be1 MT |
1979 | -- |
1980 | ||
67fb52de | 1981 | ALTER TABLE ONLY public.repositories |
f87d64a2 | 1982 | ADD CONSTRAINT repositories_parent_id FOREIGN KEY (parent_id) REFERENCES public.repositories(id); |
a7a18be1 MT |
1983 | |
1984 | ||
439d364e | 1985 | -- |
c734cf6c | 1986 | -- Name: sessions sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1987 | -- |
1988 | ||
67fb52de MT |
1989 | ALTER TABLE ONLY public.sessions |
1990 | ADD CONSTRAINT sessions_user_id FOREIGN KEY (user_id) REFERENCES public.users(id); | |
439d364e MT |
1991 | |
1992 | ||
1993 | -- | |
c734cf6c | 1994 | -- Name: sources_commits sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
1995 | -- |
1996 | ||
67fb52de MT |
1997 | ALTER TABLE ONLY public.sources_commits |
1998 | ADD CONSTRAINT sources_commits_source_id FOREIGN KEY (source_id) REFERENCES public.sources(id); | |
439d364e MT |
1999 | |
2000 | ||
2001 | -- | |
c734cf6c | 2002 | -- Name: sources sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
2003 | -- |
2004 | ||
67fb52de MT |
2005 | ALTER TABLE ONLY public.sources |
2006 | ADD CONSTRAINT sources_distro_id FOREIGN KEY (distro_id) REFERENCES public.distributions(id); | |
439d364e MT |
2007 | |
2008 | ||
2009 | -- | |
c734cf6c | 2010 | -- Name: uploads uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
2011 | -- |
2012 | ||
67fb52de MT |
2013 | ALTER TABLE ONLY public.uploads |
2014 | ADD CONSTRAINT uploads_builder_id FOREIGN KEY (builder_id) REFERENCES public.builders(id); | |
439d364e MT |
2015 | |
2016 | ||
2017 | -- | |
c734cf6c | 2018 | -- Name: uploads uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
439d364e MT |
2019 | -- |
2020 | ||
67fb52de MT |
2021 | ALTER TABLE ONLY public.uploads |
2022 | ADD CONSTRAINT uploads_user_id FOREIGN KEY (user_id) REFERENCES public.users(id); | |
439d364e MT |
2023 | |
2024 | ||
64316541 MT |
2025 | -- |
2026 | -- PostgreSQL database dump complete | |
2027 | -- | |
9050c160 | 2028 |