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     overload builders_overload DEFAULT 'N'::builders_overload NOT NULL,
 567     free_space bigint DEFAULT 0 NOT NULL,
 568     host_key_id text,
 569     time_created timestamp without time zone DEFAULT now() NOT NULL,
 570     time_updated timestamp without time zone,
 571     time_keepalive timestamp without time zone,
 572     loadavg1 double precision,
 573     loadavg5 double precision,
 574     loadavg15 double precision,
 575     mem_total bigint,
 576     mem_free bigint,
 577     swap_total bigint,
 578     swap_free bigint,
 579     space_free bigint
 580 );
 581
 582
 583 ALTER TABLE builders OWNER TO pakfire;
 584
 585 --
 586 -- Name: builders_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 587 --
 588
 589 CREATE TABLE builders_history (
 590     id integer NOT NULL,
 591     builder_id integer NOT NULL,
 592     action builders_history_action NOT NULL,
 593     user_id integer,
 594     "time" timestamp without time zone NOT NULL
 595 );
 596
 597
 598 ALTER TABLE builders_history OWNER TO pakfire;
 599
 600 --
 601 -- Name: builders_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 602 --
 603
 604 CREATE SEQUENCE builders_history_id_seq
 605     START WITH 1
 606     INCREMENT BY 1
 607     NO MINVALUE
 608     NO MAXVALUE
 609     CACHE 1;
 610
 611
 612 ALTER TABLE builders_history_id_seq OWNER TO pakfire;
 613
 614 --
 615 -- Name: builders_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 616 --
 617
 618 ALTER SEQUENCE builders_history_id_seq OWNED BY builders_history.id;
 619
 620
 621 --
 622 -- Name: builders_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 623 --
 624
 625 CREATE SEQUENCE builders_id_seq
 626     START WITH 1
 627     INCREMENT BY 1
 628     NO MINVALUE
 629     NO MAXVALUE
 630     CACHE 1;
 631
 632
 633 ALTER TABLE builders_id_seq OWNER TO pakfire;
 634
 635 --
 636 -- Name: builders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 637 --
 638
 639 ALTER SEQUENCE builders_id_seq OWNED BY builders.id;
 640
 641
 642 --
 643 -- Name: builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 644 --
 645
 646 CREATE TABLE builds (
 647     id integer NOT NULL,
 648     uuid text NOT NULL,
 649     pkg_id integer NOT NULL,
 650     type builds_type DEFAULT 'release'::builds_type NOT NULL,
 651     state text DEFAULT 'building'::text NOT NULL,
 652     severity builds_severity,
 653     message text,
 654     time_created timestamp without time zone DEFAULT now() NOT NULL,
 655     update_year integer,
 656     update_num integer,
 657     depends_on integer,
 658     distro_id integer NOT NULL,
 659     owner_id integer,
 660     priority integer DEFAULT 0 NOT NULL,
 661     auto_move boolean DEFAULT false NOT NULL
 662 );
 663
 664
 665 ALTER TABLE builds OWNER TO pakfire;
 666
 667 --
 668 -- Name: builds_bugs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 669 --
 670
 671 CREATE TABLE builds_bugs (
 672     id integer NOT NULL,
 673     build_id integer NOT NULL,
 674     bug_id integer NOT NULL
 675 );
 676
 677
 678 ALTER TABLE builds_bugs OWNER TO pakfire;
 679
 680 --
 681 -- Name: builds_bugs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 682 --
 683
 684 CREATE SEQUENCE builds_bugs_id_seq
 685     START WITH 1
 686     INCREMENT BY 1
 687     NO MINVALUE
 688     NO MAXVALUE
 689     CACHE 1;
 690
 691
 692 ALTER TABLE builds_bugs_id_seq OWNER TO pakfire;
 693
 694 --
 695 -- Name: builds_bugs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 696 --
 697
 698 ALTER SEQUENCE builds_bugs_id_seq OWNED BY builds_bugs.id;
 699
 700
 701 --
 702 -- Name: builds_bugs_updates; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 703 --
 704
 705 CREATE TABLE builds_bugs_updates (
 706     id integer NOT NULL,
 707     bug_id integer NOT NULL,
 708     status text,
 709     resolution text,
 710     comment text,
 711     "time" timestamp without time zone NOT NULL,
 712     error boolean DEFAULT false NOT NULL,
 713     error_msg text
 714 );
 715
 716
 717 ALTER TABLE builds_bugs_updates OWNER TO pakfire;
 718
 719 --
 720 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 721 --
 722
 723 CREATE SEQUENCE builds_bugs_updates_id_seq
 724     START WITH 1
 725     INCREMENT BY 1
 726     NO MINVALUE
 727     NO MAXVALUE
 728     CACHE 1;
 729
 730
 731 ALTER TABLE builds_bugs_updates_id_seq OWNER TO pakfire;
 732
 733 --
 734 -- Name: builds_bugs_updates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 735 --
 736
 737 ALTER SEQUENCE builds_bugs_updates_id_seq OWNED BY builds_bugs_updates.id;
 738
 739
 740 --
 741 -- Name: builds_comments; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 742 --
 743
 744 CREATE TABLE builds_comments (
 745     id integer NOT NULL,
 746     build_id integer NOT NULL,
 747     user_id integer NOT NULL,
 748     text text NOT NULL,
 749     score integer NOT NULL,
 750     time_created timestamp without time zone NOT NULL,
 751     time_updated timestamp without time zone
 752 );
 753
 754
 755 ALTER TABLE builds_comments OWNER TO pakfire;
 756
 757 --
 758 -- Name: builds_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 759 --
 760
 761 CREATE SEQUENCE builds_comments_id_seq
 762     START WITH 1
 763     INCREMENT BY 1
 764     NO MINVALUE
 765     NO MAXVALUE
 766     CACHE 1;
 767
 768
 769 ALTER TABLE builds_comments_id_seq OWNER TO pakfire;
 770
 771 --
 772 -- Name: builds_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 773 --
 774
 775 ALTER SEQUENCE builds_comments_id_seq OWNED BY builds_comments.id;
 776
 777
 778 --
 779 -- Name: builds_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 780 --
 781
 782 CREATE TABLE builds_history (
 783     id integer NOT NULL,
 784     build_id integer NOT NULL,
 785     action builds_history_action NOT NULL,
 786     user_id integer,
 787     "time" timestamp without time zone NOT NULL,
 788     bug_id integer
 789 );
 790
 791
 792 ALTER TABLE builds_history OWNER TO pakfire;
 793
 794 --
 795 -- Name: builds_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 796 --
 797
 798 CREATE SEQUENCE builds_history_id_seq
 799     START WITH 1
 800     INCREMENT BY 1
 801     NO MINVALUE
 802     NO MAXVALUE
 803     CACHE 1;
 804
 805
 806 ALTER TABLE builds_history_id_seq OWNER TO pakfire;
 807
 808 --
 809 -- Name: builds_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 810 --
 811
 812 ALTER SEQUENCE builds_history_id_seq OWNED BY builds_history.id;
 813
 814
 815 --
 816 -- Name: builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 817 --
 818
 819 CREATE SEQUENCE builds_id_seq
 820     START WITH 1
 821     INCREMENT BY 1
 822     NO MINVALUE
 823     NO MAXVALUE
 824     CACHE 1;
 825
 826
 827 ALTER TABLE builds_id_seq OWNER TO pakfire;
 828
 829 --
 830 -- Name: builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 831 --
 832
 833 ALTER SEQUENCE builds_id_seq OWNED BY builds.id;
 834
 835
 836 --
 837 -- Name: jobs; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 838 --
 839
 840 CREATE TABLE jobs (
 841     id integer NOT NULL,
 842     uuid text NOT NULL,
 843     build_id integer NOT NULL,
 844     state jobs_state DEFAULT 'new'::jobs_state NOT NULL,
 845     arch text NOT NULL,
 846     time_created timestamp without time zone DEFAULT now() NOT NULL,
 847     time_started timestamp without time zone,
 848     time_finished timestamp without time zone,
 849     start_not_before timestamp without time zone,
 850     builder_id integer,
 851     aborted_state integer DEFAULT 0 NOT NULL,
 852     message text,
 853     test boolean DEFAULT true NOT NULL,
 854     superseeded_by integer
 855 );
 856
 857
 858 ALTER TABLE jobs OWNER TO pakfire;
 859
 860 --
 861 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
 862 --
 863
 864 CREATE VIEW builds_times AS
 865  SELECT jobs.build_id,
 866     jobs.arch,
 867     (jobs.time_finished - jobs.time_started) AS duration
 868    FROM jobs
 869   WHERE ((jobs.test IS FALSE) AND (jobs.state = 'finished'::jobs_state));
 870
 871
 872 ALTER TABLE builds_times OWNER TO pakfire;
 873
 874 --
 875 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 876 --
 877
 878 CREATE TABLE builds_watchers (
 879     id integer NOT NULL,
 880     build_id integer NOT NULL,
 881     user_id integer NOT NULL
 882 );
 883
 884
 885 ALTER TABLE builds_watchers OWNER TO pakfire;
 886
 887 --
 888 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 889 --
 890
 891 CREATE SEQUENCE builds_watchers_id_seq
 892     START WITH 1
 893     INCREMENT BY 1
 894     NO MINVALUE
 895     NO MAXVALUE
 896     CACHE 1;
 897
 898
 899 ALTER TABLE builds_watchers_id_seq OWNER TO pakfire;
 900
 901 --
 902 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 903 --
 904
 905 ALTER SEQUENCE builds_watchers_id_seq OWNED BY builds_watchers.id;
 906
 907
 908 --
 909 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 910 --
 911
 912 CREATE TABLE distributions (
 913     id integer NOT NULL,
 914     name text NOT NULL,
 915     sname text NOT NULL,
 916     slogan text NOT NULL,
 917     description text,
 918     vendor text NOT NULL,
 919     contact text,
 920     tag text NOT NULL,
 921     deleted boolean DEFAULT false NOT NULL
 922 );
 923
 924
 925 ALTER TABLE distributions OWNER TO pakfire;
 926
 927 --
 928 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 929 --
 930
 931 CREATE TABLE distributions_arches (
 932     id integer NOT NULL,
 933     distro_id integer NOT NULL,
 934     arch text NOT NULL
 935 );
 936
 937
 938 ALTER TABLE distributions_arches OWNER TO pakfire;
 939
 940 --
 941 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 942 --
 943
 944 CREATE SEQUENCE distributions_id_seq
 945     START WITH 1
 946     INCREMENT BY 1
 947     NO MINVALUE
 948     NO MAXVALUE
 949     CACHE 1;
 950
 951
 952 ALTER TABLE distributions_id_seq OWNER TO pakfire;
 953
 954 --
 955 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 956 --
 957
 958 ALTER SEQUENCE distributions_id_seq OWNED BY distributions.id;
 959
 960
 961 --
 962 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 963 --
 964
 965 CREATE SEQUENCE distro_arches_id_seq
 966     START WITH 1
 967     INCREMENT BY 1
 968     NO MINVALUE
 969     NO MAXVALUE
 970     CACHE 1;
 971
 972
 973 ALTER TABLE distro_arches_id_seq OWNER TO pakfire;
 974
 975 --
 976 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 977 --
 978
 979 ALTER SEQUENCE distro_arches_id_seq OWNED BY distributions_arches.id;
 980
 981
 982 --
 983 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 984 --
 985
 986 CREATE TABLE filelists (
 987     pkg_id integer NOT NULL,
 988     name text NOT NULL,
 989     size bigint NOT NULL,
 990     hash_sha512 text,
 991     type integer NOT NULL,
 992     config boolean NOT NULL,
 993     mode integer NOT NULL,
 994     "user" text NOT NULL,
 995     "group" text NOT NULL,
 996     mtime timestamp without time zone NOT NULL,
 997     capabilities text
 998 );
 999
