modify bug_status_type to match what bug_presence returns

[debbugs.git] / Debbugs / DB / Result / BugStatusCache.pm

diff --git a/Debbugs/DB/Result/BugStatusCache.pm b/Debbugs/DB/Result/BugStatusCache.pm
index 3d2dcc9d9a277376529138dfedfcc2fa86e1827d..26b850e721683c7c0381041671d1abd6e0a335d9 100644 (file)
--- a/Debbugs/DB/Result/BugStatusCache.pm
+++ b/Debbugs/DB/Result/BugStatusCache.pm
@@ -64,7 +64,7 @@ Architecture id (matches arch)
 =head2 status
 
   data_type: 'enum'
-  extra: {custom_type_name => "bug_status_type",list => ["pending","forwarded","pending-fixed","fixed","absent","done"]}
+  extra: {custom_type_name => "bug_status_type",list => ["absent","found","fixed","undef"]}
   is_nullable: 0
 
 Status (bug status)
@@ -101,14 +101,7 @@ __PACKAGE__->add_columns(
     data_type => "enum",
     extra => {
       custom_type_name => "bug_status_type",
-      list => [
-        "pending",
-        "forwarded",
-        "pending-fixed",
-        "fixed",
-        "absent",
-        "done",
-      ],
+      list => ["absent", "found", "fixed", "undef"],
     },
     is_nullable => 0,
   },
@@ -207,9 +200,21 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2017-03-04 10:59:03
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dgaCogdpUWo99BQhdH68Mg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2017-08-07 09:58:56
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RNAken/j2+82FVCyCTnvQw
 
+sub sqlt_deploy_hook {
+    my ($self, $sqlt_table) = @_;
+#     $sqlt_table->add_index(name => 'bug_status_cache_bug_suite_arch_idx',
+#                         fields => ['bug',
+#                                    q{COALESCE(suite,0)},
+#                                    q{COALESCE(arch,0)},]
+#                        );
+    for my $f (qw(bug status arch suite asof)) {
+       $sqlt_table->add_index(name => 'bug_status_cache_idx_'.$f,
+                              fields => [$f],
+                             );
+    }
+}
 
-# You can replace this text with custom code or comments, and it will be preserved on regeneration
 1;