sql/_source/deploy/1/001-auto.yml

   1 ---
   2 schema:
   3   procedures: {}
   4   tables:
   5     arch:
   6       constraints:
   7         - deferrable: 1
   8           expression: ''
   9           fields:
  10             - id
  11           match_type: ''
  12           name: ''
  13           on_delete: ''
  14           on_update: ''
  15           options: []
  16           reference_fields: []
  17           reference_table: ''
  18           type: PRIMARY KEY
  19         - deferrable: 1
  20           expression: ''
  21           fields:
  22             - arch
  23           match_type: ''
  24           name: arch_arch_key
  25           on_delete: ''
  26           on_update: ''
  27           options: []
  28           reference_fields: []
  29           reference_table: ''
  30           type: UNIQUE
  31       fields:
  32         arch:
  33           data_type: text
  34           default_value: ~
  35           is_nullable: 0
  36           is_primary_key: 0
  37           is_unique: 1
  38           name: arch
  39           order: 2
  40           size:
  41             - 0
  42         id:
  43           data_type: integer
  44           default_value: ~
  45           is_auto_increment: 1
  46           is_nullable: 0
  47           is_primary_key: 1
  48           is_unique: 0
  49           name: id
  50           order: 1
  51           size:
  52             - 0
  53       indices: []
  54       name: arch
  55       options: []
  56       order: 1
  57     bin_associations:
  58       constraints:
  59         - deferrable: 1
  60           expression: ''
  61           fields:
  62             - id
  63           match_type: ''
  64           name: ''
  65           on_delete: ''
  66           on_update: ''
  67           options: []
  68           reference_fields: []
  69           reference_table: ''
  70           type: PRIMARY KEY
  71         - deferrable: 0
  72           expression: ''
  73           fields:
  74             - bin
  75           match_type: ''
  76           name: bin_associations_fk_bin
  77           on_delete: CASCADE
  78           on_update: CASCADE
  79           options: []
  80           reference_fields:
  81             - id
  82           reference_table: bin_ver
  83           type: FOREIGN KEY
  84         - deferrable: 0
  85           expression: ''
  86           fields:
  87             - suite
  88           match_type: ''
  89           name: bin_associations_fk_suite
  90           on_delete: CASCADE
  91           on_update: CASCADE
  92           options: []
  93           reference_fields:
  94             - id
  95           reference_table: suite
  96           type: FOREIGN KEY
  97       fields:
  98         bin:
  99           data_type: integer
 100           default_value: ~
 101           is_nullable: 0
 102           is_primary_key: 0
 103           is_unique: 0
 104           name: bin
 105           order: 3
 106           size:
 107             - 0
 108         created:
 109           data_type: timestamp with time zone
 110           default_value: !!perl/ref
 111             =: current_timestamp
 112           is_nullable: 0
 113           is_primary_key: 0
 114           is_unique: 0
 115           name: created
 116           order: 4
 117           size:
 118             - 0
 119         id:
 120           data_type: integer
 121           default_value: ~
 122           is_auto_increment: 1
 123           is_nullable: 0
 124           is_primary_key: 1
 125           is_unique: 0
 126           name: id
 127           order: 1
 128           size:
 129             - 0
 130         modified:
 131           data_type: timestamp with time zone
 132           default_value: !!perl/ref
 133             =: current_timestamp
 134           is_nullable: 0
 135           is_primary_key: 0
 136           is_unique: 0
 137           name: modified
 138           order: 5
 139           size:
 140             - 0
 141         suite:
 142           data_type: integer
 143           default_value: ~
 144           is_nullable: 0
 145           is_primary_key: 0
 146           is_unique: 0
 147           name: suite
 148           order: 2
 149           size:
 150             - 0
 151       indices:
 152         - fields:
 153             - bin
 154           name: bin_associations_idx_bin
 155           options: []
 156           type: NORMAL
 157         - fields:
 158             - suite
 159           name: bin_associations_idx_suite
 160           options: []
 161           type: NORMAL
 162       name: bin_associations
 163       options: []
 164       order: 29
 165     bin_pkg:
 166       constraints:
 167         - deferrable: 1
 168           expression: ''
 169           fields:
 170             - id
 171           match_type: ''
 172           name: ''
 173           on_delete: ''
 174           on_update: ''
 175           options: []
 176           reference_fields: []
 177           reference_table: ''
 178           type: PRIMARY KEY
 179         - deferrable: 1
 180           expression: ''
 181           fields:
 182             - pkg
 183           match_type: ''
 184           name: bin_pkg_pkg_key
 185           on_delete: ''
 186           on_update: ''
 187           options: []
 188           reference_fields: []
 189           reference_table: ''
 190           type: UNIQUE
 191       fields:
 192         id:
 193           data_type: integer
 194           default_value: ~
 195           is_auto_increment: 1
 196           is_nullable: 0
 197           is_primary_key: 1
 198           is_unique: 0
 199           name: id
 200           order: 1
 201           size:
 202             - 0
 203         pkg:
 204           data_type: text
 205           default_value: ~
 206           is_nullable: 0
 207           is_primary_key: 0
 208           is_unique: 1
 209           name: pkg
 210           order: 2
 211           size:
 212             - 0
 213       indices: []
 214       name: bin_pkg
 215       options: []
 216       order: 2
 217     bin_ver:
 218       constraints:
 219         - deferrable: 1
 220           expression: ''
 221           fields:
 222             - id
 223           match_type: ''
 224           name: ''
 225           on_delete: ''
 226           on_update: ''
 227           options: []
 228           reference_fields: []
 229           reference_table: ''
 230           type: PRIMARY KEY
 231         - deferrable: 0
 232           expression: ''
 233           fields:
 234             - arch
 235           match_type: ''
 236           name: bin_ver_fk_arch
 237           on_delete: CASCADE
 238           on_update: CASCADE
 239           options: []
 240           reference_fields:
 241             - id
 242           reference_table: arch
 243           type: FOREIGN KEY
 244         - deferrable: 0
 245           expression: ''
 246           fields:
 247             - bin_pkg
 248           match_type: ''
 249           name: bin_ver_fk_bin_pkg
 250           on_delete: CASCADE
 251           on_update: CASCADE
 252           options: []
 253           reference_fields:
 254             - id
 255           reference_table: bin_pkg
 256           type: FOREIGN KEY
 257         - deferrable: 0
 258           expression: ''
 259           fields:
 260             - src_ver
 261           match_type: ''
 262           name: bin_ver_fk_src_ver
 263           on_delete: CASCADE
 264           on_update: CASCADE
 265           options: []
 266           reference_fields:
 267             - id
 268           reference_table: src_ver
 269           type: FOREIGN KEY
 270       fields:
 271         arch:
 272           data_type: integer
 273           default_value: ~
 274           is_nullable: 0
 275           is_primary_key: 0
 276           is_unique: 0
 277           name: arch
 278           order: 4
 279           size:
 280             - 0
 281         bin_pkg:
 282           data_type: integer
 283           default_value: ~
 284           is_nullable: 0
 285           is_primary_key: 0
 286           is_unique: 0
 287           name: bin_pkg
 288           order: 2
 289           size:
 290             - 0
 291         id:
 292           data_type: integer
 293           default_value: ~
 294           is_auto_increment: 1
 295           is_nullable: 0
 296           is_primary_key: 1
 297           is_unique: 0
 298           name: id
 299           order: 1
 300           size:
 301             - 0
 302         src_ver:
 303           data_type: integer
 304           default_value: ~
 305           is_nullable: 0
 306           is_primary_key: 0
 307           is_unique: 0
 308           name: src_ver
 309           order: 3
 310           size:
 311             - 0
 312         ver:
 313           data_type: debversion
 314           default_value: ~
 315           is_nullable: 0
 316           is_primary_key: 0
 317           is_unique: 0
 318           name: ver
 319           order: 5
 320           size:
 321             - 0
 322       indices:
 323         - fields:
 324             - arch
 325           name: bin_ver_idx_arch
 326           options: []
 327           type: NORMAL
 328         - fields:
 329             - bin_pkg
 330           name: bin_ver_idx_bin_pkg
 331           options: []
 332           type: NORMAL
 333         - fields:
 334             - src_ver
 335           name: bin_ver_idx_src_ver
 336           options: []
 337           type: NORMAL
 338       name: bin_ver
 339       options: []
 340       order: 27
 341     binary_versions:
 342       constraints: []
 343       fields:
 344         arch:
 345           data_type: text
 346           default_value: ~
 347           is_nullable: 1
 348           is_primary_key: 0
 349           is_unique: 0
 350           name: arch
 351           order: 4
 352           size:
 353             - 0
 354         bin_pkg:
 355           data_type: text
 356           default_value: ~
 357           is_nullable: 1
 358           is_primary_key: 0
 359           is_unique: 0
 360           name: bin_pkg
 361           order: 3
 362           size:
 363             - 0
 364         bin_ver:
 365           data_type: debversion
 366           default_value: ~
 367           is_nullable: 1
 368           is_primary_key: 0
 369           is_unique: 0
 370           name: bin_ver
 371           order: 5
 372           size:
 373             - 0
 374         src_pkg:
 375           data_type: text
 376           default_value: ~
 377           is_nullable: 1
 378           is_primary_key: 0
 379           is_unique: 0
 380           name: src_pkg
 381           order: 1
 382           size:
 383             - 0
 384         src_pkg_based_on:
 385           data_type: text
 386           default_value: ~
 387           is_nullable: 1
 388           is_primary_key: 0
 389           is_unique: 0
 390           name: src_pkg_based_on
 391           order: 7
 392           size:
 393             - 0
 394         src_ver:
 395           data_type: debversion
 396           default_value: ~
 397           is_nullable: 1
 398           is_primary_key: 0
 399           is_unique: 0
 400           name: src_ver
 401           order: 2
 402           size:
 403             - 0
 404         src_ver_based_on:
 405           data_type: debversion
 406           default_value: ~
 407           is_nullable: 1
 408           is_primary_key: 0
 409           is_unique: 0
 410           name: src_ver_based_on
 411           order: 6
 412           size:
 413             - 0
 414       indices: []
 415       name: binary_versions
 416       options: []
 417       order: 3
 418     bug:
 419       constraints:
 420         - deferrable: 1
 421           expression: ''
 422           fields:
 423             - id
 424           match_type: ''
 425           name: ''
 426           on_delete: ''
 427           on_update: ''
 428           options: []
 429           reference_fields: []
 430           reference_table: ''
 431           type: PRIMARY KEY
 432         - deferrable: 0
 433           expression: ''
 434           fields:
 435             - done
 436           match_type: ''
 437           name: bug_fk_done
 438           on_delete: NO ACTION
 439           on_update: NO ACTION
 440           options: []
 441           reference_fields:
 442             - id
 443           reference_table: correspondent
 444           type: FOREIGN KEY
 445         - deferrable: 0
 446           expression: ''
 447           fields:
 448             - owner
 449           match_type: ''
 450           name: bug_fk_owner
 451           on_delete: NO ACTION
 452           on_update: NO ACTION
 453           options: []
 454           reference_fields:
 455             - id
 456           reference_table: correspondent
 457           type: FOREIGN KEY
 458         - deferrable: 0
 459           expression: ''
 460           fields:
 461             - severity
 462           match_type: ''
 463           name: bug_fk_severity
 464           on_delete: NO ACTION
 465           on_update: NO ACTION
 466           options: []
 467           reference_fields:
 468             - id
 469           reference_table: severity
 470           type: FOREIGN KEY
 471         - deferrable: 0
 472           expression: ''
 473           fields:
 474             - submitter
 475           match_type: ''
 476           name: bug_fk_submitter
 477           on_delete: NO ACTION
 478           on_update: NO ACTION
 479           options: []
 480           reference_fields:
 481             - id
 482           reference_table: correspondent
 483           type: FOREIGN KEY
 484       fields:
 485         archived:
 486           data_type: boolean
 487           default_value: !!perl/ref
 488             =: false
 489           is_nullable: 0
 490           is_primary_key: 0
 491           is_unique: 0
 492           name: archived
 493           order: 5
 494           size:
 495             - 0
 496         creation:
 497           data_type: timestamp with time zone
 498           default_value: !!perl/ref
 499             =: current_timestamp
 500           is_nullable: 0
 501           is_primary_key: 0
 502           is_unique: 0
 503           name: creation
 504           order: 2
 505           size:
 506             - 0
 507         done:
 508           data_type: integer
 509           default_value: ~
 510           is_nullable: 1
 511           is_primary_key: 0
 512           is_unique: 0
 513           name: done
 514           order: 12
 515           size:
 516             - 0
 517         done_full:
 518           data_type: text
 519           default_value: ''
 520           is_nullable: 0
 521           is_primary_key: 0
 522           is_unique: 0
 523           name: done_full
 524           order: 13
 525           size:
 526             - 0
 527         forwarded:
 528           data_type: text
 529           default_value: ''
 530           is_nullable: 0
 531           is_primary_key: 0
 532           is_unique: 0
 533           name: forwarded
 534           order: 7
 535           size:
 536             - 0
 537         id:
 538           data_type: integer
 539           default_value: ~
 540           is_nullable: 0
 541           is_primary_key: 1
 542           is_unique: 0
 543           name: id
 544           order: 1
 545           size:
 546             - 0
 547         last_modified:
 548           data_type: timestamp with time zone
 549           default_value: !!perl/ref
 550             =: current_timestamp
 551           is_nullable: 0
 552           is_primary_key: 0
 553           is_unique: 0
 554           name: last_modified
 555           order: 4
 556           size:
 557             - 0
 558         log_modified:
 559           data_type: timestamp with time zone
 560           default_value: !!perl/ref
 561             =: current_timestamp
 562           is_nullable: 0
 563           is_primary_key: 0
 564           is_unique: 0
 565           name: log_modified
 566           order: 3
 567           size:
 568             - 0
 569         outlook:
 570           data_type: text
 571           default_value: ''
 572           is_nullable: 0
 573           is_primary_key: 0
 574           is_unique: 0
 575           name: outlook
 576           order: 9
 577           size:
 578             - 0
 579         owner:
 580           data_type: integer
 581           default_value: ~
 582           is_nullable: 1
 583           is_primary_key: 0
 584           is_unique: 0
 585           name: owner
 586           order: 14
 587           size:
 588             - 0
 589         owner_full:
 590           data_type: text
 591           default_value: ''
 592           is_nullable: 0
 593           is_primary_key: 0
 594           is_unique: 0
 595           name: owner_full
 596           order: 15
 597           size:
 598             - 0
 599         severity:
 600           data_type: integer
 601           default_value: ~
 602           is_nullable: 0
 603           is_primary_key: 0
 604           is_unique: 0
 605           name: severity
 606           order: 11
 607           size:
 608             - 0
 609         subject:
 610           data_type: text
 611           default_value: ~
 612           is_nullable: 0
 613           is_primary_key: 0
 614           is_unique: 0
 615           name: subject
 616           order: 10
 617           size:
 618             - 0
 619         submitter:
 620           data_type: integer
 621           default_value: ~
 622           is_nullable: 1
 623           is_primary_key: 0
 624           is_unique: 0
 625           name: submitter
 626           order: 16
 627           size:
 628             - 0
 629         submitter_full:
 630           data_type: text
 631           default_value: ''
 632           is_nullable: 0
 633           is_primary_key: 0
 634           is_unique: 0
 635           name: submitter_full
 636           order: 17
 637           size:
 638             - 0
 639         summary:
 640           data_type: text
 641           default_value: ''
 642           is_nullable: 0
 643           is_primary_key: 0
 644           is_unique: 0
 645           name: summary
 646           order: 8
 647           size:
 648             - 0
 649         unarchived:
 650           data_type: timestamp with time zone
 651           default_value: ~
 652           is_nullable: 1
 653           is_primary_key: 0
 654           is_unique: 0
 655           name: unarchived
 656           order: 6
 657           size:
 658             - 0
 659         unknown_packages:
 660           data_type: text
 661           default_value: ''
 662           is_nullable: 0
 663           is_primary_key: 0
 664           is_unique: 0
 665           name: unknown_packages
 666           order: 18
 667           size:
 668             - 0
 669       indices:
 670         - fields:
 671             - done
 672           name: bug_idx_done
 673           options: []
 674           type: NORMAL
 675         - fields:
 676             - owner
 677           name: bug_idx_owner
 678           options: []
 679           type: NORMAL
 680         - fields:
 681             - severity
 682           name: bug_idx_severity
 683           options: []
 684           type: NORMAL
 685         - fields:
 686             - submitter
 687           name: bug_idx_submitter
 688           options: []
 689           type: NORMAL
 690       name: bug
 691       options: []
 692       order: 16
 693     bug_binpackage:
 694       constraints:
 695         - deferrable: 1
 696           expression: ''
 697           fields:
 698             - id
 699           match_type: ''
 700           name: ''
 701           on_delete: ''
 702           on_update: ''
 703           options: []
 704           reference_fields: []
 705           reference_table: ''
 706           type: PRIMARY KEY
 707         - deferrable: 1
 708           expression: ''
 709           fields:
 710             - bug
 711             - bin_pkg
 712           match_type: ''
 713           name: bug_binpackage_id_pkg
 714           on_delete: ''
 715           on_update: ''
 716           options: []
 717           reference_fields: []
 718           reference_table: ''
 719           type: UNIQUE
 720         - deferrable: 0
 721           expression: ''
 722           fields:
 723             - bin_pkg
 724           match_type: ''
 725           name: bug_binpackage_fk_bin_pkg
 726           on_delete: NO ACTION
 727           on_update: NO ACTION
 728           options: []
 729           reference_fields:
 730             - id
 731           reference_table: bin_pkg
 732           type: FOREIGN KEY
 733         - deferrable: 0
 734           expression: ''
 735           fields:
 736             - bug
 737           match_type: ''
 738           name: bug_binpackage_fk_bug
 739           on_delete: NO ACTION
 740           on_update: NO ACTION
 741           options: []
 742           reference_fields:
 743             - id
 744           reference_table: bug
 745           type: FOREIGN KEY
 746       fields:
 747         bin_pkg:
 748           data_type: integer
 749           default_value: ~
 750           is_nullable: 0
 751           is_primary_key: 0
 752           is_unique: 1
 753           name: bin_pkg
 754           order: 3
 755           size:
 756             - 0
 757         bug:
 758           data_type: integer
 759           default_value: ~
 760           is_nullable: 0
 761           is_primary_key: 0
 762           is_unique: 1
 763           name: bug
 764           order: 2
 765           size:
 766             - 0
 767         id:
 768           data_type: integer
 769           default_value: ~
 770           is_auto_increment: 1
 771           is_nullable: 0
 772           is_primary_key: 1
 773           is_unique: 0
 774           name: id
 775           order: 1
 776           size:
 777             - 0
 778       indices:
 779         - fields:
 780             - bin_pkg
 781           name: bug_binpackage_idx_bin_pkg
 782           options: []
 783           type: NORMAL
 784         - fields:
 785             - bug
 786           name: bug_binpackage_idx_bug
 787           options: []
 788           type: NORMAL
 789       name: bug_binpackage
 790       options: []
 791       order: 21
 792     bug_blocks:
 793       constraints:
 794         - deferrable: 1
 795           expression: ''
 796           fields:
 797             - id
 798           match_type: ''
 799           name: ''
 800           on_delete: ''
 801           on_update: ''
 802           options: []
 803           reference_fields: []
 804           reference_table: ''
 805           type: PRIMARY KEY
 806         - deferrable: 1
 807           expression: ''
 808           fields:
 809             - bug
 810             - blocks
 811           match_type: ''
 812           name: bug_blocks_bug_id_blocks_idx
 813           on_delete: ''
 814           on_update: ''
 815           options: []
 816           reference_fields: []
 817           reference_table: ''
 818           type: UNIQUE
 819         - deferrable: 0
 820           expression: ''
 821           fields:
 822             - blocks
 823           match_type: ''
 824           name: bug_blocks_fk_blocks
 825           on_delete: NO ACTION
 826           on_update: NO ACTION
 827           options: []
 828           reference_fields:
 829             - id
 830           reference_table: bug
 831           type: FOREIGN KEY
 832         - deferrable: 0
 833           expression: ''
 834           fields:
 835             - bug
 836           match_type: ''
 837           name: bug_blocks_fk_bug
 838           on_delete: NO ACTION
 839           on_update: NO ACTION
 840           options: []
 841           reference_fields:
 842             - id
 843           reference_table: bug
 844           type: FOREIGN KEY
 845       fields:
 846         blocks:
 847           data_type: integer
 848           default_value: ~
 849           is_nullable: 0
 850           is_primary_key: 0
 851           is_unique: 1
 852           name: blocks
 853           order: 3
 854           size:
 855             - 0
 856         bug:
 857           data_type: integer
 858           default_value: ~
 859           is_nullable: 0
 860           is_primary_key: 0
 861           is_unique: 1
 862           name: bug
 863           order: 2
 864           size:
 865             - 0
 866         id:
 867           data_type: integer
 868           default_value: ~
 869           is_auto_increment: 1
 870           is_nullable: 0
 871           is_primary_key: 1
 872           is_unique: 0
 873           name: id
 874           order: 1
 875           size:
 876             - 0
 877       indices:
 878         - fields:
 879             - blocks
 880           name: bug_blocks_idx_blocks
 881           options: []
 882           type: NORMAL
 883         - fields:
 884             - bug
 885           name: bug_blocks_idx_bug
 886           options: []
 887           type: NORMAL
 888       name: bug_blocks
 889       options: []
 890       order: 18
 891     bug_merged:
 892       constraints:
 893         - deferrable: 1
 894           expression: ''
 895           fields:
 896             - id
 897           match_type: ''
 898           name: ''
 899           on_delete: ''
 900           on_update: ''
 901           options: []
 902           reference_fields: []
 903           reference_table: ''
 904           type: PRIMARY KEY
 905         - deferrable: 1
 906           expression: ''
 907           fields:
 908             - bug
 909             - merged
 910           match_type: ''
 911           name: bug_merged_bug_id_merged_idx
 912           on_delete: ''
 913           on_update: ''
 914           options: []
 915           reference_fields: []
 916           reference_table: ''
 917           type: UNIQUE
 918         - deferrable: 0
 919           expression: ''
 920           fields:
 921             - bug
 922           match_type: ''
 923           name: bug_merged_fk_bug
 924           on_delete: NO ACTION
 925           on_update: NO ACTION
 926           options: []
 927           reference_fields:
 928             - id
 929           reference_table: bug
 930           type: FOREIGN KEY
 931         - deferrable: 0
 932           expression: ''
 933           fields:
 934             - merged
 935           match_type: ''
 936           name: bug_merged_fk_merged
 937           on_delete: NO ACTION
 938           on_update: NO ACTION
 939           options: []
 940           reference_fields:
 941             - id
 942           reference_table: bug
 943           type: FOREIGN KEY
 944       fields:
 945         bug:
 946           data_type: integer
 947           default_value: ~
 948           is_nullable: 0
 949           is_primary_key: 0
 950           is_unique: 1
 951           name: bug
 952           order: 2
 953           size:
 954             - 0
 955         id:
 956           data_type: integer
 957           default_value: ~
 958           is_auto_increment: 1
 959           is_nullable: 0
 960           is_primary_key: 1
 961           is_unique: 0
 962           name: id
 963           order: 1
 964           size:
 965             - 0
 966         merged:
 967           data_type: integer
 968           default_value: ~
 969           is_nullable: 0
 970           is_primary_key: 0
 971           is_unique: 1
 972           name: merged
 973           order: 3
 974           size:
 975             - 0
 976       indices:
 977         - fields:
 978             - bug
 979           name: bug_merged_idx_bug
 980           options: []
 981           type: NORMAL
 982         - fields:
 983             - merged
 984           name: bug_merged_idx_merged
 985           options: []
 986           type: NORMAL
 987       name: bug_merged
 988       options: []
 989       order: 19
 990     bug_message:
 991       constraints:
 992         - deferrable: 1
 993           expression: ''
 994           fields:
 995             - id
 996           match_type: ''
 997           name: ''
 998           on_delete: ''
 999           on_update: ''
