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 );
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: filelists_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2642 --
2643
2644 CREATE INDEX filelists_pkg_id ON filelists USING btree (pkg_id);
2645
2646 ALTER TABLE filelists CLUSTER ON filelists_pkg_id;
2647
2648
2649 --
2650 -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2651 --
2652
2653 CREATE INDEX idx_2197982_builder_id ON builders_history USING btree (builder_id);
2654
2655
2656 --
2657 -- Name: idx_2197988_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2658 --
2659
2660 CREATE INDEX idx_2197988_pkg_id ON builds USING btree (pkg_id);
2661
2662
2663 --
2664 -- Name: idx_2197988_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2665 --
2666
2667 CREATE INDEX idx_2197988_state ON builds USING btree (state);
2668
2669
2670 --
2671 -- Name: idx_2197988_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2672 --
2673
2674 CREATE INDEX idx_2197988_type ON builds USING btree (type);
2675
2676
2677 --
2678 -- Name: idx_2197988_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2679 --
2680
2681 CREATE UNIQUE INDEX idx_2197988_uuid ON builds USING btree (uuid);
2682
2683
2684 --
2685 -- Name: idx_2198002_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2686 --
2687
2688 CREATE UNIQUE INDEX idx_2198002_build_id ON builds_bugs USING btree (build_id, bug_id);
2689
2690
2691 --
2692 -- Name: idx_2198018_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2693 --
2694
2695 CREATE INDEX idx_2198018_build_id ON builds_comments USING btree (build_id);
2696
2697
2698 --
2699 -- Name: idx_2198018_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2700 --
2701
2702 CREATE INDEX idx_2198018_user_id ON builds_comments USING btree (user_id);
2703
2704
2705 --
2706 -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2707 --
2708
2709 CREATE INDEX idx_2198063_build_id ON jobs USING btree (build_id);
2710
2711
2712 --
2713 -- Name: idx_2198063_state; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2714 --
2715
2716 CREATE INDEX idx_2198063_state ON jobs USING btree (state);
2717
2718
2719 --
2720 -- Name: idx_2198063_time_finished; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2721 --
2722
2723 CREATE INDEX idx_2198063_time_finished ON jobs USING btree (time_finished);
2724
2725
2726 --
2727 -- Name: idx_2198063_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2728 --
2729
2730 CREATE UNIQUE INDEX idx_2198063_uuid ON jobs USING btree (uuid);
2731
2732
2733 --
2734 -- Name: idx_2198080_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2735 --
2736
2737 CREATE INDEX idx_2198080_job_id ON jobs_history USING btree (job_id);
2738
2739
2740 --
2741 -- Name: idx_2198089_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2742 --
2743
2744 CREATE UNIQUE INDEX idx_2198089_job_id ON jobs_repos USING btree (job_id, repo_id);
2745
2746
2747 --
2748 -- Name: idx_2198094_fingerprint; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2749 --
2750
2751 CREATE UNIQUE INDEX idx_2198094_fingerprint ON keys USING btree (fingerprint);
2752
2753
2754 --
2755 -- Name: idx_2198132_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2756 --
2757
2758 CREATE INDEX idx_2198132_name ON packages USING btree (name);
2759
2760
2761 --
2762 -- Name: idx_2198132_type; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2763 --
2764
2765 CREATE INDEX idx_2198132_type ON packages USING btree (type);
2766
2767
2768 --
2769 -- Name: idx_2198132_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2770 --
2771
2772 CREATE INDEX idx_2198132_uuid ON packages USING btree (uuid);
2773
2774
2775 --
2776 -- Name: idx_2198139_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2777 --
2778
2779 CREATE INDEX idx_2198139_pkg_id ON packages_deps USING btree (pkg_id);
2780
2781
2782 --
2783 -- Name: idx_2198147_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2784 --
2785
2786 CREATE UNIQUE INDEX idx_2198147_name ON packages_properties USING btree (name);
2787
2788
2789 --
2790 -- Name: idx_2198189_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2791 --
2792
2793 CREATE UNIQUE INDEX idx_2198189_build_id ON repositories_builds USING btree (build_id);
2794
2795
2796 --
2797 -- Name: idx_2198193_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2798 --
2799
2800 CREATE INDEX idx_2198193_build_id ON repositories_history USING btree (build_id);
2801
2802
2803 --
2804 -- Name: idx_2198199_k; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2805 --
2806
2807 CREATE UNIQUE INDEX idx_2198199_k ON settings USING btree (k);
2808
2809
2810 --
2811 -- Name: idx_2198213_identifier; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2812 --
2813
2814 CREATE UNIQUE INDEX idx_2198213_identifier ON sources USING btree (identifier);
2815
2816
2817 --
2818 -- Name: idx_2198222_revision; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2819 --
2820
2821 CREATE INDEX idx_2198222_revision ON sources_commits USING btree (revision);
2822
2823
2824 --
2825 -- Name: idx_2198232_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2826 --
2827
2828 CREATE UNIQUE INDEX idx_2198232_uuid ON uploads USING btree (uuid);
2829
2830
2831 --
2832 -- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2833 --
2834
2835 CREATE UNIQUE INDEX idx_2198244_name ON users USING btree (name);
2836
2837
2838 --
2839 -- Name: idx_2198256_email; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2840 --
2841
2842 CREATE UNIQUE INDEX idx_2198256_email ON users_emails USING btree (email);
2843
2844
2845 --
2846 -- Name: idx_2198256_user_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2847 --
2848
2849 CREATE INDEX idx_2198256_user_id ON users_emails USING btree (user_id);
2850
2851
2852 --
2853 -- Name: jobs_arch; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2854 --
2855
2856 CREATE INDEX jobs_arch ON jobs USING btree (arch);
2857
2858
2859 --
2860 -- Name: jobs_buildroots_job_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2861 --
2862
2863 CREATE INDEX jobs_buildroots_job_id ON jobs_buildroots USING btree (job_id);
2864
2865 ALTER TABLE jobs_buildroots CLUSTER ON jobs_buildroots_job_id;
2866
2867
2868 --
2869 -- Name: jobs_buildroots_pkg_uuid; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2870 --
2871
2872 CREATE INDEX jobs_buildroots_pkg_uuid ON jobs_buildroots USING btree (pkg_uuid);
2873
2874
2875 --
2876 -- Name: mirrors_checks_sort; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2877 --
2878
2879 CREATE INDEX mirrors_checks_sort ON mirrors_checks USING btree (mirror_id, "timestamp");
2880
2881 ALTER TABLE mirrors_checks CLUSTER ON mirrors_checks_sort;
2882
2883
2884 --
2885 -- Name: repositories_builds_repo_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace:
2886 --
2887
2888 CREATE INDEX repositories_builds_repo_id ON repositories_builds USING btree (repo_id);
2889
2890
2891 --
2892 -- Name: on_update_current_timestamp; Type: TRIGGER; Schema: public; Owner: pakfire
2893 --
2894
2895 CREATE TRIGGER on_update_current_timestamp BEFORE UPDATE ON sources FOR EACH ROW EXECUTE PROCEDURE on_update_current_timestamp_sources();
2896
2897
2898 --
2899 -- Name: arches_compat_build_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2900 --
2901
2902 ALTER TABLE ONLY arches_compat
2903     ADD CONSTRAINT arches_compat_build_arch FOREIGN KEY (build_arch) REFERENCES arches(name);
2904
2905
2906 --
2907 -- Name: builders_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2908 --
2909
2910 ALTER TABLE ONLY builders_history
2911     ADD CONSTRAINT builders_history_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
2912
2913
2914 --
2915 -- Name: builders_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2916 --
2917
2918 ALTER TABLE ONLY builders_history
2919     ADD CONSTRAINT builders_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2920
2921
2922 --
2923 -- Name: builds_bug_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2924 --
2925
2926 ALTER TABLE ONLY builds_bugs
2927     ADD CONSTRAINT builds_bug_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2928
2929
2930 --
2931 -- Name: builds_comments_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2932 --
2933
2934 ALTER TABLE ONLY builds_comments
2935     ADD CONSTRAINT builds_comments_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2936
2937
2938 --
2939 -- Name: builds_comments_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2940 --
2941
2942 ALTER TABLE ONLY builds_comments
2943     ADD CONSTRAINT builds_comments_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2944
2945
2946 --
2947 -- Name: builds_depends_on; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2948 --
2949
2950 ALTER TABLE ONLY builds
2951     ADD CONSTRAINT builds_depends_on FOREIGN KEY (depends_on) REFERENCES builds(id);
2952
2953
2954 --
2955 -- Name: builds_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2956 --
2957
2958 ALTER TABLE ONLY builds
2959     ADD CONSTRAINT builds_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
2960
2961
2962 --
2963 -- Name: builds_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2964 --
2965
2966 ALTER TABLE ONLY builds_history
2967     ADD CONSTRAINT builds_history_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
2968
2969
2970 --
2971 -- Name: builds_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2972 --
2973
2974 ALTER TABLE ONLY builds_history
2975     ADD CONSTRAINT builds_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
2976
2977
2978 --
2979 -- Name: builds_owner_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2980 --
2981
2982 ALTER TABLE ONLY builds
2983     ADD CONSTRAINT builds_owner_id FOREIGN KEY (owner_id) REFERENCES users(id);
2984
2985
2986 --
2987 -- Name: builds_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2988 --
2989
2990 ALTER TABLE ONLY builds
2991     ADD CONSTRAINT builds_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
2992
2993
2994 --
2995 -- Name: builds_watchers_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
2996 --
2997
2998 ALTER TABLE ONLY builds_watchers
2999     ADD CONSTRAINT builds_watchers_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3000
3001
3002 --
3003 -- Name: builds_watchers_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3004 --
3005
3006 ALTER TABLE ONLY builds_watchers
3007     ADD CONSTRAINT builds_watchers_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3008
3009
3010 --
3011 -- Name: distributions_arches_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3012 --
3013
3014 ALTER TABLE ONLY distributions_arches
3015     ADD CONSTRAINT distributions_arches_arch FOREIGN KEY (arch) REFERENCES arches(name);
3016
3017
3018 --
3019 -- Name: distro_arches_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3020 --
3021
3022 ALTER TABLE ONLY distributions_arches
3023     ADD CONSTRAINT distro_arches_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3024
3025
3026 --
3027 -- Name: filelists_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3028 --
3029
3030 ALTER TABLE ONLY filelists
3031     ADD CONSTRAINT filelists_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3032
3033
3034 --
3035 -- Name: jobs_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3036 --
3037
3038 ALTER TABLE ONLY jobs
3039     ADD CONSTRAINT jobs_arch FOREIGN KEY (arch) REFERENCES arches(name);
3040
3041
3042 --
3043 -- Name: jobs_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3044 --
3045
3046 ALTER TABLE ONLY jobs
3047     ADD CONSTRAINT jobs_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3048
3049
3050 --
3051 -- Name: jobs_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3052 --
3053
3054 ALTER TABLE ONLY jobs
3055     ADD CONSTRAINT jobs_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3056
3057
3058 --
3059 -- Name: jobs_buildroots_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3060 --
3061
3062 ALTER TABLE ONLY jobs_buildroots
3063     ADD CONSTRAINT jobs_buildroots_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3064
3065
3066 --
3067 -- Name: jobs_history_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3068 --
3069
3070 ALTER TABLE ONLY jobs_history
3071     ADD CONSTRAINT jobs_history_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3072
3073
3074 --
3075 -- Name: jobs_history_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3076 --
3077
3078 ALTER TABLE ONLY jobs_history
3079     ADD CONSTRAINT jobs_history_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3080
3081
3082 --
3083 -- Name: jobs_history_test_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3084 --
3085
3086 ALTER TABLE ONLY jobs_history
3087     ADD CONSTRAINT jobs_history_test_job_id FOREIGN KEY (test_job_id) REFERENCES jobs(id);
3088
3089
3090 --
3091 -- Name: jobs_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3092 --
3093
3094 ALTER TABLE ONLY jobs_history
3095     ADD CONSTRAINT jobs_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3096
3097
3098 --
3099 -- Name: jobs_packaged_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3100 --
3101
3102 ALTER TABLE ONLY jobs_packages
3103     ADD CONSTRAINT jobs_packaged_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3104
3105
3106 --
3107 -- Name: jobs_packages_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3108 --
3109
3110 ALTER TABLE ONLY jobs_packages
3111     ADD CONSTRAINT jobs_packages_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3112
3113
3114 --
3115 -- Name: jobs_repos_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3116 --
3117
3118 ALTER TABLE ONLY jobs_repos
3119     ADD CONSTRAINT jobs_repos_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3120
3121
3122 --
3123 -- Name: jobs_repos_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3124 --
3125
3126 ALTER TABLE ONLY jobs_repos
3127     ADD CONSTRAINT jobs_repos_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
3128
3129
3130 --
3131 -- Name: keys_subkeys_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3132 --
3133
3134 ALTER TABLE ONLY keys_subkeys
3135     ADD CONSTRAINT keys_subkeys_key_id FOREIGN KEY (key_id) REFERENCES keys(id);
3136
3137
3138 --
3139 -- Name: logfiles_job_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3140 --
3141
3142 ALTER TABLE ONLY logfiles
3143     ADD CONSTRAINT logfiles_job_id FOREIGN KEY (job_id) REFERENCES jobs(id);
3144
3145
3146 --
3147 -- Name: mirrors_checks_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3148 --
3149
3150 ALTER TABLE ONLY mirrors_checks
3151     ADD CONSTRAINT mirrors_checks_mirror_id FOREIGN KEY (mirror_id) REFERENCES mirrors(id);
3152
3153
3154 --
3155 -- Name: mirrors_history_mirror_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3156 --
3157
3158 ALTER TABLE ONLY mirrors_history
3159     ADD CONSTRAINT mirrors_history_mirror_id FOREIGN KEY (mirror_id) REFERENCES mirrors(id);
3160
3161
3162 --
3163 -- Name: mirrors_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3164 --
3165
3166 ALTER TABLE ONLY mirrors_history
3167     ADD CONSTRAINT mirrors_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3168
3169
3170 --
3171 -- Name: packages_arch; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3172 --
3173
3174 ALTER TABLE ONLY packages
3175     ADD CONSTRAINT packages_arch FOREIGN KEY (arch) REFERENCES arches(name);
3176
3177
3178 --
3179 -- Name: packages_commit_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3180 --
3181
3182 ALTER TABLE ONLY packages
3183     ADD CONSTRAINT packages_commit_id FOREIGN KEY (commit_id) REFERENCES sources_commits(id);
3184
3185
3186 --
3187 -- Name: packages_deps_pkg_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3188 --
3189
3190 ALTER TABLE ONLY packages_deps
3191     ADD CONSTRAINT packages_deps_pkg_id FOREIGN KEY (pkg_id) REFERENCES packages(id);
3192
3193
3194 --
3195 -- Name: repositories_aux_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3196 --
3197
3198 ALTER TABLE ONLY repositories_aux
3199     ADD CONSTRAINT repositories_aux_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3200
3201
3202 --
3203 -- Name: repositories_builds_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3204 --
3205
3206 ALTER TABLE ONLY repositories_builds
3207     ADD CONSTRAINT repositories_builds_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3208
3209
3210 --
3211 -- Name: repositories_builds_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3212 --
3213
3214 ALTER TABLE ONLY repositories_builds
3215     ADD CONSTRAINT repositories_builds_repo_id FOREIGN KEY (repo_id) REFERENCES repositories(id);
3216
3217
3218 --
3219 -- Name: repositories_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3220 --
3221
3222 ALTER TABLE ONLY repositories
3223     ADD CONSTRAINT repositories_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3224
3225
3226 --
3227 -- Name: repositories_history_build_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3228 --
3229
3230 ALTER TABLE ONLY repositories_history
3231     ADD CONSTRAINT repositories_history_build_id FOREIGN KEY (build_id) REFERENCES builds(id);
3232
3233
3234 --
3235 -- Name: repositories_history_from_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3236 --
3237
3238 ALTER TABLE ONLY repositories_history
3239     ADD CONSTRAINT repositories_history_from_repo_id FOREIGN KEY (from_repo_id) REFERENCES repositories(id);
3240
3241
3242 --
3243 -- Name: repositories_history_to_repo_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3244 --
3245
3246 ALTER TABLE ONLY repositories_history
3247     ADD CONSTRAINT repositories_history_to_repo_id FOREIGN KEY (to_repo_id) REFERENCES repositories(id);
3248
3249
3250 --
3251 -- Name: repositories_history_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3252 --
3253
3254 ALTER TABLE ONLY repositories_history
3255     ADD CONSTRAINT repositories_history_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3256
3257
3258 --
3259 -- Name: repositories_key_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3260 --
3261
3262 ALTER TABLE ONLY repositories
3263     ADD CONSTRAINT repositories_key_id FOREIGN KEY (key_id) REFERENCES keys(id);
3264
3265
3266 --
3267 -- Name: repositories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3268 --
3269
3270 ALTER TABLE ONLY repositories
3271     ADD CONSTRAINT repositories_parent_id FOREIGN KEY (parent_id) REFERENCES repositories(id);
3272
3273
3274 --
3275 -- Name: sessions_impersonated_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3276 --
3277
3278 ALTER TABLE ONLY sessions
3279     ADD CONSTRAINT sessions_impersonated_user_id FOREIGN KEY (impersonated_user_id) REFERENCES users(id);
3280
3281
3282 --
3283 -- Name: sessions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3284 --
3285
3286 ALTER TABLE ONLY sessions
3287     ADD CONSTRAINT sessions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3288
3289
3290 --
3291 -- Name: sources_commits_source_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3292 --
3293
3294 ALTER TABLE ONLY sources_commits
3295     ADD CONSTRAINT sources_commits_source_id FOREIGN KEY (source_id) REFERENCES sources(id);
3296
3297
3298 --
3299 -- Name: sources_distro_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3300 --
3301
3302 ALTER TABLE ONLY sources
3303     ADD CONSTRAINT sources_distro_id FOREIGN KEY (distro_id) REFERENCES distributions(id);
3304
3305
3306 --
3307 -- Name: uploads_builder_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3308 --
3309
3310 ALTER TABLE ONLY uploads
3311     ADD CONSTRAINT uploads_builder_id FOREIGN KEY (builder_id) REFERENCES builders(id);
3312
3313
3314 --
3315 -- Name: uploads_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3316 --
3317
3318 ALTER TABLE ONLY uploads
3319     ADD CONSTRAINT uploads_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3320
3321
3322 --
3323 -- Name: users_emails_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3324 --
3325
3326 ALTER TABLE ONLY users_emails
3327     ADD CONSTRAINT users_emails_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3328
3329
3330 --
3331 -- Name: users_permissions_user_id; Type: FK CONSTRAINT; Schema: public; Owner: pakfire
3332 --
3333
3334 ALTER TABLE ONLY users_permissions
3335     ADD CONSTRAINT users_permissions_user_id FOREIGN KEY (user_id) REFERENCES users(id);
3336
3337
3338 --
3339 -- PostgreSQL database dump complete
3340 --
3341