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     deleted_at timestamp without time zone
 856 );
 857
 858
 859 ALTER TABLE jobs OWNER TO pakfire;
 860
 861 --
 862 -- Name: builds_times; Type: VIEW; Schema: public; Owner: pakfire
 863 --
 864
 865 CREATE VIEW builds_times AS
 866  SELECT jobs.build_id,
 867     jobs.arch,
 868     (jobs.time_finished - jobs.time_started) AS duration
 869    FROM jobs
 870   WHERE (((jobs.deleted_at IS NULL) AND (jobs.test IS FALSE)) AND (jobs.state = 'finished'::jobs_state));
 871
 872
 873 ALTER TABLE builds_times OWNER TO pakfire;
 874
 875 --
 876 -- Name: builds_watchers; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 877 --
 878
 879 CREATE TABLE builds_watchers (
 880     id integer NOT NULL,
 881     build_id integer NOT NULL,
 882     user_id integer NOT NULL
 883 );
 884
 885
 886 ALTER TABLE builds_watchers OWNER TO pakfire;
 887
 888 --
 889 -- Name: builds_watchers_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 890 --
 891
 892 CREATE SEQUENCE builds_watchers_id_seq
 893     START WITH 1
 894     INCREMENT BY 1
 895     NO MINVALUE
 896     NO MAXVALUE
 897     CACHE 1;
 898
 899
 900 ALTER TABLE builds_watchers_id_seq OWNER TO pakfire;
 901
 902 --
 903 -- Name: builds_watchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 904 --
 905
 906 ALTER SEQUENCE builds_watchers_id_seq OWNED BY builds_watchers.id;
 907
 908
 909 --
 910 -- Name: distributions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 911 --
 912
 913 CREATE TABLE distributions (
 914     id integer NOT NULL,
 915     name text NOT NULL,
 916     sname text NOT NULL,
 917     slogan text NOT NULL,
 918     description text,
 919     vendor text NOT NULL,
 920     contact text,
 921     tag text NOT NULL,
 922     deleted boolean DEFAULT false NOT NULL
 923 );
 924
 925
 926 ALTER TABLE distributions OWNER TO pakfire;
 927
 928 --
 929 -- Name: distributions_arches; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 930 --
 931
 932 CREATE TABLE distributions_arches (
 933     id integer NOT NULL,
 934     distro_id integer NOT NULL,
 935     arch text NOT NULL
 936 );
 937
 938
 939 ALTER TABLE distributions_arches OWNER TO pakfire;
 940
 941 --
 942 -- Name: distributions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 943 --
 944
 945 CREATE SEQUENCE distributions_id_seq
 946     START WITH 1
 947     INCREMENT BY 1
 948     NO MINVALUE
 949     NO MAXVALUE
 950     CACHE 1;
 951
 952
 953 ALTER TABLE distributions_id_seq OWNER TO pakfire;
 954
 955 --
 956 -- Name: distributions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 957 --
 958
 959 ALTER SEQUENCE distributions_id_seq OWNED BY distributions.id;
 960
 961
 962 --
 963 -- Name: distro_arches_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
 964 --
 965
 966 CREATE SEQUENCE distro_arches_id_seq
 967     START WITH 1
 968     INCREMENT BY 1
 969     NO MINVALUE
 970     NO MAXVALUE
 971     CACHE 1;
 972
 973
 974 ALTER TABLE distro_arches_id_seq OWNER TO pakfire;
 975
 976 --
 977 -- Name: distro_arches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
 978 --
 979
 980 ALTER SEQUENCE distro_arches_id_seq OWNED BY distributions_arches.id;
 981
 982
 983 --
 984 -- Name: filelists; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
 985 --
 986
 987 CREATE TABLE filelists (
 988     pkg_id integer NOT NULL,
 989     name text NOT NULL,
 990     size bigint NOT NULL,
 991     hash_sha512 text,
 992     type integer NOT NULL,
 993     config boolean NOT NULL,
 994     mode integer NOT NULL,
 995     "user" text NOT NULL,
 996     "group" text NOT NULL,
 997     mtime timestamp without time zone NOT NULL,
 998     capabilities text
 999 );
