From adf6bdf8be8e0b3da649c5ee113ce085e7b46560 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Wed, 11 Apr 2018 13:09:18 -0700 Subject: [PATCH] add unknown_affects to the bug table --- Debbugs/DB.pm | 2 +- Debbugs/DB/Result/Bug.pm | 14 ++++++++++++-- sql/debbugs_schema.sql | 4 +++- 3 files changed, 16 insertions(+), 4 deletions(-) diff --git a/Debbugs/DB.pm b/Debbugs/DB.pm index be8f47af..6941a5f3 100644 --- a/Debbugs/DB.pm +++ b/Debbugs/DB.pm @@ -17,7 +17,7 @@ __PACKAGE__->load_namespaces; # This version must be incremented any time the schema changes so that # DBIx::Class::DeploymentHandler can do its work -our $VERSION=10; +our $VERSION=11; # 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 7c7fb63c..75eec8cd 100644 --- a/Debbugs/DB/Result/Bug.pm +++ b/Debbugs/DB/Result/Bug.pm @@ -173,6 +173,14 @@ Individual who submitted this bug; empty if there is no submitter Package name if the package is not known +=head2 unknown_affects + + data_type: 'text' + default_value: (empty string) + is_nullable: 0 + +Package name if the affected package is not known + =cut __PACKAGE__->add_columns( @@ -227,6 +235,8 @@ __PACKAGE__->add_columns( { data_type => "text", default_value => "", is_nullable => 0 }, "unknown_packages", { data_type => "text", default_value => "", is_nullable => 0 }, + "unknown_affects", + { data_type => "text", default_value => "", is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -514,8 +524,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-09-24 14:51:07 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iaipVETTaokcFNrICfIEAw +# Created by DBIx::Class::Schema::Loader v0.07048 @ 2018-04-11 13:06:55 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qxkLXbv8JGoV9reebbOUEw use Carp; use List::AllUtils qw(uniq); diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql index b20ceb07..c091a6e5 100644 --- a/sql/debbugs_schema.sql +++ b/sql/debbugs_schema.sql @@ -113,7 +113,8 @@ CREATE TABLE bug ( -- submitter would ideally be NOT NULL, but there are some ancient bugs which do not have submitters submitter INT REFERENCES correspondent(id), submitter_full TEXT NOT NULL DEFAULT '', - unknown_packages TEXT NOT NULL DEfAULT '' + unknown_packages TEXT NOT NULL DEFAULT '', + unknown_affects TEXT NOT NULL DEFAULT '' ); CREATE INDEX bug_idx_owner ON bug(owner); CREATE INDEX bug_idx_submitter ON bug(submitter); @@ -139,6 +140,7 @@ INSERT INTO column_comments VALUES ('bug','done','Individual who did the -done; INSERT INTO column_comments VALUES ('bug','owner','Individual who owns this bug; empty if no one owns it'); INSERT INTO column_comments VALUES ('bug','submitter','Individual who submitted this bug; empty if there is no submitter'); INSERT INTO column_comments VALUES ('bug','unknown_packages','Package name if the package is not known'); +INSERT INTO column_comments VALUES ('bug','unknown_affects','Package name if the affected package is not known'); -- 2.39.5