From c35f49b5c19d83704275f3b2b5e6e006b7667d91 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Wed, 6 Nov 2013 21:20:50 -0800 Subject: [PATCH] update for correspondent in maintainer --- Debbugs/DB/Result/Arch.pm | 4 +- Debbugs/DB/Result/BinAssociation.pm | 8 ++-- Debbugs/DB/Result/BinPkg.pm | 4 +- Debbugs/DB/Result/BinVer.pm | 10 ++-- Debbugs/DB/Result/Bug.pm | 54 +++++++++++----------- Debbugs/DB/Result/BugBinpackage.pm | 8 ++-- Debbugs/DB/Result/BugBlock.pm | 8 ++-- Debbugs/DB/Result/BugMerged.pm | 8 ++-- Debbugs/DB/Result/BugMessage.pm | 8 ++-- Debbugs/DB/Result/BugPackage.pm | 4 +- Debbugs/DB/Result/BugSrcpackage.pm | 8 ++-- Debbugs/DB/Result/BugTag.pm | 8 ++-- Debbugs/DB/Result/BugVer.pm | 14 +++--- Debbugs/DB/Result/Correspondent.pm | 19 +++++++- Debbugs/DB/Result/CorrespondentFullName.pm | 6 +-- Debbugs/DB/Result/Maintainer.pm | 29 +++++++++++- Debbugs/DB/Result/MessageCorrespondent.pm | 8 ++-- Debbugs/DB/Result/MessageRef.pm | 8 ++-- Debbugs/DB/Result/SrcAssociation.pm | 8 ++-- Debbugs/DB/Result/SrcPkg.pm | 6 +-- Debbugs/DB/Result/SrcVer.pm | 12 ++--- Debbugs/DB/Result/Suite.pm | 4 +- Debbugs/DB/Result/Tag.pm | 4 +- 23 files changed, 145 insertions(+), 105 deletions(-) diff --git a/Debbugs/DB/Result/Arch.pm b/Debbugs/DB/Result/Arch.pm index 420d325..ef26e3c 100644 --- a/Debbugs/DB/Result/Arch.pm +++ b/Debbugs/DB/Result/Arch.pm @@ -124,8 +124,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-04-01 15:46:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jkMopbSgd3Carub/plyQQA +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Lp58Ajmt1p8qgL26cbgHZA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BinAssociation.pm b/Debbugs/DB/Result/BinAssociation.pm index c074597..7f32065 100644 --- a/Debbugs/DB/Result/BinAssociation.pm +++ b/Debbugs/DB/Result/BinAssociation.pm @@ -134,7 +134,7 @@ __PACKAGE__->belongs_to( "bin", "Debbugs::DB::Result::BinVer", { id => "bin" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 suite @@ -149,12 +149,12 @@ __PACKAGE__->belongs_to( "suite", "Debbugs::DB::Result::Suite", { id => "suite" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CuIGLI5HKte90nfppS4Phw +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:23:58 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zEtAfQAP6UdXRqAF3PaBGA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BinPkg.pm b/Debbugs/DB/Result/BinPkg.pm index e951e03..861c766 100644 --- a/Debbugs/DB/Result/BinPkg.pm +++ b/Debbugs/DB/Result/BinPkg.pm @@ -124,8 +124,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E/y1hURij+mI11E63GPZZg +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k32MQX4vbBhX4m9+EqR7ww # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BinVer.pm b/Debbugs/DB/Result/BinVer.pm index 688b7fe..d18614b 100644 --- a/Debbugs/DB/Result/BinVer.pm +++ b/Debbugs/DB/Result/BinVer.pm @@ -153,7 +153,7 @@ __PACKAGE__->belongs_to( "arch", "Debbugs::DB::Result::Arch", { id => "arch_id" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 bin_associations @@ -183,7 +183,7 @@ __PACKAGE__->belongs_to( "bin_pkg", "Debbugs::DB::Result::BinPkg", { id => "bin_pkg" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 src_ver @@ -198,12 +198,12 @@ __PACKAGE__->belongs_to( "src_ver", "Debbugs::DB::Result::SrcVer", { id => "src_ver_id" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3K+5M1Rohq6AB4uLnVco+w +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FQGstQI5fa/5pJhSi7AtYg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/Bug.pm b/Debbugs/DB/Result/Bug.pm index 2782522..ab08d49 100644 --- a/Debbugs/DB/Result/Bug.pm +++ b/Debbugs/DB/Result/Bug.pm @@ -301,6 +301,21 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 bug_mergeds_merged + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "bug_mergeds_merged", + "Debbugs::DB::Result::BugMerged", + { "foreign.merged" => "self.id" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + =head2 bug_messages Type: has_many @@ -376,21 +391,6 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); -=head2 bugs_merged_merged - -Type: has_many - -Related object: L - -=cut - -__PACKAGE__->has_many( - "bugs_merged_merged", - "Debbugs::DB::Result::BugMerged", - { "foreign.merged" => "self.id" }, - { cascade_copy => 0, cascade_delete => 0 }, -); - =head2 done Type: belongs_to @@ -404,10 +404,10 @@ __PACKAGE__->belongs_to( "Debbugs::DB::Result::Correspondent", { id => "done" }, { - is_deferrable => 1, + is_deferrable => 0, join_type => "LEFT", - on_delete => "CASCADE", - on_update => "CASCADE", + on_delete => "NO ACTION", + on_update => "NO ACTION", }, ); @@ -424,10 +424,10 @@ __PACKAGE__->belongs_to( "Debbugs::DB::Result::Correspondent", { id => "owner" }, { - is_deferrable => 1, + is_deferrable => 0, join_type => "LEFT", - on_delete => "CASCADE", - on_update => "CASCADE", + on_delete => "NO ACTION", + on_update => "NO ACTION", }, ); @@ -443,7 +443,7 @@ __PACKAGE__->belongs_to( "severity", "Debbugs::DB::Result::Severity", { id => "severity" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); =head2 submitter @@ -459,16 +459,16 @@ __PACKAGE__->belongs_to( "Debbugs::DB::Result::Correspondent", { id => "submitter" }, { - is_deferrable => 1, + is_deferrable => 0, join_type => "LEFT", - on_delete => "CASCADE", - on_update => "CASCADE", + on_delete => "NO ACTION", + on_update => "NO ACTION", }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-04-01 15:59:31 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hRsCzIGJB1krEYpMKmSVYw +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iaePW9PF93j30EB5iY9Bag # You can replace this text with custom code or comments, and it will be preserved on regeneration 1; diff --git a/Debbugs/DB/Result/BugBinpackage.pm b/Debbugs/DB/Result/BugBinpackage.pm index 102feeb..e031b82 100644 --- a/Debbugs/DB/Result/BugBinpackage.pm +++ b/Debbugs/DB/Result/BugBinpackage.pm @@ -116,7 +116,7 @@ __PACKAGE__->belongs_to( "bin_pkg", "Debbugs::DB::Result::BinPkg", { id => "bin_pkg" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); =head2 bug @@ -131,12 +131,12 @@ __PACKAGE__->belongs_to( "bug", "Debbugs::DB::Result::Bug", { id => "bug" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cQ0MmOnrqlxvxubcvh4PBg +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VDOd/VQL46JFDA5cj33bHQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BugBlock.pm b/Debbugs/DB/Result/BugBlock.pm index 273eca0..b175f23 100644 --- a/Debbugs/DB/Result/BugBlock.pm +++ b/Debbugs/DB/Result/BugBlock.pm @@ -116,7 +116,7 @@ __PACKAGE__->belongs_to( "block", "Debbugs::DB::Result::Bug", { id => "blocks" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); =head2 bug @@ -131,12 +131,12 @@ __PACKAGE__->belongs_to( "bug", "Debbugs::DB::Result::Bug", { id => "bug" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QswG/RKpqrXvpj74XiV0WQ +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5IuTgATXoFsL6XBFxDp5wg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BugMerged.pm b/Debbugs/DB/Result/BugMerged.pm index 7e8781d..3243528 100644 --- a/Debbugs/DB/Result/BugMerged.pm +++ b/Debbugs/DB/Result/BugMerged.pm @@ -116,7 +116,7 @@ __PACKAGE__->belongs_to( "bug", "Debbugs::DB::Result::Bug", { id => "bug" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); =head2 merged @@ -131,12 +131,12 @@ __PACKAGE__->belongs_to( "merged", "Debbugs::DB::Result::Bug", { id => "merged" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8wKFwMnVTQBFyOIgB82LSA +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GILRzg9MHEZ4k8h6aJxISA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BugMessage.pm b/Debbugs/DB/Result/BugMessage.pm index 365d275..7870ed5 100644 --- a/Debbugs/DB/Result/BugMessage.pm +++ b/Debbugs/DB/Result/BugMessage.pm @@ -127,7 +127,7 @@ __PACKAGE__->belongs_to( "bug", "Debbugs::DB::Result::Bug", { id => "bug" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 message @@ -142,12 +142,12 @@ __PACKAGE__->belongs_to( "message", "Debbugs::DB::Result::Message", { id => "message" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3UCOADGWEq7+IA7L23sa5A +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mDjAtzaj5diA9b0YFK/7cA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BugPackage.pm b/Debbugs/DB/Result/BugPackage.pm index 2601f95..5ef0b8a 100644 --- a/Debbugs/DB/Result/BugPackage.pm +++ b/Debbugs/DB/Result/BugPackage.pm @@ -69,8 +69,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:593NXq7J5AFjjfFjMLXIvw +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0HCzRExM+h0kYmDmvij1pA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BugSrcpackage.pm b/Debbugs/DB/Result/BugSrcpackage.pm index 736074f..c542b45 100644 --- a/Debbugs/DB/Result/BugSrcpackage.pm +++ b/Debbugs/DB/Result/BugSrcpackage.pm @@ -116,7 +116,7 @@ __PACKAGE__->belongs_to( "bug", "Debbugs::DB::Result::Bug", { id => "bug" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); =head2 src_pkg @@ -131,12 +131,12 @@ __PACKAGE__->belongs_to( "src_pkg", "Debbugs::DB::Result::SrcPkg", { id => "src_pkg" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jirMkEXqyqHGMbRiQ2hObw +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I/9GEPtJDUwfJq0BwrqpMA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BugTag.pm b/Debbugs/DB/Result/BugTag.pm index 81c16ed..1f3d30e 100644 --- a/Debbugs/DB/Result/BugTag.pm +++ b/Debbugs/DB/Result/BugTag.pm @@ -116,7 +116,7 @@ __PACKAGE__->belongs_to( "bug", "Debbugs::DB::Result::Bug", { id => "bug" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); =head2 tag @@ -131,12 +131,12 @@ __PACKAGE__->belongs_to( "tag", "Debbugs::DB::Result::Tag", { id => "tag" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-04-01 15:46:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7cqkTgwzMw4wP3LtAKaBDg +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Cu5Qrkpu/4fEUNUBgUEmWw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/BugVer.pm b/Debbugs/DB/Result/BugVer.pm index d35f3e6..95475f6 100644 --- a/Debbugs/DB/Result/BugVer.pm +++ b/Debbugs/DB/Result/BugVer.pm @@ -156,7 +156,7 @@ __PACKAGE__->belongs_to( "bug", "Debbugs::DB::Result::Bug", { id => "bug" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "RESTRICT", on_update => "CASCADE" }, ); =head2 src_pkg @@ -172,9 +172,9 @@ __PACKAGE__->belongs_to( "Debbugs::DB::Result::SrcPkg", { id => "src_pkg" }, { - is_deferrable => 1, + is_deferrable => 0, join_type => "LEFT", - on_delete => "CASCADE", + on_delete => "SET NULL", on_update => "CASCADE", }, ); @@ -192,16 +192,16 @@ __PACKAGE__->belongs_to( "Debbugs::DB::Result::SrcVer", { id => "src_ver_id" }, { - is_deferrable => 1, + is_deferrable => 0, join_type => "LEFT", - on_delete => "CASCADE", + on_delete => "SET NULL", on_update => "CASCADE", }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/WX1pwdsAUjQK28CwCaDQw +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AlnpfT/8jqREfK5zVfPyPw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/Correspondent.pm b/Debbugs/DB/Result/Correspondent.pm index 24cba22..8646464 100644 --- a/Debbugs/DB/Result/Correspondent.pm +++ b/Debbugs/DB/Result/Correspondent.pm @@ -153,6 +153,21 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 maintainers + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "maintainers", + "Debbugs::DB::Result::Maintainer", + { "foreign.correspondent" => "self.id" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + =head2 message_correspondents Type: has_many @@ -169,8 +184,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PnVRI1FMGlY8Go0XOM3wwA +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Wyisfi/87NgArvWis4/tuw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/CorrespondentFullName.pm b/Debbugs/DB/Result/CorrespondentFullName.pm index 738004b..1d2c668 100644 --- a/Debbugs/DB/Result/CorrespondentFullName.pm +++ b/Debbugs/DB/Result/CorrespondentFullName.pm @@ -118,12 +118,12 @@ __PACKAGE__->belongs_to( "correspondent", "Debbugs::DB::Result::Correspondent", { id => "correspondent" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-04-01 17:05:37 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xGcJNDjhN+ehcFQYzaBxBw +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ePNArKbdUxbj/cw4RbMHgg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/Maintainer.pm b/Debbugs/DB/Result/Maintainer.pm index 53bfc0f..f95ab1b 100644 --- a/Debbugs/DB/Result/Maintainer.pm +++ b/Debbugs/DB/Result/Maintainer.pm @@ -51,6 +51,14 @@ Package maintainer id Name of package maintainer +=head2 correspondent + + data_type: 'integer' + is_foreign_key: 1 + is_nullable: 0 + +Correspondent ID + =head2 created data_type: 'timestamp with time zone' @@ -81,6 +89,8 @@ __PACKAGE__->add_columns( }, "name", { data_type => "text", is_nullable => 0 }, + "correspondent", + { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "created", { data_type => "timestamp with time zone", @@ -125,6 +135,21 @@ __PACKAGE__->add_unique_constraint("maintainer_name_key", ["name"]); =head1 RELATIONS +=head2 correspondent + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "correspondent", + "Debbugs::DB::Result::Correspondent", + { id => "correspondent" }, + { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, +); + =head2 src_vers Type: has_many @@ -141,8 +166,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pjSawHrI2qYqUHgkdxgh8g +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wKZL5dHGvpVvuI9o0mh7fQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/MessageCorrespondent.pm b/Debbugs/DB/Result/MessageCorrespondent.pm index 7792290..0e5840d 100644 --- a/Debbugs/DB/Result/MessageCorrespondent.pm +++ b/Debbugs/DB/Result/MessageCorrespondent.pm @@ -140,7 +140,7 @@ __PACKAGE__->belongs_to( "correspondent", "Debbugs::DB::Result::Correspondent", { id => "correspondent" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 message @@ -155,12 +155,12 @@ __PACKAGE__->belongs_to( "message", "Debbugs::DB::Result::Message", { id => "message" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d2QCcAGqZtl1l7tx1fEwyg +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O+1oiAgBblG5UTsHpF4xRw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/MessageRef.pm b/Debbugs/DB/Result/MessageRef.pm index 9d9d514..b035598 100644 --- a/Debbugs/DB/Result/MessageRef.pm +++ b/Debbugs/DB/Result/MessageRef.pm @@ -136,7 +136,7 @@ __PACKAGE__->belongs_to( "message", "Debbugs::DB::Result::Message", { id => "message" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 ref @@ -151,12 +151,12 @@ __PACKAGE__->belongs_to( "ref", "Debbugs::DB::Result::Message", { id => "refs" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+vwRG2KAV0YTTXZE0Vv21A +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oEOZLlhxLd5tyH5IW5KhTA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/SrcAssociation.pm b/Debbugs/DB/Result/SrcAssociation.pm index fff8c4c..c160ca1 100644 --- a/Debbugs/DB/Result/SrcAssociation.pm +++ b/Debbugs/DB/Result/SrcAssociation.pm @@ -134,7 +134,7 @@ __PACKAGE__->belongs_to( "source", "Debbugs::DB::Result::SrcVer", { id => "source" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 suite @@ -149,12 +149,12 @@ __PACKAGE__->belongs_to( "suite", "Debbugs::DB::Result::Suite", { id => "suite" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7lYnCaf4vZZFcZoz2S7O9A +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:23:58 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3Hl8VlcLTNPdCLO6kMVyxQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/SrcPkg.pm b/Debbugs/DB/Result/SrcPkg.pm index ac28c90..a76b3f5 100644 --- a/Debbugs/DB/Result/SrcPkg.pm +++ b/Debbugs/DB/Result/SrcPkg.pm @@ -124,7 +124,7 @@ __PACKAGE__->belongs_to( "Debbugs::DB::Result::SrcPkg", { id => "alias_of" }, { - is_deferrable => 1, + is_deferrable => 0, join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE", @@ -192,8 +192,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:w1ifDwgGG57aeGxFptavbg +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JYP+MBnjgk3I/XtRNh2UyA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/SrcVer.pm b/Debbugs/DB/Result/SrcVer.pm index cd99a16..f684113 100644 --- a/Debbugs/DB/Result/SrcVer.pm +++ b/Debbugs/DB/Result/SrcVer.pm @@ -154,7 +154,7 @@ __PACKAGE__->belongs_to( "Debbugs::DB::Result::SrcVer", { id => "based_on" }, { - is_deferrable => 1, + is_deferrable => 0, join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE", @@ -204,9 +204,9 @@ __PACKAGE__->belongs_to( "Debbugs::DB::Result::Maintainer", { id => "maintainer_id" }, { - is_deferrable => 1, + is_deferrable => 0, join_type => "LEFT", - on_delete => "CASCADE", + on_delete => "SET NULL", on_update => "CASCADE", }, ); @@ -238,7 +238,7 @@ __PACKAGE__->belongs_to( "src_pkg", "Debbugs::DB::Result::SrcPkg", { id => "src_pkg" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 src_vers @@ -257,8 +257,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-27 18:54:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hhXOPJ8se5BVKMsbvf+szw +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:P1zipd1t+2AOidtCSzyHVw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/Suite.pm b/Debbugs/DB/Result/Suite.pm index 3723aca..2170d6d 100644 --- a/Debbugs/DB/Result/Suite.pm +++ b/Debbugs/DB/Result/Suite.pm @@ -167,8 +167,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-04-01 15:46:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Wp8D70L0WeBbMqWkFEZEyQ +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xIVtTLCQc72u8xQOuwQhrQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Debbugs/DB/Result/Tag.pm b/Debbugs/DB/Result/Tag.pm index 85a2263..3bbcccb 100644 --- a/Debbugs/DB/Result/Tag.pm +++ b/Debbugs/DB/Result/Tag.pm @@ -119,8 +119,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-04-01 15:46:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O+iuATuRz+/8rETu8oYO9Q +# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-10-09 20:27:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5Xx50RAuyQQ3VpS0ypsFEQ # You can replace this text with custom code or comments, and it will be preserved on regeneration -- 2.39.2