fix var typo and add in missing correspondent index

diff --git a/Debbugs/DB/Result/BinVer.pm b/Debbugs/DB/Result/BinVer.pm
index 5c113da0e43387c320e38424037ec0d354027d15..30be6c2411d7827822b700411ad4be0d4cd3dc64 100644 (file)
--- a/Debbugs/DB/Result/BinVer.pm
+++ b/Debbugs/DB/Result/BinVer.pm
@@ -196,7 +196,7 @@ __PACKAGE__->belongs_to(
 
 sub sqlt_deploy_hook {
     my ($self, $sqlt_table) = @_;
-    for my $idx (qw(var bin_pkg src_ver)) {
+    for my $idx (qw(ver bin_pkg src_ver)) {
        $sqlt_table->add_index(name => 'bin_ver_'.$idx.'_id_idx',
                               fields => [$idx]);
     }

diff --git a/Debbugs/DB/Result/BugVer.pm b/Debbugs/DB/Result/BugVer.pm
index f50cf623d2048fe6c090332ee95752ece3e47eac..472a1dffc31eb73a902605a802696e866a873ae9 100644 (file)
--- a/Debbugs/DB/Result/BugVer.pm
+++ b/Debbugs/DB/Result/BugVer.pm
@@ -241,7 +241,7 @@ sub sqlt_deploy_hook {
                               fields => [$idx]);
     }
     $sqlt_table->add_index(name => 'bug_ver_src_pkg_id_src_ver_id_idx',
-                          fields => [qw(src_pkg src_var)],
+                          fields => [qw(src_pkg src_ver)],
                          );
 }
 1;

diff --git a/Debbugs/DB/Result/CorrespondentFullName.pm b/Debbugs/DB/Result/CorrespondentFullName.pm
index c5a28ec5599b2d396fa145fe2128a4910178471c..a5be28391424693094157a86ad4076eb594485d5 100644 (file)
--- a/Debbugs/DB/Result/CorrespondentFullName.pm
+++ b/Debbugs/DB/Result/CorrespondentFullName.pm
@@ -117,8 +117,8 @@ __PACKAGE__->belongs_to(
 
 sub sqlt_deploy_hook {
     my ($self, $sqlt_table) = @_;
-    for my $idx (qw(correspondent message)) {
-       $sqlt_table->add_index(name => 'message_correspondent_idx'.$idx,
+    for my $idx (qw(full_name last_seen)) {
+       $sqlt_table->add_index(name => 'correspondent_full_name_idx_'.$idx,
                               fields => [$idx]);
     }
 }

diff --git a/Debbugs/DB/Result/MessageCorrespondent.pm b/Debbugs/DB/Result/MessageCorrespondent.pm
index 16550aa00b579f31e16145dda4068e9cbcac859a..ddc79d11db3ae7e118c3e4814f460b7d3d863a45 100644 (file)
--- a/Debbugs/DB/Result/MessageCorrespondent.pm
+++ b/Debbugs/DB/Result/MessageCorrespondent.pm
@@ -139,5 +139,12 @@ __PACKAGE__->belongs_to(
 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kIhya7skj4ZNM3DkC+gAPw
 
 
-# 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(correspondent message)) {
+       $sqlt_table->add_index(name => 'message_correspondent_idx'.$idx,
+                              fields => [$idx]);
+    }
+}
+
 1;

diff --git a/sql/PostgreSQL/deploy/6/001-auto.sql b/sql/PostgreSQL/deploy/6/001-auto.sql
index a28dc2a278426b329797454e16af3b4d1a662e50..3b4b1220ddea66db4228e978136e2fe4117b89a0 100644 (file)
--- a/sql/PostgreSQL/deploy/6/001-auto.sql
+++ b/sql/PostgreSQL/deploy/6/001-auto.sql
@@ -1,6 +1,6 @@
 -- 
 -- Created by SQL::Translator::Producer::PostgreSQL
--- Created on Fri Apr 14 20:22:11 2017
+-- Created on Sat Apr 15 20:14:22 2017
 -- 
 ;
 --
@@ -150,8 +150,8 @@ CREATE TABLE "correspondent_full_name" (
   CONSTRAINT "correspondent_full_name_correspondent_full_name_idx" UNIQUE ("correspondent", "full_name")
 );
 CREATE INDEX "correspondent_full_name_idx_correspondent" on "correspondent_full_name" ("correspondent");
-CREATE INDEX "message_correspondent_idxcorrespondent" on "correspondent_full_name" ("correspondent");
-CREATE INDEX "message_correspondent_idxmessage" on "correspondent_full_name" ("message");
+CREATE INDEX "correspondent_full_name_idx_full_name" on "correspondent_full_name" ("full_name");
+CREATE INDEX "correspondent_full_name_idx_last_seen" on "correspondent_full_name" ("last_seen");
 
 ;
 --
@@ -246,6 +246,8 @@ CREATE TABLE "message_correspondent" (
 );
 CREATE INDEX "message_correspondent_idx_correspondent" on "message_correspondent" ("correspondent");
 CREATE INDEX "message_correspondent_idx_message" on "message_correspondent" ("message");
+CREATE INDEX "message_correspondent_idxcorrespondent" on "message_correspondent" ("correspondent");
+CREATE INDEX "message_correspondent_idxmessage" on "message_correspondent" ("message");
 
 ;
 --

diff --git a/sql/PostgreSQL/upgrade/5-6/001-auto.sql b/sql/PostgreSQL/upgrade/5-6/001-auto.sql
index bf02e7ba2594cf45f92943c5229c4738790959dd..0e6fe494433be6ce7966d45d8aef799c0f8a6857 100644 (file)
--- a/sql/PostgreSQL/upgrade/5-6/001-auto.sql
+++ b/sql/PostgreSQL/upgrade/5-6/001-auto.sql
@@ -28,7 +28,10 @@ CREATE INDEX bug_message_idx_bug_message_number on bug_message (bug, message_num
 CREATE INDEX bug_ver_src_pkg_id_src_ver_id_idx on bug_ver (src_pkg, src_ver);
 
 ;
-CREATE INDEX message_correspondent_idxmessage on correspondent_full_name (message);
+CREATE INDEX correspondent_full_name_idx_full_name on correspondent_full_name (full_name);
+
+;
+CREATE INDEX correspondent_full_name_idx_last_seen on correspondent_full_name (last_seen);
 
 ;
 CREATE INDEX message_msgid_idx on message (msgid);

diff --git a/sql/_source/deploy/6/001-auto.yml b/sql/_source/deploy/6/001-auto.yml
index 20528a0197dccd58b97a0f6ef06757c19538f2cf..a480db43e02cbbe8b33e73a0cceb01eefd1e661c 100644 (file)
--- a/sql/_source/deploy/6/001-auto.yml
+++ b/sql/_source/deploy/6/001-auto.yml
@@ -2009,13 +2009,13 @@ schema:
           options: []
           type: NORMAL
         - fields:
-            - correspondent
-          name: message_correspondent_idxcorrespondent
+            - full_name
+          name: correspondent_full_name_idx_full_name
           options: []
           type: NORMAL
         - fields:
-            - message
-          name: message_correspondent_idxmessage
+            - last_seen
+          name: correspondent_full_name_idx_last_seen
           options: []
           type: NORMAL
       name: correspondent_full_name
@@ -2351,6 +2351,16 @@ schema:
           name: message_correspondent_idx_message
           options: []
           type: NORMAL
+        - fields:
+            - correspondent
+          name: message_correspondent_idxcorrespondent
+          options: []
+          type: NORMAL
+        - fields:
+            - message
+          name: message_correspondent_idxmessage
+          options: []
+          type: NORMAL
       name: message_correspondent
       options: []
       order: 16