Update DB Schema version to 6

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

diff --git a/Debbugs/DB/Result/Message.pm b/Debbugs/DB/Result/Message.pm
index 0ac17aa525472f18669564a10d3c9f228723c7b8..cd42f48efef4bbabd3a8cb46de904e722b01c2f7 100644 (file)
--- a/Debbugs/DB/Result/Message.pm
+++ b/Debbugs/DB/Result/Message.pm
@@ -243,5 +243,13 @@ __PACKAGE__->many_to_many(correspondents => 'message_correspondents','correspond
 __PACKAGE__->many_to_many(references => 'message_refs_message','message');
 __PACKAGE__->many_to_many(referenced_by => 'message_refs_refs','message');
 
-# You can replace this text with custom code or comments, and it will be preserved on regeneration
+
+sub sqlt_deploy_hook {
+    my ($self, $sqlt_table) = @_;
+    for my $idx (qw(msgid subject)) {
+       $sqlt_table->add_index(name => 'message_'.$idx.'_idx',
+                              fields => [$idx]);
+    }
+}
+
 1;