src/database.sql

   1 --
   2 -- PostgreSQL database dump
   3 --
   4
   5 SET statement_timeout = 0;
   6 SET lock_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;
  11
  12 --
  13 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
  14 --
  15
  16 CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
  17
  18
  19 --
  20 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
  21 --
  22
  23 COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
  24
  25
  26 SET search_path = public, pg_catalog;
  27
  28 --
  29 -- Name: arches_binary; Type: TYPE; Schema: public; Owner: pakfire
  30 --
  31
  32 CREATE TYPE arches_binary AS ENUM (
  33     'Y',
  34     'N'
  35 );
  36
  37
  38 ALTER TYPE arches_binary OWNER TO pakfire;
  39
  40 --
  41 -- Name: builders_disabled; Type: TYPE; Schema: public; Owner: pakfire
  42 --
  43
  44 CREATE TYPE builders_disabled AS ENUM (
  45     'Y',
  46     'N'
  47 );
  48
  49
  50 ALTER TYPE builders_disabled OWNER TO pakfire;
  51
  52 --
  53 -- Name: builders_history_action; Type: TYPE; Schema: public; Owner: pakfire
  54 --
  55
  56 CREATE TYPE builders_history_action AS ENUM (
  57     'created',
  58     'enabled',
  59     'disabled',
  60     'deleted'
  61 );
  62
  63
  64 ALTER TYPE builders_history_action OWNER TO pakfire;
  65
  66 --
  67 -- Name: builders_overload; Type: TYPE; Schema: public; Owner: pakfire
  68 --
  69
  70 CREATE TYPE builders_overload AS ENUM (
  71     'Y',
  72     'N'
  73 );
  74
  75
  76 ALTER TYPE builders_overload OWNER TO pakfire;
  77
  78 --
  79 -- Name: builds_auto_move; Type: TYPE; Schema: public; Owner: pakfire
  80 --
  81
  82 CREATE TYPE builds_auto_move AS ENUM (
  83     'N',
  84     'Y'
  85 );
  86
  87
  88 ALTER TYPE builds_auto_move OWNER TO pakfire;
  89
  90 --
  91 -- Name: builds_history_action; Type: TYPE; Schema: public; Owner: pakfire
  92 --
  93
  94 CREATE TYPE builds_history_action AS ENUM (
  95     'created',
  96     'bug_added',
  97     'bug_removed'
  98 );
  99
 100
 101 ALTER TYPE builds_history_action OWNER TO pakfire;
 102
 103 --
 104 -- Name: builds_severity; Type: TYPE; Schema: public; Owner: pakfire
 105 --
 106
 107 CREATE TYPE builds_severity AS ENUM (
 108     'security update',
 109     'bugfix update',
 110     'enhancement',
 111     'new package'
 112 );
 113
 114
 115 ALTER TYPE builds_severity OWNER TO pakfire;
 116
 117 --
 118 -- Name: builds_state; Type: TYPE; Schema: public; Owner: pakfire
 119 --
 120
 121 CREATE TYPE builds_state AS ENUM (
 122     'building',
 123     'testing',
 124     'stable',
 125     'obsolete',
 126     'broken'
 127 );
 128
 129
 130 ALTER TYPE builds_state OWNER TO pakfire;
 131
 132 --
 133 -- Name: builds_type; Type: TYPE; Schema: public; Owner: pakfire
 134 --
 135
 136 CREATE TYPE builds_type AS ENUM (
 137     'release',
 138     'scratch'
 139 );
 140
 141
 142 ALTER TYPE builds_type OWNER TO pakfire;
 143
 144 --
 145 -- Name: filelists_config; Type: TYPE; Schema: public; Owner: pakfire
 146 --
 147
 148 CREATE TYPE filelists_config AS ENUM (
 149     'Y',
 150     'N'
 151 );
 152
 153
 154 ALTER TYPE filelists_config OWNER TO pakfire;
 155
 156 --
 157 -- Name: jobs_history_action; Type: TYPE; Schema: public; Owner: pakfire
 158 --
 159
 160 CREATE TYPE jobs_history_action AS ENUM (
 161     'created',
 162     'state_change',
 163     'reset',
 164     'schedule_rebuild',
 165     'schedule_test_job'
 166 );
 167
 168
 169 ALTER TYPE jobs_history_action OWNER TO pakfire;
 170
 171 --
 172 -- Name: jobs_history_state; Type: TYPE; Schema: public; Owner: pakfire
 173 --
 174
 175 CREATE TYPE jobs_history_state AS ENUM (
 176     'new',
 177     'pending',
 178     'running',
 179     'finished',
 180     'dispatching',
 181     'uploading',
 182     'failed',
 183     'temporary_failed',
 184     'dependency_error',
 185     'aborted',
 186     'download_error',
 187     'deleted'
 188 );
 189
 190
 191 ALTER TYPE jobs_history_state OWNER TO pakfire;
 192
 193 --
 194 -- Name: jobs_state; Type: TYPE; Schema: public; Owner: pakfire
 195 --
 196
 197 CREATE TYPE jobs_state AS ENUM (
 198     'new',
 199     'pending',
 200     'running',
 201     'finished',
 202     'dispatching',
 203     'uploading',
 204     'failed',
 205     'aborted',
 206     'temporary_failed',
 207     'dependency_error',
 208     'download_error',
 209     'deleted'
 210 );
 211
 212
 213 ALTER TYPE jobs_state OWNER TO pakfire;
 214
 215 --
 216 -- Name: jobs_type; Type: TYPE; Schema: public; Owner: pakfire
 217 --
 218
 219 CREATE TYPE jobs_type AS ENUM (
 220     'build',
 221     'test'
 222 );
 223
 224
 225 ALTER TYPE jobs_type OWNER TO pakfire;
 226
 227 --
 228 -- Name: mirrors_history_action; Type: TYPE; Schema: public; Owner: pakfire
 229 --
 230
 231 CREATE TYPE mirrors_history_action AS ENUM (
 232     'created',
 233     'enabled',
 234     'disabled',
 235     'deleted'
 236 );
 237
 238
 239 ALTER TYPE mirrors_history_action OWNER TO pakfire;
 240
 241 --
 242 -- Name: packages_deps_type; Type: TYPE; Schema: public; Owner: pakfire
 243 --
 244
 245 CREATE TYPE packages_deps_type AS ENUM (
 246     'requires',
 247     'prerequires',
 248     'provides',
 249     'conflicts',
 250     'obsoletes',
 251     'suggests',
 252     'recommends'
 253 );
 254
 255
 256 ALTER TYPE packages_deps_type OWNER TO pakfire;
 257
 258 --
 259 -- Name: packages_properties_critical_path; Type: TYPE; Schema: public; Owner: pakfire
 260 --
 261
 262 CREATE TYPE packages_properties_critical_path AS ENUM (
 263     'N',
 264     'Y'
 265 );
 266
 267
 268 ALTER TYPE packages_properties_critical_path OWNER TO pakfire;
 269
 270 --
 271 -- Name: packages_type; Type: TYPE; Schema: public; Owner: pakfire
 272 --
 273
 274 CREATE TYPE packages_type AS ENUM (
 275     'source',
 276     'binary'
 277 );
 278
 279
 280 ALTER TYPE packages_type OWNER TO pakfire;
 281
 282 --
 283 -- Name: repositories_aux_status; Type: TYPE; Schema: public; Owner: pakfire
 284 --
 285
 286 CREATE TYPE repositories_aux_status AS ENUM (
 287     'enabled',
 288     'disabled'
 289 );
 290
 291
 292 ALTER TYPE repositories_aux_status OWNER TO pakfire;
 293
 294 --
 295 -- Name: repositories_enabled_for_builds; Type: TYPE; Schema: public; Owner: pakfire
 296 --
 297
 298 CREATE TYPE repositories_enabled_for_builds AS ENUM (
 299     'N',
 300     'Y'
 301 );
 302
 303
 304 ALTER TYPE repositories_enabled_for_builds OWNER TO pakfire;
 305
 306 --
 307 -- Name: repositories_history_action; Type: TYPE; Schema: public; Owner: pakfire
 308 --
 309
 310 CREATE TYPE repositories_history_action AS ENUM (
 311     'added',
 312     'removed',
 313     'moved'
 314 );
 315
 316
 317 ALTER TYPE repositories_history_action OWNER TO pakfire;
 318
 319 --
 320 -- Name: repositories_mirrored; Type: TYPE; Schema: public; Owner: pakfire
 321 --
 322
 323 CREATE TYPE repositories_mirrored AS ENUM (
 324     'N',
 325     'Y'
 326 );
 327
 328
 329 ALTER TYPE repositories_mirrored OWNER TO pakfire;
 330
 331 --
 332 -- Name: repositories_type; Type: TYPE; Schema: public; Owner: pakfire
 333 --
 334
 335 CREATE TYPE repositories_type AS ENUM (
 336     'testing',
 337     'unstable',
 338     'stable'
 339 );
 340
 341
 342 ALTER TYPE repositories_type OWNER TO pakfire;
 343
 344 --
 345 -- Name: sources_commits_state; Type: TYPE; Schema: public; Owner: pakfire
 346 --
 347
 348 CREATE TYPE sources_commits_state AS ENUM (
 349     'pending',
 350     'running',
 351     'finished',
 352     'failed'
 353 );
 354
 355
 356 ALTER TYPE sources_commits_state OWNER TO pakfire;
 357
 358 --
 359 -- Name: uploads_finished; Type: TYPE; Schema: public; Owner: pakfire
 360 --
 361
 362 CREATE TYPE uploads_finished AS ENUM (
 363     'N',
 364     'Y'
 365 );
 366
 367
 368 ALTER TYPE uploads_finished OWNER TO pakfire;
 369
 370 --
 371 -- Name: users_activated; Type: TYPE; Schema: public; Owner: pakfire
 372 --
 373
 374 CREATE TYPE users_activated AS ENUM (
 375     'Y',
 376     'N'
 377 );
 378
 379
 380 ALTER TYPE users_activated OWNER TO pakfire;
 381
 382 --
 383 -- Name: users_deleted; Type: TYPE; Schema: public; Owner: pakfire
 384 --
 385
 386 CREATE TYPE users_deleted AS ENUM (
 387     'Y',
 388     'N'
 389 );
 390
 391
 392 ALTER TYPE users_deleted OWNER TO pakfire;
 393
 394 --
 395 -- Name: users_emails_primary; Type: TYPE; Schema: public; Owner: pakfire
 396 --
 397
 398 CREATE TYPE users_emails_primary AS ENUM (
 399     'N',
 400     'Y'
 401 );
 402
 403
 404 ALTER TYPE users_emails_primary OWNER TO pakfire;
 405
 406 --
 407 -- Name: users_permissions_create_scratch_builds; Type: TYPE; Schema: public; Owner: pakfire
 408 --
 409
 410 CREATE TYPE users_permissions_create_scratch_builds AS ENUM (
 411     'Y',
 412     'N'
 413 );
 414
 415
 416 ALTER TYPE users_permissions_create_scratch_builds OWNER TO pakfire;
 417
 418 --
 419 -- Name: users_permissions_maintain_builders; Type: TYPE; Schema: public; Owner: pakfire
 420 --
 421
 422 CREATE TYPE users_permissions_maintain_builders AS ENUM (
 423     'N',
 424     'Y'
 425 );
 426
 427
 428 ALTER TYPE users_permissions_maintain_builders OWNER TO pakfire;
 429
 430 --
 431 -- Name: users_permissions_manage_critical_path; Type: TYPE; Schema: public; Owner: pakfire
 432 --
 433
 434 CREATE TYPE users_permissions_manage_critical_path AS ENUM (
 435     'N',
 436     'Y'
 437 );
 438
 439
 440 ALTER TYPE users_permissions_manage_critical_path OWNER TO pakfire;
 441
 442 --
 443 -- Name: users_permissions_manage_mirrors; Type: TYPE; Schema: public; Owner: pakfire
 444 --
 445
 446 CREATE TYPE users_permissions_manage_mirrors AS ENUM (
 447     'N',
 448     'Y'
 449 );
 450
 451
 452 ALTER TYPE users_permissions_manage_mirrors OWNER TO pakfire;
 453
 454 --
 455 -- Name: users_permissions_vote; Type: TYPE; Schema: public; Owner: pakfire
 456 --
 457
 458 CREATE TYPE users_permissions_vote AS ENUM (
 459     'N',
 460     'Y'
 461 );
 462
 463
 464 ALTER TYPE users_permissions_vote OWNER TO pakfire;
 465
 466 --
 467 -- Name: users_state; Type: TYPE; Schema: public; Owner: pakfire
 468 --
 469
 470 CREATE TYPE users_state AS ENUM (
 471     'user',
 472     'tester',
 473     'admin'
 474 );
 475
 476
 477 ALTER TYPE users_state OWNER TO pakfire;
 478
 479 --
 480 -- Name: on_update_current_timestamp_sources(); Type: FUNCTION; Schema: public; Owner: pakfire
 481 --
 482
 483 CREATE FUNCTION on_update_current_timestamp_sources() RETURNS trigger
 484     LANGUAGE plpgsql
 485     AS $$
 486 BEGIN
 487    NEW.updated = now();
 488    RETURN NEW;
 489 END;
 490 $$;
 491
 492
 493 ALTER FUNCTION public.on_update_current_timestamp_sources() OWNER TO pakfire;
 494
 495 SET default_tablespace = '';
 496
 497 SET default_with_oids = false;
 498
 499 --
 500 -- Name: arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 501 --
 502
 503 CREATE TABLE arches (
 504     id integer NOT NULL,
 505     name text NOT NULL
 506 );
 507
 508
 509 ALTER TABLE arches OWNER TO pakfire;
 510
 511 --
 512 -- Name: arches_compat; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 513 --
 514
 515 CREATE TABLE arches_compat (
 516     native_arch text NOT NULL,
 517     build_arch text NOT NULL,
 518     CONSTRAINT arches_compat_unique CHECK ((native_arch <> build_arch))
 519 );
 520
 521
 522 ALTER TABLE arches_compat OWNER TO pakfire;
 523
 524 --
 525 -- Name: arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 526 --
 527
 528 CREATE SEQUENCE arches_id_seq
 529     START WITH 1
 530     INCREMENT BY 1
 531     NO MINVALUE
 532     NO MAXVALUE
 533     CACHE 1;
 534
 535
 536 ALTER TABLE arches_id_seq OWNER TO pakfire;
 537
 538 --
 539 -- Name: arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 540 --
 541
 542 ALTER SEQUENCE arches_id_seq OWNED BY arches.id;
 543
 544
 545 --
 546 -- Name: builders; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 547 --
 548
 549 CREATE TABLE builders (
 550     id integer NOT NULL,
 551     name text NOT NULL,
 552     passphrase text,
 553     description text,
 554     enabled boolean DEFAULT false NOT NULL,
 555     deleted boolean DEFAULT false NOT NULL,
 556     loadavg text DEFAULT '0'::character varying NOT NULL,
 557     testmode boolean DEFAULT true NOT NULL,
 558     max_jobs bigint DEFAULT 1::bigint NOT NULL,
 559     pakfire_version text,
 560     os_name text,
 561     cpu_model text,
 562     cpu_count integer DEFAULT 1 NOT NULL,
 563     cpu_arch text,
 564     cpu_bogomips double precision,
 565     memory bigint DEFAULT 0 NOT NULL,
 566     free_space bigint DEFAULT 0 NOT NULL,
 567     host_key_id text,
 568     time_created timestamp without time zone DEFAULT now() NOT NULL,
 569     time_updated timestamp without time zone,
 570     time_keepalive timestamp without time zone,
 571     loadavg1 double precision,
 572     loadavg5 double precision,
 573     loadavg15 double precision,
 574     mem_total bigint,
 575     mem_free bigint,
 576     swap_total bigint,
 577     swap_free bigint,
 578     space_free bigint
 579 );
 580
 581
 582 ALTER TABLE builders OWNER TO pakfire;
 583
 584 --
 585 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 586 --
 587
 588 CREATE TABLE builders_history (
 589     id integer NOT NULL,
 590     builder_id integer NOT NULL,
 591     action builders_history_action NOT NULL,
 592     user_id integer,
 593     "time" timestamp without time zone NOT NULL
 594 );
 595
 596
 597 ALTER TABLE builders_history OWNER TO pakfire;
 598
 599 --
 600 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 601 --
 602
 603 CREATE SEQUENCE builders_history_id_seq
 604     START WITH 1
 605     INCREMENT BY 1
 606     NO MINVALUE
 607     NO MAXVALUE
 608     CACHE 1;
 609
 610
 611 ALTER TABLE builders_history_id_seq OWNER TO pakfire;
 612
 613 --
 614 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 615 --
 616
 617 ALTER SEQUENCE builders_history_id_seq OWNED BY builders_history.id;
 618
 619
 620 --
 621 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 622 --
 623
 624 CREATE SEQUENCE builders_id_seq
 625     START WITH 1
 626     INCREMENT BY 1
 627     NO MINVALUE
 628     NO MAXVALUE
 629     CACHE 1;
 630
 631
 632 ALTER TABLE builders_id_seq OWNER TO pakfire;
 633
 634 --
 635 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 636 --
 637
 638 ALTER SEQUENCE builders_id_seq OWNED BY builders.id;
 639
 640
 641 --
 642 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 643 --
 644
 645 CREATE TABLE builds (
 646     id integer NOT NULL,
 647     uuid text NOT NULL,
 648     pkg_id integer NOT NULL,
 649     type builds_type DEFAULT 'release'::builds_type NOT NULL,
 650     state text DEFAULT 'building'::text NOT NULL,
 651     severity builds_severity,
 652     message text,
 653     time_created timestamp without time zone DEFAULT now() NOT NULL,
 654     update_year integer,
 655     update_num integer,
 656     depends_on integer,
 657     distro_id integer NOT NULL,
 658     owner_id integer,
 659     priority integer DEFAULT 0 NOT NULL,
 660     auto_move boolean DEFAULT false NOT NULL
 661 );
 662
 663
 664 ALTER TABLE builds OWNER TO pakfire;
 665
 666 --
 667 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 668 --
 669
 670 CREATE TABLE builds_bugs (
 671     id integer NOT NULL,
 672     build_id integer NOT NULL,
 673     bug_id integer NOT NULL
 674 );
 675
 676
 677 ALTER TABLE builds_bugs OWNER TO pakfire;
 678
 679 --
 680 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 681 --
 682
 683 CREATE SEQUENCE builds_bugs_id_seq
 684     START WITH 1
 685     INCREMENT BY 1
 686     NO MINVALUE
 687     NO MAXVALUE
 688     CACHE 1;
 689
 690
 691 ALTER TABLE builds_bugs_id_seq OWNER TO pakfire;
 692
 693 --
 694 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 695 --
 696
 697 ALTER SEQUENCE builds_bugs_id_seq OWNED BY builds_bugs.id;
 698
 699
 700 --
 701 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 702 --
 703
 704 CREATE TABLE builds_bugs_updates (
 705     id integer NOT NULL,
 706     bug_id integer NOT NULL,
 707     status text,
 708     resolution text,
 709     comment text,
 710     "time" timestamp without time zone NOT NULL,
 711     error boolean DEFAULT false NOT NULL,
 712     error_msg text
 713 );
 714
 715
 716 ALTER TABLE builds_bugs_updates OWNER TO pakfire;
 717
 718 --
 719 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 720 --
 721
 722 CREATE SEQUENCE builds_bugs_updates_id_seq
 723     START WITH 1
 724     INCREMENT BY 1
 725     NO MINVALUE
 726     NO MAXVALUE
 727     CACHE 1;
 728
 729
 730 ALTER TABLE builds_bugs_updates_id_seq OWNER TO pakfire;
 731
 732 --
 733 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 734 --
 735
 736 ALTER SEQUENCE builds_bugs_updates_id_seq OWNED BY builds_bugs_updates.id;
 737
 738
 739 --
 740 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 741 --
 742
 743 CREATE TABLE builds_comments (
 744     id integer NOT NULL,
 745     build_id integer NOT NULL,
 746     user_id integer NOT NULL,
 747     text text NOT NULL,
 748     score integer NOT NULL,
 749     time_created timestamp without time zone NOT NULL,
 750     time_updated timestamp without time zone
 751 );
 752
 753
 754 ALTER TABLE builds_comments OWNER TO pakfire;
 755
 756 --
 757 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 758 --
 759
 760 CREATE SEQUENCE builds_comments_id_seq
 761     START WITH 1
 762     INCREMENT BY 1
 763     NO MINVALUE
 764     NO MAXVALUE
 765     CACHE 1;
 766
 767
 768 ALTER TABLE builds_comments_id_seq OWNER TO pakfire;
 769
 770 --
 771 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 772 --
 773
 774 ALTER SEQUENCE builds_comments_id_seq OWNED BY builds_comments.id;
 775
 776
 777 --
 778 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 779 --
 780
 781 CREATE TABLE builds_history (
 782     id integer NOT NULL,
 783     build_id integer NOT NULL,
 784     action builds_history_action NOT NULL,
 785     user_id integer,
 786     "time" timestamp without time zone NOT NULL,
 787     bug_id integer
 788 );
 789
 790
 791 ALTER TABLE builds_history OWNER TO pakfire;
 792
 793 --
 794 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 795 --
 796
 797 CREATE SEQUENCE builds_history_id_seq
 798     START WITH 1
 799     INCREMENT BY 1
 800     NO MINVALUE
 801     NO MAXVALUE
 802     CACHE 1;
 803
 804
 805 ALTER TABLE builds_history_id_seq OWNER TO pakfire;
 806
 807 --
 808 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 809 --
 810
 811 ALTER SEQUENCE builds_history_id_seq OWNED BY builds_history.id;
 812
 813
 814 --
 815 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 816 --
 817
 818 CREATE SEQUENCE builds_id_seq
 819     START WITH 1
 820     INCREMENT BY 1
 821     NO MINVALUE
 822     NO MAXVALUE
 823     CACHE 1;
 824
 825
 826 ALTER TABLE builds_id_seq OWNER TO pakfire;
 827
 828 --
 829 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 830 --
 831
 832 ALTER SEQUENCE builds_id_seq OWNED BY builds.id;
 833
 834
 835 --
 836 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 837 --
 838
 839 CREATE TABLE jobs (
 840     id integer NOT NULL,
 841     uuid text NOT NULL,
 842     build_id integer NOT NULL,
 843     state jobs_state DEFAULT 'new'::jobs_state NOT NULL,
 844     arch text NOT NULL,
 845     time_created timestamp without time zone DEFAULT now() NOT NULL,
 846     time_started timestamp without time zone,
 847     time_finished timestamp without time zone,
 848     start_not_before timestamp without time zone,
 849     builder_id integer,
 850     aborted_state integer DEFAULT 0 NOT NULL,
 851     message text,
 852     test boolean DEFAULT true NOT NULL,
 853     superseeded_by integer
 854 );
 855
 856
 857 ALTER TABLE jobs OWNER TO pakfire;
 858
 859 --
 860 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
 861 --
 862
 863 CREATE VIEW builds_times AS
 864  SELECT jobs.build_id,
 865     jobs.arch,
 866     (jobs.time_finished - jobs.time_started) AS duration
 867    FROM jobs
 868   WHERE ((jobs.test IS FALSE) AND (jobs.state = 'finished'::jobs_state));
 869
 870
 871 ALTER TABLE builds_times OWNER TO pakfire;
 872
 873 --
 874 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 875 --
 876
 877 CREATE TABLE builds_watchers (
 878     id integer NOT NULL,
 879     build_id integer NOT NULL,
 880     user_id integer NOT NULL
 881 );
 882
 883
 884 ALTER TABLE builds_watchers OWNER TO pakfire;
 885
 886 --
 887 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 888 --
 889
 890 CREATE SEQUENCE builds_watchers_id_seq
 891     START WITH 1
 892     INCREMENT BY 1
 893     NO MINVALUE
 894     NO MAXVALUE
 895     CACHE 1;
 896
 897
 898 ALTER TABLE builds_watchers_id_seq OWNER TO pakfire;
 899
 900 --
 901 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 902 --
 903
 904 ALTER SEQUENCE builds_watchers_id_seq OWNED BY builds_watchers.id;
 905
 906
 907 --
 908 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 909 --
 910
 911 CREATE TABLE distributions (
 912     id integer NOT NULL,
 913     name text NOT NULL,
 914     sname text NOT NULL,
 915     slogan text NOT NULL,
 916     description text,
 917     vendor text NOT NULL,
 918     contact text,
 919     tag text NOT NULL,
 920     deleted boolean DEFAULT false NOT NULL
 921 );
 922
 923
 924 ALTER TABLE distributions OWNER TO pakfire;
 925
 926 --
 927 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 928 --
 929
 930 CREATE TABLE distributions_arches (
 931     id integer NOT NULL,
 932     distro_id integer NOT NULL,
 933     arch text NOT NULL
 934 );
 935
 936
 937 ALTER TABLE distributions_arches OWNER TO pakfire;
 938
 939 --
 940 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 941 --
 942
 943 CREATE SEQUENCE distributions_id_seq
 944     START WITH 1
 945     INCREMENT BY 1
 946     NO MINVALUE
 947     NO MAXVALUE
 948     CACHE 1;
 949
 950
 951 ALTER TABLE distributions_id_seq OWNER TO pakfire;
 952
 953 --
 954 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 955 --
 956
 957 ALTER SEQUENCE distributions_id_seq OWNED BY distributions.id;
 958
 959
 960 --
 961 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 962 --
 963
 964 CREATE SEQUENCE distro_arches_id_seq
 965     START WITH 1
 966     INCREMENT BY 1
 967     NO MINVALUE
 968     NO MAXVALUE
 969     CACHE 1;
 970
 971
 972 ALTER TABLE distro_arches_id_seq OWNER TO pakfire;
 973
 974 --
 975 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 976 --
 977
 978 ALTER SEQUENCE distro_arches_id_seq OWNED BY distributions_arches.id;
 979
 980
 981 --
 982 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 983 --
 984
 985 CREATE TABLE filelists (
 986     pkg_id integer NOT NULL,
 987     name text NOT NULL,
 988     size bigint NOT NULL,
 989     hash_sha512 text,
 990     type integer NOT NULL,
 991     config boolean NOT NULL,
 992     mode integer NOT NULL,
 993     "user" text NOT NULL,
 994     "group" text NOT NULL,
 995     mtime timestamp without time zone NOT NULL,
 996     capabilities text
 997 );
 998
 999
