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