add submitter field to bug table

diff --git a/Debbugs/DB/Load.pm b/Debbugs/DB/Load.pm
index d8685b9d8a29ed1fd06e06a54d53eceae848a0d2..3ff6470586f26b15075e413c1db49177d08591e3 100644 (file)
--- a/Debbugs/DB/Load.pm
+++ b/Debbugs/DB/Load.pm
@@ -118,6 +118,7 @@ sub load_bug {
               subject => $data->{subject} // '',
               done => $data->{done} // '',
               owner => $data->{owner} // '',
+               submitter => $data->{submitter} // '',
               severity => length($data->{severity}) ? $data->{severity} : $config{default_severity},
              };
     $s->resultset('Bug')->update_or_create($bug);

diff --git a/Debbugs/DB/Result/BinaryVersion.pm b/Debbugs/DB/Result/BinaryVersion.pm
index 14814d67e5f1a6da7140afc12d6e7a741d5009c1..6404f2ad22b6d3ceeed6940de962cb77d9b10060 100644 (file)
--- a/Debbugs/DB/Result/BinaryVersion.pm
+++ b/Debbugs/DB/Result/BinaryVersion.pm
@@ -60,6 +60,16 @@ __PACKAGE__->table("binary_versions");
   data_type: 'debversion'
   is_nullable: 1
 
+=head2 src_ver_based_on
+
+  data_type: 'debversion'
+  is_nullable: 1
+
+=head2 src_pkg_based_on
+
+  data_type: 'text'
+  is_nullable: 1
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -73,11 +83,15 @@ __PACKAGE__->add_columns(
   { data_type => "text", is_nullable => 1 },
   "bin_ver",
   { data_type => "debversion", is_nullable => 1 },
+  "src_ver_based_on",
+  { data_type => "debversion", is_nullable => 1 },
+  "src_pkg_based_on",
+  { data_type => "text", is_nullable => 1 },
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2012-11-23 23:44:18
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:04R2st85wn634BqbBU2/qQ
+# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-22 16:20:31
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:77yN9sUsXItcsQ1qJETQaw
 
 
 # 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 51a964d0c43f9af97c1f79655d3f964d06bcb85b..50673120a50fd6c5a20a796424af070bc83b6bcb 100644 (file)
--- a/Debbugs/DB/Result/Bug.pm
+++ b/Debbugs/DB/Result/Bug.pm
@@ -129,7 +129,15 @@ Individual who did the -done; empty if it has never been -done
   default_value: (empty string)
   is_nullable: 0
 
-Individual who did the -done; empty if it has never been -done
+Individual who owns this bug; empty if no one owns it
+
+=head2 submitter
+
+  data_type: 'text'
+  default_value: (empty string)
+  is_nullable: 0
+
+Individual who submitted this bug; empty if there is no submitter
 
 =head2 unknown_packages
 
@@ -190,6 +198,8 @@ __PACKAGE__->add_columns(
   { data_type => "text", default_value => "", is_nullable => 0 },
   "owner",
   { data_type => "text", default_value => "", is_nullable => 0 },
+  "submitter",
+  { data_type => "text", default_value => "", is_nullable => 0 },
   "unknown_packages",
   { data_type => "text", default_value => "", is_nullable => 0 },
   "severity",
@@ -362,8 +372,8 @@ __PACKAGE__->has_many(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2012-11-29 18:11:35
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eW7Cg2dL1CbA9Rn+nzZqOg
+# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-22 16:20:31
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Cvwpg/d7shs9bxFOQZhNVg
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration

diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql
index cf1e950919b4de6f19521a2d731c733ea84a817d..9fc729a93fbabeaf9863b7f54175ee84f7b0eddb 100644 (file)
--- a/sql/debbugs_schema.sql
+++ b/sql/debbugs_schema.sql
@@ -73,6 +73,7 @@ CREATE TABLE bug (
        subject TEXT NOT NULL,
        done TEXT NOT NULL DEFAULT '',
        owner TEXT NOT NULL DEFAULT '',
+       submitter TEXT NOT NULL DEFAULT '',
        unknown_packages TEXT NOT NULL DEfAULT '',
        severity bug_severity DEFAULT 'normal'::bug_severity
 );
@@ -88,7 +89,8 @@ INSERT INTO column_comments VALUES ('bug','summary','Summary of the bug; empty i
 INSERT INTO column_comments VALUES ('bug','outlook','Outlook of the bug; empty if it has no outlook');
 INSERT INTO column_comments VALUES ('bug','subject','Subject of the bug');
 INSERT INTO column_comments VALUES ('bug','done','Individual who did the -done; empty if it has never been -done');
-INSERT INTO column_comments VALUES ('bug','owner','Individual who did the -done; empty if it has never been -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','severity','Bug severity');