1000
1001
1002 ALTER TABLE filelists OWNER TO pakfire;
1003
1004 --
1005 -- Name: images_types; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1006 --
1007
1008 CREATE TABLE images_types (
1009     id integer NOT NULL,
1010     type text NOT NULL
1011 );
1012
1013
1014 ALTER TABLE images_types OWNER TO pakfire;
1015
1016 --
1017 -- Name: images_types_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1018 --
1019
1020 CREATE SEQUENCE images_types_id_seq
1021     START WITH 1
1022     INCREMENT BY 1
1023     NO MINVALUE
1024     NO MAXVALUE
1025     CACHE 1;
1026
1027
1028 ALTER TABLE images_types_id_seq OWNER TO pakfire;
1029
1030 --
1031 -- Name: images_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1032 --
1033
1034 ALTER SEQUENCE images_types_id_seq OWNED BY images_types.id;
1035
1036
1037 --
1038 -- Name: jobs_active; Type: VIEW; Schema: public; Owner: pakfire
1039 --
1040
1041 CREATE VIEW jobs_active AS
1042  SELECT jobs.id,
1043     jobs.uuid,
1044     jobs.build_id,
1045     jobs.state,
1046     jobs.arch,
1047     jobs.time_created,
1048     jobs.time_started,
1049     jobs.time_finished,
1050     jobs.start_not_before,
1051     jobs.builder_id,
1052     jobs.aborted_state,
1053     jobs.message
1054    FROM jobs
1055   WHERE (jobs.state = ANY (ARRAY['dispatching'::jobs_state, 'running'::jobs_state, 'uploading'::jobs_state]))
1056   ORDER BY jobs.time_started;
1057
1058
1059 ALTER TABLE jobs_active OWNER TO pakfire;
1060
1061 --
1062 -- Name: jobs_buildroots; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1063 --
1064
1065 CREATE TABLE jobs_buildroots (
1066     job_id integer NOT NULL,
1067     pkg_uuid text NOT NULL,
1068     pkg_name text NOT NULL
1069 );
1070
1071
1072 ALTER TABLE jobs_buildroots OWNER TO pakfire;
1073
1074 --
1075 -- Name: jobs_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1076 --
1077
1078 CREATE TABLE jobs_history (
1079     job_id integer NOT NULL,
1080     action jobs_history_action NOT NULL,
1081     state jobs_history_state,
1082     user_id integer,
1083     "time" timestamp without time zone NOT NULL,
1084     builder_id integer,
1085     test_job_id integer
1086 );
1087
1088
1089 ALTER TABLE jobs_history OWNER TO pakfire;
1090
1091 --
1092 -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1093 --
1094
1095 CREATE SEQUENCE jobs_id_seq
1096     START WITH 1
1097     INCREMENT BY 1
1098     NO MINVALUE
1099     NO MAXVALUE
1100     CACHE 1;
1101
1102
1103 ALTER TABLE jobs_id_seq OWNER TO pakfire;
1104
1105 --
1106 -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1107 --
1108
1109 ALTER SEQUENCE jobs_id_seq OWNED BY jobs.id;
1110
1111
1112 --
1113 -- Name: jobs_packages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1114 --
1115
1116 CREATE TABLE jobs_packages (
1117     id integer NOT NULL,
1118     job_id integer NOT NULL,
1119     pkg_id integer NOT NULL
1120 );
1121
1122
1123 ALTER TABLE jobs_packages OWNER TO pakfire;
1124
1125 --
1126 -- Name: jobs_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1127 --
1128
1129 CREATE SEQUENCE jobs_packages_id_seq
1130     START WITH 1
1131     INCREMENT BY 1
1132     NO MINVALUE
1133     NO MAXVALUE
1134     CACHE 1;
1135
1136
1137 ALTER TABLE jobs_packages_id_seq OWNER TO pakfire;
1138
1139 --
1140 -- Name: jobs_packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1141 --
1142
1143 ALTER SEQUENCE jobs_packages_id_seq OWNED BY jobs_packages.id;
1144
1145
1146 --
1147 -- Name: jobs_queue; Type: VIEW; Schema: public; Owner: pakfire
1148 --
1149
1150 CREATE VIEW jobs_queue AS
1151  WITH queue AS (
1152          SELECT jobs.id,
1153             rank() OVER (ORDER BY (NOT jobs.test), builds.priority DESC, jobs.time_created) AS rank
1154            FROM (jobs
1155              LEFT JOIN builds ON ((jobs.build_id = builds.id)))
1156           WHERE (jobs.state = 'pending'::jobs_state)
1157         )
1158  SELECT queue.id AS job_id,
1159     queue.rank
1160    FROM queue;
1161
1162
1163 ALTER TABLE jobs_queue OWNER TO pakfire;
1164
1165 --
1166 -- Name: jobs_repos; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1167 --
1168
1169 CREATE TABLE jobs_repos (
1170     job_id integer NOT NULL,
1171     repo_id integer NOT NULL
1172 );
1173
1174
1175 ALTER TABLE jobs_repos OWNER TO pakfire;
1176
1177 --
1178 -- Name: keys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1179 --
1180
1181 CREATE TABLE keys (
1182     id integer NOT NULL,
1183     fingerprint text NOT NULL,
1184     uids text NOT NULL,
1185     data text NOT NULL
1186 );
1187
1188
1189 ALTER TABLE keys OWNER TO pakfire;
1190
1191 --
1192 -- Name: keys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1193 --
1194
1195 CREATE SEQUENCE keys_id_seq
1196     START WITH 1
1197     INCREMENT BY 1
1198     NO MINVALUE
1199     NO MAXVALUE
1200     CACHE 1;
1201
1202
1203 ALTER TABLE keys_id_seq OWNER TO pakfire;
1204
1205 --
1206 -- Name: keys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1207 --
1208
1209 ALTER SEQUENCE keys_id_seq OWNED BY keys.id;
1210
1211
1212 --
1213 -- Name: keys_subkeys; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1214 --
1215
1216 CREATE TABLE keys_subkeys (
1217     id integer NOT NULL,
1218     key_id integer NOT NULL,
1219     fingerprint text NOT NULL,
1220     time_created timestamp without time zone NOT NULL,
1221     time_expires timestamp without time zone,
1222     algo text
1223 );
1224
1225
1226 ALTER TABLE keys_subkeys OWNER TO pakfire;
1227
1228 --
1229 -- Name: keys_subkeys_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1230 --
1231
1232 CREATE SEQUENCE keys_subkeys_id_seq
1233     START WITH 1
1234     INCREMENT BY 1
1235     NO MINVALUE
1236     NO MAXVALUE
1237     CACHE 1;
1238
1239
1240 ALTER TABLE keys_subkeys_id_seq OWNER TO pakfire;
1241
1242 --
1243 -- Name: keys_subkeys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1244 --
1245
1246 ALTER SEQUENCE keys_subkeys_id_seq OWNED BY keys_subkeys.id;
1247
1248
1249 --
1250 -- Name: logfiles; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1251 --
1252
1253 CREATE TABLE logfiles (
1254     id integer NOT NULL,
1255     job_id integer NOT NULL,
1256     path text NOT NULL,
1257     filesize bigint NOT NULL,
1258     hash_sha512 text NOT NULL
1259 );
1260
1261
1262 ALTER TABLE logfiles OWNER TO pakfire;
1263
1264 --
1265 -- Name: logfiles_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1266 --
1267
1268 CREATE SEQUENCE logfiles_id_seq
1269     START WITH 1
1270     INCREMENT BY 1
1271     NO MINVALUE
1272     NO MAXVALUE
1273     CACHE 1;
1274
1275
1276 ALTER TABLE logfiles_id_seq OWNER TO pakfire;
1277
1278 --
1279 -- Name: logfiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1280 --
1281
1282 ALTER SEQUENCE logfiles_id_seq OWNED BY logfiles.id;
1283
1284
1285 --
1286 -- Name: mirrors; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1287 --
1288
1289 CREATE TABLE mirrors (
1290     id integer NOT NULL,
1291     hostname text NOT NULL,
1292     path text NOT NULL,
1293     owner text,
1294     contact text,
1295     deleted 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 );
1568
1569
1570 ALTER TABLE repositories OWNER TO pakfire;
1571
1572 --
1573 -- Name: repositories_aux; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1574 --
1575
1576 CREATE TABLE repositories_aux (
1577     id integer NOT NULL,
1578     name text NOT NULL,
1579     description text,
1580     url text NOT NULL,
1581     distro_id integer NOT NULL,
1582     status repositories_aux_status DEFAULT 'disabled'::repositories_aux_status NOT NULL
1583 );
1584
1585
1586 ALTER TABLE repositories_aux OWNER TO pakfire;
1587
1588 --
1589 -- Name: repositories_aux_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1590 --
1591
1592 CREATE SEQUENCE repositories_aux_id_seq
1593     START WITH 1
1594     INCREMENT BY 1
1595     NO MINVALUE
1596     NO MAXVALUE
1597     CACHE 1;
1598
1599
1600 ALTER TABLE repositories_aux_id_seq OWNER TO pakfire;
1601
1602 --
1603 -- Name: repositories_aux_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1604 --
1605
1606 ALTER SEQUENCE repositories_aux_id_seq OWNED BY repositories_aux.id;
1607
1608
1609 --
1610 -- Name: repositories_builds; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1611 --
1612
1613 CREATE TABLE repositories_builds (
1614     id integer NOT NULL,
1615     repo_id integer NOT NULL,
1616     build_id bigint NOT NULL,
1617     time_added timestamp without time zone NOT NULL
1618 );
1619
1620
1621 ALTER TABLE repositories_builds OWNER TO pakfire;
1622
1623 --
1624 -- Name: repositories_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1625 --
1626
1627 CREATE SEQUENCE repositories_builds_id_seq
1628     START WITH 1
1629     INCREMENT BY 1
1630     NO MINVALUE
1631     NO MAXVALUE
1632     CACHE 1;
1633
1634
1635 ALTER TABLE repositories_builds_id_seq OWNER TO pakfire;
1636
1637 --
1638 -- Name: repositories_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1639 --
1640
1641 ALTER SEQUENCE repositories_builds_id_seq OWNED BY repositories_builds.id;
1642
1643
1644 --
1645 -- Name: repositories_history; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1646 --
1647
1648 CREATE TABLE repositories_history (
1649     build_id bigint NOT NULL,
1650     action repositories_history_action NOT NULL,
1651     from_repo_id integer,
1652     to_repo_id integer,
1653     user_id integer,
1654     "time" timestamp without time zone NOT NULL
1655 );
1656
1657
1658 ALTER TABLE repositories_history OWNER TO pakfire;
1659
1660 --
1661 -- Name: repositories_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1662 --
1663
1664 CREATE SEQUENCE repositories_id_seq
1665     START WITH 1
1666     INCREMENT BY 1
1667     NO MINVALUE
1668     NO MAXVALUE
1669     CACHE 1;
1670
1671
1672 ALTER TABLE repositories_id_seq OWNER TO pakfire;
1673
1674 --
1675 -- Name: repositories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1676 --
1677
1678 ALTER SEQUENCE repositories_id_seq OWNED BY repositories.id;
1679
1680
1681 --
1682 -- Name: sessions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1683 --
1684
1685 CREATE TABLE sessions (
1686     id integer NOT NULL,
1687     session_id text NOT NULL,
1688     created_at timestamp without time zone DEFAULT now() NOT NULL,
1689     valid_until timestamp without time zone DEFAULT (now() + '7 days'::interval) NOT NULL,
1690     user_id integer NOT NULL,
1691     impersonated_user_id integer,
1692     address inet,
1693     user_agent text,
1694     CONSTRAINT sessions_impersonation_check CHECK (((impersonated_user_id IS NULL) OR (user_id <> impersonated_user_id)))
1695 );
1696
1697
1698 ALTER TABLE sessions OWNER TO pakfire;
1699
1700 --
1701 -- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1702 --
1703
1704 CREATE SEQUENCE sessions_id_seq
1705     START WITH 1
1706     INCREMENT BY 1
1707     NO MINVALUE
1708     NO MAXVALUE
1709     CACHE 1;
1710
1711
1712 ALTER TABLE sessions_id_seq OWNER TO pakfire;
1713
1714 --
1715 -- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1716 --
1717
1718 ALTER SEQUENCE sessions_id_seq OWNED BY sessions.id;
1719
1720
1721 --
1722 -- Name: settings; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1723 --
1724
1725 CREATE TABLE settings (
1726     k text NOT NULL,
1727     v text NOT NULL
1728 );
1729
1730
1731 ALTER TABLE settings OWNER TO pakfire;
1732
1733 --
1734 -- Name: slogans; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1735 --
1736
1737 CREATE TABLE slogans (
1738     id integer NOT NULL,
1739     message text NOT NULL
1740 );
1741
1742
1743 ALTER TABLE slogans OWNER TO pakfire;
1744
1745 --
1746 -- Name: slogans_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1747 --
1748
1749 CREATE SEQUENCE slogans_id_seq
1750     START WITH 1
1751     INCREMENT BY 1
1752     NO MINVALUE
1753     NO MAXVALUE
1754     CACHE 1;
1755
1756
1757 ALTER TABLE slogans_id_seq OWNER TO pakfire;
1758
1759 --
1760 -- Name: slogans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1761 --
1762
1763 ALTER SEQUENCE slogans_id_seq OWNED BY slogans.id;
1764
1765
1766 --
1767 -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1768 --
1769
1770 CREATE TABLE sources (
1771     id integer NOT NULL,
1772     name text NOT NULL,
1773     identifier text NOT NULL,
1774     url text NOT NULL,
1775     gitweb text,
1776     revision text NOT NULL,
1777     branch text NOT NULL,
1778     updated timestamp without time zone,
1779     distro_id integer NOT NULL
1780 );
1781
1782
1783 ALTER TABLE sources OWNER TO pakfire;
1784
1785 --
1786 -- Name: sources_commits; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1787 --
1788
1789 CREATE TABLE sources_commits (
1790     id integer NOT NULL,
1791     source_id integer NOT NULL,
1792     revision text NOT NULL,
1793     author text NOT NULL,
1794     committer text NOT NULL,
1795     subject text NOT NULL,
1796     body text NOT NULL,
1797     date timestamp without time zone NOT NULL,
1798     state sources_commits_state DEFAULT 'pending'::sources_commits_state NOT NULL,
1799     imported_at timestamp without time zone DEFAULT now() NOT NULL
1800 );
1801
1802
1803 ALTER TABLE sources_commits OWNER TO pakfire;
1804
1805 --
1806 -- Name: sources_commits_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1807 --
1808
1809 CREATE SEQUENCE sources_commits_id_seq
1810     START WITH 1
1811     INCREMENT BY 1
1812     NO MINVALUE
1813     NO MAXVALUE
1814     CACHE 1;
1815
1816
1817 ALTER TABLE sources_commits_id_seq OWNER TO pakfire;
1818
1819 --
1820 -- Name: sources_commits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1821 --
1822
1823 ALTER SEQUENCE sources_commits_id_seq OWNED BY sources_commits.id;
1824
1825
1826 --
1827 -- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1828 --
1829
1830 CREATE SEQUENCE sources_id_seq
1831     START WITH 1
1832     INCREMENT BY 1
1833     NO MINVALUE
1834     NO MAXVALUE
1835     CACHE 1;
1836
1837
1838 ALTER TABLE sources_id_seq OWNER TO pakfire;
1839
1840 --
1841 -- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1842 --
1843
1844 ALTER SEQUENCE sources_id_seq OWNED BY sources.id;
1845
1846
1847 --
1848 -- Name: uploads; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1849 --
1850
1851 CREATE TABLE uploads (
1852     id integer NOT NULL,
1853     uuid text NOT NULL,
1854     user_id integer,
1855     builder_id integer,
1856     filename text NOT NULL,
1857     hash text NOT NULL,
1858     size bigint NOT NULL,
1859     progress bigint DEFAULT 0 NOT NULL,
1860     finished boolean DEFAULT false NOT NULL,
1861     time_started timestamp without time zone DEFAULT now() NOT NULL,
1862     time_finished timestamp without time zone
1863 );
1864
1865
1866 ALTER TABLE uploads OWNER TO pakfire;
1867
1868 --
1869 -- Name: uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1870 --
1871
1872 CREATE SEQUENCE uploads_id_seq
1873     START WITH 1
1874     INCREMENT BY 1
1875     NO MINVALUE
1876     NO MAXVALUE
1877     CACHE 1;
1878
1879
1880 ALTER TABLE uploads_id_seq OWNER TO pakfire;
1881
1882 --
1883 -- Name: uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1884 --
1885
1886 ALTER SEQUENCE uploads_id_seq OWNED BY uploads.id;
1887
1888
1889 --
1890 -- Name: user_messages; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1891 --
1892
1893 CREATE TABLE user_messages (
1894     id integer NOT NULL,
1895     frm text NOT NULL,
1896     "to" text NOT NULL,
1897     subject text NOT NULL,
1898     text text NOT NULL,
1899     time_added timestamp without time zone DEFAULT now() NOT NULL
1900 );
1901
1902
1903 ALTER TABLE user_messages OWNER TO pakfire;
1904
1905 --
1906 -- Name: user_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1907 --
1908
1909 CREATE SEQUENCE user_messages_id_seq
1910     START WITH 1
1911     INCREMENT BY 1
1912     NO MINVALUE
1913     NO MAXVALUE
1914     CACHE 1;
1915
1916
1917 ALTER TABLE user_messages_id_seq OWNER TO pakfire;
1918
1919 --
1920 -- Name: user_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1921 --
1922
1923 ALTER SEQUENCE user_messages_id_seq OWNED BY user_messages.id;
1924
1925
1926 --
1927 -- Name: users; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1928 --
1929
1930 CREATE TABLE users (
1931     id integer NOT NULL,
1932     name text NOT NULL,
1933     realname text,
1934     passphrase text NOT NULL,
1935     state users_state NOT NULL,
1936     locale text,
1937     timezone text,
1938     activated users_activated DEFAULT 'N'::users_activated NOT NULL,
1939     activation_code text,
1940     deleted users_deleted DEFAULT 'N'::users_deleted NOT NULL,
1941     registered timestamp without time zone DEFAULT now() NOT NULL
1942 );
1943
1944
1945 ALTER TABLE users OWNER TO pakfire;
1946
1947 --
1948 -- Name: users_emails; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
1949 --
1950
1951 CREATE TABLE users_emails (
1952     id integer NOT NULL,
1953     user_id integer NOT NULL,
1954     email text NOT NULL,
1955     "primary" users_emails_primary DEFAULT 'N'::users_emails_primary NOT NULL
1956 );
1957
1958
1959 ALTER TABLE users_emails OWNER TO pakfire;
1960
1961 --
1962 -- Name: users_emails_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1963 --
1964
1965 CREATE SEQUENCE users_emails_id_seq
1966     START WITH 1
1967     INCREMENT BY 1
1968     NO MINVALUE
1969     NO MAXVALUE
1970     CACHE 1;
1971
1972
1973 ALTER TABLE users_emails_id_seq OWNER TO pakfire;
1974
1975 --
1976 -- Name: users_emails_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1977 --
1978
1979 ALTER SEQUENCE users_emails_id_seq OWNED BY users_emails.id;
1980
1981
1982 --
1983 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
1984 --
1985
1986 CREATE SEQUENCE users_id_seq
1987     START WITH 1
1988     INCREMENT BY 1
1989     NO MINVALUE
1990     NO MAXVALUE
1991     CACHE 1;
1992
1993
1994 ALTER TABLE users_id_seq OWNER TO pakfire;
1995
1996 --
1997 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
1998 --
1999
2000 ALTER SEQUENCE users_id_seq OWNED BY users.id;
2001
2002
2003 --
2004 -- Name: users_permissions; Type: TABLE; Schema: public; Owner: pakfire; Tablespace:
2005 --
2006
2007 CREATE TABLE users_permissions (
2008     id integer NOT NULL,
2009     user_id integer NOT NULL,
2010     create_scratch_builds users_permissions_create_scratch_builds DEFAULT 'N'::users_permissions_create_scratch_builds NOT NULL,
2011     maintain_builders users_permissions_maintain_builders DEFAULT 'N'::users_permissions_maintain_builders NOT NULL,
2012     manage_critical_path users_permissions_manage_critical_path DEFAULT 'N'::users_permissions_manage_critical_path NOT NULL,
2013     manage_mirrors users_permissions_manage_mirrors DEFAULT 'N'::users_permissions_manage_mirrors NOT NULL,
2014     vote users_permissions_vote DEFAULT 'N'::users_permissions_vote NOT NULL
2015 );
2016
2017
2018 ALTER TABLE users_permissions OWNER TO pakfire;
2019
2020 --
2021 -- Name: users_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire
2022 --
2023
2024 CREATE SEQUENCE users_permissions_id_seq
2025     START WITH 1
2026     INCREMENT BY 1
2027     NO MINVALUE
2028     NO MAXVALUE
2029     CACHE 1;
2030
2031
2032 ALTER TABLE users_permissions_id_seq OWNER TO pakfire;
2033
2034 --
2035 -- Name: users_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire
2036 --
2037
2038 ALTER SEQUENCE users_permissions_id_seq OWNED BY users_permissions.id;
2039
2040
2041 --
2042 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2043 --
2044
2045 ALTER TABLE ONLY arches ALTER COLUMN id SET DEFAULT nextval('arches_id_seq'::regclass);
2046
2047
2048 --
2049 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2050 --
2051
2052 ALTER TABLE ONLY builders ALTER COLUMN id SET DEFAULT nextval('builders_id_seq'::regclass);
2053
2054
2055 --
2056 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2057 --
2058
2059 ALTER TABLE ONLY builders_history ALTER COLUMN id SET DEFAULT nextval('builders_history_id_seq'::regclass);
2060
2061
2062 --
2063 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2064 --
2065
2066 ALTER TABLE ONLY builds ALTER COLUMN id SET DEFAULT nextval('builds_id_seq'::regclass);
2067
2068
2069 --
2070 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2071 --
2072
2073 ALTER TABLE ONLY builds_bugs ALTER COLUMN id SET DEFAULT nextval('builds_bugs_id_seq'::regclass);
2074
2075
2076 --
2077 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2078 --
2079
2080 ALTER TABLE ONLY builds_bugs_updates ALTER COLUMN id SET DEFAULT nextval('builds_bugs_updates_id_seq'::regclass);
2081
2082
2083 --
2084 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2085 --
2086
2087 ALTER TABLE ONLY builds_comments ALTER COLUMN id SET DEFAULT nextval('builds_comments_id_seq'::regclass);
2088
2089
2090 --
2091 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2092 --
2093
2094 ALTER TABLE ONLY builds_history ALTER COLUMN id SET DEFAULT nextval('builds_history_id_seq'::regclass);
2095
2096
2097 --
2098 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2099 --
2100
2101 ALTER TABLE ONLY builds_watchers ALTER COLUMN id SET DEFAULT nextval('builds_watchers_id_seq'::regclass);
2102
2103
2104 --
2105 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2106 --
2107
2108 ALTER TABLE ONLY distributions ALTER COLUMN id SET DEFAULT nextval('distributions_id_seq'::regclass);
2109
2110
2111 --
2112 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2113 --
2114
2115 ALTER TABLE ONLY distributions_arches ALTER COLUMN id SET DEFAULT nextval('distro_arches_id_seq'::regclass);
2116
2117
2118 --
2119 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2120 --
2121
2122 ALTER TABLE ONLY images_types ALTER COLUMN id SET DEFAULT nextval('images_types_id_seq'::regclass);
2123
2124
2125 --
2126 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2127 --
2128
2129 ALTER TABLE ONLY jobs ALTER COLUMN id SET DEFAULT nextval('jobs_id_seq'::regclass);
2130
2131
2132 --
2133 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2134 --
2135
2136 ALTER TABLE ONLY jobs_packages ALTER COLUMN id SET DEFAULT nextval('jobs_packages_id_seq'::regclass);
2137
2138
2139 --
2140 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2141 --
2142
2143 ALTER TABLE ONLY keys ALTER COLUMN id SET DEFAULT nextval('keys_id_seq'::regclass);
2144
2145
2146 --
2147 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2148 --
2149
2150 ALTER TABLE ONLY keys_subkeys ALTER COLUMN id SET DEFAULT nextval('keys_subkeys_id_seq'::regclass);
2151
2152
2153 --
2154 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2155 --
2156
2157 ALTER TABLE ONLY logfiles ALTER COLUMN id SET DEFAULT nextval('logfiles_id_seq'::regclass);
2158
2159
2160 --
2161 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2162 --
2163
2164 ALTER TABLE ONLY mirrors ALTER COLUMN id SET DEFAULT nextval('mirrors_id_seq'::regclass);
2165
2166
2167 --
2168 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2169 --
2170
2171 ALTER TABLE ONLY mirrors_checks ALTER COLUMN id SET DEFAULT nextval('mirrors_checks_id_seq'::regclass);
2172
2173
2174 --
2175 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2176 --
2177
2178 ALTER TABLE ONLY mirrors_history ALTER COLUMN id SET DEFAULT nextval('mirrors_history_id_seq'::regclass);
2179
2180
2181 --
2182 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2183 --
2184
2185 ALTER TABLE ONLY packages ALTER COLUMN id SET DEFAULT nextval('packages_id_seq'::regclass);
2186
2187
2188 --
2189 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2190 --
2191
2192 ALTER TABLE ONLY packages_properties ALTER COLUMN id SET DEFAULT nextval('packages_properties_id_seq'::regclass);
2193
2194
2195 --
2196 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2197 --
2198
2199 ALTER TABLE ONLY queue_delete ALTER COLUMN id SET DEFAULT nextval('queue_delete_id_seq'::regclass);
2200
2201
2202 --
2203 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2204 --
2205
2206 ALTER TABLE ONLY repositories ALTER COLUMN id SET DEFAULT nextval('repositories_id_seq'::regclass);
2207
2208
2209 --
2210 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2211 --
2212
2213 ALTER TABLE ONLY repositories_aux ALTER COLUMN id SET DEFAULT nextval('repositories_aux_id_seq'::regclass);
2214
2215
2216 --
2217 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2218 --
2219
2220 ALTER TABLE ONLY repositories_builds ALTER COLUMN id SET DEFAULT nextval('repositories_builds_id_seq'::regclass);
2221
2222
2223 --
2224 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2225 --
2226
2227 ALTER TABLE ONLY sessions ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
2228
2229
2230 --
2231 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2232 --
2233
2234 ALTER TABLE ONLY slogans ALTER COLUMN id SET DEFAULT nextval('slogans_id_seq'::regclass);
2235
2236
2237 --
2238 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2239 --
2240
2241 ALTER TABLE ONLY sources ALTER COLUMN id SET DEFAULT nextval('sources_id_seq'::regclass);
2242
2243
2244 --
2245 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2246 --
2247
2248 ALTER TABLE ONLY sources_commits ALTER COLUMN id SET DEFAULT nextval('sources_commits_id_seq'::regclass);
2249
2250
2251 --
2252 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2253 --
2254
2255 ALTER TABLE ONLY uploads ALTER COLUMN id SET DEFAULT nextval('uploads_id_seq'::regclass);
2256
2257
2258 --
2259 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2260 --
2261
2262 ALTER TABLE ONLY user_messages ALTER COLUMN id SET DEFAULT nextval('user_messages_id_seq'::regclass);
2263
2264
2265 --
2266 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2267 --
2268
2269 ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
2270
2271
2272 --
2273 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2274 --
2275
2276 ALTER TABLE ONLY users_emails ALTER COLUMN id SET DEFAULT nextval('users_emails_id_seq'::regclass);
2277
2278
2279 --
2280 -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire
2281 --
2282
2283 ALTER TABLE ONLY users_permissions ALTER COLUMN id SET DEFAULT nextval('users_permissions_id_seq'::regclass);
2284
2285
2286 --
2287 -- Name: arches_compat_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2288 --
2289
2290 ALTER TABLE ONLY arches_compat
2291     ADD CONSTRAINT arches_compat_unique UNIQUE (native_arch, build_arch);
2292
2293
2294 --
2295 -- Name: arches_name; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2296 --
2297
2298 ALTER TABLE ONLY arches
2299     ADD CONSTRAINT arches_name UNIQUE (name);
2300
2301
2302 --
2303 -- Name: idx_2197943_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2304 --
2305
2306 ALTER TABLE ONLY arches
2307     ADD CONSTRAINT idx_2197943_primary PRIMARY KEY (id);
2308
2309
2310 --
2311 -- Name: idx_2197954_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2312 --
2313
2314 ALTER TABLE ONLY builders
2315     ADD CONSTRAINT idx_2197954_primary PRIMARY KEY (id);
2316
2317
2318 --
2319 -- Name: idx_2197982_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2320 --
2321
2322 ALTER TABLE ONLY builders_history
2323     ADD CONSTRAINT idx_2197982_primary PRIMARY KEY (id);
2324
2325
2326 --
2327 -- Name: idx_2197988_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2328 --
2329
2330 ALTER TABLE ONLY builds
2331     ADD CONSTRAINT idx_2197988_primary PRIMARY KEY (id);
2332
2333
2334 --
2335 -- Name: idx_2198002_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2336 --
2337
2338 ALTER TABLE ONLY builds_bugs
2339     ADD CONSTRAINT idx_2198002_primary PRIMARY KEY (id);
2340
2341
2342 --
2343 -- Name: idx_2198008_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2344 --
2345
2346 ALTER TABLE ONLY builds_bugs_updates
2347     ADD CONSTRAINT idx_2198008_primary PRIMARY KEY (id);
2348
2349
2350 --
2351 -- Name: idx_2198018_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2352 --
2353
2354 ALTER TABLE ONLY builds_comments
2355     ADD CONSTRAINT idx_2198018_primary PRIMARY KEY (id);
2356
2357
2358 --
2359 -- Name: idx_2198027_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2360 --
2361
2362 ALTER TABLE ONLY builds_history
2363     ADD CONSTRAINT idx_2198027_primary PRIMARY KEY (id);
2364
2365
2366 --
2367 -- Name: idx_2198033_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2368 --
2369
2370 ALTER TABLE ONLY builds_watchers
2371     ADD CONSTRAINT idx_2198033_primary PRIMARY KEY (id);
2372
2373
2374 --
2375 -- Name: idx_2198039_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2376 --
2377
2378 ALTER TABLE ONLY distributions
2379     ADD CONSTRAINT idx_2198039_primary PRIMARY KEY (id);
2380
2381
2382 --
2383 -- Name: idx_2198048_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2384 --
2385
2386 ALTER TABLE ONLY distributions_arches
2387     ADD CONSTRAINT idx_2198048_primary PRIMARY KEY (id);
2388
2389
2390 --
2391 -- Name: idx_2198057_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2392 --
2393
2394 ALTER TABLE ONLY images_types
2395     ADD CONSTRAINT idx_2198057_primary PRIMARY KEY (id);
2396
2397
2398 --
2399 -- Name: idx_2198063_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2400 --
2401
2402 ALTER TABLE ONLY jobs
2403     ADD CONSTRAINT idx_2198063_primary PRIMARY KEY (id);
2404
2405
2406 --
2407 -- Name: idx_2198085_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2408 --
2409
2410 ALTER TABLE ONLY jobs_packages
2411     ADD CONSTRAINT idx_2198085_primary PRIMARY KEY (id);
2412
2413
2414 --
2415 -- Name: idx_2198094_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2416 --
2417
2418 ALTER TABLE ONLY keys
2419     ADD CONSTRAINT idx_2198094_primary PRIMARY KEY (id);
2420
2421
2422 --
2423 -- Name: idx_2198103_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2424 --
2425
2426 ALTER TABLE ONLY keys_subkeys
2427     ADD CONSTRAINT idx_2198103_primary PRIMARY KEY (id);
2428
2429
2430 --
2431 -- Name: idx_2198109_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2432 --
2433
2434 ALTER TABLE ONLY logfiles
2435     ADD CONSTRAINT idx_2198109_primary PRIMARY KEY (id);
2436
2437
2438 --
2439 -- Name: idx_2198115_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2440 --
2441
2442 ALTER TABLE ONLY mirrors
2443     ADD CONSTRAINT idx_2198115_primary PRIMARY KEY (id);
2444
2445
2446 --
2447 -- Name: idx_2198126_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2448 --
2449
2450 ALTER TABLE ONLY mirrors_history
2451     ADD CONSTRAINT idx_2198126_primary PRIMARY KEY (id);
2452
2453
2454 --
2455 -- Name: idx_2198132_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2456 --
2457
2458 ALTER TABLE ONLY packages
2459     ADD CONSTRAINT idx_2198132_primary PRIMARY KEY (id);
2460
2461
2462 --
2463 -- Name: idx_2198147_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2464 --
2465
2466 ALTER TABLE ONLY packages_properties
2467     ADD CONSTRAINT idx_2198147_primary PRIMARY KEY (id);
2468
2469
2470 --
2471 -- Name: idx_2198155_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2472 --
2473
2474 ALTER TABLE ONLY queue_delete
2475     ADD CONSTRAINT idx_2198155_primary PRIMARY KEY (id);
2476
2477
2478 --
2479 -- Name: idx_2198164_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2480 --
2481
2482 ALTER TABLE ONLY repositories
2483     ADD CONSTRAINT idx_2198164_primary PRIMARY KEY (id);
2484
2485
2486 --
2487 -- Name: idx_2198179_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2488 --
2489
2490 ALTER TABLE ONLY repositories_aux
2491     ADD CONSTRAINT idx_2198179_primary PRIMARY KEY (id);
2492
2493
2494 --
2495 -- Name: idx_2198189_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2496 --
2497
2498 ALTER TABLE ONLY repositories_builds
2499     ADD CONSTRAINT idx_2198189_primary PRIMARY KEY (id);
2500
2501
2502 --
2503 -- Name: idx_2198207_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2504 --
2505
2506 ALTER TABLE ONLY slogans
2507     ADD CONSTRAINT idx_2198207_primary PRIMARY KEY (id);
2508
2509
2510 --
2511 -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2512 --
2513
2514 ALTER TABLE ONLY sources
2515     ADD CONSTRAINT idx_2198213_primary PRIMARY KEY (id);
2516
2517
2518 --
2519 -- Name: idx_2198222_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2520 --
2521
2522 ALTER TABLE ONLY sources_commits
2523     ADD CONSTRAINT idx_2198222_primary PRIMARY KEY (id);
2524
2525
2526 --
2527 -- Name: idx_2198232_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2528 --
2529
2530 ALTER TABLE ONLY uploads
2531     ADD CONSTRAINT idx_2198232_primary PRIMARY KEY (id);
2532
2533
2534 --
2535 -- Name: idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2536 --
2537
2538 ALTER TABLE ONLY users
2539     ADD CONSTRAINT idx_2198244_primary PRIMARY KEY (id);
2540
2541
2542 --
2543 -- Name: idx_2198256_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2544 --
2545
2546 ALTER TABLE ONLY users_emails
2547     ADD CONSTRAINT idx_2198256_primary PRIMARY KEY (id);
2548
2549
2550 --
2551 -- Name: idx_2198263_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2552 --
2553
2554 ALTER TABLE ONLY users_permissions
2555     ADD CONSTRAINT idx_2198263_primary PRIMARY KEY (id);
2556
2557
2558 --
2559 -- Name: idx_2198274_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2560 --
2561
2562 ALTER TABLE ONLY user_messages
2563     ADD CONSTRAINT idx_2198274_primary PRIMARY KEY (id);
2564
2565
2566 --
2567 -- Name: jobs_packages_unique; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2568 --
2569
2570 ALTER TABLE ONLY jobs_packages
2571     ADD CONSTRAINT jobs_packages_unique UNIQUE (job_id, pkg_id);
2572
2573
2574 --
2575 -- Name: mirrors_checks_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2576 --
2577
2578 ALTER TABLE ONLY mirrors_checks
2579     ADD CONSTRAINT mirrors_checks_pkey PRIMARY KEY (id);
2580
2581
2582 --
2583 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2584 --
2585
2586 ALTER TABLE ONLY sessions
2587     ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);
2588
2589
2590 --
2591 -- Name: sessions_session_id_key; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace:
2592 --
2593
2594 ALTER TABLE ONLY sessions
2595     ADD CONSTRAINT sessions_session_id_key UNIQUE (session_id);
2596
2597
2598 --
2599 -- Name: arches_compat_native_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2600 --
2601
2602 CREATE INDEX arches_compat_native_arch ON arches_compat USING btree (native_arch);
2603
2604
2605 --
2606 -- Name: builders_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2607 --
2608
2609 CREATE UNIQUE INDEX builders_name ON builders USING btree (name) WHERE (deleted IS FALSE);
2610
2611
2612 --
2613 -- Name: builds_watchers_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2614 --
2615
2616 CREATE INDEX builds_watchers_build_id ON builds_watchers USING btree (build_id);
2617
2618
2619 --
2620 -- Name: distributions_arches_distro_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2621 --
2622
2623 CREATE INDEX distributions_arches_distro_id ON distributions_arches USING btree (distro_id);
2624
2625
2626 --
2627 -- Name: distributions_sname; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2628 --
2629
2630 CREATE UNIQUE INDEX distributions_sname ON distributions USING btree (sname) WHERE (deleted IS FALSE);
2631
2632
2633 --
2634 -- Name: filelists_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2635 --
2636
2637 CREATE INDEX filelists_name ON filelists USING btree (name);
2638
2639
2640 --
2641 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2642 --
2643
2644 CREATE INDEX idx_2197982_builder_id ON builders_history USING btree (builder_id);
2645
2646
2647 --
2648 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2649 --
2650
2651 CREATE INDEX idx_2197988_pkg_id ON builds USING btree (pkg_id);
2652
2653
2654 --
2655 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2656 --
2657
2658 CREATE INDEX idx_2197988_state ON builds USING btree (state);
2659
2660
2661 --
2662 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2663 --
2664
2665 CREATE INDEX idx_2197988_type ON builds USING btree (type);
2666
2667
2668 --
2669 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2670 --
2671
2672 CREATE UNIQUE INDEX idx_2197988_uuid ON builds USING btree (uuid);
2673
2674
2675 --
2676 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2677 --
2678
2679 CREATE UNIQUE INDEX idx_2198002_build_id ON builds_bugs USING btree (build_id, bug_id);
2680
2681
2682 --
2683 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2684 --
2685
2686 CREATE INDEX idx_2198018_build_id ON builds_comments USING btree (build_id);
2687
2688
2689 --
2690 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2691 --
2692
2693 CREATE INDEX idx_2198018_user_id ON builds_comments USING btree (user_id);
2694
2695
2696 --
2697 -- Name: idx_2198052_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2698 --
2699
2700 CREATE INDEX idx_2198052_pkg_id ON filelists USING btree (pkg_id);
2701
2702
2703 --
2704 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2705 --
2706
2707 CREATE INDEX idx_2198063_build_id ON jobs USING btree (build_id);
2708
2709
2710 --
2711 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2712 --
2713
2714 CREATE INDEX idx_2198063_state ON jobs USING btree (state);
2715
2716
2717 --
2718 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2719 --
2720
2721 CREATE INDEX idx_2198063_time_finished ON jobs USING btree (time_finished);
2722
2723
2724 --
2725 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2726 --
2727
2728 CREATE UNIQUE INDEX idx_2198063_uuid ON jobs USING btree (uuid);
2729
2730
2731 --
2732 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2733 --
2734
2735 CREATE INDEX idx_2198080_job_id ON jobs_history USING btree (job_id);
2736
2737
2738 --
2739 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2740 --
2741
2742 CREATE UNIQUE INDEX idx_2198089_job_id ON jobs_repos USING btree (job_id, repo_id);
2743
2744
2745 --
2746 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2747 --
2748
2749 CREATE UNIQUE INDEX idx_2198094_fingerprint ON keys USING btree (fingerprint);
2750
2751
2752 --
2753 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2754 --
2755
2756 CREATE INDEX idx_2198132_name ON packages USING btree (name);
2757
2758
2759 --
2760 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2761 --
2762
2763 CREATE INDEX idx_2198132_type ON packages USING btree (type);
2764
2765
2766 --
2767 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2768 --
2769
2770 CREATE INDEX idx_2198132_uuid ON packages USING btree (uuid);
2771
2772
2773 --
2774 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2775 --
2776
2777 CREATE INDEX idx_2198139_pkg_id ON packages_deps USING btree (pkg_id);
2778
2779
2780 --
2781 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2782 --
2783
2784 CREATE UNIQUE INDEX idx_2198147_name ON packages_properties USING btree (name);
2785
2786
2787 --
2788 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2789 --
2790
2791 CREATE UNIQUE INDEX idx_2198189_build_id ON repositories_builds USING btree (build_id);
2792
2793
2794 --
2795 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2796 --
2797
2798 CREATE INDEX idx_2198193_build_id ON repositories_history USING btree (build_id);
2799
2800
2801 --
2802 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2803 --
2804
2805 CREATE UNIQUE INDEX idx_2198199_k ON settings USING btree (k);
2806
2807
2808 --
2809 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2810 --
2811
2812 CREATE UNIQUE INDEX idx_2198213_identifier ON sources USING btree (identifier);
2813
2814
2815 --
2816 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2817 --
2818
2819 CREATE INDEX idx_2198222_revision ON sources_commits USING btree (revision);
2820
2821
2822 --
2823 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2824 --
2825
2826 CREATE UNIQUE INDEX idx_2198232_uuid ON uploads USING btree (uuid);
2827
2828
2829 --
2830 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2831 --
2832
2833 CREATE UNIQUE INDEX idx_2198244_name ON users USING btree (name);
2834
2835
2836 --
2837 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2838 --
2839
2840 CREATE UNIQUE INDEX idx_2198256_email ON users_emails USING btree (email);
2841
2842
2843 --
2844 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2845 --
2846
2847 CREATE INDEX idx_2198256_user_id ON users_emails USING btree (user_id);
2848
2849
2850 --
2851 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2852 --
2853
2854 CREATE INDEX jobs_arch ON jobs USING btree (arch);
2855
2856
2857 --
2858 -- Name: jobs_buildroots_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2859 --
2860
2861 CREATE INDEX jobs_buildroots_job_id ON jobs_buildroots USING btree (job_id);
2862
2863 ALTER TABLE jobs_buildroots CLUSTER ON jobs_buildroots_job_id;
2864
2865
2866 --
2867 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2868 --
2869
2870 CREATE INDEX jobs_buildroots_pkg_uuid ON jobs_buildroots USING btree (pkg_uuid);
2871
2872
2873 --
2874 -- Name: jobs_test; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2875 --
2876
2877 CREATE INDEX jobs_test ON jobs USING btree (test) WHERE (deleted_at IS NULL);
2878
2879
2880 --
2881 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2882 --
2883
2884 CREATE INDEX mirrors_checks_sort ON mirrors_checks USING btree (mirror_id, "timestamp");
2885
2886 ALTER TABLE mirrors_checks CLUSTER ON mirrors_checks_sort;
2887
2888
2889 --
2890 -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2891 --
2892
2893 CREATE INDEX repositories_builds_repo_id ON repositories_builds USING btree (repo_id);
2894
2895
2896 --
2897 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
2898 --
2899
2900 CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON sources FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
2901
2902
2903 --
2904 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2905 --
2906
2907 ALTER TABLE ONLY arches_compat
2908     ADD CONSTRAINT arches_compat_build_arch FOREIGN KEY (build_arch) REFERENCES arches(name);
2909
2910
2911 --
2912 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2913 --
2914
2915 ALTER TABLE ONLY builders_history
2916     ADD CONSTRAINT builders_history_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
2917
2918
2919 --
2920 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2921 --
2922
2923 ALTER TABLE ONLY builders_history
2924     ADD CONSTRAINT builders_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2925
2926
2927 --
2928 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2929 --
2930
2931 ALTER TABLE ONLY builds_bugs
2932     ADD CONSTRAINT builds_bug_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2933
2934
2935 --
2936 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2937 --
2938
2939 ALTER TABLE ONLY builds_comments
2940     ADD CONSTRAINT builds_comments_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2941
2942
2943 --
2944 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2945 --
2946
2947 ALTER TABLE ONLY builds_comments
2948     ADD CONSTRAINT builds_comments_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2949
2950
2951 --
2952 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2953 --
2954
2955 ALTER TABLE ONLY builds
2956     ADD CONSTRAINT builds_depends_on FOREIGN KEY (depends_on) REFERENCES builds(id);
2957
2958
2959 --
2960 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2961 --
2962
2963 ALTER TABLE ONLY builds
2964     ADD CONSTRAINT builds_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
2965
2966
2967 --
2968 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2969 --
2970
2971 ALTER TABLE ONLY builds_history
2972     ADD CONSTRAINT builds_history_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2973
2974
2975 --
2976 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2977 --
2978
2979 ALTER TABLE ONLY builds_history
2980     ADD CONSTRAINT builds_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2981
2982
2983 --
2984 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2985 --
2986
2987 ALTER TABLE ONLY builds
2988     ADD CONSTRAINT builds_owner_id FOREIGN KEY (owner_id) REFERENCES users(id);
2989
2990
2991 --
2992 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2993 --
2994
2995 ALTER TABLE ONLY builds
2996     ADD CONSTRAINT builds_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
2997
2998
2999 --
3000 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3001 --
3002
3003 ALTER TABLE ONLY builds_watchers
3004     ADD CONSTRAINT builds_watchers_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3005
3006
3007 --
3008 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3009 --
3010
3011 ALTER TABLE ONLY builds_watchers
3012     ADD CONSTRAINT builds_watchers_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3013
3014
3015 --
3016 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3017 --
3018
3019 ALTER TABLE ONLY distributions_arches
3020     ADD CONSTRAINT distributions_arches_arch FOREIGN KEY (arch) REFERENCES arches(name);
3021
3022
3023 --
3024 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3025 --
3026
3027 ALTER TABLE ONLY distributions_arches
3028     ADD CONSTRAINT distro_arches_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3029
3030
3031 --
3032 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3033 --
3034
3035 ALTER TABLE ONLY filelists
3036     ADD CONSTRAINT filelists_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3037
3038
3039 --
3040 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3041 --
3042
3043 ALTER TABLE ONLY jobs
3044     ADD CONSTRAINT jobs_arch FOREIGN KEY (arch) REFERENCES arches(name);
3045
3046
3047 --
3048 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3049 --
3050
3051 ALTER TABLE ONLY jobs
3052     ADD CONSTRAINT jobs_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3053
3054
3055 --
3056 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3057 --
3058
3059 ALTER TABLE ONLY jobs
3060     ADD CONSTRAINT jobs_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3061
3062
3063 --
3064 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3065 --
3066
3067 ALTER TABLE ONLY jobs_buildroots
3068     ADD CONSTRAINT jobs_buildroots_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3069
3070
3071 --
3072 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3073 --
3074
3075 ALTER TABLE ONLY jobs_history
3076     ADD CONSTRAINT jobs_history_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3077
3078
3079 --
3080 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3081 --
3082
3083 ALTER TABLE ONLY jobs_history
3084     ADD CONSTRAINT jobs_history_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3085
3086
3087 --
3088 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3089 --
3090
3091 ALTER TABLE ONLY jobs_history
3092     ADD CONSTRAINT jobs_history_test_job_id FOREIGN KEY (test_job_id) REFERENCES jobs(id);
3093
3094
3095 --
3096 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3097 --
3098
3099 ALTER TABLE ONLY jobs_history
3100     ADD CONSTRAINT jobs_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3101
3102
3103 --
3104 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3105 --
3106
3107 ALTER TABLE ONLY jobs_packages
3108     ADD CONSTRAINT jobs_packaged_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3109
3110
3111 --
3112 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3113 --
3114
3115 ALTER TABLE ONLY jobs_packages
3116     ADD CONSTRAINT jobs_packages_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3117
3118
3119 --
3120 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3121 --
3122
3123 ALTER TABLE ONLY jobs_repos
3124     ADD CONSTRAINT jobs_repos_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3125
3126
3127 --
3128 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3129 --
3130
3131 ALTER TABLE ONLY jobs_repos
3132     ADD CONSTRAINT jobs_repos_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
3133
3134
3135 --
3136 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3137 --
3138
3139 ALTER TABLE ONLY keys_subkeys
3140     ADD CONSTRAINT keys_subkeys_key_id FOREIGN KEY (key_id) REFERENCES keys(id);
3141
3142
3143 --
3144 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3145 --
3146
3147 ALTER TABLE ONLY logfiles
3148     ADD CONSTRAINT logfiles_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3149
3150
3151 --
3152 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3153 --
3154
3155 ALTER TABLE ONLY mirrors_checks
3156     ADD CONSTRAINT mirrors_checks_mirror_id FOREIGN KEY (mirror_id) REFERENCES mirrors(id);
3157
3158
3159 --
3160 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3161 --
3162
3163 ALTER TABLE ONLY mirrors_history
3164     ADD CONSTRAINT mirrors_history_mirror_id FOREIGN KEY (mirror_id) REFERENCES mirrors(id);
3165
3166
3167 --
3168 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3169 --
3170
3171 ALTER TABLE ONLY mirrors_history
3172     ADD CONSTRAINT mirrors_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3173
3174
3175 --
3176 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3177 --
3178
3179 ALTER TABLE ONLY packages
3180     ADD CONSTRAINT packages_arch FOREIGN KEY (arch) REFERENCES arches(name);
3181
3182
3183 --
3184 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3185 --
3186
3187 ALTER TABLE ONLY packages
3188     ADD CONSTRAINT packages_commit_id FOREIGN KEY (commit_id) REFERENCES sources_commits(id);
3189
3190
3191 --
3192 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3193 --
3194
3195 ALTER TABLE ONLY packages_deps
3196     ADD CONSTRAINT packages_deps_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3197
3198
3199 --
3200 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3201 --
3202
3203 ALTER TABLE ONLY repositories_aux
3204     ADD CONSTRAINT repositories_aux_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3205
3206
3207 --
3208 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3209 --
3210
3211 ALTER TABLE ONLY repositories_builds
3212     ADD CONSTRAINT repositories_builds_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3213
3214
3215 --
3216 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3217 --
3218
3219 ALTER TABLE ONLY repositories_builds
3220     ADD CONSTRAINT repositories_builds_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
3221
3222
3223 --
3224 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3225 --
3226
3227 ALTER TABLE ONLY repositories
3228     ADD CONSTRAINT repositories_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3229
3230
3231 --
3232 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3233 --
3234
3235 ALTER TABLE ONLY repositories_history
3236     ADD CONSTRAINT repositories_history_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3237
3238
3239 --
3240 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3241 --
3242
3243 ALTER TABLE ONLY repositories_history
3244     ADD CONSTRAINT repositories_history_from_repo_id FOREIGN KEY (from_repo_id) REFERENCES repositories(id);
3245
3246
3247 --
3248 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3249 --
3250
3251 ALTER TABLE ONLY repositories_history
3252     ADD CONSTRAINT repositories_history_to_repo_id FOREIGN KEY (to_repo_id) REFERENCES repositories(id);
3253
3254
3255 --
3256 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3257 --
3258
3259 ALTER TABLE ONLY repositories_history
3260     ADD CONSTRAINT repositories_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3261
3262
3263 --
3264 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3265 --
3266
3267 ALTER TABLE ONLY repositories
3268     ADD CONSTRAINT repositories_key_id FOREIGN KEY (key_id) REFERENCES keys(id);
3269
3270
3271 --
3272 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3273 --
3274
3275 ALTER TABLE ONLY repositories
3276     ADD CONSTRAINT repositories_parent_id FOREIGN KEY (parent_id) REFERENCES repositories(id);
3277
3278
3279 --
3280 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3281 --
3282
3283 ALTER TABLE ONLY sessions
3284     ADD CONSTRAINT sessions_impersonated_user_id FOREIGN KEY (impersonated_user_id) REFERENCES users(id);
3285
3286
3287 --
3288 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3289 --
3290
3291 ALTER TABLE ONLY sessions
3292     ADD CONSTRAINT sessions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3293
3294
3295 --
3296 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3297 --
3298
3299 ALTER TABLE ONLY sources_commits
3300     ADD CONSTRAINT sources_commits_source_id FOREIGN KEY (source_id) REFERENCES sources(id);
3301
3302
3303 --
3304 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3305 --
3306
3307 ALTER TABLE ONLY sources
3308     ADD CONSTRAINT sources_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3309
3310
3311 --
3312 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3313 --
3314
3315 ALTER TABLE ONLY uploads
3316     ADD CONSTRAINT uploads_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3317
3318
3319 --
3320 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3321 --
3322
3323 ALTER TABLE ONLY uploads
3324     ADD CONSTRAINT uploads_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3325
3326
3327 --
3328 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3329 --
3330
3331 ALTER TABLE ONLY users_emails
3332     ADD CONSTRAINT users_emails_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3333
3334
3335 --
3336 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3337 --
3338
3339 ALTER TABLE ONLY users_permissions
3340     ADD CONSTRAINT users_permissions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3341
3342
3343 --
3344 -- PostgreSQL database dump complete
3345 --
3346