1000 ALTER TABLE filelists OWNER TO pakfire;
1001
1002 --
1003 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1004 --
1005
1006 CREATE TABLE images_types (
1007     id integer NOT NULL,
1008     type text NOT NULL
1009 );
1010
1011
1012 ALTER TABLE images_types OWNER TO pakfire;
1013
1014 --
1015 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1016 --
1017
1018 CREATE SEQUENCE images_types_id_seq
1019     START WITH 1
1020     INCREMENT BY 1
1021     NO MINVALUE
1022     NO MAXVALUE
1023     CACHE 1;
1024
1025
1026 ALTER TABLE images_types_id_seq OWNER TO pakfire;
1027
1028 --
1029 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1030 --
1031
1032 ALTER SEQUENCE images_types_id_seq OWNED BY images_types.id;
1033
1034
1035 --
1036 -- Name: jobs_active; Type: VIEW; Schema: public; Owner: pakfire
1037 --
1038
1039 CREATE VIEW jobs_active AS
1040  SELECT jobs.id,
1041     jobs.uuid,
1042     jobs.build_id,
1043     jobs.state,
1044     jobs.arch,
1045     jobs.time_created,
1046     jobs.time_started,
1047     jobs.time_finished,
1048     jobs.start_not_before,
1049     jobs.builder_id,
1050     jobs.aborted_state,
1051     jobs.message
1052    FROM jobs
1053   WHERE (jobs.state = ANY (ARRAY['dispatching'::jobs_state, 'running'::jobs_state, 'uploading'::jobs_state]))
1054   ORDER BY jobs.time_started;
1055
1056
1057 ALTER TABLE jobs_active OWNER TO pakfire;
1058
1059 --
1060 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1061 --
1062
1063 CREATE TABLE jobs_buildroots (
1064     job_id integer NOT NULL,
1065     pkg_uuid text NOT NULL,
1066     pkg_name text NOT NULL
1067 );
1068
1069
1070 ALTER TABLE jobs_buildroots OWNER TO pakfire;
1071
1072 --
1073 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1074 --
1075
1076 CREATE TABLE jobs_history (
1077     job_id integer NOT NULL,
1078     action jobs_history_action NOT NULL,
1079     state jobs_history_state,
1080     user_id integer,
1081     "time" timestamp without time zone NOT NULL,
1082     builder_id integer,
1083     test_job_id integer
1084 );
1085
1086
1087 ALTER TABLE jobs_history OWNER TO pakfire;
1088
1089 --
1090 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1091 --
1092
1093 CREATE SEQUENCE jobs_id_seq
1094     START WITH 1
1095     INCREMENT BY 1
1096     NO MINVALUE
1097     NO MAXVALUE
1098     CACHE 1;
1099
1100
1101 ALTER TABLE jobs_id_seq OWNER TO pakfire;
1102
1103 --
1104 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1105 --
1106
1107 ALTER SEQUENCE jobs_id_seq OWNED BY jobs.id;
1108
1109
1110 --
1111 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1112 --
1113
1114 CREATE TABLE jobs_packages (
1115     id integer NOT NULL,
1116     job_id integer NOT NULL,
1117     pkg_id integer NOT NULL
1118 );
1119
1120
1121 ALTER TABLE jobs_packages OWNER TO pakfire;
1122
1123 --
1124 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1125 --
1126
1127 CREATE SEQUENCE jobs_packages_id_seq
1128     START WITH 1
1129     INCREMENT BY 1
1130     NO MINVALUE
1131     NO MAXVALUE
1132     CACHE 1;
1133
1134
1135 ALTER TABLE jobs_packages_id_seq OWNER TO pakfire;
1136
1137 --
1138 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1139 --
1140
1141 ALTER SEQUENCE jobs_packages_id_seq OWNED BY jobs_packages.id;
1142
1143
1144 --
1145 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
1146 --
1147
1148 CREATE VIEW jobs_queue AS
1149  WITH queue AS (
1150          SELECT jobs.id,
1151             rank() OVER (ORDER BY (NOT jobs.test), builds.priority DESC, jobs.time_created) AS rank
1152            FROM (jobs
1153              LEFT JOIN builds ON ((jobs.build_id = builds.id)))
1154           WHERE (jobs.state = 'pending'::jobs_state)
1155         )
1156  SELECT queue.id AS job_id,
1157     queue.rank
1158    FROM queue;
1159
1160
1161 ALTER TABLE jobs_queue OWNER TO pakfire;
1162
1163 --
1164 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1165 --
1166
1167 CREATE TABLE jobs_repos (
1168     job_id integer NOT NULL,
1169     repo_id integer NOT NULL
1170 );
1171
1172
1173 ALTER TABLE jobs_repos OWNER TO pakfire;
1174
1175 --
1176 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1177 --
1178
1179 CREATE TABLE keys (
1180     id integer NOT NULL,
1181     fingerprint text NOT NULL,
1182     uids text NOT NULL,
1183     data text NOT NULL
1184 );
1185
1186
1187 ALTER TABLE keys OWNER TO pakfire;
1188
1189 --
1190 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1191 --
1192
1193 CREATE SEQUENCE keys_id_seq
1194     START WITH 1
1195     INCREMENT BY 1
1196     NO MINVALUE
1197     NO MAXVALUE
1198     CACHE 1;
1199
1200
1201 ALTER TABLE keys_id_seq OWNER TO pakfire;
1202
1203 --
1204 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1205 --
1206
1207 ALTER SEQUENCE keys_id_seq OWNED BY keys.id;
1208
1209
1210 --
1211 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1212 --
1213
1214 CREATE TABLE keys_subkeys (
1215     id integer NOT NULL,
1216     key_id integer NOT NULL,
1217     fingerprint text NOT NULL,
1218     time_created timestamp without time zone NOT NULL,
1219     time_expires timestamp without time zone,
1220     algo text
1221 );
1222
1223
1224 ALTER TABLE keys_subkeys OWNER TO pakfire;
1225
1226 --
1227 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1228 --
1229
1230 CREATE SEQUENCE keys_subkeys_id_seq
1231     START WITH 1
1232     INCREMENT BY 1
1233     NO MINVALUE
1234     NO MAXVALUE
1235     CACHE 1;
1236
1237
1238 ALTER TABLE keys_subkeys_id_seq OWNER TO pakfire;
1239
1240 --
1241 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1242 --
1243
1244 ALTER SEQUENCE keys_subkeys_id_seq OWNED BY keys_subkeys.id;
1245
1246
1247 --
1248 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1249 --
1250
1251 CREATE TABLE logfiles (
1252     id integer NOT NULL,
1253     job_id integer NOT NULL,
1254     path text NOT NULL,
1255     filesize bigint NOT NULL,
1256     hash_sha512 text NOT NULL
1257 );
1258
1259
1260 ALTER TABLE logfiles OWNER TO pakfire;
1261
1262 --
1263 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1264 --
1265
1266 CREATE SEQUENCE logfiles_id_seq
1267     START WITH 1
1268     INCREMENT BY 1
1269     NO MINVALUE
1270     NO MAXVALUE
1271     CACHE 1;
1272
1273
1274 ALTER TABLE logfiles_id_seq OWNER TO pakfire;
1275
1276 --
1277 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1278 --
1279
1280 ALTER SEQUENCE logfiles_id_seq OWNED BY logfiles.id;
1281
1282
1283 --
1284 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1285 --
1286
1287 CREATE TABLE mirrors (
1288     id integer NOT NULL,
1289     hostname text NOT NULL,
1290     path text NOT NULL,
1291     owner text,
1292     contact text,
1293     deleted boolean DEFAULT false NOT NULL,
1294     supports_https boolean DEFAULT false NOT NULL
1295 );
1296
1297
1298 ALTER TABLE mirrors OWNER TO pakfire;
1299
1300 --
1301 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1302 --
1303
1304 CREATE TABLE mirrors_checks (
1305     id integer NOT NULL,
1306     mirror_id integer NOT NULL,
1307     "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
1308     response_time double precision,
1309     http_status integer,
1310     last_sync_at timestamp without time zone,
1311     status text DEFAULT 'OK'::text NOT NULL
1312 );
1313
1314
1315 ALTER TABLE mirrors_checks OWNER TO pakfire;
1316
1317 --
1318 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1319 --
1320
1321 CREATE SEQUENCE mirrors_checks_id_seq
1322     START WITH 1
1323     INCREMENT BY 1
1324     NO MINVALUE
1325     NO MAXVALUE
1326     CACHE 1;
1327
1328
1329 ALTER TABLE mirrors_checks_id_seq OWNER TO pakfire;
1330
1331 --
1332 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1333 --
1334
1335 ALTER SEQUENCE mirrors_checks_id_seq OWNED BY mirrors_checks.id;
1336
1337
1338 --
1339 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1340 --
1341
1342 CREATE TABLE mirrors_history (
1343     id integer NOT NULL,
1344     mirror_id integer NOT NULL,
1345     action mirrors_history_action NOT NULL,
1346     user_id integer,
1347     "time" timestamp without time zone NOT NULL
1348 );
1349
1350
1351 ALTER TABLE mirrors_history OWNER TO pakfire;
1352
1353 --
1354 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1355 --
1356
1357 CREATE SEQUENCE mirrors_history_id_seq
1358     START WITH 1
1359     INCREMENT BY 1
1360     NO MINVALUE
1361     NO MAXVALUE
1362     CACHE 1;
1363
1364
1365 ALTER TABLE mirrors_history_id_seq OWNER TO pakfire;
1366
1367 --
1368 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1369 --
1370
1371 ALTER SEQUENCE mirrors_history_id_seq OWNED BY mirrors_history.id;
1372
1373
1374 --
1375 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1376 --
1377
1378 CREATE SEQUENCE mirrors_id_seq
1379     START WITH 1
1380     INCREMENT BY 1
1381     NO MINVALUE
1382     NO MAXVALUE
1383     CACHE 1;
1384
1385
1386 ALTER TABLE mirrors_id_seq OWNER TO pakfire;
1387
1388 --
1389 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1390 --
1391
1392 ALTER SEQUENCE mirrors_id_seq OWNED BY mirrors.id;
1393
1394
1395 --
1396 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1397 --
1398
1399 CREATE TABLE packages (
1400     id integer NOT NULL,
1401     name text NOT NULL,
1402     epoch integer NOT NULL,
1403     version text NOT NULL,
1404     release text NOT NULL,
1405     type packages_type NOT NULL,
1406     arch text NOT NULL,
1407     groups text NOT NULL,
1408     maintainer text NOT NULL,
1409     license text NOT NULL,
1410     url text NOT NULL,
1411     summary text NOT NULL,
1412     description text NOT NULL,
1413     size bigint NOT NULL,
1414     supported_arches text,
1415     uuid text NOT NULL,
1416     commit_id integer,
1417     build_id text NOT NULL,
1418     build_host text NOT NULL,
1419     build_time timestamp without time zone NOT NULL,
1420     path text NOT NULL,
1421     filesize bigint NOT NULL,
1422     hash_sha512 text NOT NULL
1423 );
1424
1425
1426 ALTER TABLE packages OWNER TO pakfire;
1427
1428 --
1429 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1430 --
1431
1432 CREATE TABLE packages_deps (
1433     pkg_id integer NOT NULL,
1434     type packages_deps_type NOT NULL,
1435     what text NOT NULL
1436 );
1437
1438
1439 ALTER TABLE packages_deps OWNER TO pakfire;
1440
1441 --
1442 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1443 --
1444
1445 CREATE SEQUENCE packages_id_seq
1446     START WITH 1
1447     INCREMENT BY 1
1448     NO MINVALUE
1449     NO MAXVALUE
1450     CACHE 1;
1451
1452
1453 ALTER TABLE packages_id_seq OWNER TO pakfire;
1454
1455 --
1456 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1457 --
1458
1459 ALTER SEQUENCE packages_id_seq OWNED BY packages.id;
1460
1461
1462 --
1463 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1464 --
1465
1466 CREATE TABLE packages_properties (
1467     id integer NOT NULL,
1468     name text NOT NULL,
1469     critical_path boolean DEFAULT false NOT NULL,
1470     priority integer DEFAULT 0 NOT NULL
1471 );
1472
1473
1474 ALTER TABLE packages_properties OWNER TO pakfire;
1475
1476 --
1477 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1478 --
1479
1480 CREATE SEQUENCE packages_properties_id_seq
1481     START WITH 1
1482     INCREMENT BY 1
1483     NO MINVALUE
1484     NO MAXVALUE
1485     CACHE 1;
1486
1487
1488 ALTER TABLE packages_properties_id_seq OWNER TO pakfire;
1489
1490 --
1491 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1492 --
1493
1494 ALTER SEQUENCE packages_properties_id_seq OWNED BY packages_properties.id;
1495
1496
1497 --
1498 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1499 --
1500
1501 CREATE TABLE queue_delete (
1502     id integer NOT NULL,
1503     path text NOT NULL,
1504     not_before timestamp without time zone
1505 );
1506
1507
1508 ALTER TABLE queue_delete OWNER TO pakfire;
1509
1510 --
1511 -- Name: queue_delete_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1512 --
1513
1514 CREATE SEQUENCE queue_delete_id_seq
1515     START WITH 1
1516     INCREMENT BY 1
1517     NO MINVALUE
1518     NO MAXVALUE
1519     CACHE 1;
1520
1521
1522 ALTER TABLE queue_delete_id_seq OWNER TO pakfire;
1523
1524 --
1525 -- Name: queue_delete_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1526 --
1527
1528 ALTER SEQUENCE queue_delete_id_seq OWNED BY queue_delete.id;
1529
1530
1531 --
1532 -- Name: relation_sizes; Type: VIEW; Schema: public; Owner: pakfire
1533 --
1534
1535 CREATE VIEW relation_sizes AS
1536  SELECT c.relname AS relation,
1537     pg_size_pretty(pg_relation_size((c.oid)::regclass)) AS size
1538    FROM (pg_class c
1539      LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)))
1540   WHERE (n.nspname <> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name]))
1541   ORDER BY pg_relation_size((c.oid)::regclass) DESC;
1542
1543
1544 ALTER TABLE relation_sizes OWNER TO pakfire;
1545
1546 --
1547 -- Name: repositories; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1548 --
1549
1550 CREATE TABLE repositories (
1551     id integer NOT NULL,
1552     name text NOT NULL,
1553     type repositories_type DEFAULT 'testing'::repositories_type NOT NULL,
1554     description text NOT NULL,
1555     distro_id integer NOT NULL,
1556     parent_id integer,
1557     key_id integer,
1558     mirrored boolean DEFAULT false NOT NULL,
1559     enabled_for_builds boolean DEFAULT false NOT NULL,
1560     score_needed integer DEFAULT 0 NOT NULL,
1561     last_update timestamp without time zone,
1562     time_min integer DEFAULT 0 NOT NULL,
1563     time_max integer DEFAULT 0 NOT NULL,
1564     deleted boolean DEFAULT false NOT NULL,
1565     priority integer,
1566     user_id integer,
1567     update_forced boolean DEFAULT false NOT NULL
1568 );
1569
1570
1571 ALTER TABLE repositories OWNER TO pakfire;
1572
1573 --
1574 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1575 --
1576
1577 CREATE TABLE repositories_aux (
1578     id integer NOT NULL,
1579     name text NOT NULL,
1580     description text,
1581     url text NOT NULL,
1582     distro_id integer NOT NULL,
1583     status repositories_aux_status DEFAULT 'disabled'::repositories_aux_status NOT NULL
1584 );
1585
1586
1587 ALTER TABLE repositories_aux OWNER TO pakfire;
1588
1589 --
1590 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1591 --
1592
1593 CREATE SEQUENCE repositories_aux_id_seq
1594     START WITH 1
1595     INCREMENT BY 1
1596     NO MINVALUE
1597     NO MAXVALUE
1598     CACHE 1;
1599
1600
1601 ALTER TABLE repositories_aux_id_seq OWNER TO pakfire;
1602
1603 --
1604 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1605 --
1606
1607 ALTER SEQUENCE repositories_aux_id_seq OWNED BY repositories_aux.id;
1608
1609
1610 --
1611 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1612 --
1613
1614 CREATE TABLE repositories_builds (
1615     id integer NOT NULL,
1616     repo_id integer NOT NULL,
1617     build_id bigint NOT NULL,
1618     time_added timestamp without time zone NOT NULL
1619 );
1620
1621
1622 ALTER TABLE repositories_builds OWNER TO pakfire;
1623
1624 --
1625 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1626 --
1627
1628 CREATE SEQUENCE repositories_builds_id_seq
1629     START WITH 1
1630     INCREMENT BY 1
1631     NO MINVALUE
1632     NO MAXVALUE
1633     CACHE 1;
1634
1635
1636 ALTER TABLE repositories_builds_id_seq OWNER TO pakfire;
1637
1638 --
1639 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1640 --
1641
1642 ALTER SEQUENCE repositories_builds_id_seq OWNED BY repositories_builds.id;
1643
1644
1645 --
1646 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1647 --
1648
1649 CREATE TABLE repositories_history (
1650     build_id bigint NOT NULL,
1651     action repositories_history_action NOT NULL,
1652     from_repo_id integer,
1653     to_repo_id integer,
1654     user_id integer,
1655     "time" timestamp without time zone NOT NULL
1656 );
1657
1658
1659 ALTER TABLE repositories_history OWNER TO pakfire;
1660
1661 --
1662 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1663 --
1664
1665 CREATE SEQUENCE repositories_id_seq
1666     START WITH 1
1667     INCREMENT BY 1
1668     NO MINVALUE
1669     NO MAXVALUE
1670     CACHE 1;
1671
1672
1673 ALTER TABLE repositories_id_seq OWNER TO pakfire;
1674
1675 --
1676 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1677 --
1678
1679 ALTER SEQUENCE repositories_id_seq OWNED BY repositories.id;
1680
1681
1682 --
1683 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1684 --
1685
1686 CREATE TABLE sessions (
1687     id integer NOT NULL,
1688     session_id text NOT NULL,
1689     created_at timestamp without time zone DEFAULT now() NOT NULL,
1690     valid_until timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1691     user_id integer NOT NULL,
1692     impersonated_user_id integer,
1693     address inet,
1694     user_agent text,
1695     CONSTRAINT sessions_impersonation_check CHECK (((impersonated_user_id IS NULL) OR (user_id <> impersonated_user_id)))
1696 );
1697
1698
1699 ALTER TABLE sessions OWNER TO pakfire;
1700
1701 --
1702 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1703 --
1704
1705 CREATE SEQUENCE sessions_id_seq
1706     START WITH 1
1707     INCREMENT BY 1
1708     NO MINVALUE
1709     NO MAXVALUE
1710     CACHE 1;
1711
1712
1713 ALTER TABLE sessions_id_seq OWNER TO pakfire;
1714
1715 --
1716 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1717 --
1718
1719 ALTER SEQUENCE sessions_id_seq OWNED BY sessions.id;
1720
1721
1722 --
1723 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1724 --
1725
1726 CREATE TABLE settings (
1727     k text NOT NULL,
1728     v text NOT NULL
1729 );
1730
1731
1732 ALTER TABLE settings OWNER TO pakfire;
1733
1734 --
1735 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1736 --
1737
1738 CREATE TABLE sources (
1739     id integer NOT NULL,
1740     name text NOT NULL,
1741     identifier text NOT NULL,
1742     url text NOT NULL,
1743     gitweb text,
1744     revision text NOT NULL,
1745     branch text NOT NULL,
1746     updated timestamp without time zone,
1747     distro_id integer NOT NULL
1748 );
1749
1750
1751 ALTER TABLE sources OWNER TO pakfire;
1752
1753 --
1754 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1755 --
1756
1757 CREATE TABLE sources_commits (
1758     id integer NOT NULL,
1759     source_id integer NOT NULL,
1760     revision text NOT NULL,
1761     author text NOT NULL,
1762     committer text NOT NULL,
1763     subject text NOT NULL,
1764     body text NOT NULL,
1765     date timestamp without time zone NOT NULL,
1766     state sources_commits_state DEFAULT 'pending'::sources_commits_state NOT NULL,
1767     imported_at timestamp without time zone DEFAULT now() NOT NULL
1768 );
1769
1770
1771 ALTER TABLE sources_commits OWNER TO pakfire;
1772
1773 --
1774 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1775 --
1776
1777 CREATE SEQUENCE sources_commits_id_seq
1778     START WITH 1
1779     INCREMENT BY 1
1780     NO MINVALUE
1781     NO MAXVALUE
1782     CACHE 1;
1783
1784
1785 ALTER TABLE sources_commits_id_seq OWNER TO pakfire;
1786
1787 --
1788 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1789 --
1790
1791 ALTER SEQUENCE sources_commits_id_seq OWNED BY sources_commits.id;
1792
1793
1794 --
1795 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1796 --
1797
1798 CREATE SEQUENCE sources_id_seq
1799     START WITH 1
1800     INCREMENT BY 1
1801     NO MINVALUE
1802     NO MAXVALUE
1803     CACHE 1;
1804
1805
1806 ALTER TABLE sources_id_seq OWNER TO pakfire;
1807
1808 --
1809 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1810 --
1811
1812 ALTER SEQUENCE sources_id_seq OWNED BY sources.id;
1813
1814
1815 --
1816 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1817 --
1818
1819 CREATE TABLE uploads (
1820     id integer NOT NULL,
1821     uuid text NOT NULL,
1822     user_id integer,
1823     builder_id integer,
1824     filename text NOT NULL,
1825     hash text NOT NULL,
1826     size bigint NOT NULL,
1827     progress bigint DEFAULT 0 NOT NULL,
1828     finished boolean DEFAULT false NOT NULL,
1829     time_started timestamp without time zone DEFAULT now() NOT NULL,
1830     time_finished timestamp without time zone
1831 );
1832
1833
1834 ALTER TABLE uploads OWNER TO pakfire;
1835
1836 --
1837 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1838 --
1839
1840 CREATE SEQUENCE uploads_id_seq
1841     START WITH 1
1842     INCREMENT BY 1
1843     NO MINVALUE
1844     NO MAXVALUE
1845     CACHE 1;
1846
1847
1848 ALTER TABLE uploads_id_seq OWNER TO pakfire;
1849
1850 --
1851 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1852 --
1853
1854 ALTER SEQUENCE uploads_id_seq OWNED BY uploads.id;
1855
1856
1857 --
1858 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1859 --
1860
1861 CREATE TABLE user_messages (
1862     id integer NOT NULL,
1863     frm text NOT NULL,
1864     "to" text NOT NULL,
1865     subject text NOT NULL,
1866     text text NOT NULL,
1867     time_added timestamp without time zone DEFAULT now() NOT NULL
1868 );
1869
1870
1871 ALTER TABLE user_messages OWNER TO pakfire;
1872
1873 --
1874 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1875 --
1876
1877 CREATE SEQUENCE user_messages_id_seq
1878     START WITH 1
1879     INCREMENT BY 1
1880     NO MINVALUE
1881     NO MAXVALUE
1882     CACHE 1;
1883
1884
1885 ALTER TABLE user_messages_id_seq OWNER TO pakfire;
1886
1887 --
1888 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1889 --
1890
1891 ALTER SEQUENCE user_messages_id_seq OWNED BY user_messages.id;
1892
1893
1894 --
1895 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1896 --
1897
1898 CREATE TABLE users (
1899     id integer NOT NULL,
1900     name text NOT NULL,
1901     realname text,
1902     passphrase text NOT NULL,
1903     state users_state NOT NULL,
1904     locale text,
1905     timezone text,
1906     activated users_activated DEFAULT 'N'::users_activated NOT NULL,
1907     activation_code text,
1908     deleted users_deleted DEFAULT 'N'::users_deleted NOT NULL,
1909     registered timestamp without time zone DEFAULT now() NOT NULL
1910 );
1911
1912
1913 ALTER TABLE users OWNER TO pakfire;
1914
1915 --
1916 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1917 --
1918
1919 CREATE TABLE users_emails (
1920     id integer NOT NULL,
1921     user_id integer NOT NULL,
1922     email text NOT NULL,
1923     "primary" users_emails_primary DEFAULT 'N'::users_emails_primary NOT NULL
1924 );
1925
1926
1927 ALTER TABLE users_emails OWNER TO pakfire;
1928
1929 --
1930 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1931 --
1932
1933 CREATE SEQUENCE users_emails_id_seq
1934     START WITH 1
1935     INCREMENT BY 1
1936     NO MINVALUE
1937     NO MAXVALUE
1938     CACHE 1;
1939
1940
1941 ALTER TABLE users_emails_id_seq OWNER TO pakfire;
1942
1943 --
1944 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1945 --
1946
1947 ALTER SEQUENCE users_emails_id_seq OWNED BY users_emails.id;
1948
1949
1950 --
1951 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1952 --
1953
1954 CREATE SEQUENCE users_id_seq
1955     START WITH 1
1956     INCREMENT BY 1
1957     NO MINVALUE
1958     NO MAXVALUE
1959     CACHE 1;
1960
1961
1962 ALTER TABLE users_id_seq OWNER TO pakfire;
1963
1964 --
1965 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1966 --
1967
1968 ALTER SEQUENCE users_id_seq OWNED BY users.id;
1969
1970
1971 --
1972 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1973 --
1974
1975 CREATE TABLE users_permissions (
1976     id integer NOT NULL,
1977     user_id integer NOT NULL,
1978     create_scratch_builds users_permissions_create_scratch_builds DEFAULT 'N'::users_permissions_create_scratch_builds NOT NULL,
1979     maintain_builders users_permissions_maintain_builders DEFAULT 'N'::users_permissions_maintain_builders NOT NULL,
1980     manage_critical_path users_permissions_manage_critical_path DEFAULT 'N'::users_permissions_manage_critical_path NOT NULL,
1981     manage_mirrors users_permissions_manage_mirrors DEFAULT 'N'::users_permissions_manage_mirrors NOT NULL,
1982     vote users_permissions_vote DEFAULT 'N'::users_permissions_vote NOT NULL
1983 );
1984
1985
1986 ALTER TABLE users_permissions OWNER TO pakfire;
1987
1988 --
1989 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1990 --
1991
1992 CREATE SEQUENCE users_permissions_id_seq
1993     START WITH 1
1994     INCREMENT BY 1
1995     NO MINVALUE
1996     NO MAXVALUE
1997     CACHE 1;
1998
1999
2000 ALTER TABLE users_permissions_id_seq OWNER TO pakfire;
2001
2002 --
2003 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2004 --
2005
2006 ALTER SEQUENCE users_permissions_id_seq OWNED BY users_permissions.id;
2007
2008
2009 --
2010 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2011 --
2012
2013 ALTER TABLE ONLY arches ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
2014
2015
2016 --
2017 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2018 --
2019
2020 ALTER TABLE ONLY builders ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
2021
2022
2023 --
2024 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2025 --
2026
2027 ALTER TABLE ONLY builders_history ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
2028
2029
2030 --
2031 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2032 --
2033
2034 ALTER TABLE ONLY builds ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
2035
2036
2037 --
2038 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2039 --
2040
2041 ALTER TABLE ONLY builds_bugs ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
2042
2043
2044 --
2045 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2046 --
2047
2048 ALTER TABLE ONLY builds_bugs_updates ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
2049
2050
2051 --
2052 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2053 --
2054
2055 ALTER TABLE ONLY builds_comments ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
2056
2057
2058 --
2059 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2060 --
2061
2062 ALTER TABLE ONLY builds_history ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
2063
2064
2065 --
2066 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2067 --
2068
2069 ALTER TABLE ONLY builds_watchers ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
2070
2071
2072 --
2073 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2074 --
2075
2076 ALTER TABLE ONLY distributions ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
2077
2078
2079 --
2080 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2081 --
2082
2083 ALTER TABLE ONLY distributions_arches ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
2084
2085
2086 --
2087 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2088 --
2089
2090 ALTER TABLE ONLY images_types ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
2091
2092
2093 --
2094 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2095 --
2096
2097 ALTER TABLE ONLY jobs ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
2098
2099
2100 --
2101 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2102 --
2103
2104 ALTER TABLE ONLY jobs_packages ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
2105
2106
2107 --
2108 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2109 --
2110
2111 ALTER TABLE ONLY keys ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
2112
2113
2114 --
2115 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2116 --
2117
2118 ALTER TABLE ONLY keys_subkeys ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
2119
2120
2121 --
2122 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2123 --
2124
2125 ALTER TABLE ONLY logfiles ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
2126
2127
2128 --
2129 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2130 --
2131
2132 ALTER TABLE ONLY mirrors ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
2133
2134
2135 --
2136 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2137 --
2138
2139 ALTER TABLE ONLY mirrors_checks ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
2140
2141
2142 --
2143 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2144 --
2145
2146 ALTER TABLE ONLY mirrors_history ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
2147
2148
2149 --
2150 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2151 --
2152
2153 ALTER TABLE ONLY packages ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
2154
2155
2156 --
2157 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2158 --
2159
2160 ALTER TABLE ONLY packages_properties ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
2161
2162
2163 --
2164 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2165 --
2166
2167 ALTER TABLE ONLY queue_delete ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
2168
2169
2170 --
2171 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2172 --
2173
2174 ALTER TABLE ONLY repositories ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
2175
2176
2177 --
2178 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2179 --
2180
2181 ALTER TABLE ONLY repositories_aux ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
2182
2183
2184 --
2185 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2186 --
2187
2188 ALTER TABLE ONLY repositories_builds ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
2189
2190
2191 --
2192 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2193 --
2194
2195 ALTER TABLE ONLY sessions ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
2196
2197
2198 --
2199 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2200 --
2201
2202 ALTER TABLE ONLY sources ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
2203
2204
2205 --
2206 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2207 --
2208
2209 ALTER TABLE ONLY sources_commits ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
2210
2211
2212 --
2213 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2214 --
2215
2216 ALTER TABLE ONLY uploads ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
2217
2218
2219 --
2220 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2221 --
2222
2223 ALTER TABLE ONLY user_messages ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
2224
2225
2226 --
2227 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2228 --
2229
2230 ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
2231
2232
2233 --
2234 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2235 --
2236
2237 ALTER TABLE ONLY users_emails ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
2238
2239
2240 --
2241 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2242 --
2243
2244 ALTER TABLE ONLY users_permissions ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
2245
2246
2247 --
2248 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2249 --
2250
2251 ALTER TABLE ONLY arches_compat
2252     ADD CONSTRAINT arches_compat_unique UNIQUE (native_arch, build_arch);
2253
2254
2255 --
2256 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2257 --
2258
2259 ALTER TABLE ONLY arches
2260     ADD CONSTRAINT arches_name UNIQUE (name);
2261
2262
2263 --
2264 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2265 --
2266
2267 ALTER TABLE ONLY arches
2268     ADD CONSTRAINT idx_2197943_primary PRIMARY KEY (id);
2269
2270
2271 --
2272 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2273 --
2274
2275 ALTER TABLE ONLY builders
2276     ADD CONSTRAINT idx_2197954_primary PRIMARY KEY (id);
2277
2278
2279 --
2280 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2281 --
2282
2283 ALTER TABLE ONLY builders_history
2284     ADD CONSTRAINT idx_2197982_primary PRIMARY KEY (id);
2285
2286
2287 --
2288 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2289 --
2290
2291 ALTER TABLE ONLY builds
2292     ADD CONSTRAINT idx_2197988_primary PRIMARY KEY (id);
2293
2294
2295 --
2296 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2297 --
2298
2299 ALTER TABLE ONLY builds_bugs
2300     ADD CONSTRAINT idx_2198002_primary PRIMARY KEY (id);
2301
2302
2303 --
2304 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2305 --
2306
2307 ALTER TABLE ONLY builds_bugs_updates
2308     ADD CONSTRAINT idx_2198008_primary PRIMARY KEY (id);
2309
2310
2311 --
2312 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2313 --
2314
2315 ALTER TABLE ONLY builds_comments
2316     ADD CONSTRAINT idx_2198018_primary PRIMARY KEY (id);
2317
2318
2319 --
2320 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2321 --
2322
2323 ALTER TABLE ONLY builds_history
2324     ADD CONSTRAINT idx_2198027_primary PRIMARY KEY (id);
2325
2326
2327 --
2328 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2329 --
2330
2331 ALTER TABLE ONLY builds_watchers
2332     ADD CONSTRAINT idx_2198033_primary PRIMARY KEY (id);
2333
2334
2335 --
2336 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2337 --
2338
2339 ALTER TABLE ONLY distributions
2340     ADD CONSTRAINT idx_2198039_primary PRIMARY KEY (id);
2341
2342
2343 --
2344 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2345 --
2346
2347 ALTER TABLE ONLY distributions_arches
2348     ADD CONSTRAINT idx_2198048_primary PRIMARY KEY (id);
2349
2350
2351 --
2352 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2353 --
2354
2355 ALTER TABLE ONLY images_types
2356     ADD CONSTRAINT idx_2198057_primary PRIMARY KEY (id);
2357
2358
2359 --
2360 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2361 --
2362
2363 ALTER TABLE ONLY jobs
2364     ADD CONSTRAINT idx_2198063_primary PRIMARY KEY (id);
2365
2366
2367 --
2368 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2369 --
2370
2371 ALTER TABLE ONLY jobs_packages
2372     ADD CONSTRAINT idx_2198085_primary PRIMARY KEY (id);
2373
2374
2375 --
2376 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2377 --
2378
2379 ALTER TABLE ONLY keys
2380     ADD CONSTRAINT idx_2198094_primary PRIMARY KEY (id);
2381
2382
2383 --
2384 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2385 --
2386
2387 ALTER TABLE ONLY keys_subkeys
2388     ADD CONSTRAINT idx_2198103_primary PRIMARY KEY (id);
2389
2390
2391 --
2392 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2393 --
2394
2395 ALTER TABLE ONLY logfiles
2396     ADD CONSTRAINT idx_2198109_primary PRIMARY KEY (id);
2397
2398
2399 --
2400 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2401 --
2402
2403 ALTER TABLE ONLY mirrors
2404     ADD CONSTRAINT idx_2198115_primary PRIMARY KEY (id);
2405
2406
2407 --
2408 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2409 --
2410
2411 ALTER TABLE ONLY mirrors_history
2412     ADD CONSTRAINT idx_2198126_primary PRIMARY KEY (id);
2413
2414
2415 --
2416 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2417 --
2418
2419 ALTER TABLE ONLY packages
2420     ADD CONSTRAINT idx_2198132_primary PRIMARY KEY (id);
2421
2422
2423 --
2424 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2425 --
2426
2427 ALTER TABLE ONLY packages_properties
2428     ADD CONSTRAINT idx_2198147_primary PRIMARY KEY (id);
2429
2430
2431 --
2432 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2433 --
2434
2435 ALTER TABLE ONLY queue_delete
2436     ADD CONSTRAINT idx_2198155_primary PRIMARY KEY (id);
2437
2438
2439 --
2440 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2441 --
2442
2443 ALTER TABLE ONLY repositories
2444     ADD CONSTRAINT idx_2198164_primary PRIMARY KEY (id);
2445
2446
2447 --
2448 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2449 --
2450
2451 ALTER TABLE ONLY repositories_aux
2452     ADD CONSTRAINT idx_2198179_primary PRIMARY KEY (id);
2453
2454
2455 --
2456 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2457 --
2458
2459 ALTER TABLE ONLY repositories_builds
2460     ADD CONSTRAINT idx_2198189_primary PRIMARY KEY (id);
2461
2462
2463 --
2464 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2465 --
2466
2467 ALTER TABLE ONLY sources
2468     ADD CONSTRAINT idx_2198213_primary PRIMARY KEY (id);
2469
2470
2471 --
2472 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2473 --
2474
2475 ALTER TABLE ONLY sources_commits
2476     ADD CONSTRAINT idx_2198222_primary PRIMARY KEY (id);
2477
2478
2479 --
2480 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2481 --
2482
2483 ALTER TABLE ONLY uploads
2484     ADD CONSTRAINT idx_2198232_primary PRIMARY KEY (id);
2485
2486
2487 --
2488 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2489 --
2490
2491 ALTER TABLE ONLY users
2492     ADD CONSTRAINT idx_2198244_primary PRIMARY KEY (id);
2493
2494
2495 --
2496 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2497 --
2498
2499 ALTER TABLE ONLY users_emails
2500     ADD CONSTRAINT idx_2198256_primary PRIMARY KEY (id);
2501
2502
2503 --
2504 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2505 --
2506
2507 ALTER TABLE ONLY users_permissions
2508     ADD CONSTRAINT idx_2198263_primary PRIMARY KEY (id);
2509
2510
2511 --
2512 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2513 --
2514
2515 ALTER TABLE ONLY user_messages
2516     ADD CONSTRAINT idx_2198274_primary PRIMARY KEY (id);
2517
2518
2519 --
2520 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2521 --
2522
2523 ALTER TABLE ONLY jobs_packages
2524     ADD CONSTRAINT jobs_packages_unique UNIQUE (job_id, pkg_id);
2525
2526
2527 --
2528 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2529 --
2530
2531 ALTER TABLE ONLY mirrors_checks
2532     ADD CONSTRAINT mirrors_checks_pkey PRIMARY KEY (id);
2533
2534
2535 --
2536 -- Name: repositories_builds_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2537 --
2538
2539 ALTER TABLE ONLY repositories_builds
2540     ADD CONSTRAINT repositories_builds_unique UNIQUE (repo_id, build_id);
2541
2542
2543 --
2544 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2545 --
2546
2547 ALTER TABLE ONLY sessions
2548     ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);
2549
2550
2551 --
2552 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2553 --
2554
2555 ALTER TABLE ONLY sessions
2556     ADD CONSTRAINT sessions_session_id_key UNIQUE (session_id);
2557
2558
2559 --
2560 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2561 --
2562
2563 CREATE INDEX arches_compat_native_arch ON arches_compat USING btree (native_arch);
2564
2565
2566 --
2567 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2568 --
2569
2570 CREATE UNIQUE INDEX builders_name ON builders USING btree (name) WHERE (deleted IS FALSE);
2571
2572
2573 --
2574 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2575 --
2576
2577 CREATE INDEX builds_watchers_build_id ON builds_watchers USING btree (build_id);
2578
2579
2580 --
2581 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2582 --
2583
2584 CREATE INDEX distributions_arches_distro_id ON distributions_arches USING btree (distro_id);
2585
2586
2587 --
2588 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2589 --
2590
2591 CREATE UNIQUE INDEX distributions_sname ON distributions USING btree (sname) WHERE (deleted IS FALSE);
2592
2593
2594 --
2595 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2596 --
2597
2598 CREATE INDEX filelists_name ON filelists USING btree (name);
2599
2600
2601 --
2602 -- Name: filelists_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2603 --
2604
2605 CREATE INDEX filelists_pkg_id ON filelists USING btree (pkg_id);
2606
2607 ALTER TABLE filelists CLUSTER ON filelists_pkg_id;
2608
2609
2610 --
2611 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2612 --
2613
2614 CREATE INDEX idx_2197982_builder_id ON builders_history USING btree (builder_id);
2615
2616
2617 --
2618 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2619 --
2620
2621 CREATE INDEX idx_2197988_pkg_id ON builds USING btree (pkg_id);
2622
2623
2624 --
2625 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2626 --
2627
2628 CREATE INDEX idx_2197988_state ON builds USING btree (state);
2629
2630
2631 --
2632 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2633 --
2634
2635 CREATE INDEX idx_2197988_type ON builds USING btree (type);
2636
2637
2638 --
2639 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2640 --
2641
2642 CREATE UNIQUE INDEX idx_2197988_uuid ON builds USING btree (uuid);
2643
2644
2645 --
2646 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2647 --
2648
2649 CREATE UNIQUE INDEX idx_2198002_build_id ON builds_bugs USING btree (build_id, bug_id);
2650
2651
2652 --
2653 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2654 --
2655
2656 CREATE INDEX idx_2198018_build_id ON builds_comments USING btree (build_id);
2657
2658
2659 --
2660 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2661 --
2662
2663 CREATE INDEX idx_2198018_user_id ON builds_comments USING btree (user_id);
2664
2665
2666 --
2667 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2668 --
2669
2670 CREATE INDEX idx_2198063_build_id ON jobs USING btree (build_id);
2671
2672
2673 --
2674 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2675 --
2676
2677 CREATE INDEX idx_2198063_state ON jobs USING btree (state);
2678
2679
2680 --
2681 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2682 --
2683
2684 CREATE INDEX idx_2198063_time_finished ON jobs USING btree (time_finished);
2685
2686
2687 --
2688 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2689 --
2690
2691 CREATE UNIQUE INDEX idx_2198063_uuid ON jobs USING btree (uuid);
2692
2693
2694 --
2695 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2696 --
2697
2698 CREATE INDEX idx_2198080_job_id ON jobs_history USING btree (job_id);
2699
2700
2701 --
2702 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2703 --
2704
2705 CREATE UNIQUE INDEX idx_2198089_job_id ON jobs_repos USING btree (job_id, repo_id);
2706
2707
2708 --
2709 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2710 --
2711
2712 CREATE UNIQUE INDEX idx_2198094_fingerprint ON keys USING btree (fingerprint);
2713
2714
2715 --
2716 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2717 --
2718
2719 CREATE INDEX idx_2198132_name ON packages USING btree (name);
2720
2721
2722 --
2723 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2724 --
2725
2726 CREATE INDEX idx_2198132_type ON packages USING btree (type);
2727
2728
2729 --
2730 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2731 --
2732
2733 CREATE INDEX idx_2198132_uuid ON packages USING btree (uuid);
2734
2735
2736 --
2737 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2738 --
2739
2740 CREATE INDEX idx_2198139_pkg_id ON packages_deps USING btree (pkg_id);
2741
2742
2743 --
2744 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2745 --
2746
2747 CREATE UNIQUE INDEX idx_2198147_name ON packages_properties USING btree (name);
2748
2749
2750 --
2751 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2752 --
2753
2754 CREATE UNIQUE INDEX idx_2198189_build_id ON repositories_builds USING btree (build_id);
2755
2756
2757 --
2758 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2759 --
2760
2761 CREATE INDEX idx_2198193_build_id ON repositories_history USING btree (build_id);
2762
2763
2764 --
2765 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2766 --
2767
2768 CREATE UNIQUE INDEX idx_2198199_k ON settings USING btree (k);
2769
2770
2771 --
2772 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2773 --
2774
2775 CREATE UNIQUE INDEX idx_2198213_identifier ON sources USING btree (identifier);
2776
2777
2778 --
2779 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2780 --
2781
2782 CREATE INDEX idx_2198222_revision ON sources_commits USING btree (revision);
2783
2784
2785 --
2786 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2787 --
2788
2789 CREATE UNIQUE INDEX idx_2198232_uuid ON uploads USING btree (uuid);
2790
2791
2792 --
2793 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2794 --
2795
2796 CREATE UNIQUE INDEX idx_2198244_name ON users USING btree (name);
2797
2798
2799 --
2800 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2801 --
2802
2803 CREATE UNIQUE INDEX idx_2198256_email ON users_emails USING btree (email);
2804
2805
2806 --
2807 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2808 --
2809
2810 CREATE INDEX idx_2198256_user_id ON users_emails USING btree (user_id);
2811
2812
2813 --
2814 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2815 --
2816
2817 CREATE INDEX jobs_arch ON jobs USING btree (arch);
2818
2819
2820 --
2821 -- Name: jobs_buildroots_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2822 --
2823
2824 CREATE INDEX jobs_buildroots_job_id ON jobs_buildroots USING btree (job_id);
2825
2826 ALTER TABLE jobs_buildroots CLUSTER ON jobs_buildroots_job_id;
2827
2828
2829 --
2830 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2831 --
2832
2833 CREATE INDEX jobs_buildroots_pkg_uuid ON jobs_buildroots USING btree (pkg_uuid);
2834
2835
2836 --
2837 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2838 --
2839
2840 CREATE INDEX mirrors_checks_sort ON mirrors_checks USING btree (mirror_id, "timestamp");
2841
2842 ALTER TABLE mirrors_checks CLUSTER ON mirrors_checks_sort;
2843
2844
2845 --
2846 -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2847 --
2848
2849 CREATE INDEX repositories_builds_repo_id ON repositories_builds USING btree (repo_id);
2850
2851
2852 --
2853 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
2854 --
2855
2856 CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON sources FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
2857
2858
2859 --
2860 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2861 --
2862
2863 ALTER TABLE ONLY arches_compat
2864     ADD CONSTRAINT arches_compat_build_arch FOREIGN KEY (build_arch) REFERENCES arches(name);
2865
2866
2867 --
2868 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2869 --
2870
2871 ALTER TABLE ONLY builders_history
2872     ADD CONSTRAINT builders_history_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
2873
2874
2875 --
2876 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2877 --
2878
2879 ALTER TABLE ONLY builders_history
2880     ADD CONSTRAINT builders_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2881
2882
2883 --
2884 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2885 --
2886
2887 ALTER TABLE ONLY builds_bugs
2888     ADD CONSTRAINT builds_bug_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2889
2890
2891 --
2892 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2893 --
2894
2895 ALTER TABLE ONLY builds_comments
2896     ADD CONSTRAINT builds_comments_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2897
2898
2899 --
2900 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2901 --
2902
2903 ALTER TABLE ONLY builds_comments
2904     ADD CONSTRAINT builds_comments_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2905
2906
2907 --
2908 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2909 --
2910
2911 ALTER TABLE ONLY builds
2912     ADD CONSTRAINT builds_depends_on FOREIGN KEY (depends_on) REFERENCES builds(id);
2913
2914
2915 --
2916 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2917 --
2918
2919 ALTER TABLE ONLY builds
2920     ADD CONSTRAINT builds_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
2921
2922
2923 --
2924 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2925 --
2926
2927 ALTER TABLE ONLY builds_history
2928     ADD CONSTRAINT builds_history_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2929
2930
2931 --
2932 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2933 --
2934
2935 ALTER TABLE ONLY builds_history
2936     ADD CONSTRAINT builds_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2937
2938
2939 --
2940 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2941 --
2942
2943 ALTER TABLE ONLY builds
2944     ADD CONSTRAINT builds_owner_id FOREIGN KEY (owner_id) REFERENCES users(id);
2945
2946
2947 --
2948 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2949 --
2950
2951 ALTER TABLE ONLY builds
2952     ADD CONSTRAINT builds_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
2953
2954
2955 --
2956 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2957 --
2958
2959 ALTER TABLE ONLY builds_watchers
2960     ADD CONSTRAINT builds_watchers_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2961
2962
2963 --
2964 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2965 --
2966
2967 ALTER TABLE ONLY builds_watchers
2968     ADD CONSTRAINT builds_watchers_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2969
2970
2971 --
2972 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2973 --
2974
2975 ALTER TABLE ONLY distributions_arches
2976     ADD CONSTRAINT distributions_arches_arch FOREIGN KEY (arch) REFERENCES arches(name);
2977
2978
2979 --
2980 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2981 --
2982
2983 ALTER TABLE ONLY distributions_arches
2984     ADD CONSTRAINT distro_arches_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
2985
2986
2987 --
2988 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2989 --
2990
2991 ALTER TABLE ONLY filelists
2992     ADD CONSTRAINT filelists_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
2993
2994
2995 --
2996 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2997 --
2998
2999 ALTER TABLE ONLY jobs
3000     ADD CONSTRAINT jobs_arch FOREIGN KEY (arch) REFERENCES arches(name);
3001
3002
3003 --
3004 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3005 --
3006
3007 ALTER TABLE ONLY jobs
3008     ADD CONSTRAINT jobs_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3009
3010
3011 --
3012 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3013 --
3014
3015 ALTER TABLE ONLY jobs
3016     ADD CONSTRAINT jobs_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3017
3018
3019 --
3020 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3021 --
3022
3023 ALTER TABLE ONLY jobs_buildroots
3024     ADD CONSTRAINT jobs_buildroots_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3025
3026
3027 --
3028 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3029 --
3030
3031 ALTER TABLE ONLY jobs_history
3032     ADD CONSTRAINT jobs_history_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3033
3034
3035 --
3036 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3037 --
3038
3039 ALTER TABLE ONLY jobs_history
3040     ADD CONSTRAINT jobs_history_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3041
3042
3043 --
3044 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3045 --
3046
3047 ALTER TABLE ONLY jobs_history
3048     ADD CONSTRAINT jobs_history_test_job_id FOREIGN KEY (test_job_id) REFERENCES jobs(id);
3049
3050
3051 --
3052 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3053 --
3054
3055 ALTER TABLE ONLY jobs_history
3056     ADD CONSTRAINT jobs_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3057
3058
3059 --
3060 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3061 --
3062
3063 ALTER TABLE ONLY jobs_packages
3064     ADD CONSTRAINT jobs_packaged_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3065
3066
3067 --
3068 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3069 --
3070
3071 ALTER TABLE ONLY jobs_packages
3072     ADD CONSTRAINT jobs_packages_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3073
3074
3075 --
3076 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3077 --
3078
3079 ALTER TABLE ONLY jobs_repos
3080     ADD CONSTRAINT jobs_repos_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3081
3082
3083 --
3084 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3085 --
3086
3087 ALTER TABLE ONLY jobs_repos
3088     ADD CONSTRAINT jobs_repos_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
3089
3090
3091 --
3092 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3093 --
3094
3095 ALTER TABLE ONLY keys_subkeys
3096     ADD CONSTRAINT keys_subkeys_key_id FOREIGN KEY (key_id) REFERENCES keys(id);
3097
3098
3099 --
3100 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3101 --
3102
3103 ALTER TABLE ONLY logfiles
3104     ADD CONSTRAINT logfiles_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3105
3106
3107 --
3108 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3109 --
3110
3111 ALTER TABLE ONLY mirrors_checks
3112     ADD CONSTRAINT mirrors_checks_mirror_id FOREIGN KEY (mirror_id) REFERENCES mirrors(id);
3113
3114
3115 --
3116 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3117 --
3118
3119 ALTER TABLE ONLY mirrors_history
3120     ADD CONSTRAINT mirrors_history_mirror_id FOREIGN KEY (mirror_id) REFERENCES mirrors(id);
3121
3122
3123 --
3124 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3125 --
3126
3127 ALTER TABLE ONLY mirrors_history
3128     ADD CONSTRAINT mirrors_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3129
3130
3131 --
3132 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3133 --
3134
3135 ALTER TABLE ONLY packages
3136     ADD CONSTRAINT packages_arch FOREIGN KEY (arch) REFERENCES arches(name);
3137
3138
3139 --
3140 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3141 --
3142
3143 ALTER TABLE ONLY packages
3144     ADD CONSTRAINT packages_commit_id FOREIGN KEY (commit_id) REFERENCES sources_commits(id);
3145
3146
3147 --
3148 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3149 --
3150
3151 ALTER TABLE ONLY packages_deps
3152     ADD CONSTRAINT packages_deps_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3153
3154
3155 --
3156 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3157 --
3158
3159 ALTER TABLE ONLY repositories_aux
3160     ADD CONSTRAINT repositories_aux_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3161
3162
3163 --
3164 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3165 --
3166
3167 ALTER TABLE ONLY repositories_builds
3168     ADD CONSTRAINT repositories_builds_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3169
3170
3171 --
3172 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3173 --
3174
3175 ALTER TABLE ONLY repositories_builds
3176     ADD CONSTRAINT repositories_builds_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
3177
3178
3179 --
3180 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3181 --
3182
3183 ALTER TABLE ONLY repositories
3184     ADD CONSTRAINT repositories_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3185
3186
3187 --
3188 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3189 --
3190
3191 ALTER TABLE ONLY repositories_history
3192     ADD CONSTRAINT repositories_history_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3193
3194
3195 --
3196 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3197 --
3198
3199 ALTER TABLE ONLY repositories_history
3200     ADD CONSTRAINT repositories_history_from_repo_id FOREIGN KEY (from_repo_id) REFERENCES repositories(id);
3201
3202
3203 --
3204 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3205 --
3206
3207 ALTER TABLE ONLY repositories_history
3208     ADD CONSTRAINT repositories_history_to_repo_id FOREIGN KEY (to_repo_id) REFERENCES repositories(id);
3209
3210
3211 --
3212 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3213 --
3214
3215 ALTER TABLE ONLY repositories_history
3216     ADD CONSTRAINT repositories_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3217
3218
3219 --
3220 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3221 --
3222
3223 ALTER TABLE ONLY repositories
3224     ADD CONSTRAINT repositories_key_id FOREIGN KEY (key_id) REFERENCES keys(id);
3225
3226
3227 --
3228 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3229 --
3230
3231 ALTER TABLE ONLY repositories
3232     ADD CONSTRAINT repositories_parent_id FOREIGN KEY (parent_id) REFERENCES repositories(id);
3233
3234
3235 --
3236 -- Name: repositories_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3237 --
3238
3239 ALTER TABLE ONLY repositories
3240     ADD CONSTRAINT repositories_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3241
3242
3243 --
3244 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3245 --
3246
3247 ALTER TABLE ONLY sessions
3248     ADD CONSTRAINT sessions_impersonated_user_id FOREIGN KEY (impersonated_user_id) REFERENCES users(id);
3249
3250
3251 --
3252 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3253 --
3254
3255 ALTER TABLE ONLY sessions
3256     ADD CONSTRAINT sessions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3257
3258
3259 --
3260 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3261 --
3262
3263 ALTER TABLE ONLY sources_commits
3264     ADD CONSTRAINT sources_commits_source_id FOREIGN KEY (source_id) REFERENCES sources(id);
3265
3266
3267 --
3268 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3269 --
3270
3271 ALTER TABLE ONLY sources
3272     ADD CONSTRAINT sources_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3273
3274
3275 --
3276 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3277 --
3278
3279 ALTER TABLE ONLY uploads
3280     ADD CONSTRAINT uploads_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3281
3282
3283 --
3284 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3285 --
3286
3287 ALTER TABLE ONLY uploads
3288     ADD CONSTRAINT uploads_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3289
3290
3291 --
3292 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3293 --
3294
3295 ALTER TABLE ONLY users_emails
3296     ADD CONSTRAINT users_emails_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3297
3298
3299 --
3300 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3301 --
3302
3303 ALTER TABLE ONLY users_permissions
3304     ADD CONSTRAINT users_permissions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3305
3306
3307 --
3308 -- PostgreSQL database dump complete
3309 --
3310