1000
1001 ALTER TABLE filelists OWNER TO pakfire;
1002
1003 --
1004 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1005 --
1006
1007 CREATE TABLE images_types (
1008     id integer NOT NULL,
1009     type text NOT NULL
1010 );
1011
1012
1013 ALTER TABLE images_types OWNER TO pakfire;
1014
1015 --
1016 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1017 --
1018
1019 CREATE SEQUENCE images_types_id_seq
1020     START WITH 1
1021     INCREMENT BY 1
1022     NO MINVALUE
1023     NO MAXVALUE
1024     CACHE 1;
1025
1026
1027 ALTER TABLE images_types_id_seq OWNER TO pakfire;
1028
1029 --
1030 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1031 --
1032
1033 ALTER SEQUENCE images_types_id_seq OWNED BY images_types.id;
1034
1035
1036 --
1037 -- Name: jobs_active; Type: VIEW; Schema: public; Owner: pakfire
1038 --
1039
1040 CREATE VIEW jobs_active AS
1041  SELECT jobs.id,
1042     jobs.uuid,
1043     jobs.build_id,
1044     jobs.state,
1045     jobs.arch,
1046     jobs.time_created,
1047     jobs.time_started,
1048     jobs.time_finished,
1049     jobs.start_not_before,
1050     jobs.builder_id,
1051     jobs.aborted_state,
1052     jobs.message
1053    FROM jobs
1054   WHERE (jobs.state = ANY (ARRAY['dispatching'::jobs_state, 'running'::jobs_state, 'uploading'::jobs_state]))
1055   ORDER BY jobs.time_started;
1056
1057
1058 ALTER TABLE jobs_active OWNER TO pakfire;
1059
1060 --
1061 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1062 --
1063
1064 CREATE TABLE jobs_buildroots (
1065     job_id integer NOT NULL,
1066     pkg_uuid text NOT NULL,
1067     pkg_name text NOT NULL
1068 );
1069
1070
1071 ALTER TABLE jobs_buildroots OWNER TO pakfire;
1072
1073 --
1074 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1075 --
1076
1077 CREATE TABLE jobs_history (
1078     job_id integer NOT NULL,
1079     action jobs_history_action NOT NULL,
1080     state jobs_history_state,
1081     user_id integer,
1082     "time" timestamp without time zone NOT NULL,
1083     builder_id integer,
1084     test_job_id integer
1085 );
1086
1087
1088 ALTER TABLE jobs_history OWNER TO pakfire;
1089
1090 --
1091 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1092 --
1093
1094 CREATE SEQUENCE jobs_id_seq
1095     START WITH 1
1096     INCREMENT BY 1
1097     NO MINVALUE
1098     NO MAXVALUE
1099     CACHE 1;
1100
1101
1102 ALTER TABLE jobs_id_seq OWNER TO pakfire;
1103
1104 --
1105 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1106 --
1107
1108 ALTER SEQUENCE jobs_id_seq OWNED BY jobs.id;
1109
1110
1111 --
1112 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1113 --
1114
1115 CREATE TABLE jobs_packages (
1116     id integer NOT NULL,
1117     job_id integer NOT NULL,
1118     pkg_id integer NOT NULL
1119 );
1120
1121
1122 ALTER TABLE jobs_packages OWNER TO pakfire;
1123
1124 --
1125 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1126 --
1127
1128 CREATE SEQUENCE jobs_packages_id_seq
1129     START WITH 1
1130     INCREMENT BY 1
1131     NO MINVALUE
1132     NO MAXVALUE
1133     CACHE 1;
1134
1135
1136 ALTER TABLE jobs_packages_id_seq OWNER TO pakfire;
1137
1138 --
1139 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1140 --
1141
1142 ALTER SEQUENCE jobs_packages_id_seq OWNED BY jobs_packages.id;
1143
1144
1145 --
1146 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
1147 --
1148
1149 CREATE VIEW jobs_queue AS
1150  WITH queue AS (
1151          SELECT jobs.id,
1152             rank() OVER (ORDER BY (NOT jobs.test), builds.priority DESC, jobs.time_created) AS rank
1153            FROM (jobs
1154              LEFT JOIN builds ON ((jobs.build_id = builds.id)))
1155           WHERE (jobs.state = 'pending'::jobs_state)
1156         )
1157  SELECT queue.id AS job_id,
1158     queue.rank
1159    FROM queue;
1160
1161
1162 ALTER TABLE jobs_queue OWNER TO pakfire;
1163
1164 --
1165 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1166 --
1167
1168 CREATE TABLE jobs_repos (
1169     job_id integer NOT NULL,
1170     repo_id integer NOT NULL
1171 );
1172
1173
1174 ALTER TABLE jobs_repos OWNER TO pakfire;
1175
1176 --
1177 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1178 --
1179
1180 CREATE TABLE keys (
1181     id integer NOT NULL,
1182     fingerprint text NOT NULL,
1183     uids text NOT NULL,
1184     data text NOT NULL
1185 );
1186
1187
1188 ALTER TABLE keys OWNER TO pakfire;
1189
1190 --
1191 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1192 --
1193
1194 CREATE SEQUENCE keys_id_seq
1195     START WITH 1
1196     INCREMENT BY 1
1197     NO MINVALUE
1198     NO MAXVALUE
1199     CACHE 1;
1200
1201
1202 ALTER TABLE keys_id_seq OWNER TO pakfire;
1203
1204 --
1205 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1206 --
1207
1208 ALTER SEQUENCE keys_id_seq OWNED BY keys.id;
1209
1210
1211 --
1212 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1213 --
1214
1215 CREATE TABLE keys_subkeys (
1216     id integer NOT NULL,
1217     key_id integer NOT NULL,
1218     fingerprint text NOT NULL,
1219     time_created timestamp without time zone NOT NULL,
1220     time_expires timestamp without time zone,
1221     algo text
1222 );
1223
1224
1225 ALTER TABLE keys_subkeys OWNER TO pakfire;
1226
1227 --
1228 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1229 --
1230
1231 CREATE SEQUENCE keys_subkeys_id_seq
1232     START WITH 1
1233     INCREMENT BY 1
1234     NO MINVALUE
1235     NO MAXVALUE
1236     CACHE 1;
1237
1238
1239 ALTER TABLE keys_subkeys_id_seq OWNER TO pakfire;
1240
1241 --
1242 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1243 --
1244
1245 ALTER SEQUENCE keys_subkeys_id_seq OWNED BY keys_subkeys.id;
1246
1247
1248 --
1249 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1250 --
1251
1252 CREATE TABLE logfiles (
1253     id integer NOT NULL,
1254     job_id integer NOT NULL,
1255     path text NOT NULL,
1256     filesize bigint NOT NULL,
1257     hash_sha512 text NOT NULL
1258 );
1259
1260
1261 ALTER TABLE logfiles OWNER TO pakfire;
1262
1263 --
1264 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1265 --
1266
1267 CREATE SEQUENCE logfiles_id_seq
1268     START WITH 1
1269     INCREMENT BY 1
1270     NO MINVALUE
1271     NO MAXVALUE
1272     CACHE 1;
1273
1274
1275 ALTER TABLE logfiles_id_seq OWNER TO pakfire;
1276
1277 --
1278 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1279 --
1280
1281 ALTER SEQUENCE logfiles_id_seq OWNED BY logfiles.id;
1282
1283
1284 --
1285 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1286 --
1287
1288 CREATE TABLE mirrors (
1289     id integer NOT NULL,
1290     hostname text NOT NULL,
1291     path text NOT NULL,
1292     owner text,
1293     contact text,
1294     deleted boolean DEFAULT false NOT NULL,
1295     supports_https boolean DEFAULT false NOT NULL
1296 );
1297
1298
1299 ALTER TABLE mirrors OWNER TO pakfire;
1300
1301 --
1302 -- Name: mirrors_checks; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1303 --
1304
1305 CREATE TABLE mirrors_checks (
1306     id integer NOT NULL,
1307     mirror_id integer NOT NULL,
1308     "timestamp" timestamp without time zone DEFAULT now() NOT NULL,
1309     response_time double precision,
1310     http_status integer,
1311     last_sync_at timestamp without time zone,
1312     status text DEFAULT 'OK'::text NOT NULL
1313 );
1314
1315
1316 ALTER TABLE mirrors_checks OWNER TO pakfire;
1317
1318 --
1319 -- Name: mirrors_checks_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1320 --
1321
1322 CREATE SEQUENCE mirrors_checks_id_seq
1323     START WITH 1
1324     INCREMENT BY 1
1325     NO MINVALUE
1326     NO MAXVALUE
1327     CACHE 1;
1328
1329
1330 ALTER TABLE mirrors_checks_id_seq OWNER TO pakfire;
1331
1332 --
1333 -- Name: mirrors_checks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1334 --
1335
1336 ALTER SEQUENCE mirrors_checks_id_seq OWNED BY mirrors_checks.id;
1337
1338
1339 --
1340 -- Name: mirrors_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1341 --
1342
1343 CREATE TABLE mirrors_history (
1344     id integer NOT NULL,
1345     mirror_id integer NOT NULL,
1346     action mirrors_history_action NOT NULL,
1347     user_id integer,
1348     "time" timestamp without time zone NOT NULL
1349 );
1350
1351
1352 ALTER TABLE mirrors_history OWNER TO pakfire;
1353
1354 --
1355 -- Name: mirrors_history_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1356 --
1357
1358 CREATE SEQUENCE mirrors_history_id_seq
1359     START WITH 1
1360     INCREMENT BY 1
1361     NO MINVALUE
1362     NO MAXVALUE
1363     CACHE 1;
1364
1365
1366 ALTER TABLE mirrors_history_id_seq OWNER TO pakfire;
1367
1368 --
1369 -- Name: mirrors_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1370 --
1371
1372 ALTER SEQUENCE mirrors_history_id_seq OWNED BY mirrors_history.id;
1373
1374
1375 --
1376 -- Name: mirrors_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1377 --
1378
1379 CREATE SEQUENCE mirrors_id_seq
1380     START WITH 1
1381     INCREMENT BY 1
1382     NO MINVALUE
1383     NO MAXVALUE
1384     CACHE 1;
1385
1386
1387 ALTER TABLE mirrors_id_seq OWNER TO pakfire;
1388
1389 --
1390 -- Name: mirrors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1391 --
1392
1393 ALTER SEQUENCE mirrors_id_seq OWNED BY mirrors.id;
1394
1395
1396 --
1397 -- Name: packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1398 --
1399
1400 CREATE TABLE packages (
1401     id integer NOT NULL,
1402     name text NOT NULL,
1403     epoch integer NOT NULL,
1404     version text NOT NULL,
1405     release text NOT NULL,
1406     type packages_type NOT NULL,
1407     arch text NOT NULL,
1408     groups text NOT NULL,
1409     maintainer text NOT NULL,
1410     license text NOT NULL,
1411     url text NOT NULL,
1412     summary text NOT NULL,
1413     description text NOT NULL,
1414     size bigint NOT NULL,
1415     supported_arches text,
1416     uuid text NOT NULL,
1417     commit_id integer,
1418     build_id text NOT NULL,
1419     build_host text NOT NULL,
1420     build_time timestamp without time zone NOT NULL,
1421     path text NOT NULL,
1422     filesize bigint NOT NULL,
1423     hash_sha512 text NOT NULL
1424 );
1425
1426
1427 ALTER TABLE packages OWNER TO pakfire;
1428
1429 --
1430 -- Name: packages_deps; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1431 --
1432
1433 CREATE TABLE packages_deps (
1434     pkg_id integer NOT NULL,
1435     type packages_deps_type NOT NULL,
1436     what text NOT NULL
1437 );
1438
1439
1440 ALTER TABLE packages_deps OWNER TO pakfire;
1441
1442 --
1443 -- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1444 --
1445
1446 CREATE SEQUENCE packages_id_seq
1447     START WITH 1
1448     INCREMENT BY 1
1449     NO MINVALUE
1450     NO MAXVALUE
1451     CACHE 1;
1452
1453
1454 ALTER TABLE packages_id_seq OWNER TO pakfire;
1455
1456 --
1457 -- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1458 --
1459
1460 ALTER SEQUENCE packages_id_seq OWNED BY packages.id;
1461
1462
1463 --
1464 -- Name: packages_properties; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1465 --
1466
1467 CREATE TABLE packages_properties (
1468     id integer NOT NULL,
1469     name text NOT NULL,
1470     critical_path boolean DEFAULT false NOT NULL,
1471     priority integer DEFAULT 0 NOT NULL
1472 );
1473
1474
1475 ALTER TABLE packages_properties OWNER TO pakfire;
1476
1477 --
1478 -- Name: packages_properties_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1479 --
1480
1481 CREATE SEQUENCE packages_properties_id_seq
1482     START WITH 1
1483     INCREMENT BY 1
1484     NO MINVALUE
1485     NO MAXVALUE
1486     CACHE 1;
1487
1488
1489 ALTER TABLE packages_properties_id_seq OWNER TO pakfire;
1490
1491 --
1492 -- Name: packages_properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1493 --
1494
1495 ALTER SEQUENCE packages_properties_id_seq OWNED BY packages_properties.id;
1496
1497
1498 --
1499 -- Name: queue_delete; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1500 --
1501
1502 CREATE TABLE queue_delete (
1503     id integer NOT NULL,
1504     path text NOT NULL
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     update_started timestamp without time zone,
1565     update_ended timestamp without time zone,
1566     deleted boolean DEFAULT false NOT NULL,
1567     priority integer
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: slogans; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1736 --
1737
1738 CREATE TABLE slogans (
1739     id integer NOT NULL,
1740     message text NOT NULL
1741 );
1742
1743
1744 ALTER TABLE slogans OWNER TO pakfire;
1745
1746 --
1747 -- Name: slogans_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1748 --
1749
1750 CREATE SEQUENCE slogans_id_seq
1751     START WITH 1
1752     INCREMENT BY 1
1753     NO MINVALUE
1754     NO MAXVALUE
1755     CACHE 1;
1756
1757
1758 ALTER TABLE slogans_id_seq OWNER TO pakfire;
1759
1760 --
1761 -- Name: slogans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1762 --
1763
1764 ALTER SEQUENCE slogans_id_seq OWNED BY slogans.id;
1765
1766
1767 --
1768 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1769 --
1770
1771 CREATE TABLE sources (
1772     id integer NOT NULL,
1773     name text NOT NULL,
1774     identifier text NOT NULL,
1775     url text NOT NULL,
1776     gitweb text,
1777     revision text NOT NULL,
1778     branch text NOT NULL,
1779     updated timestamp without time zone,
1780     distro_id integer NOT NULL
1781 );
1782
1783
1784 ALTER TABLE sources OWNER TO pakfire;
1785
1786 --
1787 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1788 --
1789
1790 CREATE TABLE sources_commits (
1791     id integer NOT NULL,
1792     source_id integer NOT NULL,
1793     revision text NOT NULL,
1794     author text NOT NULL,
1795     committer text NOT NULL,
1796     subject text NOT NULL,
1797     body text NOT NULL,
1798     date timestamp without time zone NOT NULL,
1799     state sources_commits_state DEFAULT 'pending'::sources_commits_state NOT NULL,
1800     imported_at timestamp without time zone DEFAULT now() NOT NULL
1801 );
1802
1803
1804 ALTER TABLE sources_commits OWNER TO pakfire;
1805
1806 --
1807 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1808 --
1809
1810 CREATE SEQUENCE sources_commits_id_seq
1811     START WITH 1
1812     INCREMENT BY 1
1813     NO MINVALUE
1814     NO MAXVALUE
1815     CACHE 1;
1816
1817
1818 ALTER TABLE sources_commits_id_seq OWNER TO pakfire;
1819
1820 --
1821 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1822 --
1823
1824 ALTER SEQUENCE sources_commits_id_seq OWNED BY sources_commits.id;
1825
1826
1827 --
1828 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1829 --
1830
1831 CREATE SEQUENCE sources_id_seq
1832     START WITH 1
1833     INCREMENT BY 1
1834     NO MINVALUE
1835     NO MAXVALUE
1836     CACHE 1;
1837
1838
1839 ALTER TABLE sources_id_seq OWNER TO pakfire;
1840
1841 --
1842 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1843 --
1844
1845 ALTER SEQUENCE sources_id_seq OWNED BY sources.id;
1846
1847
1848 --
1849 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1850 --
1851
1852 CREATE TABLE uploads (
1853     id integer NOT NULL,
1854     uuid text NOT NULL,
1855     user_id integer,
1856     builder_id integer,
1857     filename text NOT NULL,
1858     hash text NOT NULL,
1859     size bigint NOT NULL,
1860     progress bigint DEFAULT 0 NOT NULL,
1861     finished boolean DEFAULT false NOT NULL,
1862     time_started timestamp without time zone DEFAULT now() NOT NULL,
1863     time_finished timestamp without time zone
1864 );
1865
1866
1867 ALTER TABLE uploads OWNER TO pakfire;
1868
1869 --
1870 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1871 --
1872
1873 CREATE SEQUENCE uploads_id_seq
1874     START WITH 1
1875     INCREMENT BY 1
1876     NO MINVALUE
1877     NO MAXVALUE
1878     CACHE 1;
1879
1880
1881 ALTER TABLE uploads_id_seq OWNER TO pakfire;
1882
1883 --
1884 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1885 --
1886
1887 ALTER SEQUENCE uploads_id_seq OWNED BY uploads.id;
1888
1889
1890 --
1891 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1892 --
1893
1894 CREATE TABLE user_messages (
1895     id integer NOT NULL,
1896     frm text NOT NULL,
1897     "to" text NOT NULL,
1898     subject text NOT NULL,
1899     text text NOT NULL,
1900     time_added timestamp without time zone DEFAULT now() NOT NULL
1901 );
1902
1903
1904 ALTER TABLE user_messages OWNER TO pakfire;
1905
1906 --
1907 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1908 --
1909
1910 CREATE SEQUENCE user_messages_id_seq
1911     START WITH 1
1912     INCREMENT BY 1
1913     NO MINVALUE
1914     NO MAXVALUE
1915     CACHE 1;
1916
1917
1918 ALTER TABLE user_messages_id_seq OWNER TO pakfire;
1919
1920 --
1921 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1922 --
1923
1924 ALTER SEQUENCE user_messages_id_seq OWNED BY user_messages.id;
1925
1926
1927 --
1928 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1929 --
1930
1931 CREATE TABLE users (
1932     id integer NOT NULL,
1933     name text NOT NULL,
1934     realname text,
1935     passphrase text NOT NULL,
1936     state users_state NOT NULL,
1937     locale text,
1938     timezone text,
1939     activated users_activated DEFAULT 'N'::users_activated NOT NULL,
1940     activation_code text,
1941     deleted users_deleted DEFAULT 'N'::users_deleted NOT NULL,
1942     registered timestamp without time zone DEFAULT now() NOT NULL
1943 );
1944
1945
1946 ALTER TABLE users OWNER TO pakfire;
1947
1948 --
1949 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1950 --
1951
1952 CREATE TABLE users_emails (
1953     id integer NOT NULL,
1954     user_id integer NOT NULL,
1955     email text NOT NULL,
1956     "primary" users_emails_primary DEFAULT 'N'::users_emails_primary NOT NULL
1957 );
1958
1959
1960 ALTER TABLE users_emails OWNER TO pakfire;
1961
1962 --
1963 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1964 --
1965
1966 CREATE SEQUENCE users_emails_id_seq
1967     START WITH 1
1968     INCREMENT BY 1
1969     NO MINVALUE
1970     NO MAXVALUE
1971     CACHE 1;
1972
1973
1974 ALTER TABLE users_emails_id_seq OWNER TO pakfire;
1975
1976 --
1977 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1978 --
1979
1980 ALTER SEQUENCE users_emails_id_seq OWNED BY users_emails.id;
1981
1982
1983 --
1984 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1985 --
1986
1987 CREATE SEQUENCE users_id_seq
1988     START WITH 1
1989     INCREMENT BY 1
1990     NO MINVALUE
1991     NO MAXVALUE
1992     CACHE 1;
1993
1994
1995 ALTER TABLE users_id_seq OWNER TO pakfire;
1996
1997 --
1998 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1999 --
2000
2001 ALTER SEQUENCE users_id_seq OWNED BY users.id;
2002
2003
2004 --
2005 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2006 --
2007
2008 CREATE TABLE users_permissions (
2009     id integer NOT NULL,
2010     user_id integer NOT NULL,
2011     create_scratch_builds users_permissions_create_scratch_builds DEFAULT 'N'::users_permissions_create_scratch_builds NOT NULL,
2012     maintain_builders users_permissions_maintain_builders DEFAULT 'N'::users_permissions_maintain_builders NOT NULL,
2013     manage_critical_path users_permissions_manage_critical_path DEFAULT 'N'::users_permissions_manage_critical_path NOT NULL,
2014     manage_mirrors users_permissions_manage_mirrors DEFAULT 'N'::users_permissions_manage_mirrors NOT NULL,
2015     vote users_permissions_vote DEFAULT 'N'::users_permissions_vote NOT NULL
2016 );
2017
2018
2019 ALTER TABLE users_permissions OWNER TO pakfire;
2020
2021 --
2022 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2023 --
2024
2025 CREATE SEQUENCE users_permissions_id_seq
2026     START WITH 1
2027     INCREMENT BY 1
2028     NO MINVALUE
2029     NO MAXVALUE
2030     CACHE 1;
2031
2032
2033 ALTER TABLE users_permissions_id_seq OWNER TO pakfire;
2034
2035 --
2036 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2037 --
2038
2039 ALTER SEQUENCE users_permissions_id_seq OWNED BY users_permissions.id;
2040
2041
2042 --
2043 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2044 --
2045
2046 ALTER TABLE ONLY arches ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
2047
2048
2049 --
2050 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2051 --
2052
2053 ALTER TABLE ONLY builders ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
2054
2055
2056 --
2057 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2058 --
2059
2060 ALTER TABLE ONLY builders_history ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
2061
2062
2063 --
2064 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2065 --
2066
2067 ALTER TABLE ONLY builds ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
2068
2069
2070 --
2071 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2072 --
2073
2074 ALTER TABLE ONLY builds_bugs ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
2075
2076
2077 --
2078 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2079 --
2080
2081 ALTER TABLE ONLY builds_bugs_updates ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
2082
2083
2084 --
2085 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2086 --
2087
2088 ALTER TABLE ONLY builds_comments ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
2089
2090
2091 --
2092 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2093 --
2094
2095 ALTER TABLE ONLY builds_history ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
2096
2097
2098 --
2099 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2100 --
2101
2102 ALTER TABLE ONLY builds_watchers ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
2103
2104
2105 --
2106 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2107 --
2108
2109 ALTER TABLE ONLY distributions ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
2110
2111
2112 --
2113 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2114 --
2115
2116 ALTER TABLE ONLY distributions_arches ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
2117
2118
2119 --
2120 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2121 --
2122
2123 ALTER TABLE ONLY images_types ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
2124
2125
2126 --
2127 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2128 --
2129
2130 ALTER TABLE ONLY jobs ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
2131
2132
2133 --
2134 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2135 --
2136
2137 ALTER TABLE ONLY jobs_packages ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
2138
2139
2140 --
2141 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2142 --
2143
2144 ALTER TABLE ONLY keys ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
2145
2146
2147 --
2148 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2149 --
2150
2151 ALTER TABLE ONLY keys_subkeys ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
2152
2153
2154 --
2155 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2156 --
2157
2158 ALTER TABLE ONLY logfiles ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
2159
2160
2161 --
2162 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2163 --
2164
2165 ALTER TABLE ONLY mirrors ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
2166
2167
2168 --
2169 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2170 --
2171
2172 ALTER TABLE ONLY mirrors_checks ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
2173
2174
2175 --
2176 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2177 --
2178
2179 ALTER TABLE ONLY mirrors_history ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
2180
2181
2182 --
2183 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2184 --
2185
2186 ALTER TABLE ONLY packages ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
2187
2188
2189 --
2190 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2191 --
2192
2193 ALTER TABLE ONLY packages_properties ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
2194
2195
2196 --
2197 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2198 --
2199
2200 ALTER TABLE ONLY queue_delete ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
2201
2202
2203 --
2204 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2205 --
2206
2207 ALTER TABLE ONLY repositories ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
2208
2209
2210 --
2211 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2212 --
2213
2214 ALTER TABLE ONLY repositories_aux ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
2215
2216
2217 --
2218 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2219 --
2220
2221 ALTER TABLE ONLY repositories_builds ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
2222
2223
2224 --
2225 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2226 --
2227
2228 ALTER TABLE ONLY sessions ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
2229
2230
2231 --
2232 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2233 --
2234
2235 ALTER TABLE ONLY slogans ALTER COLUMN id SET DEFAULT nextval('slogans_id_seq'::regclass);
2236
2237
2238 --
2239 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2240 --
2241
2242 ALTER TABLE ONLY sources ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
2243
2244
2245 --
2246 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2247 --
2248
2249 ALTER TABLE ONLY sources_commits ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
2250
2251
2252 --
2253 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2254 --
2255
2256 ALTER TABLE ONLY uploads ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
2257
2258
2259 --
2260 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2261 --
2262
2263 ALTER TABLE ONLY user_messages ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
2264
2265
2266 --
2267 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2268 --
2269
2270 ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
2271
2272
2273 --
2274 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2275 --
2276
2277 ALTER TABLE ONLY users_emails ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
2278
2279
2280 --
2281 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2282 --
2283
2284 ALTER TABLE ONLY users_permissions ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
2285
2286
2287 --
2288 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2289 --
2290
2291 ALTER TABLE ONLY arches_compat
2292     ADD CONSTRAINT arches_compat_unique UNIQUE (native_arch, build_arch);
2293
2294
2295 --
2296 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2297 --
2298
2299 ALTER TABLE ONLY arches
2300     ADD CONSTRAINT arches_name UNIQUE (name);
2301
2302
2303 --
2304 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2305 --
2306
2307 ALTER TABLE ONLY arches
2308     ADD CONSTRAINT idx_2197943_primary PRIMARY KEY (id);
2309
2310
2311 --
2312 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2313 --
2314
2315 ALTER TABLE ONLY builders
2316     ADD CONSTRAINT idx_2197954_primary PRIMARY KEY (id);
2317
2318
2319 --
2320 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2321 --
2322
2323 ALTER TABLE ONLY builders_history
2324     ADD CONSTRAINT idx_2197982_primary PRIMARY KEY (id);
2325
2326
2327 --
2328 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2329 --
2330
2331 ALTER TABLE ONLY builds
2332     ADD CONSTRAINT idx_2197988_primary PRIMARY KEY (id);
2333
2334
2335 --
2336 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2337 --
2338
2339 ALTER TABLE ONLY builds_bugs
2340     ADD CONSTRAINT idx_2198002_primary PRIMARY KEY (id);
2341
2342
2343 --
2344 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2345 --
2346
2347 ALTER TABLE ONLY builds_bugs_updates
2348     ADD CONSTRAINT idx_2198008_primary PRIMARY KEY (id);
2349
2350
2351 --
2352 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2353 --
2354
2355 ALTER TABLE ONLY builds_comments
2356     ADD CONSTRAINT idx_2198018_primary PRIMARY KEY (id);
2357
2358
2359 --
2360 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2361 --
2362
2363 ALTER TABLE ONLY builds_history
2364     ADD CONSTRAINT idx_2198027_primary PRIMARY KEY (id);
2365
2366
2367 --
2368 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2369 --
2370
2371 ALTER TABLE ONLY builds_watchers
2372     ADD CONSTRAINT idx_2198033_primary PRIMARY KEY (id);
2373
2374
2375 --
2376 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2377 --
2378
2379 ALTER TABLE ONLY distributions
2380     ADD CONSTRAINT idx_2198039_primary PRIMARY KEY (id);
2381
2382
2383 --
2384 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2385 --
2386
2387 ALTER TABLE ONLY distributions_arches
2388     ADD CONSTRAINT idx_2198048_primary PRIMARY KEY (id);
2389
2390
2391 --
2392 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2393 --
2394
2395 ALTER TABLE ONLY images_types
2396     ADD CONSTRAINT idx_2198057_primary PRIMARY KEY (id);
2397
2398
2399 --
2400 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2401 --
2402
2403 ALTER TABLE ONLY jobs
2404     ADD CONSTRAINT idx_2198063_primary PRIMARY KEY (id);
2405
2406
2407 --
2408 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2409 --
2410
2411 ALTER TABLE ONLY jobs_packages
2412     ADD CONSTRAINT idx_2198085_primary PRIMARY KEY (id);
2413
2414
2415 --
2416 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2417 --
2418
2419 ALTER TABLE ONLY keys
2420     ADD CONSTRAINT idx_2198094_primary PRIMARY KEY (id);
2421
2422
2423 --
2424 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2425 --
2426
2427 ALTER TABLE ONLY keys_subkeys
2428     ADD CONSTRAINT idx_2198103_primary PRIMARY KEY (id);
2429
2430
2431 --
2432 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2433 --
2434
2435 ALTER TABLE ONLY logfiles
2436     ADD CONSTRAINT idx_2198109_primary PRIMARY KEY (id);
2437
2438
2439 --
2440 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2441 --
2442
2443 ALTER TABLE ONLY mirrors
2444     ADD CONSTRAINT idx_2198115_primary PRIMARY KEY (id);
2445
2446
2447 --
2448 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2449 --
2450
2451 ALTER TABLE ONLY mirrors_history
2452     ADD CONSTRAINT idx_2198126_primary PRIMARY KEY (id);
2453
2454
2455 --
2456 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2457 --
2458
2459 ALTER TABLE ONLY packages
2460     ADD CONSTRAINT idx_2198132_primary PRIMARY KEY (id);
2461
2462
2463 --
2464 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2465 --
2466
2467 ALTER TABLE ONLY packages_properties
2468     ADD CONSTRAINT idx_2198147_primary PRIMARY KEY (id);
2469
2470
2471 --
2472 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2473 --
2474
2475 ALTER TABLE ONLY queue_delete
2476     ADD CONSTRAINT idx_2198155_primary PRIMARY KEY (id);
2477
2478
2479 --
2480 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2481 --
2482
2483 ALTER TABLE ONLY repositories
2484     ADD CONSTRAINT idx_2198164_primary PRIMARY KEY (id);
2485
2486
2487 --
2488 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2489 --
2490
2491 ALTER TABLE ONLY repositories_aux
2492     ADD CONSTRAINT idx_2198179_primary PRIMARY KEY (id);
2493
2494
2495 --
2496 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2497 --
2498
2499 ALTER TABLE ONLY repositories_builds
2500     ADD CONSTRAINT idx_2198189_primary PRIMARY KEY (id);
2501
2502
2503 --
2504 -- Name: idx_2198207_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2505 --
2506
2507 ALTER TABLE ONLY slogans
2508     ADD CONSTRAINT idx_2198207_primary PRIMARY KEY (id);
2509
2510
2511 --
2512 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2513 --
2514
2515 ALTER TABLE ONLY sources
2516     ADD CONSTRAINT idx_2198213_primary PRIMARY KEY (id);
2517
2518
2519 --
2520 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2521 --
2522
2523 ALTER TABLE ONLY sources_commits
2524     ADD CONSTRAINT idx_2198222_primary PRIMARY KEY (id);
2525
2526
2527 --
2528 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2529 --
2530
2531 ALTER TABLE ONLY uploads
2532     ADD CONSTRAINT idx_2198232_primary PRIMARY KEY (id);
2533
2534
2535 --
2536 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2537 --
2538
2539 ALTER TABLE ONLY users
2540     ADD CONSTRAINT idx_2198244_primary PRIMARY KEY (id);
2541
2542
2543 --
2544 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2545 --
2546
2547 ALTER TABLE ONLY users_emails
2548     ADD CONSTRAINT idx_2198256_primary PRIMARY KEY (id);
2549
2550
2551 --
2552 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2553 --
2554
2555 ALTER TABLE ONLY users_permissions
2556     ADD CONSTRAINT idx_2198263_primary PRIMARY KEY (id);
2557
2558
2559 --
2560 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2561 --
2562
2563 ALTER TABLE ONLY user_messages
2564     ADD CONSTRAINT idx_2198274_primary PRIMARY KEY (id);
2565
2566
2567 --
2568 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2569 --
2570
2571 ALTER TABLE ONLY jobs_packages
2572     ADD CONSTRAINT jobs_packages_unique UNIQUE (job_id, pkg_id);
2573
2574
2575 --
2576 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2577 --
2578
2579 ALTER TABLE ONLY mirrors_checks
2580     ADD CONSTRAINT mirrors_checks_pkey PRIMARY KEY (id);
2581
2582
2583 --
2584 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2585 --
2586
2587 ALTER TABLE ONLY sessions
2588     ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);
2589
2590
2591 --
2592 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2593 --
2594
2595 ALTER TABLE ONLY sessions
2596     ADD CONSTRAINT sessions_session_id_key UNIQUE (session_id);
2597
2598
2599 --
2600 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2601 --
2602
2603 CREATE INDEX arches_compat_native_arch ON arches_compat USING btree (native_arch);
2604
2605
2606 --
2607 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2608 --
2609
2610 CREATE UNIQUE INDEX builders_name ON builders USING btree (name) WHERE (deleted IS FALSE);
2611
2612
2613 --
2614 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2615 --
2616
2617 CREATE INDEX builds_watchers_build_id ON builds_watchers USING btree (build_id);
2618
2619
2620 --
2621 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2622 --
2623
2624 CREATE INDEX distributions_arches_distro_id ON distributions_arches USING btree (distro_id);
2625
2626
2627 --
2628 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2629 --
2630
2631 CREATE UNIQUE INDEX distributions_sname ON distributions USING btree (sname) WHERE (deleted IS FALSE);
2632
2633
2634 --
2635 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2636 --
2637
2638 CREATE INDEX filelists_name ON filelists USING btree (name);
2639
2640
2641 --
2642 -- Name: filelists_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2643 --
2644
2645 CREATE INDEX filelists_pkg_id ON filelists USING btree (pkg_id);
2646
2647 ALTER TABLE filelists CLUSTER ON filelists_pkg_id;
2648
2649
2650 --
2651 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2652 --
2653
2654 CREATE INDEX idx_2197982_builder_id ON builders_history USING btree (builder_id);
2655
2656
2657 --
2658 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2659 --
2660
2661 CREATE INDEX idx_2197988_pkg_id ON builds USING btree (pkg_id);
2662
2663
2664 --
2665 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2666 --
2667
2668 CREATE INDEX idx_2197988_state ON builds USING btree (state);
2669
2670
2671 --
2672 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2673 --
2674
2675 CREATE INDEX idx_2197988_type ON builds USING btree (type);
2676
2677
2678 --
2679 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2680 --
2681
2682 CREATE UNIQUE INDEX idx_2197988_uuid ON builds USING btree (uuid);
2683
2684
2685 --
2686 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2687 --
2688
2689 CREATE UNIQUE INDEX idx_2198002_build_id ON builds_bugs USING btree (build_id, bug_id);
2690
2691
2692 --
2693 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2694 --
2695
2696 CREATE INDEX idx_2198018_build_id ON builds_comments USING btree (build_id);
2697
2698
2699 --
2700 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2701 --
2702
2703 CREATE INDEX idx_2198018_user_id ON builds_comments USING btree (user_id);
2704
2705
2706 --
2707 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2708 --
2709
2710 CREATE INDEX idx_2198063_build_id ON jobs USING btree (build_id);
2711
2712
2713 --
2714 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2715 --
2716
2717 CREATE INDEX idx_2198063_state ON jobs USING btree (state);
2718
2719
2720 --
2721 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2722 --
2723
2724 CREATE INDEX idx_2198063_time_finished ON jobs USING btree (time_finished);
2725
2726
2727 --
2728 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2729 --
2730
2731 CREATE UNIQUE INDEX idx_2198063_uuid ON jobs USING btree (uuid);
2732
2733
2734 --
2735 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2736 --
2737
2738 CREATE INDEX idx_2198080_job_id ON jobs_history USING btree (job_id);
2739
2740
2741 --
2742 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2743 --
2744
2745 CREATE UNIQUE INDEX idx_2198089_job_id ON jobs_repos USING btree (job_id, repo_id);
2746
2747
2748 --
2749 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2750 --
2751
2752 CREATE UNIQUE INDEX idx_2198094_fingerprint ON keys USING btree (fingerprint);
2753
2754
2755 --
2756 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2757 --
2758
2759 CREATE INDEX idx_2198132_name ON packages USING btree (name);
2760
2761
2762 --
2763 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2764 --
2765
2766 CREATE INDEX idx_2198132_type ON packages USING btree (type);
2767
2768
2769 --
2770 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2771 --
2772
2773 CREATE INDEX idx_2198132_uuid ON packages USING btree (uuid);
2774
2775
2776 --
2777 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2778 --
2779
2780 CREATE INDEX idx_2198139_pkg_id ON packages_deps USING btree (pkg_id);
2781
2782
2783 --
2784 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2785 --
2786
2787 CREATE UNIQUE INDEX idx_2198147_name ON packages_properties USING btree (name);
2788
2789
2790 --
2791 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2792 --
2793
2794 CREATE UNIQUE INDEX idx_2198189_build_id ON repositories_builds USING btree (build_id);
2795
2796
2797 --
2798 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2799 --
2800
2801 CREATE INDEX idx_2198193_build_id ON repositories_history USING btree (build_id);
2802
2803
2804 --
2805 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2806 --
2807
2808 CREATE UNIQUE INDEX idx_2198199_k ON settings USING btree (k);
2809
2810
2811 --
2812 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2813 --
2814
2815 CREATE UNIQUE INDEX idx_2198213_identifier ON sources USING btree (identifier);
2816
2817
2818 --
2819 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2820 --
2821
2822 CREATE INDEX idx_2198222_revision ON sources_commits USING btree (revision);
2823
2824
2825 --
2826 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2827 --
2828
2829 CREATE UNIQUE INDEX idx_2198232_uuid ON uploads USING btree (uuid);
2830
2831
2832 --
2833 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2834 --
2835
2836 CREATE UNIQUE INDEX idx_2198244_name ON users USING btree (name);
2837
2838
2839 --
2840 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2841 --
2842
2843 CREATE UNIQUE INDEX idx_2198256_email ON users_emails USING btree (email);
2844
2845
2846 --
2847 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2848 --
2849
2850 CREATE INDEX idx_2198256_user_id ON users_emails USING btree (user_id);
2851
2852
2853 --
2854 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2855 --
2856
2857 CREATE INDEX jobs_arch ON jobs USING btree (arch);
2858
2859
2860 --
2861 -- Name: jobs_buildroots_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2862 --
2863
2864 CREATE INDEX jobs_buildroots_job_id ON jobs_buildroots USING btree (job_id);
2865
2866 ALTER TABLE jobs_buildroots CLUSTER ON jobs_buildroots_job_id;
2867
2868
2869 --
2870 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2871 --
2872
2873 CREATE INDEX jobs_buildroots_pkg_uuid ON jobs_buildroots USING btree (pkg_uuid);
2874
2875
2876 --
2877 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2878 --
2879
2880 CREATE INDEX mirrors_checks_sort ON mirrors_checks USING btree (mirror_id, "timestamp");
2881
2882 ALTER TABLE mirrors_checks CLUSTER ON mirrors_checks_sort;
2883
2884
2885 --
2886 -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2887 --
2888
2889 CREATE INDEX repositories_builds_repo_id ON repositories_builds USING btree (repo_id);
2890
2891
2892 --
2893 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
2894 --
2895
2896 CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON sources FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
2897
2898
2899 --
2900 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2901 --
2902
2903 ALTER TABLE ONLY arches_compat
2904     ADD CONSTRAINT arches_compat_build_arch FOREIGN KEY (build_arch) REFERENCES arches(name);
2905
2906
2907 --
2908 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2909 --
2910
2911 ALTER TABLE ONLY builders_history
2912     ADD CONSTRAINT builders_history_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
2913
2914
2915 --
2916 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2917 --
2918
2919 ALTER TABLE ONLY builders_history
2920     ADD CONSTRAINT builders_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2921
2922
2923 --
2924 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2925 --
2926
2927 ALTER TABLE ONLY builds_bugs
2928     ADD CONSTRAINT builds_bug_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2929
2930
2931 --
2932 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2933 --
2934
2935 ALTER TABLE ONLY builds_comments
2936     ADD CONSTRAINT builds_comments_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2937
2938
2939 --
2940 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2941 --
2942
2943 ALTER TABLE ONLY builds_comments
2944     ADD CONSTRAINT builds_comments_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2945
2946
2947 --
2948 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2949 --
2950
2951 ALTER TABLE ONLY builds
2952     ADD CONSTRAINT builds_depends_on FOREIGN KEY (depends_on) REFERENCES builds(id);
2953
2954
2955 --
2956 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2957 --
2958
2959 ALTER TABLE ONLY builds
2960     ADD CONSTRAINT builds_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
2961
2962
2963 --
2964 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2965 --
2966
2967 ALTER TABLE ONLY builds_history
2968     ADD CONSTRAINT builds_history_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2969
2970
2971 --
2972 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2973 --
2974
2975 ALTER TABLE ONLY builds_history
2976     ADD CONSTRAINT builds_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2977
2978
2979 --
2980 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2981 --
2982
2983 ALTER TABLE ONLY builds
2984     ADD CONSTRAINT builds_owner_id FOREIGN KEY (owner_id) REFERENCES users(id);
2985
2986
2987 --
2988 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2989 --
2990
2991 ALTER TABLE ONLY builds
2992     ADD CONSTRAINT builds_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
2993
2994
2995 --
2996 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2997 --
2998
2999 ALTER TABLE ONLY builds_watchers
3000     ADD CONSTRAINT builds_watchers_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3001
3002
3003 --
3004 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3005 --
3006
3007 ALTER TABLE ONLY builds_watchers
3008     ADD CONSTRAINT builds_watchers_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3009
3010
3011 --
3012 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3013 --
3014
3015 ALTER TABLE ONLY distributions_arches
3016     ADD CONSTRAINT distributions_arches_arch FOREIGN KEY (arch) REFERENCES arches(name);
3017
3018
3019 --
3020 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3021 --
3022
3023 ALTER TABLE ONLY distributions_arches
3024     ADD CONSTRAINT distro_arches_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3025
3026
3027 --
3028 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3029 --
3030
3031 ALTER TABLE ONLY filelists
3032     ADD CONSTRAINT filelists_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3033
3034
3035 --
3036 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3037 --
3038
3039 ALTER TABLE ONLY jobs
3040     ADD CONSTRAINT jobs_arch FOREIGN KEY (arch) REFERENCES arches(name);
3041
3042
3043 --
3044 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3045 --
3046
3047 ALTER TABLE ONLY jobs
3048     ADD CONSTRAINT jobs_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3049
3050
3051 --
3052 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3053 --
3054
3055 ALTER TABLE ONLY jobs
3056     ADD CONSTRAINT jobs_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3057
3058
3059 --
3060 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3061 --
3062
3063 ALTER TABLE ONLY jobs_buildroots
3064     ADD CONSTRAINT jobs_buildroots_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3065
3066
3067 --
3068 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3069 --
3070
3071 ALTER TABLE ONLY jobs_history
3072     ADD CONSTRAINT jobs_history_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3073
3074
3075 --
3076 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3077 --
3078
3079 ALTER TABLE ONLY jobs_history
3080     ADD CONSTRAINT jobs_history_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3081
3082
3083 --
3084 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3085 --
3086
3087 ALTER TABLE ONLY jobs_history
3088     ADD CONSTRAINT jobs_history_test_job_id FOREIGN KEY (test_job_id) REFERENCES jobs(id);
3089
3090
3091 --
3092 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3093 --
3094
3095 ALTER TABLE ONLY jobs_history
3096     ADD CONSTRAINT jobs_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3097
3098
3099 --
3100 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3101 --
3102
3103 ALTER TABLE ONLY jobs_packages
3104     ADD CONSTRAINT jobs_packaged_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3105
3106
3107 --
3108 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3109 --
3110
3111 ALTER TABLE ONLY jobs_packages
3112     ADD CONSTRAINT jobs_packages_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3113
3114
3115 --
3116 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3117 --
3118
3119 ALTER TABLE ONLY jobs_repos
3120     ADD CONSTRAINT jobs_repos_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3121
3122
3123 --
3124 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3125 --
3126
3127 ALTER TABLE ONLY jobs_repos
3128     ADD CONSTRAINT jobs_repos_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
3129
3130
3131 --
3132 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3133 --
3134
3135 ALTER TABLE ONLY keys_subkeys
3136     ADD CONSTRAINT keys_subkeys_key_id FOREIGN KEY (key_id) REFERENCES keys(id);
3137
3138
3139 --
3140 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3141 --
3142
3143 ALTER TABLE ONLY logfiles
3144     ADD CONSTRAINT logfiles_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3145
3146
3147 --
3148 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3149 --
3150
3151 ALTER TABLE ONLY mirrors_checks
3152     ADD CONSTRAINT mirrors_checks_mirror_id FOREIGN KEY (mirror_id) REFERENCES mirrors(id);
3153
3154
3155 --
3156 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3157 --
3158
3159 ALTER TABLE ONLY mirrors_history
3160     ADD CONSTRAINT mirrors_history_mirror_id FOREIGN KEY (mirror_id) REFERENCES mirrors(id);
3161
3162
3163 --
3164 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3165 --
3166
3167 ALTER TABLE ONLY mirrors_history
3168     ADD CONSTRAINT mirrors_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3169
3170
3171 --
3172 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3173 --
3174
3175 ALTER TABLE ONLY packages
3176     ADD CONSTRAINT packages_arch FOREIGN KEY (arch) REFERENCES arches(name);
3177
3178
3179 --
3180 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3181 --
3182
3183 ALTER TABLE ONLY packages
3184     ADD CONSTRAINT packages_commit_id FOREIGN KEY (commit_id) REFERENCES sources_commits(id);
3185
3186
3187 --
3188 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3189 --
3190
3191 ALTER TABLE ONLY packages_deps
3192     ADD CONSTRAINT packages_deps_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3193
3194
3195 --
3196 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3197 --
3198
3199 ALTER TABLE ONLY repositories_aux
3200     ADD CONSTRAINT repositories_aux_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3201
3202
3203 --
3204 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3205 --
3206
3207 ALTER TABLE ONLY repositories_builds
3208     ADD CONSTRAINT repositories_builds_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3209
3210
3211 --
3212 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3213 --
3214
3215 ALTER TABLE ONLY repositories_builds
3216     ADD CONSTRAINT repositories_builds_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
3217
3218
3219 --
3220 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3221 --
3222
3223 ALTER TABLE ONLY repositories
3224     ADD CONSTRAINT repositories_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3225
3226
3227 --
3228 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3229 --
3230
3231 ALTER TABLE ONLY repositories_history
3232     ADD CONSTRAINT repositories_history_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3233
3234
3235 --
3236 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3237 --
3238
3239 ALTER TABLE ONLY repositories_history
3240     ADD CONSTRAINT repositories_history_from_repo_id FOREIGN KEY (from_repo_id) REFERENCES repositories(id);
3241
3242
3243 --
3244 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3245 --
3246
3247 ALTER TABLE ONLY repositories_history
3248     ADD CONSTRAINT repositories_history_to_repo_id FOREIGN KEY (to_repo_id) REFERENCES repositories(id);
3249
3250
3251 --
3252 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3253 --
3254
3255 ALTER TABLE ONLY repositories_history
3256     ADD CONSTRAINT repositories_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3257
3258
3259 --
3260 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3261 --
3262
3263 ALTER TABLE ONLY repositories
3264     ADD CONSTRAINT repositories_key_id FOREIGN KEY (key_id) REFERENCES keys(id);
3265
3266
3267 --
3268 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3269 --
3270
3271 ALTER TABLE ONLY repositories
3272     ADD CONSTRAINT repositories_parent_id FOREIGN KEY (parent_id) REFERENCES repositories(id);
3273
3274
3275 --
3276 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3277 --
3278
3279 ALTER TABLE ONLY sessions
3280     ADD CONSTRAINT sessions_impersonated_user_id FOREIGN KEY (impersonated_user_id) REFERENCES users(id);
3281
3282
3283 --
3284 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3285 --
3286
3287 ALTER TABLE ONLY sessions
3288     ADD CONSTRAINT sessions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3289
3290
3291 --
3292 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3293 --
3294
3295 ALTER TABLE ONLY sources_commits
3296     ADD CONSTRAINT sources_commits_source_id FOREIGN KEY (source_id) REFERENCES sources(id);
3297
3298
3299 --
3300 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3301 --
3302
3303 ALTER TABLE ONLY sources
3304     ADD CONSTRAINT sources_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3305
3306
3307 --
3308 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3309 --
3310
3311 ALTER TABLE ONLY uploads
3312     ADD CONSTRAINT uploads_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3313
3314
3315 --
3316 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3317 --
3318
3319 ALTER TABLE ONLY uploads
3320     ADD CONSTRAINT uploads_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3321
3322
3323 --
3324 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3325 --
3326
3327 ALTER TABLE ONLY users_emails
3328     ADD CONSTRAINT users_emails_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3329
3330
3331 --
3332 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3333 --
3334
3335 ALTER TABLE ONLY users_permissions
3336     ADD CONSTRAINT users_permissions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3337
3338
3339 --
3340 -- PostgreSQL database dump complete
3341 --
3342