1000           options: []
1001           reference_fields: []
1002           reference_table: ''
1003           type: PRIMARY KEY
1004         - deferrable: 1
1005           expression: ''
1006           fields:
1007             - bug
1008             - message
1009           match_type: ''
1010           name: bug_message_bug_message_idx
1011           on_delete: ''
1012           on_update: ''
1013           options: []
1014           reference_fields: []
1015           reference_table: ''
1016           type: UNIQUE
1017         - deferrable: 0
1018           expression: ''
1019           fields:
1020             - bug
1021           match_type: ''
1022           name: bug_message_fk_bug
1023           on_delete: CASCADE
1024           on_update: CASCADE
1025           options: []
1026           reference_fields:
1027             - id
1028           reference_table: bug
1029           type: FOREIGN KEY
1030         - deferrable: 0
1031           expression: ''
1032           fields:
1033             - message
1034           match_type: ''
1035           name: bug_message_fk_message
1036           on_delete: CASCADE
1037           on_update: CASCADE
1038           options: []
1039           reference_fields:
1040             - id
1041           reference_table: message
1042           type: FOREIGN KEY
1043       fields:
1044         bug:
1045           data_type: integer
1046           default_value: ~
1047           is_nullable: 0
1048           is_primary_key: 0
1049           is_unique: 1
1050           name: bug
1051           order: 2
1052           size:
1053             - 0
1054         bug_log_offset:
1055           data_type: integer
1056           default_value: ~
1057           is_nullable: 1
1058           is_primary_key: 0
1059           is_unique: 0
1060           name: bug_log_offset
1061           order: 5
1062           size:
1063             - 0
1064         id:
1065           data_type: integer
1066           default_value: ~
1067           is_auto_increment: 1
1068           is_nullable: 0
1069           is_primary_key: 1
1070           is_unique: 0
1071           name: id
1072           order: 1
1073           size:
1074             - 0
1075         message:
1076           data_type: integer
1077           default_value: ~
1078           is_nullable: 0
1079           is_primary_key: 0
1080           is_unique: 1
1081           name: message
1082           order: 3
1083           size:
1084             - 0
1085         message_number:
1086           data_type: integer
1087           default_value: ~
1088           is_nullable: 0
1089           is_primary_key: 0
1090           is_unique: 0
1091           name: message_number
1092           order: 4
1093           size:
1094             - 0
1095         offset_valid:
1096           data_type: timestamp with time zone
1097           default_value: ~
1098           is_nullable: 1
1099           is_primary_key: 0
1100           is_unique: 0
1101           name: offset_valid
1102           order: 6
1103           size:
1104             - 0
1105       indices:
1106         - fields:
1107             - bug
1108           name: bug_message_idx_bug
1109           options: []
1110           type: NORMAL
1111         - fields:
1112             - message
1113           name: bug_message_idx_message
1114           options: []
1115           type: NORMAL
1116       name: bug_message
1117       options: []
1118       order: 22
1119     bug_package:
1120       constraints: []
1121       fields:
1122         bug:
1123           data_type: integer
1124           default_value: ~
1125           is_nullable: 1
1126           is_primary_key: 0
1127           is_unique: 0
1128           name: bug
1129           order: 1
1130           size:
1131             - 0
1132         package:
1133           data_type: text
1134           default_value: ~
1135           is_nullable: 1
1136           is_primary_key: 0
1137           is_unique: 0
1138           name: package
1139           order: 4
1140           size:
1141             - 0
1142         pkg_id:
1143           data_type: integer
1144           default_value: ~
1145           is_nullable: 1
1146           is_primary_key: 0
1147           is_unique: 0
1148           name: pkg_id
1149           order: 2
1150           size:
1151             - 0
1152         pkg_type:
1153           data_type: text
1154           default_value: ~
1155           is_nullable: 1
1156           is_primary_key: 0
1157           is_unique: 0
1158           name: pkg_type
1159           order: 3
1160           size:
1161             - 0
1162       indices: []
1163       name: bug_package
1164       options: []
1165       order: 4
1166     bug_srcpackage:
1167       constraints:
1168         - deferrable: 1
1169           expression: ''
1170           fields:
1171             - id
1172           match_type: ''
1173           name: ''
1174           on_delete: ''
1175           on_update: ''
1176           options: []
1177           reference_fields: []
1178           reference_table: ''
1179           type: PRIMARY KEY
1180         - deferrable: 1
1181           expression: ''
1182           fields:
1183             - bug
1184             - src_pkg
1185           match_type: ''
1186           name: bug_srcpackage_id_pkg
1187           on_delete: ''
1188           on_update: ''
1189           options: []
1190           reference_fields: []
1191           reference_table: ''
1192           type: UNIQUE
1193         - deferrable: 0
1194           expression: ''
1195           fields:
1196             - bug
1197           match_type: ''
1198           name: bug_srcpackage_fk_bug
1199           on_delete: NO ACTION
1200           on_update: NO ACTION
1201           options: []
1202           reference_fields:
1203             - id
1204           reference_table: bug
1205           type: FOREIGN KEY
1206         - deferrable: 0
1207           expression: ''
1208           fields:
1209             - src_pkg
1210           match_type: ''
1211           name: bug_srcpackage_fk_src_pkg
1212           on_delete: CASCADE
1213           on_update: CASCADE
1214           options: []
1215           reference_fields:
1216             - id
1217           reference_table: src_pkg
1218           type: FOREIGN KEY
1219       fields:
1220         bug:
1221           data_type: integer
1222           default_value: ~
1223           is_nullable: 0
1224           is_primary_key: 0
1225           is_unique: 1
1226           name: bug
1227           order: 2
1228           size:
1229             - 0
1230         id:
1231           data_type: integer
1232           default_value: ~
1233           is_auto_increment: 1
1234           is_nullable: 0
1235           is_primary_key: 1
1236           is_unique: 0
1237           name: id
1238           order: 1
1239           size:
1240             - 0
1241         src_pkg:
1242           data_type: integer
1243           default_value: ~
1244           is_nullable: 0
1245           is_primary_key: 0
1246           is_unique: 1
1247           name: src_pkg
1248           order: 3
1249           size:
1250             - 0
1251       indices:
1252         - fields:
1253             - bug
1254           name: bug_srcpackage_idx_bug
1255           options: []
1256           type: NORMAL
1257         - fields:
1258             - src_pkg
1259           name: bug_srcpackage_idx_src_pkg
1260           options: []
1261           type: NORMAL
1262       name: bug_srcpackage
1263       options: []
1264       order: 23
1265     bug_status_cache:
1266       constraints:
1267         - deferrable: 1
1268           expression: ''
1269           fields:
1270             - id
1271           match_type: ''
1272           name: ''
1273           on_delete: ''
1274           on_update: ''
1275           options: []
1276           reference_fields: []
1277           reference_table: ''
1278           type: PRIMARY KEY
1279         - deferrable: 1
1280           expression: ''
1281           fields:
1282             - bug
1283             - suite
1284             - arch
1285           match_type: ''
1286           name: bug_status_cache_bug_suite_arch_idx
1287           on_delete: ''
1288           on_update: ''
1289           options: []
1290           reference_fields: []
1291           reference_table: ''
1292           type: UNIQUE
1293         - deferrable: 0
1294           expression: ''
1295           fields:
1296             - arch
1297           match_type: ''
1298           name: bug_status_cache_fk_arch
1299           on_delete: CASCADE
1300           on_update: CASCADE
1301           options: []
1302           reference_fields:
1303             - id
1304           reference_table: arch
1305           type: FOREIGN KEY
1306         - deferrable: 0
1307           expression: ''
1308           fields:
1309             - bug
1310           match_type: ''
1311           name: bug_status_cache_fk_bug
1312           on_delete: CASCADE
1313           on_update: CASCADE
1314           options: []
1315           reference_fields:
1316             - id
1317           reference_table: bug
1318           type: FOREIGN KEY
1319         - deferrable: 0
1320           expression: ''
1321           fields:
1322             - suite
1323           match_type: ''
1324           name: bug_status_cache_fk_suite
1325           on_delete: CASCADE
1326           on_update: CASCADE
1327           options: []
1328           reference_fields:
1329             - id
1330           reference_table: suite
1331           type: FOREIGN KEY
1332       fields:
1333         arch:
1334           data_type: integer
1335           default_value: ~
1336           is_nullable: 1
1337           is_primary_key: 0
1338           is_unique: 1
1339           name: arch
1340           order: 4
1341           size:
1342             - 0
1343         asof:
1344           data_type: timestamp with time zone
1345           default_value: !!perl/ref
1346             =: current_timestamp
1347           is_nullable: 0
1348           is_primary_key: 0
1349           is_unique: 0
1350           name: asof
1351           order: 7
1352           size:
1353             - 0
1354         bug:
1355           data_type: integer
1356           default_value: ~
1357           is_nullable: 0
1358           is_primary_key: 0
1359           is_unique: 1
1360           name: bug
1361           order: 2
1362           size:
1363             - 0
1364         id:
1365           data_type: integer
1366           default_value: ~
1367           is_auto_increment: 1
1368           is_nullable: 0
1369           is_primary_key: 1
1370           is_unique: 0
1371           name: id
1372           order: 1
1373           size:
1374             - 0
1375         modified:
1376           data_type: timestamp with time zone
1377           default_value: !!perl/ref
1378             =: current_timestamp
1379           is_nullable: 0
1380           is_primary_key: 0
1381           is_unique: 0
1382           name: modified
1383           order: 6
1384           size:
1385             - 0
1386         status:
1387           data_type: enum
1388           default_value: ~
1389           extra:
1390             custom_type_name: bug_status_type
1391             list:
1392               - pending
1393               - forwarded
1394               - pending-fixed
1395               - fixed
1396               - absent
1397               - done
1398           is_nullable: 0
1399           is_primary_key: 0
1400           is_unique: 0
1401           name: status
1402           order: 5
1403           size:
1404             - 0
1405         suite:
1406           data_type: integer
1407           default_value: ~
1408           is_nullable: 1
1409           is_primary_key: 0
1410           is_unique: 1
1411           name: suite
1412           order: 3
1413           size:
1414             - 0
1415       indices:
1416         - fields:
1417             - arch
1418           name: bug_status_cache_idx_arch
1419           options: []
1420           type: NORMAL
1421         - fields:
1422             - bug
1423           name: bug_status_cache_idx_bug
1424           options: []
1425           type: NORMAL
1426         - fields:
1427             - suite
1428           name: bug_status_cache_idx_suite
1429           options: []
1430           type: NORMAL
1431       name: bug_status_cache
1432       options: []
1433       order: 25
1434     bug_tag:
1435       constraints:
1436         - deferrable: 1
1437           expression: ''
1438           fields:
1439             - id
1440           match_type: ''
1441           name: ''
1442           on_delete: ''
1443           on_update: ''
1444           options: []
1445           reference_fields: []
1446           reference_table: ''
1447           type: PRIMARY KEY
1448         - deferrable: 1
1449           expression: ''
1450           fields:
1451             - bug
1452             - tag
1453           match_type: ''
1454           name: bug_tag_bug_tag
1455           on_delete: ''
1456           on_update: ''
1457           options: []
1458           reference_fields: []
1459           reference_table: ''
1460           type: UNIQUE
1461         - deferrable: 0
1462           expression: ''
1463           fields:
1464             - bug
1465           match_type: ''
1466           name: bug_tag_fk_bug
1467           on_delete: NO ACTION
1468           on_update: NO ACTION
1469           options: []
1470           reference_fields:
1471             - id
1472           reference_table: bug
1473           type: FOREIGN KEY
1474         - deferrable: 0
1475           expression: ''
1476           fields:
1477             - tag
1478           match_type: ''
1479           name: bug_tag_fk_tag
1480           on_delete: NO ACTION
1481           on_update: NO ACTION
1482           options: []
1483           reference_fields:
1484             - id
1485           reference_table: tag
1486           type: FOREIGN KEY
1487       fields:
1488         bug:
1489           data_type: integer
1490           default_value: ~
1491           is_nullable: 0
1492           is_primary_key: 0
1493           is_unique: 1
1494           name: bug
1495           order: 2
1496           size:
1497             - 0
1498         id:
1499           data_type: integer
1500           default_value: ~
1501           is_auto_increment: 1
1502           is_nullable: 0
1503           is_primary_key: 1
1504           is_unique: 0
1505           name: id
1506           order: 1
1507           size:
1508             - 0
1509         tag:
1510           data_type: integer
1511           default_value: ~
1512           is_nullable: 0
1513           is_primary_key: 0
1514           is_unique: 1
1515           name: tag
1516           order: 3
1517           size:
1518             - 0
1519       indices:
1520         - fields:
1521             - bug
1522           name: bug_tag_idx_bug
1523           options: []
1524           type: NORMAL
1525         - fields:
1526             - tag
1527           name: bug_tag_idx_tag
1528           options: []
1529           type: NORMAL
1530       name: bug_tag
1531       options: []
1532       order: 24
1533     bug_ver:
1534       constraints:
1535         - deferrable: 1
1536           expression: ''
1537           fields:
1538             - id
1539           match_type: ''
1540           name: ''
1541           on_delete: ''
1542           on_update: ''
1543           options: []
1544           reference_fields: []
1545           reference_table: ''
1546           type: PRIMARY KEY
1547         - deferrable: 1
1548           expression: ''
1549           fields:
1550             - bug
1551             - ver_string
1552             - found
1553           match_type: ''
1554           name: bug_ver_bug_ver_string_found_idx
1555           on_delete: ''
1556           on_update: ''
1557           options: []
1558           reference_fields: []
1559           reference_table: ''
1560           type: UNIQUE
1561         - deferrable: 0
1562           expression: ''
1563           fields:
1564             - bug
1565           match_type: ''
1566           name: bug_ver_fk_bug
1567           on_delete: RESTRICT
1568           on_update: CASCADE
1569           options: []
1570           reference_fields:
1571             - id
1572           reference_table: bug
1573           type: FOREIGN KEY
1574         - deferrable: 0
1575           expression: ''
1576           fields:
1577             - src_pkg
1578           match_type: ''
1579           name: bug_ver_fk_src_pkg
1580           on_delete: SET NULL
1581           on_update: CASCADE
1582           options: []
1583           reference_fields:
1584             - id
1585           reference_table: src_pkg
1586           type: FOREIGN KEY
1587         - deferrable: 0
1588           expression: ''
1589           fields:
1590             - src_ver
1591           match_type: ''
1592           name: bug_ver_fk_src_ver
1593           on_delete: SET NULL
1594           on_update: CASCADE
1595           options: []
1596           reference_fields:
1597             - id
1598           reference_table: src_ver
1599           type: FOREIGN KEY
1600       fields:
1601         bug:
1602           data_type: integer
1603           default_value: ~
1604           is_nullable: 0
1605           is_primary_key: 0
1606           is_unique: 1
1607           name: bug
1608           order: 2
1609           size:
1610             - 0
1611         creation:
1612           data_type: timestamp with time zone
1613           default_value: !!perl/ref
1614             =: current_timestamp
1615           is_nullable: 0
1616           is_primary_key: 0
1617           is_unique: 0
1618           name: creation
1619           order: 7
1620           size:
1621             - 0
1622         found:
1623           data_type: boolean
1624           default_value: !!perl/ref
1625             =: true
1626           is_nullable: 0
1627           is_primary_key: 0
1628           is_unique: 1
1629           name: found
1630           order: 6
1631           size:
1632             - 0
1633         id:
1634           data_type: integer
1635           default_value: ~
1636           is_auto_increment: 1
1637           is_nullable: 0
1638           is_primary_key: 1
1639           is_unique: 0
1640           name: id
1641           order: 1
1642           size:
1643             - 0
1644         last_modified:
1645           data_type: timestamp with time zone
1646           default_value: !!perl/ref
1647             =: current_timestamp
1648           is_nullable: 0
1649           is_primary_key: 0
1650           is_unique: 0
1651           name: last_modified
1652           order: 8
1653           size:
1654             - 0
1655         src_pkg:
1656           data_type: integer
1657           default_value: ~
1658           is_nullable: 1
1659           is_primary_key: 0
1660           is_unique: 0
1661           name: src_pkg
1662           order: 4
1663           size:
1664             - 0
1665         src_ver:
1666           data_type: integer
1667           default_value: ~
1668           is_nullable: 1
1669           is_primary_key: 0
1670           is_unique: 0
1671           name: src_ver
1672           order: 5
1673           size:
1674             - 0
1675         ver_string:
1676           data_type: text
1677           default_value: ~
1678           is_nullable: 1
1679           is_primary_key: 0
1680           is_unique: 1
1681           name: ver_string
1682           order: 3
1683           size:
1684             - 0
1685       indices:
1686         - fields:
1687             - bug
1688           name: bug_ver_idx_bug
1689           options: []
1690           type: NORMAL
1691         - fields:
1692             - src_pkg
1693           name: bug_ver_idx_src_pkg
1694           options: []
1695           type: NORMAL
1696         - fields:
1697             - src_ver
1698           name: bug_ver_idx_src_ver
1699           options: []
1700           type: NORMAL
1701       name: bug_ver
1702       options: []
1703       order: 28
1704     column_comments:
1705       constraints:
1706         - deferrable: 1
1707           expression: ''
1708           fields:
1709             - table_name
1710             - column_name
1711           match_type: ''
1712           name: column_comments_table_name_column_name_idx
1713           on_delete: ''
1714           on_update: ''
1715           options: []
1716           reference_fields: []
1717           reference_table: ''
1718           type: UNIQUE
1719       fields:
1720         column_name:
1721           data_type: text
1722           default_value: ~
1723           is_nullable: 0
1724           is_primary_key: 0
1725           is_unique: 1
1726           name: column_name
1727           order: 2
1728           size:
1729             - 0
1730         comment_text:
1731           data_type: text
1732           default_value: ~
1733           is_nullable: 0
1734           is_primary_key: 0
1735           is_unique: 0
1736           name: comment_text
1737           order: 3
1738           size:
1739             - 0
1740         table_name:
1741           data_type: text
1742           default_value: ~
1743           is_nullable: 0
1744           is_primary_key: 0
1745           is_unique: 1
1746           name: table_name
1747           order: 1
1748           size:
1749             - 0
1750       indices: []
1751       name: column_comments
1752       options: []
1753       order: 5
1754     correspondent:
1755       constraints:
1756         - deferrable: 1
1757           expression: ''
1758           fields:
1759             - id
1760           match_type: ''
1761           name: ''
1762           on_delete: ''
1763           on_update: ''
1764           options: []
1765           reference_fields: []
1766           reference_table: ''
1767           type: PRIMARY KEY
1768         - deferrable: 1
1769           expression: ''
1770           fields:
1771             - addr
1772           match_type: ''
1773           name: correspondent_addr_idx
1774           on_delete: ''
1775           on_update: ''
1776           options: []
1777           reference_fields: []
1778           reference_table: ''
1779           type: UNIQUE
1780       fields:
1781         addr:
1782           data_type: text
1783           default_value: ~
1784           is_nullable: 0
1785           is_primary_key: 0
1786           is_unique: 1
1787           name: addr
1788           order: 2
1789           size:
1790             - 0
1791         id:
1792           data_type: integer
1793           default_value: ~
1794           is_auto_increment: 1
1795           is_nullable: 0
1796           is_primary_key: 1
1797           is_unique: 0
1798           name: id
1799           order: 1
1800           size:
1801             - 0
1802       indices: []
1803       name: correspondent
1804       options: []
1805       order: 6
1806     correspondent_full_name:
1807       constraints:
1808         - deferrable: 1
1809           expression: ''
1810           fields:
1811             - id
1812           match_type: ''
1813           name: ''
1814           on_delete: ''
1815           on_update: ''
1816           options: []
1817           reference_fields: []
1818           reference_table: ''
1819           type: PRIMARY KEY
1820         - deferrable: 1
1821           expression: ''
1822           fields:
1823             - correspondent
1824             - full_name
1825           match_type: ''
1826           name: correspondent_full_name_correspondent_full_name_idx
1827           on_delete: ''
1828           on_update: ''
1829           options: []
1830           reference_fields: []
1831           reference_table: ''
1832           type: UNIQUE
1833         - deferrable: 0
1834           expression: ''
1835           fields:
1836             - correspondent
1837           match_type: ''
1838           name: correspondent_full_name_fk_correspondent
1839           on_delete: CASCADE
1840           on_update: CASCADE
1841           options: []
1842           reference_fields:
1843             - id
1844           reference_table: correspondent
1845           type: FOREIGN KEY
1846       fields:
1847         correspondent:
1848           data_type: integer
1849           default_value: ~
1850           is_nullable: 0
1851           is_primary_key: 0
1852           is_unique: 1
1853           name: correspondent
1854           order: 2
1855           size:
1856             - 0
1857         full_name:
1858           data_type: text
1859           default_value: ~
1860           is_nullable: 0
1861           is_primary_key: 0
1862           is_unique: 1
1863           name: full_name
1864           order: 3
1865           size:
1866             - 0
1867         id:
1868           data_type: integer
1869           default_value: ~
1870           is_auto_increment: 1
1871           is_nullable: 0
1872           is_primary_key: 1
1873           is_unique: 0
1874           name: id
1875           order: 1
1876           size:
1877             - 0
1878         last_seen:
1879           data_type: timestamp
1880           default_value: !!perl/ref
1881             =: current_timestamp
1882           is_nullable: 0
1883           is_primary_key: 0
1884           is_unique: 0
1885           name: last_seen
1886           order: 4
1887           size:
1888             - 0
1889       indices:
1890         - fields:
1891             - correspondent
1892           name: correspondent_full_name_idx_correspondent
1893           options: []
1894           type: NORMAL
1895       name: correspondent_full_name
1896       options: []
1897       order: 13
1898     maintainer:
1899       constraints:
1900         - deferrable: 1
1901           expression: ''
1902           fields:
1903             - id
1904           match_type: ''
1905           name: ''
1906           on_delete: ''
1907           on_update: ''
1908           options: []
1909           reference_fields: []
1910           reference_table: ''
1911           type: PRIMARY KEY
1912         - deferrable: 1
1913           expression: ''
1914           fields:
1915             - name
1916           match_type: ''
1917           name: maintainer_name_idx
1918           on_delete: ''
1919           on_update: ''
1920           options: []
1921           reference_fields: []
1922           reference_table: ''
1923           type: UNIQUE
1924         - deferrable: 0
1925           expression: ''
1926           fields:
1927             - correspondent
1928           match_type: ''
1929           name: maintainer_fk_correspondent
1930           on_delete: NO ACTION
1931           on_update: NO ACTION
1932           options: []
1933           reference_fields:
1934             - id
1935           reference_table: correspondent
1936           type: FOREIGN KEY
1937       fields:
1938         correspondent:
1939           data_type: integer
1940           default_value: ~
1941           is_nullable: 0
1942           is_primary_key: 0
1943           is_unique: 0
1944           name: correspondent
1945           order: 3
1946           size:
1947             - 0
1948         created:
1949           data_type: timestamp with time zone
1950           default_value: !!perl/ref
1951             =: current_timestamp
1952           is_nullable: 0
1953           is_primary_key: 0
1954           is_unique: 0
1955           name: created
1956           order: 4
1957           size:
1958             - 0
1959         id:
1960           data_type: integer
1961           default_value: ~
1962           is_auto_increment: 1
1963           is_nullable: 0
1964           is_primary_key: 1
1965           is_unique: 0
1966           name: id
1967           order: 1
1968           size:
1969             - 0
1970         modified:
1971           data_type: timestamp with time zone
1972           default_value: !!perl/ref
1973             =: current_timestamp
1974           is_nullable: 0
1975           is_primary_key: 0
1976           is_unique: 0
1977           name: modified
1978           order: 5
1979           size:
1980             - 0
1981         name:
1982           data_type: text
1983           default_value: ~
1984           is_nullable: 0
1985           is_primary_key: 0
1986           is_unique: 1
1987           name: name
1988           order: 2
1989           size:
1990             - 0
1991       indices:
1992         - fields:
1993             - correspondent
1994           name: maintainer_idx_correspondent
1995           options: []
1996           type: NORMAL
1997       name: maintainer
1998       options: []
1999       order: 14
2000     message:
2001       constraints:
2002         - deferrable: 1
2003           expression: ''
2004           fields:
2005             - id
2006           match_type: ''
2007           name: ''
2008           on_delete: ''
2009           on_update: ''
2010           options: []
2011           reference_fields: []
2012           reference_table: ''
2013           type: PRIMARY KEY
2014       fields:
2015         from_addr:
2016           data_type: text
2017           default_value: ~
2018           is_nullable: 1
2019           is_primary_key: 0
2020           is_unique: 0
2021           name: from_addr
2022           order: 4
2023           size:
2024             - 0
2025         from_complete:
2026           data_type: text
2027           default_value: ~
2028           is_nullable: 1
2029           is_primary_key: 0
2030           is_unique: 0
2031           name: from_complete
2032           order: 3
2033           size:
2034             - 0
2035         id:
2036           data_type: integer
2037           default_value: ~
2038           is_auto_increment: 1
2039           is_nullable: 0
2040           is_primary_key: 1
2041           is_unique: 0
2042           name: id
2043           order: 1
2044           size:
2045             - 0
2046         is_spam:
2047           data_type: boolean
2048           default_value: !!perl/ref
2049             =: false
2050           is_nullable: 1
2051           is_primary_key: 0
2052           is_unique: 0
2053           name: is_spam
2054           order: 11
2055           size:
2056             - 0
2057         msgid:
2058           data_type: text
2059           default_value: ~
2060           is_nullable: 1
2061           is_primary_key: 0
2062           is_unique: 0
2063           name: msgid
2064           order: 2
2065           size:
2066             - 0
2067         refs:
2068           data_type: text
2069           default_value: ''
2070           is_nullable: 0
2071           is_primary_key: 0
2072           is_unique: 0
2073           name: refs
2074           order: 9
2075           size:
2076             - 0
2077         sent_date:
2078           data_type: timestamp with time zone
2079           default_value: ~
2080           is_nullable: 1
2081           is_primary_key: 0
2082           is_unique: 0
2083           name: sent_date
2084           order: 8
2085           size:
2086             - 0
2087         spam_score:
2088           data_type: double precision
2089           default_value: ~
2090           is_nullable: 1
2091           is_primary_key: 0
2092           is_unique: 0
2093           name: spam_score
2094           order: 10
2095           size:
2096             - 0
2097         subject:
2098           data_type: text
2099           default_value: ''
2100           is_nullable: 0
2101           is_primary_key: 0
2102           is_unique: 0
2103           name: subject
2104           order: 7
2105           size:
2106             - 0
2107         to_addr:
2108           data_type: text
2109           default_value: ~
2110           is_nullable: 1
2111           is_primary_key: 0
2112           is_unique: 0
2113           name: to_addr
2114           order: 6
2115           size:
2116             - 0
2117         to_complete:
2118           data_type: text
2119           default_value: ~
2120           is_nullable: 1
2121           is_primary_key: 0
2122           is_unique: 0
2123           name: to_complete
2124           order: 5
2125           size:
2126             - 0
2127       indices: []
2128       name: message
2129       options: []
2130       order: 7
2131     message_correspondent:
2132       constraints:
2133         - deferrable: 1
2134           expression: ''
2135           fields:
2136             - id
2137           match_type: ''
2138           name: ''
2139           on_delete: ''
2140           on_update: ''
2141           options: []
2142           reference_fields: []
2143           reference_table: ''
2144           type: PRIMARY KEY
2145         - deferrable: 1
2146           expression: ''
2147           fields:
2148             - message
2149             - correspondent
2150             - correspondent_type
2151           match_type: ''
2152           name: message_correspondent_message_correspondent_correspondent_t_idx
2153           on_delete: ''
2154           on_update: ''
2155           options: []
2156           reference_fields: []
2157           reference_table: ''
2158           type: UNIQUE
2159         - deferrable: 0
2160           expression: ''
2161           fields:
2162             - correspondent
2163           match_type: ''
2164           name: message_correspondent_fk_correspondent
2165           on_delete: CASCADE
2166           on_update: CASCADE
2167           options: []
2168           reference_fields:
2169             - id
2170           reference_table: correspondent
2171           type: FOREIGN KEY
2172         - deferrable: 0
2173           expression: ''
2174           fields:
2175             - message
2176           match_type: ''
2177           name: message_correspondent_fk_message
2178           on_delete: CASCADE
2179           on_update: CASCADE
2180           options: []
2181           reference_fields:
2182             - id
2183           reference_table: message
2184           type: FOREIGN KEY
2185       fields:
2186         correspondent:
2187           data_type: integer
2188           default_value: ~
2189           is_nullable: 0
2190           is_primary_key: 0
2191           is_unique: 1
2192           name: correspondent
2193           order: 3
2194           size:
2195             - 0
2196         correspondent_type:
2197           data_type: enum
2198           default_value: to
2199           extra:
2200             custom_type_name: message_correspondent_type
2201             list:
2202               - to
2203               - from
2204               - envfrom
2205               - cc
2206           is_nullable: 0
2207           is_primary_key: 0
2208           is_unique: 1
2209           name: correspondent_type
2210           order: 4
2211           size:
2212             - 0
2213         id:
2214           data_type: integer
2215           default_value: ~
2216           is_auto_increment: 1
2217           is_nullable: 0
2218           is_primary_key: 1
2219           is_unique: 0
2220           name: id
2221           order: 1
2222           size:
2223             - 0
2224         message:
2225           data_type: integer
2226           default_value: ~
2227           is_nullable: 0
2228           is_primary_key: 0
2229           is_unique: 1
2230           name: message
2231           order: 2
2232           size:
2233             - 0
2234       indices:
2235         - fields:
2236             - correspondent
2237           name: message_correspondent_idx_correspondent
2238           options: []
2239           type: NORMAL
2240         - fields:
2241             - message
2242           name: message_correspondent_idx_message
2243           options: []
2244           type: NORMAL
2245       name: message_correspondent
2246       options: []
2247       order: 17
2248     message_refs:
2249       constraints:
2250         - deferrable: 1
2251           expression: ''
2252           fields:
2253             - id
2254           match_type: ''
2255           name: ''
2256           on_delete: ''
2257           on_update: ''
2258           options: []
2259           reference_fields: []
2260           reference_table: ''
2261           type: PRIMARY KEY
2262         - deferrable: 1
2263           expression: ''
2264           fields:
2265             - message
2266             - refs
2267           match_type: ''
2268           name: message_refs_message_refs_idx
2269           on_delete: ''
2270           on_update: ''
2271           options: []
2272           reference_fields: []
2273           reference_table: ''
2274           type: UNIQUE
2275         - deferrable: 0
2276           expression: ''
2277           fields:
2278             - message
2279           match_type: ''
2280           name: message_refs_fk_message
2281           on_delete: CASCADE
2282           on_update: CASCADE
2283           options: []
2284           reference_fields:
2285             - id
2286           reference_table: message
2287           type: FOREIGN KEY
2288         - deferrable: 0
2289           expression: ''
2290           fields:
2291             - refs
2292           match_type: ''
2293           name: message_refs_fk_refs
2294           on_delete: CASCADE
2295           on_update: CASCADE
2296           options: []
2297           reference_fields:
2298             - id
2299           reference_table: message
2300           type: FOREIGN KEY
2301       fields:
2302         id:
2303           data_type: integer
2304           default_value: ~
2305           is_auto_increment: 1
2306           is_nullable: 0
2307           is_primary_key: 1
2308           is_unique: 0
2309           name: id
2310           order: 1
2311           size:
2312             - 0
2313         inferred:
2314           data_type: boolean
2315           default_value: !!perl/ref
2316             =: false
2317           is_nullable: 1
2318           is_primary_key: 0
2319           is_unique: 0
2320           name: inferred
2321           order: 4
2322           size:
2323             - 0
2324         message:
2325           data_type: integer
2326           default_value: ~
2327           is_nullable: 0
2328           is_primary_key: 0
2329           is_unique: 1
2330           name: message
2331           order: 2
2332           size:
2333             - 0
2334         primary_ref:
2335           data_type: boolean
2336           default_value: !!perl/ref
2337             =: false
2338           is_nullable: 1
2339           is_primary_key: 0
2340           is_unique: 0
2341           name: primary_ref
2342           order: 5
2343           size:
2344             - 0
2345         refs:
2346           data_type: integer
2347           default_value: ~
2348           is_nullable: 0
2349           is_primary_key: 0
2350           is_unique: 1
2351           name: refs
2352           order: 3
2353           size:
2354             - 0
2355       indices:
2356         - fields:
2357             - message
2358           name: message_refs_idx_message
2359           options: []
2360           type: NORMAL
2361         - fields:
2362             - refs
2363           name: message_refs_idx_refs
2364           options: []
2365           type: NORMAL
2366       name: message_refs
2367       options: []
2368       order: 15
2369     severity:
2370       constraints:
2371         - deferrable: 1
2372           expression: ''
2373           fields:
2374             - id
2375           match_type: ''
2376           name: ''
2377           on_delete: ''
2378           on_update: ''
2379           options: []
2380           reference_fields: []
2381           reference_table: ''
2382           type: PRIMARY KEY
2383         - deferrable: 1
2384           expression: ''
2385           fields:
2386             - severity
2387           match_type: ''
2388           name: severity_severity_idx
2389           on_delete: ''
2390           on_update: ''
2391           options: []
2392           reference_fields: []
2393           reference_table: ''
2394           type: UNIQUE
2395       fields:
2396         id:
2397           data_type: integer
2398           default_value: ~
2399           is_auto_increment: 1
2400           is_nullable: 0
2401           is_primary_key: 1
2402           is_unique: 0
2403           name: id
2404           order: 1
2405           size:
2406             - 0
2407         obsolete:
2408           data_type: boolean
2409           default_value: !!perl/ref
2410             =: false
2411           is_nullable: 1
2412           is_primary_key: 0
2413           is_unique: 0
2414           name: obsolete
2415           order: 5
2416           size:
2417             - 0
2418         ordering:
2419           data_type: integer
2420           default_value: 5
2421           is_nullable: 0
2422           is_primary_key: 0
2423           is_unique: 0
2424           name: ordering
2425           order: 3
2426           size:
2427             - 0
2428         severity:
2429           data_type: text
2430           default_value: ~
2431           is_nullable: 0
2432           is_primary_key: 0
2433           is_unique: 1
2434           name: severity
2435           order: 2
2436           size:
2437             - 0
2438         strong:
2439           data_type: boolean
2440           default_value: !!perl/ref
2441             =: false
2442           is_nullable: 1
2443           is_primary_key: 0
2444           is_unique: 0
2445           name: strong
2446           order: 4
2447           size:
2448             - 0
2449       indices: []
2450       name: severity
2451       options: []
2452       order: 8
2453     src_associations:
2454       constraints:
2455         - deferrable: 1
2456           expression: ''
2457           fields:
2458             - id
2459           match_type: ''
2460           name: ''
2461           on_delete: ''
2462           on_update: ''
2463           options: []
2464           reference_fields: []
2465           reference_table: ''
2466           type: PRIMARY KEY
2467         - deferrable: 0
2468           expression: ''
2469           fields:
2470             - source
2471           match_type: ''
2472           name: src_associations_fk_source
2473           on_delete: CASCADE
2474           on_update: CASCADE
2475           options: []
2476           reference_fields:
2477             - id
2478           reference_table: src_ver
2479           type: FOREIGN KEY
2480         - deferrable: 0
2481           expression: ''
2482           fields:
2483             - suite
2484           match_type: ''
2485           name: src_associations_fk_suite
2486           on_delete: CASCADE
2487           on_update: CASCADE
2488           options: []
2489           reference_fields:
2490             - id
2491           reference_table: suite
2492           type: FOREIGN KEY
2493       fields:
2494         created:
2495           data_type: timestamp with time zone
2496           default_value: !!perl/ref
2497             =: current_timestamp
2498           is_nullable: 0
2499           is_primary_key: 0
2500           is_unique: 0
2501           name: created
2502           order: 4
2503           size:
2504             - 0
2505         id:
2506           data_type: integer
2507           default_value: ~
2508           is_auto_increment: 1
2509           is_nullable: 0
2510           is_primary_key: 1
2511           is_unique: 0
2512           name: id
2513           order: 1
2514           size:
2515             - 0
2516         modified:
2517           data_type: timestamp with time zone
2518           default_value: !!perl/ref
2519             =: current_timestamp
2520           is_nullable: 0
2521           is_primary_key: 0
2522           is_unique: 0
2523           name: modified
2524           order: 5
2525           size:
2526             - 0
2527         source:
2528           data_type: integer
2529           default_value: ~
2530           is_nullable: 0
2531           is_primary_key: 0
2532           is_unique: 0
2533           name: source
2534           order: 3
2535           size:
2536             - 0
2537         suite:
2538           data_type: integer
2539           default_value: ~
2540           is_nullable: 0
2541           is_primary_key: 0
2542           is_unique: 0
2543           name: suite
2544           order: 2
2545           size:
2546             - 0
2547       indices:
2548         - fields:
2549             - source
2550           name: src_associations_idx_source
2551           options: []
2552           type: NORMAL
2553         - fields:
2554             - suite
2555           name: src_associations_idx_suite
2556           options: []
2557           type: NORMAL
2558       name: src_associations
2559       options: []
2560       order: 26
2561     src_pkg:
2562       constraints:
2563         - deferrable: 1
2564           expression: ''
2565           fields:
2566             - id
2567           match_type: ''
2568           name: ''
2569           on_delete: ''
2570           on_update: ''
2571           options: []
2572           reference_fields: []
2573           reference_table: ''
2574           type: PRIMARY KEY
2575         - deferrable: 1
2576           expression: ''
2577           fields:
2578             - pkg
2579             - disabled
2580           match_type: ''
2581           name: src_pkg_pkg_disabled
2582           on_delete: ''
2583           on_update: ''
2584           options: []
2585           reference_fields: []
2586           reference_table: ''
2587           type: UNIQUE
2588         - deferrable: 0
2589           expression: ''
2590           fields:
2591             - alias_of
2592           match_type: ''
2593           name: src_pkg_fk_alias_of
2594           on_delete: CASCADE
2595           on_update: CASCADE
2596           options: []
2597           reference_fields:
2598             - id
2599           reference_table: src_pkg
2600           type: FOREIGN KEY
2601       fields:
2602         alias_of:
2603           data_type: integer
2604           default_value: ~
2605           is_nullable: 1
2606           is_primary_key: 0
2607           is_unique: 0
2608           name: alias_of
2609           order: 4
2610           size:
2611             - 0
2612         creation:
2613           data_type: timestamp with time zone
2614           default_value: !!perl/ref
2615             =: current_timestamp
2616           is_nullable: 1
2617           is_primary_key: 0
2618           is_unique: 0
2619           name: creation
2620           order: 5
2621           size:
2622             - 0
2623         disabled:
2624           data_type: timestamp with time zone
2625           default_value: ~
2626           is_nullable: 1
2627           is_primary_key: 0
2628           is_unique: 1
2629           name: disabled
2630           order: 6
2631           size:
2632             - 0
2633         id:
2634           data_type: integer
2635           default_value: ~
2636           is_auto_increment: 1
2637           is_nullable: 0
2638           is_primary_key: 1
2639           is_unique: 0
2640           name: id
2641           order: 1
2642           size:
2643             - 0
2644         last_modified:
2645           data_type: timestamp with time zone
2646           default_value: !!perl/ref
2647             =: current_timestamp
2648           is_nullable: 1
2649           is_primary_key: 0
2650           is_unique: 0
2651           name: last_modified
2652           order: 7
2653           size:
2654             - 0
2655         obsolete:
2656           data_type: boolean
2657           default_value: !!perl/ref
2658             =: false
2659           is_nullable: 1
2660           is_primary_key: 0
2661           is_unique: 0
2662           name: obsolete
2663           order: 8
2664           size:
2665             - 0
2666         pkg:
2667           data_type: text
2668           default_value: ~
2669           is_nullable: 0
2670           is_primary_key: 0
2671           is_unique: 1
2672           name: pkg
2673           order: 2
2674           size:
2675             - 0
2676         pseduopkg:
2677           data_type: boolean
2678           default_value: !!perl/ref
2679             =: false
2680           is_nullable: 1
2681           is_primary_key: 0
2682           is_unique: 0
2683           name: pseduopkg
2684           order: 3
2685           size:
2686             - 0
2687       indices:
2688         - fields:
2689             - alias_of
2690           name: src_pkg_idx_alias_of
2691           options: []
2692           type: NORMAL
2693       name: src_pkg
2694       options: []
2695       order: 9
2696     src_ver:
2697       constraints:
2698         - deferrable: 1
2699           expression: ''
2700           fields:
2701             - id
2702           match_type: ''
2703           name: ''
2704           on_delete: ''
2705           on_update: ''
2706           options: []
2707           reference_fields: []
2708           reference_table: ''
2709           type: PRIMARY KEY
2710         - deferrable: 1
2711           expression: ''
2712           fields:
2713             - src_pkg
2714             - ver
2715           match_type: ''
2716           name: src_ver_src_pkg_id_ver
2717           on_delete: ''
2718           on_update: ''
2719           options: []
2720           reference_fields: []
2721           reference_table: ''
2722           type: UNIQUE
2723         - deferrable: 0
2724           expression: ''
2725           fields:
2726             - based_on
2727           match_type: ''
2728           name: src_ver_fk_based_on
2729           on_delete: CASCADE
2730           on_update: CASCADE
2731           options: []
2732           reference_fields:
2733             - id
2734           reference_table: src_ver
2735           type: FOREIGN KEY
2736         - deferrable: 0
2737           expression: ''
2738           fields:
2739             - maintainer
2740           match_type: ''
2741           name: src_ver_fk_maintainer
2742           on_delete: SET NULL
2743           on_update: CASCADE
2744           options: []
2745           reference_fields:
2746             - id
2747           reference_table: maintainer
2748           type: FOREIGN KEY
2749         - deferrable: 0
2750           expression: ''
2751           fields:
2752             - src_pkg
2753           match_type: ''
2754           name: src_ver_fk_src_pkg
2755           on_delete: CASCADE
2756           on_update: CASCADE
2757           options: []
2758           reference_fields:
2759             - id
2760           reference_table: src_pkg
2761           type: FOREIGN KEY
2762       fields:
2763         based_on:
2764           data_type: integer
2765           default_value: ~
2766           is_nullable: 1
2767           is_primary_key: 0
2768           is_unique: 0
2769           name: based_on
2770           order: 6
2771           size:
2772             - 0
2773         id:
2774           data_type: integer
2775           default_value: ~
2776           is_auto_increment: 1
2777           is_nullable: 0
2778           is_primary_key: 1
2779           is_unique: 0
2780           name: id
2781           order: 1
2782           size:
2783             - 0
2784         maintainer:
2785           data_type: integer
2786           default_value: ~
2787           is_nullable: 1
2788           is_primary_key: 0
2789           is_unique: 0
2790           name: maintainer
2791           order: 4
2792           size:
2793             - 0
2794         src_pkg:
2795           data_type: integer
2796           default_value: ~
2797           is_nullable: 0
2798           is_primary_key: 0
2799           is_unique: 1
2800           name: src_pkg
2801           order: 2
2802           size:
2803             - 0
2804         upload_date:
2805           data_type: timestamp with time zone
2806           default_value: !!perl/ref
2807             =: current_timestamp
2808           is_nullable: 0
2809           is_primary_key: 0
2810           is_unique: 0
2811           name: upload_date
2812           order: 5
2813           size:
2814             - 0
2815         ver:
2816           data_type: debversion
2817           default_value: ~
2818           is_nullable: 0
2819           is_primary_key: 0
2820           is_unique: 1
2821           name: ver
2822           order: 3
2823           size:
2824             - 0
2825       indices:
2826         - fields:
2827             - based_on
2828           name: src_ver_idx_based_on
2829           options: []
2830           type: NORMAL
2831         - fields:
2832             - maintainer
2833           name: src_ver_idx_maintainer
2834           options: []
2835           type: NORMAL
2836         - fields:
2837             - src_pkg
2838           name: src_ver_idx_src_pkg
2839           options: []
2840           type: NORMAL
2841       name: src_ver
2842       options: []
2843       order: 20
2844     suite:
2845       constraints:
2846         - deferrable: 1
2847           expression: ''
2848           fields:
2849             - id
2850           match_type: ''
2851           name: ''
2852           on_delete: ''
2853           on_update: ''
2854           options: []
2855           reference_fields: []
2856           reference_table: ''
2857           type: PRIMARY KEY
2858         - deferrable: 1
2859           expression: ''
2860           fields:
2861             - suite_name
2862           match_type: ''
2863           name: suite_suite_name_key
2864           on_delete: ''
2865           on_update: ''
2866           options: []
2867           reference_fields: []
2868           reference_table: ''
2869           type: UNIQUE
2870       fields:
2871         active:
2872           data_type: boolean
2873           default_value: !!perl/ref
2874             =: true
2875           is_nullable: 1
2876           is_primary_key: 0
2877           is_unique: 0
2878           name: active
2879           order: 5
2880           size:
2881             - 0
2882         codename:
2883           data_type: text
2884           default_value: ~
2885           is_nullable: 1
2886           is_primary_key: 0
2887           is_unique: 0
2888           name: codename
2889           order: 4
2890           size:
2891             - 0
2892         id:
2893           data_type: integer
2894           default_value: ~
2895           is_auto_increment: 1
2896           is_nullable: 0
2897           is_primary_key: 1
2898           is_unique: 0
2899           name: id
2900           order: 1
2901           size:
2902             - 0
2903         suite_name:
2904           data_type: text
2905           default_value: ~
2906           is_nullable: 0
2907           is_primary_key: 0
2908           is_unique: 1
2909           name: suite_name
2910           order: 2
2911           size:
2912             - 0
2913         version:
2914           data_type: text
2915           default_value: ~
2916           is_nullable: 1
2917           is_primary_key: 0
2918           is_unique: 0
2919           name: version
2920           order: 3
2921           size:
2922             - 0
2923       indices: []
2924       name: suite
2925       options: []
2926       order: 10
2927     table_comments:
2928       constraints:
2929         - deferrable: 1
2930           expression: ''
2931           fields:
2932             - table_name
2933           match_type: ''
2934           name: table_comments_table_name_key
2935           on_delete: ''
2936           on_update: ''
2937           options: []
2938           reference_fields: []
2939           reference_table: ''
2940           type: UNIQUE
2941       fields:
2942         comment_text:
2943           data_type: text
2944           default_value: ~
2945           is_nullable: 0
2946           is_primary_key: 0
2947           is_unique: 0
2948           name: comment_text
2949           order: 2
2950           size:
2951             - 0
2952         table_name:
2953           data_type: text
2954           default_value: ~
2955           is_nullable: 0
2956           is_primary_key: 0
2957           is_unique: 1
2958           name: table_name
2959           order: 1
2960           size:
2961             - 0
2962       indices: []
2963       name: table_comments
2964       options: []
2965       order: 11
2966     tag:
2967       constraints:
2968         - deferrable: 1
2969           expression: ''
2970           fields:
2971             - id
2972           match_type: ''
2973           name: ''
2974           on_delete: ''
2975           on_update: ''
2976           options: []
2977           reference_fields: []
2978           reference_table: ''
2979           type: PRIMARY KEY
2980         - deferrable: 1
2981           expression: ''
2982           fields:
2983             - tag
2984           match_type: ''
2985           name: tag_tag_key
2986           on_delete: ''
2987           on_update: ''
2988           options: []
2989           reference_fields: []
2990           reference_table: ''
2991           type: UNIQUE
2992       fields:
2993         id:
2994           data_type: integer
2995           default_value: ~
2996           is_auto_increment: 1
2997           is_nullable: 0
2998           is_primary_key: 1
2999           is_unique: 0
3000           name: id
3001           order: 1
3002           size:
3003             - 0
3004         obsolete:
3005           data_type: boolean
3006           default_value: !!perl/ref
3007             =: false
3008           is_nullable: 1
3009           is_primary_key: 0
3010           is_unique: 0
3011           name: obsolete
3012           order: 3
3013           size:
3014             - 0
3015         tag:
3016           data_type: text
3017           default_value: ~
3018           is_nullable: 0
3019           is_primary_key: 0
3020           is_unique: 1
3021           name: tag
3022           order: 2
3023           size:
3024             - 0
3025       indices: []
3026       name: tag
3027       options: []
3028       order: 12
3029   triggers: {}
3030   views: {}
3031 translator:
3032   add_drop_table: 0
3033   filename: ~
3034   no_comments: 0
3035   parser_args:
3036     sources:
3037       - Arch
3038       - BinAssociation
3039       - BinPkg
3040       - BinVer
3041       - BinaryVersion
3042       - Bug
3043       - BugBinpackage
3044       - BugBlock
3045       - BugMerged
3046       - BugMessage
3047       - BugPackage
3048       - BugSrcpackage
3049       - BugStatusCache
3050       - BugTag
3051       - BugVer
3052       - ColumnComment
3053       - Correspondent
3054       - CorrespondentFullName
3055       - Maintainer
3056       - Message
3057       - MessageCorrespondent
3058       - MessageRef
3059       - Severity
3060       - SrcAssociation
3061       - SrcPkg
3062       - SrcVer
3063       - Suite
3064       - TableComment
3065       - Tag
3066   parser_type: SQL::Translator::Parser::DBIx::Class
3067   producer_args: {}
3068   producer_type: SQL::Translator::Producer::YAML
3069   show_warnings: 0
3070   trace: 0
3071   version: 0.11018